Project Management

Statistical PERT® (SPERT™) Estimation Worksheet for Task Duration Forecasting

By PMI Washington, DC Chapter +1

Format: Evaluation Assessment / Evaluation Form

Update for 2021! This spreadsheet has worksheets showing the results of a Monte Carlo simulation on a sample project's work effort hours, and a companion estimate using Statistical PERT.  This way, you can see how you can use just the built-in functions of Microsoft Excel to do probabilistic, risk-based estimation. Textbox comments have been added to the worksheets to aid in understanding. Use this in conjunction with the article Risk Management Starts Sooner Than You Think.

Version 5 includes:

  • SPERT Normal Scheduler, which lets project managers create a probabilistic schedule by estimating their project's critical path at either the task or activity level
  • SPERT Normal - CFD Charts, which creates a visual picture of an agile (or any other) team's workflow process using a dynamically-drawn, cumulative flow diagram (CFD). CFDs are popular among some agile teams who use a Kanban board and are interested in their flow.

Version 4 included these new features:

  • New Monte Carlo simulation worksheet simulates a single, random variable 10,000 times, then charts the results using a dynamic histogram
  • New agile burn-up chart visually forecasts three probabilistic agile delivery dates using historical data
  • Specify an explicit standard deviation for any uncertainty on any worksheet

Related Content

People who downloaded this item also downloaded . . .

Premium Content
PMI Membership
$129 /year
(plus $10 application fee)
Sign up for PMI Membership to download this deliverable and get unlimited access to our library of webinars, time-saving templates and more.
PMI Membership perks include job opportunities, local chapters, respected publications, and standards.   Learn more
Already a PMI Member? Log in now.

ADVERTISEMENT

9,506
Downloads

Reviews (13)

Login/join to subscribe
Page:
Page:
ADVERTISEMENTS

Whenever you are asked if you can do a job, tell 'em, "Certainly, I can!" Then get busy and find out how to do it.

- Theodore Roosevelt

ADVERTISEMENT

Sponsors