Earned Value
Earned Value Management (EVM): a way to measure a project with three numbers: the work planned, the work done and what it cost. SPI and CPI show if it is on schedule and on budget.
In 30 seconds
- Problem
- A project can spend exactly on plan and still be late. Spending alone does not show it.
- Tool
- The skill takes the plan, the actual costs and % complete per work package. A script computes every EVM metric.
- Result
- An Excel report with the status, an S-curve and a short reading you can check.
The flow
Choose a step to see what happens there.
AI does
Reads your files, maps them to work packages and explains the result. It never computes a metric or guesses % complete.
You decide
Confirm % complete, set the thresholds, decide what to do.
The status rule
| Rule | Amber | Red |
|---|---|---|
| SPI (schedule) | under 0.95 | under 0.90 |
| CPI (cost) | under 0.95 | under 0.90 |
The overall status is the worse of the two. You can change the thresholds in the file.
Get it
Download earned-value.zip and install it like Tool 01. Then attach your plan and cost report, or paste them, and ask for an earned value report.
Tested
Tested with a demo cost report: every metric checked by hand and against Excel’s own result, also with another status date and other thresholds.