绿标
- 注册时间
- 2011-2-18
- 最后登录
- 2012-4-9
|
楼主 |
发表于 2011-4-18 07:48:37
|
显示全部楼层
回复 19# 蓝刃 的帖子
感谢蓝刃兄的整理,说实话,我excel用得不熟,第二排的下拉很方便!(我自己都是导入到数据库中,用SQL查 )
兄弟所说评分的星级,是指的把那些对星级的文字描述,替换为友好些的☆么?
实际上,为了好排序,我自己做了一个对应转换
Strength
Extremely Mild 1
Very Mild 1.5
Mild 2
Mild to Medium 2.5
Medium 3
Medium to Strong 3.5
Strong 4
Very Strong 4.5
Extremely Strong 5
Flavoring
None detected 0
Extremely Mild 1
Very Mild 1.5
Mild 2
Mild to Medium 2.5
Medium 3
Medium to Strong 3.5
Strong 4
Very Strong 4.5
Extra Strong 5
Taste
Extremely Mild (Flat) 1
Very Mild 1.5
Mild 2
Mild to Medium 2.5
Medium 3
Medium to Full 3.5
Full 4
Very Full 4.5
Extra Full 5
Overwhelming 5.5
Room Note
Unnoticeable 0
Very Pleasant 1.5
Pleasant 2
Pleasant to Tolerable 2.5
Tolerable 3
Tolerable to Strong 3.5
Strong 4
Very Strong 4.5
Overwhelming 5.5
Recommendation
Highly Recommended 4
Recommended 3
Somewhat Recommended 2
Not Recommended 1
最后这个就是总的评分星级吧?(由于怕误解,所以我没有发布转换后的xls) |
|