Spreadsheet: 731998d1620739959-extract-data-based-on-a-drop-down-list-selection-version-10
Sheet: Market

 |  |  |  |  |  |  | Merchant # 1 |  |  | Merchant # 2 |  |  | Merchant # 3 |  |  | Merchant # 4 |  |  | Merchant # 5 |  |  | Merchant # 6 |  |  | Merchant # 7 |  |  | Merchant # 8 |  |  | Merchant # 9 |  |  | Merchant # 10
Vessel | Species | Grade | Presentation | [NAME] | Total Boxes | Boxes Remaining | Merchant | Boxes | Price | Merchant | Boxes | Price | Merchant | Boxes | Price | Merchant | Boxes | Price | Merchant | Boxes | Price | Merchant | Boxes | Price | Merchant | Boxes | Price | Merchant | Boxes | Price | Merchant | Boxes | Price | Merchant | Boxes | Price |  | Vessel | Total Boxes | Areas fished
UL44 | ANF | 1 | GH | 45 | 0.5 |  | WL | 0.5 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4a, 6
UL44 | ANF | 2 | GH | 45 | 2.5 |  | WC | 2.5 | 114 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6a
UL44 | ANF | 3 | GH | 45 | 13.25 |  | PWELL | 1 | 130 | WC | 12.25 | 120 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4a, 6
UL44 | ANF | 4 | GH | 45 | 15 |  | WC | 15 | 114
UL44 | ANF | 5 | GH | 45 | 19 |  | WC | 19 | 110
UL44 | ANF | 6 | GH | 45 | 8 |  | WT | 8 | 70
UL44 | LEZ | 1 | GH | 35 | 10.25 |  | WC | 10.25 | 150
UL44 | LEZ | 2 | GH | 35 | 9 |  | WC | 9 | 114
UL44 | LEZ | 3 | GH | 35 | 6.75 |  | WC | 6.75 | 90
UL44 | LEZ | 4 | GH | 35 | 8 |  | WC | 8 | 76
UL44 | LEZ | B | GH | 35 | 4 |  | WC | 4 | 46
UL44 | COD | 1 | GH | 35 | 4 |  | CPM | 4 | 122
UL44 | COD | 2 | GH | 35 | 6 |  | CPM | 1 | 120 | PWELL | 1 | 120 | BL | 4 | 118
UL44 | COD | 4 | GH | 35 | 1 |  | HD | 1 | 91
UL44 | HAD | 3 | GH | 40 | 0.5 |  | PWELL | 0.5 | 122
UL44 | HAD | 4 | GH | 40 | 1 |  | PWELL | 1 | 122
UL44 | HAD | 5 | GH | 40 | 2 |  | HD | 2 | 110
UL44 | HAD | 6 | GH | 40 | 3.75 |  | WT | 2 | 80 | JPL | 1.75 | 75
UL44 | RJM | 3 | GH | 45 | 5 |  | PWELL | 1 | 66 | WC | 4 | 55
UL44 | RJM | 4 | GH | 45 | 3 |  | WC | 3 | 48
UL44 | [NAME] | 4 | GH | 45 | 2.5 |  | BL | 0.5 | 40 | HD | 2 | 40
UL44 | RJC | 2 | GH | 45 | 0.75 |  | HD | 0.75 | 64
UL44 | WHG | 2 | GH | 40 | 1 |  | WT | 1 | 114
UL44 | WHG | 4 | WF | 40 | 6.5 |  | WT | 6.5 | 76
UL44 | LEM | 1 | GH | 5 | 1 |  | PWELL | 1 | 40
UL44 | LEM | 2 | GH | 31 | 1 |  | PWELL | 1 | 150
UL44 | LEM | 3 | GH | 40 | 2.25 |  | HD | 2.25 | 71
UL44 | HKE | 2 | GH | 35 | 0.25 |  | PWELL | 0.25 | 80
UL44 | HKE | 4 | GH | 35 | 1 |  | BL | 1 | 52
UL44 | HKE | 5 | GH | 35 | 1 |  | WL | 1 | 45
UL44 | HKE | 6 | GH | 35 | 2 |  | WL | 2 | 35
UL44 | LIN | 2 | GH | 40 | 1.75 |  | WC | 1.75 | 20
UL44 | WIT | U | GH | 5 | 1 |  | JPL | 1 | 5
UL44 | PLE | 3 | GH | 45 | 0.25 |  | JPL | 0.25 | 40
UL44 | PLE | 4 | GH | 45 | 1 |  | BL | 1 | 20
UL44 | JOD | U | GH | 6 | 1 |  | JPL | 1 | 20
UL44 | TBT | U | GH | 27 | 1 |  | WC | 1 | 275
UL44 | BLL | U | GH | 16 | 1 |  | JPL | 1 | 140
BF505 | COD | 1 | GH | 35 | 21 |  | CPM | 5 | 116 | WT | 5 | 116 | JPL | 2 | 116 | BL | 9 | 112
BF505 | COD | 2 | GH | 35 | 4 |  | WT | 4 | 106
BF505 | COD | 3 | GH | 35 | 6 |  | HD | 2 | 98 | WT | 4 | 95
BF505 | LEZ | 1 | GH | 35 | 9 |  | WC | 9 | 122
BF505 | LEZ | 2 | GH | 35 | 5 |  | WC | 5 | 86
BF505 | LEZ | 4 | GH | 35 | 6.75 |  | WC | 6.75 | 53
BF505 | LEZ | B | GH | 35 | 1 |  | WL | 1 | 20
BF505 | USK | U | GH | 45 | 0.5 |  | [NAME] | 0.5 | 20
BF505 | JOD | U | GH | 35 | 2.5 |  | OT | 1 | 300 | BL | 1 | 230 | WC | 0.5 | 230
BF505 | HKE | 2 | GH | 32 | 15 |  | CPM | 10 | 142 | BL | 5 | 142
BF505 | HKE | 3 | GH | 32 | 31 |  | HD | 12 | 74 | BL | 1 | 74 | HD | 2 | 66 | WT | 12 | 63 | WL | 4 | 60
BF505 | HKE | 4 | GH | 32 | 55 |  | HD | 15 | 50 | WL | 40 | 47
BF505 | HKE | 5 | GH | 32 | 30 |  | WL | 30 | 42
BF505 | LEM | 1 | GH | 32 | 1 |  | OT | 1 | 355
BF505 | LEM | 2 | GH | 32 | 3 |  | WC | 2 | 220 | HD | 1 | 100
BF505 | LEM | 3 | GH | 32 | 5.75 |  | HD | 2.75 | 80 | WC | 3 | 20
BF505 | ANF | 1 | GH | 50 | 6 |  | WL | 6 | 112
BF505 | ANF | 2 | GH | 50 | 13 |  | WT | 7 | 121 | WL | 6 | 118
BF505 | ANF | 3 | GH | 50 | 9 |  | BL | 2 | 124 | WC | 7 | 123
BF505 | ANF | 4 | GH | 50 | 21.25 |  | WL | 21 | 128 | WT | 0.25 | 128
BF505 | ANF | 5 | GH | 50 | 13 |  | WL | 13 | 126
BF505 | ANF | 6 | GH | 50 | 2 |  | HD | 2 | 100
BF505 | POK | 1 | GH | 45 | 3 |  | BL | 1 | 50 | WT | 2 | 35
BF505 | POK | 2 | GH | 45 | 4 |  | HD | 2 | 37 | WT | 2 | 35
BF505 | POK | 4 | GH | 45 | 11 |  | WT | 11 | 35
BF505 | POL | 1 | GH | 43 | 202 |  | HD | 202 | 70
BF505 | POL | 2 | GH | 43 | 17 |  | WT | 17 | 72
BF505 | POL | 3 | GH | 43 | 2.25 |  | WL | 2.25 | 65
BF505 | HBT | U | GH | 8 | 1 |  | WC | 1 | 114
BF505 | TBT | U | GH | 8 | 1 |  | WC | 1 | 80
BF505 | TBT | U | GH | 7.8 | 1 |  | WC | 1 | 80
BF505 | TBT | U | GH | 5.2 | 1 |  | BL | 1 | 52
BF505 | TBT | U | GH | 4.3 | 1 |  | BL | 1 | 43
BF505 | TBT | U | GH | 4 | 2 |  | BL | 1 | 40 | WC | 1 | 40
BF505 | TBT | U | GH | 3.2 | 1 |  | WC | 1 | 32
BF505 | TBT | U | GH | 3 | 1 |  | WC | 1 | 30
BF505 | TBT | U | GH | 2.8 | 1 |  | WT | 1 | 29.03
BF505 | TBT | U | GH | 2.6 | 1 |  | WT | 1 | 26.97
BF505 | LIN | 1 | GH | 45 | 15 |  | WC | 15 | 16
BF505 | LIN | 2 | GH | 45 | 168 |  | WC | 102 | 21 | WT | 12 | 20 | WC | 54 | 17
BF505 | HAD | 1 | GH | 45 | 0.25 |  | WC | 0.25 | 100
BF505 | HAD | 2 | GH | 45 | 6.25 |  | HD | 4 | 70 | WC | 0.25 | 100
BF505 | HAD | 3 | GH | 45 | 13 |  | HD | 10 | 122 | WC | 3 | 100
BF505 | HAD | 4 | GH | 45 | 19 |  | CS | 1 | 134 | HD | 10 | 134 | WC | 8 | 110
BF505 | HAD | 5 | GH | 45 | 25 |  | HD | 12 | 118 | WC | 6 | 118 | WC | 2 | 100 | HH | 1 | 50 | BL | 4 | 20
BF505 | HAD | 6 | GH | 45 | 45.5 |  | WT | 1.5 | 92 | CPM | 5 | 92 | HD | 13 | 92 | HD | 20 | 70 | HD | 6 | 40
BF505 | WHG | 2 | GH | 45 | 15.25 |  | WC | 12 | 130 | WT | 3.25 | 100
BF505 | WHG | 3 | GH | 45 | 30.25 |  | WT | 8.25 | 101 | HD | 2 | 101 | HD | 5 | 100 | WC | 15 | 95
BF505 | SQU | U | WF | 25 | 12.5 |  | CPM | 2 | 125 | BL | 3 | 125 | BL | 2 | 105 | WL | 5.5 | 100
BCK35 | COD | 1 | GH | 35 | 85 |  | CPM | 5 | 116 | WC | 15 | 113 | HD | 6 | 113 | WC | 2 | 113 | BL | 8 | 113 | WT | 9 | 113 | WL | 20 | 110 | BL | 11 | 108 | WL | 4 | 110 | WC | 5 | 100
BCK35 | COD | 2 | GH | 35 | 82 |  | HD | 26 | 100 | HD | 4 | 100 | WC | 24 | 96 | WL | 28 | 93
BCK35 | COD | 3 | GH | 35 | 24 |  | HD | 4 | 92 | WT | 15 | 90 | HD | 5 | 90
BCK35 | ANF | 1 | GH | 50 | 7.75 |  | WL | 7.75 | 112
BCK35 | ANF | 2 | GH | 50 | 4 |  | BL | 2 | 120 | WL | 2 | 118
BCK35 | ANF | 3 | GH | 50 | 8 |  | CPM | 2 | 130 | WC | 1 | 130 | HD | 2 | 124 | WC | 3 | 120
BCK35 | ANF | 4 | GH | 50 | 31.5 |  | WC | 31.5 | 124
BCK35 | ANF | 5 | GH | 50 | 31.5 |  | HD | 20 | 107 | WT | 11.5 | 104
BCK35 | ANF | 6 | GH | 50 | 13.75 |  | WT | 13.75 | 76
BCK35 | LEZ | 1 | GH | 31 | 7.75 |  | BL | 1 | 130 | WC | 6.75 | 120
BCK35 | LEZ | 2 | GH | 31 | 1 | WC | WC | 1 | 86
BCK35 | LEZ | 3 | GH | 31 | 6 |  | WC | 6 | 66
BCK35 | LEZ | 4 | GH | 31 | 11 |  | WC | 11 | 52
BCK35 | LEZ | B | GH | 31 | 3 |  | WL | 3 | 20
BCK35 | LIN | 1 | GH | 40 | 9 |  | HD | 4 | 20 | WC | 5 | 18
BCK35 | LIN | 2 | GH | 40 | 7 |  | WC | 7 | 18
BCK35 | LIN | 3 | GH | 40 | 5 |  | WC | 5 | 16
BCK35 | WHG | 4 | WF | 35 | 32 |  | HD | 21 | 58 | WT | 11 | 55
BCK35 | LEM | 2 | GH | 40 | 5.5 |  | CPM | 1 | 345 | BL | 1.5 | 345 | HD | 3 | 300
BCK35 | LEM | 3 | GH | 40 | 10.5 |  | HD | 10.5 | 80
BCK35 | HKE | 4 | GH | 35 | 2 |  | WL | 2 | 54
BCK35 | HKE | 5 | GH | 35 | 3 |  | WL | 3 | 50
BCK35 | WIT | U | GH | 40 | 5 |  | CPM | 2 | 40 | HD | 3 | 30
BCK35 | POK | 1 | GH | 36 | 1 |  | HD | 1 | 26
BCK35 | POL | 2 | GH | 38 | 1.75 |  | WL | 1.75 | 58
BCK35 | SQU | U | WF | 30 | 1.5 |  | JPL | 1 | 20 | BL | 0.5 | 60
BCK35 | JOD | U | WF | 20 | 1 |  | HD | 1 | 95
BCK35 | TBT | U | GH | 10 | 1 |  | BL | 1 | 100
BCK35 | HAD | 2 | GH | 35 | 4.75 |  | WC | 2 | 50 | BL | 2.75 | 50
BCK35 | HAD | 3 | GH | 35 | 3 |  | WC | 3 | 35
BCK35 | HAD | 4 | GH | 35 | 4 |  | BL | 4 | 40
BCK35 | HAD | 5 | GH | 35 | 3 |  | HD | 3 | 40
BCK35 | HAD | 6 | GH | 35 | 4 |  | CPM | 3 | 30 | HD | 1 | 20