At any rate, I thought that just tracking it on a spreadsheet was pretty lame, so I threw together a small flask app as a way to both see if I could improve the process and learn Bulma CSS. One of my big constraints was I didn't want/couldn't have any confidential information touching my server, so the entire project is an SPA - once you download it, everything else is up to you, it's all clientside.
I should note this was the point in my academic/professional career I didn't believe in JS frameworks (before I learned react) so the entire thing is implemented in plain JS + Jquery.
It was a fantastic exercise, but I've since gotten a little more lethal with Excel in my day job and I think I can get comparable results in Office now.
If you want to check it out, a live version is at https://realmtiel.com/troops2seat and the source is available on my github at https://github.com/bktiel/troops2seats.