Updating Template Material Cost Data

You can export material property data from the machining template 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.

1. To open a Costing machining template, do one of the following:
   • From the Windows Start menu, go to SOLIDWORKS Tools version > Costing Template Editor version.
   • With a part open:
     1. Click Costing (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, enter a name and click Save.
   The file opens in Microsoft Excel, where you can modify the cost data.

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