计件工资管理系统表

1、 【基本工资表】【工序单价表】，录入相应资料,2、【生产数据表】双击选择日期,员工,工序，其他手录,3、【工序数量统计表】点击查询按钮，自动生成报表,4、【计件工资统计表】点击查询按钮，自动生成报表,5、【计件工资查询表】双击选择员工，自动生成工资明细报表,6、【工资明细表】橙色列手录，其他自动生成，点击工资条按钮，自动生成工资条,必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw,888888,元炜科技 QQ:417284054,员工工号姓名基本工资,A1001武松,A1002张清,A1003徐宁900.0,A1004戴宗,A1005李逵,A1006穆弘,A1007李俊,A1008张横,A1009张顺,A1010杨雄,A1011解珍,A1012燕青,A1013朱武,A1014孙立,A1015郝思文,A1016魏定国,A1017裴宣,A1018邓飞,A1019杨林,A1020蒋敬,产品工序代码工序名称单价,产品A1001.0车外圆,1002.0铣平面,1003.0钻孔0.332,1004.0磨平面1.08,1005.0装配10.322,1006.0装配20.313,产品B2001.0裁剪,2002.0拷边0.308,2003.0缝口袋0.32,2004.0总缝0.57,2005.0装拉链0.32,产品C3001.0裁剪0.8,3002.0划剪大0.342,3003.0划剪中0.52,3004.0划剪小0.332,3005.0缝制大0.455,3006.0缝制中0.35,3007.0缝制小0.655,3008.0大卷边0.4,3009.0中卷边0.48,3010.0小卷边0.37,3011.0封口0.328,3012.0订商标0.54,日期员工编号姓名工序编号工序名称单价计件数量计件工资夜班费其它,20.9,13.68,24.568,47.52,18.354,20.032,23.94,28.88,45.36,53.6,19.152,27.04,14.608-20.0,17.745,20.65,20.96,12.8,24.0,22.2,12.792,78.025.116,24.472,12.948,48.6,18.998,18.154,77.029.26,16.34,72.36,45.6,27.018,18.72,25.232,22.75,73.025.55,25.545,29.6,19.68,23.68,49.016.072,73.027.74,12.16,75.024.9,36.72,25.438,23.162,12.92,18.24,60.4820.0,30.4,13.68,33.28,18.924,33.67,22.05,30.785,78.031.2,17.28,30.011.1,13.448,20.52,30.02,17.928,62.066.96,66.021.252,14.711,26.22,14.44,64.8,21.888,29.12,17.264,17.29,15.05,31.44,28.8,33.12,28.12,20.664,19.0,51.019.38,17.264,69.12,14.49,10.955,22.04,70.026.6,61.56,28.0,15.048,21.84,20.252,35.945,62.021.7,31.020.305,15.2,26.88,66.024.42,12.792,28.12,12.92,22.244,34.56,17.71,23.788,16.72,23.18,68.04,19.152,17.68,21.248,70.031.85,75.026.25,22.27,27.6,31.2,16.65,25.912,19.76,26.22,77.025.564,31.033.48,18.998,15.65,16.34,37.039.96,11.628,33.28,11.288,23.66,25.9,26.855,28.8,17.28,20.35,15.416,23.18,37.014.06,14.276,62.64,13.524,16.276,24.7,23.94,82.08,43.2,19.836,21.84,13.28,27.755,21.35,41.265,15.6,20.64,30.011.1,24.272,22.244,61.56,51.016.422,22.536,15.96,24.7,70.2,38.4,33.011.286,30.16,17.596,18.2,12.25,43.885,21.6,25.44,19.61,18.04,工序数量统计表,工序编号工序名称单价计件数量计件工资,1001.0车外圆0.38959.0364.42,1002.0铣平面0.38892.0338.96,1003.0钻孔0.332548.0181.936,1004.0磨平面1.08950.01026.0,1005.0装配10.322667.0214.774,1006.0装配20.313528.0165.264,2001.0裁剪,2002.0拷边,2003.0缝口袋,2004.0总缝,2005.0装拉链,3001.0裁剪0.8469.0375.2,3002.0划剪大0.342464.0158.688,3003.0划剪中0.52448.0232.96,3004.0划剪小0.332481.0159.692,3005.0缝制大0.455503.0228.865,3006.0缝制中0.35545.0190.75,3007.0缝制小0.655402.0263.31,3008.0大卷边0.4528.0211.2,3009.0中卷边0.48449.0215.52,3010.0小卷边0.37479.0177.23,3011.0封口0.328486.0159.408,3012.0订商标,总计9798.04664.177,计件工资统计表,员工编号姓名计件数量计件工资夜班费其它,A1001武松542.0201.4365.0,A1002张清459.0170.012,A1003徐宁548.0181.936,A1004戴宗427.0461.1645.0,A1005李逵513.0165.186,A1006穆弘528.0165.264,A1007李俊495.0188.1,A1008张横509.0193.42,A1009张顺523.0564.8445.020.0,A1010杨雄469.0375.2,A1011解珍464.0158.688,A1012燕青448.0232.96,A1013朱武481.0159.692-20.0,A1014孙立503.0228.865,A1015郝思文545.0190.75,A1016魏定国402.0263.31,A1017裴宣528.0211.2,A1018邓飞449.0215.52,A1019杨林479.0177.23,A1020蒋敬486.0159.408,总计9798.04664.17795.0,计件工资查询表,员工编号A1001姓名武松,日期工序名称单价计件数量计件工资夜班费其它,43313.055.020.95.0,43314.0装配10.32278.025.116,43315.073.027.74,43317.054.020.52,43318.050.019.0,43322.074.028.12,43323.052.019.76,43324.061.023.18,43327.045.017.1,总计542.0201.4365.00.0,工资明细表,序号工号姓名应付工资应付工资,合计应扣工资应扣工资,合计实发工资,固定工资计件工资质量奖全勤奖夜班费其它养老保险医疗保险所得税,1.0A1001武松201.4365.01276.4361176.436,2.0A1002张清170.0121040.012960.012,3.0A1003徐宁900.0181.9361151.93672.018.090.01061.936,4.0A1004戴宗461.1645.01576.161476.16,5.0A1005李逵165.1861015.186935.186,6.0A1006穆弘165.2641025.264945.264,7.0A1007李俊188.11048.1968.1,8.0A1008张横193.421053.42973.42,9.0A1009张顺564.8445.01489.841409.84,A1010杨雄375.21225.21145.2,11.0A1011解珍158.6881018.688938.688,12.0A1012燕青232.9630.01272.961172.96,13.0A1013朱武159.692-20.0999.692919.692,14.0A1014孙立228.8651088.8651008.865,15.0A1015郝思文190.751050.75970.75,A1016魏定国263.311123.311043.31,17.0A1017裴宣211.21071.2991.2,18.0A1018邓飞215.521075.52995.52,19.0A1019杨林177.231037.23957.23,A1020蒋敬159.4081019.408939.408,合计16700.04664.1771020.0180.095.022659.1771336.0334.01670.020989.177,1.0A1001武松201.4365.01276.4361176.436,2.0A1002张清170.0121040.012960.012,3.0A1003徐宁900.0181.9361151.93672.018.090.01061.936,4.0A1004戴宗461.1645.01576.161476.16,5.0A1005李逵165.1861015.186935.186,6.0A1006穆弘165.2641025.264945.264,7.0A1007李俊188.11048.1968.1,8.0A1008张横193.421053.42973.42,9.0A1009张顺564.8445.01489.841409.84,A1010杨雄375.21225.21145.2,11.0A1011解珍158.6881018.688938.688,12.0A1012燕青232.9630.01272.961172.96,13.0A1013朱武159.692-20.0999.692919.692,14.0A1014孙立228.8651088.8651008.865,15.0A1015郝思文190.751050.75970.75,A1016魏定国263.311123.311043.31,17.0A1017裴宣211.21071.2991.2,18.0A1018邓飞215.521075.52995.52,19.0A1019杨林177.231037.23957.23,A1020蒋敬159.4081019.408939.408