{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["组织绩效与个人绩效分布关系","评分人数据","组织等级","基础资料"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":108,"n_cols":6,"rows_kept":108,"cut":false,"hidden":false,"merged":[[107,0,107,5],[53,0,56,0],[58,0,61,0],[63,0,66,0],[68,0,71,0],[73,0,76,0],[78,0,81,0],[83,0,86,0],[88,0,91,0],[93,0,96,0],[98,0,101,0],[103,0,106,0],[48,0,51,0],[0,0,0,5],[2,0,5,0],[6,0,6,5],[8,0,11,0],[13,0,16,0],[18,0,21,0],[23,0,26,0],[28,0,31,0],[33,0,36,0],[38,0,41,0],[43,0,46,0]]}
["组织绩效与个人绩效分布对应关系表（仅供参考）"]
["类目","组织绩效/个人绩效强制比例要求","个人绩效A比例","个人绩效B+比例","个人绩效B比例","个人绩效B-/C/D比例"]
["组织绩效","组织绩效A",0.2,0.3,0.5,0]
[null,"组织绩效B+",0.1,0.25,0.6,0.05]
[null,"组织绩效B",0,0.2,0.7,0.1]
[null,"组织绩效B-/C/D",0,0.1,0.7,0.2]
[]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[2,"组织绩效A",0,1,{"$f":"ROUND(E3*2,2)","v":1},0]
[null,"组织绩效B+",0,1,1,0]
[null,"组织绩效B",{"$f":"ROUND(C5*2,2)","v":0},0,2,0]
[null,"组织绩效B-/C/D",0,0,2,0]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[3,"组织绩效A",1,1,1,{"$f":"ROUND(F3*3,2)","v":0}]
[null,"组织绩效B+",0,1,2,0]
[null,"组织绩效B",{"$f":"ROUND(C5*3,2)","v":0},1,2,0]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*3,2)","v":0},0,3,0]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[4,"组织绩效A",1,1,{"$f":"ROUND(E3*4,2)","v":2},{"$f":"ROUND(F3*4,2)","v":0}]
[null,"组织绩效B+",1,1,2,0]
[null,"组织绩效B",{"$f":"ROUND(C5*4,2)","v":0},1,3,0]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*4,2)","v":0},0,3,1]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
["5\n（组织B-时就低取整）","组织绩效A",{"$f":"C3*5","v":1},2,2,{"$f":"F3*5","v":0}]
[null,"组织绩效B+",1,1,{"$f":"E4*5","v":3},0]
[null,"组织绩效B",{"$f":"C5*5","v":0},{"$f":"D5*5","v":1},4,0]
[null,"组织绩效B-/C/D",{"$f":"C6*5","v":0},1,3,1]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[6,"组织绩效A",{"$f":"ROUND(C3*6,2)","v":1.2},{"$f":"ROUND(D3*6,0)","v":2},3,0]
[null,"组织绩效B+",{"$f":"ROUND(C4*6,2)","v":0.6},{"$f":"ROUND(D4*6,2)","v":1.5},3,0.3]
[null,"组织绩效B",{"$f":"ROUND(C5*6,2)","v":0},1,4,1]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*6,2)","v":0},1,4,1]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[7,"组织绩效A",{"$f":"ROUND(C3*7,0)","v":1},2,4,0]
[null,"组织绩效B+",1,2,4,0]
[null,"组织绩效B",{"$f":"ROUND(C5*7,0)","v":0},1,5,1]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*7,0)","v":0},1,5,1]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[8,"组织绩效A",{"$f":"ROUND(C3*8,0)","v":2},{"$f":"ROUND(D3*8,0)","v":2},{"$f":"ROUND(E3*8,0)","v":4},{"$f":"ROUND(F3*8,0)","v":0}]
[null,"组织绩效B+",{"$f":"ROUND(C4*8,2)","v":0.8},{"$f":"ROUND(D4*8,0)","v":2},{"$f":"ROUND(E4*8,0)","v":5},{"$f":"ROUND(F4*8,0)","v":0}]
[null,"组织绩效B",{"$f":"ROUND(C5*8,2)","v":0},2,5,1]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*8,2)","v":0},{"$f":"ROUND(D6*8,0)","v":1},5,2]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[9,"组织绩效A",{"$f":"ROUND(C3*9,0)","v":2},{"$f":"ROUND(D3*9,0)","v":3},4,0]
[null,"组织绩效B+",{"$f":"ROUND(C4*9,0)","v":1},2,6,0]
[null,"组织绩效B",{"$f":"ROUND(C5*9,0)","v":0},2,6,1]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*9,2)","v":0},1,6,2]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[10,"组织绩效A",{"$f":"ROUND(C3*10,0)","v":2},{"$f":"ROUND(D3*10,0)","v":3},5,0]
[null,"组织绩效B+",{"$f":"ROUND(C4*10,0)","v":1},3,6,0]
[null,"组织绩效B",0,2,7,1]
[null,"组织绩效B-/C/D",0,1,7,2]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[11,"组织绩效A",2,3,6,{"$f":"ROUND(F3*11,2)","v":0}]
[null,"组织绩效B+",1,3,7,0]
[null,"组织绩效B",{"$f":"ROUND(C5*11,2)","v":0},2,8,1]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*11,2)","v":0},1,8,2]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
["12\n（组织B-时就低取整）","组织绩效A",2,4,{"$f":"ROUND(E3*12,2)","v":6},0]
[null,"组织绩效B+",1,{"$f":"ROUND(D4*12,2)","v":3},7,1]
[null,"组织绩效B",0,2,9,1]
[null,"组织绩效B-/C/D",0,1,8,3]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[13,"组织绩效A",3,4,6,{"$f":"ROUND(F3*13,2)","v":0}]
[null,"组织绩效B+",1,3,8,1]
[null,"组织绩效B",{"$f":"ROUND(C5*13,2)","v":0},3,9,1]
[null,"组织绩效B-/C/D",0,1,9,3]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[14,"组织绩效A",3,4,{"$f":"ROUND(E3*14,2)","v":7},0]
[null,"组织绩效B+",1,4,8,1]
[null,"组织绩效B",{"$f":"ROUND(C5*14,2)","v":0},3,10,1]
[null,"组织绩效B-/C/D",0,1,10,3]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
["15\n（组织B-时就低取整）","组织绩效A",{"$f":"ROUND(C3*15,2)","v":3},5,7,{"$f":"ROUND(F3*15,2)","v":0}]
[null,"组织绩效B+",2,4,8,1]
[null,"组织绩效B",{"$f":"ROUND(C5*15,2)","v":0},3,11,1]
[null,"组织绩效B-/C/D",0,1,11,3]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[16,"组织绩效A",3,5,{"$f":"ROUND(E3*16,2)","v":8},0]
[null,"组织绩效B+",2,{"$f":"ROUND(D4*16,2)","v":4},9,1]
[null,"组织绩效B",0,3,11,2]
[null,"组织绩效B-/C/D",0,2,11,3]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[17,"组织绩效A",3,5,9,0]
[null,"组织绩效B+",2,4,10,1]
[null,"组织绩效B",{"$f":"ROUND(C5*17,2)","v":0},3,12,2]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*17,2)","v":0},2,12,3]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
["18\n（组织B-时就低取整）","组织绩效A",{"$f":"ROUND(C3*18,2)","v":3.6},5.4,9,0]
[null,"组织绩效B+",1.8,4.5,10,0.9]
[null,"组织绩效B",{"$f":"ROUND(C5*18,2)","v":0},3.6,12,1.8]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*18,2)","v":0},1.8,12,3.6]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[19,"组织绩效A",4,6,9,{"$f":"ROUND(F3*19,2)","v":0}]
[null,"组织绩效B+",2,5,11,1]
[null,"组织绩效B",{"$f":"ROUND(C5*19,2)","v":0},4,13,2]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*19,2)","v":0},2,13,4]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[20,"组织绩效A",{"$f":"ROUND(C3*20,2)","v":4},{"$f":"ROUND(D3*20,2)","v":6},10,0]
[null,"组织绩效B+",{"$f":"ROUND(C4*20,2)","v":2},5,12,1]
[null,"组织绩效B",{"$f":"ROUND(C5*20,2)","v":0},4,14,2]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*20,2)","v":0},2,14,4]
["人数","组织绩效/个人绩效强制比例要求","A","B+","B","B-/C/D"]
[28,"组织绩效A",{"$f":"ROUND(C3*A104,2)","v":5.6},{"$f":"ROUND(D3*A104,2)","v":8.4},{"$f":"ROUND(E3*A104,2)","v":14},{"$f":"ROUND(F3*A104,2)","v":0}]
[null,"组织绩效B+",{"$f":"ROUND(C4*A104,2)","v":2.8},{"$f":"ROUND(D4*A104,2)","v":7},{"$f":"ROUND(E4*A104,2)","v":16.8},{"$f":"ROUND(F4*A104,2)","v":1.4}]
[null,"组织绩效B",{"$f":"ROUND(C5*A104,2)","v":0},{"$f":"ROUND(D5*A104,2)","v":5.6},{"$f":"ROUND(E5*A104,2)","v":19.600000000000001},{"$f":"ROUND(F5*A104,2)","v":2.8}]
[null,"组织绩效B-/C/D",{"$f":"ROUND(C6*A104,2)","v":0},{"$f":"ROUND(D6*A104,2)","v":2.8},{"$f":"ROUND(E6*A104,2)","v":19.600000000000001},{"$f":"ROUND(F6*A104,2)","v":5.6}]
["*以上人数为根据比例换算，由于人数取整等情况，实际人数与比例可能存在一定误差。\n*人数恰好5人时，取整后单次考核无B-，但两个考核周期需要评出1个B-/C；\n*人数不足5人（不含单位负责人）的单位，按照若干周期累计达5人后的比例计算绩优、绩差名额。\n例如：某单位二季度、三季度均为3人参评（不足5人），两个季度累计后，参评人数为6人（达到5人），以此计算分布比例。\n假定：该单位两个季度组织绩效均为B，两个季度累计后，该单位B+名额为6*20%=1.2（取整后1人）、B名额为6*70%=4.2（取整后4人）、B-/C名额为6*10%=0.6（取整后1人）。三季度时，各等级绩效名额，根据二季度绩效已分布情况进行计算。"]

{"sheet":"评分人数据","index":1,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["部门名称","部门编码","考核人","考核人工号","评分人","评分人工号"]

{"sheet":"组织等级","index":2,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["部门名称","部门编码","等级"]

{"sheet":"基础资料","index":3,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["组织绩效/个人绩效强制比例要求","个人绩效A比例","个人绩效B+比例","个人绩效B比例","个人绩效B-比例","个人绩效C比例","个人绩效D比例"]
["组织绩效A",0.2,0.3,0.5,0,0,0]
["组织绩效B+",0.1,0.25,0.6,0.05,0.05,0.05]
["组织绩效B",0,0.2,0.7,0.1,0.1,0.1]
["组织绩效B-",0,0.1,0.7,0.2,0.2,0.2]
["组织绩效C",0,0.1,0.7,null,0.2]
["组织绩效D",0,0.1,0.7,null,null,0.2]