It’s mostly for fun, but I have found it makes a useful tool for digesting an official’s history into a more readable format and looking at various types of games. There are dropdowns to filter the data by association, level, date, and position…so you can look at things like “MRDA games NSOed since Covid”.
If you want to play with it, go to the following link and make a copy for yourself: Math’s Officiating History Viewer
Then, copy a game history link into the appropriate green cell (D3). Note that shortened or “vanity” links don’t work in Google Sheets.
Let me know if you have questions, suggestions, or critiques!
Disclaimer: Game totals aren’t the whole story of an official. I would never base important staffing decisions on game totals, and I encourage you not to either.
Love! Found some things on my game history to clean up.
I may have used it wrong, but I don’t see games when I sort by NSO position but do see them when I sort by CHNSO. When I CHNSO, which is in the primary position column, I am almost always doing another NSO job at the same time, which is in the second position column.
Hmm, interesting! Do you mean that when you filter by ‘CHNSO’, it is counting specific games that are not counted when you filter by ‘Any NSO’? I can’t see any reason why the QUERY for Any NSO would miss the CHNSO games, since the regular expression for the former contains the latter.
One possibility: There is a weird thing where, when you first input a link, the sheet can behave weirdly and show no games at all. My guess is that the game history data takes a minute to load in the backend, and it just gives null results until it loads.
Regarding Head Officials and 2nd positions…I wasn’t entirely sure how to count HNSO games, and I’m open to suggestions. With HNSO, both the 1st and 2nd positions may be of interest. I considered ways to incorporate 2nd position info, but I gave up and decided to count every game by 1st position exclusively.
