I need to calculate itemized instances from a schedule. I can't make a formula using the Count parameter, Revit gives an error. What is the best way to accomplish the following?:
1. Multiply Count * CWFU, Count * HWFU, and Count * WFU
2. Total each formula total CWFU, HWFU, and WFU
See the attached table.
I have found that if you add a shared parameter called "COUNT" to your pumbing files and set this paramter to equal 1 you can then add it to your schedule and use it in calculations.
You can then use the paramters CWFU, HWFU and WFU as the totaled CWFU, HWFU, WFU.
Add a new calculated paramter with a formula of CWFU*COUNT, HWFU*COUNT and WFU*COUNT for the "fixture unit each".
Sounds completely backwards but works!
On the other hand one can add a ton of parameters to the plumbing family and perform the math in the family iteself first.
ie:
Count =1
CombFU = <plumbing code value>
Comb HWFU = Count * HWFUeach
HWFUeach = CombFU * 0.75
Comb CWFU = Count * CWFUeach
CWFUeach = CombFU * 0.75
etc...
I have used this method successfuly in Revit Architecture in the past. The downside is all the work to setup a plumbing family with shared parameters. Also, there is some sloppyness of this is method in Revit MEP as it won't tie to Revits parameters CWFU,HWFU,WFU to perform the pipe sizing calculations. Nor is there a way to tie them together unless one sets up a schedule and monitors it with the help of a conditional format.
Is there really a clean way to assign code values to plumbing fixtures and get it to tabulate the way we want it to?