{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Cuotafijacomparable"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cuotafijacomparable","index":0,"n_rows":394,"n_cols":67,"rows_kept":394,"cut":false,"hidden":false,"merged":[[7,3,7,5],[7,11,7,13],[8,10,17,10],[16,11,17,12],[19,11,19,13],[9,3,13,3],[14,3,15,3],[9,11,13,11],[14,11,15,11],[18,10,24,10],[25,10,25,14],[25,2,25,6],[27,9,27,14],[8,1,25,1],[8,9,25,9],[16,3,17,4],[27,1,27,6],[8,2,17,2],[19,3,19,5],[18,2,24,2],[53,18,53,21],[15,44,15,45],[15,52,15,54],[24,44,24,45],[30,44,30,47],[30,49,30,51],[30,53,30,55],[53,44,53,47],[15,18,15,19],[15,26,15,28],[24,18,24,19],[30,18,30,21],[30,23,30,25],[30,27,30,29]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOMINAL",{"$f":"+CONCATENATE(U12,CONCATENATE(LEFT(V16,1),LEFT(W16,1),LEFT(X16,1),LEFT(Y16,1)))","v":"31,43% EACV"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOMINAL",{"$f":"+CONCATENATE(AU12,CONCATENATE(LEFT(AV16,1),LEFT(AW16,1),LEFT(AX16,1),LEFT(AY16,1)))","v":"15,00% EAMV"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERIÓDICA",{"$f":"+CONCATENATE(U12,CONCATENATE(LEFT(W16,1),,LEFT(Y16,1)))","v":"31,43% AV"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERIÓDICA",{"$f":"+CONCATENATE(AU12,CONCATENATE(LEFT(AW16,1),,LEFT(AY16,1)))","v":"15,00% AV"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EFECTIVA",{"$f":"+CONCATENATE(U12,CONCATENATE(LEFT(V16,1),LEFT(W16,1)))","v":"31,43% EA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EFECTIVA",{"$f":"+CONCATENATE(AU12,CONCATENATE(LEFT(AV16,1),LEFT(AW16,1)))","v":"15,00% EA"}]
[null,null,"",null,null,null,null,null,null,null,""]
[null,"Primera opción\n\n\n1°","INGRESE AQUÍ LOS DATOS  INICIALES  E ","CAPITAL ","VALOR DEL CRÉDITO O PRÉSTAMO",null,14102000,null,null,"Segunda opción\n\n\n2°","INGRESE AQUÍ LOS DATOS  INICIALES  E ","CAPITAL ","VALOR DEL CRÉDITO O PRÉSTAMO",null,14102000]
[null,null,null,"TASA DE INTERÉS","VALOR DE LA TASA DE INTERES INFORMADA",null,0.31430000000000002,{"$f":"TEXT(G10,\"#0,00% \")","v":"31,43% "},null,null,null,"TASA DE INTERÉS","VALOR DE LA TASA DE INTERES INFORMADA",null,0.15,{"$f":"TEXT(O10,\"#0,00% \")","v":"15,00% "}]
[null,null,null,null,"TIPO DE TASA INFORMADA",null,"EFECTIVA",null,null,null,null,null,"TIPO DE TASA INFORMADA",null,"EFECTIVA",null,null,null,"PRIMERA OPCIÓN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEGUNDA OPCIÓN"]
[null,null,null,null,"TIPO DE PERIODO PACTADO DE LA TASA",null,"ANUAL",null,null,null,null,null,"TIPO DE PERIODO DE LA TASA",null,"ANUAL",null,null,null,null,null,{"$f":"TEXT(U16,\"#0,00% \")","v":"31,43% "},"      Ó     ","ANUAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(AU16,\"#0,00% \")","v":"15,00% "},"      Ó     ","ANUAL"]
[null,null,null,null,"TIPO DE PERIODO DE PAGO DE INTERES",null,"CUATRIMESTRE",null,null,null,null,null,"TIPO DE PERIODO DE PAGO DE INTERES",null,"MES"]
[null,null,null,null,"FORMA DE PAGOS DE LOS INTERESES",null,"VENCIDO",null,null,null,null,null,"FORMA DE PAGOS DE LOS INTERESES",null,"VENCIDO"]
[null,null,null,"PLAZO","PERIODICIDAD EN QUE DEBERÁ PAGAR LA CUOTA",null,"MENSUAL",null,null,null,null,"PLAZO","PERIODICIDAD EN QUE DEBERÁ PAGAR LA CUOTA",null,"MENSUAL"]
[null,null,null,null,"NUMERO DE PERIODOS TOTALES DEL CREDITO",null,24,null,null,null,null,null,"NUMERO DE PERIODOS TOTALES DEL CREDITO",null,24,null,null,null,null,null,{"$f":"+G10","v":0.31430000000000002},{"$f":"+G11","v":"EFECTIVA"},{"$f":"+G12","v":"ANUAL"},{"$f":"+G13","v":"CUATRIMESTRE"},{"$f":"+G14","v":"VENCIDO"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+O10","v":0.15},{"$f":"+O11","v":"EFECTIVA"},{"$f":"+O12","v":"ANUAL"},{"$f":"+O13","v":"MES"},{"$f":"+O14","v":"VENCIDO"}]
[null,null,null,"OTROS CARGOS ASOCIADOS AL CREDITO",null,"OTROS CARGOS (%)",0,null,null,null,null,"OTROS CARGOS ASOCIADOS AL CREDITO",null,"OTROS CARGOS (%)",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI NOMINAL O EFECTIVA",null,{"$f":"+IF(V16=\"NOMINAL\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI NOMINAL O EFECTIVA",null,{"$f":"+IF(AV16=\"NOMINAL\",1,0)","v":0}]
[null,null,null,null,null,"OTROS CARGOS  ($)",0,null,null,null,null,null,null,"OTROS CARGOS  ($)",0,null,null,null,null,null,"PORCENTAJE ","TIPO DE TASA","TIPO DE PERIODO PACTADO","TIPO DE PERIODO DE PAGO DE INTERES","FORMA DE PAGOS DE INTERESES",null,null,null,null,null,null,null,"Efectiva anual",null,0.1268,null,null,null,null,null,null,null,null,null,null,null,"PORCENTAJE ","TIPO DE TASA","TIPO DE PERIODO PACTADO","TIPO DE PERIODO DE PAGO DE INTERES","FORMA DE PAGOS DE INTERESES",null,null,null,null,null,null,null,"Efectiva anual",null,0.1268]
[null,null,"INFORMACIÓN RESUMEN \nDEL CRÉDITO 1","EL VALOR Y TIPO DE TASA QUE LE FUE INFORMADA FUE",null,null,{"$f":"+IF(G11=\"NOMINAL\",T5,IF(G11=\"PERIÓDICA\",T6,IF(G11=\"EFECTIVA\",T7,)))","v":"31,43% EA"},{"$f":"TEXT(G19,\"#0,00% \")","v":"31,43% EA"},null,null,"INFORMACIÓN RESUMEN \nDEL CRÉDITO 2","EL VALOR Y TIPO DE TASA QUE LE FUE INFORMADA FUE",null,null,{"$f":"+IF(O11=\"NOMINAL\",AT5,IF(O11=\"PERIÓDICA\",AT6,IF(O11=\"EFECTIVA\",AT7,)))","v":"15,00% EA"},{"$f":"TEXT(O19,\"#0,00% \")","v":"15,00% EA"}]
[null,null,null,"1) TASA EQUIVALENTE DE INTERÉS EFECTIVA ANUAL",null,null,{"$f":"+CONCATENATE(H20,\"EA\")","v":"31,43% EA"},{"$f":"TEXT(AD40,\"#0,00% \")","v":"31,43% "},null,null,null,"1) TASA EQUIVALENTE DE INTERÉS EFECTIVA ANUAL",null,null,{"$f":"+CONCATENATE(P20,\"EA\")","v":"15,00% EA"},{"$f":"TEXT(BD40,\"#0,00% \")","v":"15,00% "}]
[null,null,null,"2) TASA EQUIVALENTE NOMINAL ANUAL MES VENCIDO",null,null,{"$f":"+CONCATENATE(H21,\"NAMV\")","v":"27,64% NAMV"},{"$f":"TEXT(V37,\"#0,00% \")","v":"27,64% "},null,null,null,"2) TASA EQUIVALENTE NOMINAL ANUAL MES VENCIDO",null,null,{"$f":"+CONCATENATE(P21,\"NAMV\")","v":"14,06% NAMV"},{"$f":"TEXT(AV37,\"#0,00% \")","v":"14,06% "}]
[null,null,null,"3) TASA EQUIVALENTE PERIÓDICA MES VENCIDO",null,null,{"$f":"+CONCATENATE(H22,\"MV\")","v":"2,30% MV"},{"$f":"TEXT(Z37,\"#0,00% \")","v":"2,30% "},null,null,null,"3) TASA EQUIVALENTE PERIÓDICA MES VENCIDO",null,null,{"$f":"+CONCATENATE(P22,\"MV\")","v":"1,17% MV"},{"$f":"TEXT(AZ37,\"#0,00% \")","v":"1,17% "}]
[null,null,null,"N° DE CUOTAS MAXIMAS QUE PAGARÁ AL AÑO ",null,null,{"$f":"IF(EXACT(\"DIARIO\",G15),365,IF(\"SEMANAL\"=G15,52,IF(\"QUINCENAL\"=G15,24,IF(\"MENSUAL\"=G15,12,IF(\"BIMESTRAL\"=G15,6,IF(\"TRIMESTRAL\"=G15,4,IF(\"SEMESTRAL\"=G15,2,1)))))))","v":12},null,null,null,null,"N° DE CUOTAS MAXIMAS QUE PAGARÁ AL AÑO ",null,null,{"$f":"IF(EXACT(\"DIARIO\",O15),365,IF(\"SEMANAL\"=O15,52,IF(\"QUINCENAL\"=O15,24,IF(\"MENSUAL\"=O15,12,IF(\"BIMESTRAL\"=O15,6,IF(\"TRIMESTRAL\"=O15,4,IF(\"SEMESTRAL\"=O15,2,1)))))))","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verificación de Periodo de pago menor frente a pactado",null,null,null,null,{"$f":"IF(V16=\"NOMINAL\",IF(VLOOKUP(W16,$AK$43:$AL$51,2,0)>VLOOKUP(X16,$AK$55:$AL$63,2,0),0,1),1)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verificación de Periodo de pago menor frente a pactado",null,null,null,null,{"$f":"IF(AV16=\"NOMINAL\",IF(VLOOKUP(AW16,$BK$43:$BL$51,2,0)>VLOOKUP(AX16,$BK$55:$BL$63,2,0),0,1),1)","v":1}]
[null,null,null,"CUOTA FIJA TOTAL A PAGAR CADA CORTE (INCLUYE COSTO ADICIONALES)",null,null,{"$f":"+D30+IF(G17>0%,G17*D30,0)+IF(G18>1,G18,0)","v":771481.91101200914},{"$f":"IF($G$23=365,\"Diaria\",IF($G$23=52,\"Semanal\",IF($G$23=24,\"Quincenal\",IF($G$23=12,\"Mensual\",IF($G$23=6,\"Bimestral\",IF($G$23=4,\"Trimestral\",IF($G$23=2,\"Semestral\",\"Anual\")))))))","v":"Mensual"},null,null,null,"CUOTA FIJA TOTAL A PAGAR CADA CORTE (INCLUYE COSTO ADICIONALES)",null,null,{"$f":"+L30+IF(O17>0%,O17*L30,0)+IF(O18>1,O18,0)","v":677463.47438445711}]
[null,null,null,"TOTAL DE INTERESES A PAGAR DURANTE EL TIEMPO",null,null,{"$f":"SUM($E$30:$E$394)","v":4413565.8642882165},{"$f":"-PMT(#REF!,G16,$G$9)+IF(G17>0%,G17*D30,0)+IF(G18>1,G18,0)","v":{"$error":"#REF!"}},null,null,null,"TOTAL DE INTERESES A PAGAR DURANTE EL TIEMPO",null,null,{"$f":"SUM($M$30:$M$394)","v":2157123.3852269701},null,null,null,"LA TASA QUE HA INGRESADO ES     E ",null,{"$f":"+IF(V16=\"NOMINAL\",AI6,IF(V16=\"PERIÓDICA\",AI7,IF(V16=\"EFECTIVA\",AI8,)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA TASA QUE HA INGRESADO ES     E ",null,{"$f":"+IF(AV16=\"NOMINAL\",BI6,IF(AV16=\"PERIÓDICA\",BI7,IF(AV16=\"EFECTIVA\",BI8,)))","v":0}]
[null,null,{"$f":"+IF(AL23=1,\"\", \"ERROR EN LA TASA. RECUERDE QUE EL PERIODO PACTADO DE LA TASA NOMINAL  DEBE SER SIEMPRE IGUAL O MAYOR AL PERIODO DE PAGO DE INTERÉS.\")","v":""},null,null,null,null,null,null,null,{"$f":"+IF(BL23=1,\"\", \"ERROR EN LA TASA. RECUERDE QUE EL PERIODO PACTADO DE LA TASA NOMINAL  DEBE SER SIEMPRE IGUAL O MAYOR AL PERIODO DE PAGO DE INTERÉS.\")","v":""}]
[null,"",null,null,null,null,{"$f":"+VLOOKUP($G$15,$AK$43:$AN$51,4,0)","v":2.3036688922224879E-2},"EM",null,"",null,null,null,null,{"$f":"+VLOOKUP($O$15,$BK$43:$BN$51,4,0)","v":1.171491691985338E-2},"EM"]
[null,"DETALLE DE LA AMORTIZACIÓN DEL CRÉDITO",null,null,null,null,null,null,null,"DETALLE DE LA AMORTIZACIÓN DEL CRÉDITO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Conversión a periodo de pactado anual (nominal)",null,null,null,{"$f":"+IF(V16=\"NOMINAL\",IF(W16=W12,U16,U16*VLOOKUP(W16,AK43:AL51,2,0)),U16)","v":0.31430000000000002},{"$f":"+CONCATENATE(LEFT(V16,1),\"A\",LEFT(X16,1),LEFT(Y16,1))","v":"EACV"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Conversión a periodo de pactado anual (nominal)",null,null,null,{"$f":"+IF(AV16=\"NOMINAL\",IF(AW16=AW12,AU16,AU16*VLOOKUP(AW16,BK43:BL51,2,0)),AU16)","v":0.15},{"$f":"+CONCATENATE(LEFT(AV16,1),\"A\",LEFT(AX16,1),LEFT(AY16,1))","v":"EAMV"}]
[null,"PERIODO","SALDO INICIAL","CUOTA CRÉDITO","INTERÉS","ABONO A CAPITAL","SALDO ",null,null,"PERIODO","SALDO INICIAL","CUOTA CRÉDITO","INTERÉS","ABONO A CAPITAL","SALDO "]
[null,1,{"$f":"+G9","v":14102000},{"$f":"PMT(G27,G16,-$G$9)","v":771481.91101200914},{"$f":"+IF(ISNUMBER(B30),C30*$G$27,$B$27)","v":324863.38718121522},{"$f":"D30-E30","v":446618.52383079391},{"$f":"+C30-F30","v":13655381.476169206},null,null,1,{"$f":"+O9","v":14102000},{"$f":"PMT(O27,O16,-$O$9)","v":677463.47438445711},{"$f":"+IF(ISNUMBER(J30),K30*$O$27,$J$27)","v":165203.75840377237},{"$f":"L30-M30","v":512259.71598068473},{"$f":"+K30-N30","v":13589740.284019316},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conversión de Nominal a Efectiva Anual (VENCIDA)",null,null,null,{"$f":"((1+AK28/(VLOOKUP(X16,$AK$55:$AL$63,2,0)))^((VLOOKUP(X16,$AK$55:$AL$63,2,0)))-1)","v":0.34837808797062952},"EA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conversión de Nominal a Efectiva Anual (VENCIDA)",null,null,null,{"$f":"((1+BK28/(VLOOKUP(AX16,$BK$55:$BL$63,2,0)))^((VLOOKUP(AX16,$BK$55:$BL$63,2,0)))-1)","v":0.16075451772299854},"EA"]
[null,{"$f":"IF(ISNUMBER(B30),IF(($G$16-B30)>0,B30+1,$C$8),$C$8)","v":2},{"$f":"IF(ISNUMBER(B31),+G30,$C$8)","v":13655381.476169206},{"$f":"IF(ISNUMBER(B31),$D$30,$C$8)","v":771481.91101200914},{"$f":"+IF(ISNUMBER(B31),C31*$G$27,$B$27)","v":314574.77518082195},{"$f":"IF(ISNUMBER(B31),D31-E31,$C$8)","v":456907.13583118719},{"$f":"IF(ISNUMBER(B31),C31-F31,$C$8)","v":13198474.34033802},null,null,{"$f":"IF(ISNUMBER(J30),IF(($O$16-J30)>0,J30+1,$K$8),$C$8)","v":2},{"$f":"IF(ISNUMBER(J31),+O30,$C$8)","v":13589740.284019316},{"$f":"IF(ISNUMBER(J31),$L$30,$C$8)","v":677463.47438445711},{"$f":"+IF(ISNUMBER(J31),K31*$O$27,$J$27)","v":159202.67838967097},{"$f":"IF(ISNUMBER(J31),L31-M31,$C$8)","v":518260.79599478614},{"$f":"IF(ISNUMBER(J31),K31-N31,$C$8)","v":13071479.488024529},null,null,null,"Tasas Nominales Equivalentes",null,null,null,null,"Tasas Períodicas Equivalentes",null,null,null,"Tasas Efectivas  Equivalentes",null,null,null,null,"Conversión de Nominal a Efectiva Anual (ANTICIPADA)",null,null,null,{"$f":"((1-AK28/(VLOOKUP(X16,$AK$55:$AL$63,2,0)))^(-(VLOOKUP(X16,$AK$55:$AL$63,2,0)))-1)","v":0.39377049514062623},"EA",null,null,null,null,null,null,"Tasas Nominales Equivalentes",null,null,null,null,"Tasas Períodicas Equivalentes",null,null,null,"Tasas Efectivas  Equivalentes",null,null,null,null,"Conversión de Nominal a Efectiva Anual (ANTICIPADA)",null,null,null,{"$f":"((1-BK28/(VLOOKUP(AX16,$BK$55:$BL$63,2,0)))^(-(VLOOKUP(AX16,$BK$55:$BL$63,2,0)))-1)","v":0.16293314447764007},"EA"]
[null,3,13198474.34033802,771481.91101200914,304049.14762633416,467432.76338567497,12731041.576952344,null,null,3,13071479.488024529,{"$f":"IF(ISNUMBER(J32),$L$30,$C$8)","v":677463.47438445711},153131.29622177494,524332.1781626821,12547147.309861846,null,null,null,"Nominal Anual Diario ",null,"(NADV)",{"$f":"((1+$AK$40)^(1/360)-1)*360","v":0.27340797408094808},null,"Diario","(DV)",{"$f":"V32/360","v":7.5946659466930022E-4},null,"Efectiva Diaria","(ED)",{"$f":"(((1+$AK$40))^(1/365)-1)","v":7.4905904719213545E-4},null,null,"NOMINAL A EFECTIVA",null,null,null,{"$f":"IF(V16=\"NOMINAL\",IF(Y16=\"ANTICIPADO\",((1-AK28/(VLOOKUP(X16,$AK$55:$AL$63,2,0)))^(-(VLOOKUP(X16,$AK$55:$AL$63,2,0)))-1),((1+AK28/(VLOOKUP(X16,$AK$55:$AL$63,2,0)))^((VLOOKUP(X16,$AK$55:$AL$63,2,0)))-1)))","v":false},"EA",null,null,null,null,null,null,"Nominal Anual Diario ",null,"(NADV)",{"$f":"((1+$BK$40)^(1/360)-1)*360","v":0.13978907560928455},null,"Diario","(DV)",{"$f":"AV32/360","v":3.883029878035682E-4},null,"Efectiva Diaria","(ED)",{"$f":"(((1+$BK$40))^(1/365)-1)","v":3.8298275033898932E-4},null,null,"NOMINAL A EFECTIVA",null,null,null,{"$f":"IF(AV16=\"NOMINAL\",IF(AY16=\"ANTICIPADO\",((1-BK28/(VLOOKUP(AX16,$BK$55:$BL$63,2,0)))^(-(VLOOKUP(AX16,$BK$55:$BL$63,2,0)))-1),((1+BK28/(VLOOKUP(AX16,$BK$55:$BL$63,2,0)))^((VLOOKUP(AX16,$BK$55:$BL$63,2,0)))-1)))","v":false},"EA"]
[null,4,12731041.576952344,771481.91101200914,293281.04446416243,478200.8665478467,12252840.710404497,null,null,4,12547147.309861846,677463.47438445711,146988.78831619336,530474.68606826372,12016672.623793583,null,null,null,"Nominal Anual Semanal Vencida",null,"(NASV)",{"$f":"((1+$AK$40)^(1/52)-1)*52","v":0.27402368741511562},null,"Semanal Vencido","(SEMV)",{"$f":"V33/52","v":5.2696862964445312E-3},null,"Efectiva Semanal","(ESM)",{"$f":"(((1+$AK$40))^(1/52)-1)","v":5.2696862964445312E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal Anual Semanal Vencida",null,"(NASV)",{"$f":"((1+$BK$40)^(1/52)-1)*52","v":0.13994993191812544},null,"Semanal Vencido","(SEMV)",{"$f":"AV33/52","v":2.6913448445793353E-3},null,"Efectiva Semanal","(ESM)",{"$f":"(((1+$BK$40))^(1/52)-1)","v":2.6913448445793353E-3}]
[null,5,12252840.710404497,771481.91101200914,282264.87985916127,489217.03115284786,11763623.679251648,null,null,5,12016672.623793583,677463.47438445711,140774.32144081837,536689.15294363874,11479983.470849944,null,null,null,"Nominal Anual Semanal Anticipada",null,"(NASA)",{"$f":"Z34*52","v":0.272587238181485},null,"Semanal Anticipado","(SEMA)",{"$f":"Z33/(1+Z33)","v":5.2420622727208654E-3},null,"Efectiva Quincenal","(EQ)",{"$f":"(((1+$AK$40))^(1/26)-1)","v":1.0567142186552081E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal Anual Semanal Anticipada",null,"(NASA)",{"$f":"AZ34*52","v":0.13957428937398295},null,"Semanal Anticipado","(SEMA)",{"$f":"AZ33/(1+AZ33)","v":2.6841209494996719E-3},null,"Efectiva Quincenal","(EQ)",{"$f":"(((1+$BK$40))^(1/26)-1)","v":5.3899330262310308E-3}]
[null,6,11763623.679251648,771481.91101200914,270994.93929703871,500486.97171497042,11263136.707536679,null,null,6,11479983.470849944,677463.47438445711,134487.05260229713,542976.42178215994,10937007.049067784,null,null,null,"Nominal Anual Quincena Vencida",null,"(NAQV)",{"$f":"((1+$AK$40)^(1/26)-1)*26","v":0.2747456968503541},null,"Quincenal Vencido","(QV)",{"$f":"V35/26","v":1.0567142186552081E-2},null,"Efectiva Mensual","(EM)",{"$f":"(((1+$AK$40))^(1/12)-1)","v":2.3036688922224879E-2},null,2,"Conversión de Efectivas a Efectiva Anual",null,null,null,{"$f":"+IF(V16=\"EFECTIVA\",(((1+U16))^(VLOOKUP($G$12,$AK$43:$AL$51,2,0)/1)-1),0)","v":0.31430000000000002},"EA",null,null,null,null,null,null,"Nominal Anual Quincena Vencida",null,"(NAQV)",{"$f":"((1+$BK$40)^(1/26)-1)*26","v":0.1401382586820068},null,"Quincenal Vencido","(QV)",{"$f":"AV35/26","v":5.3899330262310308E-3},null,"Efectiva Mensual","(EM)",{"$f":"(((1+$BK$40))^(1/12)-1)","v":1.171491691985338E-2},null,2,"Conversión de Efectivas a Efectiva Anual",null,null,null,{"$f":"+IF(AV16=\"EFECTIVA\",(((1+AU16))^(VLOOKUP($O$12,$BK$43:$BL$51,2,0)/1)-1),0)","v":0.14999999999999991},"EA"]
[null,7,11263136.707536679,771481.91101200914,259465.37662001461,512016.53439199453,10751120.173144685,null,null,7,10937007.049067784,677463.47438445711,128126.12893167986,549337.34545277723,10387669.703615006,null,null,null,"Nominal Anual Quincena Anticipada",null,"(NAQA)",{"$f":"Z36*26","v":0.27187277854283892},null,"Quincenal Anticipado","(QA)",{"$f":"Z35/(1+Z35)","v":1.0456645328570728E-2},null,"Efectiva Bimestral","(EB)",{"$f":"(((1+$AK$40))^(1/6)-1)","v":4.6604066880949091E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal Anual Quincena Anticipada",null,"(NAQA)",{"$f":"AZ36*26","v":0.13938697223692068},null,"Quincenal Anticipado","(QA)",{"$f":"AZ35/(1+AZ35)","v":5.3610373937277179E-3},null,"Efectiva Bimestral","(EB)",{"$f":"(((1+$BK$40))^(1/6)-1)","v":2.3567073118145654E-2}]
[null,8,10751120.173144685,771481.91101200914,247670.21099419059,523811.70001781854,10227308.473126866,null,null,8,10387669.703615006,677463.47438445711,121690.68756872778,555772.78681572934,9831896.9167992771,null,null,null,"Nominal Anual Mes Vencido",null,"(NAMV)",{"$f":"((1+$AK$40)^(1/12)-1)*12","v":0.27644026706669855},null,"Mensual Vencido","(MV)",{"$f":"V37/12","v":2.3036688922224879E-2},null,"Efectiva Trimestral","(ET)",{"$f":"(((1+$AK$40))^(1/4)-1)","v":7.0714359194420817E-2},null,3,"De  Tasa periodica Anticipada a vencida",null,null,null,{"$f":"IF(V16=\"PERIÓDICA\",IF(Y16=\"ANTICIPADO\",U16/(1-U16),U16),0)","v":0},"VENCIDA",null,null,null,null,null,null,"Nominal Anual Mes Vencido",null,"(NAMV)",{"$f":"((1+$BK$40)^(1/12)-1)*12","v":0.14057900303824056},null,"Mensual Vencido","(MV)",{"$f":"AV37/12","v":1.171491691985338E-2},null,"Efectiva Trimestral","(ET)",{"$f":"(((1+$BK$40))^(1/4)-1)","v":3.5558076341622114E-2},null,3,"De  Tasa periodica Anticipada a vencida",null,null,null,{"$f":"IF(AV16=\"PERIÓDICA\",IF(AY16=\"ANTICIPADO\",AU16/(1-AU16),AU16),0)","v":0},"VENCIDA"]
[null,9,10227308.473126866,771481.91101200914,235603.32380705833,535878.58720495086,9691429.8859219141,null,null,9,9831896.9167992771,677463.47438445711,115179.85554486614,562283.61883959093,9269613.2979596853,null,null,null,"Nominal Anual Mes Anticipado",null,"(NAMA)",{"$f":"Z38*12","v":0.27021539897843738},null,"Mensual Anticipado","(MA)",{"$f":"Z37/(1+Z37)","v":2.2517949914869783E-2},null,"Efectiva Cuatrimestral","(EC)",{"$f":"(((1+$AK$40))^(1/3)-1)","v":9.5380072811742211E-2},null,null,"De periodica a Efectiva Anual",null,null,null,{"$f":"((1+AK37)^(VLOOKUP(W16,$AK$43:$AL$51,2,0))-1)","v":0},"EA",null,null,null,null,null,null,"Nominal Anual Mes Anticipado",null,"(NAMA)",{"$f":"AZ38*12","v":0.13895120125957086},null,"Mensual Anticipado","(MA)",{"$f":"AZ37/(1+AZ37)","v":1.1579266771630905E-2},null,"Efectiva Cuatrimestral","(EC)",{"$f":"(((1+$BK$40))^(1/3)-1)","v":4.7689553171647248E-2},null,null,"De periodica a Efectiva Anual",null,null,null,{"$f":"((1+BK37)^(VLOOKUP(AW16,$BK$43:$BL$51,2,0))-1)","v":0},"EA"]
[null,10,9691429.8859219141,771481.91101200914,223258.45549353649,548223.45551847271,9143206.4304034412,null,null,10,9269613.2979596853,677463.47438445711,108592.74966476581,568870.72471969132,8700742.5732399933,null,null,null,"Nominal Anual Bimestre Vencido",null,"(NABV)",{"$f":"((1+$AK$40)^(1/6)-1)*6","v":0.27962440128569455},null,"Bimestral Vencido","(BV)",{"$f":"V39/6","v":4.6604066880949091E-2},null,"Efectiva Semestral","(ES)",{"$f":"(((1+$AK$40))^(1/2)-1)","v":0.14642923898511939},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal Anual Bimestre Vencido",null,"(NABV)",{"$f":"((1+$BK$40)^(1/6)-1)*6","v":0.14140243870887392},null,"Bimestral Vencido","(BV)",{"$f":"AV39/6","v":2.3567073118145654E-2},null,"Efectiva Semestral","(ES)",{"$f":"(((1+$BK$40))^(1/2)-1)","v":7.2380529476360866E-2}]
[null,11,9143206.4304034412,771481.91101200914,210629.20228889023,560852.70872311888,8582353.7216803227,null,null,11,8700742.5732399933,677463.47438445711,101928.47638653783,575534.99799791933,8125207.5752420742,null,null,null,"Nominal Anual Bimestre Anticipado",null,"(NABA)",{"$f":"Z40*6","v":0.26717305056822577},null,"Bimestral Anticipado","(BA)",{"$f":"Z39/(1+Z39)","v":4.4528841761370959E-2},null,"Efectiva Anual","(EA)",{"$f":"(((1+$AK$40))^(1/1)-1)","v":0.31430000000000002},null,null,"DEFINITIVA A CONVERTIR (EA%)",null,null,null,{"$f":"+IF(V16=\"PERIÓDICA\",AK38,IF(V16=\"NOMINAL\",AK32,IF(V16=\"EFECTIVA\",AK35,0)))","v":0.31430000000000002},"EA",null,null,null,null,null,null,"Nominal Anual Bimestre Anticipado",null,"(NABA)",{"$f":"AZ40*6","v":0.13814672474575829},null,"Bimestral Anticipado","(BA)",{"$f":"AZ39/(1+AZ39)","v":2.3024454124293048E-2},null,"Efectiva Anual","(EA)",{"$f":"(((1+$BK$40))^(1/1)-1)","v":0.14999999999999991},null,null,"DEFINITIVA A CONVERTIR (EA%)",null,null,null,{"$f":"+IF(AV16=\"PERIÓDICA\",BK38,IF(AV16=\"NOMINAL\",BK32,IF(AV16=\"EFECTIVA\",BK35,0)))","v":0.14999999999999991},"EA"]
[null,12,8582353.7216803227,771481.91101200914,197709.01290684857,573772.89810516057,8008580.8235751623,null,null,12,8125207.5752420742,677463.47438445711,95186.131700524231,582277.34268393286,7542930.2325581415,null,null,null,"Nominal Anual Trimestre Vencido",null,"(NATV)",{"$f":"((1+$AK$40)^(1/4)-1)*4","v":0.28285743677768327},null,"Trimestral Vencido","(TV)",{"$f":"V41/4","v":7.0714359194420817E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal Anual Trimestre Vencido",null,"(NATV)",{"$f":"((1+$BK$40)^(1/4)-1)*4","v":0.14223230536648845},null,"Trimestral Vencido","(TV)",{"$f":"AV41/4","v":3.5558076341622114E-2}]
[null,13,8008580.8235751623,771481.91101200914,184491.18514119653,586990.72587081254,7421590.09770435,null,null,13,7542930.2325581415,677463.47438445711,88364.80100666896,589098.67337778816,6953831.5591803528,null,null,null,"Nominal Anual Trimestre Anticipado",null,"(NATA)",{"$f":"Z42*4","v":0.26417637379076364},null,"Trimestral Anticipado","(TA)",{"$f":"Z41/(1+Z41)","v":6.604409344769091E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,null,null,"Nominal Anual Trimestre Anticipado",null,"(NATA)",{"$f":"AZ42*4","v":0.13734845839738996},null,"Trimestral Anticipado","(TA)",{"$f":"AZ41/(1+AZ41)","v":3.433711459934749E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,14,7421590.09770435,771481.91101200914,170968.86238907967,600513.04862292949,6821077.0490814205,null,null,14,6953831.5591803528,677463.47438445711,81463.558990452322,595999.91539400478,6357831.6437863484,null,null,null,"Nominal Anual Cuatrimestre Vencido",null,"(NACV)",{"$f":"((1+$AK$40)^(1/3)-1)*3","v":0.28614021843522663},null,"Cuatrimestre Vencido","(CV)",{"$f":"V43/3","v":9.5380072811742211E-2},null,null,null,null,null,null,null,null,null,"TIPO DE PERIODO PACTADO","ANUAL",1,8.3333333333333329E-2,{"$f":"+AD40","v":0.31430000000000002},4,null,null,null,"Nominal Anual Cuatrimestre Vencido",null,"(NACV)",{"$f":"((1+$BK$40)^(1/3)-1)*3","v":0.14306865951494174},null,"Cuatrimestre Vencido","(CV)",{"$f":"AV43/3","v":4.7689553171647248E-2},null,null,null,null,null,null,null,null,null,"TIPO DE PERIODO PACTADO","ANUAL",1,8.3333333333333329E-2,{"$f":"+BD40","v":0.14999999999999991},4]
[null,15,6821077.0490814205,771481.91101200914,157135.03009421632,614346.88091779279,6206730.1681636274,null,null,15,6357831.6437863484,677463.47438445711,74481.469497371916,602982.00488708518,5754849.638899263,null,null,null,"Nominal Anual Cuatrimestre Anticipado",null,"(NACA)",{"$f":"Z44*3","v":0.26122459732239822},null,"Cuatrimestre Anticipado","(CA)",{"$f":"Z43/(1+Z43)","v":8.7074865774132745E-2},null,null,null,null,null,null,null,null,null,null,"SEMESTRAL",2,0.16666666666666666,{"$f":"+AD39","v":0.14642923898511939},2,null,null,null,"Nominal Anual Cuatrimestre Anticipado",null,"(NACA)",{"$f":"AZ44*3","v":0.13655634828259303},null,"Cuatrimestre Anticipado","(CA)",{"$f":"AZ43/(1+AZ43)","v":4.5518782760864344E-2},null,null,null,null,null,null,null,null,null,null,"SEMESTRAL",2,0.16666666666666666,{"$f":"+BD39","v":7.2380529476360866E-2},2]
[null,16,6206730.1681636274,771481.91101200914,142982.51210817401,628499.3989038351,5578230.7692597918,null,null,16,5754849.638899263,677463.47438445711,67417.585405953083,610045.88897850399,5144803.7499207594,null,null,null,"Nominal Anual Semestre Vencido",null,"(NASV)",{"$f":"((1+$AK$40)^(1/2)-1)*2","v":0.29285847797023878},null,"Semestral Vencido","(SV)",{"$f":"V45/2","v":0.14642923898511939},null,null,null,null,null,null,null,null,null,null,"CUATRIMESTRAL",3,0.25,{"$f":"+AD38","v":9.5380072811742211E-2},12,null,null,null,"Nominal Anual Semestre Vencido",null,"(NASV)",{"$f":"((1+$BK$40)^(1/2)-1)*2","v":0.14476105895272173},null,"Semestral Vencido","(SV)",{"$f":"AV45/2","v":7.2380529476360866E-2},null,null,null,null,null,null,null,null,null,null,"CUATRIMESTRAL",3,0.25,{"$f":"+BD38","v":4.7689553171647248E-2},12]
[null,17,5578230.7692597918,771481.91101200914,128503.96696782102,642977.94404418813,4935252.8252156042,null,null,17,5144803.7499207594,677463.47438445711,60270.948499271821,617192.52588518523,4527611.2240355741,null,null,null,"Nominal Anual Semestre Anticipado",null,"(NASA)",{"$f":"Z46*2","v":0.25545272923210927},null,"Semestral Anticipado","(SA)",{"$f":"Z45/(1+Z45)","v":0.12772636461605463},null,null,null,null,null,null,null,null,null,null,"TRIMESTRAL",4,0.33333333333333331,{"$f":"+AD37","v":7.0714359194420817E-2},null,null,null,null,"Nominal Anual Semestre Anticipado",null,"(NASA)",{"$f":"AZ46*2","v":0.13499038351937254},null,"Semestral Anticipado","(SA)",{"$f":"AZ45/(1+AZ45)","v":6.7495191759686268E-2},null,null,null,null,null,null,null,null,null,null,"TRIMESTRAL",4,0.33333333333333331,{"$f":"+BD37","v":3.5558076341622114E-2}]
[null,18,4935252.8252156042,771481.91101200914,113691.88408702335,657790.02692498581,4277462.7982906187,null,null,18,4527611.2240355741,677463.47438445711,53040.589334972421,624422.88504948467,3903188.3389860895,null,null,null,"Nominal Anual Año Vencido",null,"(NAAV)",{"$f":"((1+$AK$40)^(1/1)-1)*1","v":0.31430000000000002},null,"Anual Vencido","(AV)",{"$f":"V47/1","v":0.31430000000000002},null,null,null,null,null,null,null,null,null,null,"BIMESTRAL",6,0.5,{"$f":"+AD36","v":4.6604066880949091E-2},null,null,null,null,"Nominal Anual Año Vencido",null,"(NAAV)",{"$f":"((1+$BK$40)^(1/1)-1)*1","v":0.14999999999999991},null,"Anual Vencido","(AV)",{"$f":"AV47/1","v":0.14999999999999991},null,null,null,null,null,null,null,null,null,null,"BIMESTRAL",6,0.5,{"$f":"+BD36","v":2.3567073118145654E-2}]
[null,19,4277462.7982906187,771481.91101200914,98538.579860610524,672943.3311513986,3604519.4671392199,null,null,19,3903188.3389860895,677463.47438445711,45725.527113762546,631737.94727069454,3271450.3917153948,null,null,null,"Nominal Anual Año Anticipado",null,"(NAAA)",{"$f":"Z48*1","v":0.23913870501407594},null,"Anual Anticipado","(AA)",{"$f":"Z47/(1+Z47)","v":0.23913870501407594},null,null,null,null,null,null,null,null,null,null,"MENSUAL",12,1,{"$f":"+AD35","v":2.3036688922224879E-2},null,null,null,null,"Nominal Anual Año Anticipado",null,"(NAAA)",{"$f":"AZ48*1","v":0.13043478260869559},null,"Anual Anticipado","(AA)",{"$f":"AZ47/(1+AZ47)","v":0.13043478260869559},null,null,null,null,null,null,null,null,null,null,"MENSUAL",12,1,{"$f":"+BD35","v":1.171491691985338E-2}]
[null,20,3604519.4671392199,771481.91101200914,83036.193678589989,688445.71733341913,2916073.7498058006,null,null,20,3271450.3917153948,677463.47438445711,38324.769546367643,639138.70483808941,2632311.6868773056,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUINCENAL",26,{"$f":"1/0.5","v":2},{"$f":"+AD34","v":1.0567142186552081E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUINCENAL",26,{"$f":"1/0.5","v":2},{"$f":"+BD34","v":5.3899330262310308E-3}]
[null,21,2916073.7498058006,771481.91101200914,67176.683848542045,704305.22716346709,2211768.5226423335,null,null,21,2632311.6868773056,677463.47438445711,30837.31271892674,646626.16166553041,1985685.5252117752,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEMANAL",52,{"$f":"1/0.25","v":4},{"$f":"+AD33","v":5.2696862964445312E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEMANAL",52,{"$f":"1/0.25","v":4},{"$f":"+BD33","v":2.6913448445793353E-3}]
[null,22,2211768.5226423335,771481.91101200914,50951.823424080329,720530.08758792887,1491238.4350544047,null,null,22,1985685.5252117752,677463.47438445711,23262.14095681137,654201.33342764573,1331484.1917841295,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIARIO",365,{"$f":"1/(1/30)","v":30},{"$f":"+AD32","v":7.4905904719213545E-4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIARIO",365,{"$f":"1/(1/30)","v":30},{"$f":"+BD32","v":3.8298275033898932E-4}]
[null,23,1491238.4350544047,771481.91101200914,34353.195937213772,737128.71507479541,754109.71997960925,null,null,23,1331484.1917841295,677463.47438445711,15598.226686849201,661865.24769760785,669618.94408652163]
[null,24,754109.71997960925,771481.91101200914,17372.191032396371,754109.71997961274,-3.4924596548080444E-9,null,null,24,669618.94408652163,677463.47438445711,7844.5302979335465,669618.94408652361,-1.9790604710578918E-9]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO DE PERIODO PAGO INTERES","AÑO",1,"ANUAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO DE PERIODO PAGO INTERES","AÑO",1,"ANUAL"]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEMESTRE",2,"SEMESTRAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEMESTRE",2,"SEMESTRAL"]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUATRIMESTRE",3,"CUATRIMESTRAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUATRIMESTRE",3,"CUATRIMESTRAL"]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRIMESTRE",4,"TRIMESTRAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRIMESTRE",4,"TRIMESTRAL"]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIMESTRE",6,"BIMESTRAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIMESTRE",6,"BIMESTRAL"]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MES",12,"MENSUAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MES",12,"MENSUAL"]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEMANA",26,"SEMANAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEMANA",26,"SEMANAL"]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUINCENA",52,"QUINCENAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUINCENA",52,"QUINCENAL"]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIARIO",365,"DIARIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIARIO",365,"DIARIA"]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORMA DE PAGO","VENCIDO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORMA DE PAGO","VENCIDO"]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANTICIPADO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANTICIPADO"]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO DE TASA","NOMINAL",1,{"$f":"+AK30","v":0.34837808797062952},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO DE TASA","NOMINAL",1,{"$f":"+BK30","v":0.16075451772299854}]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EFECTIVA",2,{"$f":"+AK35","v":0.31430000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EFECTIVA",2,{"$f":"+BK35","v":0.14999999999999991}]
[null,"","","","","","",null,null,"","","","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERIÓDICA",3,{"$f":"+AK38","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERIÓDICA",3,{"$f":"+BK38","v":0}]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,{"$f":"IF(ISNUMBER(B94),IF(($G$16-B94)>0,B94+1,$C$8),$C$8)","v":""},{"$f":"IF(ISNUMBER(B95),+G94,$C$8)","v":""},{"$f":"IF(ISNUMBER(B95),$D$30,$C$8)","v":""},{"$f":"+IF(ISNUMBER(B95),C95*$G$27,$B$27)","v":""},{"$f":"IF(ISNUMBER(B95),D95-E95,$C$8)","v":""},{"$f":"IF(ISNUMBER(B95),C95-F95,$C$8)","v":""},null,null,{"$f":"IF(ISNUMBER(J94),IF(($O$16-J94)>0,J94+1,$K$8),$C$8)","v":""},{"$f":"IF(ISNUMBER(J95),+O94,$C$8)","v":""},{"$f":"IF(ISNUMBER(J95),$L$30,$C$8)","v":""},{"$f":"+IF(ISNUMBER(J95),K95*$O$27,$J$27)","v":""},{"$f":"IF(ISNUMBER(J95),L95-M95,$C$8)","v":""},{"$f":"IF(ISNUMBER(J95),K95-N95,$C$8)","v":""}]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,{"$f":"IF(ISNUMBER(B158),IF(($G$16-B158)>0,B158+1,$C$8),$C$8)","v":""},{"$f":"IF(ISNUMBER(B159),+G158,$C$8)","v":""},{"$f":"IF(ISNUMBER(B159),$D$30,$C$8)","v":""},{"$f":"+IF(ISNUMBER(B159),C159*$G$27,$B$27)","v":""},{"$f":"IF(ISNUMBER(B159),D159-E159,$C$8)","v":""},{"$f":"IF(ISNUMBER(B159),C159-F159,$C$8)","v":""},null,null,{"$f":"IF(ISNUMBER(J158),IF(($O$16-J158)>0,J158+1,$K$8),$C$8)","v":""},{"$f":"IF(ISNUMBER(J159),+O158,$C$8)","v":""},{"$f":"IF(ISNUMBER(J159),$L$30,$C$8)","v":""},{"$f":"+IF(ISNUMBER(J159),K159*$O$27,$J$27)","v":""},{"$f":"IF(ISNUMBER(J159),L159-M159,$C$8)","v":""},{"$f":"IF(ISNUMBER(J159),K159-N159,$C$8)","v":""}]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,{"$f":"IF(ISNUMBER(B222),IF(($G$16-B222)>0,B222+1,$C$8),$C$8)","v":""},{"$f":"IF(ISNUMBER(B223),+G222,$C$8)","v":""},{"$f":"IF(ISNUMBER(B223),$D$30,$C$8)","v":""},{"$f":"+IF(ISNUMBER(B223),C223*$G$27,$B$27)","v":""},{"$f":"IF(ISNUMBER(B223),D223-E223,$C$8)","v":""},{"$f":"IF(ISNUMBER(B223),C223-F223,$C$8)","v":""},null,null,{"$f":"IF(ISNUMBER(J222),IF(($O$16-J222)>0,J222+1,$K$8),$C$8)","v":""},{"$f":"IF(ISNUMBER(J223),+O222,$C$8)","v":""},{"$f":"IF(ISNUMBER(J223),$L$30,$C$8)","v":""},{"$f":"+IF(ISNUMBER(J223),K223*$O$27,$J$27)","v":""},{"$f":"IF(ISNUMBER(J223),L223-M223,$C$8)","v":""},{"$f":"IF(ISNUMBER(J223),K223-N223,$C$8)","v":""}]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,{"$f":"IF(ISNUMBER(B286),IF(($G$16-B286)>0,B286+1,$C$8),$C$8)","v":""},{"$f":"IF(ISNUMBER(B287),+G286,$C$8)","v":""},{"$f":"IF(ISNUMBER(B287),$D$30,$C$8)","v":""},{"$f":"+IF(ISNUMBER(B287),C287*$G$27,$B$27)","v":""},{"$f":"IF(ISNUMBER(B287),D287-E287,$C$8)","v":""},{"$f":"IF(ISNUMBER(B287),C287-F287,$C$8)","v":""},null,null,{"$f":"IF(ISNUMBER(J286),IF(($O$16-J286)>0,J286+1,$K$8),$C$8)","v":""},{"$f":"IF(ISNUMBER(J287),+O286,$C$8)","v":""},{"$f":"IF(ISNUMBER(J287),$L$30,$C$8)","v":""},{"$f":"+IF(ISNUMBER(J287),K287*$O$27,$J$27)","v":""},{"$f":"IF(ISNUMBER(J287),L287-M287,$C$8)","v":""},{"$f":"IF(ISNUMBER(J287),K287-N287,$C$8)","v":""}]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,{"$f":"IF(ISNUMBER(B350),IF(($G$16-B350)>0,B350+1,$C$8),$C$8)","v":""},{"$f":"IF(ISNUMBER(B351),+G350,$C$8)","v":""},{"$f":"IF(ISNUMBER(B351),$D$30,$C$8)","v":""},{"$f":"+IF(ISNUMBER(B351),C351*$G$27,$B$27)","v":""},{"$f":"IF(ISNUMBER(B351),D351-E351,$C$8)","v":""},{"$f":"IF(ISNUMBER(B351),C351-F351,$C$8)","v":""},null,null,{"$f":"IF(ISNUMBER(J350),IF(($O$16-J350)>0,J350+1,$K$8),$C$8)","v":""},{"$f":"IF(ISNUMBER(J351),+O350,$C$8)","v":""},{"$f":"IF(ISNUMBER(J351),$L$30,$C$8)","v":""},{"$f":"+IF(ISNUMBER(J351),K351*$O$27,$J$27)","v":""},{"$f":"IF(ISNUMBER(J351),L351-M351,$C$8)","v":""},{"$f":"IF(ISNUMBER(J351),K351-N351,$C$8)","v":""}]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]
[null,"","","","","","",null,null,"","","","","",""]