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

[µo°Ý] ¼W¥[²Ä7¬q¼Æ¦rªº§P§O»PÂkÃþ

[µo°Ý] ¼W¥[²Ä7¬q¼Æ¦rªº§P§O»PÂkÃþ

7C_0_1894´Á_50_1893_10+1890-1892_10_1¦¸_1-49.rar (173.56 KB)
¥Ø«e¡G
¥Ñ7C_0_1894´Á_50_1893_10+1890-1892_10_1¦¸_1-49¸ê®Æ§¨¤ºªºH2_·j´M(¾÷)¦rÀÉ(¥DÀÉ)_0917_samwang°õ¦æ«á²£¥Í~
7²Î2_0_1894´Á_50_1893+²Ä7¬q¼Æ¦r_3­Ó_1¦¸(¥Ø«e)ªº1­Ó¦³²ÎÃöÁä¦rÀÉ®×~
§Y¥Ñ¤j¦Ó¤p¶}±Ò7C_0_1894´Á_50_1893-10+1892-10_1¦¸_1-49¡F7C_0_1894´Á_50_1893-10+1891-10_1¦¸_1-49¡F7C_0_1894´Á_50_1893-10+1890-10_1¦¸_1-49~
·j´M¦³(¾÷)ÃöÁä¦rªºÀɮסA¨Ã±NÀɮפºªºA&B¤GÄ檺¤º®e¨Ì§Ç½Æ»s¶K¤WSheets("Sheet1")ªºM1¡A
¦A¨Ì¾Ú²Ä5¬q¼Æ¦r§P§OÂkÃþ¬°1­Ó¦³²ÎÃöÁä¦rÀɮסC

»Ý¨D¡G·Q¦A¶i¶¥¼W¥[²Ä7¬q¼Æ¦rªº§P§O»PÂkÃþ~
¥Ñ7C_0_1894´Á_50_1893_10+1890-1892_10_1¦¸_1-49¸ê®Æ§¨¤ºªºH2_·j´M(¾÷)¦rÀÉ(¥DÀÉ)_0917_samwang°õ¦æ«á²£¥Í~
7²Î2_0_1894´Á_50_1893+1890_1­Ó_1¦¸(®ÄªGÀÉ)¡F7²Î2_0_1894´Á_50_1893+1891_1­Ó_1¦¸(®ÄªGÀÉ)¡F7²Î2_0_1894´Á_50_1893+1892_1­Ó_1¦¸(®ÄªGÀÉ)¦@3­Ó¦³²ÎÃöÁä¦rÀÉ®×~
§Y¥Ñ¤j¦Ó¤p¶}±Ò7C_0_1894´Á_50_1893-10+1892-10_1¦¸_1-49¡F7C_0_1894´Á_50_1893-10+1891-10_1¦¸_1-49¡F7C_0_1894´Á_50_1893-10+1890-10_1¦¸_1-49~
·j´M¦³(¾÷)ÃöÁä¦rªºÀɮסA¨Ã±NÀɮפºªºA&B¤GÄ檺¤º®e¨Ì§Ç½Æ»s¶K¤WSheets("Sheet1")ªºM1¡A
¦A¨Ì¾Ú²Ä5¬q¼Æ¦r+²Ä7¬q¼Æ¦r§P§O~¦UÂkÃþ²£¥Í¦@3­Ó¦³²ÎÃöÁä¦rÀɮסC
¸Ô¦pªþ¥ó½d¨Ò

¥H¤W»Ý¨Dªº»yªk~Àµ½Ð¦U¦ì¤j¤j«ü±Ð¡I
ÁÂÁ¡I

¦^´_ 1# ziv976688


§Úªº²z¸Ñ±z»Ý¨D¬O¡A·j´M¦U§O¸ê®Æ§¨-->§ä¨ì"¾÷"ÃöÁä¦r-->¸ê®Æ³B²z-->¦U§O¥t¦s·sÀɮסA¤£ª¾¬O§_¥¿½T¡C

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-9-24 13:44 ½s¿è

§Úªº²z¸Ñ±z»Ý¨D¬O¡A·j´M¦U§O¸ê®Æ§¨-->§ä¨ì"¾÷"ÃöÁä¦r-->¸ê®Æ³B²z-->¦U§O¥t¦s·sÀɮסA ...
samwang µoªí©ó 2021-9-24 12:37 [/quote]
¦^´_ 2# samwang
samwang¤j¤j : ±z¦n !
¬O¥¿½Tªº~§Y¥Ø«e¬O¥u¥H¸ê®Æ§¨ªº²Ä5¬q¼Æ¦r§@§P§O»PÂkÃþ¡A²{¦b§ï¬°²Ä5¬q¼Æ¦r+²Ä7¬q¼Æ¦r§@§P§O»PÂkÃþ~
§ä¨ì"¾÷"ÃöÁä¦r-->¸ê®Æ³B²z-->¦U§O¥t¦s·sÀɮסC
ÁÂÁ±z

TOP

¦^´_ 3# ziv976688

¦pªþ¥ó¡A·sÀɮתºÀɦW¤£¤Ó½T©w¬O§_±zªº»Ý¨D¡A½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ

H2_·j´M(¾÷)¦rÀÉ(¥DÀÉ)_0924.zip (120.46 KB)

TOP

¦^´_ 4# samwang
®ÄªGÀɦWºÙ³o¼Ë¤]«Ü²z·Q~
´ú¸Õµ²ªG¡G§¹¥þ²Å¦X»Ý¨D¥B³æ¼h©MÂù¼h³£¾A¥Î
¸U¤À·PÁ±zªº«ü¾É©MÀ°¦£~·P®¦

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-9-24 19:21 ½s¿è

¦^´_ 4# samwang
©Ó¤WÃD~
¤£¦n·N«ä¡A¥i¯à¬O¦]¬°¦WºÙ§ïÅÜ¡AAÄ檺´Á¼Æ¤º®e¤]ÀH¤§²§°Ê(¥Ñ¦U³æ´Á¼Æ²§°Ê¬°¦U³æ´Á¼Æ+²Ó¶µ)¡A
©Ò¥HA_·j´M(²Î)¦rÀÉ(¥DÀÉ_«e3¤p_§t0)_0922°õ¦æ«á~Sheets("Sheet1")ªº¤º®eµn¿ý¦³»~~
EX¡G7«e3¤j&¤p+0_0_1894´Á_6­Ó_1¦¸(¥Ø«e)ªºC2¡GAY33©MBD2¡GCZ33ªºÂª©¡A
¥H¦P¼Ë¤½¦¡§@²Î­p~µª®×¤£²Å¦X¡F¥t~
CY40¡GAY123ªº¥Ø«e³æ´Á²Ó¶µ¤À­pªº¦X­p¼Æ©MBD40¡GCZ123ªºÂª©³æ´Á¼Æ¦X­p¼Æ~¥H¤H¤u¤ñ¹ï¡Fµª®×¤£²Å¦X¡F
CY125¡GAY140ªº¥Ø«e©MBD125¡GCZ140ªºÂª©¤§¤½¦¡²Î­pµª®×²Å¦X¡C
½Ð¸Ô¨£ªþ¥ó½d¨Ò 0924.rar (285.55 KB)

½Ð°Ý¡GA_·j´M(²Î)¦rÀÉ(¥DÀÉ_«e3¤p_§t0)_0922­n¦p¦ó­×¥¿¡H
ÁÂÁ±z

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-9-25 12:45 ½s¿è

¦^´_ 4# samwang
¤£¦n·N«ä¡A6¼Óªº»¡©úÃ㤣¹F·N~­«·s¾ã²z¦p¤U~
³Æµù¡G
1_H2_·j´M(¾÷)¦rÀÉ(¥DÀÉ)_0924~°õ¦æ«á~§¹¥þ²Å¦X»Ý¨D¡C

2_¦³²ÎÃöÁä¦r¤§ÀɮצWºÙªº·N²[~
³æ¼h¡G
7²ÎS_0_1894´Á_50_1893-10_1¦¸
1894 =«ü©w¤ñ¹ïªº¶}¼ú´Á¼Æ= Nrange
1893 = ¤ñ¹ïªº²Ä1¼hRange
Âù¼h¡G
7²ÎS_0_1894´Á_50_1893-10+1892-10_1¦¸
1894 =«ü©w¤ñ¹ïªº¶}¼ú´Á¼Æ = Nrange
1893 = ¤ñ¹ïªº²Ä1¼hRange
1892 = ¤ñ¹ïªº²Ä2¼hRange

·s»Ý¨D¡G
¥HA_·j´M(²Î)¦rÀÉ(¥DÀÉ_«e3¤p_§t0)_0922_samwang~°õ¦æ«á~²£¥Íªº®ÄªGÀÉ~
¦b³æ¼h©MÂù¼h¤§²Ä2¼h¬°³æ´Á®É~µª®×³£OK¡F
¦ý¦bÂù¼h¤§²Ä2¼h¬°¦h´Á®É¡Aµª®×·|¦³BUG~
EX¡GÂù¼h_²Ä1¼h¦h´Á+²Ä2¼h¦h´Á-NG¡FÂù¼h_²Ä1¼h³æ´Á+²Ä2¼h¦h´Á-NG~
¨ä¤ºªº®ÄªGÀÉB1¡GAY40ªºµª®×¤£¥¿½T(¦]B41¥H¤Uªº®æ¦¡¤£¦P~²§³B¤£¼Ð¥Ü)¡C
¸Ô¦pªþ¥ó½d¨Ò : Á`´ú¸Õ_0925.rar (573.32 KB)

¥H¤W    A_·j´M(²Î)¦rÀÉ(¥DÀÉ_«e3¤p_§t0)_0922_samwang
Àµ½Ð½ç¥¿~¯à¦]À³·s®æ¦¡¡A°õ¦æ«á~¥H²£¥Í¥¿½Tµª®×¡C
ÁÂÁ±z¡I

TOP

¦^´_ 7# ziv976688

½Ð°Ý¤°»ò¬O³æ¼h¡BÂù¼h?
½Ð°Ý¤°»ò¬O²Ä1¼h¦h´Á¡B³æ´Á?
¨ä¹ê§Ú¦^Âиѵª«á¡A´£°ÝªÌ©Ò¸ß°Ý±ø¥ó«Ü§Ö´N§Ñ¡A
©Ò¥H¡A¤~·|¾É­P§ï³o¸Ì¼vÅT¨ä¥Lªº

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-9-25 14:59 ½s¿è

¦^´_ 8# samwang
¥H¤U»¡©ú¤£¥]¬A Nrange=1894ªº¼Æ¦r~
³æ¼h=¸ê®Æ§¨¤ºªº²ÎÃöÁä¦r¤§ÀɮצWºÙ¥u¦³²Ä1¼hªºRange¼Æ¦r
EX : 7²ÎS_0_1894´Á_50_1893-10_1¦¸
³æ´Á=¸ê®Æ§¨¤º¥u¦³1­Ó²ÎÃöÁä¦r¤§ÀÉ®×~¦p¤W­z¡C
¦h´Á=¸ê®Æ§¨¤º¦³2­Ó(§t)¥H¤W²ÎÃöÁä¦r¤§ÀÉ®×~
EX : 7²ÎS_0_1894´Á_50_1891-10_1¦¸¡F 7²ÎS_0_1894´Á_50_1892-10_1¦¸¡F....¡C

Âù¼h=¸ê®Æ§¨¤ºªº²ÎÃöÁä¦r¤§ÀɮצWºÙ¦³²Ä1¼hªºRange¼Æ¦r+²Ä2¼hªºRange¼Æ¦r
EX : 7²ÎS_0_1894´Á_50_1893-10+1892-10_1¦¸
²Ä1¼h³æ´Á+²Ä2¼h³æ´Á=¸ê®Æ§¨¤º¥u¦³1­Ó²Ä1¼hªºRange¼Æ¦r+²Ä2¼hªºRange¼Æ¦r¤§²ÎÃöÁä¦r¤§ÀÉ®×~¦p¤W­z¡C

²Ä1¼h³æ´Á+²Ä2¼h¦h´Á=¸ê®Æ§¨¤º¦³2­Ó(§t)¥H¤W²ÎÃöÁä¦r¤§ÀÉ®×~
¥B²Ä1¼hªºRange¼Æ¦r³£¬Û¦P(³æ´Á)+²Ä2¼hªºRange¼Æ¦r³£¤£¬Û¦P(¦h´Á)~
EX : 7²ÎS_0_1894´Á_50_1893-10+1890-10_1¦¸¡F7²ÎS_0_1894´Á_50_1893-10+1891-10_1¦¸¡F....¡C

²Ä1¼h¦h´Á+²Ä2¼h³æ´Á=¸ê®Æ§¨¤º¦³2­Ó(§t)¥H¤W²ÎÃöÁä¦r¤§ÀÉ®×~
¥B²Ä1¼hªºRange¼Æ¦r³£¤£¬Û¦P(¦h´Á)+²Ä2¼hªºRange¼Æ¦r³£¬Û¦P(³æ´Á)~
EX : 7²ÎS_0_1894´Á_100_1891-10+1890-10_1¦¸¡F7²ÎS_0_1894´Á_100_1892-10+1890-10_1¦¸¡F....¡C

²Ä1¼h¦h´Á+²Ä2¼h¦h´Á=¸ê®Æ§¨¤º¦³4­Ó(§t)¥H¤W²ÎÃöÁä¦r¤§ÀÉ®×~
¥B²Ä1¼hªºRange¼Æ¦r¤£¥þ¬Û¦P(¦h´Á)+²Ä2¼hªºRange¼Æ¦r¤£¥þ¬Û¦P(¦h´Á)~
EX : 7²ÎS_0_1894´Á_100_1891-10+1890-10_1¦¸¡F7²ÎS_0_1894´Á_100_1892-10+1890-10_1¦¸¡F7²ÎS_0_1894´Á_100_1892-10+1891-10_1¦¸¡F7²ÎS_0_1894´Á_100_1893-10+1890-10_1¦¸¡F....¡C

¥H¤W  ½Ð°Ñ¦Ò~ÁÂÁ±z

PS : À³¸Ó¥u¬O¦b²Ä2¼h¦³¦h´Á®É¡A§PŪ¤£°÷§¹¥þ~¨ä¥¦³£OK¡C

TOP

¦^´_ 9# ziv976688


¦pªþ¹Ï¡A§ì¨ú¸ê®Æ¬O¹ïªº¡A½Ð¦A½T»{¤@¤U¡AÁÂÁÂ
Â^¨ú1.PNG

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD