《Excel表格模板：计件工资核算表-自动统计员工工资.xlsx》由会员分享，可在线阅读，更多相关《Excel表格模板：计件工资核算表-自动统计员工工资.xlsx（60页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、代代码码姓姓名名基基本本工工资资代代码码工工序序名名称称单单价价重重量量WSG王世高500端端盖盖ZAT张安团60010011001YB2-80前21.75ZH张浩70010021002YB2-80后21.8WWF王文发10031003YB2-80B544.87DJ董江10041004YB2-90后12XYC薛玉成10051005YB2-90前11.95XTG徐田果10061006YB2-90立2.54.87LXP吕学浦10071007YB2-100前33.14CHP陈会平10081008YB2-100后33LX李晓10091009YB2-112前3.43.91WSG王世高10101010YB
2、2-112后44.53ZAT张安团10111011YB2-132前5.56.42ZH张浩10121012YB2-132后66.38WWF王文发10131013YB2-132 B351012.6DJ董江10141014YB2-132 B51012.7XYC薛玉成10151015YB2-160-2P8.78.98XTG徐田果10161016YB2-160-4P8.78.3LXP吕学浦10171017YB2-180-2P9.811.2CHP陈会平10181018YB2-180-4P212.97LX李晓10191019YB2-200-2P31410201020YB2-200-4P416.1102110
3、21YB2-225-2P52010221022YB2-225-4P62110231023YB2-250-4P725.610241024YB2-280-2P83110251025YB2-280-4P93110261026YB3-71前101.610271027YB3-71后111.410281028YB3-80前12210291029YB3-80后131.7210301030YB3-80闷141.7610311031YB3-80-B35154.3410321032YB3-80-B5164.410331033YB3-90前17210341034YB3-90后182.1210351035YB3-90
4、后闷192.1210361036YB3-90-B35204.5910371037YB3-90-B521510381038YB3-100前223.510391039YB3-100后233.6510401040YB3-100-B35247.1310411041YB3-100-B5257.6110421042YB3-100-B3立端262.9210431043YB3-112-B5279.5810441044AIMUR-160-2P端盖2810.410451045AIMUR-160-4P端盖2911.210461046AIMUR-180-2P端盖3013.3610471047Y2 180 4P（俄）3
5、19.510481048Y2VP 315324010491049Y2VP 3553359.410501050Y2 400盖3419.310511051Y2 400座3552.210521052Y2 225-4端盖（俄）3615.710531053Y2 225 4P B5（俄）374410541054Y2 200 4P B5（俄）3825.410551055NEPM 184端盖39410561056NEPM 213端盖405.910571057YB3 90前端（马来西亚）412.410581058YB3 100前端（马来西亚）423.610591059YB3 112前端（马来西亚）4351060
6、1060YB3 132前端（马来西亚）44710611061YB3 355 2P CT44585.510621062YB3 355 4P CT4469010631063YB3 355-2端盖4777.610641064YB3 355-4P端盖4881.810651065AIMU M16盒座（三孔）4943.610661066AIMU-160-4P B3501010671067NE 404 2P外盖512.810681068NE 444 4P内盖5251069106982*82压板530.651070107076*76压板540.591071107190*90压板550.810721072126
7、*126压板561.5510731073160*160压板572.510741074M5斗580.6710751075M6斗590.810761076M6斗（带护圈）600.9910771077M10斗（带护圈）612.310781078M16斗（带护圈）623.910791079AIMU M8斗(带护圈）631.9410801080M8斗641.6110811081M16斗653.910821082YB3-M5小盒盖662.310831083YB3-M5大盒盖673.4610841084YB3-M6盒盖683.5610851085YB2-M5小盒座694.5710861086YB2-M5大盒
8、座706.1110871087YB2-M6盒座717.510881088YB2-M8盒座7210.810891089YB2-M16盒座7339.510901090YB2-M5大盒座CT4749.1210911091YB2-M6盒盖CT475310921092YB2-M6盒座CT47612.6210931093YB3 M5大方盒座（新平底）778.110941094YB3 M5小方座（大中模具）786.810951095M5小方盒座（自家模具）796.410961096AIMU M10盒座（三孔）8024.310971097AIMU M16盒座（三孔）8143.610981098AIMUR M5
9、座828.410991099AIMUR M6座8315.2511001100YB3 M5小方盒盖841.8轴轴承承盖盖20012001YB2-180-2P内22.320022002YB2-180-2P外31.620032003YB2-180-4P内42.7220042004YB2-200-2P内52.5120052005YB2-200-2P外61.8420062006YB2-200-2P外闷72.2920072007YB2-200-4P内82.9320082008YB2-200-4P外92.1520092009YB2-200-4P外闷102.620102010YB2-225-2P内113.65
10、20112011YB2-225-2P外123.620122012YB2-225-4P外133.620132013YB2-250-2P外144.2820142014YB2-250-4P内153.3520152015YB2-280-2P内164.2420162016YB2-280-4P内175.3920172017YB2-280-2P外183.620182018YB2-280-4P外19420192019YB3 315 4P外盖207.320202020YB2-250-2P内213.3520212021YB2-250-2P外223.3520222022YB3 355 2P外（止口加6mm)2372
11、0232023YB3 355 2P闷（止口加6mm)248.120242024NE 404 2P外盖252.820252025NE 444 4P内盖26520262026AIMU M16盒座2742.2520272027AIMU M16接线盒板2813.620282028YB3 250立端B5 4P2949.720292029VASO-225前3023.820302030VASO-225后3122.820312031YB3 250油环321.220322032YB3 280油环331.520332033112法兰B5349.520342034132法兰B5351120352035 M16压板（
12、带护圈）360.720362036YB3 200 2P闷盖372.220372037YB3 250 2P闷盖383.820382038YB3 280 2P闷盖394.120392039YB3 315 4P闷盖407.520402040YB3 100 闷盖413.120412041YB3 112闷盖424.520422042YB3 132闷盖436.520432043280风罩4481.2日日期期姓姓名名编编号号姓姓名名编编号号工工序序名名称称单单价价造造型型数数量量 计计件件 数数量量计计件件工工资资03/15ZAT张安团1001YB2-80前23006001200.0003/16ZAT张安团
13、1002YB2-80后23006001200.0003/17ZAT张安团1003YB2-80B542008003200.0003/18ZH张浩1024YB2-280-2P8201160812864.0003/19ZH张浩1025YB2-280-4P9202181816362.0003/20ZH张浩1026YB3-71前10203203020300.0003/21ZH张浩1027YB3-71后11204224424684.0003/22ZH张浩1028YB3-80前12205246029520.0003/23ZH张浩1029YB3-80后13206267834814.0003/24ZH张浩103
14、0YB3-80闷14207289840572.0003/25DJ董江1031YB3-80-B3515208312046800.0003/26DJ董江1026YB3-71前10209209020900.0003/27DJ董江1027YB3-71后11210231025410.0003/28DJ董江1028YB3-80前12211253230384.0003/29DJ董江1029YB3-80后13212275635828.0003/30DJ董江1030YB3-80闷14213298241748.0003/31DJ董江1031YB3-80-B3515214321048150.0004/01DJ董江1
15、032YB3-80-B516215344055040.0004/02WSG王世高1033YB3-90前17216367262424.0004/03WSG王世高1029YB3-80后13217282136673.0004/04WSG王世高1030YB3-80闷14218305242728.0004/05WSG王世高1031YB3-80-B3515219328549275.0004/06WSG王世高1032YB3-80-B516220352056320.0004/07WSG王世高1033YB3-90前17221375763869.0004/08WSG王世高1034YB3-90后1822239967
16、1928.0004/09WSG王世高1035YB3-90后闷19223423780503.0004/10合合格格率率备备注注3 3#2.00#6.25%1.56%1.23%1.00%0.83%0.69%0.59%0.51%0.44%1.00%0.83%0.69%0.59%0.51%0.44%0.39%0.35%0.59%0.51%0.44%0.39%0.35%0.31%0.28%工工序序数数量量统统计计报报表表工工序序编编号号工工序序名名称称单单价价数数量量金额单重总重端端盖盖10011001YB2-80YB2-80前前2 2300300600.00260010021002YB2-80YB2-
17、80后后2 2300300600.00260010031003YB2-80B5YB2-80B54 4200200800.00480010041004YB2-90YB2-90后后1 1110051005YB2-90YB2-90前前1 1110061006YB2-90YB2-90立立2.52.52.510071007YB2-100YB2-100前前3 3310081008YB2-100YB2-100后后3 3310091009YB2-112YB2-112前前3.43.43.410101010YB2-112YB2-112后后4 4410111011YB2-132YB2-132前前5.55.55.51
18、0121012YB2-132YB2-132后后6 6610131013YB2-132YB2-132 B35B3510101010141014YB2-132YB2-132 B5B510101010151015YB2-160-2PYB2-160-2P8.78.78.710161016YB2-160-4PYB2-160-4P8.78.78.710171017YB2-180-2PYB2-180-2P9.89.89.810181018YB2-180-4PYB2-180-4P2 2210191019YB2-200-2PYB2-200-2P3 3310201020YB2-200-4PYB2-200-4P4
19、4410211021YB2-225-2PYB2-225-2P5 5510221022YB2-225-4PYB2-225-4P6 6610231023YB2-250-4PYB2-250-4P7 7710241024YB2-280-2PYB2-280-2P8 82012011608.008160810251025YB2-280-4PYB2-280-4P9 92022021818.009181810261026YB3-71YB3-71前前10104124124120.0010412010271027YB3-71YB3-71后后11114144144554.0011455410281028YB3-80
20、YB3-80前前12124164164992.0012499210291029YB3-80YB3-80后后13136356358255.0013825510301030YB3-80YB3-80闷闷14146386388932.0014893210311031YB3-80-B35YB3-80-B3515156416419615.0015961510321032YB3-80-B5YB3-80-B516164354356960.0016696010331033YB3-90YB3-90前前17174374377429.0017742910341034YB3-90YB3-90后后222222183996
21、10351035YB3-90YB3-90后后闷闷19192232234237.0019423710361036YB3-90-B35YB3-90-B3520202010371037YB3-90-B5YB3-90-B521212110381038YB3-100YB3-100前前22222210391039YB3-100YB3-100后后23232310401040YB3-100-B35YB3-100-B3524242410411041YB3-100-B5YB3-100-B525252510421042YB3-100-B3YB3-100-B3立立端端26262610431043YB3-112-B5Y
22、B3-112-B527272710441044AIMUR-160-2PAIMUR-160-2P端端盖盖28282810451045AIMUR-160-4PAIMUR-160-4P端端盖盖29292910461046AIMUR-180-2PAIMUR-180-2P端端盖盖30303010471047Y2Y2 180180 4P4P（俄俄）31313110481048Y2VPY2VP 31531532323210491049Y2VPY2VP 35535533333310501050Y2Y2 400400盖盖34343410511051Y2Y2 400400座座35353510521052Y2Y2
23、225-4225-4端端盖盖（俄俄）36363610531053Y2Y2 225225 4P4P B5B5（俄俄）37373710541054Y2Y2 200200 4P4P B5B5（俄俄）38383810551055NEPMNEPM 184184端端盖盖39393910561056NEPMNEPM 213213端端盖盖40404010571057 YB3YB3 9090前前端端（马马来来西西亚亚）41414110581058YB3YB3 100100前前端端（马马来来西西亚亚）42424210591059YB3YB3 112112前前端端（马马来来西西亚亚）43434310601060YB
24、3YB3 132132前前端端（马马来来西西亚亚）44444410611061YB3YB3 355355 2P2P CT4CT445454510621062YB3YB3 355355 4P4P CT4CT446464610631063YB3YB3 355-2355-2端端盖盖47474710641064YB3YB3 355-4P355-4P端端盖盖48484810651065AIMUAIMU M16M16盒盒座座（三三孔孔）49494910661066AIMU-160-4PAIMU-160-4P B3B350505010671067NENE 404404 2P2P外外盖盖51515110681
25、068NENE 444444 4P4P内内盖盖521069106982*8282*82压压板板5353531070107076*7676*76压压板板5454541071107190*9090*90压压板板55555510721072126*126126*126压压板板56565610731073160*160160*160压压板板57575710741074M5M5斗斗58585810751075M6M6斗斗59595910761076M6M6斗斗（带带护护圈圈）60606010771077M10M10斗斗（带带护护圈圈）61616110781078M16M16斗斗（带带护护圈圈）62626
26、210791079AIMUAIMU M8M8斗斗(带带护护圈圈）63636310801080M8M8斗斗64646410811081M16M16斗斗65656510821082YB3-M5YB3-M5小小盒盒盖盖66666610831083YB3-M5YB3-M5大大盒盒盖盖67676710841084YB3-M6YB3-M6盒盒盖盖68686810851085YB2-M5YB2-M5小小盒盒座座69696910861086YB2-M5YB2-M5大大盒盒座座70707010871087YB2-M6YB2-M6盒盒座座71717110881088YB2-M8YB2-M8盒盒座座72727210
27、891089YB2-M16YB2-M16盒盒座座73737310901090YB2-M5YB2-M5大大盒盒座座CT4CT474747410911091YB2-M6YB2-M6盒盒盖盖CT4CT475757510921092YB2-M6YB2-M6盒盒座座CT4CT476767610931093YB3YB3 M5M5大大方方盒盒座座（新新平平底底）77777710941094YB3YB3 M5M5小小方方座座（大大中中模模具具）78787810951095 M5M5小小方方盒盒座座（自自家家模模具具）7910961096AIMUAIMU M10M10盒盒座座（三三孔孔）808080109710
28、97AIMUAIMU M16M16盒盒座座（三三孔孔）81818110981098AIMURAIMUR M5M5座座82828210991099AIMURAIMUR M6M6座座83838311001100YB3YB3 M5M5小小方方盒盒盖盖848484轴轴承承盖盖20012001YB2-180-2PYB2-180-2P内内2 2220022002YB2-180-2PYB2-180-2P外外3 3320032003YB2-180-4PYB2-180-4P内内4 4420042004YB2-200-2PYB2-200-2P内内5 5520052005YB2-200-2PYB2-200-2P外外
29、6 6620062006YB2-200-2PYB2-200-2P外外闷闷7 7720072007YB2-200-4PYB2-200-4P内内8 8820082008YB2-200-4PYB2-200-4P外外9 9920092009YB2-200-4PYB2-200-4P外外闷闷10101020102010YB2-225-2PYB2-225-2P内内11111120112011YB2-225-2PYB2-225-2P外外12121220122012YB2-225-4PYB2-225-4P外外13131320132013YB2-250-2PYB2-250-2P外外1420142014YB2-25
30、0-4PYB2-250-4P内内15151520152015YB2-280-2PYB2-280-2P内内16161620162016YB2-280-4PYB2-280-4P内内17171720172017YB2-280-2PYB2-280-2P外外18181820182018YB2-280-4PYB2-280-4P外外19191920192019YB3YB3 315315 4P4P外外盖盖2020202020YB2-250-2PYB2-250-2P内内21212120212021YB2-250-2PYB2-250-2P外外22222220222022YB3YB3 355355 2P2P外外（止
31、止口口加加6mm)6mm)23232320232023YB3YB3 355355 2P2P闷闷（止止口口加加6mm)6mm)24242420242024NENE 404404 2P2P外外盖盖25252520252025NENE 444444 4P4P内内盖盖26262620262026AIMUAIMU M16M16盒盒座座27272720272027AIMUAIMU M16M16接接线线盒盒板板28282820282028YB3YB3 250250立立端端B5B5 4P4P29292920292029VASO-225VASO-225前前30303020302030VASO-225VASO-2
32、25后后31313120312031YB3YB3 250250油油环环32323220322032YB3YB3 280280油油环环33333320332033112112法法兰兰B5B534343420342034132132法法兰兰B5B535353520352035M16M16压压板板（带带护护圈圈）36363620362036YB3YB3 200200 2P2P闷闷盖盖37373720372037YB3YB3 250250 2P2P闷闷盖盖38383820382038YB3YB3 280280 2P2P闷闷盖盖39393920392039YB3YB3 315315 4P4P闷闷盖盖40
33、404020402040YB3YB3 100100 闷闷盖盖41414120412041YB3YB3 112112闷闷盖盖42424220422042YB3YB3 132132闷闷盖盖43434320432043280280风风罩罩444444#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N
34、/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A#N/A工工资资统统计计报报表表姓姓名名编编号号姓姓名名造造型型数数量量计计件件数数量量计计件件工工资资合合格格率率备备注注3 3WSGWSG王世高175617562834028340463720.00463720.000.030.03ZATZAT张安团800800200020005600.005600.000.560.562.002.00ZHZH张浩142814281573615736179116.00179116.000.060.06WWFWW
35、F王文发DJDJ董江169216922244022440304260.00304260.000.050.05XYCXYC薛玉成XTGXTG徐田果LXPLXP吕学浦CHPCHP陈会平LXLX李晓WSGWSG王世高175617562834028340463720.00463720.000.030.03ZATZAT张安团800800200020005600.005600.000.560.562.002.00ZHZH张浩142814281573615736179116.00179116.000.060.06WWFWWF王文发DJDJ董江169216922244022440304260.00304260
36、.000.050.05XYCXYC薛玉成XTGXTG徐田果LXPLXP吕学浦CHPCHP陈会平LXLX李晓合合计计463720.005600.00179116.00304260.00463720.005600.00179116.00304260.00生生产产部部11月月工工资资序号姓名应应付付工工资资应应付付工工 资资合合计计应应扣扣工工资资工资合计实实发发工工资资出勤 天数出勤率其他计件工资其它养老 保险1王世高28340.028340.028340.02张安团2000.02.02002.02002.03张浩15736.015736.015736.04王文发5董江22440.022440.0
37、22440.06薛玉成7徐田果8吕学浦9陈会平10李晓1112131415161718192021222324252627282930313233343536373839404142434445合计68516.02.068518.068518.0打印日期:查查询询姓姓名名代代码码WSG姓姓名名王王世世高高查查询询月月份份1 1至至5 5月月日日期期类类别别工工序序名名称称单单价价造造型型数数量量计计件件数数量量计计件件工工资资合合格格率率备备注注04/021033YB3-90前17216367262424.000.35%04/031029YB3-80后13217282136673.000.59%04/041030YB3-80闷14218305242728.000.51%04/051031YB3-80-B3515219328549275.000.44%04/061032YB3-80-B516220352056320.000.39%04/071033YB3-90前17221375763869.000.35%04/081034YB3-90后18222399671928.000.31%04/091035YB3-90后闷19223423780503.000.28%