Metric Calculation Sheet

Metric Calculation Sheet - Formula List

Genesis edition only.

The following is a list of the available formulas 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:
GetCodeQuantity

Description:
Returns the Code Quantity for Codes in a Code Set.

Syntax:
GetCodeQuantity(x, y) where x is the reference for the Code Set and y is the lookup value for the Code(s).

Example:
GetCodeQuantity("WBS", "1001") will return the Code Quantity for the Code(s) with the Lookup Value of 1001 in the WBS Code Set.

GetCodeQuantity("Cost Codes", "10/20/30") will return the Code Quantity for the referenced Code 10.20.30 from the Cost Codes Code Set.

Function:
GetCodeSellValue

Description:
Returns the Sell Value for Codes in a Code Set based on either the Project or provided Resource Usage source.

Syntax:
GetCodeSellValue(x, y, z) where x is the reference for the Code Set, y is the lookup value for the Code(s) and z is the Resource Types to be included.

Example:
GetCodeSellValue("WBS", "1001") will return the total Sell Value for the Code(s) with the Lookup Value of 1001 in the WBS Code Set.

GetCodeSellValue("WBS", "1001", L) will return the Sell Value for the Code(s) with the Lookup Value of 1001 in the WBS Code Set for all Labour resources.

GetCodeSellValue("Cost Codes", "10/20/30", L) will return the Sell Value for the referenced Code 10.20.30 from the Cost Codes Code Set for all Labour resources.

Function:
GetCodeValue

Description:
Returns the Cost Value for Codes in a Code Set.

Syntax:
GetCodeValue(x, y) where x is the reference for the Code Set and y is the lookup value for the Code(s).

Example:
GetCodeValue("WBS", "1001") will return the Cost Value for the Code(s) with the Lookup Value of 1001 in the WBS Code Set.

GetCodeValue("Cost Codes", "10/20/30") will return the Cost Value for the referenced Code 10.20.30 from the Cost Codes Code Set.

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:
GetResourceUsageForCode

Description:
Returns the Resource Usage for Codes in a Code Set based on either the Project or provided Resource Usage source.

Syntax:
GetResourceUsageForCode(x, y, z) where x is the reference for the Code Set, y is the lookup value for the Code(s) and z is the Resource Types to be included.

Example:
GetResourceUsageForCode("WBS", "1001") will return the total Resource Usage for the Code(s) with the Lookup Value of 1001 in the WBS Code Set.

GetResourceUsageForCode("WBS", "1001", L) will return the Resource Usage for the Code(s) with the Lookup Value of 1001 in the WBS Code Set for all Labour resources.

GetResourceUsageForCode("Cost Codes", "10/20/30", L) will return the Resource Usage for the referenced Code 10.20.30 from the Cost Codes Code Set for all Labour resources.

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()