Addressing Data Integrity Challenges when Relying on Spreadsheets for Calculating and Documenting Laboratory Results

Sep 13, 2018

Register Free:

When reporting and calculating results in a laboratory, analysts have many options, each with its own benefits and challenges:

  • Within the LIMS or SAP system
  • Within the data-generating application (CDS, MS data system, spectroscopy software, etc.)
  • Using external applications (MiniTab®, Microsoft ®Excel, SAS®)
  • Using paper records and manual calculators

A recent LCGC publication discussed the relative merits of each and highlighted the specific concerns around using spreadsheets, specifically to address current Data Integrity concerns such as attributability, security, version control, traceability, and audit trails.

In this webcast we will discuss the challenges associated with spreadsheets, while acknowledging that sometimes a compliance-ready application may not be available, or a laboratory may have a need to combine data from multiple sources into a single report. This webinar will propose a solution to offer the comfort of using a familiar application such as a spreadsheet while providing the technical controls expected in today’s regulated environment.


Key Learning Objectives:

  • Current regulatory expectations that are not met with standard spreadsheet applications, even when validated
  • Options for mitigating these challenges using applications already in the laboratory
  • Tools for overcoming the security and technical controls that are missing in spreadsheet applications today


Who Should Attend:

  • Regulated companies
  • Laboratory directors, managers, and analysts
  • Information technology professionals supporting laboratory applications
  • Quality Assurance professionals



Garrett Mullen, Product Owner, Laboratory Management, Waters Corporation

Heather Longden, Senior Marketing Manager, Informatics and Regulatory Compliance, Waters Corporation


Date and Time:

Live: Thursday, 13 September, 2018 at 10 am EDT | 1500 BST | 1600 CEST

After the final airing of the webcast on 13 September, 2018 it will be available on demand until 13 September, 2019. 

Sponsor: Waters Corporation    

Register Free:

lorem ipsum