1. Home
  2. Jobs
  3. Job Estimate
  4. Expression Calculator

Expression Calculator

  • To Access the expression calculator, click on the calculator icon in any selected cell.

    Job Module - Job Estimate -Expression Calculator

The Expression Calculator is available in cells for both the Estimate table and the Quantity Calculation.

  • Enter your desired expression and then click “OK”

    Job Module - Job Estimate -Expression Calculator- OK

Functions List

The Expression Calculator has the following Functions

CodeFunction
Imperial Feet e.g. 12′ returns 12 Decimal Feet
Imperial Inches e.g. 5 1/2” returns 0.458333333333 Decimal Feet
sinSine
sinhHyberbolic Sine
cosCosine
coshHyperbolic cosine
tanTangent
tanhHyperbolic Tangent
asinArcsine
acosArccosine
atanArctangent
atan2Arctangent 2
sqrtSquare Root
expExponent
logLogarithm
log10Logarithm (Base 10)
cbrtCubic Root
modModulus
PIPi
absAbsolute value
roundRound to the nearest integer
rdownRound down to the nearest integer
rupRound up to the nearest integer
rtorto(x,y) rounds x to the nearest multiple of y
rdprdp(x,y) rounds x to y decimal places
rdowntordownto(x,y) rounds x down to the nearest multiple of y
rdowndprdowndp(x,y) rounds x down to y decimal places
ruptorupto(x,y) rounds x up to the nearest multiple of y
rupdprupdp(x,y) rounds x up to y decimal places
^Power (x^y= x to the power of y)
;Comment – everything after ; is ignored, e.g. 2*2; equals 4

Sample Imperial and Metric Formulas

  • Calculation of Factor Using Pitch in the Imperial System

    Calculation of Factor Using Pitch in the Imperial System
    The calculation is for a 6/12 Pitch Roof, to get any other pitch you would change the highlighted area from 6 to 4 in a 4/12 Pitch Roof
  • Calculation of Factor Using Degrees in Metric System

    Calculation of Factor Using Degrees in Metric Syste
    The Calculation is for obtaining the Factor for a 22.5° roof angle, change the value with the brackets to your desired pitch.
  • Converting Pitch to Degrees and using Cos(Degrees)

    Converting Pitch to Degrees and using Cos(Degrees)
     atan(6/12) gives you the Degrees so you can substitute in the above formula using Rise over Length. You can also use fraction in Rise ( eg. 6.5/12)
  • Calculating Volume of a spherical Beam or a Concrete Pier.

    Calculating Volume of a spherical Beam or a Concrete Pier.
    (3/2) represents a 3 ft Diameter  divide by 2 to give you the Radius and the result is squared.

    The Formula for Volume of a Cylinder is  r2 h . The Total Height is calculated by the Count of Piers by the height of 6 ft giving a total of 848.23 cu ft.

    Calc Volume 2
  • Adding Feet and Inches together 

    Adding feet and inches

Updated on February 7, 2022

Was this article helpful?

Related Articles