Statistical PERT® (SPERT™) Estimation Worksheet for Task Duration Forecasting
Format: Evaluation Assessment / Evaluation Form
Update for 2022! 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.
- NEW for 2022: 2022-2023 federal holidays and other time-off dates plus other minor tweaks
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
Risk Management Starts Sooner Than You Think
byGetting Beta with Statistical PERT
byStatistical PERT™ (SPERT™) Estimation Worksheet
deliverable
by
Statistical PERT® Beta Edition
deliverable
by
People who downloaded this item also downloaded . . .
Project Plan/Project Definition
PREMIUM deliverable
At-a-Glance Weekly Project Status Report
PREMIUM deliverable
Communication Plan
PREMIUM deliverable
Premium Content
PMI Membership
$129 /year
$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,893
Downloads
Reviews (20)
Login/join to subscribe
Page:
Page:
ADVERTISEMENTS
"The purpose of art: to make the unconscious conscious." - Richard Wagner |