Tables page

Spreadsheets ››
Parent Previous Next

Beside the common handling functions of the other pages like open, save, export, search and replace, the tables page provides extensive spreadsheet functions.


Read on for further details:



Table handling


To create a new table, specify the numbers of rows and columns click onto the "New table" button.

       


For cut, copy, paste, delete and select options, use the right click menu.


Click on the "Search" button to search and replace elements in the current table.



Mathematical and statistical functions


Use the tables page to work with your data. After creation of your customized table, apply formulas and calculate significant statistical values.


Sort


Data displayed in tables can be sorted by clicking on a column header. Dependent on the amount of mouse clicks, the data is sorted ascending and descending alternately. The entire table is sorted in respect to the column where the click ensued.


Apply formulas


The formula input panel "cell(row,col)=" enables you to process complicated calculations. Insert a formula and use some of the default functions if necessary. Select if your formula should be applied to selected cells only or to all cells and press "play".


See two examples below:



Fill a column with its row numbers


To fill a column with its row numbers, select empty cells and insert the formula:

       cell(row,col) = $row

in the formula panel and press "play". Every variable or function has to get a "$" sign as an escape sign.


The cells will be filled with the values: 1, 2, 3, ...


Multiply a column by a factor


To multiply a column filled with its row numbers by a factor of "3", select empty cells to the right of the origin column and insert the formula:

       cell(row,col) = cell($row, $col-1)*3

in the formula panel and press "play".


The origin column contains the values: 1, 2, 3, ...

and the results are: 3, 6, 9, ...


Statistical functions


On table page you are able to calculate statistical values easy and fast. Just click on the applicable button. The results are displayed on the output page.

Available functions are:



Find correlations


The "Find correlations" functions helps looking for dependencies within your table data. The algorithm calculates the formula, determines errors and creates plotable data of the appoximated functions.


To find correlations, proceed as follows:

  1. Mark the data cells which should be checked for dependencies. The correlation function assumes that single data channels are placed columnwise.
  2. Select the type of functions which should be approximated and adjust the speed-quality ratio for higher polynomial orders. These are determined by an statistical approach.
  3. Choose your required type of result:
    1. Correlations: The dependencies of any column against any other column is calculated.
    2. Plotable data of the approximated functions: This feature creates a lookup table of approximated functions with a reasonable stepsize for plotting. Therefore, define the columns of your origin values and their functional counterpart as well as the extreme values and the demanded step size. Specify your expected precision of the outputted values.
  4. Press start to begin.




Two dimensional plots


Mark at least two columns and click on the "Plot" button. A plot dialog opens and enables you to define your own plot settings. For further details see the "Two dimensional plots" section in the plotting chapter.



Convert data to z matrix


Each table might be converted to a z matrix. Therefore, mark the requested table data cells and click on the "Create image from selected cells" button. An image is created consisting of the selected table data as the z matrix.