Window schedule

[Kbosch.184344]

Formulas in Revit are not nearly as usefull as the ones in Excell. When I want to use <= it seems not to be possible, but instead you have to use NOT(a>b).. All very nice but when you have a harder embedded formula then it gets very complex.

At the moment I'm creating a window schedule for the "glased area".. The schedule containts Glaswidth and GlasHeight wich I assigned to the all window families. For complexer windows I use the parameter "comlex windows" wich is no more then an Area based parameter (not shared) I can manually fill in the complex windows. So my calculated parameter becommes like this:

(Glaswidth*Glasheight) + Complex windows.
Sadly when I fill in complex windows and the values for Glaswidth and Glasheight are empty, the end value of my calculated valuea

remains empty aswell..WHY?? :mad: I guess the formula can't handle zero input in the first part of the formula, so any1 an idea of how to fix it

Already tried some things like:
If(Or(Glasheight1*Glaswidth1 +Glasheight2*Glaswidth2 > 0, Glasheight1*Glaswidth1 +Glasheight2*Glaswidth2 < 0) , Glasheight1*Glaswidth1 +Glasheight2*Glaswidth2, Complex windows)

Working formula, but doesn't do what I want it to do.

[aggockel50321]

One possible fix:

Do the area calculation within the window family.

Add an area parameter (shared parameter) in your window family(s) and set it equal to your gazed width*glazed height.

Then add the parameter to your schedule, and do a calculated value of the sum of the two (glazed area + complex glazed area).

[aaronrumple]

One possible fix:

Do the area calculation within the window family.



This is the most direct and simplest to manage over time. It will accomodate different window shapes (arched, triangular, etc.) down the road, which your fix schedule formula can't.

[Kbosch.184344]

One possible fix:

Do the area calculation within the window family.

Add an area parameter (shared parameter) in your window family(s) and set it equal to your gazed width*glazed height.

Then add the parameter to your schedule, and do a calculated value of the sum of the two (glazed area + complex glazed area).Thanks I'll try this aprouch and have a feeling it might work.

Edit; Yes it worked


This is the most direct and simplest to manage over time. It will accomodate different window shapes (arched, triangular, etc.) down the road, which your fix schedule formula can't.
Well you still have to link shared parameter to the dimensions in the your families, so I'm not sure how you would be able to accomodate windowshapes like triangular. That's why I have a column of complex windows... If the window gets to complex for simple parameters, I measure the window glazing by hand and fill it in manually.

[aaronrumple]

Well you still have to link shared parameter to the dimensions in the your families, so I'm not sure how you would be able to accomodate windowshapes like triangular. That's why I have a column of complex windows... If the window gets to complex for simple parameters, I measure the window glazing by hand and fill it in manually.

You have a shared parameter "Glass Area" (It's ok to use spaces in shared and title case in parameters. This saves time when you place it in the schedule. You then don't have to rename the column heading) The formula use by this parameter for each window family will be different. For a simple rectangle: Glass Area = Glass Width * Glass Height. For a arched window Glass Area = (3.14 * Window Radius * Window Radius) / 2 ...and so forth for other window types. Note that Glass Width and Glass Height don't need to be shared parameters unless you want those in a schedule. They can just serve to do the calculations.

[Kbosch.184344]

You have a shared parameter "Glass Area" (It's ok to use spaces in shared and title case in parameters. This saves time when you place it in the schedule. You then don't have to rename the column heading) The formula use by this parameter for each window family will be different. For a simple rectangle: Glass Area = Glass Width * Glass Height. For a arched window Glass Area = (3.14 * Window Radius * Window Radius) / 2 ...and so forth for other window types. Note that Glass Width and Glass Height don't need to be shared parameters unless you want those in a schedule. They can just serve to do the calculations. Ah ok...and the reason why I had the Height and Width as shared parameters is that I had to connect a calculated value to it in the schedule. Now when I have the Height and Width in all of my families this isn't nessesairy anymore. So I'll use normal parameters for those values in the future as it saves time. Shared parameters are relative time consuming.