The excel project plan template has some advanced features which help in identifying delayed tasks, traffic light indicators, using predecessors will make any project managers life easy.
|Project Plan Template Excel|
Features of the Project Plan Template Excel
- The Excel Template helps a project manager in creating project plan and tracking with a Gantt view.
- Clearly highlights if the task in the plan is on track, behind or delayed using traffic lights.
- The start date of the timeline is configurable for the entire plan.
- Each task can have a predecessor for dependent tasks which will auto populate the start date.
- PM needs to enter only the start date and effort. The finish date is auto calculated by the planning template.
- When calculating the finish date only weekdays are considered.
- The excel project plan template auto calculates the % Plan.
- There is an option to enter up to 20 holidays in the config section of the template.
- When a day is marked as a holiday it is not counted in calculation for finish date of a task.
- There is an option to enter % complete ( % Act) in the plan.
- The % Plan is indicative of much the the task should have progressed as of this date.
- The status column is a traffic light with green, red and amber depending on the task status.
- When a task starts on a weekend the task is highlighted in red.
- The plan template has a Gantt View on a daily basis and displays the date and day of the week.
- The Gantt View is designed to show tasks in different color for each project phase in the plan.
- The Gantt View timeline in the plan can be changed to show the view over 2 or more days.
- The current date is highlighted in blue on the project timeline for easy tracking.
Some limitations of the Project Plan Template Excel
- As the template is built on excel adding tasks is a manual step in the template.
- The timeline and Gantt are designed for daily view. Even though there is option to have a broader view the timeline works best on a daily basis.
- The project phases cannot be tracked in the plan. For example there is no way of knowing start date and end date of Requirements Phase or Build Phase.
- Individual leaves cannot be factored into the planning process.
- The coloring of the Gantt Chart is designed using conditional formatting so there is limited number of project phases which can be created with different colors.
Basics of the Excel Project Plan Template
- In the picture below 1 is Project name.
- 2 is Start for the view - Not necessarily the start of the project but the start date of the timeline view.
- 3 is Timeline view setting - This is number of days for timeline. By default it is one day so shows the Gantt of a daily basis. Please note that the broader the timeline number the less accurate the timeline.
- 4 is the project timeline. 5 - is today's date which is highlighted as blue in the template.
- The project plan template allows up to 20 project holidays. The holidays can be added under the data tab in the template.
|Project Timeline Basics|
How to create Project Phases and Tasks
It is recommended that when you want to create a new phase or task you should copy the existing project phase or task. This is important to do this as the tasks contain numerous formula and conditional formatting settings which may not work if you try to create them on your own.
Techno-Tip : Always try to reuse the existing template structure and tasks by copying and pasting rows or simple rename the tasks and change the dates. It is best to rename the project phases and tasks rather than trying to create new.
- Each project task has a task ID(#), Task Name, Resource Name, Predecessor (Pre), Start, Finish, Effort ( Days), Progress so far (% Act), Planned Progress ( % Plan) and Status. Some of the fields like task name, resource name are self explanatory.
- Task ID should always be sequential and unique across the project.
- Predecessor column should have the task id for the task that should finish before the current task starts. This is mandatory except for the first task. If you don't want to use the predecessor then you must delete the contents in the start date including the formula and enter the date of your choice.
- Start date except the first task are driven by predecessors. The start date will be end date of the predecessor task plus 1. End date is auto calculated and reflected in the Gantt. The calculation for end date will consider only weekdays and ignore the holidays. DO NOT MODIFY THE END DATE MANUALLY.
- Effort is total effort required to complete the task. This is the effort and not duration. % Act is the Actual progress till now. This value should be coming from the project team members. % Plan is ideal % complete. The % Plan is AUTO CALCULATED and should not be changed.
- Status is the column which will indicate the status of the tasks. If the task is on track then the signal will be green, will be yellow if the task is behind by less than 5 % and red if the task is delayed by more than 5%.