EARNED VALUE MANAGEMENT TEMPLATE:

DOWNLOAD HERE

View other templates here: Excel Templates

This template does not contain macros/VBA code.

Directions:

Enter in the values asked for in the red circle area shown in the image above.

*Items in the chart below must currently be manually entered from the calculator, to automate that process you can view the Dynamic Earned Value Management (EVM) Chart Using VBA tutorial.

Once items are entered in, you can refresh the accompanying pivot table.

When VBA code is added to automate the process:

View the Dynamic Earned Value Management (EVM) Chart Using VBA tutorial to learn how to automate this Excel document.