Below is the DailyRainfall.txt

Home Insert Cut Copy Formulas Data 10 -A- A Review = = View = General E P Page Layout Arial BIU fx C D Ep Wrap Text Merge & Center Paste Format Conditional Format Formatting as Table co Sty 013 v M N O P Q R 1 2 3 4 X A B E F G H I J K Import the Daily Rainfall.txt file. Separate the data fields into columns Which characters are used in the Flag1 field? Copy all the records that have rainfall data (Prop) greater than 0.3 and a minimum temperature greater than 70 (Tmin) into a separate block. Create a table, in a separate sheet, listing the maximum temperature (Tmax) for each month in each year. Include column headings and do not change the order of the records. Tmin Tobs Tmean Flag1 86 70 78 68 Cdd Hdd Prop 13 0 90 60 80 79 74 10 77 78 0 79 73 ! on on 73 0 11 76 69 17 78 77 79 70 O 74 68 0.53 0.09 0 0 0 0 0 0 0 1.34 0 0 0 7 COOPID WBANID 8 87886 92806 87886 92806 2806 87886 92806 87886 92806 87886 92806 13 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 BN year month day Tmax 2006 11 1 2006 112 2006 113 2006 2006 11 2006 2006 2006 11 2006 2006 10 2006 2006 2006 2006 2006 15 2006 2006 2006 2006 2006 11 2006 2006 2006 2006 2006 2006 26 2006 2006 2006 2006 2006 2006 FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFRE OOOU WOU 18 60 69 10 60 57 0.03 0.03 57 1 0 11 0 75 68 69 27 77 28 75 76 72 75 10 0 79 2 $5. COOPID, WBANID, Prelim, year, month, day, Tmax, Tmin, Tobs, Tmean, Cdd, Hdd, Pr.se, Flag1, Snow, Flag2, Snwd 87886,92806, 2006, 11, 1,86, 70, 72, 78,13,0,0 ,0, ,0 87886,92806, 2006, 11,2,80, 68, 70, 74,9,0,0, , , ,0 87886,92806, , 2006, 11, 3, 79, 63, 64,71,6, 0, 0, 0, ,0 87886,92806, 2006, 11,4,77,63,68, 70,5, 0, 0, 0, ,0 87886,92806, , 2006, 11,5, 78, 65, 69, 72,7,0,0, ,0, ,0 87886,92806, , 2006, 11, 6, 79, 67, 69, 73,8,0,0, ,0, ,0 87886,928$06, 2006, 11, 7,72,68,68,70,5, 0, 0.53, ,0, ,0 87886,92806, 2006, 11, 8, 73, 66, 67, 70,5, 0, 0.09, ,0, ,0 87886,92806, 2006, 11,9, 76,62,62,69,4,,,,,,0 87886,92806, 2006, 11, 10,78,61,66,70,5, 0, 0, ,0, ,0 87886,92806, , 2006, 11, 11, 77,63,68,70,5,,,,,, 87886,92806, 2006, 11, 12, 79,61,61,70,5, 0, 0, , , , 87886,92806, 2006, 11, 13, 71,59,63,65, 0, 0, 0, 0, ,0 87886,92806, 2006, 11, 14, 74,61,69,68,3,,,,,, 87886,92806, ,2006, 11, 15, 80, 63, 69, 72,7,0,0, ,0, ,0 87886,92806, , 2006, 11, 16, 73, 66, 67, 70,5, 0,1.34, ,, 87886,92806, , 2006, 11, 17, 67,56,58,62,0,3,,,,, 87886,92806, 2006, 11, 18,65,54,58,60,0,5,,,,, 87886,92806, 2006, 11, 19,69, 55, 56, 62,0,3, , , , , 87886,92806, 2006, 11,20,60,50,52,55, 6, 10, 0.03, ,0, 87886,92806, , 2006,11,21,57,46,53,52,0,13,0.03, ,, 87886, 92806, 2006, 11,22,63,51,53,57,0,8,0, ,0, ,0 87886,92806, 2006,11, 23, 71,53,57,62,0,3,0, ,0, 87886,92806, , 2006, 11, 24, 73, 54, 62, 64,0,1,0, ,, 87886,92806, 2006, 11, 25, 74,58, 64, 66,1,0,0, ,0, 87886,92806, 2006, 11,26,75, 61, 64,68,3,0,0, ,0, 87886,92806, 2006, 11,27, 77, 61, 68, 69, 4,0,0, ,0, ,0 87886,92806, 2006, 11, 28, 75, 66, 68, 71,6, 0, 0, ,0, ,0 87886,92806, 2006, 11, 29, 76, 67, 69, 72, 7,0,0, ,0, ,0 87886,92806, 2006, 11,30, 81,68, 71, 75, 10,0,0, ,0, ,0 87886,92806, 2006, 12, 1, 79, 69, 73, 74,9,0,, ,0, ,0 87886,92806, 2006, 12, 2, 82,69, 73, 76,11,0,0, ,0, ,0 87886,92806, , 2006, 12, 3, 79,69,69,74,9,0,0, ,0, ,0 87886,92806, 2006, 12,4,69,59,59,64,0,1,0, 10, ,0 87886,92806, , 2006, 12,5, 71,53, 61, 62,0,3,0, ,0, ,0 87886,92806, 2006, 12,6,75,60,66,68,3,0,o,,,, 87886,92806, , 2006, 12,7,72,59,59,66,1,0,0, , , , 87886,92806, , 2006, 12,8,59,47,47,53,0, 12, , ,0, , 87886,92806, 2006, 12,9,68,47,59,58,0,7, , , , ,0 87886,92806, , 2006, 12, 10, 70,55,63,63,0,2,, ,,, 87886,92806, 2006, 12, 11, 71, 61, 65, 66,1,0,0, ,0, ,0 87886,92806, 2006, 12, 12,73,61,66,67,2,0,0, ,0, ,0 87886,92806, , 2006, 12, 13, 73, 64, 68, 69,4,0,0.03, , , , 87886,92806, 2006, 12, 14, 74,66,68, 70,5, 0, 0.09, , , , 87886,92806, ,2006, 12, 15, 71,63,63,67,2,,,,,, 87886,92806, 2006, 12, 16,73,63,68, 68,3,,,,,, 87886,92806, 2006, 12, 17,77,65,69,71,6,0,0, ,0, ,0 87886,92806, , 2006, 12, 18, 77,66,68,72,7,0,0,,,, 87886,92806, 2006, 12, 19,77,64,68, 71,6, 0,,,,, 87886,92806, 2006, 12, 20, 75, 65, 67, 70,5, 0, 0, 0, ,0 87886,92806 ,2006, 12,21,77, 66, 69, 72, 7,0,0, ,0, ,0 87886,92806, , 2006, 12, 22, 79, 69, 73, 74,9,0,0.07, ,, 87886,92806, , 2006, 12, 23, 79, 67, 70, 73,8,0,0.92, ,0, 87886,92806, , 2006, 12, 24, 79, 68, 71, 74,9,0,0.01, ,0, ,0 87886,92806, 2006, 12, 25, 76,66,68, 71,6,9,1.75, , , , 87886,92806, , 2006, 12, 26,68,56,56,62,0,3, 0.09, , , , 87886,92806, , 2006, 12, 27,59,48,56,54,0,11,, ,0, ,0 87886,92806, , 2006, 12, 28, 73,55,64,64,0,1,0, ,0, ,0 87886,92806, , 2006, 12, 29, 75, 62, 67, 69,4,0,0, ,0, ,0 87886,92806, 2006, 12,30,78,66,69,72,7,0,0, ,0, ,0 Home Insert Cut Copy Formulas Data 10 -A- A Review = = View = General E P Page Layout Arial BIU fx C D Ep Wrap Text Merge & Center Paste Format Conditional Format Formatting as Table co Sty 013 v M N O P Q R 1 2 3 4 X A B E F G H I J K Import the Daily Rainfall.txt file. Separate the data fields into columns Which characters are used in the Flag1 field? Copy all the records that have rainfall data (Prop) greater than 0.3 and a minimum temperature greater than 70 (Tmin) into a separate block. Create a table, in a separate sheet, listing the maximum temperature (Tmax) for each month in each year. Include column headings and do not change the order of the records. Tmin Tobs Tmean Flag1 86 70 78 68 Cdd Hdd Prop 13 0 90 60 80 79 74 10 77 78 0 79 73 ! on on 73 0 11 76 69 17 78 77 79 70 O 74 68 0.53 0.09 0 0 0 0 0 0 0 1.34 0 0 0 7 COOPID WBANID 8 87886 92806 87886 92806 2806 87886 92806 87886 92806 87886 92806 13 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 87886 92806 BN year month day Tmax 2006 11 1 2006 112 2006 113 2006 2006 11 2006 2006 2006 11 2006 2006 10 2006 2006 2006 2006 2006 15 2006 2006 2006 2006 2006 11 2006 2006 2006 2006 2006 2006 26 2006 2006 2006 2006 2006 2006 FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFRE OOOU WOU 18 60 69 10 60 57 0.03 0.03 57 1 0 11 0 75 68 69 27 77 28 75 76 72 75 10 0 79 2 $5. COOPID, WBANID, Prelim, year, month, day, Tmax, Tmin, Tobs, Tmean, Cdd, Hdd, Pr.se, Flag1, Snow, Flag2, Snwd 87886,92806, 2006, 11, 1,86, 70, 72, 78,13,0,0 ,0, ,0 87886,92806, 2006, 11,2,80, 68, 70, 74,9,0,0, , , ,0 87886,92806, , 2006, 11, 3, 79, 63, 64,71,6, 0, 0, 0, ,0 87886,92806, 2006, 11,4,77,63,68, 70,5, 0, 0, 0, ,0 87886,92806, , 2006, 11,5, 78, 65, 69, 72,7,0,0, ,0, ,0 87886,92806, , 2006, 11, 6, 79, 67, 69, 73,8,0,0, ,0, ,0 87886,928$06, 2006, 11, 7,72,68,68,70,5, 0, 0.53, ,0, ,0 87886,92806, 2006, 11, 8, 73, 66, 67, 70,5, 0, 0.09, ,0, ,0 87886,92806, 2006, 11,9, 76,62,62,69,4,,,,,,0 87886,92806, 2006, 11, 10,78,61,66,70,5, 0, 0, ,0, ,0 87886,92806, , 2006, 11, 11, 77,63,68,70,5,,,,,, 87886,92806, 2006, 11, 12, 79,61,61,70,5, 0, 0, , , , 87886,92806, 2006, 11, 13, 71,59,63,65, 0, 0, 0, 0, ,0 87886,92806, 2006, 11, 14, 74,61,69,68,3,,,,,, 87886,92806, ,2006, 11, 15, 80, 63, 69, 72,7,0,0, ,0, ,0 87886,92806, , 2006, 11, 16, 73, 66, 67, 70,5, 0,1.34, ,, 87886,92806, , 2006, 11, 17, 67,56,58,62,0,3,,,,, 87886,92806, 2006, 11, 18,65,54,58,60,0,5,,,,, 87886,92806, 2006, 11, 19,69, 55, 56, 62,0,3, , , , , 87886,92806, 2006, 11,20,60,50,52,55, 6, 10, 0.03, ,0, 87886,92806, , 2006,11,21,57,46,53,52,0,13,0.03, ,, 87886, 92806, 2006, 11,22,63,51,53,57,0,8,0, ,0, ,0 87886,92806, 2006,11, 23, 71,53,57,62,0,3,0, ,0, 87886,92806, , 2006, 11, 24, 73, 54, 62, 64,0,1,0, ,, 87886,92806, 2006, 11, 25, 74,58, 64, 66,1,0,0, ,0, 87886,92806, 2006, 11,26,75, 61, 64,68,3,0,0, ,0, 87886,92806, 2006, 11,27, 77, 61, 68, 69, 4,0,0, ,0, ,0 87886,92806, 2006, 11, 28, 75, 66, 68, 71,6, 0, 0, ,0, ,0 87886,92806, 2006, 11, 29, 76, 67, 69, 72, 7,0,0, ,0, ,0 87886,92806, 2006, 11,30, 81,68, 71, 75, 10,0,0, ,0, ,0 87886,92806, 2006, 12, 1, 79, 69, 73, 74,9,0,, ,0, ,0 87886,92806, 2006, 12, 2, 82,69, 73, 76,11,0,0, ,0, ,0 87886,92806, , 2006, 12, 3, 79,69,69,74,9,0,0, ,0, ,0 87886,92806, 2006, 12,4,69,59,59,64,0,1,0, 10, ,0 87886,92806, , 2006, 12,5, 71,53, 61, 62,0,3,0, ,0, ,0 87886,92806, 2006, 12,6,75,60,66,68,3,0,o,,,, 87886,92806, , 2006, 12,7,72,59,59,66,1,0,0, , , , 87886,92806, , 2006, 12,8,59,47,47,53,0, 12, , ,0, , 87886,92806, 2006, 12,9,68,47,59,58,0,7, , , , ,0 87886,92806, , 2006, 12, 10, 70,55,63,63,0,2,, ,,, 87886,92806, 2006, 12, 11, 71, 61, 65, 66,1,0,0, ,0, ,0 87886,92806, 2006, 12, 12,73,61,66,67,2,0,0, ,0, ,0 87886,92806, , 2006, 12, 13, 73, 64, 68, 69,4,0,0.03, , , , 87886,92806, 2006, 12, 14, 74,66,68, 70,5, 0, 0.09, , , , 87886,92806, ,2006, 12, 15, 71,63,63,67,2,,,,,, 87886,92806, 2006, 12, 16,73,63,68, 68,3,,,,,, 87886,92806, 2006, 12, 17,77,65,69,71,6,0,0, ,0, ,0 87886,92806, , 2006, 12, 18, 77,66,68,72,7,0,0,,,, 87886,92806, 2006, 12, 19,77,64,68, 71,6, 0,,,,, 87886,92806, 2006, 12, 20, 75, 65, 67, 70,5, 0, 0, 0, ,0 87886,92806 ,2006, 12,21,77, 66, 69, 72, 7,0,0, ,0, ,0 87886,92806, , 2006, 12, 22, 79, 69, 73, 74,9,0,0.07, ,, 87886,92806, , 2006, 12, 23, 79, 67, 70, 73,8,0,0.92, ,0, 87886,92806, , 2006, 12, 24, 79, 68, 71, 74,9,0,0.01, ,0, ,0 87886,92806, 2006, 12, 25, 76,66,68, 71,6,9,1.75, , , , 87886,92806, , 2006, 12, 26,68,56,56,62,0,3, 0.09, , , , 87886,92806, , 2006, 12, 27,59,48,56,54,0,11,, ,0, ,0 87886,92806, , 2006, 12, 28, 73,55,64,64,0,1,0, ,0, ,0 87886,92806, , 2006, 12, 29, 75, 62, 67, 69,4,0,0, ,0, ,0 87886,92806, 2006, 12,30,78,66,69,72,7,0,0, ,0, ,0