{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Excel","Ausdruck Erfassung"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Excel","index":0,"n_rows":132,"n_cols":26,"rows_kept":132,"cut":false,"hidden":false,"merged":[[12,3,12,19],[8,1,8,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Biomasse Nahwärme -\nBetriebsdatenerfassung"]
[]
["A0","Grunddaten"]
[]
[null,null,"Projekt Name"]
[]
[null,null,"Betriebsjahr [JJJJ]",2013,null,null,null,null,null,null,null,null,null,null,"Anm.:",null," Empfohlene Eingaben"]
[null,null,"Anfangsmonat Rechnungsjahr","März",null,null,null,null,null,null,null,null,null,null,null,null," notwendige Eingaben",null,null,null,null,null,null,{"$f":"VLOOKUP(D16,Y16:Z27,2,FALSE)","v":3},"Jänner",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Februar",2]
["A1","Wärmeerzeugung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"März",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April",4]
[null,"A1.1 Zählerstände Wärmeerzeuger",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mai",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juni",6]
[null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),-1)","v":"2013-02-28"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"},null,null,null,null,null,null,null,null,"Juli",7]
[null,null,"Biomassekessel 1 [kWh]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",8]
[null,null,"Biomassekessel 2 [kWh]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September",9]
[null,null,"Öl-/Gaskessel [kWh]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oktober",10]
[null,null,"Solaranlage [kWh]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November",11]
[null,null,"Wärmerückgewinnung [kWh]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dezember",12]
[]
[null,"A1.2 Erzeugung"]
[]
[null,null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"},"Summe"]
[null,null,"Biomassekessel 1 [kWh]",null,{"$f":"IF(AND(ISNUMBER(D23),ISNUMBER(E23)),E23-D23,\"\")","v":""},{"$f":"IF(AND(ISNUMBER(E23),ISNUMBER(F23)),F23-E23,\"\")","v":""},"","","","","","","","","","",{"$f":"IF(AND(ISNUMBER(P23),ISNUMBER(D23)),P23-D23,\"\")","v":""}]
[null,null,"Biomassekessel 2 [kWh]",null,{"$f":"IF(AND(ISNUMBER(D24),ISNUMBER(E24)),E24-D24,\"\")","v":""},"","","","","","","","","","","",{"$f":"IF(AND(ISNUMBER(P24),ISNUMBER(D24)),P24-D24,\"\")","v":""}]
[null,null,"Öl-/Gaskessel [kWh]",null,"","","","","","","","","","","","",{"$f":"IF(AND(ISNUMBER(P25),ISNUMBER(D25)),P25-D25,\"\")","v":""}]
[null,null,"Solaranlage [kWh]",null,"","","","","","","","","","","","",{"$f":"IF(AND(ISNUMBER(P26),ISNUMBER(D26)),P26-D26,\"\")","v":""}]
[null,null,"Wärmerückgewinnung [kWh]",null,"","","","","","","","","","","","",{"$f":"IF(AND(ISNUMBER(P27),ISNUMBER(D27)),P27-D27,\"\")","v":""}]
[null,null,"Summe [kWh]",null,{"$f":"SUM(E32:E36)","v":0},{"$f":"SUM(F32:F36)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Anteil fossil [%]",null,{"$f":"IF(E34<>\"\",E34/E37*100,\"\")","v":""},"","","","","","","","","","","",""]
[null,null,"Anteil Wärmerückgewinnung [%]",null,{"$f":"IF(E36<>\"\",E36/(IF(E32>0,E32,0)+IF(E33>0,E33,0))*100,\"\")","v":""},{"$f":"IF(F36<>\"\",F36/(IF(F32>0,F32,0)+IF(F33>0,F33,0))*100,\"\")","v":""},"","","","","","","","","","",""]
[]
["A2","Wärmeverteilung"]
[]
[null,"A2.1 Zählerstände Einspeisung und Verkauf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,"Netzzähler vorhanden"]
[]
[null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),-1)","v":"2013-02-28"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"}]
[null,null,"Wärmeverkauf [kWh]"]
[null,null,"Wärmemenge eingespeist [kWh]"]
[null,null,"Wasserumlauf [m³]"]
[]
[null,"A1.2 Netzdaten"]
[]
[null,null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"},"Summe","Wärmeerlös [€]"]
[null,null,"Wärmeverkauf [kWh]",null,{"$f":"IF(E49>D49,E49-D49,\"\")","v":""},{"$f":"IF(F49>E49,F49-E49,\"\")","v":""},"","","","","","","","","","",{"$f":"IF(P49>D49,P49-D49,\"\")","v":""}]
[null,null,"eingespeiste Wärmemenge [kWh]",null,{"$f":"IF($Y$45=1,IF(E50>D50,E50-D50,\"\"),E37)","v":""},"","","","","","","","","","","",{"$f":"IF($Y$45=1,IF(P50>D50,P50-D50,\"\"),Q37)","v":""}]
[null,null,"Wassermenge [m³]",null,{"$f":"IF(E51>D51,E51-D51,\"\")","v":""},{"$f":"IF(F51>E51,F51-E51,\"\")","v":""},"","","","","","","","","","",{"$f":"IF(P51>D51,P51-D51,\"\")","v":""}]
[null,null,"spez. Umlauf [m³/MWh]",null,{"$f":"IF(AND(E57<>\"\",E58<>\"\"),E58/(E57/1000),\"\")","v":""},{"$f":"IF(AND(F57<>\"\",F58<>\"\"),F58/(F57/1000),\"\")","v":""},"","","","","","","","","","",""]
[null,null,"Netzverlust [kWh]",null,{"$f":"IF(AND(E56<>\"\",E57<>\"\"),E57-E56,\"\")","v":""},{"$f":"IF(AND(F56<>\"\",F57<>\"\"),F57-F56,\"\")","v":""},"","","","","","","","","","",""]
[null,null,"Netzverlust [%]",null,{"$f":"IF(E60<>\"\",E60/E57*100,\"\")","v":""},{"$f":"IF(F60<>\"\",F60/F57*100,\"\")","v":""},"","","","","","","","","","",""]
[]
["A3","Brennstoffe"]
[]
[null,"A3.1 Hackgut"]
[]
[null,null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"},"Summe","Kosten [€]","Kosten [€/Einheit]","Wassergehalt"]
[null,null,"eigenes Waldhackgut",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E68:P68)","v":0},null,{"$f":"IF(AND(Q68<>\"\",R68<>\"\"),R68/Q68,\"\")","v":""}]
[null,null,"Waldhackgut",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E69:P69)","v":0},null,""]
[null,null,"Industriehackgut (SNP)",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
[null,null,"Sägespäne",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,""]
[null,null,"Rinde",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E72:P72)","v":0},null,""]
[null,null,"Hobelspäne",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E73:P73)","v":0},null,""]
[null,null,"Baumschnitt",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E74:P74)","v":0},null,""]
[null,null,"Sonstiges",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E75:P75)","v":0},null,""]
[null,null,"Summe",null,{"$f":"SUM(E68:E75)","v":0},{"$f":"SUM(F68:F75)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"A3.2 Pellets"]
[]
[null,null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"},"Summe","Kosten [€]","Kosten [€/Einheit]"]
[null,null,"Pellets","[kg]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E81:P81)","v":0},null,{"$f":"IF(AND(Q81<>\"\",R81<>\"\"),R81/Q81,\"\")","v":""}]
[]
[null,"A3.3 fossile Brennstoffe"]
[]
[null,null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"},"Summe","Kosten [€]","Kosten [€/Einheit]"]
[null,null,"Heizöl EL","[l]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E86:P86)","v":0},null,{"$f":"IF(AND(Q86<>\"\",R86<>\"\"),R86/Q86,\"\")","v":""}]
[null,null,"Erdgas","[kWh]",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E87:P87)","v":0},null,{"$f":"IF(AND(Q87<>\"\",R87<>\"\"),R87/Q87,\"\")","v":""}]
[]
["A4","Betrieb"]
[]
[null,"A4.1 Zählerstände Strom"]
[]
[null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),-1)","v":"2013-02-28"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"}]
[null,null,"Strom [kWh]"]
[]
[null,"A4.2 Stromverbrauch"]
[]
[null,null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"},"Summe","Kosten [€]"]
[null,null,"Stromverbrauch [kWh]",null,{"$f":"IF(E94>D94,E94-D94,\"\")","v":""},{"$f":"IF(F94>E94,F94-E94,\"\")","v":""},"","","","","","","","","","",{"$f":"IF(P94>D94,P94-D94,\"\")","v":""}]
[null,null,"spez. Stromverbrauch [kWh/MWherz.]",null,{"$f":"IF(AND(E99<>\"\",E37<>\"\"),E99/(E37/1000),\"\")","v":""},"","","","","","","","","","","",""]
[]
[null,"A4.3 Asche"]
[]
[null,null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"},"Summe","Kosten [€]","Kosten [€/Einheit]"]
[null,null,"Rostasche [kg]",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E105:P105)","v":0},null,{"$f":"IF(AND(Q105<>\"\",R105<>\"\"),R105/Q105,\"\")","v":""}]
[null,null,"Mischasche [kg]",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E106:P106)","v":0},null,{"$f":"IF(AND(Q106<>\"\",R106<>\"\"),R106/Q106,\"\")","v":""}]
[null,null,"Flugasche [kg]",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E107:P107)","v":0},null,{"$f":"IF(AND(Q107<>\"\",R107<>\"\"),R107/Q107,\"\")","v":""}]
[null,null,"Feinstflugasche [kg]",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E108:P108)","v":0},null,{"$f":"IF(AND(Q108<>\"\",R108<>\"\"),R108/Q108,\"\")","v":""}]
[null,null,"Summe Asche [kg]",null,{"$f":"SUM(E105:E108)","v":0},{"$f":"SUM(F105:F108)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R105:R108)","v":0},{"$f":"IF(AND(Q109<>\"\",R109<>\"\",Q109>0),R109/Q109,\"\")","v":""}]
[null,null,"spez. Aschenmenge [kg/MWherz.]",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q109>0,OR(Q32<>\"\",Q33<>\"\")),Q109/((Q32+Q33)/1000),\"\")","v":""}]
[]
[null,"A4.3 Sonstiges"]
[]
[null,null,null,null,{"$f":"EOMONTH(DATE($D$15,$X$16,1),0)","v":"2013-03-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),1)","v":"2013-04-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),2)","v":"2013-05-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),3)","v":"2013-06-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),4)","v":"2013-07-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),5)","v":"2013-08-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),6)","v":"2013-09-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),7)","v":"2013-10-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),8)","v":"2013-11-30"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),9)","v":"2013-12-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),10)","v":"2014-01-31"},{"$f":"EOMONTH(DATE($D$15,$X$16,1),11)","v":"2014-02-28"},"Summe","Kosten [€]","Kosten [€/Einheit]"]
[null,null,"Personalaufwand [h]",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E115:P115)","v":0},null,{"$f":"IF(AND(Q115<>\"\",R115<>\"\"),R115/Q115,\"\")","v":""}]
[null,null,"Kondensatwasser [m³]",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E116:P116)","v":0},null,{"$f":"IF(AND(Q116<>\"\",R116<>\"\"),R116/Q116,\"\")","v":""}]
[null,null,"Wartung & Instandhaltung [€]",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E117:P117)","v":0},{"$f":"Q117","v":0}]
[null,null,"Miete [€]",null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"Q118","v":0}]
[null,null,"sonstige Kosten [€]",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E119:P119)","v":0},{"$f":"Q119","v":0}]
[null,null,"Summe [€]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R112:R119)","v":0}]
[]
["A5","Wärmegestehungskosten (exkl. Anlagenkosten)"]
[]
[null,null,null,null,"[€/MWhverk.]","[%]"]
[null,null,"Biomasse",null,{"$f":"IF(ISNUMBER((R76+R81)/($P$49/1000)),(R76+R81)/($P$49/1000),\"\")","v":""},{"$f":"IF(ISNUMBER((R76+R81)/$R$56),100*(R76+R81)/$R$56,\"\")","v":""}]
[null,null,"fossile Energie",null,{"$f":"IF(ISNUMBER((R86+R87)/($P$49/1000)),(R86+R87)/($P$49/1000),\"\")","v":""},{"$f":"IF(ISNUMBER((R86+R87)/$R$56),100*(R86+R87)/$R$56,\"\")","v":""}]
[null,null,"Strom",null,{"$f":"IF(ISNUMBER(R99/($P$49/1000)),R99/($P$49/1000),\"\")","v":""},{"$f":"IF(ISNUMBER(R99/$R$56),100*R99/$R$56,\"\")","v":""}]
[null,null,"Asche",null,{"$f":"IF(ISNUMBER(R109/($P$49/1000)),R109/($P$49/1000),\"\")","v":""},{"$f":"IF(ISNUMBER(R109/$R$56),100*R109/$R$56,\"\")","v":""}]
[null,null,"Wartung & Instandhaltung",null,{"$f":"IF(ISNUMBER(R117/($P$49/1000)),R117/($P$49/1000),\"\")","v":""},{"$f":"IF(ISNUMBER(R117/$R$56),100*R117/$R$56,\"\")","v":""}]
[null,null,"Personal",null,{"$f":"IF(ISNUMBER(R115/($P$49/1000)),R115/($P$49/1000),\"\")","v":""},{"$f":"IF(ISNUMBER(R115/$R$56),100*R115/$R$56,\"\")","v":""}]
[null,null,"Kondensat, Miete, sonst.",null,{"$f":"IF(ISNUMBER((R119+R118+R116)/($P$49/1000)),(R119+R118+R116)/($P$49/1000),\"\")","v":""},{"$f":"IF(ISNUMBER((R119+R118+R116)/$R$56),100*(R119+R118+R116)/$R$56,\"\")","v":""}]
[null,null,"Summe",null,{"$f":"SUM(E125:E131)","v":0},{"$f":"SUM(F125:F131)","v":0}]

{"sheet":"Ausdruck Erfassung","index":1,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,0,8,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Biomasse Nahwärme -\nBetriebsdatenerfassung - Zählerstände"]
[]
[null,null,null,{"$f":"Excel!D22","v":"2013-02-28"},{"$f":"Excel!E22","v":"2013-03-31"},{"$f":"Excel!F22","v":"2013-04-30"},{"$f":"Excel!G22","v":"2013-05-31"},{"$f":"Excel!H22","v":"2013-06-30"},{"$f":"Excel!I22","v":"2013-07-31"},{"$f":"Excel!J22","v":"2013-08-31"}]
[null,null,"Biomassekessel 1 [kWh]"]
[null,null,"Biomassekessel 2 [kWh]"]
[null,null,"Öl-/Gaskessel [kWh]"]
[null,null,"Solaranlage [kWh]"]
[null,null,"Wärmerückgewinnung [kWh]"]
[null,null,"Wärmeverkauf (wenn bekannt) [kWh]"]
[null,null,"Wärmemenge eingespeist [kWh]"]
[null,null,"Wasserumlauf [m³]"]
[null,null,"Strom [kWh]"]
[]
[]
[null,null,null,{"$f":"Excel!K22","v":"2013-09-30"},{"$f":"Excel!L22","v":"2013-10-31"},{"$f":"Excel!M22","v":"2013-11-30"},{"$f":"Excel!N22","v":"2013-12-31"},{"$f":"Excel!O22","v":"2014-01-31"},{"$f":"Excel!P22","v":"2014-02-28"}]
[null,null,"Biomassekessel 1 [kWh]"]
[null,null,"Biomassekessel 2 [kWh]"]
[null,null,"Öl-/Gaskessel [kWh]"]
[null,null,"Solaranlage [kWh]"]
[null,null,"Wärmerückgewinnung [kWh]"]
[null,null,"Wärmeverkauf (wenn bekannt) [kWh]"]
[null,null,"Wärmemenge eingespeist [kWh]"]
[null,null,"Wasserumlauf [m³]"]
[null,null,"Strom [kWh]"]