Updating Template Material Cost Data

You can export machining template material property data to an .xlsx file and modify the cost data in the spreadsheet. You can upload the material cost data from the .xlsx file to the Costing machining template.

To update material cost data in a Costing machining template:

  1. To open a Costing machining template, do one of the following:
    • From the Windows Start menu, click All Programs > SOLIDWORKS version > SOLIDWORKS Tools > Costing Template Editor version .
    • With a part open:
      1. Click Costing tool_costing_tools.gif (Tools toolbar or the Evaluate tab on the CommandManager) or Tools > SOLIDWORKS Applications > Costing.
      2. In the Costing Task Pane, select a template, and click Launch Template Editor.
  2. If your machining template is not open, in the Costing Template Editor application, click Open , select the machining template and click Open.
  3. Under Material, select the method and click Export.
  4. To save the material properties data as an .xlsx file, type a name and click Save.
    The file opens in Microsoft Excel, where you can modify the cost data.
    You must not add rows or columns to the spreadsheet.
  5. To import the updated material cost data:
    1. In the machining template, under Material, select the method and click Export.
    2. Select the edited .xlsx file and click Open.
    Updated costs are highlighted in the template Cost column.
  6. Save the template and close the application.