Releases: famousdavis/spert-normal
Statistical PERT® Normal Edition - Version 5.1.2
On January 8, 2024, I released Statistical PERT® Normal Edition Version 5.1.2, which uses Excel's normal distribution functions to model uncertainty. This new release updates date data values for 2024-2025.
Statistical PERT® Normal Edition - Version 5.1.1
On March 4, 2023, I released Statistical PERT® Normal Edition Version 5.1.1, which uses Excel's normal distribution functions to model uncertainty. This new release updates date data values for 2023-2024.
Statistical PERT® Normal Edition - Version 5.1
On January 1, 2022, I released Statistical PERT® Normal Edition Version 5.1, which uses Excel's normal distribution functions to model uncertainty. This new release makes it easier to modify this spreadsheet and have the correct copyright notice included on each worksheet. It also updated the list of USA federal holidays for 2022-2023 (used on the Scheduler worksheet).
Statistical PERT® Normal Edition - Version 5.0.3
On August 14, 2021, I released Statistical PERT® Normal Edition Version 5.0.3 which added optional call-outs on the Burn-up Chart worksheet, to make it easier for consumers of the burn-up chart to see the optimistic, expected and conservative dates.
Previously, Version 5.0.2 added a lookup for choosing whether you are a "Frequentist" or "Bayesian" which is used for some cell labeling only. Version 5.0.1 added a new "WIP Only" chart on the new CFD Charts worksheet, summed the Duration Days column on the Scheduler worksheet, and made minor formatting improvements.
On June 5, 2021, I released Statistical PERT® Normal Edition Version 5. This major update includes two new features and several minor enhancements:
- NEW! SPERT® Normal Scheduler creates a probabilistic schedule for a project's critical path at either the task or activity level
- NEW! SPERT® Normal - CFD Charts creates a cumulative flow diagram to map a team's workflow process
- Smoother bell-curve graphics that use double the number of sampled data points (200)
- For non-summary bell-curves, a new zoom feature allows fitting the bell-curve inside the Excel combo chart
- Other minor tweaks and enhancements
Statistical PERT® Normal Edition - Version 5.0.2
On June 13, 2021, I release Statistical PERT® Normal Edition Version 5.0.2 which added a new selection to indicate whether the user is a Frequentist or a Bayesian statistics modeler. This choice has no bearing on the Statistical PERT calculations. It only changes whether certain labels refer to a "confidence interval" or a "credible interval."
Previously, version 5.0.1 added a new "WIP Only" chart on the new CFD Charts worksheet, summed the Duration Days column on the Scheduler worksheet, and made minor formatting improvements.
On June 5, 2021, I released Statistical PERT® Normal Edition Version 5. This major update includes two new features and several minor enhancements:
- NEW! SPERT® Normal Scheduler creates a probabilistic schedule for a project's critical path at either the task or activity level
- NEW! SPERT® Normal - CFD Charts creates a cumulative flow diagram to map a team's workflow process
- Smoother bell-curve graphics that use double the number of sampled data points (200)
- For non-summary bell-curves, a new zoom feature allows fitting the bell-curve inside the Excel combo chart
- Other minor tweaks and enhancements
Statistical PERT® Normal Edition - Version 5.0.1
On June 8, 2021, I release Statistical PERT® Normal Edition Version 5.0.1. This is a minor release that added a new "WIP Only" chart on the new CFD Charts worksheet, summed the Duration Days column on the Scheduler worksheet, and made minor formatting improvements.
On June 5, 2021, I released Statistical PERT® Normal Edition Version 5. This major update includes two new features and several minor enhancements:
- NEW! SPERT® Normal Scheduler creates a probabilistic schedule for a project's critical path at either the task or activity level
- NEW! SPERT® Normal - CFD Charts creates a cumulative flow diagram to map a team's workflow process
- Smoother bell-curve graphics that use double the number of sampled data points (200)
- For non-summary bell-curves, a new zoom feature allows fitting the bell-curve inside the Excel combo chart
- Other minor tweaks and enhancements
Statistical PERT® Normal Edition - Version 5.0
On June 5, 2021, I released Statistical PERT® Normal Edition Version 5. This major update includes two new features and several minor enhancements:
- NEW! SPERT® Normal Scheduler creates a probabilistic schedule for a project's critical path at either the task or activity level
- NEW! SPERT® Normal - CFD Charts creates a cumulative flow diagram to map a team's workflow process
- Smoother bell-curve graphics that use double the number of sampled data points (200)
- For non-summary bell-curves, a new zoom feature allows fitting the bell-curve inside the Excel combo chart
- Other minor tweaks and enhancements
Statistical PERT® Normal Edition - Version 4.3
On June 3, 2020, I released a minor update to Statistical PERT® Normal Edition Version 4. The minor updates since January's major release of Version 4 include:
- NEW! Added Team Capacity on the Agile Burnup Chart to show reduced team capacity in future iterations
- Added additional statistics to the Monte Carlo simulation worksheet
- Improved Agile Burnup Chart formatting
- Added formulas to reduce extra steps when using the Agile Burnup Chart
Version 4 of SPERT® Normal Edition adds these new/enhanced features:
- New Monte Carlo simulation tab for simulating 10,000 trials of a single, random variable
- New Agile Burnup chart for creating an agile release forecast
- More subjective judgment options (10) to choose from when determining how likely the most likely outcome really is
- Revised ratio scale modifiers for use with the SPERT Standard Deviation formula
- Enhanced agile forecast tab
- Added a way to use your own, explicit standard deviation, which is especially useful if you have historical data
- Minor formatting enhancements
- A one-click way to ask for help using my free support service
Statistical PERT® Normal Edition - Version 4.2.2
On June 2, 2020, I released a minor update to Statistical PERT® Normal Edition Version 4. The minor updates since January's major release of Version 4 include:
- Added additional statistics to the Monte Carlo simulation worksheet
- Improved Agile Burnup Chart formatting
- Added formulas to reduce extra steps when using the Agile Burnup Chart
Version 4 of SPERT® Normal Edition adds these new/enhanced features:
- New Monte Carlo simulation tab for simulating 10,000 trials of a single, random variable
- New Agile Burnup chart for creating an agile release forecast
- More subjective judgment options (10) to choose from when determining how likely the most likely outcome really is
- Revised ratio scale modifiers for use with the SPERT Standard Deviation formula
- Enhanced agile forecast tab
- Added a way to use your own, explicit standard deviation, which is especially useful if you have historical data
- Minor formatting enhancements
- A one-click way to ask for help using my free support service
Statistical PERT® Normal Edition - Version 4.2.1
On May 26, 2020, I released a minor update to Statistical PERT® Normal Edition Version 4. The minor updates since January's major release of Version 4 include:
- Added additional statistics to the Monte Carlo simulation worksheet
- Improved Agile Burnup chart formatting
- Added formulas to reduce extra steps when using the Agile Burnup chart
Version 4 of SPERT Normal Edition adds these new/enhanced features:
- New Monte Carlo simulation tab for simulating 10,000 trials of a single, random variable
- New Agile Burnup chart for creating an agile release forecast
- More subjective judgment options (10) to choose from when determining how likely the most likely outcome really is
- Revised ratio scale modifiers for use with the SPERT Standard Deviation formula
- Enhanced agile forecast tab
- Added a way to use your own, explicit standard deviation, which is especially useful if you have historical data
- Minor formatting enhancements
- A one-click way to ask for help using my free support service