How to Plan a Vacation Using a Spreadsheet
Open a spreadsheet., Make the following columns., Don't forget food and lodgings., Fill in day numbers., Use web links in the spreadsheet to the activities for descriptions. , Format cost cells as currency. , Use if statements to calculate totals...
Step-by-Step Guide
-
Step 1: Open a spreadsheet.
You can use a program like Microsoft Excel, Numbers (for Mac), etc. -
Step 2: Make the following columns.
Date Day Number Start Destination.
Activity.
End Destination.
Cost. , You can put these in separate columns if you wish, or don't and use the activity column. , 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. ,,, If you know what you are doing with spreadsheets. ,, Present it to the people again to confirm the specific dates. , 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. -
Step 3: Don't forget food and lodgings.
-
Step 4: Fill in day numbers.
-
Step 5: Use web links in the spreadsheet to the activities for descriptions.
-
Step 6: Format cost cells as currency.
-
Step 7: Use if statements to calculate totals based on alternatives.
-
Step 8: Present the itinerary to the people you're going with.
-
Step 9: Add in the specific dates.
-
Step 10: Total up the costs.
Detailed Guide
You can use a program like Microsoft Excel, Numbers (for Mac), etc.
Date Day Number Start Destination.
Activity.
End Destination.
Cost. , You can put these in separate columns if you wish, or don't and use the activity column. , 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. ,,, If you know what you are doing with spreadsheets. ,, Present it to the people again to confirm the specific dates. , 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.
About the Author
Joshua Morales
Professional writer focused on creating easy-to-follow lifestyle tutorials.
Rate This Guide
How helpful was this guide? Click to rate: