{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Wohneinheiten","Gesamtübersicht","Einzelabrechnung","Adressdaten"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Wohneinheiten","index":0,"n_rows":57,"n_cols":79,"rows_kept":57,"cut":false,"hidden":false,"merged":[[6,1,6,3],[4,2,4,3],[50,1,52,1],[50,8,52,8],[38,1,40,1],[38,8,40,8],[41,1,43,1],[41,8,43,8],[32,1,34,1],[32,8,34,8],[35,1,37,1],[35,8,37,8],[4,7,4,10],[23,8,25,8],[8,8,10,8],[11,8,13,8],[53,1,55,1],[53,8,55,8],[44,1,46,1],[44,8,46,8],[47,1,49,1],[47,8,49,8],[3,52,5,52],[3,29,4,36],[3,45,5,45],[3,53,5,53],[3,54,4,57],[3,48,5,48],[3,49,5,49],[3,50,5,50],[3,51,5,51],[3,13,3,24],[20,8,22,8],[3,46,5,46],[3,47,5,47],[3,25,4,28],[56,1,56,2],[4,13,4,20],[6,13,6,20],[8,1,10,1],[11,1,13,1],[14,1,16,1],[17,1,19,1],[20,1,22,1],[23,1,25,1],[26,1,28,1],[29,1,31,1],[29,8,31,8],[14,8,16,8],[17,8,19,8],[26,8,28,8],[3,12,5,12],[1,1,1,10],[1,12,1,78],[6,54,6,57],[3,58,4,61],[6,58,6,61],[3,63,3,78],[4,63,4,78],[3,1,3,10],[6,25,6,28],[6,29,6,36],[6,64,6,78],[4,4,4,6],[3,37,4,44],[6,37,6,44],[6,21,6,24],[4,21,4,24]]}
[]
[null,{"$f":"\"Betriebskostenabrechnung \"& YEAR(E7)","v":"Betriebskostenabrechnung 2022"},null,null,null,null,null,null,null,null,null,null,"      ß ß ß ß"]
[]
[null,"Wohnungsdaten, Mieterdaten und Berechnungsfaktoren",null,null,null,null,null,null,null,null,null,null,"Grundsteuer","Wasserkosten",null,null,null,null,null,null,null,null,null,null,null,"Heizkosten",null,null,null,"Zentrale Wasserbereitung",null,null,null,null,null,null,null,"Verbundene Heizungs und Warmwasserversorgungsanlagen",null,null,null,null,null,null,null,"Fahrstuhl","Straßenreinigung Müllabfuhr","Hausreinigung Ungeziefer-bekämpfung","Gartenpflege","Beleuchtung","Schornstein-reinigung","Versicherungen","Hauswart","Gemeinschafts-antenne Breitbandkabel","Wascheinrichtungen",null,null,null,"Sonstige Kosten"]
[null,null,"Mieterdaten",null,"Abrechnungszeitraum",null,null,"Berechnungsfaktoren",null,null,null,null,null,"Wasser",null,null,null,null,null,null,null,"Entwässerung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Einzelabrechnungen und Vorauszahlungen (Zahlungseingänge)"]
[null,"Wohneinheit","Mieter","Bewohnerzahl","von","bis","Wohntage","Personen/Tage","m² Wohn-fläche","m² / Tage","Punktwert",null,null,"Zählerstand\nalt","Zählerstand neu","Differenz","Anteil nach Einheiten","Anteil nach Personen / Tage","Anteil nach\nm² / Tage","Schlüssel-Nr.","Relevanter Betrag","Anteil nach Einheiten","Anteil nach Personen / Tage","Anteil nach\nm² / Tage","Relevanter Betrag","Zählerstand\nalt","Zählerstand neu","Differenz","Anteil nach Einheiten","Zählerstand\nalt","Zählerstand neu","Differenz","Anteil nach Einheiten","Anteil nach Personen / Tage","Anteil nach\nm² / Tage","Schlüssel-Nr.","Relevanter Betrag","Zählerstand\nalt","Zählerstand neu","Differenz","Anteil nach Einheiten","Anteil nach Personen / Tage","Anteil nach\nm² / Tage","Schlüssel-Nr.","Relevanter Betrag",null,null,null,null,null,null,null,null,null,"Jede Wohnung 1 Anteil","Anteil nach Personen / Tage","Schlüssel-Nr.","Relevanter Betrag","Jede Wohnung 1 Anteil","Anteil nach Personen / Tage","Schlüssel-Nr.","Relevanter Betrag",null,"gesamte Nebenkosten Jahr","neue Abschlags-zahlung / Monat","Vorauszahlung Januar","Vorauszahlung Februar","Vorauszahlung März","Vorauszahlung April","Vorauszahlung Mai","Vorauszahlung Juni","Vorauszahlung Juli","Vorauszahlung August","Vorauszahlung September","Vorauszahlung Oktober","Vorauszahlung November","Vorauszahlung Dezemberr","Summe Abschlags-zahlung / Vorjahr","Guthaben / Nachzahlung / Vorjahr"]
[null,"Abrechnungszeitraum:",null,null,"2022-01-01","2022-12-31",null,null,null,null,null,null,{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G24","v":600},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G25","v":500},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G26","v":0},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G27","v":0},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G26","v":0},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G28","v":0},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G26","v":0},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G23","v":2564},{"$f":"Gesamtübersicht!$G29","v":1094},{"$f":"Gesamtübersicht!$G30","v":678},{"$f":"Gesamtübersicht!$G31","v":100},{"$f":"Gesamtübersicht!$G32","v":350},{"$f":"Gesamtübersicht!$G33","v":100},{"$f":"Gesamtübersicht!$G34","v":200},{"$f":"Gesamtübersicht!$G35","v":1000},{"$f":"Gesamtübersicht!$G36","v":300},{"$f":"Gesamtübersicht!$G37","v":400},{"$f":"Gesamtübersicht!$G38","v":100},{"$f":"Gesamtübersicht!$G30","v":678},{"$f":"Gesamtübersicht!$G30","v":678},{"$f":"Gesamtübersicht!$G30","v":678},{"$f":"Gesamtübersicht!$G39","v":200},{"$f":"Gesamtübersicht!$G30","v":678},{"$f":"Gesamtübersicht!$G30","v":678},{"$f":"Gesamtübersicht!$G30","v":678},null,{"$f":"Gesamtübersicht!$G40","v":8186}]
[]
[null,"WE 1","Hans Mustermann",1,"2022-01-01","2022-03-31",{"$f":"F9-E9+IF(C9>\"\",1,0)","v":90},{"$f":"D9*G9","v":90},{"$f":"Gesamtübersicht!C4","v":94.2},{"$f":"G9*I9","v":8478},{"$f":"(D9)*I9*G9","v":8478},null,{"$f":"($M$7/$J$57*J9)","v":151.03993551950919},3456,3996,{"$f":"O9-N9","v":540},{"$f":"IF($P$57<>0,$N$7/$P$57*P9,0)","v":96},{"$f":"$N$7/$H$57*H9","v":15.725101921956902},{"$f":"$N$7/$J$57*J9","v":35.344758701913221},1,{"$f":"IF(T9=1,Q9,IF(T9=2,R9,S9))","v":96},{"$f":"IF($P$57<>0,$V$7/$P$57*P9,0)","v":80},{"$f":"$V$7/$H$57*H9","v":13.10425160163075},{"$f":"$V$7/$J$57*J9","v":29.453965584927687},{"$f":"IF(T9=1,V9,IF(T9=2,W9,X9))","v":80},0,0,{"$f":"AA9-Z9","v":0},{"$f":"IF($AB$57<>0,$Z$7/$AB$57*AB9,0)","v":0},0,0,{"$f":"AE9-AD9","v":0},{"$f":"IF($AF$57<>0,$AD$7/$AF$57*AF9,0)","v":0},{"$f":"$AD$7/$H$57*H9","v":0},{"$f":"$AD$7/$J$57*J9","v":0},1,{"$f":"IF(AJ9=1,AG9,IF(AJ9=2,AH9,AI9))","v":0},0,0,{"$f":"AM9-AL9","v":0},{"$f":"IF($AN$57<>0,$AL$7/$AN$57*AN9,0)","v":0},{"$f":"$AL$7/$H$57*H9","v":0},{"$f":"$AL$7/$J$57*J9","v":0},1,{"$f":"IF(AR9=1,AO9,IF(AR9=2,AP9,AQ9))","v":0},{"$f":"$AT$7/$J$57*J9","v":64.445276699821775},{"$f":"$AU$7/$J$57*J9","v":39.939577333161942},{"$f":"$AV$7/$J$57*J9","v":5.8907931169855372},{"$f":"$AW$7/$J$57*J9","v":20.617775909449382},{"$f":"$AX$7/$J$57*J9","v":5.8907931169855372},{"$f":"$AY$7/$J$57*J9","v":11.781586233971074},{"$f":"$AZ$7/$J$57*J9","v":58.907931169855374},{"$f":"$BA$7/$J$57*J9","v":17.672379350956611},{"$f":"IF(C9>\"\",$BB$7/$G$57*G9,0)","v":24.657534246575342},{"$f":"IF(C9>\"\",$BC$7/$G$57*G9,0)","v":6.1643835616438354},{"$f":"$BC$7/$H$57*H9","v":2.6208503203261504},1,{"$f":"IF(BE9=1,BC9,BD9)","v":6.1643835616438354},{"$f":"IF(C9>\"\",$BG$7/$G$57*G9,0)","v":12.328767123287671},{"$f":"$BG$7/$H$57*H9","v":5.2417006406523008},2,{"$f":"IF(BI9=1,BG9,BH9)","v":5.2417006406523008},null,{"$f":"M9+U9+Y9+AC9+AK9+AS9+AT9+AU9+AV9+AW9+AX9+AY9+AZ9+BA9+BB9+BF9+BJ9","v":588.24966689956796},{"$f":"IF(BY9=0,0,IF(C9=\"\",0,BL9/G9*365)/12)","v":0},150,150,150,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BN9:BY9)","v":450},{"$f":"SUM(BL9-BZ9)*-1","v":-138.24966689956796}]
[null,null,"Nachmieter 1",2,"2022-04-01","2022-10-31",214,{"$f":"D10*G10","v":428},null,{"$f":"G10*I9","v":20158.8},{"$f":"(D10)*I9*G10","v":40317.599999999999},null,{"$f":"($M$7/$J$57*J10)","v":359.13940223527737},3600,3954,{"$f":"O10-N10","v":354},{"$f":"IF($P$57<>0,$N$7/$P$57*P10,0)","v":62.933333333333337},{"$f":"$N$7/$H$57*H10","v":74.781595806639487},{"$f":"$N$7/$J$57*J10","v":84.041981802326987},{"$f":"$T$9","v":1},{"$f":"IF(T10=1,Q10,IF(T10=2,R10,S10))","v":62.933333333333337},{"$f":"IF($P$57<>0,$V$7/$P$57*P10,0)","v":52.444444444444443},{"$f":"$V$7/$H$57*H10","v":62.317996505532903},{"$f":"$V$7/$J$57*J10","v":70.034984835272496},{"$f":"IF(T10=1,V10,IF(T10=2,W10,X10))","v":52.444444444444443},0,0,{"$f":"AA10-Z10","v":0},{"$f":"IF($AB$57<>0,$Z$7/$AB$57*AB10,0)","v":0},0,0,{"$f":"AE10-AD10","v":0},{"$f":"IF($AF$57<>0,$AD$7/$AF$57*AF10,0)","v":0},{"$f":"$AD$7/$H$57*H10","v":0},{"$f":"$AD$7/$J$57*J10","v":0},{"$f":"$AJ$9","v":1},{"$f":"IF(AJ10=1,AG10,IF(AJ10=2,AH10,AI10))","v":0},0,0,{"$f":"AM10-AL10","v":0},{"$f":"IF($AN$57<>0,$AL$7/$AN$57*AN10,0)","v":0},{"$f":"$AL$7/$H$57*H10","v":0},{"$f":"$AL$7/$J$57*J10","v":0},{"$f":"$AR$9","v":1},{"$f":"IF(AR10=1,AO10,IF(AR10=2,AP10,AQ10))","v":0},{"$f":"$AT$7/$J$57*J10","v":153.23654681957623},94.967439436629505,{"$f":"$AV$7/$J$57*J10","v":14.0069969670545},{"$f":"$AW$7/$J$57*J10","v":49.024489384690753},{"$f":"$AX$7/$J$57*J10","v":14.0069969670545},{"$f":"$AY$7/$J$57*J10","v":28.013993934108999},{"$f":"$AZ$7/$J$57*J10","v":140.06996967054499},{"$f":"$BA$7/$J$57*J10","v":42.020990901163493},{"$f":"IF(C10>\"\",$BB$7/$G$57*G10,0)","v":58.630136986301366},{"$f":"IF(C10>\"\",$BC$7/$G$57*G10,0)","v":14.657534246575342},{"$f":"$BC$7/$H$57*H10","v":12.463599301106582},{"$f":"$BE$9","v":1},{"$f":"IF(BE10=1,BC10,BD10)","v":14.657534246575342},{"$f":"IF(C10>\"\",$BG$7/$G$57*G10,0)","v":29.315068493150683},{"$f":"$BG$7/$H$57*H10","v":24.927198602213164},{"$f":"$BI$9","v":2},{"$f":"IF(BI10=1,BG10,BH10)","v":24.927198602213164},null,{"$f":"M10+U10+Y10+AC10+AK10+AS10+AT10+AU10+AV10+AW10+AX10+AY10+AZ10+BA10+BB10+BF10+BJ10","v":1108.0794739289681},{"$f":"IF(BY10=0,0,IF(C10=\"\",0,BL10/G10*365)/12)","v":0},0,0,0,150,150,150,150,150,150,150,0,0,{"$f":"SUM(BN10:BY10)","v":1050},{"$f":"SUM(BL10-BZ10)*-1","v":-58.079473928968127}]
[null,null,"Nachmieter 2",3,"2022-11-01","2022-12-31",61,183,null,{"$f":"G11*I9","v":5746.2},{"$f":"(D11)*I9*G11","v":17238.600000000002},null,102.37151185211177,3954,4100,146,25.955555555555556,{"$f":"$N$7/$H$57*H11","v":31.974373907979032},23.955892009074518,1,25.955555555555556,21.62962962962963,26.645311589982526,19.963243340895431,21.62962962962963,0,0,0,0,0,0,0,0,0,0,{"$f":"$AJ$9","v":1},0,0,0,0,0,0,0,{"$f":"$AR$9","v":1},0,43.679576429879205,27.070157970254204,3.9926486681790863,{"$f":"$AW$7/$J$57*J11","v":13.974270338626802},3.9926486681790863,7.9852973363581725,39.926486681790863,11.977946004537259,16.712328767123285,4.1780821917808213,5.329062317996506,{"$f":"$BE$9","v":1},4.1780821917808213,8.3561643835616426,10.658124635993012,{"$f":"$BI$9","v":2},10.658124635993012,null,334.10426472999876,166.59570577383818,0,0,0,0,0,0,0,0,0,0,150,150,300,-34.104264729998761]
[null,"WE 2","Renate Musterfrau",2,"2022-01-01","2022-12-31",365,730,{"$f":"Gesamtübersicht!C5","v":138},{"$f":"G12*I12","v":50370},{"$f":"(D12)*I12*G12","v":100740},null,897.36748668526502,4542,5000,458,81.422222222222231,127.54804892253931,209.99239158001521,1,81.422222222222231,67.851851851851848,106.29004076878276,174.99365965001269,67.851851851851848,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,382.88612731422779,237.29140248541719,34.998731930002535,122.49556175500889,34.998731930002535,69.99746386000507,349.98731930002538,104.9961957900076,100,25,21.258008153756553,1,25,50,42.516016307513105,2,42.516016307513105,null,2551.8091114315494,212.65075928596244,300,300,300,300,300,300,300,300,300,300,300,300,3600,1048.1908885684506]
[null,null,null,null,null,null,0,0,null,{"$f":"G13*I12","v":0},{"$f":"(D13)*I12*G13","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G14*I12","v":0},{"$f":"(D14)*I12*G14","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WE3","Hans Testperson",3,"2022-01-01","2022-12-31",365,1095,{"$f":"Gesamtübersicht!C6","v":66.599999999999994},{"$f":"G15*I15","v":24308.999999999996},{"$f":"(D15)*I15*G15","v":72927},null,433.07735226984528,1234,1456,222,39.466666666666669,{"$f":"$N$7/$H$57*H15","v":191.32207338380897},101.34415419731167,1,39.466666666666669,32.888888888888886,159.43506115317413,84.453461831093065,32.888888888888886,0,0,0,{"$f":"IF($AB$57<>0,$Z$7/$AB$57*AB15,0)","v":0},0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,184.78417448643162,114.51889424296219,16.890692366218612,59.117423281765149,16.890692366218612,33.781384732437225,168.90692366218613,50.672077098655834,100,25,31.887012230634827,1,25,50,63.774024461269654,2,63.774024461269654,null,1339.7691945235458,111.64743287696216,120,120,120,120,120,120,120,120,120,120,120,120,1440,100.23080547645418]
[null,null,null,null,null,null,0,0,null,{"$f":"G16*I15","v":0},{"$f":"(D16)*I15*G16","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G17*I15","v":0},{"$f":"(D17)*I15*G17","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WE4","Renate Testperson",4,"2022-01-01","2022-06-30",181,724,{"$f":"Gesamtübersicht!C7","v":95.5},{"$f":"G18*I18","v":17285.5},{"$f":"(D18)*I18*G18","v":69142},null,307.95008320623685,3456,4000,544,96.711111111111109,126.49970879440886,72.063201998339352,1,96.711111111111109,80.592592592592581,105.41642399534071,60.052668331949462,80.592592592592581,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,131.39523831030542,81.431418258123458,12.010533666389891,42.036867832364621,12.010533666389891,24.021067332779783,120.10533666389892,36.031600999169676,49.589041095890408,12.397260273972602,21.083284799068142,1,12.397260273972602,24.794520547945204,42.166569598136284,2,42.166569598136284,null,1048.4492546073614,0,170,170,170,170,170,170,0,0,0,0,0,0,1020,-28.449254607361354]
[null,null,"Nachmieter 3",1,"2022-07-01","2022-12-31",184,184,null,{"$f":"G19*I18","v":17572},{"$f":"(D19)*I18*G19","v":17572},null,313.05422823175456,1234,2345,1111,197.51111111111112,32.149097262667446,73.257619711019004,1,197.51111111111112,164.59259259259258,26.790914385556199,61.048016425849177,164.59259259259258,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,133.573059939758,82.781110273451475,12.209603285169834,42.733611498094426,12.209603285169834,24.419206570339668,122.09603285169835,36.628809855509502,50.410958904109584,12.602739726027396,5.3581828771112407,1,12.602739726027396,25.205479452054792,10.716365754222481,2,10.716365754222481,null,1215.5390338790087,200.93829137945568,0,0,0,0,0,0,170,170,170,170,170,170,1020,-195.53903387900868]
[null,null,null,null,null,null,0,0,null,{"$f":"G20*I18","v":0},{"$f":"(D20)*I18*G20","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WE 5",null,null,null,null,0,0,{"$f":"Gesamtübersicht!C8","v":0},{"$f":"G21*I21","v":0},{"$f":"(D21)*I21*G21","v":0},null,0,0,0,0,0,0,0,1,{"$f":"IF(T21=1,Q21,IF(T21=2,R21,S21))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G22*I21","v":0},{"$f":"(D22)*I21*G22","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,{"$f":"$AL$7/$J$57*J22","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"F23-E23+IF(C23>\"\",1,0)","v":0},0,null,{"$f":"G23*I21","v":0},{"$f":"(D23)*I21*G23","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WE 6",null,null,null,null,0,0,{"$f":"Gesamtübersicht!C9","v":0},{"$f":"G24*I24","v":0},{"$f":"(D24)*I24*G24","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,{"$f":"$AW$7/$J$57*J24","v":0},0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G25*I24","v":0},{"$f":"(D25)*I24*G25","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G26*I24","v":0},{"$f":"(D26)*I24*G26","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WE 7",null,null,null,null,0,0,{"$f":"Gesamtübersicht!C10","v":0},{"$f":"G27*I27","v":0},{"$f":"(D27)*I27*G27","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G28*I27","v":0},{"$f":"(D28)*I27*G28","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G29*I27","v":0},{"$f":"(D29)*I27*G29","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WE 8",null,null,null,null,0,0,{"$f":"Gesamtübersicht!C11","v":0},{"$f":"G30*I30","v":0},{"$f":"(D30)*I30*G30","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G31*I30","v":0},{"$f":"(D31)*I30*G31","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G32*I30","v":0},{"$f":"(D32)*I30*G32","v":0},null,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$AJ$9","v":1},0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"WE 9",null,null,null,null,0,{"$f":"D33*G33","v":0},{"$f":"Gesamtübersicht!C12","v":0},{"$f":"G33*I33","v":0},{"$f":"(D33)*I33*G33","v":0},null,{"$f":"($M$7/$J$57*J33)","v":0},null,null,{"$f":"O33-N33","v":0},0,{"$f":"$N$7/$H$57*H33","v":0},{"$f":"$N$7/$J$57*J33","v":0},1,{"$f":"IF(T33=1,Q33,IF(T33=2,R33,S33))","v":0},0,{"$f":"$V$7/$H$57*H33","v":0},{"$f":"$V$7/$J$57*J33","v":0},{"$f":"IF(T33=1,V33,IF(T33=2,W33,X33))","v":0},null,null,{"$f":"AA33-Z33","v":0},0,null,null,{"$f":"AE33-AD33","v":0},0,{"$f":"$AD$7/$H$57*H33","v":0},{"$f":"$AD$7/$J$57*J33","v":0},1,{"$f":"IF(AJ33=1,AG33,IF(AJ33=2,AH33,AI33))","v":0},null,null,{"$f":"AM33-AL33","v":0},0,{"$f":"$AL$7/$H$57*H33","v":0},{"$f":"$AL$7/$J$57*J33","v":0},1,{"$f":"IF(AR33=1,AO33,IF(AR33=2,AP33,AQ33))","v":0},{"$f":"$AT$7/$J$57*J33","v":0},{"$f":"$AU$7/$J$57*J33","v":0},{"$f":"$AV$7/$J$57*J33","v":0},{"$f":"$AW$7/$J$57*J33","v":0},{"$f":"$AX$7/$J$57*J33","v":0},{"$f":"$AY$7/$J$57*J33","v":0},{"$f":"$AZ$7/$J$57*J33","v":0},{"$f":"$BA$7/$J$57*J33","v":0},{"$f":"IF(C33>\"\",$BB$7/$G$57*G33,0)","v":0},{"$f":"IF(C33>\"\",$BC$7/$G$57*G33,0)","v":0},{"$f":"$BC$7/$H$57*H33","v":0},1,{"$f":"IF(BE33=1,BC33,BD33)","v":0},{"$f":"IF(C33>\"\",$BG$7/$G$57*G33,0)","v":0},{"$f":"$BG$7/$H$57*H33","v":0},2,{"$f":"IF(BI33=1,BG33,BH33)","v":0},null,{"$f":"M33+U33+Y33+AC33+AK33+AS33+AT33+AU33+AV33+AW33+AX33+AY33+AZ33+BA33+BB33+BF33+BJ33","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BN33:BY33)","v":0},{"$f":"SUM(BL33-BZ33)*-1","v":0}]
[null,null,null,null,null,null,{"$f":"F34-E34+IF(C34>\"\",1,0)","v":0},0,null,{"$f":"G34*I33","v":0},{"$f":"(D34)*I33*G34","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G35*I33","v":0},{"$f":"(D35)*I33*G35","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,{"$f":"$AJ$9","v":1},0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"WE 10",null,null,null,null,0,0,{"$f":"Gesamtübersicht!C13","v":0},{"$f":"G36*I36","v":0},{"$f":"(D36)*I36*G36","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G37*I36","v":0},{"$f":"(D37)*I36*G37","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G38*I36","v":0},{"$f":"(D38)*I36*G38","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,{"$f":"$AJ$9","v":1},0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"WE 11",null,null,null,null,0,0,{"$f":"Gesamtübersicht!C14","v":0},{"$f":"G39*I39","v":0},{"$f":"(D39)*I39*G39","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G40*I39","v":0},{"$f":"(D40)*I39*G40","v":0},null,0,null,null,0,0,0,{"$f":"$N$7/$J$57*J40","v":0},1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G41*I39","v":0},{"$f":"(D41)*I39*G41","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,{"$f":"$AJ$9","v":1},0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"WE 12",null,null,null,null,0,0,{"$f":"Gesamtübersicht!C15","v":0},{"$f":"G42*I42","v":0},{"$f":"(D42)*I42*G42","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G43*I42","v":0},{"$f":"(D43)*I42*G43","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G44*I42","v":0},{"$f":"(D44)*I42*G44","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,{"$f":"$AJ$9","v":1},0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"WE 13",null,null,null,null,0,{"$f":"D45*G45","v":0},{"$f":"Gesamtübersicht!C16","v":0},{"$f":"G45*I45","v":0},{"$f":"(D45)*I45*G45","v":0},null,{"$f":"($M$7/$J$57*J45)","v":0},null,null,{"$f":"O45-N45","v":0},0,{"$f":"$N$7/$H$57*H45","v":0},{"$f":"$N$7/$J$57*J45","v":0},1,{"$f":"IF(T45=1,Q45,IF(T45=2,R45,S45))","v":0},0,{"$f":"$V$7/$H$57*H45","v":0},{"$f":"$V$7/$J$57*J45","v":0},{"$f":"IF(T45=1,V45,IF(T45=2,W45,X45))","v":0},null,null,{"$f":"AA45-Z45","v":0},0,null,null,{"$f":"AE45-AD45","v":0},0,{"$f":"$AD$7/$H$57*H45","v":0},{"$f":"$AD$7/$J$57*J45","v":0},1,{"$f":"IF(AJ45=1,AG45,IF(AJ45=2,AH45,AI45))","v":0},null,null,{"$f":"AM45-AL45","v":0},0,{"$f":"$AL$7/$H$57*H45","v":0},{"$f":"$AL$7/$J$57*J45","v":0},1,{"$f":"IF(AR45=1,AO45,IF(AR45=2,AP45,AQ45))","v":0},{"$f":"$AT$7/$J$57*J45","v":0},{"$f":"$AU$7/$J$57*J45","v":0},{"$f":"$AV$7/$J$57*J45","v":0},{"$f":"$AW$7/$J$57*J45","v":0},{"$f":"$AX$7/$J$57*J45","v":0},{"$f":"$AY$7/$J$57*J45","v":0},{"$f":"$AZ$7/$J$57*J45","v":0},{"$f":"$BA$7/$J$57*J45","v":0},{"$f":"IF(C45>\"\",$BB$7/$G$57*G45,0)","v":0},{"$f":"IF(C45>\"\",$BC$7/$G$57*G45,0)","v":0},{"$f":"$BC$7/$H$57*H45","v":0},1,{"$f":"IF(BE45=1,BC45,BD45)","v":0},{"$f":"IF(C45>\"\",$BG$7/$G$57*G45,0)","v":0},{"$f":"$BG$7/$H$57*H45","v":0},2,{"$f":"IF(BI45=1,BG45,BH45)","v":0},null,{"$f":"M45+U45+Y45+AC45+AK45+AS45+AT45+AU45+AV45+AW45+AX45+AY45+AZ45+BA45+BB45+BF45+BJ45","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BN45:BY45)","v":0},{"$f":"SUM(BL45-BZ45)*-1","v":0}]
[null,null,null,null,null,null,{"$f":"F46-E46+IF(C46>\"\",1,0)","v":0},0,null,{"$f":"G46*I45","v":0},{"$f":"(D46)*I45*G46","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G47*I45","v":0},{"$f":"(D47)*I45*G47","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,{"$f":"$AJ$9","v":1},0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"WE 14",null,null,null,null,0,0,{"$f":"Gesamtübersicht!C17","v":0},{"$f":"G48*I48","v":0},{"$f":"(D48)*I48*G48","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G49*I48","v":0},{"$f":"(D49)*I48*G49","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G50*I48","v":0},{"$f":"(D50)*I48*G50","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,{"$f":"$AJ$9","v":1},0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"WE 15",null,null,null,null,0,0,{"$f":"Gesamtübersicht!C18","v":0},{"$f":"G51*I51","v":0},{"$f":"(D51)*I51*G51","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G52*I51","v":0},{"$f":"(D52)*I51*G52","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G53*I51","v":0},{"$f":"(D53)*I51*G53","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,{"$f":"$AJ$9","v":1},0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"WE 16",null,null,null,null,0,0,{"$f":"Gesamtübersicht!C19","v":0},{"$f":"G54*I54","v":0},{"$f":"(D54)*I54*G54","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G55*I54","v":0},{"$f":"(D55)*I54*G55","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,1,0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"G56*I54","v":0},{"$f":"(D56)*I54*G56","v":0},null,0,null,null,0,0,0,0,1,0,0,0,0,0,null,null,0,0,null,null,0,0,0,0,{"$f":"$AJ$9","v":1},0,null,null,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,2,0,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"(Prüf) Summen:",null,{"$f":"SUM(D9:D56)","v":16},null,null,{"$f":"SUM(G9:G56)","v":1460},{"$f":"SUM(H9:H56)","v":3434},{"$f":"SUM(I9+I12+I15+I18+I21+I24+I27+I30+I33+I36+I39+I42+I45+I48+I51+I54)","v":394.29999999999995},{"$f":"SUM(J9:J56)","v":143919.5},{"$f":"SUM(K9:L56)","v":326415.2},null,{"$f":"SUM(M9:M56)","v":2564},null,null,{"$f":"SUM(P9:P56)","v":3375},{"$f":"SUM(Q9:Q56)","v":600},{"$f":"SUM(R9:R56)","v":600},{"$f":"SUM(S9:S56)","v":600},null,{"$f":"SUM(U9:U56)","v":600},{"$f":"SUM(V9:V56)","v":500},{"$f":"SUM(W9:W56)","v":500.00000000000006},{"$f":"SUM(X9:X56)","v":500.00000000000006},{"$f":"SUM(Y9:Y56)","v":500},null,null,{"$f":"SUM(AB9:AB56)","v":0},{"$f":"SUM(AC9:AC56)","v":0},null,null,{"$f":"SUM(AF9:AF56)","v":0},{"$f":"SUM(AG9:AG56)","v":0},{"$f":"SUM(AH9:AH56)","v":0},{"$f":"SUM(AI9:AI56)","v":0},null,{"$f":"SUM(AK9:AK56)","v":0},null,null,{"$f":"SUM(AN9:AN56)","v":0},{"$f":"SUM(AO9:AO56)","v":0},{"$f":"SUM(AP9:AP56)","v":0},{"$f":"SUM(AQ9:AQ56)","v":0},null,{"$f":"SUM(AS9:AS56)","v":0},1094,678,100,350,100,200,1000.0000000000001,300,400,100,100,null,{"$f":"SUM(BF9:BF56)","v":100},{"$f":"SUM(BG9:BG56)","v":200},{"$f":"SUM(BH9:BH56)","v":200},null,{"$f":"SUM(BJ9:BJ55)","v":200},null,{"$f":"SUM(BL9:BL56)","v":8186},691.83218931621843,740,740,740,740,740,740,740,740,740,740,740,740,8880,694]

{"sheet":"Gesamtübersicht","index":1,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,8,39,9],[39,4,39,5],[1,1,1,3],[1,4,1,6],[1,7,1,9]]}
[]
[null,"Betriebskostenabrechnung",null,null,"Musterstr. 11",null,null,"12345 Musterstadt"]
[null,null,"qm",1000,"Mieter ","Personentage","Nachmieter 1","Personentage","Nachmieter 2","Personentage"]
[null,"WE 1",94.2,{"$f":"$D$20/$C$20*C4","v":238.90438752219126},{"$f":"Wohneinheiten!C9","v":"Hans Mustermann"},{"$f":"Wohneinheiten!H9","v":90},{"$f":"Wohneinheiten!C10","v":"Nachmieter 1"},{"$f":"Wohneinheiten!H10","v":428},{"$f":"Wohneinheiten!C11","v":"Nachmieter 2"},{"$f":"Wohneinheiten!H11","v":183}]
[null,"WE 2",138,{"$f":"$D$20/$C$20*C5","v":349.98731930002538},{"$f":"Wohneinheiten!C12","v":"Renate Musterfrau"},{"$f":"Wohneinheiten!H12","v":730},{"$f":"Wohneinheiten!C13","v":0},{"$f":"Wohneinheiten!H13","v":0},{"$f":"Wohneinheiten!C14","v":0},{"$f":"Wohneinheiten!H14","v":0}]
[null,"WE 3",66.599999999999994,168.90692366218616,{"$f":"Wohneinheiten!C15","v":"Hans Testperson"},{"$f":"Wohneinheiten!H15","v":1095},{"$f":"Wohneinheiten!C16","v":0},{"$f":"Wohneinheiten!H16","v":0},{"$f":"Wohneinheiten!C17","v":0},{"$f":"Wohneinheiten!H17","v":0}]
[null,"WE 4",95.5,242.20136951559726,{"$f":"Wohneinheiten!C18","v":"Renate Testperson"},{"$f":"Wohneinheiten!H18","v":724},{"$f":"Wohneinheiten!C19","v":"Nachmieter 3"},{"$f":"Wohneinheiten!H19","v":184},{"$f":"Wohneinheiten!C20","v":0},{"$f":"Wohneinheiten!H20","v":0}]
[null,"WE 5",0,0,{"$f":"Wohneinheiten!C21","v":0},{"$f":"Wohneinheiten!H21","v":0},{"$f":"Wohneinheiten!C22","v":0},{"$f":"Wohneinheiten!H22","v":0},{"$f":"Wohneinheiten!C23","v":0},{"$f":"Wohneinheiten!H23","v":0}]
[null,"WE 6",0,0,{"$f":"Wohneinheiten!C24","v":0},{"$f":"Wohneinheiten!H24","v":0},{"$f":"Wohneinheiten!C25","v":0},{"$f":"Wohneinheiten!H25","v":0},{"$f":"Wohneinheiten!C26","v":0},{"$f":"Wohneinheiten!H26","v":0}]
[null,"WE 7",0,0,{"$f":"Wohneinheiten!C27","v":0},{"$f":"Wohneinheiten!H27","v":0},{"$f":"Wohneinheiten!C28","v":0},{"$f":"Wohneinheiten!H28","v":0},{"$f":"Wohneinheiten!C29","v":0},{"$f":"Wohneinheiten!H29","v":0}]
[null,"WE 8",0,0,{"$f":"Wohneinheiten!C30","v":0},{"$f":"Wohneinheiten!H30","v":0},{"$f":"Wohneinheiten!C31","v":0},{"$f":"Wohneinheiten!H31","v":0},{"$f":"Wohneinheiten!C32","v":0},{"$f":"Wohneinheiten!H32","v":0}]
[null,"WE 9",0,0,{"$f":"Wohneinheiten!C33","v":0},{"$f":"Wohneinheiten!H33","v":0},{"$f":"Wohneinheiten!C34","v":0},{"$f":"Wohneinheiten!H34","v":0},{"$f":"Wohneinheiten!C35","v":0},{"$f":"Wohneinheiten!H35","v":0}]
[null,"WE 10",0,0,{"$f":"Wohneinheiten!C36","v":0},{"$f":"Wohneinheiten!H36","v":0},{"$f":"Wohneinheiten!C37","v":0},{"$f":"Wohneinheiten!H37","v":0},{"$f":"Wohneinheiten!C38","v":0},{"$f":"Wohneinheiten!H38","v":0}]
[null,"WE 11",0,0,{"$f":"Wohneinheiten!C39","v":0},{"$f":"Wohneinheiten!H39","v":0},{"$f":"Wohneinheiten!C40","v":0},{"$f":"Wohneinheiten!H40","v":0},{"$f":"Wohneinheiten!C41","v":0},{"$f":"Wohneinheiten!H41","v":0}]
[null,"WE 12",0,0,{"$f":"Wohneinheiten!C42","v":0},{"$f":"Wohneinheiten!H42","v":0},{"$f":"Wohneinheiten!C43","v":0},{"$f":"Wohneinheiten!H43","v":0},{"$f":"Wohneinheiten!C44","v":0},{"$f":"Wohneinheiten!H44","v":0}]
[null,"WE 13",0,0,{"$f":"Wohneinheiten!C45","v":0},{"$f":"Wohneinheiten!H45","v":0},{"$f":"Wohneinheiten!C46","v":0},{"$f":"Wohneinheiten!H46","v":0},{"$f":"Wohneinheiten!C47","v":0},{"$f":"Wohneinheiten!H47","v":0}]
[null,"WE 14",0,0,{"$f":"Wohneinheiten!C48","v":0},{"$f":"Wohneinheiten!H48","v":0},{"$f":"Wohneinheiten!C49","v":0},{"$f":"Wohneinheiten!H49","v":0},{"$f":"Wohneinheiten!C50","v":0},{"$f":"Wohneinheiten!H50","v":0}]
[null,"WE 15",0,0,{"$f":"Wohneinheiten!C51","v":0},{"$f":"Wohneinheiten!H51","v":0},{"$f":"Wohneinheiten!C52","v":0},{"$f":"Wohneinheiten!H52","v":0},{"$f":"Wohneinheiten!C53","v":0},{"$f":"Wohneinheiten!H53","v":0}]
[null,"WE 16",0,0,{"$f":"Wohneinheiten!C54","v":0},{"$f":"Wohneinheiten!H54","v":0},{"$f":"Wohneinheiten!C55","v":0},{"$f":"Wohneinheiten!H55","v":0},{"$f":"Wohneinheiten!C56","v":0},{"$f":"Wohneinheiten!H56","v":0}]
[null,null,{"$f":"SUM(C4:C19)","v":394.29999999999995},1000,null,{"$f":"SUM(F4:F19)","v":2639},null,{"$f":"SUM(H4:H19)","v":612},null,{"$f":"SUM(J4:J19)","v":183}]
[]
[null,"Posten","Beschreibung",null,null,null,"Betrag"]
[null,1,"Grundsteuer",null,null,null,2564]
[null,2,"Wasserkosten",null,null,null,600]
[null,3,"Abwasser",null,null,null,500]
[null,4,"Heizkosten",null,null,null,0]
[null,5,"Zentrale Wasserbereitung",null,null,null,0]
[null,6,"Verb. Heizungs- und Warmwasserversorgungsanlagen",null,null,null,0]
[null,7,"Fahrstuhl",null,null,null,1094]
[null,8,"Straßenreinigung / Müllabfuhr / Winterdienst",null,null,null,678]
[null,9,"Hausreinigung / Ungezieferbeseitigung",null,null,null,100]
[null,10,"Gartenpflege",null,null,null,350]
[null,11,"Beleuchtung",null,null,null,100]
[null,12,"Schornsteinreinigung",null,null,null,200]
[null,13,"Versicherungen",null,null,null,1000]
[null,14,"Hauswart",null,null,null,300]
[null,15,"Gemeinschaftsantenne / Breitbandkabel",null,null,null,400]
[null,16,"Wascheinrichtungen",null,null,null,100]
[null,17,"Sonstige Kosten",null,null,null,200]
[null,null,null,null,"Summe:",null,{"$f":"SUM(G23:G39)","v":8186},null,{"$f":"TODAY()","v":"2023-03-31"}]

{"sheet":"Einzelabrechnung","index":2,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,1,35,5],[34,1,34,5],[1,2,1,3],[1,4,1,5],[3,2,3,3],[3,1,4,1],[3,4,4,4],[3,5,4,5]]}
[]
[null,"Betriebskostenabrechnung",{"$f":"Gesamtübersicht!E2","v":"Musterstr. 11"},null,{"$f":"Gesamtübersicht!H2","v":"12345 Musterstadt"}]
[]
[null,"Mietername","Zeitraum",null,"Tage","Personen"]
[null,null,"Vom","Bis"]
[null,"Renate Musterfrau","2022-01-01","2022-12-31",365,2]
[]
[]
[null,"Abrechnungsposten","Saldo","Schlüssel","365 Tage",{"$f":"E6& \" Tage\"","v":"365 Tage"}]
[null,"Grundsteuer",{"$f":"Gesamtübersicht!G23","v":2564},"m² / Tage",{"$f":"F10/$E$6*365","v":897.37},897.37]
[null,"Wasserkosten",{"$f":"Gesamtübersicht!G24","v":600},"Zähler",{"$f":"F11/$E$6*365","v":81.42},81.42]
[null,"Abwasser",{"$f":"Gesamtübersicht!G25","v":500},"Zähler",67.849999999999994,67.849999999999994]
[null,"Heizkosten",{"$f":"Gesamtübersicht!G26","v":0},"Zähler",0,0]
[null,"Zentrale Wasserbereitung",{"$f":"Gesamtübersicht!G27","v":0},"Zähler",0,0]
[null,"Verb. Heizungs- und Warmwasserversorgungsanl.",{"$f":"Gesamtübersicht!G28","v":0},"Zähler",0,0]
[null,"Fahrstuhl",{"$f":"Gesamtübersicht!G29","v":1094},"m² / Tage",382.89000000000004,382.89]
[null,"Straßenreinigung / Müllabfuhr / Winterdienst",{"$f":"Gesamtübersicht!G30","v":678},"m² / Tage",237.29,237.29]
[null,"Hausreinigung / Ungezieferbeseitigung",{"$f":"Gesamtübersicht!G31","v":100},"m² / Tage",35,35]
[null,"Gartenpflege",{"$f":"Gesamtübersicht!G32","v":350},"m² / Tage",122.5,122.5]
[null,"Beleuchtung",{"$f":"Gesamtübersicht!G33","v":100},"m² / Tage",35,35]
[null,"Schornsteinreinigung",{"$f":"Gesamtübersicht!G34","v":200},"m² / Tage",70,70]
[null,"Versicherungen",{"$f":"Gesamtübersicht!G35","v":1000},"m² / Tage",349.99,349.99]
[null,"Hauswart",{"$f":"Gesamtübersicht!G36","v":300},"m² / Tage",105,105]
[null,"Gemeinschaftsantenne / Breitbandkabel",{"$f":"Gesamtübersicht!G37","v":400},"Wohnung=1",{"$f":"F24/$E$6*365","v":100},100]
[null,"Wascheinrichtungen",{"$f":"Gesamtübersicht!G38","v":100},"Wohnung=1",25,25]
[null,"Sonstige Kosten",{"$f":"Gesamtübersicht!G39","v":200},"m² / Tage",42.52,42.52]
[null,null,"Gesamtkosten:",null,{"$f":"SUM(E10:E26)","v":2551.83},{"$f":"SUM(F10:F26)","v":2551.8299999999995}]
[]
[null,null,"Abzüglich Ihrer geleisteten Zahlungen:",null,null,3600]
[null,null,"Erstattung:",null,null,{"$f":"SUM(F29-F27)","v":1048.1700000000005}]
[]
[null,"Abrechnungsdatum:",null,null,null,0]
[null,{"$f":"TODAY()","v":"2023-03-31"},"Neue Abschlagszahlung monatlich:",null,null,212.65]
[]
[null,"- Die zuviel gezahlten Nebenkosten werden Ihnen innerhalb der nächsten 4 Wochen überwiesen! -"]
[null,"- Bitte ändern Sie ggf. Ihren Dauerauftrag bei Ihrer Bank oder Sparkasse. Danke! -"]

{"sheet":"Adressdaten","index":3,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,1,1,9],[34,6,36,6],[37,6,39,6],[40,6,42,6],[43,6,45,6],[22,6,24,6],[25,6,27,6],[28,6,30,6],[31,6,33,6],[10,6,12,6],[13,6,15,6],[16,6,18,6],[19,6,21,6],[2,1,2,5],[2,6,2,9],[4,6,6,6],[7,6,9,6],[46,6,48,6],[49,6,51,6]]}
[]
[null,"Musterstr. 11, 12345 Musterstadt"]
[null,"Adressdaten nach Auszug",null,null,null,null,"Bewohnte Einheit"]
[null,"Name","Straße/Nr.","PLZ","Ort","Telefon","WE","BW","von","bis"]
[null,{"$f":"Wohneinheiten!C9","v":"Hans Mustermann"},"Erstmieterstr. 1",12345,"Erstmieterstadt 1","0123 456789",1,{"$f":"Wohneinheiten!D9","v":1},{"$f":"Wohneinheiten!E9","v":"2022-01-01"},{"$f":"Wohneinheiten!F9","v":"2022-03-31"}]
[null,{"$f":"Wohneinheiten!C10","v":"Nachmieter 1"},"Nachmieterstr. 1",23456,"Nachmieterstadt 1","0234 567890",null,{"$f":"Wohneinheiten!D10","v":2},{"$f":"Wohneinheiten!E10","v":"2022-04-01"},{"$f":"Wohneinheiten!F10","v":"2022-10-31"}]
[null,{"$f":"Wohneinheiten!C11","v":"Nachmieter 2"},null,null,null,null,null,{"$f":"Wohneinheiten!D11","v":3},{"$f":"Wohneinheiten!E11","v":"2022-11-01"},{"$f":"Wohneinheiten!F11","v":"2022-12-31"}]
[null,{"$f":"Wohneinheiten!C12","v":"Renate Musterfrau"},null,null,null,null,2,{"$f":"Wohneinheiten!D12","v":2},{"$f":"Wohneinheiten!E12","v":"2022-01-01"},{"$f":"Wohneinheiten!F12","v":"2022-12-31"}]
[null,{"$f":"Wohneinheiten!C13","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D13","v":0},{"$f":"Wohneinheiten!E13","v":"00:00:00"},{"$f":"Wohneinheiten!F13","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C14","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D14","v":0},{"$f":"Wohneinheiten!E14","v":"00:00:00"},{"$f":"Wohneinheiten!F14","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C15","v":"Hans Testperson"},null,null,null,null,3,{"$f":"Wohneinheiten!D15","v":3},{"$f":"Wohneinheiten!E15","v":"2022-01-01"},{"$f":"Wohneinheiten!F15","v":"2022-12-31"}]
[null,{"$f":"Wohneinheiten!C16","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D16","v":0},{"$f":"Wohneinheiten!E16","v":"00:00:00"},{"$f":"Wohneinheiten!F16","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C17","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D17","v":0},{"$f":"Wohneinheiten!E17","v":"00:00:00"},{"$f":"Wohneinheiten!F17","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C18","v":"Renate Testperson"},"Erstmieterstr. 2",12345,"Erstmieterstadt 2","0123 456789",4,{"$f":"Wohneinheiten!D18","v":4},{"$f":"Wohneinheiten!E18","v":"2022-01-01"},{"$f":"Wohneinheiten!F18","v":"2022-06-30"}]
[null,{"$f":"Wohneinheiten!C19","v":"Nachmieter 3"},null,null,null,null,null,{"$f":"Wohneinheiten!D19","v":1},{"$f":"Wohneinheiten!E19","v":"2022-07-01"},{"$f":"Wohneinheiten!F19","v":"2022-12-31"}]
[null,{"$f":"Wohneinheiten!C20","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D20","v":0},{"$f":"Wohneinheiten!E20","v":"00:00:00"},{"$f":"Wohneinheiten!F20","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C21","v":0},null,null,null,null,5,{"$f":"Wohneinheiten!D21","v":0},{"$f":"Wohneinheiten!E21","v":"00:00:00"},{"$f":"Wohneinheiten!F21","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C22","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D22","v":0},{"$f":"Wohneinheiten!E22","v":"00:00:00"},{"$f":"Wohneinheiten!F22","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C23","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D23","v":0},{"$f":"Wohneinheiten!E23","v":"00:00:00"},{"$f":"Wohneinheiten!F23","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C24","v":0},null,null,null,null,6,{"$f":"Wohneinheiten!D24","v":0},{"$f":"Wohneinheiten!E24","v":"00:00:00"},{"$f":"Wohneinheiten!F24","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C25","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D25","v":0},{"$f":"Wohneinheiten!E25","v":"00:00:00"},{"$f":"Wohneinheiten!F25","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C26","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D26","v":0},{"$f":"Wohneinheiten!E26","v":"00:00:00"},{"$f":"Wohneinheiten!F26","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C27","v":0},null,null,null,null,7,{"$f":"Wohneinheiten!D27","v":0},{"$f":"Wohneinheiten!E27","v":"00:00:00"},{"$f":"Wohneinheiten!F27","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C28","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D28","v":0},{"$f":"Wohneinheiten!E28","v":"00:00:00"},{"$f":"Wohneinheiten!F28","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C29","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D29","v":0},{"$f":"Wohneinheiten!E29","v":"00:00:00"},{"$f":"Wohneinheiten!F29","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C30","v":0},null,null,null,null,8,{"$f":"Wohneinheiten!D30","v":0},{"$f":"Wohneinheiten!E30","v":"00:00:00"},{"$f":"Wohneinheiten!F30","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C31","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D31","v":0},{"$f":"Wohneinheiten!E31","v":"00:00:00"},{"$f":"Wohneinheiten!F31","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C32","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D32","v":0},{"$f":"Wohneinheiten!E32","v":"00:00:00"},{"$f":"Wohneinheiten!F32","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C33","v":0},null,null,null,null,9,{"$f":"Wohneinheiten!D33","v":0},{"$f":"Wohneinheiten!E33","v":"00:00:00"},{"$f":"Wohneinheiten!F33","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C34","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D34","v":0},{"$f":"Wohneinheiten!E34","v":"00:00:00"},{"$f":"Wohneinheiten!F34","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C35","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D35","v":0},{"$f":"Wohneinheiten!E35","v":"00:00:00"},{"$f":"Wohneinheiten!F35","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C36","v":0},null,null,null,null,10,{"$f":"Wohneinheiten!D36","v":0},{"$f":"Wohneinheiten!E36","v":"00:00:00"},{"$f":"Wohneinheiten!F36","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C37","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D37","v":0},{"$f":"Wohneinheiten!E37","v":"00:00:00"},{"$f":"Wohneinheiten!F37","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C38","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D38","v":0},{"$f":"Wohneinheiten!E38","v":"00:00:00"},{"$f":"Wohneinheiten!F38","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C39","v":0},null,null,null,null,11,{"$f":"Wohneinheiten!D39","v":0},{"$f":"Wohneinheiten!E39","v":"00:00:00"},{"$f":"Wohneinheiten!F39","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C40","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D40","v":0},{"$f":"Wohneinheiten!E40","v":"00:00:00"},{"$f":"Wohneinheiten!F40","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C41","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D41","v":0},{"$f":"Wohneinheiten!E41","v":"00:00:00"},{"$f":"Wohneinheiten!F41","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C42","v":0},null,null,null,null,12,{"$f":"Wohneinheiten!D42","v":0},{"$f":"Wohneinheiten!E42","v":"00:00:00"},{"$f":"Wohneinheiten!F42","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C43","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D43","v":0},{"$f":"Wohneinheiten!E43","v":"00:00:00"},{"$f":"Wohneinheiten!F43","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C44","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D44","v":0},{"$f":"Wohneinheiten!E44","v":"00:00:00"},{"$f":"Wohneinheiten!F44","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C45","v":0},null,null,null,null,13,{"$f":"Wohneinheiten!D45","v":0},{"$f":"Wohneinheiten!E45","v":"00:00:00"},{"$f":"Wohneinheiten!F45","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C46","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D46","v":0},{"$f":"Wohneinheiten!E46","v":"00:00:00"},{"$f":"Wohneinheiten!F46","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C47","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D47","v":0},{"$f":"Wohneinheiten!E47","v":"00:00:00"},{"$f":"Wohneinheiten!F47","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C48","v":0},null,null,null,null,14,{"$f":"Wohneinheiten!D48","v":0},{"$f":"Wohneinheiten!E48","v":"00:00:00"},{"$f":"Wohneinheiten!F48","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C49","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D49","v":0},{"$f":"Wohneinheiten!E49","v":"00:00:00"},{"$f":"Wohneinheiten!F49","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C50","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D50","v":0},{"$f":"Wohneinheiten!E50","v":"00:00:00"},{"$f":"Wohneinheiten!F50","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C51","v":0},null,null,null,null,15,{"$f":"Wohneinheiten!D51","v":0},{"$f":"Wohneinheiten!E51","v":"00:00:00"},{"$f":"Wohneinheiten!F51","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C52","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D52","v":0},{"$f":"Wohneinheiten!E52","v":"00:00:00"},{"$f":"Wohneinheiten!F52","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C53","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D53","v":0},{"$f":"Wohneinheiten!E53","v":"00:00:00"},{"$f":"Wohneinheiten!F53","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C54","v":0},null,null,null,null,16,{"$f":"Wohneinheiten!D54","v":0},{"$f":"Wohneinheiten!E54","v":"00:00:00"},{"$f":"Wohneinheiten!F54","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C55","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D55","v":0},{"$f":"Wohneinheiten!E55","v":"00:00:00"},{"$f":"Wohneinheiten!F55","v":"00:00:00"}]
[null,{"$f":"Wohneinheiten!C56","v":0},null,null,null,null,null,{"$f":"Wohneinheiten!D56","v":0},{"$f":"Wohneinheiten!E56","v":"00:00:00"},{"$f":"Wohneinheiten!F56","v":"00:00:00"}]