¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯ ¤³¤Î¥Ö¥í¥°¤Ç½ñ¤«¤ì¤Æ¤¤¤ëÆâÍÆ¤Ë´ð¤Å¤¤¤Æºî¤é¤ì¤¿ ¥È¥ì¡¼¥É¥ë¡¼¥ë¸¡¾Ú¡¦ºÇŬ²½¥½¥Õ¥È¤ÎÈÎÇä¤ò³«»Ï¤·¤Þ¤·¤¿¡£ ²Á³Ê¤Ï10500±ß¤Ç¤¹¡£ ¤´¹ØÆþ¤Ï¤³¤Á¤é¤«¤é¤Ç¤¤Þ¤¹¡£ ASP¤Ë¤Ï¥¤¥ó¥Õ¥©¥È¥Ã¥×¤ò»È¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£¥¢¥Õ¥£¥ê¥¨¥¤¥ÈÊó½·¤Ï60¡ó¤È¤·¤Æ¤ª¤ê¤Þ¤¹¤Î¤ÇFX,³ô¼°,Æü·Ð225ÀèʪÅù°·¤¦¥Ö¥í¥°¤äHP¤ò±¿±Ä¤µ¤ì¤Æ¤¤¤ëÊý¤Ï¤â¤·¤è¤í¤·¤±¤ì¤Ð¤³¤Îµ¡²ñ¤ò¤´ÍøÍѤ¯¤À¤µ¤¤¡£ ¤Ê¤ª¥¢¥Õ¥£¥ê¥¨¥¤¥È¤Î¤´ÍøÍѤò´õ˾¤µ¤ì¤ëÊý¤ÇInfotop¤Î¥¢¥Õ¥£¥ê¥¨¥¤¥È¥¢¥«¥¦¥ó¥È¤ò¤ª»ý¤Á¤Ç¤Ê¤¤Êý¤Ï¤³¤Á¤é¤è¤ê¥¢¥Õ¥£¥ê¥¨¥¤¥¿¡¼¤Î¤´ÅÐÏ¿¤¬¤Ç¤¤Þ¤¹¡£ ¥¢¥Õ¥£¥ê¥¨¥¤¥È¥ê¥ó¥¯¤òºîÀ®¤¹¤ëºÝ¡ÖGeneticOptimizer¡×¤Ç¸¡º÷¤·¤Æ¤¯¤À¤µ¤¤¡£ ¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯ ¥Æ¡¼¥Þ:¥·¥¹¥Æ¥à¥È¥ì¡¼¥É - ¥¸¥ã¥ó¥ë:³ô¼°¡¦Åê»ñ¡¦¥Þ¥Í¡¼ ![]() |
¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯ PROM¤ÏÈá´ÑŪ¥ê¥¿¡¼¥ó¤È¤â¸Æ¤Ð¤ì¾Úµò¶â¤ËÂФ¹¤ëǯ¼¡Íø²ó¤ê¤ò¡¢¥·¥¹¥Æ¥à¤Î¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤¬¡Ö¥ê¥¢¥ë¥È¥ì¡¼¥Ç¥£¥ó¥°¤Ç¤Ï¥Æ¥¹¥È»þ¤Û¤ÉÎɤ¯¤Ê¤¤¡×¤È¤¤¤¦Èá´ÑŪ¤ÊÁÛÄê¤Ë´ð¤Å¤¤¤ÆÄ´À°¤·¤¿¤â¤Î¤Ç¡¢¼¡¤Î¤è¤¦¤Ë·×»»¤µ¤ì¤Þ¤¹¡£ PROM¡á¡ÐÊ¿¶ÑÍø±×*(¾¡¤Á¥È¥ì¡¼¥É¿ô¡Ý¢å¾¡¤Á¥È¥ì¡¼¥É¿ô¡Ë¡ÝÊ¿¶Ñ»¼º*(É餱¥È¥ì¡¼¥É¿ô+¢åÉ餱¥È¥ì¡¼¥É¿ô)¡Ñ/¾Úµò¶â ¾¡¤Á¥È¥ì¡¼¥É¿ô¤òɸ½à¸íº¹¤ÇÄ´À°¤·Ä㤯¸«ÀѤâ¤ê¡¢ÁíÍø±×¤òÄ㤤ÃͤËÄ´À°¤·¡¢µÕ¤ËÉ餱¥È¥ì¡¼¥É¿ô¤òɸ½à¸íº¹¤ÇÄ´À°¤·Áí»¼º¤ò¹â¤¤ÃͤËÄ´À°¤¹¤ë¤³¤È¤ÇºÇ°¤Î»öÂÖ¤òÁÛÄꤷ¤Æ¤¤¤ë¤ï¤±¤Ç¤¹¡£ ´ðËÜŪ¤Ë¤Ï¡Ö¤É¤ó¤ÊÍ¥¤ì¤¿¥·¥¹¥Æ¥à¤Ç¤â¥ê¥¢¥ë¥È¥ì¡¼¥É¤Ë¤Ê¤Ã¤¿ÅÓü¡¢É餱¥È¥ì¡¼¥É¤¬Áý¤¨¡¢¾¡¤Á¥È¥ì¡¼¥É¤Ï¸º¤ë¡×¤È¤¤¤¦·Ð¸³Â§¤Ë´ð¤Å¤¤¤Æ¤¤¤ë¤Î¤Ç¤¹¤¬¡¢¤³¤ÎPROM¤Ï¼°¤ò¸«¤Æ¤â¤ï¤«¤ë¤è¤¦¤ËÁíÍø±×¡¢Ê¿¶ÑÍø±×¡¢Ê¿¶Ñ»¼º¡¢Áí»¼º¡¢¾¡¤Á¥È¥ì¡¼¥É¿ô¡¢É餱¥È¥ì¡¼¥É¿ô¤È¤¤¤¦£¶¤Ä¤ÎÍ×ÁǤòÀ¹¤ê¹þ¤ó¤ÀÃͤʤΤǡ¢¥·¥¹¥Æ¥à¤Î͸úÀ¤ò¿Þ¤ë»ØÉ¸¤È¤·¤Æ¤Ïñ¤Ê¤ëÁíÍø±×¤äºÇÂç¥É¥í¡¼¥À¥¦¥ó¤è¤ê¤âÍ¥¤ì¤¿»ØÉ¸¤À¤È¤¤¤¦¤³¤È¤¬¤Ç¤¤ë¤Ç¤·¤ç¤¦¡£ ¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯ ¥Æ¡¼¥Þ:¥·¥¹¥Æ¥à¥È¥ì¡¼¥É - ¥¸¥ã¥ó¥ë:³ô¼°¡¦Åê»ñ¡¦¥Þ¥Í¡¼ ![]() |
¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯ ¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Î͸úÀȽÃÇ¡¢¤Ä¤Þ¤êÅý·×³ØÅª¤ËͰդʥȥ졼¥É¥·¥¹¥Æ¥à¤ò¸«½Ð¤¹¤¿¤á¤Ë¡¢²áµî¤Î¥Ç¡¼¥¿¤Ï¤É¤Î¤¯¤é¤¤É¬ÍפʤΤǤ·¤ç¤¦¤«¡£ ¤¿¤È¤¨¤Ð¡¢°ìǯ´Ö¤Ë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°Ê¾å¤Î¥µ¥ó¥×¥ë¤¬¤¢¤ì¤Ð¡¢¤è¤ê¿¤¯¤Î¥µ¥ó¥×¥ë¤¬¤¢¤ë¤Ë±Û¤·¤¿¤³¤È¤Ï¤Ê¤¤¤¬¡¢°ì±þ¤ÎɬÍ׺ÇÄã¸Â¤Î¥Ç¡¼¥¿¤Ï¤¢¤ë¤È¹Í¤¨¤Æº¹¤·»Ù¤¨¤Ê¤¤¤Ç¤·¤ç¤¦¡£ ¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯ ¥Æ¡¼¥Þ:¥·¥¹¥Æ¥à¥È¥ì¡¼¥É - ¥¸¥ã¥ó¥ë:³ô¼°¡¦Åê»ñ¡¦¥Þ¥Í¡¼ ![]() |
¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯ ¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Î¼ý±×À¤Îɾ²Á´ð½à¤Î°ì¤Ä¤Ë¥â¥Ç¥ë¸úΨ¤¬¤¢¤ê¤Þ¤¹¡£ ¥â¥Ç¥ë¸úΨ¤È¤Ï¥Þ¡¼¥±¥Ã¥È¤ÎÀøºßÅªÍø±×¤ò´ð½à¤Ë¤·¤¿É¾²Á´ð½à¤Ç¤¹¡£ ¥Þ¡¼¥±¥Ã¥È¤ÎÀøºßÍø±×¤È¤Ï¤¹¤Ù¤Æ¤ÎÄìÃͤÇÇ㤤¡¢¤¹¤Ù¤Æ¤ÎÅ·°æ¤ÇÇä¤ë¤³¤È¤¬¤Ç¤¤¿¾ì¹ç¡¢¤Ä¤Þ¤ê¤½¤Î¥Þ¡¼¥±¥Ã¥È¤«¤éÆÀ¤é¤ì¤ëºÇÂç¸Â¤ÎÍø±×¤Ç¤¢¤ë¡£¥â¥Ç¥ë¸úΨ¤Ï¡¢¤³¤ÎÀøºßÅªÍø±×¤ËÂФ¹¤ë¼ý±×À¤ÎÂ礤µ¤ò¬¤ë´ð½à¤Ç¤¹¡£ ¤¿¤È¤¨¤Ð¤¢¤ë¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Îǯ¼¡Íø±×¤¬60Ëü±ß¤Ç¤½¤Î¥Þ¡¼¥±¥Ã¥È¤ÎÀøºßÅªÍø±×¤¬600Ëü±ß¤À¤Ã¤¿¤È¤¹¤ë¤È¥â¥Ç¥ë¸úΨ¤Ï ¥â¥Ç¥ë¸úΨ(%)= 60 / 600 * 100(%)=10% ·Ð¸³Â§¾å¡¢ÀøºßÍø±×¤ò½ªÃÍ¥Ù¡¼¥¹¤Ç·×»»¤·¤¿¾ì¹ç¡Ê¤Ä¤Þ¤ê½ªÃͤÇÀÞ¤ìÀþ¥°¥é¥Õ¤ò½ñ¤¤¤¿¾ì¹ç¤Î¤¹¤Ù¤Æ¤ÎÄì¤ÇÇ㤤¡¢Å·°æ¤ÇÇä¤Ã¤¿¤È¤¡Ë¡¢¤³¤Î¿ô»ú¤¬5¡ó°Ê¾å¤Ç¤¢¤ì¤ÐÁêÅöÍ¥½¨¤Ê¥È¥ì¡¼¥É¥·¥¹¥Æ¥à¤Ç¤¢¤ë¤È¤¤¤¦¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ ¤³¤Î¥â¥Ç¥ë¸úΨ¤Ï¡¢¥¶¥é¾ì¥Ù¡¼¥¹¤Ç·×»»¤¹¤ë¤È¤â¤Ã¤ÈÄ㤤¿ô»ú¤Ë¤Ê¤ë¤¬¡¢¤½¤¦¤·¤¿·Ð¸³Â§¤¬¤¢¤ë°Ê¾åɾ²Á´ð½à¤È¤·¤Æ¤Ï½ªÃÍ¥Ù¡¼¥¹¤òÍѤ¤¤ë¤Î¤¬Îɤ¤¤È¤¤¤¨¤ë¤Ç¤·¤ç¤¦¡£ ¥¨¥¯¥»¥ëÅù¤Ç¤Î¥â¥Ç¥ë¸úΨ¤Î¶ñÂÎŪ¤Ê»»½ÐÊýË¡¤Ï ÁíÍø±×¤ò½ªÃͤÈÁ°Æü½ªÃͤκ¹¤ÎÀäÂÐÃͤÎÁí·×¤Ç½ü¤¹¤³¤È¤Ç·×»»¤Ç¤¤Þ¤¹¡£ EÎó¤Ë½ªÃͤ¬¤¢¤ë¤È¤·¤Æ $F3=ABS($E3-$E2) ¤È¤·¤Æ²¼Êý¤Ë¥³¥Ô¡¼¤·¤Æ ÁíÍø±×/SUM(F3:F*) ¤Ç»»½Ð¤µ¤ì¤Þ¤¹¡£(*:ºÇ½ª¹Ô) ¤Þ¤¿¥¶¥é¾ì¥Ù¡¼¥¹¤Ê¤é¡¢ËèÆü¤Î¥ì¥ó¥¸¡Ê¹âÃͤȰÂÃͤκ¹¡Ë¤Î¹ç·×¤ò·×»»¤¹¤ì¤ÐÎɤ¤¤Î¤Ç¡¢¤Þ¤È¤á¤Æ ÁíÍø±×/SUM(C2:C*)-SUM(D2:D*) ¤È¤¤¤¦¼°¤Ç»»½Ð¤¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ ![]() ¥¹¥Ý¥ó¥µ¡¼¥É¥ê¥ó¥¯ ¥Æ¡¼¥Þ:¥·¥¹¥Æ¥à¥È¥ì¡¼¥É - ¥¸¥ã¥ó¥ë:³ô¼°¡¦Åê»ñ¡¦¥Þ¥Í¡¼ ![]() |
| ¥·¥¹¥Æ¥à¥È¥ì¡¼¥É¤Î¿¹ |
³ô¼°¡¢Æü·Ð225¡¢FX(°ÙÂØ¾Úµò¶â¼è°ú)Åù¤Ç¥·¥¹¥Æ¥à¥È¥ì¡¼¥É¤ò¼Â¸½¤¹¤ë¥Î¥¦¥Ï¥¦¤ò¸ø³«
|
¡¡
|
|
|
|
|
|
|
|
¥×¥í¥Õ¥£¡¼¥ë
|
|
Author:SIGMA
|
|
|
|
Äó·È¥µ¥¤¥È
|
|
FX
|
|
|
|
·îÊÌ¥¢¡¼¥«¥¤¥Ö
|
|
|
|
|
|
By FC2¥Ö¥í¥°
|
|
FC2BLOG
|
|
|
|
¥Ö¥í¥°Æâ¸¡º÷
|
|
|
|
|
|
RSS¥Õ¥£¡¼¥É
|
|
|
|
|