{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["FORMATO DE PLANILLA","FERIADOS","RET. JUD.","OBLIGACIONES LABORALES","...","INF"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":12,"defined_names":103,"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":"FORMATO DE PLANILLA","index":0,"n_rows":50,"n_cols":145,"rows_kept":50,"cut":false,"hidden":false,"merged":[[24,2,24,4],[21,2,21,4],[8,104,8,107],[2,0,2,1],[2,104,2,105],[2,103,3,103],[2,107,3,107],[2,106,3,106],[3,0,3,1],[18,2,18,4],[16,2,16,4],[17,2,17,4],[20,2,20,4],[4,0,4,1],[5,0,5,1],[22,2,22,4],[25,2,25,4],[19,2,19,4],[32,2,32,4],[1,111,1,113],[5,112,8,113],[2,108,3,108],[14,2,14,4],[15,2,15,4],[1,110,2,110],[23,2,23,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[26,2,26,4],[31,2,31,4],[13,139,13,144],[13,50,13,59],[13,103,13,108],[13,116,13,122],[13,85,13,88],[13,112,13,114],[13,70,13,71],[13,81,13,84],[13,62,13,65],[13,96,13,99],[13,130,13,137],[37,2,37,4],[49,2,49,4],[50,2,50,4],[38,2,38,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[45,2,45,4],[46,2,46,4],[39,2,39,4],[40,2,40,4],[47,2,47,4],[48,2,48,4],[44,2,44,4]]}
[]
[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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DETALLE","TASA"]
["CONTRATA: ",null,"MINSUR",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,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,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,null,null,null,null,null,null,null,"AFP","COMISION",null,"SEGURO","OBLIGATORIO","LEY 27252",null,null,"ADMINISTRATIVO","SUPERFICIE","SOCAVON"]
["RUC :",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,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,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,null,null,null,null,null,null,null,null,null,null,"FLUJO","MIXTA",null,null,null,null,"SCTR PENSION",null,0.1517,1.2E-2]
["Periodo del :",null,"2020-07-01","al","2020-07-31",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,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,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,null,null,null,null,null,"HABITAT",1.47E-2,3.8E-3,1.35E-2,0.1,0.02,null,"SCTR SALUD",null,6.3E-3,1.2999999999999999E-2]
["Unidad :",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,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,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,null,null,null,null,null,null,null,null,null,"INTEGRA",1.55E-2,0,1.35E-2,0.1,0.02,null,"VIDA LEY",3.5000000000000001E-3]
[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,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,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,null,null,null,null,null,null,null,null,null,null,"PRIMA",1.6E-2,1.8E-3,1.35E-2,0.1,0.02,null,"FJMMS",5.0000000000000001E-3]
[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,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,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,null,null,null,null,null,null,null,null,null,null,"PROFUTURO",1.6899999999999998E-2,6.7000000000000002E-3,1.35E-2,0.1,0.02,null,"SENATI",7.4999999999999997E-3]
[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,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,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,null,null,null,null,null,null,null,null,null,null,"ONP",null,null,null,null,0.13,null,"R.M.V.",930]
[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,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,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,null,null,null,null,null,null,null,null,null,null,"REM. ASEG. MAX.",9636]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+T15","v":"2020-07-01"},{"$f":"+U15","v":"2020-07-02"},"2020-07-03","2020-07-04","2020-07-05","2020-07-06","2020-07-07","2020-07-08","2020-07-09","2020-07-10","2020-07-11","2020-07-12","2020-07-13","2020-07-14","2020-07-15","2020-07-16","2020-07-17","2020-07-18","2020-07-19","2020-07-20","2020-07-21","2020-07-22","2020-07-23","2020-07-24","2020-07-25","2020-07-26","2020-07-27","2020-07-28","2020-07-29","2020-07-30","1900-01-31","OCURRENCIAS",null,null,null,null,null,null,null,null,null,null,8," HORAS SOBRETIEMPO",null,null,null,"NUEVO",null,null,null,"DIAS",null,null,null,null,null,null,null,null,null,null,"HORAS EXTRAS",null,null,null,"LIQ DE BBSS.",null,null,null,null,null,null,null,null,null,null,"BENEFICIOS SOCIALES",null,null,null,null,null,null,"AFP",null,null,null,null,null,null,null,null,"RETENCION JUDICIAL",null,null,null,"ADELANTOS",null,null,null,null,null,null,null,null,null,null,null,null,null,"APORTES",null,null,null,null,null,null,null,null,"BASE IMPONIBLE"]
["Nº","DNI","APELLIDOS Y NOMBRES",null,null,"FECHA NACIMIENTO","CARGO","CENTRO COSTOS","AREA DE  TRABAJO","FECHA DE INGRESO","FECHA DE CESE","BCO.","CUENTA HABERES","AFP NRO","FECHA AFILIACION SPP","SISTEMA DE PENSION","TIPO DE COMISION","JORNADA LABORAL","EPS",{"$f":"+C5","v":"2020-07-01"},{"$f":"+T15+1","v":"2020-07-02"},{"$f":"+U15+1","v":"2020-07-03"},"2020-07-04","2020-07-05","2020-07-06","2020-07-07","2020-07-08","2020-07-09","2020-07-10","2020-07-11","2020-07-12","2020-07-13","2020-07-14","2020-07-15","2020-07-16","2020-07-17","2020-07-18","2020-07-19","2020-07-20","2020-07-21","2020-07-22","2020-07-23","2020-07-24","2020-07-25","2020-07-26","2020-07-27","2020-07-28",{"$f":"+AU15+1","v":"2020-07-29"},{"$f":"+AV15+1","v":"2020-07-30"},"1900-01-31","DIA FALTA","LIC. SIN GOCE","DIA SUSPENSIÓN","DESC. MEDICO","DIA SUBSIDIO","LIC. PATERNAL","LIC. CON GOCE","VAC","DIA ATIPICO/DESC. OBL.","DIA ORDINARIO","TOTAL DIAS MES","HORAS TRABAJADAS",0.25,0.35,1,"FERIADO","PERMISOS POR HORAS","COMPENSACION VACACIONAL","BASICO MENSUAL","ASIG. FAMILIAR","ORDINARIOS","ATIPICOS","ASIGNACION FAMILIAR","LICENCIA POR PATERNIDAD","LICENCIA CON GOCE DE HABER","VACACIONES","COMPENS. VACACIONAL","DESCANSO MEDICO","SUBSIDIO POR INCAPACIDAD","REINTEGROS AFECTO","BONO","FERIADO",0.25,0.35,1,"VACACIONES TRUNCAS","GRATIFICACION  TRUNCA","BONIFICACION LEY 29351 PROPORC.","C.T.S. TRUNCA","DEV. RENTA DE QUINTA","REINTEGRO INAFECTO","CONDICIONES DE TRABAJO ","MOVILIDAD SUPEDITADA A LA ASISTENCIA","AGUINALDO CANASTA NAVIDEÑA","BONO CIERRE DE PLIEGO","ESCOLARIDAD ","UTILIDAD","GRATIFICACION ORDINARIA","BON. EXTR. 9% O 6.75%","CTS","TOTAL INGRESOS","TOTAL ING AFECTOS","S.N.P.","APORTE OBLIGATORIO","AFP 2% LEY 27252","SEGURO AFP","COM SOBRE FLUJO REM","COM SOBRE MIXTA","TOTAL AFP","DSCTO. FJCMMS 0.5%","ESSALUD VIDA","5TA. CATEG","%","RET. PORCENTUAL","RET. FIJO","PRESTAMO","DE LIQUIDACION"," DE GRATIFICACIONES"," DE CTS"," DE VACACIONES","UTILIDAD"," DE MOVILIDAD","DE SUELDO","DSCTO PROTECCION FAMILIAR","DSCTO CONCESIONARIO","DSCTO PERM. HORAS","OTROS DESCUENTOS","DSCTO EPS","TOTAL DESCUENTO","NETO A PAGAR","ESSALUD","EPS","AFP LEY 27252","SCTR                SALUD","SCTR PENSION","3% D° EMISION","VIDA LEY","SENATI","Total Aportes Empleador","ESSALUD","S.N.P./SENATI","AFP","SCTR              SALUD","SCTR PENSION","VIDA LEY"]
[1,"75990857","AMARO SUEL BETHLES JONATAN",null,null,"1998-05-03","MECANICO ESPECIALISTA","OPERACIÓN MINA","SU","2019-03-18",null,"CONTINENTAL","0011-0057-75-0236793932","659161BASRL5","2015-12-24","INTEGRA","CM","ATIPICO","N","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","TD","L","L","L","L","L","L","F","F",{"$f":"+IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AX16,\"F\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"F\"),COUNTIF(T16:AW16,\"F\")))","v":2},{"$f":"+IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"LSG\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"LSG\"),COUNTIF(T16:AW16,\"LSG\")))","v":0},{"$f":"+IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"S\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"S\"),COUNTIF(T16:AW16,\"S\")))","v":0},{"$f":"IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"DM\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"DM\"),COUNTIF(T16:AW16,\"DM\")))","v":0},{"$f":"IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"SB\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"SB\"),COUNTIF(T16:AW16,\"SB\")))","v":0},{"$f":"IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"LP\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"LP\"),COUNTIF(T16:AW16,\"LP\")))","v":0},{"$f":"IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"LCG\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"LCG\"),COUNTIF(T16:AW16,\"LCG\")))","v":0},{"$f":"IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"V\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"V\"),COUNTIF(T16:AW16,\"V\")))","v":0},{"$f":"+IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"L\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"L\"),COUNTIF(T16:AW16,\"L\")))","v":6},{"$f":"+IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"TD\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"TD\"),COUNTIF(T16:AW16,\"TD\")))+IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"TN\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"TN\"),COUNTIF(T16:AW16,\"TN\")))","v":23},{"$f":"+SUM(AY16:BH16)","v":31},{"$f":"+BH16*$BJ$14","v":184},null,null,null,null,null,null,930,0,{"$f":"ROUND(IF((BQ16/30)*(BH16)<0,0,(BQ16/30)*(BH16)),2)","v":713},{"$f":"+ROUND((BQ16/30)*BG16,2)","v":186},{"$f":"+IF(AND(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),(AY16+AZ16+BA16+BC16+BF16)=31),0,IF(AND(MONTH($C$5)=2,(AY16+AZ16+BA16+BC16+BF16)=28),0,IF(AND(OR(MONTH($C$5)=4,MONTH($C$5)=6,MONTH($C$5)=9,MONTH($C$5)=11),(AY16+AZ16+BA16+BC16+BF16)=30),0,BR16)))","v":0},{"$f":"ROUND((BQ16/30)*BD16,2)","v":0},{"$f":"ROUND((BQ16/30)*BE16,2)","v":0},null,null,{"$f":"(BQ16/30)*BB16","v":0},null,null,null,{"$f":"+ROUND(((((BQ16+BR16)/30)/$BJ$14)*2)*BN16,2)","v":0},{"$f":"+ROUND((((BQ16+BR16)/30)/$BJ$14)*125%,2)*BK16","v":0},{"$f":"+ROUND((((BQ16+BR16)/30)/$BJ$14)*135%,2)*BL16","v":0},{"$f":"+ROUND(((((BQ16+BR16)/30)/$BJ$14)*2)*BM16,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+ROUND(IF(S16=\"N\",CT16*9%,CT16*6.75%),2)","v":0},null,{"$f":"ROUND(SUM(BS16:CV16),2)","v":899},{"$f":"ROUND(SUM(BS16:CH16)-DV16,2)","v":899},{"$f":"ROUND(IF(P16=\"ONP\",(CX16-CA16)*$DE$9,0),2)","v":0},{"$f":"ROUND(IF(P16=\"ONP\",0,(VLOOKUP(P16,$CZ$5:$DE$8,5,0))*CX16),2)","v":89.9},{"$f":"ROUND(IF(I16=\"SO\",IF(P16=\"ONP\",0,VLOOKUP(P16,$CZ$5:$DE$8,6,0)*CX16),0),2)","v":0},{"$f":"+IF(P16=\"ONP\",0,IF(DATEDIF(F16,$E$5,\"Y\")>=65,0,IF(EL16>=$DA$10,$DA$10*VLOOKUP(P16,$CZ$5:$DE$8,4),VLOOKUP(P16,$CZ$5:$DE$8,4)*EL16)))","v":12.1365},{"$f":"ROUND(IF(Q16=\"CF\",IF(P16=\"ONP\",0,VLOOKUP(P16,$CZ$5:$DE$8,2,0)*CX16),0),2)","v":0},{"$f":"IF(Q16=\"CM\",(ROUND(IF(P16=\"ONP\",0,VLOOKUP(P16,$CZ$5:$DE$8,3,0)*CX16),2)),0)","v":0},{"$f":"SUM(CZ16:DD16)","v":102.0365},{"$f":"ROUND(IF(I16=\"SO\",(ROUND(((CX16-CA16)*$DH$7),2)),0),2)","v":0},null,null,{"$f":"+SUMIF('RET. JUD.'!A:A,'FORMATO DE PLANILLA'!$B16,'RET. JUD.'!C:C)","v":0},{"$f":"DI16*(SUM(BS16:CM16,CO16:CV16)-CY16-DE16-DF16-DG16-DH16)","v":0},{"$f":"+SUMIF('RET. JUD.'!$A:$A,'FORMATO DE PLANILLA'!$B16,'RET. JUD.'!$D:$D)","v":0},null,null,null,null,null,null,{"$f":"+CO16","v":0},656.92,null,null,{"$f":"+(((BQ16+BR16)/30)/$BJ$14)*BO16","v":0},null,null,{"$f":"SUM(CY16:DX16)-DE16","v":758.95649999999989},{"$f":"+CW16-DY16","v":140.04350000000011},{"$f":"+ROUND(IF(S16=\"S\",EJ16*6.75%,EJ16*9%),2)","v":83.7},{"$f":"+ROUND(IF(S16=\"S\",EJ16*2.25%,0),2)","v":0},{"$f":"DA16","v":0},{"$f":"ROUND(IF($I16=\"SU\",EM16*$DI$5,EM16*$DJ$5),2)","v":5.66},{"$f":"ROUND(IF(I16=\"SU\",EN16*$DI$4,EN16*DJ4),2)","v":136.38},{"$f":"+EE16*3%","v":4.0914000000000001},{"$f":"+ROUND(EO16*$DH$6,2)","v":3.26},{"$f":"+EK16*$DH$8","v":6.7424999999999997},{"$f":"SUM(EA16:EG16)","v":233.09139999999999},{"$f":"+IF(AND((CX16-CA16)<930,IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"DM\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"DM\"),COUNTIF(T16:AW16,\"DM\")))>=1,IF(OR(MONTH($C$5)=1,MONTH($C$5)=3,MONTH($C$5)=5,MONTH($C$5)=7,MONTH($C$5)=8,MONTH($C$5)=10,MONTH($C$5)=12),COUNTIF(T16:AW16,\"SB\"),IF(MONTH($C$5)=2,COUNTIF(T16:AU16,\"SB\"),COUNTIF(T16:AW16,\"SB\")))>=1),(CX16-CA16),IF((CX16-CA16)<930,930,(CX16-CA16)))","v":930},{"$f":"+(CX16-CA16)","v":899},{"$f":"+ROUND(SUM(BS16:CH16),2)","v":899},{"$f":"+ROUND((CX16+CT16+CU16-CA16),2)","v":899},{"$f":"+IF((CX16+CT16+CU16)>=$DA$10,$DA$10,(CX16+CT16+CU16))","v":899},{"$f":"+IF((BR16+BQ16)>=$DA$10,$DA$10,(BR16+BQ16))","v":930}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIGLAS",null,"L"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIMA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INTEGRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HABITAT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ONP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROFUTURO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIMA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INTEGRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INTEGRA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HABITAT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIMA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ONP"]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AY16:AY33)","v":2},0,0,0,0,0,0,0,6,23,31,184,0,0,0,0,0,0,930,0,713,186,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(CE16:CE33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,899,899,0,89.9,0,12.1365,0,0,102.0365,0,0,0,0,0,{"$f":"SUM(DK16:DK33)","v":0},0,0,0,0,0,0,0,656.92,0,0,0,0,0,758.95649999999989,140.04350000000011,83.7,0,0,5.66,136.38,4.0914000000000001,3.26,6.7424999999999997,233.09139999999999,930,899,899,899,899,930]
[]
[null,"Leyenda:"]
[null,"SIGLAS","DESCRIPCION"]
[null,"DM","DESCANSO MEDICO"]
[null,"F","DIA FALTA"]
[null,"S","DIA SUSPENSIÓN"]
[null,"L","LIBRE"]
[null,"LCG","LICENCIA CON GOCE"]
[null,"LP","LICENCIA PATERNAL"]
[null,"V","VACACIONES"]
[null,"LSG","LICENCIA SIN GOCE/PERMISO"]
[null,"R","RETIRADO"]
[null,"SB","SUBSIDIO"]
[null,"TD","TURNO DIA"]
[null,"TN","TURNO NOCHE"]

{"sheet":"FERIADOS","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["FECHA","FERIADO","OBSERVACION"]
["2019-01-01","Año Nuevo"]
["2019-04-18","Jueves Santo","MODIFICAR"]
["2019-04-19","Viernes Santo","MODIFICAR"]
["2019-06-29","San Pedro y San Pablo"]
["2019-07-28","Independencia del Perú"]
["2019-07-29","Día de las Fuerzas Armadas"]
["2019-08-30","Santa Rosa de Lima"]
["2019-10-08","Combate Naval de Angamos"]
["2019-11-01","Día de Todos los Santos"]
["2019-12-08","Día de la Inmaculada Concepción"]
["2019-12-25","Navidad"]
["2019-05-01","DIA DEL TRABAJADOR"]

{"sheet":"RET. JUD.","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["DNI","APELLIDOS Y NOMBRES","TASA","FIJO"]
["12345678",null,0.1,100]
["12345678",null,0.1,100]
["12345678",null,0.1,100]
["12345678",null,0.1,100]

{"sheet":"OBLIGACIONES LABORALES","index":3,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,3,3,9]]}
[]
[]
[]
[null,null,null,"Registro de Reporte Obligacion Laboral"]
[]
[null,null,"*","fecha actual",null,{"$f":"TODAY()","v":"2022-03-11"}]
[null,null,"*","Unidad",null,"Raura"]
[null,null,"*","Contrata",null,"Compania Minera Tumi"]
[]
[]
[]
[null,null,"*","Aportaciones"]
[null,null,null,"y/o Tributo ",null,"Onp/Essalud","*","N Trabajadores",null,19]
[]
[null,null,null,"* Banco",null,"Banco de la Nacion"]
[]
[null,null," Monto"," Aportaciones"]
[null,null,null,"y/o Tributo",null,3325,"*","Fecha pago",null,"2020-07-24"]
[]
[null,null,"*","Monto Pago",null,3325,"*","Periodo",null,"Junio"]
[]
[null,null,"*","Justificar"]

{"sheet":"...","index":4,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"fecha","Unidad","Contrata","Aportaciones","Banco","N\nTrabajadores","Monto\nAportacion","Monto\nPago","Fecha\npago","Periodo","Justificar"]

{"sheet":"INF","index":5,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,5,1,8]]}
[]
[null,null,null,null,null,"COTNRATISTA"]
[null,"Aportacion",null,"UNIDAD",null,"San.Rafael","Raura","Pucamarca","Fundicion.Pisco",null,"mes",null,"año"]
[null,"Seleccionar",null,"San.Rafael",null,"Confipetrol sa","Aesa","Exsa","El Canario",null,"Enero",null,2019]
[null,"Essalud",null,"Raura",null,"Ur Topografia","ByB Eisemn","Pegaus","Electrotecnia",null,"Febrero",null,2020]
[null,"Essalud Vida",null,"Pucamarca",null,"Cmmei Del Peru S.A.","Compania Minera Tumi","Sodexo","Famecsa",null,"Marzo"]
[null,"Onp",null,"Fundicion.Pisco",null,"Corporacion Ramis Srl","Transportes Linea SA","EMC2 Consulting","Pemsur",null,"Abril"]
[null,"Renta De 5ta Categoria",null,null,null,"Ligabue","Constructora Meneses","Frad sa","Estivadores",null,"Mayo"]
[null,"Sctr Pension",null,null,null,"Explomin Peru sac","Cjnetcom","Ferreyros sac","Ligabue Sa",null,"Junio"]
[null,"Sctr Salud",null,"BANCO",null,"Comin sa","Corporacion Panaservice SAC","Neuma Peru","Beatita De Humay",null,"Julio"]
[null,"FCJMMS 0.5%",null,"Seleccionar",null,"Epcm Experts sac","ECOSERMUQ ",null,null,null,"Agosto"]
[null,"AFP Prima",null,"Banco de la Nacion",null,"Tumi Contratista Minero sac","Clínica Internacional",null,null,null,"Septiembre"]
[null,"AFP Integra",null,"Banco Continental",null,"S&R Contratistas","JV RESGUARDO ",null,null,null,"Octubre"]
[null,"AFP Profuturo",null,"Banco de Credito",null,null,"Kanay S.A.C.",null,null,null,"Noviembre"]
[null,"AFP Habitat",null,"Scotiabank",null,null,"Vijicsa",null,null,null,"Diciembre"]
[null,"Senati",null,null,null,null,"Overall"]
[null,"Onp/Essalud"]
[null,"Onp/Essalud/5ta"]
[null,"Sctr Pension/Salud"]
[null,"Onp/Essalud/5ta/Essalud vida"]
[null,"AFP Prima/Integra/Profoturo/Habitat"]
[null,"Vida Ley"]
[null,"N/A"]