{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Balances"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":9,"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":"Data","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,2,12,2],[15,2,16,2],[17,2,18,2],[13,2,14,2]]}
[]
[]
[]
[null,null,"Employee Name","John Jones"]
[]
[null,null,"Current Age",24]
[]
[null,null,"Retirement Age",65]
[]
[null,null,"Current Salary",20000]
[]
[null,null,"Salary Growth Rate",0.03]
[]
[null,null,"Contribution Rate",0.08]
[]
[null,null,"Company Match",0.5]
[]
[null,null,"Investment Return",0.1]
[]
[]
[null,null,"Ending Balance",{"$f":"Balances!$G$44","v":1671012.1089175898}]

{"sheet":"Balances","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,null,"Beginning","Employee","Company","Investment","Ending"]
["Age","Salary","Balance","Contributions","Match","Earnings","Balance"]
[{"$f":"Data!D6","v":24},{"$f":"Data!D10","v":20000},0,{"$f":"B3*Data!$D$14","v":1600},{"$f":"MIN(Data!$D$14,0.06)*B3*Data!$D$16","v":600},{"$f":"(C3+D3/2)*Data!$D$18","v":80},{"$f":"SUM(C3:F3)","v":2280}]
[{"$f":"A3+1","v":25},{"$f":"B3*(1+Data!$D$12)","v":20600},{"$f":"G3","v":2280},{"$f":"B4*Data!$D$14","v":1648},{"$f":"MIN(Data!$D$14,0.06)*B4*Data!$D$16","v":618},{"$f":"(C4+D4/2)*Data!$D$18","v":310.40000000000003},{"$f":"SUM(C4:F4)","v":4856.3999999999996}]
[{"$f":"A4+1","v":26},{"$f":"B4*(1+Data!$D$12)","v":21218},{"$f":"G4","v":4856.3999999999996},{"$f":"B5*Data!$D$14","v":1697.44},{"$f":"MIN(Data!$D$14,0.06)*B5*Data!$D$16","v":636.54},{"$f":"(C5+D5/2)*Data!$D$18","v":570.51200000000006},{"$f":"SUM(C5:F5)","v":7760.8919999999998}]
[27,{"$f":"B5*(1+Data!$D$12)","v":21854.54},7760.8919999999998,{"$f":"B6*Data!$D$14","v":1748.3632},{"$f":"MIN(Data!$D$14,0.06)*B6*Data!$D$16","v":655.63620000000003},{"$f":"(C6+D6/2)*Data!$D$18","v":863.50736000000006},11028.39876]
[28,{"$f":"B6*(1+Data!$D$12)","v":22510.176200000002},11028.39876,{"$f":"B7*Data!$D$14","v":1800.8140960000001},{"$f":"MIN(Data!$D$14,0.06)*B7*Data!$D$16","v":675.30528600000002},{"$f":"(C7+D7/2)*Data!$D$18","v":1192.8805808000002},14697.398722800001]
[29,{"$f":"B7*(1+Data!$D$12)","v":23185.481486000001},14697.398722800001,{"$f":"B8*Data!$D$14","v":1854.83851888},{"$f":"MIN(Data!$D$14,0.06)*B8*Data!$D$16","v":695.56444457999999},{"$f":"(C8+D8/2)*Data!$D$18","v":1562.4817982240002},18810.283484483996]
[30,{"$f":"B8*(1+Data!$D$12)","v":23881.04593058},18810.283484483996,{"$f":"B9*Data!$D$14","v":1910.4836744464001},{"$f":"MIN(Data!$D$14,0.06)*B9*Data!$D$16","v":716.43137791739991},{"$f":"(C9+D9/2)*Data!$D$18","v":1976.5525321707196},23413.751069018519]
[31,{"$f":"B9*(1+Data!$D$12)","v":24597.4773084974},23413.751069018519,{"$f":"B10*Data!$D$14","v":1967.798184679792},{"$f":"MIN(Data!$D$14,0.06)*B10*Data!$D$16","v":737.92431925492201},{"$f":"(C10+D10/2)*Data!$D$18","v":2439.7650161358415},28559.238589089073]
[32,{"$f":"B10*(1+Data!$D$12)","v":25335.401627752322},28559.238589089073,{"$f":"B11*Data!$D$14","v":2026.8321302201859},{"$f":"MIN(Data!$D$14,0.06)*B11*Data!$D$16","v":760.06204883256964},{"$f":"(C11+D11/2)*Data!$D$18","v":2957.2654654199168},34303.398233561747]
[33,{"$f":"B11*(1+Data!$D$12)","v":26095.463676584892},34303.398233561747,{"$f":"B12*Data!$D$14","v":2087.6370941267915},{"$f":"MIN(Data!$D$14,0.06)*B12*Data!$D$16","v":782.86391029754668},{"$f":"(C12+D12/2)*Data!$D$18","v":3534.7216780625149},40708.620916048603]
[34,{"$f":"B12*(1+Data!$D$12)","v":26878.327586882438},40708.620916048603,{"$f":"B13*Data!$D$14","v":2150.266206950595},{"$f":"MIN(Data!$D$14,0.06)*B13*Data!$D$16","v":806.34982760647313},{"$f":"(C13+D13/2)*Data!$D$18","v":4178.3754019523903},47843.612352558062]
[35,{"$f":"B13*(1+Data!$D$12)","v":27684.677414488913},47843.612352558062,{"$f":"B14*Data!$D$14","v":2214.7741931591131},{"$f":"MIN(Data!$D$14,0.06)*B14*Data!$D$16","v":830.54032243466736},{"$f":"(C14+D14/2)*Data!$D$18","v":4895.0999449137626},55784.026813065604]
[36,{"$f":"B14*(1+Data!$D$12)","v":28515.21773692358},55784.026813065604,{"$f":"B15*Data!$D$14","v":2281.2174189538864},{"$f":"MIN(Data!$D$14,0.06)*B15*Data!$D$16","v":855.4565321077074},{"$f":"(C15+D15/2)*Data!$D$18","v":5692.4635522542558},64613.164316381459]
[37,{"$f":"B15*(1+Data!$D$12)","v":29370.674269031289},64613.164316381459,{"$f":"B16*Data!$D$14","v":2349.6539415225034},{"$f":"MIN(Data!$D$14,0.06)*B16*Data!$D$16","v":881.12022807093865},{"$f":"(C16+D16/2)*Data!$D$18","v":6578.7991287142713},74422.737614689162]
[38,{"$f":"B16*(1+Data!$D$12)","v":30251.79449710223},74422.737614689162,{"$f":"B17*Data!$D$14","v":2420.1435597681784},{"$f":"MIN(Data!$D$14,0.06)*B17*Data!$D$16","v":907.55383491306691},{"$f":"(C17+D17/2)*Data!$D$18","v":7563.280939457326},85313.715948827739]
[39,{"$f":"B17*(1+Data!$D$12)","v":31159.348332015299},85313.715948827739,{"$f":"B18*Data!$D$14","v":2492.7478665612239},{"$f":"MIN(Data!$D$14,0.06)*B18*Data!$D$16","v":934.7804499604589},{"$f":"(C18+D18/2)*Data!$D$18","v":8656.008988210835},97397.253253560251]
[40,{"$f":"B18*(1+Data!$D$12)","v":32094.12878197576},97397.253253560251,{"$f":"B19*Data!$D$14","v":2567.5303025580611},{"$f":"MIN(Data!$D$14,0.06)*B19*Data!$D$16","v":962.82386345927273},{"$f":"(C19+D19/2)*Data!$D$18","v":9868.1018404839288},110795.70926006151]
[41,{"$f":"B19*(1+Data!$D$12)","v":33056.952645435034},110795.70926006151,{"$f":"B20*Data!$D$14","v":2644.5562116348028},{"$f":"MIN(Data!$D$14,0.06)*B20*Data!$D$16","v":991.70857936305094},{"$f":"(C20+D20/2)*Data!$D$18","v":11211.798736587893},125643.77278764726]
[42,{"$f":"B20*(1+Data!$D$12)","v":34048.661224798088},125643.77278764726,{"$f":"B21*Data!$D$14","v":2723.892897983847},{"$f":"MIN(Data!$D$14,0.06)*B21*Data!$D$16","v":1021.4598367439426},{"$f":"(C21+D21/2)*Data!$D$18","v":12700.57192366392},142089.69744603898]
[43,{"$f":"B21*(1+Data!$D$12)","v":35070.121061542035},142089.69744603898,{"$f":"B22*Data!$D$14","v":2805.6096849233627},{"$f":"MIN(Data!$D$14,0.06)*B22*Data!$D$16","v":1052.1036318462611},{"$f":"(C22+D22/2)*Data!$D$18","v":14349.250228850067},160296.66099165866]
[44,{"$f":"B22*(1+Data!$D$12)","v":36122.2246933883},160296.66099165866,{"$f":"B23*Data!$D$14","v":2889.7779754710641},{"$f":"MIN(Data!$D$14,0.06)*B23*Data!$D$16","v":1083.666740801649},{"$f":"(C23+D23/2)*Data!$D$18","v":16174.154997939419},180444.26070587078]
[45,{"$f":"B23*(1+Data!$D$12)","v":37205.891434189951},180444.26070587078,{"$f":"B24*Data!$D$14","v":2976.4713147351963},{"$f":"MIN(Data!$D$14,0.06)*B24*Data!$D$16","v":1116.1767430256984},{"$f":"(C24+D24/2)*Data!$D$18","v":18193.249636323839},202730.15839995549]
[46,{"$f":"B24*(1+Data!$D$12)","v":38322.068177215653},202730.15839995549,{"$f":"B25*Data!$D$14","v":3065.7654541772522},{"$f":"MIN(Data!$D$14,0.06)*B25*Data!$D$16","v":1149.6620453164696},{"$f":"(C25+D25/2)*Data!$D$18","v":20426.304112704413},227371.89001215363]
[47,{"$f":"B25*(1+Data!$D$12)","v":39471.730222532125},227371.89001215363,{"$f":"B26*Data!$D$14","v":3157.73841780257},{"$f":"MIN(Data!$D$14,0.06)*B26*Data!$D$16","v":1184.1519066759638},{"$f":"(C26+D26/2)*Data!$D$18","v":22895.07592210549},254608.85625873765]
[48,{"$f":"B26*(1+Data!$D$12)","v":40655.88212920809},254608.85625873765,{"$f":"B27*Data!$D$14","v":3252.4705703366471},{"$f":"MIN(Data!$D$14,0.06)*B27*Data!$D$16","v":1219.6764638762427},{"$f":"(C27+D27/2)*Data!$D$18","v":25623.509154390598},284704.51244734111]
[49,{"$f":"B27*(1+Data!$D$12)","v":41875.558593084337},284704.51244734111,{"$f":"B28*Data!$D$14","v":3350.044687446747},{"$f":"MIN(Data!$D$14,0.06)*B28*Data!$D$16","v":1256.2667577925301},{"$f":"(C28+D28/2)*Data!$D$18","v":28637.953479106451},317948.77737168677]
[50,{"$f":"B28*(1+Data!$D$12)","v":43131.825350876868},317948.77737168677,{"$f":"B29*Data!$D$14","v":3450.5460280701495},{"$f":"MIN(Data!$D$14,0.06)*B29*Data!$D$16","v":1293.954760526306},{"$f":"(C29+D29/2)*Data!$D$18","v":31967.405038572186},354660.68319885543]
[51,{"$f":"B29*(1+Data!$D$12)","v":44425.780111403175},354660.68319885543,{"$f":"B30*Data!$D$14","v":3554.0624089122539},{"$f":"MIN(Data!$D$14,0.06)*B30*Data!$D$16","v":1332.7734033420952},{"$f":"(C30+D30/2)*Data!$D$18","v":35643.771440331155},395191.29045144096]
[52,{"$f":"B30*(1+Data!$D$12)","v":45758.553514745268},395191.29045144096,{"$f":"B31*Data!$D$14","v":3660.6842811796214},{"$f":"MIN(Data!$D$14,0.06)*B31*Data!$D$16","v":1372.756605442358},{"$f":"(C31+D31/2)*Data!$D$18","v":39702.16325920308},439926.89459726604]
[53,{"$f":"B31*(1+Data!$D$12)","v":47131.310120187627},439926.89459726604,{"$f":"B32*Data!$D$14","v":3770.5048096150103},{"$f":"MIN(Data!$D$14,0.06)*B32*Data!$D$16","v":1413.9393036056288},{"$f":"(C32+D32/2)*Data!$D$18","v":44181.214700207354},489292.55341069406]
[54,{"$f":"B32*(1+Data!$D$12)","v":48545.249423793255},489292.55341069406,{"$f":"B33*Data!$D$14","v":3883.6199539034606},{"$f":"MIN(Data!$D$14,0.06)*B33*Data!$D$16","v":1456.3574827137977},{"$f":"(C33+D33/2)*Data!$D$18","v":49123.436338764586},543755.96718607598]
[55,{"$f":"B33*(1+Data!$D$12)","v":50001.606906507055},543755.96718607598,{"$f":"B34*Data!$D$14","v":4000.1285525205644},{"$f":"MIN(Data!$D$14,0.06)*B34*Data!$D$16","v":1500.0482071952115},{"$f":"(C34+D34/2)*Data!$D$18","v":54575.603146233632},603831.74709202535]
[56,{"$f":"B34*(1+Data!$D$12)","v":51501.655113702269},603831.74709202535,{"$f":"B35*Data!$D$14","v":4120.1324090961816},{"$f":"MIN(Data!$D$14,0.06)*B35*Data!$D$16","v":1545.049653411068},{"$f":"(C35+D35/2)*Data!$D$18","v":60589.181329657353},670086.11048418994]
[57,{"$f":"B35*(1+Data!$D$12)","v":53046.70476711334},670086.11048418994,{"$f":"B36*Data!$D$14","v":4243.7363813690672},{"$f":"MIN(Data!$D$14,0.06)*B36*Data!$D$16","v":1591.4011430134001},{"$f":"(C36+D36/2)*Data!$D$18","v":67220.797867487461},743142.0458760598]
[58,{"$f":"B36*(1+Data!$D$12)","v":54638.105910126746},743142.0458760598,{"$f":"B37*Data!$D$14","v":4371.0484728101401},{"$f":"MIN(Data!$D$14,0.06)*B37*Data!$D$16","v":1639.1431773038023},{"$f":"(C37+D37/2)*Data!$D$18","v":74532.757011246489},823684.99453742034]
[59,{"$f":"B37*(1+Data!$D$12)","v":56277.249087430551},823684.99453742034,{"$f":"B38*Data!$D$14","v":4502.179926994444},{"$f":"MIN(Data!$D$14,0.06)*B38*Data!$D$16","v":1688.3174726229165},{"$f":"(C38+D38/2)*Data!$D$18","v":82593.608450091764},912469.10038712958]
[60,{"$f":"B38*(1+Data!$D$12)","v":57965.56656005347},912469.10038712958,{"$f":"B39*Data!$D$14","v":4637.2453248042775},{"$f":"MIN(Data!$D$14,0.06)*B39*Data!$D$16","v":1738.966996801604},{"$f":"(C39+D39/2)*Data!$D$18","v":91478.772304953178},1010324.0850136887]
[61,{"$f":"B39*(1+Data!$D$12)","v":59704.533556855073},1010324.0850136887,{"$f":"B40*Data!$D$14","v":4776.3626845484059},{"$f":"MIN(Data!$D$14,0.06)*B40*Data!$D$16","v":1791.1360067056521},{"$f":"(C40+D40/2)*Data!$D$18","v":101271.22663559629},1118162.8103405391]
[62,{"$f":"B40*(1+Data!$D$12)","v":61495.669563560725},1118162.8103405391,{"$f":"B41*Data!$D$14","v":4919.6535650848582},{"$f":"MIN(Data!$D$14,0.06)*B41*Data!$D$16","v":1844.8700869068216},{"$f":"(C41+D41/2)*Data!$D$18","v":112062.26371230817},1236989.5977048387]
[63,{"$f":"B41*(1+Data!$D$12)","v":63340.539650467545},1236989.5977048387,{"$f":"B42*Data!$D$14","v":5067.2431720374034},{"$f":"MIN(Data!$D$14,0.06)*B42*Data!$D$16","v":1900.2161895140262},{"$f":"(C42+D42/2)*Data!$D$18","v":123952.32192908575},1367909.3789954758]
[64,{"$f":"B42*(1+Data!$D$12)","v":65240.755839981575},1367909.3789954758,{"$f":"B43*Data!$D$14","v":5219.2604671985264},{"$f":"MIN(Data!$D$14,0.06)*B43*Data!$D$16","v":1957.2226751994472},{"$f":"(C43+D43/2)*Data!$D$18","v":137051.90092290752},1512137.7630607812]
[65,{"$f":"B43*(1+Data!$D$12)","v":67197.978515181021},1512137.7630607812,{"$f":"B44*Data!$D$14","v":5375.8382812144819},{"$f":"MIN(Data!$D$14,0.06)*B44*Data!$D$16","v":2015.9393554554306},{"$f":"(C44+D44/2)*Data!$D$18","v":151482.56822013887},1671012.1089175898]