Á» ¾Ë·ÁÁÖ¼¼¿ä - -;
3¹ø ¼Ò½ºÄÚµù
Option Explicit
Sub Main() ''Çʼö º¯¼ö ¼±¾ð Dim Àμö1, Àμö2, i, ¹öÆÛ As Variant ''ÇÙ½É º¯¼ö ¼±¾ð Dim »ý¹°Á¡¼ö, ¼ºÃëµµ, ÃÑÁ¡, Áö¸®Á¡¼ö, Çйø, ÃÖ´ëÇйø, ÃÖ¼Ò°ª, üÀ°Á¡¼ö, Temp As Variant ''Àμö ó¸® Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " "))) ''ÀÔ·Â ÆÄÀÏ Ã³¸® Open "c:\c_it\data\abc09.txt" For Input As #1 ''ÃÖ¼Ò°ª ÃʱâÈ ÃÖ¼Ò°ª = 999999999 For i = 1 To Àμö2 Line Input #1, ¹öÆÛ If i >= Àμö1 Then ''º¯¼ö ÀúÀå »ý¹°Á¡¼ö = Val(Mid(¹öÆÛ, 11, 3)) ¼ºÃëµµ = Trim(Mid(¹öÆÛ, 27, 1)) ÃÑÁ¡ = Val(Mid(¹öÆÛ, 29, 3)) Áö¸®Á¡¼ö = Val(Mid(¹öÆÛ, 8, 3)) Çйø = Val(Mid(¹öÆÛ, 1, 6)) ''ÃÖ´ëÇйøÀÇ Ã¼À°Á¡¼ö±¸Çϱâ If »ý¹°Á¡¼ö < 40 And ¼ºÃëµµ = "C" Then If ÃÖ¼Ò°ª > (ÃÑÁ¡ - Áö¸®Á¡¼ö) / 4 Or _ (ÃÖ¼Ò°ª = (ÃÑÁ¡ - Áö¸®Á¡¼ö) / 4 And ÃÖ´ëÇйø < Çйø) Then ÃÖ¼Ò°ª = (ÃÑÁ¡ - Áö¸®Á¡¼ö) / 4 ÃÖ´ëÇйø = Çйø üÀ°Á¡¼ö = Val(Mid(¹öÆÛ, 14, 3)) End If 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
4¹ø ¼Ò½ºÄÚµù
Option Explicit
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\abc09.txt" For Input As #1 For i = 1 To Àμö2 Line Input #1, ¹öÆÛ If i >= Àμö1 Then ''º¯¼ö ÀúÀå ¼ºÃëµµ = Trim(Mid(¹öÆÛ, 27, 2)) ÃÑÁ¡ = Val(Mid(¹öÆÛ, 29, 3)) Áö¿ªÄÚµå = Val(Mid(¹öÆÛ, 7, 1)) ''Ç¥ ±¸Çϱâ Select Case ¼ºÃëµµ Case "A1" Ãß°¡Á¡¼ö = 10 Case "A2" Ãß°¡Á¡¼ö = 9 Case "A3" Ãß°¡Á¡¼ö = 8 Case "B1" Ãß°¡Á¡¼ö = 7 Case "B2" Ãß°¡Á¡¼ö = 6 Case "B3" Ãß°¡Á¡¼ö = 5 Case "C1" Ãß°¡Á¡¼ö = 4 Case "C2" Ãß°¡Á¡¼ö = 3 Case "C3" Ãß°¡Á¡¼ö = 2 End Select ''Çհ豸Çϱâ If ÃÑÁ¡ >= 200 And Áö¿ªÄÚµå = "B" Then ÇÕ°è = ÇÕ°è + ((ÃÑÁ¡ + Ãß°¡Á¡¼ö) / 5) End If End If Next i Close #1 ''Ãâ·Â ÆÄÀÏ Ã³¸® Open "c:\c_it\data\ans4.txt" For Output As #2 Print #2, Àμö1, Àμö2, Int(ÇÕ°è) Close #2 End Sub
|