{"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",15000,"1F",null,{"$f":"F5","v":15000}]
["II: Bemessungsbelastungen","CSB-Bemessungsbelastung Belebung ","EWCSB120","2A",null,20000,"2F",null,{"$f":"F6","v":20000}]
[null,"CSB-Bemessungsbelastung Faulung ","EWCSB120",null,null,null,"3F","s. Handbuch",17000]
["III: Wirkungsgrade","Mittlere Entfernung CSB","%","4A","85 - 98",95,"4F",null,{"$f":"F8","v":95}]
[null,"Mittlere Entfernung NGes","%","5A","70 - 95",85,"5F",null,{"$f":"F9","v":85}]
["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",30,"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",7500,"10F","s. Handbuch",7500]
["VI: Belüftung","Sauerstoffertrag","kg O2/kWh","11A","1,50 - 2,20",2,"11F",null,{"$f":"F15","v":2}]
[null,"Strompreis","Euro/kWh","12A","s. Handbuch",0.14000000000000001,"12F",null,{"$f":"F16","v":0.14000000000000001}]
["VII: Schlammlinie","oTS-Gehalt Primärschlamm","%","13A","50 - 80","–","13F","50 - 80","–"]
[null,"oTS-Gehalt Überschussschlamm","%","14A","45 - 70",55,"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",30]
[null,"TS nach Entwässerung","%","17F","20 - 30",24,"17F","20 - 30",26]
[null,"spezifische Schlamm-Entsorgungskosten","Euro/t","18F","s. Handbuch",60,"18F","s. Handbuch",60]
["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":9322.1997163040887},null,null,{"$f":"Bemessung!AL60*I12/I13","v":5039.3745270408299}]
[null,"zusätzlich erforderliches VBB bei vorgegebener TSBB (9A/9F)","m³",null,null,{"$f":"IF(F29-F14<=0,0,F29-F14)","v":1822.1997163040887},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":3.7288798865216357},null,null,{"$f":"Bemessung!AL60*I12/I14","v":2.0157498108163319}]
["Faulung / Schlammanfall","Volumen Faulbehälter","m³",null,null,"–",null,null,{"$f":"Bemessung!BH58","v":957.48116013775768}]
[null,"Schlammanfall (entwässerter Schlamm)","t/Jahr",null,null,{"$f":"Bemessung!AY26","v":1188.4090998633983},null,null,{"$f":"Bemessung!AY56","v":895.56193228545033}]
[]
["Zwischenergebnis 1B: Reservekapazität Variante F"]
[]
["Reservekapazität Belebung","Reservekapazität VBB ","m³",null,null,"–",null,null,{"$f":"I14-I29","v":2460.6254729591701}]
[null,"Reservekapazität Einwohnerwerte 1","EWCSB120",null,null,"–",null,null,{"$f":"Bemessung!B62","v":9765.5987256183271}]
[null,"Reservekapazität Einwohnerwerte 2","%",null,null,"–",null,null,{"$f":"I38/I6*100","v":48.82799362809164}]
["Faulung bei Ausnutzung Reservekapazität","Volumen Faulbehälter bei Ausnutzung Reservekapazität","m³",null,null,"–",null,null,{"$f":"Bemessung!BH59","v":1424.9999999999998}]
[null,"Schlammanfall bei Ausnutzung Reservekapazität (entwässerter Schlamm)","t/Jahr",null,null,"–",null,null,{"$f":"Bemessung!AY57","v":1332.8468555174038}]
[]
["Zwischenergebnis 2: Faulgasnutzung"]
[]
["Faulgasnutzung","mittlere in Faulung abgebaute CSB-Fracht","kg CSB/ Jahr",null,null,"–",null,null,{"$f":"Bemessung!AU56","v":109502.77270742202}]
[null,"mittlere in Faulung entstehende CH4-Fracht","Nm³ CH4/Jahr",null,null,"–",null,null,{"$f":"I45*'Fixe Parameter'!C9","v":38325.970447597705}]
[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,600000,"22F",null,0]
[null,"Investitionskosten Faulung","Euro",null,null,null,"23F",null,800000]
[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",3,"28F",null,{"$f":"F58","v":3}]
["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":600000},null,null,{"$f":"I53+I55+I56+I57","v":800000}]
[null,"Gesamtinvestitionskosten mit RK                         ","Euro",null,null,{"$f":"F64+'Berechnung Grafik Dynamisch  2'!C19","v":765861.63145668013},null,null,{"$f":"I64+'Berechnung Grafik Dynamisch  2'!H19","v":1021148.84194224}]
["Betriebskosten","Kosten für Belüftung","Euro/Jahr",null,null,{"$f":"Bemessung!AG26","v":37086.22266299004},null,null,{"$f":"Bemessung!AG56","v":34371.458347182721}]
[null,"Kosten für Schlammentsorgung","Euro/Jahr",null,null,{"$f":"Bemessung!BA26","v":71304.545991803898},null,null,{"$f":"Bemessung!BA56","v":53733.715937127017}]
[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":108390.76865479394},null,null,{"$f":"I66+I67+I68-I69","v":88105.174284309731}]
[]
["Zwischenergebnis 3B: Kostendifferenz Variante A / Variante F"]
[]
["Einparung Gesamtinvestitionskosten                                                                                                                                                                                                                Variante A","Einsparung Gesamtinvestitionskosten ohne RK                                                                   ","Euro",null,null,{"$f":"I64-F64","v":200000},null,null,"–"]
[null,"Einsparung Gesamtinvestitionskosten mit RK                                                                                       ","Euro",null,null,{"$f":"I65-F65","v":255287.21048555989},null,null,"–"]
["Einsparung / Erhöung Betriebskosten                                                                                                                                                                                                                                           Variante F","Einsparung Belüftung","Euro/Jahr",null,null,"–",null,null,{"$f":"F66-I66","v":2714.7643158073188}]
[null,"Einsparung Schlammentsorgung","Euro/Jahr",null,null,"–",null,null,{"$f":"F67-I67","v":17570.830054676881}]
[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":20285.594370484199}]
[]
["Endergebnis: Amortisationszeit Faulung"]
[]
["Amortisationszeit Faulung",null,"Jahre",{"$f":"'Berechnung Grafik_Dynamisch'!Q31","v":11.863111079989181}]
[]
["Kontrollwerte zur Plausibilitätsüberprüfung"]
[]
["Kontrollwerte Belebung","N-Rückbelastung Variante F","%",null,null,"–",null,"< 15",{"$f":"Bemessung!F58","v":10.90936714395238}]
[null,"Nges_zu/CSB_zu","–",null,"< 0,14",{"$f":"Bemessung!K6","v":9.166666666666666E-2},null,"< 0,14",{"$f":"Bemessung!K36","v":0.10166691988195635}]
[null,"spezifische Belüftungskosten","kWh/(EW·a)",null,"15 - 25",{"$f":"Bemessung!AE26","v":17.660106029995255},null,"10 - 20",{"$f":"Bemessung!AE56","v":16.367361117706057}]
[null,"spezifische Kosten Erweiterung Belebung","Euro/m³",null,"300 - 500",{"$f":"IF(F52>0,F52/F30,\"–\")","v":329.27235946285924},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":40.816938206372917}]
[null,"spezifische Kosten Faulung","Euro/EW",null,null,"–",null,"s. Handbuch",{"$f":"I53/I7","v":47.058823529411768}]
[null,"spezifische Kosten Faulung","Euro/m³",null,null,"–",null,"800 - 1200",{"$f":"I53/I32","v":835.52557826297061}]
[null,"spezifischer Biogasanfall","L Biogas/(EW120·d)",null,null,"–",null,"s. Handbuch",{"$f":"I46/0.65/365/I5*1000","v":10.769503462619657}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":7.4999999999999997E-2},{"$f":"(100-'Dateneingabe und Ergebnisse'!F9)/100","v":0.15},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.2539184952978055}]
[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":30},{"$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":63.55659669729161},{"$f":"'Dateneingabe und Ergebnisse'!F8","v":95},{"$f":"(N6-H6)/(100-H6)*100","v":95},{"$f":"I6*O6/100","v":83220},{"$f":"P6*M6/100","v":52891.799771486076},{"$f":"AH6*$R$2","v":1819.6920137108352},{"$f":"J6*$S$2","v":602.25},{"$f":"J6*$T$2","v":1204.5},{"$f":"J6-R6-T6+S6","v":5608.0579862891645},{"$f":"U6*4.3","v":24114.649341043405},{"$f":"J6-R6-T6","v":5005.8079862891645},{"$f":"W6*2.9","v":14516.843160238577},{"$f":"100-T6/J6*100","v":85},{"$f":"Q6+V6-X6","v":62489.605952290913},{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},{"$f":"Z6*AA6","v":70640.42411998102},{"$f":"'Dateneingabe und Ergebnisse'!F15","v":2},{"$f":"AB6/AC6","v":35320.21205999051},{"$f":"AD6/B6","v":17.660106029995255},{"$f":"'Dateneingabe und Ergebnisse'!F16","v":0.14000000000000001},{"$f":"AD6*AF6","v":4944.8296883986723},{"$f":"P6*((100-M6)/100)","v":30328.200228513921},{"$f":"AH6/$AI$2","v":20916.000157595809},{"$f":"'Dateneingabe und Ergebnisse'!F18","v":55},{"$f":"AI6/AJ6*100","v":38029.091195628738},{"$f":"AK6/365","v":104.18929094692805},{"$f":"C6-I6","v":0},{"$f":"AM6/$AI$2","v":0},{"$f":"'Dateneingabe und Ergebnisse'!F17","v":"–"},{"$f":"AI6+AN6","v":20916.000157595809},{"$f":"IF(AO6<>\"–\",AK6+AN6/AO6*100,AK6)","v":38029.091195628738},"-","-","-",null,"-",{"$f":"AQ6","v":38029.091195628738},{"$f":"'Dateneingabe und Ergebnisse'!F21","v":24},{"$f":"AW6/(AX6/100)/1000","v":158.45454664845309},{"$f":"'Dateneingabe und Ergebnisse'!F22","v":60},{"$f":"AY6*AZ6","v":9507.2727989071846}]
[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":30},{"$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":63.55659669729161},{"$f":"N6","v":95},{"$f":"(N7-H7)/(100-H7)*100","v":95},{"$f":"I7*O7/100","v":166440},{"$f":"P7*M7/100","v":105783.59954297215},3639.3840274216705,{"$f":"J7*$S$2","v":1204.5},{"$f":"J7*$T$2","v":2409},11216.115972578329,{"$f":"U7*4.3","v":48229.29868208681},{"$f":"J7-R7-T7","v":10011.615972578329},{"$f":"W7*2.9","v":29033.686320477154},{"$f":"100-T7/J7*100","v":85},124979.21190458183,{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},141280.84823996204,{"$f":"AC6","v":2},70640.42411998102,17.660106029995255,{"$f":"AF6","v":0.14000000000000001},9889.6593767973445,{"$f":"P7*((100-M7)/100)","v":60656.400457027841},41832.000315191617,{"$f":"AJ6","v":55},{"$f":"AI7/AJ7*100","v":76058.182391257476},{"$f":"AK7/365","v":208.37858189385611},0,0,{"$f":"AO6","v":"–"},41832.000315191617,{"$f":"IF(AO7<>\"–\",AK7+AN7/AO7*100,AK7)","v":76058.182391257476},{"$f":"AR6","v":"-"},{"$f":"AS6","v":"-"},{"$f":"AT6","v":"-"},null,{"$f":"AV6","v":"-"},76058.182391257476,{"$f":"AX6","v":24},316.90909329690618,{"$f":"AZ6","v":60},19014.545597814369]
[null,6000,262800,24090,{"$f":"E7","v":0},0,"NEIN",0,262800,24090,9.166666666666666E-2,30,63.55659669729161,{"$f":"N7","v":95},95,249660,158675.39931445825,5459.0760411325055,1806.75,3613.5,16824.173958867494,72343.948023130215,15017.423958867494,{"$f":"W8*2.9","v":43550.529480715733},85,187468.81785687275,1.1304347826086956,211921.27235994308,2,105960.63617997154,17.660106029995255,0.14000000000000001,14834.489065196016,{"$f":"P8*((100-M8)/100)","v":90984.600685541765},62748.000472787426,55,{"$f":"AI8/AJ8*100","v":114087.27358688622},312.56787284078416,0,0,{"$f":"AO7","v":"–"},62748.000472787426,114087.27358688622,{"$f":"AR7","v":"-"},{"$f":"AS7","v":"-"},{"$f":"AT7","v":"-"},null,{"$f":"AV7","v":"-"},114087.27358688622,24,475.36363994535924,60,28521.818396721555]
[null,8000,350400,32120,0,0,"NEIN",0,350400,32120,9.166666666666666E-2,30,63.55659669729161,95,95,332880,211567.1990859443,7278.7680548433409,2409,4818,22432.231945156658,96458.59736417362,20023.231945156658,{"$f":"W9*2.9","v":58067.372640954309},85,249958.42380916365,1.1304347826086956,282561.69647992408,2,141280.84823996204,17.660106029995255,0.14000000000000001,19779.318753594689,{"$f":"P9*((100-M9)/100)","v":121312.80091405568},83664.000630383234,55,152116.36478251495,416.75716378771222,0,0,"–",83664.000630383234,152116.36478251495,"-","-","-",null,"-",152116.36478251495,24,633.81818659381236,60,38029.091195628738]
[null,10000,438000,40150,0,0,"NEIN",0,438000,40150,9.166666666666666E-2,30,63.55659669729161,95,95,416100,264458.99885743042,9098.4600685541773,3011.25,6022.5,28040.289931445823,120573.24670521704,25029.039931445823,72584.215801192884,85,312448.02976145456,1.1304347826086956,353202.12059990515,2,176601.06029995257,17.660106029995259,0.14000000000000001,24724.148441993362,151641.00114256961,104580.00078797905,55,190145.45597814373,520.94645473464038,0,0,"–",104580.00078797905,190145.45597814373,"-","-","-",null,"-",190145.45597814373,24,792.27273324226553,60,47536.363994535932]
[null,12000,525600,48180,0,0,"NEIN",0,525600,48180,9.166666666666666E-2,30,63.55659669729161,95,95,499320,317350.7986289165,10918.152082265011,3613.5,7227,33648.347917734987,144687.89604626043,30034.847917734987,87101.058961431467,85,374937.63571374549,1.1304347826086956,423842.54471988615,2,211921.27235994308,17.660106029995255,0.14000000000000001,29668.978130392032,181969.20137108353,125496.00094557485,55,228174.54717377244,625.13574568156832,0,0,"–",125496.00094557485,228174.54717377244,"-","-","-",null,"-",228174.54717377244,24,950.72727989071848,60,57043.636793443111]
[null,14000,613200,56210,0,0,"NEIN",0,613200,56210,9.166666666666666E-2,30,63.55659669729161,95,95,582540,370242.59840040252,12737.844095975846,4215.75,8431.5,39256.405904024155,168802.54538730386,35040.655904024155,101617.90212167005,85,437427.24166603631,1.1304347826086956,494482.9688398671,2,247241.48441993355,17.660106029995255,0.14000000000000001,34613.807818790701,212297.40159959745,146412.00110317065,55,266203.63836940116,729.32503662849638,0,0,"–",146412.00110317065,266203.63836940116,"-","-","-",null,"-",266203.63836940116,24,1109.1818265391717,60,66550.909592350305]
[null,16000,700800,64240,0,0,"NEIN",0,700800,64240,9.166666666666666E-2,30,63.55659669729161,95,95,665760,423134.39817188861,14557.536109686682,4818,9636,44864.463890313316,192917.19472834724,40046.463890313316,116134.74528190862,85,499916.8476183273,1.1304347826086956,565123.39295984816,2,282561.69647992408,17.660106029995255,0.14000000000000001,39558.637507189378,242625.60182811136,167328.00126076647,55,304232.72956502991,833.51432757542443,0,0,"–",167328.00126076647,304232.72956502991,"-","-","-",null,"-",304232.72956502991,24,1267.6363731876247,60,76058.182391257476]
[null,18000,788400,72270,0,0,"NEIN",0,788400,72270,9.166666666666666E-2,30,63.55659669729161,95,95,748980,476026.19794337475,16377.228123397517,5420.25,10840.5,50472.521876602485,217031.84406939067,45052.271876602485,130651.5884421472,85,562406.45357061818,1.1304347826086956,635763.81707982917,2,317881.90853991458,17.660106029995255,0.14000000000000001,44503.467195588048,272953.80205662531,188244.00141836228,55,342261.82076065871,937.7036185223526,0,0,"–",188244.00141836228,342261.82076065871,"-","-","-",null,"-",342261.82076065871,24,1426.090919836078,60,85565.455190164677]
[null,20000,876000,80300,0,0,"NEIN",0,876000,80300,9.166666666666666E-2,30,63.55659669729161,95,95,832200,528917.99771486083,18196.920137108355,6022.5,12045,56080.579862891645,241146.49341043408,50058.079862891645,145168.43160238577,85,624896.05952290911,1.1304347826086956,706404.24119981029,2,353202.12059990515,17.660106029995259,0.14000000000000001,49448.296883986724,303282.00228513923,209160.0015759581,55,380290.91195628745,1041.8929094692808,0,0,"–",209160.0015759581,380290.91195628745,"-","-","-",null,"-",380290.91195628745,24,1584.5454664845311,60,95072.727989071864]
[null,22000,963600,88330,0,0,"NEIN",0,963600,88330,9.166666666666666E-2,30,63.55659669729161,95,95,915420,581809.79748634691,20016.612150819186,6624.75,13249.5,61688.637849180814,265261.14275147748,55063.887849180814,159685.27476262435,85,687385.66547519993,1.1304347826086956,777044.66531979118,2,388522.33265989559,17.660106029995255,0.14000000000000001,54393.126572385387,333610.20251365314,230076.00173355389,55,418320.0031519162,1146.0822004162087,0,0,"–",230076.00173355389,418320.0031519162,"-","-","-",null,"-",418320.0031519162,24,1743.0000131329843,60,104580.00078797906]
[null,24000,1051200,96360,0,0,"NEIN",0,1051200,96360,9.166666666666666E-2,30,63.55659669729161,95,95,998640,634701.597257833,21836.304164530022,7227,14454,67296.695835469975,289375.79209252086,60069.695835469975,174202.11792286293,85,749875.27142749098,1.1304347826086956,847685.0894397723,2,423842.54471988615,17.660106029995255,0.14000000000000001,59337.956260784063,363938.40274216706,250992.0018911497,55,456349.09434754489,1250.2714913631366,0,0,"–",250992.0018911497,456349.09434754489,"-","-","-",null,"-",456349.09434754489,24,1901.454559781437,60,114087.27358688622]
[null,26000,1138800,104390,0,0,"NEIN",0,1138800,104390,9.166666666666666E-2,30,63.55659669729161,95,95,1081860,687593.39702931896,23655.996178240857,7829.25,15658.5,72904.753821759135,313490.44143356429,65075.503821759135,188718.96108310149,85,812364.8773797818,1.1304347826086956,918325.51355975331,2,459162.75677987665,17.660106029995255,0.14000000000000001,64282.78594918274,394266.60297068098,271908.00204874552,55,494378.18554317363,1354.4607823100648,0,0,"–",271908.00204874552,494378.18554317363,"-","-","-",null,"-",494378.18554317363,24,2059.9091064298905,60,123594.54638579342]
[null,28000,1226400,112420,0,0,"NEIN",0,1226400,112420,9.166666666666666E-2,30,63.55659669729161,95,95,1165080,740485.19680080505,25475.688191951693,8431.5,16863,78512.811808048311,337605.09077460773,70081.311808048311,203235.8042433401,85,874854.48333207262,1.1304347826086956,988965.9376797342,2,494482.9688398671,17.660106029995255,0.14000000000000001,69227.615637581403,424594.8031991949,292824.00220634131,55,532407.27673880232,1458.6500732569928,0,0,"–",292824.00220634131,532407.27673880232,"-","-","-",null,"-",532407.27673880232,24,2218.3636530783433,60,133101.81918470061]
[null,30000,1314000,120450,0,0,"NEIN",0,1314000,120450,9.166666666666666E-2,30,63.55659669729161,95,95,1248300,793376.99657229113,27295.380205662528,9033.75,18067.5,84120.869794337472,361719.7401156511,75087.119794337472,217752.64740357865,85,937344.08928436355,1.1304347826086956,1059606.3617997153,2,529803.18089985766,17.660106029995255,0.14000000000000001,74172.445325980079,454923.00342770881,313740.00236393715,55,570436.36793443118,1562.8393642039211,0,0,"–",313740.00236393715,570436.36793443118,"-","-","-",null,"-",570436.36793443118,24,2376.8181997267966,60,142609.0919836078]
[null,32000,1401600,128480,0,0,"NEIN",0,1401600,128480,9.166666666666666E-2,30,63.55659669729161,95,95,1331520,846268.79634377721,29115.072219373364,9636,19272,89728.927780626633,385834.38945669448,80092.927780626633,232269.49056381723,85,999833.6952366546,1.1304347826086956,1130246.7859196963,2,565123.39295984816,17.660106029995255,0.14000000000000001,79117.275014378756,485251.20365622273,334656.00252153294,55,608465.45913005981,1667.0286551508489,0,0,"–",334656.00252153294,608465.45913005981,"-","-","-",null,"-",608465.45913005981,24,2535.2727463752494,60,152116.36478251495]
[null,34000,1489200,136510,0,0,"NEIN",0,1489200,136510,9.166666666666666E-2,30,63.55659669729161,95,95,1414740,899160.5961152633,30934.764233084199,10238.25,20476.5,95336.985766915808,409949.03879773797,85098.735766915808,246786.33372405585,85,1062323.3011889453,1.1304347826086956,1200887.2100396771,2,600443.60501983855,17.660106029995251,0.14000000000000001,84062.104702777404,515579.40388473665,355572.00267912872,55,646494.55032568856,1771.2179460977768,0,0,"–",355572.00267912872,646494.55032568856,"-","-","-",null,"-",646494.55032568856,24,2693.7272930237023,60,161623.63758142214]
[null,36000,1576800,144540,0,0,"NEIN",0,1576800,144540,9.166666666666666E-2,30,63.55659669729161,95,95,1497960,952052.39588674949,32754.456246795035,10840.5,21681,100945.04375320497,434063.68813878135,90104.543753204969,261303.1768842944,85,1124812.9071412364,1.1304347826086956,1271527.6341596583,2,635763.81707982917,17.660106029995255,0.14000000000000001,89006.934391176095,545907.60411325062,376488.00283672457,55,684523.64152131742,1875.4072370447052,0,0,"–",376488.00283672457,684523.64152131742,"-","-","-",null,"-",684523.64152131742,24,2852.181839672156,60,171130.91038032935]
[null,38000,1664400,152570,0,0,"NEIN",0,1664400,152570,9.166666666666666E-2,30,63.55659669729161,95,95,1581180,1004944.1956582356,34574.14826050587,11442.75,22885.5,106553.10173949413,458178.33747982472,95110.35173949413,275820.02004453295,85,1187302.5130935274,1.1304347826086956,1342168.0582796396,2,671084.02913981979,17.660106029995259,0.14000000000000001,93951.764079574772,576235.80434176454,397404.00299432036,55,722552.73271694616,1979.5965279916334,0,0,"–",397404.00299432036,722552.73271694616,"-","-","-",null,"-",722552.73271694616,24,3010.6363863206093,60,180638.18317923657]
[null,40000,1752000,160600,0,0,"NEIN",0,1752000,160600,9.166666666666666E-2,30,63.55659669729161,95,95,1664400,1057835.9954297217,36393.840274216709,12045,24090,112161.15972578329,482292.98682086816,100116.15972578329,290336.86320477154,85,1249792.1190458182,1.1304347826086956,1412808.4823996206,2,706404.24119981029,17.660106029995259,0.14000000000000001,98896.593767973449,606564.00457027846,418320.0031519162,55,760581.82391257491,2083.7858189385615,0,0,"–",418320.0031519162,760581.82391257491,"-","-","-",null,"-",760581.82391257491,24,3169.0909329690621,60,190145.45597814373]
["Mittlere Belastung Kläranlage",{"$f":"'Dateneingabe und Ergebnisse'!F5","v":15000},657000,60225,0,0,"NEIN",0,657000,60225,9.166666666666666E-2,30,63.55659669729161,95,95,624150,396688.49828614556,13647.690102831264,4516.875,9033.75,42060.434897168736,180859.87005782555,37543.559897168736,108876.32370178933,85,468672.04464218178,{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},529803.18089985766,2,264901.59044992883,17.660106029995255,0.14000000000000001,37086.22266299004,227461.50171385441,156870.00118196858,55,285218.18396721559,781.41968210196057,0,0,"–",156870.00118196858,285218.18396721559,"-","-","-",null,"-",285218.18396721559,24,1188.4090998633983,60,71304.545991803898]
["Bemessung Aerobie",{"$f":"'Dateneingabe und Ergebnisse'!F6","v":20000},876000,80300,0,0,"NEIN",0,{"$f":"IF(G27=\"NEIN\",C27,C27*(1-H27/100))","v":876000},{"$f":"B27*0.011*365+E27","v":80300},{"$f":"J27/I27","v":9.166666666666666E-2},30,63.55659669729161,85,{"$f":"(N27-H27)/(100-H27)*100","v":85},{"$f":"I27*O27/100","v":744600},{"$f":"P27*M27/100","v":473242.41900803335},{"$f":"AH27*$R$2","v":16281.454859517999},{"$f":"J27*$S$2","v":6022.5},{"$f":"J27*T29","v":24090},{"$f":"J27-R27-T27+S27","v":45951.045140482005},{"$f":"U27*4.3","v":197589.49410407263},{"$f":"J27-R27-T27","v":39928.545140482005},{"$f":"W27*2.9","v":115792.78090739781},{"$f":"100-T27/J27*100","v":70},{"$f":"Q27+V27-X27","v":555039.13220470818},{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},{"$f":"Z27*AA27","v":627435.54075314838},null,null,null,null,null,{"$f":"P27*((100-M27)/100)","v":271357.58099196665},{"$f":"AH27/$AI$2","v":187143.15930480461},55,340260.28964509926,{"$f":"AK27/365","v":932.21997163040896},{"$f":"C27-I27","v":0},{"$f":"AM27/$AI$2","v":0},"–",187143.15930480461,340260.28964509926,"-","-","-",null,"-",340260.28964509926,24,1417.7512068545802,60,{"$f":"AY27*AZ27","v":85065.072411274814}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q6+AH6+AM6","v":83220},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":95},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.149425287356322}]
[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":876.0221816593762},{"$f":"E36/D36*100","v":10.90936714395238},{"$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":8906.0221816593767},{"$f":"J36/I36","v":0.10166691988195635},{"$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":95},{"$f":"(N36-H36)/(100-H36)*100","v":95},{"$f":"I36*O36/100","v":83220},{"$f":"P36*M36/100","v":47449.630305677063},{"$f":"AH36*$R$2","v":2146.222181659376},{"$f":"J36*$S$2","v":667.9516636244532},{"$f":"J36*$T$2","v":1335.9033272489064},{"$f":"J36-R36-T36+S36","v":6091.8483363755477},{"$f":"U36*4.3","v":26194.947846414852},{"$f":"J36-R36-T36","v":5423.8966727510942},{"$f":"W36*2.9","v":15729.300350978172},{"$f":"100-T36/J36*100","v":85},{"$f":"Q36+V36-X36","v":57915.277801113742},{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},{"$f":"Z36*AA36","v":65469.444470824223},{"$f":"'Dateneingabe und Ergebnisse'!I15","v":2},{"$f":"AB36/AC36","v":32734.722235412111},{"$f":"AD36/B36","v":16.367361117706057},{"$f":"'Dateneingabe und Ergebnisse'!F16","v":0.14000000000000001},{"$f":"AD36*AF36","v":4582.8611129576957},{"$f":"P36*((100-M36)/100)","v":35770.369694322937},{"$f":"AH36/$AI$2","v":24669.220478843406},{"$f":"'Dateneingabe und Ergebnisse'!I18","v":60},{"$f":"AI36/AJ36*100","v":41115.367464739014},{"$f":"AK36/365","v":112.64484236914798},{"$f":"C36-I36","v":0},{"$f":"AM36/$AI$2","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I17","v":"–"},{"$f":"AI36+AN36","v":24669.220478843406},{"$f":"IF(AO36<>\"–\",AK36+AN36/AO36*100,AK36)","v":41115.367464739014},{"$f":"'Fixe Parameter'!C4","v":20},{"$f":"AR36/1000*B36*365","v":14600},{"$f":"+AP36-AS36","v":10069.220478843406},{"$f":"AT36*$AI$2","v":14600.369694322939},{"$f":"AT36/AP36*100","v":40.816938206372917},{"$f":"AQ36-AT36","v":31046.146985895608},{"$f":"'Dateneingabe und Ergebnisse'!I21","v":26},{"$f":"AW36/(AX36/100)/1000","v":119.40825763806002},{"$f":"'Dateneingabe und Ergebnisse'!I22","v":60},{"$f":"AY36*AZ36","v":7164.4954582836017},null,null,null,null,null,null,null,null,null,{"$f":"'Dateneingabe und Ergebnisse'!I23","v":"NEIN"},{"$f":"AU36","v":14600.369694322939},0.35,{"$f":"BL36*BM36","v":5110.1293930130287},{"$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,1752.0443633187524,{"$f":"E37/D37*100","v":10.90936714395238},{"$f":"G36","v":"NEIN"},{"$f":"H36","v":0},175200,17812.044363318753,0.10166691988195635,{"$f":"L36","v":15},57.017099622298801,{"$f":"N36","v":95},{"$f":"(N37-H37)/(100-H37)*100","v":95},{"$f":"I37*O37/100","v":166440},{"$f":"P37*M37/100","v":94899.260611354126},4292.444363318752,{"$f":"J37*$S$2","v":1335.9033272489064},{"$f":"J37*$T$2","v":2671.8066544978128},{"$f":"J37-R37-T37+S37","v":12183.696672751095},{"$f":"U37*4.3","v":52389.895692829705},{"$f":"J37-R37-T37","v":10847.793345502188},{"$f":"W37*2.9","v":31458.600701956344},{"$f":"100-T37/J37*100","v":85},115830.55560222748,{"$f":"AA36","v":1.1304347826086956},130938.88894164845,{"$f":"AC36","v":2},65469.444470824223,16.367361117706057,{"$f":"AF36","v":0.14000000000000001},9165.7222259153914,{"$f":"P37*((100-M37)/100)","v":71540.739388645874},49338.440957686813,{"$f":"AJ36","v":60},{"$f":"AI37/AJ37*100","v":82230.734929478029},{"$f":"AK37/365","v":225.28968473829596},0,0,{"$f":"AO36","v":"–"},49338.440957686813,{"$f":"IF(AO37<>\"–\",AK37+AN37/AO37*100,AK37)","v":82230.734929478029},{"$f":"AR36","v":20},29200,20138.440957686813,{"$f":"AT37*$AI$2","v":29200.739388645878},40.816938206372917,{"$f":"AQ37-AT37","v":62092.293971791216},{"$f":"AX36","v":26},238.81651527612004,{"$f":"AZ36","v":60},14328.990916567203,null,null,null,null,null,null,null,null,null,{"$f":"BK36","v":"NEIN"},29200.739388645878,{"$f":"BM36","v":0.35},{"$f":"BL37*BM37","v":10220.258786026057},{"$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,2628.0665449781291,10.909367143952382,"NEIN",0,262800,26718.06654497813,0.10166691988195635,15,57.017099622298801,{"$f":"N37","v":95},95,249660,142348.89091703118,6438.6665449781285,2003.8549908733596,4007.7099817467192,18275.545009126643,78584.843539244568,16271.690018253283,{"$f":"W38*2.9","v":47187.901052934518},85,173745.83340334124,1.1304347826086956,196408.33341247268,2,98204.166706236341,16.367361117706057,0.14000000000000001,13748.58333887309,107311.10908296882,74007.661436530223,60,123346.10239421704,337.93452710744396,0,0,{"$f":"AO37","v":"–"},74007.661436530223,123346.10239421704,20,43800,30207.661436530223,43801.109082968826,40.816938206372924,{"$f":"AQ38-AT38","v":93138.44095768682},26,358.22477291418005,60,21493.486374850803,null,null,null,null,null,null,null,null,null,{"$f":"BK37","v":"NEIN"},43801.109082968826,{"$f":"BM37","v":0.35},{"$f":"BL38*BM38","v":15330.388179039088},{"$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,3504.0887266375048,10.90936714395238,"NEIN",0,350400,35624.088726637507,0.10166691988195635,15,57.017099622298801,95,95,332880,189798.52122270825,8584.8887266375041,2671.8066544978128,5343.6133089956256,24367.393345502191,104779.79138565941,21695.586691004377,{"$f":"W39*2.9","v":62917.201403912688},85,231661.11120445497,1.1304347826086956,261877.77788329689,2,130938.88894164845,16.367361117706057,0.14000000000000001,18331.444451830783,143081.47877729175,98676.881915373626,60,164461.46985895606,450.57936947659192,0,0,"–",98676.881915373626,164461.46985895606,20,58400,40276.881915373626,58401.478777291755,40.816938206372917,124184.58794358243,26,477.63303055224009,60,28657.981833134407,null,null,null,null,null,null,null,null,null,"NEIN",58401.478777291755,0.35,20440.517572052115,10,0,0,0,0,0]
[null,10000,438000,40150,4380.1109082968815,10.909367143952382,"NEIN",0,438000,44530.110908296883,0.10166691988195635,15,57.017099622298801,95,95,416100,237248.15152838532,10731.11090829688,3339.7583181222662,6679.5166362445325,30459.241681877735,130974.73923207425,27119.483363755469,78646.501754890865,85,289576.38900556869,1.1304347826086956,327347.2223541211,2,163673.61117706055,16.367361117706054,0.14000000000000001,22914.305564788479,178851.84847161468,123346.10239421703,60,205576.83732369504,563.22421184573989,0,0,"–",123346.10239421703,205576.83732369504,20,73000,50346.102394217029,73001.848471614692,40.816938206372917,155230.73492947803,26,597.04128819030007,60,35822.477291418007,null,null,null,null,null,null,null,null,null,"NEIN",73001.848471614692,0.35,{"$f":"BL40*BM40","v":25550.646965065142},{"$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,5256.1330899562581,10.909367143952382,"NEIN",0,525600,53436.13308995626,0.10166691988195635,15,57.017099622298801,95,95,499320,284697.78183406236,12877.333089956257,4007.7099817467192,8015.4199634934384,36551.090018253286,157169.68707848914,32543.380036506565,94375.802105869036,85,347491.66680668248,1.1304347826086956,392816.66682494537,2,196408.33341247268,16.367361117706057,0.14000000000000001,27497.16667774618,214622.21816593764,148015.32287306045,60,246692.20478843409,675.86905421488791,0,0,"–",148015.32287306045,246692.20478843409,20,87600,60415.322873060446,87602.218165937651,40.816938206372924,186276.88191537364,26,716.4495458283601,60,42986.972749701607,null,null,null,null,null,null,null,null,null,"NEIN",87602.218165937651,0.35,30660.776358078176,10,0,0,0,0,0]
[null,14000,613200,56210,6132.1552716156348,10.909367143952384,"NEIN",0,613200,62342.155271615637,0.10166691988195635,15,57.017099622298801,95,95,582540,332147.41213973943,15023.555271615633,4675.6616453711722,9351.3232907423444,42642.93835462883,183364.63492490395,37967.276709257661,110105.10245684722,85,405406.94460779615,1.1304347826086956,458286.11129576951,2,229143.05564788476,16.367361117706054,0.14000000000000001,32080.027790703869,250392.58786026057,172684.54335190385,60,287807.57225317304,788.51389658403571,0,0,"–",172684.54335190385,287807.57225317304,20,102200,70484.543351903849,102202.58786026058,40.816938206372924,217323.02890126919,26,835.85780346641991,60,50151.468207985192,null,null,null,null,null,null,null,null,null,"NEIN",102202.58786026058,0.35,35770.905751091203,10,0,0,0,0,0]
[null,16000,700800,64240,7008.1774532750096,10.90936714395238,"NEIN",0,700800,71248.177453275013,0.10166691988195635,15,57.017099622298801,95,95,665760,379597.0424454165,17169.777453275008,5343.6133089956256,10687.226617991251,48734.786691004381,209559.58277131882,43391.173382008754,125834.40280782538,85,463322.22240890993,1.1304347826086956,523755.55576659378,2,261877.77788329689,16.367361117706057,0.14000000000000001,36662.888903661566,286162.9575545835,197353.76383074725,60,328922.93971791212,901.15873895318384,0,0,"–",197353.76383074725,328922.93971791212,20,116800,80553.763830747252,116802.95755458351,40.816938206372917,248369.17588716486,26,955.26606110448017,60,57315.963666268814,null,null,null,null,null,null,null,null,null,"NEIN",116802.95755458351,0.35,40881.035144104229,10,0,0,0,0,0]
[null,18000,788400,72270,7884.1996349343863,10.909367143952382,"NEIN",0,788400,80154.199634934383,0.10166691988195635,15,57.017099622298801,95,95,748980,427046.67275109357,19315.999634934386,6011.5649726200782,12023.129945240156,54826.635027379918,235754.53061773363,48815.070054759839,141563.70315880352,85,521237.50021002372,1.1304347826086956,589225.00023741811,2,294612.50011870905,16.367361117706057,0.14000000000000001,41245.750016619269,321933.32724890643,222022.98430959065,60,370038.30718265107,1013.8035813223318,0,0,"–",222022.98430959065,370038.30718265107,20,131400,90622.984309590654,131403.32724890645,40.816938206372917,279415.32287306042,26,1074.67431874254,60,64480.459124552399,null,null,null,null,null,null,null,null,null,"NEIN",131403.32724890645,0.35,45991.164537117256,10,0,0,0,0,0]
[null,20000,876000,80300,8760.2218165937629,10.909367143952382,"NEIN",0,876000,89060.221816593767,0.10166691988195635,15,57.017099622298801,95,95,832200,474496.30305677064,21462.221816593759,6679.5166362445325,13359.033272489065,60918.483363755469,261949.4784641485,54238.966727510939,157293.00350978173,85,579152.77801113739,1.1304347826086956,654694.4447082422,2,327347.2223541211,16.367361117706054,0.14000000000000001,45828.611129576959,357703.69694322936,246692.20478843406,60,411153.67464739009,1126.4484236914798,0,0,"–",246692.20478843406,411153.67464739009,20,146000,100692.20478843406,146003.69694322938,40.816938206372917,310461.46985895606,26,1194.0825763806001,60,71644.954582836013,null,null,null,null,null,null,null,null,null,"NEIN",146003.69694322938,0.35,51101.293930130283,10,0,0,0,0,0]
[null,22000,963600,88330,9636.2439982531378,10.90936714395238,"NEIN",0,963600,97966.243998253136,0.10166691988195635,15,57.017099622298801,95,95,915420,521945.93336244771,23608.44399825314,7347.468299868985,14694.93659973797,67010.331700131006,288144.42631056329,59662.863400262017,173022.30386075983,85,637068.05581225117,1.1304347826086956,720163.88917906652,2,360081.94458953326,16.367361117706057,0.14000000000000001,50411.472242534663,393474.06663755234,271361.42526727746,60,452269.04211212916,1239.0932660606279,0,0,"–",271361.42526727746,452269.04211212916,20,160600,110761.42526727746,160604.06663755231,40.816938206372917,341507.6168448517,26,1313.4908340186603,60,78809.45004111962,null,null,null,null,null,null,null,null,null,"NEIN",160604.06663755231,0.35,56211.42332314331,10,0,0,0,0,0]
[null,24000,1051200,96360,10512.266179912516,10.909367143952382,"NEIN",0,1051200,106872.26617991252,0.10166691988195635,15,57.017099622298801,95,95,998640,569395.56366812473,25754.666179912514,8015.4199634934384,16030.839926986877,73102.180036506572,314339.37415697827,65086.760073013131,188751.60421173807,85,694983.33361336496,1.1304347826086956,785633.33364989073,2,392816.66682494537,16.367361117706057,0.14000000000000001,54994.333355492359,429244.43633187527,296030.64574612089,60,493384.40957686817,1351.7381084297758,0,0,"–",296030.64574612089,493384.40957686817,20,175200,120830.64574612089,175204.4363318753,40.816938206372924,372553.76383074728,26,1432.8990916567202,60,85973.945499403213,null,null,null,null,null,null,null,null,null,"NEIN",175204.4363318753,0.35,61321.552716156351,10,0,0,0,0,0]
[null,26000,1138800,104390,11388.288361571889,10.90936714395238,"NEIN",0,1138800,115778.28836157189,0.10166691988195635,15,57.017099622298801,95,95,1081860,616845.1939738018,27900.888361571891,8683.371627117891,17366.743254235782,79194.028372882094,340534.32200339297,70510.656745764209,204480.9045627162,85,752898.61141447863,1.1304347826086956,851102.77812071494,2,425551.38906035747,16.367361117706057,0.14000000000000001,59577.194468450049,465014.8060261982,320699.86622496427,60,534499.77704160707,1464.3829507989235,0,0,"–",320699.86622496427,534499.77704160707,20,189800,130899.86622496427,189804.80602619817,40.816938206372917,403599.91081664281,26,1552.3073492947801,60,93138.440957686806,null,null,null,null,null,null,null,null,null,"NEIN",189804.80602619817,0.35,66431.682109169356,10,0,0,0,0,0]
[null,28000,1226400,112420,12264.31054323127,10.909367143952384,"NEIN",0,1226400,124684.31054323127,0.10166691988195635,15,57.017099622298801,95,95,1165080,664294.82427947887,30047.110543231265,9351.3232907423444,18702.646581484689,85285.87670925766,366729.2698498079,75934.553418515323,220210.20491369444,85,810813.88921559229,1.1304347826086956,916572.22259153903,2,458286.11129576951,16.367361117706054,0.14000000000000001,64160.055581407738,500785.17572052113,345369.0867038077,60,575615.14450634609,1577.0277931680714,0,0,"–",345369.0867038077,575615.14450634609,20,204400,140969.0867038077,204405.17572052116,40.816938206372924,434646.05780253839,26,1671.7156069328398,60,100302.93641597038,null,null,null,null,null,null,null,null,null,"NEIN",204405.17572052116,0.35,71541.811502182405,10,0,0,0,0,0]
[null,30000,1314000,120450,13140.332724890644,10.909367143952382,"NEIN",0,1314000,133590.33272489064,0.10166691988195635,15,57.017099622298801,95,95,1248300,711744.45458515594,32193.332724890643,10019.274954366798,20038.549908733596,91377.725045633211,392924.21769622277,81358.450091266408,235939.50526467257,85,868729.16701670608,1.1304347826086956,982041.66706236335,2,491020.83353118168,16.367361117706057,0.14000000000000001,68742.916694365442,536555.54541484406,370038.30718265107,60,616730.51197108522,1689.6726355372198,0,0,"–",370038.30718265107,616730.51197108522,20,219000,151038.30718265107,219005.54541484403,40.816938206372917,465692.20478843414,26,1791.1238645709007,60,107467.43187425403,null,null,null,null,null,null,null,null,null,"NEIN",219005.54541484403,0.35,76651.94089519541,10,0,0,0,0,0]
[null,32000,1401600,128480,14016.354906550019,10.90936714395238,"NEIN",0,1401600,142496.35490655003,0.10166691988195635,15,57.017099622298801,95,95,1331520,759194.08489083301,34339.554906550016,10687.226617991251,21374.453235982503,97469.573382008763,419119.16554263764,86782.346764017508,251668.80561565075,85,926644.44481781987,1.1304347826086956,1047511.1115331876,2,523755.55576659378,16.367361117706057,0.14000000000000001,73325.777807323131,572325.91510916699,394707.5276614945,60,657845.87943582423,1802.3174779063677,0,0,"–",394707.5276614945,657845.87943582423,20,233600,161107.5276614945,233605.91510916702,40.816938206372917,496738.35177432973,26,1910.5321222089603,60,114631.92733253763,null,null,null,null,null,null,null,null,null,"NEIN",233605.91510916702,0.35,81762.070288208459,10,0,0,0,0,0]
[null,34000,1489200,136510,14892.377088209396,10.90936714395238,"NEIN",0,1489200,151402.37708820938,0.10166691988195634,15,57.017099622298801,95,95,1414740,806643.71519651008,36485.777088209397,11355.178281615703,22710.356563231406,103561.42171838427,445314.11338905233,92206.243436768564,267398.10596662882,85,984559.72261893353,1.1304347826086956,1112980.5560040118,2,556490.27800200589,16.367361117706057,0.14000000000000001,77908.638920280835,608096.28480348992,419376.74814033788,60,698961.24690056313,1914.9623202755154,0,0,"–",419376.74814033788,698961.24690056313,20,248200,171176.74814033788,248206.28480348992,40.816938206372917,527784.49876022525,26,2029.94037984702,60,121796.42279082121,null,null,null,null,null,null,null,null,null,"NEIN",248206.28480348992,0.35,86872.199681221464,10,0,0,0,0,0]
[null,36000,1576800,144540,15768.399269868773,10.909367143952382,"NEIN",0,1576800,160308.39926986877,0.10166691988195635,15,57.017099622298801,95,95,1497960,854093.34550218715,38631.999269868771,12023.129945240156,24046.259890480313,109653.27005475984,471509.06123546726,97630.140109519678,283127.40631760703,85,1042475.0004200474,1.1304347826086956,1178450.0004748362,2,589225.00023741811,16.367361117706057,0.14000000000000001,82491.500033238539,643866.65449781285,444045.96861918131,60,740076.61436530214,2027.6071626446635,0,0,"–",444045.96861918131,740076.61436530214,20,262800,181245.96861918131,262806.65449781291,40.816938206372917,558830.64574612083,26,2149.34863748508,60,128960.9182491048,null,null,null,null,null,null,null,null,null,"NEIN",262806.65449781291,0.35,91982.329074234513,10,0,0,0,0,0]
[null,38000,1664400,152570,16644.421451528146,10.90936714395238,"NEIN",0,1664400,169214.42145152815,0.10166691988195635,15,57.017099622298801,95,95,1581180,901542.97580786422,40778.221451528145,12691.081608864612,25382.163217729223,115745.1183911354,497704.00908188219,103054.03678227079,298856.70666858531,85,1100390.2782211611,1.1304347826086956,1243919.4449456602,2,621959.72247283009,16.367361117706054,0.14000000000000001,87074.361146196228,679637.02419213578,468715.18909802468,60,781191.98183004104,2140.252005013811,0,0,"–",468715.18909802468,781191.98183004104,20,277400,191315.18909802468,277407.02419213578,40.81693820637291,589876.79273201642,26,2268.7568951231401,60,136125.41370738842,null,null,null,null,null,null,null,null,null,"NEIN",277407.02419213578,0.35,97092.458467247518,10,0,0,0,0,0]
[null,40000,1752000,160600,17520.443633187526,10.909367143952382,"NEIN",0,1752000,178120.44363318753,0.10166691988195635,15,57.017099622298801,95,95,1664400,948992.60611354129,42924.443633187519,13359.033272489065,26718.06654497813,121836.96672751094,523898.956928297,108477.93345502188,314586.00701956346,85,1158305.5560222748,1.1304347826086956,1309388.8894164844,2,654694.4447082422,16.367361117706054,0.14000000000000001,91657.222259153918,715407.39388645871,493384.40957686811,60,822307.34929478017,2252.8968473829595,0,0,"–",493384.40957686811,822307.34929478017,20,292000,201384.40957686811,292007.39388645877,40.816938206372917,620922.93971791212,26,2388.1651527612003,60,143289.90916567203,null,null,null,null,null,null,null,null,null,"NEIN",292007.39388645877,0.35,102202.58786026057,10,0,0,0,0,0]
["Mittlere Belastung Kläranlage",{"$f":"'Dateneingabe und Ergebnisse'!I5","v":15000},657000,60225,6570.1663624453222,10.909367143952382,"NEIN",0,657000,66795.166362445321,0.10166691988195635,15,57.017099622298801,95,95,624150,355872.22729257797,16096.666362445321,5009.6374771833989,10019.274954366798,45688.862522816606,196462.10884811138,40679.225045633204,117969.75263233628,85,434364.58350835304,1.1304347826086956,491020.83353118168,2,245510.41676559084,16.367361117706057,0.14000000000000001,34371.458347182721,268277.77270742203,185019.15359132554,60,308365.25598554261,844.83631776860989,0,0,{"$f":"AO55","v":"–"},185019.15359132554,308365.25598554261,20,109500,75519.153591325536,109502.77270742202,40.816938206372917,232846.10239421707,26,895.56193228545033,60,53733.715937127017,null,null,null,null,null,null,null,null,null,{"$f":"BK55","v":"NEIN"},109502.77270742202,{"$f":"BM55","v":0.35},{"$f":"BL56*BM56","v":38325.970447597705},{"$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":22324.199044213747},977799.9181365621,89631.65916251819,9778.2467752551474,{"$f":"E57/D57*100","v":10.909367143952386},"NEIN",0,{"$f":"IF(G57=\"NEIN\",C57,C57*(1-H57/100))","v":977799.9181365621},{"$f":"B57*0.011*365+E57","v":99409.905937773336},{"$f":"J57/I57","v":0.10166691988195635},15,{"$f":"IF(G57=\"NEIN\",9.4345*LN(L57)+32.468-1,8.8152*LN(L57)+39.505-1)","v":57.017099622298801},95,{"$f":"(N57-H57)/(100-H57)*100","v":95},{"$f":"I57*O57/100","v":928909.92222973402},{"$f":"P57*M57/100","v":529637.49575914582},{"$f":"AH57*$R$2","v":23956.345588235294},{"$f":"J57*$S$2","v":7455.7429453329996},{"$f":"J57*$T$2","v":14911.485890665999},{"$f":"J57-R57-T57+S57","v":67997.817404205052},{"$f":"U57*4.3","v":292390.6148380817},{"$f":"J57-R57-T57","v":60542.074458872048},{"$f":"W57*2.9","v":175572.01593072893},{"$f":"100-T57/J57*100","v":85},{"$f":"Q57+V57-X57","v":646456.09466649848},1.1304347826086956,{"$f":"Z57*AA57","v":730776.45484038955},2,{"$f":"AB57/AC57","v":365388.22742019477},{"$f":"AD57/B57","v":16.367361117706057},0.14000000000000001,{"$f":"AD57*AF57","v":51154.351838827271},{"$f":"P57*((100-M57)/100)","v":399272.42647058825},{"$f":"AH57/$AI$2","v":275360.29411764711},60,458933.82352941181,{"$f":"AK57/365","v":1257.3529411764707},{"$f":"C57-I57","v":0},{"$f":"AM57/$AI$2","v":0},{"$f":"AO55","v":"–"},275360.29411764711,458933.82352941181,20,162966.65302276035,112393.64109488676,162970.7795875858,40.816938206372924,346540.18243452505,26,1332.8468555174038,60,{"$f":"AY57*AZ57","v":79970.811331044228}]
["Bemessung Anaerobie",{"$f":"'Dateneingabe und Ergebnisse'!I7","v":17000},{"$f":"B58*0.12*365","v":744600},{"$f":"B58*0.011*365","v":68255},7446.1885441046979,10.90936714395238,{"$f":"G56","v":"NEIN"},{"$f":"H56","v":0},744600,75701.188544104691,{"$f":"J58/I58","v":0.10166691988195634},{"$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":95},95,707370,{"$f":"P58*M58/100","v":403321.85759825504},{"$f":"AH58*$R$2","v":18242.888544104699},{"$f":"J58*$S$2","v":5677.5891408078514},{"$f":"J58*$T$2","v":11355.178281615703},{"$f":"J58-R58-T58+S58","v":51780.710859192135},{"$f":"U58*4.3","v":222657.05669452617},{"$f":"J58-R58-T58","v":46103.121718384282},{"$f":"W58*2.9","v":133699.05298331441},{"$f":"100-T58/J58*100","v":85},{"$f":"Q58+V58-X58","v":492279.86130946677},{"$f":"AA56","v":1.1304347826086956},{"$f":"Z58*AA58","v":556490.27800200589},{"$f":"AC56","v":2},{"$f":"AB58/AC58","v":278245.13900100294},16.367361117706057,{"$f":"AF56","v":0.14000000000000001},{"$f":"AD58*AF58","v":38954.319460140418},{"$f":"P58*((100-M58)/100)","v":304048.14240174496},209688.37407016894,{"$f":"AJ56","v":60},349480.62345028156,957.48116013775768,{"$f":"C58-I58","v":0},0,{"$f":"AO57","v":"–"},209688.37407016894,349480.62345028156,{"$f":"AR56","v":20},124100,85588.374070168938,124103.14240174496,40.816938206372917,263892.24938011263,{"$f":"AX56","v":26},1014.97018992351,{"$f":"AZ56","v":60},{"$f":"AY58*AZ58","v":60898.211395410603},null,{"$f":"AQ58","v":349480.62345028156},{"$f":"BC58/365","v":957.48116013775768},{"$f":"'Dateneingabe und Ergebnisse'!I19","v":3},{"$f":"BD58/(BE58/100)/1000","v":31.91603867125859},{"$f":"'Dateneingabe und Ergebnisse'!I20","v":30},{"$f":"BF58*BG58","v":957.48116013775768}]
["Bemessung Anaerobie_NEU",{"$f":"B58+B62*(B58/B60)","v":25300.75891677558},{"$f":"B59*0.12*365","v":1108173.2405547702},{"$f":"B59*0.011*365","v":101582.54705085394},11082.013011955822,{"$f":"E59/D59*100","v":10.909367143952373},"NEIN",0,{"$f":"IF(G59=\"NEIN\",C59,C59*(1-H59/100))","v":1108173.2405547702},{"$f":"B59*0.011*365+E59","v":112664.56006280976},{"$f":"J59/I59","v":0.10166691988195635},15,{"$f":"IF(G59=\"NEIN\",9.4345*LN(L59)+32.468-1,8.8152*LN(L59)+39.505-1)","v":57.017099622298801},95,{"$f":"(N59-H59)/(100-H59)*100","v":95},{"$f":"I59*O59/100","v":1052764.5785270317},{"$f":"P59*M59/100","v":600255.82852703182},{"$f":"AH59*$R$2","v":27150.524999999994},{"$f":"J59*$S$2","v":8449.842004710732},{"$f":"J59*$T$2","v":16899.684009421464},{"$f":"J59-R59-T59+S59","v":77064.19305809903},{"$f":"U59*4.3","v":331376.03014982579},{"$f":"J59-R59-T59","v":68614.351053388295},{"$f":"W59*2.9","v":198981.61805482605},{"$f":"100-T59/J59*100","v":85},{"$f":"Q59+V59-X59","v":732650.2406220315},1.1304347826086956,{"$f":"Z59*AA59","v":828213.31548577466},2,{"$f":"AB59/AC59","v":414106.65774288733},{"$f":"AD59/B59","v":16.367361117706054},0.14000000000000001,{"$f":"AD59*AF59","v":57974.932084004235},{"$f":"P59*((100-M59)/100)","v":452508.74999999994},{"$f":"AH59/$AI$2","v":312074.99999999994},60,520124.99999999988,{"$f":"AK59/365","v":1424.9999999999998},{"$f":"C59-I59","v":0},{"$f":"AM59/$AI$2","v":0},{"$f":"AO58","v":"–"},312074.99999999994,520124.99999999988,20,184695.54009246174,127379.4599075382,184700.21686593039,40.816938206372896,392745.54009246168,26,1510.559769586391,60,{"$f":"AY59*AZ59","v":90633.58617518346},null,{"$f":"AQ59","v":520124.99999999988},{"$f":"BC59/365","v":1424.9999999999998},{"$f":"BE58","v":3},{"$f":"BD59/(BE59/100)/1000","v":47.499999999999993},{"$f":"BG58","v":30},{"$f":"BF59*BG59","v":1424.9999999999998}]
["Bemessung Aerobie",{"$f":"'Dateneingabe und Ergebnisse'!I6","v":20000},{"$f":"B60*0.12*365","v":876000},{"$f":"B60*0.011*365","v":80300},{"$f":"E58","v":7446.1885441046979},{"$f":"F58","v":10.90936714395238},{"$f":"G58","v":"NEIN"},{"$f":"H58","v":0},876000,87746.188544104691,{"$f":"J60/I60","v":0.10016688189966289},{"$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,744600,{"$f":"P60*M60/100","v":424549.32378763688},{"$f":"AH60*$R$2","v":19203.040572741786},{"$f":"J60*$S$2","v":6580.9641408078514},{"$f":"J60*$T$64","v":26323.856563231406},{"$f":"J60-R60-T60+S60","v":48800.255548939356},{"$f":"U60*4.3","v":209841.09886043923},{"$f":"J60-R60-T60","v":42219.291408131503},{"$f":"W60*2.9","v":122435.94508358135},{"$f":"100-T60/J60*100","v":70},{"$f":"Q60+V60-X60","v":511954.47756449471},{"$f":"($AA$1/($AA$1-$AA$2))","v":1.1304347826086956},{"$f":"Z60*AA60","v":578731.14855116792},null,null,null,null,null,{"$f":"P60*((100-M60)/100)","v":320050.67621236312},220724.60428438836,{"$f":"AJ58","v":60},367874.34047398058,1007.874905408166,{"$f":"C60-I60","v":0},0,{"$f":"AO59","v":"–"},220724.60428438836,367874.34047398058,{"$f":"AR58","v":20},{"$f":"AS58","v":124100},{"$f":"AT58","v":85588.374070168938},124103.14240174496,{"$f":"AV58","v":40.816938206372917},282285.96640381165,{"$f":"AX58","v":26},1085.7152553992755,{"$f":"AZ58","v":60},{"$f":"AY60*AZ60","v":65142.915323956535}]
["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":9765.5987256183271},{"$f":"I62/(1-H61/100)","v":427733.22418208275},null,null,null,null,null,{"$f":"P62/O62*100","v":427733.22418208275},null,null,null,{"$f":"M60","v":57.017099622298801},null,{"$f":"O60","v":85},{"$f":"AH62+Q62","v":363573.24055477034},{"$f":"AH62/(100-M62)*M62","v":207298.91676713349},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI62*AI2","v":156274.32378763688},{"$f":"AK62*AJ62/100","v":107775.39571561165},{"$f":"AJ60","v":60},{"$f":"AL62*365","v":179625.65952601942},{"$f":"'Dateneingabe und Ergebnisse'!I37*'Dateneingabe und Ergebnisse'!I13/'Dateneingabe und Ergebnisse'!I12","v":492.125094591834}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q41+AH41+AM41","v":499320},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":95},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":9765.5987256183271},25427.252215835997,21790.377895244001,18159.677180313596]
[null,{"$f":"B58/B60","v":0.85},0.68571428571428572,0.8,0.96]
[null,{"$f":"B65*B66","v":8300.7589167755777},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":361.96857544097657},{"$f":"Bemessung!BA6-Bemessung!BA36","v":2342.7773406235829},{"$f":"D4+C4","v":2704.7459160645594},{"$f":"Bemessung!BT36","v":0},{"$f":"G24","v":0},{"$f":"$H$24*(B4/$B$24)","v":0},{"$f":"(IF(E4+F4-G4-H4<0,0,E4+F4-G4-H4))","v":2704.7459160645594}]
[null,4000,{"$f":"Bemessung!AG7-Bemessung!AG37","v":723.93715088195313},{"$f":"Bemessung!BA7-Bemessung!BA37","v":4685.5546812471657},5409.4918321291188,{"$f":"Bemessung!BT37","v":0},{"$f":"G4","v":0},{"$f":"$H$24*(B5/$B$24)","v":0},{"$f":"(IF(E5+F5-G5-H5<0,0,E5+F5-G5-H5))","v":5409.4918321291188}]
[null,6000,{"$f":"Bemessung!AG8-Bemessung!AG38","v":1085.9057263229261},{"$f":"Bemessung!BA8-Bemessung!BA38","v":7028.3320218707522},8114.2377481936783,{"$f":"Bemessung!BT38","v":0},{"$f":"G5","v":0},0,8114.2377481936783]
[null,8000,{"$f":"Bemessung!AG9-Bemessung!AG39","v":1447.8743017639063},{"$f":"Bemessung!BA9-Bemessung!BA39","v":9371.1093624943314},10818.983664258238,{"$f":"Bemessung!BT39","v":0},0,0,10818.983664258238]
[null,10000,{"$f":"Bemessung!AG10-Bemessung!AG40","v":1809.8428772048828},{"$f":"Bemessung!BA10-Bemessung!BA40","v":11713.886703117925},13523.729580322808,{"$f":"Bemessung!BT40","v":0},0,0,13523.729580322808]
[null,12000,{"$f":"Bemessung!AG11-Bemessung!AG41","v":2171.8114526458521},{"$f":"Bemessung!BA11-Bemessung!BA41","v":14056.664043741504},16228.475496387357,{"$f":"Bemessung!BT41","v":0},0,0,16228.475496387357]
[null,14000,{"$f":"Bemessung!AG12-Bemessung!AG42","v":2533.7800280868323},{"$f":"Bemessung!BA12-Bemessung!BA42","v":16399.441384365113},18933.221412451945,{"$f":"Bemessung!BT42","v":0},0,0,18933.221412451945]
[null,16000,{"$f":"Bemessung!AG13-Bemessung!AG43","v":2895.7486035278125},{"$f":"Bemessung!BA13-Bemessung!BA43","v":18742.218724988663},21637.967328516475,{"$f":"Bemessung!BT43","v":0},0,0,21637.967328516475]
[null,18000,{"$f":"Bemessung!AG14-Bemessung!AG44","v":3257.7171789687782},{"$f":"Bemessung!BA14-Bemessung!BA44","v":21084.996065612278},24342.713244581057,{"$f":"Bemessung!BT44","v":0},0,0,24342.713244581057]
[null,20000,{"$f":"Bemessung!AG15-Bemessung!AG45","v":3619.6857544097657},{"$f":"Bemessung!BA15-Bemessung!BA45","v":23427.77340623585},27047.459160645616,{"$f":"Bemessung!BT45","v":0},0,0,27047.459160645616]
[null,22000,{"$f":"Bemessung!AG16-Bemessung!AG46","v":3981.654329850724},{"$f":"Bemessung!BA16-Bemessung!BA46","v":25770.550746859444},29752.205076710168,{"$f":"Bemessung!BT46","v":0},0,0,29752.205076710168]
[null,24000,{"$f":"Bemessung!AG17-Bemessung!AG47","v":4343.6229052917042},{"$f":"Bemessung!BA17-Bemessung!BA47","v":28113.328087483009},32456.950992774713,{"$f":"Bemessung!BT47","v":0},0,0,32456.950992774713]
[null,26000,{"$f":"Bemessung!AG18-Bemessung!AG48","v":4705.5914807326917},{"$f":"Bemessung!BA18-Bemessung!BA48","v":30456.105428106617},35161.696908839309,{"$f":"Bemessung!BT48","v":0},0,0,35161.696908839309]
[null,28000,{"$f":"Bemessung!AG19-Bemessung!AG49","v":5067.5600561736646},{"$f":"Bemessung!BA19-Bemessung!BA49","v":32798.882768730226},37866.44282490389,{"$f":"Bemessung!BT49","v":0},0,0,37866.44282490389]
[null,30000,{"$f":"Bemessung!AG20-Bemessung!AG50","v":5429.5286316146376},{"$f":"Bemessung!BA20-Bemessung!BA50","v":35141.660109353761},40571.188740968399,{"$f":"Bemessung!BT50","v":0},0,0,40571.188740968399]
[null,32000,{"$f":"Bemessung!AG21-Bemessung!AG51","v":5791.497207055625},{"$f":"Bemessung!BA21-Bemessung!BA51","v":37484.437449977326},43275.934657032951,{"$f":"Bemessung!BT51","v":0},0,0,43275.934657032951]
[null,34000,{"$f":"Bemessung!AG22-Bemessung!AG52","v":6153.4657824965689},{"$f":"Bemessung!BA22-Bemessung!BA52","v":39827.214790600934},45980.680573097503,{"$f":"Bemessung!BT52","v":0},0,0,45980.680573097503]
[null,36000,{"$f":"Bemessung!AG23-Bemessung!AG53","v":6515.4343579375563},{"$f":"Bemessung!BA23-Bemessung!BA53","v":42169.992131224557},48685.426489162113,{"$f":"Bemessung!BT53","v":0},0,0,48685.426489162113]
[null,38000,{"$f":"Bemessung!AG24-Bemessung!AG54","v":6877.4029333785438},{"$f":"Bemessung!BA24-Bemessung!BA54","v":44512.769471848151},51390.172405226695,{"$f":"Bemessung!BT54","v":0},0,0,51390.172405226695]
[null,40000,{"$f":"Bemessung!AG25-Bemessung!AG55","v":7239.3715088195313},{"$f":"Bemessung!BA25-Bemessung!BA55","v":46855.546812471701},54094.918321291232,{"$f":"Bemessung!BT55","v":0},0,0,54094.918321291232]
["Ersparnis bei derzeitiger (mittlerer) Belastung",{"$f":"'Dateneingabe und Ergebnisse'!F5","v":15000},{"$f":"Bemessung!AG26-Bemessung!AG56","v":2714.7643158073188},{"$f":"Bemessung!BA26-Bemessung!BA56","v":17570.830054676881},20285.594370484199,{"$f":"Bemessung!BT56","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I68","v":0},{"$f":"'Dateneingabe und Ergebnisse'!I60","v":0},{"$f":"E24+F24-G24","v":20285.594370484199}]

{"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":2704.7459160645594},2000,{"$f":"IF(C$2/$A4>50,#N/A,C$2/$A4)","v":0},{"$f":"IF(D$2/$A4>50,#N/A,D$2/$A4)","v":{"$error":"#N/A"}},{"$f":"IF(E$2/$A4>50,#N/A,E$2/$A4)","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":5409.4918321291188},4000,{"$f":"IF(C$2/$A5>50,#N/A,C$2/$A5)","v":0},{"$f":"IF(D$2/$A5>50,#N/A,D$2/$A5)","v":36.972049539315435},{"$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!I6","v":8114.2377481936783},6000,0,24.648033026210289,49.296066052420578,{"$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":10818.983664258238},8000,0,18.486024769657718,36.972049539315435,{"$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":13523.729580322808},10000,0,14.788819815726162,29.577639631452325,44.366459447178485,{"$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":16228.475496387357},12000,0,12.324016513105144,24.648033026210289,36.972049539315435,49.296066052420578,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I10","v":18933.221412451945},14000,0,10.56344272551868,21.12688545103736,31.69032817655604,42.25377090207472,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I11","v":21637.967328516475},16000,0,9.2430123848288588,18.486024769657718,27.729037154486576,36.972049539315435,46.215061924144294,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I12","v":24342.713244581057},18000,0,8.2160110087367553,16.432022017473511,24.648033026210268,32.864044034947021,41.080055043683778,49.296066052420535,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I13","v":27047.459160645616},20000,0,7.3944099078630812,14.788819815726162,22.183229723589243,29.577639631452325,36.972049539315407,44.366459447178485,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I14","v":29752.205076710168},22000,0,6.7221908253300757,13.444381650660151,20.166572475990229,26.888763301320303,33.610954126650377,40.333144951980458,47.055335777310532,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I15","v":32456.950992774713},24000,0,6.1620082565525722,12.324016513105144,18.486024769657718,24.648033026210289,30.810041282762864,36.972049539315435,43.13405779586801,49.296066052420578,{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I16","v":35161.696908839309},26000,0,5.6880076214331377,11.376015242866275,17.064022864299414,22.752030485732551,28.440038107165691,34.128045728598828,39.816053350031964,45.504060971465101,{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I17","v":37866.44282490389},28000,0,5.28172136275934,10.56344272551868,15.84516408827802,21.12688545103736,26.408606813796698,31.69032817655604,36.972049539315378,42.25377090207472,47.535492264834062,{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I18","v":40571.188740968399},30000,0,4.9296066052420571,9.8592132104841141,14.788819815726171,19.718426420968228,24.648033026210285,29.577639631452342,34.507246236694399,39.436852841936457,44.366459447178514,49.296066052420571]
[{"$f":"Betriebskostenersparnis!I19","v":43275.934657032951},32000,0,4.6215061924144294,9.2430123848288588,13.864518577243288,18.486024769657718,23.107530962072147,27.729037154486576,32.350543346901006,36.972049539315435,41.593555731729865,46.215061924144294]
[{"$f":"Betriebskostenersparnis!I20","v":45980.680573097503},34000,0,4.3496528869782871,8.6993057739565742,13.048958660934861,17.398611547913148,21.748264434891436,26.097917321869723,30.44757020884801,34.797223095826297,39.146875982804588,43.496528869782871]
[{"$f":"Betriebskostenersparnis!I21","v":48685.426489162113},36000,0,4.1080055043683776,8.2160110087367553,12.324016513105134,16.432022017473511,20.540027521841889,24.648033026210268,28.756038530578646,32.864044034947021,36.9720495393154,41.080055043683778]
[{"$f":"Betriebskostenersparnis!I22","v":51390.172405226695},38000,0,3.8917946883489885,7.7835893766979769,11.675384065046964,15.567178753395954,19.458973441744941,23.350768130093929,27.242562818442916,31.134357506791908,35.026152195140895,38.917946883489883]
[{"$f":"Betriebskostenersparnis!I23","v":54094.918321291232},40000,0,3.6972049539315406,7.3944099078630812,11.091614861794621,14.788819815726162,18.486024769657703,22.183229723589243,25.880434677520785,29.577639631452325,33.274844585383867,36.972049539315407]
[]
["Berechnung statische Armortisationszeit","KLÄRANLAGE X"]
["Betriebskostenänderung","Einwohnerwerte","Investitionskostendifferenz","Armotisationszeit",null,"Aufsummierte Kosten (Formel !!)"]
["Euro/Jahr","EW"]
[null,0,0,{"$f":"D29","v":9.8592132104841141}]
[{"$f":"Betriebskostenersparnis!I24","v":20285.594370484199},{"$f":"Betriebskostenersparnis!B24","v":15000},{"$f":"IF('Berechnung Grafik Statisch 2'!L18<0,'Dateneingabe und Ergebnisse'!F74,'Dateneingabe und Ergebnisse'!#REF!)","v":200000},{"$f":"IF(C29/A29>60,#N/A,C29/A29)","v":9.8592132104841141}]
[null,{"$f":"B29","v":15000},{"$f":"C29","v":200000},0]
[]
["Berechnung für tA = f (IKD)"]
["Betriebskostenänderung","Einwohnerwerte"]
["Euro/Jahr","EW","Amortisationszeit"]
[{"$f":"A29","v":20285.594370484199},{"$f":"B29","v":15000},{"$f":"IF(C$2/$A35>50,#N/A,C$2/$A35)","v":0},9.8592132104841141,19.718426420968228,29.577639631452342,39.436852841936457,49.296066052420571,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"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":600000},0,{"$f":"B5+C5","v":600000},{"$f":"'Dateneingabe und Ergebnisse'!I64","v":800000},0,0,{"$f":"E5+F5-G5","v":800000},0,{"$f":"D5/1000000","v":0.6},{"$f":"H5/1000000","v":0.8},{"$f":"(K5-J5)*1000000","v":200000.00000000006},{"$f":"ABS(L5)","v":200000.00000000006},null,{"$f":"C5-F5+G5","v":0},{"$f":"(E5+E19)/O6","v":55.211593978711022}]
[1,0,{"$f":"Bemessung!BA26+Bemessung!AG26","v":108390.76865479394},{"$f":"D5+C6+B6","v":708390.76865479397},0,{"$f":"Bemessung!BA56+Bemessung!AG56","v":88105.174284309731},{"$f":"Bemessung!BT56","v":0},{"$f":"H5+E6+F6-G6","v":888105.17428430973},{"$f":"A6","v":1},{"$f":"D6/1000000","v":0.708390768654794},{"$f":"H6/1000000","v":0.88810517428430968},{"$f":"(K6-J6)*1000000","v":179714.40562951568},{"$f":"ABS(L6)","v":179714.40562951568},null,20285.594370484207]
[2,{"$f":"B6","v":0},{"$f":"C6","v":108390.76865479394},{"$f":"D6+C7+B7","v":816781.53730958793},0,{"$f":"F6","v":88105.174284309731},{"$f":"G6","v":0},{"$f":"H6+E7+F7-G7","v":976210.34856861946},2,0.81678153730958791,0.97621034856861943,159428.81125903153,159428.81125903153,null,20285.594370484207]
[3,{"$f":"B7","v":0},{"$f":"C7","v":108390.76865479394},925172.3059643819,0,{"$f":"F7","v":88105.174284309731},{"$f":"G7","v":0},1064315.5228529293,3,0.92517230596438194,1.0643155228529293,139143.21688854735,139143.21688854735,null,20285.594370484207]
[4,0,108390.76865479394,1033563.0746191759,0,88105.174284309731,0,1152420.6971372389,4,1.033563074619176,1.1524206971372388,118857.62251806287,118857.62251806287,null,20285.594370484207]
[5,0,108390.76865479394,1141953.8432739698,0,88105.174284309731,0,1240525.8714215485,5,1.1419538432739698,1.2405258714215486,98572.028147578822,98572.028147578822,null,20285.594370484207]
[6,0,108390.76865479394,1250344.6119287638,0,88105.174284309731,0,1328631.0457058582,6,1.2503446119287638,1.3286310457058581,78286.433777094324,78286.433777094324,null,20285.594370484207]
[7,0,108390.76865479394,1358735.3805835578,0,88105.174284309731,0,1416736.2199901678,7,1.3587353805835578,1.4167362199901679,58000.839406610052,58000.839406610052,null,20285.594370484207]
[8,0,108390.76865479394,1467126.1492383517,0,88105.174284309731,0,1504841.3942744774,8,1.4671261492383518,1.5048413942744774,37715.245036125554,37715.245036125554,null,20285.594370484207]
[9,0,108390.76865479394,1575516.9178931457,0,88105.174284309731,0,1592946.568558787,9,1.5755169178931456,1.5929465685587869,17429.650665641282,17429.650665641282,null,20285.594370484207]
[10,0,108390.76865479394,1683907.6865479397,0,88105.174284309731,0,1681051.7428430966,10,1.6839076865479397,1.6810517428430967,-2855.9437048429891,2855.9437048429891,null,20285.594370484207]
[11,0,108390.76865479394,1792298.4552027336,0,88105.174284309731,0,1769156.9171274062,11,1.7922984552027337,1.7691569171274062,-23141.538075327484,23141.538075327484,null,20285.594370484207]
[12,0,108390.76865479394,1900689.2238575276,0,88105.174284309731,0,1857262.0914117158,12,1.9006892238575277,1.8572620914117159,-43427.132445811752,43427.132445811752,null,20285.594370484207]
[12.5,0,{"$f":"C17/2","v":54195.384327396969},1954884.6081849246,0,{"$f":"F17/2","v":44052.587142154865},{"$f":"G17/2","v":0},1901314.6785538706,12.5,1.9548846081849245,1.9013146785538706,-53569.929631053892,53569.929631053892]
[12.5,{"$f":"'Dateneingabe und Ergebnisse'!F52*'Dateneingabe und Ergebnisse'!F54/100","v":240000},0,2194884.6081849243,{"$f":"'Dateneingabe und Ergebnisse'!I53*'Dateneingabe und Ergebnisse'!I54/100+'Dateneingabe und Ergebnisse'!I56","v":320000},0,0,2221314.6785538709,12.5,2.1948846081849243,2.2213146785538709,26430.070368946625,26430.070368946625]
[13,{"$f":"B17","v":0},{"$f":"C17/2","v":54195.384327396969},2249079.9925123211,0,{"$f":"F17/2","v":44052.587142154865},{"$f":"G17/2","v":0},2265367.2656960259,13,2.2490799925123213,2.265367265696026,16287.273183704709,16287.273183704709,null,10142.797185242103]
[14,0,{"$f":"C17","v":108390.76865479394},2357470.7611671151,0,{"$f":"F17","v":88105.174284309731},{"$f":"G17","v":0},2353472.4399803355,14,2.3574707611671148,2.3534724399803357,-3998.3211867791192,3998.3211867791192,null,20285.594370484207]
[15,{"$f":"B21","v":0},{"$f":"C21","v":108390.76865479394},2465861.529821909,0,88105.174284309731,{"$f":"G21","v":0},2441577.6142646451,15,2.4658615298219089,2.441577614264645,-24283.915557263834,24283.915557263834,null,20285.594370484207]
[16,0,108390.76865479394,2574252.298476703,0,{"$f":"F22","v":88105.174284309731},{"$f":"G22","v":0},2529682.7885489548,16,2.5742522984767029,2.5296827885489548,-44569.509927748106,44569.509927748106,null,20285.594370484207]
[17,{"$f":"B23","v":0},108390.76865479394,2682643.067131497,0,88105.174284309731,0,2617787.9628332644,17,2.6826430671314969,2.6177879628332645,-64855.104298232378,64855.104298232378,null,20285.594370484207]
[18,{"$f":"B24","v":0},108390.76865479394,2791033.8357862909,0,88105.174284309731,0,2705893.137117574,18,2.7910338357862909,2.7058931371175738,-85140.698668717101,85140.698668717101,null,20285.594370484207]
[19,0,108390.76865479394,2899424.6044410849,0,88105.174284309731,0,2793998.3114018836,19,2.899424604441085,2.7939983114018836,-105426.29303920137,105426.29303920137,null,20285.594370484207]
[20,0,108390.76865479394,3007815.3730958789,0,88105.174284309731,0,2882103.4856861932,20,3.007815373095879,2.8821034856861933,-125711.88740968565,125711.88740968565,null,20285.594370484207]
[21,0,108390.76865479394,3116206.1417506728,0,88105.174284309731,0,2970208.6599705028,21,3.116206141750673,2.9702086599705027,-145997.48178017035,145997.48178017035,null,20285.594370484207]
[22,0,108390.76865479394,3224596.9104054668,0,88105.174284309731,0,3058313.8342548124,22,3.2245969104054666,3.0583138342548124,-166283.07615065417,166283.07615065417,null,20285.594370484207]
[23,0,108390.76865479394,3332987.6790602608,0,88105.174284309731,0,3146419.0085391221,23,3.3329876790602606,3.1464190085391222,-186568.67052113847,186568.67052113847,null,20285.594370484207]
[24,0,108390.76865479394,3441378.4477150547,0,88105.174284309731,0,3234524.1828234317,24,3.4413784477150546,3.2345241828234315,-206854.26489162317,206854.26489162317,null,20285.594370484207]
[25,0,108390.76865479394,3549769.2163698487,0,88105.174284309731,0,3322629.3571077413,25,3.5497692163698487,3.3226293571077412,-227139.85926210743,227139.85926210743,null,20285.594370484207]
[26,0,108390.76865479394,3658159.9850246427,0,88105.174284309731,0,3410734.5313920509,26,3.6581599850246427,3.410734531392051,-247425.45363259173,247425.45363259173,null,20285.594370484207]
[27,0,108390.76865479394,3766550.7536794366,0,88105.174284309731,0,3498839.7056763605,27,3.7665507536794367,3.4988397056763607,-267711.04800307599,267711.04800307599,null,20285.594370484207]
[28,0,108390.76865479394,3874941.5223342306,0,88105.174284309731,0,3586944.8799606701,28,3.8749415223342307,3.58694487996067,-287996.64237356069,287996.64237356069,null,20285.594370484207]
[29,0,108390.76865479394,3983332.2909890246,0,88105.174284309731,0,3675050.0542449798,29,3.9833322909890247,3.6750500542449798,-308282.23674404499,308282.23674404499,null,20285.594370484207]
[30,0,108390.76865479394,4091723.0596438185,0,88105.174284309731,0,3763155.2285292894,30,4.0917230596438188,3.7631552285292895,-328567.83111452922,328567.83111452922,null,20285.594370484207]

{"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":0.03},"EW","Amortisationszeit"]
[{"$f":"Betriebskostenersparnis!I4","v":2704.7459160645594},2000,{"$f":"C$2/$A4","v":0},{"$f":"D$2/$A4","v":73.94409907863087},{"$f":"E$2/$A4","v":147.88819815726174},221.83229723589261,{"$f":"G$2/$A4","v":295.77639631452348},369.72049539315435,443.66459447178522,517.60869355041609,591.55279262904696,665.49689170767783,{"$f":"M$2/$A4","v":739.4409907863087},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":5409.4918321291188},4000,{"$f":"C$2/$A5","v":0},36.972049539315435,73.94409907863087,110.91614861794631,147.88819815726174,184.86024769657718,221.83229723589261,258.80434677520805,295.77639631452348,332.74844585383892,369.72049539315435,null,{"$f":"'Dateneingabe und Ergebnisse'!F58/100","v":0.03},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":8114.2377481936783},6000,0,24.648033026210289,49.296066052420578,73.94409907863087,98.592132104841156,123.24016513105146,147.88819815726174,172.53623118347204,197.18426420968231,221.83229723589261,246.48033026210291,null,null,6000,0,45.500014160168888,{"$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":10818.983664258238},8000,0,18.486024769657718,36.972049539315435,55.458074308973153,73.94409907863087,92.430123848288588,110.91614861794631,129.40217338760402,147.88819815726174,166.37422292691946,184.86024769657718,null,null,8000,0,27.36035389364168,{"$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":13523.729580322808},10000,0,14.788819815726162,29.577639631452325,44.366459447178485,59.155279262904649,73.944099078630813,88.73291889435697,103.52173871008314,118.3105585258093,133.09937834153547,147.88819815726163,null,null,10000,0,19.837878222110046,{"$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":16228.475496387357},12000,0,12.324016513105144,24.648033026210289,36.972049539315435,49.296066052420578,61.620082565525728,73.94409907863087,86.26811559173602,98.592132104841156,110.91614861794631,123.24016513105146,null,null,12000,0,15.616055620442319,45.500014160168888,{"$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":18933.221412451945},14000,0,10.56344272551868,21.12688545103736,31.69032817655604,42.25377090207472,52.817213627593397,63.38065635311208,73.944099078630757,84.50754180414944,95.070984529668124,105.63442725518679,null,null,14000,0,12.893581355757068,33.986274614381003,{"$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":21637.967328516475},16000,0,9.2430123848288588,18.486024769657718,27.729037154486576,36.972049539315435,46.215061924144294,55.458074308973153,64.701086693802011,73.94409907863087,83.187111463459729,92.430123848288588,null,null,16000,0,10.98649922397804,27.36035389364168,{"$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":24342.713244581057},18000,0,8.2160110087367553,16.432022017473511,24.648033026210268,32.864044034947021,41.080055043683778,49.296066052420535,57.512077061157292,65.728088069894042,73.944099078630799,82.160110087367556,null,null,18000,0,9.5741415517282675,22.976799945977604,45.500014160168796,{"$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":27047.459160645616},20000,0,7.3944099078630812,14.788819815726162,22.183229723589243,29.577639631452325,{"$f":"H$2/$A13","v":36.972049539315407},44.366459447178485,51.760869355041571,59.155279262904649,66.549689170767735,73.944099078630813,null,null,20000,0,8.4852295343711823,19.837878222110046,37.048493986814485,{"$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":29752.205076710168},22000,0,6.7221908253300757,13.444381650660151,20.166572475990229,26.888763301320303,33.610954126650377,40.333144951980458,47.055335777310532,53.777526602640606,60.49971742797068,{"$f":"M$2/$A14","v":67.221908253300754},null,null,22000,0,7.6196550903512064,17.470041829545764,31.424221888085867,{"$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":32456.950992774713},24000,0,6.1620082565525722,12.324016513105144,18.486024769657718,24.648033026210289,30.810041282762864,36.972049539315435,43.13405779586801,49.296066052420578,55.458074308973153,61.620082565525728,null,null,24000,0,6.9148845596751061,15.616055620442319,27.36035389364168,45.500014160168888,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I16","v":35161.696908839309},26000,0,5.6880076214331377,11.376015242866275,17.064022864299414,22.752030485732551,28.440038107165691,34.128045728598828,39.816053350031964,45.504060971465101,51.192068592898245,56.880076214331382,null,null,26000,0,6.3297976056152461,14.122947599613711,24.26611713289233,38.819886090077929,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I17","v":37866.44282490389},28000,0,5.28172136275934,10.56344272551868,15.84516408827802,21.12688545103736,26.408606813796698,31.69032817655604,36.972049539315378,42.25377090207472,47.535492264834062,52.817213627593397,null,null,28000,0,5.8362242771587454,12.893581355757068,21.822037404608796,33.986274614381003,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I18","v":40571.188740968399},30000,0,4.9296066052420571,9.8592132104841141,14.788819815726171,19.718426420968228,24.648033026210285,29.577639631452342,34.507246236694399,39.436852841936457,44.366459447178514,49.296066052420571,null,null,30000,0,5.414209162938846,11.863111079989181,19.837878222110067,30.291911053731639,45.500014160168867,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I19","v":43275.934657032951},32000,0,4.6215061924144294,9.2430123848288588,13.864518577243288,18.486024769657718,23.107530962072147,27.729037154486576,32.350543346901006,36.972049539315435,41.593555731729865,46.215061924144294,null,null,32000,0,5.0492155507664558,10.98649922397804,18.192345914019757,27.36035389364168,39.976035473185597,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I20","v":45980.680573097503},34000,0,{"$f":"D$2/$A20","v":4.3496528869782871},8.6993057739565742,13.048958660934861,{"$f":"G$2/$A20","v":17.398611547913148},21.748264434891436,26.097917321869723,30.44757020884801,34.797223095826297,39.146875982804588,43.496528869782871,null,null,34000,0,4.7304003666806684,10.231442180110808,16.804030967554187,24.969124354625457,35.7538435964344,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I21","v":48685.426489162113},36000,0,4.1080055043683776,8.2160110087367553,12.324016513105134,{"$f":"G$2/$A21","v":16.432022017473511},20.540027521841889,24.648033026210268,28.756038530578646,32.864044034947021,36.9720495393154,41.080055043683778,null,null,36000,0,4.4495095415103005,9.5741415517282675,15.6160556204423,22.976799945977604,32.397653966142691,45.500014160168796,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I22","v":51390.172405226695},38000,0,3.8917946883489885,7.7835893766979769,11.675384065046964,{"$f":"G$2/$A22","v":15.567178753395954},19.458973441744941,23.350768130093929,27.242562818442916,31.134357506791908,35.026152195140895,38.917946883489883,null,null,38000,0,4.2001478968675618,8.9966636609327235,14.587375191785666,21.288503944861869,29.653277745447117,40.790482502601066,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"Betriebskostenersparnis!I23","v":54094.918321291232},40000,0,3.6972049539315406,7.3944099078630812,11.091614861794621,{"$f":"G$2/$A23","v":14.788819815726162},18.486024769657703,22.183229723589243,25.880434677520785,29.577639631452325,33.274844585383867,36.972049539315407,null,null,40000,0,3.9772831774713149,8.4852295343711823,13.687569550783936,19.837878222110046,27.360353893641648,37.048493986814485,{"$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":11.863111079989181}]
[{"$f":"Betriebskostenersparnis!I24","v":20285.594370484199},{"$f":"Betriebskostenersparnis!B24","v":15000},{"$f":"IF('Berechnung Grafik Dynamisch  2'!Q18<0,'Dateneingabe und Ergebnisse'!F74,'Dateneingabe und Ergebnisse'!F75)","v":200000},{"$f":"C31/A31","v":9.8592132104841141},null,null,null,null,null,null,null,null,null,null,{"$f":"A31","v":20285.594370484199},{"$f":"Betriebskostenersparnis!B24","v":15000},{"$f":"IF(ISERROR(LOG(1/(1-$O$3*D31),1+$O$3)),\"\",(LOG(1/(1-$O$3*D31),1+$O$3)))","v":11.863111079989181}]
[null,null,{"$f":"C31","v":200000},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P31","v":15000},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":20285.594370484199},{"$f":"B31","v":15000},{"$f":"C$2/$A37","v":0},9.8592132104841141,19.718426420968228,29.577639631452342,39.436852841936457,49.296066052420571,59.155279262904685,69.014492473388799,78.873705683872913,88.732918894357027,98.592132104841141,null,{"$f":"O31","v":20285.594370484199},{"$f":"P31","v":15000},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":11.863111079989181},{"$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":30.291911053731639},{"$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":600000},{"$f":"B5","v":600000},0,null,{"$f":"B5+E5","v":600000},{"$f":"'Dateneingabe und Ergebnisse'!I64","v":800000},{"$f":"G5","v":800000},0,0,{"$f":"I5+J5","v":0},0,{"$f":"G5","v":800000},0,{"$f":"F5/1000000","v":0.6},{"$f":"M5/1000000","v":0.8},{"$f":"(P5-O5)*1000000","v":200000.00000000006},null,null,{"$f":"D5-I5+J5","v":0},{"$f":"(G5+G19)/T6","v":55.211593978711022}]
[1,null,null,{"$f":"'Dateneingabe und Ergebnisse'!F70","v":108390.76865479394},{"$f":"D6/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A6","v":105233.7559755281},{"$f":"F5+E6","v":705233.75597552815},0,null,{"$f":"'Dateneingabe und Ergebnisse'!I66+'Dateneingabe und Ergebnisse'!I67+'Dateneingabe und Ergebnisse'!I68","v":88105.174284309731},{"$f":"Bemessung!BT56","v":0},{"$f":"I6-J6","v":88105.174284309731},{"$f":"K6/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A6","v":85539.004159524004},{"$f":"M5+L6","v":885539.00415952399},{"$f":"A6","v":1},{"$f":"F6/1000000","v":0.70523375597552818},{"$f":"M6/1000000","v":0.88553900415952402},{"$f":"(P6-O6)*1000000","v":180305.24818399583},null,null,20285.594370484207]
[2,null,null,{"$f":"D6","v":108390.76865479394},{"$f":"D7/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A7","v":102168.69512187195},{"$f":"F6+E7","v":807402.45109740016},0,null,{"$f":"I6","v":88105.174284309731},{"$f":"J6","v":0},{"$f":"I7-J7","v":88105.174284309731},{"$f":"K7/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A7","v":83047.576853906809},{"$f":"M6+L7","v":968586.58101343084},2,0.80740245109740016,0.96858658101343087,161184.12991603071,null,null,20285.594370484207]
[3,null,null,{"$f":"D7","v":108390.76865479394},{"$f":"D8/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A8","v":99192.907885312554},906595.35898271273,0,null,{"$f":"I7","v":88105.174284309731},0,88105.174284309731,{"$f":"K8/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A8","v":80628.715392142534},1049215.2964055734,3,0.90659535898271271,1.0492152964055734,142619.93742286073,null,null,20285.594370484207]
[4,null,null,108390.76865479394,{"$f":"D9/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A9","v":96303.794063410256},1002899.153046123,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K9/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A9","v":78280.306205963629},1127495.6026115371,4,1.0028991530461231,1.127495602611537,124596.44956541393,null,null,20285.594370484207]
[5,null,null,108390.76865479394,{"$f":"D10/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A10","v":93498.829187776952},1096397.9822338999,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K10/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A10","v":76000.297287343332},1203495.8998988804,5,1.0963979822338998,1.2034958998988803,107097.91766498044,null,null,20285.594370484207]
[6,null,null,108390.76865479394,{"$f":"D11/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A11","v":90775.562318230048},1187173.5445521299,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K11/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A11","v":73786.696395478953},1277282.5962943593,6,1.1871735445521299,1.2772825962943593,90109.051742229378,null,null,20285.594370484207]
[7,null,null,108390.76865479394,{"$f":"D12/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A12","v":88131.613901194214},1275305.1584533241,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K12/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A12","v":71637.56931599899},1348920.1656103584,7,1.2753051584533242,1.3489201656103584,73615.007157034284,null,null,20285.594370484207]
[8,null,null,108390.76865479394,{"$f":"D13/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A13","v":85564.673690479831},1360869.8321438041,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K13/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A13","v":69551.038170872809},1418471.2037812311,8,1.360869832143804,1.418471203781231,57601.371637427066,null,null,20285.594370484207]
[9,null,null,108390.76865479394,{"$f":"D14/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A14","v":83072.498728621198},1443942.3308724253,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K14/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A14","v":67525.279777546413},1485996.4835587775,9,1.4439423308724253,1.4859964835587776,42054.152686352267,null,null,20285.594370484207]
[10,null,null,108390.76865479394,{"$f":"D15/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A15","v":80652.91138701087},1524595.2422594363,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K15/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A15","v":65558.524055870308},1551555.0076146477,10,1.5245952422594362,1.5515550076146478,26959.765355211606,null,null,20285.594370484207]
[11,null,null,108390.76865479394,{"$f":"D16/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A16","v":78303.797463117342},1602899.0397225537,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K16/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A16","v":63649.052481427476},1615204.0600960753,11,1.6028990397225538,1.6152040600960753,12305.020373521547,null,null,20285.594370484207]
[12,null,null,108390.76865479394,{"$f":"D17/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A17","v":76023.104333123643},1678922.1440556773,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K17/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A17","v":61795.196583910183},1676999.2566799854,12,1.6789221440556774,1.6769992566799854,-1922.8873756920173,null,null,20285.594370484207]
[12.5,null,null,{"$f":"D17/2","v":54195.384327396969},{"$f":"D18/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A18","v":37453.895258182711},1716376.03931386,0,null,{"$f":"I17/2","v":44052.587142154865},{"$f":"J17/2","v":0},44052.587142154865,{"$f":"K18/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A18","v":30444.308222022388},1707443.5649020078,12.5,{"$f":"F18/1000000","v":1.7163760393138601},{"$f":"M18/1000000","v":1.7074435649020079},-8932.4744118521867]
[12.5,{"$f":"'Dateneingabe und Ergebnisse'!F52*'Dateneingabe und Ergebnisse'!F54/100","v":240000},{"$f":"B19/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A19","v":165861.63145668007},0,{"$f":"D19/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A19","v":0},{"$f":"F18+C19","v":1882237.6707705401},{"$f":"'Dateneingabe und Ergebnisse'!I53*'Dateneingabe und Ergebnisse'!I54/100+'Dateneingabe und Ergebnisse'!I56","v":320000},{"$f":"G19/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A19","v":221148.84194224008},null,{"$f":"J18","v":0},null,{"$f":"K19/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A19","v":0},{"$f":"M18+H19","v":1928592.4068442478},12.5,1.8822376707705402,1.9285924068442479,46354.736073707769]
[13,null,null,{"$f":"D18","v":54195.384327396969},{"$f":"D20/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A20","v":36904.419579186237},{"$f":"F19+E20","v":1919142.0903497264},0,null,{"$f":"I18","v":44052.587142154865},{"$f":"J18","v":0},44052.587142154865,{"$f":"K20/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A20","v":29997.668244616594},{"$f":"M19+L20","v":1958590.0750888644},13,{"$f":"F20/1000000","v":1.9191420903497263},{"$f":"M20/1000000","v":1.9585900750888645},39447.984739138243,null,null,{"$f":"D20-I20+J20","v":10142.797185242103}]
[14,null,null,{"$f":"D17","v":108390.76865479394},{"$f":"D21/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A21","v":71659.067144050947},{"$f":"F20+E21","v":1990801.1574937773},0,null,{"$f":"I17","v":88105.174284309731},{"$f":"J17","v":0},88105.174284309731,{"$f":"K21/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A21","v":58247.89950410989},{"$f":"M20+L21","v":2016837.9745929744},14,1.9908011574937774,2.0168379745929745,26036.817099197142,null,null,20285.594370484207]
[15,null,null,108390.76865479394,{"$f":"D22/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A22","v":69571.909848593146},2060373.0673423705,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K22/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A22","v":56551.358741854259},2073389.3333348287,15,2.0603730673423706,2.0733893333348288,13016.265992458199,null,null,20285.594370484207]
[16,null,null,{"$f":"D22","v":108390.76865479394},{"$f":"D23/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A23","v":67545.543542323445},2127918.6108846939,0,null,{"$f":"I22","v":88105.174284309731},{"$f":"J22","v":0},{"$f":"I23-J23","v":88105.174284309731},{"$f":"K23/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A23","v":54904.231788208024},2128293.565123037,16,2.1279186108846937,2.128293565123037,374.95423834332797,null,null,20285.594370484207]
[17,null,null,{"$f":"D23","v":108390.76865479394},{"$f":"D24/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A24","v":65578.197613906261},2193496.8084986,0,null,{"$f":"I23","v":88105.174284309731},{"$f":"J23","v":0},88105.174284309731,{"$f":"K24/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A24","v":53305.079406027209},2181598.6445290642,17,2.1934968084986002,2.181598644529064,-11898.163969536135,null,null,20285.594370484207]
[18,null,null,{"$f":"D24","v":108390.76865479394},{"$f":"D25/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A25","v":63668.153023209961},2257164.9615218099,0,null,{"$f":"I24","v":88105.174284309731},0,88105.174284309731,{"$f":"K25/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A25","v":51752.504277696316},2233351.1488067606,18,2.2571649615218101,2.2333511488067606,-23813.812715049564,null,null,20285.594370484207]
[19,null,null,108390.76865479394,{"$f":"D26/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A26","v":61813.740799232975},2318978.7023210428,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K26/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A26","v":50245.149784171183},2283596.2985909316,19,2.3189787023210426,2.2835962985909317,-35382.40373011092,null,null,20285.594370484207]
[20,null,null,108390.76865479394,{"$f":"D27/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A27","v":60013.340581779587},2378992.0429028221,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K27/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A27","v":48781.698819583675},2332377.9974105153,20,2.378992042902822,2.3323779974105152,-46614.045492306745,null,null,20285.594370484207]
[21,null,null,108390.76865479394,{"$f":"D28/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A28","v":58265.379205611258},2437257.4221084332,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K28/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A28","v":47360.872640372509},2379738.870050888,21,2.4372574221084333,2.3797388700508879,-57518.552057545414,null,null,20285.594370484207]
[22,null,null,108390.76865479394,{"$f":"D29/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A29","v":56568.329325836166},2493825.7514342694,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K29/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A29","v":45981.429747934468},2425720.2997988225,22,2.4938257514342692,2.4257202997988223,-68105.451635446894,null,null,20285.594370484207]
[23,null,null,108390.76865479394,{"$f":"D30/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A30","v":54920.708083336081},2548746.4595176056,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K30/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A30","v":44642.164803819869},2470362.4646026422,23,2.5487464595176057,2.4703624646026423,-78383.99491496339,null,null,20285.594370484207]
[24,null,null,108390.76865479394,{"$f":"D31/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A31","v":53321.075809064168},2602067.5353266699,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K31/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A31","v":43341.90757652415},2513704.3721791664,24,2.60206753532667,2.5137043721791663,-88363.163147503699,null,null,20285.594370484207]
[25,null,null,108390.76865479394,{"$f":"D32/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A32","v":51768.034766081713},2653835.5700927516,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K32/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A32","v":42079.521918955485},2555783.8940981217,25,2.6538355700927516,2.5557838940981217,-98051.675994629943,null,null,20285.594370484207]
[26,null,null,108390.76865479394,{"$f":"D33/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A33","v":50260.227928234664},2704095.7980209864,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K33/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A33","v":40853.904775684932},2596637.7988738064,26,2.7040957980209863,2.5966377988738065,-107457.9991471798,null,null,20285.594370484207]
[27,null,null,108390.76865479394,{"$f":"D34/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A34","v":48796.337794402592},2752892.135815389,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K34/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A34","v":39663.985219111593},2636301.784092918,27,2.7528921358153888,2.6363017840929182,-116590.35172247067,null,null,20285.594370484207]
[28,null,null,108390.76865479394,{"$f":"D35/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A35","v":47375.085237284075},2800267.2210526732,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K35/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A35","v":38508.72351370057},2674810.5076066186,28,2.8002672210526733,2.6748105076066184,-125456.71344605491,null,null,20285.594370484207]
[29,null,null,108390.76865479394,{"$f":"D36/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A36","v":45995.228385712697},2846262.4494383857,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K36/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A36","v":37387.110207476289},2712197.6178140948,29,2.8462624494383855,2.7121976178140947,-134064.83162429073,null,null,20285.594370484207]
[30,null,null,108390.76865479394,{"$f":"D37/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A37","v":44655.561539526891},2890918.0109779127,0,null,88105.174284309731,0,88105.174284309731,{"$f":"K37/(1+'Dateneingabe und Ergebnisse'!$F$58/100)^A37","v":36298.165249976977},2748495.7830640716,30,2.8909180109779129,2.7484957830640715,-142422.2279138414,null,null,20285.594370484207]

{"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}]