{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculation","Data","Tabellen"],"not_rendered":{"charts":1,"images":15,"macros":1,"external_links":0,"defined_names":4,"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":"Calculation","index":0,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,1,64,4]]}
[]
[null,"Výpočet úspor AS-ECOshower"]
[null,"Version 1.2"]
[null,"Zadání",null,null,null,null,null,null,1]
[]
[null,"Projekt",null,null,null,null,null,null,null,null,2]
[]
[null,"Produkt","AS-ECOshower pipe 15/1500mm",null,null,null,null,null,null,null,2]
[]
[null,"Teplota sprchování",40,null,null,null,"typischer Wert: 37 - 40°C",null,3]
[]
[null,"Délky sprchování",10,null,null,null,null,null,4]
[]
[null,"Průtok",12.5,null,null,null,"typischer Wert: 8…15 Liter /min",null,5]
[]
[null,"Teplota studené vody",10,null,null,null,"typischer Wert: 8 - 12 °C",null,6]
[]
[null,"Teplota ohřívané vody",60]
[]
[null,"Počet osob",4]
[]
[null,"Počet sprchování / osoba a týden",5]
[]
[null,"Účinnost plynového kotle na ohřev teplé vody (pokud přítomen)",0.7]
[]
[null,"Cena plynu",1.5,null,3]
[]
[null,"Cena elektřiny",3.7,null,1.5]
[]
[null,"Délka provozu",25]
[]
[]
[null,"Zapojení","na zdroj tepla a sprch. baterii (vyvážený průtok)",null,{"$f":"VLOOKUP(C33,Tabellen!$K$6:$L$8,2,FALSE)","v":0}]
[]
[null,"Obvyklá ztráta tepla ve sprše ",0.2,null,"odparem, akumulací dlažby, ..."]
[]
[null,"Výsledky - spotřeba"]
[]
[null,"Objem",{"$f":"C20*E39*52*C22","v":130000},null,{"$f":"C14*C12","v":125},null,"typischer Wert: 35…80 Liter / Duschvorgang"]
[]
[null,"Užitné teplo",{"$f":"IF(C10>40,0.001*C39*Data!C22*(40-C16),0.001*C39*Data!C22*(C10-C16))","v":4535.7}]
[]
[null,"Spotřeba plynu pro ohřev teplé vody",{"$f":"C41/C24","v":6479.5714285714284},null,{"$f":"C41/C24/10","v":647.9571428571428}]
[]
[null,"Cena sprchování - plyn",{"$f":"C43*C26","v":9719.3571428571431}]
[]
[null,"Cena sprchování - elektřina",{"$f":"C41*C28","v":16782.09}]
[]
[null,"Výsledky - úspora","za rok",null,{"$f":"\"za \"&C30&\" let\"","v":"za 25 let"}]
[]
[null,"Úspora relativní",{"$f":"Data!F19*(1-C35)*(1-E33)","v":0.41840000000000005}]
[]
[null,"Úspora užitné energii",{"$f":"IFERROR($C$41*C51,\"keine Werte verfügbar\")","v":1897.7368800000002},null,{"$f":"IFERROR(C53*$C$30,\"-\")","v":47443.422000000006}]
[]
[null,"Úspora plynu",{"$f":"IFERROR($C$43*C51,\"keine Werte verfügbar\")","v":2711.0526857142859},null,{"$f":"IFERROR(C55*$C$30,\"-\")","v":67776.317142857151}]
[]
[null,"Úspora „Kč“ za plyn",{"$f":"IFERROR(C55*$C$26,\"keine Werte verfügbar\")","v":4066.5790285714288},null,{"$f":"IFERROR(SUMPRODUCT(C57*(1+E26/100)^ROW(INDIRECT(\"1:\"&C30))),\"-\")","v":152712.41407884954}]
[]
[null,"Úspora „Kč“ za elektřinu",{"$f":"IFERROR(C53*$C$28,\"keine Werte verfügbar\")","v":7021.6264560000009},null,{"$f":"IFERROR(SUMPRODUCT(C59*(1+E28/100)^ROW(INDIRECT(\"1:\"&$C$30))),\"-\")","v":214257.69173626392}]
[]
[null,"CO2-úspora elektřiny",{"$f":"IFERROR(C53*Data!C23,\"keine Werte verfügbar\")","v":1920.5097225600002},null,{"$f":"IFERROR(C61*$C$30,\"-\")","v":48012.743064000009}]
[]
[null,"CO2-úspora plynu",{"$f":"IFERROR(C55*Data!C24,\"keine Werte verfügbar\")","v":536.78843177142858},null,{"$f":"IFERROR(C63*$C$30,\"-\")","v":13419.710794285715}]
[]
[null,"Tento výpočetní nástroj byl naprogramován dle nejlepšího vědomí a svědomí. Měl by být poskytnut přibližný údaj o úsporech našich produktů AS-ECOshower. Účinnosti jsou stanoveny nezávislým institutem. Červené hodnoty v datovém listu byly interpolovány."]

{"sheet":"Data","index":1,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,2,2,5],[5,0,14,0]]}
["Účinnost podle přílohy B normy NEN 7120: 2011 / C2: 2011, zkouška dle KIWA"]
["Červené označené hodnoty jsou vypočteny"]
[null,null,"Objemový průtok"]
[null,null,5.8,9.1999999999999993,12.5,15,null,null,null,5.8,9.1999999999999993,12.5,15]
[null,"AS-ECOshower pipe 15/1500mm",0.6,0.56799999999999995,0.52300000000000002,0.48,{"$f":"VLOOKUP(Calculation!C8,Data!B5:I15,8,0)","v":5},null,5,"*","*",null,"*"]
["Produkt","AS-ECOshower pipe 15/1700mm",0.63300000000000001,0.6,0.55500000000000005,0.51,{"$f":"VLOOKUP(Calculation!C8,Data!B5:I14,8,0)","v":5},null,6,null,null,null,"*"]
[null,"AS-ECOshower pipe 15/2015mm",0.67,0.63700000000000001,0.6,0.56000000000000005,null,null,7,"*",null,null,"*"]
[null,"AS-ECOshower pipe 20",0.6,0.56999999999999995,0.502,0.47,null,null,8,"*","*",null,"*"]
[null,"AS-ECOshower drain 800",0.39500000000000002,0.38100000000000001,0.36399999999999999,0.32,null,null,9,null,null,null,"*"]
[null,"(není v nabídce) Duschrinne ECOshower 810",0.41899999999999998,0.41599999999999998,0.39700000000000002,0.35,null,null,10,null,null,null,"*"]
[null,"(není v nabídce) Duschrinne ECOshower 810H",0.57399999999999995,0.57299999999999995,0.56399999999999995,0.52,null,null,11,null,null,null,"*"]
[null,"AS-ECOshower drain 900",0.5,0.49099999999999999,0.47699999999999998,0.43,null,null,12,"*",null,null,"*"]
[null,"AS-ECOshower tray",0.50600000000000001,0.50600000000000001,0.48299999999999998,0.44,null,null,13,null,null,null,"*"]
[null,"(není v nabídce) Duschsammler ECOshower ",0.53,0.51,0.432,0.42299999999999999,null,null,14,"*","*"]
[null,"Nejnižší energetická třída",0.3,0.3,0.3,0.3,null,null,15]
[]
[null,"Průběžný výstup"]
[null,{"$f":"Calculation!C8","v":"AS-ECOshower pipe 15/1500mm"},{"$f":"VLOOKUP($B$18,$B$5:$F$15,2,0)","v":0.6},{"$f":"VLOOKUP($B$18,$B$5:$F$15,3,0)","v":0.56799999999999995},{"$f":"VLOOKUP($B$18,$B$5:$F$15,4,0)","v":0.52300000000000002},{"$f":"VLOOKUP($B$18,$B$5:$F$15,5,0)","v":0.48}]
[null,null,null,null,null,{"$f":"HLOOKUP(Calculation!C14,Data!C4:F18,15,0)","v":0.52300000000000002}]
[]
[null,"Konstanty"]
[null,"Měrná tepelná kapacita vody",1.163,"Wh/kg"]
[null,"CO2 Elektřiny",1.012,"kg / kWh"]
[null,"CO2 Zemního plynu",0.19800000000000001,"kg / kWh"]

{"sheet":"Tabellen","index":2,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Reduzierung Energieeinsparung gegenüber Balanciertem Betrieb"]
[]
["Temperatur WEZ","Tm","KW","Verhältnis KW:WW","Anschluss Mischarmatur","KW","Verhältnis KW:WW","Anschluss WEZ",null,{"$f":"Calculation!B18","v":"Teplota ohřívané vody"},{"$f":"Calculation!C18","v":60}]
[{"$f":"B4","v":40},{"$f":"Calculation!$C$10","v":40},27,{"$f":"(A4-B4)/(B4-C4)","v":0},{"$f":"1-(D4/(D4+1))","v":1},10,{"$f":"(A4-B4)/(B4-F4)","v":0},{"$f":"(G4/(G4+1))","v":0},null,{"$f":"Calculation!B10","v":"Teplota sprchování"},{"$f":"Calculation!C10","v":40}]
[{"$f":"A4+1","v":41},{"$f":"Calculation!$C$10","v":40},27,{"$f":"(A5-B5)/(B5-C5)","v":7.6923076923076927E-2},{"$f":"1-(D5/(D5+1))","v":0.9285714285714286},10,3.3333333333333333E-2,{"$f":"(G5/(G5+1))","v":3.2258064516129031E-2},null,null,null,"Reduzierung Einsparung"]
[{"$f":"A5+1","v":42},{"$f":"Calculation!$C$10","v":40},27,{"$f":"(A6-B6)/(B6-C6)","v":0.15384615384615385},{"$f":"1-(D6/(D6+1))","v":0.8666666666666667},10,6.6666666666666666E-2,{"$f":"(G6/(G6+1))","v":6.25E-2},null,"Betriebsweise","na zdroj tepla a sprch. baterii (vyvážený průtok)",0]
[43,{"$f":"Calculation!$C$10","v":40},27,0.23076923076923078,0.8125,10,0.1,9.0909090909090912E-2,null,null,"na sprchovou baterii",{"$f":"VLOOKUP($K$3,$A$3:$H$46,5,FALSE)","v":0.39393939393939392}]
[44,{"$f":"Calculation!$C$10","v":40},27,0.30769230769230771,0.76470588235294112,10,0.13333333333333333,0.11764705882352941,null,null,"na zdroj tepla",{"$f":"VLOOKUP($K$3,$A$3:$H$46,8,FALSE)","v":0.4}]
[45,{"$f":"Calculation!$C$10","v":40},27,0.38461538461538464,0.72222222222222221,10,0.16666666666666666,0.14285714285714285]
[46,{"$f":"Calculation!$C$10","v":40},27,0.46153846153846156,0.68421052631578949,10,0.2,0.16666666666666669]
[47,{"$f":"Calculation!$C$10","v":40},27,0.53846153846153844,0.64999999999999991,10,0.23333333333333334,0.18918918918918917]
[48,{"$f":"Calculation!$C$10","v":40},27,0.61538461538461542,0.61904761904761907,10,0.26666666666666666,0.2105263157894737]
[49,{"$f":"Calculation!$C$10","v":40},27,0.69230769230769229,0.59090909090909094,10,0.3,0.23076923076923075]
[50,{"$f":"Calculation!$C$10","v":40},27,0.76923076923076927,0.56521739130434778,10,0.33333333333333331,0.25]
[51,{"$f":"Calculation!$C$10","v":40},27,0.84615384615384615,0.54166666666666674,10,0.36666666666666664,0.26829268292682923]
[52,{"$f":"Calculation!$C$10","v":40},27,0.92307692307692313,0.52,10,0.4,0.28571428571428575]
[53,{"$f":"Calculation!$C$10","v":40},27,1,0.5,10,0.43333333333333335,0.30232558139534882]
[54,{"$f":"Calculation!$C$10","v":40},27,1.0769230769230769,0.4814814814814814,10,0.46666666666666667,0.31818181818181818]
[55,{"$f":"Calculation!$C$10","v":40},27,1.1538461538461537,0.4642857142857143,10,0.5,0.33333333333333331]
[56,{"$f":"Calculation!$C$10","v":40},27,1.2307692307692308,0.44827586206896552,10,0.53333333333333333,0.34782608695652178]
[57,{"$f":"Calculation!$C$10","v":40},27,1.3076923076923077,0.43333333333333324,10,0.56666666666666665,0.36170212765957444]
[58,{"$f":"Calculation!$C$10","v":40},27,1.3846153846153846,0.41935483870967738,10,0.6,0.37499999999999994]
[59,{"$f":"Calculation!$C$10","v":40},27,1.4615384615384615,0.40625000000000011,10,0.6333333333333333,0.38775510204081631]
[60,{"$f":"Calculation!$C$10","v":40},27,1.5384615384615385,0.39393939393939392,10,0.66666666666666663,0.4]
[61,{"$f":"Calculation!$C$10","v":40},27,1.6153846153846154,0.38235294117647056,10,0.7,0.41176470588235292]
[62,{"$f":"Calculation!$C$10","v":40},27,1.6923076923076923,0.37142857142857144,10,0.73333333333333328,0.42307692307692302]
[63,{"$f":"Calculation!$C$10","v":40},27,1.7692307692307692,0.36111111111111116,10,0.76666666666666672,0.43396226415094347]
[64,{"$f":"Calculation!$C$10","v":40},27,1.8461538461538463,0.35135135135135132,10,0.8,0.44444444444444448]
[65,{"$f":"Calculation!$C$10","v":40},27,1.9230769230769231,0.3421052631578948,10,0.83333333333333337,0.45454545454545453]
[66,{"$f":"Calculation!$C$10","v":40},27,2,0.33333333333333337,10,0.8666666666666667,0.4642857142857143]
[67,{"$f":"Calculation!$C$10","v":40},27,2.0769230769230771,0.32499999999999996,10,0.9,0.47368421052631582]
[68,{"$f":"Calculation!$C$10","v":40},27,2.1538461538461537,0.31707317073170738,10,0.93333333333333335,0.48275862068965519]
[69,{"$f":"Calculation!$C$10","v":40},27,2.2307692307692308,0.30952380952380953,10,0.96666666666666667,0.49152542372881353]
[70,{"$f":"Calculation!$C$10","v":40},27,2.3076923076923075,0.30232558139534882,10,1,0.5]
[71,{"$f":"Calculation!$C$10","v":40},27,2.3846153846153846,0.29545454545454541,10,1.0333333333333334,0.50819672131147553]
[72,{"$f":"Calculation!$C$10","v":40},27,2.4615384615384617,0.28888888888888886,10,1.0666666666666667,0.51612903225806461]
[73,{"$f":"Calculation!$C$10","v":40},27,2.5384615384615383,0.28260869565217395,10,1.1000000000000001,0.52380952380952384]
[74,{"$f":"Calculation!$C$10","v":40},27,2.6153846153846154,0.27659574468085102,10,1.1333333333333333,0.53125]
[75,{"$f":"Calculation!$C$10","v":40},27,2.6923076923076925,0.27083333333333337,10,1.1666666666666667,0.53846153846153844]
[76,{"$f":"Calculation!$C$10","v":40},27,2.7692307692307692,0.26530612244897955,10,1.2,0.54545454545454541]
[77,{"$f":"Calculation!$C$10","v":40},27,2.8461538461538463,0.26,10,1.2333333333333334,0.55223880597014929]
[78,{"$f":"Calculation!$C$10","v":40},27,2.9230769230769229,0.25490196078431371,10,1.2666666666666666,0.55882352941176472]
[79,{"$f":"Calculation!$C$10","v":40},27,3,0.25,10,1.3,0.56521739130434789]
[80,{"$f":"Calculation!$C$10","v":40},27,3.0769230769230771,0.24528301886792447,10,1.3333333333333333,0.57142857142857151]
[81,{"$f":"Calculation!$C$10","v":40},27,3.1538461538461537,0.2407407407407407,10,1.3666666666666667,0.57746478873239437]
[82,{"$f":"Calculation!$C$10","v":40},27,3.2307692307692308,0.23636363636363633,10,1.4,0.58333333333333337]
[]
[]
["Anzahl Duschvorgänge Auswahlliste"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]