Hey Todd, I use a custom property call coverage and its tied to all my products that way in my takeoff for example if I takeoff a wall that has drywall and i pick my product material of drywall 8ft @32 sf per sheet,I have it divide by the coverage which is assigned 32 sf in my product list.so if I change from 8 ft drywall to 10ft it automatically calculates the total sheets based on my product list same as lumber or any item. That way i can pick any material and it will always calculate the proper qty based on what is put in the material list.Hope that makes sense. Just putting it out there for ideas. I've been using that for years and works great
Hi John. If you are moving this logic into zzTakeoff, you can replicate this by adding a Custom Property called "Coverage" to your Takeoff/Items/Products. Then you can set that value on the Takeoff/Items/Products to get the calculation you need.
if([Coverage]<=0,0,[Area]/[Coverage])
if([Coverage]<=0,0,[Area]/[Coverage])
This allows the you to change products and have the quantity update automatically based on the selected product coverage.
Wastage and roundup do not need to be built into the formula, because zzTakeoff already handles those through the dropdown settings.
This would make the system flexible for drywall, sheet materials, timber, mesh, film, and many other products.