PP&C Live Pilot — Example OHL Reinforcement

1. Executive Summary

Cost Performance (CPI)

0.95

Target ≥ 0.95

Schedule Performance (SPI)

0.95

Target ≥ 0.95

Budget at Completion (BAC)

£185.0m

Total budget

Estimate at Completion (EAC)

£189.3m

Forecast outturn

Variance at Completion (VAC)

£-4.3m

BAC − EAC

% Complete (cost)

26.8%

Activities

24

Critical Path

12

Total Float = 0

Negative Float

2

Open Risks

10

Risk EMV (cost)

£5.5m

Open CEs

3

£1.5m forecast

2. Earned Value S-Curve

S-curve is approximated from the baseline schedule + current cost snapshot. For a true time-phased curve, add a Period column to your cost CSV with multiple period rows per WBS (BCWS / BCWP / ACWP cumulative at each period-end).

3. Earned Value Detail

WBS	Description	BAC	PV	EV	AC	CPI	SPI
1.1	Engineering & Design	£8.5m	£4.2m	£4.1m	£4.4m	0.93	0.96
1.2	Procurement	£42.0m	£18.0m	£17.5m	£18.2m	0.96	0.97
1.3	Civil Works	£38.0m	£12.0m	£11.2m	£11.8m	0.95	0.93
1.4	Tower Erection	£29.0m	£5.0m	£4.4m	£4.7m	0.94	0.88
1.5	Stringing & Commissioning	£18.0m	£1.5m	£1.3m	£1.4m	0.93	0.87
1.6	Substation	£42.0m	£8.0m	£7.7m	£8.1m	0.95	0.96
1.7	Project Management	£7.5m	£3.5m	£3.5m	£3.6m	0.96	0.99

4. Resource Profile — Demand vs Supply

Monthly resource demand (planned hours) derived from the latest XER's TASKRSRC table, distributed across each activity's baseline calendar duration. Drop a resources/resource-supply.csv with columns Month, Available_Hours to overlay the supply line.

Top resources by total planned hours

Resource	Total Planned Hours
Civils Crew	3,360 h
Tower Erection Crew	1,080 h
HV/MEICA Engineer	720 h
Stringing Crew	640 h
Civil Foreman	320 h
Project Manager	160 h
Land/Wayleaves Officer	160 h

5. Schedule Quality — DCMA-14 Logic Forensics

The 14 schedule-quality checks defined by the US Defense Contract Management Agency. Used by IPA, DCMA, NDIA-IPMR/IPMDAR and most NEC4 client assurance teams to assess whether a schedule submission is fit for purpose. Failing checks list the offending activities so your planner can fix them.

F-Score (composite)

28.6%

Pass rate across 14 checks · target ≥ 90%

Incomplete activities

10

basis for % checks

Logic relationships

11

basis for #3, #4

#	Check	Result	Threshold	Status
#1	Logic — missing predecessors / successors	3 (30.0%)	≤ 5.0%	● Fail
#2	Leads (negative lag)	1	= 0	● Fail
#3	Lags (positive lag)	1 (9.1%)	≤ 5.0%	● Fail
#4	Relationship types — non-FS	1 (9.1%)	≤ 10.0%	● Pass
#5	Hard constraints	3 (30.0%)	≤ 5.0%	● Fail
#6	High float (> 44 working days)	0 (0.0%)	≤ 5.0%	● Pass
#7	Negative float	2	= 0	● Fail
#8	High duration (> 44 working days)	4 (40.0%)	≤ 5.0%	● Fail
#9	Invalid dates (actual finish before actual start)	0	= 0	● Pass
#10	Resources unassigned	0 (0.0%)	≤ 5% ideal · liberal	● Pass
#11	Missed tasks (planned but not done)	2 (20.0%)	≤ 5.0%	● Fail
#12	Critical Path Test	0 on CP	≥ 1 activity on CP	● Fail
#13	CPLI — Critical Path Length Index	0.927	≥ 0.95	● Fail
#14	BEI — Baseline Execution Index	0.500	≥ 0.95	● Fail

DCMA #1 — top 3 offenders

Activity	Description	Constraint	Total Float	Rem Dur	Early Finish
`A1010`	Site Setup	CS_MSO	+0.0d	20.0d	2026-01-29
`A1100`	OHL Foundations Tower 21-30	—	-20.0d	60.0d	2026-07-30
`A1110`	Wayleave Securing - Phase B	—	+30.0d	20.0d	2026-09-15

DCMA #5 — top 3 offenders

Activity	Description	Constraint	Total Float	Rem Dur	Early Finish
`A1010`	Site Setup	CS_MSO	+0.0d	20.0d	2026-01-29
`A1020`	Foundations Cast Tower 1-10	CS_MEO	+0.0d	40.0d	2026-04-15
`M1000`	Energisation Milestone	CS_MEOA	+0.0d	0.0d	2026-12-01

DCMA #7 — top 2 offenders

Activity	Description	Constraint	Total Float	Rem Dur	Early Finish
`A1070`	Conductor Stringing Phase 2	—	-10.0d	40.0d	2026-12-31
`A1100`	OHL Foundations Tower 21-30	—	-20.0d	60.0d	2026-07-30

DCMA #8 — top 4 offenders

Activity	Description	Constraint	Total Float	Rem Dur	Early Finish
`A1040`	Tower Erection T1-T10	—	+0.0d	75.0d	2026-07-30
`A1050`	Tower Erection T11-T20	—	+20.0d	60.0d	2026-10-15
`A1090`	Substation MEICA Install	—	+0.0d	90.0d	2026-07-30
`A1100`	OHL Foundations Tower 21-30	—	-20.0d	60.0d	2026-07-30

DCMA #11 — top 2 offenders

Activity	Description	Constraint	Total Float	Rem Dur	Early Finish
`A1010`	Site Setup	CS_MSO	+0.0d	20.0d	2026-01-29
`A1020`	Foundations Cast Tower 1-10	CS_MEO	+0.0d	40.0d	2026-04-15

6. Critical Path Gantt

Activities with Total Float ≤ 20 working days, sorted by criticality. Bars: red = negative float · amber = on critical path (TF=0) · green = near-critical (< 10 days) · blue = within 20 days. Darker overlay shows % complete. Diamonds = milestones.

7. Top 5 Schedule Drivers

Activities most likely driving the finish date — lowest total float, longest remaining duration. Excludes complete activities and milestones.

Activity	Description	Total Float (days)	Remaining Dur (days)	% Complete	Early Finish	Late Finish
`A1100`	OHL Foundations Tower 21-30	-20.0	60.0	20.0%	2026-07-30	2026-09-15
`A1070`	Conductor Stringing Phase 2	-10.0	40.0	0.0%	2026-12-31	2027-01-31
`A1090`	Substation MEICA Install	+0.0	90.0	45.0%	2026-07-30
`A1040`	Tower Erection T1-T10	+0.0	75.0	30.0%	2026-07-30
`A1100`	OHL Foundations Tower 21-30	+0.0	60.0	5.0%	2026-07-30	2026-08-30

8. Schedule Change Management

What changed between the two most recent schedule submissions — added / removed / re-dated / re-floated activities. Drop multiple XER snapshots into 01-data-drop/schedule/ to enable.

Comparing 2026-04-02 → 2026-04-30

Added

1

Removed

1

Date changed

6

Duration changed

0

Float changed

6

% complete changed

4

Activities with date changes (top 10 by slip)

Activity	Description	Previous Finish	Current Finish	Slip
`A1030`	Foundations Cast Tower 11-20	2026-04-01	2026-04-30	+29d
`A1070`	Conductor Stringing Phase 2	2026-12-15	2026-12-31	+16d
`A1040`	Tower Erection T1-T10	2026-07-15	2026-07-30	+15d
`A1090`	Substation MEICA Install	2026-07-15	2026-07-30	+15d
`A1020`	Foundations Cast Tower 1-10	2026-04-01	2026-04-15	+14d
`A1050`	Tower Erection T11-T20	2026-10-01	2026-10-15	+14d

Activities with float changes (most lost float first)

Activity	Description	Previous Float (days)	Current Float (days)	Δ
`A1090`	Substation MEICA Install	20.0	0.0	-20.0d
`A1100`	OHL Foundations Tower 21-30	0.0	-20.0	-20.0d
`A1020`	Foundations Cast Tower 1-10	10.0	0.0	-10.0d
`A1040`	Tower Erection T1-T10	10.0	0.0	-10.0d
`A1050`	Tower Erection T11-T20	30.0	20.0	-10.0d
`A1070`	Conductor Stringing Phase 2	0.0	-10.0	-10.0d

Activities added in current snapshot

Activity	Description	Early Start	Early Finish
`A1110`	Wayleave Securing - Phase B	2026-08-01	2026-09-15

Activities removed since previous snapshot

Activity	Description	Previous Finish
`A1090A`	Substation Earthworks (legacy)	2025-12-15

9. Risk Register — Top by EMV

R-003 — Outage window not granted

£1.4m

R-005 — Tower steel supply short

£700k

R-006 — Skilled labour shortage

£630k

R-001 — Wayleave refusal at parcel 14

£600k

R-002 — GIS module FAT slippage

£550k

R-008 — Cable supplier insolvency

£500k

R-004 — Adverse weather Q4

£400k

R-009 — DNO connection design change

£360k

R-007 — Environmental constraints (newt season)

£292k

R-010 — Cyber security incident

£75k

10. Change & Compensation Events

Open EWs

3

Open CEs

3

Open CE Forecast Value

£1.5m

Implemented CE Value

£-180k

ID	Type	Title	Notified	Status	Forecast £
EW-001	EW	Adverse ground conditions Span 12-15	2026-02-15	Notified	£420k
CE-001	CE	Wayleave delay at parcel 14	2026-03-01	Quoted	£1.2m
CE-002	CE	Vendor LD on transformer	2026-03-12	Implemented	£-180k
CE-003	CE	Additional environmental survey	2026-04-02	Quoted	£75k
EW-002	EW	Wind farm interface clash	2026-04-18	Notified	£0
CE-004	CE	Design change to Tower T42	2026-04-22	Disputed	£210k
EW-003	EW	Outage window risk	2026-04-29	Notified	£0

11. Data Quality Report

Files loaded

· schedule/: sample-2026-04-02.xer, sample-2026-04-30.xer

· cost/: test-cost.csv

· risk/: test-risk.csv

· change/: test-change.csv

· project-meta/: test-project.csv

· resources/: test-supply.csv

Run log

[INFO] ============================================================
[INFO] PP&C Live Pilot — Ingestion
[INFO] ============================================================
[INFO] Drop folder: /Users/waqarrauf/Desktop/code/Project Planning/PPC-Dashboard-Suite/99-Live-Pilot/01-data-drop
[INFO] Output folder: /Users/waqarrauf/Desktop/code/Project Planning/PPC-Dashboard-Suite/99-Live-Pilot/02-output
[INFO] 
[INFO] Reading XER: sample-2026-04-02.xer
[INFO]   TASK=12 TASKRSRC=11 RSRC=6 TASKPRED=11
[INFO] Reading XER: sample-2026-04-30.xer
[INFO]   TASK=12 TASKRSRC=11 RSRC=7 TASKPRED=11
[INFO] Reading CSV: cost/test-cost.csv
[INFO] Reading CSV: risk/test-risk.csv
[INFO] Reading CSV: change/test-change.csv
[INFO] Reading CSV: project-meta/test-project.csv
[INFO] Reading CSV: resources/test-supply.csv
[INFO] 
[INFO] Activities loaded:             24
[INFO] Resource assignments:          22
[INFO] Resources (RSRC):              13
[INFO] Predecessor relationships:     22
[INFO] Cost rows loaded:               7
[INFO] Risk rows loaded:              10
[INFO] Change rows loaded:             7
[INFO] Project rows loaded:            1
[INFO] Resource-supply rows:          12
[INFO] 
[INFO] Wrote: activities.csv (24 rows)
[INFO] Wrote: cost.csv (7 rows)
[INFO] Wrote: risk.csv (10 rows)
[INFO] Wrote: change.csv (7 rows)
[INFO] Wrote: project.csv (1 rows)
[INFO] 
[INFO] KPIs:
[INFO]   activity_count: 24
[INFO]   critical_activities: 12
[INFO]   negative_float_activities: 2
[INFO]   long_duration_activities: 8
[INFO]   hard_constraint_count: 6
[INFO]   pct_long_duration: 33.3
[INFO]   pct_hard_constraint: 25.0
[INFO]   avg_pct_complete: 29.8
[INFO]   BAC: 185000000.0
[INFO]   PV: 52250000.0
[INFO]   EV: 49650000.0
[INFO]   AC: 52200000.0
[INFO]   EAC: 189300000.0
[INFO]   Contingency_Remaining: 5850000.0
[INFO]   MR_Remaining: 2250000.0
[INFO]   CPI: 0.951
[INFO]   SPI: 0.95
[INFO]   Pct_Complete_Cost: 26.8
[INFO]   Pct_Spent: 28.2
[INFO]   VAC: -4300000.0
[INFO]   TCPI: 1.019
[INFO]   risk_count: 10
[INFO]   EMV_Cost: 5457500.0
[INFO]   EMV_Schedule_Days: 128.5
[INFO]   risks_open: 10
[INFO]   change_count: 7
[INFO]   EW_Open: 3
[INFO]   CE_Open: 3
[INFO]   CE_Open_Value: 1485000.0
[INFO]   CE_Implemented_Value: -180000.0
[INFO] Wrote: kpis.json
[INFO] Top schedule drivers identified: 5
[INFO] S-curve built (synthesised, 25 points)
[INFO] Resource profile: 12 months · top resource: Civils Crew
[INFO] DCMA-14 F-score: 28.6% (across 14 checks)
[INFO] Critical-path Gantt: 9 activities (TF ≤ 20d)
[INFO] Schedule diff: +1 added · -1 removed · 6 dates · 0 durations · 6 floats