Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Plumbing Calculations Schedule

17 REPLIES 17
SOLVED
Reply
Message 1 of 18
aishwaryagNEDYQ
962 Views, 17 Replies

Plumbing Calculations Schedule

aishwaryagNEDYQ
Participant
Participant

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.

 

0 Likes

Plumbing Calculations Schedule

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.

 

17 REPLIES 17
Message 2 of 18

barthbradley
Consultant
Consultant

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. 

0 Likes

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. 

Message 3 of 18

aishwaryagNEDYQ
Participant
Participant

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

0 Likes

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

Message 4 of 18

barthbradley
Consultant
Consultant

@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.  

0 Likes


@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.  

Message 5 of 18

aishwaryagNEDYQ
Participant
Participant

Got the solution

0 Likes

Got the solution

Message 6 of 18

aishwaryagNEDYQ
Participant
Participant
Posted a link for you
0 Likes

Posted a link for you
Message 7 of 18
ToanDN
in reply to: aishwaryagNEDYQ

ToanDN
Consultant
Consultant

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?

0 Likes

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?

Message 8 of 18
aishwaryagNEDYQ
in reply to: ToanDN

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

Thank you. The formula has to be "Occupant Breakdown(Male)/75". Currently, both the assemblies are taking the same formula.
Message 9 of 18
ToanDN
in reply to: aishwaryagNEDYQ

ToanDN
Consultant
Consultant

@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?

0 Likes


@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?

Message 10 of 18
aishwaryagNEDYQ
in reply to: ToanDN

aishwaryagNEDYQ
Participant
Participant
No threshold for A-2
0 Likes

No threshold for A-2
Message 11 of 18
ToanDN
in reply to: aishwaryagNEDYQ

ToanDN
Consultant
Consultant
Accepted solution

ToanDN_0-1678222399187.png

 

 

 

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

0 Likes

ToanDN_0-1678222399187.png

 

 

 

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

Message 12 of 18
aishwaryagNEDYQ
in reply to: ToanDN

aishwaryagNEDYQ
Participant
Participant
Can you please share the file with me?
0 Likes

Can you please share the file with me?
Message 13 of 18
ToanDN
in reply to: aishwaryagNEDYQ

ToanDN
Consultant
Consultant

@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.

 

 

0 Likes


@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.

 

 

Message 14 of 18
aishwaryagNEDYQ
in reply to: ToanDN

aishwaryagNEDYQ
Participant
Participant
Thank you! Let me check if that works for me.
0 Likes

Thank you! Let me check if that works for me.
Message 15 of 18
ToanDN
in reply to: aishwaryagNEDYQ

ToanDN
Consultant
Consultant

For LAV:

 

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

0 Likes

For LAV:

 

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

Message 16 of 18
aishwaryagNEDYQ
in reply to: ToanDN

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

For LAV, the final value per normal calculations must be "3.88" but Revit is calculating as "5.76" which is wrong.
Message 17 of 18
ToanDN
in reply to: aishwaryagNEDYQ

ToanDN
Consultant
Consultant

@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.

0 Likes


@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.

Message 18 of 18
3rez
in reply to: ToanDN

3rez
Explorer
Explorer

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

0 Likes

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

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report