Average area in Room schedule

[yohaiQBCFZ]

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

[ToanDN]

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.

[yohaiQBCFZ]

@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. 

[ToanDN · Accepted solution]

Try this file.

[frederik.vannespen]

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

Regards and thanks for the support

[ToanDN]

---

@frederik.vannespen wrote:

Awesome @ToanDN .  Works like a charm, but how???  I really don't understand how this works 😂.  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.

[javierN7G4T]

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?

[ToanDN]

Uncheck Calculate totals for Average.

[javierN7G4T]

When I do that, it just says <varies> in the average column

[ToanDN]

Share your file.

[javierN7G4T]

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

[ToanDN]

[javierN7G4T]

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

[ToanDN]

---

@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.  

---

[javierN7G4T]

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!

[adalzell15]

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.

[adalzell15]

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 

[ToanDN]

---

@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.

[adalzell15]

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.

[ToanDN]

---

@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.