ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ±Æ¦W¤Î¥­§¡¤À°t­È

[µo°Ý] ±Æ¦W¤Î¥­§¡¤À°t­È

¥»©«³Ì«á¥Ñ unicornbo ©ó 2015-2-5 14:09 ½s¿è

½Ð°Ý...
¦pªG±Æ¦W1-10
¦p¦ó¥h¤À°t ³Ì¤j­È2.2~³Ì¤p­È0.5

·Q¤£¥X¤½¦¡±a¶i...
³Â·Ð¤j¤j­ÌÀ°À°¦£~
:'(

¥»©«³Ì«á¥Ñ p212 ©ó 2015-2-5 14:54 ½s¿è

¦^´_ 1# unicornbo
°²³]raw data¦ì©óA1:A10½d³ò¤º¡A¸g±Æ§Ç«á¥­§¡¤À°t¤©0.5-2.2¤§¶¡¼Æ­È(³Ì¤jraw data¤À°t2.2¡F³Ì¤praw data¤À°t0.5)¡A¸Ó¼Æ­È¨ú¦Ü¤pÂI«á¤@¦ì¡C
Àx¦s®æB1¿é¤J¤½¦¡
=ROUND((10-RANK($A1,$A$1:$A$10))*((2.2-0.5)/9)+0.5,1)
¦V¤U½Æ»s¤½¦¡
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212

·PÁ¤j¤j¦^ÂÐ^^
¤£¹L¦n¹³ÄA­Ë¤F...
²Ä1¦WÀ³¸Ó¬O³Ì¤j­È2.2...(¬O§Ú¨S»¡²M·¡ªü>_<)
2015-02-05_150343.jpg

¬O§_¯à¸ò§Ú¸ÑÄÀ¦¹¤½¦¡©O?
=ROUND((10-RANK(A1,$A$1:$A$10))*((2.2-0.5)/9)+0.5,2)
¦]¬°¦³®É,¦W¦¸¨Ã¤£¤@©w¬O1-10....
¥B±Æ¦C·|¬O¶Ã¼Æ±Æ¦C:¦W¦¸: 1,3,5,4,2

³Â·Ð¤F~~

TOP

¦^´_ 2# p212

·PÁ¤j¤jµ¹ªºÅÞ¿è~
¤w¸g­×§ï¥X¨Ó¤F^^
2015-02-05_153828.jpg
¥u¬O¦pªG¦W¦¸±Æ¦C¬O¶Ã¼Æ®É,À³¸Ó·|¥d¥d XD

ÁÂÁ±z~

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD