{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Program. amortización préstamo","Hoja1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"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":"Program. amortización préstamo","index":0,"n_rows":499,"n_cols":10,"rows_kept":499,"cut":false,"hidden":false,"merged":[[6,1,6,3],[5,7,5,9],[0,6,0,9],[3,7,3,9]]}
[null,null,"PLAN DE PAGOS",null,null,null,"COOPERATIVA TAULABE LIMITADA"]
[]
[]
[null,null,"Código de afiliado:",null,null,null,"Nombre:"]
[]
[null,null,null,null,null,null,null,"Resumen del préstamo"]
[null,"Especificar valores",null,null,null,false,null,null,"Pago programado",{"$f":"IF(Valores_especificados,-PMT(Tasa_de_interés/Núm_pagos_al_año,Años_préstamo*Núm_pagos_al_año,Importe_del_préstamo),\"\")","v":4151.6710452708021}]
[null,null,"Importe del préstamo",200000,null,null,null,null,"Capital efectivo",{"$f":"Importe_del_préstamo-J10-J11","v":198000}]
[null,null,"Tasa de interés anual",0.09,null,null,null,null,"Número de pagos programado",{"$f":"IF(Valores_especificados,Años_préstamo*Núm_pagos_al_año,\"\")","v":60}]
[null,null,"Plazo del préstamo en años",5,null,null,null,null,"Comisión de desembolso (CD)",{"$f":"+Importe_del_préstamo*D12","v":2000}]
[null,null,"Número de pagos al año",12,null,null,null,null,"Comisión de gestión (CG)",{"$f":"+D13","v":0}]
[null,null,"Comisión de desembolso (CD)",0.01,null,null,null,null,"Interés total",{"$f":"IF(Valores_especificados,SUMIF(Saldo_inicial,\">0\",Int),\"\")","v":49100.262716248144}]
[null,null,"Comisión de gestión (CG)",{"$f":"+Hoja1!C10","v":0},null,null,null,null,"Costo total mensual del crédito",{"$f":"IRR((OFFSET(C19,,1,(1+J9))),Tasa_de_interés)","v":7.8589584085544395E-3}]
[null,null,"Fecha inicial del préstamo","2024-01-31",null,null,null,null,"T.A.E. (CAT) real",{"$f":"+((1+(J13))^D11)-1","v":9.8492572959451685E-2}]
[null,null,"Pagos adicionales opcionales"]
[]
[]
["Nº Pago","Fecha de pago","Saldo inicial","Pago programado","Pago adicional","Pago total","Capital","Interés","Saldo final","Interés acumulativo"]
[null,null,null,{"$f":"-J8","v":-198000}]
[{"$f":"IF(Valores_especificados,1,\"\")","v":1},{"$f":"IF(Núm_de_pago<>\"\",DATE(YEAR(Inicio_prestamo),MONTH(Inicio_prestamo)+(Núm_de_pago)*12/Núm_pagos_al_año,DAY(Inicio_prestamo)),\"\")","v":"2024-03-02"},{"$f":"IF(Valores_especificados,Importe_del_préstamo,\"\")","v":200000},{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pagos_adicionales_programados<Saldo_inicial),Pagos_adicionales_programados,IF(AND(Núm_de_pago<>\"\",Saldo_inicial-Pago_progr>0),Saldo_inicial-Pago_progr,IF(Núm_de_pago<>\"\",0,\"\")))","v":0},{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Pago_progr+Pago_adicional,IF(Núm_de_pago<>\"\",Saldo_inicial,\"\"))","v":4151.6710452708021},{"$f":"IF(Núm_de_pago<>\"\",Pago_total-Int,\"\")","v":2651.6710452708021},{"$f":"IF(Núm_de_pago<>\"\",Saldo_inicial*(Tasa_de_interés/Núm_pagos_al_año),\"\")","v":1500},{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Saldo_inicial-Capital,IF(Núm_de_pago<>\"\",0,\"\"))","v":197348.32895472919},{"$f":"SUM($H$20:$H20)","v":1500}]
[{"$f":"IF(Valores_especificados,A20+1,\"\")","v":2},"2024-03-31",{"$f":"IF(Núm_de_pago<>\"\",I20,\"\")","v":197348.32895472919},{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},0,4151.6710452708021,{"$f":"IF(Núm_de_pago<>\"\",Pago_total-Int,\"\")","v":2671.5585781103337},{"$f":"IF(Núm_de_pago<>\"\",Saldo_inicial*Tasa_de_interés/Núm_pagos_al_año,\"\")","v":1480.1124671604687},194676.77037661886,{"$f":"SUM($H$20:$H21)","v":2980.1124671604684}]
[3,"2024-05-01",194676.77037661886,{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},0,4151.6710452708021,2691.5952674461605,1460.0757778246414,191985.17510917271,{"$f":"SUM($H$20:$H22)","v":4440.18824498511}]
[4,"2024-05-31",191985.17510917271,{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},0,4151.6710452708021,2711.7822319520064,1439.8888133187954,189273.3928772207,{"$f":"SUM($H$20:$H23)","v":5880.0770583039057}]
[5,"2024-07-01",189273.3928772207,4151.6710452708021,0,4151.6710452708021,2732.1205986916466,1419.5504465791553,186541.27227852907,{"$f":"SUM($H$20:$H24)","v":7299.6275048830612}]
[6,"2024-07-31",186541.27227852907,4151.6710452708021,0,4151.6710452708021,2752.6115031818345,1399.0595420889679,183788.66077534723,{"$f":"SUM($H$20:$H25)","v":8698.6870469720288}]
[7,"2024-08-31",183788.66077534723,4151.6710452708021,0,4151.6710452708021,2773.2560894556982,1378.4149558151041,181015.40468589152,{"$f":"SUM($H$20:$H26)","v":10077.102002787133}]
[8,"2024-10-01",181015.40468589152,4151.6710452708021,0,4151.6710452708021,2794.0555101266154,1357.6155351441864,178221.34917576492,{"$f":"SUM($H$20:$H27)","v":11434.717537931319}]
[9,"2024-10-31",178221.34917576492,4151.6710452708021,0,4151.6710452708021,2815.0109264525654,1336.6601188182369,175406.33824931236,{"$f":"SUM($H$20:$H28)","v":12771.377656749557}]
[10,"2024-12-01",175406.33824931236,4151.6710452708021,0,4151.6710452708021,2836.1235084009595,1315.5475368698428,172570.21474091141,{"$f":"SUM($H$20:$H29)","v":14086.9251936194}]
[11,"2024-12-31",172570.21474091141,4151.6710452708021,0,4151.6710452708021,2857.3944347139668,1294.2766105568355,169712.82030619745,{"$f":"SUM($H$20:$H30)","v":15381.201804176235}]
[12,"2025-01-31",169712.82030619745,4151.6710452708021,0,4151.6710452708021,2878.8248929743213,1272.8461522964808,166833.99541322314,{"$f":"SUM($H$20:$H31)","v":16654.047956472714}]
[13,"2025-03-03",166833.99541322314,4151.6710452708021,0,4151.6710452708021,2900.4160796716287,1251.2549655991736,163933.57933355152,{"$f":"SUM($H$20:$H32)","v":17905.302922071889}]
[14,"2025-03-31",163933.57933355152,4151.6710452708021,0,4151.6710452708021,2922.1692002691657,1229.5018450016364,161011.41013328236,{"$f":"SUM($H$20:$H33)","v":19134.804767073525}]
[15,"2025-05-01",161011.41013328236,4151.6710452708021,0,4151.6710452708021,2944.0854692711846,1207.5855759996177,158067.32466401119,{"$f":"SUM($H$20:$H34)","v":20342.390343073144}]
[16,"2025-05-31",158067.32466401119,4151.6710452708021,0,4151.6710452708021,2966.1661102907183,1185.5049349800838,155101.15855372048,{"$f":"SUM($H$20:$H35)","v":21527.895278053227}]
[17,"2025-07-01",155101.15855372048,4151.6710452708021,0,4151.6710452708021,2988.4123561178985,1163.2586891529036,152112.7461976026,{"$f":"SUM($H$20:$H36)","v":22691.15396720613}]
[18,"2025-07-31",152112.7461976026,4151.6710452708021,0,4151.6710452708021,3010.8254487887825,1140.8455964820193,149101.92074881381,{"$f":"SUM($H$20:$H37)","v":23831.99956368815}]
[19,"2025-08-31",149101.92074881381,4151.6710452708021,0,4151.6710452708021,3033.4066396546987,1118.2644056161034,146068.51410915912,{"$f":"SUM($H$20:$H38)","v":24950.263969304255}]
[20,"2025-10-01",146068.51410915912,4151.6710452708021,0,4151.6710452708021,3056.1571894521085,1095.5138558186934,143012.356919707,{"$f":"SUM($H$20:$H39)","v":26045.777825122947}]
[21,"2025-10-31",143012.356919707,4151.6710452708021,0,4151.6710452708021,3079.0783683729996,1072.5926768978024,139933.27855133399,{"$f":"SUM($H$20:$H40)","v":27118.370502020749}]
[22,"2025-12-01",139933.27855133399,4151.6710452708021,0,4151.6710452708021,3102.1714561357971,1049.499589135005,136831.10709519818,{"$f":"SUM($H$20:$H41)","v":28167.870091155753}]
[23,"2025-12-31",136831.10709519818,4151.6710452708021,0,4151.6710452708021,3125.4377420568158,1026.2333032139863,133705.66935314136,{"$f":"SUM($H$20:$H42)","v":29194.10339436974}]
[24,"2026-01-31",133705.66935314136,4151.6710452708021,0,4151.6710452708021,3148.8785251222421,1002.7925201485601,130556.79082801912,{"$f":"SUM($H$20:$H43)","v":30196.8959145183}]
[25,"2026-03-03",130556.79082801912,4151.6710452708021,0,4151.6710452708021,3172.4951140606586,979.1759312101434,127384.29571395846,{"$f":"SUM($H$20:$H44)","v":31176.071845728442}]
[26,"2026-03-31",127384.29571395846,4151.6710452708021,0,4151.6710452708021,3196.2888274161137,955.38221785468841,124188.00688654235,{"$f":"SUM($H$20:$H45)","v":32131.454063583129}]
[27,"2026-05-01",124188.00688654235,4151.6710452708021,0,4151.6710452708021,3220.2609936217345,931.41005164906755,120967.74589292062,{"$f":"SUM($H$20:$H46)","v":33062.864115232194}]
[28,"2026-05-31",120967.74589292062,4151.6710452708021,0,4151.6710452708021,3244.4129510738976,907.25809419690461,117723.33294184672,{"$f":"SUM($H$20:$H47)","v":33970.122209429101}]
[29,"2026-07-01",117723.33294184672,4151.6710452708021,0,4151.6710452708021,3268.7460482069519,882.92499706385036,114454.58689363976,{"$f":"SUM($H$20:$H48)","v":34853.047206492949}]
[30,"2026-07-31",114454.58689363976,4151.6710452708021,0,4151.6710452708021,3293.261643568504,858.40940170229817,111161.32525007126,{"$f":"SUM($H$20:$H49)","v":35711.456608195251}]
[31,"2026-08-31",111161.32525007126,4151.6710452708021,0,4151.6710452708021,3317.9611058952678,833.70993937553442,107843.36414417598,{"$f":"SUM($H$20:$H50)","v":36545.166547570785}]
[32,"2026-10-01",107843.36414417598,4151.6710452708021,0,4151.6710452708021,3342.8458141894821,808.82523108131988,104500.5183299865,{"$f":"SUM($H$20:$H51)","v":37353.991778652104}]
[33,"2026-10-31",104500.5183299865,4151.6710452708021,0,4151.6710452708021,3367.9171577959032,783.75388747489876,101132.6011721906,{"$f":"SUM($H$20:$H52)","v":38137.745666127004}]
[34,"2026-12-01",101132.6011721906,4151.6710452708021,0,4151.6710452708021,3393.1765364793728,758.49450879142944,97739.424635711228,{"$f":"SUM($H$20:$H53)","v":38896.240174918436}]
[{"$f":"IF(Valores_especificados,A53+1,\"\")","v":35},"2026-12-31",97739.424635711228,4151.6710452708021,0,4151.6710452708021,3418.6253605029679,733.04568476783425,94320.799275208265,{"$f":"SUM($H$20:$H54)","v":39629.285859686272}]
[36,"2027-01-31",94320.799275208265,4151.6710452708021,0,4151.6710452708021,3444.2650507067401,707.40599456406198,90876.53422450152,{"$f":"SUM($H$20:$H55)","v":40336.691854250334}]
[{"$f":"IF(Valores_especificados,A55+1,\"\")","v":37},"2027-03-03",90876.53422450152,4151.6710452708021,0,4151.6710452708021,3470.0970385870405,681.57400668376135,87406.437185914474,{"$f":"SUM($H$20:$H56)","v":41018.265860934094}]
[38,"2027-03-31",87406.437185914474,4151.6710452708021,0,4151.6710452708021,3496.1227663764435,655.54827889435853,83910.31441953803,{"$f":"SUM($H$20:$H57)","v":41673.81413982845}]
[39,"2027-05-01",83910.31441953803,4151.6710452708021,0,4151.6710452708021,3522.343687124267,629.32735814653518,80387.970732413756,{"$f":"SUM($H$20:$H58)","v":42303.141497974982}]
[40,"2027-05-31",80387.970732413756,4151.6710452708021,0,4151.6710452708021,3548.7612647776991,602.90978049310309,76839.209467636058,{"$f":"SUM($H$20:$H59)","v":42906.051278468083}]
[41,"2027-07-01",76839.209467636058,4151.6710452708021,0,4151.6710452708021,3575.3769742635318,576.29407100727042,73263.832493372523,{"$f":"SUM($H$20:$H60)","v":43482.345349475356}]
[42,"2027-07-31",73263.832493372523,4151.6710452708021,0,4151.6710452708021,3602.1923015705083,549.47874370029388,69661.640191802013,{"$f":"SUM($H$20:$H61)","v":44031.824093175652}]
[43,"2027-08-31",69661.640191802013,4151.6710452708021,0,4151.6710452708021,3629.2087438322869,522.46230143851506,66032.43144796972,{"$f":"SUM($H$20:$H62)","v":44554.286394614166}]
[44,"2027-10-01",66032.43144796972,4151.6710452708021,0,4151.6710452708021,3656.4278094110291,495.24323585977294,62376.003638558694,{"$f":"SUM($H$20:$H63)","v":45049.529630473939}]
[45,"2027-10-31",62376.003638558694,4151.6710452708021,0,4151.6710452708021,3683.8510179816121,467.82002728919019,58692.152620577079,{"$f":"SUM($H$20:$H64)","v":45517.34965776313}]
[46,"2027-12-01",58692.152620577079,4151.6710452708021,0,4151.6710452708021,3711.479900616474,440.19114465432807,54980.672719960603,{"$f":"SUM($H$20:$H65)","v":45957.540802417461}]
[47,"2027-12-31",54980.672719960603,4151.6710452708021,0,4151.6710452708021,3739.3159998710976,412.35504539970452,51241.356720089505,{"$f":"SUM($H$20:$H66)","v":46369.895847817163}]
[48,"2028-01-31",51241.356720089505,4151.6710452708021,0,4151.6710452708021,3767.360869870131,384.31017540067131,47473.995850219377,{"$f":"SUM($H$20:$H67)","v":46754.206023217834}]
[49,"2028-03-02",47473.995850219377,4151.6710452708021,0,4151.6710452708021,3795.6160763941566,356.05496887664532,43678.379773825218,{"$f":"SUM($H$20:$H68)","v":47110.260992094481}]
[50,"2028-03-31",43678.379773825218,4151.6710452708021,0,4151.6710452708021,3824.0831969671131,327.5878483036891,39854.296576858105,{"$f":"SUM($H$20:$H69)","v":47437.848840398168}]
[51,"2028-05-01",39854.296576858105,4151.6710452708021,0,4151.6710452708021,3852.7638209443662,298.90722432643577,36001.532755913737,{"$f":"SUM($H$20:$H70)","v":47736.756064724606}]
[52,"2028-05-31",36001.532755913737,4151.6710452708021,0,4151.6710452708021,3881.6595496014493,270.011495669353,32119.873206312288,{"$f":"SUM($H$20:$H71)","v":48006.767560393957}]
[53,"2028-07-01",32119.873206312288,4151.6710452708021,0,4151.6710452708021,3910.7719962234601,240.89904904734215,28209.101210088829,{"$f":"SUM($H$20:$H72)","v":48247.666609441301}]
[54,"2028-07-31",28209.101210088829,4151.6710452708021,0,4151.6710452708021,3940.1027861951361,211.56825907566622,24268.998423893692,{"$f":"SUM($H$20:$H73)","v":48459.234868516971}]
[55,"2028-08-31",24268.998423893692,4151.6710452708021,0,4151.6710452708021,3969.6535570915994,182.0174881792027,20299.344866802094,{"$f":"SUM($H$20:$H74)","v":48641.252356696175}]
[56,"2028-10-01",20299.344866802094,4151.6710452708021,0,4151.6710452708021,3999.4259587697866,152.24508650101569,16299.918908032307,{"$f":"SUM($H$20:$H75)","v":48793.497443197193}]
[57,"2028-10-31",16299.918908032307,4151.6710452708021,0,4151.6710452708021,4029.4216534605598,122.24939181024229,12270.497254571746,{"$f":"SUM($H$20:$H76)","v":48915.746835007434}]
[58,"2028-12-01",12270.497254571746,4151.6710452708021,0,4151.6710452708021,4059.6423158615139,92.02872940928809,8210.8549387102321,{"$f":"SUM($H$20:$H77)","v":49007.775564416719}]
[59,"2028-12-31",8210.8549387102321,4151.6710452708021,0,4151.6710452708021,4090.0896332304756,61.58141204032674,4120.7653054797565,{"$f":"SUM($H$20:$H78)","v":49069.356976457049}]
[60,"2029-01-31",4120.7653054797565,4151.6710452708021,0,4120.7653054797565,4089.8595656886582,30.905739791098171,0,{"$f":"SUM($H$20:$H79)","v":49100.262716248144}]
[61,"2029-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H80)","v":49100.262716248144}]
[62,"2029-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H81)","v":49100.262716248144}]
[63,"2029-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H82)","v":49100.262716248144}]
[64,"2029-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H83)","v":49100.262716248144}]
[65,{"$f":"IF(Núm_de_pago<>\"\",DATE(YEAR(Inicio_prestamo),MONTH(Inicio_prestamo)+(Núm_de_pago)*12/Núm_pagos_al_año,DAY(Inicio_prestamo)),\"\")","v":"2029-07-01"},0,4151.6710452708021,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pagos_adicionales_programados<Saldo_inicial),Pagos_adicionales_programados,IF(AND(Núm_de_pago<>\"\",Saldo_inicial-Pago_progr>0),Saldo_inicial-Pago_progr,IF(Núm_de_pago<>\"\",0,\"\")))","v":0},{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Pago_progr+Pago_adicional,IF(Núm_de_pago<>\"\",Saldo_inicial,\"\"))","v":0},0,0,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Saldo_inicial-Capital,IF(Núm_de_pago<>\"\",0,\"\"))","v":0},{"$f":"SUM($H$20:$H84)","v":49100.262716248144}]
[{"$f":"IF(Valores_especificados,A84+1,\"\")","v":66},"2029-07-31",{"$f":"IF(Núm_de_pago<>\"\",I84,\"\")","v":0},4151.6710452708021,0,0,{"$f":"IF(Núm_de_pago<>\"\",Pago_total-Int,\"\")","v":0},{"$f":"IF(Núm_de_pago<>\"\",Saldo_inicial*Tasa_de_interés/Núm_pagos_al_año,\"\")","v":0},0,{"$f":"SUM($H$20:$H85)","v":49100.262716248144}]
[67,"2029-08-31",0,{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},0,0,0,0,0,{"$f":"SUM($H$20:$H86)","v":49100.262716248144}]
[68,"2029-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H87)","v":49100.262716248144}]
[69,"2029-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H88)","v":49100.262716248144}]
[70,"2029-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H89)","v":49100.262716248144}]
[71,"2029-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H90)","v":49100.262716248144}]
[72,"2030-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H91)","v":49100.262716248144}]
[73,"2030-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H92)","v":49100.262716248144}]
[74,"2030-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H93)","v":49100.262716248144}]
[75,"2030-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H94)","v":49100.262716248144}]
[76,"2030-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H95)","v":49100.262716248144}]
[77,"2030-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H96)","v":49100.262716248144}]
[78,"2030-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H97)","v":49100.262716248144}]
[79,"2030-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H98)","v":49100.262716248144}]
[80,"2030-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H99)","v":49100.262716248144}]
[81,"2030-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H100)","v":49100.262716248144}]
[82,"2030-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H101)","v":49100.262716248144}]
[83,"2030-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H102)","v":49100.262716248144}]
[84,"2031-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H103)","v":49100.262716248144}]
[85,"2031-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H104)","v":49100.262716248144}]
[86,"2031-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H105)","v":49100.262716248144}]
[87,"2031-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H106)","v":49100.262716248144}]
[88,"2031-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H107)","v":49100.262716248144}]
[89,"2031-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H108)","v":49100.262716248144}]
[90,"2031-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H109)","v":49100.262716248144}]
[91,"2031-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H110)","v":49100.262716248144}]
[92,"2031-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H111)","v":49100.262716248144}]
[93,"2031-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H112)","v":49100.262716248144}]
[94,"2031-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H113)","v":49100.262716248144}]
[95,"2031-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H114)","v":49100.262716248144}]
[96,"2032-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H115)","v":49100.262716248144}]
[97,"2032-03-02",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H116)","v":49100.262716248144}]
[98,"2032-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H117)","v":49100.262716248144}]
[99,"2032-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H118)","v":49100.262716248144}]
[100,"2032-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H119)","v":49100.262716248144}]
[101,"2032-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H120)","v":49100.262716248144}]
[102,"2032-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H121)","v":49100.262716248144}]
[103,"2032-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H122)","v":49100.262716248144}]
[104,"2032-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H123)","v":49100.262716248144}]
[105,"2032-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H124)","v":49100.262716248144}]
[106,"2032-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H125)","v":49100.262716248144}]
[107,"2032-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H126)","v":49100.262716248144}]
[108,"2033-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H127)","v":49100.262716248144}]
[109,"2033-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H128)","v":49100.262716248144}]
[110,"2033-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H129)","v":49100.262716248144}]
[111,"2033-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H130)","v":49100.262716248144}]
[112,"2033-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H131)","v":49100.262716248144}]
[113,"2033-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H132)","v":49100.262716248144}]
[114,"2033-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H133)","v":49100.262716248144}]
[115,"2033-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H134)","v":49100.262716248144}]
[116,"2033-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H135)","v":49100.262716248144}]
[117,"2033-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H136)","v":49100.262716248144}]
[118,"2033-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H137)","v":49100.262716248144}]
[119,"2033-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H138)","v":49100.262716248144}]
[120,"2034-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H139)","v":49100.262716248144}]
[121,"2034-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H140)","v":49100.262716248144}]
[122,"2034-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H141)","v":49100.262716248144}]
[123,"2034-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H142)","v":49100.262716248144}]
[124,"2034-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H143)","v":49100.262716248144}]
[125,"2034-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H144)","v":49100.262716248144}]
[126,"2034-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H145)","v":49100.262716248144}]
[127,"2034-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H146)","v":49100.262716248144}]
[128,"2034-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H147)","v":49100.262716248144}]
[129,{"$f":"IF(Núm_de_pago<>\"\",DATE(YEAR(Inicio_prestamo),MONTH(Inicio_prestamo)+(Núm_de_pago)*12/Núm_pagos_al_año,DAY(Inicio_prestamo)),\"\")","v":"2034-10-31"},0,4151.6710452708021,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pagos_adicionales_programados<Saldo_inicial),Pagos_adicionales_programados,IF(AND(Núm_de_pago<>\"\",Saldo_inicial-Pago_progr>0),Saldo_inicial-Pago_progr,IF(Núm_de_pago<>\"\",0,\"\")))","v":0},{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Pago_progr+Pago_adicional,IF(Núm_de_pago<>\"\",Saldo_inicial,\"\"))","v":0},0,0,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Saldo_inicial-Capital,IF(Núm_de_pago<>\"\",0,\"\"))","v":0},{"$f":"SUM($H$20:$H148)","v":49100.262716248144}]
[{"$f":"IF(Valores_especificados,A148+1,\"\")","v":130},"2034-12-01",{"$f":"IF(Núm_de_pago<>\"\",I148,\"\")","v":0},4151.6710452708021,0,0,{"$f":"IF(Núm_de_pago<>\"\",Pago_total-Int,\"\")","v":0},{"$f":"IF(Núm_de_pago<>\"\",Saldo_inicial*Tasa_de_interés/Núm_pagos_al_año,\"\")","v":0},0,{"$f":"SUM($H$20:$H149)","v":49100.262716248144}]
[131,"2034-12-31",0,{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},0,0,0,0,0,{"$f":"SUM($H$20:$H150)","v":49100.262716248144}]
[132,"2035-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H151)","v":49100.262716248144}]
[133,"2035-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H152)","v":49100.262716248144}]
[134,"2035-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H153)","v":49100.262716248144}]
[135,"2035-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H154)","v":49100.262716248144}]
[136,"2035-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H155)","v":49100.262716248144}]
[137,"2035-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H156)","v":49100.262716248144}]
[138,"2035-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H157)","v":49100.262716248144}]
[139,"2035-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H158)","v":49100.262716248144}]
[140,"2035-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H159)","v":49100.262716248144}]
[141,"2035-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H160)","v":49100.262716248144}]
[142,"2035-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H161)","v":49100.262716248144}]
[143,"2035-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H162)","v":49100.262716248144}]
[144,"2036-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H163)","v":49100.262716248144}]
[145,"2036-03-02",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H164)","v":49100.262716248144}]
[146,"2036-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H165)","v":49100.262716248144}]
[147,"2036-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H166)","v":49100.262716248144}]
[148,"2036-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H167)","v":49100.262716248144}]
[149,"2036-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H168)","v":49100.262716248144}]
[150,"2036-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H169)","v":49100.262716248144}]
[151,"2036-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H170)","v":49100.262716248144}]
[152,"2036-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H171)","v":49100.262716248144}]
[153,"2036-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H172)","v":49100.262716248144}]
[154,"2036-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H173)","v":49100.262716248144}]
[155,"2036-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H174)","v":49100.262716248144}]
[156,"2037-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H175)","v":49100.262716248144}]
[157,"2037-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H176)","v":49100.262716248144}]
[158,"2037-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H177)","v":49100.262716248144}]
[159,"2037-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H178)","v":49100.262716248144}]
[160,"2037-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H179)","v":49100.262716248144}]
[161,"2037-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H180)","v":49100.262716248144}]
[162,"2037-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H181)","v":49100.262716248144}]
[163,"2037-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H182)","v":49100.262716248144}]
[164,"2037-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H183)","v":49100.262716248144}]
[165,"2037-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H184)","v":49100.262716248144}]
[166,"2037-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H185)","v":49100.262716248144}]
[167,"2037-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H186)","v":49100.262716248144}]
[168,"2038-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H187)","v":49100.262716248144}]
[169,"2038-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H188)","v":49100.262716248144}]
[170,"2038-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H189)","v":49100.262716248144}]
[171,"2038-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H190)","v":49100.262716248144}]
[172,"2038-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H191)","v":49100.262716248144}]
[173,"2038-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H192)","v":49100.262716248144}]
[174,"2038-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H193)","v":49100.262716248144}]
[175,"2038-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H194)","v":49100.262716248144}]
[176,"2038-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H195)","v":49100.262716248144}]
[177,"2038-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H196)","v":49100.262716248144}]
[178,"2038-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H197)","v":49100.262716248144}]
[179,"2038-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H198)","v":49100.262716248144}]
[180,"2039-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H199)","v":49100.262716248144}]
[181,"2039-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H200)","v":49100.262716248144}]
[182,"2039-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H201)","v":49100.262716248144}]
[183,"2039-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H202)","v":49100.262716248144}]
[184,"2039-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H203)","v":49100.262716248144}]
[185,"2039-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H204)","v":49100.262716248144}]
[186,"2039-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H205)","v":49100.262716248144}]
[187,"2039-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H206)","v":49100.262716248144}]
[188,"2039-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H207)","v":49100.262716248144}]
[189,"2039-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H208)","v":49100.262716248144}]
[190,"2039-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H209)","v":49100.262716248144}]
[191,"2039-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H210)","v":49100.262716248144}]
[192,"2040-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H211)","v":49100.262716248144}]
[193,{"$f":"IF(Núm_de_pago<>\"\",DATE(YEAR(Inicio_prestamo),MONTH(Inicio_prestamo)+(Núm_de_pago)*12/Núm_pagos_al_año,DAY(Inicio_prestamo)),\"\")","v":"2040-03-02"},0,4151.6710452708021,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pagos_adicionales_programados<Saldo_inicial),Pagos_adicionales_programados,IF(AND(Núm_de_pago<>\"\",Saldo_inicial-Pago_progr>0),Saldo_inicial-Pago_progr,IF(Núm_de_pago<>\"\",0,\"\")))","v":0},{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Pago_progr+Pago_adicional,IF(Núm_de_pago<>\"\",Saldo_inicial,\"\"))","v":0},0,0,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Saldo_inicial-Capital,IF(Núm_de_pago<>\"\",0,\"\"))","v":0},{"$f":"SUM($H$20:$H212)","v":49100.262716248144}]
[{"$f":"IF(Valores_especificados,A212+1,\"\")","v":194},"2040-03-31",{"$f":"IF(Núm_de_pago<>\"\",I212,\"\")","v":0},4151.6710452708021,0,0,{"$f":"IF(Núm_de_pago<>\"\",Pago_total-Int,\"\")","v":0},{"$f":"IF(Núm_de_pago<>\"\",Saldo_inicial*Tasa_de_interés/Núm_pagos_al_año,\"\")","v":0},0,{"$f":"SUM($H$20:$H213)","v":49100.262716248144}]
[195,"2040-05-01",0,{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},0,0,0,0,0,{"$f":"SUM($H$20:$H214)","v":49100.262716248144}]
[196,"2040-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H215)","v":49100.262716248144}]
[197,"2040-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H216)","v":49100.262716248144}]
[198,"2040-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H217)","v":49100.262716248144}]
[199,"2040-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H218)","v":49100.262716248144}]
[200,"2040-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H219)","v":49100.262716248144}]
[201,"2040-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H220)","v":49100.262716248144}]
[202,"2040-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H221)","v":49100.262716248144}]
[203,"2040-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H222)","v":49100.262716248144}]
[204,"2041-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H223)","v":49100.262716248144}]
[205,"2041-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H224)","v":49100.262716248144}]
[206,"2041-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H225)","v":49100.262716248144}]
[207,"2041-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H226)","v":49100.262716248144}]
[208,"2041-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H227)","v":49100.262716248144}]
[209,"2041-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H228)","v":49100.262716248144}]
[210,"2041-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H229)","v":49100.262716248144}]
[211,"2041-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H230)","v":49100.262716248144}]
[212,"2041-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H231)","v":49100.262716248144}]
[213,"2041-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H232)","v":49100.262716248144}]
[214,"2041-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H233)","v":49100.262716248144}]
[215,"2041-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H234)","v":49100.262716248144}]
[216,"2042-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H235)","v":49100.262716248144}]
[217,"2042-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H236)","v":49100.262716248144}]
[218,"2042-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H237)","v":49100.262716248144}]
[219,"2042-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H238)","v":49100.262716248144}]
[220,"2042-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H239)","v":49100.262716248144}]
[221,"2042-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H240)","v":49100.262716248144}]
[222,"2042-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H241)","v":49100.262716248144}]
[223,"2042-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H242)","v":49100.262716248144}]
[224,"2042-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H243)","v":49100.262716248144}]
[225,"2042-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H244)","v":49100.262716248144}]
[226,"2042-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H245)","v":49100.262716248144}]
[227,"2042-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H246)","v":49100.262716248144}]
[228,"2043-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H247)","v":49100.262716248144}]
[229,"2043-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H248)","v":49100.262716248144}]
[230,"2043-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H249)","v":49100.262716248144}]
[231,"2043-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H250)","v":49100.262716248144}]
[232,"2043-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H251)","v":49100.262716248144}]
[233,"2043-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H252)","v":49100.262716248144}]
[234,"2043-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H253)","v":49100.262716248144}]
[235,"2043-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H254)","v":49100.262716248144}]
[236,"2043-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H255)","v":49100.262716248144}]
[237,"2043-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H256)","v":49100.262716248144}]
[238,"2043-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H257)","v":49100.262716248144}]
[239,"2043-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H258)","v":49100.262716248144}]
[240,"2044-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H259)","v":49100.262716248144}]
[241,"2044-03-02",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H260)","v":49100.262716248144}]
[242,"2044-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H261)","v":49100.262716248144}]
[243,"2044-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H262)","v":49100.262716248144}]
[244,"2044-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H263)","v":49100.262716248144}]
[245,"2044-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H264)","v":49100.262716248144}]
[246,"2044-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H265)","v":49100.262716248144}]
[247,"2044-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H266)","v":49100.262716248144}]
[248,"2044-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H267)","v":49100.262716248144}]
[249,"2044-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H268)","v":49100.262716248144}]
[250,"2044-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H269)","v":49100.262716248144}]
[251,"2044-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H270)","v":49100.262716248144}]
[252,"2045-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H271)","v":49100.262716248144}]
[253,"2045-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H272)","v":49100.262716248144}]
[254,"2045-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H273)","v":49100.262716248144}]
[255,"2045-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H274)","v":49100.262716248144}]
[256,"2045-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H275)","v":49100.262716248144}]
[257,{"$f":"IF(Núm_de_pago<>\"\",DATE(YEAR(Inicio_prestamo),MONTH(Inicio_prestamo)+(Núm_de_pago)*12/Núm_pagos_al_año,DAY(Inicio_prestamo)),\"\")","v":"2045-07-01"},0,4151.6710452708021,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pagos_adicionales_programados<Saldo_inicial),Pagos_adicionales_programados,IF(AND(Núm_de_pago<>\"\",Saldo_inicial-Pago_progr>0),Saldo_inicial-Pago_progr,IF(Núm_de_pago<>\"\",0,\"\")))","v":0},{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Pago_progr+Pago_adicional,IF(Núm_de_pago<>\"\",Saldo_inicial,\"\"))","v":0},0,0,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Saldo_inicial-Capital,IF(Núm_de_pago<>\"\",0,\"\"))","v":0},{"$f":"SUM($H$20:$H276)","v":49100.262716248144}]
[{"$f":"IF(Valores_especificados,A276+1,\"\")","v":258},"2045-07-31",{"$f":"IF(Núm_de_pago<>\"\",I276,\"\")","v":0},4151.6710452708021,0,0,{"$f":"IF(Núm_de_pago<>\"\",Pago_total-Int,\"\")","v":0},{"$f":"IF(Núm_de_pago<>\"\",Saldo_inicial*Tasa_de_interés/Núm_pagos_al_año,\"\")","v":0},0,{"$f":"SUM($H$20:$H277)","v":49100.262716248144}]
[259,"2045-08-31",0,{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},0,0,0,0,0,{"$f":"SUM($H$20:$H278)","v":49100.262716248144}]
[260,"2045-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H279)","v":49100.262716248144}]
[261,"2045-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H280)","v":49100.262716248144}]
[262,"2045-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H281)","v":49100.262716248144}]
[263,"2045-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H282)","v":49100.262716248144}]
[264,"2046-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H283)","v":49100.262716248144}]
[265,"2046-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H284)","v":49100.262716248144}]
[266,"2046-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H285)","v":49100.262716248144}]
[267,"2046-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H286)","v":49100.262716248144}]
[268,"2046-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H287)","v":49100.262716248144}]
[269,"2046-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H288)","v":49100.262716248144}]
[270,"2046-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H289)","v":49100.262716248144}]
[271,"2046-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H290)","v":49100.262716248144}]
[272,"2046-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H291)","v":49100.262716248144}]
[273,"2046-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H292)","v":49100.262716248144}]
[274,"2046-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H293)","v":49100.262716248144}]
[275,"2046-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H294)","v":49100.262716248144}]
[276,"2047-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H295)","v":49100.262716248144}]
[277,"2047-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H296)","v":49100.262716248144}]
[278,"2047-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H297)","v":49100.262716248144}]
[279,"2047-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H298)","v":49100.262716248144}]
[280,"2047-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H299)","v":49100.262716248144}]
[281,"2047-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H300)","v":49100.262716248144}]
[282,"2047-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H301)","v":49100.262716248144}]
[283,"2047-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H302)","v":49100.262716248144}]
[284,"2047-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H303)","v":49100.262716248144}]
[285,"2047-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H304)","v":49100.262716248144}]
[286,"2047-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H305)","v":49100.262716248144}]
[287,"2047-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H306)","v":49100.262716248144}]
[288,"2048-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H307)","v":49100.262716248144}]
[289,"2048-03-02",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H308)","v":49100.262716248144}]
[290,"2048-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H309)","v":49100.262716248144}]
[291,"2048-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H310)","v":49100.262716248144}]
[292,"2048-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H311)","v":49100.262716248144}]
[293,"2048-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H312)","v":49100.262716248144}]
[294,"2048-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H313)","v":49100.262716248144}]
[295,"2048-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H314)","v":49100.262716248144}]
[296,"2048-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H315)","v":49100.262716248144}]
[297,"2048-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H316)","v":49100.262716248144}]
[298,"2048-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H317)","v":49100.262716248144}]
[299,"2048-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H318)","v":49100.262716248144}]
[300,"2049-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H319)","v":49100.262716248144}]
[301,"2049-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H320)","v":49100.262716248144}]
[302,"2049-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H321)","v":49100.262716248144}]
[303,"2049-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H322)","v":49100.262716248144}]
[304,"2049-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H323)","v":49100.262716248144}]
[305,"2049-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H324)","v":49100.262716248144}]
[306,"2049-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H325)","v":49100.262716248144}]
[307,"2049-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H326)","v":49100.262716248144}]
[308,"2049-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H327)","v":49100.262716248144}]
[309,"2049-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H328)","v":49100.262716248144}]
[310,"2049-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H329)","v":49100.262716248144}]
[311,"2049-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H330)","v":49100.262716248144}]
[312,"2050-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H331)","v":49100.262716248144}]
[313,"2050-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H332)","v":49100.262716248144}]
[314,"2050-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H333)","v":49100.262716248144}]
[315,"2050-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H334)","v":49100.262716248144}]
[316,"2050-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H335)","v":49100.262716248144}]
[317,"2050-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H336)","v":49100.262716248144}]
[318,"2050-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H337)","v":49100.262716248144}]
[319,"2050-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H338)","v":49100.262716248144}]
[320,"2050-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H339)","v":49100.262716248144}]
[321,{"$f":"IF(Núm_de_pago<>\"\",DATE(YEAR(Inicio_prestamo),MONTH(Inicio_prestamo)+(Núm_de_pago)*12/Núm_pagos_al_año,DAY(Inicio_prestamo)),\"\")","v":"2050-10-31"},0,4151.6710452708021,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pagos_adicionales_programados<Saldo_inicial),Pagos_adicionales_programados,IF(AND(Núm_de_pago<>\"\",Saldo_inicial-Pago_progr>0),Saldo_inicial-Pago_progr,IF(Núm_de_pago<>\"\",0,\"\")))","v":0},{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Pago_progr+Pago_adicional,IF(Núm_de_pago<>\"\",Saldo_inicial,\"\"))","v":0},0,0,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Saldo_inicial-Capital,IF(Núm_de_pago<>\"\",0,\"\"))","v":0},{"$f":"SUM($H$20:$H340)","v":49100.262716248144}]
[{"$f":"IF(Valores_especificados,A340+1,\"\")","v":322},"2050-12-01",{"$f":"IF(Núm_de_pago<>\"\",I340,\"\")","v":0},4151.6710452708021,0,0,{"$f":"IF(Núm_de_pago<>\"\",Pago_total-Int,\"\")","v":0},{"$f":"IF(Núm_de_pago<>\"\",Saldo_inicial*Tasa_de_interés/Núm_pagos_al_año,\"\")","v":0},0,{"$f":"SUM($H$20:$H341)","v":49100.262716248144}]
[323,"2050-12-31",0,{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},0,0,0,0,0,{"$f":"SUM($H$20:$H342)","v":49100.262716248144}]
[324,"2051-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H343)","v":49100.262716248144}]
[325,"2051-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H344)","v":49100.262716248144}]
[326,"2051-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H345)","v":49100.262716248144}]
[327,"2051-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H346)","v":49100.262716248144}]
[328,"2051-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H347)","v":49100.262716248144}]
[329,"2051-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H348)","v":49100.262716248144}]
[330,"2051-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H349)","v":49100.262716248144}]
[331,"2051-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H350)","v":49100.262716248144}]
[332,"2051-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H351)","v":49100.262716248144}]
[333,"2051-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H352)","v":49100.262716248144}]
[334,"2051-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H353)","v":49100.262716248144}]
[335,"2051-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H354)","v":49100.262716248144}]
[336,"2052-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H355)","v":49100.262716248144}]
[337,"2052-03-02",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H356)","v":49100.262716248144}]
[338,"2052-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H357)","v":49100.262716248144}]
[339,"2052-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H358)","v":49100.262716248144}]
[340,"2052-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H359)","v":49100.262716248144}]
[341,"2052-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H360)","v":49100.262716248144}]
[342,"2052-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H361)","v":49100.262716248144}]
[343,"2052-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H362)","v":49100.262716248144}]
[344,"2052-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H363)","v":49100.262716248144}]
[345,"2052-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H364)","v":49100.262716248144}]
[346,"2052-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H365)","v":49100.262716248144}]
[347,"2052-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H366)","v":49100.262716248144}]
[348,"2053-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H367)","v":49100.262716248144}]
[349,"2053-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H368)","v":49100.262716248144}]
[350,"2053-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H369)","v":49100.262716248144}]
[351,"2053-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H370)","v":49100.262716248144}]
[352,"2053-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H371)","v":49100.262716248144}]
[353,"2053-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H372)","v":49100.262716248144}]
[354,"2053-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H373)","v":49100.262716248144}]
[355,"2053-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H374)","v":49100.262716248144}]
[356,"2053-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H375)","v":49100.262716248144}]
[357,"2053-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H376)","v":49100.262716248144}]
[358,"2053-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H377)","v":49100.262716248144}]
[359,"2053-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H378)","v":49100.262716248144}]
[360,"2054-01-31",{"$f":"IF(Núm_de_pago<>\"\",I378,\"\")","v":0},4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H379)","v":49100.262716248144}]
[361,"2054-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H380)","v":49100.262716248144}]
[362,"2054-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H381)","v":49100.262716248144}]
[363,"2054-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H382)","v":49100.262716248144}]
[364,"2054-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H383)","v":49100.262716248144}]
[365,"2054-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H384)","v":49100.262716248144}]
[366,"2054-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H385)","v":49100.262716248144}]
[367,"2054-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H386)","v":49100.262716248144}]
[368,"2054-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H387)","v":49100.262716248144}]
[369,"2054-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H388)","v":49100.262716248144}]
[370,"2054-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H389)","v":49100.262716248144}]
[371,"2054-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H390)","v":49100.262716248144}]
[372,"2055-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H391)","v":49100.262716248144}]
[373,"2055-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H392)","v":49100.262716248144}]
[374,"2055-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H393)","v":49100.262716248144}]
[375,"2055-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H394)","v":49100.262716248144}]
[376,"2055-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H395)","v":49100.262716248144}]
[377,"2055-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H396)","v":49100.262716248144}]
[378,"2055-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H397)","v":49100.262716248144}]
[379,"2055-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H398)","v":49100.262716248144}]
[380,"2055-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H399)","v":49100.262716248144}]
[381,"2055-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H400)","v":49100.262716248144}]
[382,"2055-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H401)","v":49100.262716248144}]
[383,"2055-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H402)","v":49100.262716248144}]
[384,"2056-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H403)","v":49100.262716248144}]
[385,{"$f":"IF(Núm_de_pago<>\"\",DATE(YEAR(Inicio_prestamo),MONTH(Inicio_prestamo)+(Núm_de_pago)*12/Núm_pagos_al_año,DAY(Inicio_prestamo)),\"\")","v":"2056-03-02"},0,4151.6710452708021,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pagos_adicionales_programados<Saldo_inicial),Pagos_adicionales_programados,IF(AND(Núm_de_pago<>\"\",Saldo_inicial-Pago_progr>0),Saldo_inicial-Pago_progr,IF(Núm_de_pago<>\"\",0,\"\")))","v":0},{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Pago_progr+Pago_adicional,IF(Núm_de_pago<>\"\",Saldo_inicial,\"\"))","v":0},0,0,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Saldo_inicial-Capital,IF(Núm_de_pago<>\"\",0,\"\"))","v":0},{"$f":"SUM($H$20:$H404)","v":49100.262716248144}]
[{"$f":"IF(Valores_especificados,A404+1,\"\")","v":386},"2056-03-31",0,4151.6710452708021,0,0,{"$f":"IF(Núm_de_pago<>\"\",Pago_total-Int,\"\")","v":0},{"$f":"IF(Núm_de_pago<>\"\",Saldo_inicial*Tasa_de_interés/Núm_pagos_al_año,\"\")","v":0},0,{"$f":"SUM($H$20:$H405)","v":49100.262716248144}]
[387,"2056-05-01",0,{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},0,0,0,0,0,{"$f":"SUM($H$20:$H406)","v":49100.262716248144}]
[388,"2056-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H407)","v":49100.262716248144}]
[389,"2056-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H408)","v":49100.262716248144}]
[390,"2056-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H409)","v":49100.262716248144}]
[391,"2056-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H410)","v":49100.262716248144}]
[392,"2056-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H411)","v":49100.262716248144}]
[393,"2056-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H412)","v":49100.262716248144}]
[394,"2056-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H413)","v":49100.262716248144}]
[395,"2056-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H414)","v":49100.262716248144}]
[396,"2057-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H415)","v":49100.262716248144}]
[397,"2057-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H416)","v":49100.262716248144}]
[398,"2057-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H417)","v":49100.262716248144}]
[399,"2057-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H418)","v":49100.262716248144}]
[400,"2057-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H419)","v":49100.262716248144}]
[401,"2057-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H420)","v":49100.262716248144}]
[402,"2057-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H421)","v":49100.262716248144}]
[403,"2057-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H422)","v":49100.262716248144}]
[404,"2057-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H423)","v":49100.262716248144}]
[405,"2057-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H424)","v":49100.262716248144}]
[406,"2057-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H425)","v":49100.262716248144}]
[407,"2057-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H426)","v":49100.262716248144}]
[408,"2058-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H427)","v":49100.262716248144}]
[409,"2058-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H428)","v":49100.262716248144}]
[410,"2058-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H429)","v":49100.262716248144}]
[411,"2058-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H430)","v":49100.262716248144}]
[412,"2058-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H431)","v":49100.262716248144}]
[413,"2058-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H432)","v":49100.262716248144}]
[414,"2058-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H433)","v":49100.262716248144}]
[415,"2058-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H434)","v":49100.262716248144}]
[416,"2058-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H435)","v":49100.262716248144}]
[417,"2058-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H436)","v":49100.262716248144}]
[418,"2058-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H437)","v":49100.262716248144}]
[419,"2058-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H438)","v":49100.262716248144}]
[420,"2059-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H439)","v":49100.262716248144}]
[421,"2059-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H440)","v":49100.262716248144}]
[422,"2059-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H441)","v":49100.262716248144}]
[423,"2059-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H442)","v":49100.262716248144}]
[424,"2059-05-31",{"$f":"IF(Núm_de_pago<>\"\",I442,\"\")","v":0},4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H443)","v":49100.262716248144}]
[425,"2059-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H444)","v":49100.262716248144}]
[426,"2059-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H445)","v":49100.262716248144}]
[427,"2059-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H446)","v":49100.262716248144}]
[428,"2059-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H447)","v":49100.262716248144}]
[429,"2059-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H448)","v":49100.262716248144}]
[430,"2059-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H449)","v":49100.262716248144}]
[431,"2059-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H450)","v":49100.262716248144}]
[432,"2060-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H451)","v":49100.262716248144}]
[433,"2060-03-02",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H452)","v":49100.262716248144}]
[434,"2060-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H453)","v":49100.262716248144}]
[435,"2060-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H454)","v":49100.262716248144}]
[436,"2060-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H455)","v":49100.262716248144}]
[437,"2060-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H456)","v":49100.262716248144}]
[438,"2060-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H457)","v":49100.262716248144}]
[439,"2060-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H458)","v":49100.262716248144}]
[440,"2060-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H459)","v":49100.262716248144}]
[441,"2060-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H460)","v":49100.262716248144}]
[442,"2060-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H461)","v":49100.262716248144}]
[443,"2060-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H462)","v":49100.262716248144}]
[444,"2061-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H463)","v":49100.262716248144}]
[445,"2061-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H464)","v":49100.262716248144}]
[446,"2061-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H465)","v":49100.262716248144}]
[447,"2061-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H466)","v":49100.262716248144}]
[448,"2061-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H467)","v":49100.262716248144}]
[449,{"$f":"IF(Núm_de_pago<>\"\",DATE(YEAR(Inicio_prestamo),MONTH(Inicio_prestamo)+(Núm_de_pago)*12/Núm_pagos_al_año,DAY(Inicio_prestamo)),\"\")","v":"2061-07-01"},0,4151.6710452708021,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pagos_adicionales_programados<Saldo_inicial),Pagos_adicionales_programados,IF(AND(Núm_de_pago<>\"\",Saldo_inicial-Pago_progr>0),Saldo_inicial-Pago_progr,IF(Núm_de_pago<>\"\",0,\"\")))","v":0},{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Pago_progr+Pago_adicional,IF(Núm_de_pago<>\"\",Saldo_inicial,\"\"))","v":0},0,0,{"$f":"IF(AND(Núm_de_pago<>\"\",Pago_progr+Pago_adicional<Saldo_inicial),Saldo_inicial-Capital,IF(Núm_de_pago<>\"\",0,\"\"))","v":0},{"$f":"SUM($H$20:$H468)","v":49100.262716248144}]
[{"$f":"IF(Valores_especificados,A468+1,\"\")","v":450},"2061-07-31",0,4151.6710452708021,0,0,{"$f":"IF(Núm_de_pago<>\"\",Pago_total-Int,\"\")","v":0},{"$f":"IF(Núm_de_pago<>\"\",Saldo_inicial*Tasa_de_interés/Núm_pagos_al_año,\"\")","v":0},0,{"$f":"SUM($H$20:$H469)","v":49100.262716248144}]
[451,"2061-08-31",0,{"$f":"IF(Núm_de_pago<>\"\",Pago_mensual_programado,\"\")","v":4151.6710452708021},0,0,0,0,0,{"$f":"SUM($H$20:$H470)","v":49100.262716248144}]
[452,"2061-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H471)","v":49100.262716248144}]
[453,"2061-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H472)","v":49100.262716248144}]
[454,"2061-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H473)","v":49100.262716248144}]
[455,"2061-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H474)","v":49100.262716248144}]
[456,"2062-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H475)","v":49100.262716248144}]
[457,"2062-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H476)","v":49100.262716248144}]
[458,"2062-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H477)","v":49100.262716248144}]
[459,"2062-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H478)","v":49100.262716248144}]
[460,"2062-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H479)","v":49100.262716248144}]
[461,"2062-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H480)","v":49100.262716248144}]
[462,"2062-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H481)","v":49100.262716248144}]
[463,"2062-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H482)","v":49100.262716248144}]
[464,"2062-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H483)","v":49100.262716248144}]
[465,"2062-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H484)","v":49100.262716248144}]
[466,"2062-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H485)","v":49100.262716248144}]
[467,"2062-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H486)","v":49100.262716248144}]
[468,"2063-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H487)","v":49100.262716248144}]
[469,"2063-03-03",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H488)","v":49100.262716248144}]
[470,"2063-03-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H489)","v":49100.262716248144}]
[471,"2063-05-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H490)","v":49100.262716248144}]
[472,"2063-05-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H491)","v":49100.262716248144}]
[473,"2063-07-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H492)","v":49100.262716248144}]
[474,"2063-07-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H493)","v":49100.262716248144}]
[475,"2063-08-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H494)","v":49100.262716248144}]
[476,"2063-10-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H495)","v":49100.262716248144}]
[477,"2063-10-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H496)","v":49100.262716248144}]
[478,"2063-12-01",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H497)","v":49100.262716248144}]
[479,"2063-12-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H498)","v":49100.262716248144}]
[480,"2064-01-31",0,4151.6710452708021,0,0,0,0,0,{"$f":"SUM($H$20:$H499)","v":49100.262716248144}]

{"sheet":"Hoja1","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Comisión de gestión (CG)"]
[]
[null,"Desccripcion","Monto"]
[null,"Tinbres"]
[null,"Centrald de riezgos"]
[null,"Gastos por liquidacion"]
[null,"seguro deuda"]
[]
[]
[null,"TOTAL",{"$f":"SUM(C4:C9)","v":0}]