Spreadsheet: 772480d1647296790-trying-to-get-rate-from-shhet-when-matching-a-and-b-test2
Sheet: BOLS

Terminal | Product Code | Product description | BOL Date | Gallons | BBL | Transport | Lubricity | Additive | Blending | Red Dye | BIO | Supplier | BOL Number | Totals
LA - LA-GATX | 122 [NAME] | 122 [NAME] | 03/02/2022 | 294714 |  |  |  |  |  |  |  | PBF Holding | RCPSA1008
LA - LA-GATX | 122 [NAME] | 122 [NAME] | 03/02/2022 | 294714 |  |  |  |  |  |  |  | PBF Holding | RCPSA1008
LA - LA-GATX | 122 [NAME] | 122 [NAME] | 03/02/2022 | 294714 |  |  |  |  |  |  |  | PBF Holding | RCPSA1008
LA - LA-GATX | 505 Pipe | 505 EPA Pipeline | 03/02/2022 | 105000 |  |  |  |  |  |  |  | Chevron | RCPW84309A
LA - LA-GATX | 505 Pipe | 505 EPA Pipeline | 03/02/2022 | 357000 |  |  |  |  |  |  |  | Chevron | RCPW84309B
LA - LA-GATX | 505 Pipe | 505 EPA Pipeline | 03/02/2022 | 609000 |  |  |  |  |  |  |  | Chevron | RCPW84309C
LA - LA-GATX | 504 Pipe | 504 CARB Pipeline | 03/05/2022 | 228480 |  |  |  |  |  |  |  | Marathon Petroleum | RCPS80009
LA - LA-GATX | 504 Pipe | 504 CARB Pipeline | 03/05/2022 | 228480 |  |  |  |  |  |  |  | Marathon Petroleum | RCPS80009
LA - LA-GATX | 504 Pipe | 504 CARB Pipeline | 03/05/2022 | 228480 |  |  |  |  |  |  |  | Marathon Petroleum | RCPS80009
LA - LA-GATX | 122 [NAME] | 122 [NAME] | 03/08/2022 | 284634 |  |  |  |  |  |  |  | Chevron | RCPSA1009
LA - LA-GATX | 122 [NAME] | 122 [NAME] | 03/08/2022 | 284634 |  |  |  |  |  |  |  | Chevron | RCPSA1009
LA - LA-GATX | 122 [NAME] | 122 [NAME] | 03/08/2022 | 284634 |  |  |  |  |  |  |  | Chevron | RCPSA1009
LA - LA-GATX | 127  Carbob/PIPE | 127  [NAME] | 03/08/2022 | 214368 |  |  |  |  |  |  |  | Chevron | RCPSB1009
LA - LA-GATX | 127  Carbob/PIPE | 127  [NAME] | 03/08/2022 | 214368 |  |  |  |  |  |  |  | Chevron | RCPSB1009
LA - LA-GATX | 127  Carbob/PIPE | 127  [NAME] | 03/08/2022 | 214368 |  |  |  |  |  |  |  | Chevron | RCPSB1009
LA - LA-GATX | 505 Pipe | 505 EPA Pipeline | 03/09/2022 | 357000 |  |  |  |  |  |  |  | Chevron | [NAME]
LA - LA-GATX | 505 Pipe | 505 EPA Pipeline | 03/09/2022 | 147000 |  |  |  |  |  |  |  | Chevron | RCPW84310B
LA - LA-GATX | 505 Pipe | 505 EPA Pipeline | 03/09/2022 | 609000 |  |  |  |  |  |  |  | Chevron | RCPW84310C
[NAME] | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 29001 |  |  |  |  |  |  |  | Kinergy Marketing LLC | CTCX733160
[NAME] | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 29001 |  |  |  |  |  |  |  | Kinergy Marketing LLC | CTCX733160
[NAME] | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 29001 |  |  |  |  |  |  |  | Kinergy Marketing LLC | CTCX733160
[NAME] | 599 Pipeline | 599 Alcohol Pipeline | 03/04/2022 | 28837 |  |  |  |  |  |  |  | Louis Dreyfus Company | [NAME]
[NAME] | 599 Pipeline | 599 Alcohol Pipeline | 03/04/2022 | 28837 |  |  |  |  |  |  |  | Louis Dreyfus Company | [NAME]
[NAME] | 599 Pipeline | 599 Alcohol Pipeline | 03/04/2022 | 28837 |  |  |  |  |  |  |  | Louis Dreyfus Company | [NAME]
NC - Bradshaw | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 7994 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117364S
NC - Bradshaw | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 7994 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117364S
NC - Bradshaw | 599 Pipeline | 599 Alcohol Pipeline | 03/08/2022 | 8197 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117391S
NC - Bradshaw | 599 Pipeline | 599 Alcohol Pipeline | 03/08/2022 | 8197 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117391S
NC - Bradshaw | 599 Pipeline | 599 Alcohol Pipeline | 03/08/2022 | 8222 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117414S
NC - Bradshaw | 599 Pipeline | 599 Alcohol Pipeline | 03/08/2022 | 8222 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117414S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8202 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117299S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8202 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117299S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8213 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117250S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8213 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117250S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8154 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117319S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8154 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117319S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8228 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117352S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8228 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117352S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/08/2022 | 8210 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117461S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/08/2022 | 8210 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117461S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/08/2022 | 8222 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117392S
NC - Chico | 599 Pipeline | 599 Alcohol Pipeline | 03/08/2022 | 8222 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117392S
NC - Fresno | 594 B99 /01 | B99 - BioDiesel/BULK | 03/01/2022 | 7000 |  |  |  |  |  |  |  | Targray | 306937
NC - Fresno | 594 B99 /01 | B99 - BioDiesel/BULK | 03/01/2022 | 7000 |  |  |  |  |  |  |  | Targray | 306937
NC - Fresno | 594 B99 /01 | B99 - BioDiesel/BULK | 03/02/2022 | 7183 |  |  |  |  |  |  |  | Seaboard Energy LLC | 810-1
NC - Fresno | 594 B99 /01 | B99 - BioDiesel/BULK | 03/02/2022 | 7183 |  |  |  |  |  |  |  | Seaboard Energy LLC | 810-1
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8108 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205865
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8108 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205865
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8109 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205864
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8109 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205864
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 7528 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205999
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 7528 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205999
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8108 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205879
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8108 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205879
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/04/2022 | 8115 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205998
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/04/2022 | 8115 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205998
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/04/2022 | 8120 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205800
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/04/2022 | 8120 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 205800
NC - Fresno | 594 B99 /01 | B99 - BioDiesel/BULK | 03/07/2022 | 7188 |  |  |  |  |  |  |  | Seaboard Energy LLC | 810-2
NC - Fresno | 594 B99 /01 | B99 - BioDiesel/BULK | 03/07/2022 | 7188 |  |  |  |  |  |  |  | Seaboard Energy LLC | 810-2
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/07/2022 | 8126 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 206075
NC - Fresno | 599 Pipeline | 599 Alcohol Pipeline | 03/07/2022 | 8126 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 206075
NC - Fresno | 594 B99 /01 | B99 - BioDiesel/BULK | 03/08/2022 | 7187 |  |  |  |  |  |  |  | Seaboard Energy LLC | 810-3
NC - Fresno | 594 B99 /01 | B99 - BioDiesel/BULK | 03/08/2022 | 7187 |  |  |  |  |  |  |  | Seaboard Energy LLC | 810-3
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/01/2022 | 8145 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117209S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/01/2022 | 8145 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117209S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/01/2022 | 8021 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117180S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/01/2022 | 8021 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117180S
NC - San Jose | 127  Carbob/PIPE | 127  [NAME] | 03/02/2022 | 105000 |  |  |  |  |  |  |  | [NAME] | VALNB3509
NC - San Jose | 127  Carbob/PIPE | 127  [NAME] | 03/02/2022 | 105000 |  |  |  |  |  |  |  | [NAME] | VALNB3509
NC - San Jose | 127  Carbob/PIPE | 127  [NAME] | 03/02/2022 | 105000 |  |  |  |  |  |  |  | [NAME] | VALNB3509
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8011 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117241S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8011 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117241S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8156 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117269S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 8156 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117269S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8121 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117307S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8121 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117307S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8108 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117369S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8108 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117369S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/07/2022 | 7974 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117374S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/07/2022 | 7974 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117374S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/08/2022 | 7890 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117397S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/08/2022 | 7890 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117397S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/09/2022 | 7713 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117473S
NC - San Jose | 599 Pipeline | 599 Alcohol Pipeline | 03/09/2022 | 7713 |  |  |  |  |  |  |  | Kinergy Marketing LLC | 117473S
SD - San Diego | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 7930 |  |  |  |  |  |  |  | [NAME] | 7024775
SD - San Diego | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 7951 |  |  |  |  |  |  |  | [NAME] | 7024797
SD - San Diego | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8029 |  |  |  |  |  |  |  | [NAME] | 3607530
SD - San Diego | 599 Pipeline | 599 Alcohol Pipeline | 03/03/2022 | 8017 |  |  |  |  |  |  |  | [NAME] | 7024794
SD - San Diego | 599 Pipeline | 599 Alcohol Pipeline | 03/04/2022 | 7937 |  |  |  |  |  |  |  | [NAME] | 7024819
SD - San Diego | 599 Pipeline | 599 Alcohol Pipeline | 03/07/2022 | 7932 |  |  |  |  |  |  |  | [NAME] | 7024851
SD - San Diego | 599 Pipeline | 599 Alcohol Pipeline | 03/07/2022 | 8024 |  |  |  |  |  |  |  | [NAME] | 7024843
SD - San Diego | 594 B99 /01 | B99 - BioDiesel/BULK | 03/08/2022 | 6016 |  |  |  |  |  |  |  | The BioFuel Agency | RCP03-01
SD - San Diego | 594 B99 /01 | B99 - BioDiesel/BULK | 03/08/2022 | 6016 |  |  |  |  |  |  |  | The BioFuel Agency | RCP03-01
SD - San Diego | 594 B99 /01 | B99 - BioDiesel/BULK | 03/09/2022 | 6014 |  |  |  |  |  |  |  | The BioFuel Agency | RCP03-02
SD - San Diego | 594 B99 /01 | B99 - BioDiesel/BULK | 03/09/2022 | 6014 |  |  |  |  |  |  |  | The BioFuel Agency | RCP03-02
SPK - Sparks | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 67200 |  |  |  |  |  |  |  | ConocoPhillips Co | 1231257
SPK - Sparks | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 67200 |  |  |  |  |  |  |  | ConocoPhillips Co | 1231257
SPK - Sparks | 599 Pipeline | 599 Alcohol Pipeline | 03/02/2022 | 67200 |  |  |  |  |  |  |  | ConocoPhillips Co | 1231257
SPK - Sparks | 599 Pipeline | 599 Alcohol Pipeline | 03/09/2022 | 63000 |  |  |  |  |  |  |  | ConocoPhillips Co | 1232758
SPK - Sparks | 599 Pipeline | 599 Alcohol Pipeline | 03/09/2022 | 63000 |  |  |  |  |  |  |  | ConocoPhillips Co | 1232758
SPK - Sparks | 599 Pipeline | 599 Alcohol Pipeline | 03/09/2022 | 63000 |  |  |  |  |  |  |  | ConocoPhillips Co | 1232758