How to calculate the average room area in schedule

[brenTRONwiberg]

Hey folks, I have racked my brain and cannot find a solution for one of the easiest calculations.

See the attached schedule and calculated value. I'm simply trying to take the area of my building and divide it by the total room count to get the average area of a room in the building. This is for a self-storage facility and the average storage unit area is an important statistic.

In my schedule I added the "Unit Count Number" parameter to the rooms. Each room has a value of 1. I did this because I could not use the default "Count" parameter in a calculated value.

In my schedule, you can see then that I have column "C" "Unit Count Number" which is totaling the amount of units of each size (5x5, 10x10, etc...) and then has a grand total at the bottom of the column.

Additionally I have the "Area" and "Marketable SF" (Marketable SF is a custom parameter I made for each room because what we market round number areas rather than exact areas so this value is slightly different than the Area parameter calculated by Revit) parameters which is also totaling the area for all the units of a size and then has a grand total at the bottom of the column.

All I want to do is have the "Average Area" column display the Area/Unit Count Number or Marketable SF/Unit Count Number. and have it give me an average size per row and a grand total at the bottom of the column. You would think this is simple enough but it doesn't seem to work. You can see my image of the calculated value I setup. I think I am doing it correctly, but in the schedule it's dividing the areas by 1 so that the Average Area, is the same number as the Marketable SF. Why is this? Why can't I get it to calculate properly?

For example the 5x5 units have a count of 122 units and a total marketable SF of 3050 so the Average Area should be 25 SF (3050/122) Likewise the grand total at the bottom of Unit Count Number is 1160 and the total Marketable SF is 108350, so the total Average Area should be 93.41 SF.

Any ideas on how to get this to behave?

[ToanDN · Accepted solution]

See if this is similar to what you want.

[barthbradley]

You can't use the Count though.

What about something like this?

[syman2000 · Accepted solution]

I am able replicate your issue. The problem lies with unit number set to 1. This number need to be your total unit number. Revit for some odd reason won't recognized Calculated total value. It will recognized only if this value is set as your manually type in value.

To solved this make this box value not calculated total. Enter in the value the same as count and you will get your average.

[ToanDN · Accepted solution]

Did you look at the example file I posted.  It does exactly what you want without manually entering the quantity.

[brenTRONwiberg]

Hmm, I got excited for a minute, but I cannot get the "Precentage" calculated value "By" to set to "Type". It only allows grand totals. See the attached.

[brenTRONwiberg]

For some reason the forum isn't allowing me to post my file. Basically though, when you use area and a room schedule instead of your schedule, it doesn't allow for you to change the "by" to "type" like you have in your schedule.

[ToanDN · Accepted solution]

The percentage parameter in this formula is not the same as the one you show in your earlier post. It should be by Name and it can be hidden on the schedule.

[brenTRONwiberg]

Ok, perfect, I got it to work so that the rows show the average, but then the total is wrong. Right now this is what I have: Name Count Area 1Count Precentage Average 25x10 3 681 3 100% 227 30x10 3 821 3 100% 273 6 1503 6 500 So it's just adding up all the average areas? I think I'd rather it take the total square footage and divide it by the total amount of units. I'm trying to get the average size of a unit on this project. Now that I review my original post, I see that I described it in a confusing manner.

[brenTRONwiberg]

Wow, when I posted, it messed up all my formatting, so that my last post is a mess. I got it to do what I want using what you described, then just sorted by "1Count" which made one row with totals, the average column is then correct.