Ingilab Guliyev 000°
Term → Tool Tool 04 Claude skill

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

RuleAmberRed
SPI (schedule)under 0.95under 0.90
CPI (cost)under 0.95under 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.

What you get

Every metric is an Excel formula. Change a cost or the status date and the report follows.
What you get
Earned value report for the demo project Project Atlas: status Amber, SPI 0.92, CPI 0.94, a forecast of 127,988 AZN against a budget of 120,000, and an S-curve of planned value, earned value and actual cost