2025年人力资源制度：【年终奖】员工年终奖金发放统计（函数自动计算）

员工年终评核-年终奖发放统计表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

奖金阶层设定,,,,备注,工龄奖金基数,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

前,3,名对应奖金,8000,1-3名,2000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

前,5,名对应奖金,5000,4-5名,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

前,10,名对应奖金,3000,6-10名,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

基本信息,,,,,司龄,考勤部分（30%）,,,,,每月表现,,,,,,,,,,,,工作量/产量,,,,,,,,,,,,迟到得分,事假得分,病假得分,旷工得分,上班天数,每月表现,每月产量,年终评分,年终排名,应发奖金,,

,,,,,,5%,10%,5%,5%,5%,40%,,,,,,,,,,,,30%,,,,,,,,,,,,5%,10%,5%,5%,5%,40%,30%,,,,,

序号,姓名,英文名,员工编号,入职时间,10%,全年迟到次数,事假时长（h）,病假时长（h）,旷工天数,全年上班天数,1月评分,2月评分,3月评分,4月评分,5月评分,6月评分,7月评分,8月评分,9月评分,10月评分,11月评分,12月评分,1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,每次到1次扣0.5分,每请假1天扣1分,每请假1天扣0.5分,每次扣2分,上班天数*百分比,全年平均*百分比,全年平均*百分比,,,基本奖金,工龄奖金,合计

1,萧颖素,Bowie,1174428,2013/5/24,9.547222222,5,4,4,0,264,85,90,87,80,80,80,87,80,87,92,80,95,4200,3822,3846,3822,3846,3579,3822,3579,3822,3822,4321,4321,2.5,9.5,4.75,5,13.2,34.1,23.401,92.45,25,-,1909,1909

2,黄坤贤,Yuka,1174429,2013/7/1,9.444444444,3,24,8,2,213,87,76,80,89,85,90,85,80,87,88,80,80,3822,3579,3822,3579,3579,3822,3579,4321,3822,3579,4321,3978,3.5,7,4.5,3,10.65,33.56666667,22.9015,85.12,37,-,1889,1889

3,张剑凤,Faye,1174430,2013/7/3,9.438888889,6,0,0,0,260,85,80,87,80,80,92,95,95,95,95,-,-,3579,4251,3579,4251,3822,3579,4251,3822,3579,4251,-,-,2,10,5,5,13,35.36,23.3784,93.74,13,-,1888,1888

4,徐耀滨,Paul,1174431,2013/7/3,9.438888889,4,16,0,0,225,87,87,92,95,98,80,80,80,99,85,99,92,4251,4321,4251,4321,3579,4251,3822,4321,4251,4321,3978,3978,3,8,5,5,11.25,35.8,24.8225,92.87,21,-,1888,1888

5,吴伟铖,Wilson,1174432,2013/7/15,9.405555556,12,20,8,0,218,85,80,80,87,85,87,95,99,80,87,92,88,4321,4102,4321,4102,4251,4321,3579,4321,4321,4251,3978,3978,0,7.5,4.5,5,10.9,34.83333333,24.923,87.66,33,-,1881,1881

6,黄绍华,Simon,1174433,2014/1/2,8.941666667,18,4,16,1,224,92,95,80,80,95,99,85,87,92,95,80,92,4102,3978,4102,3978,4321,4102,4251,3822,4102,3822,3978,4251,0,9.5,4,4,11.2,35.73333333,24.4045,88.84,29,-,1788,1788

7,黄艳珑,Donna,1174434,2014/4/18,8.647222222,2,8,20,0,252,80,87,87,92,80,87,92,80,85,95,88,85,3978,3846,3978,3846,4102,3978,3822,4321,3978,3978,4321,4321,4,9,3.75,5,12.6,34.6,24.2345,93.18,17,-,1729,1729

8,郑君琪,Cyrus,1174435,2014/6/17,8.483333333,0,0,4,0,261,95,86,85,95,99,92,80,92,92,99,80,88,3846,4156,3846,4156,3978,3846,4102,3978,3846,3978,3978,3978,5,10,4.75,5,13.05,36.1,23.844,97.74,1,8000,1697,9697

9,肖晓璇,Cecilia,1174436,2014/9/1,8.277777778,2,8,0,0,261,92,92,92,95,80,95,87,88,88,95,95,88,4156,3846,4156,3846,3846,4156,3978,3978,4156,4251,4321,3978,4,9,5,5,13.05,36.23333333,24.334,96.62,5,5000,1656,6656

10,肖晓璇,Cecilia,1174437,2014/9/2,8.275,3,9,1,1,262,93,93,93,96,81,96,88,89,89,96,96,89,4157,3847,4157,3847,3847,4157,3979,3979,4157,4252,4322,3979,3.5,8.875,4.9375,4,13.1,36.63333333,24.34,95.39,9,3000,1655,4655

11,萧颖素,Bowie,1174428,2013/5/24,9.547222222,5,4,4,0,264,85,90,87,80,80,80,87,80,87,92,80,95,4200,3822,3846,3822,3846,3579,3822,3579,3822,3822,4321,4321,2.5,9.5,4.75,5,13.2,34.1,23.401,92.45,25,-,1909,1909

12,黄坤贤,Yuka,1174429,2013/7/1,9.444444444,3,24,8,2,213,87,76,80,89,85,90,85,80,87,88,80,80,3822,3579,3822,3579,3579,3822,3579,4321,3822,3579,4321,3978,3.5,7,4.5,3,10.65,33.56666667,22.9015,85.12,37,-,1889,1889

13,张剑凤,Faye,1174430,2013/7/3,9.438888889,6,0,0,0,260,85,80,87,80,80,92,95,95,95,95,-,-,3579,4251,3579,4251,3822,3579,4251,3822,3579,4251,-,-,2,10,5,5,13,35.36,23.3784,93.74,13,-,1888,1888

14,徐耀滨,Paul,1174431,2013/7/3,9.438888889,4,16,0,0,225,87,87,92,95,98,80,80,80,99,85,99,92,4251,4321,4251,4321,3579,4251,3822,4321,4251,4321,3978,3978,3,8,5,5,11.25,35.8,24.8225,92.87,21,-,1888,1888

15,吴伟铖,Wilson,1174432,2013/7/15,9.405555556,12,20,8,0,218,85,80,80,87,85,87,95,99,80,87,92,88,4321,4102,4321,4102,4251,4321,3579,4321,4321,4251,3978,3978,0,7.5,4.5,5,10.9,34.83333333,24.923,87.66,33,-,1881,1881

16,黄绍华,Simon,1174433,2014/1/2,8.941666667,18,4,16,1,224,92,95,80,80,95,99,85,87,92,95,80,92,4102,3978,4102,3978,4321,4102,4251,3822,4102,3822,3978,4251,0,9.5,4,4,11.2,35.73333333,24.4045,88.84,29,-,1788,1788

17,黄艳珑,Donna,1174434,2014/4/18,8.647222222,2,8,20,0,252,80,87,87,92,80,87,92,80,85,95,88,85,3978,3846,3978,3846,4102,3978,3822,4321,3978,3978,4321,4321,4,9,3.75,5,12.6,34.6,24.2345,93.18,17,-,1729,1729

18,郑君琪,Cyrus,1174435,2014/6/17,8.483333333,0,0,4,0,261,95,86,85,95,99,92,80,92,92,99,80,88,3846,4156,3846,4156,3978,3846,4102,3978,3846,3978,3978,3978,5,10,4.75,5,13.05,36.1,23.844,97.74,1,8000,1697,9697

19,肖晓璇,Cecilia,1174436,2014/9/1,8.277777778,2,8,0,0,261,92,92,92,95,80,95,87,88,88,95,95,88,4156,3846,4156,3846,3846,4156,3978,3978,4156,4251,4321,3978,4,9,5,5,13.05,36.23333333,24.334,96.62,5,5000,1656,6656

20,肖晓璇,Cecilia,1174437,2014/9/2,8.275,3,9,1,1,262,93,93,93,96,81,96,88,89,89,96,96,89,4157,3847,4157,3847,3847,4157,3979,3979,4157,4252,4322,3979,3.5,8.875,4.9375,4,13.1,36.63333333,24.34,95.39,9,3000,1655,4655

21,萧颖素,Bowie,1174428,2013/5/24,9.547222222,5,4,4,0,264,85,90,87,80,80,80,87,80,87,92,80,95,4200,3822,3846,3822,3846,3579,3822,3579,3822,3822,4321,4321,2.5,9.5,4.75,5,13.2,34.1,23.401,92.45,25,-,1909,1909

22,黄坤贤,Yuka,1174429,2013/7/1,9.444444444,3,24,8,2,213,87,76,80,89,85,90,85,80,87,88,80,80,3822,3579,3822,3579,3579,3822,3579,4321,3822,3579,4321,3978,3.5,7,4.5,3,10.65,33.56666667,22.9015,85.12,37,-,1889,1889

23,张剑凤,Faye,1174430,2013/7/3,9.438888889,6,0,0,0,260,85,80,87,80,80,92,95,95,95,95,-,-,3579,4251,3579,4251,3822,3579,4251,3822,3579,4251,-,-,2,10,5,5,13,35.36,23.3784,93.74,13,-,1888,1888

24,徐耀滨,Paul,1174431,2013/7/3,9.438888889,4,16,0,0,225,87,87,92,95,98,80,80,80,99,85,99,92,4251,4321,4251,4321,3579,4251,3822,4321,4251,4321,3978,3978,3,8,5,5,11.25,35.8,24.8225,92.87,21,-,1888,1888

25,吴伟铖,Wilson,1174432,2013/7/15,9.405555556,12,20,8,0,218,85,80,80,87,85,87,95,99,80,87,92,88,4321,4102,4321,4102,4251,4321,3579,4321,4321,4251,3978,3978,0,7.5,4.5,5,10.9,34.83333333,24.923,87.66,33,-,1881,1881

26,黄绍华,Simon,1174433,2014/1/2,8.941666667,18,4,16,1,224,92,95,80,80,95,99,85,87,92,95,80,92,4102,3978,4102,3978,4321,4102,4251,3822,4102,3822,3978,4251,0,9.5,4,4,11.2,35.73333333,24.4045,88.84,29,-,1788,1788

27,黄艳珑,Donna,1174434,2014/4/18,8.647222222,2,8,20,0,252,80,87,87,92,80,87,92,80,85,95,88,85,3978,3846,3978,3846,4102,3978,3822,4321,3978,3978,4321,4321,4,9,3.75,5,12.6,34.6,24.2345,93.18,17,-,1729,1729

28,郑君琪,Cyrus,1174435,2014/6/17,8.483333333,0,0,4,0,261,95,86,85,95,99,92,80,92,92,99,80,88,3846,4156,3846,4156,3978,3846,4102,3978,3846,3978,3978,3978,5,10,4.75,5,13.05,36.1,23.844,97.74,1,8000,1697,9697

29,肖晓璇,Cecilia,1174436,2014/9/1,8.277777778,2,8,0,0,261,92,92,92,95,80,95,87,88,88,95,95,88,4156,3846,4156,3846,3846,4156,3978,3978,4156,4251,4321,3978,4,9,5,5,13.05,36.23333333,24.334,96.62,5,5000,1656,6656

30,肖晓璇,Cecilia,1174437,2014/9/2,8.275,3,9,1,1,262,93,93,93,96,81,96,88,89,89,96,96,89,4157,3847,4157,3847,3847,4157,3979,3979,4157,4252,4322,3979,3.5,8.875,4.9375,4,13.1,36.63333333,24.34,95.39,9,3000,1655,4655

31,萧颖素,Bowie,1174428,2013/5/24,9.547222222,5,4,4,0,264,85,90,87,80,80,80,87,80,87,92,80,95,4200,3822,3846,3822,3846,3579,3822,3579,3822,3822,4321,4321,2.5,9.5,4.75,5,13.2,34.1,23.401,92.45,25,-,1909,1909

32,黄坤贤,Yuka,1174429,2013/7/1,9.444444444,3,24,8,2,213,87,76,80,89,85,90,85,80,87,88,80,80,3822,3579,3822,3579,3579,3822,3579,4321,3822,3579,4321,3978,3.5,7,4.5,3,10.65,33.56666667,22.9015,85.12,37,-,1889,1889

33,张剑凤,Faye,1174430,2013/7/3,9.438888889,6,0,0,0,260,85,80,87,80,80,92,95,95,95,95,-,-,3579,4251,3579,4251,3822,3579,4251,3822,3579,4251,-,-,2,10,5,5,13,35.36,23.3784,93.74,13,-,1888,1888

34,徐耀滨,Paul,1174431,2013/7/3,9.438888889,4,16,0,0,225,87,87,92,95,98,80,80,80,99,85,99,92,4251,4321,4251,4321,3579,4251,3822,4321,4251,4321,3978,3978,3,8,5,5,11.25,35.8,24.8225,92.87,21,-,1888,1888

35,吴伟铖,Wilson,1174432,2013/7/15,9.405555556,12,20,8,0,218,85,80,80,87,85,87,95,99,80,87,92,88,4321,4102,4321,4102,4251,4321,3579,4321,4321,4251,3978,3978,0,7.5,4.5,5,10.9,34.83333333,24.923,87.66,33,-,1881,1881

36,黄绍华,Simon,1174433,2014/1/2,8.941666667,18,4,16,1,224,92,95,80,80,95,99,85,87,92,95,80,92,4102,3978,4102,3978,4321,4102,4251,3822,4102,3822,3978,4251,0,9.5,4,4,11.2,35.73333333,24.4045