SpreadsheetMan Planners
Event & Travel Itinerary Daily Planner Spreadsheet
This Google Sheets spreadsheet is great for planning trips, events, vacations, travel or anything that requires day-by-day and time-slot based planning. Invite others to collaborate with you to plan the trip and then let friends and family view it so they know where you'll be. While it's super easy to plan in a day-by-day and time-by-time matrix (table), The best part is that and AGENDA VIEW is created automatically for you, giving a simpler summary to read and a smaller view for mobile access!
The other best part ;) is that you can share the planner online using the Google Sheets version so that you can plan collaboratively with other people! This is the most important feature for those of you who plan a lot of trips, events, travel or other things related to personal or professional life: Collaborative event planning !
STEP 1a - ACTIVITY Method:
The first method of planning is by "Activites" that you can define. These are general time-slots throughout the day, which might not be specific times, but are more like segments of each day - like Breakfast, or Lunch or Travel or Transportation.
Enter the activity segments down the left side...
Enter just the first day of the plan and the other dates are automatically filled in for you.
Then you just fill in each day's activities in the table - day by day!
STEP 1b - TIME Method:
The second method of planning is by "TIMES" that you can adjust to your specific plan. Enter the START TIME only, and the INCREMENT (in minutes) that you want to use to fill in the rest of the times - and the times are all filled in automatically!
Enter just the first day of the plan and the other dates will be automatically filled in for you.
Then you just fill in each time slot activity in the table for each day in your plan!
The Automatic Agenda Views
ACTIVITY-based Agenda:
For the Activity-based plan, there will be an agenda which is automatically created on another sheet - which outlines, for each day, the activities for that day - step-by-step.
TIME-based Agenda:
For the Time-based planners, the agenda which is automatically created outlines the activities for that day - within each time-slot.