{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SIMULADOR DE CREDITO","CALCULO CUPO DE CREDITO","Hoja3","VERIFICACION 1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"SIMULADOR DE CREDITO","index":0,"n_rows":76,"n_cols":12,"rows_kept":76,"cut":false,"hidden":false,"merged":[[27,0,30,0],[27,1,30,1],[31,0,32,0],[31,1,32,1],[13,0,15,1],[16,0,20,1],[22,0,22,1],[23,0,24,0],[23,1,24,1],[25,0,26,0],[25,1,26,1]]}
["DESTINO DEL CREDITO","SELECCIONA TIPO DE CREDITO",null,"# PAGO","PAGO INTERES","PAGO CAPITAL","SALDO",null,null,"SELECCIONA TIPO DE CREDITO",0,0]
["MONTO DEL CREDTO",null,null,null,null,null,null,null,null,"BIENVENIDA",1.29E-2,0.1658]
["TASA DE INTERES MENSUAL",{"$f":"VLOOKUP($B$1,$J$1:$L$42,2,0)","v":0},null,null,null,null,null,null,null,"CALAMIDAD",3.0000000000000001E-3,3.6499999999999998E-2]
["NUMERO DE CUOTAS MENSUALES",null,null,null,null,null,null,null,null,"SALUD",5.0000000000000001E-3,6.1677811999999999E-2]
["VALOR DE LA CUOTA MENSUAL",{"$f":"+E2+F2","v":0},null,null,null,null,null,null,null,"EDUCACION",5.0000000000000001E-3,6.1600000000000002E-2]
["VALOR CUOTA QUINCENAL",{"$f":"B5/2","v":0},null,null,null,null,null,null,null,"VACACIONES",6.0000000000000001E-3,7.4399999999999994E-2]
["TASA DE INTERES E.A.",{"$f":"VLOOKUP($B$1,$J$1:$L$42,3,0)","v":0},null,null,null,null,null,null,null,"PAGO DE IMPUESTOS",7.0000000000000001E-3,8.7300000000000003E-2]
[null,null,null,null,null,null,null,null,null,"COMPRA DE UTILES",7.0000000000000001E-3,8.7300000000000003E-2]
[null,null,null,null,null,null,null,null,null,"FIDELIDAD",7.4999999999999997E-3,9.4799999999999995E-2]
[null,null,null,null,null,null,null,null,null,"VIVIENDA 10 AÑOS ANT 1-5 AÑOS",7.9000000000000008E-3,9.9000000000000005E-2]
[null,null,null,null,null,null,null,null,null,"VIVIENDA 10 AÑOS ANT 5-10 AÑOS",7.4000000000000003E-3,9.2499999999999999E-2]
[null,null,null,null,null,null,null,null,null,"VIVIENDA 10 AÑOS ANT MAY 10 AÑOS",6.8999999999999999E-3,8.5000000000000006E-2]
[null,null,null,null,null,null,null,null,null,"VIVIENDA 12 AÑOS ANT 1-5 AÑOS",8.8999999999999999E-3,0.11219999999999999]
["SEÑOR ASOCIADO SOLO DEBE DILIGENCIAR LOS ESPACIOS DE COLOR VERDE",null,null,null,null,null,null,null,null,"VIVIENDA 12 AÑOS ANT 5-10 AÑOS",8.3999999999999995E-3,0.1056]
[null,null,null,null,null,null,null,null,null,"VIVIENDA 12 AÑOS ANT MAY 10 AÑOS",7.9000000000000008E-3,9.9000000000000005E-2]
[null,null,null,null,null,null,null,null,null,"VEHICULO UNICO CREDITO",8.8000000000000005E-3,0.1052]
["LOS ESPACIOS DE COLOR AZUL LE INFORMARÁN LA TASA DEL CREDITO Y EL VALOR DE LA CUOTA MENSUAL",null,null,null,null,null,null,null,null,"VEHICULO CON SEGUNDO CREDITO VEHICULO",9.7000000000000003E-3,0.11840000000000001]
[null,null,null,null,null,null,null,null,null,"COMPUTADOR",1.2500000000000001E-2,0.16070000000000001]
[null,null,null,null,null,null,null,null,null,"COMPRA DE CARTERA 36",9.1000000000000004E-3,0.11509999999999999]
[null,null,null,null,null,null,null,null,null,"COMPRA DE CARTERA 48",9.9000000000000008E-3,0.12520000000000001]
[null,null,null,null,null,null,null,null,null,"REMODELACION DE VIVIENDA 36",8.9999999999999993E-3,0.1268]
[null,null,null,null,null,null,null,null,null,"REMODELACION DE VIVIENDA 48",0.01,0.14019999999999999]
["INSTRUCCIONES",null,null,null,null,null,null,null,null,"REMODELACION DE VIVIENDA CON GARANTIA",7.7999999999999996E-3,9.7699999999999995E-2]
["DESTINO DE CREDITO","Seleccione en la lista desplegable el destino del credito  por el cual esta interesado",null,null,null,null,null,null,null,"PROMOCIONAL",1.29E-2,0.1658]
[null,null,null,null,null,null,null,null,null,"LIBRE INVERSION 12 MESES ANT 3MES",1.2500000000000001E-2,0.16070000000000001]
["MONTO DEL CREDITO","Escriba el valor del credito que desea solicitar",null,null,null,null,null,null,null,"LIBRE INVERSION 12 MESES ANT > 3AÑOS",1.2E-2,0.15379999999999999]
[null,null,null,null,null,null,null,null,null,"LIBRE INVERSION 12 MESES ANT > 6AÑOS",1.15E-2,0.14699999999999999]
["NUMERO DE CUOTAS MENSUALES","Escriba el numero de meses en los que desea pagar el credito( Tenga en cuenta el plazo maximo permitido para el tipo de credito que solicita)",null,null,null,null,null,null,null,"LIBRE INVERSION 12 MESES ANT > 9AÑOS",1.0999999999999999E-2,0.14019999999999999]
[null,null,null,null,null,null,null,null,null,"LIBRE INVERSION 24 MESES ANT 3MES",1.2999999999999999E-2,0.1676]
[null,null,null,null,null,null,null,null,null,"LIBRE INVERSION 24 MESES ANT > 3AÑOS",1.2500000000000001E-2,0.16070000000000001]
[null,null,null,null,null,null,null,null,null,"LIBRE INVERSION 24 MESES ANT > 6AÑOS",1.2E-2,0.15379999999999999]
["DESTINO DE CREDITO","Seleccione en la lista desplegable el destino del credito  por el cual esta interesado",null,null,null,null,null,null,null,"LIBRE INVERSION 24 MESES ANT > 9AÑOS",1.15E-2,0.14699999999999999]
[null,null,null,null,null,null,null,null,null,"LIBRE INVERSION 36 MESES ANT 3MES",1.35E-2,0.17449999999999999]
[null,null,null,null,null,null,null,null,null,"LIBRE INVERSION 36 MESES ANT > 3AÑOS",1.2999999999999999E-2,0.1676]
[null,null,null,null,null,null,null,null,null,"LIBRE INVERSION 36 MESES ANT > 6AÑOS",1.2500000000000001E-2,0.16700000000000001]
["TIPO DE CREDITO","PLAZO MAXIMO EN MESES",null,null,null,null,null,null,null,"LIBRE INVERSION 36 MESES ANT > 9AÑOS",1.2E-2,0.15379999999999999]
["VEHICULO",60,null,null,null,null,null,null,null,"LIBRE INVERSION 48 MESES ANT 3MES",1.4E-2,0.18149999999999999]
["VIVIENDA",120,null,null,null,null,null,null,null,"LIBRE INVERSION 48 MESES ANT > 3AÑOS",1.35E-2,0.17449999999999999]
["EDUCACION",36,null,null,null,null,null,null,null,"LIBRE INVERSION 48 MESES ANT > 6AÑOS",1.2999999999999999E-2,0.1676]
["COMPRA DE CARTERA",48,null,null,null,null,null,null,null,"LIBRE INVERSION 48 MESES ANT > 9AÑOS",1.2500000000000001E-2,0.16070000000000001]
["COMPRA DE UTILES",12,null,null,null,null,null,null,null,"CONSOLIDACION DE CARTERA 36",1.43E-2,0.18509999999999999]
["PAGO DE IMPUESTOS",12,null,null,null,null,null,null,null,"CONSOLIDACION DE CARTERA 48",1.4800000000000001E-2,0.19220000000000001]
["VACACIONES",12]
["PROMOCIONAL",12]
["COMPUTADOR",24]
["LIBRE INVERSION 12 MESES",12]
["LIBRE INVERSION 18 MESES",18]
["LIBRE INVERSION 24 MESES",24]
["LIBRE INVERSION 36 MESES",36]
["LIBRE INVERSION 48 MESES",48]
["CONSOLIDACION DE CARTERA",48]
["REMODELACION DE VIVIENDA",48]
["SALUD",24]
["FIDELIDAD",36]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CALAMIDAD",24]
["BIENVENIDA",36]

{"sheet":"CALCULO CUPO DE CREDITO","index":1,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,6],[3,0,3,1],[3,14,3,15],[13,0,14,1],[1,0,1,6],[10,5,14,6]]}
["SIMULADOR CALCULO CUPO DE CREDITO"]
["SEÑOR ASOCIADO SOLO DEBE DILIGENCIAR LOS ESPACIOS DE COLOR VERDE"]
[]
["POR FAVOR DILIGENCIE EL SALDO ACTUAL DE SU AHORRO PERMANENTE Y APORTE SOCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"TIPO DE CREDITO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALAMIDAD",3]
["AHORRO PERMANENTE",null,null,null,null,"MONTO SOLICITADO",{"$f":"+B11","v":0},null,null,null,null,null,null,null,"SALUD",3]
["APORTES SOCIALES",null,null,null,null,"CUPO DISPONIBLE",{"$f":"B31","v":0},null,null,null,null,null,null,null,"EDUCACION",5]
[null,null,null,null,null,"VALOR FALTANTE",{"$f":"IF(G7-G6<0,G7-G6,\" \")","v":" "},null,null,null,null,null,null,null,"VACACIONES ",3]
["TOTAL AHORRADO",{"$f":"B6+B7","v":0},null,null,null,"VALOR A CONSIGNAR",{"$f":"IF(G8<0,(G8/B12),\" \")","v":" "},null,null,null,null,null,null,null,"COMPRA DE UTILES ",3]
["CREDITO A SOLICITAR",null,null,null,null,null,null,null,null,null,null,null,null,null,"PAGO DE IMPUESTOS",3]
["MONTO A SOLICITAR",null,null,null,null,{"$f":"IF(G8<0,\"SI USTED TIENE ALGUN PRODUCTO DE AHORRO PROGRAMADO, A PARTE DE CDAT Y FEVIAHORRITO RECUERDE QUE ESTE LO PUEDE TRASLADAR A LOS APORTES SOCIALES PARA INCREMENTAR EL CUPO DE CREDITO\",\" \")","v":" "},null,null,null,null,null,null,null,null,"VIVIENDA",7]
["RECIPROCIDAD PARA CUPO DE PRESTAMO",{"$f":"IF(B10=O12,7,IF(B10=O11,7,IF(B10=O7,5,IF(B10=O15,4,IF(B10=O17,\"$1,232,000\",IF(B10=O16,7,\"3\"))))))","v":"3"},null,null,null,null,null,null,null,null,null,null,null,null,"VEHICULO",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMPUTADOR",3]
["POR FAVOR DILIGENCIE LOS CREDITOS QUE TIENE ACTUALMENTE CON EL FEVI Y EL SALDO ACTUAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"COMPRA DE UTILES",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COMPRA DE CARTERA",4]
["TIPO DE CREDITO","SALDO DEL CREDITO",null,null,null,null,null,null,null,null,null,null,null,null,"REMODELACION DE VIVIENDA",7]
[null,null,{"$f":"IF(A17=$O$12,7,IF(A17=$O$11,7,IF(A17=$O$16,7,IF(A17=$O$7,5,IF(A17=$O$15,4,IF(A17=$O$17,\"N/A\",\"3\"))))))","v":"3"},{"$f":"IF(A17=\"PROMOCIONAL\",\"0\",B17/C17)","v":0},null,null,null,null,null,null,null,null,null,null,"PROMOCIONAL"]
[null,null,"3",{"$f":"IF(A18=\"PROMOCIONAL\",\"0\",B18/C18)","v":0},null,null,null,null,null,null,null,null,null,null,"ORDINARIO",3]
[null,null,"3",0,null,null,null,null,null,null,null,null,null,null,"CONSOLIDACION DE CARTERA",3]
[null,null,"3",0,null,null,null,null,null,null,null,null,null,null,"CODEUDORES",3]
[null,null,"3",0,null,null,null,null,null,null,null,null,null,null,"TARJETA DE CREDITO",3]
[null,null,"3",0]
[null,null,"3",0]
[null,null,"3",0]
[null,null,"3",0]
[]
[]
[]
["APORTES USADOS",{"$f":"SUM(D17:D25)","v":0},null," "]
["AHORRO DISPONIBLE",{"$f":"B9-B29","v":0}]
["CREDITO DISPONIBLE",{"$f":"B30*B12","v":0}]

{"sheet":"Hoja3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"VERIFICACION 1","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,"LINEA DE CREDITO","CUOTAS","MONTO 1","LINIX","SIMULADOR","AYUDA VENTAS"]
[null,"SALUD",24,5000000,221603,209420.13551095381,221600,{"$f":"E3-F3","v":12182.864489046187}]
[null,"COMPRA CARTERA",36,14000000,458011,394368.80076012295,452060,{"$f":"E4-F4","v":63642.199239877053}]
[null,"LIBRE INVERSION 48 MESES ANT > 6AÑOS",48,6000000,170657,128345.84626833102,170640,42311.153731668979]
[null,"VACACIONES",12,2500000,216547,209011.03717090099,216550,7535.9628290990076]
[null,"VEHICULO UNICO CREDITO",60,25000000,537967,426053.28786467935,531750,111913.71213532065]
[]
[null,"LINEA DE CREDITO","CUOTAS QUINCENALES","MONTO 2","LINIX","SIMULADOR","AYUDA VENTAS"]
[null,"SALUD",24,8500000,376725,356014.23036862147,376720,{"$f":"E10-F10","v":20710.769631378527}]
[null,"COMPRA CARTERA",36,17500000,556156,492961.00095015357,565075,{"$f":"E11-F11","v":63194.999049846432}]
[null,"LIBRE INVERSION 48 MESES ANT > 6AÑOS",48,9500000,270207,203214.25659152411,270180,66992.743408475886]
[null,"VACACIONES",12,6000000,519714,501626.48921016249,519720,18087.510789837514]
[null,"VEHICULO UNICO CREDITO",60,28500000,613282,485700.74816573446,606195,127581.25183426554]