Spreadsheet: 880115d1727736604-searching-for-data-across-multiple-worksheets-test-october-2024
Sheet: FD24HFV

DATE | Vehicle ID | Driver | [NAME] | Fleet Comments | Status (Complete (Y) / Cancelled (N) ) | [NAME] (F / W ) | Delivery No | AI / POD | [NAME] | From | TO | Tip Arrival | Tip Departure | Waiting Time (+15 [NAME]) | Tonnes | Rate Per T | OTHER Revenue | Comments | TOTAL Miles | TOTAL Miles | Fuel Gallons Used | Actual MPG | MPG Variance |  | Total Revenue | Total Cost | Gross Profit | Gross Profit % | Net Profit | Net Profit % |  | Anticipated Load Payment | Anticipated Waiting Time Revenue (0.67Ppm) | Anticipated OTHER Revenue |  | ACTUAL Load Payment | ACTUAL Rate PAYMENT | ACTUAL Waiting Time Revenue | ACTUAL OTHER Revenue |  | [NAME] | Variance RATE Payment | [NAME] | [NAME] | Invoice Received (Y/N) | Invoice Number | Query (Y/N) | Query Number | Query Type (LOAD / RATE / OTHER) | Query PAID (Y/N) |  | FENLAND Fuel Cost | MPG Target | Fleet Cost | OH Charge | Fuel Price (Per Gallon) | Driver Cost
2024-10-01 00:00:00 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 8.64 |  |  |  |  | 296 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166 | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 8.28 |  |  |  |  | 296 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166 | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 8.77 |  |  |  |  | 296 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166 | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 9.01 |  |  |  |  | 296 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166 | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  | Weekend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 296 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  | Weekend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 296 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 8.77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166 | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 9.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166 | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 8.77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166 | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 9.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166 | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166 | 1.46
 | FEN 3 |  |  |  |  |  |  |  |  | Weekend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | FEN 3 |  |  |  |  |  |  |  |  | Weekend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166
 | FEN 3 |  |  |  |  |  |  |  |  | Weekend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | FEN 3 |  |  |  |  |  |  |  |  | Weekend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 166
 | FEN 3 |  |  |  |  |  |  |  |  | Weekend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | FEN 3 |  |  |  |  |  |  |  |  | Weekend |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | FEN 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.81 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO