# Calculating Quantities with Formulas & Equations ## Megan Sullivan

Looking to enhance your estimates with precise quantities derived from combining values and parameters together through formulas or equations?  Have you leveraged formulas in spreadsheet systems before and want to implement them in CoConstruct construction management software?

Harness the power of a quantity with CoConstruct formulas.

## WHAT FORMULAS

Use any formulas to quantify the appropriate quantities.  See the full list of available formulas below:

Add a value (x) with another value (y)x+y

Ex. Calculate the quantity of floor receiving hardwood flooring

={1st Floor Living} + {2nd Floor Living}

#### Subtraction

Subtract a value (x) from another value (y)y-x

Ex. Calculate the quantity of deck around a pool

={Deck Area} - {Pool Area]

#### Multiplication

Multiply a value (x) by another value (y)x*y

Ex. Calculate the quantity of carpet then apply a 15% waste factor

=({Master Bedroom}+{Guest Room 1}+{Guest Room 2})*1.15

#### Division

Divide a value (x) by another value (y)x/y

Ex. Calculate the number of hours it will take to install a roof by first translating the number of roof squares into total roof SF, then dividing that against the number of square feet worked per hour

=({Roof Squares}*100)/40

#### Exponentials

Find the exponential total of a value (x) to the nth degree (y)x^y

Ex. Calculate the quantity of concrete required for the garage floor

={Garage Length}^2

#### Square Root

Find the square root of a value (x)sqrt(x)

Ex. Calculate the quantity of fence needed for the yard by deriving the square root of the lot area to obtain length, then multiply by 4 sides to get the appropriate quantity

=sqrt({Lot Area})*4

#### Rounding

Round a value (x) up or down to desired number of decimals (y)round(x,y)

Ex. Calculate the number of hours it will take to install a roof rounded to the nearest whole number by taking division example above and selecting what place value to round to

=round(({Roof Squares}*100)/40,0)

#### Round Down

Round a value (x) down to the nearest whole numberfloor(x)

Ex. Calculate a competitive quantity of flooring labor by first dividing total floor area by the number of square feet installed per hour then rounding that value to the nearest whole number

=floor(({1st Floor Living} + {2nd Floor Living})/55)

#### Round Up

Round a value (x) up to the nearest whole numberceil(x)

Ex. Calculate the number of paint gallons needed for a certain wall area by rounding the total wall area divided by the number of square feet in a gallon

=ceil({Wall Area}/400)

#### If Statement

When a value or formula (x) meets some criteria (y) then use a different value (z), and if not use (w)

Potential Criteria:
- Greater than (>)
- Less than (<)
- Greater than or equal to (>=)
- Less than or equal to (<=)

if(x,y,z,w)

Ex. Calculate the number of bricks needed for a patio by first establishing how many bricks required (calculate patio square feet by number of bricks in a square foot).  Then establish the criteria for ordering at a wholesale price of 2500 bricks.  If it's below a certain number you need to order for a wholesale price, use the minimum order amount OR if it's not, then use the actual value.

=if(({Patio SF}/4.5)<2500,2500,({Patio SF}/4.5)

#### Minimums

Use the lowest set of values or formulas

min(x,y,z)

Ex. Calculate the quantity of porch by originally budgeting the smallest of the different porch options that range from 7 ft wide, 10 ft wide, and 5 ft wide on all four sides.

=min((7*{House Width})+(7*{House Length}),10*{House Width},(((5*{House Length})*2)+((5*{House Width})*2)))

#### Maximums

Use the largest of a set of values or formulas

max(x,y,z)

Ex. Calculate tile floor installation per room by leveraging the largest room quantity in order to set a standard rate per room

=max({Kitchen SF}/40,{Bath 1 SF}/40,{Master Bath}/40)

## USING FORMULAS

Start by leveraging the parameters tool to house any project measurements or dimensions.