资源描述：
《用excel制作工资条》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、用EXCEL制作工资条计算员工代码姓名部门岗位工资标准上班天数基本工资加班时间加班工资销售数量销售工资奖励应发金额所得税其他扣款应扣金额实发金额1001行政部员工1总经理3,000.0021.03,000.005.065.03,070147.001302772,7931002行政部员工2行政部1,200.0021.01,200.0010.064.01,2741291291,1451003行政部员工3行政部1,200.0021.01,200.0015.063.01,2781281281,150109><#990099'>04行政部员工4行政部1,200
2、.0021.01,200.0020.062.01,2821271271,1551005行政部员工5行政部1,200.0021.01,200.0025.061.01,2861261261,1601006行政部员工6行政部1,200.0021.01,200.0030.060.01,2901251251,1651007行政部员工7行政部1,200.0021.01,200.0035.059.01,2941241241,1701008行政部员工8行政部1,200.0021.01,200.0040.058.01,2981231231,1751009行政部员工9行
3、政部1,200.0021.01,200.0045.057.01,3021221221,1801010行政部员工10行政部1,200.0021.01,200.0050.056.01,3061211211,1852001销售部员工1销售部1,500.0021.01,500.0055.055.01,6100.50120120.51,489.52002销售部员工2销售部1,500.0021.01,500.0060.054.01,6140.70119119.71,494.32003销售部员工3销售部1,500.0021.01,500.0065.053.01,6
4、180.90118118.91,499.120<#990099'>04销售部员工4销售部1,500.0021.01,500.0070.052.01,6221.10117118.11,503.92005销售部员工5销售部1,500.0021.01,500.0075.051.01,6261.30116117.31,508.72006销售部员工6销售部1,500.0021.01,500.0080.050.01,6301.50115116.51,513.52007销售部员工7销售部1,500.0021.01,500.0085.049.01,6341.7011
5、4115.71,518.32008销售部员工8销售部1,500.0021.01,500.0090.048.01,6381.90113114.91,523.12009销售部员工9销售部1,500.0021.01,500.0095.047.01,6422.10112114.11,527.92010销售部员工10销售部1,500.0021.01,500.00100.046.01,6462.30111113.31,532.72011销售部员工11销售部1,500.0021.01,500.00105.045.01,6502.50110112.51,537.52
6、012销售部员工12销售部1,500.0021.01,500.00110.044.01,6542.70109111.71,542.32013销售部员工13销售部1,500.0021.01,500.00115.043.01,6582.90108110.91,547.12014销售部员工14销售部1,500.0021.01,500.00120.042.01,6623.10107110.11,551.92015销售部员工15销售部1,500.0021.01,500.00125.041.01,6663.30106109.31,556.72016销售部员工16
7、销售部1,500.0021.01,500.00130.040.01,6703.50105108.51,561.52017销售部员工17销售部1,500.0021.01,500.00135.039.01,6743.701<#990099'>04107.71,566.32018销售部员工18销售部1,500.0021.01,500.00140.038.01,6783.90103106.91,571.12019销售部员工19销售部1,500.0021.01,500.00145.037.01,6824.10102106.11,575.92020销售部员工20
8、销售部1,500.0021.01,500.00150.036.01,6864.30101105.31,580
