{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["ÚVOD","Příklad","Výpočet","Tolerance","Roztažnost","Validace","Běžné hodnoty"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":1,"defined_names":3,"comments":8,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"ÚVOD","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Příklad","index":1,"n_rows":85,"n_cols":7,"rows_kept":85,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Stanovení nejistoty koncentrace"]
[null,"kalibračního roztoku pesticidu"]
[null,"Zadání:"]
[]
[]
[]
[]
[null,"Objem,","Popis",null,"Opakovatelnost doplňování","Tolerance"]
[null," symbol",null,null," (směr. odchylka, ml)","  ± a(ml)"]
[null,"V1","pipeta 10 ml",null,0.012,"± 0,02"]
[null,"V2","odm. baňka 100 ml",null,0.024,"± 0,10"]
[]
[null,"Řešení:"]
{"$rows_empty":11}
[null,"nejistota zás. roztoku",null,"u",1.1547005383792517]
[null,null,null,"u/C",0.0011547005383792516]
{"$rows_empty":8}
[null,"Výpočet nejistoty zřeďovacího poměru"]
[]
[null,"Stanovení nejistoty objemu V1",null,null,"Pipeta 10 ml"]
[null,"Vstupy",null,null,"Hodnota","u","u2"]
[null,"Objem (ml)",null,null,10]
[null,"Tolerance (ml) ±",null,null,0.02,0.008164965809277261,6.666666666666668e-05]
[null,"Opakovatelnost doplnění, směrodatná odchylka",null,null,0.012,0.012,0.000144]
[null,"Roztažnost (K-1)","voda",0.00021,0.001,0.017320508075688773,0.00030000000000000003]
[null,null,"organika",0.001,null,"SUM",0.0005106666666666666]
[null,"Kolísání teploty ± °C (95%)",null,null,3,"SQRT",0.02259793500890439]
[{"$nulls":4},"Nejistota u(V1)",0.02259793500890439]
[{"$nulls":4},"Nejistota u(V1)/V1",0.002259793500890439]
[]
[]
[null,"Stanovení nejistoty objemu V2",null,null,"Odměrná baňka 100 ml"]
[null,"Vstupy",null,null,"Hodnota","u","u2"]
[null,"Objem (ml)",null,null,100]
[null,"Tolerance (ml) ±",null,null,0.1,0.040824829046386304,0.001666666666666667]
[null,"Opakovatelnost doplnění, směrodatná odchylka",null,null,0.024,0.024,0.000576]
[null,"Roztažnost (K-1)","voda",0.00021,0.001,0.17320508075688773,0.03]
[null,null,"organika",0.001,null,"SUM",0.03224266666666667]
[null,"Kolísání teploty ± °C (95%)",null,null,3,"SQRT",0.17956243111148465]
[{"$nulls":4},"Nejistota u(V2)",0.17956243111148465]
[{"$nulls":4},"Nejistota u(V2)/V2",0.0017956243111148466]
[]
[null,"Ředění f = V2/V1"]
[null,"V1",10]
[null,"V2",100]
[null,"Nejistota u(V1)/V1",0.002259793500890439,5.106666666666666e-06]
[null,"Nejistota u(V2)/V2",0.0017956243111148466,3.2242666666666672e-06]
[null,null,"SUM",8.330933333333334e-06]
[null,null,"SQRT",0.002886335623820164]
[null,null,"f = V2/V1",10]
[null,null,"u(f)/f",0.002886335623820164]
{"$rows_empty":9}
[null,"Shrnutí"]
[null,"koncentrace kalibr. roztoku (mg/l)",null,null,100]
[null,"nejistota kalibračního roztoku uk/ck",null,null,0.0031087403665579195]
[null,"nejistota kalibračního roztoku uk (mg/l)",null,null,0.31087403665579194]
[null,"rozšířená nejistota U (mg/l)",null,null,0.6217480733115839]
[]
[null,"Výsledek"]

{"sheet":"Výpočet","index":2,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["Instrukce jsou uvedeny  poznámkách, které se vyvolají umístěním kurzoru na červenou značku buňky "]
[]
[]
[null,"Stanovení nejistoty objemu a ředění"]
[null,"pro výpočet nejistoty měření dle ISO"]
[]
[null,"Stanovení nejistoty objemu V1",null,null,"Pipeta  10 ml"]
[null,"Vstupy",null,null,"Hodnota","u","u2"]
[null,"Objem (ml)",null,null,10]
[null,"Tolerance (ml) ±",null,null,0.02,0.008164965809277261,6.666666666666668e-05]
[null,"Opakovatelnost doplnění, směrodatná odchylka",null,null,0.012,0.012,0.000144]
[null,"Roztažnost (K-1)","voda",0.00021,0.001,0.017320508075688773,0.00030000000000000003]
[null,null,"organika",0.001,null,"SUM",0.0005106666666666666]
[null,"Kolísání teploty ± °C ",null,null,3,"SQRT",0.02259793500890439]
[{"$nulls":4},"Nejistota u(V1)",0.02259793500890439]
[{"$nulls":4},"Nejistota u(V1)/V1",0.002259793500890439]
[]
[]
[null,"Stanovení nejistoty objemu V2",null,null,"Odměrná baňka 100 ml"]
[null,"Vstupy",null,null,"Hodnota","u","u2"]
[null,"Objem (ml)",null,null,100]
[null,"Tolerance (ml) ±",null,null,0.1,0.040824829046386304,0.001666666666666667]
[null,"Opakovatelnost doplnění, směrodatná odchylka",null,null,0.024,0.024,0.000576]
[null,"Roztažnost (K-1)","voda",0.00021,0.001,0.17320508075688773,0.03]
[null,null,"organika",0.001,null,"SUM",0.03224266666666667]
[null,"Kolísání teploty ± °C ",null,null,3,"SQRT",0.17956243111148465]
[{"$nulls":4},"Nejistota u(V2)",0.17956243111148465]
[{"$nulls":4},"Nejistota u(V2)/V2",0.0017956243111148466]
[]
[null,"Ředění f = V2/V1"]
[null,"V1",10]
[null,"V2",100]
[null,"Nejistota u(V1)/V1",0.002259793500890439,5.106666666666666e-06]
[null,"Nejistota u(V2)/V2",0.0017956243111148466,3.2242666666666672e-06]
[null,null,"SUM",8.330933333333334e-06]
[null,null,"SQRT",0.002886335623820164]
[null,null,"f = V2/V1",10]
[null,null,"u(f)/f",0.002886335623820164]

{"sheet":"Tolerance","index":3,"n_rows":110,"n_cols":10,"rows_kept":110,"cut":false,"hidden":false,"merged":[[47,2,48,2],[69,2,70,2],[99,7,99,9]],"flags":["formulas_cached_only"]}
[null,"TOLERANCE ODMĚRNÉHO NÁDOBÍ"]
[]
[]
[]
[]
[]
[]
[null,"Nedělené pipety (ČSN EN ISO 648:2009, OOP č. 0111-OOP-C030-13, tabulka 4)  "]
[]
[null,"Jmenovitý objem ",null,null,"Největší dovolená chyba objemu "]
[{"$nulls":4},"(cm3)"]
[null,"(cm3)",null,"Třída přesnosti A",null,"Třída přesnosti B"]
[null,0.5,null,null,0.005,null,0.01]
[null,1,null,null,0.008,null,0.015]
[null,2,null,null,0.01,null,0.02]
[null,5,null,null,0.015,null,0.03]
[null,10,null,null,0.02,null,0.04]
[null,20,null,null,0.03,null,0.06]
[null,25,null,null,0.03,null,0.06]
[null,50,null,null,0.05,null,0.1]
[null,100,null,null,0.08,null,0.15]
[]
[]
[]
[null,"Dělené  pipety  (ČSN EN ISO 835:2007, OOP č. 0111-OOP-C030-13, tabulka 3)"]
[]
[null,"Jmenovitý objem ","Nejmenší dělení stupnice",null,null,"Největší dovolená odchylka objemu "]
[{"$nulls":5},"(± ml)"]
[null,"(ml)","(ml)",null,"Třída přesnosti A a AS",null,"Třída přesnosti B"]
[null,0.1,0.01,null,null,0.006,null,0.01]
[null,0.2,0.01,null,null,0.006,null,0.01]
[null,0.5,0.01,null,null,0.006,null,0.01]
[null,1,0.01,null,null,"0,007",null,0.01]
[null,1,0.1,null,null,"0,007",null,0.01]
[null,2,0.02,null,null,"0,010",null,"0,02"]
[null,2,"0,10",null,null,"0,010",null,"0,02"]
[null,5,0.05,null,null,"0,030",null,"0,05"]
[null,5,"0,10",null,null,"0,030",null,"0,05"]
[null,10,"0,1",null,null,"0,05",null,"0,1"]
[null,20,"0,1",null,null,"0,1",null,"0,2"]
[null,25,0.1,null,null,"0,1",null,"0,2"]
[null,25,0.2,null,null,"0,1",null,"0,2"]
[]
[]
[]
[null,"Odměrné baňky úzkohrdlé (ČSN ISO 1042:1999, OOP č. 0111-OOP-C030-13, tabulka 1)"]
[]
[null,"Jmenovitý objem","Vnitřní průměr hrdla",null,null,"Největší dovolená chyba objemu "]
[{"$nulls":6},"(ml)"]
[null,"(ml)","(mm)",null,null,"třída A",null,"třída B"]
[null,"1","7 ±1",null,null,"±0,025",null,"±0,050"]
[null,"2","7 ±1",null,null,"±0,025",null,"±0,050"]
[null,"5","7 ±1",null,null,"±0,025",null,"±0,050"]
[null,"10","7 ±1",null,null,"±0,025",null,"±0,050"]
[null,"20","9 ±1",null,null,"±0,040",null,"±0,080"]
[null,"25","9 ±1",null,null,"±0,040",null,"±0,080"]
[null,"50","11 ±1",null,null,"±0,060",null,"±0,120"]
[null,"100","13 ±1",null,null,"±0,100",null,"±0,200"]
[null,"200","15 ±1,5",null,null,"±0,150",null,"±0,300"]
[null,"250","15 ±1,5",null,null,"±0,150",null,"±0,300"]
[null,"500","19 ±2",null,null,"±0,250",null,"±0,500"]
[null,"1000","23 ±2",null,null,"±0,400",null,"±0,800"]
[null,"2000","27,5 ±1,5",null,null,"±0,600",null,"±1,200"]
[null,"5000","38 ±3",null,null,"±1,200",null,"±2,400"]
[]
[]
[]
[null,"Odměrné baňky širokohrdlé podle (ČSN ISO 1042:1999, OOP č. 0111-OOP-C030-13, tabulka 2)"]
[]
[null,"Jmenovitý objem","Vnitřní průměr hrdla",null,null,"Největší dovolená chyba objemu "]
[{"$nulls":5},"(ml)"]
[null,"(ml)","(mm)",null,null,"třída A",null,"třída B"]
[null,"1","9 ±1",null,null,"±0,040",null,"±0,080"]
[null,"10","9 ±1",null,null,"±0,040",null,"±0,080"]
[null,"20","11 ±1",null,null,"±0,060",null,"±0,120"]
[null,"25","11 ±1",null,null,"±0,060",null,"±0,120"]
[null,"50","13 ±1",null,null,"±0,100",null,"±0,200"]
[null,"1000","27,5 ±2,5",null,null,"±0,600",null,"±1,200"]
[]
[]
[null,"Odměrné válce Část 1: Odměrné válce vysokého tvaru s výlevkou "]
[null,null,"nebo hrdlem na zátku podle  ČSN EN ISO 4788 (2006)"]
[]
[null,"Jmenovitý objem","Celková výška",null,null,"Dělení stupnice",null,"Největší dovolená chyba objemu"]
[{"$nulls":8},"(± ml)"]
[null,"(ml)",null,"(mm)",null,"(ml)",null,"Třída A",null,"Třída B"]
[null,5,null,115,null,0.1,null,0.05,null,0.1]
[null,10,null,140,null,0.2,null,0.1,null,0.2]
[null,25,null,170,null,0.5,null,0.25,null,0.5]
[null,50,null,200,null,1,null,0.5,null,1]
[null,100,null,260,null,1,null,0.5,null,1]
[null,250,null,335,null,2,null,1,null,2]
[null,500,null,390,null,5,null,2.5,null,5]
[null,1000,null,470,null,10,null,5,null,10]
[null,2000,null,570,null,20,null,10,null,20]
[]
[]
[null,"Odměrné válce Část 2: Odměrné válce se nízkého tvaru s výlevkou podle  ČSN EN ISO 4788 (2006)"]
[]
[null,"Jmenovitý objem","Celková výška",null,null,"Dělení stupnice",null,"Největší dovolená chyba objemu"]
[null,"(ml)",null,"(mm)",null,"(ml)",null,null,"(± ml)"]
[null,5,null,80,null,0.5,null,null,0.2]
[null,10,null,100,null,1,null,null,0.3]
[null,25,null,125,null,1,null,null,0.5]
[null,50,null,150,null,"1 nebo 2",null,null,1]
[null,100,null,170,null,2,null,null,1]
[null,250,null,220,null,5,null,null,2]
[null,500,null,255,null,10,null,null,5]
[null,1000,null,295,null,20,null,null,10]
[null,2000,null,345,null,50,null,null,20]

{"sheet":"Roztažnost","index":4,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"TEPELNÉ VLASTNOSTI KAPALIN 1"]
[]
[null,null,null,"je teplotní součinitel objemové roztažnosti"]
[]
[null,null,"Kapalina"]
[]
[null,null,"aceton",null,null,1.49]
[null,null,"benzen",null,null,1.23]
[null,null,"diethylether",null,null,1.62]
[null,null,"ethylalkohol",null,null,1.1]
[null,null,"glycerin",null,null,0.5]
[null,null,"chlorid uhličitý",null,null,1.22]
[null,null,"chloroform",null,null,1.28]
[null,null,"kyselina octová",null,null,1.07]
[null,null,"methylalkohol",null,null,1.2]
[null,null,"pentan",null,null,1.54]
[null,null,"sirouhlík",null,null,1.18]
[null,null,"toluen",null,null,1.11]
[null,null,"voda",null,null,0.207]
[null,null,"xylen ",null,null,0.99]
[]
[null,"Literatura:"]
[null,"1.  ","Brož J., Roskovec V., Valouch M.: Fyzikální a matematické tabulky."]
[null,null,"SNTL, Praha 1980, str. 66. "]
[]
[null,"Poznámka:"]
[null,null,"Pokud je třeba zpřesnit odhad vlivu tepelné roztažnosti vodných roztoků, "]
[null,null,"je možné potřebné údaje najít v běžných analytických tabulkách."]
[null,null,"(Např. Sýkora V., Zátka V.: Příruční tabulky pro chemiky. SNTL,"]
[null,null," Praha 1960, str. 56; Küster-Thiel: Chemicko-analytické výpočetní tabulky. "]
[null,null," Academia, Praha 1988, str. 84)."]

{"sheet":"Validace","index":5,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,25,11]],"flags":["formulas_cached_only"]}
["Instrukce jsou uvedeny v listu \"Úvod\" a poznámkách, které se vyvolají umístěním kurzoru na červenou značku buňky "]
[]
[]
[null,"Validace softwaru"]
[null,"pro výpočet nejistoty měření dle ISO1,2"]
[]
[]
[]
[]
[]
[]
[null,"Stanovení nejistoty objemu V1",null,null,"Odměrná baňka 100 ml "]
[null,"Vstupy",null,null,"Hodnota","u","u2"]
[null,"Objem (ml)",null,null,100]
[null,"Tolerance (ml) ±",null,null,0.1,0.040824829046386304,0.001666666666666667]
[null,"Opakovatelnost doplnění, směrodatná odchylka",null,null,0.02,0.02,0.0004]
[null,"Roztažnost (K-1)","voda",0.00021,0.00021,0.04849742261192857,0.0023520000000000004]
[null,null,"organika",0.001,null,"SUM",0.004418666666666668]
[null,"Kolísání teploty ± °C ",null,null,4,"SQRT",0.06647305218407432]
[{"$nulls":4},"Nejistota u(V1)",0.06647305218407432]
[null,"Odkaz [2], příklad A1 str. 49 poskytuje",null,null,"Nejistota u(V1)",0.07]
[]
[]
[null,"Literatura:"]
[]
[null,"český překlad zaveden jako TNI 01 4109-3:2011 Nejistoty měření - Část 3: Pokyn pro vyjádření nejistoty měření (GUM:1995).\n"]

{"sheet":"Běžné hodnoty","index":6,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,4,14,5],[7,5,11,5],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[7,0,11,0],[7,1,11,1],[7,2,11,2],[7,4,11,4],[2,4,2,5],[4,0,6,0],[4,1,6,1],[4,2,6,2],[4,4,6,4],[4,5,6,5]],"flags":["formulas_cached_only"]}
["Běžné  hodnoty nejistot objemových operací 1"]
[]
["Stanoveno","Složky nejistoty","Příčina","Metoda stanovení","Typická hodnota"]
[{"$nulls":4},"příklad","Hodnota"]
["objem (kapaliny)","nejistota kalibrace","omezená přesnost [accuracy] kalibrace","uvedeno ve specifikaci výrobce, převedeno na směrodatnou odchylku","10 ml (třída A)","0.02 / √3 = 0,01 ml                              (předpokládá se rovnoměrné rozdělení)"]
[null,null,null,"Pro skleněné nádobí objemu V třídy A podle ASTM je tato mez přibližně V0,6/200"]
[]
[null,"teplota","odchylky teploty od teploty kalibrace způsobuje rozdíl objemu při standardní teplotě ","ΔTα/(2√3) poskytuje relativní směrodatnou odchylku, kde ΔT je možný teplotní rozsah a α součinitel teplotní roztažnosti kapaliny","100 ml voda","0,03 ml pro práci v rozmezí 3 ºC od uvedené pracovní teploty "]
[null,null,null,"α je přibližně"]
[null,null,null,"2 x 10-4 K-1 pro vodu a"]
[null,null,null,"1 x 10-3 K-1 pro org. kapaliny"]
[]
[null,"variabilita mezi jednotlivými odměřováními","různá","Směrodatná odchylka z opakovaných kontrolních odměřování (zjištěna vážením)","25 ml pipeta","opakované naplnění / zvážení:"]
[{"$nulls":5},"s = 0,0092 ml"]
[]
[null,"Literatura:"]
[null,"1. Kvalimetrie 19. Stanovení nejistoty analytického měření. Eurachem-ČR, Praha 2014"]
[null,"    Příloha G. ISBN 978-80-86322-07-0 "]
[null,"    Překlad Quantifying Uncertainty in Analytical Measurement.Measurement. 3rd Edition  "]
[null,"     EURACHEM/CITAC Guide (2012)."]