{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["MAYO","HUACHO","HUARAZ"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"MAYO","index":0,"n_rows":29,"n_cols":32,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,31],[3,0,5,0],[3,1,5,1],[3,2,5,2],[3,3,5,3],[3,17,5,17],[4,23,5,23],[3,16,5,16],[1,4,1,27],[3,26,5,26],[4,20,4,22],[3,14,5,14],[3,12,5,12],[3,18,5,18],[3,19,3,24],[3,30,5,30],[4,24,5,24],[3,6,4,8],[3,27,5,27],[3,28,5,28],[3,29,5,29],[2,0,2,1],[18,1,18,5],[16,0,16,9],[3,15,5,15],[3,4,5,4],[3,5,5,5],[3,9,5,9],[3,10,5,10],[3,11,5,11],[3,13,5,13]]}
["AUTOMOTORES YOSHIVAL S.A.C."]
[" ","RUC: 20408104638",null,null,"PLANILLA DE MES DE MAYO DEL 2018"]
["BUSCADOR DE SEDE"]
["Nº","APELLIDOS Y NOMBRE  ","DNI","SEDE","FACHA DE INGRESOS","FECHA \nDE NACIM. ","INCORPORACION AL SISTEMA PRIVADO DE PENSIONES - AFP",null,null,"CARGO ","HORAS EXTRAS","FERIADOS","COMISION","REMUNERACION  MENSUAL","ASIG.  FAMILIAR","COMISIONES","FALTAS ","DESCUENTOS POR TARDANZAS Y OTROS","REMUNERACION  TOTAL","DESCUESTOS DE LEY ",null,null,null,null,null,"APORTE DEL EMPLEADOR","CTS","BASICO","ADICIONAL","NETO A PAGAR","NUMERO DE CUENTA DE TRABAJADOR","FIRMA DE RECEPCION  \n(RECIBI CONFORME)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S.N.P.","SISTEMA PRIVADO DE PENSIONES - AFP",null,null,"Renta 5° Categ.","TOTAL DESCUENTOS DE LEY","ESSALUD "]
[null,null,null,null,null,null,"FECHA","TIPO D´AFP","CUSPP",null,null,null,null,null,null,null,null,null,null,0.13,"APOR. OBLIG.","COMISION","PRIMA DE SEG.",null,null,0.09]
["01","CARLOS ENRIQUE CHIGNE SALDIVAR",18113541,"HUARAZ","2008-02-04","1969-11-05",null,"PRIMA","255101CCSGD7","GERENTE GENERAL",null,null,null,930,93,null,{"$f":"HUARAZ!B36","v":217},null,{"$f":"+N7+O7-R7+P7-Q7","v":806},null,{"$f":"S7*10%","v":80.600000000000009},1.84,{"$f":"S7*1.36%","v":10.961600000000001},null,{"$f":"SUM(T7:X7)","v":93.401600000000016},{"$f":"+S7*9%","v":72.539999999999992},{"$f":"+S7*8.33/100","v":67.139800000000008},{"$f":"+S7-Y7","v":712.59839999999997},1150,{"$f":"AB7+AC7","v":1862.5983999999999},"375-90387954-0-19"]
["02","MELODY JENNY MAMANI MEDNA",44990512,"HUARAZ","2012-02-01","1988-02-03",null,"ONP",null,"SECRETARIA",null,null,null,930,93,null,{"$f":"HUARAZ!C36","v":155},null,{"$f":"+N8+O8-R8+P8-Q8+M8+K8+L8","v":868},{"$f":"+S8*13%","v":112.84},null,null,null,null,{"$f":"SUM(T8:X8)","v":112.84},{"$f":"+S8*9%","v":78.11999999999999},{"$f":"+S8*8.33/100","v":72.304400000000001},{"$f":"+S8-Y8","v":755.16},650,{"$f":"AB8+AC8","v":1405.1599999999999},"375-90388079-0-45"]
["03","YULI  CECILIA PRUDENCIO HUANUCO",46571513,"HUARAZ","2016-04-01","1990-10-01",null,"ONP",null,"SECRETARIA",null,null,null,930,0,null,{"$f":"HUARAZ!D36","v":248},null,682,{"$f":"+S9*13%","v":88.66},null,null,null,null,88.66,61.379999999999995,56.810600000000001,593.34,450,1043.3400000000001,"375-90388101-0-68"]
["04","RUSSEL ACUÑA VEGA","74498493","HUARAZ","2018-03-01","1997-02-23",null,"ONP",null,"MECANICO",null,null,null,930,0,null,{"$f":"HUARAZ!E36","v":155},null,775,{"$f":"+S10*13%","v":100.75},null,null,null,null,100.75,69.75,64.557500000000005,674.25,200,874.25,"375-90389230-0-08"]
["05","DIEGO TEODORO CERRUDO VALVERDE",70115551,"HUARAZ","2018-05-01","1994-03-24",null,"ONP",null,"MECANICO",null,null,null,930,0,null,{"$f":"HUARAZ!F36","v":248},null,682,{"$f":"+S11*13%","v":88.66},null,null,null,null,88.66,61.379999999999995,56.810600000000001,593.34,370,{"$f":"AB11+AC11","v":963.34},"375-90641497-0-23"]
["06","MERCEDES ELIZABETH JAMANCA BARRENECHEA",40334338,"HUARAZ","2018-05-01","1979-11-04",null,"ONP",null,"PERSONAL DE LIMPIEZA",null,null,null,930,93,null,{"$f":"HUARAZ!G36","v":155},null,868,{"$f":"+S12*13%","v":112.84},null,null,null,null,112.84,78.11999999999999,72.304400000000001,755.16,440,1195.1599999999999,"375-90388337-0-06"]
["07","JOSE JHONATAN VENTURA ACEVEDO","43744245","HUARAZ","2018-03-01","1986-02-16",null,"PROFUTURO","614571JVATV3","VENDEDOR",null,null,null,930,93,null,{"$f":"HUARAZ!H36","v":217},null,806,null,{"$f":"S13*10%","v":80.600000000000009},10.95,13.91,null,105.46000000000001,72.539999999999992,67.139800000000008,700.54,null,700.54,"375-90388226-0-94"]
["08","PEDRO ALEJANDRO ULLOA CHIGNE","72809837","HUACHO","2016-12-01","1993-03-06",null,"PROFUTURO","340321PUCOG3","VENDEDOR",null,null,null,930,93,null,{"$f":"HUACHO!B36","v":186},null,837,null,{"$f":"S14*10%","v":83.7},10.95,13.91,null,108.56,75.33,69.722099999999998,728.44,null,728.44,"375-90388534-0-05"]
["09","KHRYZZIA ARLENNE MERCADO ALBA","45417785","HUARAZ","2017-12-01","1988-02-06",null,"PRIMA","321770KMACA4","SECRETARIA",null,null,null,930,0,null,{"$f":"HUARAZ!I36","v":217},null,713,null,{"$f":"S15*10%","v":71.3},1.67,12.65,null,85.62,64.17,59.392899999999997,627.38,870,1497.38,"375-90388386-0-55"]
["10","GERARDO ANTONIO VENTOCILLA PALOMARES","41037836","HUACHO","2017-12-01","1981-09-30","MIXTA/SALDO","PROFUTURO",null,"PERSONAL DE LIMPIEZA",null,null,null,930,93,null,{"$f":"HUACHO!C36","v":93},null,930,null,{"$f":"+S16*0.1","v":93},10.95,13.91,null,{"$f":"SUM(T16:X16)","v":117.86},{"$f":"+S16*9%","v":83.7},{"$f":"+S16*8.33/100","v":77.468999999999994},{"$f":"+S16-Y16","v":812.14},330,1142.1399999999999,"375-90388762-0-35"]
["TOTAL MENSUAL -MAYO-2018",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K7:K16)","v":0},0,0,9300,558,0,1891,0,7967,503.75,409.20000000000005,36.36,65.3416,0,1014.6516000000001,717.03,663.65110000000004,6952.3484000000008,null,{"$f":"SUM(AD7:AD16)","v":11412.348399999999}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+A20","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"HUACHO"]
[null,null,null,"HUARAZ"]
[null,null,null,"IR A AYOSHIVAL.COM"]

{"sheet":"HUACHO","index":1,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["HUACHO"]
[null,"PEDRO ULLOA","GERARDO VENTOCILLA"]
["DIA 1","A","A"]
["DIA 2","A","A"]
["DIA 3","F","A"]
["DIA 4","A","A"]
["DIA 5","A","A"]
["DIA 6","F","A"]
["DIA 7","A","A"]
["DIA 8","A","A"]
["DIA 9","A","A"]
["DIA 10","F","A"]
["DIA 11","A","A"]
["DIA 12","A","A"]
["DIA 13","A","F"]
["DIA 14","F","A"]
["DIA 15","A","A"]
["DIA 16","A","A"]
["DIA 17","A","A"]
["DIA 18","A","A"]
["DIA 19","A","F"]
["DIA 20","F","A"]
["DIA 21","A","A"]
["DIA 22","A","A"]
["DIA 23","A","A"]
["DIA 24","A","A"]
["DIA 25","A","A"]
["DIA 26","A","A"]
["DIA 27","A","A"]
["DIA 28","A","F"]
["DIA 29","A","A"]
["DIA 30","F","A"]
["DIA 31","A","A"]
["TOTAL FATAS",{"$f":"COUNTIF(B3:B33,\"F\")","v":6},{"$f":"COUNTIF(C3:C33,\"F\")","v":3}]
["TOTAL ASISTENCIAS",{"$f":"COUNTIF(B3:B33,\"A\")","v":25},{"$f":"COUNTIF(C3:C33,\"A\")","v":28}]
["TOTAL A DESCONTAR",{"$f":"31*B34","v":186},{"$f":"31*C34","v":93}]

{"sheet":"HUARAZ","index":2,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["HUARAZ"]
[null,"CARLOS CHIGNE ","MELODY MAMANI","YULI PRUDENCIO","RUSSEL ACUÑA ","DIEGO  CERRUDO ","MERCEDES JAMANCA","JOSE VENTURA ","KHRYZZIA MERCADO "]
["DIA 1","A","A","A","A","A","A","A","A"]
["DIA 2","A","A","A","A","A","A","A","A"]
["DIA 3","F","A","F","A","F","A","F","F"]
["DIA 4","A","A","A","A","A","A","A","A"]
["DIA 5","A","A","A","A","A","A","A","A"]
["DIA 6","F","A","F","A","F","A","F","F"]
["DIA 7","A","A","A","A","A","A","A","A"]
["DIA 8","A","A","F","F","F","F","A","A"]
["DIA 9","A","A","A","A","A","A","A","F"]
["DIA 10","F","A","F","A","F","A","F","A"]
["DIA 11","A","A","A","A","A","A","A","A"]
["DIA 12","A","A","A","A","A","A","F","A"]
["DIA 13","A","F","A","F","A","F","A","F"]
["DIA 14","F","A","F","A","F","A","F","A"]
["DIA 15","A","A","A","A","A","F","A","A"]
["DIA 16","A","F","F","F","A","A","A","A"]
["DIA 17","A","A","A","A","A","A","A","A"]
["DIA 18","A","A","A","A","A","A","A","A"]
["DIA 19","A","F","A","F","A","F","A","F"]
["DIA 20","F","A","F","A","F","A","F","A"]
["DIA 21","A","A","A","A","A","A","A","A"]
["DIA 22","A","A","A","A","A","A","A","A"]
["DIA 23","A","A","A","A","A","A","A","A"]
["DIA 24","F","F","A","A","A","A","A","A"]
["DIA 25","A","A","A","A","A","A","A","A"]
["DIA 26","A","A","A","A","F","A","A","F"]
["DIA 27","A","A","A","A","A","A","A","A"]
["DIA 28","A","F","A","F","A","F","A","F"]
["DIA 29","A","A","A","A","A","A","A","A"]
["DIA 30","F","A","F","A","F","A","F","A"]
["DIA 31","A","A","A","A","A","A","A","A"]
["TOTAL FATAS",{"$f":"COUNTIF(B3:B33,\"F\")","v":7},5,8,5,8,5,7,7]
["TOTAL ASISTENCIAS",{"$f":"COUNTIF(B3:B33,\"A\")","v":24},26,23,26,23,26,24,24]
["TOTAL A DESCONTAR",{"$f":"31*B34","v":217},{"$f":"31*C34","v":155},{"$f":"31*D34","v":248},155,248,155,217,217]