Location Speed Time/Date Lat/Lon
...Adams County...
0.7 Mi S Of Northwest Pkwy 56 MPH 1235 PM 12/30 39.97N/104.99W
...Boulder County...
3 SSW Boulder 108 MPH 0225 PM 12/30 39.99N/105.27W
1 NE Crisman 102 MPH 1120 AM 12/30 40.05N/105.35W
3 NW Marshall 90 MPH 0125 PM 12/30 39.98N/105.28W
Boulder 75 MPH 0215 PM 12/30 40.03N/105.23W
036e03750rws1rp1 At Baseline 73 MPH 1123 AM 12/30 40.00N/105.26W
Wondervu 72 MPH 0956 AM 12/30 39.91N/105.38W
Atoc - Univ. Colorado Campus 71 MPH 1050 AM 12/30 40.01N/105.27W
Lyons 3W 70 MPH 1042 AM 12/30 40.22N/105.33W
Lafayette 70 MPH 1001 AM 12/30 40.06N/105.12W
Louisville 68 MPH 0200 PM 12/30 39.96N/105.15W
Longmont 68 MPH 1147 AM 12/30 40.13N/105.23W
Nederland 66 MPH 0900 AM 12/30 39.99N/105.45W
Nederland 65 MPH 0938 AM 12/30 39.99N/105.45W
Boulder 64 MPH 0325 PM 12/30 40.06N/105.29W
Boulder 64 MPH 1117 AM 12/30 40.04N/105.26W
Boulder 63 MPH 1116 AM 12/30 40.02N/105.29W
Boulder 62 MPH 0223 PM 12/30 40.06N/105.21W
Boulder 61 MPH 1042 AM 12/30 40.00N/105.20W
Ward 60 MPH 0833 AM 12/30 40.10N/105.50W
Boulder 57 MPH 0808 AM 12/30 40.03N/105.28W
...Broomfield County...
025s229 Sh7 57 MPH 1153 AM 12/30 40.00N/104.98W
...Clear Creek County...
Corral Creek 67 MPH 1158 AM 12/30 39.64N/105.46W
I-70 Georgetown Lake 61 MPH 1235 PM 12/30 39.73N/105.69W
I-70 Floyd Hill 60 MPH 1204 PM 12/30 39.72N/105.41W
...Douglas County...
Cheesman 67 MPH 1223 PM 12/30 39.18N/105.27W
Carpenter Peak 56 MPH 0357 PM 12/30 39.42N/105.08W
Franktown 56 MPH 0320 PM 12/30 39.39N/104.75W
Surrey Ridge 55 MPH 1224 PM 12/30 39.49N/104.87W
...Elbert County...
Elizabeth 60 MPH 0250 PM 12/30 39.35N/104.53W
...Gilpin County...
Black Hawk 58 MPH 1253 PM 12/30 39.84N/105.47W
Dakota Hill 58 MPH 0955 AM 12/30 39.87N/105.55W
Aspen Springs 57 MPH 1250 PM 12/30 39.83N/105.48W
Golden 56 MPH 1131 AM 12/30 39.90N/105.40W
...Grand County...
Winter Park Eagle Wind 73 MPH 0345 AM 12/30 39.85N/105.78W
Berthoud Pass 63 MPH 0935 AM 12/30 39.80N/105.77W
Keyser Ridge 55 MPH 0427 AM 12/30 39.89N/106.04W
...Jefferson County...
Arvada 115 MPH 1206 PM 12/30 39.86N/105.22W
Rocky Flats Hwy 93 and 72 110 MPH 1123 AM 12/30 39.87N/105.24W
2.8 NE White Ranch Open Spac 103 MPH 0126 PM 12/30 39.85N/105.25W
2 NW Rocky Flats 98 MPH 1155 AM 12/30 39.91N/105.23W
470w014 Wadsworth 81 MPH 0348 PM 12/30 39.55N/105.08W
1.7 NE Rocky Flats (CDPHE) 78 MPH 1215 PM 12/30 39.91N/105.19W
I-70 at C470 73 MPH 1224 PM 12/30 39.71N/105.19W
Genesee 71 MPH 1212 PM 12/30 39.71N/105.29W
Coal Creek Canyon 69 MPH 1016 AM 12/30 39.88N/105.39W
Lakewood 67 MPH 0346 PM 12/30 39.70N/105.15W
Golden 66 MPH 0901 AM 12/30 39.79N/105.28W
Arvada 62 MPH 0146 PM 12/30 39.84N/105.17W
Arvada 62 MPH 0139 PM 12/30 39.85N/105.16W
Littleton 56 MPH 0316 PM 12/30 39.59N/105.13W
4 SSE Rocky Flats 55 MPH 0230 PM 12/30 39.83N/105.19W
...Larimer County...
Glen Haven 89 MPH 0827 AM 12/30 40.47N/105.45W
Livermore 79 MPH 0846 AM 12/30 40.71N/105.41W
Lyons 62 MPH 1156 AM 12/30 40.28N/105.31W
Virginia Dale 62 MPH 1134 AM 12/30 40.95N/105.35W
Buckeye 60 MPH 0235 PM 12/30 40.81N/105.04W
Red Feather RAWS 58 MPH 1224 PM 12/30 40.80N/105.57W
Livermore 57 MPH 0933 AM 12/30 40.87N/105.36W
3 WNW Loveland 56 MPH 0217 PM 12/30 40.43N/105.12W
...Summit County...
Red Cliff Pass 55 MPH 0515 AM 12/30 39.48N/106.15W
...Weld County...
Erie Muni 59 MPH 0915 AM 12/30 40.02N/105.05W
30Dec_max_wind_speeds
30Dec_max_wind_speeds
C:\Users\ESTHER~1\AppData\Local\Temp\Engine_29204_e419074249364e36a60a619107b3cf5c_\Engine_32112_dcf413b6b21a483796ea86fdf806151a_.yxdb
Single
Profile
Avg wind speed by county
Avg wind speed by county
IsEmpty([Field_1])
OR Contains([Field_1], "Location")
Custom
IsEmpty([Field_1])
OR Contains([Field_1], "Location")
Field_1
County
V_String
35
Empty
IIF(StartsWith([Field_1],"."),Trim([Field_1],"."),[Row-1:County])
IIF(StartsWith([Field_1],"."),Trim([Field_1],"."),[Row-1:Coun...
!StartsWith([Field_1],".")
Custom
!StartsWith([Field_1],".")
Wind speed - Descending
1
Avg_Wind speed - Descending
C:\Users\ESTHER~1\AppData\Local\Temp\Engine_29204_e419074249364e36a60a619107b3cf5c_\Engine_32112_2564e1bc34c347aaa7bc06d0dfdb725a_.yxdb
Single
Profile
Wind speed
Wind speed
C:\Users\ESTHER~1\AppData\Local\Temp\Engine_29204_e419074249364e36a60a619107b3cf5c_\Engine_32112_d137fb988e244fefac20f2f0eff83fde_.yxdb
Single
Profile
Avg wind speed
Avg wind speed
Location = REGEX_Replace([Field_1], "(.*?)\s+\d+\sMPH.*", "$1")
Wind Speed = ton...
Alteryx Educational Asset - Terms and Conditions
Use of this Alteryx asset is for educational purposes only and bound by the conditions set forth on alteryx.com/terms-and-conditions. Alteryx Information may not be reproduced, transmitted or distributed without Alteryx, Inc.'s permission.”
Horizontal
challenge_316_EHB_completed