{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["SQL Results","SQL Statement"],"not_rendered":{"external_links":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"SQL Results","index":0,"n_rows":407,"n_cols":7,"rows_kept":407,"merged":[[0,0,0,6]],"flags":["formulas_cached_only"]}
["2014年市直机关公开遴选公务员笔试成绩"]
["序号  ","姓名","准考证号","遴选机关","职位","笔试成绩","名次"]
["1","王立学","1401010426","中国民主促进会淄博市委员会","综合文秘","   70.9",1]
["2","李冬","1401010809","中国民主促进会淄博市委员会","综合文秘","   70.1",2]
["3","刘西发","1401011323","中国民主促进会淄博市委员会","综合文秘","   69.9",3]
["4","刘炳棋","1401010215","中国民主促进会淄博市委员会","综合文秘","   68.9",4]
["5","徐莹","1401010703","中国民主促进会淄博市委员会","综合文秘","   68.6",5]
["6","王萌萌","1401011305","中国民主促进会淄博市委员会","综合文秘","   68.2",6]
["7","耿丹丹","1401011017","中国民主促进会淄博市委员会","综合文秘","   68.1",7]
["8","刘珊珊","1401010927","中国民主促进会淄博市委员会","综合文秘","   67.4",8]
["9","王冲","1401010309","中国民主促进会淄博市委员会","综合文秘","   66.9",9]
["10","董蓬蓬","1401011116","中国民主促进会淄博市委员会","综合文秘","   66.4",10]
["11","苗雨","1401010706","中国民主促进会淄博市委员会","综合文秘","   64.9",11]
["12","赵虹","1401010326","中国民主促进会淄博市委员会","综合文秘","   64.6",12]
["13","武小涵","1401011222","中国民主促进会淄博市委员会","综合文秘","   63.9",13]
["14","董昌艳","1401010811","中国民主促进会淄博市委员会","综合文秘","   62.9",14]
["15","渠慧君","1401011008","中国民主促进会淄博市委员会","综合文秘","   62.9",14]
["16","李彩霞","1401011304","中国民主促进会淄博市委员会","综合文秘","   62.7",16]
["17","张洪波","1401010224","中国民主促进会淄博市委员会","综合文秘","   62.7",16]
["18","郝健","1401010621","中国民主促进会淄博市委员会","综合文秘","   60.4",18]
["19","王文君","1401010324","中国民主促进会淄博市委员会","综合文秘","   60.0",19]
["20","侯远志","1401010509","中国民主促进会淄博市委员会","综合文秘","   59.8",20]
["21","邵阳","1401010312","中国民主促进会淄博市委员会","综合文秘","   59.8",20]
["22","张英喆","1401011104","中国民主促进会淄博市委员会","综合文秘","   59.5",22]
["23","徐立鹏","1401010527","中国民主促进会淄博市委员会","综合文秘","   59.3",23]
["24","郭玉坤","1401010502","中国民主促进会淄博市委员会","综合文秘","   59.0",24]
["25","张银","1401010107","中国民主促进会淄博市委员会","综合文秘","    0.0",25]
["26","黄立欣","1401011019","市政府办公厅","综合文秘","   69.7",1]
["27","吕桂玲","1401011408","市政府办公厅","综合文秘","   65.6",2]
["28","徐世红","1401010617","市政府办公厅","综合文秘","   64.8",3]
["29","李通","1401010813","市政府办公厅","综合文秘","   62.7",4]
["30","贾友斌","1401010101","市政府办公厅","综合文秘","   62.5",5]
["31","刘凤玲","1401010713","市经信委","综合管理","   74.1",1]
["32","解纯杰","1401010421","市经信委","综合管理","   71.3",2]
["33","范增波","1401011320","市经信委","综合管理","   70.9",3]
["34","王世超","1401011005","市经信委","综合管理","   69.3",4]
["35","万晓辉","1401010104","市经信委","综合管理","   68.4",5]
["36","王琳琳","1401010528","市经信委","综合管理","   68.1",6]
["37","杨夏","1401010723","市经信委","综合管理","   67.9",7]
["38","李剑","1401010623","市经信委","综合管理","   67.8",8]
["39","邢翠翠","1401011109","市经信委","综合管理","   67.5",9]
["40","郝纪涛","1401010113","市经信委","综合管理","   67.2",10]
["41","田文娟","1401011120","市经信委","综合管理","   67.1",11]
["42","商淑真","1401011024","市经信委","综合管理","   67.0",12]
["43","闻晓","1401011016","市经信委","综合管理","   66.9",13]
["44","张政","1401010218","市经信委","综合管理","   66.6",14]
["45","杨金枝","1401010123","市经信委","综合管理","   66.5",15]
["46","袁钊","1401010219","市经信委","综合管理","   66.5",15]
["47","周佳霓","1401010803","市经信委","综合管理","   66.5",15]
["48","张丽丽","1401010425","市经信委","综合管理","   66.3",18]
["49","王雪","1401010430","市经信委","综合管理","   66.2",19]
["50","范成亮","1401010715","市经信委","综合管理","   66.1",20]
["51","李彦霞","1401011030","市经信委","综合管理","   66.0",21]
["52","李玉","1401010815","市经信委","综合管理","   65.5",22]
["53","李帅","1401011310","市经信委","综合管理","   65.2",23]
["54","崔涛","1401010625","市经信委","综合管理","   65.0",24]
["55","田晓丽","1401010521","市经信委","综合管理","   65.0",24]
["56","王健","1401010517","市经信委","综合管理","   65.0",24]
["57","李长进","1401011015","市经信委","综合管理","   65.0",24]
["58","高展","1401010820","市经信委","综合管理","   64.8",28]
["59","王晓宇","1401011210","市经信委","综合管理","   64.7",29]
["60","郭龙雪","1401010329","市经信委","综合管理","   64.5",30]
["61","李秉鑫","1401011014","市经信委","综合管理","   64.4",31]
["62","商泓钰","1401010230","市经信委","综合管理","   64.0",32]
["63","夏虎振","1401011105","市经信委","综合管理","   64.0",32]
["64","李奇峰","1401011414","市经信委","综合管理","   64.0",32]
["65","鲍剑侠","1401010330","市经信委","综合管理","   63.9",35]
["66","刘禄金","1401010117","市经信委","综合管理","   63.7",36]
["67","王淋","1401010904","市经信委","综合管理","   63.7",36]
["68","杜彬","1401011115","市经信委","综合管理","   63.7",36]
["69","董有为","1401011006","市经信委","综合管理","   63.6",39]
["70","陈作帅","1401011126","市经信委","综合管理","   63.5",40]
["71","马玉洁","1401011401","市经信委","综合管理","   63.5",40]
["72","刘迎春","1401011216","市经信委","综合管理","   63.5",40]
["73","石磊","1401010725","市经信委","综合管理","   63.4",43]
["74","刘珊","1401010216","市经信委","综合管理","   63.3",44]
["75","李劲","1401010307","市经信委","综合管理","   63.1",45]
["76","路文","1401010511","市经信委","综合管理","   63.1",45]
["77","李震","1401011319","市经信委","综合管理","   63.1",45]
["78","黄胜楠","1401011229","市经信委","综合管理","   63.0",48]
["79","朱维康","1401010108","市经信委","综合管理","   62.9",49]
["80","曹冬冬","1401010605","市经信委","综合管理","   62.9",49]
["81","韩雯","1401010306","市经信委","综合管理","   62.5",51]
["82","张荣耀","1401010516","市经信委","综合管理","   62.4",52]
["83","张伦","1401010912","市经信委","综合管理","   62.4",52]
["84","牛宁","1401010504","市经信委","综合管理","   62.0",54]
["85","张秀玲","1401011108","市经信委","综合管理","   62.0",54]
["86","陈官麟","1401011407","市经信委","综合管理","   62.0",54]
["87","任伟","1401010327","市经信委","综合管理","   61.9",57]
["88","岳唯斌","1401011207","市经信委","综合管理","   61.8",58]
["89","徐文强","1401010412","市经信委","综合管理","   61.3",59]
["90","王松涛","1401010415","市经信委","综合管理","   61.3",59]
["91","王帅坤","1401010829","市经信委","综合管理","   61.2",61]
["92","张倩","1401010209","市经信委","综合管理","   61.1",62]
["93","刘龙飞","1401011004","市经信委","综合管理","   60.8",63]
["94","张磊","1401011404","市经信委","综合管理","   60.8",63]
["95","阎道滨","1401010925","市经信委","综合管理","   60.6",65]
["96","倪晓菲","1401011316","市经信委","综合管理","   60.5",66]
["97","张豹","1401011225","市经信委","综合管理","   60.1",67]
["98","张峰","1401010203","市经信委","综合管理","   59.4",68]
["99","李凯","1401010525","市经信委","综合管理","   56.7",69]
["100","孙静","1401010920","市经信委","综合管理","   56.7",69]
["101","任涛","1401010512","市经信委","综合管理","   56.5",71]
["102","王皓","1401010609","市经信委","综合管理","   56.4",72]
["103","李骁光","1401010601","市经信委","综合管理","   55.8",73]
["104","张真真","1401010507","市经信委","综合管理","   51.6",74]
["105","张友","1401010824","市民政局","社会工作管理","   68.0",1]
["106","朱乐斌","1401010806","市民政局","社会工作管理","   64.3",2]
["107","郇程","1401010414","市民政局","社会工作管理","   60.4",3]
["108","唐武","1401010610","市民政局","社会工作管理","   59.2",4]
["109","邹敬","1401010223","市民政局","社会工作管理","    0.0",5]
["110","马娜","1401010913","市商务局","财会","   69.7",1]
["111","蒋伟","1401011301","市商务局","财会","   67.5",2]
["112","伊楠","1401010807","市商务局","财会","   67.1",3]
["113","张倩","1401010730","市商务局","财会","   66.6",4]
["114","王蕊","1401010419","市商务局","财会","   66.6",4]
["115","唐敬雷","1401010823","市商务局","财会","   64.3",6]
["116","李阳岑","1401011002","市商务局","财会","   63.1",7]
["117","高毅","1401010404","市商务局","财会","   62.9",8]
["118","李亚雯","1401010112","市商务局","财会","   62.5",9]
["119","王辉","1401010407","市商务局","财会","   61.8",10]
["120","荣慧","1401011010","市商务局","财会","   60.7",11]
["121","张溁丽","1401010714","市商务局","财会","   55.7",12]
["122","王春玲","1401011028","市商务局","财会","    0.0",13]
["123","徐莹","1401010226","市商务局","经贸管理","   71.5",1]
["124","孙晓姣","1401010410","市商务局","经贸管理","   70.5",2]
["125","李珂","1401010530","市商务局","经贸管理","   69.1",3]
["126","魏夏","1401011027","市商务局","经贸管理","   68.6",4]
["127","宫雪君","1401010519","市商务局","经贸管理","   68.2",5]
["128","刘宝敏","1401010207","市商务局","经贸管理","   66.4",6]
["129","巩莹","1401010403","市商务局","经贸管理","   65.7",7]
["130","赵伟","1401010221","市商务局","经贸管理","   65.5",8]
["131","王静","1401011309","市商务局","经贸管理","   65.3",9]
["132","孙璐","1401011013","市商务局","经贸管理","   65.2",10]
["133","魏洁","1401010826","市商务局","经贸管理","   64.9",11]
["134","刘敏杰","1401010718","市商务局","经贸管理","   64.6",12]
["135","黄凌慧","1401010702","市商务局","经贸管理","   64.5",13]
["136","张琛","1401010402","市商务局","经贸管理","   64.3",14]
["137","刘建鹏","1401010804","市商务局","经贸管理","   64.2",15]
["138","姚佳","1401010626","市商务局","经贸管理","   63.8",16]
["139","石帅","1401010229","市商务局","经贸管理","   63.7",17]
["140","赵延亭","1401011021","市商务局","经贸管理","   63.6",18]
["141","蒋钰鹏","1401011206","市商务局","经贸管理","   63.6",18]
["142","李雪","1401011122","市商务局","经贸管理","   63.5",20]
["143","马志远","1401010405","市商务局","经贸管理","   63.3",21]
["144","刘秉壮","1401011011","市商务局","经贸管理","   63.3",21]
["145","刘宁宁","1401010620","市商务局","经贸管理","   63.2",23]
["146","王奕奕","1401010424","市商务局","经贸管理","   63.1",24]
["147","仇聪聪","1401011411","市商务局","经贸管理","   62.9",25]
["148","代连丽","1401010720","市商务局","经贸管理","   62.6",26]
["149","高姗姗","1401011402","市商务局","经贸管理","   62.5",27]
["150","杨静","1401011306","市商务局","经贸管理","   62.2",28]
["151","王菊","1401010522","市商务局","经贸管理","   61.4",29]
["152","吴可钒","1401011220","市商务局","经贸管理","   60.3",30]
["153","张浩","1401010408","市商务局","经贸管理","   60.2",31]
["154","马岩","1401010514","市商务局","经贸管理","   59.6",32]
["155","房静","1401010724","市商务局","经贸管理","    0.0",33]
["156","孔丽媛","1401010102","市商务局","经贸管理","    0.0",33]
["157","李桂军","1401010915","市商务局","经贸管理","    0.0",33]
["158","周萌","1401010105","市商务局","经贸管理","    0.0",33]
["159","吴静","1401011302","市规划局二处","规划管理","   68.2",1]
["160","王景","1401010611","市规划局二处","规划管理","   66.6",2]
["161","井文萌","1401010926","市规划局二处","规划管理","   66.4",3]
["162","杨桂燕","1401011020","市规划局二处","规划管理","   65.2",4]
["163","常迎春","1401010315","市规划局二处","规划管理","   64.7",5]
["164","楚振元","1401010423","市规划局二处","规划管理","   64.2",6]
["165","王睿婧","1401010607","市规划局二处","规划管理","   63.8",7]
["166","王璨","1401010707","市规划局二处","规划管理","   61.9",8]
["167","杜冲","1401010505","市规划局二处","规划管理","   60.6",9]
["168","刘大伟","1401011230","市规划局二处","规划管理","   60.2",10]
["169","徐龙佶","1401010121","市规划局二处","规划管理","   58.8",11]
["170","仇慧清","1401011312","市规划局二处","规划管理","   58.5",12]
["171","王国瑞","1401010115","市规划局二处","规划管理","   58.3",13]
["172","夏栋","1401011219","市规划局二处","规划管理","   55.2",14]
["173","张卫卫","1401011009","市卫生计生委","财务管理","   71.3",1]
["174","邬润生","1401011315","市卫生计生委","财务管理","   71.0",2]
["175","周南","1401010328","市卫生计生委","财务管理","   70.2",3]
["176","孙静","1401010721","市卫生计生委","财务管理","   68.3",4]
["177","秦永波","1401011226","市卫生计生委","财务管理","   68.2",5]
["178","张健","1401011311","市卫生计生委","财务管理","   67.7",6]
["179","何媛媛","1401010126","市卫生计生委","财务管理","   65.4",7]
["180","张浩","1401011124","市卫生计生委","财务管理","   64.6",8]
["181","杨海生","1401010311","市卫生计生委","财务管理","   64.2",9]
["182","张爱平","1401010622","市卫生计生委","财务管理","   63.8",10]
["183","冯双伟","1401010612","市卫生计生委","财务管理","   63.7",11]
["184","刘泽融","1401011119","市卫生计生委","财务管理","   63.1",12]
["185","毕魏巍","1401010523","市卫生计生委","财务管理","   61.8",13]
["186","刘晴","1401010416","市卫生计生委","财务管理","   60.4",14]
["187","苏宁","1401010701","市卫生计生委","财务管理","   59.9",15]
["188","郑冰","1401010910","市卫生计生委","财务管理","   57.9",16]
["189","纪瑾","1401010406","市卫生计生委","财务管理","   57.8",17]
["190","李溶冰","1401010728","市卫生计生委","财务管理","    0.0",18]
["191","曲艳","1401010709","市卫生计生委","综合管理","   68.5",1]
["192","李磊","1401010830","市卫生计生委","综合管理","   68.0",2]
["193","刘喆","1401010111","市卫生计生委","综合管理","   67.1",3]
["194","王亚敏","1401010303","市卫生计生委","综合管理","   65.2",4]
["195","刘凯","1401010323","市卫生计生委","综合管理","   64.1",5]
["196","石磊","1401010205","市卫生计生委","综合管理","   61.1",6]
["197","王羽","1401010220","淄博市食品药品监督管理局","食品药品监管","   68.7",1]
["198","王慧","1401011026","淄博市食品药品监督管理局","食品药品监管","   67.4",2]
["199","李龙飞","1401010201","淄博市食品药品监督管理局","食品药品监管","   66.3",3]
["200","孙娜","1401011103","淄博市食品药品监督管理局","食品药品监管","   64.1",4]
["201","张晓华","1401010211","淄博市食品药品监督管理局","食品药品监管","   63.1",5]
["202","李燕","1401010508","淄博市食品药品监督管理局","食品药品监管","   59.4",6]
["203","蔡琳","1401010429","淄博市食品药品监督管理局","食品药品监管","   59.2",7]
["204","毕洧海","1401010921","淄博市食品药品监督管理局","食品药品监管","   58.4",8]
["205","岳宁","1401010924","淄博市食品药品监督管理局","食品药品监管","   58.4",8]
["206","邹政","1401011112","淄博市食品药品监督管理局","食品药品监管","   56.7",10]
["207","彭荣","1401010127","淄博市食品药品监督管理局","综合管理","   71.8",1]
["208","田金楠","1401011022","淄博市食品药品监督管理局","综合管理","   69.8",2]
["209","齐富强","1401010818","淄博市食品药品监督管理局","综合管理","   69.5",3]
["210","孟令鸽","1401010129","淄博市食品药品监督管理局","综合管理","   69.5",3]
["211","陈停","1401010606","淄博市食品药品监督管理局","综合管理","   69.3",5]
["212","王媛","1401010427","淄博市食品药品监督管理局","综合管理","   69.2",6]
["213","肖杨","1401010923","淄博市食品药品监督管理局","综合管理","   68.9",7]
["214","贾海宁","1401010919","淄博市食品药品监督管理局","综合管理","   68.5",8]
["215","李冠群","1401010308","淄博市食品药品监督管理局","综合管理","   67.9",9]
["216","宗哲","1401010828","淄博市食品药品监督管理局","综合管理","   67.7",10]
["217","毕东一","1401010301","淄博市食品药品监督管理局","综合管理","   67.3",11]
["218","魏丽君","1401011012","淄博市食品药品监督管理局","综合管理","   67.1",12]
["219","王澜博","1401011123","淄博市食品药品监督管理局","综合管理","   67.0",13]
["220","傅强","1401010120","淄博市食品药品监督管理局","综合管理","   66.5",14]
["221","于汝鑫","1401010529","淄博市食品药品监督管理局","综合管理","   66.3",15]
["222","池华","1401010909","淄博市食品药品监督管理局","综合管理","   66.1",16]
["223","王琳琳","1401010422","淄博市食品药品监督管理局","综合管理","   65.9",17]
["224","王玉莲","1401011224","淄博市食品药品监督管理局","综合管理","   65.3",18]
["225","孙函","1401010902","淄博市食品药品监督管理局","综合管理","   65.2",19]
["226","李妍嫣","1401011318","淄博市食品药品监督管理局","综合管理","   64.6",20]
["227","任玉姣","1401010726","淄博市食品药品监督管理局","综合管理","   64.5",21]
["228","李婷婷","1401010212","淄博市食品药品监督管理局","综合管理","   64.2",22]
["229","苏文凭","1401011329","淄博市食品药品监督管理局","综合管理","   64.2",22]
["230","马成栋","1401011211","淄博市食品药品监督管理局","综合管理","   64.1",24]
["231","关文","1401010428","淄博市食品药品监督管理局","综合管理","   63.4",25]
["232","田若雨","1401010510","淄博市食品药品监督管理局","综合管理","   63.1",26]
["233","赵佳","1401010619","淄博市食品药品监督管理局","综合管理","   63.0",27]
["234","董海林","1401011204","淄博市食品药品监督管理局","综合管理","   63.0",27]
["235","胡丹","1401011110","淄博市食品药品监督管理局","综合管理","   62.7",29]
["236","周锋","1401011117","淄博市食品药品监督管理局","综合管理","   61.0",30]
["237","杨斋","1401011128","淄博市食品药品监督管理局","综合管理","   60.7",31]
["238","李杨","1401010816","淄博市食品药品监督管理局","综合管理","   60.6",32]
["239","薛培培","1401011321","淄博市食品药品监督管理局","综合管理","   60.6",32]
["240","周琳","1401010202","淄博市食品药品监督管理局","综合管理","   60.5",34]
["241","赵勐","1401010729","淄博市食品药品监督管理局","综合管理","   60.5",34]
["242","王超","1401010125","淄博市食品药品监督管理局","综合管理","   60.4",36]
["243","刘晓单","1401010210","淄博市食品药品监督管理局","综合管理","   60.3",37]
["244","于红蕊","1401010603","淄博市食品药品监督管理局","综合管理","   60.3",37]
["245","陈瑶","1401010930","淄博市食品药品监督管理局","综合管理","   60.1",39]
["246","张大千","1401011221","淄博市食品药品监督管理局","综合管理","   59.9",40]
["247","李珊珊","1401010411","淄博市食品药品监督管理局","综合管理","   59.8",41]
["248","胡裕德","1401011003","淄博市食品药品监督管理局","综合管理","   59.1",42]
["249","石晖","1401011205","淄博市食品药品监督管理局","综合管理","   58.2",43]
["250","张琳","1401011308","淄博市食品药品监督管理局","综合管理","   57.7",44]
["251","薛通","1401010710","淄博市食品药品监督管理局","综合管理","   56.6",45]
["252","王彦婷","1401010319","淄博市食品药品监督管理局","综合管理","   53.7",46]
["253","刘婷婷","1401010321","淄博市食品药品监督管理局","综合管理","   51.9",47]
["254","孙涛","1401010928","淄博市食品药品监督管理局高新区分局","综合管理","   73.3",1]
["255","陈婷婷","1401010613","淄博市食品药品监督管理局高新区分局","综合管理","   71.6",2]
["256","孙艳艳","1401010103","淄博市食品药品监督管理局高新区分局","综合管理","   69.8",3]
["257","毕婷婷","1401011317","淄博市食品药品监督管理局高新区分局","综合管理","   69.8",3]
["258","徐贵娟","1401010503","淄博市食品药品监督管理局高新区分局","综合管理","   69.5",5]
["259","臧建建","1401010916","淄博市食品药品监督管理局高新区分局","综合管理","   69.2",6]
["260","李杨","1401010325","淄博市食品药品监督管理局高新区分局","综合管理","   67.4",7]
["261","王娜","1401010719","淄博市食品药品监督管理局高新区分局","综合管理","   67.4",7]
["262","朱晓艳","1401010418","淄博市食品药品监督管理局高新区分局","综合管理","   65.9",9]
["263","李振","1401010119","淄博市食品药品监督管理局高新区分局","综合管理","   65.6",10]
["264","崔倩","1401011102","淄博市食品药品监督管理局高新区分局","综合管理","   65.6",10]
["265","梁爽","1401010704","淄博市食品药品监督管理局高新区分局","综合管理","   65.4",12]
["266","邱海珍","1401011114","淄博市食品药品监督管理局高新区分局","综合管理","   65.4",12]
["267","尹玲","1401010905","淄博市食品药品监督管理局高新区分局","综合管理","   65.0",14]
["268","孙斌","1401010812","淄博市食品药品监督管理局高新区分局","综合管理","   64.8",15]
["269","鹿秀红","1401010922","淄博市食品药品监督管理局高新区分局","综合管理","   64.5",16]
["270","耿慧晶","1401010314","淄博市食品药品监督管理局高新区分局","综合管理","   64.4",17]
["271","张丽","1401011313","淄博市食品药品监督管理局高新区分局","综合管理","   64.3",18]
["272","路兵","1401010524","淄博市食品药品监督管理局高新区分局","综合管理","   64.2",19]
["273","赵玉","1401010618","淄博市食品药品监督管理局高新区分局","综合管理","   63.8",20]
["274","赵洋","1401010906","淄博市食品药品监督管理局高新区分局","综合管理","   63.5",21]
["275","毕大伟","1401010628","淄博市食品药品监督管理局高新区分局","综合管理","   63.4",22]
["276","王蕾","1401010808","淄博市食品药品监督管理局高新区分局","综合管理","   63.2",23]
["277","杨琳","1401010604","淄博市食品药品监督管理局高新区分局","综合管理","   62.9",24]
["278","陈鑫悦","1401011121","淄博市食品药品监督管理局高新区分局","综合管理","   62.8",25]
["279","王泽","1401011106","淄博市食品药品监督管理局高新区分局","综合管理","   62.8",25]
["280","战倩","1401011212","淄博市食品药品监督管理局高新区分局","综合管理","   61.8",27]
["281","武兵","1401010727","淄博市食品药品监督管理局高新区分局","综合管理","   61.2",28]
["282","徐辰","1401011218","淄博市食品药品监督管理局高新区分局","综合管理","   61.0",29]
["283","苏磊","1401010825","淄博市食品药品监督管理局高新区分局","综合管理","   61.0",29]
["284","高苗苗","1401010802","淄博市食品药品监督管理局高新区分局","综合管理","   60.2",31]
["285","张扬","1401011130","淄博市食品药品监督管理局高新区分局","综合管理","   60.0",32]
["286","周小娟","1401011101","淄博市食品药品监督管理局高新区分局","综合管理","   58.9",33]
["287","韩国威","1401010116","淄博市食品药品监督管理局高新区分局","综合管理","   58.8",34]
["288","陈晨","1401010506","淄博市食品药品监督管理局高新区分局","综合管理","   57.4",35]
["289","于海明","1401011228","淄博市食品药品监督管理局高新区分局","综合管理","   56.8",36]
["290","孟越","1401011326","淄博市食品药品监督管理局高新区分局","综合管理","   56.1",37]
["291","王超","1401011227","淄博市食品药品监督管理局高新区分局","综合管理","   53.9",38]
["292","周振","1401010204","市安全生产监督管理局","危化品安全监管","   72.3",1]
["293","庞文军","1401010110","市安全生产监督管理局","危化品安全监管","   67.7",2]
["294","陈斌","1401010417","市安全生产监督管理局","危化品安全监管","   67.0",3]
["295","李永梅","1401011415","市安全生产监督管理局","危化品安全监管","   66.8",4]
["296","唐行祥","1401010805","市安全生产监督管理局","危化品安全监管","   63.3",5]
["297","孙辉","1401011214","市安全生产监督管理局","危化品安全监管","   61.5",6]
["298","宋娟","1401010929","市安全生产监督管理局","危化品安全监管","   60.0",7]
["299","李新瑞","1401010615","市安全生产监督管理局","危化品安全监管","   57.3",8]
["300","曹胜男","1401011327","市安全生产监督管理局","危化品安全监管","   56.9",9]
["301","杨光亮","1401010109","市安全生产监督管理局","危化品安全监管","   55.3",10]
["302","董金磊","1401010814","市安全生产监督管理局","危化品安全监管","    0.0",11]
["303","王文晓","1401010317","市公共资源交易管理办公室","综合文秘","   74.7",1]
["304","焦光明","1401010822","市公共资源交易管理办公室","综合文秘","   72.6",2]
["305","姜晓卫","1401011325","市公共资源交易管理办公室","综合文秘","   71.0",3]
["306","刘天芹","1401010217","市公共资源交易管理办公室","综合文秘","   69.5",4]
["307","薛倩","1401010901","市公共资源交易管理办公室","综合文秘","   69.1",5]
["308","石爽","1401010914","市公共资源交易管理办公室","综合文秘","   68.7",6]
["309","宋宏博","1401010114","市公共资源交易管理办公室","综合文秘","   68.2",7]
["310","张芮","1401010518","市公共资源交易管理办公室","综合文秘","   68.2",7]
["311","刘瑞泽","1401011029","市公共资源交易管理办公室","综合文秘","   68.1",9]
["312","肖雅楠","1401010705","市公共资源交易管理办公室","综合文秘","   67.4",10]
["313","于丽萍","1401011303","市公共资源交易管理办公室","综合文秘","   67.3",11]
["314","隋蒙蒙","1401010711","市公共资源交易管理办公室","综合文秘","   67.2",12]
["315","石鑫","1401010302","市公共资源交易管理办公室","综合文秘","   67.1",13]
["316","董娟","1401010908","市公共资源交易管理办公室","综合文秘","   67.1",13]
["317","杜丽","1401010316","市公共资源交易管理办公室","综合文秘","   66.8",15]
["318","李丛丛","1401011018","市公共资源交易管理办公室","综合文秘","   66.8",15]
["319","刘欣然","1401010225","市公共资源交易管理办公室","综合文秘","   66.7",17]
["320","张慎涛","1401010624","市公共资源交易管理办公室","综合文秘","   66.7",17]
["321","李大双","1401010401","市公共资源交易管理办公室","综合文秘","   66.4",19]
["322","孟偲偲","1401010918","市公共资源交易管理办公室","综合文秘","   66.2",20]
["323","张秀梅","1401010526","市公共资源交易管理办公室","综合文秘","   65.8",21]
["324","许永娟","1401010907","市公共资源交易管理办公室","综合文秘","   65.6",22]
["325","高群翔","1401011322","市公共资源交易管理办公室","综合文秘","   65.3",23]
["326","严芳","1401010228","市公共资源交易管理办公室","综合文秘","   65.2",24]
["327","宋玉娟","1401010227","市公共资源交易管理办公室","综合文秘","   65.1",25]
["328","段红芳","1401011129","市公共资源交易管理办公室","综合文秘","   64.8",26]
["329","张珊珊","1401010515","市公共资源交易管理办公室","综合文秘","   64.6",27]
["330","孙斐","1401011314","市公共资源交易管理办公室","综合文秘","   64.3",28]
["331","于轩","1401010513","市公共资源交易管理办公室","综合文秘","   64.2",29]
["332","滕迎晖","1401011405","市公共资源交易管理办公室","综合文秘","   64.1",30]
["333","房琳","1401011403","市公共资源交易管理办公室","综合文秘","   64.0",31]
["334","赵国峰","1401010304","市公共资源交易管理办公室","综合文秘","   63.8",32]
["335","高倩","1401010630","市公共资源交易管理办公室","综合文秘","   63.8",32]
["336","朱秀珍","1401011107","市公共资源交易管理办公室","综合文秘","   63.6",34]
["337","杨洋","1401010821","市公共资源交易管理办公室","综合文秘","   63.2",35]
["338","孙新新","1401010616","市公共资源交易管理办公室","综合文秘","   62.8",36]
["339","蒲波","1401011412","市公共资源交易管理办公室","综合文秘","   62.6",37]
["340","李尧","1401011213","市公共资源交易管理办公室","综合文秘","   62.5",38]
["341","白涛","1401010106","市公共资源交易管理办公室","综合文秘","   62.3",39]
["342","王懿娜","1401011406","市公共资源交易管理办公室","综合文秘","   62.3",39]
["343","周晓霞","1401011330","市公共资源交易管理办公室","综合文秘","   62.2",41]
["344","张瑶","1401010318","市公共资源交易管理办公室","综合文秘","   61.7",42]
["345","周静","1401010213","市公共资源交易管理办公室","综合文秘","   61.3",43]
["346","邹倩","1401010322","市公共资源交易管理办公室","综合文秘","   60.9",44]
["347","邱苗苗","1401010801","市公共资源交易管理办公室","综合文秘","   60.9",44]
["348","张天鹏","1401010320","市公共资源交易管理办公室","综合文秘","   60.8",46]
["349","朱峰","1401011209","市公共资源交易管理办公室","综合文秘","   60.8",46]
["350","宗晓晓","1401010708","市公共资源交易管理办公室","综合文秘","   60.6",48]
["351","郗文娇","1401010629","市公共资源交易管理办公室","综合文秘","   60.1",49]
["352","昭国良","1401010810","市公共资源交易管理办公室","综合文秘","   60.0",50]
["353","徐蒙","1401010722","市公共资源交易管理办公室","综合文秘","   59.7",51]
["354","张振","1401010409","市公共资源交易管理办公室","综合文秘","   59.2",52]
["355","田蕾","1401010827","市公共资源交易管理办公室","综合文秘","   58.9",53]
["356","孙华丽","1401010208","市公共资源交易管理办公室","综合文秘","   58.8",54]
["357","张慧敏","1401010501","市公共资源交易管理办公室","综合文秘","   58.2",55]
["358","高磊","1401010716","市公共资源交易管理办公室","综合文秘","   57.9",56]
["359","耿喆","1401010819","市公共资源交易管理办公室","综合文秘","   57.5",57]
["360","孙莹","1401010118","市公共资源交易管理办公室","综合文秘","   52.7",58]
["361","李琳琳","1401010608","市公共资源交易管理办公室","综合文秘","    0.0",59]
["362","李文娜","1401010717","市公共资源交易管理办公室","督查管理","   68.2",1]
["363","李园","1401010911","市公共资源交易管理办公室","督查管理","   67.8",2]
["364","赵旭","1401011127","市公共资源交易管理办公室","督查管理","   67.7",3]
["365","尹肇炤","1401010420","市公共资源交易管理办公室","督查管理","   67.2",4]
["366","王新伟","1401010413","市公共资源交易管理办公室","督查管理","   67.1",5]
["367","刘琼","1401011203","市公共资源交易管理办公室","督查管理","   65.5",6]
["368","刘辰子","1401011007","市公共资源交易管理办公室","督查管理","   64.9",7]
["369","李宁","1401010917","市公共资源交易管理办公室","督查管理","   64.5",8]
["370","齐萍","1401010222","市公共资源交易管理办公室","督查管理","   64.5",8]
["371","李娜","1401011025","市公共资源交易管理办公室","督查管理","   64.2",10]
["372","黄凯","1401010520","市公共资源交易管理办公室","督查管理","   63.9",11]
["373","杨立斌","1401011201","市公共资源交易管理办公室","督查管理","   63.4",12]
["374","许健","1401010122","市公共资源交易管理办公室","督查管理","   63.2",13]
["375","石先锋","1401011217","市公共资源交易管理办公室","督查管理","   63.2",13]
["376","李娟","1401010602","市公共资源交易管理办公室","督查管理","   63.1",15]
["377","白欣灵","1401010903","市公共资源交易管理办公室","督查管理","   63.1",15]
["378","田甜","1401010313","市公共资源交易管理办公室","督查管理","   63.0",17]
["379","李睿","1401011413","市公共资源交易管理办公室","督查管理","   62.7",18]
["380","杨金涛","1401010627","市公共资源交易管理办公室","督查管理","   62.1",19]
["381","孙静","1401011215","市公共资源交易管理办公室","督查管理","   62.1",19]
["382","伊则桦","1401011208","市公共资源交易管理办公室","督查管理","   61.4",21]
["383","温正","1401010128","市公共资源交易管理办公室","督查管理","   61.2",22]
["384","胡月","1401011324","市公共资源交易管理办公室","督查管理","   60.6",23]
["385","王海泉","1401010712","市公共资源交易管理办公室","督查管理","   60.5",24]
["386","张茜","1401010817","市公共资源交易管理办公室","督查管理","   59.2",25]
["387","徐铮","1401011125","市公共资源交易管理办公室","督查管理","   58.3",26]
["388","翟俊尧","1401011409","市公共资源交易管理办公室","督查管理","   58.2",27]
["389","李静","1401010124","市公共资源交易管理办公室","督查管理","   57.3",28]
["390","张亮","1401011223","市公共资源交易管理办公室","督查管理","   55.5",29]
["391","宋子琦","1401010310","市公共资源交易管理办公室","督查管理","   43.8",30]
["392","崔建超","1401011113","市煤炭工业管理局（参公管理事业单位）","局域网维护","   66.7",1]
["393","朱彦彦","1401011202","市煤炭工业管理局（参公管理事业单位）","局域网维护","   64.2",2]
["394","高鹏","1401010614","市煤炭工业管理局（参公管理事业单位）","局域网维护","   64.0",3]
["395","岳瑞","1401010130","市煤炭工业管理局（参公管理事业单位）","局域网维护","   63.2",4]
["396","张成泉","1401011307","市煤炭工业管理局（参公管理事业单位）","局域网维护","   60.9",5]
["397","黄衍浦","1401010206","市煤炭工业管理局（参公管理事业单位）","局域网维护","   60.1",6]
["398","孙凤琴","1401011410","市煤炭工业管理局（参公管理事业单位）","局域网维护","   59.5",7]
["399","姜文杰","1401011111","市煤炭工业管理局（参公管理事业单位）","局域网维护","   55.5",8]
["400","张佳","1401011328","市煤炭工业管理局（参公管理事业单位）","局域网维护","    0.0",9]
["401","李艳霞","1401011023","市煤炭工业管理局（参公管理事业单位）","煤炭质量监管","   68.0",1]
["402","邵长龙","1401010214","市煤炭工业管理局（参公管理事业单位）","煤炭质量监管","   64.4",2]
["403","梁辉","1401011001","市煤炭工业管理局（参公管理事业单位）","煤炭质量监管","   59.8",3]
["404","张振","1401010305","市煤炭工业管理局（参公管理事业单位）","煤炭质量监管","   56.7",4]
["405","张振","1401011118","市煤炭工业管理局（参公管理事业单位）","煤炭质量监管","   48.8",5]

{"sheet":"SQL Statement","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"flags":["formulas_cached_only"]}
["select a.*,\n       rank() over(partition by a.department_id, a.station_id order by a.score desc, a.finalscore desc) ranknum\n  from (select ca.name,\n               ca.cardtype,\n               ca.cardno,\n               ca.work_date,\n               ca.work_year,\n               en.sub_gongzhong_id,\n               en.sub_jibie_id,\n               en.station_id,\n               en.department_id,\n               en.org_id,\n               en.compno,\n               (select os.org_station_code\n                  from org_station os\n                 where os.department_id = en.department_id\n                   and os.station_id = en.station_id\n                   and os.batch_id = en.batch_id) stationcode,\n               (select pd.department_name\n                  from department pd\n                 where pd.department_id = nvl(d.parent_id, d.department_id)) parentdeptname,\n               d.department_name,\n               (select st.station_name\n                  from station st\n                 where st.station_id = en.station_id) stationname,\n               (select s.subject_name\n                  from subject s\n                 where s.subject_id = en.sub_gongzhong_id) gzname,\n               (select s.subject_name\n                  from subject s\n                 where s.subject_id = en.sub_jibie_id) jbname,\n               (select s.subject_name\n                  from subject s\n                 where s.subject_id = sc.sub_kemu_id) kmname,\n               ca.orgname,\n               nvl(score_state, 0) scorestate,\n               case\n                 when sc.exam_record_id is not null then\n                  (select rt.record_type_name\n                     from exam_record er, record_type rt\n                    where er.record_type_id = rt.record_type_id\n                      and er.exam_record_id = sc.exam_record_id)\n                 else\n                  to_char(sc.score, '9990.9')\n               end score,\n               to_char(sc.final_score, '9990.9') finalscore,\n               sc.score_id,\n               en.enrollment_id,\n               en.testcardno,\n               (select decode(examinee_iso_answer_id, null, '0', '1')\n                  from examinee_iso_answer eia\n                 where eia.enrollment_id = en.enrollment_id\n                   and eia.exam_batch_id = sc.exam_batch_id) flag\n\n          from enrollment en, candidate ca, score sc, department d\n         where sc.batch_id = 934\n           and en.enrollment_id = sc.enrollment_id\n           and en.candidate_id = ca.candidate_id\n           and en.batch_id = ca.batch_id\n           and en.department_id = d.department_id\n           and d.valid_sign = 1\n           and en.del_sign = 0\n           and ca.del_sign = 0\n           and sc.exam_type = 0\n           and sc.score >= 0\n           and sc.score <= 100\n           and sc.exam_batch_id = 1266\n           and en.org_id in\n               (select org_id\n                  from organization\n                 start with org_id = 1\n                connect by prior org_id = parent_org_id)) a\n order by a.department_id, a.station_id,ranknum"]