Is it possible to alter labor hours using a calculation without changing the takeoff unit to hours in Estimating Extended?

I want to add a calculation in my assembly that will change the labor hours behind the scenes. My takeoff unit is EA and I don't want to change that.

For example:

If I have a qty of 10, I want my labor hours to be unaffected.

If I have a qty of 25, I want my labor hours to multiplied by .80 (or 80 percent) making the time to do the same "task" less than if there were a qty of 10. That line item will have the same labor productivity, no matter what qty is entered at the start.

Please let me know if there is a way to put that into a calculation.

Thanks!

  • 0
    agoricki, I have not tried to do what you want, but if I were to try, I would use a Table. In that table you can insert multiply items and set a formula for each. This may accomplish what you a looking for. Another way in is to insert Items directly into the assembly and and choose the item that corresponds to your quantity takeoff (each item having a different production rate-this is what is happening with the .80). You can use an 'If' statement in the Assembly formula to display item options based on quantity input. I believe it is possible, you may have to think geometrically.