SimplexNumerica’s ArrayEditor is not a Spreadsheet; instead, it is organized in fix x/y/z columns (Measurement Rows) and a number of SampleData rows. Furthermore, it is not intended to be a competitor to Excel or other Spreadsheet programs. Certainly, you should use your Spreadsheet program for copy and paste the data in the ArrayEditor.

The ArrayEditor has its own Pulldown-menu.  You can call the ArrayEditor over the Toolbar or with the key <F2> or from the Pulldown-menu <Edit> menu point <ArrayEditor>.

Only real (double) or Date & Time values can be put into the ArrayEditor cells. Each cell has only one value.

The data can be directly entered in the ArrayEditor or imported from a file.

A particular inverse rectangle highlights the columns which are current used for the graph. The red selection rectangle is only used for bar charts without a real x-Axis (so called Business Diagrams).

The above picture shows the ArrayEditor in the EvaluationMode with the columns of the x, y and z-Arrays. We can see above six columns but only two - so called – Memory Records (S0 and S1). Each graph is actually stored in a memory record. In the TestMode there are maximal three columns possible (x/y or x/y/z, respectively); in the EvaluationMode the number of columns depends on the number of records. The Z-axis can be switched on and off with the key <Ctrl + W>.

To put formulas directly into the cells and make calculations, use the equal character (=).

e.g.:   =sin(3.5) <ENTER> = -0.3508

          =2*3 <ENTER> = 6

The result will be put directly into the cell.

If the ArrayEditor stays on top, then a Pulldown-menu with the following entries should be available:

• Pulldown-menu File
  
• Pulldown-menu Edit
  
• Pulldown-menu Table
  
• Pulldown-menu Window
  
• Record Memory
  

New Table

New Table replaced the actual table with one memory record. Before the program removes the existing content it will ask you to delete the table.

If you affirm, then SimplexNumerica represents the last two lines of the x/y column as default values. For representation in a coordinate system at least two lines and two (x/y) columns must be present.

If the 3D-Window is on top, then three columns per series of measurements can be present. If the error bars in the 2D are switched on, likewise three columns are present. The third column (the z-column is mentioned) can be switched on and off.

How do you edit now the individual cells?

Click with the left mouse in a cell. A small typical MS Windows Edit Field appears in it. Right now, other menu effects are available. Not all Pulldown-menus will work, yet. Thus the following keys are available:

The direction of motion of the editing cell is depending from the previous cursor and Tab direction. If you move e.g. the cell with the cursor key upwards and afterwards press return key, then the direction remains upwards.

As soon as you lock a cell with #, the number of lines in this column up to this row will be shortened. You can put also in any cell #. Especially in the EvaluationMode you can use this particularly easily. Please pay attention if you indicate # in the cell. It will lock the cell with Return only if the direction does not go upward, because otherwise the last cell is marked and thereafter with Return again a new cell is immediately inserted. 

Save SampleData

Data can be stored either in special binary or preferred CSV text formats (Comma Separated Value).

If no columns are selected in the ArrayEditor, then the entire table will be stored. However, if you select any columns, then only these columns will be saved.

Load SampleData

Data can be recalled either in special binary or preferred CSV text formats (Comma Separated Value).

If you load an external file from another application and SimplexNumerica can’t recognize the content so it will automatically call the import dialog (see next capital).

Load SampleData in the TestMode

In the TestMode each data load will replace the previous columns and view against the new once. So you can simple test your data without additional afford.

Load SampleData in the EvaluationMode

In the EvaluationMode each data load will call the Memory Record Dialogbox:

Here you can store your data in SimplexNumerica’s Memory Record. Please press the button <Store> for that (for more info search for Memory Record in this doc).

You will see now two marker types in the diagram and also more than two columns in the table. Also you can identify the # sign. It marks the end of column 3 and 4. They are not so long as column 1 and 2. The calculator in the 2D view marks the current graph (See more in next capitals).

Import and Export `*.CSV '

SimplexNumerica can load and save files in the `*.CSV' format. CSV is a pure ASCII format and stands for Comma Separated Values (like tab ; ,). 

The structure of CSV files follows a simple pattern:

• The file is line by line developed as ASCII stringer.
• The individual values are separated thereby by commas.
• Texts are framed additionally into quotation marks (").

Further still three headlines are available, those of the field names (in SimplexNumerica of the record field names) and the data type definition (in SimplexNumerica is it the 2, stands for numeric value).

If the table was stored by SimplexNumerica as a complete table, then it is just reproduced. However if columns were selected before storing, then the stored columns become stringed together.

If you load an external file and SimplexNumerica can recognize the content so it will automatically call the following import dialog.

If the dialogbox didn’t looks like so and you are sure that you have exported the table with SimplexNumerica so you can setup the dialogbox manually.

If you load an external file from another application and SimplexNumerica can not recognize the content so it will automatically call the same import dialog but without the standard header selected.

CSV Dialogbox Explanations

Compatible Format

• Standard-Header available.
  Set this option if a Standard CSV Header is available.
• Use [Old] Simplex Format
  Set this option if the file is saves from SimplexNumerica

Rows

• Jump over first row.
  The first row in the file will be ignored.
• Jump over second row.
  Also the second row in the file will be ignored.
• Jump over first n rows.
  The first n rows will be ignored.
• Skip over each m row.
  Each m row will used for the table.
• If skipping, then use averaging.
  If <Skip over each m row> is activated, then it will average the skipped values and put these in the table.
• Take MemoryName from first row.
  Each Memory Record is identified by a name, so it will use the name from a file.

Columns

• Jump over x-Columns in table.
  It is used only for y data columns.
• Put first column in Legend.
  The Legend is the left grey column.
• Set next column for x-Axis.
  The next loading column will be put in the x-Column.
• Insert data beyond last column.
  This decides between replacing or appending the data in the table.

General

• Use Standard MemoryName
  A default name is Memory plus record number (e.g. Memory 0, 1, … , n-1, n)
• Look for Date and Time
  It looks for Date <space> Time, e.g. 29.11.2006 20:02

Columns-Separation

• Semicolon [ ; ]
• Comma [ , ]
• Dot [ . ]
• TAB [ chr$(9) ]
• Space

Decimal- Separation (e.g. 3.14)

• Comma [ , ]
• Dot [ . ]

Don't show this dialog the next time.
(Activate it again from the ArrayEditor Pulldown-menu <Window>)

This will show you only once the above dialogbox. If you read again a file, then the data will put directly in the table with the same settings.

Import and Export `*.DIF '

SimplexNumerica can load and save files in the `*.DIF' format. DIF is also a pure ASCII format and stands for Simplex Interchange Format. The `*.DIF' format became quasi an industry standard. It serves to exchange data between different programs. Program-specific information such as cell formats or formulas are not contained in the DIF.

Print Selection

The selected columns are directly sent to the printer.

Cut

Columns or lines can be removed from the table, by selecting them with the mouse. These data are put into a temporary file. 

Copy

Columns or lines can be copied from the table, by selecting them with the mouse. These data are put into a temporary file. 

Paste

Columns or lines can be inserted from the temporary file into the table, by calling this menu. If no columns are selected before inserting, then SimplexNumerica asks you whether the original position (before cutting out) is to be taken again or not. However if columns are selected, then SimplexNumerica will fill up these columns and will put the remainder in the back.

If several columns are selected and before only one column had been cut out, then all selected columns are filled with it.

Insert Clipboard

Sometimes it is necessary to copy and paste data from a Spreadsheet program like Excel to the ArrayEditor. This can be done with the menu <Insert Clipboard>.

Call your Spreadsheet program. Select there some columns or regions; go back to the ArrayEditor and call <Insert Clipboard>.

Remove

The data will be removed from the table.

(De-) Select All

All columns will be either selected or de- selected.

Goto selected row(s)

Is there more than one row selected then you can jump with this menu point or the key <F2> to each selected row.

Select x/y columns

All x or y-columns will be selected.

Swap CurveData <-> SampleData

Swapping between CurveData and SampleData.

Rows in Columns

Transformation from rows in columns.

Number Format

The format of the numbers can be set global for all columns.

You will find a detailed description for the Number Format in the 2D-Window chapter.

View z-Column

This switch determines whether the z-column is indicated or not. SimplexNumerica sets it automatically with the call of the 3D-Systems and on activation of the error bars.

At present the Error Array agrees with the array of the z-Column.

Don’t show Import Dialog

Please look above in the chapter <CSV Dialogbox Explanations> for description.

General explanation for selecting

Selections will be made only with the left mouse button. You can not select a region likewise a Spreadsheet program. It is more a simple click on the column header or for the rows selection click on the left legend. You can select several columns or rows. Selecting a column waives selecting a row and vice versa.

If no columns are selected and you call for instance an interpolation (e.g. Cubic Spline), then it will be implement with the entire data on the table. Otherwise, if several columns are selected (or all columns), only this will be processed.

The left column is the legend column. It serves e.g. as an inscription for the x-axis for a Business Diagrams. In Business Diagrams no real x-values are used.

The legend can’t edit directly, only from a dialogbox. That dialog will be called with a right-click to the mouse into the cell of the legend.

The data in the ArrayEditor are a mirror of the Memory Record. They are not converted into strings or other formats. Besides it is still faster.

Thus, the entries into the table must be real numbers (except date and time format columns).  

Record Memory Dialogbox

You can access directly the memory management in SimplexNumerica when you are in the EvaluationMode, by holding the control key and click with the left mouse button on the head of a column. Thus the appropriate column will be defined as the Current Record, i.e. all components of this field become preset.

The arrays are copied internally into the TestMode (in the TestMode all computations are implemented), all properties (e.g. line styles etc.) are adjusted from the current record entries. Immediately the Record Memory Dialogbox appears. It shows you the actually Memory Record with the name of the ArrayEditor header text. Changes in the memory box are taken immediately.

The call of some properties (e.g. the marker style) can be transacted also more simply without the detour over the memory box. 

Other work with the ArrayEditor

Many parts of the program are co-ordinated with the ArrayEditor and refer their functions to selected columns. The description of these functions is in the appropriate chapters of the 2D-Window.

Working with functions:

Assumed, you would like to normalize all x-Values of measurements on unity. In addition you have to call the table menu <Select x-Columns> and afterwards in the Pulldown-menu Functions <Normalize>. In the next popup menu click <Selected columns>. SimplexNumerica normalized afterwards all selected columns.