How to
Create a Spreadsheet for your Vacation
·
1st
Step – Type itinerary and prices into excel spreadsheet like the table example
below.
|
Itinerary (column A, row 1) |
Price (Column B, row 1) |
|
Day 1 |
|
|
Hotel - |
$250.00 |
|
Attraction
1 - |
$25.00 |
|
Attraction
2 - |
$15.00 |
|
Attraction
3 - |
$13.00 |
|
Food- |
$28.00 |
|
Day 1 total |
$331.00 |
|
Day 2 |
|
|
Hotel - |
|
|
Attraction
1 - |
|
|
Attraction
2 - |
|
|
Attraction
3 - |
|
|
Food- |
|
|
Day 2 Total |
|
|
|
|
|
Total for all days |
|
|
Budget |
$2000.00 |
|
Remaining Funds (subtraction
formula) |
(subtract
total for all days from budget – in this cell) |
·
2nd
Step – Write formulas to get the total for each day:
o
Formula
for adding: =SUM(column row+ column row)
=SUM(C2+B3)
o
Formula
for subtracting: =SUM(column row- column row)
=SUM(C2-B3)
·
3rd
Step – Write formula to add all the
daily totals