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

[µo°Ý] ¸¨ÂI°ÝÃD....(§Ú¥Ø«e±q¥¼¨ì¹Lªº»â°ì)

A¡BC°Ïµ¹ªº®y¼ÐÂI¬°«Ê³¬½u¬q¡A¤ñ¸û®e©ö³B²z
B°Ï·Pı¤]¬O¥|Ãä§Î¦n¹³¦bA¡BC°Ï¤U¤è¡A®y¼ÐÂI¤£¬O«Ê³¬½u¬q»Ý­n¸ÉÂI©ÎÃB¥~³B²z
B°Ïªº´y­z¥i§_¥t¦æ¸ÉÂI(®y¼Ð)³B²z

­ì«h¤W¥|Ãä«Ê³¬°Ï°ì¥i¥H¥Î¤¤¤ß»PÀˬdÂI³s¤@ª½½u¡AÀˬd»P¥|Ãä½u¬O§_¬Û¥æ¡A¥þ³¡¨S¦³¬Û¥æ´N¬O¦b¸Ì­±¡A»P¥ô¤@½u¬Û¥æªí¥Ü¦b¥~­±¡C

µ¥§Ú©ú¤Ñ¦^¨Ó¦A¸Ô²Ó¬ã¨s
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# stillfish00


  stillfish00¤j´£¨Ñªº¸ê®Æ«Ü§¹¾ã¡AÁÂÁ§A´£¨Ñ¨º»ò§¹¾ãªººô­¶¸ê°T¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# stillfish00


    ¹ªÀy¤@¤U¡AC»y¨¥§ï¬°VBA¡A­è¦n¥i¥H°Ñ¦Ò¡AÁÂÁÂ
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ui123

stillfish00 ¤jªº¥\¤O°ª±j¡A¨Ï¥Î¦Û­q¨ç¼ÆÀ³¸Ó³Ì¦nªº¤è¦¡

ºô­¶¤¤©Ò­zªº¤èªk¤ñ§ÚÁ¿ªº¦Ò¼{¤èªkÁÙ­n¥¿½T

§PÂ_¤@­ÓÂI¬O§_¦b²³æ¦hÃä§Î¤º³¡
±qµ¹©wÂI¶}©l¡A©¹ÀH«K¤@­Ó¤è¦V¡]¹ê§@®É²ßºD¤ô¥­©¹¥k¡^®g¥X¤@±øµL­­ªø®g½u¡A¬Ý¬Ý¬ï¹L¦h¤Ö±øÃä¡C¦pªG¬ï¹L°¸¼Æ¦¸¡Aªí¥ÜÂI¦b²³æ¦hÃä§Î¥~³¡¡F¦pªG¬ï¹L©_¼Æ¦¸¡Aªí¥ÜÂI¦b²³æ¦hÃä§Î¤º³¡¡C
­n¤p¤ß³B²z®g½u¬ï¹L³»ÂI¡B®g½u»PÃä­«Å|ªº±¡ªp¡C¤]­n¤p¤ß³B²zÂI¦b¦hÃä§ÎÃä¬É¤Wªº±¡ªp¡C
®É¶¡½ÆÂø«×¬° O(N) ¡A N ¬°Â²³æ¦hÃä§Îªº³»ÂI¼Æ¥Ø¡C

§Ú¦A¨Ó¬ã¨s¥i§_¥Î¤½¦¡¨M¸Ñ¡A¦ý·|¤ñVBA¬Ý°_¨Ó§ó½ÆÂø¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# stillfish00

¤£¦n·N«ä¡A­É¸Óª©¸ê®Æ

stillfish00¤j:
¥i§_½Ð§A¦AÀ°¦£¼g A¡BB¡BCµ¥°Ï°ì­±¿nªº¦Û­q¨ç¼Æ¡A·P®¦¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 12# stillfish00


¦¬¨ì¤F¡A·PÁ¸U¤À
ªì¨B´ú¸Õ OK

§Ú­Ì¤uµ{³]­p­nºâ¤@¨Ç­±¿n¡B§Î¤ß¡BºD©Ê¯xIx¡B Iy¡BIxy µ¥
µ{¦¡³£¬ODOS®É´ÁFORTRAN¼gªº¡A¦bWIN7¡BWIN8¨t²ÎµLªk°õ¦æ(¶V¨Ó¶V¤£¬Û®e)¡C
­è·QÂରEXCEL VBA¨Ó³B²z¡A¬Ý¨Ó§A¤w¸gÀ°§Ú§¹¦¨²Ä¤@¨B¤F¡A·PÁ¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 15# ui123

µ{¦¡©ñ¦b Module1
A°Ï­±¿n =PolyArea(C4:D8)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD