Jump to content

Door and Window Schedules


Recommended Posts

For those who don't want to dig around in Jeffery's worksheet for the trick, here it is.

I cannot get this trick to work.

I've added the column with formula =COUNT and used the column reference in my formula =(Window.RoughOpenWIdth)/D4 but the summed cells are still not correct. 47'7 7/8" / 15 should return a value of 3'2 1/8", not 8'8 7/8".

Any suggestions? Does this trick only work with VW 13?

Link to comment

Boxjoint,

I just tried this and it does seem to be broken in VW12.

I have not been able to figure out exaclty what is happening, but the calcs are definitely not right.

In VW2008, I did find that it does not work correctly if the field you are summing on is the field that you are trying to do the calculation on, but that does not help in VW12.

Sorry,

Pat

Link to comment

Jeffery,

Thanks but...

Count is in column D. Width and Height are columns H & I. I am summing column E.

Still getting the wrong answers.

I tried moving Count to the column immediately preceding the width and height but it didn't help either.

Other thoughts?

Link to comment
  • 1 month later...

IFA: Check your Worksheet "Criteria"

Right-click on the Database Header...then:

picture21ql5.png

picture22ui6.png

Note this is useful because say you have a few different design scenarios

that you created by duplicating a design layer so you can have a bunch of

alternatives to look at. In this case you can set one of the criteria to be

"Layer-Is-Design Layer X." Of course there are numerous other ways that

this may be useful. This level of flexibility is also probably one of the reasons

that Schedules in VW is not as "automatic" as you might expect, but it proves

to be a great benefit to have this amount of control at your fingertips.

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