Problem

This article explains how to use Excel-based syntax to create custom items within a Weldment cut list table. This is needed because the Weldment cut list custom properties do not allow for links to a global variable or standard arithmetic or mathematics within the properties dialog box.  

Within the Weldment cut list properties dialog box and cut list tables, there are only two ways to go about using two values to conduct basic mathematical operations: arithmetic symbols present in the custom properties value and evaluating the value manually within the table itself.

Solution 1: Linked Values and Arithmetic Symbols

This method allows the user to create a mathematical expression within the cut list properties that populates within the cut list table, similar to the "Evaluated Value" of the cut list properties.

1. Expand the cut list and right-click on one of the weldments to select "Properties" to view the cut list properties

2. Within the cut list properties, the syntax from two properties can be copied and an arithmetic symbol placed between them to display the mathematical function as the "Evaluated Value," as seen in the example image below. 

Solution 2: Evaluating Table Cells with Excel Syntax

This method allows the user to create a mathematical expression within the cut list table in a Drawing:

1. Within a part, add cut list properties to each cut list item (right-click in the FeatureManager tree to select Properties). 

2. Add a property to the cut list table within the drawing by adding a blank column in the cut list table in the drawing.

3. Double-click the blank cell and add a title. The cells below will use basic Excel math. In the example below, we did ' =B2*E2 ' to get the value for cell F2.

The final table values for both Method 1 and Method 2 are shown in the image below.

For additional support, existing customers can submit a ticket or new customers can contact Hawk Ridge Systems.