{"text_format":"3","workbook":"xls","n_sheets":9,"sheets":["会计学","企管","技术经济","产业经济学","金融学","管理科学与工程","会计专硕","博15","博16"],"not_rendered":{"external_links":1,"defined_names":2,"comments":7},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"会计学","index":0,"n_rows":12,"n_cols":16,"rows_kept":12,"merged":[[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,1,5],[1,6,1,9],[1,10,1,13],[1,14,2,14],[1,15,2,15]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）工商管理学院会计学专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":3},"智育成绩",{"$nulls":3},"文体成绩",{"$nulls":3},"总分","排名"]
[null,null,"基础分","奖励分","惩罚分","总 分","学习成绩分","奖励分","惩罚分","总 分","基本分","奖励分","惩罚分","总 分"]
[2016217033,"丁丹",{"v":98.82399999999998,"d":"98.82"},{"v":13,"d":"13.00"},{"v":0,"d":"0.00"},{"v":99.46630612680566,"d":"99.47"},{"v":88.01086956521738,"d":"88.01"},{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":97.6923076923077,"d":"97.69"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":93.34803381109886,"d":"93.35"},{"v":99.22806460647101,"d":"99.23"},1]
[2016217031,"耿明伟",{"v":97.22399999999999,"d":"97.22"},{"v":15.2,"d":"15.20"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":81.2663043478261,"d":"81.27"},9.33,{"v":0,"d":"0.00"},{"v":96.36790380390798,"d":"96.37"},{"v":97.46153846153847,"d":"97.46"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":93.12752664461595,"d":"93.13"},{"v":96.77028532719717,"d":"96.77"},2]
[2016217027,"连贯华",{"v":97.85999999999999,"d":"97.86"},{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":89.71394008396783,"d":"89.71"},{"v":86.81666666666666,"d":"86.82"},{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":96.60230469803832,"d":"96.60"},{"v":97.38461538461539,"d":"97.38"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":93.05402425578832,"d":"93.05"},{"v":94.86980373099922,"d":"94.87"},3]
[2016217028,"彭媛",{"v":98.068,"d":"98.07"},{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":90.78844374866577,"d":"90.79"},{"v":86.56521739130434,"d":"86.57"},{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":94.2074228234478,"d":"94.21"},{"v":97.34615384615384,"d":"97.35"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":93.01727306137448,"d":"93.02"},{"v":93.40461203228406,"d":"93.40"},4]
[2016217029,"刘成志",97.44,{"v":7,"d":"7.00"},{"v":0,"d":"0.00"},{"v":92.89831352736071,"d":"92.90"},{"v":82.37391304347827,"d":"82.37"},{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":89.74910394265235,"d":"89.75"},{"v":97.65384615384616,"d":"97.65"},{"v":7,"d":"7.00"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":91.40403546532879,"d":"91.40"},5]
[2016217032,"杨丹",{"v":98.432,"d":"98.43"},{"v":10,"d":"10.00"},{"v":0,"d":"0.00"},{"v":96.44915676368036,"d":"96.45"},{"v":83.67608695652173,"d":"83.68"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":89.00682159787259,"d":"89.01"},{"v":97.11538461538461,"d":"97.12"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":92.79676589489158,"d":"92.80"},{"v":90.87428306073603,"d":"90.87"},6]
[2016217035,"付静",{"v":96.876,"d":"96.88"},{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},{"v":91.50715149790082,"d":"91.51"},{"v":83.56521739130434,"d":"83.57"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":88.8888888888889,"d":"88.89"},{"v":97.15384615384616,"d":"97.15"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":92.8335170893054,"d":"92.83"},{"v":89.80700423073293,"d":"89.81"},7]
[2016217030,"储祥路",{"v":97.79599999999999,"d":"97.80"},{"v":8,"d":"8.00"},{"v":0,"d":"0.00"},{"v":94.1044616807799,"d":"94.10"},{"v":80.36195652173913,"d":"80.36"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":85.48155856168344,"d":"85.48"},{"v":97.38461538461539,"d":"97.38"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":93.05402425578832,"d":"93.05"},{"v":87.96338575491322,"d":"87.96"},8]
[2016217034,"郭坤",98.32,{"v":5.6,"d":"5.60"},{"v":0,"d":"0.00"},{"v":92.43577883725894,"d":"92.44"},{"v":80.72826086956522,"d":"80.73"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":85.87119898254136,"d":"85.87"},{"v":97.38461538461539,"d":"97.38"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":93.05402425578832,"d":"93.05"},{"v":87.90239748080957,"d":"87.90"},9]

{"sheet":"企管","index":1,"n_rows":12,"n_cols":16,"rows_kept":12,"merged":[[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,1,5],[1,6,1,9],[1,10,1,13],[1,14,2,14],[1,15,2,15]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）工商管理学院企业管理专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":3},"智育成绩",{"$nulls":3},"文体成绩",{"$nulls":3},"总分","排名"]
[null,null,"基础分","奖励分","惩罚分","总 分","学习成绩分","奖励分","惩罚分","总 分","基本分","奖励分","惩罚分","总 分"]
[2016217036,"宁莉雯",{"v":94.95599999999999,"d":"94.96"},{"v":11,"d":"11.00"},{"v":0,"d":"0.00"},{"v":94.13290689410093,"d":"94.13"},{"v":88.94736842105263,"d":"88.95"},{"v":6.2,"d":"6.20"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":96.73076923076923,"d":"96.73"},{"v":8,"d":"8.00"},{"v":0,"d":"0.00"},{"v":82.21618357487922,"d":"82.22"},{"v":97.0481997363081,"d":"97.05"},1]
[2016217044,"郭田园",{"v":97.396,"d":"97.40"},{"v":7.8,"d":"7.80"},{"v":0,"d":"0.00"},{"v":93.45771144278608,"d":"93.46"},{"v":87.2421052631579,"d":"87.24"},4.67,{"v":0,"d":"0.00"},{"v":96.59973448390309,"d":"96.60"},{"v":96.07692307692308,"d":"96.08"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":75.42270531400966,"d":"75.42"},{"v":93.85362695869034,"d":"93.85"},2]
[2016217043,"弋菲",{"v":97.77600000000001,"d":"97.78"},{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},{"v":92.19616204690834,"d":"92.20"},84.35,{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},{"v":94.95795995132205,"d":"94.96"},{"v":97.11538461538461,"d":"97.12"},{"v":5,"d":"5.00"},{"v":0,"d":"0.00"},{"v":80.16304347826086,"d":"80.16"},{"v":92.92610872313318,"d":"92.93"},3]
[2016217042,"谢文卓",{"v":97.46799999999999,"d":"97.47"},{"v":7.6,"d":"7.60"},{"v":0,"d":"0.00"},{"v":93.34399431414356,"d":"93.34"},{"v":82.00263157894736,"d":"82.00"},{"v":5,"d":"5.00"},{"v":0,"d":"0.00"},{"v":91.43987166721982,"d":"91.44"},{"v":97.3076923076923,"d":"97.31"},{"v":12,"d":"12.00"},{"v":0,"d":"0.00"},{"v":85.80917874396134,"d":"85.81"},{"v":91.25762690427871,"d":"91.26"},4]
[2016217041,"董翠影",{"v":97.636,"d":"97.64"},{"v":9.2,"d":"9.20"},{"v":0,"d":"0.00"},{"v":94.91471215351814,"d":"94.91"},{"v":85.98421052631578,"d":"85.98"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":90.36950990153777,"d":"90.37"},{"v":96.96153846153847,"d":"96.96"},{"v":8,"d":"8.00"},{"v":0,"d":"0.00"},{"v":82.39734299516908,"d":"82.40"},{"v":90.48133366129697,"d":"90.48"},5]
[2016217038,"乔丽娟",{"v":97.75999999999999,"d":"97.76"},{"v":14.8,"d":"14.80"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":84.3578947368421,"d":"84.36"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":88.66025002765792,"d":"88.66"},{"v":97.34615384615384,"d":"97.35"},{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":78.77415458937197,"d":"78.77"},{"v":89.93959047829775,"d":"89.94"},6]
[2016217037,"顾祖豪",{"v":97.368,"d":"97.37"},{"v":8,"d":"8.00"},{"v":0,"d":"0.00"},{"v":93.61051883439944,"d":"93.61"},{"v":79.02105263157894,"d":"79.02"},{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":85.15322491426042,"d":"85.15"},{"v":97.38461538461539,"d":"97.38"},{"v":30,"d":"30.00"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":88.32936120686219,"d":"88.33"},7]
[2016217040,"宋佳",{"v":96.75599999999999,"d":"96.76"},{"v":7.6,"d":"7.60"},{"v":0,"d":"0.00"},{"v":92.71144278606964,"d":"92.71"},{"v":81.48210526315789,"d":"81.48"},{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":87.7397942250249,"d":"87.74"},{"v":96.6923076923077,"d":"96.69"},{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":78.26086956521739,"d":"78.26"},{"v":87.78623147125309,"d":"87.79"},8]
[2016217039,"秦德政",{"v":94.564,"d":"94.56"},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":84.90049751243781,"d":"84.90"},{"v":79.87105263157895,"d":"79.87"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":83.94457351476933,"d":"83.94"},{"v":97.1923076923077,"d":"97.19"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":76.29830917874396,"d":"76.30"},{"v":83.37113188070049,"d":"83.37"},9]

{"sheet":"技术经济","index":2,"n_rows":11,"n_cols":16,"rows_kept":11,"merged":[[0,0,0,15]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）工商管理学院技术经济与管理专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":3},"智育成绩",{"$nulls":3},"文体成绩",{"$nulls":3},"总分","排名"]
[null,null,"基础分","奖励分","惩罚分","总 分","学习成绩分","奖励分","惩罚分","总 分","基本分","奖励分","惩罚分","总 分"]
[2016217052,"邹良萍",{"v":98.17999999999999,"d":"98.18"},{"v":14.2,"d":"14.20"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},91.66,5.25,{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":97.23076923076923,"d":"97.23"},{"v":17,"d":"17.00"},{"v":0,"d":"0.00"},{"v":99.69788519637461,"d":"99.70"},{"v":99.96978851963746,"d":"99.970"},1]
[2016217046,"尹伊",{"v":98.244,"d":"98.24"},{"v":5.4,"d":"5.40"},{"v":0,"d":"0.00"},{"v":92.22637479978644,"d":"92.23"},{"v":83.37333333333332,"d":"83.37"},{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},{"v":92.22302479964227,"d":"92.22"},{"v":97.57692307692308,"d":"97.58"},{"v":17,"d":"17.00"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":93.00139231970688,"d":"93.001"},2]
[2016217050,"殷玉洁",{"v":97.064,"d":"97.06"},{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":89.93059263214094,"d":"89.93"},{"v":90.1,"d":"90.10"},{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":95.03663192652976,"d":"95.04"},{"v":97.23076923076923,"d":"97.23"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":84.86069150721718,"d":"84.86"},{"v":92.99783002572073,"d":"92.998"},3]
[2016217048,"郭肖月",{"v":97.936,"d":"97.94"},{"v":9.4,"d":"9.40"},{"v":0,"d":"0.00"},{"v":95.51165687844814,"d":"95.51"},86.66,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":90.45506139717263,"d":"90.46"},{"v":97.73076923076923,"d":"97.73"},{"v":7,"d":"7.00"},{"v":0,"d":"0.00"},{"v":91.40651225243369,"d":"91.41"},{"v":91.56152557895383,"d":"91.562"},4]
[2016217051,"王睿智",{"v":98.17999999999999,"d":"98.18"},{"v":7.6,"d":"7.60"},{"v":0,"d":"0.00"},{"v":94.12706887346502,"d":"94.13"},{"v":84,"d":"84.00"},3.25,{"v":0,"d":"0.00"},{"v":90.03198844288517,"d":"90.03"},{"v":97.03846153846153,"d":"97.04"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":84.69284994964752,"d":"84.69"},{"v":90.31709067967738,"d":"90.317"},5]
[2016217053,"李世齐",{"v":98.124,"d":"98.12"},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":88.20430681615946,"d":"88.20"},{"v":85.37333333333333,"d":"85.37"},{"v":1.6,"d":"1.60"},{"v":0,"d":"0.00"},{"v":89.74650018917896,"d":"89.75"},{"v":97.26923076923077,"d":"97.27"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":84.89425981873111,"d":"84.89"},{"v":88.95283747753028,"d":"88.953"},6]
[2016217045,"艾旭",97.46,{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":89.39313045025806,"d":"89.39"},84.06,3.25,{"v":0,"d":"0.00"},{"v":88.8040449901971,"d":"88.80"},{"v":97,"d":"97.00"},{"v":5,"d":"5.00"},{"v":0,"d":"0.00"},{"v":89.02316213494461,"d":"89.02"},{"v":88.94377379668404,"d":"88.944"},7]
[2016217049,"刘建英",98.16,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":88.23634098594056,"d":"88.24"},{"v":85.845,"d":"85.85"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":88.58218966050975,"d":"88.58"},{"v":97.8076923076923,"d":"97.81"},{"v":5,"d":"5.00"},{"v":0,"d":"0.00"},{"v":89.72809667673715,"d":"89.73"},{"v":88.62761062721864,"d":"88.628"},8]

{"sheet":"产业经济学","index":3,"n_rows":14,"n_cols":16,"rows_kept":14,"merged":[[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,1,5],[1,6,1,9],[1,10,1,13],[1,14,2,14],[1,15,2,15]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）工商管理学院产业经济学专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":3},"智育成绩",{"$nulls":3},"文体成绩",{"$nulls":3},"综合得分","名次"]
[null,null,"基础分","奖励分","惩罚分","总 分","学习成绩分","奖励分","惩罚分","总 分","基本分","奖励分","惩罚分","总 分"]
[2016217010,"刘瑞雪",{"v":99.00833333333333,"d":"99.01"},{"v":9.4,"d":"9.40"},{"v":0,"d":"0.00"},{"v":95.54902680866692,"d":"95.55"},{"v":92.16272727272727,"d":"92.16"},{"v":9,"d":"9.00"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":98.33333333333333,"d":"98.33"},{"v":10,"d":"10.00"},{"v":0,"d":"0.00"},{"v":98.1132075471698,"d":"98.11"},{"v":98.92112611645035,"d":"98.92"},1]
[2016217014,"马健",{"v":98.5625,"d":"98.56"},{"v":14.8,"d":"14.80"},{"v":0,"d":"0.00"},{"v":99.91553433712816,"d":"99.92"},{"v":89.2469696969697,"d":"89.25"},7.75,{"v":0,"d":"0.00"},{"v":95.88212211348653,"d":"95.88"},{"v":98.375,"d":"98.38"},{"v":9,"d":"9.00"},{"v":0,"d":"0.00"},{"v":97.24528301886792,"d":"97.25"},{"v":96.825120648753,"d":"96.83"},2]
[2016217006,"张培元",{"v":98.65833333333333,"d":"98.66"},{"v":14.8,"d":"14.80"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":88.95434782608694,"d":"88.95"},4.25,{"v":0,"d":"0.00"},{"v":92.13309124695193,"d":"92.13"},97.75,{"v":12,"d":"12.00"},{"v":0,"d":"0.00"},{"v":99.39622641509433,"d":"99.40"},{"v":94.43278651437578,"d":"94.43"},3]
[2016217009,"亢雪晨",{"v":98.77499999999999,"d":"98.78"},{"v":8.6,"d":"8.60"},{"v":0,"d":"0.00"},{"v":94.63826661770105,"d":"94.64"},{"v":91.43454545454544,"d":"91.43"},{"v":3.333,"d":"3.33"},{"v":0,"d":"0.00"},{"v":93.67832205537431,"d":"93.68"},98.25,{"v":8,"d":"8.00"},{"v":0,"d":"0.00"},{"v":96.22641509433961,"d":"96.23"},{"v":94.1251202717362,"d":"94.13"},4]
[2016217012,"黄晨",{"v":98.41666666666667,"d":"98.42"},{"v":12.2,"d":"12.20"},{"v":0,"d":"0.00"},{"v":97.49540947484394,"d":"97.50"},{"v":89.12083333333332,"d":"89.12"},{"v":4.5,"d":"4.50"},{"v":0,"d":"0.00"},{"v":92.54478982257808,"d":"92.54"},{"v":98.08333333333333,"d":"98.08"},{"v":8,"d":"8.00"},{"v":0,"d":"0.00"},{"v":96.07547169811319,"d":"96.08"},{"v":93.88798194058475,"d":"93.89"},5]
[2016217016,"叶晓妹",{"v":98.70833333333333,"d":"98.71"},{"v":8,"d":"8.00"},{"v":0,"d":"0.00"},{"v":94.05067939772309,"d":"94.05"},{"v":86.925,"d":"86.93"},{"v":8.667,"d":"8.67"},{"v":0,"d":"0.00"},{"v":94.49330062275902,"d":"94.49"},{"v":98.5,"d":"98.50"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":89.20754716981132,"d":"89.21"},{"v":93.87620103245706,"d":"93.88"},6]
[2016217011,"杨少华",{"v":98.74583333333332,"d":"98.75"},{"v":14.6,"d":"14.60"},{"v":0,"d":"0.00"},{"v":99.9008446566287,"d":"99.90"},{"v":86.30636363636363,"d":"86.31"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":85.3143899567753,"d":"85.31"},{"v":98.41666666666667,"d":"98.42"},{"v":12,"d":"12.00"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":89.70024190106845,"d":"89.70"},7]
[2016217007,"赵玉婷",{"v":98.8625,"d":"98.86"},{"v":5,"d":"5.00"},{"v":0,"d":"0.00"},{"v":91.54241645244217,"d":"91.54"},{"v":84.88461538461539,"d":"84.88"},{"v":3.2,"d":"3.20"},{"v":0,"d":"0.00"},{"v":87.07220313183704,"d":"87.07"},{"v":98.58333333333333,"d":"98.58"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":89.28301886792451,"d":"89.28"},{"v":88.18732736956682,"d":"88.19"},8]
[2016217015,"孙楚钰",{"v":98.59166666666667,"d":"98.59"},{"v":7,"d":"7.00"},{"v":0,"d":"0.00"},{"v":93.06647080426,"d":"93.07"},{"v":85.19615384615383,"d":"85.20"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":84.21694051058081,"d":"84.22"},{"v":98.45833333333333,"d":"98.46"},{"v":5,"d":"5.00"},{"v":0,"d":"0.00"},{"v":93.69811320754715,"d":"93.70"},{"v":86.93496383901329,"d":"86.93"},9]
[2016217013,"郜东慧",{"v":98.5625,"d":"98.56"},{"v":7,"d":"7.00"},{"v":0,"d":"0.00"},{"v":93.04076386338598,"d":"93.04"},{"v":82.23636363636362,"d":"82.24"},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":82.27967541045479,"d":"82.28"},{"v":98.41666666666667,"d":"98.42"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":89.13207547169812,"d":"89.13"},{"v":85.11713310716536,"d":"85.12"},10]
[2016217008,"胡斯琪",{"v":98.11666666666667,"d":"98.12"},{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},{"v":91.76643408005877,"d":"91.77"},{"v":79.27083333333331,"d":"79.27"},{"v":4.2,"d":"4.20"},{"v":0,"d":"0.00"},{"v":82.51145019874969,"d":"82.51"},{"v":98.16666666666667,"d":"98.17"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":88.9056603773585,"d":"88.91"},{"v":85.00186799287238,"d":"85.00"},11]

{"sheet":"金融学","index":4,"n_rows":8,"n_cols":16,"rows_kept":8,"merged":[[0,0,0,15],[1,2,1,5],[1,6,1,9],[1,10,1,13],[1,14,2,14],[1,15,2,15]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）工商管理学院金融学专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":3},"智育成绩",{"$nulls":3},"文体成绩",{"$nulls":3},"综合得分","名次"]
[null,null,"基础分","奖励分","惩罚分","总 分","学习成绩分","奖励分","惩罚分","总 分","基本分","奖励分","惩罚分","总 分"]
[2016217005,"周玲芝",{"v":98.825,"d":"98.83"},{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},{"v":92.41789728895746,"d":"92.42"},{"v":85.26227272727272,"d":"85.26"},{"v":8,"d":"8.00"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":98.58333333333333,"d":"98.58"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":91.38663576670528,"d":"91.39"},{"v":97.62224303446202,"d":"97.62"},1]
[2016217003,"胡紫阳",{"v":98.825,"d":"98.83"},{"v":14.6,"d":"14.60"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":85.09545454545454,"d":"85.10"},{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":95.53215028974984,"d":"95.53"},{"v":98.45833333333333,"d":"98.46"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":91.27076091154885,"d":"91.27"},{"v":95.99958129397977,"d":"96.00"},2]
[2016217004,"杨豪",{"v":98.76666666666667,"d":"98.77"},{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":89.72154874733671,"d":"89.72"},{"v":86.51090909090908,"d":"86.51"},{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":97.04986426353831,"d":"97.05"},{"v":97.875,"d":"97.88"},{"v":10,"d":"10.00"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":95.87921473394417,"d":"95.88"},3]
[2016217001,"东庆敏",{"v":98.89166666666667,"d":"98.89"},{"v":8,"d":"8.00"},{"v":0,"d":"0.00"},{"v":94.23995297920798,"d":"94.24"},{"v":89.43333333333334,"d":"89.43"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":95.89443911029666,"d":"95.89"},{"v":98.375,"d":"98.38"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":91.19351100811124,"d":"91.19"},{"v":95.09344907386038,"d":"95.09"},4]
[2016217002,"武腾花",{"v":98.26249999999999,"d":"98.26"},{"v":4,"d":"4.00"},{"v":0,"d":"0.00"},{"v":90.15869517302181,"d":"90.16"},{"v":88.125,"d":"88.13"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":94.4915853141434,"d":"94.49"},{"v":98.54166666666667,"d":"98.54"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":91.3480108149865,"d":"91.35"},{"v":93.3106498360034,"d":"93.31"},5]

{"sheet":"管理科学与工程","index":5,"n_rows":11,"n_cols":16,"rows_kept":11,"merged":[[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,1,5],[1,6,1,9],[1,10,1,12],[1,14,2,14],[1,15,2,15]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）工商管理学院管理科学与工程专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":3},"智育成绩",{"$nulls":3},"文体成绩",{"$nulls":3},"综合得分","名次"]
[null,null,"基础分","奖励分","惩罚分","总 分","学习成绩分","奖励分","惩罚分","总 分","基本分","奖励分","惩罚分","总 分"]
[2016217022,"卢韵",{"v":98.64999999999999,"d":"98.65"},{"v":5.4,"d":"5.40"},{"v":0,"d":"0.00"},{"v":95.09520182787509,"d":"95.10"},{"v":89.88499999999999,"d":"89.89"},{"v":4.417,"d":"4.42"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":98.5,"d":"98.50"},{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},{"v":84.8730964467005,"d":"84.87"},{"v":97.50635001024507,"d":"97.51"},1]
[2016217023,"任凯鹏",{"v":98.41666666666667,"d":"98.42"},{"v":11,"d":"11.00"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":83.73777777777777,"d":"83.74"},{"v":5.333,"d":"5.33"},{"v":0,"d":"0.00"},{"v":94.45269217808506,"d":"94.45"},{"v":98.29166666666667,"d":"98.29"},{"v":8,"d":"8.00"},{"v":0,"d":"0.00"},{"v":86.32825719120136,"d":"86.33"},{"v":94.74971024377967,"d":"94.75"},2]
[2016217020,"臧雪珺",{"v":97.21666666666667,"d":"97.22"},{"v":8.8,"d":"8.80"},{"v":0,"d":"0.00"},{"v":96.89261233815688,"d":"96.89"},{"v":84.94555555555556,"d":"84.95"},{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":92.19905787316873,"d":"92.20"},{"v":98.125,"d":"98.13"},{"v":25,"d":"25.00"},{"v":0,"d":"0.00"},{"v":100,"d":"100.00"},{"v":93.91786297884948,"d":"93.92"},3]
[2016217018,"刘贝",{"v":98.57083333333333,"d":"98.57"},{"v":6,"d":"6.00"},{"v":0,"d":"0.00"},{"v":95.57121096725055,"d":"95.57"},{"v":86.31806722689076,"d":"86.32"},{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":93.65450067537355,"d":"93.65"},{"v":98.125,"d":"98.13"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":79.69543147208122,"d":"79.70"},{"v":92.64193581341972,"d":"92.64"},4]
[2016217017,"段克然",{"v":98.46666666666667,"d":"98.47"},{"v":9.6,"d":"9.60"},{"v":0,"d":"0.00"},{"v":98.76618431073875,"d":"98.77"},84.83,{"v":2.5,"d":"2.50"},{"v":0,"d":"0.00"},{"v":92.60673156454794,"d":"92.61"},{"v":98.66666666666667,"d":"98.67"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":80.13536379018613,"d":"80.14"},{"v":92.59148533634992,"d":"92.59"},5]
[2016217021,"刘可",{"v":97.97083333333333,"d":"97.97"},{"v":2,"d":"2.00"},{"v":0,"d":"0.00"},{"v":91.36709824828637,"d":"91.37"},{"v":86.68970588235294,"d":"86.69"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":91.92774902160393,"d":"91.93"},{"v":98.20833333333333,"d":"98.21"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":79.76311336717427,"d":"79.76"},{"v":90.59915530149745,"d":"90.60"},6]
[2016217019,"陆秀芝",{"v":98.83333333333333,"d":"98.83"},{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":91.24143183549123,"d":"91.24"},{"v":85.61258659469186,"d":"85.61"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":90.78554706654351,"d":"90.79"},{"v":98.20833333333333,"d":"98.21"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":79.76311336717427,"d":"79.76"},{"v":89.77448065039613,"d":"89.77"},7]
[2016217026,"张琪",{"v":97.24583333333332,"d":"97.25"},{"v":3,"d":"3.00"},{"v":0,"d":"0.00"},{"v":91.61843107387661,"d":"91.62"},{"v":84.80999999999999,"d":"84.81"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":89.93446586498695,"d":"89.93"},{"v":98.125,"d":"98.13"},{"v":5,"d":"5.00"},{"v":0,"d":"0.00"},{"v":83.75634517766497,"d":"83.76"},{"v":89.65344683803268,"d":"89.65"},8]

{"sheet":"会计专硕","index":6,"n_rows":43,"n_cols":16,"rows_kept":43,"merged":[[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,1,5],[1,6,1,9],[1,10,1,13],[1,14,2,14],[1,15,2,15]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）工商管理学院MPAcc专业研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":3},"智育成绩",{"$nulls":3},"文体成绩",{"$nulls":3},"总分","排名"]
[null,null,"基础分","奖励分","惩罚分","总 分","学习成绩分","奖励分","惩罚分","总 分","基本分","奖励分","惩罚分","总 分"]
[2016217627,"马树敏",{"v":98,"d":"98.00"},{"v":15,"d":"15.00"},null,{"v":99.20983318700615,"d":"99.21"},{"v":86.98714285714286,"d":"86.99"},{"v":32,"d":"32.00"},null,{"v":100,"d":"100.00"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":98.51453300908264,"d":"98.51"},1]
[2016217623,"庞元君",{"v":98.3,"d":"98.30"},{"v":13,"d":"13.00"},null,{"v":97.71729587357332,"d":"97.72"},{"v":86.80571428571427,"d":"86.81"},29.15,null,{"v":97.45230577133181,"d":"97.45"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":96.43263958632835,"d":"96.43"},2]
[2016217631,"覃丹",{"v":98.3,"d":"98.30"},{"v":9,"d":"9.00"},null,{"v":94.20544337137841,"d":"94.21"},{"v":88.25642857142856,"d":"88.26"},16.67,null,{"v":88.18299696245691,"d":"88.18"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":89.24175291967693,"d":"89.24"},3]
[2016217633,"王彤彤",{"v":97.055,"d":"97.06"},{"v":12,"d":"12.00"},null,{"v":95.74626865671642,"d":"95.75"},{"v":90.10214285714285,"d":"90.10"},{"v":14,"d":"14.00"},null,{"v":87.49024504448259,"d":"87.49"},96.47,{"v":0,"d":"0.00"},null,{"v":85.3716814159292,"d":"85.37"},{"v":88.92959340407401,"d":"88.93"},4]
[2016217630,"张赢赢",{"v":98.3,"d":"98.30"},9.93,null,{"v":95.0219490781387,"d":"95.02"},{"v":90.70285714285713,"d":"90.70"},{"v":10,"d":"10.00"},null,{"v":84.6333937640321,"d":"84.63"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":86.92033182213163,"d":"86.92"},5]
[2016217610,"刘素晓",{"v":98.69999999999999,"d":"98.70"},{"v":15.2,"d":"15.20"},null,{"v":100.00000000000001,"d":"100.00"},{"v":90.67999999999999,"d":"90.68"},{"v":6,"d":"6.00"},null,{"v":81.25247625793904,"d":"81.25"},{"v":99,"d":"99.00"},{"v":0,"d":"0.00"},null,{"v":87.61061946902655,"d":"87.61"},{"v":85.63779532745998,"d":"85.64"},6]
[2016217628,"史戈",{"v":98.3,"d":"98.30"},{"v":8.6,"d":"8.60"},null,{"v":93.85425812115892,"d":"93.85"},{"v":90.42214285714286,"d":"90.42"},5.33,null,{"v":80.47268012150172,"d":"80.47"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":83.7742940809644,"d":"83.77"},7]
[2016217618,"王印倩",{"v":98,"d":"98.00"},{"v":2,"d":"2.00"},null,{"v":87.7963125548727,"d":"87.80"},{"v":87.71928571428572,"d":"87.72"},{"v":9,"d":"9.00"},null,{"v":81.28549303045948,"d":"81.29"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":83.13167400397758,"d":"83.13"},8]
[2016217611,"孙钰聪",{"v":98,"d":"98.00"},{"v":5,"d":"5.00"},null,{"v":90.43020193151888,"d":"90.43"},{"v":86.82071428571427,"d":"86.82"},{"v":9,"d":"9.00"},null,{"v":80.53030939717375,"d":"80.53"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":83.12982333600681,"d":"83.13"},9]
[2016217625,"段晓雯",{"v":99,"d":"99.00"},{"v":9.2,"d":"9.20"},null,{"v":94.99561018437227,"d":"95.00"},{"v":86.83857142857143,"d":"86.84"},{"v":7,"d":"7.00"},null,{"v":78.86446314727883,"d":"78.86"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":82.87681261165103,"d":"82.88"},10]
[2016217617,"单怡宁",{"v":98.3,"d":"98.30"},14.67,null,{"v":99.18349429323969,"d":"99.18"},{"v":89.55499999999999,"d":"89.56"},{"v":2,"d":"2.00"},null,{"v":76.94528820640886,"d":"76.95"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":82.37096697481554,"d":"82.37"},11]
[2016217649,"刘娜",{"v":97.77647058823528,"d":"97.78"},{"v":9.2,"d":"9.20"},null,{"v":93.92139647781852,"d":"93.92"},{"v":87.36571428571429,"d":"87.37"},{"v":5.333333333333333,"d":"5.33"},null,{"v":77.90677664253441,"d":"77.91"},{"v":97.1176470588235,"d":"97.12"},{"v":5,"d":"5.00"},null,{"v":90.36959916710043,"d":"90.37"},{"v":82.35598286204784,"d":"82.36"},12]
[2016217615,"魏文丹",{"v":98.3,"d":"98.30"},{"v":10.6,"d":"10.60"},null,{"v":95.61018437225637,"d":"95.61"},{"v":87.43785714285713,"d":"87.44"},{"v":4,"d":"4.00"},null,{"v":76.84683819380243,"d":"76.85"},{"v":98,"d":"98.00"},{"v":8,"d":"8.00"},null,{"v":93.80530973451327,"d":"93.81"},{"v":82.29535458356429,"d":"82.30"},13]
[2016217612,"杨瑞红",{"v":98,"d":"98.00"},{"v":3.4,"d":"3.40"},null,{"v":89.02546093064092,"d":"89.03"},{"v":90.09642857142856,"d":"90.10"},{"v":2,"d":"2.00"},null,{"v":77.40031936223602,"d":"77.40"},{"v":99,"d":"99.00"},{"v":0,"d":"0.00"},null,{"v":87.61061946902655,"d":"87.61"},{"v":80.74637768659605,"d":"80.75"},14]
[2016217624,"赵天娇",{"v":98,"d":"98.00"},{"v":2,"d":"2.00"},null,{"v":87.7963125548727,"d":"87.80"},{"v":87.56142857142856,"d":"87.56"},{"v":2.7199999999999998,"d":"2.72"},null,{"v":75.87494447179166,"d":"75.87"},{"v":98,"d":"98.00"},{"v":15,"d":"15.00"},null,{"v":100,"d":"100.00"},{"v":80.67172364122871,"d":"80.67"},15]
[2016217645,"张珂",{"v":95.78399999999999,"d":"95.78"},{"v":10.8,"d":"10.80"},null,{"v":93.57682177348552,"d":"93.58"},{"v":88.57428571428571,"d":"88.57"},{"v":2,"d":"2.00"},null,{"v":76.12106950330768,"d":"76.12"},96.53,{"v":1,"d":"1.00"},null,{"v":86.30973451327434,"d":"86.31"},{"v":80.63108645833991,"d":"80.63"},16]
[2016217654,"周诗涵",{"v":97.89999999999999,"d":"97.90"},{"v":14,"d":"14.00"},null,{"v":98.24407374890255,"d":"98.24"},{"v":83.21357142857141,"d":"83.21"},{"v":4,"d":"4.00"},null,{"v":73.29663469042272,"d":"73.30"},{"v":96.8823529411765,"d":"96.88"},{"v":10,"d":"10.00"},null,{"v":94.58615304528894,"d":"94.59"},{"v":80.4150743376053,"d":"80.42"},17]
[2016217640,"徐梦璇",96.63,{"v":9.6,"d":"9.60"},null,{"v":93.26602282704125,"d":"93.27"},{"v":87.31071428571428,"d":"87.31"},{"v":3,"d":"3.00"},null,{"v":75.89955697494327,"d":"75.90"},96.24,{"v":0,"d":"0.00"},null,{"v":85.16814159292035,"d":"85.17"},{"v":80.29970860716057,"d":"80.30"},18]
[2016217644,"盛涛",{"v":95.371,"d":"95.37"},{"v":9,"d":"9.00"},null,{"v":91.6338893766462,"d":"91.63"},{"v":86.02214285714285,"d":"86.02"},{"v":2,"d":"2.00"},null,{"v":73.9761798993889,"d":"73.98"},95.59,{"v":17,"d":"17.00"},null,{"v":99.63716814159292,"d":"99.64"},{"v":80.07382061906075,"d":"80.07"},19]
[2016217639,"文杰",{"v":97.7,"d":"97.70"},13.33,null,{"v":97.48024582967516,"d":"97.48"},{"v":87.80071428571429,"d":"87.80"},{"v":0,"d":"0.00"},null,{"v":73.7900853633646,"d":"73.79"},96.59,{"v":0,"d":"0.00"},null,{"v":85.47787610619469,"d":"85.48"},{"v":79.69689653090971,"d":"79.70"},20]
[2016217629,"张思琦",{"v":98.3,"d":"98.30"},8.33,null,{"v":93.61720807726076,"d":"93.62"},{"v":86.69928571428571,"d":"86.70"},{"v":2,"d":"2.00"},null,{"v":74.5452689966503,"d":"74.55"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":79.57769628478876,"d":"79.58"},21]
[2016217616,"程志秋",{"v":98.3,"d":"98.30"},{"v":8.8,"d":"8.80"},null,{"v":94.02985074626866,"d":"94.03"},{"v":86.54642857142856,"d":"86.55"},{"v":2,"d":"2.00"},null,{"v":74.41680373629804,"d":"74.42"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":79.57029913634376,"d":"79.57"},22]
["2016217634","赵晨旭",{"v":95.40299999999999,"d":"95.40"},{"v":8.8,"d":"8.80"},null,{"v":91.486391571554,"d":"91.49"},{"v":83.64369747899158,"d":"83.64"},{"v":6,"d":"6.00"},null,{"v":75.3389780832192,"d":"75.34"},95.41,{"v":0,"d":"0.00"},null,{"v":84.43362831858407,"d":"84.43"},{"v":79.47792580442264,"d":"79.48"},23]
[2016217626,"刘熙雯",{"v":98,"d":"98.00"},{"v":8,"d":"8.00"},null,{"v":93.06409130816506,"d":"93.06"},{"v":85.25642857142856,"d":"85.26"},{"v":2,"d":"2.00"},null,{"v":73.33265298771774,"d":"73.33"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":78.61824172471684,"d":"78.62"},24]
[2016217643,"梁静",{"v":96.232,"d":"96.23"},{"v":8.8,"d":"8.80"},null,{"v":92.21422300263389,"d":"92.21"},{"v":86.26071428571427,"d":"86.26"},1.28,null,{"v":73.57157435977476,"d":"73.57"},96.24,{"v":1,"d":"1.00"},null,{"v":86.05309734513274,"d":"86.05"},{"v":78.54825638688237,"d":"78.55"},25]
[2016217641,"王婷",{"v":97.28399999999999,"d":"97.28"},{"v":10.966666666666667,"d":"10.97"},null,{"v":95.04009364940006,"d":"95.04"},{"v":86.57571428571428,"d":"86.58"},{"v":0,"d":"0.00"},null,{"v":72.76056236568176,"d":"72.76"},95.76,{"v":0,"d":"0.00"},null,{"v":84.7433628318584,"d":"84.74"},{"v":78.41474866904308,"d":"78.41"},26]
[2016217621,"张甜甜",{"v":98.69999999999999,"d":"98.70"},{"v":6,"d":"6.00"},null,{"v":91.9227392449517,"d":"91.92"},{"v":86.9992857142857,"d":"87.00"},{"v":0,"d":"0.00"},null,{"v":73.1165432039476,"d":"73.12"},{"v":99,"d":"99.00"},{"v":0,"d":"0.00"},null,{"v":87.61061946902655,"d":"87.61"},{"v":78.32719003865631,"d":"78.33"},27]
["2016217650","张金瑞",{"v":97.24117647058826,"d":"97.24"},{"v":6.6,"d":"6.60"},null,{"v":91.1687238547746,"d":"91.17"},{"v":83.39928571428571,"d":"83.40"},{"v":2.6666666666666665,"d":"2.67"},null,{"v":72.3321447295226,"d":"72.33"},{"v":95.6470588235294,"d":"95.65"},{"v":10,"d":"10.00"},null,{"v":93.49297241020301,"d":"93.49"},{"v":78.21554332264104,"d":"78.22"},28]
[2016217638,"王浩",{"v":97.85799999999999,"d":"97.86"},{"v":5.6,"d":"5.60"},null,{"v":90.83230904302019,"d":"90.83"},{"v":83.65285714285713,"d":"83.65"},{"v":2,"d":"2.00"},null,{"v":71.98496836392887,"d":"71.98"},97.53,{"v":8,"d":"8.00"},null,{"v":93.38938053097345,"d":"93.39"},{"v":77.89487771645159,"d":"77.89"},29]
[2016217648,"种慧敏",{"v":97.09411764705882,"d":"97.09"},{"v":8.8,"d":"8.80"},null,{"v":92.97113050663638,"d":"92.97"},{"v":85.76642857142856,"d":"85.77"},{"v":0,"d":"0.00"},null,{"v":72.08041685176069,"d":"72.08"},{"v":96.5882352941177,"d":"96.59"},{"v":0,"d":"0.00"},null,{"v":85.47631441957319,"d":"85.48"},{"v":77.59814933951708,"d":"77.60"},30]
[2016217622,"张亚萱",{"v":98,"d":"98.00"},{"v":3,"d":"3.00"},null,{"v":88.67427568042143,"d":"88.67"},{"v":84.75428571428571,"d":"84.75"},{"v":2,"d":"2.00"},null,{"v":72.91063860441103,"d":"72.91"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":77.44486853085343,"d":"77.44"},31]
[2016217614,"田安宁",{"v":98.3,"d":"98.30"},{"v":2,"d":"2.00"},null,{"v":88.05970149253731,"d":"88.06"},{"v":84.7392857142857,"d":"84.74"},{"v":2,"d":"2.00"},null,{"v":72.89803220035778,"d":"72.90"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":77.31312921043931,"d":"77.31"},32]
[2016217613,"胡晔南",{"v":98,"d":"98.00"},{"v":2,"d":"2.00"},null,{"v":87.7963125548727,"d":"87.80"},{"v":84.55214285714285,"d":"84.55"},{"v":2,"d":"2.00"},null,{"v":72.74075230216951,"d":"72.74"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":77.1503554941746,"d":"77.15"},33]
[2016217619,"辛添悦",{"v":98,"d":"98.00"},{"v":6,"d":"6.00"},null,{"v":91.30816505706761,"d":"91.31"},{"v":85.12857142857142,"d":"85.13"},{"v":0,"d":"0.00"},null,{"v":71.54434452701972,"d":"71.54"},{"v":98,"d":"98.00"},{"v":0,"d":"0.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":77.01524055200873,"d":"77.02"},34]
[2016217647,"王晖",{"v":97.05294117647057,"d":"97.05"},{"v":8.8,"d":"8.80"},null,{"v":92.93497908381964,"d":"92.93"},{"v":84.315,"d":"84.32"},{"v":0,"d":"0.00"},null,{"v":70.86059718336915,"d":"70.86"},{"v":96.5294117647059,"d":"96.53"},{"v":0,"d":"0.00"},null,{"v":85.42425819885477,"d":"85.42"},{"v":76.73183966500781,"d":"76.73"},35]
[2016217620,"徐盛",{"v":98.3,"d":"98.30"},{"v":1,"d":"1.00"},null,{"v":87.1817383669886,"d":"87.18"},82.46,{"v":2,"d":"2.00"},null,{"v":70.98245908921733,"d":"70.98"},{"v":98,"d":"98.00"},{"v":10,"d":"10.00"},null,{"v":95.57522123893806,"d":"95.58"},{"v":76.68159115974366,"d":"76.68"},36]
[2016217646,"张明珠",{"v":95.65882352941173,"d":"95.66"},{"v":10.366666666666667,"d":"10.37"},null,{"v":93.08647076038491,"d":"93.09"},{"v":83.785,"d":"83.79"},{"v":0,"d":"0.00"},null,{"v":70.41517090682066,"d":"70.42"},{"v":97,"d":"97.00"},{"v":1,"d":"1.00"},null,{"v":86.72566371681415,"d":"86.73"},{"v":76.58048015853285,"d":"76.58"},37]
["2016217651","李乐祎",{"v":97.48823529411762,"d":"97.49"},{"v":6,"d":"6.00"},null,{"v":90.85885451634559,"d":"90.86"},{"v":84.09571428571428,"d":"84.10"},{"v":0,"d":"0.00"},null,{"v":70.6763035622096,"d":"70.68"},{"v":96.3529411764706,"d":"96.35"},{"v":0,"d":"0.00"},null,{"v":85.26808953669965,"d":"85.27"},{"v":76.17199235048581,"d":"76.17"},38]
[2016217652,"李敏之",{"v":97.15882352941173,"d":"97.16"},{"v":3,"d":"3.00"},null,{"v":87.9357537571657,"d":"87.94"},{"v":84.10428571428571,"d":"84.10"},{"v":0,"d":"0.00"},null,{"v":70.6835072216686,"d":"70.68"},{"v":96.1764705882353,"d":"96.18"},{"v":0,"d":"0.00"},null,{"v":85.11192087454451,"d":"85.11"},{"v":75.5767978940556,"d":"75.58"},39]
[2016217653,"杨雪",{"v":97.36470588235296,"d":"97.36"},{"v":8,"d":"8.00"},null,{"v":92.50632649899296,"d":"92.51"},{"v":80.9,"d":"80.90"},{"v":0,"d":"0.00"},null,{"v":67.99053919391052,"d":"67.99"},{"v":95.5882352941177,"d":"95.59"},{"v":0,"d":"0.00"},null,{"v":84.5913586673608,"d":"84.59"},{"v":74.55377860227203,"d":"74.55"},40]

{"sheet":"博15","index":7,"n_rows":31,"n_cols":16,"rows_kept":31,"merged":[[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,1,5],[1,6,1,9],[1,10,1,13],[1,14,2,14],[1,15,2,15]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）工商管理学院2015级博士研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":3},"智育成绩",{"$nulls":3},"文体成绩",{"$nulls":3},"总分","名次"]
[null,null,"基础分","奖励分","惩罚分","总 分","学习成绩分","奖励分","惩罚分","总 分","基本分","奖励分","惩罚分","总 分"]
[2015317005,"董康银",{"v":99,"d":"99.00"},null,null,{"v":99,"d":"99.00"},{"v":89.6,"d":"89.60"},{"v":74.63833333333334,"d":"74.64"},null,{"v":164.23833333333334,"d":"164.24"},{"v":98.875,"d":"98.88"},null,null,{"v":98.875,"d":"98.88"},{"v":97.54056522673545,"d":"97.54"},1]
[2015317003,"陈英超",{"v":98.9125,"d":"98.91"},10,null,{"v":108.9125,"d":"108.91"},{"v":85.7,"d":"85.70"},72.5,null,{"v":158.2,"d":"158.20"},{"v":99,"d":"99.00"},null,null,{"v":99,"d":"99.00"},{"v":96.73712963750638,"d":"96.74"},2]
[2015317001,"董聪",{"v":98.1,"d":"98.10"},6,null,{"v":104.1,"d":"104.10"},{"v":84.72727272727272,"d":"84.73"},29.25,null,{"v":113.97727272727272,"d":"113.98"},{"v":98.875,"d":"98.88"},null,null,{"v":98.875,"d":"98.88"},{"v":77.02306004077954,"d":"77.02"},3]
[2015317008,"韩松",{"v":99.21249999999999,"d":"99.21"},6,null,{"v":105.21249999999999,"d":"105.21"},{"v":88.233,"d":"88.23"},20,null,{"v":108.233,"d":"108.23"},{"v":98.875,"d":"98.88"},null,null,{"v":98.875,"d":"98.88"},{"v":74.77204603599156,"d":"74.77"},4]
[2015317004,"王晓宇",{"v":97.8,"d":"97.80"},15,null,{"v":112.8,"d":"112.80"},{"v":84.89090909,"d":"84.89"},{"v":9.625,"d":"9.63"},null,{"v":94.51590909,"d":"94.52"},{"v":98.875,"d":"98.88"},null,null,{"v":98.875,"d":"98.88"},{"v":70.27098781224458,"d":"70.27"},5]
[2015317009,"王雪成",{"v":99.3,"d":"99.30"},null,null,{"v":99.3,"d":"99.30"},{"v":83.74090909,"d":"83.74"},13.4,null,{"v":97.14090909000001,"d":"97.14"},{"v":98.875,"d":"98.88"},null,null,{"v":98.875,"d":"98.88"},{"v":68.99617172051146,"d":"69.00"},6]
[2015317006,"王文欢",{"v":99.21249999999999,"d":"99.21"},null,null,{"v":99.21249999999999,"d":"99.21"},{"v":84.99375,"d":"84.99"},10.5,null,{"v":95.49375,"d":"95.49"},{"v":99,"d":"99.00"},null,null,{"v":99,"d":"99.00"},{"v":68.29124832407467,"d":"68.29"},7]
[2015317002,"范烨",{"v":98.01249999999999,"d":"98.01"},null,null,{"v":98.01249999999999,"d":"98.01"},{"v":79.64545455,"d":"79.65"},0,null,{"v":79.64545455,"d":"79.65"},{"v":99,"d":"99.00"},null,null,{"v":99,"d":"99.00"},{"v":61.323782297622444,"d":"61.32"},8]
{"$rows_empty":19}
["加分"]

{"sheet":"博16","index":8,"n_rows":9,"n_cols":16,"rows_kept":9,"merged":[[0,0,0,15],[1,0,2,0],[1,1,2,1],[1,2,1,5],[1,6,1,9],[1,10,1,13],[1,14,2,14],[1,15,2,15]],"flags":["formulas_cached_only"]}
["中国石油大学（北京）工商管理学院2016级博士研究生综合测评汇总表"]
["学号","姓名","德育成绩",{"$nulls":3},"智育成绩",{"$nulls":3},"文体成绩",{"$nulls":3},"总分","排名"]
[null,null,"基础分","奖励分","惩罚分","总 分","学习成绩分","奖励分","惩罚分","总 分","基本分","奖励分","惩罚分","总 分"]
[2016317006,"冯翠洋",99,6,0,{"v":96.3302752293578,"d":"96.33"},{"v":86.85714285714286,"d":"86.86"},18.5,0,{"v":100.00000271186448,"d":"100.00"},99,0,0,100,{"v":99.26605694417668,"d":"99.27"},1]
[2016317002,"马少超",99,6,0,{"v":96.3302752293578,"d":"96.33"},{"v":87.42857142857143,"d":"87.43"},16,0,{"v":98.1694941876473,"d":"98.17"},99,0,0,100,{"v":97.98470097722466,"d":"97.98"},2]
[2016317005,"李喆",99,10,0,{"v":100,"d":"100.00"},{"v":89.78571428571429,"d":"89.79"},0,0,{"v":85.22034129411095,"d":"85.22"},99,0,0,100,{"v":89.65423890587766,"d":"89.65"},3]
[2016317003,"冯敬轩",99,0,0,{"v":90.82568807339449,"d":"90.83"},{"v":87.78571428571429,"d":"87.79"},1.25,0,{"v":84.50847686802649,"d":"84.51"},99,0,0,100,{"v":87.32107142229744,"d":"87.32"},4]
[2016317007,"卫静",99,0,0,{"v":90.82568807339449,"d":"90.83"},{"v":85.64285714285714,"d":"85.64"},0,0,{"v":81.28813779764441,"d":"81.29"},99,0,0,100,{"v":85.06683407302998,"d":"85.07"},5]
[2016317001,"杨鑫磊",99,0,0,{"v":90.82568807339449,"d":"90.83"},{"v":84,"d":"84.00"},0,0,{"v":79.72881572145941,"d":"79.73"},99,0,0,100,{"v":83.97530861970048,"d":"83.98"},6]