This shows up the list of Name Properties in the Excel file. (In Excel 2007, its called “Name Manager” and its on the Formulas button. Its also possible to see all Name Properties in an Excel file: Insert -> Name -> Define (Excel 2000/2003) Customers on subscription can view the SolidWorks Knowledge Base at Column (otherwise your Excel BOM will act strange, adding several duplicate rows into the BOM.) (I spent quite a while caught on this.) FYI this fact is noted in the SolidWorks Knowledge Base. Remove/Add Columns to suit making sure to type in the SolidWorks File Property name into the “Name Property” box (see image below).Open bomtemp-all.xls Look at the various Headings in Row 1.Find out where BOM templates are stored: Open SolidWorks -> Tools -> Options -> File Locations -> BOM Templates.This post shows how a custom Excel based Bill of Materials for a SolidWorks Assembly drawing can be created.
#Export equations in solidworks 2005 manual
Note: in recent versions of SolidWorks (2008,2009 etc.) it is possible to do totals and equations in standard BOMs, however they require some post manual tweaking. if you want a complete project costing (taking into account price per meter length of piping or weldments). While using an Excel based BOM (as opposed to a standard BOM) is not as flexible as a standard Bill of Materials, there are various customisations which can be done.