Project Pipeline Excel Template Free Download

One of the key challenges when managing a portfolio of projects is to make sure that the projects start on time. If the project pipeline is not managed then there is a good chance that the project funding and resources will be lost. This tracker will help a PMO or Portfolio Manager to keep track of the incoming projects.

Project Pipeline Tracker
Project Pipeline Tracker

Features or Things to know About the Pipeline Tracker

  • Provides a birds eye view of the projects in pipeline with start date and budget.
  • Captures and utilizes key project initiation activities or project pre-requisites like Business Case, Timeline, Funding and Resourcing.
  • Project Name and Comments columns are self explanatory.
  • Has an indicator column which indicates if the project is starting in one month(red), 3 months(amber) or beyond 3 months (green).
  • Has an overall Status field which indicates if the project is ready. The Status is set Ready in Green when all the pre-requisites are completed successfully.

  • The dashboard displays the number of projects starting in next 1 month, 3 months, 6 months and beyond 6 months.
  • The columns are automatically sorted in chronological order based on start date when the sheet is open.So, if a project with start date in the next few days is added to the bottom of the bottom list then the next time the sheet is opened the project will be top. Please enable macros if you want the sorting to work.
  • If you wish to manually sort the column then press Ctrl + q. 

Project Timeline Template Explained
Project Timeline Template Explained

Click Here To Download the Project Pipeline Tracker

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