Site icon Pharma Dekho

sop for operation for validation of excel worksheets

1.0 OBJECTIVE 
1.1 To describe procedure for procedure for Validation of ex.cel worksheets.
2.0 SCOPE
2.1 This procedure is applicable for Validation of excel worksheets of Quality Control Department
3.0 RESPONSIBILITY
3.1 Officer /Executive – QC
4.0 ACCOUNTABILITY

4.1 Head – QC
5.0 PROCEDURE

5.1 Operating Procedure

5.1.1 The Validated excel worksheets shall be stored in the respective Controlled excel worksheet folders.

5.1.2 The Group leader/ Lab QA should issue an excel worksheet number to analyst for preparing the new excel worksheet

5.1.3 The analyst shall take an A.R. No. for the excel worksheet validation activity.

5.1.4 The Group leader should assign the excel worksheet number in the following manner DB/QC/ES/001 where ‘DB’ is the company identity, ‘QC’ is identity of department, ‘ES’ denoted as Excel Sheet and ‘001’ is the unique serial number for the Validated Excel Sheet which is continuous in increasing order for different Excel Sheet.

 

5.1.5 Maintain a list for the excel worksheet numbers where the details of sample name /activity and tests for which the excel worksheet is recorded along with the validated by/on date. Refer Format




5.1.6 After assignment of the excel worksheet number the analyst should prepare the excel worksheet as per the requirement and submit to the group leader for review. One excel worksheet should contain only one test

 

5.1.7 The group leader should check the excel worksheet against the Guideline/MOA/ Specification for calculation and formula.

5.1.8 If the worksheet is found OK, then it must be validated before it is kept for usage.

5.1.9 Enter the values in the relevant cells. Results will be calculated by the prepared excel worksheet and the values are displayed. Obtain a printout of the excel worksheet.

5.1.10 Enter the relevant details in the Validation Report for excel worksheet, Refer Format

5.1.11 Calculate the results manually using the same values as in excel worksheets with the help of scientific calculator and report the results in the validation report for excel worksheets. Refer Format

 

5.1.12 Write the results obtained by software and manual calculation on the validation report.

5.1.13 Attach the excel worksheet print to the validation report.

5.1.14 Compare the results obtained by software and manual calculation and record the same in the validation report.

5.1.15 The sheet should be protected in such a way that analysts are able to enter the values and data only in the cells meant for variable values and analysis information data. All the other parts of              the excel work sheet like the formula cells and the other cells and their formatting should not be available for modification to the analyst. The modification can be done only by the

reviewer and /or Group Leader. This can be done by activating the protection for excel worksheet and excel workbook.

 

 

5.1.16 The excel worksheet should be password protected and opened only after supplying the requisite password. The password should’ be treated as confidential information.

5.1.17 Acceptance Criteria: The results obtained manually and from excel worksheet should be comparable.

5.1.18 All the reports of excel validation should be maintained as history as per relevant SOP.

6.0 RELATED DOCUMENT
6.1 Nil

7.0 REFERENCE

7.1 In House



8.0 FORMATS
8.1 List for the excel worksheet numbers
8.2 Validation Report for excel worksheet
9.0 ABBREVIATIONS
9.1 QC Quality Control
9.2 QA Quality Assurance
9.3 QCA Quality Control Analytical
9.4 SOP Standard Operating Procedure
9.5 A.R. NoAnalytical Reference number

 

SOP for testing of ETP water

sop for Calibration and Maintenance of Laboratory Instruments and Equipment

Disposal of Residual Sample or Left Over Material

sop for for Laboratory Incident

standard operating procedure temperature monitoring

sop for drying of silica gel

sop for operation of infrared moisture balance

sop for preparation of mobile phase

sop for treated RO water

sop for Preparation and Issuance of Analysis protocol standard

sop of placebo and impurity stock solutions

sop for disposal of residual sample  

sop for handling of pharmacopoeial changes

sop for procedure for operation of ultrasonic cleaner

difference between UPLC and HPLC

sop for for Emergency Eyewash and Shower

sop for operation and calibration of total organic carbon analyzers

sop for operation of cobb tester

sop for Operation and calibration of atomic absorption spectrophotometer

sop for Operation and calibration of gas liquid chromatograph

sop for operation of humidity oven

sop for operation and calibration of serological water bath

sop for monitoring of drain trap

sop for destruction of analytical samples after testing and control samples

sop for destruction of used chemicals

Sop for Operation of suction pump

sop for Operation and calibration uv cabinet

sop for Operation and calibration of bulk density apparatus

sop for operation and calibration of shore hardness tester

sop for operation of rub proofness tester

sop for monitoring of purified water

sop for Retesting of packaging materials

sop for Retesting and resampling of raw materials

sop for Control of issuance of record of analysis green sheets

sop for Control of computer passwords

sop for sampling of packaging materials PM

sop for sampling of sterile raw material

sop for sampling of intermediates and finished products

sop for operation and calibration of friability test apparatus

sop for approval and rejection of packaging materials

sop for non conformance of RM PM and finished product

sop for collection storage and disposal of control samples

sop for trend analysis of finished products

sop for Chromatographic practices and system suitability

SOP For Good Laboratory Practices

sop for cleaning and operation of sieve shaker

general specification of packing material cartons

sop for Password for Analytical Instrument and LIMS software

sop for Rounding off numerical analytical results

sop for sampling of bulk and finished product

sop for cleaning of spillage material

sop for Handling of Reference Standard

sop for hplc column maintenance and washing

procedure for sampling and handling of bulk sample

STP for borewell generation point (raw water storage tank)

sop for preparation and standardization of 0.1M Zinc Sulphate

Operation &calibration of analytical balance (dhona)

Operation and Calibration Procedure for Disintegration Test apparatus

sop for preparation and standardization of 1 M Hydrochloric Acid

Preparation and standardization of 0.1 M ceric ammonium sulphate solution

sop for preparation and standardization of 0.05 m iodine solution

validation of volumetric solution 0.1m ammonium thiocyanate

handling of reference standard and preparation of working standard

sop for water sampling and analysis

sop for operation for validation of excel worksheets

sop for laboratory cleaning

sop for stability of volumetric solutions

sop for preparation of raw material in process finish product packing material data sheets

sop for handling of hazardous chemicals

sop for handling of glassware and allocation of identification number

sop for operation cleaning and calibration of bursting strength tester

sop for rounding off the analytical test results

procedure for Analyst Qualification

sop for operation and calibration of dissolution Apparatus

procedure for maintenance of desiccators

sop for for hplc column receipt checking id no and regeneration

safety data sheet for laboratory chemicals

procedure for handling of poisonous chemicals

sop for cleaning of sampling devices

sop for calibration procedure of instruments

sop for specification and standard testing raw material packing material and finished product

procedure for operation and calibration of potentiometric titrator

procedure for operating and calibration of digital hardness tester

procedure for disposal of expired chemicals, reagents and solvents

sop for behavior in quality control department

sop for preparation and standardization 0.1M sodium thiosulphate

sop for preparation and standardization 0.1M Disodium Edetate

preparation and standardization 0.1M Sodium Hydroxide Solution

Preparation and standardization of 0.1M Perchloric acid solution

sop for preparation 0.05M edetate disodium

sop for preparation 0.1M silver nitrate

sop for Operation and Calibration of High Performance Liquid Chromatography

sop for UV & Visible Spectrophotometer

procedure for Cleaning of laboratory glassware

Cleaning of Instrument, Instrument bench and surrounding area of Quality

Safety Precaution in Quality Control Department

Operation & Calibration of Analytical Balance

Calibration of Glassware in Quality Control Department

handling of samples received in Quality Control

Cleaning and Operation of Refrigerator

Operation, Cleaning and Calibration of water bath

Operation & Calibration of Refractometer

Operation and Cleaning of Centrifuge Apparatus

cleaning, operation & calibration of Vernier caliper

Calibration of Fourier Transform Infrared Spectrophotometer (FTIR)

Cleaning and operation of Moisture Analyzer

Cleaning & Operation of Vacuum pump in Quality Control Department

Operation and Calibration of Polarimeter

Cleaning and operation of Magnetic Stirrer

Cleaning Operation and Calibration of Melting Point

Operation Cleaning and Calibration of Muffle Furnance in Quality Control Department

procedure of operation and Cleaning of Sonicator

Operation Cleaning & Calibration of pH meter in Quality Control Department

Entry and Exit in Quality Control Department

 

Exit mobile version