How to Drive Expressions from a Spreadsheet

Siemens Experimenter Siemens Experimenter
Siemens Experimenter

Quick Overview

This Tips & Trick shows how to drive expressions in Simcenter 3D from an external spreadsheet.

 

Core content

Demo Video

 

When performing what-if or parametric studies, you may have to repeat simulations with different values of multiple parameters. These parameters can define various aspects of a model such as part dimensions, material properties, load magnitudes, etc. In a FEM part, parameters are defined in their respective dialogs, which makes the parameter updating process a time consuming and error-prone task.

 

Expressions functionality allows you to define all of the required parameters in one spreadsheet and to update the FEM with a single click.

 

Steps

Suppose you are going to run a simulation with multiple values for the part dimensions (Hole diameter and Rib thickness), material properties (Young’s Modulus and Poisson’s Ratio), and load application (Force magnitude and angle). First, create a spreadsheet with the name of parameters and their values as shown in Figure 1. Note that the name of the parameters and cell number in a spreadsheet are arbitrary.

 

image

Figure 1: Spreadsheet listing example parameters

 

Choose the Tools tab and under the Utilities group select Expressions.

 

image

Figure 2: Expression dialog

 

In the Expressions dialog, enter the name of the first parameter in the Name box and set the correct type and unit for that parameter.

 

To make the software read the value of the parameter from the external spreadsheet, click on the Functions icon.

 

In the Insert Function dialog from the Choose a Category list select spreadsheet. From the list of the functions, select ug_excel_read and click OK.

 

image

Figure 3: Insert function dialog

 

In the Function Arguments dialog, browse for the spreadsheet that you have created in the first step and enter the cell number corresponding to the parameter value in the Specify a Cell box and click OK. For example, for the Hole Diameter expression, the cell number is B1 (Figure 1). Click OK and repeat the process of defining expressions for all of the desired parameters.

 

image

Figure 4: Function Argument dialog

 

All user defined expressions as shown in Figure 5 can be used in the FEM. For example, to define the Young’s Modulus as an expression, in the box for Young’s Modulus instead of entering a constant value, select Expression.

 

image

Figure 5: Isotropic Material dialog

 

From the Expressions dialog then select the corresponding expression that you defined in previous steps, i.e. Young’s Modulus.

image

Figure 6: Select a predefined expression

 

After updating the values in the spreadsheet, the FEM can be updated by a simple click on Refresh values from external spreadsheet.

imageFigure 7: Expressions dialog

 

Maya Simulation: T +1.514.369.5706 | info@mayahtt.com | http://www.mayasimulation.com

Comments
Pioneer
Pioneer

Hi,

is it possible to do the same with fields?


I would like to parametrize a field (i.e. pressure = f(time)).

 

time (s) pressure (MPa) *
0 0
1 0
2 6
3 9
4 12
5 24

field_parameter_NX.PNG