#1  
Old 02-19-2015, 04:26 PM
JYLY's Avatar
JYLY JYLY is offline
Newbie
 
Join Date: Feb 2015
Posts: 34
Niced 5 Times in 3 Posts
Default Finnish putting game

Hello!

I recently made a putting game which was surprisingly well liked in the Finnish disc golf community, so i thought to share it here as well.
Basically it is an excel sheet where you input your results as you throw 100 putts from different distances, 5 discs per round.


Good things about it:

-you can track your putting skill progression as you save your scores
-it is not as monotonous as normal putting practice
-it is suitable for training alone or playing with friends
-you can see your putting percentage from certain distances
-you dont necessarily need a computer when putting, you can use pen & paper or a cell phone to keep score and input the data later.
-if you input your results directly to the excel-sheet, you can see estimates for your score and stats as you go.


The rules are simple although they might first seem complicated:

-Mark distances for 5, 6, 7, 8 ,9 and 10 meters.
-First round is always from 10 meters. Throw 5 discs from there. Depending on how many of them went into the basket (regardless of the distance you threw them from), your tee changes as follows:

0: go to 5 meter tee
1: go to 6 meter tee
2: go to 7 meter tee
3: go to 8 meter tee
4: go to 9 meter tee
5: stay at 10 meter tee

-repeat 20 times.

You get 10 points for every disc you score from 10 meters, 7 points from 7 meters and so on. You really dont have to worry about this or calculate anything, because the chart will know where you are throwing (or SHOULD be throwing) and calculates everything automatically.

After 20 rounds you should have a line of numbers from zero to five. Enter these to "singleplayer" sheets cells B2:B21. After that copy your statistics from cells G2:G21 and paste their VALUES to drillstats sheets C2-cell. Next time to D2 and so on...

If your name is not Paul McBeth, your tee changes continuosly after every 5 discs. Advanced players rarely use the closest tees, but amateurs use at least the 6-10 tees quite evenly.



After few games you get some stats as follows:
-Rows 2-8 show your putting percentage from different distances
-Row 9 is your total points
-Rows 10-15 show how many points per disc you got from different distances.
-Rows 16-21 show how many discs you threw from different distances.
Column A shows you lifetime averages from all of these.

The maximum points you can achieve is 1000 pts. (requires all 100 putts to go in from 10 meters)
The world record at the moment is by our local putting hero Mr Tapani Aulu, 719 points.
Us normal humans get around 500 points and complete noobs about 200 points.

There is also a multiplayer-sheet, which works similarily. If you would like to track statistics for several players, just copy the Drillstats-sheet as many times as necessary.

Download link: http://www.filedropper.com/jyly

Choose the GREY "download this file" button and type the requested letters.

Any feedback or suggestions are much appreciated. Also would be interested to hear what kind of scores you guys are getting.

Game on!
Sponsored Links

Niced: (2)
Reply With Quote
  #2  
Old 02-19-2015, 05:05 PM
onemilemore's Avatar
onemilemore onemilemore is offline
* Ace Member *
 
Join Date: Apr 2011
Location: Golden State
Years Playing: 8.8
Courses Played: 43
Throwing Style: LHBH
Posts: 6,402
Niced 222 Times in 97 Posts
Default

This sounds pretty cool, good way to break up the monotony of putting practice. I'll give it a shot!
Reply With Quote
  #3  
Old 02-19-2015, 05:31 PM
ODRB's Avatar
ODRB ODRB is offline
* Ace Member *
 
Join Date: Apr 2014
Location: Portland, OR
Years Playing: 11.6
Courses Played: 163
Throwing Style: RHBH
Posts: 4,487
Niced 1,181 Times in 582 Posts
Default

Sounds cool. Can't seem to get the scoresheet.
Reply With Quote
  #4  
Old 02-19-2015, 06:21 PM
DougCrawford's Avatar
DougCrawford DougCrawford is offline
Double Eagle Member
 
Join Date: Aug 2014
Location: Concord, NC
Years Playing: 5.5
Courses Played: 54
Throwing Style: RHBH
Posts: 1,101
Niced 15 Times in 12 Posts
Default

I like it. I'll check out the spreadsheet when I get to my computer
Reply With Quote
  #5  
Old 02-19-2015, 06:36 PM
markmcc's Avatar
markmcc markmcc is offline
Eagle Member
 
Join Date: Sep 2012
Location: Wherever the RV is parked
Years Playing: 7.6
Courses Played: 271
Throwing Style: RHBH
Posts: 587
Niced 171 Times in 74 Posts
Default

Sounds interesting. I downloaded the spreadsheet and did a practice run. Works fine.

Thanks!
Reply With Quote
  #6  
Old 02-19-2015, 07:16 PM
ODRB's Avatar
ODRB ODRB is offline
* Ace Member *
 
Join Date: Apr 2014
Location: Portland, OR
Years Playing: 11.6
Courses Played: 163
Throwing Style: RHBH
Posts: 4,487
Niced 1,181 Times in 582 Posts
Default

Anyone know how to make the spreadsheet work on an iphone?
That'd be the bees knees.
Reply With Quote
  #7  
Old 02-19-2015, 07:47 PM
runningDoc's Avatar
runningDoc runningDoc is offline
Double Eagle Member
 
Join Date: May 2014
Years Playing: 5.6
Courses Played: 3
Throwing Style: LHBH
Posts: 1,475
Niced 162 Times in 89 Posts
Default

I'm going to try this out. Anything to break the monotony of putting practice. Thanks!





Also every time I throw my last putt I'm going to yell: "I'm FINNISHED!"






thank thank you... please don't forget to tip the waitresses after the show...

Niced: (2)
Reply With Quote
  #8  
Old 02-19-2015, 07:59 PM
ODRB's Avatar
ODRB ODRB is offline
* Ace Member *
 
Join Date: Apr 2014
Location: Portland, OR
Years Playing: 11.6
Courses Played: 163
Throwing Style: RHBH
Posts: 4,487
Niced 1,181 Times in 582 Posts
Default

^
Reply With Quote
  #9  
Old 02-19-2015, 08:02 PM
ru4por's Avatar
ru4por ru4por is offline
* Ace Member *
 
Join Date: May 2012
Location: Dearborn Michigan
Years Playing: 36.6
Courses Played: 248
Throwing Style: RHBH
Posts: 3,987
Niced 1,740 Times in 757 Posts
Default

Quote:
Originally Posted by davidrboy View Post
Anyone know how to make the spreadsheet work on an iphone?
That'd be the bees knees.
Anyone know how to get a phone to work in -17C degrees. Christ, I don't think a pencil even works in this cold.
Reply With Quote
 

  #10  
Old 02-19-2015, 09:09 PM
onemilemore's Avatar
onemilemore onemilemore is offline
* Ace Member *
 
Join Date: Apr 2011
Location: Golden State
Years Playing: 8.8
Courses Played: 43
Throwing Style: LHBH
Posts: 6,402
Niced 222 Times in 97 Posts
Default

This is money! The way you have this set up, there is no thinking at all, just putting. I love it.

My first score, on the other hand? Not so much. Time to do some work.

Can you make this an app at all? It would awesome to do this from my phone instead of my laptop.
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Finnish putting game spreadsheet Texas2Putts General Disc Golf Chat 4 05-05-2016 12:02 PM
putting game robbnot General Disc Golf Chat 10 07-09-2014 07:34 PM
putting game help Tmac811 General Disc Golf Chat 2 05-17-2011 02:33 PM
Has Anyone Seen My Putting Game? jhgonzo Technique & Strategy 15 09-18-2009 02:21 AM
New Putting Game SomeChump Technique & Strategy 10 06-23-2009 04:25 PM


All times are GMT -4. The time now is 06:28 AM.


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.