I have started taking up to golf and have decided to keep a handicap. Always had a opinion it was a boring sport until the Pandemic hit and I joined a couple of buddies on the golf course. Next Season the intention is to join a Golf Club. You automatically then get access to Golf Canada Membership and their site to keep your handicap. However, this Season I decided to start keeping my own Handicap and put together an excel Spread-sheet. Then I realized that the Handicap Rules actually changed in 2020 to take into account 8 rather than 10 of your best scores in 20 rounds. That is not a problem to switch to 8. But what what is challenging is taking 2 strokes off in the first 3 rounds by Adjustments then it goes down to 1 stroke off in 4 games and finally 0 strokes off in 5 games. That is based on just one best score. However, when you play 6 rounds it averages the best 2 rounds but then gives you a stroke off. From 7 rounds onwards there is no problem as the Adjustment reveals no strokes to be taken off your Handicap. But just cannot get the spread-sheet to remove these strokes when it automatically calculates the Handicap based on the average of the respective rounds. Any ideas how to do so if there are any IT wizards on this Board?

