EVM Formula Optimization
What It Does
An EVM tracking spreadsheet was only calculating percent complete based on labor hours, which meant equipment-only and material-only line items (zero budgeted labor hours) showed 0% complete despite real progress. Designed and implemented fallback logic: if budgeted labor hours > 0, use labor-based calculation; if zero, fall back to installed quantity ÷ base quantity. Applied the fix across 31 affected rows and flagged data anomalies (installed quantities exceeding base quantities) for review.
Key Features
- Designed fallback logic for equipment-only and material-only line items
- Fixed percent complete calculations across 31 cost accounts
- Flagged data anomalies (installed quantities exceeding base quantities)
- Labor-based and quantity-based calculation modes
Why I Built It
Incorrect percent complete calculations were masking real progress on non-labor line items. The fix ensured accurate earned value reporting across all cost types.
What I Learned
Learned how EVM formulas need to adapt to different cost account types. A single formula approach fails when the underlying data structure varies across line items.