{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CAL","SPEC","关于本模板"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CAL","index":0,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[32,2,32,4],[32,0,32,1],[33,0,33,1],[33,2,33,4],[34,0,34,4],[31,2,31,4],[31,0,31,1],[22,0,22,1],[22,2,22,4],[23,0,23,1],[23,2,23,4],[24,0,24,4],[26,0,26,4],[25,0,25,4],[29,0,29,4],[30,0,30,4],[28,0,28,4],[27,0,27,4],[0,0,0,4],[13,0,13,1],[17,0,17,1],[7,0,12,0],[15,0,15,1],[16,0,16,1],[14,0,14,1],[21,2,21,4],[19,0,19,1],[20,0,20,1],[21,0,21,1],[1,1,1,4],[2,1,2,4],[1,0,2,0],[3,0,6,0],[18,0,18,1]]}
["移液器校准的计算表格"]
["表格基本信息","表格编号:Labwind-QC-001；版本号：01；制作：XX；审核：XX；批准：XX"]
[null,"批准日期：2017-01-01；生效日期：2017-01-15；下次审核日期：2019-01-01"]
["校准基本信息","水密度\n (g/ml)","使用范围\n（μL）","移液器编号","校准温度\n (℃)"]
[null,{"$f":"VLOOKUP(E5,SPEC!B67:C73,2,0)","v":{"$error":"#N/A"}},null,"Labwind-PT-001"]
[null,"Round Factor","Calibration\nVolume 1 (μL)","Calibration\nVolume 2 (μL)","Calibration\nVolume 3 (μL)"]
[null,{"$f":"VLOOKUP($C$5,SPEC!$C:$E,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$5&\"c1\",SPEC!$C:$D,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$5&\"c2\",SPEC!$C:$D,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$5&\"c3\",SPEC!$C:$D,2,0)","v":{"$error":"#N/A"}}]
["称重值Xi\nWeighing Data\nXi(mg)",1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
["Xi Average (mg)",null,{"$f":"AVERAGE(C8:C13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D8:D13)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E13)","v":{"$error":"#DIV/0!"}}]
["Actual  Volume (μL)",null,{"$f":"ROUND(C14/$B$5,$B$7)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(D14/$B$5,$B$7)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["Accuracy Results (μL)",null,{"$f":"ABS(C7-C15)","v":{"$error":"#N/A"}},{"$f":"ABS(D7-D15)","v":{"$error":"#N/A"}},{"$f":"ABS(E7-E15)","v":{"$error":"#N/A"}}]
["Accuracy Acceptance Criteria(μL)",null,{"$f":"VLOOKUP($C$5&\"C1\",SPEC!$C:$E,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$5&\"C2\",SPEC!$C:$E,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$5&\"C3\",SPEC!$C:$E,3,0)","v":{"$error":"#N/A"}}]
["Accuracy Conclusion  (Pass or Fail)",null,{"$f":"IF(COUNTIF(C5:E13,\"\")>0,\"\",IF((C17-C16)>=0,\"Pass\",\"Fail\"))","v":""},{"$f":"IF(COUNTIF(C5:E13,\"\")>0,\"\",IF((D17-D16)>=0,\"Pass\",\"Fail\"))","v":""},{"$f":"IF(COUNTIF(C5:E13,\"\")>0,\"\", IF((E17-E16)>=0,\"Pass\",\"Fail\"))","v":""}]
["Repeatability Results (RSD%)",null,{"$f":"ROUND(100*STDEV(C8:C13)/C14,1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(100*STDEV(D8:D13)/D14,1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(100*STDEV(E8:E13)/E14,1)","v":{"$error":"#DIV/0!"}}]
["Repeatability Acceptance Criteria(RSD%)",null,{"$f":"VLOOKUP($C$5&\"C1\",SPEC!$C:$F,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$5&\"C2\",SPEC!$C:$F,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($C$5&\"C3\",SPEC!$C:$F,4,0)","v":{"$error":"#N/A"}}]
["Repeatability Conclusion(Pass or Fail)",null,{"$f":"IF(COUNTIF(C5:E13,\"\")>0,\"\",IF((C20-C19)>=0,\"Pass\",\"Fail\"))","v":""},{"$f":"IF(COUNTIF(C5:E13,\"\")>0,\"\",IF((D20-D19)>=0,\"Pass\",\"Fail\"))","v":""},{"$f":"IF(COUNTIF(C5:E13,\"\")>0,\"\",IF((E20-E19)>=0,\"Pass\",\"Fail\"))","v":""}]
["Calibration Conclusion (Pass or Fail)",null,{"$f":"IF(COUNTIF(C5:E13,\"\")>0,\"\",IF(COUNTIF(C18:E21,\"Pass\")=6,\"Pass\",\"Fail\"))","v":""}]
["Last Saved By/Date:",null,"DESK-P1A59J9~anxiao zheng~2018/3/23~17:16:55"]
["Last Printed By/Date:",null,"DESK-P1A59J9~anxiao zheng~2018/3/20~15:12:38"]
["The formula used in this spreadsheet"]
["Actual volume (μL)=Round (Xi Average (mg)/Water Density (ρ, g/cm3), B7)"]
["Accuracy Results (μL)=ABS(Calibration Volume (μL)-Actural Volume(μL))"]
["Accuracy Conclusion  (Pass or Fail)=\nIF(COUNTIF(C5:E13,\"\")>0,\"\",IF((Accuracy Acceptance Criteria-Accuracy Results)>=0,\"Pass\",\"Fail\"))"]
["Repeatability Results (RSD%)=ROUND(100*STDEV Xi/Xi Average (mg),1)"]
["Repeatability Conclusion  (Pass or Fail)=\nIF(COUNTIF(C5:E13,\"\")>0,\"\",IF((Repeatibility Acceptance Criteria-Repeatibility Results)>=0,\"Pass\",\"Fail\"))"]
["Calibration Conclusion (Pass or Fail)=\nIF(COUNTIF(C5:E13,\"\")>0,\"\",IF(COUNTIF(C18:E21,\"Pass\")=6,\"Pass\",\"Fail\"))"]
["Round Factor (B7)=Vlookup \"SPEC\" ",null,"Calibration Volume=Vlookup \"SPEC\""]
["Water Density (ρ, g/cm3)= Vlookup \"SPEC\"",null,"Accuracy Acceptance Criterial = Vlookup \"SPEC\""]
["Xi Average (mg)= Average (Xi)",null,"Repeatability Acceptance Criterial = Vlookup \"SPEC\""]

{"sheet":"SPEC","index":1,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":false,"merged":[[46,1,46,3],[1,0,1,5],[64,1,64,2]]}
[]
["Table 1（不同使用范围对应的校准体积及可接受标准）"]
["标识范围（μL）\nNominal Range","使用范围（μL）\nUsing Range","Marker of calibration volume","校准体积（μL）\nCalibration Volume","准确性接受标准\nAccuracy Acceptance Criteria (μL)","重复性接受标准≤（%）\nRepeatability Acceptance Criteria"]
["0.100-2.000","1.000-2.000",{"$f":"B4&\"C1\"","v":"1.000-2.000C1"},1,0.2,10]
["0.100-2.000","1.000-2.000",{"$f":"B5&\"C2\"","v":"1.000-2.000C2"},1.5,0.24,8]
["0.100-2.000","1.000-2.000",{"$f":"B6&\"C3\"","v":"1.000-2.000C3"},2,0.24,6]
["0.100-2.500","1.000-2.500",{"$f":"B7&\"C1\"","v":"1.000-2.500C1"},1,0.2,10]
["0.100-2.500","1.000-2.500",{"$f":"B8&\"C2\"","v":"1.000-2.500C2"},2,0.3,8]
["0.100-2.500","1.000-2.500",{"$f":"B9&\"C3\"","v":"1.000-2.500C3"},2.5,0.3,6]
["0.50-10.00","2.00-10.00",{"$f":"B10&\"C1\"","v":"2.00-10.00C1"},2,0.2,5]
["0.50-10.00","2.00-10.00",{"$f":"B11&\"C2\"","v":"2.00-10.00C2"},5,0.2,2]
["0.50-10.00","2.00-10.00",{"$f":"B12&\"C3\"","v":"2.00-10.00C3"},10,0.2,1]
["2.00-20.00","5.00-20.00",{"$f":"B13&\"C1\"","v":"5.00-20.00C1"},5,0.4,4]
["2.00-20.00","5.00-20.00",{"$f":"B14&\"C2\"","v":"5.00-20.00C2"},10,0.4,2]
["2.00-20.00","5.00-20.00",{"$f":"B15&\"C3\"","v":"5.00-20.00C3"},20,0.4,1]
["5.00-50.00","10.00-50.00",{"$f":"B16&\"C1\"","v":"10.00-50.00C1"},10,1,5]
["5.00-50.00","10.00-50.00",{"$f":"B17&\"C2\"","v":"10.00-50.00C2"},25,1,2]
["5.00-50.00","10.00-50.00",{"$f":"B18&\"C3\"","v":"10.00-50.00C3"},50,1,1]
["10.0-100.0","20.0-100.0",{"$f":"B19&\"C1\"","v":"20.0-100.0C1"},20,1.5,3.8]
["10.0-100.0","20.0-100.0",{"$f":"B20&\"C2\"","v":"20.0-100.0C2"},50,1.5,1.5]
["10.0-100.0","20.0-100.0",{"$f":"B21&\"C3\"","v":"20.0-100.0C3"},100,2,1]
["20.0-200.0","50.0-200.0",{"$f":"B22&\"C1\"","v":"50.0-200.0C1"},50,2,2]
["20.0-200.0","50.0-200.0",{"$f":"B23&\"C2\"","v":"50.0-200.0C2"},100,2,1]
["20.0-200.0","50.0-200.0",{"$f":"B24&\"C3\"","v":"50.0-200.0C3"},200,3,0.8]
["30.0-300.0","50.0-300.0",{"$f":"B25&\"C1\"","v":"50.0-300.0C1"},50,3,3]
["30.0-300.0","50.0-300.0",{"$f":"B26&\"C2\"","v":"50.0-300.0C2"},150,3,1]
["30.0-300.0","50.0-300.0",{"$f":"B27&\"C3\"","v":"50.0-300.0C3"},300,4.5,0.8]
["100-1000","200-1000",{"$f":"B28&\"C1\"","v":"200-1000C1"},200,5,1.3]
["100-1000","200-1000",{"$f":"B29&\"C2\"","v":"200-1000C2"},500,5,0.5]
["100-1000","200-1000",{"$f":"B30&\"C3\"","v":"200-1000C3"},1000,10,0.5]
["100-1200","200-1200",{"$f":"B31&\"C1\"","v":"200-1200C1"},200,6,1.5]
["100-1200","200-1200",{"$f":"B32&\"C2\"","v":"200-1200C2"},600,6,0.5]
["100-1200","200-1200",{"$f":"B33&\"C3\"","v":"200-1200C3"},1200,12,0.5]
["500-5000","1000-5000",{"$f":"B34&\"C1\"","v":"1000-5000C1"},1000,13,0.7]
["500-5000","1000-5000",{"$f":"B35&\"C2\"","v":"1000-5000C2"},2500,13,0.3]
["500-5000","1000-5000",{"$f":"B36&\"C3\"","v":"1000-5000C3"},5000,30,0.3]
["1000-10000","2000-10000",{"$f":"B37&\"C1\"","v":"2000-10000C1"},1000,25,0.7]
["1000-10000","2000-10000",{"$f":"B38&\"C2\"","v":"2000-10000C2"},5000,25,0.3]
["1000-10000","2000-10000",{"$f":"B39&\"C3\"","v":"2000-10000C3"},10000,60,0.3]
["2500-25000","5000-25000",{"$f":"B40&\"C1\"","v":"5000-25000C1"},5000,50,0.5]
["2500-25000","5000-25000",{"$f":"B41&\"C2\"","v":"5000-25000C2"},10000,50,0.3]
["2500-25000","5000-25000",{"$f":"B42&\"C3\"","v":"5000-25000C3"},25000,150,0.3]
["5000-50000","10000-50000",{"$f":"B43&\"C1\"","v":"10000-50000C1"},10000,125,0.7]
["5000-50000","10000-50000",{"$f":"B44&\"C2\"","v":"10000-50000C2"},25000,125,0.3]
["5000-50000","10000-50000",{"$f":"B45&\"C3\"","v":"10000-50000C3"},50000,300,0.3]
[]
[null,"Table 2（不同使用范围对应的小数点后有效数值位数）"]
[null,"Using Range (μL)","Marker of calibration volume","Round marker of Accuracy"]
[null,"1.000-2.000","1.000-2.000",3]
[null,"1.000-2.500","1.000-2.500",3]
[null,"2.00-10.00","2.00-10.00",2]
[null,"5.00-20.00","5.00-20.00",2]
[null,"10.00-50.00","10.00-50.00",2]
[null,"20.0-100.0","20.0-100.0",1]
[null,"50.0-200.0","50.0-200.0",1]
[null,"50.0-300.0","50.0-300.0",1]
[null,"200-1000","200-1000",0]
[null,"200-1200","200-1200",0]
[null,"1000-5000","1000-5000",0]
[null,"2000-10000","2000-10000",0]
[null,"5000-25000","5000-25000",0]
[null,"10000-50000","10000-50000",0]
[]
[]
[null,"Table3（水密度/温度对应表）"]
[null,"温度（℃）","水密度（g/ml）"]
[null,20,0.99820299999999995]
[null,21,0.99799199999999999]
[null,22,0.99777000000000005]
[null,23,0.99753800000000004]
[null,24,0.99729599999999996]
[null,25,0.99704400000000004]

{"sheet":"关于本模板","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"本模板由武汉点风信息科技有限公司制作"]
[null,null,"www.labwind.com"]
[]
[null,"有何问题或建议请联系:",null,null,"allen.zheng@labwind.com"]