PROM(Èá´ÑŪ¥ê¥¿¡¼¥ó¡Ë

¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯


PROM¤ÏÈá´ÑŪ¥ê¥¿¡¼¥ó¤È¤â¸Æ¤Ð¤ì¾Úµò¶â¤ËÂФ¹¤ëǯ¼¡Íø²ó¤ê¤ò¡¢¥·¥¹¥Æ¥à¤Î¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤¬¡Ö¥ê¥¢¥ë¥È¥ì¡¼¥Ç¥£¥ó¥°¤Ç¤Ï¥Æ¥¹¥È»þ¤Û¤ÉÎɤ¯¤Ê¤¤¡×¤È¤¤¤¦Èá´ÑŪ¤ÊÁÛÄê¤Ë´ð¤Å¤¤¤ÆÄ´À°¤·¤¿¤â¤Î¤Ç¡¢¼¡¤Î¤è¤¦¤Ë·×»»¤µ¤ì¤Þ¤¹¡£

PROM¡á¡ÐÊ¿¶ÑÍø±×*(¾¡¤Á¥È¥ì¡¼¥É¿ô¡Ý¢å¾¡¤Á¥È¥ì¡¼¥É¿ô¡Ë¡ÝÊ¿¶Ñ»¼º*(É餱¥È¥ì¡¼¥É¿ô+¢åÉ餱¥È¥ì¡¼¥É¿ô)¡Ñ/¾Úµò¶â

¾¡¤Á¥È¥ì¡¼¥É¿ô¤òɸ½à¸íº¹¤ÇÄ´À°¤·Ä㤯¸«ÀѤâ¤ê¡¢ÁíÍø±×¤òÄ㤤ÃͤËÄ´À°¤·¡¢µÕ¤ËÉ餱¥È¥ì¡¼¥É¿ô¤òɸ½à¸íº¹¤ÇÄ´À°¤·Áí»¼º¤ò¹â¤¤ÃͤËÄ´À°¤¹¤ë¤³¤È¤ÇºÇ°­¤Î»öÂÖ¤òÁÛÄꤷ¤Æ¤¤¤ë¤ï¤±¤Ç¤¹¡£

´ðËÜŪ¤Ë¤Ï¡Ö¤É¤ó¤ÊÍ¥¤ì¤¿¥·¥¹¥Æ¥à¤Ç¤â¥ê¥¢¥ë¥È¥ì¡¼¥É¤Ë¤Ê¤Ã¤¿ÅÓü¡¢É餱¥È¥ì¡¼¥É¤¬Áý¤¨¡¢¾¡¤Á¥È¥ì¡¼¥É¤Ï¸º¤ë¡×¤È¤¤¤¦·Ð¸³Â§¤Ë´ð¤Å¤¤¤Æ¤¤¤ë¤Î¤Ç¤¹¤¬¡¢¤³¤ÎPROM¤Ï¼°¤ò¸«¤Æ¤â¤ï¤«¤ë¤è¤¦¤ËÁíÍø±×¡¢Ê¿¶ÑÍø±×¡¢Ê¿¶Ñ»¼º¡¢Áí»¼º¡¢¾¡¤Á¥È¥ì¡¼¥É¿ô¡¢É餱¥È¥ì¡¼¥É¿ô¤È¤¤¤¦£¶¤Ä¤ÎÍ×ÁǤòÀ¹¤ê¹þ¤ó¤ÀÃͤʤΤǡ¢¥·¥¹¥Æ¥à¤ÎÍ­¸úÀ­¤ò¿Þ¤ë»ØÉ¸¤È¤·¤Æ¤Ïñ¤Ê¤ëÁíÍø±×¤äºÇÂç¥É¥í¡¼¥À¥¦¥ó¤è¤ê¤âÍ¥¤ì¤¿»ØÉ¸¤À¤È¤¤¤¦¤³¤È¤¬¤Ç¤­¤ë¤Ç¤·¤ç¤¦¡£

¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯


¥Æ¡¼¥Þ:¥·¥¹¥Æ¥à¥È¥ì¡¼¥É - ¥¸¥ã¥ó¥ë:³ô¼°¡¦Åê»ñ¡¦¥Þ¥Í¡¼

¡Ú2008/02/09 06:48¡Û | ¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Îɾ²Á | ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯(0) | ¥³¥á¥ó¥È(2)
¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤ÎÍ­¸úÀ­È½ÃǤËɬÍפʥǡ¼¥¿¤ÎÎÌ

¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯


¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤ÎÍ­¸úÀ­È½ÃÇ¡¢¤Ä¤Þ¤êÅý·×³ØÅª¤ËÍ­°Õ¤Ê¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤ò¸«½Ð¤¹¤¿¤á¤Ë¡¢²áµî¤Î¥Ç¡¼¥¿¤Ï¤É¤Î¤¯¤é¤¤É¬ÍפʤΤǤ·¤ç¤¦¤«¡£

¤¿¤È¤¨¤Ð¡¢°ìǯ´Ö¤Ë2ÅÙ¤·¤«¥È¥ì¡¼¥É¤·¤Ê¤«¤Ã¤¿¥·¥¹¥Æ¥à¤È¡¢°ìǯ´Ö¤Ë200²ó¥È¥ì¡¼¥É¤·¤¿¥·¥¹¥Æ¥à¤ÎÍ­¸úÀ­¤òƱ¤¸Î̤Υǡ¼¥¿¤Ç¿Þ¤ë¤Î¤Ï¸­¤¤¤ä¤êÊý¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¡£2²ó¤Î¥È¥ì¡¼¥É¥µ¥ó¥×¥ë¤Ç²¿¤¬¤ï¤«¤ë¤È¤¤¤¦¤Î¤Ç¤·¤ç¤¦¤«¡£µÕ¤Ë200²ó¤Î¥È¥ì¡¼¥É¥µ¥ó¥×¥ë¤ÎÍ¿¤¨¤ë¾ðÊó¤ÎÎ̤ÏÁêÅö¤Ê¤â¤Î¤Ç¤·¤ç¤¦¡£¤Ä¤Þ¤ê¡¢Í­¸úÀ­È½ÃǤËɬÍפʥǡ¼¥¿¤ÎÎ̤ϰ쳵¤Ë¸À¤¦¤³¤È¤Ï¤Ç¤­¤º¡¢¤½¤ì¤ò¬¤ë¼ÜÅ٤ϥȥ졼¥É¥µ¥ó¥×¥ë¤Î¿ô¤Ç¤¢¤ë¤È¤¤¤¦¤³¤È¤¬¤Ç¤­¤ë¤Ç¤·¤ç¤¦¡£

¤³¤ì¤ÏÅý·×³Ø¤Îɸ½à¸íº¹¤È¤¤¤¦³µÇ°¤Ë¤è¤Ã¤ÆÀâÌÀ¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£

ɸ½à¸íº¹¤Ï¼¡¤Î¼°¤Çɽ¤µ¤ì¤Þ¤¹¡£

ɸ½à¸íº¹¡á£±¡¿¢å£î

¤¿¤È¤¨¤Ð10¤Î¥È¥ì¡¼¥É¥µ¥ó¥×¥ë¤¬¤¢¤Ã¤¿¤È¤¹¤ë¤Èɸ½à¸íº¹¤Ï1¡¿¢å10¢â31.62¤È¤Ê¤êÌó32%¤Ç¤¹¡£

¤³¤ì¤Ï¤¿¤È¤¨¤Ð³Æ¥È¥ì¡¼¥É¤ÎÊ¿¶ÑÍø±×¤¬20000±ß¤À¤Ã¤¿¤È¤¹¤ë¤È20000¡Þ32%¤Ä¤Þ¤ê¡¢¼ÂºÝ¤ÎÊ¿¶ÑÍø±×¤Ï13600±ß¡Á26400±ß¤Î´Ö¤ÎÃͤò¤È¤ë¤È¤¤¤¦¤³¤È¤Ç¤¹¡£¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Îɾ²Á¤È¤¤¤¦»öÊÁ¤ÎÀ­¼Á¾åÁÛÄꤹ¤ëÍø±×¤Ë¤ÏºÇ°­¤Î¥±¡¼¥¹¤Ç¤¢¤ë13600±ß¤òºÎÍѤ¹¤Ù¤­¤Ç¤·¤ç¤¦¡£

¤Þ¤¿¡¢¥È¥ì¡¼¥É¥µ¥ó¥×¥ë¤¬30¡¢50¡¢100¡¢200¤Ç¤¢¤Ã¤¿¾ì¹ç¤Îɸ½à¸íº¹¤ò·×»»¤¹¤ë¤È

30¡§18%

50¡§14%

100¡§10%

200¡§7%

¤³¤Î·ë²Ì¤«¤é¤ï¤«¤ë¤è¤¦¤Ë¡¢¥È¥ì¡¼¥É¥µ¥ó¥×¥ë¤Î¿ô¤¬Â¿¤¤¤Û¤É¡¢É¸½à¸íº¹¤Ï¾®¤µ¤¯¤Ê¤ë¤Î¤Ç¿®ÍêÀ­¤Î¹â¤¤·ë²Ì¤¬ÆÀ¤é¤ì¤ë¤È¤¤¤¨¤Þ¤¹¡£
¥µ¥ó¥×¥ë¿ô¤¬100¤¢¤ì¤Ð¤½¤ÎÊ¿¶ÑÍø±×¤Î¸íº¹¤Ï¡Þ10%¤ÎÈϰϤ˼ý¤Þ¤ë¤Î¤Ç¡¢100¤È¤¤¤¦¿ô¤Ï°ì¤Ä¤ÎÌܰ¤Ǥ¢¤ë¤È¤¤¤¨¤ë¤Ç¤·¤ç¤¦
¤³¤ì°Ê²¼¤Ç¤¢¤ì¤Ð¡¢ÆÀ¤é¤ì¤¿·ë²Ì¤È¼ÂºÝ¤Î¥È¥ì¡¼¥É¤È¤Ç¤ÏÍ­¤ëÄøÅÙÂ礭¤Ê¥Ö¥ì¤¬¤¢¤ë¤³¤È¤ò³Ð¸ç¤·¤Ê¤¯¤Æ¤Ï¤Ê¤é¤Ê¤¤¤Ç¤·¤ç¤¦¡£
µÕ¤Ë100°Ê¾å¤Î¥µ¥ó¥×¥ë¤¬¤¢¤ì¤Ð¡¢¤è¤ê¿¤¯¤Î¥µ¥ó¥×¥ë¤¬¤¢¤ë¤Ë±Û¤·¤¿¤³¤È¤Ï¤Ê¤¤¤¬¡¢°ì±þ¤ÎɬÍ׺ÇÄã¸Â¤Î¥Ç¡¼¥¿¤Ï¤¢¤ë¤È¹Í¤¨¤Æº¹¤·»Ù¤¨¤Ê¤¤¤Ç¤·¤ç¤¦¡£

¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯


¥Æ¡¼¥Þ:¥·¥¹¥Æ¥à¥È¥ì¡¼¥É - ¥¸¥ã¥ó¥ë:³ô¼°¡¦Åê»ñ¡¦¥Þ¥Í¡¼

¡Ú2008/02/08 07:59¡Û | ¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Îɾ²Á | ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯(0) | ¥³¥á¥ó¥È(0)
¥â¥Ç¥ë¸úΨ

¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯


¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Î¼ý±×À­¤Îɾ²Á´ð½à¤Î°ì¤Ä¤Ë¥â¥Ç¥ë¸úΨ¤¬¤¢¤ê¤Þ¤¹¡£
¥â¥Ç¥ë¸úΨ¤È¤Ï¥Þ¡¼¥±¥Ã¥È¤ÎÀøºßÅªÍø±×¤ò´ð½à¤Ë¤·¤¿É¾²Á´ð½à¤Ç¤¹¡£
¥Þ¡¼¥±¥Ã¥È¤ÎÀøºßÍø±×¤È¤Ï¤¹¤Ù¤Æ¤ÎÄìÃͤÇÇ㤤¡¢¤¹¤Ù¤Æ¤ÎÅ·°æ¤ÇÇä¤ë¤³¤È¤¬¤Ç¤­¤¿¾ì¹ç¡¢¤Ä¤Þ¤ê¤½¤Î¥Þ¡¼¥±¥Ã¥È¤«¤éÆÀ¤é¤ì¤ëºÇÂç¸Â¤ÎÍø±×¤Ç¤¢¤ë¡£¥â¥Ç¥ë¸úΨ¤Ï¡¢¤³¤ÎÀøºßÅªÍø±×¤ËÂФ¹¤ë¼ý±×À­¤ÎÂ礭¤µ¤ò¬¤ë´ð½à¤Ç¤¹¡£

¤¿¤È¤¨¤Ð¤¢¤ë¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Îǯ¼¡Íø±×¤¬60Ëü±ß¤Ç¤½¤Î¥Þ¡¼¥±¥Ã¥È¤ÎÀøºßÅªÍø±×¤¬600Ëü±ß¤À¤Ã¤¿¤È¤¹¤ë¤È¥â¥Ç¥ë¸úΨ¤Ï

¥â¥Ç¥ë¸úΨ(%)= 60 / 600 * 100(%)=10%

·Ð¸³Â§¾å¡¢ÀøºßÍø±×¤ò½ªÃÍ¥Ù¡¼¥¹¤Ç·×»»¤·¤¿¾ì¹ç¡Ê¤Ä¤Þ¤ê½ªÃͤÇÀÞ¤ìÀþ¥°¥é¥Õ¤ò½ñ¤¤¤¿¾ì¹ç¤Î¤¹¤Ù¤Æ¤ÎÄì¤ÇÇ㤤¡¢Å·°æ¤ÇÇä¤Ã¤¿¤È¤­¡Ë¡¢¤³¤Î¿ô»ú¤¬5¡ó°Ê¾å¤Ç¤¢¤ì¤ÐÁêÅöÍ¥½¨¤Ê¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Ç¤¢¤ë¤È¤¤¤¦¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£

¤³¤Î¥â¥Ç¥ë¸úΨ¤Ï¡¢¥¶¥é¾ì¥Ù¡¼¥¹¤Ç·×»»¤¹¤ë¤È¤â¤Ã¤ÈÄ㤤¿ô»ú¤Ë¤Ê¤ë¤¬¡¢¤½¤¦¤·¤¿·Ð¸³Â§¤¬¤¢¤ë°Ê¾åɾ²Á´ð½à¤È¤·¤Æ¤Ï½ªÃÍ¥Ù¡¼¥¹¤òÍѤ¤¤ë¤Î¤¬Îɤ¤¤È¤¤¤¨¤ë¤Ç¤·¤ç¤¦¡£

¥¨¥¯¥»¥ëÅù¤Ç¤Î¥â¥Ç¥ë¸úΨ¤Î¶ñÂÎŪ¤Ê»»½ÐÊýË¡¤Ï

ÁíÍø±×¤ò½ªÃͤÈÁ°Æü½ªÃͤκ¹¤ÎÀäÂÐÃͤÎÁí·×¤Ç½ü¤¹¤³¤È¤Ç·×»»¤Ç¤­¤Þ¤¹¡£

EÎó¤Ë½ªÃͤ¬¤¢¤ë¤È¤·¤Æ

$F3=ABS($E3-$E2)
¤È¤·¤Æ²¼Êý¤Ë¥³¥Ô¡¼¤·¤Æ

ÁíÍø±×/SUM(F3:F*)
¤Ç»»½Ð¤µ¤ì¤Þ¤¹¡£(*:ºÇ½ª¹Ô)

¤Þ¤¿¥¶¥é¾ì¥Ù¡¼¥¹¤Ê¤é¡¢ËèÆü¤Î¥ì¥ó¥¸¡Ê¹âÃͤȰÂÃͤκ¹¡Ë¤Î¹ç·×¤ò·×»»¤¹¤ì¤ÐÎɤ¤¤Î¤Ç¡¢¤Þ¤È¤á¤Æ

ÁíÍø±×/SUM(C2:C*)-SUM(D2:D*)
¤È¤¤¤¦¼°¤Ç»»½Ð¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£

ÀøºßÍø±×

¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯


¥Æ¡¼¥Þ:¥·¥¹¥Æ¥à¥È¥ì¡¼¥É - ¥¸¥ã¥ó¥ë:³ô¼°¡¦Åê»ñ¡¦¥Þ¥Í¡¼

¡Ú2008/02/07 16:14¡Û | ¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Îɾ²Á | ¥È¥é¥Ã¥¯¥Ð¥Ã¥¯(0) | ¥³¥á¥ó¥È(0)
¥·¥¹¥Æ¥à¥È¥ì¡¼¥É¤Î¿¹


³ô¼°¡¢Æü·Ð225¡¢FX(°ÙÂØ¾Úµò¶â¼è°ú)Åù¤Ç¥·¥¹¥Æ¥à¥È¥ì¡¼¥É¤ò¼Â¸½¤¹¤ë¥Î¥¦¥Ï¥¦¤ò¸ø³«

¡¡

Åö¥µ¥¤¥È¤«¤éÃÂÀ¸¡ª¡ª
ÇäÇ㥷¥¹¥Æ¥à¹½ÃÛ¤Î
¿·¥¹¥¿¥ó¥À¡¼¥É¡ª

¥È¥ì¡¼¥É¥·¥¹¥Æ¥à
¹â®¸¡¾Ú¡¦ºÇŬ²½¥½¥Õ¥È
GeneticOptimizer

¥×¥í¥Õ¥£¡¼¥ë

Author:SIGMA
ǧÄê¥Æ¥¯¥Ë¥«¥ë¥¢¥Ê¥ê¥¹¥È(CMTA)
¥½¥Õ¥È¥¦¥§¥¢³«È¯²ñ¼Ò·Ð±Ä

Äó·È¥µ¥¤¥È

FX






¸÷¥¤¥ó¥¿¡¼¥Í¥Ã¥È




¹â®̵Àþ¥¤¥ó¥¿¡¼¥Í¥Ã¥È


ÌÙ¤«¤ë¥¤¥ó¥¿¡¼¥Í¥Ã¥È¥«¥Õ¥§·Ð±Ä


Javaµ»½Ñ¼Ô¤Îµá¿Í
¡¡

Í»»ñ


»ëÎϲóÉü


ºÇÂ磸£°GB¤Î¥ì¥ó¥¿¥ë¥µ¡¼¥Ð¡¼

ºÇ¶á¤Îµ­»ö

¥«¥Æ¥´¥ê¡¼

·îÊÌ¥¢¡¼¥«¥¤¥Ö

¥ê¥ó¥¯

¥ê¥ó¥¯¤·¤Æ¤¤¤¿¤À¤¤¤¿¾ì¹ç¥¢¥¯¥»¥¹²òÀϤˤƤ³¤Á¤é¤«¤é¤â¥ê¥ó¥¯¤¤¤¿¤·¤Þ¤¹¡£

¤³¤Î¥Ö¥í¥°¤ò¥ê¥ó¥¯¤ËÄɲ乤ë

By FC2¥Ö¥í¥°

FC2BLOG

Æü·ÐÊ¿¶ÑÀèʪ¤Î¼«Æ°ÇäÇã¤Ï¥³¥Á¥é
VT¥È¥ì¡¼¥À¡¼¤ò»ÈÍѤ·¤¿¼«Æ°ÇäÇ㥽¥Õ¥È

¥Ö¥í¥°Æâ¸¡º÷

 

RSS¥Õ¥£¡¼¥É