3 计件工资管理系统（明细对账生产量统计） (2).xlsx

工工序序明明细细表表员员工工计计件件工工资资表表产产量量统统计计表表员员工工工工序序查查询询员员工工信信息息表表工工序序价价格格表表生生产产工工序序查查询询使使用用说说明明计件工资管理系统Piecework salary management system员员工工工工序序查查询询使使用用说说明明工工序序记记录录明明细细表表日日期期员员工工编编号号 员员工工姓姓名名班班组组工工序序名名称称单单价价数数量量 合合计计金金额额2019/4/2N001张1甲切割0.8264211.22019/4/2N002张2甲抛光1.2483579.62019/4/2N003张3甲组合0.9394354.62019/4/2N004张4甲测量0.52961482019/4/2N005张5乙包装0.6353211.82019/4/2N006张6乙切割0.8459367.22019/4/2N007张7乙抛光1.2283339.62019/4/2N008张8乙组合0.9281252.92019/4/3N009张9丙测量0.54422212019/4/3N010张10丙包装0.64602762019/4/3N011张11丙切割0.8208166.42019/4/3N012张12丙抛光1.22603122019/4/3N001张1甲组合0.9401360.92019/4/3N002张2甲测量0.5363181.52019/4/3N003张3甲包装0.6482289.22019/4/3N004张4甲切割0.8308246.42019/4/4N005张5乙抛光1.2302362.42019/4/4N006张6乙组合0.9289260.12019/4/4N007张7乙测量0.5419209.52019/4/4N008张8乙包装0.6323193.8000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004 4 月月份份员员工工提提成成汇汇总总表表员员工工编编号号 员员工工姓姓名名 计计件件工工资资基基本本工工资资补补贴贴工工资资合合计计N001张1572.115002002272.1N002张2761.115002002461.1N003张3643.815002002343.8N004张4394.415002002094.4N005张5574.215002002274.2N006张6627.315002002327.3N007张7549.115002002249.1N008张8446.715002002146.7N009张922115002001921N010张1027615002001976N011张11166.415002001866.4N012张12312150020020120000000000000000000000000000生生产产工工序序查查询询工工序序名名称称切割查查询询日日期期至至日日期期员员工工编编号号 员员工工姓姓名名班班组组工工序序名名称称单单价价数数量量 合合计计金金额额2019/4/2N001张1甲切割0.8264211.22019/4/2N006张6乙切割0.8459367.22019/4/3N011张11丙切割0.8208166.42019/4/3N004张4甲切割0.8308246.44 4 月月份份统统计计分分析析员员工工工工序序统统计计表表班班组组工工序序统统计计表表 工工序序员员工工切切割割抛抛光光组组合合测测量量包包装装合合计计 工工序序班班组组切切割割抛抛光光N0012640401000665甲572483N0020483036300846乙459585N0030039404820876丙208260N004308002960060400N005030200353065500N006459028900074800N007028304190070200N0080028103230604合合计计1239123913281328N00900044200442N01000004600460N01120800000208N01202600000260000000000000000000000000000000000000000000合合计计12391239132813281365136515201520161816180 070707070组组合合测测量量包包装装合合计计7956594820299157041967602709044246001370000000000000000000001365136515201520161816180 070707070班班组组工工序序统统计计表表员员工工工工序序明明细细查查询询员员工工编编号号N001工工序序名名称称起起2019/4/1止止2019/4/10日日期期员员工工编编号号 员员工工姓姓名名班班组组工工序序名名称称单单价价数数量量合合计计金金额额2019/4/2N001张1甲切割0.8264211.22019/4/3N001张1甲组合0.9401360.9查询条件中的员工和工序可自由选择员员工工信信息息表表员员工工编编号号姓姓名名班班组组N001张1甲N002张2甲N003张3甲N004张4甲N005张5乙N006张6乙N007张7乙N008张8乙N009张9丙N010张10丙N011张11丙N012张12丙工工序序对对照照表表工工序序名名称称单单价价/元元切割0.8抛光1.2组合0.9测量0.5包装0.6使使用用说说明明1 1、首首先先在在【员员工工信信息息表表】中中登登记记员员工工信信息息，其其次次在在【工工序序对对照照表表】中中登登记记工工序序信信息息2 2、每每天天在在【工工序序记记录录明明细细表表】记记录录每每日日生生产产详详细细信信息息，姓姓名名、班班组组、单单价价、金金额额可可以以自自动动生生成成，不不须须录录入入3 3、【员员工工提提层层汇汇总总表表】第第一一次次使使用用前前需需要要录录入入员员工工编编号号，以以后后再再次次查查询询只只需需录录入入月月份份就就可可以以查查出出详详细细信信息息，如如果果没没有有基基本本工工资资和和补补助助可可以以不不录录4 4、【统统计计分分析析表表】首首次次使使用用时时把把标标题题栏栏的的内内容容修修改改成成用用户户真真实实的的员员工工编编号号及及工工序序名名称称，并并输输入入需需要要统统计计的的月月份份即即可可5 5、【员员工工工工序序明明细细查查询询】只只要要录录入入起起止止及及员员工工编编码码或或者者工工序序名名称称就就可可以以查查询询出出相相应应的的明明细细6 6、【工工序序查查询询表表】只只需需输输入入工工序序名名称称即即可可查查询询相相关关内内容容，时时间间不不设设置置默默认认为为不不做做要要求求