Excel Formulas for Project Managers

Earned Value Management Formulas Outlined in the PMBOK®.

The Earned Value Management technique (EVM) helps measure project progress in an objective way. This method can combine scope, cost, and schedule values to give early warning (or reassurance) of performance progress. These numbers can also help prevent scope creep, communicate with stakeholders, and keep the project and project team on track.

QI Macros add-in for Excel includes these formula templates for project managers

Earned Value Cost:

  • Cost Variance
  • CPI Cost Performance Index
  • Earned Value
  • Actual Cost
  • Expected Monetary Value
  • Benefit Cost Ratio
  • Cost Benefit Ratio
Earned Value Cost template
earned value mgmt template2

Earned Value Schedule:

  • Earned Value (alt method)
  • Schedule Variance
  • Schedule Performance Index
  • Planned Value
  • Estimate at Completion (4 formulas)
  • Estimate to completion (3 formulas)
  • Variance at Completion
  • Pert
  • Communication Channels
earned value schedule template
earned value schedule part 2

Other Charts Included in QI Macros Add-in for Excel