Update design variable settings in an Excel spreadsheet

This example shows how to modify the upper bound of the C_MOD design variable from 2 to 2.2 in an Excel spreadsheet.

2. In the Simulation Navigator , right-click the Design Variables [#] node and choose Export to Excel Spreadsheet.

3. Right-click the Design Variables [#] node again and choose Update Design Variables from Spreadsheet.

In the Excel spreadsheet, do the following:

1. Enter 2.2 in the Upper Bound cell of the C_MOD design variable row.

2. Select the C_MOD design variable row.

3. Choose Start → Exit Excel.

In the Simulation Navigator, the upper bound value of the C_MOD design variable is updated in the Correlation Details View subpanel.

ID	Name	Label	Value	Lower Bound	Upper Bound	Weight	Physical Property	Type	Field
22.	C_MOD	C_MOD	1.000	0.500	2.200	1.000	MAT1 2	MAT1	E
23.	MNT_KX	MNT_KX	1.000	0.500	2.000	1.000	PELAS 30001	PELAS	K1
24.	MNT_KY	MNT_KY	1.000	0.500	2.000	1.000	PELAS 30002	PELAS	K1

How do I

Modify a design variable

Remove a design variable from the optimization

Reset the design variables

View sensitivity matrix

Create design variables for the model update solution process

Create multiple physical design variables

Learn more

Design variables in the model update and model update set solution processes

Create Multiple Design Variables

Look up more details

Supported design variables for model update solution process

Quick links

Command reference

Pre/Post video examples

Bulk Entry Descriptions

Simcenter 3D tutorials

Browse Simcenter 3D help by product area

Update design variable settings in an Excel spreadsheet, Simcenter 3D 2021.1 Series

© 2020 Siemens

window.mainLanguage="en_US"

window.delivId=""

window.projectId=""

MathJax.Hub.Config({ TeX: { extensions: ["autoload-all.js"] }, tex2jax: { displayMath: [ ] }, "SVG": { scale: 125 } });