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

[µo°Ý] ¦p¦ó±q­ìÁ`»ù¤u§@ªíE15§ïÅÜÁ`­p¦Û°Êºâ¥XD2¸òD3³æ»ù©O?

[µo°Ý] ¦p¦ó±q­ìÁ`»ù¤u§@ªíE15§ïÅÜÁ`­p¦Û°Êºâ¥XD2¸òD3³æ»ù©O?

³Ì·s­ìÁ`»ù¤u§@ªí¥u¬O°Ñ¦Ò¹Lµ{,¹ê»Ú¬O¤£¦s¦bªº³á
³Ñ¤U¥u¦³­ìÁ`»ù¤u§@ªí¤@±i¦Ó¤w

¾Ç©f¤S¨Ó³Â·Ð¤j®a¤F

½Ð«Ó­ô/¬ü¤kª©¥D «Ó­ô/¬ü¤k¾Çªø¸ò¾Ç©j

À°¦£¾Ç©f§¹¦¨

ÁÂÁ¤F

metrostar305.rar (2.29 KB)

¸Ì­±ªº»¡©ú¤½¦¡¿ù°È

½Ð¨Ï¥Î¤ÀªRÂÅ¥»¥\¯à
&¦Û¤v­n½æ¦h¤Ö X Y
§Ú­Ì§â X=1
Y¤]¬Oºâªº¥X¨Ó¡A§Aıªº³o¼Ë¹ï¶Ü?

TOP

¸Ì­±ªº»¡©ú¤½¦¡¿ù°È

½Ð¨Ï¥Î¤ÀªRÂÅ¥»¥\¯à
&¦Û¤v­n½æ¦h¤Ö X Y
§Ú­Ì§â X=1
Y¤]¬Oºâªº¥X¨Ó¡A§Aıªº³o¼Ë¹ï ...
HUNGCHILIN µoªí©ó 2010-8-28 13:37



    ¦hÁ HUNGCHILIN  «Ó­ôª©¥D



½Ð«Ó­ô/¬ü¤kª©¥D «Ó­ô/¬ü¤k¾Çªø¸ò¾Ç©j

À°¦£¾Ç©f§¹¦¨
Àɮצ³§ó·s

D2(H2) ¸ò D3(H3) ­n¨ú¾ã¼Æ¤£­n¥ô¦ó¤p¼ÆÂI

metrostar305.rar (2.67 KB)

TOP

¦^´_ 3# metrostar

§Aªº»¡©úÁÙ¬O¨SÀY¨S§Àªº
¤â¤u´ú¸ÕÅܨº¼Æ¦r?
¤£ª¾¹D§A«ç»ò´úªº ³W«h?

§Ú§ï¤@§ï¤]¤£ª¾±q¦ó§ï°_ ¥u¦³HÄæ§ï¥|±Ë¤­¤J¾ã¼Æ IÄæ§ï¨ì­Ó¦ì¼ÆµL±ø¥ó±Ë¥h

    metrostar305.rar (2.19 KB)

TOP

¤â¤uªº¨ÆÅýµ{¦¡¥h¶]
¤£¹Lµ²ªG¸ò§A¤â¤u¤£¤@¼Ë
metrostar305.rar (8.51 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ metrostar ©ó 2010-8-30 16:38 ½s¿è

·sÁ`»ù/­ìÁ`»ù = ¨t¼Æ ©¹¤W©Î¬O©¹¤U¥hºâ
±µªñ¦b¨t¼Æ½d³ò³Ì¤p¥B¥X¨Ó³£¥²¶·¾ã¼Æ³£ºâ¦X®æ
³Ì¦n¯àºâ¥X¶V±µªñ ­ì D2 ¸ò D3 ªº­È¶V¤p¶V¦n¥B¥²¶·¾ã¼Æ

¨Ò¦p : ³o¤èªk¤]¥i¥H,ºâ¬O¥i¥H«j±j¥i¥H±µ¨ü,¦ý·Pı¤]¤£¬O²z·Q,¨â³æ»ù¦©°£®t¤£¦h

     D2 = 212123 , D3 = 342295 ³£¥i¥H²Å¦X 4175000
     D2 = 212126 , D3 = 342290 ³£¥i¥H²Å¦X 4175000
¾Ç©f§xÃø¬O»¡´N¤@­Ó¤@­Ó¥h¸Õ³£¨S¦³¤èªk¥i´`,©Ò¥H¤~¤W¨Ó¨D±Ï¤èªk

Hsieh ¶W¯Åª©¥D¤èªk¬O¥i¥H,¦³¨S¦³§ó²z·Q,³Ì¦n¯àºâ¥X¶V±µªñ ­ì D2 ¸ò D3 ªº­È¶V¤p¶V¦n¥B¥²¶·¾ã¼Æ ¨S¦³²Å¦X¥ªÃä´y­z , (¨âªÌ®t¶Z¤Ó¤j) ¨º´N§é¤¤ , ¥i¥H¶Ü? ÁÂÁ±z !

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-8-31 11:23 ½s¿è

¨S¬ÝÀ´³o¥y"³Ì¦n¯àºâ¥X¶V±µªñ ­ì D2 ¸ò D3 ªº­È¶V¤p¶V¦n¥B¥²¶·¾ã¼Æ"
¥[¤J¤ñ¨Ò¨D°_ºâ­È
  1. Sub yy()
  2. m = InputBox("¥Ø¼Ð", , 4175500)
  3. pr = m / ([C2] * [D2] + [C3] * [D3])
  4. k = Int([E2] * pr) + 1
  5. i = Int(k / [C2])
  6. y = (Val(m) - i * [C2]) / [C3]
  7.    Do Until y <> 0 And y = Int(y)
  8.       i = i - 1: y = (Val(m) - i * [C2]) / [C3]
  9.       If i = 0 Then MsgBox "µLªk¨ú±o": End
  10.     Loop
  11. [F2] = i: [F3] = y
  12. End Sub
½Æ»s¥N½X
metrostar305.rar (9.62 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§Úªºª©¥»¬O¥Î­Ëºâªº¡A¥ýºâ¥X­°»ù¤ñ²v«á¡A¦A­Ëºâ»ù®æ¡A³o¼ËÀ³¸Ó¥i¥H²Å¦X©Ò»Ý¡C

metrostar305.zip (7.3 KB)

TOP

°µ¨ì³o¼Ë¤w¸g«Üº¡·N¤F
·PÁ¼ӤW¦U¦ì«Ó­ôª©¥D¸ò¾Çªø

§¹¥þ¹F¨ì
¾Ç©f«D±`·P°Ê©O
±z­Ì¯u¬O¤Ó±j¤Ó±j¤F
·PÁ±z­Ì¨Ã¯¬¶P±z­Ì
©¯ºÖ¦n¹B¥Ã»·­°Á{±z­Ì¨­¤W

TOP

        ÀR«ä¦Û¦b : ¦Y­W¤F­W¡B­WºÉ¤Ü¨Ó¡A¨ÉºÖ¤FºÖ¡BºÖºÉ´d¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD