User defined functions are a feature of Excel that is utilized in the Estimating Workbook. These custom functions allow for faster calculation of various estimating cost items.
Example 01: Use CalcQuantity to estimate the quantity of material required for the Catwalk in the Truss Roof Framing.
1. Identify the material type by looking at the plans. Enter that material in the Estimating Workbook -> Framing Tab -> Truss Roof Framing Material -> Catwalk Row -> Materials Cell.
2. Enter the Size and Units information in the Estimating Workbook, next to the Material.
3. Determine how many feet are required by completing a takeoff from the plans using Bluebeam. In this case, there are four different catwalk lengths measuring at 14.5', 23.5', 23.5', and 12', respectively.
4. Select the Quantity cell in the Catwalk row of the Framing tab of the Estimating Workbook.
5. Click on the Insert Function icon in the menu bar, and search for the CalcQuantity function in the Formula Builder Tool.
6. Select the cells the function should reference for Material, WasteFactor, and Size in the the Formula Builder. Also enter the four lengths of the catwalks from the takeoff (14.5+23.5+23.5+12). Click Done.
The four catwalk lengths add up to 73.5'. The Waste Factor in this case is 0, and the material is purchased in 1 SF increments. Taking all of these variables into account, the CalcQuantity function returns an estimated quantity of 74.