{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["优秀团队名额分配表"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"优秀团队名额分配表","index":0,"n_rows":19,"n_cols":14,"rows_kept":19,"merged":[[0,0,0,3],[0,4,0,13],[1,0,2,0],[1,4,1,8],[1,10,1,11],[1,12,1,13],[17,1,17,3],[17,4,17,8],[17,9,17,13],[18,1,18,13]]}
["指标分配结果",{"$nulls":3},"指标分配计算过程"]
["挂靠单位/分配规则","校级答辩\n团队数量","二等奖团队数量\n（学院直推）","三等奖团队数量\n（学院直推）","立项与结项情况",{"$nulls":4},"重点团队情况","在指定平台宣传报道情况",null,"入选专项情况"]
[null,"①+②+③","依据北京市\n数量分配","依据结项数量和比例分配","立项数量","结项数量","北京市报备\n提交数量","结项比例","报备比例","①基础指标","有报道的团队数量","②分配指标","入选专项数量","③奖励指标"]
["地球科学学院",{"$f":"J4+N4+L4","v":2},1,{"$f":"ROUND((68*F4/547),0)","v":5},40,37,40,{"$f":"F4/E4","v":{"v":0.925,"d":"92.5%"}},{"$f":"G4/E4","v":{"v":1,"d":"100.0%"}},1,5,{"$f":"ROUND(K4/97*22,0)","v":1},4,0]
["石油工程学院",{"$f":"J5+N5+L5","v":5},1,{"$f":"ROUND((68*F5/547),0)","v":9},81,75,79,{"$f":"F5/E5","v":{"v":0.925925925925926,"d":"92.6%"}},{"$f":"G5/E5","v":{"v":0.975308641975309,"d":"97.5%"}},1,13,{"$f":"ROUND(K5/97*22,0)","v":3},17,1]
["化学工程与环境学院",2,1,{"$f":"ROUND((68*F6/547),0)","v":6},52,50,51,{"v":0.961538461538462,"d":"96.2%"},{"v":0.980769230769231,"d":"98.1%"},1,6,1,3,0]
["机械与储运工程学院",4,1,9,73,70,73,{"v":0.958904109589041,"d":"95.9%"},{"v":1,"d":"100.0%"},1,8,2,8,1]
["地球物理学院",3,1,7,65,57,63,{"v":0.876923076923077,"d":"87.7%"},{"v":0.969230769230769,"d":"96.9%"},1,8,2,5,0]
["安全与海洋工程学院",2,1,3,34,22,30,{"v":0.647058823529412,"d":"64.7%"},{"v":0.882352941176471,"d":"88.2%"},1,6,1,6,0]
["新能源与材料学院",{"$f":"J10+N10+L10+1","v":4},1,13,124,105,123,{"v":0.846774193548387,"d":"84.7%"},{"v":0.991935483870968,"d":"99.2%"},1,8,2,1,0]
["人工智能学院",3,1,4,37,35,35,{"v":0.945945945945946,"d":"94.6%"},{"v":0.945945945945946,"d":"94.6%"},1,8,2,0,0]
["理学院",2,1,3,22,22,22,{"v":1,"d":"100.0%"},{"v":1,"d":"100.0%"},1,3,1,0,0]
["经济管理学院",5,1,6,51,46,48,{"v":0.901960784313726,"d":"90.2%"},{"v":0.941176470588235,"d":"94.1%"},1,13,3,15,1]
["马克思主义学院",3,1,2,18,17,18,{"v":0.944444444444444,"d":"94.4%"},{"v":1,"d":"100.0%"},1,7,2,6,0]
["外国语学院",1,0,0,10,8,9,{"v":0.8,"d":"80.0%"},{"v":0.9,"d":"90.0%"},1,2,0,1,0]
["团委",4,1,1,11,11,11,{"v":1,"d":"100.0%"},{"v":1,"d":"100.0%"},1,10,2,13,1]
["总计",{"$f":"SUM(B4:B16)","v":40},12,68,618,555,602,"/","/",{"$f":"SUM(J4:J16)","v":13},{"$f":"SUM(K4:K16)","v":97},{"$f":"SUM(L4:L16)","v":22},{"$f":"SUM(M4:M16)","v":79},{"$f":"SUM(N4:N16)","v":4}]
["优秀团队\n指标分配说明","奖项总计120项： \n各单位推荐共计40支团队参与校级答辩，评选出16项一等奖和24项二等奖。剩余12项二等奖和68项三等奖由各学院直接推荐产生。\n一等奖16项（答辩产生）\n二等奖36项（答辩产生24项+学院直推12项）\n三等奖68项（学院直推）",null,null,"学院直接推荐的二等奖、三等奖指标分配原则：\n分别根据各单位北京市报备情况和结项比例分配。",{"$nulls":4},"各学院一等奖答辩团队数量指标分配由三部分构成：\n①基础指标：根据入选北京市重点团队数量，各单位各分配1个指标，共计13个。\n②分配指标：根据各单位在指定平台宣传的团队数量情况，按比例分配23个名额。\n③奖励指标：根据各单位入选省部级及以上专项的数量，奖励4个指标。\n"]
["社会实践奖学金\n和先进个人评定\n说明","在120个获奖团队中，每个团队可推荐1位成员参评社会实践奖学金，每人每次200元，同时授予“社会实践先进个人”荣誉称号。"]