{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Info","Kvalitetskrav","Bias SLP","Bias 735vs835","Bias mellom instrument","CV Bio","CV -735vs835"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":4,"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":"Info","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Kvalitetskrav","index":1,"n_rows":54,"n_cols":55,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,49,2,51],[2,52,2,54],[1,35,1,54],[28,15,28,18],[28,1,29,2],[28,3,29,5],[28,6,29,9],[28,10,28,14],[1,0,3,0],[1,1,2,2],[1,6,2,9],[2,38,2,47],[1,3,2,5],[1,15,1,18],[1,19,2,24],[1,10,1,14],[1,25,2,34]]}
[]
["Analytt","Biological variation",null,"Referanseområde Kofstad -95",null,null,"SLP nr 4/2011",null,null,null,"Mål for BIAS %",null,null,null,null,"Mål for IMPRESISJON %",null,null,null,"Innkjøring av Leverandør (Verst tilfelle…)",null,null,null,null,null,"SLP resultat 835 (MB)",null,null,null,null,null,null,null,null,null,"Våre resultat"]
[null,null,null,null,null,null,null,null,null,null,"optimalt","ønskelig B(%)","Minimum","Mellom instrument",null,"optimalt","ønskelig I(%)","minimum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ABL PLAB",null,null,null,null,null,null,null,null,null,null,"ABL MB",null,null,"ABL hov"]
[null,"CVw","CVb","Lav","Høy","Benevning","Mean metodegruppe\n735","Mean\n835","Grense %","Bio krav\n2,33(0,5*CVw)+0,25√(CVw^2+CVb^2)","0,125*√(CVw2+CVb2)","0,250*√(CVw2+CVb2)","0,375*√(CVw2+CVb2)","CVw  / 3","Ref/16 %","0,25*CVw","0,50*CVw","0,75*CVw","CVt Basert på Ref\ntillatt feil (1/4*refintervall/mean intervall)*100= CVa*2\n→CVa=(1/4*refintervall/mean intervall)*50","CVwd","CVbd","Måloppnåelse Impresisjon (CVwd) bio","Måloppnåelse Impresisjon (CVbd) bio","Måloppnåelse Impresisjon (Ref) (CVwd)","Måloppnåelse Impresisjon (Ref) (CVbd)","SLP\nvårt resultat\n735","SLP\nvårt resultat\n735\nBIAS%","Krav i forhold til SLP krav","Krav i forhold til Bio krav\n2,33(0,5*CVw)+0,25√(CVw^2+CVb^2)","Vårt resultat","BIAS% i forhold til metodegruppa","Krav i forhold til Mål","Krav i forhold til SLP krav","Måloppnåelse BIAS mellom ny/gammel\nbio","Krav i forhold til Bio krav\n2,33(0,5*CVw)+0,25√(CVw^2+CVb^2)","Nivå\nMean pasient (innkjøring)\nABL 735","Nivå Stabil CV 735","CVa 735 (2011)","Bias\n(735vs835)","Bias%\n(735vs835)","Måloppnåelse BIAS mellom ny/gammel\nSLP","Måloppnåelse BIAS mellom ny/gammel\nbio","Måloppnåelse BIAS mellom ny/gammel\n1/16 av ref","Nivå bd","SDbd","CVbd","Måloppnåelse Impresisjon bio","Måloppnåelse Impresisjon ref","CVny<CVgammel","Nivå bd","CVbd","Måloppnåelse Impresisjon","Nivå bd","CVbd","Måloppnåelse Impresisjon"]
["pH",3.5,2,7.36,7.44,"pH",7.3390000000000004,7.3380000000000001,0.5,{"$f":"(2.33*(0.5*B5))+(0.25*SQRT(B5^2+C5^2))","v":5.0852822185373192},{"$f":"0.125*(SQRT(B5^2+C5^2))","v":0.50389110926865932},{"$f":"0.25*(SQRT(B5^2+C5^2))","v":1.0077822185373186},{"$f":"0.375*(SQRT(B5^2+C5^2))","v":1.511673327805978},{"$f":"IF(B5<>\"\",B5/3,\"CVw mangler\")","v":1.1666666666666667},{"$f":"((E5-D5)/16)/AVERAGE(D5:E5)*100","v":6.7567567567567627E-2},{"$f":"0.25*B5","v":0.875},{"$f":"0.5*B5","v":1.75},{"$f":"0.75*B5","v":2.625},{"$f":"(((E5-D5)/4)/AVERAGE(D5:E5))*50","v":0.13513513513513525},0,0,{"$f":"IF(OR(B5<> \"\",C5<>\"\"),(IF(T5<P5,\"Optimal\",IF(T5<Q5,\"Ønskelig\",IF(T5<R5,\"Minimum\",\"Ikke ok\")))),\"Bio?\")","v":"Optimal"},{"$f":"IF(OR(B5<> \"\",C5<>\"\"),(IF(U5<P5,\"Optimal\",IF(U5<Q5,\"Ønskelig\",IF(U5<R5,\"Minimum\",\"Ikke ok\")))),\"Bio?\")","v":"Optimal"},{"$f":"IF(T5<S5,\"Ok\",\"Ikke ok\")","v":"Ok"},{"$f":"IF(U5<S5,\"Ok\",\"Ikke ok\")","v":"Ok"},7.3280000000000003,{"$f":"ABS(((G5-Z5)*100)/G5)","v":0.1498841804060515},{"$f":"IF(AA5<I5,\"Ok\",\"Ikke ok\")","v":"Ok"},{"$f":"IF(B5<>\"\",IF(AA5<J5,\"Ok\",\"Ikke ok\"),\"Bio?\")","v":"Ok"},7.3339999999999996,{"$f":"ABS(((H5-AD5)*100)/H5)","v":5.4510765876266659E-2},{"$f":"IF(B5<>\"\",(IF(H5<>\"\",(IF(AE5<K5,\"Optimal\",IF(AE5<L5,\"Ønskelig\",IF(AE5<M5,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")),\"Mangler bias\")","v":"Optimal"},{"$f":"IF(AE5<I5,\"Ok\",\"Ikke ok\")","v":"Ok"},{"$f":"IF(AD5<>\"\",(IF(B5<>\"\",(IF(AE5<K5,\"Optimal\",IF(AE5<L5,\"Ønskelig\",IF(AE5<M5,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")),\"Mangler bias\")","v":"Optimal"},{"$f":"IF(B5<>\"\",IF(AE5<J5,\"Ok\",\"Ikke ok\"),\"Bio?\")","v":"Ok"},7.4119999999999999,7.1130000000000004,0.04,-0.02,{"$f":"ABS(AM5*100/AJ5)","v":0.26983270372369134},{"$f":"IF(AN5<>\"\",(IF(I5<>\"\",(IF(AN5<I5,\"Ok\",\"Ikke ok\")),\"Mangler SLPgrense\")),\"Mangler bias\")","v":"Ok"},{"$f":"IF(AN5<>\"\",(IF(B5<>\"\",(IF(AN5<K5,\"Optimal\",IF(AN5<L5,\"Ønskelig\",IF(AN5<M5,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")),\"Mangler bias\")","v":"Optimal"},{"$f":"IF(AN5<O5,\"Ok\",\"Ikke ok\")","v":"Ikke ok"},7.1130000000000004,null,0.03,{"$f":"IF(B5<>\"\",(IF(AT5<P5,\"Optimal\",IF(AT5<Q5,\"Ønskelig\",IF(AT5<R5,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"},{"$f":"IF(AT5<S5,\"Ok\",\"Ikke ok\")","v":"Ok"},{"$f":"IF(AT5<=AL5,\"Ok\",\"Ikke ok\")","v":"Ok"},null,0.02,null,null,0.01]
["pCO2",4.8,5.3,4.7,5.9,"kPa",6.15,6.16,4,{"$f":"(2.33*(0.5*B6))+(0.25*SQRT(B6^2+C6^2))","v":7.3796311140724749},{"$f":"0.125*(SQRT(B6^2+C6^2))","v":0.89381555703623772},{"$f":"0.25*(SQRT(B6^2+C6^2))","v":1.7876311140724754},{"$f":"0.375*(SQRT(B6^2+C6^2))","v":2.6814466711087133},1.5999999999999999,{"$f":"((E6-D6)/16)/AVERAGE(D6:E6)*100","v":1.4150943396226416},{"$f":"0.25*B6","v":1.2},{"$f":"0.5*B6","v":2.4},{"$f":"0.75*B6","v":3.5999999999999996},{"$f":"(((E6-D6)/4)/AVERAGE(D6:E6))*50","v":2.8301886792452833},0.9,2.5,"Optimal","Minimum",{"$f":"IF(T6<S6,\"Ok\",\"Ikke ok\")","v":"Ok"},{"$f":"IF(U6<S6,\"Ok\",\"Ikke ok\")","v":"Ok"},6.3,2.4390243902438935,"Ok",{"$f":"IF(B6<>\"\",IF(AA6<J6,\"Ok\",\"Ikke ok\"),\"Bio?\")","v":"Ok"},6.3,{"$f":"ABS(((H6-AD6)*100)/H6)","v":2.2727272727272676},{"$f":"IF(B6<>\"\",(IF(H6<>\"\",(IF(AE6<K6,\"Optimal\",IF(AE6<L6,\"Ønskelig\",IF(AE6<M6,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")),\"Mangler bias\")","v":"Minimum"},"Ok",{"$f":"IF(AD6<>\"\",(IF(B6<>\"\",(IF(AE6<K6,\"Optimal\",IF(AE6<L6,\"Ønskelig\",IF(AE6<M6,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")),\"Mangler bias\")","v":"Minimum"},"Ok",5.4029999999999996,1.66,2.4500000000000002,-0.14000000000000001,{"$f":"ABS(AM6*100/AJ6)","v":2.5911530631130857},"Ok","Minimum","Ikke ok",1.66,null,1.38,"Ønskelig","Ok",{"$f":"IF(AT6<=AL6,\"Ok\",\"Ikke ok\")","v":"Ok"},null,1.57,null,null,0.93]
["pO2",null,null,10.5,14,"kPa",9.35,9.82,6,0,0,0,0,"CVw mangler",1.7857142857142856,0,0,0,3.5714285714285712,0.7,2,"Bio?","Bio?","Ok","Ok",9.3000000000000007,0.53475935828875865,"Ok","Bio?",9.6999999999999993,1.2219959266802545,"Mangler bias","Ok","Mangler bio","Bio?",10.478999999999999,8.9700000000000006,2.2400000000000002,0.46500000000000002,{"$f":"ABS(AM7*100/AJ7)","v":4.4374463212138568},"Ok","Mangler bio","Ikke ok",8.86,null,2.2000000000000002,"Mangler bio","Ok","Ok",null,1.37,null,null,2.2400000000000002]
["ctHb",2.8,6.6,12,16,"g/dL",null,null,10,5.0543448328934915,0.89617241644674595,1.7923448328934919,2.6885172493402378,0.93333333333333324,1.7857142857142856,0.7,1.4,2.0999999999999996,3.5714285714285712,0.67,2.2000000000000002,"Optimal","Ikke ok","Ok","Ok",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},"Mangler bio",{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},12.025,8.2200000000000006,1.18,-0.255,{"$f":"ABS(AM8*100/AJ8)","v":2.1205821205821205},"Ok","Minimum","Ikke ok",8.2200000000000006,null,0.61,"Optimal","Ok","Ok",null,0,null,null,0.46]
["sO2",null,null,95,99,"%",null,null,10,0,0,0,0,"CVw mangler",0.25773195876288657,0,0,0,0.51546391752577314,0.05,0.3,"Bio?","Bio?","Ok","Ok",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",94.703000000000003,70.239999999999995,0.25,-0.751,{"$f":"ABS(AM9*100/AJ9)","v":0.79300550140967019},"Ok","Mangler bio","Ikke ok",49.98,null,0.06,"Mangler bio","Ok","Ok",null,7.0000000000000007E-2,null,null,0.03]
["FO2HB",null,null,0.94,0.99,"%",null,null,null,0,null,null,null,"CVw mangler",0.32383419689119197,null,null,null,0.64766839378238394,0.15,0.5,"Bio?","Bio?","Ok","Ok",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",null,null,null,null,{"$f":"ABS(AM10*100/AJ10)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"Mangler bio","Ok","Ok"]
["FCOHb",null,null,0.5,1.5,"%",null,null,10,0,null,null,null,"CVw mangler",6.25,null,null,null,12.5,0.25,3.75,"Bio?","Bio?","Ok","Ok",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",2.028,5.9,4.8499999999999996,-0.28000000000000003,13.806706114398423,"Ikke ok","Mangler bio","Ikke ok",5.9,null,2.1,"Mangler bio","Ok","Ok",null,2.57,null,null,2.82]
["MetHb",null,null,null,null,"%",null,null,null,0,null,null,null,"CVw mangler",{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},0.25,2,"Bio?","Bio?",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"Mangler bio",{"$error":"#DIV/0!"},"Ok"]
["tO2",null,null,8,9.5,"mmol/L",null,null,null,0,null,null,null,"CVw mangler",1.0714285714285714,null,null,null,2.1428571428571428,3.75,10,"Bio?","Bio?","Ikke ok","Ikke ok",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",6.87,null,null,-0.11799999999999999,1.7176128093158658,"Mangler SLPgrense","Mangler bio","Ikke ok",null,null,null,"Mangler bio","Ok","Ok"]
["cHCO3-(P)c",null,null,22,26,"mmol/L",null,null,null,0,0,0,0,"CVw mangler",1.0416666666666665,0,0,0,2.083333333333333,null,null,"Bio?","Bio?","Ok","Ok",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"Mangler bio","Ok","Ok",null,0.76,null,null,0.56999999999999995]
["cHCO3-(P,st)c",null,null,null,null,"mmol/L",null,null,null,0,0,0,0,"CVw mangler",{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},null,null,"Bio?","Bio?",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"Mangler bio",{"$error":"#DIV/0!"},"Ok"]
["SBEc",null,null,-3,3,"mmol/L",null,null,null,0,0,0,0,"CVw mangler",{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},null,null,"Bio?","Bio?",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"Mangler bio",{"$error":"#DIV/0!"},"Ok",null,35.700000000000003,null,null,48.02]
["cNa+",0.7,1,136,144,"mmol/L",134.5,134.80000000000001,2,1.1206638903933426,0.15258194519667129,0.30516389039334257,0.45774583559001386,0.23333333333333331,0.35714285714285715,0.17499999999999999,0.35,0.52499999999999991,0.7142857142857143,0.28999999999999998,0.79,"Ønskelig","Ikke ok","Ok","Ikke ok",134,0.37174721189591076,"Ok","Ok",135,0.14836795252224674,"Optimal","Ok","Optimal","Ok",137.47999999999999,127.5,0.63,0.65,0.47279604306080886,"Ok","Ikke ok","Ikke ok",127.5,null,0.41,"Minimum","Ok","Ok",null,0.23,null,null,0.59]
["cK+",4.8,5.6,3.5,5,"mmol/L",3.32,3.33,4,7.4359088914585767,0.92195444572928864,1.8439088914585773,2.765863337187866,1.5999999999999999,2.2058823529411766,1.2,2.4,3.5999999999999996,4.4117647058823533,0.5,1.88,"Optimal","Ønskelig","Ok","Ok",3.3,0.60240963855421747,"Ok","Ok",3.3,0.90090090090090835,"Optimal","Ok","Optimal","Ok",3.9649999999999999,1.8,0,7.1999999999999995E-2,1.815889029003783,"Ok","Ønskelig","Ok",1.8,null,0,"Optimal","Ok","Ok",null,0.38,null,null,0.36]
["cCa2+",1.9,2.8,1.1499999999999999,1.35,"mmol/L",1.18,1.19,3,3.0594462157844315,0.42297310789221576,0.84594621578443152,1.2689193236766472,0.6333333333333333,1.0000000000000009,0.47499999999999998,0.95,1.4249999999999998,2.0000000000000018,0.64,1.6,"Ønskelig","Ikke ok","Ok","Ok",1.18,0,"Ok","Ok",1.18,0.8403361344537823,"Ønskelig","Ok","Ønskelig","Ok",1.1910000000000001,0.53,4.99,-0.01,0.83963056255247692,"Ok","Ønskelig","Ok",0.53,null,0.9,"Ønskelig","Ok","Ok",null,0.92,null,null,0.73]
["cCl-",1.2,1.5,98,106,"mmol/L",94.1,93.9,3,1.8782343178074636,0.24011715890373184,0.48023431780746367,0.72035147671119548,0.39999999999999997,0.49019607843137253,0.3,0.6,0.89999999999999991,0.98039215686274506,0.38,1.36,"Ønskelig","Ikke ok","Ok","Ikke ok",95,0.95642933049947476,"Ok","Ok",93,0.95846645367412742,"Ikke ok","Ok","Ikke ok","Ok",105.8,67.400000000000006,1.58,null,0,"Ok","Optimal","Ok",67.400000000000006,null,null,"Optimal","Ok","Ok",null,0.75,null,null,0.56000000000000005]
["cCa2+(7.4)c",null,null,1.1499999999999999,1.35,"mmol/L",1.1399999999999999,1.1499999999999999,3,0,0,0,0,"CVw mangler",1.0000000000000009,0,0,0,2.0000000000000018,null,null,"Bio?","Bio?","Ok","Ok",1.1399999999999999,0,"Ok","Bio?",1.1399999999999999,0.86956521739130521,"Mangler bias","Ok","Mangler bio","Bio?",1.226,null,null,4.0000000000000001E-3,0.32626427406199021,"Ok","Mangler bio","Ok",null,null,null,"Mangler bio","Ok","Ok"]
["Anion gab, K+c",null,null,11,17,"mmol/L",null,null,null,0,0,0,0,"CVw mangler",2.6785714285714284,0,0,0,5.3571428571428568,null,null,"Bio?","Bio?","Ok","Ok",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",null,null,null,-0.20799999999999999,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"Mangler bio","Ok","Ok",null,0.76,null,null,1.27]
["cGlu",5.7,6.9,4,6,"mmol/L",11.82,11.9,4.5,8.8779650835264441,1.1187325417632223,2.2374650835264447,3.356197625289667,1.9000000000000001,2.5,1.425,2.85,4.2750000000000004,5,1.17,3.67,"Optimal","Minimum","Ok","Ok",12.4,4.9069373942470396,"Ikke ok","Ok",11.7,1.6806722689075719,"Ønskelig","Ok","Ønskelig","Ok",7.59,1.52,3.1,-3.2000000000000001E-2,0.42160737812911731,"Ok","Optimal","Ok",1.52,null,3.29,"Minimum","Ok","Ikke ok",null,1.22,null,null,1.19]
["ctBil",null,null,null,null,"µmol/L",null,null,null,0,0,0,0,"CVw mangler",{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},0,0,"Bio?","Bio?",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"Mangler bio",{"$error":"#DIV/0!"},"Ok"]
["cLac",27.2,16.7,0.5,1.6,"mmol/L",1.34,1.34,6,39.667387507822887,3.9896937539114452,7.9793875078228904,11.969081261734335,9.0666666666666664,6.5476190476190483,6.8,13.6,20.399999999999999,13.095238095238097,2,7.5,"Optimal","Ønskelig","Ok","Ok",1.4,4.4776119402984946,"Ok","Ok",1.3,2.985074626865674,"Optimal","Ok","Optimal","Ok",1.226,4.3600000000000003,1.84,null,0,"Ok","Optimal","Ok",4.3600000000000003,null,2.09,"Optimal","Ok","Ikke ok",null,4.32,null,null,1.93]
["cCreat",5.3,14.2,60,100,"µmol/L",279.5,"na",8,9.9637116594352442,1.8946058297176223,3.7892116594352445,5.683817489152867,1.7666666666666666,3.125,1.325,2.65,3.9749999999999996,6.25,1.8,3.1,"Ønskelig","Minimum","Ok","Ok","na",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"na",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},127.11799999999999,261,null,null,0,"Ok","Optimal","Ok",261,null,null,"Optimal","Ok","Ok",null,null,null,null,3.05]
[null,null,null,null,null,null,null,null,null,0,0,0,0,"CVw mangler",{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},null,null,"Bio?","Bio?",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"Bio?",null,{"$error":"#DIV/0!"},"Mangler bias",{"$error":"#DIV/0!"},"Mangler bias","Bio?",null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,"Mangler bio",{"$error":"#DIV/0!"},"Ok"]
[]
[null,"Biological variation",null,"Referanseområde Kofstad -95",null,null,"SLP nr …",null,null,null,"Mål for BIAS %",null,null,null,null,"Mål for IMPRESISJON %"]
[null,null,null,null,null,null,null,null,null,null,"optimalt","ønskelig B(%)","Minimum","Mellom instrument",null,"optimalt","ønskelig I(%)","minimum"]
[null,"CVw","CVb","Lav","Høy","Benevning","Mean metodegruppe\n735","Mean\n835","Grense %","Bio krav\n2,33(0,5*CVw)+0,25√(CVw^2+CVb^2)","0,125*√(CVw2+CVb2)","0,250*√(CVw2+CVb2)","0,375*√(CVw2+CVb2)","CVw  / 3","Ref/16 %","0,25*CVw","0,50*CVw","0,75*CVw","CVt Basert på Ref\ntillatt feil (1/4*refintervall/mean intervall)*100= CVa*2\n→CVa=(1/4*refintervall/mean intervall)*50",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nivå Stabil CV 735","CVa 735 (2011)",null,null,null,null,null,"Nivå bd","SDbd","CVbd","Måloppnåelse Impresisjon bio","Måloppnåelse Impresisjon ref","CVny<CVgammel"]
["pH",3.5,2,7.36,7.44,"pH",7.3390000000000004,7.3380000000000001,0.5,{"$f":"(2.33*(0.5*B32))+(0.25*SQRT(B32^2+C32^2))","v":5.0852822185373192},{"$f":"0.125*(SQRT(B32^2+C32^2))","v":0.50389110926865932},{"$f":"0.25*(SQRT(B32^2+C32^2))","v":1.0077822185373186},{"$f":"0.375*(SQRT(B32^2+C32^2))","v":1.511673327805978},{"$f":"IF(B32<>\"\",B32/3,\"CVw mangler\")","v":1.1666666666666667},{"$f":"((E32-D32)/16)/AVERAGE(D32:E32)*100","v":6.7567567567567627E-2},{"$f":"0.25*B32","v":0.875},{"$f":"0.5*B32","v":1.75},{"$f":"0.75*B32","v":2.625},{"$f":"(((E32-D32)/4)/AVERAGE(D32:E32))*50","v":0.13513513513513525},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5860000000000003,0.1,null,null,null,null,null,7.5860000000000003,null,0.02,{"$f":"IF(B32<>\"\",(IF(AT32<P32,\"Optimal\",IF(AT32<Q32,\"Ønskelig\",IF(AT32<R32,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"},{"$f":"IF(AT32<S32,\"Ok\",\"Ikke ok\")","v":"Ok"},{"$f":"IF(AT32<=AL32,\"Ok\",\"Ikke ok\")","v":"Ok"}]
["pCO2",4.8,5.3,4.7,5.9,"kPa",6.15,6.16,4,{"$f":"(2.33*(0.5*B33))+(0.25*SQRT(B33^2+C33^2))","v":7.3796311140724749},{"$f":"0.125*(SQRT(B33^2+C33^2))","v":0.89381555703623772},{"$f":"0.25*(SQRT(B33^2+C33^2))","v":1.7876311140724754},{"$f":"0.375*(SQRT(B33^2+C33^2))","v":2.6814466711087133},1.5999999999999999,{"$f":"((E33-D33)/16)/AVERAGE(D33:E33)*100","v":1.4150943396226416},{"$f":"0.25*B33","v":1.2},{"$f":"0.5*B33","v":2.4},{"$f":"0.75*B33","v":3.5999999999999996},{"$f":"(((E33-D33)/4)/AVERAGE(D33:E33))*50","v":2.8301886792452833},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.75,1.7,null,null,null,null,null,8.75,null,1.22,"Ønskelig","Ok",{"$f":"IF(AT33<=AL33,\"Ok\",\"Ikke ok\")","v":"Ok"}]
["pO2",null,null,10.5,14,"kPa",9.35,9.82,6,0,{"$f":"0.125*(SQRT(B34^2+C34^2))","v":0},{"$f":"0.25*(SQRT(B34^2+C34^2))","v":0},{"$f":"0.375*(SQRT(B34^2+C34^2))","v":0},"CVw mangler",1.7857142857142856,{"$f":"0.25*B34","v":0},{"$f":"0.5*B34","v":0},{"$f":"0.75*B34","v":0},3.5714285714285712,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.399999999999999,1.89,null,null,null,null,null,19.399999999999999,null,1.84,"Mangler bio","Ok","Ok"]
["ctHb",2.8,6.6,12,16,"g/dL",null,null,10,5.0543448328934915,{"$f":"0.125*(SQRT(B35^2+C35^2))","v":0.89617241644674595},{"$f":"0.25*(SQRT(B35^2+C35^2))","v":1.7923448328934919},{"$f":"0.375*(SQRT(B35^2+C35^2))","v":2.6885172493402378},0.93333333333333324,1.7857142857142856,{"$f":"0.25*B35","v":0.7},{"$f":"0.5*B35","v":1.4},{"$f":"0.75*B35","v":2.0999999999999996},3.5714285714285712,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.7,0.98,null,null,null,null,null,19.7,null,0.45,"Optimal","Ok","Ok"]
["sO2",null,null,95,99,"%",null,null,10,0,{"$f":"0.125*(SQRT(B36^2+C36^2))","v":0},{"$f":"0.25*(SQRT(B36^2+C36^2))","v":0},{"$f":"0.375*(SQRT(B36^2+C36^2))","v":0},"CVw mangler",0.25773195876288657,{"$f":"0.25*B36","v":0},{"$f":"0.5*B36","v":0},{"$f":"0.75*B36","v":0},0.51546391752577314,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70.25,0.25,null,null,null,null,null,70.25,null,0,"Mangler bio","Ok","Ok"]
["FO2HB",null,null,0.94,0.99,"%",null,null,null,0,null,null,null,"CVw mangler",0.32383419689119197,null,null,null,0.64766839378238394,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangler bio","Ok","Ok"]
["FCOHb",null,null,0.5,1.5,"%",null,null,10,0,null,null,null,"CVw mangler",6.25,null,null,null,12.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20.72,1.23,null,null,null,null,null,20.72,null,0.32,"Mangler bio","Ok","Ok"]
["MetHb",null,null,null,null,"%",null,null,null,0,null,null,null,"CVw mangler",{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangler bio",{"$error":"#DIV/0!"},"Ok"]
["tO2",null,null,8,9.5,"mmol/L",null,null,null,0,null,null,null,"CVw mangler",1.0714285714285714,null,null,null,2.1428571428571428,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangler bio","Ok","Ok"]
["cHCO3-(P)c",null,null,22,26,"mmol/L",null,null,null,0,{"$f":"0.125*(SQRT(B41^2+C41^2))","v":0},{"$f":"0.25*(SQRT(B41^2+C41^2))","v":0},{"$f":"0.375*(SQRT(B41^2+C41^2))","v":0},"CVw mangler",1.0416666666666665,{"$f":"0.25*B41","v":0},{"$f":"0.5*B41","v":0},{"$f":"0.75*B41","v":0},2.083333333333333,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangler bio","Ok","Ok"]
["cHCO3-(P,st)c",null,null,null,null,"mmol/L",null,null,null,0,0,0,0,"CVw mangler",{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangler bio",{"$error":"#DIV/0!"},"Ok"]
["SBEc",null,null,-3,3,"mmol/L",null,null,null,0,0,0,0,"CVw mangler",{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangler bio",{"$error":"#DIV/0!"},"Ok"]
["cNa+",0.7,1,136,144,"mmol/L",134.5,134.80000000000001,2,1.1206638903933426,0.15258194519667129,0.30516389039334257,0.45774583559001386,0.23333333333333331,0.35714285714285715,0.17499999999999999,0.35,0.52499999999999991,0.7142857142857143,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,159.69999999999999,0.56999999999999995,null,null,null,null,null,159.69999999999999,null,0.31,"Ønskelig","Ok","Ok"]
["cK+",4.8,5.6,3.5,5,"mmol/L",3.32,3.33,4,7.4359088914585767,0.92195444572928864,1.8439088914585773,2.765863337187866,1.5999999999999999,2.2058823529411766,1.2,2.4,3.5999999999999996,4.4117647058823533,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.49,0.68,null,null,null,null,null,5.49,null,0.34,"Optimal","Ok","Ok"]
["cCa2+",1.9,2.8,1.1499999999999999,1.35,"mmol/L",1.18,1.19,3,3.0594462157844315,0.42297310789221576,0.84594621578443152,1.2689193236766472,0.6333333333333333,1.0000000000000009,0.47499999999999998,0.95,1.4249999999999998,2.0000000000000018,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0429999999999999,1.76,null,null,null,null,null,1.0429999999999999,null,0.8,"Ønskelig","Ok","Ok"]
["cCl-",1.2,1.5,98,106,"mmol/L",94.1,93.9,3,1.8782343178074636,0.24011715890373184,0.48023431780746367,0.72035147671119548,0.39999999999999997,0.49019607843137253,0.3,0.6,0.89999999999999991,0.98039215686274506,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120.8,1.0900000000000001,null,null,null,null,null,120.8,null,null,"Optimal","Ok","Ok"]
["cCa2+(7.4)c",null,null,1.1499999999999999,1.35,"mmol/L",1.1399999999999999,1.1499999999999999,3,0,0,0,0,"CVw mangler",1.0000000000000009,0,0,0,2.0000000000000018,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangler bio","Ok","Ok"]
["Anion gab, K+c",null,null,11,17,"mmol/L",null,null,null,0,0,0,0,"CVw mangler",2.6785714285714284,0,0,0,5.3571428571428568,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangler bio","Ok","Ok"]
["cGlu",5.7,6.9,4,6,"mmol/L",11.82,11.9,4.5,8.8779650835264441,1.1187325417632223,2.2374650835264447,3.356197625289667,1.9000000000000001,2.5,1.425,2.85,4.2750000000000004,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.09,1.17,null,null,null,null,null,14.09,null,1.39,"Optimal","Ok","Ikke ok"]
["ctBil",null,null,null,null,"µmol/L",null,null,null,0,0,0,0,"CVw mangler",{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangler bio",{"$error":"#DIV/0!"},"Ok"]
["cLac",27.2,16.7,0.5,1.6,"mmol/L",1.34,1.34,6,39.667387507822887,3.9896937539114452,7.9793875078228904,11.969081261734335,9.0666666666666664,6.5476190476190483,6.8,13.6,20.399999999999999,13.095238095238097,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.33,2.4,null,null,null,null,null,10.33,null,4.09,"Optimal","Ok","Ikke ok"]
["cCreat",5.3,14.2,60,100,"µmol/L",279.5,"na",8,9.9637116594352442,1.8946058297176223,3.7892116594352445,5.683817489152867,1.7666666666666666,3.125,1.325,2.65,3.9749999999999996,6.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,520,null,null,null,null,null,null,520,null,null,"Optimal","Ok","Ok"]
[null,null,null,null,null,null,null,null,null,0,0,0,0,"CVw mangler",{"$error":"#DIV/0!"},0,0,0,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mangler bio",{"$error":"#DIV/0!"},"Ok"]

{"sheet":"Bias SLP","index":2,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[14,1,15,2],[14,3,15,3],[27,0,29,0],[27,1,28,2],[27,3,28,3],[27,4,27,6],[27,7,28,9],[14,4,14,6],[14,7,15,9],[1,0,3,0],[1,1,2,2],[1,3,2,3],[1,4,1,6],[1,7,2,9],[14,0,16,0]]}
["Prøve 1"]
["Analytt","Biological variation",null,"SLP nr 4/2011","Mål for BIAS %",null,null,"SLP resultat 835 (MB)"]
[null,null,null,null,"optimalt","ønskelig B(%)","Minimum"]
[null,"CVw","CVb","Mean\n835","0,125*√(CVw2+CVb2)","0,250*√(CVw2+CVb2)","0,375*√(CVw2+CVb2)","Vårt resultat","BIAS% i forhold til metodegruppa","Krav i forhold til Mål"]
["pH",3.5,2,7.157,{"$f":"0.125*(SQRT(B5^2+C5^2))","v":0.50389110926865932},{"$f":"0.25*(SQRT(B5^2+C5^2))","v":1.0077822185373186},{"$f":"0.375*(SQRT(B5^2+C5^2))","v":1.511673327805978},7.1539999999999999,{"$f":"ABS(((D5-H5)*100)/D5)","v":4.1917004331425367E-2},{"$f":"IF(B5<>\"\",(IF(D5<>\"\",(IF(I5<E5,\"Optimal\",IF(I5<F5,\"Ønskelig\",IF(I5<G5,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")),\"Mangler bias\")","v":"Optimal"}]
["pCO2",4.8,5.3,8.19,{"$f":"0.125*(SQRT(B6^2+C6^2))","v":0.89381555703623772},{"$f":"0.25*(SQRT(B6^2+C6^2))","v":1.7876311140724754},{"$f":"0.375*(SQRT(B6^2+C6^2))","v":2.6814466711087133},8.3000000000000007,1.3431013431013579,"Ønskelig"]
["cNa+",0.7,1,119.1,0.15258194519667129,0.30516389039334257,0.45774583559001386,119,8.3963056255242918E-2,"Optimal"]
["cK+",4.8,5.6,2,0.92195444572928864,1.8439088914585773,2.765863337187866,2,0,"Optimal"]
["cCa2+",1.9,2.8,1.7,0.42297310789221576,0.84594621578443152,1.2689193236766472,1.69,0.58823529411764763,"Ønskelig"]
["cCl-",1.2,1.5,78.5,0.24011715890373184,0.48023431780746367,0.72035147671119548,76,3.1847133757961785,"Ikke ok"]
["cGlu",5.7,6.9,21.14,1.1187325417632223,2.2374650835264447,3.356197625289667,21,0.66225165562914179,"Optimal"]
["cLac",27.2,16.7,14.16,3.9896937539114452,7.9793875078228904,11.969081261734335,13.5,4.6610169491525433,"Ønskelig"]
[]
["Prøve 2"]
["Analytt","Biological variation",null,"SLP nr 4/2011","Mål for BIAS %",null,null,"SLP resultat 835 (MB)"]
[null,null,null,null,"optimalt","ønskelig B(%)","Minimum"]
[null,"CVw","CVb","Mean\n835","0,125*√(CVw2+CVb2)","0,250*√(CVw2+CVb2)","0,375*√(CVw2+CVb2)","Vårt resultat","BIAS% i forhold til metodegruppa","Krav i forhold til Mål"]
["pH",3.5,2,7.3380000000000001,{"$f":"0.125*(SQRT(B18^2+C18^2))","v":0.50389110926865932},{"$f":"0.25*(SQRT(B18^2+C18^2))","v":1.0077822185373186},{"$f":"0.375*(SQRT(B18^2+C18^2))","v":1.511673327805978},7.3339999999999996,{"$f":"ABS(((D18-H18)*100)/D18)","v":5.4510765876266659E-2},{"$f":"IF(B18<>\"\",(IF(D18<>\"\",(IF(I18<E18,\"Optimal\",IF(I18<F18,\"Ønskelig\",IF(I18<G18,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")),\"Mangler bias\")","v":"Optimal"}]
["pCO2",4.8,5.3,6.16,{"$f":"0.125*(SQRT(B19^2+C19^2))","v":0.89381555703623772},{"$f":"0.25*(SQRT(B19^2+C19^2))","v":1.7876311140724754},{"$f":"0.375*(SQRT(B19^2+C19^2))","v":2.6814466711087133},6.3,2.2727272727272676,"Minimum"]
["cNa+",0.7,1,134.80000000000001,0.15258194519667129,0.30516389039334257,0.45774583559001386,135,0.14836795252224674,"Optimal"]
["cK+",4.8,5.6,3.33,0.92195444572928864,1.8439088914585773,2.765863337187866,3.3,0.90090090090090835,"Optimal"]
["cCa2+",1.9,2.8,1.19,0.42297310789221576,0.84594621578443152,1.2689193236766472,1.18,0.8403361344537823,"Ønskelig"]
["cCl-",1.2,1.5,93.9,0.24011715890373184,0.48023431780746367,0.72035147671119548,93,0.95846645367412742,"Ikke ok"]
["cGlu",5.7,6.9,11.9,1.1187325417632223,2.2374650835264447,3.356197625289667,11.7,1.6806722689075719,"Ønskelig"]
["cLac",27.2,16.7,1.34,3.9896937539114452,7.9793875078228904,11.969081261734335,1.3,2.985074626865674,"Optimal"]
[]
["Prøve 3"]
["Analytt","Biological variation",null,"SLP nr 4/2011","Mål for BIAS %",null,null,"SLP resultat 835 (MB)"]
[null,null,null,null,"optimalt","ønskelig B(%)","Minimum"]
[null,"CVw","CVb","Mean\n835","0,125*√(CVw2+CVb2)","0,250*√(CVw2+CVb2)","0,375*√(CVw2+CVb2)","Vårt resultat","BIAS% i forhold til metodegruppa","Krav i forhold til Mål"]
["pH",3.5,2,7.6230000000000002,{"$f":"0.125*(SQRT(B31^2+C31^2))","v":0.50389110926865932},{"$f":"0.25*(SQRT(B31^2+C31^2))","v":1.0077822185373186},{"$f":"0.375*(SQRT(B31^2+C31^2))","v":1.511673327805978},7.62,{"$f":"ABS(((D31-H31)*100)/D31)","v":3.9354584809131753E-2},{"$f":"IF(B31<>\"\",(IF(D31<>\"\",(IF(I31<E31,\"Optimal\",IF(I31<F31,\"Ønskelig\",IF(I31<G31,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")),\"Mangler bias\")","v":"Optimal"}]
["pCO2",4.8,5.3,2.8,{"$f":"0.125*(SQRT(B32^2+C32^2))","v":0.89381555703623772},{"$f":"0.25*(SQRT(B32^2+C32^2))","v":1.7876311140724754},{"$f":"0.375*(SQRT(B32^2+C32^2))","v":2.6814466711087133},2.9,3.5714285714285747,"Ikke ok"]
["cNa+",0.7,1,160.1,0.15258194519667129,0.30516389039334257,0.45774583559001386,160,6.2460961898809696E-2,"Optimal"]
["cK+",4.8,5.6,5.74,0.92195444572928864,1.8439088914585773,2.765863337187866,5.7,0.69686411149825844,"Optimal"]
["cCa2+",1.9,2.8,0.47,0.42297310789221576,0.84594621578443152,1.2689193236766472,0.49,4.2553191489361746,"Ikke ok"]
["cCl-",1.2,1.5,118,0.24011715890373184,0.48023431780746367,0.72035147671119548,118,0,"Optimal"]
["cGlu",5.7,6.9,2.52,1.1187325417632223,2.2374650835264447,3.356197625289667,2.5,0.79365079365079438,"Optimal"]
["cLac",27.2,16.7,1.34,3.9896937539114452,7.9793875078228904,11.969081261734335,1.3,2.985074626865674,"Optimal"]

{"sheet":"Bias 735vs835","index":3,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,5,2,7],[2,1,2,3],[2,4,3,4],[1,0,3,0]]}
[]
["Analytt","Våre resultat"]
[null,"ABL 735 MB",null,null,"KRAV\n≤ ⅓∙CVagammel metode","ABL 835 MB"]
[null,"Nivå\nMean pasient (innkjøring)\nABL 735","Nivå Stabil CV 735","CVa 735 (2011)",null,"Nivå\nMean pasient (innkjøring)\nABL 835 MB","%Bias","Måloppnåelse Bias"]
["pO2",10.478999999999999,8.9700000000000006,2.2400000000000002,{"$f":"D5/3","v":0.7466666666666667},10.74625,{"$f":"ABS((F5-B5)*100/B5)","v":2.5503387727836691},{"$f":"IF(G5<=E5,\"Ok\",\"Ikke Ok\")","v":"Ikke Ok"}]
["sO2",94.703000000000003,70.239999999999995,0.25,{"$f":"D6/3","v":8.3333333333333329E-2},93.885000000000005,{"$f":"ABS((F6-B6)*100/B6)","v":0.8637529962091991},{"$f":"IF(G6<=E6,\"Ok\",\"Ikke Ok\")","v":"Ikke Ok"}]
["ctHb",12.025,8.218,1.18,{"$f":"D7/3","v":0.39333333333333331},11.863,{"$f":"ABS((F7-B7)*100/B7)","v":1.3471933471933539},{"$f":"IF(G7<=E7,\"Ok\",\"Ikke Ok\")","v":"Ikke Ok"}]
["FCOHb",2.028,5.9,4.8499999999999996,{"$f":"D8/3","v":1.6166666666666665},1.8480000000000001,{"$f":"ABS((F8-B8)*100/B8)","v":8.8757396449704107},{"$f":"IF(G8<=E8,\"Ok\",\"Ikke Ok\")","v":"Ikke Ok"}]

{"sheet":"Bias mellom instrument","index":4,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,4,0],[2,1,3,1],[3,2,3,4],[3,5,4,5],[2,2,2,12],[3,7,3,9],[3,10,3,12]]}
[]
[]
["Analytt","Biological variation","Våre resultat"]
[null,null,"ABL 735 MB",null,null,"KRAV\n≤ ⅓∙CVw evt\n≤ ⅓∙CVagammel metode","ABL 835 MB","ABL PLAB",null,null,"ABL HOV"]
[null,"CVw","Nivå\nMean pasient (innkjøring)\nABL 735","Nivå Stabil CV 735","CVa 735 (2011)",null,"Nivå bd","Nivå bd","Bias","Måloppnåelse Bias","Nivå bd","Bias","Måloppnåelse Bias"]
["pH",3.5,7.4119999999999999,7.5860000000000003,9.5799999999999996E-2,{"$f":"IF(B6<>\"\",B6/3,E6/3)","v":1.1666666666666667},7.4057000000000004,7.4097249999999972,{"$f":"ABS((H6-$G6)*100/$G6)","v":5.4350027681337842E-2},{"$f":"IF(I6<=$F6,\"Ok\",\"Ikke Ok\")","v":"Ok"},7.4091250000000013,{"$f":"ABS((K6-$G6)*100/$G6)","v":4.6248160200938457E-2},{"$f":"IF(L6<=$F6,\"Ok\",\"Ikke Ok\")","v":"Ok"}]
["pCO2",4.8,5.4029999999999996,8.7479999999999993,1.6990000000000001,{"$f":"IF(B7<>\"\",B7/3,E7/3)","v":1.5999999999999999},5.3579999999999988,5.2635000000000005,{"$f":"ABS((H7-$G7)*100/$G7)","v":1.7637178051511435},{"$f":"IF(I7<=$F7,\"Ok\",\"Ikke Ok\")","v":"Ikke Ok"},5.2420000000000009,{"$f":"ABS((K7-$G7)*100/$G7)","v":2.1649869354236264},{"$f":"IF(L7<=$F7,\"Ok\",\"Ikke Ok\")","v":"Ikke Ok"}]
["pO2",null,10.478999999999999,8.9689999999999994,2.2400000000000002,0.7466666666666667,10.74625,10.943499999999998,1.835524020006966,"Ikke Ok",11.13625,3.6291729673141848,"Ikke Ok"]
["ctHb",2.8,12.025,8.218,1.18,0.93333333333333324,11.862500000000001,11.77,0.77976817702846057,"Ok",11.7075,1.3066385669125491,"Ikke Ok"]
["sO2",null,94.703000000000003,70.25,0.25,8.3333333333333329E-2,93.884615384615401,93.95128205128205,7.1009149255750303E-2,"Ok",93.933333333333323,5.1891301379187592E-2,"Ok"]
["FCOHb",null,2.028,5.9,4.8499999999999996,1.6166666666666665,1.8474999999999999,1.7475000000000001,5.4127198917455948,"Ikke Ok",1.6025,13.261163734776719,"Ikke Ok"]
["cNa+",0.7,137.47999999999999,127.5,0.63300000000000001,0.23333333333333331,138.1,138.125,1.8102824040554442E-2,"Ok",139.07499999999999,0.70601013758145859,"Ikke Ok"]
["cK+",4.8,3.9649999999999999,1.8,0,1.5999999999999999,4.0250000000000004,4.0374999999999996,0.31055900621116245,"Ok",3.9750000000000001,1.2422360248447271,"Ok"]
["cCa2+",1.9,1.1910000000000001,1.0429999999999999,1.764,0.6333333333333333,1.18425,1.1807500000000002,0.29554570403207403,"Ok",1.181,0.27443529660122229,"Ok"]
["cCl-",1.2,105.8,120.8,1.091,0.39999999999999997,104.35,null,null,null,104.9,0.5270723526593305,"Ikke Ok"]
["cGlu",5.7,7.59,null,null,1.9000000000000001,7.4769230769230761,7.3820512820512816,1.2688614540466348,"Ok",7.3461538461538476,1.748971193415608,"Ok"]
["cLac",27.2,1.226,null,null,9.0666666666666664,1.1763157894736842,1.1947368421052631,1.5659955257270648,"Ok",1.1000000000000001,6.4876957494407081,"Ok"]
["cCreat",5.3,127.11799999999999,null,null,1.7666666666666666,133.5,null,null,null,127.11764705882354,4.78078871998237,"Ikke Ok"]

{"sheet":"CV Bio","index":5,"n_rows":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[17,9,17,11],[17,12,17,14],[1,0,3,0],[1,1,2,2],[1,6,1,14],[2,9,2,11],[2,6,2,8],[2,12,2,14],[1,3,1,5],[16,0,18,0],[16,1,17,2],[16,3,16,5],[16,6,16,14],[17,6,17,8]]}
["Kontroll level 1"]
["Analytt","Biological variation",null,"Mål for IMPRESISJON %",null,null,"Våre resultat"]
[null,null,null,"optimalt","ønskelig I(%)","minimum","ABL MB",null,null,"ABL PLAB",null,null,"ABL HOV"]
[null,"CVw","CVb","0,25*CVw","0,50*CVw","0,75*CVw","Nivå bd","CVbd","Måloppnåelse Impresisjon","Nivå bd","CVbd","Måloppnåelse Impresisjon bio","Nivå bd","CVbd","Måloppnåelse Impresisjon"]
["pH",3.5,2,{"$f":"0.25*B5","v":0.875},{"$f":"0.5*B5","v":1.75},{"$f":"0.75*B5","v":2.625},7.1029999999999998,0.04,{"$f":"IF(B5<>\"\",(IF(H5<D5,\"Optimal\",IF(H5<E5,\"Ønskelig\",IF(H5<F5,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"},7.1040000000000001,0.03,{"$f":"IF(B5<>\"\",(IF(K5<D5,\"Optimal\",IF(K5<E5,\"Ønskelig\",IF(K5<F5,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"},7.1070000000000002,0.02,{"$f":"IF(B5<>\"\",(IF(N5<D5,\"Optimal\",IF(N5<E5,\"Ønskelig\",IF(N5<F5,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"}]
["pCO2",4.8,5.3,{"$f":"0.25*B6","v":1.2},{"$f":"0.5*B6","v":2.4},{"$f":"0.75*B6","v":3.5999999999999996},8.9280000000000008,1.57,{"$f":"IF(B6<>\"\",(IF(H6<D6,\"Optimal\",IF(H6<E6,\"Ønskelig\",IF(H6<F6,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Ønskelig"},8.89,1.22,"Ønskelig",8.76,0.93,{"$f":"IF(B6<>\"\",(IF(N6<D6,\"Optimal\",IF(N6<E6,\"Ønskelig\",IF(N6<F6,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"}]
["ctHb",2.8,6.6,0.7,1.4,2.0999999999999996,8.1999999999999993,0,"Optimal",8.14,0.61,"Optimal",8.18,0.46,"Optimal"]
["cNa+",0.7,1,0.17499999999999999,0.35,0.52499999999999991,160.15,0.79,"Ikke ok",159.41,0.31,"Ønskelig",16.04,0.49,"Minimum"]
["cK+",4.8,5.6,1.2,2.4,3.5999999999999996,1.8,0,"Optimal",1.8,0,"Optimal",1.7,0,"Optimal"]
["cCa2+",1.9,2.8,0.47499999999999998,0.95,1.4249999999999998,1.0589999999999999,0.92,"Ønskelig",1.0489999999999999,0.8,"Ønskelig",1.04,0.73,"Ønskelig"]
["cCl-",1.2,1.5,0.3,0.6,0.89999999999999991,120.13,0.74,"Minimum",null,null,null,119.96,0.56000000000000005,"Ønskelig"]
["cGlu",5.7,6.9,1.425,2.85,4.2750000000000004,1.55,3.27,"Minimum",1.43,3.29,{"$f":"IF(B12<>\"\",(IF(K12<D12,\"Optimal\",IF(K12<E12,\"Ønskelig\",IF(K12<F12,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Minimum"},1.62,2.3199999999999998,"Ønskelig"]
["cLac",27.2,16.7,6.8,13.6,20.399999999999999,4.34,4.32,"Optimal",4.34,2.09,{"$f":"IF(B13<>\"\",(IF(K13<D13,\"Optimal\",IF(K13<E13,\"Ønskelig\",IF(K13<F13,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"},4.37,1.93,"Optimal"]
["cCreat",5.3,14.2,1.325,2.65,3.9749999999999996,null,null,null,null,null,null,261.44,3.05,"Minimum"]
[]
["Kontroll level 3"]
["Analytt","Biological variation",null,"Mål for IMPRESISJON %",null,null,"Våre resultat"]
[null,null,null,"optimalt","ønskelig I(%)","minimum","ABL MB",null,null,"ABL PLAB",null,null,"ABL HOV"]
[null,"CVw","CVb","0,25*CVw","0,50*CVw","0,75*CVw","Nivå bd","CVbd","Måloppnåelse Impresisjon","Nivå bd","CVbd","Måloppnåelse Impresisjon bio","Nivå bd","CVbd","Måloppnåelse Impresisjon"]
["pH",3.5,2,{"$f":"0.25*B20","v":0.875},{"$f":"0.5*B20","v":1.75},{"$f":"0.75*B20","v":2.625},7.58,0.02,{"$f":"IF(B20<>\"\",(IF(H20<D20,\"Optimal\",IF(H20<E20,\"Ønskelig\",IF(H20<F20,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"},7.58,0.02,{"$f":"IF(B20<>\"\",(IF(K20<D20,\"Optimal\",IF(K20<E20,\"Ønskelig\",IF(K20<F20,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"},7.577,0.01,{"$f":"IF(B20<>\"\",(IF(N20<D20,\"Optimal\",IF(N20<E20,\"Ønskelig\",IF(N20<F20,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"}]
["pCO2",4.8,5.3,{"$f":"0.25*B21","v":1.2},{"$f":"0.5*B21","v":2.4},{"$f":"0.75*B21","v":3.5999999999999996},1.65,2.1800000000000002,{"$f":"IF(B21<>\"\",(IF(H21<D21,\"Optimal\",IF(H21<E21,\"Ønskelig\",IF(H21<F21,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Ønskelig"},1.7,1.38,"Ønskelig",1.68,1.55,{"$f":"IF(B21<>\"\",(IF(N21<D21,\"Optimal\",IF(N21<E21,\"Ønskelig\",IF(N21<F21,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Ønskelig"}]
["ctHb",2.8,6.6,0.7,1.4,2.0999999999999996,19.559999999999999,0.3,"Optimal",19.32,0.45,"Optimal",19.62,0.36,"Optimal"]
["cNa+",0.7,1,0.17499999999999999,0.35,0.52499999999999991,127.09,0.23,"Ønskelig",127.28,0.41,"Minimum",128.63999999999999,0.59,"Ikke ok"]
["cK+",4.8,5.6,1.2,2.4,3.5999999999999996,5.5039999999999996,0.38,"Optimal",5.5,0.34,"Optimal",5.4960000000000004,0.36,"Optimal"]
["cCa2+",1.9,2.8,0.47499999999999998,0.95,1.4249999999999998,0.54200000000000004,0.96,"Minimum",0.54100000000000004,0.9,"Ønskelig",0.52,0.67,"Ønskelig"]
["cCl-",1.2,1.5,0.3,0.6,0.89999999999999991,67.33,0.98,"Ikke ok",null,null,null,66.12,0.91,"Ikke ok"]
["cGlu",5.7,6.9,1.425,2.85,4.2750000000000004,13.95,1.22,"Optimal",13.93,1.39,{"$f":"IF(B27<>\"\",(IF(K27<D27,\"Optimal\",IF(K27<E27,\"Ønskelig\",IF(K27<F27,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"},13.75,1.19,"Optimal"]
["cLac",27.2,16.7,6.8,13.6,20.399999999999999,10.38,4.57,"Optimal",10.210000000000001,4.09,{"$f":"IF(B28<>\"\",(IF(K28<D28,\"Optimal\",IF(K28<E28,\"Ønskelig\",IF(K28<F28,\"Minimum\",\"Ikke ok\")))),\"Mangler bio\")","v":"Optimal"},10.55,5.09,"Optimal"]
["cCreat",5.3,14.2,1.325,2.65,3.9749999999999996,null,null,null,null,null,null,520.16,3.68,"Minimum"]

{"sheet":"CV -735vs835","index":6,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,9,10,11],[1,0,3,0],[1,1,1,11],[2,3,2,5],[2,6,2,8],[2,9,2,11],[2,1,2,2],[9,0,11,0],[9,1,9,11],[10,1,10,2],[10,3,10,5],[10,6,10,8]]}
["Kontroll Level 1"]
["Analytt","Våre resultat"]
[null,"ABL 735 (MB)",null,"ABL 835 MB",null,null,"ABL PLAB",null,null,"ABL HOV"]
[null,"Nivå Stabil CV 735","CVa 735 (2011)","Nivå bd","CVbd","Måloppnåelse Impresisjon bio","Nivå bd","CVbd","Måloppnåelse Impresisjon","Nivå bd","CVbd","Måloppnåelse Impresisjon"]
["pO2",19.399999999999999,1.885,19.997,2.48,{"$f":"IF(E5<=$C5,\"Ok\",\"Ikke Ok\")","v":"Ikke Ok"},20.106999999999999,1.84,{"$f":"IF(H5<=$C5,\"Ok\",\"Ikke Ok\")","v":"Ok"},19.724,2.0299999999999998,{"$f":"IF(K5<=$C5,\"Ok\",\"Ikke Ok\")","v":"Ikke Ok"}]
["sO2",49.98,0.10299999999999999,50.091000000000001,0.06,{"$f":"IF(E6<=$C6,\"Ok\",\"Ikke Ok\")","v":"Ok"},50.09,0.06,{"$f":"IF(H6<=$C6,\"Ok\",\"Ikke Ok\")","v":"Ok"},50.008000000000003,0.06,{"$f":"IF(K6<=$C6,\"Ok\",\"Ikke Ok\")","v":"Ok"}]
["FCOHb",5.8979999999999997,4.8499999999999996,6.52,2.57,{"$f":"IF(E7<=$C7,\"Ok\",\"Ikke Ok\")","v":"Ok"},6.55,2.1,{"$f":"IF(H7<=$C7,\"Ok\",\"Ikke Ok\")","v":"Ok"},6.032,2.82,{"$f":"IF(K7<=$C7,\"Ok\",\"Ikke Ok\")","v":"Ok"}]
[]
["Kontroll Level 3"]
["Analytt","Våre resultat"]
[null,"ABL 735 (MB)",null,"ABL 835 MB",null,null,"ABL PLAB",null,null,"ABL HOV"]
[null,"Nivå Stabil CV 735","CVa 735 (2011)","Nivå bd","CVbd","Måloppnåelse Impresisjon bio","Nivå bd","CVbd","Måloppnåelse Impresisjon","Nivå bd","CVbd","Måloppnåelse Impresisjon"]
["pO2",8.9689999999999994,2.2400000000000002,9.31,1.37,{"$f":"IF(E13<=$C13,\"Ok\",\"Ikke Ok\")","v":"Ok"},9.7070000000000007,2.2000000000000002,{"$f":"IF(H13<=$C13,\"Ok\",\"Ikke Ok\")","v":"Ok"},9.7129999999999992,2.2400000000000002,{"$f":"IF(K13<=$C13,\"Ok\",\"Ikke Ok\")","v":"Ok"}]
["sO2",70.25,0.25,70.447999999999993,7.0000000000000007E-2,{"$f":"IF(E14<=$C14,\"Ok\",\"Ikke Ok\")","v":"Ok"},70.400000000000006,0,{"$f":"IF(H14<=$C14,\"Ok\",\"Ikke Ok\")","v":"Ok"},70.195999999999998,0.03,{"$f":"IF(K14<=$C14,\"Ok\",\"Ikke Ok\")","v":"Ok"}]
["FCOHb",20.72,1.23,21.25,0.28000000000000003,{"$f":"IF(E15<=$C15,\"Ok\",\"Ikke Ok\")","v":"Ok"},21.09,0.32,{"$f":"IF(H15<=$C15,\"Ok\",\"Ikke Ok\")","v":"Ok"},20.495999999999999,0.26,{"$f":"IF(K15<=$C15,\"Ok\",\"Ikke Ok\")","v":"Ok"}]