Follow

# Linking Items In a Cut List Table Using Excel Commands For Arithmetic Operations

John_Tran

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

METHOD 1: LINKED VALUES AND ARITHMETIC SYMBOLS

This method allows for 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.

To access the cut list properties, see the instructions in the image below, within the feature manager tree.

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 image below.

METHOD 2: EVALUATING TABLE CELLS USING EXCEL SYNTAX

Within your part, add your cut list properties to each cut list item (right click in feature manager tree > properties). Add a property to your cut list table within your drawing by adding a blank column in your cut list table in the drawing

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

The final table values for both Method 1 and Method 2 are show in the image below:

If you have any questions regarding the information above, please contact Hawk Ridge Systems Technical Support at 1-877-266-4469  (US), 1-866-587-6803  (CAN), or support@hawkridgesys.com.