Spreadsheet: 845654d1697071866-matching-up-run-number-with-date-and-time-in-one-cell-tracker-test
Sheet: Tracker

Carrier | 1 | Load type | Location Code | City | ST | Arrive | [NAME] | Trailer Type | Stop Time | F/L Stop | MAX
Test 1 | 1 | SAC71349870 | 16487 | CARUTHERS | CA | 2023-10-10 06:42:00 | 184.7 | 53R | 00:53:00 | 19:00:00 | 53
Test 1 | 1 | SAC71349870 | 16004 | [NAME] | CA | 2023-10-10 07:55:00 | 14 | 53R | 00:56:00 | 19:00:00 | 53
Test 1 | 1 | SAC71349870 | 16266 | LATON | CA | 2023-10-10 09:06:00 | 10 | 53R | 00:47:00 | 19:00:00 | 53
Test 1 | 1 | SAC71349870 | 15044 | PAHRUMP | NV | 2023-10-11 07:00:00 | 374.3 | 53R | 01:01:00 | 19:00:00 | 53
Test 1 | 1 | SAC71349870 | 13578 | BARSTOW | CA | 2023-10-11 11:07:00 | 150.4 | 53R | 01:20:00 | 19:00:00 | 53
Carrier | 1 | Load type | Location Code | City | ST | Arrive | [NAME] | Trailer Type | Stop Time | F/L Stop | MAX
Test 2 | 1 | [NAME] | 16487 | CARUTHERS | CA | 2023-10-10 06:42:00 | 184.7 | 53R | 00:53:00 | 20:00:00 | 53
Test 2 | 1 | [NAME] | 16004 | [NAME] | CA | 2023-10-10 07:55:00 | 14 | 53R | 00:56:00 | 20:00:00 | 53
Test 2 | 1 | [NAME] | 16266 | LATON | CA | 2023-10-10 09:06:00 | 10 | 53R | 00:47:00 | 20:00:00 | 53
Test 2 | 1 | [NAME] | 15044 | PAHRUMP | NV | 2023-10-11 07:00:00 | 374.3 | 53R | 01:01:00 | 20:00:00 | 53
Test 2 | 1 | [NAME] | 13578 | BARSTOW | CA | 2023-10-11 11:07:00 | 150.4 | 53R | 01:20:00 | 20:00:00 | 53
Carrier | 2 | Load type | Location Code | City | ST | Arrive | [NAME] | Trailer Type | Stop Time | F/L Stop | MAX
Test 3 | 2 | SAC71349872 | 16483 | MYRTLE CREEK | OR | 2023-10-11 08:44:00 | 389.2 | 53R | 00:51:00 | 15:37:00 | 53
Test 3 | 2 | SAC71349872 | 15483 | WINSTON | OR | 2023-10-11 11:00:00 | 15.6 | 53R | 01:09:00 | 15:37:00 | 53
Test 3 | 2 | SAC71349872 | 20154 | MYRTLE POINT | OR | 2023-10-11 13:15:00 | 49.2 | 53R | 00:48:00 | 15:37:00 | 53
Test 3 | 2 | SAC71349872 | 17097 | PORT ORFORD | OR | 2023-10-11 15:11:00 | 52.9 | 53R | 01:10:00 | 15:37:00 | 53
Test 3 | 2 | SAC71349872 | 16451 | LAKESIDE | OR | 2023-10-11 17:42:00 | 66.3 | 53R | 00:49:00 | 15:37:00 | 53
Test 3 | 2 | SAC71349872 | 17726 | DRAIN | OR | 2023-10-12 08:00:00 | 60.4 | 53R | 01:16:00 | 15:37:00 | 53
Test 3 | 2 | SAC71349872 | 15774 | SUTHERLIN | OR | 2023-10-12 09:45:00 | 22.5 | 53R | 01:15:00 | 15:37:00 | 53
Carrier | 2 | Load type | Location Code | City | ST | Arrive | [NAME] | Trailer Type | Stop Time | F/L Stop | MAX
Test 4 | 2 | SAC71349873 | 16483 | MYRTLE CREEK | OR | 2023-10-11 08:44:00 | 389.2 | 53R | 00:51:00 | 16:37:00 | 53
Test 4 | 2 | SAC71349873 | 15483 | WINSTON | OR | 2023-10-11 11:00:00 | 15.6 | 53R | 01:09:00 | 16:37:00 | 53
Test 4 | 2 | SAC71349873 | 20154 | MYRTLE POINT | OR | 2023-10-11 13:15:00 | 49.2 | 53R | 00:48:00 | 16:37:00 | 53
Test 4 | 2 | SAC71349873 | 17097 | PORT ORFORD | OR | 2023-10-11 15:11:00 | 52.9 | 53R | 01:10:00 | 16:37:00 | 53
Test 4 | 2 | SAC71349873 | 16451 | LAKESIDE | OR | 2023-10-11 17:42:00 | 66.3 | 53R | 00:49:00 | 16:37:00 | 53
Test 4 | 2 | SAC71349873 | 17726 | DRAIN | OR | 2023-10-12 08:00:00 | 60.4 | 53R | 01:16:00 | 16:37:00 | 53
Test 4 | 2 | SAC71349873 | 15774 | SUTHERLIN | OR | 2023-10-12 09:45:00 | 22.5 | 53R | 01:15:00 | 16:37:00 | 53