Happy Holidays! Merry Christmas if you celebrate.
I'm
not volunteering to be the keeper of this doc for ever, but I created a google sheet for upcoming races and results. I started with a 'word' doc, but the sheet seems more natural for our use. Consider this experimental and just something for us to play around with for now.
The first question is sharing and security. I doubt we want to go to the trouble of allowing access by individual email (I don't). I set it up so that anyone with the link can view/edit the document. I think this means you don't even need a google login to edit it.
The next issue is how to share the link? If I post it in the forum, anyone can see it, even people without a DIS login. This doesn't seem like it would be a problem, but you never know what troublemakers are out there.
The best I could come up with is to add it to my DIS profile, so that only logged in users can see it. Obviously this is not foolproof, but offers at least a tiny bit of protection.
To get the URL (a tinyURL), click on my avatar and click 'About'. You should see the link listed as my website.
I added a separate column for distance, even though most race names contain the distance. I thought it might be fun to see how many of each distance we run by the end of the year.
Any other suggestions? Maybe a PR Y/N column? Same thought: it might be fun to see how many PRs we hit in 2020.
The time columns require the time to be entered with the hour to format correctly, so 38:59 must be entered as 0:38:59.
I added a real race (01/04) and a couple of fake ones to test the sorting.
Let's see how it goes. My experience with lots of people editing a document is that the document gets hosed every time.