ADV LAT LON TIME WIND PR STAT 1 12.00 -31.60 08/13/15Z 30 1005 TROPICALDEPRESSION 2 11.90 -33.10 08/13/21Z 30 1005 TROPICALDEPRESSION 3 12.00 -35.00 08/14/03Z 30 1005 TROPICALDEPRESSION 4 12.00 -36.80 08/14/09Z 30 1005 TROPICALDEPRESSION 5 11.70 -39.40 08/14/15Z 35 1004 TROPICALSTORM 6 11.60 -41.00 08/14/21Z 35 1004 TROPICALSTORM 7 12.00 -42.30 08/15/03Z 45 1000 TROPICALSTORM 8 12.20 -44.20 08/15/09Z 45 1000 TROPICALSTORM 9 12.40 -46.00 08/15/15Z 50 997 TROPICALSTORM 10 13.10 -47.90 08/15/21Z 55 994 TROPICALSTORM 11 13.10 -50.20 08/16/03Z 60 991 TROPICALSTORM 11A 13.20 -51.30 08/16/06Z 60 991 TROPICALSTORM 12 13.40 -52.30 08/16/09Z 65 987 HURRICANE-1 12A 13.50 -53.30 08/16/12Z 70 985 HURRICANE-1 13 13.70 -54.30 08/16/15Z 80 979 HURRICANE-1 13A 13.80 -55.50 08/16/18Z 80 970 HURRICANE-1 14 14.00 -56.50 08/16/21Z 85 979 HURRICANE-2 14A 14.00 -57.80 08/17/00Z 85 979 HURRICANE-2 15 14.10 -58.70 08/17/03Z 85 976 HURRICANE-2 15A 14.30 -59.80 08/17/06Z 85 976 HURRICANE-2 16 14.30 -60.90 08/17/09Z 85 976 HURRICANE-2 16A 14.40 -61.70 08/17/12Z 85 970 HURRICANE-2 17 14.60 -62.60 08/17/15Z 90 964 HURRICANE-2 18 14.80 -63.60 08/17/17Z 110 961 HURRICANE-3 19 15.00 -64.50 08/17/21Z 110 961 HURRICANE-3 19A 14.90 -65.10 08/18/00Z 115 946 HURRICANE-4 20 14.90 -65.90 08/18/03Z 125 937 HURRICANE-4 20A 15.00 -66.70 08/18/06Z 130 930 HURRICANE-4 21 15.10 -67.30 08/18/09Z 130 930 HURRICANE-4 21A 15.40 -67.90 08/18/12Z 130 930 HURRICANE-4 22 15.70 -68.60 08/18/15Z 130 929 HURRICANE-4 22A 15.90 -69.40 08/18/18Z 130 930 HURRICANE-4 23 16.10 -70.20 08/18/21Z 130 930 HURRICANE-4 23A 16.00 -71.00 08/19/00Z 130 920 HURRICANE-4 24 16.20 -71.70 08/19/03Z 125 918 HURRICANE-4 24A 16.40 -72.60 08/19/06Z 125 921 HURRICANE-4 25 16.60 -73.40 08/19/09Z 125 921 HURRICANE-4 25A 16.80 -74.30 08/19/12Z 125 921 HURRICANE-4 26 17.00 -75.10 08/19/15Z 125 926 HURRICANE-4 26A 17.10 -76.00 08/19/18Z 125 930 HURRICANE-4 27 17.30 -76.80 08/19/21Z 125 930 HURRICANE-4 27A 17.50 -77.80 08/20/00Z 125 930 HURRICANE-4 28 17.60 -78.80 08/20/03Z 125 925 HURRICANE-4 28A 17.70 -79.70 08/20/06Z 130 926 HURRICANE-4 29 17.70 -80.70 08/20/09Z 130 926 HURRICANE-4 29A 17.80 -81.50 08/20/12Z 130 926 HURRICANE-4 30 17.90 -82.40 08/20/15Z 130 925 HURRICANE-4 30A 18.00 -83.20 08/20/18Z 130 924 HURRICANE-4 31 18.20 -84.20 08/20/21Z 130 918 HURRICANE-4 31A 18.20 -85.10 08/21/00Z 135 915 HURRICANE-4 32 18.40 -86.00 08/21/03Z 140 914 HURRICANE-5 32A 18.50 -86.80 08/21/06Z 140 911 HURRICANE-5 33 18.70 -87.80 08/21/09Z 145 906 HURRICANE-5 33A 18.90 -88.70 08/21/12Z 110 935 HURRICANE-3 34 19.00 -89.60 08/21/15Z 90 950 HURRICANE-2 34A 19.20 -90.40 08/21/18Z 75 960 HURRICANE-1 35 19.40 -91.30 08/21/21Z 70 970 HURRICANE-1 35A 19.70 -92.20 08/22/00Z 70 970 HURRICANE-1 36 19.90 -93.00 08/22/03Z 70 979 HURRICANE-1 36A 20.10 -94.00 08/22/06Z 70 980 HURRICANE-1 37 20.30 -94.80 08/22/09Z 70 979 HURRICANE-1 37A 20.50 -95.50 08/22/12Z 80 976 HURRICANE-1 38 20.60 -96.30 08/22/15Z 85 979 HURRICANE-2 38A 20.50 -97.30 08/22/18Z 75 982 HURRICANE-1 39 20.50 -98.10 08/22/21Z 60 975 TROPICALSTORM 39A 20.50 -99.00 08/23/00Z 40 996 TROPICALSTORM 40 20.50 -100.00 08/23/03Z 30 1000 TROPICALDEPRESSION

EGN 1007 - Engineering Concepts and Methods Excel Assignment Module #3 Solve each problem on a separate labeled worksheet (with correctly labeled headers) under the same file name (one workbook). Submit your file via the assignment in Canvas before the deadline. Do Not send via Email 1. Import the text file hurricane.txt into Excel (it can be found in Canvas). Wind speeds given in the text file are in knots. Convert them into miles per hour (1 knot = 1.15078 mph). Add a column to the spreadsheet and label all columns with their proper units. Plot Wind Speed in knots versus Time and Wind Speed in mph versus time on the same plot. Axis should be labeled properly along with an appropriate title for the chart. A key shall be added to the plot too