{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Inputs","Instructions - Simulator sheet","Simulator","Example results","Read me whenever!"],"not_rendered":{"charts":1,"images":13,"macros":1,"external_links":0,"defined_names":34,"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":"Inputs","index":0,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["This excel sheet uses MACRO's. You will need to enable them before proceeding. Zoom each sheet according to your convenience"]
[]
["Read and complete entries in this column first"]
["Fill only cell in green",null,null,"The corpus that you enter will divided into 5 buckets, that is different instruments as listed below. "]
["Current monthly expenses",10000," ","Enter the % allocation to each bucket. Bucket 1 represents a fixed income instrument like a FD. So returns will not vary"]
["Time to retirement",25,null,"For the other buckets you need to enter an average return and variation from this average (explained below)"]
["inflation prior retirement",0.08,null," The simulator will randomly generate (uncorrelated) returns for each year in retirement based on the input average return and variation"]
["Years in retirement",25,null,"Income for first few retirement years will come from bucket 1. This allows enough time for the sum invested in other buckets"]
["inflation post-retirement",0.08,null,"to appreciate. You can transfer from buckets 2-5 to bucket 1 if (a) you have made good returns in a year or (b) you don't have"]
["Annual expenses in 1st year of retirement",{"$f":"B5*12*(1+B7)^(B6+1)","v":887562.38543002447},null,"enough funds in bucket 1 to continue. You can transfer sums among buckets 2-5."]
["Average return for post-retirement investments",0.08,null,"Usually it is recommend that one makes a transfer to bucket 1 only if the average compounded rate of return is close to historcial"]
["Total corpus needed to meet expenses",{"$f":"PV((1+retroi)/(1+rinf)-1,k,-prepen1,,1)","v":22189059.63575061},null,"returns (10-15% approx.). Unfortunately inflation in India hovers around 8% and this may not work"]
["Thus  while the corpus grows at an average rate you draw ",null,null,"This approach is known as defined withdrawals strategy or the retirement bucket strategy"]
["from it each year  accoring to your expenses (indexed to inflation).",null,null,"The idea of the simulator is to try and prolong the life of the corpus (you chose!) while accouting for inflation-indexed expenses."]
["This corpus will become zero at the end of retirement period",null,null,"With intelligent transfers can you beat the standard withdrawal method? If you are not used to equity investing then "]
["This is known as the systematic withdrawals strategy",null,null,"you will need to try several times! Don't give up. This strategy can make a big difference to your retirement plan"]
["Is there a way to cope with a lower corpus?"]
["Is there a way to make the corpus last longer?",null,null,null,"Instrument","Allocation","Fixed Return","This allocation (bucket 1) will approx. last for (years)*"]
["This simulator attempts to see if this is possible*",null,null,"Bucket 1","Fixed Income (Bank FD)",0.45,0.05,{"$f":"NPER((1+_min1)/(1+rinf)-1,-prepen1,F19*B20,,1)","v":9.0314419660977094}]
["Enter corpus you think will fund your retirement",20000000,null,null,null,null,"Average Return","Variation from average return (std. dev.)"]
["If you don't want to use the above amt take a guess",null,null,"Bucket 2","Debt Fund",0.25,0.09,0.03]
["Rememeber it would be tough to cope with a much lower corpus",null,null,"Bucket 3","Hybrid: Balanced Fund",0.1,0.1,0.1]
[null,null,null,"Bucket 4","Large-cap (stocks/MF)",0.1,0.12,0.2]
["If you are going to receive an annuity ensure the corpus amount you enter",null,null,"Bucket 5","Mid-/Small-cap (stocks/MF)",0.1,0.15,0.3]
["above does not include the sum that will be used to provide the annuity",null,null,"* The idea is to use this time to let the sum in other buckets appreciate AND transfer at oppurtune times into bucket 1. Recommended time 8-10 years."]
["Enter the annuity or pension you will receive",null,null,"Important: If the allocation column turns red, ensure the allocations add up to 100% before proceeding"]
["This is constant throughout retirement",75000,null,"Note on Variation from average return: Suppose we consider an average of 15% and variation (or standard deviation of 40%)"]
["Enter annual income from other sources during ",null,null,"If we use a so-called normal distribution (the most common in nature) then about 68% of all return will lie centered about the average"]
["1st year of retirement",100000,null,"return. Such returns will range from (15%-20%) to (15% + 20%) or -5% to 35%. Here 20% is half the standard deviation. Lower the"]
["Annual rate of increase of this income",0.1,null,"standard deviation lower the volatility. How justified are we in using a normal distribution? It works reasonably with US"]
[null,null,null,"market data. However we don't have enough data on Indian markets to see if this is suitable. However given the omnipresence of such"]
["Net annual expenses to be covered from corpus",null,null,"distributions in nature it is a safe bet as long as we keep in mind real life is more complicated than we can ever imagine!"]
["in the first year of retirement",{"$f":"(prepen1)-(pension)-(income)","v":712562.38543002447}]
[]
[" Once you have read & completed the entried in this sheet, proceed to the 'instructions' page to learn how to use the the simulator. You could then  proceed to the 'Simulator' page"]
[]
["Systemactic withdrawals can be made in two ways: One with fixed average return as mentioned above or it can be made with varying returns from different buckets. "]
["If buckets are used the (weighted) average of returns from each bucket is used. The simulator calculates the total corpus in each year of retirement using all the 3 methods."]
[]
["* Please remember this is a simulation tool. It presents a series of situations with high volatility in returns to help you understand the factors that affect retirement corpus management. Althought subect to reasonable "]
["assumptions it can never susbtitute for real life scenarios, The take home message is managing a retirement corpus is an active exercise. Passive statergies like relying on annuities or a pension will not work for most!"]

{"sheet":"Instructions - Simulator sheet","index":1,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["1. To obtain a fresh set of random returns press this"]
[null,null,null,null,null,null,null,null,null,null,null,"2. To advance to the next year press this",null,null,null,null,null,null,null,"3.For the same interest rate data set click this to redo the exercise!"]
[]
[]
["4. Before advancing remember to review: (a). balances in each bucket."]
["(b). compounded annual growth rate (CAGR) of the buckets."]
["A good thumb rule is to sell if the CAGR is close to or above"]
["the average rate of each bucket you have entered in the 'Inputs' sheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["6.In the screenshot 21 is the current year. However bucket 1 has funds only"]
["up to year 20. So you cannot proceed unless you transfer funds into bucket 1"]
["If funds are not available its game over!"]
[]
["7. The annual corpus obtained by three stratergies are plotted here to"]
["evaluate the progress of the bucket statergy"]
["To accommodate the plot only the last years in the table will be displayed"]

{"sheet":"Simulator","index":2,"n_rows":111,"n_cols":55,"rows_kept":111,"cut":false,"hidden":false,"merged":[[9,53,9,54],[9,47,9,48],[9,51,9,52],[7,24,7,25],[8,24,8,25],[7,26,7,27],[8,26,8,27],[9,24,9,25],[9,26,9,27],[6,26,6,27],[5,3,5,12],[5,14,5,18],[5,20,5,27],[6,24,6,25],[6,22,6,23],[6,20,6,21],[2,4,2,12],[7,22,7,23],[8,22,8,23],[7,20,7,21],[8,20,8,21],[9,20,9,21],[9,22,9,23]]}
[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,null,null,null,null,{"$f":"IF(Inputs!F19+Inputs!F21+Inputs!F22+Inputs!F23+Inputs!F24=100%,1,0)","v":1}]
[]
[null,null,null,null,"Compound Annual Growth Rate",null,null,null,null,null,null,null,null,null,"Current Year",null,{"$f":"MAX(AQ12:AQ111)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,{"$f":"SUM(AQ12:AQ111)","v":0}]
[null,null,null,null,"Bucket 1","Bucket 2",null,"Bucket 3",null,"Bucket 4",null,null,"Bucket 5",null,"Bucket 1 can support expenses up to year",null,null,null,{"$f":"SUM(AN12:AN1111)-1","v":9},null,"If cells in the 'transfers' coumns turn red it means you are trying to transfer "]
[null,null,null,null,{"$f":"_min1","v":0.05},null,null,null,null,null,null,null,null,null,"To continue transfer",null,{"$f":"SUM(AM12:AM111)","v":4.8180637453394457},"lakhs to bucket 1",null,null,"more than the available balance. Decrease amt until the 'red' goes away",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,"Random Annual Returns",null,null,null,null,null,null,null,null,null,null,"BALANCES (Lakhs)",null,null,null,null,null,"TRANSFERS (Lakhs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Show"]
[null,"Net annual",null,null,"Bucket 1","Bucket 2",null,"Bucket 3",null,"Bucket 4",null,null,"Bucket 5",null,"Bucket 1","Bucket 2","Bucket 3","Bucket 4","Bucket 5",null,"Bucket 2",null,"Bucket 3",null,"Bucket 4",null,"Bucket 5",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hide"]
[null,"expenses",null,null,"Fixed","Debt Fund",null,"Hybrid",null,"Large-cap",null,null,"Mid/Small ",null,"Fixed","Debt Fund","Hybrid","Large-cap","Mid/Small ",null,"Debt Fund",null,"Hybrid",null,"Large-cap",null,"Mid/Small Cap"]
[null,"that will be ",null,null,"(eg. FDs)",null,null,"Bal. Fund",null,"Stocks/MF",null,null,"Stocks/MF",null,"(eg. FDs)",null,"Bal. Fund","Stocks/MF","Stocks/MF",null,null,null,"Balanced Fund",null,"Stocks/MF",null,"Stocks/MF",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bucket 2"]
[null,"covered",null,null," Income",null,null,null,null,null,null,null,"Cap",null," Income",null,null,null,"Cap",null,"Transfers to",null,"Transfers to",null,"Transfers to",null,"Transfers to",null,null,"Year",null,null,null,null,null,null,null,null,null,null,"Bucket 3",null,null,"Bucket","sys wit","sys wit",null,"B2",null,"B3",null,"B4",null,"B5"]
["Year","by corpus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bucket 1","Bucket 3","Bucket 1","Bucket 2","Bucket 1","Bucket 2","Bucket 1","Bucket 2",null,"Year",null,null,null,null,null,null,null,null,null,null,"Bucket 4",null,null,"strategy","avg ret","rand ret",null,null,"CAGR",null,"CAGR",null,"CAGR",null,"CAGR"]
[0,{"$f":"(prepen1*(1+rinf)^A12/100000)-(pension/100000)-(income*(1+incrate)^A12/100000)","v":7.1256238543002439},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Inputs!F19*Inputs!B20,0)/100000","v":90},{"$f":"ROUND(Inputs!F21*Inputs!B20,0)/100000","v":50},{"$f":"ROUND(Inputs!B20*Inputs!F22,0)/100000","v":20},{"$f":"ROUND(Inputs!B20*Inputs!F23,0)/100000","v":20},{"$f":"ROUND(Inputs!F24*Inputs!B20,0)/100000","v":20},null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Bucket 5",null,null,{"$f":"Inputs!B20/100000","v":200},{"$f":"(Inputs!B12-prepen1)/100000","v":213.01497250320588},{"$f":"Inputs!B20/100000","v":200},null,1,null,1,null,1,null,1]
[{"$f":"A12+1","v":1},7.7356737626442662,null,{"$f":"IF(E13<>\"\",E13,_min1)","v":0.05},0.05,0.1197423283856266,{"$f":"IF(F13<>\"\",F13,NORMINV(RAND(),mean2,stdev2))","v":0.1197423283856266},0.14139740641492543,{"$f":"IF(H13<>\"\",H13,NORMINV(RAND(),mean3,stdev3))","v":0.14139740641492543},0.14387458323598337,{"$f":"IF(J13<>\"\",J13,NORMINV(RAND(),mean4,stdev4))","v":0.14387458323598337},{"$f":"IF(M13<>\"\",M13,NORMINV(RAND(),mean5,stdev5))","v":0.70761063500248778},0.70761063500248778,null,{"$f":"IF(O12=\"no funds\",\"no funds\",IF((O12-B12+U12+W12+Y12+AA12)*(1+D13)<0,\"no funds\",ROUND((O12-B12+U12+W12+Y12+AA12)*(1+D13),0)))","v":87},{"$f":"ROUND((P12-U12-V12+IF(trans3=\"bucket 2\",X12)+IF(trans4=\"bucket 2\",Z12)+IF(trans5=\"bucket 2\",AB12))*(1+F13),0)","v":56},{"$f":"ROUND((Q12-W12-X12+IF(trans2=\"bucket 3\",V12)+IF(trans4=\"bucket 3\",Z12)+IF(trans5=\"bucket 3\",AB12))*(1+H13),0)","v":23},{"$f":"ROUND((R12-Y12-Z12+IF(trans2=\"bucket 4\",V12)+IF(trans3=\"bucket 4\",X12)+IF(trans5=\"bucket 4\",AB12))*(1+J13),0)","v":23},{"$f":"ROUND((S12-AA12-AB12+IF(trans2=\"bucket 5\",V12)+IF(trans3=\"bucket 5\",X12)+IF(trans4=\"bucket 5\",Z12))*(1+M13),0)","v":34},null,null,null,null,null,null,null,null,null,null,{"$f":"AD12+1","v":1},null,null,null,null,null,null,null,null,{"$f":"IF($O13<$B13,$B13-$O13,0)","v":0},{"$f":"IF($O13<$B13,AD13,0)","v":0},null,null,null,{"$f":"IF(AQ13<>0,IF(SUM(O13:S13)<0,NA(),SUM(O13:S13)),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AQ13<>0,IF(AS12*(1+retroi)-(prepen1/100000)*(1+rinf)^AQ13<0,NA(),AS12*(1+retroi)-(prepen1/100000)*(1+rinf)^AQ13),NA())","v":{"$error":"#N/A"}},{"$f":"IF(AQ13<>0,IF((AT12-B12)*(1+alloc1*Simulator!E13+alloc2*Simulator!F13+alloc3*Simulator!H13+alloc4*Simulator!J13+alloc5*Simulator!M13)<0,NA(),(AT12-B12)*(1+alloc1*Simulator!E13+alloc2*Simulator!F13+alloc3*Simulator!H13+alloc4*Simulator!J13+alloc5*Simulator!M13)),NA())","v":{"$error":"#N/A"}},null,{"$f":"AV12*(1+F13)","v":1.1197423283856267},{"$f":"(AV13/$AV$12)^(1/AQ13)-1","v":{"$error":"#DIV/0!"}},{"$f":"AX12*(1+H13)","v":1.1413974064149255},{"$f":"(AX13/$AX$12)^(1/AQ13)-1","v":{"$error":"#DIV/0!"}},{"$f":"AZ12*(1+J13)","v":1.1438745832359833},{"$f":"(AZ13/$AZ$12)^(1/AQ13)-1","v":{"$error":"#DIV/0!"}},{"$f":"BB12*(1+M13)","v":1.7076106350024878},{"$f":"(BB13/$BB$12)^(1/AQ13)-1","v":{"$error":"#DIV/0!"}}]
[2,8.3925276636558053,null,0.05,0.05,9.2947180681354505E-2,9.2947180681354505E-2,0.19423190013038577,0.19423190013038577,0.17036358164652907,0.17036358164652907,-3.1231291178219434E-2,-3.1231291178219434E-2,null,{"$f":"IF(O13=\"no funds\",\"no funds\",IF((O13-B13+U13+W13+Y13+AA13)*(1+D14)<0,\"no funds\",ROUND((O13-B13+U13+W13+Y13+AA13)*(1+D14),0)))","v":83},61,27,27,33,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,{"$f":"IF($O14<$B14,$B14-$O14,0)","v":0},{"$f":"IF($O14<$B14,AD14,0)","v":0},null,null,null,{"$f":"IF(AQ14<>0,IF(SUM(O14:S14)<0,NA(),SUM(O14:S14)),NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(AQ14<>0,IF((AT13-B13)*(1+alloc1*Simulator!E14+alloc2*Simulator!F14+alloc3*Simulator!H14+alloc4*Simulator!J14+alloc5*Simulator!M14)<0,NA(),(AT13-B13)*(1+alloc1*Simulator!E14+alloc2*Simulator!F14+alloc3*Simulator!H14+alloc4*Simulator!J14+alloc5*Simulator!M14)),NA())","v":{"$error":"#N/A"}},null,{"$f":"AV13*(1+F14)","v":1.223819220898646},{"$error":"#DIV/0!"},{"$f":"AX13*(1+H14)","v":1.3630931934667907},{"$f":"(AX14/$AX$12)^(1/AQ14)-1","v":{"$error":"#DIV/0!"}},{"$f":"AZ13*(1+J14)","v":1.3387491541904961},{"$f":"(AZ14/$AZ$12)^(1/AQ14)-1","v":{"$error":"#DIV/0!"}},{"$f":"BB13*(1+M14)","v":1.6542797500417008},{"$f":"(BB14/$BB$12)^(1/AQ14)-1","v":{"$error":"#DIV/0!"}}]
[3,9.0997298767482722,null,0.05,0.05,5.6812678970990925E-2,5.6812678970990925E-2,0.10114182441148691,0.10114182441148691,0.10603073306064252,0.10603073306064252,-0.22176079945977326,-0.22176079945977326,null,78,64,30,30,26,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,0,0,"Bucket 2",null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ15<>0,IF((AT14-B14)*(1+alloc1*Simulator!E15+alloc2*Simulator!F15+alloc3*Simulator!H15+alloc4*Simulator!J15+alloc5*Simulator!M15)<0,NA(),(AT14-B14)*(1+alloc1*Simulator!E15+alloc2*Simulator!F15+alloc3*Simulator!H15+alloc4*Simulator!J15+alloc5*Simulator!M15)),NA())","v":{"$error":"#N/A"}},null,1.2933476694140889,{"$error":"#DIV/0!"},1.5009589258969018,{"$error":"#DIV/0!"},1.4806977083936295,{"$error":"#DIV/0!"},1.2874253501423394,{"$error":"#DIV/0!"}]
[4,9.8610882668881352,null,0.05,0.05,0.13784381000320323,0.13784381000320323,0.15158367463447675,0.15158367463447675,-0.20614057706544064,-0.20614057706544064,0.35504115338700992,0.35504115338700992,null,72,73,35,24,35,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,0,0,"Bucket 4",null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ16<>0,IF((AT15-B15)*(1+alloc1*Simulator!E16+alloc2*Simulator!F16+alloc3*Simulator!H16+alloc4*Simulator!J16+alloc5*Simulator!M16)<0,NA(),(AT15-B15)*(1+alloc1*Simulator!E16+alloc2*Simulator!F16+alloc3*Simulator!H16+alloc4*Simulator!J16+alloc5*Simulator!M16)),NA())","v":{"$error":"#N/A"}},null,1.4716276398248904,{"$error":"#DIV/0!"},1.7284797953597715,{"$error":"#DIV/0!"},1.1754658283258912,{"$error":"#DIV/0!"},1.7445143313565508,{"$error":"#DIV/0!"}]
[5,10.680693328239183,null,0.05,0.05,5.7540041808505263E-2,5.7540041808505263E-2,8.960432383408741E-2,8.960432383408741E-2,-0.20275521395388424,-0.20275521395388424,-0.40658749665233374,-0.40658749665233374,null,65,77,38,19,21,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,null,0,0,"Bucket 5",null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ17<>0,IF((AT16-B16)*(1+alloc1*Simulator!E17+alloc2*Simulator!F17+alloc3*Simulator!H17+alloc4*Simulator!J17+alloc5*Simulator!M17)<0,NA(),(AT16-B16)*(1+alloc1*Simulator!E17+alloc2*Simulator!F17+alloc3*Simulator!H17+alloc4*Simulator!J17+alloc5*Simulator!M17)),NA())","v":{"$error":"#N/A"}},null,1.5563051557469665,{"$error":"#DIV/0!"},1.8833590586838656,{"$error":"#DIV/0!"},0.93713400280819548,{"$error":"#DIV/0!"},1.0352166164961709,{"$error":"#DIV/0!"}]
[6,11.562938594498322,null,0.05,0.05,7.784150522918018E-2,7.784150522918018E-2,8.3930243039595509E-2,8.3930243039595509E-2,0.40291155167544801,0.40291155167544801,0.32577676792652249,0.32577676792652249,null,57,83,41,27,28,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ18<>0,IF((AT17-B17)*(1+alloc1*Simulator!E18+alloc2*Simulator!F18+alloc3*Simulator!H18+alloc4*Simulator!J18+alloc5*Simulator!M18)<0,NA(),(AT17-B17)*(1+alloc1*Simulator!E18+alloc2*Simulator!F18+alloc3*Simulator!H18+alloc4*Simulator!J18+alloc5*Simulator!M18)),NA())","v":{"$error":"#N/A"}},null,1.6774502916662439,{"$error":"#DIV/0!"},2.0414298422100265,{"$error":"#DIV/0!"},1.3147161180074691,{"$error":"#DIV/0!"},1.3724661399221239,{"$error":"#DIV/0!"}]
[7,12.512542462058187,null,0.05,0.05,9.9238296886664107E-2,9.9238296886664107E-2,0.21212692474437295,0.21212692474437295,5.074483666773244E-2,5.074483666773244E-2,0.19574362786413974,0.19574362786413974,null,48,91,50,28,33,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,0,0,"Bucket 2",null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ19<>0,IF((AT18-B18)*(1+alloc1*Simulator!E19+alloc2*Simulator!F19+alloc3*Simulator!H19+alloc4*Simulator!J19+alloc5*Simulator!M19)<0,NA(),(AT18-B18)*(1+alloc1*Simulator!E19+alloc2*Simulator!F19+alloc3*Simulator!H19+alloc4*Simulator!J19+alloc5*Simulator!M19)),NA())","v":{"$error":"#N/A"}},null,1.8439176017232399,{"$error":"#DIV/0!"},2.4744720767194299,{"$error":"#DIV/0!"},1.3814311726801933,{"$error":"#DIV/0!"},1.6411176412711725,{"$error":"#DIV/0!"}]
[8,13.53457151702284,null,0.05,0.05,0.11456173960446914,0.11456173960446914,0.19179101687202324,0.19179101687202324,-3.4637232764829384E-2,-3.4637232764829384E-2,0.38774630332929416,0.38774630332929416,null,37,101,60,27,46,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,0,0,"Bucket 3",null,null,{"$f":"IF(AQ20=SUM(AN7:AN1106),NA(),IF(AQ20<>0,IF(SUM(O20:S20)<0,NA(),SUM(O20:S20)),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(AQ20=SUM(AN7:AN1106),NA(),IF(AQ20<>0,IF(AS19*(1+retroi)-(prepen1/100000)*(1+rinf)^AQ20<0,NA(),AS19*(1+retroi)-(prepen1/100000)*(1+rinf)^AQ20),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(AQ20=SUM(AN7:AN1106),NA(),IF(AQ20<>0,IF((AT19-B19)*(1+alloc1*Simulator!E20+alloc2*Simulator!F20+alloc3*Simulator!H20+alloc4*Simulator!J20+alloc5*Simulator!M20)<0,NA(),(AT19-B19)*(1+alloc1*Simulator!E20+alloc2*Simulator!F20+alloc3*Simulator!H20+alloc4*Simulator!J20+alloc5*Simulator!M20)),NA()))","v":{"$error":"#N/A"}},null,2.0551600098639549,{"$error":"#DIV/0!"},2.9490535925348764,{"$error":"#DIV/0!"},1.3335822196034781,{"$error":"#DIV/0!"},2.2774549400025603,{"$error":"#DIV/0!"}]
[9,14.63446546218467,null,0.05,0.05,0.10474679019487296,0.10474679019487296,0.16809279636216851,0.16809279636216851,0.16181512826752997,0.16181512826752997,0.241884884619541,0.241884884619541,null,25,112,70,31,57,null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,0,0,"Bucket 5",null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ21=SUM(AN8:AN1107),NA(),IF(AQ21<>0,IF((AT20-B20)*(1+alloc1*Simulator!E21+alloc2*Simulator!F21+alloc3*Simulator!H21+alloc4*Simulator!J21+alloc5*Simulator!M21)<0,NA(),(AT20-B20)*(1+alloc1*Simulator!E21+alloc2*Simulator!F21+alloc3*Simulator!H21+alloc4*Simulator!J21+alloc5*Simulator!M21)),NA()))","v":{"$error":"#N/A"}},null,2.2704314242340673,{"$error":"#DIV/0!"},3.4447682575259631,{"$error":"#DIV/0!"},1.5493759975239123,{"$error":"#DIV/0!"},2.8283368653912833,{"$error":"#DIV/0!"}]
[10,15.818063745339446,null,0.05,0.05,4.3273457149784596E-2,4.3273457149784596E-2,0.11391566703034367,0.11391566703034367,-2.4180812338924856E-2,-2.4180812338924856E-2,0.54634495324625987,0.54634495324625987,null,11,117,78,30,88,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,4.8180637453394457,10,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ22=SUM(AN9:AN1108),NA(),IF(AQ22<>0,IF((AT21-B21)*(1+alloc1*Simulator!E22+alloc2*Simulator!F22+alloc3*Simulator!H22+alloc4*Simulator!J22+alloc5*Simulator!M22)<0,NA(),(AT21-B21)*(1+alloc1*Simulator!E22+alloc2*Simulator!F22+alloc3*Simulator!H22+alloc4*Simulator!J22+alloc5*Simulator!M22)),NA()))","v":{"$error":"#N/A"}},null,2.3686808411821847,{"$error":"#DIV/0!"},3.8371813313469878,{"$error":"#DIV/0!"},1.5119108272853521,{"$error":"#DIV/0!"},4.373584437878157,{"$error":"#DIV/0!"}]
[11,17.091633995764596,null,0.05,0.05,0.10431655275206744,0.10431655275206744,0.23317598958458535,0.23317598958458535,0.13277830392235729,0.13277830392235729,0.50771210577189907,0.50771210577189907,null,"no funds",129,96,34,133,null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ23=SUM(AN10:AN1109),NA(),IF(AQ23<>0,IF((AT22-B22)*(1+alloc1*Simulator!E23+alloc2*Simulator!F23+alloc3*Simulator!H23+alloc4*Simulator!J23+alloc5*Simulator!M23)<0,NA(),(AT22-B22)*(1+alloc1*Simulator!E23+alloc2*Simulator!F23+alloc3*Simulator!H23+alloc4*Simulator!J23+alloc5*Simulator!M23)),NA()))","v":{"$error":"#N/A"}},null,2.6157734611041779,{"$error":"#DIV/0!"},4.7319198854993179,{"$error":"#DIV/0!"},1.7126597826141492,{"$error":"#DIV/0!"},6.5941062026044834,{"$error":"#DIV/0!"}]
[12,18.461902381303567,null,0.05,0.05,0.10088728686100619,0.10088728686100619,0.21205788398045611,0.21205788398045611,-0.10235807448158529,-0.10235807448158529,-0.3694028503131398,-0.3694028503131398,null,"no funds",142,116,31,84,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ24=SUM(AN11:AN1110),NA(),IF(AQ24<>0,IF((AT23-B23)*(1+alloc1*Simulator!E24+alloc2*Simulator!F24+alloc3*Simulator!H24+alloc4*Simulator!J24+alloc5*Simulator!M24)<0,NA(),(AT23-B23)*(1+alloc1*Simulator!E24+alloc2*Simulator!F24+alloc3*Simulator!H24+alloc4*Simulator!J24+alloc5*Simulator!M24)),NA()))","v":{"$error":"#N/A"}},null,2.8796717486380023,{"$error":"#DIV/0!"},5.7353608035833457,{"$error":"#DIV/0!"},1.5373552250237144,{"$error":"#DIV/0!"},4.1582245760948329,{"$error":"#DIV/0!"}]
[13,19.936086004273434,null,0.05,0.05,7.1206530400693274E-2,7.1206530400693274E-2,5.389209612743049E-2,5.389209612743049E-2,1.0118812499680996E-2,1.0118812499680996E-2,0.24509951675679406,0.24509951675679406,null,"no funds",152,122,31,105,null,null,null,null,null,null,null,null,null,null,13,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ25=SUM(AN12:AN1111),NA(),IF(AQ25<>0,IF((AT24-B24)*(1+alloc1*Simulator!E25+alloc2*Simulator!F25+alloc3*Simulator!H25+alloc4*Simulator!J25+alloc5*Simulator!M25)<0,NA(),(AT24-B24)*(1+alloc1*Simulator!E25+alloc2*Simulator!F25+alloc3*Simulator!H25+alloc4*Simulator!J25+alloc5*Simulator!M25)),NA()))","v":{"$error":"#N/A"}},null,3.0847231825514116,{"$error":"#DIV/0!"},6.0444514193355561,{"$error":"#DIV/0!"},1.5529114342911341,{"$error":"#DIV/0!"},5.1774034102619009,{"$error":"#DIV/0!"}]
[14,21.521927460327451,null,0.05,0.05,7.944764781989315E-2,7.944764781989315E-2,2.1203051146014423E-3,2.1203051146014423E-3,0.18341686008334615,0.18341686008334615,-0.31739320701080787,-0.31739320701080787,null,"no funds",164,122,37,72,null,null,null,null,null,null,null,null,null,null,14,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(AQ26=SUM(AN13:AN1112),NA(),IF(AQ26<>0,IF(SUM(O26:S26)<0,NA(),SUM(O26:S26)),NA()))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(AQ26=SUM(AN13:AN1112),NA(),IF(AQ26<>0,IF((AT25-B25)*(1+alloc1*Simulator!E26+alloc2*Simulator!F26+alloc3*Simulator!H26+alloc4*Simulator!J26+alloc5*Simulator!M26)<0,NA(),(AT25-B25)*(1+alloc1*Simulator!E26+alloc2*Simulator!F26+alloc3*Simulator!H26+alloc4*Simulator!J26+alloc5*Simulator!M26)),NA()))","v":{"$error":"#N/A"}},null,3.3297971835806162,{"$error":"#DIV/0!"},6.057267500594933,{"$error":"#DIV/0!"},1.8377415735563394,{"$error":"#DIV/0!"},3.5341307378901829,{"$error":"#DIV/0!"}]
[15,23.227731690437,null,0.05,0.05,0.15999309445391999,0.15999309445391999,7.531236967622118E-3,7.531236967622118E-3,0.2898991327902396,0.2898991327902396,-0.13660192386543182,-0.13660192386543182,null,"no funds",190,123,48,62,null,null,null,null,null,null,null,null,null,null,15,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ27=SUM(AN14:AN1113),NA(),IF(AQ27<>0,IF((AT26-B26)*(1+alloc1*Simulator!E27+alloc2*Simulator!F27+alloc3*Simulator!H27+alloc4*Simulator!J27+alloc5*Simulator!M27)<0,NA(),(AT26-B26)*(1+alloc1*Simulator!E27+alloc2*Simulator!F27+alloc3*Simulator!H27+alloc4*Simulator!J27+alloc5*Simulator!M27)),NA()))","v":{"$error":"#N/A"}},null,3.8625417388856267,{"$error":"#DIV/0!"},6.1028862175181899,{"$error":"#DIV/0!"},2.3705012620228927,{"$error":"#DIV/0!"},3.0513616799024259,{"$error":"#DIV/0!"}]
[16,25.062405262283647,null,0.05,0.05,9.2701710253559069E-2,9.2701710253559069E-2,-0.1175427107060048,-0.1175427107060048,0.23077094362937947,0.23077094362937947,-0.23509872360643722,-0.23509872360643722,null,"no funds",208,109,59,47,null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ28=SUM(AN15:AN1114),NA(),IF(AQ28<>0,IF((AT27-B27)*(1+alloc1*Simulator!E28+alloc2*Simulator!F28+alloc3*Simulator!H28+alloc4*Simulator!J28+alloc5*Simulator!M28)<0,NA(),(AT27-B27)*(1+alloc1*Simulator!E28+alloc2*Simulator!F28+alloc3*Simulator!H28+alloc4*Simulator!J28+alloc5*Simulator!M28)),NA()))","v":{"$error":"#N/A"}},null,4.2206059640060802,{"$error":"#DIV/0!"},5.3855364283807861,{"$error":"#DIV/0!"},2.9175440751345505,{"$error":"#DIV/0!"},2.3339904436957712,{"$error":"#DIV/0!"}]
[17,27.035498223539193,null,0.05,0.05,0.11411539704295119,0.11411539704295119,9.5922787264114837E-2,9.5922787264114837E-2,-0.14913530929841179,-0.14913530929841179,-0.14448591185601276,-0.14448591185601276,null,"no funds",232,119,50,40,null,null,null,null,null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ29=SUM(AN16:AN1115),NA(),IF(AQ29<>0,IF((AT28-B28)*(1+alloc1*Simulator!E29+alloc2*Simulator!F29+alloc3*Simulator!H29+alloc4*Simulator!J29+alloc5*Simulator!M29)<0,NA(),(AT28-B28)*(1+alloc1*Simulator!E29+alloc2*Simulator!F29+alloc3*Simulator!H29+alloc4*Simulator!J29+alloc5*Simulator!M29)),NA()))","v":{"$error":"#N/A"}},null,4.7022420893504817,{"$error":"#DIV/0!"},5.9021320935034973,{"$error":"#DIV/0!"},2.4824352370976106,{"$error":"#DIV/0!"},1.9967617061751679,{"$error":"#DIV/0!"}]
[18,29.157248675722474,null,0.05,0.05,6.3585582816616526E-2,6.3585582816616526E-2,3.984398377709502E-2,3.984398377709502E-2,0.15020348369873895,0.15020348369873895,0.38595009303088135,0.38595009303088135,null,"no funds",247,124,58,55,null,null,null,null,null,null,null,null,null,null,18,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ30=SUM(AN17:AN1116),NA(),IF(AQ30<>0,IF((AT29-B29)*(1+alloc1*Simulator!E30+alloc2*Simulator!F30+alloc3*Simulator!H30+alloc4*Simulator!J30+alloc5*Simulator!M30)<0,NA(),(AT29-B29)*(1+alloc1*Simulator!E30+alloc2*Simulator!F30+alloc3*Simulator!H30+alloc4*Simulator!J30+alloc5*Simulator!M30)),NA()))","v":{"$error":"#N/A"}},null,5.0012368931466566,{"$error":"#DIV/0!"},6.1372965488873223,{"$error":"#DIV/0!"},2.8553056577661766,{"$error":"#DIV/0!"},2.7674120724339755,{"$error":"#DIV/0!"}]
[19,31.438630223510426,null,0.05,0.05,0.10213342899752617,0.10213342899752617,-2.8701014174204481E-2,-2.8701014174204481E-2,0.31679192023731184,0.31679192023731184,0.33533842818932508,0.33533842818932508,null,"no funds",272,120,76,73,null,null,null,null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ31=SUM(AN18:AN1117),NA(),IF(AQ31<>0,IF((AT30-B30)*(1+alloc1*Simulator!E31+alloc2*Simulator!F31+alloc3*Simulator!H31+alloc4*Simulator!J31+alloc5*Simulator!M31)<0,NA(),(AT30-B30)*(1+alloc1*Simulator!E31+alloc2*Simulator!F31+alloc3*Simulator!H31+alloc4*Simulator!J31+alloc5*Simulator!M31)),NA()))","v":{"$error":"#N/A"}},null,5.5120303662726595,{"$error":"#DIV/0!"},5.9611499136464117,{"$error":"#DIV/0!"},3.7598434199543846,{"$error":"#DIV/0!"},3.6954316869561472,{"$error":"#DIV/0!"}]
[20,33.891402460494426,null,0.05,0.05,5.1214218270029234E-2,5.1214218270029234E-2,9.0438748062552546E-2,9.0438748062552546E-2,0.28452723605881813,0.28452723605881813,0.12411173507279959,0.12411173507279959,null,"no funds",286,131,98,82,null,null,null,null,null,null,null,null,null,null,20,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ32=SUM(AN19:AN1118),NA(),IF(AQ32<>0,IF((AT31-B31)*(1+alloc1*Simulator!E32+alloc2*Simulator!F32+alloc3*Simulator!H32+alloc4*Simulator!J32+alloc5*Simulator!M32)<0,NA(),(AT31-B31)*(1+alloc1*Simulator!E32+alloc2*Simulator!F32+alloc3*Simulator!H32+alloc4*Simulator!J32+alloc5*Simulator!M32)),NA()))","v":{"$error":"#N/A"}},null,5.7943246925619771,{"$error":"#DIV/0!"},6.5002688488497862,{"$error":"#DIV/0!"},4.8296212762479396,{"$error":"#DIV/0!"},4.1540781254672776,{"$error":"#DIV/0!"}]
[21,36.528164658347471,null,0.05,0.05,0.10133804416462995,0.10133804416462995,-0.10966060718486084,-0.10966060718486084,0.12740422335054508,0.12740422335054508,0.13374623338277897,0.13374623338277897,null,"no funds",315,117,110,93,null,null,null,null,null,null,null,null,null,null,21,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ33=SUM(AN20:AN1119),NA(),IF(AQ33<>0,IF((AT32-B32)*(1+alloc1*Simulator!E33+alloc2*Simulator!F33+alloc3*Simulator!H33+alloc4*Simulator!J33+alloc5*Simulator!M33)<0,NA(),(AT32-B32)*(1+alloc1*Simulator!E33+alloc2*Simulator!F33+alloc3*Simulator!H33+alloc4*Simulator!J33+alloc5*Simulator!M33)),NA()))","v":{"$error":"#N/A"}},null,6.381510224161028,{"$error":"#DIV/0!"},5.7874454200200827,{"$error":"#DIV/0!"},5.4449354240255765,{"$error":"#DIV/0!"},4.7096704279263211,{"$error":"#DIV/0!"}]
[22,39.362412832130119,null,0.05,0.05,0.10020167952345353,0.10020167952345353,-6.5057755664792632E-2,-6.5057755664792632E-2,0.12304891991182931,0.12304891991182931,-0.72321695316312662,-0.72321695316312662,null,"no funds",347,109,124,26,null,null,null,null,null,null,null,null,null,null,22,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ34=SUM(AN21:AN1120),NA(),IF(AQ34<>0,IF((AT33-B33)*(1+alloc1*Simulator!E34+alloc2*Simulator!F34+alloc3*Simulator!H34+alloc4*Simulator!J34+alloc5*Simulator!M34)<0,NA(),(AT33-B33)*(1+alloc1*Simulator!E34+alloc2*Simulator!F34+alloc3*Simulator!H34+alloc4*Simulator!J34+alloc5*Simulator!M34)),NA()))","v":{"$error":"#N/A"}},null,7.0209482665180536,{"$error":"#DIV/0!"},5.410927209961093,{"$error":"#DIV/0!"},6.1149288469415817,{"$error":"#DIV/0!"},1.3035569306389685,{"$error":"#DIV/0!"}]
[23,42.408600359926851,null,0.05,0.05,0.1194986904064289,0.1194986904064289,9.9530179648183795E-2,9.9530179648183795E-2,0.10490771543467775,0.10490771543467775,0.13707919517196834,0.13707919517196834,null,"no funds",388,120,137,30,null,null,null,null,null,null,null,null,null,null,23,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ35=SUM(AN22:AN1121),NA(),IF(AQ35<>0,IF((AT34-B34)*(1+alloc1*Simulator!E35+alloc2*Simulator!F35+alloc3*Simulator!H35+alloc4*Simulator!J35+alloc5*Simulator!M35)<0,NA(),(AT34-B34)*(1+alloc1*Simulator!E35+alloc2*Simulator!F35+alloc3*Simulator!H35+alloc4*Simulator!J35+alloc5*Simulator!M35)),NA()))","v":{"$error":"#N/A"}},null,7.8599423897782472,{"$error":"#DIV/0!"},5.949477767231766,{"$error":"#DIV/0!"},6.7564320623198313,{"$error":"#DIV/0!"},1.4822474655517996,{"$error":"#DIV/0!"}]
[24,45.682202340069949,null,0.05,0.05,0.1042749062020316,0.1042749062020316,0.1375062773868217,0.1375062773868217,0.77948273071023777,0.77948273071023777,-0.28625276589821114,-0.28625276589821114,null,"no funds",428,137,244,21,null,null,null,null,null,null,null,null,null,null,24,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ36=SUM(AN23:AN1122),NA(),IF(AQ36<>0,IF((AT35-B35)*(1+alloc1*Simulator!E36+alloc2*Simulator!F36+alloc3*Simulator!H36+alloc4*Simulator!J36+alloc5*Simulator!M36)<0,NA(),(AT35-B35)*(1+alloc1*Simulator!E36+alloc2*Simulator!F36+alloc3*Simulator!H36+alloc4*Simulator!J36+alloc5*Simulator!M36)),NA()))","v":{"$error":"#N/A"}},null,8.6795371452257459,{"$error":"#DIV/0!"},6.7675683073994657,{"$error":"#DIV/0!"},12.022954176115098,{"$error":"#DIV/0!"},1.0579500287919836,{"$error":"#DIV/0!"}]
[25,49.199783873759394,null,0.05,0.05,7.1961556833159065E-2,7.1961556833159065E-2,1.2275873133696408E-2,1.2275873133696408E-2,7.0565136863336292E-2,7.0565136863336292E-2,0.10919001617896021,0.10919001617896021,null,"no funds",459,139,261,23,null,null,null,null,null,null,null,null,null,null,25,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ37=SUM(AN24:AN1123),NA(),IF(AQ37<>0,IF((AT36-B36)*(1+alloc1*Simulator!E37+alloc2*Simulator!F37+alloc3*Simulator!H37+alloc4*Simulator!J37+alloc5*Simulator!M37)<0,NA(),(AT36-B36)*(1+alloc1*Simulator!E37+alloc2*Simulator!F37+alloc3*Simulator!H37+alloc4*Simulator!J37+alloc5*Simulator!M37)),NA()))","v":{"$error":"#N/A"}},null,9.3041301507874241,{"$error":"#DIV/0!"},6.8506461173647271,{"$error":"#DIV/0!"},12.87135558305428,{"$error":"#DIV/0!"},1.1734676095523118,{"$error":"#DIV/0!"}]
[26,52.979072464792367,null,0.05,0.05,7.2909550372012591E-2,7.2909550372012591E-2,0.12470171061426875,0.12470171061426875,3.9852468693323567E-2,3.9852468693323567E-2,0.19696242586451487,0.19696242586451487,null,"no funds",492,156,271,28,null,null,null,null,null,null,null,null,null,null,26,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ38=SUM(AN25:AN1124),NA(),IF(AQ38<>0,IF((AT37-B37)*(1+alloc1*Simulator!E38+alloc2*Simulator!F38+alloc3*Simulator!H38+alloc4*Simulator!J38+alloc5*Simulator!M38)<0,NA(),(AT37-B37)*(1+alloc1*Simulator!E38+alloc2*Simulator!F38+alloc3*Simulator!H38+alloc4*Simulator!J38+alloc5*Simulator!M38)),NA()))","v":{"$error":"#N/A"}},null,9.9824900966840211,{"$error":"#DIV/0!"},7.7049334070131064,{"$error":"#DIV/0!"},13.384310878468584,{"$error":"#DIV/0!"},1.4045966366031684,{"$error":"#DIV/0!"}]
[27,57.039034731221214,null,0.05,0.05,3.7970094578604348E-2,3.7970094578604348E-2,0.15833080271123559,0.15833080271123559,0.16506538086060954,0.16506538086060954,-0.21212207417247184,-0.21212207417247184,null,"no funds",511,181,316,22,null,null,null,null,null,null,null,null,null,null,27,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ39=SUM(AN26:AN1125),NA(),IF(AQ39<>0,IF((AT38-B38)*(1+alloc1*Simulator!E39+alloc2*Simulator!F39+alloc3*Simulator!H39+alloc4*Simulator!J39+alloc5*Simulator!M39)<0,NA(),(AT38-B38)*(1+alloc1*Simulator!E39+alloc2*Simulator!F39+alloc3*Simulator!H39+alloc4*Simulator!J39+alloc5*Simulator!M39)),NA()))","v":{"$error":"#N/A"}},null,10.361526189785094,{"$error":"#DIV/0!"},8.9248616981821058,{"$error":"#DIV/0!"},15.5935972511798,{"$error":"#DIV/0!"},1.1066506846712265,{"$error":"#DIV/0!"}]
[28,61.399957625888923,null,0.05,0.05,9.0975506992458641E-2,9.0975506992458641E-2,-5.5188125433841412E-2,-5.5188125433841412E-2,0.15347739096149546,0.15347739096149546,0.24639435898662845,0.24639435898662845,null,"no funds",557,171,364,27,null,null,null,null,null,null,null,null,null,null,28,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$f":"IF(AQ40=SUM(AN27:AN1126),NA(),IF(AQ40<>0,IF(AS39*(1+retroi)-(prepen1/100000)*(1+rinf)^AQ40<0,NA(),AS39*(1+retroi)-(prepen1/100000)*(1+rinf)^AQ40),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(AQ40=SUM(AN27:AN1126),NA(),IF(AQ40<>0,IF((AT39-B39)*(1+alloc1*Simulator!E40+alloc2*Simulator!F40+alloc3*Simulator!H40+alloc4*Simulator!J40+alloc5*Simulator!M40)<0,NA(),(AT39-B39)*(1+alloc1*Simulator!E40+alloc2*Simulator!F40+alloc3*Simulator!H40+alloc4*Simulator!J40+alloc5*Simulator!M40)),NA()))","v":{"$error":"#N/A"}},null,11.304171288116432,{"$f":"(AV40/$AV$12)^(1/AQ40)-1","v":{"$error":"#DIV/0!"}},8.4323153113031442,{"$f":"(AX40/$AX$12)^(1/AQ40)-1","v":{"$error":"#DIV/0!"}},17.986861872995224,{"$f":"(AZ40/$AZ$12)^(1/AQ40)-1","v":{"$error":"#DIV/0!"}},1.3793231707429068,{"$f":"(BB40/$BB$12)^(1/AQ40)-1","v":{"$error":"#DIV/0!"}}]
[29,66.083534363747034,null,0.05,0.05,5.5236247007730208E-2,5.5236247007730208E-2,0.18721343735384449,0.18721343735384449,-0.13072119708839625,-0.13072119708839625,-0.19557603264566512,-0.19557603264566512,null,"no funds",588,203,316,22,null,null,null,null,null,null,null,null,null,null,29,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ41=SUM(AN28:AN1127),NA(),IF(AQ41<>0,IF((AT40-B40)*(1+alloc1*Simulator!E41+alloc2*Simulator!F41+alloc3*Simulator!H41+alloc4*Simulator!J41+alloc5*Simulator!M41)<0,NA(),(AT40-B40)*(1+alloc1*Simulator!E41+alloc2*Simulator!F41+alloc3*Simulator!H41+alloc4*Simulator!J41+alloc5*Simulator!M41)),NA()))","v":{"$error":"#N/A"}},null,11.928571285604523,{"$error":"#DIV/0!"},10.01095804558366,{"$error":"#DIV/0!"},15.635597757093656,{"$error":"#DIV/0!"},1.1095606172727697,{"$error":"#DIV/0!"}]
[30,71.112955253412508,null,0.05,0.05,8.8414540071405617E-2,8.8414540071405617E-2,0.15640712856717814,0.15640712856717814,0.16008072230248796,0.16008072230248796,-0.32913078757844516,-0.32913078757844516,null,"no funds",640,235,367,15,null,null,null,null,null,null,null,null,null,null,30,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ42=SUM(AN29:AN1128),NA(),IF(AQ42<>0,IF((AT41-B41)*(1+alloc1*Simulator!E42+alloc2*Simulator!F42+alloc3*Simulator!H42+alloc4*Simulator!J42+alloc5*Simulator!M42)<0,NA(),(AT41-B41)*(1+alloc1*Simulator!E42+alloc2*Simulator!F42+alloc3*Simulator!H42+alloc4*Simulator!J42+alloc5*Simulator!M42)),NA()))","v":{"$error":"#N/A"}},null,12.983230429530222,{"$error":"#DIV/0!"},11.576743247699891,{"$error":"#DIV/0!"},18.138555539680372,{"$error":"#DIV/0!"},0.74437005744375717,{"$error":"#DIV/0!"}]
[31,76.513003628307786,null,0.05,0.05,7.9732912959573771E-2,7.9732912959573771E-2,0.19721632272930831,0.19721632272930831,0.2332679034165677,0.2332679034165677,-0.10951496424374388,-0.10951496424374388,null,"no funds",691,281,453,13,null,null,null,null,null,null,null,null,null,null,31,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ43=SUM(AN30:AN1129),NA(),IF(AQ43<>0,IF((AT42-B42)*(1+alloc1*Simulator!E43+alloc2*Simulator!F43+alloc3*Simulator!H43+alloc4*Simulator!J43+alloc5*Simulator!M43)<0,NA(),(AT42-B42)*(1+alloc1*Simulator!E43+alloc2*Simulator!F43+alloc3*Simulator!H43+alloc4*Simulator!J43+alloc5*Simulator!M43)),NA()))","v":{"$error":"#N/A"}},null,14.018421211302046,{"$error":"#DIV/0!"},13.859865980192613,{"$error":"#DIV/0!"},22.369698361426583,{"$error":"#DIV/0!"},0.66285039721869055,{"$error":"#DIV/0!"}]
[32,{"$f":"(prepen1*(1+rinf)^A44/100000)-(pension/100000)-(income*(1+incrate)^A44/100000)","v":82.310157068656906},null,0.05,0.05,0.11901207991484897,0.11901207991484897,0.14394551895364643,0.14394551895364643,-0.1358400053369278,-0.1358400053369278,0.30898131249030664,0.30898131249030664,null,"no funds",773,321,391,17,null,null,null,null,null,null,null,null,null,null,32,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ44=SUM(AN31:AN1130),NA(),IF(AQ44<>0,IF((AT43-B43)*(1+alloc1*Simulator!E44+alloc2*Simulator!F44+alloc3*Simulator!H44+alloc4*Simulator!J44+alloc5*Simulator!M44)<0,NA(),(AT43-B43)*(1+alloc1*Simulator!E44+alloc2*Simulator!F44+alloc3*Simulator!H44+alloc4*Simulator!J44+alloc5*Simulator!M44)),NA()))","v":{"$error":"#N/A"}},null,15.68678267678154,{"$error":"#DIV/0!"},15.854931581339429,{"$error":"#DIV/0!"},19.330998416624933,{"$error":"#DIV/0!"},0.86765878293604271,{"$error":"#DIV/0!"}]
[33,88.53269409924242,null,{"$f":"IF(E45<>\"\",E45,_min1)","v":0.05},0.05,0.12633254236641975,{"$f":"IF(F45<>\"\",F45,NORMINV(RAND(),mean2,stdev2))","v":0.12633254236641975},3.3997579752332294E-2,{"$f":"IF(H45<>\"\",H45,NORMINV(RAND(),mean3,stdev3))","v":3.3997579752332294E-2},0.43024031369898302,{"$f":"IF(J45<>\"\",J45,NORMINV(RAND(),mean4,stdev4))","v":0.43024031369898302},{"$f":"IF(M45<>\"\",M45,NORMINV(RAND(),mean5,stdev5))","v":0.18798016804221854},0.18798016804221854,null,"no funds",{"$f":"ROUND((P44-U44-V44+IF(trans3=\"bucket 2\",X44)+IF(trans4=\"bucket 2\",Z44)+IF(trans5=\"bucket 2\",AB44))*(1+F45),0)","v":871},{"$f":"ROUND((Q44-W44-X44+IF(trans2=\"bucket 3\",V44)+IF(trans4=\"bucket 3\",Z44)+IF(trans5=\"bucket 3\",AB44))*(1+H45),0)","v":332},{"$f":"ROUND((R44-Y44-Z44+IF(trans2=\"bucket 4\",V44)+IF(trans3=\"bucket 4\",X44)+IF(trans5=\"bucket 4\",AB44))*(1+J45),0)","v":559},{"$f":"ROUND((S44-AA44-AB44+IF(trans2=\"bucket 5\",V44)+IF(trans3=\"bucket 5\",X44)+IF(trans4=\"bucket 5\",Z44))*(1+M45),0)","v":20},null,null,null,null,null,null,null,null,null,null,33,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ45=SUM(AN32:AN1131),NA(),IF(AQ45<>0,IF((AT44-B44)*(1+alloc1*Simulator!E45+alloc2*Simulator!F45+alloc3*Simulator!H45+alloc4*Simulator!J45+alloc5*Simulator!M45)<0,NA(),(AT44-B44)*(1+alloc1*Simulator!E45+alloc2*Simulator!F45+alloc3*Simulator!H45+alloc4*Simulator!J45+alloc5*Simulator!M45)),NA()))","v":{"$error":"#N/A"}},null,17.668533813888864,{"$error":"#DIV/0!"},16.393960882243785,{"$error":"#DIV/0!"},27.647973239508186,{"$error":"#DIV/0!"},1.0307614267556668,{"$error":"#DIV/0!"}]
[34,95.210806538784055,null,0.05,0.05,5.8052712109138031E-2,5.8052712109138031E-2,9.7739317618488156E-2,9.7739317618488156E-2,0.1827068684335641,0.1827068684335641,0.23417170630975609,0.23417170630975609,null,"no funds",922,364,661,25,null,null,null,null,null,null,null,null,null,null,34,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ46=SUM(AN33:AN1132),NA(),IF(AQ46<>0,IF((AT45-B45)*(1+alloc1*Simulator!E46+alloc2*Simulator!F46+alloc3*Simulator!H46+alloc4*Simulator!J46+alloc5*Simulator!M46)<0,NA(),(AT45-B45)*(1+alloc1*Simulator!E46+alloc2*Simulator!F46+alloc3*Simulator!H46+alloc4*Simulator!J46+alloc5*Simulator!M46)),NA()))","v":{"$error":"#N/A"}},null,18.694240120777124,{"$error":"#DIV/0!"},17.996295431938481,{"$error":"#DIV/0!"},32.69944784863371,{"$error":"#DIV/0!"},1.2721365888573202,{"$error":"#DIV/0!"}]
[35,102.37671766464925,null,0.05,0.05,5.297954933976956E-2,5.297954933976956E-2,4.9498918827083641E-2,4.9498918827083641E-2,6.9819311436703876E-2,6.9819311436703876E-2,-0.25995087796893601,-0.25995087796893601,null,"no funds",971,382,707,19,null,null,null,null,null,null,null,null,null,null,35,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ47=SUM(AN34:AN1133),NA(),IF(AQ47<>0,IF((AT46-B46)*(1+alloc1*Simulator!E47+alloc2*Simulator!F47+alloc3*Simulator!H47+alloc4*Simulator!J47+alloc5*Simulator!M47)<0,NA(),(AT46-B46)*(1+alloc1*Simulator!E47+alloc2*Simulator!F47+alloc3*Simulator!H47+alloc4*Simulator!J47+alloc5*Simulator!M47)),NA()))","v":{"$error":"#N/A"}},null,19.684652537625336,{"$error":"#DIV/0!"},18.887092598712218,{"$error":"#DIV/0!"},34.982500781785724,{"$error":"#DIV/0!"},0.94144356568745247,{"$error":"#DIV/0!"}]
[36,110.06480634085992,null,0.05,0.05,7.3425774262160473E-2,7.3425774262160473E-2,0.18210557639203315,0.18210557639203315,-0.12904490301725419,-0.12904490301725419,-0.4213999871240649,-0.4213999871240649,null,"no funds",1042,452,616,11,null,null,null,null,null,null,null,null,null,null,36,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ48=SUM(AN35:AN1134),NA(),IF(AQ48<>0,IF((AT47-B47)*(1+alloc1*Simulator!E48+alloc2*Simulator!F48+alloc3*Simulator!H48+alloc4*Simulator!J48+alloc5*Simulator!M48)<0,NA(),(AT47-B47)*(1+alloc1*Simulator!E48+alloc2*Simulator!F48+alloc3*Simulator!H48+alloc4*Simulator!J48+alloc5*Simulator!M48)),NA()))","v":{"$error":"#N/A"}},null,21.130013391282077,{"$f":"(AV48/$AV$12)^(1/AQ48)-1","v":{"$error":"#DIV/0!"}},22.326537482770412,{"$f":"(AX48/$AX$12)^(1/AQ48)-1","v":{"$error":"#DIV/0!"}},30.468187361099165,{"$f":"(AZ48/$AZ$12)^(1/AQ48)-1","v":{"$error":"#DIV/0!"}},0.54471925922872622,{"$f":"(BB48/$BB$12)^(1/AQ48)-1","v":{"$error":"#DIV/0!"}}]
[37,118.31173723747131,null,0.05,0.05,0.11434033655289963,0.11434033655289963,-2.1746150739764714E-2,-2.1746150739764714E-2,0.37642509435774346,0.37642509435774346,-8.6183748735161575E-2,-8.6183748735161575E-2,null,"no funds",1161,442,848,10,null,null,null,null,null,null,null,null,null,null,37,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ49=SUM(AN36:AN1135),NA(),IF(AQ49<>0,IF((AT48-B48)*(1+alloc1*Simulator!E49+alloc2*Simulator!F49+alloc3*Simulator!H49+alloc4*Simulator!J49+alloc5*Simulator!M49)<0,NA(),(AT48-B48)*(1+alloc1*Simulator!E49+alloc2*Simulator!F49+alloc3*Simulator!H49+alloc4*Simulator!J49+alloc5*Simulator!M49)),NA()))","v":{"$error":"#N/A"}},null,23.546026233808547,{"$error":"#DIV/0!"},21.84102123317308,{"$error":"#DIV/0!"},41.937177663410324,{"$error":"#DIV/0!"},0.49777331146015436,{"$error":"#DIV/0!"}]
[38,127.15659724474588,null,0.05,0.05,0.18515675784694063,0.18515675784694063,0.16615182903547557,0.16615182903547557,-0.10509620438148437,-0.10509620438148437,0.55006370102741087,0.55006370102741087,null,"no funds",1376,515,759,16,null,null,null,null,null,null,null,null,null,null,38,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ50=SUM(AN37:AN1136),NA(),IF(AQ50<>0,IF((AT49-B49)*(1+alloc1*Simulator!E50+alloc2*Simulator!F50+alloc3*Simulator!H50+alloc4*Simulator!J50+alloc5*Simulator!M50)<0,NA(),(AT49-B49)*(1+alloc1*Simulator!E50+alloc2*Simulator!F50+alloc3*Simulator!H50+alloc4*Simulator!J50+alloc5*Simulator!M50)),NA()))","v":{"$error":"#N/A"}},null,27.905732111439548,{"$error":"#DIV/0!"},25.469946859067445,{"$error":"#DIV/0!"},37.529739468513931,{"$error":"#DIV/0!"},0.77158034143459697,{"$error":"#DIV/0!"}]
[39,136.64103815543007,null,0.05,0.05,0.10322834915789257,0.10322834915789257,4.9653816774246164E-2,4.9653816774246164E-2,0.25082218865882971,0.25082218865882971,-8.0587336697228534E-2,-8.0587336697228534E-2,null,"no funds",1518,541,949,15,null,null,null,null,null,null,null,null,null,null,39,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ51=SUM(AN38:AN1137),NA(),IF(AQ51<>0,IF((AT50-B50)*(1+alloc1*Simulator!E51+alloc2*Simulator!F51+alloc3*Simulator!H51+alloc4*Simulator!J51+alloc5*Simulator!M51)<0,NA(),(AT50-B50)*(1+alloc1*Simulator!E51+alloc2*Simulator!F51+alloc3*Simulator!H51+alloc4*Simulator!J51+alloc5*Simulator!M51)),NA()))","v":{"$error":"#N/A"}},null,30.78639476934584,{"$error":"#DIV/0!"},26.734626933657367,{"$error":"#DIV/0!"},46.943030861802264,{"$error":"#DIV/0!"},0.70940073667044456,{"$error":"#DIV/0!"}]
[40,146.80942565207948,null,0.05,0.05,6.14756391264598E-2,6.14756391264598E-2,9.2133336150332215E-2,9.2133336150332215E-2,0.40101885210818855,0.40101885210818855,0.30040849299486005,0.30040849299486005,null,"no funds",1611,591,1330,20,null,null,null,null,null,null,null,null,null,null,40,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$f":"IF(AQ52=SUM(AN39:AN1138),NA(),IF(AQ52<>0,IF(AS51*(1+retroi)-(prepen1/100000)*(1+rinf)^AQ52<0,NA(),AS51*(1+retroi)-(prepen1/100000)*(1+rinf)^AQ52),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(AQ52=SUM(AN39:AN1138),NA(),IF(AQ52<>0,IF((AT51-B51)*(1+alloc1*Simulator!E52+alloc2*Simulator!F52+alloc3*Simulator!H52+alloc4*Simulator!J52+alloc5*Simulator!M52)<0,NA(),(AT51-B51)*(1+alloc1*Simulator!E52+alloc2*Simulator!F52+alloc3*Simulator!H52+alloc4*Simulator!J52+alloc5*Simulator!M52)),NA()))","v":{"$error":"#N/A"}},null,32.679008064190874,{"$error":"#DIV/0!"},29.197777303789749,{"$error":"#DIV/0!"},65.768071212481473,{"$error":"#DIV/0!"},0.92251074290305635,{"$error":"#DIV/0!"}]
[41,157.70899459288233,null,0.05,0.05,7.5980215872801474E-2,7.5980215872801474E-2,2.2985521494670841E-2,2.2985521494670841E-2,5.7401747238934875E-3,5.7401747238934875E-3,0.35349306023476595,0.35349306023476595,null,"no funds",1733,605,1338,27,null,null,null,null,null,null,null,null,null,null,41,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ53=SUM(AN40:AN1139),NA(),IF(AQ53<>0,IF((AT52-B52)*(1+alloc1*Simulator!E53+alloc2*Simulator!F53+alloc3*Simulator!H53+alloc4*Simulator!J53+alloc5*Simulator!M53)<0,NA(),(AT52-B52)*(1+alloc1*Simulator!E53+alloc2*Simulator!F53+alloc3*Simulator!H53+alloc4*Simulator!J53+alloc5*Simulator!M53)),NA()))","v":{"$error":"#N/A"}},null,35.161966151417118,{"$error":"#DIV/0!"},29.868903441602619,{"$error":"#DIV/0!"},66.145591432494584,{"$error":"#DIV/0!"},1.2486118885113051,{"$error":"#DIV/0!"}]
[42,169.390010537813,null,0.05,0.05,0.11776729056253718,0.11776729056253718,0.30386664121808271,0.30386664121808271,0.15944320951101332,0.15944320951101332,0.36381186287262168,0.36381186287262168,null,"no funds",1937,789,1551,37,null,null,null,null,null,null,null,null,null,null,42,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ54=SUM(AN41:AN1140),NA(),IF(AQ54<>0,IF((AT53-B53)*(1+alloc1*Simulator!E54+alloc2*Simulator!F54+alloc3*Simulator!H54+alloc4*Simulator!J54+alloc5*Simulator!M54)<0,NA(),(AT53-B53)*(1+alloc1*Simulator!E54+alloc2*Simulator!F54+alloc3*Simulator!H54+alloc4*Simulator!J54+alloc5*Simulator!M54)),NA()))","v":{"$error":"#N/A"}},null,39.302895635921153,{"$error":"#DIV/0!"},38.94506680726964,{"$error":"#DIV/0!"},76.692056825495712,{"$error":"#DIV/0!"},1.7028717056755052,{"$error":"#DIV/0!"}]
[43,181.90593739608818,null,0.05,0.05,6.3995249105643137E-2,6.3995249105643137E-2,6.1019726000577285E-2,6.1019726000577285E-2,8.2374792491960253E-2,8.2374792491960253E-2,6.4376698283438311E-2,6.4376698283438311E-2,null,"no funds",2061,837,1679,39,null,null,null,null,null,null,null,null,null,null,43,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ55=SUM(AN42:AN1141),NA(),IF(AQ55<>0,IF((AT54-B54)*(1+alloc1*Simulator!E55+alloc2*Simulator!F55+alloc3*Simulator!H55+alloc4*Simulator!J55+alloc5*Simulator!M55)<0,NA(),(AT54-B54)*(1+alloc1*Simulator!E55+alloc2*Simulator!F55+alloc3*Simulator!H55+alloc4*Simulator!J55+alloc5*Simulator!M55)),NA()))","v":{"$error":"#N/A"}},null,41.818094232715019,{"$error":"#DIV/0!"},41.321484112923415,{"$error":"#DIV/0!"},83.009549092277538,{"$error":"#DIV/0!"},1.8124969636871813,{"$error":"#DIV/0!"}]
[44,195.31361100455041,null,0.05,0.05,7.7023167771770928E-2,7.7023167771770928E-2,0.30489370350774214,0.30489370350774214,0.39496972085843501,0.39496972085843501,8.2550971118536834E-2,8.2550971118536834E-2,null,"no funds",2220,1092,2342,42,null,null,null,null,null,null,null,null,null,null,44,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ56=SUM(AN43:AN1142),NA(),IF(AQ56<>0,IF((AT55-B55)*(1+alloc1*Simulator!E56+alloc2*Simulator!F56+alloc3*Simulator!H56+alloc4*Simulator!J56+alloc5*Simulator!M56)<0,NA(),(AT55-B55)*(1+alloc1*Simulator!E56+alloc2*Simulator!F56+alloc3*Simulator!H56+alloc4*Simulator!J56+alloc5*Simulator!M56)),NA()))","v":{"$error":"#N/A"}},null,45.039056320697156,{"$error":"#DIV/0!"},53.920144438548967,{"$error":"#DIV/0!"},115.79580752583895,{"$error":"#DIV/0!"},1.9621203481889575,{"$error":"#DIV/0!"}]
[45,209.67341836336709,null,0.05,0.05,7.3775241481719336E-2,7.3775241481719336E-2,0.15604554182307945,0.15604554182307945,-1.4665387825800485E-2,-1.4665387825800485E-2,0.13936110907612545,0.13936110907612545,null,"no funds",2384,1262,2308,48,null,null,null,null,null,null,null,null,null,null,45,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ57=SUM(AN44:AN1143),NA(),IF(AQ57<>0,IF((AT56-B56)*(1+alloc1*Simulator!E57+alloc2*Simulator!F57+alloc3*Simulator!H57+alloc4*Simulator!J57+alloc5*Simulator!M57)<0,NA(),(AT56-B56)*(1+alloc1*Simulator!E57+alloc2*Simulator!F57+alloc3*Simulator!H57+alloc4*Simulator!J57+alloc5*Simulator!M57)),NA()))","v":{"$error":"#N/A"}},null,48.361823576865348,{"$error":"#DIV/0!"},62.334142592641044,{"$error":"#DIV/0!"},114.09761709987077,{"$error":"#DIV/0!"},2.2355636160534043,{"$error":"#DIV/0!"}]
[46,225.04948215873441,null,0.05,0.05,3.2773640213063532E-2,3.2773640213063532E-2,0.23152602339172021,0.23152602339172021,-8.8669202645563633E-2,-8.8669202645563633E-2,5.1852055709194017E-2,5.1852055709194017E-2,null,"no funds",2462,1554,2103,50,null,null,null,null,null,null,null,null,null,null,46,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ58=SUM(AN45:AN1144),NA(),IF(AQ58<>0,IF((AT57-B57)*(1+alloc1*Simulator!E58+alloc2*Simulator!F58+alloc3*Simulator!H58+alloc4*Simulator!J58+alloc5*Simulator!M58)<0,NA(),(AT57-B57)*(1+alloc1*Simulator!E58+alloc2*Simulator!F58+alloc3*Simulator!H58+alloc4*Simulator!J58+alloc5*Simulator!M58)),NA()))","v":{"$error":"#N/A"}},null,49.946816582821192,{"$error":"#DIV/0!"},76.766118748647685,{"$error":"#DIV/0!"},103.9806723678664,{"$error":"#DIV/0!"},2.3514821852144525,{"$error":"#DIV/0!"}]
[47,241.50985009036097,null,0.05,0.05,0.11016515227526581,0.11016515227526581,8.2116316598320527E-2,8.2116316598320527E-2,0.43377669396138774,0.43377669396138774,0.15204215165939622,0.15204215165939622,null,"no funds",2733,1682,3015,58,null,null,null,null,null,null,null,null,null,null,47,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ59=SUM(AN46:AN1145),NA(),IF(AQ59<>0,IF((AT58-B58)*(1+alloc1*Simulator!E59+alloc2*Simulator!F59+alloc3*Simulator!H59+alloc4*Simulator!J59+alloc5*Simulator!M59)<0,NA(),(AT58-B58)*(1+alloc1*Simulator!E59+alloc2*Simulator!F59+alloc3*Simulator!H59+alloc4*Simulator!J59+alloc5*Simulator!M59)),NA()))","v":{"$error":"#N/A"}},null,55.44921523733246,{"$error":"#DIV/0!"},83.069869659835902,{"$error":"#DIV/0!"},149.08506466348172,{"$error":"#DIV/0!"},2.7090065962431966,{"$error":"#DIV/0!"}]
[48,259.1266883924103,null,0.05,0.05,5.1958706130680529E-2,5.1958706130680529E-2,8.7890893633454592E-2,8.7890893633454592E-2,9.3270570138403841E-2,9.3270570138403841E-2,0.12002119060101946,0.12002119060101946,null,"no funds",2875,1830,3296,65,null,null,null,null,null,null,null,null,null,null,48,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ60=SUM(AN47:AN1146),NA(),IF(AQ60<>0,IF((AT59-B59)*(1+alloc1*Simulator!E60+alloc2*Simulator!F60+alloc3*Simulator!H60+alloc4*Simulator!J60+alloc5*Simulator!M60)<0,NA(),(AT59-B59)*(1+alloc1*Simulator!E60+alloc2*Simulator!F60+alloc3*Simulator!H60+alloc4*Simulator!J60+alloc5*Simulator!M60)),NA()))","v":{"$error":"#N/A"}},null,58.330284717025869,{"$error":"#DIV/0!"},90.370954738253474,{"$error":"#DIV/0!"},162.99031364376546,{"$error":"#DIV/0!"},3.0341447932703201,{"$error":"#DIV/0!"}]
[49,277.97647878810574,null,0.05,0.05,0.12185219511775836,0.12185219511775836,-4.7753076064348615E-2,-4.7753076064348615E-2,0.13301815222172064,0.13301815222172064,-0.13815700257231303,-0.13815700257231303,null,"no funds",3225,1743,3734,56,null,null,null,null,null,null,null,null,null,null,49,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ61=SUM(AN48:AN1147),NA(),IF(AQ61<>0,IF((AT60-B60)*(1+alloc1*Simulator!E61+alloc2*Simulator!F61+alloc3*Simulator!H61+alloc4*Simulator!J61+alloc5*Simulator!M61)<0,NA(),(AT60-B60)*(1+alloc1*Simulator!E61+alloc2*Simulator!F61+alloc3*Simulator!H61+alloc4*Simulator!J61+alloc5*Simulator!M61)),NA()))","v":{"$error":"#N/A"}},null,65.437957951639305,{"$error":"#DIV/0!"},86.055463662629847,{"$error":"#DIV/0!"},184.67098399469785,{"$error":"#DIV/0!"},2.6149564432617023,{"$error":"#DIV/0!"}]
[50,298.14021794788698,null,0.05,0.05,0.11039773350066885,0.11039773350066885,0.10990071720522879,0.10990071720522879,-0.23579237053170199,-0.23579237053170199,-0.14866661131184586,-0.14866661131184586,null,"no funds",3581,1935,2854,48,null,null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ62=SUM(AN49:AN1148),NA(),IF(AQ62<>0,IF((AT61-B61)*(1+alloc1*Simulator!E62+alloc2*Simulator!F62+alloc3*Simulator!H62+alloc4*Simulator!J62+alloc5*Simulator!M62)<0,NA(),(AT61-B61)*(1+alloc1*Simulator!E62+alloc2*Simulator!F62+alloc3*Simulator!H62+alloc4*Simulator!J62+alloc5*Simulator!M62)),NA()))","v":{"$error":"#N/A"}},null,72.662160194412365,{"$error":"#DIV/0!"},95.513020838581383,{"$error":"#DIV/0!"},141.12697491016604,{"$error":"#DIV/0!"},2.2261997301139078,{"$error":"#DIV/0!"}]
[51,319.70361832612411,null,0.05,0.05,3.7670917873087892E-2,3.7670917873087892E-2,9.2326821680535992E-2,9.2326821680535992E-2,0.11520816296892604,0.11520816296892604,7.0541373589387016E-2,7.0541373589387016E-2,null,"no funds",3716,2114,3183,51,null,null,null,null,null,null,null,null,null,null,51,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ63=SUM(AN50:AN1149),NA(),IF(AQ63<>0,IF((AT62-B62)*(1+alloc1*Simulator!E63+alloc2*Simulator!F63+alloc3*Simulator!H63+alloc4*Simulator!J63+alloc5*Simulator!M63)<0,NA(),(AT62-B62)*(1+alloc1*Simulator!E63+alloc2*Simulator!F63+alloc3*Simulator!H63+alloc4*Simulator!J63+alloc5*Simulator!M63)),NA()))","v":{"$error":"#N/A"}},null,75.399410463577226,{"$error":"#DIV/0!"},104.3314344817144,{"$error":"#DIV/0!"},157.38595443492801,{"$error":"#DIV/0!"},2.3832389169604653,{"$error":"#DIV/0!"}]
[52,342.75730902886067,null,0.05,0.05,4.4313251535102731E-2,4.4313251535102731E-2,-2.1344308846851651E-3,-2.1344308846851651E-3,0.33062853391798741,0.33062853391798741,0.13147178725813596,0.13147178725813596,null,"no funds",3881,2109,4235,58,null,null,null,null,null,null,null,null,null,null,52,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ64=SUM(AN51:AN1150),NA(),IF(AQ64<>0,IF((AT63-B63)*(1+alloc1*Simulator!E64+alloc2*Simulator!F64+alloc3*Simulator!H64+alloc4*Simulator!J64+alloc5*Simulator!M64)<0,NA(),(AT63-B63)*(1+alloc1*Simulator!E64+alloc2*Simulator!F64+alloc3*Simulator!H64+alloc4*Simulator!J64+alloc5*Simulator!M64)),NA()))","v":{"$error":"#N/A"}},null,78.740603505048185,{"$error":"#DIV/0!"},104.10874624571312,{"$error":"#DIV/0!"},209.42224180903145,{"$error":"#DIV/0!"},2.696567596836402,{"$error":"#DIV/0!"}]
[53,367.39703511148093,null,0.05,0.05,7.5172786525770974E-2,7.5172786525770974E-2,0.25626848021894433,0.25626848021894433,1.8451084001579576E-2,1.8451084001579576E-2,-7.5401752442205511E-2,-7.5401752442205511E-2,null,"no funds",4173,2649,4313,54,null,null,null,null,null,null,null,null,null,null,53,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ65=SUM(AN52:AN1151),NA(),IF(AQ65<>0,IF((AT64-B64)*(1+alloc1*Simulator!E65+alloc2*Simulator!F65+alloc3*Simulator!H65+alloc4*Simulator!J65+alloc5*Simulator!M65)<0,NA(),(AT64-B64)*(1+alloc1*Simulator!E65+alloc2*Simulator!F65+alloc3*Simulator!H65+alloc4*Simulator!J65+alloc5*Simulator!M65)),NA()))","v":{"$error":"#N/A"}},null,84.659754083243541,{"$error":"#DIV/0!"},130.78853642360176,{"$error":"#DIV/0!"},213.28630918444901,{"$error":"#DIV/0!"},2.4932416744560708,{"$error":"#DIV/0!"}]
[54,393.72385341674192,null,0.05,0.05,9.1159400431308754E-2,9.1159400431308754E-2,0.19684155795368047,0.19684155795368047,0.18856399017704484,0.18856399017704484,-9.6307763319189443E-3,-9.6307763319189443E-3,null,"no funds",4553,3170,5126,53,null,null,null,null,null,null,null,null,null,null,54,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ66=SUM(AN53:AN1152),NA(),IF(AQ66<>0,IF((AT65-B65)*(1+alloc1*Simulator!E66+alloc2*Simulator!F66+alloc3*Simulator!H66+alloc4*Simulator!J66+alloc5*Simulator!M66)<0,NA(),(AT65-B65)*(1+alloc1*Simulator!E66+alloc2*Simulator!F66+alloc3*Simulator!H66+alloc4*Simulator!J66+alloc5*Simulator!M66)),NA()))","v":{"$error":"#N/A"}},null,92.37728650613407,{"$error":"#DIV/0!"},156.5331556957052,{"$error":"#DIV/0!"},253.50442669440361,{"$error":"#DIV/0!"},2.4692298215479651,{"$error":"#DIV/0!"}]
[55,421.84432273605796,null,0.05,0.05,0.11088139719369021,0.11088139719369021,3.0969791642138825E-2,3.0969791642138825E-2,-0.11943249291746069,-0.11943249291746069,0.7375747098996972,0.7375747098996972,null,"no funds",5058,3268,4514,92,null,null,null,null,null,null,null,null,null,null,55,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ67=SUM(AN54:AN1153),NA(),IF(AQ67<>0,IF((AT66-B66)*(1+alloc1*Simulator!E67+alloc2*Simulator!F67+alloc3*Simulator!H67+alloc4*Simulator!J67+alloc5*Simulator!M67)<0,NA(),(AT66-B66)*(1+alloc1*Simulator!E67+alloc2*Simulator!F67+alloc3*Simulator!H67+alloc4*Simulator!J67+alloc5*Simulator!M67)),NA()))","v":{"$error":"#N/A"}},null,102.62020910289604,{"$error":"#DIV/0!"},161.38095491268766,{"$error":"#DIV/0!"},223.2277610486793,{"$error":"#DIV/0!"},4.2904712908518867,{"$error":"#DIV/0!"}]
[56,451.87068570551708,null,0.05,0.05,5.9262981963167205E-2,5.9262981963167205E-2,0.22568993158430237,0.22568993158430237,-0.27627537164156857,-0.27627537164156857,0.17694071202418835,0.17694071202418835,null,"no funds",5358,4006,3267,108,null,null,null,null,null,null,null,null,null,null,56,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ68=SUM(AN55:AN1154),NA(),IF(AQ68<>0,IF((AT67-B67)*(1+alloc1*Simulator!E68+alloc2*Simulator!F68+alloc3*Simulator!H68+alloc4*Simulator!J68+alloc5*Simulator!M68)<0,NA(),(AT67-B67)*(1+alloc1*Simulator!E68+alloc2*Simulator!F68+alloc3*Simulator!H68+alloc4*Simulator!J68+alloc5*Simulator!M68)),NA()))","v":{"$error":"#N/A"}},null,108.70178870401742,{"$error":"#DIV/0!"},197.80301158594153,{"$error":"#DIV/0!"},161.55542840424016,{"$error":"#DIV/0!"},5.049630335974558,{"$error":"#DIV/0!"}]
[57,483.92103942759047,null,0.05,0.05,0.10966689372241031,0.10966689372241031,1.467095591699874E-2,1.467095591699874E-2,-0.1512201189538922,-0.1512201189538922,-0.23871964680480182,-0.23871964680480182,null,"no funds",5946,4065,2773,82,null,null,null,null,null,null,null,null,null,null,57,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ69=SUM(AN56:AN1155),NA(),IF(AQ69<>0,IF((AT68-B68)*(1+alloc1*Simulator!E69+alloc2*Simulator!F69+alloc3*Simulator!H69+alloc4*Simulator!J69+alloc5*Simulator!M69)<0,NA(),(AT68-B68)*(1+alloc1*Simulator!E69+alloc2*Simulator!F69+alloc3*Simulator!H69+alloc4*Simulator!J69+alloc5*Simulator!M69)),NA()))","v":{"$error":"#N/A"}},null,120.6227762132568,{"$error":"#DIV/0!"},200.70497084916846,{"$error":"#DIV/0!"},137.12499730330396,{"$error":"#DIV/0!"},3.8441843656758987,{"$error":"#DIV/0!"}]
[58,518.11949133399264,null,0.05,0.05,8.1843334120117683E-2,8.1843334120117683E-2,0.10860170253414393,0.10860170253414393,-4.3018948645617339E-2,-4.3018948645617339E-2,0.1932998367721214,0.1932998367721214,null,"no funds",6433,4506,2654,98,null,null,null,null,null,null,null,null,null,null,58,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ70=SUM(AN57:AN1156),NA(),IF(AQ70<>0,IF((AT69-B69)*(1+alloc1*Simulator!E70+alloc2*Simulator!F70+alloc3*Simulator!H70+alloc4*Simulator!J70+alloc5*Simulator!M70)<0,NA(),(AT69-B69)*(1+alloc1*Simulator!E70+alloc2*Simulator!F70+alloc3*Simulator!H70+alloc4*Simulator!J70+alloc5*Simulator!M70)),NA()))","v":{"$error":"#N/A"}},null,130.49494638937455,{"$error":"#DIV/0!"},222.50187239045388,{"$error":"#DIV/0!"},131.22602408628271,{"$error":"#DIV/0!"},4.5872645760829913,{"$error":"#DIV/0!"}]
[59,554.59629626812648,null,0.05,0.05,4.5126950260408506E-2,4.5126950260408506E-2,0.24419142374500824,0.24419142374500824,-0.11944999070980578,-0.11944999070980578,0.53904679880781248,0.53904679880781248,null,"no funds",6723,5606,2337,151,null,null,null,null,null,null,null,null,null,null,59,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ71=SUM(AN58:AN1157),NA(),IF(AQ71<>0,IF((AT70-B70)*(1+alloc1*Simulator!E71+alloc2*Simulator!F71+alloc3*Simulator!H71+alloc4*Simulator!J71+alloc5*Simulator!M71)<0,NA(),(AT70-B70)*(1+alloc1*Simulator!E71+alloc2*Simulator!F71+alloc3*Simulator!H71+alloc4*Simulator!J71+alloc5*Simulator!M71)),NA()))","v":{"$error":"#N/A"}},null,136.38378534432255,{"$error":"#DIV/0!"},276.83492139540897,{"$error":"#DIV/0!"},115.55107672829149,{"$error":"#DIV/0!"},7.0600148611050049,{"$error":"#DIV/0!"}]
[60,593.48797015973264,null,0.05,0.05,8.8221561467514545E-2,8.8221561467514545E-2,4.3651149020811159E-2,4.3651149020811159E-2,-0.30802404604173356,-0.30802404604173356,0.16347214361663559,0.16347214361663559,null,"no funds",7316,5851,1617,176,null,null,null,null,null,null,null,null,null,null,60,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ72=SUM(AN59:AN1158),NA(),IF(AQ72<>0,IF((AT71-B71)*(1+alloc1*Simulator!E72+alloc2*Simulator!F72+alloc3*Simulator!H72+alloc4*Simulator!J72+alloc5*Simulator!M72)<0,NA(),(AT71-B71)*(1+alloc1*Simulator!E72+alloc2*Simulator!F72+alloc3*Simulator!H72+alloc4*Simulator!J72+alloc5*Simulator!M72)),NA()))","v":{"$error":"#N/A"}},null,148.41577584624901,{"$error":"#DIV/0!"},288.91908380340448,{"$error":"#DIV/0!"},79.958566549964345,{"$error":"#DIV/0!"},8.2141306244151426,{"$error":"#DIV/0!"}]
[61,634.93737498168298,null,0.05,0.05,9.0423604391833556E-2,9.0423604391833556E-2,0.11710033829728193,0.11710033829728193,0.10877451261528809,0.10877451261528809,7.7138375176564453E-2,7.7138375176564453E-2,null,"no funds",7978,6536,1793,190,null,null,null,null,null,null,null,null,null,null,61,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ73=SUM(AN60:AN1159),NA(),IF(AQ73<>0,IF((AT72-B72)*(1+alloc1*Simulator!E73+alloc2*Simulator!F73+alloc3*Simulator!H73+alloc4*Simulator!J73+alloc5*Simulator!M73)<0,NA(),(AT72-B72)*(1+alloc1*Simulator!E73+alloc2*Simulator!F73+alloc3*Simulator!H73+alloc4*Simulator!J73+alloc5*Simulator!M73)),NA()))","v":{"$error":"#N/A"}},null,161.83606524687727,{"$error":"#DIV/0!"},322.75160625732389,{"$error":"#DIV/0!"},88.656020655853794,{"$error":"#DIV/0!"},8.8477553142705858,{"$error":"#DIV/0!"}]
[62,679.09376891030638,null,0.05,0.05,6.7347458707812363E-2,6.7347458707812363E-2,4.3427835602438659E-2,4.3427835602438659E-2,0.16061094997382822,0.16061094997382822,0.28416245950051588,0.28416245950051588,null,"no funds",8515,6820,2081,244,null,null,null,null,null,null,null,null,null,null,62,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ74=SUM(AN61:AN1160),NA(),IF(AQ74<>0,IF((AT73-B73)*(1+alloc1*Simulator!E74+alloc2*Simulator!F74+alloc3*Simulator!H74+alloc4*Simulator!J74+alloc5*Simulator!M74)<0,NA(),(AT73-B73)*(1+alloc1*Simulator!E74+alloc2*Simulator!F74+alloc3*Simulator!H74+alloc4*Simulator!J74+alloc5*Simulator!M74)),NA()))","v":{"$error":"#N/A"}},null,172.73531296852619,{"$error":"#DIV/0!"},336.76800995428999,{"$error":"#DIV/0!"},102.8951483542898,{"$error":"#DIV/0!"},11.361955225432474,{"$error":"#DIV/0!"}]
[63,726.11281474622888,null,0.05,0.05,6.942660280271655E-2,6.942660280271655E-2,0.29282955105442954,0.29282955105442954,-7.4625132096100749E-2,-7.4625132096100749E-2,0.17485143789618907,0.17485143789618907,null,"no funds",9106,8817,1926,287,null,null,null,null,null,null,null,null,null,null,63,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ75=SUM(AN62:AN1161),NA(),IF(AQ75<>0,IF((AT74-B74)*(1+alloc1*Simulator!E75+alloc2*Simulator!F75+alloc3*Simulator!H75+alloc4*Simulator!J75+alloc5*Simulator!M75)<0,NA(),(AT74-B74)*(1+alloc1*Simulator!E75+alloc2*Simulator!F75+alloc3*Simulator!H75+alloc4*Simulator!J75+alloc5*Simulator!M75)),NA()))","v":{"$error":"#N/A"}},null,184.72773893199499,{"$error":"#DIV/0!"},435.38363511869835,{"$error":"#DIV/0!"},95.216584316303042,{"$error":"#DIV/0!"},13.348609433911461,{"$error":"#DIV/0!"}]
[64,{"$f":"(prepen1*(1+rinf)^A76/100000)-(pension/100000)-(income*(1+incrate)^A76/100000)","v":776.1565386813345},null,0.05,0.05,0.1038758257191541,0.1038758257191541,1.9389727825265685E-2,1.9389727825265685E-2,0.38462758008148068,0.38462758008148068,-1.1009811279363874E-2,-1.1009811279363874E-2,null,"no funds",10052,8988,2667,284,null,null,null,null,null,null,null,null,null,null,64,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ76=SUM(AN63:AN1162),NA(),IF(AQ76<>0,IF((AT75-B75)*(1+alloc1*Simulator!E76+alloc2*Simulator!F76+alloc3*Simulator!H76+alloc4*Simulator!J76+alloc5*Simulator!M76)<0,NA(),(AT75-B75)*(1+alloc1*Simulator!E76+alloc2*Simulator!F76+alloc3*Simulator!H76+alloc4*Simulator!J76+alloc5*Simulator!M76)),NA()))","v":{"$error":"#N/A"}},null,203.91648534678831,{"$error":"#DIV/0!"},443.82560530322473,{"$error":"#DIV/0!"},131.83950872550696,{"$error":"#DIV/0!"},13.20164376320216,{"$error":"#DIV/0!"}]
[65,829.39323040678971,null,{"$f":"IF(E77<>\"\",E77,_min1)","v":0.05},0.05,0.10284215707560106,{"$f":"IF(F77<>\"\",F77,NORMINV(RAND(),mean2,stdev2))","v":0.10284215707560106},9.8049259402088931E-2,{"$f":"IF(H77<>\"\",H77,NORMINV(RAND(),mean3,stdev3))","v":9.8049259402088931E-2},-5.109842234953893E-3,{"$f":"IF(J77<>\"\",J77,NORMINV(RAND(),mean4,stdev4))","v":-5.109842234953893E-3},{"$f":"IF(M77<>\"\",M77,NORMINV(RAND(),mean5,stdev5))","v":0.26235848051283028},0.26235848051283028,null,"no funds",{"$f":"ROUND((P76-U76-V76+IF(trans3=\"bucket 2\",X76)+IF(trans4=\"bucket 2\",Z76)+IF(trans5=\"bucket 2\",AB76))*(1+F77),0)","v":11086},{"$f":"ROUND((Q76-W76-X76+IF(trans2=\"bucket 3\",V76)+IF(trans4=\"bucket 3\",Z76)+IF(trans5=\"bucket 3\",AB76))*(1+H77),0)","v":9869},{"$f":"ROUND((R76-Y76-Z76+IF(trans2=\"bucket 4\",V76)+IF(trans3=\"bucket 4\",X76)+IF(trans5=\"bucket 4\",AB76))*(1+J77),0)","v":2653},{"$f":"ROUND((S76-AA76-AB76+IF(trans2=\"bucket 5\",V76)+IF(trans3=\"bucket 5\",X76)+IF(trans4=\"bucket 5\",Z76))*(1+M77),0)","v":359},null,null,null,null,null,null,null,null,null,null,65,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ77=SUM(AN64:AN1163),NA(),IF(AQ77<>0,IF((AT76-B76)*(1+alloc1*Simulator!E77+alloc2*Simulator!F77+alloc3*Simulator!H77+alloc4*Simulator!J77+alloc5*Simulator!M77)<0,NA(),(AT76-B76)*(1+alloc1*Simulator!E77+alloc2*Simulator!F77+alloc3*Simulator!H77+alloc4*Simulator!J77+alloc5*Simulator!M77)),NA()))","v":{"$error":"#N/A"}},null,224.88769656312721,{"$error":"#DIV/0!"},487.34237720688975,{"$error":"#DIV/0!"},131.16582963558579,{"$error":"#DIV/0!"},16.665206961187561,{"$error":"#DIV/0!"}]
[{"$f":"A77+1","v":66},885.99727433337557,null,0.05,0.05,0.10622459814546499,0.10622459814546499,7.8667780617571403E-2,7.8667780617571403E-2,0.34668102995846262,0.34668102995846262,0.44907687781517447,0.44907687781517447,null,{"$f":"IF(O77=\"no funds\",\"no funds\",IF((O77-B77+U77+W77+Y77+AA77)*(1+D78)<0,\"no funds\",ROUND((O77-B77+U77+W77+Y77+AA77)*(1+D78),0)))","v":"no funds"},12264,10645,3573,520,null,null,null,null,null,null,null,null,null,null,{"$f":"AD77+1","v":66},null,null,null,null,null,null,null,null,{"$f":"IF($O78<$B78,$B78-$O78,0)","v":0},{"$f":"IF($O78<$B78,AD78,0)","v":0},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ78=SUM(AN65:AN1164),NA(),IF(AQ78<>0,IF((AT77-B77)*(1+alloc1*Simulator!E78+alloc2*Simulator!F78+alloc3*Simulator!H78+alloc4*Simulator!J78+alloc5*Simulator!M78)<0,NA(),(AT77-B77)*(1+alloc1*Simulator!E78+alloc2*Simulator!F78+alloc3*Simulator!H78+alloc4*Simulator!J78+alloc5*Simulator!M78)),NA()))","v":{"$error":"#N/A"}},null,{"$f":"AV77*(1+F78)","v":248.77630175840468},{"$f":"(AV78/$AV$12)^(1/AQ78)-1","v":{"$error":"#DIV/0!"}},{"$f":"AX77*(1+H78)","v":525.68052042264708},{"$f":"(AX78/$AX$12)^(1/AQ78)-1","v":{"$error":"#DIV/0!"}},{"$f":"AZ77*(1+J78)","v":176.63853454900692},{"$f":"(AZ78/$AZ$12)^(1/AQ78)-1","v":{"$error":"#DIV/0!"}},{"$f":"BB77*(1+M78)","v":24.149166071461384},{"$f":"(BB78/$BB$12)^(1/AQ78)-1","v":{"$error":"#DIV/0!"}}]
[67,946.14890032349274,null,0.05,0.05,0.1066038870771055,0.1066038870771055,9.0049354630685349E-2,9.0049354630685349E-2,0.3743864180102533,0.3743864180102533,0.13512606865414736,0.13512606865414736,null,"no funds",13571,11604,4911,590,null,null,null,null,null,null,null,null,null,null,67,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ79=SUM(AN66:AN1165),NA(),IF(AQ79<>0,IF((AT78-B78)*(1+alloc1*Simulator!E79+alloc2*Simulator!F79+alloc3*Simulator!H79+alloc4*Simulator!J79+alloc5*Simulator!M79)<0,NA(),(AT78-B78)*(1+alloc1*Simulator!E79+alloc2*Simulator!F79+alloc3*Simulator!H79+alloc4*Simulator!J79+alloc5*Simulator!M79)),NA()))","v":{"$error":"#N/A"}},null,275.29682253851757,{"$error":"#DIV/0!"},573.01771202862926,{"$error":"#DIV/0!"},242.76960278139001,{"$error":"#DIV/0!"},27.41234794397408,{"$error":"#DIV/0!"}]
[68,1010.0338407971643,null,0.05,0.05,0.14209625322392883,0.14209625322392883,0.28523234981826961,0.28523234981826961,0.24286742649218754,0.24286742649218754,-6.4789072925567709E-2,-6.4789072925567709E-2,null,"no funds",15499,14914,6104,552,null,null,null,null,null,null,null,null,null,null,68,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ80=SUM(AN67:AN1166),NA(),IF(AQ80<>0,IF((AT79-B79)*(1+alloc1*Simulator!E80+alloc2*Simulator!F80+alloc3*Simulator!H80+alloc4*Simulator!J80+alloc5*Simulator!M80)<0,NA(),(AT79-B79)*(1+alloc1*Simulator!E80+alloc2*Simulator!F80+alloc3*Simulator!H80+alloc4*Simulator!J80+alloc5*Simulator!M80)),NA()))","v":{"$error":"#N/A"}},null,314.41546954569378,{"$error":"#DIV/0!"},736.46090051804367,{"$error":"#DIV/0!"},301.73043143943681,{"$error":"#DIV/0!"},25.636327333970907,{"$error":"#DIV/0!"}]
[69,1077.842879353509,null,0.05,0.05,0.1422548773180041,0.1422548773180041,9.8832999386291656E-2,9.8832999386291656E-2,-0.28483864697100619,-0.28483864697100619,0.23720733376398995,0.23720733376398995,null,"no funds",17704,16388,4365,683,null,null,null,null,null,null,null,null,null,null,69,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ81=SUM(AN68:AN1167),NA(),IF(AQ81<>0,IF((AT80-B80)*(1+alloc1*Simulator!E81+alloc2*Simulator!F81+alloc3*Simulator!H81+alloc4*Simulator!J81+alloc5*Simulator!M81)<0,NA(),(AT80-B80)*(1+alloc1*Simulator!E81+alloc2*Simulator!F81+alloc3*Simulator!H81+alloc4*Simulator!J81+alloc5*Simulator!M81)),NA()))","v":{"$error":"#N/A"}},null,359.14260359279911,{"$error":"#DIV/0!"},809.24754024697131,{"$error":"#DIV/0!"},215.78594359824967,{"$error":"#DIV/0!"},31.717452188363044,{"$error":"#DIV/0!"}]
[70,1149.771274123618,null,0.05,0.05,3.1229490101687664E-2,3.1229490101687664E-2,0.14328506051282108,0.14328506051282108,0.26259553894849863,0.26259553894849863,0.48768288615836231,0.48768288615836231,null,"no funds",18257,18736,5511,1016,null,null,null,null,null,null,null,null,null,null,70,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ82=SUM(AN69:AN1168),NA(),IF(AQ82<>0,IF((AT81-B81)*(1+alloc1*Simulator!E82+alloc2*Simulator!F82+alloc3*Simulator!H82+alloc4*Simulator!J82+alloc5*Simulator!M82)<0,NA(),(AT81-B81)*(1+alloc1*Simulator!E82+alloc2*Simulator!F82+alloc3*Simulator!H82+alloc4*Simulator!J82+alloc5*Simulator!M82)),NA()))","v":{"$error":"#N/A"}},null,370.35844397679477,{"$error":"#DIV/0!"},925.20062302111023,{"$error":"#DIV/0!"},272.45036975494236,{"$error":"#DIV/0!"},47.185510813173792,{"$error":"#DIV/0!"}]
[71,1226.0180369175184,null,0.05,0.05,0.11291303849504372,0.11291303849504372,7.9228987660699801E-2,7.9228987660699801E-2,0.29490448293954502,0.29490448293954502,-5.6641095873919023E-2,-5.6641095873919023E-2,null,"no funds",20318,20220,7136,958,null,null,null,null,null,null,null,null,null,null,71,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ83=SUM(AN70:AN1169),NA(),IF(AQ83<>0,IF((AT82-B82)*(1+alloc1*Simulator!E83+alloc2*Simulator!F83+alloc3*Simulator!H83+alloc4*Simulator!J83+alloc5*Simulator!M83)<0,NA(),(AT82-B82)*(1+alloc1*Simulator!E83+alloc2*Simulator!F83+alloc3*Simulator!H83+alloc4*Simulator!J83+alloc5*Simulator!M83)),NA()))","v":{"$error":"#N/A"}},null,412.17674121851104,{"$error":"#DIV/0!"},998.50333176612151,{"$error":"#DIV/0!"},352.79720517421151,{"$error":"#DIV/0!"},44.512871771344976,{"$error":"#DIV/0!"}]
[72,1306.7850468213323,null,0.05,0.05,0.14072606291915221,0.14072606291915221,4.5936402957394477E-2,4.5936402957394477E-2,0.19293544947570446,0.19293544947570446,7.2486405050857933E-2,7.2486405050857933E-2,null,"no funds",23177,21149,8513,1027,null,null,null,null,null,null,null,null,null,null,72,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$f":"IF(AQ84=SUM(AN71:AN1170),NA(),IF(AQ84<>0,IF(AS83*(1+retroi)-(prepen1/100000)*(1+rinf)^AQ84<0,NA(),AS83*(1+retroi)-(prepen1/100000)*(1+rinf)^AQ84),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(AQ84=SUM(AN71:AN1170),NA(),IF(AQ84<>0,IF((AT83-B83)*(1+alloc1*Simulator!E84+alloc2*Simulator!F84+alloc3*Simulator!H84+alloc4*Simulator!J84+alloc5*Simulator!M84)<0,NA(),(AT83-B83)*(1+alloc1*Simulator!E84+alloc2*Simulator!F84+alloc3*Simulator!H84+alloc4*Simulator!J84+alloc5*Simulator!M84)),NA()))","v":{"$error":"#N/A"}},null,470.18075123703835,{"$error":"#DIV/0!"},1044.3709831684312,{"$error":"#DIV/0!"},420.86429252827037,{"$error":"#DIV/0!"},47.739449824539591,{"$error":"#DIV/0!"}]
[73,1392.2759742124929,null,0.05,0.05,7.4957007555369576E-2,7.4957007555369576E-2,2.332997569155329E-2,2.332997569155329E-2,-5.4557785219957633E-2,-5.4557785219957633E-2,0.46424016227892573,0.46424016227892573,null,"no funds",24914,21642,8049,1504,null,null,null,null,null,null,null,null,null,null,73,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ85=SUM(AN72:AN1171),NA(),IF(AQ85<>0,IF((AT84-B84)*(1+alloc1*Simulator!E85+alloc2*Simulator!F85+alloc3*Simulator!H85+alloc4*Simulator!J85+alloc5*Simulator!M85)<0,NA(),(AT84-B84)*(1+alloc1*Simulator!E85+alloc2*Simulator!F85+alloc3*Simulator!H85+alloc4*Simulator!J85+alloc5*Simulator!M85)),NA()))","v":{"$error":"#N/A"}},null,505.42409335990237,{"$error":"#DIV/0!"},1068.7361328187142,{"$error":"#DIV/0!"},397.90286884976354,{"$error":"#DIV/0!"},69.902019758190477,{"$error":"#DIV/0!"}]
[74,1482.6949881594908,null,0.05,0.05,7.4720199387279154E-2,7.4720199387279154E-2,0.28291274450194892,0.28291274450194892,0.2575863265657331,0.2575863265657331,0.44336069259643152,0.44336069259643152,null,"no funds",26776,27765,10122,2171,null,null,null,null,null,null,null,null,null,null,74,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ86=SUM(AN73:AN1172),NA(),IF(AQ86<>0,IF((AT85-B85)*(1+alloc1*Simulator!E86+alloc2*Simulator!F86+alloc3*Simulator!H86+alloc4*Simulator!J86+alloc5*Simulator!M86)<0,NA(),(AT85-B85)*(1+alloc1*Simulator!E86+alloc2*Simulator!F86+alloc3*Simulator!H86+alloc4*Simulator!J86+alloc5*Simulator!M86)),NA()))","v":{"$error":"#N/A"}},null,543.18948239088911,{"$error":"#DIV/0!"},1371.0952053028561,{"$error":"#DIV/0!"},500.39720716674077,{"$error":"#DIV/0!"},100.89382765207125,{"$error":"#DIV/0!"}]
[75,1578.2452168232485,null,0.05,0.05,6.1977688766264041E-2,6.1977688766264041E-2,0.21159332619813478,0.21159332619813478,-8.8468993601378498E-2,-8.8468993601378498E-2,0.31511477201870591,0.31511477201870591,null,"no funds",28436,33640,9227,2855,null,null,null,null,null,null,null,null,null,null,75,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ87=SUM(AN74:AN1173),NA(),IF(AQ87<>0,IF((AT86-B86)*(1+alloc1*Simulator!E87+alloc2*Simulator!F87+alloc3*Simulator!H87+alloc4*Simulator!J87+alloc5*Simulator!M87)<0,NA(),(AT86-B86)*(1+alloc1*Simulator!E87+alloc2*Simulator!F87+alloc3*Simulator!H87+alloc4*Simulator!J87+alloc5*Simulator!M87)),NA()))","v":{"$error":"#N/A"}},null,576.85511107161972,{"$error":"#DIV/0!"},1661.2098003272022,{"$error":"#DIV/0!"},456.12756984775871,{"$error":"#DIV/0!"},132.68696315074828,{"$error":"#DIV/0!"}]
[76,1679.1269267412079,null,0.05,0.05,6.8229108430395008E-2,6.8229108430395008E-2,0.21150962518069366,0.21150962518069366,0.22452383068344062,0.22452383068344062,-0.3611547358699323,-0.3611547358699323,null,"no funds",30376,40755,11299,1824,null,null,null,null,null,null,null,null,null,null,76,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ88=SUM(AN75:AN1174),NA(),IF(AQ88<>0,IF((AT87-B87)*(1+alloc1*Simulator!E88+alloc2*Simulator!F88+alloc3*Simulator!H88+alloc4*Simulator!J88+alloc5*Simulator!M88)<0,NA(),(AT87-B87)*(1+alloc1*Simulator!E88+alloc2*Simulator!F88+alloc3*Simulator!H88+alloc4*Simulator!J88+alloc5*Simulator!M88)),NA()))","v":{"$error":"#N/A"}},null,616.21342099355275,{"$error":"#DIV/0!"},2012.5716625409036,{"$error":"#DIV/0!"},558.53907911030615,{"$error":"#DIV/0!"},84.766438020656352,{"$error":"#DIV/0!"}]
[77,1785.5353827098124,null,0.05,0.05,8.2405238872755623E-2,8.2405238872755623E-2,0.13657182072339125,0.13657182072339125,0.35193572455794897,0.35193572455794897,0.30187665501964561,0.30187665501964561,null,"no funds",32879,46321,15276,2375,null,null,null,null,null,null,null,null,null,null,77,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ89=SUM(AN76:AN1175),NA(),IF(AQ89<>0,IF((AT88-B88)*(1+alloc1*Simulator!E89+alloc2*Simulator!F89+alloc3*Simulator!H89+alloc4*Simulator!J89+alloc5*Simulator!M89)<0,NA(),(AT88-B88)*(1+alloc1*Simulator!E89+alloc2*Simulator!F89+alloc3*Simulator!H89+alloc4*Simulator!J89+alloc5*Simulator!M89)),NA()))","v":{"$error":"#N/A"}},null,666.99263514712436,{"$error":"#DIV/0!"},2287.4322388304172,{"$error":"#DIV/0!"},755.10893461092121,{"$error":"#DIV/0!"},110.3554467882622,{"$error":"#DIV/0!"}]
[78,1897.6583453388369,null,0.05,0.05,8.0369258268180449E-2,8.0369258268180449E-2,0.21739928718484017,0.21739928718484017,-0.18880769696049032,-0.18880769696049032,0.53115740741991135,0.53115740741991135,null,"no funds",35521,56391,12392,3636,null,null,null,null,null,null,null,null,null,null,78,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$f":"IF(AQ90=SUM(AN77:AN1176),NA(),IF(AQ90<>0,IF(SUM(O90:S90)<0,NA(),SUM(O90:S90)),NA()))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(AQ90=SUM(AN77:AN1176),NA(),IF(AQ90<>0,IF((AT89-B89)*(1+alloc1*Simulator!E90+alloc2*Simulator!F90+alloc3*Simulator!H90+alloc4*Simulator!J90+alloc5*Simulator!M90)<0,NA(),(AT89-B89)*(1+alloc1*Simulator!E90+alloc2*Simulator!F90+alloc3*Simulator!H90+alloc4*Simulator!J90+alloc5*Simulator!M90)),NA()))","v":{"$error":"#N/A"}},null,720.59833850423786,{"$error":"#DIV/0!"},2784.7183770357733,{"$error":"#DIV/0!"},612.53855571274369,{"$error":"#DIV/0!"},168.97155979898153,{"$error":"#DIV/0!"}]
[79,2015.6731581794074,null,0.05,0.05,5.3102199509687607E-2,5.3102199509687607E-2,1.5516498379650218E-2,1.5516498379650218E-2,0.15656529328118407,0.15656529328118407,0.34726891593183806,0.34726891593183806,null,"no funds",37407,57266,14332,4899,null,null,null,null,null,null,null,null,null,null,79,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ91=SUM(AN78:AN1177),NA(),IF(AQ91<>0,IF((AT90-B90)*(1+alloc1*Simulator!E91+alloc2*Simulator!F91+alloc3*Simulator!H91+alloc4*Simulator!J91+alloc5*Simulator!M91)<0,NA(),(AT90-B90)*(1+alloc1*Simulator!E91+alloc2*Simulator!F91+alloc3*Simulator!H91+alloc4*Simulator!J91+alloc5*Simulator!M91)),NA()))","v":{"$error":"#N/A"}},null,758.86369524183931,{"$error":"#DIV/0!"},2827.9274552208312,{"$error":"#DIV/0!"},708.44083433394235,{"$error":"#DIV/0!"},227.65013019368558,{"$error":"#DIV/0!"}]
[80,2139.7433705685685,null,0.05,0.05,8.6088875452609764E-2,8.6088875452609764E-2,5.6642401044483787E-2,5.6642401044483787E-2,0.15387860784024135,0.15387860784024135,-0.41229671569079085,-0.41229671569079085,null,"no funds",40627,60510,16537,2879,null,null,null,null,null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ92=SUM(AN79:AN1178),NA(),IF(AQ92<>0,IF((AT91-B91)*(1+alloc1*Simulator!E92+alloc2*Simulator!F92+alloc3*Simulator!H92+alloc4*Simulator!J92+alloc5*Simulator!M92)<0,NA(),(AT91-B91)*(1+alloc1*Simulator!E92+alloc2*Simulator!F92+alloc3*Simulator!H92+alloc4*Simulator!J92+alloc5*Simulator!M92)),NA()))","v":{"$error":"#N/A"}},null,824.19341738702121,{"$error":"#DIV/0!"},2988.1080562641559,{"$error":"#DIV/0!"},817.45472365842852,{"$error":"#DIV/0!"},133.79072918824806,{"$error":"#DIV/0!"}]
[81,2270.0148359223449,null,0.05,0.05,5.4496855492491184E-2,5.4496855492491184E-2,0.15535111660919515,0.15535111660919515,-0.18861959561184666,-0.18861959561184666,0.14977727753731174,0.14977727753731174,null,"no funds",42841,69910,13418,3310,null,null,null,null,null,null,null,null,null,null,81,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ93=SUM(AN80:AN1179),NA(),IF(AQ93<>0,IF((AT92-B92)*(1+alloc1*Simulator!E93+alloc2*Simulator!F93+alloc3*Simulator!H93+alloc4*Simulator!J93+alloc5*Simulator!M93)<0,NA(),(AT92-B92)*(1+alloc1*Simulator!E93+alloc2*Simulator!F93+alloc3*Simulator!H93+alloc4*Simulator!J93+alloc5*Simulator!M93)),NA()))","v":{"$error":"#N/A"}},null,869.10936695222415,{"$error":"#DIV/0!"},3452.3139793537243,{"$error":"#DIV/0!"},663.2667442509819,{"$error":"#DIV/0!"},153.82954036579559,{"$error":"#DIV/0!"}]
[82,2406.611218075253,null,0.05,0.05,0.11144649215388305,0.11144649215388305,3.0563100905563093E-2,3.0563100905563093E-2,0.24533453351172238,0.24533453351172238,0.26402076186009288,0.26402076186009288,null,"no funds",47615,72047,16710,4184,null,null,null,null,null,null,null,null,null,null,82,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ94=SUM(AN81:AN1180),NA(),IF(AQ94<>0,IF((AT93-B93)*(1+alloc1*Simulator!E94+alloc2*Simulator!F94+alloc3*Simulator!H94+alloc4*Simulator!J94+alloc5*Simulator!M94)<0,NA(),(AT93-B93)*(1+alloc1*Simulator!E94+alloc2*Simulator!F94+alloc3*Simulator!H94+alloc4*Simulator!J94+alloc5*Simulator!M94)),NA()))","v":{"$error":"#N/A"}},null,965.96855719713153,{"$error":"#DIV/0!"},3557.8273998623986,{"$error":"#DIV/0!"},825.9889815456354,{"$error":"#DIV/0!"},194.44373280976086,{"$error":"#DIV/0!"}]
[83,2549.628830328304,null,0.05,0.05,5.7257805935036057E-2,5.7257805935036057E-2,9.6241244506042239E-2,9.6241244506042239E-2,0.2873916204633995,0.2873916204633995,2.2431763440593638E-2,2.2431763440593638E-2,null,"no funds",50341,78981,21512,4278,null,null,null,null,null,null,null,null,null,null,83,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ95=SUM(AN82:AN1181),NA(),IF(AQ95<>0,IF((AT94-B94)*(1+alloc1*Simulator!E95+alloc2*Simulator!F95+alloc3*Simulator!H95+alloc4*Simulator!J95+alloc5*Simulator!M95)<0,NA(),(AT94-B94)*(1+alloc1*Simulator!E95+alloc2*Simulator!F95+alloc3*Simulator!H95+alloc4*Simulator!J95+alloc5*Simulator!M95)),NA()))","v":{"$error":"#N/A"}},null,1021.2777973844718,{"$error":"#DIV/0!"},3900.2371365628524,{"$error":"#DIV/0!"},1063.3712934369485,{"$error":"#DIV/0!"},198.80544862665542,{"$error":"#DIV/0!"}]
[84,2699.1307230423035,null,0.05,0.05,4.9323259825036429E-2,4.9323259825036429E-2,0.12343980942878371,0.12343980942878371,0.38365307421111428,0.38365307421111428,8.9049903085662352E-2,8.9049903085662352E-2,null,"no funds",52824,88730,29765,4659,null,null,null,null,null,null,null,null,null,null,84,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ96=SUM(AN83:AN1182),NA(),IF(AQ96<>0,IF((AT95-B95)*(1+alloc1*Simulator!E96+alloc2*Simulator!F96+alloc3*Simulator!H96+alloc4*Simulator!J96+alloc5*Simulator!M96)<0,NA(),(AT95-B95)*(1+alloc1*Simulator!E96+alloc2*Simulator!F96+alloc3*Simulator!H96+alloc4*Simulator!J96+alloc5*Simulator!M96)),NA()))","v":{"$error":"#N/A"}},null,1071.650547538407,{"$error":"#DIV/0!"},4381.6816654272352,{"$error":"#DIV/0!"},1471.3369591918827,{"$error":"#DIV/0!"},216.50905455976073,{"$error":"#DIV/0!"}]
[85,2855.1399258021956,null,0.05,0.05,0.13188146016349181,0.13188146016349181,0.10695375766536709,0.10695375766536709,4.8005623702793529E-2,4.8005623702793529E-2,0.23490618388997309,0.23490618388997309,null,"no funds",59791,98220,31194,5753,null,null,null,null,null,null,null,null,null,null,85,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ97=SUM(AN84:AN1183),NA(),IF(AQ97<>0,IF((AT96-B96)*(1+alloc1*Simulator!E97+alloc2*Simulator!F97+alloc3*Simulator!H97+alloc4*Simulator!J97+alloc5*Simulator!M97)<0,NA(),(AT96-B96)*(1+alloc1*Simulator!E97+alloc2*Simulator!F97+alloc3*Simulator!H97+alloc4*Simulator!J97+alloc5*Simulator!M97)),NA()))","v":{"$error":"#N/A"}},null,1212.9813865327776,{"$error":"#DIV/0!"},4850.3189844381222,{"$error":"#DIV/0!"},1541.9694075948605,{"$error":"#DIV/0!"},267.36837034402009,{"$error":"#DIV/0!"}]
[86,3017.63173927453,null,0.05,0.05,9.6708393159541051E-2,9.6708393159541051E-2,0.13228231864811099,0.13228231864811099,0.10146477439826622,0.10146477439826622,-0.39205976211853744,-0.39205976211853744,null,"no funds",65573,111213,34359,3497,null,null,null,null,null,null,null,null,null,null,86,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ98=SUM(AN85:AN1184),NA(),IF(AQ98<>0,IF((AT97-B97)*(1+alloc1*Simulator!E98+alloc2*Simulator!F98+alloc3*Simulator!H98+alloc4*Simulator!J98+alloc5*Simulator!M98)<0,NA(),(AT97-B97)*(1+alloc1*Simulator!E98+alloc2*Simulator!F98+alloc3*Simulator!H98+alloc4*Simulator!J98+alloc5*Simulator!M98)),NA()))","v":{"$error":"#N/A"}},null,1330.2868673567946,{"$error":"#DIV/0!"},5491.9304258825478,{"$error":"#DIV/0!"},1698.4249856655013,{"$error":"#DIV/0!"},162.54399066892256,{"$error":"#DIV/0!"}]
[87,3186.5249597654674,null,0.05,0.05,7.3860909225107491E-2,7.3860909225107491E-2,0.17398144665893214,0.17398144665893214,0.21024782927510394,0.21024782927510394,0.21664251313676944,0.21664251313676944,null,"no funds",70416,130562,41583,4255,null,null,null,null,null,null,null,null,null,null,87,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ99=SUM(AN86:AN1185),NA(),IF(AQ99<>0,IF((AT98-B98)*(1+alloc1*Simulator!E99+alloc2*Simulator!F99+alloc3*Simulator!H99+alloc4*Simulator!J99+alloc5*Simulator!M99)<0,NA(),(AT98-B98)*(1+alloc1*Simulator!E99+alloc2*Simulator!F99+alloc3*Simulator!H99+alloc4*Simulator!J99+alloc5*Simulator!M99)),NA()))","v":{"$error":"#N/A"}},null,1428.5430649099874,{"$error":"#DIV/0!"},6447.4244263277988,{"$error":"#DIV/0!"},2055.5151520882723,{"$error":"#DIV/0!"},197.75792930271757,{"$error":"#DIV/0!"}]
[88,3361.6719060305777,null,0.05,0.05,6.8281707834338512E-2,6.8281707834338512E-2,9.5209815370191353E-2,9.5209815370191353E-2,7.9115782304932589E-2,7.9115782304932589E-2,-0.235276976348721,-0.235276976348721,null,"no funds",75224,142993,44873,3254,null,null,null,null,null,null,null,null,null,null,88,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ100=SUM(AN87:AN1186),NA(),IF(AQ100<>0,IF((AT99-B99)*(1+alloc1*Simulator!E100+alloc2*Simulator!F100+alloc3*Simulator!H100+alloc4*Simulator!J100+alloc5*Simulator!M100)<0,NA(),(AT99-B99)*(1+alloc1*Simulator!E100+alloc2*Simulator!F100+alloc3*Simulator!H100+alloc4*Simulator!J100+alloc5*Simulator!M100)),NA()))","v":{"$error":"#N/A"}},null,1526.0864250969416,{"$error":"#DIV/0!"},7061.282515571731,{"$error":"#DIV/0!"},2218.1388413853788,{"$error":"#DIV/0!"},151.23004164739004,{"$error":"#DIV/0!"}]
[89,3542.8471029452821,null,0.05,0.05,9.5206171506480641E-2,9.5206171506480641E-2,-3.8561614441864622E-3,-3.8561614441864622E-3,3.5398597798286191E-2,3.5398597798286191E-2,0.5752378143582827,0.5752378143582827,null,"no funds",82386,142442,46461,5126,null,null,null,null,null,null,null,null,null,null,89,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ101=SUM(AN88:AN1187),NA(),IF(AQ101<>0,IF((AT100-B100)*(1+alloc1*Simulator!E101+alloc2*Simulator!F101+alloc3*Simulator!H101+alloc4*Simulator!J101+alloc5*Simulator!M101)<0,NA(),(AT100-B100)*(1+alloc1*Simulator!E101+alloc2*Simulator!F101+alloc3*Simulator!H101+alloc4*Simulator!J101+alloc5*Simulator!M101)),NA()))","v":{"$error":"#N/A"}},null,1671.379271018433,{"$error":"#DIV/0!"},7034.0530701886755,{"$error":"#DIV/0!"},2296.6578460923365,{"$error":"#DIV/0!"},238.22328026994674,{"$error":"#DIV/0!"}]
[90,3729.7344600563893,null,0.05,0.05,0.14667855246478781,0.14667855246478781,-7.3143936994339603E-2,-7.3143936994339603E-2,-0.31224818483217864,-0.31224818483217864,-0.22395474285987063,-0.22395474285987063,null,"no funds",94470,132023,31954,3978,null,null,null,null,null,null,null,null,null,null,90,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ102=SUM(AN89:AN1188),NA(),IF(AQ102<>0,IF((AT101-B101)*(1+alloc1*Simulator!E102+alloc2*Simulator!F102+alloc3*Simulator!H102+alloc4*Simulator!J102+alloc5*Simulator!M102)<0,NA(),(AT101-B101)*(1+alloc1*Simulator!E102+alloc2*Simulator!F102+alloc3*Simulator!H102+alloc4*Simulator!J102+alloc5*Simulator!M102)),NA()))","v":{"$error":"#N/A"}},null,1916.534763111069,{"$error":"#DIV/0!"},6519.5547356079542,{"$error":"#DIV/0!"},1579.5306024694232,{"$error":"#DIV/0!"},184.87204679385593,{"$error":"#DIV/0!"}]
[91,3921.9127646239331,null,0.05,0.05,0.10283276827115451,0.10283276827115451,-4.0764722166891726E-2,-4.0764722166891726E-2,0.10429521663504426,0.10429521663504426,-1.7659400167037292E-2,-1.7659400167037292E-2,null,"no funds",104185,126641,35287,3908,null,null,null,null,null,null,null,null,null,null,91,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ103=SUM(AN90:AN1189),NA(),IF(AQ103<>0,IF((AT102-B102)*(1+alloc1*Simulator!E103+alloc2*Simulator!F103+alloc3*Simulator!H103+alloc4*Simulator!J103+alloc5*Simulator!M103)<0,NA(),(AT102-B102)*(1+alloc1*Simulator!E103+alloc2*Simulator!F103+alloc3*Simulator!H103+alloc4*Simulator!J103+alloc5*Simulator!M103)),NA()))","v":{"$error":"#N/A"}},null,2113.6173382896814,{"$error":"#DIV/0!"},6253.7868981590527,{"$error":"#DIV/0!"},1744.2680888356535,{"$error":"#DIV/0!"},181.60731733982399,{"$error":"#DIV/0!"}]
[92,4118.8392883331862,null,0.05,0.05,0.11236662006867205,0.11236662006867205,6.9570621955334228E-3,6.9570621955334228E-3,6.4187943023217814E-2,6.4187943023217814E-2,-0.45612181824774123,-0.45612181824774123,null,"no funds",115892,127522,37552,2125,null,null,null,null,null,null,null,null,null,null,92,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ104=SUM(AN91:AN1190),NA(),IF(AQ104<>0,IF((AT103-B103)*(1+alloc1*Simulator!E104+alloc2*Simulator!F104+alloc3*Simulator!H104+alloc4*Simulator!J104+alloc5*Simulator!M104)<0,NA(),(AT103-B103)*(1+alloc1*Simulator!E104+alloc2*Simulator!F104+alloc3*Simulator!H104+alloc4*Simulator!J104+alloc5*Simulator!M104)),NA()))","v":{"$error":"#N/A"}},null,2351.117374711836,{"$error":"#DIV/0!"},6297.2948825671574,{"$error":"#DIV/0!"},1856.2290695390534,{"$error":"#DIV/0!"},98.772257547688923,{"$error":"#DIV/0!"}]
[93,4319.8312841931138,null,0.05,0.05,0.10646605953217853,0.10646605953217853,6.6716672428938001E-2,6.6716672428938001E-2,6.7862754149028565E-2,6.7862754149028565E-2,0.3253911872759786,0.3253911872759786,null,"no funds",128231,136030,40100,2816,null,null,null,null,null,null,null,null,null,null,93,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ105=SUM(AN92:AN1191),NA(),IF(AQ105<>0,IF((AT104-B104)*(1+alloc1*Simulator!E105+alloc2*Simulator!F105+alloc3*Simulator!H105+alloc4*Simulator!J105+alloc5*Simulator!M105)<0,NA(),(AT104-B104)*(1+alloc1*Simulator!E105+alloc2*Simulator!F105+alloc3*Simulator!H105+alloc4*Simulator!J105+alloc5*Simulator!M105)),NA()))","v":{"$error":"#N/A"}},null,2601.4315770950457,{"$error":"#DIV/0!"},6717.4294424358186,{"$error":"#DIV/0!"},1982.1978865294625,{"$error":"#DIV/0!"},130.91187970106014,{"$error":"#DIV/0!"}]
[94,4524.0451250011602,null,0.05,0.05,6.6197253846321052E-2,6.6197253846321052E-2,0.13193246938238851,0.13193246938238851,0.11087455153825321,0.11087455153825321,0.30378135006145834,0.30378135006145834,null,"no funds",136720,153977,44546,3671,null,null,null,null,null,null,null,null,null,null,94,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ106=SUM(AN93:AN1192),NA(),IF(AQ106<>0,IF((AT105-B105)*(1+alloc1*Simulator!E106+alloc2*Simulator!F106+alloc3*Simulator!H106+alloc4*Simulator!J106+alloc5*Simulator!M106)<0,NA(),(AT105-B105)*(1+alloc1*Simulator!E106+alloc2*Simulator!F106+alloc3*Simulator!H106+alloc4*Simulator!J106+alloc5*Simulator!M106)),NA()))","v":{"$error":"#N/A"}},null,2773.6392035678418,{"$error":"#DIV/0!"},7603.6764966783367,{"$error":"#DIV/0!"},2201.9731882584902,{"$error":"#DIV/0!"},170.68046725573143,{"$error":"#DIV/0!"}]
[95,4730.4528068811123,null,0.05,0.05,0.11373824214496447,0.11373824214496447,0.10193801227960732,0.10193801227960732,0.29500359970234791,0.29500359970234791,0.42711784036181122,0.42711784036181122,null,"no funds",152270,169673,57687,5239,null,null,null,null,null,null,null,null,null,null,95,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ107=SUM(AN94:AN1193),NA(),IF(AQ107<>0,IF((AT106-B106)*(1+alloc1*Simulator!E107+alloc2*Simulator!F107+alloc3*Simulator!H107+alloc4*Simulator!J107+alloc5*Simulator!M107)<0,NA(),(AT106-B106)*(1+alloc1*Simulator!E107+alloc2*Simulator!F107+alloc3*Simulator!H107+alloc4*Simulator!J107+alloc5*Simulator!M107)),NA()))","v":{"$error":"#N/A"}},null,3089.1080509260073,{"$error":"#DIV/0!"},8378.7801647668948,{"$error":"#DIV/0!"},2851.5632052428004,{"$error":"#DIV/0!"},243.58113982194428,{"$error":"#DIV/0!"}]
[96,{"$f":"(prepen1*(1+rinf)^A108/100000)-(pension/100000)-(income*(1+incrate)^A108/100000)","v":4937.8155104994457},null,0.05,0.05,0.11597235925756133,0.11597235925756133,0.28874164778961342,0.28874164778961342,0.14491657558557797,0.14491657558557797,-0.33841752889893906,-0.33841752889893906,null,"no funds",169929,218665,66047,3466,null,null,null,null,null,null,null,null,null,null,96,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ108=SUM(AN95:AN1194),NA(),IF(AQ108<>0,IF((AT107-B107)*(1+alloc1*Simulator!E108+alloc2*Simulator!F108+alloc3*Simulator!H108+alloc4*Simulator!J108+alloc5*Simulator!M108)<0,NA(),(AT107-B107)*(1+alloc1*Simulator!E108+alloc2*Simulator!F108+alloc3*Simulator!H108+alloc4*Simulator!J108+alloc5*Simulator!M108)),NA()))","v":{"$error":"#N/A"}},null,3447.359199593423,{"$error":"#DIV/0!"},10798.082956008617,{"$error":"#DIV/0!"},3264.8019800124216,{"$error":"#DIV/0!"},161.14901239701493,{"$error":"#DIV/0!"}]
[97,{"$f":"(prepen1*(1+rinf)^A109/100000)-(pension/100000)-(income*(1+incrate)^A109/100000)","v":5144.6538783140295},null,{"$f":"IF(E109<>\"\",E109,_min1)","v":0.05},0.05,8.1395679236394625E-2,{"$f":"IF(F109<>\"\",F109,NORMINV(RAND(),mean2,stdev2))","v":8.1395679236394625E-2},4.028108798926483E-4,{"$f":"IF(H109<>\"\",H109,NORMINV(RAND(),mean3,stdev3))","v":4.028108798926483E-4},-4.2729273992594852E-2,{"$f":"IF(J109<>\"\",J109,NORMINV(RAND(),mean4,stdev4))","v":-4.2729273992594852E-2},{"$f":"IF(M109<>\"\",M109,NORMINV(RAND(),mean5,stdev5))","v":-6.1910074313813818E-2},-6.1910074313813818E-2,null,"no funds",183760,218753,63225,3251,null,null,null,null,null,null,null,null,null,null,97,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ109=SUM(AN96:AN1195),NA(),IF(AQ109<>0,IF((AT108-B108)*(1+alloc1*Simulator!E109+alloc2*Simulator!F109+alloc3*Simulator!H109+alloc4*Simulator!J109+alloc5*Simulator!M109)<0,NA(),(AT108-B108)*(1+alloc1*Simulator!E109+alloc2*Simulator!F109+alloc3*Simulator!H109+alloc4*Simulator!J109+alloc5*Simulator!M109)),NA()))","v":{"$error":"#N/A"}},null,3727.9593432161632,{"$error":"#DIV/0!"},10802.432541305279,{"$error":"#DIV/0!"},3125.2993616769045,{"$error":"#DIV/0!"},151.17226506391805,{"$error":"#DIV/0!"}]
[98,{"$f":"(prepen1*(1+rinf)^A110/100000)-(pension/100000)-(income*(1+incrate)^A110/100000)","v":5349.2146282512422},null,{"$f":"IF(E110<>\"\",E110,_min1)","v":0.05},0.05,7.1726210571019341E-2,{"$f":"IF(F110<>\"\",F110,NORMINV(RAND(),mean2,stdev2))","v":7.1726210571019341E-2},1.7732164140516329E-2,{"$f":"IF(H110<>\"\",H110,NORMINV(RAND(),mean3,stdev3))","v":1.7732164140516329E-2},8.4112473615002931E-2,{"$f":"IF(J110<>\"\",J110,NORMINV(RAND(),mean4,stdev4))","v":8.4112473615002931E-2},{"$f":"IF(M110<>\"\",M110,NORMINV(RAND(),mean5,stdev5))","v":-0.55162743244706192},-0.55162743244706192,null,"no funds",196940,222632,68543,1458,null,null,null,null,null,null,null,null,null,null,98,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ110=SUM(AN97:AN1196),NA(),IF(AQ110<>0,IF((AT109-B109)*(1+alloc1*Simulator!E110+alloc2*Simulator!F110+alloc3*Simulator!H110+alloc4*Simulator!J110+alloc5*Simulator!M110)<0,NA(),(AT109-B109)*(1+alloc1*Simulator!E110+alloc2*Simulator!F110+alloc3*Simulator!H110+alloc4*Simulator!J110+alloc5*Simulator!M110)),NA()))","v":{"$error":"#N/A"}},null,3995.3517400678843,{"$error":"#DIV/0!"},10993.98304824456,{"$error":"#DIV/0!"},3388.1760217749388,{"$error":"#DIV/0!"},67.781496629502257,{"$error":"#DIV/0!"}]
[99,{"$f":"(prepen1*(1+rinf)^A111/100000)-(pension/100000)-(income*(1+incrate)^A111/100000)","v":5549.433082150641},null,{"$f":"IF(E111<>\"\",E111,_min1)","v":0.05},0.05,5.7730919639457007E-2,{"$f":"IF(F111<>\"\",F111,NORMINV(RAND(),mean2,stdev2))","v":5.7730919639457007E-2},7.5167065176943743E-2,{"$f":"IF(H111<>\"\",H111,NORMINV(RAND(),mean3,stdev3))","v":7.5167065176943743E-2},0.13995532710502889,{"$f":"IF(J111<>\"\",J111,NORMINV(RAND(),mean4,stdev4))","v":0.13995532710502889},{"$f":"IF(M111<>\"\",M111,NORMINV(RAND(),mean5,stdev5))","v":0.50923279431930013},0.50923279431930013,null,"no funds",208310,239367,78136,2200,null,null,null,null,null,null,null,null,null,null,99,null,null,null,null,null,null,null,null,0,0,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(AQ111=SUM(AN98:AN1197),NA(),IF(AQ111<>0,IF((AT110-B110)*(1+alloc1*Simulator!E111+alloc2*Simulator!F111+alloc3*Simulator!H111+alloc4*Simulator!J111+alloc5*Simulator!M111)<0,NA(),(AT110-B110)*(1+alloc1*Simulator!E111+alloc2*Simulator!F111+alloc3*Simulator!H111+alloc4*Simulator!J111+alloc5*Simulator!M111)),NA()))","v":{"$error":"#N/A"}},null,4226.0070703051088,{"$error":"#DIV/0!"},11820.368488586173,{"$error":"#DIV/0!"},3862.3693051918658,{"$error":"#DIV/0!"},102.29805756128791,{"$error":"#DIV/0!"}]

{"sheet":"Example results","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Read me whenever!","index":4,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Background and Motivation"]
["Mr. P V Subramanyam (subramoney.com) introduced the idea of retirement buckets and urged me to a build a calculator. When I looked around for"]
["what was available I first ound a terrific free version offered by ISG Planning (and stopped looking!)"]
["This simulator is inspired by and influenced by the free Investment Income Simulator available at ",null,null,null,null,null,null,null,null,"ISG Planning"]
["That said the simulator has been bulit independently from the ground-up. Why do this when something is already available for free? I believe my version offers "]
["additional flexibility and features. These include: "]
["1. an extra investment bucket with information on how long the initial allocation to bucket 1 will last."]
["2. a standard retirment calculator and comparison with the bucket stratergy"]
["3. Choice of defining the volatility in each bucket"]
["4. Choice of including annuity and additonal income"]
["Some useful features in the ISG version are not (yet!) available. There are also some differences. For example:"]
["a. Correlation among the different kind of stocks"]
["b. Dividends from stocks is not considered"]
["c. The exact nature of the Monte Carlo simulation used by ISG is not known. I have simply used random returns that obey a Normal distribution without any averaging"]
["Sometimes the random returns may not reflect historic market trends. As this is only a informative and practice tool I don't intende to change this unless there is interest from users"]
["d. Of course the ISG version is way more better looking and user friendly than mine. However I am not going to lose sleep over this."]
["I made this calculator because I  believe diversification (ie. Additional buckets) with a wide range in volatility maybe necessary to combat high inflation rates that prevail in India. "]
[]
["Remember: This is a work in progress. I have tried this out several times to weed out errors. No guarantees can however be made that it is error free. If you find a bug kindly bring it to my notice."]
[]
["Is it correct to use software to predict market returns? Is the math behind this a proven one? "]
["I don't care! Forgive me for soudning a tad irresponsible. This is the only stand to take when there is no universal agreement on which model "]
["(Monte Carlo or Historical) to use for returns and which distribution to use or whether to use one at all!"]
["This is a practice tool and not a calculator. It models a situation with different volatilites and prepares you for handling your retirement corpus."]
["The more times you play it the better you get. This is not a tool that claims to mimic market conditions. I don't think any toolmaker can make that claim"]
["The bottomline: My idea of making this calculator is to introduce a technique which if used properly might (only might) be a more"]
["efficient way of managing a retirement corpus. Is this suitable for everyone? Unfortunately no. Some experience in at least handling mutual fund investments maybe necessary."]
["A financial planner with experience in handling retirment buckets would certainly help. Finding one is another matter"]
[]
[]
["Note on error: \"You don't have enough funds in Bucket 5 to make this transfer! If didn't want to make a transfer please see the 'Notes' sheet!\""]
["If you got this error and didn't want to make a transfer it means that the returns next year will wipe out the balance in the concerned bucket!"]
["As of now you don’t have a choice but to start all over again. You could of course transfer the balance and proceed. The error will go away but"]
["that is like predicting the future and hence cheating!"]