{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INSTRUCTIVO","FORMATO 1","FORMATO 2","FORMATO 3B","PARAMETRO"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"INSTRUCTIVO","index":0,"n_rows":104,"n_cols":13,"rows_kept":104,"cut":false,"hidden":false,"merged":[[52,0,54,2],[52,3,54,12],[0,0,2,2],[0,3,2,12],[3,0,7,12],[10,2,11,11],[13,2,14,12],[29,0,29,3],[49,0,50,3],[49,4,50,6],[49,7,50,9],[49,10,50,11],[49,12,50,12],[56,0,56,3],[73,0,73,3],[92,2,93,12],[100,2,101,11],[103,0,104,3],[103,4,104,6],[103,7,104,9],[103,10,104,11],[103,12,104,12]]}
[null,null,null,"PROCESO DE DILIGENCIAMIENTO FORMATOS CLEBP"]
[]
[]
["Colpensiones pone a disposición de las entidades que deben certificar tiempos publico anteriores a la entrada en vigencia del Sistema General de Pensiones, formatos CLEBP con controles que permiten identificar posibles errores en el momento del diligenciamiento  que facilitarán la radicación en los Puntos de Atención Colpensiones. Lo invitamos a utilizar esta herramienta, para ello hemos dispuesto ayudas en los diferentes campos, por lo que le solicitamos leer cuidadosamente este instructivo. "]
[]
[]
[]
[]
[]
[]
[null,null,"Para los 3 formatos los campos marcados de color rojo son obligatorios, cuando están diligenciados cambia a color gris y letras color negra"]
[]
[]
[null,null,"Siga las instrucciones para cada formato\nNo subrayar con colores las celdas donde se digita la información"]
[]
[null,null,"Verifique que el número de documento y Nombres sea igual para los 3 formatos"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FORMATO 1"]
[]
["Recuerde"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ELABORACIÓN:\nNOMBRE:  Marcela Velosa García\nCARGO:  PROFESIONAL MASTER 5 ",null,null,null,"REVISIÓN:\nNOMBRE:  Miguel Monroy Gómez\nCARGO: PROFESIONAL MASTER",null,null,"APROBACIÓN:\nNOMBRE:  Cesar Alberto Mendoza Heredia\nCARGO: Director Historia Laboral",null,null,"FECHA ELABORACIÓN:\n08/02/2018",null,"Versión\n01"]
[]
[]
[null,null,null,"PROCESO DE DILIGENCIAMIENTO FORMATOS CLEBP"]
[]
[]
[]
["FORMATO 2"]
[]
["Recuerde"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FORMATO 3"]
[]
["Recuerde"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["El NO correcto diligenciamiento de los formatos genera:"]
[null,null,"Incremento en los rechazos"]
[null,null,"Afecta al ciudadano en cuanto al tiempo de respuesta de la decisión de la prestación solicitada."]
[null,null,"Prestaciones económicas mal decididas por información reportada de manera errada por las entidades certificadoras."]
[null,null,"Los 3 formatos deberán ir firmados por el funcionario competente para firmar, junto con su cargo, tipo y número de cedula, cargo y resolución."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Recuerde si el campo NO se diligencia los campos obligatorios quedarán en color ROJO \nNo deben quedar campos en color ROJO"]
[]
[]
["ELABORACIÓN:\nNOMBRE:  Marcela Velosa García\nCARGO:  PROFESIONAL MASTER 5 ",null,null,null,"REVISIÓN:\nNOMBRE:  Miguel Monroy Gómez\nCARGO: PROFESIONAL MASTER",null,null,"APROBACIÓN:\nNOMBRE:  Cesar Alberto Mendoza Heredia\nCARGO: Director Historia Laboral",null,null,"FECHA ELABORACIÓN:\n08/02/2018",null,"Versión\n01"]

{"sheet":"FORMATO 1","index":1,"n_rows":84,"n_cols":51,"rows_kept":84,"cut":false,"hidden":false,"merged":[[4,45,4,46],[4,47,4,48],[4,50,4,51],[5,1,5,52],[6,36,6,44],[6,45,6,52],[0,1,0,52],[1,18,1,29],[1,36,1,52],[2,18,2,29],[3,1,3,52],[2,36,2,44],[2,46,2,52],[4,6,4,43],[7,1,7,52],[8,1,8,8],[8,9,8,42],[8,43,8,44],[8,45,8,52],[9,1,9,13],[9,14,9,16],[9,17,9,43],[9,44,9,48],[10,1,10,13],[10,14,10,18],[10,19,10,45],[10,46,10,50],[11,1,11,4],[11,5,11,13],[11,14,11,16],[11,17,11,25],[11,26,11,29],[11,30,11,52],[12,1,12,52],[13,1,13,8],[13,9,13,42],[13,43,13,45],[13,46,13,52],[14,1,14,13],[14,14,14,17],[14,18,14,45],[14,46,14,48],[17,23,17,35],[17,36,18,44],[17,45,17,52],[18,5,18,18],[18,19,18,22],[18,23,18,35],[18,45,18,52],[15,1,15,13],[15,14,15,19],[15,20,15,45],[15,46,15,50],[16,1,18,3],[16,5,16,18],[16,19,16,22],[16,23,16,52],[17,5,17,18],[17,19,17,22],[22,36,22,44],[22,45,22,46],[22,47,22,48],[22,49,22,52],[23,1,23,52],[24,1,24,29],[24,30,24,44],[24,45,24,52],[19,1,19,52],[20,1,20,29],[20,30,20,44],[20,45,20,52],[21,1,22,29],[21,41,21,42],[21,45,21,46],[21,47,21,48],[21,49,21,52],[22,30,22,35],[25,1,25,29],[25,41,25,42],[25,45,25,52],[27,1,27,52],[28,1,28,52],[29,2,29,13],[29,14,31,21],[29,22,31,35],[29,36,29,48],[29,49,31,52],[31,36,31,37],[31,39,31,40],[31,41,31,42],[31,43,31,44],[31,45,31,46],[31,47,31,48],[30,2,30,7],[30,8,30,13],[30,36,30,42],[30,43,30,48],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[32,49,32,52],[33,2,33,7],[33,8,33,13],[33,14,33,21],[33,22,33,35],[33,36,33,42],[33,43,33,48],[33,49,33,52],[32,2,32,7],[32,8,32,13],[32,14,32,21],[32,22,32,35],[32,36,32,42],[32,43,32,48],[38,49,38,52],[39,1,39,52],[34,49,34,52],[35,2,35,7],[35,8,35,13],[35,14,35,21],[35,22,35,35],[35,36,35,42],[35,43,35,48],[35,49,35,52],[34,2,34,7],[34,8,34,13],[34,14,34,21],[34,22,34,35],[34,36,34,42],[34,43,34,48],[36,49,36,52],[37,2,37,7],[37,8,37,13],[37,14,37,21],[37,22,37,35],[37,36,37,42],[37,43,37,48],[37,49,37,52],[36,2,36,7],[36,8,36,13],[36,14,36,21],[36,22,36,35],[36,36,36,42],[36,43,36,48],[40,1,40,52],[41,2,41,13],[41,14,43,17],[41,18,42,35],[41,36,42,49],[41,50,43,52],[42,2,42,7],[42,8,42,13],[38,2,38,7],[38,8,38,13],[38,14,38,21],[38,22,38,35],[38,36,38,42],[38,43,38,48],[43,18,43,26],[43,27,43,35],[43,36,43,44],[43,45,43,49],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[43,12,43,13],[44,45,44,49],[44,50,44,52],[45,2,45,7],[45,8,45,13],[45,14,45,17],[45,18,45,26],[45,27,45,35],[45,36,45,44],[45,45,45,49],[45,50,45,52],[44,2,44,7],[44,8,44,13],[44,14,44,17],[44,18,44,26],[44,27,44,35],[44,36,44,44],[46,45,46,49],[46,50,46,52],[47,2,47,7],[47,8,47,13],[47,14,47,17],[47,18,47,26],[47,27,47,35],[47,36,47,44],[47,45,47,49],[47,50,47,52],[46,2,46,7],[46,8,46,13],[46,14,46,17],[46,18,46,26],[46,27,46,35],[46,36,46,44],[48,45,48,49],[48,50,48,52],[49,2,49,7],[49,8,49,13],[49,14,49,17],[49,18,49,26],[49,27,49,35],[49,36,49,44],[49,45,49,49],[49,50,49,52],[48,2,48,7],[48,8,48,13],[48,14,48,17],[48,18,48,26],[48,27,48,35],[48,36,48,44],[50,45,50,49],[50,50,50,52],[51,1,51,52],[53,1,54,10],[53,13,54,17],[53,18,54,42],[53,43,54,44],[53,45,54,52],[50,2,50,7],[50,8,50,13],[50,14,50,17],[50,18,50,26],[50,27,50,35],[50,36,50,44],[64,1,64,40],[65,4,65,6],[65,11,65,14],[65,20,65,26],[65,35,65,44],[65,45,65,49],[56,1,57,52],[58,1,58,52],[59,1,60,29],[60,35,60,46],[61,1,61,52],[62,1,63,29],[71,1,71,52],[72,1,73,17],[72,24,72,36],[72,40,72,51],[73,24,73,39],[73,40,73,51],[67,4,67,6],[67,11,67,14],[67,20,67,28],[67,35,67,42],[67,43,67,48],[69,4,69,6],[69,11,69,15],[69,20,69,25],[82,5,82,6],[82,7,82,15],[83,6,85,52],[75,1,76,52],[77,1,77,52],[78,1,78,52],[80,5,80,15],[80,29,80,40],[80,43,80,49]]}
[null,"REPUBLICA DE COLOMBIA  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ciudad y fecha de expedición certificación:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORMATO No. 1",null,null,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":"TODAY()","v":"2018-04-04"}]
[null,"CERTIFICADO DE INFORMACION LABORAL"]
[null,null,null,null,null,null,"Usar únicamente para certificar tiempos cotizados a Cajas públicas diferentes al ISS o tiempos no cotizados",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hoja",null,null,null,"de"]
[]
[null,"Diligenciar este formato de acuerdo a lo especificado en el instructivo.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Número consecutivo:"]
[null,"A. IDENTIFICACION   DE LA ENTIDAD QUE CERTIFICA"]
[null,"1. Nombre o Razón Social:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. NIT"]
[null,"3. Dirección",null,null,null,null,null,null,null,null,null,null,null,null,"4. Ciudad:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código Dane"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Departamento:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código Dane"]
[null,"6.Telefono",null,null,null,null,null,null,null,null,null,null,null,null,"7. Fax",null,null,null,null,null,null,null,null,null,null,null,"8. E-Mail:"]
[null,"B. IDENTIFICACION   DEL EMPLEADOR POR EL CUAL SE CERTIFICA TIEMPO"]
[null,"9. Nombre o Razón Social:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10. NIT:"]
[null,"11. Dirección",null,null,null,null,null,null,null,null,null,null,null,null,"12. Ciudad:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13. Departamento:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código"]
[null,"14.Sector (Marcar solo uno)",null,null,null,"Sector Público Nacional",null,null,null,null,null,null,null,null,null,null,null,null,null,"15. E-Mail:"]
[null,null,null,null,null,"Sector Público Departamental o Distrital",null,null,null,null,null,null,null,null,null,null,null,null,null,"16.Telefono:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18. Fecha en que entró en vigencia el SGP para ese empleador",null,null,null,null,null,null,null,null,"Día - Mes - Año"]
[null,null,null,null,null,"Sector público Municipal",null,null,null,null,null,null,null,null,null,null,null,null,null,"17. Fax:",null,null,null,"(          )"]
[null,"C. IDENTIFICACION DEL TRABAJADOR"]
[null,"19.Apellidos y Nombres completos del trabajador:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20. Documento de identidad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21. Fecha de Nacimiento (Opcional)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TI",null,null,null,null,null,"CC",null,null,"CE",null,"NIT",null,"X",null,"Día",null,"Mes",null,"Año"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No:"]
[null,"C1. Datos de identificación alternos: (Diligenciar en caso que la persona tenga o haya tenido datos de identificación alternos)"]
[null,"22.Apellidos y Nombres alternos del trabajador:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23. Tipo Documento alterno",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24. No. Doc. Alterno:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TI",null,null,null,null,null,"CC",null,null,"CE",null,"NIT"]
[]
[null,"D. VINCULACIONES LABORALES (Si falta espacio utilice hoja adicional firmada con el mismo  número consecutivo) "]
[]
[null,null,"25. PERIODOS DE VINCULACION LABORAL ",null,null,null,null,null,null,null,null,null,null,null,"26. ENTIDAD EMPLEADORA",null,null,null,null,null,null,null,"27.  Cargo / Observaciones",null,null,null,null,null,null,null,null,null,null,null,null,null,"28. INTERRUPCIONES LABORALES NO REMUNERADAS (para cada periodo)",null,null,null,null,null,null,null,null,null,null,null,null,"29. Total de días de Interrupción"]
[null,null,"DESDE",null,null,null,null,null,"HASTA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DESDE",null,null,null,null,null,null,"HASTA"]
[null,null,"Día",null,"Mes",null,"Año",null,"Día",null,"Mes",null,"Año",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Día",null,null,"Mes",null,"Año",null,"Día",null,"Mes",null,"Año"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(COUNTA(AK33:AW33)>1,(AR33-AK33)+1,\"\")","v":""}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(COUNTA(AK34:AW34)>1,(AR34-AK34)+1,\"\")","v":""}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"E. APORTES PARA PENSIONES correspondientes a las vinculaciones laborales detalladas en la sección anterior."]
[null,"(Si falta espacio use hoja adicional firmada y con el mismo número consecutivo)"]
[null,null,"30. PERIODOS DE APORTES",null,null,null,null,null,null,null,null,null,null,null,"31. AL EMPLEADO SE LE DESCONTÓ PARA SEGURIDAD SOCIAL?",null,null,null,"32. CAJA, FONDO O ENTIDAD A LA CUAL SE REALIZARON LOS APORTES.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33. ENTIDAD QUE RESPONDE POR EL PERIODO",null,null,null,null,null,null,null,null,null,null,null,null,null,"34. Periodo a cargo de la entidad que Certifica"]
[null,null,"DESDE",null,null,null,null,null,"HASTA"]
[null,null,"Día",null,"Mes",null,"Año",null,"Día",null,"Mes",null,"Año",null,null,null,null,null,"Nombre ",null,null,null,null,null,null,null,null,"NIT o Código",null,null,null,null,null,null,null,null,"Razón social",null,null,null,null,null,null,null,null,"NIT"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,"F. TRABAJADORES MIGRANTES: Diligenciar en caso que se estén certificando tiempos para un trabajador migrante, de acuerdo a lo estipulado en el Artículo 20 del Decreto 1748 de 1995, modificado por el Artículo 9° del Decreto 1513 de 1998."]
[]
[null,"35. Es trabajador migrante?",null,null,null,null,null,null,null,null,null,"Si",null,null,null,null,null,null,"36. Numero de semanas efectivamente laboradas por año:"]
[null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[null,"G. INFORMACION SOBRE PENSIONES E INDEMNIZACION SUSTITUTIVA (La información de esta sección es de carácter netamente informativo, y solo debe ser diligenciado si la entidad que expide la certificación, tiene pruebas de la pensión a la cual se hace mención)."]
[]
[]
[null,"37. ¿Al trabajador para el cual se expide esta certificación le fue otorgada una indemnización sustitutiva  por esa entidad o actualmente la está tramitando?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sí",null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indemnización sustitutiva en trámite"]
[]
[null,"38. ¿El trabajador para el cual se expide esta certificación fue o está pensionado por esa entidad o actualmente la está tramitando?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sí",null,null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pensión en trámite"]
[null,"39. En caso de haber respondido \"SI\" o \"Pensión en trámite\" en el punto anterior, ¿Qué tipo de pensión se le otorgó?"]
[null,null,null,null,"Vejez",null,null,null,null,null,null,"Jubilación",null,null,null,null,null,null,null,null,"Asignación por retiro",null,null,null,null,null,null,null,null,null,null,null,null,null,"Asignación de retiro F.M","40. Resolución de pensión No."]
[]
[null,null,null,null,"Invalidez",null,null,null,null,null,null,"Sustitución",null,null,null,null,null,null,null,null,"Jubilación  por aportes ISS",null,null,null,null,null,null,null,null,null,null,null,null,null,"Jubilación aportes ISS","41. Fecha de Pensión:"]
[]
[null,null,null,null,"Muerte",null,null,null,null,null,null,"Pensión gracia",null,null,null,null,null,null,null,null,"Retiro por vejez"]
[]
[]
[null,"42. ¿Tiene indicios de que el trabajador fue pensionado por otra entidad? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sí",null,null,null,null,null,"43.  Entidad que lo pensionó"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,null,null,null,null,"44.  Nit de entidad que lo pensionó"]
[]
[null,"IMPORTANTE: Si el trabajador se vinculó antes del 1 de Julio de 1992, estaba activo a 30 de junio de 1992 y este formato es para certificar tiempos para Bono Pensional, se debe diligenciar y anexar el  formato \"CERTIFICACION DE SALARIO BASE PARA LIQUIDACION Y EMISION DE BONOS PENSIONALES\"."]
[]
[null,"Aceptamos que cualquier falsedad en esta información nos hará acreedores a las sanciones del artículo 50 del Decreto 1748/95."]
[null,"La información contenida en esta certificación reemplaza cualquier otra expedida en fecha anterior."]
[]
[]
[null,null,null,null,null,"Funcionario competente  para certificar",null,null,null,null,null,null,null,null,null,null,null,null,null,"Firma del funcionario",null,null,null,null,null,null,null,null,null,"Cargo del funcionario",null,"*Acto administrativo",null,null,null,null,null,null,null,null,null,null,null,"*Acto administrativo"]
[null,null,null,null,null,"C.C:"]
[null,"Advertencia:",null,null,null,null,"El diligenciamiento de la presente certificación no compromete a la entidad en aquellos casos en que la persona a la cual se le certifica información laboral no tenga  derecho a pensión o a ser beneficiario de Bono Pensional.\nEl diligenciamiento de la presente certificación no le genera automáticamente a la persona a la cual se le certifica información laboral,  el derecho a una pensión o a ser beneficiario de un Bono Pensional."]

{"sheet":"FORMATO 2","index":2,"n_rows":88,"n_cols":50,"rows_kept":88,"cut":false,"hidden":false,"merged":[[86,5,86,6],[86,7,86,15],[2,36,2,44],[2,46,2,52],[79,24,79,52],[80,1,80,52],[81,1,81,52],[82,1,82,52],[84,5,84,15],[84,29,84,40],[84,43,84,49],[74,18,74,23],[75,18,75,23],[76,18,76,23],[77,18,77,23],[79,1,79,16],[79,18,79,23],[71,1,71,11],[71,13,71,17],[71,18,71,35],[71,37,71,43],[71,44,71,52],[72,1,72,52],[70,13,70,17],[70,19,70,23],[70,25,70,29],[70,31,70,40],[70,42,70,46],[70,48,70,52],[68,48,68,52],[69,1,69,11],[69,13,69,17],[69,19,69,23],[69,25,69,29],[69,31,69,40],[69,42,69,46],[69,48,69,52],[68,1,68,11],[68,13,68,17],[68,19,68,23],[68,25,68,29],[68,31,68,40],[68,42,68,46],[66,48,66,52],[67,1,67,11],[67,13,67,17],[67,19,67,23],[67,25,67,29],[67,31,67,40],[67,42,67,46],[67,48,67,52],[66,1,66,11],[66,13,66,17],[66,19,66,23],[66,25,66,29],[66,31,66,40],[66,42,66,46],[64,1,65,11],[64,12,65,17],[64,18,65,23],[64,24,65,29],[64,30,65,40],[64,41,65,46],[62,48,62,52],[63,13,63,17],[63,19,63,23],[63,25,63,29],[63,31,63,40],[63,42,63,46],[63,48,63,52],[62,1,62,11],[62,13,62,17],[62,19,62,23],[62,25,62,29],[62,35,62,40],[62,42,62,46],[60,48,60,52],[61,1,61,11],[61,13,61,17],[61,19,61,23],[61,25,61,29],[61,35,61,40],[61,42,61,46],[61,48,61,52],[60,1,60,11],[60,13,60,17],[60,19,60,23],[60,25,60,29],[60,35,60,40],[60,42,60,46],[57,1,57,52],[59,1,59,11],[59,13,59,17],[59,19,59,23],[59,25,59,29],[59,35,59,40],[59,42,59,46],[59,48,59,52],[50,12,50,26],[50,36,50,51],[52,1,52,52],[54,1,54,23],[54,47,54,52],[55,1,55,18],[55,19,55,20],[55,22,55,52],[46,1,46,52],[47,1,49,7],[48,9,48,13],[48,14,48,26],[48,28,48,51],[49,9,49,11],[49,12,49,26],[49,28,49,30],[49,36,49,51],[38,1,38,52],[39,1,39,9],[39,10,39,25],[42,1,42,52],[44,2,44,16],[44,19,44,20],[44,23,44,24],[44,25,44,52],[34,1,34,18],[34,42,35,43],[34,44,35,45],[34,46,35,47],[34,48,35,49],[36,1,37,18],[36,42,36,49],[26,1,26,29],[26,41,26,42],[26,45,26,52],[28,1,28,52],[30,1,30,15],[31,44,33,52],[33,1,33,18],[33,36,33,43],[23,36,23,44],[23,45,23,46],[23,47,23,48],[23,49,23,52],[24,1,24,52],[25,1,25,29],[25,30,25,44],[25,45,25,52],[21,1,21,29],[21,30,21,44],[21,45,21,52],[22,1,23,29],[22,41,22,42],[22,45,22,46],[22,47,22,48],[22,49,22,52],[23,30,23,35],[15,1,15,13],[15,14,15,19],[15,20,15,45],[15,46,15,50],[17,1,17,7],[19,1,19,4],[19,5,19,13],[19,14,19,16],[19,17,19,25],[19,26,19,29],[19,30,19,52],[12,1,12,52],[13,1,13,8],[13,9,13,42],[13,43,13,45],[13,46,13,52],[14,1,14,13],[14,14,14,17],[14,18,14,45],[14,46,14,48],[10,1,10,13],[10,14,10,18],[10,19,10,45],[10,46,10,50],[11,1,11,4],[11,5,11,13],[11,14,11,16],[11,17,11,25],[11,26,11,29],[11,30,11,52],[7,1,7,52],[8,1,8,8],[8,9,8,42],[8,43,8,44],[8,45,8,52],[9,1,9,13],[9,14,9,16],[9,17,9,43],[9,44,9,48],[4,7,4,43],[4,45,4,46],[4,47,4,48],[4,50,4,51],[5,1,5,52],[6,36,6,44],[6,45,6,52],[0,1,0,52],[1,18,1,29],[1,36,1,52],[2,18,2,29],[3,1,3,52]]}
[null,"REPUBLICA DE COLOMBIA  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ciudad y fecha de expedición certificación:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORMATO No. 2",null,null,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":"TODAY()","v":"2018-04-04"}]
[null,"CERTIFICACION DE SALARIO BASE"]
[null,null,null,null,null,null,null,"Usar únicamente para certificar tiempos cotizados a Cajas públicas diferentes al ISS o tiempos no cotizados",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hoja",null,null,null,"de"]
[]
[null,"Diligenciar este formato de acuerdo a lo especificado en el instructivo.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Número consecutivo:"]
[null,"A. IDENTIFICACION   DE LA ENTIDAD QUE CERTIFICA"]
[null,"1. Nombre o Razón Social:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. NIT"]
[null,"3. Dirección",null,null,null,null,null,null,null,null,null,null,null,null,"4. Ciudad:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código Dane"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Departamento:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código Dane"]
[null,"6.Telefono",null,null,null,null,null,null,null,null,null,null,null,null,"7. Fax",null,null,null,null,null,null,null,null,null,null,null,"8. E-Mail:"]
[null,"B. IDENTIFICACION   DEL EMPLEADOR POR EL CUAL SE CERTIFICA TIEMPO"]
[null,"9. Nombre o Razón Social:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10. NIT:"]
[null,"11. Dirección",null,null,null,null,null,null,null,null,null,null,null,null,"12. Ciudad:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13. Departamento:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código"]
[]
[null,"14.Sector (Marcar uno)",null,null,null,null,null,null,null,null,"Sector Público Nacional",null,null,null,null,null,null,null,"Sector Público Departamental o Distrital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sector público Municipal"]
[]
[null,"15.Telefono",null,null,null,null,null,null,null,null,null,null,null,null,"16. Fax",null,null,null,null,null,null,null,null,null,null,null,"17. E-Mail:"]
[null,"C. IDENTIFICACION DEL TRABAJADOR"]
[null,"18.Apellidos y Nombres completos del trabajador:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19. Documento de identidad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20. Fecha de Nacimiento (Opcional)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TI",null,null,null,null,null,"CC","X",null,"CE",null,"NIT",null,null,null,"Día",null,"Mes",null,"Año"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No:"]
[null,"C.1 Datos de identificación alternos: (Diligenciar en caso que la persona tenga o haya tenido datos de identificación alternos)"]
[null,"21.Apellidos y Nombres alternos del trabajador:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22. Tipo Documento alterno",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23. No. Doc. Alterno:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TI",null,null,null,null,null,"CC",null,null,"CE",null,"NIT"]
[]
[null,"D. DETERMINACION DE FECHA  BASE PARA LIQUIDACION DE BONO PENSIONAL"]
[]
[null,"24.¿El trabajador estaba activo a 30 de Junio de 1992?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Marque con una X)",null,null,null,null,null,"Si",null,null,"No",null,null,null,"(si en la casilla 24 marcó \"SI\", pasar a la casilla 29)"]
[null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Día",null,null,"Mes",null,"Año",null,null,"(si diligenció la casilla 26, pasar a la casilla 29)"]
[]
[null,"25, ¿El trabajador se desvinculó antes del 30 de Junio de 1992?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si",null,null,null,null,"26. Laboró hasta el día"]
[null,"(Marque con una X)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,"Si marcó \"NO\" en la casilla 25, pasar a la casilla 27",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Día",null,"Mes",null,"Año"]
[]
[null,"27. El trabajador se hallaba suspendido o en licencia no remunerada A 30 de Junio/92? (Marque con una X)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si",null,null,null,"28. Fecha de inicio de licencia o suspensión"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"29. FECHA BASE. La fecha será: EL 30 de Junio de 1992, si a esta fecha el trabajador se encontraba activo y no se encontraba suspendido o en licencia, ó la Fecha de Retiro (fecha del campo 26), si el trabajador se desvinculó antes del 30 de Junio de 1992 ó si se encontraba en licencia no remunerada o suspendido, la víspera o día anterior a la fecha de inicio de la suspensión o de inicio de la licencia (día calendario anterior a la fecha del campo 28)."]
[null,"29.FECHA BASE (DIA-MES-AÑO)",null,null,null,null,null,null,null,null,"1992-06-01"]
[]
[]
[null,"E. APORTES PARA PENSIONES EN FECHA BASE"]
[]
[null,null,"30. ¿Se hacían aportes para pensiones en fecha base?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI",null,null,null,"NO",null,null,"Marcar con una \"X\" SI o NO  sí se descontó para Seguridad Social al trabajador."]
[]
[null,"F. ENTIDAD RESPONSABLE PARA PENSIONES EN FECHA BASE (si diligencia \"SI\" en la casilla 31 no es necesario diligenciar las casillas 32 y 33)"]
[null,"31. Periodo asumido por el empleador o entidad que reporta?"]
[null,null,null,null,null,null,null,null,null,"32. Caja  o Fondo:",null,null,null,null,"(diligenciar si se le aportaba a alguna Caja o Fondo)",null,null,null,null,null,null,null,null,null,null,null,null,null,"33. ENTIDAD QUE RESPONDE POR EL PERIODO"]
[null,null,null,null,null,null,null,null,null,"Nombre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre:"]
[null,null,"SI",null,null,"NO",null,null,null,"NIT:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NIT:"]
[]
[null,"G. FACTORES PARA EL CALCULO DEL SALARIO BASE (definidos por el Decreto 1158 de 1994)"]
[]
[null,"34. La vinculación empezó por lo menos un año antes de la fecha de Salario Base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI",null,null,null,"NO"]
[null,"35. Cuantos meses de vinculación  tiene antes de la fecha Base ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si respondió \"SI\" en el ítem anterior, este valor es igual a 12."]
[]
[null,"H. Factores Adicionales no Netos para determinación de Salario Base (Diligenciar de acuerdo con el total de meses del numeral 35, tomando como el \"Mes 12\" el mes del Salario Base y como \"Mes 11\" el mes inmediatamente anterior…)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mes 1",null,null,null,null,null,"Mes 2",null,null,null,null,null,"Mes 3",null,null,null,null,null,"Mes 4",null,null,null,null,null,null,null,null,null,null,"Mes 5",null,null,null,null,null,"Mes 6"]
[null,"Prima de antigüedad ascensional y de capacitación cuando sean factor de salario",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$"]
[null,"Remuneración por trabajo dominical o festivo.",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$"]
[null,"Remuneración por trabajo suplementario o de horas extras a realizarse en jornada nocturna",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$"]
[null,"Remuneración o Bonificación por servicios prestados",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$"]
[null,"Subtotal  Mensual",null,null,null,null,null,null,null,null,null,null,"$",{"$f":"SUM(N60:R63)","v":0},null,null,null,null,"$",{"$f":"SUM(T60:X63)","v":0},null,null,null,null,"$",{"$f":"SUM(Z60:AD63)","v":0},null,null,null,null,"$",0,null,null,null,null,null,null,null,null,null,"$",{"$f":"SUM(AQ60:AU63)","v":0},null,null,null,null,"$",{"$f":"SUM(AW60:BA63)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mes 7",null,null,null,null,null,"Mes 8",null,null,null,null,null,"Mes 9",null,null,null,null,null,"Mes 10",null,null,null,null,null,null,null,null,null,null,"Mes 11",null,null,null,null,null,"Mes 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 de la fecha Base"]
[null,"Prima de antigüedad ascensional y de capacitación cuando sean factor de salario",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$"]
[null,"Remuneración por trabajo dominical o festivo.",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$"]
[null,"Remuneración por trabajo suplementario o de horas extras a realizarse en jornada nocturna",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$"]
[null,"Remuneración o Bonificación por servicios prestados",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,"$",null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,"$"]
[null,"Subtotal  Mensual",null,null,null,null,null,null,null,null,null,null,"$",{"$f":"SUM(N67:R70)","v":0},null,null,null,null,"$",{"$f":"SUM(T67:X70)","v":0},null,null,null,null,"$",{"$f":"SUM(Z67:AD70)","v":0},null,null,null,null,"$",0,null,null,null,null,null,null,null,null,null,"$",{"$f":"SUM(AQ67:AU70)","v":0},null,null,null,null,"$",{"$f":"SUM(AW67:BA70)","v":0}]
[null,"36. Sumatoria de Subtotales Mensuales:",null,null,null,null,null,null,null,null,null,null,"$",{"$f":"N64+T64+Z64+AF64+AQ64+AW64+N71+T71+Z71+AF71+AQ71+AW71","v":0},null,null,null,null,"37. Promedio de la sumatoria de Subtotales Mensuales proporcional al número de meses:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,null,null,"Total del Numeral 36 dividido entre número de meses del numeral 35"]
[null,"I. CALCULO DEL SALARIO BASE"]
[null,null,"Los Factores de los Numerales 38, 39 y 40 Son los valores Netos a la fecha BASE (fecha del Numeral 29)"]
[null,null,null,"38. ASIGNACION BASICA MENSUAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"$"]
[null,null,null,"39. GASTOS DE REPRESENTACION",null,null,null,null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,null,"(Si los hubo en el mes que se certifica el salario base)"]
[null,null,null,"40. PRIMA TECNICA",null,null,null,null,null,null,null,null,null,null,null,null,null,"$",null,null,null,null,null,null,"(Solo si es factor de Salario)"]
[null,null,null,"41. Total de valores adicionales del numeral 37",null,null,null,null,null,null,null,null,null,null,null,null,null,"$"]
[]
[null,"42. SALARIO BASE TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"SUM(S75:X78)","v":0},null,null,null,null,null,"(Suma de los valores correspondientes a los numerales 38,39,40 y 41)"]
[]
[null,"Aceptamos que cualquier falsedad en esta información nos hará acreedores a las sanciones del artículo 50 del Decreto 1748/95."]
[null,"La información contenida en esta certificación reemplaza cualquier otra expedida en fecha anterior."]
[]
[]
[null,null,null,null,null,"Funcionario competente  para certificar",null,null,null,null,null,null,null,null,null,null,null,null,null,"Firma del funcionario",null,null,null,null,null,null,null,null,null,"Cargo del funcionario",null,"*Acto administrativo",null,null,null,null,null,null,null,null,null,null,null,"*Acto administrativo"]
[null,null,null,null,null,"C.C:"]
[null,"Observaciones:"]

{"sheet":"FORMATO 3B","index":3,"n_rows":64,"n_cols":56,"rows_kept":64,"cut":false,"hidden":false,"merged":[[62,2,62,12],[62,43,62,49],[63,6,65,52],[2,36,2,44],[2,46,2,52],[59,1,59,52],[60,1,60,12],[60,14,60,19],[60,21,60,27],[60,29,60,40],[60,43,60,51],[56,26,56,29],[56,30,56,37],[56,39,56,42],[56,43,56,47],[56,48,56,52],[58,1,58,52],[56,1,56,2],[56,3,56,5],[56,6,56,11],[56,12,56,16],[56,17,56,20],[56,21,56,25],[55,21,55,25],[55,26,55,29],[55,30,55,37],[55,39,55,42],[55,43,55,47],[55,48,55,52],[54,26,54,29],[54,30,54,37],[54,39,54,42],[54,43,54,47],[54,48,54,52],[55,1,55,2],[55,3,55,5],[55,6,55,11],[55,12,55,16],[55,17,55,20],[54,1,54,2],[54,3,54,5],[54,6,54,11],[54,12,54,16],[54,17,54,20],[54,21,54,25],[53,21,53,25],[53,26,53,29],[53,30,53,37],[53,39,53,42],[53,43,53,47],[53,48,53,52],[52,26,52,29],[52,30,52,37],[52,39,52,42],[52,43,52,47],[52,48,52,52],[52,21,52,25],[53,1,53,2],[53,3,53,5],[53,6,53,11],[53,12,53,16],[53,17,53,20],[52,1,52,2],[52,3,52,5],[52,6,52,11],[52,12,52,16],[52,17,52,20],[51,21,51,25],[51,26,51,29],[51,30,51,37],[51,39,51,42],[51,43,51,47],[51,48,51,52],[50,26,50,29],[50,30,50,37],[50,39,50,42],[50,43,50,47],[50,48,50,52],[50,21,50,25],[51,1,51,2],[51,3,51,5],[51,6,51,11],[51,12,51,16],[51,17,51,20],[50,1,50,2],[50,3,50,5],[50,6,50,11],[50,12,50,16],[50,17,50,20],[49,21,49,25],[49,26,49,29],[49,30,49,37],[49,39,49,42],[49,43,49,47],[49,48,49,52],[48,26,48,29],[48,30,48,37],[48,39,48,42],[48,43,48,47],[48,48,48,52],[48,21,48,25],[49,1,49,2],[49,3,49,5],[49,6,49,11],[49,12,49,16],[49,17,49,20],[48,1,48,2],[48,3,48,5],[48,6,48,11],[48,12,48,16],[48,17,48,20],[47,21,47,25],[47,26,47,29],[47,30,47,37],[47,39,47,42],[47,43,47,47],[47,48,47,52],[46,26,46,29],[46,30,46,37],[46,39,46,42],[46,43,46,47],[46,48,46,52],[46,21,46,25],[47,1,47,2],[47,3,47,5],[47,6,47,11],[47,12,47,16],[47,17,47,20],[46,1,46,2],[46,3,46,5],[46,6,46,11],[46,12,46,16],[46,17,46,20],[45,21,45,25],[45,26,45,29],[45,30,45,37],[45,39,45,42],[45,43,45,47],[45,48,45,52],[44,26,44,29],[44,30,44,37],[44,39,44,42],[44,43,44,47],[44,48,44,52],[44,21,44,25],[45,1,45,2],[45,3,45,5],[45,6,45,11],[45,12,45,16],[45,17,45,20],[44,1,44,2],[44,3,44,5],[44,6,44,11],[44,12,44,16],[44,17,44,20],[43,21,43,25],[43,26,43,29],[43,30,43,37],[43,39,43,42],[43,43,43,47],[43,48,43,52],[42,26,42,29],[42,30,42,37],[42,39,42,42],[42,43,42,47],[42,48,42,52],[42,21,42,25],[43,1,43,2],[43,3,43,5],[43,6,43,11],[43,12,43,16],[43,17,43,20],[42,1,42,2],[42,3,42,5],[42,6,42,11],[42,12,42,16],[42,17,42,20],[41,21,41,25],[41,26,41,29],[41,30,41,37],[41,39,41,42],[41,43,41,47],[41,48,41,52],[40,26,40,29],[40,30,40,37],[40,39,40,42],[40,43,40,47],[40,48,40,52],[40,21,40,25],[41,1,41,2],[41,3,41,5],[41,6,41,11],[41,12,41,16],[41,17,41,20],[40,1,40,2],[40,3,40,5],[40,6,40,11],[40,12,40,16],[40,17,40,20],[39,21,39,25],[39,26,39,29],[39,30,39,37],[39,39,39,42],[39,43,39,47],[39,48,39,52],[38,26,38,29],[38,30,38,37],[38,39,38,42],[38,43,38,47],[38,48,38,52],[38,21,38,25],[39,1,39,2],[39,3,39,5],[39,6,39,11],[39,12,39,16],[39,17,39,20],[38,1,38,2],[38,3,38,5],[38,6,38,11],[38,12,38,16],[38,17,38,20],[37,21,37,25],[37,26,37,29],[37,30,37,37],[37,39,37,42],[37,43,37,47],[37,48,37,52],[36,26,36,29],[36,30,36,37],[36,39,36,42],[36,43,36,47],[36,48,36,52],[36,21,36,25],[37,1,37,2],[37,3,37,5],[37,6,37,11],[37,12,37,16],[37,17,37,20],[36,1,36,2],[36,3,36,5],[36,6,36,11],[36,12,36,16],[36,17,36,20],[32,43,32,47],[32,48,32,52],[35,1,35,2],[35,3,35,5],[35,6,35,11],[35,12,35,16],[35,17,35,20],[34,1,34,2],[34,3,34,5],[34,6,34,11],[34,12,34,16],[34,17,34,20],[35,21,35,25],[35,26,35,29],[35,30,35,37],[35,39,35,42],[35,43,35,47],[35,48,35,52],[34,26,34,29],[34,30,34,37],[34,39,34,42],[34,43,34,47],[34,48,34,52],[34,21,34,25],[33,1,33,2],[33,3,33,5],[33,6,33,11],[33,12,33,16],[33,17,33,20],[28,1,28,52],[29,1,29,52],[30,1,30,52],[31,1,31,52],[32,1,32,2],[32,3,32,5],[32,6,32,11],[32,12,32,16],[32,17,32,20],[32,21,32,25],[33,21,33,25],[33,26,33,29],[33,30,33,37],[33,39,33,42],[33,43,33,47],[33,48,33,52],[32,26,32,29],[32,30,32,37],[32,39,32,42],[25,1,25,29],[25,30,25,44],[25,45,25,52],[26,1,26,29],[26,41,26,42],[26,45,26,52],[23,30,23,35],[23,36,23,44],[23,45,23,46],[23,47,23,48],[23,49,23,52],[24,1,24,52],[20,1,20,52],[21,1,21,29],[21,30,21,44],[21,45,21,52],[22,1,23,29],[22,41,22,42],[22,45,22,46],[22,47,22,48],[22,49,22,52],[15,1,15,13],[15,14,15,19],[15,20,15,45],[15,46,15,50],[17,1,17,7],[19,1,19,4],[19,5,19,13],[19,14,19,16],[19,17,19,25],[19,26,19,29],[19,30,19,52],[12,1,12,52],[13,1,13,8],[13,9,13,42],[13,43,13,45],[13,46,13,52],[14,1,14,13],[14,14,14,17],[14,18,14,45],[14,46,14,48],[10,1,10,13],[10,14,10,18],[10,19,10,45],[10,46,10,50],[11,1,11,4],[11,5,11,13],[11,14,11,16],[11,17,11,25],[11,26,11,29],[11,30,11,52],[7,1,7,52],[8,1,8,8],[8,9,8,42],[8,43,8,44],[8,45,8,52],[9,1,9,13],[9,14,9,16],[9,17,9,43],[9,44,9,48],[4,7,4,43],[4,45,4,46],[4,47,4,48],[4,50,4,51],[5,1,5,52],[6,36,6,44],[6,45,6,52],[0,1,0,52],[1,18,1,29],[1,36,1,52],[2,18,2,29],[3,1,3,52]]}
[null,"REPUBLICA DE COLOMBIA  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ciudad y fecha de expedición certificación:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORMATO No. 3 (B)",null,null,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":"TODAY()","v":"2018-04-04"}]
[null,"CERTIFICACION DE SALARIOS MES A MES"]
[null,null,null,null,null,null,null,"            Para liquidar Pensiones del Régimen de Prima Media ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hoja",null,null,null,"de"]
[]
[null,"Diligenciar este formato de acuerdo a lo especificado en el instructivo.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Número consecutivo:"]
[null,"A. IDENTIFICACION   DE LA ENTIDAD QUE CERTIFICA"]
[null,"1. Nombre o Razón Social:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. NIT"]
[null,"3. Dirección",null,null,null,null,null,null,null,null,null,null,null,null,"4. Ciudad:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código Dane"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Departamento:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código Dane"]
[null,"6.Telefono",null,null,null,null,null,null,null,null,null,null,null,null,"7. Fax",null,null,null,null,null,null,null,null,null,null,null,"8. E-Mail:"]
[null,"B. IDENTIFICACION   DEL EMPLEADOR POR EL CUAL SE CERTIFICAN SALARIOS"]
[null,"9. Nombre o Razón Social:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10. NIT:"]
[null,"11. Dirección",null,null,null,null,null,null,null,null,null,null,null,null,"12. Ciudad:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13. Departamento:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código"]
[]
[null,"14.Sector",null,null,null,null,null,null,null,null,"Sector Público Nacional",null,null,null,null,null,null,null,"Sector Público Departamental o Distrital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sector público Municipal"]
[]
[null,"15.Telefono",null,null,null,null,null,null,null,null,null,null,null,null,"16. Fax",null,null,null,null,null,null,null,null,null,null,null,"17. E-Mail:"]
[null,"C. IDENTIFICACION DEL TRABAJADOR"]
[null,"19.Apellidos y Nombres completos del trabajador:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20. Documento de identidad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21. Fecha de Nacimiento (Opcional)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TI",null,null,null,null,null,"CC",null,null,"CE",null,"NIT",null,null,null,"Día",null,"Mes",null,"Año"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No:"]
[null,"C.1 Datos de identificación alternos: (Diligenciar en caso que la persona tenga o haya tenido datos de identificación alternos)"]
[null,"21.Apellidos y Nombres alternos del trabajador:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22. Tipo Documento alterno",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23. No. Doc. Alterno:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TI",null,null,null,null,null,"CC",null,null,"CE",null,"NIT"]
[]
[null,"D. CERTIFICACION DE SALARIOS MES A MES PARA LA LIQUIDACION DE PENSIONES"]
[null,"NOTA: Hasta el 31 de marzo de 1.994 se certifica el salario devengado según el Decreto 1158 de 1994.  A partir del 1° de abril de 1994 se certifica el salario sobre el cual se cotizó o se debió cotizar a cualquier administradora del sistema general de Pensiones. Para entidades del orden territorial se debe certificar el salario devengado según el Decreto 1158 de 1994 a mas tardar hasta el 30 de junio de 1995 o fecha en que fue declarada insolvente la caja a la cual se efectuaban aportes."]
[null,"En el caso de los Regímenes especiales en la Casilla No. 27 (Asignación Básica Mensual) el valor de la asignación básica, será la suma de los factores salariales que no están incluidos en el Decreto 1158 de 1.994 sobre los cuales se han efectuado cotizaciones para pensión (Ej.: Sobresueldo INPEC, prima de antigüedad que se paga de manera mensual, etc.). Siempre y cuando exista una norma que especifique que estos factores son válidos para Pensión."]
[null,"(Si falta espacio use hoja adicional firmada con el mismo  número consecutivo) "]
[null,"24, AÑO",null,"25,   MES",null,null,"26. Observaciones",null,null,null,null,null,"27.  Asignación Básica Mensual",null,null,null,null,"28,  Gastos de Representación",null,null,null,"29,   Prima Técnica",null,null,null,null,"30A, Primas de antigüedad ascensional y de capacitación (Factor salarial)",null,null,null,"30B, Remuneración por trabajo dominical o festivo",null,null,null,null,null,null,null,null,"30C, Remuneración por trabajo suplementario o de horas extras en jornada nocturna ",null,null,null,"30D, Remuneración por servicios prestados",null,null,null,null,"31,  Total mes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(M34<>\"\",SUM(M34:AV34),\"\")","v":""},null,null,null,null,{"$f":"IF(D34<>\"\",VALUE(CONCATENATE(B34,VLOOKUP($D34,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B34=1989,$B34=1962),IF(AND($B34=1989,$D34=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B34=1962,OR($D34=\"Agosto\",$D34=\"Septiembre\",$D34=\"Octubre\",$D34=\"Noviembre\",$D34=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B34,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B34=1989,$B34=1962),IF(AND($B34=1989,$D34=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B34=1962,OR($D34=\"Agosto\",$D34=\"Septiembre\",$D34=\"Octubre\",$D34=\"Noviembre\",$D34=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B34,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(M35<>\"\",SUM(M35:AV35),\"\")","v":""},null,null,null,null,{"$f":"IF(D35<>\"\",VALUE(CONCATENATE(B35,VLOOKUP($D35,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B35=1989,$B35=1962),IF(AND($B35=1989,$D35=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B35=1962,OR($D35=\"Agosto\",$D35=\"Septiembre\",$D35=\"Octubre\",$D35=\"Noviembre\",$D35=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B35,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B35=1989,$B35=1962),IF(AND($B35=1989,$D35=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B35=1962,OR($D35=\"Agosto\",$D35=\"Septiembre\",$D35=\"Octubre\",$D35=\"Noviembre\",$D35=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B35,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D36<>\"\",VALUE(CONCATENATE(B36,VLOOKUP($D36,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B36=1989,$B36=1962),IF(AND($B36=1989,$D36=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B36=1962,OR($D36=\"Agosto\",$D36=\"Septiembre\",$D36=\"Octubre\",$D36=\"Noviembre\",$D36=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B36,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B36=1989,$B36=1962),IF(AND($B36=1989,$D36=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B36=1962,OR($D36=\"Agosto\",$D36=\"Septiembre\",$D36=\"Octubre\",$D36=\"Noviembre\",$D36=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B36,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D37<>\"\",VALUE(CONCATENATE(B37,VLOOKUP($D37,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B37=1989,$B37=1962),IF(AND($B37=1989,$D37=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B37=1962,OR($D37=\"Agosto\",$D37=\"Septiembre\",$D37=\"Octubre\",$D37=\"Noviembre\",$D37=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B37,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B37=1989,$B37=1962),IF(AND($B37=1989,$D37=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B37=1962,OR($D37=\"Agosto\",$D37=\"Septiembre\",$D37=\"Octubre\",$D37=\"Noviembre\",$D37=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B37,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D38<>\"\",VALUE(CONCATENATE(B38,VLOOKUP($D38,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B38=1989,$B38=1962),IF(AND($B38=1989,$D38=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B38=1962,OR($D38=\"Agosto\",$D38=\"Septiembre\",$D38=\"Octubre\",$D38=\"Noviembre\",$D38=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B38,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B38=1989,$B38=1962),IF(AND($B38=1989,$D38=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B38=1962,OR($D38=\"Agosto\",$D38=\"Septiembre\",$D38=\"Octubre\",$D38=\"Noviembre\",$D38=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B38,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D39<>\"\",VALUE(CONCATENATE(B39,VLOOKUP($D39,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B39=1989,$B39=1962),IF(AND($B39=1989,$D39=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B39=1962,OR($D39=\"Agosto\",$D39=\"Septiembre\",$D39=\"Octubre\",$D39=\"Noviembre\",$D39=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B39,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B39=1989,$B39=1962),IF(AND($B39=1989,$D39=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B39=1962,OR($D39=\"Agosto\",$D39=\"Septiembre\",$D39=\"Octubre\",$D39=\"Noviembre\",$D39=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B39,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D40<>\"\",VALUE(CONCATENATE(B40,VLOOKUP($D40,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B40=1989,$B40=1962),IF(AND($B40=1989,$D40=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B40=1962,OR($D40=\"Agosto\",$D40=\"Septiembre\",$D40=\"Octubre\",$D40=\"Noviembre\",$D40=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B40,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B40=1989,$B40=1962),IF(AND($B40=1989,$D40=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B40=1962,OR($D40=\"Agosto\",$D40=\"Septiembre\",$D40=\"Octubre\",$D40=\"Noviembre\",$D40=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B40,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D41<>\"\",VALUE(CONCATENATE(B41,VLOOKUP($D41,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B41=1989,$B41=1962),IF(AND($B41=1989,$D41=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B41=1962,OR($D41=\"Agosto\",$D41=\"Septiembre\",$D41=\"Octubre\",$D41=\"Noviembre\",$D41=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B41,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B41=1989,$B41=1962),IF(AND($B41=1989,$D41=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B41=1962,OR($D41=\"Agosto\",$D41=\"Septiembre\",$D41=\"Octubre\",$D41=\"Noviembre\",$D41=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B41,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D42<>\"\",VALUE(CONCATENATE(B42,VLOOKUP($D42,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B42=1989,$B42=1962),IF(AND($B42=1989,$D42=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B42=1962,OR($D42=\"Agosto\",$D42=\"Septiembre\",$D42=\"Octubre\",$D42=\"Noviembre\",$D42=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B42,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B42=1989,$B42=1962),IF(AND($B42=1989,$D42=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B42=1962,OR($D42=\"Agosto\",$D42=\"Septiembre\",$D42=\"Octubre\",$D42=\"Noviembre\",$D42=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B42,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D43<>\"\",VALUE(CONCATENATE(B43,VLOOKUP($D43,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B43=1989,$B43=1962),IF(AND($B43=1989,$D43=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B43=1962,OR($D43=\"Agosto\",$D43=\"Septiembre\",$D43=\"Octubre\",$D43=\"Noviembre\",$D43=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B43,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B43=1989,$B43=1962),IF(AND($B43=1989,$D43=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B43=1962,OR($D43=\"Agosto\",$D43=\"Septiembre\",$D43=\"Octubre\",$D43=\"Noviembre\",$D43=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B43,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D44<>\"\",VALUE(CONCATENATE(B44,VLOOKUP($D44,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B44=1989,$B44=1962),IF(AND($B44=1989,$D44=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B44=1962,OR($D44=\"Agosto\",$D44=\"Septiembre\",$D44=\"Octubre\",$D44=\"Noviembre\",$D44=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B44,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B44=1989,$B44=1962),IF(AND($B44=1989,$D44=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B44=1962,OR($D44=\"Agosto\",$D44=\"Septiembre\",$D44=\"Octubre\",$D44=\"Noviembre\",$D44=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B44,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D45<>\"\",VALUE(CONCATENATE(B45,VLOOKUP($D45,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B45=1989,$B45=1962),IF(AND($B45=1989,$D45=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B45=1962,OR($D45=\"Agosto\",$D45=\"Septiembre\",$D45=\"Octubre\",$D45=\"Noviembre\",$D45=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B45,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B45=1989,$B45=1962),IF(AND($B45=1989,$D45=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B45=1962,OR($D45=\"Agosto\",$D45=\"Septiembre\",$D45=\"Octubre\",$D45=\"Noviembre\",$D45=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B45,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D46<>\"\",VALUE(CONCATENATE(B46,VLOOKUP($D46,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B46=1989,$B46=1962),IF(AND($B46=1989,$D46=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B46=1962,OR($D46=\"Agosto\",$D46=\"Septiembre\",$D46=\"Octubre\",$D46=\"Noviembre\",$D46=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B46,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B46=1989,$B46=1962),IF(AND($B46=1989,$D46=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B46=1962,OR($D46=\"Agosto\",$D46=\"Septiembre\",$D46=\"Octubre\",$D46=\"Noviembre\",$D46=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B46,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D47<>\"\",VALUE(CONCATENATE(B47,VLOOKUP($D47,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B47=1989,$B47=1962),IF(AND($B47=1989,$D47=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B47=1962,OR($D47=\"Agosto\",$D47=\"Septiembre\",$D47=\"Octubre\",$D47=\"Noviembre\",$D47=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B47,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B47=1989,$B47=1962),IF(AND($B47=1989,$D47=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B47=1962,OR($D47=\"Agosto\",$D47=\"Septiembre\",$D47=\"Octubre\",$D47=\"Noviembre\",$D47=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B47,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D48<>\"\",VALUE(CONCATENATE(B48,VLOOKUP($D48,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B48=1989,$B48=1962),IF(AND($B48=1989,$D48=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B48=1962,OR($D48=\"Agosto\",$D48=\"Septiembre\",$D48=\"Octubre\",$D48=\"Noviembre\",$D48=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B48,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B48=1989,$B48=1962),IF(AND($B48=1989,$D48=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B48=1962,OR($D48=\"Agosto\",$D48=\"Septiembre\",$D48=\"Octubre\",$D48=\"Noviembre\",$D48=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B48,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D49<>\"\",VALUE(CONCATENATE(B49,VLOOKUP($D49,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B49=1989,$B49=1962),IF(AND($B49=1989,$D49=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B49=1962,OR($D49=\"Agosto\",$D49=\"Septiembre\",$D49=\"Octubre\",$D49=\"Noviembre\",$D49=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B49,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B49=1989,$B49=1962),IF(AND($B49=1989,$D49=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B49=1962,OR($D49=\"Agosto\",$D49=\"Septiembre\",$D49=\"Octubre\",$D49=\"Noviembre\",$D49=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B49,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D50<>\"\",VALUE(CONCATENATE(B50,VLOOKUP($D50,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B50=1989,$B50=1962),IF(AND($B50=1989,$D50=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B50=1962,OR($D50=\"Agosto\",$D50=\"Septiembre\",$D50=\"Octubre\",$D50=\"Noviembre\",$D50=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B50,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B50=1989,$B50=1962),IF(AND($B50=1989,$D50=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B50=1962,OR($D50=\"Agosto\",$D50=\"Septiembre\",$D50=\"Octubre\",$D50=\"Noviembre\",$D50=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B50,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D51<>\"\",VALUE(CONCATENATE(B51,VLOOKUP($D51,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B51=1989,$B51=1962),IF(AND($B51=1989,$D51=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B51=1962,OR($D51=\"Agosto\",$D51=\"Septiembre\",$D51=\"Octubre\",$D51=\"Noviembre\",$D51=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B51,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B51=1989,$B51=1962),IF(AND($B51=1989,$D51=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B51=1962,OR($D51=\"Agosto\",$D51=\"Septiembre\",$D51=\"Octubre\",$D51=\"Noviembre\",$D51=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B51,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D52<>\"\",VALUE(CONCATENATE(B52,VLOOKUP($D52,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B52=1989,$B52=1962),IF(AND($B52=1989,$D52=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B52=1962,OR($D52=\"Agosto\",$D52=\"Septiembre\",$D52=\"Octubre\",$D52=\"Noviembre\",$D52=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B52,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B52=1989,$B52=1962),IF(AND($B52=1989,$D52=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B52=1962,OR($D52=\"Agosto\",$D52=\"Septiembre\",$D52=\"Octubre\",$D52=\"Noviembre\",$D52=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B52,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D53<>\"\",VALUE(CONCATENATE(B53,VLOOKUP($D53,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B53=1989,$B53=1962),IF(AND($B53=1989,$D53=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B53=1962,OR($D53=\"Agosto\",$D53=\"Septiembre\",$D53=\"Octubre\",$D53=\"Noviembre\",$D53=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B53,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B53=1989,$B53=1962),IF(AND($B53=1989,$D53=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B53=1962,OR($D53=\"Agosto\",$D53=\"Septiembre\",$D53=\"Octubre\",$D53=\"Noviembre\",$D53=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B53,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D54<>\"\",VALUE(CONCATENATE(B54,VLOOKUP($D54,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B54=1989,$B54=1962),IF(AND($B54=1989,$D54=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B54=1962,OR($D54=\"Agosto\",$D54=\"Septiembre\",$D54=\"Octubre\",$D54=\"Noviembre\",$D54=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B54,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B54=1989,$B54=1962),IF(AND($B54=1989,$D54=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B54=1962,OR($D54=\"Agosto\",$D54=\"Septiembre\",$D54=\"Octubre\",$D54=\"Noviembre\",$D54=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B54,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D55<>\"\",VALUE(CONCATENATE(B55,VLOOKUP($D55,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B55=1989,$B55=1962),IF(AND($B55=1989,$D55=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B55=1962,OR($D55=\"Agosto\",$D55=\"Septiembre\",$D55=\"Octubre\",$D55=\"Noviembre\",$D55=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B55,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B55=1989,$B55=1962),IF(AND($B55=1989,$D55=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B55=1962,OR($D55=\"Agosto\",$D55=\"Septiembre\",$D55=\"Octubre\",$D55=\"Noviembre\",$D55=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B55,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D56<>\"\",VALUE(CONCATENATE(B56,VLOOKUP($D56,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B56=1989,$B56=1962),IF(AND($B56=1989,$D56=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B56=1962,OR($D56=\"Agosto\",$D56=\"Septiembre\",$D56=\"Octubre\",$D56=\"Noviembre\",$D56=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B56,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B56=1989,$B56=1962),IF(AND($B56=1989,$D56=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B56=1962,OR($D56=\"Agosto\",$D56=\"Septiembre\",$D56=\"Octubre\",$D56=\"Noviembre\",$D56=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B56,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(D57<>\"\",VALUE(CONCATENATE(B57,VLOOKUP($D57,PARAMETRO!$E$1:$F$13,2,0))),\"\")","v":""},{"$f":"IF(OR($B57=1989,$B57=1962),IF(AND($B57=1989,$D57=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,2,0),IF(AND($B57=1962,OR($D57=\"Agosto\",$D57=\"Septiembre\",$D57=\"Octubre\",$D57=\"Noviembre\",$D57=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,2,0))),VLOOKUP($B57,PARAMETRO!$A$1:$C$74,2,0))","v":{"$error":"#N/A"}},{"$f":"IF(OR($B57=1989,$B57=1962),IF(AND($B57=1989,$D57=\"Diciembre\"),VLOOKUP(\"1989/12\",PARAMETRO!$A$1:$C$74,3,0),IF(AND($B57=1962,OR($D57=\"Agosto\",$D57=\"Septiembre\",$D57=\"Octubre\",$D57=\"Noviembre\",$D57=\"Diciembre\")),VLOOKUP(\"1962/08\",PARAMETRO!$A$1:$C$74,3,0))),VLOOKUP($B57,PARAMETRO!$A$1:$C$74,3,0))","v":{"$error":"#N/A"}}]
[]
[null,"Aceptamos que cualquier falsedad en esta información nos hará acreedores a las sanciones del artículo 50 del Decreto 1748/95."]
[null,"La información contenida en esta certificación reemplaza cualquier otra expedida en fecha anterior."]
[]
[null,"Funcionario competente  para certificar",null,null,null,null,null,null,null,null,null,null,null,null,"Firma del funcionario",null,null,null,null,null,null,null,null,"Cargo",null,null,null,null,null,"*Acto administrativo",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha de  expedición"]
[null,"CC:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DD-MM-AAAA"]
[null,"Observaciones:",null,null,null,null,"El diligenciamiento de la presente certificación no compromete a la entidad en aquellos casos en que la persona a la cual se le certifica información laboral no tenga  derecho a pensión o a ser beneficiario de Bono Pensional.\nEl diligenciamiento de la presente certificación no le genera automáticamente a la persona a la cual se le certifica información laboral,  el derecho a una pensión o a ser beneficiario de un Bono Pensional."]

{"sheet":"PARAMETRO","index":4,"n_rows":72,"n_cols":6,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
["AÑO","SALARIO MINIMO","IBL BASE",null,"Mes","Número"]
[1950,60,785,null,"Enero","01"]
[1951,60,785,null,"Febrero","02"]
[1952,60,785,null,"Marzo","03"]
[1953,60,785,null,"Abril","04"]
[1954,60,785,null,"Mayo","05"]
[1955,60,785,null,"Junio","06"]
[1956,135,1765,null,"Julio","07"]
[1957,155,2027,null,"Agosto","08"]
[1958,155,2027,null,"Septiembre","09"]
[1959,155,2027,null,"Octubre","10"]
[1960,198,2589,null,"Noviembre","11"]
[1961,198,2589,null,"Diciembre","12"]
[1962,219,2863]
["1962/08",300,3922]
[1963,420,5490]
[1964,420,5490]
[1965,420,5490]
[1966,420,5490]
[1967,420,5490]
[1968,420,5490]
[1969,461,5490]
[1970,519,5490]
[1971,519,5490]
[1972,324,14610]
[1973,660,14610]
[1974,950,25530]
[1975,1200,25530]
[1976,1350,25530]
[1977,1887,25530]
[1978,2500,25530]
[1979,3450,79290]
[1980,4500,79290]
[1981,5700,79290]
[1982,7410,79290]
[1983,9261,163020]
[1984,11298,163020]
[1985,13558,163020]
[1986,16812,163020]
[1987,20510,163020]
[1988,25638,163020]
[1989,32560,163020]
["1989/12",32560,665070]
[1990,41025,665070]
[1991,51720,665070]
[1992,65190,665070]
[1993,81510,1644810]
[1994,98700,1974000]
[1995,118934,2378680]
[1996,142125,2842500]
[1997,172005,3440100]
[1998,203826,4076520]
[1999,236460,4729200]
[2000,260100,5200000]
[2001,286000,5720000]
[2002,309000,6180000]
[2003,332000,6640000]
[2004,358000,8950000]
[2005,381500,9537500]
[2006,408000,10200000]
[2007,433700,10842500]
[2008,461500,11537500]
[2009,496900,12422500]
[2010,515000,12875000]
[2011,535600,13390000]
[2012,566700,14167500]
[2013,589500,14737500]
[2014,616000,15400000]
[2015,644350,16108750]
[2016,689455,17236375]
[2017,737717,18442925]
[2018,781242,19531050]