A spreadsheet to track handicaps for a weekly league is one of those wheels that we all keep reinventing. I'd like to get a nice collection of people's spreadsheets here so that someone trying to start a new league can see what other people have done.
I'll start with my elaborate contribution to this genre. The league in question plays the same layout every week and bases handicaps on your last five rounds using a centered average (drop the highest and lowest score and take the average of the other three).
The spreadsheet is here (it has a lot of sheets):
https://docs.google.com/spreadsheet/ccc?key=0Aiupe6tk7j8RdFJZTUtRRF83SWJuMjlHMmxmTnVlWUE&usp=sharing
Since it is hosted on Google Docs, the live version of the spreadsheet can be used from any smart phone to tabulate the results of an event and calculate handicapped standings and payouts (it uses a version of PDGA payout tables calibrated so that last cash is $3 = entry fee).
Over time I even added a summary of standings for the season. This includes a 1000-based rating using a linear fit of player's scores each week so that people get a "League Rating". It also tracks points based on how many people you beat on a given week (even though tracking points-series this way for handicap events is probably not a great idea).
Feel free to copy my spreadsheet and use it for your own league if you think it would be useful. Please share any changes or feedback, if you do.
If you have made your own spreadsheet to run a league, please share it!
I'll start with my elaborate contribution to this genre. The league in question plays the same layout every week and bases handicaps on your last five rounds using a centered average (drop the highest and lowest score and take the average of the other three).
The spreadsheet is here (it has a lot of sheets):
https://docs.google.com/spreadsheet/ccc?key=0Aiupe6tk7j8RdFJZTUtRRF83SWJuMjlHMmxmTnVlWUE&usp=sharing
Since it is hosted on Google Docs, the live version of the spreadsheet can be used from any smart phone to tabulate the results of an event and calculate handicapped standings and payouts (it uses a version of PDGA payout tables calibrated so that last cash is $3 = entry fee).
Over time I even added a summary of standings for the season. This includes a 1000-based rating using a linear fit of player's scores each week so that people get a "League Rating". It also tracks points based on how many people you beat on a given week (even though tracking points-series this way for handicap events is probably not a great idea).
Feel free to copy my spreadsheet and use it for your own league if you think it would be useful. Please share any changes or feedback, if you do.
If you have made your own spreadsheet to run a league, please share it!