|
I keep all my games in a spreadsheet, tracking not only date, location, pay, etc, but also partners (for baseball, don't bother with football or basketball) and game notes, kind of as a short diary/record.
For location, I have a tab with all the common locations in a list, then when I enter the name on the main tracking sheet, it looks up against the list. If it's a new school or location, it's easy to spot since the lookup returns an error. Then I just enter that school/location into the main list. Yea, it's a little time-consuming to set up at the start but after a short while, 90% of the locations are on the list and as it grows it gets even more all-encompassing. I have a little flag that I enter whether I left from work or home originally (since the mileage would be different) and it uses that in the lookup. To get the original values, I just used Google Map's distance from work or home.
So if I did something goofy like go from one school to the other, would it track that? No, but that's fairly rare. 99% of the time, I'm either leaving from either work or home and returning home. Close enough.
|