{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Info","Netzbetreiber","SLP-Verfahren","SLP-Temp-Gebiet #01","SLP-Temp-Gebiet #02","SLP-Profile","SLP-Feiertage","BDEW-Standard","Wochentag F(WT)"],"not_rendered":{"images":5,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Info","index":0,"n_rows":30,"n_cols":3,"rows_kept":30}
[]
[null,"BDEW / VKU / GEODE - Excel-Tabelle mit verfahrensspezifischen Parameter"]
[]
[null,"Im Rahmen der Veröffentlichungspflichten des Netzbetreibers zum Standardlastprofilverfahren hat jeder Netzbetreiber"]
[null,"zu seinem Profilverfahren die folgende Excel-Tabelle auf seiner Internetseite zu veröffentlichen. "]
[]
[null,"Die Veröffentlichung erfolgt im Rahmen der Vorgaben der Kooperationsvereinbarung und des Leitfandens \"Abwicklung von Standardlastprofilen Gas\"."]
[null,"Sofern Anpassungen am Bilanzierungsverfahren vorgenommen werden, ist die Excel-Tabelle stets in aktualisierter Form zu veröffentlichen."]
[]
[null,"Hinweise:"]
[null,"Sofern sich verfahrensspezifische Parameter für vorhandene Netzgebiete unterscheiden, ist für jedes Netzgebiet eine separate Datei auszufüllen."]
[null,"Bei Netzbetreibern mit Marktgebietüberlappung sollte das SLP Verfahren in beiden Marktgebieten identisch sein."]
[null,"Bei Netzbetreibern mit Netzgebieten mit H-Gas und L-Gas ist für jedes Netzgebiet eine separate Datei auszufüllen."]
[]
[null,"Herausgeber:"]
[]
[null,"BDEW Bundesverband der Energie- und Wasserwirtschaft e.V., "]
[null,"Reinhardtstraße 32"]
[null,"10117 Berlin"]
[]
[null,"Verband kommunaler Unternehmen e.V. (VKU) "]
[null,"Invalidenstraße 91"]
[null,"10115 Berlin"]
[]
[null,"GEODE – Groupement Européen des entreprises et Organismes de Distribution d’Énergie, EWIV"]
[null,"Magazinstraße 15-16"]
[null,"10179 Berlin "]
[]
[null,"Stand: ","2015-09-01"]
[null,"Version: ","1.0"]

{"sheet":"Netzbetreiber","index":1,"n_rows":48,"n_cols":4,"rows_kept":48}
[]
[null,"Netzbetreiberinformationen"]
[]
[null,null,"Stand der verf.-spezif.  Parameter (\"Speicherdatum\" der Datei):","2015-09-23"]
[]
[null,null,"verf.-spezif. Parameter dieser Datei sind gültig ab: ","2015-10-01"]
[]
[]
[null,"1.","Name des Netzbetreibers:","Stadtwerke Walldof GmbH & Co. KG"]
[]
[null,"2.","Marktpartner-ID (DVGW-Nummer des Netzbetreibers)","9870096700000"]
[]
[null,"3.","Straße, Nr.:","Altrottstraße 39"]
[]
[null,"4.","Postleitzahl:",{"v":69190,"d":"D-69190"}]
[]
[null,"5.","Ort:","Walldorf"]
[]
[null,"6.","Ansprechpartner SLP-Bilanzierung:","Peter Huber"]
[]
[null,"7.","Email-Adresse:","peter.huber@stadtwerke-walldorf.de"]
[]
[null,"8.","Telefonnummer des Ansprechpartners:","06227-8288241"]
[]
[null,"9.","Anzahl betreuter Netzgebiete (Angabe 1 … 20)",1]
[]
[null,"10.","In dieser Datei erfasstes Netzgebiet (eine Datei je Netzgebiet):","Netzgebiet 1"]
[null,null,"Angaben gelten für alle Netzgebiete",{"$f":"IF(D27<>C28,VLOOKUP(D27,$C$29:$D$48,2,FALSE),C28)","v":"Walldorf"}]
[null,null,"Netzgebiet 1","Walldorf"]
[null,null,"Netzgebiet 2"]
[null,null,"Netzgebiet 3"]
[null,null,"Netzgebiet 4"]
[null,null,"Netzgebiet 5"]
[null,null,"Netzgebiet 6"]
[null,null,"Netzgebiet 7"]
[null,null,"Netzgebiet 8"]
[null,null,"Netzgebiet 9"]
[null,null,"Netzgebiet 10"]
[null,null,"Netzgebiet 11"]
[null,null,"Netzgebiet 12"]
[null,null,"Netzgebiet 13"]
[null,null,"Netzgebiet 14"]
[null,null,"Netzgebiet 15"]
[null,null,"Netzgebiet 16"]
[null,null,"Netzgebiet 17"]
[null,null,"Netzgebiet 18"]
[null,null,"Netzgebiet 19"]
[null,null,"Netzgebiet 20"]

{"sheet":"SLP-Verfahren","index":2,"n_rows":62,"n_cols":22,"rows_kept":62}
[]
[null,"Stammdaten Netzgebiet"]
[]
[]
[null,null,"Netzbetreiber: ",{"$f":"Netzbetreiber!$D$9","v":"Stadtwerke Walldof GmbH & Co. KG"}]
[null,null,"Netzgebiet: ",{"$f":"Netzbetreiber!D28","v":"Walldorf"}]
[null,null,"Marktpartner-ID: ",{"$f":"Netzbetreiber!$D$11","v":"9870096700000"}]
[null,null,"gültig ab: ",{"$f":"Netzbetreiber!$D$6","v":"2015-10-01"}]
[]
[]
[null,"11.","Marktgebiet:","NCG",{"$nulls":3},"NCG","Gaspool","MGÜ (NCG/Gaspool)"]
[]
[null,"12.","Gasfamilie:","H-Gas",{"$nulls":3},"H-Gas","L-Gas"]
[]
[null,"13.","Netzkontonummer NCG:","NCHN00700967000"]
[null,null,"Netzkontonummer Gaspool:","GASPOOLNF33"]
[]
[null,"14.","Verwendetes SLP-Verfahren: ","synthetisch",{"$nulls":3},"synthetisch","analytisch"]
[null,null,{"$f":"HLOOKUP($D$18,$H$18:$I$20,2,0)","v":"=> zeitnah ermittelter Netzzustand fließt nicht in Allokation ein"},{"$nulls":4},"=> zeitnah ermittelter Netzzustand fließt nicht in Allokation ein","=>  zeitnah ermittelter Netzustand bestimmt Höhe der täglichen Allokation"]
[null,null,{"$f":"HLOOKUP($D$18,$H$18:$I$20,3,0)","v":"=> Zeitreihentyp SLPsyn"},{"$nulls":4},"=> Zeitreihentyp SLPsyn","=> Zeitreihentyp SLPana"]
[]
[null,"15.","Bilanzierungsrelevanter Wert","Kundenwert  [KW]",{"$nulls":3},"Kundenwert  [KW]","Jahresverbrauchsprognose [JVP]"]
[null,null,{"$f":"HLOOKUP(D22,H22:I23,2,0)","v":"nach TU-München Verfahren"},"JVP / Multiplikator(SLP-Typ)",{"$nulls":3},"nach TU-München Verfahren","Berechnung der Tagesmenge mit: "]
[null,null,"Allokationsfunktion für die  Tagesmenge: ",{"$f":"IF(D22=$H$22,L24,IF(D23=$H$24,M24,N24))","v":"=>  Q(D) = KW  x  h(T, SLP-Typ)  x  F(WT)"},{"$nulls":3},"JVP / Multiplikator(SLP-Typ)","JVP  x  h(T, SLP-Typ')",null,null,"=>  Q(D) = KW  x  h(T, SLP-Typ)  x  F(WT)","=>  Q(D) = JVP / M(SLP-Typ)  x  h(T, SLP-Typ)  x  F(WT)","=>  Q(D) = JVP  x  h(T, SLP-Typ')  x  F(WT)"]
[]
[null,"16.","Korrekturfaktor (synthetisches Verfahren): ","nein",{"$nulls":3},"ja","nein"]
[null,null,"Art des Korrekturfaktors","F(kor) = 1",{"$nulls":3},"F(kor) = 1","statisch ","dynamisch"]
[null,null,{"$f":"HLOOKUP(D27,H27:J28,2,0)","v":"=> Q(Allokation)  =  Q(Synth.);    F(kor) = 1"},{"v":1,"d":"1.00"},{"$nulls":3},"=> Q(Allokation)  =  Q(Synth.);    F(kor) = 1","=> Q(Allokation)  =  Q(Synth.) × F(kor);    F(kor) = ","=> Q(Allokation)  =  Q(Synth.) × F(opt)"]
[null,null,{"$f":"HLOOKUP(D27,H27:J29,3,0)","v":" "},{"$nulls":4}," ","Hinweis: Korrekturfaktoren im synthetischen Verfahren sind von der BNetzA zu genehmigen.  ","Hinweis: dynamische Korrekturfaktoren sind tägl. als anwendungsspezif. Parameter bereitzustellen. "]
[]
[null,"17.","Optimierungsfaktor (analytisches Verfahren):","nein",{"$nulls":3},"ja","nein"]
[null,null,{"$f":"HLOOKUP(D31,$H$31:$I$32,2,0)","v":"=> Q(Allokation)  =  Q(D-2);  F(opt) = 1"},{"$nulls":4},"=> Q(Allokation)  =  Q(D-2) × F(opt)","=> Q(Allokation)  =  Q(D-2);  F(opt) = 1"]
[null,null,{"$f":"HLOOKUP(D31,$H$31:$I$33,3,0)","v":" "},{"$nulls":4},"Hinweis: beim Verwendung von Optimierungsfaktoren, sind tägl. anwendungsspezif. Parameter bereitzustellen. "," "]
[]
[null,"18.","Anzahl verwendeter Profile:",13]
[]
[null,"19.","Anwendungsgrenzen SLP  -  Arbeit [kWh]:",{"v":1500000,"d":"<  1,500,000 kWh"},"(*)"]
[null,null,"(Standard nach § 24 Abs. 1 u. 2 GasNZV: 1,5 Mio. kWh pro Jahr)"]
[]
[null,"20.","Anwendungsgrenzen SLP  -  Leistung [kW]:",{"v":500,"d":"<  500 kW"},"(**)"]
[null,null,"(Standard nach § 24 Abs. 1 u. 2 GasNZV: 500 kW)"]
[]
[null,null,"(*) Angabe Grenzwert oder Verweis auf Hinterlegungsquelle"]
[null,null,"(**) optionale Angabe"]
[]
[null,"21.","Anzahl der Temperaturgebiete des NG: ",1,{"$nulls":3},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[{"$nulls":7},{"$f":"IF(H46<=$D$46,H46,\"\")","v":1},{"$f":"IF(I46<=$D$46,I46,\"\")","v":""},"","","","","","","","","","","","",""]
[null,null,"SLP-Temp-Gebiet 01","Walldorf"]
[null,null,"SLP-Temp-Gebiet 02"]
[null,null,"SLP-Temp-Gebiet 03"]
[null,null,"SLP-Temp-Gebiet 04"]
[null,null,"SLP-Temp-Gebiet 05"]
[null,null,"SLP-Temp-Gebiet 06"]
[null,null,"SLP-Temp-Gebiet 07"]
[null,null,"SLP-Temp-Gebiet 08"]
[null,null,"SLP-Temp-Gebiet 09"]
[null,null,"SLP-Temp-Gebiet 10"]
[null,null,"SLP-Temp-Gebiet 11"]
[null,null,"SLP-Temp-Gebiet 12"]
[null,null,"SLP-Temp-Gebiet 13"]
[null,null,"SLP-Temp-Gebiet 14"]
[null,null,"SLP-Temp-Gebiet 15"]

{"sheet":"SLP-Temp-Gebiet #01","index":3,"n_rows":72,"n_cols":48,"rows_kept":72,"merged":[[12,2,12,4],[13,2,13,3],[14,2,14,3],[71,2,71,5]]}
[]
[null,"Bildungsregel Temperaturzeitreihe(n)    -  a.) Allokationstemperatur und b.) Kundenwerttemperatur"]
[]
[null,null,"Netzbetreiber: ",null,{"$f":"Netzbetreiber!D9","v":"Stadtwerke Walldof GmbH & Co. KG"}]
[null,null,"Netzgebiet: ",null,{"$f":"Netzbetreiber!D28","v":"Walldorf"}]
[null,null,"Marktpartner-ID: ",null,{"$f":"Netzbetreiber!D11","v":"9870096700000"}]
[null,null,"gültig ab: ",null,{"$f":"Netzbetreiber!D6","v":"2015-10-01"}]
[{"$nulls":7},"Hinweis:"]
[null,null,"Anzahl der Temperaturgebiete des Netzgebietes: ",null,null,{"$f":"'SLP-Verfahren'!D46","v":1},null,"Bei mehreren Temperaturgebieten je Netzgebiet jeweils ein weiteres \"Excel-Tabellenblatt\" je "]
[null,null,"Nummer des Temperaturgebietes:",null,null,1,null,"Temperaturgebiet einfügen. Bitte SLP-Temp-Gebiet # \"##\" in Namen des Excel-Tabellenblattes aufnehmen."]
[null,null,"Name des Temperaturgebietes:",null,null,{"$f":"INDEX('SLP-Verfahren'!D48:D62,'SLP-Temp-Gebiet #01'!F10)","v":"Walldorf"}]
[]
[null,null,"Temperaturversatz (der Knickpunkt Temperatur)",null,null,"Tag:","Monat:","DTKP "]
[null,null,"Heizperiode Kernzeit Winter ",null,"Beginn:","15.","Oktober",{"v":0,"d":"+0.00 °C"},{"$nulls":6},"anderer Wetter-Dienstleister (falls verwendet):",null,null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"]
[null,null,"Sommer-/Übergangsperiode ",null,"Beginn:","1.","März",{"v":0,"d":"+0.00 °C"},{"$nulls":6},"Deutscher Wetterdienst",null,null,"1.","2.","3.","4.","5.","6.","7.","8.","9.","10.","11.","12.","13.","14.","15.","16.","17.","18.","19.","20.","21.","22.","23.","24.","25.","26.","27.","28.","29.","30.","31."]
[]
[null,"a.) für Allokationstemperatur (auch für Misch-Allokationstempertur [virt. Wetter-Station])"]
[null,null,"Anzahl Stationen für Misch-Allokationstemperatur: ",null,null,1]
[{"$nulls":4},{"$f":"IF(E20>$F$18,0,1)","v":1},{"$f":"IF(F20>$F$18,0,1)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Temperaturstationen ","Sn",{"v":1,"d":"Station S 1"},{"v":2,"d":"Station S 2"},{"v":3,"d":"Station S 3"},{"v":4,"d":"Station S 4"},{"v":5,"d":"Station S 5"},{"v":6,"d":"Station S 6"},{"v":7,"d":"Station S 7"},{"v":8,"d":"Station S 8"},{"v":9,"d":"Station S 9"},{"v":10,"d":"Station S 10"},"Art des Feldes"]
[null,null,"Gewichtungsfaktoren (Station)","g(Sn)",{"$f":"1-SUMPRODUCT(F19:N19,F21:N21)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(F22/$D$22,4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(G22/$D$22,4)","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,null,"Gewichte (Station)   G(Sn)",{"$f":"SUMPRODUCT(E22:N22,E19:N19)","v":{"v":1,"d":"1.000"}},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"$nulls":8},"Num. Wert"]
[null,null,"Wetter-DL",null,"DWD","DWD","DWD","DWD","DWD","DWD","DWD","DWD","DWD","DWD","Auswahlfeld",null,null,"DWD","MeteoGroup",{"$f":"O15","v":"Deutscher Wetterdienst"}]
[null,null,"Name der Station",null,"Waghäusel","DEF-St.",{"$nulls":8},"Textfeld"]
[null,null,"Stations-Nr. ",null,5275,"xxxxx",{"$nulls":8},"Code",null,null,"St.-Nr."]
[null,null,"Klima-Zeitreihe",null,"Temp. (2m)","Temp. (2m)",{"$nulls":8},"Auswahlfeld",null,null,"Temp. (2m)","Sonstiges"]
[]
[null,null,"Anzahl Temperaturen für Zeitreihengewichtung: ",null,null,4]
[{"$nulls":4},{"$f":"IF(E30>$F$28,0,1)","v":1},{"$f":"IF(F30>$F$28,0,1)","v":1},1,1,0,0,0,0,0,0]
[null,null,"Temp.-ZR Reihenbildung ","Tn",{"v":1,"d":"T1"},{"v":2,"d":"T2"},{"v":3,"d":"T3"},{"v":4,"d":"T4"},{"v":5,"d":"T5"},{"v":6,"d":"T6"},{"v":7,"d":"T7"},{"v":8,"d":"T8"},{"v":9,"d":"T9"},{"v":10,"d":"T10"},"Art des Feldes"]
[null,null,"Gewichtungsfaktoren (Temp.-ZR)   ","g(Tn)",{"$f":"1-SUMPRODUCT(F29:N29,F31:N31)","v":0.5333},{"$f":"ROUND(F32/$D$32,4)","v":0.2667},{"$f":"ROUND(G32/$D$32,4)","v":0.1333},0.0667,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,null,"Gewichte (Temp.-ZR)    G(Tn)",{"$f":"SUMPRODUCT(E32:N32,E29:N29)","v":{"v":1.875,"d":"1.8750"}},{"v":1,"d":"1.0000"},{"v":0.5,"d":"0.5000"},{"v":0.25,"d":"0.2500"},{"v":0.125,"d":"0.1250"},{"$nulls":6},"Num. Wert"]
[null,null,"Temperturzeitraum","[d]","D","D-1","D-2","D-3",{"$nulls":6},"Auswahlfeld",null,null,"D","D-1","D-2","D-3","D-4","D-5","D-6","D-7","D-8","D-9","D-10"]
[null,null,"Tages-Bezug [Gastag/Kalendertag]","[GT/KT]","Gastag","Gastag","Gastag","Gastag",{"$nulls":6},"Auswahlfeld",null,null,"Gastag","Kalendertag"]
[null,null,"Zeitzone für Tages-Bezug","[UCT/CET]","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","Auswahlfeld",null,null,"CET/CEST","UCT"]
[null,null,"Art der Zeitreihe","[IST/Prog]","Temp.-Prog.","Temp.-Prog.","Temp.-IST","Temp.-IST",{"$nulls":6},"Auswahlfeld",null,null,"Temp.-IST","Temp.-Prog."]
[]
[null,null,"Erläuterung: "]
[null,null,"für Betrachtungstag D ",null,"T(Allokation) = T(gew. Stations-Temp) + DTKP"]
[{"$nulls":4},"T(gew. Stations-Temp.) = [TS1 • g(S1)  +  TS2 • g(S2)  +  TS3  •  g(S3)  + ….  +  TS10 • g(S10)]"]
[{"$nulls":4},"Summe(g(S1 …S10)) =  [g(S1) + g(S2) + g(S3) + ... + g(S10)] = 1,000"]
[{"$nulls":4},"TSn(gew.Temp) = [T1 • g(T1)  +  T2 • g(T2)  +  T3 • g(T3)  +  …:  +  T10 • g(T10)]"]
[{"$nulls":4},"Summe(g(T1 …T10)) = [g(T1) + g(T2) + g(T3) +  …   + g(T10)] = 1,000"]
[]
[null,null,"Beispiel für Gewichte  G(Tn):"]
[null,null,"Eintages-Temp. (Vorhersagetemp.)","G(Tn)",{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},"…"]
[null,null,"Geom.-Reihe (gem. LF-SLP)","G(Tn)",{"v":1,"d":"1.0000"},{"v":0.5,"d":"0.5000"},{"v":0.25,"d":"0.2500"},{"v":0.125,"d":"0.1250"},{"v":0,"d":"0.0000"},"…"]
[]
[]
[null,"b.) für Kundenwerttemperatur (auch für Misch-Kundenwerttemperatur [virt. Wetter-Station])"]
[]
[null,null,"Anzahl Station für Misch-Kundenwerttemperatur: ",null,null,{"$f":"F18","v":1}]
[{"$nulls":4},{"$f":"IF(E54>$F$52,0,1)","v":1},{"$f":"IF(F54>$F$52,0,1)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Temperaturstationen ","Sn",{"v":1,"d":"Station S 1"},{"v":2,"d":"Station S 2"},{"v":3,"d":"Station S 3"},{"v":4,"d":"Station S 4"},{"v":5,"d":"Station S 5"},{"v":6,"d":"Station S 6"},{"v":7,"d":"Station S 7"},{"v":8,"d":"Station S 8"},{"v":9,"d":"Station S 9"},{"v":10,"d":"Station S 10"},"Art des Feldes"]
[null,null,"Gewichtungsfaktoren (Station)","g(Sn)",{"$f":"1-SUMPRODUCT(F53:N53,F55:N55)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(F56/$D$56,4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(G56/$D$56,4)","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,null,"Gewichte (Station)   G(Sn)",{"$f":"SUMPRODUCT(E56:N56,E53:N53)","v":{"v":1,"d":"1.000"}},{"$f":"E22","v":{"v":1,"d":"1.0000"}},{"$f":"F22","v":{"v":1,"d":"1.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},"Num. Wert"]
[null,null,"Wetter-DL",null,{"$f":"E23","v":"DWD"},{"$f":"F23","v":"DWD"},"DWD","DWD","DWD","DWD","DWD","DWD","DWD","DWD","Auswahlfeld"]
[null,null,"Name der Station",null,{"$f":"E24","v":"Waghäusel"},{"$f":"F24","v":"DEF-St."},0,0,0,0,0,0,0,0,"Textfeld"]
[null,null,"Stations-Nr. ",null,{"$f":"E25","v":5275},{"$f":"F25","v":"xxxxx"},0,0,0,0,0,0,0,0,"Code"]
[null,null,"Klima-Zeitreihe",null,{"$f":"E26","v":"Temp. (2m)"},{"$f":"F26","v":"Temp. (2m)"},0,0,0,0,0,0,0,0,"Auswahlfeld"]
[]
[null,null,"Anzahl Temperaturen für Zeitreihengewichtung: ",null,null,{"$f":"F28","v":4}]
[{"$nulls":4},{"$f":"IF(E64>$F$62,0,1)","v":1},{"$f":"IF(F64>$F$62,0,1)","v":1},1,1,0,0,0,0,0,0]
[null,null,"Temp.-ZR Reihenbildung ","Tn",{"v":1,"d":"T1"},{"v":2,"d":"T2"},{"v":3,"d":"T3"},{"v":4,"d":"T4"},{"v":5,"d":"T5"},{"v":6,"d":"T6"},{"v":7,"d":"T7"},{"v":8,"d":"T8"},{"v":9,"d":"T9"},{"v":10,"d":"T10"},"Art des Feldes"]
[null,null,"Gewichtungsfaktoren (Temp.-ZR)   ","g(Tn)",{"$f":"1-SUMPRODUCT(F63:N63,F65:N65)","v":0.5333},{"$f":"ROUND(F66/$D$66,4)","v":0.2667},{"$f":"ROUND(G66/$D$66,4)","v":0.1333},0.0667,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,null,"Gewichte (Temp.-ZR)    G(Tn)",{"$f":"SUMPRODUCT(E66:N66,E63:N63)","v":1.875},{"$f":"E32","v":{"v":1,"d":"1.0000"}},{"$f":"F32","v":{"v":0.5,"d":"0.5000"}},{"v":0.25,"d":"0.2500"},{"v":0.125,"d":"0.1250"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},"Num. Wert"]
[null,null,"Temperturzeitraum","[d]",{"$f":"E33","v":"D"},{"$f":"F33","v":"D-1"},"D-2","D-3",0,0,0,0,0,0,"Auswahlfeld"]
[null,null,"Tages-Bezug [Gastag/Kalendertag]","[GT/KT]",{"$f":"E34","v":"Gastag"},{"$f":"F34","v":"Gastag"},"Gastag","Gastag",0,0,0,0,0,0,"Auswahlfeld"]
[null,null,"Zeitzone für Tages-Bezug","[UCT/CET]",{"$f":"E35","v":"CET/CEST"},{"$f":"F35","v":"CET/CEST"},"CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","Auswahlfeld"]
[null,null,"Art der Zeitreihe","[IST/Prog]","Temp.-IST","Temp.-IST",{"$f":"G36","v":"Temp.-IST"},"Temp.-IST",0,0,0,0,0,0,"Auswahlfeld"]
[]
[null,null,"Berechnung analog Allokationstemperatur (siehe Erläuterung) "]

{"sheet":"SLP-Temp-Gebiet #02","index":4,"n_rows":72,"n_cols":48,"rows_kept":72,"hidden":true,"merged":[[12,2,12,4],[13,2,13,3],[14,2,14,3],[71,2,71,5]]}
[]
[null,"Bildungsregel Temperaturzeitreihe(n)    -  a.) Allokationstemperatur und b.) Kundenwerttemperatur"]
[]
[null,null,"Netzbetreiber: ",null,{"$f":"Netzbetreiber!$D$9","v":"Stadtwerke Walldof GmbH & Co. KG"}]
[null,null,"Netzgebiet: ",null,{"$f":"Netzbetreiber!$D$28","v":"Walldorf"}]
[null,null,"Marktpartner-ID: ",null,{"$f":"Netzbetreiber!$D$11","v":"9870096700000"}]
[null,null,"gültig ab: ",null,{"$f":"Netzbetreiber!$D$6","v":"2015-10-01"}]
[{"$nulls":7},"Hinweis:"]
[null,null,"Anzahl der Temperaturgebiete des Netzgebietes: ",null,null,{"$f":"'SLP-Verfahren'!D46","v":1},null,"Bei mehreren Temperaturgebieten je Netzgebiet jeweils ein weiteres \"Excel-Tabellenblatt\" je "]
[null,null,"Nummer des Temperaturgebietes:",null,null,2,null,"Temperaturgebiet einfügen. Bitte SLP-Temp-Gebiet # \"##\" in Namen des Excel-Tabellenblattes aufnehmen."]
[null,null,"Name des Temperaturgebietes:",null,null,{"$f":"INDEX('SLP-Verfahren'!D48:D62,'SLP-Temp-Gebiet #02'!F10)","v":0}]
[]
[null,null,"Temperaturversatz (der Knickpunkt Temperatur)",null,null,"Tag:","Monat:","DTKP "]
[null,null,"Heizperiode Kernzeit Winter ",null,"Beginn:","15.","Oktober",{"v":0,"d":"+0.00 °C"},{"$nulls":6},"anderer Wetter-Dienstleister (falls verwendet):",null,null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"]
[null,null,"Sommer-/Übergangsperiode ",null,"Beginn:","1.","März",{"v":0,"d":"+0.00 °C"},{"$nulls":6},"Wetterdienstleister ABC",null,null,"1.","2.","3.","4.","5.","6.","7.","8.","9.","10.","11.","12.","13.","14.","15.","16.","17.","18.","19.","20.","21.","22.","23.","24.","25.","26.","27.","28.","29.","30.","31."]
[]
[null,"a.) für Allokationstemperatur (auch für Misch-Allokationstempertur [virt. Wetter-Station])"]
[null,null,"Anzahl Stationen für Misch-Allokationstemperatur: ",null,null,2]
[{"$nulls":4},{"$f":"IF(E20>$F$18,0,1)","v":1},{"$f":"IF(F20>$F$18,0,1)","v":1},0,0,0,0,0,0,0,0]
[null,null,"Temperaturstationen ","Sn",{"v":1,"d":"Station S 1"},{"v":2,"d":"Station S 2"},{"v":3,"d":"Station S 3"},{"v":4,"d":"Station S 4"},{"v":5,"d":"Station S 5"},{"v":6,"d":"Station S 6"},{"v":7,"d":"Station S 7"},{"v":8,"d":"Station S 8"},{"v":9,"d":"Station S 9"},{"v":10,"d":"Station S 10"},"Art des Feldes"]
[null,null,"Gewichtungsfaktoren (Station)","g(Sn)",{"$f":"1-SUMPRODUCT(F19:N19,F21:N21)","v":{"v":0.5,"d":"0.5000"}},{"$f":"ROUND(F22/$D$22,4)","v":{"v":0.5,"d":"0.5000"}},{"$f":"ROUND(G22/$D$22,4)","v":{"v":0,"d":"0.000"}},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,null,"Gewichte (Station)   G(Sn)",{"$f":"SUMPRODUCT(E22:N22,E19:N19)","v":{"v":2,"d":"2.000"}},{"v":1,"d":"1.0000"},{"v":1,"d":"1.0000"},{"$nulls":8},"Num. Wert"]
[null,null,"Wetter-DL",null,"DWD","DWD","DWD","DWD","DWD","DWD","DWD","DWD","DWD","DWD","Auswahlfeld",null,null,"DWD","MeteoGroup",{"$f":"O15","v":"Wetterdienstleister ABC"}]
[null,null,"Name der Station",null,"ABC-St.","DEF-St.",{"$nulls":8},"Textfeld"]
[null,null,"Stations-Nr. ",null,"xxxxx","xxxxx",{"$nulls":8},"Code",null,null,"St.-Nr."]
[null,null,"Klima-Zeitreihe",null,"Temp. (2m)","Temp. (2m)",{"$nulls":8},"Auswahlfeld",null,null,"Temp. (2m)","Sonstiges"]
[]
[null,null,"Anzahl Temperaturen für Zeitreihengewichtung: ",null,null,4]
[{"$nulls":4},{"$f":"IF(E30>$F$28,0,1)","v":1},{"$f":"IF(F30>$F$28,0,1)","v":1},1,1,0,0,0,0,0,0]
[null,null,"Temp.-ZR Reihenbildung ","Tn",{"v":1,"d":"T1"},{"v":2,"d":"T2"},{"v":3,"d":"T3"},{"v":4,"d":"T4"},{"v":5,"d":"T5"},{"v":6,"d":"T6"},{"v":7,"d":"T7"},{"v":8,"d":"T8"},{"v":9,"d":"T9"},{"v":10,"d":"T10"},"Art des Feldes"]
[null,null,"Gewichtungsfaktoren (Temp.-ZR)   ","g(Tn)",{"$f":"1-SUMPRODUCT(F29:N29,F31:N31)","v":0.5333},{"$f":"ROUND(F32/$D$32,4)","v":0.2667},{"$f":"ROUND(G32/$D$32,4)","v":0.1333},0.0667,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,null,"Gewichte (Temp.-ZR)    G(Tn)",{"$f":"SUMPRODUCT(E32:N32,E29:N29)","v":{"v":1.875,"d":"1.8750"}},{"v":1,"d":"1.0000"},{"v":0.5,"d":"0.5000"},{"v":0.25,"d":"0.2500"},{"v":0.125,"d":"0.1250"},{"$nulls":6},"Num. Wert"]
[null,null,"Temperturzeitraum","[d]","D","D-1","D-2","D-3",{"$nulls":6},"Auswahlfeld",null,null,"D","D-1","D-2","D-3","D-4","D-5","D-6","D-7","D-8","D-9","D-10"]
[null,null,"Tages-Bezug [Gastag/Kalendertag]","[GT/KT]","Gastag","Gastag","Gastag","Gastag",{"$nulls":6},"Auswahlfeld",null,null,"Gastag","Kalendertag"]
[null,null,"Zeitzone für Tages-Bezug","[UCT/CET]","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","Auswahlfeld",null,null,"CET/CEST","UCT"]
[null,null,"Art der Zeitreihe","[IST/Prog]","Temp.-Prog.","Temp.-Prog.","Temp.-IST","Temp.-IST",{"$nulls":6},"Auswahlfeld",null,null,"Temp.-IST","Temp.-Prog."]
[]
[null,null,"Erläuterung: "]
[null,null,"für Betrachtungstag D ",null,"T(Allokation) = T(gew. Stations-Temp) + DTKP"]
[{"$nulls":4},"T(gew. Stations-Temp.) = [TS1 • g(S1)  +  TS2 • g(S2)  +  TS3  •  g(S3)  + ….  +  TS10 • g(S10)]"]
[{"$nulls":4},"Summe(g(S1 …S10)) =  [g(S1) + g(S2) + g(S3) + ... + g(S10)] = 1,000"]
[{"$nulls":4},"TSn(gew.Temp) = [T1 • g(T1)  +  T2 • g(T2)  +  T3 • g(T3)  +  …:  +  T10 • g(T10)]"]
[{"$nulls":4},"Summe(g(T1 …T10)) = [g(T1) + g(T2) + g(T3) +  …   + g(T10)] = 1,000"]
[]
[null,null,"Beispiel für Gewichte  G(Tn):"]
[null,null,"Eintages-Temp. (Vorhersagetemp.)","G(Tn)",{"v":1,"d":"1.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},"…"]
[null,null,"Geom.-Reihe (gem. LF-SLP)","G(Tn)",{"v":1,"d":"1.0000"},{"v":0.5,"d":"0.5000"},{"v":0.25,"d":"0.2500"},{"v":0.125,"d":"0.1250"},{"v":0,"d":"0.0000"},"…"]
[]
[]
[null,"b.) für Kundenwerttemperatur (auch für Misch-Kundenwerttemperatur [virt. Wetter-Station])"]
[]
[null,null,"Anzahl Station für Misch-Kundenwerttemperatur: ",null,null,{"$f":"F18","v":2}]
[{"$nulls":4},{"$f":"IF(E54>$F$52,0,1)","v":1},{"$f":"IF(F54>$F$52,0,1)","v":1},0,0,0,0,0,0,0,0]
[null,null,"Temperaturstationen ","Sn",{"v":1,"d":"Station S 1"},{"v":2,"d":"Station S 2"},{"v":3,"d":"Station S 3"},{"v":4,"d":"Station S 4"},{"v":5,"d":"Station S 5"},{"v":6,"d":"Station S 6"},{"v":7,"d":"Station S 7"},{"v":8,"d":"Station S 8"},{"v":9,"d":"Station S 9"},{"v":10,"d":"Station S 10"},"Art des Feldes"]
[null,null,"Gewichtungsfaktoren (Station)","g(Sn)",{"$f":"1-SUMPRODUCT(F53:N53,F55:N55)","v":{"v":0.5,"d":"0.5000"}},{"$f":"ROUND(F56/$D$56,4)","v":{"v":0.5,"d":"0.5000"}},{"$f":"ROUND(G56/$D$56,4)","v":{"v":0,"d":"0.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,null,"Gewichte (Station)   G(Sn)",{"$f":"SUMPRODUCT(E56:N56,E53:N53)","v":{"v":2,"d":"2.000"}},{"$f":"E22","v":{"v":1,"d":"1.0000"}},{"$f":"F22","v":{"v":1,"d":"1.0000"}},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},"Num. Wert"]
[null,null,"Wetter-DL",null,{"$f":"E23","v":"DWD"},"DWD","DWD","DWD","DWD","DWD","DWD","DWD","DWD","DWD","Auswahlfeld"]
[null,null,"Name der Station",null,{"$f":"E24","v":"ABC-St."},"DEF-St.",0,0,0,0,0,0,0,0,"Textfeld"]
[null,null,"Stations-Nr. ",null,{"$f":"E25","v":"xxxxx"},"xxxxx",0,0,0,0,0,0,0,0,"Code"]
[null,null,"Klima-Zeitreihe",null,{"$f":"E26","v":"Temp. (2m)"},"Temp. (2m)",0,0,0,0,0,0,0,0,"Auswahlfeld"]
[]
[null,null,"Anzahl Temperaturen für Zeitreihengewichtung: ",null,null,{"$f":"F28","v":4}]
[{"$nulls":4},{"$f":"IF(E64>$F$62,0,1)","v":1},{"$f":"IF(F64>$F$62,0,1)","v":1},1,1,0,0,0,0,0,0]
[null,null,"Temp.-ZR Reihenbildung ","Tn",{"v":1,"d":"T1"},{"v":2,"d":"T2"},{"v":3,"d":"T3"},{"v":4,"d":"T4"},{"v":5,"d":"T5"},{"v":6,"d":"T6"},{"v":7,"d":"T7"},{"v":8,"d":"T8"},{"v":9,"d":"T9"},{"v":10,"d":"T10"},"Art des Feldes"]
[null,null,"Gewichtungsfaktoren (Temp.-ZR)   ","g(Tn)",{"$f":"1-SUMPRODUCT(F63:N63,F65:N65)","v":0.5333},{"$f":"ROUND(F66/$D$66,4)","v":0.2667},{"$f":"ROUND(G66/$D$66,4)","v":0.1333},0.0667,{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"}]
[null,null,"Gewichte (Temp.-ZR)    G(Tn)",{"$f":"SUMPRODUCT(E66:N66,E63:N63)","v":1.875},{"$f":"E32","v":{"v":1,"d":"1.0000"}},{"$f":"F32","v":{"v":0.5,"d":"0.5000"}},{"v":0.25,"d":"0.2500"},{"v":0.125,"d":"0.1250"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},{"v":0,"d":"0.0000"},"Num. Wert"]
[null,null,"Temperturzeitraum","[d]",{"$f":"E33","v":"D"},"D-1","D-2","D-3",0,0,0,0,0,0,"Auswahlfeld"]
[null,null,"Tages-Bezug [Gastag/Kalendertag]","[GT/KT]",{"$f":"E34","v":"Gastag"},"Gastag","Gastag","Gastag",0,0,0,0,0,0,"Auswahlfeld"]
[null,null,"Zeitzone für Tages-Bezug","[UCT/CET]",{"$f":"E35","v":"CET/CEST"},"CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","CET/CEST","Auswahlfeld"]
[null,null,"Art der Zeitreihe","[IST/Prog]","Temp.-IST","Temp.-IST","Temp.-IST","Temp.-IST",0,0,0,0,0,0,"Auswahlfeld"]
[]
[null,null,"Berechnung analog Allokationstemperatur (siehe Erläuterung) "]

{"sheet":"SLP-Profile","index":5,"n_rows":41,"n_cols":25,"rows_kept":41}
[]
[null,"Verwendete SLP Profiltypen"]
[null,"Hier sind alle vom Netzbetreiber im Netzgebiet verwendeten SLP-Profiltypen aufzuführen."]
[]
[null,null,"Netzbetreiber:",{"$f":"Netzbetreiber!$D$9","v":"Stadtwerke Walldof GmbH & Co. KG"},{"$nulls":5},"Hinweis:","Profilnomenklaturen können in Zelle \"E11\" eingesehen werden. Doppelt hinterlegte Profile sind rot markiert"]
[null,null,"Netzgebiet:",{"$f":"Netzbetreiber!$D$28","v":"Walldorf"},{"$nulls":6},"Formeln/Koeffizienten zur Koeffizientenübernahme der BDEW-Profile können aus Zeile \"11\" übernommen werden"]
[null,null,"Marktpartner-ID: ",{"$f":"Netzbetreiber!$D$11","v":"9870096700000"}]
[null,null,"gültig ab: ",{"$f":"Netzbetreiber!$D$6","v":"2015-10-01"},{"$nulls":3},"Anzahl verwendeter Profile:",null,{"$f":"COUNTA(D12:D100)","v":13}]
[{"$nulls":5},2,null,4,5,6,7,8,9,10,11,12,8,3,4,5,6,7,8,9]
[null,"#","Netzgebiet","Profil-Art","BDEW Nomen-\nklatur","EDI-CODE",null,"A","B","C","D","ϑ0","mH","bH","mW","bW","h(8°C) \n(FWT = 1)","FWT (Mo.)","FWT (Di.)","FWT (Mi.)","FWT (Do.)","FWT (Fr.)","FWT (Sa.)","FWT (So.)","Multiplikator MSLP \nUmrechnungsfaktor: \nKW  =  JVP / MSLP"]
[null,"Muster","Abruf von BDEW-Standardwerten:","BDEW","DE_GKO34",{"$f":"VLOOKUP($E11,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"OK4"},null,{"$f":"ROUND(VLOOKUP($E11,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":1.4256684,"d":"1.4256684 "}},{"$f":"ROUND(VLOOKUP($E11,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":-36.6590504},{"$f":"ROUND(VLOOKUP($E11,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":7.6083226,"d":"7.6083226 "}},{"$f":"ROUND(VLOOKUP($E11,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.0371116,"d":"0.0371116 "}},{"$f":"ROUND(VLOOKUP($E11,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0 "}},{"$f":"ROUND(VLOOKUP($E11,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":-0.0809359},{"$f":"ROUND(VLOOKUP($E11,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":{"v":1.2364527,"d":"1.2364527 "}},{"$f":"ROUND(VLOOKUP($E11,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":{"v":-7.628E-4,"d":"-0.0007628"}},{"$f":"ROUND(VLOOKUP($E11,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":{"v":0.1002979,"d":"0.1002979 "}},{"$f":"($H11/(1+($I11/($Q$9-$L11))^$J11)+$K11)+MAX($M11*$Q$9+$N11,$O11*$Q$9+$P11)","v":{"v":0.9999999603349892,"d":"1.00000 "}},{"$f":"ROUND(VLOOKUP(MID($E11,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":1.0354},{"$f":"ROUND(VLOOKUP(MID($E11,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":1.0523},{"$f":"ROUND(VLOOKUP(MID($E11,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":1.0449},{"$f":"ROUND(VLOOKUP(MID($E11,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":1.0494},{"$f":"ROUND(VLOOKUP(MID($E11,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":0.9885},{"$f":"ROUND(VLOOKUP(MID($E11,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":{"v":0.886,"d":"0.8860"}},{"$f":"7-SUM(R11:W11)","v":{"v":0.9434999999999993,"d":"0.9435"}},365.123]
[null,1,{"$f":"$D$6","v":"Walldorf"},"BDEW","BW_HEF04",{"$f":"VLOOKUP($E12,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"W14"},null,{"$f":"ROUND(VLOOKUP($E12,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":3.1764404,"d":"3.1764404 "}},{"$f":"ROUND(VLOOKUP($E12,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":-37.4105832},{"$f":"ROUND(VLOOKUP($E12,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":6.1622336,"d":"6.1622336 "}},{"$f":"ROUND(VLOOKUP($E12,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.0759377,"d":"0.0759377 "}},{"$f":"ROUND(VLOOKUP($E12,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E12,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E12,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E12,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E12,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"$f":"($H12/(1+($I12/($Q$9-$L12))^$J12)+$K12)+MAX($M12*$Q$9+$N12,$O12*$Q$9+$P12)","v":{"v":0.9537403328806262,"d":"0.95374 "}},{"$f":"ROUND(VLOOKUP(MID($E12,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(VLOOKUP(MID($E12,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(VLOOKUP(MID($E12,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(VLOOKUP(MID($E12,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(VLOOKUP(MID($E12,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(VLOOKUP(MID($E12,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"7-SUM(R12:W12)","v":{"v":1,"d":"1.0000"}}]
[null,2,"Walldorf","BDEW","BW_HMF04",{"$f":"VLOOKUP($E13,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"W24"},null,{"$f":"ROUND(VLOOKUP($E13,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":2.507817,"d":"2.5078170 "}},{"$f":"ROUND(VLOOKUP($E13,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":-35.0367363},{"$f":"ROUND(VLOOKUP($E13,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":6.2430159,"d":"6.2430159 "}},{"$f":"ROUND(VLOOKUP($E13,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.1025195,"d":"0.1025195 "}},{"$f":"ROUND(VLOOKUP($E13,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E13,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E13,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E13,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E13,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":1.0107516326442527,"d":"1.01075 "},{"$f":"ROUND(VLOOKUP(MID($E13,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(VLOOKUP(MID($E13,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(VLOOKUP(MID($E13,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(VLOOKUP(MID($E13,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(VLOOKUP(MID($E13,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"ROUND(VLOOKUP(MID($E13,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":{"v":1,"d":"1.0000"}},{"$f":"7-SUM(R13:W13)","v":{"v":1,"d":"1.0000"}}]
[null,3,"Walldorf","BDEW","DE_GMK04",{"$f":"VLOOKUP($E14,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"MK4"},null,{"$f":"ROUND(VLOOKUP($E14,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":3.1177248,"d":"3.1177248 "}},{"$f":"ROUND(VLOOKUP($E14,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":-35.8715062},{"$f":"ROUND(VLOOKUP($E14,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":7.5186829,"d":"7.5186829 "}},{"$f":"ROUND(VLOOKUP($E14,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.0343301,"d":"0.0343301 "}},{"$f":"ROUND(VLOOKUP($E14,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E14,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E14,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E14,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E14,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":0.9622064996731321,"d":"0.96221 "},{"$f":"ROUND(VLOOKUP(MID($E14,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":1.0699},{"$f":"ROUND(VLOOKUP(MID($E14,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":1.0365},{"$f":"ROUND(VLOOKUP(MID($E14,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":0.9933},{"$f":"ROUND(VLOOKUP(MID($E14,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":0.9948},{"$f":"ROUND(VLOOKUP(MID($E14,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":1.0659},{"$f":"ROUND(VLOOKUP(MID($E14,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":0.9362},{"v":0.9033999999999995,"d":"0.9034"}]
[null,4,"Walldorf","BDEW","DE_GHA04",{"$f":"VLOOKUP($E15,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"HA4"},null,{"$f":"ROUND(VLOOKUP($E15,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":4.0196902,"d":"4.0196902 "}},{"$f":"ROUND(VLOOKUP($E15,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":-37.8282037},{"$f":"ROUND(VLOOKUP($E15,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":8.1593369,"d":"8.1593369 "}},{"$f":"ROUND(VLOOKUP($E15,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.0472845,"d":"0.0472845 "}},{"$f":"ROUND(VLOOKUP($E15,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E15,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E15,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E15,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E15,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":0.8648671330326079,"d":"0.86487 "},{"$f":"ROUND(VLOOKUP(MID($E15,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":1.0358},{"$f":"ROUND(VLOOKUP(MID($E15,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":1.0232},{"$f":"ROUND(VLOOKUP(MID($E15,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":1.0252},{"$f":"ROUND(VLOOKUP(MID($E15,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":1.0295},{"$f":"ROUND(VLOOKUP(MID($E15,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":1.0253},{"$f":"ROUND(VLOOKUP(MID($E15,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":0.9675},{"v":0.8935000000000004,"d":"0.8935"}]
[null,5,"Walldorf","BDEW","DE_GKO04",{"$f":"VLOOKUP($E16,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"KO4"},null,{"$f":"ROUND(VLOOKUP($E16,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":3.4428943,"d":"3.4428943 "}},{"$f":"ROUND(VLOOKUP($E16,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":-36.6590504},{"$f":"ROUND(VLOOKUP($E16,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":7.6083226,"d":"7.6083226 "}},{"$f":"ROUND(VLOOKUP($E16,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.074685,"d":"0.0746850 "}},{"$f":"ROUND(VLOOKUP($E16,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E16,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E16,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E16,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E16,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":0.9776838211052654,"d":"0.97768 "},{"$f":"ROUND(VLOOKUP(MID($E16,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":1.0354},{"$f":"ROUND(VLOOKUP(MID($E16,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":1.0523},{"$f":"ROUND(VLOOKUP(MID($E16,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":1.0449},{"$f":"ROUND(VLOOKUP(MID($E16,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":1.0494},{"$f":"ROUND(VLOOKUP(MID($E16,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":0.9885},{"$f":"ROUND(VLOOKUP(MID($E16,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":{"v":0.886,"d":"0.8860"}},{"v":0.9434999999999993,"d":"0.9435"}]
[null,6,"Walldorf","BDEW","DE_GBD04",{"$f":"VLOOKUP($E17,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"BD4"},null,{"$f":"ROUND(VLOOKUP($E17,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":3.75,"d":"3.7500000 "}},{"$f":"ROUND(VLOOKUP($E17,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":{"v":-37.5,"d":"-37.5000000"}},{"$f":"ROUND(VLOOKUP($E17,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":6.8,"d":"6.8000000 "}},{"$f":"ROUND(VLOOKUP($E17,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.0609113,"d":"0.0609113 "}},{"$f":"ROUND(VLOOKUP($E17,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E17,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E17,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E17,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E17,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":1.0126136468627658,"d":"1.01261 "},{"$f":"ROUND(VLOOKUP(MID($E17,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":1.1052},{"$f":"ROUND(VLOOKUP(MID($E17,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":1.0857},{"$f":"ROUND(VLOOKUP(MID($E17,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":1.0378},{"$f":"ROUND(VLOOKUP(MID($E17,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":1.0622},{"$f":"ROUND(VLOOKUP(MID($E17,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":1.0266},{"$f":"ROUND(VLOOKUP(MID($E17,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":0.7629},0.9196]
[null,7,"Walldorf","BDEW","DE_GGA04",{"$f":"VLOOKUP($E18,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"GA4"},null,{"$f":"ROUND(VLOOKUP($E18,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":2.8195656,"d":"2.8195656 "}},{"$f":"ROUND(VLOOKUP($E18,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":{"v":-36,"d":"-36.0000000"}},{"$f":"ROUND(VLOOKUP($E18,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":7.7368518,"d":"7.7368518 "}},{"$f":"ROUND(VLOOKUP($E18,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.157281,"d":"0.1572810 "}},{"$f":"ROUND(VLOOKUP($E18,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E18,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E18,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E18,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E18,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":0.9657633768575921,"d":"0.96576 "},{"$f":"ROUND(VLOOKUP(MID($E18,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":0.9322},{"$f":"ROUND(VLOOKUP(MID($E18,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":0.9894},{"$f":"ROUND(VLOOKUP(MID($E18,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":1.0033},{"$f":"ROUND(VLOOKUP(MID($E18,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":1.0109},{"$f":"ROUND(VLOOKUP(MID($E18,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":{"v":1.018,"d":"1.0180"}},{"$f":"ROUND(VLOOKUP(MID($E18,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":1.0356},{"v":1.0106000000000002,"d":"1.0106"}]
[null,8,"Walldorf","BDEW","DE_GBH04",{"$f":"VLOOKUP($E19,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"BH4"},null,{"$f":"ROUND(VLOOKUP($E19,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":2.4595181,"d":"2.4595181 "}},{"$f":"ROUND(VLOOKUP($E19,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":-35.2532124},{"$f":"ROUND(VLOOKUP($E19,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":6.0587001,"d":"6.0587001 "}},{"$f":"ROUND(VLOOKUP($E19,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.164737,"d":"0.1647370 "}},{"$f":"ROUND(VLOOKUP($E19,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E19,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E19,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E19,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E19,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":1.043802057143173,"d":"1.04380 "},{"$f":"ROUND(VLOOKUP(MID($E19,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":0.9767},{"$f":"ROUND(VLOOKUP(MID($E19,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":1.0389},{"$f":"ROUND(VLOOKUP(MID($E19,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":1.0028},{"$f":"ROUND(VLOOKUP(MID($E19,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":1.0162},{"$f":"ROUND(VLOOKUP(MID($E19,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":1.0024},{"$f":"ROUND(VLOOKUP(MID($E19,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":1.0043},{"v":0.9587000000000012,"d":"0.9587"}]
[null,9,"Walldorf","BDEW","DE_GWA04",{"$f":"VLOOKUP($E20,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"WA4"},null,{"$f":"ROUND(VLOOKUP($E20,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":1.0535875,"d":"1.0535875 "}},{"$f":"ROUND(VLOOKUP($E20,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":{"v":-35.3,"d":"-35.3000000"}},{"$f":"ROUND(VLOOKUP($E20,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":4.8662747,"d":"4.8662747 "}},{"$f":"ROUND(VLOOKUP($E20,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.6811042,"d":"0.6811042 "}},{"$f":"ROUND(VLOOKUP($E20,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E20,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E20,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E20,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E20,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":1.0844348950990992,"d":"1.08443 "},{"$f":"ROUND(VLOOKUP(MID($E20,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":1.2457},{"$f":"ROUND(VLOOKUP(MID($E20,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":1.2615},{"$f":"ROUND(VLOOKUP(MID($E20,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":1.2707},{"$f":"ROUND(VLOOKUP(MID($E20,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":{"v":1.243,"d":"1.2430"}},{"$f":"ROUND(VLOOKUP(MID($E20,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":1.1276},{"$f":"ROUND(VLOOKUP(MID($E20,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":0.3877},0.4638]
[null,10,"Walldorf","BDEW","DE_GGB04",{"$f":"VLOOKUP($E21,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"GB4"},null,{"$f":"ROUND(VLOOKUP($E21,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":3.6017736,"d":"3.6017736 "}},{"$f":"ROUND(VLOOKUP($E21,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":-37.8825368},{"$f":"ROUND(VLOOKUP($E21,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":6.983607,"d":"6.9836070 "}},{"$f":"ROUND(VLOOKUP($E21,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.0548262,"d":"0.0548262 "}},{"$f":"ROUND(VLOOKUP($E21,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E21,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E21,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E21,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E21,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":0.9023937597531186,"d":"0.90239 "},{"$f":"ROUND(VLOOKUP(MID($E21,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":0.9897},{"$f":"ROUND(VLOOKUP(MID($E21,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":0.9627},{"$f":"ROUND(VLOOKUP(MID($E21,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":1.0507},{"$f":"ROUND(VLOOKUP(MID($E21,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":1.0552},{"$f":"ROUND(VLOOKUP(MID($E21,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":1.0297},{"$f":"ROUND(VLOOKUP(MID($E21,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":0.9767},{"v":0.9352999999999998,"d":"0.9353"}]
[null,11,"Walldorf","BDEW","DE_GBA04",{"$f":"VLOOKUP($E22,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"BA4"},null,{"$f":"ROUND(VLOOKUP($E22,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":0.9315889,"d":"0.9315889 "}},{"$f":"ROUND(VLOOKUP($E22,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":{"v":-33.35,"d":"-33.3500000"}},{"$f":"ROUND(VLOOKUP($E22,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":5.7212303,"d":"5.7212303 "}},{"$f":"ROUND(VLOOKUP($E22,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.6656494,"d":"0.6656494 "}},{"$f":"ROUND(VLOOKUP($E22,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E22,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E22,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E22,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E22,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":1.0766391850538448,"d":"1.07664 "},{"$f":"ROUND(VLOOKUP(MID($E22,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":1.0848},{"$f":"ROUND(VLOOKUP(MID($E22,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":1.1211},{"$f":"ROUND(VLOOKUP(MID($E22,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":1.0769},{"$f":"ROUND(VLOOKUP(MID($E22,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":1.1353},{"$f":"ROUND(VLOOKUP(MID($E22,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":1.1402},{"$f":"ROUND(VLOOKUP(MID($E22,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":0.4852},{"v":0.9565000000000001,"d":"0.9565"}]
[null,12,"Walldorf","BDEW","DE_GPD04",{"$f":"VLOOKUP($E23,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"PD4"},null,{"$f":"ROUND(VLOOKUP($E23,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":3.85,"d":"3.8500000 "}},{"$f":"ROUND(VLOOKUP($E23,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":{"v":-37,"d":"-37.0000000"}},{"$f":"ROUND(VLOOKUP($E23,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":10.2405021,"d":"10.2405021 "}},{"$f":"ROUND(VLOOKUP($E23,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.0469243,"d":"0.0469243 "}},{"$f":"ROUND(VLOOKUP($E23,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E23,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E23,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E23,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E23,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":0.7569106527987923,"d":"0.75691 "},{"$f":"ROUND(VLOOKUP(MID($E23,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":1.0214},{"$f":"ROUND(VLOOKUP(MID($E23,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":1.0866},{"$f":"ROUND(VLOOKUP(MID($E23,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":{"v":1.072,"d":"1.0720"}},{"$f":"ROUND(VLOOKUP(MID($E23,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":1.0557},{"$f":"ROUND(VLOOKUP(MID($E23,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":1.0117},{"$f":"ROUND(VLOOKUP(MID($E23,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":0.9001},{"v":0.8524999999999991,"d":"0.8525"}]
[null,13,"Walldorf","BDEW","DE_GMF04",{"$f":"VLOOKUP($E24,'BDEW-Standard'!$B$3:$M$158,F$9,0)","v":"MF4"},null,{"$f":"ROUND(VLOOKUP($E24,'BDEW-Standard'!$B$3:$M$158,H$9,0),7)","v":{"v":2.5187775,"d":"2.5187775 "}},{"$f":"ROUND(VLOOKUP($E24,'BDEW-Standard'!$B$3:$M$158,I$9,0),7)","v":-35.0333754},{"$f":"ROUND(VLOOKUP($E24,'BDEW-Standard'!$B$3:$M$158,J$9,0),7)","v":{"v":6.2240634,"d":"6.2240634 "}},{"$f":"ROUND(VLOOKUP($E24,'BDEW-Standard'!$B$3:$M$158,K$9,0),7)","v":{"v":0.1010782,"d":"0.1010782 "}},{"$f":"ROUND(VLOOKUP($E24,'BDEW-Standard'!$B$3:$M$158,L$9,0),1)","v":{"v":40,"d":"40.0"}},{"$f":"ROUND(VLOOKUP($E24,'BDEW-Standard'!$B$3:$M$158,M$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E24,'BDEW-Standard'!$B$3:$M$158,N$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E24,'BDEW-Standard'!$B$3:$M$158,O$9,0),7)","v":0},{"$f":"ROUND(VLOOKUP($E24,'BDEW-Standard'!$B$3:$M$158,P$9,0),7)","v":0},{"v":1.0146273685996503,"d":"1.01463 "},{"$f":"ROUND(VLOOKUP(MID($E24,4,3),'Wochentag F(WT)'!$B$7:$J$22,R$9,0),4)","v":1.0354},{"$f":"ROUND(VLOOKUP(MID($E24,4,3),'Wochentag F(WT)'!$B$7:$J$22,S$9,0),4)","v":1.0523},{"$f":"ROUND(VLOOKUP(MID($E24,4,3),'Wochentag F(WT)'!$B$7:$J$22,T$9,0),4)","v":1.0449},{"$f":"ROUND(VLOOKUP(MID($E24,4,3),'Wochentag F(WT)'!$B$7:$J$22,U$9,0),4)","v":1.0494},{"$f":"ROUND(VLOOKUP(MID($E24,4,3),'Wochentag F(WT)'!$B$7:$J$22,V$9,0),4)","v":0.9885},{"$f":"ROUND(VLOOKUP(MID($E24,4,3),'Wochentag F(WT)'!$B$7:$J$22,W$9,0),4)","v":{"v":0.886,"d":"0.8860"}},{"v":0.9434999999999993,"d":"0.9435"}]
[null,14,"Walldorf"]
[null,15,"Walldorf"]
[null,16,"Walldorf"]
[null,17,"Walldorf"]
[null,18,"Walldorf"]
[null,19,"Walldorf"]
[null,20,"Walldorf"]
[null,21,"Walldorf"]
[null,22,"Walldorf"]
[null,23,"Walldorf"]
[null,24,"Walldorf"]
[null,25,"Walldorf"]
[null,26,"Walldorf"]
[null,27,"Walldorf"]
[null,28,"Walldorf"]
[null,29,"Walldorf"]
[null,30,"Walldorf"]

{"sheet":"SLP-Feiertage","index":6,"n_rows":33,"n_cols":30,"rows_kept":33,"merged":[[7,12,7,29],[9,1,9,2],[9,5,9,11]]}
[]
[null,"Feiertagskalender / Sondertage"]
[]
[null,"Netzbetreiber: ",{"$f":"Netzbetreiber!$D$9","v":"Stadtwerke Walldof GmbH & Co. KG"},{"$nulls":9},"Verwendeter Feiertagskalender bitte markieren (auch Mehrfachnennungen möglich)"]
[null,"Netzgebiet: ",{"$f":"Netzbetreiber!$D$28","v":"Walldorf"},{"$nulls":9},"Hinweis: Entsprechende Feiertage / Ersatztage werden grau-grün markiert"]
[null,"MP-ID: ",{"$f":"Netzbetreiber!$D$11","v":"9870096700000"}]
[null,"gültig ab: ",{"$f":"Netzbetreiber!$D$6","v":"2015-10-01"}]
[{"$nulls":12},"Vorgaben für Feiertagskalender bundesweit / bundeslandspezif / NB-individuell"]
[{"$nulls":12}," DE  "," HB  "," HH  "," SL  "," BE  "," HE  "," NI  "," NW  "," BW  "," RP  "," SH  "," SN  "," BB  "," BY  "," MV  "," ST  "," TH  ","NB"]
[null,"verwendeter Feiertagskalender des Netzgebiets",null,2,{"$f":"IF(ISERROR(HLOOKUP(E$11,$M$9:$AD$33,$D10,0)),\"\",HLOOKUP(E$11,$M$9:$AD$33,$D10,0))","v":""},"Wochentag und entsprechender Ersatztag",{"$nulls":6},"BRD, bundesweit ","Bremen  ","Hamburg  ","Saarland  ","Berlin  ","Hessen  ","Nieder-sachsen  ","Nordrhein-Westfalen  ","Baden-Württemberg  ","Rheinland-Pfalz  ","Schleswig-Holstein  ","Sachsen  ","Brandenburg  ","Bayern  ","Mecklenburg-Vorpommern  ","Sachsen-Anhalt  ","Thüringen  ","NB-individuell"]
[null,"Feiertag / Sondertag ",null,3,null,"Montag","Dienstag","Mittwoch","Donnerstag","Freitag","Samstag","Sonntag",1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Neujahr (1.1.)",null,4,{"$f":"MIN(SUMPRODUCT($M$11:$AD$11,M12:AD12),1)","v":1},"Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Heilige Drei Könige (6.1.)",null,5,{"$f":"MIN(SUMPRODUCT($M$11:$AD$11,M13:AD13),1)","v":0},"Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag",{"$nulls":8},1,{"$nulls":4},1,null,1]
[null,"Rosenmontag (-48 Tage)",null,6,0,"Sonntag","-","-","-","-","-","-"]
[null,"Faschingsdienstag (-47 Tage)",null,7,0,"-","Samstag","-","-","-","-","-"]
[null,"Karfreitag (-2 Tage)",null,8,1,"-","-","-","-","Sonntag","-","-",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Ostersonntag (0. Tag)",null,9,1,"-","-","-","-","-","-","Sonntag",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Ostermontag (+1 Tag)",null,10,1,"Sonntag","-","-","-","-","-","-",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Maifeiertag (1.5.)",null,11,1,"Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Christi Himmelfahrt (+39 Tage)",null,12,1,"-","-","-","Sonntag","-","-","-",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Pfingstsonntag (+49 Tage)",null,13,1,"-","-","-","-","-","-","Sonntag",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Pfingstmontag (+50 Tage)",null,14,1,"Sonntag","-","-","-","-","-","-",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Fronleichnam (+60 Tage)",null,15,0,"-","-","-","Sonntag","-","-","-",{"$nulls":3},1,null,1,null,1,1,1,{"$nulls":3},1]
[null,"Friedensfest (8.8.)",null,16,0,"Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag"]
[null,"Mariä Himmelfahrt (15.8.)",null,17,0,"Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag",{"$nulls":3},1,{"$nulls":9},1]
[null,"Tag der Dt. Einheit (3.10.)",null,18,1,"Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Reformationstag (31.10.)",null,19,0,"Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag",{"$nulls":11},1,1,null,1,1,1]
[null,"Allerheiligen (1.11.)",null,20,0,"Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag",{"$nulls":3},1,{"$nulls":3},1,1,1,{"$nulls":3},1]
[null,"Buß- und Bettag (Mi. v. 23.11.)",null,21,0,"-","-","Sonntag","-","-","-","-",{"$nulls":11},1]
[null,"Heilig Abend (24.12.)",null,22,0,"Samstag","Samstag","Samstag","Samstag","Samstag","Samstag","Sonntag"]
[null,"1. Weihnachtstag (25.12.)",null,23,1,"Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"2. Weihnachtstag (26.12.)",null,24,1,"Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag","Sonntag",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Silvester (31.12.)",null,25,0,"Samstag","Samstag","Samstag","Samstag","Samstag","Samstag","Sonntag"]

{"sheet":"BDEW-Standard","index":7,"n_rows":158,"n_cols":13,"rows_kept":158,"hidden":true}
["Stand: ","2015-06-18",null,"BDEW Standardlastprofile - SLP-Koef. ",null,"hier keine Eintragungen / Veränderungen vornehmen !"]
["Quelle","BDEW Nomenklatur","EDI-CODE","Profilname","A","B","C","D","J0","m_H","b_H","m_W","b_W"]
[{"$f":"IF(MID(D3,1,8)=\"SigLinDe\",\"SLP-FfE\",\"SLP-TUM\")","v":"SLP-TUM"},{"$f":"\"DE_\"&IF(A3=\"SLP-TUM\",MID(D3,5,4)&RIGHT(D3,1),\"\")&IF(A3=\"SLP-FfE\",MID(#REF!,5,3)&\"3\"&RIGHT(#REF!,1),\"\")","v":"DE_HEF03"},{"$f":"IF(A3=\"SLP-TUM\",LEFT(D3,3),\"\")&IF(A3=\"SLP-FfE\",MID(#REF!,2,1)&MID(#REF!,1,1)&MID(#REF!,3,1),\"\")","v":"D13"},"D13/HEF03",3.04696946,{"v":-37.18331413,"d":"-37.18331413 "},{"v":5.672784662,"d":"5.67278466"},0.09619306,{"v":40,"d":"40.0"},0,0,0,0]
[{"$f":"IF(MID(D4,1,8)=\"SigLinDe\",\"SLP-FfE\",\"SLP-TUM\")","v":"SLP-TUM"},{"$f":"\"DE_\"&IF(A4=\"SLP-TUM\",MID(D4,5,4)&RIGHT(D4,1),\"\")&IF(A4=\"SLP-FfE\",MID(D1,5,3)&\"3\"&RIGHT(D1,1),\"\")","v":"DE_HEF04"},{"$f":"IF(A4=\"SLP-TUM\",LEFT(D4,3),\"\")&IF(A4=\"SLP-FfE\",MID(D1,2,1)&MID(D1,1,1)&MID(D1,3,1),\"\")","v":"D14"},"D14/HEF04",3.18501913,{"v":-37.41241549,"d":"-37.41241549 "},{"v":6.172317873,"d":"6.17231787"},{"v":0.076109594,"d":"0.07610959"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_HEF05","D15","D15/HEF05",{"v":3.345666672,"d":"3.34566667"},{"v":-37.52683159,"d":"-37.52683159 "},{"v":6.432893683,"d":"6.43289368"},{"v":0.056256618,"d":"0.05625662"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE",{"$f":"\"DE_\"&IF(A6=\"SLP-TUM\",MID(D6,5,4)&RIGHT(D6,1),\"\")&IF(A6=\"SLP-FfE\",MID(D3,5,3)&\"3\"&RIGHT(D3,1),\"\")","v":"DE_HEF33"},"1D3","SigLinDe FfE/'HEF03'",{"v":1.62095442221218,"d":"1.62095442"},{"v":-37.18331413,"d":"-37.18331413 "},{"v":5.672784662,"d":"5.67278466"},{"v":0.0716431179426293,"d":"0.07164312"},{"v":40,"d":"40.0"},{"v":-0.049570015603148,"d":"- 0.04957002 "},{"v":0.840101458080529,"d":" 0.84010146 "},{"v":-2.20902646706885E-3,"d":"- 0.00220903 "},{"v":0.107446796243988,"d":" 0.10744680 "}]
["SLP-FfE","DE_HEF34","1D4","SigLinDe FfE/'HEF04'",{"v":1.38196630429025,"d":"1.38196630"},{"v":-37.41241549,"d":"-37.41241549 "},{"v":6.172317873,"d":"6.17231787"},{"v":0.039628356395289,"d":"0.03962836"},{"v":40,"d":"40.0"},{"v":-0.0672158729377494,"d":"- 0.06721587 "},{"v":1.11671383851592,"d":" 1.11671384 "},{"v":-0.00199816476877116,"d":"- 0.00199816 "},{"v":0.135506974393588,"d":" 0.13550697 "}]
["SLP-TUM","DE_HMF03","D23","D23/HMF03",{"v":2.387761791,"d":"2.38776179"},{"v":-34.72136051,"d":"-34.72136051 "},{"v":5.816430402,"d":"5.81643040"},{"v":0.120819368,"d":"0.12081937"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_HMF04","D24","D24/HMF04",{"v":2.518777519,"d":"2.51877752"},{"v":-35.03337542,"d":"-35.03337542 "},{"v":6.224063396,"d":"6.22406340"},{"v":0.101078172,"d":"0.10107817"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_HMF05","D25","D25/HMF05",{"v":2.656440592,"d":"2.65644059"},{"v":-35.25169267,"d":"-35.25169267 "},{"v":6.518265862,"d":"6.51826586"},{"v":0.081205866,"d":"0.08120587"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_HMF33","2D3","SigLinDe FfE/'HMF03'",{"v":1.23286546541232,"d":"1.23286547"},{"v":-34.72136051,"d":"-34.72136051 "},{"v":5.816430402,"d":"5.81643040"},{"v":0.0873351930206002,"d":"0.08733519"},{"v":40,"d":"40.0"},{"v":-0.0409283994003907,"d":"- 0.04092840 "},{"v":0.767292039450741,"d":" 0.76729204 "},{"v":-2.23202741619469E-3,"d":"- 0.00223203 "},{"v":0.119920720218609,"d":" 0.11992072 "}]
["SLP-FfE","DE_HMF34","2D4","SigLinDe FfE/'HMF04'",{"v":1.04435376805832,"d":"1.04435377"},{"v":-35.03337542,"d":"-35.03337542 "},{"v":6.224063396,"d":"6.22406340"},{"v":0.0502917160409897,"d":"0.05029172"},{"v":40,"d":"40.0"},{"v":-0.0535830222357689,"d":"- 0.05358302 "},{"v":0.999590090399734,"d":" 0.99959009 "},{"v":-2.17584483209612E-3,"d":"- 0.00217584 "},{"v":0.163329881177145,"d":" 0.16332988 "}]
["SLP-TUM","DE_HKO03","HK3","HK3/HKO03",{"v":0.4040932,"d":"0.40409320"},{"v":-24.4392968,"d":"-24.43929680 "},{"v":6.5718175,"d":"6.57181750"},{"v":0.710771,"d":"0.71077100"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GMK01","MK1","MK1/GMK01",{"v":1.864453364,"d":"1.86445336"},{"v":-30.70716325,"d":"-30.70716325 "},{"v":6.462693731,"d":"6.46269373"},{"v":0.104833866,"d":"0.10483387"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GMK02","MK2","MK2/GMK02",{"v":2.290818386,"d":"2.29081839"},{"v":-33.14768673,"d":"-33.14768673 "},{"v":6.371476504,"d":"6.37147650"},{"v":0.081002321,"d":"0.08100232"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GMK03","MK3","MK3/GMK03",{"v":2.788242394,"d":"2.78824239"},{"v":-34.88061302,"d":"-34.88061302 "},{"v":6.595189922,"d":"6.59518992"},{"v":0.054032911,"d":"0.05403291"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GMK04","MK4","MK4/GMK04",{"v":3.117724811,"d":"3.11772481"},{"v":-35.87150622,"d":"-35.87150622 "},{"v":7.518682887,"d":"7.51868289"},{"v":0.034330093,"d":"0.03433009"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GMK05","MK5","MK5/GMK05",{"v":3.586235525,"d":"3.58623553"},{"v":-37.08029935,"d":"-37.08029935 "},{"v":8.242057176,"d":"8.24205718"},{"v":0.014600757,"d":"0.01460076"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_GMK33","KM3","SigLinDe FfE/'GMK03'",{"v":1.42024191542431,"d":"1.42024192"},{"v":-34.88061302,"d":"-34.88061302 "},{"v":6.595189922,"d":"6.59518992"},{"v":0.038531702714089,"d":"0.03853170"},{"v":40,"d":"40.0"},{"v":-0.0521084240793636,"d":"- 0.05210842 "},{"v":0.864791873696473,"d":" 0.86479187 "},{"v":-1.43692105046127E-3,"d":"- 0.00143692 "},{"v":0.0637601910393071,"d":" 0.06376019 "}]
["SLP-FfE","DE_GMK34","KM4","SigLinDe FfE/'GMK04'",{"v":1.32849128341426,"d":"1.32849128"},{"v":-35.87150622,"d":"-35.87150622 "},{"v":7.518682887,"d":"7.51868289"},{"v":0.0175540429283774,"d":"0.01755404"},{"v":40,"d":"40.0"},{"v":-0.0758982787384199,"d":"- 0.07589828 "},{"v":1.19425549859791,"d":" 1.19425550 "},{"v":-8.9798095264275E-4,"d":"- 0.00089798 "},{"v":0.0603337307284458,"d":" 0.06033373 "}]
["SLP-TUM","DE_GHA01","HA1","HA1/GHA01",{"v":2.374282771,"d":"2.37428277"},{"v":-34.75955014,"d":"-34.75955014 "},{"v":5.998703683,"d":"5.99870368"},{"v":0.149441144,"d":"0.14944114"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GHA02","HA2","HA2/GHA02",{"v":2.854474853,"d":"2.85447485"},{"v":-35.62942308,"d":"-35.62942308 "},{"v":7.005826443,"d":"7.00582644"},{"v":0.116477221,"d":"0.11647722"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GHA03","HA3","HA3/GHA03",3.58112137,{"v":-36.96500652,"d":"-36.96500652 "},{"v":7.225694671,"d":"7.22569467"},{"v":0.044841567,"d":"0.04484157"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GHA04","HA4","HA4/GHA04",{"v":4.019690204,"d":"4.01969020"},{"v":-37.82820366,"d":"-37.82820366 "},{"v":8.159336876,"d":"8.15933688"},{"v":0.047284495,"d":"0.04728450"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GHA05","HA5","HA5/GHA05",{"v":4.825237566,"d":"4.82523757"},{"v":-39.2802564,"d":"-39.28025640 "},{"v":8.624021689,"d":"8.62402169"},{"v":0.009994463,"d":"0.00999446"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_GHA33","AH3","SigLinDe FfE/'GHA03'",{"v":1.97247753750471,"d":"1.97247754"},{"v":-36.96500652,"d":"-36.96500652 "},{"v":7.225694671,"d":"7.22569467"},{"v":0.0345781570412447,"d":"0.03457816"},{"v":40,"d":"40.0"},{"v":-0.0742174022298938,"d":"- 0.07421740 "},{"v":1.04488686764057,"d":" 1.04488687 "},{"v":-0.000829544720239446,"d":"- 0.00082954 "},{"v":0.0461794912976014,"d":" 0.04617949 "}]
["SLP-FfE","DE_GHA34","AH4","SigLinDe FfE/'GHA04'",{"v":1.83984551795092,"d":"1.83984552"},{"v":-37.82820366,"d":"-37.82820366 "},{"v":8.159336876,"d":"8.15933688"},{"v":0.0259710062554828,"d":"0.02597101"},{"v":40,"d":"40.0"},{"v":-0.106926174596805,"d":"- 0.10692617 "},{"v":1.45522403984838,"d":" 1.45522404 "},{"v":-0.000491972635279072,"d":"- 0.00049197 "},{"v":0.0691851477646249,"d":" 0.06918515 "}]
["SLP-TUM","DE_GKO01","KO1","KO1/GKO01",{"v":1.415957087,"d":"1.41595709"},{"v":-30.84251916,"d":"-30.84251916 "},{"v":6.346755701,"d":"6.34675570"},{"v":0.321179065,"d":"0.32117907"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GKO02","KO2","KO2/GKO02",2.06605007,{"v":-33.60165203,"d":"-33.60165203 "},{"v":6.675360994,"d":"6.67536099"},{"v":0.230912468,"d":"0.23091247"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GKO03","KO3","KO3/GKO03",{"v":2.717228844,"d":"2.71722884"},{"v":-35.14125631,"d":"-35.14125631 "},{"v":7.130339509,"d":"7.13033951"},0.14184717,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GKO04","KO4","KO4/GKO04",{"v":3.442894287,"d":"3.44289429"},{"v":-36.65905041,"d":"-36.65905041 "},{"v":7.608322616,"d":"7.60832262"},0.07468501,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GKO05","KO5","KO5/GKO05",{"v":4.3624833,"d":"4.36248330"},{"v":-38.66340216,"d":"-38.66340216 "},{"v":7.597464428,"d":"7.59746443"},{"v":0.008326418,"d":"0.00832642"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_GKO33","OK3","SigLinDe FfE/'GKO03'",{"v":1.35545152289308,"d":"1.35545152"},{"v":-35.14125631,"d":"-35.14125631 "},{"v":7.130339509,"d":"7.13033951"},{"v":0.0990618615825365,"d":"0.09906186"},{"v":40,"d":"40.0"},{"v":-0.0526486914295292,"d":"- 0.05264869 "},{"v":0.862608575142234,"d":" 0.86260858 "},{"v":-0.000880838956026602,"d":"- 0.00088084 "},{"v":0.0964014193937084,"d":" 0.09640142 "}]
["SLP-FfE","DE_GKO34","OK4","SigLinDe FfE/'GKO04'",{"v":1.4256683872018,"d":"1.42566839"},{"v":-36.65905041,"d":"-36.65905041 "},{"v":7.608322616,"d":"7.60832262"},{"v":0.0371115865474787,"d":"0.03711159"},{"v":40,"d":"40.0"},{"v":-0.0809358930224151,"d":"- 0.08093589 "},{"v":1.23645270182598,"d":" 1.23645270 "},{"v":-0.000762799666428523,"d":"- 0.00076280 "},{"v":0.100297906459644,"d":" 0.10029791 "}]
["SLP-TUM","DE_GBD01","BD1","BD1/GBD01",{"v":1.290350459,"d":"1.29035046"},{"v":-35.23498683,"d":"-35.23498683 "},{"v":2.106424688,"d":"2.10642469"},{"v":0.455725333,"d":"0.45572533"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBD02","BD2","BD2/GBD02",{"v":2.109587843,"d":"2.10958784"},{"v":-35.84445084,"d":"-35.84445084 "},{"v":5.215467228,"d":"5.21546723"},{"v":0.285458254,"d":"0.28545825"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBD03","BD3","BD3/GBD03",{"v":2.917702722,"d":"2.91770272"},{"v":-36.17941165,"d":"-36.17941165 "},{"v":5.926516165,"d":"5.92651617"},{"v":0.115191176,"d":"0.11519118"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBD04","BD4","BD4/GBD04",{"v":3.75,"d":"3.75000000"},{"v":-37.5,"d":"-37.50000000 "},{"v":6.8,"d":"6.80000000"},{"v":0.060911265,"d":"0.06091127"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBD05","BD5","BD5/GBD05",{"v":4.569950565,"d":"4.56995057"},{"v":-38.53533924,"d":"-38.53533924 "},{"v":7.597699099,"d":"7.59769910"},{"v":0.006631354,"d":"0.00663135"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_GBD33","DB3","SigLinDe FfE/'GBD03'",{"v":1.4633681573375,"d":"1.46336816"},{"v":-36.17941165,"d":"-36.17941165 "},{"v":5.926516165,"d":"5.92651617"},{"v":0.0808834761578303,"d":"0.08088348"},{"v":40,"d":"40.0"},{"v":-0.047579990370696,"d":"- 0.04757999 "},{"v":0.82307541850402,"d":" 0.82307542 "},{"v":-1.92725690584626E-3,"d":"- 0.00192726 "},{"v":0.107704598925155,"d":" 0.10770460 "}]
["SLP-FfE","DE_GBD34","DB4","SigLinDe FfE/'GBD04'",{"v":1.51757916044091,"d":"1.51757916"},{"v":-37.5,"d":"-37.50000000 "},{"v":6.8,"d":"6.80000000"},{"v":0.0295800532480301,"d":"0.02958005"},{"v":40,"d":"40.0"},{"v":-0.0788559183995737,"d":"- 0.07885592 "},{"v":1.21612498767079,"d":" 1.21612499 "},{"v":-1.31336800852578E-3,"d":"- 0.00131337 "},{"v":0.096872112636313,"d":" 0.09687211 "}]
["SLP-TUM","DE_GGA01","GA1","GA1/GGA01",{"v":1.177034538,"d":"1.17703454"},{"v":-39.1599914,"d":"-39.15999140 "},{"v":4.207610964,"d":"4.20761096"},{"v":0.660473932,"d":"0.66047393"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GGA02","GA2","GA2/GGA02",{"v":1.648762294,"d":"1.64876229"},{"v":-36.39927357,"d":"-36.39927357 "},{"v":6.214917209,"d":"6.21491721"},{"v":0.487763733,"d":"0.48776373"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GGA03","GA3","GA3/GGA03",{"v":2.285016474,"d":"2.28501647"},{"v":-36.28785839,"d":"-36.28785839 "},{"v":6.588512639,"d":"6.58851264"},{"v":0.315053534,"d":"0.31505353"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GGA04","GA4","GA4/GGA04",{"v":2.819565615,"d":"2.81956562"},{"v":-36,"d":"-36.00000000 "},{"v":7.736851768,"d":"7.73685177"},0.15728098,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GGA05","GA5","GA5/GGA05",{"v":3.329557482,"d":"3.32955748"},{"v":-36.01462112,"d":"-36.01462112 "},{"v":8.776746471,"d":"8.77674647"},{"v":0,"d":"0.00000000"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_GGA33","AG3","SigLinDe FfE/'GGA03'",{"v":1.15820816823062,"d":"1.15820817"},{"v":-36.28785839,"d":"-36.28785839 "},{"v":6.588512639,"d":"6.58851264"},{"v":0.223568019279065,"d":"0.22356802"},{"v":40,"d":"40.0"},{"v":-0.0410334784248699,"d":"- 0.04103348 "},{"v":0.752645138542657,"d":" 0.75264514 "},{"v":-0.000908768552979623,"d":"- 0.00090877 "},{"v":0.191664070308203,"d":" 0.19166407 "}]
["SLP-FfE","DE_GGA34","AG4","SigLinDe FfE/'GGA04'",{"v":1.18483197659357,"d":"1.18483198"},{"v":-36,"d":"-36.00000000 "},{"v":7.736851768,"d":"7.73685177"},{"v":0.0793107420898834,"d":"0.07931074"},{"v":40,"d":"40.0"},{"v":-0.068738315813288,"d":"- 0.06873832 "},{"v":1.13085700508515,"d":" 1.13085701 "},{"v":-6.58695704968982E-4,"d":"- 0.00065870 "},{"v":0.191030103862021,"d":" 0.19103010 "}]
["SLP-TUM","DE_GBH01","BH1","BH1/GBH01",{"v":1.477178569,"d":"1.47717857"},{"v":-35.08344471,"d":"-35.08344471 "},{"v":5.412342465,"d":"5.41234247"},{"v":0.474426408,"d":"0.47442641"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBH02","BH2","BH2/GBH02",1.70052794,{"v":-35.15,"d":"-35.15000000 "},{"v":6.163273851,"d":"6.16327385"},{"v":0.429826085,"d":"0.42982609"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBH03","BH3","BH3/GBH03",{"v":2.010247173,"d":"2.01024717"},{"v":-35.25321235,"d":"-35.25321235 "},{"v":6.154440641,"d":"6.15444064"},{"v":0.329474097,"d":"0.32947410"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBH04","BH4","BH4/GBH04",{"v":2.459518061,"d":"2.45951806"},{"v":-35.25321235,"d":"-35.25321235 "},{"v":6.058700072,"d":"6.05870007"},{"v":0.164737049,"d":"0.16473705"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBH05","BH5","BH5/GBH05",{"v":2.98,"d":"2.98000000"},{"v":-35.8,"d":"-35.80000000 "},{"v":5.634058062,"d":"5.63405806"},{"v":0,"d":"0.00000000"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_GBH33","HB3","SigLinDe FfE/'GBH03'",{"v":0.987428301992787,"d":"0.98742830"},{"v":-35.25321235,"d":"-35.25321235 "},{"v":6.154440641,"d":"6.15444064"},{"v":0.226571574644788,"d":"0.22657157"},{"v":40,"d":"40.0"},{"v":-0.0339019728779373,"d":"- 0.03390197 "},{"v":0.693823369584483,"d":" 0.69382337 "},{"v":-0.00128490078017325,"d":"- 0.00128490 "},{"v":0.202973165694549,"d":" 0.20297317 "}]
["SLP-FfE","DE_GBH34","HB4","SigLinDe FfE/'GBH04'",{"v":0.987258471486126,"d":"0.98725847"},{"v":-35.25321235,"d":"-35.25321235 "},{"v":6.058700072,"d":"6.05870007"},{"v":0.0793511784792907,"d":"0.07935118"},{"v":40,"d":"40.0"},{"v":-0.0495013227495672,"d":"- 0.04950132 "},{"v":0.963799861253224,"d":" 0.96379986 "},{"v":-0.00223037852710912,"d":"- 0.00223038 "},{"v":0.22883982780254,"d":" 0.22883983 "}]
["SLP-TUM","DE_GWA01","WA1","WA1/GWA01",{"v":0.4,"d":"0.40000000"},{"v":-40.51494818,"d":"-40.51494818 "},{"v":2.874795695,"d":"2.87479570"},{"v":0.935107584,"d":"0.93510758"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GWA02","WA2","WA2/GWA02",{"v":0.616622893,"d":"0.61662289"},{"v":-38.4,"d":"-38.40000000 "},{"v":3.870535189,"d":"3.87053519"},{"v":0.870025031,"d":"0.87002503"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GWA03","WA3","WA3/GWA03",{"v":0.765729012,"d":"0.76572901"},{"v":-36.02379115,"d":"-36.02379115 "},{"v":4.866274683,"d":"4.86627468"},{"v":0.804942478,"d":"0.80494248"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GWA04","WA4","WA4/GWA04",{"v":1.053587472,"d":"1.05358747"},{"v":-35.3,"d":"-35.30000000 "},{"v":4.866274683,"d":"4.86627468"},{"v":0.681104234,"d":"0.68110423"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GWA05","WA5","WA5/GWA05",{"v":1.276885373,"d":"1.27688537"},{"v":-34.34243707,"d":"-34.34243707 "},{"v":5.451882242,"d":"5.45188224"},0.55726599,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_GWA33","AW3","SigLinDe FfE/'GWA03'",{"v":0.333783832123808,"d":"0.33378383"},{"v":-36.02379115,"d":"-36.02379115 "},{"v":4.866274683,"d":"4.86627468"},{"v":0.491227957971774,"d":"0.49122796"},{"v":40,"d":"40.0"},{"v":-0.0092263492839078,"d":"- 0.00922635 "},{"v":0.45957571089625,"d":" 0.45957571 "},{"v":-0.000967642449895133,"d":"- 0.00096764 "},{"v":0.396429075178636,"d":" 0.39642908 "}]
["SLP-FfE","DE_GWA34","AW4","SigLinDe FfE/'GWA04'",{"v":0.392533873806349,"d":"0.39253387"},{"v":-35.3,"d":"-35.30000000 "},{"v":4.866274683,"d":"4.86627468"},{"v":0.304509866196958,"d":"0.30450987"},{"v":40,"d":"40.0"},{"v":-0.0167993072626435,"d":"- 0.01679931 "},{"v":0.671088891734221,"d":" 0.67108889 "},{"v":-0.00203008235945165,"d":"- 0.00203008 "},{"v":0.561462342896087,"d":" 0.56146234 "}]
["SLP-TUM","DE_GGB01","GB1","GB1/GGB01",{"v":3.176194476,"d":"3.17619448"},{"v":-40.83666086,"d":"-40.83666086 "},{"v":3.678589174,"d":"3.67858917"},{"v":0.150215576,"d":"0.15021558"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GGB02","GB2","GB2/GGB02",{"v":3.390464506,"d":"3.39046451"},{"v":-39.28752164,"d":"-39.28752164 "},{"v":4.490574046,"d":"4.49057405"},{"v":0.083478317,"d":"0.08347832"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GGB03","GB3","GB3/GGB03",{"v":3.257274213,"d":"3.25727421"},{"v":-37.5,"d":"-37.50000000 "},{"v":6.346214795,"d":"6.34621480"},0.08662265,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GGB04","GB4","GB4/GGB04",{"v":3.601773562,"d":"3.60177356"},{"v":-37.88253684,"d":"-37.88253684 "},{"v":6.983607029,"d":"6.98360703"},{"v":0.054826186,"d":"0.05482619"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GGB05","GB5","GB5/GGB05",{"v":3.932053248,"d":"3.93205325"},{"v":-38.14332482,"d":"-38.14332482 "},{"v":7.618587098,"d":"7.61858710"},{"v":0.023029723,"d":"0.02302972"},{"v":40,"d":"40.0"},0,0,0,0]
[{"$f":"IF(MID(D68,1,8)=\"SigLinDe\",\"SLP-FfE\",\"SLP-TUM\")","v":"SLP-FfE"},{"$f":"\"DE_\"&IF(A68=\"SLP-TUM\",MID(D68,5,4)&RIGHT(D68,1),\"\")&IF(A68=\"SLP-FfE\",MID(D65,5,3)&\"3\"&RIGHT(D65,1),\"\")","v":"DE_GGB33"},{"$f":"IF(A68=\"SLP-TUM\",LEFT(D68,3),\"\")&IF(A68=\"SLP-FfE\",MID(D65,2,1)&MID(D65,1,1)&MID(D65,3,1),\"\")","v":"BG3"},"SigLinDe FfE/'GGB03'",{"v":1.82137779524266,"d":"1.82137780"},{"v":-37.5,"d":"-37.50000000 "},{"v":6.346214795,"d":"6.34621480"},{"v":0.0678117914984112,"d":"0.06781179"},{"v":40,"d":"40.0"},{"v":-0.0607665689685263,"d":"- 0.06076657 "},{"v":0.930815856582958,"d":" 0.93081586 "},{"v":-0.00139668882761774,"d":"- 0.00139669 "},{"v":0.0850398799492811,"d":" 0.08503988 "}]
["SLP-FfE","DE_GGB34","BG4","SigLinDe FfE/'GGB04'",{"v":1.62668116109167,"d":"1.62668116"},{"v":-37.88253684,"d":"-37.88253684 "},{"v":6.983607029,"d":"6.98360703"},{"v":0.0297136027122766,"d":"0.02971360"},{"v":40,"d":"40.0"},{"v":-0.0854332892007443,"d":"- 0.08543329 "},{"v":1.2709629183123,"d":" 1.27096292 "},{"v":-0.00113191923363135,"d":"- 0.00113192 "},{"v":0.0928123931807869,"d":" 0.09281239 "}]
["SLP-TUM","DE_GBA01","BA1","BA1/GBA01",{"v":0.15,"d":"0.15000000"},{"v":-36,"d":"-36.00000000 "},{"v":2,"d":"2.00000000"},{"v":1,"d":"1.00000000"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBA02","BA2","BA2/GBA02",{"v":0.387919104,"d":"0.38791910"},{"v":-35.5,"d":"-35.50000000 "},{"v":4,"d":"4.00000000"},{"v":0.905481543,"d":"0.90548154"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBA03","BA3","BA3/GBA03",{"v":0.626196216,"d":"0.62619622"},{"v":-33,"d":"-33.00000000 "},5.72123025,0.78556546,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBA04","BA4","BA4/GBA04",{"v":0.931588901,"d":"0.93158890"},{"v":-33.35,"d":"-33.35000000 "},5.72123025,{"v":0.665649377,"d":"0.66564938"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GBA05","BA5","BA5/GBA05",1.27795673,{"v":-34.517392,"d":"-34.51739200 "},5.72123025,{"v":0.545733294,"d":"0.54573329"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_GBA33","AB3","SigLinDe FfE/'GBA03'",{"v":0.277008711731108,"d":"0.27700871"},{"v":-33,"d":"-33.00000000 "},5.72123025,{"v":0.4865118291885,"d":"0.48651183"},{"v":40,"d":"40.0"},{"v":-0.00948491309440127,"d":"- 0.00948491 "},{"v":0.463023693687715,"d":" 0.46302369 "},{"v":-0.000713418600565782,"d":"- 0.00071342 "},{"v":0.386744669887959,"d":" 0.38674467 "}]
["SLP-FfE","DE_GBA34","AB4","SigLinDe FfE/'GBA04'",{"v":0.353764015077942,"d":"0.35376402"},{"v":-33.35,"d":"-33.35000000 "},5.72123025,{"v":0.30333053043746,"d":"0.30333053"},{"v":40,"d":"40.0"},{"v":-0.0177463478688756,"d":"- 0.01774635 "},{"v":0.682569912168636,"d":" 0.68256991 "},{"v":-0.00139117928414567,"d":"- 0.00139118 "},{"v":0.543462385684501,"d":" 0.54346239 "}]
["SLP-TUM","DE_GPD01","PD1","PD1/GPD01",{"v":1.489402246,"d":"1.48940225"},{"v":-32.42526775,"d":"-32.42526775 "},{"v":8.173261208,"d":"8.17326121"},{"v":0.390598736,"d":"0.39059874"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GPD02","PD2","PD2/GPD02",{"v":2.578417254,"d":"2.57841725"},{"v":-34.7321261,"d":"-34.73212610 "},{"v":6.480503514,"d":"6.48050351"},{"v":0.140772912,"d":"0.14077291"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GPD03","PD3","PD3/GPD03",{"v":3.2,"d":"3.20000000"},{"v":-35.8,"d":"-35.80000000 "},{"v":8.4,"d":"8.40000000"},{"v":0.093848608,"d":"0.09384861"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GPD04","PD4","PD4/GPD04",{"v":3.85,"d":"3.85000000"},{"v":-37,"d":"-37.00000000 "},{"v":10.2405021,"d":"10.24050210"},{"v":0.046924304,"d":"0.04692430"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GPD05","PD5","PD5/GPD05",{"v":4.746281392,"d":"4.74628139"},{"v":-38.75042939,"d":"-38.75042939 "},10.27533341,{"v":0,"d":"0.00000000"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_GPD33","DP3","SigLinDe FfE/'GPD03'",{"v":1.71107392562331,"d":"1.71107393"},{"v":-35.8,"d":"-35.80000000 "},{"v":8.4,"d":"8.40000000"},{"v":0.0702545839208687,"d":"0.07025458"},{"v":40,"d":"40.0"},{"v":-0.0745381134111297,"d":"- 0.07453811 "},{"v":1.04630053886108,"d":" 1.04630054 "},{"v":-0.000367207932817838,"d":"- 0.00036721 "},{"v":0.0621882262236128,"d":" 0.06218823 "}]
["SLP-FfE","DE_GPD34","DP4","SigLinDe FfE/'GPD04'",{"v":1.88346094379506,"d":"1.88346094"},{"v":-37,"d":"-37.00000000 "},{"v":10.2405021,"d":"10.24050210"},{"v":0.0275470422541609,"d":"0.02754704"},{"v":40,"d":"40.0"},{"v":-0.125309974791607,"d":"- 0.12530997 "},{"v":1.62759988176077,"d":" 1.62759988 "},{"v":-1.10508201486912E-4,"d":"- 0.00011051 "},{"v":0.0635119413506926,"d":" 0.06351194 "}]
["SLP-TUM","DE_GMF01","MF1","MF1/GMF01",{"v":2.116353087,"d":"2.11635309"},{"v":-34.26286231,"d":"-34.26286231 "},{"v":5.176387424,"d":"5.17638742"},{"v":0.160694541,"d":"0.16069454"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GMF02","MF2","MF2/GMF02",{"v":2.248633329,"d":"2.24863333"},{"v":-34.54284307,"d":"-34.54284307 "},{"v":5.554524484,"d":"5.55452448"},{"v":0.140821963,"d":"0.14082196"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GMF03","MF3","MF3/GMF03",{"v":2.387761791,"d":"2.38776179"},{"v":-34.72136051,"d":"-34.72136051 "},{"v":5.816430402,"d":"5.81643040"},{"v":0.120819368,"d":"0.12081937"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GMF04","MF4","MF4/GMF04",{"v":2.518777519,"d":"2.51877752"},{"v":-35.03337542,"d":"-35.03337542 "},{"v":6.224063396,"d":"6.22406340"},{"v":0.101078172,"d":"0.10107817"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GMF05","MF5","MF5/GMF05",{"v":2.656440592,"d":"2.65644059"},{"v":-35.25169267,"d":"-35.25169267 "},{"v":6.518265862,"d":"6.51826586"},{"v":0.081205866,"d":"0.08120587"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-FfE","DE_GMF33","FM3","SigLinDe FfE/'GMF03'",{"v":1.23286546541232,"d":"1.23286547"},{"v":-34.72136051,"d":"-34.72136051 "},{"v":5.816430402,"d":"5.81643040"},{"v":0.0873351930206002,"d":"0.08733519"},{"v":40,"d":"40.0"},{"v":-0.0409283994003907,"d":"- 0.04092840 "},{"v":0.767292039450741,"d":" 0.76729204 "},{"v":-2.23202741619469E-3,"d":"- 0.00223203 "},{"v":0.119920720218609,"d":" 0.11992072 "}]
["SLP-FfE","DE_GMF34","FM4","SigLinDe FfE/'GMF04'",{"v":1.04435376805832,"d":"1.04435377"},{"v":-35.03337542,"d":"-35.03337542 "},{"v":6.224063396,"d":"6.22406340"},{"v":0.0502917160409897,"d":"0.05029172"},{"v":40,"d":"40.0"},{"v":-0.0535830222357689,"d":"- 0.05358302 "},{"v":0.999590090399734,"d":" 0.99959009 "},{"v":-2.17584483209612E-3,"d":"- 0.00217584 "},{"v":0.163329881177145,"d":" 0.16332988 "}]
["SLP-TUM","DE_GHD03","HD3","HD3/GHD03",{"v":2.579251014,"d":"2.57925101"},{"v":-35.6816144,"d":"-35.68161440 "},{"v":6.685797612,"d":"6.68579761"},{"v":0.199554099,"d":"0.19955410"},{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","DE_GHD04","HD4","HD4/GHD04",{"v":3.008434556,"d":"3.00843456"},{"v":-36.60784527,"d":"-36.60784527 "},{"v":7.321186953,"d":"7.32118695"},{"v":0.154966031,"d":"0.15496603"},{"v":40,"d":"40.0"},0,0,0,0]
[{"$f":"IF(MID(D93,1,8)=\"SigLinDe\",\"SLP-FfE\",\"SLP-TUM\")","v":"SLP-FfE"},{"$f":"\"DE_\"&IF(A93=\"SLP-TUM\",MID(D93,5,4)&RIGHT(D93,1),\"\")&IF(A93=\"SLP-FfE\",MID(D91,5,3)&\"3\"&RIGHT(D91,1),\"\")","v":"DE_GHD33"},{"$f":"IF(A93=\"SLP-TUM\",LEFT(D93,3),\"\")&IF(A93=\"SLP-FfE\",MID(D91,2,1)&MID(D91,1,1)&MID(D91,3,1),\"\")","v":"DH3"},"SigLinDe FfE/'GHD03'",{"v":1.30106232806706,"d":"1.30106233"},{"v":-35.6816144,"d":"-35.68161440 "},{"v":6.685797612,"d":"6.68579761"},{"v":0.140926667042252,"d":"0.14092667"},{"v":40,"d":"40.0"},{"v":-0.04734280882463,"d":"- 0.04734281 "},{"v":0.814169125333265,"d":" 0.81416913 "},{"v":-0.0010600643623826,"d":"- 0.00106006 "},{"v":0.132509207320192,"d":" 0.13250921 "}]
["SLP-FfE",{"$f":"\"DE_\"&IF(A94=\"SLP-TUM\",MID(D94,5,4)&RIGHT(D94,1),\"\")&IF(A94=\"SLP-FfE\",MID(D92,5,3)&\"3\"&RIGHT(D92,1),\"\")","v":"DE_GHD34"},{"$f":"IF(A94=\"SLP-TUM\",LEFT(D94,3),\"\")&IF(A94=\"SLP-FfE\",MID(D92,2,1)&MID(D92,1,1)&MID(D92,3,1),\"\")","v":"DH4"},"SigLinDe FfE/'GHD04'",{"v":1.25696003661151,"d":"1.25696004"},{"v":-36.60784527,"d":"-36.60784527 "},{"v":7.321186953,"d":"7.32118695"},{"v":0.07769599944695,"d":"0.07769600"},{"v":40,"d":"40.0"},{"v":-0.0696825980683407,"d":"- 0.06968260 "},{"v":1.13797018307135,"d":" 1.13797018 "},{"v":-0.000852200219017975,"d":"- 0.00085220 "},{"v":0.192106757522949,"d":" 0.19210676 "}]
["SLP-TUM","BB_HEF03","R13","Bundeslandprofil",3.0217398598,-37.1823599508,5.6477169551,0.1152387563712,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BB_HEF04","R14","Bundeslandprofil",3.159294041,-37.4068859976,6.1418925605,0.09226611062899999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BB_HMF03","R23","Bundeslandprofil",2.3548082787,-34.7150298504,5.8675639272,0.15092742664779998,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BB_HMF04","R24","Bundeslandprofil",2.4859160576,-35.0435977727,6.2818214214,0.12839042175739998,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BE_HEF03","B13","Bundeslandprofil",3.0553842454,-37.1836374223,5.6810824599,0.10016998486249999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BE_HEF04","B14","Bundeslandprofil",3.193597811,-37.4142478269,6.1824021474,0.0789212713625,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BE_HMF03","B23","Bundeslandprofil",2.3987552319,-34.7234877745,5.799644639,0.12390732033749999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BE_HMF04","B24","Bundeslandprofil",2.5297380185,-35.0300145098,6.2051108885,0.10300644025,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BW_HEF03","W13","Bundeslandprofil",3.0385546749,-37.1829908408,5.664486865,0.0955844507254,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BW_HEF04","W14","Bundeslandprofil",3.1764404494,-37.4105831517,6.1622335977,0.0759377203658,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BW_HMF03","W23","Bundeslandprofil",2.3767683504,-34.7192332513,5.833216164,0.12181819977010001,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BW_HMF04","W24","Bundeslandprofil",2.5078170188,-35.0367363344,6.2430159033,0.1025195150444,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BY_HEF03","G13","Bundeslandprofil",3.0217398598,-37.1823599508,5.6477169551,0.095626240752,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BY_HEF04","G14","Bundeslandprofil",3.159294041,-37.4068859976,6.1418925605,0.0765633159025,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BY_HMF03","G23","Bundeslandprofil",2.3548082787,-34.7150298504,5.8675639272,0.1252410464255,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","BY_HMF04","G24","Bundeslandprofil",2.4859160576,-35.0435977727,6.2818214214,0.1065396205915,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HB_HEF03","M13","Bundeslandprofil",3.0890720564,-37.184949682,5.713795913,0.0815255446296,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HB_HEF04","M14","Bundeslandprofil",3.2279445929,-37.4214799891,6.2222288165,0.0630443400096,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HB_HMF03","M23","Bundeslandprofil",2.4428072126,-34.7321437565,5.7347347252,0.0940970067267,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HB_HMF04","M24","Bundeslandprofil",2.5736652122,-35.0169441759,6.1318139781,0.0758603548598,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HE_HEF03","F13","Bundeslandprofil",3.0553842454,-37.1836374223,5.6810824599,0.09501838564099999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HE_HEF04","F14","Bundeslandprofil",3.193597811,-37.4142478269,6.1824021474,0.07486246312099999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HE_HMF03","F23","Bundeslandprofil",2.3987552319,-34.7234877745,5.799644639,0.117534943863,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HE_HMF04","F24","Bundeslandprofil",2.5297380185,-35.0300145098,6.2051108885,0.09770896618,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HH_HEF03","H13","Bundeslandprofil",3.0722214502,-37.184284426,5.6975233566,0.0904188489264,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HH_HEF04","H14","Bundeslandprofil",3.2107659244,-37.4178800803,6.2023999708,0.0706017007536,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HH_HMF03","H23","Bundeslandprofil",2.4207683708,-34.7277917251,5.7668252225,0.1082275311744,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","HH_HMF04","H24","Bundeslandprofil",2.5516882275,-35.0234219419,6.1680699421,0.0887057624352,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","MV_HEF03","V13","Bundeslandprofil",3.0217398598,-37.1823599508,5.6477169551,0.115116939504,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","MV_HEF04","V14","Bundeslandprofil",3.159294041,-37.4068859976,6.1418925605,0.0921685777425,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","MV_HMF03","V23","Bundeslandprofil",2.3548082787,-34.7150298504,5.8675639272,0.1507678839135,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","MV_HMF04","V24","Bundeslandprofil",2.4859160576,-35.0435977727,6.2818214214,0.1282547024955,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","NI_HEF03","I13","Bundeslandprofil",3.0553842454,-37.1836374223,5.6810824599,0.1029175044473,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","NI_HEF04","I14","Bundeslandprofil",3.193597811,-37.4142478269,6.1824021474,0.0810859690913,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","NI_HMF03","I23","Bundeslandprofil",2.3987552319,-34.7234877745,5.799644639,0.1273059211239,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","NI_HMF04","I24","Bundeslandprofil",2.5297380185,-35.0300145098,6.2051108885,0.105831759754,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","NW_HEF03","N13","Bundeslandprofil",3.0553842454,-37.1836374223,5.6810824599,0.0821966275786,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","NW_HEF04","N14","Bundeslandprofil",3.193597811,-37.4142478269,6.1824021474,0.0647605403866,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","NW_HMF03","N23","Bundeslandprofil",2.3987552319,-34.7234877745,5.799644639,0.10167480685979999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","NW_HMF04","N24","Bundeslandprofil",2.5297380185,-35.0300145098,6.2051108885,0.084524141828,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","RP_HEF03","P13","Bundeslandprofil",3.0385546749,-37.1829908408,5.664486865,0.093339574874,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","RP_HEF04","P14","Bundeslandprofil",3.1764404494,-37.4105831517,6.1622335977,0.074154263398,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","RP_HMF03","P23","Bundeslandprofil",2.3767683504,-34.7192332513,5.833216164,0.11895720373100001,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","RP_HMF04","P24","Bundeslandprofil",2.5078170188,-35.0367363344,6.2430159033,0.100111763764,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SH_HEF03","L13","Bundeslandprofil",3.0385546749,-37.1829908408,5.664486865,0.1064543759006,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SH_HEF04","L14","Bundeslandprofil",3.1764404494,-37.4105831517,6.1622335977,0.0845734067362,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SH_HMF03","L23","Bundeslandprofil",2.3767683504,-34.7192332513,5.833216164,0.1356714437489,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SH_HMF04","L24","Bundeslandprofil",2.5078170188,-35.0367363344,6.2430159033,0.11417810019159999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SL_HEF03","A13","Bundeslandprofil",3.0722214502,-37.184284426,5.6975233566,0.09352145648759999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SL_HEF04","A14","Bundeslandprofil",3.2107659244,-37.4178800803,6.2023999708,0.0730243081324,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SL_HMF03","A23","Bundeslandprofil",2.4207683708,-34.7277917251,5.7668252225,0.1119412209696,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SL_HMF04","A24","Bundeslandprofil",2.5516882275,-35.0234219419,6.1680699421,0.0917495876168,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SN_HEF03","S13","Bundeslandprofil",3.0385546749,-37.1829908408,5.664486865,0.1124800952912,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SN_HEF04","S14","Bundeslandprofil",3.1764404494,-37.4105831517,6.1622335977,0.0893605807024,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SN_HMF03","S23","Bundeslandprofil",2.3767683504,-34.7192332513,5.833216164,0.1433509594328,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","SN_HMF04","S24","Bundeslandprofil",2.5078170188,-35.0367363344,6.2430159033,0.12064101152319999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","ST_HEF03","C13","Bundeslandprofil",3.0217398598,-37.1823599508,5.6477169551,0.11828417805119999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","ST_HEF04","C14","Bundeslandprofil",3.159294041,-37.4068859976,6.1418925605,0.0947044327915,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","ST_HMF03","C23","Bundeslandprofil",2.3548082787,-34.7150298504,5.8675639272,0.15491599500529998,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","ST_HMF04","C24","Bundeslandprofil",2.4859160576,-35.0435977727,6.2818214214,0.1317834033049,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","TH_HEF03","T13","Bundeslandprofil",3.0217398598,-37.1823599508,5.6477169551,0.11706600937919999,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","TH_HEF04","T14","Bundeslandprofil",3.159294041,-37.4068859976,6.1418925605,0.0937291039265,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","TH_HMF03","T23","Bundeslandprofil",2.3548082787,-34.7150298504,5.8675639272,0.15332056766229998,{"v":40,"d":"40.0"},0,0,0,0]
["SLP-TUM","TH_HMF04","T24","Bundeslandprofil",2.4859160576,-35.0435977727,6.2818214214,0.1304262106859,{"v":40,"d":"40.0"},0,0,0,0]

{"sheet":"Wochentag F(WT)","index":8,"n_rows":22,"n_cols":16,"rows_kept":22,"hidden":true,"merged":[[2,0,3,0],[2,3,2,9]]}
["BDEW Standardlastprofile - WT-Koef. ",null,null,"hier keine Eintragungen / Veränderungen vornehmen !"]
[null,"Wochentagfaktoren gemäß TUM"]
["#","  Bezeichnung",null,"Wochentagfaktoren"]
[{"$nulls":3},"F(Mo)","F(Di)","F(Mi)","F(Do)","F(Fr)","F(Sa)","F(So)"]
[null,"Tag",null,"Mo","Di","Mi","Do","Fr","Sa","So","Mo-So","Max Tag","Max Wert","Profil-Art","H/N-Profil","Alternative Profilempfehlung"]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
[1,"HEF","Einfamilienhaushalt",{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},"Mo-So",{"$f":"MAX(D7:J7)","v":{"v":1,"d":"1.0000  "}},"Heizgas"]
[2,"HMF","Mehrfamilienhaushalt",{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},"Mo-So",{"v":1,"d":"1.0000  "},"Heizgas"]
[3,"HKO","Kochgas",{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},{"v":1,"d":"1.0000  "},"Mo-So",{"$f":"MAX(D9:J9)","v":{"v":1,"d":"1.0000  "}},"Kochgas"]
[]
[4,"GKO","Gebietskörpersch., Kreditinst. u. Versich., Org. o. Erwerbszw. & öff. Einr.",{"v":1.0353906654726432,"d":"1.0354  "},{"v":1.0522626697461936,"d":"1.0523  "},{"v":1.044930469815579,"d":"1.0449  "},{"v":1.0493599072216477,"d":"1.0494  "},{"v":0.9884597489777012,"d":"0.9885  "},{"v":0.8860056359071147,"d":"0.8860  "},{"v":0.9435909028591213,"d":"0.9436  "},{"v":1,"d":"1.0000  "},"Di",{"v":1.0522626697461936,"d":"1.0523  "},"Gewerbe","Hauptprofil"]
[5,"GHA","Einzelhandel, Großhandel",{"v":1.0358469949391176,"d":"1.0358  "},{"v":1.02316516044779,"d":"1.0232  "},{"v":1.025224616371781,"d":"1.0252  "},{"v":1.0295353991682878,"d":"1.0295  "},{"v":1.0252886184395307,"d":"1.0253  "},{"v":0.9674952706583615,"d":"0.9675  "},{"v":0.8934439399751309,"d":"0.8934  "},{"v":1,"d":"1.0000  "},"Mo",{"v":1.0358469949391176,"d":"1.0358  "},"Gewerbe","Hauptprofil"]
[6,"GMK","Metall, Kfz",{"v":1.069856584592316,"d":"1.0699  "},{"v":1.0365322101473011,"d":"1.0365  "},{"v":0.9932557179192343,"d":"0.9933  "},{"v":0.9947828488586291,"d":"0.9948  "},{"v":1.065870859929255,"d":"1.0659  "},{"v":0.9362449719696236,"d":"0.9362  "},{"v":0.9034568065836398,"d":"0.9035  "},{"v":1,"d":"1.0000  "},"Mo",{"v":1.069856584592316,"d":"1.0699  "},"Gewerbe","Hauptprofil"]
[7,"GBD","sonst. betr. Dienstleistungen",{"v":1.1052461689,"d":"1.1052  "},{"v":1.0857012791,"d":"1.0857  "},{"v":1.0377707873,"d":"1.0378  "},{"v":1.06215513,"d":"1.0622  "},{"v":1.0265803347,"d":"1.0266  "},{"v":0.7628946809,"d":"0.7629  "},{"v":0.897991231,"d":"0.8980  "},{"v":1,"d":"1.0000  "},"Mo",{"v":1.1052461689,"d":"1.1052  "},"Gewerbe","Hauptprofil"]
[8,"GBH","Beherbergung",{"v":0.9766940095,"d":"0.9767  "},{"v":1.0389446761,"d":"1.0389  "},{"v":1.0028244082,"d":"1.0028  "},{"v":1.0161945715,"d":"1.0162  "},{"v":1.0023537775,"d":"1.0024  "},{"v":1.0043297858,"d":"1.0043  "},{"v":0.9583670626,"d":"0.9584  "},{"v":1,"d":"1.0000  "},"Di",{"v":1.0389446761,"d":"1.0389  "},"Gewerbe","Hauptprofil"]
[9,"GWA","Wäschereien",{"v":1.2457482941,"d":"1.2457  "},{"v":1.2614994284,"d":"1.2615  "},{"v":1.2706602107,"d":"1.2707  "},{"v":1.2430339493,"d":"1.2430  "},{"v":1.1276335364,"d":"1.1276  "},{"v":0.387661837,"d":"0.3877  "},{"v":0.4615442048,"d":"0.4615  "},{"v":1,"d":"1.0000  "},"Mi",{"$f":"MAX(D16:J16)","v":{"v":1.2706602107,"d":"1.2707  "}},"Gewerbe","Hauptprofil"]
[10,"GGA","Gaststätten",{"v":0.9322474153,"d":"0.9322  "},{"v":0.9894218818,"d":"0.9894  "},{"v":1.003324816,"d":"1.0033  "},{"v":1.0108926579,"d":"1.0109  "},{"v":1.0179736627,"d":"1.0180  "},{"v":1.0355882019,"d":"1.0356  "},{"v":1.0090728501,"d":"1.0091  "},{"v":1,"d":"1.0000  "},"Sa",{"v":1.0355882019,"d":"1.0356  "},"Gewerbe","Nebenprofil","GBH"]
[11,"GBA","Bäckereien",{"v":1.0847669095,"d":"1.0848  "},{"v":1.1211171725,"d":"1.1211  "},{"v":1.0769491269,"d":"1.0769  "},{"v":1.1353121304,"d":"1.1353  "},{"v":1.1401797149,"d":"1.1402  "},{"v":0.4852245678,"d":"0.4852  "},{"v":0.9584222802,"d":"0.9584  "},{"v":1,"d":"1.0000  "},"Fr",{"v":1.1401797149,"d":"1.1402  "},"Gewerbe","Nebenprofil","GWA"]
[12,"GGB","Gartenbau",{"v":0.9896630543,"d":"0.9897  "},{"v":0.9627360766,"d":"0.9627  "},{"v":1.0507108354,"d":"1.0507  "},{"v":1.0552346931,"d":"1.0552  "},{"v":1.0297033314,"d":"1.0297  "},{"v":0.9766710807,"d":"0.9767  "},{"v":0.9359887908,"d":"0.9360  "},{"v":1,"d":"1.0000  "},"Do",{"v":1.0552346931,"d":"1.0552  "},"Gewerbe","Nebenprofil","GKO"]
[13,"GPD","Papier und Druck",{"v":1.0213513197,"d":"1.0214  "},{"v":1.0865859003,"d":"1.0866  "},{"v":1.0719708746,"d":"1.0720  "},{"v":1.0557448463,"d":"1.0557  "},{"v":1.0116673967,"d":"1.0117  "},{"v":0.9001424455,"d":"0.9001  "},{"v":0.8511495026,"d":"0.8511  "},{"v":1,"d":"1.0000  "},"Mo",{"v":1.0865859003,"d":"1.0866  "},"Gewerbe","Nebenprofil","GHA"]
[14,"GMF","haushaltsähnliche Gewerbebetriebe",{"$f":"D11","v":{"v":1.0353906654726432,"d":"1.0354  "}},{"$f":"E11","v":{"v":1.0522626697461936,"d":"1.0523  "}},{"v":1.044930469815579,"d":"1.0449  "},{"v":1.0493599072216477,"d":"1.0494  "},{"v":0.9884597489777012,"d":"0.9885  "},{"v":0.8860056359071147,"d":"0.8860  "},{"v":0.9435909028591213,"d":"0.9436  "},{"v":1,"d":"1.0000  "},"Di",{"v":1.0522626697461936,"d":"1.0523  "},"Gewerbe","Nebenprofil","GBH"]
[15,"GHD","Summenlastprofil Gewerbe, Handel, Dienstleistung",{"v":1.03,"d":"1.0300  "},{"v":1.03,"d":"1.0300  "},{"v":1.02,"d":"1.0200  "},{"v":1.03,"d":"1.0300  "},{"v":1.01,"d":"1.0100  "},{"v":0.93,"d":"0.9300  "},{"v":0.94,"d":"0.9400  "},{"v":1,"d":"1.0000  "},"Di",{"$f":"MAX(D22:J22)","v":{"v":1.03,"d":"1.0300  "}},"Gewerbe","Nebenprofil"]