1¹ø¹®Á¦
Sub main()
''Çʼöº¯¼ö¼±¾ð
Dim Àμö1, Àμö2, i As Long
Dim ¹öÆÛ As String
''Çٽɺ¯¼ö¼±¾ð
Dim ´Ü°¡, °Å·¡Æ÷ÀÎÆ®, j, Temp, Num, ÇÕ°è(1000) As Long
Dim ºÐ·ùÄÚµå As String
''Àμöó¸®
Àμö1 = Val(Left(Command, InStr(Command, " ")))
Àμö2 = Val(Mid(Command, InStr(Command, " ")))
''ÀÔ·ÂÆÄÀÏó¸®
Open "C:\C_it\data\abc1118.txt" For Input As #1
For i = 1 To Àμö2
Line Input #1, ¹öÆÛ
If i >= Àμö1 Then
''ÇÙ½ÉÄÚµåÀÔ·Â
´Ü°¡ = Val(Mid(¹öÆÛ, 12, 3))
°Å·¡Æ÷ÀÎÆ® = Val(Mid(¹öÆÛ, 27, 3))
ºÐ·ùÄÚµå = Trim(Mid(¹öÆÛ, 18, 1))
If ºÐ·ùÄÚµå = "A" And ´Ü°¡ >= 30 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 i
Next i
Close #1
''Ãâ·ÂÆÄÀÏó¸®
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 Long
Dim ¹öÆÛ As String
''Çٽɺ¯¼ö¼±¾ð
Dim ´Ü°¡, °Å·¡Æ÷ÀÎÆ®, ÇÕ°è As Long
Dim ºÐ·ùÄÚµå As String
''Àμöó¸®
Àμö1 = Val(Left(Command, InStr(Command, " ")))
Àμö2 = Val(Mid(Command, InStr(Command, " ")))
''ÀÔ·ÂÆÄÀÏó¸®
Open "C:\C_it\data\abc1118.txt" For Input As #1
For i = 1 To Àμö2
Line Input #1, ¹öÆÛ
If i >= Àμö1 Then
''ÇÙ½ÉÄÚµåÀÔ·Â
´Ü°¡ = Val(Mid(¹öÆÛ, 12, 3))
°Å·¡Æ÷ÀÎÆ® = Val(Mid(¹öÆÛ, 27, 3))
ºÐ·ùÄÚµå = Trim(Mid(¹öÆÛ, 18, 1))
If ºÐ·ùÄÚµå = "A" And ´Ü°¡ >= 30 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
3¹ø¹®Á¦
Sub main()
''Çʼöº¯¼ö¼±¾ð
Dim Àμö1, Àμö2, i As Long
Dim ¹öÆÛ As String
''Çٽɺ¯¼ö¼±¾ð
Dim ÀÌÀÍÆ÷ÀÎÆ®, ¹è´Þ°Å¸®, Ãß°¡Æ÷ÀÎÆ®, ÇÕ°è As Long
Dim ¿î¼ÛÄÚµå As String
''Àμöó¸®
Àμö1 = Val(Left(Command, InStr(Command, " ")))
Àμö2 = Val(Mid(Command, InStr(Command, " ")))
''ÀÔ·ÂÆÄÀÏó¸®
Open "C:\C_it\data\abc1118.txt" For Input As #1
For i = 1 To Àμö2
Line Input #1, ¹öÆÛ
If i >= Àμö1 Then
''ÇÙ½ÉÄÚµåÀÔ·Â
¹è´Þ°Å¸® = Val(Mid(¹öÆÛ, 24, 3))
¿î¼ÛÄÚµå = Trim(Mid(¹öÆÛ, 19, 1))
''Ç¥ÀÔ·Â
If ¿î¼ÛÄÚµå = "A" Then
Ãß°¡Æ÷ÀÎÆ® = 5
ElseIf ¿î¼ÛÄÚµå = "B" Then
Ãß°¡Æ÷ÀÎÆ® = 15
ElseIf ¿î¼ÛÄÚµå = "C" Then
Ãß°¡Æ÷ÀÎÆ® = 20
End If
If ÀÌÀÍÆ÷ÀÎÆ® >= 30 Then
ÇÕ°è = ÇÕ°è + ¹è´Þ°Å¸® + Ãß°¡Æ÷ÀÎÆ®
End If
End If
Next i
Close #1
''Ãâ·ÂÆÄÀÏó¸®
Open "C:\C_it\data\Ans3.txt" For Output As #2
Print #2, Àμö1, Àμö2, ÇÕ°è
Close #2
End Sub
4¹ø¹®Á¦
Sub main()
''Çʼöº¯¼ö¼±¾ð
Dim Àμö1, Àμö2, i As Long
Dim ¹öÆÛ As String
''Çٽɺ¯¼ö¼±¾ð
Dim Àû¿ëÆ÷ÀÎÆ®, ¼ö·®, ÇÕ°è As Long
Dim ºÐ·ùÄÚµå As String
''Àμöó¸®
Àμö1 = Val(Left(Command, InStr(Command, " ")))
Àμö2 = Val(Mid(Command, InStr(Command, " ")))
''ÀÔ·ÂÆÄÀÏó¸®
Open "C:\C_it\data\abc1118.txt" For Input As #1
For i = 1 To Àμö2
Line Input #1, ¹öÆÛ
If i >= Àμö1 Then
''ÇÙ½ÉÄÚµåÀÔ·Â
¼ö·® = Val(Mid(¹öÆÛ, 15, 3))
ºÐ·ùÄÚµå = Trim(Mid(¹öÆÛ, 18, 1))
''Ç¥ÀÔ·Â
If ºÐ·ùÄÚµå = "A" Then
Àû¿ëÆ÷ÀÎÆ® = 5
ElseIf ºÐ·ùÄÚµå = "B" Then
Àû¿ëÆ÷ÀÎÆ® = 15
ElseIf ºÐ·ùÄÚµå = "C" Then
Àû¿ëÆ÷ÀÎÆ® = 20
End If
If ¼ö·® > =30 Then
ÇÕ°è = ÇÕ°è + ¼ö·® + Àû¿ëÆ÷ÀÎÆ®
End If
End If
Next i
Close #1
''Ãâ·ÂÆÄÀÏó¸®
Open "C:\C_it\data\Ans4.txt" For Output As #2
Print #2, Àμö1, Àμö2, ÇÕ°è
Close #2
End Sub |