X-evm Users Manual v1.0 EVM Research LLC

X-evm Users Manual v1.0
EVM Research LLC
System Requirements for X-evm
Operating System
MS Office Compatibility
Processor
CPU Architecture
RAM
Hard disk space Required
All Windows Platforms
Office 2007, 2010 and 2013
Pentium Dual Core or Above (Recommended i3)
32 and 64 bit
1 GB or Above (Recommended 2GB)
Less than 1 MB
Installation Instructions
1.
2.
3.
4.
5.
6.
7.
8.
Save the X-evm file to your hard drive. Do not open the file yet.
Open Microsoft Excel
Enable Macros and Disable Protected view :
a) Click the Microsoft Office /File Menu, and then click Options
b) Click Trust Center > Trust Center Settings,> Macro Settings
c) Select the option ‘Enable all macros (not recommended, potentially dangerous code can run)’ and also check the
‘Trust access to the VBA project object model’ box.
d) Next, click on ‘Protected View’
e) Uncheck ‘Enable Protected View for files originating from the Internet ‘
f) Uncheck ‘Enable Protected View for Outlook attachments’ and click ‘OK’.
Now, open the X-evm file in Excel . The ‘X-evm licensing form’ will be opened
Follow the instructions to activate the software. Make sure you have internet connection during the activation process.
When you have successfully actiavted X-evm, you will be prompted to choose a location to save the ‘X-evm Template’
file. Remember this location as this is your souce template for X-evm.
The file will then be closed automatically.
Open the File you just saved and start using X-evm. When you save your work, you will be prompted to save it under a
new file name.
Limitations
o
X-evm is not supported on Mac, Linux, Online Office or any cloud systems.
o
Avoid Excel® drag-down function to populate rows or copy/paste rows. Use the X-evm built in functions instead.
Legal
o
X-evm is a teaching aid and illustrator for educational purposes only and EVM Research LLC is not responsible for
financial/accounting anomalies, losses or any other irregularities resulting in your projects. Refer to the X-evm End Users
Agreement.
o
This software is restricted to one license per machine.
X-­‐evm Users Manual v1.0 evmresearch.com 1
I.
Overview
X-evm was built simple, devoid of the complexities that come with expensive leading tools. The intent was to allow
you, the project practitioner, to setup projects requiring EVM on the fly. Let’s say you are visiting a client site to assess
one of their troubled projects struggling with cost overruns. You could then use X-evm to plug in some basic cost and %
complete inputs, to quickly spit out the CPI and SPI. You could also use X-evm as a simulator to accelerate your own
learning or simply use it to try out various what-if scenarios for your ongoing projects.
Whatever the purpose might be, with X-evm, you will gain valuable insight into the powerful word of EVM. You can
now build the confidence you have always wanted to manage EVM projects.
II.
Dashboard
Fig. 1 EVM Chart
The above chart illustrates PV, AC and EV plotted as a function of time available in the Dashboard tab.
Figure 2 EVM Metrics
X-­‐evm Users Manual v1.0 evmresearch.com 2
The above table illustrates the EVM metrics snapshot available in the Dashboard tab.
The DASHBOARD tab provides you a snapshot of where your project is as of today (you can choose any other status
date you wish as well).
The top header section consists of free form text fields for you to populate. The following are writable fields;
Company Name
Project Name
Project Code
Project Manager
Placeholder 1
Placeholder 2
The following fields in the header section are automatically populated from the GANTT ENGINE. You cannot write
to these fields;
Project start date
Project end date
Project duration
Starting day of week
The following fields are controllers allowing you to set parameters;
EV status date: Choose a status date for reviewing EVM parameters. These values are derived from the EV tab
bottom most section. See Fig. 7.
Show chart from week: The date you want the graph to start on, irrespective of the project start date (zoom
in/out).
To: How many weeks you want the graph to plot from the start date.
EVM Parameters: This table displays a snapshot of EVM parameters for the date you chose in the EV status
date
X-­‐evm Users Manual v1.0 evmresearch.com 3
Graph: Displays PV, AC and EV for the parameters you set in ‘Show chart from’ field and ‘To’ field. Use these
controllers to zoom into your graphs.
III.
GANTT Engine
The GANTT Engine is a powerful utility that helps you to build your schedule. Users must avoid performing
traditional Excel ® functions as such drag, drop or copy/paste functions.
The figure below shows the first half of the Gantt Engine tab.
Fig. 3 Gantt Chart
The following buttons are controllers;
Add new rows: Adds the amount of rows you specify starting at the last row.
Insert row: Use it to insert a row anyplace between the rows you already have scheduled. Note, you cannot use
this to add a new row to the end of the existing rows.
Delete row: Delete any row that you specify.
Bulk delete: Delete the number of rows you specify from the end of the rows you already have built.
Refresh; Use it to refresh the data. In case you delete the date you use this button to retrieve it. You could also
try using this to clear any unintended user input errors.
Weekend work: Check this box if weekend work is required. This will now include weekend days (Sat, Sun, or
both weekend days) to the schedule.
Resource names: Choose the resource name you have listed in the Resource tab. Multiple resources can be
specified for each task and the resource column will display the number of resources for a particular task with
the number of resources prefixed to the resources.
The following fields are automatically generated and cannot be written to:
No
X-­‐evm Users Manual v1.0 evmresearch.com 4
WBS
% Comp: This value is derived from the EV tab.
End date This value is driven by the ‘start date’ and ‘Pred’ (Predecessor).
Budgeted cost This value is the budgeted cost for each task (Duration times the number of resources times
Hours each resource works per day)
The following fields are writable:
Task name: Type the task names here. “Add rows” when you need to add more tasks. Always write one task
at a time and avoid using the drag down functions to populate the rows.
Predecessor: This field automatically calculates the start and end date of the task based on its predecessor. Be
careful not to input invalid predecessors- you will be prompted with errors. Only finish-Start is supported. StartStart and other lead/lag functions are not supported.
Fig. 4 Gantt Chart
The Gantt chart view is also available in the Gantt engine tab by scrolling to the right. A 6-month view is
available. To view later durations use the “select the starting week’ button to move the Gantt chart to the right.
The Gantt chart is illustrated in beige and bronze graphs, with the bronze indicating the % completed.
IV.
Planned Value (PV)
The project baseline that you build using the Gantt engine, gets translated into costs and are accumulated in this sheet.
The cumulative cost/week is plotted in the graph in the DASHBOARD tab as PV. This is the line against which you
X-­‐evm Users Manual v1.0 evmresearch.com 5
measure progress of AC and EV. Note that you cannot write on this tab. These numbers are automatically generated
and distributed across the duration of the project.
Budgeted cost/week: Displays all the tasks that you listed in the GANTT tab and their respective costs for
each week. You can see what the planned cost is for each task for each week.
Total budgeted cost/week: This is the summation of the costs of all tasks in each week.
Cumulative planned value This is the cumulative total of each week’s cost summed up in incremental order,
week over week. This is the line that is plotted in the graph that you use to measure AC and EV against.
The Start and End dates are also displayed for each task along with its total budgeted cost.
X-­‐evm Users Manual v1.0 evmresearch.com 6
V.
Actual Cost (AC)
Actual Cost tab where you manually enter the actual cost (AC) that each task incurs every week. It is good practice to enter
these costs every week.
The Actual Cost/ Week - All Tasks section is writable. Enter the weekly cost for each task here;
The Actual cost/week and Cumulative costs are auto generated and cannot be written to. The cumulative cost is what makes up
the AC component of the graph in the Dashboard tab.
The following parameters are also auto generated and non-writable;
Budg. Cost: These are the PV values for each task
Total Actual Cost; How much cost you have incurred for each task to date
Variance: Difference between PV and the cost you have incurred to date for each task
As you can see, the above fields grant you the ability to instantaneously ascertain how much you are spending and how
much you have left for each task- a great cost control feature.
Fig. 5 Actual Cost tab
Note the gray cells for each task. They are auto shaded during the build of PV, to guide you to the weeks’ expected cost.
Now you call determine if any resource is expected to bill that week. If you don’t find any resource billings for that week,
then it can indicate a missed billing or missed task. On the contrary, if someone bills during a week with no grey cells, then
that could indicate a gap as well. This is a great cost control feature.
VI.
Earned Value (EV)
Earned value is a function of PV. If you multiply the % complete of a task with the budgeted cost of that task, you will arrive
at the EV for that task.
This tab follows the same convention as that of the AC. You manually enter the % complete of each task in the EV/week- all
tasks section. These percentages are then converted into costs (% complete times the planned value of that task). The
X-­‐evm Users Manual v1.0 evmresearch.com 7
EV/week row displays the total cost of tasks for each week. The cumulative EV represents the summation of the EV/week,
accumulated every week. This makes up the EV component of the graph.
EV/Week- all tasks: this is where you manually enter the % complete for each task for each week.
EV/Week: This is auto generated and shows the total EV for each week (remember % x PV)
Cumulative EV: This is the summation of the EV/week costs, week over week.
Fig. 6 Earned Value Tab
Note the gray cells for each task. They are auto shaded during the build of PV, to guide you to the weeks’ % completion
expected. Now you call tell if any resource is expected complete a task during the gray shaded duration. In this illustration,
Task 1 is scheduled for week1 – week 3. Here the resource completed 30% of the work during week 1 and made no progress
during week 2, so it remains at 30%. However during the 3rd week the resource has managed to complete the entire task at
100%. On the contrary, should the work continue past the gray cells, it may indicate a delay in the completion of the task.
This is a great utility to keep track of work on a weekly basis.
Caution must be exercised to not enter percentage completion that is greater than 100%. This would trigger the cells to
change color to red. If this happens then make the necessary changes to bring it back to less or equal to 100%.
Finally, if circumstances require you to revise the % completion to a lower value than what is shown, then the costs
corresponding to the revised % completion will also be decremented from the overall costs. For example, say you have a
task marked at 75% at week-1, and say you want to revise it to 50% at week-2. Then, after you make the revision in week-2,
25% of the costs will be decremented from the overall cost. Ideally this type of revisions should be avoided. Instead, it’s best
to simply go back in time and make the necessary revisions to week-1 and bring it to where it actually must be. This will
ensure the % completion and the associated costs are gradually incremented over time.
Fig.7 Graph data for PV, EV, AC
This is where the cumulative totals of EV, AC and PV are stored and retrieved by the graph on the DASHBOARD tab.
These 3 lines of data available at the bottom of the sheet in the EV tab. The ‘evm snapshot’ table in the DASHBOARD tab
displays the data highlighted in red and generates other parameters based on these 3 data point. The cells highlighted in red
are driven by the ‘ev date’ field above the ‘evm snapshot’ table. You may select any date from the ‘ev date’ box to view the
EVM parameters during various durations of the project. Utilize this as a simulator to aid your learning.
X-­‐evm Users Manual v1.0 evmresearch.com 8
VII.
Resource Rates and Cost
You can list your resources on this tab, along with their rates. These rates are used to calculate the PV for each task. There
are also placeholders for other information you can input for each of the resources. The below files are writable.
The resource name column is the place where you enter the resources
The hourly rate column holds the hourly rates for the resources
The working hours/day column specifies how many hours that resource works/day. For example, 4hrs/day indicates 50%
and 2hrs/day indicates 25%. This provides great flexibility for loose resources that may not be dedicated on a particular
project.
The details column is a placeholder to write any comments for each resource.
The total budget resource cost shows the total cumulative cost for each resource. This is auto-generated and can’t be written
to. This is an extremely useful table to keep track of total resource cost
VIII.
Holiday List
You can list observed and non-observed holidays here. These are global settings that apply to all resources. The PV
automatically factors these non-working days into the schedule and cost.
The above fields are writable;
Date: Format must be [numerical day- month – numerical year].
Example 3-Jan-2014
Description: The holiday
No; this is not writable and has a limit of 60
X-­‐evm Users Manual v1.0 evmresearch.com 9