Schedules, counting houses...

[Anonymous]

We would like to count the amount of houses in a project scene.

This scene consists of houses with 1, 2 or 3 levels. Each house has a unique number. This number is used in the area’s so we can combine all area’s belonging to one unique house. By doing this we know the total area of each house.

The question is now, how can we use this unique house id to get the total of houses?

The only feedback i get from Revit so far is the total of floor area’s. Which is a multitude of the number of houses in the project.

I hope someone can help me out.

[dferreira-blackwell]

you can create a model group for each house and schedule this model groups and set grand totals from sorting tab. you will get totals no of houses equal to total no of model groups.

[barthbradley]

Are you saying that you are combining the Areas from multiple Level Area Plans into a single Schedule?  How are you doing this?  Or, am I misunderstanding? 

[joe_keogh]

Hi @Anonymous 

Is this what you are looking for?

[joe_keogh]

Or more like this?

[Anonymous]

Thank you for your reply.

The scene consists of both appartments and houses. The appartment building is constructed as a whole. Therefor we are not able tot count the houses.

Would you know of a way to use the unique number of the area plans to count the total?

[Anonymous]

We are combining the area's at different levels of one house, as in message no. 5 is shown.

[Anonymous]

Thank you for your reply.

This is what we have now. What we would like to know is how we cvan count the total of houses:

the grandtotal in this case would be 3! (3 houses instead of 9).

Hope you can help us out.

[joe_keogh]

what I have seen companies do in the past, is create multiple schedules showing the different information about the same group of elements and place them together on a sheet.  would this work?

so for example a schedule showing the House Number and filtering that to Areas with name containing GF (Ground Floor) or beginning with 01,  placed next to a schedule that shows the total area for the corresponding Houses.

[Anonymous]

Hi Joe,

That would indeed work if we had only houses (or area's at one level) in this project. We then could only count the area's on this level and have the number of houses in the project.

Unfortunatly there are also apartments part of the project for which this does not apply. They are placed at different levels and some of the apartments are are divided over two levels.

Any thoughts?

[joe_keogh]

If every apartment and house had their base level Area named in a way such that they all began with 01 or you used the comments for this, you could filter this way.  this way they don't need to sit on the same level, you use a parameter to identify the base level, followed by further identifiers.

Revit is a database, you can only get out what you put in.

[joe_keogh]

Try this as an example

[Anonymous · Accepted solution]

This certainly could work, but is also a bit fault sensitive. We now use a unique name to merge the related area's for to get the total area of a house or apartment. The identifier for the number of houses would be a second unique identifier.

Would there be a way within revit for counting the amount of unique name's, but not the total number of area's?

The same way of what you did in your example but with the unique name as filter.

Area 01

Area 02

Area 02

Area 03

numer of unique area's: 3

Thanks, great help 🙂

[joe_keogh · Accepted solution]

I am, sure there would be a way with Dynamo, list all areas with X, filter the list and so on.  

But I think it would still be a case of adding the unique identifiers to the area level.  Alternatively model every unit as a single model and link into a site file.  Which I imagine is going to be the way you will need to proceed into documentation.

[Anonymous]

Thanks Joe.

Still hope somewhere in the future there might be a simple solution to this. But till that moment we will work with your suggestion 🙂

[joe_keogh]

I agree @Anonymous  This is a very common issue with scheduling areas and rooms.