¹®Á¦µÎ °°ÀÌ ¿Ã¸®´Âµ¥ ÀÚ²Ù ¿¡·¯°¡ ³ª³×¿ä..
Option Explicit
Sub main()
''''Çʼöº¯¼ö¼±¾ð Dim Àμö1, Àμö2, ¹öÆÛ, i As Variant
''''ÇÙ½É Dim ¿¹¾à¼ö·®, ¿¹¾à±Ý¾×, ÁöºÒ±Ý¾×(1000), ¿¹¾àÀÏÀÚ(1000), ÀϷùøÈ£(1000), temp, j, num As Variant
''''Àμöó¸® Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " ")))
''''ÀÔ·ÂÆÄÀÏ Open "C:\C_it\data\san0105.txt" For Input As #1
For i = 1 To Àμö1 Line Input #1, ¹öÆÛ If i >= Àμö1 Then ''''º¯¼öÀúÀå ¿¹¾à¼ö·® = Val(Mid(¹öÆÛ, 18, 5)) ¿¹¾à±Ý¾× = Val(Mid(¹öÆÛ, 23, 10))
''''¹è¿ If ¿¹¾à¼ö·® * ¿¹¾à±Ý¾× >= 7000000 Then num = num + 1 ÁöºÒ±Ý¾×(num) = Val(Mid(¹öÆÛ, 48, 10)) ÀϷùøÈ£(num) = Trim(Mid(¹öÆÛ, 1, 7)) ¿¹¾àÀÏÀÚ(num) = Trim(Mid(¹öÆÛ, 8, 10)) End If End If Next i ''''Á¤¿(ÁöºÒ±Ý¾×-¿À¸§Â÷¼ø, ¿¹¾àÀÏÀÚµ¿Àϰª ¹ß»ý½Ã ÀϷùøÈ£-¿À¸§Â÷¼ø) For i = 1 To num For j = i To num If ÁöºÒ±Ý¾×(i) > ÁöºÒ±Ý¾×(j) Or ¿¹¾àÀÏÀÚ(i) = ¿¹¾àÀÏÀÚ(j) And ÀϷùøÈ£(i) > ÀϷùøÈ£(j) Then temp = ÁöºÒ±Ý¾×(i) ÁöºÒ±Ý¾×(i) = ÁöºÒ±Ý¾×(j) ÁöºÒ±Ý¾×(j) = temp temp = ¿¹¾àÀÏÀÚ(i) ¿¹¾àÀÏÀÚ(i) = ¿¹¾àÀÏÀÚ(j) ¿¹¾àÀÏÀÚ(j) = temp temp = ÀϷùøÈ£(i) ÀϷùøÈ£(i) = ÀϷùøÈ£(j) ÀϷùøÈ£(j) = temp End If Next j Next i Close #1 ''''Ãâ·ÂÆÄÀÏó¸® Open "C:\C_it\data\Ans1.txt" For Output As #2 Print #2, Àμö1, Àμö2, ¿¹¾àÀÏÀÚ(1000) End Sub
2¹ø¹®Á¦
Option Explicit
Sub main()
''Çʼöº¯¼ö¼±¾ð Dim Àμö1, Àμö2, ¹öÆÛ, i As Variant
''ÇÙ½É Dim ¿¹¾à¼ö·®, ¿¹¾à±Ý¾×, ȸ¿ø±¸ºÐ, ÇÕ°è(1000), temp, j, num As Variant
''Àμöó¸® Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " ")))
''ÀÔ·ÂÆÄÀÏ Open "C:\C_it\data\san0105.txt" For Input As #1
For i = 1 To Àμö1 Line Input #1, ¹öÆÛ If i >= Àμö1 Then ''º¯¼öÀúÀå ¿¹¾à¼ö·® = Val(Mid(¹öÆÛ, 18, 5)) ¿¹¾à±Ý¾× = Val(Mid(¹öÆÛ, 23, 10)) ȸ¿ø±¸ºÐ = Trim(Mid(¹öÆÛ, 33, 1))
''¹è¿ If ȸ¿ø±¸ºÐ <> "0" And ȸ¿ø±¸ºÐ <> "1" Then num = num + 1 ÇÕ°è(num) = ¿¹¾à¼ö·® * ¿¹¾à±Ý¾× End If End If Next i ''Á¤¿ For i = 1 To num For j = i To num If ÇÕ°è(i) > ÇÕ°è(j) Then temp = ÇÕ°è(i) ÇÕ°è(i) = ÇÕ°è(j) ÇÕ°è(j) = temp End If Next j Next i Close #1 ''Ãâ·ÂÆÄÀÏó¸® Open "C:\C_it\data\Ans2.txt" For Output As #2 Print #2, Àμö1, Àμö2, ÇÕ°è(1) End Sub
|