蒲公英 - 制药技术的传播者 GMP理论的实践者

搜索
查看: 2759|回复: 4
收起左侧

[GMP相关] FDA警告信-MS excel表

[复制链接]
药士
发表于 2016-10-2 11:01:59 | 显示全部楼层 |阅读模式

欢迎您注册蒲公英

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
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


回复

使用道具 举报

药士
 楼主| 发表于 2016-10-2 11:11:46 | 显示全部楼层
可以参考EDQM OMCL的excel表单验证模板
回复

使用道具 举报

药徒
发表于 2016-10-2 11:19:28 | 显示全部楼层
电子数据不受控,化验员可以随意修改;实验室数据计算不受控,所用的Excel公式可以随意更改,另外就是没有验证。
回复

使用道具 举报

药士
 楼主| 发表于 2016-10-2 21:54:30 | 显示全部楼层
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
回复

使用道具 举报

药神
发表于 2023-2-19 16:36:31 | 显示全部楼层
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

×发帖声明
1、本站为技术交流论坛,发帖的内容具有互动属性。您在本站发布的内容:
①在无人回复的情况下,可以通过自助删帖功能随时删除(自助删帖功能关闭期间,可以联系管理员微信:8542508 处理。)
②在有人回复和讨论的情况下,主题帖和回复内容已构成一个不可分割的整体,您将不能直接删除该帖。
2、禁止发布任何涉政、涉黄赌毒及其他违反国家相关法律、法规、及本站版规的内容,详情请参阅《蒲公英论坛总版规》。
3、您在本站发表、转载的任何作品仅代表您个人观点,不代表本站观点。不要盗用有版权要求的作品,转贴请注明来源,否则文责自负。
4、请认真阅读上述条款,您发帖即代表接受上述条款。

QQ|手机版|蒲公英|ouryao|蒲公英 ( 京ICP备14042168号-1 )  京ICP证150354号  互联网药品信息服务证书编号: (京)-非经营性-2024-0033

GMT+8, 2024-11-11 06:47

Powered by Discuz! X3.4运维单位:苏州豚鼠科技有限公司

Copyright © 2001-2020, Tencent Cloud.

声明:蒲公英网站所涉及的原创文章、文字内容、视频图片及首发资料,版权归作者及蒲公英网站所有,转载要在显著位置标明来源“蒲公英”;禁止任何形式的商业用途。违反上述声明的,本站及作者将追究法律责任。
快速回复 返回顶部 返回列表