Jump to content

Trouble with Window Schedule Consolidation


Sky

Recommended Posts

So just when I thought I had all the schedule stuff figured out...

I am consolidating all the similar windows together by using the SUM function in the Marks database headers. I use the =COUNT formula to display quantity. And I divide by that quantity (/A4, the cell which the +COUNT formula appears) in the formula for overall height, overall width, and elevation.

The quantities show up correctly. The dimensions are right if the quantity is 1, but half what they should be when the quantity is 2, and a quarter of what they should be when the quantity is 4.

I did this in the door schedule and didn't have a problem. What am I overlooking here?

Link to comment

Just in case anyone looks at this topic, Pat replicated the same problem and found a temporary solution until this bug is fixed... at least we think it is a bug.

To consolidate the windows in the window schedule, you should divide by the cell with the =COUNT formula in it (i.e. /D4), then multiply by that cell (i.e. *D4) so the formula will look something like this:

=(Window.OverallWidth)/D4*D4

Weird, but it works for now.

Link to comment
  • Vectorworks, Inc Employee

Try to move the Quantity column to the end of the worksheet.

The location of this column matters in a summarize database. It is recommended to place that column right to the column where you reference it for best results.

Of course this is a bug.

Hugues

NNA

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