{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Clientes ","T Dinámica Clientes ","Macro Clientes","Vendedores","T Dinámica Vendedores","Producto","formato factura","Informe"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":2},"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":"Clientes ","index":0,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
[]
["ESTEFANÍA BONILLA R"]
[1010243810]
["ESAU SILVA"]
["12 DE MAYO 2020"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cédula","Nombres","Apellidos","Teléfono","Dirección","e-mail "]
[198382473,"Luisa","Pinzón Nuñez",3108562019,"cll 127#30-1","l.pinzon@yahoo.com "]
[2984801741,"Camilo","Moreno Bravo",3125889032,"crr12 #27a-1","c.moreno@hotmail.com"]
[1283745791,"Felipe","Rodríguez ",3194738475,"crr48#55-20","f.rodriguez@hotmail.com"]
[1823728472,"Julian","Forero Forero",3128457472,"cll45#22-31","j.forero@yahoo.com "]
[1824701202,"Camila","Avila Lopéz",3155482892,"cll5#57-63","c.avila@hotmail.com"]
[1010228310,"Sandra","Arias Bonilla",322349857,"cll27a#15-55","s.arias@hotmail.com"]
[2013948572,"Sofia","Díaz Ovalle",3214785798,"crr7#39-23","s.diaz@hotmail.com"]
[9912340586,"Lucrecia","Sampedro ",3257813747,"crr222#70-31","l.sampedro@hotmail.com"]
[4432189450,"Pilar","Filipo Rivière",3271937491,"cll63#40-22","p.filipo@hotmail.com"]
[7843215830,"Esteban ","Montes Olivo",3159178427,"crr63#24a-14","e.montes@yahoo.com "]

{"sheet":"T Dinámica Clientes ","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,3,6,5],[11,3,18,8]]}
[]
["Nombres","(Todas)"]
["Apellidos","(Todas)"]
[null,null,null,"LA CLAVE PARA DESPROTEGER TODAS LAS HOJAS ES 98765"]
["Etiquetas de fila","Suma de Cédula"]
[322349857,1010228310]
["cll27a#15-55",1010228310]
[3108562019,198382473]
["cll 127#30-1",198382473]
["l.pinzon@yahoo.com ",198382473]
[3125889032,2984801741]
["crr12 #27a-1",2984801741,null,"Al filtrar por el nombre la tabla dinámica arroja los datos de ese cliente, su cédula, dirección, correo y teléfono; igual ocurre con el apellido. También puedo filtrar por el número de celular.       "]
["c.moreno@hotmail.com",2984801741]
[3128457472,1823728472]
["cll45#22-31",1823728472]
["j.forero@yahoo.com ",1823728472]
[3155482892,1824701202]
["cll5#57-63",1824701202]
["c.avila@hotmail.com",1824701202]
[3159178427,7843215830]
["crr63#24a-14",7843215830]
["e.montes@yahoo.com ",7843215830]
[3194738475,1283745791]
["crr48#55-20",1283745791]
["f.rodriguez@hotmail.com",1283745791]
[3214785798,2013948572]
["crr7#39-23",2013948572]
["s.diaz@hotmail.com",2013948572]
[3257813747,9912340586]
["crr222#70-31",9912340586]
["l.sampedro@hotmail.com",9912340586]
[3271937491,4432189450]
["cll63#40-22",4432189450]
["p.filipo@hotmail.com",4432189450]
["Total general",33327282427]

{"sheet":"Macro Clientes","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,2,25,4]]}
[]
[]
[null,"Cédula","Nombre","Apellido","Dirección","Teléfono "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"La Macro realizada contiene la información de los clientes. Automatiza la información por medio de la ejecución de una tabla que prestablece los datos requeridos como la cédula, los nombres y apellidos, la dirección y el teléfono de los clientes.  Con solo teclear Contro+s la tabla se realiza automáticamente o también se puede hacer en la parte de revisar -> macros    -> ver macros  y se elige la que uno necesite. Luego la tabla se genera sola y queda lista para ingresar los datos de los clientes.  "]

{"sheet":"Vendedores","index":3,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cédula","Nombres","Apellidos","Ventas","Mes Venta"]
[null,60295790,"Marta Ines","Ramírez Díaz",{"$f":"7700000-280000","v":7420000},"enero"]
[null,792674111,"Jose Felipe ","Quintero Suarez",6750000,"febrero"]
[null,83947237,"Mariana","Caballero Castro",7700000,"marzo"]
[null,38230723,"Cristian ","Cristancho Pinos",6000000,"abril"]
[null,82739328,"Sofia ","Cepeda Acevedo",8870000,"mayo"]
[null,1010284501,"Juliana ","Forero Rincón",5610000,"junio"]
[null,89489724,"Camilo ","Cruz Pulido",7780000,"julio"]
[null,48238209,"Luisa ","Ovalle Yaneth",5300000,"agosto"]
[null,32847229,"Valentina ","Moreno Cano",6620000,"septiembre"]
[null,28428231,"Sergio ","Bolivar Torres",6820000,"octubre"]
[null,60295790,"Marta Ines","Ramírez Díaz",{"$f":"7700000-280000","v":7420000},"noviembre"]
[null,792674111,"Jose Felipe ","Quintero Suarez",6750000,"diciembre"]
[null,83947237,"Mariana","Caballero Castro",7700000,"enero"]
[null,38230723,"Cristian ","Cristancho Pinos",6000000,"febrero"]
[null,82739328,"Sofia ","Cepeda Acevedo",8870000,"marzo"]
[null,1010284501,"Juliana ","Forero Rincón",5610000,"abril"]
[null,89489724,"Camilo ","Cruz Pulido",7780000,"mayo"]
[null,48238209,"Luisa ","Ovalle Yaneth",5300000,"junio"]
[null,32847229,"Valentina ","Moreno Cano",6620000,"julio"]
[null,28428231,"Sergio ","Bolivar Torres",6820000,"agosto"]
[null,60295790,"Marta Ines","Ramírez Díaz",{"$f":"7700000-280000","v":7420000},"septiembre"]
[null,792674111,"Jose Felipe ","Quintero Suarez",6750000,"octubre"]
[null,83947237,"Mariana","Caballero Castro",7700000,"noviembre"]
[null,38230723,"Cristian ","Cristancho Pinos",6000000,"diciembre"]
[null,82739328,"Sofia ","Cepeda Acevedo",8870000,"enero"]
[null,1010284501,"Juliana ","Forero Rincón",5610000,"febrero"]
[null,89489724,"Camilo ","Cruz Pulido",7780000,"marzo"]
[null,48238209,"Luisa ","Ovalle Yaneth",5300000,"abril"]
[null,32847229,"Valentina ","Moreno Cano",6620000,"mayo"]
[null,28428231,"Sergio ","Bolivar Torres",6820000,"junio"]

{"sheet":"T Dinámica Vendedores","index":4,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,3,11,7]]}
[]
["Mes Venta","(Todas)"]
["Cédula","(Todas)"]
[]
["Etiquetas de fila","Suma de Ventas"]
["Camilo ",23340000]
["Cruz Pulido",23340000]
["Cristian ",18000000,null," Al aplicar los filtros por mes de ventas y/o cédula puedo encontrar los datos de los vendedores con nombres y apellidos y el total de ventas que realizaron en el año  "]
["Cristancho Pinos",18000000]
["Jose Felipe ",20250000]
["Quintero Suarez",20250000]
["Juliana ",16830000]
["Forero Rincón",16830000]
["Luisa ",15900000]
["Ovalle Yaneth",15900000]
["Mariana",23100000]
["Caballero Castro",23100000]
["Marta Ines",22260000]
["Ramírez Díaz",22260000]
["Sergio ",20460000]
["Bolivar Torres",20460000]
["Sofia ",26610000]
["Cepeda Acevedo",26610000]
["Valentina ",19860000]
["Moreno Cano",19860000]
["Total general",206610000]

{"sheet":"Producto","index":5,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Código","NOMBRE DEL PRODUCTO","VALOR UNI.","N° Ventas ","Valor ventas"]
["LAC.10001","LECHE ENTERA 1L.",2000,8743,{"$f":"C15*D15","v":17486000}]
["LAC. 10002","LECHE DESCREMADA 1.L",2500,8193,{"$f":"C16*D16","v":20482500}]
["LAC.10003","QUESO DOBLE CREMA",4500,6000,27000000]
["LAC. 10004","QUESO MOZARELLA ",5500,5970,32835000]
["LAC. 10005","QUESO PAIPA",4700,6028,28331600]
["LAC. 10006","QUESO CAMPESINO",4300,6390,27477000]
["LAC. 10007","YOGURT FRESA       200ML",2000,6190,12380000]
["LAC. 10008","YOGURT MORA        200ML",2000,5634,11268000]
["LAC. 10009","YOGURT MELOCOTÓN  200ML",2300,5789,13314700]
["LAC. 10010","KUMIS  200ML",2700,5973,16127100]

{"sheet":"formato factura","index":6,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,4,34,5],[35,4,35,5],[36,4,36,5],[31,2,31,3],[32,2,32,3],[33,2,33,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[17,5,17,6],[21,5,21,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[17,2,17,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[21,2,21,3],[26,2,26,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Fecha","2020-04-28",null,"Fac No. ",525970]
[null,"Nombre",{"$f":"CONCATENATE(VLOOKUP(C20,Clientes,2,FALSE),\" \",(VLOOKUP(C20,Clientes,3,FALSE)))","v":"Sandra Arias Bonilla"}]
[null,"Cédula ",1010228310]
[null,"Teléfono",{"$f":"VLOOKUP(C20, Clientes,4,FALSE)","v":322349857}]
[null,"Vendedor ",{"$f":"CONCATENATE(VLOOKUP(F22,VENDEDORES,2,FALSE),\" \",(VLOOKUP(F22,VENDEDORES,3,FALSE)))","v":"Cristian  Cristancho Pinos"},null,"C.C. ",38230723]
[]
[null,"ID. Producto","Descripción ",null,"Valor Unit.","Cantidad ","Total "]
[null,"LAC.10001",{"$f":"IFERROR(VLOOKUP(B25,PRODUCTO,2,FALSE),\"\")","v":"LECHE ENTERA 1L."},null,{"$f":"INT(VLOOKUP(B25,PRODUCTO,3))","v":2700},130,{"$f":"IFERROR(E25*F25,\"\")","v":351000}]
[null,"LAC. 10007","YOGURT FRESA       200ML",null,{"$f":"VLOOKUP(B26,PRODUCTO,3)","v":2000},50,{"$f":"IFERROR(E26*F26,\"\")","v":100000}]
[null,"LAC.10003","QUESO DOBLE CREMA",null,2700,110,297000]
[null,"LAC. 10002",{"$f":"IFERROR(VLOOKUP(B28,PRODUCTO,2,FALSE),\"\")","v":"LECHE DESCREMADA 1.L"},null,2500,85,212500]
[null,"LAC. 10005",{"$f":"IFERROR(VLOOKUP(B29,PRODUCTO,2,FALSE),\"\")","v":"QUESO PAIPA"},null,4700,50,235000]
[null,"LAC. 10004","QUESO MOZARELLA ",null,2500,55,137500]
[null,"LAC. 10006",{"$f":"IFERROR(VLOOKUP(B31,PRODUCTO,2,FALSE),\"\")","v":"QUESO CAMPESINO"},null,4300,60,258000]
[null,"LAC. 10008","YOGURT MORA        200ML",null,2000,65,130000]
[null,"LAC. 10009","YOGURT MELOCOTÓN  200ML",null,2300,65,149500]
[null,"LAC. 10010","KUMIS  200ML",null,2700,50,135000]
[null,null,null,null,"Subtotal",null,{"$f":"SUM(G25:G34)","v":2005500}]
[null,null,null,null,"IVA 19%",null,{"$f":"G35*19%","v":381045}]
[null,null,null,null,"Total ",null,{"$f":"SUM(G35:G36)","v":2386545}]

{"sheet":"Informe","index":7,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[9,17,9,22],[11,18,11,20],[12,18,12,20],[13,18,13,20],[14,18,14,20],[10,18,10,20],[10,21,10,22],[11,21,11,22],[12,21,12,22],[13,21,13,22],[14,21,14,22],[20,11,20,12],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[11,13,11,14],[12,13,12,14],[11,11,11,12],[12,11,12,12],[13,11,13,12],[8,0,8,6],[10,1,10,2],[10,9,10,10],[10,11,10,12],[10,13,10,14],[9,9,9,14],[19,13,19,14],[20,13,20,14],[21,13,21,14],[21,11,21,12],[13,13,13,14],[14,13,14,14],[15,13,15,14],[16,13,16,14],[17,13,17,14],[18,13,18,14],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
["INFORME VENTAS ANUAL 2019"]
[null,null,null,null,null,null,null,null,null,"INFORME VENDEDORES 2019",null,null,null,null,null,null,null,"INFORME   PRODUCTO    MAYOR    DEMANDA    2019"]
[null,"VENTAS ",null,null,null,null,null,null,null,"ID Vendedores ",null,"Nombres Apellidos ",null,"Ventas ",null,null,null,"Código ","Producto ",null,null,"Ventas"]
[null,"MES ","TOTALES ",null,null,null,null,null,null,60295790,null,{"$f":"CONCATENATE(VLOOKUP(J12,VENDEDORES,2,FALSE), \" \", VLOOKUP(J12,VENDEDORES,3,FALSE))","v":"Marta Ines Ramírez Díaz"},null,{"$f":"SUMIF(cc_vendedores,J12, mes_ventas)","v":22260000},null,null,null,"LAC.10001",{"$f":"VLOOKUP(R12,PRODUCTO,2,FALSE)","v":"LECHE ENTERA 1L."},null,null,{"$f":"Producto!E15","v":17486000}]
[null,"Enero ",{"$f":"Vendedores!E14+Vendedores!E26+Vendedores!E38","v":23990000},null,null,null,null,null,null,792674111,null,"Jose Felipe  Quintero Suarez",null,{"$f":"SUMIF(cc_vendedores,J13, mes_ventas)","v":20250000},null,null,null,"LAC. 10005",{"$f":"VLOOKUP(R13,PRODUCTO,2,FALSE)","v":"QUESO PAIPA"},null,null,{"$f":"Producto!E19","v":28331600}]
[null,"Febrero ",{"$f":"Vendedores!E15+Vendedores!E27+Vendedores!E39","v":18360000},null,null,null,null,null,null,83947237,null,"Mariana Caballero Castro",null,23100000,null,null,null,"LAC. 10006",{"$f":"VLOOKUP(R14,PRODUCTO,2,FALSE)","v":"QUESO CAMPESINO"},null,null,{"$f":"Producto!E20","v":27477000}]
[null,"Marzo",{"$f":"Vendedores!E16+Vendedores!E28+Vendedores!E40","v":24350000},null,null,null,null,null,null,38230723,null,"Cristian  Cristancho Pinos",null,18000000,null,null,null,"LAC. 10007",{"$f":"VLOOKUP(R15,PRODUCTO,2,FALSE)","v":"YOGURT FRESA       200ML"},null,null,{"$f":"Producto!E21","v":12380000}]
[null,"Abril",{"$f":"Vendedores!E17+Vendedores!E29+Vendedores!E41","v":16910000},null,null,null,null,null,null,82739328,null,"Sofia  Cepeda Acevedo",null,26610000]
[null,"Mayo",{"$f":"Vendedores!E18+Vendedores!E30+Vendedores!E42","v":23270000},null,null,null,null,null,null,1010284501,null,"Juliana  Forero Rincón",null,16830000]
[null,"Junio",{"$f":"Vendedores!E19+Vendedores!E31+Vendedores!E43","v":17730000},null,null,null,null,null,null,89489724,null,"Camilo  Cruz Pulido",null,23340000]
[null,"Julio",{"$f":"Vendedores!E20+Vendedores!E32","v":14400000},null,null,null,null,null,null,48238209,null,"Luisa  Ovalle Yaneth",null,15900000]
[null,"Agosto",{"$f":"Vendedores!E21+Vendedores!E33","v":12120000},null,null,null,null,null,null,32847229,null,"Valentina  Moreno Cano",null,19860000]
[null,"Septiembre",{"$f":"Vendedores!E22+Vendedores!E34","v":14040000},null,null,null,null,null,null,28428231,null,"Sergio  Bolivar Torres",null,20460000]
[null,"Octubre",{"$f":"Vendedores!E23+Vendedores!E35+Vendedores!E47","v":13570000},null,null,null,null,null,null,null,null,"TOTAL ",null,{"$f":"SUM(N12:O21)","v":206610000}]
[null,"Noviembre",{"$f":"Vendedores!E24+Vendedores!E36+Vendedores!E48","v":15120000}]
[null,"Diciembre",{"$f":"Vendedores!E25+Vendedores!E37+Vendedores!E49","v":12750000}]
[null,"Total ",{"$f":"SUM(C13:C24)","v":206610000}]