Excel模板：计件工资管理系统-工序管理-工资汇总.xlsx

计件工资管理系统工序明细记录表个人明细查询表员工工资汇总表产品工序查询表工序汇总表基础信息对照表使用说明员工工作量汇总表计件工资管理系统工序明细记录表日期员工编号员工姓名工序名称工序描述数量单价2017/1/10101name1A1拆边30000.82017/1/15102name2A2裁剪30000.62017/1/20103name3A3封边15000.32017/1/25101name1A4折叠15000.22017/1/30105name5A5对齐10000.42017/2/4101name1A6上料20000.52017/2/9102name2A7收口30000.72017/2/14103name3A8加料30000.42017/2/19104name4A9收线30000.92017/2/24105name5A10打签30000.9合计金额备注240018004503004001000210012002700270000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002017年1月个人明细表员工编号101姓名name1总金额0日期员工编号 员工姓名工序名称工序描述数量单价合计金额备注#101name1A1拆边30000.824000#101name1A4折叠15000.23000产品工序查询工序名称A1起1月1日至1月31日日期员工编号员工姓名工序名称 工序描述数量单价合计金额备注1月10日101name1A1拆边30000.8240002017年2月工资表员工编号员工姓名记件工资基本工资住房补贴饭补总计101name1100010002001002300102name221008002001003200103name312006002001002100104name427006002001003600105name527006002001003600106name6002001003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000工序汇总表2017年2月工序编号工序描述完成数量提成金额A1拆边00A2裁剪00A3封边00A4折叠00A5对齐00A6上料20001000A7收口30002100A8加料30001200A9收线30002700A10打签30002700000000000000000000000000000000000000000000000000000000000000000000000000000000000员工工作量汇总表2017年2月员工编号员工姓名工作总量提成金额101name120001000102name230002100103name330001200104name430002700105name530002700106name600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000基础信息表员工编号姓名工序编号工序描述单价/元101name1A1拆边0.8102name2A2裁剪0.6103name3A3封边0.3104name4A4折叠0.2105name5A5对齐0.4106name6A6上料0.5A7收口0.7A8加料0.4A9收线0.9A10打签0.91、【基础信息对照表】：为基础信息表，使用前需要先在该表中填入相应的基础信息2、【工序明细记录表】：为日常记录表，填写相应的日期、员工编号、工序名称、数量即可，员工姓名、工序描述、单价及合计金额可自动显示3、【个人明细查询表】：可查询某一个员工，某月的明细记录，在该表中输入年、月、员工编号，其他可自动显示4、【员工工资汇总表】：汇总某月所有员工的工资总额，需填入年、月即可，员工编号、员工姓名、记件工资、总计会自动计算生成，住房补贴、基本工资、饭补等根据需要可以录入，也可以不录入5、【产品工序查询表】当某项产品或者工序出现问题，输入相应产品或工序号及对应的时间起止点就可以查询出该时间段的详情6、不需要填写的地方已经用蓝色底纹标示出来7、【员工工作量汇总表】、【工序汇总表】为自动统计表，无须录入，只需输入需要查询的年月即可8、本系统为永久使用性系统，总共包括一个基础信息表，一个日常记录表，其他五个表格全部根据日常记录表生成，用户使用起来极其方便，