How to Plan a Vacation Using a Spreadsheet

Опубликовал Admin
10-11-2016, 22:42
511
0
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

  1. Open a spreadsheet. You can use a program like Microsoft Excel, Numbers (for Mac), etc.
  2. Make the following columns.
    • Date
    • Day Number
    • Start Destination.
    • Activity.
    • End Destination.
    • Cost.
  3. Don't forget food and lodgings. You can put these in separate columns if you wish, or don't and use the activity column.
  4. 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.
  5. Use web links in the spreadsheet to the activities for descriptions.
  6. Format cost cells as currency.
  7. Use if statements to calculate totals based on alternatives. If you know what you are doing with spreadsheets.
  8. Present the itinerary to the people you're going with.
  9. Add in the specific dates. Present it to the people again to confirm the specific dates.
  10. 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.