´äÀÌ ¾û¶×ÇÏ°Ô ³ª¿Í¿ä..
¹¹°¡ À߸øµÈ°Ç°¡¿ä..
1¹ø¹®Á¦ Sub main()
''Çʼöº¯¼ö¼±¾ð Dim Àμö1, Àμö2, i, ¹öÆÛ As Variant ''Çٽɺ¯¼ö¼±¾ð Dim ´ã´çÄÚµå, ¿µ¾îÁ¡¼ö, ¼öÇÐÁ¡¼ö, Çйø(1000), ÇÕ°è(1000), j, temp, num As Variant
''ÀμöÀúÀå Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " ")))
''ÀÔ·ÂÆÄÀÏó¸® Open "c:\c_it\data\abc1115.txt" For Input As #1 For i = 1 To Àμö2 Line Input #1, ¹öÆÛ If i >= Àμö1 Then
''º¯¼öÀúÀå ´ã´çÄÚµå = Trim(Mid(¹öÆÛ, 29, 1)) ¿µ¾îÁ¡¼ö = Val(Mid(¹öÆÛ, 14, 3)) ¼öÇÐÁ¡¼ö = Val(Mid(¹öÆÛ, 17, 3))
If ´ã´çÄÚµå = "A" Or ´ã´çÄÚµå = "C" Then num = num + 1 ÇÕ°è(num) = ¿µ¾îÁ¡¼ö + ¼öÇÐÁ¡¼ö Çйø(num) = Val(Mid(¹öÆÛ, 1, 6)) End If End If
Next i
''ÀÚ·áÁ¤·Ä
For i = 1 To num For j = 1 To num
If ÇÕ°è(i) < ÇÕ°è(j) Or (ÇÕ°è(i) = ÇÕ°è(j) And Çйø(i) > Çйø(j)) Then
temp = ÇÕ°è(i) ÇÕ°è(i) = ÇÕ°è(j) ÇÕ°è(j) = temp
temp = Çйø(i) Çйø(i) = Çйø(j) Çйø(j) = temp
End If Next j Next i ''Ãâ·ÂÀÚ·áÀÔ·Â Open "c:\c_it\data\ans1.txt" For Output As #2 Print #2, Àμö1, Àμö2, Çйø(5) Close #2 End Sub
2¹ø¹®Á¦ Sub main()
''Çʼöº¯¼ö¼±¾ð Dim Àμö1, Àμö2, i, ¹öÆÛ As Variant ''Çٽɺ¯¼ö¼±¾ð Dim ´ã´çÄÚµå, ¿µ¾îÁ¡¼ö, ¼öÇÐÁ¡¼ö, ÃÖ´ë°ª, ÇÕ°è As Variant
''ÀμöÀúÀå Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " ")))
''ÀÔ·ÂÆÄÀÏó¸® Open "c:\c_it\data\abc1115.txt" For Input As #1 ''ÃÖ´ë°ª ÃʱâÈ ÃÖ´ë°ª = 0
For i = 1 To Àμö2 Line Input #1, ¹öÆÛ If i >= Àμö1 Then
''º¯¼öÀúÀå ´ã´çÄÚµå = Trim(Mid(¹öÆÛ, 29, 1)) ¿µ¾îÁ¡¼ö = Val(Mid(¹öÆÛ, 14, 3)) ¼öÇÐÁ¡¼ö = Val(Mid(¹öÆÛ, 17, 3))
If ´ã´çÄÚµå = "A" Or ´ã´çÄÚµå = "C" And ÃÖ´ë°ª < ¿µ¾îÁ¡¼ö + ¼öÇÐÁ¡¼ö Then
ÃÖ´ë°ª = ¿µ¾îÁ¡¼ö + ¼öÇÐÁ¡¼ö End If
End If
Next i
Close #1
''Ãâ·ÂÀÚ·áÀÔ·Â Open "c:\c_it\data\ans2.txt" For Output As #2 Print #2, Àμö1, Àμö2, ÃÖ´ë°ª Close #2
End Sub
|