Excel Spreadsheets and FDA Device Regulations - Webinar By GlobalCompliancePanel

(bit.ly)

We discuss the following issues:
The pitfalls of using Excel without a good regulatory plan
How to recognize when you are using software in production or the quality system
The use of Excel tools to help ensure spreadsheets are built correctly
The FDA’s requirements and expectation for production and quality system software
The reason for Part 11 and some of the implications
The requirements of Part 11 for electronic records and the current guidance document
Why should you attend: FDA Inspections are based on ensuring compliance with the regulations. Failure to comply can result in the FDA citing the company for a violation, i.e., listing it on an FDA Form 483 Inspectional Observations. The FDA may even escalate these observations to a Warning Letter. Unfortunately, many well meaning intentions may fail to satisfy the regulations. For example, a manufacturing engineer may recognize that an Excel spreadsheet could reduce the possibility of error in a manual calculation. On its own, the spreadsheet would be a valuable Preventive Action. However if the spreadsheet is not validated, approved, and documented properly it may create a problem during an FDA inspection. An unvalidated spreadsheet violates the QSR requirements for automated processes. The next easy step is to eliminate the form used in the manual calculation. It would straightforward, as the next step, to reduce the paperwork and just keep the calculations in the spreadsheet. This is potentially an "electronic record", and may violate 21 CFR Part 11. If manufacturers don't understand the regulations, they could create regulatory problems that are will be hard to fix.

Areas Covered in the Session:
Overview of the regulations
Automated processes
Production and process changes
General record keeping requirements
Electronic records
Excel Validation
Setting the validation criteria
Data types
Using lists to keep data consistent
Developing an input message
Developing an error warning message
Using the Excel Convert Function
Changing the unit of measure
Excel Formula Auditing
Tracing precedents and dependents
Watching formulas
Error checking
Circle Invalid Entries
Excel Protection
Locking and unlocking cells
Protecting a worksheet
Protecting a workbook
Selecting passwords
Track Changes
How to turn it on
The time limit for tracking changes
Viewing history
Understanding automated process
The regulation
The concept of validation
Establishing intended use
Establishing the validation protocol
The guidance document
How much validation evidence is needed?
Defined user requirements
Validation of off-the-shelf software and automated equipment
Electronic records
General requirements for records
Definitions from Part 11
Electronic records
Closed systems
Open systems
Summary of requirements
Validation
System access
Audit trail
Other requirements
The guidance document
Enforcement discretion
Electronic records . . .
in place of paper format
in addition to paper format
records submitted to FDA in electronic format
Who Will Benefit: Attendees should have knowledge of manufacturing and quality system processes. This typically includes:
Quality Engineers
Production and Process Engineers
Manufacturing Engineers
Design Engineers
Purchasing Managers
Purchasing Agents
Supplier Quality Engineers
Quality Supervisors
Quality Inspectors
Quality Managers
Quality Audit Managers
Quality Auditors