Team Challenge

Match-Play Ratings

Ratings on the PDGA scale, built from who beat whom in singles and doubles.

1

Player list

Players.xlsx holds PDGA numbers, PDGA ratings, and every spelling of each name. Skip it the first time; the tool will make one for you.

Choose Players.xlsx
No player list loaded.
2

Match workbooks

Add the latest copy of each league's workbook (Maine, New England). Each run starts from scratch, so always add every workbook.

Add workbooks
3

Calculate

Reads every match tab, matches names to players, and replays the season in date order.

What you get

Every player gets one rating across all the leagues you add. Beating a stronger player moves your rating more than beating a weaker one, and a 7&5 win counts for more than a 1up. Doubles count at half weight.

Players start from their PDGA rating when the player list has one. Everyone else starts from their team's level and settles after a few matches.

Example layout, not real results
1Player ATeam One961+9
2Player BTeam Two942+92
3Player CTeam One938+12
4Player DTeam Three921−6