电子表格作业设计

工资表,,,,,,,,,,,

编号,姓名,工龄,校龄,基本工资,职称工资,业务津贴,扣医疗保险,扣公积金,个人所得税,应发工资,实发

1011,程妮子,10,6,"￥1,800.00",￥180.00,￥-,￥36.00,￥59.40,￥99.20,"￥2,042.00","￥1,847.40"

1012,黄建成,13,9,"￥1,800.00",￥180.00,￥-,￥36.00,￥59.40,￥101.30,"￥2,063.00","￥1,866.30"

1020,黄上卿,13,5,"￥1,800.00",￥180.00,￥-,￥36.00,￥59.40,￥100.50,"￥2,055.00","￥1,859.10"

1021,吴尚垠,4,0,"￥1,800.00",￥180.00,￥-,￥36.00,￥59.40,￥95.00,"￥2,000.00","￥1,809.60"

1025,张铸剑,9,3,"￥1,800.00",￥180.00,￥-,￥36.00,￥59.40,￥98.10,"￥2,031.00","￥1,837.50"

,,,,"￥1,800.00汇总",,,,,￥494.10,,"￥9,219.90"

1007,符伟涛,5,5,"￥2,000.00",￥200.00,￥-,￥40.00,￥66.00,￥118.50,"￥2,235.00","￥2,010.50"

1008,陈幸妤,11,4,"￥2,000.00",￥200.00,￥-,￥40.00,￥66.00,￥121.30,"￥2,263.00","￥2,035.70"

1013,秦芳琴,31,9,"￥2,000.00",￥200.00,￥350.00,￥40.00,￥66.00,￥167.30,"￥2,723.00","￥2,449.70"

1014,丘少峰,6,4,"￥2,000.00",￥200.00,￥350.00,￥40.00,￥66.00,￥153.80,"￥2,588.00","￥2,328.20"

1016,周海尚,8,2,"￥2,000.00",￥200.00,￥450.00,￥40.00,￥66.00,￥164.40,"￥2,694.00","￥2,423.60"

1024,蔡雅妲,15,9,"￥2,000.00",￥200.00,￥450.00,￥40.00,￥66.00,￥169.30,"￥2,743.00","￥2,467.70"

,,,,"￥2,000.00汇总",,,,,￥894.60,,"￥13,715.40"

1004,高宇星,10,1,"￥2,200.00",￥220.00,￥-,￥44.00,￥72.60,￥142.20,"￥2,472.00","￥2,213.20"

1005,何锡,38,8,"￥2,200.00",￥220.00,￥350.00,￥44.00,￥72.60,￥192.60,"￥2,976.00","￥2,666.80"

1006,朱超熏,3,2,"￥2,200.00",￥220.00,￥350.00,￥44.00,￥72.60,￥173.90,"￥2,789.00","￥2,498.50"

1015,苏海陵,11,3,"￥2,200.00",￥220.00,￥450.00,￥44.00,￥72.60,￥188.10,"￥2,931.00","￥2,626.30"

1022,林家娟,9,7,"￥2,200.00",￥220.00,￥-,￥44.00,￥72.60,￥142.90,"￥2,479.00","￥2,219.50"

1023,金丝草,8,5,"￥2,200.00",￥220.00,￥-,￥44.00,￥72.60,￥142.00,"￥2,470.00","￥2,211.40"

,,,,"￥2,200.00汇总",,,,,￥981.70,,"￥14,435.70"

1001,费德清,6,6,"￥2,500.00",￥250.00,￥350.00,￥50.00,￥82.50,￥209.20,"￥3,142.00","￥2,800.30"

1002,林子,7,1,"￥2,500.00",￥250.00,￥-,￥50.00,￥82.50,￥173.70,"￥2,787.00","￥2,480.80"

1003,林西风,28,8,"￥2,500.00",￥250.00,￥450.00,￥50.00,￥82.50,￥230.60,"￥3,356.00","￥2,992.90"

1009,韦炫丽,11,2,"￥2,500.00",￥250.00,￥350.00,￥50.00,￥82.50,￥210.90,"￥3,159.00","￥2,815.60"

1010,何夕峰,22,0,"￥2,500.00",￥250.00,￥450.00,￥50.00,￥82.50,￥226.00,"￥3,310.00","￥2,951.50"

1017,翟丹巴,38,5,"￥2,500.00",￥250.00,￥450.00,￥50.00,￥82.50,￥235.00,"￥3,400.00","￥3,032.50"

1018,步江风,28,3,"￥2,500.00",￥250.00,￥-,￥50.00,￥82.50,￥184.60,"￥2,896.00","￥2,578.90"

1019,江贺喜,4,2,"￥2,500.00",￥250.00,￥450.00,￥50.00,￥82.50,￥217.40,"￥3,224.00","￥2,874.10"

,,,,"￥2,500.00汇总",,,,,"￥1,687.40",