Trip Planning Spreadsheet: Itineraries, Multi-Currency Budgets & Group Cost Splitting
Plan a multi-stop trip from check-in dates to the last night, budget in four currencies, compare transport and places to stay, track daily spending, split costs fairly with your travel companions and settle up in a few payments – 8 hands-on labs on one rail trip, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you plan a twelve-night trip through four cities in a spreadsheet that checks every cell as you go. You build check-in and check-out dates from nights per stop and count the pricier weekend nights, convert expenses in four currencies with a rate table and price the card fees. You compare plane, train, bus and car per person and per hour saved, turn advertised room prices into real totals with fees and city tax, and track a daily budget burn-down. Finally you split shared costs by who took part, calculate net balances, settle up in the fewest payments and value credit-card points.
Lessons
- Building the Itinerary: Nights per Stop, Check-in and Check-out Dates Pro
- Spending in Four Currencies: FX Table, Home-Currency Totals and Card Fees Pro
- Plane, Train, Bus or Car? Comparing One Leg per Person and per Hour Pro
- Hotel, Apartment or Hostel? Total Stay Cost with Fees and City Tax Pro
- Daily Budget Burn-Down: Planned vs Actual and What's Left per Day Pro
- Splitting Group Costs Fairly: Who Paid, Fair Shares and Net Balances Pro
- Settling Up: The Fewest Payments that Clear Every Balance Pro
- Points & Miles: Value per Point and the Best Use of a Balance Pro