计件工资管理系统带工资条表

Docer 牛图文设计公司,今天是:2018年7月11日【星期三】,1.基本工资表录入员工信息，工序单价表录入工序信息,2.生产数据表，日起，员工编号，工序编号双击选择，其他手录,3.工序数量统计表，点击查询按钮，选择起止日期，自动生成统计报表,4.计件工资统计表，点击查询按钮，选择起止日期，自动生成统计报表,5.计件工资查询表，点击查询按钮，选择起止日期和员工信息，自动生成明细记录,6.工资明细表，工号，姓名可复制基本工资表数据，注意合计上方保留一空行，计件工资、夜班费、其他根据计件工资统计表数据生成,公式可根据实际需要自行修改,7.工资明细表点击工资条按钮，即可自动生成对应日期工资条,必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw,员工编号姓名基本工资,YG001员工1,YG002员工2,YG003员工3900.0,YG004员工4,YG005员工5,YG006员工6,YG007员工7,YG008员工8,YG009员工9,YG010员工10,YG011员工11,YG012员工12,YG013员工13,YG014员工14,YG015员工15,YG016员工16,YG017员工17,YG018员工18,YG019员工19,YG020员工20,YG021员工21,产品工序代码工序名称单价,产品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,日期员工编号姓名工序编号工序名称单价计件数量计件工资夜班费其它,YG001员工11001.0车外圆55.020.9,YG002员工21002.0铣平面36.013.68,YG003员工31003.0钻孔0.33274.024.568,YG004员工41004.0磨平面1.0844.047.52,YG005员工51005.0装配10.32257.018.354,YG006员工61006.0装配20.31364.020.032,YG007员工72001.0裁剪63.023.94,YG008员工82002.0拷边0.30876.023.408,YG009员工91004.0磨平面1.0842.045.36,YG010员工103001.0裁剪0.867.053.6,YG011员工113002.0划剪大0.34256.019.152,YG012员工123003.0划剪中0.5252.027.04,YG013员工133004.0划剪小0.33244.014.608-20.0,YG014员工143005.0缝制大0.45539.017.745,YG015员工153006.0缝制中0.3559.020.65,YG016员工163007.0缝制小0.65532.020.96,YG017员工173008.0大卷边0.432.012.8,YG018员工181001.0车外圆50.019.0,YG001员工11006.0装配20.31320.06.26,工序数量统计表,2018-2-1~2018-2-28,工序编号工序名称单价计件数量计件工资,1001.0车外圆105.039.9,1002.0铣平面36.013.68,1003.0钻孔0.33274.024.568,1004.0磨平面1.0886.092.88,1005.0装配10.32257.018.354,1006.0装配20.31384.026.292,2001.0裁剪63.023.94,2002.0拷边0.30876.023.408,2003.0缝口袋0.32,2004.0总缝0.57,2005.0装拉链0.32,3001.0裁剪0.867.053.6,3002.0划剪大0.34256.019.152,3003.0划剪中0.5252.027.04,3004.0划剪小0.33244.014.608,3005.0缝制大0.45539.017.745,3006.0缝制中0.3559.020.65,3007.0缝制小0.65532.020.96,3008.0大卷边0.432.012.8,3009.0中卷边0.48,3010.0小卷边0.37,3011.0封口0.328,3012.0订商标0.54,总计10.277962.0449.577,计件工资统计表,2018-2-1~2018-2-28,员工编码姓名计件数量计件工资夜班费其它,YG001员工175.027.16,YG002员工236.013.68,YG003员工374.024.568,YG004员工444.047.52,YG005员工557.018.354,YG006员工664.020.032,YG007员工763.023.94,YG008员工876.023.408,YG009员工942.045.36,YG010员工1067.053.6,YG011员工1156.019.152,YG012员工1252.027.04,YG013员工1344.014.608-20.0,YG014员工1439.017.745,YG015员工1559.020.65,YG016员工1632.020.96,YG017员工1732.012.8,YG018员工1850.019.0,YG019员工19,YG020员工20,YG021员工21,总计962.0449.57715.0-20.0,计件工资查询表,员工编号YG001姓名员工12018-2-1~2018-2-28,日期工序名称单价计件数量计件工资夜班费其它,43132.0车外圆0.3855.020.95.0,43132.0装配20.31320.06.26,总计75.027.165.00.0,工资明细表,序号工号姓名应付工资应付工资,合计应扣工资应扣工资,合计实发工资,固定工资计件工资质量奖全勤奖夜班费其它养老保险医疗保险所得税,1.0YG001员工127.161102.161002.16,2.0YG002员工213.68883.68803.68,3.0YG003员工3900.024.568994.56872.018.090.0904.568,4.0YG004员工447.521122.521022.52,YG005员工518.354868.354788.354,6.0YG006员工620.032880.032800.032,7.0YG007员工723.94883.94803.94,8.0YG008员工823.408883.408803.408,9.0YG009员工945.36910.36830.36,YG010员工1053.6903.6823.6,11.0YG011员工1119.152879.152799.152,12.0YG012员工1227.0430.01067.04967.04,13.0YG013员工1314.608-20.0854.608774.608,14.0YG014员工1417.745877.745797.745,15.0YG015员工1520.65880.65800.65,YG016员工1620.96880.96800.96,17.0YG017员工1712.8872.8792.8,18.0YG018员工1819.0879.0799.0,19.0YG019员工19,YG020员工20,21.0YG021员工21,合计17500.0449.5771070.0190.015.0-20.019204.5771400.0350.01750.017454.577,1.0YG001员工127.161102.161002.16,2.0YG002员工213.68883.68803.68,3.0YG003员工3900.024.568994.56872.018.090.0904.568,4.0YG004员工447.521122.521022.52,YG005员工518.354868.354788.354,6.0YG006员工620.032880.032800.032,7.0YG007员工723.94883.94803.94,8.0YG008员工823.408883.408803.408,9.0YG009员工945.36910.36830.36,YG010员工1053.6903.6823.6,11.0YG011员工1119.152879.152799.152,12.0YG012员工1227.0430.01067.04967.04,13.0YG013员工1314.608-20.0854.608774.608,14.0YG014员工1417.745877.745797.745,15.0YG015员工1520.65880.65800.65,YG016员工1620.96880.96800.96,17.0YG017员工1712.8872.8792.8,18.0YG018员工1819.0879.0799.0,19.0YG019员工19,YG020员工20,21.0YG021员工21