Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Bernie
I've been using the Callaway s/s that you supplied, and all seems to be well. However... I have the following scores / pars entered in the spreadsheet: Golfer 1 has the following scores: 5, 7, 9, 9, 5, 8, 8, 7, 8, 8, 6, 6, 8, 6, 6, 6, 9, 8 When I total these individually, I get a total of 129. When it gets totalled in the s/s, it shows a total of 125. The hole pars are = 5, 4, 4, 5, 3, 5, 4, 3, 4, 4, 3, 4, 5, 4, 3, 4, 5, 3 This gives a double par total of = 144 As you can see, the hole score is not greater than double the par, so the raw score should be calculated as 129 and not 125 as it is showing. Unless, under the Calloway Rules, the individaul hole scores are checked against their par score. If this is the case, for Hole 3 with a par of 4 but a hole score of 9, the hole would only show a score of 8. If this is replicated over all holes, this would indeed give a total score of 125. Can you help? Rgds Duncs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bernie Deitrick | Excel Discussion (Misc queries) | |||
PING Bob Phillips | Excel Discussion (Misc queries) | |||
Bernie My New Macro | Excel Worksheet Functions | |||
My New Macro from Bernie | Excel Worksheet Functions | |||
Bernie Deitrick | Excel Worksheet Functions |