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: 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