Skip to content

Life Sciences

The GMP spreadsheet nobody validated

  • Life Sciences
  • 1 min read

An Excel file that calculates the F0 of a sterilisation cycle can release or reject a batch. Most sites never listed it as a system.

EU GMP Annex 11 applies to all forms of computerized systems used as part of GMP-regulated activities. A spreadsheet becomes one the moment its answer drives a GMP decision: an assay result, an airflow figure in a requalification report, a cumulative F0 value. Excel itself is off-the-shelf software. The formulas someone typed into it are not.

What goes wrong is rarely dramatic. A row gets inserted and the SUM range stops one line short. Someone pastes values over a formula to fix a rounding problem. Three copies of the template live on three laptops, and the one on the shared drive is the oldest.

The minimum we would expect to find in an audit:

  1. Input cells open, every formula cell locked, the sheet protected.
  2. The template under version control, with one released copy.
  3. Each formula checked once against a hand calculation, with the evidence filed.
  4. A rule for where completed sheets are saved and who may change the template.

GAMP 5 handles end-user applications like these on a risk basis, so a simple sheet does not need a thick validation package. It does need to be on the inventory.

When we write a validation strategy, the spreadsheets go on the system list next to the SCADA.

Industries

Related

More on this subject

GMP on the electrical side

Where a SCADA, BMS or EMS records GMP-relevant data, access control, clock synchronization, alarm records and audit trails are decided by the electrical and automation engineers. Many sites keep those parameters on a separate validated EMS. Humiley's cross-functional training covers GMP, validation and project management.

InsightRead

Keep the BMS outside the EMS validation boundary

When the BMS and the validated EMS share one platform, the validation boundary takes in the control logic and every setpoint change becomes change control. An EMS with its own sensors, database and QA alarms under Part 11 and Annex 11 allows the BMS to be managed under good engineering practice.

InsightRead

Part 11 starts with the predicate rule

Part 11 applies to electronic records that a predicate rule such as 21 CFR 211 requires. For a BMS or EMS, name the rule behind each point: GMP-critical monitoring usually belongs in a validated EMS. For EU export, Annex 11 has no predicate-rule test, so the BMS still needs a risk assessment.

InsightRead