【年终奖】员工年终奖金发放统计（函数自动计算） (2).xlsx

员工年终评核-年终奖发放统计表奖金阶层设定备注工龄奖金基数前3名对应奖金80001-3名2000前5名对应奖金50004-5名前10名对应奖金30006-10名基本信息司龄考勤部分（30%）每月表现5%10%5%5%5%40%序号姓名英文名员工编号入职时间10%全年迟到次数事假时长（h）病假时长（h）旷工天数全年上班天数1月评分2月评分3月评分1萧颖素Bowie11744282013/5/24 9.5554402648590872黄坤贤Yuka11744292013/7/19.44324822138776803张剑凤Faye11744302013/7/39.4460002608580874徐耀滨Paul11744312013/7/39.44416002258787925吴伟铖Wilson11744322013/7/15 9.411220802188580806黄绍华Simon11744332014/1/28.941841612249295807黄艳珑Donna11744342014/4/18 8.65282002528087878郑君琪Cyrus11744352014/6/17 8.4800402619586859肖晓璇Cecilia11744362014/9/18.28280026192929210肖晓璇Cecilia11744372014/9/28.28391126293939311萧颖素Bowie11744282013/5/24 9.55544026485908712黄坤贤Yuka11744292013/7/19.443248221387768013张剑凤Faye11744302013/7/39.44600026085808714徐耀滨Paul11744312013/7/39.444160022587879215吴伟铖Wilson11744322013/7/15 9.4112208021885808016黄绍华Simon11744332014/1/28.9418416122492958017黄艳珑Donna11744342014/4/18 8.652820025280878718郑君琪Cyrus11744352014/6/17 8.48004026195868519肖晓璇Cecilia11744362014/9/18.28280026192929220肖晓璇Cecilia11744372014/9/28.28391126293939321萧颖素Bowie11744282013/5/24 9.55544026485908722黄坤贤Yuka11744292013/7/19.443248221387768023张剑凤Faye11744302013/7/39.44600026085808724徐耀滨Paul11744312013/7/39.444160022587879225吴伟铖Wilson11744322013/7/15 9.4112208021885808026黄绍华Simon11744332014/1/28.9418416122492958027黄艳珑Donna11744342014/4/18 8.652820025280878728郑君琪Cyrus11744352014/6/17 8.48004026195868529肖晓璇Cecilia11744362014/9/18.28280026192929230肖晓璇Cecilia11744372014/9/28.28391126293939331萧颖素Bowie11744282013/5/24 9.55544026485908732黄坤贤Yuka11744292013/7/19.443248221387768033张剑凤Faye11744302013/7/39.44600026085808734徐耀滨Paul11744312013/7/39.444160022587879235吴伟铖Wilson11744322013/7/15 9.4112208021885808036黄绍华Simon11744332014/1/28.9418416122492958037黄艳珑Donna11744342014/4/18 8.652820025280878738郑君琪Cyrus11744352014/6/17 8.480040261958685客户可根据实际情况修改奖金阶层(名次、对应奖金、工龄奖金基数均可修改），函数表会自动更新员工的应发奖金。39肖晓璇Cecilia11744362014/9/18.28280026192929240肖晓璇Cecilia11744372014/9/28.28391126293939341工作量/产量30%4月评分5月评分6月评分7月评分8月评分9月评分10月评分11月评分12月评分1月2月3月4月5月6月7月8月808080878087928095420038223846382238463579382235798985908580878880803822357938223579357938223579432180809295959595-3579425135794251382235794251382295988080809985999242514321425143213579425138224321878587959980879288432141024321410242514321357943218095998587929580924102397841023978432141024251382292808792808595888539783846397838464102397838224321959992809292998088384641563846415639783846410239789580958788889595884156384641563846384641563978397896819688898996968941573847415738473847415739793979808080878087928095420038223846382238463579382235798985908580878880803822357938223579357938223579432180809295959595-3579425135794251382235794251382295988080809985999242514321425143213579425138224321878587959980879288432141024321410242514321357943218095998587929580924102397841023978432141024251382292808792808595888539783846397838464102397838224321959992809292998088384641563846415639783846410239789580958788889595884156384641563846384641563978397896819688898996968941573847415738473847415739793979808080878087928095420038223846382238463579382235798985908580878880803822357938223579357938223579432180809295959595-3579425135794251382235794251382295988080809985999242514321425143213579425138224321878587959980879288432141024321410242514321357943218095998587929580924102397841023978432141024251382292808792808595888539783846397838464102397838224321959992809292998088384641563846415639783846410239789580958788889595884156384641563846384641563978397896819688898996968941573847415738473847415739793979808080878087928095420038223846382238463579382235798985908580878880803822357938223579357938223579432180809295959595-357942513579425138223579425138229598808080998599924251432142514321357942513822432187858795998087928843214102432141024251432135794321809599858792958092410239784102397843214102425138229280879280859588853978384639783846410239783822432195999280929299808838464156384641563978384641023978员工年终评核-年终奖发放统计表每月表现40%客户可根据实际情况修改奖金阶层(名次、对应奖金、工龄奖金基数均可修改），函数表会自动更新员工的应发奖金。9580958788889595884156384641563846384641563978397896819688898996968941573847415738473847415739793979迟到得分事假得分病假得分旷工得分上班天数每月表现每月产量年终评分年终排名应发奖金5%10%5%5%5%40%30%9月10月11月12月每次到1次扣0.5分每请假1天扣1分每请假1天扣0.5分每次扣2分上班天数*百分比全年平均*百分比全年平均*百分比基本奖金38223822432143212.59.54.75513.234.123.492.4525-38223579432139783.574.5310.733.622.985.1237-35794251-210551335.423.493.7413-4251432139783978385511.335.824.892.8721-432142513978397807.54.5510.934.824.987.6633-410238223978425109.54411.235.724.488.8429-3978397843214321493.75512.634.624.293.1817-38463978397839785104.75513.136.123.897.74180004156425143213978495513.136.224.396.625500041574252432239793.58.884.94413.136.624.395.399300038223822432143212.59.54.75513.234.123.492.4525-38223579432139783.574.5310.733.622.985.1237-35794251-210551335.423.493.7413-4251432139783978385511.335.824.892.8721-432142513978397807.54.5510.934.824.987.6633-410238223978425109.54411.235.724.488.8429-3978397843214321493.75512.634.624.293.1817-38463978397839785104.75513.136.123.897.74180004156425143213978495513.136.224.396.625500041574252432239793.58.884.94413.136.624.395.399300038223822432143212.59.54.75513.234.123.492.4525-38223579432139783.574.5310.733.622.985.1237-35794251-210551335.423.493.7413-4251432139783978385511.335.824.892.8721-432142513978397807.54.5510.934.824.987.6633-410238223978425109.54411.235.724.488.8429-3978397843214321493.75512.634.624.293.1817-38463978397839785104.75513.136.123.897.74180004156425143213978495513.136.224.396.625500041574252432239793.58.884.94413.136.624.395.399300038223822432143212.59.54.75513.234.123.492.4525-38223579432139783.574.5310.733.622.985.1237-35794251-210551335.423.493.7413-4251432139783978385511.335.824.892.8721-432142513978397807.54.5510.934.824.987.6633-410238223978425109.54411.235.724.488.8429-3978397843214321493.75512.634.624.293.1817-38463978397839785104.75513.136.123.897.74180004156425143213978495513.136.224.396.625500041574252432239793.58.884.94413.136.624.395.3993000工龄奖金合计1909190918891889188818881888188818811881178817881729172916979697165666561655465519091909188918891888188818881888188118811788178817291729169796971656665616554655190919091889188918881888188818881881188117881788172917291697969716566656165546551909190918891889188818881888188818811881178817881729172916979697应发奖金1656665616554655