Q & APull 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.
Hello Mr. Kellenberger,
Sorry for leaving you hanging, I had put everything on pause since I am the only one working on this, and they were coming out with some pretty cool updates. They did not disappoint, but I would really like to connect sometime and go over what you have been working on. Our mutual friend Todd, has told me that you were working on some pretty cool formulas.