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.
This is an example of a itinerary matix...
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.