LIMS.eu

Navigation

To display a sample selection in the Results table, follow this path:
Navigation bar → Samples → Manage samples → Results table → show

• In the sample list, activate the checkboxes for the relevant samples.
• Then select the Results table option from the dropdown at the bottom of the table.
• Click show.

Figure: Show Results table 1

Additional ways to access the Results table:

• Click the Results table icon of the desired order to display the samples of that order in the Results table.
  
  Figure: Show Results table 2

Overview

The Results table enables:

• Simultaneous display of multiple pre-selected samples with their parameters and measured values in a tabular overview.
• Direct entry and editing of measured values within this table.
• Export of data as an Excel or CSV file.
• Individual customization of the displayed parameter columns via column filters.
• Display of statistical key figures (Min, Max, Average, Standard deviation, Sum).
• Bulk editing of samples directly from the Results table.

The following figure shows what the Results table looks like in the LDB. The functions are described below.

Figure: Results table

Description of the Tabular Overview

Samples are displayed row by row in a table. The parameter columns are grouped together in a configuration-dependent manner (e.g. Chemical parameters, Physical parameters, Anions).

Note: All sample numbers highlighted in blue are clickable links to the respective sample detail view. The parameter names in the header row are also clickable and open the associated chart. The naming of columns and the available parameter groups depend on the configuration.

Statistical Key Figures

Below the sample data, the Results table automatically displays statistical key figures for each parameter:

• Min – smallest entered or calculated value
• Max. – largest entered or calculated value
• Average – mean of all values
• Standard deviation – statistical spread of the values
• Sum – sum of all values
• Number of selected Parameters – number of samples for which this parameter is intended
• Number of entered Values – number of values actually entered

Functions

Entering a Value for a Parameter

Measured values can be entered directly in the Results table.

• Click on the desired parameter field in the row of the corresponding sample.
• Enter the measured value. For parameters with a dropdown selection, the corresponding options are available to choose from.
• Confirm the entry by clicking outside the field or pressing Tab to automatically move to the next input field.
• Use the keyboard shortcuts Alt ↑, Alt ↓, Alt ←, Alt → or Tab for quick navigation between input fields.

Note: Fields highlighted in red do not yet contain a entered value. Fields highlighted in grey contain a formula for calculating results. Locked fields (highlighted in grey with diagonal stripes, or e.g. in the case of finalized samples) cannot be edited. Parameters whose field contains a dash are not selected for the respective sample.

Enter Value for the Whole Column

To enter the same value for all samples of a parameter simultaneously, the Enter value for the whole column row is available at the bottom of the Results table.

• Click the button below the desired parameter (e.g. Messwert, °C, Wert).
• Enter the desired value in the dialog that appears.
• Click save to apply the value.

The value is only saved for those samples where the parameter is selected and no value has been entered yet.

Overwriting existing values

If already entered values are to be replaced, additional confirmation is required:

• Activate the checkbox Overwrite already entered values? before clicking save.
• Without activating this checkbox, already entered values remain unchanged.

Deleting values

To delete already entered values, proceed as follows:

• Activate the checkbox Overwrite already entered values?.
• Leave the input field empty.
• Click save to remove all entered values for the parameter.

Figure: Enter value for the whole column

Select Columns

Customize the displayed parameter columns individually.

• Click the Select columns button to show the column selection.
• Activate the checkboxes of the desired parameter columns in the displayed selection row.
• Click Show column selection to reduce the view to the selected columns.
• Optionally save the selection as a filter: Activate the Save column selection checkbox, assign a name and click save.

Figure: Select columns individually

Using Column Filters

Saved column filters enable quick switching between frequently used column views.

My Column Filters

• Click the My column filters dropdown to access your personally saved filters.
• Select a filter from the list to adjust the Results table accordingly.
• Via the Manage filters entry you can access filter management.

Public Column Filters

• Click the Public Column Filters dropdown to use system-wide shared filters.
• The currently active filter is highlighted in the list.

Figure: Column filters

Additional Information: Automatic Sample Notifications

Chart

In the LDB, you can display trends, correlations and histograms as charts, and view statistical key figures (standard deviation, variance, Cp, CpK, etc.). The chart shows the measured values of your samples as a graphical trend, allowing you to assess trends, outliers and compliance with target values at a glance. A tabular overview of the underlying measured values is also available.

• Click on the blue-highlighted name of a parameter in the header row of the Results table to open the chart for that parameter.

Additional Information: Charts and Statistical Key Figures

Bulk Editing of Samples

Click the Edit Samples button (orange, top right) to access the view for bulk editing of all samples displayed in the Results table.

Figure: Edit Samples button

The following describes the functions available to you in the Edit Samples collectively screen:

Figure: Edit Samples

1. Edit Sample Master Data for all selected samples simultaneously

• Change Sample Master Data such as status, order, specification, labels, examination packages and further for all selected samples simultaneously.
• Click the save icon (floppy disk) next to the respective field to apply the change.

Figure: Edit master data simultaneously

2. Edit Master Data in a Table

Edit the master data of multiple samples in a table view.

• Click the Edit master data in table link in the Edit Samples view.
• In the table view that appears, select the master data fields to be displayed.
• Click the Show column selection button to display the master data of all selected samples in tabular form.
• Make the desired changes and save the data when finished.

Figure: Edit master data in table

3. Adding / Removing Parameters

Add parameters to the selected samples or remove them.

• Click the plus icon next to a parameter to add it to all selected samples.
• Click the minus icon next to a parameter to remove it from all selected samples.
• The change is saved automatically.

Abbildung : Add / Delete Parameters

Note: Parameters with already entered measured values can no longer be removed. (Indicated by the lock icon.)

4. Deleting Samples

Delete all selected samples collectively using the function in the Edit Samples view.

• Click Delete all samples.
• Optionally enter a reason for the deletion.
• Deleted samples are moved to the recycle bin and can be restored if needed.

Bulk Editing of Samples – from the Samples List

The bulk editing view can also be accessed directly from the Samples list:

• Open the Samples list.
• Select the desired samples using the respective checkboxes.
• Click edit at the bottom of the Samples list.

The Edit Samples view that then appears provides the functions described above.

Switch to Samples List

• Click the Samples list button in the top menu bar to switch to the sample list

Export Functions

Excel Export

• Click the Excel export button in the top menu bar.
• The currently displayed table view, including any active column selection, is downloaded as an Excel file.

CSV Export

• Click the CSV Export button to export the data in CSV format.