EVM Worksheet Package
Format: Evaluation Assessment / Log / Evaluation Form
Every project needs to answer the question: How much work was accomplished? Earned value management (EVM) is a quantitative technique methodology for controlling a project; it relies on measuring the performance of work using a work breakdown structure (WBS) and includes an integrated schedule and budget based on the project WBS. However, we must keep in mind that this methodology provides an “estimate,” not an exact number. This estimate varies according the performance of the project.
Earned value management is used in project management to measure progress of a project with respect to cost. This template runs a basic earned value analysis and monitors spending over the life of a project. This EVM worksheet is used for planning and tracking of your spending.
Start by adding tasks to the EVM table and entering the amounts that will be spent on the tasks each period.
After you are done defining the tasks and the budget, enter the same set of tasks in the PV (Planned Value), EV (Earned Value) and AC (Actual Cost) worksheets.
At the end of each period, you'll enter a percentage complete for each task in the % PV+EV worksheet, and the amount spent on each task during the period in the AC worksheet.
Update the pivot table on Graphic worksheet and analyze the graph, comparing the EV and AC to the Planned Value.
This zip file contains a user manual and sheets with English and Spanish samples; adapt to your own needs.