¹®Á¦¸¦ ºÙ¿©³ÖÀ¸´Ï..°è¼Ó ¿À·ù°¡ ³ª¼..ÇÒ¼ö¾øÀÌ ¹®Á¦´Â ¸ø³Ö¾ú½À´Ï´Ù¤Ð¤Ð
¿©±â ±âÃâ¹®Á¦ ºÁµµ...»ê¾÷±â»ç 10¿ù 31ÀϱîÁö¸¸ ÀÖ°í..11¿ù 1ÀÏ ÀÚ·á´Â ¾ø´õ¶ó±¸¿ä...
¼Ò½ºÁ» º¸°í½Í¾î¿ä..
¿À·ùµµ ¾È³ª°í °á°ú°ªÀÌ ¸ðµÎ Ʋ¸®°Ô ³ª¿Í¿ä...¤Ð¤Ð ³¾ÀÌ ¼ÉÀε¥..ÀÌ·¸°Ô Çì¸Å°í ÀÖÀ¸´Ï;;
¾îµð°¡ Ʋ·È´ÂÁö Á» °¡¸£ÃÄÁÖ¼¼¿ä...¤Ð¤Ð
È¥ÀÚ °è¼Ó Çì¸Å´Ù µµÀúÈ÷ °¨À» ¸øÀâ¾Æ¼ ÀÌ·¸°Ô ¹®Àǵ帳´Ï´Ù..
¹®Á¦3>
''''Çʼöº¯¼ö¼±¾ð 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\abc0109.txt" For Input As #1 For i = 1 To Àμö2 Line Input #1, ¹öÆÛ If i >= Àμö1 Then ''''º¯¼öÀúÀå Åõ¼÷±â°£ = Val(Mid(¹öÆÛ, 15, 2)) ´©ÀûÁ¡¼ö = Val(Mid(¹öÆÛ, 41, 5)) ¿¹¾àÀÏÀÚ = Trim(Mid(¹öÆÛ, 12, 1)) If ¿¹¾àÀÏÀÚ = "9" 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
¹®Á¦4>
''''Çʼöº¯¼ö¼±¾ð 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\abc0109.txt" For Input As #1 For i = 1 To Àμö2 Line Input #1, ¹öÆÛ If i >= Àμö1 Then ''''º¯¼öÀúÀå Åõ¼÷±â°£ = Val(Mid(¹öÆÛ, 15, 2)) °í°´±¸ºÐÄÚµå = Trim(Mid(¹öÆÛ, 17, 2)) ¿¹¾à½Ç±¸ºÐÄÚµå = Trim(Mid(¹öÆÛ, 39, 2)) ÇÒÀÎ±Ý¾× = Val(Mid(¹öÆÛ, 30, 4)) ''''ǥó¸® Select Case °í°´±¸ºÐÄÚµå Case "HA" Ãß°¡»ç¿ë±Ý¾× = 1530 Case "VP" Ãß°¡»ç¿ë±Ý¾× = 2100 Case "YE" Ãß°¡»ç¿ë±Ý¾× = 2340 Case "IN" Ãß°¡»ç¿ë±Ý¾× = 3100 End Select ''''Çհ豸Çϱâ If Åõ¼÷±â°£ >= 12 Or ¿¹¾à½Ç±¸ºÐÄÚµå = "AZ" 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
sub main ¹°·Ð ³Ö¾ú°í¿ä..
|