Measurement repetitions value selection
You can use number series formulas to select which measurement from repeat measurements appears on the report.
If you want to use measurement repetitions and decide which of the measurements appears on the report, you can use formulas for numerical series. The individual measured values of the measurement repetition are to be treated as a numerical series. To do this, first create at least 2 columns in the corresponding parameter (Add Parameter). One column for the measurement results and one for the result that should appear on the report (this must be selected in the report table editor).
In the column for the result, you store a formula that selects which of the values should be chosen. For this, you use the formulas from Calculating with number sequences.
For example, you can store the following formulas (with 2 columns, column 0 contains the final result):
| Highest measured value | max(this(1)) |
| Lowest measured value | min(this(1)) |
| First measured value | first(this(1)) |
| Last measured value | last(this(1)) |
| 2nd measured value | csventry(1, this(1)) |
| Average of all repetitions | mittelwert(this(1)) |
This is how it could look if you always took the highest value:
Last change: 25.08.2025
Allgemeines
- Main menu
- Dashboard
- Backup / Data protection
- Version number of the Labordatenbank
- Supported browsers
- Activation of SSO in the Labordatenbank
- Print labels
- Automatic Labordatenbank validations
- Create/Edit/Delete Categories
- Status management
- SMTP Configuration
- Konfiguration SMTP via OAuth 2.0
- IT requirements for the use of the Labordatenbank
- Add Dashboard Widgets
- Evaluation criteria for suppliers
- Edit evaluation criteria for suppliers
- Test SFTP/FTP Connection
- Restore Deleted Records
- Manage PDF Templates
Einführungsphase
- Labordatenbank introduction checklist
- Labordatenbank data structure
- Implementing the QM-Database
- Import parameters (Introduction phase)
- Import sample master data (Introduction phase)
- Benefits of the Labordatenbank Cloud
- configurable master data fields in the Labordatenbank
Auswertungen
- Create evaluations using a template
- SQL Basic Course
- SQL JOINs
- SQL Basics
- Create SQL reports
- Parameter columns
- Variables in SQL reports
- Export SQL Reports
- Link Evaluations
- SQL report tables (SQL table and SQL bar chart)
- Save and Display MySQL Labordatenbank Backup Locally
- Link evaluations with import interface
Mitarbeiter
- Add employee
- Labordatenbank Login
- Change employee
- Change password
- Create task
- Access rights
- Employee groups
- Audit Trail: traceable documentation of all work
- Import employees (introduction phase)
- Archive employees
- Tracking working hours
- activate Multi-Factor-Authentification (MFA) with TOTP
- activate a Security Key for the MFA
- Activation of Passkey
- Install TOTP App
- Edit Accessright
Aufträge
- Create Order
- Add an order using a template
- Equipment GPS location
- Add samples with an order template
- Add on-site inspection
- Delete order
- Scanning and sending documents to the Labordatenbank with QR
- Typical configurations
- Create order templates
- Create orders using templates
- Defining order access rights
- Order schedule
Proben
- Add samples
- Add multiple identical samples
- Enter values
- Enter identical values for multiple samples
- Edit samples as a group
- Sample search
- Sample sorting rules
- Statistical evaluations
- Save sample search as filter
- Show results table
- Column filter for results table
- Create filters specific to employee groups
- Automatic creation of analysis orders for external contracting
- Create analysis plan for samples
- Automatic Sample Notifications
- Delete samples
- Map pooled samples in LIMS
- Sample Tracking with QR Code (Scanning at Stations)
Probenvorlage
Berichte
- Create report
- Sign reports
- Send reports by e-mail or post
- Reissue of signed reports
- Inserting Images and File Attachments into a Report
- Create checklist with report table editor
- Protect emails from spam filters
- Certificate
- Manage signatures
Kunden
- E-mail templates for reports and invoices
- Create customer
- Add contact persons at customers
- Merging duplicate customers
- Search customers
- Forward emails to the Labordatenbank
- Import customers ( introduction phase)
- Delete Customer
Berichtstabellen Editor
- Create report table with Report Table Editor
- Add column to report table
- Creating a parameter table with target values
- Create sample table
- Create table with open structure
- Report templates
- Order of the report tables
- Fonts and character set for PDF reports
- Report tables overview
- Measurement repetitions value selection
Kundenzone (optional)
- Activating the Customer Zone
- Customerzone
- Create Online Analysis Order
- Sampling with online analysis order
- Hide parameter columns in customer portal
- Provide files in the customer zone
Anlagen
- Add new Assets
- Add asset parts to asset
- Add order templates to equipment
- Add tests to order templates
- Copy assets, order templates, and asset components
Angebote
- Create offer
- Add prices and price items
- Appendix with Terms and Conditions and Service Catalog
- Send Offer
Rechnungen
- Create Invoice
- Sending Invoices
- The English translation for "Teilzahlungen bei einer Rechnung erfassen
- Manage price list
- Exporting invoices
- Import billing items (Introduction phase)
- Create revenue centers for prices
- Activate X-invoice / E-invoice for Germany
- Create Collective Invoices
- Cancel invoice
- QR code for online banking on invoices
Parameter
- Basics of parameter management
- Add Parameter
- Parameter grouping and order
- Daily Task List: What has to be done in the laboratory
- Create table with parameter limit values
- Parameter Usage Annual Overview
- Delete test group, parameter group, or parameter
- Automatically display due parameters
- Legends & markings for subcontracting & accreditation
- Parameter data types
- portray proficiency tests
- examination packages
Rechnen mit Parametern
- Deposit formulas with parameters
- Calculating with number sequences
- Example: Weighing in and weighing out
- Calculation of dry matter and annealing loss
- Example: Calculation of annealing loss with validity check
- Example: Determination of Chemical Oxygen Demand
- Example: Determination of TVC - aerobic mesophilic total viable count
- Calculating with Date/Time Information
- Bsp.: Drinkingwater-Legionella since March 2023 (German Regulation)
Schnittstellen
- Import Interfaces Overview
- Import results from measuring instruments
- Create CSV measurement data import interface
- Import measurement data
- Import of samples
- Mode for measured value import
- Automatic FTP/SFTP Import
- Testing the HTTPS Import Interface
- Transformation code for importing other data formats
- Practical example: Import GC/MS measurement values to your LIMS system
- Practical example: Import Biomerieux Vitek antibiogram into LIMS
- Connect Thermo Fisher Chromeleon to LIMS
- Connect PCR to LIMS with plate assignment
- LIMS connection to DEMIS reporting for pathogen detection
- Tips for import interfaces
- Imort pictures in parameters
- Connection of Essentim data loggers
Webservice
- Labordatenbank Webservices
- Provide data as web services for external systems
- Send data to an external web service
- Send data to the Labordatenbank
- Example: Send eTermin to the Labordatenbank
- Example: JSON file for creating samples
Transformationscode
- General structure of a transformation code
- Transformation code for evaluations
- Export transformation code
- Webservice Response Handler
- Import transformation code
Prüfpläne / Grenzwerte / Spezifikationen
- Create test plan / limit values / specification
- Add setpoints
- Add target values - Special cases
- Targetvalue violations
- Parameter-specific text modules according to limit tables
Dokumentenlenkung
- Create a New Document
- Create new version
- Validate document
- Release Document
- Request read confirmation
- Import documents (Introduction phase)
- Change the document creator afterwards
- Delete documents
- Documents: Confirm validity check
Fragen und Antworten
- IT requirements
- Where can I find the current version number of the _LABORDATENBANK__?
- How can I calculate the average from five measured values?
- Where do you enter titles like Dr/Prof/Dipl. etc.?
- How can I change the order of parameters in the packages?
- Querious: Delete archived reports
- Download files in the Edge browser instead of opening them directly
- Transfer the status of the production system to the test system
Prüfmittel
- Test Equipment Management
- Test equipment detailed view
- Add/edit/delete Test Equipment
- Import test equipment (introduction phase)
- Create control charts
- Import control values from test equipment
- Print labels for test equipment
- Forward emails to test equipment
- Booking Test Equipment
- Test Equipment Calendar
Material
- Functions of Material Management
- Create/edit/delete material
- Linking materials with parameters
- Reorder Materials Online
- Management of chemicals
- Manage/Create/Edit/Delete Batches
Mitarbeiterschulungen
- TrainingSchedule: Document Training Sessions, Demonstrate Competencies
- Add/edit/delete training
- Import Trainings (Introduction phase)
8D-Report
Sonstiges
PDF-Vorlagen
- Create/edit PDF templates
- Design elements Setting options
- Create design elements
- Integrate report tables into design template
- Design element for the reason for reissuing test reports
Lieferantenbewertung
Dateiverwaltung
- Add Files (to Samples, Customers, Orders)
- Add Files (Test Equipment, Material, Batches, Specifications)
- File Management
- Search data
Prozesse