Jump to content

Wall component data in worksheets

Recommended Posts

When I have my wall styles built from several components and many of them (say, masonry or insulation) used in more than 1 wall style, is there a way of getting total volume of specific component?

The workaround I'm doing is to create cell with formula like =VOLUME((L='basement') & (WST='stone 600'))/1000000000/690*600 where "/690*600" is coefficient of specific component (600 mm) within whole wall (690 mm). Later I sum necessary cells to have total volume. This is half-automatic and therefore leaves room for error.

Link to comment

This is going to be a hard thing to do. Since the components don't have names that are accessible from the worksheet.

It is probably possible to create a vectorscript that will add a custom record to every wall and include information about the thickness of the components you are interested in. That custom record could then be used in a worksheet to do the calculations you want. But if you every changed the style of a wall or redefined the wall style or added another wall, you would have to remember to run the script again to make sure the data is up to speed.

Link to comment

My suggestion would be to create a second worksheet where you store the wall component details like their individual thickness.

The formulas in the first worksheet can use data from the second, and all changes can be typed into the second, taking only a Recalculate of the first.

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.

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