{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["各系总分","各系卫生得分","各系出勤得分"],"read":"whole","date_system":"1900"}

{"sheet":"各系总分","index":0,"n_rows":14,"n_cols":9,"rows_kept":14,"merged":[[0,0,0,8]]}
["邯郸科技职业学院先进班集体评分测评表"]
["   项目\n\n\n班级","总分\n（100分）","出勤（25分）\n出勤率×25\n","卫生\n（25分）\n卫生评比得分的平均值×25%","活动\n（16分）\n根据提供的活动相关证书等佐证材料（系以上），个人加1分；班级加5分。加满为止","荣誉加分\n（6分）\n好人好事、校外荣誉。提供可考的证明，每人每次加1分。","主题班会\n（16分）\n每提供一次主题班会佐证材料（含讲稿、文字、图片或视频），加1分。","疫情防控\n（12分）\n按时填报疫情防控日报表，每次0.1分。","违纪\n（扣分，上不封顶。被系以上通报批评1分、警告2分、严重警告3分、记过4分、留校查看10分）"]
["财经系20级会计管理3班",{"$f":"SUM(C3:I3)","v":{"v":96.420376984127,"d":"96.42"}},{"v":24.1048214285714,"d":"24.10"},{"v":22.3155555555556,"d":"22.32"},{"v":16,"d":"16.00"},{"v":6,"d":"6.00"},{"v":16,"d":"16.00"},{"v":12,"d":"12.00"}]
["医药卫生20级护理5班",{"$f":"SUM(C4:I4)","v":{"v":92.2403075396825,"d":"92.24"}},{"v":21.3325297619048,"d":"21.33"},{"v":20.9077777777778,"d":"20.91"},{"v":16,"d":"16.00"},{"v":6,"d":"6.00"},{"v":16,"d":"16.00"},{"v":12,"d":"12.00"}]
["电子信息系20级物联网2班",{"$f":"SUM(C5:I5)","v":{"v":85.406484962406,"d":"85.41"}},{"v":16.603984962406,"d":"16.60"},{"v":18.8025,"d":"18.80"},{"v":16,"d":"16.00"},{"v":6,"d":"6.00"},{"v":16,"d":"16.00"},{"v":12,"d":"12.00"}]
["农牧系20级畜牧兽医1班",{"$f":"SUM(C6:I6)","v":{"v":83.491561461794,"d":"83.49"}},{"v":12.631561461794,"d":"12.63"},20.86,{"v":16,"d":"16.00"},{"v":6,"d":"6.00"},{"v":16,"d":"16.00"},{"v":12,"d":"12.00"}]
["计算机系20级计算机应用技术1班",{"$f":"SUM(C7:I7)","v":77.78},{"v":13.96875,"d":"13.97"},{"v":19.81125,"d":"19.81"},{"v":16,"d":"16.00"},{"v":6,"d":"6.00"},{"v":10,"d":"10.00"},{"v":12,"d":"12.00"}]
[null,{"$f":"SUM(C8:I8)","v":0}]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]

{"sheet":"各系卫生得分","index":1,"n_rows":47,"n_cols":31,"rows_kept":47,"merged":[[1,0,10,0],[11,0,18,0],[19,0,28,0],[29,0,37,0],[38,0,46,0]]}
[null,"班级","楼号","宿\n舍\n号","2021/\n10/15","2021/\n10/18","2021/\n10/20","2021/\n10/22","2021/\n10/25","2021/\n10/27","2021/\n10/29","2021/\n11/1","2021/\n11/3","2021/\n11/5","2021/\n11/8","2021/\n11/10","2021/\n11/12","2021/\n11/15","2021/\n11/17","2021/\n11/19","2021/\n11/22","2021/\n11/24","2021/\n11/26","2021/\n11/29","2021/\n12/1","2021/\n12/3","2021/\n12/6","2021/\n12/8","2021/\n12/9","平均值","评比结果"]
["财经系20级会计管理3班","会计3班（2020级）",6,420,100,100,95,98,96,96,96,97,98,98,97,96,95,98,97,95,93,95,97,97,94,96,96,93,95,96.32,"文明宿舍"]
[null,"会计3班（2020级）",6,413,100,98,97,94,92,92,92,92,90,93,91,93,90,90,89,90,89,89,93,90,90,90,93,91,94,92.08,"文明宿舍"]
[null,"会计3班（2020级）",6,417,100,97,97,93,92,92,93,90,90,92,91,94,90,90,92,90,91,89,90,89,90,93,90,92,93,92,"文明宿舍"]
[null,"会计3班（2020级）",6,414,95,97,96,93,92,93,93,92,90,93,90,93,90,91,91,90,90,89,90,89,90,90,91,92,94,91.76,"文明宿舍"]
[null,"会计3班（2020级）",6,415,100,98,97,92,90,93,92,90,90,92,93,91,90,91,90,89,89,90,89,88,89,94,92,90,92,91.64,"文明宿舍"]
[null,"会计3班（2020级）",6,416,80,99,97,93,93,92,92,91,91,93,93,92,90,90,89,90,89,89,90,90,89,90,91,90,93,91.04,"文明宿舍"]
[null,"会计3班（2020级）",6,418,0,97,98,93,91,92,92,90,90,93,90,92,90,95,92,90,89,90,89,90,89,92,92,91,92,87.96,"五星级宿舍"]
[null,"会计2/3班（2020级）",1,432,71,67,72,70,71,80,88,85,83,83,83,87,87,72,86,87,87,86,86,86,85,86,86,87,91,82.08,"四星级宿舍"]
[null,"会计3班（2020级）",1,431,75,67,66,74,65,80,82,67,72,72,72,82,82,83,84,85,83,83,83,83,82,84,85,82,89,78.48,"三星级宿舍"]
[{"$nulls":28},"平均值",{"$f":"SUM(AD2:AD10)/9","v":89.2622222222222}]
["农牧系20级畜牧兽医1班","畜牧1班(2020级)",6,516,87,80,85,88,87,82,83,88,86,88,85,89,89,87,83,84,85,84,88,87,88,88,88,85,91,86.2,"五星级宿舍"]
[null,"畜牧1班(2020级)",1,532,83,71,84,84,86,83,83,88,80,73,84,90,86,86,89,82,89,90,87,86,90,89,85,87,96,85.24,"四星级宿舍"]
[null,"畜牧1/2班（2020级）",6,518,68,80,85,93,90,66,83,89,87,85,84,89,87,87,87,81,86,84,82,86,87,80,87,89,92,84.56,"四星级宿舍"]
[null,"畜牧1班(2020级)",6,517,64,73,75,90,87,84,82,85,82,85,86,88,87,84,78,82,82,85,86,82,86,71,87,88,90,82.76,"四星级宿舍"]
[null,"畜牧1班(2020级)",1,531,84,64,84,84,85,81,83,88,81,68,77,84,85,78,86,84,80,86,86,83,87,87,83,85,92,82.6,"四星级宿舍"]
[null,"畜牧1班(2020级)",1,519,85,82,83,65,81,87,90,84,84,72,80,85,81,70,85,81,76,85,85,82,86,79,82,85,91,81.84,"四星级宿舍"]
[null,"畜牧1/2班（2020级）",1,520,82,71,87,65,79,88,89,65,84,77,79,87,83,81,82,82,77,82,82,82,83,78,82,84,91,80.88,"三星级宿舍"]
[{"$nulls":28},"平均值",{"$f":"SUM(AD12:AD18)/7","v":83.44}]
["医药卫生20级护理5班","护理5班（2020级）",5,507,85,88,89,88,83,84,86,86,84,65,87,88,87,89,88,89,88,89,90,87,90,88,88,90,91,86.68,"五星级宿舍"]
[null,"护理5班（2020级）",5,503,86,87,87,87,86,83,87,88,85,65,88,85,80,78,88,87,90,90,87,90,90,86,90,90,89,85.96,"四星级宿舍"]
[null,"护理5班（2020级）",5,506,83,88,89,88,86,83,84,84,87,56,89,90,85,88,86,90,89,88,90,86,86,78,88,91,88,85.6,"四星级宿舍"]
[null,"护理5班（2020级）",1,329,83,87,83,85,85,88,86,89,82,84,68,90,89,89,89,86,89,85,83,86,82,82,85,81,89,85,"四星级宿舍"]
[null,"护理5班（2020级）",5,504,83,86,0,86,85,83,89,88,87,87,88,93,80,87,87,89,93,90,91,90,89,85,90,90,88,84.16,"四星级宿舍"]
[null,"护理5/6班（2020级）",1,332,81,84,85,84,84,86,89,86,86,83,81,86,83,86,85,85,85,83,84,84,84,82,82,81,81,84,"四星级宿舍"]
[null,"护理5班（2020级）",5,508,83,80,90,86,83,84,85,85,83,71,87,89,86,80,78,89,86,87,72,89,84,55,70,84,86,82.08,"四星级宿舍"]
[null,"护理5班（2020级）",5,505,85,87,87,87,86,83,85,79,83,57,83,86,87,82,87,87,82,85,87,75,86,67,85,82,25,80.2,"三星级宿舍"]
[null,"护理5班（2020级）",1,330,84,84,87,85,86,88,87,79,83,83,78,85,84,85,85,85,78,61,82,81,82,0,82,80,81,79,"三星级宿舍"]
[{"$nulls":28},"平均值",{"$f":"SUM(AD20:AD28)/9","v":83.6311111111111}]
["电子信息系20级物联网2班","物联网2班（2020级）",7,413,95,88,94,95,95,93,92,70,79,86,91,93,94,95,95,95,95,95,95,95,95,95,94,95,100,92.36,"文明宿舍"]
[null,"物联网2班（2020级）",7,412,93,84,92,90,93,89,89,59,84,88,88,90,91,87,87,87,80,85,85,85,85,85,85,85,98,86.56,"五星级宿舍"]
[null,"物联网2班（2020级）",4,525,60,86,67,60,68,72,66,50,60,67,73,71,71,82,74,92,77,74,77,82,81,81,79,88,91,73.96]
[null,"物联网2班（2020级）",4,530,72,74,53,80,66,66,60,47,55,64,83,72,64,83,75,91,78,75,74,81,78,78,80,89,91,73.16]
[null,"物联网2班（2020级）",4,529,57,57,62,49,71,71,57,35,60,60,79,72,64,83,64,90,84,61,72,79,76,77,79,86,94,69.56]
[null,"物联网2班（2020级）",4,528,63,55,46,74,68,46,61,54,59,61,72,70,63,82,70,93,82,63,70,80,74,69,79,87,96,69.48]
[null,"物联网2班（2020级）",4,526,59,80,0,59,72,67,62,58,59,60,69,70,64,83,68,89,83,70,71,78,75,75,78,87,90,69.04]
[null,"物联网2班（2020级）",4,527,67,50,34,57,67,46,59,58,60,61,74,70,52,81,67,87,78,70,75,77,79,73,77,81,89,67.56]
[{"$nulls":28},"平均值",{"$f":"SUM(AD30:AD37)/8","v":75.21}]
["计算机系20级计算机应用技术1班","计算1班（2020级）",5,611,94,90,92,88,88,84,87,86,89,87,65,86,92,87,94,94,91,93,93,91,88,93,93,94,93,89.28,"五星级宿舍"]
[null,"计算1班（2020级）",5,610,93,90,90,86,86,78,77,77,76,81,64,84,87,94,87,85,84,86,79,79,85,87,88,88,76,83.48,"四星级宿舍"]
[null,"计算1班（2020级）",3,505,76,90,86,85,84,81,77,77,79,81,77,76,81,81,79,83,85,85,86,82,83,85,84,85,90,82.32,"四星级宿舍"]
[null,"计算1班（2020级）",3,501,72,85,77,82,84,51,81,80,78,78,76,69,74,72,78,81,81,82,81,79,79,81,79,80,90,78,"三星级宿舍"]
[null,"计算1班（2020级）",3,502,70,81,76,81,82,48,75,74,78,77,73,69,77,76,79,78,79,77,80,80,76,79,76,76,87,76.16,"三星级宿舍"]
[null,"计算1班（2020级）",3,504,71,85,71,77,80,79,74,73,70,75,64,74,81,72,77,77,76,75,80,74,78,76,79,78,87,76.12,"三星级宿舍"]
[null,"计算1班（2020级）",3,503,74,82,75,82,81,52,66,54,72,73,68,74,76,79,68,81,81,77,79,81,78,81,82,77,85,75.12]
[null,"计算1班（2020级）",3,506,71,81,78,77,79,51,68,73,71,74,72,79,73,72,75,38,75,76,79,79,76,75,77,81,87,73.48]
[{"$nulls":28},"平均值",{"$f":"SUM(AD39:AD46)/8","v":79.245}]

{"sheet":"各系出勤得分","index":2,"n_rows":7,"n_cols":18,"rows_kept":7,"merged":[[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[0,11,0,12],[0,13,0,14],[0,15,0,16],[0,17,1,17]]}
[null,"2021年10月11日-15日",null,"2021年10月17日- 22日",null,"2021年10月24日- 30日",null,"2021年10月31日- 11月5日",null,"2021年11月7日- 12日",null,"2021年11月14日-19日",null,"2021年11月21日-26日",null,"2021年11月28日-12月4日",null,"总出勤率"]
[null,"早操出勤率","晚自习出勤率","早操出勤率","晚自习出勤率","早操出勤率","晚自习出勤率","早操出勤率","晚自习出勤率","早操出勤率","晚自习出勤率","早操出勤率","晚自习出勤率","早操出勤率","晚自习出勤率","早操出勤率","晚自习出勤率"]
["财经系20级会计管理3班",null,{"v":1,"d":"100.00%"},{"v":0.9574,"d":"95.74%"},{"v":0.9957,"d":"99.57%"},{"v":0.9415,"d":"94.15%"},{"v":0.9787,"d":"97.87%"},{"v":0.9362,"d":"93.62%"},{"v":0.9531,"d":"95.31%"},null,{"v":0.9021,"d":"90.21%"},{"v":0.9362,"d":"93.62%"},{"v":0.9744,"d":"97.44%"},{"v":0.966,"d":"96.60%"},{"v":0.9617,"d":"96.17%"},{"v":1,"d":"100.00%"},{"v":0.9957,"d":"99.57%"},{"$f":"SUM(B3:Q3)/14","v":{"v":0.964192857142857,"d":"96.42%"}}]
["农牧系20级畜牧兽医1班",null,{"v":0.6977,"d":"69.77%"},{"v":0,"d":"0.00%"},{"v":0.6047,"d":"60.47%"},{"v":0.1163,"d":"11.63%"},{"v":0.7023,"d":"70.23%"},{"v":0.2093,"d":"20.93%"},{"v":0.6791,"d":"67.91%"},null,{"v":0.695,"d":"69.50%"},{"v":0.4031,"d":"40.31%"},{"v":0.7209,"d":"72.09%"},{"v":0.3581,"d":"35.81%"},{"v":0.7395,"d":"73.95%"},{"v":0.436046511627907,"d":"43.60%"},{"v":0.711627906976744,"d":"71.16%"},{"$f":"SUM(B4:Q4)/14","v":{"v":0.505262458471761,"d":"50.53%"}}]
["医药卫生20级护理5班",null,{"v":1,"d":"100.00%"},{"v":0.6,"d":"60.00%"},{"v":1,"d":"100.00%"},{"v":0.2083,"d":"20.83%"},{"v":0.9333,"d":"93.33%"},{"v":1,"d":"100.00%"},{"v":1,"d":"100.00%"},null,{"v":0.93,"d":"93.00%"},{"v":1,"d":"100.00%"},{"v":0.66,"d":"66.00%"},{"v":0.8042,"d":"80.42%"},{"v":1,"d":"100.00%"},{"v":0.90625,"d":"90.63%"},{"v":0.904166666666667,"d":"90.42%"},{"$f":"SUM(B5:Q5)/14","v":{"v":0.85330119047619,"d":"85.33%"}}]
["电子信息系20级物联网2班",null,{"v":1,"d":"100.00%"},{"v":1,"d":"100.00%"},{"v":0.9947,"d":"99.47%"},{"v":0.4803,"d":"48.03%"},{"v":0.3895,"d":"38.95%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,{"v":1,"d":"100.00%"},{"v":0.7456,"d":"74.56%"},{"v":1,"d":"100.00%"},{"v":0.4263,"d":"42.63%"},{"v":0.6842,"d":"68.42%"},{"v":0.809210526315789,"d":"80.92%"},{"v":0.768421052631579,"d":"76.84%"},{"$f":"SUM(B6:Q6)/14","v":{"v":0.664159398496241,"d":"66.42%"}}]
["计算机系20级计算机应用技术1班",null,{"v":0.9318,"d":"93.18%"},{"v":0.1273,"d":"12.73%"},{"v":0.8955,"d":"89.55%"},{"v":0,"d":"0.00%"},{"v":0.7955,"d":"79.55%"},{"v":0,"d":"0.00%"},{"v":0.8954,"d":"89.54%"},null,{"v":0.8772,"d":"87.72%"},{"v":0.3182,"d":"31.82%"},{"v":0.8045,"d":"80.45%"},{"v":0.4227,"d":"42.27%"},{"v":0.7181,"d":"71.81%"},{"v":0.2273,"d":"22.73%"},{"v":0.809,"d":"80.90%"},{"$f":"SUM(B7:Q7)/14","v":{"v":0.55875,"d":"55.88%"}}]