Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Average area in Room schedule

22 ANTWORTEN 22
GELÖST
Antworten
Nachricht 1 von 23
yohaiQBCFZ
6888 Aufrufe, 22 Antworten

Average area in Room schedule

Hi,

 

I am using a room schedule and I want to create an average calculate parameter to room areas. For example say I have a room schedule that shows 10 units and a total area calculated of 1000 sf, I want a column that will automatically calculate that the average area for this units is 100 sf (even if in the model  different units are in different sizes but total to a 1000 sf)?

Thanks,

Yohai

Beschriftungen (4)
22 ANTWORTEN 22
Nachricht 2 von 23
ToanDN
als Antwort auf: yohaiQBCFZ

If you have these 10 units grouped into a single row then simply add a Calculated value parameter, type = Area, and use the formula = Area/10, the format the parameter to Calculate Totals.
Nachricht 3 von 23
yohaiQBCFZ
als Antwort auf: ToanDN

@ToanDN I need a more inclusive formula if the schedule is more complex than showing only one unit type. See attached schedule, it would be ideal if there was a formula that will calculate: Area/Count. 

Nachricht 4 von 23
ToanDN
als Antwort auf: yohaiQBCFZ

Try this file.

 

ToanDN_0-1595290304901.png

 

 

 

 

 

 

 

 

 

 

 

Nachricht 5 von 23
frederik.vannespen
als Antwort auf: ToanDN

Awesome @ToanDN .  Works like a charm, but how???  I really don't understand how this works :Gesicht_mit_Freudentränen:.  If you could explain the thought process behind this that would be much appreciated.

 

Regards and thanks for the support

Nachricht 6 von 23
ToanDN
als Antwort auf: frederik.vannespen


@frederik.vannespen wrote:

Awesome @ToanDN .  Works like a charm, but how???  I really don't understand how this works :Gesicht_mit_Freudentränen:.  If you could explain the thought process behind this that would be much appreciated.

 

Regards and thanks for the support


Edit the schedule, go to Fields tab and inspect the formulas used for: 1Count, Percent, and Average.

Nachricht 7 von 23
javierN7G4T
als Antwort auf: yohaiQBCFZ

I am not sure if its just me, but I have an issue with this, to create averages.

I have 1 bedroom units through out many floors, and I am trying to find the average of all the 1 bedrooms in the entire building.

So I have a few parameters that I am using to  make this to work (I hope)

1. Custom count parameter since the OOTB Count cannot be used in formulas.

2. Level multiplier for typical levels, Level 2-4 = 3, Level 10-14 = 5, etc.

3. Area - default OOTB to get the areas from the area plan/boundaries

4. Total Area - Area x Custom count - This will give me to total area for each 1 bedroom

5. Unit Count total - Custom count x Level multiplier - This should get me my total # of 1 bedrooms

 

I should be able to take Total Area/ Unit Total count, but its not giving me the correct value.

Per the below, Total Area / 84 is 19k...it should be 582.

It seems like its doing the averages of each unit type, then adding them all up.

What am I missing?

javierN7G4T_1-1628880206795.png

 

 

 

Nachricht 8 von 23
ToanDN
als Antwort auf: javierN7G4T

Uncheck Calculate totals for Average.

Nachricht 9 von 23
javierN7G4T
als Antwort auf: ToanDN

When I do that, it just says <varies> in the average column
Nachricht 10 von 23
ToanDN
als Antwort auf: javierN7G4T

Share your file.

Nachricht 11 von 23
javierN7G4T
als Antwort auf: ToanDN

Thanks for the help Aaron.

I did not see an option to upload a file, but see below dropbox link

https://www.dropbox.com/s/zabhb5m6xvprwb1/areas-averages.rvt?dl=0

Nachricht 12 von 23
ToanDN
als Antwort auf: javierN7G4T

ToanDN_0-1628895526726.png

 

Nachricht 13 von 23
javierN7G4T
als Antwort auf: ToanDN

Thanks, I would not have figured to use the percentage to get that to work.

 

The formula  I had was basically what you sent except w/o the percentage, the total area / (the individual count x the multipliers), which should have given me the average?

 

Guess this is just one of those revit things

Nachricht 14 von 23
ToanDN
als Antwort auf: javierN7G4T


@javierN7G4T wrote:

Thanks, I would not have figured to use the percentage to get that to work.

The % field is the key to even out different areas in the schedule.

 

The formula  I had was basically what you sent except w/o the percentage, the total area / (the individual count x the multipliers), which should have given me the average?

No.  That is the wrong formula.  That still gives you the total area (try multiplier = 1 condition you will see).

 

Guess this is just one of those revit things

Not one of those Revit things.  It is simply a math thing.  


 

Nachricht 15 von 23
javierN7G4T
als Antwort auf: ToanDN

thanks again for the help, they did not teach me in school to multiply by a percentage to get an average, learn something new everyday!
Nachricht 16 von 23
adalzell15
als Antwort auf: yohaiQBCFZ

This solution method is overly complicated, you don't need to split out the ratio as a percentage and then multiply the area by the percentage. You can make revit generate the total area for all your similar rooms, then divide by the total number of rooms. The tricky part is getting revit to let you use the total number of rooms in a formula.

Step 1, add the "name" and "area" parameters

Step 2, under the formatting tab, set "area" to "calculate maximum"

Step 3, under the "field" tab again, click the "fx" to add a calculated value, name it "COUNT" or whatever tickles your fancy, Discipline - Common, Type - Number, and for formula just put in a "1" . (NOTE, you can't use the revit field that is labeled "Count" because it doesn't work for step 4 - you don't pay autodesk enough money for it to work like that)

Step 4, click the "fx" to add a calculated value, name it "Average", Discipline - common, Type - Area(important step here), then for the formula click the "...", select area, click "/" (so you are dividing the two parameters), then click"..." again and select your "COUNT" value or whatever you named it. That's it.

 

Nachricht 17 von 23
adalzell15
als Antwort auf: yohaiQBCFZ

Oh and finally Step 5, under the "formatting" tab, select your "Average" calculated value and make sure it is set to "calculate maximum" otherwise you get a "varies" value 

Nachricht 18 von 23
ToanDN
als Antwort auf: adalzell15


@adalzell15 wrote:

Oh and finally Step 5, under the "formatting" tab, select your "Average" calculated value and make sure it is set to "calculate maximum" otherwise you get a "varies" value 


It doesn't work but I will give you a benefit of doubt by letting you correct the attach file, which was created based on the steps you have provided.

 

ToanDN_0-1658796295606.png

 

Nachricht 19 von 23
adalzell15
als Antwort auf: yohaiQBCFZ

Ahh, yes this only works for rooms with the same name. The original post mentioned units so I figured this was for a multifamily project where you may have a bunch of similar units that are all type A.1 or something but maybe some are slightly different areas due to a shaft or column or whatever. Developers request average unit sizes all the time.

I don't know why you would need average room sizes for a bunch of random rooms - how would that be useful? I don't think the percentage method would work in this instance either.

Take the "Name" parameter out of there and then it would probably work.

Nachricht 20 von 23
ToanDN
als Antwort auf: adalzell15


@adalzell15 wrote:

Ahh, yes this only works for rooms with the same name. The original post mentioned units so I figured this was for a multifamily project where you may have a bunch of similar units that are all type A.1 or something but maybe some are slightly different areas due to a shaft or column or whatever. Developers request average unit sizes all the time.

I don't know why you would need average room sizes for a bunch of random rooms - how would that be useful? I don't think the percentage method would work in this instance either.

Take the "Name" parameter out of there and then it would probably work.


Okay. Here is one with Rooms with the same name and one with Name removed from schedule.  Neither gives average area. 

 

As to why someone needs an average area of random rooms, you need to ask @yohaiQBCFZ because he didn't ask the question just for fun.  Trying to invalidate the question because you cannot answer it correctly is a poor form of contribution.

 

ToanDN_2-1658797792486.png

 

ToanDN_1-1658797763077.png

 

 

 

 

 

 

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report