topic Calculating Floor Efficiency in Revit Architecture Forum

Calculating Floor Efficiency

jfjacques — Sun, 14 Jan 2024 16:59:50 GMT

I want to achieve the following via Revit Schedules

The columns below are : TOTAL FLOOR AREA and EFFICIENCY (The schedule is sorted by floor. It is also in french.)

EFFICIENCY = TOTAL FLOOR AREA / SELLABLE FLOOR AREA

I am testing my prototype floor by floor. As you can see below, I am able to obtain the Level's efficiency value given VENDABLE: a Yes/No parameter that serves to filter out service/common spaces from AREA_VENDABLE. (Perhaps there is an automatic way to achieve this separation, but given the lack of strings as conditions, I haven't been able to figure it out. Suggestions are welcome.) I also divide areas with their concommitant percentage of the total Level area, thereby given me the "total area" in AREA/ AREA % and AREA_VENDABLE/AREA_VENDABLE% elements.

When I un-itemize every instance I get "varies" as there is more than one value in my AREA_VENDABLE/AREA_VENDABLE % column.

How can I work around this? I am close to something workable, but I don't mind changing the schedule if it's a dead end.

Re: Calculating Floor Efficiency

barthbradley — Sun, 14 Jan 2024 18:28:35 GMT

Post your "close to something workable" Project file.

Re: Calculating Floor Efficiency

jfjacques — Sun, 14 Jan 2024 23:00:28 GMT

the schedule is "stat_X % efficacite..."

Re: Calculating Floor Efficiency

ToanDN — Sun, 14 Jan 2024 23:50:09 GMT

Try this file:

Re: Calculating Floor Efficiency

jfjacques — Tue, 16 Jan 2024 17:00:31 GMT

thx! solves the part I was missing : taking a sum total, X, appearing in every row, and placing it back as a grand total Y.

In other words, dividing X by the number of times it appears in a column, so that, when added into Y as a grand total, Y now equals the orginal X value.

Re: Calculating Floor Efficiency

ToanDN — Wed, 17 Jan 2024 00:51:43 GMT

I actually am impressed that you can make out the logic just by looking at the file. Good job.

Re: Calculating Floor Efficiency

jfjacques — Wed, 17 Jan 2024 02:11:23 GMT

Thanks. And thanks again for the solution. Afraid to ask, but would you have an idea how to skip the "Rentable" YES/NO step? It would be nice if the schedule recognized, say, 1-4 bedrooms, as rentable without having to check them off. I was thinking this would be a straightforward conditional statements, but learned that the condition can't be a string!

Re: Calculating Floor Efficiency

britt_weidemann — Thu, 20 Jun 2024 00:16:35 GMT

Hi, I am looking to solve a similar issue but working in 2023 so cannot open the files attached

is it possible to explain how this is done?

Re: Calculating Floor Efficiency

admaecc211151 — Mon, 24 Jun 2024 01:08:23 GMT

Revit cannot use string for checking condition.
https://help.autodesk.com/view/RVT/2025/ENU/?guid=GUID-A0FA7A2C-9C1D-40F3-A808-73CD0A4A3F20

One way to do similar things is to build a schedule key for your project. (Or maybe save it for your Template project too.) Then you can lock/change several room parameters by changing the key parameter.
https://help.autodesk.com/view/RVT/2025/ENU/?guid=GUID-CD22DA24-4162-4AB2-B1D3-02CEBE918444

Re: Calculating Floor Efficiency

admaecc211151 — Mon, 24 Jun 2024 01:23:33 GMT

Here is made by 2020