{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Vstupní parametry a výsledky","Inicializace","Spalovací proces","Výpočet trati vzduchu","Výkonové křivky - vzduch","Výpočet trati plynu","Výkonové křivky - plyn"],"not_rendered":{"charts":8,"images":3,"macros":1,"external_links":1,"defined_names":27,"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":"Vstupní parametry a výsledky","index":0,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[12,0,12,3],[13,6,13,9],[3,7,4,7],[3,6,4,6],[0,6,0,9],[7,6,7,9],[0,0,0,3],[6,0,6,3]]}
["1. Parametry okysličovadla",null,null,null,null,null,"Výsledky"]
["Teplota okolního vzduchu","Tvz",20,"°C",null,null,"Průtok vzduchu","Qvz",{"$f":"'Spalovací proces'!C28","v":275.84141564381338},"mN3/h"]
["Tlak vzduchu za dmychadlem","pvz",98.58,"kPa",null,null,"Průtok spalin","Qspal",{"$f":"'Spalovací proces'!C39","v":290.64015061806288},"mN3/h"]
["Relativní vlhkost okolí","ϕ",50,"%",null,null,"Výkon hořáku","PH",{"$f":"'Spalovací proces'!C55","v":147.28756014365226},"kW"]
[null,null,null,null,null,null,null,null,{"$f":"I4/150*100","v":98.191706762434833},"%"]
[]
["2. Uživatelské parametry"]
["Požadovaná teplota","Tpož",900,"°C",null,null,"Inicializační hodnoty"]
["Přebytek okysličovadla","α",1.9343643029321382,"[-]",null,null,"Odhadnutý průtok ZP","QZP_X",{"$f":"Inicializace!E9","v":14.78197111036253},"mN3/h"]
["Přebytek O2 ve spalinách","O2",10,"%",null,null,"Odhadnutý průtok vzduchu","Qvz",{"$f":"Inicializace!D23","v":275.84141564381338},"mN3/h"]
[null,null,null,null,null,null,"Otáčky dmychadla vzduchu","nvz",{"$f":"Inicializace!D27","v":99.986996847496087},"%"]
[]
["3. Palivo"]
["Hmotnostní průtok paliva","Qm_pal",10.790838910564647,"kg/h",null,null,"Kontrolní hodnoty"]
["Objemový průtok paliva","Qpal",14.78197111036253,"mN3/h",null,null,"α z Množství O2 ve spalinách","α",{"$f":"'Spalovací proces'!C51","v":1.9343643029321382},"[-]"]
[null,null,null,null,null,null,"Množství O2 ve spalinách z α ","O2",{"$f":"'Spalovací proces'!C50","v":10},"%"]
[null,null,null,null,null,null,"Průtok paliva z teploty","QZP_teor.",{"$f":"Inicializace!E5","v":11.370747007971177},"mN3/h"]

{"sheet":"Inicializace","index":1,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,2,24,4],[25,2,26,2],[1,1,1,4],[16,1,16,4],[21,2,21,4]]}
[]
[null,"Průtok zemního plynu v závislosti na teplotě"]
[null,"T","QZP","Tpož","QZP_teor."]
[null,"°C","mN3/h","°C","mN3/h"]
[null,0,0,{"$f":"'Vstupní parametry a výsledky'!C8","v":900},{"$f":"B19*D5^3+C19*D5^2+D19*D5^1+E19*D5^0","v":11.370747007971177}]
[null,100,0.81]
[null,200,1.74,"X","QZP_X"]
[null,300,2.79,"[%]","mN3/h"]
[null,400,3.96,30,{"$f":"E5*(1+D9/100)","v":14.78197111036253},{"$f":"'Vstupní parametry a výsledky'!C15*'Spalovací proces'!C3-'Vstupní parametry a výsledky'!I9*'Spalovací proces'!C3","v":0}]
[null,500,5.25]
[null,550,5.8]
[null,600,6.66]
[null,680,7.7]
[null,700,8.19]
[null,800,9.84]
[null,900,11.3]
[null,"Lineární regrese"]
[null,"k1","k2","k3","k4"]
[null,{"$f":"LINEST(C5:C16,B5:B16^{1,2,3})","v":-1.2335195642069674E-9},7.183446736671414E-6,7.1505267480586358E-3,1.5916840321440195E-2]
[]
[]
[null,null,"Požadovaný průtok vzduchu pro QZP_X"]
[null,null,"Qvz_inic",{"$f":"E9*'Spalovací proces'!C27*'Vstupní parametry a výsledky'!C9","v":275.84141564381338},"mN3/h"]
[]
[null,null,"Odhadnuté otáčky z výkonové křivky"]
[null,null,"nvz_inic",{"$f":"D23/'Výkonové křivky - vzduch'!I14*'Výkonové křivky - vzduch'!C5","v":2849.6294101536387},"min-1"]
[null,null,null,{"$f":"D26/'Výkonové křivky - vzduch'!C5*100","v":99.986996847496087},"%"]

{"sheet":"Spalovací proces","index":2,"n_rows":55,"n_cols":27,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,22,0,26],[0,0,0,3],[23,0,23,4],[7,0,7,3],[0,14,0,20],[30,0,30,4],[0,8,0,9],[0,11,0,12],[1,11,1,12],[0,5,0,6],[1,5,1,6],[15,0,15,3],[24,4,26,4],[4,0,4,3],[31,4,36,4],[40,0,40,4],[52,0,52,3],[48,0,48,3],[41,4,44,4],[37,4,38,4]]}
["Parametry vstupující do výpočtu",null,null,null,null,"Složení suchého vzduchu ",null,null,"Složení vlhkého vzduchu",null,null,"Složení zemního plynu",null,null,"Vlastnosti složek",null,null,null,null,null,null,null,"Stechiometrické výpočty"]
["Hustota ZP","ρZP",0.73,"kg/m3",null,"Dle mezinárodní atmosféry",null,null,"Složka","Koncentrace",null,"Tranzitní ZP",null,null,"složka","Počet uhlíků","Počet vodíků","spotřeba O2","tvorba CO2","tvorba H2O","tvorba    N2",null,"složka","Minimální spotřeba kyslíku","Koncentrace CO2 ve spalinách","Koncentrace N2 ve spalinách","Koncentrace H2O ve spalinách"]
["Hustota vzduchu","ρVZ",1.2921,"kg/m3",null,"Složka","Koncentrace",null,"i","[% objemu]",null,"Složka","Koncentrace",null,"i","x","y","mol/mol","mol/mol","mol/mol","mol/mol",null,"i","VO2min [mN3/mN3ZP]"]
["Molární objem","M",22.414000000000001,"m3/kmol",null,"i","[% objemu]",null,"N2",{"$f":"G5*(1-$C$19/100)","v":77.167321595815892},null,"i","[% objemu]",null,"CH4",1,4,2,1,2,0,null,"CH4",{"$f":"0.9995*(R4)*M5/100","v":1.9668161},{"$f":"0.994*S4*M5/100","v":0.97799659999999999},{"$f":"U4*M5/100","v":0},{"$f":"M5/100*T4","v":1.9678}]
["Při 0 °C a 101325 Pa",null,null,null,null,"N2",78.09,null,"O2",{"$f":"G6*(1-$C$19/100)","v":20.702463662854946},null,"CH4",98.39,null,"C2H6",2,6,3.5,2,3,0,null,"C2H6",1.5392300000000001E-2,8.7472000000000001E-3,0,1.32E-2]
[null,null,null,null,null,"O2",20.95,null,"Ar",{"$f":"G7*(1-$C$19/100)","v":0.91901151343461107},null,"C2H6",0.44,null,"C3H8",3,8,5,3,4,0,null,"C3H8",7.9960000000000014E-3,4.7712000000000006E-3,0,6.4000000000000003E-3]
[null,null,null,null,null,"Ar",0.93,null,"CO2",{"$f":"G8*(1-$C$19/100)","v":2.9645532691439064E-2},null,"C3H8",0.16,null,"C4H10",4,10,6.5,4,5,0,null,"C4H10",4.5477250000000007E-3,2.7832E-3,0,3.5000000000000005E-3]
["Parametry ze zadání",null,null,null,null,"CO2",0.03,null,"H2O",{"$f":"C19","v":1.1815576952031159},null,"C4H10",7.0000000000000007E-2,null,"C5H12",5,12,8,5,6,0,null,"C5H12",2.3988E-3,1.4909999999999999E-3,0,1.8E-3]
["Teplota vzduchu","tvz",{"$f":"'Vstupní parametry a výsledky'!C2","v":20},"°C",null,"Suma",{"$f":"SUM(G5:G8)","v":100.00000000000001},null,"Suma",{"$f":"SUM(J4:J8)","v":100},null,"C5H12",0.03,null,"N2",0,0,0,0,0,1,null,"N2",0,0,8.3999999999999995E-3,0]
["Tlak vzduchu","pvz",{"$f":"'Vstupní parametry a výsledky'!C3","v":98.58},"kPa",null,null,null,null,null,null,null,"N2",0.84,null,"CO2",1,0,0,1,0,0,null,"CO2",0,6.958E-4,0,0]
["Relativní vlhkost ","ϕ",{"$f":"'Vstupní parametry a výsledky'!C4","v":50},"%",null,null,null,null,null,null,null,"CO2",7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,"Celkem",{"$f":"SUM(X4:X8)","v":1.9971509249999997},{"$f":"SUM(Y4:Y10)","v":0.99648499999999995},{"$f":"SUM(Z4:Z10)","v":8.3999999999999995E-3},{"$f":"SUM(AA4:AA10)","v":1.9927000000000001}]
["Alfa","α",{"$f":"'Vstupní parametry a výsledky'!C9","v":1.9343643029321382},"[ - ]",null,null,null,null,null,null,null,"H2O",0]
["Průtok ZP","QZP",{"$f":"'Vstupní parametry a výsledky'!C15","v":14.78197111036253},"mN3/h",null,"hmotnostní průtok",{"$f":"C13*C2","v":10.790838910564647},{"$f":"G13-'Vstupní parametry a výsledky'!C14","v":0},null,null,null,"O2",0]
[null,null,null,null,null,"objemový průtok",{"$f":"C13","v":14.78197111036253},{"$f":"G14-'Vstupní parametry a výsledky'!C15","v":0}]
[]
["Výpočet koncentrace vody"]
["Tlak nasycených par","p''",{"$f":"10^(7.19621-1730.63/(233.426+C9))","v":2.3295591518624632},"kPa"]
["Parciální tlak vody","pH2O",{"$f":"C17*C11/100","v":1.1647795759312316},"kPa"]
["Koncentrace vody","ωH2O",{"$f":"C18/C10*100","v":1.1815576952031159},"% objemu"]
["Objem vodní páry","VH2O",{"$f":"C11/100*(C17/(C10-(C11/100)*C17))","v":1.1956854081535753E-2},"mN3/mN3ZP"]
["Faktor zvýšení objemu vzduchu","f",{"$f":"1+C20","v":1.0119568540815358},"[ - ]"]
[]
[]
["Výpočet spotřeby okysličovadla"]
["Minimální spotřeba kyslíku","VO2min",{"$f":"X11","v":1.9971509249999997},"mN3/mN3ZP","stechiometricky"]
["Min. množství suchého vzduchu","VvzSmin",{"$f":"100/G6*C25","v":9.5329399761336511},"mN3/mN3ZP"]
["Min. množství vlhkého vzduchu","VvzVmin",{"$f":"C26*C21","v":9.6469239483963207},"mN3/mN3ZP"]
["Průtok vlhkého vzduchu včetně alfa","VvzV",{"$f":"C27*C12*C13","v":275.84141564381338},"mN3/h","včetně alfa"]
[]
[]
["Výpočet množství spalin"]
["Množství CO2","VCO2",{"$f":"$Y$11+$G$8/100*C26+M11/100","v":1.00004488199284},"mN3/mN3ZP","stechiometricky"]
["Množství N2","VN2",{"$f":"Z11+G5/100*C26","v":7.4526728273627683},"mN3/mN3ZP"]
["Množství Ar","VAr",{"$f":"G7/100*C26","v":8.8656341778042963E-2},"mN3/mN3ZP"]
["Min. množství suchých spalin","VsSmin",{"$f":"SUM(C32:C34)","v":8.5413740511336513},"mN3/mN3ZP"]
["Množství H2O","VH2O",{"$f":"AA11+(C21-1)*C26","v":2.1066839722626693},"mN3/mN3ZP"]
["Min. množství vlhkých spalin","VsVmin",{"$f":"C35+C36","v":10.64805802339632},"mN3/mN3ZP"]
["Množství vlhkých spalin včetně alfa","VsV",{"$f":"(C37+(C12-1)*C27)","v":19.661799393879001},"mN3/mN3ZP","včetně alfa"]
["Průtok spalin včetně alfa","QsV",{"$f":"(C37+(C12-1)*C27)*C13","v":290.64015061806288},"mN3/h"]
[]
["Hustota spalin"]
["Ar","ρAr",1.7823852943371179,"kg/m3","Pro normální fyzikální \npodmínky"]
["N2","ρN2",1.2496632106772707,"kg/m3"]
["CO2","ρCO2",1.9635296816506511,"kg/m3"]
["Vodní pára","ρH2O",0.80396624936593197,"kg/m3"]
["Spaliny","ρs",{"$f":"((C32*C44+C33*C43+C34*C42+C36*C45)+(C12-1)*C27*C3)/(C37+(C12-1)*C27)","v":1.2600742262924831},"kg/m3","Včetně alfa"]
[]
[]
["Určení O2 ve spalinách"]
["Množství O2 ve spalinách ","O2",{"$f":"(J5/100*(1-1/C12))*100","v":10},"%",{"$f":"C50-'Vstupní parametry a výsledky'!C10","v":0}]
["α z Množství O2 ve spalinách","α",{"$f":"'Spalovací proces'!J5/('Spalovací proces'!J5-'Vstupní parametry a výsledky'!C10)","v":1.9343643029321382},"[ - ]",{"$f":"'Vstupní parametry a výsledky'!$C$9-'Spalovací proces'!C51","v":0}]
[]
["Výkon hořáku"]
["Výhřevnost","H",9.9640000000000004,"kWh/m3"]
["Výkon hořáku","PH",{"$f":"C54*'Vstupní parametry a výsledky'!C15","v":147.28756014365226},"kW"]

{"sheet":"Výpočet trati vzduchu","index":3,"n_rows":23,"n_cols":65,"rows_kept":23,"cut":false,"hidden":false,"merged":[[30,18,30,21],[0,19,0,27],[12,19,12,25],[11,34,11,43],[17,34,17,41],[1,4,1,5],[6,4,7,5],[20,61,21,61],[17,61,18,61],[0,29,0,47],[0,50,0,58],[0,61,0,64],[6,34,6,43],[2,63,2,64],[1,61,1,62],[1,63,1,64],[1,29,1,32],[1,34,1,47],[2,61,2,62],[5,54,5,57],[41,40,42,40],[38,32,38,37],[0,13,0,17],[31,0,31,5],[13,0,13,3],[41,38,44,38],[43,40,44,40],[41,39,42,39],[43,39,44,39],[38,28,38,30],[31,7,31,11],[15,19,17,19],[18,7,18,9],[12,29,12,31],[0,7,0,11],[0,0,0,5]]}
["Vstupní parametry",null,null,null,null,null,null,"Výpočet tlaků v jednotlivých uzlech - bez redukce průměru",null,null,null,null,null,"Výpočet tlaků v jednotlivých uzlech - redukce průměru",null,null,null,null,null,"Zaškrcení výstupu s korekcí průtoku",null,null,null,null,null,null,null,null,null,"Ztrátový součinitelé trati vzduchu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kinematická viskozita vzduchu v závislosti na teplotě ",null,null,null,null,null,null,null,null,null,null,"Charakteristika filtru"]
["Atmosferický tlak","p7=p0",{"$f":"'Vstupní parametry a výsledky'!C3*1000","v":98580},"Pa","Atmosferický tlak",null,null,"p6 -> p4","pk",{"$f":"C2+C8*((E10^2)/2)*((1/(C5^2))-(1/(C15^2)))+C8*(AE8)*(-E10)*E10/(2*(C5^2))","v":98717.995928796619},"Pa",null,null,"d6",40,"mm",{"$f":"O2/1000","v":0.04},"m",null,"Iterace","Průtok","Tlak p5","Tlak p4","Tlak p3","Tlak p2","Tlak p1","Ztráta na filtru","Tlaková diference",null,"Ztrátový součinitelé",null,null,null,null,"Konické rozšíření",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t","ν·106","ν",null,null,null,null,null,null,null,null,"Tlaková ztráta",null,"Průtok "]
["Průměr potrubí o světlosti DN80","d1",80,"mm",{"$f":"C3/1000","v":0.08},"m",null,"p4 -> p3","p3",{"$f":"J2+C8*((E10^2)/2)*((1/(C15^2))-(1/(C5^2)))+C8*AE7*(-E10)*E10/(2*(C5^2))","v":98527.804643945274},"Pa",null,null,"S6",{"$f":"PI()*Q2^2/4","v":1.2566370614359172E-3},"m2",null,null,null,"i","Qvz","p5","p4","p3","p2","p1","Δpz_filtr","ΔpDmychadla",null,"ξ1",0.18,"[ - ]","Zůžení před dmychadlem",null,"2δ [ °]",6,8,10,12,14,16,20,25,30,40,60,90,180,null,null,"°C","m2/s","m2/s",null,"takt",{"$f":"C9","v":20},"°C",null,null,null,null,"Δp",null,"Q(n)Dvz"]
["Průměr potrubí o světlosti DN40","d2",40,"mm",{"$f":"C4/1000","v":0.04},"m",null,"p3 -> p2","p2",{"$f":"J3+C8*((E10^2)/2)*((1/C5^2)-(1/C6^2))+C8*(AE4+AE5+AE6)*(-E10)*E10/(2*(C5^2))","v":95291.268539256271},"Pa",null,null,"p6 -> p5","p5",{"$f":"C2+C8*((E10^2)/2)*((1/(O3^2))-(1/(C5^2)))+C8*(AE9)*(-E10)*E10/(2*(O3^2))","v":100163.48439922348},"Pa",null,null,"[-]","m3/s","Pa","Pa","Pa","Pa","Pa","kPa","Pa",null,"ξ2",{"$f":"AP4*(('Výpočet trati vzduchu'!E3^2)/('Výpočet trati vzduchu'!E4^2)-1)^2","v":3.2399999999999998},"[ - ]","Rozšíření za dmychadlem",null,"ψ",0.08,0.11,0.15,0.19,0.23,0.27,0.36,0.5,0.65,0.92,1.1499999999999999,1.1000000000000001,1,null,null,0,13.49,{"$f":"AZ4*10^-6","v":1.349E-5},null,"νakt",{"$f":" -BC8*BD3^3 +BD8*BD3^2 + BE8*BD3 + BF8","v":1.5328904569988717E-5},"m2/s",null,null,null,null,"mbar","kPa","m3/min","m3/h"]
["Průtočná plocha potrubí DN80","S1",{"$f":"PI()*E3^2/4","v":5.0265482457436689E-3},"m2",null,null,null,"p0 -> p1","p1",{"$f":"(C2-('Výpočet trati vzduchu'!BK22*1000))-C8*(E10^2)/(2*(C6^2))-AE3*C8*(E10^2)/(2*(C6^2))","v":94611.042935780381},"Pa",null,null,"p5 -> p4","pk",{"$f":"P4+C8*((E10^2)/2)*((1/(C5^2))-(1/(C15^2)))+C8*(AE8)*(-E10)*E10/(2*(C5^2))","v":100301.4803280201},"Pa",null,null,1,{"$f":"E10","v":8.4533712044363288E-2},{"$f":"P4","v":100163.48439922348},{"$f":"P5","v":100301.4803280201},{"$f":"P6","v":100111.28904316876},{"$f":"P7","v":96874.752938479753},{"$f":"P8","v":94611.042935780381},{"$f":"BK22","v":0.84174101219668651},{"$f":"P9","v":2263.7100026993721},null,"ξ3",1,"[ - ]","Ztráta na klapce",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,14.47,1.447E-5,null,null,null,null,null,null,null,null,0,{"$f":"BJ5/10","v":0},0,{"$f":"BL5*60","v":0}]
["Průtočná plocha potrubí DN40","S2",{"$f":"PI()*E4^2/4","v":1.2566370614359172E-3},"m2",null,null,null,"ΔpDmychadla","p2-p1",{"$f":"J4-J5","v":680.22560347589024},"Pa","Max 16 kPa pro 300 m3/h",null,"p4 -> p3","p3",{"$f":"P5+C8*((E10^2)/2)*((1/(C15^2))-(1/(C5^2)))+C8*AE7*(-E10)*E10/(2*(C5^2))","v":100111.28904316876},"Pa",null,null,2,{"$f":"($V$17+$U$17*(AB5/1000))/3600","v":8.174304815552802E-2},{"$f":"$C$2+$C$8*((U6^2)/2)*((1/($O$3^2))-(1/($C$5^2)))+$C$8*($AE$9)*(-U6)*U6/(2*($O$3^2))","v":100060.66075417821},{"$f":"$P$4+$C$8*((U6^2)/2)*((1/($C$5^2))-(1/($C$15^2)))+$C$8*($AE$8)*(-U6)*U6/(2*($C$5^2))","v":100292.51955492549},{"$f":"$P$5+$C$8*((U6^2)/2)*((1/($C$15^2))-(1/($C$5^2)))+$C$8*$AE$7*(-U6)*U6/(2*($C$5^2))","v":100123.63912452974},{"$f":"$P$6+$C$8*((U6^2)/2)*((1/$C$5^2)-(1/$C$6^2))+$C$8*('Výpočet trati vzduchu'!$AE$4+'Výpočet trati vzduchu'!$AE$5+'Výpočet trati vzduchu'!$AE$6)*(-U6)*U6/(2*($C$5^2))","v":97084.917585360992},{"$f":"($C$2-('Výpočet trati vzduchu'!$BK$22*1000))-$C$8*(U6^2)/(2*($C$6^2))-'Výpočet trati vzduchu'!$AE$3*$C$8*(U6^2)/(2*($C$6^2))","v":94814.10887913339},{"$f":"(0.3723*(U6*60)^2-0.3563*(U6*60)+0.647)/10","v":0.7855148790943558},{"$f":"Y6-Z6","v":2270.8087062276027},null,"ξ4",0.3,"[ - ]","Ztráta v koleni",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,15.32,1.5319999999999999E-5,null,"Lineární regrese",null,null,null,null,null,null,0.1,0.01,0.35499999999999998,21.299999999999997]
["Kinemtatická viskozita ","ν",{"$f":"BD4","v":1.5328904569988717E-5},"m2/s","Pro Takt",null,null,null,null,null,null,null,null,"p3 -> p2","p2",{"$f":"P6+C8*((E10^2)/2)*((1/C5^2)-(1/C6^2))+C8*('Výpočet trati vzduchu'!AE4+'Výpočet trati vzduchu'!AE5+'Výpočet trati vzduchu'!AE6)*(-E10)*E10/(2*(C5^2))","v":96874.752938479753},"Pa",null,null,3,{"$f":"($V$17+$U$17*(AB6/1000))/3600","v":8.1734296992362163E-2},{"$f":"$C$2+$C$8*((U7^2)/2)*((1/($O$3^2))-(1/($C$5^2)))+$C$8*($AE$9)*(-U7)*U7/(2*($O$3^2))","v":100060.34374103643},{"$f":"$P$4+$C$8*((U7^2)/2)*((1/($C$5^2))-(1/($C$15^2)))+$C$8*($AE$8)*(-U7)*U7/(2*($C$5^2))","v":100292.49192817845},{"$f":"$P$5+$C$8*((U7^2)/2)*((1/($C$15^2))-(1/($C$5^2)))+$C$8*$AE$7*(-U7)*U7/(2*($C$5^2))","v":100123.67720077273},{"$f":"$P$6+$C$8*((U7^2)/2)*((1/$C$5^2)-(1/$C$6^2))+$C$8*('Výpočet trati vzduchu'!$AE$4+'Výpočet trati vzduchu'!$AE$5+'Výpočet trati vzduchu'!$AE$6)*(-U7)*U7/(2*($C$5^2))","v":97085.565539000163},{"$f":"($C$2-('Výpočet trati vzduchu'!$BK$22*1000))-$C$8*(U7^2)/(2*($C$6^2))-'Výpočet trati vzduchu'!$AE$3*$C$8*(U7^2)/(2*($C$6^2))","v":94814.734946928045},{"$f":"(0.3723*(U7*60)^2-0.3563*(U7*60)+0.647)/10","v":0.78534184460624235},{"$f":"Y7-Z7","v":2270.8305920721177},null,"ξ5",0.15,"[ - ]","Kónické rozšíření komory",null,"Kónické zúžení",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,17.27,1.7269999999999999E-5,null,"k1","k2","k3","k4",null,null,null,0.47499999999999998,4.7500000000000001E-2,1,60]
["Hustota","ρ",{"$f":"C2/(287.1*E9)","v":1.171293471928077},"kg/m3",null,null,null,null,null,null,null,null,null,"p0 -> p1","p1",{"$f":"(C2-('Výpočet trati vzduchu'!BK22*1000))-C8*(E10^2)/(2*(C6^2))-'Výpočet trati vzduchu'!AE3*C8*(E10^2)/(2*(C6^2))","v":94611.042935780381},"Pa",null,null,4,{"$f":"($V$17+$U$17*(AB7/1000))/3600","v":8.1734270011858526E-2},{"$f":"$C$2+$C$8*((U8^2)/2)*((1/($O$3^2))-(1/($C$5^2)))+$C$8*($AE$9)*(-U8)*U8/(2*($O$3^2))","v":100060.34276371321},{"$f":"$P$4+$C$8*((U8^2)/2)*((1/($C$5^2))-(1/($C$15^2)))+$C$8*($AE$8)*(-U8)*U8/(2*($C$5^2))","v":100292.49184300765},{"$f":"$P$5+$C$8*((U8^2)/2)*((1/($C$15^2))-(1/($C$5^2)))+$C$8*$AE$7*(-U8)*U8/(2*($C$5^2))","v":100123.67731815838},{"$f":"$P$6+$C$8*((U8^2)/2)*((1/$C$5^2)-(1/$C$6^2))+$C$8*('Výpočet trati vzduchu'!$AE$4+'Výpočet trati vzduchu'!$AE$5+'Výpočet trati vzduchu'!$AE$6)*(-U8)*U8/(2*($C$5^2))","v":97085.567536583389},{"$f":"($C$2-('Výpočet trati vzduchu'!$BK$22*1000))-$C$8*(U8^2)/(2*($C$6^2))-'Výpočet trati vzduchu'!$AE$3*$C$8*(U8^2)/(2*($C$6^2))","v":94814.736877039177},{"$f":"(0.3723*(U8*60)^2-0.3563*(U8*60)+0.647)/10","v":0.78534131115945827},{"$f":"Y8-Z8","v":2270.8306595442118},null,"ξ6",0.16511999999999999,"[ - ]","Kónické zužení komory",null,"2δ [ °]",5,7,10,15,20,30,45,60,75,null,null,null,null,null,null,60,19.22,1.9219999999999999E-5,null,{"$f":"LINEST(BA4:BA23,AY4:AY23^{1,2,3})","v":-2.2455096627893638E-14},1.0121515591410957E-10,8.8243389062749299E-8,1.3523371085595065E-5,null,null,null,1.7,0.16999999999999998,2,120]
["Aktuální teplota","Takt",{"$f":"'Vstupní parametry a výsledky'!C2","v":20},"°C",{"$f":"C9+273.15","v":293.14999999999998},"K",null,null,null,null,null,null,null,"ΔpDmychadla","p2-p1",{"$f":"P7-P8","v":2263.7100026993721},"Pa",null,null,5,{"$f":"($V$17+$U$17*(AB8/1000))/3600","v":8.1734269928680048E-2},{"$f":"$C$2+$C$8*((U9^2)/2)*((1/($O$3^2))-(1/($C$5^2)))+$C$8*($AE$9)*(-U9)*U9/(2*($O$3^2))","v":100060.34276070021},{"$f":"$P$4+$C$8*((U9^2)/2)*((1/($C$5^2))-(1/($C$15^2)))+$C$8*($AE$8)*(-U9)*U9/(2*($C$5^2))","v":100292.49184274509},{"$f":"$P$5+$C$8*((U9^2)/2)*((1/($C$15^2))-(1/($C$5^2)))+$C$8*$AE$7*(-U9)*U9/(2*($C$5^2))","v":100123.67731852028},{"$f":"$P$6+$C$8*((U9^2)/2)*((1/$C$5^2)-(1/$C$6^2))+$C$8*('Výpočet trati vzduchu'!$AE$4+'Výpočet trati vzduchu'!$AE$5+'Výpočet trati vzduchu'!$AE$6)*(-U9)*U9/(2*($C$5^2))","v":97085.567542741759},{"$f":"($C$2-('Výpočet trati vzduchu'!$BK$22*1000))-$C$8*(U9^2)/(2*($C$6^2))-'Výpočet trati vzduchu'!$AE$3*$C$8*(U9^2)/(2*($C$6^2))","v":94814.736882989528},{"$f":"(0.3723*(U9*60)^2-0.3563*(U9*60)+0.647)/10","v":0.78534130951489001},{"$f":"Y9-Z9","v":2270.8306597522314},null,"ξ7",0.34,"[ - ]","Zaškrcení výstupu",null,"ξ",0.06,0.12,0.16,0.18,0.2,0.34,0.36,0.5,0.65,null,null,null,null,null,null,80,21.3,2.1299999999999999E-5,null,null,null,null,null,null,null,null,3.5,0.35,3,180]
["Maximální průtok vzduchu","Qvz",{"$f":"'Výkonové křivky - vzduch'!$C$4*'Výkonové křivky - vzduch'!$C$8/'Výkonové křivky - vzduch'!$E$9*E9/C2","v":304.32136335970785},"mN3/h",{"$f":"C10/3600","v":8.4533712044363288E-2},"m3/s",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,23.34,2.334E-5,null,null,null,null,null,null,null,null,5.7,0.57000000000000006,4,240]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,25.73,2.5729999999999999E-5,null,null,null,null,null,null,null,null,8.5,0.85,5,300]
[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,null,null,null,null,null,null,null,"Koleno ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,27.88,2.7879999999999997E-5,null,null,null,null,null,null,null,null,11.7,1.17,6,360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Výkonová křivka dmychadla SAP300 pro aktuální parametry vzduchu",null,null,null,null,null,null,null,null,null,"Ztráty třením",null,null,null,null,"r/D",0.8,1,1.5,2,4,6,10,20,50,null,null,null,null,null,null,160,29.98,2.9979999999999998E-5,null,null,null,null,null,null,null,null,15.5,1.55,7,420]
["Parametry spalovací komory",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. bod výkonové křivky","Qmax",{"$f":"'Výkonové křivky - vzduch'!$C$4*'Výkonové křivky - vzduch'!$C$8/'Výkonové křivky - vzduch'!$E$9*E9/C2","v":304.32136335970785},"m3/h","Δp1",0,"kPa",null,null,null,"vDN80",{"$f":"E10/C5","v":16.817447662209133},"m/s",null,null,"ξ pro hydraulicky hladké",0.37,0.21,0.17,0.15,0.11,0.09,7.0000000000000007E-2,0.05,0.03,null,null,null,null,null,null,180,32.51,3.2509999999999999E-5,null,null,null,null,null,null,null,null,21,2.1,8,480]
["Průtočná plocha komory","Sk",{"$f":"0.3*0.4","v":0.12},"m2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. bod výkonové křivky","Qmin",{"$f":"'Výkonové křivky - vzduch'!$E$14*'Výkonové křivky - vzduch'!$C$8/'Výkonové křivky - vzduch'!$E$9*E9/C2","v":233.31304524244268},"m3/h","Δp2",16,"kPa",null,null,null,"λ",{"$f":"8*(((8/$AE$19)^12)+(1/SQRT(($AE$17+$AE$18)^3)))^(1/12)","v":2.52215297915349E-2},"[ - ]",null,null,"ξ pro hydraulicky drsné",0.74,0.42,0.34,0.3,0.22,0.18,0.14000000000000001,0.1,0.06,null,null,null,null,null,null,200,35.19,3.5189999999999993E-5,null,null,null,null,null,null,null,null,35,3.5,10,600]
["Rychlost proudění v komoře","vk",{"$f":"E10/C15","v":0.70444760036969412},"m/s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lineární regrese průtoku v závislosti na tlakové diferenci buňka P9","Lineární konst.","Abs. hodnota",null,null,null,null,null,null,null,"k",1.4999999999999999E-4,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,40.04,4.0039999999999996E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LINEST(V14:V15,Y14:Y15)","v":-4.4380198823290717},304.32136335970785,null,null,null,null,null,null,null,"A",{"$f":"(-2.457*LN(1/(((7/$AE$19)^0.9)+(0.27*$AE$16/'Výpočet trati vzduchu'!$E$3))))^16","v":1.0245861888310549E+20},"[ - ]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,48.85,4.8850000000000002E-5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qnový",{"$f":"(V17+U17*(P9/1000))/3600","v":8.174304815552802E-2},"m3/s",null,null,null,null,null,null,"B",{"$f":"(37530/AE19)^16","v":1.2492052784930891E-6},"[ - ]",null,null,"Koleno ostré",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,56.35,5.6350000000000001E-5,null,null,null,null,null,null,null,null,"Qmax",{"$f":"C10","v":304.32136335970785},"m3/h"]
[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,null,null,"Re",{"$f":"'Výpočet trati vzduchu'!AE14*'Výpočet trati vzduchu'!$E$3/'Výpočet trati vzduchu'!$C$7","v":87768.555595993312},"[ - ]",null,null,"δ [ °]",10,15,22.5,30,45,60,90,null,null,null,null,null,null,null,null,400,63.83,6.382999999999999E-5,null,null,null,null,null,null,null,null,null,{"$f":"BK18/60","v":5.0720227226617975},"m3/min"]
[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,null,null,"L",1.5,"m",null,null,"ξ pro hydraulicky hladké",3.4000000000000002E-2,4.2000000000000003E-2,6.6000000000000003E-2,0.13,0.23599999999999999,0.47099999999999997,1.129,null,null,null,null,null,null,null,null,500,80.27,8.0269999999999989E-5]
[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,null,null,"Δpz_tření",{"$f":"AE20*AE15/E3*(AE14^2)/2","v":66.874857679930841},"Pa","Zanedbáno",null,"ξ pro hydraulicky drsné",4.3999999999999997E-2,6.2E-2,0.154,0.16500000000000001,0.32,0.68400000000000005,1.2649999999999999,null,null,null,null,null,null,null,null,600,98.25,9.8249999999999989E-5,null,null,null,null,null,null,null,null,"Δpz_filtr",{"$f":"0.3723*BK19^2-0.3563*BK19+0.647","v":8.4174101219668653},"mbar"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,136.9,1.3689999999999999E-4,null,null,null,null,null,null,null,null,null,{"$f":"BK21/10","v":0.84174101219668651},"kPa"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,180.7,1.8069999999999997E-4]

{"sheet":"Výkonové křivky - vzduch","index":4,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,3],[10,0,10,9],[11,8,11,9],[6,0,6,5],[11,3,11,4],[11,5,11,6],[11,0,11,2]]}
["Parametry dmychadla vzduchu"]
["Výkon ","Pvz",2.2000000000000002,"kW"]
["Tlak ","Δpvz",16,"kPa"]
["Průtok ","Qvz",300,"m3/h"]
["Otáčky ","n0",2850,"min-1"]
[]
["Parametry při měření dmychadla z charakteristiky"]
["Tlak","pvz",100000,"Pa"]
["Teplota","tvz",20,"°C",{"$f":"C9+273.15","v":293.14999999999998},"K"]
[]
["Přepočtená charakteristika dmychadla"]
["Otáčky ",null,null,"Průtok",null,"Tlak ",null,"Výkon","Průtok přepočten na normální parametry"]
["n [min-1]","%","[-]","Qmax [m3/h]","Qmin [m3/h]","Δpvz_max [kPa]","Δpvz_min [kPa]","P [W]","Qmax [mN3/h]","Qmin [mN3/h]"]
[{"$f":"$C$5*C14","v":2850},{"$f":"C14*100","v":100},1,{"$f":"$C$4*A14/$C$5","v":300},230,{"$f":"$C$3*(A14/$C$5)^2","v":16},0,{"$f":"1000*$C$2*(A14/$C$5)^3","v":2200},{"$f":"D14*$C$8/$E$9*273.15/101325","v":275.87728838834613},{"$f":"E14*$C$8/$E$9*273.15/101325","v":211.50592109773203}]
[2565,90,0.9,270,{"$f":"$E$14*A15/$C$5","v":207},12.96,0,1603.8000000000002,248.28955954951152,190.35532898795881]
[2280,80,0.8,240,184,10.240000000000002,0,1126.4000000000003,220.70183071067689,169.20473687818566]
[1994.9999999999998,70,0.7,209.99999999999997,160.99999999999997,7.839999999999999,0,754.5999999999998,193.11410187184225,148.05414476841239]
[1710,60,0.6,180,138,5.76,0,475.2,165.5263730330077,126.90355265863924]
[1425,50,0.5,150,115,4,0,275,137.93864419417307,105.75296054886601]
[1140,40,0.4,120,92,2.5600000000000005,0,140.80000000000004,110.35091535533844,84.602368439092828]
[855,30,0.3,90,69,1.44,0,59.4,82.76318651650385,63.451776329319621]
[570,20,0.2,60,46,0.64000000000000012,0,17.600000000000005,55.175457677669222,42.301184219546414]
[285,10,0.1,30,23,0.16000000000000003,0,2.2000000000000006,27.587728838834611,21.150592109773207]
[0,0,0,0,0,0,0,0,0,0]

{"sheet":"Výpočet trati plynu","index":5,"n_rows":38,"n_cols":25,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,15,0,24],[1,15,1,18],[1,19,1,20],[1,22,1,23],[11,7,13,7],[0,7,0,13],[2,11,3,13],[6,7,6,9],[35,0,35,1],[35,2,35,3],[34,0,34,3],[2,15,2,18],[2,22,2,23],[15,7,15,9],[27,0,27,1],[27,2,27,3],[1,0,2,0],[2,4,5,4],[0,0,0,5],[22,0,23,0],[24,0,25,0],[21,0,21,5],[9,0,9,5],[18,4,18,5],[11,4,12,5],[15,4,16,5]]}
["Parametry zemního plynu",null,null,null,null,null,null,"Výpočet tlaku v místě průtokoměru pro parametry kontrolního testu",null,null,null,null,null,null,null,"Charakteristika potrubí"]
["Hustota","ρZP",0.73,"kg/m3","při 0 °C",null,null,"Tlak před dmychadlem","p2",{"$f":"C24+C3*(C19^2)/2*((1/(C12^2))-(1/(C16^2)))-C3*(C13^2)/2*(J10+J11+J9)-C3*(C17^2)/2*(J12)-I23","v":100268.64661131473},"Pa","p2rel",{"$f":"J2-C8","v":1688.6466113147326},"Pa",null,"Průtok",null,null,null,"Rychlosti",null,"Tlak před dmychadlem","p2-p1"]
[null,"ρZP_akt",{"$f":"C24/(C6*E7)","v":0.69695675134196589},"kg/m3","Při takt",null,null,"p3-p2","Δpdmych",{"$f":"(C26-J2)","v":211.35338868526742},"Pa","Ztráta trati je zantbatelná",null,null,null,"Q",null,null,null,"v1","v2","p2","Δpz_trati",null,"Δpdmych"]
["Dynamická vis.","ηZP",{"$f":"(6.4*(SQRT(1+((C7+208)/35))-1))*10^-6","v":1.0807041747909075E-5},"kg.m-1.s-1",null,null,null,"p2-p1","Δpz_trati",{"$f":"C24-J2","v":11.353388685267419},"Pa",null,null,null,null,"%","[-]","mN3/h","mN3/s","m/s","m/s","Pa","Pa","kPa","kPa"]
["Kinematická vis.","νZP",{"$f":"C4/'Výpočet trati plynu'!C3","v":1.550604356310559E-5},"m2/s",null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*Q5","v":100},1,{"$f":"'Výkonové křivky - plyn'!C20","v":29.426910761423585},{"$f":"R5/3600","v":8.1741418781732175E-3},{"$f":"S5/$C$12","v":6.5047754272286848},{"$f":"S5/$C$16","v":16.652225093705432},{"$f":"$C$24+$C$2*(S5^2)/2*((1/($C$12^2))-(1/($C$16^2)))-$C$2*(T5^2)/2*($J$10+$J$11+$J$11)-$C$2*(U5^2)/2*($J$12)-(($I$17*$I$22)/$E$11*T5^2/2)","v":100005.7959065538},{"$f":"$C$24-V5","v":274.20409344619839},{"$f":"W5/1000","v":0.27420409344619839},{"$f":"($C$26-V5)/1000","v":0.4742040934461984}]
["Plynová konst.","RZP",508.15,"J·kg-1·K-1",null,null,null,null,null,null,null,null,null,null,null,90,0.9,{"$f":"Q6*$R$5","v":26.484219685281229},7.356727690355897E-3,{"$f":"S6/$C$12","v":5.8542978845058169},{"$f":"S6/$C$16","v":14.98700258433489},{"$f":"$C$24+$C$2*(S6^2)/2*((1/($C$12^2))-(1/($C$16^2)))-$C$2*(T6^2)/2*($J$10+$J$11+$J$11)-$C$2*(U6^2)/2*($J$12)-(($I$17*$I$22)/$E$11*T6^2/2)","v":100057.89468430859},222.10531569141313,{"$f":"W6/1000","v":0.22210531569141312},0.42210531569141313]
["Teplota","TZP_akt",10,"°C",{"$f":"C7+273.15","v":283.14999999999998},"K",null,"Ztráty",null,null,null,null,null,null,null,80,0.8,{"$f":"Q7*$R$5","v":23.541528609138869},6.5393135025385747E-3,5.2038203417829481,13.321780074964346,100104.50938019443,175.49061980556871,0.17549061980556871,0.37549061980556869]
["Atmosferický tlak","patm",98580,"Pa",null,null,null,"Ztrátové koeficienty","Označení","Hodnota",null,null,null,null,null,70,0.7,20.598837532996509,5.7218993147212524E-3,4.5533427990600792,11.656557565593802,100145.63999421135,134.3600057886506,0.13436000578865059,0.3343600057886506]
[null,null,null,null,null,null,null,"Koleno 1","ξk1",0.15,null,null,null,null,null,60,0.6,17.656146456854149,4.9044851269039302E-3,3.9028652563372104,9.9913350562232583,100181.28652635936,98.713473640644224,9.8713473640644228E-2,0.29871347364064421]
["Parametry trati ",null,null,null,null,null,null,"Koleno 2","ξk2",0.17,null,null,null,null,null,50,0.5,14.713455380711792,4.0870709390866088E-3,3.2523877136143424,8.3261125468527162,100211.44897663845,68.551023361549596,6.8551023361549598E-2,0.26855102336154962]
["Světlost potrubí ","D1",40,"mm",{"$f":"C11/1000","v":0.04},"m",null,"Koleno 3","ξk3",0.15,null,null,null,null,null,40,0.4,11.770764304569434,3.2696567512692874E-3,2.601910170891474,6.6608900374821731,100236.1273450486,43.872654951395816,4.3872654951395813E-2,0.24387265495139582]
["Průtočný průřez","S1",{"$f":"PI()*E11^2/4","v":1.2566370614359172E-3},"m2",null,null,null,"Zúžení","ξz",{"$f":"((1/J13)-1)^2","v":0.34310214183173904},null,null,null,null,null,30,0.3,8.8280732284270744,2.4522425634519651E-3,1.9514326281686052,4.9956675281116292,100255.32163158986,24.678368410139228,2.4678368410139227E-2,0.22467836841013922]
["Rychlost proudění","v1",{"$f":"$C$19/C12","v":1.337785716102551},"m/s",null,null,null,null,"ε",{"$f":"0.57+0.043/(1.1-J14)","v":0.63061674008810564},null,null,null,null,null,20,0.2,5.8853821522847172,1.6348283756346437E-3,1.300955085445737,3.3304450187410866,100269.03183626215,10.968163737852592,1.0968163737852593E-2,0.2109681637378526]
[null,null,null,null,null,null,null,null,"n",{"$f":"'Výpočet trati plynu'!C16/'Výpočet trati plynu'!C12","v":0.39062500000000006},null,null,null,null,null,10,0.1,2.9426910761423586,8.1741418781732184E-4,0.65047754272286851,1.6652225093705433,100277.25795906554,2.742040934463148,2.7420409344631482E-3,0.20274204093446316]
["Světlost potrubí ","D2",25,"mm",{"$f":"C15/1000","v":2.5000000000000001E-2},"m",null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,100280,{"$f":"$C$24-V15","v":0},{"$f":"W15/1000","v":0},0.2]
["Průtočný průřez","S2",{"$f":"PI()*E15^2/4","v":4.9087385212340522E-4},"m2",null,null,null,"Ztráty třením"]
["Rychlost proudění","v2",{"$f":"$C$19/C16","v":3.4247314332225303},"m/s",null,null,null,"Lambda",{"$f":"8*(((8/$I$21)^12)+(1/SQRT(($I$19+$I$20)^3)))^(1/12)","v":4.6149009539792986E-2}]
[null,null,null,null,null,null,null,"k",1.4999999999999999E-4,"m"]
["Průtok ","Q",{"$f":"C32","v":1.6811111111140538E-3},"m3/s","Při kontrolním testu 2",null,null,"A",{"$f":"(-2.457*LN(1/(((7/$I$21)^0.9)+(0.27*$I$18/'Výpočet trati plynu'!E11))))^16","v":7.7722758188521178E+17}]
[null,null,null,null,null,null,null,"B",{"$f":"(37530/I21)^16","v":3.8276153927365968E+16}]
[null,null,null,null,null,null,null,"Re",{"$f":"'Výpočet trati plynu'!C13*'Výpočet trati plynu'!E11/'Výpočet trati plynu'!$C$5","v":3451.0046632027284}]
["Měřené parametry - Kontrolní test 2",null,null,null,null,null,null,"L",6,"m"]
["Tlak p1","p1_rel",1.7,"kPa",{"$f":"C23*1000","v":1700},"Pa",null,"Δpz_tření",{"$f":"(I17*I22)/E11*C13^2/2","v":6.194364496302371},"Pa"]
[null,"p1_abs",{"$f":"C8+E23","v":100280},"Pa"]
["Tlak p3","p3_rel",1.9,"kPa",{"$f":"C25*1000","v":1900},"Pa"]
[null,"p3_abs",{"$f":"C8+E25","v":100480},"Pa"]
[]
["Spotřeba",null,"Rozdíl"]
["Start",46990.686999999998,{"$f":"B30-B29","v":3.0260000000052969},"m3"]
["End",46993.713000000003]
["Délka testu","t",30,"min"]
["Průtok","Q",{"$f":"C29/(C31*60)","v":1.6811111111140538E-3},"m3/s"]
["Otevření PV",20,"%"]
[]
["Stanovení průtoku při úplném otevření ventilu"]
["Průtok",null,"Otevření ventilu"]
[{"$f":"C32*3600","v":6.0520000000105938},"m3/h",20,"% "]
[{"$f":"C38/C37*A37","v":30.260000000052969},"m3/h",100,"%"]

{"sheet":"Výkonové křivky - plyn","index":6,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,3],[28,0,28,12],[29,9,29,12],[18,0,18,3],[13,0,13,5],[30,0,30,3],[29,0,29,3],[6,0,9,0],[2,0,5,0],[29,4,29,7]]}
["Parametry dmychadla plynu"]
["Výkon ","Pvz",0.37,"kW"]
["Průtok ","Q1vz",32,"m3/h"]
[null,"Q2vz",16,"m3/h"]
[null,"Q3vz",9.4,"m3/h"]
[null,"Q4vz",0,"m3/h"]
["Tlak vzduchu","Δp1vz",0,"kPa"]
[null,"Δp2vz",10,"kPa"]
[null,"Δp3vz",15,"kPa"]
[null,"Δp4vz",23,"kPa"]
["Otáčky ","n",2850,"min-1"]
["Frekvence","f",50,"Hz"]
[]
["Parametry při měření"]
["Tlak","p1",100000,"Pa"]
["Teplota","T1",20,"°C",{"$f":"C16+273.15","v":293.14999999999998},"K"]
["Hustota vzduchu","rho",{"$f":"C15/(287.1*E16)","v":1.1881654209049268},"kg/m3"]
[]
["Přepočet parametrů na zemní plyn"]
["Průtok","Q1plyn",{"$f":"$C$15*C3/$E$16*273.15/101325","v":29.426910761423585},"mN3/h"]
[null,"Q2plyn",{"$f":"$C$15*C4/$E$16*273.15/101325","v":14.713455380711792},"mN3/h"]
[null,"Q3plyn",{"$f":"$C$15*C5/$E$16*273.15/101325","v":8.6441550361681792},"mN3/h"]
[null,"Q4plyn",{"$f":"$C$15*C6/$E$16*273.15/101325","v":0},"mN3/h"]
["Tlak plynu","Δp1plyn",0,"kPa"]
[null,"Δp2plyn",6.1439256450000004,"kPa"]
[null,"Δp3plyn",9.215888467500001,"kPa"]
[null,"Δp4plyn",14.1310289835,"kPa"]
[]
["Afinní vztahy"]
["Otáčky",null,null,null,"Průtok",null,null,null,null,"Tlak"]
["n",null,null,null,"Q1plyn","Q2plyn","Q3plyn","Q4plyn",null,"Δp1plyn","Δp2plyn","Δp3plyn","Δp4plyn"]
["min-1","%","[-]","Hz"," mN3/h"," mN3/h"," mN3/h"," mN3/h",null,"kPa","kPa","kPa","kPa"]
[{"$f":"$C$11*C33","v":2850},{"$f":"C33*100","v":100},1,{"$f":"$C$12*C33","v":50},{"$f":"$C$20*A33/$C$11","v":29.426910761423585},{"$f":"$C$21*A33/$C$11","v":14.713455380711792},{"$f":"$C$22*A33/$C$11","v":8.6441550361681792},{"$f":"$C$23*A33/$C$11","v":0},null,{"$f":"$C$24*(A33/$C$11)^2","v":0},{"$f":"$C$25*(A33/$C$11)^2","v":6.1439256450000004},{"$f":"$C$26*(A33/$C$11)^2","v":9.215888467500001},{"$f":"$C$27*(A33/$C$11)^2","v":14.1310289835}]
[2565,90,0.9,45,26.484219685281225,13.242109842640613,7.7797395325513614,0,null,0,4.9765797724500009,7.464869658675001,11.446133476635001]
[2280,80,0.8,40,23.541528609138869,11.770764304569434,6.9153240289345428,0,null,0,3.9321124128000009,5.8981686192000016,9.0438585494400012]
[1994.9999999999998,70,0.7,35,20.598837532996505,10.299418766498253,6.0509085253177242,0,null,0,3.0105235660499998,4.5157853490750002,6.924204201914999]
[1710,60,0.6,30,17.656146456854152,8.8280732284270762,5.1864930217009073,0,null,0,2.2118132321999999,3.3177198483000003,5.0871704340599999]
[1425,50,0.5,25,14.713455380711792,7.3567276903558962,4.3220775180840896,0,null,0,1.5359814112500001,2.3039721168750003,3.5327572458750001]
[1140,40,0.4,20,11.770764304569434,5.8853821522847172,3.4576620144672714,0,null,0,0.98302810320000023,1.4745421548000004,2.2609646373600003]
[855,30,0.3,15,8.8280732284270762,4.4140366142135381,2.5932465108504537,0,null,0,0.55295330804999998,0.82942996207500008,1.271792608515]
[741,26,{"$f":"D41/D33","v":0.26},13,7.6509967979701319,3.8254983989850659,2.2474803094037266,0,null,0,0.41532937360200006,0.62299406040300009,0.9552575592846001]
[570,20,0.2,{"$f":"$C$12*C42","v":10},5.8853821522847172,2.9426910761423586,1.7288310072336357,0,null,0,0.24575702580000006,0.3686355387000001,0.56524115934000008]
[285,10,0.1,{"$f":"$C$12*C43","v":5},2.9426910761423586,1.4713455380711793,0.86441550361681785,0,null,0,6.1439256450000014E-2,9.2158884675000025E-2,0.14131028983500002]
[85.5,3,{"$f":"D44/D33","v":0.03},1.5,0.88280732284270746,0.44140366142135373,0.25932465108504538,0,null,0,5.5295330805000004E-3,8.2942996207500015E-3,1.2717926085149999E-2]