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: 

Exterior window area to floor ratio calculation

22 ANTWORTEN 22
GELÖST
Antworten
Nachricht 1 von 23
Marcus.Isacsson
6956 Aufrufe, 22 Antworten

Exterior window area to floor ratio calculation

Hi fellas!

We need a way to calculate the ratio between exterior windows to floors.
How would you guys create your setup for this?

Is it possible within standard Revit schedule configurations or do we need to use something like Dynamo?

22 ANTWORTEN 22
Nachricht 2 von 23
Ilic.Andrej
als Antwort auf: Marcus.Isacsson

Ok, I have a solution for you. No Dynamo. Just pay attention to all the details.

 

Step 1: Create a project parameter (manage/project parameters). The type of param is <<Area>, assign it to <<Windows>>, call it "Floor Area". This will later be hidden field.

 

Step 2: Create a floor schedule. You will not put this schedule on a sheet. It will serve to extract data. Assign <<Area>> field. 

 

Step 3: Create a window schedule. Assign these fields: "Width", "Height" and "Floor Area".

 

Step 4: Create a calculated value. This will be << Slope >>> parameter. Lets call it "Ratio". Assign this formula: Width * Height / Floor Area

 

Step 5: Go to Schedule Properties/Sorting and Grouping. Uncheck <<Itemize every instance>>

 

Step 6: Go to Schedule Properties/ Formatting. Select All fields one by one and use dropdown menu to set <<Calculate Totals>>.

 

Step 7 Go to Schedule Properties/ Formatting. Select "Ratio". Go to <<Field Format>>. Uncheck <<Use project settings>> You have two good options for what you need. Set <<Units>> to be 1:x or percentage. Set Unit Symbol to be <<1:>> or <<%>>, depending on what units you chose.

 

Step 8: This step is described with pictures. Click on the image to enlarge it.

 

1.jpg2.jpg3.jpg

 

 

I know that this requires you to copy value from one schedule and then paste it to another. But, I'm sure that this ratio is something you will use not very often. You will probably use it when the project is almost finished. It serves just to verify that what you did is good. 



Andrej Ilić

phonetical: ændreɪ ilich
MSc Arch

Autodesk Expert Elite Alumni

Nachricht 3 von 23
Marcus.Isacsson
als Antwort auf: Ilic.Andrej


@Ilic.Andrej wrote:

Ok, I have a solution for you. No Dynamo. Just pay attention to all the details.

 

Step 1: Create a project parameter (manage/project parameters). The type of param is <<Area>, assign it to <<Windows>>, call it "Floor Area". This will later be hidden field.

 

Step 2: Create a floor schedule. You will not put this schedule on a sheet. It will serve to extract data. Assign <<Area>> field. 

 

Step 3: Create a window schedule. Assign these fields: "Width", "Height" and "Floor Area".

 

Step 4: Create a calculated value. This will be << Slope >>> parameter. Lets call it "Ratio". Assign this formula: Width * Height / Floor Area

 

Step 5: Go to Schedule Properties/Sorting and Grouping. Uncheck <<Itemize every instance>>

 

Step 6: Go to Schedule Properties/ Formatting. Select All fields one by one and use dropdown menu to set <<Calculate Totals>>.

 

Step 7 Go to Schedule Properties/ Formatting. Select "Ratio". Go to <<Field Format>>. Uncheck <<Use project settings>> You have two good options for what you need. Set <<Units>> to be 1:x or percentage. Set Unit Symbol to be <<1:>> or <<%>>, depending on what units you chose.

 

Step 8: This step is described with pictures. Click on the image to enlarge it.

 

 

 

 

I know that this requires you to copy value from one schedule and then paste it to another. But, I'm sure that this ratio is something you will use not very often. You will probably use it when the project is almost finished. It serves just to verify that what you did is good. 


Sometimes we have requests from the customer that the window area shouldn't be more than a certain percentage of the floor area.
Would be neat to have those requirements checked with an automatic schedule. 

The workaround you present can be good enough but it's a bit of a shame that we have to manually copy values.
Also, is it possible to get the window area compared room by room? Because this will create a total ratio, right?

I'm looking for a way to easily tell which rooms have a problem regarding those demands. 

Nachricht 4 von 23
Ilic.Andrej
als Antwort auf: Marcus.Isacsson

Ok, now I know that this about rooms. I think this can be solved with a multi-category schedule. Give me a sec...



Andrej Ilić

phonetical: ændreɪ ilich
MSc Arch

Autodesk Expert Elite Alumni

Nachricht 5 von 23
Ilic.Andrej
als Antwort auf: Marcus.Isacsson

Nop, sorry I can't do it. The only thing that crosses my mind is that you can create a room schedule and use custom proj parameters which are assigned to rooms. Those will define window surface. For example, you can just add values for widths and heights of windows which are facing a room, make calculated values and go from there...

 



Andrej Ilić

phonetical: ændreɪ ilich
MSc Arch

Autodesk Expert Elite Alumni

Nachricht 6 von 23
Marcus.Isacsson
als Antwort auf: Ilic.Andrej

Maybe it's included somehow in Autodesk Green Building Studio?
I haven't tried that solution yet. 

Nachricht 7 von 23
cbcarch
als Antwort auf: Marcus.Isacsson

Not exactly what you are asking for, but this might be helpful?

 

http://blogs.autodesk.com/insight/facade-design-with-insight-webinar/

Cliff B. Collins
Registered Architect The Lamar Johnson Collaborative Architects-St. Louis, MO
Nachricht 8 von 23
Sahay_R
als Antwort auf: Marcus.Isacsson

Can the window schedule be nested : appended? I'm not in front of Revit right now, so I'm just thinking aloud...

Rina Sahay
Autodesk Expert Elite
Revit Architecture Certified Professional

If you find my post interesting, feel free to give a Kudo.
If it solves your problem, please click Accept to enhance the Forum.
Nachricht 9 von 23
FAIR59
als Antwort auf: Marcus.Isacsson

try this ,

no manual input required, except of course for the glazed_area of the window (project parameter)

 

windows schedule:

 

  1. "known" fields: glazed_area, To Room: Name, To Room: Area
  2. calculated fields:
    • glazed_area_weighted ( percentage of glazed_area by To Room: Name)
    • room_area_weighted ( parametertype Area / formula: To Room: Area * glazed_area_weighted )
    • ratio_test ( parametertype Number / formula:  glazed_area / (To_Room: Area * glazed_area_weighted) )
  3. filter for windows with glazed_area > 0
  4. sorting:  To Room: Name
  5. conditional format on ratio_test

 

picture_1.JPGpicture_2.JPG

Nachricht 10 von 23
FAIR59
als Antwort auf: FAIR59

here is my Revit2017 test file

Nachricht 11 von 23
Marcus.Isacsson
als Antwort auf: FAIR59


@FAIR59 wrote:

here is my Revit2017 test file


Thanks alot. I'll check it out and get back to you! :leicht_lächelndes_Gesicht:

Nachricht 12 von 23
damian
als Antwort auf: FAIR59

Hi FAIR59, thanks for your solution.

I've been looking at this for a while, and came across your solution this morning. I've been trying to see how you've done this by reverse engineering your rvt file. I cannot seem to place any new windows into the room that will update the ratio_test calculation.

I've tried to insert another of your windows but, whilst it shows on plan and seems to be identical to the other two, it does not appear in the window schedule. And I cannot copy a window as I get an error message that "Can't place inserts outside of hosts".

How have you hosted the windows?

Thanks again.

Damo

Nachricht 13 von 23
FAIR59
als Antwort auf: damian

The Windows are hosted on a wall.

As you can see, in the schedule there is a filter for the ToRoom name. If your new windows don't appear in the schedule then they are facing the wrong direction (i.e. ToRoom.Name is blank, and FromRoom.Name is the room name.)  [ Placing the windows in a 3D View on the interior side of the wall, should result in the correct facing direction]

 

General Solution:

Make a second window schedule, 

Fields: Family & Type, ToRoom.Name, FromRoom.Name.

Sorting/Grouping: Itemize every instance Checked

In this schedule you can swap the ToRoom.Name with the FromRoom.Name.

Nachricht 14 von 23
damian
als Antwort auf: FAIR59

Hi FAIR59,

 

Thank you for your reply, appreciated.

In fact, about 30minutes before your post whilst I was still playing with the Revit file I found I was able to place windows, don't know if I had a glitch (I'm using Revit 2019) as I certainly couldn't place windows earlier, but anyway....

 

However, moving on, I then wanted to see if I could add in my own windows. Placing them was OK, and I manually entered the 'glazed_Area" data under the Type Properties -> Dimensions parameter, but this isn't showing up in the schedule. Wondering if this is related to the 'KC_Kozijnmerk' parameter under Identity Data? Do I need to add this 'KC_Kozijnmerk' to my windows too for them to show up in the schedule, or is there something else I need to add to my window families?

 

By the way, thank you for the Revit file, I have not found any other solution on Google nor in my Mastering Revit books.

 

Nachricht 15 von 23
FAIR59
als Antwort auf: damian

You can remove the KC_Kozijnmerk filter. I used that to limit the schedule to a few windows in a large project.

The main purpose of those filters is to have only elements with a glazing_area >0 in the schedule.

Nachricht 16 von 23
damian
als Antwort auf: FAIR59


@FAIR59 wrote:

You can remove the KC_Kozijnmerk filter. I used that to limit the schedule to a few windows in a large project.


OK, understood.

Could you give me some guidance on what I need to do to get my own windows to show in the schedule please?

I'm failing here, spent a good few hours (learning lots) from your family but not managing to get my window to show in your schedule. What am I missing?

 

Thanks

Damian

Nachricht 17 von 23
FAIR59
als Antwort auf: damian

attach a project file, where you placed your own windows, and i'll have a look.

Nachricht 18 von 23
damian
als Antwort auf: FAIR59

Thanks, attached (version 2019)

 

I've also noticed that if I place a window the wrong way around, it doesn't schedule even after I flip it inside:outside. Again, maybe something to do with Revit 2019.

Nachricht 19 von 23
FAIR59
als Antwort auf: damian

Flipping a window and assigning ToRoom/FromRoom are 2 separate mechanisms. Changing one doesn't change the other.

You can however link them, by checking the Room Calculation Point parameter in the family-editor.

familyparams.PNG

If you do that, make sure that the arrow of the Room Calculation Point points to the interior, using the flip control of the selected Room Calculation Point.

flipcontrol.PNG 

Pointers to get things right:

  • remove the KC_kozijnmerk filter

schedule_filters.PNG

  • assign value to glazed area parameter for  family type Velfac200 1224 (Stru.1248)w x 500h 
  • if you also need instances of the category [Doors] (e.g. sliding door Velfac237) in the schedule, you first need to make a new MultiCategory-schedule with the same fields, filters and sorting/grouping.  and secondly modify the Project Parameter glazed area to include the Doors-category. 
Nachricht 20 von 23
damian
als Antwort auf: FAIR59

Thanks once again FAIR59. I was busy on other items beginning of this week, got around to doing this on Wed, Your guidance was great. All working perfectly now for my windows.

 

But..... yesterday afternoon I was going around in circles in trying to create a MultiCategory schedule to include the doors. There is no:

  • To Room: Name
  • To Room: Area
  • Room_Area_weighted
  • glazed_Area-weighted

or

  • ratio_test

fields available to select in any of the drop-down options (Multiple Categories, Room, Space, Project Information). This, I'm sure, is very simple but I just cannot figure out what I'm missing.

 

Thank you again.

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