{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Marzo","Encabezados"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Marzo","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,1,18,3],[20,1,20,4],[25,1,25,3],[27,1,27,3],[3,1,3,4],[6,1,6,3],[8,1,8,4],[12,1,12,3],[14,1,14,3],[16,1,16,3]]}
[]
[null,"CONCEPTO","BASE SALUD","BASE PENSIÓN","VALOR"]
[]
[null,"PAGOS SALARIALES"]
[null,"Salario Básico","SI","SI",1000000]
[null,"Comisiones","SI","SI",0]
[null,"TOTAL PAGOS SALARIALES",null,null,{"$f":"SUM(E5:E6)","v":1000000}]
[]
[null,"PAGOS NO SALARIALES"]
[null,"Aux. de alimentación no salarial","NO","NO",670000]
[null,"Bonificación no salarial","NO","NO",0]
[null,"Aux. de Transporte","NO","NO",0,"No se incluye según (0042111 Cotización factores no salariales)"]
[null,"TOTAL PAGOS NO SALARIALES",null,null,{"$f":"SUM(E10:E12)","v":670000}]
[]
[null,"TOTAL REMUNERACIÓN",null,null,{"$f":"E7+E13","v":1670000}]
[]
[null,"Limite de pagos No Salariales (Total Remuneración*40%)",null,null,{"$f":"E15*40%","v":668000}]
[]
[null,"Total Pagos no Salariales exceden el 40% del Total Remunerado (Pagos no salariales - Limite de pagos no salariales)",null,null,{"$f":"E13-E17","v":2000}]
[]
[null,"NOVEDADES DEL PERIODO"]
[null,"Incapacidad General",null,null,0,"Base mes actual."]
[null,"Vacaciones",null,null,0,"Es la base mes anterior."]
[null,"Descanso Remunerado",null,null,0,"Base mes actual."]
[null,"Licencia No Remunerada",null,null,0,"La registré manualmente con la base mes anterior."]
[null,"TOTAL NOVEDADES DEL PERIODO",null,null,{"$f":"SUM(E22:E25)","v":0}]
[]
[null,"IBC para salud y pensión (Total Pagos Salariales +Total pagos no Salariales exceden el 40%) + Novedades",null,null,{"$f":"E7+E26+(SUMIF(E19,\">0\"))","v":1002000}]
[]
[null,"Nota: Si (Total Pagos no Salariales exceden el 40% del Total Remunerado (Pagos no salariales - Limite de pagos no salariales))  da positivo  \nse suma al (IBC para salud y pensión (Total Pagos Salariales +Total pagos no Salariales exceden el 40%) + Novedades), si da negativo no se debe sumar."]

{"sheet":"Encabezados","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["0110001DEMO SYSCOM                                                                                                                                                                                             NI900064324       0E                    U                                                  14-28 2022-012022-020000000000          000110000294190360100"]