2025年人力資源制度:【年終獎】員工年終獎金發放統計(函數自動計算)_第1頁
2025年人力資源制度:【年終獎】員工年終獎金發放統計(函數自動計算)_第2頁
2025年人力資源制度:【年終獎】員工年終獎金發放統計(函數自動計算)_第3頁
2025年人力資源制度:【年終獎】員工年終獎金發放統計(函數自動計算)_第4頁
2025年人力資源制度:【年終獎】員工年終獎金發放統計(函數自動計算)_第5頁
已閱讀5頁,還剩3頁未讀 繼續免費閱讀

下載本文檔

版權說明:本文檔由用戶提供并上傳,收益歸屬內容提供方,若內容存在侵權,請進行舉報或認領

文檔簡介

員工年終評核-年終獎發放統計表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

獎金階層設定,,,,備注,工齡獎金基數,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

前,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

溫馨提示

  • 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯系上傳者。文件的所有權益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網頁內容里面會有圖紙預覽,若沒有圖紙預覽就沒有圖紙。
  • 4. 未經權益所有人同意不得將文件中的內容挪作商業或盈利用途。
  • 5. 人人文庫網僅提供信息存儲空間,僅對用戶上傳內容的表現方式做保護處理,對用戶上傳分享的文檔內容本身不做任何修改或編輯,并不能對任何下載內容負責。
  • 6. 下載文件中如有侵權或不適當內容,請與我們聯系,我們立即糾正。
  • 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論