sop for performance verification of calculator and excel sheet validation
1.0 OBJECTIVE
1.1 To lay down a procedure for Performance verification of Calculator and Excel sheet validation.
2.0 SCOPE
2.1 This procedure is applicable for Performance verification of Calculator and Excel sheet validation in Quality Control Department of
3.0 RESPONSIBILITY
3.1 QC Officer or QC Executive
4.0 ACCOUNTABILITY
Head-QC
5.0 PROCEDURE
5.1 Performance verification of Calculator
5.1.1 Before using any new calculator Identification No. shall be allocate and subsequent Performance verification shall be check.
5.1.2 Identification No. for calculator shall be provide by as per Instrument list of the Quality Control laboratory.
5.1.3 Verify for addition in calculator by using numeric key 2 + 2 = 4 ,
5.1.4 Verify for Substraction in calculator by using numeric Key 5-2 = 3,
5.1.5 Verify for Multiplication in calculator by using numeric Key 4 x 6 = 24,
5.1.6 Verify for Division in calculator by using numeric Key 8 / 2 = 4,
5.1.7 Verify for percentage in calculator by using this formula (5 / 20) X 100 = 25%,
5.1.8 Verify for Under root in calculator by using this formula √ 64 = 8
5.1.9 Verify for log in scientific calculator by using standard log table : Log 10 = 1
5.1.10 Verify for Antilog in scientific calculator by using standard log table : Antilog 1 = 10
5.1.11 Note down Performance check of calculator in Annex-I of this SOP.
5.1.12 If the results are found satisfactory after Performance verification, allocate the Identification No. to the calculator and maintain it.
5.1.13 Maintain calculator issuance Record as per Annex-II of this SOP.
5.1.14 If the results are found unsatisfactory after Performance verification the calculator will be rejected and record shall be maintained as per Annex-II of this SOP.
5.1.15 If any unsatisfactory results are given by the calculator during use, it shall be rejected and record shall be maintained as per Annex-II of this SOP.
5.1.16 Re-performance Verification of calculators shall be done at an interval of two year and after each maintenance.
5.2.10 Record the data of Excel sheet validation in Annex-III of this SOP.
5.2.11 If the results of Excel sheet found satisfactory after Performance check, allocate the Identification No. to the computer and maintain it
5.2.12 If the Excel sheet are found unsatisfactory after validation, the Excel sheet will be rejected for calculation.
5.2.13 If Excel sheet given any unsatisfactory results during use, it shall be rejected for calculation.
5.2.14 Re-performance Verification of Excel sheet shall be done at an interval of two year and after each maintenance.
5.2.15 Computer ID shall be generated by I.T. department.
6.0 ABBREVIATION
Sr. No. | Abbreviation used | Full form of abbreviation used |
1.0 | Ltd. | Limited |
2.0 | SOP | Standard Operating Procedure |
3.0 | No. | Number |
4.0 | Sr. | Senior |
5.0 | AGM | Assistant General Manager |
6.0 | Annex | Annexure |
7.0 | QC | Quality Control |
8.0 | QA | Quality Assurance |
9.0 | GM | General Manager |
10.0 | I.T. | Information Technology |
7.0 ATTACHMENTS (ANNEXES)
Annex-I : Calculator Performance Verification Record.
Annex-II : Calculator Issuance/ Rejection Record
Annex-III : Excel sheet validation Record
8.0 REFERENCE
Sr. No. | Reference Title | Author Name | Edition | Page No. |
1 | In house | — | — | — |
ANNEX-II
CALUCULATOR ISSUENCE /REJECTION RECORD
Calculator ID. No. | Issued to | Issued On | Issued By | Received By | Retrieved
By / Date |
Rejected By | Remarks |
Annex-III : Excel sheet validation Record