{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["PLANILLA","Hoja2","Hoja1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":3,"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":"PLANILLA","index":0,"n_rows":18,"n_cols":43,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,27,4,29]]}
["MES APORTACIÓN   :"]
["NAVE                         :",null,"M/N CS SATIRA",null,null,null,null,"NAVE(S)                    :",null,null,null,null,null,"NAVE(S)                    :",null,null,null,null,null,"NAVE(S)                    :"]
["FECHA DE INGRESO :",null,"2017-04-25","AL","2017-04-25",null,null,"FECHA DE INGRESO :",null,null,"AL",null,null,"FECHA DE INGRESO :",null,null,"AL",null,null,"FECHA DE INGRESO :",null,null,"AL"]
[]
[null,"NUMERO DE","APELLIDO","FECHA","FECHA","TURNO","DIAS","DIAS","NUMERO","NUMERO","REMUNERACION","BONIFICACION","CPTZ ","PORTA/WINCHERO","AMANECIDA","ASIGNACION","GRATIFICACIONES","REMUNERAION","DESCANSO ","BONIF","FERIADOS","CTS","MOVILIDAD","REMUN.","REMUN.",null,"O.N.P.","AFPS",null,null,"RETENCION","OTROS","TOTAL","REMUN.","ENTIDAD","ESSALUD","SCTR","SCTR","TOTAL","TOTAL","TOTAL","TOTAL"]
[null,"DOCUMENTO","PATERNO","INICIO","TERMINO","DIA","TRABAJ","SUBSIDIADO","HORAS","HORAS","DIARIA","ESPECIAL","70%/30%",0.45,"45%/28% /11.01%","FAMILIAR","LEGALES","VACACIONAL","SEMANAL","EXTRAORD",null,null,"ALIMENTACION","BRUTA","AFECTA",null,0.13,"APORTE OBLIGATORIO","COMISION","SEGURO","JUDICIAL","DESCUENTOS","DESCUENTOS","NETA","DE SERVICIO",0.09,"SALUD","PENSIONES","ESTIBA","MANIOBRA","TARJADOR","JUDICIAL","GRUPO"]
[null,null,null,null,null,null,null,null,"ORDINARIAS","SOBRETIEMPO",null,null,null,null,null,null,null,null,null,0.09,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01,1.38E-2,null,null,null,"TARJA Y CIA"]
[{"$f":"IFERROR(VLOOKUP(C8,[1]Hoja1!$V$2:$W$5000,2,FALSE),0)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH8-AM8-AN8-AO8","v":0},{"$f":"IFERROR(VLOOKUP(A8,[1]Hoja1!$B$2:$U$5000,18,FALSE),0)","v":0}]
[{"$f":"IFERROR(VLOOKUP(C9,[1]Hoja1!$V$2:$W$5000,2,FALSE),0)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AH9-AM9-AN9-AO9","v":0},{"$f":"IFERROR(VLOOKUP(A9,[1]Hoja1!$B$2:$U$5000,18,FALSE),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K8:K9)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,{"$f":"SUM(AL8:AL9)","v":0},{"$f":"SUM(AM8:AM9)","v":0},{"$f":"SUM(AN8:AN9)","v":0},{"$f":"SUM(AO8:AO9)","v":0},{"$f":"SUM(AP8:AP9)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REMUNERACION BRUTA",null,{"$f":"+X10","v":0},null,null,null,null,null,null,"SON:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ONP",null,{"$f":"+AA10","v":0},null,"ESTIBADORES",null,{"$f":"+AM10","v":0},null,null,{"$f":"[2]!num_letras(AH10,0)","v":" CON 00/100 SOLES "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AFP",null,{"$f":"SUM(AB10:AD10)","v":0},null,"MANIOBRA",null,{"$f":"+AN10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JUDICIAL",null,{"$f":"+AE10","v":0},null,"TRAJADORES",null,{"$f":"+AO10","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":"+Y13-Y14-Y15-Y16","v":0},null,"JUDICIAL",null,{"$f":"+AP10","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,null,null,null,null,{"$f":"+AC14+AC15+AC16+AC17","v":0}]

{"sheet":"Hoja2","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+F1","v":"ENERO DEL 2017"},"ENERO","DEL",2017,null,{"$f":"TRIM(CONCATENATE(B1,\" \",C1,\" \",D1))","v":"ENERO DEL 2017"}]
[{"$f":"+F2","v":"FEBRERO DEL 2017"},"FEBRERO","DEL",2017,null,{"$f":"TRIM(CONCATENATE(B2,\" \",C2,\" \",D2))","v":"FEBRERO DEL 2017"}]
["MARZO DEL 2017","MARZO","DEL",2017,null,"MARZO DEL 2017"]
["ABRIL DEL 2017","ABRIL","DEL",2017,null,"ABRIL DEL 2017"]
["MAYO DEL 2017","MAYO","DEL",2017,null,"MAYO DEL 2017"]
["JUNIO DEL 2017","JUNIO","DEL",2017,null,"JUNIO DEL 2017"]
["JULIO DEL 2017","JULIO","DEL",2017,null,"JULIO DEL 2017"]
["AGOSTO DEL 2017","AGOSTO","DEL",2017,null,"AGOSTO DEL 2017"]
["SETIEMBRE DEL 2017","SETIEMBRE","DEL",2017,null,"SETIEMBRE DEL 2017"]
["OCTUBRE DEL 2017","OCTUBRE","DEL",2017,null,"OCTUBRE DEL 2017"]
["NOVIEMBRE DEL 2017","NOVIEMBRE","DEL",2017,null,"NOVIEMBRE DEL 2017"]
["DICIEMBRE DEL 2017","DICIEMBRE","DEL",2017,null,"DICIEMBRE DEL 2017"]

{"sheet":"Hoja1","index":2,"n_rows":7,"n_cols":43,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,27,4,29]]}
[]
[]
[]
[]
[null,"NUMERO DE","APELLIDO","FECHA","FECHA","TURNO","DIAS","DIAS","NUMERO","NUMERO","REMUNERACION","BONIFICACION","CPTZ ","PORTA/WINCHERO","AMANECIDA","ASIGNACION","GRATIFICACIONES","REMUNERAION","DESCANSO ","BONIF","FERIADOS","CTS","MOVILIDAD","REMUN.","REMUN.",null,"O.N.P.","AFPS",null,null,"RETENCION","OTROS","TOTAL","REMUN.","ENTIDAD","ESSALUD","SCTR","SCTR","TOTAL","TOTAL","TOTAL","TOTAL"]
[null,"DOCUMENTO","PATERNO","INICIO","TERMINO","DIA","TRABAJ","SUBSIDIADO","HORAS","HORAS","DIARIA","ESPECIAL","70%/30%",0.45,"45%/28% /11.01%","FAMILIAR","LEGALES","VACACIONAL","SEMANAL","EXTRAORD",null,null,"ALIMENTACION","BRUTA","AFECTA",null,0.13,"APORTE OBLIGATORIO","COMISION","SEGURO","JUDICIAL","DESCUENTOS","DESCUENTOS","NETA","DE SERVICIO",0.09,"SALUD","PENSIONES","ESTIBA","MANIOBRA","TARJADOR","JUDICIAL","GRUPO"]
[null,null,null,null,null,null,null,null,"ORDINARIAS","SOBRETIEMPO",null,null,null,null,null,null,null,null,null,0.09,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01,1.38E-2,null,null,null,"TARJA Y CIA"]