Jump to content

Window Schedule custom Windows


Andrew Mac

Recommended Posts

  • 3 months later...

Hi Mac - 

 

You can add a column in the schedule worksheet where you would like the window operation to be reported - probably next to the regular column "Sash Operation".  Turn on Database Headers under View - in the database header of your new column, add the formula

 

=IF((Window.SashOperation='Custom'), 'DH', Window.SashOperation)

 

This will report all custom sash as "DH", so this is only practical if you have only the one Custom sash type.  Because Window.SashOperation reports the text string as, for example, "Double Hung", you'll want to add additional logical tests in the string on the pattern of 

 

=IF((Window.SashOperation='Custom'), 'DH', IF((Window.SashOperation='Double Hung'), 'DH', IF((Window.SashOperation='Casement'), 'CMT', Window.SashOperation))) ... etc.

 

This is also a useful way of converting any of VW's standard text reporting to the office convention.

VW Add Logical Test Column to Window Schedule.vwx

Edited by Chad Hamilton HAarchs
Added file example
  • Like 1
Link to comment

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.

×
×
  • Create New...