Forum Discussion
What is the formula to divide an odd number
Kevin_Caldewell Let's say the 5 handicap sits in cell A1. Then, in B1 you enter:
=INT(A1/2) to get 2,
And in C1 you enter:
=A1-B1 to get 3
Kevin_Caldewell Let's say the 5 handicap sits in cell A1. Then, in B1 you enter:
=INT(A1/2) to get 2,
And in C1 you enter:
=A1-B1 to get 3
I would like a formula that calculates the adjusted score based on a specific handicap. For example, the most anyone can post for any one hole is a net double bogey (2 over par), with the key being net. If someone was a 0 handicap he would not get any strokes on any holes and the most he could post for any one hole would be a double bogey, but if he had a 2 handicap, he could post a score on H/C holes 1 and 2, which in the example below is hole 5 and 17, of a 7 (PAR 4 + Double Bogey or 6 + 1 for a total of 7) instead of 6 if he had a 0 H/C. I have entered two players scores and have listed them in order of the hole number played, with the hole H/C and PAR listed below that. The formula would use the scores listed for each hole, allowing for one extra stroke on the H/C holes he is allowed a stroke on, which in this example would be for Mike H/C's 1 through 11, and William 1 and 2 (not holes 1 through 11, and 1 and 2, but H/C holes 1 through 11, and H/C holes 1 and 2. The formula would be written in the cell under the ADJUSTED SCORE COLUMN, and it would have to work with the individual's HANDICAP. I was thinking the formula would have the HANDICAP affect only those scores on holes where his HANDICAP applied, then adding all the ADJUSTED SCORES for a TOTAL ADJUSTER SCORE. Can you help.
| FRONT | BACK | |||||||||||||||||||||
| HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | ||||
| H/C | 7 | 5 | 17 | 9 | 1 | 15 | 13 | 3 | 11 | 12 | 16 | 14 | 4 | 6 | 18 | 8 | 2 | 10 | ||||
| HANDICAP | PAR | 4 | 5 | 3 | 5 | 4 | 4 | 3 | 4 | 4 | 4 | 3 | 4 | 4 | 5 | 3 | 4 | 4 | 5 | ADJUSTER TOTAL SCORE | ||
| Mike Aroz | 12 | 5 | 5 | 4 | 6 | 5 | 5 | 3 | 3 | 5 | 5 | 4 | 5 | 5 | 6 | 4 | 5 | 4 | 6 | |||
| William Bonnett | 2 | 4 | 5 | 6 | 4 | 5 | 4 | 3 | 4 | 4 | 3 | 3 | 8 | 5 | 6 | 4 | 4 | 4 | 5 |
- The score card looks good, but my understanding of posting scores is that you can not take more than a net double bogey on any one hole, so if the spreadsheet you provided, William shot a 8 on a par 4, which was on hole 12 that had a handicap of 14, and since William is a 2 handicap he would not get a stroke on that hole, so his net score for posting purposes would be 6, and his total for the back would be reduced by 2 strokes. Again this is for posting purposes. Can you explain further?
Kevin_Caldewell Changed the file a bit. See attached.
Kevin_Caldewell Golfer myself! Happened to have a score card ready that I made earlier for someone else. Put in your numbers as an example. See if this works for you.