{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Prestaciones Sociales","Indemnizaciones","Hoja3"],"not_rendered":{"charts":0,"images":2,"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":"Prestaciones Sociales","index":0,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[[13,2,13,3],[3,1,3,9],[4,1,4,9],[5,1,5,9],[11,1,11,3],[12,2,12,3],[2,11,2,15],[3,11,5,11],[3,12,5,12],[3,13,5,13],[3,14,5,14],[3,15,5,15],[53,1,56,9],[57,1,59,9],[11,5,11,9],[25,4,25,8],[26,4,26,8],[38,1,38,8],[43,1,43,8],[49,1,52,9],[19,4,19,8],[20,4,20,8],[21,4,21,8],[23,1,23,2],[23,4,23,9],[24,4,24,8],[18,1,18,2],[18,4,18,9],[30,1,30,9],[39,1,39,9],[47,1,48,9],[15,2,15,3],[6,2,6,9],[7,2,7,9],[8,2,8,9],[9,2,9,9],[10,1,10,9],[12,5,12,8],[13,5,13,8],[14,5,14,8],[46,1,46,9],[11,4,15,4],[16,1,17,9],[14,2,14,3]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"SALARIO PROMEDIO"]
[null,"LIQUIDACION DE CONTRATO DE TRABAJO A TERMINO FIJO",null,null,null,null,null,null,null,null,null,"MES","COMISIONES","H.EXTRAS","DOM Y FEST","REC.NOCT."]
[null,"TECNOLOGIA MODULAR S.A.S"]
[null,"NIT 900.580.736-4",null,null,null,null,null,null,null,null,null,null,"COMISIONES"]
[null,"NOMBRE DEL EMPLEADO:",null,null,null,null,null,null,null,null,null,"ENERO",0,0,0,0]
[null,"C.C.:",null,null,null,null,null,null,null,null,null,"FEBRERO",0,0,0,0]
[null,"CARGO:",null,null,null,null,null,null,null,null,null,"MARZO",0,0,0,0]
[null,"CAUSA DE LA LIQUIDACION:",null,null,null,null,null,null,null,null,null,"ABRIL",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"MAYO",0,0,0,0]
[null,"PERIODO DE LIQUIDACION",null,null,null,"SALARIO BASE DE LIQUIDACION:",null,null,null,null,null,"JUNIO",0,0,0,0]
[null,"FECHA TERMINACION DE CONTRATO","2012-11-25",null,null,"SUELDO BASICO:",null,null,null,1000000,null,"JULIO",0,0,0,0]
[null,"FECHA DE INICIO CONTRATO","2011-10-18",null,null,"AUXILIO DE TRANSPORTE:",null,null,null,67800,null,"AGOSTO",0,0,0,0]
[null,"TIEMPO TOTAL LABORADO",{"$f":"DAYS360(C14,C13)+1","v":398},null,null,"PROMEDIO SALARIO VARIABLE",null,null,null,{"$f":"+P21","v":0},null,"SEPTIEMBRE",0,0,0,0]
[null,null,null,null,null,"TOTAL BASE DE LIQUIDACION:",null,null,null,{"$f":"SUM(J13:J15)","v":1067800},null,"OCTUBRE",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"NOVIEMBRE",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"DICIEMBRE",0,0,0,0]
[null,"PRIMA",null,null,"CESANTIAS",null,null,null,null,null,null,"TOTAL",{"$f":"SUM(M7:M18)","v":0},{"$f":"SUM(N7:N18)","v":0},0,0]
[null,"FECHA DE LIQUIDACION PRIMA","2012-06-30",null,"FECHA DE LIQUIDACION CESANTIAS",null,null,null,null,"2012-01-01",null,"PROMEDIO",{"$f":"AVERAGE(M7:M18)","v":0},{"$f":"AVERAGE(N7:N18)","v":0},0,0]
[null,"FECHA DE CORTE PRIMA",{"$f":"+C13","v":"2012-11-25"},null,"FECHA DE CORTE CESANTIAS",null,null,null,null,{"$f":"+C13","v":"2012-11-25"},null,null,null,null,null,{"$f":"SUM(M20:P20)","v":0}]
[null,"DIAS PRIMA",{"$f":"DAYS360(C20,C21)","v":145},null,"DIAS CESANTIAS",null,null,null,null,{"$f":"DAYS360(J20,J21)","v":324}]
[]
[null,"VACACIONES",null,null,"INTERESES A LAS CESANTIAS"]
[null,"FECHA DE LIQUIDACION VACACIONES","2010-10-17",null,"FECHA DE LIQUIDACION INTERESES",null,null,null,null,{"$f":"+J20","v":"2012-01-01"}]
[null,"FECHA DE CORTE VACACIONES",{"$f":"+C13","v":"2012-11-25"},null,"FECHA DE CORTE INTERESES",null,null,null,null,{"$f":"+J21","v":"2012-11-25"}]
[null,"TOTAL DIAS DE VACIONES",{"$f":"((15*(C26-C25-$J$17)/360))-0.25","v":31.833333333333336},null,"DIAS INTERESES",null,null,null,null,{"$f":"(DAYS360(J25,J26)*12%)/360","v":0.10799999999999998}]
[null,"DIAS TOMADOS DE VACACIONES",0]
[null,"DIAS PENDIENTES",{"$f":"+C27-C28","v":31.833333333333336}]
[]
[null,"RESUMEN LIQUIDACION PAGOS:"]
[null,"VACACIONES PENDIENTES:",{"$f":"J16-J14","v":1000000},"/",{"$f":"C29","v":31.833333333333336},"x",30,"=",null,{"$f":"((C32/G32)*E32)","v":1061111.1111111112}]
[null,"CESANTIAS:  ",{"$f":"J16","v":1067800},"/",360,"x",{"$f":"J22-$J$17","v":324}," ",null,{"$f":"((C33*G33)/E33)","v":961020}]
[null,"INTERESES DE CESANTIAS",{"$f":"$J$33","v":961020},"/",360,"x",{"$f":"J27-$J$17","v":0.10799999999999998},"X ",0.12,{"$f":"((C34*G34*I34)/E34)","v":34.596719999999998}]
[null,"PRIMA SERVICIOS",{"$f":"J16","v":1067800},"/",360,"x",{"$f":"C22","v":145},"=",null,{"$f":"((C35*G35)/E35)","v":430086.11111111112}]
[null,"CESANTIAS:  ",{"$f":"+C35","v":1067800},"/",360,"x",{"$f":"+J22","v":324},"=",null,{"$f":"((C36*G36)/E36)","v":961020}]
[null,"INTERESES DE CESANTIAS",{"$f":"+J36","v":961020},null,null,"x",{"$f":"+J27","v":0.10799999999999998},"=",null,{"$f":"+$C$37*$G$37","v":103790.15999999999}]
[null,"INDEMNIZACION",null,null,null,null,null,null,null,{"$f":"+Indemnizaciones!C16+Indemnizaciones!F16+Indemnizaciones!I16","v":6000000}]
[null,"TOTAL DEVENGOS",null,null,null,null,null,null,null,{"$f":"SUM(J32:J38)","v":9517061.9789422229}]
[null,"RESUMEN DESCUENTOS LIQUIDACION :"]
[null,"SALUD:",0.04,null,null,null,null,null,null,{"$f":"(SUM(E41:G41)*-C41)","v":0},null,{"$f":"J39-J44","v":9517061.9789422229}]
[null,"PENSION:  ",0.04,null,null,null,null,null,null,{"$f":"(SUM(E42:G42)*-C42)","v":0}]
[null,"PRESTAMOS O ANTICIPOS:",null,null,null,null,null,null,null,{"$f":"SUM(E43:G43)","v":0}]
[null,"TOTAL DEDUCCIONES",null,null,null,null,null,null,null,{"$f":"SUM(J41:J43)","v":0}]
[]
[null,"VALOR LIQUIDACION ",null,null,null,null,null,null,null,{"$f":"ROUND(L41,0)","v":9517062}]
[null,{"$f":"PesosMN(J46)","v":"SON: ( NUEVE MILLONES QUINIENTOS DIECISIETE MIL SESENTA Y DOS PESOS 00/100 M.N.)"}]
[null,"SE HACE CONSTAR:"]
[]
[null,"1. Que el patrono ha incorporado en la presente liquidación los importes correspondientes a salarios, horas extras, descansos compensatorios, cesantías, vacaciones, prima de servicios, auxilio de transporte, y en sí, todo concepto   relacionado con salarios, prestaciones o indemnizaciones causadas al quedar extinguido el contrato de trabajo."]
[]
[]
[]
[null,"2. Que con el pago del dinero anotado en la presente liquidación, queda transada cualquier diferencia relativa al contrato de trabajo extinguido, o a cualquier diferencia anterior. Por lo tanto, esta transacción tiene como efecto la terminaciónde las obligaciones provenientes de la relación laboral que existió entre EL EJEMPLO S.A y el trabajador, quienes declaran estar a paz y salvo por todo concepto."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"EL EMPLEADOR"]
[null,"EL EMPLEADO",null,null,null,null,null,null,"NIT. "]
[null,"C.C."]

{"sheet":"Indemnizaciones","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,1,3,8],[5,1,5,5],[5,7,5,8],[6,1,6,5],[7,7,7,8],[7,1,7,2],[7,4,7,5]]}
[]
[]
[]
[null,"INDEMNIZACIONES POR DESPIDO SIN JUSTA CAUSA"]
[]
[null,"CONTRATO A TERMINO INDEFINIDO",null,null,null,null,null,"CONTRATO A TERMINO FIJO"]
[null,"Art. 28 de la Ley 789 del 2002"]
[null,"1. Cuando el trabajador devenga MENOS de 10 SMMLV",null,null,"2. Cuando el trabajador devenga MAS de  10 SMMLV",null,null,"Art. 64 del C.S.T."]
[null,"DETALLE","DATOS",null,"DETALLE","DATOS",null,"DETALLE","DATOS"]
[null,"SALARIO BASE",0,null,"SALARIO BASE",6000000,null,"SALARIO BASE",0]
[null,"FECHA DE INGRESO","2011-12-01",null,"FECHA DE INGRESO","2011-12-01",null,"FECHA INICIO DE CONTRATO",{"$f":"+F11","v":"2011-12-01"}]
[null,"FECHA DE RETIRO","2012-10-01",null,"FECHA DE RETIRO",{"$f":"+C12","v":"2012-10-01"},null,"FECHA FIN DE CONTRATO","2012-12-01"]
[null,"TIEMPO TRABAJADO",{"$f":"DAYS360(C11,C12)","v":300},null,"TIEMPO TRABAJADO",{"$f":"DAYS360(F11,F12)","v":300},null,"FECHA DE RETIRO","2012-10-31"]
[null,null,{"$f":"30+(C13-360)*20/360","v":26.666666666666668},null,"DIAS  A PAGAR",{"$f":"20+(F13-360)*15/360","v":17.5},null,"TIEMPO CONTRATADO",{"$f":"DAYS360(I11,I12)+1","v":361}]
[null,"DIAS  A PAGAR POR INDEMNIZACION",{"$f":"IF(C14>=30,C14,30)","v":30},null,"DIAS  A PAGAR POR INDEMNIZACION",{"$f":"IF(F14>=30,F14,30)","v":30},null,"DIAS  QUE FALTAN PARA EL CONTRATO",{"$f":"(I14)-(DAYS360(I11,I13))+1","v":32}]
[null,"VALOR DE LA INDEMNIZACIÓN",{"$f":"+C10/30*C15","v":0},null,"INDEMNIZACIÓN",{"$f":"+F10/30*F15","v":6000000},null,"INDEMNIZACIÓN",{"$f":"+I10/30*I15","v":0}]

{"sheet":"Hoja3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}