Adding custom formulas to an assembly allows you to have greater control over what is displayed in the final line item on your Reports and in Estimates. Below you will find our most commonly used formula conversions and add-ons.

**More On Item and Assemblies**

# Topics

# Common Variable Conversions

You may need to convert a takeoff variable into another. Below are examples of common custom variables you can create to convert the data.

## Starting From Count

From [MeasuredCount], add custom variables to represent the other dimensions of the building condition.

Starting from Count | Add Custom Variable (example) |

To Linear Feet | [WallLengthFeet] |

To Square Feet | [WallLengthFeet] and [WallHeightFeet] |

To Cubic Yards | [WallLengthFeet] and [WallHeightFeet] and [WallThicknessInches] |

[MeasuredCount]*[WallLengthFeet]

[MeasuredCount]*[WallLengthFeet]*[WallHeightFeet]

[MeasuredCount]*[WallLengthFeet]*[WallHeightFeet]*([WallThicknessInches]/12)/27

## Starting from Linear

From [MeasuredLinear], add custom variables to represent the other dimensions of the building condition.

Starting from Linear | Add Custom Variable (example) |

To Square Feet | [WallHeightFeet] |

To Cubic Yards | [WallHeightFeet] and [WallThicknessInches] |

[MeasuredLinear]*[WallHeightFeet]

[MeasuredLinear]*[WallHeightFeet]*([WallThicknessInches]/12)/27

## Starting from Square Feet

From [MeasuredArea] or [MeasuredSurfaceArea], add custom variables to represent the other dimensions of the building condition.

Starting from Square Feet | Add Custom Variable (example) |

To Cubic Yards | [WallThicknessInches] |

[MeasuredArea]*([WallThicknessInches]/12)

[MeasuredSurfaceArea]*([WallThicknessInches]/12)/27

# Common Unit Conversion

You may need to convert a takeoff or custom variable from one unit to another. Below are examples of common units and their conversion factors.

## Inches and Feet

From | To | Factor |

Inches | Feet | 12 |

[WallThicknessInches]/12

[MeasuredLinear]*12

## Square Feet and Yards

From | To | Factor |

Square Feet | Square Yards | 9 |

[MeasuredArea]/9

[CarpetRollYards]*9

## Cubic Inches, Feet, and Yards

From | To | Factor |

Cubic Inches | Cubic Yards | 46656 |

Cubic Feet | Cubic Yards | 27 |

([MeasuredArea]/12)*([SlabThicknessInches]/12)/46656

[MeasuredArea]*[SlabThicknessFeet]/27

# Common Formula Functions

## Adding a Waste Percentage

You can add a waste percentage to your formula to control the final quantities. Some examples:

[MeasuredLinear]*1.10

[MeasuredArea]*(1+([WastePercentage0to100]/100))

## Evenly-spaced Items

To calculate an item that occurs on set intervals, add a custom variables to represent the distance of the spacing, and then:

[MeasuredLinear]/[ItemSpacingInFeet]

[MeasuredLinear]*12/16

[MeasuredLinear]*12/[ItemSpacingInInches]

## Area-coverage Items

When an item is set to a known dimension, we can use that information to convert our area takeoffs into item counts. For example:

4'x8' sheet of plywood: [MeasuredArea]/32

4'x10' sheet of drywall: [MeasuredSurfaceArea]/40

## Area of a Circle

To calculate the area of a circle, add a custom variable to represent the radius or diameter of the circle, and then:

3.14*[RadiusOfCircle]*[RadiusOfCircle] or

pi()*power([RadiusOfCircle],2)

3.14*([DiameterOfCircle]/2)*([DiameterOfCircle]/2) or

pi()*power([DiameterOfCircle]/2,2)

## Circumference of a Circle

To calculate the circumference of a circle, add a custom variable to represent the radius or diameter of the circle, and then:

2*3.14*[RadiusOfCircle] or

2*pi()*[RadiusOfCircle]

3.14*[DiameterOfCircle] or

pi()*[DiameterOfCircle]