LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 65
Default PING: Bernie Deitrick - Calloway Golf Scoring

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bernie Deitrick CBrausa Excel Discussion (Misc queries) 1 May 5th 06 10:27 PM
PING Bob Phillips Steve Excel Discussion (Misc queries) 3 July 4th 05 07:31 PM
Bernie My New Macro JulianB Excel Worksheet Functions 1 March 8th 05 09:41 PM
My New Macro from Bernie JulianB Excel Worksheet Functions 1 March 4th 05 05:21 PM
Bernie Deitrick Trying to excel in life but need help Excel Worksheet Functions 1 January 19th 05 03:27 PM


All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"