{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Blad1","index":0,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[{"$nulls":7},"Kosten verkrijgen in eigendom"]
[{"$nulls":15},{"$f":"IF(Q14>136570,\"Overschrijding van de kostengrens voor woonwagens \",\"\")","v":""}]
[{"$nulls":7},"Woonwagen en/of standplaats"]
[{"$nulls":15},{"$f":"IF(Q37>50000,\"Overschrijding van de kostengrens voor woonwagenstandplaatsen \",\"\")","v":""}]
[{"$nulls":7},"Norm 2.5 en 2.6"]
[]
[{"$nulls":15},"Koopsom of marktwaarde",{"$f":"MAX(IF(G14<G15,IF(G14+G24>G15,G15,G14+G24),G15))","v":45000}]
[{"$nulls":15},"MW na verb ex ebv + ebv+ebb",{"$f":"IF(G21>0,G17+G21+G22,G16+G22)","v":50000}]
[null,null,"Woonwagen: maximaal € 140.000,-",{"$nulls":12},"106% mw NA (incl EBV)",{"$f":"G16*1.06","v":53000}]
[{"$nulls":15},"kst verkr eigendom",{"$f":"I19+I23+G24","v":55120}]
[null,"A","Koopsom of aannemingssom incl. BTW",null,null,null,45000,{"$nulls":8},"laagste bedrag",{"$f":"MIN(Q13,IF(Q12>0,Q12,Q10),IF(Q11>0,Q11,Q10))","v":50000}]
[null,"B","Marktwaarde voor verbouwing",null,null,null,45000]
[null,null,"Marktwaarde na verbouwing (incl EBV)",null,null,null,50000]
[null,null,"Berekende martkwaarde excl EBV",null,null,null,{"$f":"IF(G14>0,G20/(G20+G21)*(G16-G15)+G15,0)","v":50000}]
[]
[{"$nulls":5},"Laagste van A of B",null,null,{"$f":"IF(G15<G14,G15,G14)","v":45000}]
[null,null,"Kosten meerwerk of kwaliteitsverbetering",null,null,null,7000]
[null,null,"Energiebesparend voorzieningen",null,null,null,0]
[null,null,"Energiebudget",null,null,null,0]
[{"$nulls":5},"Kosten ",null,null,{"$f":"G20+G21+G22","v":7000}]
[null,null,"Maximaal 6% bijkomende kosten",null,null,null,{"$f":"(I19+G20+G21)*6%","v":3120}]
[]
[null,null,"Kosten verkrijging woonwagen",null,null,null,{"$f":"I19+I23+I25","v":52000}]
[]
[null,null,"Maximale lening met NHG",{"$nulls":5},{"$f":"IF(Q14>140000,\"Niet mogelijk\",Q14)","v":50000}]
[]
[null,null,{"$f":"P5","v":""}]
[]
[]
[null,null,"Woonwagenstandplaats: maximaal € 51.000,-"]
[]
[null,null,"Koopsom grond",null,null,null,0,{"$nulls":8},"koopsom grond of marktwaarde",{"$f":"MAX(IF(G35<G36,IF(G35+G38>G36,G36,G35+G38),G36))","v":0}]
[null,null,"Marktwaarde",null,null,null,0,{"$nulls":8},"kst verkr eigendom",{"$f":"G40","v":0}]
[{"$nulls":8},{"$f":"MIN(G35:G36)","v":0},{"$nulls":6},"laagste bedrag",{"$f":"MIN(Q35,Q36)","v":0}]
[null,null,"Maximaal 6% bijkomende kosten",null,null,null,{"$f":"IF(G35<G36,G35*6%,G36*6%)","v":0}]
[]
[null,null,"Kosten verkrijging woonwagenstandplaats",null,null,null,{"$f":"IF(G36<G35,G36,G35)+G38","v":0}]
[]
[null,null,"Maximale lening met NHG",{"$nulls":5},{"$f":"IF(Q37>51000,\"Niet mogelijk\",Q37)","v":0}]
[]
[null,null,{"$f":"P7","v":""}]
{"$rows_empty":15}
[null,"versie 2019-1"]
[]
[{"$nulls":11},{"$f":"IF(I42>50000,\"Overschrijding van de kostengrens voor woonwagenstandplaatsen \",\"\")","v":""}]