Travel Planner
Posted on July 25, 2009
Filed Under Other |
Finally … home again. After spending one week in Hongkong and China, met with my offline business partners, finally I can straight my legs at home and hoping that all meeting there will give me good business results. And this is my second visit this year and I just saw that the world economic crisis didn’t really affect this country. Or maybe I just saw from my business perspective.
If you have a plan to visit China and you don’t know how to speak Chinese, you should be prepare anything carefully, since most of people in China doesn’t speak English and they don’t know how to read latin words. One spreadsheet that I used to remind me about situation in my travel destination beside my travel expense spreadsheet, is my travel planner spreadsheet.
This spreadsheet is created based on my weekly planner spreadsheet. So, you can adjust your time activities references like in weekly planner. Unlike the weekly planner that have one week period, this travel planner has a flexible period that you can adjust with maximum of 14 days. This travel planner consist of two worksheets with explanation as follows :
Setup Worksheet
You can set your planner layout here.
- Time style : You can set whether you want to show the minutes or not in the planner. If you need a planner that only have hour, set the time style with “Don’t show minutes”.
- Appointment schedule : This is the area where you can set your time planner. Just check (type “v”) in the column next to hour and minutes to show them in the planner. If you uncheck them, the hour or minutes will disappear from your planner. You can change the hour time also, I set the default with 7 o’clock, but you can change that hour into your desired start time, but don’t forget to change the hour below.
- Maximum rows : This is your reference for the maximum rows that can be shown in the planner, where the remain rows cell will give you information regarding your remaining available rows that can be checked.
- Holiday column : This is columns where you can put your holiday or additional holiday instead of the default ones. The name of holiday will appear in the planner if the date is inside your weekly period.
Planner worksheet
Before you fill or print this worksheet, make sure you fill the start date and end date in the two columns at the left corner. I put a conditional formatting in that worksheet where travel date columns will be created based on your start/end date information. And below the date, I put a big transportation and accommodation column, because these are the most important things that you have to remember when you are travelling. And at the left side, I put some sample not-to-forget information. I also attach one sample planner worksheet to ease you understanding my worksheet which you can erase if you don’t need that worksheet anymore.
Feel free to modify based on your needs. And you can download the file here.
You can read and download my other templates below :
- Latitude Longitude Calculator
- Gantt Chart
- Shift Schedules
- Grocery List
- Home Inventory
- Biorythm Chart
Comments
6 Responses to “Travel Planner”
Leave a Reply
Hi - I downloaded your travel planner, put my days in (June 2010) but the days of the week remained as you had them.
Hi KT,
You should activate the analysis toolpak add-ins. Go to menu > tools > add-ins, tick the analysis toolpak and click OK. And your travel planner will work as expected.
Regards
Hi - When changing the dates to a new time period the spreadsheet does not apply the days of the week eventhough i activated the ass-ins for analysis.
even the number of the year losses its reference ( yyyy).
What am I doing wrong ?
thank you in advance.
Peter
Can’t seem to download travel planner
Do you have a travel itinerary planner that shows the details of the travel such as flights/hotels etc?….
Hi,
Great tool!
Is there anyway to have it stretch further that a 2-week travel period? I put in the dates of my trip 4/29 - 5/14, but it only shows dates through 5/12.
Thank you,
Ben