Stats Spreadsheet

[Region3]

I've spent a little time this morning going over in my head my round from yesterday, as I do quite often.

This time I got a little carried away and played around in Excel to make a sheet to work everything out for me.

Since I've seen threads before asking about spreadsheets I thought I'd share it in case anyone finds it useful.

https://dl.dropboxusercontent.com/u/97483632/Stats Template.xlsx

The key for entering details is on the left.
Col F is optional, just for information.
E, G, and hc in F4 are only needed if you want your points worked out.

I don't use dropbox very often, but I guess if you want to use it you'll have to save it locally to your own machine.

I'm hoping it's self explanatory but here's the one I filled in as an example if anyone needs it.

https://dl.dropboxusercontent.com/u/97483632/Stats Example.xlsx

Any questions (about the sheet, not my need for a life), fire away.

 

[Neilds]

Interesting that you only hit 3 fairways, I guess your misses were only in the first cut and not trees/long stuff?

 

[ScienceBoy]

To clean up and speed up entry try creating a user form.

I would always be wary about letting sheets loose on others without locking (no password) them up a little and standardising entry.

Not so much to stop them changing it to suit them but to stop them breaking it and bothering me for a fix.

 

[Region3]

Interesting that you only hit 3 fairways, I guess your misses were only in the first cut and not trees/long stuff?

Not really no, I had a wild night off the tee, especially the back 9.
The 5 x's in the GIR column means that 5 times I was either chipping sideways or lost a ball. Either way it means zero chance of hitting GIR.

The ones marked L and R aren't so bad, as I still had a legitimate chance of hitting the green.

 

[Region3]

To clean up and speed up entry try creating a user form.

I would always be wary about letting sheets loose on others without locking (no password) them up a little and standardising entry.

Not so much to stop them changing it to suit them but to stop them breaking it and bothering me for a fix.

If my 'brief' was to create something for others to use then I agree, in fact I'd probably write it in .NET, but it was just me looking at my round last night and it got out of hand.

The cells containing formulae are locked (or at least I thought they were), but if anyone breaks it they can download the template again

 

[Deleted Member 1156]

Cheers Gary, I'm not big on recording stats but this one looks quick and simple to use so I might give it a go.

 

[Region3]

Cheers Gary, I'm not big on recording stats but this one looks quick and simple to use so I might give it a go.

It's not as simple as it could have been, but it's quite easy once you get used to it.

I think the worst thing (hindsight etc) is that the L and R's are capitals, and the x's are lowercase.
I've not tested it but I'm guessing it will matter.

 

[spongebob59]

That look pretty good compared to the stake of old score cards I've got in the drawer !
How do I get a write version for this.

Do you think the swindle tomorrow will mind me taking my tablet round with me

 

[spongebob59]

These are the stats my coach has me record :

One thing that will help us both is keeping a track of your statistics, this is easily done! Please see below;

Fairways
- give yourself a tick for hitting a fairway, and a cross for missing
it. If you miss indicate which side you missed the fairway, left or
right.

Greens - give yourself a tick for hitting a green and a
cross for missing it. If you miss indicate which side you missed the
green, left or right as well as long or short.

Chipping - if you miss the green mark down yes or no for an 'up n down'

Putting
- work out your 'average length' putt. This is done by seeing how far
you have for your first putt, let's say it's 18ft, you miss that putt
and have 2ft left and then hole it ... That's a total of 20ft for that
hole. Do this 18 times and you will get a figure around 450-550, then
divide it by 18 and you will get your average length putt. A tour pro
will be around 12-15ft!! This stat is great because it's not working out
how good your putting is but your proximity to the hole from the 2nd
shot.

 

[ScienceBoy]

I'd probably write it in .NET

Wimp, better to write it in Python simulating Fortran on punch cards...

 

[Region3]

How do I get a write version for this.

Not sure what you mean by this. You can record your own rounds on the sheet in the link, the only thing that's locked are the cells with formula in.

If you want to amend those, just unprotect the sheet, there's no password for it.

 

[Region3]

Wimp, better to write it in Python simulating Fortran on punch cards...

My first experience of programming was on a terminal that spat your code out punched on what looked like those tickets you win on the arcade machines on the sea front, where you need 1000 tickets for a mug.

 

[spongebob59]

Doh, when I opened it , it said read only so I thought it was locked.
Where's my dunces cap 🎅😏

 

[Region3]

Doh, when I opened it , it said read only so I thought it was locked.
Where's my dunces cap 🎅😏

Not a problem. Worst case you just "save as" but it opened fine on my PC - maybe because it was created on my PC.

I've just tried using capital X's and it still works, which surprises me but makes me happy