Spreadsheet: 148577d1333470784-find-the-max-column-value-given-certain-restrictions-or-filters-on-the-data-set-max_value_given_criteria
Sheet: Sheet1

LotID | Status | [NAME] |  |  | LotID | Max_Yld_WhereStatus<>"Closed"
20060359 | Submitted | 57.69664351851679 |  |  | 20060359
20060359 | Submitted | 37.88934027777577 |  |  | 20060517
20060359 | Submitted | 34.95087962962862 |  |  | 20060579
20060359 | Submitted | 19.47002314814745 |  |  | 20070363
20060517 | Submitted | 54.69707175925578 |  |  | 20070782
20060517 | Submitted | 31.30978009258979 |  |  | 20080099
20060517 | Submitted | 21.24501157407212 |  |  | 20080259
20060517 | Submitted | 21.24405092592497 |  |  | 20080394
20060579 | Submitted | 69.90724537037022 |  |  | 20080435
20060579 | Submitted | 69.90479166666773 |  |  | 20080470
20070363 | Submitted | 16.79400462962803 |  |  | 20080580
20070782 | Submitted | 76.81924768518365 |  |  | 20080763
20080099 | Closed | 281.8798263888893 |  |  | 20090072
20080099 | Closed | 278.8394444444421 |  |  | 20090508
20080099 | Closed | 273.4665509259285 |  |  | 20090686
20080099 | Closed | 272.1906018518494
20080099 | Closed | 272.1876388888923
20080099 | Closed | 266.7346180555542
20080099 | Closed | 265.970185185186
20080099 | Closed | 265.8638888888891
20080099 | Closed | 258.651192129626
20080099 | Closed | 246.8322337962964
20080099 | Closed | 246.8285648148158
20080099 | Closed | 246.8257291666669
20080099 | Closed | 239.0794212962937
20080099 | Closed | 198.7935069444429
20080099 | Closed | 181.9561342592569
20080099 | Closed | 163.7814351851848
20080099 | Closed | 99.85571759259619
20080099 | Closed | 64.92170138889196
20080099 | Closed | 40.7854166666657
20080099 | Closed | 29.7682638888873
20080259 | Submitted | 61.86613425926043
20080259 | Submitted | 57.88623842592642
20080259 | Submitted | 43.65418981481344
20080259 | Submitted | 12.22103009259445
20080259 | Submitted | 12.21111111110804
20080394 | Closed | 58.86315972221928
20080394 | Closed | 44.03523148148088
20080394 | Closed | 44.03309027777868
20080394 | Closed | 44.01650462963153
20080394 | Closed | 43.99569444444205
20080394 | Closed | 43.99200231481518
20080394 | Submitted | 23.74122685185284
20080394 | Submitted | 20.52432870370103
20080394 | Submitted | 20.52151620370569
20080435 | Submitted | 22.45541666666395
20080470 | Submitted | 14.50592592592875
20080580 | Closed | 57.85767361111357
20080580 | Closed | 57.85556712962716
20080580 | Re-Submitted | 29.9691550925927
20080763 | Closed | 78.88144675926014
20080763 | Closed | 65.13442129629402
20080763 | Closed | 65.1305787037054
20090072 | Closed | 279.3222453703711
20090072 | Closed | 267.5396296296312
20090072 | Closed | 267.3002314814803
20090072 | Closed | 267.289606481485
20090072 | Closed | 261.5045254629658
20090072 | Closed | 259.7832986111098
20090072 | Closed | 259.7804745370377
20090072 | Closed | 240.8659953703682
20090072 | Closed | 230.4945023148175
20090072 | Closed | 225.8969444444447
20090072 | Closed | 223.6753935185188
20090072 | Closed | 209.1457523148129
20090072 | Closed | 182.9186458333352
20090072 | Closed | 162.8462384259255
20090072 | Closed | 118.354432870372
20090072 | Closed | 114.6557523148149
20090072 | Closed | 114.6522337962961
20090072 | Closed | 79.58605324073869
20090072 | Closed | 79.58405092592875
20090072 | Closed | 72.98736111111066
20090072 | Closed | 72.98149305555853
20090072 | Closed | 68.79562499999884
20090072 | Closed | 65.04067129629402
20090072 | Closed | 62.72027777777839
20090072 | Closed | 62.71804398148379
20090072 | Closed | 40.94557870370045
20090072 | Closed | 40.62168981481227
20090072 | Closed | 40.61862268518598
20090508 | Closed | 280.8018055555585
20090508 | Closed | 272.6688773148126
20090508 | Closed | 265.1910300925956
20090508 | Closed | 258.5860416666692
20090508 | Closed | 257.3035648148143
20090508 | Closed | 257.3007175925959
20090508 | Closed | 254.4170023148181
20090508 | Closed | 253.7509375000009
20090508 | Closed | 240.8089236111118
20090508 | Closed | 238.6916319444426
20090508 | Closed | 238.6901504629641
20090508 | Closed | 238.6875578703693
20090508 | Closed | 238.6826620370339
20090508 | Closed | 237.5298379629603
20090508 | Closed | 237.5285185185203
20090508 | Closed | 237.5267245370342
20090508 | Closed | 237.5251041666634
20090508 | Closed | 237.5203009259276
20090508 | Closed | 233.4122685185212
20090508 | Closed | 222.7564814814832
20090508 | Closed | 217.6196759259255
20090508 | Closed | 204.9622222222242
20090508 | Closed | 203.6652314814783
20090508 | Closed | 196.5898032407422
20090508 | Closed | 160.0134606481515
20090508 | Closed | 141.2523958333331
20090508 | Closed | 99.69561342592351
20090508 | Closed | 99.68494212962833
20090686 | Submitted | 41.40718750000087
20090686 | Submitted | 41.40473379629839
20090686 | Submitted | 28.43782407407707