Specifying Data in a 1-D Lookup Table Manually

You specify the data in a 1-D Lookup Table element A type of input element that allows you to define your input in terms of a lookup table (i.e., a response surface). manually by pressing the Edit Data... button.

The following dialog will be displayed:

By default, the table is created with a single row of zeros.

You add rows to the table using the Add Row(s) button. If you hold down the Ctrl key when you press this button, you will be prompted for the number of rows to add (otherwise, a single row will be added). To delete one or more rows, select them and press the Remove Row(s) button.

The first column of the table is where you enter the values for the independent (row) variable; the second column is where you enter the values for the dependent variable (the result).

The fields in the table only accept numbers (they do not accept links). You should not append units to the numbers. The assumed units for the values that you enter are the units specified for the two variables on the main Lookup Table dialog. These units are displayed in the column headers.

You can paste data from a spreadsheet, Word document or comma delimited text file into a 1-D table. To paste data from the Windows clipboard into a table, simply click once in the cell representing the upper left-hand corner of the region of the table into which you wish to paste the data, and press Ctrl+V.

When you paste data into a table, GoldSim will overwrite any data existing in the target region, and if necessary, will automatically expand the size of the table (i.e., add rows) to accommodate all of the data being pasted.

In addition to entering the data by hand, or pasting from another application, you can also import data directly from a specially formatted text file, a spreadsheet or a database. This is discussed further in the topic listed below.

The values of the Independent Variable must increase monotonically as you move downward in the table. When you press OK to close the dialog, GoldSim automatically sorts the rows into the correct order, and also deletes all empty rows.

Note: If, after defining a 1-D Table, you change the units for one of the variables without changing the dimensions An output attribute for an element that defines the dimensionality (in terms of Length, Time and other fundamental dimensions) of the output. (e.g., from feet to meters), GoldSim will automatically convert the existing data in the table to the new units. For example, if one of the entries for a dependent variable was 1 ft, and you changed the units for the dependent variable to meters, GoldSim would automatically convert the entry to 0.3048 meters. If the units are changed in such a way that the dimensions for the variable are different, the numbers will not be changed.

Note: If you are defining a 1-D Table, and the Row Variable represents the simulation time (i.e., Time or Etime), instead of using a Lookup Table element, you should use a Time Series element A type of input element that provide a very flexible and powerful way to input external time histories of data.. This element is essentially a one-dimensional lookup table that is specifically designed to represent Time Series data (i.e., 1-D lookup tables in which the independent variable is time).

Note: When a Lookup Table is linked to a spreadsheet or database, you cannot edit the data once it has been imported; you can only view it. If you wish to edit the data, you must first remove the link to the spreadsheet or database (by changing Data Source A source of data external to your GoldSim model that can be automatically imported into GoldSim elements. External data sources are either spreadsheets, text files, databases or DLLs. to “None”).