ªð¦^¦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

¥»©«³Ì«á¥Ñ 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

¦^´_ 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

¥»©«³Ì«á¥Ñ 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

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

¦^´_ 10# samwang
­è­è±NÂù¼h_²Ä1¼h¦h´Á+²Ä2¼h¦h´Á¸ê®Æ§¨¤ºªº6­Ó¦³²Î¦rÀɮפºªºDÄæ&EÄæ~¥H¤H¤u¤ñ¹ï§¹²¦~
µ²ªGÀÉ®× : 7«e3¤j&¤p+0_0_1894´Á_6­Ó_1¦¸_Âù¼h_²Ä1¼h¦h´Á+²Ä2¼h¦h´Á~µn¿ýªº¤º®e§¹¥þ¥¿½T¡C
À³¸Ó¬O¦U³æÀɤέì½Æ¦XÀÉ~¨ä«e3¤j©M«e3¤pªº¤ñ¹ï°ò¼Æ¤£¬Û¦P¡A©Ò¥H¦X­p°Ïªº²Î­p¼Æ¦r¤~·|¤£¬Û¦P¡C
¤£¯à¥ú¾Ì·Q¹³¡A¥²¶·¹ê»Ú¤ñ¹ï~ÁÙ¬O¤£¯à°½Ãi

«D±`ÁÂÁ±zªº«ü¾É©MÀ°¦£~·P®¦

TOP

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

¦^´_ 10# samwang
¤£¦n·N«ä¡A¬Ý¨ì®ÄªGÀɮתºSheets("Sheet1")¤º®e~¦]¬°´Á¼Æ®æ¦¡ªº¤£¦P¡A
¦X­p°Ï(C2 : AY38)¤§²Î­p¼Æ¦rªº®t²§³º¦p¦¹¤§¤j¡A©Ò¥H¦A¼W¤U¦C¶i¶¥»Ý¨D~
Àµ½Ð«ü¾É¡IÁÂÁ±z¡I

±N·j´Mªº¦³(²Î)ÃöÁä¦rÀÉ®×~³£¦U²£¥Í1­Ó®ÄªGÀɮסC
¶i¶¥»Ý¨D_0926.rar (220.16 KB)
¥Ø«e¡G
A_·j´M(²Î)¦rÀÉ(¥DÀÉ_«e3¤p_§t0)_0926-Q°õ¦æ«á~²£¥Í1­Ó®ÄªGÀÉ®×~
7«e3¤j&¤p+0_0_1894´Á_6­Ó_1¦¸(¥Ø«e)

¶i¶¥»Ý¨D¡G
½Ð±NA_·j´M(²Î)¦rÀÉ(¥DÀÉ_«e3¤p_§t0)_0926-Q°õ¦æ«á~§ï¬°±N¨C­Ó¦³(²Î)ÃöÁä¦rªºÀÉ®×~¦U²£¥Í1­Ó®ÄªGÀÉ®×~
EX¡G7«e3¤j&¤p+0_0_1894´Á_100_1891-10+1890-10_1¦¸(»Ý¨D)¡F¡K¡K¡K¡F~¥»ÃD¦@¦³6­Ó®ÄªGÀɮסC
·sÀɮצWºÙ= "7«e3¤j&¤p+0" &¡K¡K.(¸Ô¦pªþ¥ó½d¨ÒÀÉ)

½Ð°Ý¡G»Ý¨D»yªkÀ³¸Ó¦p¦ó¼W½s¡H
Àµ½Ð½ç±Ð~ÁÂÁ±z¡I

TOP

¦^´_ 13# samwang
´ú¸Õ¦¨¥\
ÁÂÁ±zªº­@¤ß«ü¾É©M¼ö¤ßÀ°¦£~·P®¦

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-9-27 05:56 ½s¿è

¦^´_ 13# samwang
¤£¦n·N«ä¡A¦³1­Ó"°»¿ù"ªº°ÝÃD~
Àµ½Ð½ç¥¿ !  ÁÂÁ±z

»¡©ú :
¦b7C_0_1894´Á_50_1891-1893_10_1¦¸_1-49¸ê®Æ§¨¤º¡A¥H7RA_·j´M(¾÷)¦rÀÉ(¥DÀÉ)_0927°õ¦æ«á~²£¥Í3­Ó7RA²ÎÃöÁä¦rªº®ÄªGÀÉ(³o³¡¤ÀOK)¡F

¦³BUGªº³¡¥÷~
1_¥H¤W­z¸ê®Æ§¨¥~ªº7S_·j´M(²Î)¦rÀÉ(¥DÀÉ_«e3¤p_§t0)_0927°õ¦æ«á~µ{¦¡½X¦C55·|²£¥Í"°»¿ù"~¸Ô¦p¹Ï¤ù¡C
¥¼©R¦W.png
2021-9-27 05:45

µo²{­ì¦]¬O : ¥DÀÉ°õ¦æ®É¤]·|±N¤W­zªº7RA_·j´M(¾÷)¦rÀÉ(¥DÀÉ)_0927¶}±Ò¤F~
¦ý¤£¬O¨C¦¸³£·|¶}±Ò~µo¥ÍÀW²v¬ù50%¡C

2_¦³®É±NTEST_0927¸m©ñ"D¼Ñ"°õ¦æ~·|²£¥Í"°»¿ù"¡F¦³®É±NTEST_0927¸m©ñ"®à­±"°õ¦æ~¤Ï¦Ó¤£·|²£¥Í"°»¿ù"¡C
TEST_0927.rar (194.75 KB)
¥Ø«e§Úªº¸Ñ¨M¿ìªk¬O : ·í7RA_·j´M(¾÷)¦rÀÉ(¥DÀÉ)_0927°õ¦æ§¹²¦«á~±N¨ä²¾Â÷¤W­z¸ê®Æ§¨«á¡F
¦A°õ¦æ7S_·j´M(²Î)¦rÀÉ(¥DÀÉ_«e3¤p_§t0)_0927
¦ý¦P®É­n´ú¸Õªº¸ê®Æ§¨«Ü¦h~±`±`­n½Æ»s=>¶K¤W¡F¤S°Å¤U=>¶K¤W~«Ü¬OÀYµh¡C

³oºØ°ÝÃD¡A¦pªG¨S¦³´ú¸Õ¥X"°»¿ù"³B¡A¤@©w¤S·|µL¯e¦Ó²×~
©Ò¥H¯à§_«_¬Nªº³Ò¾r±z¦h´ú¸Õ´X¦¸~ ÁÂÁ±z

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD