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,729
Downloads

Reviews (7)

Login/join to subscribe
ADVERTISEMENTS

"Imagination is more important than knowledge, for knowledge is limited while imagination embraces the entire world."

- Albert Einstein