Calculating Floor Efficiency

[jfjacques]

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. 

[barthbradley]

Post your "close to something workable" Project file.     

[jfjacques]

the schedule is "stat_X % efficacite..."

[ToanDN · Accepted solution]

Try this file:

[jfjacques]

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.  

[ToanDN]

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

[jfjacques]

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!

[britt_weidemann]

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?

[admaecc211151]

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

[admaecc211151]

Here is made by 2020