Validation and control of excel spreadsheets in regulated environments
This presentation is the property of its rightful owner.
Sponsored Links
1 / 5

Validation and Control of Excel Spreadsheets in Regulated Environments PowerPoint PPT Presentation


Excel Applications are widely used in laboratories, offices and manufacturing e.g., for data capture, data manipulation and report generation. Regulations such as HIPAA, Sarbanes Oxley Act and FDA's GxP and 21 CFR Part 11 require users of software and computer systems to demonstrate and document data accuracy, integrity and confidentiality. Out-of-the box Excel has not been designed for regulated environments. However, with a good knowledge of Excel capabilities combined with good procedures and practices on how to validate and use Excel requirements can be met. For example, the FDA is widely using Excel and complies with its own regulations.Hand-outs :For easy implementation, attendees will receiveSOP: Validation of spreadsheet applicationsSOP: Development and use of spreadsheets in regulated environmentsGap analysis/checklist for Macros and Spreadsheet applications

Download Presentation

Validation and Control of Excel Spreadsheets in Regulated En...

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Validation and control of excel spreadsheets in regulated environments

Validation and Control of Excel Spreadsheets in Regulated Environments

Speaker: Ludwig Huber| Date: 31st May 2016 2016 2016 | 10:00 AM PST | 01:00 PM EST

Contact Us : Email: [email protected] | Tel: +1-248-233-2049


Description

Excel Applications are widely used in laboratories, offices and manufacturing e.g., for data capture, data manipulation and report generation. Regulations such as HIPAA, Sarbanes Oxley Act and FDA's GxP and 21 CFR Part 11 require users of software and computer systems to demonstrate and document data accuracy, integrity and confidentiality. Out-of-the box Excel has not been designed for regulated environments. However, with a good knowledge of Excel capabilities combined with good procedures and practices on how to validate and use Excel requirements can be met. For example, the FDA is widely using Excel and complies with its own regulations.

Hand-outs :

For easy implementation, attendees will receive

SOP: Validation of spreadsheet applications

SOP: Development and use of spreadsheets in regulated environments

Gap analysis/checklist for Macros and Spreadsheet applications

Description:


Areas covered in the session

  • Regulatory requirements for spreadsheets; FDA Part 11 and GxP

  • Recent FDA inspectional observations and warning letters

  • Recommendations from the new GAMP®5 and EU Annex 11

  • How to design spreadsheets for compliance.

  • How to design, ensure and validate spreadsheet integrity.

  • When, what and how much to test?

  • Validation of standard/native Excel functions?

  • How to apply risk based validation to spreadsheet applications

Areas Covered in the Session:


Who will benefit

  • Developers and users of spreadsheet templates

  • Lab Supervisors and managers

  • QA managers and personnel

  • Analysts

  • Consultants

  • Teachers

Who will benefit:


Instructor profile

Ludwig Huber, Ph.D., is the director of Lab compliance and  editor of w.labcompliance.com, the global online resource for validation and compliance. He is the author of the books "Validation and Qualification in Analytical Laboratories" and "Validation of Computerized Analytical and Networked Systems". He has given multiple presentations mainly on GLP/GMP, 21 CFR Part 11, and Validation around the world. This included seminars, workshops and presentations for the US FDA, China CFDA, , ISPE, Japan PDA, PIC/S and several other national health care agencies. 

Instructor Profile :


  • Login