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: 

Calculating Floor Efficiency

9 ANTWORTEN 9
GELÖST
Antworten
Nachricht 1 von 10
jfjacques
960 Aufrufe, 9 Antworten

Calculating Floor Efficiency

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

jfjacques_0-1705191914621.png

 

 

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. 

 

jfjacques_1-1705192423915.png

 

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

 

jfjacques_2-1705193199375.png

 

 

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. 

 

 

9 ANTWORTEN 9
Nachricht 2 von 10
barthbradley
als Antwort auf: jfjacques

Post your "close to something workable" Project file.     

Nachricht 3 von 10
jfjacques
als Antwort auf: barthbradley

the schedule is "stat_X % efficacite..."

Nachricht 4 von 10
ToanDN
als Antwort auf: jfjacques

Try this file:

 

ToanDN_0-1705276165451.png

 

Nachricht 5 von 10
jfjacques
als Antwort auf: ToanDN

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.  

Nachricht 6 von 10
ToanDN
als Antwort auf: jfjacques

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

Nachricht 7 von 10
jfjacques
als Antwort auf: 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!

 

Nachricht 8 von 10
britt_weidemann
als Antwort auf: ToanDN

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?
Nachricht 9 von 10
admaecc211151
als Antwort auf: jfjacques

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
Nachricht 10 von 10
admaecc211151
als Antwort auf: britt_weidemann

Here is made by 2020

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