pyp6xer_earned_value
Calculate Earned Value Management (EVM) metrics including SPI, CPI, and variances from Primavera P6 XER files to assess project cost and schedule performance.
Instructions
Calculate Earned Value Management (EVM) metrics.
Metrics:
BCWS (PV): Budgeted Cost of Work Scheduled = total budgeted cost × duration %
BCWP (EV): Budgeted Cost of Work Performed = sum of (budget × % complete) per task
ACWP (AC): Actual Cost of Work Performed = sum of actual costs
SPI: Schedule Performance Index = EV / PV
CPI: Cost Performance Index = EV / AC
CV: Cost Variance = EV - AC
SV: Schedule Variance = EV - PV
EAC: Estimate at Completion = BAC / CPI
VAC: Variance at Completion = BAC - EAC
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cache_key | No | Cache key identifying the loaded XER file (set when calling pyp6xer_load_file) | default |
| proj_id | No | Project ID or short name; uses first project if omitted |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |