unit matrix quantifier

[aclarke]

Hi all,

We are not using 'Spaces' or 'Rooms', how would you do this?

We have a unit/space matrix and I need to quantify all elements in a single unit (Unit A1) and then multiply this by as many Unit A1 in the building.  Then Unit A2 and so on...

My current approach, we have a dummy family that we use as a space tag, and we place this in every unit and I can quantify this tag but I need to multiply this by each element count in this single unit to get a grand total.  I am struggling to multiply the number of tags by the number of element using the schedule, I don't think it can be done, but I need another opinion before I start coding my solution, I would rather keep within the realm of OOTB Revit if I can.

Thanks

[iainsavage]

“I would rather keep within the realm of OOTB Revit if I can.”

So why would you not use Spaces if that would give the information that you need?

Or create a text parameter, associate it with all relevant categories, then for each unit type select all elements and give their parameter an appropriate value. You can then filter, sort and totalise in schedules using that parameter as the criterion.

[aclarke]

hi,
the associated parameter idea is the exact thing we are doing, we model out one unit type then quantify this by the number of unit types. We use a generic model with labels as a tag to quickly tag all the unit types, I would like to quantify the tags against this one unit.

We don't use spaces because the majority of Arch links don't use rooms so we are left to build our own spaces which is not time efficient

The solution I came up with is to create a parameter to hold a count value and build an Updater that counts when the dummy tag is created or deleted then multiply this count value against the elements labeled as in a specific unit. But if there is a way for me to access the count of an element in a schedule, some super user trick?

[ToanDN]

Add you own calculated value Count parameter (I use Qty), type = Integer, formula = 1 ( no need the =). Then use it is rated of the built-in Count.

[aclarke]

I understand what your are saying, the Count Dracula trick.
Lets say I have two air terminal types
type1 and type2
I have 12 type1 and 3 type2
and I have 4 identical units Unit A1

Type1 = 12
Type2 = 3
Unit A1 Tags = 4

how do I get that 4 to multiply by the 12 and by the 3 so I have this

Unit A1
Type1 Total = 48
Type2 Total = 12

[ToanDN]

Create Unit parameter and enter Unit # for all air terminal instances. Sort schedule by Unit then by Type, uncheck Itemize every instance. Set Qty field to Calculate Totals.

[aclarke]

Thanks for your help,

All your steps get me here, but I need the Total column, how do I multiply the 3 by all those 2's to get the 6's?

I manually entered the 6's to show my desired result.