Defining tabular data

When you create a table field using the Table Field dialog box, you use the options on the Definition page to define the tabular data points. These options include the following:

• Manually date entry.

• Importing tabular data from a text file.

• Creating tabular data in a spreadsheet.

• Extracting the coordinate values for spatial independent domains from the graphics window.

Manual data entry

To manually enter tabular data, click a cell in the data points table and type the data.

You can use the Tab and Enter keys to move between cells in the table or to create a new row.

• The Tab key moves your cursor to the next cell in the current row. If you press Tab when your cursor is in the last cell of a row, the software creates a new row.

• The Enter key moves your cursor to the next cell in the current column. If you press Enter when your cursor is in the last cell of a column, the software creates a new row.

You can also type expressions in the cells. To do so, each expression must satisfy the following requirements:

• The expression must evaluate directly to a numerical value.For example, the expression can contain numerical values, mathematical functions, mathematical operators, and so on, but it cannot contain indeterminate inputs such as variables.Note: Variables are fundamental spatial and non-spatial quantities that vary in the model and are understood by the expression system. The software predefines variables. You cannot create a variable. Examples of variables are Cartesian coordinates and temperature.

• The dimensionality of the expression must be either dimensionless or match the dimensionality of the independent or dependent domain variable that it is being used to define.If the expression is dimensionless, the software treats it as if it has the dimensionality and units specified in the column heading of the data table.If the expression has dimensions that match the dimensionality of the independent or dependent domain variable that it is being used to define, but the units do not match those in the column heading of the data table, the software automatically converts the numerical value of the expression to the units in the column heading of the data table.For information on expressions, see Expressions.You can enable the use of expressions in table fields by doing the following:Choose File→Utilities→Early Access Feature.In the Early Access Features dialog box, for the Allow table cells to reference expressions early access feature, right-click in the State column and choose On.

Import from a text file

To obtain the tabular data from a text file, click Import from Text File .

You can use commas, spaces, or tabs to separate values in the text file.

For the data to import correctly, the text file should contain data that corresponds to the columns defined in the table field. For example, if the table field contains two columns of data, the text file should contain two columns of data.

Tip:

You can use a .csv file to import analysis results or node IDs into a table field. For more information on how to do so, see Breakout modeling workflow and Creating loads using node ID tables.

Certain tabular data can be ordered in the text file such that the software can detect a pattern in the data. For example, if the tabular data has a single independent variable and the data is listed in ascending or descending order, the software detects that the data is ordered.

When the software detects a pattern in the data, it presents you with special options for importing and using the tabular data. For example, when the software detects that single independent variable data is ordered, it presents you with the option to make the data parametric when it is imported.

For more information on these options, see Importing ordered or structured tabular data from a text file.

Edit table in spreadsheet

To create or edit a table field in an external spreadsheet application, click Edit table in spreadsheet .

After you finish making changes to the data in the spreadsheet, you must update the table field and then close the spreadsheet.

Graphical selection

The following options are available for you to extract the coordinate values for tabular data points from the graphics window:

• If you are creating a single tabular data point, click a cell in the independent domain column and select the Select Point command. In the graphics window, select the location for the software to extract the coordinate values for the tabular data point.

• If you are creating multiple tabular data points that all have the same dependent domain value, use the Add Multiple Data Point Locations With Constant Value command.In the Points in Table dialog box, select the Select Constant Objects command. In the graphics window, select the locations for the software to extract the coordinate values for the tabular data points. In the Value box, specify the value of the dependent domain.

When you use either graphical selection method, you can optionally associate the spatial coordinates of the tabular data points with model geometry.

For example, suppose you use graphical selection to create a tabular data point that lies at the mid-point of a polygon edge. If the Associative check box is selected when you create the tabular data point, the software associates the tabular data point with the model geometry. Thus, if the length, orientation, or other aspect of the polygon edge changes, the software automatically updates the coordinate values for the tabular data point to reflect the new coordinates of the mid-point.

Discontinuities and skips in table field data

You can include jump discontinuities and skips in the tabular data that you enter in the Table Field dialog box.

You cannot define more than two data points at each discontinuity, and you cannot define discontinuities at the starting or ending points of the data range.

To include a skip, type “- -” (two dashes with no space in between) in place of a numerical value. To replace existing numerical values in the data points table with a skip, overwrite them with “- -” (two dashes with no space in between) in their cells. You cannot enter skips at the starting and ending points of the data range or at discontinuities.

Controlling the display of tabular data

If a table contains more than 5,000 rows, you can control the number of rows of tabular data to display per page on the Definition page of the Table Field dialog box.

Page controls let you quickly navigate from page to page, or go to the beginning or end of the table. If you use this feature when you import large amounts of tabular data, you can eliminate the long load times that might occur when all of the tabular data loads at once.

To use this feature, in the Page Control group, in the Number of rows per page box, type the number of rows of tabular data to display per page. Then use the controls to navigate from page to page, or go to the beginning or end of the table.

How do I

Create a table field

Create a table field from results

Create a table field from a formula field

Create a table field from an AFU file

Define a boundary condition using a table field

Define a material property using a table field

Define a table field with complex dependent variables

Learn more

Table fields

Creating table fields from results

Defining pressure and power data in dB

Duplicate data

Removing sliver triangles

Importing ordered or structured tabular data from a text file

Controlling the display of error messages

Mesh size fields

Look up more details

Table field interpolation and extrapolation options

Special editing options for table fields

Lookup options for fields created from results

Quick links

Command reference

Pre/Post video examples

Bulk Entry Descriptions

Simcenter 3D tutorials

Browse Simcenter 3D help by product area

Defining tabular data, 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 } });