Are there spreadsheet templates to help plan a several week visit by 6 family units, covering several locations, when not everyone will be in the same place at the same time? The goal is to see where everyone is at any time, and to see who will be in the same city on any given day.

  • 1
    Wouldn't a calendar be more useful than a spreadsheet? – Gagravarr Mar 22 '15 at 0:15
  • How could a calendar keep track of multiple family units and multiple cities? – Yehuda_NYC Mar 22 '15 at 0:24
  • I have seen companies use a matrix to track where people will be on dates extending out into the future. You could adapt a scheme like that to your purpose without much trouble. – Gayot Fow Mar 22 '15 at 0:40
  • @Yehuda_NYC One colour per family, then add entries like "Smith Family in NYC" and "Jones Family in Paris", then look at the calendar to see where everyone is? – Gagravarr Mar 22 '15 at 11:17
  • @Gayot Fow Can you post an example of such a spreadsheet? – Yehuda_NYC Mar 22 '15 at 15:38

This is an example of a itinerary matix...

enter image description here

It shows three couples on a short trip to Europe.

This example is set for the granularity of one day, but could be increased to morning, afternoon, and evening granularity.

Colour coding is optional. This example uses orange to indicate international travel.

Greenish colours indicate activities in and around London, and pinkish colours indicate activities in and around Paris.

Using this matrix, it's apparent that 'Fred' wants to stay an extra day in London to see the V&A Museum; 'Mary' wants to see Chantilly while others want to see Chartes. 'Francis', on the other hand, wants to visit her long lost uncle. 'John' and 'Fred' have a special thing for Monet, so they want to visit Giverny. As shown, everybody is safely home and well rested for the big 4th of July BBQ and fireworks.

You can add notes, annotations, and call-outs to the matrix as needed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.