topic Creating capacity from family count in Revit Architecture Forum

Creating capacity from family count

Anonymous — Wed, 18 Aug 2021 11:08:42 GMT

Hi there

I can do this outside of revit with a pivot or vlookup but was wondering if it is possible to do inside the program.

I have a chair family that I am using to populate stages in my building. Obviously this is creating a count per room. I was wondering is it possible to use this count to generate the room capacity? Could a formula direct it to look towards this number so it was dynamic if the chair count changed? Or is not could I create a new shared Parameter called "Stage Capacity" that could do this by using a Global Parametre?

Any and all help is greatly appreciated

Re: Creating capacity from family count

RDAOU — Wed, 18 Aug 2021 12:26:55 GMT

@Anonymous

Not sure if this is exactly what you are after but there are several posts on how to use the calculated total of Count in schedules...But the count is basically in the Components Schedule (ie: Chairs). Copying that to the room schedule (or a parameter in the rooms) would need a workaround (such as Dynamo)

However, considering that room schedules can have sub/embedded schedules, you might be able to use this to generate the desired output

https://knowledge.autodesk.com/support/revit-products/troubleshooting/caas/sfdcarticles/sfdcarticles/Cannot-include-count-parameter-in-the-new-calculated-value-while-creating-Schedule-in-Revit.html

https://forums.autodesk.com/t5/revit-architecture-forum/using-schedule-calculated-total-in-a-formula/td-p/5471470

http://revitcat.blogspot.com/2019/08/using-count-parameter-in-revit-schedule.html

Re: Creating capacity from family count

ToanDN — Wed, 18 Aug 2021 13:01:27 GMT

You can create a furniture schedule, add room information, get the count per room, and format the schedule so it looks like a room schedule.

Alternatively, you can embed a furniture schedule in a room schedule. The information is there but I have always found the formatting, appearance of such schedule being difficult to digest.

If you want to embed the chair count information into the room data such in a room tag then you would need Dynamo.

Re: Creating capacity from family count

Anonymous — Wed, 18 Aug 2021 13:58:50 GMT

Thanks @RDAOU, the Revitcat blog article was really informative though I couldn't get exactly what I wanted.

And also thank you @ToanDN, I'm using that method and it looks clean and simple but I wanted to be able to tag it. For now I can just update the tags manually. Some day I must really get around to using Dynamo, but today is not that day!

Re: Creating capacity from family count

barthbradley — Wed, 18 Aug 2021 16:50:00 GMT

I'm unclear about what you are wanting to do. Almost sounds like a job for Generative Design.

https://help.autodesk.com/view/RVT/2022/ENU/?guid=GUID-6E8C0DAD-A61C-476D-98C2-1A9A04EAFC62

Am I warm? 😉

Re: Creating capacity from family count

ToanDN — Wed, 18 Aug 2021 17:03:13 GMT

@Anonymous

In Revit 2022 you can add Host Count to a Tag but you need to add all the chairs in the room as Host to that tag.