Spreadsheet: 93150d1292688247-simplify-formula-steph-
Sheet: Sheet2

Sold To | Name | Ship To | Name | Qty | Request Date | Next Status | A | B | Backlog | Work Centre
37801011 | Parker Hannifin Oy | 37801011 | Parker Hannifin Oy | 2 | 30/03/10 | 540 | 40267 | 261 | 1 | 3788VA02
37802832 | Parker Hannifin Ltd Sales UK | 37802832 | Parker Hannifin Ltd Sales UK | 1 | 19/07/10 | 560 | 40378 | 150 | 1 | 3788AS01
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 2 | 21/07/10 | 540 | 40380 | 148 | 1 | 3788VA15
37801018 | Parker Hannifin AB | 37801018 | Parker Hannifin AB | 8 | 09/08/10 | 540 | 40399 | 129 | 1 | 3788VA13
37801011 | Parker Hannifin Oy | 37801011 | Parker Hannifin Oy | 17 | 17/08/10 | 540 | 40407 | 121 | 1 | 3788VA13
37801011 | Parker Hannifin Oy | 37801011 | Parker Hannifin Oy | 5 | 31/08/10 | 540 | 40421 | 107 | 1 | 3788VA13
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 3 | 01/09/10 | 540 | 40422 | 106 | 1 | 3788VA03
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 15 | 01/09/10 | 540 | 40422 | 106 | 1 | 3788VA14
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 7 | 02/09/10 | 540 | 40423 | 105 | 1 | 3788VA11
37805662 | Parker Hannifin Japan Ltd | 37805662 | Parker Hannifin Japan Ltd | 1 | 06/09/10 | 540 | 40427 | 101 | 1 | 3788VA12
37801011 | Parker Hannifin Oy | 37801011 | Parker Hannifin Oy | 7 | 07/09/10 | 540 | 40428 | 100 | 1 | 3788VA13
37801011 | Parker Hannifin Oy | 37801011 | Parker Hannifin Oy | 16 | 07/09/10 | 540 | 40428 | 100 | 1 | 3788VA14
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 15 | 08/09/10 | 540 | 40429 | 99 | 1 | 3788VA11
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 11 | 09/09/10 | 540 | 40430 | 98 | 1 | 3788VA12
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 25 | 15/09/10 | 540 | 40436 | 92 | 1 | 3788VA12
37801018 | Parker Hannifin AB | 37801018 | Parker Hannifin AB | 2 | 16/09/10 | 540 | 40437 | 91 | 1 | 3788VA12
37801018 | Parker Hannifin AB | 37801018 | Parker Hannifin AB | 3 | 20/09/10 | 540 | 40441 | 87 | 1 | 3788VA14
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 8 | 22/09/10 | 540 | 40443 | 85 | 1 | 3788VA13
37806229 | Parker Hannifin Corporation In | 37806229 | Parker Hannifin Corporation In | 2 | 22/09/10 | 560 | 40443 | 85 | 1 | 3788VA14
37802821 | Parker Hannifin Australia Pty | 37802821 | Parker Hannifin Australia Pty | 6 | 26/09/10 | 560 | 40447 | 81 | 1 | 3788VA14
37802821 | Parker Hannifin Australia Pty | 37802821 | Parker Hannifin Australia Pty | 1 | 26/09/10 | 540 | 40447 | 81 | 1 | 3788VA14
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 1 | 27/09/10 | 540 | 40448 | 80 | 1 | 3788VA14
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 1 | 27/09/10 | 540 | 40448 | 80 | 1 | 3788VA03
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 70 | 29/09/10 | 540 | 40450 | 78 | 1 | 3788VA14
37802821 | Parker Hannifin Australia Pty | 37802821 | Parker Hannifin Australia Pty | 4 | 30/09/10 | 540 | 40451 | 77 | 1 | 3788VA13
37802821 | Parker Hannifin Australia Pty | 37802821 | Parker Hannifin Australia Pty | 9 | 30/09/10 | 560 | 40451 | 77 | 1 | 3788VA14
37802821 | Parker Hannifin Australia Pty | 37802821 | Parker Hannifin Australia Pty | 5 | 30/09/10 | 540 | 40451 | 77 | 1 | 3788VA14
37805611 | Parker Hannifin AB | 37805611 | Parker Hannifin AB | 12 | 01/10/10 | 540 | 40452 | 76 | 1 | #N/A
37806141 | Parker Hannifin AS | 37806141 | Parker Hannifin AS | 7 | 04/10/10 | 540 | 40455 | 73 | 1 | 3788VA01
37802811 | Parker Hannifin France S A S | 37802811 | Parker Hannifin France S A S | 1 | 04/10/10 | 560 | 40455 | 73 | 1 | 3788VA02
37802811 | Parker Hannifin France S A S | 37802811 | Parker Hannifin France S A S | 20 | 04/10/10 | 540 | 40455 | 73 | 1 | 3788VA02
37801011 | Parker Hannifin Oy | 37801011 | Parker Hannifin Oy | 46 | 05/10/10 | 540 | 40456 | 72 | 1 | 3788VA13
37801011 | Parker Hannifin Oy | 37801011 | Parker Hannifin Oy | 17 | 05/10/10 | 540 | 40456 | 72 | 1 | 3788VA14
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 1 | 05/10/10 | 540 | 40456 | 72 | 1 | 3788VA14
37801284 | Tianjin Foreign Trade Bohai | 37804683 | Tianjin Foreign Trade Bohai | 20 | 05/10/10 | 540 | 40456 | 72 | 1 | #N/A
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 1 | 05/10/10 | 540 | 40456 | 72 | 1 | 3788VA14
37801539 | Parker Hannifin Plc | 37801539 | Parker Hannifin Plc | 3 | 05/10/10 | 540 | 40456 | 72 | 1 | 3788VA11
37806141 | Parker Hannifin AS | 37806141 | Parker Hannifin AS | 10 | 05/10/10 | 540 | 40456 | 72 | 1 | 3788VA01
37802980 | Parker Hannifin India Priv Ltd | 37802980 | Parker Hannifin India Priv Ltd | 31 | 06/10/10 | 540 | 40457 | 71 | 1 | 3788VA11
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 2 | 06/10/10 | 540 | 40457 | 71 | 1 | 3788VA03
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 23 | 06/10/10 | 540 | 40457 | 71 | 1 | 3788VA03
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 4 | 06/10/10 | 540 | 40457 | 71 | 1 | 3788VA13
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 1 | 06/10/10 | 540 | 40457 | 71 | 1 | 3787BD01
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 1 | 06/10/10 | 540 | 40457 | 71 | 1 | 3788VA15
37801018 | Parker Hannifin AB | 37801018 | Parker Hannifin AB | 10 | 07/10/10 | 540 | 40458 | 70 | 1 | 3788VA12
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 2 | 08/10/10 | 540 | 40459 | 69 | 1 | 3788VA14
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 1 | 11/10/10 | 540 | 40462 | 66 | 1 | #N/A
37805465 | Parker Hannifin Europe Sarl | 37805465 | Parker Hannifin Europe Sarl | 10 | 11/10/10 | 540 | 40462 | 66 | 1 | 3788VA13
37800977 | Caterpillar S A R L | 37803705 | [NAME] (Euro-Ilc) | 13 | 11/10/10 | 560 | 40462 | 66 | 1 | 3788VA15
37800977 | Caterpillar S A R L | 37803705 | [NAME] (Euro-Ilc) | 26 | 11/10/10 | 540 | 40462 | 66 | 1 | 3788VA14
37802821 | Parker Hannifin Australia Pty | 37802821 | Parker Hannifin Australia Pty | 1 | 11/10/10 | 540 | 40462 | 66 | 1 | 3788VA14
37801051 | Amca Hydraulic Fluid Power Bv | 37804183 | Amca Hydraulic Fluid Power Bv | 7 | 12/10/10 | 540 | 40463 | 65 | 1 | 3788VA13
37801333 | [NAME] 550 796 | 37804744 | [NAME] | 2 | 12/10/10 | 540 | 40463 | 65 | 1 | 3788VA14
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 8 | 12/10/10 | 540 | 40463 | 65 | 1 | #N/A
37802980 | Parker Hannifin India Priv Ltd | 37802980 | Parker Hannifin India Priv Ltd | 34 | 13/10/10 | 540 | 40464 | 64 | 1 | 3788VA11
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 5 | 13/10/10 | 540 | 40464 | 64 | 1 | 3788VA13
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 21 | 13/10/10 | 540 | 40464 | 64 | 1 | 3788VA15
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 30 | 13/10/10 | 540 | 40464 | 64 | 1 | 3788VA14
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 1 | 13/10/10 | 540 | 40464 | 64 | 1 | 3788VA14
37801540 | Parker Hannifin Plc | 37801540 | Parker Hannifin Plc | 1 | 13/10/10 | 540 | 40464 | 64 | 1 | 3788VA12
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 23 | 14/10/10 | 540 | 40465 | 63 | 1 | 3788AD01
37802832 | Parker Hannifin Ltd Sales UK | 37802832 | Parker Hannifin Ltd Sales UK | 3 | 14/10/10 | 540 | 40465 | 63 | 1 | 3788VA11
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 1 | 14/10/10 | 540 | 40465 | 63 | 1 | 3788VA13
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 4 | 14/10/10 | 540 | 40465 | 63 | 1 | 3788VA01
37802811 | Parker Hannifin France S A S | 37802811 | Parker Hannifin France S A S | 10 | 14/10/10 | 540 | 40465 | 63 | 1 | 3788AV01
37802770 | Parker Hannifin S P A | 37802770 | Parker Hannifin S P A | 48 | 15/10/10 | 540 | 40466 | 62 | 1 | 3788VA03
37806229 | Parker Hannifin Corporation In | 37806267 | Limsco Co | 2 | 15/10/10 | 560 | 40466 | 62 | 1 | 3788VA01
37802796 | Parker Hannifin SA | 37802796 | Parker Hannifin SA | 1 | 18/10/10 | 540 | 40469 | 59 | 1 | 3788AD01
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 8 | 18/10/10 | 540 | 40469 | 59 | 1 | 3788VA13
37800977 | Caterpillar S A R L | 37803705 | [NAME] (Euro-Ilc) | 1 | 18/10/10 | 540 | 40469 | 59 | 1 | 3788VA15
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 2 | 18/10/10 | 540 | 40469 | 59 | 1 | 3788VA02
37802811 | Parker Hannifin France S A S | 37802811 | Parker Hannifin France S A S | 1 | 18/10/10 | 540 | 40469 | 59 | 1 | 3788VA02
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 1 | 18/10/10 | 540 | 40469 | 59 | 1 | 3788VA14
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 13 | 19/10/10 | 540 | 40470 | 58 | 1 | 3788VA13
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 1 | 19/10/10 | 540 | 40470 | 58 | 1 | #N/A
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 15 | 19/10/10 | 540 | 40470 | 58 | 1 | 3788VA01
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 23 | 20/10/10 | 540 | 40471 | 57 | 1 | 3787MC09
37801102 | Specma Component AB | 37804309 | Specma Component AB | 5 | 20/10/10 | 540 | 40471 | 57 | 1 | 3788VA03
37802770 | Parker Hannifin S P A | 37802770 | Parker Hannifin S P A | 8 | 20/10/10 | 540 | 40471 | 57 | 1 | 3788VA03
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 30 | 20/10/10 | 560 | 40471 | 57 | 1 | 3788VA03
37805492 | Parker Sales (Ireland) Ltd | 37805492 | Parker Sales (Ireland) Ltd | 25 | 20/10/10 | 540 | 40471 | 57 | 1 | 3788VA03
37802810 | Parker Hannifin Danmark A/S  I | 37802810 | Parker Hannifin Danmark A/S  I | 75 | 20/10/10 | 560 | 40471 | 57 | 1 | 3788VA13
37801102 | Specma Component AB | 37804309 | Specma Component AB | 2 | 20/10/10 | 540 | 40471 | 57 | 1 | 3787VS01
37801102 | Specma Component AB | 37804309 | Specma Component AB | 1 | 20/10/10 | 540 | 40471 | 57 | 1 | 3787VS01
37805492 | Parker Sales (Ireland) Ltd | 37805492 | Parker Sales (Ireland) Ltd | 2 | 21/10/10 | 540 | 40472 | 56 | 1 | 3788VA12
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 8 | 21/10/10 | 540 | 40472 | 56 | 1 | 3788VA15
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 4 | 22/10/10 | 540 | 40473 | 55 | 1 | 3788VA13
37801566 | Parker Hannifin Gmbh & Co Kg | 37801566 | Parker Hannifin Gmbh & Co Kg | 2 | 22/10/10 | 540 | 40473 | 55 | 1 | 3788VA14
37802892 | Parker Hannifin Corp | 37802892 | Parker Hannifin Corp | 18 | 22/10/10 | 540 | 40473 | 55 | 1 | 3788VA12
37800977 | Caterpillar S A R L | 37803705 | [NAME] (Euro-Ilc) | 36 | 25/10/10 | 540 | 40476 | 52 | 1 | 3788VA13
37805611 | Parker Hannifin AB | 37805611 | Parker Hannifin AB | 3 | 25/10/10 | 560 | 40476 | 52 | 1 | 3788VA02
37802832 | Parker Hannifin Ltd Sales UK | 37802832 | Parker Hannifin Ltd Sales UK | 2 | 26/10/10 | 540 | 40477 | 51 | 1 | 3788AD01