XLS《工资明细表》

工资明细表 "员工代码","部门","姓名","性别","基础工资","绩效工资","通讯补助","工龄工资","加班费","个人所得税","住宿费","养老保险","工资合计", "A005","财务部","李克强","男",1562.

5,2288,100,700,0,90.050000000000011,0,300,4260.5 "A012","生产综合部","王巨禄","男",2200,2392,0,800,0,164.20000000000002,100,300,4827.8 "A013","质控部","郭延标","男",1600,2392,0,800,0,104.20000000000002,0,100,4587.8 "A001","供应科","张文岳","女",2075,1980,200,650,0,115.5,0,300,4489.5 "A014","生产综合部","张正","女",2125,2800,0,600,0,178.75,0,300,5046.3 "A017","财务部","李建国","男",1600,1744,200,850,350,99.4,350,600,3694.6 "A018","财务部","徐光春","女",2313,2392,,

750,0,170.5,0,600,4684.5,1 "A002","生产综合部","韩长赋","男",2200,2400,0,850,200,197.5,0,300,5152.5 "A006","供应科","王云坤","女",2200,2352,0,700,381.66666666666669,195.05,0,300,5138.7000000000007 "A009","供应科","李渊","女",1600,2574,0,800,0,122.4,100,300,4451.6000000000004 "A016","财务部","韩正","女",1900,1936,,

650,0,73.600000000000009,0,600,3812.4 "A011","质控部","王国发","男",1300,2800,0,600,0,95,0,450,4155 "A010","质控部","王珉","女",1900,2200,200,550,194.41666666666666,129.44166666666672,0,450,4465 "A007","生产综合部","钱运录","男",1900,2024,0,550,0,72.400000000000006,0,450,3951.6 "A008","财务部","龚学平","女",2500,2716,0,650,0,229.89999999999998,0,450,5186.1000000000004 "A017","质控部","陈文林","女",1300,2380,0,550,0,48,100,450,3632 "A003","供应科","张左己","男",1400,1570,,

300,204,0,0,500,2974 "A004","供应科","陈光林","男",1600,2380,100,500,435,126.5,0,400,4488.5 "A014","质控部","王巨禄","男",2100,2090,,

600,,

104,,

450,4236 "A015","财务部","将以任","女",1850,2040,100,600,,

84,,

600,3906 "A019","财务部","张高丽","女",2200,2134,,

600,328,151.20000000000002,,

600,4510.8 筛选两列不同数据 "日期","姓名","发票金额","支付金额" 42796,"李渊",278.07,278.07 42797,"王国发",789,788.2 42797,"郭延标",1365.35,1365.35 42805,"张文岳",240.17,190.4 42811,"张正",1348.49,1348.49 42813,"韩长赋",2023.34,2023.34 42814,"王云坤",292.81,292.81 42814,"李渊",1802.92,1912.92 42815,"王国发",566,566 42819,"王珉",412,412 42820,"钱运录",1355.71,1355.71 42828,"龚学平",176.43,176.43 42829,"陈文林",870,870 42832,"王云坤",1682.37,1682.37