员工工资表全公式自动计算表

11月公司员工工资表,月度工作日：,序号员工工号姓名工资级别部门岗位名称入职日期基本工资最后一天工作日出勤天数出勤工资加班补发奖金社保基数养老企业养老个人失业企业失业个人工伤企业医疗基数医疗企业医疗个人生育企业公积金基数公积金企业公积金个人社会保险小计企业社会保险小计个人工资总额税前扣除税前工资个税实发工资人员类别,0.20.080.010.0020.0030.10.020.0080.120.12,1.01001.031.038565.0790.014210.0,2.01002.038579.02138.0855.2106.921.3832.071069.0216.885.521282.81282.84714.291093.389596.62249.669346.96,3.01003.028.038600.033386.8444436.7128950.134,4.01004.023.0824.6329.8441.238.24612.369412.385.46494.76494.761785.259423.5463699.4543699.454外阜城镇,5.01005.0300.01888.4755.3694.4218.88428.326944.2191.8475.5361133.041133.044163.922966.08411742.02000.08775.916167.598608.326,6.01006.01843.8737.5292.1918.43827.657921.9187.381106.281106.283991.827943.3388275.662117.578158.092,7.01007.012950.012950.014550.013406.844630.6812776.164,8.01008.012913.012913.0500.015013.013869.844676.9813192.864,9.01009.013334.013334.014934.014934.0783.414150.6,10.01010.04840.07412096.844499.6811597.164,11.01011.014113.014113.015713.014569.844746.9813822.864,12.01012.013343.013343.014943.013799.844669.9813129.864,13.01013.017400.017400.019000.019000.01390.017610.0,14.01014.0,15.01015.0,16.01016.0,17.01017.0,18.01018.0,19.01019.0,20.01020.0,1021.0,22.01022.0,23.01023.0,24.01024.0,1025.0,1026.0,27.01027.0,28.01028.0,29.01029.0,30.01030.0,31.01031.0,32.01032.0,33.01033.0,34.01034.012860.012860.04840.07414460.013316.844621.6812695.164,合计193157.0714.0193157.011200.0800.022344.08937.61117.2223.44335.1611172.02267.4608.17613406.413406.448982.93611428.44207157.02000.0193728.5669767.85123960.71