Login Register

LiuShen

Joined 2 years ago

LiuShen / 半透明css分享

Last active 4 months ago

设置了部分半透明，不过被注释了，请自行打开

1 0 1

1	/* #card-newest-comments img {border-radius: 10px; /* 设置最新评论圆角半径为10px，可以根据需要调整} */
2
3	/* 说说轮播 */
4	#bber-talk {
5	background: linear-gradient(-45deg, rgba(255, 255, 255, .7),
6	rgba(255, 255, 255, .8),
7	rgba(255, 255, 255, .8),
8	rgba(255, 255, 255, .7));
9	/* backdrop-filter: blur(10px); 应用高斯模糊效果，可以根据需要调整模糊程度 */
10	/* -webkit-backdrop-filter: blur(10px);兼容性前缀，适用于一些旧版本的浏览器 */

LiuShen / 从xlsx获取加权成绩

Last active 4 months ago

将自评，互评，辅导员评分加权取平均，得到最终成绩

0 0 1

1	import openpyxl
2
3	# 定义数据范围
4	data_range = "C5:R39"
5
6	# 定义源文件名称数组
7	source_files = ["./自评总表.xlsx", "./互评总表.xlsx", "./辅导员评分.xlsx", "./最终总表.xlsx"]
8
9	# 打开所有源文件
10	workbooks = [openpyxl.load_workbook(file) for file in source_files]

LiuShen / 多xlsx互评结果中取平均

Last active 4 months ago

将互评的结果，去掉最高，去掉最低，保留中间部分并求平均数

0 0 1

1	import openpyxl
2	import numpy as np
3
4	# 定义数据范围
5	data_range = "C5:R39"
6
7	# 定义源文件名称数组
8	source_files = ["./1.xlsx", "./2.xlsx", "./3.xlsx", "./4.xlsx", "./5.xlsx", "./6.xlsx", "./7.xlsx", "./8.xlsx", "./9.xlsx"]
9
10	# 定义目标文件名称