Travel Planner - Free Excel Template



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.
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.
From: exceltemplate.net
  Download   Demo  

0 Comments:

Post a Comment