{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Kalkulation","Tarife","Drop Down","Tabelle3","Tabelle4 "],"not_rendered":{"images":1,"defined_names":5,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Kalkulation","index":0,"n_rows":43,"n_cols":10,"rows_kept":43,"merged":[[3,0,3,12],[9,6,9,7],[11,6,11,7],[12,6,12,7],[14,6,14,7],[15,6,15,7],[18,6,18,7],[18,8,18,12],[19,6,19,7],[19,8,19,12],[24,2,24,4]]}
[{"$f":"\"Kostenrechner Gas\"&\" \"&Tarife!E1&\" 2. HJ\"","v":"Kostenrechner Gas 2024 2. HJ"},{"$nulls":4},"Formelbasis - nicht verändern!"]
["gültig ab 1. Juli 2024"]
[]
["Muster AG, Musterstrasse, 8620 Wetzikon"]
["Datum",{"$f":"TODAY()","v":"2024-04-04"}]
[]
[]
["Kenngrössen"]
[]
["Bezugsperiode",{"$nulls":4},{"$f":"IF(G10='Drop Down'!A4,1,IF(G10='Drop Down'!A5,3,IF(G10='Drop Down'!A6,12)))","v":12},"Jahr"]
[]
[{"$f":"\"Verbrauchsmenge \"&G10","v":"Verbrauchsmenge Jahr"},{"$nulls":5},{"v":35000,"d":"35,000"},null,"kWh"]
["Anzahl Zähler/Messpunkte",{"$nulls":5},1]
[]
["Tarifart",{"$nulls":5},"G-Standard"]
["Biogasanteil",{"$nulls":5},"Biogas 35 % - Standardmix"]
[]
[]
["Gasversorgung",{"$nulls":5},{"$f":"\"Tarif\"&\" \"&G15&\" \"","v":"Tarif G-Standard "},null,{"$f":"\"Kostenkalkulation\"&\" pro \" &G10","v":"Kostenkalkulation pro Jahr"}]
[]
[]
[]
["Erdgas",null,null,{"$f":"G12","v":{"v":35000,"d":"35,000"}},"kWh",{"$f":"CONCATENATE(G15,A23)","v":"G-StandardErdgas"},{"$f":"VLOOKUP(F23,Tarife!$C:$E,3,0)","v":{"v":6.5,"d":"6.50"}},"Rp./kWh",{"$f":"$G$12*G23/100","v":{"v":2275,"d":"2,275.00"}},"CHF"]
["Erdgas Sonderausschüttung1",{"$nulls":4},{"$f":"CONCATENATE(A24)","v":"Erdgas Sonderausschüttung1"},{"$f":"VLOOKUP(F24,Tarife!$C:$E,3,0)","v":-2.81},"Rp./kWh",{"$f":"$G$12*G24/100","v":{"v":-983.5,"d":"-983.50"}},"CHF"]
[{"$f":"G16","v":"Biogas 35 % - Standardmix"},{"$nulls":4},{"$f":"CONCATENATE(A25)","v":"Biogas 35 % - Standardmix"},{"$f":"VLOOKUP(F25,Tarife!$C:$E,3,0)","v":{"v":1.4,"d":"1.40"}},"Rp./kWh",{"$f":"$G$12*G25/100","v":{"v":490,"d":"490.00"}},"CHF"]
["Grundpreis",{"$nulls":4},{"$f":"CONCATENATE(G15,A26)","v":"G-StandardGrundpreis"},{"$f":"VLOOKUP(F26,Tarife!$C:$E,3,0)","v":{"v":12,"d":"12.00"}},"CHF/Zähler/Mt",{"$f":"G26*$G$13*$F$10","v":{"v":144,"d":"144.00"}},"CHF"]
[]
["Abgaben"]
["CO2-Abgabe",{"$nulls":4},{"$f":"CONCATENATE(A29,\" \",G16)","v":"CO2-Abgabe Biogas 35 % - Standardmix"},{"$f":"VLOOKUP(F29,Tarife!$C:$E,3,0)","v":2.156},"Rp./kWh",{"$f":"G12*G29/100","v":{"v":754.6,"d":"754.60"}},"CHF"]
["Abgabe an das Gemeinwesen",{"$nulls":4},{"$f":"CONCATENATE(A30)","v":"Abgabe an das Gemeinwesen"},{"$f":"VLOOKUP(F30,Tarife!$C:$E,3,0)","v":{"v":2.9,"d":"2.90"}},"CHF/Zähler/Mt",{"$f":"G30*$G$13*$F$10","v":{"v":34.8,"d":"34.80"}},"CHF"]
[]
["Total Gaskosten exkl. MWST",{"$nulls":7},{"$f":"SUM(I22:I31)","v":{"v":2714.9,"d":"2,714.90"}},"CHF"]
[]
[]
["Dieser Kostenrechner dient als preisliche Indikation und ist nicht verbindlich."]
[]
["Preise für Erdgas, Biogas und CO2-Abgabe sind stets auf die gesamte Menge bezogen, gemäss den publizierten Ansätzen."]
[]
["Alle Preise verstehen sich exklusive MWST."]
["Produkt- und Preisänderungen bleiben vorbehalten."]
["Weitere Informationen, Leistungen und Preisbedingungen sind dem entsprechend gültigen Tarifblatt zu entnehmen."]
[]
["1 Sonderausschüttung nicht mehr gebrauchter Reserven aus der Energiebeschaffung."]

{"sheet":"Tarife","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"hidden":true}
["Tarife zu Kostenrechner Gas",null,"Formelbasis - nicht verändern!",null,2024]
[]
["Tarife Standard-Gasmix."]
["Alle Preise exklusive MWST."]
["Produkt- und Preisänderungen bleiben vorbehalten."]
[]
["Tarif","G-Standard",null,"Einheit"]
["Erdgas",null,{"$f":"CONCATENATE(B7,A8)","v":"G-StandardErdgas"},"Rp./kWh",{"v":6.5,"d":"6.50"}]
["Grundpreis",null,{"$f":"CONCATENATE(B7,A9)","v":"G-StandardGrundpreis"},"CHF/Zähler/Mt",{"v":12,"d":"12.00"}]
[]
[{"$f":"A7","v":"Tarif"},"G-Extra",null,{"$f":"D7","v":"Einheit"}]
["Erdgas",null,{"$f":"CONCATENATE(B11,A12)","v":"G-ExtraErdgas"},"Rp./kWh",5.98]
["Grundpreis",null,{"$f":"CONCATENATE(B11,A13)","v":"G-ExtraGrundpreis"},"CHF/Zähler/Mt",{"v":39,"d":"39.00"}]
[]
["Tarifunabhängige Komponenten",null,null,{"$f":"D7","v":"Einheit"},{"$f":"E1","v":2024}]
["Erdgas Sonderausschüttung1",null,{"$f":"CONCATENATE(A16)","v":"Erdgas Sonderausschüttung1"},"Rp./kWh",-2.81]
["Abgabe an das Gemeinwesen",null,{"$f":"CONCATENATE(A17)","v":"Abgabe an das Gemeinwesen"},"CHF/Zähler/Mt",{"v":2.9,"d":"2.90"}]
[]
[]
["CO2-Abgabe Biogas 0 %",null,{"$f":"CONCATENATE(A20)","v":"CO2-Abgabe Biogas 0 %"},"Rp./kWh",2.156]
["CO2-Abgabe Biogas 35 % - Standardmix",null,{"$f":"CONCATENATE(A21)","v":"CO2-Abgabe Biogas 35 % - Standardmix"},"Rp./kWh",{"$f":"E20","v":2.156}]
["CO2-Abgabe Schweizer Biogas 80 %",null,{"$f":"CONCATENATE(A22)","v":"CO2-Abgabe Schweizer Biogas 80 %"},"Rp./kWh",0.431]
["CO2-Abgabe Schweizer Biogas 100 %",null,{"$f":"CONCATENATE(A23)","v":"CO2-Abgabe Schweizer Biogas 100 %"},"Rp./kWh",{"v":0,"d":"0.000"}]
[]
["Biogas Europa"]
["Biogas 35 % - Standardmix",null,{"$f":"A26","v":"Biogas 35 % - Standardmix"},"Rp./kWh",{"v":1.4,"d":"1.40"}]
["Biogas 0 %",null,{"$f":"A27","v":"Biogas 0 %"},"Rp./kWh",{"v":0,"d":"0.00"}]
[]
["Schweizer Biogas"]
["Schweizer Biogas 80 %",null,{"$f":"A30","v":"Schweizer Biogas 80 %"},"Rp./kWh",9.24]
["Schweizer Biogas 100 %",null,{"$f":"A31","v":"Schweizer Biogas 100 %"},"Rp./kWh",11.56]

{"sheet":"Drop Down","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"hidden":true}
["Drop Down Menu"]
[]
["Periode","Tarifart","Biogasanteil"]
["Monat","G-Standard","Biogas 35 % - Standardmix"]
["Quartal","G-Extra","Biogas 0 %"]
["Jahr",null,"Schweizer Biogas 80 %"]
[null,null,"Schweizer Biogas 100 %"]

{"sheet":"Tabelle3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Tabelle4 ","index":4,"n_rows":0,"n_cols":0,"rows_kept":0}