{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cálculador cuota","Factor x millon","Factor x millon ONEST"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":31,"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":"Cálculador cuota","index":0,"n_rows":322,"n_cols":25,"rows_kept":322,"cut":false,"hidden":false,"merged":[[19,5,19,6],[18,5,18,6],[17,5,17,6],[24,5,24,6],[12,14,12,15],[14,10,16,12],[12,5,12,6],[15,5,15,6],[16,5,16,6],[12,9,12,10],[13,5,14,6],[13,8,14,8],[7,5,7,6],[8,5,8,8],[11,5,11,6],[9,5,9,6],[10,5,10,6],[9,16,9,18],[18,10,22,12],[2,8,2,12],[3,8,3,12],[4,9,4,12],[10,9,10,10],[11,9,11,10]]}
[]
[]
[null,null,null,null,null,null,null,null,"SIMULADOR DE CÁLCULO DE CUOTAS LIBRANZA"]
[null,null,null,null,null,null,null,null,"VENTA"]
[]
[]
[]
[null,null,null,null,null,"No. Convenio",null,null,"REAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REAL",30]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(I8,#REF!,2,0),\"FALTA DIGITAR No. DE CONVENIO\")","v":"FALTA DIGITAR No. DE CONVENIO"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRUPO COLPATRIA",30]
[null,null,null,null,null,"Monto Solicitado/Aprobado",null,null,30000000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OFICIAL",60]
[null,null,null,null,null,"% Tasa E.A.",null,null,{"$f":"EFFECT(I12*12,12)","v":0.15800608683458517},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EDUCACIÓN PÚBLICA",90]
[null,null,null,null,null,"% Tasa N.M.V.",null,null,1.23E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUERZAS MILITARES",90]
[null,null,null,null,null,"Plazo",null,null,84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POLICIA",90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENSIONADOS",90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POLICIA",90]
[null,null,null,null,null,"Cuota",-335544.32000000001,null,585907.22712139587]
[null,null,null,null,null,"Cuota + Seguro",null,null,{"$f":"IFERROR(IF(AND(VLOOKUP(Plazo,$B$57:$K$350,10,0)>-1,(VLOOKUP(Plazo,$B$57:$K$350,10,0)<1)),ROUND((I10*0.0016)+I16,0),0),0)","v":633907}]
[null,null,null,null,null,"Total crédito",null,null,{"$f":"IFERROR(I17*Plazo,0)","v":53248188}]
[null,null,null,null,null,"Desplazamiento convenio",null,null,{"$f":"IFERROR(VLOOKUP(I8,$X$8:$Y$15,2,0),0)","v":30},null,{"$f":"UPPER(ALETRAS(I18))","v":"CINCUENTA Y TRES MILLONES DOSCIENTOS CUARENTA Y OCHO MIL CIENTO OCHENTA Y OCHO PESOS"}]
[null,null,null,null,null,"Día específico",null,null,{"$f":"IFERROR(VLOOKUP(I8,#REF!,3,0),\"-\")","v":"-"}]
[null,null,null,null,null,"Fecha de Desembolso",null,null,{"$f":"TODAY()","v":"2019-10-22"}]
[null,null,null,null,"Días",{"$f":"IF(I19=90,122,IF(I19=60,92,IF(I19=30,62)))","v":62}]
[]
[]
[null,null,null,null,null,"VTU  % E.A.",null,null,{"$f":"IFERROR(EFFECT(N54,12),\" \")","v":0.19531879202875091}]
[null,null,null,null,null,"VTU Resultante en pesos",null,null,{"$f":"SUM(M57:M374)","v":52614281}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IRR(M56:M1048576)","v":1.497881813979296E-2},{"$f":"M54*12","v":0.17974581767751552}]
[]
["No. Cuota","No. cuota","F.Inicio","F.Fin","Días","Valor Cuota","Interés x","Capital x","Interés","Capital","Saldo",null,{"$f":"-Monto","v":-30000000}]
[1,1,{"$f":"I21","v":"2019-10-22"},{"$f":"C57+F22","v":"2019-12-23"},{"$f":"IF(B57>Plazo,\"\",_xlfn.DAYS(D57,C57))","v":62},{"$f":"IF(B57>Plazo,\"\",$I$16)","v":585907.22712139587},{"$f":"IF(B57>Plazo,\"\",(I10*$I$12)/30*E57)","v":762600},{"$f":"IF(B57>Plazo,\"\",F57-G57)","v":-176692.77287860413},{"$f":"IF(B57>Plazo,\"\",IF(G57>F57,F57,G57))","v":585907.22712139587},{"$f":"IF(B57>Plazo,\"\",IF(H57<0,0,(F57-G57)))","v":0},{"$f":"IF(B57>Plazo,0,I10-J57)","v":30000000},null,{"$f":"IF(K57>1,CuotaSeg,0)","v":633907}]
[2,2,{"$f":"IF(B58>Plazo,\"\",D57)","v":"2019-12-23"},{"$f":"IF(B58>Plazo,\"\",EDATE(D57,1))","v":"2020-01-23"},31,585907.22712139587,{"$f":"IF(B58>Plazo,\"\",(K57*$I$12)/30*E58)","v":381300},{"$f":"IF(B58>Plazo,\"\",F58-I58)","v":27914.454242791748},{"$f":"IF(B58>Plazo,\"\",IF(H57<0,G58-H57,G58))","v":557992.77287860413},{"$f":"IF(B58>Plazo,\"\",IF(H58<0,0,(F58-I58)))","v":27914.454242791748},{"$f":"IF(B58>Plazo,-1,K57-J58)","v":29972085.545757208},null,633907]
[3,3,"2020-01-23","2020-02-23",31,585907.22712139587,380945.20728657412,204962.01983482175,380945.20728657412,204962.01983482175,29767123.525922388,null,633907]
[4,4,"2020-02-23","2020-03-23",29,585907.22712139587,353931.0987232172,231976.12839817867,353931.0987232172,231976.12839817867,29535147.397524208,null,633907]
[5,5,"2020-03-23","2020-04-23",31,585907.22712139587,375391.72342253267,210515.50369886321,375391.72342253267,210515.50369886321,29324631.893825345,null,633907]
[6,6,"2020-04-23","2020-05-23",30,585907.22712139587,360692.97229405172,225214.25482734415,360692.97229405172,225214.25482734415,29099417.638998002,null,633907]
[7,7,"2020-05-23","2020-06-23",31,585907.22712139587,369853.59819166461,216053.62892973126,369853.59819166461,216053.62892973126,28883364.010068271,null,633907]
[8,8,"2020-06-23","2020-07-23",30,585907.22712139587,355265.37732383976,230641.84979755612,355265.37732383976,230641.84979755612,28652722.160270717,null,633907]
[9,9,"2020-07-23","2020-08-23",31,585907.22712139587,364176.0986570408,221731.12846435508,364176.0986570408,221731.12846435508,28430991.031806361,null,633907]
[10,10,"2020-08-23","2020-09-23",31,585907.22712139587,361357.89601425891,224549.33110713697,361357.89601425891,224549.33110713697,28206441.700699225,null,633907]
[11,11,"2020-09-23","2020-10-23",30,585907.22712139587,346939.23291860049,238967.99420279538,346939.23291860049,238967.99420279538,27967473.706496429,null,633907]
[12,12,"2020-10-23","2020-11-23",31,585907.22712139587,355466.59080956964,230440.63631182624,355466.59080956964,230440.63631182624,27737033.070184603,null,633907]
[13,13,"2020-11-23","2020-12-23",30,585907.22712139587,341165.50676327065,244741.72035812523,341165.50676327065,244741.72035812523,27492291.349826477,null,633907]
[14,14,"2020-12-23","2021-01-23",31,585907.22712139587,349427.02305629454,236480.20406510134,349427.02305629454,236480.20406510134,27255811.145761374,null,633907]
[15,15,"2021-01-23","2021-02-23",31,585907.22712139587,346421.35966262704,239485.86745876883,346421.35966262704,239485.86745876883,27016325.278302606,null,633907]
[16,16,"2021-02-23","2021-03-23",28,585907.22712139587,310147.41419491393,275759.81292648194,310147.41419491393,275759.81292648194,26740565.465376124,null,633907]
[17,17,"2021-03-23","2021-04-23",31,585907.22712139587,339872.58706493059,246034.64005646529,339872.58706493059,246034.64005646529,26494530.825319659,null,633907]
[18,18,"2021-04-23","2021-05-23",30,585907.22712139587,325882.72915143182,260024.49796996405,325882.72915143182,260024.49796996405,26234506.327349696,null,633907]
[19,19,"2021-05-23","2021-06-23",31,585907.22712139587,333440.57542061462,252466.65170078125,333440.57542061462,252466.65170078125,25982039.675648917,null,633907]
[20,20,"2021-06-23","2021-07-23",30,585907.22712139587,319579.08801048168,266328.1391109142,319579.08801048168,266328.1391109142,25715711.536538001,null,633907]
[21,21,"2021-07-23","2021-08-23",31,585907.22712139587,326846.69362939801,259060.53349199786,326846.69362939801,259060.53349199786,25456651.003046002,null,633907]
[22,22,"2021-08-23","2021-09-23",31,585907.22712139587,323554.03424871468,262353.19287268119,323554.03424871468,262353.19287268119,25194297.810173322,null,633907]
[23,23,"2021-09-23","2021-10-23",30,585907.22712139587,309889.86306513188,276017.36405626399,309889.86306513188,276017.36405626399,24918280.446117058,null,633907]
[24,24,"2021-10-23","2021-11-23",31,585907.22712139587,316711.3444701478,269195.88265124807,316711.3444701478,269195.88265124807,24649084.563465811,null,633907]
[25,25,"2021-11-23","2021-12-23",30,585907.22712139587,303183.74013062951,282723.48699076637,303183.74013062951,282723.48699076637,24366361.076475047,null,633907]
[26,26,"2021-12-23","2022-01-23",31,585907.22712139587,309696.44928199786,276210.77783939801,309696.44928199786,276210.77783939801,24090150.298635647,null,633907]
[27,27,"2022-01-23","2022-02-23",31,585907.22712139587,306185.81029565906,279721.41682573681,306185.81029565906,279721.41682573681,23810428.881809909,null,633907]
[28,28,"2022-02-23","2022-03-23",28,585907.22712139587,273343.72356317774,312563.50355821813,273343.72356317774,312563.50355821813,23497865.37825169,null,633907]
[29,29,"2022-03-23","2022-04-23",31,585907.22712139587,298657.86895757902,287249.35816381685,298657.86895757902,287249.35816381685,23210616.020087875,null,633907]
[30,30,"2022-04-23","2022-05-23",30,585907.22712139587,285490.57704708085,300416.65007431502,285490.57704708085,300416.65007431502,22910199.370013561,null,633907]
[31,31,"2022-05-23","2022-06-23",31,585907.22712139587,291188.63399287238,294718.5931285235,291188.63399287238,294718.5931285235,22615480.776885036,null,633907]
[32,32,"2022-06-23","2022-07-23",30,585907.22712139587,278170.41355568595,307736.81356570992,278170.41355568595,307736.81356570992,22307743.963319328,null,633907]
[33,33,"2022-07-23","2022-08-23",{"$f":"IF(B89>Plazo,\"\",_xlfn.DAYS(D89,C89))","v":31},{"$f":"IF(B89>Plazo,\"\",$I$16)","v":585907.22712139587},283531.42577378865,302375.80134760722,283531.42577378865,302375.80134760722,22005368.161971722,null,633907]
[34,34,{"$f":"IF(B90>Plazo,\"\",D89)","v":"2022-08-23"},{"$f":"IF(B90>Plazo,\"\",EDATE(D89,1))","v":"2022-09-23"},31,585907.22712139587,{"$f":"IF(B90>Plazo,\"\",(K89*$I$12)/30*E90)","v":279688.2293386606},{"$f":"IF(B90>Plazo,\"\",F90-I90)","v":306218.99778273527},{"$f":"IF(B90>Plazo,\"\",IF(H89<0,G90-H89,G90))","v":279688.2293386606},{"$f":"IF(B90>Plazo,\"\",IF(H90<0,0,(F90-I90)))","v":306218.99778273527},{"$f":"IF(B90>Plazo,-1,K89-J90)","v":21699149.164188985},null,633907]
[35,35,"2022-09-23","2022-10-23",30,585907.22712139587,266899.5347195245,319007.69240187138,266899.5347195245,319007.69240187138,21380141.471787114,null,633907]
[36,36,"2022-10-23","2022-11-23",31,585907.22712139587,271741.5981064142,314165.62901498168,271741.5981064142,314165.62901498168,21065975.842772134,null,633907]
[37,37,"2022-11-23","2022-12-23",30,585907.22712139587,259111.50286609726,326795.72425529861,259111.50286609726,326795.72425529861,20739180.118516836,null,633907]
[38,38,"2022-12-23","2023-01-23",31,585907.22712139587,263594.97930634901,322312.24781504687,263594.97930634901,322312.24781504687,20416867.87070179,null,633907]
[39,39,"2023-01-23","2023-02-23",31,585907.22712139587,259498.39063661973,326408.83648477611,259498.39063661973,326408.83648477611,20090459.034217015,null,633907]
[40,40,"2023-02-23","2023-03-23",28,585907.22712139587,230638.46971281135,355268.75740858453,230638.46971281135,355268.75740858453,19735190.27680843,null,633907]
[41,41,"2023-03-23","2023-04-23",31,585907.22712139587,250834.26841823515,335072.95870316075,250834.26841823515,335072.95870316075,19400117.318105269,null,633907]
[42,42,"2023-04-23","2023-05-23",30,585907.22712139587,238621.44301269483,347285.78410870105,238621.44301269483,347285.78410870105,19052831.533996567,null,633907]
[43,43,"2023-05-23","2023-06-23",31,585907.22712139587,242161.48879709636,343745.73832429951,242161.48879709636,343745.73832429951,18709085.795672268,null,633907]
[44,44,"2023-06-23","2023-07-23",30,585907.22712139587,230121.75528676889,355785.47183462698,230121.75528676889,355785.47183462698,18353300.323837642,null,633907]
[45,45,"2023-07-23","2023-08-23",31,585907.22712139587,233270.44711597645,352636.78000541939,233270.44711597645,352636.78000541939,18000663.543832224,null,633907]
[46,46,"2023-08-23","2023-09-23",31,585907.22712139587,228788.43364210756,357118.79347928835,228788.43364210756,357118.79347928835,17643544.750352934,null,633907]
[47,47,"2023-09-23","2023-10-23",30,585907.22712139587,217015.60042934108,368891.62669205479,217015.60042934108,368891.62669205479,17274653.123660877,null,633907]
[48,48,"2023-10-23","2023-11-23",31,585907.22712139587,219560.84120172975,366346.38591966615,219560.84120172975,366346.38591966615,16908306.73774121,null,633907]
[49,49,"2023-11-23","2023-12-23",30,585907.22712139587,207972.17287421689,377935.05424717895,207972.17287421689,377935.05424717895,16530371.683494031,null,633907]
[50,50,"2023-12-23","2024-01-23",31,585907.22712139587,210101.02409720916,375806.20302418672,210101.02409720916,375806.20302418672,16154565.480469845,null,633907]
[51,51,"2024-01-23","2024-02-23",31,585907.22712139587,205324.52725677175,380582.69986462413,205324.52725677175,380582.69986462413,15773982.780605221,null,633907]
[52,52,"2024-02-23","2024-03-23",29,585907.22712139587,187552.65526139608,398354.57185999979,187552.65526139608,398354.57185999979,15375628.208745221,null,633907]
[53,53,"2024-03-23","2024-04-23",31,585907.22712139587,195424.23453315176,390482.99258824415,195424.23453315176,390482.99258824415,14985145.216156976,null,633907]
[54,54,"2024-04-23","2024-05-23",30,585907.22712139587,184317.2861587308,401589.94096266507,184317.2861587308,401589.94096266507,14583555.275194312,null,633907]
[55,55,"2024-05-23","2024-06-23",31,585907.22712139587,185356.98754771968,400550.2395736762,185356.98754771968,400550.2395736762,14183005.035620635,null,633907]
[56,56,"2024-06-23","2024-07-23",30,585907.22712139587,174450.96193813381,411456.26518326206,174450.96193813381,411456.26518326206,13771548.770437373,null,633907]
[57,57,"2024-07-23","2024-08-23",31,585907.22712139587,175036.38487225902,410870.84224913688,175036.38487225902,410870.84224913688,13360677.928188236,null,633907]
[58,58,"2024-08-23","2024-09-23",31,585907.22712139587,169814.21646727246,416093.01065412338,169814.21646727246,416093.01065412338,12944584.917534113,null,633907]
[59,59,"2024-09-23","2024-10-23",30,585907.22712139587,159218.39448566959,426688.83263572631,159218.39448566959,426688.83263572631,12517896.084898386,null,633907]
[60,60,"2024-10-23","2024-11-23",31,585907.22712139587,159102.45923905849,426804.76788233739,159102.45923905849,426804.76788233739,12091091.317016048,null,633907]
[61,61,"2024-11-23","2024-12-23",30,585907.22712139587,148720.42319929739,437186.80392209848,148720.42319929739,437186.80392209848,11653904.51309395,null,633907]
[62,62,"2024-12-23","2025-01-23",31,585907.22712139587,148121.1263614241,437786.10075997177,148121.1263614241,437786.10075997177,11216118.412333978,null,633907]
[63,63,"2025-01-23","2025-02-23",31,585907.22712139587,142556.86502076485,443350.362100631,142556.86502076485,443350.362100631,10772768.050233347,null,633907]
[64,64,"2025-02-23","2025-03-23",28,585907.22712139587,123671.37721667883,462235.84990471706,123671.37721667883,462235.84990471706,10310532.200328629,null,633907]
[65,65,"2025-03-23","2025-04-23",{"$f":"IF(B121>Plazo,\"\",_xlfn.DAYS(D121,C121))","v":31},{"$f":"IF(B121>Plazo,\"\",$I$16)","v":585907.22712139587},131046.86426617687,454860.36285521899,131046.86426617687,454860.36285521899,9855671.8374734111,null,{"$f":"IF(K121>1,CuotaSeg,0)","v":633907}]
[66,66,{"$f":"IF(B122>Plazo,\"\",D121)","v":"2025-04-23"},{"$f":"IF(B122>Plazo,\"\",EDATE(D121,1))","v":"2025-05-23"},30,585907.22712139587,{"$f":"IF(B122>Plazo,\"\",(K121*$I$12)/30*E122)","v":121224.76360092296},{"$f":"IF(B122>Plazo,\"\",F122-I122)","v":464682.46352047293},{"$f":"IF(B122>Plazo,\"\",IF(H121<0,G122-H121,G122))","v":121224.76360092296},{"$f":"IF(B122>Plazo,\"\",IF(H122<0,0,(F122-I122)))","v":464682.46352047293},{"$f":"IF(B122>Plazo,-1,K121-J122)","v":9390989.3739529382},null,633907]
[67,67,"2025-05-23","2025-06-23",31,585907.22712139587,119359.47494294183,466547.75217845407,119359.47494294183,466547.75217845407,8924441.6217744835,null,633907]
[68,68,"2025-06-23","2025-07-23",30,585907.22712139587,109770.63194782614,476136.59517356975,109770.63194782614,476136.59517356975,8448305.0266009141,null,633907]
[69,69,"2025-07-23","2025-08-23",31,585907.22712139587,107377.95688809761,478529.27023329824,107377.95688809761,478529.27023329824,7969775.7563676154,null,633907]
[70,70,"2025-08-23","2025-09-23",31,585907.22712139587,101295.84986343239,484611.37725796347,101295.84986343239,484611.37725796347,7485164.3791096518,null,633907]
[71,71,"2025-09-23","2025-10-23",30,585907.22712139587,92067.521863048722,493839.70525834715,92067.521863048722,493839.70525834715,6991324.6738513047,null,633907]
[72,72,"2025-10-23","2025-11-23",31,585907.22712139587,88859.736604650097,497047.49051674578,88859.736604650097,497047.49051674578,6494277.1833345592,null,633907]
[73,73,"2025-11-23","2025-12-23",30,585907.22712139587,79879.609355015084,506027.61776638078,79879.609355015084,506027.61776638078,5988249.5655681789,null,633907]
[74,74,"2025-12-23","2026-01-23",31,585907.22712139587,76110.651978371548,509796.57514302433,76110.651978371548,509796.57514302433,5478452.9904251546,null,633907]
[75,75,"2026-01-23","2026-02-23",31,585907.22712139587,69631.137508303727,516276.08961309213,69631.137508303727,516276.08961309213,4962176.9008120624,null,633907]
[76,76,"2026-02-23","2026-03-23",28,585907.22712139587,56965.79082132248,528941.4363000734,56965.79082132248,528941.4363000734,4433235.4645119887,null,633907]
[77,77,"2026-03-23","2026-04-23",31,585907.22712139587,56346.422753947372,529560.80436744855,56346.422753947372,529560.80436744855,3903674.66014454,null,633907]
[78,78,"2026-04-23","2026-05-23",30,585907.22712139587,48015.198319777846,537892.02880161803,48015.198319777846,537892.02880161803,3365782.6313429219,null,633907]
[79,79,"2026-05-23","2026-06-23",31,585907.22712139587,42779.097244368546,543128.12987702736,42779.097244368546,543128.12987702736,2822654.5014658943,null,633907]
[80,80,"2026-06-23","2026-07-23",30,585907.22712139587,34718.650368030503,551188.57675336534,34718.650368030503,551188.57675336534,2271465.9247125289,null,633907]
[81,81,"2026-07-23","2026-08-23",31,585907.22712139587,28870.331903096245,557036.89521829959,28870.331903096245,557036.89521829959,1714429.0294942292,null,633907]
[82,82,"2026-08-23","2026-09-23",31,585907.22712139587,21790.392964871655,564116.83415652427,21790.392964871655,564116.83415652427,1150312.1953377048,null,633907]
[83,83,"2026-09-23","2026-10-23",30,585907.22712139587,14148.840002653769,571758.3871187421,14148.840002653769,571758.3871187421,578553.80821896275,null,633907]
[84,84,"2026-10-23","2026-11-23",31,585907.22712139587,7353.4189024630159,578553.80821893283,7353.4189024630159,578553.80821893283,2.9918737709522247E-8,null,0]
[85,85,"","","","","","","","",-1,null,0]
[86,86,"","","","","","","","",-1,null,0]
[87,87,"","","","","","","","",-1,null,0]
[88,88,"","","","","","","","",-1,null,0]
[89,89,"","","","","","","","",-1,null,0]
[90,90,"","","","","","","","",-1,null,0]
[91,91,"","","","","","","","",-1,null,0]
[92,92,"","","","","","","","",-1,null,0]
[93,93,"","","","","","","","",-1,null,0]
[94,94,"","","","","","","","",-1,null,0]
[95,95,"","","","","","","","",-1,null,0]
[96,96,"","","","","","","","",-1,null,0]
[97,97,"","",{"$f":"IF(B153>Plazo,\"\",_xlfn.DAYS(D153,C153))","v":""},{"$f":"IF(B153>Plazo,\"\",$I$16)","v":""},"","","","",-1,null,0]
[98,98,{"$f":"IF(B154>Plazo,\"\",D153)","v":""},{"$f":"IF(B154>Plazo,\"\",EDATE(D153,1))","v":""},"","",{"$f":"IF(B154>Plazo,\"\",(K153*$I$12)/30*E154)","v":""},{"$f":"IF(B154>Plazo,\"\",F154-I154)","v":""},{"$f":"IF(B154>Plazo,\"\",IF(H153<0,G154-H153,G154))","v":""},{"$f":"IF(B154>Plazo,\"\",IF(H154<0,0,(F154-I154)))","v":""},{"$f":"IF(B154>Plazo,-1,K153-J154)","v":-1},null,0]
[99,99,"","","","","","","","",-1,null,0]
[100,100,"","","","","","","","",-1,null,0]
[101,101,"","","","","","","","",-1,null,0]
[102,102,"","","","","","","","",-1,null,0]
[103,103,"","","","","","","","",-1,null,0]
[104,104,"","","","","","","","",-1,null,0]
[105,105,"","","","","","","","",-1,null,0]
[106,106,"","","","","","","","",-1,null,0]
[107,107,"","","","","","","","",-1,null,0]
[108,108,"","","","","","","","",-1,null,0]
[109,109,"","","","","","","","",-1,null,0]
[110,110,"","","","","","","","",-1,null,0]
[111,111,"","","","","","","","",-1,null,0]
[112,112,"","","","","","","","",-1,null,0]
[113,113,"","","","","","","","",-1,null,0]
[114,114,"","","","","","","","",-1,null,0]
[115,115,"","","","","","","","",-1,null,0]
[116,116,"","","","","","","","",-1,null,0]
[117,117,"","","","","","","","",-1,null,0]
[118,118,"","","","","","","","",-1,null,0]
[119,119,"","","","","","","","",-1,null,0]
[120,120,"","","","","","","","",-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,{"$f":"IF(K185>1,CuotaSeg,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B186>Plazo,-1,K185-J186)","v":-1},null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B218>Plazo,-1,K217-J218)","v":-1},null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,-1,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K249>1,CuotaSeg,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K313>1,CuotaSeg,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Factor x millon","index":1,"n_rows":84,"n_cols":12,"rows_kept":84,"cut":false,"hidden":true,"merged":[[32,1,32,2],[32,3,32,11],[58,1,58,2],[58,3,58,11],[60,1,60,2],[60,3,60,11],[3,1,3,2],[3,3,3,11],[5,1,5,2],[5,3,5,11],[30,1,30,2],[30,3,30,11]]}
[]
[]
[]
[null,"Desplazamiento",null,"30 Días      (30 Días hasta 59 Diás)"]
[]
[null,"Tasa (%)",null,"Plazo (Meses)"]
[null,"Tasa (NMV)","Tasa E.A.",12,24,36,48,60,72,84,96,108]
[null,0.01,0.12682503013196977,90899,48724,34732,27786,23657,20937,19021,17608,16529]
[null,1.0500000000000001E-2,0.1335372965869035,91225,49030,35038,28097,23975,21263,19355,17950,16880]
[null,1.0999999999999999E-2,0.14028619649985408,91552,49337,35346,28410,24296,21592,19693,18296,17235]
[null,1.15E-2,0.14707191153891563,91879,49645,35655,28725,24619,21924,20034,18647,17594]
[null,1.2E-2,0.15389462418258582,92207,49955,35966,29043,24945,22259,20378,19000,17957]
[null,1.2500000000000001E-2,0.16075451772299854,92535,50265,36279,29363,25274,22597,20726,19358,18324]
[null,1.2999999999999999E-2,0.16765177626913008,92865,50577,36594,29685,25605,22938,21077,19719,18696]
[null,1.35E-2,0.1745865847500423,93195,50890,36910,30009,25938,23282,21432,20084,19071]
[null,1.4E-2,0.18155912891812287,93526,51205,37228,30335,26275,23629,21790,20453,19450]
[null,1.4500000000000001E-2,0.18856959535234452,93857,51520,37547,30664,26613,23979,22151,20825,19833]
[null,1.4999999999999999E-2,0.19561817146153326,94190,51837,37869,30995,26955,24332,22515,21201,20220]
[null,1.55E-2,0.20270504548765578,94523,52155,38192,31327,27299,24687,22883,21580,20610]
[null,1.6E-2,0.20983040650908191,94856,52475,38517,31662,27645,25046,23253,21963,21004]
[null,1.6500000000000001E-2,0.21699444444392446,95191,52795,38843,31999,27994,25408,23628,22349,21402]
[null,1.6899999999999998E-2,0.22275365033253247,95459,53053,39106,32270,28275,25699,23929,22660,21722]
[null,1.7000000000000001E-2,0.22419735005332386,95526,53117,39172,32338,28346,25772,24005,22738,21803]
[null,1.7500000000000002E-2,0.23143931494479242,95862,53440,39501,32679,28700,26139,24385,23131,22207]
[null,1.7999999999999999E-2,0.23872053157552808,96198,53764,39833,33022,29057,26509,24768,23527,22615]
[null,1.8499999999999999E-2,0.24604119325578755,96536,54090,40166,33367,29416,26882,25154,23926,23026]
[null,1.9E-2,0.25340149415222601,96874,54416,40501,33715,29777,27257,25544,24328,23441]
[null,1.95E-2,0.26080162929128292,97212,54744,40838,34064,30141,27636,25936,24734,23858]
[null,0.02,0.26824179456254527,97552,55073,41176,34416,30507,28017,26331,25142,24279]
[]
[null,"Desplazamiento",null,"60 Días      (60 Días hasta 89 Diás)"]
[]
[null,"Tasa (%)",null,"Plazo (Meses)"]
[null,"Tasa (NMV)","Tasa E.A.",12,24,36,48,60,72,84,96,108]
[null,0.01,0.12682503013196977,91779,49190,35061,28046,23876,21129,19194,17766,16676]
[null,1.0500000000000001E-2,0.1335372965869035,92151,49522,35386,28372,24208,21467,19539,18119,17037]
[null,1.0999999999999999E-2,0.14028619649985408,92524,49855,35713,28702,24542,21808,19889,18476,17402]
[null,1.15E-2,0.14707191153891563,92899,50190,36043,29033,24880,22153,20242,18838,17772]
[null,1.2E-2,0.15389462418258582,93274,50526,36374,29367,25220,22501,20598,19203,18146]
[null,1.2500000000000001E-2,0.16075451772299854,93650,50864,36706,29704,25564,22853,20958,19573,18525]
[null,1.2999999999999999E-2,0.16765177626913008,94027,51203,37041,30042,25910,23208,21322,19946,18908]
[null,1.35E-2,0.1745865847500423,94405,51544,37378,30384,26258,23566,21690,20323,19294]
[null,1.4E-2,0.18155912891812287,94784,51886,37716,30728,26610,23927,22061,20704,19685]
[null,1.4500000000000001E-2,0.18856959535234452,95164,52230,38057,31074,26965,24291,22435,21089,20080]
[null,1.4999999999999999E-2,0.19561817146153326,95545,52575,38399,31423,27322,24658,22813,21477,20479]
[null,1.55E-2,0.20270504548765578,95926,52922,38744,31774,27682,25029,23194,21869,20881]
[null,1.6E-2,0.20983040650908191,96309,53270,39090,32127,28045,25403,23579,22265,21288]
[null,1.6500000000000001E-2,0.21699444444392446,96693,53620,39439,32482,28411,25780,23967,22664,21698]
[null,1.6899999999999998E-2,0.22275365033253247,97001,53901,39719,32768,28705,26083,24280,22986,22028]
[null,1.7000000000000001E-2,0.22419735005332386,97078,53971,39789,32840,28779,26159,24359,23067,22111]
[null,1.7500000000000002E-2,0.23143931494479242,97463,54324,40141,33200,29150,26542,24753,23473,22528]
[null,1.7999999999999999E-2,0.23872053157552808,97850,54678,40495,33562,29524,26927,25151,23882,22948]
[null,1.8499999999999999E-2,0.24604119325578755,98238,55033,40852,33927,29900,27316,25552,24295,23372]
[null,1.9E-2,0.25340149415222601,98626,55389,41210,34294,30279,27708,25956,24711,23799]
[null,1.95E-2,0.26080162929128292,99016,55746,41570,34664,30661,28102,26363,25130,24229]
[null,0.02,0.26824179456254527,99406,56105,41932,35036,31045,28499,26773,25552,24661]
[]
[]
[null,"Desplazamiento",null,"90 Días      (90 Días hasta 119 Diás)"]
[]
[null,"Tasa (%)",null,"Plazo (Meses)"]
[null,"Tasa (NMV)","Tasa E.A.",12,24,36,48,60,72,84,96,108]
[null,0.01,0.12682503013196977,92659,49656,35388,28304,24093,21319,19364,17922,16821]
[null,1.0500000000000001E-2,0.1335372965869035,93077,50014,35732,28646,24438,21669,19721,18286,17192]
[null,1.0999999999999999E-2,0.14028619649985408,93497,50373,36078,28991,24787,22023,20081,18654,17567]
[null,1.15E-2,0.14707191153891563,93918,50735,36426,29339,25138,22380,20446,19025,17947]
[null,1.2E-2,0.15389462418258582,94341,51098,36777,29689,25493,22741,20814,19402,18331]
[null,1.2500000000000001E-2,0.16075451772299854,94764,51462,37129,30042,25850,23105,21186,19782,18720]
[null,1.2999999999999999E-2,0.16765177626913008,95189,51828,37484,30397,26211,23473,21562,20167,19113]
[null,1.35E-2,0.1745865847500423,95615,52196,37841,30755,26574,23844,21942,20555,19511]
[null,1.4E-2,0.18155912891812287,96042,52565,38201,31116,26941,24219,22325,20948,19912]
[null,1.4500000000000001E-2,0.18856959535234452,96470,52935,38562,31479,27310,24597,22712,21344,20318]
[null,1.4999999999999999E-2,0.19561817146153326,96899,53308,38926,31845,27683,24978,23103,21744,20728]
[null,1.55E-2,0.20270504548765578,97330,53681,39292,32214,28059,25362,23497,22148,21141]
[null,1.6E-2,0.20983040650908191,97762,54057,39659,32584,28437,25750,23895,22556,21558]
[null,1.6500000000000001E-2,0.21699444444392446,98195,54434,40028,32958,28818,26141,24295,22967,21979]
[null,1.6899999999999998E-2,0.22275365033253247,98542,54738,40325,33258,29125,26456,24619,23298,22318]
[null,1.7000000000000001E-2,0.22419735005332386,98629,54813,40400,33333,29202,26535,24700,23381,22403]
[null,1.7500000000000002E-2,0.23143931494479242,99065,55194,40774,33712,29589,26932,25107,23799,22831]
[null,1.7999999999999999E-2,0.23872053157552808,99501,55577,41149,34093,29979,27332,25518,24220,23262]
[null,1.8499999999999999E-2,0.24604119325578755,99939,55961,41527,34476,30372,27735,25932,24645,23696]
[null,1.9E-2,0.25340149415222601,100378,56346,41908,34862,30767,28141,26349,25072,24133]
[null,1.95E-2,0.26080162929128292,100819,56734,42290,35251,31165,28550,26769,25503,24574]
[null,0.02,0.26824179456254527,101260,57123,42674,35641,31565,28962,27192,25936,25017]

{"sheet":"Factor x millon ONEST","index":2,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":true,"merged":[[3,1,3,2],[3,3,3,11],[5,1,5,2],[5,3,5,11],[11,1,11,2],[11,3,11,11],[13,1,13,2],[13,3,13,11],[20,1,20,2],[20,3,20,11],[22,1,22,2],[22,3,22,11]]}
[]
[]
[]
[null,"Desplazamiento",null,"30 Días      (30 Días hasta 59 Diás)"]
[]
[null,"Tasa (%)",null,"Plazo (Meses)"]
[null,"Tasa (NMV)","Tasa E.A.",12,24,36,48,60,72,84,96,108]
[null,1.29E-2,0.16626932649468618,92799,50515,36531,29620,25538,22869,21007,19647,18621]
[null,1.5900000000000001E-2,0.20840224624122183,94790,52411,38452,31595,27576,24974,23179,21886,20925]
[null,1.6899999999999998E-2,0.22275365033253247,95459,53053,39106,32270,28275,25699,23929,22660,21722]
[]
[null,"Desplazamiento",null,"60 Días      (60 Días hasta 89 Diás)"]
[]
[null,"Tasa (%)",null,"Plazo (Meses)"]
[null,"Tasa (NMV)","Tasa E.A.",12,24,36,48,60,72,84,96,108]
[null,1.29E-2,0.16626932649468618,93951,51135,36974,29975,25840,23136,21249,19871,18831]
[null,1.5900000000000001E-2,0.20840224624122183,96233,53200,39021,32056,27972,25328,23502,22186,21206]
[null,1.6899999999999998E-2,0.22275365033253247,97001,53901,39719,32768,28705,26083,24280,22986,22028]
[]
[]
[null,"Desplazamiento",null,"90 Días      (90 Días hasta 119 Diás)"]
[]
[null,"Tasa (%)",null,"Plazo (Meses)"]
[null,"Tasa (NMV)","Tasa E.A.",12,24,36,48,60,72,84,96,108]
[null,1.29E-2,0.16626932649468618,95104,51755,37413,30326,26138,23399,21487,20089,19034]
[null,1.5900000000000001E-2,0.20840224624122183,97676,53982,39585,32510,28361,25672,23815,22474,21474]
[null,1.6899999999999998E-2,0.22275365033253247,98542,54738,40325,33258,29125,26456,24619,23298,22318]