Project Health Dashboard

Untitled Project
Track Cost, Schedule, Progress, Quality, Safety, Risk and Resource KPIs together and get a single weighted Project Health Score with Red/Amber/Green (RAG) status, per-category trend charts, and a printable status report.
by Shahid Pervaiz: pervaiz.shahid@gmail.com
Healthโ€”
BACโ€”
Periods0
Status Dateโ€”
Rev.A

Project Setup

KPI Category Weights (%)

Adjust how much each category counts toward the Overall Project Health Score. Weights are normalized automatically, so they don't need to sum to exactly 100.

Overall Project Health โ€” Current Period

โ€”
Project Health Score
โ€”

KPI Summary โ€” Current Period

Period Data (enter cumulative values)

Enter the raw figures for each category, period by period โ€” everything else (EV, SPI, CPI and the Health Score) is calculated automatically. Cost/Schedule: PV, AC ยท Progress: % Complete ยท Quality: NCRs raised/closed ยท Safety: manhours, recordable incidents, near misses ยท Risk: total open risks, high/critical open risks ยท Resource: planned vs actual resource-hours.

Cost & Schedule Quality Safety Risk Resource
Period PV, cum AC, cum % Complete EV, cum SPI CPI NCR Raised NCR Closed Manhours Incidents Near Miss Risks Open High/Crit Open Res Planned Res Actual Health

Charts

The radar shows how the seven categories compare in the current period. The health index trend shows whether the project is improving or deteriorating overall. The rest break each category down individually.

About this project health dashboard

This tool rolls up the seven KPI areas project managers are usually asked to report separately โ€” cost, schedule, progress, quality, safety, risk and resource โ€” into one weighted Project Health Score with a Red/Amber/Green (RAG) status, so a single number can be tracked over time instead of seven disconnected reports.

The seven categories and what drives each score

Cost
Driven by CPI (Earned Value รท Actual Cost). CPI โ‰ฅ 1 scores 100; below 1 scores proportionally lower.
Schedule
Driven by SPI (Earned Value รท Planned Value), same scaling logic as CPI.
Progress
Compares actual % complete against planned % complete (PV รท BAC). Falling behind plan reduces the score.
Quality
Driven by the NCR closure rate โ€” closed non-conformances รท raised non-conformances.
Safety
Driven by TRIR (Total Recordable Incident Rate = incidents ร— 200,000 รท manhours worked). Lower TRIR scores higher.
Risk
Driven by the share of open risks that are high/critical severity. A smaller high-risk share scores higher.
Resource
Driven by resource utilization โ€” actual resource-hours รท planned resource-hours. Both over- and under-utilization reduce the score.

How the Overall Health Score is built

Each category is scored 0โ€“100 for the latest reported period, then combined using the weights you set in the Weights panel (normalized so they always sum to 100%, however they're entered). The result is banded into Red/Amber/Green (RAG) status: 80+ is Green, 60โ€“79 is Amber, below 60 is Red โ€” the same bands used on each individual KPI card.

Why one score isn't the whole picture

A composite score can hide a single failing area behind several strong ones, which is why every category also gets its own KPI cards, its own trend chart, and its own weight โ€” so a reviewer can always drill back down from the headline number to the category, and from the category to the raw figures entered in the table.

Your data stays with you

The dashboard runs entirely in your browser. There is no account and no server: projects save as JSON files on your own machine, the table exports to CSV, and autosave (optional) writes only to your own browser storage. Chart.js is loaded from a public CDN, so an internet connection is needed the first time a chart renders.

Frequently asked questions

What KPIs does this dashboard track?

Seven categories: cost (CPI/CV), schedule (SPI/SV), physical progress against plan, quality (NCR closure rate), safety (TRIR and incident counts), risk (share of open high/critical risks), and resource utilization (actual versus planned resource-hours).

How is the Overall Project Health Score calculated?

Each of the seven categories is scored 0โ€“100 based on its own formula, then combined into a single weighted average using the weights set in the Weights panel. The combined score is then banded into Green (80+), Amber (60โ€“79) or Red (below 60).

Can I change how much each category matters?

Yes. The Weights panel lets you set a relative weight per category โ€” for example, weighting Safety and Quality more heavily on a safety-critical project. Weights are normalized automatically.

What is TRIR?

Total Recordable Incident Rate โ€” the number of recordable incidents multiplied by 200,000 (representing 100 workers over a year of 2,000 hours each), divided by total manhours worked. It is the standard way to compare safety performance across projects of different sizes.

Is my project data uploaded anywhere?

No. Everything runs client-side in your browser. Projects are saved as JSON files on your own device, and the optional autosave only writes to your browser's local storage.

Related Project Management tools