Suppose the sequential file ALE.TXT contains the information shown in Table 1.1. Write a program to use the file to produce the Table 1.2 in which the baseball teams are in descending order by the percentage of games won. Note : A batting average can be displayed in standard form with FormatNumber(ave, 3, vbFalse).
Table 1.1 American League East games won and Lost in 2002.
Team Won Lost
Baltimore 67 95
Boston 93 69
New York 103 58
Tampa Bay 55 106
Toronto 78 84
Table 1.2 Final 2002 American League East standings.
American League East
Team Won Lost Percentage
New York 103 58 0.640
Boston 93 69 0.574
Toronto 78 84 0.481
Baltimore 67 95 0.414
Tampa Bay 55 106 0.342
Comments
Leave a comment