Effort-Based Project Forecasting Workbook

Home  >  Deliverables  > 

Effort-Based Project Forecasting Workbook

( Template )

Login/Register to download this item








Format: Evaluation Form / Report
Contributed by: George Jucan PMP

The included sections describe the manual and automated steps performed to be able to display the included graph. The workbook consists of four interdependent spreadsheets, ordered with the most used first:

Read Me--containing instructions for tool usage
Project Status and Forecast--main page, summarizing all detailed data from the other spreadsheets
Status Reporting--used to track the percent complete for each activity in the schedule and calculate the project aggregated percent complete.
Project Plan--populated when the project planning is complete, equivalent of a project baseline.
Task_Export_Table--working spreadsheet for importing data from other tools such as MS Project.

This workbook--used in conjunction with the Effort-Based Project Forecasting article and sample project plan--can be used standalone or can be populated from a project management software such as MS Project. It requires as input a project schedule with all activities having a defined start and end time, duration and scheduled effort (based on duration, resources and allocation percentage). For exemplification, a simple software project template created in MS Project (included in the download) was used.

Related Content
Effort-Based Project Forecasting - by George Jucan, MSc, PMP, OCP
Sample Project: Effort-Based Project Forecasting

Users who downloaded this template also downloaded . . .
Project Plan/Project Definition  ( Plan - Template)
At-a-Glance Weekly Project Status Report  (Template)
Communication Plan  ( Plan - Example)



sponsored announcements and special offers
You can do this!
Earn your master's degree in project management without putting your life on hold at GoUWP.com!
Apply today at GoUWP.com for 100% online courses, 45 PDUs each. No entrance exam. University of Wisconsin- Platteville’s MS in Project Management is globally accredited by PMI. Combine academics and real-world scenarios for a 360-degree education.
If you have a distributed team, what are you trying to achieve with Agile approaches? Isn't Agile more for co-located teams? There are eight key benefits to working in a distributed Agile environment. A new report from ProjectsAtWork looks at each of those benefits – and how you can achieve them.
Most business and IT executives agree that any company able to rapidly deliver software of high and predictable quality with minimum budgets enjoys a significant advantage. However, practical experience shows that the challenges associated with software quality remain largely unsolved. Download the white paper Uplift Quality with Requirements Driven Testing to learn fundamental principles of Requirements Driven Testing.



"If they have moving sidewalks in the future, when you get on them, I think you should have to assume sort of a walking shape so as not to frighten the dogs."
- Jack Handey