{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dateneingabe und Ergebnisse","Einfluss IKD","Einfluss EW_CSB120","Kostenentwicklung","Bemessung","Betriebskostenersparnis","Berechnung Grafik_Statisch","Berechnung Grafik Statisch 2","Berechnung Grafik_Dynamisch","Berechnung Grafik Dynamisch  2"," t_TS --> OVC","Fixe Parameter"],"not_rendered":{"charts":7,"images":2,"macros":1,"external_links":0,"defined_names":29,"comments":3,"pivot_tables":0},"unopened":[{"sheet":"Einfluss IKD","index":1,"reason":"not_a_worksheet"},{"sheet":"Einfluss EW_CSB120","index":2,"reason":"not_a_worksheet"},{"sheet":"Kostenentwicklung","index":3,"reason":"not_a_worksheet"}],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dateneingabe und Ergebnisse","index":0,"n_rows":491,"n_cols":26,"rows_kept":491,"cut":false,"hidden":false,"merged":[[95,0,109,8],[80,0,80,8],[71,3,72,8],[9,0,10,0],[73,0,74,0],[71,0,72,2],[26,0,27,2],[34,0,35,2],[83,3,83,8],[91,0,94,0],[81,0,82,2],[85,0,86,2],[87,0,90,0],[39,0,40,0],[58,0,59,0],[28,0,30,0],[34,3,35,8],[26,3,27,8],[41,0,41,8],[22,0,24,0],[25,0,25,8],[36,0,38,0],[33,0,33,8],[31,0,32,0],[0,3,0,5],[11,0,13,0],[14,0,15,0],[16,0,21,0],[0,6,0,8],[1,3,1,5],[1,6,1,8],[0,0,2,2],[5,0,6,0],[7,0,8,0],[84,0,84,8],[85,3,86,8],[81,3,82,8],[60,0,60,8],[42,0,43,2],[42,3,43,8],[49,0,49,8],[50,0,50,8],[44,0,48,0],[51,0,57,0],[61,3,62,8],[70,0,70,8],[61,0,62,2],[63,0,64,0],[65,0,68,0],[75,0,79,0]]}
["                         ",null,null,"Variante A:",null,null,"Variante F:"]
[null,null,null,"AEROBE  STABILISIERUNG",null,null,"FAULUNG"]
[null,null,null,"Nr.","Plausibilitäts-                          bereich","Eingabe ","Nr.","Plausibilitäts-                          bereich","Eingabe "]
[null,"                                                                                           D A T E N E I N G A B E B E R E I C H    I"]
["I: Mittlere Belastung der Kläranlage","Mittlere CSB-Belastung (siehe Handbuch)","EWCSB120","1A","2.000 - 40.000",null,"1F",null,{"$f":"F5","v":0}]
["II: Bemessungsbelastungen","CSB-Bemessungsbelastung Belebung ","EWCSB120","2A",null,null,"2F",null,{"$f":"F6","v":0}]
[null,"CSB-Bemessungsbelastung Faulung ","EWCSB120",null,null,null,"3F","s. Handbuch"]
["III: Wirkungsgrade","Mittlere Entfernung CSB","%","4A","85 - 98",85,"4F",null,{"$f":"F8","v":85}]
[null,"Mittlere Entfernung NGes","%","5A","70 - 95",70,"5F",null,{"$f":"F9","v":70}]
["IV: Vorklärung","Vorklärung","–","6A","JA / NEIN","NEIN","6F","JA / NEIN","NEIN"]
[null,"Wirkungsgrad Vorklärung (CSB)","%","7A","15 - 40",0,"7F","15 - 40",0]
["V: Belebungsbecken","Schlammalter Belebung","d","8A","25 - 35",25,"8F","s. Handbuch",15]
[null,"TSBB","g/L","9A","3,0 - 6,0",3,"9F","3,0 - 6,0",3]
[null,"Volumen Belebungsbecken  IST (VBB-IST)","m³","10A","s. Handbuch",null,"10F","s. Handbuch",7500]
["VI: Belüftung","Sauerstoffertrag","kg O2/kWh","11A","1,50 - 2,20",1.5,"11F",null,{"$f":"F15","v":1.5}]
[null,"Strompreis","Euro/kWh","12A","s. Handbuch",null,"12F",null,{"$f":"F16","v":0}]
["VII: Schlammlinie","oTS-Gehalt Primärschlamm","%","13A","50 - 80","–","13F","50 - 80","–"]
[null,"oTS-Gehalt Überschussschlamm","%","14A","45 - 70",45,"14F","s. Handbuch",60]
[null,"TS Rohschlamm (Zulauf Faulung; nach Voreindickung)","%",null,null,null,"15F","3,0 - 6,0",3]
[null,"Faulzeit","d",null,null,null,"16F","25 - 30",25]
[null,"TS nach Entwässerung","%","17F","20 - 30",20,"17F","20 - 30",20]
[null,"spezifische Schlamm-Entsorgungskosten","Euro/t","18F","s. Handbuch",null,"18F","s. Handbuch"]
["VIII: Faulgasnutzung","Faulgasnutzung","–",null,null,null,"19F","JA / NEIN","NEIN"]
[null,"mittlerer elektrischer Wirkungsgrad","%",null,null,null,"20F","26 - 40",0]
[null,"Strompreis (oder Einspeistarif)","Euro/kWh",null,null,null,"21F","s. Handbuch",0]
[]
["Zwischenergebnis 1: Abschätzung Belebung / Faulung"]
[]
["Belebung","VBB–SOLL bei vorgegebener TSBB (9A/9F)","m³",null,null,{"$f":"Bemessung!AL27*F12/F13","v":0},null,null,{"$f":"Bemessung!AL60*I12/I13","v":0}]
[null,"zusätzlich erforderliches VBB bei vorgegebener TSBB (9A/9F)","m³",null,null,{"$f":"IF(F29-F14<=0,0,F29-F14)","v":0},null,null,{"$f":"IF(I29-I14<=0,\"–\",I29-I14)","v":"–"}]
[null,"TSBB bei VBB–IST (Kontrollwert)","g/L",null,null,{"$f":"Bemessung!AL27*F12/F14","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Bemessung!AL60*I12/I14","v":0}]
["Faulung / Schlammanfall","Volumen Faulbehälter","m³",null,null,"–",null,null,{"$f":"Bemessung!BH58","v":0}]
[null,"Schlammanfall (entwässerter Schlamm)","t/Jahr",null,null,{"$f":"Bemessung!AY26","v":0},null,null,{"$f":"Bemessung!AY56","v":0}]
[]
["Zwischenergebnis 1B: Reservekapazität Variante F"]
[]
["Reservekapazität Belebung","Reservekapazität VBB ","m³",null,null,"–",null,null,{"$f":"I14-I29","v":7500}]
[null,"Reservekapazität Einwohnerwerte 1","EWCSB120",null,null,"–",null,null,{"$f":"Bemessung!B62","v":29765.598725618329}]
[null,"Reservekapazität Einwohnerwerte 2","%",null,null,"–",null,null,{"$f":"I38/I6*100","v":{"$error":"#DIV/0!"}}]
["Faulung bei Ausnutzung Reservekapazität","Volumen Faulbehälter bei Ausnutzung Reservekapazität","m³",null,null,"–",null,null,{"$f":"Bemessung!BH59","v":{"$error":"#DIV/0!"}}]
[null,"Schlammanfall bei Ausnutzung Reservekapazität (entwässerter Schlamm)","t/Jahr",null,null,"–",null,null,{"$f":"Bemessung!AY57","v":{"$error":"#DIV/0!"}}]
[]
["Zwischenergebnis 2: Faulgasnutzung"]
[]
["Faulgasnutzung","mittlere in Faulung abgebaute CSB-Fracht","kg CSB/ Jahr",null,null,"–",null,null,{"$f":"Bemessung!AU56","v":0}]
[null,"mittlere in Faulung entstehende CH4-Fracht","Nm³ CH4/Jahr",null,null,"–",null,null,{"$f":"I45*'Fixe Parameter'!C9","v":0}]
[null,"spezifischer elektrischer Energiegehalt","kWh_elektr./Nm³CH4",null,null,"–",null,null,{"$f":"'Fixe Parameter'!C8*I24/100","v":0}]
[null,"potentielle Stromproduktion pro Jahr","kWh_elektr./a",null,null,"–",null,null,{"$f":"I46*I47","v":0}]
[null,"theoretische mittlere Leistung BHKW bei Dauerbetrieb","kW",null,null,"–",null,null,{"$f":"I48/365/24","v":0}]
[]
["D A T E N E I N G A B E B E R E I C H    II"]
["IX: Investitionskosten","Investitionskosten Belebung","Euro","22A",null,0,"22F",null,0]
[null,"Investitionskosten Faulung","Euro",null,null,null,"23F",null,0]
[null,"Anteil Reinvestitionskosten (maschinelle Teile Belebung / Faulung)","%","24A","~ 40",40,"24F","~ 40",40]
[null,"Investitionskosten Vorklärung","Euro",null,null,null,"25F",null,0]
[null,"Investitionskosten Faulgasnutzung","Euro",null,null,null,"26F",null,0]
[null,"Sonstige Investitionskosten","Euro","27A",null,0,"27F",null,0]
[null,"Kalkulatorischer Zinssatz (Realverzinsung)","%","28A","0,0 - 5,0",0,"28F",null,{"$f":"F58","v":0}]
["X: zusätzliche Betriebskosten","etwaige zusätzliche Personalkosten – Variante F","Euro/Jahr",null,null,null,"29F","s. Handbuch",0]
[null,"etwaige zusätzliche sonstige Betriebskosten – Variante F","Euro/Jahr",null,null,null,"30F","s. Handbuch",0]
[]
["Zwischenergebnis 3: Kosten Variante A / Variante F "]
[]
["Gesamtinvestitionskosten                                                             ","Gesamtinvestitionskosten ohne RK","Euro",null,null,{"$f":"F52+F57","v":0},null,null,{"$f":"I53+I55+I56+I57","v":0}]
[null,"Gesamtinvestitionskosten mit RK                         ","Euro",null,null,{"$f":"F64+'Berechnung Grafik Dynamisch  2'!C19","v":0},null,null,{"$f":"I64+'Berechnung Grafik Dynamisch  2'!H19","v":0}]
["Betriebskosten","Kosten für Belüftung","Euro/Jahr",null,null,{"$f":"Bemessung!AG26","v":0},null,null,{"$f":"Bemessung!AG56","v":{"$error":"#DIV/0!"}}]
[null,"Kosten für Schlammentsorgung","Euro/Jahr",null,null,{"$f":"Bemessung!BA26","v":0},null,null,{"$f":"Bemessung!BA56","v":0}]
[null,"zusätzliche Betriebskosten – Variante F","Euro/Jahr",null,null,"–",null,null,{"$f":"I59+I60","v":0}]
[null,"Gewinn aus Eigenstromproduktion – Variante F","Euro/Jahr",null,null,"–",null,null,{"$f":"Bemessung!BT56","v":0}]
["Summe Betriebskosten","Belüftung + Schlammentsorgung + zusätzliche Betriebskosten -                                 Eigenstromproduktion","Euro/Jahr",null,null,{"$f":"F66+F67","v":0},null,null,{"$f":"I66+I67+I68-I69","v":{"$error":"#DIV/0!"}}]
[]
["Zwischenergebnis 3B: Kostendifferenz Variante A / Variante F"]
[]
["Einparung Gesamtinvestitionskosten                                                                                                                                                                                                                Variante A","Einsparung Gesamtinvestitionskosten ohne RK                                                                   ","Euro",null,null,{"$f":"I64-F64","v":0},null,null,"–"]
[null,"Einsparung Gesamtinvestitionskosten mit RK                                                                                       ","Euro",null,null,{"$f":"I65-F65","v":0},null,null,"–"]
["Einsparung / Erhöung Betriebskosten                                                                                                                                                                                                                                           Variante F","Einsparung Belüftung","Euro/Jahr",null,null,"–",null,null,{"$f":"F66-I66","v":{"$error":"#DIV/0!"}}]
[null,"Einsparung Schlammentsorgung","Euro/Jahr",null,null,"–",null,null,{"$f":"F67-I67","v":0}]
[null,"Einsparung durch Eigenstromproduktion","Euro/Jahr",null,null,"–",null,null,{"$f":"I69","v":0}]
[null,"Erhöhung durch etwaige zusätzliche Betriebskosten","Euro/Jahr",null,null,"–",null,null,{"$f":"I68","v":0}]
[null,"Einsparung – Gesamt","Euro/Jahr",null,null,"–",null,null,{"$f":"I76+I77+I78-I79","v":{"$error":"#DIV/0!"}}]
[]
["Endergebnis: Amortisationszeit Faulung"]
[]
["Amortisationszeit Faulung",null,"Jahre",{"$f":"'Berechnung Grafik_Dynamisch'!Q31","v":""}]
[]
["Kontrollwerte zur Plausibilitätsüberprüfung"]
[]
["Kontrollwerte Belebung","N-Rückbelastung Variante F","%",null,null,"–",null,"< 15",{"$f":"Bemessung!F58","v":{"$error":"#DIV/0!"}}]
[null,"Nges_zu/CSB_zu","–",null,"< 0,14",{"$f":"Bemessung!K6","v":9.166666666666666E-2},null,"< 0,14",{"$f":"Bemessung!K36","v":9.9087945859294271E-2}]
[null,"spezifische Belüftungskosten","kWh/(EW·a)",null,"15 - 25",{"$f":"Bemessung!AE26","v":{"$error":"#DIV/0!"}},null,"10 - 20",{"$f":"Bemessung!AE56","v":{"$error":"#DIV/0!"}}]
[null,"spezifische Kosten Erweiterung Belebung","Euro/m³",null,"300 - 500",{"$f":"IF(F52>0,F52/F30,\"–\")","v":"–"},null,"300 - 500",{"$f":"IF(I52>0,I52/I30,\"–\")","v":"–"}]
["Kontrollwerte Faulung","oTS-Reduktion in Faulung","%",null,null,"–",null,"35 - 50",{"$f":"Bemessung!AV56","v":{"$error":"#DIV/0!"}}]
[null,"spezifische Kosten Faulung","Euro/EW",null,null,"–",null,"s. Handbuch",{"$f":"I53/I7","v":{"$error":"#DIV/0!"}}]
[null,"spezifische Kosten Faulung","Euro/m³",null,null,"–",null,"800 - 1200",{"$f":"I53/I32","v":{"$error":"#DIV/0!"}}]
[null,"spezifischer Biogasanfall","L Biogas/(EW120·d)",null,null,"–",null,"s. Handbuch",{"$f":"I46/0.65/365/I5*1000","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,0,2000,70,1,"JA",25,15,45,50,25,3,50,0,1.5,3,0.9]
[null,null,null,null,null,null,null,null,null,null,0.5,2100,71,1.1000000000000001,"NEIN",26,16,46,51,26,3.5,51,15,1.6,4,1]
[null,null,null,null,null,null,null,null,null,null,1,2200,72,1.2,"–",27,17,47,52,27,4,52,16,1.7,5,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K113+0.5","v":1.5},2300,73,1.3,35,28,18,48,53,28,4.5,53,17,1.8,6]
[null,null,null,null,null,null,null,null,null,null,1.5,2400,74,1.4,null,29,19,49,54,29,5,54,18,1.9]
[null,null,null,null,null,null,null,null,null,null,2,2500,75,1.5,null,30,20,50,55,30,5.5,55,19,2]
[null,null,null,null,null,null,null,null,null,null,2.5,2600,76,1.6,null,null,21,51,56,31,6,56,20,2.1]
[null,null,null,null,null,null,null,null,null,null,3,2700,77,1.7,null,null,22,52,57,32,null,57,21,2.2000000000000002]
[null,null,null,null,null,null,null,null,null,null,3,2800,78,1.8,null,null,23,53,58,33,null,58,22]
[null,null,null,null,null,null,null,null,null,null,3.5,2900,79,1.9,null,null,24,54,59,34,null,59,23]
[null,null,null,null,null,null,null,null,null,null,4,3000,80,2,null,null,25,55,60,35,null,60,24]
[null,null,null,null,null,null,null,null,null,null,4.5,3100,81,null,null,null,26,56,61,null,null,61,25]
[null,null,null,null,null,null,null,null,null,null,4.5,3200,82,null,null,null,27,57,62,null,null,62]
[null,null,null,null,null,null,null,null,null,null,5,3300,83,null,null,null,28,58,63,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,3400,84,null,null,null,29,59,64,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,3500,85,null,null,null,30,60,65,null,null,65]
[null,null,null,null,null,null,null,null,null,null,null,3600,86,null,null,null,31,61,66,null,null,66]
[null,null,null,null,null,null,null,null,null,null,null,3700,87,null,null,null,32,62,67,null,null,67]
[null,null,null,null,null,null,null,null,null,null,null,3800,88,null,null,null,33,63,68,null,null,68]
[null,null,null,null,null,null,null,null,null,null,null,3900,89,null,null,null,34,64,69,null,null,69]
[null,null,null,null,null,null,null,null,null,null,null,4000,90,null,null,null,35,65,70,null,null,70]
[null,null,null,null,null,null,null,null,null,null,null,4100,91,null,null,null,36,66,null,null,null,71]
[null,null,null,null,null,null,null,null,null,null,null,4200,92,null,null,null,37,67,null,null,null,72]
[null,null,null,null,null,null,null,null,null,null,null,4300,93,null,null,null,38,68,null,null,null,73]
[null,null,null,null,null,null,null,null,null,null,null,4400,94,null,null,null,39,69,null,null,null,74]
[null,null,null,null,null,null,null,null,null,null,null,4500,95,null,null,null,40,70,null,null,null,75]
[null,null,null,null,null,null,null,null,null,null,null,4600,96,null,null,null,null,71]
[null,null,null,null,null,null,null,null,null,null,null,4700,97,null,null,null,null,72]
[null,null,null,null,null,null,null,null,null,null,null,4800,98,null,null,null,null,73]
[null,null,null,null,null,null,null,null,null,null,null,4900,99,null,null,null,null,74]
[null,null,null,null,null,null,null,null,null,null,null,5000,100,null,null,null,null,75]
[null,null,null,null,null,null,null,null,null,null,null,5100,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,null,null,5200,null,null,null,null,null,77]
[null,null,null,null,null,null,null,null,null,null,null,5300,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,null,null,5400,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,null,null,5500,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,null,null,5600]
[null,null,null,null,null,null,null,null,null,null,null,5700]
[null,null,null,null,null,null,null,null,null,null,null,5800]
[null,null,null,null,null,null,null,null,null,null,null,5900]
[null,null,null,null,null,null,null,null,null,null,null,6000]
[null,null,null,null,null,null,null,null,null,null,null,6100]
[null,null,null,null,null,null,null,null,null,null,null,6200]
[null,null,null,null,null,null,null,null,null,null,null,6300]
[null,null,null,null,null,null,null,null,null,null,null,6400]
[null,null,null,null,null,null,null,null,null,null,null,6500]
[null,null,null,null,null,null,null,null,null,null,null,6600]
[null,null,null,null,null,null,null,null,null,null,null,6700]
[null,null,null,null,null,null,null,null,null,null,null,6800]
[null,null,null,null,null,null,null,null,null,null,null,6900]
[null,null,null,null,null,null,null,null,null,null,null,7000]
[null,null,null,null,null,null,null,null,null,null,null,7100]
[null,null,null,null,null,null,null,null,null,null,null,7200]
[null,null,null,null,null,null,null,null,null,null,null,7300]
[null,null,null,null,null,null,null,null,null,null,null,7400]
[null,null,null,null,null,null,null,null,null,null,null,7500]
[null,null,null,null,null,null,null,null,null,null,null,7600]
[null,null,null,null,null,null,null,null,null,null,null,7700]
[null,null,null,null,null,null,null,null,null,null,null,7800]
[null,null,null,null,null,null,null,null,null,null,null,7900]
[null,null,null,null,null,null,null,null,null,null,null,8000]
[null,null,null,null,null,null,null,null,null,null,null,8100]
[null,null,null,null,null,null,null,null,null,null,null,8200]
[null,null,null,null,null,null,null,null,null,null,null,8300]
[null,null,null,null,null,null,null,null,null,null,null,8400]
[null,null,null,null,null,null,null,null,null,null,null,8500]
[null,null,null,null,null,null,null,null,null,null,null,8600]
[null,null,null,null,null,null,null,null,null,null,null,8700]
[null,null,null,null,null,null,null,null,null,null,null,8800]
[null,null,null,null,null,null,null,null,null,null,null,8900]
[null,null,null,null,null,null,null,null,null,null,null,9000]
[null,null,null,null,null,null,null,null,null,null,null,9100]
[null,null,null,null,null,null,null,null,null,null,null,9200]
[null,null,null,null,null,null,null,null,null,null,null,9300]
[null,null,null,null,null,null,null,null,null,null,null,9400]
[null,null,null,null,null,null,null,null,null,null,null,9500]
[null,null,null,null,null,null,null,null,null,null,null,9600]
[null,null,null,null,null,null,null,null,null,null,null,9700]
[null,null,null,null,null,null,null,null,null,null,null,9800]
[null,null,null,null,null,null,null,null,null,null,null,9900]
[null,null,null,null,null,null,null,null,null,null,null,10000]
[null,null,null,null,null,null,null,null,null,null,null,10100]
[null,null,null,null,null,null,null,null,null,null,null,10200]
[null,null,null,null,null,null,null,null,null,null,null,10300]
[null,null,null,null,null,null,null,null,null,null,null,10400]
[null,null,null,null,null,null,null,null,null,null,null,10500]
[null,null,null,null,null,null,null,null,null,null,null,10600]
[null,null,null,null,null,null,null,null,null,null,null,10700]
[null,null,null,null,null,null,null,null,null,null,null,10800]
[null,null,null,null,null,null,null,null,null,null,null,10900]
[null,null,null,null,null,null,null,null,null,null,null,11000]
[null,null,null,null,null,null,null,null,null,null,null,11100]
[null,null,null,null,null,null,null,null,null,null,null,11200]
[null,null,null,null,null,null,null,null,null,null,null,11300]
[null,null,null,null,null,null,null,null,null,null,null,11400]
[null,null,null,null,null,null,null,null,null,null,null,11500]
[null,null,null,null,null,null,null,null,null,null,null,11600]
[null,null,null,null,null,null,null,null,null,null,null,11700]
[null,null,null,null,null,null,null,null,null,null,null,11800]
[null,null,null,null,null,null,null,null,null,null,null,11900]
[null,null,null,null,null,null,null,null,null,null,null,12000]
[null,null,null,null,null,null,null,null,null,null,null,12100]
[null,null,null,null,null,null,null,null,null,null,null,12200]
[null,null,null,null,null,null,null,null,null,null,null,12300]
[null,null,null,null,null,null,null,null,null,null,null,12400]
[null,null,null,null,null,null,null,null,null,null,null,12500]
[null,null,null,null,null,null,null,null,null,null,null,12600]
[null,null,null,null,null,null,null,null,null,null,null,12700]
[null,null,null,null,null,null,null,null,null,null,null,12800]
[null,null,null,null,null,null,null,null,null,null,null,12900]
[null,null,null,null,null,null,null,null,null,null,null,13000]
[null,null,null,null,null,null,null,null,null,null,null,13100]
[null,null,null,null,null,null,null,null,null,null,null,13200]
[null,null,null,null,null,null,null,null,null,null,null,13300]
[null,null,null,null,null,null,null,null,null,null,null,13400]
[null,null,null,null,null,null,null,null,null,null,null,13500]
[null,null,null,null,null,null,null,null,null,null,null,13600]
[null,null,null,null,null,null,null,null,null,null,null,13700]
[null,null,null,null,null,null,null,null,null,null,null,13800]
[null,null,null,null,null,null,null,null,null,null,null,13900]
[null,null,null,null,null,null,null,null,null,null,null,14000]
[null,null,null,null,null,null,null,null,null,null,null,14100]
[null,null,null,null,null,null,null,null,null,null,null,14200]
[null,null,null,null,null,null,null,null,null,null,null,14300]
[null,null,null,null,null,null,null,null,null,null,null,14400]
[null,null,null,null,null,null,null,null,null,null,null,14500]
[null,null,null,null,null,null,null,null,null,null,null,14600]
[null,null,null,null,null,null,null,null,null,null,null,14700]
[null,null,null,null,null,null,null,null,null,null,null,14800]
[null,null,null,null,null,null,null,null,null,null,null,14900]
[null,null,null,null,null,null,null,null,null,null,null,15000]
[null,null,null,null,null,null,null,null,null,null,null,15100]
[null,null,null,null,null,null,null,null,null,null,null,15200]
[null,null,null,null,null,null,null,null,null,null,null,15300]
[null,null,null,null,null,null,null,null,null,null,null,15400]
[null,null,null,null,null,null,null,null,null,null,null,15500]
[null,null,null,null,null,null,null,null,null,null,null,15600]
[null,null,null,null,null,null,null,null,null,null,null,15700]
[null,null,null,null,null,null,null,null,null,null,null,15800]
[null,null,null,null,null,null,null,null,null,null,null,15900]
[null,null,null,null,null,null,null,null,null,null,null,16000]
[null,null,null,null,null,null,null,null,null,null,null,16100]
[null,null,null,null,null,null,null,null,null,null,null,16200]
[null,null,null,null,null,null,null,null,null,null,null,16300]
[null,null,null,null,null,null,null,null,null,null,null,16400]
[null,null,null,null,null,null,null,null,null,null,null,16500]
[null,null,null,null,null,null,null,null,null,null,null,16600]
[null,null,null,null,null,null,null,null,null,null,null,16700]
[null,null,null,null,null,null,null,null,null,null,null,16800]
[null,null,null,null,null,null,null,null,null,null,null,16900]
[null,null,null,null,null,null,null,null,null,null,null,17000]
[null,null,null,null,null,null,null,null,null,null,null,17100]
[null,null,null,null,null,null,null,null,null,null,null,17200]
[null,null,null,null,null,null,null,null,null,null,null,17300]
[null,null,null,null,null,null,null,null,null,null,null,17400]
[null,null,null,null,null,null,null,null,null,null,null,17500]
[null,null,null,null,null,null,null,null,null,null,null,17600]
[null,null,null,null,null,null,null,null,null,null,null,17700]
[null,null,null,null,null,null,null,null,null,null,null,17800]
[null,null,null,null,null,null,null,null,null,null,null,17900]
[null,null,null,null,null,null,null,null,null,null,null,18000]
[null,null,null,null,null,null,null,null,null,null,null,18100]
[null,null,null,null,null,null,null,null,null,null,null,18200]
[null,null,null,null,null,null,null,null,null,null,null,18300]
[null,null,null,null,null,null,null,null,null,null,null,18400]
[null,null,null,null,null,null,null,null,null,null,null,18500]
[null,null,null,null,null,null,null,null,null,null,null,18600]
[null,null,null,null,null,null,null,null,null,null,null,18700]
[null,null,null,null,null,null,null,null,null,null,null,18800]
[null,null,null,null,null,null,null,null,null,null,null,18900]
[null,null,null,null,null,null,null,null,null,null,null,19000]
[null,null,null,null,null,null,null,null,null,null,null,19100]
[null,null,null,null,null,null,null,null,null,null,null,19200]
[null,null,null,null,null,null,null,null,null,null,null,19300]
[null,null,null,null,null,null,null,null,null,null,null,19400]
[null,null,null,null,null,null,null,null,null,null,null,19500]
[null,null,null,null,null,null,null,null,null,null,null,19600]
[null,null,null,null,null,null,null,null,null,null,null,19700]
[null,null,null,null,null,null,null,null,null,null,null,19800]
[null,null,null,null,null,null,null,null,null,null,null,19900]
[null,null,null,null,null,null,null,null,null,null,null,20000]
[null,null,null,null,null,null,null,null,null,null,null,20100]
[null,null,null,null,null,null,null,null,null,null,null,20200]
[null,null,null,null,null,null,null,null,null,null,null,20300]
[null,null,null,null,null,null,null,null,null,null,null,20400]
[null,null,null,null,null,null,null,null,null,null,null,20500]
[null,null,null,null,null,null,null,null,null,null,null,20600]
[null,null,null,null,null,null,null,null,null,null,null,20700]
[null,null,null,null,null,null,null,null,null,null,null,20800]
[null,null,null,null,null,null,null,null,null,null,null,20900]
[null,null,null,null,null,null,null,null,null,null,null,21000]
[null,null,null,null,null,null,null,null,null,null,null,21100]
[null,null,null,null,null,null,null,null,null,null,null,21200]
[null,null,null,null,null,null,null,null,null,null,null,21300]
[null,null,null,null,null,null,null,null,null,null,null,21400]
[null,null,null,null,null,null,null,null,null,null,null,21500]
[null,null,null,null,null,null,null,null,null,null,null,21600]
[null,null,null,null,null,null,null,null,null,null,null,21700]
[null,null,null,null,null,null,null,null,null,null,null,21800]
[null,null,null,null,null,null,null,null,null,null,null,21900]
[null,null,null,null,null,null,null,null,null,null,null,22000]
[null,null,null,null,null,null,null,null,null,null,null,22100]
[null,null,null,null,null,null,null,null,null,null,null,22200]
[null,null,null,null,null,null,null,null,null,null,null,22300]
[null,null,null,null,null,null,null,null,null,null,null,22400]
[null,null,null,null,null,null,null,null,null,null,null,22500]
[null,null,null,null,null,null,null,null,null,null,null,22600]
[null,null,null,null,null,null,null,null,null,null,null,22700]
[null,null,null,null,null,null,null,null,null,null,null,22800]
[null,null,null,null,null,null,null,null,null,null,null,22900]
[null,null,null,null,null,null,null,null,null,null,null,23000]
[null,null,null,null,null,null,null,null,null,null,null,23100]
[null,null,null,null,null,null,null,null,null,null,null,23200]
[null,null,null,null,null,null,null,null,null,null,null,23300]
[null,null,null,null,null,null,null,null,null,null,null,23400]
[null,null,null,null,null,null,null,null,null,null,null,23500]
[null,null,null,null,null,null,null,null,null,null,null,23600]
[null,null,null,null,null,null,null,null,null,null,null,23700]
[null,null,null,null,null,null,null,null,null,null,null,23800]
[null,null,null,null,null,null,null,null,null,null,null,23900]
[null,null,null,null,null,null,null,null,null,null,null,24000]
[null,null,null,null,null,null,null,null,null,null,null,24100]
[null,null,null,null,null,null,null,null,null,null,null,24200]
[null,null,null,null,null,null,null,null,null,null,null,24300]
[null,null,null,null,null,null,null,null,null,null,null,24400]
[null,null,null,null,null,null,null,null,null,null,null,24500]
[null,null,null,null,null,null,null,null,null,null,null,24600]
[null,null,null,null,null,null,null,null,null,null,null,24700]
[null,null,null,null,null,null,null,null,null,null,null,24800]
[null,null,null,null,null,null,null,null,null,null,null,24900]
[null,null,null,null,null,null,null,null,null,null,null,25000]
[null,null,null,null,null,null,null,null,null,null,null,25100]
[null,null,null,null,null,null,null,null,null,null,null,25200]
[null,null,null,null,null,null,null,null,null,null,null,25300]
[null,null,null,null,null,null,null,null,null,null,null,25400]
[null,null,null,null,null,null,null,null,null,null,null,25500]
[null,null,null,null,null,null,null,null,null,null,null,25600]
[null,null,null,null,null,null,null,null,null,null,null,25700]
[null,null,null,null,null,null,null,null,null,null,null,25800]
[null,null,null,null,null,null,null,null,null,null,null,25900]
[null,null,null,null,null,null,null,null,null,null,null,26000]
[null,null,null,null,null,null,null,null,null,null,null,26100]
[null,null,null,null,null,null,null,null,null,null,null,26200]
[null,null,null,null,null,null,null,null,null,null,null,26300]
[null,null,null,null,null,null,null,null,null,null,null,26400]
[null,null,null,null,null,null,null,null,null,null,null,26500]
[null,null,null,null,null,null,null,null,null,null,null,26600]
[null,null,null,null,null,null,null,null,null,null,null,26700]
[null,null,null,null,null,null,null,null,null,null,null,26800]
[null,null,null,null,null,null,null,null,null,null,null,26900]
[null,null,null,null,null,null,null,null,null,null,null,27000]
[null,null,null,null,null,null,null,null,null,null,null,27100]
[null,null,null,null,null,null,null,null,null,null,null,27200]
[null,null,null,null,null,null,null,null,null,null,null,27300]
[null,null,null,null,null,null,null,null,null,null,null,27400]
[null,null,null,null,null,null,null,null,null,null,null,27500]
[null,null,null,null,null,null,null,null,null,null,null,27600]
[null,null,null,null,null,null,null,null,null,null,null,27700]
[null,null,null,null,null,null,null,null,null,null,null,27800]
[null,null,null,null,null,null,null,null,null,null,null,27900]
[null,null,null,null,null,null,null,null,null,null,null,28000]
[null,null,null,null,null,null,null,null,null,null,null,28100]
[null,null,null,null,null,null,null,null,null,null,null,28200]
[null,null,null,null,null,null,null,null,null,null,null,28300]
[null,null,null,null,null,null,null,null,null,null,null,28400]
[null,null,null,null,null,null,null,null,null,null,null,28500]
[null,null,null,null,null,null,null,null,null,null,null,28600]
[null,null,null,null,null,null,null,null,null,null,null,28700]
[null,null,null,null,null,null,null,null,null,null,null,28800]
[null,null,null,null,null,null,null,null,null,null,null,28900]
[null,null,null,null,null,null,null,null,null,null,null,29000]
[null,null,null,null,null,null,null,null,null,null,null,29100]
[null,null,null,null,null,null,null,null,null,null,null,29200]
[null,null,null,null,null,null,null,null,null,null,null,29300]
[null,null,null,null,null,null,null,null,null,null,null,29400]
[null,null,null,null,null,null,null,null,null,null,null,29500]
[null,null,null,null,null,null,null,null,null,null,null,29600]
[null,null,null,null,null,null,null,null,null,null,null,29700]
[null,null,null,null,null,null,null,null,null,null,null,29800]
[null,null,null,null,null,null,null,null,null,null,null,29900]
[null,null,null,null,null,null,null,null,null,null,null,30000]
[null,null,null,null,null,null,null,null,null,null,null,30100]
[null,null,null,null,null,null,null,null,null,null,null,30200]
[null,null,null,null,null,null,null,null,null,null,null,30300]
[null,null,null,null,null,null,null,null,null,null,null,30400]
[null,null,null,null,null,null,null,null,null,null,null,30500]
[null,null,null,null,null,null,null,null,null,null,null,30600]
[null,null,null,null,null,null,null,null,null,null,null,30700]
[null,null,null,null,null,null,null,null,null,null,null,30800]
[null,null,null,null,null,null,null,null,null,null,null,30900]
[null,null,null,null,null,null,null,null,null,null,null,31000]
[null,null,null,null,null,null,null,null,null,null,null,31100]
[null,null,null,null,null,null,null,null,null,null,null,31200]
[null,null,null,null,null,null,null,null,null,null,null,31300]
[null,null,null,null,null,null,null,null,null,null,null,31400]
[null,null,null,null,null,null,null,null,null,null,null,31500]
[null,null,null,null,null,null,null,null,null,null,null,31600]
[null,null,null,null,null,null,null,null,null,null,null,31700]
[null,null,null,null,null,null,null,null,null,null,null,31800]
[null,null,null,null,null,null,null,null,null,null,null,31900]
[null,null,null,null,null,null,null,null,null,null,null,32000]
[null,null,null,null,null,null,null,null,null,null,null,32100]
[null,null,null,null,null,null,null,null,null,null,null,32200]
[null,null,null,null,null,null,null,null,null,null,null,32300]
[null,null,null,null,null,null,null,null,null,null,null,32400]
[null,null,null,null,null,null,null,null,null,null,null,32500]
[null,null,null,null,null,null,null,null,null,null,null,32600]
[null,null,null,null,null,null,null,null,null,null,null,32700]
[null,null,null,null,null,null,null,null,null,null,null,32800]
[null,null,null,null,null,null,null,null,null,null,null,32900]
[null,null,null,null,null,null,null,null,null,null,null,33000]
[null,null,null,null,null,null,null,null,null,null,null,33100]
[null,null,null,null,null,null,null,null,null,null,null,33200]
[null,null,null,null,null,null,null,null,null,null,null,33300]
[null,null,null,null,null,null,null,null,null,null,null,33400]
[null,null,null,null,null,null,null,null,null,null,null,33500]
[null,null,null,null,null,null,null,null,null,null,null,33600]
[null,null,null,null,null,null,null,null,null,null,null,33700]
[null,null,null,null,null,null,null,null,null,null,null,33800]
[null,null,null,null,null,null,null,null,null,null,null,33900]
[null,null,null,null,null,null,null,null,null,null,null,34000]
[null,null,null,null,null,null,null,null,null,null,null,34100]
[null,null,null,null,null,null,null,null,null,null,null,34200]
[null,null,null,null,null,null,null,null,null,null,null,34300]
[null,null,null,null,null,null,null,null,null,null,null,34400]
[null,null,null,null,null,null,null,null,null,null,null,34500]
[null,null,null,null,null,null,null,null,null,null,null,34600]
[null,null,null,null,null,null,null,null,null,null,null,34700]
[null,null,null,null,null,null,null,null,null,null,null,34800]
[null,null,null,null,null,null,null,null,null,null,null,34900]
[null,null,null,null,null,null,null,null,null,null,null,35000]
[null,null,null,null,null,null,null,null,null,null,null,35100]
[null,null,null,null,null,null,null,null,null,null,null,35200]
[null,null,null,null,null,null,null,null,null,null,null,35300]
[null,null,null,null,null,null,null,null,null,null,null,35400]
[null,null,null,null,null,null,null,null,null,null,null,35500]
[null,null,null,null,null,null,null,null,null,null,null,35600]
[null,null,null,null,null,null,null,null,null,null,null,35700]
[null,null,null,null,null,null,null,null,null,null,null,35800]
[null,null,null,null,null,null,null,null,null,null,null,35900]
[null,null,null,null,null,null,null,null,null,null,null,36000]
[null,null,null,null,null,null,null,null,null,null,null,36100]
[null,null,null,null,null,null,null,null,null,null,null,36200]
[null,null,null,null,null,null,null,null,null,null,null,36300]
[null,null,null,null,null,null,null,null,null,null,null,36400]
[null,null,null,null,null,null,null,null,null,null,null,36500]
[null,null,null,null,null,null,null,null,null,null,null,36600]
[null,null,null,null,null,null,null,null,null,null,null,36700]
[null,null,null,null,null,null,null,null,null,null,null,36800]
[null,null,null,null,null,null,null,null,null,null,null,36900]
[null,null,null,null,null,null,null,null,null,null,null,37000]
[null,null,null,null,null,null,null,null,null,null,null,37100]
[null,null,null,null,null,null,null,null,null,null,null,37200]
[null,null,null,null,null,null,null,null,null,null,null,37300]
[null,null,null,null,null,null,null,null,null,null,null,37400]
[null,null,null,null,null,null,null,null,null,null,null,37500]
[null,null,null,null,null,null,null,null,null,null,null,37600]
[null,null,null,null,null,null,null,null,null,null,null,37700]
[null,null,null,null,null,null,null,null,null,null,null,37800]
[null,null,null,null,null,null,null,null,null,null,null,37900]
[null,null,null,null,null,null,null,null,null,null,null,38000]
[null,null,null,null,null,null,null,null,null,null,null,38100]
[null,null,null,null,null,null,null,null,null,null,null,38200]
[null,null,null,null,null,null,null,null,null,null,null,38300]
[null,null,null,null,null,null,null,null,null,null,null,38400]
[null,null,null,null,null,null,null,null,null,null,null,38500]
[null,null,null,null,null,null,null,null,null,null,null,38600]
[null,null,null,null,null,null,null,null,null,null,null,38700]
[null,null,null,null,null,null,null,null,null,null,null,38800]
[null,null,null,null,null,null,null,null,null,null,null,38900]
[null,null,null,null,null,null,null,null,null,null,null,39000]
[null,null,null,null,null,null,null,null,null,null,null,39100]
[null,null,null,null,null,null,null,null,null,null,null,39200]
[null,null,null,null,null,null,null,null,null,null,null,39300]
[null,null,null,null,null,null,null,null,null,null,null,39400]
[null,null,null,null,null,null,null,null,null,null,null,39500]
[null,null,null,null,null,null,null,null,null,null,null,39600]
[null,null,null,null,null,null,null,null,null,null,null,39700]
[null,null,null,null,null,null,null,null,null,null,null,39800]
[null,null,null,null,null,null,null,null,null,null,null,39900]
[null,null,null,null,null,null,null,null,null,null,null,40000]

{"sheet":"Bemessung","index":4,"n_rows":67,"n_cols":72,"rows_kept":67,"cut":false,"hidden":true,"merged":[[2,12,2,27],[2,28,2,32],[2,33,2,52],[32,54,32,60],[0,1,0,8],[29,1,29,8],[2,1,2,10],[32,1,32,10],[32,12,32,27],[32,62,32,71],[5,0,24,0],[35,0,54,0],[32,28,32,32],[32,33,32,52]]}
[null,"VARIANTE    A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"iN,ÜS=","NO3_ab/Nges_zu","Nges_ab/Nges_zu",null,null,null,null,null,"CS",{"$f":"'Fixe Parameter'!C2","v":13},null,null,null,null,null,null,null,"CSB/oTS",null,"TS/CSB (rückgerechnet)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Fixe Parameter'!C6","v":0.06},{"$f":"T2/2","v":0.15},{"$f":"(100-'Dateneingabe und Ergebnisse'!F9)/100","v":0.3},null,null,null,null,null,"CX",{"$f":"'Fixe Parameter'!C3","v":1.5},null,null,null,null,null,null,null,{"$f":"'Fixe Parameter'!C5","v":1.45},null,{"$f":"AK6/AH6","v":1.5325670498084294}]
[null,"ZULAUFFRACHTEN",null,null,null,null,null,null,null,null,null,"SCHLAMMALTER","SAUERSTOFFBEDARF BELEBUNG ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERGIE UND BELÜFTUNGSKOSTEN",null,null,null,null,"SCHLAMM"]
[null,"Einwohnerwerte CSB","CSB-Zulauffracht","N-Zulauffracht","N-Rückbelastung","Anteil N-Rückbelastung","VK","hVK","CSB-Zulauffracht Belebung","N-Zulauffracht Belebung","N:CSB","Schlammalter","CSB-OVC","CSB-Entfernung                 ( hges)","Hilfsgröße:                                    hBB bei hges                        mit Einfluss von hVK ","CSB-Entfernung","OVC","XorgN,BM","NO3-N,ab","Nges,ab","NO3-N (OVN)","OVN","NO3-N (OVD)","OVD","N-Entferunung IST","OV_GES","Sättigungsfaktor","erfαOC=","SAE","erforderliche Belüftungsenergie","Kontrolle über LINDNER","Strompreis","Belüftungskosten","CSBÜS","oTS-ÜS vor Faulung","oTS-Gehalt-ÜS","TS-ÜS vor Faulung","TS-ÜS vor Faulung","CSBPS","oTS-PS vor Faulung","oTS-Gehalt-PS","oTS-Schlamm vor Faulung","TS-Schlamm vor Faulung","spez. oTS-Gehalt nach Faulung","oTS-Schlamm nach Faulung","oTS-Reduktion in Faulung","CSB-Reduktion in Faulung","oTS-Reduktion in Faulung","TS-Schlamm nach Faulung_ALT","TS-Gehalt","zu entsorgende Schlammfracht","spez. Schlamm-Entsorgungskosten","Schlammentsorgungs- kosten"]
[null,"EW120","kg CSB/Jahr","kg N/Jahr","kg N/Jahr","%","-","%","kg CSB/Jahr","kg N/Jahr","-","t","%","%","%","kg CSB/Jahr","kg O2/Jahr","kg N/Jahr","kg N/Jahr","kg N/Jahr","kg N/Jahr","kg O2/Jahr","kg N/Jahr","kgO2/Jahr","%","kgO2/Jahr","-","kg O2/Jahr","kg O2/kWh","kWh/Jahr","kWh/(EW·a)","Euro/kWh","Euro/Jahr","kg CSB/Jahr","kg oTS/Jahr","%","kg TS/Jahr","kg TS/Tag","kg CSB/Jahr","kg oTS/Jahr","%","kg oTS/Jahr","kg TS/Jahr","g oTS/(EW120·d)","kg oTS/Jahr","kg oTS/Jahr","kg CSB/Jahr","%","kg TS/Jahr","%","t/Jahr","Euro/t","Euro/Jahr"]
["Berechnung allgemeine Kurvenschaar",2000,{"$f":"B6*0.12*365","v":87600},{"$f":"B6*0.011*365","v":8030},0,0,{"$f":"'Dateneingabe und Ergebnisse'!F10","v":"NEIN"},{"$f":"IF('Dateneingabe und Ergebnisse'!F11=\"–\",0,'Dateneingabe und Ergebnisse'!F11)","v":0},{"$f":"IF(G6=\"NEIN\",C6,C6*(1-H6/100))","v":87600},{"$f":"B6*0.011*365+E6","v":8030},{"$f":"J6/I6","v":9.166666666666666E-2},{"$f":"'Dateneingabe und Ergebnisse'!F12","v":25},{"$f":"IF(G6=\"NEIN\",IF(L6<=35,9.4345*LN(L6)+32.468-1,65),IF(L6<=35,8.8152*LN(L6)+39.505-1,70))","v":61.83648396971904},{"$f":"'Dateneingabe und Ergebnisse'!F8","v":85},{"$f":"(N6-H6)/(100-H6)*100","v":85},{"$f":"I6*O6/100","v":74460},{"$f":"P6*M6/100","v":46043.445963852799},{"$f":"AH6*$R$2","v":1704.993242168832},{"$f":"J6*$S$2","v":1204.5},{"$f":"J6*$T$2","v":2409},{"$f":"J6-R6-T6+S6","v":5120.5067578311682},{"$f":"U6*4.3","v":22018.179058674021},{"$f":"J6-R6-T6","v":3916.0067578311682},{"$f":"W6*2.9","v":11356.419597710388},{"$f":"100-T6/J6*100","v":70},{"$f":"Q6+V6-X6","v":56705.205424816428},{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},{"$f":"Z6*AA6","v":64101.536567183786},{"$f":"'Dateneingabe und Ergebnisse'!F15","v":1.5},{"$f":"AB6/AC6","v":42734.357711455857},{"$f":"AD6/B6","v":21.367178855727929},{"$f":"'Dateneingabe und Ergebnisse'!F16","v":0},{"$f":"AD6*AF6","v":0},{"$f":"P6*((100-M6)/100)","v":28416.554036147201},{"$f":"AH6/$AI$2","v":19597.623473204967},{"$f":"'Dateneingabe und Ergebnisse'!F18","v":45},{"$f":"AI6/AJ6*100","v":43550.274384899931},{"$f":"AK6/365","v":119.31582023260255},{"$f":"C6-I6","v":0},{"$f":"AM6/$AI$2","v":0},{"$f":"'Dateneingabe und Ergebnisse'!F17","v":"–"},{"$f":"AI6+AN6","v":19597.623473204967},{"$f":"IF(AO6<>\"–\",AK6+AN6/AO6*100,AK6)","v":43550.274384899931},"-","-","-",null,"-",{"$f":"AQ6","v":43550.274384899931},{"$f":"'Dateneingabe und Ergebnisse'!F21","v":20},{"$f":"AW6/(AX6/100)/1000","v":217.75137192449964},{"$f":"'Dateneingabe und Ergebnisse'!F22","v":0},{"$f":"AY6*AZ6","v":0}]
[null,4000,175200,16060,{"$f":"E6","v":0},{"$f":"F6","v":0},{"$f":"G6","v":"NEIN"},{"$f":"H6","v":0},175200,16060,9.166666666666666E-2,{"$f":"L6","v":25},{"$f":"IF(G7=\"NEIN\",IF(L7<=35,9.4345*LN(L7)+32.468-1,65),IF(L7<=35,8.8152*LN(L7)+39.505-1,70))","v":61.83648396971904},{"$f":"N6","v":85},{"$f":"(N7-H7)/(100-H7)*100","v":85},{"$f":"I7*O7/100","v":148920},{"$f":"P7*M7/100","v":92086.891927705597},3409.986484337664,{"$f":"J7*$S$2","v":2409},{"$f":"J7*$T$2","v":4818},10241.013515662336,{"$f":"U7*4.3","v":44036.358117348042},{"$f":"J7-R7-T7","v":7832.0135156623364},{"$f":"W7*2.9","v":22712.839195420776},{"$f":"100-T7/J7*100","v":70},113410.41084963286,{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},128203.07313436757,{"$f":"AC6","v":1.5},85468.715422911715,21.367178855727929,{"$f":"AF6","v":0},0,{"$f":"P7*((100-M7)/100)","v":56833.108072294403},39195.246946409934,{"$f":"AJ6","v":45},{"$f":"AI7/AJ7*100","v":87100.548769799861},{"$f":"AK7/365","v":238.63164046520509},0,0,{"$f":"AO6","v":"–"},39195.246946409934,{"$f":"IF(AO7<>\"–\",AK7+AN7/AO7*100,AK7)","v":87100.548769799861},{"$f":"AR6","v":"-"},{"$f":"AS6","v":"-"},{"$f":"AT6","v":"-"},null,{"$f":"AV6","v":"-"},87100.548769799861,{"$f":"AX6","v":20},435.50274384899927,{"$f":"AZ6","v":0},0]
[null,6000,262800,24090,{"$f":"E7","v":0},0,"NEIN",0,262800,24090,9.166666666666666E-2,25,61.83648396971904,{"$f":"N7","v":85},85,223380,138130.33789155839,5114.9797265064963,3613.5,7227,15361.520273493505,66054.537176022073,11748.020273493505,{"$f":"W8*2.9","v":34069.258793131165},70,170115.6162744493,1.1304347826086956,192304.60970155138,1.5,128203.07313436759,21.367178855727932,0,0,{"$f":"P8*((100-M8)/100)","v":85249.662108441611},58792.870419614905,45,{"$f":"AI8/AJ8*100","v":130650.82315469978},357.94746069780763,0,0,{"$f":"AO7","v":"–"},58792.870419614905,130650.82315469978,{"$f":"AR7","v":"-"},{"$f":"AS7","v":"-"},{"$f":"AT7","v":"-"},null,{"$f":"AV7","v":"-"},130650.82315469978,20,653.25411577349894,0,0]
[null,8000,350400,32120,0,0,"NEIN",0,350400,32120,9.166666666666666E-2,25,61.83648396971904,85,85,297840,184173.78385541119,6819.972968675328,4818,9636,20482.027031324673,88072.716234696083,15664.027031324673,{"$f":"W9*2.9","v":45425.678390841553},70,226820.82169926571,1.1304347826086956,256406.14626873514,1.5,170937.43084582343,21.367178855727929,0,0,{"$f":"P9*((100-M9)/100)","v":113666.21614458881},78390.493892819868,45,174201.09753959972,477.26328093041019,0,0,"–",78390.493892819868,174201.09753959972,"-","-","-",null,"-",174201.09753959972,20,871.00548769799855,0,0]
[null,10000,438000,40150,0,0,"NEIN",0,438000,40150,9.166666666666666E-2,25,61.83648396971904,85,85,372300,230217.229819264,8524.9662108441589,6022.5,12045,25602.533789155841,110090.89529337011,19580.033789155841,56782.097988551941,70,283526.02712408215,1.1304347826086956,320507.68283591891,1.5,213671.78855727927,21.367178855727929,0,0,142082.770180736,97988.117366024831,45,217751.3719244996,596.57910116301264,0,0,"–",97988.117366024831,217751.3719244996,"-","-","-",null,"-",217751.3719244996,20,1088.756859622498,0,0]
[null,12000,525600,48180,0,0,"NEIN",0,525600,48180,9.166666666666666E-2,25,61.83648396971904,85,85,446760,276260.67578311678,10229.959453012993,7227,14454,30723.040546987009,132109.07435204415,23496.040546987009,68138.517586262329,70,340231.23254889861,1.1304347826086956,384609.21940310276,1.5,256406.14626873517,21.367178855727932,0,0,170499.32421688322,117585.74083922981,45,261301.64630939957,715.89492139561526,0,0,"–",117585.74083922981,261301.64630939957,"-","-","-",null,"-",261301.64630939957,20,1306.5082315469979,0,0]
[null,14000,613200,56210,0,0,"NEIN",0,613200,56210,9.166666666666666E-2,25,61.83648396971904,85,85,521220,322304.12174696958,11934.952695181824,8431.5,16863,35843.547304818174,154127.25341071814,27412.047304818174,79494.937183972695,70,396936.43797371502,1.1304347826086956,448710.7559702865,1.5,299140.50398019102,21.367178855727929,0,0,198915.87825303042,137183.36431243477,45,304851.92069429951,835.21074162821787,0,0,"–",137183.36431243477,304851.92069429951,"-","-","-",null,"-",304851.92069429951,20,1524.2596034714975,0,0]
[null,16000,700800,64240,0,0,"NEIN",0,700800,64240,9.166666666666666E-2,25,61.83648396971904,85,85,595680,368347.56771082239,13639.945937350656,9636,19272,40964.054062649346,176145.43246939217,31328.054062649346,90851.356781683106,70,453641.64339853142,1.1304347826086956,512812.29253747029,1.5,341874.86169164686,21.367178855727929,0,0,227332.43228917761,156780.98778563974,45,348402.19507919945,954.52656186082038,0,0,"–",156780.98778563974,348402.19507919945,"-","-","-",null,"-",348402.19507919945,20,1742.0109753959971,0,0]
[null,18000,788400,72270,0,0,"NEIN",0,788400,72270,9.166666666666666E-2,25,61.83648396971904,85,85,670140,414391.01367467514,15344.939179519488,10840.5,21681,46084.56082048051,198163.61152806619,35244.06082048051,102207.77637939347,70,510346.84882334789,1.1304347826086956,576913.82910465414,1.5,384609.21940310276,21.367178855727932,0,0,255748.9863253248,176378.6112588447,45,391952.46946409933,1073.8423820934229,0,0,"–",176378.6112588447,391952.46946409933,"-","-","-",null,"-",391952.46946409933,20,1959.7623473204965,0,0]
[null,20000,876000,80300,0,0,"NEIN",0,876000,80300,9.166666666666666E-2,25,61.83648396971904,85,85,744600,460434.459638528,17049.932421688318,12045,24090,51205.067578311682,220181.79058674022,39160.067578311682,113564.19597710388,70,567052.05424816429,1.1304347826086956,641015.36567183782,1.5,427343.57711455855,21.367178855727929,0,0,284165.540361472,195976.23473204966,45,435502.74384899921,1193.1582023260253,0,0,"–",195976.23473204966,435502.74384899921,"-","-","-",null,"-",435502.74384899921,20,2177.5137192449961,0,0]
[null,22000,963600,88330,0,0,"NEIN",0,963600,88330,9.166666666666666E-2,25,61.83648396971904,85,85,819060,506477.90560238081,18754.92566385715,13249.5,26499,56325.574336142847,242199.96964541424,43076.074336142847,124920.61557481425,70,623757.25967298076,1.1304347826086956,705116.90223902161,1.5,470077.93482601439,21.367178855727929,0,0,312582.09439761919,215573.85820525463,45,479053.0182338992,1312.4740225586279,0,0,"–",215573.85820525463,479053.0182338992,"-","-","-",null,"-",479053.0182338992,20,2395.2650911694959,0,0]
[null,24000,1051200,96360,0,0,"NEIN",0,1051200,96360,9.166666666666666E-2,25,61.83648396971904,85,85,893520,552521.35156623356,20459.918906025985,14454,28908,61446.081093974019,264218.14870408829,46992.081093974019,136277.03517252466,70,680462.46509779722,1.1304347826086956,769218.43880620552,1.5,512812.29253747035,21.367178855727932,0,0,340998.64843376644,235171.48167845962,45,522603.29261879914,1431.7898427912305,0,0,"–",235171.48167845962,522603.29261879914,"-","-","-",null,"-",522603.29261879914,20,2613.0164630939958,0,0]
[null,26000,1138800,104390,0,0,"NEIN",0,1138800,104390,9.166666666666666E-2,25,61.83648396971904,85,85,967980,598564.79753008636,22164.912148194817,15658.5,31317,66566.587851805176,286236.32776276226,50908.087851805176,147633.454770235,70,737167.67052261357,1.1304347826086956,833319.9753733892,1.5,555546.65024892613,21.367178855727929,0,0,369415.20246991364,254769.10515166458,45,566153.56700369902,1551.1056630238329,0,0,"–",254769.10515166458,566153.56700369902,"-","-","-",null,"-",566153.56700369902,20,2830.7678350184951,0,0]
[null,28000,1226400,112420,0,0,"NEIN",0,1226400,112420,9.166666666666666E-2,25,61.83648396971904,85,85,1042440,644608.24349393917,23869.905390363649,16863,33726,71687.094609636348,308254.50682143628,54824.094609636348,158989.87436794539,70,793872.87594743003,1.1304347826086956,897421.51194057299,1.5,598281.00796038203,21.367178855727929,0,0,397831.75650606083,274366.72862486955,45,609703.84138859902,1670.4214832564357,0,0,"–",274366.72862486955,609703.84138859902,"-","-","-",null,"-",609703.84138859902,20,3048.519206942995,0,0]
[null,30000,1314000,120450,0,0,"NEIN",0,1314000,120450,9.166666666666666E-2,25,61.83648396971904,85,85,1116900,690651.68945779186,25574.89863253248,18067.5,36135,76807.60136746752,330272.68588011031,58740.10136746752,170346.29396565582,70,850578.08137224638,1.1304347826086956,961523.04850775667,1.5,641015.36567183782,21.367178855727929,0,0,426248.31054220803,293964.35209807451,45,653254.1157734989,1789.7373034890381,0,0,"–",293964.35209807451,653254.1157734989,"-","-","-",null,"-",653254.1157734989,20,3266.2705788674944,0,0]
[null,32000,1401600,128480,0,0,"NEIN",0,1401600,128480,9.166666666666666E-2,25,61.83648396971904,85,85,1191360,736695.13542164478,27279.891874701312,19272,38544,81928.108125298691,352290.86493878433,62656.108125298691,181702.71356336621,70,907283.28679706284,1.1304347826086956,1025624.5850749406,1.5,683749.72338329372,21.367178855727929,0,0,454664.86457835522,313561.97557127947,45,696804.39015839889,1909.0531237216408,0,0,"–",313561.97557127947,696804.39015839889,"-","-","-",null,"-",696804.39015839889,20,3484.0219507919942,0,0]
[null,34000,1489200,136510,0,0,"NEIN",0,1489200,136510,9.166666666666666E-2,25,61.83648396971904,85,85,1265820,782738.58138549759,28984.885116870144,20476.5,40953,87048.614883129863,374309.04399745842,66572.114883129863,193059.13316107661,70,963988.49222187954,1.1304347826086956,1089726.1216421246,1.5,726484.08109474974,21.367178855727932,0,0,483081.41861450241,333159.59904448444,45,740354.66454329877,2028.3689439542432,0,0,"–",333159.59904448444,740354.66454329877,"-","-","-",null,"-",740354.66454329877,20,3701.7733227164936,0,0]
[null,36000,1576800,144540,0,0,"NEIN",0,1576800,144540,9.166666666666666E-2,25,61.83648396971904,85,85,1340280,828782.02734935028,30689.878359038976,21681,43362,92169.121640961021,396327.22305613238,70488.121640961021,204415.55275878694,70,1020693.6976466958,1.1304347826086956,1153827.6582093083,1.5,769218.43880620552,21.367178855727932,0,0,511497.97265064961,352757.2225176894,45,783904.93892819865,2147.6847641868458,0,0,"–",352757.2225176894,783904.93892819865,"-","-","-",null,"-",783904.93892819865,20,3919.5246946409929,0,0]
[null,38000,1664400,152570,0,0,"NEIN",0,1664400,152570,9.166666666666666E-2,25,61.83648396971904,85,85,1414740,874825.4733132032,32394.871601207808,22885.5,45771,97289.628398792192,418345.40211480641,74404.128398792192,215771.97235649734,70,1077398.9030715122,1.1304347826086956,1217929.194776492,1.5,811952.79651766131,21.367178855727929,0,0,539914.5266867968,372354.84599089436,45,827455.21331309865,2267.0005844194484,0,0,"–",372354.84599089436,827455.21331309865,"-","-","-",null,"-",827455.21331309865,20,4137.2760665654932,0,0]
[null,40000,1752000,160600,0,0,"NEIN",0,1752000,160600,9.166666666666666E-2,25,61.83648396971904,85,85,1489200,920868.919277056,34099.864843376636,24090,48180,102410.13515662336,440363.58117348043,78320.135156623364,227128.39195420776,70,1134104.1084963286,1.1304347826086956,1282030.7313436756,1.5,854687.15422911709,21.367178855727929,0,0,568331.080722944,391952.46946409933,45,871005.48769799841,2386.3164046520506,0,0,"–",391952.46946409933,871005.48769799841,"-","-","-",null,"-",871005.48769799841,20,4355.0274384899922,0,0]
["Mittlere Belastung Kläranlage",{"$f":"'Dateneingabe und Ergebnisse'!F5","v":0},0,0,0,0,"NEIN",0,0,0,{"$error":"#DIV/0!"},25,61.83648396971904,85,85,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},0,{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},0,1.5,0,{"$error":"#DIV/0!"},0,0,0,0,45,0,0,0,0,"–",0,0,"-","-","-",null,"-",0,20,0,0,0]
["Bemessung Aerobie",{"$f":"'Dateneingabe und Ergebnisse'!F6","v":0},0,0,0,0,"NEIN",0,{"$f":"IF(G27=\"NEIN\",C27,C27*(1-H27/100))","v":0},{"$f":"B27*0.011*365+E27","v":0},{"$f":"J27/I27","v":{"$error":"#DIV/0!"}},25,61.83648396971904,85,{"$f":"(N27-H27)/(100-H27)*100","v":85},{"$f":"I27*O27/100","v":0},{"$f":"P27*M27/100","v":0},{"$f":"AH27*$R$2","v":0},{"$f":"J27*$S$2","v":0},{"$f":"J27*T29","v":0},{"$f":"J27-R27-T27+S27","v":0},{"$f":"U27*4.3","v":0},{"$f":"J27-R27-T27","v":0},{"$f":"W27*2.9","v":0},{"$f":"100-T27/J27*100","v":{"$error":"#DIV/0!"}},{"$f":"Q27+V27-X27","v":0},{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},{"$f":"Z27*AA27","v":0},null,null,null,null,null,{"$f":"P27*((100-M27)/100)","v":0},{"$f":"AH27/$AI$2","v":0},45,0,{"$f":"AK27/365","v":0},{"$f":"C27-I27","v":0},{"$f":"AM27/$AI$2","v":0},"–",0,0,"-","-","-",null,"-",0,20,0,0,{"$f":"AY27*AZ27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q6+AH6+AM6","v":74460},null,null,null,null,null,"Nges_ab/Nges_zu-1.AEVkA"]
["Hilfslinie Amortisationszeit",null,null,null,null,null,null,null,null,null,null,null,"Kontrolle CSB-Wirkungsgrad mit VK",{"$f":"N28/C6*100","v":85},null,null,null,null,null,0.3]
[null,"VARIANTE    F"]
[null,null,null,"N/oTS_ÜS =",{"$f":"'Fixe Parameter'!C6*'Fixe Parameter'!C5","v":8.6999999999999994E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TS/CSB (rückgerechnet)"]
[null,null,null,"N/oTS_PS =",{"$f":"'Fixe Parameter'!C7","v":0.06},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK36/AH36","v":1.1494252873563218}]
[null,"ZULAUFFRACHTEN",null,null,null,null,null,null,null,null,null,"SCHLAMMALTER","SAUERSTOFFBEDARF BELEBUNG",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENERGIE UND BELÜFTUNGSKOSTEN",null,null,null,null,"SCHLAMM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bemessung Faulung",null,null,null,null,null,null,null,"Faulgasnutzung"]
[null,"Einwohnerwerte CSB","CSB-Zulauffracht","N-Zulauffracht","N-Rückbelastung","Anteil N-Rückbelastung","VK","hVK","CSB-Zulauffracht Belebung","N-Zulauffracht Belebung","N:CSB","Schlammalter","CSB-OVC","CSB-Entfernung                 ( hges)","Hilfsgröße:                                    hBB bei hges                        mit Einfluss von hVK ","CSB-Entfernung","OVC","XorgN,BM","NO3-N,ab","Nges,ab","NO3-N (OVN)","OVN","NO3-N (OVD)","OVD","N-Entferunung IST","OV_GES","Sättigungsfaktor","erfαOC=","SAE","erforderliche Belüftungsenergie","Kontrolle über LINDNER","Strompreis","Belüftungskosten","CSBÜS","oTS-ÜS vor Faulung","oTS-Gehalt-ÜS","TS-ÜS vor Faulung","TS-ÜS vor Faulung","CSBPS","oTS-PS vor Faulung","oTS-Gehalt-PS","oTS-Schlamm vor Faulung","TS-Schlamm vor Faulung","spez. oTS-Gehalt nach Faulung","oTS-Schlamm nach Faulung","oTS-Reduktion in Faulung","CSB-Reduktion in Faulung","oTS-Reduktion durch  Faulung","TS-Schlamm nach Faulung_ALT ","TS-Gehalt","zu entsorgende Schlammfracht","spez. Schlamm-Entsorgungskosten","Schlammentsorgungs- kosten",null,"Schlammtrockensubstanz Zulauf Faulung","Schlammtrockensubstanz Zulauf Faulung","TS-Gehalt Zulauf Faulung","Schlammvolumenstrom Zulauf Faulung","Faulzeit","Bemessungsvolumen","anaerobe Raumbelastung",null,"Faulgasnutzung","Mittlere in Faulung abgebaute CSB-Fracht","spezifische Methanprotuktion ","CH4-Fracht","Energiegehalt Methan","elektr. Wirkungsgrad","spezifischer elektrischer Energiegehalt","potentielle Stromproduktion pro Jahr","Strompreis (oder Einspeistarif)","jährliche Einsp. aus Eingenstromproduktion"]
[null,"EW120","kg CSB/Jahr","kg N/Jahr","kg N/Jahr","%","-","%","kg CSB/Jahr","kg N/Jahr","-","t","%","%","%","kg CSB/Jahr","kg O2/Jahr","kg N/Jahr","kg N/Jahr","kg N/Jahr","kg N/Jahr","kg O2/Jahr","kg N/Jahr","kgO2/Jahr","%","kgO2/Jahr","-","kg O2/Jahr","kg O2/kWh","kWh/Jahr","kWh/(EW·a)","Euro/kWh","Euro/Jahr","kg CSB/Jahr","kg oTS/Jahr","%","kg TS/Jahr","kg TS/Tag","kg CSB/Jahr","kg oTS/Jahr","%","kg oTS/Jahr","kg TS/Jahr","g oTS/(EW120·d)","kg oTS/Jahr","kg oTS/Jahr","kg CSB/Jahr","%","kg TS/Jahr","%","t/Jahr","Euro/t","Euro/Jahr",null,"kg TS/Jahr","kg TS/d","%","m³/d","d","m³","kg oTS/(m³·d)",null,"–","kg CSB/ Jahr","Nm³ CH4/kg CSB","Nm³ CH4/Jahr","kWh/m³ CH4","%","kWh_elektr./m³CH4","kWh_elektr./a","Euro/kWh","Euro/a"]
["Berechnung allgemeine Kurvenschaar",2000,{"$f":"B36*0.12*365","v":87600},{"$f":"B36*0.011*365","v":8030},{"$f":"($E$31*AI36+$E$32*AN36)*AV36/100","v":650.10405727417879},{"$f":"E36/D36*100","v":8.0959409374119407},{"$f":"'Dateneingabe und Ergebnisse'!I10","v":"NEIN"},{"$f":"IF('Dateneingabe und Ergebnisse'!I11=\"–\",0,'Dateneingabe und Ergebnisse'!I11)","v":0},{"$f":"IF(G36=\"NEIN\",C36,C36*(1-H36/100))","v":87600},{"$f":"B36*0.011*365+E36","v":8680.1040572741786},{"$f":"J36/I36","v":9.9087945859294271E-2},{"$f":"'Dateneingabe und Ergebnisse'!I12","v":15},{"$f":"IF(G36=\"NEIN\",9.4345*LN(L36)+32.468-1,8.8152*LN(L36)+39.505-1)","v":57.017099622298801},{"$f":"'Dateneingabe und Ergebnisse'!I8","v":85},{"$f":"(N36-H36)/(100-H36)*100","v":85},{"$f":"I36*O36/100","v":74460},{"$f":"P36*M36/100","v":42454.932378763689},{"$f":"AH36*$R$2","v":1920.3040572741788},{"$f":"J36*$S$2","v":1302.0156085911267},{"$f":"J36*$T$2","v":2604.0312171822534},{"$f":"J36-R36-T36+S36","v":5457.7843914088726},{"$f":"U36*4.3","v":23468.472883058152},{"$f":"J36-R36-T36","v":4155.7687828177459},{"$f":"W36*2.9","v":12051.729470171462},{"$f":"100-T36/J36*100","v":70},{"$f":"Q36+V36-X36","v":53871.675791650378},{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},{"$f":"Z36*AA36","v":60898.416112300423},{"$f":"'Dateneingabe und Ergebnisse'!I15","v":1.5},{"$f":"AB36/AC36","v":40598.944074866951},{"$f":"AD36/B36","v":20.299472037433475},{"$f":"'Dateneingabe und Ergebnisse'!F16","v":0},{"$f":"AD36*AF36","v":0},{"$f":"P36*((100-M36)/100)","v":32005.067621236314},{"$f":"AH36/$AI$2","v":22072.460428438837},{"$f":"'Dateneingabe und Ergebnisse'!I18","v":60},{"$f":"AI36/AJ36*100","v":36787.434047398063},{"$f":"AK36/365","v":100.78749054081661},{"$f":"C36-I36","v":0},{"$f":"AM36/$AI$2","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I17","v":"–"},{"$f":"AI36+AN36","v":22072.460428438837},{"$f":"IF(AO36<>\"–\",AK36+AN36/AO36*100,AK36)","v":36787.434047398063},{"$f":"'Fixe Parameter'!C4","v":20},{"$f":"AR36/1000*B36*365","v":14600},{"$f":"+AP36-AS36","v":7472.460428438837},{"$f":"AT36*$AI$2","v":10835.067621236314},{"$f":"AT36/AP36*100","v":33.854225054181498},{"$f":"AQ36-AT36","v":29314.973618959226},{"$f":"'Dateneingabe und Ergebnisse'!I21","v":20},{"$f":"AW36/(AX36/100)/1000","v":146.5748680947961},{"$f":"'Dateneingabe und Ergebnisse'!I22","v":0},{"$f":"AY36*AZ36","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Dateneingabe und Ergebnisse'!I23","v":"NEIN"},{"$f":"AU36","v":10835.067621236314},0.35,{"$f":"BL36*BM36","v":3792.2736674327098},{"$f":"'Fixe Parameter'!C8","v":10},{"$f":"'Dateneingabe und Ergebnisse'!I24","v":0},{"$f":"BO36*BP36/100","v":0},{"$f":"IF(BK36=\"NEIN\",0,BN36*BQ36)","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I25","v":0},{"$f":"BR36*BS36","v":0}]
[null,4000,175200,16060,1300.2081145483576,{"$f":"E37/D37*100","v":8.0959409374119407},{"$f":"G36","v":"NEIN"},{"$f":"H36","v":0},175200,17360.208114548357,9.9087945859294271E-2,{"$f":"L36","v":15},57.017099622298801,{"$f":"N36","v":85},{"$f":"(N37-H37)/(100-H37)*100","v":85},{"$f":"I37*O37/100","v":148920},{"$f":"P37*M37/100","v":84909.864757527379},3840.6081145483577,{"$f":"J37*$S$2","v":2604.0312171822534},{"$f":"J37*$T$2","v":5208.0624343645068},{"$f":"J37-R37-T37+S37","v":10915.568782817745},{"$f":"U37*4.3","v":46936.945766116303},{"$f":"J37-R37-T37","v":8311.5375656354918},{"$f":"W37*2.9","v":24103.458940342924},{"$f":"100-T37/J37*100","v":70},107743.35158330076,{"$f":"AA36","v":1.1304347826086956},121796.83222460085,{"$f":"AC36","v":1.5},81197.888149733903,20.299472037433475,{"$f":"AF36","v":0},0,{"$f":"P37*((100-M37)/100)","v":64010.135242472628},44144.920856877674,{"$f":"AJ36","v":60},{"$f":"AI37/AJ37*100","v":73574.868094796126},{"$f":"AK37/365","v":201.57498108163321},0,0,{"$f":"AO36","v":"–"},44144.920856877674,{"$f":"IF(AO37<>\"–\",AK37+AN37/AO37*100,AK37)","v":73574.868094796126},{"$f":"AR36","v":20},29200,14944.920856877674,{"$f":"AT37*$AI$2","v":21670.135242472628},33.854225054181498,{"$f":"AQ37-AT37","v":58629.947237918452},{"$f":"AX36","v":20},293.1497361895922,{"$f":"AZ36","v":0},0,null,null,null,null,null,null,null,null,null,{"$f":"BK36","v":"NEIN"},21670.135242472628,{"$f":"BM36","v":0.35},{"$f":"BL37*BM37","v":7584.5473348654195},{"$f":"BO36","v":10},{"$f":"BP36","v":0},{"$f":"BO37*BP37/100","v":0},{"$f":"IF(BK37=\"NEIN\",0,BN37*BQ37)","v":0},{"$f":"BS36","v":0},{"$f":"BR37*BS37","v":0}]
[null,6000,262800,24090,1950.3121718225364,8.0959409374119407,"NEIN",0,262800,26040.312171822537,9.9087945859294285E-2,15,57.017099622298801,{"$f":"N37","v":85},85,223380,127364.79713629106,5760.912171822536,3906.0468257733805,7812.0936515467611,16373.35317422662,70405.418649174462,12467.306348453239,{"$f":"W38*2.9","v":36155.188410514391},70,161615.02737495114,1.1304347826086956,182695.24833690128,1.5,121796.83222460085,20.299472037433475,0,0,96015.202863708939,66217.381285316515,60,110362.3021421942,302.36247162244985,0,0,{"$f":"AO37","v":"–"},66217.381285316515,110362.3021421942,20,43800,22417.381285316515,32505.202863708946,33.854225054181498,{"$f":"AQ38-AT38","v":87944.920856877681},20,439.72460428438836,0,0,null,null,null,null,null,null,null,null,null,{"$f":"BK37","v":"NEIN"},32505.202863708946,{"$f":"BM37","v":0.35},{"$f":"BL38*BM38","v":11376.821002298131},{"$f":"BO37","v":10},{"$f":"BP37","v":0},{"$f":"BO38*BP38/100","v":0},0,{"$f":"BS37","v":0},{"$f":"BR38*BS38","v":0}]
[null,8000,350400,32120,2600.4162290967151,8.0959409374119407,"NEIN",0,350400,34720.416229096714,9.9087945859294271E-2,15,57.017099622298801,85,85,297840,169819.72951505476,7681.2162290967153,5208.0624343645068,10416.124868729014,21831.13756563549,93873.891532232607,16623.075131270984,{"$f":"W39*2.9","v":48206.917880685847},70,215486.70316660151,1.1304347826086956,243593.66444920169,1.5,162395.77629946781,20.299472037433475,0,0,128020.27048494526,88289.841713755348,60,147149.73618959225,403.14996216326642,0,0,"–",88289.841713755348,147149.73618959225,20,58400,29889.841713755348,43340.270484945257,33.854225054181498,117259.8944758369,20,586.29947237918441,0,0,null,null,null,null,null,null,null,null,null,"NEIN",43340.270484945257,0.35,15169.094669730839,10,0,0,0,0,0]
[null,10000,438000,40150,3250.5202863708928,8.0959409374119371,"NEIN",0,438000,43400.520286370891,9.9087945859294271E-2,15,57.017099622298801,85,85,372300,212274.66189381844,9601.5202863708928,6510.0780429556335,13020.156085911267,27288.921957044367,117342.36441529078,20778.843914088735,60258.647350857333,70,269358.37895825191,1.1304347826086956,304492.08056150214,1.5,202994.72037433475,20.299472037433475,0,0,160025.33810618156,110362.30214219418,60,183937.17023699029,503.937452704083,0,0,"–",110362.30214219418,183937.17023699029,20,73000,37362.302142194181,54175.33810618156,33.854225054181491,146574.86809479611,20,732.87434047398051,0,0,null,null,null,null,null,null,null,null,null,"NEIN",54175.33810618156,0.35,{"$f":"BL40*BM40","v":18961.368337163545},{"$f":"BO39","v":10},{"$f":"BP39","v":0},{"$f":"BO40*BP40/100","v":0},0,{"$f":"BS39","v":0},{"$f":"BR40*BS40","v":0}]
[null,12000,525600,48180,3900.6243436450727,8.0959409374119407,"NEIN",0,525600,52080.624343645075,9.9087945859294285E-2,15,57.017099622298801,85,85,446760,254729.59427258212,11521.824343645072,7812.0936515467611,15624.187303093522,32746.706348453241,140810.83729834892,24934.612696906479,72310.376821028782,70,323230.05474990228,1.1304347826086956,365390.49667380255,1.5,243593.66444920169,20.299472037433475,0,0,192030.40572741788,132434.76257063303,60,220724.60428438839,604.72494324489969,0,0,"–",132434.76257063303,220724.60428438839,20,87600,44834.762570633029,65010.405727417892,33.854225054181498,175889.84171375536,20,879.44920856877673,0,0,null,null,null,null,null,null,null,null,null,"NEIN",65010.405727417892,0.35,22753.642004596262,10,0,0,0,0,0]
[null,14000,613200,56210,4550.7284009192535,8.0959409374119442,"NEIN",0,613200,60760.728400919252,9.9087945859294285E-2,15,57.017099622298801,85,85,521220,297184.52665134583,13442.128400919251,9114.1092601378878,18228.218520275776,38204.490739862114,164279.31018140708,29090.381479724223,84362.106291200238,70,377101.73054155265,1.1304347826086956,426288.91278610297,1.5,284192.60852406867,20.299472037433475,0,0,224035.4733486542,154507.22299907188,60,257512.03833178646,705.51243378571633,0,0,"–",154507.22299907188,257512.03833178646,20,102200,52307.222999071877,75845.473348654225,33.854225054181505,205204.81533271458,20,1026.0240766635729,0,0,null,null,null,null,null,null,null,null,null,"NEIN",75845.473348654225,0.35,26545.915672028976,10,0,0,0,0,0]
[null,16000,700800,64240,5200.8324581934303,8.0959409374119407,"NEIN",0,700800,69440.832458193428,9.9087945859294271E-2,15,57.017099622298801,85,85,595680,339639.45903010952,15362.432458193431,10416.124868729014,20832.249737458027,43662.275131270981,187747.78306446521,33246.150262541967,96413.835761371694,70,430973.40633320302,1.1304347826086956,487187.32889840339,1.5,324791.55259893561,20.299472037433475,0,0,256040.54096989051,176579.6834275107,60,294299.4723791845,806.29992432653285,0,0,"–",176579.6834275107,294299.4723791845,20,116800,59779.683427510696,86680.540969890513,33.854225054181498,234519.78895167381,20,1172.5989447583688,0,0,null,null,null,null,null,null,null,null,null,"NEIN",86680.540969890513,0.35,30338.189339461678,10,0,0,0,0,0]
[null,18000,788400,72270,5850.9365154676079,8.0959409374119389,"NEIN",0,788400,78120.936515467605,9.9087945859294271E-2,15,57.017099622298801,85,85,670140,382094.3914088732,17282.736515467608,11718.140477320141,23436.280954640282,49120.059522679854,211216.25594752337,37401.919045359711,108465.56523154317,70,484845.08212485339,1.1304347826086956,548085.7450107038,1.5,365390.49667380255,20.299472037433475,0,0,288045.6085911268,198652.14385594951,60,331086.90642658254,907.08741486734948,0,0,"–",198652.14385594951,331086.90642658254,20,131400,67252.143855949515,97515.608591126787,33.854225054181491,263834.76257063303,20,1319.1738128531649,0,0,null,null,null,null,null,null,null,null,null,"NEIN",97515.608591126787,0.35,34130.463006894373,10,0,0,0,0,0]
[null,20000,876000,80300,6501.0405727417856,8.0959409374119371,"NEIN",0,876000,86801.040572741782,9.9087945859294271E-2,15,57.017099622298801,85,85,744600,424549.32378763688,19203.040572741786,13020.156085911267,26040.312171822534,54577.843914088735,234684.72883058156,41557.68782817747,120517.29470171467,70,538716.75791650382,1.1304347826086956,608984.16112300428,1.5,405989.4407486695,20.299472037433475,0,0,320050.67621236312,220724.60428438836,60,367874.34047398058,1007.874905408166,0,0,"–",220724.60428438836,367874.34047398058,20,146000,74724.604284388362,108350.67621236312,33.854225054181491,293149.73618959222,20,1465.748680947961,0,0,null,null,null,null,null,null,null,null,null,"NEIN",108350.67621236312,0.35,37922.73667432709,10,0,0,0,0,0]
[null,22000,963600,88330,7151.1446300159678,8.0959409374119407,"NEIN",0,963600,95481.144630015973,9.9087945859294285E-2,15,57.017099622298801,85,85,819060,467004.25616640056,21123.344630015967,14322.171694502396,28644.343389004793,60035.628305497608,258153.20171363972,45713.456610995214,132569.02417188612,70,592588.43370815413,1.1304347826086956,669882.57723530463,1.5,446588.38482353644,20.299472037433475,0,0,352055.74383359944,242797.06471282721,60,404661.77452137868,1108.6623959489827,0,0,"–",242797.06471282721,404661.77452137868,20,160600,82197.06471282721,119185.74383359945,33.854225054181498,322464.70980855147,20,1612.3235490427573,0,0,null,null,null,null,null,null,null,null,null,"NEIN",119185.74383359945,0.35,41715.010341759807,10,0,0,0,0,0]
[null,24000,1051200,96360,7801.2486872901454,8.0959409374119407,"NEIN",0,1051200,104161.24868729015,9.9087945859294285E-2,15,57.017099622298801,85,85,893520,509459.18854516424,23043.648687290144,15624.187303093522,31248.374606187044,65493.412696906482,281621.67459669785,49869.225393812958,144620.75364205756,70,646460.10949980456,1.1304347826086956,730780.99334760511,1.5,487187.32889840339,20.299472037433475,0,0,384060.81145483576,264869.52514126606,60,441449.20856877678,1209.4498864897994,0,0,"–",264869.52514126606,441449.20856877678,20,175200,89669.525141266058,130020.81145483578,33.854225054181498,351779.68342751072,20,1758.8984171375535,0,0,null,null,null,null,null,null,null,null,null,"NEIN",130020.81145483578,0.35,45507.284009192525,10,0,0,0,0,0]
[null,26000,1138800,104390,8451.3527445643267,8.0959409374119424,"NEIN",0,1138800,112841.35274456433,9.9087945859294285E-2,15,57.017099622298801,85,85,967980,551914.12092392799,24963.952744564325,16926.20291168465,33852.405823369299,70951.197088315341,305090.14747975598,54024.994176630695,156672.48311222901,70,700331.78529145499,1.1304347826086956,791679.40945990558,1.5,527786.27297327039,20.299472037433475,0,0,416065.87907607207,286941.98556970491,60,478236.64261617488,1310.237377030616,0,0,"–",286941.98556970491,478236.64261617488,20,189800,97141.985569704906,140855.8790760721,33.854225054181505,381094.65704646998,20,1905.4732852323498,0,0,null,null,null,null,null,null,null,null,null,"NEIN",140855.8790760721,0.35,49299.557676625234,10,0,0,0,0,0]
[null,28000,1226400,112420,9101.4568018385071,8.0959409374119442,"NEIN",0,1226400,121521.4568018385,9.9087945859294285E-2,15,57.017099622298801,85,85,1042440,594369.05330269167,26884.256801838503,18228.218520275776,36456.437040551551,76408.981479724229,328558.62036281417,58180.762959448446,168724.21258240048,70,754203.4610831053,1.1304347826086956,852577.82557220594,1.5,568385.21704813733,20.299472037433475,0,0,448070.94669730839,309014.44599814375,60,515024.07666357292,1411.0248675714327,0,0,"–",309014.44599814375,515024.07666357292,20,204400,104614.44599814375,151690.94669730845,33.854225054181505,410409.63066542917,20,2052.0481533271459,0,0,null,null,null,null,null,null,null,null,null,"NEIN",151690.94669730845,0.35,53091.831344057951,10,0,0,0,0,0]
[null,30000,1314000,120450,9751.5608591126802,8.0959409374119389,"NEIN",0,1314000,130201.56085911268,9.9087945859294271E-2,15,57.017099622298801,85,85,1116900,636823.98568145523,28804.56085911268,19530.234128866901,39060.468257733803,81866.765871133102,352027.0932458723,62336.531742266197,180775.94205257198,70,808075.13687475561,1.1304347826086956,913476.2416845063,1.5,608984.16112300416,20.299472037433471,0,0,480076.01431854471,331086.90642658254,60,551811.51071097096,1511.8123581122493,0,0,"–",331086.90642658254,551811.51071097096,20,219000,112086.90642658254,162526.01431854468,33.854225054181491,439724.60428438842,20,2198.6230214219418,0,0,null,null,null,null,null,null,null,null,null,"NEIN",162526.01431854468,0.35,56884.105011490632,10,0,0,0,0,0]
[null,32000,1401600,128480,10401.664916386861,8.0959409374119407,"NEIN",0,1401600,138881.66491638686,9.9087945859294271E-2,15,57.017099622298801,85,85,1191360,679278.91806021903,30724.864916386861,20832.249737458027,41664.499474916054,87324.550262541961,375495.56612893043,66492.300525083934,192827.67152274339,70,861946.81266640604,1.1304347826086956,974374.65779680677,1.5,649583.10519787122,20.299472037433475,0,0,512081.08193978103,353159.36685502139,60,588598.94475836901,1612.5998486530657,0,0,"–",353159.36685502139,588598.94475836901,20,233600,119559.36685502139,173361.08193978103,33.854225054181498,469039.57790334761,20,2345.1978895167376,0,0,null,null,null,null,null,null,null,null,null,"NEIN",173361.08193978103,0.35,60676.378678923356,10,0,0,0,0,0]
[null,34000,1489200,136510,11051.768973661035,8.0959409374119371,"NEIN",0,1489200,147561.76897366103,9.9087945859294271E-2,15,57.017099622298801,85,85,1265820,721733.85043898271,32645.168973661035,22134.265346049153,44268.530692098306,92782.334653950849,398964.03901198861,70648.069307901693,204879.40099291489,70,915818.48845805635,1.1304347826086956,1035273.0739091071,1.5,690182.04927273805,20.299472037433471,0,0,544086.14956101729,375231.82728346018,60,625386.37880576693,1713.3873391938821,0,0,"–",375231.82728346018,625386.37880576693,20,248200,127031.82728346018,184196.14956101726,33.854225054181484,498354.55152230675,20,2491.7727576115335,0,0,null,null,null,null,null,null,null,null,null,"NEIN",184196.14956101726,0.35,64468.652346356037,10,0,0,0,0,0]
[null,36000,1576800,144540,11701.873030935216,8.0959409374119389,"NEIN",0,1576800,156241.87303093521,9.9087945859294271E-2,15,57.017099622298801,85,85,1340280,764188.7828177464,34565.473030935216,23436.280954640282,46872.561909280565,98240.119045359708,422432.51189504674,74803.838090719422,216931.13046308633,70,969690.16424970678,1.1304347826086956,1096171.4900214076,1.5,730780.99334760511,20.299472037433475,0,0,576091.2171822536,397304.28771189903,60,662173.81285316509,1814.174829734699,0,0,"–",397304.28771189903,662173.81285316509,20,262800,134504.28771189903,195031.21718225357,33.854225054181491,527669.52514126606,20,2638.3476257063298,0,0,null,null,null,null,null,null,null,null,null,"NEIN",195031.21718225357,0.35,68260.926013788747,10,0,0,0,0,0]
[null,38000,1664400,152570,12351.977088209393,8.0959409374119371,"NEIN",0,1664400,164921.97708820939,9.9087945859294271E-2,15,57.017099622298801,85,85,1414740,806643.71519651008,36485.777088209397,24738.296563231408,49476.593126462816,103697.90343676857,445900.98477810482,78959.606873537166,228982.85993325777,70,1023561.8400413571,1.1304347826086956,1157069.9061337078,1.5,771379.93742247194,20.299472037433471,0,0,608096.28480348992,419376.74814033788,60,698961.24690056313,1914.9623202755154,0,0,"–",419376.74814033788,698961.24690056313,20,277400,141976.74814033788,205866.28480348992,33.854225054181491,556984.49876022525,20,2784.9224938011262,0,0,null,null,null,null,null,null,null,null,null,"NEIN",205866.28480348992,0.35,72053.199681221464,10,0,0,0,0,0]
[null,40000,1752000,160600,13002.081145483571,8.0959409374119371,"NEIN",0,1752000,173602.08114548356,9.9087945859294271E-2,15,57.017099622298801,85,85,1489200,849098.64757527376,38406.081145483571,26040.312171822534,52080.624343645068,109155.68782817747,469369.45766116312,83115.37565635494,241034.58940342933,70,1077433.5158330076,1.1304347826086956,1217968.3222460086,1.5,811978.881497339,20.299472037433475,0,0,640101.35242472624,441449.20856877672,60,735748.68094796117,2015.749810816332,0,0,"–",441449.20856877672,735748.68094796117,20,292000,149449.20856877672,216701.35242472624,33.854225054181491,586299.47237918444,20,2931.497361895922,0,0,null,null,null,null,null,null,null,null,null,"NEIN",216701.35242472624,0.35,75845.473348654181,10,0,0,0,0,0]
["Mittlere Belastung Kläranlage",{"$f":"'Dateneingabe und Ergebnisse'!I5","v":0},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"NEIN",0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},15,57.017099622298801,85,85,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1.1304347826086956,{"$error":"#DIV/0!"},1.5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,60,0,0,0,0,{"$f":"AO55","v":"–"},0,0,20,0,0,0,{"$error":"#DIV/0!"},0,20,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"BK55","v":"NEIN"},0,{"$f":"BM55","v":0.35},{"$f":"BL56*BM56","v":0},{"$f":"BO55","v":10},{"$f":"BP55","v":0},{"$f":"BO56*BP56/100","v":0},0,{"$f":"BS55","v":0},{"$f":"BR56*BS56","v":0}]
["Mittlere Belastung bei Ausnützung Überkapazität",{"$f":"B59*(B56/B58)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"E57/D57*100","v":{"$error":"#DIV/0!"}},"NEIN",0,{"$f":"IF(G57=\"NEIN\",C57,C57*(1-H57/100))","v":{"$error":"#DIV/0!"}},{"$f":"B57*0.011*365+E57","v":{"$error":"#DIV/0!"}},{"$f":"J57/I57","v":{"$error":"#DIV/0!"}},15,{"$f":"IF(G57=\"NEIN\",9.4345*LN(L57)+32.468-1,8.8152*LN(L57)+39.505-1)","v":57.017099622298801},85,{"$f":"(N57-H57)/(100-H57)*100","v":85},{"$f":"I57*O57/100","v":{"$error":"#DIV/0!"}},{"$f":"P57*M57/100","v":{"$error":"#DIV/0!"}},{"$f":"AH57*$R$2","v":{"$error":"#DIV/0!"}},{"$f":"J57*$S$2","v":{"$error":"#DIV/0!"}},{"$f":"J57*$T$2","v":{"$error":"#DIV/0!"}},{"$f":"J57-R57-T57+S57","v":{"$error":"#DIV/0!"}},{"$f":"U57*4.3","v":{"$error":"#DIV/0!"}},{"$f":"J57-R57-T57","v":{"$error":"#DIV/0!"}},{"$f":"W57*2.9","v":{"$error":"#DIV/0!"}},{"$f":"100-T57/J57*100","v":{"$error":"#DIV/0!"}},{"$f":"Q57+V57-X57","v":{"$error":"#DIV/0!"}},1.1304347826086956,{"$f":"Z57*AA57","v":{"$error":"#DIV/0!"}},1.5,{"$f":"AB57/AC57","v":{"$error":"#DIV/0!"}},{"$f":"AD57/B57","v":{"$error":"#DIV/0!"}},0,{"$f":"AD57*AF57","v":{"$error":"#DIV/0!"}},{"$f":"P57*((100-M57)/100)","v":{"$error":"#DIV/0!"}},{"$f":"AH57/$AI$2","v":{"$error":"#DIV/0!"}},60,{"$error":"#DIV/0!"},{"$f":"AK57/365","v":{"$error":"#DIV/0!"}},{"$f":"C57-I57","v":{"$error":"#DIV/0!"}},{"$f":"AM57/$AI$2","v":{"$error":"#DIV/0!"}},{"$f":"AO55","v":"–"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},20,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},20,{"$error":"#DIV/0!"},0,{"$f":"AY57*AZ57","v":{"$error":"#DIV/0!"}}]
["Bemessung Anaerobie",{"$f":"'Dateneingabe und Ergebnisse'!I7","v":0},{"$f":"B58*0.12*365","v":0},{"$f":"B58*0.011*365","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G56","v":"NEIN"},{"$f":"H56","v":0},0,{"$error":"#DIV/0!"},{"$f":"J58/I58","v":{"$error":"#DIV/0!"}},{"$f":"L56","v":15},{"$f":"IF(G58=\"NEIN\",9.4345*LN(L58)+32.468-1,8.8152*LN(L58)+39.505-1)","v":57.017099622298801},{"$f":"N56","v":85},85,0,{"$f":"P58*M58/100","v":0},{"$f":"AH58*$R$2","v":0},{"$f":"J58*$S$2","v":{"$error":"#DIV/0!"}},{"$f":"J58*$T$2","v":{"$error":"#DIV/0!"}},{"$f":"J58-R58-T58+S58","v":{"$error":"#DIV/0!"}},{"$f":"U58*4.3","v":{"$error":"#DIV/0!"}},{"$f":"J58-R58-T58","v":{"$error":"#DIV/0!"}},{"$f":"W58*2.9","v":{"$error":"#DIV/0!"}},{"$f":"100-T58/J58*100","v":{"$error":"#DIV/0!"}},{"$f":"Q58+V58-X58","v":{"$error":"#DIV/0!"}},{"$f":"AA56","v":1.1304347826086956},{"$f":"Z58*AA58","v":{"$error":"#DIV/0!"}},{"$f":"AC56","v":1.5},{"$f":"AB58/AC58","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"AF56","v":0},{"$f":"AD58*AF58","v":{"$error":"#DIV/0!"}},{"$f":"P58*((100-M58)/100)","v":0},0,{"$f":"AJ56","v":60},0,0,{"$f":"C58-I58","v":0},0,{"$f":"AO57","v":"–"},0,0,{"$f":"AR56","v":20},0,0,0,{"$error":"#DIV/0!"},0,{"$f":"AX56","v":20},0,{"$f":"AZ56","v":0},{"$f":"AY58*AZ58","v":0},null,{"$f":"AQ58","v":0},{"$f":"BC58/365","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I19","v":3},{"$f":"BD58/(BE58/100)/1000","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I20","v":25},{"$f":"BF58*BG58","v":0}]
["Bemessung Anaerobie_NEU",{"$f":"B58+B62*(B58/B60)","v":{"$error":"#DIV/0!"}},{"$f":"B59*0.12*365","v":{"$error":"#DIV/0!"}},{"$f":"B59*0.011*365","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"E59/D59*100","v":{"$error":"#DIV/0!"}},"NEIN",0,{"$f":"IF(G59=\"NEIN\",C59,C59*(1-H59/100))","v":{"$error":"#DIV/0!"}},{"$f":"B59*0.011*365+E59","v":{"$error":"#DIV/0!"}},{"$f":"J59/I59","v":{"$error":"#DIV/0!"}},15,{"$f":"IF(G59=\"NEIN\",9.4345*LN(L59)+32.468-1,8.8152*LN(L59)+39.505-1)","v":57.017099622298801},85,{"$f":"(N59-H59)/(100-H59)*100","v":85},{"$f":"I59*O59/100","v":{"$error":"#DIV/0!"}},{"$f":"P59*M59/100","v":{"$error":"#DIV/0!"}},{"$f":"AH59*$R$2","v":{"$error":"#DIV/0!"}},{"$f":"J59*$S$2","v":{"$error":"#DIV/0!"}},{"$f":"J59*$T$2","v":{"$error":"#DIV/0!"}},{"$f":"J59-R59-T59+S59","v":{"$error":"#DIV/0!"}},{"$f":"U59*4.3","v":{"$error":"#DIV/0!"}},{"$f":"J59-R59-T59","v":{"$error":"#DIV/0!"}},{"$f":"W59*2.9","v":{"$error":"#DIV/0!"}},{"$f":"100-T59/J59*100","v":{"$error":"#DIV/0!"}},{"$f":"Q59+V59-X59","v":{"$error":"#DIV/0!"}},1.1304347826086956,{"$f":"Z59*AA59","v":{"$error":"#DIV/0!"}},1.5,{"$f":"AB59/AC59","v":{"$error":"#DIV/0!"}},{"$f":"AD59/B59","v":{"$error":"#DIV/0!"}},0,{"$f":"AD59*AF59","v":{"$error":"#DIV/0!"}},{"$f":"P59*((100-M59)/100)","v":{"$error":"#DIV/0!"}},{"$f":"AH59/$AI$2","v":{"$error":"#DIV/0!"}},60,{"$error":"#DIV/0!"},{"$f":"AK59/365","v":{"$error":"#DIV/0!"}},{"$f":"C59-I59","v":{"$error":"#DIV/0!"}},{"$f":"AM59/$AI$2","v":{"$error":"#DIV/0!"}},{"$f":"AO58","v":"–"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},20,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},20,{"$error":"#DIV/0!"},0,{"$f":"AY59*AZ59","v":{"$error":"#DIV/0!"}},null,{"$f":"AQ59","v":{"$error":"#DIV/0!"}},{"$f":"BC59/365","v":{"$error":"#DIV/0!"}},{"$f":"BE58","v":3},{"$f":"BD59/(BE59/100)/1000","v":{"$error":"#DIV/0!"}},{"$f":"BG58","v":25},{"$f":"BF59*BG59","v":{"$error":"#DIV/0!"}}]
["Bemessung Aerobie",{"$f":"'Dateneingabe und Ergebnisse'!I6","v":0},{"$f":"B60*0.12*365","v":0},{"$f":"B60*0.011*365","v":0},{"$f":"E58","v":{"$error":"#DIV/0!"}},{"$f":"F58","v":{"$error":"#DIV/0!"}},{"$f":"G58","v":"NEIN"},{"$f":"H58","v":0},0,{"$error":"#DIV/0!"},{"$f":"J60/I60","v":{"$error":"#DIV/0!"}},{"$f":"L58","v":15},{"$f":"IF(G60=\"NEIN\",9.4345*LN(L60)+32.468-1,8.8152*LN(L60)+39.505-1)","v":57.017099622298801},85,85,0,{"$f":"P60*M60/100","v":0},{"$f":"AH60*$R$2","v":0},{"$f":"J60*$S$2","v":{"$error":"#DIV/0!"}},{"$f":"J60*$T$64","v":{"$error":"#DIV/0!"}},{"$f":"J60-R60-T60+S60","v":{"$error":"#DIV/0!"}},{"$f":"U60*4.3","v":{"$error":"#DIV/0!"}},{"$f":"J60-R60-T60","v":{"$error":"#DIV/0!"}},{"$f":"W60*2.9","v":{"$error":"#DIV/0!"}},{"$f":"100-T60/J60*100","v":{"$error":"#DIV/0!"}},{"$f":"Q60+V60-X60","v":{"$error":"#DIV/0!"}},{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},{"$f":"Z60*AA60","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"P60*((100-M60)/100)","v":0},0,{"$f":"AJ58","v":60},0,0,{"$f":"C60-I60","v":0},0,{"$f":"AO59","v":"–"},0,0,{"$f":"AR58","v":20},{"$f":"AS58","v":0},{"$f":"AT58","v":0},0,{"$f":"AV58","v":{"$error":"#DIV/0!"}},0,{"$f":"AX58","v":20},0,{"$f":"AZ58","v":0},{"$f":"AY60*AZ60","v":0}]
["Kontrolle Rückrechnung",114.68383087233155,{"$f":"B61*0.12*365","v":5023.1517922081221},null,null,null,"NEIN",0,{"$f":"IF(G61=\"NEIN\",C61,C61*(1-H61/100))","v":5023.1517922081221},{"$f":"B61*0.011*365+E61","v":460.4555809524112},{"$f":"J61/I61","v":9.1666666666666674E-2},15,{"$f":"IF(G61=\"NEIN\",9.4345*LN(L61)+32.468-1,8.8152*LN(L61)+39.505-1)","v":57.017099622298801},85,{"$f":"(N61-H61)/(100-H61)*100","v":85},{"$f":"I61*O61/100","v":4269.6790233769034},{"$f":"P61*M61/100","v":2434.4471423112036},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P61*((100-M61)/100)","v":1835.2318810657},{"$f":"AH61/$AI$2","v":1265.6771593556552},60,2109.4619322594253,{"$f":"AK61/365","v":5.7793477596148639}]
[" Überkapazität Aerobie (Rückrechnung)",{"$f":"C62/0.12/365","v":29765.598725618329},{"$f":"I62/(1-H61/100)","v":1303733.2241820828},null,null,null,null,null,{"$f":"P62/O62*100","v":1303733.2241820828},null,null,null,{"$f":"M60","v":57.017099622298801},null,{"$f":"O60","v":85},{"$f":"AH62+Q62","v":1108173.2405547705},{"$f":"AH62/(100-M62)*M62","v":631848.24055477034},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI62*AI2","v":476325},{"$f":"AK62*AJ62/100","v":328500},{"$f":"AJ60","v":60},{"$f":"AL62*365","v":547500},{"$f":"'Dateneingabe und Ergebnisse'!I37*'Dateneingabe und Ergebnisse'!I13/'Dateneingabe und Ergebnisse'!I12","v":1500}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q41+AH41+AM41","v":446760},null,null,null,null,null,"Nges_ab/Nges_zu-1.AEVkA"]
[null,"Fall",35000,30000,25000,null,null,null,null,null,null,null,"Kontrolle CSB-Wirkungsgrad mit VK",{"$f":"N63/C41*100","v":85},null,null,null,null,null,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"–"]
[null,{"$f":"B62","v":29765.598725618329},25427.252215835997,21790.377895244001,18159.677180313596]
[null,{"$f":"B58/B60","v":{"$error":"#DIV/0!"}},0.68571428571428572,0.8,0.96]
[null,{"$f":"B65*B66","v":{"$error":"#DIV/0!"}},17435.83009085897,17432.302316195201,17433.290093101052]

{"sheet":"Betriebskostenersparnis","index":5,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,1,0,4],[3,0,22,0]]}
[null,"Reduktion (+) / Erhöhung (-) laufender Kosten"]
[null,"Einwohnerwerte","Belüftungskostenersparnis","Schlammentsorgungskostenersparnis","Betriebskostenersparnis","jährliche Einsp. aus Eingenstromproduktion","etwaige Erhöhung durch  zusätzliche Personalkosten","etwaige Erhöhung durch  zusätliche Betriebskosten","Gesamtreduktion"]
[null,"EW","Euro/Jahr","Euro/Jahr","Euro/Jahr","Euro/Jahr","Euro/Jahr","Euro/Jahr","Euro/Jahr"]
["Berechnung allgemeine Kurvenschaar",2000,{"$f":"Bemessung!AG6-Bemessung!AG36","v":0},{"$f":"Bemessung!BA6-Bemessung!BA36","v":0},{"$f":"D4+C4","v":0},{"$f":"Bemessung!BT36","v":0},{"$f":"G24","v":0},{"$f":"$H$24*(B4/$B$24)","v":{"$error":"#DIV/0!"}},{"$f":"(IF(E4+F4-G4-H4<0,0,E4+F4-G4-H4))","v":{"$error":"#DIV/0!"}}]
[null,4000,{"$f":"Bemessung!AG7-Bemessung!AG37","v":0},{"$f":"Bemessung!BA7-Bemessung!BA37","v":0},0,{"$f":"Bemessung!BT37","v":0},{"$f":"G4","v":0},{"$f":"$H$24*(B5/$B$24)","v":{"$error":"#DIV/0!"}},{"$f":"(IF(E5+F5-G5-H5<0,0,E5+F5-G5-H5))","v":{"$error":"#DIV/0!"}}]
[null,6000,{"$f":"Bemessung!AG8-Bemessung!AG38","v":0},{"$f":"Bemessung!BA8-Bemessung!BA38","v":0},0,{"$f":"Bemessung!BT38","v":0},{"$f":"G5","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,8000,{"$f":"Bemessung!AG9-Bemessung!AG39","v":0},{"$f":"Bemessung!BA9-Bemessung!BA39","v":0},0,{"$f":"Bemessung!BT39","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,10000,{"$f":"Bemessung!AG10-Bemessung!AG40","v":0},{"$f":"Bemessung!BA10-Bemessung!BA40","v":0},0,{"$f":"Bemessung!BT40","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,12000,{"$f":"Bemessung!AG11-Bemessung!AG41","v":0},{"$f":"Bemessung!BA11-Bemessung!BA41","v":0},0,{"$f":"Bemessung!BT41","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,14000,{"$f":"Bemessung!AG12-Bemessung!AG42","v":0},{"$f":"Bemessung!BA12-Bemessung!BA42","v":0},0,{"$f":"Bemessung!BT42","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,16000,{"$f":"Bemessung!AG13-Bemessung!AG43","v":0},{"$f":"Bemessung!BA13-Bemessung!BA43","v":0},0,{"$f":"Bemessung!BT43","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,18000,{"$f":"Bemessung!AG14-Bemessung!AG44","v":0},{"$f":"Bemessung!BA14-Bemessung!BA44","v":0},0,{"$f":"Bemessung!BT44","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,20000,{"$f":"Bemessung!AG15-Bemessung!AG45","v":0},{"$f":"Bemessung!BA15-Bemessung!BA45","v":0},0,{"$f":"Bemessung!BT45","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,22000,{"$f":"Bemessung!AG16-Bemessung!AG46","v":0},{"$f":"Bemessung!BA16-Bemessung!BA46","v":0},0,{"$f":"Bemessung!BT46","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,24000,{"$f":"Bemessung!AG17-Bemessung!AG47","v":0},{"$f":"Bemessung!BA17-Bemessung!BA47","v":0},0,{"$f":"Bemessung!BT47","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,26000,{"$f":"Bemessung!AG18-Bemessung!AG48","v":0},{"$f":"Bemessung!BA18-Bemessung!BA48","v":0},0,{"$f":"Bemessung!BT48","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,28000,{"$f":"Bemessung!AG19-Bemessung!AG49","v":0},{"$f":"Bemessung!BA19-Bemessung!BA49","v":0},0,{"$f":"Bemessung!BT49","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,30000,{"$f":"Bemessung!AG20-Bemessung!AG50","v":0},{"$f":"Bemessung!BA20-Bemessung!BA50","v":0},0,{"$f":"Bemessung!BT50","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,32000,{"$f":"Bemessung!AG21-Bemessung!AG51","v":0},{"$f":"Bemessung!BA21-Bemessung!BA51","v":0},0,{"$f":"Bemessung!BT51","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,34000,{"$f":"Bemessung!AG22-Bemessung!AG52","v":0},{"$f":"Bemessung!BA22-Bemessung!BA52","v":0},0,{"$f":"Bemessung!BT52","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,36000,{"$f":"Bemessung!AG23-Bemessung!AG53","v":0},{"$f":"Bemessung!BA23-Bemessung!BA53","v":0},0,{"$f":"Bemessung!BT53","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,38000,{"$f":"Bemessung!AG24-Bemessung!AG54","v":0},{"$f":"Bemessung!BA24-Bemessung!BA54","v":0},0,{"$f":"Bemessung!BT54","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,40000,{"$f":"Bemessung!AG25-Bemessung!AG55","v":0},{"$f":"Bemessung!BA25-Bemessung!BA55","v":0},0,{"$f":"Bemessung!BT55","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Ersparnis bei derzeitiger (mittlerer) Belastung",{"$f":"'Dateneingabe und Ergebnisse'!F5","v":0},{"$f":"Bemessung!AG26-Bemessung!AG56","v":{"$error":"#DIV/0!"}},{"$f":"Bemessung!BA26-Bemessung!BA56","v":0},{"$error":"#DIV/0!"},{"$f":"Bemessung!BT56","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I68","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I60","v":0},{"$f":"E24+F24-G24","v":{"$error":"#DIV/0!"}}]

{"sheet":"Berechnung Grafik_Statisch","index":6,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":true,"merged":[[2,2,2,12],[0,2,0,12],[33,2,33,12]]}
["Berechnung statische                                             Armotisationszeit","ALLGEMEIN","Investitionskostendifferenz"]
["Betriebskostenänderung","Einwohnerwerte",0,{"$f":"200000","v":200000},{"$f":"D2+200000","v":400000},{"$f":"E2+200000","v":600000},800000,1000000,1200000,1400000,1600000,1800000,2000000]
["Euro/Jahr","EW","Amortisationszeit"]
[{"$f":"Betriebskostenersparnis!I4","v":{"$error":"#DIV/0!"}},2000,{"$f":"IF(C$2/$A4>50,#N/A,C$2/$A4)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D$2/$A4>50,#N/A,D$2/$A4)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E$2/$A4>50,#N/A,E$2/$A4)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I5","v":{"$error":"#DIV/0!"}},4000,{"$f":"IF(C$2/$A5>50,#N/A,C$2/$A5)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D$2/$A5>50,#N/A,D$2/$A5)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I6","v":{"$error":"#DIV/0!"}},6000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I7","v":{"$error":"#DIV/0!"}},8000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I8","v":{"$error":"#DIV/0!"}},10000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I9","v":{"$error":"#DIV/0!"}},12000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I10","v":{"$error":"#DIV/0!"}},14000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I11","v":{"$error":"#DIV/0!"}},16000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I12","v":{"$error":"#DIV/0!"}},18000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I13","v":{"$error":"#DIV/0!"}},20000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I14","v":{"$error":"#DIV/0!"}},22000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I15","v":{"$error":"#DIV/0!"}},24000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I16","v":{"$error":"#DIV/0!"}},26000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I17","v":{"$error":"#DIV/0!"}},28000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I18","v":{"$error":"#DIV/0!"}},30000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I19","v":{"$error":"#DIV/0!"}},32000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I20","v":{"$error":"#DIV/0!"}},34000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I21","v":{"$error":"#DIV/0!"}},36000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I22","v":{"$error":"#DIV/0!"}},38000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"Betriebskostenersparnis!I23","v":{"$error":"#DIV/0!"}},40000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Berechnung statische Armortisationszeit","KLÄRANLAGE X"]
["Betriebskostenänderung","Einwohnerwerte","Investitionskostendifferenz","Armotisationszeit",null,"Aufsummierte Kosten (Formel !!)"]
["Euro/Jahr","EW"]
[null,0,0,{"$f":"D29","v":{"$error":"#DIV/0!"}}]
[{"$f":"Betriebskostenersparnis!I24","v":{"$error":"#DIV/0!"}},{"$f":"Betriebskostenersparnis!B24","v":0},{"$f":"IF('Berechnung Grafik Statisch 2'!L18<0,'Dateneingabe und Ergebnisse'!F74,'Dateneingabe und Ergebnisse'!#REF!)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C29/A29>60,#N/A,C29/A29)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"B29","v":0},{"$f":"C29","v":{"$error":"#DIV/0!"}},0]
[]
["Berechnung für tA = f (IKD)"]
["Betriebskostenänderung","Einwohnerwerte"]
["Euro/Jahr","EW","Amortisationszeit"]
[{"$f":"A29","v":{"$error":"#DIV/0!"}},{"$f":"B29","v":0},{"$f":"IF(C$2/$A35>50,#N/A,C$2/$A35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Berechnung Grafik Statisch 2","index":7,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":true,"merged":[[1,4,1,7],[1,1,1,3]]}
[]
[null,"Variante: Aaerobe Stabilisierung",null,null,"Variante: Anaerobe Stabilisierung"]
["Jahre","Investitionskosten","Laufende Kosten","Gesamtkosten","Investitionskosten","Laufende Kosten","Einsparung Eigenstrom","Gesamtkosten","Jahre","Gesamtkosten Aerobe Stabilsierung","Gesamtkosten Anerobe Stabilsierung","Differenz","Betrag der Differenz",null,"Kontrolle Betriebskostenersparnis","Kontrolle Amortisationszeit"]
[null,null,null,null,null,null,null,null,null,"Mio. Euro","Mio. Euro","Euro"]
[0,{"$f":"'Dateneingabe und Ergebnisse'!F64","v":0},0,{"$f":"B5+C5","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I64","v":0},0,0,{"$f":"E5+F5-G5","v":0},0,{"$f":"D5/1000000","v":0},{"$f":"H5/1000000","v":0},{"$f":"(K5-J5)*1000000","v":0},{"$f":"ABS(L5)","v":0},null,{"$f":"C5-F5+G5","v":0},{"$f":"(E5+E19)/O6","v":{"$error":"#DIV/0!"}}]
[1,0,{"$f":"Bemessung!BA26+Bemessung!AG26","v":0},{"$f":"D5+C6+B6","v":0},0,{"$f":"Bemessung!BA56+Bemessung!AG56","v":{"$error":"#DIV/0!"}},{"$f":"Bemessung!BT56","v":0},{"$f":"H5+E6+F6-G6","v":{"$error":"#DIV/0!"}},{"$f":"A6","v":1},{"$f":"D6/1000000","v":0},{"$f":"H6/1000000","v":{"$error":"#DIV/0!"}},{"$f":"(K6-J6)*1000000","v":{"$error":"#DIV/0!"}},{"$f":"ABS(L6)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"}]
[2,{"$f":"B6","v":0},{"$f":"C6","v":0},{"$f":"D6+C7+B7","v":0},0,{"$f":"F6","v":{"$error":"#DIV/0!"}},{"$f":"G6","v":0},{"$f":"H6+E7+F7-G7","v":{"$error":"#DIV/0!"}},2,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[3,{"$f":"B7","v":0},{"$f":"C7","v":0},0,0,{"$f":"F7","v":{"$error":"#DIV/0!"}},{"$f":"G7","v":0},{"$error":"#DIV/0!"},3,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[4,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},4,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[5,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},5,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[6,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},6,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[7,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},7,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[8,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},8,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[9,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},9,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[10,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},10,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[11,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},11,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[12,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},12,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[12.5,0,{"$f":"C17/2","v":0},0,0,{"$f":"F17/2","v":{"$error":"#DIV/0!"}},{"$f":"G17/2","v":0},{"$error":"#DIV/0!"},12.5,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[12.5,{"$f":"'Dateneingabe und Ergebnisse'!F52*'Dateneingabe und Ergebnisse'!F54/100","v":0},0,0,{"$f":"'Dateneingabe und Ergebnisse'!I53*'Dateneingabe und Ergebnisse'!I54/100+'Dateneingabe und Ergebnisse'!I56","v":0},0,0,{"$error":"#DIV/0!"},12.5,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[13,{"$f":"B17","v":0},{"$f":"C17/2","v":0},0,0,{"$f":"F17/2","v":{"$error":"#DIV/0!"}},{"$f":"G17/2","v":0},{"$error":"#DIV/0!"},13,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[14,0,{"$f":"C17","v":0},0,0,{"$f":"F17","v":{"$error":"#DIV/0!"}},{"$f":"G17","v":0},{"$error":"#DIV/0!"},14,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[15,{"$f":"B21","v":0},{"$f":"C21","v":0},0,0,{"$error":"#DIV/0!"},{"$f":"G21","v":0},{"$error":"#DIV/0!"},15,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[16,0,0,0,0,{"$f":"F22","v":{"$error":"#DIV/0!"}},{"$f":"G22","v":0},{"$error":"#DIV/0!"},16,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[17,{"$f":"B23","v":0},0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},17,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[18,{"$f":"B24","v":0},0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},18,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[19,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},19,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[20,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},20,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[21,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},21,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[22,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},22,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[23,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},23,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[24,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},24,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[25,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},25,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[26,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},26,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[27,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},27,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[28,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},28,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[29,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},29,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[30,0,0,0,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},30,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]

{"sheet":"Berechnung Grafik_Dynamisch","index":8,"n_rows":37,"n_cols":27,"rows_kept":37,"cut":false,"hidden":true,"merged":[[35,16,35,26],[35,2,35,12],[2,6,2,12],[0,2,0,12],[0,16,0,26],[2,16,2,26]]}
["Berechnung Diskontierungsfaktor für dynamische Armotisationszeit","ALLGEMEIN","Investitionskostendifferenz",null,null,null,null,null,null,null,null,null,null,null,"dynamische Amortisationszeit","ALLGEMEIN","Investitionskostendifferenz"]
["Betriebskostenänderung","Einwohnerwerte",0,200000,{"$f":"D2+200000","v":400000},{"$f":"E2+200000","v":600000},800000,1000000,1200000,1400000,1600000,1800000,2000000,null,"Zinsatz für Tabelle","Einwohnerwerte",0,200000,{"$f":"R2+200000","v":400000},{"$f":"S2+200000","v":600000},{"$f":"T2+200000","v":800000},{"$f":"U2+200000","v":1000000},{"$f":"V2+200000","v":1200000},{"$f":"W2+200000","v":1400000},{"$f":"X2+200000","v":1600000},{"$f":"Y2+200000","v":1800000},{"$f":"Z2+200000","v":2000000}]
["Euro/Jahr","EW",null,null,null,null,"Euro",null,null,null,null,null,null,null,{"$f":"IF(O5=0,0.00000000001,O5)","v":9.9999999999999994E-12},"EW","Amortisationszeit"]
[{"$f":"Betriebskostenersparnis!I4","v":{"$error":"#DIV/0!"}},2000,{"$f":"C$2/$A4","v":{"$error":"#DIV/0!"}},{"$f":"D$2/$A4","v":{"$error":"#DIV/0!"}},{"$f":"E$2/$A4","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"G$2/$A4","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"M$2/$A4","v":{"$error":"#DIV/0!"}},null,"Zinssatz von Eingabe =",2000,0,{"$f":"IF(ISERROR(LOG(1/(1-$O$3*D4),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*D4),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*D4),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*E4),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*E4),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*E4),1+$O$3)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I5","v":{"$error":"#DIV/0!"}},4000,{"$f":"C$2/$A5","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"'Dateneingabe und Ergebnisse'!F58/100","v":0},4000,0,{"$error":"#N/A"},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*E5),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*E5),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*E5),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*F5),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*F5),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*F5),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*G5),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*G5),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*G5),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*H5),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*H5),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*H5),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*I5),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*I5),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*I5),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*J5),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*J5),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*J5),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*K5),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*K5),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*K5),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*L5),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*L5),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*L5),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*M5),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*M5),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*M5),1+$O$3)))","v":{"$error":"#N/A"}}]
[{"$f":"Betriebskostenersparnis!I6","v":{"$error":"#DIV/0!"}},6000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,6000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I7","v":{"$error":"#DIV/0!"}},8000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,8000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I8","v":{"$error":"#DIV/0!"}},10000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,10000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I9","v":{"$error":"#DIV/0!"}},12000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,12000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I10","v":{"$error":"#DIV/0!"}},14000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,14000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I11","v":{"$error":"#DIV/0!"}},16000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,16000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I12","v":{"$error":"#DIV/0!"}},18000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,18000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I13","v":{"$error":"#DIV/0!"}},20000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"H$2/$A13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,20000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I14","v":{"$error":"#DIV/0!"}},22000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"M$2/$A14","v":{"$error":"#DIV/0!"}},null,null,22000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I15","v":{"$error":"#DIV/0!"}},24000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,24000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I16","v":{"$error":"#DIV/0!"}},26000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,26000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I17","v":{"$error":"#DIV/0!"}},28000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,28000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I18","v":{"$error":"#DIV/0!"}},30000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,30000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I19","v":{"$error":"#DIV/0!"}},32000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,32000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I20","v":{"$error":"#DIV/0!"}},34000,{"$error":"#DIV/0!"},{"$f":"D$2/$A20","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G$2/$A20","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,34000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I21","v":{"$error":"#DIV/0!"}},36000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G$2/$A21","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,36000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I22","v":{"$error":"#DIV/0!"}},38000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G$2/$A22","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,38000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I23","v":{"$error":"#DIV/0!"}},40000,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"G$2/$A23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,40000,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[]
["Berechnung Diskontierungsfaktor für dynamische Armotisationszeit","Kläranlage X",null,null,null,null,null,null,null,null,null,null,null,null,"dynamische Amortisationszeit",{"$f":"'Dateneingabe und Ergebnisse'!A3","v":0}]
["Betriebskostenänderung","Einwohnerwerte","Investitionskostendifferenz","Diskontierungsf.",null,null,null,null,null,null,null,null,null,null,"Betriebskostenänderung","Einwohnerwerte","Armotisationszeit"]
["Euro/Jahr","EW","Euro","DFAK",null,null,null,null,null,null,null,null,null,null,"Euro/Jahr","EW"]
[null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q31","v":""}]
[{"$f":"Betriebskostenersparnis!I24","v":{"$error":"#DIV/0!"}},{"$f":"Betriebskostenersparnis!B24","v":0},{"$f":"IF('Berechnung Grafik Dynamisch  2'!Q18<0,'Dateneingabe und Ergebnisse'!F74,'Dateneingabe und Ergebnisse'!F75)","v":{"$error":"#DIV/0!"}},{"$f":"C31/A31","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"A31","v":{"$error":"#DIV/0!"}},{"$f":"Betriebskostenersparnis!B24","v":0},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*D31),1+$O$3)),\"\",(LOG(1/(1-$O$3*D31),1+$O$3)))","v":""}]
[null,null,{"$f":"C31","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P31","v":0},0]
[]
["Berechnung für tA = f (IKD)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Berechnung für tA = f (IKD)"]
["Betriebskostenänderung","Einwohnerwerte",null,null,null,null,null,null,null,null,null,null,null,null,"Betriebskostenänderung","Einwohnerwerte"]
["Euro/Jahr","EW","Diskontierungsfaktor",null,null,null,null,null,null,null,null,null,null,null,"Euro/Jahr","EW","Amortisationszeit"]
[{"$f":"A31","v":{"$error":"#DIV/0!"}},{"$f":"B31","v":0},{"$f":"C$2/$A37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$f":"O31","v":{"$error":"#DIV/0!"}},{"$f":"P31","v":0},0,{"$f":"IF(ISERROR(LOG(1/(1-$O$3*D37),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*D37),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*D37),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*E37),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*E37),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*E37),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*F37),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*F37),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*F37),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*G37),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*G37),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*G37),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*H37),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*H37),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*H37),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*I37),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*I37),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*I37),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*J37),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*J37),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*J37),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*K37),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*K37),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*K37),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*L37),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*L37),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*L37),1+$O$3)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*M37),1+$O$3)),#N/A,IF(LOG(1/(1-$O$3*M37),1+$O$3)>50,#N/A,LOG(1/(1-$O$3*M37),1+$O$3)))","v":{"$error":"#N/A"}}]

{"sheet":"Berechnung Grafik Dynamisch  2","index":9,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":true,"merged":[[1,1,1,5],[1,6,1,12]]}
[]
[null,"Variante: Aaerobe Stabilisierung",null,null,null,null,"Variante: Anaerobe Stabilisierung"]
["Jahre","Investitionskosten","Diskontierte Investitionskosten","Laufende Kosten","Diskontierte Betriebskosten","Gesamtkosten","Investitionskosten","Diskontierte Investitionskosten","Laufende Kosten","Einsparung Eigenstrom","Betriebskosten Gesamt","Diskontierete Betriebskosten","Gesamtkosten","Jahre","Gesamtkosten Aerobe Stabilsierung","Gesamtkosten Anerobe Stabilsierung","Differenz",null,null,"Kontrolle Betriebskostenersparnis","Kontrolle Amortisationszeit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mio. Euro","Mio. Euro"]
[0,{"$f":"'Dateneingabe und Ergebnisse'!F64","v":0},{"$f":"B5","v":0},0,null,{"$f":"B5+E5","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I64","v":0},{"$f":"G5","v":0},0,0,{"$f":"I5+J5","v":0},0,{"$f":"G5","v":0},0,{"$f":"F5/1000000","v":0},{"$f":"M5/1000000","v":0},{"$f":"(P5-O5)*1000000","v":0},null,null,{"$f":"D5-I5+J5","v":0},{"$f":"(G5+G19)/T6","v":{"$error":"#DIV/0!"}}]
[1,null,null,{"$f":"'Dateneingabe und Ergebnisse'!F70","v":0},{"$f":"D6/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A6","v":0},{"$f":"F5+E6","v":0},0,null,{"$f":"'Dateneingabe und Ergebnisse'!I66+'Dateneingabe und Ergebnisse'!I67+'Dateneingabe und Ergebnisse'!I68","v":{"$error":"#DIV/0!"}},{"$f":"Bemessung!BT56","v":0},{"$f":"I6-J6","v":{"$error":"#DIV/0!"}},{"$f":"K6/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A6","v":{"$error":"#DIV/0!"}},{"$f":"M5+L6","v":{"$error":"#DIV/0!"}},{"$f":"A6","v":1},{"$f":"F6/1000000","v":0},{"$f":"M6/1000000","v":{"$error":"#DIV/0!"}},{"$f":"(P6-O6)*1000000","v":{"$error":"#DIV/0!"}},null,null,{"$error":"#DIV/0!"}]
[2,null,null,{"$f":"D6","v":0},{"$f":"D7/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A7","v":0},{"$f":"F6+E7","v":0},0,null,{"$f":"I6","v":{"$error":"#DIV/0!"}},{"$f":"J6","v":0},{"$f":"I7-J7","v":{"$error":"#DIV/0!"}},{"$f":"K7/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A7","v":{"$error":"#DIV/0!"}},{"$f":"M6+L7","v":{"$error":"#DIV/0!"}},2,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[3,null,null,{"$f":"D7","v":0},{"$f":"D8/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A8","v":0},0,0,null,{"$f":"I7","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$f":"K8/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},3,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[4,null,null,0,{"$f":"D9/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A9","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K9/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},4,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[5,null,null,0,{"$f":"D10/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A10","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K10/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A10","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},5,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[6,null,null,0,{"$f":"D11/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A11","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K11/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A11","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},6,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[7,null,null,0,{"$f":"D12/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A12","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K12/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},7,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[8,null,null,0,{"$f":"D13/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A13","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K13/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A13","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},8,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[9,null,null,0,{"$f":"D14/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A14","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K14/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A14","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},9,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[10,null,null,0,{"$f":"D15/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A15","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K15/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A15","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},10,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[11,null,null,0,{"$f":"D16/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A16","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K16/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},11,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[12,null,null,0,{"$f":"D17/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A17","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K17/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},12,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[12.5,null,null,{"$f":"D17/2","v":0},{"$f":"D18/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A18","v":0},0,0,null,{"$f":"I17/2","v":{"$error":"#DIV/0!"}},{"$f":"J17/2","v":0},{"$error":"#DIV/0!"},{"$f":"K18/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A18","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},12.5,{"$f":"F18/1000000","v":0},{"$f":"M18/1000000","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[12.5,{"$f":"'Dateneingabe und Ergebnisse'!F52*'Dateneingabe und Ergebnisse'!F54/100","v":0},{"$f":"B19/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A19","v":0},0,{"$f":"D19/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A19","v":0},{"$f":"F18+C19","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I53*'Dateneingabe und Ergebnisse'!I54/100+'Dateneingabe und Ergebnisse'!I56","v":0},{"$f":"G19/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A19","v":0},null,{"$f":"J18","v":0},null,{"$f":"K19/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A19","v":0},{"$f":"M18+H19","v":{"$error":"#DIV/0!"}},12.5,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[13,null,null,{"$f":"D18","v":0},{"$f":"D20/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A20","v":0},{"$f":"F19+E20","v":0},0,null,{"$f":"I18","v":{"$error":"#DIV/0!"}},{"$f":"J18","v":0},{"$error":"#DIV/0!"},{"$f":"K20/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A20","v":{"$error":"#DIV/0!"}},{"$f":"M19+L20","v":{"$error":"#DIV/0!"}},13,{"$f":"F20/1000000","v":0},{"$f":"M20/1000000","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,{"$f":"D20-I20+J20","v":{"$error":"#DIV/0!"}}]
[14,null,null,{"$f":"D17","v":0},{"$f":"D21/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A21","v":0},{"$f":"F20+E21","v":0},0,null,{"$f":"I17","v":{"$error":"#DIV/0!"}},{"$f":"J17","v":0},{"$error":"#DIV/0!"},{"$f":"K21/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A21","v":{"$error":"#DIV/0!"}},{"$f":"M20+L21","v":{"$error":"#DIV/0!"}},14,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[15,null,null,0,{"$f":"D22/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A22","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K22/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A22","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},15,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[16,null,null,{"$f":"D22","v":0},{"$f":"D23/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A23","v":0},0,0,null,{"$f":"I22","v":{"$error":"#DIV/0!"}},{"$f":"J22","v":0},{"$f":"I23-J23","v":{"$error":"#DIV/0!"}},{"$f":"K23/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A23","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},16,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[17,null,null,{"$f":"D23","v":0},{"$f":"D24/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A24","v":0},0,0,null,{"$f":"I23","v":{"$error":"#DIV/0!"}},{"$f":"J23","v":0},{"$error":"#DIV/0!"},{"$f":"K24/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A24","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},17,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[18,null,null,{"$f":"D24","v":0},{"$f":"D25/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A25","v":0},0,0,null,{"$f":"I24","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$f":"K25/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A25","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},18,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[19,null,null,0,{"$f":"D26/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A26","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K26/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A26","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},19,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[20,null,null,0,{"$f":"D27/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A27","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K27/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A27","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},20,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[21,null,null,0,{"$f":"D28/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A28","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K28/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A28","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},21,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[22,null,null,0,{"$f":"D29/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A29","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K29/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A29","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},22,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[23,null,null,0,{"$f":"D30/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A30","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K30/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A30","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},23,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[24,null,null,0,{"$f":"D31/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A31","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K31/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A31","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},24,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[25,null,null,0,{"$f":"D32/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A32","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K32/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A32","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},25,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[26,null,null,0,{"$f":"D33/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A33","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K33/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A33","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},26,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[27,null,null,0,{"$f":"D34/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A34","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K34/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A34","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},27,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[28,null,null,0,{"$f":"D35/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A35","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K35/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A35","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},28,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[29,null,null,0,{"$f":"D36/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A36","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K36/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A36","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},29,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[30,null,null,0,{"$f":"D37/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A37","v":0},0,0,null,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$f":"K37/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},30,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]

{"sheet":" t_TS --> OVC","index":10,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":true,"merged":[[7,1,7,2],[7,7,7,9],[6,7,6,12],[6,3,6,4],[7,10,7,12],[7,3,7,4],[6,1,6,2],[6,5,6,6],[7,5,7,6]]}
[]
[null,null,null,null,null,null,null,"K1",43.226801536014307,null,"K2",37.062622637840079]
[null,null,null,null,null,null,null,"n1",0.13981458755423726,null,"n2",0.16347407884956872]
[]
[]
[]
[null,"von Grafik",null,"von Excel",null,"von Excel verändert",null,"Potenzfunktion"]
["t_TS","OVC",null,"OVC",null,"OVC",null,"OVC",null,null,"OVC"]
[null,"mit VK","ohne VK","mit VK","ohne VK","mit VK","ohne VK","mit VK",null,null,"ohne VK"]
["d","%","%",null,null,null,null,"%"]
[5,53,47,{"$f":"8.8152*LN(A11)+39.505","v":53.692517085689083},{"$f":"9.4345*LN(A11)+32.468","v":47.652241984859522},{"$f":"8.8152*LN(A11)+39.505-1","v":52.692517085689083},{"$f":"9.4345*LN(A11)+32.468-1","v":46.652241984859522},{"$f":"$I$2*A11^($I$3)-1","v":53.135145079958477},{"$f":"B11-H11","v":-0.1351450799584768},{"$f":"I11^2","v":1.8264192636983086E-2},{"$f":"$L$2*A11^($L$3)-1","v":47.216937796783043},{"$f":"K11-C11","v":0.21693779678304281},{"$f":"L11^2","v":4.7062007673080782E-2}]
[10,60,54,{"$f":"8.8152*LN(A12)+39.505","v":59.802748111761119},{"$f":"9.4345*LN(A12)+32.468","v":54.191739059852324},58.802748111761119,53.191739059852324,58.644127468964719,1.3558725310352813,{"$f":"I12^2","v":1.8383903204160197},53.002047512802733,-0.99795248719726715,{"$f":"L12^2","v":0.99590916670321161}]
[15,64,59,63.377004132756205,58.017099622298801,62.377004132756205,57.017099622298801,62.123026942298218,1.8769730577017825,3.523027859338379,56.702759527447725,-2.297240472552275,5.2773137887321999]
[20,67,62,65.912979137833148,60.731236134845133,64.912979137833148,59.731236134845133,64.713723243555393,2.2862767564446074,5.2270614070588746,59.481259674055224,-2.5187403259447763,6.3440528295403977]
[25,68,63,67.880034171378171,62.83648396971904,66.880034171378171,61.83648396971904,66.796224302797839,1.2037756972021612,1.4490759291745492,61.728240071311191,-1.2717599286888088,1.6173733162185642]
[30,69,64,69.487235158828241,64.55659669729161,68.487235158828241,63.55659669729161,68.546647738959322,0.45335226104067772,0.20552827259069478,63.625986302866409,-0.37401369713359145,0.13988624564353788]
[35,70,65,70.846104231641476,66.010931286121874,69.846104231641476,65.010931286121874,70.061822075672566,-6.1822075672566257E-2,3.8219690404645086E-3,65.275230827329096,0.27523082732909643,7.5752008312258895E-2]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J11:J17)","v":12.265169950255963},null,null,{"$f":"SUM(M11:M17)","v":14.497349362823252}]
[]
["Anpassungsfunktion muss wohl noch abgeflachtt werden!! 71 % OVC bei 35 Tage Schlammalter sind einfach zu viel!  Vielleicht einfach -1 und schon passt???"]

{"sheet":"Fixe Parameter","index":11,"n_rows":57,"n_cols":3,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Parameter","Einheit","Wert"]
["Sauerstoffsättigungskonzentration CS","mg/L",13]
["Sauerstoffkonzentration im Belebungsbecken CX","mg/L",1.5]
["spezifischer oTS-Gehalt ausgefaulter Schlamm","g oTS/(EW120·d)",20]
["CSB/oTS","–",1.45]
["N-Anteil im Überschussschlamm iN,ÜS","–",0.06]
["N/oTSPS =","–",0.06]
["Energiegehalt Methan","kWh/m³ CH4",10]
["spezifische Methanprotuktion ","Nm³ CH4/kg CSB",0.35]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,13]
[null,null,1.5]
[null,null,1.45]
[null,null,20]
[null,null,0.35]
[null,null,10]
[null,null,0.06]
[null,null,{"$f":"0.06","v":0.06}]