{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Tabelle1"],"not_rendered":{"external_links":1,"comments":5},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Tabelle1","index":0,"n_rows":186,"n_cols":10,"rows_kept":186,"merged":[[17,1,17,5],[49,2,49,3],[49,4,49,5],[49,6,49,7],[49,8,49,9],[107,5,107,6],[123,5,123,6],[131,5,131,6],[151,5,151,6],[170,5,170,6],[176,5,176,6],[184,5,184,6]],"flags":["formulas_cached_only"]}
[]
[null,"Objektdaten"]
[null,"Anlagenname"]
[null,"Betreiber"]
[null,"Adresse"]
[null,"Kontaktperson"]
[null,"Jahr der Inbetriebnahme \nder letzten Ausbaustufe"]
[null,"Welche Anlagenteile sind vorhanden"]
[null,"Ausbaugröße",{"$nulls":3},"EW-Ausbau"]
[null,"Angeschlossene Einwohner",{"$nulls":3},"E"]
[null,"wichtigster Indirekteinleiter (Art)"]
[null,"wichtigster Indirekteinleiter (Einwohnergleichwert)",{"$nulls":3},"EGW"]
[null,"zweitwichtigster Indirekteinleiter (Art)"]
[null,"zweitwichtigster Indirekteinleiter (Einwohnergleichwert)",{"$nulls":3},"EGW"]
[null,"drittwichtigster Indirekteinleiter (Art)"]
[null,"drittwichtigster Indirekteinleiter (Einwohnergleichwert)",{"$nulls":3},"EGW"]
[]
[null,"Betriebsdaten des Untersuchungsjahres\n(Tagesmittelwerte des Untersuchungsjahres)"]
[]
[null,"Untersuchungsjahr"]
[null,"Abwasseranfall",null,null,"m³/d"]
[]
[null,"CSB-Zulauffracht",null,null,"kg/d"]
[null,"CSB-Fracht Zulauf Biologie",null,null,"kg/d"]
[null,"BSB5-Zulauffracht",null,null,"kg/d"]
[null,"Nges.-Zulauffracht",null,null,"kg/d"]
[null,"NH4-N-Zulauffracht",null,null,"kg/d"]
[null,"Pges.-Zulauffracht",null,null,"kg/d"]
[]
[null,"CSB-Ablaufkonzentration",null,null,"mg/l"]
[null,"BSB5-Ablaufkonzentration",null,null,"mg/l"]
[null,"Nges.-Ablaufkonzentration",null,null,"mg/l"]
[null,"NH4-N-Ablaufkonzentration",null,null,"mg/l"]
[null,"NO3-N-Ablaufkonzentration",null,null,"mg/l"]
[null,"Pges.-Ablaufkonzentration",null,null,"mg/l"]
[null,"Belebungsbeckenvolumen gesamt",null,null,"m³"]
[null,"--> davon belüftet",null,null,"m³"]
[null,"--> davon gerührt",null,null,"m³"]
[]
[null,"Faulbehältervolumen",null,null,"m³"]
[null,"Faulbehälteroberfläche",null,null,"m²"]
[null,"Rohschlammtemperatur",null,null,"°C"]
[null,"Faulbehältertemperatur",null,null,"°C"]
[null,"Faulgasanfall gesamt",null,null,"m³/d"]
[null,"CO2-Gehalt Faulgas",null,null,"%"]
[null,"Faulschlammanfall bzw. stabil. Schlammanfall",null,null,"m³/d"]
[null,"TS-Faulschlamm bzw. stabil. Schlamm",null,null,"kg/m³"]
[null,"oTS-Faulschlamm bzw. stabil. Schlamm",null,null,"%"]
[]
[null,"Energiequellen","Menge",null,"Energieinhalt",null,"verwertbare\nelektrische Energie",null,"verwertbare\nthermische Energie "]
[null,"Faulgas gesamt",null,"m³/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"Faulgas BHKW",null,"m³/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"Faulgas Gasmotor",null,"m³/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"Faulgas Heizung",null,"m³/d",null,"kWh/d",{"$nulls":3},"kWh/d"]
[null,"Faulgas Fackel",null,"m³/d",null,"kWh/d"]
[null,"Erdgas gesamt",null,"m³/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"Erdgas BHWK",null,"m³/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"Erdgas Gasmotor",null,"m³/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"Erdgas Heizung",null,"m³/d",null,"kWh/d",{"$nulls":3},"kWh/d"]
[null,"Flüssiggas gesamt",null,"kg/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"Flüssiggas BHKW",null,"kg/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"Flüssiggas Gasmotor",null,"kg/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"Flüssiggas Heizung",null,"kg/d",null,"kWh/d",{"$nulls":3},"kWh/d"]
[null,"Heizöl",null,"l/d",null,"kWh/d",{"$nulls":3},"kWh/d"]
[null,"andere Energieträger 1",null,"?/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"andere Energieträger 2",null,"?/d",null,"kWh/d",null,"kWh/d",null,"kWh/d"]
[null,"Summe elektrische bzw. thermische Energie auf ARA erzeugt",{"$nulls":5},"kWh/d",null,"kWh/d"]
[null,"Elektrische Energie vom EVU zugekauft",{"$nulls":5},"kWh/d"]
[null,"Energie ans EVU bzw. Fernwärme geliefert",{"$nulls":5},"kWh/d",null,"kWh/d"]
[null,"Energiebereitsstellung ARA",{"$nulls":5},"kWh/d",null,"kWh/d"]
[]
[null,"elektrische Energieverbrauch "]
[null,"1) Zulaufpumpwerk und \n    mechanische Vorreinigung",null,"kWh/d"]
[null,"1.1 Zulaufpumpwerk",null,"kWh/d"]
[null,"1.2 Rechen",null,"kWh/d"]
[null,"1.3 Sand- u. Fettfang",null,"kWh/d"]
[null,"2) Mechanisch-biologische \n    Abwasserreinigung",null,"kWh/d"]
[null,"2.1 Belüftung",null,"kWh/d"]
[null,"2.2 Rührwerk",null,"kWh/d"]
[null,"2.3 RS-Pumpen",null,"kWh/d"]
[null,"2.4 Sonstiges (VKB, NKB,…)",null,"kWh/d"]
[null,"3) Schlammbehandlung",null,"kWh/d"]
[null,"3.1 MÜSE und stat. Eindicker",null,"kWh/d"]
[null,"3.2 Faulung",null,"kWh/d"]
[null,"3.3 Schlammentwässerung",null,"kWh/d"]
[null,"4) Infrastruktur",null,"kWh/d"]
[null,"4.1 Heizung",null,"kWh/d"]
[null,"4.2 sonstige Infrastruktur",null,"kWh/d"]
[null,"Kläranlage gesamt",null,"kWh/d"]
[]
[]
[null,"thermischer Energieverbrauch"]
[null,"Schlammaufheizung (Qs)",null,"kWh/d","QS","QS=m*(tFR-tRS)*c"]
[null,"Transmissionsverluste, Faulbehälterbeheizung (QT)",null,"kWh/d","QT","QT = A*(tFR-tUT)*k*24/1000"]
[null,"Erzeugungs-, Speicher- und\nVerteilungsverluste (QV)",null,"kWh/d","QV","10% von QT+QS"]
[null,"Wärmemenge für Gebäude (QGebäude)",null,"kWh/d","QGebäude"]
[null,"Wärmemenge für Zuluftgeräte (QZuluft)",null,"kWh/d","QZuluft"]
[null,"Kläranlage gesamt",null,"kWh/d","QARA"]
[]
[]
[]
[null,"Anlagenkennzahlen"]
[null,"EW120",null,"E"]
[null,"EW60",null,"E"]
[null,"EWNges11",null,"E"]
[null,"EWNH4N6,5",null,"E"]
[null,"EWPges1,7",null,"E"]
[null,"EW-Faulschlamm-oTS22 (EWoTS22)",null,"E",null,"Normalbereich"]
[null,"N/CSB",null,"-",null,0.07,0.1]
[null,"BSB/CSB",null,"-",null,0.4,0.6]
[null,"spez-TS-Fracht stabilisierter Schlamm",null,"g TS/EW120/d",null,35,50]
[null,"spez-oTS-Fracht Faulschlamm",null,"g oTS/EW120/d",null,20,30]
[null,"spez. Faulgasanfall je EW120",null,"l/EW120/d",null,15,22]
[null,"spez. Faulgasanfall je EWoTS22",null,"l/EWoTS22/d",null,15,22]
[null,"spez-TS-Fracht aerob stabil. Schlamm",null,"g TS/EW120/d",null,40,60]
[null,"spez-oTS-Fracht aerob stabil. Schlamm",null,"g oTS/EW120/d",null,25,35]
[null,"TS-Schlamm entwässert",null,"%",null,25,35]
[]
[]
[]
[]
[null,"Energiekennzahlen"]
[]
[null,"spez. elektrische Energiebereitsstellung",{"$nulls":3},"Normalbereich"]
[null,"el. Energie aus Faulgas erzeugt",null,"kWh/EW120/a",null,10,20]
[null,"sonstige el. Energie auf ARA erzeugt",null,"kWh/EW120/a",null,"-","-"]
[null,"el. Energie zugekauft",null,"kWh/EW120/a",null,10,50]
[null,"el. Energie ans EVU geliefert",null,"kWh/EW120/a",null,0,20]
[null,"el. Energie bereitgestellt",null,"kWh/EW120/a",null,20,50]
[]
[]
[null,"spez. elektrischer Energieverbrauch",{"$nulls":3},"Normalbereich"]
[null,"Kläranlage gesamt",null,"kWh/EW120/a",null,20,50]
[null,"1) Zulaufpumpwerk und \n    mechanische Vorreinigung",null,"kWh/EW120/a",null,2.5,5.5]
[null,"1.1 Zulaufpumpwerk",null,"kWh/EW120/a",null,1.5,3.5]
[null,"1.2 Rechen",null,"kWh/EW120/a",null,0.5,1]
[null,"1.3 Sand- u. Fettfang",null,"kWh/EW120/a",null,0.5,1]
[null,"2) Mechanisch-biologische \n    Abwasserreinigung",null,"kWh/EW120/a",null,14.5,33]
[null,"2.1 Belüftung",null,"kWh/EW120/a",null,11.5,22]
[null,"2.2 Rührwerk",null,"kWh/EW120/a",null,1.5,4.5]
[null,"2.3 RS-Pumpen",null,"kWh/EW120/a",null,1,4.5]
[null,"2.4 Sonstiges (VKB, NKB,…)",null,"kWh/EW120/a",null,0.5,2]
[null,"3) Schlammbehandlung",null,"kWh/EW120/a",null,2,7]
[null,"3.1 MÜSE und stat. Eindicker",null,"kWh/EW120/a",null,0.5,1]
[null,"3.2 Faulung",null,"kWh/EW120/a",null,1,2.5]
[null,"3.3 Schlammentwässerung",null,"kWh/EW120/a",null,0.5,3.5]
[null,"4) Infrastruktur",null,"kWh/EW120/a",null,1,4.5]
[null,"4.1 Heizung",null,"kWh/EW120/a",null,0,2.5]
[null,"4.2 sonstige Infrastruktur",null,"kWh/EW120/a",null,1,2]
[]
[]
[null,"sonstige elektrische Energiekennzahlen",{"$nulls":3},"Normalbereich"]
[null,"Eigenstromabdeckung",null,"%",null,0,100]
[null,"WG-Zulaufpumpen",null,"%",null,30,70]
[null,"spez. Rührenergie",null,"W/m³",null,1,2.5]
[null,"belastungsspez. Energieverbrauch \nvon Belüften+Rühren",null,"kWh/kgCSBBiologie zu",null,0.3,0.6]
[null,"elektrischer Wirkungsgrad BHKW",null,"%",null,24,38]
[]
[]
[null,"Energiekennzahlen für Belüftungsenergie "]
[null,"Kohlenstoffatmung (OVC) berechnet",null,"kg/d",null,"CSBzu-CSBab-CSBFaulgas-CSBSchlamm"]
[null,"OVC/CSBzu",null,"-"]
[null,"denitrifizierte Stickstofffracht (DN)",null,"kg/d",null,"Nzu-Nab-NSchlamm (=2 bis 4 % N der TS-Faulschlamm)"]
[null,"Gesamtatmung (OV)",null,"kg/d",null,"OVC+DN*1,7+NO3N_ab*4,56)"]
[null,"erforderliche Belüftungsenergie max",null,"kWh/d",null,"bei Op =1,5 kg/kWh"]
[null,"erforderliche Belüftungsenergie min",null,"kWh/d",null,"bei Op = 2,8 kg/kWh"]
[null,"erforderliche Belüftungsenergie max",null,"kWh/EW120/a",null,"bei Op =1,5 kg/kWh"]
[null,"erforderliche Belüftungsenergie min",null,"kWh/EW120/a",null,"bei Op = 2,8 kg/kWh"]
[]
[]
[null,"spez. thermische Energiebereitsstellung",{"$nulls":3},"Normalbereich"]
[null,"therm. Energie aus Faulgas erzeugt",null,"kWh/EW/a",null,20,40]
[null,"sonstige therm. Energie auf ARA erzeugt",null,"kWh/EW/a",null,"-","-"]
[null,"therm. Energie ans EVU geliefert",null,"kWh/EW/a",null,"-","-"]
[null,"therm. Energie bereitgestellt",null,"kWh/EW/a",null,0,40]
[]
[null,"spez. thermischer Energieverbrauch (=Wärmeverbrauch)",{"$nulls":3},"Normalbereich"]
[null,"Kläranlage gesamt",null,"kWh/EW/a",null,0,30]
[null,"Schlammaufheizung (Qs)",null,"kWh/EW/a",null,8,12]
[null,"Transmissionsverluste, Faulbehälterbeheizung (QT)",null,"kWh/EW/a",null,1,5]
[null,"Erzeugungs-, Speicher- und\nVerteilungsverluste (QV)",null,"kWh/EW/a",null,1,3]
[null,"Wärmemenge für Gebäude (QGebäude)",null,"kWh/EW/a",null,0,2]
[null,"Wärmemenge für Zuluftgeräte (QZuluft)",null,"kWh/EW/a",null,0,10]
[]
[null,"sonstige thermische Energiekennzahlen",{"$nulls":3},"Normalbereich"]
[null,"therm. Wirkungsgrad BHKW",null,"%",null,50,65]