Project Calendar Excel Template
Review: 5 - "A masterpiece of literature" by John Doe, written on May 4, 2006
I really enjoyed this book. It captures the essential challenge people face as they try make sense of their lives and grow to adulthood.
The goal is to visualize all relevant meetings (like Steering or Project Boards, Project Team meetings, daily Scrum calls, etc,) and deadlines (like delivery dates of pre-reading documents) of a project in a weekly overview:
Step 2: Go to the worksheet [Control] and define the start date of your project in cell C4. Select a Monday, if you want the calendar view to show the week from Monday to Sunday (the view Europeans are used to) or a Sunday, if the view shall display the week from Sunday to Saturday (usually preferred in the US)
Step 3: Go to the worksheet [Calendar Data] and delete everything inside the table right to the column [ID]:
Now insert your own data. The table structure is very simple and should be self-explanatory. Just 2 hints:
For weekly and bi-weekly items, the weekday of [Start Date] defines the weekday of this meeting or deadline.
In column [End Date] you can define, from when on this meeting or deadline will not be relevant anymore. For the items running throughout the entire project, you define the end date of the project as the [End Date]. For temporary meetings, e.g. like meetings within a 2-weeks sprint, you set the end date of this meeting series to the date of 2 weeks after the start date.