Jump to content

worksheet : wall component class


blimey

Recommended Posts

Hello everyone,

 

I'm trying to do a worksheet that would list all my wall component, give their name, and class.

I'm attaching the image of what it looks like. I manage well to get the component name and area. Then I'm trying to get the class of each component but I do not know what syntax to use.

I'm using this formula  = COMPCLASSBYNAME('MR42_AT2-XVD4') but it doesn't work. Also I would like not to enter manually the name of the component, but get it from the previous cell which formula is =COMPONENTNAME(1).... so I tried =COMPCLASSBYNAME('COMPONENTNAME(1)')... an =COMPCLASSBYNAME(COMPONENTNAME(1)) But it did not worked.

Does any body knows what formula I should use?

 

worksheet.PNG

Link to comment

@JMR T this works as well in VW2017. Thank you !  I actually tried that at first but it didn't work because I was not bracketting the header row but the database row... and I didn't realized

@ Taavilooke : Yes I was reading your thread, It's a very nice schedule and it made me want to put some effort in learning how to script.

For the moment I'm  trying to do some kind of house keeping worksheet of my walls  to list all the component and their classes and be able to control the wall library : check if all the walls, all the walls components have the right name, are in the right classes etc...   I was hoping that those information could be bidirectional (2 ways) as for the door schedule for exemple where it is possible to correct the dimensions and parameters directly in the worksheet. Alas the information are grayed and cannot be updated from the worksheet.

What I also would like to be able to list is all the bounding (top and bottom) of the wall and the wall omponents : so to be able to check if walls in 3D are correctly binding to the adequate story levels. Ultimately I want to see what I should actually mesure from the 3D model and try to build a worksheet. Thak you for your help.

Link to comment
  • 2 years later...

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