Judge Assignment Spreadsheet

For online tournaments last year, AMTA gave AMTA Representatives a Google Sheet that allowed us to easily check-in judges, assign them to rounds, and see if those assignments had conflicts. While I don't see a copy available on AMTA's website, I wanted to use it for the invitationals I am running this year, so I developed my own, trying to mimic the features AMTA's had. I've finished initial work on it, and am sharing here, in the hope that others may find it useful. I have purposefully left all of the columns with the logic unhidden to make it easier to see how it works. If anyone has any suggestions for improvements (or bugs I've missed in my limited testing) please let me know!

Link: https://docs.google.com/spreadsheets/d/1JtZw8oaPvKJ3p4NrHlh9oy58zmVKe5P3KJ-KK1LdnHg/edit?usp=sharing