Calculator
Formula Used
Schedule Performance Index: SPI = EV / PV
Schedule Variance: SV = EV - PV
Schedule Variance Percent: SV% = (EV - PV) / PV × 100
Earned Complete: Earned Complete = EV / BAC × 100
Planned Complete: Planned Complete = PV / BAC × 100
Cost Performance Index: CPI = EV / AC
Estimated Duration: Estimated Duration = Planned Duration / SPI
EV means earned value. PV means planned value. BAC means budget at completion. AC means actual cost.
How to Use This Calculator
- Enter the project name and report name.
- Enter earned value from completed approved work.
- Enter planned value for the reporting date.
- Add baseline budget and cost fields if needed.
- Add planned, elapsed, and remaining duration values.
- Set SPI status limits for your dashboard.
- Enter matching Zoho Analytics field names.
- Press the calculate button and review the result.
- Download the CSV or PDF result for records.
Example Data Table
| Project | Earned Value | Planned Value | SPI | Status |
|---|---|---|---|---|
| Dashboard Migration | 76,000 | 95,000 | 0.80 | Behind schedule |
| CRM Cleanup | 42,000 | 40,000 | 1.05 | On target |
| Data Pipeline | 120,000 | 100,000 | 1.20 | Ahead |
Schedule Performance Index Guide
Schedule Performance Index, or SPI, compares earned work with planned work. It helps project teams see whether progress matches the approved baseline. A value of 1 means the schedule is on plan. A value above 1 means work is ahead. A value below 1 means the project is behind. In Zoho Analytics, SPI is often used in dashboards, pivot tables, and project scorecards. Use comments for exceptions. Note data dates in each refresh. Review milestones separately when one critical task drives the whole result. Share the SPI trend with stakeholders. Clear trends reduce confusion and support faster decisions during regular project review meetings each week.
Why SPI Matters
Managers need more than task counts. Some tasks are small. Others control major delivery value. SPI uses earned value, so progress is weighted by planned cost or planned effort. This makes the signal stronger than a simple percent complete field. It also supports early schedule warnings. A low SPI can show slippage before the final deadline is missed.
Using SPI in Zoho Analytics
You can create a formula column or aggregate formula in Zoho Analytics. The common formula is earned value divided by planned value. When planned value is zero, the formula should return zero or blank. This avoids division errors. You can then group results by project, owner, client, milestone, or reporting period.
Interpreting Results
SPI is best read with schedule variance. Schedule variance shows the absolute gap between earned and planned value. SPI shows the ratio. For example, an SPI of 0.80 means the project earned only eighty percent of the planned progress. The team may need scope review, resource support, or baseline analysis.
Practical Reporting Tips
Use the same units for earned value and planned value. Use currency, hours, story points, or weighted task value. Do not mix units. Refresh the report after each project update. Compare SPI with cost performance index when budget tracking matters. Add status bands to make dashboards easy to read. This calculator also builds a ready formula idea for Zoho Analytics. You can copy the formula, test it, and adjust field names. Keep the baseline stable unless the approved project plan changes. A stable baseline makes trend reports more useful.
FAQs
What is Schedule Performance Index?
Schedule Performance Index measures schedule efficiency. It compares earned value with planned value. It shows whether the project has completed enough planned work by the reporting date.
What is the basic SPI formula?
The basic formula is SPI = Earned Value / Planned Value. If planned value is zero, return zero or blank to avoid division errors.
What does SPI equal to 1 mean?
An SPI of 1 means earned value equals planned value. The project is matching the approved schedule baseline at that reporting point.
What does SPI below 1 mean?
An SPI below 1 means the project is behind schedule. For example, 0.80 means only eighty percent of planned progress was earned.
Can I use this in Zoho Analytics?
Yes. Use the generated formula draft as a starting point. Match the field names with your Zoho Analytics table or report columns.
Should I use row or aggregate formula?
Use a row formula for each record. Use an aggregate formula when dashboards summarize many rows by project, month, owner, or milestone.
Can SPI use hours instead of money?
Yes. SPI can use currency, hours, points, or weighted task values. Earned value and planned value must use the same unit.
Why download CSV or PDF?
CSV helps with spreadsheet review. PDF helps with reports and sharing. Both options keep a simple record of the calculated schedule result.