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     ---     ---     ---