{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SOLICITUD","TABLA AMORTIZACION","DCTOS G REAL","PARAMETROS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":21,"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":"SOLICITUD","index":0,"n_rows":82,"n_cols":12,"rows_kept":82,"cut":false,"hidden":false,"merged":[[46,6,46,11],[50,5,58,11],[44,5,44,11],[45,5,45,11],[12,17,13,18],[2,8,3,11],[6,9,9,9],[10,9,13,9],[20,5,29,5],[42,9,42,11],[18,9,21,9],[6,5,19,5],[14,9,17,9],[32,7,32,9],[31,7,31,9],[33,7,33,12],[70,5,70,12],[34,5,34,12],[80,4,80,7],[81,4,81,7],[80,8,80,10],[80,11,80,12],[81,8,81,10],[81,11,81,12],[59,5,64,11],[36,11,36,12],[37,11,37,12],[38,11,38,12],[39,11,39,12],[40,9,40,12],[65,5,69,11]]}
[]
[]
[null,null,null,null,null,null,null,null,"LIBRANZA - SOLICITUD DE CREDITO"]
[]
[null,null,null,null,null,null,null,null,null,null,"Fecha de diligenciamiento",{"$f":"+TODAY()","v":"2020-06-08"}]
[]
[null,null,null,null,null,"INFORMACION DEUDOR","IDENTIFICACION N°:",null,null,"INGRESOS","SALARIOS / COMPENSACIONES"]
[null,null,null,null,null,null,"APELLIDOS-NOMBRES:",null,null,null,"PRIMAS REGULARES "]
[null,null,null,null,null,null,"CUENTA N°:",null,true,null,"OTROS"]
[null,null,null,null,null,null,"TIPO DE CUENTA:  ",null,null,null,"TOTAL INGRESOS MENSUALES",{"$f":"+SUM(L7:L9)","v":0}]
[null,null,null,null,null,null,"ENTIDAD FINANCIERA: ",null,null,"GASTOS","GASTOS FAMILIARES"]
[null,null,null,null,null,null,"TITULAR:",null,null,null,"CUOTAS CREDITOS"]
[null,null,null,null,null,null,"CC TITULAR:",null,null,null,"OTROS"]
[null,null,null,null,null,null,"EMPRESA:",null,null,null,"TOTAL EGRESOS MENSUALES",{"$f":"+SUM(L11:L13)","v":0}]
[null,null,null,null,null,null,"TIPO DE CONTRATO:",null,null,"ACTIVOS","DISPONIBLE (EFECTIVO - BANCOS - C X C)"]
[null,null,null,null,null,null,"DIR. DOMICILIO:",null,null,null,"BIENES (INMUEBLES - VEHICULOS)"]
[null,null,null,null,null,null,"TEL - CELULAR:",null,null,null,"OTROS (EQUIPOS - MAQUINAS - OTROS)"]
[null,null,null,null,null,null,"E-MAIL:",null,null,null,"TOTAL  A C T I V O S",{"$f":"+SUM(L15:L17)","v":0}]
[null,null,null,null,null,null,"REF. PERSONAL:",null,null,"PASIVOS","TARJETAS DE CREDITO"]
[null,null,null,null,null,null,"TEL - CELULAR:",null,null,null,"OBLIGACIONES HIPOTECARIAS"]
[null,null,null,null,null,"CODEUDORES","NOMBRES:",null,null,null,"OTRAS OBLIGACIONES"]
[null,null,null,null,null,null,"C.C.                                ",null,null,null,"TOTAL  P A S I V O S",{"$f":"+SUM(L19:L21)","v":0}]
[null,null,null,null,null,null,"DIRECCION:"]
[null,null,null,null,null,null,"TEL - CELULAR:",null,null,null,"VALOR DEL CREDITO"]
[null,null,null,null,null,null,"E-MAIL:",null,null,null,"PLAZO DE CUOTAS"]
[null,null,null,null,null,null,"NOMBRES:",null,null,null,"MESES DE GRACIA"]
[null,null,null,null,null,null,"C.C.                                ",null,null,null,"TASA DE INTERES"]
[null,null,null,null,null,null,"DIRECCION:",null,null,null,"VALOR CUOTA",{"$f":"+ROUND(IFERROR(PMT(L27,L25,-L24),0),0)","v":0}]
[null,null,null,null,null,null,"TEL - CELULAR:",null,null,null,"SUMATORIA CUOTAS",{"$f":"(L28*L25)+(L24*PGRACIA*L27)","v":0}]
[null,null,null,null,null,null,"E-MAIL:",null,null,null,null,{"$f":"+IF(AND(BORRA7=\"\",L24<>\"\"),\"FALTA COLOCAR FECHA\",\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"+IF(AND(H32=PARAMETROS!A4,SOLICITUD!H33=PARAMETROS!C1),\"VALIDE EL TIPO DE GARANTIA\",\"\")","v":""},null,null,"Primer pago"]
[null,null,null,null,null,"LINEA DE CREDITO",null,null,null,null,"Primera cuota completa",{"$f":"+IF(DAY(DATE(YEAR(L31),MONTH(L31)+1+PGRACIA,))>30,DATE(YEAR(L31),MONTH(L31)+PGRACIA,30),DATE(YEAR(L31),MONTH(L31)+1+PGRACIA,))","v":"1900-01-30"}]
[null,null,null,null,null,"TIPO DE GARANTIA"]
[null,null,null,null,null,"VALOR EN LETRAS",null,{"$f":"+LETRAS(L24,1)","v":" PESOS 00/100 M.Cte."}]
[null,null,null,null,null,{"$f":"+\"TASA DE INTERES REMUNERATORIA: Nominal \"&TEXT(L27*12,\"#,##%\")&\"M.V. (\"&TEXT(EFFECT(L27*12,12),\"#,##%\")&\" E.A.)  TASA DE INTERES DE MORA: Nominal 24% M.V. (26,8242% E.A.)\"","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,{"$f":"+\"DATOS DE GARANTIA \"&PARAMETROS!C2","v":"DATOS DE GARANTIA REAL - PIGNORACION DE VEHICULO Y APORTES SOCIALES"},null,null,null,{"$f":"+\"DATOS DE GARANTIA \"&PARAMETROS!C3","v":"DATOS DE GARANTIA REAL - HIPOTECA DE INMUEBLE Y APORTES SOCIALES"}]
[null,null,null,null,null,"MARCA:",null,null,null,"TIPO DE INMUEBLE:"]
[null,null,null,null,null,"PLACA:",null,null,null,"MATRICULA INMOBILIARIA:"]
[null,null,null,null,null,"MODELO:",null,null,null,"CEDULA CATASTRAL:"]
[null,null,null,null,null,"TIPO / LINEA:",null,null,null,"DIRECCION DEL PREDIO:"]
[null,null,null,null,null,"MOTOR/CHASIS/SERIE"]
[]
[null,null,null,null,null,"DECLARAMOS QUE EL ORIGEN DE NUESTROS INGRESOS O RECURSOS PROVIENEN DE:"]
[]
[null,null,null,null,null,"AUTORIZACION DE DESEMBOLSO A TERCERO (Aplica siempre y cuando se cumpla lo señalado en el articulo 879 del Estatuto Tributario)"]
[null,null,null,null,null,"Se debe soportar que destine el crédito a adquisición de vivienda, vehículos o activos fijos y el beneficiario (tercero) del giro sea el vendedor."]
[null,null,null,null,null,null,"Bajo mi absoluta responsabilidad autorizo a ACTIVACOOP NIT 830.067.197-1 para girar los valores a:"]
[null,null,null,null,null,null,"TITULAR:",null,null,null,"TIPO y N° DE CUENTA:  "]
[null,null,null,null,null,null,"CC TITULAR:",null,null,null,"ENTIDAD FINANCIERA: "]
[]
[null,null,null,null,null,{"$f":"+\"En mi condición de DEUDOR o CODEUDOR, autorizo al pagador de  \"&H14&\",  a retener  de mi salario, compensaciones  o ingreso mensual que devengo y entregar  a  ACTIVACOOP, NIT 830.067.197-1 a su orden  la cantidad de \"&LETRAS(L25,5)&\" \"&L25&\" cuotas mensuales, cada una por un valor de \"&+LETRAS(L28,1)&\" (\"&TEXT(L28,\"$#.#\")&\"), más \"&LETRAS(L26,5)&\" (\"&L26&\") meses de gracia por solo los intereses de acuerdo con el plan de pagos.\"&\"     Las cuotas  deberán ser descontadas del salario o pagos por cualquier concepto a mi favor a partir del mes de \"&TEXT(L31,\"mmmm\")&\" del año \"&YEAR(L31)&\" y giradas a ACTIVACOOP a más tardar los ocho (8) primeros días del mes siguiente a cada uno de los descuentos. \"&+\"En caso de que por cualquier motivo el  Pagador no realice  el descuento por nómina, AUTORIZO(AMOS)  a ACTIVACOOP y/o a la entidad Financiera en la cual el Pagador consigna los salarios (\"&H11&\") o cualquier entidad financiera donde sea(mos) titular(es) de una cuenta, para que debite (retire) de nuestras cuentas bancarias los valores correspondientes y sean entregados a ACTIVACOOP en forma inmediata.\"&\"  En caso de no poderse descontar de nómina o de mi cuenta, me(nos) comprometo a cancelar consignando en las cuentas  que ACTIVACOOP designe en entidades financieras o mediante el boton de pagos PSE.\"","v":"En mi condición de DEUDOR o CODEUDOR, autorizo al pagador de  ,  a retener  de mi salario, compensaciones  o ingreso mensual que devengo y entregar  a  ACTIVACOOP, NIT 830.067.197-1 a su orden  la cantidad de   cuotas mensuales, cada una por un valor de  PESOS 00/100 M.Cte. ($), más  () meses de gracia por solo los intereses de acuerdo con el plan de pagos.     Las cuotas  deberán ser descontadas del salario o pagos por cualquier concepto a mi favor a partir del mes de enero del año 1900 y giradas a ACTIVACOOP a más tardar los ocho (8) primeros días del mes siguiente a cada uno de los descuentos. En caso de que por cualquier motivo el  Pagador no realice  el descuento por nómina, AUTORIZO(AMOS)  a ACTIVACOOP y/o a la entidad Financiera en la cual el Pagador consigna los salarios () o cualquier entidad financiera donde sea(mos) titular(es) de una cuenta, para que debite (retire) de nuestras cuentas bancarias los valores correspondientes y sean entregados a ACTIVACOOP en forma inmediata.  En caso de no poderse descontar de nómina o de mi cuenta, me(nos) comprometo a cancelar consignando en las cuentas  que ACTIVACOOP designe en entidades financieras o mediante el boton de pagos PSE."}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"+\"Igualmente autorizo al pagador de \"&H14&\" o de cualquier Persona Juridica o Persona Natural donde me encuentre vinculado,  a descontar de mis cesantías, intereses de cesantías, prima de servicios, vacaciones,\"&\" bonificaciones, auxilio de transporte, indemnizaciones, auxilios o beneficios extralegales, compensaciones\"&\", honorarios y en general de cualquier concepto que deba cancelarme, para entregar a ACTIVACOOP los saldos pendientes  por capital, interés, gastos que ocasione el cobro y cualquier otro concepto que adeude a ACTIVACOOP cuando me retire de ACTIVACOOP \"&\"o termine mi contrato laboral.   También ACTIVACOOP queda autorizado para realizar el descuento al CODEUDOR Y/O CODEUDORES, asi como aplicar el sado de nuestros aportes sociales o cualquier otro derecho economico a nuestro favor.\"","v":"Igualmente autorizo al pagador de  o de cualquier Persona Juridica o Persona Natural donde me encuentre vinculado,  a descontar de mis cesantías, intereses de cesantías, prima de servicios, vacaciones, bonificaciones, auxilio de transporte, indemnizaciones, auxilios o beneficios extralegales, compensaciones, honorarios y en general de cualquier concepto que deba cancelarme, para entregar a ACTIVACOOP los saldos pendientes  por capital, interés, gastos que ocasione el cobro y cualquier otro concepto que adeude a ACTIVACOOP cuando me retire de ACTIVACOOP o termine mi contrato laboral.   También ACTIVACOOP queda autorizado para realizar el descuento al CODEUDOR Y/O CODEUDORES, asi como aplicar el sado de nuestros aportes sociales o cualquier otro derecho economico a nuestro favor."}]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Autorizo a  ACTIVACOOP o a quien represente sus derechos u ostente en el futuro la calidad de acreedor a reportar, procesar, solicitar y divulgar a la Central de Información Financiera que administra la Asociación Bancaria y de Entidades Financieras de Colombia (CIFIN, TRANSUNION), o cualquier otra entidad que maneje o administre base de datos con los mismos fines como DATACREDITO O EXPERIAN, entre otras, toda la información referente a mi comportamiento comercial.  Lo anterior implica que el cumplimiento o incumplimiento de mis obligaciones se reflejará en las mencionadas bases de datos, en donde se consignan de manera completa, todos los datos referentes a mi actual y pasado comportamiento frente al sector financiero y, en general, frente al cumplimiento de mis obligaciones."]
[]
[]
[]
[]
[null,null,null,null,null,"NOTA: EL PREPAGO (PAGO ANTICIPADO) NO GENERA SANCION O RECARGO ADICIONAL; PERO, LOS ABONOS A CAPITAL PODRÁN ACTUALIZAR LA TASA A LA DEL REGLAMENTO DE CREDITO VIGENTE PARA LA LINEA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"EMPRESA O CENTRO DE RECAUDO:",null,null,null,"FECHA DE RECEPCION:"]
[null,null,null,null,null,null,null,null,"FUNCIONARIO QUE RECIBE:"]

{"sheet":"TABLA AMORTIZACION","index":1,"n_rows":90,"n_cols":10,"rows_kept":90,"cut":false,"hidden":false,"merged":[[3,2,3,9],[2,2,2,9]]}
[]
[]
[null,null,"TABLA DE AMORTIZACION - PLAN DE PAGOS"]
[null,null,{"$f":"+SOLICITUD!F32&\" \"&SOLICITUD!H32","v":"LINEA DE CREDITO "}]
[null,null,{"$f":"+SOLICITUD!H8&\" ID N°: \"&TEXT(SOLICITUD!H7,\"#.#\")","v":" ID N°: "}]
[]
[null,null,"Valor Solicitado",null,null,null,{"$f":"+SOLICITUD!L24","v":0},null,{"$f":"+G8*12","v":0},"NMV"]
[null,null,"Interes Mensual",null,null,null,{"$f":"+SOLICITUD!L27","v":0},null,{"$f":"+EFFECT(I7,129)","v":{"$error":"#NUM!"}},"E.A."]
[null,null,"Cuotas credito",null,null,null,{"$f":"+SOLICITUD!L25","v":0}]
[null,null,"Meses de gracia",null,null,null,{"$f":"+SOLICITUD!L26","v":0}]
[null,null,"Periodos total",null,null,null,{"$f":"+G9+G10","v":0}]
[]
[null,null,"PERIODO","TIPO","FECHA","CUOTA","AMORTIZACION ","INTERES","SALDO","Pago %"]
[null,null,0,null,null,null,null,null,{"$f":"+G7","v":0},{"$f":"+IF(C14<=$G$9,1-(I14/$I$14),\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(C14<$G$11,1+C14,IF(C14=$G$11,\"TOTALES\",\"\"))","v":"TOTALES"},{"$f":"IF(C15=\"\",\"\",IF(C14=$G$11,\"\",IF(AND(C15>$G$10,I14>=1),\"CUOTA\",\"Gracia\")))","v":""},{"$f":"IF(C15=\"\",\"\",SOLICITUD!L31)","v":"00:00:00"},{"$f":"IF(C15=\"\",\"\",IF(C14=$G$11,SUM($F$14:F14),IF(AND(C15>$G$10,I14>=1),+SOLICITUD!$L$28,H15)))","v":0},{"$f":"IF(C15=\"\",\"\",IF(C14=$G$11,SUM(G14:$G$14),IF(C15=$G$11,I14,+F15-H15)))","v":0},{"$f":"IF(C15=\"\",\"\",IF(C14=$G$11,SUM(H$14:$H14),IF(C15=$G$11,F15-G15,+I14*$G$8)))","v":0},{"$f":"IF(C15=\"\",\"\",IF(C14=$G$11,\"\",I14-G15))","v":""},{"$f":"+IF(C15<=$G$11,1-(I15/$I$14),\"\")","v":""}]
[null,null,{"$f":"IF(C15<$G$11,1+C15,IF(C15=$G$11,\"TOTALES\",\"\"))","v":""},{"$f":"IF(C16=\"\",\"\",IF(C15=$G$11,\"\",IF(AND(C16>$G$10,I15>=1),\"CUOTA\",\"Gracia\")))","v":""},{"$f":"IF(C16=\"\",\"\",IF(C15=$G$11,\"\",IF(DAY(DATE(YEAR($E$15),MONTH($E$15)+C16,))>30,DATE(YEAR($E$15),MONTH($E$15)+C15,30),DATE(YEAR($E$15),MONTH($E$15)+C16,))))","v":""},{"$f":"IF(C16=\"\",\"\",IF(C15=$G$11,SUM($F$14:F15),IF(AND(C16>$G$10,I15>=1),+SOLICITUD!$L$28,H16)))","v":""},{"$f":"IF(C16=\"\",\"\",IF(C15=$G$11,SUM(G$14:$G15),IF(C16=$G$11,I15,+F16-H16)))","v":""},{"$f":"IF(C16=\"\",\"\",IF(C15=$G$11,SUM(H$14:$H15),IF(C16=$G$11,F16-G16,+I15*$G$8)))","v":""},{"$f":"IF(C16=\"\",\"\",IF(C15=$G$11,\"\",I15-G16))","v":""},{"$f":"+IF(C16<=$G$11,1-(I16/$I$14),\"\")","v":""}]
[null,null,"","",{"$f":"IF(C17=\"\",\"\",IF(C16=$G$11,\"\",IF(DAY(DATE(YEAR($E$15),MONTH($E$15)+C17,))>30,DATE(YEAR($E$15),MONTH($E$15)+C16,30),DATE(YEAR($E$15),MONTH($E$15)+C17,))))","v":""},{"$f":"IF(C17=\"\",\"\",IF(C16=$G$11,SUM($F$14:F16),IF(AND(C17>$G$10,I16>=1),+SOLICITUD!$L$28,H17)))","v":""},{"$f":"IF(C17=\"\",\"\",IF(C16=$G$11,SUM(G$14:$G16),IF(C17=$G$11,I16,+F17-H17)))","v":""},{"$f":"IF(C17=\"\",\"\",IF(C16=$G$11,SUM(H$14:$H16),IF(C17=$G$11,F17-G17,+I16*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C18=\"\",\"\",IF(C17=$G$11,SUM($F$14:F17),IF(AND(C18>$G$10,I17>=1),+SOLICITUD!$L$28,H18)))","v":""},{"$f":"IF(C18=\"\",\"\",IF(C17=$G$11,SUM(G$14:$G17),IF(C18=$G$11,I17,+F18-H18)))","v":""},{"$f":"IF(C18=\"\",\"\",IF(C17=$G$11,SUM(H$14:$H17),IF(C18=$G$11,F18-G18,+I17*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C19=\"\",\"\",IF(C18=$G$11,SUM($F$14:F18),IF(AND(C19>$G$10,I18>=1),+SOLICITUD!$L$28,H19)))","v":""},{"$f":"IF(C19=\"\",\"\",IF(C18=$G$11,SUM(G$14:$G18),IF(C19=$G$11,I18,+F19-H19)))","v":""},{"$f":"IF(C19=\"\",\"\",IF(C18=$G$11,SUM(H$14:$H18),IF(C19=$G$11,F19-G19,+I18*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C20=\"\",\"\",IF(C19=$G$11,SUM($F$14:F19),IF(AND(C20>$G$10,I19>=1),+SOLICITUD!$L$28,H20)))","v":""},{"$f":"IF(C20=\"\",\"\",IF(C19=$G$11,SUM(G$14:$G19),IF(C20=$G$11,I19,+F20-H20)))","v":""},{"$f":"IF(C20=\"\",\"\",IF(C19=$G$11,SUM(H$14:$H19),IF(C20=$G$11,F20-G20,+I19*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C21=\"\",\"\",IF(C20=$G$11,SUM($F$14:F20),IF(AND(C21>$G$10,I20>=1),+SOLICITUD!$L$28,H21)))","v":""},{"$f":"IF(C21=\"\",\"\",IF(C20=$G$11,SUM(G$14:$G20),IF(C21=$G$11,I20,+F21-H21)))","v":""},{"$f":"IF(C21=\"\",\"\",IF(C20=$G$11,SUM(H$14:$H20),IF(C21=$G$11,F21-G21,+I20*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C22=\"\",\"\",IF(C21=$G$11,SUM($F$14:F21),IF(AND(C22>$G$10,I21>=1),+SOLICITUD!$L$28,H22)))","v":""},{"$f":"IF(C22=\"\",\"\",IF(C21=$G$11,SUM(G$14:$G21),IF(C22=$G$11,I21,+F22-H22)))","v":""},{"$f":"IF(C22=\"\",\"\",IF(C21=$G$11,SUM(H$14:$H21),IF(C22=$G$11,F22-G22,+I21*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C23=\"\",\"\",IF(C22=$G$11,SUM($F$14:F22),IF(AND(C23>$G$10,I22>=1),+SOLICITUD!$L$28,H23)))","v":""},{"$f":"IF(C23=\"\",\"\",IF(C22=$G$11,SUM(G$14:$G22),IF(C23=$G$11,I22,+F23-H23)))","v":""},{"$f":"IF(C23=\"\",\"\",IF(C22=$G$11,SUM(H$14:$H22),IF(C23=$G$11,F23-G23,+I22*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C24=\"\",\"\",IF(C23=$G$11,SUM($F$14:F23),IF(AND(C24>$G$10,I23>=1),+SOLICITUD!$L$28,H24)))","v":""},{"$f":"IF(C24=\"\",\"\",IF(C23=$G$11,SUM(G$14:$G23),IF(C24=$G$11,I23,+F24-H24)))","v":""},{"$f":"IF(C24=\"\",\"\",IF(C23=$G$11,SUM(H$14:$H23),IF(C24=$G$11,F24-G24,+I23*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C25=\"\",\"\",IF(C24=$G$11,SUM($F$14:F24),IF(AND(C25>$G$10,I24>=1),+SOLICITUD!$L$28,H25)))","v":""},{"$f":"IF(C25=\"\",\"\",IF(C24=$G$11,SUM(G$14:$G24),IF(C25=$G$11,I24,+F25-H25)))","v":""},{"$f":"IF(C25=\"\",\"\",IF(C24=$G$11,SUM(H$14:$H24),IF(C25=$G$11,F25-G25,+I24*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C26=\"\",\"\",IF(C25=$G$11,SUM($F$14:F25),IF(AND(C26>$G$10,I25>=1),+SOLICITUD!$L$28,H26)))","v":""},{"$f":"IF(C26=\"\",\"\",IF(C25=$G$11,SUM(G$14:$G25),IF(C26=$G$11,I25,+F26-H26)))","v":""},{"$f":"IF(C26=\"\",\"\",IF(C25=$G$11,SUM(H$14:$H25),IF(C26=$G$11,F26-G26,+I25*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C27=\"\",\"\",IF(C26=$G$11,SUM($F$14:F26),IF(AND(C27>$G$10,I26>=1),+SOLICITUD!$L$28,H27)))","v":""},{"$f":"IF(C27=\"\",\"\",IF(C26=$G$11,SUM(G$14:$G26),IF(C27=$G$11,I26,+F27-H27)))","v":""},{"$f":"IF(C27=\"\",\"\",IF(C26=$G$11,SUM(H$14:$H26),IF(C27=$G$11,F27-G27,+I26*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C28=\"\",\"\",IF(C27=$G$11,SUM($F$14:F27),IF(AND(C28>$G$10,I27>=1),+SOLICITUD!$L$28,H28)))","v":""},{"$f":"IF(C28=\"\",\"\",IF(C27=$G$11,SUM(G$14:$G27),IF(C28=$G$11,I27,+F28-H28)))","v":""},{"$f":"IF(C28=\"\",\"\",IF(C27=$G$11,SUM(H$14:$H27),IF(C28=$G$11,F28-G28,+I27*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C29=\"\",\"\",IF(C28=$G$11,SUM($F$14:F28),IF(AND(C29>$G$10,I28>=1),+SOLICITUD!$L$28,H29)))","v":""},{"$f":"IF(C29=\"\",\"\",IF(C28=$G$11,SUM(G$14:$G28),IF(C29=$G$11,I28,+F29-H29)))","v":""},{"$f":"IF(C29=\"\",\"\",IF(C28=$G$11,SUM(H$14:$H28),IF(C29=$G$11,F29-G29,+I28*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C30=\"\",\"\",IF(C29=$G$11,SUM($F$14:F29),IF(AND(C30>$G$10,I29>=1),+SOLICITUD!$L$28,H30)))","v":""},{"$f":"IF(C30=\"\",\"\",IF(C29=$G$11,SUM(G$14:$G29),IF(C30=$G$11,I29,+F30-H30)))","v":""},{"$f":"IF(C30=\"\",\"\",IF(C29=$G$11,SUM(H$14:$H29),IF(C30=$G$11,F30-G30,+I29*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C31=\"\",\"\",IF(C30=$G$11,SUM($F$14:F30),IF(AND(C31>$G$10,I30>=1),+SOLICITUD!$L$28,H31)))","v":""},{"$f":"IF(C31=\"\",\"\",IF(C30=$G$11,SUM(G$14:$G30),IF(C31=$G$11,I30,+F31-H31)))","v":""},{"$f":"IF(C31=\"\",\"\",IF(C30=$G$11,SUM(H$14:$H30),IF(C31=$G$11,F31-G31,+I30*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C32=\"\",\"\",IF(C31=$G$11,SUM($F$14:F31),IF(AND(C32>$G$10,I31>=1),+SOLICITUD!$L$28,H32)))","v":""},{"$f":"IF(C32=\"\",\"\",IF(C31=$G$11,SUM(G$14:$G31),IF(C32=$G$11,I31,+F32-H32)))","v":""},{"$f":"IF(C32=\"\",\"\",IF(C31=$G$11,SUM(H$14:$H31),IF(C32=$G$11,F32-G32,+I31*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C33=\"\",\"\",IF(C32=$G$11,SUM($F$14:F32),IF(AND(C33>$G$10,I32>=1),+SOLICITUD!$L$28,H33)))","v":""},{"$f":"IF(C33=\"\",\"\",IF(C32=$G$11,SUM(G$14:$G32),IF(C33=$G$11,I32,+F33-H33)))","v":""},{"$f":"IF(C33=\"\",\"\",IF(C32=$G$11,SUM(H$14:$H32),IF(C33=$G$11,F33-G33,+I32*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C34=\"\",\"\",IF(C33=$G$11,SUM($F$14:F33),IF(AND(C34>$G$10,I33>=1),+SOLICITUD!$L$28,H34)))","v":""},{"$f":"IF(C34=\"\",\"\",IF(C33=$G$11,SUM(G$14:$G33),IF(C34=$G$11,I33,+F34-H34)))","v":""},{"$f":"IF(C34=\"\",\"\",IF(C33=$G$11,SUM(H$14:$H33),IF(C34=$G$11,F34-G34,+I33*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C35=\"\",\"\",IF(C34=$G$11,SUM($F$14:F34),IF(AND(C35>$G$10,I34>=1),+SOLICITUD!$L$28,H35)))","v":""},{"$f":"IF(C35=\"\",\"\",IF(C34=$G$11,SUM(G$14:$G34),IF(C35=$G$11,I34,+F35-H35)))","v":""},{"$f":"IF(C35=\"\",\"\",IF(C34=$G$11,SUM(H$14:$H34),IF(C35=$G$11,F35-G35,+I34*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C36=\"\",\"\",IF(C35=$G$11,SUM($F$14:F35),IF(AND(C36>$G$10,I35>=1),+SOLICITUD!$L$28,H36)))","v":""},{"$f":"IF(C36=\"\",\"\",IF(C35=$G$11,SUM(G$14:$G35),IF(C36=$G$11,I35,+F36-H36)))","v":""},{"$f":"IF(C36=\"\",\"\",IF(C35=$G$11,SUM(H$14:$H35),IF(C36=$G$11,F36-G36,+I35*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C37=\"\",\"\",IF(C36=$G$11,SUM($F$14:F36),IF(AND(C37>$G$10,I36>=1),+SOLICITUD!$L$28,H37)))","v":""},{"$f":"IF(C37=\"\",\"\",IF(C36=$G$11,SUM(G$14:$G36),IF(C37=$G$11,I36,+F37-H37)))","v":""},{"$f":"IF(C37=\"\",\"\",IF(C36=$G$11,SUM(H$14:$H36),IF(C37=$G$11,F37-G37,+I36*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C38=\"\",\"\",IF(C37=$G$11,SUM($F$14:F37),IF(AND(C38>$G$10,I37>=1),+SOLICITUD!$L$28,H38)))","v":""},{"$f":"IF(C38=\"\",\"\",IF(C37=$G$11,SUM(G$14:$G37),IF(C38=$G$11,I37,+F38-H38)))","v":""},{"$f":"IF(C38=\"\",\"\",IF(C37=$G$11,SUM(H$14:$H37),IF(C38=$G$11,F38-G38,+I37*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C39=\"\",\"\",IF(C38=$G$11,SUM($F$14:F38),IF(AND(C39>$G$10,I38>=1),+SOLICITUD!$L$28,H39)))","v":""},{"$f":"IF(C39=\"\",\"\",IF(C38=$G$11,SUM(G$14:$G38),IF(C39=$G$11,I38,+F39-H39)))","v":""},{"$f":"IF(C39=\"\",\"\",IF(C38=$G$11,SUM(H$14:$H38),IF(C39=$G$11,F39-G39,+I38*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C40=\"\",\"\",IF(C39=$G$11,SUM($F$14:F39),IF(AND(C40>$G$10,I39>=1),+SOLICITUD!$L$28,H40)))","v":""},{"$f":"IF(C40=\"\",\"\",IF(C39=$G$11,SUM(G$14:$G39),IF(C40=$G$11,I39,+F40-H40)))","v":""},{"$f":"IF(C40=\"\",\"\",IF(C39=$G$11,SUM(H$14:$H39),IF(C40=$G$11,F40-G40,+I39*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C41=\"\",\"\",IF(C40=$G$11,SUM($F$14:F40),IF(AND(C41>$G$10,I40>=1),+SOLICITUD!$L$28,H41)))","v":""},{"$f":"IF(C41=\"\",\"\",IF(C40=$G$11,SUM(G$14:$G40),IF(C41=$G$11,I40,+F41-H41)))","v":""},{"$f":"IF(C41=\"\",\"\",IF(C40=$G$11,SUM(H$14:$H40),IF(C41=$G$11,F41-G41,+I40*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C42=\"\",\"\",IF(C41=$G$11,SUM($F$14:F41),IF(AND(C42>$G$10,I41>=1),+SOLICITUD!$L$28,H42)))","v":""},{"$f":"IF(C42=\"\",\"\",IF(C41=$G$11,SUM(G$14:$G41),IF(C42=$G$11,I41,+F42-H42)))","v":""},{"$f":"IF(C42=\"\",\"\",IF(C41=$G$11,SUM(H$14:$H41),IF(C42=$G$11,F42-G42,+I41*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C43=\"\",\"\",IF(C42=$G$11,SUM($F$14:F42),IF(AND(C43>$G$10,I42>=1),+SOLICITUD!$L$28,H43)))","v":""},{"$f":"IF(C43=\"\",\"\",IF(C42=$G$11,SUM(G$14:$G42),IF(C43=$G$11,I42,+F43-H43)))","v":""},{"$f":"IF(C43=\"\",\"\",IF(C42=$G$11,SUM(H$14:$H42),IF(C43=$G$11,F43-G43,+I42*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C44=\"\",\"\",IF(C43=$G$11,SUM($F$14:F43),IF(AND(C44>$G$10,I43>=1),+SOLICITUD!$L$28,H44)))","v":""},{"$f":"IF(C44=\"\",\"\",IF(C43=$G$11,SUM(G$14:$G43),IF(C44=$G$11,I43,+F44-H44)))","v":""},{"$f":"IF(C44=\"\",\"\",IF(C43=$G$11,SUM(H$14:$H43),IF(C44=$G$11,F44-G44,+I43*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C45=\"\",\"\",IF(C44=$G$11,SUM($F$14:F44),IF(AND(C45>$G$10,I44>=1),+SOLICITUD!$L$28,H45)))","v":""},{"$f":"IF(C45=\"\",\"\",IF(C44=$G$11,SUM(G$14:$G44),IF(C45=$G$11,I44,+F45-H45)))","v":""},{"$f":"IF(C45=\"\",\"\",IF(C44=$G$11,SUM(H$14:$H44),IF(C45=$G$11,F45-G45,+I44*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C46=\"\",\"\",IF(C45=$G$11,SUM($F$14:F45),IF(AND(C46>$G$10,I45>=1),+SOLICITUD!$L$28,H46)))","v":""},{"$f":"IF(C46=\"\",\"\",IF(C45=$G$11,SUM(G$14:$G45),IF(C46=$G$11,I45,+F46-H46)))","v":""},{"$f":"IF(C46=\"\",\"\",IF(C45=$G$11,SUM(H$14:$H45),IF(C46=$G$11,F46-G46,+I45*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C47=\"\",\"\",IF(C46=$G$11,SUM($F$14:F46),IF(AND(C47>$G$10,I46>=1),+SOLICITUD!$L$28,H47)))","v":""},{"$f":"IF(C47=\"\",\"\",IF(C46=$G$11,SUM(G$14:$G46),IF(C47=$G$11,I46,+F47-H47)))","v":""},{"$f":"IF(C47=\"\",\"\",IF(C46=$G$11,SUM(H$14:$H46),IF(C47=$G$11,F47-G47,+I46*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C48=\"\",\"\",IF(C47=$G$11,SUM($F$14:F47),IF(AND(C48>$G$10,I47>=1),+SOLICITUD!$L$28,H48)))","v":""},{"$f":"IF(C48=\"\",\"\",IF(C47=$G$11,SUM(G$14:$G47),IF(C48=$G$11,I47,+F48-H48)))","v":""},{"$f":"IF(C48=\"\",\"\",IF(C47=$G$11,SUM(H$14:$H47),IF(C48=$G$11,F48-G48,+I47*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C49=\"\",\"\",IF(C48=$G$11,SUM($F$14:F48),IF(AND(C49>$G$10,I48>=1),+SOLICITUD!$L$28,H49)))","v":""},{"$f":"IF(C49=\"\",\"\",IF(C48=$G$11,SUM(G$14:$G48),IF(C49=$G$11,I48,+F49-H49)))","v":""},{"$f":"IF(C49=\"\",\"\",IF(C48=$G$11,SUM(H$14:$H48),IF(C49=$G$11,F49-G49,+I48*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C50=\"\",\"\",IF(C49=$G$11,SUM($F$14:F49),IF(AND(C50>$G$10,I49>=1),+SOLICITUD!$L$28,H50)))","v":""},{"$f":"IF(C50=\"\",\"\",IF(C49=$G$11,SUM(G$14:$G49),IF(C50=$G$11,I49,+F50-H50)))","v":""},{"$f":"IF(C50=\"\",\"\",IF(C49=$G$11,SUM(H$14:$H49),IF(C50=$G$11,F50-G50,+I49*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C51=\"\",\"\",IF(C50=$G$11,SUM($F$14:F50),IF(AND(C51>$G$10,I50>=1),+SOLICITUD!$L$28,H51)))","v":""},{"$f":"IF(C51=\"\",\"\",IF(C50=$G$11,SUM(G$14:$G50),IF(C51=$G$11,I50,+F51-H51)))","v":""},{"$f":"IF(C51=\"\",\"\",IF(C50=$G$11,SUM(H$14:$H50),IF(C51=$G$11,F51-G51,+I50*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C52=\"\",\"\",IF(C51=$G$11,SUM($F$14:F51),IF(AND(C52>$G$10,I51>=1),+SOLICITUD!$L$28,H52)))","v":""},{"$f":"IF(C52=\"\",\"\",IF(C51=$G$11,SUM(G$14:$G51),IF(C52=$G$11,I51,+F52-H52)))","v":""},{"$f":"IF(C52=\"\",\"\",IF(C51=$G$11,SUM(H$14:$H51),IF(C52=$G$11,F52-G52,+I51*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C53=\"\",\"\",IF(C52=$G$11,SUM($F$14:F52),IF(AND(C53>$G$10,I52>=1),+SOLICITUD!$L$28,H53)))","v":""},{"$f":"IF(C53=\"\",\"\",IF(C52=$G$11,SUM(G$14:$G52),IF(C53=$G$11,I52,+F53-H53)))","v":""},{"$f":"IF(C53=\"\",\"\",IF(C52=$G$11,SUM(H$14:$H52),IF(C53=$G$11,F53-G53,+I52*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C54=\"\",\"\",IF(C53=$G$11,SUM($F$14:F53),IF(AND(C54>$G$10,I53>=1),+SOLICITUD!$L$28,H54)))","v":""},{"$f":"IF(C54=\"\",\"\",IF(C53=$G$11,SUM(G$14:$G53),IF(C54=$G$11,I53,+F54-H54)))","v":""},{"$f":"IF(C54=\"\",\"\",IF(C53=$G$11,SUM(H$14:$H53),IF(C54=$G$11,F54-G54,+I53*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C55=\"\",\"\",IF(C54=$G$11,SUM($F$14:F54),IF(AND(C55>$G$10,I54>=1),+SOLICITUD!$L$28,H55)))","v":""},{"$f":"IF(C55=\"\",\"\",IF(C54=$G$11,SUM(G$14:$G54),IF(C55=$G$11,I54,+F55-H55)))","v":""},{"$f":"IF(C55=\"\",\"\",IF(C54=$G$11,SUM(H$14:$H54),IF(C55=$G$11,F55-G55,+I54*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C56=\"\",\"\",IF(C55=$G$11,SUM($F$14:F55),IF(AND(C56>$G$10,I55>=1),+SOLICITUD!$L$28,H56)))","v":""},{"$f":"IF(C56=\"\",\"\",IF(C55=$G$11,SUM(G$14:$G55),IF(C56=$G$11,I55,+F56-H56)))","v":""},{"$f":"IF(C56=\"\",\"\",IF(C55=$G$11,SUM(H$14:$H55),IF(C56=$G$11,F56-G56,+I55*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C57=\"\",\"\",IF(C56=$G$11,SUM($F$14:F56),IF(AND(C57>$G$10,I56>=1),+SOLICITUD!$L$28,H57)))","v":""},{"$f":"IF(C57=\"\",\"\",IF(C56=$G$11,SUM(G$14:$G56),IF(C57=$G$11,I56,+F57-H57)))","v":""},{"$f":"IF(C57=\"\",\"\",IF(C56=$G$11,SUM(H$14:$H56),IF(C57=$G$11,F57-G57,+I56*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C58=\"\",\"\",IF(C57=$G$11,SUM($F$14:F57),IF(AND(C58>$G$10,I57>=1),+SOLICITUD!$L$28,H58)))","v":""},{"$f":"IF(C58=\"\",\"\",IF(C57=$G$11,SUM(G$14:$G57),IF(C58=$G$11,I57,+F58-H58)))","v":""},{"$f":"IF(C58=\"\",\"\",IF(C57=$G$11,SUM(H$14:$H57),IF(C58=$G$11,F58-G58,+I57*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C59=\"\",\"\",IF(C58=$G$11,SUM($F$14:F58),IF(AND(C59>$G$10,I58>=1),+SOLICITUD!$L$28,H59)))","v":""},{"$f":"IF(C59=\"\",\"\",IF(C58=$G$11,SUM(G$14:$G58),IF(C59=$G$11,I58,+F59-H59)))","v":""},{"$f":"IF(C59=\"\",\"\",IF(C58=$G$11,SUM(H$14:$H58),IF(C59=$G$11,F59-G59,+I58*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C60=\"\",\"\",IF(C59=$G$11,SUM($F$14:F59),IF(AND(C60>$G$10,I59>=1),+SOLICITUD!$L$28,H60)))","v":""},{"$f":"IF(C60=\"\",\"\",IF(C59=$G$11,SUM(G$14:$G59),IF(C60=$G$11,I59,+F60-H60)))","v":""},{"$f":"IF(C60=\"\",\"\",IF(C59=$G$11,SUM(H$14:$H59),IF(C60=$G$11,F60-G60,+I59*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C61=\"\",\"\",IF(C60=$G$11,SUM($F$14:F60),IF(AND(C61>$G$10,I60>=1),+SOLICITUD!$L$28,H61)))","v":""},{"$f":"IF(C61=\"\",\"\",IF(C60=$G$11,SUM(G$14:$G60),IF(C61=$G$11,I60,+F61-H61)))","v":""},{"$f":"IF(C61=\"\",\"\",IF(C60=$G$11,SUM(H$14:$H60),IF(C61=$G$11,F61-G61,+I60*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C62=\"\",\"\",IF(C61=$G$11,SUM($F$14:F61),IF(AND(C62>$G$10,I61>=1),+SOLICITUD!$L$28,H62)))","v":""},{"$f":"IF(C62=\"\",\"\",IF(C61=$G$11,SUM(G$14:$G61),IF(C62=$G$11,I61,+F62-H62)))","v":""},{"$f":"IF(C62=\"\",\"\",IF(C61=$G$11,SUM(H$14:$H61),IF(C62=$G$11,F62-G62,+I61*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C63=\"\",\"\",IF(C62=$G$11,SUM($F$14:F62),IF(AND(C63>$G$10,I62>=1),+SOLICITUD!$L$28,H63)))","v":""},{"$f":"IF(C63=\"\",\"\",IF(C62=$G$11,SUM(G$14:$G62),IF(C63=$G$11,I62,+F63-H63)))","v":""},{"$f":"IF(C63=\"\",\"\",IF(C62=$G$11,SUM(H$14:$H62),IF(C63=$G$11,F63-G63,+I62*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C64=\"\",\"\",IF(C63=$G$11,SUM($F$14:F63),IF(AND(C64>$G$10,I63>=1),+SOLICITUD!$L$28,H64)))","v":""},{"$f":"IF(C64=\"\",\"\",IF(C63=$G$11,SUM(G$14:$G63),IF(C64=$G$11,I63,+F64-H64)))","v":""},{"$f":"IF(C64=\"\",\"\",IF(C63=$G$11,SUM(H$14:$H63),IF(C64=$G$11,F64-G64,+I63*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C65=\"\",\"\",IF(C64=$G$11,SUM($F$14:F64),IF(AND(C65>$G$10,I64>=1),+SOLICITUD!$L$28,H65)))","v":""},{"$f":"IF(C65=\"\",\"\",IF(C64=$G$11,SUM(G$14:$G64),IF(C65=$G$11,I64,+F65-H65)))","v":""},{"$f":"IF(C65=\"\",\"\",IF(C64=$G$11,SUM(H$14:$H64),IF(C65=$G$11,F65-G65,+I64*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C66=\"\",\"\",IF(C65=$G$11,SUM($F$14:F65),IF(AND(C66>$G$10,I65>=1),+SOLICITUD!$L$28,H66)))","v":""},{"$f":"IF(C66=\"\",\"\",IF(C65=$G$11,SUM(G$14:$G65),IF(C66=$G$11,I65,+F66-H66)))","v":""},{"$f":"IF(C66=\"\",\"\",IF(C65=$G$11,SUM(H$14:$H65),IF(C66=$G$11,F66-G66,+I65*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C67=\"\",\"\",IF(C66=$G$11,SUM($F$14:F66),IF(AND(C67>$G$10,I66>=1),+SOLICITUD!$L$28,H67)))","v":""},{"$f":"IF(C67=\"\",\"\",IF(C66=$G$11,SUM(G$14:$G66),IF(C67=$G$11,I66,+F67-H67)))","v":""},{"$f":"IF(C67=\"\",\"\",IF(C66=$G$11,SUM(H$14:$H66),IF(C67=$G$11,F67-G67,+I66*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C68=\"\",\"\",IF(C67=$G$11,SUM($F$14:F67),IF(AND(C68>$G$10,I67>=1),+SOLICITUD!$L$28,H68)))","v":""},{"$f":"IF(C68=\"\",\"\",IF(C67=$G$11,SUM(G$14:$G67),IF(C68=$G$11,I67,+F68-H68)))","v":""},{"$f":"IF(C68=\"\",\"\",IF(C67=$G$11,SUM(H$14:$H67),IF(C68=$G$11,F68-G68,+I67*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C69=\"\",\"\",IF(C68=$G$11,SUM($F$14:F68),IF(AND(C69>$G$10,I68>=1),+SOLICITUD!$L$28,H69)))","v":""},{"$f":"IF(C69=\"\",\"\",IF(C68=$G$11,SUM(G$14:$G68),IF(C69=$G$11,I68,+F69-H69)))","v":""},{"$f":"IF(C69=\"\",\"\",IF(C68=$G$11,SUM(H$14:$H68),IF(C69=$G$11,F69-G69,+I68*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C70=\"\",\"\",IF(C69=$G$11,SUM($F$14:F69),IF(AND(C70>$G$10,I69>=1),+SOLICITUD!$L$28,H70)))","v":""},{"$f":"IF(C70=\"\",\"\",IF(C69=$G$11,SUM(G$14:$G69),IF(C70=$G$11,I69,+F70-H70)))","v":""},{"$f":"IF(C70=\"\",\"\",IF(C69=$G$11,SUM(H$14:$H69),IF(C70=$G$11,F70-G70,+I69*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C71=\"\",\"\",IF(C70=$G$11,SUM($F$14:F70),IF(AND(C71>$G$10,I70>=1),+SOLICITUD!$L$28,H71)))","v":""},{"$f":"IF(C71=\"\",\"\",IF(C70=$G$11,SUM(G$14:$G70),IF(C71=$G$11,I70,+F71-H71)))","v":""},{"$f":"IF(C71=\"\",\"\",IF(C70=$G$11,SUM(H$14:$H70),IF(C71=$G$11,F71-G71,+I70*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C72=\"\",\"\",IF(C71=$G$11,SUM($F$14:F71),IF(AND(C72>$G$10,I71>=1),+SOLICITUD!$L$28,H72)))","v":""},{"$f":"IF(C72=\"\",\"\",IF(C71=$G$11,SUM(G$14:$G71),IF(C72=$G$11,I71,+F72-H72)))","v":""},{"$f":"IF(C72=\"\",\"\",IF(C71=$G$11,SUM(H$14:$H71),IF(C72=$G$11,F72-G72,+I71*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C73=\"\",\"\",IF(C72=$G$11,SUM($F$14:F72),IF(AND(C73>$G$10,I72>=1),+SOLICITUD!$L$28,H73)))","v":""},{"$f":"IF(C73=\"\",\"\",IF(C72=$G$11,SUM(G$14:$G72),IF(C73=$G$11,I72,+F73-H73)))","v":""},{"$f":"IF(C73=\"\",\"\",IF(C72=$G$11,SUM(H$14:$H72),IF(C73=$G$11,F73-G73,+I72*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C74=\"\",\"\",IF(C73=$G$11,SUM($F$14:F73),IF(AND(C74>$G$10,I73>=1),+SOLICITUD!$L$28,H74)))","v":""},{"$f":"IF(C74=\"\",\"\",IF(C73=$G$11,SUM(G$14:$G73),IF(C74=$G$11,I73,+F74-H74)))","v":""},{"$f":"IF(C74=\"\",\"\",IF(C73=$G$11,SUM(H$14:$H73),IF(C74=$G$11,F74-G74,+I73*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C75=\"\",\"\",IF(C74=$G$11,SUM($F$14:F74),IF(AND(C75>$G$10,I74>=1),+SOLICITUD!$L$28,H75)))","v":""},{"$f":"IF(C75=\"\",\"\",IF(C74=$G$11,SUM(G$14:$G74),IF(C75=$G$11,I74,+F75-H75)))","v":""},{"$f":"IF(C75=\"\",\"\",IF(C74=$G$11,SUM(H$14:$H74),IF(C75=$G$11,F75-G75,+I74*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C76=\"\",\"\",IF(C75=$G$11,SUM($F$14:F75),IF(AND(C76>$G$10,I75>=1),+SOLICITUD!$L$28,H76)))","v":""},{"$f":"IF(C76=\"\",\"\",IF(C75=$G$11,SUM(G$14:$G75),IF(C76=$G$11,I75,+F76-H76)))","v":""},{"$f":"IF(C76=\"\",\"\",IF(C75=$G$11,SUM(H$14:$H75),IF(C76=$G$11,F76-G76,+I75*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C77=\"\",\"\",IF(C76=$G$11,SUM($F$14:F76),IF(AND(C77>$G$10,I76>=1),+SOLICITUD!$L$28,H77)))","v":""},{"$f":"IF(C77=\"\",\"\",IF(C76=$G$11,SUM(G$14:$G76),IF(C77=$G$11,I76,+F77-H77)))","v":""},{"$f":"IF(C77=\"\",\"\",IF(C76=$G$11,SUM(H$14:$H76),IF(C77=$G$11,F77-G77,+I76*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C78=\"\",\"\",IF(C77=$G$11,SUM($F$14:F77),IF(AND(C78>$G$10,I77>=1),+SOLICITUD!$L$28,H78)))","v":""},{"$f":"IF(C78=\"\",\"\",IF(C77=$G$11,SUM(G$14:$G77),IF(C78=$G$11,I77,+F78-H78)))","v":""},{"$f":"IF(C78=\"\",\"\",IF(C77=$G$11,SUM(H$14:$H77),IF(C78=$G$11,F78-G78,+I77*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C79=\"\",\"\",IF(C78=$G$11,SUM($F$14:F78),IF(AND(C79>$G$10,I78>=1),+SOLICITUD!$L$28,H79)))","v":""},{"$f":"IF(C79=\"\",\"\",IF(C78=$G$11,SUM(G$14:$G78),IF(C79=$G$11,I78,+F79-H79)))","v":""},{"$f":"IF(C79=\"\",\"\",IF(C78=$G$11,SUM(H$14:$H78),IF(C79=$G$11,F79-G79,+I78*$G$8)))","v":""},"",""]
[null,null,{"$f":"IF(C79<$G$11,1+C79,IF(C79=$G$11,\"TOTALES\",\"\"))","v":""},{"$f":"IF(C80=\"\",\"\",IF(C79=$G$11,\"\",IF(AND(C80>$G$10,I79>=1),\"CUOTA\",\"Gracia\")))","v":""},"",{"$f":"IF(C80=\"\",\"\",IF(C79=$G$11,SUM($F$14:F79),IF(AND(C80>$G$10,I79>=1),+SOLICITUD!$L$28,H80)))","v":""},{"$f":"IF(C80=\"\",\"\",IF(C79=$G$11,SUM(G$14:$G79),IF(C80=$G$11,I79,+F80-H80)))","v":""},{"$f":"IF(C80=\"\",\"\",IF(C79=$G$11,SUM(H$14:$H79),IF(C80=$G$11,F80-G80,+I79*$G$8)))","v":""},{"$f":"IF(C80=\"\",\"\",IF(C79=$G$11,\"\",I79-G80))","v":""},{"$f":"+IF(C80<=$G$11,1-(I80/$I$14),\"\")","v":""}]
[null,null,"","",{"$f":"IF(C81=\"\",\"\",IF(C80=$G$11,\"\",IF(DAY(DATE(YEAR($E$15),MONTH($E$15)+C81,))>30,DATE(YEAR($E$15),MONTH($E$15)+C80,30),DATE(YEAR($E$15),MONTH($E$15)+C81,))))","v":""},{"$f":"IF(C81=\"\",\"\",IF(C80=$G$11,SUM($F$14:F80),IF(AND(C81>$G$10,I80>=1),+SOLICITUD!$L$28,H81)))","v":""},{"$f":"IF(C81=\"\",\"\",IF(C80=$G$11,SUM(G$14:$G80),IF(C81=$G$11,I80,+F81-H81)))","v":""},{"$f":"IF(C81=\"\",\"\",IF(C80=$G$11,SUM(H$14:$H80),IF(C81=$G$11,F81-G81,+I80*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C82=\"\",\"\",IF(C81=$G$11,SUM($F$14:F81),IF(AND(C82>$G$10,I81>=1),+SOLICITUD!$L$28,H82)))","v":""},{"$f":"IF(C82=\"\",\"\",IF(C81=$G$11,SUM(G$14:$G81),IF(C82=$G$11,I81,+F82-H82)))","v":""},{"$f":"IF(C82=\"\",\"\",IF(C81=$G$11,SUM(H$14:$H81),IF(C82=$G$11,F82-G82,+I81*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C83=\"\",\"\",IF(C82=$G$11,SUM($F$14:F82),IF(AND(C83>$G$10,I82>=1),+SOLICITUD!$L$28,H83)))","v":""},{"$f":"IF(C83=\"\",\"\",IF(C82=$G$11,SUM(G$14:$G82),IF(C83=$G$11,I82,+F83-H83)))","v":""},{"$f":"IF(C83=\"\",\"\",IF(C82=$G$11,SUM(H$14:$H82),IF(C83=$G$11,F83-G83,+I82*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C84=\"\",\"\",IF(C83=$G$11,SUM($F$14:F83),IF(AND(C84>$G$10,I83>=1),+SOLICITUD!$L$28,H84)))","v":""},{"$f":"IF(C84=\"\",\"\",IF(C83=$G$11,SUM(G$14:$G83),IF(C84=$G$11,I83,+F84-H84)))","v":""},{"$f":"IF(C84=\"\",\"\",IF(C83=$G$11,SUM(H$14:$H83),IF(C84=$G$11,F84-G84,+I83*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C85=\"\",\"\",IF(C84=$G$11,SUM($F$14:F84),IF(AND(C85>$G$10,I84>=1),+SOLICITUD!$L$28,H85)))","v":""},{"$f":"IF(C85=\"\",\"\",IF(C84=$G$11,SUM(G$14:$G84),IF(C85=$G$11,I84,+F85-H85)))","v":""},{"$f":"IF(C85=\"\",\"\",IF(C84=$G$11,SUM(H$14:$H84),IF(C85=$G$11,F85-G85,+I84*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C86=\"\",\"\",IF(C85=$G$11,SUM($F$14:F85),IF(AND(C86>$G$10,I85>=1),+SOLICITUD!$L$28,H86)))","v":""},{"$f":"IF(C86=\"\",\"\",IF(C85=$G$11,SUM(G$14:$G85),IF(C86=$G$11,I85,+F86-H86)))","v":""},{"$f":"IF(C86=\"\",\"\",IF(C85=$G$11,SUM(H$14:$H85),IF(C86=$G$11,F86-G86,+I85*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C87=\"\",\"\",IF(C86=$G$11,SUM($F$14:F86),IF(AND(C87>$G$10,I86>=1),+SOLICITUD!$L$28,H87)))","v":""},{"$f":"IF(C87=\"\",\"\",IF(C86=$G$11,SUM(G$14:$G86),IF(C87=$G$11,I86,+F87-H87)))","v":""},{"$f":"IF(C87=\"\",\"\",IF(C86=$G$11,SUM(H$14:$H86),IF(C87=$G$11,F87-G87,+I86*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C88=\"\",\"\",IF(C87=$G$11,SUM($F$14:F87),IF(AND(C88>$G$10,I87>=1),+SOLICITUD!$L$28,H88)))","v":""},{"$f":"IF(C88=\"\",\"\",IF(C87=$G$11,SUM(G$14:$G87),IF(C88=$G$11,I87,+F88-H88)))","v":""},{"$f":"IF(C88=\"\",\"\",IF(C87=$G$11,SUM(H$14:$H87),IF(C88=$G$11,F88-G88,+I87*$G$8)))","v":""},"",""]
[null,null,"","","",{"$f":"IF(C89=\"\",\"\",IF(C88=$G$11,SUM($F$14:F88),IF(AND(C89>$G$10,I88>=1),+SOLICITUD!$L$28,H89)))","v":""},{"$f":"IF(C89=\"\",\"\",IF(C88=$G$11,SUM(G$14:$G88),IF(C89=$G$11,I88,+F89-H89)))","v":""},{"$f":"IF(C89=\"\",\"\",IF(C88=$G$11,SUM(H$14:$H88),IF(C89=$G$11,F89-G89,+I88*$G$8)))","v":""},"",""]
[null,null,{"$f":"IF(C89<$G$9,1+C89,IF(C89=$G$9,\"TOTALES\",\"\"))","v":""},null,null,{"$f":"IF(C90=\"\",\"\",IF(C89=$G$11,SUM($F$14:F89),IF(AND(C90>$G$10,I89>=1),+SOLICITUD!$L$28,H90)))","v":""},{"$f":"IF(C90=\"\",\"\",IF(C89=$G$9,SUM(G$14:$G89),IF(C90=$G$9,I89,+F90-H90)))","v":""},{"$f":"IF(C90=\"\",\"\",IF(C89=$G$9,SUM(H$14:$H89),IF(C90=$G$9,F90-G90,+I89*$G$8)))","v":""},{"$f":"IF(C90=\"\",\"\",IF(C89=$G$9,\"\",I89-G90))","v":""},{"$f":"+IF(C90<=$G$9,1-(I90/$I$14),\"\")","v":""}]

{"sheet":"DCTOS G REAL","index":2,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1],[9,0,9,1],[10,0,10,1]]}
["DOCUMENTOS SOLICITADOS PARA GARANTIA REAL"]
["PROCESO EN NOTARIA HIPOTECA EN PRIMER GRADO","PROCESO EN SIM Y ASEGURADORA PRENDA VEHICULO"]
["Certificado Castral (pedir en cualquier Cade)","Confirmar que el vehiculo quede asegurado antes del desembolso"]
["Paz y salvo IDU","La prenda debe quedar al respaldo a nombre de ACTIVACOOP"]
["Escrituras públicas","Si es nuevo, presentar factura proforma"]
["Certificado de libertad y tradición no superior a 30 días","Se debe elaborar contrato para modificación T.Prop. Ante el SIM"]
["Copia de la Cédula al 150%","Copia de la cédula al 150%"]
["Estudio de títulos por persona avalada por la Lonja ($200.000 aprox)"]
["Impuesto predial del año pago (debe tener al día todos los imp prediales)"]
["TODOS LOS GASTOS INCURRIDOS EN ESTE PROCESO CORREN POR CUENTA DEL ASOCIADO"]
["SI SE EL DESEMBOLSO ES A ENTIDAD DIFERENTE AL ASOCIADO, DEBE DILIGENCIAR DOC. AUTORIZACION DESEMBOLSO ADICIONAL A LOS DOCUMENTOS DEL CREDITO"]

{"sheet":"PARAMETROS","index":3,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["GERENCIA",null,"PERSONAL - PAGARÉ Y APORTES SOCIALES"]
["EDUCACION",null,"REAL - PIGNORACION DE VEHICULO Y APORTES SOCIALES"]
["ORDINARIO",null,"REAL - HIPOTECA DE INMUEBLE Y APORTES SOCIALES"]
["GARANTIA REAL",null,"REAL - OTRAS GARANTIAS Y APORTES SOCIALES"]