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

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 | 47101 | Store | Hammond | 03:36:00 | 04:00:00 | OK | 517 | 234 |  |  |  |  | 434 |  |  |  |  |  | 525
08:00:00 |  |  |  |  |  |  |  |  | 140
09:00:00 |  |  |  |  |  |  |  |  | 86
10:00:00 |  |  |  |  |  |  |  |  | 10 |  | 10:23:00 | 10:55:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  | 12:57:00 |  | AM |  |  |  |  |  |  | Having break down pallets
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:24:00 | 15:00:00 | Ok | to get in the door
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 | 52023 | 47102 | Store | Hammond | 04:00:00 | 04:15:00 | OK | 509 | 267 |  |  |  |  | 429 |  |  |  |  |  | 462
08:00:00 |  |  |  |  |  |  |  |  | 190
09:00:00 |  |  |  |  |  |  |  |  | 140
10:00:00 |  |  |  |  |  |  |  |  | 40
11:00:00 |  |  |  |  |  |  |  |  | 10 |  | 11:19:00 | 11:47:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:34:00 | 14:42:00 | OK |  | 5 |  | 14:57:00 | 15:45:00 | OK
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 | 47103 | Store | Hammond | 03:53:00 | 06:50:00 | AM | 435 | 367 |  |  |  |  | 442 |  |  |  |  |  |  |  |  |  |  |  | Had to adjust load
08:00:00 |  |  |  |  |  |  |  |  | 295 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Just leaving @6:50
09:00:00 |  |  |  |  |  |  |  |  | 237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | over weight
10:00:00 |  |  |  |  |  |  |  |  | 157
11:00:00 |  |  |  |  |  |  |  |  | 110
12:00:00 |  |  |  |  |  |  |  |  | 42 |  | 12:47:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  | 14:24:00 | OK |  | 5 |  | 14:58:00 | 15:20:00 | OK
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 | 32537 | 47104 | Store | Hammond | 03:56:00 | 04:14:00 | OK | 479 | 218 |  |  |  |  | 526
08:00:00 |  |  |  |  |  |  |  |  | 183
09:00:00 |  |  |  |  |  |  |  |  | 107 |  |  |  | A1 |  |  |  |  |  |  |  |  |  |  |  |  | Drive tire blow out
10:00:00 |  |  |  |  |  |  |  |  | 107 |  |  |  | A1 |  |  |  |  |  |  |  |  |  |  |  |  | getting it fixed @
11:00:00 |  |  |  |  |  |  |  |  | 107 |  |  |  | A1 |  |  |  |  |  |  |  |  |  |  |  |  | TA @ Meridian,MS
12:00:00 |  |  |  |  |  |  |  |  | 107 |  |  |  | A1 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
13:00:00 |  |  |  |  |  |  | 15:00:00 |  | 6 |  | 15:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 TRUCKS AHEAD OF | leaving the shop now
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HIM @ 10:10 | 13:40
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 | 32802 | 47105 | Store | Hammond | 03:30:00 | 04:21:00 | OK | 479 | 200 |  |  |  |  | 528
08:00:00 |  |  |  |  |  |  |  |  | 105
09:00:00 |  |  |  |  |  |  |  |  | 50
10:00:00 |  |  |  |  |  |  |  |  |  |  | 09:54:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  | 10:43:00 | OK |  | 3 |  | 11:10:00
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:05:00 | OK
13:30: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 | 47106 | Store | Hammond | 03:12:00 | 06:50:00 | OK | 458 | 229 |  |  |  |  | 496
08:00:00 |  |  |  |  |  |  |  |  | 138
09:00:00 |  |  |  |  |  |  |  |  | 85
10:00:00 |  |  |  |  |  |  |  |  | 15 |  | 10:28:00
11:00:00 |  |  |  |  |  |  |  |  |  |  |  | 11:19:00
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 |  | 12:21:00 |  | OK
13:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:25:00