¿µÁø±³Àç¿¡ ÀÖ´Â ¸ðÀǰí»ç´Â °í±ÞÀ¯Çü±îÁö ¿Ïº®ÇÏ°Ô ¼ÒÈÇϽŠºÐ¸¸ º¸¼¼¿ä.
¿Ö³ÄÇϸé...¿µÁøÃâÆÇ»ç¿¡¼ ÀÓÀÇ·Î ¸¸µç ¹®Á¦À̹ǷΠ¹®Á¦¿Í ´äÀÌ ÀûÀýÇÏÁö ¾Ê´Â °æ¿ì°¡ ¸¹½À´Ï´Ù. À߸øÇÏ¸é ±âÃâ¹®Á¦·Î ¾î·Æ°Ô ½×¾Æ³õÀº °³³äµéÀÌ È寲¾îÁú ¼ö ÀÖ½À´Ï´Ù.
ÀÌ ¹®Á¦¿¡¼´Â Int() ¿Í Fix()ÀÇ »ç¿ë¿¡ ÀÖ¾î¼...¿µÁø±³Àç¿¡´Â ÀûÀýÄ¡ ¸øÇÑ ¹æ¹ýÀ¸·Î Ç®À̵Ǿú½À´Ï´Ù. È¥¶õÀÌ ¾ø¾úÀ¸¸é ÇÕ´Ï´Ù.
¾Æ·¡ÀÇ ¼Ò½º¸¦ Âü°íÇϼ¼¿ä.
Àμö°ª ´ëÀÔ¿¡ µû¸¥ °á°ú´Â=>( 469 569 5690 ) ±³Àç¿Í ´Ù¸§´Ï´Ù.
Option Explicit
Sub main()
''ÇʼöÀμö Dim Àμö1, Àμö2, ¹öÆÛ, i As Variant ''ÇÙ½ÉÀμö Dim ¾÷Á¾ÄÚµå, ¾÷Á¾º°¿¹ÃøÀ², Á¾¸ñº°¿¹ÃøÀ², ¿¹ÃøÀ², ÀÍÀÏ¿¹ÃøÁÖ°¡, ÀüÀϺñ, ÇöÀç°¡, °Å·¡·®, Æò±Õ, ÇÕ°è, Num As Variant ''ÀμöÁ¤ÀÇ Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " "))) ''ÀÔ·ÂÆÄÀÏ Open "c:\c_it\data\abc12.txt" For Input As #1 For i = 1 To Àμö2 Line Input #1, ¹öÆÛ If i >= Àμö1 Then ''''º¯¼öÁ¤ÀÇ ¾÷Á¾ÄÚµå = Trim(Mid(¹öÆÛ, 35, 2)) ÀüÀϺñ = Val(Mid(¹öÆÛ, 29, 6)) ÇöÀç°¡ = Val(Mid(¹öÆÛ, 6, 6)) °Å·¡·® = Val(Mid(¹öÆÛ, 43, 7)) ''''Ç¥±×¸®±â Select Case ¾÷Á¾ÄÚµå Case "A1" ¾÷Á¾º°¿¹ÃøÀ² = "0.02" Case "A2" ¾÷Á¾º°¿¹ÃøÀ² = "0.04" Case "A3" ¾÷Á¾º°¿¹ÃøÀ² = "-0.08" Case "A4" ¾÷Á¾º°¿¹ÃøÀ² = "-0.01" End Select If °Å·¡·® >= 500000 Then Á¾¸ñº°¿¹ÃøÀ² = ÀüÀϺñ / ÇöÀç°¡ ¿¹ÃøÀ² = (¾÷Á¾º°¿¹ÃøÀ² + Á¾¸ñº°¿¹ÃøÀ²) / 2 ¿¹ÃøÀ² = Fix(¿¹ÃøÀ² * 100) / 100 ÀÍÀÏ¿¹ÃøÁÖ°¡ = ÇöÀç°¡ * (1 + ¿¹ÃøÀ²) ÀÍÀÏ¿¹ÃøÁÖ°¡ = Fix(ÀÍÀÏ¿¹ÃøÁÖ°¡ / 10) * 10 Num = Num + 1 ÇÕ°è = ÇÕ°è + ÀÍÀÏ¿¹ÃøÁÖ°¡ End If End If Next i ''''Æò±Õ±¸Çϱâ If Num = 0 Then Æò±Õ = 0 Else Æò±Õ = Fix(ÇÕ°è / Num / 10) * 10 End If Close #1 ''''Ãâ·ÂÆÄÀÏ Open "c:\c_it\data\ans3.txt" For Output As #2 Print #2, Àμö1, Àμö2, Æò±Õ Close #2 End Sub
|