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

[¤À¨É] Excel ¹A¾ä»P°ê¾ä ¸U¦~¾ä

¦^´_ 20# sunnyso
ÁÂÁ§A¡A¨º¤T²Õ Function §Ú·|¥hºCºC®ø¤Æªº¡A
Idea «D±`´Î¡A¬O§A¥»¨­ Coding ªº¶Ü¡H
¹ê¦b¬O«Ü´Îªº³Ð·N¡I

TOP

¦^´_ 19# c_c_lai

¦]爲¬Ýº|¤Fmyleoyes´£¥Xªº²Ä¤G­Ó¿ù»~ÂI ¡§¹A¾ä5¤ë¦³30¤Ñ (°ê¾ä7¤ë7¤é)¡§, ©Ò¥H§@²Ä¤G¦¸­×§ï

B5500D2 -> A5500D2 -> AD500D2

²Ä¤@¦ì¡]1~4¤ë¡^ B = 1001 ²Ä¥|¦ì¥Nªí ¥|¤ë¦pªG29 ¤é À³爲 0 ©Ò¥H§ï爲 1000 = A
²Ä¤G¦ì¡]5~8¤ë¡^ 5 = 0101 ²Ä¤@¦ì¥Nªí ¤­¤ë¦pªG30¤é À³爲  1 ©Ò¥H§ï爲 1101 = D
ss

TOP

¦^´_ 22# sunnyso
§Ú¤w±N¥¦µù°O¦bµ{¦¡½Xªº³Æµù¸Ì¡A·PÁ§A¡I
³o¦³ÂI¹³ Bit ^ onOff ªº³B­ù¡A¥H©¹¦b¾³õ®É¤]±`À³¥Î Bit Shift
ªº­ì²z¨Ó³B²zºX¼Ð±±ºÞ (C»y¨¥)¡C
«e¤T½X¬O 1~4¤ë¡B5~8¤ë¡B9~12¤ë ªº¤é¼Æ©w¸q (0 ¥Nªí 29¡B1 ¥Nªí 30)
¨º»ò¦A½Ð±Ð¡A ¨º«á¥|½X (00D2) ¥Nªíªº·N¸q©O¡H

TOP

¦^´_ 23# c_c_lai

³Ì«á4¦ì¬°·í¦~¹A¾ä·s¦~ªº¦è¾ä¤é´Á¡A¦p0131¥Nªí1¤ë31¤é¡F·í§@¼Æ­ÈÂà¤Q¤»¶i¦ì(6-7¦ì)

¹A¾ä·s¦~ªº¦è¾ä¤é´Á¡A¦p0131¥Nªí1¤ë31¤é¡F·í§@¼Æ­ÈÂà¤Q¤»¶i¦ì(6-7¦ì)

2013-2-10¬O¦~ªì¤@ 0210 = D2
ss

TOP

¦^´_ 16# sunnyso
«e½ú!¨¯­WÅo!!ÁÂÁÂ!!
     ­ì¥»ªººÃ´b?¥Ñc_c_lai«e½ú!¥N³Ò´£¥X
     ¯uªº«D±`·P¿E¸ÔºÉ¸Ñ»¡ÁÂÁ¦A¤T!!

TOP

¦^´_ 24# sunnyso
«D±`·P¿E§A¸ÔºÉ¦a¸Ñ»¡¡A¦hÁ¡C
±µ¤U¨Ó´N­nºÝ¬Ý§Ú­Ì¦Û­Ó¨àªº¥\¤O¥h¬ãŪ¤F¡A
¦A¤T¨¥Á¤F¡I

TOP

·s¤HµLÅv¤U¸ü, ¨£¹Ï¦ü¥G·|ªí¥Ü¦~¤z, ·Q½Ð°Ý¥¼ª¾¦~¤z·|§_¸òÀH¥ß¬K«e«á¦Ó¦Û°Ê§ó§ï©O?

TOP

¦^´_ 27# carbonise

¦n¦nÀx¤À§a,¥[ªo®@
ss

TOP

Looking Ahead on Request
¡uWish you all the best¡v Thanks a lot and Have a Nice Day¡I¡I
¡ø(^£s^)¡ù
Best Regards

TOP

·s¤HµLÅv¤U¸ü, ¦n¹³¤£¿ù¥Î
DI

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD