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

By PMI South Florida Chapter

Format: Evaluation Assessment / Evaluation Form

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.

Related Content

People who downloaded this item also downloaded . . .

Premium Content
PMI Membership
$129 /year
(plus $10 application fee)
Sign up 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

6,921
Downloads

Reviews (7)

Login/join to subscribe
ADVERTISEMENTS

"Karate is a form of martial arts in which people who have had years and years of training can, using only their hands and feet, make some of the worst movies in the history of the world."

- Dave Barry

ADVERTISEMENT

Sponsors