Home/Resources/AI & controls
AI & controls7 min read

Earned value without the spreadsheet gymnastics.

SPI, CPI and forecast finish are the clearest signals a project has — and the most painful to maintain by hand. Here's what they actually mean, and how to get them computed for every party without touching a spreadsheet.

Earned value is the most honest number in project controls — it compares what you planned to spend, what you've actually done, and what it cost, in a single ratio. The problem was never the method. It was the manual labour of keeping the inputs current across a dozen tabs that go stale the moment site moves on.

Three numbers, plainly

You only need three to read a project's trajectory:

  • SPI (Schedule Performance Index) — work done versus work planned. Below 1.0 means you're behind; 0.94 means you've completed 94% of what the plan said you'd finish by now.
  • CPI (Cost Performance Index) — value earned versus cost spent. Below 1.0 means you're over budget for the progress achieved.
  • Forecast finish — where the current trend lands the completion date if nothing changes.
One ratio beats a status colour

"Amber" is an opinion. An SPI of 0.94 with an eroding trend is a measurement — and it tells you exactly how far off track you are.

Earned value — Clover Tower 2 · Mar 2026
0 25M 50M 75M Aug Oct Dec Feb Today EV · 42.3M AC · 44.9M PV · 45.0M SPI 0.94
Earned value (EV) Actual cost (AC) Planned value (PV)
EV below PV and AC above EV: schedule and cost both under pressure, but the gap is measurable — not just "amber".

Earned value per party

On a real project, the aggregate number hides the story. The contractor may be ahead while a single subcontractor drags the index down. OPTEAM computes SPI and CPI for each party against the same baseline, so you see whose work is actually moving the curve — not just that the curve moved.

The aggregate tells you there's a problem. Per-party earned value tells you whose problem it is.

When to trust the number

Earned value is only as good as the progress feeding it. If updates are weeks old or self-reported without verification, the index is precise but wrong. Because OPTEAM grounds the calculation in timestamped field updates and tracks claimed-versus-verified progress, the number stays both current and defensible.

0.94
Example SPI — 6% behind plan
Per party
SPI & CPI split by every contributor
Live
Recomputed on every field update
The takeaways
  • SPI, CPI and forecast finish read a project's trajectory in three numbers.
  • Per-party earned value reveals whose work is moving the curve.
  • The index is only trustworthy when grounded in current, verified progress.
  • OPTEAM computes all of it automatically — no spreadsheet to maintain.

Get earned value, computed for you.

Connect a P6 file and see SPI, CPI and forecast finish for every party — live.

Keep reading

Related reads