{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cum.Rente","Formules","Waarden"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Cum.Rente","index":0,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Wk #","Totale Inleg","Rente/wk","Rente","Cum. Rente","Eff. Rente%",null,"ResultaatDrempel(inleg,weekrente,drempel,looptijd)"]
[{"$f":"ROW()-ROW($A$2)+1","v":1},{"$f":"10000","v":10000},{"$f":"0.12%","v":1.1999999999999999E-3},{"$f":"B2*C2","v":11.999999999999998},{"$f":"D2","v":11.999999999999998},{"$f":"(B2-B$2)/B$2","v":0},null,"resultaat=inleg"]
[2,{"$f":"B2+(E2>=25)*E2","v":10000},{"$f":"C$2","v":1.1999999999999999E-3},{"$f":"B3*C3","v":11.999999999999998},{"$f":"D3+(E2<25)*E2","v":23.999999999999996},{"$f":"(B3-B$2)/B$2","v":0},null,"cumrente=0"]
[3,{"$f":"B3+(E3>=25)*E3","v":10000},{"$f":"C$2","v":1.1999999999999999E-3},{"$f":"B4*C4","v":11.999999999999998},{"$f":"D4+(E3<25)*E3","v":35.999999999999993},0,null,"for week=1 to looptijd"]
[4,10036,1.1999999999999999E-3,12.043199999999999,12.043199999999999,{"$f":"(B5-B$2)/B$2","v":3.5999999999999999E-3},null,null,"rente=resultaat*weekrente"]
[5,10036,1.1999999999999999E-3,12.043199999999999,24.086399999999998,3.5999999999999999E-3,null,null,"resultaat=resultaat+(cumrente>=drempel)*cumrente"]
[6,10036,1.1999999999999999E-3,12.043199999999999,36.129599999999996,3.5999999999999999E-3,null,null,"cumrente=rente+(cumrente<drempel)*cumrente"]
[7,10072.1296,1.1999999999999999E-3,12.086555519999999,12.086555519999999,7.2129600000000208E-3,null,"next"]
[8,10072.1296,1.1999999999999999E-3,12.086555519999999,24.173111039999998,7.2129600000000208E-3,null,"ResultaatDrempel=resultaat"]
[9,10072.1296,1.1999999999999999E-3,12.086555519999999,36.259666559999999,7.2129600000000208E-3]
[10,10108.38926656,1.1999999999999999E-3,12.130067119871999,12.130067119871999,1.0838926655999967E-2,null,"ResultaatEff(inleg,weekrente,drempel,looptijd)"]
[11,10108.38926656,1.1999999999999999E-3,12.130067119871999,24.260134239743998,1.0838926655999967E-2,null,"ResultaatEff = (ResultaatDrempel(inleg, weekrente, drempel, looptijd) - inleg) / inleg * 100"]
[12,10108.38926656,1.1999999999999999E-3,12.130067119871999,36.390201359616,1.0838926655999967E-2]
[13,10144.779467919616,1.1999999999999999E-3,12.173735361503537,12.173735361503537,1.4477946791961585E-2,null,"Vul in"]
[14,10144.779467919616,1.1999999999999999E-3,12.173735361503537,24.347470723007074,1.4477946791961585E-2,null,"inleg",10000]
[15,10144.779467919616,1.1999999999999999E-3,12.173735361503537,36.521206084510609,1.4477946791961585E-2,null,"weekrente",0.12]
[16,10181.300674004127,1.1999999999999999E-3,12.217560808804953,12.217560808804953,1.8130067400412737E-2,null,"drempel",25]
[17,10181.300674004127,1.1999999999999999E-3,12.217560808804953,24.435121617609905,1.8130067400412737E-2,null,"looptijd",53]
[18,10181.300674004127,1.1999999999999999E-3,12.217560808804953,36.652682426414856,1.8130067400412737E-2,null,"Resultaat",{"$f":"ResultaatDrempel(I15,I16,I17,I18)","v":10642.04920785272}]
[19,10217.953356430542,1.1999999999999999E-3,12.261544027716649,12.261544027716649,2.1795335643054206E-2,null,"Eff.rente",{"$f":"ResultaatEff(I15,I16,I17,I18)","v":6.4204920785272037}]
[20,10217.953356430542,1.1999999999999999E-3,12.261544027716649,24.523088055433298,2.1795335643054206E-2]
[21,10217.953356430542,1.1999999999999999E-3,12.261544027716649,36.784632083149944,2.1795335643054206E-2]
[22,10254.737988513692,1.1999999999999999E-3,12.30568558621643,12.30568558621643,2.5473798851369248E-2]
[23,10254.737988513692,1.1999999999999999E-3,12.30568558621643,24.611371172432861,2.5473798851369248E-2]
[24,10254.737988513692,1.1999999999999999E-3,12.30568558621643,36.917056758649295,2.5473798851369248E-2]
[25,10291.655045272342,1.1999999999999999E-3,12.349986054326809,12.349986054326809,2.9165504527234223E-2]
[26,10291.655045272342,1.1999999999999999E-3,12.349986054326809,24.699972108653618,2.9165504527234223E-2]
[27,10291.655045272342,1.1999999999999999E-3,12.349986054326809,37.049958162980431,2.9165504527234223E-2]
[28,10328.705003435323,1.1999999999999999E-3,12.394446004122386,12.394446004122386,3.2870500343532331E-2]
[29,10328.705003435323,1.1999999999999999E-3,12.394446004122386,24.788892008244773,3.2870500343532331E-2]
[30,10328.705003435323,1.1999999999999999E-3,12.394446004122386,37.183338012367159,3.2870500343532331E-2]
[31,10365.888341447691,1.1999999999999999E-3,12.439066009737228,12.439066009737228,3.6588834144769135E-2]
[32,10365.888341447691,1.1999999999999999E-3,12.439066009737228,24.878132019474457,3.6588834144769135E-2]
[{"$f":"ROW()-ROW($A$2)+1","v":33},10365.888341447691,1.1999999999999999E-3,12.439066009737228,37.317198029211681,3.6588834144769135E-2]
[34,10403.205539476903,1.1999999999999999E-3,12.483846647372284,12.483846647372284,4.0320553947690317E-2]
[35,10403.205539476903,1.1999999999999999E-3,12.483846647372284,24.967693294744567,4.0320553947690317E-2]
[36,10403.205539476903,1.1999999999999999E-3,12.483846647372284,37.451539942116852,4.0320553947690317E-2]
[37,10440.657079419019,1.1999999999999999E-3,12.528788495302821,12.528788495302821,4.4065707941901927E-2]
[38,10440.657079419019,1.1999999999999999E-3,12.528788495302821,25.057576990605643,4.4065707941901927E-2]
[39,10465.714656409626,1.1999999999999999E-3,12.55885758769155,12.55885758769155,4.657146564096256E-2]
[40,10465.714656409626,1.1999999999999999E-3,12.55885758769155,25.117715175383101,4.657146564096256E-2]
[41,10490.832371585009,1.1999999999999999E-3,12.58899884590201,12.58899884590201,4.9083237158500923E-2]
[42,10490.832371585009,1.1999999999999999E-3,12.58899884590201,25.17799769180402,4.9083237158500923E-2]
[43,10516.010369276813,1.1999999999999999E-3,12.619212443132175,12.619212443132175,5.1601036927681344E-2]
[44,10516.010369276813,1.1999999999999999E-3,12.619212443132175,25.238424886264351,5.1601036927681344E-2]
[45,10541.248794163077,1.1999999999999999E-3,12.649498552995691,12.649498552995691,5.4124879416307704E-2]
[46,10541.248794163077,1.1999999999999999E-3,12.649498552995691,25.298997105991383,5.4124879416307704E-2]
[47,10566.547791269068,1.1999999999999999E-3,12.67985734952288,12.67985734952288,5.6654779126906758E-2]
[48,10566.547791269068,1.1999999999999999E-3,12.67985734952288,25.35971469904576,5.6654779126906758E-2]
[49,10591.907505968113,1.1999999999999999E-3,12.710289007161734,12.710289007161734,5.9190750596811267E-2]
[50,10591.907505968113,1.1999999999999999E-3,12.710289007161734,25.420578014323468,5.9190750596811267E-2]
[51,10617.328083982437,1.1999999999999999E-3,12.740793700778923,12.740793700778923,6.1732808398243653E-2]
[52,10617.328083982437,1.1999999999999999E-3,12.740793700778923,25.481587401557846,6.1732808398243653E-2]
[53,10642.809671383995,null,null,null,6.4280967138399495E-2]

{"sheet":"Formules","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Week","Totale Inleg","Rente/wk","Rente","Cum. Rente","Eff. Rente%"]
[1,10000,1.1999999999999999E-3,"=B2*C2","=ALS(E1<25;E1;0)+D2","=(B2-B$2)/B$2"]
[2,"=B2+ALS(E2>=25;E2;0)","=C$2","=B3*C3","=ALS(E2<25;E2;0)+D3","=(B3-B$2)/B$2"]
[3,"=B3+ALS(E3>=25;E3;0)","=C$2","=B4*C4","=ALS(E3<25;E3;0)+D4","=(B4-B$2)/B$2"]
[4,"=B4+ALS(E3>=25;E3;0)","=C$2","=B5*C5","=ALS(E4<25;E4;0)+D5","=(B5-B$2)/B$2"]
[5,"=B5+ALS(E4>=25;E4;0)",null,null,null,"=(B6-B$2)/B$2"]
[]
[]
[]
[]
[]
[]
[]
["Cel","Waarde","Weergegeven waarde","Formule"]
["A2",1,"1","=RIJ()-RIJ($A$2)+1"]
["B2",10000," €  10,000.00 ","=10000"]
["C2",1.1999999999999999E-3,"0.12%","=0.12%"]
["D2",11.999999999999998," €          12.00 ","=B2*C2"]
["E2",11.999999999999998," €          12.00 ","=ALS(E1<25;E1;0)+D2"]
["A3",2,"2","=RIJ()-RIJ($A$2)+1"]
["B3",10000," €  10,000.00 ","=B2+ALS(E2>=25;E2;0)"]
["C3",1.1999999999999999E-3,"0.12%","=C$2"]
["D3",11.999999999999998," €          12.00 ","=B3*C3"]
["E3",23.999999999999996," €          24.00 ","=ALS(E2<25;E2;0)+D3"]
["A4",3,"3","=RIJ()-RIJ($A$2)+1"]
["B4",10000," €  10,000.00 ","=B3+ALS(E3>=25;E3;0)"]
["C4",1.1999999999999999E-3,"0.12%","=C$2"]
["D4",11.999999999999998," €          12.00 ","=B4*C4"]
["E4",35.999999999999993," €          36.00 ","=ALS(E3<25;E3;0)+D4"]
["A5",4,"4","=RIJ()-RIJ($A$2)+1"]
["B5",10036," €  10,036.00 ","=B4+ALS(E4>=25;E4;0)"]

{"sheet":"Waarden","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Wk #","Totale Inleg","Rente/wk","Rente","Cum. Rente","Eff. Rente%"]
[1,10000,1.1999999999999999E-3,11.999999999999998,11.999999999999998,0]
[2,10000,1.1999999999999999E-3,11.999999999999998,23.999999999999996,0]
[3,10000,1.1999999999999999E-3,11.999999999999998,35.999999999999993,0]
[4,10036,null,null,null,3.5999999999999999E-3]