{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TURNOS","EMPLEADOS","LIQUIDACION INDIVIDUAL","REGISTRO NOVEDADES GENERALES","DESPRENDIBLES DE NÓMINA"],"not_rendered":{"charts":0,"images":0,"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":"TURNOS","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["CODIGO","TURNO ","HO","RN","HED","HEN","HFD","HFN","HEFD","HEFN"]
[1,"Descanso",8]
[2,"6am-2pm",8]
[3,"2pm-10pm",8]
[4,"10pm-6am",8]
[5,"4am-12m",8]
[6,"12m-8pm",8]
[7,"7am-5pm",8]
[8,"8am-4pm",8]
[9,"8am-6pm",8]
[10,"8am-8pm",8]
[11,"8pm-4am",8]
[12,"6am-4pm",8]
[13,"2pm-12pm",8]
[14,"10pm-8am",8]
[15,"4am-2pm",8]
[16,"12m-10pm",8]
[17,"8pm-6am",8]
[18,"6am-6pm",8]
[19,"6pm-6am",8]
[20,"4am-4pm",8]
[21,"4pm-4am",8]
[22,"6am-2pm",8]
[23,"2pm-10pm",8]
[24,"10pm-6am",8]
[25,"F10pm-6am",8]
[26,"O10pm-6am",8]
[27,"4am-12m",8]
[28,"12m-8pm",8]
[29,"8pm-4am"]
[30,"O8pm-4am",8]
[31,"F8pm-4am",8]
[32,"6am-4pm",8]
[33,"2pm-12pm",8]
[34,"10pm-8am",8]
[35,"F10pm-8am",8]
[36,"O10pm-8am",8]
[37,"4am-2pm",8]
[38,"12m-10pm",8]
[39,"8pm-6am",8]
[40,"F8pm-6am",8]
[41,"O8pm-6am",8]
[42,"6am-6pm",8]
[43,"6pm-6am",8]
[44,"F6pm-6am",8]
[45,"O6pm-6am",8]
[46,"4am-4pm",8]
[47,"4pm-4am",8]
[48,"F4pm-4am",8]
[49,"O4pm-4am",8]

{"sheet":"EMPLEADOS","index":1,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["CEDULA","NOMBRE","SALARIO BASICO","AREA"]
[4096,"ACEVEDO AYALA FABIO ANDRES",900000,"CONTABILIDAD"]
[4070,"ALARCON FRAILE DILBER MAURICIO",980000,"COMERCIAL"]
[4168,"ANGUCHO LOPEZ JOSE LUIS",900000,"BODEGA"]
[4336,"ANGULO CUERO JOSE EDWIN",1300000,"BODEGA"]
[4370,"ANZOLA VASQUEZ DIANA JAZMIN",1500000,"PRODUCCION"]
[4057,"BARRAGAN PAEZ HEINER ANDRES",1400000,"LOGISTICA"]
[4434,"BARRIOS FLOREZ LISSETTE",1200000,"CONTABILIDAD"]
[4432,"CANTOR  ESCOBAR JULIO ALEXANDE",900000,"COMERCIAL"]
[4005,"CASTRO BUITRAGO JOHAN JAVIER",870000,"BODEGA"]
[4418,"CASTRO URIBE LUZ ELENA",1340000,"BODEGA"]
[4445,"CRUZ  NOVA JULIE MILENA",644350,"PRODUCCION"]
[4293,"NIETO VELA JORGE EDUARDO",644350,"LOGISTICA"]
[4451,"ORTIZ CABEZAS JESUS MARIA",700000,"CONTABILIDAD"]
[4080,"OSORIO GONZALEZ JAIRO ENRIQUE",800000,"COMERCIAL"]
[4307,"PACHECO LARA JULLI MARCELA",800000,"BODEGA"]
[4473,"PALOMEQUE GUERRERO DIEGO EDISO",900000,"BODEGA"]
[4461,"PARDO SANCHEZ SILVIA ARACELY",760000,"PRODUCCION"]
[4110,"PATINO HEREDIA DAVID",980000,"LOGISTICA"]
[4072,"PENA SEPULVEDA MAURICIO ALEJAN",1200000,"CONTABILIDAD"]
[4334,"PIZA TORRES ALEXANDER",1300000,"COMERCIAL"]
[4008,"POLANIA CARLOS ALBERTO",1500000,"BODEGA"]
[4192,"QUINONES ALARCON CRISTIAN CAMI",1800000,"CONTABILIDAD"]
[4350,"QUINTERO CHAMORRO JOSE CAMILO",1200000,"COMERCIAL"]
[4116,"RIOS HERRERA CLAUDIA  MILENA",900000,"BODEGA"]
[4430,"RODRIGUEZ ANGEL CARLOS EDUARDO",760000,"BODEGA"]
[4398,"ROJAS QUINTERO IVAN MAURICIO",4500000,"PRODUCCION"]
[4100,"GONZALEZ IZQUIERDO LUZ",3000000,"CONTABILIDAD"]

{"sheet":"LIQUIDACION INDIVIDUAL","index":2,"n_rows":61,"n_cols":18,"rows_kept":61,"cut":false,"hidden":false,"merged":[[52,0,52,8],[60,0,60,3],[60,4,60,8],[58,4,58,8],[59,4,59,8],[53,0,53,3],[54,0,54,3],[55,0,55,3],[56,0,56,3],[57,0,57,3],[58,0,58,3],[59,0,59,3],[53,4,53,8],[54,4,54,8],[55,4,55,8],[56,4,56,8],[57,4,57,8],[27,0,27,3],[27,4,27,8],[21,5,21,6],[19,0,19,1],[19,4,19,6],[19,7,19,11],[21,7,21,11],[26,0,26,8],[28,0,28,3],[28,4,28,8],[29,0,29,3],[29,4,29,8],[30,0,30,3],[30,4,30,8],[31,0,31,3],[31,4,31,8],[32,0,32,3],[32,4,32,8],[33,0,33,3],[33,4,33,8],[42,4,42,8],[43,0,43,3],[43,4,43,8],[34,0,34,3],[34,4,34,8],[35,0,35,3],[35,4,35,8],[38,0,38,3],[38,4,38,8],[50,0,50,8],[22,0,22,6],[36,0,36,3],[37,0,37,3],[36,4,36,8],[37,4,37,8],[44,0,44,3],[44,4,44,8],[46,0,46,8],[47,0,47,3],[47,4,47,8],[49,0,49,8],[40,0,40,8],[41,0,41,3],[41,4,41,8],[42,0,42,3]]}
["FECHA","DIA ","CODIGO TURNO","TURNO ","HO","RN","HED","HEN","HFD","HFN","HEFD","HEFN"]
["2015-08-01","lunes",null,{"$f":"IFERROR(VLOOKUP(C2,turnos,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C2,turnos,3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C2,turnos,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C2,turnos,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C2,turnos,6,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C2,turnos,7,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C2,turnos,8,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C2,turnos,9,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C2,turnos,10,0),\"\")","v":""}]
["2015-08-02","martes",null,"","","","","","","","",""]
["2015-08-03","miércoles",null,"","","","","","","","",""]
["2015-08-04","jueves",null,"","","","","","","","",""]
["2015-08-05","viernes",null,"","","","","","","","",""]
["2015-08-06","sábado",null,"","","","","","","","",""]
["2015-08-07","domingo",null,"","","","","","","","",""]
["2015-08-08","lunes",null,"","","","","","","","",""]
["2015-08-09","martes",null,"","","","","","","","",""]
["2015-08-10","miércoles",null,"","","","","","","","",""]
["2015-08-11","jueves",null,"","","","","","","","",""]
["2015-08-12","viernes",null,"","","","","","","","",""]
["2015-08-13","sábado",null,"","","","","","","","",""]
["2015-08-14","domingo",null,"","","","","","","","",""]
["2015-08-15","lunes",null,{"$f":"IFERROR(VLOOKUP(C16,turnos,2,0),\"\")","v":""},"","","","","","","",""]
[null,null,null,{"$f":"IFERROR(VLOOKUP(C17,turnos,2,0),\"\")","v":""},"","","","","","","",""]
[null,"DIAS LABORADOS",{"$f":"COUNT(C2:C17)","v":0},null,{"$f":"SUM(E2:E17)","v":0},{"$f":"SUM(F2:F17)","v":0},0,0,0,0,0,0]
[]
["CEDULA",null,null,null,"NOMBRE",null,null,{"$f":"IFERROR(VLOOKUP(D20,EMPLEADOS,2,0),\"\")","v":""}]
[]
[null,null,null,null,null,"SB",null,{"$f":"IFERROR(VLOOKUP(D20,EMPLEADOS,3,0),\"\")","v":""}]
["RESUMEN LIQUIDACION INDIVIDUAL"]
["CEDULA","NOMBRE","DIAS LABORADOS","SB DEVENGADO","TOTAL NOVEDADES","COMISIONES","BONIFICACIONES","TOTAL DEVENGADO","TOTAL DEDUCCCIONES","AUXILIO DE TRASNPORTE","NETO A PAGAR",{"$f":"G1","v":"HED"},{"$f":"H1","v":"HEN"},{"$f":"F1","v":"RN"},{"$f":"I1","v":"HFD"},{"$f":"J1","v":"HFN"},"HEFD","HEFN"]
[{"$f":"D20","v":0},{"$f":"H20","v":""},{"$f":"C18","v":0},{"$f":"E28","v":0},{"$f":"E36","v":0},{"$f":"E37","v":0},{"$f":"E38","v":0},{"$f":"E39","v":0},{"$f":"E45","v":0},{"$f":"E48","v":0},{"$f":"A51","v":0},{"$f":"G18","v":0},{"$f":"H18","v":0},{"$f":"F18","v":0},{"$f":"I18","v":0},{"$f":"J18","v":0},{"$f":"K18","v":0},{"$f":"L18","v":0}]
[]
["DEVENGADOS"]
["SALARIO BASICO",null,null,null,{"$f":"IFERROR(H22*E18/240,0)","v":0}]
["RN",null,null,null,{"$f":"IFERROR(H22*0.35*F18/240,0)","v":0}]
["HED",null,null,null,{"$f":"IFERROR(H22*1.25*G18/240,0)","v":0}]
["HEN",null,null,null,{"$f":"IFERROR(H22*1.75*H18/240,0)","v":0}]
["HFD",null,null,null,{"$f":"IFERROR(H22*I18*1.75/240,0)","v":0}]
["HFN",null,null,null,{"$f":"IFERROR(H22*2.1*J18/240,0)","v":0}]
["HEFD",null,null,null,{"$f":"IFERROR(H22*2*K18/240,0)","v":0}]
["HEFN",null,null,null,{"$f":"IFERROR(H22*2.5*L18/240,0)","v":0}]
["TOTAL NOVEDADES",null,null,null,{"$f":"SUM(E29:I35)","v":0}]
["COMISIONES"]
["BONIFICACIONES"]
["TOTAL DEVENGADO",null,null,null,{"$f":"E28+E36+E37+E38","v":0}]
[]
["DEDUCCIONES"]
["SALUD",null,null,null,{"$f":"E39*4%","v":0}]
["PENSION",null,null,null,{"$f":"E39*4%","v":0}]
["PRESTAMO"]
["TOTAL DEDUCCIONES",null,null,null,{"$f":"SUM(E42:I44)","v":0}]
[]
["AUXILIO DE TRANSPORTE"]
["AUX TRANS",null,null,null,{"$f":"IF(H22<(689454*2),(E18*77700)/240,0)","v":0}]
[]
["NETO A PAGAR"]
[{"$f":"E39-E45+E48","v":0}]
[]
["APROPIACIONES"]
["PENSION",null,null,null,76845]
["RIESGOS",null,null,null,3342.7574999999997]
["PRIMA",null,null,null,53343.237500000003]
["CESANTIAS",null,null,null,53343.237500000003]
["INT CESANTIAS",null,null,null,533.43237500000009]
["VACACIONES",null,null,null,18765]
["CAJA COMPENSACION",null,null,null,25615]
["TOTAL APROPIACIONES","TOTAL APROPIACIONES",null,null,{"$f":"SUM(E54:I60)","v":231787.66487499999}]

{"sheet":"REGISTRO NOVEDADES GENERALES","index":3,"n_rows":2,"n_cols":18,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["CEDULA","NOMBRE","DIAS LABORADOS","SB DEVENGADO","TOTAL NOVEDADES","COMISIONES","BONIFICACIONES","TOTAL DEVENGADO","TOTAL DEDUCCCIONES","AUXILIO DE TRASNPORTE","NETO A PAGAR","HED","HEN","RN","HFD","HFN","HEFD","HEFN"]
[4057,"BARRAGAN PAEZ HEINER ANDRES",15,700000,0,0,0,700000,56000,0,644000,0,0,0,0,0,0,0]

{"sheet":"DESPRENDIBLES DE NÓMINA","index":4,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[59,0,59,2],[60,0,60,2],[60,3,60,5],[53,0,53,2],[54,0,54,2],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[39,3,39,5],[43,2,43,5],[48,3,48,4],[49,3,49,4],[52,0,52,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[28,3,28,4],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[17,0,17,2],[18,0,18,2],[18,3,18,5],[22,2,22,5],[27,3,27,4],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[1,2,1,5],[6,3,6,4],[7,3,7,4],[10,0,10,2],[11,0,11,2]]}
[]
[null,null,"DESPRENDIBLE PAGO DE NOMINA"]
[]
[]
[]
[]
["NOMBRE            :"]
["Doc. Identidad  :"]
["MES                    :"]
[]
["CONCEPTO",null,null,"CANTIDAD","DEVENGADO","DEDUCIDO"]
["SALARIO",null,null,30,408000]
["SUBSIDIO",null,null,null,47700]
["OTROS INGRESOS (     )",null,null,null,0]
["SALUD EMPLEADO",null,null,null,null,{"$f":"+E12*4%","v":16320}]
["PENSION EMPLEADO",null,null,null,null,{"$f":"+E12*3.875%","v":15810}]
["OTROS DESCUENTOS",null,null,null,null,0]
["SUBTOTAL",null,null,null,{"$f":"SUM(E12:E17)","v":455700},{"$f":"SUM(F12:F17)","v":32130}]
["NETO A PAGAR",null,null,{"$f":"+E18-F18","v":423570}]
[]
[]
[]
[null,null,"DESPRENDIBLE PAGO DE NOMINA"]
[]
[]
[]
[]
["NOMBRE            :"]
["Doc. Identidad  :"]
["MES                    :"]
[]
["CONCEPTO",null,null,"CANTIDAD","DEVENGADO","DEDUCIDO"]
["SALARIO",null,null,30,408000]
["SUBSIDIO",null,null,null,47700]
["OTROS INGRESOS (     )",null,null,null,0]
["SALUD EMPLEADO",null,null,null,null,{"$f":"+E33*4%","v":16320}]
["PENSION EMPLEADO",null,null,null,null,{"$f":"+E33*3.875%","v":15810}]
["OTROS DESCUENTOS",null,null,null,null,0]
["SUBTOTAL",null,null,null,{"$f":"SUM(E33:E38)","v":455700},{"$f":"SUM(F33:F38)","v":32130}]
["NETO A PAGAR",null,null,{"$f":"+E39-F39","v":423570}]
[]
[]
[]
[null,null,"DESPRENDIBLE PAGO DE NOMINA"]
[]
[]
[]
[]
["NOMBRE            :"]
["Doc. Identidad  :"]
["MES                    :"]
[]
["CONCEPTO",null,null,"CANTIDAD","DEVENGADO","DEDUCIDO"]
["SALARIO",null,null,30,408000]
["SUBSIDIO",null,null,null,47700]
["OTROS INGRESOS (     )",null,null,null,0]
["SALUD EMPLEADO",null,null,null,null,{"$f":"+E54*4%","v":16320}]
["PENSION EMPLEADO",null,null,null,null,{"$f":"+E54*3.875%","v":15810}]
["OTROS DESCUENTOS",null,null,null,null,0]
["SUBTOTAL",null,null,null,{"$f":"SUM(E54:E59)","v":455700},{"$f":"SUM(F54:F59)","v":32130}]
["NETO A PAGAR",null,null,{"$f":"+E60-F60","v":423570}]