Excel表格模板：按小时计算的多功能工资表(含最新个税计算表).xlsx

工工资资表表单位名称：2017 年序序号号姓姓名名岗岗位位基基本本工工资资计计时时工工资资节节假假日日/休休假假超超时时加加班班工工资资休休息息加加班班工工资资工工作作时时数数时时薪薪金金额额时时间间单单价价金金额额时时间间单单价价金金额额时时间间单单价价1郑一建车间主任190030010.93275.86810.987.3563416.379365.5172221.839121陈工人16703019.62888.9189.676.7816414.396657.5862219.195432陈工人16703029.62898.5189.676.7816414.396657.5862219.195443陈工人16703039.62908.189.676.7816414.396657.5862219.195454陈工人16703049.62917.789.676.7816414.396657.5862219.195465陈工人11303056.51980.7586.551.95449.7413838.9655212.988576陈工人11303066.51987.2486.551.95449.7413838.9655212.988587陈工人11303076.51993.7486.551.95449.7413838.9655212.988598陈工人11303086.52000.2386.551.95449.7413838.9655212.9885109陈工人11303096.52006.7286.551.95449.7413838.9655212.98851110陈工人11303106.52013.2286.551.95449.7413838.9655212.98851211陈工人11303116.52019.7186.551.95449.7413838.9655212.98851312陈工人11303126.52026.2186.551.95449.7413838.9655212.98851413陈工人11303136.52032.786.551.95449.7413838.9655212.98851514陈工人11303146.52039.286.551.95449.7413838.9655212.98851615陈工人16703159.63023.2889.676.7816414.396657.5862219.19541716陈工人16701689.61612.4189.676.7816414.396657.5862219.19541817陈工人16701689.61612.4189.676.7816414.396657.5862219.19541918陈工人8001684.6772.41484.636.781646.8965527.586229.19542019陈工人8001684.6772.41484.636.781646.8965527.586229.19542120陈工人8001684.6772.41484.636.781646.8965527.586229.19542221陈工人8001684.6772.41484.636.781646.8965527.586229.19542322陈工人8001684.6772.41484.636.781646.8965527.586229.19542423陈工人16701689.61612.4189.676.7816414.396657.5862219.19542524陈工人367016821.13543.45821.1168.736431.6379126.552242.18392625陈工人8001684.6772.41484.636.781646.8965527.586229.19542726陈工人16701689.61612.4189.676.7816414.396657.5862219.19542827陈工人16701689.61612.4189.676.7816414.396657.5862219.19542928陈工人16701689.61612.4189.676.7816414.396657.5862219.19543029陈工人16701689.61612.4189.676.7816414.396657.5862219.19543130陈工人8001684.6772.41484.636.781646.8965527.586229.19543231陈工人16701689.61612.4189.676.7816414.396657.5862219.19543332陈工人16701689.61612.4189.676.7816414.396657.5862219.19543433陈工人16701689.61612.4189.676.7816414.396657.5862219.19543534陈工人16701689.61612.4189.676.7816414.396657.5862219.19543635陈工人245016814.12365.52814.1112.644421.120784.4828228.16093736陈工人16701689.61612.4189.676.7816414.396657.5862219.19543837陈工人16701689.61612.4189.676.7816414.396657.5862219.19543938陈工人245016814.12365.52814.1112.644421.120784.4828228.16094039陈工人8701685.084085.04047.5302104140陈工人16701689.61612.4189.676.7816414.396657.5862219.19544241陈工人16701689.61612.4189.676.7816414.396657.5862219.19544342陈工人16701689.61612.4189.676.7816414.396657.5862219.19544443陈工人16701689.61612.4189.676.7816414.396657.5862219.19544544陈工人16701689.61612.4189.676.7816414.396657.5862219.19544645陈工人16701689.61612.4189.676.7816414.396657.5862219.19544746陈工人245016814.12365.52814.1112.644421.120784.4828228.16094847陈工人12001686.91158.6286.955.1724410.344841.3793213.79314948陈工人12001686.91158.6286.955.1724410.344841.3793213.79315049陈工人12001686.91158.6286.955.1724410.344841.3793213.79315150陈工人12001686.91158.6286.955.1724410.344841.3793213.79315251陈工人16701689.61612.4189.676.7816414.396657.5862219.19545352陈工人16701689.61612.4189.676.7816414.396657.5862219.19545453陈工人245016814.12365.52814.1112.644421.120784.4828228.16095554陈工人16701689.61612.4189.676.7816414.396657.5862219.19545655陈工人16701689.61612.4189.676.7816414.396657.5862219.19545756陈工人16701689.61612.4189.676.7816414.396657.5862219.19545857陈工人16701689.61612.4189.676.7816414.396657.5862219.19545958陈工人245016814.12365.52814.1112.644421.120784.4828228.16096059陈工人16701689.61612.4189.676.7816414.396657.5862219.19546160陈工人245016814.12365.52814.1112.644421.120784.4828228.16096261陈工人245016814.12365.52814.1112.644421.120784.4828228.16096362陈工人12001686.91158.6286.955.1724410.344841.3793213.79316463陈工人12001686.91158.6286.955.1724410.344841.3793213.79316564陈工人12001686.91158.6286.955.1724410.344841.3793213.79316665陈工人12001686.91158.6286.955.1724410.344841.3793213.79316766陈工人16701689.61612.4189.676.7816414.396657.5862219.19546867陈工人16701689.61612.4189.676.7816414.396657.5862219.19546968陈工人245016814.12365.52814.1112.644421.120784.4828228.16097069陈工人16701689.61612.4189.676.7816414.396657.5862219.19547170陈工人16701689.61612.4189.676.7816414.396657.5862219.19547271陈工人16701689.61612.4189.676.7816414.396657.5862219.19547372陈工人16701689.61612.4189.676.7816414.396657.5862219.19547473陈工人245016814.12365.52814.1112.644421.120784.4828228.16097574陈工人16701689.61612.4189.676.7816414.396657.5862219.19547675陈工人245016814.12365.52814.1112.644421.120784.4828228.16097776陈工人16701689.61612.4189.676.7816414.396657.5862219.19547877陈工人8001684.6772.41484.636.781646.8965527.586229.19547978陈工人16701689.61612.4189.676.7816414.396657.5862219.19548079陈工人16701689.61612.4189.676.7816414.396657.5862219.19548180陈工人16701689.61612.4189.676.7816414.396657.5862219.19548281陈工人16701689.61612.4189.676.7816414.396657.5862219.19548382陈工人16701689.61612.4189.676.7816414.396657.5862219.19548483陈工人11301686.51091.0386.551.95449.7413838.9655212.98858584陈工人11301686.51091.0386.551.95449.7413838.9655212.98858685陈工人11301686.51091.0386.551.95449.7413838.9655212.98858786陈工人11301686.51091.0386.551.95449.7413838.9655212.98858887陈工人11301686.51091.0386.551.95449.7413838.9655212.98858988陈工人11301686.51091.0386.551.95449.7413838.9655212.98859089陈工人11301686.51091.0386.551.95449.7413838.9655212.98859190陈工人11301686.51091.0386.551.95449.7413838.9655212.98859291陈工人11301686.51091.0386.551.95449.7413838.9655212.98859392陈工人11301686.51091.0386.551.95449.7413838.9655212.98859493陈工人16701689.61612.4189.676.7816414.396657.5862219.19549594陈工人16701689.61612.4189.676.7816414.396657.5862219.19549695陈工人16701689.61612.4189.676.7816414.396657.5862219.19549796陈工人8001684.6772.41484.636.781646.8965527.586229.19549897陈工人8001684.6772.41484.636.781646.8965527.586229.19549998陈工人8001684.6772.41484.636.781646.8965527.586229.195410099陈工人8001684.6772.41484.636.781646.8965527.586229.1954101100陈工人8001684.6772.41484.636.781646.8965527.586229.1954102101陈工人16701689.61612.4189.676.7816414.396657.5862219.1954103102陈工人367016821.13543.45821.1168.736431.6379126.552242.1839104103陈工人8001684.6772.41484.636.781646.8965527.586229.1954105104陈工人16701689.61612.4189.676.7816414.396657.5862219.1954106105陈工人16701689.61612.4189.676.7816414.396657.5862219.1954107106陈工人16701689.61612.4189.676.7816414.396657.5862219.1954108107陈工人16701689.61612.4189.676.7816414.396657.5862219.1954109108陈工人8001684.6772.41484.636.781646.8965527.586229.1954110109陈工人16701689.61612.4189.676.7816414.396657.5862219.1954111110陈工人16701689.61612.4189.676.7816414.396657.5862219.1954112111陈工人16701689.61612.4189.676.7816414.396657.5862219.1954113112陈工人16701689.61612.4189.676.7816414.396657.5862219.1954114113陈工人245016814.12365.52814.1112.644421.120784.4828228.1609115114陈工人16701689.61612.4189.676.7816414.396657.5862219.1954116115陈工人16701689.61612.4189.676.7816414.396657.5862219.1954117116陈工人245016814.12365.52814.1112.644421.120784.4828228.1609118117陈工人8701685.084085.04047.530210119118陈工人16701689.61612.4189.676.7816414.396657.5862219.1954120119陈工人16701689.61612.4189.676.7816414.396657.5862219.1954121120陈工人16701689.61612.4189.676.7816414.396657.5862219.1954122121陈工人16701689.61612.4189.676.7816414.396657.5862219.1954123122陈工人16701689.61612.4189.676.7816414.396657.5862219.1954124123陈工人16701689.61612.4189.676.7816414.396657.5862219.1954125124陈工人245016814.12365.52814.1112.644421.120784.4828228.1609126125陈工人12001686.91158.6286.955.1724410.344841.3793213.7931127126陈工人12001686.91158.6286.955.1724410.344841.3793213.7931128127陈工人12001686.91158.6286.955.1724410.344841.3793213.7931129128陈工人12001686.91158.6286.955.1724410.344841.3793213.7931130129陈工人16701689.61612.4189.676.7816414.396657.5862219.1954131130陈工人16701689.61612.4189.676.7816414.396657.5862219.1954132131陈工人245016814.12365.52814.1112.644421.120784.4828228.1609133132陈工人16701689.61612.4189.676.7816414.396657.5862219.1954134133陈工人16701689.61612.4189.676.7816414.396657.5862219.1954135134陈工人16701689.61612.4189.676.7816414.396657.5862219.1954136135陈工人16701689.61612.4189.676.7816414.396657.5862219.1954137136陈工人245016814.12365.52814.1112.644421.120784.4828228.1609138137陈工人16701689.61612.4189.676.7816414.396657.5862219.1954139138陈工人245016814.12365.52814.1112.644421.120784.4828228.1609140139陈工人245016814.12365.52814.1112.644421.120784.4828228.1609141140陈工人12001686.91158.6286.955.1724410.344841.3793213.7931142141陈工人12001686.91158.6286.955.1724410.344841.3793213.7931143142陈工人12001686.91158.6286.955.1724410.344841.3793213.7931144143陈工人12001686.91158.6286.955.1724410.344841.3793213.7931145144陈工人16701689.61612.4189.676.7816414.396657.5862219.1954146145陈工人16701689.61612.4189.676.7816414.396657.5862219.1954147146陈工人245016814.12365.52814.1112.644421.120784.4828228.1609148147陈工人16701689.61612.4189.676.7816414.396657.5862219.1954149148陈工人16701689.61612.4189.676.7816414.396657.5862219.1954150149陈工人16701689.61612.4189.676.7816414.396657.5862219.1954151150陈工人16701689.61612.4189.676.7816414.396657.5862219.1954152151陈工人245016814.12365.52814.1112.644421.120784.4828228.1609153152陈工人16701689.61612.4189.676.7816414.396657.5862219.1954154153陈工人8001684.6772.41484.636.781646.8965527.586229.1954155154陈工人16701689.61612.4189.676.7816414.396657.5862219.1954156155陈工人16701689.61612.4189.676.7816414.396657.5862219.1954157156陈工人16701689.61612.4189.676.7816414.396657.5862219.1954158157陈工人16701689.61612.4189.676.7816414.396657.5862219.1954159158陈工人11301686.51091.0386.551.95449.7413838.9655212.9885160159陈工人11301686.51091.0386.551.95449.7413838.9655212.9885161160陈工人11301686.51091.0386.551.95449.7413838.9655212.9885162161陈工人11301686.51091.0386.551.95449.7413838.9655212.9885163162陈工人11301686.51091.0386.551.95449.7413838.9655212.9885164163陈工人11301686.51091.0386.551.95449.7413838.9655212.9885165164陈工人11301686.51091.0386.551.95449.7413838.9655212.9885166165陈工人11301686.51091.0386.551.95449.7413838.9655212.9885167166陈工人11301686.51091.0386.551.95449.7413838.9655212.9885168167陈工人11301686.51091.0386.551.95449.7413838.9655212.9885169168陈工人16701689.61612.4189.676.7816414.396657.5862219.1954170169陈工人16701689.61612.4189.676.7816414.396657.5862219.1954171170陈工人16701689.61612.4189.676.7816414.396657.5862219.1954172171陈工人8001684.6772.41484.636.781646.8965527.586229.1954173172陈工人8001684.6772.41484.636.781646.8965527.586229.1954174173陈工人8001684.6772.41484.636.781646.8965527.586229.1954175174陈工人8001684.6772.41484.636.781646.8965527.586229.1954176175陈工人8001684.6772.41484.636.781646.8965527.586229.1954177176陈工人16701689.61612.4189.676.7816414.396657.5862219.1954178177陈工人367016821.13543.45821.1168.736431.6379126.552242.1839179178陈工人8001684.6772.41484.636.781646.8965527.586229.1954180179陈工人16701689.61612.4189.676.7816414.396657.5862219.1954181180陈工人16701689.61612.4189.676.7816414.396657.5862219.1954182181陈工人16701689.61612.4189.676.7816414.396657.5862219.1954183182陈工人16701689.61612.4189.676.7816414.396657.5862219.1954184183陈工人8001684.6772.41484.636.781646.8965527.586229.1954185184陈工人16701689.61612.4189.676.7816414.396657.5862219.1954186185陈工人16701689.61612.4189.676.7816414.396657.5862219.1954187186陈工人16701689.61612.4189.676.7816414.396657.5862219.1954188187陈工人16701689.61612.4189.676.7816414.396657.5862219.1954189188陈工人245016814.12365.52814.1112.644421.120784.4828228.1609190189陈工人16701689.61612.4189.676.7816414.396657.5862219.1954191190陈工人16701689.61612.4189.676.7816414.396657.5862219.1954192191陈工人245016814.12365.52814.1112.644421.120784.4828228.1609193192陈工人8701685.084085.04047.530210194193陈工人16701689.61612.4189.676.7816414.396657.5862219.1954195194陈工人16701689.61612.4189.676.7816414.396657.5862219.1954196195陈工人16701689.61612.4189.676.7816414.396657.5862219.1954197196陈工人16701689.61612.4189.676.7816414.396657.5862219.1954198197陈工人16701689.61612.4189.676.7816414.396657.5862219.1954199198陈工人16701689.61612.4189.676.7816414.396657.5862219.1954200199陈工人245016814.12365.52814.1112.644421.120784.4828228.1609201200陈工人12001686.91158.6286.955.1724410.344841.3793213.7931202201陈工人12001686.91158.6286.955.1724410.344841.3793213.7931203202陈工人12001686.91158.6286.955.1724410.344841.3793213.7931204203陈工人12001686.91158.6286.955.1724410.344841.3793213.7931205204陈工人16701689.61612.4189.676.7816414.396657.5862219.1954206205陈工人16701689.61612.4189.676.7816414.396657.5862219.1954207206陈工人245016814.12365.52814.1112.644421.120784.4828228.1609208207陈工人16701689.61612.4189.676.7816414.396657.5862219.1954209208陈工人16701689.61612.4189.676.7816414.396657.5862219.1954210209陈工人16701689.61612.4189.676.7816414.396657.5862219.1954211210陈工人16701689.61612.4189.676.7816414.396657.5862219.1954212211陈工人245016814.12365.52814.1112.644421.120784.4828228.1609213212陈工人16701689.61612.4189.676.7816414.396657.5862219.1954214213陈工人245016814.12365.52814.1112.644421.120784.4828228.1609215214陈工人245016814.12365.52814.1112.644421.120784.4828228.1609216215陈工人12001686.91158.6286.955.1724410.344841.3793213.7931217216陈工人12001686.91158.6286.955.1724410.344841.3793213.7931218217陈工人12001686.91158.6286.955.1724410.344841.3793213.7931219218陈工人12001686.91158.6286.955.1724410.344841.3793213.7931220219陈工人16701689.61612.4189.676.7816414.396657.5862219.1954221220陈工人16701689.61612.4189.676.7816414.396657.5862219.1954222221陈工人245016814.12365.52814.1112.644421.120784.4828228.1609223222陈工人16701689.61612.4189.676.7816414.396657.5862219.1954224223陈工人16701689.61612.4189.676.7816414.396657.5862219.1954225224陈工人16701689.61612.4189.676.7816414.396657.5862219.1954226225陈工人16701689.61612.4189.676.7816414.396657.5862219.1954227226陈工人245016814.12365.52814.1112.644421.120784.4828228.1609228227陈工人16701689.61612.4189.676.7816414.396657.5862219.1954229228陈工人245016814.12365.52814.1112.644421.120784.4828228.1609230229陈工人16701689.61612.4189.676.7816414.396657.5862219.1954231230陈工人8001684.6772.41484.636.781646.8965527.586229.1954232231陈工人16701689.61612.4189.676.7816414.396657.5862219.1954233232陈工人16701689.61612.4189.676.7816414.396657.5862219.1954234233陈工人16701689.61612.4189.676.7816414.396657.5862219.1954235234陈工人16701689.61612.4189.676.7816414.396657.5862219.1954236235陈工人16701689.61612.4189.676.7816414.396657.5862219.1954237236陈工人11301686.51091.0386.551.95449.7413838.9655212.9885238237陈工人11301686.51091.0386.551.95449.7413838.9655212.9885239238陈工人11301686.51091.0386.551.95449.7413838.9655212.9885240239陈工人11301686.51091.0386.551.95449.7413838.9655212.9885241240陈工人11301686.51091.0386.551.95449.7413838.9655212.9885242241陈工人11301686.51091.0386.551.95449.7413838.9655212.9885243242陈工人11301686.51091.0386.551.95449.7413838.9655212.9885244243陈工人11301686.51091.0386.551.95449.7413838.9655212.9885245244陈工人11301686.51091.0386.551.95449.7413838.9655212.9885246245陈工人11301686.51091.0386.551.95449.7413838.9655212.9885247246陈工人16701689.61612.4189.676.7816414.396657.5862219.1954248247陈工人16701689.61612.4189.676.7816414.396657.5862219.1954249248陈工人16701689.61612.4189.676.7816414.396657.5862219.1954250249陈工人8001684.6772.41484.636.781646.8965527.586229.1954251250陈工人8001684.6772.41484.636.781646.8965527.586229.1954252251陈工人8001684.6772.41484.636.781646.8965527.586229.1954253252陈工人8001684.6772.41484.636.781646.8965527.586229.1954254253陈工人8001