²òÀâ †
½øʸ·ó¥í¥±¡¼¥·¥ç¥ó †
Ver.1¤È2¤Ç°ã¤¤¤Ï̵¤·
[USER]¤ÎÉôÂâ¤Ï¿Í´Ö³¦¤Ë¿¯¹¶¤·¤¿¡ª
[LIST1_1-1][LIST1_2-2]=IF(=RAND_N(1,1,3)=1,,=IF(=RAND_N(1)=2,[LIST1_3-2],[LIST1_3-2][LIST1_4-3]))[LIST1_5-4]¤Ë¿¯¹¶¤ò»Å³Ý¤±¤ë¡ª
´ðËܥƥ¥¹¥È | [USER]¤ÎÉôÂâ¤Ï¿Í´Ö³¦¤Ë¿¯¹¶¤·¤¿¡ª [LIST1_1-1][LIST1_2-2]=IF(=RAND_N(1,1,3)=1,,=IF(=RAND_N(1)=2,[LIST1_3-2],[LIST1_3-2][LIST1_4-3]))[LIST1_5-4]¤Ë¿¯¹¶¤ò»Å³Ý¤±¤ë¡ª |
| -1 1ʸ»úÌÜ | , | -2 2¡¤3ʸ»úÌÜ | , | -3 4ʸ»úÌÜ | , | -4 ¾ì½ê | LIST1 | ¥¢ | , | ¥¡ | , | ¥¡ | , | ³¹Æ» | ¥¤ | , | ¥¢ | , | ¥¢ | , | ³¹Æ» | ¥¦ | , | ¥£ | , | ¥£ | , | ºÖ | ¥¨ | , | ¥¤ | , | ¥¤ | , | ºÖ | ¥ª | , | ¥¥ | , | ¥¥ | , | ¹Á | ¡¦ ¡¦ ¡¦ | ¥¶ | , | ¥· | , | ¡¼ | , | ¾ë |
- 2¡Á4ʸ»ú¤Î¥«¥¿¥«¥Ê¤ò¥é¥ó¥À¥à¤Ëɽ¼¨¤µ¤»¡¢
³¹Æ»(2/7)¡¦ºÖ(2/7)¡¦¹Á(2/7)¡¦¾ë(1/7)¤ÎÆ⤫¤é°ì¤Ä¥é¥ó¥À¥à¤ËÁª¤Ð¤»¤ë¥Æ¥¥¹¥È
- 1ʸ»úÌܤËÍ褿¤éÉÔ¼«Á³¤Êʸ»ú¤òɽ¼¨¤µ¤»¤Ê¤¤¤è¤¦¤Ë
¤Þ¤¿¡¢¥é¥ó¥À¥à¤È¤Ï¤¤¤¨ÈÜàФÊʸ»úÎ󡢿ͤòÉÔÌû²÷¤Ë¤µ¤»¤«¤Í¤Ê¤¤Ê¸»úÎ󤬺î¤é¤ì¤Ê¤¤¤è¤¦¤ËÆÃÄê¤Îʸ»ú¤Ï¾Ã¤µ¤ì¤Æ¤¤¤ë¡£
[LIST¡»_¡ß-¿ô»ú] †
- ¥ê¥¹¥ÈÆâ¤ÎÃͤò¡Ø,¡Ù¤Ç¶èÀÚ¤ë
¸Æ¤Ó½Ð¤¹ºÝ¤ËÎ㤨¤Ð[LIST1_1-1]¤È¤«[LIST1_1-2]¤È¤¤¤Ã¤¿É÷¤Ë¡Ø-¿ô»ú¡Ù¤òÆþ¤ì¤ë¤È¤½¤ì¤¾¤ì¤ËÂбþ¤·¤¿Ãͤò¸ÄÊ̤˸ƤӽФ»¤ë
ÍøÅÀ¤ÏÆó¤Ä
- 1¡¢¥ê¥¹¥È¤Î°µ½Ì
- LIST¤Ï10¸Ä¤·¤«¤Ê¤¤¤Î¤Ç·ë¹½¤¹¤°¤ËËä¤Þ¤Ã¤Æ¤·¤Þ¤¦
Ãͤοô¤ò·¤¨¤ëɬÍפ¬¤¢¤ë»ö¤È¥ê¥¹¥È¥ª¥×¥·¥ç¥ó¤ò¡Ø»Ä¤¹¡Ù¤Ë¤·¤Ê¤¤¤È·ë²Ì¤¬ÊФ꤬¤Á¤Ë¤Ê¤ë»ö¤¬ÆñÅÀ¤À¤¬¤«¤Ê¤êÍÍÑ
- 2¡¢È½Äê·ë²Ì¤Ë±þ¤¸¤¿¤ª¤Þ¤±¤Îɽ¼¨
- [LIST1_1]¤Ç¡Ø[USER]¤ÏÊõÈ¢¤ò³«¤±¤¿¡ÄÂçÎ̤κâÊõ¤ò¼ê¤ËÆþ¤ì¤¿¡ª,ËÁ¸±¤Ç¼ê¤ËÆþ¤ì¤¿Êõ¤òÇä¤Ã¤Æ¤ß¤ë¤È¶â²ß3000Ëçʬ¤Ë¤Ê¤Ã¤¿¡ª¡Ù¤Èɽ¼¨¤µ¤ì¤ë»þ
[LIST1_1-1]¤ÈÆþÎϤ¹¤ì¤Ð¡Ø[USER]¤ÏÊõÈ¢¤ò³«¤±¤¿¡ÄÂçÎ̤κâÊõ¤ò¼ê¤ËÆþ¤ì¤¿¡ª¡Ù¤Èɽ¼¨¤Ç¤
[LIST1_1-2]¤ÈÆþÎϤ¹¤ì¤Ð¡ØËÁ¸±¤Ç¼ê¤ËÆþ¤ì¤¿Êõ¤òÇä¤Ã¤Æ¤ß¤ë¤È¶â²ß3000Ëçʬ¤Ë¤Ê¤Ã¤¿¡ª¡Ù¤Èɽ¼¨¤Ç¤¤ë
¤Ä¤Þ¤êȽÄê·ë²Ì¤Ë±þ¤¸¤¿¡Ö¤½¤Î¸å¡×¤òÉÁ¤±¤ë¡£
ÃÍ°ì¤ÄÊÕ¤ê300»ú¤È¤¤¤¦À©¸Â¤ËÃí°Õ¤¹¤ë»ö
=IF(,,)´Ø¿ô †
- ¾ò·ï¤òÉÕ¤±¤Æɽ¼¨¤òʬ´ô¤µ¤»¤ë°Ù¤Î´Ø¿ô
=IF(¡Ú¾ò·ï¡Û,¡Ú¿¿¡Û,¡Úµ¶¡Û)¤Ç¹½À®¤µ¤ì¤ë
¡Ú¾ò·ï¡Û¤ÎÃæ¤Ë=AND( , )¤ä=OR( , )¤Ê¤É¤âÆþ¤ì¤ë»ö¤â½ÐÍè¤ë
- [LIST1_1-1][LIST1_2-2]=IF(=RAND_N(1,1,3)=1,,=IF(=RAND_N(1)=2,[LIST1_3-2],[LIST1_3-2][LIST1_4-3]))[LIST1_5-4]¤Ë¿¯¹¶¤ò»Å³Ý¤±¤ë¡ª
- ³µÍ×
- =RAND_N(1,1,3)¤òÍѤ¤¤Æ1¡Á3¤Î¿ô»ú¤òÆâÉô¤ÇȯÀ¸¤µ¤»
1¤Ê¤é2ʸ»ú
2¤Ê¤é3ʸ»ú
3¤Ê¤é4ʸ»ú¤Î¥«¥¿¥«¥Ê¤òȯÀ¸¤µ¤»¤ë
- =IF(=RAND_N(1,1,3)=1,,¡Ú¢¨1¡Û)
- ¡Ú¾ò·ï¡Û¡§=RAND_N(1,1,3)=1Ž¥Ž¥Ž¥1¡Á3¤Î¿ô»ú¤ò¥é¥ó¥À¥à¤ÇȯÀ¸¤µ¤»¡¢¤½¤ì¤¬1¤À¤Ã¤¿»þ¡£¤Ä¤Þ¤ê1/3¤Î³ÎΨ¤Ç
¡Ú¿¿¡Û¡§¶õÇò¡£¤Ä¤Þ¤ê2ʸ»ú
¡Úµ¶¡Û¡§¡Ú¢¨1¡Û
- ¡Ú¢¨1¡Û=IF(=RAND_N(1)=2,[LIST1_3-2],[LIST1_3-2][LIST1_4-3])
- ¡Ú¾ò·ï¡Û¡§=RAND_N(1)=2Ž¥Ž¥Ž¥¾åµ¤ÇȯÀ¸¤µ¤»¤¿¥é¥ó¥À¥à¿ô»ú¤¬2¤À¤Ã¤¿»þ¡£¤Ä¤Þ¤ê1/3¤Î³ÎΨ¤Ç
¡Ú¿¿¡Û¡§[LIST1_3-2]¡£¤Ä¤Þ¤ê3ʸ»ú
¡Úµ¶¡Û¡§[LIST1_3-2][LIST1_4-3]¡£¤Ä¤Þ¤ê4ʸ»ú
¿ÇÃÇÉôʬ°ì¡¢ÆóÀïÌÜ †
Ver.1¤È2¤Ï´ðÁåƥ¥¹¥È¤ÏƱ¤¸¤À¤¬»²¾È¤¹¤ëÉôʬ¤Ë¾¯¡¹°ã¤¤¤¬¤¢¤ë
[LIST2_1-1]
[LIST2_2-1]
´ÉÍý¤·¤ä¤¹¤¯¤¹¤ë°Ù¤Ë¥ê¥¹¥È¤Ï¡Ö_1¡×¤«¤é»ÈÍÑ
´ðÁåƥ¥¹¥È | [LIST2_1-1]
[LIST2_2-1] |
Ver.1 | -1 ¥Æ¥¥¹¥È | , | -2 ¾¡ÇÔ | , | -3 ·ü¾Þ¶â³Û | , | -4 ·®¾Ï | , | -5 ¤½¤Î¾ | LIST2 | °ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ªÂçÎ̤βÐÌôÇúȯ¤¹¤ë¡ª[BR]¤À¤¬[USER]¤Ï¤³¤ì¤òÆɤó¤Ç¤¤¤¿¡ª¤·¤Ã¤«¤êÂн褷¤ÆÈ¿·â¤Ëž¤º¤ë¡ª | , | 1 | , | 80 | , | | , | | °ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ªÂçÎ̤βÐÌôÇúȯ¤¹¤ë¡ª[BR]¤À¤¬[USER]¤Ï¤³¤ì¤òÆɤó¤Ç¤¤¤¿¡ªµÕ¤ËÍøÍѤ·¤ÆŨ¤ËÂçÂÇ·â¤òÍ¿¤¨¤¿¡ª | , | 1 | , | 100 | , | [BR][USER]¤ÎͦÌԤʤë³èÌö¤ò»¾¤¨¡¢¡ØËâ·³ÆÍ·â·®¾Ï¡Ù¤¬¼øÍ¿¤µ¤ì¤¿¡ª | , | | °ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ªÂçÎ̤βÐÌôÇúȯ¤¹¤ë¡ª[BR][USER]¤ÎÉôÂâ¤ÏÂ礤ÊÈï³²¤ò¼õ¤±¤¿ | , | 0 | , | 40 | , | | , | [BR]µ¢´Ô¤ÎºÝ¡¢¿Í´Ö¤ÎĵÊóÉôÂâ¤òÊá¤é¤¨¤¿¡ªËâʪ¤Ë²½¤±¤Æʶ¤ì¹þ¤ó¤Ç¤¤¤ë¤è¤¦¤À¡£ | ¡¦ ¡¦ ¡¦ | ËⲸ¦µæ½ê¤òȯ¸«¤·¤¿¡¢[USER]¤¬Ãæ¤ò¤¢¤é¤¿¤á¤ë¡ª[BR]Ʊ²¤Î¤Ê¤¤¬¤é¤ò²ó¼ý¤·¤¿[BR]¡ØËⲦ·³¤ÎÇÛÃֵڤӻؼ¨Ì¿Îá·ÏÅý¤Ë´Ø¤¹¤ë»ñÎÁ¡Ù¤ò²ó¼ý¤·¤¿¡ª | , | 0 | , | 40 | , | | , | |
¡¡
Ver.2 | -1 | , | -2 | , | -3 | , | -4 | , | -5 | LIST2 | [LIST9_1-1] | , | [LIST9_1-2] | , | [LIST9_1-3] | , | [LIST9_1-4] | , | [LIST9_1-5] | [LIST9_2-1] | , | [LIST9_2-2] | , | [LIST9_2-3] | , | [LIST9_2-4] | , | [LIST9_2-5] | [LIST9_3-1] | , | [LIST9_3-2] | , | [LIST9_3-3] | , | [LIST9_3-4] | , | [LIST9_3-5] | ¡¦ ¡¦ ¡¦ | [LIST10_48-1] | , | [LIST10_48-2] | , | [LIST10_48-3] | , | [LIST10_48-4] | , | [LIST10_48-5] | [LIST10_49-1] | , | [LIST10_49-2] | , | [LIST10_49-3] | , | [LIST10_49-4] | , | [LIST10_49-5] | [LIST10_50-1] | , | [LIST10_50-2] | , | [LIST10_50-3] | , | [LIST10_50-4] | , | [LIST10_50-5] |
+
| |
|
¡Ö¿ÀεÍͤÎÄˤߤò»×¤¤ÃΤ졪¡×¤È¶«¤Ó¤Ê¤¬¤é¶¸¿®¼Ô¤¿¤Á¤¬½±¤¤³Ý¤«¤Ã¤Æ¤¤¿¡ª[BR]¤Ï¤Ã¤¤ê¸À¤Ã¤Æ»¨µû¤À¡¢[USER]¤ÎÉôÂ⤬½³»¶¤é¤·¤¿,0,40,,
¡Ö¿ÀεÍͤÎÄˤߤò»×¤¤ÃΤ졪¡×¤È¶«¤Ó¤Ê¤¬¤é¶¸¿®¼Ô¤¿¤Á¤¬½±¤¤³Ý¤«¤Ã¤Æ¤¤¿¡ª[BR]¤Ï¤Ã¤¤ê¸À¤Ã¤Æ»¨µû¤À¡¢[USER]¤ÎÉôÂ⤬½³»¶¤é¤½¤¦¤È¤·¤¿¤½¤Î»þ¡Ä¶¸¿®¼Ô¤¿¤Á¤¬ÂçÇúȯ¤òµ¯¤³¤·¤¿¡ª[BR][USER]¤ÎÉôÂâ¤ÏÈï³²¤ò¼õ¤±¤¿,1,80,,
Ëâʪ»È¤¤¤¬ÀöǾ¤·¤¿Ëâʪ¤ò¤±¤·¤«¤±¤Æ¤¤¿¡ª[BR][USER]¤Ï¶ìÀï¤ò¶¯¤¤¤é¤ì¤ë¡ª[BR]ÀöǾ¤µ¤ì¤¿Ãç´Ö¤ò¼ê¤Ë¤«¤±¤ë¾¤Ê¤«¤Ã¤¿¡ÄËâʪ»È¤¤¤Ë¤Ïƨ¤²¤é¤ì¤Æ¤·¤Þ¤Ã¤¿,0,40,,
¡¦
¡¦
¡¦
¸þ¤³¤¦¤«¤éËⲤËÊÑ°Û¤·¤¿¿Í´Ö¤¬Æ¨¤²¤Æ¤¯¤ë¡ª¤É¤¦¤ä¤é¿Í´Ö¤¿¤Á¤ËÄɤï¤ì¤Æ¤¤¤ë¤è¤¦¤À[BR][USER]¤¬½õ¤±¤è¤¦¤È¤·¤¿¤¬¡Ä´Ö¤Ë¹ç¤ï¤Ê¤«¤Ã¤¿,0,40,,
|
+
| |
|
°ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ª¶õÇòÃÏÂÓ¤ËͶ¤¤¹þ¤Þ¤ì¤Æ¤¤¤ë¡ª[BR]±óÊý¤«¤é¤ÎÂçˤ¤Ç¤Î°ìÀƼͷâ¤ò¼õ¤±¤¿¡ª[BR][USER]¤ÎÉôÂâ¤ÏËɸæ¤ò¸Ç¤á¡¢ÁÇÁ᤯°ú¤¤¤ÆÈ¿·â¤ÎÂÎÀª¤òÀ°¤¨¤¿¡ª,1,80,,
°ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ª¶õÇòÃÏÂÓ¤ËͶ¤¤¹þ¤Þ¤ì¤Æ¤¤¤ë¡ª[BR]±óÊý¤«¤é¤ÎÂçˤ¤Ç¤Î°ìÀƼͷâ¤ò¼õ¤±¤¿¡ª[BR][USER]¤ÎÉôÂâ¤ÏËɸæ¤ò¸Ç¤á¡¢ÁÇÁ᤯°ú¤¤¤ÆÈ¿·â¤ÎÂÎÀª¤òÀ°¤¨¤¿¡ª,1,80,,
°ìµ¤ÒêÀ®¤Ë¹¶¤á¹þ¤à¤¬¡Ä櫤À¡ª¶õÇòÃÏÂÓ¤ËͶ¤¤¹þ¤Þ¤ì¤Æ¤¤¤ë¡ª[BR]±óÊý¤«¤é¤ÎÂçˤ¤Ç¤Î°ìÀƼͷâ¤ò¼õ¤±¤¿¡ª[BR][USER]¤ÎÉôÂâ¤ÏËɸæ¤ò¸Ç¤á¡¢ÁÇÁ᤯°ú¤¤¤ÆÈ¿·â¤ÎÂÎÀª¤òÀ°¤¨¤¿¡ª,1,80,,
¡¦
¡¦
¡¦
¤Ê¤Ë¤ä¤éÁû¤¬¤·¤¤¡Ä¿Í´Ö¤¿¤Á¤Î°ìÉô¤¬ÆÍÇ¡ËⲤËÊÑËƤ·¡¢Ë½¤ì¤Þ¤ï¤Ã¤Æ¤¤¤ë¤é¤·¤¤[BR]¥µ¥É¥¦¥§¥¤¤ÎŹÊÞ¤«¤é½Ð¤Æ¤¤¿°ìÃĤÈÁè¤Ã¤Æ¤¤¤¿¡ªÊü¤Ã¤Æ¤ª¤³¤¦¡Ä[USER]¤Ï¹½¤ï¤º¿Ê·³¤·¤¿¡ª,1,80,,
|
- Ver.1¤ÎÊý¤¬ÁÇľ¤Ç¤ï¤«¤ê¤ä¤¹¤¤
- Ver.2¤Ï¹àÌÜ¿ô¤¬Áý¤¨¤¿´Ø·¸¤Ç
´ðÁåƥ¥¹¥È¤«¤éLIST2¤ò»²¾È
¡¡¡¡¡¡¢
LIST2¤«¤éLIST9¡¢10¤ò»²¾È¤ÈÆó½Å»²¾È¤ò¹Ô¤Ã¤Æ¤¤¤ë¡£
- ¡Ø-2¡Á5¡Ù¤Ë¤Ä¤¤¤Æ¤Ï¸å½Ò
|