Spreadsheet: 85283d1285319167-outstanding-balance-on-each-ref-no-pivot-table-example1
Sheet: Sheet1

 |  |  | Today's Date: | 2010-09-24 00:00:00
 |  |  | Week No.: | 1900-01-01 00:00:00
 |  |  | Day of the week: | Friday
 |  |  | Quantities
Part | Customer | Sub-Con | Sent | Received | Lost | Ref No.: | Expected | Lead time | Date | Week | Day
WBT2241OP3 | Mitsui | Drill & Tap | 250 |  |  | 016453 | 2010-09-20 00:00:00 | 5 | 2010-09-13 00:00:00 | 37 | Monday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5 | 2010-09-14 00:00:00 |  | Tuesday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap | 650 |  |  | 014583 | 2010-09-22 00:00:00 | 5 | 2010-09-15 00:00:00 |  | Wednesday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5 | 2010-09-16 00:00:00 |  | Thursday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap | 540 |  |  | 016823 | 2010-09-24 00:00:00 | 5 | 2010-09-17 00:00:00 |  | Friday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5 | 2010-09-18 00:00:00 |  | Saturday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5 | 2010-09-19 00:00:00 |  | Sunday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap | 350 |  |  | 015734 | 2010-09-27 00:00:00 | 5 | 2010-09-20 00:00:00 | 38 | Monday
WBT2241OP3 | Mitsui | Drill & Tap |  | 200 |  | 016453 |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5 | 2010-09-21 00:00:00 |  | Tuesday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  | 50 |  | 016453 |  | 5 | 2010-09-22 00:00:00 |  | Wednesday
WBT2241OP3 | Mitsui | Drill & Tap |  | 600 |  | 014583 |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5 | 2010-09-23 00:00:00 |  | Thursday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5 | 2010-09-24 00:00:00 |  | Friday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5 | 2010-09-25 00:00:00 |  | Saturday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5 | 2010-09-26 00:00:00 |  | Sunday
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5
WBT2241OP3 | Mitsui | Drill & Tap |  |  |  |  |  | 5