经济法概论作业.xls

1、批次工资汇总表厂名 年月 车间名称合计 - - -序号 批次 车间名称 计件工资 计时工资 补贴12员工产量汇总表（验证）年月 2016年12月 工段名称 厂名2厂名 总检中心 员工姓名 车间名称合计 802,167.68 - - - 802,167.68员工编号 员工姓名 计件工资 计时工资 补贴 奖罚 本批工资合计曹斌 3981.8683 - 0 0 3,981.87陈丹 3968.7359 - 0 0 3,968.74陈建光 5149.4635 - 0 0 5,149.46陈萍川 3608.354 - 0 0 3,608.35陈群英 3360.8385 - 0 0 3,360.84陈小艳

2、 4883.8342 - 0 0 4,883.83邓满香 3070.5615 - 0 0 3,070.56邓全恩 4464.2565 - 0 0 4,464.26丁梅 4647.1436 - 0 0 4,647.14方凤英 3211.1772 - 0 0 3,211.18冯柳 3195.7137 - 0 0 3,195.71甘家威 4782.6555 - 0 0 4,782.66甘礼辉 1907.7877 - 0 0 1,907.79龚秋林 4220.1177 - 0 0 4,220.12郭容清 5850.0356 - 0 0 5,850.04郭准 4796.6345 - 0 0 4,796.

3、63何长秀 4372.6224 - 0 0 4,372.62何玉军 3494.6314 - 0 0 3,494.63何玉平 5873.5038 - 0 0 5,873.50胡强 3955.7383 - 0 0 3,955.74胡嵩 4806.9555 - 0 0 4,806.96胡源 963.6653 - 0 0 963.67黄材峰 3796.5614 - 0 0 3,796.56黄春红 1390.7978 - 0 0 1,390.80黄丹 4072.983 - 0 0 4,072.98黄国军 3474.1184 - 0 0 3,474.12黄娇娜 3828.5649 - 0 0 3,828.

4、56黄清根 3964.1637 - 0 0 3,964.16黄秋华 5045.8388 - 0 0 5,045.84黄群英 3937.3618 - 0 0 3,937.36黄绍兰 4980.9872 - 0 0 4,980.99黄霞 4551.9074 - 0 0 4,551.91黄小燕 2863.4677 - 0 0 2,863.47黄艳 1037.9831 - 0 0 1,037.98黄艳平 5075.3077 - 0 0 5,075.31黄祖伟 4470.9185 - 0 0 4,470.92乐文萍 3564.4925 - 0 0 3,564.49黎晓利 3195.6159 - 0 0

5、3,195.62李波 852.8472 - 0 0 852.85李冬连 3039.241 - 0 0 3,039.24李根文 5817.073 - 0 0 5,817.07李江湖 2966.2456 - 0 0 2,966.25李俊杰 2466.0511 - 0 0 2,466.05李亮 2329.4791 - 0 0 2,329.48李清兰 3469.6726 - 0 0 3,469.67李秋红 3840.8751 - 0 0 3,840.88李秀华 4321.5318 - 0 0 4,321.53李竹青 4603.6888 - 0 0 4,603.69梁国平 3696.2408 - 0 0

6、 3,696.24梁平秀 4599.8643 - 0 0 4,599.86廖海军 3450.3736 - 0 0 3,450.37廖学文 1753.7784 - 0 0 1,753.78林红根 3923.7152 - 0 0 3,923.72林江 3245.8713 - 0 0 3,245.87林军 4376.9205 - 0 0 4,376.92林小军 3484.9293 - 0 0 3,484.93凌思东 3507.8147 - 0 0 3,507.81刘波 4031.1238 - 0 0 4,031.12刘德古 2715.2674 - 0 0 2,715.27刘风 4164.261 -

7、0 0 4,164.26刘广龙 4945.8954 - 0 0 4,945.90刘后青 4218.9469 - 0 0 4,218.95刘欢平 3961.0186 - 0 0 3,961.02刘坚 4715.9909 - 0 0 4,715.99刘金雁 2900.8379 - 0 0 2,900.84刘全古 4872.0494 - 0 0 4,872.05刘细牙 2864.323 - 0 0 2,864.32刘雪芬 3770.4144 - 0 0 3,770.41刘运连 4482.3023 - 0 0 4,482.30柳兰香 4271.838 - 0 0 4,271.84卢建根 3621.23

8、75 - 0 0 3,621.24卢金连 1737.4433 - 0 0 1,737.44卢晚秀 3092.1477 - 0 0 3,092.15卢正枚 3379.1051 - 0 0 3,379.11卢钻 3488.5263 - 0 0 3,488.53罗莎欧 2869.3343 - 0 0 2,869.33聂陆 3883.5098 - 0 0 3,883.51聂友生 3241.5632 - 0 0 3,241.56欧阳礼秀 5522.4777 - 0 0 5,522.48欧阳小华 5179.2012 - 0 0 5,179.20潘会明 4316.8547 - 0 0 4,316.85彭光勇

9、 4000.2713 - 0 0 4,000.27彭广洪 3491.6991 - 0 0 3,491.70彭红 3422.1554 - 0 0 3,422.16彭清玲 4320.0454 - 0 0 4,320.05彭绍园 2909.3882 - 0 0 2,909.39彭圣军 4138.9706 - 0 0 4,138.97彭小连 3785.3797 - 0 0 3,785.38彭云 4809.6278 - 0 0 4,809.63彭竹艳 3101.9421 - 0 0 3,101.94宋春梅 2472.7846 - 0 0 2,472.78苏丽娜 3979.7765 - 0 0 3,979

10、.78苏艳 3033.902 - 0 0 3,033.90孙斌 3515.1919 - 0 0 3,515.19孙玉琴 3379.4164 - 0 0 3,379.42谭荷音 4310.2035 - 0 0 4,310.20谭志伟 4531.7313 - 0 0 4,531.73汤凤娇 3483.603 - 0 0 3,483.60汤桂金 3454.9343 - 0 0 3,454.93汤志环 4710.8373 - 0 0 4,710.84唐锋 5290.0397 - 0 0 5,290.04汪闵娜 1595.7267 - 0 0 1,595.73王东存 3138.5437 - 0 0 3,

11、138.54王娟 5250.661 - 0 0 5,250.66王勤 4190.7221 - 0 0 4,190.72王艳梅 4467.1926 - 0 0 4,467.19吴爱兰 4429.963 - 0 0 4,429.96吴海芳 4115.6675 - 0 0 4,115.67吴金华 2924.0916 - 0 0 2,924.09吴茂生 2967.2794 - 0 0 2,967.28吴宜平 4395.0593 - 0 0 4,395.06武小妹 1018.3278 - 0 0 1,018.33习招 3517.299 - 0 0 3,517.30夏爱兰 4912.5547 - 0 0

12、4,912.55夏春连 2139.1534 - 0 0 2,139.15夏绍春 5199.8668 - 0 0 5,199.87夏小艳 3383.5414 - 0 0 3,383.54夏俞 5387.9986 - 0 0 5,388.00肖恩洲 4264.9654 - 0 0 4,264.97谢桂文 5060.9338 - 0 0 5,060.93谢海涛 5683.564 - 0 0 5,683.56谢检平 405.9501 - 0 0 405.95谢金根 533.9224 - 0 0 533.92谢南昌 3607.3319 - 0 0 3,607.33谢运兰 4873.2897 - 0 0

13、4,873.29辛生华 4637.0314 - 0 0 4,637.03徐春梅 3524.7483 - 0 0 3,524.75徐宽 674.0397 - 0 0 674.04徐水英 3949.1834 - 0 0 3,949.18徐文燕 2574.5658 - 0 0 2,574.57徐兴秀 3212.5852 - 0 0 3,212.59许秋花 3177.2592 - 0 0 3,177.26晏敏 3308.488 - 0 0 3,308.49阳娜 3444.2008 - 0 0 3,444.20杨康 847.2813 - 0 0 847.28杨帅 3472.2232 - 0 0 3,47

14、2.22杨正伟 5609.3204 - 0 0 5,609.32姚松华 3133.2538 - 0 0 3,133.25叶春根 2785.881 - 0 0 2,785.88叶桂华 4597.7555 - 0 0 4,597.76叶勇 28.1329 - 0 0 28.13叶勇明 2818.2666 - 0 0 2,818.27易春艳 5532.7934 - 0 0 5,532.79易德发 4027.4615 - 0 0 4,027.46易橄德 865.2953 - 0 0 865.30易华婷 3750.9318 - 0 0 3,750.93易娟娟 3825.734 - 0 0 3,825.7

15、3易美金 2896.7573 - 0 0 2,896.76易轻艳 3383.5188 - 0 0 3,383.52易清发 2620.375 - 0 0 2,620.38易清瑞 3428.3073 - 0 0 3,428.31易婷 4207.912 - 0 0 4,207.91易锡文 3723.1473 - 0 0 3,723.15易细连 2792.3169 - 0 0 2,792.32易雪梅 1130.4652 - 0 0 1,130.47易艳平 3632.8788 - 0 0 3,632.88易宜永 3902.987 - 0 0 3,902.99易友生 5044.6254 - 0 0 5,0

16、44.63易舟 3716.119 - 0 0 3,716.12易族华 3730.9379 - 0 0 3,730.94尹海艳 3953.5626 - 0 0 3,953.56于大军 4303.1623 - 0 0 4,303.16余干云 3576.5315 - 0 0 3,576.53余根牙 4519.08 - 0 0 4,519.08余顺根 4858.9475 - 0 0 4,858.95袁丹 935.1982 - 0 0 935.20袁凤英 4609.8645 - 0 0 4,609.86袁桂连 2900.8402 - 0 0 2,900.84袁国华 3191.6327 - 0 0 3,1

17、91.63袁红林 5849.3011 - 0 0 5,849.30袁会莲 3927.6582 - 0 0 3,927.66袁娇丽 4138.2381 - 0 0 4,138.24袁金金 3762.8668 - 0 0 3,762.87袁金玉 4010.1063 - 0 0 4,010.11袁军 4476.8013 - 0 0 4,476.80袁俊 3236.0734 - 0 0 3,236.07袁娜 2542.1585 - 0 0 2,542.16袁苏丹 4386.3378 - 0 0 4,386.34袁小军 3736.1815 - 0 0 3,736.18袁学良 4729.5807 - 0

18、0 4,729.58袁艳平 4366.0265 - 0 0 4,366.03袁友军 3098.681 - 0 0 3,098.68袁宇林 2142.1116 - 0 0 2,142.11臧清杰 3432.5721 - 0 0 3,432.57曾吕 5888.1666 - 0 0 5,888.17曾逃发 5000.2898 - 0 0 5,000.29翟殿敏 4082.5776 - 0 0 4,082.58张本来 4089.3084 - 0 0 4,089.31张从连 3153.6805 - 0 0 3,153.68张分秀 3858.3193 - 0 0 3,858.32张杰 4509.8546

19、 - 0 0 4,509.85张军 4128.7596 - 0 0 4,128.76张配交 4860.9371 - 0 0 4,860.94张小芳 4282.0987 - 0 0 4,282.10张小连 3249.7856 - 0 0 3,249.79赵风琴 4035.1138 - 0 0 4,035.11郑国信 4767.3947 - 0 0 4,767.39郑伟明 3983.6251 - 0 0 3,983.63郑学信 4857.8023 - 0 0 4,857.80钟健健 1701.8009 - 0 0 1,701.80钟军 4479.2489 - 0 0 4,479.25钟艳玲 488

20、7.4827 - 0 0 4,887.48钟杨 3118.3716 - 0 0 3,118.37周阿玲 2860.4103 - 0 0 2,860.41周冬秀 3300.0563 - 0 0 3,300.06周海艳 2450.8776 - 0 0 2,450.88周利 3534.2118 - 0 0 3,534.21周年香 3180.1606 - 0 0 3,180.16周瑞 3883.3271 - 0 0 3,883.33周婷 2837.0904 - 0 0 2,837.09周小兰 1299.5544 - 0 0 1,299.55周燕平 4102.7536 - 0 0 4,102.75周益成

21、 3730.0157 - 0 0 3,730.02周媛 3769.0681 - 0 0 3,769.07朱倩 5276.6565 - 0 0 5,276.66邹丽 4027.0269 - 0 0 4,027.03邹武 2941.4365 - 0 0 2,941.44邹小波 1935.3672 - 0 0 1,935.37802,166.59 - 1.09工资表已执行计件1 工资表已执行计件2 工资表未执行金额 join_id 实出勤(天) 平均每天工资3,981.86 0.01 14879 26 153.153,968.73 0.01 13869 27 146.995,149.46 0.00

22、14402 27 190.723,608.35 0.00 12305 26 138.783,360.83 0.01 13442 26 129.264,883.83 0.00 13574 26 187.843,070.56 0.00 12453 27 113.724,464.25 0.01 13981 24 186.014,647.14 0.00 13511 26 178.743,211.17 0.01 10859 23 139.623,195.71 0.00 13732 26.5 120.594,782.65 0.01 13046 25 191.311,907.78 0.01 12598 15

23、 127.194,220.11 0.01 14349 27.5 153.465,850.03 0.01 4821 26 225.004,796.63 0.00 14355 25 191.874,372.62 0.00 14853 28 156.173,494.63 0.00 11365 26 134.415,873.50 0.00 12580 28 209.773,955.73 0.01 14588 25.5 155.134,806.95 0.01 14863 26.5 181.39963.66 0.01 14254 8 120.463,796.56 0.00 8746 22.5 168.74

24、1,390.79 0.01 7085 7 198.694,072.98 0.00 15109 25 162.923,474.11 0.01 8425 21.5 161.593,828.56 0.00 14613 25 153.143,964.16 0.00 12380 28.5 139.095,045.83 0.01 11606 26 194.073,937.36 0.00 14506 26 151.444,980.98 0.01 12996 26 191.584,551.90 0.01 14321 25 182.082,863.46 0.01 15036 26 110.131,037.98

25、0.00 14414 8 129.755,075.30 0.01 13047 26 195.20员工产量汇总表（验证）4,470.91 0.01 13398 26 171.963,564.49 0.00 14141 22.5 158.423,195.61 0.01 10296 22.5 142.03852.84 0.01 6559 18 47.383,039.24 0.00 9578 24 126.645,817.07 0.00 14390 27 215.452,966.24 0.01 13401 25.5 116.322,466.05 0.00 12710 27 91.342,329.47

26、0.01 14966 24.5 95.083,469.67 0.00 3126 23 150.863,840.87 0.01 2414 25 153.644,321.53 0.00 13909 27 160.064,603.68 0.01 11881 25 184.153,696.24 0.00 6644 25 147.854,599.86 0.00 10306 25 183.993,450.37 0.00 16321 22 156.841,753.77 0.01 14989 14 125.273,923.71 0.01 14425 25 156.953,245.87 0.00 11958 2

27、2.5 144.264,376.92 0.00 14869 26 168.343,484.92 0.01 11912 28 124.463,507.81 0.00 13522 26 134.924,031.12 0.00 13934 26 155.042,715.26 0.01 14689 23 118.064,164.26 0.00 14312 24 173.514,945.89 0.01 10371 28 176.644,218.94 0.01 13305 25 168.763,961.01 0.01 13195 26.5 149.474,715.99 0.00 16254 28 168.

28、432,900.83 0.01 14957 22 131.864,872.04 0.01 16255 27 180.452,864.32 0.00 16293 21 136.403,770.41 0.00 10122 23.5 160.444,482.30 0.00 12111 27 166.014,271.83 0.01 8616 29 147.303,621.23 0.01 9873 26 139.281,737.44 0.00 11858 25 69.503,092.14 0.01 14865 22 140.553,379.10 0.01 7758 26 129.973,488.52 0

29、.01 14081 24 145.362,869.33 0.00 14701 27 106.273,883.50 0.01 14404 27 143.833,241.56 0.00 12587 23 140.945,522.47 0.01 14566 28 197.235,179.20 0.00 13192 28 184.974,316.85 0.00 5561 25 172.674,000.27 0.00 12666 26 153.863,491.69 0.01 7167 26.5 131.763,422.15 0.01 8715 23.5 145.624,320.04 0.01 11607

30、 27 160.002,909.38 0.01 8646 25 116.384,138.97 0.00 14841 27.5 150.513,785.37 0.01 12718 26 145.594,809.62 0.01 12731 26 184.993,101.94 0.00 7163 23.5 132.002,472.78 0.00 14309 24 103.033,979.77 0.01 8180 23 173.033,033.90 0.00 11822 23.5 129.103,515.19 0.00 14249 22 159.783,379.41 0.01 13471 25 135

31、.184,310.20 0.00 13845 27 159.644,531.73 0.00 13320 26 174.303,483.60 0.00 6606 25 139.343,454.93 0.00 11599 26.5 130.374,710.83 0.01 12084 26 181.195,290.03 0.01 10202 27 195.931,595.72 0.01 16388 24 66.493,138.54 0.00 6253 22.5 139.495,250.66 0.00 12355 28 187.524,190.72 0.00 13037 27 155.214,467.19 0.00 13864 26.5 168.574,429.96 0.00 12054 23 192.614,115.66 0.01 12360 25 164.632,924.09 0.00 6773 23.5 124.432,967.27 0.01 14350 27.5 107.904,395.05 0.01 13202 27 162.781,018.32 0.01 6888 20 50.923,517.29 0.01 12424 23.5 149.674,912.55 0.00 12431 27 181.952,139.15 0.00 16231 25 85.57