Specifying Data in a 1-D Lookup Table Manually

You specify the data in a 1-D Lookup Table element manually by pressing the Edit Data… button.

In this table, the Result Units are kg and the Row Units are m. Note also that the independent variable has been assigned a Name of “Length”.

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 (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. 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 to “None”).