excel vba编程示例文件[1]part01

人员编号,姓名,技能工资,岗位工资,工龄工资,浮动工资,其他,加班工资,夜餐费,营养费,各种补贴,住房补贴,车贴,月度奖,年度奖,误餐费,应发合计,养老金,失业保险,医保,公积金,工会费,病事假,房租,借款,代扣税,扣款合计,应纳税所得,实发合计,签名 01001,丁XX,1535,3450,400,80,79,100,0,0,165,245.7,12,726,0,120,6912.7,553.02,69.13,129.72,904,7.68,0,0,0,363.52,2027.07,5256.83,4885.63,0 01002,秦XX,1535,3450,340,80,79,100,0,0,165,195.53,12,726,0,120,6802.53,544.2,68.03,129.72,904,7.68,0,0,0,348.49,2002.12,5156.58,4800.41,0 01003,沈XX,1195,2760,200,70,74,0,0,0,165,195.04,12,660,0,120,5451.04,436.08,54.51,129.72,904,5.98,0,0,0,167.67,1697.96,3926.73,3753.08,0 01004,华XX,1495,2760,410,80,74,100,0,0,165,195.44,12,660,0,120,6071.44,485.72,60.71,129.72,904,7.48,0,0,0,248.69,1836.32,4491.29,4235.12,0 01006,张XX,995,2760,160,60,74,0,0,0,165,191.51,12,660,0,120,5197.51,415.8,51.98,129.72,581,4.98,0,0,0,177.85,1361.33,4019.01,3836.18,0 02001,王XX,935,2420,140,60,69,100,0,0,165,128.68,12,594,0,120,4743.68,379.49,47.44,100.06,512,4.68,0,0,0,145.47,1189.14,3704.69,3554.54,0 02002,邱XX,1415,2010,400,80,69,0,0,0,165,140.49,12,594,0,120,5005.49,400.44,50.05,109.39,565,7.08,0,0,0,163.06,1295.02,3880.61,3710.47,0 02003,钱XX,1535,2010,420,80,69,0,0,0,165,144.29,12,594,0,120,5149.29,411.94,51.49,112.39,583,7.68,0,0,0,174.05,1340.55,3990.47,3808.74,0 02005,马XX,1090,2210,230,70,69,0,0,0,165,113.08,12,594,0,120,4673.08,373.85,46.73,87.25,413,5.45,0,0,0,150.23,1076.51,3752.25,3596.57,0 02006,王XX,815,1250,100,60,57,0,0,0,165,0,12,429,0,120,3008,240.64,30.08,70.45,358,4.08,0,0,0,15.44,718.69,2308.83,2289.31,0 02007,邱XX,1415,1250,360,80,57,0,0,0,165,117.64,12,429,0,120,4005.64,320.45,40.06,93.09,538,7.08,0,0,0,76.4,1075.08,3014.04,2930.56,0 02008,陆XX,875,1250,190,60,57,1011.9,0,0,165,94.68,12,429,0,120,4264.58,341.17,42.65,75.06,429,4.38,0,0,0,112.67,1004.93,3376.7,3259.65,0 02009,刘XX,1090,1110,220,70,56,0,0,0,165,95.78,12,396,0,120,3334.78,266.78,33.35,76.03,499,5.45,0,0,0,22.98,903.59,2459.62,2431.19,0 02010,吴XX,765,1110,130,50,56,0,0,0,165,85.93,12,396,0,120,2889.93,231.19,28.9,67.99,336,3.83,0,0,0,11.29,679.2,2225.85,2210.73,0 02011,徐XX,715,1110,140,50,56,0,0,0,165,83.77,12,396,0,120,2847.77,227.82,28.48,66.24,332,3.58,0,0,0,9.66,667.78,2193.23,2179.99,0 02012,张XX,1195,1110,260,70,56,0,0,0,165,102.02,12,396,0,120,3486.02,278.88,34.86,80.6,414,5.98,0,0,0,42.77,857.09,2677.68,2628.93,0 03001,李XX,1375,2210,350,80,69,0,0,0,165,144.92,12,594,0,120,5119.92,409.59,51.2,112.59,586,6.88,0,0,0,171.05,1337.31,3960.54,3782.61,0 03002,徐XX,1415,1610,410,80,64,0,0,0,165,127.45,12,528,0,120,4531.45,362.52,45.31,99.94,521,7.08,0,0,0,125.27,1161.12,3502.68,3370.33,0 03003,朱XX,1160,1810,190,70,64,0,0,0,165,122.01,12,528,0,120,4241.01,339.28,42.41,95.33,494,5.8,0,0,0,102,1078.82,3269.99,3162.19,0 03004,季XX,1375,1810,310,80,64,0,0,0,165,128.8,12,528,0,120,4592.8,367.42,45.93,100.47,526,6.88,0,0,0,130.3,1177,3552.98,3415.8,0 03005,江XX,1265,1110,250,70,56,0,0,0,165,100.31,12,396,0,120,3544.31,283.54,35.44,79.65,412,6.33,0,0,0,48.37,865.33,2733.68,2678.98,0 04001,王XX,1415,2210,340,80,69,790.48,0,0,165,163,12,594,0,120,5958.48,476.68,59.58,127.12,659,7.08,0,0,0,270.42,1599.88,4636.1,4358.6,0 04002,张XX,1455,1610,360,80,64,0,0,0,165,136.17,12,528,0,120,4530.17,362.41,45.3,107.01,564,7.28,0,0,0,120.15,1206.15,3451.45,3324.02,0 04003,吴XX,1160,1810,190,70,64,0,0,0,165,132.49,12,528,0,120,4251.49,340.12,42.51,103.71,526,5.8,0,0,0,98.92,1117.06,3239.15,3134.43,0 04004,袁XX,1125,1610,200,70,62,520.96,0,0,165,121.96,12,495,0,120,4501.92,360.15,45.02,95.97,488,5.63,0,0,0,126.28,1121.05,3512.78,3380.87,0 04005,刘XX,875,1110,120,60,56,0,0,0,165,95.5,12,396,0,120,3009.5,240.76,30.1,76.06,383,4.38,0,0,0,13.98,748.28,2279.58,2261.22,0 05002,王XX,1455,1610,410,80,64,0,0,0,165,133.49,12,528,0,120,4577.49,366.2,45.77,104.77,553,7.28,0,0,0,125.78,1202.8,3507.75,3374.69,0 05003,张XX,1455,1610,410,80,64,0,0,0,165,133.93,12,528,0,120,4577.93,366.23,45.78,105.12,548,7.28,0,0,0,126.28,1198.69,3512.8,3379.24,0 05004,吴XX,965,1810,180,60,64,496.42,0,0,165,129.18,12,528,0,120,4529.6,362.37,45.3,100.4,491,4.83,0,0,0,128.05,1131.95,3530.53,3397.65,0 05005,钱XX,845,1250,140,60,57,0,0,0,165,98.67,12,429,0,120,3176.67,254.13,31.77,78.31,395,4.23,0,0,0,20.87,784.31,2417.46,2392.36,0 05006,顾XX,845,1000,140,60,54,0,0,0,165,85.63,12,363,0,120,2844.63,227.57,28.45,67.97,353,4.23,0,0,0,8.38,689.6,2167.64,2155.03,0 05007,于XX,845,1110,150,60,56,0,0,0,165,91.47,12,396,0,120,3005.47,240.44,30.05,72.72,376,4.23,0,0,0,14.31,737.75,2286.26,2267.72,0 05008,曹XX,1160,1110,220,70,56,0,0,0,165,101.43,12,396,0,120,3410.43,272.83,34.1,80.61,420,5.8,0,0,0,35.29,848.63,2602.89,2561.8,0 05009,吴XX,1125,1110,260,70,56,0,0,0,165,102.58,12,396,0,120,3416.58,273.33,34.17,81.44,423,5.63,0,0,0,35.46,853.03,2604.64,2563.55,0 05010,张XX,765,1110,130,50,56,0,0,0,165,78.5,12,396,0,120,2882.5,230.6,28.83,62.44,350,3.83,0,0,0,10.53,686.23,2210.63,2196.27,0 05011,姜XX,765,1000,130,50,54,0,0,0,165,87.44,12,363,0,120,2746.44,219.72,27.46,69.72,361,3.83,0,0,0,3.43,685.16,2068.54,2061.28,0 05012,张XX,765,1110,130,50,56,0,0,0,165,88.83,12,396,0,120,2892.83,231.43,28.93,70.71,362,3.83,0,0,0,9.99,706.89,2199.76,2185.94,0 05013,季XX,665,1110,120,50,56,0,0,0,165,0,12,396,0,120,2694,215.52,26.94,66.81,338,3.33,0,0,0,2.34,652.94,2046.73,2041.06,0 05014,丁XX,1195,1110,250,70,56,0,0,0,165,103.59,12,396,0,120,3477.59,278.21,34.78,82.27,429,5.98,0,0,0,40.33,870.57,2653.33,2607.02,0 05015,吴XX,1375,1110,310,80,56,0,0,0,165,110.18,12,396,0,120,3734.18,298.73,37.34,87.38,458,6.88,0,0,0,60.27,948.6,2852.73,2785.58,0 05016,孙XX,1300,1110,260,75,56,0,0,0,165,106.84,12,396,0,120,3600.84,288.07,36.01,84.81,442,6.5,0,0,0,50,907.39,2749.95,2693.45,0 05017,吴XX,1195,1110,260,70,56,0,0,0,165,107.19,12,396,0,120,3491.19,279.3,34.91,85.13,439,5.98,0,0,0,40.29,884.61,2652.85,2606.58,0 05018,李XX,425,1110,50,30,56,0,0,0,165,0,12,396,0,120,2364,189.12,23.64,57.15,228,2.13,0,0,0,0,500.04,1866.09,1863.96,0 05019,张XX,1125,1250,200,70,57,0,0,0,165,105.57,12,429,0,120,3533.57,282.69,35.34,83.75,437,5.63,0,0,0,44.48,888.89,2694.79,2644.68,0 05020,季XX,1300,1000,270,75,54,0,0,0,165,102.59,12,363,0,120,3461.59,276.93,34.62,81.28,429,6.5,0,0,0,38.98,867.31,2639.76,2594.28,0 05022,秦XX,1455,0,320,0,0,0,0,0,165,85.51,0,0,0,0,2025.51,162.04,20.26,72.13,454,7.28,0,0,0,0,715.71,1317.08,1309.8,0 05023,张XX,765,1000,130,50,54,0,0,0,165,83.28,12,363,0,120,2742.28,219.38,27.42,66.16,341,3.83,0,0,0,4.42,662.21,2088.32,2080.07,0 05024,王XX,575,1250,90,40,57,0,0,0,165,0,12,429,0,120,2738,219.04,27.38,67.84,341,2.88,0,0,0,4.14,662.28,2082.74,2075.72,0 05025,曹XX,1055,1250,180,70,57,539.04,0,0,165,112.03,12,429,0,120,3989.07,319.13,39.89,88.56,433,5.28,0,0,0,85.85,971.71,3108.49,3017.36,0 05026,张XX,790,1110,160,55,56,0,0,0,165,96.8,12,396,0,120,2960.8,236.86,29.61,76.97,384,3.95,0,0,0,11.67,743.06,2233.36,2217.74,0 05027,顾XX,615,1250,110,50,57,0,0,0,165,0,12,429,0,120,2808,224.64,28.08,67.28,345,3.08,0,0,0,7.15,675.23,2143,2132.77,0 05028,吴XX,995,1250,160,60,57,0,0,0,165,101.95,12,429,0,120,3349.95,268,33.5,80.94,420,4.98,0,0,0,29.75,837.17,2547.51,2512.78,0 05029,张XX,815,1110,110,60,56,0,0,0,165,0,12,396,0,120,2844,227.52,28.44,71.09,364,4.08,0,0,0,7.65,702.78,2152.95,2141.22,0 05030,邱XX,425,1110,50,30,56,0,0,0,165,0,12,396,0,120,2364,189.12,23.64,60.51,256,2.13,0,0,0,0,531.4,1834.73,1832.6,0 05031,徐XX,1125,1250,200,70,57,0,0,0,165,86.13,12,429,0,120,3514.13,281.13,35.14,67.74,429,5.63,0,0,0,45.11,863.75,2701.12,2650.38,0 05034,张XX,765,1000,130,50,54,0,0,0,165,83.24,12,363,0,120,2742.24,219.38,27.42,66.13,336,3.83,0,0,0,4.67,657.43,2093.31,2084.81,0 05035,张XX,1300,1000,280,75,54,0,0,0,165,101.86,12,363,0,120,3470.86,277.67,34.71,80.68,430,6.5,0,0,0,39.78,869.34,2647.8,2601.52,0 05036,陈XX,1455,1250,410,80,57,0,0,0,165,119.48,12,429,0,120,4097.48,327.8,40.97,94.46,505,7.28,0,0,0,87.93,1063.44,3129.25,3034.04,0 05038,徐XX,395,1110,70,30,56,215.01,0,0,165,0,12,39