¿ÇÃÇÆâÍÆ Edit

´ðËܥƥ­¥¹¥È Edit

[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]¤Ë¿¯¹¶¤ò»Å³Ý¤±¤ë¡ª

[LIST2_1-1]

[LIST2_2-1]

=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4,1,1)=1,¿Í´Ö¤É¤â¤ò½³»¶¤é¤½¤¦¤È¤·¤¿¤½¤Î»þ¡¢,[USER]¤ÎÉôÂâ¤ÎÌÔ¹¶¤Ë¿Í´Ö¤É¤â¤ÎÅýΨ¤¬Íð¤ì¡¢Å±Âà¤ò»Ï¤á¤ë¡ÄÄÉ·â¤À¡ª[BR][BR]),=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=1,Ã桹¹ü¤Î¤¢¤ëÅۤ餬½¸¤Þ¤Ã¤Æ¤¤¤ë¤è¤¦¤À¡Ä¾¡Éé¤Ë½Ð¤è¤¦¡ª,Ũ¤Ï¼ê¶¯¤¤¡¢[USER]¤ÎÉôÂâ¤Ï¶ìÀï¤ò¶¯¤¤¤é¤ì¤ë¡Ä¤³¤³¤¬ÀµÇ°¾ì¤À¡ª)[BR][BR])=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4)=1,[LIST4_1-1],[LIST2_3-1]),[LIST2_3-1])

=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4)=1,=IF([LIST4_1-2]=1,ͦ¼Ô¤Î·âÂà¤ËÀ®¸ù¤·¤¿¡ª[BR][BR]¤½¤Î¸å¤â[USER]¤Î³èÌö¤Ë¤è¤ê¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤ò¤¹¤Ù¤ÆËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª=IF([LIST1_5-4]=¾ë,[LIST6_1-1],)[LIST6_2-3][BR]º£²ó¤Î³èÌö¤ËÂФ¹¤ëË«Èþ¤È¤·¤ÆÂçËⲦÍͤè¤ê[LIST5_1-1]¤¬Â£¤é¤ì¤¿¡ª,[USER]¤ÎÉôÂâ¤Ïͦ¼Ô¤ÎÎϤˤè¤êűÂà¤ò;µ·¤Ê¤¯¤µ¤ì¤¿¡Ä) [BR], =IF([LIST2_3-2]=1,¿Í´Ö¤É¤â¤Ï²õÌÇ¡¢[USER]¤ÎÉôÂâ¤Î´°Á´¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¤â[USER]¤Î³èÌö¤Ë¤è¤ê¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤ò¤¹¤Ù¤ÆËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª[BR]º£²ó¤Î³èÌö¤ËÂФ¹¤ëË«Èþ¤È¤·¤ÆÂçËⲦÍͤè¤ê[LIST5_1-1]¤¬Â£¤é¤ì¤¿¡ª,»×¤ï¤ÌÄñ¹³¤Ë¤¢¤¤¼è¤êƨ¤¬¤·¤Æ¤·¤Þ¤Ã¤¿¡Ä¤À¤¬º³ºÙ¤Ê»ö¡¢[USER]¤ÎÉôÂâ¤Î¾¡Íø¤À¡ª[BR][BR]¤½¤Î¸å¡¢Â¿¾¯¤ÎÄñ¹³¤Ï¤¢¤Ã¤¿¤¬¼þÊÕ°ìÂӤο¤¯¤ÎÄ®¤ä¼¤òËⲦ·³¤Î»ÙÇÛ²¼¤ËÃÖ¤¯»ö¤ËÀ®¸ù¤·¤¿¡ª) =IF([LIST1_5-4]=¾ë,[LIST6_1-1],)[LIST6_2-3][BR]),=IF([LIST2_3-2]=1,¾¡¤Ã¤¿¡ª¿Í´Ö¤É¤â¤¬¤É¤ó¤Ê¤Ë¹³¤ª¤¦¤È¡¢ºÇ¸å¤Ë¾Ð¤¦¤Î¤Ï¤³¤Î[USER]¤Ê¤Î¤À¡ª[BR][BR]¤½¤Î¸å¡¢¼þÊÕ°ìÂÓ¤ÎÄ®¤ä¼¤Ëʼ¤òÇɸ¯¤·¤¿¤¬¡ÄÄü¤á¤Î°­¤¤Åۤ餬¤Þ¤À¤¤¤ë¤è¤¦¤À¡¢Äñ¹³¤¬·ã¤·¤¤¡£=IF([LIST1_5-4]=¾ë,[LIST6_1-1],)[LIST6_2-3],[USER]¤ÎÉôÂâ¤Ï¿¯Î¬¤Ë¼ºÇÔ¡¢Å±Âष¤¿¡Ä)[BR])
[LIST2_1-4][LIST2_2-4]=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4)=1,=IF([LIST4_1-2]=1,=IF([LIST1_5-4]=¾ë,[LIST6_1-2],)[LIST4_1-4],),=IF([LIST2_3-2]=1,=IF([LIST1_5-4]=¾ë,[LIST6_1-2],),)[LIST2_3-4]),[LIST2_3-4])
[LIST2_1-5][LIST2_2-5]=IF(=CALC([LIST2_1-2]+[LIST2_2-2])=2,=IF(=RAND_N(4)=1,[LIST4_1-5],[LIST2_3-5]),[LIST2_3-5])

µ¢´Ô¤·¤¿[USER]¤ËÄäÀï¤ÎÊó¤¬ÆϤ¯¡¢¿åÌ̲¼¤ÇÌ©¤«¤Ë¸ò¾Ä¤¬¿Ê¤á¤é¤ì¤Æ¤¤¤¿¤é¤·¤¤¡Ä
¤³¤ì¤«¤é¤ÏËܳÊŪ¤ÊµÙÀï¤Î¶¨µÄ¤ËÆþ¤ë»ö¤À¤í¤¦¡£
[USER]¤Î¼ó¤Ë³Ý¤±¤é¤ì¤¿·ü¾Þ¶â¤Ï¡¢¤â¤¦Áý¤¨¤Ê¤«¤Ã¤¿¡£

LIST Edit

+  LIST1
  • ¥ê¥¹¥È¥ª¥×¥·¥ç¥ó1
    • »Ä¤¹
+  LIST2
  • ¥ê¥¹¥È¥ª¥×¥·¥ç¥ó2
    • ¾Ã¤¹¡Ê1¤Ä¤À¤±¡Ë
+  LIST3
  • ¥ê¥¹¥È¥ª¥×¥·¥ç¥ó3
    • ¾Ã¤¹¡Ê1¤Ä¤À¤±¡Ë
+  LIST4
  • ¥ê¥¹¥È¥ª¥×¥·¥ç¥ó4
    • »Ä¤¹
+  LIST5
  • ¥ê¥¹¥È¥ª¥×¥·¥ç¥ó5
    • »Ä¤¹
+  LIST6
  • ¥ê¥¹¥È¥ª¥×¥·¥ç¥ó6
    • »Ä¤¹
+  LIST7¢¨¥Ð¥°½¤ÀµºÑ¤ß
  • ¥ê¥¹¥È¥ª¥×¥·¥ç¥ó7
    • »Ä¤¹
+  LIST8
  • ¥ê¥¹¥È¥ª¥×¥·¥ç¥ó8
    • »Ä¤¹
+  LIST9
  • ¥ê¥¹¥È¥ª¥×¥·¥ç¥ó9
    • ¾Ã¤¹¡Ê¥ê¥¹¥È9¤ÈƱ¤¸Ãͤ¹¤Ù¤Æ¡Ë
+  LIST10
  • ¥ê¥¹¥È¥ª¥×¥·¥ç¥ó10
    • ¾Ã¤¹¡Ê¥ê¥¹¥È10¤ÎƱ¤¸Ãͤ¹¤Ù¤Æ¡Ë
LIST2¤«¤éLIST9¤ÈLIST10¤ËÈô¤ó¤Ç¤¤¤¿¤Î¤ÏƱ¤¸¤À¤¬¡¢¤½¤ÎÈæΨ¤ò50¡§50¤«¤é10¡§50¤ËÊѹ¹¤·¤Æ¤¤¤ë¡ÊLIST10¤ÏLIST9¤Î5ÇÜȯÀ¸¤·¤ä¤¹¤¤¡Ë
LIST9¤Ë¤Û¤È¤ó¤É¤Î¿ÇÃǤò²¡¤·¹þ¤ß¡¢LIST10¤Ë¶¯Å¨Àï¤òÆþ¤ì¤¿
¥Æ¥­¥¹¥È¾å¤Ç¤Ï¾¡¤Ã¤¿¤êÉ餱¤¿¤ê¤·¤Æ¤¤¤ë¤¬¡¢ÆâÉô·×»»¤Ç¤ÏÁ´¾¡¤·¤Æ¤¤¤ë¡Ê°ìÉô¥ß¥¹¤¬¤¢¤ê¡¢2.5¡ó¤¯¤é¤¤¤Î³ÎΨ¤ÇÉ餱¤ë¡Ë
ͦ¼Ô¤ÎȯÀ¸³ÎΨ¤ò100¡ó¡¢¾¡Î¨¤ò1/3¤Ë°ú¤­¾å¤²¤Æ¤¤¤ë


Last-modified: 2021-02-24 Wed 21:38:03 JST (1147d)