電子表格作業(yè)設計_第1頁
電子表格作業(yè)設計_第2頁
電子表格作業(yè)設計_第3頁
電子表格作業(yè)設計_第4頁
電子表格作業(yè)設計_第5頁
全文預覽已結束

下載本文檔

版權說明：本文檔由用戶提供并上傳，收益歸屬內容提供方，若內容存在侵權，請進行舉報或認領

文檔簡介

工資表,,,,,,,,,,,

編號,姓名,工齡,校齡,基本工資,職稱工資,業(yè)務津貼,扣醫(yī)療保險,扣公積金,個人所得稅,應發(fā)工資,實發(fā)

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",

溫馨提示

  • 1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯(lián)系上傳者。文件的所有權益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內容里面會有圖紙預覽，若沒有圖紙預覽就沒有圖紙。
  • 4. 未經(jīng)權益所有人同意不得將文件中的內容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲空間，僅對用戶上傳內容的表現(xiàn)方式做保護處理，對用戶上傳分享的文檔內容本身不做任何修改或編輯，并不能對任何下載內容負責。
  • 6. 下載文件中如有侵權或不適當內容，請與我們聯(lián)系，我們立即糾正。
  • 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論