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

[µo°Ý] ·j´M¦³¥æ¶°¼Æ¦rªº²Õ¦X¡C

[µo°Ý] ·j´M¦³¥æ¶°¼Æ¦rªº²Õ¦X¡C

¥»©«³Ì«á¥Ñ Airman ©ó 2017-1-29 20:09 ½s¿è

¤ñ¹ï°ò·ÇÄæ¦ì=1®É¡A¨äBÄæ,CÄæ,DÄæ,EÄæ,FÄæ,GÄæ,HÄæ~ÀɮצWºÙ¥H1,2,3,4,5,6,7´À¥N¡C
¤ñ¹ï°ò·ÇÄæ¦ì=2®É¡A¨äB,C¤GÄæ,B,D¤GÄæ,B,E¤GÄæ,B,F¤GÄæ,B,G¤GÄæ,B,H¤GÄæ~ÀɮצWºÙ¥H12,13,14,15,16,17´À¥N¡C
¨äC,D¤GÄæ,C,E¤GÄæ,C,F¤GÄæ,C,G¤GÄæ,C,H¤GÄæ~ÀɮצWºÙ¥H23,24,25,26,27´À¥N¡C
¡J
¡J
¤ñ¹ï°ò·ÇÄæ¦ì=3®É¡A¨äB,C,D¤TÄæ,B,D¤GÄæ,B,C,E¤TÄæ,B,C,F¤TÄæ,B,C,G¤TÄæ,B,C,H¤TÄæ~ÀɮצWºÙ¥H123,124,125,126,127´À¥N¡C
¡J
¡J
¤ñ¹ï°ò·ÇÄæ¦ì=6®É¡A
¨äB,C,D,E,F,G¤»Äæ,B,C,D,E,F,H¤»Äæ,B,C,D,E,G,H¤»Äæ, B,C,D,F,G,H¤»Äæ, B,C,E,F,G,H¤»Äæ, B,D,E,F,G,H¤»Äæ, C,D,E,F,G,H¤»Äæ~
ÀɮצWºÙ¥H123456,123457,123467,123567,124567,134567,234567´À¥N¡C

Á`¸ê®Æ§¨¦WºÙ= " I_" & Nrange &"´Á_" & rnum & "_" & Rrng &"_"& Crng &"¬P_" & Ncount & "¦¸_" & Number
EX¡JI_28´Á_15_21-24_1-2¬P_2-3¦¸_3,11,21-26,43,49
¤À¸ê®Æ§¨¦WºÙ= " I_" & Nrange &"´Á_" & rnum & "_" & Rrng &"_"& Crng &"¬P_" & Ncount & "¦¸_" & Number
EX¡JI_28´Á_15_21_2¬P_3¦¸_3,11,21-26,43,49
ÀɮצWºÙ= " I_" & Nrange &"´Á_" & rnum & "_" & Rrng &"_"& Crng &"¬P_" & Ncount & "¦¸_" & Number(=ÅçÃÒ²Õ¦X¬Û¦Pªº«ü©w¸¹½X=¥æ¶°)
EX¡JÀɮצWºÙ= I_28´Á_15_21-12_3¦¸_11,26,43
¤u§@ªí¦WºÙ= Sheet1

P.S.
1.¨S¦³²£¥Í¥ô¤@­ÓÀɮתº¤À¸ê®Æ§¨²¾°£(§Y¤£²£¥Í)¡C
2.¨S¦³²£¥Í¥ô¤@­Ó¤À¸ê®Æ§¨ªºÁ`¸ê®Æ§¨²¾°£(§Y¤£²£¥Í)¡C

Sheet1ªº»Ý¨D¡J½Ð¸Ô¨£ªþÀÉ¡C
2017-0129-Q-1 -.rar (107.25 KB)

¥H¤W  Àµ½Ð¦U¦ì¥ý¶i¤£§[´f¤©«ü¾É!ÁÂÁÂ!

¦^´_ 1# Airman

­«·s¾ã²z:
I_28´Á_15_21-12_2¦¸_11,26,43.png
2017-1-30 01:13


I_28´Á_15_21-12_3¦¸_11,26,43.png
2017-1-30 01:15


I_28´Á_15_23-2_2¦¸_11,26,43

I_28´Á_15_23-2_2¦¸_11,26,43.png
2017-1-30 01:16


2017-0130-Q-1 -.rar (38.03 KB)

TOP

¦^´_ 2# Airman
C.png
2017-1-30 09:55

½Ð±N¦U­Ó²Õ§O ¼Ð¥Üªº¦r«¬ÃC¦â¡BÄæ¦ì©³¦â
ªº ÃC¦â¥N½X ¤@¤@¼Ð¥Ü¥X¨Ó¡AÁÂÁ¡C
¨Ò¦p¡G ¬õ¦â  =  255
            ¡A ¥H¦¹Ãþ±À¡C
j§Úµø¤O¤£¨Î¡AÃø¥H¥J²Ó¿ë§O¡C

TOP

¦^´_ 3# c_c_lai
¦]¬°¦â±mÃѧO½X¦]¦U¤Hªº²ßºD¤£¦P
EX:¬õ¦â±z¬O¥H255ÃѧO¡A§Ú¬O¥H3ÃѧO
©Ò¥H¦rÅéÃC¦â©MÀx¦s®æ©³¦â¡A´N¤£©ëªd¤F¡A¥u­n±zı±o¬Ûªñ§Y¥i¡C
ÁÂÁ±z

TOP

¦^´_ 4# Airman
·j´M¬Û¦P¼Æ¦rªº²Õ¦Xµ{¦¡¹Lµ{¸Ñ»¡.rar (238.5 KB)
½Ð°Ñ¾\ "·j´M¬Û¦P¼Æ¦rªº²Õ¦Xµ{¦¡¹Lµ{¸Ñ»¡.pdf "
³oÀ³¸Ó¬O¥i¥Hº¡¨¬§Aªº»Ý¨D¡C

TOP

¥»©«³Ì«á¥Ñ Airman ©ó 2017-2-3 19:17 ½s¿è

¦^´_ 5# c_c_lai
¨þ~¨þ~¤p§Ì¥u»Ý­nA²Õ¦Xªºµ{¦¡½X´N¦n(½Ð¨£2#ªº½d¨Ò¹Ï¤ù)¡A¨ä¥Lªº¤£»Ý­n~¤Ó½ÆÂø¤F^^"
¥i¤£¥i¥H½Ð±z°µ¤@­Ó°õ¦æ¥DÀÉ~¥i±N®ÄªG¸ê®Æ§¨©M¨ä¤ºªº®ÄªGÀÉ­Ó§OÅã¥Ü¥X¨Ó¡F¦]¬°½Æ»sPDFªº¤º®e¶K¤W2#ªº¥DÀÉ¡A¨S¦³¤À¬q~²V¦¨¤@¹Î¡C
ÁÂÁ±z:lol

PS:¤ñ¹ï°ò·Ç´Á(¶}¼úª©)  ©M²Ä1­ÓÅçÃÒª©­«½Æ¤F~µ¥©ó¤Ö1­ÓÅçÃÒª©¡A¨S¦³¥æ¶°¸¹½X¥X²{ (ÅçÃÒª©¤@©w­n¦³2­Ó¥H¤W¡A¤~¯à¨Ì¾ÚÅÞ¿è§ä¥X¦³¬Û¦Pªº«ü©w¥æ¶°¸¹½X¤§²Õ¦X)¡C

TOP

¦^´_ 6# Airman
·j´M³Ì«á¤@¦C³£¦³¬Û¦P¼Æ¦rªº²Õ¦XSRC.rar (8.6 KB)
§A¥i¥H¸ÕµÛ¦Û¦æ¥h­×¥¿¡C

TOP

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2017-2-3 19:41 ½s¿è

¦^´_ 6# Airman
§A¥u»Ý­nA²Õ¦Xªºµ{¦¡½X´N¦n¡H
µL©Ò¿×¤§ A²Õ¦X ªºµ{¦¡¬q¡A
¥¦¬O¨Ì¾Ú For ct2 = 1 To 3  ~ Next ct2 ¶¡
¦Û°Ê¥h§PÂ_²Õ¦X¨ä¬Û¹ïÀ³ªº "²Õ¦X"¡C
½Ð¥J²Ó¬ã¨s©Òªþµ{¦¡«K¤@¥Ø¤FµM¤F¡C

TOP

¦^´_ 8# c_c_lai
ÁÂÁ±zªº¦^À³©M¸Ñµª¡C

¶Qµ{¦¡½X¶K¨ì¼Ò²Õ1«ö°õ¦æ~¨Sµ²ªG¡C
¶K¨ìDATAªº½s¿è¾¹~¥ý§R°£­ì¥ýªºµ{¦¡½X~¥d¦b¦C37 §R°£¤u§@ªí

½Ð°µ¤@­Ó¯à°õ¦æ¥DÀÉ¡A
¦pªG¬O   
    StrRng = "1"
    Nrange = "28" '
    num = "15"
    RrngA = "21-24"
    CrngA = "1-2"
   Order = ""
   Number = "3,11,21-26,43,49"
   Ncount = "2-3"
«h·|²£¥Í
I_28´Á_15_21-24_1-2¬P_2-3¦¸_3,11,21-26,43,49(Á`¸ê®Æ§¨)
Á`¸ê®Æ§¨¤º¦³¦p:I_28´Á_15_21_2¬P_2¦¸_3,11,21-26,43,49µ¥ªº¤À¸ê®Æ§¨
¤À¸ê®Æ§¨¤º¦³¦p:I_28´Á_15_21-12_2¦¸_11,26,43µ¥ªº®ÄªGÀÉ¡C
·P®¦
³Ì«á³æ¦C«ü©w¥æ¶°(¥DÀÉ)_c_c_lai.rar (65.81 KB)

TOP

¦^´_ 8# c_c_lai
Sorry~9#§@¼o^^"


ÁÂÁ±zªº¦^À³©M¸Ñµª¡C

¥i§_½Ð±z¥uÂ^¨ú²Å¦X¥»ÃD»Ý¨Dªº¶Q¸Ñµ{¦¡½X~±N¨ä¶K¤W°õ¦æ¥DÀɪºDATAªº½s¿è¾¹¤¤~
¦p¬O¥H ¤UªºInputBox¤º®e°õ¦æ  
    StrRng = "1"
    Nrange = "28" '
    num = "15"
    RrngA = "21-24"
    CrngA = "1-2"
   Order = ""
   Number = "3,11,21-26,43,49"
   Ncount = "2-3"
«h«ö¥DÀÉ°õ¦æÁä«á¡A¯à²£¥Í¦p~
Á`¸ê®Æ§¨¡JI_28´Á_15_21-24_1-2¬P_2-3¦¸_3,11,21-26,43,49()
Á`¸ê®Æ§¨¤º¦³¡JI_28´Á_15_21_2¬P_2¦¸_3,11,21-26,43,49µ¥ªº¤À¸ê®Æ§¨
¤À¸ê®Æ§¨¤º¦³¡JI_28´Á_15_21-12_2¦¸_11,26,43µ¥ªº®ÄªGÀÉ¡C
·P®¦

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD