Plumbing Calculations Schedule

[aishwaryagNEDYQ]

Hi. I am working on a project that has A-2 assembly and B and I want them in the same schedule using an area plan. I am using the formula for B group that is also being used for A-2 which is not right. I have attached a screenshot for you to guide me on how to go about it.

FYI: Not all calculations are right. I am trying to figure out how it would work for one first.

[barthbradley]

Where is "Required Male WC" being used in Schedule?  Which column?  Maybe it would be better to just post the file for us to analyze. 

[aishwaryagNEDYQ]

"Required Male WC"would be used for Water closets "male" - the value that shows 5.50 for Business and 3.58 for A-2

[barthbradley]

---

@aishwaryagNEDYQ wrote:

"Required Male WC"would be used for Water closets "male" - the value that shows 5.50 for Business and 3.58 for A-2

---

Okay, whatever. Just make it easy for us to help you. Post your file.  

[aishwaryagNEDYQ]

Got the solution

[aishwaryagNEDYQ]

Posted a link for you

[ToanDN]

You would need to introduce another Integer or Y/N parameter to distinguish A2 and B, and use it as a conditional factor to create a nested formula.

If this formula is for B:

if((OCCUPANCY LOAD < 50), ([Occupant Breakdown(Male)] / 75), (2 + ([Occupant Breakdown(Male)] - 50) / 50))

what is the formula for A-2?

[aishwaryagNEDYQ]

Thank you. The formula has to be "Occupant Breakdown(Male)/75". Currently, both the assemblies are taking the same formula.

[ToanDN]

---

@aishwaryagNEDYQ wrote:
Thank you. The formula has to be "Occupant Breakdown(Male)/75". Currently, both the assemblies are taking the same formula.

---

So for group A-2, is the formula always Occupant Breakdown(Male)/75 regardless of the load, no threshold at 50 like group B?

[aishwaryagNEDYQ]

No threshold for A-2

[ToanDN · Accepted solution]

if(B, (if((OCCUPANCY LOAD < 50), ([Occupant Breakdown(Male)] / 75), (([Occupant Breakdown(Male)] - 50) / 80) + 2)), [Occupant Breakdown(Male)] / 75)

[aishwaryagNEDYQ]

Can you please share the file with me?

[ToanDN]

---

@aishwaryagNEDYQ wrote:
Can you please share the file with me?

---

Too big to post. 

You can simply add a Y/N parameter, tick teh box for B row, untick for A-2 row.  Then edit the formula, for example for Required male WC:

if(B, (if((OCCUPANCY LOAD < 50), ([Occupant Breakdown(Male)] / 75), (([Occupant Breakdown(Male)] - 50) / 80) + 2)), [Occupant Breakdown(Male)] / 75)

Do it for all other columns that you need.

[aishwaryagNEDYQ]

Thank you! Let me check if that works for me.

[ToanDN]

For LAV:

if(B, (if((OCCUPANCY LOAD < 80), ([Occupant Breakdown(Male)] / 40), (([Occupant Breakdown(Male)] - 80) / 80) + 2)), [Occupant Breakdown(Male)] / 200)

[aishwaryagNEDYQ]

For LAV, the final value per normal calculations must be "3.88" but Revit is calculating as "5.76" which is wrong.

[ToanDN]

---

@aishwaryagNEDYQ wrote:
For LAV, the final value per normal calculations must be "3.88" but Revit is calculating as "5.76" which is wrong.

---

I can see why.  You have the schedule unitemized so it gives the false reception of one big area for each group but in fact they are many individual rooms.  Your formula wants to work with a lump sump area, not multiple areas.  I don't have a solution at the moment, need to think a bit more.

[3rez]

@ToanDN Was there a solution to handle the multiple areas calculating incorrectly instead of the sum of the area type occupants?