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

2014-05-30 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 | L111 | 46601 | Store | Hammond | 03:46:00 | 04:00:00 |  | 464 | 150 |  |  |  |  | 445
08:00:00 |  |  |  |  |  |  |  |  | 72
09:00:00 |  |  |  |  |  |  |  |  |  |  | 09:20:00
10:00:00 |  |  |  |  |  |  |  |  |  |  |  | 10:35:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:03: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 | 801478 | 46602 | DC | Hammond | 04:00:00 | 04:18:00 |  | [NAME] | 190
08:00:00 |  |  |  |  |  |  |  | [NAME] | 143
09:00:00 |  |  |  |  |  |  |  | [NAME] | 55
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 | 21329 | 46603 | DC | Hammond | 03:00:00 | 04:30:00 |  | [NAME] | 182
08:00:00 |  |  |  |  |  |  |  | [NAME] | 145
09:00:00 |  |  |  |  |  |  |  | [NAME] | 52
10:00:00 |  |  |  |  |  |  |  | [NAME] | 10 |  | 10:25:00 | 10:40: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 | 1810 | 46604 | DC | Hammond | 05:45:00 | 06:15:00 |  | [NAME] | 288
08:00:00 |  |  |  |  |  |  |  | [NAME] | 230
09:00:00 |  |  |  |  |  |  |  | [NAME] | 146
10:00:00 |  |  |  |  |  |  |  | [NAME] | 80
11:00:00 |  |  |  |  |  |  |  | [NAME] | 35 |  | 11:30:00
12:00: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 | 21886 | 46605 | DC | Hammond | 03:00:00 | 03:51:00 |  | [NAME] | 150
08:00:00 |  |  |  |  |  |  |  | [NAME] | 89
09:00:00 |  |  |  |  |  |  |  | [NAME] | 5
10:00:00 |  |  |  |  |  |  |  | [NAME] |  |  | 09:30:00 | 09:45: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 | 32804 | 46606 | DC | Hammond | 05:22:00 | 05:55:00 |  | [NAME] | 250
08:00:00 |  |  |  |  |  |  |  | [NAME] | 180
09:00:00 |  |  |  |  |  |  |  | [NAME] | 134
10:00:00 |  |  |  |  |  |  |  | [NAME] | 65
11:00:00 |  |  |  |  |  |  |  | [NAME] | 30
12:00:00 |  |  |  |  |  |  |  |  |  |  | 12:00:00 | 12:30:00
13:00:00