An assembly allows you to make estimation calculations on your quotes. You can calculate materials or hours.
To create a new assembly, press the + at top right. You can test the result before saving it by clicking on the Test button at top right. Next to it is the option to change the assembly's name.
(A) Choose the assembly name.
(B) Determine which inputs to include.
(C) Set up the formulas.
(D) Specify output materials (outputs) to be used for calculation.
Inputs
Inputs are the data needed to make formulas later (Exp: area to be covered, percentage of loss, materials used, etc.).
You must define:
(E) The name of the input. Two entries cannot have the same name.
(F) Input type (number, material, time, yes/no).
(G) The predefined value (a value that can be changed once the input is in the assembly).
If a material input is selected, the options change (similar to time):
(H) It is possible to predefine a material or even apply a filter. You must indicate whether or not this entry is optional. A non-optional input will be mandatory in order to have assembly values.
Formulas
(I) A formula name must be entered. You can't have two similar formula names, and you can't enter the same name as an entry.
(J) For the calculation, use available variables (predefined inputs) and functions.
Available functions in assemblies
Establish the formulas using the previously created variables and the following functions.
cos(x) tan(x) asin(x) acos(x) atan(x) sinh(x) cosh(x) tanh(x) asinh(x) acosh(x) atanh(x) sqrt(x) log(x) abs(x) exp(x) ceil(x) floor(x) round(x,n) trunc(x) if(?,x,y)
The most common functions are:
ceil(x): calculates upper integer rounding (ceil = ceiling)
floor(x): calculates lower integer rounding (floor = floor)
round(x,n): return the integer rounding closest to the value specified in the parameter.
trunc(x,2): returns a number with two decimal places only
if(?,x,y): The if statement, used in conjunction with a logical comparison operator, tests whether a condition is true, e.g. whether the measurement of an analog input is greater than a certain value.
Examples of formulas:
ceil(floor area/material_area)
if(guarantee_platinum==1, guarantee_platinum, 0)
Here's an example of a small assembly: Example Wooden floor
To be determined
How many packs of wood
How many øsubfloors
How many ønails
Test result - wooden floor example*