Jump to content
Sign in to follow this  
triguy67

tracking spreadsheet

Note: This thread is 1077 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!

33 posts / 15509 viewsLast Reply

Recommended Posts

14 hours ago, triguy67 said:

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

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

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

3 hours ago, triguy67 said:

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

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.

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

2 hours ago, triguy67 said:

It looks awesome

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

How many players should I create for data?

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

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.    

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

1 hour ago, Club Rat said:

Did you create your own? 

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.   

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

15 minutes ago, 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.   

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?

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

6 hours ago, 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?

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

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

5 minutes ago, dennyjones said:

Screen shot.

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.

 

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

On April 19, 2017 at 9:00 PM, Club Rat said:

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

How many players should I create for data?

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

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

 thanks

 

Share this post


Link to post
Share on other sites

15 hours ago, triguy67 said:

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

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.  ;-)

Share this post


Link to post
Share on other sites
Awards, Achievements, and Accolades

Note: This thread is 1077 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!

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  



×
×
  • 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.

The popup will be closed in 10 seconds...