{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Entgeltrechner"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Entgeltrechner","index":0,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,3,53,9],[14,5,14,7],[30,5,30,7],[6,4,8,8],[50,3,50,9]]}
[]
[null,null,null,"Entgeltrechner 2021"]
[]
[null,null,null," Stand: 15.10.2020"]
[]
[]
[{"$nulls":4},"Entgeltrechner für Kunden mit Leistungsmessung und unterbrechbare Kunden\n(>1,5 Mio. kWh oder > 500 kW)\ninkl. Kapazitätszusagen (vorgelagerter Netzbetreiber ist die terranets bw GmbH)"]
[]
[]
[]
[{"$nulls":5},"Arbeitsentgelt"]
[]
["OTW",0.18959999999999999,null,null,null,"Jahresmenge eingeben:",4000000,"kWh/a"]
[]
["OVW",0.3579,null,null,null,{"$f":"+IF(B42=TRUE,\"\",\"Jahresmenge zu gering\")","v":""}]
["Halbwert",4700000]
["E",0.80656015000000003,null,null,null,"Jahresmenge",{"$f":"IF($B$42=TRUE,G13,\"\")","v":4000000},{"$f":"IF(G13<1500001,\"\",\"kWh\")","v":"kWh"}]
[{"$nulls":5},"Briefmarke Arbeit Ortstransportnetz",{"$f":"IF($B$42=TRUE,ROUND(B13,4),\"\")","v":0.18959999999999999},"Ct/kWh"]
["Arbeitspreis",{"$nulls":4},"Briefmarke Arbeit Ortsverteilnetz",{"$f":"IF($B$42=TRUE,ROUND(B15,4),\"\")","v":0.3579},"Ct/kWh"]
["ct/kWh",{"$f":"ROUND(B13+B15*(1/(1+(G13/B16)^B17)),4)","v":0.38019999999999998},null,null,null,"Wendepunkt Arbeit",{"$f":"IF($B$42=TRUE,ROUND(B16,0),\"\")","v":4700000},"kWh"]
["gerundet mit 4",{"$f":"B13+B15*(1/(1+(G13/B16)^B17))","v":0.38017185240131157},null,null,null,"Exponent Arbeit",{"$f":"IF($B$42=TRUE,ROUND(B17,4),\"\")","v":0.80659999999999998}]
[]
["Arbeitsentgelt",{"$f":"B21*G13/100","v":15206.874096052463},null,null,null,"Individuelles Netzentgelt Arbeit",{"$f":"IF(G13=\"\",\"\",IF($B$42=TRUE,ROUND(B21,5),\"\"))","v":0.38017000000000001},"Ct/kWh"]
[null,{"$f":"IF(H17=\"\",\"\",B23)","v":15206.874096052463},null,null,null,"Arbeitsentgelt",{"$f":"IF(G13=\"\",\"\",IF($B$42=TRUE,ROUND(B23,5),\"\"))","v":15206.874100000001},"€/a"]
[]
[]
[{"$nulls":5},"Leistungsentgelt"]
[]
["OTP",3.58,null,null,null,"Vorhalteleistung eingeben:",2000,"kW"]
["OVP",6.11]
[{"$nulls":5},{"$f":"+IF(B42=TRUE,\"\",\"Vorhalteleistung zu gering\")","v":""}]
["HW",2600]
["E",1.0327915299999999,null,null,null,"Vorhalteleistung:",{"$f":"IF(B42=TRUE,IF(G29=0,\"\",G29),\"\")","v":2000},"kW"]
[{"$nulls":5},"Briefmarke Leistung Ortstransportnetz",{"$f":"IF($B$42=TRUE,ROUND(B29,2),\"\")","v":3.58},"€/kW"]
["Leistungspreis",{"$nulls":4},"Briefmarke Leistung Ortsverteilnetz",{"$f":"IF($B$42=TRUE,ROUND(B30,2),\"\")","v":6.11},"€/kW"]
["€/kW",{"$f":"IF(G29=\"\",\"\",B29+B30/(1+((G29/B32)^B33)))","v":7.0463889364043748},null,null,null,"Wendepunkt Leistung",{"$f":"IF($B$42=TRUE,ROUND(B32,0),\"\")","v":2600},"kW"]
[{"$nulls":5},"Exponent Leistung",{"$f":"IF($B$42=TRUE,ROUND(B33,4),\"\")","v":1.0327999999999999}]
[]
["Leistungsentgelt",{"$f":"ROUND($G$29*B36,2)","v":14092.78},null,null,null,"Individuelles Netzentgelt Leistung",{"$f":"IF(G29=\"\",\"\",IF($B$42=TRUE,ROUND(B36,5),\"\"))","v":7.0463899999999997},"€/kW"]
[{"$nulls":5},"Leistungsentgelt",{"$f":"IF(G29=\"\",\"\",IF($B$42=TRUE,ROUND(B39,2),\"\"))","v":14092.78},"€/a"]
["Prüfung"]
["RLM?",{"$f":"+OR(H19>=1500000,H39>=500)","v":true}]
[{"$nulls":5},{"$f":"IF(G21=\"\",\"\",IF(G40=\"\",\"Summe der Entgelte\",\"Summe der Entgelte\"))","v":"Summe der Entgelte"},{"$f":"IF(G24=\"\",\"\",IF(G40=\"\",G24,G24+G40))","v":29299.6541},{"$f":"IF(F21=\"\",\"\",IF(F40=\"\",\"€/a\",\"€/a\"))","v":"€/a"}]
[{"$f":"+(0.5018/(1+((4/3.1)^0.978780338))+0.1803)","v":0.40006362411284652}]
{"$rows_empty":8}
[null,null,null,"Energieversorgung Filstal GmbH & Co. KG · Großeislinger Straße 30 · 73033 Göppingen\nTelefon: 07161 - 6101-0 · Internet: www.evf.de"]