A B C D E
1 Trip Planner for:
2
3 Miles per gallon
4 Cost per gallon
5 # people / double occupancy
6
7 Day 1 Day 2 Day 3 Day 4
8 Destination
9 Miles Travelled
10 Gasoline
11
12 Meals
13 Breakfast
14 Lunch
15 Dinner
16 FOOD TOTAL
17
18 Sightseeing
19 Lodging
20 Miscellaneous
21
22 TOTAL
23
24 Instructions:
25 Enter a text value in cells highlighted in blue.
26 Enter a numeric value in cells highlighted in yellow.
27 Enter a formula in cells highlighted in red.
28 All formulas should reference cells.
29 References to miles/gallon, cost/gallon, and # people/occupancy should be absolute cell references
30 Remove the highlighting when you are finished.
31 Format all numeric cells to 2 decimal points
32 Monetary values should be formatted to accounting style..
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
A B C D E
48
49
50
51
52
53
54
F G H I
1
2
3
4
5
6
7 Day 5 Day 6 Day 7 Total
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
references
olute cell29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
F G H I
48
49
50
51
52
53
54