Jump to content
Subscribe to the Spin Axis Podcast! ×
Subscribe to the Spin Axis Podcast!
IGNORED

tracking spreadsheet

triguy67
 Share
Note: This thread is 3053 days old. We appreciate that you found this thread instead of starting a new one, but if you plan to post here please make sure it's still relevant. If not, please start a new topic. Thank you!

Recommended Posts

Club Rat Super Member

Club Rat

Posted
Posted
  On 4/11/2017 at 2:21 AM, triguy67 said:

I'm still working out the bugs but here is the spreadsheet I made to track practice tests over time.

Expand  

I did a brief mockup to review and found a few items which you need to correct.
I highlighted the cells with yellow, the one selected is just a typo error, the others
you omitted a row for the equation.

I have to run, playing golf in an hour, I'll send you some suggestions and thoughts later.
It looks effective and simply for the juniors, good job.

I can show you how to upload this to Google Sheets and create a sheet the kids can enter data on their phones
rather than print a paper, which then would reflect to the results sheet for all and any players, if your interested.

G_Stats.PNG

  • Upvote 1

Johnny Rocket - Let's Rock and Roll and play some golf !!!

Awards, Achievements, and Accolades
1
1
1
1
1
1
1
1

Club Rat Super Member

Club Rat

Posted
Posted
  On 4/11/2017 at 11:22 PM, triguy67 said:

I do like the idea of putting things in on a smartphone.

Expand  

Next week I'll build score entry sheets and send a PM to you.
Everything will be on Google Sheets which allows multiple users (your juniors) to have their own data
that will link to a Master sheet for all to use and view.

Johnny Rocket - Let's Rock and Roll and play some golf !!!

Awards, Achievements, and Accolades
1
1
1
1
1
1
1
1

Club Rat Super Member

Club Rat

Posted
Posted
  On 4/19/2017 at 11:27 PM, triguy67 said:

It looks awesome

Expand  

I'll proceed with the Master in a few days. One question?

How many players should I create for data?

Johnny Rocket - Let's Rock and Roll and play some golf !!!

Awards, Achievements, and Accolades
1
1
1
1
1
1
1
1

  • 2 weeks later...
dennyjones Incredible Member

dennyjones

Posted
Posted

Slightly off topic but still a tracking spreadsheet....

Since I've joined a course I've decided to track my game per hole.    I already track the usual, birdie, par, bogie, doubles...score on par 3, 4, 5...Fairways hit, left, right....GIR.   What is enlightening is to see the breakdown per hole.   I believe it will help me learn the course better and avoid costly mistakes.    

From the land of perpetual cloudiness.   I'm Denny

Awards, Achievements, and Accolades
1
1
1
1
1

dennyjones Incredible Member

dennyjones

Posted
Posted
  On 4/28/2017 at 12:03 PM, Club Rat said:

Did you create your own? 

Expand  

yes...nothing special but I have a worksheet for overall stats and a worksheet for individual holes.   I've created averages per hole, putts per hole, GIR per hole and FIR per hole plus the usual other stats.   I've color coded good vs. not so good and hope to see more green than red.  

It is specific for my home course.  

It is nice to see that I've hit the fairway on the #7 100% but holes 3 and 4 only 20% of the time.  Hole #3 is my nemesis.  I score worse vs par on that hole than any other.   I putt worse on #7 than any other hole. On #12 I'm 100%  GIR but I have two holes this year that an 0% GIR.   Data like this excites me.   

From the land of perpetual cloudiness.   I'm Denny

Awards, Achievements, and Accolades
1
1
1
1
1

Club Rat Super Member

Club Rat

Posted
Posted
  On 4/28/2017 at 1:58 PM, dennyjones said:

yes...nothing special but I have a worksheet for overall stats and a worksheet for individual holes.   I've created averages per hole, putts per hole, GIR per hole and FIR per hole plus the usual other stats.   I've color coded good vs. not so good and hope to see more green than red.  

It is specific for my home course.  

It is nice to see that I've hit the fairway on the #7 100% but holes 3 and 4 only 20% of the time.  Hole #3 is my nemesis.  I score worse vs par on that hole than any other.   I putt worse on #7 than any other hole. On #12 I'm 100%  GIR but I have two holes this year that an 0% GIR.   Data like this excites me.   

Expand  

Our third hole is also tough, #1 handicap and our #7 is the easiest.
How many rounds have you recorded?
What do you use as the bench mark for green and red?

Johnny Rocket - Let's Rock and Roll and play some golf !!!

Awards, Achievements, and Accolades
1
1
1
1
1
1
1
1

dennyjones Incredible Member

dennyjones

Posted
Posted (edited)
  On 4/28/2017 at 2:23 PM, Club Rat said:

Our third hole is also tough, #1 handicap and our #7 is the easiest.
How many rounds have you recorded?
What do you use as the bench mark for green and red?

Expand  

I started fresh this year and have 5 rounds at Copper Ridge.   I've played 9 times already but I don't log them into this spreadsheet.   

I'm a bogie golfer.  My best this year is 84 and my worst a couple days ago in 40 mph winds was 94.   My targets are bogie or better for score,  7 of 14 fairways, 2 or less putts, and 33 or less total putts.    

Screen shot.

 

Screenshot 2017-04-28 16.58.40.png

Edited by dennyjones

From the land of perpetual cloudiness.   I'm Denny

Awards, Achievements, and Accolades
1
1
1
1
1

Club Rat Super Member

Club Rat

Posted
Posted
  On 4/28/2017 at 9:00 PM, dennyjones said:

Screen shot.

Expand  

Looking good, do your need a formula to calculate the handicap?
I have it if you need one.

I like your presentation, simple, and colorful and effective.
Most people do not tidy things up as nicely as you have.

 

  • Upvote 1

Johnny Rocket - Let's Rock and Roll and play some golf !!!

Awards, Achievements, and Accolades
1
1
1
1
1
1
1
1

triguy67 Member

triguy67

Posted
  • Author
Posted
  On 4/20/2017 at 2:00 AM, Club Rat said:

I'll proceed with the Master in a few days. One question?

How many players should I create for data?

Expand  

I am so sorry, I missed this.  Work has been insane.  

4 of us. Me my son and two of his buddies.

 thanks

 


Club Rat Super Member

Club Rat

Posted
Posted
  On 4/29/2017 at 12:31 AM, triguy67 said:

4 of us. Me my son and two of his buddies.

Expand  

OK, I will build it in a few days and send you a PM when I have it ready.
I'll set up 6 players so you will be able to see the means to add others in the future.  ;-)

Johnny Rocket - Let's Rock and Roll and play some golf !!!

Awards, Achievements, and Accolades
1
1
1
1
1
1
1
1

Club Rat Super Member

Club Rat

Posted
Posted

Base for Master is setup - the highlighted cells will indicate the best results in all categories and each week as data is entered.

Tracking 1.PNG

Johnny Rocket - Let's Rock and Roll and play some golf !!!

Awards, Achievements, and Accolades
1
1
1
1
1
1
1
1

Note: This thread is 3053 days old. We appreciate that you found this thread instead of starting a new one, but if you plan to post here please make sure it's still relevant. If not, please start a new topic. Thank you!

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Want to join this community?

    We'd love to have you!

    Sign Up

  • TST Partners

    PlayBetter
    TourStriker
    Golfer's Journal
    ShotScope
    The Stack System
    FitForGolf
    FlightScope Mevo
    Direct: Mevo, Mevo+, and Pro Package.

    Coupon Codes (save 10-20%): "IACAS" for Mevo/Stack/FitForGolf, "IACASPLUS" for Mevo+/Pro Package, and "THESANDTRAP" for ShotScope. 15% off TourStriker (no code).

  • Posts

    • 5amZ
      "5 Minutes Daily" Practice Challenge

      By 5amZ · Posted

      Day 24 9-7 Worked on lower body movement with full swing. Focused on hips. Need to work on setup a bit. Was hoping to get to the short game area today, stayed home and recorded some swings instead. I've come to the conclusion I learn the most with my practice setup at home, just a net and a hitting strip. Overall happy with the progress this week. 
    • Shindig
      "5 Minutes Daily" Practice Challenge

      By Shindig · Posted

      Day 2 (September 7), still with the grip and the medicine ball (using weights).   Still on vacation and really aching to be able to do a full practice the way I'd be able to at home.  Also bought a 1/2" section of pipe today at the hardware store and have been regularly practicing the grip with that too while watching Sunday football with the family.  
    • wetzel1592
      "5 Minutes Daily" Practice Challenge

      By wetzel1592 · Posted

      Day 1: Worked on feels for wedge swings. Primarily getting everything to move from the top of the backswing in the correct sequence. 
    • WillieT
      "5 Minutes Daily" Practice Challenge

      By WillieT · Posted

      Day 6 (7 Sep 25) - Afternoon pitch session with the 54 and 58 in the backyard. Keys: Alignment - Setup - Smooth swing thru - working on each to be as “automatic” as possible - not mindless, but deliberately repeatable. I have found the precision required to properly execute carries well into the full swings.  
    • iacas
      My Swing (saevel25)

      By iacas · Posted

      180% is the threshold. But yeah, many of them are close to 200%. Not 120 and 123%. People generate speed differently. I think your speed will come more easily when this stuff gets sorted out. Stay disciplined. Stay on the road. You can't get off exit 74 before you hit exit 32.
×
×
  • Create New...

Important Information

Welcome to TST! Signing up is free, and you'll see fewer ads and can talk with fellow golf enthusiasts! By using TST, you agree to our Terms of Use, our Privacy Policy, and our Guidelines.

  I accept

Join us here in The Sand Trap!

Registration is free and takes almost no time. You'll see one fewer ad per page and be ready to jump in and contribute your thoughts to any subject!

Click here to register (registration will open in a new page so you can continue to read what you came to read).

The popup will be closed in 10 seconds...