{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Begroting","Jaartabel","Keuzelijsten","Liquiditeitsprognose"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Begroting","index":0,"n_rows":78,"n_cols":38,"rows_kept":78,"cut":false,"hidden":false,"merged":[[6,5,11,7],[78,1,83,5],[14,1,15,3],[20,1,20,2],[19,2,19,3],[17,1,17,2]]}
[null,null,{"$f":"Jaartabel!$G6","v":1},{"$f":"Jaartabel!$G7","v":1},{"$f":"Jaartabel!$G8","v":1},null,null,{"$f":"Jaartabel!$G9","v":1},{"$f":"Jaartabel!$G10","v":1},{"$f":"Jaartabel!$G11","v":1},{"$f":"Jaartabel!$G12","v":1},{"$f":"Jaartabel!$G13","v":1},{"$f":"Jaartabel!$G14","v":1},{"$f":"Jaartabel!$G15","v":1},{"$f":"Jaartabel!$G16","v":1},{"$f":"Jaartabel!$G17","v":1},{"$f":"Jaartabel!$G18","v":1},{"$f":"Jaartabel!$G19","v":1},{"$f":"Jaartabel!$G20","v":1},{"$f":"Jaartabel!$G21","v":1},{"$f":"Jaartabel!$G22","v":1},{"$f":"Jaartabel!$G23","v":1},{"$f":"Jaartabel!$G24","v":1},{"$f":"Jaartabel!$G25","v":1},{"$f":"Jaartabel!$G26","v":0},{"$f":"Jaartabel!$G27","v":0},{"$f":"Jaartabel!$G28","v":0},{"$f":"Jaartabel!$G29","v":0},{"$f":"Jaartabel!$G30","v":0},{"$f":"Jaartabel!$G31","v":0},{"$f":"Jaartabel!$G32","v":0},{"$f":"Jaartabel!$G33","v":0},{"$f":"Jaartabel!$G34","v":0},{"$f":"Jaartabel!$G35","v":0},{"$f":"Jaartabel!$G36","v":0},{"$f":"Jaartabel!$G37","v":0},{"$f":"Jaartabel!$G38","v":0},{"$f":"Jaartabel!$G39","v":0}]
[null,null,{"$f":"Jaartabel!$H6","v":1},{"$f":"Jaartabel!$H7","v":1},{"$f":"Jaartabel!$H8","v":1},null,null,{"$f":"Jaartabel!$H9","v":1},{"$f":"Jaartabel!$H10","v":1},{"$f":"Jaartabel!$H11","v":1},{"$f":"Jaartabel!$H12","v":1},{"$f":"Jaartabel!$H13","v":1},{"$f":"Jaartabel!$H14","v":1},{"$f":"Jaartabel!$H15","v":1},{"$f":"Jaartabel!$H16","v":1},{"$f":"Jaartabel!$H17","v":1},{"$f":"Jaartabel!$H18","v":1},{"$f":"Jaartabel!$H19","v":1},{"$f":"Jaartabel!$H20","v":1},{"$f":"Jaartabel!$H21","v":1},{"$f":"Jaartabel!$H22","v":1},{"$f":"Jaartabel!$H23","v":1},{"$f":"Jaartabel!$H24","v":1},{"$f":"Jaartabel!$H25","v":1},{"$f":"Jaartabel!$H26","v":0},{"$f":"Jaartabel!$H27","v":0},{"$f":"Jaartabel!$H28","v":0},{"$f":"Jaartabel!$H29","v":0},{"$f":"Jaartabel!$H30","v":0},{"$f":"Jaartabel!$H31","v":0},{"$f":"Jaartabel!$H32","v":0},{"$f":"Jaartabel!$H33","v":0},{"$f":"Jaartabel!$H34","v":0},{"$f":"Jaartabel!$H35","v":0},{"$f":"Jaartabel!$H36","v":0},{"$f":"Jaartabel!$H37","v":0},{"$f":"Jaartabel!$H38","v":0},{"$f":"Jaartabel!$H39","v":0}]
[]
[]
[]
[null,"SVn_18_1_2022"]
[null,"Bereken de rente en aflossing van uw VvE lening",null,null,null,"Dit Excelmodel is een handreiking voor het inzichtelijk maken van gevraagde informatie met betrekking tot uw aanvraag. Het Excelmodel is een berekening van algemene aard en kwalificeert niet als enige vorm van advies of aanbeveling. SVn heeft het Excelmodel en de hierin opgenomen formules zorgvuldig opgesteld, maar mogelijk kunnen het Excelmodel en/of de gehanteerde formules niet (meer) kloppen of voor u passend zijn.  "]
[null,"Hoofdsom lening",100000,{"$f":"IF( OR( C8=0, C8=\"\" ), \"LET OP: vul hiernaast een getal in.\", \"\" )","v":""}]
[null,"Looptijd (in maanden)",240,{"$f":"IF( OR( C9=0, C9=\"\" ), \"LET OP: kies hiernaast een looptijd.\", \"\" )","v":""}]
[null,"Aangeboden rente",0.04,{"$f":"IF( OR( C10=0, C10=\"\" ), \"LET OP: vul hiernaast een percentage groter dan 0 in.\", \"\" )","v":""}]
[null,"Rente & aflossing per maand",{"$f":"-PMT(C10/12,C9,C8)","v":605.98032929941871}]
[null,"Rente & aflossing per jaar",{"$f":"-PMT(C10/12,C9,C8)*12","v":7271.7639515930241}]
[]
[null,"Toelichting"]
[null,"In kolom C, D en E vult u een inschatting van de opbrengsten en kosten die uw VvE verwacht. \nIn kolom F is ruimte voor een eventuele toelichting."]
[]
[]
[null,"Vul de witte velden s.v.p. in en het tabblad 'Liquiditeitsprognose'."]
[null,{"$f":"IF(SUM(Liquiditeitsprognose!D17:G17)=0,\"Let op: vergeet niet het tabblad 'Liquiditeitsprognose te vullen\",\"\")","v":"Let op: vergeet niet het tabblad 'Liquiditeitsprognose te vullen"}]
[null,"Naam VvE"]
[null,"Aanvraagnummer (indien bekend)"]
[null,"Geschatte ingangsdatum lening en (eventuele) verhoging servicekosten",null,null,{"$f":"IF( OR( D22=0, D22=\"\" ), \"LET OP: vul hiernaast een ingangsdatum.\", \"\" )","v":"LET OP: vul hiernaast een ingangsdatum."}]
[null,{"$f":"CONCATENATE( \"Inflatiepercentage toepassen op inkomsten en kosten (vanaf \", D26+1, \").\")","v":"Inflatiepercentage toepassen op inkomsten en kosten (vanaf 2024)."}]
[null,"Exploitatieresultaat toevoegen aan reserve"]
[]
[null,"Omschrijving",{"$f":"YEAR(TODAY())","v":2022},{"$f":"C26+1","v":2023},{"$f":"D26+1","v":2024},"Toelichting",null,{"$f":"E26+1","v":2025},{"$f":"H26+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055]
[null,"Exploitatiebijdragen eigenaars tot ingang lening",0,0,{"$f":"D27*(1+$D$23)","v":0}]
[null,"Exploitatiebijdragen eigenaars na ingang lening",0,0,{"$f":"D28*(1+$D$23)","v":0},null,null,{"$f":"SUM(E27:E28)*(1+$D$23)","v":0},{"$f":"H28*(1+$D$23)","v":0},{"$f":"I28*(1+$D$23)","v":0},0,0,0,0,0,0,{"$f":"P28*(1+$D$23)*Q$1","v":0},0,0,{"$f":"S28*(1+$D$23)*T$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bedrag aan ontvangen rente op de spaarrekening",0,0,{"$f":"D29*(1+$D$23)","v":0},null,null,{"$f":"E29*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P29*(1+$D$23)*Q$1","v":0},0,0,{"$f":"S29*(1+$D$23)*T$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Vergoedingen en tegemoetkomingen",0,0,{"$f":"D30*(1+$D$23)","v":0},null,null,{"$f":"E30*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P30*(1+$D$23)*Q$1","v":0},0,0,{"$f":"S30*(1+$D$23)*T$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Overige inkomsten:",0,0,{"$f":"D31*(1+$D$23)","v":0},null,null,{"$f":"E31*(1+$D$23)","v":0},{"$f":"H31*(1+$D$23)","v":0},{"$f":"I31*(1+$D$23)","v":0},{"$f":"J31*(1+$D$23)","v":0},{"$f":"K31*(1+$D$23)","v":0},{"$f":"L31*(1+$D$23)","v":0},{"$f":"M31*(1+$D$23)","v":0},{"$f":"N31*(1+$D$23)","v":0},{"$f":"O31*(1+$D$23)","v":0},{"$f":"P31*(1+$D$23)*Q$1","v":0},0,0,{"$f":"S31*(1+$D$23)*T$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Overige inkomsten (zonder indexering):",0,0,{"$f":"D32","v":0},{"$f":"IF(SUM(C32:E32)>0,\"Toelichting verplicht\",\"\")","v":""},null,{"$f":"E32","v":0},{"$f":"H32","v":0},{"$f":"I32","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Totaal inkomsten",{"$f":"SUM(C27:C32)","v":0},{"$f":"SUM(D27:D32)","v":0},{"$f":"SUM(E27:E32)","v":0},null,null,{"$f":"SUM(H27:H32)","v":0},{"$f":"SUM(I27:I32)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R27:R32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AI27:AI32)","v":0},0,{"$f":"SUM(AK27:AK32)","v":0},0]
[]
[null,"Verzekeringen (totaal)",{"$f":"SUM(C36:C40)","v":0},{"$f":"SUM(D36:D40)","v":0},{"$f":"SUM(E36:E40)","v":0},null,null,{"$f":"SUM(H36:H40)","v":0},{"$f":"SUM(I36:I40)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R36:R40)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(AB36:AB40)","v":0},0,0,0,0,0,0,{"$f":"SUM(AI36:AI40)","v":0},{"$f":"SUM(AJ36:AJ40)","v":0},{"$f":"SUM(AK36:AK40)","v":0},0]
[null,"VvE Polis",0,0,{"$f":"D36*(1+$D$23)","v":0},null,null,{"$f":"E36*(1+$D$23)","v":0},{"$f":"H36*(1+$D$23)","v":0},{"$f":"I36*(1+$D$23)","v":0},0,0,0,0,0,0,{"$f":"P36*(1+$D$23)*Q$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,{"$f":"D37*(1+$D$23)","v":0},null,null,{"$f":"E37*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P37*(1+$D$23)*Q$1","v":0},{"$f":"Q37*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,{"$f":"D38*(1+$D$23)","v":0},null,null,{"$f":"E38*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P38*(1+$D$23)*Q$1","v":0},{"$f":"Q38*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,{"$f":"D39*(1+$D$23)","v":0},null,null,{"$f":"E39*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P39*(1+$D$23)*Q$1","v":0},{"$f":"Q39*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,{"$f":"D40*(1+$D$23)","v":0},null,null,{"$f":"E40*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P40*(1+$D$23)*Q$1","v":0},{"$f":"Q40*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Huisvestingskosten (totaal)",{"$f":"SUM(C42:C44)","v":0},{"$f":"SUM(D42:D44)","v":0},{"$f":"SUM(E42:E44)","v":0},null,null,{"$f":"SUM(H42:H44)","v":0},{"$f":"SUM(I42:I44)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R42:R44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AI42:AI44)","v":0},{"$f":"SUM(AJ42:AJ44)","v":0},{"$f":"SUM(AK42:AK44)","v":0},0]
[null,"Nuts voorzieningen Electra",0,0,{"$f":"D42*(1+$D$23)","v":0},null,null,{"$f":"E42*(1+$D$23)","v":0},{"$f":"H42*(1+$D$23)","v":0},0,0,0,0,0,0,0,{"$f":"P42*(1+$D$23)*Q$1","v":0},{"$f":"Q42*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Verbruik water",0,0,{"$f":"D43*(1+$D$23)","v":0},null,null,{"$f":"E43*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P43*(1+$D$23)*Q$1","v":0},{"$f":"Q43*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Overige kosten:",0,0,{"$f":"D44*(1+$D$23)","v":0},null,null,{"$f":"E44*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P44*(1+$D$23)*Q$1","v":0},{"$f":"Q44*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Dotatie reservefonds (totaal)",{"$f":"SUM(C46:C48)","v":0},{"$f":"SUM(D46:D48)","v":0},{"$f":"SUM(E46:E48)","v":0},null,null,{"$f":"SUM(H46:H48)","v":0},{"$f":"SUM(I46:I48)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R46:R48)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AI46:AI48)","v":0},{"$f":"SUM(AJ46:AJ48)","v":0},{"$f":"SUM(AK46:AK48)","v":0},0]
[null,"Woningen",0,0,{"$f":"D46*(1+$D$23)","v":0},null,null,{"$f":"E46*(1+$D$23)","v":0},{"$f":"H46*(1+$D$23)","v":0},0,0,0,0,0,0,0,{"$f":"P46*(1+$D$23)*Q$1","v":0},{"$f":"Q46*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Garages / overig",0,0,{"$f":"D47*(1+$D$23)","v":0},null,null,{"$f":"E47*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P47*(1+$D$23)*Q$1","v":0},{"$f":"Q47*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Overige dotaties:",0,0,{"$f":"D48*(1+$D$23)","v":0},null,null,{"$f":"E48*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P48*(1+$D$23)*Q$1","v":0},{"$f":"Q48*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Jaarlijkse onderhoudskosten (totaal)",{"$f":"SUM(C50:C58,C60)","v":0},{"$f":"SUM(D50:D58,D60)","v":0},{"$f":"SUM(E50:E58,E60)","v":0},null,null,{"$f":"SUM(H50:H60)","v":0},{"$f":"SUM(I50:I60)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R50:R60)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AI50:AI60)","v":0},0,{"$f":"SUM(AK50:AK60)","v":0},0]
[null,"Onderhoud groenvoorziening",0,0,{"$f":"D50*(1+$D$23)","v":0},null,null,{"$f":"E50*(1+$D$23)","v":0},{"$f":"H50*(1+$D$23)","v":0},0,0,0,0,0,0,0,{"$f":"P50*(1+$D$23)*Q$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Onderhoud klein onderhoud",0,0,0,null,null,0,0,0,0,0,0,0,0,0,{"$f":"P51*(1+$D$23)*Q$1","v":0},{"$f":"Q51*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Onderhoud garage ",0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"Q52*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Contract lift",0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"Q53*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Onderhoud lift +telefonie lift",0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"Q54*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Onderhoud schoonmaak",0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"Q55*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Onderhoud glasbewassing",0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"Q56*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Onderhoud CV",0,0,0,null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"Q57*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Reeds lopende leningen (niet-geïndexeerd)",0,0,{"$f":"D58","v":0},null,null,{"$f":"IF(COUNTBLANK($C59)=1,E58,IF(H26<=$C59,E58,0))","v":0},{"$f":"IF(COUNTBLANK($C59)=1,H58,IF(I26>$C59,0,H58))","v":0},{"$f":"IF(COUNTBLANK($C59)=1,I58,IF(J26>$C59,0,I58))","v":0},0,0,0,0,0,0,{"$f":"IF(COUNTBLANK($C59)=1,P58,IF(Q26>$C59,0,P58))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Jaar waarin lopende leningen eindigen"]
[null,"Overige kosten:",0,0,{"$f":"D60*(1+$D$23)","v":0},null,null,{"$f":"E60*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P60*(1+$D$23)*Q$1","v":0},{"$f":"Q60*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Administratiekosten (totaal)",{"$f":"SUM(C62:C63)","v":0},{"$f":"SUM(D62:D63)","v":0},{"$f":"SUM(E62:E63)","v":0},null,null,{"$f":"SUM(H62:H63)","v":0},{"$f":"SUM(I62:I63)","v":0},{"$f":"SUM(J62:J63)","v":0},0,0,0,0,0,0,{"$f":"SUM(Q62:Q63)","v":0},{"$f":"SUM(R62:R63)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Administratiekantoor",0,0,{"$f":"D62*(1+$D$23)","v":0},null,null,{"$f":"E62*(1+$D$23)","v":0},{"$f":"H62*(1+$D$23)","v":0},0,0,0,0,0,0,0,{"$f":"P62*(1+$D$23)*Q$1","v":0},{"$f":"Q62*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Overige kosten:",0,0,{"$f":"D63*(1+$D$23)","v":0},null,null,{"$f":"E63*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P63*(1+$D$23)*Q$1","v":0},{"$f":"Q63*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bestuurs- en diverse kosten (totaal)",{"$f":"SUM(C65:C67)","v":0},{"$f":"SUM(D65:D67)","v":0},{"$f":"SUM(E65:E67)","v":0},null,null,{"$f":"SUM(H65:H67)","v":0},{"$f":"SUM(I65:I67)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R65:R67)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bestuurskosten",0,0,{"$f":"D65*(1+$D$23)","v":0},null,null,{"$f":"E65*(1+$D$23)","v":0},{"$f":"H65*(1+$D$23)","v":0},0,0,0,0,0,0,0,{"$f":"P65*(1+$D$23)*Q$1","v":0},{"$f":"Q65*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Overige kosten:",0,0,{"$f":"D66*(1+$D$23)","v":0},null,null,{"$f":"E66*(1+$D$23)","v":0},{"$f":"H66*(1+$D$23)","v":0},{"$f":"I66*(1+$D$23)","v":0},{"$f":"J66*(1+$D$23)","v":0},{"$f":"K66*(1+$D$23)","v":0},{"$f":"L66*(1+$D$23)","v":0},{"$f":"M66*(1+$D$23)","v":0},{"$f":"N66*(1+$D$23)","v":0},{"$f":"O66*(1+$D$23)","v":0},{"$f":"P66*(1+$D$23)*Q$1","v":0},{"$f":"Q66*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Overige kosten (zonder indexering):",0,0,{"$f":"D67","v":0},{"$f":"IF(SUM(C67:E67)>0,\"Toelichting verplicht\",\"\")","v":""},null,{"$f":"E67","v":0},{"$f":"H67","v":0},{"$f":"I67","v":0},0,0,0,0,0,0,0,{"$f":"Q67","v":0},{"$f":"R67","v":0},{"$f":"S67","v":0},{"$f":"T67","v":0},{"$f":"U67","v":0},{"$f":"V67","v":0},{"$f":"W67","v":0},{"$f":"X67","v":0},{"$f":"Y67","v":0},{"$f":"Z67","v":0},{"$f":"AA67","v":0},{"$f":"AB67","v":0},{"$f":"AC67","v":0},{"$f":"AD67","v":0},{"$f":"AE67","v":0},{"$f":"AF67","v":0},{"$f":"AG67","v":0},{"$f":"AH67","v":0},{"$f":"AI67","v":0},{"$f":"AJ67","v":0},{"$f":"AK67","v":0}]
[null,"Kosten beheer (totaal)",{"$f":"SUM(C69:C70)","v":0},{"$f":"SUM(D69:D70)","v":0},{"$f":"SUM(E69:E70)","v":0},null,null,{"$f":"SUM(H69:H70)","v":0},{"$f":"SUM(I69:I70)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(R69:R70)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"VvE beheerder",0,0,{"$f":"D69*(1+$D$23)","v":0},null,null,{"$f":"E69*(1+$D$23)","v":0},{"$f":"H69*(1+$D$23)","v":0},0,0,0,0,0,0,0,{"$f":"P69*(1+$D$23)*Q$1","v":0},{"$f":"Q69*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Overige kosten:",0,0,{"$f":"D70*(1+$D$23)","v":0},null,null,{"$f":"E70*(1+$D$23)","v":0},0,0,0,0,0,0,0,0,{"$f":"P70*(1+$D$23)*Q$1","v":0},{"$f":"Q70*(1+$D$23)*R$1","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Aflossing + rente VvE lening",{"$f":"C2*$C12","v":7271.7639515930241},{"$f":"D2*$C12","v":7271.7639515930241},{"$f":"E2*$C12","v":7271.7639515930241},null,null,{"$f":"H2*$C12","v":7271.7639515930241},7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,{"$f":"Q2*$C12","v":7271.7639515930241},7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,0,0,0,{"$f":"AB2*$C12","v":0},{"$f":"AC2*$C12","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Totaal uitgaven",{"$f":"C35+C41+C49+C61+C64+C68+C71+C45","v":7271.7639515930241},{"$f":"D35+D41+D49+D61+D64+D68+D71+D45","v":7271.7639515930241},{"$f":"E35+E41+E49+E61+E64+E68+E71+E45","v":7271.7639515930241},null,null,{"$f":"H35+H41+H49+H61+H64+H68+H71+H45","v":7271.7639515930241},7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,7271.7639515930241,0,0,0,0,{"$f":"AC35+AC41+AC49+AC61+AC64+AC68+AC71+AC45","v":0},0,0,0,0,0,{"$f":"AI35+AI41+AI49+AI61+AI64+AI68+AI71+AI45","v":0},0,{"$f":"AK35+AK41+AK49+AK61+AK64+AK68+AK71+AK45","v":0},0]
[]
[null,"Exploitatiesaldo (incl. uitgave MJOP)",{"$f":"C33-C73","v":-7271.7639515930241},{"$f":"D33-D73","v":-7271.7639515930241},{"$f":"E33-E73","v":-7271.7639515930241},null,null,{"$f":"H33-H73","v":-7271.7639515930241},-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,-7271.7639515930241,0,0,0,0,0,0,0,0,0,0,{"$f":"AI33-AI73","v":0},0,{"$f":"AK33-AK73","v":0},0]
[null,"Check exploitatiesaldo",{"$f":"IF( $C8*$C9*$C10*$D22 = 0, \"Niet akkoord, vul cel C8, C9, C10 en D22\", IF( C75<0, \"De uitgaven zijn groter dan de inkomsten.\", \"Exploitatie OK\" ))","v":"Niet akkoord, vul cel C8, C9, C10 en D22"},{"$f":"IF( $C8*$C9*$C10*$D22 = 0, \"Niet akkoord, vul cel C8, C9, C10 en D22\", IF( D75<0, \"De uitgaven zijn groter dan de inkomsten.\", \"Exploitatie OK\" ))","v":"Niet akkoord, vul cel C8, C9, C10 en D22"},{"$f":"IF( $C8*$C9*$C10*$D22 = 0, \"Niet akkoord, vul cel C8, C9, C10 en D22\", IF( E75<0, \"De uitgaven zijn groter dan de inkomsten.\", \"Exploitatie OK\" ))","v":"Niet akkoord, vul cel C8, C9, C10 en D22"},null,null,{"$f":"IF( $C8*$C9*$C10*$D22 = 0, \"Niet akkoord, vul cel C8, C9, C10 en D22\", IF( H75<0, \"De uitgaven zijn groter dan de inkomsten.\", \"Exploitatie OK\" ))","v":"Niet akkoord, vul cel C8, C9, C10 en D22"},"Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22",{"$f":"IF( $C8*$C9*$C10*$D22 = 0, \"Niet akkoord, vul cel C8, C9, C10 en D22\", IF( AB75<0, \"De uitgaven zijn groter dan de inkomsten.\", \"Exploitatie OK\" ))","v":"Niet akkoord, vul cel C8, C9, C10 en D22"},"Niet akkoord, vul cel C8, C9, C10 en D22",{"$f":"IF( $C8*$C9*$C10*$D22 = 0, \"Niet akkoord, vul cel C8, C9, C10 en D22\", IF( AD75<0, \"De uitgaven zijn groter dan de inkomsten.\", \"Exploitatie OK\" ))","v":"Niet akkoord, vul cel C8, C9, C10 en D22"},"Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22","Niet akkoord, vul cel C8, C9, C10 en D22"]
[]
[null,"Bijzonderheden"]

{"sheet":"Jaartabel","index":1,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Ingangsdatum",{"$f":"Begroting!D22","v":"00:00:00"}]
[]
[null,"Kalenderjaar","Jaar ja/nee","Maanden","Looptijd","Laatste jaar","Dummy jaar"]
[null,"Leeglaten"]
[null,{"$f":"Begroting!C26","v":2022},{"$f":"IF(B6>=YEAR(C$2),1,0)","v":1},{"$f":"IF(C6=0,0,IF(SUM(C5:C6)=1,13-MONTH(C$2),12))","v":12},{"$f":"MIN(SUM(D$6:D6),Begroting!C$9)","v":12},{"$f":"IF(AND(E6=Begroting!C$9,Jaartabel!E6<>Jaartabel!E5),1,0)","v":0},{"$f":"IF(C6=0,0,IF(SUM(F$5:F5)=1,0,1))","v":1},{"$f":"G6*(E6-E5)/12","v":1}]
[null,{"$f":"B6+1","v":2023},{"$f":"IF(B7>=YEAR(C$2),1,0)","v":1},{"$f":"IF(C7=0,0,IF(SUM(C6:C7)=1,13-MONTH(C$2),12))","v":12},{"$f":"MIN(SUM(D$6:D7),Begroting!C$9)","v":24},{"$f":"IF(AND(E7=Begroting!C$9,Jaartabel!E7<>Jaartabel!E6),1,0)","v":0},{"$f":"IF(C7=0,0,IF(SUM(F$5:F6)=1,0,1))","v":1},{"$f":"G7*(E7-E6)/12","v":1}]
[null,{"$f":"B7+1","v":2024},{"$f":"IF(B8>=YEAR(C$2),1,0)","v":1},{"$f":"IF(C8=0,0,IF(SUM(C7:C8)=1,13-MONTH(C$2),12))","v":12},{"$f":"MIN(SUM(D$6:D8),Begroting!C$9)","v":36},{"$f":"IF(AND(E8=Begroting!C$9,Jaartabel!E8<>Jaartabel!E7),1,0)","v":0},{"$f":"IF(C8=0,0,IF(SUM(F$5:F7)=1,0,1))","v":1},1]
[null,2025,1,12,{"$f":"MIN(SUM(D$6:D9),Begroting!C$9)","v":48},{"$f":"IF(AND(E9=Begroting!C$9,Jaartabel!E9<>Jaartabel!E8),1,0)","v":0},{"$f":"IF(C9=0,0,IF(SUM(F$5:F8)=1,0,1))","v":1},1]
[null,2026,1,12,{"$f":"MIN(SUM(D$6:D10),Begroting!C$9)","v":60},{"$f":"IF(AND(E10=Begroting!C$9,Jaartabel!E10<>Jaartabel!E9),1,0)","v":0},{"$f":"IF(C10=0,0,IF(SUM(F$5:F9)=1,0,1))","v":1},1]
[null,2027,1,12,{"$f":"MIN(SUM(D$6:D11),Begroting!C$9)","v":72},{"$f":"IF(AND(E11=Begroting!C$9,Jaartabel!E11<>Jaartabel!E10),1,0)","v":0},{"$f":"IF(C11=0,0,IF(SUM(F$5:F10)=1,0,1))","v":1},1]
[null,2028,1,12,{"$f":"MIN(SUM(D$6:D12),Begroting!C$9)","v":84},{"$f":"IF(AND(E12=Begroting!C$9,Jaartabel!E12<>Jaartabel!E11),1,0)","v":0},{"$f":"IF(C12=0,0,IF(SUM(F$5:F11)=1,0,1))","v":1},1]
[null,2029,1,12,{"$f":"MIN(SUM(D$6:D13),Begroting!C$9)","v":96},{"$f":"IF(AND(E13=Begroting!C$9,Jaartabel!E13<>Jaartabel!E12),1,0)","v":0},{"$f":"IF(C13=0,0,IF(SUM(F$5:F12)=1,0,1))","v":1},1]
[null,2030,1,12,{"$f":"MIN(SUM(D$6:D14),Begroting!C$9)","v":108},{"$f":"IF(AND(E14=Begroting!C$9,Jaartabel!E14<>Jaartabel!E13),1,0)","v":0},{"$f":"IF(C14=0,0,IF(SUM(F$5:F13)=1,0,1))","v":1},1]
[null,2031,1,12,{"$f":"MIN(SUM(D$6:D15),Begroting!C$9)","v":120},{"$f":"IF(AND(E15=Begroting!C$9,Jaartabel!E15<>Jaartabel!E14),1,0)","v":0},{"$f":"IF(C15=0,0,IF(SUM(F$5:F14)=1,0,1))","v":1},1]
[null,2032,1,12,{"$f":"MIN(SUM(D$6:D16),Begroting!C$9)","v":132},{"$f":"IF(AND(E16=Begroting!C$9,Jaartabel!E16<>Jaartabel!E15),1,0)","v":0},{"$f":"IF(C16=0,0,IF(SUM(F$5:F15)=1,0,1))","v":1},1]
[null,2033,1,12,{"$f":"MIN(SUM(D$6:D17),Begroting!C$9)","v":144},{"$f":"IF(AND(E17=Begroting!C$9,Jaartabel!E17<>Jaartabel!E16),1,0)","v":0},{"$f":"IF(C17=0,0,IF(SUM(F$5:F16)=1,0,1))","v":1},1]
[null,2034,1,12,{"$f":"MIN(SUM(D$6:D18),Begroting!C$9)","v":156},{"$f":"IF(AND(E18=Begroting!C$9,Jaartabel!E18<>Jaartabel!E17),1,0)","v":0},{"$f":"IF(C18=0,0,IF(SUM(F$5:F17)=1,0,1))","v":1},1]
[null,2035,1,12,{"$f":"MIN(SUM(D$6:D19),Begroting!C$9)","v":168},{"$f":"IF(AND(E19=Begroting!C$9,Jaartabel!E19<>Jaartabel!E18),1,0)","v":0},{"$f":"IF(C19=0,0,IF(SUM(F$5:F18)=1,0,1))","v":1},1]
[null,2036,1,12,{"$f":"MIN(SUM(D$6:D20),Begroting!C$9)","v":180},{"$f":"IF(AND(E20=Begroting!C$9,Jaartabel!E20<>Jaartabel!E19),1,0)","v":0},{"$f":"IF(C20=0,0,IF(SUM(F$5:F19)=1,0,1))","v":1},1]
[null,2037,1,12,{"$f":"MIN(SUM(D$6:D21),Begroting!C$9)","v":192},{"$f":"IF(AND(E21=Begroting!C$9,Jaartabel!E21<>Jaartabel!E20),1,0)","v":0},{"$f":"IF(C21=0,0,IF(SUM(F$5:F20)=1,0,1))","v":1},1]
[null,2038,1,12,{"$f":"MIN(SUM(D$6:D22),Begroting!C$9)","v":204},{"$f":"IF(AND(E22=Begroting!C$9,Jaartabel!E22<>Jaartabel!E21),1,0)","v":0},{"$f":"IF(C22=0,0,IF(SUM(F$5:F21)=1,0,1))","v":1},1]
[null,2039,1,12,{"$f":"MIN(SUM(D$6:D23),Begroting!C$9)","v":216},{"$f":"IF(AND(E23=Begroting!C$9,Jaartabel!E23<>Jaartabel!E22),1,0)","v":0},{"$f":"IF(C23=0,0,IF(SUM(F$5:F22)=1,0,1))","v":1},1]
[null,2040,1,12,{"$f":"MIN(SUM(D$6:D24),Begroting!C$9)","v":228},{"$f":"IF(AND(E24=Begroting!C$9,Jaartabel!E24<>Jaartabel!E23),1,0)","v":0},{"$f":"IF(C24=0,0,IF(SUM(F$5:F23)=1,0,1))","v":1},1]
[null,2041,1,12,{"$f":"MIN(SUM(D$6:D25),Begroting!C$9)","v":240},{"$f":"IF(AND(E25=Begroting!C$9,Jaartabel!E25<>Jaartabel!E24),1,0)","v":1},{"$f":"IF(C25=0,0,IF(SUM(F$5:F24)=1,0,1))","v":1},1]
[null,2042,1,12,{"$f":"MIN(SUM(D$6:D26),Begroting!C$9)","v":240},{"$f":"IF(AND(E26=Begroting!C$9,Jaartabel!E26<>Jaartabel!E25),1,0)","v":0},{"$f":"IF(C26=0,0,IF(SUM(F$5:F25)=1,0,1))","v":0},0]
[null,2043,1,12,{"$f":"MIN(SUM(D$6:D27),Begroting!C$9)","v":240},{"$f":"IF(AND(E27=Begroting!C$9,Jaartabel!E27<>Jaartabel!E26),1,0)","v":0},{"$f":"IF(C27=0,0,IF(SUM(F$5:F26)=1,0,1))","v":0},0]
[null,2044,1,12,{"$f":"MIN(SUM(D$6:D28),Begroting!C$9)","v":240},{"$f":"IF(AND(E28=Begroting!C$9,Jaartabel!E28<>Jaartabel!E27),1,0)","v":0},{"$f":"IF(C28=0,0,IF(SUM(F$5:F27)=1,0,1))","v":0},0]
[null,2045,1,12,{"$f":"MIN(SUM(D$6:D29),Begroting!C$9)","v":240},{"$f":"IF(AND(E29=Begroting!C$9,Jaartabel!E29<>Jaartabel!E28),1,0)","v":0},{"$f":"IF(C29=0,0,IF(SUM(F$5:F28)=1,0,1))","v":0},0]
[null,2046,1,12,{"$f":"MIN(SUM(D$6:D30),Begroting!C$9)","v":240},{"$f":"IF(AND(E30=Begroting!C$9,Jaartabel!E30<>Jaartabel!E29),1,0)","v":0},{"$f":"IF(C30=0,0,IF(SUM(F$5:F29)=1,0,1))","v":0},0]
[null,2047,1,12,{"$f":"MIN(SUM(D$6:D31),Begroting!C$9)","v":240},{"$f":"IF(AND(E31=Begroting!C$9,Jaartabel!E31<>Jaartabel!E30),1,0)","v":0},{"$f":"IF(C31=0,0,IF(SUM(F$5:F30)=1,0,1))","v":0},0]
[null,2048,1,12,{"$f":"MIN(SUM(D$6:D32),Begroting!C$9)","v":240},{"$f":"IF(AND(E32=Begroting!C$9,Jaartabel!E32<>Jaartabel!E31),1,0)","v":0},{"$f":"IF(C32=0,0,IF(SUM(F$5:F31)=1,0,1))","v":0},0]
[null,2049,1,12,{"$f":"MIN(SUM(D$6:D33),Begroting!C$9)","v":240},{"$f":"IF(AND(E33=Begroting!C$9,Jaartabel!E33<>Jaartabel!E32),1,0)","v":0},{"$f":"IF(C33=0,0,IF(SUM(F$5:F32)=1,0,1))","v":0},0]
[null,2050,1,12,{"$f":"MIN(SUM(D$6:D34),Begroting!C$9)","v":240},{"$f":"IF(AND(E34=Begroting!C$9,Jaartabel!E34<>Jaartabel!E33),1,0)","v":0},{"$f":"IF(C34=0,0,IF(SUM(F$5:F33)=1,0,1))","v":0},0]
[null,2051,1,12,{"$f":"MIN(SUM(D$6:D35),Begroting!C$9)","v":240},{"$f":"IF(AND(E35=Begroting!C$9,Jaartabel!E35<>Jaartabel!E34),1,0)","v":0},{"$f":"IF(C35=0,0,IF(SUM(F$5:F34)=1,0,1))","v":0},0]
[null,2052,1,12,{"$f":"MIN(SUM(D$6:D36),Begroting!C$9)","v":240},{"$f":"IF(AND(E36=Begroting!C$9,Jaartabel!E36<>Jaartabel!E35),1,0)","v":0},{"$f":"IF(C36=0,0,IF(SUM(F$5:F35)=1,0,1))","v":0},0]
[null,{"$f":"B36+1","v":2053},1,12,{"$f":"MIN(SUM(D$6:D37),Begroting!C$9)","v":240},{"$f":"IF(AND(E37=Begroting!C$9,Jaartabel!E37<>Jaartabel!E36),1,0)","v":0},{"$f":"IF(C37=0,0,IF(SUM(F$5:F36)=1,0,1))","v":0},0]
[null,2054,1,12,{"$f":"MIN(SUM(D$6:D38),Begroting!C$9)","v":240},{"$f":"IF(AND(E38=Begroting!C$9,Jaartabel!E38<>Jaartabel!E37),1,0)","v":0},{"$f":"IF(C38=0,0,IF(SUM(F$5:F37)=1,0,1))","v":0},0]
[null,{"$f":"B38+1","v":2055},1,12,{"$f":"MIN(SUM(D$6:D39),Begroting!C$9)","v":240},{"$f":"IF(AND(E39=Begroting!C$9,Jaartabel!E39<>Jaartabel!E38),1,0)","v":0},{"$f":"IF(C39=0,0,IF(SUM(F$5:F38)=1,0,1))","v":0},0]

{"sheet":"Keuzelijsten","index":2,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Keuzelijsten"]
[null,"Looptijd"]
[null,120]
[null,180]
[null,240]
[null,360]
[]
[null,"ja/nee"]
[null,"ja"]
[null,"nee"]
[]
[null,"Inflatie"]
[null,0]
[null,0.01]
[null,0.02]
[null,0.03]
[null,0.04]
[null,0.05]
[null,0.06]
[null,7.0000000000000007E-2]
[null,0.08]
[null,0.09]
[null,0.1]
[]
[null,"Datum"]
[null,"2019-01-01"]

{"sheet":"Liquiditeitsprognose","index":3,"n_rows":30,"n_cols":36,"rows_kept":30,"cut":false,"hidden":false,"merged":[[30,1,35,2]]}
[null,null,null,{"$f":"Begroting!C1","v":1},{"$f":"Begroting!D1","v":1},{"$f":"Begroting!E1","v":1},{"$f":"Begroting!H1","v":1},{"$f":"Begroting!I1","v":1},{"$f":"Begroting!J1","v":1},{"$f":"Begroting!K1","v":1},{"$f":"Begroting!L1","v":1},{"$f":"Begroting!M1","v":1},{"$f":"Begroting!N1","v":1},{"$f":"Begroting!O1","v":1},{"$f":"Begroting!P1","v":1},{"$f":"Begroting!Q1","v":1},{"$f":"Begroting!R1","v":1},{"$f":"Begroting!S1","v":1},{"$f":"Begroting!T1","v":1},{"$f":"Begroting!U1","v":1},{"$f":"Begroting!V1","v":1},{"$f":"Begroting!W1","v":1},{"$f":"Begroting!X1","v":1},{"$f":"Begroting!Y1","v":0},{"$f":"Begroting!Z1","v":0},{"$f":"Begroting!AA1","v":0},{"$f":"Begroting!AB1","v":0},{"$f":"Begroting!AC1","v":0},{"$f":"Begroting!AD1","v":0},{"$f":"Begroting!AE1","v":0},{"$f":"Begroting!AF1","v":0},{"$f":"Begroting!AG1","v":0},{"$f":"Begroting!AH1","v":0},{"$f":"Begroting!AI1","v":0},{"$f":"Begroting!AJ1","v":0},{"$f":"Begroting!AK1","v":0}]
[null,null,null,1,1,1,{"$f":"VLOOKUP(G15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(H15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(I15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(J15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(K15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(L15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(M15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(N15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(O15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(P15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(Q15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(R15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(S15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(T15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(U15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(V15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(W15,Jaartabel!$B$6:$G$39,6,FALSE)","v":1},{"$f":"VLOOKUP(X15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(Y15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(Z15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(AA15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(AB15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(AC15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(AD15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(AE15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(AF15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(AG15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(AH15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(AI15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0},{"$f":"VLOOKUP(AJ15,Jaartabel!$B$6:$G$39,6,FALSE)","v":0}]
[null,{"$f":"Begroting!B6","v":"SVn_18_1_2022"}]
[null,"Vul de witte velden s.v.p. in."]
[]
[null,"Uitgaven MJOP en inflatie"]
[null,"Vult u onder 'Uitgaven MJOP' (regel 18) de bedragen inclusief inflatie in?",null,"ja"]
[null,{"$f":"IF(D7=\"nee\",\"Zo nee, wilt u dat over de 'Uitgaven MJOP' (regel 17) inflatie wordt berekend?\",\"N.v.t.\")","v":"N.v.t."},null,"nee"]
[null,{"$f":"IF( D7=\"ja\", \"N.v.t.\", IF(D8 =\"nee\", \"Het MJOP wordt wel verhoogd met het inflatiepercentage uit tabblad 'Begroting'.\", \"Vul het gewenste inflatiepercentage in.\" ))","v":"N.v.t."},null,0.01]
[null,{"$f":"IF(D7=\"ja\",\"De 'Uitgaven MJOP' zijn reeds verhoogd met inflatie.\",IF(D9<Begroting!D23,\"Het MJOP wordt minimaal verhoogd met het inflatiepercentage uit tabblad 'Begroting'.\",\"Het MJOP wordt  verhoogd met het opgegeven inflatiepercentage.\"))","v":"De 'Uitgaven MJOP' zijn reeds verhoogd met inflatie."},null,{"$f":"IF(D7=\"nee\",MAX(D9,Begroting!D23),0)","v":0}]
[]
[null,null,"Jaar",1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32]
[null,null,"Inflatiefactor MJOP",{"$f":"IF($D7=\"ja\",1,(1+$D10)^(D12-1))","v":1},{"$f":"IF($D7=\"ja\",1,(1+$D10)^(E12-1))","v":1},{"$f":"IF($D7=\"ja\",1,(1+$D10)^(F12-1))","v":1},{"$f":"IF($D7=\"ja\",1,(1+$D10)^(G12-1))","v":1},{"$f":"IF($D7=\"ja\",1,(1+$D10)^(H12-1))","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"IF($D7=\"ja\",1,(1+$D10)^(AG12-1))","v":1},1,1,1]
[null,null,"Uitgaven MJOP (na inflatie)",{"$f":"D18*D13","v":0},{"$f":"E18*E13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AG18*AG13","v":0},{"$f":"AH18*AH13","v":0},0,0]
[null,"Omschrijving","Invulinstructie en toelichting",{"$f":"E15-1","v":2022},{"$f":"Begroting!D26","v":2023},{"$f":"E15+1","v":2024},2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,{"$f":"S15+1","v":2038},2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,{"$f":"AE15+1","v":2050},{"$f":"AF15+1","v":2051},{"$f":"AG15+1","v":2052},{"$f":"AH15+1","v":2053},{"$f":"AI15+1","v":2054}]
[null,"Totale reserves",{"$f":"CONCATENATE(\"Vul de stand van de reserves per 31-12-\",D15-1,\".\")","v":"Vul de stand van de reserves per 31-12-2021."},6000,{"$f":"D25","v":6000},{"$f":"E25","v":6000},{"$f":"F25","v":6000},6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,{"$f":"S25","v":6000},{"$f":"T25","v":6000},{"$f":"U25","v":6000},{"$f":"V25","v":6000},{"$f":"W25","v":6000},{"$f":"X25","v":6000},{"$f":"Y25","v":6000},{"$f":"Z25","v":6000},{"$f":"AA25","v":6000},{"$f":"AB25","v":6000},{"$f":"AC25","v":6000},{"$f":"AD25","v":6000},{"$f":"AE25","v":6000},{"$f":"AF25","v":6000},{"$f":"AG25","v":6000},{"$f":"AH25","v":6000},{"$f":"AI25","v":6000}]
[null,"Uitgaven project verduurzaming","Dit moet minimaal gelijk zijn aan de VvE lening.",0,0,0,0]
[null,"Uitgaven MJOP","Vul per kalenderjaar de uitgaven uit het MJOP in.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Uitgaven MJOP (na inflatie)","Dit zijn de uitgaven inclusief inflatie.",{"$f":"D14","v":0},0,{"$f":"F14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AF14","v":0},0,0,0,0]
[null,"VvE lening","Wordt gevuld vanuit tabblad 'Begroting'.",{"$f":"IF(D15=YEAR(Begroting!$D22),Begroting!$C8,0)","v":0},{"$f":"IF(E15=YEAR(Begroting!$D22),Begroting!$C8,0)","v":0},{"$f":"IF(F15=YEAR(Begroting!$D22),Begroting!$C8,0)","v":0}]
[null,"Subsidie","Handmatig invullen indien van toepassing.",0,0]
[null,"Dotatie","Wordt gevuld vanuit tabblad 'Begroting'.",{"$f":"Begroting!C45","v":0},{"$f":"Begroting!D45","v":0},{"$f":"Begroting!E45","v":0},{"$f":"Begroting!H45","v":0},{"$f":"Begroting!I45","v":0},{"$f":"Begroting!J45","v":0},{"$f":"Begroting!K45","v":0},{"$f":"Begroting!L45","v":0},{"$f":"Begroting!M45","v":0},{"$f":"Begroting!N45","v":0},{"$f":"Begroting!O45","v":0},{"$f":"Begroting!P45","v":0},{"$f":"Begroting!Q45","v":0},{"$f":"Begroting!R45","v":0},{"$f":"Begroting!S45","v":0},{"$f":"Begroting!T45","v":0},{"$f":"Begroting!U45","v":0},{"$f":"Begroting!V45","v":0},{"$f":"Begroting!W45","v":0},{"$f":"Begroting!X45","v":0},{"$f":"Begroting!Y45","v":0},{"$f":"Begroting!Z45","v":0},{"$f":"Begroting!AA45","v":0},{"$f":"Begroting!AB45","v":0},{"$f":"Begroting!AC45","v":0},{"$f":"Begroting!AD45","v":0},{"$f":"Begroting!AE45","v":0},{"$f":"Begroting!AF45","v":0},{"$f":"Begroting!AG45","v":0},{"$f":"Begroting!AH45","v":0},{"$f":"Begroting!AI45","v":0},{"$f":"Begroting!AJ45","v":0},{"$f":"Begroting!AK45","v":0}]
[null,"Eenmalige extra inleg","Optioneel: vul extra inleg in.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Exploitatiesaldo","Wordt gevuld vanuit tabblad 'Begroting'.",{"$f":"Begroting!C75","v":-7271.7639515930241},{"$f":"Begroting!D75","v":-7271.7639515930241},{"$f":"Begroting!E75","v":-7271.7639515930241},{"$f":"Begroting!H75","v":-7271.7639515930241},{"$f":"Begroting!I75","v":-7271.7639515930241},{"$f":"Begroting!J75","v":-7271.7639515930241},{"$f":"Begroting!K75","v":-7271.7639515930241},{"$f":"Begroting!L75","v":-7271.7639515930241},{"$f":"Begroting!M75","v":-7271.7639515930241},{"$f":"Begroting!N75","v":-7271.7639515930241},{"$f":"Begroting!O75","v":-7271.7639515930241},{"$f":"Begroting!P75","v":-7271.7639515930241},{"$f":"Begroting!Q75","v":-7271.7639515930241},{"$f":"Begroting!R75","v":-7271.7639515930241},{"$f":"Begroting!S75","v":-7271.7639515930241},{"$f":"Begroting!T75","v":-7271.7639515930241},{"$f":"Begroting!U75","v":-7271.7639515930241},{"$f":"Begroting!V75","v":-7271.7639515930241},{"$f":"Begroting!W75","v":-7271.7639515930241},{"$f":"Begroting!X75","v":-7271.7639515930241},{"$f":"Begroting!Y75","v":0},{"$f":"Begroting!Z75","v":0},{"$f":"Begroting!AA75","v":0},{"$f":"Begroting!AB75","v":0},{"$f":"Begroting!AC75","v":0},{"$f":"Begroting!AD75","v":0},{"$f":"Begroting!AE75","v":0},{"$f":"Begroting!AF75","v":0},{"$f":"Begroting!AG75","v":0},{"$f":"Begroting!AH75","v":0},{"$f":"Begroting!AI75","v":0},{"$f":"Begroting!AJ75","v":0},{"$f":"Begroting!AK75","v":0}]
[null,"Totaal reserves","Dit is het saldo van de reserves per einde kalenderjaar",{"$f":"SUM(D16-D17-D19+D20+D21+D22+D23+IF(Begroting!$D24=\"ja\",D24,0))","v":6000},{"$f":"SUM(E16-E17-E19+E20+E21+E22+E23+IF(Begroting!$D24=\"ja\",E24,0))","v":6000},{"$f":"SUM(F16-F17-F19+F20+F21+F22+F23+IF(Begroting!$D24=\"ja\",F24,0))","v":6000},{"$f":"SUM(G16-G17-G19+G20+G21+G22+G23+IF(Begroting!$D24=\"ja\",G24,0))","v":6000},{"$f":"SUM(H16-H17-H19+H20+H21+H22+H23+IF(Begroting!$D24=\"ja\",H24,0))","v":6000},{"$f":"SUM(I16-I17-I19+I20+I21+I22+I23+IF(Begroting!$D24=\"ja\",I24,0))","v":6000},{"$f":"SUM(J16-J17-J19+J20+J21+J22+J23+IF(Begroting!$D24=\"ja\",J24,0))","v":6000},{"$f":"SUM(K16-K17-K19+K20+K21+K22+K23+IF(Begroting!$D24=\"ja\",K24,0))","v":6000},{"$f":"SUM(L16-L17-L19+L20+L21+L22+L23+IF(Begroting!$D24=\"ja\",L24,0))","v":6000},{"$f":"SUM(M16-M17-M19+M20+M21+M22+M23+IF(Begroting!$D24=\"ja\",M24,0))","v":6000},{"$f":"SUM(N16-N17-N19+N20+N21+N22+N23+IF(Begroting!$D24=\"ja\",N24,0))","v":6000},{"$f":"SUM(O16-O17-O19+O20+O21+O22+O23+IF(Begroting!$D24=\"ja\",O24,0))","v":6000},{"$f":"SUM(P16-P17-P19+P20+P21+P22+P23+IF(Begroting!$D24=\"ja\",P24,0))","v":6000},{"$f":"SUM(Q16-Q17-Q19+Q20+Q21+Q22+Q23+IF(Begroting!$D24=\"ja\",Q24,0))","v":6000},{"$f":"SUM(R16-R17-R19+R20+R21+R22+R23+IF(Begroting!$D24=\"ja\",R24,0))","v":6000},{"$f":"SUM(S16-S17-S19+S20+S21+S22+S23+IF(Begroting!$D24=\"ja\",S24,0))","v":6000},{"$f":"SUM(T16-T17-T19+T20+T21+T22+T23+IF(Begroting!$D24=\"ja\",T24,0))","v":6000},{"$f":"SUM(U16-U17-U19+U20+U21+U22+U23+IF(Begroting!$D24=\"ja\",U24,0))","v":6000},{"$f":"SUM(V16-V17-V19+V20+V21+V22+V23+IF(Begroting!$D24=\"ja\",V24,0))","v":6000},{"$f":"SUM(W16-W17-W19+W20+W21+W22+W23+IF(Begroting!$D24=\"ja\",W24,0))","v":6000},{"$f":"SUM(X16-X17-X19+X20+X21+X22+X23+IF(Begroting!$D24=\"ja\",X24,0))","v":6000},{"$f":"SUM(Y16-Y17-Y19+Y20+Y21+Y22+Y23+IF(Begroting!$D24=\"ja\",Y24,0))","v":6000},{"$f":"SUM(Z16-Z17-Z19+Z20+Z21+Z22+Z23+IF(Begroting!$D24=\"ja\",Z24,0))","v":6000},{"$f":"SUM(AA16-AA17-AA19+AA20+AA21+AA22+AA23+IF(Begroting!$D24=\"ja\",AA24,0))","v":6000},{"$f":"SUM(AB16-AB17-AB19+AB20+AB21+AB22+AB23+IF(Begroting!$D24=\"ja\",AB24,0))","v":6000},{"$f":"SUM(AC16-AC17-AC19+AC20+AC21+AC22+AC23+IF(Begroting!$D24=\"ja\",AC24,0))","v":6000},{"$f":"SUM(AD16-AD17-AD19+AD20+AD21+AD22+AD23+IF(Begroting!$D24=\"ja\",AD24,0))","v":6000},{"$f":"SUM(AE16-AE17-AE19+AE20+AE21+AE22+AE23+IF(Begroting!$D24=\"ja\",AE24,0))","v":6000},{"$f":"SUM(AF16-AF17-AF19+AF20+AF21+AF22+AF23+IF(Begroting!$D24=\"ja\",AF24,0))","v":6000},{"$f":"SUM(AG16-AG17-AG19+AG20+AG21+AG22+AG23+IF(Begroting!$D24=\"ja\",AG24,0))","v":6000},{"$f":"SUM(AH16-AH17-AH19+AH20+AH21+AH22+AH23+IF(Begroting!$D24=\"ja\",AH24,0))","v":6000},{"$f":"SUM(AI16-AI17-AI19+AI20+AI21+AI22+AI23+IF(Begroting!$D24=\"ja\",AI24,0))","v":6000},{"$f":"SUM(AJ16-AJ17-AJ19+AJ20+AJ21+AJ22+AJ23+IF(Begroting!$D24=\"ja\",AJ24,0))","v":6000}]
[null,"Rekenregel",null,{"$f":"D2*D25","v":6000},{"$f":"E2*E25","v":6000},{"$f":"F2*F25","v":6000},6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,6000,0,{"$f":"Y2*Y25","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Check reserves",{"$f":"IF(Begroting!C9=120,IF(COUNTIF(D26:N26,\"<\"&0)>0,\"Aanpassing vereist: de reserves zijn niet elk jaar positief.\",\"Saldo reserves is elk jaar positief.\"),\nIF(Begroting!C9=180,IF(COUNTIF(D26:S26,\"<\"&0)>0,\"Aanpassing vereist: de reserves zijn niet elk jaar positief.\",\"Saldo reserves is elk jaar positief.\"),\nIF(Begroting!C9=240,IF(COUNTIF(D26:X26,\"<\"&0)>0,\"Aanpassing vereist: de reserves zijn niet elk jaar positief.\",\"Saldo reserves is elk jaar positief.\"),\nIF(Begroting!C9=360,IF(COUNTIF(D26:AH26,\"<\"&Begroting!D71)>0,\"Aanpassing vereist: de reserves zijn niet elk jaar voldoende positief (minimumreserve = jaarlast van de lening).\",\"Saldo reserves is elk jaar positief.\")))))","v":"Saldo reserves is elk jaar positief."}]
[null,"Check lening",{"$f":" IF( SUM(D17:G17) < Begroting!C8, \"Het totaal van D17 tm G17 moet minimaal gelijk zijn aan de hoofdsom van de VvE lening.\", \" \" )","v":"Het totaal van D17 tm G17 moet minimaal gelijk zijn aan de hoofdsom van de VvE lening."}]
[]
[null,"Bijzonderheden/toelichting"]