The following is a list of the available formula that can be utilised within the Cost Schedule formula column.

This list can also be accessed by using CTRL + Space in the formula column of either the Direct Cost or Overhead Cost Schedule.

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

FUNCTION |
DESCRIPTION |
---|---|

CirArea |
The CirArea function will return the area of a circle of the radius defined. Syntax: CirArea(x)/y – Where x the radius and the total area is then divided by y. Example: |

CirCircum |
The CirCircum function returns the circumference of a circle of a specified radius. Syntax: Example: |

CirFrustumVol |
CirFrustumVol returns the volume of the frustum of a cone calculated on defined values for upper and lower radii and the height. Syntax: Example: Alternatively, you can use this formula to return the volume of a complete cone by setting one of the radius values to 0 creating the vertex of the cone. |

CirSectArea |
This function returns the area of an angular sector of a circle, calculated on defined values for circle radius and angle of the sector. Syntax: Example: |

CirSegArea |
This function returns the area of a segment of a circle. Syntax: Note: The distance (y variable) must be less than the radius (x variable). Example: |

CirSegAreaRem |
CirSegAreaRem can be used to return the remaining area of the circle less the segment area defined. In usage, the function appears the same as the CirSegArea formula where you define the segment, however rather than returning the area of the segment, this formula returns the remaining area of the circle after that segment is removed. Syntax: Note: The distance (y variable) must be less than the radius (x variable). Example: |

ConeSlopeArea |
This function is used to calculate the surface area of the sloped face of a cone. Syntax: Example: |

ConeVol |
The ConeVol function returns the volume of a cone. Syntax: Example: |

Cos |
This function is used to find the Cosine of a specified angle. Syntax: Example: |

EllipseArea |
EllipseArea returns the area of an ellipse of a specified size. Syntax: Example: |

Exp |
This function is used to return Exponential growth rate of a specified value. Syntax: Example: |

Hrect |
The Hrect function is used to return the length of the hypotenuse of a triangle. Syntax: Example: |

If |
The If statement evaluates a logic test and returns a value based on the result. If statements can be nested within each other to perform multiple tests on multiple values and return different values for all possible outcomes of the tests. Syntax: Example: See the If statement article for a full discussion of the potential functions available. |

Log |
The Log function returns the Base 10 Log of a specified value. Syntax: Example: |

Max |
The Max function is used to return the maximum value within a specified set of numbers. Syntax: Example: |

Min |
The Min function is used to return the minimum value within a specified set of numbers. Syntax: Example: |

Mod |
The Mod function is used to return the remaining value after dividing one operand by a second. Syntax: Example: |

Pi |
The Pi function returns the value of Pi accurate to 14 decimals. Syntax: Example: |

PyramidVol |
Use this function to return the volume of a Pyramid. Syntax: Example: |

Q / SetQuantity |
Q or SetQuantity is used to place the specified value in the quantity column. Syntax: Example: |

RectArea |
The RectArea function outputs the area of a rectangle of the specified dimensions. Syntax: Example: |

RectCircum |
The RectCircum function returns the length of the outer perimeter of a rectangle of the specified dimensions. Syntax: Example: |

RelativeSum |
The RelativeSum() or Rsum() function returns the total of all cost estimate lines up to either the previous RelativeSum() function or top of the cost estimate. This is useful for quickly adding subtotals to different sections of your Cost Estimate. Syntax: Example: |

Round |
Rounds the specified value to the number of decimal places defined (away from 0 for midpoint values). The number values can either be manually entered or a define. Syntax: Example: |

Rounddn |
The Rounddn function is used to round a value down to the number of decimal places defined. The number values and either be manually entered or a define. Syntax: Example: In an item with a schedule quantity of 18.65, Rounddn(#QTY) will return 18.00 to the quantity column). |

Roundup |
The Roundup function is used to round a value up to the number of decimal places defined. The number values and either be manually entered or a define. Syntax: Example: In an item with a schedule quantity of 18.65, Roundup(#QTY) will return 19.00 to the quantity column). |

Sin |
Returns the Sine of a specified value. Syntax: Example: |

SphereArea |
The SphereArea function returns the surface area of a sphere of a specified size. Syntax: Example: |

SphereVol |
The SphereVol function returns the volume of a sphere of a specified size. Syntax: Example: |

Sqrt |
The Sqrt function returns the square root of a specified value. Syntax: Example: |

St |
The St function sums the Total of the specified lines and to produce a Rate by dividing the cumulative Total by a specified quantity. Syntax: Example: |

Sum |
The sum function is used to sum (add) the Total of the lines specified within the formula. Syntax: Example: Sum(1:7, 10:25) will total all the lines between lines 1:7 as well as all lines between 10:25. |

SumUserDef |
The SumUserDef() function is used to sum the Totals of lines that contain specific values in a specified User Defined Column. Syntax: Example: |

Tan |
Returns the Tangent of a specified value. Syntax: Example: |