How can I calculate the average from five measured values?
This document addresses a user's request for a corrected formula to calculate the mean of five measured values in a Labordatenbank. It confirms the formula has been fixed, provides a screenshot of the solution, and explains the abbreviations used in the formula (avg for average, MPV for parameter, m for matrix, and 1 for column 2). It also includes a tip for data structuring for easier reporting.
Dear Mr. Wagner,
Please find enclosed a question from me:
I had tried to generate the mean value from 5 measured values using the formula in column (5?) “Mean value”, unfortunately I probably made a mistake when creating the formula.
Could you please tell me the formula to get the mean value from the measured values at the end?
Hello Mr. ****,
It's great how well you have documented the task with a screenshot and sample number. We were able to understand this immediately and solve it straight away.
The formula has been corrected as requested. I have solved this as follows:
The abbreviations stand for the following data:
avg: Average = average
MPV: Abbreviation of the parameter
m: Matrix to address cells
1: Column 2 (the computer starts with 0 as the first column)
Greetings,
Konrad M. Wagner
Last change: 12.11.2025
General information
- Main menu
- Dashboard
- Backup / Data protection
- Version number of the Labordatenbank
- Supported browsers
- Activation of SSO
- 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
- Restore Deleted Records
- Manage PDF Templates
- Email informations
- Employee profiles
- Filter management - Search filter and column filter
- Edit Filters - Search Filters and Column Filters
- Hours per week
- Annual overview
- Hours per day
- Vacation days
- Edit hour
- Manage Weekly Hours
- Manage materials
- Onlineorder detailview
- Manage orders
- Edit orders
- Edit process key figures
- Create process key figures
- Manage 8D-Reports
- Process management view editing
- Edit processes
- Manage Projects
- Edit projects
- Manage recipes
- Create/edit recipe
- Operating the recipe detail view
- Edit planned order
- Edit planned samples
- Create/edit/delete station
- Tag management
Reports
- Create report
- Inserting Images and File Attachments into a Report
- Sign reports
- Request signature
- Reissue of signed reports
- Send reports by e-mail or post
- Protect emails from spam filters
- Verify authenticity of reports and certificates
- Certificate
- Manage signatures
- Create / edit / delete a signature
Report table editor
- Create / edit / delete a report table
- Create / Edit reporttable column
- 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
- Create checklist with report table editor
- Measurement repetitions value selection
Interfaces
- Import Interfaces Overview
- AI Extension for Import Interfaces
- Edit Attributes in Import Mapping
- 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
- Test SFTP/FTP Connection
- 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
Kompetenzen
AI functions
- Activate/deactivate AI functions
- AI Explorer
- Query Explorer
- AI Import: Automatically assign external calibration certificates
Employees
- Add employee
- Archive employees
- Reactivate archived employees
- Manage employee groups
- Edit employee group
- Create task
- Audit Trail: traceable documentation of all work
- Access rights
- Edit Accessright
- Tracking working hours
- Labordatenbank Login
- Change password
- activate Multi-Factor-Authentification (MFA) with TOTP
- activate a Security Key for the MFA
- Activation of Passkey
- Install TOTP App
- Import employees (introduction phase)
Introductory phase
- 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
- Transfer files securely to the Labordatenbank
Query reports
- Create query reports using a template
- SQL Basic Course
- SQL JOINs
- SQL Basics
- Create / Edit query reports
- Parameter columns
- Variables in query reports
- Export data from query reports
- Link Evaluations
- Query report tables (SQL table and SQL bar chart)
- Save and Display MySQL Backup Locally
- Link evaluations with import interface
Orders
- 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
Samples
- 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)
Templates
Customers
- E-mail templates for reports and invoices
- Create customer
- Add / Edit / Delete contact persons at customers
- Merging duplicate customers
- Search customers
- Forward emails to the Labordatenbank
- Import customers ( introduction phase)
- Delete Customer
Client zone (optional)
- Customerzone
- Activating the Customer Zone
- Create Online Analysis Order
- Sampling with online analysis order
- Hide parameter columns in customer portal
- Provide files in the customer zone
Assets
- 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
Offers
- Create offer
- Add prices and price items
- Appendix with Terms and Conditions and Service Catalog
- Send Offer
Invoices
- 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
- Suggest billing items
Parameters
- Basics of parameter management
- Add Parameter
- Parameter grouping and order
- Daily Task List: What has to be done in the laboratory
- 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
- Manage examination packages
- Create / Edit examination packages
Calculating with parameters
- 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)
Webservices
- 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
Test plans / limit values / specifications
- Create test plan / limit values / specification
- Add setpoints / rules
- Add target values - Special cases
- Targetvalue violations
- Parameter-specific text modules according to limit tables
Documents control
- 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
Material
- Functions of Material Management
- Create/edit/delete material
- Linking materials with parameters
- Reorder Materials Online
- Management of chemicals
- Manage/Create/Edit/Delete Batches
- Use batch samples
Questions and answers
- 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
Equipment
- 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
Trainings
- TrainingSchedule: Document Training Sessions, Demonstrate Competencies
- Add/edit/delete training
- Import Trainings (Introduction phase)
8D-report
Others
PDF templates
- 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
Supplier evaluation
File management
- Add Files (to Samples, Customers, Orders)
- Add Files (Test Equipment, Material, Batches, Specifications)
- File Management
- Search data
Processes