Jump to content
  • 0

Creating a worksheet for a Bill of Materials

Bas Vellekoop


Hi guys,


I`m doing allot of designs which need a BOM when they go in production.

My setup of for that now is: all objects are symbols with an attached record. In this way I can count the amounts and get information about the materials and give them a brief description

If I use a plugin object like a set screw from the fasteners palette I put them in a symbol and attach my own record to it with the chosen length and diameter manually.

This is prone to error and double work because al this information is automatically attached to the plugin object by VW.


My questions i hope you guys can help with:


Is there anyway I can create a worksheets in which there  is column that uses my manually created records and the plugin record without the need of a column for each individual setting in the plugin object?


Is it normal that you can not 'read' the hidden records from a plugin object inside a symbol like the length?





Attached a simple file to illustrate what I`m looking for.










test for bom.vwx

Edited by Bas Vellekoop
Link to comment

6 answers to this question

Recommended Posts

  • 0

Take a look at my edited worksheet. It will answer a number of your questions.


1.  Your criteria was Symbols. That means that you will only be able to get data on the symbols, not on the contained objects of the symbols. I changed the criteria to be Parametric objects and with the InSymbol box checked. That gets you a subrow for each PIO. You could also tell it to be Parametric Objects OR Extrusions. Or you could just attach your Material Record to the PIOs and then use that as the criteria.


2. You will need to attach your Material record to the PIO or Extrusion, not to the symbol. The subrow can look at either the contained objects OR the containing symbol, but not both. It would be nice to have a function that would allow you to access the Parent, but it does not exist yet.


3. Once you have the Material record attached to the correct objects, the rest should be easy.


4. Take a look at the =Concat function in column E to see how to combine multiple data into a cell.  You can replace where it says B3 with the formula in B3, C3, D3, etc. to get a single cell with what you need.   Or you can just leave the multiple columns and set the width to zero so they don't display.

test for bom - PIO Criteria.vwx

Link to comment
  • 0

Great help Pat! 

The only thing i now have to look out for is that everything has the record attached, otherwise I`m missing parts in the BOM.


I`m not finding 'concat' in the edit report dialog box in the section of columns and then searching in the functions? Is this correct?

Edited by Bas Vellekoop
Link to comment
  • 0

Concat might not be in the pull down menu, but you can definitely type it in and it works.


Yes, keeping a BOM correct is always a challenge. Be it that you accidentally duplicated a screw or did not put something in the correct class/layer/record so that the database finds them. Automation is a bitch as it does exactly what you tell it to do, not what you really want it to do.

  • Like 1
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.

Answer this question...

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