{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Ayuda","Dashboard","Base de Datos","Tablas dinámicas-Kpis","Desplegables"],"not_rendered":{"charts":13,"images":4,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":9},"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":"Ayuda","index":0,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"PLANTILLA DASHBOARD VENTAS"]
[]
[null,null,"En esta plantilla podrás generar un dashboard de la gestión de ventas de una empresa/institución/sociedad en particular."]
[]
[null,null,"Instrucciones:"]
[]
[null,"1.-","Hoja de \"Base de datos\": Llena los campos de la base de datos por venta realizada. (actualizar al cierre de mes)."]
[]
[null,"2.-","En la hoja \"tablas dinamicas-kpis\", haz clik en \"actualizar\". Debe hacerse este paso en  esta hoja cada vez que se actualiza la base de datos. Nota: Esto actualiza todas las tablas dinámicas que tiene la hoja."]
[]
[null,"3.-","Reporte de la hoja \"dashboard\" se actualizará en automatico. Usa la segmentación de datos o filtro por año para evaluar la gestión."]
[]
[null,"4.-","Listo y configurado para imprimir en un sola hoja."]
[]
[null,null,"Nota:"]
[]
[null,null,".Para cambiar datos en desplegables en los campos de la base de datos, ir a la hoja de \"desplegables\"."]
[null,null,".Para adicionar un KPI, ir a la hoja de \"tablas dinamicas-kpis\" y adiciona un kpis en la tabla, usando los datos de las tablas dinamicas en las fórmulas como se muestra en los ejemplos. Una vez creado, incorporalo en el dashboard siguiendo los siguientes pasos:\n1. Crea un recuadro.\n2. Selecciona el recuadro.\n3. Escribe en fx: = \"y selecciona la celda donde se encuentra el Kpi\"."]
[null,null,".Puedes incorporar otra gráfica en el dashboard. Para ello crea un gráfico usando cualquiera de las tablas dinámicas creadas en la hoja \"Tablas dinámicas-kpis\", copia la gráfica y pegala en el dashboard. Rediseña el dashboard de acuerdo a tus necesidades. Para crear un gráfico sigue los estos pasos en la hoja \"Tablas dinámicas-Kpis\":\n1. Haz click en la tabla dinámica sobre el cual harás la gráfica.\n2. Selecciona \"Analizar tabla dinámica\"\n3. Haz click en \"gráficos dinámicos\" y haz el gráfico que desees."]
[null,null,".Para incorporar una segmentacion de datos (que sirve de filtro para los datos), en la hoja de \"tablas dinamicas-Kpis\", haz click en cualquier tabla dinámica, ir a analizar tabla dinámica y selecciona insertar segmentación de datos. Elige cualquier opción desde la cual quieres realizar filtro en los datos del dashboard. Copia el segmentador e incorporalo en el dashboard. Haz click en el segmentador, luego en segmentación y selecciona conexion con informes para que lo integres con todas las tablas dinamicas creadas."]

{"sheet":"Dashboard","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Base de Datos","index":2,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Nº Operación","Estatus","Fecha","Dia","Mes","Año","Canal de Venta","Producto/Servicio","Cantidad de items","Pago","Tiempo de atención (mins)","Tipo de pago","Satisfacción del cliente","Region/Equipo de Venta","Vendedor","Rendimiento"]
[1,"Cerrado","2018-05-01",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":1},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"mayo"},{"$f":"IF(C2=\"\",\"\",YEAR(C2))","v":2018},"Tienda fisica","A",1,300,10,"Efectivo",8,"Lima","Alejandro",7]
[2,"Cerrado","2019-07-11",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":11},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"julio"},{"$f":"IF(C3=\"\",\"\",YEAR(C3))","v":2019},"Tienda fisica","B",2,200,8,"Tarjeta",7,"Bolivar","Jose",6]
[3,"Cerrado","2019-08-18",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":18},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"agosto"},{"$f":"IF(C4=\"\",\"\",YEAR(C4))","v":2019},"Tienda fisica","C",2,100,13,"Efectivo",6,"Brasilia","Miguel",8]
[4,"Cerrado","2020-04-29",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":29},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"abril"},2020,"Tienda fisica","D",1,585,10,"Efectivo",9,"Bolivar","Jose",8]
[5,"Cerrado","2020-04-30",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":30},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"abril"},2020,"Tienda fisica","E",2,235,10,"Efectivo",10,"Bolivar","Jose",9]
[6,"Cerrado","2020-06-01",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":1},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"junio"},2020,"Tienda fisica","A",1,150,8,"Efectivo",6,"Montevideo","Maria",10]
[7,"Cerrado","2020-07-02",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":2},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"julio"},2020,"Tienda fisica","B",4,1000,10,"Efectivo",7,"Bolivar","Jose",7]
[8,"Cerrado","2020-08-03",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":3},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"agosto"},2020,"Tienda fisica","C",3,200,9,"Efectivo",8,"Bolivar","Jose",8]
[9,"Cerrado","2020-08-04",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":4},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"agosto"},2020,"Web","D",2,150,10,"Transferencia",8,"La Paz","Virginia",9]
[10,"Cerrado","2021-01-05",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":5},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"enero"},2021,"Web","A",2,345,10,"Efectivo",6,"Bolivar","Jose",8]
[11,"Abierto","2021-02-06",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":6},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"febrero"},2021,"Tienda fisica","B",3,200,10,"Transferencia",9,"Montevideo","Maria",7]
[12,"Cancelado","2021-03-07",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":7},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"marzo"},2021,"Tienda fisica","C",4,190,11,null,null,"Bolivar","Jose",10]
[13,"Cerrado","2021-05-08",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":8},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"mayo"},2021,"Tienda fisica","D",5,210,10,"Transferencia",9,"Bolivar","Jose",8]
[14,"Cerrado","2022-01-09",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":9},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"enero"},2022,"Red social","E",6,1000,10,"Transferencia",8,"Brasilia","Miguel",9]
[15,"Cerrado","2022-02-09",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":9},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"febrero"},2022,"Tienda fisica","A",4,800,14,"Transferencia",9,"La Paz","Virginia",7]
[16,"Abierto","2022-04-16",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":16},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"abril"},2022,"Web","B",6,750,10,"Transferencia",8,"Brasilia","Miguel",6]
[17,"Cancelado","2022-06-09",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":9},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"junio"},2022,"Tienda fisica","C",3,90,10,null,null,"Bolivar","Jose",8]
[18,"Cerrado","2022-07-09",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":9},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"julio"},2022,"Tienda fisica","D",7,180,11,"Transferencia",8,"Bolivar","Jose",7]
[19,"Cerrado","2022-09-30",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":30},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"septiembre"},2022,"Red social","A",8,30,10,"Transferencia",7,"Bolivar","Jose",5]
[20,"Cerrado","2022-10-09",{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":9},{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",TEXT(Tabla10[[#This Row],[Fecha]],\"MMMM\"))","v":"octubre"},2022,"Red social","B",6,55,10,"Efectivo",6,"Bolivar","Jose",3]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]
[null,null,null,{"$f":"IF(Tabla10[[#This Row],[Fecha]]=\"\",\"\",DAY(Tabla10[[#This Row],[Fecha]]))","v":""},null,""]

{"sheet":"Tablas dinámicas-Kpis","index":3,"n_rows":162,"n_cols":9,"rows_kept":162,"cut":false,"hidden":false,"merged":[]}
["TABLAS DINÁMICAS",null,null,null,null,null,null,"KPI`S"]
[]
[null,null,null,null,null,null,null,"Ventas totales",{"$f":"B8","v":6770}]
[null,null,null,null,null,null,null,"Abierto",{"$f":"IFERROR(VLOOKUP(H4,A66:B70,2,0),\"0\")","v":2}]
[null,null,null,null,null,null,null,"Cancelado",{"$f":"IFERROR(VLOOKUP(H5,A66:B70,2,0),\"0\")","v":2}]
[null,null,null,null,null,null,null,"Cerrado",{"$f":"IFERROR(VLOOKUP(H6,A66:B70,2,0),\"0\")","v":16}]
[]
["Suma de Pago",{"$f":"GETPIVOTDATA(\"Pago\",$A$8)","v":6770}]
[6770]
[]
[]
[]
[]
[]
[]
["Etiquetas de fila","Suma de Pago"]
["Jose",3320]
["Miguel",1850]
["Virginia",950]
[]
[]
[]
[]
["Etiquetas de fila","Suma de Pago","Suma de Pago2"]
["enero",1345,1345]
["febrero",1000,1000]
["marzo",190,190]
["abril",1570,1570]
["mayo",510,510]
["junio",240,240]
["julio",1380,1380]
["agosto",450,450]
["septiembre",30,30]
["octubre",55,55]
["(en blanco)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Minimo","Máximo","Promedio"]
[{"$f":"IFERROR(MIN(B25:B38),\"0,00\")","v":30},{"$f":"IFERROR(MAX(B25:B38),\"0,00\")","v":1570},{"$f":"IFERROR(AVERAGE(B25:B38),\"0,00\")","v":677}]
[]
[]
["Etiquetas de fila","Cuenta de Estatus"]
["Abierto",2]
["Cancelado",2]
["Cerrado",16]
[]
[]
[]
["Etiquetas de fila","Cuenta de Region/Equipo de Venta"]
["Bolivar",12]
["Brasilia",3]
["La Paz",2]
["Lima",1]
["Montevideo",2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Etiquetas de fila","Suma de Pago"]
["A",1625]
["B",2205]
["C",580]
["D",1125]
["E",1235]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Etiquetas de fila","Suma de Pago"]
["Red social",1085]
["Tienda fisica",4440]
["Web",1245]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Etiquetas de fila","Promedio de Rendimiento"]
["Alejandro",7]
["Jose",7.25]
["Maria",8.5]
["Miguel",7.666666666666667]
["Virginia",8]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Etiquetas de fila","Promedio de Satisfacción del cliente"]
["Bolivar",7.7]
["Brasilia",7.333333333333333]
["La Paz",8.5]
["Lima",8]
["Montevideo",7.5]

{"sheet":"Desplegables","index":4,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Estatus",null,"Canal de Venta",null,"Tipo de Pago",null,"Region",null,"Columna1",null,"Columna1",null,"Columna1"]
[]
[null,"Abierto",null,"Tienda fisica",null,"Efectivo",null,"Bolivar"]
[null,"Cerrado",null,"Web",null,"Tarjeta",null,"Lima"]
[null,"Cancelado",null,"Red social",null,"Crédito",null,"Santiago"]
[null,null,null,null,null,"Transferencia",null,"Brasilia"]
[null,null,null,null,null,null,null,"Montevideo"]
[null,null,null,null,null,null,null,"La Paz"]