Window schedule/adding parameter

[Don Berinati]

1- I've looked all over for a way to add "Net Glazed Area" to the window schedule, including the formula =(Window.NetGlazedArea), which returns a huge strange number. Whassup? Wrong formula, obviously, but what's the right one and where in Help, etc are the formulas/formats listed?

2- Along those lines, in one thread I found mention of reordering the window parameters in the OIP by moving them in the # column up or down. But in my VW, there appears to be no # column (I'm looking in the Settings/Data list). There is the first column (which is a numbered list but has no symbol # at heading) but nothing is movable. Wrong place?

Thanks much...

Edited June 24, 2007 by Don Berinati

[Robert Anderson]

By "huge", do you mean the area could be in square inches? If inches or feet-inches are your units, you might try dividing by 144 and see if that number looks right....

[Don Berinati]

Turns out if I divide by 12, it's correct, or at least is the same realm as in the OIP. Thanks for the thought...

So where is all this parameter info? By that I mean, how to write parameters that will return the correct result without alot of trial and error?

Thanks again

[Robert Anderson]

Don, 12 is a strange one. Are your documents units metric or imperial, and if the latter, feet, inches, or feet&inches?

[Don Berinati]

Imperial, Feet and inches. Window sizes are displayed in the schedule as 2'6" W x 5'0" H, say.

[Robert Anderson]

Don, this sounds like a bug. Would you submit this to bugsubmit@nemetschek.net along with a file illustrating the problem? Thanks in advance.

[wezelboy]

You can probably get around this by manually changing the formula in the schedule either by dividing NetGlazedArea by 12 (or 144 or whatever), or by getting the glazing height and width from other fields and doing the multiplication yourself.

[Mightyquinn]

I have noticed the same problem as Don, and I've noticed that no matter units listed for the dimension area, and no matter how the formula is divided or multiplied, the result of =('Window'.'NetGlazedArea') is always 12 x too large....

Robert, any idea? I just submitted this as a bug

Brad O'Donnell

VW 2008

Edited November 16, 2007 by Mightyquinn

[P Retondo]

Sounds like VW is reading one dimension in feet and the other in inches.

[Petri]

In metric system, the area is 90.90725 times too large...

[doughd]

So where are the formulas/formats listed at?

[doughd]

Does anybody know where the formulas are listed at?

[Guest]

Worksheet formulae (functions and criteria) can all be found by searching "formula" in the online help.

[Don Berinati]

I see the functions and criteria, but where are the actual formula 'names' of the parameters, ie 'Glazing Description', say? Or do I just use the VW name without spaces or add single quotes, etc?

Thanks!

[Robert Anderson]

To add a parameter name to a column in a database row in a worksheet, you use the following general formula:

='ObjectName'.'ParameterName'

So for example, the glazing description of a window is:

='Window'.'Glazing'

The trick here is to figure out the parameter name, of course, as it's possible to have more verbose "alternate names" show up on the Object Info palette. You can either peruse the parameter listing in the VectorScript Plug-in Editor or there is also a script over in the VectorScript section of the TS Board that will print out all records (including parameters) attached to an object.

HTH, Robert

[Don Berinati]

OK, the VS Plug-In Editor has what I need. Thanks again!

[angwns]

How about ('Door'.'NetGlazedArea') ?

I tried adding this into my door schedule, but it's not working. I've also tried a couple variations of Glazed Area. Is there a secret to the wording in the formula?

Thanks,

Angie