Do you just compute
EVM cost variance, schedule variance, SPI and CPI, and estimates
and complete (EACs)?
There is so much more
value in earned value data!
EVM Analytics is a MS
Excel workbook that performs:
of “strange” data entries
prediction of final best/worse CPI and SPI (t)
prediction of best/worse final cost and schedule outcomes
rebaselining might be a good idea
recovery is impossible
You just import, or
enter, your program's EVM data (PV, EV, AC) and their dates. EVM
Analytics will give you more insight into your program than
traditional EVM data analysis. (It also does traditional analysis.)
EVM Analytics can be
used at the program, project, or any lower level where EVM data is
summarized or available. Thus each level of your OBS and WBS can be
analyzed as well as individual control accounts.
Enter PV and dates
only once. Each month (period) enter, or copy/paste, the EV and AC
data. The entire
perfomance measurement baseline (PMB) and performance to date is
thus available for analysis. With this total
program data and the performance
to-date a a true statistical analysis can be performed.
EVM Analytics finds "strange" data that might be a data entry
error or an effort to overstate EV or understate AC.
analysis yields a meaningful SPI (t) that is valid to the program's
end, unlike traditional EVM SPI($) that always becomes 1.0 regardless
of the program's completion date.
This SPI(t) is used to provide forecasts of the program's completion date.
The concepts used in
EVM Analytics are sourced from academic papers, presentations, and
published articles from experts in EVM. These concepts do not have
widespread implementation due to the "snapshot" nature of typical
month-end EVM data reports. By having the entire PMB and monthly
EVM data available MS Excel can do what it does best, analyze data.
Tabular summary data, charts,
and all analysis values may be exported for your further analysis or made a part of your periodic reports
and briefings. Charts are plotted over time and show:
completion date, best and worst case
completion cost, best and worst case
Measurement Baseline plots (PV, EV, and AC)
cumulative cost and schedule variances
SPI($), SPI(t), and CPI
SPI($), SPI(t), and CPI
Performance Index (TCPI) using BAC or user entered target budget
Schedule Performance Index (TSPI) using Planned Duration or user
entered target completion date
using CPI, SPI($), and SPI(t)
With these charts you
can see trends in the estimated completion date and cost, and when rebaselining might be a good idea.
The sources of the
EVM Analytics analysis
Schedule is Different, The Measurable News, March 2003
Lipke, The To
Complete Performance Index … An Expanded View, The
Measurable News, 2009, Issue 2
Applying Statistical Forecasting of Project Duration to Earned
Schedule - Longest Path, The Measureable News, 2015.02
McCurley, Goldenson, Zubrow. An Investigation of Techniques
for Detecting Data Anomalies in Earned Value Management Data,
SEI Technical Report CMU/SEI-2011-TR-027
Taking The Guessing Out Of When To Rebaseline, The
Measurable News, 2013, Issue 4
To see how it works
get the free User's Manual.
A trial version is
available. It will provide you with 120 days of free use of EVM
Analytics. Why 120 days? Some of the analysis tools need three
recent months of data. You can use the trial version on your real
projects and see the results. You can also use data from a complete
program to see how EVM Analytics would have helped forecast the
outcome. To get the trial version just send us an
EVM Analytics is
downloadable for individual users. The price is $175. Organizations may contact us for discounts for multiple users.
We use PayPal to
process electronic payments. This provides secure credit card payments
with the option to use your own PayPal account instead. We don't
see your banking information, only your name and address.
"PayPal- MGMT-TECH" will appear on your credit card statement per
U.S. federal law.
You do not need
to create a PayPal account to pay with your credit card using
Government Agencies should read our
statement about the
use of PayPal for purchase card payments.)
Problems paying via PayPal? Some corporate
purchase cards are declined by PayPal.
Contact us and we'll process your payment directly. PayPal
processes payments from
190 countries. If yours is not listed in
their pull down list contact us for electronic funds transfer (EFT)
For quantity orders and pricing please send an
e-mail with your requested quantity, shipping address, and
If you would like to get our
Newsletter including EVM community news and EVM Tidbits please sign up to our
e-mail list. Opt-out
later if you wish. (We will never, ever, share your e-mail
you can trust
Add "www.mgmt-technologies.com" to your
domain "white" list
Feel free to email us at firstname.lastname@example.org