工资表-公式计算.xlsx

人员编号姓名部门人员类别标准工资租房补贴责任工资加班费补计件工资住房补助工龄工资福利费绩效职称应发合计缺勤四项基金合计扣款合计实发合计20225张金龙二处办公室本市农民工1700 0 0 313 6687 0 60 0 0 0 8760 0 619.4619.48140.600786徐心刚二处维修班城镇工1560 0 0 431 7869 70 300 0 0 500 10730 0 20012001872900861年元桥二处维修班城镇工1560 0 0 431 6369 70 285 0 0 300 9015 0 1595.851595.857419.1501872李紫岩二处维修班本市农民工1560 130 0 466 1534 0 30 0 0 0 3720 0 306.28306.283413.7230016张建军二处维修班外埠农民工1560 130 0 179 3721 0 285 0 0 0 5875 0 439439543630056冀东亮二处维修班外埠城镇工2000 130 0 368 3432 0 240 0 0 0 6170 0 1048.421048.425121.5800991岳金浩二处收口甲班城镇工1600 0 0 0 4250 70 240 0 0 0 6160 0 1362.551362.554797.4501168闫永石二处收口甲班城镇工1560 130 0 0 5800 70 195 0 0 0 7755 0 1294.541294.546460.4601203冯树旺二处收口甲班城镇工1560 130 0 108 7092 70 165 0 0 0 9125 0 1616.441616.447508.5630200李志国二处收口甲班外埠城镇工1560 130 0 0 2250 0 150 0 0 0 4090 0 385.19385.193704.8131419邓松二处收口甲班外埠农民工1560 130 0 287 2563 0 45 0 0 0 4585 0 344.76344.764240.2432287范来二处收口甲班外埠农民工1560 130 0 0 2350 0 0 0 0 0 4040 0 257.88257.883782.1201001夏常明二处收口乙班城镇工1560 0 0 646 6554 70 240 0 0 0 9070 0 1723.41723.47346.620007田英红二处收口乙班城镇工1560 130 0 287 5513 70 300 0 0 0 7860 0 1375.671375.676484.3320012肖建文二处收口乙班城镇工1560 130 0 0 2200 70 270 0 0 0 4230 0 1046.41046.43183.630033蔡二军二处收口乙班外埠农民工1560 130 0 0 5800 0 270 0 0 0 7760 0 553.1553.17206.930048刘小平二处收口乙班外埠农民工1560 130 0 646 2004 0 240 0 0 0 4580 0 404404417630131戴业廷二处收口乙班外埠农民工1560 130 0 0 2000 0 165 0 0 0 3855 0 43543534200 000 000 000 000 000 000 00