{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["TURNOS","EMPLEADOS","LIQUIDACION INDIVIDUAL","APROPIACIONES","REGISTRO NOVEDADES GENERALES","LIQUIDACION GENERAL","DESPRENDIBLES DE NÓMINA","PRESTACIONES","INDEMNIZACION INDEFINIDO"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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,8]
[5,"4am-12m",8,2]
[6,"12m-8pm",8]
[7,"7am-5pm",8]
[8,"8am-4pm",8]
[9,"8am-6pm",8,null,2]
[10,"8am-8pm",8,null,4]
[11,"8pm-4am",8,6]
[12,"6am-4pm",8,null,2]
[13,"2pm-12pm",8,null,null,2]
[14,"10pm-8am",8,8,2]
[15,"4am-2pm",8,2,2]
[16,"12m-10pm",8,null,2]
[17,"8pm-6am",8,6,null,2]
[18,"6am-6pm",8,null,4]
[19,"6pm-6am",8,4,null,4]
[20,"4am-4pm",8,2,4]
[21,"4pm-4am",8,2,null,4]
[22,"6am-2pm",8,null,null,null,8]
[23,"2pm-10pm",8,null,null,null,8]
[24,"10pm-6am",8,null,null,null,null,8]
[25,"F10pm-6am",8,6,null,null,null,2]
[26,"O10pm-6am",8,2,null,null,null,6]
[27,"4am-12m",8,null,null,null,6,2]
[28,"12m-8pm",8,null,null,null,8]
[29,"8pm-4am",null,null,null,null,2,6]
[30,"O8pm-4am",8,2,null,null,null,4]
[31,"F8pm-4am",8,4,null,null,2,2]
[32,"6am-4pm",8,null,null,null,8,null,2]
[33,"2pm-12pm",8,null,null,null,8,null,null,2]
[34,"10pm-8am",8,null,null,null,null,6,2]
[35,"F10pm-8am",8,6,2,null,null,2]
[36,"O10pm-8am",8,2,null,null,null,6,2]
[37,"4am-2pm",8,null,null,null,6,2,2]
[38,"12m-10pm",8,null,null,null,8,null,2]
[39,"8pm-6am",8,null,null,null,2,6,null,2]
[40,"F8pm-6am",8,4,null,2,2,2]
[41,"O8pm-6am",8,2,null,null,null,4,null,2]
[42,"6am-6pm",8,null,null,null,8,null,4]
[43,"6pm-6am",8,null,null,null,4,4,null,4]
[44,"F6pm-6am",8,2,null,4,4,2]
[45,"O6pm-6am",8,2,null,null,null,2,null,4]
[46,"4am-4pm",8,null,null,null,6,2,4]
[47,"4pm-4am",8,null,null,null,6,2,null,4]
[48,"F4pm-4am",8,null,null,4,6,2]
[49,"O4pm-4am",8,2,null,null,null,null,null,4]

{"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":[[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],[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],[31,4,31,8],[32,0,32,3],[32,4,32,8],[33,0,33,3],[33,4,33,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],[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]]}
["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,4096,"NOMBRE",null,null,{"$f":"IFERROR(VLOOKUP(D20,EMPLEADOS,2,0),\"\")","v":"ACEVEDO AYALA FABIO ANDRES"}]
[]
[null,null,null,null,null,"SB",null,{"$f":"IFERROR(VLOOKUP(D20,EMPLEADOS,3,0),\"\")","v":900000}]
["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":4096},{"$f":"H20","v":"ACEVEDO AYALA FABIO ANDRES"},{"$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<(644350*2),(E18*74000)/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":"APROPIACIONES","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SALARIO BASICO","DEVENGADO BRUTO","AUX TRANSPORTE"]
["PENSION"]
[]
["RIESGOS"]
[]
["PRIMA"]
[]
["CESANTIAS"]
[]
["INT CESANTIAS"]
[]
["VACACIONES"]
[]
["CAJA COMPENSACION"]

{"sheet":"REGISTRO NOVEDADES GENERALES","index":4,"n_rows":1,"n_cols":18,"rows_kept":1,"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"]

{"sheet":"LIQUIDACION GENERAL","index":5,"n_rows":116,"n_cols":44,"rows_kept":116,"cut":false,"hidden":false,"merged":[[89,9,89,12],[103,9,103,12],[115,16,116,19],[115,9,115,12],[91,9,91,14],[105,9,105,14],[106,16,108,19],[110,16,111,19],[113,16,113,19],[70,7,70,9],[50,10,51,11],[75,10,75,12],[74,9,74,14],[53,14,53,16],[67,14,67,16],[64,14,65,16],[60,14,62,16],[7,23,8,23],[7,28,7,29],[7,30,7,31],[7,32,7,33],[7,24,8,24],[4,1,4,26],[4,28,4,43],[6,9,6,16],[6,18,6,24],[7,36,7,37],[7,34,7,35],[7,9,8,9],[7,20,8,20],[6,26,8,26],[6,43,8,43],[7,14,8,14],[7,11,8,11],[7,10,8,10],[7,38,7,39],[7,40,7,41],[7,21,8,21],[39,20,40,26],[41,21,41,23],[50,5,51,5],[69,14,69,16],[6,1,8,1],[6,3,8,3],[6,5,8,5],[6,7,8,7],[7,12,8,12],[7,15,8,15],[7,16,8,16],[41,3,71,3],[62,5,62,12],[52,5,52,12],[41,5,41,12],[7,13,8,13]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V"]
[null,"NOMINA PARA EL PAGO DE SUELDOS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRABAJO EXTRA MES DE AGOSTO"]
[]
[null,"COD",null,"DOCUMENTO ",null,"NOMBRES",null,"SUELDO BÁSICO MENSUAL ",null," D E V E N G A D O",null,null,null,null,null,null,null,null,"DEDUCIDO",null,null,null,null,null,null,null,"FIRMA DE RECIBIDO ",null,1.25,null,1.75,null,0.35,null,1.75,null,2.1,null,2,null,2.5,null,null,"VALOR TOTAL DE HORAS EXTRAS Y RECARGOS"]
[null,null,null,null,null,null,null,null,null,"DIAS LABORADOS","BÁSICO DEVENGADO ","EXTRAS Y RECARGOS","COMISIONES","BONIFICACIONES","TOTAL DEVENGADO ","AUXILIO DE TRANSPORTE","DEVENGADO CON AUXILIO DE TRANSPORTE",null,"SALUD","PENSIÓN","FONDO DE SOLIDARIDAD","RETENCIÓN EN LA FUENTE SALARIOS","APORTE A SINDICATO","TOTAL DEDUCIDO ","NETO A PAGAR",null,null,null,"H EXTRA DIURNA",null,"H EXTRA NOCTURNA",null,"RECARGO NOCTURNO",null,"HORA FESTIVA DIURNA ",null,"HORA FESTIVA NOCTURNA",null,"HORA EXTRA FESTIVA DIURNA",null,"HORA EXTRA FESTIVA NOCTURNA "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.04,0.04,null,null,0.02,null,null,null,null,null,"CANT.","VALOR","CANT.","VALOR.","CANT.","VALOR.","CANT.","VALOR","CANT.","VALOR","CANT.","VALOR.","H.E.F.D.","H.E.F.N."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.04,3.3750000000000002E-2,"SOCIAL 1%","FUENTE","SIND  2%","DEDUCIDO","PAGAR",null,"FIRMA",null,null,null,null,null,null,null,null,null,null,null,null,null,"H.E.F.D.","H.E.F.N."]
[null,1,null,4070,null,{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS,2,0),\"\")","v":"ALARCON FRAILE DILBER MAURICIO"},null,{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS,3,0),\"\")","v":980000},null,{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,3,0),\"\")","v":""},{"$f":"IFERROR(SUM(H11/30*J11),0)","v":0},{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,6,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,7,0),\"\")","v":""},{"$f":"IFERROR(SUM(K11:N11),0)","v":0},{"$f":"IF((H11)<=(644350*2),74000/30*(J11),0)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(+O11+P11,0)","v":0},null,{"$f":"+O11*$S$9","v":0},{"$f":"+O11*$T$9","v":0},{"$f":"IF((O11)>2464000,(O11)*1%,0)","v":0},null,null,{"$f":"SUM(S11:W11)","v":0},{"$f":"+Q11-X11","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,12,0),\"\")","v":""},{"$f":"IFERROR((+H11*AC11*$AC$7)/240,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,13,0),\"\")","v":""},{"$f":"IFERROR(+H11*AE11*$AE$7/240,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,14,0),\"\")","v":""},{"$f":"IFERROR(+H11*AG11*$AG$7/240,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,15,0),\"\")","v":""},{"$f":"IFERROR(+H11*AI11*$AI$7/240,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,16,0),\"\")","v":""},{"$f":"IFERROR(+H11*AK11*$AK$7/240,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,17,0),\"\")","v":""},{"$f":"IFERROR(+H11*AM11*$AM$7/240,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(D11,EMPLEADOS2,18,0),\"\")","v":""},{"$f":"IFERROR(+H11*AO11*$AO$7/240,\"\")","v":""},null,{"$f":"IFERROR(+AP11+AN11+AL11+AJ11+AH11+AF11+AD11,\"\")","v":""}]
[null,{"$f":"+B11+1","v":2},null,null,null,"",null,"",null,"",{"$f":"IFERROR(SUM(H12/30*J12),0)","v":0},"","","",{"$f":"IFERROR(SUM(K12:N12),0)","v":0},0,{"$f":"IFERROR(+O12+P12,0)","v":0},null,{"$f":"+O12*$S$9","v":0},{"$f":"+O12*$T$9","v":0},{"$f":"IF((O12)>2464000,(O12)*1%,0)","v":0},null,null,{"$f":"SUM(S12:W12)","v":0},{"$f":"+Q12-X12","v":0},null,null,null,"",{"$f":"IFERROR((+H12*AC12*$AC$7)/240,\"\")","v":""},"",{"$f":"IFERROR(+H12*AE12*$AE$7/240,\"\")","v":""},"",{"$f":"IFERROR(+H12*AG12*$AG$7/240,\"\")","v":""},"",{"$f":"IFERROR(+H12*AI12*$AI$7/240,\"\")","v":""},"",{"$f":"IFERROR(+H12*AK12*$AK$7/240,\"\")","v":""},"",{"$f":"IFERROR(+H12*AM12*$AM$7/240,\"\")","v":""},"",{"$f":"IFERROR(+H12*AO12*$AO$7/240,\"\")","v":""},null,{"$f":"IFERROR(+AP12+AN12+AL12+AJ12+AH12+AF12+AD12,\"\")","v":""}]
[null,{"$f":"+B12+1","v":3},null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,{"$f":"IF((O13)>2464000,(O13)*1%,0)","v":0},null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,4,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,5,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,6,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,7,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,8,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,9,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,10,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,11,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,12,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,13,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,14,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,15,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,16,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,17,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,18,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,19,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,20,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,21,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,22,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,23,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,24,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,25,null,null,null,"",null,"",null,"",0,"","","",0,0,0,null,0,0,0,null,null,0,0,null,null,null,"","","","","","","","","","","","","","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O36+P36)","v":0},null,null,{"$f":"SUM(#REF!+O36)*3.375%","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"SUM(H11:H35)","v":980000},null,null,{"$f":"SUM(K11:K35)","v":0},{"$f":"SUM(L11:L35)","v":0},0,0,0,{"$error":"#VALUE!"},0,null,{"$f":"SUM(S11:S35)","v":0},{"$f":"SUM(T11:T35)","v":0},0,0,0,0,0,null,{"$f":"SUM(AA11:AA28)","v":0},null,{"$f":"SUM(AC11:AC36)","v":0},{"$f":"SUM(AD11:AD35)","v":0},{"$f":"SUM(AE11:AE36)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AR11:AR36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!+O38)*3.375%","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTABILIZACIÓN DE LA NÓMINA"]
[]
[null,null,null,"APROPIACIONES DE NÓMINA",null,"PROVISIÓN PARA PRESTACIONES SOCIALES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CÓDIGO","CUENTAS",null,null,"DÉBITO ",null,"CRÉDITO "]
[]
[null,null,null,null,null,null,null,null,null,"BASE DE LIQUIDACIÓN",null,"%","PROVISIÓN EMPRESA",null,null,null,null,null,null,null,5105,"GASTOS DE PERSONAL "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,510506,"  Sueldos",null,null,{"$f":"+K37","v":0}]
[null,null,null,null,null,"CESANTIAS",null,null,null,{"$f":"+Q37","v":0},null,8.3299999999999999E-2,{"$f":"+J46*L46","v":0},null,null,null,null,null,null,null,510515,"  Horas Extras y Recargos",null,null,{"$f":"+L37","v":0}]
[null,null,null,null,null,"INTERESES SOBRE CESANTÍAS",null,null,null,{"$f":"+M46","v":0},null,0.12,{"$f":"+J47*L47","v":0},null,null,null,null,null,null,null,510518,"  Comisiones",null,null,{"$f":"+M37","v":0}]
[null,null,null,null,null,"VACACIONES",null,null,null,{"$f":"+O37","v":0},null,4.1700000000000001E-2,{"$f":"+J48*L48","v":0},null,null,null,null,null,null,null,510527,"   Auxilio de Transporte",null,null,{"$f":"+P37","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"PRIMA DE SERVICIOS",null,null,null,{"$f":"+Q37","v":0},null,8.3299999999999999E-2,{"$f":"+J49*L49","v":0},null,null,null,null,null,null,null,510548,"  Bonificaciones",null,null,{"$f":"+N37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M46:M49)","v":0},null,null,null,null,null,null,null,2370,"RETENCIONES Y APORTES DE NÓMINA"]
[null,null,null,null,null,"Total Devengado (Incluyendo auxilio de transporte)",null,null,null,null,"Total Devengado (Sin Incluir Auxilio de Transporte)",null,null,null,null,null,null,null,null,null,237005,"  Aportes a Entidades Promotoras de Salud",null,null,null,null,{"$f":"+S37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,237045,"  Fondos de Pensión",null,null,null,null,{"$f":"+T37","v":0}]
[null,null,null,null,null,"PROVISIÓN PARA LA SEGURIDAD SOCIAL ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,237045,"   Fondo de Solidaridad",null,null,null,null,{"$f":"+U37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESUMEN ",null,null,null,null,null,"237035","  Sindicatos",null,null,null,null,{"$f":"+W37","v":0}]
[null,null,null,null,null,null,null,"BASE DE LIQUIDACIÓN",null,"TRABAJADOR","EMPRESA","%","TOTAL A PAGAR",null,"TRABAJADOR","EMPRESA","TOTAL ",null,null,null,"2380","ACREEDORES VARIOS"]
[null,null,null,null,null,"SALUD",null,{"$f":"+$O$37+$P$37","v":{"$error":"#VALUE!"}},null,{"$f":"+S37","v":0},{"$f":"+H56*L56","v":{"$error":"#VALUE!"}},0,{"$f":"+J56+K56","v":{"$error":"#VALUE!"}},"SALUD",0.04,8.5000000000000006E-2,{"$f":"+O56+P56","v":0.125},null,null,null,"238030","  Fondos de Cesantías y/o Pensiones"]
[null,null,null,null,null,"PENSIÓN",null,{"$f":"+$O$37+$P$37","v":{"$error":"#VALUE!"}},null,{"$f":"+T37","v":0},{"$f":"+H57*L57","v":{"$error":"#VALUE!"}},0.12,{"$f":"+J57+K57","v":{"$error":"#VALUE!"}},"PENSIÓN",0.04,0.12,{"$f":"+O57+P57","v":0.16},null,null,null,2365,"RETENCIÓN EN LA FUENTE"]
[null,null,null,null,null,"ARL",null,{"$error":"#VALUE!"},null,null,{"$f":"+H58*L58","v":{"$error":"#VALUE!"}},4.3499999999999997E-2,{"$f":"+K58","v":{"$error":"#VALUE!"}},"ARL",null,5.2199999999999998E-3,{"$f":"+O58+P58","v":5.2199999999999998E-3},null,null,null,"236505","  Salarios y Pagos Laborales",null,null,null,null,{"$f":"+V37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M56:M58)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,1110,"BANCOS",null,null,null,{"$f":"+Y37","v":0},{"$f":"+Y37","v":0}]
[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":"SUM(Y43:Y59)","v":{"$error":"#VALUE!"}},{"$f":"SUM(Z43:Z59)","v":0},0]
[null,null,null,null,null,"Sin incluir aux de transporte",null,null,null,null,null,null,null,null,"Con la Ley 1607 de 2012, art. 25, quedan exonerados excepcionalmente de aportes al ICBF y SENA:"]
[]
[null,null,null,null,null,"PROVISIÓN PARAFISCALES"]
[]
[null,null,null,null,null,null,null,"BASE DE LIQUIDACIÓN",null,"TRABAJADOR","EMPRESA","%","TOTAL A PAGAR",null," - Las sociedades y personas juridicas y asimiladas contribuyentes del impuesto de renta y complementarios.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AA60-Y60","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"CAJA DE COMPENSACIÓN ",null,{"$f":"+$O$37+$P$37","v":{"$error":"#VALUE!"}},null,0,{"$f":"+H66*L66","v":{"$error":"#VALUE!"}},0.04,{"$f":"+K66","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"SENA",null,{"$f":"+$O$37+$P$37","v":{"$error":"#VALUE!"}},null,0,{"$f":"+H67*L67","v":{"$error":"#VALUE!"}},0,{"$f":"+K67","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"ICBF",null,{"$error":"#VALUE!"},null,0,{"$f":"+H68*L68","v":{"$error":"#VALUE!"}},0,{"$f":"+K68","v":{"$error":"#VALUE!"}},null,"-Las personas naturales empleadoras que tengan dos o más empleados."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M66:M68)","v":{"$error":"#VALUE!"}},null,"Requisito: No superen los 10 Salarios mínimos"]
[null,null,null,null,null,null,null,"Total Devengado (Sin incluir Aux de Transporte)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+F42","v":"PROVISIÓN PARA PRESTACIONES SOCIALES"}]
[null,null,null,null,null,null,null,null,null,"CÓDIGOS","CUENTAS",null,null,"DÉBITOS","CRÉDITOS"]
[]
[null,null,null,null,null,null,null,null,null,5105,"GASTOS DE PERSONAL "]
[null,null,null,null,null,null,null,null,null,510530,"Cesantías",null,null,{"$f":"+M46","v":0}]
[null,null,null,null,null,null,null,null,null,510533,"Intereses sobre cesantías",null,null,{"$f":"+M47","v":0}]
[null,null,null,null,null,null,null,null,null,"510539","Vacaciones",null,null,{"$f":"+M48","v":0}]
[null,null,null,null,null,null,null,null,null,"510536","Prima de Servicios",null,null,{"$f":"+M49","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"26","PASIVOS ESTIMADOS Y PROVISIONES"]
[null,null,null,null,null,null,null,null,null,"2610","PARA OBLIGACIONES LABORALES"]
[null,null,null,null,null,null,null,null,null,"261005","Cesantías",null,null,null,{"$f":"+N79","v":0}]
[null,null,null,null,null,null,null,null,null,"261010","Intereses sobre cesantías",null,null,null,{"$f":"+N80","v":0}]
[null,null,null,null,null,null,null,null,null,"261015","Vacaciones",null,null,null,{"$f":"+N81","v":0}]
[null,null,null,null,null,null,null,null,null,"261020","Prima de Servicios",null,null,null,{"$f":"+N82","v":0}]
[null,null,null,null,null,null,null,null,null,"SUMAS IGUALES",null,null,null,{"$f":"SUM(N79:N89)","v":0},{"$f":"SUM(O79:O89)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+F53","v":"PROVISIÓN PARA LA SEGURIDAD SOCIAL "}]
[null,null,null,null,null,null,null,null,null,"CÓDIGOS","CUENTAS",null,null,"DÉBITOS","CRÉDITOS"]
[]
[null,null,null,null,null,null,null,null,null,5105,"GASTOS DE PERSONAL "]
[null,null,null,null,null,null,null,null,null,"510569"," Aportes a Entidades Promotoras de Salud",null,null,{"$f":"+K56","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"510570"," Aportes a fondos de pensiones y/o cesantías",null,null,{"$f":"+K57","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"510568"," Administradora de Riesgos Profesionales",null,null,{"$f":"+K58","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,"2370","RETENCIONES Y APORTES DE NÓMINA"]
[null,null,null,null,null,null,null,null,null,237005,"  Aportes a Entidades Promotoras de Salud EPS",null,null,null,{"$f":"+N96","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,237045,"  Fondos de Pensión",null,null,null,{"$f":"+N97","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,237006,"  Aportes a Administradoras de Riesgos Profesionales",null,null,null,{"$f":"+N98","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"SUMAS IGUALES",null,null,null,{"$f":"SUM(N96:N103)","v":{"$error":"#VALUE!"}},{"$f":"SUM(O96:O103)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+F63","v":"PROVISIÓN PARAFISCALES"}]
[null,null,null,null,null,null,null,null,null,"CÓDIGOS","CUENTAS",null,null,"DÉBITOS","CRÉDITOS",null,"Con la Ley 1607 de 2012, art. 25, quedan exonerados excepcionalmente de aportes al ICBF y SENA:"]
[]
[null,null,null,null,null,null,null,null,null,5105,"GASTOS DE PERSONAL "]
[null,null,null,null,null,null,null,null,null,510572," Aportes a Cajas de Compensación Familiar",null,null,{"$f":"+K66","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,510575," Aportes Icbf",null,null,{"$f":"+K68","v":{"$error":"#VALUE!"}},null,null," - Las sociedades y personas juridicas y asimiladas contribuyentes del impuesto de renta y complementarios."]
[null,null,null,null,null,null,null,null,null,510578," Aportes Sena",null,null,{"$f":"+K67","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,"2370","RETENCIONES Y APORTES DE NÓMINA"]
[null,null,null,null,null,null,null,null,null,237010,"Aportes al ICBF, SENA  Cajas de Compensación ",null,null,null,{"$f":"SUM(N110:N112)","v":{"$error":"#VALUE!"}},null,"-Las personas naturales empleadoras que tengan dos o más empleados."]
[]
[null,null,null,null,null,null,null,null,null,"SUMAS IGUALES",null,null,null,{"$f":"SUM(N110:N115)","v":{"$error":"#VALUE!"}},{"$f":"SUM(O110:O114)","v":{"$error":"#VALUE!"}},null,"Requisito: No superen los 10 Salarios mínimos"]

{"sheet":"DESPRENDIBLES DE NÓMINA","index":6,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,2,1,5],[6,3,6,4],[7,3,7,4],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[18,3,18,5],[22,2,22,5],[27,3,27,4],[28,3,28,4],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[39,3,39,5],[43,2,43,5],[48,3,48,4],[49,3,49,4],[52,0,52,2],[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]]}
[]
[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}]

{"sheet":"PRESTACIONES","index":7,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[10,5,10,8],[43,3,48,9],[2,3,2,9],[4,5,4,8],[5,5,5,8],[6,5,6,8],[7,5,7,8],[9,5,9,8]]}
[]
[]
[null,null,null,"LIQUIDACION FINAL DE PRESTACIONES SOCIALES"]
[]
[null,null,null,"NOMBRE DEL EMPEADO",null,"ALEJANDRO CARDONA"]
[null,null,null,"CARGO",null,"MENSAJERO"]
[null,null,null,"FECHA DE INGRESO",null,"2008-02-22"]
[null,null,null,"FECHA DE RETIRO",null,"2008-09-02"]
[null,null,null,"DIAS LABORADOS",null,{"$f":"DAYS360(F7,F8)+1","v":191}]
[null,null,null,"TIPO CONTRATO",null,"FIJO"]
[null,null,null,"CAUSAL DE RETIRO"]
[]
[null,null,null,"SALARIO BASE DE LIQUIDACION",null,null,null,null,null,1340000]
[null,null,null,"SUELDO PROMEDIO ULTIMO AÑO",null,null,null,null,null,1420000]
[null,null,null,"AUXILIO DE TRANSPORTE"]
[null,null,null,"TOTAL",null,null,null,null,null,{"$f":"+J14+J15","v":1420000}]
[]
[null,null,null,"VACACIONES"]
[null,null,null,"DESDE","HASTA"]
[null,null,null,"2015-08-28","2015-09-26",null,{"$f":"J13","v":1340000},"X",{"$f":"DAYS360(D20,E20)+2","v":30},{"$f":"+(G20*I20)/H21","v":55833.333333333336}]
[null,null,null,null,null,null,null,720]
[null,null,null,"PRIMA DE SERVICIOS"]
[null,null,null,"DESDE","HASTA"]
[null,null,null,"2015-07-01",{"$f":"+E20","v":"2015-09-26"},null,{"$f":"+J16","v":1420000},"X",{"$f":"DAYS360(D24,E24)+2","v":87},{"$f":"+(G24*I24)/H25","v":343166.66666666669}]
[null,null,null,null,null,null,null,360]
[null,null,null,"CESANTIAS"]
[null,null,null,"DESDE","HASTA"]
[null,null,null,"2015-01-01",{"$f":"+E24","v":"2015-09-26"},null,{"$f":"+J16","v":1420000},"X",{"$f":"DAYS360(D28,E28)+2","v":267},{"$f":"+(G28*I28)/H29","v":1053166.6666666667}]
[null,null,null,null,null,null,null,360]
[null,null,null,"INTERESES CESANTIAS"]
[null,null,null,"DESDE","HASTA"]
[null,null,null,{"$f":"+D28","v":"2015-01-01"},{"$f":"+E28","v":"2015-09-26"},null,{"$f":"+J28","v":1053166.6666666667},"X   0,12   X",{"$f":"+DAYS360(D32,E32)+2","v":267},{"$f":"+(G32*0.12*I32)/H33","v":93731.833333333328}]
[null,null,null,null,null,null,null,360]
[null,null,null,"TOTAL PAGOS",null,null,null,null,null,{"$f":"+J20+J24+J28+J32","v":1545898.5}]
[]
[null,null,null,"INDEMNIZACION",null,null,null,null,null,{"$f":"'[1]INDEM INF 10 SMLV '!K31","v":4985296.2962962966}]
[]
[null,null,null,"B. DEDUCCIONES"]
[]
[null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,"TOTAL A PAGAR",null,null,null,null,null,{"$f":"+J34+J36-J40","v":6531194.7962962966}]
[]
[null,null,null,"Declaro haber recibido de ABC LTDA, la suma indicada arriba por los conceptos detallados, liquidacion que ha sido realizada conforme a lo establecido en el Código Sustantivo del Trabajo, razon por la cual la Empresa ABC LTDA se encuentra a paz y salvo."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"FIRMA TRABAJADOR"]
[null,null,null,"C.C"]
[]
[]
[null,null,null,null,null,null,"   "]

{"sheet":"INDEMNIZACION INDEFINIDO","index":8,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[11,6,11,9],[22,7,23,9],[3,3,3,10],[5,6,5,9],[6,6,6,9],[7,6,7,9],[8,6,8,9],[9,6,9,9]]}
[]
[]
[]
[null,null,null,"LIQUIDACION INDEMNIZACION CONTRATO A TERMINO INDEFINIDO CON SUELDO INFERIOR A 10 SMLV"]
[]
[null,null,null,"NOMBRE DEL EMPEADO"]
[null,null,null,"CARGO"]
[null,null,null,"FECHA DE INGRESO",null,null,"2010-08-28"]
[null,null,null,"FECHA DE RETIRO",null,null,"2015-09-26"]
[null,null,null,"DIAS LABORADOS",null,null,{"$f":"DAYS360(G8,G9)+1","v":1829}]
[null,null,null,"AÑOS LABORADOS",null,null,{"$f":"+G10/360","v":5.0805555555555557}]
[]
[]
[null,null,null,"SALARIO BASE DE LIQUIDACION",null,null,null,null,null,null,1340000]
[]
[null,null,null,"INDEMNIZACION"]
[null,null,null,null,null,"SUELDO","X",30]
[null,null,null,"PRIMER AÑO",null,null,30]
[]
[null,null,null,null,null,{"$f":"+K14","v":1340000},"X",30,null,null,{"$f":"+F20*H20/G21","v":1340000}]
[null,null,null,null,null,null,30]
[]
[null,null,null,null,null,null,null,"AÑOS LABORADOS MENOS 1"]
[null,null,null,null,null,"SUELDO    X","20  X"]
[null,null,null," AÑOS SUBSIGUIENTES",null,null,30]
[]
[null,null,null,null,null,{"$f":"+K14","v":1340000},"X",20,"X",{"$f":"+G11-1","v":4.0805555555555557},{"$f":"+F27*H27*J27/G28","v":3645296.2962962966}]
[null,null,null,null,null,null,30]
[]
[]
[null,null,null,"TOTAL INDEMNIZACION",null,null,null,null,null,null,{"$f":"+K27+K20","v":4985296.2962962966}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"   "]