This article explains how to build the MEI-POC waterfall diagram on the MEC board. The diagram plots the cumulative Annual POC against MEI values on a log-log scale, so you can see where accumulated cost sits relative to MEI and spot a possible cut-off point for an MEI threshold. It follows on from the four overviews described in MEC board basics.
This MEI-POC diagram shows the cumulative Annual POC against the MEI values.
The steps below were developed together with TAO Chennai to build the diagram from Excel data.
Building the diagram
Get the FMs with their MEI and Annual POC values.
Export the IMS-RCM analysis grid to get an Excel file with one line per task.
For each task, calculate the annual POC (POC × Ann factor).
Pivot the sum of 'Ann POC' against MEI — see columns 1 and 2 in the image below.
Accumulate the Annual POC from the biggest MEI to the smallest MEI (columns 3 and 4).
Take −LOG(MEI) and +LOG(Acc POC). For MEI = 0, use MEI = 0.01 to get the LOG: (columns 5 and 6).
Make scatter diagram in Excel.
