{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["教室分配原则","二区教室分配方案","一区教室分配方案"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"教室分配原则","index":0,"n_rows":55,"n_cols":13,"rows_kept":55,"merged":[[1,8,6,8],[8,8,12,8],[18,0,18,7],[36,1,36,10],[47,1,47,10]]}
["学院代码","学生学院","19级班级","20级班级","21级班级","22级班级","学院班级总数","所属校区","校区班级总数","分配教室数量","取整后教室数量"]
[101,"先进制造工程学院",12,12,16,19,{"$f":"SUM(C2:F2)","v":59},"二区",226,{"$f":"65/226*G2","v":16.969026548672566},17]
[102,"人工智能与大数据学院",10,9,14,18,{"$f":"SUM(C3:F3)","v":51},"二区",null,{"$f":"65/226*G3","v":14.668141592920355},15]
[103,"城市建设与交通学院",4,4,8,9,25,"二区",null,7.1902654867256635,7]
[104,"生物食品与环境学院",6,5,6,8,25,"二区",null,7.1902654867256635,7]
[105,"能源材料与化工学院",6,7,6,8,27,"二区",null,7.765486725663717,8]
[106,"设计学院",9,9,10,11,39,"二区",null,11.216814159292035,11]
[{"$nulls":10},{"$f":"SUM(K2:K7)","v":65}]
[107,"经济与管理学院",24,25,25,27,101,"一区",177,{"$f":"64/177*G9","v":36.51977401129943},35]
[108,"语言文化与传媒学院",3,3,5,7,18,"一区",null,{"$f":"64/177*G10","v":6.508474576271187},7]
[109,"教育学院",4,4,6,7,21,"一区",null,7.593220338983051,8]
[110,"外国语学院",4,4,6,7,21,"一区",null,7.593220338983051,8]
[111,"旅游与会展学院",4,4,4,4,16,"一区",null,5.785310734463277,6]
[{"$nulls":10},64]
["校区","教室总数","参与分配教室总数","备注"]
["一区",68,64,"物流专业2间\n柬埔寨班2间"]
["二区",67,65,"35#401、35#406研究生处使用"]
[]
["备注：1、所有所属学生学院的公共课程（思政、数学、物理等）优先使用该学院的教室\n      2、交叉使用教室各学院自行协调"]
[]
[]
[]
["一区多媒体教室现状","阶梯教室",6,"大教室120",22,"中教室",6,"小教室",30,"柬埔寨班",2,"中德物流",2]
[]
[]
[]
[]
[null,"学院","班级数",null,"阶梯教室","实际分配教室","大教室120","实际分配教室","中教室","实际分配教室","小教室","实际分配教室"]
[null,"经济与管理学院",{"$f":"G9","v":101},null,{"$f":"6*C29/177","v":3.4237288135593222},3,{"$f":"22*C29/177","v":12.55367231638418},12,{"$f":"5*C29/177","v":2.853107344632768},2]
[null,"语言文化与传媒学院",18,null,{"$f":"6*C30/177","v":0.6101694915254238},1,{"$f":"22*C30/177","v":2.23728813559322},3,{"$f":"5*C30/177","v":0.5084745762711864},1]
[null,"教育学院",21,null,0.711864406779661,1,2.610169491525424,3,0.5932203389830508,1]
[null,"外国语学院",21,null,0.711864406779661,0,2.610169491525424,1,0.5932203389830508,1]
[null,"旅游与会展学院",16,null,0.5423728813559322,1,1.9887005649717515,3,0.4519774011299435,1]
[null,null,{"$f":"SUM(C29:C33)","v":177},null,null,{"$f":"SUM(F29:F33)","v":6},null,{"$f":"SUM(H29:H33)","v":22},null,{"$f":"SUM(J29:J33)","v":6}]
[]
[]
[null,"按班级比例更改多媒体教室分配数1"]
[null,{"$f":"B28","v":"学院"},"班级数",0,"阶梯教室","实际分配教室","大教室120","实际分配教室","中教室","实际分配教室","小教室"]
[null,{"$f":"B29","v":"经济与管理学院"},101,0,3.4237288135593222,{"$f":"F29","v":3},12.55367231638418,13,{"$f":"I29","v":2.853107344632768},3,{"$f":"K29","v":0}]
[null,{"$f":"B30","v":"语言文化与传媒学院"},18,0,0.6101694915254238,1,2.23728813559322,3,0.5084745762711864,1,0]
[null,{"$f":"B31","v":"教育学院"},21,0,0.711864406779661,1,2.610169491525424,3,0.5932203389830508,1,0]
[null,{"$f":"B32","v":"外国语学院"},21,0,0.711864406779661,0,2.610169491525424,1,0.5932203389830508,1,0]
[null,{"$f":"B33","v":"旅游与会展学院"},16,0,0.5423728813559322,1,1.9887005649717515,2,{"$f":"I33","v":0.4519774011299435},0,{"$f":"K33","v":0}]
[null,{"$f":"B34","v":0},177,0,0,6,0,22,0,6,0]
[]
[]
[]
[null,"按班级比例更改多媒体教室分配数2"]
[null,{"$f":"B38","v":"学院"},"班级数",0,"阶梯教室","实际分配教室","大教室120","实际分配教室","中教室","实际分配教室","小教室"]
[null,{"$f":"B39","v":"经济与管理学院"},101,0,3.4237288135593222,3,12.55367231638418,13,2.853107344632768,4,0]
[null,{"$f":"B40","v":"语言文化与传媒学院"},18,0,0.6101694915254238,1,2.23728813559322,3,0.5084745762711864,1,0]
[null,{"$f":"B41","v":"教育学院"},21,0,0.711864406779661,1,2.610169491525424,3,0.5932203389830508,1,0]
[null,{"$f":"B42","v":"外国语学院"},21,0,0.711864406779661,0,2.610169491525424,1,0.5932203389830508,0,0]
[null,{"$f":"B43","v":"旅游与会展学院"},16,0,0.5423728813559322,1,1.9887005649717515,2,0.4519774011299435,0,0]
[null,{"$f":"B44","v":0},177,0,0,6,0,22,0,6,0]

{"sheet":"二区教室分配方案","index":1,"n_rows":68,"n_cols":5,"rows_kept":68}
["教室编号","教室名称","座位数","教室类别","使用部门"]
["JX235206","35-206",110,"多媒体教室","城市建设与交通学院 "]
["JX235304","35-304",56,"多媒体教室","城市建设与交通学院 "]
["JX237101","37-101",111,"多媒体教室","城市建设与交通学院 "]
["JX237105","37-105",119,"多媒体教室","城市建设与交通学院 "]
["JX237203","37-203",117,"多媒体教室","城市建设与交通学院 "]
["JX237208","37-208",62,"多媒体教室","城市建设与交通学院 "]
["JX2411JT","41-3JT",182,"多媒体教室","城市建设与交通学院 "]
["JX235105","35-105",110,"多媒体教室","能源材料与化工学院"]
["JX235412","35-412",110,"多媒体教室","能源材料与化工学院"]
["JX2371JT","37-1JT",182,"多媒体教室","能源材料与化工学院"]
["JX2372JT","37-2JT",182,"多媒体教室","能源材料与化工学院"]
["JX292201","生-201",93,"多媒体教室","能源材料与化工学院"]
["JX292203","生-203",94,"多媒体教室","能源材料与化工学院"]
["JX292210","生-210",57,"多媒体教室","能源材料与化工学院"]
["JX2912JT","生化-2JT",240,"多媒体教室","能源材料与化工学院"]
["JX235409","35-409",110,"多媒体教室","人工智能与大数据学院"]
["JX2362JT","36-2JT",182,"多媒体教室","人工智能与大数据学院"]
["JX235203","35-203",110,"多媒体教室","人工智能与大数据学院 "]
["JX235204","35-204",56,"多媒体教室","人工智能与大数据学院 "]
["JX235205","35-205",110,"多媒体教室","人工智能与大数据学院 "]
["JX235212","35-212",110,"多媒体教室","人工智能与大数据学院 "]
["JX236105","36-105",111,"多媒体教室","人工智能与大数据学院 "]
["JX236201","36-201",113,"多媒体教室","人工智能与大数据学院 "]
["JX236204","36-204",62,"多媒体教室","人工智能与大数据学院 "]
["JX236210","36-210",101,"多媒体教室","人工智能与大数据学院 "]
["JX2363JT","36-3JT",182,"多媒体教室","人工智能与大数据学院 "]
["JX237201","37-201",111,"多媒体教室","人工智能与大数据学院 "]
["JX237206","37-206",101,"多媒体教室","人工智能与大数据学院 "]
["JX237212","37-212",62,"多媒体教室","人工智能与大数据学院 "]
["JX2373JT","37-3JT",182,"多媒体教室","人工智能与大数据学院 "]
["JX235306","35-306",110,"多媒体教室","设计学院"]
["JX235308","35-308",110,"多媒体教室","设计学院"]
["JX235404","35-404",56,"多媒体教室","设计学院"]
["JX235405","35-405",47,"多媒体教室","设计学院"]
["JX235410","35-410",49,"多媒体教室","设计学院"]
["JX235414","35-414",56,"多媒体教室","设计学院"]
["JX237106","37-106",107,"多媒体教室","设计学院"]
["JX2412JT","41-2JT",182,"多媒体教室","设计学院"]
["JX237103","37-103",117,"多媒体教室","设计学院 "]
["JX237108","37-108",107,"多媒体教室","设计学院 "]
["JX237205","37-205",113,"多媒体教室","设计学院 "]
["JX235403","35-403",110,"多媒体教室","生物食品与环境学院"]
["JX292207","生-207",90,"多媒体教室","生物食品与环境学院"]
["JX235107","35-107",110,"多媒体教室","生物食品与环境学院 "]
["JX235303","35-303",110,"多媒体教室","生物食品与环境学院 "]
["JX292209","生-209",103,"多媒体教室","生物食品与环境学院 "]
["JX292212","生-212",54,"多媒体教室","生物食品与环境学院 "]
["JX2911JT","生化-1JT",240,"多媒体教室","生物食品与环境学院 "]
["JX235112","35-112",110,"多媒体教室","先进制造工程学院"]
["JX235114","35-114",56,"多媒体教室","先进制造工程学院"]
["JX235201","35-201",110,"多媒体教室","先进制造工程学院"]
["JX235208","35-208",110,"多媒体教室","先进制造工程学院"]
["JX236101","36-101",119,"多媒体教室","先进制造工程学院"]
["JX236103","36-103",117,"多媒体教室","先进制造工程学院"]
["JX236104","36-104",62,"多媒体教室","先进制造工程学院"]
["JX236106","36-106",107,"多媒体教室","先进制造工程学院"]
["JX236108","36-108",107,"多媒体教室","先进制造工程学院"]
["JX2361JT","36-1JT",182,"多媒体教室","先进制造工程学院"]
["JX236205","36-205",111,"多媒体教室","先进制造工程学院"]
["JX236212","36-212",50,"多媒体教室","先进制造工程学院"]
["JX2382JT","38-2JT",182,"多媒体教室","先进制造工程学院"]
["JX235207","35-207",110,"多媒体教室","先进制造工程学院 "]
["JX235210","35-210",49,"多媒体教室","先进制造工程学院 "]
["JX236203","36-203",117,"多媒体教室","先进制造工程学院 "]
["JX2381JT","38-3JT",182,"多媒体教室","先进制造工程学院 "]
["JX235401","35-401",110,"多媒体教室","研究生处"]
["JX235406","35-406",110,"多媒体教室","研究生处"]

{"sheet":"一区教室分配方案","index":2,"n_rows":69,"n_cols":5,"rows_kept":69}
["教室编号 ","教室名称 ","座位数 ","教室类别 ","使用部门"]
["03513","8-501",40,"多媒体教室","柬埔寨班"]
["03514","8-502",40,"多媒体教室","柬埔寨班"]
[1301,"3-101",184,"多媒体教室","教育学院"]
[1308,"3-301",128,"多媒体教室","教育学院"]
[1309,"3-302",64,"多媒体教室","教育学院"]
[1310,"3-303",83,"多媒体教室","教育学院"]
[1312,"3-305",128,"多媒体教室","教育学院"]
[1314,"3-307",128,"多媒体教室","教育学院"]
["03494","8-102",40,"多媒体教室","教育学院"]
["03495","8-103",40,"多媒体教室","教育学院"]
[1101,"1-101",184,"多媒体教室","经济与管理学院"]
[1906,"11-103",120,"多媒体教室","经济与管理学院"]
[1108,"1-301",128,"多媒体教室","经济与管理学院"]
[1109,"1-302",64,"多媒体教室","经济与管理学院"]
[1110,"1-303",83,"多媒体教室","经济与管理学院"]
[1112,"1-305",128,"多媒体教室","经济与管理学院"]
[1114,"1-307",128,"多媒体教室","经济与管理学院"]
[1401,"4-101",128,"多媒体教室","经济与管理学院"]
[1407,"4-107",184,"多媒体教室","经济与管理学院"]
[1408,"4-301",128,"多媒体教室","经济与管理学院"]
[1409,"4-302",64,"多媒体教室","经济与管理学院"]
[1410,"4-303",128,"多媒体教室","经济与管理学院"]
[1412,"4-305",83,"多媒体教室","经济与管理学院"]
[1414,"4-307",121,"多媒体教室","经济与管理学院"]
[1601,"6-101",128,"多媒体教室","经济与管理学院"]
[1603,"6-103",128,"多媒体教室","经济与管理学院"]
[1607,"6-301",128,"多媒体教室","经济与管理学院"]
[1608,"6-302",60,"多媒体教室","经济与管理学院"]
[1609,"6-303",128,"多媒体教室","经济与管理学院"]
[1613,"6-307",128,"多媒体教室","经济与管理学院"]
["03496","8-104",40,"多媒体教室","经济与管理学院"]
["03497","8-105",40,"多媒体教室","经济与管理学院"]
["j03401","8-106",40,"多媒体教室","经济与管理学院"]
["03509","8-402",40,"多媒体教室","经济与管理学院"]
["03510","8-403",40,"多媒体教室","经济与管理学院"]
["j03406","8-406",40,"多媒体教室","经济与管理学院"]
["03515","8-503",40,"多媒体教室","经济与管理学院"]
["03516","8-504",40,"多媒体教室","经济与管理学院"]
["03517","8-505",40,"多媒体教室","经济与管理学院"]
["03521","8-506",40,"多媒体教室","经济与管理学院"]
[1215,"2-305",83,"多媒体教室","经济与管理学院"]
[1217,"2-307",128,"多媒体教室","经济与管理学院"]
[1103,"1-103",85,"多媒体教室","经济与管理学院"]
["03501","8-204",40,"多媒体教室","旅游与会展学院"]
["03502","8-205",40,"多媒体教室","旅游与会展学院"]
["j03402","8-206",40,"多媒体教室","旅游与会展学院"]
[1207,"2-107",184,"多媒体教室","旅游与会展学院"]
[1211,"2-301",128,"多媒体教室","旅游与会展学院"]
[1212,"2-302",64,"多媒体教室","旅游与会展学院"]
[1213,"2-303",128,"多媒体教室","旅游与会展学院"]
["03499","8-202",40,"多媒体教室","外国语学院"]
["03500","8-203",40,"多媒体教室","外国语学院"]
[1105,"1-105",129,"多媒体教室","外国语学院"]
["03498","8-201",40,"多媒体教室","外国语学院"]
["03505","8-303",40,"多媒体教室","外国语学院"]
["03506","8-304",40,"多媒体教室","外国语学院"]
["03507","8-305",40,"多媒体教室","外国语学院"]
["j03403","8-306",40,"多媒体教室","外国语学院"]
["03508","8-401",40,"多媒体教室","外国语学院"]
[1107,"1-107",129,"多媒体教室","语言文化与传媒学院"]
[1501,"5-101",248,"多媒体教室","语言文化与传媒学院"]
[1513,"5-305",83,"多媒体教室","语言文化与传媒学院"]
[1514,"5-306",64,"多媒体教室","语言文化与传媒学院"]
[1515,"5-307",128,"多媒体教室","语言文化与传媒学院"]
[1517,"5-309",128,"多媒体教室","语言文化与传媒学院"]
["03493","8-101",40,"多媒体教室","语言文化与传媒学院"]
["03511","8-404",40,"多媒体教室","中外合作物流专业"]
["03512","8-405",40,"多媒体教室","中外合作物流专业"]