{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":70,"n_cols":12,"rows_kept":70,"merged":[[0,0,0,11],[69,0,69,11]]}
["2022-2023学年人文与公共管理学院国家励志奖学金评定表"]
["序号","班级","姓名","贫困等级","贫困等级赋分","贫困等级最终测评分","综测上","综测下","综测平均分","综测最终测评分","励志奖学金总测评分","备注"]
[1,"法学2001","蔡昊霖","特别困难",90,36,{"v":88.9976,"d":"88.998"},{"v":86.32,"d":"86.320"},{"$f":"AVERAGE(G3:H3)","v":{"v":87.6588,"d":"87.659"}},{"$f":"I3*0.6","v":{"v":52.59528,"d":"52.595"}},{"$f":"F3+J3","v":{"v":88.59528,"d":"88.595"}},"拟推荐"]
[2,"法学2001","葛友勤","特别困难",90,36,{"v":86.7056,"d":"86.706"},85.315,{"$f":"AVERAGE(G4:H4)","v":{"v":86.0103,"d":"86.010"}},{"$f":"I4*0.6","v":{"v":51.60618,"d":"51.606"}},{"$f":"F4+J4","v":{"v":87.60618,"d":"87.606"}},"拟推荐"]
[3,"法学2001","魏俊","特别困难",90,36,{"v":84.5168,"d":"84.517"},84.195,{"$f":"AVERAGE(G5:H5)","v":{"v":84.3559,"d":"84.356"}},{"$f":"I5*0.6","v":{"v":50.61354,"d":"50.614"}},{"$f":"F5+J5","v":{"v":86.61354,"d":"86.614"}}]
[4,"法学2002","马晴","特别困难",90,36,84.258,83.275,{"$f":"(G6+H6)/2","v":{"v":83.7665,"d":"83.767"}},{"$f":"I6*0.6","v":{"v":50.2599,"d":"50.260"}},{"$f":"F6+J6","v":{"v":86.2599,"d":"86.260"}},"拟推荐"]
[5,"法学2002","黄金铃","困难",70,28,89.792,{"v":84.83,"d":"84.830"},{"$f":"(G7+H7)/2","v":87.311},{"$f":"I7*0.6","v":{"v":52.3866,"d":"52.387"}},{"$f":"F7+J7","v":{"v":80.3866,"d":"80.387"}},"拟推荐"]
[6,"公管2001","彭海玉","特别困难",90,36,{"v":85.6610909090909,"d":"85.661"},{"v":89.66,"d":"89.660"},{"v":87.6605454545455,"d":"87.661"},52.597,88.597,"拟推荐"]
[7,"公管2001","张娟","困难",70,28,{"v":89.7018181818182,"d":"89.702"},{"v":88.3472727272727,"d":"88.347"},{"v":89.0245454545455,"d":"89.025"},53.415,81.415,"拟推荐"]
[8,"公管2001","朱佳敏","困难",70,28,{"v":85.2694545454545,"d":"85.269"},{"v":86.0290909090909,"d":"86.029"},{"v":85.6492727272727,"d":"85.649"},51.389,79.389]
[9,"公管2001","袁丽","困难",70,28,{"v":85.6232727272727,"d":"85.623"},85.306,{"v":85.4646363636363,"d":"85.465"},51.279,79.279]
[10,"公管2002","魏倩","特别困难",90,36,{"v":88.4456,"d":"88.446"},{"v":86.7272727272727,"d":"86.727"},{"v":87.5864363636364,"d":"87.586"},{"v":52.5518618181818,"d":"52.552"},{"v":88.5518618181818,"d":"88.552"},"拟推荐"]
[11,"公管2002","邱紫君","困难",70,28,86.894,90.722,88.808,{"v":53.2848,"d":"53.285"},{"v":81.2848,"d":"81.285"},"拟推荐"]
[12,"公管2002","周海龙","困难",70,28,{"v":84.3208,"d":"84.321"},{"v":83.4545454545455,"d":"83.455"},{"v":83.8876727272727,"d":"83.888"},{"v":50.3326036363636,"d":"50.333"},{"v":78.3326036363636,"d":"78.333"}]
[13,"文学2001","李文静","特别困难",90,36,{"v":88.44,"d":"88.440"},87.222,87.831,52.698,{"v":88.7,"d":"88.700"},"拟推荐"]
[14,"文学2001","徐翰林","特别困难",90,36,86.508,88.984,87.746,{"v":52.65,"d":"52.650"},{"v":88.65,"d":"88.650"},"拟推荐"]
[15,"文学2002","曹乃馨","特别困难",90,36,{"v":87.91,"d":"87.910"},{"v":83.79,"d":"83.790"},{"$f":"(G17+H17)/2","v":{"v":85.85,"d":"85.850"}},{"$f":"I17*0.6","v":{"v":51.51,"d":"51.510"}},{"$f":"F17+J17","v":{"v":87.51,"d":"87.510"}},"拟推荐"]
[16,"文学2002","陈思思","特别困难",90,36,{"v":85.35,"d":"85.350"},{"v":84.37,"d":"84.370"},{"$f":"(G18+H18)/2","v":{"v":84.86,"d":"84.860"}},{"$f":"I18*0.6","v":50.916},{"$f":"F18+J18","v":86.916},"拟推荐"]
[17,"文学2002","罗佳","特别困难",90,36,{"v":83.59,"d":"83.590"},{"v":82.62,"d":"82.620"},{"$f":"(G19+H19)/2","v":83.105},{"$f":"I19*0.6","v":49.863},{"$f":"F19+J19","v":85.863}]
[18,"文学2002","冷艺超","特别困难",90,36,{"v":82.87,"d":"82.870"},{"v":83.27,"d":"83.270"},{"$f":"(G20+H20)/2","v":{"v":83.07,"d":"83.070"}},{"$f":"I20*0.6","v":49.842},{"$f":"F20+J20","v":85.842}]
[19,"文学2002","吴驰宇","特别困难",90,36,{"v":82.65,"d":"82.650"},{"v":82.72,"d":"82.720"},{"$f":"(G21+H21)/2","v":82.685},{"$f":"I21*0.6","v":49.611},{"$f":"F21+J21","v":85.611}]
[20,"音学2001","王溪悦","困难",70,28,{"v":83.3,"d":"83.300"},83.282,{"v":83.29,"d":"83.290"},49.974,{"v":77.97,"d":"77.970"},"拟推荐"]
[21,"音学2001","张贻娟","困难",70,28,81.984,{"v":82.88,"d":"82.880"},{"$f":"(G23+H23)/2","v":82.432},{"$f":"I23*0.6","v":{"v":49.4592,"d":"49.459"}},{"$f":"F23+J23","v":{"v":77.4592,"d":"77.459"}}]
[22,"音学2002","周旭丹","困难",70,28,{"v":89.32,"d":"89.320"},{"v":91.1,"d":"91.100"},{"v":90.21,"d":"90.210"},{"v":54.13,"d":"54.130"},{"v":82.13,"d":"82.130"},"拟推荐"]
[23,"音学2002","黄敏","困难",70,28,{"v":88.72,"d":"88.720"},{"v":86.32,"d":"86.320"},{"v":87.52,"d":"87.520"},{"v":52.51,"d":"52.510"},{"v":80.51,"d":"80.510"}]
[24,"法学2101","谭敏欣","特别困难",90,36,86.466,81.771,{"$f":"AVERAGE(G26:H26)","v":{"v":84.1185,"d":"84.119"}},{"$f":"I26*0.6","v":{"v":50.4711,"d":"50.471"}},{"$f":"J26+F26","v":{"v":86.4711,"d":"86.471"}},"拟推荐"]
[25,"法学2101","程艳","困难",70,28,{"v":87.5116,"d":"87.512"},88.974,{"$f":"AVERAGE(G27:H27)","v":{"v":88.2428,"d":"88.243"}},{"$f":"I27*0.6","v":{"v":52.94568,"d":"52.946"}},{"$f":"J27+F27","v":{"v":80.94568,"d":"80.946"}},"拟推荐"]
[26,"法学2101","邹慧","困难",70,28,{"v":90.0792,"d":"90.079"},86.324,{"v":88.2016,"d":"88.202"},{"v":52.92096,"d":"52.921"},{"v":80.92096,"d":"80.921"}]
[27,"法学2101","刘思语","困难",70,28,{"v":85.1996,"d":"85.200"},83.962,{"v":84.5808,"d":"84.581"},{"v":50.74848,"d":"50.748"},{"v":78.74848,"d":"78.748"}]
[28,"法学2102","龚佳丽","特别困难",90,36,87.108,87.738,87.423,52.452,{"v":88.45,"d":"88.450"},"拟推荐"]
[29,"法学2102","刘薇","特别困难",90,36,84.358,86.072,85.215,51.132,{"v":87.13,"d":"87.130"},"拟推荐"]
[30,"法学2102","胡玉琴","困难",70,28,{"v":85.57,"d":"85.570"},87.629,{"v":86.6,"d":"86.600"},{"v":51.96,"d":"51.960"},{"v":79.96,"d":"79.960"}]
[31,"公管2101","康忠怡","特别困难",90,36,{"v":86.6552,"d":"86.655"},86.332,{"v":86.4936,"d":"86.494"},{"$f":"I33*0.6","v":{"v":51.89616,"d":"51.896"}},{"$f":"J33+F33","v":{"v":87.89616,"d":"87.896"}},"拟推荐"]
[32,"公管2101","曾姗","困难",70,28,89.666,{"v":85.9436363636364,"d":"85.944"},{"v":87.8048181818182,"d":"87.805"},{"v":52.6828909090909,"d":"52.683"},{"$f":"J34+F34","v":{"v":80.6828909090909,"d":"80.683"}}]
[33,"公管2101","杜敏","困难",70,28,{"v":88.9048,"d":"88.905"},86.272,{"v":87.5884,"d":"87.588"},{"v":52.55304,"d":"52.553"},{"$f":"J35+F35","v":{"v":80.55304,"d":"80.553"}}]
[34,"公管2102","杨燔","特别困难",90,{"$f":"E36*0.4","v":36},{"v":86.5784,"d":"86.578"},{"v":86.2654545454545,"d":"86.265"},{"v":86.4219272727273,"d":"86.422"},{"v":51.8531563636364,"d":"51.853"},{"$f":"F36+J36","v":{"v":87.8531563636364,"d":"87.853"}},"拟推荐"]
[35,"公管2102","李毅辉","困难",70,{"$f":"E37*0.4","v":28},88.072,{"v":92.0927272727273,"d":"92.093"},{"v":90.0823636363637,"d":"90.082"},{"v":54.0494181818182,"d":"54.049"},{"$f":"F37+J37","v":{"v":82.0494181818182,"d":"82.049"}},"拟推荐"]
[36,"公管2102","李若菲","困难",70,28,{"v":86.1589333333333,"d":"86.159"},{"v":87.2181818181818,"d":"87.218"},{"v":86.6885575757576,"d":"86.689"},{"v":52.0131345454546,"d":"52.013"},{"$f":"F38+J38","v":{"v":80.0131345454546,"d":"80.013"}}]
[37,"文学2101","郑梦佳","特别困难",90,36,{"v":88.6396,"d":"88.640"},{"v":84.48,"d":"84.480"},{"v":86.5598,"d":"86.560"},{"v":51.93588,"d":"51.936"},{"$f":"F39+J39","v":{"v":87.93588,"d":"87.936"}},"拟推荐"]
[38,"文学2101","刘鸾鸾","困难",70,28,84.794,87.414,86.104,{"v":51.6624,"d":"51.662"},{"$f":"F40+J40","v":{"v":79.6624,"d":"79.662"}},"拟推荐"]
[39,"文学2102","王月燕","特别困难",90,36,92.408,{"v":88.98,"d":"88.980"},90.694,{"v":54.41,"d":"54.410"},{"v":90.41,"d":"90.410"},"拟推荐"]
[40,"文学2102","邱淑慧","特别困难",90,36,{"v":91.59,"d":"91.590"},86.814,{"$f":"AVERAGE(G42:H42)","v":89.202},{"$f":"I42*0.6","v":{"v":53.5212,"d":"53.521"}},{"$f":"F42+J42","v":{"v":89.5212,"d":"89.521"}},"拟推荐"]
[41,"音学2101","黄熙","特别困难",90,36,83.866,83.286,83.576,{"v":50.1456,"d":"50.146"},{"v":86.1456,"d":"86.146"},"拟推荐"]
[42,"音学2102","何政吾","特别困难",90,36,{"v":84.5848,"d":"84.585"},{"v":85.0585714285714,"d":"85.059"},{"v":84.8216857142857,"d":"84.822"},{"$f":"I44*0.6","v":{"v":50.8930114285714,"d":"50.893"}},{"$f":"F44+J44","v":{"v":86.8930114285714,"d":"86.893"}},"拟推荐"]
[43,"音学2102","陈旭辉","困难",70,28,{"v":81.5408,"d":"81.541"},{"v":82.4714285714286,"d":"82.471"},{"v":82.0061142857143,"d":"82.006"},{"$f":"I45*0.6","v":{"v":49.2036685714286,"d":"49.204"}},{"$f":"F45+J45","v":{"v":77.2036685714286,"d":"77.204"}}]
[44,"法学2201","黄淇","特别困难",90,{"$f":"E46*0.4","v":36},{"v":82.6511384615385,"d":"82.651"},{"v":86.12,"d":"86.120"},{"v":84.39,"d":"84.390"},{"$f":"I46*0.6","v":50.634},{"$f":"F46+J46","v":86.634},"拟推荐"]
[45,"法学2201","叶佳轩","特别困难",90,36,{"v":80.8756,"d":"80.876"},{"v":84.54,"d":"84.540"},{"v":82.7058,"d":"82.706"},{"v":49.62348,"d":"49.623"},{"v":85.62348,"d":"85.623"},"拟推荐"]
[46,"法学2201","胡晨悦","特别困难",90,36,{"v":81.6736615384615,"d":"81.674"},{"v":82.47,"d":"82.470"},{"v":82.0718307692308,"d":"82.072"},{"v":49.2430984615385,"d":"49.243"},{"v":85.2430984615385,"d":"85.243"}]
[47,"法学2201","陈雨婷","困难",70,28,{"v":81.7900307692308,"d":"81.790"},{"v":85.06,"d":"85.060"},{"v":83.4270153846154,"d":"83.427"},{"v":50.0562092307692,"d":"50.056"},{"v":78.0562092307692,"d":"78.056"}]
[48,"法学2201","吴镕燕","困难",70,28,{"v":81.3478153846154,"d":"81.348"},{"v":82.57,"d":"82.570"},{"v":81.96,"d":"81.960"},49.176,77.176]
[49,"法学2201","柯妍","困难",70,28,{"v":81.0769692307692,"d":"81.077"},{"v":81.14,"d":"81.140"},{"v":81.11,"d":"81.110"},48.666,76.666]
[50,"法学2202","段雨欣","特别困难",90,36,{"v":82.83,"d":"82.830"},85.466,84.148,{"v":50.4888,"d":"50.489"},86.489,"拟推荐"]
[51,"法学2202","张俊茜","特别困难",90,36,80.484,85.884,83.184,{"v":49.9104,"d":"49.910"},{"v":85.9104,"d":"85.910"},"拟推荐"]
[52,"法学2202","严淑萍","困难",70,28,82.426,82.406,{"v":86.14,"d":"86.140"},51.684,79.684]
[53,"公管2201","周若妍","特别困难",90,36,81.978,{"v":84.76,"d":"84.760"},{"$f":"(G55+H55)/2","v":83.369},{"$f":"I55*0.6","v":{"v":50.0214,"d":"50.021"}},{"$f":"F55+J55","v":{"v":86.0214,"d":"86.021"}},"拟推荐"]
[54,"公管2201","谢嘉仪","特别困难",90,36,81.984,{"v":83.02,"d":"83.020"},{"$f":"(G56+H56)/2","v":82.502},{"v":49.5012,"d":"49.501"},{"v":85.5012,"d":"85.501"},"拟推荐"]
[55,"公管2201","杨佳瑶","困难",70,28,79.972,{"v":79.71,"d":"79.710"},{"$f":"(G57+H57)/2","v":79.841},{"v":47.9046,"d":"47.905"},{"v":75.9046,"d":"75.905"}]
[56,"公管2202","朱赛贞","困难",70,{"$f":"E58*0.4","v":28},{"v":82.88,"d":"82.880"},{"v":85.31,"d":"85.310"},{"v":84.09,"d":"84.090"},50.454,78.454,"拟推荐"]
[57,"公管2202","欧阳鑫华","困难",70,{"$f":"E59*0.4","v":28},81.894,"85.02",{"$f":"(G59+H59)/2","v":83.457},{"v":50.0742,"d":"50.074"},{"v":78.0742,"d":"78.074"},"拟推荐"]
[58,"公管2202","唐宇鸿","困难",70,{"$f":"E60*0.4","v":28},{"v":81.3028,"d":"81.303"},"83.16",{"$f":"(G60+H60)/2","v":{"v":82.2314,"d":"82.231"}},{"v":49.33884,"d":"49.339"},{"v":77.33884,"d":"77.339"}]
[59,"文学2201","陈悦","困难",70,{"$f":"E61*0.4","v":28},"81.092","86.06 ",83.576,{"v":50.1456,"d":"50.146"},{"v":78.1456,"d":"78.146"},"拟推荐"]
[60,"文学2201","周婷","困难",70,{"$f":"E62*0.4","v":28},"79.7","84.26 ",{"v":81.98,"d":"81.980"},49.188,77.188,"拟推荐"]
[61,"文学2202","王丽丽","特别困难",90,36,{"v":80.11,"d":"80.110"},{"v":84.93,"d":"84.930"},{"v":82.52,"d":"82.520"},49.512,{"v":85.51,"d":"85.510"},"拟推荐"]
[62,"文学2202","肖萍萍","特别困难",90,36,80.391,{"v":82.38,"d":"82.380"},81.356,48.816,84.816,"拟推荐"]
[63,"音学2201","涂马丽","特别困难",90,36,{"v":81.39,"d":"81.390"},{"v":81.93,"d":"81.930"},{"v":81.66,"d":"81.660"},{"$f":"I65*0.6","v":48.996},{"$f":"F65+J65","v":84.996},"拟推荐"]
[64,"音学2202","徐瑞鸿","特别困难",90,36,81.372,80.922,{"$f":"AVERAGE(G66,H66)","v":81.147},48.688,{"v":84.69,"d":"84.690"},"学习成绩未达到班级前30%，不推荐"]
[65,"音学2202","张媛媛","特别困难",90,36,79.076,82.106,80.591,48.354,{"v":84.35,"d":"84.350"},"综合素质测评未达到班级前30%，不推荐"]
[66,"音学2202","杜行楷","困难",70,28,{"v":84.99,"d":"84.990"},83.154,84.072,50.443,{"v":78.44,"d":"78.440"},"拟推荐"]
[67,"音学2202","肖嘉祺","困难",70,28,84.056,82.452,83.254,49.952,{"v":77.95,"d":"77.950"}]
["备注：1.测评分计算公式为：国家励志奖学金测评分=∑学年两次综合测评平均分×60%+困难等级分×40%；2.申请者困难等级分由各班根据本学期困难生认定数据，按特别困难、贫困两个等级分别赋值90分、70分；3.存在两个以上相同分，则按照综测成绩排名优先原则。"]