{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Personal","Conceptos","Remunera","Otros","HE","Comi","Calculo"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":7,"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":"Personal","index":0,"n_rows":103,"n_cols":12,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,0,1,1],[1,2,1,3]]}
["DATOS DEL PERSONAL",null,null,"INGRESAR DATOS",null,null,null,null,null,null,null,"www.archivoexcel.com"]
[null,null,"www.archivoexcel.com"]
["N","Apellidos y Nombres","Fecha de Ingreso","Faltas"]
[1,"ALVARADO, PEDRO","2014-12-20"]
[2,"TINOCO, EDVER","2014-12-20"]
[3,"BARRIOS, OSCAR","2015-06-20"]
[4,"CASTILLO, GABINO","2015-01-10"]
[5,"LEON, ROLANDO ","2014-12-12"]
[6,"CHAHUA, HONORATO","2015-03-01",5]
[7,"CHOCCE, FELIX","2014-11-15"]
[8,"QUISPE, MAXIMO","2014-12-15"]
[9,"DESTAJERO","2014-11-15"]
[10,"DESTAJERO 1","2015-05-14"]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"Conceptos","index":1,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aportes"]

{"sheet":"Remunera","index":2,"n_rows":104,"n_cols":16,"rows_kept":104,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,0,2,0],[1,15,2,15],[1,2,2,2],[0,11,0,14]]}
["TIPO DE REMUNERACIÓN",null,null,null,"SELECCIONAR DATO",null,null,null,"INGRESAR DATOS",null,null,"www.archivoexcel.com"]
["N","Apellidos y Nombres","Sueldo",1,null,2,null,3,null,4,null,5,null,6,null,"Promedio"]
[null,null,null,"Importe","Días","Importe","Días","Importe","Días","Importe","Días","Importe","Días","Importe","Días"]
[1,"ALVARADO, PEDRO",2500,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND((D4+F4+H4+J4+L4+N4)>0,(E4+G4+I4+K4+M4+O4)>0),(D4+F4+H4+J4+L4+N4)/(E4+G4+I4+K4+M4+O4)*30,IF(C4>0,C4,0))","v":2500}]
[2,"TINOCO, EDVER",3200,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND((D5+F5+H5+J5+L5+N5)>0,(E5+G5+I5+K5+M5+O5)>0),(D5+F5+H5+J5+L5+N5)/(E5+G5+I5+K5+M5+O5)*30,IF(C5>0,C5,0))","v":3200}]
[3,"BARRIOS, OSCAR",1000,null,null,null,null,null,null,null,null,null,null,null,null,1000]
[4,"LEON, ROLANDO ",{"$f":"(45+25)*30","v":2100},null,null,null,null,null,null,null,null,null,null,null,null,2100]
[5,"CHAHUA, HONORATO",1500,null,null,null,null,null,null,null,null,null,null,null,null,1500]
[6,"CHOCCE, FELIX",2800,null,null,null,null,null,null,null,null,null,null,null,null,2800]
[7,"QUISPE, MAXIMO",1800,null,null,null,null,null,null,null,null,null,null,null,null,1800]
[8,"DESTAJERO",null,700,30,650,30,800,30,550,30,800,30,600,30,683.33333333333337]
[9,"DESTAJERO 1",null,null,null,null,null,null,null,null,null,1000,30,2500,30,1750]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[52,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[54,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[56,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[57,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[59,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[61,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[66,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND((D69+F69+H69+J69+L69+N69)>0,(E69+G69+I69+K69+M69+O69)>0),(D69+F69+H69+J69+L69+N69)/(E69+G69+I69+K69+M69+O69)*30,IF(C69>0,C69,0))","v":0}]
[67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[71,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[82,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[83,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[86,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[87,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[88,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[91,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[92,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[94,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[96,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[97,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Otros","index":3,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,0,1,2]]}
["OTROS TIPOS DE INGRESOS",null,null,null,null,"SELECCIONAR DATO"]
[null,null,null,null,null,"INGRESAR DATOS"]
["N","Apellidos y Nombres","Asign. Famil","Bonif. Ordina.","Alimen. Princi.","B","C"]
[1,"ALVARADO, PEDRO",75,800]
[2,"TINOCO, EDVER",75,null,250]
[3,"BARRIOS, OSCAR",75]
[4,"CASTILLO, GABINO",75]
[5,"LEON, ROLANDO ",75]
[6,"CHAHUA, HONORATO",75]
[7,"CHOCCE, FELIX",75]
[8,"QUISPE, MAXIMO",75]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"HE","index":4,"n_rows":103,"n_cols":9,"rows_kept":103,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,0,2,0],[1,8,2,8]]}
["DETALLE DE HORAS EXTRAS",null,null,null,"SELECCIONAR DATO",null,null,"INGRESAR DATOS"]
["N","Apellidos y Nombres",1,2,3,4,5,6,"Promedio"]
[null,null,"Importe","Importe","Importe","Importe","Importe","Importe"]
[1,"CHOCCE, FELIX",158.78,149,139,160.15,158.56,178.5,{"$f":"IF((IF(C4>0,1,0)+IF(D4>0,1,0)+IF(E4>0,1,0)+IF(F4>0,1,0)+IF(G4>0,1,0)+IF(H4>0,1,0))>=3,SUM(C4:H4)/6,0)","v":157.33166666666668}]
[2,"QUISPE, MAXIMO",20,18,null,null,35,null,{"$f":"IF((IF(C5>0,1,0)+IF(D5>0,1,0)+IF(E5>0,1,0)+IF(F5>0,1,0)+IF(G5>0,1,0)+IF(H5>0,1,0))>=3,SUM(C5:H5)/6,0)","v":12.166666666666666}]
[3,null,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,0]
[32,null,null,null,null,null,null,null,0]
[33,null,null,null,null,null,null,null,0]
[34,null,null,null,null,null,null,null,0]
[35,null,null,null,null,null,null,null,0]
[36,null,null,null,null,null,null,null,0]
[37,null,null,null,null,null,null,null,0]
[38,null,null,null,null,null,null,null,0]
[39,null,null,null,null,null,null,null,0]
[40,null,null,null,null,null,null,null,0]
[41,null,null,null,null,null,null,null,0]
[42,null,null,null,null,null,null,null,0]
[43,null,null,null,null,null,null,null,0]
[44,null,null,null,null,null,null,null,0]
[45,null,null,null,null,null,null,null,0]
[46,null,null,null,null,null,null,null,0]
[47,null,null,null,null,null,null,null,0]
[48,null,null,null,null,null,null,null,0]
[49,null,null,null,null,null,null,null,0]
[50,null,null,null,null,null,null,null,0]
[51,null,null,null,null,null,null,null,0]
[52,null,null,null,null,null,null,null,0]
[53,null,null,null,null,null,null,null,0]
[54,null,null,null,null,null,null,null,0]
[55,null,null,null,null,null,null,null,0]
[56,null,null,null,null,null,null,null,0]
[57,null,null,null,null,null,null,null,0]
[58,null,null,null,null,null,null,null,0]
[59,null,null,null,null,null,null,null,0]
[60,null,null,null,null,null,null,null,0]
[61,null,null,null,null,null,null,null,0]
[62,null,null,null,null,null,null,null,0]
[63,null,null,null,null,null,null,null,0]
[64,null,null,null,null,null,null,null,0]
[65,null,null,null,null,null,null,null,0]
[66,null,null,null,null,null,null,null,{"$f":"IF((IF(C69>0,1,0)+IF(D69>0,1,0)+IF(E69>0,1,0)+IF(F69>0,1,0)+IF(G69>0,1,0)+IF(H69>0,1,0))>=3,SUM(C69:H69)/6,0)","v":0}]
[67,null,null,null,null,null,null,null,0]
[68,null,null,null,null,null,null,null,0]
[69,null,null,null,null,null,null,null,0]
[70,null,null,null,null,null,null,null,0]
[71,null,null,null,null,null,null,null,0]
[72,null,null,null,null,null,null,null,0]
[73,null,null,null,null,null,null,null,0]
[74,null,null,null,null,null,null,null,0]
[75,null,null,null,null,null,null,null,0]
[76,null,null,null,null,null,null,null,0]
[77,null,null,null,null,null,null,null,0]
[78,null,null,null,null,null,null,null,0]
[79,null,null,null,null,null,null,null,0]
[80,null,null,null,null,null,null,null,0]
[81,null,null,null,null,null,null,null,0]
[82,null,null,null,null,null,null,null,0]
[83,null,null,null,null,null,null,null,0]
[84,null,null,null,null,null,null,null,0]
[85,null,null,null,null,null,null,null,0]
[86,null,null,null,null,null,null,null,0]
[87,null,null,null,null,null,null,null,0]
[88,null,null,null,null,null,null,null,0]
[89,null,null,null,null,null,null,null,0]
[90,null,null,null,null,null,null,null,0]
[91,null,null,null,null,null,null,null,0]
[92,null,null,null,null,null,null,null,0]
[93,null,null,null,null,null,null,null,0]
[94,null,null,null,null,null,null,null,0]
[95,null,null,null,null,null,null,null,0]
[96,null,null,null,null,null,null,null,0]
[97,null,null,null,null,null,null,null,0]
[98,null,null,null,null,null,null,null,0]
[99,null,null,null,null,null,null,null,0]
[100,null,null,null,null,null,null,null,0]

{"sheet":"Comi","index":5,"n_rows":103,"n_cols":15,"rows_kept":103,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,0,2,0],[1,14,2,14],[0,11,0,14]]}
["DETALLE DE COMISIONES",null,null,null,null,"SELECCIONAR DATO",null,null,null,"INGRESAR DATOS",null,"www.archivoexcel.com"]
["N","Apellidos y Nombres",1,null,2,null,3,null,4,null,5,null,6,null,"Promedio"]
[null,null,"Importe","Días","Importe","Días","Importe","Días","Importe","Días","Importe","Días","Importe","Días"]
[1,"TINOCO, EDVER",850,null,710,null,560,null,680,null,790,null,845,null,{"$f":"IF(AND((C4+E4+G4+I4+K4+M4)>0,(D4+F4+H4+J4+L4+N4)>0),((C4+E4+G4+I4+K4+M4)/(D4+F4+H4+J4+L4+N4))*30,(C4+E4+G4+I4+K4+M4)/6)","v":739.16666666666663}]
[2,"CASTILLO, GABINO",450,10,930,30,1100,30,900,30,945,30,1150,30,{"$f":"IF(AND((C5+E5+G5+I5+K5+M5)>0,(D5+F5+H5+J5+L5+N5)>0),((C5+E5+G5+I5+K5+M5)/(D5+F5+H5+J5+L5+N5))*30,(C5+E5+G5+I5+K5+M5)/6)","v":1026.5625}]
[3,"QUISPE, MAXIMO",200,null,null,null,null,null,null,null,220,null,null,null,70]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[36,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[38,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[41,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[42,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[43,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[44,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[46,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[47,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[48,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[49,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[52,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[53,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[54,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[55,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[56,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[57,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[58,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[59,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[60,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[61,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[62,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[63,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[64,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[65,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[66,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND((C69+E69+G69+I69+K69+M69)>0,(D69+F69+H69+J69+L69+N69)>0),((C69+E69+G69+I69+K69+M69)/(D69+F69+H69+J69+L69+N69))*30,(C69+E69+G69+I69+K69+M69)/6)","v":0}]
[67,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[68,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[69,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[70,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[71,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[72,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[73,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[74,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[75,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[76,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[77,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[78,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[79,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[80,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[81,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[82,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[83,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[84,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[85,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[86,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[87,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[88,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[89,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[90,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[91,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[92,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[93,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[94,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[95,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[96,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[97,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[98,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[99,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[100,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Calculo","index":6,"n_rows":104,"n_cols":26,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,1,1],[0,6,0,9]]}
["DETALLE DEL CALCULO",null,null,"SELECCIONAR DATO",null,null,"www.archivoexcel.com",null,null,null,null,null,null,null,null,null,"2015-06-30"]
[null,null,null,"INGRESAR DATOS",null,null,null,null,null,null,null,null,null,"Factor en S/.",null,null,{"$f":"DATE(YEAR(Q1),MONTH(Q1)-5,1)","v":"2015-01-01"},null,null,null,"Tiempo Computable",null,null,"Gratificación"]
["N","Apellidos y Nombres","Fecha de Ingreso","Remunerac Computable","Sueldo","Asign. Famil","H: E.","Comisiones",{"$f":"Otros!D3","v":"Bonif. Ordina."},{"$f":"Otros!E3","v":"Alimen. Princi."},{"$f":"Otros!F3","v":"B"},{"$f":"Otros!G3","v":"C"},null,"x Mes","x Día",null,"Total Días",null,"Faltas",null,"Meses","Días",null,"Gratificación","Bono Extra.  Ley Nº 30334","Total"]
[1,"ALVARADO, PEDRO",{"$f":"IF(ISERROR(VLOOKUP(B4,DATAPERSONAL,1,0))=FALSE,VLOOKUP(B4,DATAPERSONAL,2,0),\"\")","v":"2014-12-20"},{"$f":"SUM(E4:L4)","v":3375},{"$f":"IF(ISERROR(VLOOKUP(B4,DATASUELDO,1,0))=FALSE,VLOOKUP(B4,DATASUELDO,15,0),0)","v":2500},{"$f":"IF(ISERROR(VLOOKUP(B4,DATAOTROS,1,0))=FALSE,VLOOKUP(B4,DATAOTROS,2,0),0)","v":75},{"$f":"IF(ISERROR(VLOOKUP(B4,DATAHORASEXTRAS,1,0))=FALSE,VLOOKUP(B4,DATAHORASEXTRAS,8,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B4,DATACOMISIONES,1,0))=FALSE,VLOOKUP(B4,DATACOMISIONES,14,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B4,DATAOTROS,1,0))=FALSE,VLOOKUP(B4,DATAOTROS,3,0),0)","v":800},{"$f":"IF(ISERROR(VLOOKUP(B4,DATAOTROS,1,0))=FALSE,VLOOKUP(B4,DATAOTROS,4,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B4,DATAOTROS,1,0))=FALSE,VLOOKUP(B4,DATAOTROS,5,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B4,DATAOTROS,1,0))=FALSE,VLOOKUP(B4,DATAOTROS,6,0),0)","v":0},null,{"$f":"D4/6","v":562.5},{"$f":"N4/30","v":18.75},null,{"$f":"IF(ISERROR(IF(AND(MONTH($Q$1)=6,C4>=$Q$2),DAYS360(C4,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C4>=$Q$2),DAYS360(C4,$Q$1,1)+1,IF(AND(MONTH($Q$1)=6,C4<$Q$2),DAYS360($Q$2,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C4<$Q$2),DAYS360($Q$2,$Q$1,1)+1,0)))))=TRUE,0,IF(AND(MONTH($Q$1)=6,C4>=$Q$2),DAYS360(C4,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C4>=$Q$2),DAYS360(C4,$Q$1,1)+1,IF(AND(MONTH($Q$1)=6,C4<$Q$2),DAYS360($Q$2,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C4<$Q$2),DAYS360($Q$2,$Q$1,1)+1,0)))))","v":180},null,{"$f":"IF(ISERROR(VLOOKUP(B4,DATAPERSONAL,1,0))=FALSE,VLOOKUP(B4,DATAPERSONAL,3,0),0)","v":0},null,{"$f":"INT((Q4-S4)/30)","v":6},{"$f":"IF(S4>0,(Q4-S4)-(U4*30),0)","v":0},null,{"$f":"(N4*U4)+(O4*V4)","v":3375},{"$f":"X4*0.09","v":303.75},{"$f":"SUM(X4:Y4)","v":3678.75}]
[2,"TINOCO, EDVER","2014-12-20",4264.1666666666661,3200,75,0,739.16666666666663,0,250,0,0,null,{"$f":"D5/6","v":710.69444444444434},{"$f":"N5/30","v":23.689814814814813},null,{"$f":"IF(ISERROR(IF(AND(MONTH($Q$1)=6,C5>=$Q$2),DAYS360(C5,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C5>=$Q$2),DAYS360(C5,$Q$1,1)+1,IF(AND(MONTH($Q$1)=6,C5<$Q$2),DAYS360($Q$2,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C5<$Q$2),DAYS360($Q$2,$Q$1,1)+1,0)))))=TRUE,0,IF(AND(MONTH($Q$1)=6,C5>=$Q$2),DAYS360(C5,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C5>=$Q$2),DAYS360(C5,$Q$1,1)+1,IF(AND(MONTH($Q$1)=6,C5<$Q$2),DAYS360($Q$2,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C5<$Q$2),DAYS360($Q$2,$Q$1,1)+1,0)))))","v":180},null,0,null,{"$f":"INT((Q5-S5)/30)","v":6},{"$f":"IF(S5>0,(Q5-S5)-(U5*30),0)","v":0},null,{"$f":"(N5*U5)+(O5*V5)","v":4264.1666666666661},{"$f":"X5*0.09","v":383.77499999999992},{"$f":"SUM(X5:Y5)","v":4647.9416666666657}]
[3,"BARRIOS, OSCAR","2015-06-20",1075,1000,75,0,0,0,0,0,0,null,{"$f":"D6/6","v":179.16666666666666},5.9722222222222223,null,11,null,0,null,{"$f":"INT((Q6-S6)/30)","v":0},0,null,{"$f":"(N6*U6)+(O6*V6)","v":0},{"$f":"X6*0.09","v":0},{"$f":"SUM(X6:Y6)","v":0}]
[4,"CASTILLO, GABINO","2015-01-10",1101.5625,0,75,0,1026.5625,0,0,0,0,null,{"$f":"D7/6","v":183.59375},6.119791666666667,null,171,null,0,null,5,0,null,917.96875,82.6171875,1000.5859375]
[5,"LEON, ROLANDO ","2014-12-12",2175,2100,75,0,0,0,0,0,0,null,{"$f":"D8/6","v":362.5},12.083333333333334,null,180,null,0,null,6,0,null,2175,195.75,2370.75]
[6,"CHAHUA, HONORATO","2015-03-01",1575,1500,75,0,0,0,0,0,0,null,{"$f":"D9/6","v":262.5},8.75,null,120,null,5,null,3,25,null,1006.25,90.5625,1096.8125]
[7,"CHOCCE, FELIX","2014-11-15",{"$f":"SUM(E10:L10)","v":3032.3316666666665},2800,75,157.33166666666668,0,0,0,0,0,null,505.38861111111106,16.846287037037037,null,180,null,0,null,6,0,null,3032.3316666666665,272.90984999999995,3305.2415166666665]
[8,"QUISPE, MAXIMO","2014-12-15",1957.1666666666667,1800,75,12.166666666666666,70,0,0,0,0,null,326.19444444444446,10.873148148148148,null,180,null,0,null,6,0,null,1957.1666666666667,176.14500000000001,2133.311666666667]
[9,"DESTAJERO","2014-11-15",{"$f":"SUM(E12:L12)","v":683.33333333333337},683.33333333333337,0,0,0,0,0,0,0,null,{"$f":"D12/6","v":113.8888888888889},3.7962962962962967,null,{"$f":"IF(ISERROR(IF(AND(MONTH($Q$1)=6,C12>=$Q$2),DAYS360(C12,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C12>=$Q$2),DAYS360(C12,$Q$1,1)+1,IF(AND(MONTH($Q$1)=6,C12<$Q$2),DAYS360($Q$2,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C12<$Q$2),DAYS360($Q$2,$Q$1,1)+1,0)))))=TRUE,0,IF(AND(MONTH($Q$1)=6,C12>=$Q$2),DAYS360(C12,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C12>=$Q$2),DAYS360(C12,$Q$1,1)+1,IF(AND(MONTH($Q$1)=6,C12<$Q$2),DAYS360($Q$2,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C12<$Q$2),DAYS360($Q$2,$Q$1,1)+1,0)))))","v":180},null,0,null,{"$f":"INT((Q12-S12)/30)","v":6},{"$f":"IF(S12>0,(Q12-S12)-(U12*30),0)","v":0},null,{"$f":"(N12*U12)+(O12*V12)","v":683.33333333333337},61.5,{"$f":"SUM(X12:Y12)","v":744.83333333333337}]
[10,"DESTAJERO 1","2015-05-14",1750,1750,0,0,0,0,0,0,0,null,291.66666666666669,9.7222222222222232,null,47,null,0,null,1,0,null,291.66666666666669,26.25,317.91666666666669]
[11,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[12,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[13,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[14,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[15,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[16,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[17,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[18,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[19,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[20,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[21,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[22,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[23,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[24,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[25,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[26,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[27,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[28,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[29,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[30,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[31,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[32,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[33,null,{"$f":"IF(ISERROR(VLOOKUP(B36,DATAPERSONAL,1,0))=FALSE,VLOOKUP(B36,DATAPERSONAL,2,0),\"\")","v":""},0,{"$f":"IF(ISERROR(VLOOKUP(B36,DATASUELDO,1,0))=FALSE,VLOOKUP(B36,DATASUELDO,15,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B36,DATAOTROS,1,0))=FALSE,VLOOKUP(B36,DATAOTROS,2,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B36,DATAHORASEXTRAS,1,0))=FALSE,VLOOKUP(B36,DATAHORASEXTRAS,8,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B36,DATACOMISIONES,1,0))=FALSE,VLOOKUP(B36,DATACOMISIONES,14,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B36,DATAOTROS,1,0))=FALSE,VLOOKUP(B36,DATAOTROS,3,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B36,DATAOTROS,1,0))=FALSE,VLOOKUP(B36,DATAOTROS,4,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B36,DATAOTROS,1,0))=FALSE,VLOOKUP(B36,DATAOTROS,5,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B36,DATAOTROS,1,0))=FALSE,VLOOKUP(B36,DATAOTROS,6,0),0)","v":0},null,0,0,null,0,null,{"$f":"IF(ISERROR(VLOOKUP(B36,DATAPERSONAL,1,0))=FALSE,VLOOKUP(B36,DATAPERSONAL,3,0),0)","v":0},null,0,0,null,0,0,0]
[34,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[35,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[36,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[37,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[38,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[39,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[40,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[41,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[42,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[43,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[44,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[45,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[46,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[47,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[48,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[49,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[50,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[51,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[52,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[53,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[54,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[55,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[56,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[57,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[58,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[59,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[60,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[61,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[62,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[63,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[64,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[65,null,{"$f":"IF(ISERROR(VLOOKUP(B68,DATAPERSONAL,1,0))=FALSE,VLOOKUP(B68,DATAPERSONAL,2,0),\"\")","v":""},0,{"$f":"IF(ISERROR(VLOOKUP(B68,DATASUELDO,1,0))=FALSE,VLOOKUP(B68,DATASUELDO,15,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B68,DATAOTROS,1,0))=FALSE,VLOOKUP(B68,DATAOTROS,2,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B68,DATAHORASEXTRAS,1,0))=FALSE,VLOOKUP(B68,DATAHORASEXTRAS,8,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B68,DATACOMISIONES,1,0))=FALSE,VLOOKUP(B68,DATACOMISIONES,14,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B68,DATAOTROS,1,0))=FALSE,VLOOKUP(B68,DATAOTROS,3,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B68,DATAOTROS,1,0))=FALSE,VLOOKUP(B68,DATAOTROS,4,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B68,DATAOTROS,1,0))=FALSE,VLOOKUP(B68,DATAOTROS,5,0),0)","v":0},{"$f":"IF(ISERROR(VLOOKUP(B68,DATAOTROS,1,0))=FALSE,VLOOKUP(B68,DATAOTROS,6,0),0)","v":0},null,0,0,null,0,null,{"$f":"IF(ISERROR(VLOOKUP(B68,DATAPERSONAL,1,0))=FALSE,VLOOKUP(B68,DATAPERSONAL,3,0),0)","v":0},null,0,0,null,0,0,0]
[66,null,"",0,0,0,0,0,0,0,0,0,null,0,{"$f":"N69/30","v":0},null,0,null,0,null,0,0,null,0,0,0]
[67,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,{"$f":"X70*0.09","v":0},0]
[68,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[69,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[70,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[71,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[72,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[73,null,"",{"$f":"SUM(E76:L76)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"D76/6","v":0},0,null,{"$f":"IF(ISERROR(IF(AND(MONTH($Q$1)=6,C76>=$Q$2),DAYS360(C76,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C76>=$Q$2),DAYS360(C76,$Q$1,1)+1,IF(AND(MONTH($Q$1)=6,C76<$Q$2),DAYS360($Q$2,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C76<$Q$2),DAYS360($Q$2,$Q$1,1)+1,0)))))=TRUE,0,IF(AND(MONTH($Q$1)=6,C76>=$Q$2),DAYS360(C76,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C76>=$Q$2),DAYS360(C76,$Q$1,1)+1,IF(AND(MONTH($Q$1)=6,C76<$Q$2),DAYS360($Q$2,$Q$1,1)+1,IF(AND(MONTH($Q$1)=12,C76<$Q$2),DAYS360($Q$2,$Q$1,1)+1,0)))))","v":0},null,0,null,{"$f":"INT((Q76-S76)/30)","v":0},{"$f":"IF(S76>0,(Q76-S76)-(U76*30),0)","v":0},null,{"$f":"(N76*U76)+(O76*V76)","v":0},0,{"$f":"SUM(X76:Y76)","v":0}]
[74,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[75,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[76,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[77,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[78,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[79,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[80,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[81,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[82,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[83,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[84,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[85,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[86,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[87,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[88,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[89,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[90,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[91,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[92,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[93,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[94,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[95,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[96,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[97,null,{"$f":"IF(ISERROR(VLOOKUP(B100,DATAPERSONAL,1,0))=FALSE,VLOOKUP(B100,DATAPERSONAL,2,0),\"\")","v":""},0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[98,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[99,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[100,null,"",0,0,0,0,0,0,0,0,0,null,0,0,null,0,null,0,null,0,0,null,0,0,0]
[null,null,""]