Spreadsheet: 117076d1312428746-if-function-between-sheets-with-text-and-numbers-load
Sheet: INPUT

Driver # | Book Date | Company | Load # | [NAME] | Fuel | [NAME] | Shared | PU Date | PU Time | City, State | Drop Date | Drop Time | City, State | Truck | Trailer #(s)
 |  |  |  |  |  |  | Load
HET101 | 2011-07-22 00:00:00 | [NAME] | 102405390 | 548.1 | 178.64 |  |  | 2011-07-23 00:00:00 | 18:00:00 | Bolingbrook, IL | 2011-07-25 00:00:00 | 10:00:00 | [NAME], MN | 1 | 124034
KUR001 | 2011-07-22 00:00:00 | Blue Line | 102404615 | 482.4 | 176.88 |  |  | 2011-07-25 00:00:00 | Anytime | Chanhassen, MN | 2011-07-26 00:00:00 | FCFS | Elk [NAME], IL | 1 | 843530
BAG001 | 2011-07-25 00:00:00 | CH [NAME] | 94950354 | 750 | 52 |  |  | 2011-07-26 00:00:00 | Apt | Alsip, IL | 2011-07-27 00:00:00 | 6:00 - 14:00 | Albertville, MN | 2 | 843530
CAT001 | 2011-07-26 00:00:00 | [NAME] | 102407050 | 511.2 | 231.7 | 40 |  | 2011-07-26 00:00:00 | 08:00:00 | Chanhassen, MN | 2011-07-27 00:00:00 | 09:00:00 | St Louis, MO | 4 | 843530
[NAME] | 2011-07-25 00:00:00 | CH [NAME] | 94950354 | 750 | 732 |  | CAT002 | 2011-07-26 00:00:00 | Apt | Alsip, IL | 2011-07-27 00:00:00 | 6:00 - 14:00 | Albertville, MN | 1 | 843530
KUE001 | 2011-07-26 00:00:00 | [NAME] | 102407050 | 511.2 | 231.7 |  |  | 2011-07-26 00:00:00 | 08:00:00 | Chanhassen, MN | 2011-07-27 00:00:00 | 09:00:00 | Chicago, IL | 5 | 843530
[NAME] | 2011-07-27 00:00:00 | RoadCo | 102999999 | 1500 | 500 |  |  | 2011-07-28 00:00:00 | FCFS | Menomonie, WI | 2011-07-29 00:00:00 | FCFS | [NAME], WI | 5 | 128415
HET002 | 2011-07-27 00:00:00 | [NAME] | 102407050 | 511.2 | 231.7 |  |  | 2011-07-29 00:00:00 | 09:30:00 | Chanhassen, MN | 2011-07-30 00:00:00 | 09:00:00 | Elmhurst, IL | 12 | 843530
PLA102 | 2011-07-28 00:00:00 | CH [NAME] | 94950354 | 750 | 550 | 80 |  | 2011-07-30 00:00:00 | Anytime | Alsip, IL | 2011-07-31 00:00:00 | 6:00 - 14:00 | Albertville, MN | 1 | 843530
PLA103 | 2011-07-28 00:00:00 | [NAME] | 102407050 | 511.2 | 65 |  |  | 2011-07-30 00:00:00 | 09:45:00 | Menomonie, WI | 2011-07-31 00:00:00 | 09:00:00 | Elmhurst, IL | 1 | 843530
PLA101 | 2011-07-29 00:00:00 | CH [NAME] | 94950354 | 750 | 654 |  |  | 2011-07-30 00:00:00 | Apt | Minneapolis, MN | 2011-07-31 00:00:00 | 6:00 - 14:00 | Albertville, MN | 4 | 843530
BOW002 | 2011-07-29 00:00:00 | [NAME] | 102407050 | 511.2 | 132 |  |  | 2011-08-03 00:00:00 | 14:00:00 | Chanhassen, MN | 2011-08-04 00:00:00 | 09:00:00 | Fargo, ND | 3 | 120485
LAH001 | 2011-07-30 00:00:00 | CH [NAME] | 94950354 | 750 | 321 |  |  | 2011-08-01 00:00:00 | Anytime | Fargo, ND | 2011-08-02 00:00:00 | 6:00 - 14:00 | Albertville, MN | 12 | 120684
HET004 | 2011-07-30 00:00:00 | Alpha Baking | 102407050 | 511.2 | 231 |  |  | 2011-08-01 00:00:00 | 08:00:00 | Chanhassen, MN | 2011-08-04 00:00:00 | 09:00:00 | Elmhurst, IL | 14 | 120486
BOW001 | 2011-07-31 00:00:00 | CH [NAME] | 94950354 | 750 | 261 |  | HET005 | 2011-08-03 00:00:00 | Apt | Lakeville, MN | 2011-08-04 00:00:00 | 6:00 - 14:00 | Albertville, MN | 2 | 126784
KUR002 | 2011-07-31 00:00:00 | Alpha Baking | 102407050 | 511.2 | 615 |  |  | 2011-08-01 00:00:00 | 10:00:00 | Chanhassen, MN | 2011-08-06 00:00:00 | 09:00:00 | Elmhurst, IL | 4 | 125984
LLO001 | 2011-08-01 00:00:00 | CH [NAME] | 94950354 | 750 | 324 |  |  | 2011-08-04 00:00:00 | 05:00:00 | Alsip, IL | 2011-08-06 00:00:00 | 6:00 - 14:00 | Hudson, WI | 5 | 843530
GIE201 | 2011-08-01 00:00:00 | [NAME] | 102407050 | 511.2 | 651 | 20 |  | 2011-08-02 00:00:00 | 18:00:00 | Chicago, IL | 2011-08-03 00:00:00 | 09:00:00 | Elmhurst, IL | 5 | 843530
LAH002 | 2011-08-02 00:00:00 | CH [NAME] | 94950354 | 750 | 365 |  |  | 2011-08-02 00:00:00 | Apt | Alsip, IL | 2011-08-03 00:00:00 | 6:00 - 14:00 | Kansas City, MO | 5 | 843530
HUG101 | 2011-08-02 00:00:00 | [NAME] | 102407050 | 511.2 | 354 |  |  | 2011-08-04 00:00:00 | 08:00:00 | Chanhassen, MN | 2011-08-06 00:00:00 | 09:00:00 | Elmhurst, IL | 3 | 843530