==============Procedure For Sorting and Analyzing monthly Internal Quality Control and External Quality Control Results============

  -Open 10.207.3.240/ 
  -{{:nchsls:c:biochemistry:document:01.png|}}
  -click on LIS. Following Window will be seen. {{:nchsls:c:biochemistry:document:clickonlis.png|}}
  -Log in with your ID and password. Following Window will be seen.  {{:nchsls:c:biochemistry:document:00002.png|}}
  -Now click on QC. Following Window will be seen. {{:nchsls:c:biochemistry:document:1.png|}}
  -Click on LJ Chart. Following Window will be seen. {{:nchsls:c:biochemistry:document:2.png|}}
  -Click on Date wise. Following Window will be seen {{:nchsls:c:biochemistry:document:2.png|}}
  - Name equipment name in box of "QC Equipment" for example XL_1000 or XL_640 or VITROS_3600.
  - Click on BI
  - following window will open.
  - {{:nchsls:c:biochemistry:document:3.png|}}
  - select test from morning QC profile seen as below.
  - {{:nchsls:c:biochemistry:document:4.png|}}
  - click on export.
  - one csv file will form. save it as odt file. for example {{ :nchsls:c:biochemistry:document:creatinine.ods |}}
  - arrange it as shown below.
  - {{:nchsls:c:biochemistry:document:arrange_data_form.png|}}
  - {{:nchsls:c:biochemistry:document:arrange_2.png|}}
  - 
  -  
  -

 
  -
  -Now calculate average, SD and CV of monthly data.For calculating average write in the cell "=AVERAGE( then select the data of which average is to be calculated . similarly for SD write "=STDEV(" and then follow the same as that for average. CV = SD/AVERAGE*100{{{{:nchsls:c:biochemistry:document:3333.png|}}}}


  - From the RIQAS file write method wise , obtained and instrument wise result.
  - {{:nchsls:c:biochemistry:document:4444.png|}}
  - And then write literature value of that lot of QC.