°á°ú°ªÀÌ 0À̳׿ä..¤Ñ.¤Ì
¾îµð°¡ À߸øµÈ °Ç°¡¿ä?
ÀÌÁ¤µµ¸éÀº ³À̵µ°¡ Áß±ÞÀΰÅÁÒ?
--------------------------------------------------------------
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(¹öÆÛ, 27, 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 And _ Á¾¸ñº°¿¹ÃøÀ² = ÀüÀϺñ / ÇöÀç°¡ And _ ¿¹ÃøÀ² = (¾÷Á¾º°¿¹ÃøÀ² + Á¾¸ñº°¿¹ÃøÀ²) / 2 And _ ÀÍÀÏ¿¹ÃøÁÖ°¡ = ÇöÀç°¡ * (1 + ¿¹ÃøÀ²) Then Num = Num + 1 ÇÕ°è = ÇÕ°è + Int(ÀÍÀÏ¿¹ÃøÁÖ°¡) End If End If Next i ''Æò±Õ±¸Çϱâ If Num = 0 Then Æò±Õ = 0 Else Æò±Õ = Round(ÇÕ°è / Num, 2) End If Close #1
''Ãâ·ÂÆÄÀÏ Open "c:\c_it\data\ans3.txt" For Output As #2 Print #2, Àμö1, Àμö2, Æò±Õ Close #2 End Sub
|