Spreadsheet: 86022d1285976021-outstanding-balance-on-each-ref-no-pivot-table-oustanding-bal_ssg
Sheet: Main

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