比赛评分统计表1.xlsx

XXXX比比赛赛评评分分统统计计表表XXCompetition scoring table查询姓名评评分分1 1序序号号姓姓名名评评委委1 1评评委委2 2评评委委3 3评评委委4 4评评委委5 5评评委委6 6评评委委7 71评分18.658.879.119.41弃权9.759.262评分28.968.708.479.168.908.439.793评分39.218.028.228.738.129.848.404评分49.649.978.399.369.289.678.065评分59.558.518.049.379.918.039.856评分69.989.27弃权9.429.469.209.017评分79.458.969.479.928.288.719.808评分89.178.618.059.628.038.498.649评分98.719.778.009.669.039.349.6810评分108.299.078.599.458.129.778.1411评分119.159.918.518.789.398.628.3112评分128.719.969.209.378.279.458.9513评分139.199.199.28弃权8.048.038.5214评分149.869.418.749.258.258.409.2015评分159.209.369.278.469.509.009.451617181920评分规则：1.最后得分按去掉一个最高分，去掉一个最低分，弃权不计，取剩下分值的平均值作为结果；2.排名次序按最后得分从高到低的顺序排列。最后得分排名9.16259.16256 6最最后后得得分分排排名名9.1668.84118.54159.2749.0689.341 19.283 38.59149.282 28.71138.89109.1478.74129.0099.265