Effort-Based Project Forecasting Workbook

By

Format: Evaluation Form / Report

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

People who downloaded this item also downloaded . . .

Members login here:

OR
OR


Not a member yet? Sign up here:

You must have JavaScript and cookies enabled to use this website. Please enable javascript and refresh this page.
How do I enable JavaScript in my browser? | How do I enable cookies in my browser?
  • required fields
  • First Name
    Last Name
  • Pick a password
    Confirm your password
  • please enter the text below:


  • You must have JavaScript and cookies enabled to use this website. Please enable javascript and refresh this page.
    How do I enable JavaScript in my browser? | How do I enable cookies in my browser?

  • projectmanagement.com is accredited under Return Path's Sender Score Certified™ Program. The Sender Score Certified Program helps to increase successful email delivery by requiring senders to adhere to a set of specific email standards. For more information, please see www.senderscorecertified.com.

ADVERTISEMENT

Comments (14)

Please login or join to subscribe to this item
Network:310



Thank you all for the nice comments, hope it will make your life a bit easier - every project manager could use a bit of "easy" every now and then!

Network:23



Great tool. Will see if I can modify it to suit EPC projects.

Network:19



Thanks for Sharing . Nice spreadsheet.

Network:1506



Thanks for sharing. Good useful document.

Network:0

Thanks a lot for sharing.

Network:1695



Many thanks for sharing. I Will take a closer look.
Many thanks,

Network:6418



A good overview.

Network:57



Excellent tool
Thanks

Network:263



Hello.
Many thanks for sharing. Will take a closer look. But my first impression is that it seems quite usefull.
Many thanks,
Paco

Network:86



very useful and excellent doc!

Network:271



Good stuff George! This brings back memories of many hours spent with schedulers to work out a solution. We got to something similar, as I recall. That was lost, so now I will keep yours handy in case the need arises again.

Network:5209



Thank you for sharing.

Network:23



very well structured and easy to use .


Network:100



good doc

ADVERTISEMENTS

I've never heard of a relationship being affected by punctuation.

- Jerry Seinfeld

ADVERTISEMENT

Sponsors