Must-have data — at least for me.
It may sound strange to folks who live in the world of alarm clocks and wrist watches, but my life’s calendar is managed by the sun. I wake early — before sunrise this time of year — and I sometimes can’t do things until after the sun has come up. As a pilot, I also need to know when the sun will rise and set so I can schedule sunrise and sunset flights, night flights, and photo flights, all of which depend on the sun for timing.
Each year, I export the daily sunrise and sunset information from Time Palette, a shareware application that provides various almanac information, into a FileMaker Pro database I created, which turns the exported data into real dates and times. I then export the Sunrise and Sunset info as separate FileMaker Pro files. I import those into iCal Filter, which enables me to export them back out as iCal .ics files. I open those file to import the information into iCal, thus displaying sunrise and sunset times on my iCal calendar.
Although it seems like a lot of work, I only do it once a year and then I’m set for the entire year.
If you’re interested in the .ics files for your location, I could probably be charmed into whipping up the files for you in exchange for one of the items on my Amazon.com wish list. (I really like surprises.) I might even throw in the moonrise/moonset times; I’m working on adding them, too.
Trouble was, the existing ad I wanted to modify for this job had the wrong photos. That means I had to get new photos. Then I couldn’t get the style of the new photos to match the photos I wanted to keep. So I had to find the original versions of all the photos and prepared them all over again from scratch. But I couldn’t remember out how I’d done it in the first place. So I had to figure it out.