{"product_id":"trip-planner-itinerary-spreadsheet","title":"Trip Planner Dashboard Spreadsheet","description":"\u003cp\u003eThis trip planner builds your whole itinerary from one date, so when your flight moves by a week the entire trip moves with it. It is for travelers planning a longer trip with several stops, who want the days, the bookings, the packing and the pre-trip deadlines in one file.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. It fills itself from what you enter.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDays to go: a live countdown to the day you leave, with the dates underneath\u003c\/li\u003e\n\u003cli\u003eSpent on the trip: what you spent on the ground, and the average per day\u003c\/li\u003e\n\u003cli\u003eThe route: every stop in order, with arrival, days, activities and spend\u003c\/li\u003e\n\u003cli\u003eBookings: paid, deposit and to pay, and the next ones still to pay\u003c\/li\u003e\n\u003cli\u003eA stop picker: choose any stop on the route and the spending follows\u003c\/li\u003e\n\u003cli\u003eReady to go: how much is packed and how much of the checklist is done\u003c\/li\u003e\n\u003cli\u003eSpend per day with a running total, and budget against spent for every category\u003c\/li\u003e\n\u003cli\u003eBefore you go: pre-trip tasks done, still to do and overdue, by kind\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eAn itinerary that holds no dates of its own\u003c\/h2\u003e\u003cp\u003eUnlike a typed itinerary template, day one here is the date on Setup and day two is that plus one. The demo has twenty-one days of plans, and the itinerary has room for 30, all counted from that single cell.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eMorning, afternoon and evening for each day, because that is how a day is really planned and where the gaps show\u003c\/li\u003e\n\u003cli\u003eThe weekday calculates itself, so you find out the museum day is a Monday before you get there\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eBookings and deadlines\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eA booking tracker with 60 rows, each carrying its reference, the one thing you need at a desk with no signal\u003c\/li\u003e\n\u003cli\u003ePaid, deposit or still to pay, with the amount still owed totaled, because a deposit is not a payment\u003c\/li\u003e\n\u003cli\u003eA travel checklist of twenty deadlines counted back from departure, such as passports six months out, antimalarials a month before and check-in two days before, with overdue items flagged and counted\u003c\/li\u003e\n\u003cli\u003eA packing list by category and by person, showing how far through you are\u003c\/li\u003e\n\u003cli\u003eFifteen budget categories and sixty budget lines, with totals per person, per day and days away\u003c\/li\u003e\n\u003cli\u003eOver budget, overdue and unpaid items color themselves\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark mode template edition. Every tab is restyled, not only the dashboard, and both use the same formulas. Each comes filled with a worked trip, budgeted, booked and half spent, and as a blank copy for your own vacation planner, in Excel and in Google Sheets. Ten connected tabs count from the day you go, so nothing is typed twice.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice\u003c\/li\u003e\n\u003cli\u003eNo subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel workbooks run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eWhat happens if my departure date changes?\u003c\/h3\u003e\u003cp\u003eChange the date on Setup. Every itinerary day and every pre-trip deadline counts from it, so they all move with it.\u003c\/p\u003e\u003ch3\u003eHow long a trip can I plan?\u003c\/h3\u003e\u003cp\u003eThe itinerary has 30 days, each split into morning, afternoon and evening. The worked example uses twenty-one.\u003c\/p\u003e\u003ch3\u003eCan I keep my booking references in it?\u003c\/h3\u003e\u003cp\u003eYes. The Bookings tab has 60 rows with the reference, cost and whether each one is paid, on deposit or still to pay.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Both have the same tabs and formulas, and both come in every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597865123934,"sku":"OPX-091","price":25.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/trip-planner-itinerary-spreadsheet-01.jpg?v=1790832449","url":"https:\/\/opxviashop.com\/products\/trip-planner-itinerary-spreadsheet","provider":"OPXVIA","version":"1.0","type":"link"}