Forums >> General Discussion >> Revit Project Management >> Calculating Total Plumbing Fixtures needed

ryantcook

active

Joined: Thu, Dec 26, 2013
0 Posts
No Rating

Good morning revitcity! [revit 2014] I am trying to create a schedule that will calculate the total amount of plumbing fixtures I need within a project. Granted, this might not actually be a plumbing schedule because the calculation per IBC works based on the sqft of the rooms and the occupancy classification of them. I have succesfully created schedules that calculate my plumbing needs for the seperate occupancy classifications, however I would like to create one schedule that will further sum all of my plumbing needs, so that I can see the total amount of each fixture needed for the overall project because the majority of our projects will have multiple classifications within one building.

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

Using Revit for thjis might be a poor application.  Revit schedules what is there, not what should be.

We have a template set up in excel for this.

This user is offline

ryantcook

active

Joined: Thu, Dec 26, 2013
0 Posts
No Rating

Yes I understand that is how schedules typically work within revit, however since the code looks to sq footages and occupancy classifications to calculate plumbing needs it would make sense that a schedule could be created that looks at room tags and determines plumbing needs. I have successfully created schedules that calculate plumbing needs seperately (a-1, a-2, ... s-2), I would just like to create one that totals these. How do you utilize excel?

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

First, Revit does not use room tags ... I know - just a slip.

Sure, you can do what you are asking but as I said, I think this is a poor application.  There are a lot of calculations required to meet and show for code and many of those are just too complicated to do in a Revit schedule. 

All of Revit schedules can be exported to a txt file which can be opened with excel.  If you set up a master excel file with your formulas, you can import the Revit data and have all of that calculated.... and recalculated as required.  YEP... the bad part of this process is that you can't put it back into Revit automatically unless you use DBlink.  But it is still a better process than creating a Revit schedule that doesn't work well if at all.

This user is offline

Plumbing Schedule Totals

1

Plumbing Fixture Schedule

0

Plumbing fixtures not displaying

4

plumbing fixtures in foundation

2

How to show plumbing fixtures on site plan?

3