2025年人力資源制度：【年終獎】員工年終獎金發(fā)放統(tǒng)計(jì)（函數(shù)自動計(jì)算）_第1頁
2025年人力資源制度：【年終獎】員工年終獎金發(fā)放統(tǒng)計(jì)（函數(shù)自動計(jì)算）_第2頁
2025年人力資源制度：【年終獎】員工年終獎金發(fā)放統(tǒng)計(jì)（函數(shù)自動計(jì)算）_第3頁
2025年人力資源制度：【年終獎】員工年終獎金發(fā)放統(tǒng)計(jì)（函數(shù)自動計(jì)算）_第4頁
2025年人力資源制度：【年終獎】員工年終獎金發(fā)放統(tǒng)計(jì)（函數(shù)自動計(jì)算）_第5頁
已閱讀5頁，還剩3頁未讀， 繼續(xù)免費(fèi)閱讀

下載本文檔

版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡介

員工年終評核-年終獎發(fā)放統(tǒng)計(jì)表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

獎金階層設(shè)定,,,,備注,工齡獎金基數(shù),,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

前,3,名對應(yīng)獎金,8000,1-3名,2000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

前,5,名對應(yīng)獎金,5000,4-5名,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

前,10,名對應(yīng)獎金,3000,6-10名,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

基本信息,,,,,司齡,考勤部分（30%）,,,,,每月表現(xiàn),,,,,,,,,,,,工作量/產(chǎn)量,,,,,,,,,,,,遲到得分,事假得分,病假得分,曠工得分,上班天數(shù),每月表現(xiàn),每月產(chǎn)量,年終評分,年終排名,應(yīng)發(fā)獎金,,

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

序號,姓名,英文名,員工編號,入職時間,10%,全年遲到次數(shù),事假時長（h）,病假時長（h）,曠工天數(shù),全年上班天數(shù),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分,上班天數(shù)*百分比,全年平均*百分比,全年平均*百分比,,,基本獎金,工齡獎金,合計(jì)

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. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲空間，僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請與我們聯(lián)系，我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論