{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Daten","Berechnung","Intro"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"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":"Daten","index":0,"n_rows":112,"n_cols":12,"rows_kept":112,"cut":false,"hidden":true,"merged":[[15,1,15,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Gesamtemission [Tonnen CO2 pro Jahr]:"]
[null,null,null,null,null,"persönlicher Wert:",{"$f":"SUM(E21,F70,F81,F103,F112)","v":10.78},{"$f":"\"[\"&TEXT(Berechnung!BS13*100,\"0\")&\" % ]\"","v":"[99 % ]"}]
[null,null,null,null,null,"durchschnittlicher Wert in Deutschland:",11]
[null,null,null,null,null,"durchschnittlicher Wert in West-Europa:",10]
[null,null,null,null,null,"weltweiter Durchschnitt:",4.3]
[null,null,null,null,null,"durchschnittlicher Wert in den USA:",20]
[null,null,null,null,null,"durchschnittlicher Wert in Afrika:",1.3]
[null,"Das rechte Bild symbolisiert den persönlichen Fußabdruck im Vergleich zum Durchschnitt Deutschlands"]
[]
[]
[null,"Wohnsituation"]
[null,null,null,null,"persönlicher Wert:",null,null,"Durchschnitt in Deutschland"]
[null,null,null,"Summe Wohnen",{"$f":"SUM(E22:E23)","v":2.7199999999999998},null,null,{"$f":"Berechnung!BT6","v":2.72}]
[null,null,null,"Wärmeenergie",{"$f":"Berechnung!L5/1000","v":2.02}]
[null,null,null,"Elektroenergie",{"$f":"Berechnung!L6/1000","v":0.7}]
[]
[null,null,"Wohnung"]
[null,null,null,"Anzahl der Personen im Haushalt:"]
[null,null,null,"Wohnfläche:"]
[]
[]
[]
[null,null,"Wärmebedarf"]
[null,null,"Schätzung"]
[null,null,null,"Heizungsart und Gebäudezustand"]
[]
[]
[]
[null,null,null,"mittlere Raumtemperatur",20]
[null,null,null," während der Heizperiode:"]
[]
[null,null,null,"Warmwasserverbrauch"]
[]
[]
[]
[null,null,"Oder: Direkte Eingabe der verbrauchten Energie für Raumwärme und Warmwasser"]
[]
[null,null,null,"Heizölverbrauch",null,"Kilowattstunden pro Jahr",null,null,null,null,"Liter pro Jahr","Kubikmeter pro Jahr"]
[null,null,null,"Erdgasverbrauch",null,"Kilowattstunden pro Jahr",null,null,null,null,"Kilowattstunden pro Jahr","Kilowattstunden pro Jahr"]
[null,null,null,"Fernwärmeverbrauch",null,{"$f":"K47","v":"Kilowattstunden pro Jahr"}]
[]
[null,null,"Elektroenergiebedarf"]
[null,null,"Schätzung"]
[]
[null,null,"Nutzung von Elektrogeräten im Haushalt"]
[]
[null,null,null,"Ausstattung mit Elektrogeräten:"]
[]
[null,null,null,"Energieeffizienz:"]
[]
[null,null,null,"Grad der Nutzung:"]
[]
[null,null,"Oder: Direkte Eingabe der verbrauchten Elektroenergie"]
[]
[null,null,null,null,"Elektroenergieverbrauch",null,{"$f":"$K$47","v":"Kilowattstunden pro Jahr"}]
[]
[null,null,null,null,"bei Nutzung von Photovoltaik - Einspeisung in das Stromnetz:",null,{"$f":"$K$47","v":"Kilowattstunden pro Jahr"}]
[]
[]
[null,"Ernährung"]
[]
[null,null,null,null,null,{"$f":"Berechnung!$L$63/1000","v":1.55},null,{"$f":"Berechnung!L64/1000","v":1.65}]
[]
[null,null,null,"Geschlecht:"]
[]
[null,null,null,"Ernährungsform:"]
[]
[null,null,null,"Ernährungsweise:"]
[]
[]
[null,"Verkehr"]
[]
[null,null,null,null,"Summe Verkehr",{"$f":"SUM(F82:F84)","v":2.52},null,{"$f":"SUM(H82:H84)","v":2.52}]
[null,null,null,null,"PKW",{"$f":"Berechnung!L50/1000","v":1.56},null,{"$f":"Berechnung!L53/1000","v":1.56}]
[null,null,null,null,"ÖPNV",{"$f":"Berechnung!L51/1000","v":0.11},null,{"$f":"Berechnung!L54/1000","v":0.11}]
[null,null,null,null,"Flüge",{"$f":"Berechnung!L52/1000","v":0.85},null,{"$f":"Berechnung!L55/1000","v":0.85}]
[]
[null,null,null,null,null,null,"im Jahr gefahrene Km:"]
[null,null,null,"1. Privat-PKW:"]
[]
[null,null,null,"2. Privat-PKW:"]
[]
[null,null,null,"ÖPNV (Pendelverkehr):"]
[]
[null,null,null,"Bahnreisen:"]
[]
[null,null,"Flüge [Hin- und Rückflug zählen als ein Flug]",null,null,null,"Anzahl der Flüge:"]
[null,null,null,"1. Flugvariante:"]
[]
[null,null,null,"2. Flugvariante:"]
[]
[]
[null,"Konsumgewohnheiten"]
[]
[null,null,null,null,null,{"$f":"Berechnung!L75/1000","v":2.75},null,{"$f":"Berechnung!L76/1000","v":2.75}]
[]
[null,null,null,"Konsumverhalten:"]
[]
[null,null,null,"Kaufkriterien:"]
[]
[]
[null,"öffentlicher Konsum, Infrastruktur"]
[]
[null,null,null,null,null,{"$f":"Berechnung!L87/1000","v":1.24},null,{"$f":"F112","v":1.24}]

{"sheet":"Berechnung","index":1,"n_rows":87,"n_cols":72,"rows_kept":87,"cut":false,"hidden":true,"merged":[]}
[]
["Datenübernahme und -übergabe",null,null,null,null,null,null,null,null,"Berechnungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quellen",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,null,null,null,null,null,null,null,null,null,"Diagramm und Script"]
[null,"Wohnen",null,null,null,null,null,null,null,null,"Wohnen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quellenangaben",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,null,null,null,null,null,null,null,null,null,"Datenbereich für Diagramm"]
[null,"Wärme - Datenaufbereitung",null,null,null,null,null,null,null,null,"Rechenergebnisse aufbereitet, Übergabe an Auswertung"]
[null,null,"Anzahl Personen",{"$f":"Daten!E26","v":0},"Datenübernahme",null,null,null,null,null,"Gesamt Wärme (Heizung und WW) - Ergebnis und Übertrag",{"$f":"IF(N17<>0,N17,P24+L28)","v":2020},"kg pro Person und Jahr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Idee für die Gestaltung dieses Rechners beruht auf:",null,null,null,"http://www.energiesystem.de/Auswahl/Kompetenzen/Elektro/Stromkosten/Stromverbrauch/a_Stromverbrauch.gif",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,null,null,null,null,null,null,null,"persönlicher CO2-Abdruck","Mittelwert Deutschland"]
[null,null,"Wohnfläche",{"$f":"Daten!E27","v":0},"Datenübernahme",null,"CO2-Index",null,null,null,"Gesamt Elektro - Ergebnis und Übertrag",{"$f":"IF(D41=TRUE,0,IF(L32<>0,IF(D5=0,0,(L32-L33)/D5),L31))*AD35","v":700},"kg pro Person und Jahr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Persönliche Energie und CO2-Bilanz V. 1.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Techem-Studie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wohnen",{"$f":"(L5+L6)/1000","v":2.72},2.72]
[null,null,"Heizungsart",3,1,"Öl- bzw. Kohleheizung",0.27,null,null,null,"Mittelwert D Heizung und Warmwasser",2020,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Christoph Schlumpf",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,null,null,null,null,null,null,null,null,null,null,"Ernährung",{"$f":"L63/1000","v":1.55},{"$f":"L64/1000","v":1.65}]
[null,null,null,null,2,"Gasheizung",0.2,null,null,null,"Mittelwert D Elektro",700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EAWAG, Ueberlandstr. 133, CH-8600 Dübendorf",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,null,null,null,null,null,null,null,null,null,null,"Verkehr",{"$f":"SUM(L50,L51,L52)/1000","v":2.52},{"$f":"SUM(L53,L54,L55)/1000","v":2.52}]
[null,null,null,null,3,"Fernwärme",0.22500000000000001,null,null,null,"Berechnung Heizung",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,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,"Konsum",{"$f":"L75/1000","v":2.75},{"$f":"L76/1000","v":2.75}]
[null,null,null,null,4,"Wärmepumpe",0.51400000000000001,"(Strommix für Wärmepumpe)",null,null,null,null,null,"direkte Eingabe von Verbrauchswerten Heizung und Warmwasser - Umrechnung in CO2",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"öffentliche Infrastruktur",{"$f":"L87/1000","v":1.24},{"$f":"BS10","v":1.24}]
[null,null,null,null,5,"Holz (-Pellets)",0.01,null,null,null,null,"Wert","CO2-Index","CO2 absolut",null,null,null,null,"passivhaus","saniert, mod.","n. 1980, n.s.","v. 1980, n.s.",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summen für Fußabdruck:",{"$f":"SUM(BS6:BS10)","v":10.780000000000001},{"$f":"SUM(BT6:BT10)","v":10.88}]
[null,null,null,null,null,null,"Wichtung",null,null,null,"Heizöl [kWh]",{"$f":"IF(Daten!$F$46=Daten!L47,Daten!$E$46,0)","v":0},{"$f":"AD40","v":290},{"$f":"M12*L12/1000","v":0},null,null,{"$f":"F13","v":"Einfamilienhaus"},1,90,110,170,280]
[null,null,"Haustyp",3,1,"Einfamilienhaus",1.3,null,null,null,"Heizöl [l]",{"$f":"IF(Daten!$F$46=Daten!K46,Daten!$E$46,0)","v":0},{"$f":"AD43","v":2800},{"$f":"M13*L13/1000","v":0},null,null,{"$f":"F14","v":"Reihenhaus"},2,80,100,150,250,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skalierungsfaktor für Fußabdruck:",{"$f":"ROUND(BS11/BT11,2)","v":0.99}]
[null,null,null,null,2,"Reihenhaus",1.1000000000000001,null,null,null,"Erdgas [kWh]",{"$f":"IF(Daten!$F$47=Daten!L47,Daten!$E$47,0)","v":0},{"$f":"AD41","v":190},0,null,null,{"$f":"F15","v":"Mehrfamilienhaus"},3,70,95,120,200,null,null,null,null,null,"Berechnung Heizung und Warmwasser"]
[null,null,null,null,3,"Mehrfamilienhaus",1,null,null,null,"Erdgas [m³]",{"$f":"IF(Daten!$F$47=Daten!L46,Daten!$E$47,0)","v":0},{"$f":"AD45","v":1860},0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quelle: eigene Betriebskostenabrechnung 2009"]
[null,null,null,null,null,null,"CO2-Index",null,null,null,"Fernwärme",{"$f":"Daten!E48","v":0},225,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heizung","Warmwasser"]
[null,null,"Sanierungstyp",3,1,"Passivhaus-Standard",0.09,null,null,null,null,null,null,{"$f":"SUM(N12:N16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Kosten gesamt",64811,21627]
[null,null,null,null,2,"saniertes Gebäude, moderne Heizung",0.42,null,null,null,"Korrektur Haustyp:",{"$f":"VLOOKUP(D13,E13:G15,3,FALSE)","v":1},null,null,null,{"$f":"D13","v":3},null,null,null,null,null,null,null,null,null,null,null,"Kosten für Wohneinheit",1210,230]
[null,null,null,null,3,"unsaniert, nach 1980 erbaut",1,null,null,null,"Korrektur Sanierungstyp:",{"$f":"VLOOKUP(D17,E17:G20,3,FALSE)","v":1},null,null,null,{"$f":"D17","v":3},null,null,null,null,null,null,null,null,null,null,null,"Anteil",{"$f":"AC18/AC17","v":1.8669670272021724E-2},{"$f":"AD18/AD17","v":1.0634854579923244E-2}]
[null,null,null,null,4,"unsaniert, vor 1980 erbaut",1.2,null,null,null,"Korrektur Raumtemperatur (6% je K +/- bei 20° als 1):",{"$f":"(D21-20)*0.06","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energie gesamt",769460]
[null,null,"Raumtemperatur",{"$f":"Daten!E37","v":20},"Datenübernahme",null,null,null,null,null,"Grundenergieeinsatz nach Fläche (Techem):",{"$f":"AU51*D6","v":0},"kWh/a",null,"Energie nach LFU",{"$f":"VLOOKUP(P18,R12:V14,P19+1,FALSE)*D6","v":0},"kWh/a",null,null,null,null,null,null,null,null,null,null,"Anteil Heizung und WW",0.75,0.25]
[null,null,null,null,null,null,"Wichtung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energie Heizung und WW",{"$f":"AC20*AC21","v":577095},{"$f":"AC20*AD21","v":192365}]
[null,null,"Warmwasserindex",2,1,"täglich Duschen, oft Baden",1.4,null,null,null,"Gesamt mit Korr. Haus, Sanierungszustand, Zimmertemp:",{"$f":"L21*L19*L18+L21*L19*L18*L20","v":0},"kWh/a",null,null,{"$f":"P21+L20*P21","v":0},"kWh/a",null,null,null,null,null,null,null,null,null,null,"Anteil Energie gesamt",{"$f":"AC22*AC19","v":10774.173365632376},{"$f":"AD22*AD19","v":2045.7738012669349}]
[null,null,null,null,2,"täglich Duschen, selten Baden",1.2,null,null,null,"Gesamt Heizung - Umrechnung auf CO2 ",{"$f":"IF(OR(D5=0,D6=0),L7,VLOOKUP(D7,E7:G11,3)*L23/D5)","v":2020},"kg Co2 pro Person und Jahr",null,null,{"$f":"IF(OR(D5=0,D6=0),L7,VLOOKUP(D7,E7:G11,3)*P23/D5)","v":2020},"kg Co2 pro Person und Jahr",null,null,null,null,null,null,null,null,null,null,"Einheiten (qm bzw. m³)",70,18.7]
[null,null,null,null,3,"täglich Duschen, nicht Baden",1,null,null,null,"Berechnung Warmwasser",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energie pro Einheit",{"$f":"AC23/AC24","v":153.91676236617681},{"$f":"AD23/AD24","v":109.3996685169484}]
[null,null,null,null,4,"nicht täglich Duschen",0.8,null,null,null,"Energie für Warmwasser:",{"$f":"VLOOKUP(D23,E23:G26,3)*1000","v":1200},"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MW Heizung:",{"$f":"AC25","v":153.91676236617681},"kWh pro Jahr und qm bei 21°"]
[null,null,"Solarthermie",false,"Datenübernahme",null,null,null,null,null,"Korr Solarthermie:",{"$f":"IF(D27=FALSE,L26,L26*0.6)","v":1200},"kWh/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MW Warmwasser:",{"$f":"AD25","v":109.3996685169484},"kWh pro m³ Wasser"]
[null,null,"Warmwasser elektrisch",false,"Datenübernahme",null,null,null,null,null,"Gesamt CO2 Warmwasser",{"$f":"IF(D5=0,0,IF(D28=TRUE,G10,VLOOKUP(D7,E7:G11,3))*L27)","v":0},"kg Co2/a"]
[null,"Haushaltsgeräte - Datenaufbereitung",null,null,null,null,null,null,null,null,"Berechnung Elektroenergie",null,null,null,"Schätzung Elektroenergieverbrauch in Abhängigkeit von Ausstattung, Effizienz und Nutzung"]
[null,null,"Ausstattung",2,1,"gering",null,null,null,null,"Elektroenergie",{"$f":"MAX(0,FORECAST($P$30,INDEX($P$33:$W$39,0,HLOOKUP(U30,P32:W40,9),1),$O$33:$O$39))","v":0},"kWh/a",null,"Fläche:",{"$f":"D6","v":0},null,null,null,"Elektrogeräte Ausstattung und Nutzung:",{"$f":"L39","v":86.4}]
[null,null,null,null,2,"durchschnittlich",null,null,null,null,"Elektroenergie pro Nase",{"$f":"IF(D5=0,L8/AD35,L30/D5)","v":1129.0322580645161},"kWh/a und Person",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quelle der Umrechnungen: http://www.greenorange.de/"]
[null,null,null,null,3,"überdurchschnittlich",null,null,null,null,"Elektroenergie Datenübernahme Direkteingabe",{"$f":"Daten!F63","v":0},null,null,null,9.9999999999999858,21,55,88,114,142,170,195,null,null,null,null,"© Copyright 2007 Ceramix Aktiengesellschaft. Alle Rechte vorbehalten."]
[null,null,null,null,null,null,null,null,null,null,"Rückspeisung Photovoltaik Datenübernahme Direkteingabe",{"$f":"Daten!F65","v":0},null,null,60,1521,1660,1798,1937,2075,2214,2352,2491,null,null,null,null,null,"Umrechnungen"]
[null,null,"Effizienz",2,1,"sehr effizient (Klasse A und besser)",null,null,null,null,null,null,null,null,75,2347,2597,2846,3096,3345,3595,3844,4000.0000000000009,null,null,null,null,"dt. Strommix","kWh","kg CO2"]
[null,null,null,null,2,"durchschnittlich",null,null,null,null,"Elektrogeräte",null,null,null,90,3173,3534,3894,4255,4615,4976,5336,5550,null,null,null,null,null,1,0.62,"UBA CO2-Rechner im Vergleich",null,null,"alt:",5.62]
[null,null,null,null,null,null,null,null,null,null,"Wertung Ausstattung",{"$f":"D30*3","v":6},null,null,120,3999.9999999999986,4471,4942,5414,5885,6357,6828,7300.0000000000009]
[null,null,"Nutzung",2,1,"eher geringe Nutzung",null,null,null,null,"Wertung Effizienz",{"$f":"D34*1.8","v":3.6},null,null,135,4826,5408,5990,6573,7155,7738,8320,8800,null,null,null,null,"Wohnen",null,2720]
[null,null,null,null,2,"durchschnittliche Nutzung",null,null,null,null,"Wertung Nutzung",{"$f":"D37*2","v":4},null,null,155,5652,6345,7038,7732,8425,9119,9812,10380,null,null,null,null,null,"kWh","kg Co2"]
[null,null,null,null,3,"überdurchschnittliche Nutzung",null,null,null,null,"Gesamtwertung",{"$f":"L36*L37*L38","v":86.4},null,null,175,6478,7282,8087,8891,9695,10500,11304,11960,null,null,null,null,"Fernwärme",1000,225,"http://www.iwr.de/re/eu/co2/co2.html",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flächen-Korrekturfaktor aus Techem-Grafik"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,3,4,5,6,7,8,9,null,null,null,null,"Heizöl",1000,290,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mehrfamilienhaus:",17.3,{"$f":"AU40/$AU$40","v":1}]
[null,null,"Ökostrom",false,"Datenübernahme",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Erdgas",1000,190,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doppelhaus",19.5,{"$f":"AU41/$AU$40","v":1.1271676300578035}]
[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,"l",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Einfamilienhaus",22.5,{"$f":"AU42/$AU$40","v":1.3005780346820808}]
[null,"Verkehr",null,null,null,null,null,null,null,null,"Benzin/Diesel",null,"l/100 Km","CO2 / Km",null,null,null,null,null,null,null,null,null,null,null,null,null,"Heizöl",1000,2800,"http://www.iwr.de/re/eu/co2/co2.html"]
[null,"1. PKW","Typ",3,1,"Kleinwagen (Benzin)",null,null,null,null,1,1,7,{"$f":"IF(K44=1,$AF$50/$AC$50*M44,$AF$49/$AC$49*M44)","v":0.16519999999999999},null,"Ergebnis 1. PKW",{"$f":"VLOOKUP(D44,$L$44:$N$49,3,FALSE)*D45","v":0},"Kg CO2/a",null,null,null,null,null,null,null,null,null,null,"m³",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.energieanbieter-vergleichen.de/news/2009/01/30/raumtemperatur-verringern-und-energieverbrauch-senken/"]
[null,null,"Km",{"$f":"Daten!G87","v":0},2,"Kleinwagen (Diesel)",null,null,null,null,2,2,5,0.13200000000000001,null,"Ergebnis 2. PKW",{"$f":"VLOOKUP(D47,$L$44:$N$49,3,FALSE)*D48","v":0},"Kg CO2/a",null,null,null,null,null,null,null,null,null,"Erdgas",1000,1860,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energieverbrauchs-Senkung je K Raumtemperatur: 6%"]
[null,null,null,null,3,"Mittelklasse (Benzin)",null,null,null,null,1,3,9,0.21240000000000001]
[null,"2. PKW","Typ",1,4,"Mittelklasse (Diesel)",null,null,null,null,2,4,7,0.18479999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,"PKW",null,1560,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"spez. Verbrauch:"]
[null,null,"Km",{"$f":"Daten!G89","v":0},5,"Oberklasse / Van (Benzin)",null,null,null,null,1,5,11,0.2596,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verbrauch pro 100 km","km","kg CO2",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU48/$AU$51","v":9.0909090909090912E-2},"Passivhaus",15,"kWh/m²","http://www.effiziento.de/energieeinsparung.html"]
[null,null,null,null,6,"Oberklasse / Van (Diesel)",null,null,null,null,2,6,9,0.23760000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diesel",10,10000,2640,{"$f":"AE49/AD49","v":0.26400000000000001},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU49/$AU$51","v":0.42424242424242425},"Niedrigenergiehaus",70,"kWh/m²"]
[null,"kein PKW",null,false,null,null,null,null,null,null,"PKW-Nutzung - Ergebnis und Übertrag",{"$f":"IF(D50=TRUE,0,IF(SUM(Q44:Q45)=0,L53,SUM(Q44:Q45)))","v":1560},"kg CO2/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benzin",10,10000,2360,{"$f":"AE50/AD50","v":0.23599999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,"Fernwärme",130,"kWh/m²"]
[null,"ÖPNV","Typ",1,1,"Straßenbahn",{"$f":"AD70","v":70},null,null,null,"ÖPNV und Bahn - Ergebnis und Übertrag",{"$f":"IF(D54=TRUE,0,IF(SUM(Q51:Q52)=0,L54,SUM(Q51:Q52)))","v":110},"kg CO2/a",null,null,"Ergebnis ÖPNV",{"$f":"VLOOKUP(D51,E51:G53,3)*D52/AC70","v":0},"Kg CO2/a",null,null,null,null,null,null,null,null,null,"Autogas",10,10000,1860,0.186,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas/Öl",165,"kWh/m²","(Techem-Studie)"]
[null,null,"Km",{"$f":"Daten!G91","v":0},2,"Bus",{"$f":"AD71","v":80},null,null,null,"Flug - Ergebnis und Übertrag",{"$f":"IF(D56=TRUE,0,IF(SUM(Q55:Q56)=0,L55,SUM(Q55:Q56)))","v":850},"kg CO2/a",null,null,"Ergebnis Bahn",{"$f":"AD73*D55/AC73","v":0},"Kg CO2/a",null,null,null,null,null,null,null,null,null,"Erdgas",10,10000,2280,0.22800000000000001]
[null,null,null,null,3,"Zug",{"$f":"AD72","v":100},null,null,null,"Mittelwert Deutschland - PKW",1560,"kg CO2/a"]
[null,"kein ÖPNV",null,false,null,null,null,null,null,null,"Mittelwert Deutschland - ÖPNV und Bahn",110,"kg CO2/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flüge",null,850,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wärmepumpe - Heizung mit Brauchwassererwärmung  Fläche 135 m²"]
[null,"Bahnreisen","Km",{"$f":"Daten!G93","v":0},null,null,null,null,null,null,"Mittelwert Deutschland - Flug",850,"kg CO2/a",null,null,"Ergebnis 1. Flug",{"$f":"VLOOKUP(D57,$E$57:$L$61,7,FALSE)*VLOOKUP(D57,$E$57:$L$61,8,FALSE)*D58/1000","v":0},"Kg CO2/a",null,null,null,null,null,null,null,null,null,null,null,10000,2610,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://energie-effizientes-haus.de/energieverbrauch.php"]
[null,"Kein Flug",null,false,null,null,null,null,null,null,"doppelte Entfernung",null,null,null,null,"Ergebnis 2. Flug",{"$f":"VLOOKUP(D59,$E$57:$L$61,7,FALSE)*VLOOKUP(D59,$E$57:$L$61,8,FALSE)*D60/1000","v":0},"Kg CO2/a",null,null,null,null,null,null,null,null,null,"Ziel","Entfernung (einfach)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jahr","Verbrauch"]
[null,"1. Flug","Typ",1,1,"Städteflug Europa",null,null,null,null,1700,220,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mallorca",1250,null,{"$f":"$AE$55/$AD$55*AC57*2","v":652.5},{"$f":"AE57/AC57","v":0.52200000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,2007,1835,"kWh"]
[null,null,"Anzahl",{"$f":"Daten!G96","v":0},2,"Mittelmeerurlaub",null,null,null,null,2500,185,null,null,"http://www.iwr.de/re/eu/co2/co2.html",null,null,null,null,null,null,null,null,null,null,null,null,"Peking",7800,null,4071.6000000000004,{"$f":"AE58/AC58","v":0.52200000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,2008,2000,"kWh"]
[null,"2. Flug","Typ",2,3,"Übersee (USA, Kanada)",null,null,null,null,15000,150,null,null,"kurz",220,"je 1000 km",null,null,null,null,null,null,null,null,null,null,"LA",9300,null,4854.6000000000004,0.52200000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,2009,1864,"kWh"]
[null,null,"Anzahl",{"$f":"Daten!G98","v":0},4,"Übersee (Asien)",null,null,null,null,18300,150,null,null,"mittel",185,null,null,null,null,null,null,null,null,null,null,null,"Vancouver",8000,null,4176,0.52200000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,"spezif. Verbrauch:",{"$f":"AVERAGE(AU57:AU59)/135","v":14.071604938271605},"kWh/m²"]
[null,null,null,null,5,"Übersee (Down under)",null,null,null,null,34800,150,null,null,"lang",150,null,null,null,null,null,null,null,null,null,null,null,"NY",6200,null,3236.4,0.52200000000000002]
[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,"Washington",6500,null,3393,0.52200000000000002]
[null,"Ernährung",null,null,null,null,null,null,null,null,"Ernährung - Ergebnis und Übertrag:",{"$f":"INDEX($K$69:$P$73,D66,IF(D64=1,D71+3,D71))","v":1550},"kg CO2 pro Jahr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tokio",9400,null,4906.8,0.52200000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warmwasser"]
[null,null,"Geschlecht",1,1,"weiblich",null,null,null,null,"Mittelwert Deutschland:",1650,"kg CO2 pro Jahr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sydney",16500,null,8613,0.52200000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,"spez. Verbrauch:",110,"kWh/m³ Wasser"]
[null,null,null,null,2,"männlich",null,null,null,null,"männlich",null,null,"weiblich",null,null,null,null,null,null,null,null,null,null,null,null,null,"Auckland",18200,null,9500.4,0.52200000000000002]
[null,null,"Ernährung",4,1,"Vegan",null,null,null,null,"bewusst ökologisch","durchschnittlich","unbewusst, kostengünstig","bewusst ökologisch","durchschnittlich","unbewusst, kostengünstig",null,null,null,null,null,null,null,null,null,null,null,"Singapur",10300,null,5376.6,0.52200000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,"http://www.energiesparen-im-haushalt.de/energie/bauen-und-modernisieren/modernisierung-haus/heizung-modernisieren/heizungsanlage-erneuern/gasheizung-erneuern/gasverbrauch-warmwasser.html"]
[null,null,null,null,2,"Vegetarisch",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,null,null,null,null,null,null,null,null,"Einsparung bei Solarunterstützung 40%"]
[null,null,null,null,3,"geringer Verzehr von Fleisch und Wurst",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ÖPNV",null,110]
[null,null,null,null,4,"durchschnittliche Vollwertkost",null,null,null,null,1190,1400,1610,920,1080,1240,null,null,null,null,null,null,null,null,null,null,null,null,"km","kg CO2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verbrauch Warmwasser pro Person im Mittel"]
[null,null,null,null,5,"reichlicher Verzehr von Fleisch und Wurst",null,null,null,null,1260,1480,1700,970,1140,1310,null,null,null,null,null,null,null,null,null,null,null,"Straba",1000,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"Liter",null,{"$f":"AT70*0.356","v":14.239999999999998}]
[null,null,"Nahrungsauswahl",2,1,"bewusst ökologisch",null,null,null,null,1610,1890,2170,1240,1460,1680,null,null,null,null,null,null,null,null,null,null,null,"NV Bus",1000,80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"800 kWh"]
[null,null,null,null,2,"durchschnittlich",null,null,null,null,1710,2010,2310,1320,1550,1780,null,null,null,null,null,null,null,null,null,null,null,"NV Bahn",1000,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0,8 - 1 - 1,2","Verhältnisse wenig - Durchschnitt - viel"]
[null,null,null,null,3,"unbewusst, kostengünstig",null,null,null,null,2050,2410,2770,1580,1860,2140,null,null,null,null,null,null,null,null,null,null,null,"FV Bahn",1000,50]
[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,"Fernbus",1000,30]
[null,"Konsumverhalten",null,null,null,null,null,null,null,null,"Konsum - Ergebnis und Übertrag",{"$f":"INDEX($K$79:$M$83,D76,D82)","v":2750},"kg CO2 pro Jahr"]
[null,null,"Gewohnheiten-Typ",3,1,"sehr sparsam",null,null,null,null,"Mittelwert Deutschland Deutschland:",2750,"kg CO2 pro Jahr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Konsum",null,2750]
[null,null,null,null,2,"sparsam"]
[null,null,null,null,3,"durchschnittlich",null,null,null,null,"Günstiger Anschaffungspreis","Bedienbarkeit und Funktionalität","Qualität und Langlebigkeit"]
[null,null,null,null,4,"großzügig",null,null,null,null,2670,2540,2420]
[null,null,null,null,5,"sehr großzügig",null,null,null,null,2740,2610,2480]
[null,null,null,null,null,null,null,null,null,null,2890,2750,2610]
[null,null,"Kriterien-Typ",2,1,"Günstiger Anschaffungspreis",null,null,null,null,3030,2890,2740]
[null,null,null,null,2,"Bedienbarkeit und Funktionalität",null,null,null,null,3100,2960,2810]
[null,null,null,null,3,"Qualität und Langlebigkeit"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"öffentliche Infrastruktur - Vorgabe und Übertrag",1240,"kg CO2 pro Jahr"]

{"sheet":"Intro","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}