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

{"sheet":"Select select","index":0,"n_rows":57,"n_cols":10,"rows_kept":57,"merged":[[1,0,1,9],[4,1,11,1],[4,2,11,2],[12,1,14,1],[12,2,14,2],[15,1,20,1],[15,2,20,2],[21,1,28,1],[21,2,28,2],[29,1,34,1],[29,2,34,2],[35,1,39,1],[35,2,39,2],[40,1,42,1],[40,2,42,2],[44,1,50,1],[44,2,50,2],[51,1,55,1],[51,2,55,2],[56,0,56,6]],"flags":["formulas_cached_only"]}
["附件1"]
["2018级各专业拟接纳转入学生人数情况一览表"]
[]
["序号","学院代码","学院名称","专业代码","专业名称","学制","校区","专业在校\n学生数","班级数","拟接纳转入\n学生数"]
[1,"01","土木工程学院","0101","土木工程","4","南校区",179,4,31]
[2,null,null,"0103","勘查技术与工程","4","南校区",42,1,18]
[3,null,null,"0104","安全工程","4","南校区",88,2,22]
[4,null,null,"0105","测绘工程","4","南校区",42,1,18]
[5,null,null,"0107","地质工程","4","南校区",43,1,17]
[6,null,null,"0108","道路桥梁与渡河工程","4","南校区",88,2,22]
[7,null,null,"0109","交通工程","4","南校区",46,1,9]
[8,null,null,"0112","城市地下空间工程","4","南校区",89,2,21]
[9,"02","建筑与规划学院","0201","建筑学","5","北校区",50,2,22]
[10,null,null,"0207","城乡规划","5","北校区",53,2,17]
[11,null,null,"0208","风景园林","4","北校区",66,2,4]
[12,"03","环境与能源工程学院","0303","环境工程","4","南校区",44,1,11]
[13,null,null,"0308","建筑环境与能源应用工程","4","南校区",89,2,21]
[14,null,null,"0309","给排水科学与工程","4","南校区",90,2,20]
[15,null,null,"0310","能源与动力工程","4","南校区",89,2,21]
[16,null,null,"0311","地理信息科学","4","南校区",43,1,17]
[17,null,null,"0313","环境生态工程","4","南校区",43,1,17]
[18,"04","经济与管理学院","0402","工程管理","4","南校区",89,2,21]
[19,null,null,"0403","财务管理","4","北校区",90,2,20]
[20,null,null,"0405","会计学","4","北校区",89,2,21]
[21,null,null,"0408","经济学","4","北校区",45,1,15]
[22,null,null,"0414","房地产开发与管理","4","南校区",45,1,15]
[23,null,null,"0415","工程造价","4","南校区",88,2,22]
[24,null,null,"0416","金融工程","4","北校区",88,2,22]
[25,null,null,"0417","资产评估","4","北校区",44,1,11]
[26,"05","电子与信息工程学院","0501","电子信息工程","4","南校区",87,2,23]
[27,null,null,"0502","计算机科学与技术","4","南校区",87,2,23]
[28,null,null,"0504","通信工程","4","南校区",47,1,8]
[29,null,null,"0505","网络工程","4","南校区",49,1,11]
[30,null,null,"0506","建筑电气与智能化","4","南校区",86,2,24]
[31,null,null,"0520","物联网工程","4","南校区",93,2,17]
[32,"06","材料与化学工程学院","0601","无机非金属材料工程","4","南校区",88,2,22]
[33,null,null,"0602","高分子材料与工程","4","南校区",89,2,21]
[34,null,null,"0603","应用化学","4","南校区",45,1,15]
[35,null,null,"0604","化学工程与工艺","4","南校区",44,1,16]
[36,null,null,"0612","金属材料工程","4","南校区",43,1,17]
[37,"07","数理学院","0703","应用物理学","4","南校区",43,1,17]
[38,null,null,"0704","统计学","4","南校区",86,2,34]
[39,null,null,"0705","声学","4","南校区",43,1,17]
[40,"08","外国语学院","0801","英语","4","南校区",89,3,30]
[41,"10","机械与电气工程学院","1001","机械设计制造及其自动化","4","南校区",88,2,22]
[42,null,null,"1002","电气工程及其自动化","4","南校区",90,2,20]
[43,null,null,"1003","自动化","4","南校区",93,2,17]
[44,null,null,"1004","测控技术与仪器","4","南校区",42,1,18]
[45,null,null,"1005","工业设计","4","南校区",43,1,17]
[46,null,null,"1006","过程装备与控制工程","4","南校区",44,1,16]
[47,null,null,"1007","机械电子工程","4","南校区",49,1,6]
[48,"11","公共管理学院","1101","法学","4","南校区",87,2,23]
[49,null,null,"1102","人力资源管理","4","南校区",79,2,31]
[50,null,null,"1103","劳动与社会保障","4","南校区",43,1,17]
[51,null,null,"1104","土地资源管理","4","南校区",45,1,15]
[52,null,null,"1105","城市管理","4","南校区",45,1,15]
["合计",{"$nulls":6},3529,83,967]

{"sheet":"SQL Statement","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"flags":["formulas_cached_only"]}
["select jgdm,jgmc,zyh,zymc,xz,xqh_id,count(*) as zyrs from(\r\nselect b.jgdm,b.jgmc,c.zyh,c.zymc,d.bj,d.xqh_id,a.*\r\nfrom jw_xjgl_xsjbxxb a,zftal_xtgl_jgdmb b,zftal_xtgl_zydmb c,zftal_xtgl_bjdmb d\r\nwhere substr(trim(a.xh),1,2)='18' and length(trim(a.xh_id))=11\r\nand a.xh not in (select xh from wbd2018)\r\nand a.xh not in('18201040229','18202070220','18205010226','18211030141','18201050143','18204150126','18205060241')\r\nand a.zyh_id not in('0422','0424','0906')\r\nand a.jg_id=b.jg_id\r\nand a.zyh_id=c.zyh_id\r\nand a.bh_id=d.bh_id\r\n) group by jgdm,jgmc,zyh,zymc,xz,xqh_id order by jgdm,zyh"]