A method for implementing costing in your Piping and Steel drawings that can be exported to excel is shown below.
1. Enter the CADWorx Specification Editor and select the Catalog file that governs the project you are using in CADWorx.
2. In the catalog, select "Data Tables" and choose "Add Custom Data To All Tables"
3. Here are the values I am entering to create a cost field:
4. Now for every component under "Custom Data" I have a COST field. click on one of the data tables that you want to add cost to.
5. Add the value for cost for each nominal size. Repeat this step for the data tables for each component.
6. Save the changes. Open up your project file. When you get a dialog to update the project file from the catalog, choose Yes.
7. Open up CADWorx Plant Professional. Connect to the project file you updated in step 6. Route a few components, and then use the command BOMSETUP.
8. There will be a data table called "COST_TABLE_REAL" that can now be added over to the right side as a selected column. This will incorporate a COST field every time you use a BOMEXPORT command.
9. Run a BOMEXPORT command on your components. Here my cost table is shown, and I have elected to use a cost per ft value for pipe components. The user will need to determine the true cost of pipe by multiplying the length by this value. Any fields that are empty have not been given a cost value associated with the catalog that was modified in step 5.
1. Open up C:\CADWorx 2015\Plant\Steel_I\SamplePartNumbers.dat in notepad. This file contains default part numbers that are applied to each steel shape in CADWorx. Typically most users do not utilize this SamplePartNumbers sheet, so the recommendation for this solution is to modify this file to instead have the cost per foot of each steel member in the sheet. Here I will modify this column in red to a cost/ft. value.
2. After saving these changes, I'm going to run a WSHAPE command in CADWorx. The Part Number field is now giving me the Cost/ft value that I set in step 1.
3. Now run a SBOMSETUP command, and move over the PART_NUMBER column to one of the visible fields when you run SBOMEXPORT.
4. Now when I run SBOMEXPORT, I get cost per foot under PART_NUMBER. The user will still have to multiply their length by cost/ft. in order to get the total cost.