{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dateneingabe","Abrechnung für Wohnungsnutzer","Haftungsausschluss"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":13,"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":"Dateneingabe","index":0,"n_rows":897,"n_cols":27,"rows_kept":897,"cut":false,"hidden":false,"merged":[[896,3,896,15],[843,4,843,5],[844,4,844,5],[845,4,845,5],[846,4,846,5],[829,4,829,5],[830,4,830,5],[831,4,831,5],[832,4,832,5],[833,4,833,5],[834,4,834,5],[835,4,835,5],[836,4,836,5],[893,3,893,15],[892,3,892,15],[876,3,876,15],[875,3,875,15],[874,3,874,15],[885,3,885,15],[884,3,884,15],[880,3,880,15],[879,3,879,15],[878,3,878,15],[877,3,877,15],[3,18,4,21],[14,12,15,12],[14,6,15,6],[709,12,711,14],[396,2,550,2],[553,2,707,2],[711,2,863,2],[887,3,887,15],[881,3,881,15],[856,4,856,5],[857,4,857,5],[858,4,858,5],[847,4,847,5],[848,4,848,5],[849,4,849,5],[850,4,850,5],[851,4,851,5],[852,4,852,5],[853,4,853,5],[854,4,854,5],[855,4,855,5],[838,4,838,5],[824,4,824,5],[828,4,828,5],[890,3,890,15],[882,3,882,15],[889,3,889,15],[883,3,883,15],[888,3,888,15],[886,3,886,15],[837,4,837,5],[840,4,840,5],[841,4,841,5],[842,4,842,5],[839,4,839,5],[818,4,818,5],[819,4,819,5],[820,4,820,5],[821,4,821,5],[822,4,822,5],[823,4,823,5],[825,4,825,5],[826,4,826,5],[827,4,827,5],[809,4,809,5],[810,4,810,5],[811,4,811,5],[812,4,812,5],[813,4,813,5],[814,4,814,5],[815,4,815,5],[816,4,816,5],[817,4,817,5],[800,4,800,5],[801,4,801,5],[802,4,802,5],[803,4,803,5],[804,4,804,5],[805,4,805,5],[806,4,806,5],[807,4,807,5],[808,4,808,5],[791,4,791,5],[792,4,792,5],[793,4,793,5],[794,4,794,5],[795,4,795,5],[796,4,796,5],[797,4,797,5],[798,4,798,5],[799,4,799,5],[782,4,782,5],[783,4,783,5],[784,4,784,5],[785,4,785,5],[786,4,786,5],[787,4,787,5],[788,4,788,5],[789,4,789,5],[790,4,790,5],[773,4,773,5],[774,4,774,5],[775,4,775,5],[776,4,776,5],[777,4,777,5],[778,4,778,5],[779,4,779,5],[780,4,780,5],[781,4,781,5],[764,4,764,5],[765,4,765,5],[766,4,766,5],[767,4,767,5],[768,4,768,5],[769,4,769,5],[770,4,770,5],[771,4,771,5],[772,4,772,5],[755,4,755,5],[756,4,756,5],[757,4,757,5],[758,4,758,5],[759,4,759,5],[760,4,760,5],[761,4,761,5],[762,4,762,5],[763,4,763,5],[746,4,746,5],[747,4,747,5],[748,4,748,5],[749,4,749,5],[750,4,750,5],[751,4,751,5],[752,4,752,5],[753,4,753,5],[754,4,754,5],[737,4,737,5],[738,4,738,5],[739,4,739,5],[740,4,740,5],[741,4,741,5],[742,4,742,5],[743,4,743,5],[744,4,744,5],[745,4,745,5],[728,4,728,5],[729,4,729,5],[730,4,730,5],[731,4,731,5],[732,4,732,5],[733,4,733,5],[734,4,734,5],[735,4,735,5],[736,4,736,5],[705,4,705,5],[707,3,707,5],[706,4,706,5],[863,3,863,5],[862,4,862,5],[717,4,717,5],[716,4,716,5],[715,4,715,5],[714,4,714,5],[713,4,713,5],[712,4,712,5],[718,4,718,5],[719,4,719,5],[720,4,720,5],[721,4,721,5],[859,4,859,5],[860,4,860,5],[861,4,861,5],[722,4,722,5],[723,4,723,5],[724,4,724,5],[725,4,725,5],[726,4,726,5],[727,4,727,5],[696,4,696,5],[697,4,697,5],[698,4,698,5],[699,4,699,5],[700,4,700,5],[701,4,701,5],[702,4,702,5],[703,4,703,5],[704,4,704,5],[687,4,687,5],[688,4,688,5],[689,4,689,5],[690,4,690,5],[691,4,691,5],[692,4,692,5],[693,4,693,5],[694,4,694,5],[695,4,695,5],[678,4,678,5],[679,4,679,5],[680,4,680,5],[681,4,681,5],[682,4,682,5],[683,4,683,5],[684,4,684,5],[685,4,685,5],[686,4,686,5],[669,4,669,5],[670,4,670,5],[671,4,671,5],[672,4,672,5],[673,4,673,5],[674,4,674,5],[675,4,675,5],[676,4,676,5],[677,4,677,5],[660,4,660,5],[661,4,661,5],[662,4,662,5],[663,4,663,5],[664,4,664,5],[665,4,665,5],[666,4,666,5],[667,4,667,5],[668,4,668,5],[651,4,651,5],[652,4,652,5],[653,4,653,5],[654,4,654,5],[655,4,655,5],[656,4,656,5],[657,4,657,5],[658,4,658,5],[659,4,659,5],[642,4,642,5],[643,4,643,5],[644,4,644,5],[645,4,645,5],[646,4,646,5],[647,4,647,5],[648,4,648,5],[649,4,649,5],[650,4,650,5],[633,4,633,5],[634,4,634,5],[635,4,635,5],[636,4,636,5],[637,4,637,5],[638,4,638,5],[639,4,639,5],[640,4,640,5],[641,4,641,5],[624,4,624,5],[625,4,625,5],[626,4,626,5],[627,4,627,5],[628,4,628,5],[629,4,629,5],[630,4,630,5],[631,4,631,5],[632,4,632,5],[615,4,615,5],[616,4,616,5],[617,4,617,5],[618,4,618,5],[619,4,619,5],[620,4,620,5],[621,4,621,5],[622,4,622,5],[623,4,623,5],[606,4,606,5],[607,4,607,5],[608,4,608,5],[609,4,609,5],[610,4,610,5],[611,4,611,5],[612,4,612,5],[613,4,613,5],[614,4,614,5],[597,4,597,5],[598,4,598,5],[599,4,599,5],[600,4,600,5],[601,4,601,5],[602,4,602,5],[603,4,603,5],[604,4,604,5],[605,4,605,5],[588,4,588,5],[589,4,589,5],[590,4,590,5],[591,4,591,5],[592,4,592,5],[593,4,593,5],[594,4,594,5],[595,4,595,5],[596,4,596,5],[585,4,585,5],[586,4,586,5],[587,4,587,5],[581,4,581,5],[582,4,582,5],[583,4,583,5],[584,4,584,5],[560,4,560,5],[559,4,559,5],[566,4,566,5],[567,4,567,5],[564,4,564,5],[563,4,563,5],[562,4,562,5],[561,4,561,5],[578,4,578,5],[579,4,579,5],[580,4,580,5],[572,4,572,5],[576,4,576,5],[536,4,536,5],[537,4,537,5],[577,4,577,5],[555,13,556,13],[553,11,554,13],[555,9,556,9],[555,6,556,6],[555,7,556,7],[557,4,557,5],[555,4,556,5],[555,10,556,10],[555,8,556,8],[573,4,573,5],[574,4,574,5],[575,4,575,5],[558,4,558,5],[538,4,538,5],[539,4,539,5],[540,4,540,5],[541,4,541,5],[542,4,542,5],[543,4,543,5],[544,4,544,5],[545,4,545,5],[546,4,546,5],[550,3,550,5],[549,4,549,5],[548,4,548,5],[547,4,547,5],[568,4,568,5],[569,4,569,5],[570,4,570,5],[571,4,571,5],[553,3,554,10],[565,4,565,5],[555,3,556,3],[550,6,550,7],[527,4,527,5],[528,4,528,5],[529,4,529,5],[530,4,530,5],[531,4,531,5],[532,4,532,5],[533,4,533,5],[534,4,534,5],[535,4,535,5],[518,4,518,5],[519,4,519,5],[520,4,520,5],[521,4,521,5],[522,4,522,5],[523,4,523,5],[524,4,524,5],[525,4,525,5],[526,4,526,5],[509,4,509,5],[510,4,510,5],[511,4,511,5],[512,4,512,5],[513,4,513,5],[514,4,514,5],[515,4,515,5],[516,4,516,5],[517,4,517,5],[500,4,500,5],[501,4,501,5],[502,4,502,5],[503,4,503,5],[504,4,504,5],[505,4,505,5],[506,4,506,5],[507,4,507,5],[508,4,508,5],[491,4,491,5],[492,4,492,5],[493,4,493,5],[494,4,494,5],[495,4,495,5],[496,4,496,5],[497,4,497,5],[498,4,498,5],[499,4,499,5],[482,4,482,5],[483,4,483,5],[484,4,484,5],[485,4,485,5],[486,4,486,5],[487,4,487,5],[488,4,488,5],[489,4,489,5],[490,4,490,5],[473,4,473,5],[474,4,474,5],[475,4,475,5],[476,4,476,5],[477,4,477,5],[478,4,478,5],[479,4,479,5],[480,4,480,5],[481,4,481,5],[464,4,464,5],[465,4,465,5],[466,4,466,5],[467,4,467,5],[468,4,468,5],[469,4,469,5],[470,4,470,5],[471,4,471,5],[472,4,472,5],[455,4,455,5],[456,4,456,5],[457,4,457,5],[458,4,458,5],[459,4,459,5],[460,4,460,5],[461,4,461,5],[462,4,462,5],[463,4,463,5],[446,4,446,5],[447,4,447,5],[448,4,448,5],[449,4,449,5],[450,4,450,5],[451,4,451,5],[452,4,452,5],[453,4,453,5],[454,4,454,5],[443,4,443,5],[444,4,444,5],[445,4,445,5],[438,4,438,5],[427,4,427,5],[428,4,428,5],[429,4,429,5],[430,4,430,5],[431,4,431,5],[435,4,435,5],[436,4,436,5],[437,4,437,5],[439,4,439,5],[434,4,434,5],[440,4,440,5],[389,3,389,5],[388,3,388,5],[384,3,384,5],[383,3,383,5],[382,3,382,6],[385,3,385,5],[387,3,387,6],[441,4,441,5],[442,4,442,5],[414,4,414,5],[415,4,415,5],[408,4,408,5],[407,4,407,5],[406,4,406,5],[405,4,405,5],[403,4,403,5],[402,4,402,5],[401,4,401,5],[169,9,169,12],[169,4,170,4],[341,12,342,12],[338,4,338,5],[358,6,358,7],[341,8,342,8],[336,4,336,5],[341,9,342,9],[341,7,342,7],[334,2,334,7],[169,2,321,2],[169,3,170,3],[358,4,358,5],[337,4,337,5],[341,6,342,6],[169,5,169,8],[335,4,335,6],[341,4,342,4],[340,4,340,9],[340,3,358,3],[341,11,342,11],[331,4,332,4],[6,9,6,10],[9,12,9,13],[14,9,15,9],[6,7,7,7],[9,3,9,4],[7,9,7,10],[9,9,9,10],[13,1,13,15],[14,5,15,5],[14,3,15,3],[14,4,15,4],[14,2,166,2],[14,8,15,8],[166,3,166,5],[14,7,15,7],[14,11,15,11],[166,12,166,13],[14,13,15,13],[14,10,15,10],[6,3,6,6],[6,11,6,14],[7,11,7,14],[367,5,367,7],[380,3,380,5],[373,7,374,11],[379,3,379,5],[377,7,377,10],[381,7,381,10],[375,3,375,5],[376,3,376,5],[377,3,377,5],[378,3,378,5],[374,3,374,5],[3,2,4,6],[3,12,4,13],[891,3,891,15],[422,4,422,5],[423,4,423,5],[432,4,432,5],[433,4,433,5],[365,3,365,4],[367,3,367,4],[398,6,399,6],[398,4,399,5],[396,9,397,12],[398,7,399,7],[398,9,399,9],[416,4,416,5],[417,4,417,5],[418,4,418,5],[419,4,419,5],[420,4,420,5],[364,9,364,13],[386,12,386,13],[387,12,388,12],[387,13,388,13],[396,3,397,5],[895,3,895,15],[330,3,330,8],[331,7,331,8],[332,7,332,8],[331,3,332,3],[330,10,330,12],[333,10,333,11],[869,2,869,7],[865,3,865,11],[711,3,711,10],[398,3,399,3],[390,7,390,10],[424,4,424,5],[425,4,425,5],[426,4,426,5],[409,4,409,5],[410,4,410,5],[411,4,411,5],[412,4,412,5],[398,12,399,12],[400,4,400,5],[382,7,382,10],[385,7,385,10],[384,7,384,10],[398,8,399,8],[404,4,404,5],[421,4,421,5],[413,4,413,5],[400,13,401,15],[6,8,7,8],[396,6,397,8],[390,3,390,5],[370,3,370,6],[369,3,369,6],[368,3,368,7],[383,7,383,10],[388,7,388,10],[389,7,389,10],[387,7,387,10],[386,7,386,10],[364,3,364,6],[378,7,378,10],[379,7,379,10],[380,7,380,10],[376,7,376,10],[375,7,375,10],[366,3,366,4],[366,5,366,7]]}
[]
[null,"Achtung: Nur die hellgrau gefärbten Felder sind auszufüllen!"]
[]
[null,null,"Heizkostenabrechnung für Pelletheizungen",null,null,null,null,null,null,null,null,null,"Umlageverfahren",null,null,null,null,null,"Gradtagszahlen für Monate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand: 1/2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monat","Gradtagszahl","Monat","Gradtagszahl"]
[null,null,"Objekt1:",null,null,null,null,"Jahr3:",null,"Ersteller der Abrechnung4: ",null,null,null,null,null,null,null,null,"Januar",170,"Juli",{"$f":"40/3","v":13.333333333333334}]
[null,null,null,null,null,"Anzahl Tabellenzeilen2: ",5,null,null,"Datum5: ",null,null,null,null,null,null,null,null,"Februar",150,"August",{"$f":"40/3","v":13.333333333333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"März",130,"September",30]
[null,null,null,"Abrechnungszeitraum6: ",null,null,"bis",null,null,"Abrechnungszeitraum7: ",null,{"$f":"IF(OR(F10>H10,H10-F10>366),\"Fehler\",IF(F10<H10,(H10-F10+1),IF(F10=H10,\"\")))","v":""},"max. 365 Tage, Schaltjahr 366 Tage",null,null,null,null,null,"April",80,"Oktober",80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mai",40,"November",120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Juni",{"$f":"40/3","v":13.333333333333334},"Dezember",160]
[]
[]
[null,null,"Tabelle 1","Wohneinheit8 \n(WE)","Nutzername8","Nutz- bzw. Wohnfläche in m²","Beginn des Nutzungszeitraums","Ende des Nutzungszeitraums","Nutzungs-\nzeitraum","Auszug des Nutzer","monatl. Zahlung Heizkosten (Soll)","Zahlungseingang \nfür den Ab-\nrechnungszeitraum","Anteilige Wohndauer","Anteilig über Gradtagszahlen-methode"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(G17>=$F$10,H17<=$H$10,G17>0,H17>0),IF((H17-G17)<0,H17-G17,H17-G17+1),IF(AND(G17>=$F$10,H17>$H$10,G17>0),IF(($H$10-G17)<0,$H$10-G17,$H$10-G17+1),IF(AND(G17<=$F$10,H17<=$H$10,G17>0,H17>0),IF((H17-$F$10)<0,H17-$F$10,H17-$F$10+1),IF(AND(G17<=$F$10,G17<>0,H17=0),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G17<=$F$10,H17>$H$10),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G17>=$F$10,H17=0,G17>0),IF(($H$10-G17)<0,$H$10-G17,$H$10-G17+1),IF(OR(D17<>\"\",E17<>\"\",F17<>\"\"),H10-F10+1,\"\"))))))),\"\")","v":""},{"$f":"IF(OR(AND(G17=0,H17=0),AND(G17=\"\",H17=\"\")),\"\",IF(OR(H17>=$H$10,AND(I17<>0,OR(H17=0,H17=\"\"))),\"nein\",\"ja\"))","v":""},null,null,{"$f":"IF(ISERROR(F17*I17/$L$10),\"\",IF(COUNTIF($D$17:$D$166,VLOOKUP(D17,$D$17:$D$166,1))=1,(F17/F17)*100,((F17*I17/$L$10)/F17)*100))","v":""},{"$f":"IFERROR(IF((V17)/SUM($T$7:$T$12,$V$7:$V$12)<0,\"\",(V17)/SUM($T$7:$T$12,$V$7:$V$12)),\"\")","v":0},null,null,null,null,{"$f":"IFERROR(IF(DAY(G17)=1,IF(MONTH(G17)=1,GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=2,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=3,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=4,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=5,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=6,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=7,(GTZJbA*2/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=8,(GTZJbA*1/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=9,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=10,GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=11,GTZNov+GTZDez,IF(MONTH(G17)=12,GTZDez)))))))))))),IF(AND(DAY(G17)>0,DAY(G17)<>1),IF(MONTH(G17)=1,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=2,((28-DAY(G17)+1)/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=3,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=4,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=5,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=6,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=7,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=8,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=9,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(G17)=10,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(G17)=11,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*GTZNov)+GTZDez,IF(MONTH(G17)=12,((DAY(DATE(YEAR(G17),MONTH(G17)+1,0))-DAY(G17)+1)/DAY(DATE(YEAR(G17),MONTH(G17)+1,0))*GTZDez))))))))))))))),\"\")","v":false},{"$f":"IFERROR(IF(DAY(H17)=1,IF(MONTH(H17)=12,GTZDez+GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H17)=11,GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H17)=10,GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H17)=9,GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H17)=8,GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H17)=7,(GTZJbA*2/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H17)=6,(GTZJbA*1/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H17)=5,GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H17)=4,GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H17)=3,GTZMar+GTZFeb+GTZJan,IF(MONTH(H17)=2,GTZFeb+GTZJan,IF(MONTH(H17)=1,GTZJan)))))))))))),IF(AND(DAY(H17)>0,DAY(H17)<>1),IF(MONTH(H17)=1,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZJan),IF(MONTH(H17)=2,(DAY(H17)/28*GTZFeb)+GTZJan,IF(MONTH(H17)=3,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZMar)+GTZJan+GTZFeb,IF(MONTH(H17)=4,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZApr)+GTZJan+GTZFeb+GTZMar,IF(MONTH(H17)=5,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZMai)+GTZJan+GTZFeb+GTZMar+GTZApr,IF(MONTH(H17)=6,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai,IF(MONTH(H17)=7,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(1/3*GTZJbA),IF(MONTH(H17)=8,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(2/3*GTZJbA),IF(MONTH(H17)=9,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZSep)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA,IF(MONTH(H17)=10,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZOkt)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep,IF(MONTH(H17)=11,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZNov)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt,IF(MONTH(H17)=12,(DAY(H17)/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZDez)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov)))))))))))))),\"\")","v":false},{"$f":"IFERROR(IF(DAY(H17)=DAY(DATE(YEAR(H17),MONTH(H17)+1,0)),IF(MONTH(H17)=1,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=2,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=3,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=4,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=5,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=6,(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=7,(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=8,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=9,GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=10,GTZNov+GTZDez,IF(MONTH(H17)=11,GTZDez))))))))))),IF(AND(DAY(H17)<DAY(DATE(YEAR(H17),MONTH(H17)+1,0)),DAY(H17)<>DAY(DATE(YEAR(H17),MONTH(H17)+1,0))),IF(MONTH(H17)=1,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=2,((28-DAY(H17))/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=3,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=4,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=5,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=6,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=7,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=8,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=9,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(H17)=10,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(H17)=11,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZNov)+GTZDez,IF(MONTH(H17)=12,((DAY(DATE(YEAR(H17),MONTH(H17)+1,0))-DAY(H17))/DAY(DATE(YEAR(H17),MONTH(H17)+1,0))*GTZDez))))))))))))))),\"\")","v":1000},{"$f":"IFERROR(IF(YEAR(H17)>YEAR(G17),S17+T17,IF(YEAR(H17)=YEAR(G17),IF(AND(G17=$F$10,H17<>$H$10,YEAR(H17)<>YEAR($H$10)),S17-U17,IF(AND(G17=$F$10,H17=$H$10),S17,IF(AND(G17=$F$10,H17<>$H$10),T17,IF(AND(G17<>$F$10,H17=$H$10),S17-U17,IF(AND(G17<>$F$10,H17<>$H$10),S17-U17,\"\"))))))),\"\")","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(G18>=$F$10,H18<=$H$10,G18>0,H18>0),IF((H18-G18)<0,H18-G18,H18-G18+1),IF(AND(G18>=$F$10,H18>$H$10,G18>0),IF(($H$10-G18)<0,$H$10-G18,$H$10-G18+1),IF(AND(G18<=$F$10,H18<=$H$10,G18>0,H18>0),IF((H18-$F$10)<0,H18-$F$10,H18-$F$10+1),IF(AND(G18<=$F$10,G18<>0,H18=0),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G18<=$F$10,H18>$H$10),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G18>=$F$10,H18=0,G18>0),IF(($H$10-G18)<0,$H$10-G18,$H$10-G18+1),IF(OR(D18<>\"\",E18<>\"\",F18<>\"\"),H11-F11+1,\"\"))))))),\"\")","v":""},{"$f":"IF(OR(AND(G18=0,H18=0),AND(G18=\"\",H18=\"\")),\"\",IF(OR(H18>=$H$10,AND(I18<>0,OR(H18=0,H18=\"\"))),\"nein\",\"ja\"))","v":""},null,null,"",{"$f":"IFERROR(IF((V18)/SUM($T$7:$T$12,$V$7:$V$12)<0,\"\",(V18)/SUM($T$7:$T$12,$V$7:$V$12)),\"\")","v":0},null,null,null,null,{"$f":"IFERROR(IF(DAY(G18)=1,IF(MONTH(G18)=1,GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=2,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=3,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=4,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=5,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=6,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=7,(GTZJbA*2/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=8,(GTZJbA*1/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=9,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=10,GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=11,GTZNov+GTZDez,IF(MONTH(G18)=12,GTZDez)))))))))))),IF(AND(DAY(G18)>0,DAY(G18)<>1),IF(MONTH(G18)=1,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=2,((28-DAY(G18)+1)/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=3,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=4,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=5,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=6,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=7,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=8,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=9,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(G18)=10,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(G18)=11,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*GTZNov)+GTZDez,IF(MONTH(G18)=12,((DAY(DATE(YEAR(G18),MONTH(G18)+1,0))-DAY(G18)+1)/DAY(DATE(YEAR(G18),MONTH(G18)+1,0))*GTZDez))))))))))))))),\"\")","v":false},{"$f":"IFERROR(IF(DAY(H18)=1,IF(MONTH(H18)=12,GTZDez+GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H18)=11,GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H18)=10,GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H18)=9,GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H18)=8,GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H18)=7,(GTZJbA*2/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H18)=6,(GTZJbA*1/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H18)=5,GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H18)=4,GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H18)=3,GTZMar+GTZFeb+GTZJan,IF(MONTH(H18)=2,GTZFeb+GTZJan,IF(MONTH(H18)=1,GTZJan)))))))))))),IF(AND(DAY(H18)>0,DAY(H18)<>1),IF(MONTH(H18)=1,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZJan),IF(MONTH(H18)=2,(DAY(H18)/28*GTZFeb)+GTZJan,IF(MONTH(H18)=3,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZMar)+GTZJan+GTZFeb,IF(MONTH(H18)=4,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZApr)+GTZJan+GTZFeb+GTZMar,IF(MONTH(H18)=5,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZMai)+GTZJan+GTZFeb+GTZMar+GTZApr,IF(MONTH(H18)=6,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai,IF(MONTH(H18)=7,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(1/3*GTZJbA),IF(MONTH(H18)=8,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(2/3*GTZJbA),IF(MONTH(H18)=9,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZSep)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA,IF(MONTH(H18)=10,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZOkt)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep,IF(MONTH(H18)=11,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZNov)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt,IF(MONTH(H18)=12,(DAY(H18)/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZDez)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov)))))))))))))),\"\")","v":false},{"$f":"IFERROR(IF(DAY(H18)=DAY(DATE(YEAR(H18),MONTH(H18)+1,0)),IF(MONTH(H18)=1,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=2,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=3,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=4,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=5,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=6,(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=7,(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=8,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=9,GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=10,GTZNov+GTZDez,IF(MONTH(H18)=11,GTZDez))))))))))),IF(AND(DAY(H18)<DAY(DATE(YEAR(H18),MONTH(H18)+1,0)),DAY(H18)<>DAY(DATE(YEAR(H18),MONTH(H18)+1,0))),IF(MONTH(H18)=1,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=2,((28-DAY(H18))/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=3,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=4,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=5,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=6,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=7,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=8,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=9,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(H18)=10,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(H18)=11,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZNov)+GTZDez,IF(MONTH(H18)=12,((DAY(DATE(YEAR(H18),MONTH(H18)+1,0))-DAY(H18))/DAY(DATE(YEAR(H18),MONTH(H18)+1,0))*GTZDez))))))))))))))),\"\")","v":1000},{"$f":"IFERROR(IF(YEAR(H18)>YEAR(G18),S18+T18,IF(YEAR(H18)=YEAR(G18),IF(AND(G18=$F$10,H18<>$H$10,YEAR(H18)<>YEAR($H$10)),S18-U18,IF(AND(G18=$F$10,H18=$H$10),S18,IF(AND(G18=$F$10,H18<>$H$10),T18,IF(AND(G18<>$F$10,H18=$H$10),S18-U18,IF(AND(G18<>$F$10,H18<>$H$10),S18-U18,\"\"))))))),\"\")","v":false}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(G19>=$F$10,H19<=$H$10,G19>0,H19>0),IF((H19-G19)<0,H19-G19,H19-G19+1),IF(AND(G19>=$F$10,H19>$H$10,G19>0),IF(($H$10-G19)<0,$H$10-G19,$H$10-G19+1),IF(AND(G19<=$F$10,H19<=$H$10,G19>0,H19>0),IF((H19-$F$10)<0,H19-$F$10,H19-$F$10+1),IF(AND(G19<=$F$10,G19<>0,H19=0),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G19<=$F$10,H19>$H$10),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G19>=$F$10,H19=0,G19>0),IF(($H$10-G19)<0,$H$10-G19,$H$10-G19+1),IF(OR(D19<>\"\",E19<>\"\",F19<>\"\"),H12-F12+1,\"\"))))))),\"\")","v":""},"",null,null,{"$f":"IF(ISERROR(F19*I19/$L$10),\"\",IF(COUNTIF($D$17:$D$166,VLOOKUP(D19,$D$17:$D$166,1))=1,(F19/F19)*100,((F19*I19/$L$10)/F19)*100))","v":""},0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(G20>=$F$10,H20<=$H$10,G20>0,H20>0),IF((H20-G20)<0,H20-G20,H20-G20+1),IF(AND(G20>=$F$10,H20>$H$10,G20>0),IF(($H$10-G20)<0,$H$10-G20,$H$10-G20+1),IF(AND(G20<=$F$10,H20<=$H$10,G20>0,H20>0),IF((H20-$F$10)<0,H20-$F$10,H20-$F$10+1),IF(AND(G20<=$F$10,G20<>0,H20=0),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G20<=$F$10,H20>$H$10),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G20>=$F$10,H20=0,G20>0),IF(($H$10-G20)<0,$H$10-G20,$H$10-G20+1),IF(OR(D20<>\"\",E20<>\"\",F20<>\"\"),H13-F13+1,\"\"))))))),\"\")","v":""},"",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(G21>=$F$10,H21<=$H$10,G21>0,H21>0),IF((H21-G21)<0,H21-G21,H21-G21+1),IF(AND(G21>=$F$10,H21>$H$10,G21>0),IF(($H$10-G21)<0,$H$10-G21,$H$10-G21+1),IF(AND(G21<=$F$10,H21<=$H$10,G21>0,H21>0),IF((H21-$F$10)<0,H21-$F$10,H21-$F$10+1),IF(AND(G21<=$F$10,G21<>0,H21=0),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G21<=$F$10,H21>$H$10),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G21>=$F$10,H21=0,G21>0),IF(($H$10-G21)<0,$H$10-G21,$H$10-G21+1),IF(OR(D21<>\"\",E21<>\"\",F21<>\"\"),H14-F14+1,\"\"))))))),\"\")","v":""},"",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(G22>=$F$10,H22<=$H$10,G22>0,H22>0),IF((H22-G22)<0,H22-G22,H22-G22+1),IF(AND(G22>=$F$10,H22>$H$10,G22>0),IF(($H$10-G22)<0,$H$10-G22,$H$10-G22+1),IF(AND(G22<=$F$10,H22<=$H$10,G22>0,H22>0),IF((H22-$F$10)<0,H22-$F$10,H22-$F$10+1),IF(AND(G22<=$F$10,G22<>0,H22=0),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G22<=$F$10,H22>$H$10),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G22>=$F$10,H22=0,G22>0),IF(($H$10-G22)<0,$H$10-G22,$H$10-G22+1),IF(OR(D22<>\"\",E22<>\"\",F22<>\"\"),G15-F15+1,\"\"))))))),\"\")","v":""},"",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,{"$f":"IFERROR(IF(DAY(G24)=1,IF(MONTH(G24)=1,GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=2,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=3,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=4,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=5,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=6,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=7,(GTZJbA*2/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=8,(GTZJbA*1/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=9,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=10,GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=11,GTZNov+GTZDez,IF(MONTH(G24)=12,GTZDez)))))))))))),IF(AND(DAY(G24)>0,DAY(G24)<>1),IF(MONTH(G24)=1,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=2,((28-DAY(G24)+1)/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=3,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=4,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=5,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=6,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=7,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=8,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=9,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(G24)=10,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(G24)=11,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*GTZNov)+GTZDez,IF(MONTH(G24)=12,((DAY(DATE(YEAR(G24),MONTH(G24)+1,0))-DAY(G24)+1)/DAY(DATE(YEAR(G24),MONTH(G24)+1,0))*GTZDez))))))))))))))),\"\")","v":false},{"$f":"IFERROR(IF(DAY(H24)=1,IF(MONTH(H24)=12,GTZDez+GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H24)=11,GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H24)=10,GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H24)=9,GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H24)=8,GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H24)=7,(GTZJbA*2/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H24)=6,(GTZJbA*1/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H24)=5,GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H24)=4,GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H24)=3,GTZMar+GTZFeb+GTZJan,IF(MONTH(H24)=2,GTZFeb+GTZJan,IF(MONTH(H24)=1,GTZJan)))))))))))),IF(AND(DAY(H24)>0,DAY(H24)<>1),IF(MONTH(H24)=1,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZJan),IF(MONTH(H24)=2,(DAY(H24)/28*GTZFeb)+GTZJan,IF(MONTH(H24)=3,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZMar)+GTZJan+GTZFeb,IF(MONTH(H24)=4,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZApr)+GTZJan+GTZFeb+GTZMar,IF(MONTH(H24)=5,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZMai)+GTZJan+GTZFeb+GTZMar+GTZApr,IF(MONTH(H24)=6,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai,IF(MONTH(H24)=7,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(1/3*GTZJbA),IF(MONTH(H24)=8,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(2/3*GTZJbA),IF(MONTH(H24)=9,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZSep)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA,IF(MONTH(H24)=10,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZOkt)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep,IF(MONTH(H24)=11,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZNov)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt,IF(MONTH(H24)=12,(DAY(H24)/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZDez)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov)))))))))))))),\"\")","v":false},{"$f":"IFERROR(IF(DAY(H24)=DAY(DATE(YEAR(H24),MONTH(H24)+1,0)),IF(MONTH(H24)=1,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=2,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=3,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=4,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=5,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=6,(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=7,(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=8,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=9,GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=10,GTZNov+GTZDez,IF(MONTH(H24)=11,GTZDez))))))))))),IF(AND(DAY(H24)<DAY(DATE(YEAR(H24),MONTH(H24)+1,0)),DAY(H24)<>DAY(DATE(YEAR(H24),MONTH(H24)+1,0))),IF(MONTH(H24)=1,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=2,((28-DAY(H24))/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=3,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=4,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=5,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=6,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=7,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=8,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=9,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(H24)=10,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(H24)=11,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZNov)+GTZDez,IF(MONTH(H24)=12,((DAY(DATE(YEAR(H24),MONTH(H24)+1,0))-DAY(H24))/DAY(DATE(YEAR(H24),MONTH(H24)+1,0))*GTZDez))))))))))))))),\"\")","v":1000},false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,{"$f":"IF(ISERROR(F49*I49/$L$10),\"\",IF(COUNTIF($D$17:$D$166,VLOOKUP(D49,$D$17:$D$166,1))=1,(F49/F49)*100,((F49*I49/$L$10)/F49)*100))","v":""},0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(G54>=$F$10,H54<=$H$10,G54>0,H54>0),IF((H54-G54)<0,H54-G54,H54-G54+1),IF(AND(G54>=$F$10,H54>$H$10,G54>0),IF(($H$10-G54)<0,$H$10-G54,$H$10-G54+1),IF(AND(G54<=$F$10,H54<=$H$10,G54>0,H54>0),IF((H54-$F$10)<0,H54-$F$10,H54-$F$10+1),IF(AND(G54<=$F$10,G54<>0,H54=0),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G54<=$F$10,H54>$H$10),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G54>=$F$10,H54=0,G54>0),IF(($H$10-G54)<0,$H$10-G54,$H$10-G54+1),IF(OR(D54<>\"\",E54<>\"\",F54<>\"\"),G47-F47+1,\"\"))))))),\"\")","v":""},"",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,{"$f":"IF(ISERROR(F81*I81/$L$10),\"\",IF(COUNTIF($D$17:$D$166,VLOOKUP(D81,$D$17:$D$166,1))=1,(F81/F81)*100,((F81*I81/$L$10)/F81)*100))","v":""},0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(AND(G82=0,H82=0),AND(G82=\"\",H82=\"\")),\"\",IF(OR(H82>=$H$10,AND(I82<>0,OR(H82=0,H82=\"\"))),\"nein\",\"ja\"))","v":""},null,null,"",{"$f":"IFERROR(IF((V82)/SUM($T$7:$T$12,$V$7:$V$12)<0,\"\",(V82)/SUM($T$7:$T$12,$V$7:$V$12)),\"\")","v":0},null,null,null,null,false,false,1000,{"$f":"IFERROR(IF(YEAR(H82)>YEAR(G82),S82+T82,IF(YEAR(H82)=YEAR(G82),IF(AND(G82=$F$10,H82<>$H$10,YEAR(H82)<>YEAR($H$10)),S82-U82,IF(AND(G82=$F$10,H82=$H$10),S82,IF(AND(G82=$F$10,H82<>$H$10),T82,IF(AND(G82<>$F$10,H82=$H$10),S82-U82,IF(AND(G82<>$F$10,H82<>$H$10),S82-U82,\"\"))))))),\"\")","v":false}]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(G86>=$F$10,H86<=$H$10,G86>0,H86>0),IF((H86-G86)<0,H86-G86,H86-G86+1),IF(AND(G86>=$F$10,H86>$H$10,G86>0),IF(($H$10-G86)<0,$H$10-G86,$H$10-G86+1),IF(AND(G86<=$F$10,H86<=$H$10,G86>0,H86>0),IF((H86-$F$10)<0,H86-$F$10,H86-$F$10+1),IF(AND(G86<=$F$10,G86<>0,H86=0),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G86<=$F$10,H86>$H$10),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G86>=$F$10,H86=0,G86>0),IF(($H$10-G86)<0,$H$10-G86,$H$10-G86+1),IF(OR(D86<>\"\",E86<>\"\",F86<>\"\"),G79-F79+1,\"\"))))))),\"\")","v":""},"",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,{"$f":"IFERROR(IF(DAY(G88)=1,IF(MONTH(G88)=1,GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=2,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=3,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=4,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=5,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=6,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=7,(GTZJbA*2/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=8,(GTZJbA*1/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=9,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=10,GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=11,GTZNov+GTZDez,IF(MONTH(G88)=12,GTZDez)))))))))))),IF(AND(DAY(G88)>0,DAY(G88)<>1),IF(MONTH(G88)=1,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=2,((28-DAY(G88)+1)/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=3,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=4,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=5,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=6,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=7,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=8,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=9,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(G88)=10,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(G88)=11,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*GTZNov)+GTZDez,IF(MONTH(G88)=12,((DAY(DATE(YEAR(G88),MONTH(G88)+1,0))-DAY(G88)+1)/DAY(DATE(YEAR(G88),MONTH(G88)+1,0))*GTZDez))))))))))))))),\"\")","v":false},{"$f":"IFERROR(IF(DAY(H88)=1,IF(MONTH(H88)=12,GTZDez+GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H88)=11,GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H88)=10,GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H88)=9,GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H88)=8,GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H88)=7,(GTZJbA*2/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H88)=6,(GTZJbA*1/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H88)=5,GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H88)=4,GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H88)=3,GTZMar+GTZFeb+GTZJan,IF(MONTH(H88)=2,GTZFeb+GTZJan,IF(MONTH(H88)=1,GTZJan)))))))))))),IF(AND(DAY(H88)>0,DAY(H88)<>1),IF(MONTH(H88)=1,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZJan),IF(MONTH(H88)=2,(DAY(H88)/28*GTZFeb)+GTZJan,IF(MONTH(H88)=3,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZMar)+GTZJan+GTZFeb,IF(MONTH(H88)=4,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZApr)+GTZJan+GTZFeb+GTZMar,IF(MONTH(H88)=5,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZMai)+GTZJan+GTZFeb+GTZMar+GTZApr,IF(MONTH(H88)=6,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai,IF(MONTH(H88)=7,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(1/3*GTZJbA),IF(MONTH(H88)=8,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(2/3*GTZJbA),IF(MONTH(H88)=9,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZSep)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA,IF(MONTH(H88)=10,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZOkt)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep,IF(MONTH(H88)=11,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZNov)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt,IF(MONTH(H88)=12,(DAY(H88)/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZDez)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov)))))))))))))),\"\")","v":false},{"$f":"IFERROR(IF(DAY(H88)=DAY(DATE(YEAR(H88),MONTH(H88)+1,0)),IF(MONTH(H88)=1,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=2,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=3,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=4,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=5,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=6,(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=7,(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=8,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=9,GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=10,GTZNov+GTZDez,IF(MONTH(H88)=11,GTZDez))))))))))),IF(AND(DAY(H88)<DAY(DATE(YEAR(H88),MONTH(H88)+1,0)),DAY(H88)<>DAY(DATE(YEAR(H88),MONTH(H88)+1,0))),IF(MONTH(H88)=1,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=2,((28-DAY(H88))/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=3,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=4,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=5,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=6,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=7,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=8,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=9,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(H88)=10,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(H88)=11,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZNov)+GTZDez,IF(MONTH(H88)=12,((DAY(DATE(YEAR(H88),MONTH(H88)+1,0))-DAY(H88))/DAY(DATE(YEAR(H88),MONTH(H88)+1,0))*GTZDez))))))))))))))),\"\")","v":1000},false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,{"$f":"IF(ISERROR(F113*I113/$L$10),\"\",IF(COUNTIF($D$17:$D$166,VLOOKUP(D113,$D$17:$D$166,1))=1,(F113/F113)*100,((F113*I113/$L$10)/F113)*100))","v":""},0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(G118>=$F$10,H118<=$H$10,G118>0,H118>0),IF((H118-G118)<0,H118-G118,H118-G118+1),IF(AND(G118>=$F$10,H118>$H$10,G118>0),IF(($H$10-G118)<0,$H$10-G118,$H$10-G118+1),IF(AND(G118<=$F$10,H118<=$H$10,G118>0,H118>0),IF((H118-$F$10)<0,H118-$F$10,H118-$F$10+1),IF(AND(G118<=$F$10,G118<>0,H118=0),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G118<=$F$10,H118>$H$10),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G118>=$F$10,H118=0,G118>0),IF(($H$10-G118)<0,$H$10-G118,$H$10-G118+1),IF(OR(D118<>\"\",E118<>\"\",F118<>\"\"),G111-F111+1,\"\"))))))),\"\")","v":""},"",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,{"$f":"IF(ISERROR(F145*I145/$L$10),\"\",IF(COUNTIF($D$17:$D$166,VLOOKUP(D145,$D$17:$D$166,1))=1,(F145/F145)*100,((F145*I145/$L$10)/F145)*100))","v":""},0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(OR(AND(G146=0,H146=0),AND(G146=\"\",H146=\"\")),\"\",IF(OR(H146>=$H$10,AND(I146<>0,OR(H146=0,H146=\"\"))),\"nein\",\"ja\"))","v":""},null,null,"",{"$f":"IFERROR(IF((V146)/SUM($T$7:$T$12,$V$7:$V$12)<0,\"\",(V146)/SUM($T$7:$T$12,$V$7:$V$12)),\"\")","v":0},null,null,null,null,false,false,1000,{"$f":"IFERROR(IF(YEAR(H146)>YEAR(G146),S146+T146,IF(YEAR(H146)=YEAR(G146),IF(AND(G146=$F$10,H146<>$H$10,YEAR(H146)<>YEAR($H$10)),S146-U146,IF(AND(G146=$F$10,H146=$H$10),S146,IF(AND(G146=$F$10,H146<>$H$10),T146,IF(AND(G146<>$F$10,H146=$H$10),S146-U146,IF(AND(G146<>$F$10,H146<>$H$10),S146-U146,\"\"))))))),\"\")","v":false}]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND(G150>=$F$10,H150<=$H$10,G150>0,H150>0),IF((H150-G150)<0,H150-G150,H150-G150+1),IF(AND(G150>=$F$10,H150>$H$10,G150>0),IF(($H$10-G150)<0,$H$10-G150,$H$10-G150+1),IF(AND(G150<=$F$10,H150<=$H$10,G150>0,H150>0),IF((H150-$F$10)<0,H150-$F$10,H150-$F$10+1),IF(AND(G150<=$F$10,G150<>0,H150=0),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G150<=$F$10,H150>$H$10),IF(($H$10-$F$10)<0,$H$10-$F$10,$H$10-$F$10+1),IF(AND(G150>=$F$10,H150=0,G150>0),IF(($H$10-G150)<0,$H$10-G150,$H$10-G150+1),IF(OR(D150<>\"\",E150<>\"\",F150<>\"\"),G143-F143+1,\"\"))))))),\"\")","v":""},"",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,{"$f":"IFERROR(IF(DAY(G152)=1,IF(MONTH(G152)=1,GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=2,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=3,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=4,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=5,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=6,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=7,(GTZJbA*2/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=8,(GTZJbA*1/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=9,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=10,GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=11,GTZNov+GTZDez,IF(MONTH(G152)=12,GTZDez)))))))))))),IF(AND(DAY(G152)>0,DAY(G152)<>1),IF(MONTH(G152)=1,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=2,((28-DAY(G152)+1)/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=3,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=4,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=5,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=6,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=7,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=8,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=9,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(G152)=10,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(G152)=11,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*GTZNov)+GTZDez,IF(MONTH(G152)=12,((DAY(DATE(YEAR(G152),MONTH(G152)+1,0))-DAY(G152)+1)/DAY(DATE(YEAR(G152),MONTH(G152)+1,0))*GTZDez))))))))))))))),\"\")","v":false},{"$f":"IFERROR(IF(DAY(H152)=1,IF(MONTH(H152)=12,GTZDez+GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H152)=11,GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H152)=10,GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H152)=9,GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H152)=8,GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H152)=7,(GTZJbA*2/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H152)=6,(GTZJbA*1/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H152)=5,GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H152)=4,GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(H152)=3,GTZMar+GTZFeb+GTZJan,IF(MONTH(H152)=2,GTZFeb+GTZJan,IF(MONTH(H152)=1,GTZJan)))))))))))),IF(AND(DAY(H152)>0,DAY(H152)<>1),IF(MONTH(H152)=1,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZJan),IF(MONTH(H152)=2,(DAY(H152)/28*GTZFeb)+GTZJan,IF(MONTH(H152)=3,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZMar)+GTZJan+GTZFeb,IF(MONTH(H152)=4,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZApr)+GTZJan+GTZFeb+GTZMar,IF(MONTH(H152)=5,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZMai)+GTZJan+GTZFeb+GTZMar+GTZApr,IF(MONTH(H152)=6,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai,IF(MONTH(H152)=7,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(1/3*GTZJbA),IF(MONTH(H152)=8,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(2/3*GTZJbA),IF(MONTH(H152)=9,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZSep)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA,IF(MONTH(H152)=10,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZOkt)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep,IF(MONTH(H152)=11,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZNov)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt,IF(MONTH(H152)=12,(DAY(H152)/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZDez)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov)))))))))))))),\"\")","v":false},{"$f":"IFERROR(IF(DAY(H152)=DAY(DATE(YEAR(H152),MONTH(H152)+1,0)),IF(MONTH(H152)=1,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=2,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=3,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=4,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=5,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=6,(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=7,(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=8,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=9,GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=10,GTZNov+GTZDez,IF(MONTH(H152)=11,GTZDez))))))))))),IF(AND(DAY(H152)<DAY(DATE(YEAR(H152),MONTH(H152)+1,0)),DAY(H152)<>DAY(DATE(YEAR(H152),MONTH(H152)+1,0))),IF(MONTH(H152)=1,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=2,((28-DAY(H152))/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=3,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=4,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=5,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=6,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=7,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=8,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=9,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(H152)=10,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(H152)=11,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZNov)+GTZDez,IF(MONTH(H152)=12,((DAY(DATE(YEAR(H152),MONTH(H152)+1,0))-DAY(H152))/DAY(DATE(YEAR(H152),MONTH(H152)+1,0))*GTZDez))))))))))))))),\"\")","v":1000},false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,"","",null,null,"",0,null,null,null,null,false,false,1000,false]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M17:M166)/100","v":0}]
[]
[]
[null,null,"Tabelle 2","Wohneinheit","Name","Raumwärme: Stand Wärmemengenzähler (WMZ) in MWh",null,null,null,"Warmwasser: Stand Warmwasserzähler in m³  *"]
[null,null,null,null,null,"Zählernummer","Anfangsstand","Endstand","Verbrauch","Zählernummer","Anfangsstand","Endstand","Verbrauch"]
[null,null,null,{"$f":"D17","v":0},0,null,null,null,{"$f":"IF(ISERROR(H172-G172),\"Fehler \",IF(G172>H172,\"Fehler \",IF(G172<=H172,H172-G172)))","v":0},null,null,null,{"$f":"IF(ISERROR(K172-L172),\"Fehler \",IF(K172>L172,\"Fehler \",IF(K172<=L172,L172-K172)))","v":0},{"$f":"IFERROR(IF(I172>0,(M17/100)*F17,0),\"\")","v":0},{"$f":"IFERROR(IF(M172>0,(M17/100)*F17,0),\"\")","v":0}]
[null,null,null,0,0,null,null,null,{"$f":"IF(ISERROR(H173-G173),\"Fehler \",IF(G173>H173,\"Fehler \",IF(G173<=H173,H173-G173)))","v":0},null,null,null,{"$f":"IF(ISERROR(K173-L173),\"Fehler \",IF(K173>L173,\"Fehler \",IF(K173<=L173,L173-K173)))","v":0},{"$f":"IFERROR(IF(I173>0,(M18/100)*F18,0),\"\")","v":0},{"$f":"IFERROR(IF(M173>0,(M18/100)*F18,0),\"\")","v":0}]
[null,null,null,0,0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,0,0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,0,0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,0,0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,0,0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,0,0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,0,0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,0,0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D27","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D28","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D29","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D30","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D31","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D32","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D33","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D34","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D35","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D36","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D37","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D38","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D39","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D40","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D41","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D42","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D43","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D44","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D45","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D46","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D47","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D48","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D49","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D50","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D51","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D52","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D53","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D54","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D55","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D56","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D57","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D58","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D59","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D60","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D61","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D62","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D63","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D64","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D65","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D66","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D67","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D68","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D69","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D70","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D71","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D72","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D73","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D74","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D75","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D76","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D77","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D78","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D79","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D80","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D81","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D82","v":0},0,null,null,null,{"$f":"IF(ISERROR(H237-G237),\"Fehler \",IF(G237>H237,\"Fehler \",IF(G237<=H237,H237-G237)))","v":0},null,null,null,{"$f":"IF(ISERROR(K237-L237),\"Fehler \",IF(K237>L237,\"Fehler \",IF(K237<=L237,L237-K237)))","v":0},{"$f":"IFERROR(IF(I237>0,(M82/100)*F82,0),\"\")","v":0},{"$f":"IFERROR(IF(M237>0,(M82/100)*F82,0),\"\")","v":0}]
[null,null,null,{"$f":"D83","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D84","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D85","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D86","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D87","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D88","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D89","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D90","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D91","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D92","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D93","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D94","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D95","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D96","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D97","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D98","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D99","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D100","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D101","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D102","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D103","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D104","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D105","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D106","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D107","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D108","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D109","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D110","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D111","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D112","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D113","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D114","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D115","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D116","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D117","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D118","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D119","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D120","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D121","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D122","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D123","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D124","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D125","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D126","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D127","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D128","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D129","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D130","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D131","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D132","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D133","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D134","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D135","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D136","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D137","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D138","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D139","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D140","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D141","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D142","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D143","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D144","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D145","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D146","v":0},0,null,null,null,{"$f":"IF(ISERROR(H301-G301),\"Fehler \",IF(G301>H301,\"Fehler \",IF(G301<=H301,H301-G301)))","v":0},null,null,null,{"$f":"IF(ISERROR(K301-L301),\"Fehler \",IF(K301>L301,\"Fehler \",IF(K301<=L301,L301-K301)))","v":0},{"$f":"IFERROR(IF(I301>0,(M146/100)*F146,0),\"\")","v":0},{"$f":"IFERROR(IF(M301>0,(M146/100)*F146,0),\"\")","v":0}]
[null,null,null,{"$f":"D147","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D148","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D149","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D150","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D151","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D152","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D153","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D154","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D155","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D156","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D157","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D158","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D159","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D160","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D161","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D162","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D163","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D164","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D165","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,{"$f":"D166","v":0},0,null,null,null,0,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I172:I321)","v":0},null,null,null,{"$f":"SUM(M172:M321)","v":0},{"$f":"SUM(N172:N321)","v":0},{"$f":"SUM(O172:O321)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Warmwasser: Wärmemengenzähler in MWh9",null,null,null,null,null,null,"zentraler Warmwasserzähler10"]
[null,null,null,"Zählernummer",null,{"$f":"F10","v":"00:00:00"},{"$f":"H10","v":"00:00:00"},"Verbrauch gesamt",null,null,"Zählernummer","Anfangsbestand","Endbestand"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(G333-F333),\"Fehler\",IF(G333-F333<0,\"Fehler, neg. Verbrauch!\",IF(G333-F333<>0,G333-F333,\"\")))","v":""}]
[null,null,null,null,null,null,"Warmwassertemperatur:",55,null,null,"Verbrauch gesamt:",null,{"$f":"IF(AND(L333<>0,M333<>0),M333-L333,\"\")","v":""}]
[]
[null,null,null,null,"Lagerbestand Pellets in t",null,null,"Preis (netto)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gesamt"]
[null,null,null,null,"Anfangsbestand Pellets11",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G337","v":0},{"$f":"H337","v":0},{"$f":"$G$359","v":7},null,null,null,null,{"$f":"ROUND(S337*T337*(1+(U337/100)),2)","v":0},{"$f":"Z337-Z363","v":0}]
[null,null,null,null,"Endbestand Pellets12",null,null,{"$f":"IF($G$338<=G358,H358,IF(AND($G$338>G358,G338<=SUM(G357:G358)),((G358*H358)+(SUM(I358:I358))+(($G$338-G358)*H357))/$G$338,IF(AND($G$338>SUM(G357:G358),$G$338<=SUM(G356:G358)),((G358*H358)+(G357*H357)+(SUM(I357:I358))+(($G$338-SUM(G357:G358))*H356))/$G$338,IF(AND($G$338>SUM(G356:G358),$G$338<=SUM(G355:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(SUM(I356:I358))+(($G$338-SUM(G356:G358))*H355))/$G$338,IF(AND($G$338>SUM(G355:G358),$G$338<=SUM(G354:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(SUM(I355:I358))+(($G$338-SUM(G355:G358))*H354))/$G$338,IF(AND($G$338>SUM(G354:G358),$G$338<=SUM(G353:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(SUM(I354:I358))+(($G$338-SUM(G354:G358))*H353))/$G$338,IF(AND($G$338>SUM(G353:G358),$G$338<=SUM(G352:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(G353*H353)+(SUM(I353:I358))+(($G$338-SUM(G353:G358))*H352))/$G$338,IF(AND($G$338>SUM(G352:G358),$G$338<=SUM(G351:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(G353*H353)+(G352*H352)+(SUM(I352:I358))+(($G$338-SUM(G352:G358))*H351))/$G$338,IF(AND($G$338>SUM(G351:G358),$G$338<=SUM(G350:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(G353*H353)+(G352*H352)+(G351*H351)+(SUM(I351:I358))+(($G$338-SUM(G351:G358))*H350))/$G$338,IF(AND($G$338>SUM(G350:G358),$G$338<=SUM(G349:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(G353*H353)+(G352*H352)+(G351*H351)+(G350*H350)+(SUM(I350:I358))+(($G$338-SUM(G350:G358))*H349))/$G$338,IF(AND($G$338>SUM(G349:G358),$G$338<=SUM(G348:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(G353*H353)+(G352*H352)+(G351*H351)+(G350*H350)+(G349*H349)+(SUM(I349:I358))+(($G$338-SUM(G349:G358))*H348))/$G$338,IF(AND($G$338>SUM(G348:G358),$G$338<=SUM(G347:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(G353*H353)+(G352*H352)+(G351*H351)+(G350*H350)+(G349*H349)+(G348*H348)+(SUM(I348:I358))+(($G$338-SUM(G348:G358))*H347))/$G$338,IF(AND($G$338>SUM(G347:G358),$G$338<=SUM(G346:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(G353*H353)+(G352*H352)+(G351*H351)+(G350*H350)+(G349*H349)+(G348*H348)+(G347*H347)+(SUM(I347:I358))+(($G$338-SUM(G347:G358))*H346))/$G$338,IF(AND($G$338>SUM(G346:G358),$G$338<=SUM(G345:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(G353*H353)+(G352*H352)+(G351*H351)+(G350*H350)+(G349*H349)+(G348*H348)+(G347*H347)+(G346*H346)+(SUM(I346:I358))+(($G$338-SUM(G346:G358))*H345))/$G$338,IF(AND($G$338>SUM(G345:G358),$G$338<=SUM(G344:G358)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(G353*H353)+(G352*H352)+(G351*H351)+(G350*H350)+(G349*H349)+(G348*H348)+(G347*H347)+(G346*H346)+(G345*H345)+(SUM(I345:I358))+(($G$338-SUM(G345:G358))*H344))/$G$338,IF(AND($G$338>SUM(G344:G358),$G$338<=(SUM(G344:G358)+G337)),((G358*H358)+(G357*H357)+(G356*H356)+(G355*H355)+(G354*H354)+(G353*H353)+(G352*H352)+(G351*H351)+(G350*H350)+(G349*H349)+(G348*H348)+(G347*H347)+(G346*H346)+(G345*H345)+(G344*H344)+(SUM(I344:I358))+(($G$338-SUM(G344:G358))*H337))/$G$338,\"Fehler \"))))))))))))))))","v":0}]
[]
[]
[null,null,null,"Tabelle A","Brennstoffkosten13"]
[null,null,null,null,"Notiz zur\nLieferung; Datum","Anz. Lieferungen14","Menge in t","Preis je Tonne\n netto","Einblaspauschale netto","Betrag brutto"]
[null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G344>0,G344*H344+(G344*H344*($G$359/100))+I344+(I344*($I$359/100)),IF(G344<0,G344*H344+(G344*H344*($G$359/100))-I344-(I344*($I$359/100)),\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"G344","v":0},{"$f":"H344","v":0},{"$f":"$G$359","v":7},{"$f":"S344*T344*(1+(U344/100))","v":0},{"$f":"I344","v":0},{"$f":"$I$359","v":7},{"$f":"W344*(1+(X344/100))","v":0},{"$f":"ROUND(V344+Y344,2)","v":0},{"$f":"Z344+AA337","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G345>0,G345*H345+(G345*H345*($G$359/100))+I345+(I345*($I$359/100)),IF(G345<0,G345*H345+(G345*H345*($G$359/100))-I345-(I345*($I$359/100)),\"\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"G345","v":0},{"$f":"H345","v":0},{"$f":"$G$359","v":7},{"$f":"S345*T345*(1+(U345/100))","v":0},{"$f":"I345","v":0},{"$f":"$I$359","v":7},{"$f":"W345*(1+(X345/100))","v":0},{"$f":"ROUND(V345+Y345,2)","v":0}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,7,0,0,7,0,0]
[null,null,null,null,"plus Umsatzsteuer",null,7,null,7,{"$f":"SUM(J344:J358)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G338","v":0},{"$f":"H338","v":0},{"$f":"$G$359","v":7},null,null,null,null,{"$f":"ROUND(S361*T361*(1+(U361/100)),2)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamtkosten",{"$f":"SUM(Z337:Z358)-Z361","v":0}]
[]
[null,null,null,"Brennstoffpreis",null,null,null,"Gesamtkosten",null,"Kosten für Elektrizität in €15"]
[null,null,null,"Verbrauchdaten Pellets",null,{"$f":"$G$337+SUM(G344:G358)-$G$338","v":0},{"$f":"F366*H370","v":0},{"$f":"Z363","v":0},null,"Stromzähler",null,"Zählernummer",{"$f":"F10","v":"00:00:00"},{"$f":"H10","v":"00:00:00"}]
[null,null,null,"Durchschnittspreis brutto",null,{"$f":"H366/F366","v":{"$error":"#DIV/0!"}},null,null,null,"Stand",null,null,0]
[null,null,null,"Preis je kWh",null,{"$f":"F367/(H370*1000)","v":{"$error":"#DIV/0!"}},null,null,null,"Preis je kWh brutto"]
[null,null,null,null,null,null,null,null,null,"Verbrauch Elektrizität",null,null,{"$f":"IF(N367>=M367,N367-M367,\"Fehler\")","v":0}]
[null,null,null,"Energiegehalt Pellets (Hi: unterer Heizwert im Anlieferungszustand)",null,null,null,5]
[null,null,null,"Anteil des erfassten Wärmeverbrauchs am Energiegehalt des Brennstoffs16",null,null,null,{"$f":"IF(ISERROR((J551+K708)/$G$366),\"\",IF(J708<>0,(J551+J708)/$G$366,IF(K708<>0,(J551+K708)/$G$366,\"\")))","v":""},null,"Summe Kosten Elektrizität",null,null,{"$f":"M369*M368","v":0},"brutto"]
[]
[]
[null,null,null,"allg. verbrauchsunabhängige Nebenkosten (brutto)",null,null,null,"Zusammenfassung"]
[null,null,null,"Kostenart",null,null,"Betrag brutto"]
[null,null,null,"Betreuung",null,null,null,"Gesamte Nutz- bzw. Wohnfläche",null,null,null,{"$f":"N322","v":0}]
[null,null,null,"Wartung",null,null,null,"Gesamtenergieverbrauch Raumwärme",null,null,null,{"$f":"G366-L378","v":0}]
[null,null,null,"Schornsteinfeger",null,null,null,"Gesamtenergieverbrauch Warmwasserversorgung",null,null,null,{"$f":"IF(ISERROR(J708+K708),\"\",J708+K708)","v":0}]
[null,null,null,"Abrechnung, Verbrauchserfassung",null,null,null,"Gesamtenergieverbrauch Raumwärme- und Warmwasserversorgung",null,null,null,{"$f":"IF(ISERROR(L378+L377),\"\",L378+L377)","v":0}]
[null,null,null,"Gaskosten",null,null,null,"Eingesetzte Menge Pellets",null,null,null,{"$f":"F366","v":0}]
[null,null,null,"Summe",null,null,{"$f":"SUM(G376:G380)","v":0},"Kosten Pellets",null,null,null,{"$f":"ROUND(H366,2)","v":0}]
[null,null,null,null,null,null,null,"Kosten Elektrizität für die Wärmeversogung",null,null,null,{"$f":"M371","v":0}]
[null,null,null,"spez. Nebenkosten für Raumwärme-Bereitstellung17",null,null,null,"Kosten Betreuung",null,null,null,{"$f":"G376","v":0}]
[null,null,null,null,null,null,null,"Kosten Wartung",null,null,null,{"$f":"G377","v":0}]
[null,null,null,null,null,null,null,"Kosten Schornsteinfeger",null,null,null,{"$f":"G378","v":0}]
[null,null,null,"Summe",null,null,{"$f":"SUM(G384:G385)","v":0},"Kosten Abrechnung, Verbrauchserfassung",null,null,null,{"$f":"G379","v":0}]
[null,null,null,null,null,null,null,{"$f":"D380","v":"Gaskosten"},null,null,null,{"$f":"G380","v":0},"Verteilung nach"]
[null,null,null,"spez. Nebenkosten für Warmwasser-Bereitstellung17",null,null,null,"spez. Nebenkosten für Raumwärme- und Warmwasser-Bereitstellung",null,null,null,{"$f":"G386+G391","v":0},"Verbrauch","Nutz- bzw. Wohnfläche"]
[null,null,null,null,null,null,null,"Gesamtkosten ",null,null,null,{"$f":"SUM(L381:L387)+G386+G391","v":0}]
[null,null,null,null,null,null,null,"Gesamtkosten für Raumwärme",null,null,null,{"$f":"IFERROR(ROUND(IF(ISERROR(L389*L377/L379),\"\",(L389-G386-G391)*L377/L379+G386),2),\"\")","v":""},{"$f":"TEXT(IF(ISERROR(L390*K399/100),\"\",L390*K399/100),\"#.##0,00\")&\" €; (\"&K399&\" %)\"","v":" €; (70 %)"},{"$f":"TEXT(IF(ISERROR(L390*L399/100),\"\",L390*L399/100),\"#.##0,00\")&\" €; (\"&L399&\" %)\"","v":" €; (30 %)"}]
[null,null,null,"Summe",null,null,{"$f":"SUM(G389:G390)","v":0},"Gesamtkosten für Warmwasser",null,null,null,{"$f":"IF(ISERROR(L389*L378/L379),\"\",ROUND((L389-G386-G391)*L378/L379+G391,2))","v":""},{"$f":"TEXT(IF(ISERROR(L391*L556/100),\"\",L391*L556/100),\"#.##0,00\")&\" €; (\"&L556&\" %)\"","v":" €; (70 %)"},{"$f":"TEXT(IF(ISERROR(L391*M556/100),\"\",L391*M556/100),\"#.##0,00\")&\" €; (\"&M556&\" %)\"","v":" €; (30 %)"}]
[]
[]
[]
[]
[]
[null,null,"Tabelle 3","Raumwärme",null,null,"nach Wohndauer",null,null,"Kostenaufteilung nach HeizkostenV"]
[]
[null,null,null,"Wohneinheit","Name",null,"Anteilige Wohndauer","Anteilig über Gradtagszahlen-methode","Anteil\nder anrechenbaren Fläche","Verbrauch Wärme",70,{"$f":"100-K399","v":30},"Gesamtbetrag"]
[null,null,null,null,null,null,null,null,null,null,"nach \nVerbrauch","nach Nutz- bzw. Wohnfläche"]
[null,null,null,{"$f":"D17","v":0},{"$f":"IF($E17=\"\",\"\",$E17)","v":""},null,{"$f":"IF(ISERROR(IF(M17<>\"\",M17,\"\")),\"\",IF(M17<>\"\",M17,\"\"))","v":""},{"$f":"IF(ISERROR(IF(N17<>\"\",N17,\"\")),\"\",IF(N17<>\"\",N17,\"\"))","v":0},{"$f":"IF(ISERROR((M17/100)*F17/$N$322),\"\",(M17/100)*F17/$N$322*100)","v":""},{"$f":"IF((H172-G172)<=0,\"\",H172-G172)","v":""},{"$f":"IF(ISERROR($J401/$L$377*$L$390*$K$399/100),\"\",($J401/$J$551)*$L$390*$K$399/100)","v":""},{"$f":"IF(J401=\"\",\"\",IF(ISERROR(IF($G$397=\"nach Wohndauer\",$G401/100*F17/$N$322*$L$390*$L$399/100,IF($G$397=\"nach Gradtagstabelle\",$H401*F17/$G$551*$L$390*$L$399/100,\"Fehler\"))),0,(IF($G$397=\"nach Wohndauer\",$G401/100*F17/$N$322*$L$390*$L$399/100,IF($G$397=\"nach Gradtagstabelle\",$H401*F17/$N$322*$L$390*$L$399/100,\"Fehler\")))))","v":""},{"$f":"IF(ISERROR(K401+L401),\"\",K401+L401)","v":""},{"$f":"IF(SUM(G401:G550)/100=SUM(H401:H550),\"\",\"Gradtagswerte können nicht für die Berechung der Kosten verwendet werden!\")","v":""}]
[null,null,null,{"$f":"D18","v":0},"",null,"",0,"","","",{"$f":"IF(J402=\"\",\"\",IF(ISERROR(IF($G$397=\"nach Wohndauer\",$G402,IF($G$397=\"nach Gradtagstabelle\",$H402*100,\"Fehler\"))/100*F18/$G$551*$L$390*$L$399/100),0,(IF($G$397=\"nach Wohndauer\",$G402,IF($G$397=\"nach Gradtagstabelle\",$H402*100,\"Fehler\")))/100*F18/$N$322*$L$390*$L$399/100))","v":""},""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,{"$f":"IF($E21=\"\",\"\",$E21)","v":""},null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",{"$f":"IF(ISERROR(K406+L406),\"\",K406+L406)","v":""}]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,{"$f":"IF($E25=\"\",\"\",$E25)","v":""},null,"",0,"","","","",""]
[null,null,null,0,{"$f":"IF($E26=\"\",\"\",$E26)","v":""},null,"",0,"","","","",{"$f":"IF(ISERROR(K410+L410),\"\",K410+L410)","v":""}]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,{"$f":"IF(ISERROR(IF(M49<>\"\",M49,\"\")),\"\",IF(M49<>\"\",M49,\"\"))","v":""},{"$f":"IF(ISERROR(IF(N49<>\"\",N49,\"\")),\"\",IF(N49<>\"\",N49,\"\"))","v":0},{"$f":"IF(ISERROR((M49/100)*F49/$N$322),\"\",(M49/100)*F49/$N$322*100)","v":""},{"$f":"IF((H204-G204)<=0,\"\",H204-G204)","v":""},{"$f":"IF(ISERROR($J433/$L$377*$L$390*$K$399/100),\"\",($J433/$J$551)*$L$390*$K$399/100)","v":""},"",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,{"$f":"IF(ISERROR(IF(M81<>\"\",M81,\"\")),\"\",IF(M81<>\"\",M81,\"\"))","v":""},{"$f":"IF(ISERROR(IF(N81<>\"\",N81,\"\")),\"\",IF(N81<>\"\",N81,\"\"))","v":0},{"$f":"IF(ISERROR((M81/100)*F81/$N$322),\"\",(M81/100)*F81/$N$322*100)","v":""},{"$f":"IF((H236-G236)<=0,\"\",H236-G236)","v":""},{"$f":"IF(ISERROR($J465/$L$377*$L$390*$K$399/100),\"\",($J465/$J$551)*$L$390*$K$399/100)","v":""},"",""]
[null,null,null,{"$f":"D82","v":0},"",null,"",0,"","","",{"$f":"IF(J466=\"\",\"\",IF(ISERROR(IF($G$397=\"nach Wohndauer\",$G466,IF($G$397=\"nach Gradtagstabelle\",$H466*100,\"Fehler\"))/100*F82/$G$551*$L$390*$L$399/100),0,(IF($G$397=\"nach Wohndauer\",$G466,IF($G$397=\"nach Gradtagstabelle\",$H466*100,\"Fehler\")))/100*F82/$N$322*$L$390*$L$399/100))","v":""},""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,{"$f":"IF($E90=\"\",\"\",$E90)","v":""},null,"",0,"","","","",{"$f":"IF(ISERROR(K474+L474),\"\",K474+L474)","v":""}]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,{"$f":"IF(ISERROR(IF(M113<>\"\",M113,\"\")),\"\",IF(M113<>\"\",M113,\"\"))","v":""},{"$f":"IF(ISERROR(IF(N113<>\"\",N113,\"\")),\"\",IF(N113<>\"\",N113,\"\"))","v":0},{"$f":"IF(ISERROR((M113/100)*F113/$N$322),\"\",(M113/100)*F113/$N$322*100)","v":""},{"$f":"IF((H268-G268)<=0,\"\",H268-G268)","v":""},{"$f":"IF(ISERROR($J497/$L$377*$L$390*$K$399/100),\"\",($J497/$J$551)*$L$390*$K$399/100)","v":""},"",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,{"$f":"IF(ISERROR(IF(M145<>\"\",M145,\"\")),\"\",IF(M145<>\"\",M145,\"\"))","v":""},{"$f":"IF(ISERROR(IF(N145<>\"\",N145,\"\")),\"\",IF(N145<>\"\",N145,\"\"))","v":0},{"$f":"IF(ISERROR((M145/100)*F145/$N$322),\"\",(M145/100)*F145/$N$322*100)","v":""},{"$f":"IF((H300-G300)<=0,\"\",H300-G300)","v":""},{"$f":"IF(ISERROR($J529/$L$377*$L$390*$K$399/100),\"\",($J529/$J$551)*$L$390*$K$399/100)","v":""},"",""]
[null,null,null,{"$f":"D146","v":0},"",null,"",0,"","","",{"$f":"IF(J530=\"\",\"\",IF(ISERROR(IF($G$397=\"nach Wohndauer\",$G530,IF($G$397=\"nach Gradtagstabelle\",$H530*100,\"Fehler\"))/100*F146/$G$551*$L$390*$L$399/100),0,(IF($G$397=\"nach Wohndauer\",$G530,IF($G$397=\"nach Gradtagstabelle\",$H530*100,\"Fehler\")))/100*F146/$N$322*$L$390*$L$399/100))","v":""},""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,{"$f":"IF($E154=\"\",\"\",$E154)","v":""},null,"",0,"","","","",{"$f":"IF(ISERROR(K538+L538),\"\",K538+L538)","v":""}]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,{"$f":"IF($E156=\"\",\"\",$E156)","v":""},null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",""]
[null,null,null,0,"",null,"",0,"","","","",{"$f":"IF(ISERROR(K550+L550),\"\",K550+L550)","v":""}]
[null,null,null,"Gesamt",null,null,{"$f":"M167","v":0},null,{"$f":"SUM(I401:I550)","v":0},{"$f":"SUM(J401:J550)","v":0},{"$f":"SUM(K401:K550)","v":0},{"$f":"SUM(L401:L550)","v":0},{"$f":"SUM(M401:M550)","v":0}]
[]
[]
[null,null,"Tabelle 4","Warmwasser",null,null,null,null,null,null,null,"Kostenaufteilung nach HeizkostenV"]
[]
[null,null,null,"Wohneinheit","Name",null,"Anteilige Wohndauer","Anteil\nder anrechenbaren Fläche","Verbrauch \nin m³","Energieeinsatz\nfür Warmwasser gerechnet mit WMZ","Energieeinsatz\nfür Warmwassera \nin m³",70,{"$f":"100-L556","v":30},"Gesamtbetrag"]
[null,null,null,null,null,null,null,null,null,null,null,"nach \nVerbrauch","nach Nutz- bzw. Wohnfläche"]
[null,null,null,{"$f":"D17","v":0},{"$f":"IF($E17=\"\",\"\",$E17)","v":""},null,{"$f":"IF(O172<>0,M17,\"\")","v":""},{"$f":"IF(O172<>0,O172/$O$322,IF(O172=0,\"\"))","v":""},{"$f":"IFERROR(IF(AND(AND($M$333<>0,$L$333<>0),M172<>0),(M172/$M$322)*$M$334,IF(AND(OR($M$334=0,$M$334=\"\"),L172<>0),L172-K172,IF(AND(OR(M172=0,M172=\"\"),AND($M$333<>0,$L$333<>0)),M17/100*$M$334*100/(SUM($M$17:$M$166)),IF(AND(OR($M$334=0,$M$334=\"\"),AND(OR(K172=0,K172=\"\"),OR(L172=0,L172=\"\"))),\"nicht bereitgestellt\")))),\"nicht bereitgestellt\")","v":"nicht bereitgestellt"},{"$f":"IFERROR(IF(ISERROR($H$333),\"\",IF(O172=0,0,IF(I558=\"nicht bereitgestellt\",M17/100*$H$333*100/(SUM($M$17:$M$166)),IF($H$333<>\"\",$H$333*(I558/$I$708),0)))),0)","v":0},{"$f":"IF(I558=\"nicht bereitgestellt\",0,IF(J558<>0,0,2.5*I558*($H$334-10)/1000))","v":0},{"$f":"IF(G558=\"\",0,IF(I558<>\"nicht bereitgestellt\",($L$391*$L$556/100*I558/$I$708),IF(I558=\"nicht bereitgestellt\",($L$391*$L$556/100*J558/$J$708))))","v":0},{"$f":"IF(ISERROR($L$391*$M$556/100*$G558/$O$322),0,IF(G558=\"\",0,($L$391*$M$556/100*($G558/100)*F17/$O$322)))","v":0},{"$f":"IF(ISERROR(L558+M558),\"\",L558+M558)","v":0}]
[null,null,null,{"$f":"D18","v":0},"",null,{"$f":"IF(O173<>0,M18,\"\")","v":""},{"$f":"IF(O173<>0,O173/$O$322,IF(O173=0,\"\"))","v":""},{"$f":"IFERROR(IF(AND(AND($M$333<>0,$L$333<>0),M173<>0),(M173/$M$322)*$M$334,IF(AND(OR($M$334=0,$M$334=\"\"),L173<>0),L173-K173,IF(AND(OR(M173=0,M173=\"\"),AND($M$333<>0,$L$333<>0)),M18/100*$M$334*100/(SUM($M$17:$M$166)),IF(AND(OR($M$334=0,$M$334=\"\"),AND(OR(K173=0,K173=\"\"),OR(L173=0,L173=\"\"))),\"nicht bereitgestellt\")))),\"nicht bereitgestellt\")","v":"nicht bereitgestellt"},0,{"$f":"IF(I559=\"nicht bereitgestellt\",0,IF(J559<>0,0,2.5*I559*($H$334-10)/1000))","v":0},{"$f":"IF(G559=\"\",0,IF(I559<>\"nicht bereitgestellt\",($L$391*$L$556/100*I559/$I$708),IF(I559=\"nicht bereitgestellt\",($L$391*$L$556/100*J559/$J$708))))","v":0},{"$f":"IF(ISERROR($L$391*$M$556/100*$G559/$O$322),0,IF(G559=\"\",0,($L$391*$M$556/100*($G559/100)*F18/$O$322)))","v":0},{"$f":"IF(ISERROR(L559+M559),\"\",L559+M559)","v":0}]
[null,null,null,{"$f":"D19","v":0},"",null,"","","nicht bereitgestellt",{"$f":"IFERROR(IF(ISERROR($H$333),\"\",IF(O174=0,0,IF(I560=\"nicht bereitgestellt\",M19/100*$H$333*100/(SUM($M$17:$M$166)),IF($H$333<>\"\",$H$333*(I560/$I$708),0)))),0)","v":0},{"$f":"IF(I560=\"nicht bereitgestellt\",0,IF(J560<>0,0,2.5*I560*($H$334-10)/1000))","v":0},0,0,{"$f":"IF(ISERROR(L560+M560),\"\",L560+M560)","v":0}]
[null,null,null,0,"",null,"","","nicht bereitgestellt",{"$f":"IFERROR(IF(ISERROR($H$333),\"\",IF(O175=0,0,IF(I561=\"nicht bereitgestellt\",M20/100*$H$333*100/(SUM($M$17:$M$166)),IF($H$333<>\"\",$H$333*(I561/$I$708),0)))),0)","v":0},0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,{"$f":"IF(ISERROR(L576+M576),\"\",L576+M576)","v":0}]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,{"$f":"IF($E81=\"\",\"\",$E81)","v":""},null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,{"$f":"IF(O237<>0,M82,\"\")","v":""},{"$f":"IF(O237<>0,O237/$O$322,IF(O237=0,\"\"))","v":""},{"$f":"IFERROR(IF(AND(AND($M$333<>0,$L$333<>0),M237<>0),(M237/$M$322)*$M$334,IF(AND(OR($M$334=0,$M$334=\"\"),L237<>0),L237-K237,IF(AND(OR(M237=0,M237=\"\"),AND($M$333<>0,$L$333<>0)),M82/100*$M$334*100/(SUM($M$17:$M$166)),IF(AND(OR($M$334=0,$M$334=\"\"),AND(OR(K237=0,K237=\"\"),OR(L237=0,L237=\"\"))),\"nicht bereitgestellt\")))),\"nicht bereitgestellt\")","v":"nicht bereitgestellt"},0,0,{"$f":"IF(G623=\"\",0,IF(I623<>\"nicht bereitgestellt\",($L$391*$L$556/100*I623/$I$708),IF(I623=\"nicht bereitgestellt\",($L$391*$L$556/100*J623/$J$708))))","v":0},{"$f":"IF(ISERROR($L$391*$M$556/100*$G623/$O$322),0,IF(G623=\"\",0,($L$391*$M$556/100*($G623/100)*F82/$O$322)))","v":0},0]
[null,null,null,{"$f":"D83","v":0},"",null,"","","nicht bereitgestellt",0,{"$f":"IF(I624=\"nicht bereitgestellt\",0,IF(J624<>0,0,2.5*I624*($H$334-10)/1000))","v":0},0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",{"$f":"IFERROR(IF(ISERROR($H$333),\"\",IF(O239=0,0,IF(I625=\"nicht bereitgestellt\",M84/100*$H$333*100/(SUM($M$17:$M$166)),IF($H$333<>\"\",$H$333*(I625/$I$708),0)))),0)","v":0},0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,{"$f":"IF(ISERROR(L640+M640),\"\",L640+M640)","v":0}]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,{"$f":"IF($E145=\"\",\"\",$E145)","v":""},null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,{"$f":"IF(O301<>0,M146,\"\")","v":""},{"$f":"IF(O301<>0,O301/$O$322,IF(O301=0,\"\"))","v":""},{"$f":"IFERROR(IF(AND(AND($M$333<>0,$L$333<>0),M301<>0),(M301/$M$322)*$M$334,IF(AND(OR($M$334=0,$M$334=\"\"),L301<>0),L301-K301,IF(AND(OR(M301=0,M301=\"\"),AND($M$333<>0,$L$333<>0)),M146/100*$M$334*100/(SUM($M$17:$M$166)),IF(AND(OR($M$334=0,$M$334=\"\"),AND(OR(K301=0,K301=\"\"),OR(L301=0,L301=\"\"))),\"nicht bereitgestellt\")))),\"nicht bereitgestellt\")","v":"nicht bereitgestellt"},0,0,{"$f":"IF(G687=\"\",0,IF(I687<>\"nicht bereitgestellt\",($L$391*$L$556/100*I687/$I$708),IF(I687=\"nicht bereitgestellt\",($L$391*$L$556/100*J687/$J$708))))","v":0},{"$f":"IF(ISERROR($L$391*$M$556/100*$G687/$O$322),0,IF(G687=\"\",0,($L$391*$M$556/100*($G687/100)*F146/$O$322)))","v":0},0]
[null,null,null,{"$f":"D147","v":0},"",null,"","","nicht bereitgestellt",0,{"$f":"IF(I688=\"nicht bereitgestellt\",0,IF(J688<>0,0,2.5*I688*($H$334-10)/1000))","v":0},0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",{"$f":"IFERROR(IF(ISERROR($H$333),\"\",IF(O303=0,0,IF(I689=\"nicht bereitgestellt\",M148/100*$H$333*100/(SUM($M$17:$M$166)),IF($H$333<>\"\",$H$333*(I689/$I$708),0)))),0)","v":0},0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,{"$f":"IF(ISERROR(L704+M704),\"\",L704+M704)","v":0}]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,0,0,0,0]
[null,null,null,0,"",null,"","","nicht bereitgestellt",0,{"$f":"IF(I707=\"nicht bereitgestellt\",0,IF(J707<>0,0,2.5*I707*($H$334-10)/1000))","v":0},0,0,0]
[null,null,null,"Gesamt",null,null,{"$f":"SUM(G558:G707)/100","v":0},{"$f":"SUM(H558:H707)","v":0},{"$f":"SUM(I558:I707)","v":0},{"$f":"SUM(J558:J707)","v":0},{"$f":"SUM(K558:K707)","v":0},{"$f":"IF(ISERROR($L$391*$L$556/100*$I708/$I$708),\"\",SUM(L558:L707))","v":""},{"$f":"IF(ISERROR($L$391*$M$556/100*$G708/$G$708),\"\",SUM(M558:M707))","v":""},{"$f":"SUM(N558:N707)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"aFormel: 2,5 ∙ Verbrauch ∙ (Temperatur − 10°)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($G$333=0,$G$333=\"\"),\"Achtung: Der Gesamtbetrag für die Warmwasserbereitung ist wegen fehlender Angabe der Wärmemenge \nnur ein pauschaler Wert! (siehe auch Zelle H333)\",\"\")","v":"Achtung: Der Gesamtbetrag für die Warmwasserbereitung ist wegen fehlender Angabe der Wärmemenge \nnur ein pauschaler Wert! (siehe auch Zelle H333)"}]
[]
[null,null,"Tabelle 5","Zu zahlender Betrag in €"]
[null,null,null,"Wohneinheit","Name",null,"Warmwasser","Raumwärme","Gesamt","Abschlagszahlung","Gutschrift (+) bzw. Nachzahlung (-)"]
[null,null,null,{"$f":"D17","v":0},{"$f":"IF($E17=\"\",\"\",$E17)","v":""},null,{"$f":"N558","v":0},{"$f":"M401","v":""},{"$f":"IF(H714=\"\",\"\",G714+H714)","v":""},{"$f":"L17","v":0},{"$f":"IF(I714<>\"\",J714-I714,\"\")","v":""}]
[null,null,null,{"$f":"D18","v":0},{"$f":"IF($E18=\"\",\"\",$E18)","v":""},null,{"$f":"N559","v":0},"","",0,""]
[null,null,null,{"$f":"D19","v":0},{"$f":"IF($E19=\"\",\"\",$E19)","v":""},null,{"$f":"N560","v":0},"",{"$f":"IF(H716=\"\",\"\",G716+H716)","v":""},0,{"$f":"IF(I716<>\"\",J716-I716,\"\")","v":""}]
[null,null,null,{"$f":"D20","v":0},"",null,0,"","",0,""]
[null,null,null,{"$f":"D21","v":0},"",null,0,"","",0,""]
[null,null,null,{"$f":"D22","v":0},"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,{"$f":"N578","v":0},"",{"$f":"IF(H734=\"\",\"\",G734+H734)","v":""},0,{"$f":"IF(I734<>\"\",J734-I734,\"\")","v":""}]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,{"$f":"M433","v":""},"",{"$f":"L49","v":0},""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,{"$f":"M465","v":""},"",{"$f":"L81","v":0},""]
[null,null,null,0,"",null,{"$f":"N623","v":0},"",{"$f":"IF(H779=\"\",\"\",G779+H779)","v":""},0,{"$f":"IF(I779<>\"\",J779-I779,\"\")","v":""}]
[null,null,null,0,{"$f":"IF($E83=\"\",\"\",$E83)","v":""},null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,{"$f":"D86","v":0},"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,{"$f":"M497","v":""},"",{"$f":"L113","v":0},""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,{"$f":"M529","v":""},"",{"$f":"L145","v":0},""]
[null,null,null,0,"",null,{"$f":"N687","v":0},"",{"$f":"IF(H843=\"\",\"\",G843+H843)","v":""},0,{"$f":"IF(I843<>\"\",J843-I843,\"\")","v":""}]
[null,null,null,0,{"$f":"IF($E147=\"\",\"\",$E147)","v":""},null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,{"$f":"D150","v":0},"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,0,"",null,0,"","",0,""]
[null,null,null,"Gesamt",null,null,{"$f":"SUM(G714:G863)","v":0},0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Deutsches Pelletinstitut GmbH (DEPI), 2024"]
[]
[]
[]
[]
[]
[null,null,"Erläuterung der Fußnoten:"]
[]
[null,null,"Fußnote","Erläuterung"]
[null,null,1,"Bezeichnung des Objekts, ggf. Anschrift"]
[null,null,2,"Angabe der Anzahl der Tabellenzeilen für Tabelle 1 und 2. In dieser Zelle (G8) wird die Summe der Anzahl der Wohneinheiten plus der Mieterwechsel im Abrechnungszeitraum angegeben. Sie erzeugt dann die benötigte Anzahl an Zeilen in Tabelle 1 und 2. Diese Tabellen sind auf eine maximale Anzahl von 150 Tabellenzeilen limitiert somit ist die maximal zulässige Zahl in Zelle (G8) 1 bis 150.\n(Muster-Bsp.: Das Objekt verfügt über vier Wohneinheiten und es gab im Abrechnungszeitraum einen Mieterwechsel, dann wird in Zelle (G8) \"5\" eingetragen.)"]
[null,null,3,"Zeitraum der Heizkostenabrechnung; dient der Dokumentation und wird für keine Berechnungen berücksichtigt; Format: JJJJ/JJJJ (Bsp.: 2022/2023)"]
[null,null,4,"Name des Erstellers der Heizkostenabrechnung; dient der Dokumentation"]
[null,null,5,"Datum der Erstellung der Heizkostenabrechnung; dient der Dokumentation; Format: TT.MM.JJJJ (Bsp: 30.03.2023)"]
[null,null,6,"Der Abrechnungszeitraum, also der Zeitraum, für den der Vermieter die Betriebskosten zusammenstellt und abrechnet, darf maximal ein Jahr lang sein (nach $ 556, Abs. 3, Satz 1, BGB; Ausnahmen vorbehalten).\nDabei muss der Abrechnungszeitraum nicht zwingend mit dem Kalenderjahr (01.01. - 31.12) übereinstimmen. Liegt beispielsweise ein Mieterwechsel vor, der am 1. Mai statt gefunden hat, kann der Zeitraum vom 01.05 bis zum 30.04 des Folgejahres gewählt werden. Davon zu unterscheiden ist der Nutzungszeitraum. Dies beschreibt den Zeitraum der Nutzung der Wohnung im Abrechnungszeitraum. Hat ein Mieterwechsel stattgefunden hat, ist dieser kürzer als der Abrechnungszeitraum. Dann sind die für die Wohneinheit entstandenen Kosten auf die Nutzer im gesamten Abrechnungszeitraum aufzuteilen. Format des Datums: TT.MM.JJJJ bis TT.MM.JJJJ; bspw.: 01.07.2015 bis 30.06.2016."]
[null,null,7,"Gleiches, wie unter Fußnote 6 beschrieben, gilt für den Abrechnungszeitraum nach Tagen. In der Zelle (L10) wird aus dem Abrechnungszeitraum - nach Datum - der Zellen (F10 und H10) der Abrechnungszeitraum nach Tagen berechnet. Der maximale Zeitraum pro Heizkostenabrechnung beträgt 365 Tage und im Schaltjahr 366 Tage."]
[null,null,8,"Wenn ein Mieterwechsel innerhalb einer Wohnung stattfand, muss für diese Wohnung, die gleiche Wohneinheit eingetragen werden (Alt- und Neumieter)."]
[null,null,9,"Ist die Tabelle 2 \"Warmwasser: Stand Warmwasserzähler in m³\" ausgefüllt, können die Zellen der Tabelle \"Warmwasser: Wärmemengenzähler in MWh\" leer bleiben. Die Wärmemenge sollte gemäß HeizkostenV durch einen Wärmemengenzähler WMZ gemessen werden, da Berechnung nach § 9 Abs. 2 HeizkostenKV nur dann zulässig ist, wenn die Messung der Wärmemenge unter unzumutbar hohem Aufwand erfolgen kann. "]
[null,null,10,"Ein zentraler Warmwasserzähler ist keine Pflicht. Ist dieser vorhanden, wird Verteilung der gemessenen oder berechneten Wärmemenge für die Warmwasserbereitung auf die einzelnen Wohnungsnutzer nach dem Anteil der für die Wohnungen erfassten Warmwassermengen aufgeteilt. Sind keine Warmwasserzähler in den Wohnungen (Einzelzähler) vorhanden, wird der Verbrauch über den Flächenanteil der Wohnungen verteilt. Ist kein zentraler Warmwasserzähler vorhanden, können die Zellen K333, L333 und M333 leer bleiben."]
[null,null,11,"Der Anfangsbestand an Holzpellets im Lager ist der Endbestand an Holzpellets im Lager vom Vorjahr (letzte Heizkostenabrechnung)."]
[null,null,12,"Der Endbestand an Holzpellets im Lager muss ermittelt werden und in Zelle (G338) eingetragen werden. \nAus dem Anfangsbestand, den Lieferungen und dem Endbestand wird in Zelle (H338) der Preis für den Bestand an Holzpellets berechnet."]
[null,null,13,"Wird das Lager gereinigt und ein Restbestand an Pellets entnommen, sollte dies in Tabelle A aufgelistet werden, um die für Heizzwecke verbrauchte Pelletmenge richtig ausweisen zu können. Dazu wird die bei der Lagerreinigung entnommene Menge (mit einem Minuszeichen) ohne Eingabe eines Preisen eingetragen. Eine Umbuchung der Kosten für diese Pellets zu den allg. verbrauchsunabhängigen Nebenkosten ist nicht erforderlich, da dies keine Auswirkung auf die Kostenverteilung hat. Die weiteren Kosten, die für die Lagerreinigung aufgekommen sind, werden dann unter den allg. verbrauchsunabhängigen Nebenkosten erfasst (bspw. in Zelle D380).\n"]
[null,null,14,"Die Tabelle A kann mit der Zelle (F343) erweitert oder reduziert werden. Hierbei wird die Anzahl der Lieferungen an Holzpellets über den Zeitraum der Heizkostenabrechnung in die Zelle (F343) eingetragen. \nEs ist möglich, bis zu 15 Lieferungen in Tabelle A einzutragen."]
[null,null,15,"Ist kein separater Strommengenzähler für die Heizung vorhanden, ist diese Strommenge zu schätzen. Hierzu können gemäß BGH-Urteil V ZR 166/15 vom 03.06.2016 (https://dejure.org/dienste/vernetzung/rechtsprechung?Gericht=BGH&Datum=03.06.2016&Aktenzeichen=V%20ZR%20166/15) je nach Alter der Heizungsanlage 3-10 % der Kosten des Brennstoffverbrauchs angesetzt werden. Im Streitfall muss der Vermieter aber erklären können, ob der angesetzte Prozentsatz zutreffend ist (Urt. v. 20.2.2008 – VIII ZR 27/07). Die geschätzten Stromkosten können im Berechnungstool eingegeben werden, indem diese durch den kWh-Preis für Strom geteilt werden und das Ergebnis als Zählerstand zum Ende des Abrechnungszeitraums eingegeben wird. Der Ersteller der Abrechnung muss dann zusätzlich sicherstellen, dass diese Strommenge dann bei der Nebenkostenabrechnung nicht noch einmal abgerechnet wird, sondern bei der Erstellung der Nebenkostenabrechnung von der erfassten Gesamtstrommenge abgezogen wird."]
[null,null,16,"Anteil des für die einzelnen Wohnungen erfassten Wärmeverbrauchs (Raumwärme und Warmwasser) am Energiegehalt des Brennstoffs (Erfassungsrate)"]
[null,null,17,"Zu spez. verbrauchsunabhängige Nebenkosten zählen u. a. Legionellenprüfung und Zähleraustausch. Spez. verbrauchsunabhängige Nebenkosten für die Raumwärme- und Warmwasserbereitstellung sind von den allg. verbrauchsunabhängigen Nebenkosten zu differenzieren, weil diese direkt den Raumwärme- und Warmwasserkosten zugeordnet werden, und nicht über den Anteil des Raumwärme- und Warmwasserverbrauchs am Gesamtverbrauch umgelegt werden."]
[null,null,18,"Im Falle eines Nutzerwechsels ist der flächenbezogene Anteil der Raumwärmekosten wahlweise mittels Gradtagszahlentabelle (s. rechts oben) oder Nutzungszeitraum (§ 9b, Abs. 2 der HeizkostenV) auf die beteiligten Wohnungsnutzer zu verteilen. Üblich ist die Verteilung über die Gradtagszahlen, die daher vorausgewählt ist. Der verbrauchsabhängige Anteil der Raumwärmekosten der Wohnung ist auf Grundlage einer Zwischenablesung auf die beteiligten Wohnungsnutzer zu verteilen."]
[null,null,"Tabelle 1 bis 2","Bearbeitungstabellen die über Zelle (G8) erweitert oder reduziert werden kann."]
[null,null,"Tabelle 3 bis 5","Auswertungstabellen, die Ergebnisse der Berechnungen nach Wohneinheit und Nutzer auflisten."]
[null,null,"a","Formel gemäß § 9, Abs. 2, Satz 2 der HeizkostenV (Schätzwert)"]
[null,null,"*","Wenn das Warmwasser dezentral bereitgestellt wird (z.B. mit Boiler oder Durchlauferhitzer), müssen sämtliche Eingabefelder, die für die Warmwasserbereitung vorgesehen sind, leer bleiben oder \"Null\" eingetragen werden."]
[null,null,"Allg. Hinweis: ","Wenn keine Anfangs- und Endstände von Zählern vorliegen, sondern Verbrauchswerte, kann der Anfangszählerstand auf null gesetzt und der Verbrauchswert als Endstand des Zählers eingefügt werden."]

{"sheet":"Abrechnung für Wohnungsnutzer","index":1,"n_rows":72,"n_cols":82,"rows_kept":72,"cut":false,"hidden":false,"merged":[[43,10,44,11],[41,18,42,19],[46,10,46,11],[42,10,42,11],[51,10,51,11],[50,10,50,11],[49,10,49,11],[47,10,48,11],[51,8,51,9],[3,13,5,20],[3,1,5,11],[6,13,6,20],[18,17,18,20],[10,10,10,11],[12,18,12,20],[16,13,16,16],[37,13,37,16],[13,13,14,20],[15,18,15,20],[29,17,29,20],[25,17,25,20],[16,17,16,20],[14,3,14,5],[31,3,31,5],[6,1,6,11],[7,1,8,11],[16,1,18,6],[32,8,32,9],[12,8,12,11],[13,8,13,11],[14,8,14,11],[15,8,15,11],[34,1,34,11],[15,3,15,5],[47,8,48,8],[39,9,40,9],[39,8,40,8],[39,5,40,5],[39,6,40,7],[24,1,26,11],[43,4,44,5],[22,1,23,11],[30,1,30,11],[32,10,32,11],[32,1,32,2],[36,1,36,2],[35,1,35,2],[35,3,35,5],[35,6,35,7],[43,6,44,6],[43,7,44,8],[32,6,32,7],[36,6,36,7],[39,1,40,3],[38,9,38,10],[38,1,38,8],[42,1,42,3],[39,13,40,20],[41,13,42,16],[41,17,42,17],[41,20,42,20],[61,10,61,11],[16,8,16,11],[31,8,31,9],[35,8,35,9],[36,10,36,11],[39,10,40,11],[35,10,35,11],[53,10,53,11],[19,1,21,11],[31,10,31,11],[58,13,59,20],[50,1,51,7],[52,8,52,9],[52,1,52,7],[52,10,52,11],[58,1,59,11],[42,4,42,5],[46,1,46,3],[46,4,46,5],[55,1,57,11],[31,1,31,2],[36,8,36,9],[47,1,48,3],[53,8,53,9],[47,6,48,7],[47,9,48,9],[49,8,49,9],[50,8,50,9],[47,4,48,5],[43,1,44,3],[49,1,49,7],[31,6,31,7],[43,9,44,9],[17,17,17,19],[19,17,19,19],[20,17,20,19],[22,17,22,19],[23,17,23,19],[26,17,26,19],[21,17,21,19],[36,13,36,16],[34,17,34,20]]}
[]
[null,"Erst nach vollständiger Auswahl der Wohneinheit und des Wohnungsnutzers (Name) aktualisiert sich das nachfolgende Blatt!"]
[]
[null,{"$f":"\"Heizkostenabrechnung \"&Dateneingabe!I7","v":"Heizkostenabrechnung "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Heizkostenabrechnung \"&Dateneingabe!I7","v":"Heizkostenabrechnung "},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,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D17))),\"\")","v":""}]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D18))),\"\")","v":""}]
[null,{"$f":"\"Abrechnungszeitraum \"&TEXT(Dateneingabe!F10,\"TT.MM.JJJJ\")&\" - \"&TEXT(Dateneingabe!H10,\"TT.MM.JJJJ\")","v":"Abrechnungszeitraum 00.01.1900 - 00.01.1900"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Abrechnungszeitraum \"&TEXT(Dateneingabe!F10,\"TT.MM.JJJJ\")&\" - \"&TEXT(Dateneingabe!H10,\"TT.MM.JJJJ\")","v":"Abrechnungszeitraum 00.01.1900 - 00.01.1900"},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,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D19))),\"\")","v":""}]
[null,"Kosten Ihrer Wohneinheit",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D20))),\"\")","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D21))),\"\")","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D22))),\"\")","v":""}]
[null,"Objekt:",null,{"$f":"IF(Dateneingabe!D7=\"\",\"\",Dateneingabe!D7)","v":""},null,null,null,null,null,null,{"$f":"IF(OR(Dateneingabe!L8<>0,Dateneingabe!L8<>\"\"),TEXT(Dateneingabe!L8,\"TT. MMM. JJJJ\"),\"\")","v":""},null,null,{"$f":"B11","v":"Objekt:"},{"$f":"D11","v":""},null,null,null,null,null,{"$f":"IF(OR(Dateneingabe!L8<>0,Dateneingabe!L8<>\"\"),TEXT(K11,\"TT. MMM. JJJJ\"),\"\")","v":""},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,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D23))),\"\")","v":""}]
[null,"Wohneinheit:",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D24))),\"\")","v":""}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D25))),\"\")","v":""}]
[null,"Name:",null,"",null,null,null,"Kontakt:",null,null,null,null,null,"Gesamtkosten der Wärmeversorgung",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,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D26))),\"\")","v":""}]
[null,"Straße:",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D27))),\"\")","v":""}]
[null,"Ort:",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D28))),\"\")","v":""}]
[null,{"$f":"IF(OR(CD4=$D$14,CD5=$D$14,CD6=$D$14,CD7=$D$14,CD8=$D$14,CD9=$D$14,CD10=$D$14,CD11=$D$14,CD12=$D$14,CD13=$D$14,CD14=$D$14),\"\",\"Der Wohnungsnutzer passt nicht zur Wohneinheit. \nBitte kontrollieren Sie Ihre Eingabe!\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Brennstoffkosten Heizung",null,null,null,"Nebenkosten 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,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D30))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pelletlieferung","Datum","Menge","Kosten","Kostenart",null,null,"Kosten",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,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D31))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Anfangsbestand",{"$f":"Dateneingabe!F10","v":"00:00:00"},{"$f":"Dateneingabe!G337","v":0},{"$f":"ROUND(Dateneingabe!G337*(Dateneingabe!H337*(Dateneingabe!G359/100+1)),2)","v":0},"allg. verbrauchsunabhängige Nebenkosten",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,null,null,null,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D32))),\"\")","v":""}]
[null,{"$f":"\"In der Heizsaison \"&Dateneingabe!I7&\" wohnten Sie an \"&IFERROR(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$K$172:$K$321,Dateneingabe!$I$17:$I$166),3,FALSE),\"\")&\" von \"&Dateneingabe!L10&\" Tagen in der Wohnung des Objekts \"&Dateneingabe!D7&\". Für das Objekt wurde eine Wärmemenge von \"&TEXT(Dateneingabe!L379,\"#.##0,000\")&\" MWh bereitgestellt, darin enthalten wurde für die Erwärmung des Warmwassers eine Wärmemenge von \"&TEXT(Dateneingabe!L378,\"#.##0,000\")&\" MWh verbraucht.\"","v":"In der Heizsaison  wohnten Sie an  von  Tagen in der Wohnung des Objekts . Für das Objekt wurde eine Wärmemenge von 0,000 MWh bereitgestellt, darin enthalten wurde für die Erwärmung des Warmwassers eine Wärmemenge von 0,000 MWh verbraucht."},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E344=0,\"\",Dateneingabe!E344)","v":""},{"$f":"IF(Dateneingabe!F344=0,\"\",Dateneingabe!F344)","v":""},{"$f":"IF(Dateneingabe!G344=0,\"\",Dateneingabe!G344)","v":""},{"$f":"IF(OR(Dateneingabe!J344=\"\",Dateneingabe!J344=0),\"\",ROUND(Dateneingabe!J344,2))","v":""},{"$f":"IF(Dateneingabe!D376=0,\"\",Dateneingabe!D376)","v":"Betreuung"},null,null,{"$f":"IF(Dateneingabe!G376=0,\"\",Dateneingabe!G376)","v":""},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,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D33))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E345=0,\"\",Dateneingabe!E345)","v":""},{"$f":"IF(Dateneingabe!F345=0,\"\",Dateneingabe!F345)","v":""},{"$f":"IF(Dateneingabe!G345=0,\"\",Dateneingabe!G345)","v":""},{"$f":"IF(OR(Dateneingabe!J345=\"\",Dateneingabe!J345=0),\"\",ROUND(Dateneingabe!J345,2))","v":""},{"$f":"IF(Dateneingabe!D377=0,\"\",Dateneingabe!D377)","v":"Wartung"},null,null,{"$f":"IF(Dateneingabe!G377=0,\"\",Dateneingabe!G377)","v":""},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,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D34))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E346=0,\"\",Dateneingabe!E346)","v":""},{"$f":"IF(Dateneingabe!F346=0,\"\",Dateneingabe!F346)","v":""},{"$f":"IF(Dateneingabe!G346=0,\"\",Dateneingabe!G346)","v":""},{"$f":"IF(OR(Dateneingabe!J346=\"\",Dateneingabe!J346=0),\"\",ROUND(Dateneingabe!J346,2))","v":""},{"$f":"IF(Dateneingabe!D378=0,\"\",Dateneingabe!D378)","v":"Schornsteinfeger"},null,null,{"$f":"IF(Dateneingabe!G378=0,\"\",Dateneingabe!G378)","v":""},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,null,null,{"$f":"IFERROR(INDEX(Dateneingabe!$E$17:$E$166,LARGE((Dateneingabe!$D$17:$D$166=$D$12)*(ROW(Dateneingabe!$D$17:$D$166)-16),COUNTIF(Dateneingabe!$D$17:$D$166,$D$12)+17-ROW(Dateneingabe!D35))),\"\")","v":""}]
[null,{"$f":"IF(OR(Dateneingabe!H333=0,Dateneingabe!H333=\"\"),\"Es werden \"&TEXT(Dateneingabe!K399,\"#0\")&\" %\"&\" der Kosten nach Verbrauch und \"&TEXT(Dateneingabe!L399,\"#0\")&\" %\"&\" nach der Nutz- bzw. Wohnfläche aufgeteilt.\",\"Es werden \"&TEXT(Dateneingabe!K399,\"#0\")&\" %\"&\" der Kosten nach Verbrauch und \"&TEXT(Dateneingabe!L399,\"#0\")&\" %\"&\" nach der Nutz- bzw. Wohnfläche aufgeteilt.\")","v":"Es werden 70 % der Kosten nach Verbrauch und 30 % nach der Nutz- bzw. Wohnfläche aufgeteilt."},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E347=0,\"\",Dateneingabe!E347)","v":""},{"$f":"IF(Dateneingabe!F347=0,\"\",Dateneingabe!F347)","v":""},{"$f":"IF(Dateneingabe!G347=0,\"\",Dateneingabe!G347)","v":""},{"$f":"IF(OR(Dateneingabe!J347=\"\",Dateneingabe!J347=0),\"\",ROUND(Dateneingabe!J347,2))","v":""},{"$f":"IF(Dateneingabe!D379=0,\"\",Dateneingabe!D379)","v":"Abrechnung, Verbrauchserfassung"},null,null,{"$f":"IF(Dateneingabe!G379=0,\"\",Dateneingabe!G379)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E348=0,\"\",Dateneingabe!E348)","v":""},{"$f":"IF(Dateneingabe!F348=0,\"\",Dateneingabe!F348)","v":""},{"$f":"IF(Dateneingabe!G348=0,\"\",Dateneingabe!G348)","v":""},{"$f":"IF(OR(Dateneingabe!J348=\"\",Dateneingabe!J348=0),\"\",ROUND(Dateneingabe!J348,2))","v":""},{"$f":"IF(Dateneingabe!D380=0,\"\",Dateneingabe!D380)","v":"Gaskosten"},null,null,{"$f":"IF(Dateneingabe!G380=0,\"\",Dateneingabe!G380)","v":""}]
[null,{"$f":"IF(Dateneingabe!G397=\"nach Wohndauer\",\"Bei einem Nutzerwechsel werden der verbrauchsabhängige Anteil der Kosten auf Grundlage einer Zwischenablesung und der flächenbezogene Anteil mittels Nutzungszeitraum berechnet (§ 9b, Abs. 2 der HeizkostenV).\",IF(Dateneingabe!G397=\"nach Gradtagstabelle\",\"Bei einem Nutzerwechsel werden der verbrauchsabhängige Anteil der Kosten auf Grundlage einer Zwischenablesung und der flächenbezogene Anteil mittels Gradtagszahlentabelle* berechnet \n(§ 9b, Abs. 2 der HeizkostenV).\",IF(Dateneingabe!G397=\"\",\"\",\"\"\"Fehler\")))","v":"Bei einem Nutzerwechsel werden der verbrauchsabhängige Anteil der Kosten auf Grundlage einer Zwischenablesung und der flächenbezogene Anteil mittels Nutzungszeitraum berechnet (§ 9b, Abs. 2 der HeizkostenV)."},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E349=0,\"\",Dateneingabe!E349)","v":""},{"$f":"IF(Dateneingabe!F349=0,\"\",Dateneingabe!F349)","v":""},{"$f":"IF(Dateneingabe!G349=0,\"\",Dateneingabe!G349)","v":""},{"$f":"IF(OR(Dateneingabe!J349=\"\",Dateneingabe!J349=0),\"\",ROUND(Dateneingabe!J349,2))","v":""},{"$f":"Dateneingabe!D381","v":"Summe"},null,null,{"$f":"IF(Dateneingabe!G381=0,\"\",Dateneingabe!G381)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D$12&$D$14,CHOOSE({1,2},Dateneingabe!$D$17:$D$166&Dateneingabe!$E$17:$E$166,Dateneingabe!$F$17:$F$166),2,FALSE),\"\")","v":0},{"$f":"IF(Dateneingabe!E350=0,\"\",Dateneingabe!E350)","v":""},{"$f":"IF(Dateneingabe!F350=0,\"\",Dateneingabe!F350)","v":""},{"$f":"IF(Dateneingabe!G350=0,\"\",Dateneingabe!G350)","v":""},{"$f":"IF(OR(Dateneingabe!J350=\"\",Dateneingabe!J350=0),\"\",ROUND(Dateneingabe!J350,2))","v":""},"allg. verbrauchsabhängige Nebenkosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E351=0,\"\",Dateneingabe!E351)","v":""},{"$f":"IF(Dateneingabe!F351=0,\"\",Dateneingabe!F351)","v":""},{"$f":"IF(Dateneingabe!G351=0,\"\",Dateneingabe!G351)","v":""},{"$f":"IF(OR(Dateneingabe!J351=\"\",Dateneingabe!J351=0),\"\",ROUND(Dateneingabe!J351,2))","v":""},"Elektrizität Wärmeversorgung",null,null,{"$f":"IF(Dateneingabe!M371=0,\"\",Dateneingabe!M371)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E352=0,\"\",Dateneingabe!E352)","v":""},{"$f":"IF(Dateneingabe!F352=0,\"\",Dateneingabe!F352)","v":""},{"$f":"IF(Dateneingabe!G352=0,\"\",Dateneingabe!G352)","v":""},{"$f":"IF(OR(Dateneingabe!J352=\"\",Dateneingabe!J352=0),\"\",ROUND(Dateneingabe!J352,2))","v":""},"Summe Nebenkosten",null,null,{"$f":"IFERROR(SUM(U27,U25),\"\")","v":0}]
[null,null,null,"Ihr Nutzungszeitraum:",null,null,{"$f":"IF(IFERROR(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$G$172:$G$321,Dateneingabe!$G$17:$G$166),3,FALSE),\"\")<Dateneingabe!F10,Dateneingabe!F10,IFERROR(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$G$172:$G$321,Dateneingabe!$G$17:$G$166),3,FALSE),\"\"))","v":""},"bis",{"$f":"IFERROR(IF(AND(MieterDatumAuszug>0,MieterDatumAuszug<Dateneingabe!H10),MieterDatumAuszug,IF(OR(MieterDatumAuszug=0,MieterDatumAuszug=\"\"),Dateneingabe!H10,Dateneingabe!H10)),\"\")","v":"00:00:00"},null,null,null,null,{"$f":"IF(Dateneingabe!E353=0,\"\",Dateneingabe!E353)","v":""},{"$f":"IF(Dateneingabe!F353=0,\"\",Dateneingabe!F353)","v":""},{"$f":"IF(Dateneingabe!G353=0,\"\",Dateneingabe!G353)","v":""},{"$f":"IF(OR(Dateneingabe!J353=\"\",Dateneingabe!J353=0),\"\",ROUND(Dateneingabe!J353,2))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E354=0,\"\",Dateneingabe!E354)","v":""},{"$f":"IF(Dateneingabe!F354=0,\"\",Dateneingabe!F354)","v":""},{"$f":"IF(Dateneingabe!G354=0,\"\",Dateneingabe!G354)","v":""},{"$f":"IF(OR(Dateneingabe!J354=\"\",Dateneingabe!J354=0),\"\",ROUND(Dateneingabe!J354,2))","v":""},"spez. Nebenkosten für Raumwärmebereitstellung"]
[null,"Raumwärme: Wärmemengenzähler",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E355=0,\"\",Dateneingabe!E355)","v":""},{"$f":"IF(Dateneingabe!F355=0,\"\",Dateneingabe!F355)","v":""},{"$f":"IF(Dateneingabe!G355=0,\"\",Dateneingabe!G355)","v":""},{"$f":"IF(OR(Dateneingabe!J355=\"\",Dateneingabe!J355=0),\"\",ROUND(Dateneingabe!J355,2))","v":""},{"$f":"IF(Dateneingabe!D384=0,\"\",Dateneingabe!D384)","v":""},null,null,{"$f":"IF(Dateneingabe!G384=0,\"\",Dateneingabe!G384)","v":""}]
[null,"Zählernummer",null,"Zeitraum",null,null,"Anfangsstand",null,"Endstand",null,"Verbrauch",null,null,{"$f":"IF(Dateneingabe!E356=0,\"\",Dateneingabe!E356)","v":""},{"$f":"IF(Dateneingabe!F356=0,\"\",Dateneingabe!F356)","v":""},{"$f":"IF(Dateneingabe!G356=0,\"\",Dateneingabe!G356)","v":""},{"$f":"IF(OR(Dateneingabe!J356=\"\",Dateneingabe!J356=0),\"\",ROUND(Dateneingabe!J356,2))","v":""},{"$f":"IF(Dateneingabe!D385=0,\"\",Dateneingabe!D385)","v":""},null,null,{"$f":"IF(Dateneingabe!G385=0,\"\",Dateneingabe!G385)","v":""}]
[null,{"$f":"IFERROR(IF(OR(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$F$172:$F$321,Dateneingabe!$N$172:$N$321),2,FALSE)=0,VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$F$172:$F$321,Dateneingabe!$N$172:$N$321),2,FALSE)=\"\"),\"\",VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$F$172:$F$321,Dateneingabe!$N$172:$N$321),2,FALSE)),\"\")","v":""},null,{"$f":"IF(OR(Dateneingabe!G322=0,Dateneingabe!G322=\"\"),Dateneingabe!F10,Dateneingabe!G322)","v":"00:00:00"},"-",{"$f":"IF(OR(Dateneingabe!H322=0,Dateneingabe!H322=\"\"),Dateneingabe!H10,Dateneingabe!H322)","v":"00:00:00"},{"$f":"IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$G$172:$G$321,Dateneingabe!$H$172:$H$321),2,FALSE),\"#.##0,000\")&\" MWh\",\"\")","v":""},null,{"$f":"(IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$G$172:$G$321,Dateneingabe!$H$172:$H$321),3,FALSE),\"#.##0,000\")&\" MWh\",\"\"))","v":""},null,{"$f":"(IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$G$172:$G$321,Dateneingabe!$I$172:$I$321),3,FALSE),\"#.##0,000\")&\" MWh\",\"\"))","v":""},null,null,{"$f":"IF(Dateneingabe!E357=0,\"\",Dateneingabe!E357)","v":""},{"$f":"IF(Dateneingabe!F357=0,\"\",Dateneingabe!F357)","v":""},{"$f":"IF(Dateneingabe!G357=0,\"\",Dateneingabe!G357)","v":""},{"$f":"IF(OR(Dateneingabe!J357=\"\",Dateneingabe!J357=0),\"\",ROUND(Dateneingabe!J357,2))","v":""},{"$f":"Dateneingabe!D386","v":"Summe"},null,null,{"$f":"IF(Dateneingabe!G386=0,\"\",Dateneingabe!G386)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!E358=0,\"\",Dateneingabe!E358)","v":""},{"$f":"IF(Dateneingabe!F358=0,\"\",Dateneingabe!F358)","v":""},{"$f":"IF(Dateneingabe!G358=0,\"\",Dateneingabe!G358)","v":""},{"$f":"IF(OR(Dateneingabe!J358=\"\",Dateneingabe!J358=0),\"\",ROUND(Dateneingabe!J358,2))","v":""}]
[null,"Warmwasserbereitstellung: Warmwasserzähler (zu erwärmendes Kaltwasser wird in der Nebenkostenabrechnung berechnet)",null,null,null,null,null,null,null,null,null,null,null,"abz. Endbestand",{"$f":"Dateneingabe!H10","v":"00:00:00"},{"$f":"-Dateneingabe!G338","v":0},{"$f":"ROUND(-Dateneingabe!G338*(Dateneingabe!H338*(Dateneingabe!G359/100+1)),2)","v":0},"spez. Nebenkosten für Warmwasserbereitstellung"]
[null,"Zählernummer",null,"Zeitraum",null,null,"Anfangsstand",null,"Endstand",null,"Verbrauch",null,null,"Brennstoffkosten",null,{"$f":"SUM(P19:P35)","v":0},{"$f":"SUM(Q19:Q35)","v":0},{"$f":"IF(Dateneingabe!D389=0,\"\",Dateneingabe!D389)","v":""},null,null,{"$f":"IF(Dateneingabe!G389=0,\"\",Dateneingabe!G389)","v":""}]
[null,{"$f":"IFERROR(IF(OR(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$J$172:$J$321,Dateneingabe!$N$172:$N$321),2,FALSE)=0,VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$J$172:$J$321,Dateneingabe!$N$172:$N$321),2,FALSE)=\"\"),\"\",VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$J$172:$J$321,Dateneingabe!$N$172:$N$321),2,FALSE)),\"\")","v":""},null,{"$f":"IF(OR(Dateneingabe!K322=0,Dateneingabe!K322=\"\"),Dateneingabe!F10,Dateneingabe!K322)","v":"00:00:00"},"-",{"$f":"IF(OR(Dateneingabe!L322=0,Dateneingabe!L322=\"\"),Dateneingabe!H10,Dateneingabe!L322)","v":"00:00:00"},{"$f":"IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$K$172:$K$321,Dateneingabe!$L$172:$L$321),2,FALSE),\"#.##0,000\")&\" m³\",\"\")","v":""},null,{"$f":"IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$K$172:$K$321,Dateneingabe!$L$172:$L$321),3,FALSE),\"#.##0,000\")&\" m³\",\"\")","v":""},null,{"$f":"(IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$G$172:$G$321,Dateneingabe!$M$172:$M$321),3,FALSE),\"#.##0,000\")&\" m³\",\"\"))","v":""},null,null,{"$f":"\"Heizwert (Hi) = \"&TEXT(Dateneingabe!H370,\"0,0\")&\" MWh/t\"","v":"Heizwert (Hi) = 5,0 MWh/t"},null,null,null,{"$f":"IF(Dateneingabe!D390=0,\"\",Dateneingabe!D390)","v":""},null,null,{"$f":"IF(Dateneingabe!G390=0,\"\",Dateneingabe!G390)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Energieaufwand Q = Heizwert x Menge = \"&TEXT(P36*Dateneingabe!H370,\"#.##0,000\")&\" MWh\"","v":"Energieaufwand Q = Heizwert x Menge = 0,000 MWh"},null,null,null,{"$f":"Dateneingabe!D391","v":"Summe"},null,null,{"$f":"IF(Dateneingabe!G391=0,\"\",Dateneingabe!G391)","v":""}]
[null,"Übersicht für das Gesamtgebäude",null,null,null,null,null,null,null,"Ihre Wohneinheit"]
[null,"Anteil",null,null,null,"Kosten","Nutz- bzw. Wohnfläche\noder Verbrauchsmenge",null,"Kosten je Einheit1","Ihre Einheiten2","Ihre Kosten3",null,null,"Verteilung der Gesamtkosten"]
[]
[null,"Kosten Raumwärme",null,null,null,null,null,null,null,null,null,null,null,"Auflistung der Kosten",null,null,null,"Kosten","Nutz- bzw. Wohnfläche\noder Verbrauchsmenge",null,"Kosten \nje Einheit"]
[null,"nach Nutz- bzw. Wohnfläche",null,null,{"$f":"IFERROR(R51,\"\")","v":""},null,{"$f":"S51","v":"0,0 m² beheizte Fläche"},null,{"$f":"IFERROR(E43/Dateneingabe!N322,\"\")","v":""},{"$f":"IFERROR(IF(Dateneingabe!G397=\"nach Wohndauer\",TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$K$172:$K$321,Dateneingabe!$N$172:$N$321),3,FALSE),\"#.##0,000\"),IF(Dateneingabe!G397=\"nach Gradtagstabelle\",TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$17:$D$166&Dateneingabe!$E$17:$E$166,Dateneingabe!$K$17:$K$166,Dateneingabe!$F$17:$F$166),3,FALSE)*VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$17:$D$166&Dateneingabe!$E$17:$E$166,Dateneingabe!$K$17:$K$166,Dateneingabe!$N$17:$N$166),3,FALSE),\"#.##0,000\"),\"\")),\"\")","v":""},{"$f":"IFERROR(I43*J43,\"\")","v":""}]
[null,"nach Verbrauch",null,null,{"$f":"IFERROR(R52,\"\")","v":""},null,{"$f":"S52","v":"0,000 MWh"},{"$f":"IFERROR(E44/Dateneingabe!I322,\"\")","v":""},null,{"$f":"TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$G$172:$G$321,Dateneingabe!$I$172:$I$321),3,FALSE),\"#.##0,000\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(H44*J44,\"\")","v":""},null,null,"Brennstoffkosten",null,null,null,{"$f":"Q36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nebenkosten Heizung",null,null,null,{"$f":"U28","v":0}]
[null,"Kosten Warmwasserbereitstellung",null,null,null,null,null,null,null,null,null,null,null,"Gesamtkosten",null,null,null,{"$f":"SUM(R44:R45)","v":0}]
[null,"nach Nutz- bzw. Wohnfläche",null,null,{"$f":"R56","v":{"$error":"#DIV/0!"}},null,{"$f":"S56","v":"0,0 m² Fläche"},null,{"$f":"IFERROR(R56/Dateneingabe!O322,0)","v":0},{"$f":"IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$K$172:$K$321,Dateneingabe!$O$172:$O$321),3,FALSE),\"#.##0,000\"),\"\")","v":""},{"$f":"I47*J47","v":{"$error":"#VALUE!"}},null,null,{"$f":"\"davon \"&TEXT(Dateneingabe!L378/Dateneingabe!L379*100,\"0,0000\")&\" % für Warmwassererwärmung\"","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"-Dateneingabe!L378/Dateneingabe!L379*'Abrechnung für Wohnungsnutzer'!R46","v":{"$error":"#DIV/0!"}}]
[null,"nach Verbrauch",null,null,{"$f":"R57","v":{"$error":"#DIV/0!"}},null,{"$f":"S57","v":"0,000 m³"},null,{"$f":"IFERROR(E48/IF(OR(Dateneingabe!H333=\"\",Dateneingabe!H333=0),Dateneingabe!M322,Dateneingabe!H333),0)","v":0},{"$f":"IF(OR(Dateneingabe!H333=\"\",Dateneingabe!H333=0),IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$G$172:$G$321,Dateneingabe!$M$172:$M$321),3,FALSE),\"#.##0,000\"),\"\"),(IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$558:$D$707&Dateneingabe!$E$558:$E$707,Dateneingabe!$I$558:$I$707,Dateneingabe!$J$558:$J$707),3,FALSE),\"#.##0,000\"),\"\")))","v":""},{"$f":"IFERROR(I48*J48,\"\")","v":""},null,null,"Kosten Raumwärme",null,null,null,{"$f":"ROUND(R46+R47,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"spez. Nebenkosten Raumwärme",null,null,null,{"$f":"U33","v":""}]
[null,"1 Berechnung: Kosten / Nutz- bzw. Wohnfläche oder Verbrauchsmenge",null,null,null,null,null,null,"Ihre Gesamtkosten",null,{"$f":"SUM(K43:K48)","v":{"$error":"#VALUE!"}},null,null,"Gesamtkosten Raumwärme",null,null,null,{"$f":"SUM(R48:R49)","v":{"$error":"#DIV/0!"}}]
[null,"2 Ihre Wohn- bzw. Nutzfläche (ggf. geteilt durch Ihren Anteil am Abrechungszeitraum) oder Ihre Verbrauchsmenge",null,null,null,null,null,null,"Ihre geleistete Vorauszahlung",null,{"$f":"IFERROR(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$17:$D$166&Dateneingabe!$E$17:$E$166,Dateneingabe!$J$17:$J$166,Dateneingabe!$L$17:$L$166),3,FALSE),\"\")","v":0},null,null,{"$f":"\"davon \"&TEXT(Dateneingabe!L399,\"0,0\")&\" % nach Nutz- bzw. Wohnfläche\"","v":"davon 30,0 % nach Nutz- bzw. Wohnfläche"},null,null,null,{"$f":"Dateneingabe!L399/100*'Abrechnung für Wohnungsnutzer'!R50","v":{"$error":"#DIV/0!"}},{"$f":"TEXT(Dateneingabe!N322,\"#.##0,0\")&\" m² beheizte Fläche\"","v":"0,0 m² beheizte Fläche"},null,{"$f":"ROUND(R51/Dateneingabe!N322,6)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"IF(K50>K51,\"Ihre Nachzahlung\",IF(K50<K51,\"Ihr Guthaben\",\"Von Ihnen zu zahlen\"))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(K51>=K50,-(K50-K51),K50-K51)","v":{"$error":"#VALUE!"}},null,null,{"$f":"\"davon \"&TEXT(Dateneingabe!K399,\"0,0\")&\" % nach Verbrauch\"","v":"davon 70,0 % nach Verbrauch"},null,null,null,{"$f":"Dateneingabe!K399/100*'Abrechnung für Wohnungsnutzer'!R50","v":{"$error":"#DIV/0!"}},{"$f":"TEXT(Dateneingabe!I322,\"#.##0,000\")&\" MWh\"","v":"0,000 MWh"},null,{"$f":"ROUND(R52/Dateneingabe!I322,6)","v":{"$error":"#DIV/0!"}}]
[null,"3 Berechnung: Kosten je Einheit x Ihre Einheiten",null,null,null,null,null,null,"Bisherige monatl. Zahlung (Soll)",null,{"$f":"VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$17:$D$166&Dateneingabe!$E$17:$E$166,Dateneingabe!$K$17:$K$166,Dateneingabe!$K$17:$K$166),3,FALSE)","v":0},null,null,"Kosten für die Warmwasserbereitstellung",null,null,null,{"$f":"Dateneingabe!L378/Dateneingabe!L379*R46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"Zukünftiger monatl. Abschlag",null,{"$f":"IFERROR(ROUNDUP(((1000/G68)/12*K50)*2,-1)/2,\"\")","v":""},null,null,"spez. Nebenkosten Warmwasserbereitung",null,null,null,{"$f":"U38","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamtkosten Warmwasserbereitstellung",null,null,null,{"$f":"ROUND(SUM(R53:R54),2)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IFERROR(IF(K51<K50,\"Bei Ihnen ergibt sich eine Nachzahlung in Höhe von \"&TEXT(K52,\"#.##0,00\")&\" EUR. Bitte begleichen Sie diesen Betrag innerhalb eines Monats in einer separaten Zahlung.\",IF(K51>K50,\"Sie haben ein Guthaben von \"&TEXT(K52,\"#.##0,00\")&\" EUR. Bitte übermitteln Sie eine Kontoverbindung.\",\"\"))&IF(AND(K51<K50,K52>=60),\" Es ergibt sich ein zukünftiger monatlicher Abschlag in Höhe von \"&TEXT(K54,\"#.##0,00\")&\" EUR. Bitte passen Sie dahingehend Ihre nächste Zahlung an.\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"davon \"&TEXT(Dateneingabe!M556,\"0,0\")&\" % nach Nutz- bzw. Wohnfläche\"","v":"davon 30,0 % nach Nutz- bzw. Wohnfläche"},null,null,null,{"$f":"Dateneingabe!M556/100*'Abrechnung für Wohnungsnutzer'!R55","v":{"$error":"#DIV/0!"}},{"$f":"TEXT(Dateneingabe!O322,\"#.##0,0\")&\" m² Fläche\"","v":"0,0 m² Fläche"},null,{"$f":"ROUND(R56/Dateneingabe!N322,6)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"davon \"&TEXT(Dateneingabe!L556,\"0,0\")&\" % nach Verbrauch Warmwasserbereitstellung\"","v":"davon 70,0 % nach Verbrauch Warmwasserbereitstellung"},null,null,null,{"$f":"Dateneingabe!L556/100*'Abrechnung für Wohnungsnutzer'!R55","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(Dateneingabe!H333=\"\",Dateneingabe!H333=0),TEXT(Dateneingabe!M322,\"#.##0,000\")&\" m³\",TEXT(Dateneingabe!H333,\"#.##0,000\")&\" MWh\")","v":"0,000 m³"},null,{"$f":"IFERROR(ROUND(R57/IF(OR(Dateneingabe!H333=\"\",Dateneingabe!H333=0),Dateneingabe!M322,Dateneingabe!H333),6),0)","v":0}]
[]
[null,"Einwendungen gegen die Abrechnung können nur innerhalb eines Monats ab Zugang der Abrechnung und nur schriftlich geltend gemacht werden. Die Abrechnung gilt als genehmigt, wenn dies unterbleibt.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Dateneingabe!G397=\"nach Gradtagstabelle\",\"* Gradtagszahlen (Summe = 1000): Januar \"&Dateneingabe!T7&\", Februar \"&Dateneingabe!T8&\", März \"&Dateneingabe!T9&\", April \"&Dateneingabe!T10&\", Mai \"&Dateneingabe!T11&\", Juni bis August \"&Dateneingabe!T12+Dateneingabe!V7+Dateneingabe!V8&\", September \"&Dateneingabe!V9&\", \nOktober \"&Dateneingabe!V10&\", November \"&Dateneingabe!V11&\", Dezember \"&Dateneingabe!V12&\"\",\"\")","v":""}]
[]
[]
[null,"Heizkostenabrechnung für Pelletfeuerungen; Stand: Januar 2024",null,null,null,null,null,null,null,null,"Seite 1 von 2",null,null,"Heizkostenabrechnung für Pelletfeuerungen; Stand: Januar 2024",null,null,null,null,null,null,"Seite 2 von 2"]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(DAY(G29)=1,IF(MONTH(G29)=1,GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=2,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=3,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=4,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=5,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=6,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=7,(GTZJbA*2/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=8,(GTZJbA*1/3)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=9,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=10,GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=11,GTZNov+GTZDez,IF(MONTH(G29)=12,GTZDez)))))))))))),IF(AND(DAY(G29)>0,DAY(G29)<>1),IF(MONTH(G29)=1,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=2,((28-DAY(G29)+1)/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=3,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=4,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=5,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=6,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=7,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=8,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=9,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(G29)=10,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(G29)=11,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*GTZNov)+GTZDez,IF(MONTH(G29)=12,((DAY(DATE(YEAR(G29),MONTH(G29)+1,0))-DAY(G29)+1)/DAY(DATE(YEAR(G29),MONTH(G29)+1,0))*GTZDez)))))))))))))))","v":{"$error":"#VALUE!"}},{"$f":"IF(DAY(I29)=1,IF(MONTH(I29)=12,GTZDez+GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(I29)=11,GTZNov+GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(I29)=10,GTZOkt+GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(I29)=9,GTZSep+GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(I29)=8,GTZJbA+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(I29)=7,(GTZJbA*2/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(I29)=6,(GTZJbA*1/3)+GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(I29)=5,GTZMai+GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(I29)=4,GTZApr+GTZMar+GTZFeb+GTZJan,IF(MONTH(I29)=3,GTZMar+GTZFeb+GTZJan,IF(MONTH(I29)=2,GTZFeb+GTZJan,IF(MONTH(I29)=1,GTZJan)))))))))))),IF(AND(DAY(I29)>0,DAY(I29)<>1),IF(MONTH(I29)=1,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZJan),IF(MONTH(I29)=2,(DAY(I29)/28*GTZFeb)+GTZJan,IF(MONTH(I29)=3,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZMar)+GTZJan+GTZFeb,IF(MONTH(I29)=4,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZApr)+GTZJan+GTZFeb+GTZMar,IF(MONTH(I29)=5,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZMai)+GTZJan+GTZFeb+GTZMar+GTZApr,IF(MONTH(I29)=6,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai,IF(MONTH(I29)=7,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(1/3*GTZJbA),IF(MONTH(I29)=8,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*(1/3*GTZJbA))+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+(2/3*GTZJbA),IF(MONTH(I29)=9,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZSep)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA,IF(MONTH(I29)=10,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZOkt)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep,IF(MONTH(I29)=11,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZNov)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt,IF(MONTH(I29)=12,(DAY(I29)/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZDez)+GTZJan+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov))))))))))))))","v":false},null,{"$f":"IF(DAY(I29)=DAY(DATE(YEAR(I29),MONTH(I29)+1,0)),IF(MONTH(I29)=1,GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=2,GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=3,GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=4,GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=5,GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=6,(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=7,(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=8,GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=9,GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=10,GTZNov+GTZDez,IF(MONTH(I29)=11,GTZDez))))))))))),IF(AND(DAY(I29)<DAY(DATE(YEAR(I29),MONTH(I29)+1,0)),DAY(I29)<>DAY(DATE(YEAR(I29),MONTH(I29)+1,0))),IF(MONTH(I29)=1,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZJan)+GTZFeb+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=2,((28-DAY(I29))/28*GTZFeb)+GTZMar+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=3,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZMar)+GTZApr+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=4,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZApr)+GTZMai+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=5,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZMai)+GTZJbA+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=6,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*(1/3*GTZJbA))+(2/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=7,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*(1/3*GTZJbA))+(1/3*GTZJbA)+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=8,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*(GTZJbA*1/3))+GTZSep+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=9,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZSep)+GTZOkt+GTZNov+GTZDez,IF(MONTH(I29)=10,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZOkt)+GTZNov+GTZDez,IF(MONTH(I29)=11,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZNov)+GTZDez,IF(MONTH(I29)=12,((DAY(DATE(YEAR(I29),MONTH(I29)+1,0))-DAY(I29))/DAY(DATE(YEAR(I29),MONTH(I29)+1,0))*GTZDez)))))))))))))))","v":1000},{"$f":"IF(IF(YEAR(I29)>YEAR(G29),C68+D68,IF(YEAR(I29)=YEAR(G29),C68-F68,C68))>1000,\"Fehler\",IF(YEAR(I29)>YEAR(G29),C68+D68,IF(YEAR(I29)=YEAR(G29),C68-F68,C68)))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND((K50-K51)>=60,(K54-K53>=5)),FALSE,TRUE)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(OR(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$G$172:$G$321,Dateneingabe!$H$172:$H$321),2,FALSE)=0),TRUE,FALSE)","v":{"$error":"#N/A"}}]
[null,null,"WW",{"$f":"((IF(OR(Dateneingabe!H333=\"\",Dateneingabe!H333=0),K37,IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$558:$D$707&Dateneingabe!$E$558:$E$707,Dateneingabe!$I$558:$I$707,Dateneingabe!$J$558:$J$707),3,FALSE),\"#.##0,000\"),\"\"))/IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$N$172:$N$321,Dateneingabe!$M$172:$M$321),2,FALSE),\"#.##0,000\"),\"\")/(IF(OR(Dateneingabe!H333=\"\",Dateneingabe!H333=0),Dateneingabe!M322,Dateneingabe!H333)/Dateneingabe!N322)-1)*100)","v":{"$error":"#VALUE!"}},null,"RW",{"$f":"((K33/IFERROR(TEXT(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$N$172:$N$321,Dateneingabe!$M$172:$M$321),2,FALSE),\"#.##0,000\"),\"\")/(Dateneingabe!I322/Dateneingabe!N322)-1)*100)","v":{"$error":"#VALUE!"}},{"$f":"IF(VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$K$172:$K$321,Dateneingabe!$L$172:$L$321),2,FALSE)=0,TRUE,FALSE)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$K$172:$K$321,Dateneingabe!$G$17:$G$166),2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"VLOOKUP($D$12&$D$14,CHOOSE({1,2,3},Dateneingabe!$D$172:$D$321&Dateneingabe!$E$172:$E$321,Dateneingabe!$M$172:$M$321,Dateneingabe!$G$17:$G$166),2,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Haftungsausschluss","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,12,8]]}
[]
[null,"Haftungsausschluss für das Berechnungsprogramm\n\nAlle Inhalte wurden von uns mit allergrößter Sorgfalt erstellt. Das DEPI-Berechnungstool zur Heizkostenabrechnung muss von den Nutzern auf ihren konkreten Einzelfall angepasst werden. Wir übernehmen ausdrücklich keine Gewähr für die Vollständigkeit, Richtigkeit und Aktualität des angebotenen Inhalts oder die Richtigkeit der Ergebnisse, die durch die Berechnung mit unserem Berechnungstool entstehen. Bitte prüfen Sie in Ihrem eigenen Interesse, ob die Berechnungen plausibel sind. Wir übernehmen keine Haftung für Schäden oder wirtschaftliche Nachteile jeglicher Art, die durch die Nutzung des Berechnungstool entstehen."]