Download Statistical PERT® templates for Microsoft Excel®.
They’re free

Join My Newsletter

Get monthly tips & tricks plus webinars and new release notifications.
I never sell, rent or share your contact information! Unsubscribe anytime.

Top 10 Countries

Each year, Statistical PERT is downloaded by thousands of people living in over 100 countries.
Here are the Top 10 countries for 2020.

United States
United Kingdom
India
Canada
Poland
Brazil
Australia
Germany
France
Italy

Statistical PERT®  (SPERT®) is a freely licensed, probabilistic, estimation technique that uses the built-in statistical functions of Microsoft Excel®.  Use Statistical PERT to estimate uncertainties with bell-shaped risk properties, like:  task duration, work effort, revenue, expenses, agile release dates, project portfolios, event attendance, and more.

There is nothing to install.  Just download a Statistical PERT example workbook or template, then open the downloaded files with Microsoft Excel (2010 / 2013 / 2016 / 2019 / Microsoft 365).

All Statistical PERT downloads are FREE to use, modify and share!  No registration, no macros, no adware, no cost, and no hassle!

Before downloading any files from this site, please read this site’s Privacy Policy, Warranty Disclaimer, and Terms of Agreement.  If you choose to download any files from this site, you are giving your express acceptance of this site’s Privacy Policy, Warranty Disclaimer, and Terms of Agreement.  If you do not agree with any of these, please do not use this site or download any files from this site.

Since 2015, thousands of project managers, business managers, entrepreneurs, Scrum Masters, agile coaches, university professors, college students, and other business professionals from dozens of countries around the world have downloaded and used Statistical PERT to estimate uncertain future outcomes.

The Project Management Institute (PMI) offers Statistical PERT templates to its membership through its sister site, ProjectManagement.com, along with published articles on Statistical PERT like this one and this one and this newer one published January, 2020 and this latest one published February, 2020 (note:  you must be a PMI member to read these articles).  Thanks to PMI, tens of thousands of project professionals worldwide have discovered and downloaded the freely licensed Statistical PERT example spreadsheets, with hundreds more each week who discover Statistical PERT.

Important note:  All spreadsheet files downloaded from this site are distributed under the GNU General Public License published by the Free Software Foundation.  You may redistribute any downloaded spreadsheet files and/or modify them under the terms of version 3 of that license, or (at your option) any later version.  Statistical PERT® and SPERT® are protected, federally-registered trademarks. Soothsayer™, Sagacity™, SimSee™, and MyScrumBudget™ are non-federally-registered trademarks. If you modify, in any material way, any spreadsheet file downloaded from this site, you agree to remove these trademarked names from the modified spreadsheet(s). On both verbatim and modified copies of spreadsheet files that you download from this site, you must always display the original copyright notices showing the spreadsheet’s copyright year and and copyright holder information (example: “Original Copyright © 2015-2021, William W. Davis, MSPM, PMP”). Moreover, a modified spreadsheet must clearly identify the changes you or others made, in accordance with the GNU General Public License. If you have questions about what it means to materially modify a spreadsheet, please contact me.  All spreadsheet files on this site are freely available for downloading in the hope that they will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

Statistical PERT® Normal Edition, Version 5.0.3, released August 14, 2021, is a very minor update which adds optional call-outs on the Burn-up Chart worksheet, to make it easier for stakeholders to read the probabilistic delivery dates. Version 5.0.2 added a new lookup so the user can indicate whether they are a Frequentist or a Bayesian statistical modeler (or whether they don’t know or care). Version 5.0.1 added some very minor formatting improvements and a new “WIP Only” chart on the CFD Charts worksheet. Version 5 is a major update to the Normal Edition. There are two new features of Version 5. The first major feature is the SPERT® Normal Scheduler worksheet. The Scheduler worksheet lets users create a probabilistic schedule by estimating the time duration of a project’s critical path. The second major feature is the SPERT® Normal – CFD Charts worksheet which lets users create a cumulative flow diagram (CFD) that visualizes a team’s workflow. Version 5 also has improved bell-curve graphics with double the number of sampled data points. Statistical PERT Normal Edition uses Excel’s two normal distribution functions, NORM.DIST and NORM.INV to create probabilistic estimates.

Statistical PERT® Beta Edition, Version 3.2, released June 9, 2021, is a minor update that adds double the number of random data points used to create the tri-colored, bell-shaped charts. These charts now have a sharper, smoother appearance. Other minor tweaks are also included to improve consistency and appearance. Version 3 has two new features and one enhanced feature.  The first new feature is a Monte Carlo simulation worksheet for modeling a single, random variable using the beta distribution.  Another new feature is SPERT® Beta Scheduler, which allows for easy, probabilistic scheduling of plan-driven projects.  Finally, the Agile Forecast worksheet is enhanced to allow for a side-by-side comparison of up to three scenarios, making it easier to do what-if analysis.  Statistical PERT Beta Edition uses Excel’s two beta distribution functions, BETA.DIST and BETA.INV to create probabilistic estimates, plus the normal distribution functions, NORM.DIST and NORM.INV, to calculate probabilities assuming the Central Limit Theorem for summary rows.

Statistical PERT® Bootstrap Edition, Version 1.0.1, released September 9, 2021, is a brand-new edition of Statistical PERT. The Bootstrap Edition uses statistical bootstrapping to simulate what might get done in the future based upon what has actually been done in the past. This edition of SPERT is useful for agile team forecasting (both Scrum and Kanban teams) who have historical records of what their team has accomplished over at least 6 or 8 iterations. The 1.0.1 release clarifies the meaning of certain Excel functions in pop-up notes.  Bootstrapping will simulate future iterations by randomly selecting values from the team’s historical record. Read more about statistical bootstrapping here.

SPECIAL RELEASE for smartphone users – SPERT® Mobile!  Download this special version of Statistical PERT Normal Edition that makes it easy to create probabilistic estimates right on your iPhone or Android smartphone.  You must have Excel Mobile installed on your device to use Statistical PERT.  Excel Mobile is a free download on iTunes and Google Play.

Are you using an iPhone, but don’t have the free Microsoft Excel app for iPhone?  Download it from Microsoft now.

Are you using an Android smartphone, but don’t have Excel installed?  Download it from Google Play now.

Statistical PERT® Normal Edition

Statistical PERT® Normal Edition uses Excel’s two normal distribution functions, NORM.DIST and NORM.INV.

Download the SPERT® Normal Edition (macro-free) example workbook

Download the SPERT® Normal Edition (macro-free) template

Download the Quick Start guide for Statistical PERT® Normal Edition to learn how to use Statistical PERT Normal Edition.

Subscribe to my free, monthly newsletter to receive tips & tricks and new release notifications via email.

Learn more about Statistical PERT!  Attend my next, free webinar or check out these site resources.

Can’t download from this site?
Try downloading SPERT® Normal Edition Version 5 from GitHub or PMI’s ProjectManagement.com.

Statistical PERT® Beta Edition

Statistical PERT® Beta Edition uses Excel’s two beta distribution functions, BETA.DIST and BETA.INV.

Download the SPERT® Beta Edition (macro-free) example workbook

Download the SPERT® Beta Edition (macro-free) template

Download the Quick Start guide for the Statistical PERT® Beta Edition to learn how to use Statistical PERT Beta Edition.

Subscribe to my free, monthly newsletter to receive tips & tricks and new release notifications via email.

Learn more about Statistical PERT!  Attend my next, free webinar or check out these site resources.

Can’t download from this site?
Try downloading SPERT® Beta Edition Version 3 from GitHub or PMI’s ProjectManagement.com.

Statistical PERT® Bootstrap Edition

Statistical PERT® Bootstrap Edition uses statistical bootstrapping to simulate future iterations for both Scrum and Kanban teams. Using those teams’ historical record of getting work completed, the Bootstrap Edition can create a probabilistic forecast of what they might get done in the future.

Download the SPERT® Bootstrap Edition (macro-free) example workbook

Download the SPERT® Bootstrap Edition (macro-free) template

Download the Quick Start guide for the Statistical PERT® Bootstrap Edition to learn how to use Statistical PERT Bootstrap Edition.

Subscribe to my free, monthly newsletter to receive tips & tricks and new release notifications via email.

Learn more about Statistical PERT!  Attend my next, free webinar or check out these site resources.

Can’t download from this site?
Try downloading SPERT® Bootstrap Edition Version 1 from GitHub.

Bonus Downloads

Sagacity™

Download
Sagacity™
for Covid-19
risk assessment

Soothsayer™

Download Soothsayer™ for Project Schedule or Budget Contingency

SimSee™

See how Monte Carlo Simulation (MCS) solves estimation problems by downloading this easy-to-understand spreadsheet

New! SPERT® Lognormal Edition!

Try SPERT® Lognormal Edition to easily use the lognormal distribution! (Caution: This new edition is still under development)

SPERT® Cherry Blossom Edition

Download the SPERT® Cherry Blossom Edition and forecast your chance of seeing the Washington DC cherry blossoms at their peak!

SPERT_HD_Page_Logo