Schedule Risk Analyzer Pro
Excel tool for schedule risk analysis on your real project network. SRA Pro recalculates your plan 10,000 times, with three-point durations and risks that sometimes occur and sometimes do not, and gives the finish dates you can commit to at P50, P80 and P90, plus the activities and risks that move the date.
WHAT IT ANSWERS
- Which finish date can we commit to, and with what confidence?
- Which activities and risks push the date out?
- Which risk response saves the most days?
YOUR REAL SCHEDULE NETWORK
- Full CPM network with FS, SS, FF and SF relations and lags; the critical path is recalculated in every iteration
- Up to 200 activities and 1,000 relations
- Up to four working-day calendars with holiday lists
- Three-point duration per activity (minimum, most likely, maximum), drawn from a Beta-PERT distribution
- Up to 50 risks with a probability and a delay in days, mapped to the activities they hit with a weight from 0 to 1
- Optional correlation between activities and between risks
- + ADD RISK adds one risk and links it to the activities you tick; DELETE RISK removes a risk after you confirm
- NEW PROJECT empties all inputs and results for your own schedule
PRIMAVERA P6 IMPORT
- Reads a P6 XER export: activities, logic, calendars and WBS
- Validated on real exports from P6 versions 5.0, 6.0, 15.2 and 24.12
- WBS filter for schedules of more than 200 activities
- Import log that shows what came in and why
- Import guide, a test schedule and its expected import result are included
- Other planning tools: a client intake form that mirrors the tool cell for cell
CONFIDENCE LEVELS
- P50, P80 and P90 finish dates against the plan date, on the Control Center
- S-curve with P10 to P95 markers and a percentile table: read the probability of any target date
- Per activity the P10, P50, P80 and P90 of its simulated dates, in a probabilistic Gantt chart
- Target assessment: the probability of finishing on or before your target date, rated ON TRACK, AT RISK or CRITICAL
DRIVERS AND MITIGATION
- Criticality: the share of iterations each activity spends on the critical path
- Tornado of the largest drivers of the spread
- Delay in days per risk
- Mitigation ROI: the days gained on the P80 for each risk you eliminate
- Histogram of finish dates with the plan date and the mean marked
REPORTING AND GOVERNANCE
- Word management report and PowerPoint board pack, one click each, on Windows
- Interpretation in the report is computed from the results
- 10,000 iterations by default; fast mode with 5,000 while you tune the model; technical maximum 50,000
- Fixed seed and an audit log of every run
VALIDATED AND TRANSPARENT
- CPM and Monte Carlo engine rebuilt independently in Python: the deterministic date reproduces exactly, the percentiles within sampling error
- The Python verification script and the P6 import reference script ship with the product
- No sheet or workbook protection, by design, so the model can be audited
- Installation check: the reference case returns plan 26 Oct 2028, P50 10 May 2029, P80 21 Jul 2029 and P90 29 Aug 2029
IN THE PACKAGE
- For Windows: the Professional workbook with P6 import, the Standard workbook without it, and a Demo (25 activities, 2,000 iterations, no P6 import)
- macOS versions of the same workbooks (not yet field-tested on a Mac)
- Complete User Guide A to Z, Quick Start and Reference Card, Ten-Minute Briefing and macOS Installation Guide
- P6 XER Import Guide with a test schedule and its expected result
- Client intake form, pre-analysis questionnaire, showcase and the DHN-380 use case
- Example Word reports and PowerPoint board packs, plus a board pack template
- Verification Note, Product Quality Brief, System Requirements and license documents
- A second zip with the step-by-step tutorial video and the overview video
REQUIREMENTS AND LICENCE
Built and tested for 64-bit Microsoft Excel for Windows 10 or 11 (Microsoft 365, Excel 2024, 2021 or 2019), with macros enabled. 32-bit Excel is not supported. The report and the board pack need Word and PowerPoint for Windows. Runs offline; nothing is sent or collected.
Mac: the package contains macOS workbooks for Excel for Mac version 16 (Microsoft 365) and a macOS Installation Guide, but the tool has not yet been field-tested on a Mac. The simulation, the charts and the P6 import are in the macOS workbooks; the Word report and the PowerPoint board pack are not available on a Mac and are generated on Windows only. Try the free demo first.
Perpetual licence for one named user on up to two devices; twelve months of free updates.
For business and professional use only. SRA Pro is a decision-support tool: results depend on the quality of your inputs. By buying you accept the Quantil License Agreement in the package. You may not modify, unlock, extract or reverse engineer the tool or its code, including with automated or AI tools.