{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Eingabe","Berechnung","Translation"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":1,"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":"Eingabe","index":0,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,1,4,11],[7,1,8,11],[11,1,12,11],[16,1,16,6]]}
[]
[null,{"$f":"Translation!A2","v":"Consumption costs of instanteaneous water heaters"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Translation!A37","v":"Extended options"}]
[]
[null,{"$f":"Translation!A3","v":"Number of inhabitants ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Translation!A28","v":"Average shower temperature"},null,null,null,{"$f":"Berechnung!D5&\" °C\"","v":"38 °C"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Berechnung!A5=1,Berechnung!A5&\" \"&Translation!A5,Berechnung!A5&\" \"&Translation!A4)","v":"4 persons in the household"},null,null,null,null,{"$f":"Translation!A29","v":"Average cold water temperature"},null,null,null,{"$f":"Berechnung!E5&\" °C\"","v":"10 °C"}]
[]
[null,{"$f":"Translation!A6","v":"Shower operations per week and person ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Translation!A30","v":"Heating capacity"},null,null,null,{"$f":"Berechnung!F5&\" KW\"","v":"21 KW"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Berechnung!B5=1,Berechnung!B5&\" \"&Translation!A8,Berechnung!B5&\" \"&Translation!A7)","v":"4 showers per week"},null,null,null,null,{"$f":"Translation!A31","v":"Flow quantity shower"},null,null,null,{"$f":"FIXED(Berechnung!G5,0)&\" \"&Translation!A22","v":"8 liter/minute"}]
[]
[null,{"$f":"Translation!A9","v":"Average shower time per person ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Translation!A32","v":"Annual usage"},null,null,null,{"$f":"IF(Berechnung!H5=1,Berechnung!H5&\" \"&Translation!A27,Berechnung!H5&\" \"&Translation!A26)","v":"49 weeks/year"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Berechnung!C5=1,Berechnung!C5&\" \"&Translation!A11,Berechnung!C5&\" \"&Translation!A10)","v":"7 minutes per week"},null,null,null,null,{"$f":"Translation!A33","v":"Fresh and waste water costs"},null,null,null,{"$f":"FIXED(Berechnung!I5,2)&\" \"&Translation!A25","v":"4,50 Euro/m³"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Translation!A34","v":"Electricity costs"},null,null,null,{"$f":"Berechnung!J5&\" Cent/kWh\"","v":"24 Cent/kWh"}]
[]
[null,{"$f":"Translation!A12","v":"Results"},null,null,null,null,null,null,null,{"$f":"Translation!A13","v":"Electronic"},null,{"$f":"Translation!A14","v":"Hydraulic"},null,{"$f":"\"> \"&Translation!A37","v":"> Extended options"},{"$f":"\"< \"&Translation!A35","v":"< Fade out"}]
[]
[null,{"$f":"Translation!A15","v":"Water consumption"},null,null,null,null,null,null,null,{"$f":"Berechnung!E17","v":"43,9 m³/year"},null,{"$f":"Berechnung!F17","v":"59,0 m³/year"},null,null,{"$f":"IF(Berechnung!G5>Berechnung!G7,\"Der max. Durchfluss bei gewählter Leistung und Temperaturniveau beträgt \"&FIXED(Berechnung!G7,1)&\" Liter/Minute.\",\"\")","v":""}]
[]
[null,{"$f":"Translation!A16","v":"Water costs"},null,null,null,null,null,null,null,{"$f":"Berechnung!E18","v":"198 Euro/year"},null,{"$f":"Berechnung!F18","v":"265 Euro/year"}]
[]
[null,{"$f":"Translation!A17","v":"Energy consumption"},null,null,null,null,null,null,null,{"$f":"Berechnung!E19","v":"1.458,9 kWh/year"},null,{"$f":"Berechnung!F19","v":"1.960,0 kWh/year"}]
[]
[null,{"$f":"Translation!A18","v":"Energy costs"},null,null,null,null,null,null,null,{"$f":"Berechnung!E20","v":"350 Euro/year"},null,{"$f":"Berechnung!F20","v":"470 Euro/year"}]
[]
[null,{"$f":"Translation!A19","v":"Total costs"},null,null,null,null,null,null,null,{"$f":"Berechnung!E21","v":"548 Euro/year"},null,{"$f":"Berechnung!F21","v":"736 Euro/year"}]
[]
[null,{"$f":"Translation!A20","v":"Savings"},null,null,null,null,null,null,null,{"$f":"Berechnung!E22&\"  (\"&Berechnung!E23&\")\"","v":"188 Euro/year  (25,6 %)"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"IMT/TR 09/12"]

{"sheet":"Berechnung","index":1,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[14,0,14,1],[13,0,13,1],[25,0,25,1],[26,0,26,1],[32,0,32,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[10,6,10,7],[2,10,3,11],[22,0,22,1],[23,0,23,1],[24,0,24,1],[12,0,12,1],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[10,4,10,5],[10,2,10,3],[10,0,11,1],[16,0,16,1]]}
[]
["Eingabewerte"]
["Personen","Häufigkeit","Dauer","Duschtemp","KW-Temp","Leistung DE","Durchfluss","Nutzung","Kosten Wasser","Kosten Strom","Sprache"]
[null,"Duschen pro Woche","min/Dusche","°C","°C","KW","l/min","Woche pro Jahr","€/m³","Cent/kWh"]
[4,4,7,{"$f":"MAX(D7,E5+1)","v":38},10,{"$f":"VLOOKUP(F7,G13:H33,2,FALSE)","v":21},{"$f":"MIN(G7:G8)","v":8},49,{"$f":"I7/10","v":4.5},24,2,{"$f":"VLOOKUP(K5,K6:L25,2,FALSE)","v":"| English"}]
[null,null,null,"Scrollwert",null,"Scrollwert",null,null,"Scrollwert",null,1,"| Deutsch"]
[null,null,null,38,null,9,{"$f":"F5*1000/((D5-E5)*1.163*60)","v":10.748065348237319},null,45,null,2,"| English"]
[null,null,null,null,null,null,8,null,null,null,3,"| Nederlands"]
[null,null,null,null,null,null,null,null,null,null,4,"| Francais"]
[null,null,null,null,null,null,null,null,null,null,5,"| Suomi"]
["Wert",null,"Berechnung",null,"Ausgabe",null,"Scrollwerte Leistung",null,null,null,6,"| Espanol"]
[null,null,"Elektronisch","Hydraulisch","Elektronisch","Hydraulisch"]
["Warmwasserverbrauch [m³/a]",null,{"$f":"A5*B5*C5*H5*G5/1000","v":43.904000000000003},{"$f":"C13","v":43.904000000000003},{"$f":"FIXED(C13,2)&\" \"&Translation!A21","v":"43,90 m³/year"},{"$f":"FIXED(D13,2)&\" \"&Translation!A21","v":"43,90 m³/year"},1,2.7]
["Erzeugte WW-Temperatur [°C]",null,{"$f":"D5","v":38},{"$f":"MIN(60,F5*1000/(1.163*G5*60)+E5)","v":47.618228718830608},{"$f":"FIXED(C14,1)&\" °C\"","v":"38,0 °C"},{"$f":"FIXED(D14,1)&\" °C\"","v":"47,6 °C"},2,3.2]
["Kaltwasserbeimischung [l/min]",null,0,{"$f":"G5*(D14-E5)/(D5-E5)-G5","v":2.7480653482373167},{"$f":"FIXED(C15,2)&\" \"&Translation!A22","v":"0,00 liter/minute"},{"$f":"FIXED(D15,2)&\" \"&Translation!A22","v":"2,75 liter/minute"},3,4]
["Kaltwasserverbrauch [m³/a]",null,0,{"$f":"D15*A5*B5*C5*H5/1000","v":15.081382631126393},{"$f":"FIXED(C16,2)&\" \"&Translation!A22","v":"0,00 liter/minute"},{"$f":"FIXED(D16,2)&\" \"&Translation!A21","v":"15,08 m³/year"},4,6]
["Wasserverbrauch-gesamt [m³/Jahr]",null,{"$f":"C13+C16","v":43.904000000000003},{"$f":"D13+D16","v":58.985382631126399},{"$f":"FIXED(C17,1)&\" \"&Translation!A21","v":"43,9 m³/year"},{"$f":"FIXED(D17,1)&\" \"&Translation!A21","v":"59,0 m³/year"},5,8]
["Wasserkosten [Euro/Jahr]",null,{"$f":"C17*I5","v":197.56800000000001},{"$f":"D17*I5","v":265.4342218400688},{"$f":"FIXED(C18,0)&\" \"&Translation!A24","v":"198 Euro/year"},{"$f":"FIXED(D18,0)&\" \"&Translation!A24","v":"265 Euro/year"},6,12]
["Energiebedarf [kWh/Jahr]",null,{"$f":"C13*1.163*(C14-E5)/0.98","v":1458.8672000000001},{"$f":"D13*1.163*(D14-E5)/0.98","v":1960.0000000000002},{"$f":"FIXED(C19,1)&\" \"&Translation!A23","v":"1.458,9 kWh/year"},{"$f":"FIXED(D19,1)&\" \"&Translation!A23","v":"1.960,0 kWh/year"},7,12]
["Energiekosten [Euro/Jahr]",null,{"$f":"C19*J5/100","v":350.128128},{"$f":"D19*J5/100","v":470.40000000000009},{"$f":"FIXED(C20,0)&\" \"&Translation!A24","v":"350 Euro/year"},{"$f":"FIXED(D20,0)&\" \"&Translation!A24","v":"470 Euro/year"},8,18]
["Gesamtkosten [Euro/Jahr]",null,{"$f":"C18+C20","v":547.69612800000004},{"$f":"D18+D20","v":735.83422184006895},{"$f":"FIXED(C21,0)&\" \"&Translation!A24","v":"548 Euro/year"},{"$f":"FIXED(D21,0)&\" \"&Translation!A24","v":"736 Euro/year"},9,21]
["Einsparung DHE [Euro/Jahr]",null,{"$f":"D21-C21","v":188.1380938400689},null,{"$f":"FIXED(C22,0)&\" \"&Translation!A24","v":"188 Euro/year"},null,10,24]
["Einsparung DHE [%]",null,{"$f":"100*C22/D21","v":25.568000000000012},null,{"$f":"FIXED(C23,1)&\" %\"","v":"25,6 %"},null,11,27]
[null,null,null,null,null,null,12,36]
[null,null,null,null,null,null,13,45]
[null,null,null,null,null,null,14,60]
[null,null,null,null,null,null,15,90]

{"sheet":"Translation","index":2,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Englisch","Deutsch","Englisch"]
["Consumption costs of instanteaneous water heaters","Verbrauchskosten Durchlauferhitzer","Consumption costs of instanteaneous water heaters"]
["Number of inhabitants ?","Wieviele Personen wohnen im Haushalt ?","Number of inhabitants ?"]
["persons in the household","Personen im Haushalt","persons in the household"]
["person in the household","Person im Haushalt","person in the household"]
["Shower operations per week and person ?","Wie oft duscht jede Person in einer Woche ?","Shower operations per week and person ?"]
["showers per week","Duschen pro Woche","showers per week"]
["shower per week","Dusche pro Woche","shower per week"]
["Average shower time per person ?","Wie lange duscht jede Person durchschnittlich ?","Average shower time per person ?"]
["minutes per week","Minuten pro Dusche","minutes per week"]
["minute per week","Minute pro Dusche","minute per week"]
["Results","Ergebnisse","Results"]
["Electronic","Elektronisch","Electronic"]
["Hydraulic","Hydraulisch","Hydraulic"]
["Water consumption","Wasserverbrauch","Water consumption"]
["Water costs","Wasserkosten","Water costs"]
["Energy consumption","Energieverbrauch","Energy consumption"]
["Energy costs","Energiekosten","Energy costs"]
["Total costs","Gesamtkosten","Total costs"]
["Savings","Ersparnis","Savings"]
["m³/year","m³/Jahr","m³/year"]
["liter/minute","Liter/Minute","liter/minute"]
["kWh/year","kWh/Jahr","kWh/year"]
["Euro/year","Euro/Jahr","Euro/year"]
["Euro/m³","Euro/m³","Euro/m³"]
["weeks/year","Wochen/Jahr","weeks/year"]
["week/year","Woche/Jahr","week/year"]
["Average shower temperature","Mittlere Duschtemperatur","Average shower temperature"]
["Average cold water temperature","Mittlere Kaltwassertemperatur","Average cold water temperature"]
["Heating capacity","Leistungsgröße Durchlauferhitzer","Heating capacity"]
["Flow quantity shower","Durchflussmenge Dusche","Flow quantity shower"]
["Annual usage","Jährliche Nutzungsdauer","Annual usage"]
["Fresh and waste water costs","Kosten Frisch- und Abwasser","Fresh and waste water costs"]
["Electricity costs","Stromkosten","Electricity costs"]
["Fade out","ausblenden","Fade out"]
["| Reset","| zurücksetzen","| Reset"]
["Extended options","Weitere Optionen","Extended options"]