Australian & International Sales
Instant download after purchase.
Easy EVM Workbook is a simple spreadsheet that performs the calculations needed to apply EVM to normal projects. It is recommended for use on straightforward engineering projects up to $20 million and ICT projects up to $10 million, both with a pragmatic work package design, for more on this see: Sizing Work Packages.
The worksheet is designed to process the data for a
single update. After each update is complete, you save a
copy of the spreadsheet ready for the next update and then
edit / add the new information at the appropriate time.
The worksheet is protected to maintain its integrity, data
can only be entered in the cells shaded light green and
there are extensive error checks built in to validate the
information. Trend information is valuable, reviewing
changes in a work package over several updates (saved
worksheets) will indicate if the project situation is
improving or deteriorating.
Work package numbers and descriptions are free-form and can be edited to suit the needs of the project to a maximum of 35 work packages. Once created, these should not be changed.
It is recommended a schedule be set up for the project
with the following characteristics:
1. The schedule contains a summary activity for each work package with detail tasks below
2. The summary activity be set up to roll up 'physical percent complete' from the underlying detail activities
3. Dates and percent complete are transcribed into the workbook from the schedule.
Baseline start and end dates are obtained from the initial schedule and transcribed into the relevant fields, and baseline budget values are obtained from the project budget. Once entered these values should not be changed. The total budget (BAC) is summed at the top of the table for verification against the project finances.
Then at each update, the actual schedule and cost information is obtained from the same sources and transferred into the spreadsheet for an instant update to the EVM information.
Detail instructions on the use of the spreadsheet are
included on the second 'Instructions' tab and we are happy
to provide help or advice.
or download the instructions for use
Buy the Easy EVM Workbook for $20 (plus
GST for Australian purchasers only) Buy Now Link to download emailed on
completion of purchase.
Easy EVM Workbook is designed to support the practical approach to implementing earned value management described in Easy EVM. Buy the book and spreadsheet as a bundle for $40, saving $15:
Or, buy our complete project controls package consisting of Easy EVM, Easy CPM and the Easy EVM Workbook valued at $90, for $60, saving $30: