您现在的位置：开云官网入口app>>友善书院>>学生组织>>自律会>> 正文
友善书院 201 - 201 学期宿舍评比结果
创建日期：2013-7-4 10:16:12  浏览次数：2827

友善书院 201- 201学期宿舍评比结果
辅导员 班级 楼栋 宿舍 2.3月份数 4月份数 5月份数 6月分数 学期分数 学期等级
曾瑞苗 国贸 1 班 友爱 1101 31.50 31.6 32.4 33.5 32.25 =29,"四星级",IF(I4>=22,"三星级","无星级")))">五星级
友爱 1102 27.67 29 29.2 28 28.47 =29,"四星级",IF(I5>=22,"三星级","无星级")))">三星级
友爱 1103 30.17 30.6 29.2 29 29.74 =29,"四星级",IF(I6>=22,"三星级","无星级")))">四星级
友爱 1104 27.17 29 31.2 32 29.84 =29,"四星级",IF(I7>=22,"三星级","无星级")))">四星级
友爱 1105 26.67 29.2 31.6 34 30.37 =29,"四星级",IF(I8>=22,"三星级","无星级")))">四星级
友爱 1006 29.33 30.4 31.8 33.5 31.26 =29,"四星级",IF(I9>=22,"三星级","无星级")))">四星级
友善 536 28.40 26.6 27.4 29 27.85 =29,"四星级",IF(I10>=22,"三星级","无星级")))">三星级
友善 632 24.80 24.4 20.4 30 24.90 =29,"四星级",IF(I11>=22,"三星级","无星级")))">三星级
友善 634 30.60 26.6 28 24 27.30 =29,"四星级",IF(I12>=22,"三星级","无星级")))">三星级
友善 635 28.80 27.2 28 34 29.50 =29,"四星级",IF(I13>=22,"三星级","无星级")))">四星级
友善 636 29.20 27.2 29.2 31 29.15 =29,"四星级",IF(I14>=22,"三星级","无星级")))">四星级
友善 637 33.80 32.2 33.7 32.5 33.05 =29,"四星级",IF(I15>=22,"三星级","无星级")))">五星级
国贸 2 班 友爱 1101 31.50 31.6 32.4 32.5 32.00 =29,"四星级",IF(I16>=22,"三星级","无星级")))">五星级
友爱 1105 26.67 29.2 31.6 33.5 30.24 =29,"四星级",IF(I17>=22,"三星级","无星级")))">四星级
友爱 1106 31.00 27.4 29.8 33.5 30.43 =29,"四星级",IF(I18>=22,"三星级","无星级")))">四星级
友爱 1109 27.33 27 27.4 30 27.93 =29,"四星级",IF(I19>=22,"三星级","无星级")))">三星级
友爱 1110 29.50 28 30.4 31.5 29.85 =29,"四星级",IF(I20>=22,"三星级","无星级")))">四星级
友爱 1111 31.33 29.4 31.2 32 30.98 =29,"四星级",IF(I21>=22,"三星级","无星级")))">四星级
国贸 3 班 友爱 1006 29.33 30.4 31.8 33.5 31.26 =29,"四星级",IF(I22>=22,"三星级","无星级")))">四星级
友爱 1009 31.50 30.6 32.4 33.5 32.00 =29,"四星级",IF(I23>=22,"三星级","无星级")))">五星级
友爱 1101 31.50 31.6 32.4 33.5 32.25 =29,"四星级",IF(I24>=22,"三星级","无星级")))">五星级
友爱 1111 31.33 30 31.2 32 31.13 =29,"四星级",IF(I25>=22,"三星级","无星级")))">四星级
友爱 1112 26.67 27.4 30.8 32 29.22 =29,"四星级",IF(I26>=22,"三星级","无星级")))">四星级
友爱 1113 26.00 28.2 29.8 30.5 28.63 =29,"四星级",IF(I27>=22,"三星级","无星级")))">三星级
友爱 1114 24.17 28.4 27.6 33 28.29 =29,"四星级",IF(I28>=22,"三星级","无星级")))">三星级
友爱 1115 27.00 30.8 30.6 32.5 30.23 =29,"四星级",IF(I29>=22,"三星级","无星级")))">四星级
国贸 5 班 友爱 1001 31.67 31.6 32.8 33 32.27 =29,"四星级",IF(I30>=22,"三星级","无星级")))">五星级
友爱 1002 29.33 31.4 30.8 30.2 30.43 =29,"四星级",IF(I31>=22,"三星级","无星级")))">四星级
友爱 1115 27.00 30.8 30.6 33.5 30.48 =29,"四星级",IF(I32>=22,"三星级","无星级")))">四星级
友爱 1116 31.33 33.4 33.2 35 33.23 =29,"四星级",IF(I33>=22,"三星级","无星级")))">五星级
友爱 1009 31.50 31.4 32.4 33.5 32.20 =29,"四星级",IF(I34>=22,"三星级","无星级")))">五星级
友爱 1120 30.83 31.4 30.2 33 31.36 =29,"四星级",IF(I35>=22,"三星级","无星级")))">四星级
国贸 6 班 友爱 1002 29.33 31.4 30.6 30 30.33 =29,"四星级",IF(I36>=22,"三星级","无星级")))">四星级
友爱 1003 29.33 28.4 31.2 32 30.23 =29,"四星级",IF(I37>=22,"三星级","无星级")))">四星级
友爱 1004 24.17 25 27.6 26 25.69 =29,"四星级",IF(I38>=22,"三星级","无星级")))">三星级
友爱 1005 24.67 28 29.2 32 28.47 =29,"四星级",IF(I39>=22,"三星级","无星级")))">三星级
友爱 1006 29.33 29.4 31.8 33.5 31.01 =29,"四星级",IF(I40>=22,"三星级","无星级")))">四星级
友爱 1101 31.50 31.6 32.4 33.5 32.25 =29,"四星级",IF(I41>=22,"三星级","无星级")))">五星级
友爱 1116 31.33 32.8 33.2 35 33.08 =29,"四星级",IF(I42>=22,"三星级","无星级")))">五星级
友善 638 30.00 24.8 23.2 29 26.75 =29,"四星级",IF(I43>=22,"三星级","无星级")))">三星级
友善 639 25.60 22.4 17.8 25 22.70 =29,"四星级",IF(I44>=22,"三星级","无星级")))">三星级
友善 640 23.40 22.8 25.2 27 24.60 =29,"四星级",IF(I45>=22,"三星级","无星级")))">三星级
友善 641 29.20 25.6 29.2 29 28.25 =29,"四星级",IF(I46>=22,"三星级","无星级")))">三星级
友善 642 33.40 28 31 34 31.60 =29,"四星级",IF(I47>=22,"三星级","无星级")))">四星级
友善 643 34.00 30.4 29.2 31 31.15 =29,"四星级",IF(I48>=22,"三星级","无星级")))">四星级
友善 644 26.60 17.4 21.2 23 22.05 =29,"四星级",IF(I49>=22,"三星级","无星级")))">三星级
辅导员 班级 楼栋 宿舍 2.3月份数 4月份数 5月份数 6月分数 学期分数 学期等级
陈龙华 12工管 1 班 友善 307 31.80 30.2 32.9 34 32.23 =29,"四星级",IF(I52>=22,"三星级","无星级")))">五星级
友善 401 32.80 32.6 29.8 33.5 32.18 =29,"四星级",IF(I53>=22,"三星级","无星级")))">五星级
友善 402 28.20 28 26.6 21.5 26.08 =29,"四星级",IF(I54>=22,"三星级","无星级")))">三星级
友善 403 30.80 31.6 32 28.9 30.83 =29,"四星级",IF(I55>=22,"三星级","无星级")))">四星级
友善 404 26.60 24.4 27.8 24 25.70 =29,"四星级",IF(I56>=22,"三星级","无星级")))">三星级
友爱 817 30.83 31 30.9 33.8 31.63 =29,"四星级",IF(I57>=22,"三星级","无星级")))">四星级
友爱 818 29.83 29.6 30.7 31.8 30.48 =29,"四星级",IF(I58>=22,"三星级","无星级")))">四星级
友爱 823 29.83 30 32.4 35.1 31.83 =29,"四星级",IF(I59>=22,"三星级","无星级")))">四星级
12工管 2 班 友善 307 31.80 30.2 32.4 33.5 31.98 =29,"四星级",IF(I60>=22,"三星级","无星级")))">四星级
友善 409 32.4 32.6 32.3 34.3 32.90 =29,"四星级",IF(I61>=22,"三星级","无星级")))">五星级
友善 410 23.4 26.4 29.2 25 26.00 =29,"四星级",IF(I62>=22,"三星级","无星级")))">三星级
友善 411 32.2 30 30.6 31 30.95 =29,"四星级",IF(I63>=22,"三星级","无星级")))">四星级
友善 412 33.2 30.2 31.8 32 31.80 =29,"四星级",IF(I64>=22,"三星级","无星级")))">四星级
友爱 819 28 27.8 31 32.9 29.93 =29,"四星级",IF(I65>=22,"三星级","无星级")))">四星级
友爱 820 30.17 28.2 31.4 32.4 30.54 =29,"四星级",IF(I66>=22,"三星级","无星级")))">四星级
12工管3班 友善 417 30.4 28.4 28.2 29.5 29.13 =29,"四星级",IF(I67>=22,"三星级","无星级")))">四星级
友善 418 33.2 29.6 30.6 30.4 30.95 =29,"四星级",IF(I68>=22,"三星级","无星级")))">四星级
友善 419 28.6 27 28.2 31.5 28.83 =29,"四星级",IF(I69>=22,"三星级","无星级")))">三星级
友善 420 32.6 29.8 30.6 27.5 30.13 =29,"四星级",IF(I70>=22,"三星级","无星级")))">四星级
友爱 821 30.33 29.2 32.2 33.6 31.33 =29,"四星级",IF(I71>=22,"三星级","无星级")))">四星级
友爱 822 29 29 32.6 33.2 30.95 =29,"四星级",IF(I72>=22,"三星级","无星级")))">四星级
12土木 1 班 友善 115 29.4 28.8 26 28.5 28.18 =29,"四星级",IF(I73>=22,"三星级","无星级")))">三星级
友善 121 30.4 26.6 31.6 35 30.90 =29,"四星级",IF(I74>=22,"三星级","无星级")))">四星级
友善 308 32.8 30.4 30.2 33 31.60 =29,"四星级",IF(I75>=22,"三星级","无星级")))">四星级
友善 313 32.2 31.4 30.8 33 31.85 =29,"四星级",IF(I76>=22,"三星级","无星级")))">四星级
友善 314 30.8 30.6 32 34.4 31.95 =29,"四星级",IF(I77>=22,"三星级","无星级")))">四星级
友善 315 31 28 28.6 30 29.40 =29,"四星级",IF(I78>=22,"三星级","无星级")))">四星级
友善 316 30.2 28 23.6 32.5 28.58 =29,"四星级",IF(I79>=22,"三星级","无星级")))">三星级
友爱 824 27.67 28 30.2 32.5 29.59 =29,"四星级",IF(I80>=22,"三星级","无星级")))">四星级
12土木 2 班 友善 321 30.2 27.4 27.8 29 28.60 =29,"四星级",IF(I81>=22,"三星级","无星级")))">三星级
友善 322 32.4 28.8 31.6 33.5 31.58 =29,"四星级",IF(I82>=22,"三星级","无星级")))">四星级
友善 323 30.8 25.4 28.8 33 29.50 =29,"四星级",IF(I83>=22,"三星级","无星级")))">四星级
友善 324 32.4 31 31.4 29.9 31.18 =29,"四星级",IF(I84>=22,"三星级","无星级")))">四星级
友善 329 31 29.8 31.4 32 31.05 =29,"四星级",IF(I85>=22,"三星级","无星级")))">四星级
友善 330 31.2 30.2 30 31 30.60 =29,"四星级",IF(I86>=22,"三星级","无星级")))">四星级
12土木 3 班 友善 116 29.4 28 25.4 33.5 29.08 =29,"四星级",IF(I87>=22,"三星级","无星级")))">四星级
友善 331 29.2 30.4 29.6 29.5 29.68 =29,"四星级",IF(I88>=22,"三星级","无星级")))">四星级
友善 332 31.6 28.4 30.2 31.5 30.43 =29,"四星级",IF(I89>=22,"三星级","无星级")))">四星级
友善 337 30.6 27.4 28.2 29.5 28.93 =29,"四星级",IF(I90>=22,"三星级","无星级")))">三星级
友善 338 30.8 28.4 27.8 28 28.75 =29,"四星级",IF(I91>=22,"三星级","无星级")))">三星级
友善 339 30.4 29.6 31.6 32.5 31.03 =29,"四星级",IF(I92>=22,"三星级","无星级")))">四星级
友善 340 33.6 31.4 33.4 35 33.35 =29,"四星级",IF(I93>=22,"三星级","无星级")))">五星级
友爱 825 30.17 30.6 30.8 34 31.39 =29,"四星级",IF(I94>=22,"三星级","无星级")))">四星级
12土木 6 班 友善 340 33.6 32.4 33.4 35 33.60 =29,"四星级",IF(I95>=22,"三星级","无星级")))">五星级
友善 343 32.2 29.8 29.8 29 30.20 =29,"四星级",IF(I96>=22,"三星级","无星级")))">四星级
友善 344 32.6 31.6 31.2 34 32.35 =29,"四星级",IF(I97>=22,"三星级","无星级")))">五星级
友善 443 34.2 33 32 35 33.55 =29,"四星级",IF(I98>=22,"三星级","无星级")))">五星级
友善 444 33.6 32.6 31 32 32.30 =29,"四星级",IF(I99>=22,"三星级","无星级")))">五星级
友爱 826 30.17 27.8 32 34.2 31.04 =29,"四星级",IF(I100>=22,"三星级","无星级")))">四星级
辅导员 班级 楼栋 宿舍 2.3月份数 4月份数 5月份数 6月分数 学期分数 学期等级
黄妙红 11土木 5 班 友善 508 33.20 30.2 31.2 31 31.40 =29,"四星级",IF(I103>=22,"三星级","无星级")))">四星级
友善 513 33.80 32.6 32.8 35 33.55 =29,"四星级",IF(I104>=22,"三星级","无星级")))">五星级
友善 514 33.40 31.2 32.8 35 33.10 =29,"四星级",IF(I105>=22,"三星级","无星级")))">五星级
友善 515 33.00 32 31.4 33 32.35 =29,"四星级",IF(I106>=22,"三星级","无星级")))">五星级
友善 516 33.60 31 31.8 33.4 32.45 =29,"四星级",IF(I107>=22,"三星级","无星级")))">五星级
友善 521 32.80 31 32.4 35 32.80 =29,"四星级",IF(I108>=22,"三星级","无星级")))">五星级
友善 543 33.60 31.8 29.8 31 31.55 =29,"四星级",IF(I109>=22,"三星级","无星级")))">四星级
友爱 901 30.50 30.8 32.6 31.1 31.25 =29,"四星级",IF(I110>=22,"三星级","无星级")))">四星级
友爱 902 28.00 30.2 30.2 31.5 29.98 =29,"四星级",IF(I111>=22,"三星级","无星级")))">四星级
友爱 903 30.67 30.8 30.6 33.5 31.39 =29,"四星级",IF(I112>=22,"三星级","无星级")))">四星级
友爱 904 29.83 28.8 30.4 32 30.26 =29,"四星级",IF(I113>=22,"三星级","无星级")))">四星级
友爱 905 33.83 30.8 32.5 32.8 32.48 =29,"四星级",IF(I114>=22,"三星级","无星级")))">五星级
友爱 906 31.17 30.6 30.8 33 31.39 =29,"四星级",IF(I115>=22,"三星级","无星级")))">四星级
11土木 6 班 友善 522 33.60 31.4 27.2 33 31.30 =29,"四星级",IF(I116>=22,"三星级","无星级")))">四星级
友善 523 32.00 33 31.6 34 32.65 =29,"四星级",IF(I117>=22,"三星级","无星级")))">五星级
友善 524 34.40 30.6 29.2 28 30.55 =29,"四星级",IF(I118>=22,"三星级","无星级")))">四星级
友善 529 33.80 32.8 31.8 35 33.35 =29,"四星级",IF(I119>=22,"三星级","无星级")))">五星级
友善 530 34.80 30.6 29 30 31.10 =29,"四星级",IF(I120>=22,"三星级","无星级")))">四星级
11土木 7 班 友善 526 32.40 32 33.5 35.5 33.35 =29,"四星级",IF(I121>=22,"三星级","无星级")))">五星级
友善 531 32.40 29 30.1 31.5 30.75 =29,"四星级",IF(I122>=22,"三星级","无星级")))">四星级
友善 532 35.00 33.4 32 35 33.85 =29,"四星级",IF(I123>=22,"三星级","无星级")))">五星级
友善 537 34.00 32 32.6 35 33.40 =29,"四星级",IF(I124>=22,"三星级","无星级")))">五星级
友善 538 33.20 30.4 29 33 31.40 =29,"四星级",IF(I125>=22,"三星级","无星级")))">四星级
友善 539 33.40 28.2 30.2 30 30.45 =29,"四星级",IF(I126>=22,"三星级","无星级")))">四星级
友善 540 33.00 32.6 31.6 32 32.30 =29,"四星级",IF(I127>=22,"三星级","无星级")))">五星级
11土木 8 班 友善 442 30.80 31.4 31.2 32.5 31.48 =29,"四星级",IF(I128>=22,"三星级","无星级")))">四星级
友善 507 33.60 31.4 30 32 31.75 =29,"四星级",IF(I129>=22,"三星级","无星级")))">四星级
友善 525 31.20 29.8 29.4 29 29.85 =29,"四星级",IF(I130>=22,"三星级","无星级")))">四星级
友善 527 33.40 31 30.4 33.4 32.05 =29,"四星级",IF(I131>=22,"三星级","无星级")))">五星级
友善 543 33.60 30.8 29.8 31 31.30 =29,"四星级",IF(I132>=22,"三星级","无星级")))">四星级
友善 544 30.80 29.4 29.6 30 29.95 =29,"四星级",IF(I133>=22,"三星级","无星级")))">四星级
11土木 9 班 友善 512 32.00 31.4 30.2 31 31.15 =29,"四星级",IF(I134>=22,"三星级","无星级")))">四星级
友善 517 32.20 30.8 30.6 34 31.90 =29,"四星级",IF(I135>=22,"三星级","无星级")))">四星级
友善 518 33.00 30.6 32.2 33 32.20 =29,"四星级",IF(I136>=22,"三星级","无星级")))">五星级
友善 519 31.60 31 31.6 33 31.80 =29,"四星级",IF(I137>=22,"三星级","无星级")))">四星级
友善 520 32.80 29.2 29.8 32 30.95 =29,"四星级",IF(I138>=22,"三星级","无星级")))">四星级
友善 528 31.40 29.8 31.2 29.6 30.50 =29,"四星级",IF(I139>=22,"三星级","无星级")))">四星级
友善 533 32.00 30.6 28.2 26 29.20 =29,"四星级",IF(I140>=22,"三星级","无星级")))">四星级
12土木 4 班 友善 301 23.40 26.2 28.6 27 26.30 =29,"四星级",IF(I141>=22,"三星级","无星级")))">三星级
友善 302 32.60 29.6 33 32.5 31.93 =29,"四星级",IF(I142>=22,"三星级","无星级")))">四星级
友善 303 30.20 28.4 28 28.5 28.78 =29,"四星级",IF(I143>=22,"三星级","无星级")))">三星级
友善 304 29.80 27.2 29.2 31 29.30 =29,"四星级",IF(I144>=22,"三星级","无星级")))">四星级
友善 309 30.40 31 32.6 33.7 31.93 =29,"四星级",IF(I145>=22,"三星级","无星级")))">四星级
友善 310 28.80 28.8 31.8 32.5 30.48 =29,"四星级",IF(I146>=22,"三星级","无星级")))">四星级
友善 311 28.00 29.4 30.4 28 28.95 =29,"四星级",IF(I147>=22,"三星级","无星级")))">三星级
友爱 1129 32.67 29.8 31.4 29.5 30.84 =29,"四星级",IF(I148>=22,"三星级","无星级")))">四星级
辅导员 班级 楼栋 宿舍 2.3月份数 4月份数 5月份数 6月分数 学期分数 学期等级
李玮瑜 11国贸 4 班 友善 542 31.20 30.8 28.8 29 29.95 =29,"四星级",IF(I151>=22,"三星级","无星级")))">四星级
友善 606 31.80 29.2 30.4 33 31.10 =29,"四星级",IF(I152>=22,"三星级","无星级")))">四星级
友善 607 33.60 30 31.8 35 32.60 =29,"四星级",IF(I153>=22,"三星级","无星级")))">五星级
友爱 1010 32.00 31.2 33.6 33.5 32.58 =29,"四星级",IF(I154>=22,"三星级","无星级")))">五星级
友爱 1011 28.17 28.2 27.4 30.5 28.57 =29,"四星级",IF(I155>=22,"三星级","无星级")))">三星级
友爱 1012 32.17 32.4 33.2 34 32.94 =29,"四星级",IF(I156>=22,"三星级","无星级")))">五星级
友爱 1013 30.33 30.8 30.2 31 30.58 =29,"四星级",IF(I157>=22,"三星级","无星级")))">四星级
友爱 1014 29.50 28.6 33 32 30.78 =29,"四星级",IF(I158>=22,"三星级","无星级")))">四星级
11国贸 7 班 友善 608 28.60 25.6 26.8 27 27.00 =29,"四星级",IF(I159>=22,"三星级","无星级")))">三星级
友善 613 33.80 29.2 29 30 30.50 =29,"四星级",IF(I160>=22,"三星级","无星级")))">四星级
友善 614 32.20 30 30.4 33.4 31.50 =29,"四星级",IF(I161>=22,"三星级","无星级")))">四星级
友爱 1015 32.00 30.6 32.4 31 31.50 =29,"四星级",IF(I162>=22,"三星级","无星级")))">四星级
友爱 1016 34.00 34.4 34 35 34.35 =29,"四星级",IF(I163>=22,"三星级","无星级")))">五星级
友爱 1017 30.17 30.6 32 31.5 31.07 =29,"四星级",IF(I164>=22,"三星级","无星级")))">四星级
友爱 1018 33.00 32.2 33.4 34.5 33.28 =29,"四星级",IF(I165>=22,"三星级","无星级")))">五星级
11国贸 8 班 友善 114 27.80 13.4 24.4 25 22.65 =29,"四星级",IF(I166>=22,"三星级","无星级")))">三星级
友善 442 31.80 31.4 31.2 32.5 31.73 =29,"四星级",IF(I167>=22,"三星级","无星级")))">四星级
友善 542 31.20 30.8 28.8 29 29.95 =29,"四星级",IF(I168>=22,"三星级","无星级")))">四星级
友善 615 29.00 27.4 28.4 29 28.45 =29,"四星级",IF(I169>=22,"三星级","无星级")))">三星级
友善 616 25.40 25 21 31 25.60 =29,"四星级",IF(I170>=22,"三星级","无星级")))">三星级
友爱 1019 30.00 28.6 32.8 30.5 30.48 =29,"四星级",IF(I171>=22,"三星级","无星级")))">四星级
友爱 1020 30.33 28.6 32.8 31 30.68 =29,"四星级",IF(I172>=22,"三星级","无星级")))">四星级
友爱 1021 32.17 32 32.6 33 32.44 =29,"四星级",IF(I173>=22,"三星级","无星级")))">五星级
友爱 1022 29.67 28.6 32.2 30.5 30.24 =29,"四星级",IF(I174>=22,"三星级","无星级")))">四星级
11国贸 9 班 友善 621 32.00 28.6 29.8 31 30.35 =29,"四星级",IF(I175>=22,"三星级","无星级")))">四星级
友善 622 31.60 28.4 24 35.6 29.90 =29,"四星级",IF(I176>=22,"三星级","无星级")))">四星级
友爱 909 31.00 32.4 31 33 31.85 =29,"四星级",IF(I177>=22,"三星级","无星级")))">四星级
友爱 1023 31.83 30.8 33.2 32.5 32.08 =29,"四星级",IF(I178>=22,"三星级","无星级")))">五星级
友爱 1024 29.50 29.6 32.4 30.9 30.60 =29,"四星级",IF(I179>=22,"三星级","无星级")))">四星级
友爱 1025 31.17 28.8 31.2 33 31.04 =29,"四星级",IF(I180>=22,"三星级","无星级")))">四星级
友爱 1122 32.00 32.4 33.6 34 33.00 =29,"四星级",IF(I181>=22,"三星级","无星级")))">五星级
11国贸 10班 友善 623 31.80 29.2 28.4 30 29.85 =29,"四星级",IF(I182>=22,"三星级","无星级")))">四星级
友善 624 33.20 27 26.2 32 29.60 =29,"四星级",IF(I183>=22,"三星级","无星级")))">四星级
友善 629 33.60 30 30.2 34 31.95 =29,"四星级",IF(I184>=22,"三星级","无星级")))">四星级
友爱 1026 31.33 31.4 32.2 35 32.48 =29,"四星级",IF(I185>=22,"三星级","无星级")))">五星级
友爱 1027 29.33 28.8 30.6 30.5 29.81 =29,"四星级",IF(I186>=22,"三星级","无星级")))">四星级
友爱 1028 28.83 26.2 31 31.2 29.31 =29,"四星级",IF(I187>=22,"三星级","无星级")))">四星级
友爱 1029 31.17 30.4 32.6 34 32.04 =29,"四星级",IF(I188>=22,"三星级","无星级")))">五星级
11国贸 11班 友善 541 29.60 21.4 24.2 23 24.55 =29,"四星级",IF(I189>=22,"三星级","无星级")))">三星级
友善 630 34.00 31.2 31.8 34 32.75 =29,"四星级",IF(I190>=22,"三星级","无星级")))">五星级
友善 631 31.00 27.4 26 30 28.60 =29,"四星级",IF(I191>=22,"三星级","无星级")))">三星级
友爱 1030 27.83 29.8 30.4 30 29.51 =29,"四星级",IF(I192>=22,"三星级","无星级")))">四星级
友爱 1031 30.00 30.4 31.6 30.5 30.63 =29,"四星级",IF(I193>=22,"三星级","无星级")))">四星级
友爱 1032 28.83 28.8 32.6 31 30.31 =29,"四星级",IF(I194>=22,"三星级","无星级")))">四星级
辅导员 班级 楼栋 宿舍 2.3月份数 4月份数 5月份数 6月分数 学期分数 学期等级
林跃辉 12国贸7班 友善 237 29.00 25.8 24 30.5 27.33 =29,"四星级",IF(I197>=22,"三星级","无星级")))">三星级
友善 238 28.40 26.4 24 31 27.45 =29,"四星级",IF(I198>=22,"三星级","无星级")))">三星级
友善 239 24.60 25.2 25.8 29.5 26.28 =29,"四星级",IF(I199>=22,"三星级","无星级")))">三星级
友爱 601 25.67 27 26 22 25.17 =29,"四星级",IF(I200>=22,"三星级","无星级")))">三星级
友爱 602 31.50 32.8 31.4 32.5 32.05 =29,"四星级",IF(I201>=22,"三星级","无星级")))">五星级
友爱 603 25.83 26.4 24 26 25.56 =29,"四星级",IF(I202>=22,"三星级","无星级")))">三星级
友爱 710 25.50 29.4 28 32.5 28.85 =29,"四星级",IF(I203>=22,"三星级","无星级")))">三星级
友爱 725 28.50 21.8 32.6 32 28.73 =29,"四星级",IF(I204>=22,"三星级","无星级")))">三星级
12国贸8班 友善 240 33.60 32.8 31.8 34.5 33.18 =29,"四星级",IF(I205>=22,"三星级","无星级")))">五星级
友善 243 30.80 29.6 26.8 21 27.05 =29,"四星级",IF(I206>=22,"三星级","无星级")))">三星级
友爱 711 27.83 31.4 30.6 34.5 31.08 =29,"四星级",IF(I207>=22,"三星级","无星级")))">四星级
友爱 712 28.33 32.8 30.8 33 31.23 =29,"四星级",IF(I208>=22,"三星级","无星级")))">四星级
友爱 713 28.33 30 27.2 32 29.38 =29,"四星级",IF(I209>=22,"三星级","无星级")))">四星级
友爱 714 30.00 31.6 32.1 35.5 32.30 =29,"四星级",IF(I210>=22,"三星级","无星级")))">五星级
友爱 725 28.50 22.8 32.6 32.6 29.13 =29,"四星级",IF(I211>=22,"三星级","无星级")))">四星级
12国贸9班 友善 244 24 24.8 27 25.27 =29,"四星级",IF(I212>=22,"三星级","无星级")))">三星级
友善 326 16.20 22.6 26.2 29 23.00 =29,"四星级",IF(I213>=22,"三星级","无星级")))">三星级
友善 327 26.20 27 32.4 31 26.00 =29,"四星级",IF(I214>=22,"三星级","无星级")))">三星级
友爱 716 30.33 30.8 29.6 31 30.18 =29,"四星级",IF(I215>=22,"三星级","无星级")))">四星级
友爱 717 30.33 33.6 31 33.5 30.43 =29,"四星级",IF(I216>=22,"三星级","无星级")))">四星级
友爱 718 30.00 29.8 30.2 35 32.03 =29,"四星级",IF(I217>=22,"三星级","无星级")))">五星级
友爱 719 27.50 33.4 31.4 32 30.63 =29,"四星级",IF(I218>=22,"三星级","无星级")))">四星级
友爱 729 32.17 32.2 30.4 34.5 32.24 =29,"四星级",IF(I219>=22,"三星级","无星级")))">五星级
12国贸10班 友善 114 27.80 13.4 24.4 25 22.65 =29,"四星级",IF(I220>=22,"三星级","无星级")))">三星级
友善 123 29.6 29.6 34.5 31.23 =29,"四星级",IF(I221>=22,"三星级","无星级")))">四星级
友善 328 24.00 26.8 20.4 25.5 24.18 =29,"四星级",IF(I222>=22,"三星级","无星级")))">三星级
友善 333 30.40 29 29 30 29.60 =29,"四星级",IF(I223>=22,"三星级","无星级")))">四星级
友爱 721 32.33 32.6 31.4 31.5 31.96 =29,"四星级",IF(I224>=22,"三星级","无星级")))">四星级
友爱 722 33.17 33 26 35 31.79 =29,"四星级",IF(I225>=22,"三星级","无星级")))">四星级
友爱 723 30.67 30 26.4 32.5 29.89 =29,"四星级",IF(I226>=22,"三星级","无星级")))">四星级
友爱 724 31.17 31 30.8 34.5 31.87 =29,"四星级",IF(I227>=22,"三星级","无星级")))">四星级
12国贸11班 友善 334 30.20 32.2 27.6 32 30.50 =29,"四星级",IF(I228>=22,"三星级","无星级")))">四星级
友善 335 25.80 24.4 26.8 28 26.25 =29,"四星级",IF(I229>=22,"三星级","无星级")))">三星级
友善 336 20.80 15.8 25.8 29.5 22.98 =29,"四星级",IF(I230>=22,"三星级","无星级")))">三星级
友爱 715 32.17 32 33 32 32.29 =29,"四星级",IF(I231>=22,"三星级","无星级")))">五星级
友爱 726 28.83 30.6 29.2 32.5 30.28 =29,"四星级",IF(I232>=22,"三星级","无星级")))">四星级
友爱 727 31.50 32.8 33.4 34.6 33.08 =29,"四星级",IF(I233>=22,"三星级","无星级")))">五星级
友爱 728 32.83 32.8 32.4 35 33.26 =29,"四星级",IF(I234>=22,"三星级","无星级")))">五星级
12国贸12班 友善 341 29.80 26.6 30 30.7 29.28 =29,"四星级",IF(I235>=22,"三星级","无星级")))">四星级
友善 342 31.20 30 30 32.5 30.93 =29,"四星级",IF(I236>=22,"三星级","无星级")))">四星级
友爱 720 31.50 32.2 30 33 31.68 =29,"四星级",IF(I237>=22,"三星级","无星级")))">四星级
友爱 729 32.17 32.2 30.4 34.5 32.32 =29,"四星级",IF(I238>=22,"三星级","无星级")))">五星级
友爱 730 30.83 31 28.4 33 30.81 =29,"四星级",IF(I239>=22,"三星级","无星级")))">四星级
友爱 731 25.17 29.6 28 29 27.94 =29,"四星级",IF(I240>=22,"三星级","无星级")))">三星级
友爱 732 31.67 33.2 29 32 31.47 =29,"四星级",IF(I241>=22,"三星级","无星级")))">四星级
辅导员 班级 楼栋 宿舍 2.3月份数 4月份数 5月份数 6月分数 学期分数 学期等级
瞿丽闵 12国贸 1 班 友善 416 34.40 29.8 28.2 34 31.60 =29,"四星级",IF(I244>=22,"三星级","无星级")))">四星级
友善 421 25.60 28.6 28.6 34.5 29.33 =29,"四星级",IF(I245>=22,"三星级","无星级")))">四星级
友爱 801 28.00 31.8 32.2 32 31.00 =29,"四星级",IF(I246>=22,"三星级","无星级")))">四星级
友爱 802 30.50 30.8 33 33.5 31.95 =29,"四星级",IF(I247>=22,"三星级","无星级")))">四星级
友爱 803 30.17 31.4 33.7 34.3 32.39 =29,"四星级",IF(I248>=22,"三星级","无星级")))">五星级
友爱 804 27.50 32.6 31.4 31.5 30.75 =29,"四星级",IF(I249>=22,"三星级","无星级")))">四星级
友爱 805 29.17 32 32 32.5 31.42 =29,"四星级",IF(I250>=22,"三星级","无星级")))">四星级
12国贸 2 班 友善 422 33.00 28.2 29 23 28.30 =29,"四星级",IF(I251>=22,"三星级","无星级")))">三星级
友善 423 22.00 27.2 26.2 20.5 23.98 =29,"四星级",IF(I252>=22,"三星级","无星级")))">三星级
友爱 806 28.50 32.2 31.4 29 30.28 =29,"四星级",IF(I253>=22,"三星级","无星级")))">四星级
友爱 807 27.17 29.6 31 29.5 29.32 =29,"四星级",IF(I254>=22,"三星级","无星级")))">四星级
友爱 809 31.00 33 33.2 32 32.30 =29,"四星级",IF(I255>=22,"三星级","无星级")))">五星级
友爱 810 31.17 32.8 33 33.5 32.62 =29,"四星级",IF(I256>=22,"三星级","无星级")))">五星级
友爱 811 30.83 30.8 33 33.5 32.03 =29,"四星级",IF(I257>=22,"三星级","无星级")))">五星级
12国贸 3 班 友善 424 31.60 31.2 31 34.5 32.08 =29,"四星级",IF(I258>=22,"三星级","无星级")))">五星级
友善 429 33.60 30.2 33.2 34 32.75 =29,"四星级",IF(I259>=22,"三星级","无星级")))">五星级
友爱 812 30.67 31.8 31.2 33 31.67 =29,"四星级",IF(I260>=22,"三星级","无星级")))">四星级
友爱 813 31.00 32.6 31.7 34.5 32.45 =29,"四星级",IF(I261>=22,"三星级","无星级")))">五星级
友爱 814 27.00 31.4 28.8 31.5 29.68 =29,"四星级",IF(I262>=22,"三星级","无星级")))">四星级
友爱 815 27.00 30 29.2 30.5 29.18 =29,"四星级",IF(I263>=22,"三星级","无星级")))">四星级
友爱 816 29.67 31.6 31.4 33.5 31.54 =29,"四星级",IF(I264>=22,"三星级","无星级")))">四星级
12国贸 4 班 友善 430 26.80 31.2 28.6 29.5 29.03 =29,"四星级",IF(I265>=22,"三星级","无星级")))">四星级
友善 431 33.60 30.6 29.6 27 30.20 =29,"四星级",IF(I266>=22,"三星级","无星级")))">四星级
友善 438 33.20 32 32 34 32.80 =29,"四星级",IF(I267>=22,"三星级","无星级")))">五星级
友爱 505 28.50 28 29.4 27.5 28.35 =29,"四星级",IF(I268>=22,"三星级","无星级")))">三星级
友爱 506 31.17 28.4 32.4 33.5 31.37 =29,"四星级",IF(I269>=22,"三星级","无星级")))">四星级
友爱 701 28.83 30.6 28 28.5 28.98 =29,"四星级",IF(I270>=22,"三星级","无星级")))">三星级
友爱 702 31.50 29.2 32.8 35 32.13 =29,"四星级",IF(I271>=22,"三星级","无星级")))">五星级
12国贸 5 班 友善 432 28.00 28.2 24.8 27 27.00 =29,"四星级",IF(I272>=22,"三星级","无星级")))">三星级
友善 437 23.80 24.4 28.4 29 26.40 =29,"四星级",IF(I273>=22,"三星级","无星级")))">三星级
友善 438 33.20 32 31.8 34 32.75 =29,"四星级",IF(I274>=22,"三星级","无星级")))">五星级
友爱 703 26.67 28.2 28 32 28.72 =29,"四星级",IF(I275>=22,"三星级","无星级")))">三星级
友爱 704 26.50 25.2 25.4 22 24.78 =29,"四星级",IF(I276>=22,"三星级","无星级")))">三星级
友爱 705 27.67 30.4 27 32 29.27 =29,"四星级",IF(I277>=22,"三星级","无星级")))">四星级
友爱 706 25.83 29.6 29.4 33 29.46 =29,"四星级",IF(I278>=22,"三星级","无星级")))">四星级
友爱 1007 29.50 31 29.5 33 30.75 =29,"四星级",IF(I279>=22,"三星级","无星级")))">四星级
12国贸 6 班 友善 439 30.40 25 26.2 34 28.90 =29,"四星级",IF(I280>=22,"三星级","无星级")))">三星级
友善 440 30.60 26 28.8 25 27.60 =29,"四星级",IF(I281>=22,"三星级","无星级")))">三星级
友爱 707 30.17 30.6 29 33 30.69 =29,"四星级",IF(I282>=22,"三星级","无星级")))">四星级
友爱 709 30.17 32.6 31 34.2 31.99 =29,"四星级",IF(I283>=22,"三星级","无星级")))">四星级
友爱 1107 30.00 31.4 31 31.5 30.98 =29,"四星级",IF(I284>=22,"三星级","无星级")))">四星级
友爱 1118 32.83 31.6 29.4 33.5 31.83 =29,"四星级",IF(I285>=22,"三星级","无星级")))">四星级
辅导员 班级 楼栋 宿舍 2.3月份数 4月份数 5月份数 6月分数 学期分数 学期等级
谢永亮 11财管 1 班 友善 425 31.80 29.6 32.8 33.5 31.93 =29,"四星级",IF(I288>=22,"三星级","无星级")))">四星级
友善 426 30.60 31.2 30 32.5 31.08 =29,"四星级",IF(I289>=22,"三星级","无星级")))">四星级
友善 427 30.20 30.6 31.6 33.5 31.48 =29,"四星级",IF(I290>=22,"三星级","无星级")))">四星级
友爱 520 29.67 28.6 30.8 32.5 30.39 =29,"四星级",IF(I291>=22,"三星级","无星级")))">四星级
友爱 911 27.00 26.6 29.3 30.3 29.35 =29,"四星级",IF(I292>=22,"三星级","无星级")))">四星级
友爱 912 24.33 23.4 27.6 29 27.21 =29,"四星级",IF(I293>=22,"三星级","无星级")))">三星级
友爱 913 28.50 30 32.1 29.5 27.13 =29,"四星级",IF(I294>=22,"三星级","无星级")))">三星级
友爱 914 25.67 29 27.2 28 29.32 =29,"四星级",IF(I295>=22,"三星级","无星级")))">四星级
友爱 915 27.00 31.6 32.2 32 27.80 =29,"四星级",IF(I296>=22,"三星级","无星级")))">三星级
友爱 916 28.17 28.6 31.6 34 30.99 =29,"四星级",IF(I297>=22,"三星级","无星级")))">四星级
11财管 2 班 友善 428 32.40 29.8 31 31.5 31.65 =29,"四星级",IF(I298>=22,"三星级","无星级")))">四星级
友善 433 32.20 28.8 26.6 32.5 30.03 =29,"四星级",IF(I299>=22,"三星级","无星级")))">四星级
友爱 916 28.17 29.2 31.6 29 30.27 =29,"四星级",IF(I300>=22,"三星级","无星级")))">四星级
友爱 917 28.67 27.6 31.3 29.2 29.54 =29,"四星级",IF(I301>=22,"三星级","无星级")))">四星级
友爱 918 29.83 32.4 30.8 31.5 29.36 =29,"四星级",IF(I302>=22,"三星级","无星级")))">四星级
友爱 919 30.67 26.6 31.8 32.5 31.59 =29,"四星级",IF(I303>=22,"三星级","无星级")))">四星级
友爱 920 27.67 27.6 30.6 31.5 29.34 =29,"四星级",IF(I304>=22,"三星级","无星级")))">四星级
友爱 921 28.33 26.6 29.8 30.5 29.31 =29,"四星级",IF(I305>=22,"三星级","无星级")))">四星级
友爱 922 29.33 28.6 29 30.5 28.86 =29,"四星级",IF(I306>=22,"三星级","无星级")))">三星级
友爱 929 30.83 29 28.8 31 29.68 =29,"四星级",IF(I307>=22,"三星级","无星级")))">四星级
11财管 3 班 友善 434 30.80 29.2 31 29.5 30.45 =29,"四星级",IF(I308>=22,"三星级","无星级")))">四星级
友善 435 30.00 30.4 30 31.5 29.68 =29,"四星级",IF(I309>=22,"三星级","无星级")))">四星级
友善 436 31.60 29.4 31.2 33 31.18 =29,"四星级",IF(I310>=22,"三星级","无星级")))">四星级
友爱 923 30.50 27.4 31.8 31 31.18 =29,"四星级",IF(I311>=22,"三星级","无星级")))">四星级
友爱 924 29.00 32.8 31 33 29.60 =29,"四星级",IF(I312>=22,"三星级","无星级")))">四星级
友爱 925 31.50 29.6 34.4 31 32.93 =29,"四星级",IF(I313>=22,"三星级","无星级")))">五星级
友爱 926 28.83 29 30.4 30 29.96 =29,"四星级",IF(I314>=22,"三星级","无星级")))">四星级
友爱 927 30.33 28.2 30.8 29.5 30.03 =29,"四星级",IF(I315>=22,"三星级","无星级")))">四星级
友爱 928 27.33 28.6 29 30.5 28.51 =29,"四星级",IF(I316>=22,"三星级","无星级")))">三星级
友爱 929 30.83 29.8 28.8 34 29.68 =29,"四星级",IF(I317>=22,"三星级","无星级")))">四星级
12财管 7 班 友善 406 32.60 29.6 32.4 32.4 32.20 =29,"四星级",IF(I318>=22,"三星级","无星级")))">五星级
友善 407 30.60 31.2 30.4 34.5 30.75 =29,"四星级",IF(I319>=22,"三星级","无星级")))">四星级
友善 408 32.00 27.4 31.2 34 32.23 =29,"四星级",IF(I320>=22,"三星级","无星级")))">五星级
友爱 827 31.50 29.4 32.4 33.6 31.33 =29,"四星级",IF(I321>=22,"三星级","无星级")))">四星级
友爱 828 32.67 28.8 33 35 32.02 =29,"四星级",IF(I322>=22,"三星级","无星级")))">五星级
友爱 829 33.17 32.2 33.6 34 32.49 =29,"四星级",IF(I323>=22,"三星级","无星级")))">五星级
友爱 830 31.67 30.2 31.2 31 32.87 =29,"四星级",IF(I324>=22,"三星级","无星级")))">五星级
友爱 930 28.33 28.6 31.2 31.5 30.18 =29,"四星级",IF(I325>=22,"三星级","无星级")))">四星级
12财管 8 班 友善 413 32.80 31 30.6 30.5 31.38 =29,"四星级",IF(I326>=22,"三星级","无星级")))">四星级
友善 414 32.20 29.4 27 29 29.40 =29,"四星级",IF(I327>=22,"三星级","无星级")))">四星级
友善 415 33.00 30.8 33 32 32.20 =29,"四星级",IF(I328>=22,"三星级","无星级")))">五星级
友爱 831 32.00 31.6 32.2 32 31.95 =29,"四星级",IF(I329>=22,"三星级","无星级")))">四星级
友爱 832 27.83 25.4 30.2 33 29.11 =29,"四星级",IF(I330>=22,"三星级","无星级")))">四星级
友爱 930 27.33 28.6 31.2 31.5 29.66 =29,"四星级",IF(I331>=22,"三星级","无星级")))">四星级
友爱 931 30.00 31.6 30.8 33 31.35 =29,"四星级",IF(I332>=22,"三星级","无星级")))">四星级
友爱 932 30.83 28.6 30.8 30.5 30.18 =29,"四星级",IF(I333>=22,"三星级","无星级")))">四星级
辅导员 班级 楼栋 宿舍 2.3月份数 4月份数 5月份数 6月分数 学期分数 学期等级
杨家磊 11土木 1 班 友善 441 26.60 28 25.6 22.5 25.68 =29,"四星级",IF(I336>=22,"三星级","无星级")))">三星级
友善 501 28.20 26.2 26 32 28.10 =29,"四星级",IF(I337>=22,"三星级","无星级")))">三星级
友善 502 32.80 30.8 30.6 34 32.05 =29,"四星级",IF(I338>=22,"三星级","无星级")))">五星级
友善 503 34.60 32 33.2 35 33.70 =29,"四星级",IF(I339>=22,"三星级","无星级")))">五星级
友善 504 27.00 27.6 29.5 30.5 28.65 =29,"四星级",IF(I340>=22,"三星级","无星级")))">三星级
友善 509 26.80 29.4 26.4 31 28.40 =29,"四星级",IF(I341>=22,"三星级","无星级")))">三星级
友善 534 18.00 24.4 21.6 23 21.75 =29,"四星级",IF(I342>=22,"三星级","无星级")))">无星级
友善 628 31.20 26.8 27.4 31 29.10 =29,"四星级",IF(I343>=22,"三星级","无星级")))">四星级
友善 633 31.00 26.8 28.6 33 29.85 =29,"四星级",IF(I344>=22,"三星级","无星级")))">四星级
友爱 1117 27.17 31.6 31.4 33.5 30.92 =29,"四星级",IF(I345>=22,"三星级","无星级")))">四星级
11土木 2 班 友善 510 34.40 31.4 30.8 35 32.90 =29,"四星级",IF(I346>=22,"三星级","无星级")))">五星级
友善 511 32.80 30.4 28.3 34.3 31.45 =29,"四星级",IF(I347>=22,"三星级","无星级")))">四星级
友善 601 30.80 26.6 29.6 29 29.00 =29,"四星级",IF(I348>=22,"三星级","无星级")))">四星级
友善 602 25.60 26.6 28.6 29 27.45 =29,"四星级",IF(I349>=22,"三星级","无星级")))">三星级
友善 603 33.00 24.4 27 28 28.10 =29,"四星级",IF(I350>=22,"三星级","无星级")))">三星级
友善 604 28.80 27.6 28 31 28.85 =29,"四星级",IF(I351>=22,"三星级","无星级")))">三星级
友爱 906 31.17 30.6 31.2 33.4 31.59 =29,"四星级",IF(I352>=22,"三星级","无星级")))">四星级
友爱 1117 27.17 31.6 31.4 33.5 30.92 =29,"四星级",IF(I353>=22,"三星级","无星级")))">四星级
11土木 3 班 友善 534 18.00 24.4 21.6 26 22.50 =29,"四星级",IF(I354>=22,"三星级","无星级")))">三星级
友善 535 34.80 32 32 30 32.20 =29,"四星级",IF(I355>=22,"三星级","无星级")))">五星级
友善 609 32.60 30.6 31 32 31.55 =29,"四星级",IF(I356>=22,"三星级","无星级")))">四星级
友善 610 33.00 29.8 28.8 31.2 30.70 =29,"四星级",IF(I357>=22,"三星级","无星级")))">四星级
友善 611 33.40 31.6 28 32 31.25 =29,"四星级",IF(I358>=22,"三星级","无星级")))">四星级
友善 612 31.80 30 29.2 29 30.00 =29,"四星级",IF(I359>=22,"三星级","无星级")))">四星级
友善 617 34.00 30.2 31.4 33 32.15 =29,"四星级",IF(I360>=22,"三星级","无星级")))">五星级
友善 627 31.40 28.6 28.6 31 29.90 =29,"四星级",IF(I361>=22,"三星级","无星级")))">四星级
友善 633 31.00 26.8 28.6 33 29.85 =29,"四星级",IF(I362>=22,"三星级","无星级")))">四星级
友爱 1120 31.83 31.4 30.2 32.5 31.48 =29,"四星级",IF(I363>=22,"三星级","无星级")))">四星级
11土木 4 班 友善 535 34.80 32 32 33 32.95 =29,"四星级",IF(I364>=22,"三星级","无星级")))">五星级
友善 618 33.80 31.4 30.4 33 32.15 =29,"四星级",IF(I365>=22,"三星级","无星级")))">五星级
友善 619 33.40 30.4 31.8 33 32.15 =29,"四星级",IF(I366>=22,"三星级","无星级")))">五星级
友善 620 32.20 29.4 30 31 30.65 =29,"四星级",IF(I367>=22,"三星级","无星级")))">四星级
友善 625 32.20 26.4 29.2 32 29.95 =29,"四星级",IF(I368>=22,"三星级","无星级")))">四星级
友善 626 32.40 30 30.4 31 30.95 =29,"四星级",IF(I369>=22,"三星级","无星级")))">四星级
友善 628 31.20 25.8 27.8 31 28.95 =29,"四星级",IF(I370>=22,"三星级","无星级")))">三星级
友善 633 31.00 26.8 28.4 33 29.80 =29,"四星级",IF(I371>=22,"三星级","无星级")))">四星级
友爱 1120 31.83 31.4 30.2 33 31.61 =29,"四星级",IF(I372>=22,"三星级","无星级")))">四星级
友爱 1006 29.33 30.4 32.8 33.5 31.51 =29,"四星级",IF(I373>=22,"三星级","无星级")))">四星级
12土木 5 班 友善 121 26.6 31.6 35 23.30 =29,"四星级",IF(I374>=22,"三星级","无星级")))">三星级
友善 311 27.60 28.8 30.4 30 29.20 =29,"四星级",IF(I375>=22,"三星级","无星级")))">四星级
友善 312 23.00 21.8 23.4 29.5 24.43 =29,"四星级",IF(I376>=22,"三星级","无星级")))">三星级
友善 317 32.80 29.6 31.4 34 31.95 =29,"四星级",IF(I377>=22,"三星级","无星级")))">四星级
友善 318 33.40 29.8 32 34.5 32.43 =29,"四星级",IF(I378>=22,"三星级","无星级")))">五星级
友善 319 26.60 24.2 28.2 26.5 26.38 =29,"四星级",IF(I379>=22,"三星级","无星级")))">三星级
友善 320 32.60 27.6 29.8 30 30.00 =29,"四星级",IF(I380>=22,"三星级","无星级")))">四星级
友善 325 17.00 17 24.8 29.6 22.10 =29,"四星级",IF(I381>=22,"三星级","无星级")))">三星级
友爱 1129 30.00 29.8 31.6 30.5 30.48 =29,"四星级",IF(I382>=22,"三星级","无星级")))">四星级
辅导员 班级 楼栋 宿舍 2.3月份数 4月份数 5月份数 6月分数 学期分数 学期等级
朱丹青 12财管 1 班 友善 207 31.00 29.8 32.2 32.5 31.38 =29,"四星级",IF(I385>=22,"三星级","无星级")))">四星级
友善 208 30.20 23.2 28.4 31 28.20 =29,"四星级",IF(I386>=22,"三星级","无星级")))">三星级
友爱 501 30.83 30 28.8 33.5 30.78 =29,"四星级",IF(I387>=22,"三星级","无星级")))">四星级
友爱 502 29.17 27.8 32.2 29.5 29.67 =29,"四星级",IF(I388>=22,"三星级","无星级")))">四星级
友爱 503 29.33 30 32 31 30.58 =29,"四星级",IF(I389>=22,"三星级","无星级")))">四星级
友爱 504 28.67 26 30.7 30.5 28.97 =29,"四星级",IF(I390>=22,"三星级","无星级")))">三星级
友爱 604 30.83 28.6 29.6 30.9 29.98 =29,"四星级",IF(I391>=22,"三星级","无星级")))">四星级
友爱 605 30.83 32 30.8 32 31.41 =29,"四星级",IF(I392>=22,"三星级","无星级")))">四星级
友爱 612 30.33 33.2 31.6 33 32.03 =29,"四星级",IF(I393>=22,"三星级","无星级")))">五星级
12财管 2 班 友善 213 29.20 31 31.4 33 31.15 =29,"四星级",IF(I394>=22,"三星级","无星级")))">四星级
友善 214 31.40 28 27.2 32 29.65 =29,"四星级",IF(I395>=22,"三星级","无星级")))">四星级
友爱 509 24.00 30 31.8 32.5 29.58 =29,"四星级",IF(I396>=22,"三星级","无星级")))">四星级
友爱 605 30.83 32 30.8 32 31.41 =29,"四星级",IF(I397>=22,"三星级","无星级")))">四星级
友爱 606 29.83 29 27.2 30.5 29.13 =29,"四星级",IF(I398>=22,"三星级","无星级")))">四星级
友爱 607 30.00 29.6 28.4 32 30.00 =29,"四星级",IF(I399>=22,"三星级","无星级")))">四星级
友爱 609 29.33 30.4 29.6 28.5 29.46 =29,"四星级",IF(I400>=22,"三星级","无星级")))">四星级
友爱 610 31.50 31.6 31.2 32 31.58 =29,"四星级",IF(I401>=22,"三星级","无星级")))">四星级
友爱 611 30.67 30.8 29.2 33.5 31.04 =29,"四星级",IF(I402>=22,"三星级","无星级")))">四星级
12财管 3 班 友善 215 27.40 29.8 20.6 29 26.70 =29,"四星级",IF(I403>=22,"三星级","无星级")))">三星级
友善 216 34.00 31.2 29.4 31.5 31.53 =29,"四星级",IF(I404>=22,"三星级","无星级")))">四星级
友爱 612 32.00 33.2 31.6 32 32.20 =29,"四星级",IF(I405>=22,"三星级","无星级")))">五星级
友爱 613 31.17 32.6 32.2 34 32.49 =29,"四星级",IF(I406>=22,"三星级","无星级")))">五星级
友爱 614 29.83 30.8 30.8 32 30.86 =29,"四星级",IF(I407>=22,"三星级","无星级")))">四星级
友爱 615 28.33 31.6 32 33.5 31.36 =29,"四星级",IF(I408>=22,"三星级","无星级")))">四星级
友爱 616 31.17 34.2 32.6 34.5 33.12 =29,"四星级",IF(I409>=22,"三星级","无星级")))">五星级
友爱 617 30.17 32 31.8 34.5 32.12 =29,"四星级",IF(I410>=22,"三星级","无星级")))">五星级
友爱 1207 29.50 30 30.2 34.5 31.05 =29,"四星级",IF(I411>=22,"三星级","无星级")))">四星级
12财管 4 班 友善 122 23.8 26 33 20.70 =29,"四星级",IF(I412>=22,"三星级","无星级")))">无星级
友善 216 34.00 29.6 30.6 34.5 32.18 =29,"四星级",IF(I413>=22,"三星级","无星级")))">五星级
友善 221 31.20 30.6 27.6 29.5 29.73 =29,"四星级",IF(I414>=22,"三星级","无星级")))">四星级
友爱 618 29.50 28.6 29.8 30 29.48 =29,"四星级",IF(I415>=22,"三星级","无星级")))">四星级
友爱 619 30.00 31.2 30.4 32 30.90 =29,"四星级",IF(I416>=22,"三星级","无星级")))">四星级
友爱 620 31.00 32.6 31.8 32 31.85 =29,"四星级",IF(I417>=22,"三星级","无星级")))">四星级
友爱 621 30.83 31.8 30.8 33.5 31.73 =29,"四星级",IF(I418>=22,"三星级","无星级")))">四星级
友爱 622 29.17 30.4 30.8 32.5 30.72 =29,"四星级",IF(I419>=22,"三星级","无星级")))">四星级
友爱 623 32.17 33.6 31.2 34 32.74 =29,"四星级",IF(I420>=22,"三星级","无星级")))">五星级
12财管 5 班 友善 222 33.00 32.4 30 31.5 31.73 =29,"四星级",IF(I421>=22,"三星级","无星级")))">四星级
友善 223 29.60 21.6 23.6 25.1 24.98 =29,"四星级",IF(I422>=22,"三星级","无星级")))">三星级
友爱 624 30.17 30 30.2 31 30.34 =29,"四星级",IF(I423>=22,"三星级","无星级")))">四星级
友爱 625 26.83 30 28 31.5 29.08 =29,"四星级",IF(I424>=22,"三星级","无星级")))">四星级
友爱 626 26.50 30.2 27.8 30 28.63 =29,"四星级",IF(I425>=22,"三星级","无星级")))">三星级
友爱 627 27.33 26.6 27.4 24.7 26.51 =29,"四星级",IF(I426>=22,"三星级","无星级")))">三星级
友爱 628 30.50 30.4 28 28.5 29.35 =29,"四星级",IF(I427>=22,"三星级","无星级")))">四星级
12财管 6 班 友善 113 28.40 25.4 26.2 20 25.00 =29,"四星级",IF(I428>=22,"三星级","无星级")))">三星级
友善 224 25.60 30 25.4 27 27.00 =29,"四星级",IF(I429>=22,"三星级","无星级")))">三星级
友爱 628 30.50 30.4 28 28.5 29.35 =29,"四星级",IF(I430>=22,"三星级","无星级")))">四星级
友爱 629 30.17 30 28.8 31.5 30.12 =29,"四星级",IF(I431>=22,"三星级","无星级")))">四星级
友爱 630 27.83 28.4 26.8 32.5 28.88 =29,"四星级",IF(I432>=22,"三星级","无星级")))">三星级
友爱 631 31.00 30.4 30.6 31 30.75 =29,"四星级",IF(I433>=22,"三星级","无星级")))">四星级
友爱 632 30.83 30 29.8 30.5 30.28 =29,"四星级",IF(I434>=22,"三星级","无星级")))">四星级
友爱 1307 26.50 32.6 30.2 31.5 30.20 =29,"四星级",IF(I435>=22,"三星级","无星级")))">四星级

版权所有: 开云官网入口app 友善书院 地址: 厦门市集美区孙坂南路1251号 邮编: 361021


技术支持：厦门智小厦信息科技有限公司


Baidu
map