Metric Calculation Sheet

Genesis edition only.

The Metric Calculation window provides the ability to build the result of a Metric based on calculated project information.

Each line in the Metric Calculation window represents a separate calculation, but can reference the Total or the Resource Usage result of a previous line in the same window.

The Total on the last line of the Calculation window will be used as the result of the Metric. This value is displayed at the bottom of the window. This is the same value that will then be shown on the Metrics window, and the value that will be compared to the Maximum and Minimum (if entered) accepted values to determine whether a Project Message is created.

There are two styles of formula that can be used to reference calculated results from the Project;

• Get
• GetResourceUsageFor

“Get” functions return a numeric result. For example; GetProjectTotalValue() will return the total value of the Project as a numeric. The result will go to the Total column of that Metric Calculation Sheet line which can then be referenced later in the calculation sheet (if required).

“GetResourceUsageFor” functions do not return a numeric result. Instead, they filter Resource Usage information based on different criteria. For example; GetResourceUsageForResourceUnit() will filter the Resource Usage information for the Project to only Resources that match the criteria given in the formula. These functions can be chained together by referencing a previous “GetResourceUsageFor” function as part of the next function.

There are four (4) formula that can be used to translate these Resource Usage elements to values that can be used as Metric results;

• GetBaseValue
• GetBaseQuantity
• GetGroupValue
• GetGroupQuantity

These formula, when given a reference to a “GetResourceUsageFor” function on a previous line (or have it nested) translate the resultant Resource Usage to either a Value (based on the Calculated Rates of the Resources) or a Quantity (based on the sum of Resource Units in the Resource Usage result).

Metric Calculation Sheet window

“GetResourceUsageFor” functions show “Resource Usage” in the Total column instead of a numeric value. Hovering the mouse over that “Resource Usage” text will show a tooltip containing the number of Schedule Items and Resources that are within that Resource Usage result.