Hi:
I have to validate lots of spreadsheets at work, but I’m not sure if I can use a calculator in order to validate the formulas in a spreadsheet or I have to do it manually, or I don’t know if the calculator has to be validated.
Hope somebody can help me.
Thanks in advance.
Hi,
While performing spreadsheet validation, this is a common practices across indutry to verify the calculation. It can be done in two ways 1. Manually 2. With help of calculating device
-
Mnaually ;
In case of manual calculation all raw calculation sheets need to be preserved with the validation data.
Ensure the rounding off will not be a culprit for significant value difference during manual calculation.
-
Calculating Device:
Device must be pre-qualified.
Qualification documents should be available readily.
Mention reference of these documents in your validation docket.
Validation Calculation values should be under the capacity of calculation device.
Happy Reading !
Your recommendations are very helpful, thank you for taking the time to answer
Best Regards!!
Hi:
I have to validate Empower Software for HPLC.Please if someone know how to do it help me.
Thanks.