Free template
Earned value tracker template (free Excel download)
Enter the budget once, then the cumulative planned value, earned value and actual cost each month. Every row shows CPI, SPI, the variances and the forecast cost at completion.
Download
Free, no sign-up. .xlsx, 8 KB. Opens in Excel, Google Sheets, Numbers and LibreOffice.
What is inside
Enter the budget once, then the cumulative planned value, earned value and actual cost each month. Every row shows CPI, SPI, the variances and the forecast cost at completion.
| Period | Free text. |
|---|---|
| PV (cumulative) | An amount in your currency. |
| EV (cumulative) | An amount in your currency. |
| AC (cumulative) | An amount in your currency. |
| CPI | Calculated for you. |
| SPI | Calculated for you. |
| CV | Calculated for you. |
| SV | Calculated for you. |
| EAC (BAC / CPI) | Calculated for you. |
Example rows show what good entries look like. Overwrite them, and add rows as you need; the formulas copy down.
How to use it
- Enter the budget at completion (BAC) once, at the top.
- Each period, enter cumulative planned value, earned value and actual cost.
- Read CPI, SPI and EAC on the same row; below 1.0 means over budget or behind plan.
The full method, with a worked example, is in this article.
When a spreadsheet stops being enough
A spreadsheet works for one project and one person. Once several people update it, or you need the numbers on a dashboard, copies drift apart. Critova has CPI, SPI(t), EAC and TCPI calculated from your schedule and costs, shared by the whole team and free during the launch.
Common questions
Is it really free?
Yes. Download it, change it and use it at work. No sign-up and no email address needed.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets; the formulas and drop-downs keep working.
Is there an Arabic version?
Yes. Every template comes in English and in Arabic, and the Arabic file is laid out right to left.
Bring one schedule. See your critical path in an hour.
Free during our launch until 31 March 2027.
