{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["VP bankzeit","PlanVerwendung"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":2,"defined_names":10,"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":"VP bankzeit","index":0,"n_rows":38,"n_cols":37,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,0,3,9],[10,0,37,0],[14,3,37,32],[35,36,36,50]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Vielen Dank für die Nutzung dieses Excel-Tools. Es kann bei der Kostenplanung und der Verwendungskontrolle von Investitionsvorhaben privat oder geschäftlich unterstützen.\n[Kostenplanung] Optional kann die Planungsseite jederzeit mit Projektnamen und weiteren Infos individualisiert werden. Man gibt die Kosten der einzelnen Gewerke, denen dabei eine Positionsnummer zugeordnet wird, ein. Die Gesamtsumme wird ermittelt, und nach Vorgabe des geplanten Eigenmitteleinsatzes wird – sofern relevant – der Fremdfinanzierungsbedarf ermittelt.\n[Verwendung] Die Ausgabepositionen werden laufend eingetragen, die jeweilige Positionsnummer zugeordnet und vermerkt wieviel davon aus Eigenmitteln eingesetzt wird – der Rest wird automatisch dem Fremdfinanzierungsteil zugeordnet. Zu den einzelnen Positionen werden die Summen gebildet, so dass man zu jedem Gewerk und natürlich auch in der Gesamtschau sieht, was geplant ist, wieviel davon bereits verbraucht wurde und wieviel noch verfügbar ist.\nEin Klick auf den RESET-Button löscht alle Eingaben. \n\nTrotz langer Erfahrung und größtmöglicher Sorgfalt, kann bei diesem kleinen kostenfreien Tool natürlich keinerlei Haftung für Vollständigkeit, Richtigkeit, Fehlerfreiheit und Aktualität übernommen werden."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 1.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,null,null,null,null,null,null,null,null,null,null,null,null,"Stand: März 2021  | www.bankzeit.de | info@bankzeit.de"]

{"sheet":"PlanVerwendung","index":1,"n_rows":385,"n_cols":13,"rows_kept":385,"cut":false,"hidden":false,"merged":[[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[103,2,103,3],[90,2,90,3],[90,8,90,9],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[76,2,76,3],[77,2,77,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[81,2,81,3],[82,2,82,3],[83,2,83,3],[84,2,84,3],[85,2,85,3],[86,2,86,3],[87,2,87,3],[88,2,88,3],[85,8,85,9],[69,8,69,9],[86,8,86,9],[70,8,70,9],[71,8,71,9],[72,8,72,9],[73,8,73,9],[74,8,74,9],[75,8,75,9],[76,8,76,9],[77,8,77,9],[49,2,49,3],[49,8,49,9],[54,2,54,3],[54,8,54,9],[56,2,56,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[59,8,59,9],[60,8,60,9],[61,8,61,9],[118,8,118,9],[119,8,119,9],[120,8,120,9],[121,8,121,9],[122,8,122,9],[136,8,136,9],[137,8,137,9],[123,8,123,9],[124,8,124,9],[125,8,125,9],[126,8,126,9],[127,8,127,9],[128,8,128,9],[129,8,129,9],[130,8,130,9],[131,8,131,9],[145,2,145,3],[146,2,146,3],[147,2,147,3],[148,2,148,3],[149,2,149,3],[150,2,150,3],[151,2,151,3],[152,2,152,3],[58,8,58,9],[62,8,62,9],[67,8,67,9],[68,8,68,9],[89,8,89,9],[91,8,91,9],[92,8,92,9],[94,8,94,9],[95,8,95,9],[96,8,96,9],[97,8,97,9],[98,8,98,9],[114,8,114,9],[115,8,115,9],[116,8,116,9],[117,8,117,9],[136,2,136,3],[137,2,137,3],[138,2,138,3],[139,2,139,3],[140,2,140,3],[141,2,141,3],[142,2,142,3],[143,2,143,3],[144,2,144,3],[271,8,271,9],[272,8,272,9],[273,8,273,9],[10,1,10,3],[11,1,11,3],[12,1,12,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[266,8,266,9],[267,8,267,9],[268,8,268,9],[269,8,269,9],[270,8,270,9],[261,8,261,9],[262,8,262,9],[263,8,263,9],[264,8,264,9],[265,8,265,9],[58,2,58,3],[62,2,62,3],[259,8,259,9],[260,8,260,9],[251,8,251,9],[252,8,252,9],[253,8,253,9],[254,8,254,9],[255,8,255,9],[2,1,2,9],[24,1,24,3],[67,2,67,3],[68,2,68,3],[89,2,89,3],[91,2,91,3],[192,2,192,3],[193,2,193,3],[194,2,194,3],[195,2,195,3],[92,2,92,3],[94,2,94,3],[95,2,95,3],[96,2,96,3],[97,2,97,3],[98,2,98,3],[115,2,115,3],[196,8,196,9],[248,8,248,9],[249,8,249,9],[250,8,250,9],[190,8,190,9],[191,8,191,9],[256,8,256,9],[257,8,257,9],[258,8,258,9],[192,8,192,9],[193,8,193,9],[194,8,194,9],[195,8,195,9],[230,8,230,9],[237,8,237,9],[204,8,204,9],[189,8,189,9],[53,8,53,9],[55,8,55,9],[57,8,57,9],[183,8,183,9],[184,8,184,9],[99,8,99,9],[100,8,100,9],[101,8,101,9],[102,8,102,9],[104,8,104,9],[105,8,105,9],[106,8,106,9],[107,8,107,9],[108,8,108,9],[109,8,109,9],[110,8,110,9],[111,8,111,9],[112,8,112,9],[113,8,113,9],[132,8,132,9],[133,8,133,9],[134,8,134,9],[135,8,135,9],[185,8,185,9],[186,8,186,9],[187,8,187,9],[188,8,188,9],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[104,2,104,3],[105,2,105,3],[106,2,106,3],[107,2,107,3],[108,2,108,3],[109,2,109,3],[110,2,110,3],[111,2,111,3],[112,2,112,3],[113,2,113,3],[114,2,114,3],[116,2,116,3],[132,2,132,3],[133,2,133,3],[134,2,134,3],[135,2,135,3],[271,2,271,3],[272,2,272,3],[273,2,273,3],[265,2,265,3],[266,2,266,3],[267,2,267,3],[268,2,268,3],[269,2,269,3],[53,2,53,3],[117,2,117,3],[118,2,118,3],[119,2,119,3],[120,2,120,3],[121,2,121,3],[122,2,122,3],[123,2,123,3],[124,2,124,3],[125,2,125,3],[126,2,126,3],[127,2,127,3],[128,2,128,3],[129,2,129,3],[130,2,130,3],[131,2,131,3],[270,2,270,3],[262,2,262,3],[6,3,6,4],[7,3,7,4],[43,2,43,3],[44,2,44,3],[45,2,45,3],[55,2,55,3],[57,2,57,3],[183,2,183,3],[184,2,184,3],[190,2,190,3],[191,2,191,3],[185,2,185,3],[186,2,186,3],[187,2,187,3],[188,2,188,3],[189,2,189,3],[259,2,259,3],[260,2,260,3],[261,2,261,3],[263,2,263,3],[9,1,9,3],[46,2,46,3],[248,2,248,3],[249,2,249,3],[250,2,250,3],[251,2,251,3],[252,2,252,3],[253,2,253,3],[264,2,264,3],[254,2,254,3],[255,2,255,3],[256,2,256,3],[257,2,257,3],[258,2,258,3],[4,1,4,4],[3,5,3,7],[8,1,8,9],[5,1,7,2],[0,7,0,9],[0,4,0,6],[0,1,0,2],[3,8,4,9],[196,2,196,3],[1,8,1,9],[43,8,43,9],[44,8,44,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[48,8,48,9],[52,8,52,9],[47,2,47,3],[48,2,48,3],[52,2,52,3],[3,1,3,4],[5,3,5,4],[40,1,40,3],[41,1,41,4],[153,2,153,3],[154,2,154,3],[156,2,156,3],[157,2,157,3],[158,2,158,3],[159,2,159,3],[160,2,160,3],[161,2,161,3],[162,2,162,3],[163,2,163,3],[164,2,164,3],[165,2,165,3],[166,2,166,3],[167,2,167,3],[168,2,168,3],[169,2,169,3],[173,2,173,3],[174,2,174,3],[175,2,175,3],[176,2,176,3],[177,2,177,3],[178,2,178,3],[179,2,179,3],[180,2,180,3],[181,2,181,3],[182,2,182,3],[170,2,170,3],[171,2,171,3],[172,2,172,3],[140,8,140,9],[138,8,138,9],[139,8,139,9],[141,8,141,9],[142,8,142,9],[143,8,143,9],[144,8,144,9],[145,8,145,9],[151,8,151,9],[167,8,167,9],[168,8,168,9],[169,8,169,9],[170,8,170,9],[152,8,152,9],[153,8,153,9],[154,8,154,9],[155,8,155,9],[156,8,156,9],[157,8,157,9],[158,8,158,9],[159,8,159,9],[160,8,160,9],[181,8,181,9],[182,8,182,9],[171,8,171,9],[161,8,161,9],[150,8,150,9],[155,2,155,3],[149,8,149,9],[146,8,146,9],[147,8,147,9],[148,8,148,9],[172,8,172,9],[173,8,173,9],[174,8,174,9],[175,8,175,9],[176,8,176,9],[177,8,177,9],[178,8,178,9],[179,8,179,9],[180,8,180,9],[162,8,162,9],[163,8,163,9],[164,8,164,9],[165,8,165,9],[166,8,166,9],[197,2,197,3],[197,8,197,9],[198,2,198,3],[198,8,198,9],[199,2,199,3],[199,8,199,9],[200,2,200,3],[200,8,200,9],[201,2,201,3],[201,8,201,9],[202,2,202,3],[202,8,202,9],[203,2,203,3],[203,8,203,9],[205,2,205,3],[205,8,205,9],[206,2,206,3],[206,8,206,9],[207,2,207,3],[207,8,207,9],[204,2,204,3],[208,2,208,3],[208,8,208,9],[209,2,209,3],[209,8,209,9],[210,2,210,3],[210,8,210,9],[211,2,211,3],[211,8,211,9],[212,2,212,3],[212,8,212,9],[213,2,213,3],[213,8,213,9],[214,2,214,3],[214,8,214,9],[215,2,215,3],[215,8,215,9],[216,2,216,3],[216,8,216,9],[217,2,217,3],[217,8,217,9],[218,2,218,3],[218,8,218,9],[219,2,219,3],[219,8,219,9],[220,2,220,3],[220,8,220,9],[221,2,221,3],[221,8,221,9],[222,2,222,3],[222,8,222,9],[223,2,223,3],[223,8,223,9],[224,2,224,3],[224,8,224,9],[225,2,225,3],[225,8,225,9],[226,2,226,3],[226,8,226,9],[227,2,227,3],[227,8,227,9],[246,2,246,3],[246,8,246,9],[247,2,247,3],[247,8,247,9],[238,2,238,3],[238,8,238,9],[239,2,239,3],[239,8,239,9],[240,2,240,3],[240,8,240,9],[241,2,241,3],[241,8,241,9],[242,2,242,3],[242,8,242,9],[228,2,228,3],[228,8,228,9],[229,2,229,3],[229,8,229,9],[230,2,230,3],[244,2,244,3],[244,8,244,9],[245,2,245,3],[245,8,245,9],[231,2,231,3],[231,8,231,9],[232,2,232,3],[232,8,232,9],[243,2,243,3],[243,8,243,9],[233,2,233,3],[233,8,233,9],[234,2,234,3],[234,8,234,9],[235,2,235,3],[235,8,235,9],[236,2,236,3],[236,8,236,9],[237,2,237,3],[64,2,64,3],[66,2,66,3],[78,8,78,9],[79,8,79,9],[80,8,80,9],[81,8,81,9],[82,8,82,9],[83,8,83,9],[84,8,84,9],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[274,2,274,3],[274,8,274,9],[275,2,275,3],[275,8,275,9],[65,2,65,3],[65,8,65,9],[93,2,93,3],[50,2,50,3],[50,8,50,9],[51,2,51,3],[51,8,51,9],[56,8,56,9],[93,8,93,9],[87,8,87,9],[88,8,88,9],[63,8,63,9],[64,8,64,9],[66,8,66,9],[63,2,63,3],[276,2,276,3],[276,8,276,9],[277,2,277,3],[277,8,277,9],[278,2,278,3],[278,8,278,9],[279,2,279,3],[279,8,279,9],[280,2,280,3],[280,8,280,9],[281,2,281,3],[281,8,281,9],[282,2,282,3],[282,8,282,9],[283,2,283,3],[283,8,283,9],[284,2,284,3],[284,8,284,9],[285,2,285,3],[285,8,285,9],[286,2,286,3],[286,8,286,9],[287,2,287,3],[287,8,287,9],[288,2,288,3],[288,8,288,9],[289,2,289,3],[289,8,289,9],[290,2,290,3],[290,8,290,9],[291,2,291,3],[291,8,291,9],[292,2,292,3],[292,8,292,9],[293,2,293,3],[293,8,293,9],[294,2,294,3],[294,8,294,9],[295,2,295,3],[295,8,295,9],[296,2,296,3],[296,8,296,9],[297,2,297,3],[297,8,297,9],[298,2,298,3],[298,8,298,9],[299,2,299,3],[299,8,299,9],[300,2,300,3],[300,8,300,9],[301,2,301,3],[301,8,301,9],[302,2,302,3],[302,8,302,9],[303,2,303,3],[303,8,303,9],[304,2,304,3],[304,8,304,9],[305,2,305,3],[305,8,305,9],[306,2,306,3],[306,8,306,9],[307,2,307,3],[307,8,307,9],[308,2,308,3],[308,8,308,9],[309,2,309,3],[309,8,309,9],[310,2,310,3],[310,8,310,9],[311,2,311,3],[311,8,311,9],[312,2,312,3],[312,8,312,9],[313,2,313,3],[313,8,313,9],[314,2,314,3],[314,8,314,9],[315,2,315,3],[315,8,315,9],[316,2,316,3],[316,8,316,9],[317,2,317,3],[317,8,317,9],[318,2,318,3],[318,8,318,9],[319,2,319,3],[319,8,319,9],[320,2,320,3],[320,8,320,9],[321,2,321,3],[321,8,321,9],[322,2,322,3],[322,8,322,9],[323,2,323,3],[323,8,323,9],[324,2,324,3],[324,8,324,9],[325,2,325,3],[325,8,325,9],[326,2,326,3],[326,8,326,9],[327,2,327,3],[327,8,327,9],[328,2,328,3],[328,8,328,9],[329,2,329,3],[329,8,329,9],[330,2,330,3],[330,8,330,9],[331,2,331,3],[331,8,331,9],[332,2,332,3],[332,8,332,9],[333,2,333,3],[333,8,333,9],[334,2,334,3],[334,8,334,9],[335,2,335,3],[335,8,335,9],[336,2,336,3],[336,8,336,9],[337,2,337,3],[337,8,337,9],[338,2,338,3],[338,8,338,9],[339,2,339,3],[339,8,339,9],[340,2,340,3],[340,8,340,9],[341,2,341,3],[341,8,341,9],[342,2,342,3],[342,8,342,9],[343,2,343,3],[343,8,343,9],[344,2,344,3],[344,8,344,9],[345,2,345,3],[345,8,345,9],[346,2,346,3],[346,8,346,9],[347,2,347,3],[347,8,347,9],[348,2,348,3],[348,8,348,9],[349,2,349,3],[349,8,349,9],[350,2,350,3],[350,8,350,9],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[366,2,366,3],[366,8,366,9],[367,2,367,3],[367,8,367,9],[361,2,361,3],[361,8,361,9],[362,2,362,3],[362,8,362,9],[363,2,363,3],[363,8,363,9],[364,2,364,3],[364,8,364,9],[365,2,365,3],[365,8,365,9],[356,2,356,3],[356,8,356,9],[357,2,357,3],[357,8,357,9],[358,2,358,3],[351,2,351,3],[351,8,351,9],[352,2,352,3],[352,8,352,9],[376,2,376,3],[376,8,376,9],[377,2,377,3],[377,8,377,9],[378,2,378,3],[378,8,378,9],[371,2,371,3],[371,8,371,9],[372,2,372,3],[372,8,372,9],[373,2,373,3],[373,8,373,9],[353,2,353,3],[353,8,353,9],[354,2,354,3],[354,8,354,9],[355,2,355,3],[355,8,355,9],[368,8,368,9],[369,2,369,3],[369,8,369,9],[370,2,370,3],[370,8,370,9],[358,8,358,9],[359,2,359,3],[359,8,359,9],[360,2,360,3],[360,8,360,9],[5,8,7,9],[1,3,1,7],[1,1,1,2],[1,10,1,12],[382,2,382,3],[382,8,382,9],[383,2,383,3],[383,8,383,9],[379,2,379,3],[379,8,379,9],[380,2,380,3],[380,8,380,9],[381,2,381,3],[381,8,381,9],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[374,2,374,3],[374,8,374,9],[375,2,375,3],[375,8,375,9],[368,2,368,3]]}
[]
[null,null,null,"Investitionsplan & Verwendung",null,null,null,null,{"$f":"TODAY()","v":"2021-03-06"}]
[]
[null,"Name | Projektbezeichnung",null,null,null,"Finanzierungsplan | Beträge in Euro",null,null," Darlehenskonten\n und/oder Infos"]
[null,null,null,null,null,"Gesamtkosten","Eigenmittel","Fremdmittel"]
[null,"Summen\n",null,"Plan",null,{"$f":"F42","v":0},null,{"$f":"IF(OR(F6=0,F6=\"\"),\"\",F6-G6)","v":""}]
[null,null,null,"Ist",null,{"$f":"IF(OR(F6=0,F6=\"\"),\"\",SUM(F45:F510))","v":""},{"$f":"IF(OR(G6=0,G6=\"\"),\"\",SUM(G45:G510))","v":""},{"$f":"IF(G6=0,F7,IF(OR(F6=0,F6=\"\"),\"\",F7-G7))","v":""}]
[null,null,null,"Offen",null,{"$f":"IF(OR(F6=0,F6=\"\"),\"\",F6-F7)","v":""},{"$f":"IF(OR(G6=0,G6=\"\"),\"\",G6-G7)","v":""},{"$f":"IF(OR(H6=0,H6=\"\"),\"\",H6-H7)","v":""}]
[]
[null,"Bezeichnung der Positionen/Gewerke",null,null,"Pos","PLAN Gesamt","IST Eigenmittel","IST Fremdmittel","IST Summe","noch offen"]
[null,null,null,null,1,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,1)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,1)","v":0},{"$f":"IF(M11=0,\"\",G11+H11)","v":0},{"$f":"IF(I11=\"\",\"\",F11-I11)","v":0},{"$f":"IF(G11=\"\",0,1)","v":1},{"$f":"IF(H11=\"\",0,1)","v":1},{"$f":"K11+L11","v":2}]
[null,null,null,null,2,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,2)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,2)","v":0},{"$f":"IF(M12=0,\"\",G12+H12)","v":0},{"$f":"IF(I12=\"\",\"\",F12-I12)","v":0},{"$f":"IF(G12=\"\",0,1)","v":1},{"$f":"IF(H12=\"\",0,1)","v":1},{"$f":"K12+L12","v":2}]
[null,null,null,null,3,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,3)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,3)","v":0},0,0,{"$f":"IF(G13=\"\",0,1)","v":1},{"$f":"IF(H13=\"\",0,1)","v":1},{"$f":"K13+L13","v":2}]
[null,null,null,null,4,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,4)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,4)","v":0},0,0,1,1,2]
[null,null,null,null,5,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,5)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,5)","v":0},0,0,1,1,2]
[null,null,null,null,6,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,6)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,6)","v":0},0,0,1,1,2]
[null,null,null,null,7,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,7)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,7)","v":0},0,0,1,1,2]
[null,null,null,null,8,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,8)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,8)","v":0},0,0,1,1,2]
[null,null,null,null,9,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,9)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,9)","v":0},0,0,1,1,2]
[null,null,null,null,10,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,10)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,10)","v":0},0,0,1,1,2]
[null,null,null,null,11,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,11)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,11)","v":0},0,0,1,1,2]
[null,null,null,null,12,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,12)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,12)","v":0},0,0,1,1,2]
[null,null,null,null,13,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,13)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,13)","v":0},0,0,1,1,2]
[null,null,null,null,14,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,14)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,14)","v":0},0,0,1,1,2]
[null,null,null,null,15,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,15)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,15)","v":0},0,0,1,1,2]
[null,null,null,null,16,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,16)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,16)","v":0},0,0,1,1,2]
[null,null,null,null,17,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,17)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,17)","v":0},0,0,1,1,2]
[null,null,null,null,18,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,18)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,18)","v":0},0,0,1,1,2]
[null,null,null,null,19,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,19)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,19)","v":0},0,0,1,1,2]
[null,null,null,null,20,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,20)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,20)","v":0},0,0,1,1,2]
[null,null,null,null,21,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,21)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,21)","v":0},{"$f":"IF(M31=0,\"\",G31+H31)","v":0},{"$f":"IF(I31=\"\",\"\",F31-I31)","v":0},{"$f":"IF(G31=\"\",0,1)","v":1},{"$f":"IF(H31=\"\",0,1)","v":1},{"$f":"K31+L31","v":2}]
[null,null,null,null,22,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,22)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,22)","v":0},0,0,1,1,2]
[null,null,null,null,23,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,23)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,23)","v":0},0,0,1,1,2]
[null,null,null,null,24,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,24)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,24)","v":0},0,0,1,1,2]
[null,null,null,null,25,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,25)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,25)","v":0},0,0,1,1,2]
[null,null,null,null,26,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,26)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,26)","v":0},{"$f":"IF(M36=0,\"\",G36+H36)","v":0},{"$f":"IF(I36=\"\",\"\",F36-I36)","v":0},{"$f":"IF(G36=\"\",0,1)","v":1},{"$f":"IF(H36=\"\",0,1)","v":1},{"$f":"K36+L36","v":2}]
[null,null,null,null,27,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,27)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,27)","v":0},0,0,1,1,2]
[null,null,null,null,28,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,28)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,28)","v":0},0,0,1,1,2]
[null,null,null,null,29,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,29)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,29)","v":0},0,0,1,1,2]
[null,null,null,null,30,null,{"$f":"SUMIFS($G$45:$G$510,$E$45:$E$510,30)","v":0},{"$f":"SUMIFS($H$45:$H$510,$E$45:$E$510,30)","v":0},0,0,1,1,2]
[null,"Ohne spezielle Zuordnung ",null,null,0,null,{"$f":"SUM(G45:G510)-SUM(G11:G30)","v":0},{"$f":"SUM(H45:H510)-SUM(H11:H30)","v":0},{"$f":"IF(M41=0,\"\",G41+H41)","v":0},{"$f":"IF(I41=\"\",\"\",F41-I41)","v":0},1,1,2]
[null,{"$f":"IF(F42>F6,\"EINZELPOSITIONEN > GESAMTKOSTEN !\",\"S U M M E \")","v":"S U M M E "},null,null,null,{"$f":"SUM(F11:F41)","v":0},{"$f":"SUM(G11:G41)","v":0},{"$f":"SUM(H11:H41)","v":0},{"$f":"SUM(I11:I41)","v":0},{"$f":"SUM(J11:J41)","v":0}]
[]
[null,"Datum","Verwendungszweck",null,"Pos","Gesamt","aus\nEigenmittel","aus\nDarlehen","Ergänzende Informationen\n(z. B. Bautenstandskontrolle am …)"]
[1,null,null,null,null,null,null,{"$f":"IF(F45=\"\",\"\",F45-G45)","v":""}]
[2,null,null,null,null,null,null,""]
[3,null,null,null,null,null,null,""]
[4,null,null,null,null,null,null,""]
[5,null,null,null,null,null,null,""]
[6,null,null,null,null,null,null,{"$f":"IF(F50=\"\",\"\",F50-G50)","v":""}]
[7,null,null,null,null,null,null,""]
[8,null,null,null,null,null,null,""]
[9,null,null,null,null,null,null,""]
[10,null,null,null,null,null,null,""]
[11,null,null,null,null,null,null,{"$f":"IF(F55=\"\",\"\",F55-G55)","v":""}]
[12,null,null,null,null,null,null,""]
[13,null,null,null,null,null,null,{"$f":"IF(F57=\"\",\"\",F57-G57)","v":""}]
[14,null,null,null,null,null,null,""]
[15,null,null,null,null,null,null,""]
[16,null,null,null,null,null,null,""]
[17,null,null,null,null,null,null,""]
[18,null,null,null,null,null,null,{"$f":"IF(F62=\"\",\"\",F62-G62)","v":""}]
[19,null,null,null,null,null,null,""]
[20,null,null,null,null,null,null,{"$f":"IF(F64=\"\",\"\",F64-G64)","v":""}]
[21,null,null,null,null,null,null,""]
[22,null,null,null,null,null,null,""]
[23,null,null,null,null,null,null,""]
[24,null,null,null,null,null,null,""]
[25,null,null,null,null,null,null,""]
[26,null,null,null,null,null,null,""]
[27,null,null,null,null,null,null,""]
[28,null,null,null,null,null,null,""]
[29,null,null,null,null,null,null,""]
[30,null,null,null,null,null,null,""]
[31,null,null,null,null,null,null,""]
[32,null,null,null,null,null,null,""]
[33,null,null,null,null,null,null,""]
[34,null,null,null,null,null,null,""]
[35,null,null,null,null,null,null,""]
[36,null,null,null,null,null,null,""]
[37,null,null,null,null,null,null,""]
[38,null,null,null,null,null,null,""]
[39,null,null,null,null,null,null,""]
[40,null,null,null,null,null,null,{"$f":"IF(F84=\"\",\"\",F84-G84)","v":""}]
[41,null,null,null,null,null,null,""]
[42,null,null,null,null,null,null,""]
[43,null,null,null,null,null,null,""]
[44,null,null,null,null,null,null,""]
[45,null,null,null,null,null,null,""]
[46,null,null,null,null,null,null,""]
[47,null,null,null,null,null,null,""]
[48,null,null,null,null,null,null,""]
[49,null,null,null,null,null,null,""]
[50,null,null,null,null,null,null,""]
[51,null,null,null,null,null,null,""]
[52,null,null,null,null,null,null,""]
[53,null,null,null,null,null,null,""]
[54,null,null,null,null,null,null,""]
[55,null,null,null,null,null,null,""]
[56,null,null,null,null,null,null,""]
[57,null,null,null,null,null,null,""]
[58,null,null,null,null,null,null,""]
[59,null,null,null,null,null,null,""]
[60,null,null,null,null,null,null,""]
[61,null,null,null,null,null,null,""]
[62,null,null,null,null,null,null,""]
[63,null,null,null,null,null,null,""]
[64,null,null,null,null,null,null,""]
[65,null,null,null,null,null,null,""]
[66,null,null,null,null,null,null,""]
[67,null,null,null,null,null,null,""]
[68,null,null,null,null,null,null,""]
[69,null,null,null,null,null,null,""]
[70,null,null,null,null,null,null,""]
[71,null,null,null,null,null,null,""]
[72,null,null,null,null,null,null,""]
[73,null,null,null,null,null,null,""]
[74,null,null,null,null,null,null,""]
[75,null,null,null,null,null,null,""]
[76,null,null,null,null,null,null,""]
[77,null,null,null,null,null,null,""]
[78,null,null,null,null,null,null,""]
[79,null,null,null,null,null,null,""]
[80,null,null,null,null,null,null,""]
[81,null,null,null,null,null,null,""]
[82,null,null,null,null,null,null,""]
[83,null,null,null,null,null,null,""]
[84,null,null,null,null,null,null,""]
[85,null,null,null,null,null,null,""]
[86,null,null,null,null,null,null,""]
[87,null,null,null,null,null,null,""]
[88,null,null,null,null,null,null,""]
[89,null,null,null,null,null,null,""]
[90,null,null,null,null,null,null,""]
[91,null,null,null,null,null,null,""]
[92,null,null,null,null,null,null,""]
[93,null,null,null,null,null,null,""]
[94,null,null,null,null,null,null,""]
[95,null,null,null,null,null,null,""]
[96,null,null,null,null,null,null,""]
[97,null,null,null,null,null,null,""]
[98,null,null,null,null,null,null,""]
[99,null,null,null,null,null,null,""]
[100,null,null,null,null,null,null,""]
[101,null,null,null,null,null,null,""]
[102,null,null,null,null,null,null,""]
[103,null,null,null,null,null,null,""]
[104,null,null,null,null,null,null,""]
[105,null,null,null,null,null,null,""]
[106,null,null,null,null,null,null,""]
[107,null,null,null,null,null,null,""]
[108,null,null,null,null,null,null,""]
[109,null,null,null,null,null,null,""]
[110,null,null,null,null,null,null,""]
[111,null,null,null,null,null,null,""]
[112,null,null,null,null,null,null,""]
[113,null,null,null,null,null,null,""]
[114,null,null,null,null,null,null,""]
[115,null,null,null,null,null,null,""]
[116,null,null,null,null,null,null,""]
[117,null,null,null,null,null,null,""]
[118,null,null,null,null,null,null,""]
[119,null,null,null,null,null,null,""]
[120,null,null,null,null,null,null,""]
[121,null,null,null,null,null,null,""]
[122,null,null,null,null,null,null,""]
[123,null,null,null,null,null,null,""]
[124,null,null,null,null,null,null,""]
[125,null,null,null,null,null,null,""]
[126,null,null,null,null,null,null,""]
[127,null,null,null,null,null,null,""]
[128,null,null,null,null,null,null,""]
[129,null,null,null,null,null,null,""]
[130,null,null,null,null,null,null,""]
[131,null,null,null,null,null,null,""]
[132,null,null,null,null,null,null,""]
[133,null,null,null,null,null,null,""]
[134,null,null,null,null,null,null,""]
[135,null,null,null,null,null,null,""]
[136,null,null,null,null,null,null,""]
[137,null,null,null,null,null,null,""]
[138,null,null,null,null,null,null,""]
[139,null,null,null,null,null,null,""]
[140,null,null,null,null,null,null,""]
[141,null,null,null,null,null,null,""]
[142,null,null,null,null,null,null,""]
[143,null,null,null,null,null,null,""]
[144,null,null,null,null,null,null,""]
[145,null,null,null,null,null,null,""]
[146,null,null,null,null,null,null,""]
[147,null,null,null,null,null,null,""]
[148,null,null,null,null,null,null,{"$f":"IF(F192=\"\",\"\",F192-G192)","v":""}]
[149,null,null,null,null,null,null,{"$f":"IF(F193=\"\",\"\",F193-G193)","v":""}]
[150,null,null,null,null,null,null,{"$f":"IF(F194=\"\",\"\",F194-G194)","v":""}]
[151,null,null,null,null,null,null,{"$f":"IF(F195=\"\",\"\",F195-G195)","v":""}]
[152,null,null,null,null,null,null,{"$f":"IF(F196=\"\",\"\",F196-G196)","v":""}]
[153,null,null,null,null,null,null,{"$f":"IF(F197=\"\",\"\",F197-G197)","v":""}]
[154,null,null,null,null,null,null,""]
[155,null,null,null,null,null,null,""]
[156,null,null,null,null,null,null,""]
[157,null,null,null,null,null,null,""]
[158,null,null,null,null,null,null,""]
[159,null,null,null,null,null,null,""]
[160,null,null,null,null,null,null,""]
[161,null,null,null,null,null,null,{"$f":"IF(F205=\"\",\"\",F205-G205)","v":""}]
[162,null,null,null,null,null,null,""]
[163,null,null,null,null,null,null,""]
[164,null,null,null,null,null,null,""]
[165,null,null,null,null,null,null,""]
[166,null,null,null,null,null,null,""]
[167,null,null,null,null,null,null,""]
[168,null,null,null,null,null,null,""]
[169,null,null,null,null,null,null,""]
[170,null,null,null,null,null,null,""]
[171,null,null,null,null,null,null,""]
[172,null,null,null,null,null,null,""]
[173,null,null,null,null,null,null,""]
[174,null,null,null,null,null,null,""]
[175,null,null,null,null,null,null,""]
[176,null,null,null,null,null,null,""]
[177,null,null,null,null,null,null,""]
[178,null,null,null,null,null,null,""]
[179,null,null,null,null,null,null,""]
[180,null,null,null,null,null,null,""]
[181,null,null,null,null,null,null,""]
[182,null,null,null,null,null,null,""]
[183,null,null,null,null,null,null,""]
[184,null,null,null,null,null,null,""]
[185,null,null,null,null,null,null,""]
[186,null,null,null,null,null,null,""]
[187,null,null,null,null,null,null,""]
[188,null,null,null,null,null,null,""]
[189,null,null,null,null,null,null,""]
[190,null,null,null,null,null,null,""]
[191,null,null,null,null,null,null,""]
[192,null,null,null,null,null,null,""]
[193,null,null,null,null,null,null,""]
[194,null,null,null,null,null,null,""]
[195,null,null,null,null,null,null,""]
[196,null,null,null,null,null,null,""]
[197,null,null,null,null,null,null,""]
[198,null,null,null,null,null,null,""]
[199,null,null,null,null,null,null,""]
[200,null,null,null,null,null,null,""]
[201,null,null,null,null,null,null,""]
[202,null,null,null,null,null,null,""]
[203,null,null,null,null,null,null,""]
[204,null,null,null,null,null,null,""]
[205,null,null,null,null,null,null,""]
[206,null,null,null,null,null,null,""]
[207,null,null,null,null,null,null,""]
[208,null,null,null,null,null,null,""]
[209,null,null,null,null,null,null,""]
[210,null,null,null,null,null,null,""]
[211,null,null,null,null,null,null,""]
[212,null,null,null,null,null,null,""]
[213,null,null,null,null,null,null,""]
[214,null,null,null,null,null,null,{"$f":"IF(F258=\"\",\"\",F258-G258)","v":""}]
[215,null,null,null,null,null,null,""]
[216,null,null,null,null,null,null,""]
[217,null,null,null,null,null,null,""]
[218,null,null,null,null,null,null,""]
[219,null,null,null,null,null,null,""]
[220,null,null,null,null,null,null,""]
[221,null,null,null,null,null,null,""]
[222,null,null,null,null,null,null,""]
[223,null,null,null,null,null,null,""]
[224,null,null,null,null,null,null,""]
[225,null,null,null,null,null,null,""]
[226,null,null,null,null,null,null,""]
[227,null,null,null,null,null,null,""]
[228,null,null,null,null,null,null,""]
[229,null,null,null,null,null,null,""]
[230,null,null,null,null,null,null,""]
[66,null,null,null,null,null,null,""]
[67,null,null,null,null,null,null,""]
[68,null,null,null,null,null,null,""]
[69,null,null,null,null,null,null,""]
[70,null,null,null,null,null,null,""]
[71,null,null,null,null,null,null,""]
[72,null,null,null,null,null,null,""]
[73,null,null,null,null,null,null,""]
[74,null,null,null,null,null,null,""]
[75,null,null,null,null,null,null,""]
[76,null,null,null,null,null,null,""]
[77,null,null,null,null,null,null,""]
[78,null,null,null,null,null,null,""]
[79,null,null,null,null,null,null,""]
[80,null,null,null,null,null,null,""]
[81,null,null,null,null,null,null,""]
[82,null,null,null,null,null,null,""]
[83,null,null,null,null,null,null,""]
[84,null,null,null,null,null,null,""]
[85,null,null,null,null,null,null,""]
[86,null,null,null,null,null,null,""]
[87,null,null,null,null,null,null,""]
[88,null,null,null,null,null,null,""]
[89,null,null,null,null,null,null,""]
[90,null,null,null,null,null,null,""]
[91,null,null,null,null,null,null,""]
[92,null,null,null,null,null,null,""]
[93,null,null,null,null,null,null,""]
[94,null,null,null,null,null,null,""]
[95,null,null,null,null,null,null,""]
[96,null,null,null,null,null,null,""]
[97,null,null,null,null,null,null,""]
[98,null,null,null,null,null,null,""]
[99,null,null,null,null,null,null,""]
[100,null,null,null,null,null,null,""]
[101,null,null,null,null,null,null,""]
[102,null,null,null,null,null,null,""]
[103,null,null,null,null,null,null,""]
[104,null,null,null,null,null,null,""]
[105,null,null,null,null,null,null,""]
[106,null,null,null,null,null,null,""]
[107,null,null,null,null,null,null,""]
[108,null,null,null,null,null,null,""]
[109,null,null,null,null,null,null,""]
[110,null,null,null,null,null,null,""]
[111,null,null,null,null,null,null,""]
[112,null,null,null,null,null,null,""]
[113,null,null,null,null,null,null,{"$f":"IF(F322=\"\",\"\",F322-G322)","v":""}]
[114,null,null,null,null,null,null,""]
[115,null,null,null,null,null,null,""]
[116,null,null,null,null,null,null,""]
[117,null,null,null,null,null,null,""]
[118,null,null,null,null,null,null,""]
[119,null,null,null,null,null,null,""]
[120,null,null,null,null,null,null,""]
[121,null,null,null,null,null,null,""]
[122,null,null,null,null,null,null,""]
[123,null,null,null,null,null,null,""]
[124,null,null,null,null,null,null,""]
[125,null,null,null,null,null,null,""]
[126,null,null,null,null,null,null,""]
[127,null,null,null,null,null,null,""]
[128,null,null,null,null,null,null,""]
[129,null,null,null,null,null,null,""]
[130,null,null,null,null,null,null,""]
[131,null,null,null,null,null,null,""]
[132,null,null,null,null,null,null,""]
[133,null,null,null,null,null,null,""]
[134,null,null,null,null,null,null,""]
[135,null,null,null,null,null,null,""]
[136,null,null,null,null,null,null,""]
[137,null,null,null,null,null,null,""]
[138,null,null,null,null,null,null,""]
[139,null,null,null,null,null,null,""]
[140,null,null,null,null,null,null,""]
[141,null,null,null,null,null,null,""]
[142,null,null,null,null,null,null,""]
[143,null,null,null,null,null,null,""]
[144,null,null,null,null,null,null,""]
[145,null,null,null,null,null,null,""]
[146,null,null,null,null,null,null,""]
[147,null,null,null,null,null,null,""]
[148,null,null,null,null,null,null,{"$f":"IF(F357=\"\",\"\",F357-G357)","v":""}]
[149,null,null,null,null,null,null,{"$f":"IF(F358=\"\",\"\",F358-G358)","v":""}]
[150,null,null,null,null,null,null,{"$f":"IF(F359=\"\",\"\",F359-G359)","v":""}]
[151,null,null,null,null,null,null,{"$f":"IF(F360=\"\",\"\",F360-G360)","v":""}]
[152,null,null,null,null,null,null,{"$f":"IF(F361=\"\",\"\",F361-G361)","v":""}]
[153,null,null,null,null,null,null,{"$f":"IF(F362=\"\",\"\",F362-G362)","v":""}]
[154,null,null,null,null,null,null,""]
[155,null,null,null,null,null,null,""]
[156,null,null,null,null,null,null,""]
[157,null,null,null,null,null,null,""]
[158,null,null,null,null,null,null,""]
[159,null,null,null,null,null,null,""]
[160,null,null,null,null,null,null,""]
[161,null,null,null,null,null,null,""]
[162,null,null,null,null,null,null,""]
[163,null,null,null,null,null,null,""]
[164,null,null,null,null,null,null,""]
[156,null,null,null,null,null,null,{"$f":"IF(F374=\"\",\"\",F374-G374)","v":""}]
[157,null,null,null,null,null,null,""]
[158,null,null,null,null,null,null,""]
[159,null,null,null,null,null,null,""]
[160,null,null,null,null,null,null,""]
[161,null,null,null,null,null,null,""]
[162,null,null,null,null,null,null,""]
[163,null,null,null,null,null,null,""]
[164,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,1]