Jump to content
Sign in to follow this  
triguy67

tracking spreadsheet

Note: This thread is 1027 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 / 14867 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

Register for free today and you won't see this ad spot again!

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 1027 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  



  • Want to join this community?

    We'd love to have you!

    Sign Up
  • 2020 TST Partners

    PING Golf
    FlightScope Mevo
  • Posts

    • YOU GOT YOUR ****ING ANSWER IN THE FIRST RESPONSE!!!
    • Here's a couple of examples. The first is Dustin Johnson's caddie, who just happens to be his Brother. I've heard on the golf telecasts that he has higher clubhead speed with the Driver than DJ! But, who knows where it goes? So DJ plays and his Bro caddies. The other example is me. A few years ago, we were playing a local upscale, daily fee course. The hole was a 399 yard par 4. We were still playing the white tees, even though I had lost a bit of speed. If I could pump a drive out there 230, I was good! My buddy was still fooling himself, thinking he was hitting it 260-270. He hit his usual drive, and somehow, I really blasted one!  Before we left the tee I asked my buddy how long he thought he hit that drive. He said 250-260. We get to his ball and he has 179 in, meaning he hit that drive 220! This is verified by GPS btw. I pointed it out to him and he got pissed! Meanwhile I can see my ball much further down the fairway. When we drove up to it the GPS read 100 yards. Meaning I had hit that drive 299 yards, at 63 years of age!  This is the greatest example of an "outlier" that I can imagine! Somehow, by accident, I had done everything perfectly and really launched one! Hadn't happened for years before that, and hasn't happened since! But it illustrates that it CAN happen.
    • Thanks, just one of those things thats a bit annoying. One shows up and my wife and myself quizzing each other “ did you pay it?”
    • It's very simple - if you intend to change the playing characteristics of your golf ball by artificially heating or cooling it, you are breaking the rules. Every single one of your contrived circumstances can be covered and answered by this very plain and common sense explanation.    You cannot wash your ball in warm water if you're doing so to intentionally make the ball go further. You can wash your ball in warm water if you're a normal person doing it because it gets dirt off the ball better. You cannot place your golf balls in a special insulated black sack designed to act like a sauna to heat the balls up. You can place your golf balls in a black sack if it just happens to be what you store your golf balls in.    Golf is a game of honor and intent, and this is no different than the dozens of other rules regarding activities prohibited only if the player intended to gain an advantage. It makes the judgement of the rule very simple for honest golfers, and more difficult for those intent on toeing the line as close as possible so that they can gain an advantage so small as to be nearly unmeasurable. I know which type of golfer I am, and I also know which type of golfer I'd rather play with in a tournament.
    • That makes sense for you guys. Me? I'm a 13.8. So, a 25% reduction is 3.45 strokes! I'd take that in a heartbeat. 
  • TST Blog Entries

  • Blog Entries

  • Today's Birthdays

    1. Dray574
      Dray574
      (45 years old)
    2. henry granic
      henry granic
      (64 years old)
    3. Jscrillah
      Jscrillah
      (48 years old)

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