Spreadsheet: 677486d1589374306-multiple-fields-pulling-into-a-summary-form-draft-order-and-spreadsheet-auto-pop_help
Sheet: Draft Order

PICK # | FRANCHISE | Player Name | [NAME] | CONTRACT | Test (Hide) | [NAME]?
1 | [NAME] | [NAME], [NAME] | 20.2 |  | 0
2 | [NAME] | AASE, [NAME] | 2.4 |  | 0
3 | Middle Channel | ABBOTT, [NAME] | 4.9 |  | 0
4 | Menomonee | ABERNATHY, [NAME] | 9 |  | 0
5 | Cincinnati | AKER, [NAME] | 1.6 |  | 0
6 | Las Vegas | ALEXANDER, [NAME] (Grover Cleveland) | 19 |  | 0
7 | Coastline | [NAME], [NAME] | 1 |  | 0
8 | Fantomz | BECK, Rod | 2.9 |  | 0
9 | Madison East | ADAMS, Babe | 15.9 |  | 0
10 | New Westminster | BETANCOURT, Rafael | 3.3 |  | 0
11 | Hollywood | YOUNG, Cy | 16.1 |  | 0
12 | Kansas City A's | TROUT, [NAME] | 12.6 |  | 0
13 | [NAME] | SANTANA, [NAME] | 15.1 |  | 0
14 | Clockwork | ADCOCK, [NAME] | 5.1 |  | 0
15 | Iowa | AFFELDT, Jeremy | 2.2 |  | 0
16 | Wainwright | AGEE, [NAME] | 1.2 |  | 0
17 | [NAME] | AGUILERA, [NAME] | 6.1 |  | 0
18 | Climax | AGUIRRE, Hank | 5.4 |  | 0
19 | Indiana | AIKENS, Willie | 0.5 |  | 0
20 | Detroit | ALEXANDER, [NAME] | 10.6 |  | 0
21 | San Tan Valley | ALEXANDER, [NAME] | 0.5 |  | 0
22 | Hoboken | ALFONZO, Edgardo | 5.3 |  | 0
23 | Chicago | ALLEN, [NAME] | 1.1 |  | 0
24 | Kansas City Blues | ALLEN, [NAME] | 18.2 |  | 0
25 | [NAME] | ALLEN, [NAME] | 11 |  | 0
26 | Pigtown | [NAME], [NAME] | 15.5 |  | 0
27 | West Michigan | BALFOUR, Grant | 2.4 |  | 0
28 | Boston | BALL, Diamond (Walter) | 3.2 |  | 0
29 | Fort Worth | BANCROFT, [NAME] | 8.3 |  | 0
30 | Virginia | BANDO, [NAME] | 9.7
31 | Fire Lake | BANKHEAD, [NAME] | 1.1
32 | Motown | BANKS, Ernie | 10.6
PICK # | FRANCHISE | Player Name | [NAME] | CONTRACT
33 | Motown | BARFIELD, [NAME] | 4.2
34 | Fire Lake | BARNES, [NAME] | 10.5
35 | Virginia | BARNHILL, [NAME] ([NAME]) | 0.5
36 | Fort Worth | BARRETT, [NAME] | 0.9
37 | Boston | BARTELL, [NAME] | 6.3
38 | West Michigan | BASSLER, [NAME] | 0.5
39 | Pigtown | BATES, [NAME] | 7.4
40 | [NAME] | BATTEY, [NAME] | 1.2
41 | Kansas City Blues | BAUER, Hank | 4.8
42 | Chicago | BAY, [NAME] | 5.1
43 | Hoboken | BAUTISTA, [NAME] | 9.1
44 | San Tan Valley | BAYLOR, [NAME] | 7.3
45 | Detroit | BEAUMONT, [NAME] | 10
46 | Indiana | BECK, Rod | 2.9
47 | Climax | BECKER, Beals | 0.5
48 | [NAME] | BECKERT, [NAME] | 1.9
49 | Wainwright | BECKETT, [NAME] | 11.6
50 | Iowa | BECKLEY, Jake | 3.1
51 | Clockwork | BECKWITH, [NAME] | 9.9
52 | [NAME] | BEDROSIAN, [NAME] | 5.3
53 | Kansas City A's | BEGGS, [NAME] | 1.9
54 | Hollywood | BELANGER, [NAME] | 0.5
55 | New Westminster | BELL, Buddy | 6.6
56 | Madison East | BELL, Cool Papa (James) | 10
57 | Fantomz | BELL, [NAME] | 5
58 | Coastline | BELL, [NAME] | 5.4
59 | Las Vegas | BELL, Heath | 1.1
60 | Cincinnati | BELL, [NAME] | 1.1
61 | Menomonee | BELLE, [NAME] | 11.2
62 | Middle Channel | BELT, [NAME] | 3.4
63 | [NAME] | GAGNE, [NAME] | 4.9
64 | [NAME] | CASTRO, [NAME] | 0.5
PICK # | FRANCHISE | Player Name | [NAME] | CONTRACT
65 | [NAME]
66 | [NAME]
67 | Middle Channel
68 | Menomonee
69 | Cincinnati
70 | Las Vegas
71 | Coastline
72 | Fantomz
73 | Madison East
74 | New Westminster
75 | Hollywood
76 | Kansas City A's
77 | [NAME]
78 | Clockwork
79 | Iowa
80 | Wainwright
81 | [NAME]
82 | Climax
83 | Indiana
84 | Detroit
85 | San Tan Valley
86 | Hoboken
87 | Chicago
88 | Kansas City Blues
89 | [NAME]
90 | Pigtown
91 | West Michigan
92 | Boston
93 | Fort Worth
94 | Virginia
95 | Fire Lake
96 | Motown