Output
Input
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 #93
2000
Illinois
3636000
4713117.64705882
-1077117.64705882
Michigan
704000
853823.529411765
-149823.529411765
2001
Illinois
3192000
4713117.64705882
-1521117.64705882
Michigan
528000
853823.529411765
-325823.529411765
2002
Illinois
2988000
4713117.64705882
-1725117.64705882
Michigan
816000
853823.529411765
-37823.5294117647
2003
Illinois
3258000
4713117.64705882
-1455117.64705882
New York
742000
903529.411764706
-161529.411764706
2004
Illinois
4572000
4713117.64705882
-141117.647058823
New York
819000
903529.411764706
-84529.4117647059
2005
Illinois
4967000
4713117.64705882
253882.352941177
Michigan
754000
853823.529411765
-99823.5294117647
2006
Illinois
4918000
4713117.64705882
204882.352941177
New York
798000
903529.411764706
-105529.411764706
2007
Illinois
5420000
4713117.64705882
706882.352941177
Michigan
713000
853823.529411765
-140823.529411765
2008
Illinois
4960000
4713117.64705882
246882.352941177
Ohio
931000
1137941.17647059
-206941.176470588
2009
Illinois
4291000
4713117.64705882
-422117.647058823
Michigan
737000
853823.529411765
-116823.529411765
2010
Illinois
4274000
4713117.64705882
-439117.647058823
Michigan
952000
853823.529411765
98176.4705882353
2011
Illinois
5204000
4713117.64705882
490882.352941177
New York
693000
903529.411764706
-210529.411764706
2012
Illinois
5563000
4713117.64705882
849882.352941177
Michigan
945000
853823.529411765
91176.4705882353
2013
Illinois
5476000
4713117.64705882
762882.352941177
Pennsylvania
856000
1020588.23529412
-164588.235294118
2014
Illinois
7458000
4713117.64705882
2744882.35294118
New York
690000
903529.411764706
-213529.411764706
2015
Illinois
3179000
4713117.64705882
-1534117.64705882
New York
489000
903529.411764706
-414529.411764706
2016
Illinois
6767000
4713117.64705882
2053882.35294118
Minnesota
167000
167000
0
C:\Users\MKASSA~1\AppData\Local\Temp\Engine_16428_8153cdd456514fdfa3ea8a3afa612530_\Engine_22888_a29059ab7e71417ea12a647aca29aad4_.yxdb
Single
Profile
2016
6
1,350,000
2016
17
6,767,000
2016
18
662,000
2016
26
791,000
2016
27
167,000
2016
34
202,000
2016
36
322,000
2016
37
936,000
2016
39
930,000
2016
41
483,000
2016
0
2016
42
735,000
2016
47
274,000
2016
48
1,480,000
2016
51
372,000
2016
53
398,000
2016
55
201,000
2015
6
1,464,000
2015
17
3,179,000
2015
26
770,000
2015
36
489,000
2015
39
842,000
2015
42
794,000
2014
6
1,798,000
2014
17
7,458,000
2014
26
970,000
2014
36
690,000
2014
39
1,053,000
2014
42
1,050,000
2013
6
1,947,000
2013
17
5,476,000
2013
26
978,000
2013
36
960,000
2013
39
1,004,000
2013
42
856,000
2012
6
1,870,000
2012
17
5,563,000
2012
26
945,000
2012
36
1,071,000
2012
39
1,440,000
2012
42
1,147,000
2011
6
1,674,000
2011
17
5,204,000
2011
26
986,000
2011
36
693,000
2011
39
1,122,000
2011
42
1,026,000
2010
6
1,984,000
2010
17
4,274,000
2010
26
952,000
2010
36
1,462,000
2010
39
1,104,000
2010
42
972,000
2009
6
1,479,000
2009
17
4,291,000
2009
26
737,000
2009
36
750,000
2009
39
1,237,000
2009
42
819,000
2008
6
1,484,000
2008
17
4,960,000
2008
26
986,000
2008
36
1,062,000
2008
39
931,000
2008
42
1,240,000
2007
6
1,224,000
2007
17
5,420,000
2007
26
713,000
2007
36
1,152,000
2007
39
2,013,000
2007
42
936,000
2006
6
1,325,000
2006
17
4,918,000
2006
26
855,000
2006
36
798,000
2006
39
1,340,000
2006
42
1,248,000
2005
6
1,595,000
2005
17
4,967,000
2005
26
754,000
2005
36
795,000
2005
39
1,332,000
2005
42
1,313,000
2004
6
1,404,000
2004
17
4,572,000
2004
26
1,008,000
2004
36
819,000
2004
39
1,116,000
2004
42
1,216,000
2003
6
1,225,000
2003
17
3,258,000
2003
26
1,022,000
2003
36
742,000
2003
39
1,088,000
2003
42
750,000
2002
6
1,540,000
2002
17
2,988,000
2002
26
816,000
2002
36
1,071,000
2002
39
924,000
2002
42
1,170,000
2001
6
1,464,000
2001
17
3,192,000
2001
26
528,000
2001
36
1,344,000
2001
39
944,000
2001
42
988,000
2000
6
1,800,000
2000
17
3,636,000
2000
26
704,000
2000
36
1,140,000
2000
39
925,000
2000
42
1,090,000
Input 1
STATE|STUSAB|STATE_NAME|STATENS
01|AL|Alabama|01779775
02|AK|Alaska|01785533
04|AZ|Arizona|01779777
05|AR|Arkansas|00068085
06|CA|California|01779778
08|CO|Colorado|01779779
09|CT|Connecticut|01779780
10|DE|Delaware|01779781
11|DC|District of Columbia|01702382
12|FL|Florida|00294478
13|GA|Georgia|01705317
15|HI|Hawaii|01779782
16|ID|Idaho|01779783
17|IL|Illinois|01779784
18|IN|Indiana|00448508
19|IA|Iowa|01779785
20|KS|Kansas|00481813
21|KY|Kentucky|01779786
22|LA|Louisiana|01629543
23|ME|Maine|01779787
24|MD|Maryland|01714934
25|MA|Massachusetts|00606926
26|MI|Michigan|01779789
27|MN|Minnesota|00662849
28|MS|Mississippi|01779790
29|MO|Missouri|01779791
30|MT|Montana|00767982
31|NE|Nebraska|01779792
32|NV|Nevada|01779793
33|NH|New Hampshire|01779794
34|NJ|New Jersey|01779795
35|NM|New Mexico|00897535
36|NY|New York|01779796
37|NC|North Carolina|01027616
38|ND|North Dakota|01779797
39|OH|Ohio|01085497
40|OK|Oklahoma|01102857
41|OR|Oregon|01155107
42|PA|Pennsylvania|01779798
44|RI|Rhode Island|01219835
45|SC|South Carolina|01779799
46|SD|South Dakota|01785534
47|TN|Tennessee|01325873
48|TX|Texas|01779801
49|UT|Utah|01455989
50|VT|Vermont|01779802
51|VA|Virginia|01779803
53|WA|Washington|01779804
54|WV|West Virginia|01779805
55|WI|Wisconsin|01779806
56|WY|Wyoming|01779807
60|AS|American Samoa|01802701
66|GU|Guam|01802705
69|MP|Northern Mariana Islands|01779809
72|PR|Puerto Rico|01779808
74|UM|U.S. Minor Outlying Islands|01878752
78|VI|U.S. Virgin Islands|01802710
Input 2
Average_State_Prod
,
Warn
Name = Replace([Name], "Avg_", "")
Name = Replace([Name], "New_York", "New York"...
C:\Users\MKASSA~1\AppData\Local\Temp\Engine_16428_8153cdd456514fdfa3ea8a3afa612530_\Engine_22888_5b94ca3d9a5941eb940ef3b33c7da9b7_.yxdb
Single
Profile
Min Diff from Average Prod
Min Producer
Min Producer
Min Average State Production
FindAny
Append
Min Diff from Average Production = [Min Pumpkin Numbers]-[Min Average State Prod...
Container 133
Min_PUMPKINS
PUMPKINS
2000
FindAny
Append
,
Warn
,
Warn
Sol1
Field1
Last
Skip
1
Skip 1st 1
"Year","State ANSI","PUMPKINS"
False
True
True
False
False
False
False
False
False
upper
C:\Users\MKASSA~1\AppData\Local\Temp\Engine_16428_8153cdd456514fdfa3ea8a3afa612530_\Engine_22888_6e2d4c1eca98464c8931e0912482b8c3_.yxdb
Year - Ascending
Warn
Year - Ascending
STATE_NAME - Descending
[STATE_NAME] = "Illinois"
Simple
=
STATE_NAME
True
fixed
2021-11-09 14:58:57
0
Illinois
2021-11-09 14:58:57
2021-11-09 14:58:57
[STATE_NAME] = "Illinois"
Allow
Container 59
C:\Users\MKASSA~1\AppData\Local\Temp\Engine_11888_ec8b0f81d01240acba67496e63638f30_\Engine_4608_0f16ceec2fb749b588a9fc55ba25fbd7_.yxdb
Single
Profile
C:\Users\MKASSA~1\AppData\Local\Temp\Engine_11888_ec8b0f81d01240acba67496e63638f30_\Engine_4608_839a8c7246514be2bce67b5d01ea33e4_.yxdb
Single
Profile
Horizontal
challenge_93_start_file_solution