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

2014-05-29 00:00:00
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 | 34084 | 45601 | Store | Hammond | 03:45:00 | 04:00:00 |  | 525 |  |  |  |  | OK | 253
08:00:00 |  |  |  |  |  |  |  |  | 253
09:00:00 |  |  |  |  |  |  |  |  | 132
10:00:00
11:00:00 |  |  |  |  |  |  |  |  | 54
12:00:00 |  |  |  |  |  |  |  |  | 17
13:00:00 |  |  |  |  |  |  |  |  |  |  | 12:30:00 | 13:30:00 |  |  | 29 |  | 14:15:00 | 14:45: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 | L173 | 45602 | DC | Hammond | 03:00:00 | 03:50:00 |  | [NAME] |  |  |  |  | OK
08:00:00 |  |  |  |  |  |  |  | [NAME] | 144
09:00:00 |  |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:15:00 | 09: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 | 32608 | 45603 | DC | Hammond | 02:30:00 | 04:50:00 |  | [NAME] |  |  |  |  | OK
08:00:00 |  |  |  |  |  |  |  | [NAME] | 168
09:00:00 |  |  |  |  |  |  |  | [NAME] | 20
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10;05 | 10:20: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 | 629810 | 45604 | DC | Hammond | 04:00:00 | 04:15:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 209
09:00:00 |  |  |  |  |  |  |  | [NAME] | 40
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 | 91057 | 45605 | DC | Hammond | 03:00:00 | 04:45:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 200
09:00:00 |  |  |  |  |  |  |  | [NAME] | 88
10:00:00 |  |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  |  | [NAME] | 20 |  | 11:27:00 | 11:45:00
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 | 7809 | 45606 | DC | Hammond | 03:00:00 | 04:36:00 |  | [NAME]
08:00:00 |  |  |  |  |  |  |  | [NAME] | 152
09:00:00 |  |  |  |  |  |  |  | [NAME] | 43
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 10:15:00 | 10:30:00
11:00:00 |  |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00