{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Presentación","datos","Ejercicio 1","Ejercicio 2","Ejercicio 3"],"not_rendered":{"charts":0,"images":0,"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":"Presentación","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[null,null,"Mi hypervinculo"]
[]
[null,null,"Ejercicio 1"]
[null,"Datos:","Lista de inscripciones y notas"]
[]
[null,1,"Armar una tabla dinamica mostrando el numero de personas por empresa y por día"]
[null,2,"Ordenar la tabla por orden alfabetico de empresa"]
[null,3,"Expresar los resultados en porcentaje referentes a todas las inscripciones, a las inscripciones por el día, a las inscripciones para la empresa"]
[null,4,"Obtener una lista de las personas del jueves. De las personas de GyM el miercoles"]
[null,null,"¿Que pasa si una persona cambia de día?"]
[null,5,"cambiar la tabla para mostrar el promedio de notas por empresa y día"]
[null,6,"Usar el concepto de pagina para una tabla dinamica que muestra las notas por empresa (Pagina) y persona y tema"]
[null,7,"Obtener los promedios por persona, por empresa por los dos temas"]
[null,8,"Crear un campo con el promedio de las dos notas"]
[null,null," En el campo gran total, se ve la suma del campo calculado (y no el promedio) ¿Cual podria  ser la solución para tener el promedio total incluyendo los dos tema y todos los participantes?"]
[]
[null,null,"Ejercicio 2"]
[null,"Datos","lista de personas"]
[null,null,"lista de material"]
[null,null,"lista de pedidos"]
[]
[null,1,"Completar la tabla de los pedidos ayudandose de la lista de personas y de la lista de material (función BUSCAR,LOOKUP). Para simplificar tu trabajo definir nombres para los diferentes campos de datos."]
[null,null,"¿Esta correcta la tabla? ¿Que pasó con los post-it 5x8?"]
[null,2,"Armar una tabla dinamica mostrando de  montos de los pedidos por empresa y por articulo"]
[null,3,"Modificar la tabla par ver la repartición de gastos en %"]
[null,4,"Modificar la tabla para ver las cantidades"]
[null,null,"¿Quiénes pidieron disket en la unidad D?"]
[null,5,"Agrupar los post-it en una clase y llamarla \"Post-it\""]
[null,6,"Hacer doble clic sobre la casilla \"Post-it\", ¿que pasa?"]
[null,7,"Modificar la tabla para tener como parametos verticales las unidades, y horizontalmente los meses.visualiza los datos como \"% del total\", como \"diferencia del primer mes\", como \"% de diferencia del primer mes\""]
[null,8,"Modificar la tabla para tener como parametos verticales las unidades y los funciones, y horizontalmente los meses y los articulos"]

{"sheet":"datos","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Regreso a la lista de tareas"]
[]
[null,"Vendedor","Sucursal",null,null,"Código","Artículo","Unidad","P. Unit."]
[null,"Josué","Lima",null,null,"D1-001","CD-R Sony 700 MB","Caja x 10",2.5]
[null,"Elías","Lima",null,null,"L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3]
[null,"Daniel","Miraflores",null,null,"P1-001","Post-it 5X5","Bolsa x 10",12]
[null,"Alberto","Miraflores",null,null,"P2-001","Post-it 5X8","Bolsa x 10",15]
[null,"Fabián","Surco",null,null,"P3-001","Post-it 3X3","Bolsa x 10",10]
[null,"Piero","Surco",null,null,"S1-001","Sobre Manila A4","Ciento",25]

{"sheet":"Ejercicio 1","index":2,"n_rows":185,"n_cols":12,"rows_kept":185,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Nº Pedido","Fecha","Mes","Sucursal","Vendedor","Código","Artículo","Unidad","Precio Unitario","Cantidad","Ventas","Comisión"]
[3,"2013-07-18",{"$f":"B10","v":"2013-07-18"},"Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,50,{"$f":"I10*J10","v":1250},{"$f":"IF(J10>=30,K10*4%,K10*3%)","v":50}]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,50,1250,50]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,50,1250,50]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,70,1050,42]
[8,"2013-09-06","2013-09-06","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[24,"2013-02-13","2013-02-13","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[25,"2013-02-23","2013-02-23","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[26,"2013-03-05","2013-03-05","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,60,900,36]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,60,900,36]
[4,"2013-07-28","2013-07-28","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[5,"2013-08-07","2013-08-07","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[7,"2013-08-27","2013-08-27","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[21,"2013-01-14","2013-01-14","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,50,750,30]
[21,"2013-01-14","2013-01-14","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[3,"2013-07-18","2013-07-18","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[4,"2013-07-28","2013-07-28","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[8,"2013-09-06","2013-09-06","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[23,"2013-02-03","2013-02-03","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[25,"2013-02-23","2013-02-23","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[26,"2013-02-02","2013-02-02","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[7,"2013-08-27",{"$f":"B42","v":"2013-08-27"},"Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,55,{"$f":"I42*J42","v":550},{"$f":"IF(J42>=30,K42*4%,K42*3%)","v":22}]
[7,"2013-08-27","2013-08-27","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,45,540,21.6]
[3,"2013-07-18","2013-07-18","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,50,500,20]
[6,"2013-08-17","2013-08-17","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[19,"2013-12-25","2013-12-25","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[22,"2013-01-24","2013-01-24","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[23,"2013-02-03","2013-02-03","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[27,"2013-03-14","2013-03-14","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[29,"2013-04-03","2013-04-03","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[30,"2013-04-13","2013-04-13","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[5,"2013-08-07","2013-08-07","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[21,"2013-01-14","2013-01-14","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[30,"2013-04-13","2013-04-13","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[6,"2013-08-17","2013-08-17","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[24,"2013-02-13","2013-02-13","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[27,"2013-03-14","2013-03-14","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[8,"2013-09-06","2013-09-06","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[25,"2013-02-23","2013-02-23","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[26,"2013-03-05","2013-03-05","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[1,"2013-06-28","2013-06-28","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[2,"2013-07-08","2013-07-08","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[3,"2013-07-18","2013-07-18","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[4,"2013-07-28","2013-07-28","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[6,"2013-08-17","2013-08-17","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[23,"2013-02-03",{"$f":"B74","v":"2013-02-03"},"Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,30,{"$f":"I74*J74","v":360},{"$f":"IF(J74>=30,K74*4%,K74*3%)","v":14.4}]
[28,"2013-03-24","2013-03-24","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[1,"2013-06-28","2013-06-28","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[1,"2013-06-28","2013-06-28","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[2,"2013-07-08","2013-07-08","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[5,"2013-08-07","2013-08-07","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[5,"2013-08-07","2013-08-07","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[7,"2013-08-27","2013-08-27","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[8,"2013-09-06","2013-09-06","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[19,"2013-12-25","2013-12-25","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[21,"2013-01-14","2013-01-14","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[24,"2013-02-13","2013-02-13","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[27,"2013-03-14","2013-03-14","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[29,"2013-04-03","2013-04-03","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[30,"2013-04-13","2013-04-13","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[30,"2013-04-13","2013-04-13","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[1,"2013-06-28","2013-06-28","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[2,"2013-07-08","2013-07-08","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[28,"2013-03-24","2013-03-24","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,20,240,7.1999999999999993]
[24,"2013-02-13","2013-02-13","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,20,240,7.1999999999999993]
[27,"2013-03-14","2013-03-14","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,20,240,7.1999999999999993]
[2,"2013-07-08","2013-07-08","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[4,"2013-07-28","2013-07-28","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[6,"2013-08-17","2013-08-17","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[11,"2013-10-06",{"$f":"B106","v":"2013-10-06"},"Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,20,{"$f":"I106*J106","v":200},{"$f":"IF(J106>=30,K106*4%,K106*3%)","v":6}]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[22,"2013-01-24","2013-01-24","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[23,"2013-02-03","2013-02-03","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[28,"2013-03-24","2013-03-24","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[20,"2014-01-04","2014-01-04","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[22,"2013-01-24","2013-01-24","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[25,"2013-02-23","2013-02-23","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[26,"2013-03-05","2013-03-05","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[28,"2013-03-24","2013-03-24","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[3,"2013-07-18","2013-07-18","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[19,"2013-12-25","2013-12-25","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[20,"2014-01-04","2014-01-04","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[22,"2013-01-24","2013-01-24","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[24,"2013-02-13","2013-02-13","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[29,"2013-04-03","2013-04-03","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[2,"2013-07-08","2013-07-08","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[7,"2013-08-27","2013-08-27","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[19,"2013-12-25","2013-12-25","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,10,100,3]
[20,"2014-01-04","2014-01-04","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,10,100,3]
[23,"2013-02-03","2013-02-03","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[28,"2013-03-24","2013-03-24","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[29,"2013-04-03","2013-04-03","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,10,100,3]
[1,"2013-06-28","2013-06-28","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[2,"2013-07-08","2013-07-08","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[4,"2013-07-28",{"$f":"B138","v":"2013-07-28"},"Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,{"$f":"I138*J138","v":90},{"$f":"IF(J138>=30,K138*4%,K138*3%)","v":3.6}]
[5,"2013-08-07","2013-08-07","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[7,"2013-08-27","2013-08-27","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[8,"2013-09-06","2013-09-06","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[21,"2013-01-14","2013-01-14","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[22,"2013-01-24","2013-01-24","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[23,"2013-02-03","2013-02-03","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[25,"2013-02-23","2013-02-23","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[26,"2013-03-05","2013-03-05","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[28,"2013-03-24","2013-03-24","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[3,"2013-07-18","2013-07-18","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[21,"2013-01-14","2013-01-14","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[24,"2013-02-13","2013-02-13","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[27,"2013-03-14","2013-03-14","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[30,"2013-04-13","2013-04-13","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[6,"2013-08-17","2013-08-17","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[27,"2013-03-14","2013-03-14","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[30,"2013-04-13","2013-04-13","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[1,"2013-06-28","2013-06-28","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[4,"2013-07-28","2013-07-28","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[5,"2013-08-07","2013-08-07","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[6,"2013-08-17","2013-08-17","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[8,"2013-09-06",{"$f":"B170","v":"2013-09-06"},"Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,{"$f":"I170*J170","v":50},{"$f":"IF(J170>=30,K170*4%,K170*3%)","v":1.5}]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[22,"2013-01-24","2013-01-24","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[25,"2013-02-23","2013-02-23","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[26,"2013-03-05","2013-03-05","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[19,"2013-12-25","2013-12-25","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,10,30,0.89999999999999991]
[20,"2014-01-04","2014-01-04","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,10,30,0.89999999999999991]
[29,"2013-04-03","2013-04-03","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,10,30,0.89999999999999991]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[19,"2013-12-25","2013-12-25","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[20,"2014-01-04","2014-01-04","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[29,"2013-04-03","2013-04-03","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]

{"sheet":"Ejercicio 2","index":3,"n_rows":185,"n_cols":12,"rows_kept":185,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Nº Pedido","Fecha","Mes","Sucursal","Vendedor","Código","Artículo","Unidad","Precio Unitario","Cantidad","Ventas","Comisión"]
[1,"2013-06-28",{"$f":"B10","v":"2013-06-28"},"Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,{"$f":"I10*J10","v":50},{"$f":"IF(J10>=30,K10*4%,K10*3%)","v":1.5}]
[1,"2013-06-28","2013-06-28","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[1,"2013-06-28","2013-06-28","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[1,"2013-06-28","2013-06-28","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[1,"2013-06-28","2013-06-28","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[1,"2013-06-28","2013-06-28","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[2,"2013-07-08","2013-07-08","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[2,"2013-07-08","2013-07-08","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[2,"2013-07-08","2013-07-08","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[2,"2013-07-08","2013-07-08","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[2,"2013-07-08","2013-07-08","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[2,"2013-07-08","2013-07-08","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[3,"2013-07-18","2013-07-18","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[3,"2013-07-18","2013-07-18","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[3,"2013-07-18","2013-07-18","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[3,"2013-07-18","2013-07-18","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[3,"2013-07-18","2013-07-18","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,50,500,20]
[3,"2013-07-18","2013-07-18","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,50,1250,50]
[4,"2013-07-28","2013-07-28","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[4,"2013-07-28","2013-07-28","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[4,"2013-07-28","2013-07-28","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[4,"2013-07-28","2013-07-28","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[4,"2013-07-28","2013-07-28","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[4,"2013-07-28","2013-07-28","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[5,"2013-08-07","2013-08-07","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[5,"2013-08-07","2013-08-07","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[5,"2013-08-07","2013-08-07","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[5,"2013-08-07","2013-08-07","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[5,"2013-08-07","2013-08-07","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[5,"2013-08-07","2013-08-07","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[6,"2013-08-17","2013-08-17","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[6,"2013-08-17","2013-08-17","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[6,"2013-08-17",{"$f":"B42","v":"2013-08-17"},"Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,30,{"$f":"I42*J42","v":360},{"$f":"IF(J42>=30,K42*4%,K42*3%)","v":14.4}]
[6,"2013-08-17","2013-08-17","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[6,"2013-08-17","2013-08-17","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[6,"2013-08-17","2013-08-17","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[7,"2013-08-27","2013-08-27","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[7,"2013-08-27","2013-08-27","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[7,"2013-08-27","2013-08-27","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,45,540,21.6]
[7,"2013-08-27","2013-08-27","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[7,"2013-08-27","2013-08-27","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,55,550,22]
[7,"2013-08-27","2013-08-27","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[8,"2013-09-06","2013-09-06","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[8,"2013-09-06","2013-09-06","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[8,"2013-09-06","2013-09-06","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[8,"2013-09-06","2013-09-06","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[8,"2013-09-06","2013-09-06","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[8,"2013-09-06","2013-09-06","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[11,"2013-10-06",{"$f":"B74","v":"2013-10-06"},"Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,20,{"$f":"I74*J74","v":200},{"$f":"IF(J74>=30,K74*4%,K74*3%)","v":6}]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,60,900,36]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,70,1050,42]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,50,1250,50]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,20,240,7.1999999999999993]
[17,"2013-12-05",{"$f":"B106","v":"2013-12-05"},"Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,30,{"$f":"I106*J106","v":450},{"$f":"IF(J106>=30,K106*4%,K106*3%)","v":18}]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,50,1250,50]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,60,900,36]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[19,"2013-12-25","2013-12-25","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[19,"2013-12-25","2013-12-25","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,10,30,0.89999999999999991]
[19,"2013-12-25","2013-12-25","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[19,"2013-12-25","2013-12-25","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[19,"2013-12-25","2013-12-25","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,10,100,3]
[19,"2013-12-25","2013-12-25","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[20,"2014-01-04","2014-01-04","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[20,"2014-01-04","2014-01-04","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,10,30,0.89999999999999991]
[20,"2014-01-04","2014-01-04","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[20,"2014-01-04","2014-01-04","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[20,"2014-01-04","2014-01-04","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,10,100,3]
[21,"2013-01-14","2013-01-14","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[21,"2013-01-14","2013-01-14","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[21,"2013-01-14","2013-01-14","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[21,"2013-01-14","2013-01-14","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,50,750,30]
[21,"2013-01-14","2013-01-14","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[21,"2013-01-14","2013-01-14","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[22,"2013-01-24","2013-01-24","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[22,"2013-01-24","2013-01-24","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[22,"2013-01-24","2013-01-24","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[22,"2013-01-24","2013-01-24","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[22,"2013-01-24","2013-01-24","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[22,"2013-01-24","2013-01-24","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[23,"2013-02-03",{"$f":"B138","v":"2013-02-03"},"Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,{"$f":"I138*J138","v":100},{"$f":"IF(J138>=30,K138*4%,K138*3%)","v":4}]
[23,"2013-02-03","2013-02-03","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[23,"2013-02-03","2013-02-03","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[23,"2013-02-03","2013-02-03","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[23,"2013-02-03","2013-02-03","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[23,"2013-02-03","2013-02-03","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[24,"2013-02-13","2013-02-13","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[24,"2013-02-13","2013-02-13","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[24,"2013-02-13","2013-02-13","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,20,240,7.1999999999999993]
[24,"2013-02-13","2013-02-13","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[24,"2013-02-13","2013-02-13","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[24,"2013-02-13","2013-02-13","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[25,"2013-02-23","2013-02-23","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[25,"2013-02-23","2013-02-23","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[25,"2013-02-23","2013-02-23","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[25,"2013-02-23","2013-02-23","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[25,"2013-02-23","2013-02-23","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[25,"2013-02-23","2013-02-23","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[26,"2013-03-05","2013-03-05","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[26,"2013-03-05","2013-03-05","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[26,"2013-02-02","2013-02-02","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[26,"2013-03-05","2013-03-05","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[26,"2013-03-05","2013-03-05","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[26,"2013-03-05","2013-03-05","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[27,"2013-03-14","2013-03-14","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[27,"2013-03-14","2013-03-14","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[27,"2013-03-14","2013-03-14","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,20,240,7.1999999999999993]
[27,"2013-03-14","2013-03-14","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[27,"2013-03-14","2013-03-14","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[27,"2013-03-14","2013-03-14","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[28,"2013-03-24","2013-03-24","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[28,"2013-03-24","2013-03-24","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[28,"2013-03-24",{"$f":"B170","v":"2013-03-24"},"Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,30,{"$f":"I170*J170","v":360},{"$f":"IF(J170>=30,K170*4%,K170*3%)","v":14.4}]
[28,"2013-03-24","2013-03-24","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[28,"2013-03-24","2013-03-24","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[28,"2013-03-24","2013-03-24","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[29,"2013-04-03","2013-04-03","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[29,"2013-04-03","2013-04-03","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,10,30,0.89999999999999991]
[29,"2013-04-03","2013-04-03","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[29,"2013-04-03","2013-04-03","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[29,"2013-04-03","2013-04-03","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,10,100,3]
[29,"2013-04-03","2013-04-03","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[30,"2013-04-13","2013-04-13","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[30,"2013-04-13","2013-04-13","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[30,"2013-04-13","2013-04-13","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[30,"2013-04-13","2013-04-13","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[30,"2013-04-13","2013-04-13","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[30,"2013-04-13","2013-04-13","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,20,500,15]

{"sheet":"Ejercicio 3","index":4,"n_rows":185,"n_cols":12,"rows_kept":185,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Nº Pedido","Fecha","Mes","Sucursal","Vendedor","Código","Artículo","Unidad","Precio Unitario","Cantidad","Ventas","Comisión"]
[21,"2013-01-14",{"$f":"B10","v":"2013-01-14"},"Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,50,{"$f":"I10*J10","v":750},{"$f":"IF(J10>=30,K10*4%,K10*3%)","v":30}]
[21,"2013-01-14","2013-01-14","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[21,"2013-01-14","2013-01-14","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[21,"2013-01-14","2013-01-14","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[21,"2013-01-14","2013-01-14","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[21,"2013-01-14","2013-01-14","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[22,"2013-01-24","2013-01-24","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[22,"2013-01-24","2013-01-24","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[22,"2013-01-24","2013-01-24","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[22,"2013-01-24","2013-01-24","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[22,"2013-01-24","2013-01-24","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[22,"2013-01-24","2013-01-24","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[26,"2013-02-02","2013-02-02","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[23,"2013-02-03","2013-02-03","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[23,"2013-02-03","2013-02-03","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[23,"2013-02-03","2013-02-03","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[23,"2013-02-03","2013-02-03","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[23,"2013-02-03","2013-02-03","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[23,"2013-02-03","2013-02-03","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[24,"2013-02-13","2013-02-13","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[24,"2013-02-13","2013-02-13","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[24,"2013-02-13","2013-02-13","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[24,"2013-02-13","2013-02-13","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[24,"2013-02-13","2013-02-13","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[24,"2013-02-13","2013-02-13","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,20,240,7.1999999999999993]
[25,"2013-02-23","2013-02-23","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[25,"2013-02-23","2013-02-23","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[25,"2013-02-23","2013-02-23","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[25,"2013-02-23","2013-02-23","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[25,"2013-02-23","2013-02-23","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[25,"2013-02-23","2013-02-23","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[26,"2013-03-05","2013-03-05","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[26,"2013-03-05","2013-03-05","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[26,"2013-03-05","2013-03-05","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[26,"2013-03-05","2013-03-05","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[26,"2013-03-05","2013-03-05","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[27,"2013-03-14","2013-03-14","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[27,"2013-03-14","2013-03-14","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[27,"2013-03-14","2013-03-14","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[27,"2013-03-14","2013-03-14","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[27,"2013-03-14","2013-03-14","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,20,240,7.1999999999999993]
[27,"2013-03-14","2013-03-14","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[28,"2013-03-24","2013-03-24","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[28,"2013-03-24","2013-03-24","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[28,"2013-03-24","2013-03-24","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[28,"2013-03-24","2013-03-24","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[28,"2013-03-24","2013-03-24","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[28,"2013-03-24","2013-03-24","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[29,"2013-04-03","2013-04-03","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[29,"2013-04-03","2013-04-03","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[29,"2013-04-03","2013-04-03","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[29,"2013-04-03","2013-04-03","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,10,30,0.89999999999999991]
[29,"2013-04-03","2013-04-03","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,10,100,3]
[29,"2013-04-03","2013-04-03","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[30,"2013-04-13","2013-04-13","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[30,"2013-04-13","2013-04-13","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[30,"2013-04-13","2013-04-13","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[30,"2013-04-13","2013-04-13","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[30,"2013-04-13","2013-04-13","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[30,"2013-04-13","2013-04-13","Surco","Fabián","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[1,"2013-06-28","2013-06-28","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[1,"2013-06-28","2013-06-28","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[1,"2013-06-28","2013-06-28","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[1,"2013-06-28","2013-06-28","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[1,"2013-06-28",{"$f":"B74","v":"2013-06-28"},"Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,20,{"$f":"I74*J74","v":300},{"$f":"IF(J74>=30,K74*4%,K74*3%)","v":9}]
[1,"2013-06-28","2013-06-28","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[2,"2013-07-08","2013-07-08","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[2,"2013-07-08","2013-07-08","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[2,"2013-07-08","2013-07-08","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[2,"2013-07-08","2013-07-08","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[2,"2013-07-08","2013-07-08","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[2,"2013-07-08","2013-07-08","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[3,"2013-07-18","2013-07-18","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,50,500,20]
[3,"2013-07-18","2013-07-18","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,50,1250,50]
[3,"2013-07-18","2013-07-18","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[3,"2013-07-18","2013-07-18","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[3,"2013-07-18","2013-07-18","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[3,"2013-07-18","2013-07-18","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[4,"2013-07-28","2013-07-28","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[4,"2013-07-28","2013-07-28","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[4,"2013-07-28","2013-07-28","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[4,"2013-07-28","2013-07-28","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[4,"2013-07-28","2013-07-28","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[4,"2013-07-28","2013-07-28","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[5,"2013-08-07","2013-08-07","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[5,"2013-08-07","2013-08-07","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[5,"2013-08-07","2013-08-07","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[5,"2013-08-07","2013-08-07","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[5,"2013-08-07","2013-08-07","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[5,"2013-08-07","2013-08-07","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[6,"2013-08-17","2013-08-17","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[6,"2013-08-17","2013-08-17","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[6,"2013-08-17","2013-08-17","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[6,"2013-08-17","2013-08-17","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[6,"2013-08-17","2013-08-17","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[6,"2013-08-17","2013-08-17","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[7,"2013-08-27","2013-08-27","Lima","Josué","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,40,100,4]
[7,"2013-08-27","2013-08-27","Lima","Josué","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[7,"2013-08-27","2013-08-27","Lima","Josué","P1-001","Post-it 5X5","Bolsa x 10",12,45,540,21.6]
[7,"2013-08-27","2013-08-27","Lima","Josué","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[7,"2013-08-27","2013-08-27","Lima","Josué","P3-001","Post-it 3X3","Bolsa x 10",10,55,550,22]
[7,"2013-08-27","2013-08-27","Lima","Josué","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[8,"2013-09-06","2013-09-06","Lima","Elías","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[8,"2013-09-06","2013-09-06","Lima","Elías","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[8,"2013-09-06","2013-09-06","Lima","Elías","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[8,"2013-09-06","2013-09-06","Lima","Elías","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[8,"2013-09-06","2013-09-06","Lima","Elías","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[8,"2013-09-06","2013-09-06","Lima","Elías","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[9,"2013-09-16","2013-09-16","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[10,"2013-09-26","2013-09-26","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,40,600,24]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,30,360,14.4]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,30,750,30]
[11,"2013-10-06","2013-10-06","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,60,900,36]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[12,"2013-10-16",{"$f":"B138","v":"2013-10-16"},"Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,40,{"$f":"I138*J138","v":1000},{"$f":"IF(J138>=30,K138*4%,K138*3%)","v":40}]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[12,"2013-10-16","2013-10-16","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[13,"2013-10-26","2013-10-26","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,10,250,7.5]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,40,480,19.2]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[14,"2013-11-05","2013-11-05","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,70,1050,42]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[15,"2013-11-15","2013-11-15","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,20,200,6]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,50,1250,50]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,30,75,3]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,20,60,1.7999999999999998]
[16,"2013-11-25","2013-11-25","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","S1-001","Sobre Manila A4","Ciento",25,50,1250,50]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","P3-001","Post-it 3X3","Bolsa x 10",10,40,400,16]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,30,90,3.6]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","P2-001","Post-it 5X8","Bolsa x 10",15,30,450,18]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[17,"2013-12-05","2013-12-05","Miraflores","Alberto","P1-001","Post-it 5X5","Bolsa x 10",12,20,240,7.1999999999999993]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","P2-001","Post-it 5X8","Bolsa x 10",15,60,900,36]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","P1-001","Post-it 5X5","Bolsa x 10",12,50,600,24]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,40,120,4.8]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","S1-001","Sobre Manila A4","Ciento",25,40,1000,40]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","P3-001","Post-it 3X3","Bolsa x 10",10,30,300,12]
[18,"2013-12-15","2013-12-15","Miraflores","Daniel","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,20,50,1.5]
[19,"2013-12-25","2013-12-25","Surco","Piero","P2-001","Post-it 5X8","Bolsa x 10",15,20,300,9]
[19,"2013-12-25","2013-12-25","Surco","Piero","S1-001","Sobre Manila A4","Ciento",25,20,500,15]
[19,"2013-12-25","2013-12-25","Surco","Piero","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[19,"2013-12-25","2013-12-25","Surco","Piero","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,10,30,0.89999999999999991]
[19,"2013-12-25","2013-12-25","Surco","Piero","P3-001","Post-it 3X3","Bolsa x 10",10,10,100,3]
[19,"2013-12-25","2013-12-25","Surco","Piero","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[20,"2014-01-04","2014-01-04","Surco","Fabián","D1-001","CD-R Sony 700 MB","Caja x 10",2.5,10,25,0.75]
[20,"2014-01-04","2014-01-04","Surco","Fabián","L1-001","Lápiz Nº 2 Faber Castel","Caja x 12",3,10,30,0.89999999999999991]
[20,"2014-01-04","2014-01-04","Surco","Fabián","P3-001","Post-it 3X3","Bolsa x 10",10,10,100,3]
[20,"2014-01-04","2014-01-04","Surco","Fabián","P1-001","Post-it 5X5","Bolsa x 10",12,10,120,3.5999999999999996]
[20,"2014-01-04","2014-01-04","Surco","Fabián","P2-001","Post-it 5X8","Bolsa x 10",15,10,150,4.5]