The other day I posted...
... and a couple of people asked me how to do it.
To some of you this may be the most obvious thing on the planet, but I only
discovered it earlier this year and - my oh my - has it saved me some time. My
day* job sees me visiting various places around the country and I keep track
of it all in my calendar. As any self-respecting nerd is driven by unknown
forces to do, I often put a bit of effort into finding out how I can get the
tech around me to do some of the more boring jobs so that I have more time
available for doing the interesting things. I'd list some potential use-cases
for this spreadsheet-to-calendar trick but I figure that if you've read this
far you already know what you want it for.
Before we get started, a disclaimer: Yes, there are plenty of other
articles detailing how to do this and I visited many of them. I haven't
referenced any of them because it was about six months ago so I've forgotten
which ones I used, none of them gave me every piece of information I needed,
and there were a few important stumbling blocks that weren't mentioned at all.