My wife, Jen, is the travel planner of the family. She has a real knack not only for finding the best deals and all of the must-see places, but also for keeping track of a lot of information on flight times, hotel bookings, people to visit etc. I'm not the best at all of that, so when it fell to me to plan our upcoming trip back home to Australia I knew I would need some kind of tool to keep track of everything.
I first tried the online travel planner tools like TripIt and TripCase but found that they weren't designed to show the information as a timeline in the way that I wanted. Next I went to Microsoft Office Timeline, but with the free version you can only input ten events. Lastly I tried the templates available on Microsoft Excel, and while they ultimately proved a little unwieldy overall, they did give me some ideas for how I might design my own timeline tool using a scatter plot.
So I spent a couple of hours last Saturday putting this thing together. The only bug that I haven't been able to fix is the automatic scaling of the x axis when the dates are changed. It's frustrating but not too difficult to fix manually. And as you can see, the trip is coming along nicely!
(The dates have been changed from those of the actual trip for privacy)
Travel Planner Timeline
Luke Scholtes is a Science teacher with eleven years experience, currently working at the American International School of Bucharest.