AnsweredAssumed Answered

Custom Excel BOM

Question asked by Mark Greenwell on Apr 30, 2015
Latest reply on May 1, 2015 by John Stoltzfus

HI,

 

I am for the 1st time trying to set up an Excel based BOM as opposed to the standard SolidWorks BOM.

 

I have fount the Excel BOM templates and thought I could just edit one to suit.

 

While some properties now appear on the BOM some are taking the wrong information.

 

Attached are some screen shots.

 

I have an assembly with multiple part all with custom properties.

 

I want the BOM to take the information from these custom properties,

I cannot figure out how to link the Evaluated Value to the BOM, these would be in this screen shot, Length (500) and Section Size. (Plt 30*165)

 

properties.PNG

 

This is what appears on the BOM, which are Value / text expression for length and nothing for the Section Size.

 

I guess it could be how I have set the Excel file up but not sure what I have done wrong.

 

BOM.PNG

 

Also attached is the edited excel file.

 

Could some one please explain what I need to do.

 

Thanks

 

Mark (SolidWorks 2015 sp2.1)

Attachments

Outcomes