课后练Excel基础综合练习题1小时

一、请使用把下表数值区域（蓝色字体）中大于或等于100的数值用显著颜色标识。表一离职类型一个月内两个月内半年内一年内两年内辞职员工中止合同1413575195178解雇公司中止合同1662502084试用期不合格2318316898108试用期内离职10213943436员工终止合同159901518597转动624182129112自离65889293二、请把B12单元格设置为只能录入6位数字或文本；且当操作员录入位数错误时，能提示错误原因。三、请把B15单元格设置为可以对表一中的离职类型的进行下拉选择的效果；请把B16单元格设置为可以对工作表第三题中的所有姓名进行下拉选择的效果；四、请仅对表一所在的整个区域进行保护锁定处理。五、请制作如下图左上角一致的表头。离职人数离职率离职人数离职率离职人数离职率UNW521093868297UNL16671526CIC11250HRDQAD13331月2月3月月份门部人数两年以上4615214718136173176请把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/26129900FAD000367魏春梅职员会计组长C12005/5/6423200说明一FAD000491唐玉金职员会计文员C22005/6/24262200编制公式，输入工号后可自动显示后面相关的人事资料。若可以，请进行容错处理。FAD000550王金荣职员会计主任O22005/8/17155200工号FAD000576邱寿强职员助理财务经理M32005/10/6206100000483FAD000578王芳职员助理财务经理M32005/10/18295000FAD000805林绮钏职员会计文员C22007/1/15392900说明二FAD000932赵建波职员会计副主任O32007/7/12312700编制公式，当输入姓名后可自动显示后面相关的人事资料。若可以，请进行容错处理。FAD001009梁丽芳职员会计文员C22007/9/24440200姓名FAD001653张静职员会计文员C22008/3/18405800刘小花FAD001745李桂彬职员会计组长C12008/9/16311100GMO000242邓欢欣职员助理主任O32005/4/176200说明三GMO000247黄星华职员助理主任O32005/4/1269900请编制公式，根据左表及以下给出的条件统计相关结果GMO000751杨素婷职员一级文员C22006/10/93082001、GMO000797姚瑜职员生产计划主任O22006/12/18241100GMO000872唐燕职员一级文员C22007/4/23484200GMO000911姚文秀职员二级文员C32007/6/21457700GMO001703黄杏碧职员一级文员C22008/5/26107900GMO001708孟黎惠职员一级文员C22008/6/164564003、GMO001733董伟健职员二级文员C32008/8/1185100GMO000754林舒娜职员秘书O32006/10/9431100GMO001741黄耀辉职员一级文员C22008/9/1199900GMO990082李玉心职员总经理E22006/12/1303600ISD000030刘建生职员资讯服务部经理M22005/2/135500ISD000727李小银职员电脑支援主任O22006/9/1473700ISD000927郭期孝职员电脑支援主任O22007/7/5244000ISD000929古志金职员电脑支援员C22007/7/9156000ISD000980胡安职员高级电脑支援员C12007/8/27403300ISD001723周剑凡职员高级电脑支援主任O12008/7/14437800ISD001805付劲松职员高级电脑支援员C12009/7/20117500ISD001819魏志伟职员高级电脑支援员C12009/8/24187800LAB000892余东洋职员实验室主任O22007/6/2466900LAB000969杜四霞职员一级文员C22007/8/14146300LAB000974梁泳珊职员一级文员C22007/8/20179300LAB001749费玉莲职员一级文员C22008/10/8256500LAB001806廖雪明职员一级文员C22009/7/20135400MC000289宋晓波职员高级面料控制主任O12005/4/127300要求1、编制公式请尽量简洁，并易于拖曳向右、向下等2、不能对原始数据表进行任何辅助操作MC000290周国红职员高级面料控制主任O12005/4/1431300MC000298贺少泉职员面料控制副主任O32005/4/1167200MC000465黄国兰职员面料控制副主任O32005/6/15119000MC000515叶颖旋职员高级面料控制员C12005/7/12185400MC000763黄美容职员面料控制副主任O32006/10/24229800MC000877杨希艳职员高级面料控制员C12007/5/7462800MC000940徐慧林职员面料控制副主任O32007/7/16384500MC000950汪佩职员高级面料控制员C12007/7/25352900MC001714李格萍职员高级面料控制员C12008/6/2373200MC001715区允玲职员高级面料控制员C12008/6/2339600MC001718杨昭云职员面料控制员C22008/7/1384900MC001740朱才生职员面料控制员C22008/9/1412500MC001748莫介上职员面料控制员C22008/10/820500MC990013张玉梅职员面料经理M22005/4/7399100MC000343蔡向阳职员高级主任O12005/5/1313900MC000345关劲职员助理主任O32005/5/1484600MC000348唐雁华职员助理主任O32005/5/1338800MC000486廖为山职员面料控制员C22005/6/23307000MC000573谢绪钊职员面料控制副主任O32005/9/26250600MC000692黄金辉职员助理主任O32006/6/26305700MC000856黄树根职员高级面料控制员C12007/4/2109200MC000873蒋平职员面料控制员C22007/5/1403000MC000992林春明职员面料控制员C22007/9/6312000MC990089郑伟文职员面料经理M22007/4/1316100MER000306姜小君职员跟单主任O22005/4/6491500MER000418兰艳职员跟单副主任O32005/6/3334100MER000865马碧意职员跟单主任O22007/4/12490900MER001598林艳艳职员助理主任O32007/11/1456400MER001713金月秋职员跟单副主任O32008/6/23350900MER990102毛伟益职员高级跟单经理M12005/4/1119100MER000178谭芳职员高级跟单主任O12005/3/15467300MER000548李云职员跟单副主任O32005/8/1314700MER000961司徒美娇职员跟单副主任O32007/8/690000MER000996林月桂职员跟单主任O22007/9/10159300MER990111崔智远职员后整发展经理M22009/7/1462100MER000056王振富职员助理主任O32005/3/1356300MER000484郑春强职员高级跟单主任O12005/6/21369700MER000684曾碧容职员高级跟单员C12006/6/1527600MER000811王丽职员跟单主任O22007/2/1283700MER000868覃秀音职员跟单主任O22007/4/1695000MER000937曾素清职员高级跟单员C12007/7/16427800MER001586张丹丹职员跟单副主任O32007/10/11324200MER001663邱伟职员跟单员C22008/3/31198800MER001780罗祯荣职员跟单主任O22009/3/9170000MER990027许艳芳职员高级跟单经理M12005/6/161600MER000043曾火林职员跟单主任O22005/3/1279400MER000223潘云霞职员跟单主任O22005/4/1297600MER000227李丽岫职员高级跟单主任O12005/4/1421900MER000706柯琳职员跟单主任O22006/7/19471300MER000882曾光平职员高级跟单主任O12007/5/11455900MER001702苏嘉敏职员跟单员C22008/5/2632800MER001742邹凤英职员高级跟单主任O12005/7/25483800MER001793张成义职员跟单员C22009/5/29471800MER001802赖晓欣职员跟单员C22009/6/24183600MER990096罗富华职员高级跟单经理M12008/3/1354400MER990110陈建民职员后整发展主任O22009/5/12136900MER000228陈满堂职员跟单主任O22005/4/1404100MER000232刘付芸职员跟单副经理M32005/4/1181900MER000808曾萌慧职员跟单员C22007/1/23301900MER990105赖成法职员跟单经理M22008/9/1138300MER000376钟关政职员高级跟单主任O12005/4/168500MER000383郑记忠职员跟单副主任O32005/5/16125900MER000735高秀叶职员高级跟单主任O12006/9/15349700MER000806吴玉玲职员跟单副主任O32007/1/19487100MER000839关腾蛟职员高级跟单主任O12007/3/20291400MER000849梁厚毅职员高级跟单员C12007/3/26412800MER000864李秀娟职员高级跟单主任O12007/4/11178100MER000917王洪职员跟单副主任O32007/6/28126000MER000981钟婷职员助理主任O32007/8/2876500MER000998宋正发职员助理主任O32007/9/10405000MER001578张艳芳职员跟单员C22007/10/5130100MER001658严业霞职员跟单主任O22008/3/21484700MER001677王灿职员一级文员C22008/4/97900MER001695劳杏友职员跟单员C22008/5/15499900MER001725钟名华职员跟单副主任O32008/7/1589900MER001816唐艳职员助理主任O32009/8/10279500MER990074吴铭泳职员跟单经理M22006/10/1254600MER990078周慧芬职员跟单主任O22006/11/1380900MER990083朱伟伦职员跟单经理M22007/2/1123400MER000040何绮玲职员跟单主任O22005/3/1247800MER000060梁小冰职员跟单副经理M32005/3/1111800MER001595操爱荣职员助理主任O32007/10/23475300MER001624倪丽职员高级跟单员C12007/12/2063000MER000453刘凯职员高级跟单主任O12005/6/1032400MER000522孟小梅职员跟单员C22005/7/19125900MER001585黄永源职员跟单主任O22007/10/10466700MER001630陆亮职员跟单主任O22008/1/3378400MER001632吴迪娜职员跟单员C22008/1/9101300MER001709吴卫珍职员跟单员C22008/6/16116200MER990085林荫职员跟单经理M22007/3/1280600PRD000277刘向荣职员高级生产计划主任O12005/4/1303100PRD000414薛红霞职员高级生产跟单员C12005/6/1444200PRD001670马瑛职员一级文员C22008/4/7326500PRD990035何淑娟职员高级经理M12005/6/1274800PRD990042吕宝玲职员跟单经理M22005/6/2863400PRD990044樊素贤职员助理生产计划控制经理M32005/7/11481300PRD990080郭玉金职员高级生产主任O12006/11/1126700PRD000269赵亮职员助理采购经理M32005/4/1214800PRD000723刘雪花职员辅料采购主任O22006/8/28294000PRD000760鄢晚君职员辅料采购副主任O32006/10/17464500PRD000764李军望职员高级辅料采购主任O12006/10/27473300PRD000801邹瑞君职员助理辅料采购员C32007/1/382900PRD000859陆美连职员辅料采购副主任O32007/4/4319800PRD000878罗小慕职员辅料采购员C22007/5/7254200PRD000944黄荣荣职员高级辅料采购员C12007/7/23366700PRD000962周小芳职员高级辅料采购员C12007/8/6297500PRD001001雷生娟职员辅料采购员C22007/9/18303400PRD001575赵四方职员一级文员C22007/9/26251600PRD001593覃彬平职员辅料采购员C22007/10/16235800PRD001594苏金桃职员助理辅料采购员C32007/10/16435700PRD001681李延峰职员辅料采购员C22008/4/14386500PRD001754刘志清职员二级文员C32008/10/17304100PRD001760朱君职员高级采购员C12005/1/22454900PRD001762伍萌职员辅料采购员C22008/7/226700PRD001765卢东云职员辅料采购员C22005/8/8275100PRD001766陈艾玲职员二级文员C32007/9/2685400PRD001790莫灵珊职员辅料采购员C22009/5/1841900PRD001792曾寰琦职员二级文员C32009/5/6335800PRD001796简妙玲职员辅料采购主任O22009/6/15352300PRD001822刘泽元职员采购副主任O32009/9/7302300PRD000283庄雪凤职员船务主任O22005/4/1235800PRD000444周淑贞职员船务主任O22005/6/3106000PRD990041张永兴职员助理船务经理M32005/6/1303000WRD001657朱桃飞职员行政助理C12008/3/5280700WRD001722赵汝调职员机械工程主任O22008/6/3232700WRD001724王磊职员化学工程主任O22008/7/14195400WRD001728尹建军职员技术支援助理经理M32008/7/1674700WRD001734叶银莹职员主任O22008/8/18481200WRD001781孙红梅职员实验室助理C12009/3/1619100WRD001821沈映才职员实验室助理C12009/9/3226500WRD990095郑敏濂职员副总经理技术支援E32008/1/2390900UNS000145黄丽莉职员排唛技术员F22005/4/1178400UNS000146林良国职员高级CMD主任O12005/4/1330700UNS000422梁锦梅职员高级排唛放码技术员F12005/5/1777200UNS000658黄玲彰职员排唛技术员F22006/5/5292700UNS000885周传均职员高级排唛放码技术员F12007/5/17116500UNS000970程铭职员排唛技术员F22007/8/14478900UNS000991吴新喜职员高级排唛放码技术员F12007/9/5229100UNS001120黄金彩职员高级排唛放码技术员F12005/4/1322100UNS001152邱基宏职员排唛技术员F22005/4/1278900UNS001170成志雄职员CMD副主任O32005/4/1163400UNS001252肖彩平职员排唛技术员F22005/4/1219600UNS001640罗圣锋职员排唛员G12008/2/25282100UNS000182刘超日薪B裁办员BG12005/3/7149400UNS000714朱民民日薪B裁办员BG12006/8/9283300UNS000825曾辉煌日薪B裁办员BG12007/3/562000UNS000836谢汝听日薪B裁办员BG12007/3/16277300UNS000997余凡中日薪B裁办员BG12007/9/10365800UNS001300李杰斌职员裁床组长F12005/4/1415000UNS001629陈世荣日薪A裁床部杂工G32007/10/15401600UNS001700曹战超日薪B裁办员BG12008/5/2097000UNS000115周奇志日薪B烫办BG12005/3/1221500UNS000311赵代政日薪B后整打钮员BG12005/4/8407800UNS000416邱启松职员后整组长F12005/6/2304200UNS000643古尽华日薪A车间部杂工G32006/3/302900UNS000667陈香华日薪B后整打钮员BG12006/5/29253000UNS000862田丹霞日薪B后整打钮员BG12007/4/6481600UNS000893阳利金日薪B后整打钮员BG12007/6/4312100UNS000984李月明日薪B后整打钮员BG12007/8/31407600UNS001635廖柏生日薪B烫办BG12006/3/20145700UNS990016李明德职员办房经理M22005/4/153300UNS990022伍笑霞职员高级主任O12005/4/1213500UNS000072孙锦龙职员高级纸样技术员F12005/3/1486000UNS000077易育莉职员高级纸样技术员F12005/3/1405500UNS000082陈上海职员高级纸样技术员F12005/3/119900UNS000083占小林职员高级纸样技术员F12005/3/1461800UNS000405陈立香职员高级纸样技术员F12005/4/1189200UNS000428张道遥职员纸样技术员F22005/5/18195700UNS000447邓小军职员高级纸样技术员F12005/6/350200UNS000899闵伯仲职员高级纸样技术员F12007/6/11131400UNS000922花丽职员助理纸样师傅O32007/7/3209700UNS001020邓湘元职员纸样师傅O22005/4/1315100UNS001029黄庆和职员高级纸样师傅O12005/4/1183900UNS001048廖小平职员高级纸样技术员F12005/4/162200UNS001102刘荣华职员纸样师傅O22005/4/1334800UNS001103蔡刚职员助理纸样师傅O32005/4/1238400UNS001650李秋霖职员高级纸样技术员F12008/3/15263400UNS001682张方春职员高级纸样技术员F12008/4/14175800UNS000204李美崇日薪AQC员G12005/3/19268700UNS000408杨汉杰日薪AQC员G12005/5/27142000UNS000680卜桂明日薪AQC员G12006/6/12465200UNS000787郑科苗日薪AQC员G12006/12/168100UNS000891李珍日薪AQC员G12007/6/4375400UNS001006王娥职员QC组长F12005/4/1360600UNS001738覃秀颜日薪AQC员G12008/8/29321400UNS001779徐继红日薪AQC员G12009/3/2290700UNS001789玉秋梅日薪AQC员G12009/5/1862500UNS001820蔡晓飞日薪AQC员G12009/9/3113900UNS000032胡长会日薪B车办员BG12005/3/3139000UNS000167刘宇鹏日薪B车办员BG12005/3/14489300UNS000181张忠盛日薪B车办员BG12005/3/9301600UNS000191张明娥日薪B车办员BG12005/3/16413500UNS000192刘和平日薪B车办员BG12005/3/16191200UNS000261肖兰英日薪B车办员BG12005/4/1291000UNS000310罗远春日薪B车办员BG12005/4/842400UNS000353谢海辉日薪B车办员BG12005/4/27177900UNS000388何芬秀职员车间组长F12005/4/162600UNS000390王梅琼日薪B车办员BG12005/5/1158600UNS000437谭丙生职员车间副主任O32005/4/1277100UNS000439钟丽春职员高级车间主任O12005/4/162800UNS000442邓春香日薪A车办员G12005/4/1294000UNS000467刘俊华日薪B车办员BG12005/6/1516100UNS000476易建伟日薪B车办员BG12005/6/20241700UNS000483林曼姿职员一级文员（办房）F22005/6/21160400UNS000489卢建军日薪B车办员BG12005/6/2416100UNS000551谢全香日薪B车办员BG12005/8/18285700UNS000636梁民翔日薪B车办员BG12006/3/20422000UNS000673谭金秀日薪B车办员BG12006/6/3156200UNS000749林顺日薪B车办员BG12006/9/23366600UNS000766肖小花日薪B车办员BG12006/10/3083600UNS000786蒋永建日薪B车办员BG12006/12/2234200UNS000815刘石生日薪B车办员BG12007/3/2353400UNS000823张青基日薪B车办员BG12007/3/6344800UNS000876蓝定华日薪B车办员BG12007/5/7402600UNS000881刘功俊日薪B车办员BG12007/5/1458400UNS000905张荣生日薪B车办员BG12007/6/1433100UNS000949曾林皆日薪B车办员BG12007/7/25250900UNS000972何芸秀日薪B车办员BG12007/8/16215000UNS001022陈礼容职员车间副主任O32005/4/173000UNS001028钟家权职员车间副主任O32005/4/1479200UNS001041陈奎职员车间组长F12005/4/176100UNS001044潘玲职员车间组长F12005/4/181500UNS001073魏春明职员车间组长F12005/4/165400UNS001085张绍银日薪B车办员BG12005/4/1216800UNS001129胡贱妹日薪A车办员G12005/4/172300UNS001259刘学军日薪B车办员BG12005/4/151300UNS001611程良伟日薪B车办员BG12007/11/20388700UNS001617严建国日薪B车办员BG12007/11/24178400UNS001618黎娜日薪A车办员G12007/11/26259100UNS001636苏晓妮职员三级文员（办房）G22008/2/18255600UNS001643刘桂芳日薪B车办员BG12007/11/2294900UNS001651黄石凤职员三级文员（办房）G22008/3/15377300UNS001652张建全日薪B车办员BG12008/3/17383800UNS001680王璋静日薪B车办员BG12008/4/10358600UNS001687曾祥娇日薪B车办员BG12008/4/17466500UNS001688沈凤林日薪B车办员BG12008/4/17328800UNS001689赵国英日薪B车办员BG12008/4/22170300UNS001690谢更梅职员三级文员（办房）G22008/4/2515200UNS001691贺海燕日薪B车办员BG12008/5/7182600UNS001692马旦健日薪B车办员BG12008/5/12237400UNS001706贾开平日薪B车办员BG12008/5/2924100UNS001707黄玲敏日薪A车间收发G22008/6/11286500UNS001712卢艳芬日薪B车办员BG12008/6/23243000UNS001743陆元伟日薪B车办员BG12008/9/11345800UNS001753张勇日薪B车办员BG12008/10/1589500UNS001758程荣华日薪B车办员BG12008/10/2232900UNS001777肖小燕日薪A车办员G12009/2/11315700UNS001778卢建朝日薪B车办员BG12009/2/16292800UNS001782颜克英日薪B车办员BG12009/3/17244400UNS001784李双平日薪B车办员BG12009/3/31305100UNS001785高咸贵日薪B车办员BG12009/4/23410900UNS001786朱永亮日薪B车办员BG12009/4/23301400UNS001787孙新欢日薪B车办员BG12009/5/4454200UNS001788王建银日薪B车办员BG12009/5/666200UNS001791师菊日薪B车办员BG12009/5/19179800UNS001794丁雪春日薪B车办员BG12009/6/1316200UNS001798梁少妍日薪A车间收发G22009/6/19400UNS001799陈石保日薪B车办员BG12009/6/2317800UNS001807黄华日薪B车办员BG12009/7/28268000UNS001809马传梅日薪A车办员G12009/8/3388500UNS001812花书和日薪A车办员G12009/8/3312600UNS001814陈刚日薪A车办员G12009/8/4122500UNS001817董群芳日薪A车办员G12009/8/10249900UNS001818李延强职员机修员G12009/8/21365800UNS000653苏山青职员仓务组长F12006/4/12122800UNS001646周继涛日薪A仓务什工G32008/3/5381800编制公式，输入工号后可自动显示后面相关的人事资料。若可以，请进行容错处理。姓名级别入职日期工种职位名称编制公式，当输入姓名后可自动显示后面相关的人事资料。若可以，请进行容错处理。部门工号工资请编制公式，根据左表及以下给出的条件统计相关结果工种人数2、部门工种人数职员UNS职员日薪AUNS日薪A日薪BUNS日薪B部门工资总额4、部门工种工资总额FADUNS职员MERUNS日薪AUNSUNS日薪B要求1、编制公式请尽量简洁，并易于拖曳向右、向下等2、不能对原始数据表进行任何辅助操作原始记录说明00004320090124500一、A列是食堂消费系统导出的数据，全为文本格式；60305620090124500二、前6位为工号，中间8位为消费日期，最后几位为消费金额；00099820090124500三、请根据以上内容,快速统计出000937200901245001、每人消费金额001001200901245002、每月消费金每季度消费金额000242200901245004、年度消费总金额0004182009012450000091120090124500001703200901245000008722009012450000079720090124500304676200901245000018162009012450000022320090124500001766200901245000017622009012450000096220090124500500016200901245000000562009012450030525320090124500000306200901245003093432009012450000093220090124500001790200901245000017452009012450000179220090124500000989200901245000008012009012450000168120090124500000228200901245000004142009012450000165320090124500001670200901245000004912009012450030750620090124500000550200901245000017492009012450000033920090124500000917200901245003056522009012450000080620090124500001781200901245003023392009012450000165720090124500001722200901245003006802009012450030495520090124500000980200901245003093932009012450030843320090124500000929200901245003005732009012450000036720090124500304703200901245006004722009012450000165820090124500001819200901245003092622009012450030001420090124500001724200901245003093662009012450000180520090124500304596200901245003035622009012450030066020090124500302346200901245003070442009012450000104420090124500305481200901245000008852009012450000038820090124500000422200901245003091032009012450030750220090124500001650200901245000008992009012450000008320090124500308456200901245000000722009012450030626920090124500308975200901245003064812009012450030711520090124500307953200901245003078402009012450030789220090124500308138200901245003066112009012450030097120090124500307887200901245003010902009012450030556320090124500305436200901245006003132009012450030266920090124500307108200901245003064472009012450030926220090124500304324200901245003055772009012450030940520090124500000522200901245003041862009012450000034520090124500305160200901245003044672009012450030028320090124500300337200901245003085202009012450030944620090124500309968200901262003075022009012820030789220090128200309397200901282003015562009012820030207720090128200307295200901282003058382009012820030889620090128200000815200901282003091812009012820000088520090128200600500200901282003009712009012820030860220090128200302670200901282003070752009012820030519020090128200306386200901282003085922009012820030704420090128200305891200901282003092702009012820030611020090128200000881200901282003032182009020150030381320090201500306259200902015003072672009020150030612320090201500300263200902015003065692009020150030922620090201500305253200902015006001622009020150000083620090201500307892200902015003091032009020150000163620090201500600240200902015003051802009020150060006920090201500308154200902015003081712009020150030807820090201500301138200902015003082752009020150030860220090201500302695200902015003078912009020150030850520090201500600046200902015003082982009020150060050520090201500306766200902015003080992009020150000165020090201500000388200902015003043902009020150030647320090201500309232200902015003057142009020150030934620090201500301556200902015003075022009020150000110220090201500301590200902015003019472009020150030930220090201500305563200902015003062172009020150030406320090201500308920200902015003093632009020150030910420090201500600508200902015000010412009020150030591520090201500309125200902015003074772009020150030719420090201500309003200902015003057162009020150030266920090201500300971200902015003079532009020150030711920090201500307755200902015006000682009020150000018120090201500305800200902015003010902009020150030298920090201500303227200902015003062702009020150030719720090201500302545200902015003055772009020150030298420090201500000522200902015003046622009020150030710820090201500308738200902015003069662009020150030664220090201500303357200902015003073482009020150030775320090201500307380200902015003020492009020150030693820090201500306087200902015003066722009020150030866020090201500309102200902015003059292009020150030879920090201500303822200902015003075572009020150030391120090201500300283200902015003020562009020150030717920090201500301476200902015003044672009020150030932520090201500305802200902015003062812009020150030584620090201500304749200902015003060512009020150030701220090201500308055200902015003003372009020150030897420090201500309175200902015003058512009020150030547420090201500306145200902015003071872009020150030914620090201500305988200902015003077312009020150060024620090201500302721200902015003080532009020150030868820090201500305672200902015003039052009020150030933820090201500307682200902015003091442009020150030818420090201500307285200902015003066462009020150030516020090201500309262200902015003038212009020150030381220090201500001792200902015003038052009020150000024720090201500001741200902015000016632009020150030470320090201500000306200902015000000432009020150000022320090201500001793200902015000005502009020150000076020090201500303520200902015003075062009020150030495520090201500000932200902015003047632009020150000174520090201500001578200902015000003832009020150030698920090201500000811200902015000003392009020150060047220090201500302339200902015003006802009020150000163220090201500300726200902015003051902009020150030750520090201500001593200902015000017662009020150000087220090201500001762200902015000017082009020150000091120090201500300014200902015000017092009020150030682120090201500001740200902015000017962009020150000098920090201500000961200902015000009272009020150000180520090201500000980200902015000009292009020150000080120090201500001749200902015000016952009020150030725720090201500001624200902015000007272009020150000157520090201500000944200902015000008592009020150000168120090201500001718200902015003038112009020150030748320090201500000437200902015003038132009020150030726720090201500302205200902015003035102009020150060017320090201500303562200902015003085052009020150030808620090201500308099200902015003071942009020150030777320090201500300405200902015003048502009020150030726620090201500307080200902015003079532009020150030710820090201500306881200902015003071172009020150030439020090