Hi, Does anyone know of or have a Spreadsheet Validation Checklist that can be used for GxP spreadsheets, ie so you know what to do if it is simply a list of GxP data vs what to do if it is a complex Spreadsheet with macros and calculations?
Idealy I want to create a document that can be used to validate simple spreadsheets which can be signed off as documented evidence and then for the more complex spreadheets, additional document requirements are highlighted
You may want to consider the following items when developing your guideline/template
Will this workbook/excel sheet be store in a secure location. Version control
Password Protect the spreadsheet
All cells that are not input fields need to be locked down
Mathematical forumla, macros need to be verified in the case of the macros you may need to do some sort of source code review to ensure that the code is robust.
Mathematical calulations need to be verified with a calculator, each cell that performs a calculation.
Verify locked cells , verify unlocked cells.
Change control for updating/changing the spreadsheet.
Archiving and securing old sheets in a secure location.
I have perfomed the validation of numerours spreadsheets with macros etc and have developed my own validation document (yes one document) to provide full validation. See below for the li st of headings that I used.
i found your topic about the spreadsheet validation checklist and so on. I would be interested in experience with this or other things (protocols, checklist), if you have some information, you can contact me.
You may want to consider the following items when developing your guideline/template
Will this workbook/excel sheet be store in a secure location. Version control
Password Protect the spreadsheet
All cells that are not input fields need to be locked down
Mathematical forumla, macros need to be verified in the case of the macros you may need to do some sort of source code review to ensure that the code is robust.
Mathematical calulations need to be verified with a calculator, each cell that performs a calculation.
Verify locked cells , verify unlocked cells.
Change control for updating/changing the spreadsheet.
Archiving and securing old sheets in a secure location.
I have perfomed the validation of numerours spreadsheets with macros etc and have developed my own validation document (yes one document) to provide full validation. See below for the li st of headings that I used.
Purpose
Scope
Applicable documents
Definitions
Intended use and base risk statement
Configuration management
Requirements
Design
Testing approach
Test Results
Test Summary
Validation conclusion.
Hope you find this answer helpful
Kind Regards[/quote]
Hi
Can you give me an sample file that you prepared ?
how can i buy this sample ?