Jump to content
Sign in to follow this  
Pierluigi Feltri

Wall worksheet data

Recommended Posts

Anybody knows if:

Is it possibile to list, in a worksheet, the thickness of each components forming a wall?

Is it possible to list in one single cell the name of each components forming a wall? (using for instance a command like "=ComponentName(1..6) for a wall made of 6 layers).

Thank you very much.

Pierluigi Feltri

Share this post


Link to post

It is possible. You can format it either as a database or a bunch of spreadsheet cells.

It's not perfect. Maybe someone could check out worksheet 3 under the column "Why doesn't this work?" and answer the implied question.

I'll attach an example using a bunch of spreadsheet cell calls. To use it, enter the name of a wall type into the cell A2 and the worksheet will take care of the rest.

There must be a way to if/then/else the division by zero error notices, but I couldn't make it work in a couple minutes. Maybe someone will have an answer for that as well.

hth

mk

Share this post


Link to post

I think on a thread a few years ago we figured out that adding a very small number to the denominator will work as a hack to get rid of the division by zero error notice. Just tried adding .0001 to the area and it seems to work.

Doesn't fix the other problems, however…

mk

Share this post


Link to post

I just took a look and I have a guess as to what is going on.

My guess is that the ComponentArea function is returning a string not a number. Once it is written into a cell (stored as a string) and then read back out, the divisor code is smart enough to convert it to a number. When it is used in a formula directly, then it is still a string and is numerically a zero.

Any bets?

Share this post


Link to post

Hi Pat!

Interesting. I just tried slapping a VALUE() call in front of everything. No difference.

Then I tried switching the document units to more easy to understand mm and meters. I switched the cell formatting to decimal, 3 places.

I see your thinking, that it might be taking a string to have a value of 0. But I'm getting different non zero results between dividing two cell values and dividing the calls that went into those cells.

Is it possible that when a volume is called to a cell it does the math for cubing and when an area is called to a cell is does the math to take squaring into account.

But when a those same calls are used together in the same cell it can't do the math on each call separately?

I'm not expressing the issue correctly yet.

Maybe sleep and caffeine will help in the morning…

mk

Share this post


Link to post

I thank you everybody for the examples and the suggestions: I'm going to try your way. It doesn't fit exactly with my expectation but it could work. The best would be to have the possibility to retrieve and use, in the worksheet, the data input of the component and its layers used in the setting window of the wall.

Thank you again.

Pierluigi Feltri

Share this post


Link to post

I agree!

The data you want is in the drawing! It shouldn't require mathematical detective work to get at it.

Perhaps there is a hidden record format for wall types. If not there should be. And then it should be less hidden.

Jim, here's another wish list item: All data should have a way to present itself to worksheets.

mk

Share this post


Link to post

Here's my current suspicion:

When calling the area or volume to a cell it's doing the calculation in one unit of measure. For argument, say it calculates area and volume in square and cubic feet. When those values are placed into a cell they are placed in document units.

But when the calculation happens within the cell doing the calling of both functions, the switching to document units happens after the division. So the volume is off by a factor of 1728 and the area is off by a factor of 144.

Except I tried those values and they don't work. But it gets closer.

Any other ideas?

mk

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.

Sign in to follow this  

 

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