{"text_format":"5","workbook":"xlsx","n_sheets":4,"sheets":["검교정방법","양식","양식 (2)","양식 (3)"],"props":{"creator":"admin","last_modified_by":"admin"},"not_rendered":{"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"검교정방법","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[11,0,11,4],[12,0,12,4],[22,0,22,4],[23,0,23,4]]}
["자동피펫 자체교정 관련"]
["    (관련규격 : ISO 8655)"]
["     Eppendorf SOP 를 참고하여 작성하였으며, 각 제조사에 따라 다를 수 있음."]
["1. 최소요구 전자저울 사양"]
[null,"시험 용량","해독도 (mg)"]
[null,"1~10 uL",1E-3]
[null,">10~100 uL",0.01]
[null,">100 uL ~ 10 mL",0.1]
[null,">10 ~ 200 mL",1]
[]
["2. 시험환경 "]
["- 15~30℃, RH 50% 이상"]
["- Test Liquid : DI water"]
[]
["3. 평가항목"]
[" - 시스템 에러","(정확도)"]
["- 랜덤 에러","(정밀도)"]
[]
["4. 에러 한계"]
[]
[]
["5. 평가방법"]
["- 피펫의 10, 50, 100 % 용량(설정값)에 대하여 각각 3회 이상 테스트 한다."]
["- 각 용량별 테스트 값에 온도 보정 실시"]
["- 평균값 및 표준편차 산출"]
["- 시스템에러(%) = (평균값- 설정값)/설정값×100"]
["- 랜덤에러(%) = (표준편차/평균값)×100"]
["- 시스템에러 와 랜덤에러 값을 위의 표와 비교하여 범위 안에 있는지 확인"]

{"sheet":"양식","index":1,"n_rows":35,"n_cols":17,"rows_kept":35,"merged":[[0,2,0,4],[3,2,3,6],[4,2,4,6]]}
[null,"사용방법 : ","노란색 셀에만 데이터 입력",{"$nulls":7},"Factor Z for DI water",{"$nulls":3},"Error Limits ISO 8655"]
[null,null,"나머지는 자동계산",{"$nulls":8},"Air Pressure(kPa)",{"$nulls":4},"%"]
[{"$nulls":10},"Temp.(℃)",101.3,null,null,"Volume(uL)","Sys Err","Ran Err"]
[null,"시험일자 ","2016.2.1(월)",{"$nulls":7},15,{"v":1.002,"d":"1.0020"},null,null,1,5,5]
[null,"피펫번호","일련번호 또는 자체관리번호 기입",{"$nulls":7},15.5,{"v":1.002,"d":"1.0020"},null,null,2,4,2]
[null,"피펫용량",1000,"uL",{"$nulls":6},16,1.0021,null,null,5,2.5,1.5]
[null,"Temp ",23,"℃","→","Z :",{"$f":"VLOOKUP(C7,$K$4:$L$34,2)","v":1.0035},{"$nulls":3},16.5,1.0022,null,null,10,1.2,0.8]
[{"$nulls":10},17,1.0023,null,null,20,1,0.5]
[{"$nulls":10},17.5,1.0024,null,null,50,1,0.4]
[null,"(예시)",{"$nulls":5},"(Unit : ug)",null,null,18,1.0025,null,null,100,0.8,0.3]
[null,null,10,"%",50,"%",100,"%",null,null,18.5,1.0026,null,null,200,0.8,0.3]
[null,null,{"$f":"C6*0.1","v":100},"uL",{"$f":"C6*0.5","v":500},"uL",{"$f":"C6","v":1000},"uL",null,null,19,1.0027,null,null,500,0.8,0.3]
[null,null,"측정값","측정값*Z","측정값","측정값*Z","측정값","측정값*Z",null,null,19.5,1.0028,null,null,1000,0.8,0.3]
[null,"Test 1",100,{"$f":"C14*$G$7","v":{"v":100.35000000000001,"d":"100.4"}},500,{"$f":"E14*$G$7","v":{"v":501.75000000000006,"d":"501.8"}},1000,{"$f":"G14*$G$7","v":{"v":1003.5000000000001,"d":"1003.5"}},null,null,20,1.0029,null,null,2000,0.8,0.3]
[null,"Test 2",90,{"v":90.31500000000001,"d":"90.3"},490,{"$f":"E15*$G$7","v":{"v":491.71500000000003,"d":"491.7"}},1010,{"$f":"G15*$G$7","v":{"v":1013.5350000000001,"d":"1013.5"}},null,null,20.5,{"v":1.003,"d":"1.0030"},null,null,5000,0.8,0.3]
[null,"Test 3",90,{"v":90.31500000000001,"d":"90.3"},490,{"$f":"E16*$G$7","v":{"v":491.71500000000003,"d":"491.7"}},1000,{"$f":"G16*$G$7","v":{"v":1003.5000000000001,"d":"1003.5"}},null,null,21,1.0031,null,null,10000,0.6,0.3]
[null,"Test 4",90,{"v":90.31500000000001,"d":"90.3"},500,{"$f":"E17*$G$7","v":{"v":501.75000000000006,"d":"501.8"}},1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,21.5,1.0032]
[null,"Test 5",90,{"v":90.31500000000001,"d":"90.3"},500,{"$f":"E18*$G$7","v":{"v":501.75000000000006,"d":"501.8"}},1000,{"v":1003.5000000000001,"d":"1003.5"},null,null,22,1.0033]
[null,"Test 6",90,{"v":90.31500000000001,"d":"90.3"},null,null,1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,22.5,1.0034]
[null,"Test 7",90,{"v":90.31500000000001,"d":"90.3"},null,null,1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,23,1.0035]
[null,"Test 8",90,{"v":90.31500000000001,"d":"90.3"},null,null,1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,23.5,1.0036]
[null,"Test 9",90,{"v":90.31500000000001,"d":"90.3"},{"$nulls":6},24,1.0038]
[null,"Test 10",90,{"v":90.31500000000001,"d":"90.3"},{"$nulls":6},24.5,1.0039]
[null,"Avg.",null,{"$f":"AVERAGE(D14:D23)","v":{"v":91.31850000000003,"d":"91.3"}},null,{"$f":"AVERAGE(F14:F23)","v":{"v":497.73600000000005,"d":"497.7"}},null,{"$f":"AVERAGE(H14:H23)","v":{"v":1009.771875,"d":"1009.8"}},null,null,25,{"v":1.004,"d":"1.0040"}]
[null,"S.D.",null,{"$f":"_xlfn.STDEV.S(D14:D23)","v":{"v":3.173345631978967,"d":"3.2"}},null,{"$f":"_xlfn.STDEV.S(F14:F23)","v":{"v":5.496395864564356,"d":"5.5"}},null,{"$f":"_xlfn.STDEV.S(H14:H23)","v":{"v":5.193605916000377,"d":"5.2"}},null,null,25.5,1.0041]
[{"$nulls":10},26,1.0043]
[null,"정확도",{"$nulls":8},26.5,1.0044]
[null,"System Error(%)",null,{"$f":"(D24-C12)/C12*100","v":{"v":-8.681499999999971,"d":"-8.68"}},null,{"$f":"(F24-E12)/E12*100","v":{"v":-0.4527999999999906,"d":"-0.45"}},null,{"$f":"(H24-G12)/G12*100","v":{"v":0.9771875000000023,"d":"0.98"}},null,null,27,1.0045]
[null,"S.E. 적합범위",null,{"$f":"VLOOKUP(C12,$O$4:$Q$16,2)","v":0.8},null,{"$f":"VLOOKUP(E12,$O$4:$Q$16,2)","v":0.8},null,{"$f":"VLOOKUP(G12,$O$4:$Q$16,2)","v":0.8},null,null,27.5,1.0047]
[null,"적합여부",null,{"$f":"IF(D29>=ABS(D28),\"적합\", \"부적합\")","v":"부적합"},null,{"$f":"IF(F29>=ABS(F28),\"적합\", \"부적합\")","v":"적합"},null,{"$f":"IF(H29>=ABS(H28),\"적합\", \"부적합\")","v":"부적합"},null,null,28,1.0048]
[{"$nulls":10},28.5,{"v":1.005,"d":"1.0050"}]
[null,"정밀도",{"$nulls":8},29,1.0051]
[null,"Random Error(%)",null,{"$f":"(D25/D24)*100","v":{"v":3.4750303957894246,"d":"3.48"}},null,{"$f":"(F25/F24)*100","v":{"v":1.1042793498088055,"d":"1.10"}},null,{"$f":"(H25/H24)*100","v":{"v":0.5143345783918152,"d":"0.51"}},null,null,29.5,1.0052]
[null,"R.E. 적합범위",null,{"$f":"VLOOKUP(C12,$O$4:$Q$16,3)","v":0.3},null,{"$f":"VLOOKUP(E12,$O$4:$Q$16,3)","v":0.3},null,{"$f":"VLOOKUP(G12,$O$4:$Q$16,3)","v":0.3},null,null,30,1.0054]
[null,"적합여부",null,{"$f":"IF(D34>=ABS(D33),\"적합\", \"부적합\")","v":"부적합"},null,{"$f":"IF(F34>=ABS(F33),\"적합\", \"부적합\")","v":"부적합"},null,{"$f":"IF(H34>=ABS(H33),\"적합\", \"부적합\")","v":"부적합"}]

{"sheet":"양식 (2)","index":2,"n_rows":35,"n_cols":17,"rows_kept":35,"merged":[[0,2,0,4],[3,2,3,6],[4,2,4,6]]}
[null,"사용방법 : ","노란색 셀에만 데이터 입력",{"$nulls":7},"Factor Z for DI water",{"$nulls":3},"Error Limits ISO 8655"]
[null,null,"나머지는 자동계산",{"$nulls":8},"Air Pressure(kPa)",{"$nulls":4},"%"]
[{"$nulls":10},"Temp.(℃)",101.3,null,null,"Volume(uL)","Sys Err","Ran Err"]
[null,"시험일자 ","2016.2.1(월)",{"$nulls":7},15,{"v":1.002,"d":"1.0020"},null,null,1,5,5]
[null,"피펫번호","일련번호 또는 자체관리번호 기입",{"$nulls":7},15.5,{"v":1.002,"d":"1.0020"},null,null,2,4,2]
[null,"피펫용량",1000,"uL",{"$nulls":6},16,1.0021,null,null,5,2.5,1.5]
[null,"Temp ",23,"℃","→","Z :",{"$f":"VLOOKUP(C7,$K$4:$L$34,2)","v":1.0035},{"$nulls":3},16.5,1.0022,null,null,10,1.2,0.8]
[{"$nulls":10},17,1.0023,null,null,20,1,0.5]
[{"$nulls":10},17.5,1.0024,null,null,50,1,0.4]
[null,"(예시)",{"$nulls":5},"(Unit : ug)",null,null,18,1.0025,null,null,100,0.8,0.3]
[null,null,10,"%",50,"%",100,"%",null,null,18.5,1.0026,null,null,200,0.8,0.3]
[null,null,{"$f":"C6*0.1","v":100},"uL",{"$f":"C6*0.5","v":500},"uL",{"$f":"C6","v":1000},"uL",null,null,19,1.0027,null,null,500,0.8,0.3]
[null,null,"측정값","측정값*Z","측정값","측정값*Z","측정값","측정값*Z",null,null,19.5,1.0028,null,null,1000,0.8,0.3]
[null,"Test 1",100,{"$f":"C14*$G$7","v":{"v":100.35000000000001,"d":"100.4"}},501,{"$f":"E14*$G$7","v":{"v":502.75350000000003,"d":"502.8"}},1000,{"$f":"G14*$G$7","v":{"v":1003.5000000000001,"d":"1003.5"}},null,null,20,1.0029,null,null,2000,0.8,0.3]
[null,"Test 2",101,{"$f":"C15*$G$7","v":{"v":101.35350000000001,"d":"101.4"}},498,{"v":499.74300000000005,"d":"499.7"},1010,{"$f":"G15*$G$7","v":{"v":1013.5350000000001,"d":"1013.5"}},null,null,20.5,{"v":1.003,"d":"1.0030"},null,null,5000,0.8,0.3]
[null,"Test 3",100,{"$f":"C16*$G$7","v":{"v":100.35000000000001,"d":"100.4"}},499,{"v":500.7465,"d":"500.7"},1000,{"v":1003.5000000000001,"d":"1003.5"},null,null,21,1.0031,null,null,10000,0.6,0.3]
[null,"Test 4",null,null,500,{"v":501.75000000000006,"d":"501.8"},1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,21.5,1.0032]
[null,"Test 5",null,null,499,{"v":500.7465,"d":"500.7"},1000,{"v":1003.5000000000001,"d":"1003.5"},null,null,22,1.0033]
[null,"Test 6",null,null,500,{"v":501.75000000000006,"d":"501.8"},1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,22.5,1.0034]
[null,"Test 7",{"$nulls":4},1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,23,1.0035]
[null,"Test 8",{"$nulls":4},1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,23.5,1.0036]
[null,"Test 9",{"$nulls":8},24,1.0038]
[null,"Test 10",{"$nulls":8},24.5,1.0039]
[null,"Avg.",null,{"$f":"AVERAGE(D14:D23)","v":{"v":100.68450000000001,"d":"100.7"}},null,{"$f":"AVERAGE(F14:F23)","v":{"v":501.24825000000004,"d":"501.2"}},null,{"$f":"AVERAGE(H14:H23)","v":{"v":1009.771875,"d":"1009.8"}},null,null,25,{"v":1.004,"d":"1.0040"}]
[null,"S.D.",null,{"$f":"_xlfn.STDEV.S(D14:D23)","v":{"v":0.5793709951317909,"d":"0.6"}},null,{"$f":"_xlfn.STDEV.S(F14:F23)","v":{"v":1.052479679138747,"d":"1.1"}},null,{"$f":"_xlfn.STDEV.S(H14:H23)","v":{"v":5.193605916000377,"d":"5.2"}},null,null,25.5,1.0041]
[{"$nulls":10},26,1.0043]
[null,"정확도",{"$nulls":8},26.5,1.0044]
[null,"System Error(%)",null,{"$f":"(D24-C12)/C12*100","v":{"v":0.6845000000000141,"d":"0.68"}},null,{"$f":"(F24-E12)/E12*100","v":{"v":0.24965000000000828,"d":"0.25"}},null,{"$f":"(H24-G12)/G12*100","v":{"v":0.9771875000000023,"d":"0.98"}},null,null,27,1.0045]
[null,"S.E. 적합범위",null,{"$f":"VLOOKUP(C12,$O$4:$Q$16,2)","v":0.8},null,{"$f":"VLOOKUP(E12,$O$4:$Q$16,2)","v":0.8},null,{"$f":"VLOOKUP(G12,$O$4:$Q$16,2)","v":0.8},null,null,27.5,1.0047]
[null,"적합여부",null,{"$f":"IF(D29>=ABS(D28),\"적합\", \"부적합\")","v":"적합"},null,{"$f":"IF(F29>=ABS(F28),\"적합\", \"부적합\")","v":"적합"},null,{"$f":"IF(H29>=ABS(H28),\"적합\", \"부적합\")","v":"부적합"},null,null,28,1.0048]
[{"$nulls":10},28.5,{"v":1.005,"d":"1.0050"}]
[null,"정밀도",{"$nulls":8},29,1.0051]
[null,"Random Error(%)",null,{"$f":"(D25/D24)*100","v":{"v":0.575432161983017,"d":"0.58"}},null,{"$f":"(F25/F24)*100","v":{"v":0.20997174137540567,"d":"0.21"}},null,{"$f":"(H25/H24)*100","v":{"v":0.5143345783918152,"d":"0.51"}},null,null,29.5,1.0052]
[null,"R.E. 적합범위",null,{"$f":"VLOOKUP(C12,$O$4:$Q$16,3)","v":0.3},null,{"$f":"VLOOKUP(E12,$O$4:$Q$16,3)","v":0.3},null,{"$f":"VLOOKUP(G12,$O$4:$Q$16,3)","v":0.3},null,null,30,1.0054]
[null,"적합여부",null,{"$f":"IF(D34>=ABS(D33),\"적합\", \"부적합\")","v":"부적합"},null,{"$f":"IF(F34>=ABS(F33),\"적합\", \"부적합\")","v":"적합"},null,{"$f":"IF(H34>=ABS(H33),\"적합\", \"부적합\")","v":"부적합"}]

{"sheet":"양식 (3)","index":3,"n_rows":35,"n_cols":17,"rows_kept":35,"merged":[[0,2,0,4],[3,2,3,6],[4,2,4,6]]}
[null,"사용방법 : ","노란색 셀에만 데이터 입력",{"$nulls":7},"Factor Z for DI water",{"$nulls":3},"Error Limits ISO 8655"]
[null,null,"나머지는 자동계산",{"$nulls":8},"Air Pressure(kPa)",{"$nulls":4},"%"]
[{"$nulls":10},"Temp.(℃)",101.3,null,null,"Volume(uL)","Sys Err","Ran Err"]
[null,"시험일자 ","2016.2.1(월)",{"$nulls":7},15,{"v":1.002,"d":"1.0020"},null,null,1,5,5]
[null,"피펫번호","일련번호 또는 자체관리번호 기입",{"$nulls":7},15.5,{"v":1.002,"d":"1.0020"},null,null,2,4,2]
[null,"피펫용량",1000,"uL",{"$nulls":6},16,1.0021,null,null,5,2.5,1.5]
[null,"Temp ",23,"℃","→","Z :",{"$f":"VLOOKUP(C7,$K$4:$L$34,2)","v":1.0035},{"$nulls":3},16.5,1.0022,null,null,10,1.2,0.8]
[{"$nulls":10},17,1.0023,null,null,20,1,0.5]
[{"$nulls":10},17.5,1.0024,null,null,50,1,0.4]
[null,"(예시)",{"$nulls":5},"(Unit : ug)",null,null,18,1.0025,null,null,100,0.8,0.3]
[null,null,10,"%",50,"%",100,"%",null,null,18.5,1.0026,null,null,200,0.8,0.3]
[null,null,{"$f":"C6*0.1","v":100},"uL",{"$f":"C6*0.5","v":500},"uL",{"$f":"C6","v":1000},"uL",null,null,19,1.0027,null,null,500,0.8,0.3]
[null,null,"측정값","측정값*Z","측정값","측정값*Z","측정값","측정값*Z",null,null,19.5,1.0028,null,null,1000,0.8,0.3]
[null,"Test 1",{"v":0.1,"d":"0"},{"$f":"C14*$G$7","v":{"v":0.10035000000000001,"d":"0.1"}},{"v":0.501,"d":"0.5010"},{"$f":"E14*$G$7","v":{"v":0.5027535000000001,"d":"0.5028"}},1000,{"$f":"G14*$G$7","v":{"v":1003.5000000000001,"d":"1003.5"}},1000,null,20,1.0029,null,null,2000,0.8,0.3]
[null,"Test 2",{"v":0.101,"d":"0"},{"$f":"C15*$G$7","v":{"v":0.10135350000000001,"d":"0.1"}},{"v":0.498,"d":"0.4980"},{"v":0.49974300000000005,"d":"0.4997"},1010,{"$f":"G15*$G$7","v":{"v":1013.5350000000001,"d":"1013.5"}},null,null,20.5,{"v":1.003,"d":"1.0030"},null,null,5000,0.8,0.3]
[null,"Test 3",{"v":0.1,"d":"0"},{"$f":"C16*$G$7","v":{"v":0.10035000000000001,"d":"0.1"}},{"v":0.499,"d":"0.4990"},{"v":0.5007465,"d":"0.5007"},1000,{"v":1003.5000000000001,"d":"1003.5"},null,null,21,1.0031,null,null,10000,0.6,0.3]
[null,"Test 4",null,null,{"v":0.5,"d":"0.5000"},{"v":0.50175,"d":"0.5018"},1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,21.5,1.0032]
[null,"Test 5",null,null,{"v":0.499,"d":"0.4990"},{"v":0.5007465,"d":"0.5007"},1000,{"v":1003.5000000000001,"d":"1003.5"},null,null,22,1.0033]
[null,"Test 6",null,null,{"v":0.5,"d":"0.5000"},{"v":0.50175,"d":"0.5018"},1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,22.5,1.0034]
[null,"Test 7",{"$nulls":4},1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,23,1.0035]
[null,"Test 8",{"$nulls":4},1010,{"v":1013.5350000000001,"d":"1013.5"},null,null,23.5,1.0036]
[null,"Test 9",{"$nulls":8},24,1.0038]
[null,"Test 10",{"$nulls":8},24.5,1.0039]
[null,"Avg.",null,{"$f":"AVERAGE(D14:D23)","v":{"v":0.10068450000000001,"d":"0.1"}},null,{"$f":"AVERAGE(F14:F23)","v":{"v":0.5012482500000001,"d":"0.5012"}},null,{"$f":"AVERAGE(H14:H23)","v":{"v":1009.771875,"d":"1009.8"}},null,null,25,{"v":1.004,"d":"1.0040"}]
[null,"S.D.",null,{"$f":"_xlfn.STDEV.S(D14:D23)","v":{"v":0.000579370995131792,"d":"0.0"}},null,{"$f":"_xlfn.STDEV.S(F14:F23)","v":{"v":1.0524796791387635E-3,"d":"0.0011"}},null,{"$f":"_xlfn.STDEV.S(H14:H23)","v":{"v":5.193605916000377,"d":"5.2"}},null,null,25.5,1.0041]
[{"$nulls":10},26,1.0043]
[null,"정확도",{"$nulls":8},26.5,1.0044]
[null,"System Error(%)",null,{"$f":"(D24-C12)/C12*100","v":{"v":-99.8993155,"d":"-99.90"}},null,{"$f":"(F24-E12/1000)/(E12/1000)*100","v":{"v":0.24965000000001236,"d":"0.25"}},null,{"$f":"(H24-G12)/G12*100","v":{"v":0.9771875000000023,"d":"0.98"}},null,null,27,1.0045]
[null,"S.E. 적합범위",null,{"$f":"VLOOKUP(C12,$O$4:$Q$16,2)","v":0.8},null,{"$f":"VLOOKUP(E12,$O$4:$Q$16,2)","v":0.8},null,{"$f":"VLOOKUP(G12,$O$4:$Q$16,2)","v":0.8},null,null,27.5,1.0047]
[null,"적합여부",null,{"$f":"IF(D29>=ABS(D28),\"적합\", \"부적합\")","v":"부적합"},null,{"$f":"IF(F29>=ABS(F28),\"적합\", \"부적합\")","v":"적합"},null,{"$f":"IF(H29>=ABS(H28),\"적합\", \"부적합\")","v":"부적합"},null,null,28,1.0048]
[{"$nulls":10},28.5,{"v":1.005,"d":"1.0050"}]
[null,"정밀도",{"$nulls":8},29,1.0051]
[null,"Random Error(%)",null,{"$f":"(D25/D24)*100","v":{"v":0.5754321619830182,"d":"0.58"}},null,{"$f":"(F25/F24)*100","v":{"v":0.20997174137540897,"d":"0.21"}},null,{"$f":"(H25/H24)*100","v":{"v":0.5143345783918152,"d":"0.51"}},null,null,29.5,1.0052]
[null,"R.E. 적합범위",null,{"$f":"VLOOKUP(C12,$O$4:$Q$16,3)","v":0.3},null,{"$f":"VLOOKUP(E12,$O$4:$Q$16,3)","v":0.3},null,{"$f":"VLOOKUP(G12,$O$4:$Q$16,3)","v":0.3},null,null,30,1.0054]
[null,"적합여부",null,{"$f":"IF(D34>=ABS(D33),\"적합\", \"부적합\")","v":"부적합"},null,{"$f":"IF(F34>=ABS(F33),\"적합\", \"부적합\")","v":"적합"},null,{"$f":"IF(H34>=ABS(H33),\"적합\", \"부적합\")","v":"부적합"}]