{"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":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,3,54,9],[14,5,14,7],[30,5,30,7],[6,4,8,8],[51,3,51,9]]}
[]
[null,null,null,"Entgeltrechner"]
[]
[null,null,null," Stand: 01.01.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.19869999999999999,null,null,null,"Jahresmenge eingeben:",4000000,"kWh/a"]
[]
["OVW",0.36280000000000001,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.19869999999999999},"Ct/kWh"]
["Arbeitspreis",{"$nulls":4},"Briefmarke Arbeit Ortsverteilnetz",{"$f":"IF($B$42=TRUE,ROUND(B15,4),\"\")","v":0.36280000000000001},"Ct/kWh"]
["ct/kWh",{"$f":"ROUND(B13+B15*(1/(1+(G13/B16)^B17)),4)","v":0.39190000000000003},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.39188096689353408},null,null,null,"Exponent Arbeit",{"$f":"IF($B$42=TRUE,ROUND(B17,4),\"\")","v":0.80659999999999998}]
[]
["Arbeitsentgelt",{"$f":"B21*G13/100","v":15675.238675741362},null,null,null,"Individuelles Netzentgelt Arbeit",{"$f":"IF(G13=\"\",\"\",IF($B$42=TRUE,ROUND(B21,5),\"\"))","v":0.39188000000000001},"Ct/kWh"]
[null,{"$f":"IF(H17=\"\",\"\",B23)","v":15675.238675741362},null,null,null,"Arbeitsentgelt",{"$f":"IF(G13=\"\",\"\",IF($B$42=TRUE,ROUND(B23,5),\"\"))","v":15675.23868},"€/a"]
[]
[]
[{"$nulls":5},"Leistungsentgelt"]
[]
["OTP",3.6,null,null,null,"Vorhalteleistung eingeben:",2000,"kW"]
["OVP",5.95]
[{"$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.6},"€/kW"]
["Leistungspreis",{"$nulls":4},"Briefmarke Leistung Ortsverteilnetz",{"$f":"IF($B$42=TRUE,ROUND(B30,2),\"\")","v":5.95},"€/kW"]
["€/kW",{"$f":"IF(G29=\"\",\"\",B29+B30/(1+((G29/B32)^B33)))","v":6.9756160673659622},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":13951.23},null,null,null,"Individuelles Netzentgelt Leistung",{"$f":"IF(G29=\"\",\"\",IF($B$42=TRUE,ROUND(B36,5),\"\"))","v":6.9756200000000002},"€/kW"]
[{"$nulls":5},"Leistungsentgelt",{"$f":"IF(G29=\"\",\"\",IF($B$42=TRUE,ROUND(B39,2),\"\"))","v":13951.23},"€/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":29626.468679999998},{"$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":9}
[null,null,null,"Energieversorgung Filstal GmbH & Co. KG · Großeislinger Straße 30 · 73033 Göppingen\nTelefon: 07161 - 6101-0 · Internet: www.evf.de"]