ConstructConnect Home | CONTACT | SALES: 1-800-364-2059
 
Getting Started with ConstructConnect Takeoff


Tools
Categories

16.05.04 Custom Formula Example - Counts

Last Updated: 2022-02-14 13:16

ConstructConnect Takeoff includes numerous Result formulas for each Takeoff Item Type (Linear, Area, Count, Attachment). If you cannot find one that suits your needs, you can create a Custom Formula.

Note

There are numerous "Variables" you can use in your formulas, please see Related Articles for a list of all available variables you can use in Custom Formulas.

Remember, depending on how you measure something (as a Linear, Area, or Count or all three...), you may need to create similar Custom Formulas to calculate the same Material for each Type of Takeoff Item.

Example - Calculating the Volume of a Pyramid Count Object

How you create a Custom Formula is dependent on the Type of Takeoff Item; and for Count and Attachments, the Shape of the object often requires some adjustments to your formulas.

As an example, we want to calculate the volume of a pyramid-shaped Count object. The dimensions of the pyramid's base are 8' by 6' and the height is 10'.

The mathematical formula to calculate a pyramid's volume is (W*D*H/3 (one third of the volume of the rectangle)). This is easy to accomplish using a Custom Formula.

Pyramid shape

Our Takeoff Item is setup like this...

Count Condition Properties to calculate a Pyramid's volume

In the Takeoff Item's Results tab, click the Add Result button at the bottom of the Results list, this opens up the Count Formulas window.

Count Condition Formula List

Click the  Add Result button in the Count Formulas list to add a new, Custom Formula using the Formula Editor (introduced in the previous articles).

Custom Formula to calculate Volume of a Pyramid Count rectangular shape

Our formula takes the Count's Height (H), Width (W), and Depth (D) and divides by 3. (Could not be simpler! But wait, the Formula for calculating surface area, below, is a bit more complex).

Formula Errors

If the program identifies an error in your formula, it lets you know....

Error in formula

In our example, we included an unnecessary closing parenthesis at the end of our Formula. The program underlines our mistake so we can fix it.

Validation # 1

Before you save this Custom Formula, use the Validation panel on the right - we enter 10' for length and 10' for height.

Validation showing number of blocks

If we do the math:

  1. 10 (Height) x 6 (Width) x 8 (Depth) = 480
  2. Divide 480 by 3 and you get 160
  3. We are expecting CF (for Volume) so that is also correct

Click Save (you can save this to the Masters if you are adding from a Takeoff Item by clicking "Save to Library" in the Formula List).

Validation #2

Now return to the Takeoff Tab and draw a one object with this Takeoff Item.

Takeoff Tab Condition Results showing number of blocks

Notice, Result # 2 (our Custom Formula) shows 160.00 CF - exactly what we were expecting.

Again, if you wanted to account for weight, that is easy enough to do, review the previous article on Linear Custom Formulas.

Now, setting up a Custom Formula to calculate the surface area of a pyramid is much more complex.

Complex Calculation - Surface Area of a Pyramid

From our Geometry classes, we know that the formula for calculating the surface area of a pyramid requires calculating the surface area of the triangles that compose the "walls" of the pyramid, and adding that to the surface area of the base of the pyramid.

Mathematical formula to calculate surface area of a Pyramid
Mathematical Formula for the surface area of a pyramid, compliments of Bing™ - notice the Result, 196.144.

This may seem daunting, but if you break it down a bit, we can figure it out.

First step, the surface area of the base is just Length times Width, but we call Length "Depth" because "length" is related to drawing Linear takeoff.

Mathematical formula to calculate surface area of a Pyramid

Then, it is a matter of converting those Root symbols to fractional powers (the square root of 4 is the same as saying 4 raised to the power of 1/2). When raising to a power, be sure to offset that calculation with parentheses, and be double-sure that you offset addition and subtraction calculations.

The most confusing part is keeping track of the parentheses to control the order of calculations - but remember, the program lets you know if you miss any closing parentheses.

Mathematical formula to calculate surface area of a Pyramid

Notice, our validation matches that online calculator.

Save this Custom Formula and the Takeoff Item and then review the Takeoff Tab.

Mathematical formula to calculate surface area of a Pyramid

Notice, our Result # 3 matches our online calculator's result.

Remember, depending on how you measure something (as a Linear, Area, or Count or all three...), you may need to create similar Custom Formulas to calculate the same Material for each Type of Takeoff Item.

previous article arrow Custom Formula Example - AreasVariables You Can Use in Custom Formulas next article arrow



 

The information in this site is protected by copyright by ConstructConnect. You may not reproduce, adapt, or publish any content from this site in whole or in part for any purpose, without the express written consent of ConstructConnect, Inc.
Copyright 2023 - All Rights Reserved.