| ADMIM INFO: **-change only picked# in criteria to <> | |||||||||||||||||||||||||||||||||||||||||
| - data-filter-adv.filter: List=aall; Criteria=$F$3:$AP$4; | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | |||||||||||||||||||||||
| CTRL-E TO EXTRACT | Copy to=$F$10:$AP$71 | Golfer | Phoenix | Picked 1 | LAOpen | Picked 2 | Honda | Picked 3 | Valspar | Picked 4 | Palmer | Picked 5 | Masters | Picked 6 | Texas | Picked 7 | WellsFargo | Picked 8 | Players | Picked 9 | Memorial | Picked 10 | USOpen | Picked 11 | Quicken | Picked 12 | Greenbreir | Picked 13 | British | Picked 14 | Bridgestone | Picked 15 | PGA | Picked 16 | NorthTrust | Picked 17 | Dell | Picked 18 | |||
| CTRL-Shift-P TO Update picks sheet (chg each tourney) | <> | ||||||||||||||||||||||||||||||||||||||||
| Week #: | 18 | ||||||||||||||||||||||||||||||||||||||||
| count: | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | 28 | |||||||||||||||||||||||
| 28 | 5,207,479.29 | 119 | |||||||||||||||||||||||||||||||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | ||||||||||||||||||||||||
| Golfer | Phoenix | Picked 1 | LAOpen | Picked 2 | Honda | Picked 3 | Valspar | Picked 4 | Palmer | Picked 5 | Masters | Picked 6 | Texas | Picked 7 | WellsFargo | Picked 8 | Players | Picked 9 | Memorial | Picked 10 | USOpen | Picked 11 | Quicken | Picked 12 | Greenbreir | Picked 13 | British | Picked 14 | Bridgestone | Picked 15 | PGA | Picked 16 | NorthTrust | Picked 17 | Dell | Picked 18 | |||||
| 1 | Patrick Cantlay | 71,228.57 | 1 | Patrick Cantlay | 0.00 | 1 | 261,000.00 | 1 | 71,228.57 | 1 | |||||||||||||||||||||||||||||||
| 2 | Paul Casey | 100,800.00 | 1 | Paul Casey | 17,964.00 | 10 | 0.00 | 1 | 1,170,000.00 | 8 | 192,500.00 | 3 | 0.00 | 1 | 281,050.00 | 2 | 27,161.00 | 2 | 74,750.00 | 4 | 0.00 | 1 | 18,990.00 | 1 | 100,800.00 | 1 | |||||||||||||||
| 3 | Joel Dahmen | 0.00 | 1 | Joel Dahmen | 0.00 | 1 | |||||||||||||||||||||||||||||||||||
| 4 | Jason Day | 0.00 | 11 | Jason Day | 89,000.00 | 15 | 128,150.00 | 4 | 0.00 | 1 | 1,386,000.00 | 7 | 418,000.00 | 14 | 25,721.00 | 11 | 0.00 | 10 | 0.00 | 1 | 109,714.00 | 2 | 160,875.00 | 3 | 113,125.00 | 9 | 101,160.00 | 14 | 0.00 | 11 | |||||||||||
| 5 | Bryson DeChambeau | 1,620,000.00 | 3 | Bryson DeChambeau | 24,516.00 | 1 | 46,200.00 | 1 | 369,600.00 | 2 | 50,600.00 | 2 | 79,200.27 | 3 | 79,250.00 | 1 | 1,620,000.00 | 3 | |||||||||||||||||||||||
| 6 | Tony Finau | 372,000.00 | 11 | Tony Finau | 0.00 | 4 | 0.00 | 10 | 286,000.00 | 1 | 77,000.00 | 4 | 139,018.00 | 3 | 75,920.00 | 15 | 160,875.00 | 4 | 33,281.25 | 7 | 972,000.00 | 3 | 372,000.00 | 11 | |||||||||||||||||
| 7 | Tommy Fleetwood | 71,228.57 | 5 | Tommy Fleetwood | 33,120.00 | 7 | 316,800.00 | 5 | 59,318.50 | 12 | 170,500.00 | 2 | 0.00 | 10 | 1,296,000.00 | 1 | 0.00 | 1 | 154,500.00 | 15 | 128,250.00 | 5 | 48,428.57 | 7 | 101,160.00 | 6 | 71,228.57 | 5 | |||||||||||||
| 8 | Tyrrell Hatton | 160,875.00 | 1 | Tyrrell Hatton | 0.00 | 8 | 18,067.00 | 2 | 22,389.23 | 1 | 81,250.00 | 1 | 261,945.00 | 1 | 101,160.00 | 1 | 160,875.00 | 1 | |||||||||||||||||||||||
| 9 | Charley Hoffman | 17,280.00 | 1 | Charley Hoffman | 51,060.00 | 3 | 24,516.00 | 4 | 0.00 | 1 | 12,958.00 | 13 | 0.00 | 1 | 54,875.00 | 1 | 0.00 | 1 | 101,160.00 | 1 | 17,280.00 | 1 | |||||||||||||||||||
| 10 | Billy Horschel | 0.00 | 1 | Billy Horschel | 22,770.00 | 1 | 136,400.00 | 10 | 0.00 | 1 | 96,086.67 | 3 | 0.00 | 1 | 0.00 | 1 | |||||||||||||||||||||||||
| 11 | Dustin Johnson | 261,900.00 | 13 | Dustin Johnson | 111,600.00 | 15 | 0.00 | 2 | 286,000.00 | 8 | 0.00 | 1 | 148,866.66 | 8 | 240,300.00 | 13 | 812,927.00 | 15 | 0.00 | 1 | 0.00 | 15 | 510,000.00 | 16 | 76,000.00 | 16 | 198,000.00 | 14 | 261,900.00 | 13 | |||||||||||
| 12 | Brooks Koepka | 160,875.00 | 11 | Brooks Koepka | 22,389.23 | 1 | 225,500.00 | 1 | 2,160,000.00 | 4 | 41,375.00 | 7 | 357,000.00 | 4 | 1,980,000.00 | 9 | 261,000.00 | 7 | 160,875.00 | 11 | |||||||||||||||||||||
| 13 | Matt Kuchar | 28,860.00 | 1 | Matt Kuchar | 242,362.50 | 3 | 46,996.36 | 3 | 0.00 | 1 | 24,700.00 | 3 | 76,450.00 | 2 | 14,508.00 | 10 | 0.00 | 1 | 148,866.66 | 2 | 139,018.00 | 5 | 0.00 | 1 | 219,000.00 | 1 | 128,250.00 | 1 | 0.00 | 1 | 18,990.00 | 1 | 28,860.00 | 1 | |||||||
| 14 | Hideki Matsuyama | 372,000.00 | 1 | Hideki Matsuyama | 0.00 | 13 | 21,965.20 | 3 | 14,168.00 | 3 | 0.00 | 1 | 139,018.00 | 1 | 163,435.00 | 2 | 66,250.00 | 2 | 372,000.00 | 1 | |||||||||||||||||||||
| 15 | Rory McIlroy | 160,875.00 | 9 | Rory McIlroy | 78,000.00 | 6 | 14,388.00 | 13 | 0.00 | 7 | 1,602,000.00 | 3 | 386,375.00 | 14 | 0.00 | 3 | 115,500.00 | 16 | 0.00 | 12 | 240,300.00 | 10 | 0.00 | 8 | 694,250.00 | 5 | 241,375.00 | 14 | 24,833.33 | 15 | 0.00 | 1 | 160,875.00 | 9 | |||||||
| 16 | Phil Mickelson | 160,875.00 | 4 | Phil Mickelson | 242,362.50 | 2 | 241,200.00 | 8 | 0.00 | 1 | 55,275.00 | 12 | 0.00 | 3 | 281,050.00 | 5 | 0.00 | 5 | 139,018.00 | 1 | 27,951.84 | 7 | 0.00 | 1 | 15,111.00 | 13 | 84,000.00 | 2 | 87,250.00 | 2 | 0.00 | 1 | 144,000.00 | 1 | 160,875.00 | 4 | |||||
| 17 | Francesco Molinari | 0.00 | 1 | Francesco Molinari | 59,318.50 | 1 | 0.00 | 3 | 1,278,000.00 | 8 | 1,890,000.00 | 6 | 66,250.00 | 3 | 334,712.50 | 3 | 0.00 | 11 | 0.00 | 1 | |||||||||||||||||||||
| 18 | Kevin Na | 0.00 | 1 | Kevin Na | 633,600.00 | 1 | 0.00 | 2 | 0.00 | 1 | 14,626.00 | 2 | 1,314,000.00 | 1 | 27,161.00 | 2 | 113,125.00 | 1 | 0.00 | 1 | |||||||||||||||||||||
| 19 | Jon Rahm | 28,860.00 | 1 | Jon Rahm | 141,450.00 | 13 | 23,320.00 | 4 | 0.00 | 1 | 0.00 | 6 | 0.00 | 1 | 104,250.00 | 4 | 489,250.00 | 3 | 0.00 | 6 | 28,860.00 | 1 | |||||||||||||||||||
| 20 | Justin Rose | 972,000.00 | 6 | Justin Rose | 0.00 | 1 | 247,000.00 | 11 | 605,200.00 | 14 | 231,000.00 | 11 | 0.00 | 1 | 92,714.29 | 5 | 309,275.00 | 12 | 270,151.00 | 16 | 0.00 | 1 | 694,250.00 | 17 | 0.00 | 6 | 113,125.00 | 7 | 0.00 | 15 | 972,000.00 | 6 | |||||||||
| 21 | Xander Schauffele | 21,500.00 | 1 | Xander Schauffele | 180,000.00 | 2 | 0.00 | 1 | 11,966.00 | 2 | 75,920.00 | 7 | 47,750.00 | 3 | 21,500.00 | 1 | |||||||||||||||||||||||||
| 22 | Adam Scott | 21,500.00 | 6 | Adam Scott | 16,436.57 | 2 | 123,750.00 | 1 | 30,304.50 | 5 | 63,663.00 | 1 | 0.00 | 4 | 14,168.00 | 2 | 328,500.00 | 1 | 21,500.00 | 6 | |||||||||||||||||||||
| 23 | Webb Simpson | 21,500.00 | 1 | Webb Simpson | 0.00 | 4 | 77,000.00 | 4 | 1,980,000.00 | 1 | 270,151.00 | 1 | 18,523.75 | 13 | 87,250.00 | 1 | 113,125.00 | 1 | 59,850.00 | 3 | 21,500.00 | 1 | |||||||||||||||||||
| 24 | Jordan Spieth | 160,875.00 | 4 | Jordan Spieth | 0.00 | 13 | 180,000.00 | 13 | 0.00 | 1 | 0.00 | 16 | 0.00 | 1 | 748,000.00 | 10 | 0.00 | 3 | 40,700.00 | 7 | 0.00 | 5 | 0.00 | 3 | 219,000.00 | 4 | 51,500.00 | 5 | 187,747.14 | 3 | 73,500.00 | 3 | 160,875.00 | 4 | |||||||
| 25 | Justin Thomas | 71,228.58 | 12 | Justin Thomas | 100,050.00 | 5 | 180,000.00 | 11 | 1,188,000.00 | 13 | 170,500.00 | 12 | 0.00 | 1 | 77,000.00 | 15 | 225,500.00 | 12 | 240,300.00 | 14 | 79,200.27 | 14 | 0.00 | 1 | 0.00 | 2 | 1,700,000.00 | 6 | 334,712.50 | 14 | 261,000.00 | 13 | 71,228.58 | 12 | |||||||
| 26 | Bubba Watson | 261,900.00 | 2 | Bubba Watson | 28,290.00 | 1 | 1,296,000.00 | 1 | 18,512.00 | 3 | 386,375.00 | 11 | 0.00 | 3 | 25,721.00 | 2 | 121,362.50 | 16 | 74,750.00 | 2 | 0.00 | 1 | 45,450.00 | 1 | 261,900.00 | 2 | |||||||||||||||
| 27 | Aaron Wise | 18,090.00 | 1 | Aaron Wise | 30,304.50 | 1 | 0.00 | 1 | 18,090.00 | 1 | |||||||||||||||||||||||||||||||
| 28 | Tiger Woods | 71,228.57 | 8 | Tiger Woods | 0.00 | 3 | 151,800.00 | 5 | 572,000.00 | 10 | 338,200.00 | 17 | 63,663.00 | 16 | 0.00 | 3 | 17,479.00 | 9 | 225,500.00 | 4 | 76,985.00 | 16 | 0.00 | 9 | 312,400.00 | 16 | 0.00 | 1 | 327,000.00 | 7 | 74,750.00 | 15 | 1,188,000.00 | 5 | 32,400.00 | 13 | 71,228.57 | 8 | |||
| 29 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 30 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 31 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 32 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 33 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 34 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 35 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 36 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 37 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 38 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 39 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 40 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 41 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 42 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 43 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 44 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 45 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 46 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 47 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 48 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 49 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 50 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 51 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 52 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 53 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 54 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 55 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 56 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 57 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 58 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 59 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 60 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||
| 61 | --- | --- | --- | ||||||||||||||||||||||||||||||||||||||