{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Datos","Regla4%","Guyton-Klinger","Ratchet","Graficos OK"],"not_rendered":{"charts":2,"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Datos","index":0,"n_rows":26,"n_cols":2,"rows_kept":26}
["Año","Rentabilidad"]
[1,{"v":-0.18,"d":"-18.00%"}]
[2,{"v":-0.26,"d":"-26.00%"}]
[3,{"v":-0.12,"d":"-12.00%"}]
[4,{"v":0.05,"d":"5.00%"}]
[5,{"v":0.12,"d":"12.00%"}]
[6,{"v":0.15,"d":"15.00%"}]
[7,{"v":0.16,"d":"16.00%"}]
[8,{"v":0.18,"d":"18.00%"}]
[9,{"v":-0.22,"d":"-22.00%"}]
[10,{"v":0.25,"d":"25.00%"}]
[11,{"v":0.22,"d":"22.00%"}]
[12,{"v":0.2,"d":"20.00%"}]
[13,{"v":0.18,"d":"18.00%"}]
[14,{"v":0.17,"d":"17.00%"}]
[15,{"v":0.15,"d":"15.00%"}]
[16,{"v":0.12,"d":"12.00%"}]
[17,{"v":0.1,"d":"10.00%"}]
[18,{"v":0.21,"d":"21.00%"}]
[19,{"v":0.19,"d":"19.00%"}]
[20,{"v":0.15,"d":"15.00%"}]
[21,{"v":0.11,"d":"11.00%"}]
[22,{"v":-0.07,"d":"-7.00%"}]
[23,{"v":-0.1,"d":"-10.00%"}]
[24,{"v":0.04,"d":"4.00%"}]
[25,{"v":0.04,"d":"4.00%"}]

{"sheet":"Regla4%","index":1,"n_rows":26,"n_cols":5,"rows_kept":26}
["Año","Rentabilidad","Capital Inicial","Retirada","Capital Final"]
[1,{"$f":"+Datos!B2","v":{"v":-0.18,"d":"-18.00%"}},{"v":500000,"d":"500,000"},{"v":20000,"d":"20,000"},{"$f":"C2*(1+B2)-D2","v":{"v":390000.00000000006,"d":"390,000"}}]
[2,{"$f":"+Datos!B3","v":{"v":-0.26,"d":"-26.00%"}},{"$f":"E2","v":{"v":390000.00000000006,"d":"390,000"}},{"$f":"D2*1.02","v":{"v":20400,"d":"20,400"}},{"v":268200.00000000006,"d":"268,200"}]
[3,{"$f":"+Datos!B4","v":{"v":-0.12,"d":"-12.00%"}},{"$f":"E3","v":{"v":268200.00000000006,"d":"268,200"}},{"v":20808,"d":"20,808"},{"$f":"C4*(1+B4)-D4","v":{"v":215208.00000000006,"d":"215,208"}}]
[4,{"$f":"+Datos!B5","v":{"v":0.05,"d":"5.00%"}},{"v":215208.00000000006,"d":"215,208"},{"v":21224.16,"d":"21,224"},{"v":204744.24000000008,"d":"204,744"}]
[5,{"$f":"+Datos!B6","v":{"v":0.12,"d":"12.00%"}},{"v":204744.24000000008,"d":"204,744"},{"v":21648.6432,"d":"21,649"},{"v":207664.90560000011,"d":"207,665"}]
[6,{"$f":"+Datos!B7","v":{"v":0.15,"d":"15.00%"}},{"v":207664.90560000011,"d":"207,665"},{"v":22081.616063999998,"d":"22,082"},{"v":216733.02537600012,"d":"216,733"}]
[7,{"$f":"+Datos!B8","v":{"v":0.16,"d":"16.00%"}},{"v":216733.02537600012,"d":"216,733"},{"v":22523.24838528,"d":"22,523"},{"v":228887.06105088012,"d":"228,887"}]
[8,{"$f":"+Datos!B9","v":{"v":0.18,"d":"18.00%"}},{"v":228887.06105088012,"d":"228,887"},{"v":22973.7133529856,"d":"22,974"},{"v":247113.0186870529,"d":"247,113"}]
[9,{"$f":"+Datos!B10","v":{"v":-0.22,"d":"-22.00%"}},{"v":247113.0186870529,"d":"247,113"},{"v":23433.18762004531,"d":"23,433"},{"v":169314.96695585595,"d":"169,315"}]
[10,{"$f":"+Datos!B11","v":{"v":0.25,"d":"25.00%"}},{"v":169314.96695585595,"d":"169,315"},{"v":23901.851372446217,"d":"23,902"},{"v":187741.85732237372,"d":"187,742"}]
[11,{"$f":"+Datos!B12","v":{"v":0.22,"d":"22.00%"}},{"v":187741.85732237372,"d":"187,742"},{"v":24379.888399895142,"d":"24,380"},{"v":204665.1775334008,"d":"204,665"}]
[12,{"$f":"+Datos!B13","v":{"v":0.2,"d":"20.00%"}},{"v":204665.1775334008,"d":"204,665"},{"v":24867.486167893047,"d":"24,867"},{"v":220730.7268721879,"d":"220,731"}]
[13,{"$f":"+Datos!B14","v":{"v":0.18,"d":"18.00%"}},{"v":220730.7268721879,"d":"220,731"},{"v":25364.835891250907,"d":"25,365"},{"v":235097.4218179308,"d":"235,097"}]
[14,{"$f":"+Datos!B15","v":{"v":0.17,"d":"17.00%"}},{"v":235097.4218179308,"d":"235,097"},{"v":25872.132609075925,"d":"25,872"},{"v":249191.85091790307,"d":"249,192"}]
[15,{"$f":"+Datos!B16","v":{"v":0.15,"d":"15.00%"}},{"v":249191.85091790307,"d":"249,192"},{"v":26389.575261257443,"d":"26,390"},{"v":260181.05329433104,"d":"260,181"}]
[16,{"$f":"+Datos!B17","v":{"v":0.12,"d":"12.00%"}},{"v":260181.05329433104,"d":"260,181"},{"v":26917.36676648259,"d":"26,917"},{"v":264485.4129231682,"d":"264,485"}]
[17,{"$f":"+Datos!B18","v":{"v":0.1,"d":"10.00%"}},{"v":264485.4129231682,"d":"264,485"},{"v":27455.714101812246,"d":"27,456"},{"v":263478.24011367286,"d":"263,478"}]
[18,{"$f":"+Datos!B19","v":{"v":0.21,"d":"21.00%"}},{"v":263478.24011367286,"d":"263,478"},{"v":28004.82838384849,"d":"28,005"},{"v":290803.84215369564,"d":"290,804"}]
[19,{"$f":"+Datos!B20","v":{"v":0.19,"d":"19.00%"}},{"v":290803.84215369564,"d":"290,804"},{"v":28564.92495152546,"d":"28,565"},{"v":317491.6472113723,"d":"317,492"}]
[20,{"$f":"+Datos!B21","v":{"v":0.15,"d":"15.00%"}},{"v":317491.6472113723,"d":"317,492"},{"v":29136.223450555968,"d":"29,136"},{"v":335979.1708425222,"d":"335,979"}]
[21,{"$f":"+Datos!B22","v":{"v":0.11,"d":"11.00%"}},{"v":335979.1708425222,"d":"335,979"},{"v":29718.947919567087,"d":"29,719"},{"v":343217.93171563256,"d":"343,218"}]
[22,{"$f":"+Datos!B23","v":{"v":-0.07,"d":"-7.00%"}},{"v":343217.93171563256,"d":"343,218"},{"v":30313.32687795843,"d":"30,313"},{"v":288879.34961757984,"d":"288,879"}]
[23,{"$f":"+Datos!B24","v":{"v":-0.1,"d":"-10.00%"}},{"v":288879.34961757984,"d":"288,879"},{"v":30919.593415517596,"d":"30,920"},{"v":229071.82124030427,"d":"229,072"}]
[24,{"$f":"+Datos!B25","v":{"v":0.04,"d":"4.00%"}},{"v":229071.82124030427,"d":"229,072"},{"v":31537.985283827948,"d":"31,538"},{"v":206696.70880608849,"d":"206,697"}]
[25,{"$f":"+Datos!B26","v":{"v":0.04,"d":"4.00%"}},{"v":206696.70880608849,"d":"206,697"},{"v":32168.744989504507,"d":"32,169"},{"v":182795.83216882753,"d":"182,796"}]

{"sheet":"Guyton-Klinger","index":2,"n_rows":26,"n_cols":8,"rows_kept":26}
["Año","Rentabilidad","Capital Inicial","Retirada","Capital Final","WR","GuardSup","GuardInf"]
[1,{"$f":"+Datos!B2","v":{"v":-0.18,"d":"-18.00%"}},{"v":500000,"d":"500,000"},{"v":20000,"d":"20,000"},{"$f":"C2*(1+B2)-D2","v":{"v":390000.00000000006,"d":"390,000"}},{"$f":"+D2/C2","v":0.04},0.048,0.032]
[2,{"$f":"+Datos!B3","v":{"v":-0.26,"d":"-26.00%"}},{"$f":"+E2","v":{"v":390000.00000000006,"d":"390,000"}},{"$f":"MAX(\n   15000,\n   IF(\n      F3>G3,\n         D2*0.95,\n         IF(\n            F3<H3,\n               D2*1.1,\n               D2*1.02\n         )\n   )\n)","v":{"v":19000,"d":"19,000"}},{"$f":"C3*(1+B3)-D3","v":{"v":269600.00000000006,"d":"269,600"}},{"$f":"+D2/C3","v":{"v":0.05128205128205127,"d":"0.05"}},0.048,0.032]
[3,{"$f":"+Datos!B4","v":{"v":-0.12,"d":"-12.00%"}},{"$f":"+E3","v":{"v":269600.00000000006,"d":"269,600"}},{"$f":"MAX(\n   15000,\n   IF(\n      F4>G4,\n         D3*0.95,\n         IF(\n            F4<H4,\n               D3*1.1,\n               D3*1.02\n         )\n   )\n)","v":{"v":18050,"d":"18,050"}},{"$f":"C4*(1+B4)-D4","v":{"v":219198.00000000006,"d":"219,198"}},{"$f":"+D3/C4","v":{"v":0.07047477744807121,"d":"0.07"}},0.048,0.032]
[4,{"$f":"+Datos!B5","v":{"v":0.05,"d":"5.00%"}},{"v":219198.00000000006,"d":"219,198"},{"v":17147.5,"d":"17,148"},{"v":213010.40000000008,"d":"213,010"},{"v":0.08234564183979778,"d":"0.08"},0.048,0.032]
[5,{"$f":"+Datos!B6","v":{"v":0.12,"d":"12.00%"}},{"v":213010.40000000008,"d":"213,010"},{"v":16290.125,"d":"16,290"},{"v":222281.5230000001,"d":"222,282"},{"v":0.08050076428193174,"d":"0.08"},0.048,0.032]
[6,{"$f":"+Datos!B7","v":{"v":0.15,"d":"15.00%"}},{"v":222281.5230000001,"d":"222,282"},{"v":15475.61875,"d":"15,476"},{"v":240148.1327000001,"d":"240,148"},{"v":0.07328600587283178,"d":"0.07"},0.048,0.032]
[7,{"$f":"+Datos!B8","v":{"v":0.16,"d":"16.00%"}},{"v":240148.1327000001,"d":"240,148"},{"v":15000,"d":"15,000"},{"v":263571.8339320001,"d":"263,572"},{"v":0.0644419699458275,"d":"0.06"},0.048,0.032]
[8,{"$f":"+Datos!B9","v":{"v":0.18,"d":"18.00%"}},{"v":263571.8339320001,"d":"263,572"},{"v":15000,"d":"15,000"},{"v":296014.7640397601,"d":"296,015"},{"v":0.056910481580023105,"d":"0.06"},0.048,0.032]
[9,{"$f":"+Datos!B10","v":{"v":-0.22,"d":"-22.00%"}},{"v":296014.7640397601,"d":"296,015"},{"v":15000,"d":"15,000"},{"v":215891.5159510129,"d":"215,892"},{"v":0.05067314817441075,"d":"0.05"},0.048,0.032]
[10,{"$f":"+Datos!B11","v":{"v":0.25,"d":"25.00%"}},{"v":215891.5159510129,"d":"215,892"},{"v":15000,"d":"15,000"},{"v":254864.39493876614,"d":"254,864"},{"v":0.06947933981529682,"d":"0.07"},0.048,0.032]
[11,{"$f":"+Datos!B12","v":{"v":0.22,"d":"22.00%"}},{"v":254864.39493876614,"d":"254,864"},{"v":15000,"d":"15,000"},{"v":295934.5618252947,"d":"295,935"},{"v":0.05885482749994917,"d":"0.06"},0.048,0.032]
[12,{"$f":"+Datos!B13","v":{"v":0.2,"d":"20.00%"}},{"v":295934.5618252947,"d":"295,935"},{"v":15000,"d":"15,000"},{"v":340121.4741903536,"d":"340,121"},{"v":0.050686881273621795,"d":"0.05"},0.048,0.032]
[13,{"$f":"+Datos!B14","v":{"v":0.18,"d":"18.00%"}},{"v":340121.4741903536,"d":"340,121"},{"v":15300,"d":"15,300"},{"v":386043.3395446172,"d":"386,043"},{"v":0.0441018904663604,"d":"0.04"},0.048,0.032]
[14,{"$f":"+Datos!B15","v":{"v":0.17,"d":"17.00%"}},{"v":386043.3395446172,"d":"386,043"},{"v":15606,"d":"15,606"},{"v":436064.70726720215,"d":"436,065"},{"v":0.03963285577740603,"d":"0.04"},0.048,0.032]
[15,{"$f":"+Datos!B16","v":{"v":0.15,"d":"15.00%"}},{"v":436064.70726720215,"d":"436,065"},{"v":15918.12,"d":"15,918"},{"v":485556.2933572824,"d":"485,556"},{"v":0.035788266603372004,"d":"0.04"},0.048,0.032]
[16,{"$f":"+Datos!B17","v":{"v":0.12,"d":"12.00%"}},{"v":485556.2933572824,"d":"485,556"},{"v":16236.4824,"d":"16,236"},{"v":527586.5661601564,"d":"527,587"},{"v":0.03278326368697093,"d":"0.03"},0.048,0.032]
[17,{"$f":"+Datos!B18","v":{"v":0.1,"d":"10.00%"}},{"v":527586.5661601564,"d":"527,587"},{"v":17860.130640000003,"d":"17,860"},{"v":562485.0921361721,"d":"562,485"},{"v":0.03077501104353591,"d":"0.03"},0.048,0.032]
[18,{"$f":"+Datos!B19","v":{"v":0.21,"d":"21.00%"}},{"v":562485.0921361721,"d":"562,485"},{"v":19646.143704000006,"d":"19,646"},{"v":660960.8177807681,"d":"660,961"},{"v":0.031752184883997316,"d":"0.03"},0.048,0.032]
[19,{"$f":"+Datos!B20","v":{"v":0.19,"d":"19.00%"}},{"v":660960.8177807681,"d":"660,961"},{"v":21610.758074400008,"d":"21,611"},{"v":764932.615084714,"d":"764,933"},{"v":0.02972361322409942,"d":"0.03"},0.048,0.032]
[20,{"$f":"+Datos!B21","v":{"v":0.15,"d":"15.00%"}},{"v":764932.615084714,"d":"764,933"},{"v":23771.83388184001,"d":"23,772"},{"v":855900.673465581,"d":"855,901"},{"v":0.028251845519760822,"d":"0.03"},0.048,0.032]
[21,{"$f":"+Datos!B22","v":{"v":0.11,"d":"11.00%"}},{"v":855900.673465581,"d":"855,901"},{"v":26149.017270024015,"d":"26,149"},{"v":923900.730276771,"d":"923,901"},{"v":0.027774056755425564,"d":"0.03"},0.048,0.032]
[22,{"$f":"+Datos!B23","v":{"v":-0.07,"d":"-7.00%"}},{"v":923900.730276771,"d":"923,901"},{"v":28763.91899702642,"d":"28,764"},{"v":830463.7601603706,"d":"830,464"},{"v":0.028302842949578154,"d":"0.03"},0.048,0.032]
[23,{"$f":"+Datos!B24","v":{"v":-0.1,"d":"-10.00%"}},{"v":830463.7601603706,"d":"830,464"},{"v":29339.19737696695,"d":"29,339"},{"v":718078.1867673666,"d":"718,078"},{"v":0.034635971341448815,"d":"0.03"},0.048,0.032]
[24,{"$f":"+Datos!B25","v":{"v":0.04,"d":"4.00%"}},{"v":718078.1867673666,"d":"718,078"},{"v":29925.98132450629,"d":"29,926"},{"v":716875.332913555,"d":"716,875"},{"v":0.040857942655305686,"d":"0.04"},0.048,0.032]
[25,{"$f":"+Datos!B26","v":{"v":0.04,"d":"4.00%"}},{"v":716875.332913555,"d":"716,875"},{"v":30524.50095099642,"d":"30,525"},{"v":715025.8452791008,"d":"715,026"},{"v":0.041745028668903776,"d":"0.04"},0.048,0.032]

{"sheet":"Ratchet","index":3,"n_rows":26,"n_cols":6,"rows_kept":26}
["Año","Rentabilidad","Capital Inicial","Retirada","Capital Final","MaxNominal"]
[1,{"$f":"+Datos!B2","v":{"v":-0.18,"d":"-18.00%"}},{"v":500000,"d":"500,000"},{"v":20000,"d":"20,000"},{"$f":"C2*(1+B2)-D2","v":{"v":390000.00000000006,"d":"390,000"}},{"$f":"+C2","v":{"v":500000,"d":"500,000"}}]
[2,{"$f":"+Datos!B3","v":{"v":-0.26,"d":"-26.00%"}},{"$f":"E2","v":{"v":390000.00000000006,"d":"390,000"}},{"$f":"IF(C3>F2*0.9, D2*1.02, D2)","v":{"v":20000,"d":"20,000"}},{"$f":"C3*(1+B3)-D3","v":{"v":268600.00000000006,"d":"268,600"}},{"$f":"MAX(F2,C3)","v":{"v":500000,"d":"500,000"}}]
[3,{"$f":"+Datos!B4","v":{"v":-0.12,"d":"-12.00%"}},{"$f":"E3","v":{"v":268600.00000000006,"d":"268,600"}},{"$f":"IF(C4>F3*0.9, D3*1.02, D3)","v":{"v":20000,"d":"20,000"}},{"$f":"C4*(1+B4)-D4","v":{"v":216368.00000000006,"d":"216,368"}},{"$f":"MAX(F3,C4)","v":{"v":500000,"d":"500,000"}}]
[4,{"$f":"+Datos!B5","v":{"v":0.05,"d":"5.00%"}},{"v":216368.00000000006,"d":"216,368"},{"v":20000,"d":"20,000"},{"v":207186.40000000008,"d":"207,186"},{"v":500000,"d":"500,000"}]
[5,{"$f":"+Datos!B6","v":{"v":0.12,"d":"12.00%"}},{"v":207186.40000000008,"d":"207,186"},{"v":20000,"d":"20,000"},{"v":212048.76800000013,"d":"212,049"},{"v":500000,"d":"500,000"}]
[6,{"$f":"+Datos!B7","v":{"v":0.15,"d":"15.00%"}},{"v":212048.76800000013,"d":"212,049"},{"v":20000,"d":"20,000"},{"v":223856.08320000014,"d":"223,856"},{"v":500000,"d":"500,000"}]
[7,{"$f":"+Datos!B8","v":{"v":0.16,"d":"16.00%"}},{"v":223856.08320000014,"d":"223,856"},{"v":20000,"d":"20,000"},{"v":239673.05651200016,"d":"239,673"},{"v":500000,"d":"500,000"}]
[8,{"$f":"+Datos!B9","v":{"v":0.18,"d":"18.00%"}},{"v":239673.05651200016,"d":"239,673"},{"v":20000,"d":"20,000"},{"v":262814.20668416016,"d":"262,814"},{"v":500000,"d":"500,000"}]
[9,{"$f":"+Datos!B10","v":{"v":-0.22,"d":"-22.00%"}},{"v":262814.20668416016,"d":"262,814"},{"v":20000,"d":"20,000"},{"v":184995.08121364494,"d":"184,995"},{"v":500000,"d":"500,000"}]
[10,{"$f":"+Datos!B11","v":{"v":0.25,"d":"25.00%"}},{"v":184995.08121364494,"d":"184,995"},{"v":20000,"d":"20,000"},{"v":211243.85151705617,"d":"211,244"},{"v":500000,"d":"500,000"}]
[11,{"$f":"+Datos!B12","v":{"v":0.22,"d":"22.00%"}},{"v":211243.85151705617,"d":"211,244"},{"v":20000,"d":"20,000"},{"v":237717.49885080854,"d":"237,717"},{"v":500000,"d":"500,000"}]
[12,{"$f":"+Datos!B13","v":{"v":0.2,"d":"20.00%"}},{"v":237717.49885080854,"d":"237,717"},{"v":20000,"d":"20,000"},{"v":265260.99862097023,"d":"265,261"},{"v":500000,"d":"500,000"}]
[13,{"$f":"+Datos!B14","v":{"v":0.18,"d":"18.00%"}},{"v":265260.99862097023,"d":"265,261"},{"v":20000,"d":"20,000"},{"v":293007.97837274487,"d":"293,008"},{"v":500000,"d":"500,000"}]
[14,{"$f":"+Datos!B15","v":{"v":0.17,"d":"17.00%"}},{"v":293007.97837274487,"d":"293,008"},{"v":20000,"d":"20,000"},{"v":322819.3346961115,"d":"322,819"},{"v":500000,"d":"500,000"}]
[15,{"$f":"+Datos!B16","v":{"v":0.15,"d":"15.00%"}},{"v":322819.3346961115,"d":"322,819"},{"v":20000,"d":"20,000"},{"v":351242.2349005282,"d":"351,242"},{"v":500000,"d":"500,000"}]
[16,{"$f":"+Datos!B17","v":{"v":0.12,"d":"12.00%"}},{"v":351242.2349005282,"d":"351,242"},{"v":20000,"d":"20,000"},{"v":373391.30308859167,"d":"373,391"},{"v":500000,"d":"500,000"}]
[17,{"$f":"+Datos!B18","v":{"v":0.1,"d":"10.00%"}},{"v":373391.30308859167,"d":"373,391"},{"v":20000,"d":"20,000"},{"v":390730.4333974509,"d":"390,730"},{"v":500000,"d":"500,000"}]
[18,{"$f":"+Datos!B19","v":{"v":0.21,"d":"21.00%"}},{"v":390730.4333974509,"d":"390,730"},{"v":20000,"d":"20,000"},{"v":452783.82441091555,"d":"452,784"},{"v":500000,"d":"500,000"}]
[19,{"$f":"+Datos!B20","v":{"v":0.19,"d":"19.00%"}},{"v":452783.82441091555,"d":"452,784"},{"v":20400,"d":"20,400"},{"v":518412.7510489895,"d":"518,413"},{"v":500000,"d":"500,000"}]
[20,{"$f":"+Datos!B21","v":{"v":0.15,"d":"15.00%"}},{"v":518412.7510489895,"d":"518,413"},{"v":20808,"d":"20,808"},{"v":575366.6637063378,"d":"575,367"},{"v":518412.7510489895,"d":"518,413"}]
[21,{"$f":"+Datos!B22","v":{"v":0.11,"d":"11.00%"}},{"v":575366.6637063378,"d":"575,367"},{"v":21224.16,"d":"21,224"},{"v":617432.836714035,"d":"617,433"},{"v":575366.6637063378,"d":"575,367"}]
[22,{"$f":"+Datos!B23","v":{"v":-0.07,"d":"-7.00%"}},{"v":617432.836714035,"d":"617,433"},{"v":21648.6432,"d":"21,649"},{"v":552563.8949440524,"d":"552,564"},{"v":617432.836714035,"d":"617,433"}]
[23,{"$f":"+Datos!B24","v":{"v":-0.1,"d":"-10.00%"}},{"v":552563.8949440524,"d":"552,564"},{"v":21648.6432,"d":"21,649"},{"v":475658.8622496472,"d":"475,659"},{"v":617432.836714035,"d":"617,433"}]
[24,{"$f":"+Datos!B25","v":{"v":0.04,"d":"4.00%"}},{"v":475658.8622496472,"d":"475,659"},{"v":21648.6432,"d":"21,649"},{"v":473036.57353963313,"d":"473,037"},{"v":617432.836714035,"d":"617,433"}]
[25,{"$f":"+Datos!B26","v":{"v":0.04,"d":"4.00%"}},{"v":473036.57353963313,"d":"473,037"},{"v":21648.6432,"d":"21,649"},{"v":470309.3932812185,"d":"470,309"},{"v":617432.836714035,"d":"617,433"}]

{"sheet":"Graficos OK","index":4,"n_rows":57,"n_cols":5,"rows_kept":57}
["Años","Regal 4%","Guyton-K","Ratchet"]
[1,{"$f":"+'Regla4%'!E2","v":{"v":390000.00000000006,"d":"390,000"}},{"$f":"+'Guyton-Klinger'!E2","v":{"v":390000.00000000006,"d":"390,000"}},{"$f":"+Ratchet!E2","v":{"v":390000.00000000006,"d":"390,000"}}]
[2,{"$f":"+'Regla4%'!E3","v":{"v":268200.00000000006,"d":"268,200"}},{"$f":"+'Guyton-Klinger'!E3","v":{"v":269600.00000000006,"d":"269,600"}},{"$f":"+Ratchet!E3","v":{"v":268600.00000000006,"d":"268,600"}}]
[3,{"$f":"+'Regla4%'!E4","v":{"v":215208.00000000006,"d":"215,208"}},{"$f":"+'Guyton-Klinger'!E4","v":{"v":219198.00000000006,"d":"219,198"}},{"$f":"+Ratchet!E4","v":{"v":216368.00000000006,"d":"216,368"}}]
[4,{"$f":"+'Regla4%'!E5","v":{"v":204744.24000000008,"d":"204,744"}},{"$f":"+'Guyton-Klinger'!E5","v":{"v":213010.40000000008,"d":"213,010"}},{"$f":"+Ratchet!E5","v":{"v":207186.40000000008,"d":"207,186"}}]
[5,{"$f":"+'Regla4%'!E6","v":{"v":207664.90560000011,"d":"207,665"}},{"$f":"+'Guyton-Klinger'!E6","v":{"v":222281.5230000001,"d":"222,282"}},{"$f":"+Ratchet!E6","v":{"v":212048.76800000013,"d":"212,049"}}]
[6,{"$f":"+'Regla4%'!E7","v":{"v":216733.02537600012,"d":"216,733"}},{"$f":"+'Guyton-Klinger'!E7","v":{"v":240148.1327000001,"d":"240,148"}},{"$f":"+Ratchet!E7","v":{"v":223856.08320000014,"d":"223,856"}}]
[7,{"$f":"+'Regla4%'!E8","v":{"v":228887.06105088012,"d":"228,887"}},{"$f":"+'Guyton-Klinger'!E8","v":{"v":263571.8339320001,"d":"263,572"}},{"$f":"+Ratchet!E8","v":{"v":239673.05651200016,"d":"239,673"}}]
[8,{"$f":"+'Regla4%'!E9","v":{"v":247113.0186870529,"d":"247,113"}},{"$f":"+'Guyton-Klinger'!E9","v":{"v":296014.7640397601,"d":"296,015"}},{"$f":"+Ratchet!E9","v":{"v":262814.20668416016,"d":"262,814"}}]
[9,{"$f":"+'Regla4%'!E10","v":{"v":169314.96695585595,"d":"169,315"}},{"$f":"+'Guyton-Klinger'!E10","v":{"v":215891.5159510129,"d":"215,892"}},{"$f":"+Ratchet!E10","v":{"v":184995.08121364494,"d":"184,995"}}]
[10,{"$f":"+'Regla4%'!E11","v":{"v":187741.85732237372,"d":"187,742"}},{"$f":"+'Guyton-Klinger'!E11","v":{"v":254864.39493876614,"d":"254,864"}},{"$f":"+Ratchet!E11","v":{"v":211243.85151705617,"d":"211,244"}}]
[11,{"$f":"+'Regla4%'!E12","v":{"v":204665.1775334008,"d":"204,665"}},{"$f":"+'Guyton-Klinger'!E12","v":{"v":295934.5618252947,"d":"295,935"}},{"$f":"+Ratchet!E12","v":{"v":237717.49885080854,"d":"237,717"}}]
[12,{"$f":"+'Regla4%'!E13","v":{"v":220730.7268721879,"d":"220,731"}},{"$f":"+'Guyton-Klinger'!E13","v":{"v":340121.4741903536,"d":"340,121"}},{"$f":"+Ratchet!E13","v":{"v":265260.99862097023,"d":"265,261"}}]
[13,{"$f":"+'Regla4%'!E14","v":{"v":235097.4218179308,"d":"235,097"}},{"$f":"+'Guyton-Klinger'!E14","v":{"v":386043.3395446172,"d":"386,043"}},{"$f":"+Ratchet!E14","v":{"v":293007.97837274487,"d":"293,008"}}]
[14,{"$f":"+'Regla4%'!E15","v":{"v":249191.85091790307,"d":"249,192"}},{"$f":"+'Guyton-Klinger'!E15","v":{"v":436064.70726720215,"d":"436,065"}},{"$f":"+Ratchet!E15","v":{"v":322819.3346961115,"d":"322,819"}}]
[15,{"$f":"+'Regla4%'!E16","v":{"v":260181.05329433104,"d":"260,181"}},{"$f":"+'Guyton-Klinger'!E16","v":{"v":485556.2933572824,"d":"485,556"}},{"$f":"+Ratchet!E16","v":{"v":351242.2349005282,"d":"351,242"}}]
[16,{"$f":"+'Regla4%'!E17","v":{"v":264485.4129231682,"d":"264,485"}},{"$f":"+'Guyton-Klinger'!E17","v":{"v":527586.5661601564,"d":"527,587"}},{"$f":"+Ratchet!E17","v":{"v":373391.30308859167,"d":"373,391"}}]
[17,{"$f":"+'Regla4%'!E18","v":{"v":263478.24011367286,"d":"263,478"}},{"$f":"+'Guyton-Klinger'!E18","v":{"v":562485.0921361721,"d":"562,485"}},{"$f":"+Ratchet!E18","v":{"v":390730.4333974509,"d":"390,730"}}]
[18,{"$f":"+'Regla4%'!E19","v":{"v":290803.84215369564,"d":"290,804"}},{"$f":"+'Guyton-Klinger'!E19","v":{"v":660960.8177807681,"d":"660,961"}},{"$f":"+Ratchet!E19","v":{"v":452783.82441091555,"d":"452,784"}}]
[19,{"$f":"+'Regla4%'!E20","v":{"v":317491.6472113723,"d":"317,492"}},{"$f":"+'Guyton-Klinger'!E20","v":{"v":764932.615084714,"d":"764,933"}},{"$f":"+Ratchet!E20","v":{"v":518412.7510489895,"d":"518,413"}}]
[20,{"$f":"+'Regla4%'!E21","v":{"v":335979.1708425222,"d":"335,979"}},{"$f":"+'Guyton-Klinger'!E21","v":{"v":855900.673465581,"d":"855,901"}},{"$f":"+Ratchet!E21","v":{"v":575366.6637063378,"d":"575,367"}}]
[21,{"$f":"+'Regla4%'!E22","v":{"v":343217.93171563256,"d":"343,218"}},{"$f":"+'Guyton-Klinger'!E22","v":{"v":923900.730276771,"d":"923,901"}},{"$f":"+Ratchet!E22","v":{"v":617432.836714035,"d":"617,433"}}]
[22,{"$f":"+'Regla4%'!E23","v":{"v":288879.34961757984,"d":"288,879"}},{"$f":"+'Guyton-Klinger'!E23","v":{"v":830463.7601603706,"d":"830,464"}},{"$f":"+Ratchet!E23","v":{"v":552563.8949440524,"d":"552,564"}}]
[23,{"$f":"+'Regla4%'!E24","v":{"v":229071.82124030427,"d":"229,072"}},{"$f":"+'Guyton-Klinger'!E24","v":{"v":718078.1867673666,"d":"718,078"}},{"$f":"+Ratchet!E24","v":{"v":475658.8622496472,"d":"475,659"}}]
[24,{"$f":"+'Regla4%'!E25","v":{"v":206696.70880608849,"d":"206,697"}},{"$f":"+'Guyton-Klinger'!E25","v":{"v":716875.332913555,"d":"716,875"}},{"$f":"+Ratchet!E25","v":{"v":473036.57353963313,"d":"473,037"}}]
[25,{"$f":"+'Regla4%'!E26","v":{"v":182795.83216882753,"d":"182,796"}},{"$f":"+'Guyton-Klinger'!E26","v":{"v":715025.8452791008,"d":"715,026"}},{"$f":"+Ratchet!E26","v":{"v":470309.3932812185,"d":"470,309"}},"capital final"]
[]
[]
[]
[]
["Años","Regal 4%","Guyton-K","Ratchet"]
[1,{"$f":"+'Regla4%'!D2","v":{"v":20000,"d":"20,000"}},{"$f":"+'Guyton-Klinger'!D2","v":{"v":20000,"d":"20,000"}},{"$f":"+Ratchet!D2","v":{"v":20000,"d":"20,000"}}]
[2,{"$f":"+'Regla4%'!D3","v":{"v":20400,"d":"20,400"}},{"$f":"+'Guyton-Klinger'!D3","v":{"v":19000,"d":"19,000"}},{"$f":"+Ratchet!D3","v":{"v":20000,"d":"20,000"}}]
[3,{"$f":"+'Regla4%'!D4","v":{"v":20808,"d":"20,808"}},{"$f":"+'Guyton-Klinger'!D4","v":{"v":18050,"d":"18,050"}},{"$f":"+Ratchet!D4","v":{"v":20000,"d":"20,000"}}]
[4,{"$f":"+'Regla4%'!D5","v":{"v":21224.16,"d":"21,224"}},{"$f":"+'Guyton-Klinger'!D5","v":{"v":17147.5,"d":"17,148"}},{"$f":"+Ratchet!D5","v":{"v":20000,"d":"20,000"}}]
[5,{"$f":"+'Regla4%'!D6","v":{"v":21648.6432,"d":"21,649"}},{"$f":"+'Guyton-Klinger'!D6","v":{"v":16290.125,"d":"16,290"}},{"$f":"+Ratchet!D6","v":{"v":20000,"d":"20,000"}}]
[6,{"$f":"+'Regla4%'!D7","v":{"v":22081.616063999998,"d":"22,082"}},{"$f":"+'Guyton-Klinger'!D7","v":{"v":15475.61875,"d":"15,476"}},{"$f":"+Ratchet!D7","v":{"v":20000,"d":"20,000"}}]
[7,{"$f":"+'Regla4%'!D8","v":{"v":22523.24838528,"d":"22,523"}},{"$f":"+'Guyton-Klinger'!D8","v":{"v":15000,"d":"15,000"}},{"$f":"+Ratchet!D8","v":{"v":20000,"d":"20,000"}}]
[8,{"$f":"+'Regla4%'!D9","v":{"v":22973.7133529856,"d":"22,974"}},{"$f":"+'Guyton-Klinger'!D9","v":{"v":15000,"d":"15,000"}},{"$f":"+Ratchet!D9","v":{"v":20000,"d":"20,000"}}]
[9,{"$f":"+'Regla4%'!D10","v":{"v":23433.18762004531,"d":"23,433"}},{"$f":"+'Guyton-Klinger'!D10","v":{"v":15000,"d":"15,000"}},{"$f":"+Ratchet!D10","v":{"v":20000,"d":"20,000"}}]
[10,{"$f":"+'Regla4%'!D11","v":{"v":23901.851372446217,"d":"23,902"}},{"$f":"+'Guyton-Klinger'!D11","v":{"v":15000,"d":"15,000"}},{"$f":"+Ratchet!D11","v":{"v":20000,"d":"20,000"}}]
[11,{"$f":"+'Regla4%'!D12","v":{"v":24379.888399895142,"d":"24,380"}},{"$f":"+'Guyton-Klinger'!D12","v":{"v":15000,"d":"15,000"}},{"$f":"+Ratchet!D12","v":{"v":20000,"d":"20,000"}}]
[12,{"$f":"+'Regla4%'!D13","v":{"v":24867.486167893047,"d":"24,867"}},{"$f":"+'Guyton-Klinger'!D13","v":{"v":15000,"d":"15,000"}},{"$f":"+Ratchet!D13","v":{"v":20000,"d":"20,000"}}]
[13,{"$f":"+'Regla4%'!D14","v":{"v":25364.835891250907,"d":"25,365"}},{"$f":"+'Guyton-Klinger'!D14","v":{"v":15300,"d":"15,300"}},{"$f":"+Ratchet!D14","v":{"v":20000,"d":"20,000"}}]
[14,{"$f":"+'Regla4%'!D15","v":{"v":25872.132609075925,"d":"25,872"}},{"$f":"+'Guyton-Klinger'!D15","v":{"v":15606,"d":"15,606"}},{"$f":"+Ratchet!D15","v":{"v":20000,"d":"20,000"}}]
[15,{"$f":"+'Regla4%'!D16","v":{"v":26389.575261257443,"d":"26,390"}},{"$f":"+'Guyton-Klinger'!D16","v":{"v":15918.12,"d":"15,918"}},{"$f":"+Ratchet!D16","v":{"v":20000,"d":"20,000"}}]
[16,{"$f":"+'Regla4%'!D17","v":{"v":26917.36676648259,"d":"26,917"}},{"$f":"+'Guyton-Klinger'!D17","v":{"v":16236.4824,"d":"16,236"}},{"$f":"+Ratchet!D17","v":{"v":20000,"d":"20,000"}}]
[17,{"$f":"+'Regla4%'!D18","v":{"v":27455.714101812246,"d":"27,456"}},{"$f":"+'Guyton-Klinger'!D18","v":{"v":17860.130640000003,"d":"17,860"}},{"$f":"+Ratchet!D18","v":{"v":20000,"d":"20,000"}}]
[18,{"$f":"+'Regla4%'!D19","v":{"v":28004.82838384849,"d":"28,005"}},{"$f":"+'Guyton-Klinger'!D19","v":{"v":19646.143704000006,"d":"19,646"}},{"$f":"+Ratchet!D19","v":{"v":20000,"d":"20,000"}}]
[19,{"$f":"+'Regla4%'!D20","v":{"v":28564.92495152546,"d":"28,565"}},{"$f":"+'Guyton-Klinger'!D20","v":{"v":21610.758074400008,"d":"21,611"}},{"$f":"+Ratchet!D20","v":{"v":20400,"d":"20,400"}}]
[20,{"$f":"+'Regla4%'!D21","v":{"v":29136.223450555968,"d":"29,136"}},{"$f":"+'Guyton-Klinger'!D21","v":{"v":23771.83388184001,"d":"23,772"}},{"$f":"+Ratchet!D21","v":{"v":20808,"d":"20,808"}}]
[21,{"$f":"+'Regla4%'!D22","v":{"v":29718.947919567087,"d":"29,719"}},{"$f":"+'Guyton-Klinger'!D22","v":{"v":26149.017270024015,"d":"26,149"}},{"$f":"+Ratchet!D22","v":{"v":21224.16,"d":"21,224"}}]
[22,{"$f":"+'Regla4%'!D23","v":{"v":30313.32687795843,"d":"30,313"}},{"$f":"+'Guyton-Klinger'!D23","v":{"v":28763.91899702642,"d":"28,764"}},{"$f":"+Ratchet!D23","v":{"v":21648.6432,"d":"21,649"}}]
[23,{"$f":"+'Regla4%'!D24","v":{"v":30919.593415517596,"d":"30,920"}},{"$f":"+'Guyton-Klinger'!D24","v":{"v":29339.19737696695,"d":"29,339"}},{"$f":"+Ratchet!D24","v":{"v":21648.6432,"d":"21,649"}}]
[24,{"$f":"+'Regla4%'!D25","v":{"v":31537.985283827948,"d":"31,538"}},{"$f":"+'Guyton-Klinger'!D25","v":{"v":29925.98132450629,"d":"29,926"}},{"$f":"+Ratchet!D25","v":{"v":21648.6432,"d":"21,649"}}]
[25,{"$f":"+'Regla4%'!D26","v":{"v":32168.744989504507,"d":"32,169"}},{"$f":"+'Guyton-Klinger'!D26","v":{"v":30524.50095099642,"d":"30,525"}},{"$f":"+Ratchet!D26","v":{"v":21648.6432,"d":"21,649"}}]
["SUMA",{"$f":"+SUM(B32:B56)","v":{"v":640605.9944647298,"d":"640,606"}},{"$f":"+SUM(C32:C56)","v":{"v":486615.32836976,"d":"486,615"}},{"v":509026.73279999994,"d":"509,027"},"suma retiradas"]