Estimating
The "criteria" page in the spreadsheet contains the database functions for separating the takeoff.
It also contains a splice table with named cells. For example, a #7 top splice is named "S7T".
This could be used in the takeoff by adding it to other dimensions. A column formula might look
like floor2elev - floor1elev + S7T. This will automatically add the #7 top splice.
Another function built into the spreadsheet will look up the splice based on the bar size and
position. The function is "=Splice(Size, Location)". Using this function, the size can reference the
cell where the bar size is located and the location is either top, bottom or comp (for compression
splices).
It also contains a splice table with named cells. For example, a #7 top splice is named "S7T".
This could be used in the takeoff by adding it to other dimensions. A column formula might look
like floor2elev - floor1elev + S7T. This will automatically add the #7 top splice.
Another function built into the spreadsheet will look up the splice based on the bar size and
position. The function is "=Splice(Size, Location)". Using this function, the size can reference the
cell where the bar size is located and the location is either top, bottom or comp (for compression
splices).
 |  |