Jump to content
Don Berinati

Window schedule/adding parameter

Recommended Posts

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 by Don Berinati

Share this post


Link to post

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....

Share this post


Link to post

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 :)

Share this post


Link to post

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

Share this post


Link to post

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

Share this post


Link to post

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.

Share this post


Link to post

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 by Mightyquinn

Share this post


Link to post
Guest

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

Share this post


Link to post

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!

Share this post


Link to post

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

Share this post


Link to post

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

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...