Spreadsheet: 95948d1295457252-find-value-and-add-qty-test-forecast
Sheet: Sheet1

Part_Number | July 2010  Qty | Aug 2010  Qty | Sept 2010  Qty | Oct 2010  Qty | Nov 2010  Qty | Dec 2010  Qty
Part A | 0 | 0 | 0 | 0 | 500 | 200000 |  |  | Oct would be 90 days
Part A | 0 | 0 | 0 | 0 | 500 | 50000 |  |  | July would be 180 Days
Part A | 0 | 0 | 200 | 60000 | 0 | 0
Part A | 0 | 0 | 0 | 0 | 1000 | 200000
Part A | 1000 | 250000 | 700 | 195000 | 1000 | 235000
Part A | 0 | 0 | 6000 | 1008000 | 5700 | 957600
Part A | 600 | 225882 | 800 | 301176 | 180 | 67764.6
Part A | 0 | 0 | 0 | 0 | 4000 | 880000
Part A | 500 | 95000 | 1500 | 260000 | 1000 | 220000
Part A | 400 | 82944 | 500 | 103680 | 970 | 240799.2
Part A | 0 | 0 | 2000 | 400000 | 0 | 0
Part A | 2000 | 400000 | 0 | 0 | 2000 | 400000
Part A | 500 | 75000 | 0 | 0 | 500 | 75000
Part A | 4975 | 1421307.75 | 2400 | 685656 | 2120 | 605662.8
Part A | 0 | 0 | 0 | 0 | 500 | 60000
Part A | 0 | 0 | 0 | 0 | 500 | 63000
Part B | 0 | 0 | 0 | 0 | 500 | 50000
Part B | 0 | 0 | 2000 | 170000 | 0 | 0
Part B | 2000 | 170000 | 0 | 0 | 2000 | 170000
Part B | 600 | 277086 | 955 | 441028.55 | 800 | 369448
Part B | 700 | 216000 | 500 | 150000 | 1500 | 470000
Part B | 500 | 100000 | 0 | 0 | 500 | 100000
Part B | 500 | 120000 | 0 | 0 | 250 | 60000
Part B | 400 | 184724 | 1085 | 501063.85 | 400 | 184724
Part B | 0 | 0 | 100 | 39000 | 0 | 0
Part B | 0 | 0 | 0 | 0 | 0 | 0
Part B | 1270 | 562889.4 | 80 | 35457.6 | 180 | 79779.6
Part C | 0 | 0 | 0 | 0 | 0 | 0
Part C | 0 | 0 | 4000 | 764000 | 0 | 0
Part C | 1000 | 102000 | 1500 | 153000 | 1000 | 102000
Part C | 0 | 0 | 0 | 0 | 1000 | 130000
Part C | 0 | 0 | 0 | 0 | 0 | 0
Part C | 0 | 0 | 0 | 0 | 0 | 0
Part C | 8900 | 836600 | 0 | 0 | 4300 | 404200
Part C | 3000 | 246000 | 3000 | 246000 | 3000 | 246000
Part C | 10 | 1150 | 20 | 2190 | 10 | 1140
Part C | 5 | 14556 | 0 | 0 | 0 | 0
Part C | 0 | 0 | 20 | 36110 | 10 | 19790
Part C | 40 | 55200 | 0 | 0 | 0 | 0
Part C | 40 | 26144 | 0 | 0 | 0 | 0
Part D | 60 | 34080 | 0 | 0 | 0 | 0
Part D | 80 | 36352 | 0 | 0 | 0 | 0
Part D | 10 | 20930 | 20 | 36175 | 10 | 20040
Part D | 10 | 39060 | 20 | 64550 | 10 | 35520
Part D | 10 | 5600 | 20 | 5200 | 10 | 2600
Part D | 10 | 114710 | 20 | 200380 | 10 | 109820
Part D | 30 | 48300 | 0 | 0 | 0 | 0
Part D | 40 | 32384 | 0 | 0 | 0 | 0
Part D | 0 | 0 | 4000 | 0 | 0 | 0
Part D | 424 | 64558.24 | 333 | 50702.58 | 520 | 79175.2
Part D | 414 | 64364.58 | 496 | 77113.12 | 785 | 122043.95
Part D | 0 | 0 | 6000 | 0 | 5700 | 0
Part D | 9010 | 0 | 0 | 0 | 4300 | 0
Part E | 0 | 0 | 0 | 0 | 0 | 0
Part E | 30 | 900 | 0 | 0 | 0 | 0
Part E | 40 | 768 | 0 | 0 | 0 | 0
Part E | 0 | 0 | 10 | 200 | 10 | 200
Part E | 0 | 0 | 0 | 0 | 4000 | 0
Part E | 2200 | 0 | 700 | 0 | 2500 | 0
Part E | 0 | 0 | 0 | 0 | 1000 | 0
Part E | 1000 | 0 | 1500 | 0 | 1500 | 0
Part E | 0 | 0 | 0 | 0 | 1000 | 0
Part F | 0 | 0 | 2000 | 0 | 1000 | 0
Part F | 500 | 0 | 0 | 0 | 500 | 0
Part F | 500 | 0 | 0 | 0 | 500 | 0
Part F | 3000 | 0 | 3000 | 0 | 3000 | 0
Part F | 0 | 0 | 0 | 0 | 500 | 0
Part F | 1 | 1406299.5 | 1 | 1430480.31 | 1 | 1472076.98
Part F | 2 | 100000 | 2 | 100000 | 2 | 100000
Part F | 1 | 45000 | 1 | 45000 | 2 | 90000
Part F | 0 | 0 | 0 | 0 | 50 | 19750
Part F | 0 | 0 | 0 | 0 | 50 | 19750
Part F | 0 | 0 | 0 | 0 | 50 | 5000
Part F | 0 | 0 | 0 | 0 | 50 | 4750
Part F | 25 | 10356.5252095251 | 25 | 10536.1181322336 | 40 | 16821.870427032
Part F | 0 | 0 | 0 | 0 | 290 | 111910
Part F | 385 | 120432.619396036 | 835 | 247930.29133963 | 715 | 213566.781960888
Part F | 193 | 58234.0029266994 | 350 | 101476.386856459 | 260 | 189887.588133564
Part F | 0 | 0 | 0 | 0 | 50 | 11950
Part F | 0 | 0 | 0 | 0 | 460 | 134340