FDA警告信-MS excel表

beiwei5du

FDA Warning Letter - Microsoft Excel Spreadsheet

Date: 13 June 2012
Link FDA 483 (New Window)
Observation
5. Your firm has not established and documented the accuracy, reliability and performance of your computer systems employed in the release of drug products [21 C.F.R. 211.68 (a)]

For example, your firm did not verify the accuracy of Excel spreadsheets used to calculate product assay analytical results, for all products manufactured for the US market, in order to verify the accuracy of the results obtained.

This is very similar to a observation from 2010 in the use of Microsoft Excel Spreadsheets which stated

6. Your firm has failed to exercise appropriate controls over computer or related systems to assure that changes in master production and control records, or other records, are instituted only by authorized personnel [21 C.F.R § 211.68(b)].


a) Your firm's laboratory analysts have the ability to access and delete raw chromatographic data located on the (b)(4) of (b)(4) used to conduct HPLC testing. Due to this unrestrictive access, there is no assurance that laboratory records and raw data are accurate and valid.

b) Your firm's laboratory analysts have the ability to access and modify the formulas in the Excel spreadsheets used to calculate assay results for Guaifenesin and (b)(4) drug products. Due to this unrestricted access, there is no assurance that the formulas in the Excel spreadsheets are accurate and valid.

Comment
Microsoft Excel Spreadsheets are used throughout the pharmaceutical industry, generally installed on every desktop computer. However when using spreadsheets to make calculations that are used to support product release and quality based decisions then the spreadsheet must be controlled and verified to ensure that the spreadsheet is secure and that the calculations are accurate across the range.

The security of the spreadsheet should ensure that users of the spreadsheet can only enter data in to specific cells and that the calculations cannot be modified. Basic Excel security can be used to ensure this.

Calculations should be verified across the data range against manually calculated results. Care should be taken relating to rounding errors and resolution..

The spreadsheets should be maintained within a document management system or other secure location to ensure that the files can be access but cannot be modified or overwritten. Changes to the spreadsheets should be managed by Change Control.

Posted by Barry Tedstone    No comments:   

Labels: FDA Warning Letters, Spreadsheets

beiwei5du

可以参考EDQM OMCL的excel表单验证模板

城里人hh

电子数据不受控，化验员可以随意修改；实验室数据计算不受控，所用的Excel公式可以随意更改，另外就是没有验证。

beiwei5du

liufeng 发表于 2016-10-2 11:19
电子数据不受控，化验员可以随意修改；实验室数据计算不受控，所用的Excel公式可以随意更改，另外就是没有 ...

A general rule should be to avoid using spreadsheets as much as possible, but where they are used they must be controlled and validated

小金库

谢谢共享