Have spreadsheet, will travel

Ah…the joy of Excel

In the world before the pandemic, Sue had booked a trip to Italy with her niece as a high school graduation gift. Unfortunately, the COVID-19 virus caused her to cancel the trip and her niece is not available for a trip this summer. We have about $3,000 of flight credits that we need to use up this year, so we decided to go out on a limb and book a trip for the summer. As you all remember, before we go anywhere, I start a spreadsheet and while I am a little out of practice, here is my first stab at a preliminary itinerary for our trip to France.

On an accounting geek side note: Since we are using flight credits to pay for the tickets, I am currently meditating on how to list the price for the flights. One one hand, if we are looking at this sheet as a measure of the cost of the trip, then I should include the price of the flights. On the other hand, if we are looking at this as a list of the amount of cash we will be spending for the trip and since the flight credits are use it or lose it, then perhaps I should exclude the cost of the flights. Just a quick meditation on the accounting for the trip. Feel free to weigh in if you choose.

Preliminary trip plan

I think we previously mentioned that Sue has a friend who lives in Paris. Last year she and her wife moved out of the city to Burgundy. We decided (somewhat uninvited?) to go and visit them. In outline, we plan to fly into Geneva, visit Burgundy, drive down through Provence, along the Cote d’Azur and up into the French national parks to do some hiking in the Alps and then back to Geneva. Our thought is that if we are both vaccinated we can safely travel, but perhaps this isn’t the time to go romping around the cities and visiting crowded museums and windy little streets. So instead, we will plan to spend much of our time seeing Sue’s friend, driving around the countryside (perhaps visiting a winery or ten?), and hiking in the Alps.

Right now we are doing our usual planning process which consists of us reading anything we can about places that may look interesting and writing notes down (usually on little slips of paper or Post-It notes). At some point we will collate them and figure out which ones make the cut. We usually end up with about three times the number of things that we can possibly manage in the time that we have, so hand-to-hand combat between Sue and myself ends up being the deciding factor. Yes, Sue always wins, but that is because she fights like she is from Queens and I fight like a gentleman. I created a very preliminary list of National Parks that look interesting and a few other places I have heard about/see somewhere etc. Sue has begun to read about places and we will, at some point soon start to make a plan. If anyone has suggestions, please feel free to let us know.

Who knows, by the time we finish the plan, for all we know we will spend three weeks in Italy instead. 😉

3 thoughts on “Have spreadsheet, will travel

  1. Rich M

    Flight credits are clearly a ‘sunk cost’, or perhaps ‘sunk value’.

    In any event, they shouldn’t count in calculations as there is no way to recover them.

    If you’re considering alternative trip itineraries, which could also use the credits, then it would be comparison of total trip value to you (inclusive of flights that will appear ‘free’) vs total cost of each alternative trip.

    Hope that’s interesting ….really an excuse to say hi!

    Good to hear from you.

    How life in Maryland?

    Rich

    On Sun, Mar 14, 2021 at 8:46 AM Doing It On The Road wrote:

    > Steven posted: ” Ah…the joy of Excel In the world before the pandemic, > Sue had booked a trip to Italy with her niece as a high school graduation > gift. Unfortunately, the COVID-19 virus caused her to cancel the trip and > her niece is not available for a tr” >

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s