Project Management Formulas for Excel

Project Management Formulas for Excel

The Project Management Formulas Template provides formulas to assist Project Managers in getting a quick point-in-time look at their project progress.

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. The Earned Value Management formulas in this template are outlined in the PMBOK®.

Earned Value Cost:

• Cost Variance
• CPI Cost Performance Index
• Earned Value
• Actual Cost
• Expected Monetary Value
• Benefit Cost Ratio
• Cost Benefit Ratio

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

The Project Management Template with Earned Value Management formulas is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma