4 数据分析之排序筛选分类汇总.xls

某单位各部门工资统计表No部门姓名基本工资奖金住房基金保险费实发工资级别1办公室陈鹏800.00700.00130.00100.001270.0082办公室王卫平685.00700.00100.00100.001185.0073办公室张晓寰685.00600.00100.00100.001085.0074办公室杨宝春613.00600.00100.00100.001013.0065人事处许东东800.00700.00130.00100.001270.0086人事处王川613.00700.00100.00100.001113.0067人事处艾芳685.00700.00100.00100.001185.0078财务处连威800.00700.00130.00100.001270.0089人事处王小明613.00600.00100.00100.001013.00610人事处胡海涛613.00600.00100.00100.001013.00611统计处庄凤仪800.00700.00130.00100.001270.00812统计处沈奇峰685.00600.00100.00100.001085.00713统计处沈克613.00600.00100.00100.001013.00614统计处岳晋生613.00600.00100.00100.001013.00615后勤处林海685.00700.00130.00100.001155.00716后勤处刘学燕613.00600.00100.00100.001013.006编号部门姓名一月二月三月四月五月六月1 办公室陈鹏8008008008008008802 办公室王卫平685685685685685753.53 办公室张晓寰685685685685685753.54 办公室杨宝春613613613613613674.35 人事处许东东8008008008008008806 人事处王川613613613613613674.37 人事处沈克8008008008008008808 人事处艾芳685685685685685753.59 人事处王小明613613613613613674.310 财务处胡海涛613613613613613674.311 财务处庄凤仪80080080080080088012 财务处沈奇峰685685685685685753.513 财务处连威613613613613613674.314 统计处岳晋生613613613613613674.315 统计处林海685685685685685753.516 统计处刘学燕613613613613613674.317 统计处钱五一685685685685685753.518 后勤处李春613613613613613674.319 后勤处方方613613613613613674.320 后勤处李红80080080080080088021 后勤处郭华685685685685685753.522 后勤处袁静613613613613613674.323 研究室赵海涛80080080080080088024 研究室孙娟613613613613613674.325 研究室周园艺80080080080080088026 研究室王光685685685685685753.527 研究室林有义613613613613613674.328 研究室孙建国613613613613613674.329 研究室张爱国80080080080080088030 研究室南平平685685685685685753.531 业务处胡小明80080080080080088020 后勤处李红80080080080080088021 后勤处郭华685685685685685753.522 后勤处袁静613613613613613674.323 研究室赵海涛80080080080080088024 研究室孙娟613613613613613674.325 研究室周园艺80080080080080088026 研究室王光685685685685685753.5七月八月九月十月十一月十二月8808808808808801180753.5753.5753.5753.5753.51053.5753.5753.5753.5753.5753.51053.5674.3674.3674.3674.3674.3974.38808808808808801180674.3674.3674.3674.3674.3974.38808808808808801180753.5753.5753.5753.5753.51053.5674.3674.3674.3674.3674.3974.3674.3674.3674.3674.3674.3974.38808808808808801180753.5753.5753.5753.5753.51053.5674.3674.3674.3674.3674.3974.3674.3674.3674.3674.3674.3974.3753.5753.5753.5753.5753.51053.5674.3674.3674.3674.3674.3974.3753.5753.5753.5753.5753.51053.5674.3674.3674.3674.3674.3974.3674.3674.3674.3674.3674.3974.38808808808808801180753.5753.5753.5753.5753.51053.5674.3674.3674.3674.3674.3974.38808808808808801180674.3674.3674.3674.3674.3974.38808808808808801180753.5753.5753.5753.5753.51053.5674.3674.3674.3674.3674.3974.3674.3674.3674.3674.3674.3974.38808808808808801180753.5753.5753.5753.5753.51053.588088088088088011808808808808808801180753.5753.5753.5753.5753.51053.5674.3674.3674.3674.3674.3974.38808808808808801180674.3674.3674.3674.3674.3974.38808808808808801180753.5753.5753.5753.5753.51053.5编号 单位名称联系人区号电话传真002英格尔公司北京办事处陈鹏(010)6505038665050383003北京智慧国际开发有限公司刘学燕(010)6328226664263436004北京燕美商城有限公司黄璐京(010)6465182064651820013中国青年报广告处沈克(010)6403396164035845邮编邮编=1000002040回研究生藏副编审大学本科日期星期姓名小时2010/3/2星期日任水滨0.62010/3/2星期日张晓寰0.82010/3/7星期日连威0.5行行标标签签求求和和项项:小小时时2010/3/8星期日黄璐京0.5星星期期日日9 92010/3/13星期日高琳1.5高琳2.32010/3/17星期日高琳0.8黄璐京12010/3/18星期日黄璐京0.5连威1.782010/3/19星期日张晓寰0.8任水滨0.62010/3/21星期日连威1.3王川1.722010/3/25星期日王川1.7张晓寰1.62010/3/2星期一王卫平0.5星星期期一一19.2719.272010/3/2星期一黄璐京1.5高琳2.342010/3/2星期一张晓寰0.5黄璐京72010/3/2星期一黄璐京1.0连威1.832010/3/2星期一王卫平0.5任水滨0.52010/3/2星期一任水滨0.5王川0.82010/3/2星期一杨宝春0.8王卫平1.52010/3/2星期一连威1.8许东东12010/3/3星期一许东东0.5杨宝春1.32010/3/3星期一王川0.8张晓寰32010/3/5星期一张晓寰1.0星星期期二二13.713.72010/3/5星期一杨宝春0.5高琳0.52010/3/6星期一黄璐京1.5黄璐京3.22010/3/7星期一张晓寰0.5连威12010/3/14星期一许东东0.5任水滨0.62010/3/18星期一高琳1.0王卫平2.42010/3/20星期一王卫平0.5许东东1.52010/3/21星期一张晓寰0.5杨宝春0.52010/3/21星期一黄璐京1.5张晓寰42010/3/22星期一张晓寰0.5星星期期三三3.73.72010/3/22星期一高琳1.4连威0.62010/3/27星期一黄璐京1.5王川0.52010/3/3星期二王卫平0.6王卫平12010/3/3星期二黄璐京0.8张晓寰1.62010/3/3星期二张晓寰0.8星星期期四四4.64.62010/3/3星期二张晓寰0.8高琳0.82010/3/3星期二张晓寰0.8黄璐京2.82010/3/3星期二杨宝春0.5王卫平12010/3/3星期二许东东1.5星星期期五五10.810.82010/3/3星期二连威1.0高琳3.442010/3/4星期二高琳0.5黄璐京3.52010/3/4星期二任水滨0.6王川0.62010/3/8星期二王卫平0.6许东东1.562010/3/9星期二黄璐京0.8张晓寰1.72010/3/9星期二黄璐京0.8星星期期六六5.885.882010/3/10星期二张晓寰0.8连威0.82010/3/15星期二王卫平0.6王川1.972010/3/23星期二王卫平0.6王卫平1.52010/3/24星期二黄璐京0.8许东东1.612010/3/25星期二张晓寰0.8总总计计66.9566.952010/3/4星期三王卫平0.52010/3/4星期三张晓寰0.82010/3/4星期三王川0.52010/3/4星期三连威0.62010/3/11星期三王卫平0.52010/3/12星期三张晓寰0.82010/3/5星期四黄璐京1.02010/3/5星期四王卫平0.52010/3/5星期四高琳0.82010/3/5星期四黄璐京0.82010/3/13星期四黄璐京1.02010/3/14星期四王卫平0.52010/3/2星期五高琳1.92010/3/6星期五张晓寰0.62010/3/6星期五黄璐京1.02010/3/6星期五张晓寰0.52010/3/6星期五黄璐京1.52010/3/6星期五许东东0.52010/3/15星期五张晓寰0.62010/3/15星期五王川0.62010/3/16星期五黄璐京1.02010/3/19星期五许东东1.12010/3/23星期五高琳1.52010/3/6星期六王川0.82010/3/7星期六王卫平0.52010/3/7星期六王卫平0.52010/3/16星期六连威0.82010/3/17星期六王卫平0.52010/3/20星期六王川1.22010/3/24星期六许东东1.6