Jump to content
IGNORED

tracking spreadsheet


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

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

  • Upvote 1

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

Link to comment
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.

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

Link to comment
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?

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

Link to comment
Share on other sites

Awards, Achievements, and Accolades

  • 2 weeks later...

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

Link to comment
Share on other sites

Awards, Achievements, and Accolades

26 minutes ago, dennyjones said:

but still a tracking spreadsheet....

Did you create your own? 

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

Link to comment
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.   

From the land of perpetual cloudiness.   I'm Denny

Link to comment
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?

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

Link to comment
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

From the land of perpetual cloudiness.   I'm Denny

Link to comment
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.

 

  • Upvote 1

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

Link to comment
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

 

Link to comment
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.  ;-)

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

Link to comment
Share on other sites

Awards, Achievements, and Accolades

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

Link to comment
Share on other sites

Awards, Achievements, and Accolades

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


  • Want to join this community?

    We'd love to have you!

    Sign Up
  • TST Partners

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

    Coupon Codes (save 10-15%): "IACAS" for Mevo/Stack, "IACASPLUS" for Mevo+/Pro Package, and "THESANDTRAP" for ShotScope.
  • Posts

    • Sad tale.  Both the A's and Raiders.  IMO, cities shouldn't be building stadiums for MLB/NFL teams.  But that's the world we live in.   DAY 3:  30-min range session with irons and wedges.  Working on follow thru -- no hooks! 🙂
    • Backswing: Body is responsible for taking the club around. Arms are responsible for making the club go up.  Downswing: The process is reversed. Weight Forward So, your arms need to do stuff. Set up to the ball. Do not raise your arms at all. Rotate your body as you would in the swing. You will notice your hands stay down near your right hip. So, how does the club get up? Your arms raise it up. You can't take your arms out of the swing. What you are describing might be more of a feel, but it also might not be correct.
    • It depends on what you mean by "while the core remains still" I wouldn't consider his core "remaining still" here, DJ's abs, belly button, and belt buckle have rotated almost 90 degrees by the top of the backswing. Those components of his core then have to rotate/uncoil on the downswing. Far from remaining still IMO.
    • It’s going to change but your basic setup feel should be about the same. Your body kind of adjusts to length and lie angle of the club. You’ll want to pay attention more to ball position as you change clubs more than how bent over you are. I understood what you meant from what your wrote.
    • Oh I probably was thinking the wrong thing or the wrong way when I typed the golf swing was more of a body swing (in my mind).  The in my mind part probably should have said in my opinion or based on what I have read.  Just meant the body needs to be involved more than the hands and swinging the arms while the core remains still.
×
×
  • 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...