{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Ayuda","Dashboard","Base de Datos","Tablas dinámicas-Kpis","Desplegables"],"not_rendered":{"charts":13,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":18},"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 RRHH"]
[]
[null,null,"En esta plantilla podrás generar un dashboard de la gestión de recursos humanos 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 empleado. (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 oficina y/o Departamento 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":21,"n_cols":25,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["ID","DNI","Nombre y Apellido","Estado laboral","Fecha de ingreso","Año de ingreso","Teléfono de contacto","Email","Fecha de nacimiento","Edad","Sexo","Cargo","Departamento","Oficina","Salario","Turno","Tipo de contrato","Horas extras","Dias ausencias","Fecha de Salida","Permanencia en la empresa (años)","Tipo de salida","Razón de Salida","Rendimiento","Promedio encuesta de satisfacción"]
[1,123352,"Empleado No. 1","Activo",42491,{"$f":"IF(E2=\"\",\"\",YEAR(E2))","v":2016},"000-000000","empleado1@company.com",32330,{"$f":"INT((TODAY()-I2)/365)","v":35},"Femenino","Ventas","Ventas","Lima",2000,"Mixto","Medio Tiempo",10,1,null,{"$f":"IF(T2=\"\",IF(E2=\"\",\"\",(TODAY()-E2)/365),(T2-E2)/365)","v":7.3863013698630136},"Voluntaria",null,7,8]
[2,343435,"Empleado No. 2","Activo",43281,2018,"000-000000","empleado2@company.com",33854,31,"Masculino","Contador","Administrativo","Santiago",2500,"Mixto","Medio Tiempo",null,2,null,{"$f":"IF(T3=\"\",IF(E3=\"\",\"\",(TODAY()-E3)/365),(T3-E3)/365)","v":5.2219178082191782},null,null,6,7]
[3,563518,"Empleado No. 3","Activo",43055,2017,"000-000000","empleado3@company.com",35316,27,"Femenino","Otro","IT","Brasilia",2000,"Mixto","Tiempo Completo",null,1,null,5.8410958904109593,null,null,8,9]
[4,783601,"Empleado No. 4","Activo",40687,2011,"000-000000","empleado4@company.com",34586,29,"Femenino","Lider de Proyecto","Mercadeo","Montevideo",3500,"Mixto","Tiempo Completo",5,2,null,12.328767123287671,null,null,8,7]
[5,1003684,"Empleado No. 5","Activo",40995,2012,"000-000000","empleado5@company.com",37144,22,"Masculino","Gerente de Finanzas","Contabilidad y Finanzas","Montevideo",4000,"Mañana","Tiempo Completo",null,null,null,11.484931506849316,null,null,9,8]
[6,1223767,"Empleado No. 6","Activo",41406,2013,"000-000000","empleado6@company.com",28379,46,"Femenino","CEO","Administrativo","Lima",2000,"Mañana","Tiempo Completo",18,1,null,10.358904109589041,null,null,10,9]
[7,1443850,"Empleado No. 7","Activo",42606,2016,"000-000000","empleado7@company.com",27649,48,"Femenino","Redactor","Contabilidad y Finanzas","Santiago",2300,"Mañana","Tiempo Completo",null,null,null,7.0712328767123287,null,null,7,10]
[8,1663933,"Empleado No. 8","Activo",43066,2017,"000-000000","empleado8@company.com",29477,43,"Masculino","Recepcionista","Administrativo","Brasilia",2200,"Mixto","Tiempo Completo",7,1,null,5.8109589041095893,null,null,8,8]
[9,1884016,"Empleado No. 9","Activo",40271,2010,"000-000000","empleado9@company.com",32034,36,"Masculino","Otro","Producción","Montevideo",2000,"Mixto","Cobro x Hora",null,null,null,13.468493150684932,null,null,9,7]
[10,2104099,"Empleado No. 10","Activo",41358,2013,"000-000000","empleado10@company.com",33496,32,"Masculino","Diseñador","Mercadeo","Montevideo",2800,"Mixto","Cobro x Hora",null,2,null,10.490410958904109,null,null,8,9]
[11,2324182,"Empleado No. 11","Activo",41515,2013,"000-000000","empleado11@company.com",37515,21,"Femenino","Desarrollador","IT","Lima",3000,"Mixto","Tiempo Completo",8,5,null,10.06027397260274,null,null,7,8]
[12,2544265,"Empleado No. 12","Activo",41482,2013,"000-000000","empleado12@company.com",36786,23,"Masculino","Gerente de Oficina","Administrativo","Santiago",1000,"Tarde","Medio Tiempo",null,null,null,10.150684931506849,null,null,10,7]
[13,2764348,"Empleado No. 13","Activo",41512,2013,"000-000000","empleado13@company.com",28751,45,"Femenino","Otro","Administrativo","Brasilia",900,"Mixto","Tiempo Completo",null,3,null,10.068493150684931,null,null,8,6]
[14,2984431,"Empleado No. 14","Activo",42095,2015,"000-000000","empleado14@company.com",29848,42,"Masculino","Contador","Contabilidad y Finanzas","Montevideo",1800,"Mixto","Medio Tiempo",15,9,null,8.4712328767123282,null,null,9,5]
[15,3204514,"Empleado No. 15","Activo",41653,2014,"000-000000","empleado15@company.com",36423,24,"Masculino","Recursos Humanos","Recursos Humanos","Montevideo",2500,"Mañana","Tiempo Completo",null,null,null,9.6821917808219187,null,null,7,4]
[16,3424597,"Empleado No. 16","Inactivo",41997,2014,"000-000000","empleado16@company.com",29483,43,"Femenino","Desarrollador","IT","Lima",2000,"Tarde","Tiempo Completo",null,null,42428,1.1808219178082191,"Voluntaria",null,6,3]
[17,3644680,"Empleado No. 17","Inactivo",41614,2013,"000-000000","empleado17@company.com",32050,35,"Masculino","Ventas","Mercadeo","Santiago",2000,"Mixto","Tiempo Completo",null,null,44346,7.484931506849315,"Voluntaria",null,8,5]
[18,3864763,"Empleado No. 18","Inactivo",43835,2020,"000-000000","empleado18@company.com",33458,32,"Femenino","Lider de Proyecto","Mercadeo","Brasilia",2000,"Nocturno","Tiempo Completo",null,null,44377,1.484931506849315,"Voluntaria",null,7,6]
[19,4084846,"Empleado No. 19","Inactivo",42497,2016,"000-000000","empleado19@company.com",37283,21,"Masculino","Desarrollador","IT","Montevideo",2000,"Mañana","Tiempo Completo",null,null,44834,6.4027397260273968,"Involuntaria","Fin de Contrato",5,8]
[20,4304929,"Empleado No. 20","Inactivo",42099,2015,"000-000000","empleado20@company.com",37516,21,"Femenino","Recursos Humanos","Recursos Humanos","Montevideo",2000,"Mixto","Cobro x Hora",null,null,43055,2.6191780821917807,"Involuntaria","Despido",3,6]

{"sheet":"Tablas dinámicas-Kpis","index":3,"n_rows":224,"n_cols":9,"rows_kept":224,"cut":false,"hidden":false,"merged":[]}
["TABLAS DINÁMICAS",null,null,null,null,null,null,"KPI`S"]
[]
[null,null,null,null,null,null,null,"Tasa de equidad",{"$f":"GETPIVOTDATA(\"Nombre y Apellido\",$A$10,\"Sexo\",\"Femenino\")/GETPIVOTDATA(\"Nombre y Apellido\",$A$10)","v":0.5}]
["Estado","Nombre / Apellido",null,null,null,null,null,"Tasa de rotacion",{"$f":"GETPIVOTDATA(\"Permanencia en la empresa (años)\",$A$92)","v":9.1903196347031972}]
["Activo",15,null,null,null,null,null,"Tasa de satisfacción",{"$f":"GETPIVOTDATA(\"Promedio encuesta de satisfacción\",$A$140)","v":7}]
["Inactivo",5,null,null,null,null,null,"Tasa de rendimiento",{"$f":"GETPIVOTDATA(\"Rendimiento\",$A$163)","v":7.5}]
["Total.",20,null,null,null,null,null,"Nº de empleados",{"$f":"GETPIVOTDATA(\"Nombre y Apellido\",$A$4,\"Estado laboral\",\"Activo\")","v":15}]
[null,null,null,null,null,null,null,"Gastos Nómina",{"$f":"GETPIVOTDATA(\"Salario\",$A$129)","v":44500}]
[null,null,null,null,null,null,null,"% Renuncias",{"$f":"SUM(B215:B233)/SUM(E215:E233)","v":0.25}]
["Genero","Cantidad"]
["Femenino",0.5]
["Masculino",0.5]
["Total.",1]
[]
[]
["Oficina","Cantidad empleados"]
["Brasilia",4]
["Lima",4]
["Montevideo",8]
["Santiago",4]
["Total.",20]
[]
["Estado","Promedio de Edad"]
["Empleado No. 1",35]
["Empleado No. 10",32]
["Empleado No. 11",21]
["Empleado No. 12",23]
["Empleado No. 13",45]
["Empleado No. 14",42]
["Empleado No. 15",24]
["Empleado No. 16",43]
["Empleado No. 17",35]
["Empleado No. 18",32]
["Empleado No. 19",21]
["Empleado No. 2",31]
["Empleado No. 20",21]
["Empleado No. 3",27]
["Empleado No. 4",29]
["Empleado No. 5",22]
["Empleado No. 6",46]
["Empleado No. 7",48]
["Empleado No. 8",43]
["Empleado No. 9",36]
["Total.",32.799999999999997]
[]
["Departamento","Cantidad"]
["Administrativo",5]
["Contabilidad y Finanzas",3]
["IT",4]
["Mercadeo",4]
["Producción",1]
["Recursos Humanos",2]
["Ventas",1]
["Total.",20]
[]
["Departamento","Horas extras."]
["Administrativo",25]
["Contabilidad y Finanzas",15]
["IT",8]
["Mercadeo",5]
["Producción",0]
["Recursos Humanos",0]
["Ventas",10]
["Total.",63]
[]
[]
["Contrato","Cantidad"]
["Cobro x Hora",3]
["Medio Tiempo",4]
["Tiempo Completo",13]
["Total.",20]
[]
[]
["Departamento","Total Dias ausencias"]
["CEO",1]
["Contador",11]
["Desarrollador",5]
["Diseñador",2]
["Gerente de Finanzas",0]
["Gerente de Oficina",0]
["Lider de Proyecto",2]
["Otro",4]
["Recepcionista",1]
["Recursos Humanos",0]
["Redactor",0]
["Ventas",1]
["Total.",27]
[]
[]
["Estado laboral","Activo"]
[]
["Empleados","Promedio de Permanencia en la empresa (años)"]
["Empleado No. 1",7.3835616438356162]
["Empleado No. 10",10.487671232876712]
["Empleado No. 11",10.057534246575342]
["Empleado No. 12",10.147945205479452]
["Empleado No. 13",10.065753424657535]
["Empleado No. 14",8.4684931506849317]
["Empleado No. 15",9.6794520547945204]
["Empleado No. 2",5.2191780821917808]
["Empleado No. 3",5.838356164383562]
["Empleado No. 4",12.326027397260274]
["Empleado No. 5",11.482191780821918]
["Empleado No. 6",10.356164383561644]
["Empleado No. 7",7.0684931506849313]
["Empleado No. 8",5.8082191780821919]
["Empleado No. 9",13.465753424657533]
["Total.",9.1903196347031972]
[]
[]
["Turno Tipo","Cantidad"]
["Mañana",5]
["Mixto",12]
["Tarde",2]
["Total.",19]
[]
["Tipo de Salida","Cantidad"]
["Involuntaria",2]
["Voluntaria",4]
["Total.",6]
[]
[]
[]
["Razon de Salida","Cantidad"]
["Despido",1]
["Fin de Contrato",1]
["Total.",2]
[]
["Departamento","Suma de Salario"]
["Administrativo",8600]
["Contabilidad y Finanzas",8100]
["IT",9000]
["Mercadeo",10300]
["Producción",2000]
["Recursos Humanos",4500]
["Ventas",2000]
["Total.",44500]
[]
[]
["Empleados","Promedio encuesta de satisfacción."]
["Empleado No. 1",8]
["Empleado No. 10",9]
["Empleado No. 11",8]
["Empleado No. 12",7]
["Empleado No. 13",6]
["Empleado No. 14",5]
["Empleado No. 15",4]
["Empleado No. 16",3]
["Empleado No. 17",5]
["Empleado No. 18",6]
["Empleado No. 19",8]
["Empleado No. 2",7]
["Empleado No. 20",6]
["Empleado No. 3",9]
["Empleado No. 4",7]
["Empleado No. 5",8]
["Empleado No. 6",9]
["Empleado No. 7",10]
["Empleado No. 8",8]
["Empleado No. 9",7]
["Total.",7]
[]
["Empleados","Promedio de Rendimiento"]
["Empleado No. 1",7]
["Empleado No. 10",8]
["Empleado No. 11",7]
["Empleado No. 12",10]
["Empleado No. 13",8]
["Empleado No. 14",9]
["Empleado No. 15",7]
["Empleado No. 16",6]
["Empleado No. 17",8]
["Empleado No. 18",7]
["Empleado No. 19",5]
["Empleado No. 2",6]
["Empleado No. 20",3]
["Empleado No. 3",8]
["Empleado No. 4",8]
["Empleado No. 5",9]
["Empleado No. 6",10]
["Empleado No. 7",7]
["Empleado No. 8",8]
["Empleado No. 9",9]
["Total.",7.5]
[]
[]
["Empleados","Ingresos"]
[2010,1]
[2011,1]
[2012,1]
[2013,6]
[2014,2]
[2015,2]
[2016,3]
[2017,2]
[2018,1]
[2020,1]
["Total.",20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Años de renuncias","Nº de renuncias",null,"Años de ingresos","Nº empleados"]
[2010,0,null,2010,1]
[2011,0,null,2011,1]
[2012,0,null,2012,1]
[2013,1,null,2013,6]
[2014,1,null,2014,2]
[2015,1,null,2015,2]
[2016,1,null,2016,3]
[2017,0,null,2017,2]
[2018,0,null,2018,1]
[2020,1,null,2020,1]

{"sheet":"Desplegables","index":4,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["Estado Laboral",null,"Departamento",null,"Tipo de Contrato",null,"Cargo",null,"Sexo",null,"Oficina",null,"Tipo de Salida",null,"Razon de Salida",null,null,"Turno"]
[]
["Activo",null,"Ventas",null,"Medio Tiempo",null,"Ventas",null,"Femenino",null,"Bolivar",null,"Voluntaria",null,"Fin de Contrato",null,null,"Mañana"]
["Inactivo",null,"Administrativo",null,"Tiempo Completo",null,"Contador",null,"Masculino",null,"Lima",null,"Involuntaria",null,"Despido",null,null,"Tarde"]
[null,null,"IT",null,"Cobro x Hora",null,"Otro",null,"Otros",null,"Santiago",null,null,null,"La posición fue eliminada",null,null,"Mixto"]
[null,null,"Mercadeo",null,null,null,"Lider de Proyecto",null,null,null,"Brasilia",null,null,null,null,null,null,"Nocturno"]
[null,null,"Contabilidad y Finanzas",null,null,null,"Gerente de Finanzas",null,null,null,"Montevideo"]
[null,null,"Producción",null,null,null,"CEO",null,null,null,"La Paz"]
[null,null,"Recursos Humanos",null,null,null,"Redactor"]
[null,null,"Legal",null,null,null,"Recepcionista"]
[null,null,"Logística",null,null,null,"Diseñador"]
[null,null,"Compras",null,null,null,"Desarrollador"]
[null,null,"Operaciones",null,null,null,"Gerente de Oficina"]
[null,null,"Investigación",null,null,null,"Recursos Humanos"]
[null,null,"Atención al Cliente",null,null,null,"Gerente de Mercadeo"]
[null,null,null,null,null,null,"Operaciones"]
[null,null,null,null,null,null,"Gerente de Legal"]
[null,null,null,null,null,null,"Gerente de Calidad"]
[null,null,null,null,null,null,"Gerente de Compras"]