{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Forside","Beskrivelse av forsøket","Replikater","Konklusjon"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":26,"comments":1,"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":"Forside","index":0,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,2,2,8],[8,3,8,8],[9,3,10,8],[11,3,11,8],[12,3,12,8]]}
[]
[]
[null,null,"Holdbarhetsforsøk"]
[]
[null,null,"Modell:","Batch-metode",null,null,"(basert på en eldre utgave av regneark)"]
[]
[]
[null,null,"Forsøket er utført ved:"]
[null,null,"Utført I perioden:",2015]
[null,null,"Kontaktperson:","Siw Berbu"]
[null,null,"(navn, epost eller telefonnr.)"]
[null,null,"Navn på komponent:","Kobalamin"]
[null,null,"Prøvemateriale:","Serum"]

{"sheet":"Beskrivelse av forsøket","index":1,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,0,42,3]]}
["BESKRIVELSE AV FORSØKET"]
["S-Kobalamin"]
["Komponent"]
["Hvilket instrument er benyttet?"]
["Cobas 8000, e602"]
[]
["Hvilken analysemetode er benyttet?"]
["S-vitamin B12"]
[]
["Hvilket reagens er benyttet?"]
[]
[]
["Er forsøket gjennomført under tilsvarende betingelser som de som gjelder ved vanlig rutinedrift (kryss av): "]
[null,"ja, gjennomført under rutinebetingelser "]
[null,"ja, rutinebetingelser er simulert "]
[null,"nei"]
[]
["Hvilke transportformer er testet/simulert?"]
[null,"Postgang"]
[null,"Hentetjeneste"]
[null,"Rørpost"]
[null,"Annet: "]
[]
["NB! Sett inn flere rader dersom du trenger det. "]
["Gi en beskrivelse av hver betingelse:","Betingelse 0 (Ref)","3 dager i kjøleskap","4 dager i kjøleskap"]
["Prøverør type"]
["Tid fra prøvetaking til sentrifugering (min.)"]
["Tid fra prøvetaking til analysering (min/timer/dager/uker)"]
["Tid fra sentrifugering til analysering (min/timer/dager/uker)"]
["Temperatur før sentrifugering (◦C)"]
["Temperatur etter sentrifugering (◦C)"]
["Sentrifugeringsegenskaper*:"]
["Hastighet (G)"]
["Temperatur (◦C)"]
["Tid (min.)"]
["Spesielle betingelser"]
["Luftfuktighet (g/m3)"]
["pH"]
["Bruk av tørris (bare noter hvis brukt)"]
["Har prøven vært frosset? Oppgi temperatur","frosset samme dag som prøvetaking","frosset etter 3 dager i kjøleskap","frosset etter 4 dager i kjøleskap"]
["Andre betingelser (oppgi)"]
[]
["*Dersom det er brukt dobbel sentrifugeringstid angis hastighet / tid / temperatur både for 1. og 2. sentrifugering"]

{"sheet":"Replikater","index":2,"n_rows":66,"n_cols":26,"rows_kept":66,"cut":false,"hidden":false,"merged":[[62,11,62,15],[63,11,63,15],[64,11,64,15],[65,11,65,15],[62,7,62,10],[63,7,63,10],[64,7,64,10],[65,7,65,10],[61,11,61,15],[56,7,56,10],[57,7,57,10],[58,7,58,10],[59,7,59,10],[60,7,60,10],[61,7,61,10],[56,11,56,15],[57,11,57,15],[58,11,58,15],[59,11,59,15],[60,11,60,15],[65,1,65,6],[1,1,2,1],[1,0,2,0],[56,1,56,6],[57,1,57,6],[58,1,58,6],[59,1,59,6],[60,1,60,6],[61,1,61,6],[62,1,62,6],[63,1,63,6],[64,1,64,6],[3,13,3,22],[30,13,30,22],[1,2,2,2],[1,3,2,3],[1,4,2,4],[21,13,21,22],[1,22,2,22],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,20,2,20],[12,13,12,22],[1,21,2,21],[1,14,2,14],[31,2,38,7],[3,0,3,8],[12,0,12,8],[30,0,30,7],[21,0,21,8],[1,15,2,15],[1,16,2,16],[1,18,2,18],[1,19,2,19],[0,0,0,6],[0,7,0,9],[1,9,2,9],[1,7,2,7],[1,8,2,8],[1,17,2,17]]}
["Stabilitet med replikater",null,null,null,null,null,null,"p (for ensidig test): ",null,null,0.05,{"$f":"\" dvs. \"&100*(1-2*p)&\" % konfidensintervall\"","v":" dvs. 90 % konfidensintervall"}]
["Tid nr","Tid","Avvik (D)","D-U","D+U","Mål 1","Mål 2","Mt-Mo","M","s","CV","N","U/M","R1","R2","R3","R4","R5","R6","R7","R8","R9","R10"]
[null,null,null,null,null,0.05,0.1]
["Prøve 1",null,null,null,null,null,null,null,null,{"$f":"IF(L4=0,\"\",SQRT(SUM(Z5:Z12)/L4))","v":6.0122714016756955},{"$f":"IF(L4=0,\"\",J4/M1_)","v":1.3406483079150192E-2},{"$f":"SUM(L5:L12)-COUNT(L5:L12)","v":27},{"$f":"IF(L4=0,\"\",CV1_^2/L5+uco^2)","v":1.7973378855154041E-5}]
[0,0,0,null,null,{"$f":"F3","v":0.05},{"$f":"G3","v":0.1},{"$f":"IF(L5=\"\",\"\",I5-M1_)","v":0},{"$f":"IF(L5=\"\",\"\",AVERAGE(N5:W5)*Mc/I32)","v":448.46000000000004},{"$f":"IF(L5=\"\",\"\",STDEV(N5:W5))","v":7.5239174193589706},{"$f":"IF(L5=\"\",\"\",J5/I5)","v":1.6777231903311266E-2},{"$f":"IF(COUNT(N5:W5)=0,\"\",COUNT(N5:W5))","v":10},{"$f":"IF(L5=\"\",\"\",SQRT(CV1_^2/L5+M32^2+M$4)*TINV(2*p,f1_))","v":1.0212170629990552E-2},455.9,449.3,445.8,453,445.4,436.2,453,435.9,454.4,455.7,{"$f":"-F5","v":-0.05},{"$f":"-G5","v":-0.1},{"$f":"IF(L5=\"\",\"\",J5^2*(L5-1))","v":509.48400000000015}]
[1,24,{"$f":"IF(L6=\"\",\"\",I6/M1_-1)","v":""},{"$f":"IF(L6=\"\",\"\",C6-M6)","v":""},{"$f":"IF(L6=\"\",\"\",C6+M6)","v":""},{"$f":"F5","v":0.05},{"$f":"G5","v":0.1},"","",{"$f":"IF(L6=\"\",\"\",STDEV(N6:W6))","v":""},"",{"$f":"IF(COUNT(N6:W6)=0,\"\",COUNT(N6:W6))","v":""},{"$f":"IF(L6=\"\",\"\",SQRT((CV1_^2/L6+M33^2)*(I6/M1_*Mc/I33)^2+M$4)*TINV(2*p,f1_))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"-F6","v":-0.05},{"$f":"-G6","v":-0.1},""]
[2,48,"","","",{"$f":"F6","v":0.05},{"$f":"G6","v":0.1},"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[3,72,4.5489006823349332E-3,-5.6865233770674924E-3,1.4784324741737359E-2,0.05,0.1,2.0399999999999636,450.5,6.2458875359000112,1.3864345251720336E-2,10,1.0235424059402426E-2,455.8,448.4,446.2,447.9,464.4,449.7,442.5,453.5,445.4,451.2,-0.05,-0.1,351.1]
[4,96,2.0871426660125758E-2,1.0552134429039298E-2,3.1190718891212218E-2,0.05,0.1,9.3599999999999568,457.82,3.5807510075091522,7.8213075171664672E-3,10,1.031929223108646E-2,462.5,463.3,450.9,457.6,458.2,457.1,458.9,458.5,456.9,454.3,-0.05,-0.1,115.39600000000029]
[5,null,"","","",0.05,0.1,"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[6,null,"","","",0.05,0.1,"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[7,null,"","","",0.05,0.1,"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
["Prøve 2",null,null,null,null,null,null,null,null,{"$f":"IF(L13=0,\"\",SQRT(SUM(Z14:Z21)/L13))","v":6.8115555236562395},{"$f":"IF(L13=0,\"\",J13/M2_)","v":1.5632514455411011E-2},{"$f":"SUM(L14:L21)-COUNT(L14:L21)","v":27},{"$f":"IF(L13=0,\"\",CV2_^2/L14+uco^2)","v":2.4437550819863425E-5}]
[0,{"$f":"B5","v":0},{"$f":"IF(L14=\"\",\"\",I14/M2_-1)","v":0},null,null,{"$f":"F3","v":0.05},{"$f":"G3","v":0.1},{"$f":"IF(L14=\"\",\"\",I14-M2_)","v":0},{"$f":"IF(L14=\"\",\"\",AVERAGE(N14:W14)*Mc/I32)","v":435.73},{"$f":"IF(L14=\"\",\"\",STDEV(N14:W14))","v":9.0697360000780041},{"$f":"IF(L14=\"\",\"\",J14/I14)","v":2.0815036834916128E-2},{"$f":"IF(COUNT(N14:W14)=0,\"\",COUNT(N14:W14))","v":10},{"$f":"IF(L14=\"\",\"\",SQRT(CV2_^2/L14+M32^2+M$13)*TINV(2*p,f2_))","v":1.1907813857813816E-2},421.5,433.4,429.5,422.8,433.6,447.4,443.5,439,443.2,443.4,{"$f":"-F14","v":-0.05},{"$f":"-G14","v":-0.1},{"$f":"IF(L14=\"\",\"\",J14^2*(L14-1))","v":740.34099999999864}]
[1,{"$f":"IF(B6=\"\",\"\",B6)","v":24},"",{"$f":"IF(L15=\"\",\"\",C15-M15)","v":""},{"$f":"IF(L15=\"\",\"\",C15+M15)","v":""},{"$f":"F14","v":0.05},{"$f":"G14","v":0.1},"","",{"$f":"IF(L15=\"\",\"\",STDEV(N15:W15))","v":""},"",{"$f":"IF(COUNT(N15:W15)=0,\"\",COUNT(N15:W15))","v":""},"",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[2,{"$f":"IF(B7=\"\",\"\",B7)","v":48},"","","",{"$f":"F15","v":0.05},{"$f":"G15","v":0.1},"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[3,72,6.0014228995019847E-2,4.8106415137206031E-2,7.1922042852833656E-2,0.05,0.1,26.149999999999977,461.88,3.532012331675972,7.6470345797089549E-3,10,1.1907813857813816E-2,457.1,457.7,465.5,461.8,466.1,461.1,460.8,467.8,460.7,460.2,-0.05,-0.1,112.27600000000022]
[4,96,4.6669267665756298E-2,3.4761453807942481E-2,5.8577081523570114E-2,0.05,0.1,20.335199999999986,456.0652,6.6675815505573963,1.461979899048951E-2,10,1.1907813857813816E-2,473.5,454.6,451.9,450.9,458.6,458.7,453.3,453.7,453.452,452,-0.05,-0.1,400.10979360000033]
[5,"","","","",0.05,0.1,"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[6,"","","","",0.05,0.1,"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[7,"","","","",0.05,0.1,"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
["Prøve 3",null,null,null,null,null,null,null,null,{"$f":"IF(L22=0,\"\",SQRT(SUM(Z23:Z30)/L22))","v":5.4256387232800138},{"$f":"IF(L22=0,\"\",J22/M3_)","v":1.2490247757268844E-2},{"$f":"SUM(L23:L30)-COUNT(L23:L30)","v":27},{"$f":"IF(L22=0,\"\",CV3_^2/L23+uco^2)","v":1.560062890379594E-5}]
[0,{"$f":"B14","v":0},{"$f":"IF(L23=\"\",\"\",I23/M3_-1)","v":0},null,null,{"$f":"F12","v":0.05},{"$f":"G12","v":0.1},{"$f":"IF(L23=\"\",\"\",I23-M3_)","v":0},{"$f":"IF(L23=\"\",\"\",AVERAGE(N23:W23)*Mc/I32)","v":434.39000000000004},{"$f":"IF(L23=\"\",\"\",STDEV(N23:W23))","v":7.3957119708352383},{"$f":"IF(L23=\"\",\"\",J23/I23)","v":1.7025511569868639E-2},{"$f":"IF(COUNT(N23:W23)=0,\"\",COUNT(N23:W23))","v":10},{"$f":"IF(L23=\"\",\"\",SQRT(CV3_^2/L23+M32^2+M$22)*TINV(2*p,f3_))","v":9.5142432623852267E-3},429.3,441.1,434.1,444.7,431.4,434.8,430.8,446.3,425.9,425.5,{"$f":"-F23","v":-0.05},{"$f":"-G23","v":-0.1},{"$f":"IF(L23=\"\",\"\",J23^2*(L23-1))","v":492.2690000000008}]
[1,{"$f":"IF(B15=\"\",\"\",B15)","v":24},"",{"$f":"IF(L24=\"\",\"\",C24-M24)","v":""},{"$f":"IF(L24=\"\",\"\",C24+M24)","v":""},{"$f":"F23","v":0.05},{"$f":"G23","v":0.1},"","",{"$f":"IF(L24=\"\",\"\",STDEV(N24:W24))","v":""},"",{"$f":"IF(COUNT(N24:W24)=0,\"\",COUNT(N24:W24))","v":""},"",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[2,{"$f":"IF(B16=\"\",\"\",B16)","v":48},"","","",{"$f":"F24","v":0.05},{"$f":"G24","v":0.1},"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[3,72,3.9365547089020847E-3,-5.577688553483142E-3,1.3450797971287311E-2,0.05,0.1,1.7099999999999795,436.1,3.9194670839569752,8.9875420407176682E-3,10,9.5142432623852267E-3,429.6,437.7,434.1,441,439,436.8,436.1,441.5,431.4,433.8,-0.05,-0.1,138.25999999999974]
[4,96,-5.1888855636639919E-2,-6.1403098899025149E-2,-4.2374612374254689E-2,0.05,0.1,-22.54000000000002,411.85,4.2724570084307327,1.0373818158141878E-2,10,9.5142432623852267E-3,409.6,408.7,402.7,411.1,415.4,412,416,411,416,416,-0.05,-0.1,164.285]
[5,"","","","",0.05,0.1,"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[6,"","","","",0.05,0.1,"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
[7,"","","","",0.05,0.1,"","","","","","",null,null,null,null,null,null,null,null,null,null,-0.05,-0.1,""]
["Kontrollprøve",null,null,null,null,null,null,null,{"$f":"AVERAGE(I32:I39)","v":1},{"$f":"IF(L31=0,0,SQRT(SUM(Z32:Z39)/L31))","v":0},{"$f":"J31/Mc","v":0},{"$f":"SUM(L32:L39)-COUNT(L32:L39)","v":0},{"$f":"IF(L31=0,0,CVc/SQRT(L32))","v":0}]
[0,{"$f":"B14","v":0},"Kontrollprøver brukes bare hvis det er umulig å finne en måte å oppbevare prøvene stabilt på!",null,null,null,null,null,{"$f":"IF(L$31=0,1,IF(L32=\"\",\"\",AVERAGE(N32:W32)))","v":1},{"$f":"IF(L32=\"\",\"\",IF(L32>1,STDEV(N32:W32),0))","v":""},{"$f":"IF(L32=\"\",\"\",J32/I32)","v":""},{"$f":"IF(COUNT(N32:W32)=0,\"\",COUNT(N32:W32))","v":""},{"$f":"IF(L32=\"\",0,CVc/SQRT(L32))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L32=\"\",\"\",J32^2*(L32-1))","v":""}]
[1,{"$f":"B15","v":24},null,null,null,null,null,null,{"$f":"IF(L$31=0,1,IF(L33=\"\",\"\",AVERAGE(N33:W33)))","v":1},{"$f":"IF(L33=\"\",\"\",IF(L33>1,STDEV(N33:W33),0))","v":""},"",{"$f":"IF(COUNT(N33:W33)=0,\"\",COUNT(N33:W33))","v":""},{"$f":"IF(L33=\"\",0,CVc/SQRT(L33))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[2,48,null,null,null,null,null,null,1,"","","",{"$f":"IF(L34=\"\",0,CVc/SQRT(L34))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,""]
[3,72,null,null,null,null,null,null,1,"","","",0,null,null,null,null,null,null,null,null,null,null,null,null,""]
[4,96,null,null,null,null,null,null,1,"","","",0,null,null,null,null,null,null,null,null,null,null,null,null,""]
[5,"",null,null,null,null,null,null,1,"","","",0,null,null,null,null,null,null,null,null,null,null,null,null,""]
[6,"",null,null,null,null,null,null,1,"","","",0,null,null,null,null,null,null,null,null,null,null,null,null,""]
[7,"",null,null,null,null,null,null,1,"","","",0,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Betegnelse",null,null,null,null,null,"Prøve",null,null,null,"Kontroll"]
[1,"Middelverdi for tid i",null,null,null,null,null,"Mpi",null,null,null,"Mki"]
[2,"Middel av middelverdier",null,null,null,null,null,null,null,null,null,"K"]
[3,"Standard avvik for tid i",null,null,null,null,null,"Spi",null,null,null,"Ski"]
[4,"Antall replikater for tid i",null,null,null,null,null,"Npi",null,null,null,"Nki"]
[5,"Antall målte verdier",null,null,null,null,null,"Np = SNpi",null,null,null,"Nk = SNki"]
[6,"Antall tidspunkter",null,null,null,null,null,"t",null,null,null,"t"]
[7,"Felles S",null,null,null,null,null,"Sp = SSpi(Npi-1)/(Np-t)",null,null,null,"Sk = SSki(Nki-1)/(Nk-t)"]
[8,"Felles CV",null,null,null,null,null,"CVp = Sp/Mpo",null,null,null,"CVk = Sk/Mko"]
[9,"Relativ standard usikkerhet (uM/M)",null,null,null,null,null,"uMpi/Mpi @ CVp/√Npi",null,null,null,"uMki/Mki @ CVk/√Nki"]

{"sheet":"Konklusjon","index":3,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,12,12],[15,1,21,12]]}
[]
[]
[null,"Vurdering av funn og annen viktig informasjon til forsøket"]
[null,"To av de tre prøvene viser økende konsentrasjon, en prøve viser redusert konsentrasjon i forhold til 0-verdi. Mean samt hele konfidensintervall for alle 3 prøver er innenfor akseptkrensen vår på ±10% ved alle tidspunkt."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Konklusjon"]
[null,"Holdbarhet oppfyller kravet vårt. Vitamin B12 i serum anses som holdbart i 4 dager ved 2-8 °C."]
[]
[]
[]
[]
[]
[]
[null,"Dato og signatur: 08.10.2015 LS"]