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

{"sheet":"Sheet1","index":0,"n_rows":22,"n_cols":23,"rows_kept":22,"merged":[[0,0,1,22],[2,0,3,0],[2,1,3,1],[2,2,2,3],[2,4,2,5],[2,6,3,6],[2,7,3,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17],[2,18,3,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,22,3,22],[14,0,17,22]]}
["人文与公共管理学院2022—2023学年国家奖学金申请者测评分排名公示"]
[]
["班级","姓名","专业成绩\n班级排名",null,"专业成绩班级\n排名赋分",null,"学年专业成绩班级排名赋分总分","专业成绩测评分","德育素质测评\n奖惩分相加",null,"智育素质测评\n奖惩分相加",null,"体育素质测评\n奖惩分相加",null,"美育素质测评\n奖惩分相加",null,"劳育素质测评\n奖惩分相加",null,"课外活动奖惩分相加总分","课外活动加分测评分","总测评分","排位","备注"]
[null,null,"上学期","下学期","上学期","下学期",null,null,"上学期","下学期","上学期","下学期","上学期","下学期","上学期","下学期","上学期","下学期"]
["公管2001","刘婷",1,1,90,90,180,{"$f":"G5*0.7","v":{"v":126,"d":"126.00"}},{"$f":"8*0.2","v":{"v":1.6,"d":"1.60"}},{"$f":"4.5*0.2","v":{"v":0.9,"d":"0.90"}},{"$f":"8*0.6","v":{"v":4.8,"d":"4.80"}},{"$f":"13*0.6","v":{"v":7.8,"d":"7.80"}},{"$f":"2*8%","v":0.16},{"$f":"2*8%","v":0.16},{"$f":"60*6%","v":{"v":3.6,"d":"3.60"}},{"$f":"38*6%","v":2.28},{"$f":"4*0.06","v":0.24},{"$f":"0*0.06","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I5:R5)","v":21.54},{"$f":"S5*0.3","v":{"v":6.462,"d":"6.46"}},{"$f":"H5+T5","v":{"v":132.462,"d":"132.46"}},{"$f":"RANK(U5,$U5:$U14)","v":1},"拟推荐"]
["文学2001","查新悦",2,2,85,85,170,{"v":119,"d":"119.00"},{"$f":"14*0.2","v":{"v":2.8,"d":"2.80"}},{"$f":"10*0.2","v":{"v":2,"d":"2.00"}},{"v":0,"d":"0.00"},{"$f":"15*0.6","v":{"v":9,"d":"9.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"40*0.06","v":{"v":2.4,"d":"2.40"}},{"v":0,"d":"0.00"},{"$f":"20*0.06","v":{"v":1.2,"d":"1.20"}},{"$f":"-1*0.06","v":-0.06},{"$f":"SUM(I6:R6)","v":17.34},{"v":5.202,"d":"5.20"},{"$f":"H6+T6","v":{"v":124.202,"d":"124.20"}},8]
["文学2002","赖雯慧",3,2,80,85,165,{"v":115.5,"d":"115.50"},{"v":2.2,"d":"2.20"},{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":0.6,"d":"0.60"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},1.44,0.72,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"SUM(I7:R7)","v":6.96},{"$f":"S7*0.3","v":{"v":2.088,"d":"2.09"}},{"$f":"T7+H7","v":{"v":117.588,"d":"117.59"}},10]
["文学2102","王月燕",2,1,85,90,175,{"v":122.5,"d":"122.50"},{"$f":"11.5*0.2","v":{"v":2.3,"d":"2.30"}},{"$f":"12*0.2","v":{"v":2.4,"d":"2.40"}},{"$f":"4*0.6","v":{"v":2.4,"d":"2.40"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"43*0.06","v":2.58},{"$f":"18*0.06","v":1.08},{"$f":"13*0.06","v":0.78},{"$f":"13*0.06","v":0.78},{"$f":"SUM(I8:R8)","v":12.32},{"$f":"S8*0.3","v":{"v":3.696,"d":"3.70"}},{"$f":"H8+T8","v":{"v":126.196,"d":"126.20"}},5]
["音学2102","李良毅",2,1,85,90,175,{"v":122.5,"d":"122.50"},{"v":2.7,"d":"2.70"},{"v":2.1,"d":"2.10"},{"v":0.6,"d":"0.60"},{"v":0,"d":"0.00"},{"v":0.2,"d":"0.20"},0.48,{"v":2.592,"d":"2.59"},{"v":4.032,"d":"4.03"},0.18,{"v":0.3,"d":"0.30"},{"$f":"SUM(I9:R9)","v":{"v":13.184,"d":"13.18"}},{"$f":"S9*0.3","v":{"v":3.9552,"d":"3.96"}},{"$f":"T9+H9","v":{"v":126.4552,"d":"126.46"}},4]
["公管2201","胡洁",1,1,90,90,180,{"v":126,"d":"126.00"},{"v":0.8,"d":"0.80"},{"v":0.9,"d":"0.90"},{"v":0.6,"d":"0.60"},{"v":1.2,"d":"1.20"},0.24,0.16,0.06,0.96,{"v":0.3,"d":"0.30"},0.15,{"$f":"SUM(I10:R10)","v":5.37},{"$f":"S10*0.3","v":{"v":1.611,"d":"1.61"}},{"$f":"T10+H10","v":{"v":127.611,"d":"127.61"}},3]
["法学2202","姚晓妍",1,1,90,90,180,{"v":126,"d":"126.00"},{"v":1.4,"d":"1.40"},{"v":1.7,"d":"1.70"},{"v":0,"d":"0.00"},{"v":1.8,"d":"1.80"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},1.32,{"v":2.4,"d":"2.40"},0.18,1.02,{"$f":"SUM(I11:R11)","v":9.82},{"v":2.946,"d":"2.95"},{"$f":"T11+H11","v":{"v":128.946,"d":"128.95"}},2,"拟推荐"]
["公管2202","李凯琦",1,3,90,80,170,{"v":119,"d":"119.00"},{"v":2.4,"d":"2.40"},{"v":2.3,"d":"2.30"},{"v":0.6,"d":"0.60"},{"v":1.2,"d":"1.20"},0.16,0.24,0.84,{"v":2.5,"d":"2.50"},{"v":0.6,"d":"0.60"},0.78,{"$f":"SUM(I12:R12)","v":11.62},{"v":3.486,"d":"3.49"},{"$f":"T12+H12","v":{"v":122.486,"d":"122.49"}},9]
["音学2201","文晓",1,2,90,85,175,{"v":122.5,"d":"122.50"},{"v":2.5,"d":"2.50"},{"v":2,"d":"2.00"},{"v":0.6,"d":"0.60"},{"v":0,"d":"0.00"},0.08,{"v":0,"d":"0.00"},0.36,{"v":2.4,"d":"2.40"},{"v":0,"d":"0.00"},-1.11,6.83,{"v":2.049,"d":"2.05"},{"$f":"T13+H13","v":{"v":124.549,"d":"124.55"}},7]
["音学2202","杜行楷",1,2,90,85,175,{"v":122.5,"d":"122.50"},{"v":2.4,"d":"2.40"},{"v":2.1,"d":"2.10"},{"v":0.6,"d":"0.60"},{"v":1.2,"d":"1.20"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0.288,"d":"0.29"},{"v":2.4,"d":"2.40"},0.39,-0.33,{"v":9.048,"d":"9.05"},{"v":2.7144,"d":"2.71"},{"$f":"T14+H14","v":{"v":125.2144,"d":"125.21"}},6]
["国家奖学金评定采用“学年专业成绩班级排名分与课外活动奖励分”加权排名办法进行测评。\n申请者测评分=∑学年两次专业成绩排名加分总和×70%+课外活动加分总和×30%。"]
[]
[]
[]
[]
[{"$nulls":5},"专业成绩测评分=学年专业成绩班级排名赋分总分*0.7"]
[]
[{"$nulls":5},"课外活动加分测评分=课外活动奖惩分相加总分*0.3"]