{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["数据结果"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"数据结果","index":0,"n_rows":21,"n_cols":16,"rows_kept":21,"flags":["formulas_cached_only"]}
["序号","姓名","学号","总学积分","总学积分年级排名","总学积分专业排名","总GPA","总GPA年级排名","总GPA专业排名","素拓成绩","成果奖励加分","综合测评总分","综合测评年级排名","综合测评专业排名","反馈意见","学院反馈"]
["1","王一名","518020910013","90.666666667","9/424","3/171","3.84047619","35/424","13/171","99.5555555555556","1.5","94.8333333335667","4/424","2/171","根据终审表单，我的素拓成绩应该是100分再加上额外的1.5分奖励加分，我提交的素拓项目无非满分素拓，但是查到的是99.5分","系统问题，已按要求调整"]
["2","李卓航","520021910513","85.0546875","83/474","54/371","3.553125","84/474","56/371","95.1917816470588","0.1","88.1958157441176","33/474","21/371","表单填写无错误，终审无意见，\n但素拓成绩计算结果与如上成绩不一致。\n正确分数应为：92×3+99.7208+100+98.75+96×2+100+96=962.4708\n962.4708/10=96.24708\n以上分数分别为（001项素拓92，3学分。002项99.7208，1学分。003项100分，1学分。501项1学分96分，502项1学分100分，505项1学分98.75分，601项2学分96分。总共10学分）","系统问题，已按要求调整"]
["3","朱星月","518021910064","87.887179487","77/424","34/171","3.771794872","58/424","25/171","95.27271","0.9","91.0028386409","36/424","17/171","成果奖励加分在终审里是1.5，但实际只有0.9","B类赛事不可叠加，取最高0.9"]
["4","毛弘江","518021910805","89.101538462","41/424","17/171","3.833333333","37/424","15/171","46.47396","0","76.3132649234","162/424","79/171","一轮一个学分填写出错退回来了，结果忘记提交了现在已经改好提交，不知道能否帮忙通过一下，不好意思。","已超时不予通过"]
["5","林泽民","519021910432","89.052083333","41/430","16/160","3.840625","33/430","15/160","64.0488461538461","0","81.5511121792538","142/430","49/160","素拓分数有误  志愿者次数是两次  跟青志队反应过了 但次数未变，已经申请审核处于终审的项目未计入素拓分数","志愿者次数为相关工作人员失误，已修正。其余已核对，没有问题，不予修改"]
["6","陈永鹏","520020910079","85.508196721","73/474","4/36","3.639344262","59/474","4/36","46.52131","0","73.8121307047","250/474","22/36","素拓分应该没那么低，审核退回后我没有看到班级的信息，没有及时修改上传，还有社团的素拓因为素拓条发晚了我也没来得及上传","未及时重新提交，不予通过。素拓仅取必修分数"]
["7","岳子桐","518021910671","88.966666667","44/424","13/55","3.823333333","40/424","11/55","93.1320754716981","0.1","90.3162893084094","49/424","10/55","素拓成绩应为(92×3+100+85+90+100+100+94×2+100×0.25)/10.25=94.04","系统问题，已按要求调整"]
["8","王乾坤","518020910012","87.769230769","81/424","37/171","3.733333333","76/424","35/171","96.8970588235294","0.9","91.4075791853588","26/424","11/171","素拓成绩计算有误，在本人唯一提交的综合测评材料中，本人的素拓成绩应当为(99*3+100*1+90*1+100*2+98*1+100*1+98.75*1)/10=98.375，在上面成绩表中为96.897","系统问题，已按要求调整"]
["9","何鑫园","520021911011","79.225","281/474","207/371","3.115","282/474","207/371","94.6837181818182","0","83.8626154545454","103/474","72/371","经审核员胡宇轩确认后，发现素拓分数计算出现问题，具体如下：链接中显示素拓分数为94.68，经个人与审核员计算后，素拓分数应为94.75","系统问题，已按要求调整"]
["10","张洪祥","519021911211","79.5642","274/430","45/58","3.142","273/430","44/58","85.9269552447552","0.375","81.8480265734266","137/430","24/58","综测成绩有误。学积分有误，算上辅修。不算辅修应为80.366170213\n素拓成绩有误，算错了：详细如下：\n90.7307692307692*3+98.7542+90+100+100+96.25+94*2=945（取整）\n945/10=94.5\n还望老师明察，还一公道，桃花潭水深千尺 不及分数还我情\n鄙人才疏学浅，但定当感激不尽","系统问题，已按要求调整"]
["11","刘国兴","520021910752","83.073770492","153/474","104/371","3.380327869","163/474","114/371","78.890625","0.1","81.9188268444","129/474","93/371","素拓成绩计算有误，已满10学分，是不是哪里漏算了","系统问题，已按要求调整"]
["12","陈姜希","518431910001","86.485405405","95/430","15/58","3.6","115/430","16/58","46.04166","0","74.3522817835","208/430","34/58","本人的综合测评还在班级互审中，并未有通过就生成了素拓成绩，这个素拓成绩并非最终的？","审核员工作失误，已调整"]
["13","陈南汐","520021910653","86.696721311","56/474","39/371","3.632786885","62/474","43/371","79.149833518313","0.075","84.5076549731939","94/474","66/371","素质拓展成绩有误，我提交的表单001项 3学分*89分 ， 002项 1学分*100 ，003项1学分*95.\n                                                      501项1学分*96分，502项1学分*100，505项1学分*97.5 ，506项0.25学分*100，\n                                                      601项2学分*90分。奖励加分0.075分。\n素质拓展最终成绩为=（89*3+100*1+1*95+96*1+100*1+97.5*1+100*0.25+90*2）/10.25=93.707","系统问题，已按要求调整"]
["14","曹煜桢","518021910484","88.083333333","66/424","30/171","3.754761905","65/424","29/171","97.14208","1.6","92.4009573331","11/424","4/171","最新申请状态为终审且审核员无修改意见，7301项加分为1.8，7303项加分为0.4，与公布的综测成绩中成果奖励加分1.6不一致。","审核员审核错误，7301项只能是A类及以上赛事才能叠加，取A类二等1.2分，B类不再加分"]
["15","田博宇","519021910998","92.3","3/430","1/91","4","5/430","1/91","45.87875","0","78.373625","171/430","12/91","学业辅导员201项96分，1.5学分，未计入成绩。该项已出现在【0914】2021综合测评后台名单（公示版）中，但未计入成绩","本人未提交，不计入成绩"]
["16","张午阳","519021910129","84.334363636","163/430","27/58","3.471818182","168/430","27/58","63.22229","0","78.0007415452","175/430","31/58","我曾在9月16日在反馈渠道反馈过402项的相关事宜获得了通过，但更改之后，我的除001，002，003，402以外的其余所有的分全部没有被计入。我现在的素拓得分为上述四项的得分按照公式计算，而601，201等得分未被计入。","本人未提交，不计入成绩"]
["17","黄俊蓁","520021910657","84.968253968","87/474","58/371","3.56984127","77/474","50/371","94.6690666666667","0.05","87.9284977776","36/474","23/371","402项素拓早已经叉掉了，去掉402以后素拓成绩应该是95.60288才对。可能是系统bug仍然保留了402，之前已经跟郑嘉威老师反映过了，希望能得到解决。谢谢老师！","系统问题，已按要求调整"]
["18","邰潇逸","520020910107","92.036721311","1/474","1/67","3.986885246","1/474","1/67","81.3299","0.075","88.8996749177","25/474","8/67","素质拓展自己计算应该是97.59588，而目前给的分数为81.3299，差异极大。审核通过的素质拓展具体如下：\n001项，3学分，成绩97\n002项，1学分，成绩99.9588\n003项，1学分，成绩100（做了八次志愿者）\n101项，1学分，成绩100（青年大学习全勤）\n502项，1学分，成绩100（参加校运会且获奖）\n505项，1学分，成绩100（参加四次100分的讲座观众等活动）\n303项，1学分，成绩95（与祖国同行暑期社会实践）\n601项，1学分，成绩90（学院双创部干事）\n学分满10了，\n公式为素拓成绩＝（项目成绩X项目学分）综合/10\n应该为97.59588，目前给的分数为81.3299\n请查看更改。","系统问题，已按要求调整"]
["19","张沛涵","519021910136","81.560784314","229/430","37/58","3.262745098","239/430","39/58","46.25","0","70.9675490198","250/430","40/58","601项素拓未计入成绩","未在系统中找到你的申请表单，不予处理"]
["20","田博宇","519021910998","92.3","3/430","1/91","4","5/430","1/91","45.87875","0","78.373625","171/430","12/91","素拓401项prp成绩为1学分，90分，已审核通过，但未计入素拓分","经核实401项之前已加入素拓分数"]