P&K KFA (VDI 3781 part 4)
Operation within the tables
The order and the width of all columns can be changed by clicking into a column header or between column headers and dragging as desired. This is practical if values are in a particular order, because Tab has to be pressed just once in order to reach the next column.
If the data in the columns are too wide to be displayed, then the symbols (in brackets) will be hidden in the column titles (e.g. Temperature (T0) ). Widening of the column will show that particular symbol.
The buttons "+" and "-" are used to insert or delete data sets. With the button "Dup" the current data set can be duplicated. The new row will become the last row in the table. This is useful if a data set is to be generated with minor difference to the current one. To insert a row, select the lower gray row before pressing the "+" button.
Individual fields, in which a selection is possible, are marked yellow. To activate the selection click once in a cell in order to select this; click a second time in order to activate the selection (no doubleclick).
With the cursor or Tab key, the focus can be moved between individual fields.
The illustrated section can be scrolled one row up or down by moving the cursor across the upper or lower edge of the table form.
Some tables can be sorted. With a right mouse button click into the considerable column, a Pull-Down Menu will be opened, and Sort Ascending or Sort Descending can be selected.
In some tables, a Row-Editor can be invoked. The Row-Editor shows one dataset only and can have more or less features then the grid dialog.
Sometimes single Columns can be imported via the Popup Menu. From the selected file, the values are taken and written to the position, from which the dialog was invoked. One value will be read per line from an ASCII file (includes CSV format) .
Table Import and Export
In most tables, data can be imported or exported with the buttons in the tool bar. The sequence of the columns and which columns are used, depends on the current column order and the current filter setting. With a button in the tool bar, a form can be opened which gives information about the current settings.
Single Columns can be imported via the Popup Menu. From the selected file, the values are taken and written to the position, from which the dialog was invoked. One value will be read per line from an ASCII file (includes CSV format) .
Available formats for import and export
CSV | Columns are separate by commas (Comma Separated Values). If a text contains commas, it must be written in " " (Quotation marks). The decimal character is the point. Values can optionally contain an exponent (e.g.: 6.E-9), however no additional separators are allowed. |
TXT | Columns are separated by spaces. If a text contains spaces, it must be written in ' ' (Apostrophe). The decimal character is the point. Values can optionally contain an exponent (e.g.: 6.E-9), however no additional separators are allowed. |
Current Project Extension | Individual tables can be loaded from project files. The loaded table must fit logically into the project. The export creates a new project file, which contains only the exported table. |
The formats can be selected in the appropriate dialogs under the type of file. The filter function is switched off for other formats than CSV, TXT and *!
Preview
The tables can be viewed appealingly as an HTML-file by using the preview function. see Report function.