Input
Outputs
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
Jefferson County
Arvada
115
12:06:00
Output 1
Location with highest wind speeds
Output 1
Jefferson County
77.7333333333333
Boulder County
71.45
Larimer County
65.375
Grand County
63.6666666666667
Clear Creek County
62.6666666666667
Elbert County
60
Weld County
59
Douglas County
58.5
Gilpin County
57.25
Broomfield County
57
Adams County
56
Summit County
55
Output 2
Rank counties with average highest wind speed
Output 2
Afternoon
68.3333333333333
Morning
68.65625
Output 3
Average highest wind speeds were before Noon or after Noon
Output 3
C:\Users\DAVID~1.SKA\AppData\Local\Temp\Engine_14856_0c8406be18bb44d4949c9163559fe103_\Engine_29076_2c05b63f97084ac18534f8b931723eda_.yxdb
Single
Profile
C:\Users\DAVID~1.SKA\AppData\Local\Temp\Engine_14856_0c8406be18bb44d4949c9163559fe103_\Engine_29076_a1c824cd523f4ed7a2dd0d5d715b7971_.yxdb
Single
Profile
C:\Users\DAVID~1.SKA\AppData\Local\Temp\Engine_14856_0c8406be18bb44d4949c9163559fe103_\Engine_29076_340ade3717884aac9693d20366a40769_.yxdb
Single
Profile
C:\Users\DAVID~1.SKA\AppData\Local\Temp\Engine_14856_0c8406be18bb44d4949c9163559fe103_\Engine_29076_766aeed85e4942b9bd37f2607e1b5393_.yxdb
Single
Profile
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #316
True
False
"Field_1"
True
True
True
False
False
False
False
False
False
upper
Skip
1
Skip 1st 1
False
False
"County"
False
False
True
False
False
False
False
True
False
upper
County
New Field
Int32
4
Empty
IF isnull([County])
THEN [Row-1:County]
ELSE [County]
ENDIF
IF isnull([County])
THEN [Row-1:County]
ELSE [County]
ENDIF
Field_1
ParseComplex
Field_1
Warn
Field_1_Matched
Simple
IsNotNull
Location
True
fixed
2022-07-22 15:15:11
0
2022-07-22 15:15:11
2022-07-22 15:15:11
!IsNull([Location])
Speed - Descending
First
1
First 1
C:\Users\DAVID~1.SKA\AppData\Local\Temp\Engine_14856_0c8406be18bb44d4949c9163559fe103_\Engine_29076_22eddd486264422782102fb5df191c88_.yxdb
Output 1
Output 1
C:\Users\DAVID~1.SKA\AppData\Local\Temp\Engine_14856_0c8406be18bb44d4949c9163559fe103_\Engine_29076_23415f09df04495ca0bc4b1f8122c48b_.yxdb
Single
Profile
Output 2
Output 2
Avg_Speed - Descending
C:\Users\DAVID~1.SKA\AppData\Local\Temp\Engine_14856_0c8406be18bb44d4949c9163559fe103_\Engine_29076_ef8fd1c37d3d4cd888f83f5b0c0869a7_.yxdb
Single
Profile
Output 3
Output 3
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_DS