One Page Project Manager Excel Template Free Download

The One Page Project Manager Excel Template helps a project manager to manage projects with a single page. The one page project manager covers the task tracking, maintain key dates, task meter, resource load, to do for the PMs, risk and issues tracking.

One Page Project Manager Excel Template Free Download
One Page Project Manager Template

Features and Advantages of the One Page Project Manager Excel Template

  • Covers all the key project aspects in one page.
  • Allows tracking of individual tasks and highlights delayed tasks.
  • Allows capturing of key milestones/dates with a status indicator.
  • Has a task meter which shows how many tasks are on track, concerned or delayed.
  • Captures the resource work load for each resource.
  • Captures top 5 concerns which can be risks or issues.
  • Captures top 5 action items or change requests.
  • Has a notes and to do tracker which highlights tasks which have passed the due date.
  • Can handle a list of 20 pre-defined holidays. Holidays are reduced from the task duration.

Task Tracker Section

  • The task tracker allows up to 21 tasks.
  • Each task has a owner, start date, end date, actual completion, forecast completion and status.
  • All the columns marked in blue are auto populated so should not be changed.
  • The task tracker calculates the Forecast % complete based on task start date, end date and duration.

  • Based on the Actual and Forecast the status is populated. 
  • If the task is on track or ahead then the status is green. If the task is less than 5% behind then the task is marked amber. If the task is lagging behind for more than 5% then the status is marked red.
  • Always copy the previous task to create a new task. Update only the columns marked in yellow. On a day to day basis update the Actual % completion.
Task Tracker
One Page Project Manger - Task Tracker

Milestones, Task Meter and Resource Workload View

  • Milestones and Key dates section allows tracking of key dates and milestones. Each date has a due date and status indicator which will indicate on track, concern and delayed.
  • The Task Meter displays shows the on track, concern and delayed. The graph gets the data from the task tracker status. 
  • The Resource Work Load displays the work allocated to each resource in days. The resource work load graph also gets the data from task tracker.
One Page Project Manager
Task Meter and Resource Work Load

Concerns, Actions and Change Requests Section

  • This section allows tracking of risks and issues within the Top 5 Concerns
  • Each concern has a owner and status which can be On Track, Concern or Delayed.
  • The Open Actions and Change Requests allows tracking of action items and change requests.
  • Each action item and change request has a owner and status which can be On Track, Concern or Delayed.
Concerns, Actions and Change Requests Section
Concerns, Actions and Change Requests Section

To Do and Notes List Section

  • The notes and to do list is specially designed for project managers to keep track of their own tasks.
  • Each task will have a description and due date.
  • The task will be highlighted in red if the task is overdue.
Notes and To Do Action
Notes & To Do List

One Page Project Manager Data Section

  • The data section can be used to set the resources. Populate only resource names. 
  • The workload column is auto calculated.
  • The public holidays can be used to set public holidays.


One Page Project Manager Data Section
One Page Project Manager Data Section

Click Here to Download the One Page Project Manager Template


Swapnil Wale

Written by

Swapnil Wale is an IT Professional based in Sydney, Australia with over 10 years of experience in technology and project management. He is a passionate blogger and focuses on project management and BRMS articles.

0 comments:

Post a Comment

 

© 2013 Techno-PM. All rights resevered. Designed by Templateism

Back To Top
Real Time Web Analytics