By José Luis Ponz-Tienda, PhD
This article exposes the integration of the project control by EVM (Earned Value Management) with the visual control of the project advance and performance.
We wish that this example will be useful for all the Plexos´ fanatics.
First of all, you need to create at least one baseline and one control for the project, with the corresponding buttons in the [Main] tab of the ribbon menu.
In this example, one baseline and six control have been created to properly understand the correlation between the EVM indexes and the visual progress of the project.
For the visual control and 4D simulation, in the [BIM workflow] tab of the ribbon menu, we have the following buttons:
This option shows the scheduled baseline at the selected control, or in other words, hows should be the scheduled project advance at the selected control date.
This option shows the actual advance at the selected control, or in other words, hows have been the real project advance at the selected control date.
This option shows the "actual" advance with the current values of the properties panel. This option is not related to the values stored in the controls, but with the ones in the properties panel, and is useful for a quick comparison with the values stored in the control and prior to setting a new control, or in the case that the project scheduler is applying a traditional time control.
This options plays and stops the simulation of the project execution based on the scheduled baseline. You can select the simulation speed between fast, medium and slow.
In the following images are exposed the Scheduled baseline vs the real performance of the project at each one of the project controls (All the images are taken with the [Capture BIM screen] button or the ribbon menu).
You can compare de visual controls with the EVM indexes to complete the information for each control.
Scheduled at Control #1
Performed at Control #1
EVM Values at Control #1
Planned Value at Control date | Actual Cost at Control date | Earned Value at Control date | Cost Variation | Schedule Variation |
190,287,886.18 | 111,540,350.00 | 101,718,919.25 | -9,821,430.75 | -88,568,966.93 |
Scheduled at Control #2
Performed at Control #2
EVM Values at Control #2
Planned Value at Control date | Actual Cost at Control date | Earned Value at Control date | Cost Variation | Schedule Variation |
730,971,359.15 | 304,595,600.00 | 303,159,223.83 | -1,436,376.17 | -127,812,135.32 |
Scheduled at Control #3
Performed at Control #3
EVM Values at Control #3
Planned Value at Control date | Actual Cost at Control date | Earned Value at Control date | Cost Variation | Schedule Variation |
546,912,656.36 | 533,896,100.00 | 528,996,833.86 | -4,899,266.14 | -17,915,822.50 |
Scheduled at Control #4
Performed at Control #4
EVM Values at Control #4
Planned Value at Control date | Actual Cost at Control date | Earned Value at Control date | Cost Variation | Schedule Variation |
832,087,104.00 | 697,021,100.00 | 659,897,769.12 | -37,123,330.88 | -172,189,334.88 |
Scheduled at Control #5
Performed at Control #5
EVM Values at Control #5
Planned Value at Control date | Actual Cost at Control date | Earned Value at Control date | Cost Variation | Schedule Variation |
1,428,067,243.62 | 1,121,696,600.00 | 1,073,200,664.12 | -48,495,935.88 | -354,866,579.50 |
Scheduled at Control #6
Performed at Control #6
EVM Values at Control #6
Planned Value at Control date | Actual Cost at Control date | Earned Value at Control date | Cost Variation | Schedule Variation |
2,030,112,122.13 | 1,615,196,600.00 | 1,560,710,442.70 | -54,486,157.30 | -469,401,679.43 |
All the EVM values and indexes could be exported to Excel to create personalized reports and compute additional values as the Earned Schedule.
The Earned Schedule is a time-based indicator that could be defined as the scheduled time in which the current Earned Value (t) should have been reached.
The first sheet of the workbook is the selected baseline and is presented as a temporal diagram with the scheduled values. In this case, we have added an additional row with the cumulated values of the planned values to easily compute the Earned Schedule.
The following sheets are each one of the project controls:
Additionally, based on the graphical Excel tools, we can create customized reports as a resume of controls and EVM graphs. In the resume of controls, we have included two new columns to compute the Earned Schedule and the Project delay or Advance for each control: