Download Statistical PERT® templates for Microsoft Excel®.
They’re free
Get occasional tips & tricks plus webinars and new release notifications.
I never sell, rent or share your contact information! Unsubscribe anytime.
Free Webinar
Join me for a free webinar to learn how to create probabilistic estimates using Statistical PERT
Donate
SPERT® Patron
Donate any amount
Statistical PERT is free,
but this site isn’t.
Please be a patron.
Thank you!
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 2023.
United States
United Kingdom
India
Canada
Australia
France
China
Poland
Germany
Netherlands
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 (2016 / 2019 / 2021 / Microsoft 365 – click here if you’re using an older version of Excel).
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 Service 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 Service 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: “© 2015-2024, original copyright holder is 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.1.2, released January 8, 2024, is a very minor change to update the date data values to 2024-2025. Version 5.1 made it easier to legally indicate in the worksheet footers when this spreadsheet is modified by another author (who updated the Change Log worksheet correctly). Version 5.0.3 added 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.3.2, released January 12, 2024, is a very minor change to update the date data values to 2024-2025. Version 3.3. made it easier to legally indicate in the worksheet footers when this spreadsheet is modified by another author (who updated the Change Log worksheet correctly). Version 3.2 added 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® Lognormal Edition, Version 2.0.1, released January 12, 2024, is a slight update to Version 2.0, an upgrade that adds the SPERT Scheduler worksheet. The SPERT Scheduler (which is also available in both the Normal and Beta Editions of Statistical PERT) uses the lognormal distribution to model a project’s critical path uncertainty. Version 1.0, released January, 2022, is a brand new edition of Statistical PERT. This edition uses Excel’s two lognormal distribution functions, LOGNORM.DIST and LOGNORM.INV, to model uncertainty using the lognormal probability distribution. The lognormal distribution has several modeling advantages: one, it requires only a single point-estimate for the uncertainty (either the most likely outcome which is the mode, or the mean which is the arithmetic average); two, it models uncertainty only using positive numbers; three, it can easily represent uncertainties with a long, right-side tail (which is a common occurrence in project management). Statistical PERT Lognormal Edition also uses Excel’s natural log function LN(), to interact with the other lognormal functions.
Statistical PERT® Bootstrap Edition, Version 1.1.5, released January 13, 2024, is a very minor change to update the example workbook data to reflect 2024-2025 dates. Version 1.1 added explanatory labels to the BootstrapData worksheet, and made it easier to legally indicate in the worksheet footers when this spreadsheet is modified by another author (who updated the Change Log worksheet correctly). 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. 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 newsletter to receive occasional 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 newsletter to receive occasional 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® Lognormal Edition
Statistical PERT® Lognormal Edition uses Excel’s two lognormal distribution functions, LOGNORM.DIST and LOGNORM.INV.
Download the SPERT® Lognormal Edition (macro-free) example workbook
Download the SPERT® Lognormal Edition (macro-free) template
Download the Quick Start guide for the Statistical PERT® Lognormal Edition to learn how to use Statistical PERT Lognormal Edition.
Subscribe to my free newsletter to receive occasional 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® Lognormal Edition Version 2 from GitHub.
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 newsletter to receive occasional 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
SPERT® Mobile
Download
Statistical PERT for your smartphone
Soothsayer™
Download Soothsayer™ for Project Risk Analysis
Soothsayer™
Download Soothsayer™ for Project Schedule or Budget Contingency
Soothsayer™ Whitepaper
Read a whitepaper on Soothsayer™ for Schedule Contingency
SimSee™
See how Monte Carlo Simulation (MCS) solves estimation problems by downloading this easy-to-understand spreadsheet
Scrum Budgets Made Easy
Download MyScrumBudget™ and easily calculate your Scrum project’s budget!
SPERT® Cherry Blossom Edition
Download the SPERT® Cherry Blossom Edition and forecast your chance of seeing the Washington DC cherry blossoms at their peak!