PPS Water Group — Financial Dashboard v3

Upload Project Data

Upload your PPS Water Group Excel file. Data is processed entirely in your browser — nothing is sent to any server.

☁️ SharePoint — Project Summary Beta

Browse DASHBOARDS/PROJECT SUMMARY/<Year> and load up to 6 yearly files directly — no download needed.

0 / 6 selected

Current Period File

Drop .xlsx / .xls / .csv here or click to browse

Period Comparison Optional

Upload a previous month's file to see ▲▼ delta indicators across all KPIs, financials, and alerts.

Drop previous period .xlsx here or browse

Column Detection

Upload a file to see column mapping.

Upload a file to continue

Showing alerts across projects

Filter:

Alert Rule Configuration

Healthy Projects

Contract Value by Project ($M)

Net Cash Position ($M)

Department Mix

Margin % by Project

Completion Progress

Portfolio Insights

Series

Health

Dept

A-SERIES Internal overhead, asset management & support — no external contract revenue

Total Cost by A-Project

Labour vs Material

A-Series Detail

No.	Name	PM	Dept	Labour	Material	Total Cost	Cash Pos.	Hrs Spent	Forecast GP

Group by

View

Sort

Show

With labour only

Labour analysis thresholds — used for colouring and flagging in charts and table

Labour Threshold Configuration

High SOC Uplift (Warning)

SOC adds more than X% above ex-SOC rate

High Hourly Rate (Watch)

Avg all-in rate exceeds $X/hr

$ /hr

Labour % of Total Cost (High)

Labour exceeds X% of total project cost

Hours Over-burn (Critical)

Hours spent exceed FTC hours by X%

% of budget

Labour Detail Table

Labour Insights

CPI vs SPI Scatter

Efficiency % by Project

Hours Earned vs Spent

Performance Table

Project	CPI	SPI	Eff %	Progress	Hrs Earned	Hrs Spent	Hrs Var	Avg $/hr

Portfolio Billing Waterfall

GP & Forecast Waterfall

Invoiced vs Cost by Project ($M)

FAC vs Contract by Project ($M)

Under / Over Budget by Project ($M)

Margin Distribution — Projects by Margin Band

WIP & Revenue in Advance

Date Coverage — Forecast Confidence

△ Period vs Period Comparison

Financial Summary

Project	Contract	Invoiced	Cash	Cost	Labour	Material	Forecast GP	Margin	FAC	Under/Over	WIP

▶ Scenario Modeller — What-If Analysis

Adjust sliders to explore how changes to CPI, variation approvals, and completion affect your portfolio's FAC, margin, and cash position. Source data is never modified — this is read-only exploration.

▷ Cost Performance (CPI) Adjustment

Simulate a portfolio-wide CPI shift. Values above 1.0 improve efficiency; below 1.0 increase cost overruns. Applied as a multiplier to each project's remaining cost-to-complete.

Pessimistic Optimistic

Scenario CPI

1.00

Baseline Avg CPI

–

Delta

–

Presets:

CPI 1.00 — no change from current trajectory.

▷ Pending Variation Approval Rate

What percentage of pending (unapproved) variations get approved? Approved variations increase contract value and therefore improve margin and cash outlook.

0% 100%

Approval Rate

50%

Total Pending

–

Approved in Scenario

–

50% of pending variations approved.

▷ Completion Progress Shift

Shift all active project completion percentages by a fixed amount (e.g. +10% to simulate a month of progress). Used to project the impact of progress on earned value and cash.

−30% +30%

Progress Shift

+0%

Avg Baseline Progress

–

Avg Scenario Progress

–

No progress shift applied.

Portfolio Impact — Baseline vs Scenario

Forecast Gross Profit — Waterfall ($M)

Scenario Narrative

Adjust the sliders on the left and click Recalculate to see how scenarios affect your portfolio.

Per-Project Scenario Impact

Show:

Project	PM	Baseline Contract	Scenario Contract	Baseline FAC	Scenario FAC	Baseline GP	Scenario GP	GP Delta	Baseline Margin	Scenario Margin	Impact

Column Groups:

Sort by:

Projects

Project	Name	Contract	Invoiced	Cash	GP	Margin	CPI	Progress	Alerts

Portfolio Size by PM ($M)

Avg CPI by PM — cost performance

Forecast GP by PM ($M)

Net Cash Position by PM

PM Performance Table

💡 Insights

🏢 Client Portfolio

Sort by:

Revenue Concentration

Block size = contract value · colour = health

Projects

Project	Name	PM	Contract	Invoiced	Cash	GP	Margin	CPI	Progress

Contract Value by Client ($M)

Portfolio Mix — Revenue Share

Forecast GP by Client

Net Cash Position by Client

Avg Margin % by Client

Client Portfolio Table

Client	Projects	Contract	Invoiced	Cash	Cost	GP	Margin	CPI	Pending Vars	Concentration	Risk

💡 Insights

Risk Heatmap — Likelihood × Impact

Colour by:

Impact →

← Likelihood →

Score: Low (1–4) Medium (5–9) High (10–25) Numbers = risk count in cell

Risk Exposure by Category ($M weighted)

Risk Score Distribution

Filter

Sort

New Risk Entry

Project