计件工资核算表

员工编号姓名性别入厂时间基本工资/21.75工时费用/h备注,123456.0小花42067.0,234567.0小李42068.0,345678.0小胖42069.0,456789.0小兽42070.0,567900.0小红42071.0,679011.0小紫42072.012.0,790122.0小芬42073.0,901233.0晓晓42074.012.0,1012344.0利达42075.0,1123455.0鲤鱼42076.0,1234566.0李瑞亚42077.0,工件编号工件名称标准工时/件费用系数计入工时/件备注,167854.0text1,178690.0text2,189526.0text3,100362.0text40.75,111198.0text56.0,122034.0text67.03.5,132870.0text7,143706.0text8,154542.0text94.0,165378.0text10,176214.0text11,187050.0text12,197886.0text13,208722.0text14,219558.0text15,230394.0text16,241230.0text17,252066.0text18,262902.0text19,序号结算日期月份员工编号员工姓名工件编号工件名称计入工时/件数量计入工时,234567.0小李7.5,7.0,8.017.5,9.03.4642857142912.125,10.03.4285714285712.0,11.03.3928571428611.875,12.03.3571428571411.75,13.0234567.0小李3.3214285714311.625,14.03.2857142857111.5,15.03.2511.375,16.03.2142857142911.25,17.03.178571428573.17857142857,18.03.142857142864.71428571429,19.03.107142857143.10714285714,20.03.071428571439.21428571429,21.03.035714285719.10714285714,22.04.5,23.02.964285714292.96428571429,24.02.928571428574.39285714286,25.02.892857142862.89285714286,26.02.857142857148.57142857143,27.02.821428571438.46428571429,28.02.785714285714.17857142857,29.02.752.75,30.02.714285714294.07142857143,31.02.678571428572.67857142857,32.02.642857142867.92857142857,33.02.607142857147.82142857143,34.02.571428571433.85714285714,35.02.535714285712.53571428571,36.02.53.75,37.0,38.02.428571428577.28571428571,39.02.392857142867.17857142857,40.02.357142857143.53571428571,41.02.321428571432.32142857143,42.02.285714285716.85714285714,43.02.257.875,44.02.214285714292.21428571429,45.02.178571428576.53571428571,46.02.142857142866.42857142857,47.02.107142857146.32142857143,48.02.071428571432.07142857143,49.02.035714285716.10714285714,50.0,51.01.964285714291.96428571429,52.01.928571428575.78571428571,53.01.892857142866.625,54.01.857142857145.57142857143,55.01.821428571432.73214285714,56.01.785714285711.78571428571,57.01.755.25,58.01.71428571429,59.01.678571428575.03571428571,60.01.64285714286,61.01.607142857141.60714285714,62.01.571428571434.71428571429,63.01.535714285715.375,64.04.5,65.01.464285714292.19642857143,66.01.428571428571.42857142857,67.01.392857142864.17857142857,68.01.357142857144.75,69.01.321428571433.96428571429,70.01.285714285711.92857142857,71.01.251.25,72.01.214285714293.64285714286,73.01.178571428574.125,74.01.14285714286,2019年7月份工资表,序号员工编号姓名基本工资/21.75出勤天数工时费用/h本月工时工时工资基本工资应发工资五险一金扣除专项附加扣除应税工资累计个税累计应纳税税后收入,1.0123456.0小花28.25282.51799.74137931300.01499.74137931,2.0234567.0小李19.125153.01670.24137931200.01470.24137931,3.0345678.0小胖67.2321428571537.8571428572055.098522171955.09852217,4.0456789.0小兽42.3214285714338.5714285711855.812807881755.81280788,5.0567900.0小红93.875938.752455.991379312355.99137931,6.0679011.0小紫12.066.875802.52319.741379312219.74137931,7.0790122.0小芬55.7321428571557.3214285712074.562807881974.56280788,901233.0晓晓12.033.8392857143406.0714285711923.312807881823.31280788,9.01012344.0利达,1123455.0鲤鱼,11.01234566.0李瑞亚,汇总月份7月,员工编号姓名工时数,123456.0小花28.25,234567.0小李19.125,345678.0小胖67.2321428571,456789.0小兽42.3214285714,567900.0小红93.875,679011.0小紫66.875,790122.0小芬55.7321428571,901233.0晓晓33.8392857143,1012344.0利达,1123455.0鲤鱼,1234566.0李瑞亚