{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Nómina","Horas extras y demás"],"not_rendered":{"charts":0,"images":1,"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":"Nómina","index":0,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,2,37,5],[37,6,37,7],[38,2,38,5],[38,6,38,7],[32,9,32,11],[24,1,25,1],[27,2,27,7],[29,2,29,7],[36,2,36,5],[36,6,36,7],[5,10,5,14],[5,1,6,1],[39,2,39,5],[39,6,39,7],[31,2,34,7],[35,9,35,11],[36,9,36,11],[39,9,39,11],[29,9,29,11],[30,9,30,11],[31,9,31,11],[33,9,33,11],[32,1,35,1],[38,9,38,11],[24,3,25,12],[27,9,28,12],[22,1,22,3],[4,10,4,14],[0,14,0,16],[1,14,1,16],[2,14,2,16],[3,14,3,16],[5,15,6,15],[5,16,6,16],[0,1,3,5],[1,6,1,8],[2,6,2,8],[0,6,0,9],[3,6,3,8],[0,10,3,13],[4,2,4,9],[5,2,5,9]]}
[null,null,null,null,null,null,"Diligencie los siguientes valores de referencia:",null,null,null,null,null,null,null,"Periodo de pago"]
[null,null,null,null,null,null,"Salario mínimo",null,null,908526,null,null,null,null,"Septiembre 01 2021 - Septiembre 30 2021"]
[null,null,null,null,null,null,"Auxilio de transporte",null,null,106454,null,null,null,null,"Fecha de liquidación"]
[null,null,null,null,null,null,"¿Está exonerado del pago de aportes?",null,null,"Si",null,null,null,null,"2021-09-30"]
[]
[null,"Nombre del\nempleado","Devengado",null,null,null,null,null,null,null,"Deducciones",null,null,null,null,"Neto\n pagado","Firma del \n empleado"]
[null,null,"Salario \nbásico","Días \nliquidados","Salario \ndevengado","Horas \nextras","Recargos \nnocturnos","Trabajo dominical \ny festivo","Auxilio de\ntransporte","Total\ndevengado","Salud","Pensión","Fondo de solidaridad\npensional","Retención en \nla fuente","Otras\n deducciones"]
[null,"Pedro",1200000,30,{"$f":"(C8/30)*D8","v":1200000},150000,85000,170000,{"$f":"IF(C8>$J$2*2,0,($J$3/30*D8))","v":106454},{"$f":"SUM(E8:I8)","v":1711454},{"$f":"(J8-I8)*0.04","v":64200},{"$f":"(J8-I8)*0.04","v":64200},{"$f":"(J8-I8)*(IF(AND(((J8-I8)/$J$2)>=4,((J8-I8)/$J$2)<16),1,IF(AND(((J8-I8)/$J$2)>=16,((J8-I8)/$J$2)<=17),1.2,IF(AND(((J8-I8)/$J$2)>17,((J8-I8)/$J$2)<=18),1.4,IF(AND(((J8-I8)/$J$2)>18,((J8-I8)/$J$2)<=19),1.6,IF(AND(((J8-I8)/$J$2)>19,((J8-I8)/$J$2)<=20),1.8,IF(((J8-I8)/$J$2)>20,2,0))))))/100)","v":0},0,0,{"$f":"J8-K8-L8-M8-N8-O8","v":1583054}]
[null,"María",6000000,30,{"$f":"(C9/30)*D9","v":6000000},180000,null,null,0,{"$f":"SUM(E9:I9)","v":6180000},{"$f":"(J9-I9)*0.04","v":247200},{"$f":"(J9-I9)*0.04","v":247200},61800,null,null,{"$f":"J9-K9-L9-M9-N9-O9","v":5623800}]
[null,"Oscar",10000000,30,7000000,0,null,null,0,7000000,280000,280000,70000,null,null,6370000]
[null,"Angela",1400000,30,1400000,120000,null,null,106454,1626454,60800,60800,0,null,null,1504854]
[null,"Arturo",1280000,30,1280000,0,null,null,106454,1386454,51200,51200,0,null,null,1284054]
[null,"Angie",1600000,15,800000,0,null,null,53227,853227,32000,32000,0,null,null,789227]
[null,"Camila",900000,30,900000,0,null,null,106454,1006454,36000,36000,0,null,null,934454]
[null,"Alejandra",900000,30,900000,0,null,null,106454,1006454,36000,36000,0,null,null,934454]
[null,"Cleopatra",900000,30,900000,130000,null,null,106454,1136454,41200,41200,0,null,null,1054054]
[null,"Juana de Arco",900000,20,600000,0,null,null,70969.333333333328,670969.33333333337,24000,24000,0,null,null,622969.33333333337]
[null,"Magda",10000000,30,8000000,0,null,null,0,8000000,320000,320000,80000,null,null,7280000]
[null,"Inés",1000000,30,1000000.0000000001,210000,null,null,106454,1316454,48400,48400,0,null,null,1219654]
[null,"Clara",1000000,30,1000000.0000000001,0,null,null,106454,1106454,40000,40000,0,null,null,1026454]
[null,"César",1000000,30,1000000.0000000001,0,null,null,106454,1106454,40000,40000,0,null,null,1026454]
[null,"Susana",1000000,10,333333.33333333337,60000,null,null,35484.666666666664,428818.00000000006,15733.333333333336,15733.333333333336,0,null,null,397351.33333333343]
[null,"Totales",null,null,{"$f":"SUM(E8:E22)","v":32313333.333333332},{"$f":"SUM(F8:F22)","v":850000},85000,170000,1117767.0000000002,34536100.333333328,1336733.3333333333,1336733.3333333333,211800,0,0,{"$f":"SUM(P8:P22)","v":31650833.666666664}]
[]
[null,{"$f":"ROUND(P23,0)","v":31650834},null,{"$f":"LETRAS(B25)","v":"Treinta y Un Millones Seiscientos Cincuenta Mil Ochocientos Treinta y Cuatro Pesos"}]
[]
[]
[null,"Comprobante de Pago Nº:",null,null,null,null,null,null,null,"Provisiones de nómina a \ncargo del empleador."]
[]
[null,"Fecha de",{"$f":"O4","v":"2021-09-30"},null,null,null,null,null,null,"Aportes a pensión",null,null,{"$f":"(J23-I23)*0.12","v":4010199.9999999991}]
[null,null,null,null,null,null,null,null,null,"Aportes a salud",null,null,{"$f":"IF(J4=\"Si\",(SUMIF(J8:J22,\">\"&J2*10,J8:J22))*0.085,(J23-I23)*0.085)","v":0}]
[null,"Observaciones",null,null,null,null,null,null,null,"Aportes a riesgos laborales",null,null,{"$f":"(J23-I23)*0.00522","v":174443.69999999995}]
[null,null,null,null,null,null,null,null,null,"Sena",null,null,{"$f":"IF(J4=\"Si\",(SUMIF(J8:J22,\">\"&J2*10,J8:J22))*0.02,(J23-I23)*0.02)","v":0}]
[null,null,null,null,null,null,null,null,null,"Icbf",null,null,{"$f":"IF(J4=\"Si\",(SUMIF(J8:J22,\">\"&J2*10,J8:J22))*0.03,(J23-I23)*0.03)","v":0}]
[null,null,null,null,null,null,null,null,null,"Cajas de compensación",null,null,{"$f":"(J23-I23)*0.04","v":1336733.3333333333}]
[null,null,null,null,null,null,null,null,null,"Prima de servicios",null,null,{"$f":"J23*0.0833","v":2876857.1577666663}]
[null,"Elaborador Por:","Revisado Por:",null,null,null,"Aprobado Por:",null,null,"Cesantía",null,null,{"$f":"J23*0.0833","v":2876857.1577666663}]
[null,null,null,null,null,null,null,null,null,"Intereses sobre cesantías",null,null,{"$f":"M37*0.12","v":345222.85893199994}]
[null,null,null,null,null,null,null,null,null,"Provisón de vacaciones",null,null,{"$f":"(J23-F23-H23-I23)*0.0417","v":1351010.4999999998}]
[null,null,null,null,null,null,null,null,null,"Total provisiones",null,null,{"$f":"SUM(M30:M39)","v":12971324.707798664}]

{"sheet":"Horas extras y demás","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,1,11,6],[0,1,0,8],[1,7,1,8],[1,3,1,4]]}
[null,"Horas extrsa, recargos nocturnos, dominicales y festivos"]
[null,"Seleccione el trabajador a liquidar:","Cleopatra","Sueldo de ",null,null,{"$f":"C2","v":"Cleopatra"},{"$f":"VLOOKUP(G2,Nómina!B8:C22,2,0)","v":900000}]
[null,"Concepto","Porcentaje de recargo","Factor","Valor hora ordinaria","Valor del recargo","Valor de la hora con el recargo","Ingrese las horas trabajadas","Valor total"]
[null,"Recargo Nocturno",0.35,1.35,{"$f":"$H$2/240","v":3750},{"$f":"E4*C4","v":1312.5},{"$f":"E4+F4","v":5062.5},2,{"$f":"G4*H4","v":10125}]
[null,"Hora extra diurna",0.25,1.25,{"$f":"$H$2/240","v":3750},{"$f":"E5*C5","v":937.5},{"$f":"E5+F5","v":4687.5},5,{"$f":"G5*H5","v":23437.5}]
[null,"Hora extra nocturna",0.75,1.75,3750,2812.5,6562.5,2,13125]
[null,"Hora Ordinaria dominical o festivo",0.75,1.75,3750,2812.5,6562.5,1,6562.5]
[null,"Hora extra diurna dominical o festivo",1,2,3750,3750,7500,3,22500]
[null,"Hora extra nocturna dominical o festivo",1.5,2.5,3750,5625,9375,4,37500]
[null,"Descargue aquí el liquidador de horas extras",null,null,null,null,null,"Subtotal trabajo extra",{"$f":"I5+I6","v":36562.5}]
[null,null,null,null,null,null,null,"Subtotal recargo nocturno",{"$f":"I4","v":10125}]
[null,null,null,null,null,null,null,"Subtotal trabajo dominical y festivo",{"$f":"I7+I8+I9","v":66562.5}]