Q & A
Fernando Ramirez Pull Logic from the takeoff level to items
Hello, I had a formula that can help with x and y spacing if need be and additional stirrup, where would I apply the ../ in the formula for the clearance and double mat.
(((((([Linear:FT]-(2*(if(../[3in Clearance (Y)],3,1))/12))*(ceil((([Width]-(2*(if(../[3in Clearance (X)],3,1))/12))/([OC Spacing (X axis) inches]/12)))+1))+((ceil((([Width]-(2*(if(../[3in Clearance (X)],3,1))/12))/([OC Spacing (X axis) inches]/12)))+1)*(fix((([Linear:FT]-(2*(if(../[3in Clearance (Y)],3,1))/12))/[Bar Length])))*([Splice Length inches]/12)))*[LBS per Foot (X)])+((([Width]-(2*(if(../[3in Clearance (X)],3,1))/12))*(ceil((([Linear:FT]-(2*(if(../[3in Clearance (Y)],3,1))/12))/([OC Spacing (Y axis) inches]/12)))+1)))*[LBS per Foot (Y)])(if(../[Double Mat],2,1))+((([Stirrup Length]+0)*(ceil((([Linear:FT]-(2*(if(../[3in Clearance (Y)],3,1))/12))/([OC Spacing (X axis) inches]/12)))+1))*[LBS per Foot (X)]))
Hey Fernando, I believe Todd helped you fix this formula, but just replying here for everyone else. When applying the "../" or any traversal commands in the formula, you need to include them within the square brackets:
Example: "[../Double Mat]" or "[../3in Clearance (Y)]"
To fix your formula, you will need to move the '../' within the '['
Fernando, that is a impressive formula, would you mind sharing a screenshot of the takeoff and the item so we can see the whole picture?
Maybe similar to my pic below.
