{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Tabelle2"],"not_rendered":{"charts":0,"images":0,"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":"Tabelle1","index":0,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,20,46,21],[41,20,41,21],[42,20,42,21],[43,20,43,21],[44,20,44,21],[45,20,45,21],[36,20,36,21],[37,20,37,21],[38,20,38,21],[39,20,39,21],[40,20,40,21],[31,20,31,21],[32,20,32,21],[33,20,33,21],[34,20,34,21],[35,20,35,21],[2,0,4,0],[0,0,0,8],[0,10,0,17],[1,20,1,21],[22,20,22,21],[18,20,18,21],[19,20,19,21],[20,20,20,21],[21,20,21,21],[1,18,3,18],[1,19,3,19],[23,20,23,21],[24,20,24,21],[25,20,25,21],[26,20,26,21],[27,20,27,21],[28,20,28,21],[29,20,29,21],[30,20,30,21],[5,20,5,21],[6,20,6,21],[7,20,7,21],[8,20,8,21],[9,20,9,21],[10,20,10,21],[11,20,11,21],[12,20,12,21],[13,20,13,21],[14,20,14,21],[15,20,15,21],[16,20,16,21],[17,20,17,21]]}
["Heizung",null,null,null,null,null,null,null,null,null,"Warmwasser",null,null,null,null,null,null,null,null,null,null,null,"HZ","WW"]
["Ver-brauchs-Monat","Monats- Verbrauch     lt. Techem          KW   ","Monats Vergleichs- Haushalte      KW","Durch-schnitt eigener Jahr","Durch-schnit Vergleichs- Hasushalt Jahr","Durchschnitt zu Vergleichs- Haushalte in %","Durchschnitt zu Vergleichs- Haushalte in KW","Mehr-verbrauch zum  VJ  KW","Mehr-verbrauch zum  VJ     %",{"$f":"COUNTA(B6:B31)","v":24},"Monats- Verbrauch     lt. Techem          KW   ","Monats Vergleichs- Haushalte      KW","Durch-schnitt eigener Jahr","Durch-schnit Vergleichs- Hasushalt Jahr","Durchschnit Vergleichs- Haushalte in %","Durchschnit Vergleichs- Haushalte in KW","Mehr-verbrauch zum  VJ  KW","Mehr-verbrauch zum  VJ     %","HZ     Jahr aufgelaufen","WW     Jahr aufgelaufen","VJ aufgelaufen",null,{"$f":"SUM(B32:B43)","v":1665},{"$f":"SUM(K32:K313)","v":500}]
[null,"eigener aufgelaufener","Vg. Haush. aufgelaufener",null,null,null,null,null,null,null,"eigener aufgelaufener","Vg. Haush. aufgelaufener"]
[null,"Verbrauch","Verbrauch","Verbrauch","Verbrauch","Verbrauch","Verbrauch",null,null,null,"Verbrauch","Verbrauch","Verbrauch","Verbrauch","Verbrauch","Verbrauch"]
[null,{"$f":"SUM(B6:B31)","v":5745},{"$f":"SUM(C6:C31)","v":22527},{"$f":"SUM(B5/J2)","v":239.375},{"$f":"SUM(C5/J2)","v":938.625},{"$f":"SUM(SUM(G5/C5))","v":-0.74497269942735389},{"$f":"SUM(B5-C5)","v":-16782},null,null,null,{"$f":"SUM(K6:K31)","v":1726},{"$f":"SUM(L6:L31)","v":5175},{"$f":"SUM(K5/J2)","v":71.916666666666671},{"$f":"SUM(L5/J2)","v":215.625},{"$f":"SUM(SUM(P5/L5))","v":-0.66647342995169079},{"$f":"SUM(K5-L5)","v":-3449}]
["2022-11-05",87,1186,null,null,{"$f":"SUM(SUM(G6/C6))","v":-0.92664418212478916},{"$f":"SUM(B6-C6)","v":-1099},null,null,null,163,196,null,null,{"$f":"IF(K6=\"\",\"\",SUM(P6/L6))","v":-0.1683673469387755},{"$f":"SUM(K6-L6)","v":-33},null,null,null,null,{"$f":"IF(C6=\"\",\"\",\"Aktuell aufgel.\")","v":"Aktuell aufgel."}]
["2022-12-05",488,1581,null,null,{"$f":"SUM(SUM(G7/C7))","v":-0.69133459835547117},{"$f":"SUM(B7-C7)","v":-1093},null,null,null,238,203,null,null,{"$f":"IF(K7=\"\",\"\",SUM(P7/L7))","v":0.17241379310344829},{"$f":"SUM(K7-L7)","v":35},null,null,null,null,"Aktuell aufgel."]
["2023-01-05",439,1680,null,null,-0.73869047619047623,-1241,null,null,null,138,203,null,null,{"$f":"IF(K8=\"\",\"\",SUM(P8/L8))","v":-0.32019704433497537},{"$f":"SUM(K8-L8)","v":-65},null,null,null,null,"Aktuell aufgel."]
["2023-02-05",430,1482,null,null,-0.70985155195681515,-1052,null,null,null,77,183,null,null,{"$f":"SUM(SUM(P9/L9))","v":-0.57923497267759561},-106,null,null,null,null,"Aktuell aufgel."]
["2023-03-05",326,1285,null,null,-0.7463035019455253,-959,null,null,null,64,203,null,null,-0.68472906403940892,-139,null,null,null,null,"Aktuell aufgel."]
["2023-04-05",147,790,null,null,-0.8139240506329114,-643,null,null,null,77,196,null,null,-0.6071428571428571,-119,null,null,null,null,"Aktuell aufgel."]
["2023-05-05",23,395,null,null,-0.9417721518987342,-372,null,null,null,64,203,null,null,-0.68472906403940892,-139,null,null,null,null,"Aktuell aufgel."]
["2023-06-05",0,129,null,null,-1,-129,null,null,null,39,196,null,null,-0.80102040816326525,-157,null,null,null,null,"Aktuell aufgel."]
["2023-07-05",0,133,null,null,-1,-133,null,null,null,51,203,null,null,-0.74876847290640391,-152,null,null,null,null,"Aktuell aufgel."]
["2023-08-05",null,133,null,null,-1,-133,null,null,null,51,203,null,null,-0.74876847290640391,-152,null,null,null,null,"Aktuell aufgel."]
["2023-09-05",2,296,null,null,-0.9932432432432432,-294,null,null,null,51,196,null,null,-0.73979591836734693,-145,null,null,null,null,"Aktuell aufgel."]
["2023-10-05",49,790,null,null,-0.9379746835443038,-741,null,{"$f":"SUM(SUM(H17/B17))","v":0},null,64,203,null,null,-0.68472906403940892,-139,null,{"$f":"SUM(SUM(Q17/K17))","v":0},null,null,"Aktuell aufgel."]
["2023-11-05",357,1186,null,null,-0.69898819561551429,-829,{"$f":"IF(B18=\"\",\"\",SUM(B18-B6))","v":270},0.75630252100840334,null,77,196,null,null,-0.6071428571428571,-119,{"$f":"IF(K18=\"\",\"\",SUM(K18-K6))","v":-86},-1.1168831168831168,null,null,"Aktuell aufgel."]
["2023-12-05",687,1581,null,null,-0.56546489563567359,-894,199,0.28966521106259097,null,39,203,null,null,-0.80788177339901479,-164,-199,-5.1025641025641022,null,null,"Aktuell aufgel."]
["2024-01-05",734,1680,null,null,-0.56309523809523809,-946,295,0.40190735694822888,null,39,203,null,null,-0.80788177339901479,-164,-99,-2.5384615384615383,{"$f":"IF(C20=\"\",\"\",SUM(B$20:B20))","v":734},{"$f":"IF(C20=\"\",\"\",SUM(K$20:K20))","v":39},"Aktuell aufgel.",null,{"$f":"IF(C20=\"\",\"\",SUM(B$8:B8))","v":439},{"$f":"IF(C20=\"\",\"\",SUM(K$8:K8))","v":138}]
["2024-02-05",328,1482,null,null,-0.77867746288798922,-1154,{"$f":"IF(B21=\"\",\"\",SUM(B21-B9))","v":-102},{"$f":"SUM(SUM(H21/B21))","v":-0.31097560975609756},null,39,183,null,null,-0.78688524590163933,-144,{"$f":"IF(K21=\"\",\"\",SUM(K21-K9))","v":-38},{"$f":"SUM(SUM(Q21/K21))","v":-0.97435897435897434},{"$f":"IF(C21=\"\",\"\",SUM(B$20:B21))","v":1062},{"$f":"IF(C21=\"\",\"\",SUM(K$20:K21))","v":78},"Aktuell aufgel.",null,{"$f":"IF(C21=\"\",\"\",SUM(B$8:B9))","v":869},{"$f":"IF(C21=\"\",\"\",SUM(K$8:K9))","v":215}]
["2024-03-05",128,1285,null,null,-0.90038910505836578,-1157,{"$f":"IF(B22=\"\",\"\",SUM(B22-B10))","v":-198},{"$f":"SUM(SUM(H22/B22))","v":-1.546875},null,64,203,null,null,-0.68472906403940892,-139,{"$f":"IF(K22=\"\",\"\",SUM(K22-K10))","v":0},{"$f":"SUM(SUM(Q22/K22))","v":0},{"$f":"IF(C22=\"\",\"\",SUM(B$20:B22))","v":1190},{"$f":"IF(C22=\"\",\"\",SUM(K$20:K22))","v":142},"Aktuell aufgel.",null,{"$f":"IF(C22=\"\",\"\",SUM(B$8:B10))","v":1195},{"$f":"IF(C22=\"\",\"\",SUM(K$8:K10))","v":279}]
["2024-04-05",170,790,null,null,-0.78481012658227844,-620,23,0.13529411764705881,null,39,196,null,null,-0.80102040816326525,-157,-38,-0.97435897435897434,{"$f":"IF(C23=\"\",\"\",SUM(B$20:B23))","v":1360},{"$f":"IF(C23=\"\",\"\",SUM(K$20:K23))","v":181},{"$f":"IF(C23=\"\",\"\",\"Aktuell aufgel.\")","v":"Aktuell aufgel."},null,{"$f":"IF(C23=\"\",\"\",SUM(B$8:B11))","v":1342},{"$f":"IF(C23=\"\",\"\",SUM(K$8:K11))","v":356}]
["2024-05-05",0,395,null,null,-1,-395,-23,{"$f":"SUM(SUM(H24/B24))","v":{"$error":"#DIV/0!"}},null,51,203,null,null,-0.74876847290640391,-152,-13,-0.25490196078431371,{"$f":"IF(C24=\"\",\"\",SUM(B$20:B24))","v":1360},{"$f":"IF(C24=\"\",\"\",SUM(K$20:K24))","v":232},{"$f":"IF(C24=\"\",\"\",\"Aktuell aufgel.\")","v":"Aktuell aufgel."},null,{"$f":"IF(C24=\"\",\"\",SUM(B$8:B12))","v":1365},{"$f":"IF(C24=\"\",\"\",SUM(K$8:K12))","v":420}]
["2024-06-05",2,129,null,null,-0.98449612403100772,-127,2,1,null,26,196,null,null,-0.86734693877551017,-170,-13,-0.5,{"$f":"IF(C25=\"\",\"\",SUM(B$20:B25))","v":1362},{"$f":"IF(C25=\"\",\"\",SUM(K$20:K25))","v":258},{"$f":"IF(C25=\"\",\"\",\"Aktuell aufgel.\")","v":"Aktuell aufgel."},null,{"$f":"IF(C25=\"\",\"\",SUM(B$8:B13))","v":1365},{"$f":"IF(C25=\"\",\"\",SUM(K$8:K13))","v":459}]
["2024-07-05",59,133,null,null,-0.55639097744360899,-74,59,1,null,46,203,null,null,-0.77339901477832518,-157,-5,-0.10869565217391304,{"$f":"IF(C26=\"\",\"\",SUM(B$20:B26))","v":1421},{"$f":"IF(C26=\"\",\"\",SUM(K$20:K26))","v":304},"Aktuell aufgel.",null,{"$f":"IF(C26=\"\",\"\",SUM(B$8:B14))","v":1365},{"$f":"IF(C26=\"\",\"\",SUM(K$8:K14))","v":510}]
["2024-08-05",null,133,null,null,-1,-133,"",{"$error":"#VALUE!"},null,46,203,null,null,-0.77339901477832518,-157,-5,-0.10869565217391304,{"$f":"IF(C27=\"\",\"\",SUM(B$20:B27))","v":1421},{"$f":"IF(C27=\"\",\"\",SUM(K$20:K27))","v":350},"Aktuell aufgel.",null,{"$f":"IF(C27=\"\",\"\",SUM(B$8:B15))","v":1365},{"$f":"IF(C27=\"\",\"\",SUM(K$8:K15))","v":561}]
["2024-09-05",6,296,null,null,-0.97972972972972971,-290,4,0.66666666666666663,null,23,196,null,null,-0.88265306122448983,-173,-28,-1.2173913043478262,{"$f":"IF(C28=\"\",\"\",SUM(B$20:B28))","v":1427},{"$f":"IF(C28=\"\",\"\",SUM(K$20:K28))","v":373},"Aktuell aufgel.",null,{"$f":"IF(C28=\"\",\"\",SUM(B$8:B16))","v":1367},{"$f":"IF(C28=\"\",\"\",SUM(K$8:K16))","v":612}]
["2024-10-05",140,790,null,null,-0.82278481012658233,-650,91,0.65,null,46,203,null,null,-0.77339901477832518,-157,-18,-0.39130434782608697,{"$f":"IF(C29=\"\",\"\",SUM(B$20:B29))","v":1567},{"$f":"IF(C29=\"\",\"\",SUM(K$20:K29))","v":419},"Aktuell aufgel.",null,{"$f":"IF(C29=\"\",\"\",SUM(B$8:B17))","v":1416},{"$f":"IF(C29=\"\",\"\",SUM(K$8:K17))","v":676}]
["2024-11-05",491,1186,null,null,-0.58600337268128166,-695,134,0.27291242362525459,null,80,196,null,null,-0.59183673469387754,-116,3,3.7499999999999999E-2,{"$f":"IF(C30=\"\",\"\",SUM(B$20:B30))","v":2058},{"$f":"IF(C30=\"\",\"\",SUM(K$20:K30))","v":499},"Aktuell aufgel.",null,{"$f":"IF(C30=\"\",\"\",SUM(B$8:B18))","v":1773},{"$f":"IF(C30=\"\",\"\",SUM(K$8:K18))","v":753}]
["2024-12-05",652,1581,null,null,-0.58760278304870339,-929,-35,-5.3680981595092027E-2,null,34,203,null,null,-0.83251231527093594,-169,-5,-0.14705882352941177,{"$f":"IF(C31=\"\",\"\",SUM(B$20:B31))","v":2710},{"$f":"IF(C31=\"\",\"\",SUM(K$20:K31))","v":533},"Aktuell aufgel.",null,{"$f":"IF(C31=\"\",\"\",SUM(B$8:B19))","v":2460},{"$f":"IF(C31=\"\",\"\",SUM(K$8:K19))","v":792}]
["2025-01-05",715,1682,null,null,{"$f":"SUM(SUM(G32/C32))","v":-0.57491082045184305},{"$f":"SUM(B32-C32)","v":-967},{"$f":"IF(B32=\"\",\"\",SUM(B32-B20))","v":-19},{"$f":"SUM(SUM(H32/B32))","v":-2.6573426573426574E-2},null,57,203,null,null,{"$f":"SUM(SUM(P32/L32))","v":-0.71921182266009853},{"$f":"SUM(K32-L32)","v":-146},{"$f":"IF(K32=\"\",\"\",SUM(K32-K20))","v":18},{"$f":"SUM(SUM(Q32/K32))","v":0.31578947368421051},{"$f":"IF(C32=\"\",\"\",SUM(B$32:B32))","v":715},{"$f":"IF(C32=\"\",\"\",SUM(K$32:K32))","v":57},{"$f":"IF(C32=\"\",\"\",\"Aktuell aufgel.\")","v":"Aktuell aufgel."},null,{"$f":"IF(C32=\"\",\"\",SUM(B$8:B20))","v":3194},{"$f":"IF(C32=\"\",\"\",SUM(K$8:K20))","v":831}]
["2025-02-05",584,1482,null,null,-0.60593792172739536,-898,256,0.43835616438356162,null,46,183,null,null,-0.74863387978142082,-137,7,0.15217391304347827,{"$f":"IF(C33=\"\",\"\",SUM(B$32:B33))","v":1299},{"$f":"IF(C33=\"\",\"\",SUM(K$32:K33))","v":103},"Aktuell aufgel.",null,{"$f":"IF(C33=\"\",\"\",SUM(B$20:B21))","v":1062},{"$f":"IF(C33=\"\",\"\",SUM(K$20:K21))","v":78}]
["2025-03-05",338,1285,null,null,-0.73696498054474713,-947,210,0.62130177514792895,null,57,203,null,null,-0.71921182266009853,-146,-7,-0.12280701754385964,{"$f":"IF(C34=\"\",\"\",SUM(B$32:B34))","v":1637},{"$f":"IF(C34=\"\",\"\",SUM(K$32:K34))","v":160},"Aktuell aufgel.",null,{"$f":"IF(C34=\"\",\"\",SUM(B$20:B22))","v":1190},{"$f":"IF(C34=\"\",\"\",SUM(K$20:K22))","v":142}]
["2025-04-05",28,790,null,null,-0.96455696202531649,-762,-142,-5.0714285714285712,null,46,196,null,null,-0.76530612244897955,-150,7,0.15217391304347827,{"$f":"IF(C35=\"\",\"\",SUM(B$32:B35))","v":1665},{"$f":"IF(C35=\"\",\"\",SUM(K$32:K35))","v":206},"Aktuell aufgel.",null,{"$f":"IF(C35=\"\",\"\",SUM(B$8:B23))","v":3820},{"$f":"IF(C35=\"\",\"\",SUM(K$8:K23))","v":973}]
["2025-05-05",0,395,null,null,-1,-395,{"$f":"IF(B36=\"\",\"\",SUM(B36-B24))","v":0},{"$f":"SUM(SUM(H36/B36))","v":{"$error":"#DIV/0!"}},null,46,203,null,null,-0.77339901477832518,-157,-5,-0.10869565217391304,{"$f":"IF(C36=\"\",\"\",SUM(B$32:B36))","v":1665},{"$f":"IF(C36=\"\",\"\",SUM(K$32:K36))","v":252},"Aktuell aufgel.",null,{"$f":"IF(C36=\"\",\"\",SUM(B$8:B24))","v":3820},{"$f":"IF(C36=\"\",\"\",SUM(K$8:K24))","v":1024}]
["2025-06-05",0,129,null,null,-1,-129,-2,{"$error":"#DIV/0!"},null,66,196,null,null,-0.66326530612244894,-130,40,0.60606060606060608,{"$f":"IF(C37=\"\",\"\",SUM(B$32:B37))","v":1665},{"$f":"IF(C37=\"\",\"\",SUM(K$32:K37))","v":318},"Aktuell aufgel.",null,{"$f":"IF(C37=\"\",\"\",SUM(B$8:B25))","v":3822},{"$f":"IF(C37=\"\",\"\",SUM(K$8:K25))","v":1050}]
["2025-07-05",null,133,null,null,-1,-133,"",{"$error":"#VALUE!"},null,50,203,null,null,-0.75369458128078815,-153,4,0.08,null,null,"Aktuell aufgel.",null,{"$f":"IF(C38=\"\",\"\",SUM(B$8:B26))","v":3881},{"$f":"IF(C38=\"\",\"\",SUM(K$8:K26))","v":1096}]
["2025-08-05",null,133,null,null,-1,-133,"",{"$error":"#VALUE!"},null,66,203,null,null,-0.67487684729064035,-137,20,0.30303030303030304,null,null,"Aktuell aufgel.",null,{"$f":"IF(C39=\"\",\"\",SUM(B$8:B27))","v":3881},{"$f":"IF(C39=\"\",\"\",SUM(K$8:K27))","v":1142}]
["2025-09-05",null,296,null,null,-1,-296,"",{"$error":"#VALUE!"},null,66,196,null,null,-0.66326530612244894,-130,43,0.65151515151515149,null,null,"Aktuell aufgel.",null,{"$f":"IF(C40=\"\",\"\",SUM(B$8:B28))","v":3887},{"$f":"IF(C40=\"\",\"\",SUM(K$8:K28))","v":1165}]
["2025-10-05",null,3,null,null,-1,-3,"",{"$error":"#VALUE!"},null,null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,"Aktuell aufgel.",null,{"$f":"IF(C41=\"\",\"\",SUM(B$8:B29))","v":4027},{"$f":"IF(C41=\"\",\"\",SUM(K$8:K29))","v":1211}]
["2025-11-05",null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,"",null,{"$f":"IF(C42=\"\",\"\",SUM(B$8:B30))","v":""},{"$f":"IF(C42=\"\",\"\",SUM(K$8:K30))","v":""}]
["2025-12-05",null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,"",null,{"$f":"IF(C43=\"\",\"\",SUM(B$8:B31))","v":""},{"$f":"IF(C43=\"\",\"\",SUM(K$8:K31))","v":""}]
["2026-01-05",null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,"",null,{"$f":"IF(C44=\"\",\"\",SUM(B$8:B32))","v":""},{"$f":"IF(C44=\"\",\"\",SUM(K$8:K32))","v":""}]
["2026-02-05",null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,"",null,{"$f":"IF(C45=\"\",\"\",SUM(B$8:B33))","v":""},{"$f":"IF(C45=\"\",\"\",SUM(K$8:K33))","v":""}]
["2026-03-05",null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,"",null,{"$f":"IF(C46=\"\",\"\",SUM(B$8:B34))","v":""},{"$f":"IF(C46=\"\",\"\",SUM(K$8:K34))","v":""}]
["2026-04-05",null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,null,null,null,{"$error":"#DIV/0!"},0,"",{"$error":"#VALUE!"},null,null,"",null,{"$f":"IF(C47=\"\",\"\",SUM(B$8:B35))","v":""},{"$f":"IF(C47=\"\",\"\",SUM(K$8:K35))","v":""}]

{"sheet":"Tabelle2","index":1,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"B1/C1","v":{"$error":"#DIV/0!"}},3]