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

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 # | DC or Store | 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 | 22819 | 46801 | Store | Hammond | 03:43:00 | 04:05:00 |  | 464 |  |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  |  | 110
09:00:00 |  |  |  |  |  |  |  |  | 40
10:00:00 |  |  |  |  |  |  |  |  |  |  | 10:10:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  | 11:40:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 108
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:37:00 | 1903-09-06 00:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 21858 | 46802 | DC | Hammond | 03:00:00 | 07:00:00 | AI | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 300
09:00:00 |  |  |  |  | had | trailer | issues | [NAME] | 191
10:00:00 |  |  |  |  | rolling | now |  | [NAME] | 114
11:00:00 |  |  |  |  |  |  |  | [NAME] | 88
12:00:00 |  |  |  |  |  |  |  |  |  |  | 12:00:00 | 12:10:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 32804 | 46803 | DC | Hammond | 03:59:00 | 04:13:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 164
09:00:00 |  |  |  |  |  |  |  | [NAME] | 80
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:15:00 | 10:30:00
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 21886 | 46804 | DC | Hammond | 03:50:00 | 04:09:00 | AH | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 152
09:00:00 |  |  |  |  | broke |  |  | [NAME] | 77
10:00:00 |  |  |  |  | down |  |  | [NAME] | 13
11:00:00 | L325 | on his | way to | get load |  |  |  | [NAME]
12:00:00 |  |  |  |  |  |  |  |  | 50
13:00:00 |  |  |  |  |  |  |  |  | 22 |  | 1330 | 1345
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | 32643 | 46805 | DC | Hammond | 04:04:00 | 04:29:00 | AH | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 159
09:00:00 |  |  |  |  |  |  |  | [NAME] | 90
10:00:00 |  |  |  |  | broke |  |  | [NAME]
11:00:00 | 32804 | on his |  |  | down |  |  | [NAME]
13:00:00 |  | way |  | load |  |  |  |  | 137
13:30:00 |  |  |  |  |  |  |  |  | 45 |  | 1400 | 1410
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | 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 | L325 | 46806 | DC | Hammond | 04:00:00 | 04:16:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 164
09:00:00 |  |  |  |  |  |  |  | [NAME] | 110
10:00:00 |  |  |  |  |  |  |  | [NAME] | 18 |  | 10:30:00 | 10:40:00
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00