Forensic P6 Schedule Analysis, Directly in Excel
Stop reconstructing complex delay claims in manual spreadsheets. DelayLens is a native Excel add-in for Primavera P6 XER files that compares updates, isolates what moved the finish date, and explains why.
Forensic Delay Analysis in Spreadsheets Is Broken
When major capital projects slip, claims consultants and planning engineers spend weeks exporting raw P6 data, writing fragile lookup formulas, and manually comparing schedules.
Manual CPM Logic Reconstruction
Excel does not compute Critical Path Method logic natively. Tracking how out-of-sequence work, calendar overrides, and driving relationships shifted completion dates across dozens of updates requires days of tedious cross-checking.
Disputed Entitlement & Concurrency
Separating contractor delays from owner-caused delays and neutral events requires strict adherence to forensic protocols. Without structured tools, bifurcating progress delay from revision delay is prone to dispute.
Lack of Verifiable Evidence
Ad-hoc spreadsheet models lack cryptographic integrity checks. In dispute resolution, arbitrations, and litigation, unverified copy-pasting invites immediate credibility challenges from opposing experts.
A Forensic CPM Engine Inside Microsoft Excel
DelayLens combines an exact round-trip XER reader and writer and a CPM engine that reproduces P6's dates with the analytical flexibility of Microsoft Excel. Open XER files directly without P6 client licenses or database connections.
Automate Forensic Delay Methodologies
Execute AACE International Recommended Practice 29R-03 Methods (MIP 3.1 through 3.9) including Time Impact Analysis (52R-06 / MIP 3.6), Collapsed As-Built (MIP 3.8 & 3.9), As-Planned vs As-Built (MIP 3.1 & 3.2), and Contemporaneous Windows Analysis (MIP 3.3 & 3.4).
Isolate Progress Delay from Revisions
Use Half Step and Delay Trend analysis across series of schedule updates. Separate finish date slippage caused by slow site progress from changes to logic, durations, calendars, and added activities with mathematical precision.
Audit Schedule Integrity & Critical Paths
Run comprehensive Schedule Checks evaluating float bands, constraints, open logic, circular loops, out-of-sequence work, and relationship types. Verify critical path continuity and test sensitivity before finalizing reports.
Audit-Trail Evidence Sheets
Every analysis generates an Evidence sheet documenting cryptographic SHA-256 hashes of input XER files, logic network fingerprints, progress fingerprints, software build versions, and exact analytical parameters used.
Seven Specialized Engineering Tool Groups
Engineered exclusively for planners, claims consultants, contractors, and project owners working with Primavera P6 data.
1. Schedule Views & Gantt
Generate P6-styled WBS layouts, extract raw XER tables, apply multi-level WBS color coding, group rows with native Excel outlining, insert live roll-up SUBTOTALs, and plot custom timeline Gantt charts.
View 8 Tools2. Progress & Curves
Construct baseline vs. earned S-curves across any number of updates, generate resource and cost distribution histograms, inspect period activity details, and visualize project calendars with holiday grids.
View 4 Tools3. Schedule Quality
Evaluate schedule integrity across dozens of criteria, calculate Last Planner and BEI metrics, track total float burndown across updates, and isolate progress vs. revision delay trends.
View 3 Tools4. Forensic Delay Analysis
AACE 29R-03 MIP 3.1 through 3.9: Time Impact Analysis (52R-06), Collapsed As-Built, Windowed Collapsed As-Built, As-Planned vs As-Built with Daily Delay Measure, Recreate Updates, and Half Step.
View 8 Tools5. Risk (Monte Carlo)
Perform schedule risk analysis with 3-point estimates, configurable distributions (triangular, PERT, uniform), correlation groups via Gaussian copulas, and 5,000+ simulation runs yielding P-dates and tornado charts.
View Risk Tool6. Codes & Resources
Extract and update activity codes, code values, and resource assignments directly from Excel sheets back into XER files, plus plan manpower loading and convert crew plans to P6 assignments.
View 5 ToolsReady to Streamline Your Delay Analyses?
Request a full-featured 2-month trial license today. No credit card required. Install in under two minutes with no administrative permissions needed.