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:
- Input cells open, every formula cell locked, the sheet protected.
- The template under version control, with one released copy.
- Each formula checked once against a hand calculation, with the evidence filed.
- 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




