Template · Management
Earned value management (EVM) project tracker
Track a project's schedule and cost with planned value, earned value, SPI, CPI and an estimate at completion.
Downloads are included in the $19.85 yearly membership. Sign in
XLSXCSVODSXMLNumbers| Earned value management (EVM) project tracker | ||||
| Example data — replace the blue input cells with your own. | ||||
| Headline results | SPI | CPI | EAC | VAC |
| 0.90 | 0.93 | $2,925,416 | -$193,416 | |
| Inputs | ||||
| Project | Example warehouse automation | |||
| Status date | Jan 31, 2027 | Planned value is measured at this date | ||
| Schedule and cost tolerance (plus or minus) | 5% | SPI and CPI inside this band from 1.00 read as on schedule or on budget | ||
| Project start (earliest planned start) | Oct 1, 2026 | |||
| Project totals (USD) | ||||
| Budget at completion (BAC) | $2,732,000 | |||
| Planned value (PV) | $1,189,640 | BAC x planned % at the status date | ||
| Earned value (EV) | $1,073,500 | BAC x % complete |
Showing the first 16 of 49 rows and 5 of 5 columns. Cells with formulas show the formula on hover.
| Work packages | |||||||||||
| One row per work package. Enter budget, dates, percent complete and actual cost; spare rows stay blank. | |||||||||||
| Work packages (blue cells are inputs; black cells are formulas) | |||||||||||
| WBS | Work package | Owner | Budget at completion (BAC) | Planned start | Planned finish | % complete | Actual cost to date (AC) | Planned % at status date | Planned value (PV) | Earned value (EV) | Schedule variance (SV) |
| 1.1 | Project management and reporting | Project manager | $180,000 | Oct 1, 2026 | Jun 30, 2027 | 50% | $92,000 | 45% | $80,735 | $90,000 | $9,265 |
| 1.2 | Site survey and layout | Civil lead | $42,000 | Oct 1, 2026 | Oct 31, 2026 | 100% | $39,500 | 100% | $42,000 | $42,000 | $0 |
| 1.3 | Civil works and foundations | Civil lead | $310,000 | Nov 1, 2026 | Jan 31, 2027 | 90% | $302,000 | 100% | $310,000 | $279,000 | -$31,000 |
| 1.4 | Racking and structural steel | Structures lead | $260,000 | Dec 1, 2026 | Feb 28, 2027 | 55% | $150,000 | 69% | $178,202 | $143,000 | -$35,202 |
| 1.5 | Conveyor system supply | Materials lead | $420,000 | Dec 15, 2026 | Mar 31, 2027 | 40% | $175,000 | 44% | $186,226 | $168,000 | -$18,226 |
| 1.6 | Automated storage and retrieval units | Automation lead | $530,000 | Jan 15, 2027 | May 31, 2027 | 10% | $61,000 | 12% | $62,353 | $53,000 | -$9,353 |
| 1.7 | Control software development | Software lead | $290,000 | Nov 15, 2026 | Apr 30, 2027 | 35% | $118,000 | 46% | $134,518 | $101,500 | -$33,018 |
| 1.8 | Sensors and barcode scanning | Controls engineer | $95,000 | Jan 1, 2027 | Feb 28, 2027 | 60% | $52,000 | 52% | $49,138 | $57,000 | $7,862 |
| 1.9 | Electrical and power distribution | Electrical lead | $175,000 | Nov 15, 2026 | Feb 15, 2027 | 80% | $160,000 | 84% | $146,467 | $140,000 | -$6,467 |
| 1.10 | Installation and integration | Installation lead | $240,000 | Mar 1, 2027 | Jun 15, 2027 | 0% | $0 | 0% | $0 | $0 | $0 |
Showing the first 16 of 67 rows and 12 of 26 columns. Cells with formulas show the formula on hover.
| Earned value management (EVM) project tracker |
| Notes: what this workbook does, how to use it and the method behind it. |
| What it does |
| Tracks a project's cost and schedule performance with earned value. It compares the work planned by a status date and the work actually completed with the money spent, then forecasts the final cost. |
| How to use it |
| 1. Enter the status date and the schedule and cost tolerance on the Dashboard tab. |
| 2. On the Work packages tab, enter each work package's WBS code, name, owner, budget at completion (BAC), planned start and finish, percent complete and actual cost to date. |
| 3. Read the SPI, CPI, EAC and VAC tiles and the status lines on the Dashboard. |
| 4. Check the monthly planned-value table, which gives the planned S-curve from the project start. |
| 5. Clear the example rows and enter your own; spare rows at the bottom of the table stay blank. |
| Formulas and method |
| Planned % at the status date: 0 before the planned start, 1 on or after the planned finish, and linear in days in between: (status date - start) / (finish - start). |
| PV = BAC x planned %. EV = BAC x % complete. AC is entered. SV = EV - PV. CV = EV - AC. |
Showing the first 16 of 34 rows and 1 of 1 columns. Cells with formulas show the formula on hover.
What does this template do?
This workbook tracks a project's cost and schedule performance with earned value management (EVM). It is for project managers, controls analysts and anyone who reports project status to a sponsor. Enter a budget at completion, planned dates, percent complete and actual cost for each work package, then set the status date.
The Work packages tab calculates planned value (budget multiplied by the planned share at the status date, which rises in a straight line over the planned days), earned value (budget multiplied by percent complete) and the schedule and cost variances. The Dashboard turns these into SPI, CPI, the estimate at completion, the variance at completion and the to-complete performance index. It also gives a status line for schedule and cost and a 12-month planned S-curve.
The example is a fictional warehouse automation project with twelve work packages and a total budget of about $2.7 million. Replace the blue cells with your own work breakdown structure.
What’s inside
- Planned value from straight-line phasing between each work package's planned start and finish
- SPI, CPI, estimate at completion and variance at completion on the Dashboard
- Schedule and cost status lines with a tolerance band that you set
- Planned S-curve for 12 months from the project start, built from the work package rows
- Room for 60 work packages; spare rows stay blank
Which tabs does the workbook have?
| Tab | What it holds |
|---|---|
| Dashboard | Status date, headline SPI, CPI, EAC and VAC, project totals, status lines and the monthly planned S-curve. |
| Work packages | One row per work package: budget, dates, percent complete, actual cost and the earned value calculations. |
| Notes | Purpose, steps, formulas used, assumptions and limits. |
What formulas does this template use?
This template holds 1,110 formulas in 1,329 cells across 3 tabs, so 84% of its cells calculate. They use 7 distinct functions; the longest formula is 175 characters and 91 of them read from another tab.
| Function | Uses | What it does |
|---|---|---|
IF | 2,609 | one result when a test is true, another when false |
SUM | 34 | adds numbers |
EOMONTH | 12 | last day of a month, months later |
COUNTIF | 2 | counts cells meeting one condition |
ABS | 1 | absolute value |
MIN | 1 | smallest value |
SUMPRODUCT | 1 | multiplies matching entries, then adds them |
Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.
How do you use it?
- On the Dashboard, enter the project name, the status date and the tolerance.
- On the Work packages tab, enter each WBS code, name, owner, budget, planned dates, percent complete and actual cost.
- Read SPI, CPI, EAC and VAC in the tiles at the top of the Dashboard.
- Check the schedule and cost status lines and the to-complete performance index.
- Compare the monthly planned-value table with actual progress at each review.
What is it good for?
- Monthly project status report to a steering group
- Forecasting the final cost of a fixed-scope project
- Checking a contractor's schedule and cost claims against plan
- Teaching earned value terms to a project team
Questions about this sheet
What does SPI tell me?
SPI is earned value divided by planned value. Above 1 means more work is done than planned at the status date, and below 1 means the project is behind schedule. The status line uses the tolerance you set.
Why is CPI blank?
CPI is earned value divided by actual cost. It stays blank until some actual cost is entered, so the workbook never divides by zero.
How is the estimate at completion calculated?
EAC equals budget at completion divided by CPI. It assumes the cost performance so far continues to the end of the project.
Does the sheet measure percent complete?
No. Percent complete is an input. Enter it from your own measurement of the work done.