{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["院系公示成绩模板"],"read":"whole","date_system":"1900"}

{"sheet":"院系公示成绩模板","index":0,"n_rows":14,"n_cols":15,"rows_kept":14}
["序号","考生编号","姓名","专业代码","专业名称","研究方向代码","研究方向名称","初试成绩a","复试笔试成绩b1","复试面试成绩b2","复试成绩b=b1+b2","初试权重成绩A=(a/5)×60%","复试权重成绩B=(b/2)×40%","考生最后成绩A+B","名次排序"]
[1,"105331512501845","杨艳",105125,"核医学","01","临床技能训练与研究",367,87,85.4,{"$f":"I2+J2","v":172.4},{"$f":"H2/5*0.6","v":44.04},{"$f":"K2/2*0.4","v":{"v":34.480000000000004,"d":"34.48"}},{"$f":"L2+M2","v":{"v":78.52000000000001,"d":"78.52"}},1]
[2,"106141105107375","唐怀佳",105125,"核医学","01","临床技能训练与研究",361,86,86.8,172.8,43.32,34.56,77.88,2]
[3,"106321105101526","党军",105125,"核医学","01","临床技能训练与研究",350,90,82.2,172.2,{"v":42,"d":"42.00"},34.44,76.44,3]
[4,"105701567891660","蔡燕玲",105125,"核医学","01","临床技能训练与研究",361,82,81,163,43.32,{"v":32.6,"d":"32.60"},75.92,4]
[5,"121211000006928","谭小飞",105125,"核医学","01","临床技能训练与研究",353,79,83.4,162.4,{"v":42.35999999999999,"d":"42.36"},{"v":32.480000000000004,"d":"32.48"},74.84,5]
[6,"106321105101610","陈雨烟",105125,"核医学","01","临床技能训练与研究",350,76,79.4,155.4,{"v":42,"d":"42.00"},{"v":31.080000000000002,"d":"31.08"},73.08,6]
[7,"106981611100916","雷丰",105125,"核医学","01","临床技能训练与研究",361,68,78.6,146.6,43.32,29.32,72.64,7]
[8,"106311000858390","李春英",105125,"核医学","01","临床技能训练与研究",352,67,83.8,150.8,42.24,{"v":30.160000000000004,"d":"30.16"},{"v":72.4,"d":"72.40"},8]
[9,"103131110303131","谢福才",105125,"核医学","01","临床技能训练与研究",350,69,82.8,151.8,{"v":42,"d":"42.00"},{"v":30.360000000000003,"d":"30.36"},72.36,9]
[10,"106321105101547","施航",105125,"核医学","01","临床技能训练与研究",361,71,74.2,145.2,43.32,29.04,72.36,10]
[11,"103441000001964","张雪娇",105125,"核医学","01","临床技能训练与研究",354,67,78,145,42.48,{"v":29,"d":"29.00"},{"v":71.47999999999999,"d":"71.48"},11]
[12,"101611220602869","黄文杰",105125,"核医学","01","临床技能训练与研究",352,65,79.4,144.4,42.24,{"v":28.880000000000003,"d":"28.88"},71.12,12]
[13,"105701567891166","宋杨柳",105125,"核医学","01","临床技能训练与研究",351,72,72.6,144.6,42.12,28.92,{"v":71.03999999999999,"d":"71.04"},13]