{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CASTIGO_CARTERA","INSTRUCTIVO"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":1,"defined_names":0,"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":"CASTIGO_CARTERA","index":0,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,5,2,5],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,17,2,17],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,1,12],[1,13,2,13],[1,14,2,14],[1,15,2,15],[1,16,2,16]]}
[]
["COD\nREG","REGIONAL","NIT","RAZÓN SOCIAL Y/O NOMBRE DEL APORTANTE","No. RESOLUCIÓN DE EJECUTORIA O LIQUIDACIÓN No.","FECHA DE LA RESOLUCIÓN\nO LIQUIDACIÓN","VALOR CAPITAL  CASTIGADO","VALOR INTERES CASTIGADO","VALOR TOTAL","CAUSAL DEL AJUSTE","IDENTIFICACIÓN DEL DOCUMENTO SOPORTE",null,null,"APLICATIVO DE RECAUDO DONDE SE ENCUENTRA REGISTRADO","FILA EN EL APLICATIVO DE RECAUDO","CÓDIGO EN EL FORMATO DE RECAUDO","MES DEL INFORME EN EL CUAL SE APLICA EL AJUSTE","OBSERVACIONES"]
[null,null,null,null,null,null,null,null,null,null,"TIPO DOCUMENTO SOPORTE PARA EL AJUSTE","NÚMERO DEL DOCUMENTO SOPORTE","FECHA DOCUMENTO SOPORTE"]
[null,{"$f":"IF(A4=\"\",\"\",VLOOKUP(A4,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,{"$f":"SUM(G4:H4)","v":0}]
[null,{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,{"$f":"SUM(G5:H5)","v":0}]
[null,{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,{"$f":"SUM(G6:H6)","v":0}]
[null,{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,{"$f":"SUM(G7:H7)","v":0}]
[null,{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A46=\"\",\"\",VLOOKUP(A46,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A47=\"\",\"\",VLOOKUP(A47,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A48=\"\",\"\",VLOOKUP(A48,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A49=\"\",\"\",VLOOKUP(A49,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A52=\"\",\"\",VLOOKUP(A52,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A53=\"\",\"\",VLOOKUP(A53,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A54=\"\",\"\",VLOOKUP(A54,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A55=\"\",\"\",VLOOKUP(A55,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]
[null,{"$f":"IF(A56=\"\",\"\",VLOOKUP(A56,[1]Listas!$B$1:$C$36,2,0))","v":""},null,null,null,null,null,null,0]

{"sheet":"INSTRUCTIVO","index":1,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[16,1,16,3],[4,1,4,3],[9,0,9,3],[10,1,10,3],[28,1,28,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[11,0,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[23,1,23,3],[24,1,24,3],[29,1,29,3],[30,1,30,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3]]}
[]
[]
[]
[]
[null,"Señor usuario si le aparece este cuadro de advertencia por favor haga clic en la opción \"Habilitar contenido\""]
[]
[]
[]
[]
["Instructivo para diligenciar el Formato"]
["Sección","Definición"]
["Diligenciamiento de algunos campos para tener en cuenta"]
["CODIGO DE REGIONAL","Digite o seleccione en la lista desplegable el código de la Regional"]
["REGIONAL","Esta celda es automática de acuerdo con lo seleccionado en la celda anterior."]
["NIT","Digite el número de identificación del deudor, sin puntos, sin comas ni digito de verificación"]
["RAZON SOCIAL Y/O NOMBRE DEL APORTANTE","Digite el Nombre del deudor o titular de la obligación que se va a castigar."]
["No. RESOLUCION DE EJECUTORIA O LIQUIDACIÓN No","Digite el número de la resolución o el número de la liquidación sobre la cual se decretó el castigo"]
["FECHA DE LA RESOLUCIÓN O LIQUIDACIÓN","Digite la Fecha de la Resolución o Liquidación que se decretó el castigo en formato dd/mm/aa"]
["VALOR CAPITAL CASTIGADO","Digite el valor del capital que se decretó para castigo sin puntos ni comas."]
["VALOR INTERES CASTIGADO","Digite el valor de los intereses que se decretó para castigo sin puntos ni comas."]
["VALOR TOTAL","Este campo es automático y es la suma del capital más los intereses que se decretaron para castigar"]
["CAUSAL DEL AJUSTE","Seleccione en la lista desplegable la causal de ajustes que la Regional está utilizando para realizar el castigo de cartera del Aporte Parafiscal 3%"]
["TIPO DOCUMENTO SOPORTE PARA EL AJUSTE","Seleccione el tipo de documento a Acto administrativo que está soportando el castigo de cartera."]
["NÚMERO DEL DOCUMENTO SOPORTE","Digite el número de la resolución en la cual se decretó el castigo de la cartera"]
["FECHA DOCUMENTO SOPORTE","Digite la fecha del documento por el cual se decretó el castigo de la cartera en formato dd/mm/aa."]
["APLICATIVO DE RECAUDO DONDE SE ENCUENTRA REGISTRADO","Digite el nombre del formato en el cual se encuentra registrado esta cartera antes del castigo según el caso."]
["FILA EN EL APLICATIVO DE RECAUDO","Indique la fila en la que se encuentra ubicada la obligación según el aplicativo"]
["CODIGO EN EL FORMATO DE RECAUDO","Digite el código de cartera en la cual se encuentra clasificada la obligación en los aplicativos de Recaudo según el caso"]
["MES DEL INFORME EN EL CUAL SE APLICA EL AJUSTE","Indique el mes en el cual se aplica el ajuste en los aplicativos de recaudo. (No la fecha en la que se realiza el ajuste)"]
["OBSERVACIONES","Describa las Observaciones pertinentes para aclarar el ajuste de castigo de cartera al aporte parafiscal 3%"]