Seeking spreadsheet template for planning multiple people/city visits

score:4

Accepted answer

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.

More post

Search Posts

Related post