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(¹öÆÛ, 43, 7)) ÇöÀç°¡ = Val(Mid(¹öÆÛ, 6, 6)) ÀüÀϺñ = Val(Mid(¹öÆÛ, 29, 6)) Á¾¸ñº°¿¹Ãø·ü = ÀüÀϺñ / ÇöÀç°¡ ''Ç¥±¸Çϱâ Select Case ¾÷Á¾ÄÚµå Case "A1" ¾÷Á¾º°¿¹Ãø·ü = 0.02 Case "A2" ¾÷Á¾º°¿¹Ãø·ü = 0.04 Case "A3" ¾÷Á¾º°¿¹Ãø·ü = -0.08 Case "A4" ¾÷Á¾º°¿¹Ãø·ü = -0.01 End Select ''Çհ豸Çϱâ If °Å·¡·® >= 500000 Then num = num + 1 ¿¹Ãø·ü = (¾÷Á¾º°¿¹Ãø·ü + Á¾¸ñº°¿¹Ãø·ü) / 2 ¿¹Ãø·ü = Int(¿¹Ãø·ü * 100) / 100 ÀÍÀÏ¿¹ÃøÁÖ°¡ = ÇöÀç°¡ * (1 + ¿¹Ãø·ü) ÀÍÀÏ¿¹ÃøÁÖ°¡ = Int(ÀÍÀÏ¿¹ÃøÁÖ°¡ / 10) * 10 ÇÕ°è = ÇÕ°è + ÀÍÀÏ¿¹ÃøÁÖ°¡ End If End If Next i ''Æò±Õ±¸ÇÏ±â Æò±Õ = Int(ÇÕ°è / num / 10) * 10 Close #1 ''Ãâ·ÂÆÄÀÏó¸® Open "c:\c_it\data\ans3.txt" For Output As #2 Print #2, Àμö1, Àμö2, Æò±Õ Close #2 End Sub
¿©±â±îÁö´Â Çߴµ¥ °á°ú°ªÀÌ Æ²¸®³×¿ä ¤Ð.¤Ð
¾îµð°¡ Ʋ¸°°ÅÁÒ??ºÎʵ右´Ï´Ù ¤Ð.¤Ð |