Metric Calculation Sheet

Metric Calculation Sheet - Formula List

Genesis edition only.

The following is a list of the available formula that can be utilised within the Metric Calculation Sheet formula column.

These functions may be used in combinations or as part of a larger formula, with annotations and operators such as add (+), subtract (-), multiply (*) and divide (/).

This list can also be accessed by using CTRL + Space in the formula column.

Function:
Ceiling

Description:
The Ceiling formula will round the specified value up to the nearest whole number.

Syntax:
Ceiling(x) – Where x is the value to be rounded.

Example:
Ceiling(75.362) – will return the value of 76, after the rounding is performed.

Function:
Floor

Description:
The Floor formula will round the specified value down to the nearest whole number.

Syntax:
Floor(x) – Where x is the value to be rounded.

Example:
Floor(12.987) – will return the value of 12, after the rounding is performed.

Function:
GetDirectCostValue

Description:
Returns the total value of the specified Resource Types from the Direct Cost Schedule.

Syntax:
GetDirectCostValue(x) where x is the Resource Types to be included.
If left blank, all Resource Types will be included.

Example:
GetDirectCostValue() will get the total Direct Cost Value.

GetDirectCostValue(LMP) will get all Direct Cost Value derived from Labour, Material and Plant Resources.

Aliases:
GetDCV()

Function:
GetHiddenCostValue

Description:
Returns the total value of the specified Resource Types from Hidden items.

Syntax:
GetHiddenCostValue(x) where x is the Resource Types to be included.
If left blank, all Resource Types will be included.

Example:
GetHiddenCostValue() will get all Hidden Value.

GetHiddenCostValue(LMP) will get all Hidden Value derived from Labour, Material and Plant resources.

Aliases:
GetHCV()

Function:
GetOverheadCostValue

Description:
Returns the total value of the specified Resource Types from the Overhead Cost Schedule.

Syntax:
GetOverheadCostValue(x) where x is the Resource Types to be included.
If left blank, all Resource Types will be included.

Example:
GetOverheadCostValue() will get the total Overhead Cost Value.

GetOverheadCostValue(LMP) will get all Overhead Cost Value derived from Labour, Material and Plant resources.

Aliases:
GetOCV()

Function:
GetPostadjustmentsValue

Description:
Returns the total value of Post-Adjustment costs in the Project.

Syntax:
GetPostadjustmentsValue()

Example:
GetPostadjustmentsValue() returns the value of Post-Adjustments in the project.

Aliases:
GetPOV()

Function:
GetPreadjustmentsValue

Description:
Returns the total value of the specified Resource Types from Pre-Adjustments.

Syntax:
GetPreadjustmentsValue(x) where x is the Resource Types to be included.
If left blank, all Resource Types will be included.

Example:
GetPreadjustmentsValue() returns the value of Pre-Adjustments in the Project.

GetPreadjustmentsValue(LMP) will get all Pre-Adjustment Value derived from Labour, Material and Plant.

Aliases:
GetPRV()

Function:
GetProjectTotalValue

Description:
Returns the Project total.

Syntax:
GetProjectTotalValue()

Example:
GetProjectTotalValue() returns the total value of the Project.

Aliases:
GetPTV()

Function:
GetProvisionalSumValue

Description:
Returns the total value of Provisional Sums in the Project.

Syntax:
GetProvisionalSumValue()

Example:
GetProvisionalSumValue() returns the total value of Provisional Sum items in the Project

Aliases:
GetPSV()

Function:
GetResourceUsageForDirectSchedule

Description:
Returns the Resource Usage for Direct Cost Schedule items based on either the Project or provided Resource Usage source.

Syntax:
GetResourceUsageForDirectSchedule(x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.
If left blank, the entire usage of the Direct Cost Schedule will be returned.

Example:
GetResourceUsageForDirectSchedule(#LU2) will return the Resource Usage for Direct Cost Schedule items that are included in the Resource Usage reference calculated on line 2 of the current calculation sheet.

GetResourceUsageForDirectSchedule() will return the total Resource Usage for the Direct Cost Schedule.

Aliases:
GetRUDS()

Function:
GetResourceUsageForOverheadSchedule

Description:
Returns the Resource Usage for Overhead Cost Schedule items based on either the Project or provided Resource Usage source.

Syntax:
GetResourceUsageForOverheadSchedule(x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.
If left blank, the entire usage of the Overhead Cost Schedule will be returned.

Example:
GetResourceUsageForOverheadSchedule(#LU2) will return the Resource Usage for Overhead Cost Schedule items that are included in the Resource Usage reference calculated on line 2 of the current calculation sheet.

GetResourceUsageForOverheadSchedule() will return the total Resource Usage for the Overhead Cost Schedule.

Aliases:
GetRUOS()

Function:
GetResourceUsageForResource

Description:
Returns the Resource Usage for Resource(s) based on either the Project or the provided Resource Usage source.

Syntax:
GetResourceUsageForResource(“ ”, x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.
If x is blank, then the total Project Resource Usage will be used.

Example:
GetResourceUsageForResource(“Truck”) will return the total Resource Usage of the “Truck” Resource from the whole Project.

GetResourceUsageForResource(“LA*”, #LU4) will return the total Resource Usage of any Resources starting with “LA” included in the Resource Usage reference calculated on line 4 of the current calculation sheet.

Aliases:
GetRUR()

Function:
GetResourceUsageForResourceTypes

Description:
Returns the Resource Usage for Resource Type(s) based on either the Project or the provided Resource Usage source.

Syntax:
GetResourceUsageForResourceTypes(r, x) where r is the Resource Types to be included and x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.
If x is left blank, then the Resource Usage for the nominated Resource Types for the whole Project is returned.

Example:
GetResourceUsageForResourceTypes(LMP) will get all Resource Usage Value derived from Labour, Material and Plant resources.

GetResourceUsageForResourceTypes(S, #LU1) will get the Subcontract Resource Usage from the Resource Usage reference calculated on line 1 of the current calculation sheet.

Aliases:
GetRURT()

Function:
GetResourceUsageForResourceSupplier

Description:
Returns the Resource Usage for Resource Supplier/Subcontractor(s) based on either the Project or the provided Resource Usage source.

Syntax:
GetResourceUsageForResourceSupplier(“ ”, x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.
If x is blank, then the total Project Resource Usage will be used.
When defining the criteria, the wildcard of * can be applied.

Example:
GetResourceUsageForResourceSupplier(“MySupplier”) will return the total Resource Usage of the Resources with a Supplier of “MySupplier” from the whole Project.

GetResourceUsageForResourceSupplier(“EN*”, #LU4) will return the total Resource Usage of any Resources with a Supplier starting with “EN” included in the Resource Usage reference calculated on line 4 of the current calculation sheet.

Aliases:
GetRURS()

Function:
GetResourceUsageForResourceUnit

Description:
Returns the Resource Usage for Resource Unit(s) based on either the Project or the provided Resource Usage source.

Syntax:
GetResourceUsageForResourceUnit(“ ”, x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.
If x is blank, then the total Project Resource Usage will be used.
When defining the criteria, the wildcard of * can be applied.

Example:
GetResourceUsageForResourceUnit(“hr”) will return the total Resource Usage of the Resources with a unit of “hr” from the whole Project.

GetResourceUsageForResourceUnit(“m*”, #LU4) will return the total Resource Usage of any Resources with a Unit starting with “m” included in the Resource Usage reference calculated on line 4 of the current calculation sheet.

Aliases:
GetRURU()

Function:
GetResourceUsageForScheduleItemUnit

Description:
Returns the Resource Usage for Schedule items with the nominated value in the Unit Column based on either the Project or provided Resource Usage source.

Syntax:
GetResourceUsageForScheduleItemUnit(“ ”, x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.
If x is blank, then the total Project Resource Usage will be used.
When defining the criteria, the wildcard of * can be applied.

Example:
GetResourceUsageForScheduleItemUnit(“each”) will return the total Resource Usage of the Schedule Items with a unit of “each” from the whole Project.

GetResourceUsageForScheduleItemUnit(“m*”, #LU4) will return the total Resource Usage of any Schedule Items with a unit starting with “m” included in the Resource Usage reference calculated on line 4 of the current calculation sheet.

Aliases:
GetRUSIU()

Function:
GetResourceUsageForResourceUserDefinedColumnValue

Description:
Returns the Resource Usage for Resources with the nominated value in the specified Resource User Defined Column based on either the Project or provided Resource Usage source.

Syntax:
GetResourceUsageForResourceUserDefinedColumnValue(“ ”, “ ”, x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.
When defining the criteria, the wildcard of * can be applied.

Example:
GetResourceUsageForResourceUserDefinedColumnValue(“AREA”, “1”) will return the total Resource Usage of any Resources with the value “1” in the User Defined Column “AREA”.

GetResourceUsageForResourceUserDefinedColumnValue(“WorkType”, “con*”, #LU2) will return the total Resource Usage of any Resources with a value starting with “con” in the User Defined Column “WorkType” included in the Resource Usage reference calculated on line 2 of the current calculation sheet.

Aliases:
GetRURUDC()

Function:
GetResourceUsageForScheduleUserDefinedColumnValue

Description:
Returns the Resource Usage for Schedule items with the nominated value in the specified Schedule User Defined Column based on either the Project or provided Resource Usage source.

Syntax:
GetResourceUsageForScheduleUserDefinedColumnValue(“ ”, “ ”, x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.
When defining the criteria, the wildcard of * can be applied.

Example:
GetResourceUsageForScheduleUserDefinedColumnValue(“AREA”, “1”) will return the total Resource Usage of any Schedule items with the value “1” in the User Defined Column “AREA”.

GetResourceUsageForScheduleUserDefinedColumnValue(“WorkType”, “con*”, #LU2) will return the total Resource Usage of any Schedule items with a value starting with “con” in the User Defined Column “WorkType” included in the Resource Usage reference calculated on line 2 of the current calculation sheet.

Aliases:
GetRUSUDC()

Function:
GetResourceUsageForTopLevelScheduleItems(ResourceUsage)

Description:
Returns the sum of the Quantities of the Top Level Schedule Items included in the referenced Resource Usage element.

Syntax:
GetResourceUsageForTopLevelScheduleItems(x)where x is an optional field to define the resource usage element.

Example:
GetResourceUsageForTopLevelScheduleItems() returns the resource usage for all top level cost schedule items (Direct and Overheads).

Aliases:
GetTLSIQ(RU)

Function:
GetRiskAndOpportunitiesValue

Description:
Returns the total value of the specified resource types from risk and opportunities.

Syntax:
GetRiskAndOpportunitiesValue(x) where x is the resource types to be included.
If left blank, all Resource Types will be included.

Example:
GetRiskAndOpportunitiesValue() returns the value of the margin within the project.

GetRiskAndOpportunitiesValue(LM) will get all Risk and Opportunity Value derived from Labour and Material.

Aliases:
GetRO()

Function:
GetScheduleItemQuantity(ResourceUsage)

Description:
Returns the sum of the Quantities of the Schedule Items included in the referenced Resource Usage element.

Syntax:
GetScheduleItemQuantity(x) where x is an optional field to define the resource usage element.

Example:
GetScheduleItemQuantity() returns the total quantity of all contributing Cost Schedule items (both Direct and Overhead).

Aliases:
GetSIQ(RU)

Function:
GetTotalCostsValue

Description:
Returns the total cost value of the project.

Syntax:
GetTotalCostsValue()

Example:
GetTotalCostsValue() returns the value of the Direct, Overhead Costs, Risk and Opportunities and Pre-Adjustments within the project.

Aliases:
GetTC()

Function:
GetTotalMarginValue

Description:
Returns the total margin value of the project.

Syntax:
GetTotalMarginValue()

Example:
GetTotalMarginValue() returns the value of the margin within the project.

Aliases:
GetTM()

Function:
GetBaseQuantity

Description:
Returns the total Unit Quantity associated with the given Resource Usage from Bases Resources only.

Syntax:
GetBaseQuantity(x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.

Example:
GetBaseQuantity(#LU1) will return the total number of Base Resource Units included in the Resource Usage reference calculated on line 1 of the current calculation sheet.

Aliases:
GetBQ()

Function:
GetBaseValue

Description:
Returns the total Resource Value associated with the given Resource Usage from Bases Resources only.

Syntax:
GetBaseValue(x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.

Example:
GetBaseValue(#LU1) will return the total value of Base Resources included in the Resource Usage reference calculated on line 1 of the current calculation sheet.

Aliases:
GetBV()

Function:
GetGroupQuantity

Description:
Returns the total Unit Quantity associated with the given Resource Usage from Group Resources only.

Syntax:
GetGroupQuantity(x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.

Example:
GetGroupQuantity(#LU1) will return the total number of Group Resource Units included in the Resource Usage reference calculated on line 1 of the current calculation sheet.

Aliases:
GetGQ()

Function:
GetGroupValue

Description:
Returns the total Resource Value associated with the given Resource Usage from Group Resources only.

Syntax:
GetGroupValue(x) where x is a Resource Usage reference of a previous line (using #LUn) or another formula that returns a Resource Usage reference.

Example:
GetGroupValue(#LU1) will return the total value of Group Resources included in the Resource Usage reference calculated on line 1 of the current calculation sheet.

Aliases:
GetGV()