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

[µo°Ý] «ç¼Ë¥Î¨ç¼Æ§â¨C¤K­Ó¬P´Á¬°¤@­Ó´`Àô¦P®ÉÅÜ´«ª¬ºAªº±ø¥ó®æ¦¡¤Æ¡H

[µo°Ý] «ç¼Ë¥Î¨ç¼Æ§â¨C¤K­Ó¬P´Á¬°¤@­Ó´`Àô¦P®ÉÅÜ´«ª¬ºAªº±ø¥ó®æ¦¡¤Æ¡H

¥»©«³Ì«á¥Ñ maiko ©ó 2017-1-13 14:23 ½s¿è

½Ð°Ý ¦b J2©M K2¿ï¾Ü±ø¥ó¤U¡A¦p¦ó¥Î¨ç¼Æ§¹¦¨¥H¤U±ø¥ó®æ¦¡¤Æªº­n¨D¡H


¦b B2:H65½d³ò¤º¡A¨C¤K­Ó¬P´Á´N¤@­Ó´`Àô¡A´«¤@¦¸¥D¥ð¤é¡A¦Ó¦pªG¿ï¾Ü¤F¤p®§¬O¡G9.6 ªº¸Ü¡A¨º»ò²Ä1¡B3¡B5¡B7 ¬P´Á´N·|¦b¥D¥ð¤é«á­±¥[¦h¤@¤Ñ¡]¦p¹Ï¶À¦â©Ò¥Ü¡^¡A¤Ï¤§¿ï¾Ü¤F¤p®§¬O¡G8 ªº¸Ü¡A¨º»ò²Ä2¡B4¡B6¡B8 ¬P´Á´N·|¦b¥D¥ð¤é«á­±¥[¦h¤@¤Ñ¡C



¡¯¦pªG¨ì¥D¥ð¤é¬O¬P´Á¤é´«¬P´Á¤@ªº¸Ü¡A¨º»ò­ì¥»³æ¥ð¥u¦³¬P´Á¤é´«¨ì¬P´Á¤@¤]¬O³æ¥ð¡]¤£·|¬O¤§«eªº¨º¼Ë¤@­Ó¬P´Á³æ¥ð¡A¤@­Ó¬P´ÁÂù¥ð¡^¡A¤]´N¬O¨C 56 ­Ó¬P´Á¥H«á¡A¥»¨Ó²Ä 1¡B3¡B5¡B7 ¬P´Á¬OÂù¥ð¡A²{¦b­n§ï¦¨³æ¥ð¡F¥»¨Ó²Ä 2¡B4¡B6¡B8 ¬P´Á¬O³æ¥ð¡A¨º»ò­n§ï¦¨Âù¥ð¡C



¥H¦¹Ãþ±À¡A¨C¹L 56 ­Ó¬P´Á¥H«á¤]­n§â³o³W«ß­Ë§Ç¡C


µù¡G¦pªG½ü¨ì¥D¥ð¤é¬O¬P´Á¤Ñªº¸Ü¡A¨ºªþ¥[ªº¤@¤Ñ·|¬O¬P´Á¤@¡]¦p¹Ï B50:H57 ªº¶À¦â©Ò¥Ü¡^


RCondition_Fixa.rar (13.74 KB)


¥»©«³Ì«á¥Ñ ML089 ©ó 2017-1-15 05:00 ½s¿è

®æ¦¡¤Æ±ø¥ó¤½¦¡

¥D¥ð(¤£¥i¥H¿ï)               
B2=MOD(INT((B2-$B$2)/56),7)=WEEKDAY(B2,3)               

               
¤p®§ (¥i¥H¿ï)               
B2 =N(MOD(INT((B2-$B$2)/56)+1,7) = WEEKDAY(B2,3)) *(MOD(INT((B2-$B$2)/7),2)=IF($K$2=8,1,0))
²¤Æ¤Ö¤@­ÓMOD
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

®æ®æ¦¡¤Æ¤½¦¡ B2

¥D¥ð (¥i½Õ¿ï J2)       
B2 =N(MOD(INT((B2-$B$2)/56)+MATCH($J$2,$B$1:$H$1,)-1,7)=WEEKDAY(B2,3))       
WEEKDAY(B2,3)¬O¬P´Á¤@¥Ñ0¶}©l       
56¬O8©P¤Ñ¼Æ(7*8)       
       
       
¤p®§ (¥i½Õ¿ï K2)       
  9.6 ®É¡A¦b²Ä 1¡B3¡B5¡B7 ¬P´Áªº¥D¥ð¤é«á­±¥[¦h¤@¤Ñ
  8    ®É¡A¦b²Ä 2¡B4¡B6¡B8 ¬P´Áªº¥D¥ð¤é«á­±¥[¦h¤@¤Ñ
  ª`·N¡A¬P´Á¤é®É¬O¸Ó©P¬P´Á¤@¥ð
B2 =N(MOD(INT((B2-$B$2)/56)+MATCH($J$2,$B$1:$H$1,)-0,7)=WEEKDAY(B2,3))
*(MOD(INT((B2-$B$2)/7),2)=IF($K$2=8,1,0))       

RCondition_Fix ¥D¥ð¤p®§¨C¤K­Ó¬P´Á´N¤@­Ó´`Àô.rar (67.18 KB)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

®æ®æ¦¡¤Æ¤½¦¡ B2

¥D¥ð (¥i½Õ¿ï J2)       
B2 =N(MOD(INT((B2-$B$2)/56)+MATCH($J$2,$B$1H$1,)-1,7)=WEEKDA ...
ML089 µoªí©ó 2017-1-15 05:13



   
ÁÂÁ´£¨Ñ³o¼Ëªº«ä¸ô¡A¤£¹L¤£¦n·N«ä¡A¨ì¥D¥ð¤é¬O¬P´Á¤éªº®É­Ô¡A¨º»ò¤U­Ó¬P´Á¥D¥ð¤éÀ³¸Ó¬O´«¬P´Á¤@¡A¦Ó¥B¬O³æ¥ð¡A¤£¬OÂù¥ð¡C(¦p¹Ï¬õ°é©Ò¥Ü)


³o¼Ë­pºâªº¸Ü¡A¨C56­Ó¬P´Á´N­n´«¥D¥ð¤é¤@¦¸¡A¦pÃD­n¨Dªº¨º¼Ë¡C

TOP

¦^´_ 4# maiko

¬P´Á¤é¥D¥ð±µ¤U©P¬P´Á¤@¥D¥ð®É¡A­Y¤p®§¬O³æ©P¥ð®É´N·|³y¦¨¤T¤Ñ³s°²¡A­Y¤p®§¬OÂù©P¥ð®É´N¤£·|³y¦¨¤T¤Ñ³s°²¡A³o»P52©P´`Àô¨S¦³Ãö«Y¡C
³o³¡¤À»Ý¨D¦³¨Ç©_©Ç?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ maiko ©ó 2017-1-17 08:33 ½s¿è

¦^´_ 5# ML089


   

¬O³o¼Ë­n¨Dªº¡A¨C¦¸³£¦b¥D¥ð¬O ¬P´Á¤é ´« ¬P´Á¤@ªº®É­Ô¡A¦pªG¬OÂù©Pªº¸Ü¡A¨º»ò¬P´Á¤@¤]¬OÂù©P¡]³o®É¤~¦³¾÷·|³sÄò¤T¤Ñ¡^¡A¤Ï¤§¦pªG¬O³æ©Pªº¸Ü¡A¨º»ò¬P´Á¤@¤]¬O³æ©P¡]³o®É¥u¦³³sÄò¨â¤Ñ¡^¡C
½T¹ê¬O¸ò56­Ó¬P´ÁµLÃö¡A¥u¬O¨C¦¸³£¦b¬P´Á¤é´«¬P´Á¤@ªº®É­Ô¡A³o¼Ëºâ°_¨Ó´N¹j¤F 7 * 8 = 56 ­Ó¬P´Á¤F¡C

ÁÂÁÂ! ½Ð¦h¶O«ä¶q¤@¤U¡A³o¼Ëªº¸Ü¬O«ç»ò¹F¦¨ªº?

TOP

¦^´_ 6# maiko

>>¬O³o¼Ë­n¨Dªº¡A¨C¦¸³£¦b¥D¥ð¬O ¬P´Á¤é ´« ¬P´Á¤@ªº®É­Ô¡A¦pªG¬OÂù©Pªº¸Ü¡A¨º»ò¬P´Á¤@¤]¬OÂù©P¡]³o®É¤~¦³¾÷·|³sÄò¤T¤Ñ¡^¡A¤Ï¤§¦pªG¬O³æ©Pªº¸Ü¡A¨º»ò¬P´Á¤@¤]¬O³æ©P¡]³o®É¥u¦³³sÄò¨â¤Ñ¡^¡C
>>½T¹ê¬O¸ò56­Ó¬P´ÁµLÃö¡A¥u¬O¨C¦¸³£¦b¬P´Á¤é´«¬P´Á¤@ªº®É­Ô¡A³o¼Ëºâ°_¨Ó´N¹j¤F 7 * 8 = 56 ­Ó¬P´Á¤F¡C

>>ÁÂÁÂ! ½Ð¦h¶O«ä¶q¤@¤U¡A³o¼Ëªº¸Ü¬O«ç»ò¹F¦¨ªº?


¤p®§¬OÂù©P¥ðªº¨S¦³¦¹°ÝÃD
¤p®§¬O³æ©P¥ðªº¦b¥D¥ð¬°¬P´Á¤é§ï¬°¬P´Á¤@¨º¤K©P¥þ³¡§ï¬°Âù©P¥ð¶Ü? ¦A¹L 56 ­Ó¬P´Á¦A§ï¬°³æ©P¥ð®ÉÁÙ¬O¦³¦¹°ÝÃD(³s¥ð¤T¤Ñ)?
°ÝÃD¬O§_§ï¬° ¥D¥ð¬°¬P´Á¤é§ï¬°¬P´Á¤@¨º¤K©P¤p®§¥þ³¡¬°Âù©P¥ð¡A¨ä¥L¤£Åܳo¼Ë¶Ü?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089

>>¤p®§¬OÂù©P¥ðªº¨S¦³¦¹°ÝÃD
>>¤p®§¬O³æ©P¥ðªº¦b¥D¥ð¬°¬P´Á¤é§ï¬°¬P´Á¤@¨º¤K©P¥þ³¡§ï¬°Âù©P¥ð¶Ü? ¦A¹L 56 ­Ó¬P´Á¦A§ï¬°³æ©P¥ð®ÉÁÙ¬O¦³¦¹°ÝÃD(³s¥ð¤T¤Ñ)?
>>°ÝÃD¬O§_§ï¬° ¥D¥ð¬°¬P´Á¤é§ï¬°¬P´Á¤@¨º¤K©P¤p®§¥þ³¡¬°Âù©P¥ð¡A¨ä¥L¤£Åܳo¼Ë¶Ü?

§Ú³o¼Ë¸ÑÄÀ¤@¤U¬Ý¬Ý¡G
¥»¨Ó´N¬O¤@­Ó¬P´ÁÂù©P¡A¤@­Ó¬P´Á³æ©P¡A³o¼Ë¢·­Ó¬P´Á´N·|§ïÅÜ¥D¥ð¤é¡]¦pªG¬O¬P´Á¤@ªº¸Ü¡A¨º´N§ï¦¨¬P´Á¤G¡A¦ÓÂù©P´N¶¶©µ¬P´Á¤G¡B¤T³o¼Ë¡^
¨C¹L¢·­Ó¬P´Á´N§ïÅÜ¥D¥ð¤é¡A¤@ª½§ï¨ì¬P´Á¤é¡A¦Ó³o®É¦pªG¥D¥ð¬O¬P´Á¤éªº²Ä¢·­Ó¬P´Áªº¸Ü¡A¦Ó¤S¬O³æ©P¡A¨º»ò¤U­Ó¬P´Á¥D¥ð´N·|§ï¦¨¬P´Á¤@¡A³o®É­ÔÁÙ¬O³æ©P
¦]¬°¥u¦³¦b¥D¥ð¬O¬P´Á¤é­n§ï¦¨¬P´Á¤@ªº®É­Ô¡A¤p®§¤~·|­Ë§Ç¡AµM«á´N¤@­Ó¬P´Á³æ©P¡B¤@­Ó¬P´ÁÂù©P³o¼Ë¡C
¦A¨ì¤U¤@¦¸¥D¥ð¬O¬P´Á¤é­n§ï¦¨¬P´Á¤@ªº®É­Ô¡A¨º»ò¤p®§¦A¦¸­Ë§Ç¡A´N¬O¤@­Ó¬P´ÁÂù©P¡B¤@­Ó¬P´Á³æ©P³o¼Ë¡C

¦p¡G
Âù©P
³æ©P
Âù©P
³æ©P
¡K¡K
Âù©P
³æ©P¡]¬P´Á¤é¡^
³æ©P¡]¬P´Á¤@¡^
Âù©P
¡K¡K
³æ©P
Âù©P¡]¬P´Á¤é¡^
Âù©P¡]¬P´Á¤@¡^
³æ©P
¡K¡K

TOP

¦^´_ 8# maiko

1. ¤p®§¥þ³¡±Æ¦bÂù©P´N¥i¥H¨M¸Ñ°ÝÃD

2. ¤@¦~¤@¦¸³sÄò¤T¤Ñ¡A³o·|¦³¬Æ»ò¼vÅT? ÁÙ¤£¬O¨C8©P¥ð8+4¤Ñ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 9# ML089


>>1. ¤p®§¥þ³¡±Æ¦bÂù©P´N¥i¥H¨M¸Ñ°ÝÃD

>>2. ¤@¦~¤@¦¸³sÄò¤T¤Ñ¡A³o·|¦³¬Æ»ò¼vÅT? ÁÙ¤£¬O¨C8©P¥ð8+4¤Ñ

§Ú·Q¤£¬O»¡¦Û¤v­n«ç¼Ë¦w±Æ´N«ç¼Ë¦w±Æ¡A¬O¤£¬O¡H

µ{§Ç¬O­n³o¼Ë°µªº¡A§A¥i¥H±q¤@­Ó¬P´Á¤@­Ó¬P´Áªº¨¤«×¥h¬Ý¬Ý¡A¨º»ò©Ò¿×ªº³sÄò¤T¤Ñ´N¤£¦s¦b¤F¡C

¦Ó¥B§A»{¬°³o¼Ëªº³sÄò¤T¤Ñ¨ä¹ê¨Ã¤£¬O¤@¦~¤@¦¸¡A¦Ó¬O¤j·§¨â¦~¤@¦¸¡A¦]¬°¥u¦³¦bÂù©P§ïÂù©Pªº®É­Ô¤~¥X²{¡A³æ©P§ï³æ©P¤£·|¥X²{³sÄò¤T¤Ñªº¡C

¨ä¹ê³Ì«áªº­«ÂI´N¬O¡A³o¼Ëªºµ{§Ç°µªk¡AÀ³¸Ó­n«ç¼Ë¹ê²{©O¡HÁÙ¬O½Ð°ª¤â­Ì½ç±Ð¡AÁÂÁ¡I

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD