move values from one spread sheetto another
helpmeout11
tripfinacialplan1.xlsxSheet1
| A TRIP OF FIVE TO BRAZIL | ||||||||||||
| My Budget & Expenses | Breakdown of Expenses | |||||||||||
| Total Budget | ||||||||||||
| $4,750.00 | Transportation | 59% | 2,268 | |||||||||
| Total Expenses | Lodging | 16% | 600 | $3,813 | ||||||||
| $3,812.70 | Food | 15% | 585 | |||||||||
| Difference | Entertainment | 3% | 110 | |||||||||
| $937.30 | Other | 7% | 250 | |||||||||
| What are my expenses? | ||||||||||||
| description | category | quantity | unit cost | amount | ||||||||
| Flights | Transportation | 5 | 400.00 | 2,000.00 | ||||||||
| Taxi & Bus | Transportation | 5 | 30.00 | 150.00 | ||||||||
| Driving (miles, cost/mile) | Transportation | 50 | 0.56 | 28.00 | ||||||||
| Parking (days, cost/day) | Transportation | 6 | 14.95 | 89.70 | ||||||||
| Hotel (nights, cost/night) | Lodging | 5 | 120.00 | 600.00 | ||||||||
| Breakfast | Food | 5 | 12.00 | 60.00 | ||||||||
| Lunch | Food | 5 | 45.00 | 225.00 | ||||||||
| Dinners | Food | 5 | 50.00 | 250.00 | ||||||||
| Snacks and Drinks | Food | 5 | 10.00 | 50.00 | ||||||||
| Museum Tickets | Entertainment | 2 | 20.00 | 40.00 | ||||||||
| Live Show Tickets | Entertainment | 2 | 35.00 | 70.00 | ||||||||
| Maps and Guidebooks | Other | 1 | 50.00 | 50.00 | ||||||||
| Souvenirs and Gifts | Other | 1 | 200.00 | 200.00 | ||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ||||||||||||
| - 0 | ← Insert new rows ABOVE this line | |||||||||||
| Total Expenses | $ 3,812.70 |
Transportation Lodging Food Entertainment Other 0.59477535604689591 0.15736879376819576 0.15343457392399087 2.8850945524169225E-2 6.5570330736748242E-2
1
2
3
4
5
A
B
C
D
E
F
A TRIP OF FIVE TO BRAZIL
Total Budget
$4,750.00
Transportation
Total Expenses
Lodging
My Budget & Expenses
Breakdown of Expenses
