{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Hoja Control de Cambios","Instructivo","Base de datos","Formato -Imprimir","tabla","inicial","APLICA TDJ-"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Hoja Control de Cambios","index":0,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":true,"merged":[[21,0,22,19],[21,20,22,23],[19,0,19,1],[19,2,19,4],[18,2,18,4],[18,5,18,7],[18,8,18,16],[18,17,18,19],[18,20,18,23],[18,0,18,1],[19,5,19,7],[19,8,19,16],[19,17,19,19],[19,20,19,23],[17,8,17,16],[17,17,17,19],[17,5,17,7],[12,0,12,3],[12,4,12,9],[12,10,12,16],[12,17,12,23],[15,0,15,23],[17,20,17,23],[17,0,17,1],[17,2,17,4],[9,0,9,3],[9,4,9,9],[9,10,9,16],[9,17,9,23],[10,0,11,3],[10,4,11,9],[10,10,11,16],[10,17,11,23],[0,0,4,3],[0,4,4,16],[0,17,4,23],[6,0,6,23],[8,0,8,3],[8,4,8,9],[8,10,8,16],[8,17,8,23]]}
["\nGF-FOR-017",null,null,null,"FORMATO \nSOLICITUD DE CONFIRMACIÓN \nDE DEPÓSITOS"]
[]
[]
[]
[]
[]
["HOJA DE APROBACION"]
[]
[null,null,null,null,"Preparado por:",null,null,null,null,null,"Revisado por:",null,null,null,null,null,null,"Aprobado por:"]
["Nombre:",null,null,null,"Eliana Cherley Reyes Garcia\nBlanca I. Garzón Sanchéz",null,null,null,null,null,"Sandra Forero Castillo",null,null,null,null,null,null,"Sandra Forero Castillo"]
["Cargo:",null,null,null,"Profesional Especializado Subdirección Financiera\nProfesional Especializado Subdirección Financiera",null,null,null,null,null,"Subdirectora Financiera",null,null,null,null,null,null,"Subdirectora Financiera"]
[]
["Fecha",null,null,null,"  25/05/2016",null,null,null,null,null,"  26/05/2016",null,null,null,null,null,null,"  26/05/2016"]
[]
[]
["HOJA DE CONTROL DE CAMBIOS"]
[]
["Versión",null,"Acción",null,null,"Fecha",null,null,"Descripción de la acción",null,null,null,null,null,null,null,null,"Numeral",null,null,"Responsable"]
["1.0.",null,"Creación",null,null,"2014-09-17",null,null,"Creación del Formato",null,null,null,null,null,null,null,null,"Todos",null,null,"Lina María Arias A.\nEdgar Cobos Parra"]
["2.0",null,"Modificación",null,null,"  26/05/2016",null,null,"En el Formato Confirmación de Depósitos se eliminan las columnas: # de Imputación Presupuestal, # de Causación y Documento Contable.\nEn el formato solicitud de Confirmación de Depósitos se agregan las columnas:\nRegistro de Recuado y # de Causación.",null,null,null,null,null,null,null,null,"Todos",null,null,"Eliana C. Reyes García\nEdgar Cobos Parra"]
[]
["Antes de usar este documento revise el listado maestro  de documentos y verifique que esta es la última versión.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AP-FOR-004 V 1.1"]

{"sheet":"Instructivo","index":1,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Instrucciones Generales"]
[null,"Diligenciar Incialmente la Hoja \"Base de datos\""]
[null,"La base de datos alimentara la Hoja \"Formato - Imprimir\""]
[null,"La confirmación debe enviarse via e-mail, identificando el asunto con la denominación  \"CONFIRMACION DEPOSITOS\""]
[null,"El formato- Imprimir  esta diseñada para el registro de máximo 10 recaudos.  Si excede este tope favor llenar el número de solicitudes que requiera"]
[]
[]
["Base de Datos"]
[1,"FECHA DE SOLICITUD","Diligenciar fecha del dia cuando se solicita la confirmación de saldos"]
[2,"N°","Secuencia que identifica la discriminación del recaudo, cada cambio de secuencia significa una nuevo recaudo a identificar."]
[3,"TIPO DE RECAUDO","Escoger el tipo de recaudo según la lista desplegable, cada formato se debera diligenciar por un unico tipo de recaudo"]
[4,"NIT/ CC","Diligenciar el Número de identificación tributaria que tiene la persona "]
[5,"RAZON SOCIAL/ NOMBRE","Diligenciar el nombre de la persona natural o razón social de la persona Juridica que realiza el abono."]
[6,"CUENTA BANCARIA","Diligenciar el Número de la cuenta bancaria a la cual se realizo el abono"]
[7,"FECHA DE CONSIGNAC.","Fecha real del abono en el banco"]
[8,"VALOR TOTAL ","NO modificar campo formulado"]
[9,"CAPITAL","Diligenciar la proporcion del abono que corresponde a este concepto"]
[10,"INTERESES","Diligenciar la proporcion del abono que corresponde a este concepto"]
[11,"EXCESOS","Diligenciar el monto consignado de mas por la persona que realiza el recaudo suceptible de devolución"]
[12,"DOCUMENTO TERCERO","Diligenciar el Número de identificación del tercero a afectar"]
[13,"TERCERO A AFECTAR","Diligenciar el nombre del tercero al cual se le va aplicar el abono"]
[14,"PERIODO PAGADO","Diligencie si el abono correponde a un periodo en especifico"]
[15," C x C  /  OBSERVACIONES","Notas adicionales del abono"]
[]
[]
["Formato-Imprimir"]
[1,"ACTO ADMTIVO- SOPORTE","Diligenciar documentos soporte del abono realizado."]
[2,"ANEXOS","Mencione los soporte que anexa junto con el formato (Copia de la Consignación, Copia de la transferencia)"]
[3,"FUNCIONARIO SOLICITANTE","Nombre de la persona que solicitante de la confirmación"]
[4,"Area","Dependencia del solicitante"]
[5,"Extensión","Extensión telefonica dentro de la UGPP"]

{"sheet":"Base de datos","index":2,"n_rows":14,"n_cols":24,"rows_kept":14,"cut":false,"hidden":true,"merged":[[0,16,1,18],[1,0,1,3],[1,4,1,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUBDIRECCIÓN FINANCIERA"]
[null,null,null,null,"CONFIRMACIÓN DE DEPÓSITOS"]
[]
["1. FECHA DE SOLICITUD","2. N°","3. TIPO RECAUDO","4. NIT/ CC","5. RAZÓN SOCIAL / NOMBRE","6. CUENTA BANCARIA","7. FECHA DE CONSIGNAC.","8. VALOR TOTAL","9. CAPITAL","10. INTERESES","11. EXCESOS","12. DOCUMENTO TERCERO","13. TERCERO A AFECTAR","14. PERIODO PAGADO","15. C x C  /  OBSERVACIONES",null,"# Solicitud   SubFinanc.","# Recaduo SIIF","NOTAS",null,"SE ELIMINA # DE IMPUTACIÓN PRESUPUESTAL, # DE CAUSACIÓN , DOCUMENTO CONTABLE"]
[null,1,"Sanciones",{"$f":"+'APLICA TDJ-'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'APLICA TDJ-'!#REF!","v":{"$error":"#REF!"}},"300700006921",{"$f":"+'APLICA TDJ-'!L4","v":"00:00:00"},{"$f":"+J5+I5+K5","v":{"$error":"#N/A"}},{"$f":"+'APLICA TDJ-'!M4","v":{"$error":"#N/A"}},0,{"$f":"+'APLICA TDJ-'!N4","v":{"$error":"#N/A"}},{"$f":"+'APLICA TDJ-'!#REF!","v":{"$error":"#REF!"}},{"$f":"+'APLICA TDJ-'!#REF!","v":{"$error":"#REF!"}},{"$f":"+V5","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Se remite deuda actualizada del expediente ",{"$f":"+CONCATENATE(U5,\" \",U6,\"\",U7,X7,U8)","v":{"$error":"#REF!"}}]
[null,2,"Sanciones",null,null,"300700006921",{"$f":"+'APLICA TDJ-'!L6","v":"2020-09-03"},0,null,0,null,null,{"$f":"+E6","v":0},null,null,null,null,null,null,null,{"$f":"+'APLICA TDJ-'!#REF!","v":{"$error":"#REF!"}}]
[null,3,"Sanciones",null,null,"300700006921",{"$f":"+'APLICA TDJ-'!L7","v":"2021-02-01"},0,null,0,null,null,0,null,null,null,null,null,null,null," resolución  "]
[null,4,"Sanciones",null,null,"300700006921",{"$f":"+'APLICA TDJ-'!L8","v":"00:00:00"},{"$f":"+J8+I8+K8","v":0},null,0,null,{"$f":"+D8","v":0},0,null,null,null,null,null,null,null,{"$f":"+'APLICA TDJ-'!#REF!","v":{"$error":"#REF!"}},null,null," "]
[null,5,"Sanciones",null,null,"300700006921",{"$f":"+'APLICA TDJ-'!L9","v":"00:00:00"},0,null,0,null,0,0]
[null,6,"Sanciones",null,null,"300700006921",{"$f":"+'APLICA TDJ-'!L10","v":"00:00:00"},0,null,null,null,0,0]
[null,7,"Sanciones",null,null,"300700006921",{"$f":"+'APLICA TDJ-'!L11","v":"00:00:00"},0,null,null,null,0,0]
[null,8,"Sanciones",null,null,"300700006921",{"$f":"+'APLICA TDJ-'!L12","v":"00:00:00"},0,null,null,null,0,0]
[null,9,"Sanciones",null,null,"300700006921",{"$f":"+'APLICA TDJ-'!#REF!","v":{"$error":"#REF!"}},0,null,null,null,0,0]
[null,10,"Sanciones",null,null,"300700006921",{"$f":"+'APLICA TDJ-'!#REF!","v":{"$error":"#REF!"}},0,null,null,null,0,0]

{"sheet":"Formato -Imprimir","index":3,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":true,"merged":[[37,8,37,10],[38,8,38,10],[35,8,35,10],[35,5,35,7],[36,5,36,7],[39,2,39,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[18,8,18,9],[17,8,17,9],[19,8,19,9],[20,1,20,3],[32,4,32,5],[22,1,22,10],[30,0,30,10],[19,6,19,7],[20,6,20,7],[27,1,27,4],[20,8,20,9],[0,0,3,3],[7,0,8,10],[10,6,10,7],[11,6,11,7],[12,6,12,7],[0,4,3,10],[10,8,10,9],[11,8,11,9],[12,8,12,9],[10,1,10,3],[11,1,11,3],[12,1,12,3],[42,2,42,3],[43,2,43,3],[31,0,31,10],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,6,18,7],[16,8,16,9],[16,6,16,7],[17,6,17,7],[40,2,40,3],[41,2,41,3],[18,1,18,3],[19,1,19,3],[44,2,44,3],[11,12,20,13],[13,8,13,9],[13,6,13,7],[14,8,14,9],[15,8,15,9],[14,6,14,7],[15,6,15,7],[34,8,34,10],[34,5,34,7],[36,8,36,10],[37,5,37,7],[38,5,38,7],[39,5,39,7],[42,5,42,7],[43,5,43,7],[40,5,40,7],[41,5,41,7],[44,5,44,7],[41,8,41,10],[39,8,39,10],[40,8,40,10],[42,8,42,10],[43,8,43,10],[44,8,44,10]]}
[null,null,null,null,"SOLICITUD DE CONFIRMACIÓN DE DEPÓSITOS"]
[]
[]
[]
[]
["Fecha:",{"$f":"+'Base de datos'!A5","v":"00:00:00"},null,null,"CONCEPTO:",{"$f":"+'Base de datos'!C5","v":"Sanciones"}]
[]
["Se solicita verificar los recaudos relacionados a continuación e imputar presupuestalmente de acuerdo a la información recogida en la base de datos anexa."]
[]
[]
["N°","RAZÓN SOCIAL",null,null,"NIT","CUENTA BANCARIA","FECHA CONSIGNAC.",null,"VALOR",null,"1. ACTO ADMTIVO- SOPORTE"]
[1,{"$f":"VLOOKUP(A12,'Base de datos'!$B:$G,4,FALSE)","v":{"$error":"#REF!"}},null,null,{"$f":"VLOOKUP(A12,'Base de datos'!$B:$G,3,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(A12,'Base de datos'!$B:$G,5,FALSE)","v":"300700006921"},{"$f":"VLOOKUP(A12,'Base de datos'!$B:$G,6,FALSE)","v":"00:00:00"},null,{"$f":"SUMIF('Base de datos'!B:B,'Formato -Imprimir'!A12,'Base de datos'!H:H)","v":{"$error":"#N/A"}},null,{"$f":"+'APLICA TDJ-'!#REF!","v":{"$error":"#REF!"}},null,"El acto administrativo y la información de los anexos se diligencia dentro de este formato, la información restante se recoge automáticamente de la base de datos que detalla la información"]
[2,{"$f":"VLOOKUP(A13,'Base de datos'!$B:$G,4,FALSE)","v":0},null,null,{"$f":"VLOOKUP(A13,'Base de datos'!$B:$G,3,FALSE)","v":0},{"$f":"VLOOKUP(A13,'Base de datos'!$B:$G,5,FALSE)","v":"300700006921"},{"$f":"VLOOKUP(A13,'Base de datos'!$B:$G,6,FALSE)","v":"2020-09-03"},null,{"$f":"SUMIF('Base de datos'!B:B,'Formato -Imprimir'!A13,'Base de datos'!H:H)","v":0}]
[3,{"$f":"VLOOKUP(A14,'Base de datos'!$B:$G,4,FALSE)","v":0},null,null,{"$f":"VLOOKUP(A14,'Base de datos'!$B:$G,3,FALSE)","v":0},{"$f":"VLOOKUP(A14,'Base de datos'!$B:$G,5,FALSE)","v":"300700006921"},{"$f":"VLOOKUP(A14,'Base de datos'!$B:$G,6,FALSE)","v":"2021-02-01"},null,{"$f":"SUMIF('Base de datos'!B:B,'Formato -Imprimir'!A14,'Base de datos'!H:H)","v":0}]
[4,{"$f":"VLOOKUP(A15,'Base de datos'!$B:$G,4,FALSE)","v":0},null,null,{"$f":"VLOOKUP(A15,'Base de datos'!$B:$G,3,FALSE)","v":0},{"$f":"VLOOKUP(A15,'Base de datos'!$B:$G,5,FALSE)","v":"300700006921"},{"$f":"VLOOKUP(A15,'Base de datos'!$B:$G,6,FALSE)","v":"00:00:00"},null,{"$f":"SUMIF('Base de datos'!B:B,'Formato -Imprimir'!A15,'Base de datos'!H:H)","v":0}]
[5,{"$f":"VLOOKUP(A16,'Base de datos'!$B:$G,4,FALSE)","v":0},null,null,{"$f":"VLOOKUP(A16,'Base de datos'!$B:$G,3,FALSE)","v":0},{"$f":"VLOOKUP(A16,'Base de datos'!$B:$G,5,FALSE)","v":"300700006921"},{"$f":"VLOOKUP(A16,'Base de datos'!$B:$G,6,FALSE)","v":"00:00:00"},null,{"$f":"SUMIF('Base de datos'!B:B,'Formato -Imprimir'!A16,'Base de datos'!H:H)","v":0}]
[6,{"$f":"VLOOKUP(A17,'Base de datos'!$B:$G,4,FALSE)","v":0},null,null,{"$f":"VLOOKUP(A17,'Base de datos'!$B:$G,3,FALSE)","v":0},{"$f":"VLOOKUP(A17,'Base de datos'!$B:$G,5,FALSE)","v":"300700006921"},{"$f":"VLOOKUP(A17,'Base de datos'!$B:$G,6,FALSE)","v":"00:00:00"},null,{"$f":"SUMIF('Base de datos'!B:B,'Formato -Imprimir'!A17,'Base de datos'!H:H)","v":0}]
[7,{"$f":"VLOOKUP(A18,'Base de datos'!$B:$G,4,FALSE)","v":0},null,null,{"$f":"VLOOKUP(A18,'Base de datos'!$B:$G,3,FALSE)","v":0},{"$f":"VLOOKUP(A18,'Base de datos'!$B:$G,5,FALSE)","v":"300700006921"},{"$f":"VLOOKUP(A18,'Base de datos'!$B:$G,6,FALSE)","v":"00:00:00"},null,{"$f":"SUMIF('Base de datos'!B:B,'Formato -Imprimir'!A18,'Base de datos'!H:H)","v":0}]
[8,{"$f":"VLOOKUP(A19,'Base de datos'!$B:$G,4,FALSE)","v":0},null,null,{"$f":"VLOOKUP(A19,'Base de datos'!$B:$G,3,FALSE)","v":0},{"$f":"VLOOKUP(A19,'Base de datos'!$B:$G,5,FALSE)","v":"300700006921"},{"$f":"VLOOKUP(A19,'Base de datos'!$B:$G,6,FALSE)","v":"00:00:00"},null,{"$f":"SUMIF('Base de datos'!B:B,'Formato -Imprimir'!A19,'Base de datos'!H:H)","v":0}]
[9,{"$f":"VLOOKUP(A20,'Base de datos'!$B:$G,4,FALSE)","v":0},null,null,{"$f":"VLOOKUP(A20,'Base de datos'!$B:$G,3,FALSE)","v":0},{"$f":"VLOOKUP(A20,'Base de datos'!$B:$G,5,FALSE)","v":"300700006921"},{"$f":"VLOOKUP(A20,'Base de datos'!$B:$G,6,FALSE)","v":{"$error":"#REF!"}},null,{"$f":"SUMIF('Base de datos'!B:B,'Formato -Imprimir'!A20,'Base de datos'!H:H)","v":0}]
[10,{"$f":"VLOOKUP(A21,'Base de datos'!$B:$G,4,FALSE)","v":0},null,null,{"$f":"VLOOKUP(A21,'Base de datos'!$B:$G,3,FALSE)","v":0},{"$f":"VLOOKUP(A21,'Base de datos'!$B:$G,5,FALSE)","v":"300700006921"},{"$f":"VLOOKUP(A21,'Base de datos'!$B:$G,6,FALSE)","v":{"$error":"#REF!"}},null,{"$f":"SUMIF('Base de datos'!B:B,'Formato -Imprimir'!A21,'Base de datos'!H:H)","v":0}]
[]
["2. ANEXOS:","SOPORTE DE CONSIGNACION"]
[]
[]
[]
["3. Funcionario solicitante:"]
["4. Aréa","Subirección de cobranzas",null,null,null,"5. Extensión:"]
[]
[]
["CONFIRMACIÓN E IMPUTACIÓN DE LOS DEPÓSITOS"]
["Para uso exclusivo de la Subdirección Financiera"]
["Fecha:",null,null,null,null,null,null,"N° de la solicitud:"]
[]
["N°","FECHA TRANSACCIÓN","VALOR CONFIRMADO",null,"N° DE    RECAUDO SIIF","CUENTA BANCO",null,null,"NOTAS",null,null,null,null,"SE AGREGA LA COLUMNA REGISTRO DE RECAUDO, NO. DE CAUSACION"]
[{"$f":"+A12","v":1},null,null,null,{"$f":"VLOOKUP(A36,'Base de datos'!$B:$S,17,FALSE)","v":0},null,null,null,null,null,null,null,{"$f":"+C36-I12","v":{"$error":"#N/A"}}]
[2,null,null,null,{"$f":"VLOOKUP(A37,'Base de datos'!$B:$S,17,FALSE)","v":0},null,null,null,null,null,null,null,{"$f":"+C37-I13","v":0}]
[3,null,null,null,{"$f":"VLOOKUP(A38,'Base de datos'!$B:$S,17,FALSE)","v":0},null,null,null,null,null,null,null,0]
[4,null,null,null,{"$f":"VLOOKUP(A39,'Base de datos'!$B:$S,17,FALSE)","v":0},null,null,null,null,null,null,null,0]
[5,null,null,null,{"$f":"VLOOKUP(A40,'Base de datos'!$B:$S,17,FALSE)","v":0},null,null,null,null,null,null,null,0]
[6,null,null,null,{"$f":"VLOOKUP(A41,'Base de datos'!$B:$S,17,FALSE)","v":0},null,null,null,null,null,null,null,0]
[7,null,null,null,{"$f":"VLOOKUP(A42,'Base de datos'!$B:$S,17,FALSE)","v":0},null,null,null,null,null,null,null,0]
[8,null,null,null,{"$f":"VLOOKUP(A43,'Base de datos'!$B:$S,17,FALSE)","v":0},null,null,null,null,null,null,null,0]
[9,null,null,null,{"$f":"VLOOKUP(A44,'Base de datos'!$B:$S,17,FALSE)","v":0},null,null,null,null,null,null,null,0]
[10,null,null,null,{"$f":"VLOOKUP(A45,'Base de datos'!$B:$S,17,FALSE)","v":0},null,null,null,null,null,null,null,0]
[]
[]
[]
[]
["Funcionario que confirma",null,null,null,"Funcionario que registra en SIIF",null,null,null,"Vo Bo de Contabilidad"]
["Nombre:",null,null,null,"Nombre:",null,null,null,"Nombre:"]
["Area",null,null,null,"Area",null,null,null,"Cargo:"]

{"sheet":"tabla","index":4,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Tipo de Ingreso"]
["Aportes Pensionales"]
["Compartibilidad"]
["Costas"]
["Cuotas Partes"]
["Gastos procesales"]
["Incapacidades"]
["Indemnizaciones"]
["Multas empleados"]
["Reintegro de Gastos"]
["Retroactivo Patronal"]
["Sanciones"]
["Valores Adeudados por pensión"]

{"sheet":"inicial","index":5,"n_rows":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,12],[0,13,0,14],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,16,2,16],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,14,2,14]]}
["ACTUALIZACIÓN DE SANCIONES"]
["VALOR DE LA OBLIGACIÓN","FECHA EXIGIBILIDAD","CORTE ACTUALIZACION","Dias de mora","IPC",null,"VALOR IPC","VALOR ACTUALIZADO","TIPO DE PAGO","No. SIIF/ No. TDJ","VALOR PAGADO/VALOR TDJ","FECHA DE PAGO/F. EMISION DEL TDJ","PAGO IMPUTADO A OBLIGACIÓN","REMANENTE","SALDO A PAGAR ",null,"PORCENTAJE PAGADO PARA ACCEDER AL BENEFICIO"]
[null,null,null,null,"IPC ","AÑO",null,null,null,null,null,null,null,null,null,"No. De Pago"]
[{"$f":"B13","v":0},{"$f":"B15","v":"1900-01-01"},{"$f":"+VLOOKUP(YEAR(B4),$S$21:$T$29,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(L4=\"\",(C4-B4)+1,IF(YEAR(L4)<=YEAR(B4),0,IF((C4-B4)+1>365,(365),(C4-B4)+1)))","v":{"$error":"#N/A"}},{"$f":"+IF(YEAR(B4)=YEAR(B5),(0),VLOOKUP(F4,$S$21:$U$29,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"+YEAR(C4)","v":{"$error":"#N/A"}},{"$f":"+H4-A4","v":{"$error":"#N/A"}},{"$f":"A4*(1+E4)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"+IF(K4>H4,H4,K4)","v":{"$error":"#N/A"}},{"$f":"K4-M4","v":{"$error":"#N/A"}},{"$f":"H4-M4","v":{"$error":"#N/A"}},1,{"$f":"K4/H4","v":{"$error":"#N/A"}}]
[{"$f":"IF(P5=1,$B$13,O4)","v":{"$error":"#N/A"}},{"$f":"+IF(L4=\"\",DATE(YEAR(B4)+1,1,1),IF(YEAR(L4)<=YEAR($B$15),$B$15,IF(YEAR(B4)+1=YEAR(L4),DATE(YEAR(L4),1,1),DATE(YEAR(L4),1,1))))","v":"1901-01-01"},{"$f":"+VLOOKUP(YEAR(B5),$S$21:$T$29,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"+IF(YEAR(B5)=YEAR(B6),(0),VLOOKUP(F5,$S$21:$U$29,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"+YEAR(C5)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"A5*(1+E5)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"+IF(K5>H5,H5,K5)","v":{"$error":"#N/A"}},{"$f":"K5-M5","v":{"$error":"#N/A"}},{"$error":"#N/A"},2,{"$f":"K5/H5","v":{"$error":"#N/A"}}]
[{"$f":"IF(P6=1,$B$13,O5)","v":{"$error":"#N/A"}},{"$f":"+IF(L5=\"\",DATE(YEAR(B5)+1,1,1),IF(YEAR(L5)<=YEAR($B$15),$B$15,IF(YEAR(B5)+1=YEAR(L5),DATE(YEAR(L5),1,1),DATE(YEAR(L5),1,1))))","v":"1902-01-01"},{"$error":"#N/A"},{"$f":"IF(L6=\"\",(C6-B6)+1,IF(YEAR(L6)<=YEAR(B6),0,IF((C6-B6)+1>365,(365),(C6-B6)+1)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"+YEAR(C6)","v":{"$error":"#N/A"}},{"$f":"+H6-A6","v":{"$error":"#N/A"}},{"$f":"A6*(1+E6)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"+IF(K6>H6,H6,K6)","v":{"$error":"#N/A"}},{"$f":"K6-M6","v":{"$error":"#N/A"}},{"$error":"#N/A"},3,{"$f":"K6/H6","v":{"$error":"#N/A"}}]
[{"$error":"#N/A"},"1903-01-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,{"$error":"#N/A"}]
[{"$error":"#N/A"},"1904-01-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},5,{"$error":"#N/A"}]
[{"$error":"#N/A"},"1905-01-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$f":"+IF(K9>H9,H9,K9)","v":{"$error":"#N/A"}},{"$f":"K9-M9","v":{"$error":"#N/A"}},{"$error":"#N/A"},6,{"$error":"#N/A"}]
[{"$error":"#N/A"},"1906-01-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},7,{"$error":"#N/A"}]
[{"$error":"#N/A"},"1907-01-01",{"$f":"+VLOOKUP(YEAR(B11),$S$21:$T$29,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"+IF(YEAR(B11)=YEAR(B12),(0),VLOOKUP(F11,$S$21:$U$28,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"+YEAR(C11)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"A11*(1+E11)","v":{"$error":"#N/A"}},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},8,{"$error":"#N/A"}]
[]
["VALOR SANCION",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
["FECHA EJECUTORIA ","00:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
["FECHA EXIGIBILIDAD",{"$f":"B14+1","v":"1900-01-01"}]
["L.O",106216300]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B15","v":"1900-01-01"},{"$f":"+YEAR(R18)","v":1900}]
["actualizado: 18/01/2022",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L4","v":"00:00:00"},{"$f":"+YEAR(R19)","v":1900}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,"2013-12-31",1.9400000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,"2014-12-31",3.6600000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B4","v":"1900-01-01"},2015,"2015-12-31",6.7699999999999996E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,"2016-12-31",5.7500000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,"2017-12-31",4.0899999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,"2018-12-31",3.1800000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"2019-12-31",3.7999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,"2020-12-31",1.61E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,"2021-12-31",5.62E-2]

{"sheet":"APLICA TDJ-","index":6,"n_rows":28,"n_cols":21,"rows_kept":28,"cut":false,"hidden":true,"merged":[[1,16,2,16],[11,8,11,11],[0,0,0,12],[0,13,0,14],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,1,5],[1,6,2,6],[1,7,2,7],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,8,2,8],[1,14,2,14]]}
["ACTUALIZACIÓN DE SANCIONES"]
["VALOR DE LA OBLIGACIÓN","FECHA EXIGIBILIDAD","CORTE ACTUALIZACION","Dias de mora","IPC",null,"VALOR IPC","VALOR ACTUALIZADO","TIPO DE PAGO","No. SIIF/ No. TDJ","VALOR PAGADO/VALOR TDJ","FECHA DE PAGO/F. EMISION DEL TDJ","PAGO IMPUTADO A OBLIGACIÓN","REMANENTE","SALDO A PAGAR ",null,"PORCENTAJE PAGADO PARA ACCEDER AL BENEFICIO"]
[null,null,null,null,"IPC ","AÑO",null,null,null,null,null,null,null,null,null,"No. De Pago"]
[{"$f":"VALOR_OBLIGACIÓN","v":0},{"$f":"B15","v":"1900-01-01"},{"$f":"+VLOOKUP(YEAR(B4),$S$21:$T$27,2,0)","v":{"$error":"#N/A"}},{"$f":"IF(L4=\"\",(C4-B4)+1,IF(YEAR(L4)<=YEAR(B4),0,IF((C4-B4)+1>365,(365),(C4-B4)+1)))","v":{"$error":"#N/A"}},{"$f":"+IF(YEAR(B4)=YEAR(B5),(0),VLOOKUP(F4,$S$21:$U$27,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"+YEAR(C4)","v":{"$error":"#N/A"}},{"$f":"+H4-A4","v":{"$error":"#N/A"}},{"$f":"A4*(1+E4)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"+IF(K4>H4,H4,K4)","v":{"$error":"#N/A"}},{"$f":"K4-M4","v":{"$error":"#N/A"}},{"$f":"H4-M4","v":{"$error":"#N/A"}},1,{"$f":"K4/H4","v":{"$error":"#N/A"}}]
[{"$f":"IF(P5=1,$B$13,O4)","v":{"$error":"#N/A"}},{"$f":"+IF(L4=\"\",DATE(YEAR(B4)+1,1,1),IF(YEAR(L4)<=YEAR($B$15),$B$15,IF(YEAR(B4)+1=YEAR(L4),DATE(YEAR(L4),1,1),DATE(YEAR(L4),1,1))))","v":"1901-01-01"},{"$f":"+VLOOKUP(YEAR(B5),$S$21:$T$29,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"+IF(YEAR(B5)=YEAR(B6),(0),VLOOKUP(F5,$S$21:$U$29,3,FALSE))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"A5*(1+E5)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"+IF(K5>H5,H5,K5)","v":{"$error":"#N/A"}},{"$f":"K5-M5","v":{"$error":"#N/A"}},{"$error":"#N/A"},2,{"$f":"K5/H5","v":{"$error":"#N/A"}}]
[{"$error":"#N/A"},"1902-01-01",{"$f":"+VLOOKUP(YEAR(B6),$S$21:$T$29,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"+IF(YEAR(B6)=YEAR(B7),(0),VLOOKUP(F6,$S$21:$U$29,3,FALSE))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"CONSIGNACION",7295920,165913,"2020-09-03",{"$f":"+IF(K6>H6,H6,K6)","v":{"$error":"#N/A"}},{"$f":"K6-M6","v":{"$error":"#N/A"}},{"$error":"#N/A"},3,{"$f":"K6/H6","v":{"$error":"#N/A"}}]
[{"$error":"#N/A"},"2020-01-01",{"$f":"+VLOOKUP(YEAR(B7),$S$21:$T$29,2,0)","v":"2020-12-31"},365,{"$f":"+IF(YEAR(B7)=YEAR(B8),(0),VLOOKUP(F7,$S$21:$U$29,3,FALSE))","v":1.61E-2},2020,{"$error":"#N/A"},{"$error":"#N/A"},"APLICACIÓN TDJ","\n400100007936486.",3625703.05,"2021-02-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4,{"$error":"#N/A"}]
[{"$error":"#N/A"},"2021-01-01",{"$f":"+VLOOKUP(YEAR(B8),$S$21:$T$27,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"+IF(YEAR(B8)=YEAR(B9),(0),VLOOKUP(F8,$S$21:$U$27,3,FALSE))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},5,{"$error":"#N/A"}]
[{"$error":"#N/A"},"2022-01-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6,{"$error":"#N/A"}]
[{"$error":"#N/A"},"2023-01-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},7,{"$error":"#N/A"}]
[{"$error":"#N/A"},"2024-01-01",{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"+IF(YEAR(B11)=YEAR(B12),(0),VLOOKUP(F11,$S$21:$U$27,3,FALSE))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},8,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"M5+M6+M7+M8","v":{"$error":"#N/A"}},{"$f":"N6+N7+N8","v":{"$error":"#N/A"}}]
["VALOR SANCION",{"$f":"inicial!B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
["FECHA EJECUTORIA ",{"$f":"inicial!B14","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
["FECHA EXIGIBILIDAD",{"$f":"B14+1","v":"1900-01-01"}]
["L.O",106216300]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B15","v":"1900-01-01"},{"$f":"+YEAR(R18)","v":1900}]
["actualizado: 01/02/2019",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L4","v":"00:00:00"},{"$f":"+YEAR(R19)","v":1900}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,"2013-12-31",1.9400000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,"2014-12-31",3.6600000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B4","v":"1900-01-01"},2015,"2015-12-31",6.7699999999999996E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,"2016-12-31",5.7500000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,"2017-12-31",4.0899999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,"2018-12-31",3.1800000000000002E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,"2019-12-31",3.7999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,"2020-12-31",1.61E-2]