one page - test

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. The template has been designed to fit into one excel sheet and easy to print. Other important KPI have also been designed to be visible easily. 


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 capturing of key milestones/dates with a status indicator.
  • Has a task meter which shows how many tasks are on track, concerned or delayed.
  • Allows tracking of individual tasks and highlights delayed tasks.
  • 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.


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.


Share:

PMO STARTER KIT - 11 Templates to a Successful PMO Project Management Office Set up

PMO Project Management Office

Statistics can be cruel: according to several studies, most Project Management Offices (PMOs) are shut down just after 3 to 4 years after their implementation. While many reasons can lead to this scenario, a poor PMO start-up is typically one of the main root causes.

PMO STARTER KIT, PMO Project Management Office
PMO Starter Kit Step by Step Timeline
Just like projects, the front-end activities of a PMO implementation are critical to its success, laying the foundation for what to expect from the PMO going forward. In fact, most of the challenges that can later determine the life expectancy of a PMO arise from the very beginning of its establishment, such as:

  • Poor sponsorship
  • Unclear need for a PMO
  • Unclear objectives
  • Lack of direction for the PMO
  • Poor visibility over the PMO performance
  • Unclear roles and responsibilities
  • Lack of awareness of what the PMO is and does
  • Poor recognition of the PMO’s value 

No wonder that the first stages of the PMO setup are so important!

Creating a PMO from scratch can be a hard-working task, I know, and it should be emphasised that no PMO is created equal, they are all different. However, while there is no magical pill or recipe that you can follow to guarantee the PMO success, there are acknowledged steps or best practices that can guide you, like the importance of having a PMO’s catalogue of services or identifying the key performance indicators that are going to be used to measure and demonstrate the PMO’s value.

Based on this set of recognized best practices, we have developed a PMO Starter Kit to help you setting up your PMO in the right direction and equipping you with a fighting chance. That’s right, we have done all the paperwork for you, ready to be used in your new PMO!

PMO Life cycle and PMO Starter Kit 

The PMO Starter Kit aims to assist you in answering the following key questions and in building a solid foundation for your greenfield PMO:

PMO Life Cycle, PMO Starter Kit
PMO Life Cycle


Addressing the PMO implementation as a project on its own and covering the PMO life cycle, the PMO Implementation Starter Kit includes templates for:

  1. PMO Implementation Timeline: a great visual tool to communicate with your stakeholders and understand how far you are in your PMO implementation project
  2. PMO Business Case: all you need to justify the need for a PMO before the business, with a view on anticipated costs and benefits resulting from the PMO implementation
  3. PMO Charter: PMO charter is a key document that clarifies the PMO objectives and scope and formalizes the existence of the PMO in the organization
  4. PMO Service Catalogue: document the menu of services that the PMO will be able to offer to the project management community
  5. PMO Stakeholder Plan: remember that your PMO was created to serve someone – identify who these individuals are and how you are going to manage their expectations
  6. PMO Roles: as important as the PMO’s functions are the competencies of the PMO’s team
  7. PMO Roadmap: to be successful, your PMO needs to understand where it is and where it wants to be, that is, its roadmap
  8. PMO Action Plan: this useful checklist will ensure that nothing will fall through the bricks and that all key aspects are being covered in the PMO’s implementation
  9. PMO KPI Dashboard: measuring the performance of the PMO is as important as measuring the performance of the portfolio of projects and this tool will assist you to do just that
  10. PMO Communication Plan: most PMOs fail not because they are not delivering value but because they are not communicating it well enough, so we have prepared a plan to address this frequent problem too
  11. PMO Kick-off Meeting: congratulations, initiation and planning activities are completed, and you are ready to kick-off the PMO. Let’s do this!
By using our set of pre-defined templates – which should be tailored as required, by the way - you can save time and focus on what really matters when setting up a PMO: managing relationships and start building the necessary PMO buy-in from the different stakeholder groups!

Don’t get me wrong: having appropriate templates is useful but it is just the beginning and a small part of what is involved in the establishment of a PMO. There’s much to be done, from coaching project teams to recruit the PMO team to create scheduling guidelines, so be brave and do not address the PMO implementation’s project lightly. It may sound daunting in the beginning, but you will later be happy that you didn’t fast-track these steps – after all, would you live in a house whose foundation was built in a hurry?

You have the tools and you have the mindset – now go and build the best PMO ever built!

Good luck and keep us posted of your journey, we would love to hear from you.




Share:

Status Reports

Popular Posts

Welcome to Techno-PM

Swapnil Wale founded Techno-PM in 2014 in Sydney, Australia.

Techno-PM started as a blog but in a short while has grown into a full-fledged company. Techno-PM is now a registered Australian business entity with ABN: 6361 5935 469 with a team of expert project managers and web design team.

Techno-PM offers a variety of template packages and downloads. All the templates we provide come with a detailed user guide and designed by experts.

Get In Touch

Name

Email *

Message *

Excel Project Dashboard

Excel Capacity Planner

Master Excel Project Tracker

Multiple Project Tracker Excel

Template Categories

One Page Project Manager

RAID Templates

Our Best Templates

Project Planners and Trackers

Labels

Unordered List

  • Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
  • Aliquam tincidunt mauris eu risus.
  • Vestibulum auctor dapibus neque.

Pages

Theme Support

Need our help to upload or customize this blogger template? Contact me with details about the theme customization you need.