Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 5-20

ES3/C&S WHOLESALE LOAD TRACKING
STOP 1 WILL ALWAYS BE ORIGIN - LEAVE SECTION BLANK FOR ANY NON-APPLICALBE STOP, ON ANY GIVE LOAD
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21525 | 43501 | Hammond | 03:43:00 | 04:03:00 |  | 448 | 167 |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  | 80
09:00:00 |  |  |  |  |  |  |  | 39
10:00:00 |  |  |  |  |  |  |  |  |  | 10:00:00 | 10:57:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00 | 13:15:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21445 | 43502 | Hammond | 04:00:00 | 04:14:00 |  | 460 | 200 |  |  |  |  | 456
08:00:00 |  |  |  |  |  |  |  | 94
09:00:00 |  |  |  |  |  |  |  | 49
10:00:00 |  |  |  |  |  |  |  |  |  | 10:00:00 | 10:36:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00 | 13:30:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 32502 | 43503 | Hammond | 03:28:00 | 04:25:00 |  | 527 | 140 |  |  |  |  | 553
08:00:00 |  |  |  |  |  |  |  | 77
09:00:00 |  |  |  |  |  |  |  | 26
10:00:00 |  |  |  |  |  |  |  |  |  | 09:55:00 | 10:38:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:47:00 | 13:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | L111 | 43504 | Hammond | 03:00:00 | 05:05:00 |  | 543 | 210 |  |  |  |  | 520
08:00:00 |  |  |  |  |  |  |  | 120
09:00:00 |  |  |  |  |  |  |  | 75
10:00:00 |  |  |  |  |  |  |  | 5
11:00:00 |  |  |  |  |  |  |  |  |  | 10:25:00 | 11:06:00 |  |  | 5
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:32:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21323 | 43505 | Hammond | 03:45:00 | 05:15:00 |  | 543 | 206
08:00:00 |  |  |  |  |  |  |  | 114
09:00:00 |  |  |  |  |  |  |  | 95
10:00:00 |  |  |  |  |  |  |  | 33
11:00:00 |  |  |  |  |  |  |  |  |  | 11:00:00 | 12:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 23789 | 43506 | Hammond | 03:23:00 | 04:30:00 |  | 451 | 205 |  |  |  |  | 428
08:00:00
09:00:00 |  |  |  |  |  |  |  | Mobile,Al
10:00:00 |  |  |  |  |  |  |  | Broke
11:00:00 |  |  |  |  |  |  | 180 miles | down
12:00:00 |  |  |  |  |  |  | out | sending |  | 15:15:00
13:00:00 |  |  |  |  |  |  | 171 | 32553 | 30@14:30 | miles | out to 1ST stop | miles | out | 20 | 16:45:00 | 17:00:00