Back to zzTakeoff Community Channel LogoFeature Requests
David Quinn
2h 6m

Ceiling Function

Would it be possible to get a Ceiling Function from excel? This helps in determining the number of pieces needed when things are sold in increments other than 1. For example, and LVL can be sold in 2' increments, so the function Ceiling(Linear:ft,2) would always return the length rounded up to the nearest two feet. The round up function kind of does this if set up correctly, but not in every case. If I have a header that is 3 beams deep I could us this: Ceiling([Linear:FT],2)*[# of Pieces per Foot]. The final roundup function would only roundup the total lf of all three beams to the nearest 2 lf.

0
You must be logged in to post replies. If you don't have an account you can signup here.