Excel考核参考答案

一、请使用把下表数值区域（蓝色字体）中大于或等于100的数值用显著颜色标识。表一离职类型一个月内两个月内半年内一年内两年内辞职员工中止合同7913015514117解雇公司中止合同81103110106试用期不合格176968384174试用期内离职1171517219016员工终止合同461914316616转动2493178177132自离15220195193191二、请把B12单元格设置为只能录入6位数字或文本；且当操作员录入位数错误时，能提示错误原因。三、请把B15单元格设置为可以对表一中的离职类型的进行下拉选择的效果；请把B16单元格设置为可以对工作表第三题中的所有姓名进行下拉选择的效果；解雇公司中止合同解雇公司中止合同李月明唐玉金职员四、请仅对表一所在的整个区域进行保护锁定处理。五、请制作如下图左上角一致的表头。离职人数离职率离职人数离职率离职人数离职率UNW521093868297UNL16671526CIC11250HRDQAD13331月2月3月月份门部人数部门两年以上7698196110144165159请把B12单元格设置为只能录入6位数字或文本；且当操作员录入位数错误时，能提示错误原因。请把B15单元格设置为可以对表一中的离职类型的进行下拉选择的效果；请把B16单元格设置为可以对工作表第三题中的所有姓名进行下拉选择的效果；月份部门人数月份产值说明150000请直接使用左边的数据做出如下图一致的图表2750003420004880005900006600007111000898000910002010350001180550121098002008年度产值分析图表200004000060000800001000001200001月2月3月4月5月6月7月8月9月10月11月12月2008年度产值分析图表200004000060000800001000001200001月2月3月4月5月6月7月8月9月10月11月12月部门工号姓名工种职位名称级别入职日期工资FAD000339刘小花职员会计组长C12005/4/26473400FAD000367魏春梅职员会计组长C12005/5/695800说明一FAD000491唐玉金职员会计文员C22005/6/24294800编制公式，输入工号后可自动显示后面相关的人事资料。若可以，请进行容错处理。FAD000550王金荣职员会计主任O22005/8/1792100工号FAD000576邱寿强职员助理财务经理M32005/10/6445400000483FAD000578王芳职员助理财务经理M32005/10/18356100FAD000805林绮钏职员会计文员C22007/1/15385200说明二FAD000932赵建波职员会计副主任O32007/7/12476100编制公式，当输入姓名后可自动显示后面相关的人事资料。若可以，请进行容错处理。FAD001009梁丽芳职员会计文员C22007/9/24422000姓名FAD001653张静职员会计文员C22008/3/18436900赵建波FAD001745李桂彬职员会计组长C12008/9/1626600GMO000242邓欢欣职员助理主任O32005/4/1126800说明三GMO000247黄星华职员助理主任O32005/4/1181800请编制公式，根据左表及以下给出的条件统计相关结果GMO000751杨素婷职员一级文员C22006/10/94878001、GMO000797姚瑜职员生产计划主任O22006/12/18330900GMO000872唐燕职员一级文员C22007/4/23132400GMO000911姚文秀职员二级文员C32007/6/21291400GMO001703黄杏碧职员一级文员C22008/5/26186400GMO001708孟黎惠职员一级文员C22008/6/163816003、GMO001733董伟健职员二级文员C32008/8/1190100GMO000754林舒娜职员秘书O32006/10/9330500GMO001741黄耀辉职员一级文员C22008/9/1299200GMO990082李玉心职员总经理E22006/12/1217900ISD000030刘建生职员资讯服务部经理M22005/2/1276300ISD000727李小银职员电脑支援主任O22006/9/1485900ISD000927郭期孝职员电脑支援主任O22007/7/5366600ISD000929古志金职员电脑支援员C22007/7/9334400ISD000980胡安职员高级电脑支援员C12007/8/27394300ISD001723周剑凡职员高级电脑支援主任O12008/7/14304200ISD001805付劲松职员高级电脑支援员C12009/7/20473600ISD001819魏志伟职员高级电脑支援员C12009/8/24245400LAB000892余东洋职员实验室主任O22007/6/2168000LAB000969杜四霞职员一级文员C22007/8/14350200LAB000974梁泳珊职员一级文员C22007/8/20391100LAB001749费玉莲职员一级文员C22008/10/8197500LAB001806廖雪明职员一级文员C22009/7/20244400MC000289宋晓波职员高级面料控制主任O12005/4/1282800要求1、编制公式请尽量简洁，并易于拖曳向右、向下等2、不能对原始数据表进行任何辅助操作MC000290周国红职员高级面料控制主任O12005/4/1235200MC000298贺少泉职员面料控制副主任O32005/4/131000MC000465黄国兰职员面料控制副主任O32005/6/15257800MC000515叶颖旋职员高级面料控制员C12005/7/1235800MC000763黄美容职员面料控制副主任O32006/10/2410600MC000877杨希艳职员高级面料控制员C12007/5/7296200MC000940徐慧林职员面料控制副主任O32007/7/1632600MC000950汪佩职员高级面料控制员C12007/7/25270000MC001714李格萍职员高级面料控制员C12008/6/23419900MC001715区允玲职员高级面料控制员C12008/6/23210700MC001718杨昭云职员面料控制员C22008/7/1136900MC001740朱才生职员面料控制员C22008/9/165800MC001748莫介上职员面料控制员C22008/10/8131800MC990013张玉梅职员面料经理M22005/4/7311300MC000343蔡向阳职员高级主任O12005/5/1280400MC000345关劲职员助理主任O32005/5/1101000MC000348唐雁华职员助理主任O32005/5/1389200MC000486廖为山职员面料控制员C22005/6/23213000MC000573谢绪钊职员面料控制副主任O32005/9/2632200MC000692黄金辉职员助理主任O32006/6/26380100MC000856黄树根职员高级面料控制员C12007/4/2196600MC000873蒋平职员面料控制员C22007/5/1396800MC000992林春明职员面料控制员C22007/9/6491600MC990089郑伟文职员面料经理M22007/4/140000MER000306姜小君职员跟单主任O22005/4/6243900MER000418兰艳职员跟单副主任O32005/6/3182000MER000865马碧意职员跟单主任O22007/4/12485100MER001598林艳艳职员助理主任O32007/11/174000MER001713金月秋职员跟单副主任O32008/6/23313500MER990102毛伟益职员高级跟单经理M12005/4/1343200MER000178谭芳职员高级跟单主任O12005/3/1593000MER000548李云职员跟单副主任O32005/8/13332800MER000961司徒美娇职员跟单副主任O32007/8/6415600MER000996林月桂职员跟单主任O22007/9/10452800MER990111崔智远职员后整发展经理M22009/7/1255800MER000056王振富职员助理主任O32005/3/1198500MER000484郑春强职员高级跟单主任O12005/6/21427600MER000684曾碧容职员高级跟单员C12006/6/15135400MER000811王丽职员跟单主任O22007/2/1326300MER000868覃秀音职员跟单主任O22007/4/1658600MER000937曾素清职员高级跟单员C12007/7/16160400MER001586张丹丹职员跟单副主任O32007/10/11437100MER001663邱伟职员跟单员C22008/3/3194500MER001780罗祯荣职员跟单主任O22009/3/9340200MER990027许艳芳职员高级跟单经理M12005/6/1435100MER000043曾火林职员跟单主任O22005/3/1439200MER000223潘云霞职员跟单主任O22005/4/1238000MER000227李丽岫职员高级跟单主任O12005/4/1352200MER000706柯琳职员跟单主任O22006/7/19302500MER000882曾光平职员高级跟单主任O12007/5/11258800MER001702苏嘉敏职员跟单员C22008/5/2656900MER001742邹凤英职员高级跟单主任O12005/7/25457100MER001793张成义职员跟单员C22009/5/29235400MER001802赖晓欣职员跟单员C22009/6/2417700MER990096罗富华职员高级跟单经理M12008/3/1351400MER990110陈建民职员后整发展主任O22009/5/12219200MER000228陈满堂职员跟单主任O22005/4/1145900MER000232刘付芸职员跟单副经理M32005/4/1347800MER000808曾萌慧职员跟单员C22007/1/23468600MER990105赖成法职员跟单经理M22008/9/1354100MER000376钟关政职员高级跟单主任O12005/4/162700MER000383郑记忠职员跟单副主任O32005/5/1669400MER000735高秀叶职员高级跟单主任O12006/9/15353400MER000806吴玉玲职员跟单副主任O32007/1/19361700MER000839关腾蛟职员高级跟单主任O12007/3/2017400MER000849梁厚毅职员高级跟单员C12007/3/26106600MER000864李秀娟职员高级跟单主任O12007/4/11129500MER000917王洪职员跟单副主任O32007/6/2838800MER000981钟婷职员助理主任O32007/8/28397800MER000998宋正发职员助理主任O32007/9/10458200MER001578张艳芳职员跟单员C22007/10/5314200MER001658严业霞职员跟单主任O22008/3/21248100MER001677王灿职员一级文员C22008/4/9256900MER001695劳杏友职员跟单员C22008/5/15316000MER001725钟名华职员跟单副主任O32008/7/15410600MER001816唐艳职员助理主任O32009/8/1052500MER990074吴铭泳职员跟单经理M22006/10/1469400MER990078周慧芬职员跟单主任O22006/11/1227200MER990083朱伟伦职员跟单经理M22007/2/1116200MER000040何绮玲职员跟单主任O22005/3/1148900MER000060梁小冰职员跟单副经理M32005/3/1310800MER001595操爱荣职员助理主任O32007/10/23208600MER001624倪丽职员高级跟单员C12007/12/20465200MER000453刘凯职员高级跟单主任O12005/6/10226900MER000522孟小梅职员跟单员C22005/7/19168500MER001585黄永源职员跟单主任O22007/10/10432100MER001630陆亮职员跟单主任O22008/1/3124100MER001632吴迪娜职员跟单员C22008/1/9389100MER001709吴卫珍职员跟单员C22008/6/16410200MER990085林荫职员跟单经理M22007/3/12423500PRD000277刘向荣职员高级生产计划主任O12005/4/1484500PRD000414薛红霞职员高级生产跟单员C12005/6/192800PRD001670马瑛职员一级文员C22008/4/7413600PRD990035何淑娟职员高级经理M12005/6/181600PRD990042吕宝玲职员跟单经理M22005/6/28212500PRD990044樊素贤职员助理生产计划控制经理M32005/7/11237000PRD990080郭玉金职员高级生产主任O12006/11/1424700PRD000269赵亮职员助理采购经理M32005/4/1213400PRD000723刘雪花职员辅料采购主任O22006/8/28261600PRD000760鄢晚君职员辅料采购副主任O32006/10/17454700PRD000764李军望职员高级辅料采购主任O12006/10/27433700PRD000801邹瑞君职员助理辅料采购员C32007/1/3106900PRD000859陆美连职员辅料采购副主任O32007/4/4281100PRD000878罗小慕职员辅料采购员C22007/5/7475000PRD000944黄荣荣职员高级辅料采购员C12007/7/23250100PRD000962周小芳职员高级辅料采购员C12007/8/6464000PRD001001雷生娟职员辅料采购员C22007/9/18416600PRD001575赵四方职员一级文员C22007/9/26132100PRD001593覃彬平职员辅料采购员C22007/10/16389000PRD001594苏金桃职员助理辅料采购员C32007/10/1625100PRD001681李延峰职员辅料采购员C22008/4/14485300PRD001754刘志清职员二级文员C32008/10/17160500PRD001760朱君职员高级采购员C12005/1/2245000PRD001762伍萌职员辅料采购员C22008/7/214200PRD001765卢东云职员辅料采购员C22005/8/8269700PRD001766陈艾玲职员二级文员C32007/9/2613600PRD001790莫灵珊职员辅料采购员C22009/5/18278400PRD001792曾寰琦职员二级文员C32009/5/6430100PRD001796简妙玲职员辅料采购主任O22009/6/15207400PRD001822刘泽元职员采购副主任O32009/9/7263600PRD000283庄雪凤职员船务主任O22005/4/163200PRD000444周淑贞职员船务主任O22005/6/3238800PRD990041张永兴职员助理船务经理M32005/6/1253500WRD001657朱桃飞职员行政助理C12008/3/5146900WRD001722赵汝调职员机械工程主任O22008/6/3470700WRD001724王磊职员化学工程主任O22008/7/14143400WRD001728尹建军职员技术支援助理经理M32008/7/1672800WRD001734叶银莹职员主任O22008/8/1831300WRD001781孙红梅职员实验室助理C12009/3/16467400WRD001821沈映才职员实验室助理C12009/9/3480100WRD990095郑敏濂职员副总经理技术支援E32008/1/2464500UNS000145黄丽莉职员排唛技术员F22005/4/1367800UNS000146林良国职员高级CMD主任O12005/4/1133600UNS000422梁锦梅职员高级排唛放码技术员F12005/5/1791400UNS000658黄玲彰职员排唛技术员F22006/5/5240400UNS000885周传均职员高级排唛放码技术员F12007/5/1763100UNS000970程铭职员排唛技术员F22007/8/1420800UNS000991吴新喜职员高级排唛放码技术员F12007/9/584300UNS001120黄金彩职员高级排唛放码技术员F12005/4/1451800UNS001152邱基宏职员排唛技术员F22005/4/15600UNS001170成志雄职员CMD副主任O32005/4/1459200UNS001252肖彩平职员排唛技术员F22005/4/141500UNS001640罗圣锋职员排唛员G12008/2/2529800UNS000182刘超日薪B裁办员BG12005/3/7391700UNS000714朱民民日薪B裁办员BG12006/8/9455100UNS000825曾辉煌日薪B裁办员BG12007/3/5314100UNS000836谢汝听日薪B裁办员BG12007/3/16144400UNS000997余凡中日薪B裁办员BG12007/9/10285900UNS001300李杰斌职员裁床组长F12005/4/1496200UNS001629陈世荣日薪A裁床部杂工G32007/10/15434500UNS001700曹战超日薪B裁办员BG12008/5/204300UNS000115周奇志日薪B烫办BG12005/3/178100UNS000311赵代政日薪B后整打钮员BG12005/4/8389800UNS000416邱启松职员后整组长F12005/6/2239200UNS000643古尽华日薪A车间部杂工G32006/3/307100UNS000667陈香华日薪B后整打钮员BG12006/5/29255300UNS000862田丹霞日薪B后整打钮员BG12007/4/6325900UNS000893阳利金日薪B后整打钮员BG12007/6/4133600UNS000984李月明日薪B后整打钮员BG12007/8/31298900UNS001635廖柏生日薪B烫办BG12006/3/20190700UNS990016李明德职员办房经理M22005/4/1453100UNS990022伍笑霞职员高级主任O12005/4/1263300UNS000072孙锦龙职员高级纸样技术员F12005/3/1257600UNS000077易育莉职员高级纸样技术员F12005/3/1383400UNS000082陈上海职员高级纸样技术员F12005/3/1447200UNS000083占小林职员高级纸样技术员F12005/3/1125000UNS000405陈立香职员高级纸样技术员F12005/4/1499900UNS000428张道遥职员纸样技术员F22005/5/1816500UNS000447邓小军职员高级纸样技术员F12005/6/3382900UNS000899闵伯仲职员高级纸样技术员F12007/6/11354100UNS000922花丽职员助理纸样师傅O32007/7/3247700UNS001020邓湘元职员纸样师傅O22005/4/118000UNS001029黄庆和职员高级纸样师傅O12005/4/1299700UNS001048廖小平职员高级纸样技术员F12005/4/1330700UNS001102刘荣华职员纸样师傅O22005/4/1132700UNS001103蔡刚职员助理纸样师傅O32005/4/1260700UNS001650李秋霖职员高级纸样技术员F12008/3/15110200UNS001682张方春职员高级纸样技术员F12008/4/1427700UNS000204李美崇日薪AQC员G12005/3/19288700UNS000408杨汉杰日薪AQC员G12005/5/2724200UNS000680卜桂明日薪AQC员G12006/6/1227100UNS000787郑科苗日薪AQC员G12006/12/1436700UNS000891李珍日薪AQC员G12007/6/4310100UNS001006王娥职员QC组长F12005/4/1233400UNS001738覃秀颜日薪AQC员G12008/8/29462700UNS001779徐继红日薪AQC员G12009/3/2111300UNS001789玉秋梅日薪AQC员G12009/5/1821300UNS001820蔡晓飞日薪AQC员G12009/9/3356600UNS000032胡长会日薪B车办员BG12005/3/3129600UNS000167刘宇鹏日薪B车办员BG12005/3/146000UNS000181张忠盛日薪B车办员BG12005/3/9246800UNS000191张明娥日薪B车办员BG12005/3/16475300UNS000192刘和平日薪B车办员BG12005/3/16491700UNS000261肖兰英日薪B车办员BG12005/4/1190200UNS000310罗远春日薪B车办员BG12005/4/8322100UNS000353谢海辉日薪B车办员BG12005/4/2724900UNS000388何芬秀职员车间组长F12005/4/1242300UNS000390王梅琼日薪B车办员BG12005/5/1200400UNS000437谭丙生职员车间副主任O32005/4/1166800UNS000439钟丽春职员高级车间主任O12005/4/1210800UNS000442邓春香日薪A车办员G12005/4/1318200UNS000467刘俊华日薪B车办员BG12005/6/1574900UNS000476易建伟日薪B车办员BG12005/6/20134900UNS000483林曼姿职员一级文员（办房）F22005/6/21379200UNS000489卢建军日薪B车办员BG12005/6/2430600UNS000551谢全香日薪B车办员BG12005/8/18424800UNS000636梁民翔日薪B车办员BG12006/3/20315100UNS000673谭金秀日薪B车办员BG12006/6/3213600UNS000749林顺日薪B车办员BG12006/9/2342700UNS000766肖小花日薪B车办员BG12006/10/304000UNS000786蒋永建日薪B车办员BG12006/12/2275100UNS000815刘石生日薪B车办员BG12007/3/2485800UNS000823张青基日薪B车办员BG12007/3/6376900UNS000876蓝定华日薪B车办员BG12007/5/7147100UNS000881刘功俊日薪B车办员BG12007/5/14481200UNS000905张荣生日薪B车办员BG12007/6/14364500UNS000949曾林皆日薪B车办员BG12007/7/2551100UNS000972何芸秀日薪B车办员BG12007/8/16477900UNS001022陈礼容职员车间副主任O32005/4/18200UNS001028钟家权职员车间副主任O32005/4/1141800UNS001041陈奎职员车间组长F12005/4/1395900UNS001044潘玲职员车间组长F12005/4/1379700UNS001073魏春明职员车间组长F12005/4/1252700UNS001085张绍银日薪B车办员BG12005/4/1461800UNS001129胡贱妹日薪A车办员G12005/4/1342000UNS001259刘学军日薪B车办员BG12005/4/1285200UNS001611程良伟日薪B车办员BG12007/11/20457200UNS001617严建国日薪B车办员BG12007/11/24226700UNS001618黎娜日薪A车办员G12007/11/26434300UNS001636苏晓妮职员三级文员（办房）G22008/2/182000UNS001643刘桂芳日薪B车办员BG12007/11/27600UNS001651黄石凤职员三级文员（办房）G22008/3/15480100UNS001652张建全日薪B车办员BG12008/3/17240600UNS001680王璋静日薪B车办员BG12008/4/10328900UNS001687曾祥娇日薪B车办员BG12008/4/17215400UNS001688沈凤林日薪B车办员BG12008/4/17450100UNS001689赵国英日薪B车办员BG12008/4/22397700UNS001690谢更梅职员三级文员（办房）G22008/4/25172900UNS001691贺海燕日薪B车办员BG12008/5/7275900UNS001692马旦健日薪B车办员BG12008/5/12489900UNS001706贾开平日薪B车办员BG12008/5/2965700UNS001707黄玲敏日薪A车间收发G22008/6/11355200UNS001712卢艳芬日薪B车办员BG12008/6/23244800UNS001743陆元伟日薪B车办员BG12008/9/11298100UNS001753张勇日薪B车办员BG12008/10/15481000UNS001758程荣华日薪B车办员BG12008/10/22319300UNS001777肖小燕日薪A车办员G12009/2/1198400UNS001778卢建朝日薪B车办员BG12009/2/16317500UNS001782颜克英日薪B车办员BG12009/3/17288300UNS001784李双平日薪B车办员BG12009/3/31335700UNS001785高咸贵日薪B车办员BG12009/4/235600UNS001786朱永亮日薪B车办员BG12009/4/2393400UNS001787孙新欢日薪B车办员BG12009/5/4324000UNS001788王建银日薪B车办员BG12009/5/6215700UNS001791师菊日薪B车办员BG12009/5/19110100UNS001794丁雪春日薪B车办员BG12009/6/168000UNS001798梁少妍日薪A车间收发G22009/6/19230900UNS001799陈石保日薪B车办员BG12009/6/2362600UNS001807黄华日薪B车办员BG12009/7/28283900UNS001809马传梅日薪A车办员G12009/8/3248000UNS001812花书和日薪A车办员G12009/8/3135300UNS001814陈刚日薪A车办员G12009/8/47500UNS001817董群芳日薪A车办员G12009/8/10452000UNS001818李延强职员机修员G12009/8/21281200UNS000653苏山青职员仓务组长F12006/4/12442900UNS001646周继涛日薪A仓务什工G32008/3/5900编制公式，输入工号后可自动显示后面相关的人事资料。若可以，请进行容错处理。姓名级别入职日期工种职位名称林曼姿F220050621职员一级文员（办房）林曼姿编制公式，当输入姓名后可自动显示后面相关的人事资料。若可以，请进行容错处理。部门工号工资FAD0009324761请编制公式，根据左表及以下给出的条件统计相关结果工种人数2、部门工种人数职员215UNS职员47日薪A22UNS日薪A22日薪B66UNS日薪B66部门工资总额4、部门工种工资总额FAD35044UNS职员111250MER177647UNS日薪A51030UNS327337UNS日薪B165057要求1、编制公式请尽量简洁，并易于拖曳向右、向下等2、不能对原始数据表进行任何辅助操作原始记录说明0000432009012450000004320090124一、A列是食堂消费系统导出的数据，全为文本格式；6030562009012450060305620090124二、前6位为工号，中间8位为消费日期，最后几位为消费金额；0009982009012450000099820090124三、请根据以上内容,快速统计出00093720090124500000937200901241、每人消费金额00100120090124500001001200901242、每月消费金额30381220090124500303812200901243、每季度消费金额00024220090124500000242200901244、年度消费总金额0004182009012450000041820090124000911200901245000009112009012400170320090124500001703200901240008722009012450000087220090124步骤00079720090124500000797200901241、文本分列30467620090124500304676200901242、转换日期格式00181620090124500001816200901243、数据透视表00022320090124500000223200901244、日期组合001766200901245000017662009012400176220090124500001762200901240009622009012450000096220090124500016200901245005000162009012400005620090124500000056200901243052532009012450030525320090124000306200901245000003062009012430934320090124500309343200901240009322009012450000093220090124001790200901245000017902009012400174520090124500001745200901240017922009012450000179220090124000989200901245000009892009012400080120090124500000801200901240016812009012450000168120090124000228200901245000002282009012400041420090124500000414200901240016532009012450000165320090124001670200901245000016702009012400049120090124500000491200901243075062009012450030750620090124000550200901245000005502009012400174920090124500001749200901240003392009012450000033920090124000917200901245000009172009012430565220090124500305652200901240008062009012450000080620090124001781200901245000017812009012430233920090124500302339200901240016572009012450000165720090124001722200901245000017222009012430068020090124500300680200901243049552009012450030495520090124000980200901245000009802009012430939320090124500309393200901243084332009012450030843320090124000929200901245000009292009012430057320090124500300573200901240003672009012450000036720090124304703200901245003047032009012460047220090124500600472200901240016582009012450000165820090124001819200901245000018192009012430926220090124500309262200901243000142009012450030001420090124001724200901245000017242009012430936620090124500309366200901240018052009012450000180520090124304596200901245003045962009012430356220090124500303562200901243006602009012450030066020090124302346200901245003023462009012430704420090124500307044200901240010442009012450000104420090124305481200901245003054812009012400088520090124500000885200901240003882009012450000038820090124000422200901245000004222009012430910320090124500309103200901243075022009012450030750220090124001650200901245000016502009012400089920090124500000899200901240000832009012450000008320090124308456200901245003084562009012400007220090124500000072200901243062692009012450030626920090124308975200901245003089752009012430648120090124500306481200901243071152009012450030711520090124307953200901245003079532009012430784020090124500307840200901243078922009012450030789220090124308138200901245003081382009012430661120090124500306611200901243009712009012450030097120090124307887200901245003078872009012430109020090124500301090200901243055632009012450030556320090124305436200901245003054362009012460031320090124500600313200901243026692009012450030266920090124307108200901245003071082009012430644720090124500306447200901243092622009012450030926220090124304324200901245003043242009012430557720090124500305577200901243094052009012450030940520090124000522200901245000005222009012430418620090124500304186200901240003452009012450000034520090124305160200901245003051602009012430446720090124500304467200901243002832009012450030028320090124300337200901245003003372009012430852020090124500308520200901243094462009012450030944620090124309968200901262003099682009012630750220090128200307502200901283078922009012820030789220090128309397200901282003093972009012830155620090128200301556200901283020772009012820030207720090128307295200901282003072952009012830583820090128200305838200901283088962009012820030889620090128000815200901282000008152009012830918120090128200309181200901280008852009012820000088520090128600500200901282006005002009012830097120090128200300971200901283086022009012820030860220090128302670200901282003026702009012830707520090128200307075200901283051902009012820030519020090128306386200901282003063862009012830859220090128200308592200901283070442009012820030704420090128305891200901282003058912009012830927020090128200309270200901283061102009012820030611020090128000881200901282000008812009012830321820090201500303218200902013038132009020150030381320090201306259200902015003062592009020130726720090201500307267200902013061232009020150030612320090201300263200902015003002632009020130656920090201500306569200902013092262009020150030922620090201305253200902015003052532009020160016220090201500600162200902010008362009020150000083620090201307892200902015003078922009020130910320090201500309103200902010016362009020150000163620090201600240200902015006002402009020130518020090201500305180200902016000692009020150060006920090201308154200902015003081542009020130817120090201500308171200902013080782009020150030807820090201301138200902015003011382009020130827520090201500308275200902013086022009020150030860220090201302695200902015003026952009020130789120090201500307891200902013085052009020150030850520090201600046200902015006000462009020130829820090201500308298200902016005052009020150060050520090201306766200902015003067662009020130809920090201500308099200902010016502009020150000165020090201000388200902015000003882009020130439020090201500304390200902013064732009020150030647320090201309232200902015003092322009020130571420090201500305714200902013093462009020150030934620090201301556200902015003015562009020130750220090201500307502200902010011022009020150000110220090201301590200902015003015902009020130194720090201500301947200902013093022009020150030930220090201305563200902015003055632009020130621720090201500306217200902013040632009020150030406320090201308920200902015003089202009020130936320090201500309363200902013091042009020150030910420090201600508200902015006005082009020100104120090201500001041