{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DATOS","VENTAS"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":9,"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":"DATOS","index":0,"n_rows":101,"n_cols":11,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["código","Nombre","Región","Curso","Examen\nParcial","Costo","Descuento","Neto a\nPagar","Examen\nFinal","Nota","Observación"]
[1,"Alfonso","Oeste","Word",9,240,{"$f":"IF(C2=\"Norte\",15%*F2,8%*F2)","v":19.2},{"$f":"F$2:F$65536-G$2:G$65536","v":220.8},19,{"$f":"(E2+I2)/2","v":14},{"$f":"IF(J2>=14,\"Aprobado\",\"Desaprobado\")","v":"Aprobado"}]
[2,"Moisés","Oeste","Power Point",9,230,18.400000000000002,211.6,16,12.5,"Desaprobado"]
[3,"Diana","Este","Excel",20,240,19.2,220.8,15,17.5,"Aprobado"]
[4,"Luis","Este","Power Point",20,230,18.400000000000002,211.6,13,16.5,"Aprobado"]
[5,"Fabiola","Oeste","Access",11,280,22.400000000000002,257.60000000000002,11,11,"Desaprobado"]
[6,"Leonidas","Sur","Excel",18,240,19.2,220.8,13,15.5,"Aprobado"]
[7,"Tania","Este","Access",20,280,22.400000000000002,257.60000000000002,20,20,"Aprobado"]
[8,"Vanessa","Norte","Access",12,280,42,238,12,12,"Desaprobado"]
[9,"Pedro","Sur","Word",11,240,19.2,220.8,11,11,"Desaprobado"]
[10,"Elisa","Oeste","Windows",15,220,17.600000000000001,202.4,9,12,"Desaprobado"]
[11,"Ronald","Centro","Access",19,280,22.400000000000002,257.60000000000002,15,17,"Aprobado"]
[12,"Antonio","Este","Excel",11,240,19.2,220.8,17,14,"Aprobado"]
[13,"Florencio","Oeste","Excel",18,240,19.2,220.8,13,15.5,"Aprobado"]
[14,"Amelia","Centro","Power Point",16,230,18.400000000000002,211.6,19,17.5,"Aprobado"]
[15,"Zaida","Norte","Power Point",8,230,34.5,195.5,10,9,"Desaprobado"]
[16,"Giovanna","Oeste","Access",8,280,22.400000000000002,257.60000000000002,19,13.5,"Desaprobado"]
[17,"Isabel","Norte","Windows",14,220,33,187,10,12,"Desaprobado"]
[18,"Magaly","Norte","Power Point",8,230,34.5,195.5,11,9.5,"Desaprobado"]
[19,"Carlos","Este","Windows",18,220,17.600000000000001,202.4,20,19,"Aprobado"]
[20,"Jenny","Este","Word",17,240,19.2,220.8,10,13.5,"Desaprobado"]
[21,"José","Sur","Excel",14,240,19.2,220.8,13,13.5,"Desaprobado"]
[22,"Janeth","Norte","Windows",12,220,33,187,17,14.5,"Aprobado"]
[23,"Roberto","Oeste","Excel",16,240,19.2,220.8,12,14,"Aprobado"]
[24,"Marcos","Sur","Excel",19,240,19.2,220.8,11,15,"Aprobado"]
[25,"Alejandrina","Este","Access",14,280,22.400000000000002,257.60000000000002,19,16.5,"Aprobado"]
[26,"Iván","Norte","Power Point",18,230,34.5,195.5,16,17,"Aprobado"]
[27,"Elías","Centro","Word",12,240,19.2,220.8,9,10.5,"Desaprobado"]
[28,"Lidia","Oeste","Word",8,240,19.2,220.8,17,12.5,"Desaprobado"]
[29,"Manuel","Norte","Access",15,280,42,238,17,16,"Aprobado"]
[30,"Salomón","Sur","Power Point",18,230,18.400000000000002,211.6,11,14.5,"Aprobado"]
[31,"William","Norte","Word",17,240,36,204,11,14,"Aprobado"]
[32,"Maritza","Este","Windows",8,220,17.600000000000001,202.4,14,11,"Desaprobado"]
[33,"Carmen","Norte","Excel",16,240,{"$f":"IF(C34=\"Norte\",15%*F34,8%*F34)","v":36},{"$f":"F$2:F$65536-G$2:G$65536","v":204},12,{"$f":"(E34+I34)/2","v":14},{"$f":"IF(J34>=14,\"Aprobado\",\"Desaprobado\")","v":"Aprobado"}]
[34,"Alejandro","Oeste","Access",17,280,22.400000000000002,257.60000000000002,18,17.5,"Aprobado"]
[35,"Cynthia","Oeste","Windows",19,220,17.600000000000001,202.4,15,17,"Aprobado"]
[36,"Viviana","Centro","Excel",16,240,19.2,220.8,10,13,"Desaprobado"]
[37,"Dominga","Este","Word",9,240,19.2,220.8,17,13,"Desaprobado"]
[38,"Elba","Oeste","Windows",15,220,17.600000000000001,202.4,17,16,"Aprobado"]
[39,"Edson","Este","Power Point",19,230,18.400000000000002,211.6,16,17.5,"Aprobado"]
[40,"Marina","Este","Windows",14,220,17.600000000000001,202.4,8,11,"Desaprobado"]
[41,"Raúl","Norte","Power Point",17,230,34.5,195.5,17,17,"Aprobado"]
[42,"Inés","Este","Excel",19,240,19.2,220.8,20,19.5,"Aprobado"]
[43,"Dany","Oeste","Windows",10,220,17.600000000000001,202.4,13,11.5,"Desaprobado"]
[44,"Javier","Sur","Power Point",8,230,18.400000000000002,211.6,8,8,"Desaprobado"]
[45,"Andrés","Oeste","Word",13,240,19.2,220.8,13,13,"Desaprobado"]
[46,"Juan","Norte","Access",20,280,42,238,11,15.5,"Aprobado"]
[47,"Arturo","Oeste","Word",19,240,19.2,220.8,16,17.5,"Aprobado"]
[48,"Angel","Sur","Windows",18,220,17.600000000000001,202.4,19,18.5,"Aprobado"]
[49,"Lizeth","Norte","Word",20,240,36,204,10,15,"Aprobado"]
[50,"Yenny","Sur","Windows",10,220,17.600000000000001,202.4,11,10.5,"Desaprobado"]
[51,"Dagoberto","Oeste","Access",13,280,22.400000000000002,257.60000000000002,19,16,"Aprobado"]
[52,"Rubén","Norte","Word",19,240,36,204,17,18,"Aprobado"]
[53,"Alfredo","Sur","Power Point",15,230,18.400000000000002,211.6,15,15,"Aprobado"]
[54,"María","Sur","Power Point",13,230,18.400000000000002,211.6,15,14,"Aprobado"]
[55,"Oscar","Este","Power Point",12,230,18.400000000000002,211.6,10,11,"Desaprobado"]
[56,"Daniel","Oeste","Power Point",15,230,18.400000000000002,211.6,17,16,"Aprobado"]
[57,"Raquel","Oeste","Power Point",13,230,18.400000000000002,211.6,16,14.5,"Aprobado"]
[58,"Mercedes","Oeste","Access",10,280,22.400000000000002,257.60000000000002,17,13.5,"Desaprobado"]
[59,"Joel","Norte","Power Point",10,230,34.5,195.5,18,14,"Aprobado"]
[60,"Regina","Norte","Word",14,240,36,204,18,16,"Aprobado"]
[61,"Marita","Centro","Windows",19,220,17.600000000000001,202.4,8,13.5,"Desaprobado"]
[62,"Natividad","Este","Excel",16,240,19.2,220.8,17,16.5,"Aprobado"]
[63,"Faustino","Sur","Power Point",19,230,18.400000000000002,211.6,15,17,"Aprobado"]
[64,"Aurelio","Centro","Word",9,240,19.2,220.8,16,12.5,"Desaprobado"]
[65,"Irazema","Norte","Windows",19,220,{"$f":"IF(C66=\"Norte\",15%*F66,8%*F66)","v":33},{"$f":"F$2:F$65536-G$2:G$65536","v":187},10,{"$f":"(E66+I66)/2","v":14.5},{"$f":"IF(J66>=14,\"Aprobado\",\"Desaprobado\")","v":"Aprobado"}]
[66,"Sonia","Sur","Access",14,280,22.400000000000002,257.60000000000002,17,15.5,"Aprobado"]
[67,"Enrique","Oeste","Windows",20,220,17.600000000000001,202.4,18,19,"Aprobado"]
[68,"Jesús","Sur","Access",19,280,22.400000000000002,257.60000000000002,14,16.5,"Aprobado"]
[69,"Teresa","Oeste","Power Point",17,230,18.400000000000002,211.6,16,16.5,"Aprobado"]
[70,"Renán","Sur","Excel",16,240,19.2,220.8,16,16,"Aprobado"]
[71,"Octavio","Norte","Excel",11,240,36,204,14,12.5,"Desaprobado"]
[72,"Mario","Oeste","Excel",9,240,19.2,220.8,11,10,"Desaprobado"]
[73,"Jorge","Centro","Power Point",15,230,18.400000000000002,211.6,19,17,"Aprobado"]
[74,"Heli","Norte","Excel",18,240,36,204,15,16.5,"Aprobado"]
[75,"Alberto","Este","Access",14,280,22.400000000000002,257.60000000000002,11,12.5,"Desaprobado"]
[76,"Ronaldo","Sur","Access",15,280,22.400000000000002,257.60000000000002,11,13,"Desaprobado"]
[77,"Israel","Sur","Access",8,280,22.400000000000002,257.60000000000002,16,12,"Desaprobado"]
[78,"Ricardo","Norte","Excel",11,240,36,204,17,14,"Aprobado"]
[79,"Armando","Sur","Word",20,240,19.2,220.8,8,14,"Aprobado"]
[80,"Alicia","Centro","Excel",14,240,19.2,220.8,20,17,"Aprobado"]
[81,"Vladimir","Sur","Access",20,280,22.400000000000002,257.60000000000002,19,19.5,"Aprobado"]
[82,"Romell","Norte","Windows",11,220,33,187,16,13.5,"Desaprobado"]
[83,"Adán","Este","Windows",8,220,17.600000000000001,202.4,16,12,"Desaprobado"]
[84,"Alcides","Sur","Windows",12,220,17.600000000000001,202.4,9,10.5,"Desaprobado"]
[85,"Josué","Sur","Windows",9,220,17.600000000000001,202.4,16,12.5,"Desaprobado"]
[86,"Yesenia","Este","Word",15,240,19.2,220.8,14,14.5,"Aprobado"]
[87,"Rafael","Sur","Windows",19,220,17.600000000000001,202.4,8,13.5,"Desaprobado"]
[88,"Gertrudis","Centro","Access",8,280,22.400000000000002,257.60000000000002,12,10,"Desaprobado"]
[89,"Alonso","Norte","Windows",14,220,33,187,15,14.5,"Aprobado"]
[90,"Gabriel","Sur","Excel",16,240,19.2,220.8,17,16.5,"Aprobado"]
[91,"Alex","Oeste","Excel",12,240,19.2,220.8,20,16,"Aprobado"]
[92,"Ulises","Sur","Word",9,240,19.2,220.8,15,12,"Desaprobado"]
[93,"Patricia","Centro","Power Point",19,230,18.400000000000002,211.6,9,14,"Aprobado"]
[94,"Noé","Centro","Word",13,240,19.2,220.8,11,12,"Desaprobado"]
[95,"Walter","Este","Word",12,240,19.2,220.8,11,11.5,"Desaprobado"]
[96,"Nancy","Sur","Access",19,280,22.400000000000002,257.60000000000002,18,18.5,"Aprobado"]
[97,"Giannina","Centro","Access",20,280,{"$f":"IF(C98=\"Norte\",15%*F98,8%*F98)","v":22.400000000000002},{"$f":"F$2:F$65536-G$2:G$65536","v":257.60000000000002},18,{"$f":"(E98+I98)/2","v":19},{"$f":"IF(J98>=14,\"Aprobado\",\"Desaprobado\")","v":"Aprobado"}]
[98,"Ernesto","Oeste","Word",12,240,19.2,220.8,19,15.5,"Aprobado"]
[99,"Erika","Sur","Word",16,240,19.2,220.8,18,17,"Aprobado"]
[100,"Ana","Centro","Excel",13,240,19.2,220.8,13,13,"Desaprobado"]

{"sheet":"VENTAS","index":1,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,5,1,8],[8,0,8,10]]}
[]
["TABLA1",null,null,null,null,"PRECIOS"]
["Vehículo","Comisión",null,null,null,"Vehículo","Ford","Volvo","Hyundai"]
["Automóvil",30,null,null,null,"Automóvil",14000,34000,9000]
["Camión",70,null,null,null,"Camión",43000,51000,35000]
["Camioneta",35,null,null,null,"Camioneta",20000,23000,18000]
["Omnibus",50,null,null,null,"Omnibus",42000,45000,39000]
[]
["Venta de Vehículos"]
[]
["Agencia","Vehículo","Marca","Turno","Lugar","Vendedor","Cantidad","Comisión","Monto","IGV","TOTAL"]
["La Estrella","Camión","Ford","Tarde","Lima","Robles",7,{"$f":"VLOOKUP(B12,$A$4:$B$7,2)*7","v":490},{"$f":"(INDIRECT(B12) INDIRECT(C12))*G12","v":301000},{"$f":"I12*19%","v":57190},{"$f":"I$12:I$65536+J$12:J$65536","v":358190}]
["El Triunfo","Automóvil","Volvo","Mañana","Lima","Alva",2,{"$f":"VLOOKUP(B13,$A$4:$B$7,2)*7","v":210},{"$f":"(INDIRECT(B13) INDIRECT(C13))*G13","v":68000},{"$f":"I13*19%","v":12920},80920]
["El Triunfo","Omnibus","Hyundai","Mañana","Provincias","Alva",5,350,{"$f":"(INDIRECT(B14) INDIRECT(C14))*G14","v":195000},37050,232050]
["El Triunfo","Camioneta","Ford","Tarde","Lima","Cueva",6,245,{"$f":"(INDIRECT(B15) INDIRECT(C15))*G15","v":120000},22800,142800]
["La Estrella","Camión","Volvo","Tarde","Provincias","Robles",8,490,{"$f":"(INDIRECT(B16) INDIRECT(C16))*G16","v":408000},77520,485520]
["El Triunfo","Automóvil","Hyundai","Tarde","Lima","Jara",8,210,{"$f":"(INDIRECT(B17) INDIRECT(C17))*G17","v":72000},13680,85680]
["La Estrella","Omnibus","Ford","Mañana","Lima","Cueva",3,350,{"$f":"(INDIRECT(B18) INDIRECT(C18))*G18","v":126000},23940,149940]
["La Estrella","Camioneta","Volvo","Tarde","Provincias","Alva",7,245,{"$f":"(INDIRECT(B19) INDIRECT(C19))*G19","v":161000},30590,191590]
["La Estrella","Camión","Hyundai","Mañana","Lima","Alva",1,490,{"$f":"(INDIRECT(B20) INDIRECT(C20))*G20","v":35000},6650,41650]
["El Triunfo","Automóvil","Ford","Mañana","Provincias","Cueva",4,210,{"$f":"(INDIRECT(B21) INDIRECT(C21))*G21","v":56000},10640,66640]
["La Estrella","Omnibus","Volvo","Tarde","Lima","Robles",6,350,{"$f":"(INDIRECT(B22) INDIRECT(C22))*G22","v":270000},51300,321300]
["El Triunfo","Camioneta","Hyundai","Tarde","Lima","Jara",3,245,{"$f":"(INDIRECT(B23) INDIRECT(C23))*G23","v":54000},10260,64260]
["El Triunfo","Camión","Ford","Mañana","Provincias","Jara",9,490,{"$f":"(INDIRECT(B24) INDIRECT(C24))*G24","v":387000},73530,460530]
["La Estrella","Automóvil","Volvo","Tarde","Lima","Alva",6,210,{"$f":"(INDIRECT(B25) INDIRECT(C25))*G25","v":204000},38760,242760]
["El Triunfo","Omnibus","Hyundai","Tarde","Provincias","Cueva",1,350,{"$f":"(INDIRECT(B26) INDIRECT(C26))*G26","v":39000},7410,46410]
["El Triunfo","Camioneta","Ford","Mañana","Lima","Cueva",8,245,{"$f":"(INDIRECT(B27) INDIRECT(C27))*G27","v":160000},30400,190400]
["La Estrella","Camión","Volvo","Mañana","Lima","Robles",4,490,{"$f":"(INDIRECT(B28) INDIRECT(C28))*G28","v":204000},38760,242760]
["La Estrella","Automóvil","Hyundai","Tarde","Provincias","Jara",7,210,{"$f":"(INDIRECT(B29) INDIRECT(C29))*G29","v":63000},11970,74970]
["El Triunfo","Omnibus","Ford","Tarde","Lima","Robles",5,350,{"$f":"(INDIRECT(B30) INDIRECT(C30))*G30","v":210000},39900,249900]
["La Estrella","Camioneta","Volvo","Tarde","Provincias","Robles",3,245,{"$f":"(INDIRECT(B31) INDIRECT(C31))*G31","v":69000},13110,82110]
["El Triunfo","Camión","Hyundai","Mañana","Lima","Alva",1,490,{"$f":"(INDIRECT(B32) INDIRECT(C32))*G32","v":35000},6650,41650]
["El Triunfo","Automóvil","Ford","Tarde","Lima","Cueva",9,210,{"$f":"(INDIRECT(B33) INDIRECT(C33))*G33","v":126000},23940,149940]
["La Estrella","Omnibus","Volvo","Mañana","Provincias","Robles",7,350,{"$f":"(INDIRECT(B34) INDIRECT(C34))*G34","v":315000},59850,374850]
["El Triunfo","Camioneta","Hyundai","Mañana","Lima","Jara",8,245,{"$f":"(INDIRECT(B35) INDIRECT(C35))*G35","v":144000},27360,171360]
["La Estrella","Camión","Ford","Tarde","Provincias","Robles",6,490,{"$f":"(INDIRECT(B36) INDIRECT(C36))*G36","v":258000},49020,307020]
["El Triunfo","Automóvil","Volvo","Tarde","Lima","Alva",5,210,{"$f":"(INDIRECT(B37) INDIRECT(C37))*G37","v":170000},32300,202300]
["El Triunfo","Omnibus","Hyundai","Mañana","Lima","Alva",5,350,{"$f":"(INDIRECT(B38) INDIRECT(C38))*G38","v":195000},37050,232050]
["El Triunfo","Camioneta","Ford","Tarde","Provincias","Cueva",1,245,{"$f":"(INDIRECT(B39) INDIRECT(C39))*G39","v":20000},3800,23800]
["La Estrella","Camión","Volvo","Tarde","Lima","Robles",7,490,{"$f":"(INDIRECT(B40) INDIRECT(C40))*G40","v":357000},67830,424830]
["El Triunfo","Automóvil","Hyundai","Mañana","Provincias","Jara",5,210,{"$f":"(INDIRECT(B41) INDIRECT(C41))*G41","v":45000},8550,53550]
["El Triunfo","Omnibus","Ford","Mañana","Lima","Robles",8,350,{"$f":"(INDIRECT(B42) INDIRECT(C42))*G42","v":336000},63840,399840]
["El Triunfo","Camioneta","Volvo","Tarde","Lima","Robles",4,245,{"$f":"(INDIRECT(B43) INDIRECT(C43))*G43","v":92000},17480,109480]
["La Estrella","Camión","Hyundai","Tarde","Provincias","Alva",5,490,{"$f":"(INDIRECT(B44) INDIRECT(C44))*G44","v":175000},33250,208250]
["La Estrella","Automóvil","Ford","Tarde","Lima","Cueva",6,210,{"$f":"(INDIRECT(B45) INDIRECT(C45))*G45","v":84000},15960,99960]
["El Triunfo","Omnibus","Volvo","Mañana","Provincias","Robles",3,350,{"$f":"(INDIRECT(B46) INDIRECT(C46))*G46","v":135000},25650,160650]
["La Estrella","Camioneta","Hyundai","Tarde","Lima","Jara",3,245,{"$f":"(INDIRECT(B47) INDIRECT(C47))*G47","v":54000},10260,64260]
["El Triunfo","Camión","Ford","Mañana","Lima","Jara",3,490,{"$f":"(INDIRECT(B48) INDIRECT(C48))*G48","v":129000},24510,153510]
["El Triunfo","Automóvil","Volvo","Mañana","Provincias","Alva",5,210,{"$f":"(INDIRECT(B49) INDIRECT(C49))*G49","v":170000},32300,202300]
["La Estrella","Omnibus","Hyundai","Tarde","Lima","Alva",9,350,{"$f":"(INDIRECT(B50) INDIRECT(C50))*G50","v":351000},66690,417690]
["El Triunfo","Camioneta","Ford","Tarde","Provincias","Cueva",8,245,{"$f":"(INDIRECT(B51) INDIRECT(C51))*G51","v":160000},30400,190400]
["La Estrella","Camión","Volvo","Mañana","Lima","Robles",5,490,{"$f":"(INDIRECT(B52) INDIRECT(C52))*G52","v":255000},48450,303450]
["El Triunfo","Automóvil","Hyundai","Tarde","Lima","Jara",5,210,{"$f":"(INDIRECT(B53) INDIRECT(C53))*G53","v":45000},8550,53550]
["El Triunfo","Omnibus","Ford","Tarde","Provincias","Robles",2,350,{"$f":"(INDIRECT(B54) INDIRECT(C54))*G54","v":84000},15960,99960]
["El Triunfo","Camioneta","Volvo","Mañana","Lima","Alva",1,245,{"$f":"(INDIRECT(B55) INDIRECT(C55))*G55","v":23000},4370,27370]
["La Estrella","Camión","Hyundai","Mañana","Provincias","Alva",2,490,{"$f":"(INDIRECT(B56) INDIRECT(C56))*G56","v":70000},13300,83300]
["El Triunfo","Automóvil","Ford","Tarde","Lima","Cueva",2,210,{"$f":"(INDIRECT(B57) INDIRECT(C57))*G57","v":28000},5320,33320]