{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Liquidación","Tasas de Interes"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Liquidación","index":0,"n_rows":103,"n_cols":19,"rows_kept":103,"merged":[[2,11,2,12],[2,13,2,16],[4,2,4,6],[4,7,4,8],[4,12,5,12],[4,13,5,13],[4,14,5,15],[5,2,6,6],[5,7,6,8],[6,9,8,10],[6,14,6,15],[7,14,7,15],[8,14,8,15],[9,2,16,2],[9,3,10,3],[9,4,10,5],[9,9,9,10],[9,14,9,15],[10,14,10,15],[11,9,13,10],[11,14,11,15],[12,3,13,3],[12,4,13,5],[12,14,12,15],[13,14,13,15],[14,9,14,10],[14,14,14,15],[15,3,16,3],[15,4,16,5],[15,14,15,15],[16,9,18,10],[16,14,16,15],[17,4,20,5],[17,14,17,15],[18,14,18,15],[19,9,20,10],[19,14,19,15],[20,14,20,15],[21,14,21,15],[25,1,38,1],[25,7,38,7],[25,13,38,13],[41,1,54,1],[41,7,54,7],[41,13,54,13],[57,1,70,1],[57,7,70,7],[57,13,70,13],[73,1,86,1],[73,7,86,7],[73,13,86,13],[89,1,102,1],[89,7,102,7],[89,13,102,13]]}
[]
[]
[null,null,"LIQUIDACIÓN INTERESES MORATORIOS",{"$nulls":8},"Fecha Liquidación:",null,{"$f":"TODAY()","v":"2026-02-02"}]
[{"$nulls":13},"2023-07-01"]
[null,null,"Contribuyente (Razón Social)",{"$nulls":4},"NIT",{"$nulls":4},"Año","Días en Mora","Valor Intereses *"]
[]
[{"$nulls":9},{"$f":"N22","v":4},null,null,{"$f":"IF(N7=0,0,IFERROR(B26,0))","v":2025},{"$f":"IFERROR(F39,0)","v":4},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!G39,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":12},{"$f":"IF(N8=0,0,IFERROR(H26,0))","v":0},{"$f":"IFERROR(L39,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!M39,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":12},{"$f":"IF(N9=0,0,IFERROR(N26,0))","v":0},{"$f":"IFERROR(R39,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!S39,0),0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"DATOS DE ENTRADA","Valor Impuesto",{"v":9700927,"d":"$9,700,927"},{"$nulls":4},"DIAS EN MORA",null,null,{"$f":"IF(N10=0,0,IFERROR(B42,0))","v":0},{"$f":"IFERROR(F55,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!G55,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":12},{"$f":"IF(N11=0,0,IFERROR(H42,0))","v":0},{"$f":"IFERROR(L55,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!M55,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":9},{"$f":"IF(E16<N4,ROUND(O22*1000,-1),H22)","v":{"v":24470,"d":"$24,470"}},null,null,{"$f":"IF(N12=0,0,IFERROR(N42,0))","v":0},{"$f":"IFERROR(R55,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!S55,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Fecha Vencimiento","2025-12-15",{"$nulls":7},{"$f":"IF(N13=0,0,IFERROR(B58,0))","v":0},{"$f":"IFERROR(Liquidación!F71,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!G71,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":12},{"$f":"IF(N14=0,0,IFERROR(H58,0))","v":0},{"$f":"IFERROR(Liquidación!L71,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!M71,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":9},"VALOR INTERESES",null,null,{"$f":"IF(N15=0,0,IFERROR(N58,0))","v":0},{"$f":"IFERROR(Liquidación!R71,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!S71,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Fecha de Pago","2025-12-19",{"$nulls":7},{"$f":"IF(N16=0,0,IFERROR(B74,0))","v":0},{"$f":"IFERROR(Liquidación!F87,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!G87,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":9},{"$f":"E10+J12","v":{"v":9725397,"d":"$9,725,397"}},null,null,{"$f":"IF(N17=0,0,IFERROR(H74,0))","v":0},{"$f":"IFERROR(Liquidación!L87,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!M87,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":12},{"$f":"IF(N18=0,0,IFERROR(N74,0))","v":0},{"$f":"IFERROR(R87,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!S87,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":12},{"$f":"IF(N19=0,0,IFERROR(B90,0))","v":0},{"$f":"IFERROR(F103,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!G103,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":9},"TOTAL A PAGAR\nValor Impuesto + Intereses",null,null,{"$f":"IF(N20=0,0,IFERROR(H90,0))","v":0},{"$f":"IFERROR(L103,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!M103,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":12},{"$f":"IF(N21=0,0,IFERROR(N90,0))","v":0},{"$f":"IFERROR(R103,0)","v":0},{"$f":"IF($E$16<$N$4,IFERROR(Liquidación!S103,0),0)","v":{"v":0,"d":"$0.00"}}]
[null,{"$f":"YEAR(E16)","v":2025},{"$f":"MONTH(E16)","v":12},{"$f":"VLOOKUP(C22,'Tasas de Interes'!A2:B14,2,0)","v":"Dic"},{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($D22,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$22,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2302,"d":"23.020%"}},{"$f":"EOMONTH(DATE($B$22,VLOOKUP(D22,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-11-30"},{"$f":"N22","v":4},{"$f":"ROUND(($E$10*(E22/365)*G22),-1)","v":{"v":24470,"d":"24,470"}},{"$nulls":4},"Total",{"$f":"SUM(N7:N21)","v":4},{"$f":"SUM(O7:O21)","v":{"v":0,"d":"$0.00"}},null,"* Cifra en Miles de Pesos"]
[]
[null,null,"* Todos los Años: Valor Intereses en Miles de pesos"]
[null,{"$f":"IF(ISERROR(B26),\"E\",B26)","v":2025},{"$nulls":3},0,null,{"$f":"IF(ISERROR(H26),\"E\",H26)","v":"E"},{"$nulls":3},{"$f":"F25+F39","v":4},null,{"$f":"IF(ISERROR(N26),\"E\",N26)","v":"E"},{"$nulls":3},{"$f":"L25+L39","v":{"$error":"#N/A"}}]
[null,{"$f":"YEAR(E13)","v":2025},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *",{"$f":"IF(YEAR($E$16)<>$B$26,$B$26+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *",{"$f":"IF(YEAR($E$16)<>$H$26,$H$26+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *"]
[null,null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C27,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2289,"d":"22.89%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C28,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-01-31"},{"$f":"IF(E27<$E$13,0,IF(E27>$E$16,$E$16-$E$13-SUM($F$25:F26),E27-$E$13-SUM($F$25:F26)))","v":0},{"$f":"IF($E$16<$N$4,($E$10*(D27/366)*F27)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I27,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I28,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K27<$E$13,0,IF(K27>$E$16,$E$16-$E$13-SUM($L$25:L26),K27-$E$13-SUM($L$25:L26)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(J27/366)*L27)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O27,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O28,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q27<$E$13,0,IF(Q27>$E$16,$E$16-$E$13-SUM($R$25:R26),Q27-$E$13-SUM($R$25:R26)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(P27/366)*R27)/1000,0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C28,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.243,"d":"24.30%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C29,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-02-28"},{"$f":"IF(E28<$E$13,0,IF(E28>$E$16,$E$16-$E$13-SUM($F$25:F27),E28-$E$13-SUM($F$25:F27)))","v":0},{"$f":"IF($E$16<$N$4,($E$10*(D28/366)*F28)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I28,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I29,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K28<$E$13,0,IF(K28>$E$16,$E$16-$E$13-SUM($L$25:L27),K28-$E$13-SUM($L$25:L27)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(J28/366)*L28)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O28,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O29,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q28<$E$13,0,IF(Q28>$E$16,$E$16-$E$13-SUM($R$25:R27),Q28-$E$13-SUM($R$25:R27)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(P28/366)*R28)/1000,0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C29,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2292,"d":"22.92%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C30,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-03-31"},{"$f":"IF(E29<$E$13,0,IF(E29>$E$16,$E$16-$E$13-SUM($F$25:F28),E29-$E$13-SUM($F$25:F28)))","v":0},{"v":0,"d":"$0.00"},null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I29,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I30,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K29<$E$13,0,IF(K29>$E$16,$E$16-$E$13-SUM($L$25:L28),K29-$E$13-SUM($L$25:L28)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O29,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O30,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q29<$E$13,0,IF(Q29>$E$16,$E$16-$E$13-SUM($R$25:R28),Q29-$E$13-SUM($R$25:R28)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C30,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2362,"d":"23.62%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C31,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-04-30"},{"$f":"IF(E30<$E$13,0,IF(E30>$E$16,$E$16-$E$13-SUM($F$25:F29),E30-$E$13-SUM($F$25:F29)))","v":0},{"v":0,"d":"$0.00"},null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I30,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I31,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K30<$E$13,0,IF(K30>$E$16,$E$16-$E$13-SUM($L$25:L29),K30-$E$13-SUM($L$25:L29)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O30,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O31,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q30<$E$13,0,IF(Q30>$E$16,$E$16-$E$13-SUM($R$25:R29),Q30-$E$13-SUM($R$25:R29)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C31,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2397,"d":"23.97%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C32,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-05-31"},{"$f":"IF(E31<$E$13,0,IF(E31>$E$16,$E$16-$E$13-SUM($F$25:F30),E31-$E$13-SUM($F$25:F30)))","v":0},{"v":0,"d":"$0.00"},null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I31,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I32,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K31<$E$13,0,IF(K31>$E$16,$E$16-$E$13-SUM($L$25:L30),K31-$E$13-SUM($L$25:L30)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O31,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O32,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q31<$E$13,0,IF(Q31>$E$16,$E$16-$E$13-SUM($R$25:R30),Q31-$E$13-SUM($R$25:R30)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C32,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2355,"d":"23.55%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C33,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-06-30"},{"$f":"IF(E32<$E$13,0,IF(E32>$E$16,$E$16-$E$13-SUM($F$25:F31),E32-$E$13-SUM($F$25:F31)))","v":0},{"v":0,"d":"$0.00"},null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I32,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I33,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K32<$E$13,0,IF(K32>$E$16,$E$16-$E$13-SUM($L$25:L31),K32-$E$13-SUM($L$25:L31)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O32,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O33,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q32<$E$13,0,IF(Q32>$E$16,$E$16-$E$13-SUM($R$25:R31),Q32-$E$13-SUM($R$25:R31)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C33,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2278,"d":"22.78%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C34,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-07-31"},{"$f":"IF(E33<$E$13,0,IF(E33>$E$16,$E$16-$E$13-SUM($F$25:F32),E33-$E$13-SUM($F$25:F32)))","v":0},{"v":0,"d":"$0.00"},null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I33,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I34,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K33<$E$13,0,IF(K33>$E$16,$E$16-$E$13-SUM($L$25:L32),K33-$E$13-SUM($L$25:L32)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O33,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O34,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q33<$E$13,0,IF(Q33>$E$16,$E$16-$E$13-SUM($R$25:R32),Q33-$E$13-SUM($R$25:R32)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C34,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2317,"d":"23.17%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C35,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-08-31"},{"$f":"IF(E34<$E$13,0,IF(E34>$E$16,$E$16-$E$13-SUM($F$25:F33),E34-$E$13-SUM($F$25:F33)))","v":0},{"v":0,"d":"$0.00"},null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I34,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I35,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K34<$E$13,0,IF(K34>$E$16,$E$16-$E$13-SUM($L$25:L33),K34-$E$13-SUM($L$25:L33)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O34,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O35,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q34<$E$13,0,IF(Q34>$E$16,$E$16-$E$13-SUM($R$25:R33),Q34-$E$13-SUM($R$25:R33)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C35,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2301,"d":"23.01%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C36,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-09-30"},{"$f":"IF(E35<$E$13,0,IF(E35>$E$16,$E$16-$E$13-SUM($F$25:F34),E35-$E$13-SUM($F$25:F34)))","v":0},{"v":0,"d":"$0.00"},null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I35,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I36,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K35<$E$13,0,IF(K35>$E$16,$E$16-$E$13-SUM($L$25:L34),K35-$E$13-SUM($L$25:L34)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O35,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O36,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q35<$E$13,0,IF(Q35>$E$16,$E$16-$E$13-SUM($R$25:R34),Q35-$E$13-SUM($R$25:R34)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C36,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2236,"d":"22.36%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C37,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-10-31"},{"$f":"IF(E36<$E$13,0,IF(E36>$E$16,$E$16-$E$13-SUM($F$25:F35),E36-$E$13-SUM($F$25:F35)))","v":0},{"v":0,"d":"$0.00"},null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I36,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I37,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K36<$E$13,0,IF(K36>$E$16,$E$16-$E$13-SUM($L$25:L35),K36-$E$13-SUM($L$25:L35)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O36,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O37,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q36<$E$13,0,IF(Q36>$E$16,$E$16-$E$13-SUM($R$25:R35),Q36-$E$13-SUM($R$25:R35)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C37,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2299,"d":"22.99%"}},{"$f":"EOMONTH(DATE($B$26,VLOOKUP(C38,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-11-30"},{"$f":"IF(E37<$E$13,0,IF(E37>$E$16,$E$16-$E$13-SUM($F$25:F36),E37-$E$13-SUM($F$25:F36)))","v":0},{"v":0,"d":"$0.00"},null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I37,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26,VLOOKUP(I38,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K37<$E$13,0,IF(K37>$E$16,$E$16-$E$13-SUM($L$25:L36),K37-$E$13-SUM($L$25:L36)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O37,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26,VLOOKUP(O38,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q37<$E$13,0,IF(Q37>$E$16,$E$16-$E$13-SUM($R$25:R36),Q37-$E$13-SUM($R$25:R36)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C38,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"v":0.2302,"d":"23.02%"}},{"$f":"EOMONTH(DATE($B$26+1,VLOOKUP(C27,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":"2025-12-31"},{"$f":"IF(E38<$E$13,0,IF(E38>$E$16,$E$16-$E$13-SUM($F$25:F37),E38-$E$13-SUM($F$25:F37)))","v":4},{"v":0,"d":"$0.00"},null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I38,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$26+1,VLOOKUP(I27,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K38<$E$13,0,IF(K38>$E$16,$E$16-$E$13-SUM($L$25:L37),K38-$E$13-SUM($L$25:L37)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O38,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$26,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$26+1,VLOOKUP(O27,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q38<$E$13,0,IF(Q38>$E$16,$E$16-$E$13-SUM($R$25:R37),Q38-$E$13-SUM($R$25:R37)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"$f":"SUM(F27:F38)","v":4},{"$f":"SUM(G27:G38)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(L27:L38)","v":{"$error":"#N/A"}},{"$f":"SUM(M27:M38)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(R27:R38)","v":{"$error":"#N/A"}},{"$f":"SUM(S27:S38)","v":{"v":0,"d":"$0.00"}}]
[]
[null,{"$f":"IF(ISERROR(B42),\"E\",B42)","v":"E"},{"$nulls":3},{"$f":"R25+R39","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(H42),\"E\",H42)","v":"E"},{"$nulls":3},{"$f":"F41+F55","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(N42),\"E\",N42)","v":"E"},{"$nulls":3},{"$f":"L41+L55","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(YEAR($E$16)<>$N$26,$N$26+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *",{"$f":"IF(YEAR($E$16)<>$B$42,$B$42+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *",{"$f":"IF(YEAR($E$16)<>$H$42,$H$42+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *"]
[null,null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C43,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C44,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E43<$E$13,0,IF(E43>$E$16,$E$16-$E$13-SUM(F$41:$F42),E43-$E$13-SUM(F$41:$F42)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(D43/366)*F43)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I43,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I44,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K43<$E$13,0,IF(K43>$E$16,$E$16-$E$13-SUM($L$41:L42),K43-$E$13-SUM($L$41:L42)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(J43/366)*L43)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O43,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O44,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q43<$E$13,0,IF(Q43>$E$16,$E$16-$E$13-SUM($R$41:R42),Q43-$E$13-SUM($R$41:R42)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(P43/366)*R43)/1000,0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C44,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C45,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E44<$E$13,0,IF(E44>$E$16,$E$16-$E$13-SUM(F$41:$F43),E44-$E$13-SUM(F$41:$F43)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(D44/366)*F44)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I44,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I45,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K44<$E$13,0,IF(K44>$E$16,$E$16-$E$13-SUM($L$41:L43),K44-$E$13-SUM($L$41:L43)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(J44/366)*L44)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O44,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O45,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q44<$E$13,0,IF(Q44>$E$16,$E$16-$E$13-SUM($R$41:R43),Q44-$E$13-SUM($R$41:R43)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(P44/366)*R44)/1000,0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C45,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C46,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E45<$E$13,0,IF(E45>$E$16,$E$16-$E$13-SUM(F$41:$F44),E45-$E$13-SUM(F$41:$F44)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I45,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I46,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K45<$E$13,0,IF(K45>$E$16,$E$16-$E$13-SUM($L$41:L44),K45-$E$13-SUM($L$41:L44)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O45,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O46,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q45<$E$13,0,IF(Q45>$E$16,$E$16-$E$13-SUM($R$41:R44),Q45-$E$13-SUM($R$41:R44)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C46,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C47,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E46<$E$13,0,IF(E46>$E$16,$E$16-$E$13-SUM(F$41:$F45),E46-$E$13-SUM(F$41:$F45)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I46,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I47,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K46<$E$13,0,IF(K46>$E$16,$E$16-$E$13-SUM($L$41:L45),K46-$E$13-SUM($L$41:L45)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O46,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O47,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q46<$E$13,0,IF(Q46>$E$16,$E$16-$E$13-SUM($R$41:R45),Q46-$E$13-SUM($R$41:R45)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C47,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C48,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E47<$E$13,0,IF(E47>$E$16,$E$16-$E$13-SUM(F$41:$F46),E47-$E$13-SUM(F$41:$F46)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I47,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I48,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K47<$E$13,0,IF(K47>$E$16,$E$16-$E$13-SUM($L$41:L46),K47-$E$13-SUM($L$41:L46)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O47,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O48,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q47<$E$13,0,IF(Q47>$E$16,$E$16-$E$13-SUM($R$41:R46),Q47-$E$13-SUM($R$41:R46)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C48,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C49,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E48<$E$13,0,IF(E48>$E$16,$E$16-$E$13-SUM(F$41:$F47),E48-$E$13-SUM(F$41:$F47)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I48,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I49,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K48<$E$13,0,IF(K48>$E$16,$E$16-$E$13-SUM($L$41:L47),K48-$E$13-SUM($L$41:L47)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O48,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O49,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q48<$E$13,0,IF(Q48>$E$16,$E$16-$E$13-SUM($R$41:R47),Q48-$E$13-SUM($R$41:R47)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C49,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C50,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E49<$E$13,0,IF(E49>$E$16,$E$16-$E$13-SUM(F$41:$F48),E49-$E$13-SUM(F$41:$F48)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I49,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I50,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K49<$E$13,0,IF(K49>$E$16,$E$16-$E$13-SUM($L$41:L48),K49-$E$13-SUM($L$41:L48)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O49,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O50,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q49<$E$13,0,IF(Q49>$E$16,$E$16-$E$13-SUM($R$41:R48),Q49-$E$13-SUM($R$41:R48)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C50,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C51,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E50<$E$13,0,IF(E50>$E$16,$E$16-$E$13-SUM(F$41:$F49),E50-$E$13-SUM(F$41:$F49)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I50,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I51,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K50<$E$13,0,IF(K50>$E$16,$E$16-$E$13-SUM($L$41:L49),K50-$E$13-SUM($L$41:L49)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O50,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O51,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q50<$E$13,0,IF(Q50>$E$16,$E$16-$E$13-SUM($R$41:R49),Q50-$E$13-SUM($R$41:R49)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C51,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C52,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E51<$E$13,0,IF(E51>$E$16,$E$16-$E$13-SUM(F$41:$F50),E51-$E$13-SUM(F$41:$F50)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I51,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I52,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K51<$E$13,0,IF(K51>$E$16,$E$16-$E$13-SUM($L$41:L50),K51-$E$13-SUM($L$41:L50)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O51,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O52,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q51<$E$13,0,IF(Q51>$E$16,$E$16-$E$13-SUM($R$41:R50),Q51-$E$13-SUM($R$41:R50)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C52,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C53,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E52<$E$13,0,IF(E52>$E$16,$E$16-$E$13-SUM(F$41:$F51),E52-$E$13-SUM(F$41:$F51)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I52,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I53,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K52<$E$13,0,IF(K52>$E$16,$E$16-$E$13-SUM($L$41:L51),K52-$E$13-SUM($L$41:L51)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O52,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O53,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q52<$E$13,0,IF(Q52>$E$16,$E$16-$E$13-SUM($R$41:R51),Q52-$E$13-SUM($R$41:R51)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C53,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42,VLOOKUP(C54,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E53<$E$13,0,IF(E53>$E$16,$E$16-$E$13-SUM(F$41:$F52),E53-$E$13-SUM(F$41:$F52)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I53,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42,VLOOKUP(I54,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K53<$E$13,0,IF(K53>$E$16,$E$16-$E$13-SUM($L$41:L52),K53-$E$13-SUM($L$41:L52)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O53,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42,VLOOKUP(O54,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q53<$E$13,0,IF(Q53>$E$16,$E$16-$E$13-SUM($R$41:R52),Q53-$E$13-SUM($R$41:R52)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C54,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$42+1,VLOOKUP(C43,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E54<$E$13,0,IF(E54>$E$16,$E$16-$E$13-SUM(F$41:$F53),E54-$E$13-SUM(F$41:$F53)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I54,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$42+1,VLOOKUP(I43,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K54<$E$13,0,IF(K54>$E$16,$E$16-$E$13-SUM($L$41:L53),K54-$E$13-SUM($L$41:L53)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O54,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$42,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$42+1,VLOOKUP(O43,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q54<$E$13,0,IF(Q54>$E$16,$E$16-$E$13-SUM($R$41:R53),Q54-$E$13-SUM($R$41:R53)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"$f":"SUM(F43:F54)","v":{"$error":"#N/A"}},{"$f":"SUM(G43:G54)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(L43:L54)","v":{"$error":"#N/A"}},{"$f":"SUM(M43:M54)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(R43:R54)","v":{"$error":"#N/A"}},{"$f":"SUM(S43:S54)","v":{"v":0,"d":"$0.00"}}]
[]
[null,{"$f":"IF(ISERROR(B58),\"E\",B58)","v":"E"},{"$nulls":3},{"$f":"R41+R55","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(H58),\"E\",H58)","v":"E"},{"$nulls":3},{"$f":"F57+F71","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(N58),\"E\",N58)","v":"E"},{"$nulls":3},{"$f":"L57+L71","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(YEAR($E$16)<>$N$42,$N$42+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *",{"$f":"IF(YEAR($E$16)<>$B$58,$B$58+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *",{"$f":"IF(YEAR($E$16)<>$H$58,$H$58+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *"]
[null,null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C59,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C60,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E59<$E$13,0,IF(E59>$E$16,$E$16-$E$13-SUM(F$57:$F58),E59-$E$13-SUM(F$57:$F58)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(D59/366)*F59)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I59,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I60,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K59<$E$13,0,IF(K59>$E$16,$E$16-$E$13-SUM($L$57:L58),K59-$E$13-SUM($L$57:L58)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(J59/366)*L59)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O59,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O60,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q59<$E$13,0,IF(Q59>$E$16,$E$16-$E$13-SUM($R$57:R58),Q59-$E$13-SUM($R$57:R58)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(P59/366)*R59)/1000,0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C60,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C61,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E60<$E$13,0,IF(E60>$E$16,$E$16-$E$13-SUM(F$57:$F59),E60-$E$13-SUM(F$57:$F59)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(D60/366)*F60)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I60,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I61,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K60<$E$13,0,IF(K60>$E$16,$E$16-$E$13-SUM($L$57:L59),K60-$E$13-SUM($L$57:L59)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(J60/366)*L60)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O60,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O61,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q60<$E$13,0,IF(Q60>$E$16,$E$16-$E$13-SUM($R$57:R59),Q60-$E$13-SUM($R$57:R59)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(P60/366)*R60)/1000,0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C61,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C62,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E61<$E$13,0,IF(E61>$E$16,$E$16-$E$13-SUM(F$57:$F60),E61-$E$13-SUM(F$57:$F60)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I61,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I62,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K61<$E$13,0,IF(K61>$E$16,$E$16-$E$13-SUM($L$57:L60),K61-$E$13-SUM($L$57:L60)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O61,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O62,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q61<$E$13,0,IF(Q61>$E$16,$E$16-$E$13-SUM($R$57:R60),Q61-$E$13-SUM($R$57:R60)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C62,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C63,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E62<$E$13,0,IF(E62>$E$16,$E$16-$E$13-SUM(F$57:$F61),E62-$E$13-SUM(F$57:$F61)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I62,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I63,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K62<$E$13,0,IF(K62>$E$16,$E$16-$E$13-SUM($L$57:L61),K62-$E$13-SUM($L$57:L61)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O62,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O63,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q62<$E$13,0,IF(Q62>$E$16,$E$16-$E$13-SUM($R$57:R61),Q62-$E$13-SUM($R$57:R61)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C63,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C64,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E63<$E$13,0,IF(E63>$E$16,$E$16-$E$13-SUM(F$57:$F62),E63-$E$13-SUM(F$57:$F62)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I63,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I64,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K63<$E$13,0,IF(K63>$E$16,$E$16-$E$13-SUM($L$57:L62),K63-$E$13-SUM($L$57:L62)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O63,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O64,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q63<$E$13,0,IF(Q63>$E$16,$E$16-$E$13-SUM($R$57:R62),Q63-$E$13-SUM($R$57:R62)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C64,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C65,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E64<$E$13,0,IF(E64>$E$16,$E$16-$E$13-SUM(F$57:$F63),E64-$E$13-SUM(F$57:$F63)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I64,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I65,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K64<$E$13,0,IF(K64>$E$16,$E$16-$E$13-SUM($L$57:L63),K64-$E$13-SUM($L$57:L63)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O64,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O65,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q64<$E$13,0,IF(Q64>$E$16,$E$16-$E$13-SUM($R$57:R63),Q64-$E$13-SUM($R$57:R63)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C65,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C66,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E65<$E$13,0,IF(E65>$E$16,$E$16-$E$13-SUM(F$57:$F64),E65-$E$13-SUM(F$57:$F64)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I65,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I66,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K65<$E$13,0,IF(K65>$E$16,$E$16-$E$13-SUM($L$57:L64),K65-$E$13-SUM($L$57:L64)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O65,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O66,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q65<$E$13,0,IF(Q65>$E$16,$E$16-$E$13-SUM($R$57:R64),Q65-$E$13-SUM($R$57:R64)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C66,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C67,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E66<$E$13,0,IF(E66>$E$16,$E$16-$E$13-SUM(F$57:$F65),E66-$E$13-SUM(F$57:$F65)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I66,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I67,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K66<$E$13,0,IF(K66>$E$16,$E$16-$E$13-SUM($L$57:L65),K66-$E$13-SUM($L$57:L65)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O66,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O67,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q66<$E$13,0,IF(Q66>$E$16,$E$16-$E$13-SUM($R$57:R65),Q66-$E$13-SUM($R$57:R65)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C67,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C68,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E67<$E$13,0,IF(E67>$E$16,$E$16-$E$13-SUM(F$57:$F66),E67-$E$13-SUM(F$57:$F66)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I67,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I68,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K67<$E$13,0,IF(K67>$E$16,$E$16-$E$13-SUM($L$57:L66),K67-$E$13-SUM($L$57:L66)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O67,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O68,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q67<$E$13,0,IF(Q67>$E$16,$E$16-$E$13-SUM($R$57:R66),Q67-$E$13-SUM($R$57:R66)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C68,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C69,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E68<$E$13,0,IF(E68>$E$16,$E$16-$E$13-SUM(F$57:$F67),E68-$E$13-SUM(F$57:$F67)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I68,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I69,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K68<$E$13,0,IF(K68>$E$16,$E$16-$E$13-SUM($L$57:L67),K68-$E$13-SUM($L$57:L67)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O68,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O69,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q68<$E$13,0,IF(Q68>$E$16,$E$16-$E$13-SUM($R$57:R67),Q68-$E$13-SUM($R$57:R67)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C69,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58,VLOOKUP(C70,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E69<$E$13,0,IF(E69>$E$16,$E$16-$E$13-SUM(F$57:$F68),E69-$E$13-SUM(F$57:$F68)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I69,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58,VLOOKUP(I70,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K69<$E$13,0,IF(K69>$E$16,$E$16-$E$13-SUM($L$57:L68),K69-$E$13-SUM($L$57:L68)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O69,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58,VLOOKUP(O70,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q69<$E$13,0,IF(Q69>$E$16,$E$16-$E$13-SUM($R$57:R68),Q69-$E$13-SUM($R$57:R68)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C70,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$58+1,VLOOKUP(C59,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E70<$E$13,0,IF(E70>$E$16,$E$16-$E$13-SUM(F$57:$F69),E70-$E$13-SUM(F$57:$F69)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I70,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$58+1,VLOOKUP(I59,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K70<$E$13,0,IF(K70>$E$16,$E$16-$E$13-SUM($L$57:L69),K70-$E$13-SUM($L$57:L69)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O70,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$58,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$58+1,VLOOKUP(O59,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q70<$E$13,0,IF(Q70>$E$16,$E$16-$E$13-SUM($R$57:R69),Q70-$E$13-SUM($R$57:R69)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"$f":"SUM(F59:F70)","v":{"$error":"#N/A"}},{"$f":"SUM(G59:G70)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(L59:L70)","v":{"$error":"#N/A"}},{"$f":"SUM(M59:M70)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(R59:R70)","v":{"$error":"#N/A"}},{"$f":"SUM(S59:S70)","v":{"v":0,"d":"$0.00"}}]
[]
[null,{"$f":"IF(ISERROR(B74),\"E\",B74)","v":"E"},{"$nulls":3},{"$f":"R57+R71","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(H74),\"E\",H74)","v":"E"},{"$nulls":3},{"$f":"F73+F87","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(N74),\"E\",N74)","v":"E"},{"$nulls":3},{"$f":"L73+L87","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(YEAR($E$16)<>$N$58,$N$58+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *",{"$f":"IF(YEAR($E$16)<>$B$74,$B$74+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *",{"$f":"IF(YEAR($E$16)<>$H$74,$H$74+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *"]
[null,null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C75,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C76,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E75<$E$13,0,IF(E75>$E$16,$E$16-$E$13-SUM(F$73:$F74),E75-$E$13-SUM(F$73:$F74)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(D75/366)*F75)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I75,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I76,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K75<$E$13,0,IF(K75>$E$16,$E$16-$E$13-SUM($L$73:L74),K75-$E$13-SUM($L$73:L74)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(J75/366)*L75)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O75,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O76,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q75<$E$13,0,IF(Q75>$E$16,$E$16-$E$13-SUM($R$73:R74),Q75-$E$13-SUM($R$73:R74)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(P75/366)*R75)/1000,0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C76,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C77,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E76<$E$13,0,IF(E76>$E$16,$E$16-$E$13-SUM(F$73:$F75),E76-$E$13-SUM(F$73:$F75)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(D76/366)*F76)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I76,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I77,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K76<$E$13,0,IF(K76>$E$16,$E$16-$E$13-SUM($L$73:L75),K76-$E$13-SUM($L$73:L75)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(J76/366)*L76)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O76,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O77,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q76<$E$13,0,IF(Q76>$E$16,$E$16-$E$13-SUM($R$73:R75),Q76-$E$13-SUM($R$73:R75)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(P76/366)*R76)/1000,0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C77,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C78,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E77<$E$13,0,IF(E77>$E$16,$E$16-$E$13-SUM(F$73:$F76),E77-$E$13-SUM(F$73:$F76)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I77,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I78,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K77<$E$13,0,IF(K77>$E$16,$E$16-$E$13-SUM($L$73:L76),K77-$E$13-SUM($L$73:L76)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O77,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O78,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q77<$E$13,0,IF(Q77>$E$16,$E$16-$E$13-SUM($R$73:R76),Q77-$E$13-SUM($R$73:R76)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C78,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C79,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E78<$E$13,0,IF(E78>$E$16,$E$16-$E$13-SUM(F$73:$F77),E78-$E$13-SUM(F$73:$F77)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I78,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I79,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K78<$E$13,0,IF(K78>$E$16,$E$16-$E$13-SUM($L$73:L77),K78-$E$13-SUM($L$73:L77)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O78,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O79,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q78<$E$13,0,IF(Q78>$E$16,$E$16-$E$13-SUM($R$73:R77),Q78-$E$13-SUM($R$73:R77)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C79,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C80,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E79<$E$13,0,IF(E79>$E$16,$E$16-$E$13-SUM(F$73:$F78),E79-$E$13-SUM(F$73:$F78)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I79,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I80,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K79<$E$13,0,IF(K79>$E$16,$E$16-$E$13-SUM($L$73:L78),K79-$E$13-SUM($L$73:L78)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O79,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O80,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q79<$E$13,0,IF(Q79>$E$16,$E$16-$E$13-SUM($R$73:R78),Q79-$E$13-SUM($R$73:R78)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C80,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C81,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E80<$E$13,0,IF(E80>$E$16,$E$16-$E$13-SUM(F$73:$F79),E80-$E$13-SUM(F$73:$F79)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I80,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I81,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K80<$E$13,0,IF(K80>$E$16,$E$16-$E$13-SUM($L$73:L79),K80-$E$13-SUM($L$73:L79)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O80,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O81,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q80<$E$13,0,IF(Q80>$E$16,$E$16-$E$13-SUM($R$73:R79),Q80-$E$13-SUM($R$73:R79)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C81,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C82,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E81<$E$13,0,IF(E81>$E$16,$E$16-$E$13-SUM(F$73:$F80),E81-$E$13-SUM(F$73:$F80)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I81,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I82,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K81<$E$13,0,IF(K81>$E$16,$E$16-$E$13-SUM($L$73:L80),K81-$E$13-SUM($L$73:L80)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O81,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O82,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q81<$E$13,0,IF(Q81>$E$16,$E$16-$E$13-SUM($R$73:R80),Q81-$E$13-SUM($R$73:R80)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C82,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C83,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E82<$E$13,0,IF(E82>$E$16,$E$16-$E$13-SUM(F$73:$F81),E82-$E$13-SUM(F$73:$F81)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I82,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I83,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K82<$E$13,0,IF(K82>$E$16,$E$16-$E$13-SUM($L$73:L81),K82-$E$13-SUM($L$73:L81)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O82,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O83,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q82<$E$13,0,IF(Q82>$E$16,$E$16-$E$13-SUM($R$73:R81),Q82-$E$13-SUM($R$73:R81)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C83,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C84,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E83<$E$13,0,IF(E83>$E$16,$E$16-$E$13-SUM(F$73:$F82),E83-$E$13-SUM(F$73:$F82)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I83,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I84,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K83<$E$13,0,IF(K83>$E$16,$E$16-$E$13-SUM($L$73:L82),K83-$E$13-SUM($L$73:L82)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O83,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O84,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q83<$E$13,0,IF(Q83>$E$16,$E$16-$E$13-SUM($R$73:R82),Q83-$E$13-SUM($R$73:R82)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C84,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C85,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E84<$E$13,0,IF(E84>$E$16,$E$16-$E$13-SUM(F$73:$F83),E84-$E$13-SUM(F$73:$F83)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I84,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I85,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K84<$E$13,0,IF(K84>$E$16,$E$16-$E$13-SUM($L$73:L83),K84-$E$13-SUM($L$73:L83)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O84,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O85,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q84<$E$13,0,IF(Q84>$E$16,$E$16-$E$13-SUM($R$73:R83),Q84-$E$13-SUM($R$73:R83)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C85,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74,VLOOKUP(C86,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E85<$E$13,0,IF(E85>$E$16,$E$16-$E$13-SUM(F$73:$F84),E85-$E$13-SUM(F$73:$F84)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I85,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74,VLOOKUP(I86,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K85<$E$13,0,IF(K85>$E$16,$E$16-$E$13-SUM($L$73:L84),K85-$E$13-SUM($L$73:L84)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O85,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74,VLOOKUP(O86,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q85<$E$13,0,IF(Q85>$E$16,$E$16-$E$13-SUM($R$73:R84),Q85-$E$13-SUM($R$73:R84)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C86,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$74+1,VLOOKUP(C75,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E86<$E$13,0,IF(E86>$E$16,$E$16-$E$13-SUM(F$73:$F85),E86-$E$13-SUM(F$73:$F85)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I86,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$74+1,VLOOKUP(I75,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K86<$E$13,0,IF(K86>$E$16,$E$16-$E$13-SUM($L$73:L85),K86-$E$13-SUM($L$73:L85)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O86,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$74,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$74+1,VLOOKUP(O75,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q86<$E$13,0,IF(Q86>$E$16,$E$16-$E$13-SUM($R$73:R85),Q86-$E$13-SUM($R$73:R85)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"$f":"SUM(F75:F86)","v":{"$error":"#N/A"}},{"$f":"SUM(G75:G86)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(L75:L86)","v":{"$error":"#N/A"}},{"$f":"SUM(M75:M86)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(R75:R86)","v":{"$error":"#N/A"}},{"$f":"SUM(S75:S86)","v":{"v":0,"d":"$0.00"}}]
[]
[null,{"$f":"IF(ISERROR(B90),\"E\",B90)","v":"E"},{"$nulls":3},{"$f":"R73+R87","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(H90),\"E\",H90)","v":"E"},{"$nulls":3},{"$f":"F89+F103","v":{"$error":"#N/A"}},null,{"$f":"IF(ISERROR(N90),\"E\",N90)","v":"E"},{"$nulls":3},{"$f":"L89+L103","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(YEAR($E$16)<>$N$74,$N$74+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *",{"$f":"IF(YEAR($E$16)<>$B$90,$B$90+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *",{"$f":"IF(YEAR($E$16)<>$H$90,$H$90+1,NA())","v":{"$error":"#N/A"}},"Mes","Tasa","Fecha Fin Mes","Dias Mora","Valor Intereses *"]
[null,null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C91,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C92,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E91<$E$13,0,IF(E91>$E$16,$E$16-$E$13-SUM(F$89:$F90),E91-$E$13-SUM(F$89:$F90)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(D91/366)*F91)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I91,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I92,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K91<$E$13,0,IF(K91>$E$16,$E$16-$E$13-SUM($L$89:L90),K91-$E$13-SUM($L$89:L90)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(J91/366)*L91)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Ene",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O91,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O92,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q91<$E$13,0,IF(Q91>$E$16,$E$16-$E$13-SUM($R$89:R90),Q91-$E$13-SUM($R$89:R90)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(P91/366)*R91)/1000,0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C92,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C93,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E92<$E$13,0,IF(E92>$E$16,$E$16-$E$13-SUM(F$89:$F91),E92-$E$13-SUM(F$89:$F91)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(D92/366)*F92)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I92,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I93,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K92<$E$13,0,IF(K92>$E$16,$E$16-$E$13-SUM($L$89:L91),K92-$E$13-SUM($L$89:L91)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(J92/366)*L92)/1000,0)","v":{"v":0,"d":"$0.00"}},null,"Feb",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O92,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O93,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q92<$E$13,0,IF(Q92>$E$16,$E$16-$E$13-SUM($R$89:R91),Q92-$E$13-SUM($R$89:R91)))","v":{"$error":"#N/A"}},{"$f":"IF($E$16<$N$4,($E$10*(P92/366)*R92)/1000,0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C93,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C94,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E93<$E$13,0,IF(E93>$E$16,$E$16-$E$13-SUM(F$89:$F92),E93-$E$13-SUM(F$89:$F92)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I93,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I94,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K93<$E$13,0,IF(K93>$E$16,$E$16-$E$13-SUM($L$89:L92),K93-$E$13-SUM($L$89:L92)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Mar",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O93,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O94,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q93<$E$13,0,IF(Q93>$E$16,$E$16-$E$13-SUM($R$89:R92),Q93-$E$13-SUM($R$89:R92)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C94,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C95,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E94<$E$13,0,IF(E94>$E$16,$E$16-$E$13-SUM(F$89:$F93),E94-$E$13-SUM(F$89:$F93)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I94,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I95,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K94<$E$13,0,IF(K94>$E$16,$E$16-$E$13-SUM($L$89:L93),K94-$E$13-SUM($L$89:L93)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Abr",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O94,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O95,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q94<$E$13,0,IF(Q94>$E$16,$E$16-$E$13-SUM($R$89:R93),Q94-$E$13-SUM($R$89:R93)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C95,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C96,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E95<$E$13,0,IF(E95>$E$16,$E$16-$E$13-SUM(F$89:$F94),E95-$E$13-SUM(F$89:$F94)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I95,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I96,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K95<$E$13,0,IF(K95>$E$16,$E$16-$E$13-SUM($L$89:L94),K95-$E$13-SUM($L$89:L94)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"May",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O95,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O96,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q95<$E$13,0,IF(Q95>$E$16,$E$16-$E$13-SUM($R$89:R94),Q95-$E$13-SUM($R$89:R94)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C96,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C97,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E96<$E$13,0,IF(E96>$E$16,$E$16-$E$13-SUM(F$89:$F95),E96-$E$13-SUM(F$89:$F95)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I96,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I97,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K96<$E$13,0,IF(K96>$E$16,$E$16-$E$13-SUM($L$89:L95),K96-$E$13-SUM($L$89:L95)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jun",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O96,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O97,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q96<$E$13,0,IF(Q96>$E$16,$E$16-$E$13-SUM($R$89:R95),Q96-$E$13-SUM($R$89:R95)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C97,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C98,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E97<$E$13,0,IF(E97>$E$16,$E$16-$E$13-SUM(F$89:$F96),E97-$E$13-SUM(F$89:$F96)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I97,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I98,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K97<$E$13,0,IF(K97>$E$16,$E$16-$E$13-SUM($L$89:L96),K97-$E$13-SUM($L$89:L96)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Jul",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O97,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O98,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q97<$E$13,0,IF(Q97>$E$16,$E$16-$E$13-SUM($R$89:R96),Q97-$E$13-SUM($R$89:R96)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C98,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C99,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E98<$E$13,0,IF(E98>$E$16,$E$16-$E$13-SUM(F$89:$F97),E98-$E$13-SUM(F$89:$F97)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I98,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I99,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K98<$E$13,0,IF(K98>$E$16,$E$16-$E$13-SUM($L$89:L97),K98-$E$13-SUM($L$89:L97)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Ago",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O98,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O99,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q98<$E$13,0,IF(Q98>$E$16,$E$16-$E$13-SUM($R$89:R97),Q98-$E$13-SUM($R$89:R97)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C99,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C100,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E99<$E$13,0,IF(E99>$E$16,$E$16-$E$13-SUM(F$89:$F98),E99-$E$13-SUM(F$89:$F98)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I99,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I100,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K99<$E$13,0,IF(K99>$E$16,$E$16-$E$13-SUM($L$89:L98),K99-$E$13-SUM($L$89:L98)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Sep",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O99,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O100,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q99<$E$13,0,IF(Q99>$E$16,$E$16-$E$13-SUM($R$89:R98),Q99-$E$13-SUM($R$89:R98)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C100,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C101,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E100<$E$13,0,IF(E100>$E$16,$E$16-$E$13-SUM(F$89:$F99),E100-$E$13-SUM(F$89:$F99)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I100,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I101,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K100<$E$13,0,IF(K100>$E$16,$E$16-$E$13-SUM($L$89:L99),K100-$E$13-SUM($L$89:L99)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Oct",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O100,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O101,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q100<$E$13,0,IF(Q100>$E$16,$E$16-$E$13-SUM($R$89:R99),Q100-$E$13-SUM($R$89:R99)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C101,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90,VLOOKUP(C102,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E101<$E$13,0,IF(E101>$E$16,$E$16-$E$13-SUM(F$89:$F100),E101-$E$13-SUM(F$89:$F100)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I101,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90,VLOOKUP(I102,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K101<$E$13,0,IF(K101>$E$16,$E$16-$E$13-SUM($L$89:L100),K101-$E$13-SUM($L$89:L100)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Nov",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O101,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90,VLOOKUP(O102,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q101<$E$13,0,IF(Q101>$E$16,$E$16-$E$13-SUM($R$89:R100),Q101-$E$13-SUM($R$89:R100)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[null,null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($C102,'Tasas de Interes'!$B$3:$B$14,0),MATCH($B$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($B$90+1,VLOOKUP(C91,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(E102<$E$13,0,IF(E102>$E$16,$E$16-$E$13-SUM(F$89:$F101),E102-$E$13-SUM(F$89:$F101)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($I102,'Tasas de Interes'!$B$3:$B$14,0),MATCH($H$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($H$90+1,VLOOKUP(I91,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(K102<$E$13,0,IF(K102>$E$16,$E$16-$E$13-SUM($L$89:L101),K102-$E$13-SUM($L$89:L101)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"},null,"Dic",{"$f":"INDEX('Tasas de Interes'!$D$3:$BB$14,MATCH($O102,'Tasas de Interes'!$B$3:$B$14,0),MATCH($N$90,'Tasas de Interes'!$D$2:$BB$2,0))","v":{"$error":"#N/A"}},{"$f":"EOMONTH(DATE($N$90+1,VLOOKUP(O91,'Tasas de Interes'!$B$3:$C$14,2,0),0),0)","v":{"$error":"#N/A"}},{"$f":"IF(Q102<$E$13,0,IF(Q102>$E$16,$E$16-$E$13-SUM($R$89:R101),Q102-$E$13-SUM($R$89:R101)))","v":{"$error":"#N/A"}},{"v":0,"d":"$0.00"}]
[{"$nulls":5},{"$f":"SUM(F91:F102)","v":{"$error":"#N/A"}},{"$f":"SUM(G91:G102)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(L91:L102)","v":{"$error":"#N/A"}},{"$f":"SUM(M91:M102)","v":{"v":0,"d":"$0.00"}},{"$nulls":4},{"$f":"SUM(R91:R102)","v":{"$error":"#N/A"}},{"$f":"SUM(S91:S102)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Tasas de Interes","index":1,"n_rows":49,"n_cols":54,"rows_kept":49,"merged":[[49,1,49,2]]}
[]
["NM","MES","Nro Mes",2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056]
[1,"Ene",1,{"v":0.2063,"d":"20.630%"},{"v":0.20745000000000002,"d":"20.745%"},{"v":0.3275,"d":"32.750%"},{"v":0.3071,"d":"30.710%"},{"v":0.2421,"d":"24.210%"},{"v":0.2342,"d":"23.420%"},{"v":0.2988,"d":"29.880%"},{"v":0.3113,"d":"31.130%"},{"v":0.2948,"d":"29.480%"},{"v":0.2882,"d":"28.820%"},{"v":0.2952,"d":"29.520%"},{"v":0.3151,"d":"31.510%"},{"v":0.2904,"d":"29.040%"},{"v":0.26739999999999997,"d":"26.740%"},{"v":0.2616,"d":"26.160%"},{"v":0.2398,"d":"23.980%"},{"v":0.2449,"d":"24.490%"},{"v":0.4126,"d":"41.260%"},{"v":0.3298,"d":"32.980%"},{"v":0.2289,"d":"22.890%"},{"v":0.2236,"d":"22.360%"}]
[2,"Feb",2,{"v":0.2063,"d":"20.630%"},{"v":0.20745000000000002,"d":"20.745%"},{"v":0.3275,"d":"32.750%"},{"v":0.3071,"d":"30.710%"},{"v":0.2421,"d":"24.210%"},{"v":0.2342,"d":"23.420%"},{"v":0.2988,"d":"29.880%"},{"v":0.3113,"d":"31.130%"},{"v":0.2948,"d":"29.480%"},{"v":0.2882,"d":"28.820%"},{"v":0.2952,"d":"29.520%"},{"v":0.3151,"d":"31.510%"},{"v":0.29519999999999996,"d":"29.520%"},{"v":0.27549999999999997,"d":"27.550%"},{"v":0.26589999999999997,"d":"26.590%"},{"v":0.2431,"d":"24.310%"},{"v":0.2545,"d":"25.450%"},{"v":0.4327,"d":"43.270%"},{"v":0.3297,"d":"32.970%"},{"v":0.243,"d":"24.300%"},{"v":0.2323,"d":"23.230%"}]
[3,"Mar",3,{"v":0.2063,"d":"20.630%"},{"v":0.20745000000000002,"d":"20.745%"},{"v":0.3275,"d":"32.750%"},{"v":0.3071,"d":"30.710%"},{"v":0.2421,"d":"24.210%"},{"v":0.2342,"d":"23.420%"},{"v":0.2988,"d":"29.880%"},{"v":0.3113,"d":"31.130%"},{"v":0.2948,"d":"29.480%"},{"v":0.2882,"d":"28.820%"},{"v":0.2952,"d":"29.520%"},{"v":0.3151,"d":"31.510%"},{"v":0.29019999999999996,"d":"29.020%"},{"v":0.27059999999999995,"d":"27.060%"},{"v":0.2643,"d":"26.430%"},{"v":0.2412,"d":"24.120%"},{"v":0.2571,"d":"25.710%"},{"v":0.4426,"d":"44.260%"},{"v":0.313,"d":"31.300%"},{"v":0.2292,"d":"22.920%"}]
[4,"Abr",4,{"v":0.2063,"d":"20.630%"},{"v":0.25120000000000003,"d":"25.120%"},{"v":0.3288,"d":"32.880%"},{"v":0.3042,"d":"30.420%"},{"v":0.2297,"d":"22.970%"},{"v":0.2654,"d":"26.540%"},{"v":0.3078,"d":"30.780%"},{"v":0.3125,"d":"31.250%"},{"v":0.2945,"d":"29.450%"},{"v":0.2906,"d":"29.060%"},{"v":0.3081,"d":"30.810%"},{"v":0.315,"d":"31.500%"},{"v":0.28719999999999996,"d":"28.720%"},{"v":0.2698,"d":"26.980%"},{"v":0.26039999999999996,"d":"26.040%"},{"v":0.2397,"d":"23.970%"},{"v":0.2658,"d":"26.580%"},{"v":0.4509,"d":"45.090%"},{"v":0.3109,"d":"31.090%"},{"v":0.2362,"d":"23.620%"}]
[5,"May",5,{"v":0.2063,"d":"20.630%"},{"v":0.25120000000000003,"d":"25.120%"},{"v":0.3288,"d":"32.880%"},{"v":0.3042,"d":"30.420%"},{"v":0.2297,"d":"22.970%"},{"v":0.2654,"d":"26.540%"},{"v":0.3078,"d":"30.780%"},{"v":0.3125,"d":"31.250%"},{"v":0.2945,"d":"29.450%"},{"v":0.2906,"d":"29.060%"},{"v":0.3081,"d":"30.810%"},{"v":0.315,"d":"31.500%"},{"v":0.28659999999999997,"d":"28.660%"},{"v":0.2701,"d":"27.010%"},{"v":0.25289999999999996,"d":"25.290%"},{"v":0.2383,"d":"23.830%"},{"v":0.2757,"d":"27.570%"},{"v":0.4341,"d":"43.410%"},{"v":0.2953,"d":"29.530%"},{"v":0.2397,"d":"23.970%"}]
[6,"Jun",6,{"v":0.2063,"d":"20.630%"},{"v":0.25120000000000003,"d":"25.120%"},{"v":0.3288,"d":"32.880%"},{"v":0.3042,"d":"30.420%"},{"v":0.2297,"d":"22.970%"},{"v":0.2654,"d":"26.540%"},{"v":0.3078,"d":"30.780%"},{"v":0.3125,"d":"31.250%"},{"v":0.2945,"d":"29.450%"},{"v":0.2906,"d":"29.060%"},{"v":0.3081,"d":"30.810%"},{"v":0.315,"d":"31.500%"},{"v":0.2842,"d":"28.420%"},{"v":0.26949999999999996,"d":"26.950%"},{"v":0.1812,"d":"18.120%"},{"v":0.2382,"d":"23.820%"},{"v":0.286,"d":"28.600%"},{"v":0.4264,"d":"42.640%"},{"v":0.2884,"d":"28.840%"},{"v":0.2355,"d":"23.550%"}]
[7,"Jul",7,{"v":0.2262,"d":"22.620%"},{"v":0.2851,"d":"28.510%"},{"v":0.3227,"d":"32.270%"},{"v":0.2798,"d":"27.980%"},{"v":0.2241,"d":"22.410%"},{"v":0.2795,"d":"27.950%"},{"v":0.3129,"d":"31.290%"},{"v":0.3051,"d":"30.510%"},{"v":0.29,"d":"29.000%"},{"v":0.2889,"d":"28.890%"},{"v":0.3201,"d":"32.010%"},{"v":0.3097,"d":"30.970%"},{"v":0.28049999999999997,"d":"28.050%"},{"v":0.2692,"d":"26.920%"},{"v":0.1812,"d":"18.120%"},{"v":0.2377,"d":"23.770%"},{"v":0.2992,"d":"29.920%"},{"v":0.4204,"d":"42.040%"},{"v":0.2749,"d":"27.490%"},{"v":0.2278,"d":"22.780%"}]
[8,"Ago",8,{"v":0.2253,"d":"22.530%"},{"v":0.2851,"d":"28.510%"},{"v":0.3227,"d":"32.270%"},{"v":0.2798,"d":"27.980%"},{"v":0.2241,"d":"22.410%"},{"v":0.2795,"d":"27.950%"},{"v":0.3129,"d":"31.290%"},{"v":0.3051,"d":"30.510%"},{"v":0.29,"d":"29.000%"},{"v":0.2889,"d":"28.890%"},{"v":0.3201,"d":"32.010%"},{"v":0.3097,"d":"30.970%"},{"v":0.27909999999999996,"d":"27.910%"},{"v":0.2698,"d":"26.980%"},{"v":0.1829,"d":"18.290%"},{"v":0.2386,"d":"23.860%"},{"v":0.3132,"d":"31.320%"},{"v":0.4113,"d":"41.130%"},{"v":0.2721,"d":"27.210%"},{"v":0.2317,"d":"23.170%"}]
[9,"Sep",9,{"v":0.22575,"d":"22.575%"},{"v":0.2851,"d":"28.510%"},{"v":0.3227,"d":"32.270%"},{"v":0.2798,"d":"27.980%"},{"v":0.2241,"d":"22.410%"},{"v":0.2795,"d":"27.950%"},{"v":0.3129,"d":"31.290%"},{"v":0.3051,"d":"30.510%"},{"v":0.29,"d":"29.000%"},{"v":0.2889,"d":"28.890%"},{"v":0.3201,"d":"32.010%"},{"v":0.3022,"d":"30.220%"},{"v":0.27719999999999995,"d":"27.720%"},{"v":0.2698,"d":"26.980%"},{"v":0.1835,"d":"18.350%"},{"v":0.2379,"d":"23.790%"},{"v":0.3325,"d":"33.250%"},{"v":0.4005,"d":"40.050%"},{"v":0.2685,"d":"26.850%"},{"v":0.2301,"d":"23.010%"}]
[10,"Oct",10,{"v":0.22605,"d":"22.605%"},{"v":0.3189,"d":"31.890%"},{"v":0.3153,"d":"31.530%"},{"v":0.2592,"d":"25.920%"},{"v":0.2132,"d":"21.320%"},{"v":0.2909,"d":"29.090%"},{"v":0.3134,"d":"31.340%"},{"v":0.2978,"d":"29.780%"},{"v":0.2876,"d":"28.760%"},{"v":0.29,"d":"29.000%"},{"v":0.3299,"d":"32.990%"},{"v":0.2973,"d":"29.730%"},{"v":0.27449999999999997,"d":"27.450%"},{"v":0.26649999999999996,"d":"26.650%"},{"v":0.1809,"d":"18.090%"},{"v":0.2362,"d":"23.620%"},{"v":0.3492,"d":"34.920%"},{"v":0.378,"d":"37.800%"},{"v":0.2617,"d":"26.170%"},{"v":0.2236,"d":"22.360%"}]
[11,"Nov",11,{"v":0.22605,"d":"22.605%"},{"v":0.3189,"d":"31.890%"},{"v":0.3153,"d":"31.530%"},{"v":0.2592,"d":"25.920%"},{"v":0.2132,"d":"21.320%"},{"v":0.2909,"d":"29.090%"},{"v":0.3134,"d":"31.340%"},{"v":0.2978,"d":"29.780%"},{"v":0.2876,"d":"28.760%"},{"v":0.29,"d":"29.000%"},{"v":0.3299,"d":"32.990%"},{"v":0.2944,"d":"29.440%"},{"v":0.2724,"d":"27.240%"},{"v":0.2655,"d":"26.550%"},{"v":0.1784,"d":"17.840%"},{"v":0.2391,"d":"23.910%"},{"v":0.3667,"d":"36.670%"},{"v":0.3628,"d":"36.280%"},{"v":0.259,"d":"25.900%"},{"v":0.2299,"d":"22.990%"}]
[12,"Dic",12,{"v":0.22605,"d":"22.605%"},{"v":0.3189,"d":"31.890%"},{"v":0.3153,"d":"31.530%"},{"v":0.2592,"d":"25.920%"},{"v":0.2132,"d":"21.320%"},{"v":0.2909,"d":"29.090%"},{"v":0.3134,"d":"31.340%"},{"v":0.2978,"d":"29.780%"},{"v":0.2876,"d":"28.760%"},{"v":0.29,"d":"29.000%"},{"v":0.3299,"d":"32.990%"},{"v":0.2916,"d":"29.160%"},{"v":0.271,"d":"27.100%"},{"v":0.2637,"d":"26.370%"},{"v":0.2419,"d":"24.190%"},{"v":0.2419,"d":"24.190%"},{"v":0.3946,"d":"39.460%"},{"v":0.3556,"d":"35.560%"},{"v":0.2439,"d":"24.390%"},{"v":0.2302,"d":"23.020%"}]
[]
[{"$nulls":3},"Esta tabla se debe estar actualizando en la medida que se publiquen las Tasas de Impuesto de Renta y Complementarios:"]
[{"$nulls":3},"Descargar"]
[]
[{"$nulls":3},"Esta es la circular de la Dian con base a la cual se realiza la liquidación de los intereses"]
[{"$nulls":3},"Descargar",{"$nulls":44},{"$f":"IF(AW14<>\"\",1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW20=0,AV20=1),1,0)","v":0},{"$f":"IF(AND(AX20=0,AW20=1),1,0)","v":0},{"$f":"IF(AND(AY20=0,AX20=1),1,0)","v":0},{"$f":"IF(AND(AZ20=0,AY20=1),1,0)","v":0},{"$f":"IF(AND(BA20=0,AZ20=1),1,0)","v":0},{"$f":"IF(AND(BB20=0,BA20=1),1,0)","v":0}]
[]
[{"$nulls":48},1,1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW3<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW4<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW5<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW6<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW7<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW8<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW9<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW10<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW11<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW12<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW13<>\"\",1,0),1)","v":1},1,1,1,1,1]
[{"$nulls":48},{"$f":"IF(AW$21=1,IF(AW14<>\"\",1,0),1)","v":1},1,1,1,1,1]
[]
[{"$nulls":48},{"$f":"IF(AND(AW24=0,AW23=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW25=0,AW24=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW26=0,AW25=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW27=0,AW26=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW28=0,AW27=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW29=0,AW28=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW30=0,AW29=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW31=0,AW30=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW32=0,AW31=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW33=0,AW32=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW34=0,AW33=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(AND(AW35=0,AW34=1),1,0)","v":0},0,0,0,0,0]
[{"$nulls":48},{"$f":"IF(SUM(AW37:AW48)=0,0,AW2)","v":0},{"$f":"IF(SUM(AX37:AX48)=0,0,AX2)","v":0},{"$f":"IF(SUM(AY37:AY48)=0,0,AY2)","v":0},{"$f":"IF(SUM(AZ37:AZ48)=0,0,AZ2)","v":0},{"$f":"IF(SUM(BA37:BA48)=0,0,BA2)","v":0},{"$f":"IF(SUM(BB37:BB48)=0,0,BB2)","v":0}]