Hello
I have a complicated game we play in our golf league. I've done my best to try to give an example. In short, it rewards birdies and par if you are the only person to get it amongst a group. Each person puts in $20 a piece to create a pot. A "Rabbit" is getting the lone par in a hole; A "Squirrel" is getting the lone birdie or lower (eagle/double eagle) in a golf hole. I don't know if its possible, but is there a way to calculate who won a rabbit and squirrel every six holes, then tabulate payment of those rabbit and squirrel (possible two per six holes). If all six are not accumulated, then the leftover money is in skins.
To win a rabbit or squirrel, one has to have it in hand at the end. So in the example, I would get a rabbit in hole one, but if someone gets a rabbit in any subsequent hole following (up to Hole 6, Hole 12, or Hole 18) then the rabbit goes "back' for availability. I hope the spreadsheet and example helps. Please reach out if questions. In short, I want a program to calculate the yellow, adding the names itself somehow.
The yellow if formulas can be created. the green I can input myself as the amount of money may vary.
Here is the raw data
Here is the spreadsheet I loaded the numbers manually that I am hoping formulas could be created. I'll put it in xlbb. This would be putting the names of players getting money. Any money not won with rabbit or squirrel is pushed to skins (lowest lone score on hole regardless if it's a par or birdie/eagle/double eagle). I added this text. On my example, there might be a lot of people with skins so not enough space or rows . Maybe if responding the skins rabbit and squirrel could be done columnar. In mine I shoved everything in one column if that makes sense.
Here is an explanation of how I manually calculated each hole. There are three sections Holes 1-6, 7-12, and 13-18. So each section gets one rabbit one squirrel up for grabs.
I have a complicated game we play in our golf league. I've done my best to try to give an example. In short, it rewards birdies and par if you are the only person to get it amongst a group. Each person puts in $20 a piece to create a pot. A "Rabbit" is getting the lone par in a hole; A "Squirrel" is getting the lone birdie or lower (eagle/double eagle) in a golf hole. I don't know if its possible, but is there a way to calculate who won a rabbit and squirrel every six holes, then tabulate payment of those rabbit and squirrel (possible two per six holes). If all six are not accumulated, then the leftover money is in skins.
To win a rabbit or squirrel, one has to have it in hand at the end. So in the example, I would get a rabbit in hole one, but if someone gets a rabbit in any subsequent hole following (up to Hole 6, Hole 12, or Hole 18) then the rabbit goes "back' for availability. I hope the spreadsheet and example helps. Please reach out if questions. In short, I want a program to calculate the yellow, adding the names itself somehow.
The yellow if formulas can be created. the green I can input myself as the amount of money may vary.
Here is the raw data
| HD Ham and Egg spreadsheet for HD Invitational May 2024 everyone has everyone.xlsx | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
| 1 | Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | ||
| 2 | PAR | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 5 | 4 | 4 | 5 | 5 | 4 | 3 | 4 | 4 | 5 | 5 | ||
| 3 | ALLEN, Dr. SEAN | 4 | 5 | 4 | 4 | 4 | 2 | 7 | 6 | 4 | 4 | 5 | 4 | 3 | 3 | 4 | 5 | 5 | 8 | ||
| 4 | BOLDEN, Dr. ANTHONY | 4 | 5 | 5 | 3 | 4 | 3 | 5 | 5 | 4 | 4 | 5 | 4 | 4 | 2 | 4 | 5 | 5 | 5 | ||
| 5 | BRISTER, TONY | 4 | 4 | 4 | 4 | 5 | 3 | 5 | 5 | 4 | 4 | 5 | 4 | 3 | 3 | 4 | 5 | 5 | 5 | ||
| 6 | BROWN, DON | 4 | 4 | 7 | 5 | 4 | 4 | 6 | 4 | 5 | 4 | 5 | d | 3 | 3 | 4 | 5 | 5 | 5 | ||
| 7 | BOOKER, RICK | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 5 | 4 | 4 | 5 | 6 | 4 | 2 | 4 | 5 | 5 | 5 | ||
| 8 | BOWERS, BRANDON | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 5 | 5 | 3 | 5 | 6 | 4 | 2 | 4 | 5 | 5 | 5 | ||
| 9 | BYRD, GARRY | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 5 | 4 | 4 | 5 | 6 | 4 | 2 | 4 | 5 | 5 | 5 | ||
| 10 | CARTER, RICK | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 5 | 4 | 4 | 5 | 6 | 4 | 2 | 4 | 5 | 5 | 5 | ||
| 11 | CHENIER, Sr. | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 4 | 4 | 4 | 5 | 6 | 4 | 2 | 4 | 5 | 5 | 5 | ||
| 12 | COLLINS, REGGIE | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 5 | 4 | 4 | 4 | 6 | 4 | 2 | 4 | 5 | 5 | 5 | ||
| 13 | DAVIS , TONI | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 5 | 4 | 4 | 5 | 6 | 4 | 1 | 4 | 5 | 5 | 5 | ||
| 14 | DAVIS, HAROLD (H.D.) | 4 | 5 | 2 | 4 | 5 | 3 | 5 | 5 | 4 | 4 | 5 | 6 | 4 | 2 | 4 | 5 | 5 | 5 | ||
| 15 | DAYE, BOBBY | 2 | 5 | 4 | 4 | 4 | 3 | 5 | 5 | 4 | 4 | 5 | 6 | 4 | 2 | 3 | 5 | 5 | 5 | ||
| 16 | FIELDS, HAROLD | 4 | 5 | 4 | 4 | 4 | 3 | 5 | 5 | 4 | 4 | 5 | 6 | 4 | 2 | 4 | 4 | 5 | 5 | ||
Download_Scores | |||||||||||||||||||||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| S3:S39 | Cell Value | top 1 bottom values | text | NO |
| R3:R39 | Cell Value | top 1 bottom values | text | NO |
| Q3:Q39 | Cell Value | top 1 bottom values | text | NO |
| P3:P39 | Cell Value | top 1 bottom values | text | NO |
| O3:O39 | Cell Value | top 1 bottom values | text | NO |
| N3:N39 | Cell Value | top 1 bottom values | text | NO |
| M3:M39 | Cell Value | top 1 bottom values | text | NO |
| L3:L39 | Cell Value | top 1 bottom values | text | NO |
| J3:J39 | Cell Value | top 1 bottom values | text | NO |
| K3:K39 | Cell Value | top 1 bottom values | text | NO |
| I3:I39 | Cell Value | top 1 bottom values | text | NO |
| H3:H39 | Cell Value | top 1 bottom values | text | NO |
| G3:G39 | Cell Value | top 1 bottom values | text | NO |
| F3:F39 | Cell Value | top 1 bottom values | text | NO |
| E3:E39 | Cell Value | top 1 bottom values | text | NO |
| D3:D39 | Cell Value | top 1 bottom values | text | NO |
| C3:C39 | Cell Value | top 1 bottom values | text | NO |
| B3:B39 | Cell Value | top 1 bottom values | text | NO |
Here is the spreadsheet I loaded the numbers manually that I am hoping formulas could be created. I'll put it in xlbb. This would be putting the names of players getting money. Any money not won with rabbit or squirrel is pushed to skins (lowest lone score on hole regardless if it's a par or birdie/eagle/double eagle). I added this text. On my example, there might be a lot of people with skins so not enough space or rows . Maybe if responding the skins rabbit and squirrel could be done columnar. In mine I shoved everything in one column if that makes sense.
| HD Ham and Egg spreadsheet for HD Invitational May 2024 everyone has everyone.xlsx | ||||||
|---|---|---|---|---|---|---|
| U | V | W | X | |||
| 24 | Total Pot | 280 | Each rabbit and squirrel is $46.66 a piece. Six opportunities two per section. Any leftover money is split to skins depending on number a person gets | |||
| 25 | Skins | |||||
| 26 | Bobby Daye | 2 | $31.11 | From Hole 1 and 15 | ||
| 27 | Harold Davis | 1 | $15.55 | From Hole 3 | ||
| 28 | Anthony Bolden | 1 | $15.55 | From Hole 4 | ||
| 29 | Sean Allen | 1 | $15.55 | From Hole 6 | ||
| 30 | Brandon Bowers | 1 | $15.55 | From Hole 10 | ||
| 31 | Reggie Collins | 1 | $15.55 | From Hole 11 | ||
| 32 | Toni Davis | 1 | $15.55 | From Hole 14 | ||
| 33 | Harold Fields | 1 | $15.55 | From Hole 16 | ||
| 34 | ||||||
| 35 | Rabbit | |||||
| 36 | Sean Allen | 1 | $46.66 | |||
| 37 | Harold Fields | 1 | $46.66 | |||
| 38 | ||||||
| 39 | ||||||
| 40 | Squirrel | |||||
| 41 | Sean Allen | 1 | $46.66 | |||
Download_Scores | ||||||
Here is an explanation of how I manually calculated each hole. There are three sections Holes 1-6, 7-12, and 13-18. So each section gets one rabbit one squirrel up for grabs.
| Rabbit: Lowest score on a hole if that score is a PAR | |
| Squirrel: Lowest score on a hole if that score is birdie (1 stroke below Par) or eagle (2 strokes below Par) | |
| Hole 1 | Bobby Daye gets rabbit and squirrel |
| Hole 2 | Bobby Daye loses the rabbit and Squirrel as Brister and Brown birdied hole (tie). So rabbit and squirrel back to square one |
| Hole 3 | Harold Davis gets rabbit and squirrel |
| Hole 4 | Harold Davis loses rabbit and squirel as Anthony Bolder birdied hole. Rabbit and squirrel back to square one |
| Hole 5 | No one wins. Rabbit and Squirrel out there for the taking still as its back to square one |
| Hole 6 | Sean Allen gets rabbit and squirrel. Only bridie of group. Since this is the last hole of the section, he WINS rabbit and squirrel |
| Hole 7 | No single person wins this hole outright. Lots of pars |
| Hole 8 | No single person wins this hole outright. Lots of pars |
| Hole 9 | No single person wins this hole outright. Lots of pars |
| Hole 10 | Brandon Bowers gets a rabbit and squirrel. |
| Hole 11 | Brandon Bowers loses the rabbit and squirrel. Reggie Collins only birdie so rabbit and squirrel back to square one |
| Hole 12 | Three people bridied hole so push. Therefore no one wins rabbit and squirrel this section. |
| Hole 13 | Three people bridied hole so push. Therefore no one wins rabbit and squirrel this hole. |
| Hole 14 | Toni Davis got a hole in one so gets Rabbit and squirrel in hand |
| Hole 15 | Toni Davis loses Rabbit and squirrel. Bobby Daye gets sole rabbit and squirrel. Back to square one |
| Hole 16 | Harold Fields had the lone par. So he gets a rabbit only. Squirrel still at square one |
| Hole 17 | Lots of pars. Inhcluding Harold who parred so he keeps the rabbit from hole 16 |
| Hole 18 | Lots of pars. Inhcluding Harold who parred so he keeps the rabbit from hole 16. So in this section he wins a rabbit only. |
Last edited:
