Building a golf tournament spreadsheet to calculate the handicap using Peoria method

[anandchiplunkar]

Hi.

We have been organizing tournaments and playing different formats. As one of the core members, I was wanting to know if anyone has developed an excel spreadsheet to calculate handicap of players using Peoria system or Double Peoria system.

I see many sheets using Stableford format for managing tournament scores in which the handicap is entered (as a given). There also are sheets that calculate the Net score based on the entered Gross score after the tournament and known handicap before the tournament. The problem I am trying to solve is to use the entered Gross scores after the tournament, that will be the basis to calculate the handicap for that day (as per Peoria or Double Peoria system).

One way would be to use such an existing spreadsheet and link a sheet to calculate the handicap using Peoria system. But if anyone has done something like this it will be very helpful.

Thanks.

Anand

[FlameRetired]

Hi Anand. Welcome to the forum.

I personally have not done such handicapping. The following links searched online suggest it is rather straight forward.

https://www.thoughtco.com/peoria-sco...ndicap-1560947
http://www.myscorecard.com/cgi-bin/k...eoria&article=

This one explains "Double Peoria".
http://www.leaderboard.com/glossary_peoria

Let us know if you have any questions.

[anandchiplunkar]

Hi Dave.

Thanks a lot for the quick feedback. I was hoping that someone may have prepared an excel sheet for Peoria system (which itself is straightforward).

Let me keep exploring or just prepare an Excel Sheet if none exists.

Anand

[jokl]

Hi, did you find anyone that had a Peoria excel-file? Im looking to find one and my Excel skills is not good enough to build one my self....

[AliGW]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

[anandchiplunkar]

Hi, did you find anyone that had a Peoria excel-file? Im looking to find one and my Excel skills is not good enough to build one my self....

Hi Jokl, Unfortunately I didn’t find any. Anand