µÎ¹®Á¦ ´Ù Æò±Õ±¸ÇÏ´Â ¹®Á¦ÀÔ´Ï´Ù. ºÁÁÖ¼¼¿ä~ ¾î¶²°Ô Ʋ·È´ÂÁö¿ä.. ±×¸®°í Àú³á¿¡ ¸ðÀǰí»ç ½ÅûÇߴµ¥¿ä Ç÷ÎÇǵð½ºÄÏ ¿¡·¯ÀÎ°Í °°Àºµ¥¿ä... ¾ÐÃàÇϰí Àü¼Û¸¸ ÇØµµ ¼±»ý´Ô²² Á¦ ¼Ò½º°¡ °¡Áö¾Ê³ª¿ä?
¹®Á¦1
Option Explicit
Sub Main()
''''''''Çʼöº¯¼ö¼±¾ð Dim Àμö1, Àμö2, k, ¹öÆÛ As Variant ''''''''Çٽɺ¯¼ö¼±¾ð Dim ±ØÀåÄÚµå, ÇÒÀαݾ×, ¿¹¸ÅÀÏÀÚ, ¿¹¸Å¼ö·®, ¿¹¸Å´Ü°¡, ÇÕ°è, Æò±Õ, num As Variant ''''''''Àμöó¸® Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " "))) ''''''''ÀÔ·ÂÆÄÀÏó¸® Open "c:\c_it\data\abc18.txt" For Input As #1 For k = 1 To Àμö2 Line Input #1, ¹öÆÛ If k >= Àμö1 Then ''''''''º¯¼öÀúÀå ±ØÀåÄÚµå = Trim(Mid(¹öÆÛ, 6, 2)) ¿¹¸ÅÀÏÀÚ = Trim(Mid(¹öÆÛ, 18, 2)) ¿¹¸Å¼ö·® = Val(Mid(¹öÆÛ, 8, 2)) ¿¹¸Å´Ü°¡ = Val(Mid(¹öÆÛ, 10, 4)) Select Case ±ØÀåÄÚµå Case "AD" ÇÒÀÎ±Ý¾× = 500 Case "BK" ÇÒÀÎ±Ý¾× = 300 Case "MU" ÇÒÀÎ±Ý¾× = 250 Case "CV" ÇÒÀÎ±Ý¾× = 700 End Select If ¿¹¸ÅÀÏÀÚ = "09" Then ÇÕ°è = ÇÕ°è + (¿¹¸Å¼ö·® * ¿¹¸Å´Ü°¡ - ÇÒÀαݾ×) End If End If Next k ''''''''Æò±Õ±¸Çϱâ num = num + 1 Æò±Õ = ÇÕ°è / num Æò±Õ = Fix(Æò±Õ) Close #1 ''''''''Ãâ·ÂÆÄÀÏó¸® Open "c:\c_it\data\ans3.txt" For Output As #2 Print #2, Àμö1, Àμö2, Æò±Õ Close #2 End Sub
¹®Á¦2.
Option Explicit
Sub Main()
''''''''Çʼöº¯¼ö¼±¾ð Dim Àμö1, Àμö2, k, ¹öÆÛ As Variant ''''''''Çٽɺ¯¼ö¼±¾ð Dim »óǰºÐ·ùÄÚµå, ¼ö·®, ¿ùÃÑÆÇ¸Å±Ý¾×, Æò±Õ, ÇÕ°è, NUM As Variant ''''''''Àμöó¸® Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " "))) ''''''''ÀÔ·ÂÆÄÀÏó¸® Open "c:\c_it\data\abc08.txt" For Input As #1 For k = 1 To Àμö2 Line Input #1, ¹öÆÛ If k >= Àμö1 Then ''''''''º¯¼öÀúÀå »óǰºÐ·ùÄÚµå = Trim(Mid(¹öÆÛ, 5, 1)) ¼ö·® = Val(Mid(¹öÆÛ, 13, 3)) ¿ùÃÑÆÇ¸Å±Ý¾× = Val(Mid(¹öÆÛ, 26, 5)) If »óǰºÐ·ùÄÚµå = "D" And ¼ö·® <= 300 Then ''''''''NUM=NUM+1 ÇÕ°è = ÇÕ°è + ¿ùÃÑÆÇ¸Å±Ý¾× End If ''''''''Æò±Õ±¸Çϱâ NUM = NUM + 1 Æò±Õ = ÇÕ°è / NUM Æò±Õ = Fix(Æò±Õ) End If Next k Close #1 ''''''''Ãâ·ÂÆÄÀÏó¸® Open "c:\c_it\data\ans3.txt" For Output As #2 Print #2, Àμö1, Àμö2, Æò±Õ Close #2 End Sub
|