{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Zisk prostupem","Výkon na zchlazení","Zisk dýcháním ","Zisk otevíráním dveří","Ztráta od pers","Ztráta od osvětlení","Ztráta od ventilátoru","Ztráta odtáváním","Souhrn","koeficienty epsilon a Cmin","koeficienty dychani"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Zisk prostupem","index":0,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[32,0,37,0],[24,0,29,0],[16,0,21,0]]}
["Tepelná zátěž prostupem"]
[]
["Skladba stěn, stropu, dveří (PUR Panel)","d [mm]","λ [W∙m⁻¹∙K⁻¹]"]
["Ocelový plech",0.5,50]
["Polyuretanové jádro",80,2.3E-2]
["Ocelový plech",0.5,50]
[]
[null,"Výška [mm]","Šířka [mm]","délka [mm]","Plocha"]
["Boční stěny",2500,"-",6000,{"$f":"B9*D9/1000000","v":15}]
["Zadní stěna",2500,3000,"-",{"$f":"B10*C10/1000000","v":7.5}]
["Přední stěna",2500,3000,"-",{"$f":"B11*C11/1000000-E13","v":6.1210000000000004}]
["Strop","-",3000,6000,{"$f":"C12*D12/1000000","v":18}]
["Dveře",1970,700,"-",{"$f":"B13*C13/1000000","v":1.379}]
[]
[]
[null,null,"Tepelný odpor konstrukce R [W-1∙m²∙K²]","Součinitel přestupu tepla vnitřní hi  [W∙m-2∙K-2]","Součinitel prostupu tepla vnější he  [W∙m-2∙K-2]","Vnitřní teplota [°C]","Venkovní teplota [°C]","U","Plocha","Ztráta prostupem"]
["Sklad švestek","Stěna - západ",{"$f":"$B$4*10^(-3)/$C$4+$B$5*10^(-3)/$C$5+$B$6*10^(-3)/$C$6","v":3.4782808695652179},8,29,1,35,{"$f":"1/(C17+1/D17+1/E17)","v":0.27489416636415254},{"$f":"$E$9","v":15},{"$f":"H17*I17*(G17-F17)","v":140.1960248457178}]
[null,"Stěna - východ",{"$f":"C17","v":3.4782808695652179},8,29,1,35,0.27489416636415254,{"$f":"$I$17","v":15},{"$f":"H18*I18*(G18-F18)","v":140.1960248457178}]
[null,"Zadní stěna - sever",{"$f":"C17","v":3.4782808695652179},8,29,1,35,0.27489416636415254,{"$f":"$E$10","v":7.5},70.098012422858901]
[null,"Přední stěna - jih",{"$f":"C17","v":3.4782808695652179},8,29,1,35,0.27489416636415254,{"$f":"$E$11","v":6.1210000000000004},57.209324538709247]
[null,"Strop",{"$f":"C17","v":3.4782808695652179},8,29,1,35,0.27489416636415254,{"$f":"$E$12","v":18},168.23522981486136]
[null,"Dveře",{"$f":"C18","v":3.4782808695652179},8,29,1,35,0.27489416636415254,{"$f":"$E$13","v":1.379},12.888687884149656]
[null,null,null,null,null,null,null,null,"Celkem",{"$f":"SUM(J17:J22)","v":588.82330435201482}]
[null,null,"Tepelný odpor konstrukce R [W-1∙m²∙K²]","Součinitel přestupu tepla vnitřní hi  [W∙m-2∙K-2]","Součinitel prostupu tepla vnější he  [W∙m-2∙K-2]","Vnitřní teplota [°C]","Venkovní teplota [°C]","U","Plocha","Ztráta prostupem"]
["Sklad okurek","Stěna - západ",{"$f":"$B$4*10^(-3)/$C$4+$B$5*10^(-3)/$C$5+$B$6*10^(-3)/$C$6","v":3.4782808695652179},8,29,7,35,{"$f":"1/(C25+1/D25+1/E25)","v":0.27489416636415254},{"$f":"$E$9","v":15},{"$f":"H25*I25*(G25-F25)","v":115.45554987294406}]
[null,"Stěna - východ",{"$f":"C25","v":3.4782808695652179},8,29,7,35,0.27489416636415254,{"$f":"$I$17","v":15},{"$f":"H26*I26*(G26-F26)","v":115.45554987294406}]
[null,"Zadní stěna - sever",{"$f":"C25","v":3.4782808695652179},8,29,7,35,0.27489416636415254,{"$f":"$E$10","v":7.5},57.727774936472031]
[null,"Přední stěna - jih",{"$f":"C25","v":3.4782808695652179},8,29,7,35,0.27489416636415254,{"$f":"$E$11","v":6.1210000000000004},47.113561384819377]
[null,"Strop",{"$f":"C25","v":3.4782808695652179},8,29,7,35,0.27489416636415254,{"$f":"$E$12","v":18},138.54665984753288]
[null,"Dveře",{"$f":"C26","v":3.4782808695652179},8,29,7,35,0.27489416636415254,{"$f":"$E$13","v":1.379},10.614213551652657]
[null,null,null,null,null,null,null,null,"Celkem",{"$f":"SUM(J25:J30)","v":484.91330946636509}]
[null,null,"Tepelný odpor konstrukce R [W-1∙m²∙K²]","Součinitel přestupu tepla vnitřní hi  [W∙m-2∙K-2]","Součinitel prostupu tepla vnější he  [W∙m-2∙K-2]","Vnitřní teplota [°C]","Venkovní teplota [°C]","U","Plocha","Ztráta prostupem"]
["Sklad banánů","Stěna - západ",{"$f":"$B$4*10^(-3)/$C$4+$B$5*10^(-3)/$C$5+$B$6*10^(-3)/$C$6","v":3.4782808695652179},8,29,13,35,{"$f":"1/(C33+1/D33+1/E33)","v":0.27489416636415254},{"$f":"$E$9","v":15},{"$f":"H33*I33*(G33-F33)","v":90.715074900170336}]
[null,"Stěna - východ",{"$f":"C33","v":3.4782808695652179},8,29,13,35,0.27489416636415254,{"$f":"$I$17","v":15},{"$f":"H34*I34*(G34-F34)","v":90.715074900170336}]
[null,"Zadní stěna - sever",{"$f":"C33","v":3.4782808695652179},8,29,13,35,0.27489416636415254,{"$f":"$E$10","v":7.5},45.357537450085168]
[null,"Přední stěna - jih",{"$f":"C33","v":3.4782808695652179},8,29,13,35,0.27489416636415254,{"$f":"$E$11","v":6.1210000000000004},37.017798230929515]
[null,"Strop",{"$f":"C33","v":3.4782808695652179},8,29,13,35,0.27489416636415254,{"$f":"$E$12","v":18},108.8580898802044]
[null,"Dveře",{"$f":"C34","v":3.4782808695652179},8,29,13,35,0.27489416636415254,{"$f":"$E$13","v":1.379},8.3397392191556587]
[null,null,null,null,null,null,null,null,"Celkem",{"$f":"SUM(J33:J38)","v":381.00331458071543}]

{"sheet":"Výkon na zchlazení","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["Výkon na zchlazení"]
[]
[null,"Hmotnost [kg]","Měrná tepelná kapacita","Venkovní teplota","Vnitřní teplota","Doba na zchlazení [h]","Výkon na zchlazení"]
["Švestky",500,3726,32,1,24,{"$f":"B5*C5*(D5-E5)/(F5*3600)","v":668.4375}]
["Okurky",500,4103,32,7,24,{"$f":"B6*C6*(D6-E6)/(F6*3600)","v":593.60532407407402}]
["Banány",500,3349,32,13,24,368.2349537037037]

{"sheet":"Zisk dýcháním ","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Zisk dýcháním "]
[]
[null,"Hmotnost [kg]","Měrné dýchací teplo [mW/kg]","Celkové dýchací teplo [W]"]
["Švestky",500,7,{"$f":"C4/1000*B4","v":3.5}]
["Okurky",500,70,{"$f":"C5/1000*B5","v":35}]
["Banány",500,100,50]

{"sheet":"Zisk otevíráním dveří","index":3,"n_rows":6,"n_cols":15,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Zisk otevíráním dveří"]
[]
[null,"Entalpie vnitřního vzduchu [kJ/kg]","Entlapie Venkovního vzduchu [kJ/kg]","Hustota vnitřního vzduchu [kg/m3]","Hustota venkovního vzduchu  [kg/m3]","Plocha dveří [m2]","Výška Dveří [m]","Čas na otevření a zavření dveří [s]","Počet otevření dveří [-]","Čas plně otevřených dvěří [min]","Časová perioda [h]","Faktor otevírání dveří [-]","Faktor průtoku vzduchu dveřmi [-]","průtok vzduchu plně otevřenými dveřmi  [m3/s]","Ztráta otevíráním [W]"]
["Sklad švestek",9.6,81.5,1.268,1.119,{"$f":"'Zisk prostupem'!$E$13","v":1.379},{"$f":"'Zisk prostupem'!$B$13/1000","v":1.97},10,2,2,2,{"$f":"(I4*H4+60*J4)/(3600*K4)","v":1.9444444444444445E-2},0.8,{"$f":"0.221*F4*D4*(1-E4/D4)^0.5*(9.81*G4)^0.5*(2/(1+(D4/E4)^(1/3)))^(3/2)","v":0.56423919588036375},{"$f":"E4*N4*(C4-B4)*1000*L4*M4","v":706.16754705264657}]
["Sklad okurek",20.3,81.5,1.2390000000000001,1.119,{"$f":"'Zisk prostupem'!$E$13","v":1.379},{"$f":"'Zisk prostupem'!$B$13/1000","v":1.97},10,2,2,2,{"$f":"(I5*H5+60*J5)/(3600*K5)","v":1.9444444444444445E-2},0.8,{"$f":"0.221*F5*D5*(1-E5/D5)^0.5*(9.81*G5)^0.5*(2/(1+(D5/E5)^(1/3)))^(3/2)","v":0.50349625008227783},{"$f":"E5*N5*(C5-B5)*1000*L5*M5","v":536.36851325764962}]
["Sklad banánů",33,81.5,1.2110000000000001,1.119,{"$f":"'Zisk prostupem'!$E$13","v":1.379},{"$f":"'Zisk prostupem'!$B$13/1000","v":1.97},10,2,2,2,{"$f":"(I6*H6+60*J6)/(3600*K6)","v":1.9444444444444445E-2},0.8,{"$f":"0.221*F6*D6*(1-E6/D6)^0.5*(9.81*G6)^0.5*(2/(1+(D6/E6)^(1/3)))^(3/2)","v":0.43838445547340338},{"$f":"E6*N6*(C6-B6)*1000*L6*M6","v":370.09438628127486}]

{"sheet":"Ztráta od pers","index":4,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Ztráta od personálu"]
[]
[null,"Tepelný výkon osoby [W]","Počet osob","Doba pobytu [h]","Ztráta [W] "]
["Sklad švestek",266,2,2,{"$f":"B4*C4*D4/24","v":44.333333333333336}]
["Sklad okurek",228,2,2,{"$f":"B5*C5*D5/24","v":38}]
["Sklad banánů",204,2,2,{"$f":"B6*C6*D6/24","v":34}]

{"sheet":"Ztráta od osvětlení","index":5,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Ztráty od osvětlení"]
[]
[null,"Měrný tepelný výkon os osvětlení [W/m2]","Plocha","Doba zapnutí osvětlení [h]","Ztráta od osvětlení [W]"]
["sklad švestek",10,{"$f":"'Zisk prostupem'!E12","v":18},2,{"$f":"B4*C4*D4/24","v":15}]
["sklad okurek",10,{"$f":"C4","v":18},2,{"$f":"B5*C5*D5/24","v":15}]
["sklad banánů",10,{"$f":"C4","v":18},2,{"$f":"B6*C6*D6/24","v":15}]

{"sheet":"Ztráta od ventilátoru","index":6,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Ztráta ventilátoru"]
[]
[null,"Výkon ventilátoru [W]"]
["Sklad švestek",200]
["Sklad okurek",200]
["Sklad hrušek",200]

{"sheet":"Ztráta odtáváním","index":7,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Ztráta odtáváním výparníku"]
[]
[null,"Ztráta odtáváním"]
["Sklad švestek",{"$f":"0.15*('Zisk prostupem'!J23+'Výkon na zchlazení'!G5+'Zisk dýcháním '!D4+'Zisk otevíráním dveří'!O4+'Ztráta od pers'!E4+'Ztráta od osvětlení'!E4+'Ztráta od osvětlení'!E4+'Ztráta od ventilátoru'!B4)","v":336.18925271069924}]
["Sklad okurek",0]
["Sklad banánů",0]

{"sheet":"Souhrn","index":8,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,13,4,13]]}
[]
[null,"Qp [W]","Qfc [W]","Qresp [W]","Qd [W]","Qper [W]","Qlight [W]","Qvent [W]","Qdefr [W]","Suma [W]","Bezpečnost [%]","Potřebný výkon [W]","Vnitřní teplota [°C]","Celkem [W]"]
["Chladírna švestek",{"$f":"'Zisk prostupem'!J23","v":588.82330435201482},{"$f":"'Výkon na zchlazení'!G5","v":668.4375},{"$f":"'Zisk dýcháním '!D4","v":3.5},{"$f":"'Zisk otevíráním dveří'!O4","v":706.16754705264657},{"$f":"'Ztráta od pers'!E4","v":44.333333333333336},{"$f":"'Ztráta od osvětlení'!E4","v":15},{"$f":"'Ztráta od ventilátoru'!B4","v":200},{"$f":"'Ztráta odtáváním'!B4","v":336.18925271069924},{"$f":"SUM(B3:I3)","v":2562.4509374486943},10,{"$f":"(1+K3/100)*SUM(B3:I3)","v":2818.6960311935641},1,{"$f":"SUM(L3:L5)","v":6472.0378126937248}]
["Chladírna okurek",{"$f":"'Zisk prostupem'!J31","v":484.91330946636509},{"$f":"'Výkon na zchlazení'!G6","v":593.60532407407402},{"$f":"'Zisk dýcháním '!D5","v":35},{"$f":"'Zisk otevíráním dveří'!O5","v":536.36851325764962},{"$f":"'Ztráta od pers'!E5","v":38},{"$f":"'Ztráta od osvětlení'!E5","v":15},{"$f":"'Ztráta od ventilátoru'!B5","v":200},{"$f":"'Ztráta odtáváním'!B5","v":0},{"$f":"SUM(B4:I4)","v":1902.8871467980889},10,{"$f":"(1+K4/100)*SUM(B4:I4)","v":2093.1758614778978},7]
["Chladírna banánů",{"$f":"'Zisk prostupem'!J39","v":381.00331458071543},{"$f":"'Výkon na zchlazení'!G7","v":368.2349537037037},{"$f":"'Zisk dýcháním '!D6","v":50},{"$f":"'Zisk otevíráním dveří'!O6","v":370.09438628127486},{"$f":"'Ztráta od pers'!E6","v":34},{"$f":"'Ztráta od osvětlení'!E6","v":15},{"$f":"'Ztráta od ventilátoru'!B6","v":200},{"$f":"'Ztráta odtáváním'!B6","v":0},1418.3326545656939,10,{"$f":"(1+K5/100)*SUM(B5:I5)","v":1560.1659200222634},13]

{"sheet":"koeficienty epsilon a Cmin","index":9,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Kondenzátor"]
[]
["ε [-]",0.59099999999999997]
["Cmin [J/K]",1046]
[]
["Výparníky"]
[null,"Výparník 1","Výparník 2","Výparník 3"]
["ε [-]",0.45900000000000002,0.47199999999999998,0.5393]
["Cmin [J/K]",304,220,143]

{"sheet":"koeficienty dychani","index":10,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Potravina",null,"Švestky",null,null,"Okurky",null,null,"Banány"]
[null,"Ti [°C]","Ti [°F]","mCO2","Ti [°C]","Ti [°F]","mCO2","Ti [°C]","Ti [°F]","mCO2"]
[null,0,{"$f":"(9*B3/5+32)","v":32},2.5,10,{"$f":"(9*E3/5+32)","v":50},26,13,{"$f":"(9*H3/5+32)","v":55.4},50]
[null,10,{"$f":"(9*B4/5+32)","v":50},10,15,{"$f":"(9*E4/5+32)","v":59},{"$f":"(24+33)/2","v":28.5},15,{"$f":"(9*H4/5+32)","v":59},{"$f":"(26+140)/2","v":83}]
[null,20,68,20,20,68,{"$f":"(14+48)/2","v":31},18,64.400000000000006,{"$f":"(32+200)/2","v":116}]
[null,null,null,null,25,77,{"$f":"(19+55)/2","v":37},20,68,{"$f":"(40+280)/2","v":160}]