工資表5表格表格

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

結(jié)算日期：,,,,,,,,,,,

員工編號(hào),姓名,職位,基本工資,提成,效益獎(jiǎng)金,小計(jì),遲到,事假,曠工,小計(jì),實(shí)發(fā)工資

001,鄧川,銷售經(jīng)理,2300,2200,500,5000,,50,,50,4950

002,王益,銷售經(jīng)理,2100,2300,500,4900,,,,0,4900

003,陳洋,銷售經(jīng)理,2300,2300,500,5100,,,,0,5100

004,王影,業(yè)務(wù)員,1500,2500,500,4500,,,,0,4500

005,陳林,業(yè)務(wù)員,1500,2500,500,4500,,,150,150,4350

006,謝翼,業(yè)務(wù)員,1500,2400,500,4400,,,,0,4400

007,蔣平,業(yè)務(wù)員,1500,2300,500,4300,,,,0,4300

008,金江,業(yè)務(wù)員,1500,2100,400,4000,,100,,100,3900

009,李圓,業(yè)務(wù)員,1000,700,300,2000,40,,,40,1960

010,陳環(huán),業(yè)務(wù)員,1700,1900,300,3900,,100,,100,3800

011,周劍俠,業(yè)務(wù)員,1300,800,300,2400,20,300,,320,2080

012,鐘均,保潔員,500,0,100,600,0,0,0,0,600

013,周楓,銷售經(jīng)理,2100,2300,500,4900,,,,0,4900

014,楊智,銷售經(jīng)理,2200,2300,500,5000,,50,,50,4950

015,夏天,銷售經(jīng)理,2500,2000,400,4900,,150,,150,4750

016,劉秦,業(yè)務(wù)員,1500,2700,500,4700,,,,0,4700

,值,,,,,,,,,,

行標(biāo)簽,求和項(xiàng):小計(jì),求和項(xiàng):小計(jì)2,求和項(xiàng):實(shí)發(fā)工資,,,,,,,,

陳環(huán),3900,100,3800,,,,,,,,

業(yè)務(wù)員,3900,100,3800,,,,,,,,

陳林,4500,150,4350,,,,,,,,

業(yè)務(wù)員,4500,150,4350,,,,,,,,

陳洋,5100,0,5100,,,,,,,,

銷售經(jīng)理,5100,0,5100,,,,,,,,

鄧川,5000,50,4950,,,,,,,,

銷售經(jīng)理,5000,50,4950,,,,,,,,

蔣平,4300,0,4300,,,,,,,,

業(yè)務(wù)員,4300,0,4300,,,,,,,,

金江,4000,100,3900,,,,,,,,

業(yè)務(wù)員,4000,100,3900,,,,,,,,

李圓,2000,40,1960,,,,,,,,

業(yè)務(wù)員,2000,40,1960,,,,,,,,

劉秦,4700,0,4700,,,,,,,,

業(yè)務(wù)員,4700,0,4700,,,,,,,,

王益,4900,0,4900,,,,,,,,

銷售經(jīng)理,4900,0,4900,,,,,,,,

王影,4500,0,4500,,,,,,,,

業(yè)務(wù)員,4500,0,4500,,,,,,,,

夏天,4900,150,4750,,,,,,,,

銷售經(jīng)理,4900,150,4750,,,,,,,,

謝翼,4400,0,4400,,,,,,,,

業(yè)務(wù)員,4400,0,4400,,,,,,,,

楊智,5000,50,4950,,,,,,,,

銷售經(jīng)理,5000,50,4950,,,,,,,,

鐘均,600,0,600,,,,,,,,

保潔員,600,0,600,,,,,,,,

周楓,4900,0,4900,,,,,,,,

銷售經(jīng)理,4900,0,4900,,,,,,,