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

[µo°Ý] ¨D§U¡G®æ¦¡¤Æ±ø¥óªº¶i«×¤é´Á

[µo°Ý] ¨D§U¡G®æ¦¡¤Æ±ø¥óªº¶i«×¤é´Á

¥»©«³Ì«á¥Ñ gong ©ó 2010-12-6 13:04 ½s¿è

Sheet 4ªº¶i«×ªí³sµ²¨ì sheet 1¡A¥i¬O¦b sheet 1 E5:E35Äæ¥[¤J¤F³sµ²¤½¦¡«á¡C
¦b D5:D35Äæ¿é¤J Start ¤é´Á«á End ªº¤é´ÁÁÙ¥¼¿é¤J¡A¦ý¦Û°Ê¦a¼W¥[¨ì³Ì«á¤@Äæ¡A½Ð°Ý¦p¦ó¸Ñ¨M¡H
ÁÂÁ¡I

©êºp!½Ð¨D¤@¤U
ªþ¥[ÀɬO§_¥i¥H­°ª©¦s,
2007ª©ÁÙ¨S¸ò¤W¨Ó,©Ò¥HµLªk¶}±Ò

progress.zip (116.04 KB)

¤Ñ¥Í§Ú§÷¥²¦³¥Î¡A¤dª÷´²ºÉÁÙ´_¨Ó

Sheet 4ªº¶i«×ªí³sµ²¨ì sheet 1¡A¥i¬O¦b sheet 1 E5:E35Äæ¥[¤J¤F³sµ²¤½¦¡«á¡C
¦b D535Äæ¿é¤J Start ¤é´Á ...
letugo µoªí©ó 2010-12-6 12:59



    ====================================================================

¹ï¤£°_¡I Sorry !
¦A¤W¸ü 2003 ª©
ÁÂÁ¡I

progress.zip (120.54 KB)

¤Ñ¥Í§Ú§÷¥²¦³¥Î¡A¤dª÷´²ºÉÁÙ´_¨Ó

TOP

½Ð¦U¦ì°ª¤â¤j¤j­ÌÀ°¦£¡C
·P¿E¡I
¤Ñ¥Í§Ú§÷¥²¦³¥Î¡A¤dª÷´²ºÉÁÙ´_¨Ó

TOP

¦^´_ 3# letugo

TEST
    progress.zip (119.86 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤S¦A¤@¦¸±o¨ì Hsieh ¤j¤jªºÀ°¦£
·P®¦¡AÁÂÁ¡I
¤Ñ¥Í§Ú§÷¥²¦³¥Î¡A¤dª÷´²ºÉÁÙ´_¨Ó

TOP

f5
®æ¦¡>³]©w®æ¦¡¤Æ±ø¥ó
=AND(F$3>=$D5,(F$3<=$E5)*($E5<>""))

f6
®æ¦¡>³]©w®æ¦¡¤Æ±ø¥ó
=AND(F$3>=$D5,(F$3<=$E5)*($E5<>""))

progress.rar (108.53 KB)

ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¤G¦ì¤j¤j¡A½Ð®¤¤p§Ì¤£§÷¡A¸ÑÄÀ¤£²M¡C
°ÝÃD¬O·í§Ú¦bSheet 1 G4 ¿é¤J°_©l¤é´Á«á (¦p8/12/2010 )¡A«K³sµ²¨ì sheet 2¡A
°ÝÃD¬O¡F¦bSheet 2À³¸Ó¥u¨£¨ì 8/12/2010 ¨º¤Ñ¥X²{ÂŦâ¡A¥i¬O Sheet 2 «o¥Ñ8/12/2010 ¨º¤Ñ¨ì9/1/2011 ³£¥X²{ÂŦâ¡A
¥u¦³¦b G4©MH4³£¿é¤J¤F¤é´Á«á¤~¯à¥¿±`Åã¥Ü¡A½Ð°Ý¦p¦ó¸Ñ¨M¡H
ÁÂÁ¡I

¸Ô¨£ªþ¥ó ( ¤w­×¥¿ )

progress 2.zip (12.63 KB)

¤Ñ¥Í§Ú§÷¥²¦³¥Î¡A¤dª÷´²ºÉÁÙ´_¨Ó

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-12-8 22:37 ½s¿è

¦X¨ÖÀx¦s®æ»s³y³Â·Ð
progress 2.zip (12.38 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦¨¥\¤F¡I¤S¦A¦¸ÁÂÁ Hsieh ¤j¤jÀ°¦£
·P®¦¡I
¤Ñ¥Í§Ú§÷¥²¦³¥Î¡A¤dª÷´²ºÉÁÙ´_¨Ó

TOP

¥i±¤¡A¥u¿é¤J°_©l¤é´Á  ( Start day ), ¦ÓÁÙ¥¼¿é¤J²×µ²¤é´Á  ( End day ),
³£¬O¤´¥¼¯àÅã¥Ü°_©l¤é´Á  ( Start day )
Á|¨Ò»¡¡G­Y¥u¦b Sheet 1 G4 ©M G5 ¿é¤J°_©l¤é´Á¡AH4 ©M H5 ¯dªÅ
Sheet 2 ªº¤é´Á¨S¦³Åã¥Ü¥X¨Ó¡A¦]¬°¤@­Ó¤u§Ç¥i¯à¥Ñ¤µ¤Ñ¶}©l¡A°µ¤@¤Ñ¤G¤Ñ©Î¤@¬P´Á¡C
­Y¯à°µ¨ì³o¼Ë¡A´N¥i§¹¥þ¤Ï¬M¨ì¾ã­Ó¶i«×¡C
¤Ñ¥Í§Ú§÷¥²¦³¥Î¡A¤dª÷´²ºÉÁÙ´_¨Ó

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD