How to Plan a Vacation Using a Spreadsheet
When planning a vacation, it can be difficult to consolidate an overall itinerary and budget in one organized place. A spreadsheet is the perfect solution that can help with this task.
Steps
-
Open a spreadsheet. You can use a program like Microsoft Excel, Numbers (for Mac), etc.
-
Make the following columns.
- Date
- Day Number
- Start Destination.
- Activity.
- End Destination.
- Cost.
-
Don't forget food and lodgings. You can put these in separate columns if you wish, or don't and use the activity column.
-
Fill in day numbers. Don't use specific dates yet. Fill in the date column with TBC (To Be Confirmed).
- Use "Day 1" more than once. Use the same numbers more than once for alternative choices such as plane travel, train travel, coach travel.
-
Use web links in the spreadsheet to the activities for descriptions.
-
Format cost cells as currency.
-
Use if statements to calculate totals based on alternatives. If you know what you are doing with spreadsheets.
-
Present the itinerary to the people you're going with.
-
Add in the specific dates. Present it to the people again to confirm the specific dates.
-
Total up the costs. Once they've made decisions, keep a copy of the original, but make a copy without the options. Add a cell at the bottom which is a total of the cost column.
Tips
- Don't forget to budget in a bit for unforeseen expenses.
Warnings
- Costs change, so take more money than you think you'll need.
Information
Users of Guests are not allowed to comment this publication.
ТОП
Статьи