Spreadsheet: 101692d1299769827-help-with-using-a-series-of-values-to-fill-a-stocksheet-stockrunningtotals
Sheet: Stock Movement

Period / WK | Date | Product No. | Item Description | Issued Stock | Deliveries & Returns | Running Stock | Qty To Order
Period 10 | 2010-12-31 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 16 |  | 211 | 300 |  | Item Description | (All)
Period 10 | 2011-01-02 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300
Period 10 | 2011-01-02 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  |  | Period / WK | Data
Period 10 | 2011-01-05 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 2 |  | 211 | 300 |  |  | Period 10 |  | Period 11 |  | Total Count of Issued Stock | Total Count of Issued Stock2
Period 10 | 2011-01-06 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  | Date | Count of Issued Stock | Count of Issued Stock2 | Count of Issued Stock | Count of Issued Stock2
Period 10 | 2011-01-07 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  | 2010-12-31 00:00:00 | 1 | 1 |  | 0 | 1 | 1
Period 10 | 2011-01-12 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 4 |  | 211 | 300 |  | 2011-01-02 00:00:00 | 6 | 7 |  | 0 | 6 | 7
Period 10 | 2011-01-18 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 4 |  | 211 | 300 |  | 2011-01-05 00:00:00 | 4 | 11 |  | 0 | 4 | 11
Period 10 | 2011-01-18 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  | 2011-01-06 00:00:00 | 1 | 12 |  | 0 | 1 | 12
Period 10 | 2011-01-20 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 12 |  | 211 | 300 |  | 2011-01-07 00:00:00 | 1 | 13 |  | 0 | 1 | 13
Period 10 | 2011-01-21 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  | 2011-01-12 00:00:00 | 2 | 15 |  | 0 | 2 | 15
Period 10 | 2011-01-22 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  | 2011-01-14 00:00:00 | 1 | 16 |  | 0 | 1 | 16
Period 10 | 2011-01-22 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  | 2011-01-15 00:00:00 | 1 | 17 |  | 0 | 1 | 17
Period 10 | 2011-01-25 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  | 2011-01-17 00:00:00 | 2 | 19 |  | 0 | 2 | 19
Period 11 | 2011-01-29 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 30 |  | 211 | 300 |  | 2011-01-18 00:00:00 | 4 | 23 |  | 0 | 4 | 23
Period 11 | 2011-01-31 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  | 2011-01-20 00:00:00 | 1 | 24 |  | 0 | 1 | 24
Period 11 | 2011-02-03 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 18 |  | 211 | 300 |  | 2011-01-21 00:00:00 | 1 | 25 |  | 0 | 1 | 25
Period 11 | 2011-02-04 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 1 |  | 211 | 300 |  | 2011-01-22 00:00:00 | 5 | 30 |  | 0 | 5 | 30
Period 11 | 2011-02-04 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 24 |  | 211 | 300 |  | 2011-01-25 00:00:00 | 1 | 31 |  | 0 | 1 | 31
Period 11 | 2011-02-06 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 24 |  | 211 | 300 |  | 2011-01-26 00:00:00 | 1 | 32 |  | 0 | 1 | 32
Period 11 | 2011-02-07 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 12 |  | 211 | 300 |  | 2011-01-28 00:00:00 |  | 32 | 1 | 1 | 1 | 33
Period 11 | 2011-02-08 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 18 |  | 211 | 300 |  | 2011-01-29 00:00:00 |  | 32 | 2 | 3 | 2 | 35
Period 11 | 2011-02-13 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  | 2011-01-31 00:00:00 |  | 32 | 2 | 5 | 2 | 37
Period 11 | 2011-02-14 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 12 |  | 211 | 300 |  | 2011-02-03 00:00:00 |  | 32 | 1 | 6 | 1 | 38
Period 11 | 2011-02-14 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 36 |  | 211 | 300 |  | 2011-02-04 00:00:00 |  | 32 | 3 | 9 | 3 | 41
Period 11 | 2011-02-16 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 6 |  | 211 | 300 |  | 2011-02-05 00:00:00 |  | 32 | 1 | 10 | 1 | 42
Period 11 | 2011-02-18 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 21 |  | 211 | 300 |  | 2011-02-06 00:00:00 |  | 32 | 2 | 12 | 2 | 44
Period 11 | 2011-02-18 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone |  | 300 | 211 | 300 |  | 2011-02-07 00:00:00 |  | 32 | 1 | 13 | 1 | 45
Period 11 | 2011-02-24 00:00:00 | 001 | 16 watt GLS ES Energy Saver Softone | 48 |  | 211 | 300 |  | 2011-02-08 00:00:00 |  | 32 | 1 | 14 | 1 | 46
Period 10 | 2011-01-02 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 12 |  | 144 | 300 |  | 2011-02-13 00:00:00 |  | 32 | 3 | 17 | 3 | 49
Period 10 | 2011-01-12 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 3 |  | 144 | 300 |  | 2011-02-14 00:00:00 |  | 32 | 3 | 20 | 3 | 52
Period 10 | 2011-01-17 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 2 |  | 144 | 300 |  | 2011-02-15 00:00:00 |  | 32 | 1 | 21 | 1 | 53
Period 10 | 2011-01-18 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 24 |  | 144 | 300 |  | 2011-02-16 00:00:00 |  | 32 | 1 | 22 | 1 | 54
Period 10 | 2011-01-22 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 6 |  | 144 | 300 |  | 2011-02-18 00:00:00 |  | 32 | 1 | 23 | 1 | 55
Period 10 | 2011-01-22 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 6 |  | 144 | 300 |  | 2011-02-20 00:00:00 |  | 32 | 1 | 24 | 1 | 56
Period 11 | 2011-01-28 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 3 |  | 144 | 300 |  | 2011-02-24 00:00:00 |  | 32 | 3 | 27 | 3 | 59
Period 11 | 2011-01-31 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 6 |  | 144 | 300 |  | Grand Total | 32 |  | 27 |  | 59
Period 11 | 2011-02-04 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 12 |  | 144 | 300
Period 11 | 2011-02-05 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 6 |  | 144 | 300
Period 11 | 2011-02-06 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 12 |  | 144 | 300
Period 11 | 2011-02-13 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 6 |  | 144 | 300
Period 11 | 2011-02-14 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 12 |  | 144 | 300
Period 11 | 2011-02-24 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 14 |  | 144 | 300
Period 11 | 2011-02-24 00:00:00 | 002 | 16 watt GLS BC Energy Saver Softone | 12 |  | 144 | 300
Period 10 | 2011-01-05 00:00:00 | 003 | 7 Watt GU10 Energy Saver | 2 |  | 0 | 240
Period 10 | 2011-01-18 00:00:00 | 003 | 7 Watt GU10 Energy Saver | 2 |  | 0 | 240
Period 10 | 2011-01-02 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 10 |  | 207 | 400
Period 10 | 2011-01-02 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 3 |  | 207 | 400
Period 10 | 2011-01-05 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 10 |  | 207 | 400
Period 10 | 2011-01-05 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 8 |  | 207 | 400
Period 10 | 2011-01-12 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp |  | 250 | 207 | 400
Period 10 | 2011-01-14 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 10 |  | 207 | 400
Period 10 | 2011-01-15 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 10 |  | 207 | 400
Period 10 | 2011-01-17 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 2 |  | 207 | 400
Period 10 | 2011-01-26 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 60 |  | 207 | 400
Period 11 | 2011-01-29 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 30 |  | 207 | 400
Period 11 | 2011-02-13 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 20 |  | 207 | 400
Period 11 | 2011-02-15 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 20 |  | 207 | 400
Period 11 | 2011-02-20 00:00:00 | 004 | 40 Watt SES Clear Cooker hood Lamp | 10 |  | 207 | 400
Period 10 | 2011-01-02 00:00:00 | 005 | 25 Watt SES Clear Oven Lamp | 2 |  | 189 | 400
Period 10 | 2011-01-22 00:00:00 | 005 | 25 Watt SES Clear Oven Lamp | 10 |  | 189 | 400
Period 11 | 2011-02-08 00:00:00 | 005 | 25 Watt SES Clear Oven Lamp |  | 200 | 189 | 400