搜索
薪资等级分布验算模板V1.0目的：1、快速根据理论试算等级薪资分布一览表2、快速验证分布的合理性（增长率和重叠率校对）基本思路：1、主体增长依据指数增长模型（可以调整为弱指数和强指数）2、适应不同单位不同级别的要求（最多30级），指数模型不推荐级别太多，否则高级别的差距很大。2006/11/2薪资等级分布验算模板V1.0目的：1、快速根据理论试算等级薪资分布一览表2、快速验证分布的合理性（增长率和重叠率校对）基本思路：1、主体增长依据指数增长模型（可以调整为弱指数和强指数）2、适应不同单位不同级别的要求（最多30级），指数模型不推荐级别太多，否则高级别的差距很大。2006/11/2返回模板页针对级别较多的情况，适用逐渐型的。针对级别较少的情况，适用陡斜型的。其他可以自由调整。返回模板页中点增加率Mid-PointProgressionGradual逐渐的Moderate稳健的10%10%15%15%Moregrades多级别幅度重叠返回模板页幅度重叠RangeOverlapRMBRMBRMB1,201,00801,801,501,201,802,252,70Grade1,201,00801,351,12901,001,251,50GradeNooverlap没有重叠50%jumpeachpromotion每晋升,增加50%Bigoverlap大部分重叠12.5%jumpeachpromotion每晋升,增加12.5%Rangeoverlap重叠部分1,200-9003001,350-900450==RMBRMB幅度重叠RangeOverlap合理性规则一个级别的幅度一般不超过三个其他级别的重叠返回模板页一个级别的幅度一般不超过三个其他级别的重叠Therangespanofanyonegradeshouldnotoverlapmuchmorethanthreeothergrades幅度定义050001000015000200002500030000350004000045000abcdeRMB050001000015000200002500030000350004000045000abcdeabc=Mid-PointProgression中点增加率(a1-a2)/a0=(b1-b2)/b0=RangeSpread幅度（绿点值－红点值）(c1-c2)/c0=}Steep陡斜的30%30%Lessgrades少级别RMBGrade1,2001,0008001,5001,2501,0001,2501,5631,875Grade大部分重叠12.5%jumpeachpromotion12.5%重叠部分=67%==Moderateoverlap适度重叠25%jumpeachpromotion每晋升,增加25%Rangeoverlap重叠部分=40%1,200-1,0002001,500-1,000500==RMB合理性规则一个级别的幅度一般不超过三个其他级别的重叠一个级别的幅度一般不超过三个其他级别的重叠Therangespanofanyonegradeshouldnotoverlapmuch050001000015000200002500030000350004000045000abcdeGrade050001000015000200002500030000350004000045000abcde中点增加率b2)/b0=RangeSpread幅度（绿点值－红点值）/黑点值说明值最低级别的标准工资，作为计算的基础2000幅度增大会强化等级间的重叠率，要遵守核查规则25%指数级增长的基数，数值越大会弱化陡度。3000指数级别增长参数（数值越大增长陡度越大）9%增长区间最低级别中点值:强化低级别增长，弱化高级别增长，整体重点增长率大于中点增长指数增长区间最低级别中点值:强化高级别增长，弱化低级别增长，整体重点增长率小于中点增长指数规则与算法说明备注Minimum=MidPoint/(1+Range/2)Maximum=Minimum*(1+Range)范围与重叠率合理性核查规则一个级别的幅度一般不超过三个其他级别的重叠10％为逐渐的，15％为稳健的，30％是陡斜的15161718192021222324252627282930解释：名称工资低限算法工资高限算法中点增长率(较上一级中点增长的比例）参数最低级别中点值级别幅度中点增长区间中点增长指数利用幅度制定工资架构备注：只需在绿色区域填写即可，通过调整增长区间和增长指数可以调整增长速度。12345678910高限2,2222,5222,8493,2063,5944,0184,4794,9825,5316,129中点2,0002,2702,5642,8853,2353,6164,0314,4844,9785,516低限1,7782,0182,2792,5652,8753,2143,5833,9864,4254,90302,0004,0006,0008,00010,00012,00014,00016,00018,000低限中点高限12345678910高限6,7807,4908,2649,10810,02811,03012,12313,31414,61316,028中点6,1026,7417,4388,1979,0259,92710,91111,98313,15114,425低限5,4245,9926,6127,2878,0228,8249,69910,65111,69012,822级别数1112131415161718192005000100001500020000250003000035000400004500050000级别数低限中点高限高限中点低限级别数020000400006000080000100000120000120000级别数低限中点12345678910111213141516高限2,2222,5222,8493,2063,5944,0184,4794,9825,5316,1296,7807,4908,2649,10810,02811,03012,123中点2,0002,2702,5642,8853,2353,6164,0314,4844,9785,5166,1026,7417,4388,1979,0259,92710,911低限1,7782,0182,2792,5652,8753,2143,5833,9864,4254,9035,4245,9926,6127,2878,0228,8249,699级别数12345678910111213141516020000400006000080000100000120000级别数低限中点高限中点增长率重叠率后三个级别重叠合理性核查11,7782,0002,2220%0%204通过22,0182,2702,52214%41%243通过32,2792,5642,84913%43%285通过42,5652,8853,20613%44%330通过52,8753,2353,59412%46%391通过63,2143,6164,01812%47%466通过73,5834,0314,47911%48%548通过83,9864,4844,98211%50%637通过94,4254,9785,53111%50%735通过104,9035,5166,12911%51%841通过115,4246,1026,78011%52%956通过125,9926,7417,49010%53%1,082通过136,6127,4388,26410%53%1,220通过147,2878,1979,10810%54%1,370通过158,0229,02510,02810%54%1,533通过168,8249,92711,03010%55%1,711通过179,69910,91112,12310%55%1,905通过1810,65111,98313,31410%55%2,116通过1911,69013,15114,61310%56%2,347通过2012,82214,42516,02810%56%2,598通过2114,05615,81317,57010%56%2,872通过2215,40117,32619,25210%56%3,170通过2316,86718,97621,08410%57%3,496通过2418,46520,77423,0829%57%3,850通过2520,20722,73325,2599%57%4,237通过2622,10624,86927,6329%57%4,658通过2724,17627,19730,2199%57%5,117通过2826,43129,73533,0399%57%5,618通过2928,89032,50136,1139%57%4,542通过3031,57035,51739,4639%58%0通过解释：重叠率为负值，表示两个等级不重叠，数值代表离开的程度12345678910高限17,57019,25221,08423,08225,25927,63230,21933,03936,11339,463中点15,81317,32618,97620,77422,73324,86927,19729,73532,50135,517低限14,05615,40116,86718,46520,20722,10624,17626,43128,89031,570级别数21222324252627282930020000400006000080000100000120000级别数低限中点高限中点高限171819202122232425262728293012,12313,31414,61316,02817,57019,25221,08423,08225,25927,63230,21933,03936,11339,46310,91111,98313,15114,42515,81317,32618,97620,77422,73324,86927,19729,73532,50135,5179,69910,65111,69012,82214,05615,40116,86718,46520,20722,10624,17626,43128,89031,5701718192021222324252627282930