Disc Golf Course Review Finnish putting game
 Register Members List Social Groups - View All Groups - Your Group Messages Search Today's Posts Mark Forums Read

#1
02-19-2015, 03:26 PM
 JYLY Newbie Join Date: Feb 2015 Posts: 34 Niced 5 Times in 3 Posts
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.

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

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!

 Niced: (2)
#2
02-19-2015, 04:05 PM
 onemilemore * Ace Member * Join Date: Apr 2011 Location: Golden State Years Playing: 10.2 Courses Played: 43 Throwing Style: LHBH Posts: 6,402 Niced 223 Times in 98 Posts

This sounds pretty cool, good way to break up the monotony of putting practice. I'll give it a shot!
#3
02-19-2015, 04:31 PM
 ODRB * Ace Member * Join Date: Apr 2014 Location: Portland, OR Years Playing: 13.1 Courses Played: 167 Throwing Style: RHBH Posts: 4,846 Niced 1,257 Times in 626 Posts

Sounds cool. Can't seem to get the scoresheet.
#4
02-19-2015, 05:21 PM
 DougCrawford Double Eagle Member Join Date: Aug 2014 Location: Concord, NC Years Playing: 7 Courses Played: 55 Throwing Style: RHBH Posts: 1,101 Niced 15 Times in 12 Posts

I like it. I'll check out the spreadsheet when I get to my computer
#5
02-19-2015, 05:36 PM
 markmcc Eagle Member Join Date: Sep 2012 Location: Wherever the RV is parked Years Playing: 9.1 Courses Played: 272 Throwing Style: RHBH Posts: 606 Niced 220 Times in 89 Posts

Thanks!
#6
02-19-2015, 06:16 PM
 ODRB * Ace Member * Join Date: Apr 2014 Location: Portland, OR Years Playing: 13.1 Courses Played: 167 Throwing Style: RHBH Posts: 4,846 Niced 1,257 Times in 626 Posts

Anyone know how to make the spreadsheet work on an iphone?
That'd be the bees knees.
#7
02-19-2015, 06:47 PM
 runningDoc Double Eagle Member Join Date: May 2014 Years Playing: 7.1 Courses Played: 3 Throwing Style: LHBH Posts: 1,498 Niced 184 Times in 99 Posts

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)
#8
02-19-2015, 06:59 PM
 ODRB * Ace Member * Join Date: Apr 2014 Location: Portland, OR Years Playing: 13.1 Courses Played: 167 Throwing Style: RHBH Posts: 4,846 Niced 1,257 Times in 626 Posts

^
#9
02-19-2015, 07:02 PM
 ru4por * Ace Member * Join Date: May 2012 Location: Dearborn Michigan Years Playing: 38 Courses Played: 252 Throwing Style: RHBH Posts: 5,419 Niced 6,183 Times in 2,132 Posts

Quote:
 Originally Posted by davidrboy 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.

#10
02-19-2015, 08:09 PM
 onemilemore * Ace Member * Join Date: Apr 2011 Location: Golden State Years Playing: 10.2 Courses Played: 43 Throwing Style: LHBH Posts: 6,402 Niced 223 Times in 98 Posts

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.