Once I read a formula for a combined score using the number of throws and the time elapsed from the first release to the last hole-out.

Anybody know what it is, or have an idea on how to create the formula?

Scored 25 from the red tees using only the putter in 15 minutes and 20 seconds on the way home from work. The wife looked perplexed when I came in the door kind of sweaty saying "I had a quickie on the way home". :D

I think I've seen it where each throw was multiplied by 10 seconds and added to the time to play the course to get a Net Time score.

I do Speed scores as "Speed Score = Throws + Time". Convert the seconds to a decimal to get time in a decimal format. With this formula 1 minute = 1 throw.

Here are the records in the Triangle area of NC:

<table border="1"><tr><td>Date</td><td>Name</td><td>Course</td><td>Tees</td><td>Throws</td><td>Time</td><td>Score
</td></tr><tr><td>12/25/03</td><td>Dave McQuay</td><td>Cornwallis</td><td>Reg</td><td>43</td><td>11:30</td><td>54.5
</td></tr><tr><td>2/7/04</td><td>Robbie Dunn</td><td>Cornwallis</td><td>Reg</td><td>44</td><td>12:37</td><td>56.6
</td></tr><tr><td>5/16/03</td><td>Dave McQuay</td><td>Cornwallis</td><td>Reg</td><td>46</td><td>11:48</td><td>57.8
</td></tr><tr><td>5/3/03</td><td>Brett Bowers</td><td>Cornwallis</td><td>Reg</td><td>48</td><td>12:06</td><td>60.1
</td></tr><tr><td>4/29/03</td><td>Lowe Bibby</td><td>Kentwood</td><td>Reg</td><td>46</td><td>15:56</td><td>61.9
</td></tr><tr><td>11/5/03</td><td>Dave McQuay</td><td>Valley Springs</td><td>White</td><td>47</td><td>15:20</td><td>62.3
</td></tr><tr><td>1/12/04</td><td>Dave McQuay</td><td>Kentwood</td><td>Reg</td><td>48</td><td>14:26</td><td>62.4
</td></tr><tr><td>10/21/03</td><td>Dave McQuay</td><td>UNC</td><td>White</td><td>47</td><td>17:58</td><td>65.0
</td></tr><tr><td>7/4/04</td><td>Dave McQuay</td><td>Zebulon</td><td>Reg</td><td>54</td><td>20:19</td><td>74.3
</td></tr><tr><td>1/30/06</td><td>Drew Pasteur</td><td>Buckhorn</td><td>White</td><td>53</td><td>27:18</td><td>80.3
</td></tr><tr><td> </tr></td></table>

Check out these threads:

Speed Disc Golf (http://www.pdga.com/msgboard/showflat.php?Cat=&Number=35390&page=&view=&sb=5&o=&fpart=1&vc=1)

Speed Records (http://www.pdga.com/msgboard/showflat.php?Cat=&Board=Courses&Number=4589&fpart=1&PHPSESSID=)

sounds like fun. What do you do as far as multiple groups? i.e. so one doesn't hold up the other? And casual players on the course? Just curious.

Thanks for posting the replies and finding the other older threads.

New problem. In Excel I want to enter the score in column A1, the elapsed time in B1, and have the net time score in C1.

By looking at examples in doing math with time in Excel, I've got variations of setting the cells to [h]:mm, so the time calculations are in hours and minutes. Looks the same so this should be ok, but might be unnecessary. Also learned a way to convert decimal time into hh:mm format (=SUM(MID(I7,{1,3},2)/{24,1440})). My automated formula works if the score ends in 0 or 5. Otherwise it's off by 2 seconds for each stroke. :confused:

Any Excel experts out there that would be interested in sending a spreadsheet to [email protected]?

What do you do as far as multiple groups?



Here's an idea: a relay! See how fast your group can get the disc around the course with the players throwing in order. With a four person team the person who throws the first tee shot also throws the fifth shot (after the second, third and fourth players have thrown).

Rather than mess with it, I would just do it by "brute force" and put minutes in column B and seconds in Column C using the default format and not time. It also saves time typing in the numbers. You can certainly put headings on the columns. Total in column D for the first row of data is A2+B2+(C2/60)=D2

That results in 40.33, expecting 19:36.
A2 is the number of throws, 25
B2 is the number of minutes, 15
C2 is the number of seconds, 20

I'm using the "add 10 seconds per throw to the time" method to come up with the net time score.

Ah, I thought you were doing it like Lowe's table up a few posts.
Total minutes = D2=B2+TRUNC(A2/6)
Total Seconds = E2=C2+(10*MOD(A2,6))

Doesn't that miss some minutes when the seconds add up to more than a minute ?

Try it with 15:45 and score of 26
it shows 19 mins and 65 seconds.

This comes up with 20 and 05
minutes = D2 = TRUNC((A2*10+B2*60+C1)/60)
seconds = E2 = MOD((A2*10+B2*60+C1),60)

Yep. Didn't test it. Just gave the idea. Thanks.

Check out these threads:

Speed Disc Golf (http://www.pdga.com/msgboard/showflat.php?Cat=&Number=35390&page=&view=&sb=5&o=&fpart=1&vc=1)

Speed Records (http://www.pdga.com/msgboard/showflat.php?Cat=&Board=Courses&Number=4589&fpart=1&PHPSESSID=)



Cool !!!!

Getting closer.

With 25 throws [cell A1]
In 15 elapsed minutes [cell B1]
and 20 elapsed seconds [cell C1]
The score minutes calculates to 19 [cell D1 is what's between the quotes "=TRUNC((A1*10+B1*60+C1)/60)"]
The score seconds calculates to 30 [cell E1 is what's between the quotes "=MOD((A1*10+B1*60+C1),60)"]

Using a hand held calculator I get 19:37, the spreadsheet has 19:30. Is it possible for the spreadsheet to have 37 for the seconds too?

Yes, I have software tester gene.

Using a hand held calculator I get 19:37, the spreadsheet has 19:30. Is it possible for the spreadsheet to have 37 for the seconds too?



Not unless we can figure out where the calculator is introducing the error.

Because the strokes count in multiples of 10 seconds, there can be no change to the singles digit from the original elapsed time. Increasing from 0 (20 secs) to 7 (37 secs) can not be corrrect.

As I understand it, your score is elapsed time + 10 seconds per throw.

The elapsed time is 15 minutes and 20 seconds and it took 25 throws to complete the course.

calculating in seconds, we have (15*60) + 20 + (25*10)
or 900 + 20 + 250 = 1170 seconds
1170/60 = 19.5
19.5 - 19 = .5 * 60 = 30
19 minutes and 30 seconds.

Now for something more interesting.
19 minutes 59 secs and 36 throws.
1140 + 59 + 360 = 1259
1559/60 = 25.9833
(25.9833 - 25) * 60 = 58.998

Using this method leaves you with the possibility of a rounding error. Using the Modulo formula removes that problem.

Yall are making this far too complicated.
Enter the time as hh:mm:ss in A1, Enter the score in B1
Then
C1=+A1+B1/(24*60*60)*10

Under Format/Cells there is a custom category and you can pick the type h:mm:ss for The A and C columns.

One thing to remember is that Lowe's method gives a high weight to the score, therefore a player has no reason to push the envelope, i.e. play faster. By making each stroke one minute you are essentially eliminating any advantage a good runner might have over other players. That is fine except you are playing speed golf. If you just want to play golf, play golf. I recommend something closer to what Chuck recommended, 10 to 20 seconds. This makes the player focus more on speed to win. It means that the player has to push the envelope on their shot and shot selection and it makes for a more exciting round.

Last point. The rounds I play are on a 9000 foot course, times are closer to 30 minutes the beauty of this is that a stamina begins to play a major role.

I ran an event like this last year. The method is risky but will work.

First, it's based on the honor system. Second, I placed a score card on each Tee sign. You play the hole and write your score on the Tee sign for the next hole. You record your score for 18 at the finish line.

I sent people off in 3 to 5 minute intervals. Remember, that 3 minutes in a race is a life time. If the person behind you catches you, you're pretty much out of the race.

Third, I set up a rules structure that gives the advantage to the behind player. That is because if that person catches you, you're probably out of the race, I defer to the faster player. Essentially, the behind player get's to play through.

I realize there is some room for cheating, but you can mitigate it by setting your course up where a couple of Marshals can see the whole thing.

If you want I can post the rules structure I set up for my event.

Not unless we can figure out where the calculator is introducing the error.



It's a TI. /msgboard/images/graemlins/smirk.gif

throws * seconds per throw / 60 (to calculate minutes)

or

(25 * 10)/60 = 4.17 (aka 4:17)

Add 4:17 to the elapsed time of 15:20 for a total of 19:37. Is there an error in my assumption of 4.17 to 4:17?

Add 4:17 to the elapsed time of 15:20 for a total of 19:37. Is there an error in my assumption of 4.17 to 4:17?



Only if there aren't 100 seconds in a minute.

Many calculators have a button to convert to degrees minutes seconds. You may want to use it.

The problem is that you are dealing with seconds in two different formats.

The minutes are simple. (15*60)= 900
The seconds are simple. 20 = 20
The stroke/seconds are simple at 25*10 = 2500

The problem you are seeing comes from converting the stroke/seconds to decimal and then adding them to seconds (20) that are still in mm:ss format. If you convert the 20 seconds to decimal first, (20/60 = .33333) then when adding it all together 15.3333 + 4.1667 you will get 19.5 minutes

How To Create A Log For Speed Disc Golf

These instructions can be used to create a Net Time Score log in a spreadsheet. The steps describe the process using Excel 2004 for Mac v11.3.

1. select cell A1, then Format > Cells > Number > Custom > [h]mm:ss
2. select cell C1, then Format > Cells > Number > Custom > [h]mm:ss
3. select cell C1, then Insert > Function
4. Type =SUM(A1+B1/(24*60*60)*10) and click OK

In cell A1 enter the elapsed time, including hours (0:15:20).
In cell B1 enter the number of throws (25).
Cell C1 shows the Net Time Score

http://web.mac.com/bigchiz/misc/NTS_ExampleA.png

Ok, now it makes sense. Thanks all!

Here are the results of Lowe's data with the Net Time Score method. As Ross points out, more reward is given for speed than number of throws, hence a better time score for McQuay on 5/16/03 than Dunn on 2/7/04.

<table border="1"><tr><td>Date</td><td>Name</td><td>Course</td><td>Tees</td><td>Time</td><td>Throws</td><td>Score
</td></tr><tr><td>12/25/03</td><td>Dave McQuay</td><td>Cornwallis</td><td>Reg</td><td>0:11:30</td><td>43</td><td>0:18:40
</td></tr><tr><td>5/16/03</td><td>Dave McQuay</td><td>Cornwallis</td><td>Reg</td><td>0:11:48</td><td>46</td><td>0:19:28
</td></tr><tr><td>2/7/04</td><td>Robbie Dunn</td><td>Cornwallis</td><td>Reg</td><td>0:12:37</td><td>44</td><td>0:19:57
</td></tr><tr><td>5/3/03</td><td>Brett Bowers</td><td>Cornwallis</td><td>Reg</td><td>0:12:06</td><td>48</td><td>0:20:06
</td></tr><tr><td>1/12/04</td><td>Dave McQuay</td><td>Kentwood</td><td>Reg</td><td>0:14:26</td><td>48</td><td>0:22:26
</td></tr><tr><td>11/5/03</td><td>Dave McQuay</td><td>Valley Springs</td><td>White</td><td>0:15:20</td><td>47</td><td>0:23:10
</td></tr><tr><td>4/29/03</td><td>Lowe Bibby</td><td>Kentwood</td><td>Reg</td><td>0:15:56</td><td>46</td><td>0:23:36
</td></tr><tr><td>10/21/03</td><td>Dave McQuay</td><td>UNC</td><td>White</td><td>0:17:58</td><td>47</td><td>0:25:48
</td></tr><tr><td>7/4/04</td><td>Dave McQuay</td><td>Zebulon</td><td>Reg</td><td>0:20:19</td><td>54</td><td>0:29:19
</td></tr><tr><td>1/30/06</td><td>Drew Pasteur</td><td>Buckhorn</td><td>White</td><td>0:27:18</td><td>53</td><td>0:36:08</tr></td></table>

It's all good though! Next topic, par for speed golf. :D