Spreadsheet: 72581d1273260334-formatting-logic-issue-automated-kwex-stat
Sheet: Request Data

PL# Pick up | BL # | Company | Contact | ETD | ETA | ATD | ATA | Org. Company | Org. Address | Org. City | Org. State | Org. Zipcode | Org. Country | Consignee | Phone # | Phone 2# | Dest. Address | Dest. City | Dest. State | Dest. [NAME] | Dest. Country | Hand. Qty | Hand. Unit | [NAME]. Qty | Pkg. Unit | Product Type | L | W | H | Product ID | Weight | Weight Unit | Packages | Value | Special Inst. | Duration | Status | PL# Return | ETD | ETA | ATD | ATA | RTN PU Name | RTN PU Phone# | RTN PU Phone2# | RTN PU Address | RTN PU City | RTN PU State | RTN [NAME] | RTN PU Country | Return Co | Return Address | Return City | Return State | [NAME] | Return Country | Tracking No | R.Hand. Qty | R.Hand. Unit | R.Pkg. Qty | R.Pkg. Unit | R.Product Type | L | W | H | R.Product ID | Weight | Weight Unit | R.Packages | R.Value | R.Special Inst. | R.Duration | R.Status | Customer PO | Return S/N | RA
DL34761098 | 8047144587 | EGL |  | 2010-04-20 00:00:00 |  |  |  | Far East | 350 [NAME] PKWY | Carlstadt | NJ | 7072 | US | KATHY/PFANNENSTIEL | 785) 213 1540 |  | 1515 NW GAGE | Topeka | KS | 66618 | US | 1 | SKID | 1 | CARTON | 40" | 42 | 12 | 27 | LS40BHPNB/XAA | 50 | lb | PL34753715 | 1099 | 2ND DAY SERVICE DO NOT DEL W/O PICKING UP RTN UNIT AT TIME OF SWAP (KWEX18907 B2B) *APPT. REQUIRED* |  | [NAME] | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4006472190 | BH40HCNPA01560B | 702946700
N/A |  | EGL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DL34761312 | 2010-04-22 00:00:00 |  |  |  | KATHY/PFANNENSTIEL | 785) 213 1540 |  | 1515 NW GAGE | Topeka | KS | 66618 | US | KW LF | [NAME] | Little Ferry | NJ | 7643 | US |  | 1 | SKID | 1 | CARTON | 40" | 42 | 12 | 27 | LS40BHPNB/XAA | 50 | lb | PL34753723 | 714.35 | ECONOMIC GROUND SERVICE //  PLEASE CONFIRM MODEL NUMBER ON DEFECTIVE UNIT MATCHES THE MODEL NUMBER ON THE ORDER. |  | [NAME] | 4006472190 | BH40HCNPA01560B | 702946700
DL34761965 | 8047144467 | EGL |  | 2010-04-20 00:00:00 |  |  |  | Far East | 350 [NAME] PKWY | Carlstadt | NJ | 7072 | US | FREDERICK/BABSON | 202) 328 6000 |  | 1215 U ST NW | Washington | DC | 20009 | US | 1 | SKID | 1 | CARTON | 70" | 65 | 19 | 43 | LS70BPTNB/XAA | 254 | lb | PL34753756 | 14999 | 2ND DAY SERVICE DO NOT DEL W/O PICKING UP RTN UNIT AT TIME OF SWAP (KWEX18907 B2B) *APPT. REQUIRED* |  | [NAME] | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4006522285 | BP70H1ES600014R | 702947374
N/A |  | EGL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DL34761973 | 2010-04-22 00:00:00 |  |  |  | FREDERICK/BABSON | 202) 328 6000 |  | 1215 U ST NW | Washington | DC | 20009 | US | KW LF | [NAME] | Little Ferry | NJ | 7643 | US |  | 1 | SKID | 1 | CARTON | 70" | 65 | 19 | 43 | LS70BPTNB/XAA | 254 | lb | PL34753764 | 9749.35 | ECONOMIC GROUND SERVICE //  PLEASE CONFIRM MODEL NUMBER ON DEFECTIVE UNIT MATCHES THE MODEL NUMBER ON THE ORDER. |  | [NAME] | 4006522285 | BP70H1ES600014R | 702947374
DL34762062 | 8047144638 | EGL |  | 2010-04-20 00:00:00 |  |  |  | Far East | 350 [NAME] PKWY | Carlstadt | NJ | 7072 | US | MARK/PASCUAL | 512) 583 8659 |  | 1703 W. 5TH ST SUITE 600 | [NAME] | TX | 78703 | US | 1 | SKID | 1 | CARTON | 40" | 42 | 12 | 27 | LH40MSPLBB/ZA | 50 | lb | PL34753830 | 1349 | 2ND DAY SERVICE DO NOT DEL W/O PICKING UP RTN UNIT AT TIME OF SWAP (KWEX18907 B2B) *APPT. REQUIRED* |  | [NAME] | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4006515607 | MS40HCNS400193N | 702946686
DL34762104 | 8047144647 | EGL |  | 2010-04-20 00:00:00 |  |  |  | Far East | 350 [NAME] PKWY | Carlstadt | NJ | 7072 | US | ADAM/CREMEANS | 304) 526 2618 | (304) 526 2626 | 1340 HAL GREER BLVD | Huntington | WV | 25701 | US | 1 | SKID | 1 | CARTON | " | 53 | 12 | 33 | LS57BPHNB/XAA | 107 | lb | PL34753897 | 6499 | 2ND DAY SERVICE DO NOT DEL W/O PICKING UP RTN UNIT AT TIME OF SWAP (KWEX18907 B2B) *APPT. REQUIRED* |  | [NAME] | N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4006521272 | BP57H1ESB00095R | 702946704
N/A |  | EGL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2010-04-22 00:00:00 |  |  |  | ADAM/CREMEANS | 304) 526 2618 | (304) 526 2626 | 1340 HAL GREER BLVD | Huntington | WV | 25701 | US | KW LF | [NAME] | Little Ferry | NJ | 7643 | US |  | 1 | SKID | 1 | CARTON | " | 53 | 12 | 33 | LS57BPHNB/XAA | 107 | lb | PL34753905 | 4224.35 | ECONOMIC GROUND SERVICE //  PLEASE CONFIRM MODEL NUMBER ON DEFECTIVE UNIT MATCHES THE MODEL NUMBER ON THE ORDER. |  | [NAME] | 4006521272 | BP57H1ESB00095R | 702946704
Goes in column H of the STAT | Column J on the STAT |  |  | Column A on the STAT |  |  |  | Column D on the STAT |  |  |  | Column E on the STAT |  | Take out the / first then it goes in column N | Column O | Column P | Column Q | Column R | Column S | Column T |  |  |  |  |  | Column X | Y | Z | AA | Column AB | AC |  | Column AD | Column AE | Column AP |  |  | Goes in column H of the STAT | Column A on the STAT |  |  |  | Column D on the STAT |  |  |  |  |  | Column E on the STAT |  | Column N | Column Q | Column R | Column S | Column T |  |  |  |  |  |  | Column X | Column Y | Column Z | Column AA | Column AB | Column AC |  | Column AD | Column AE |  |  |  | Column AF | Column AG | Column AH