{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["人力指标明细确认"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"人力指标明细确认","index":0,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,11],[2,0,5,0],[6,0,10,0],[11,0,24,0],[7,1,10,1],[11,1,16,1],[17,1,23,1],[2,3,5,3],[2,4,5,4],[2,5,5,5],[6,5,24,5],[2,6,5,6],[6,6,24,6],[2,7,5,7],[6,7,24,7],[2,8,5,8],[6,8,25,8],[2,9,5,9],[6,9,25,9],[2,10,5,10],[6,10,25,10],[2,11,5,11],[6,11,25,11]]}
["人力BI明细确认"]
[null,"主题名称","主要内容","展现方式","数据来源","数据提供方","提供时间","BI数据整理","数据集整理时间","BI展现","展现确认时间","开发者","备注",null,"开发进度"]
["人工成本","薪酬结构","人员薪酬占比（司龄、学历、年龄、岗位、职级、mpo、是否离职）\n（按照事业部，部门：基薪、绩效奖金、加班费，福利费，年终奖、\n五保、公积金占比，层级薪酬占比，管理层/操作层薪酬占比，学历薪酬占比，工作年限薪酬占比，关键岗位薪酬占比，）\n人均薪酬（事业部、部门、岗位，加班费，增长率）","趋势图/饼图/雷达图","EXCEL：工资发放表、社保表、公积金表、预算表、年终奖发放表\nOA系统:员工信息表\nLFS系统","薪酬组","2019.10.16","孙康、薛小梅","2019.10.17","张悦/薛小梅","2019.10.18","张悦、孙康","饼图，司龄/五年的人占总体薪酬的比",null,"已完成（待修改）"]
[null,"薪酬效率","员工薪酬效率(单位成本业务量，单位成本收入，毛利，利润)",{"$nulls":9},"跟lfs操作量挂钩，操作量，人工成本，跟去年对比。单位成本--这个单位的营业成本。收入/人工成本、毛利/人工成本","单位收入、毛利、利润/人工成本= 单位收入、毛利、利润\n","已完成（待修改）"]
[null,"薪酬变化","员工薪酬变化率(时间/个人/部门/事业部薪酬变化，人均薪酬，超额奖励年度变化，人工成本总额、人均人工成本年度变化)",{"$nulls":9},"时间--薪资表时间，只取到年",null,"已完成（待修改）"]
[null,"人工成本预算","人工成本预算进度完成率",{"$nulls":9},"实际发生的/预算表的(细到人)，预算表加工号",null,"已完成（待修改）"]
["招聘配置","招聘效率","招聘计划完成率(计划人数、岗位、需求时间、来源(校招、社招)）【趋势】","仪表图、曲线图、雷达图","(招聘计划表)\nOA-人力需求表，入职手续表","招聘组","2019.10.18","孙康、黄加其、冯韵诗","2019.10.21","张悦、黄加其、冯韵诗\n","2019.10.22","张悦、孙康","入职手续表/人力需求表","人力\n需求表-员工关系第一个表。需求时间是期望到岗shijain","已完成（待修改）"]
[null,"招聘质量","招聘渠道转化率、存活率(3、6、12月，3年)","饼图（占比）、【趋势】、漏斗图","（Excel：人力需求及招聘实施跟进表）\nOA：人员卡片-入职时间、后台-离职时间",{"$nulls":7},"转化率：不同渠道招到的人/需求的人数\n存活率：/招到的人",null,"已完成（待修改）"]
[null,null,"入职人数（时间范围、单位、岗位、部门）","曲线图、【趋势】","OA：入职手续表",{"$nulls":7},"入职日期","人员卡片","已完成（待修改）"]
[null,null,"   受教育程度（OA-学历字段）","饼图（占比）、【趋势】","OA:人员卡片、履历表",{"$nulls":9},"已完成（待修改）"]
[null,null,"   年龄结构（29岁及以下，30-39,40-49,50以上）","饼图（占比）、【趋势】","OA:人员卡片、履历表",{"$nulls":9},"已完成（待修改）"]
["人事管理","在职人员构成","在职人数（时间范围、单位、岗位、部门）","曲线图、【趋势】",{"$nulls":8},"每月最后一天的当值人数",null,"已完成（待修改）"]
[null,null,"   司龄（1-3、3<x<=5、5<x<=10、10<x<=15、15<x<=20年）","饼图（占比）、【趋势】","OA:人员卡片",{"$nulls":7},"司龄=-当前时间-入职时间",null,"已完成（待修改）"]
[null,null,"   受教育程度（OA-学历字段）","饼图（占比）、【趋势】","OA:人员卡片、履历表",{"$nulls":9},"已完成（待修改）"]
[null,null,"   年龄结构（29岁及以下，30-39,40-49,50以上）","饼图（占比）、【趋势】","OA:人员卡片、履历表",{"$nulls":7},"当前时间-出生日期",null,"已完成（待修改）"]
[null,null,"   性别","饼图（占比）、【趋势】","OA:人员卡片、履历表",{"$nulls":9},"已完成（待修改）"]
[null,null,"   岗位层级","饼图（占比）、帕累托图、桑基图","OA:人员卡片-履历表、调动表",{"$nulls":7},"1-4级是高层，7-9是","需要多久晋升下一岗位","已完成（待修改）"]
[null,"离职分析","离职人数（时间范围、单位、岗位、部门）","曲线图、【趋势】",{"$nulls":10},"已完成（待修改）"]
[null,null,"   司龄（1-3、3<x<=5、5<x<=10、10<x<=15、15<x<=20年）","饼图（占比）、【趋势】","OA:人员卡片",{"$nulls":9},"已完成（待修改）"]
[null,null,"   受教育程度（OA-学历字段）","饼图（占比）、【趋势】","OA:人员卡片、履历表",{"$nulls":9},"已完成（待修改）"]
[null,null,"   年龄结构（29岁及以下，30-39,40-49,50以上）","饼图（占比）、【趋势】","OA:人员卡片、履历表",{"$nulls":9},"已完成（待修改）"]
[null,null,"   性别","饼图（占比）、【趋势】","OA:人员卡片、履历表",{"$nulls":9},"已完成（待修改）"]
[null,null,"   岗位层级","饼图（占比）、帕累托图","OA:人员卡片、履历表",{"$nulls":9},"已完成（待修改）"]
[null,null,"人员流失率(时间范围、事业部、分部、部门、员工)【趋势】\n（时间轴拖拽，月、年为单位）","饼图（占比）、【趋势】","OA:人员卡片、履历表、后端-人员状态更改-人员离职",{"$nulls":7},"离职人/在职人 时间：每个月最后一天",null,"已完成（待修改）"]
[null,"人员异动","转正、调入、调出、晋升、(时间范围、事业部、分部、部门、员工)","柱状图、曲线图【趋势】、","OA：人员异动表、晋升考察表、试用/实习评估表",{"$nulls":9},"已完成（待修改）"]
[]
[]
[null,"【展现方式】需与IT、BI商榷或补充"]