人员编号,姓名,技能工资,岗位工资,工龄工资,浮动工资,其他,加班工资,夜餐费,营养费,各种补贴,住房补贴,车贴,月度奖,年度奖,误餐费,应发合计,养老金,失业保险,医保,公积金,工会费,病事假,房租,借款,代扣税,扣款合计,应纳税所得,实发合计,签名
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
没有合适的资源?快使用搜索试试~ 我知道了~
excel vba编程示例文件[1]part01
共143个文件
xls:138个
txt:4个
db:1个
需积分: 5 6 下载量 191 浏览量
2009-11-14
10:50:15
上传
评论
收藏 1.91MB RAR 举报
温馨提示
excel vba编程示例文件[1]part01
资源推荐
资源详情
资源评论
收起资源包目录
excel vba编程示例文件[1]part01 (143个子文件)
Thumbs.db 49KB
200906.txt 13KB
工资表.txt 13KB
工资表.txt 13KB
工资表.txt 13KB
190-2 使用工作表函数.xls 1.07MB
190-3 使用更快的单元格操作方法.xls 736KB
技巧197 收据系统.xls 603KB
技巧5 查找单元格.xls 594KB
技巧198 职工考勤系统.xls 364KB
考勤系统V1.2.xls 241KB
技巧193 加班费计算表.xls 191KB
技巧194 制作发放条.xls 176KB
技巧196 职工花名册.xls 157KB
工资表分页小计(底端标题行)).xls 157KB
技巧195 费用统计表.xls 126KB
技巧179 搜索特定的文件.xls 64KB
技巧183 使用API取得硬盘信息.xls 64KB
技巧8 仅复制数值到另一区域.xls 57KB
技巧7 复制单元格区域.xls 56KB
A.xls 51KB
D.xls 51KB
170-1 使用查询表导入.xls 50KB
180-11 创建文本文件.xls 49KB
汇总表.xls 47KB
技巧24 在工作表中上下翻页.xls 46KB
180-10 导入文本文件.xls 45KB
技巧1 单元格的引用方法.xls 45KB
171-1 使用Print # 语句.xls 45KB
170-3 使用OpenText方法.xls 44KB
170-2 使用Open 语句导入.xls 43KB
技巧38 工作表的保护与解除保护.xls 42KB
技巧36 复制自动筛选后的数据区域.xls 42KB
171-2 另存为文本文件.xls 42KB
技巧25 工作表的添加与删除.xls 36KB
技巧27 自动建立工作表目录.xls 35KB
15-4 取消合并单元格时在每个单元格中保留内容.xls 34KB
技巧23 遍历工作表的方法.xls 34KB
15-3 合并内容相同的连续单元格.xls 34KB
13-5 将单元格中的公式转换为数值.xls 33KB
技巧185 暂停代码的运行.xls 30KB
技巧40 工作簿的引用方法.xls 30KB
技巧22 选择工作表的方法.xls 30KB
13-1 在单元格中写入公式.xls 29KB
188-3 模块的导入与导出.xls 29KB
技巧49 打印预览时不触发事件.xls 29KB
190-5 少用激活或选择语句.xls 28KB
技巧44 禁用宏则关闭工作簿.xls 28KB
技巧20 工作表事件的Target参数的使用方法.xls 28KB
技巧48 保存指定工作表为工作簿文件.xls 28KB
技巧30 工作表中一次插入多行.xls 27KB
DelMacro.xls 27KB
技巧21 引用工作表的方式.xls 26KB
190-4 使用With语句引用对象.xls 26KB
技巧26 禁止删除指定工作表.xls 26KB
技巧2 选定单元格区域的方法.xls 26KB
技巧4 定位单元格.xls 26KB
188-4 删除宏代码.xls 26KB
技巧45 关闭工作簿不显示保存对话框.xls 25KB
技巧28 工作表的深度隐藏.xls 25KB
技巧37 使用高级筛选获得不重复记录.xls 24KB
13-2 检查单元格是否含有公式.xls 24KB
11-3 为单元格区域添加边框.xls 24KB
15-1 判断单元格区域是否存在合并单元格.xls 24KB
技巧16 高亮显示单元格区域.xls 24KB
技巧41 新建工作簿文件.xls 24KB
营业所.xls 24KB
技巧173 查找文件或文件夹.xls 24KB
技巧32 删除工作表的重复行.xls 23KB
180-1 获取文件信息.xls 23KB
技巧6 替换单元格内字符串.xls 23KB
14-2 为单元格添加批注.xls 23KB
技巧31 删除工作表中的空行.xls 22KB
180-2 查找文件.xls 22KB
180-9 删除文件夹.xls 22KB
180-8 移动文件夹.xls 22KB
技巧3 获得指定行、列中的最后一个非空单元格.xls 22KB
190-1 关闭屏幕刷新.xls 22KB
180-7 复制文件夹.xls 22KB
14-1 判断单元格是否存在批注.xls 22KB
12-3 动态的数据有效性.xls 22KB
技巧43 判断指定工作簿是否打开.xls 22KB
安装公司.xls 21KB
180-3 移动文件.xls 21KB
180-4 复制文件.xls 21KB
180-6 创建文件夹.xls 21KB
180-5 删除文件.xls 21KB
技巧175 创建和删除文件夹.xls 21KB
技巧187 打开指定的网页.xls 21KB
188-1 添加模块和过程.xls 21KB
技巧35 限制工作表的滚动区域.xls 21KB
技巧177 移动指定的文件.xls 21KB
技巧19 录入数据后单元格自动保护.xls 21KB
技巧191 取得文件的基本名称.xls 21KB
技巧47 保存工作簿的方法.xls 21KB
技巧42 打开指定的工作簿.xls 21KB
污水处理厂.xls 20KB
技巧29 防止更改工作表的名称.xls 20KB
188-2 建立事件过程.xls 20KB
12-1 在单元格中建立数据有效性.xls 20KB
共 143 条
- 1
- 2
资源评论
protoss_bu
- 粉丝: 1
- 资源: 13
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功