Spreadsheet: 238626d1369654918-program-to-generate-sales-production-and-stock-data-in-one-sheet-stock
Sheet: Production

M/C # | Date | Item Code | Start | End | Total Daily Production
1 | 2013-04-01 00:00:00 | 4.0R/176 | 13148 | 45806
1 | 2013-04-02 00:00:00
1 | 2013-04-03 00:00:00 | 4.0R/176 | 45806 | 80000
1 | 2013-04-04 00:00:00 | 4.0R/176 | 80000 | 106700
1 | 2013-04-05 00:00:00 | 4.0R/176 | 106700 | 130000
1 | 2013-04-06 00:00:00 | 4.0R/176
1 | 2013-04-07 00:00:00 | 2.5F/21 | 16000 | 50000
1 | 2013-04-08 00:00:00 | 2.5F/21 | 50000 | 88000
1 | 2013-04-09 00:00:00
1 | 2013-04-10 00:00:00 | 2.5F/21 | 88000 | 113500
1 | 2013-04-11 00:00:00
1 | 2013-04-12 00:00:00 | 2.5F/21 | 113500 | 153230
1 | 2013-04-13 00:00:00 | 2.5F/21 | 153230 | 180500
1 | 2013-04-14 00:00:00 | 2.5F/21 | 180500 | 217240
1 | 2013-04-15 00:00:00 | 2.5F/21 | 217240 | 261000
1 | 2013-04-16 00:00:00
1 | 2013-04-17 00:00:00 | 2.5F/21 | 261000 | 287084
1 | 2013-04-18 00:00:00
1 | 2013-04-19 00:00:00 | 3.0F/61 | 0 | 13500
1 | 2013-04-20 00:00:00 | 3.0F/61 | 13500 | 40000
1 | 2013-04-21 00:00:00 | 4.0R/176 | 0 | 12900
1 | 2013-04-22 00:00:00 | 4.0R/176 | 12900 | 39760
1 | 2013-04-23 00:00:00
1 | 2013-04-24 00:00:00 | 4.0R/176 | 39760 | 75100
1 | 2013-04-25 00:00:00 | 4.0R/176 | 75100 | 102220
1 | 2013-04-26 00:00:00 | 4.0R/176 | 102220 | 136390
1 | 2013-04-27 00:00:00 | 4.0R/176 | 136390 | 172000
1 | 2013-04-28 00:00:00 | 4.0R/176 | 172000 | 191150
1 | 2013-04-29 00:00:00 | 4.0R/176 | 191150 | 219741
1 | 2013-04-30 00:00:00
2 | 2013-04-01 00:00:00 | 4.0R/176 | 45898 | 76002
2 | 2013-04-02 00:00:00
2 | 2013-04-03 00:00:00 | 4.0R/176 | 76002 | 110000
2 | 2013-04-04 00:00:00 | 4.0R/176 | 110000 | 145450
2 | 2013-04-05 00:00:00 | 4.0R/176 | 145450 | 173126
2 | 2013-04-06 00:00:00 | 4.0R/176 | 173126 | 198000
2 | 2013-04-07 00:00:00 | 4.0R/176 | 198000 | 224000
2 | 2013-04-08 00:00:00 | 4.0R/176 | 224000 | 259000
2 | 2013-04-09 00:00:00
2 | 41374 | 4.0R/176 | 259000 | 290000
2 | 2013-04-11 00:00:00
2 | 2013-04-12 00:00:00 | 4.0R/176 | 290000 | 313515
2 | 2013-04-13 00:00:00 | 4.0R/176 | 313515 | 346108
2 | 2013-04-14 00:00:00 | 4.0R/176 | 346108 | 378200
2 | 2013-04-15 00:00:00 | 4.0R/176 | 378200 | 420000
2 | 2013-04-16 00:00:00
2 | 2013-04-17 00:00:00 | 4.0R/176 | 420000 | 450725
2 | 2013-04-18 00:00:00 | 4.0R/176 | 450725 | 484119
2 | 2013-04-19 00:00:00 | 4.0R/176 | 484119 | 518540
2 | 2013-04-20 00:00:00 | 4.0R/176 | 518540 | 550315
2 | 2013-04-21 00:00:00 | 4.0R/176 | 550315 | 585560
2 | 2013-04-22 00:00:00 | 4.0R/176 | 585560 | 620570
2 | 2013-04-23 00:00:00
2 | 2013-04-24 00:00:00 | 4.0R/176 | 620570 | 655580
2 | 2013-04-25 00:00:00 | 4.0R/176 | 655580 | 692515
2 | 2013-04-26 00:00:00 | 4.0R/176 | 692515 | 728257
2 | 2013-04-27 00:00:00 | 4.0R/176 | 728257 | 755500
2 | 2013-04-28 00:00:00 | 4.0R/176 | 755500 | 766647
2 | 2013-04-29 00:00:00 | 4.0R/176 | 766647 | 766647
2 | 2013-04-30 00:00:00
3 | 2013-04-01 00:00:00 | 4.5R/208 | 0 | 2818
3 | 2013-04-02 00:00:00
3 | 2013-04-03 00:00:00 | 4.5R/208 | 2818 | 10000
3 | 2013-04-04 00:00:00 | 4.5R/208 | 10000 | 16606
3 | 2013-04-05 00:00:00 | 4.5R/208 | 16606 | 27000
3 | 2013-04-06 00:00:00 | 4.5F/182 | 0 | 18000
3 | 2013-04-07 00:00:00 | 4.0F/144 | 0 | 28000
3 | 2013-04-08 00:00:00
3 | 2013-04-09 00:00:00
3 | 2013-04-10 00:00:00 | 4.0R/180 | 0 | 14250
3 | 2013-04-11 00:00:00
3 | 2013-04-12 00:00:00 | 4.0R/180 | 14250 | 42458
3 | 2013-04-13 00:00:00
3 | 2013-04-14 00:00:00 | SOLID | 0 | 5900
3 | 2013-04-15 00:00:00 | 5.0F/236 | 0 | 3000
3 | 2013-04-16 00:00:00
3 | 2013-04-17 00:00:00 | 5.5R/278 | 0 | 8200
3 | 2013-04-18 00:00:00 | 5.5R/278 | 8200 | 22502
3 | 2013-04-19 00:00:00 | 4.5R/209 | 0 | 5330
3 | 2013-04-20 00:00:00 | 4.5R/209 | 5330 | 34390
3 | 2013-04-21 00:00:00 | 4.5R/209 | 34390 | 52591
3 | 2013-04-22 00:00:00
3 | 2013-04-23 00:00:00
3 | 2013-04-24 00:00:00 | 4.0F/154 | 0 | 6082
3 | 2013-04-25 00:00:00 | 4.0R/176 | 0 | 16600
3 | 2013-04-26 00:00:00 | 4.0R/176 | 16600 | 42150
3 | 2013-04-27 00:00:00 | 4.0R/176 | 42150 | 71000
3 | 2013-04-28 00:00:00 | 4.0R/176 | 71000 | 99420
3 | 2013-04-29 00:00:00 | 4.0R/176 | 99420 | 127950
3 | 2013-04-30 00:00:00 | 4.0R/176 | 127950 | 127950