Well, you should verify that any calculations/data analysis that the
spreadsheet performs gives the expected results. Additionally, to be
thorough, I'd check for boundary or limit conditions (what if someone
enters a "0"--do you get an error in a calculation <divide by zero for
example> or is the problem ignored and you get an answer anyway). Also, if
you have certain data requirements--such as there must be triplicate raw
data values--can you get a result anyway and what are the implications of
that?
The "gold" version of the spreadsheet, after testing, should be saved in a
protected location and a working copy provided to the users.
Of course the testing will be documented, and the calculations in the
spreadsheet should be protected against modification (test this). Lastly,
the spreadsheet once completed should be archived for Part 11.
Note: spreadsheets typically do not have audit trails, but there's a at
least one solution available for this limitation
http://www.wimmersystems.com/
Now, this is the barest of outlines, but you should treat the validation as
one of the =application= of the spreadsheet, not of the spreadsheet
application itself. If you use built in functions, you should verify the
ones you use (or build yourself) but it's generally not required that you
test every function =available=.
Greg
"DeryaAksu"
<derya_aksu@ilsan To: "PharmWeb
Computer Validation"
.com.tr> <CompVal@www2.pharmweb.net>
Sent by: cc:
<CompVal@www2.pha Subject: Excel
Spreadsheet Validation
rmweb.net>
02/06/2002 05:18
AM
Please respond to
"PharmWeb
Computer
Validation"
I am searching information about "Excel Spreadsheet Validation".
How an excel spreadsheet is validated?
What are the contents of the document prepared for validation of an
"Excel Spreadsheet"?
If you have any document or information about this topic,would you
mind mailing to me?
--------------------------------------------
DeryaAksu
derya_aksu@ilsan.com.tr
ilsan ilta? a.?.
--------------------------------------------
|