I modified a spreadsheet that was made in 2018 I think by someone on HR, and you can ACCESS IT HERE as a Google Sheets doc. The 2018 version of this spreadsheet accounted for team scores, mine does not. Feel free to modify if you've got the time, those calculations are more complicated and time-consuming than what I did.
The interactive part of the spreadsheet won't work unless you either create a copy in Google Sheets for yourself, or download and open in Excel.
~ ~ ~ ~ ~
The 2018 version is here, and it contains code that would be useful if you wanted to modify to include team (and individual) scoring.
~ ~ ~ ~ ~
EDIT to say that you should consider downloading LutherAce's spreadsheet instead since his accounts for team scores. There's a different system for scoring individual matches, you enter D, M, T, or F in the yellow boxes.
The interactive part of the spreadsheet won't work unless you either create a copy in Google Sheets for yourself, or download and open in Excel.
~ ~ ~ ~ ~
The 2018 version is here, and it contains code that would be useful if you wanted to modify to include team (and individual) scoring.
~ ~ ~ ~ ~
EDIT to say that you should consider downloading LutherAce's spreadsheet instead since his accounts for team scores. There's a different system for scoring individual matches, you enter D, M, T, or F in the yellow boxes.
Last edited: