Spreadsheet: 93190d1292792435-dynamic-report-linked-to-pivot-table-prod-scheduling-modified-
Sheet: PIVOT-2

Sum of OUT PUT | M/C TYPE | ORD NO
 | TYPE-A(10) |  | TYPE-B(8) |  |  |  | TYPE-C(12) |  | Grand Total
DATE | ORD-1 | ORD-2 | ORD-3 | ORD-7 | ORD-8 | ORD-9 | ORD-4 | ORD-5 |  |  | NOTE
2010-12-19 00:00:00 | 60 |  |  |  |  |  |  | 72 | 132 |  | 1 | IN THIS TABLE TOTAL OUT PUT PER ORDER ON PARTICULAR DAY IS SHOWN
2010-12-20 00:00:00 | 60 |  |  |  |  |  |  | 72 | 132 |  | 2 | IN THIS TABLE TOTAL ORD QTY IS THE COLUMN GRAND TOTAL
2010-12-21 00:00:00 | 60 |  | 108 |  |  |  |  | 72 | 240 |  |  | FOR EX. ORD-1 TOTAL QTY IS 780 AS SHOWN IN THE GRAND TOTAL OF COLUMN
2010-12-22 00:00:00 | 60 |  | 108 |  |  |  |  | 72 | 240 |  | 3 | ORD-2 PRODUCTION START DATE IS 25TH DEC AND END DATE IS 2ND JAN.
2010-12-23 00:00:00 | 60 |  | 108 |  |  |  | 132 | 72 | 372 |  | 4 | BASED ON THIS PIVOT SHEET, SUMMARY SHEET IS PREPARED.
2010-12-24 00:00:00 | 60 |  | 108 |  |  |  | 132 | 72 | 372 |  | 5 | WHEN THE NUMBER OF ORDER INCREASED OR ENTERED NEWLY IN THE MASTER SHEET,
2010-12-25 00:00:00 | 60 | 32 | 108 |  |  |  | 132 | 72 | 404 |  |  | ON REFRESHING THE PIVOT REPORT EXPAND ACCORDING TO THE DATA
2010-12-26 00:00:00 | 60 | 32 | 108 |  |  |  | 132 | 72 | 404 |  |  | EX. IN THE MASTER SHEET, TILL DATE WE HV ENTERED ORD-9 AND WHEN ORD-10 AND
2010-12-27 00:00:00 | 60 | 32 | 108 |  |  |  | 132 | 72 | 404 |  |  | ORD-11 ARE ENTERED IT WILL GET POPULATED UNDER RESPECTIVE TYPE OF MACHINE
2010-12-28 00:00:00 | 60 | 32 | 108 |  |  |  | 132 | 72 | 404 |  |  | AND THE PIVOT TABLE EXPAND.
2010-12-29 00:00:00 | 60 | 32 | 108 |  |  |  | 132 | 72 | 404
2010-12-30 00:00:00 | 60 | 32 | 108 |  |  |  | 132 | 72 | 404
2010-12-31 00:00:00 | 60 | 32 | 108 |  |  |  | 132 | 72 | 404
2011-01-01 00:00:00 |  | 32 | 108 |  |  |  | 132 | 72 | 344
2011-01-02 00:00:00 |  | 32 | 90 | 18 |  |  | 132 | 72 | 344
2011-01-03 00:00:00 |  |  |  | 108 |  |  | 132 | 72 | 312
2011-01-04 00:00:00 |  |  |  | 108 |  |  | 132 | 72 | 312
2011-01-05 00:00:00 |  |  |  | 108 |  |  | 132 | 72 | 312
2011-01-06 00:00:00 |  |  |  | 108 |  |  | 132 | 72 | 312
2011-01-07 00:00:00 |  |  |  | 108 |  |  | 132 | 72 | 312
2011-01-08 00:00:00 |  |  |  | 108 |  |  | 132 | 72 | 312
2011-01-09 00:00:00 |  |  |  | 54 | 54 |  | 132 | 72 | 312
2011-01-10 00:00:00 |  |  |  |  | 108 |  | 132 | 72 | 312
2011-01-11 00:00:00 |  |  |  |  | 108 |  | 132 | 72 | 312
2011-01-12 00:00:00 |  |  |  |  | 108 |  | 132 | 72 | 312
2011-01-13 00:00:00 |  |  |  |  | 108 |  | 132 | 72 | 312
2011-01-14 00:00:00 |  |  |  |  | 108 |  | 132 | 72 | 312
2011-01-15 00:00:00 |  |  |  |  | 36 | 72 | 132 | 72 | 312
2011-01-16 00:00:00 |  |  |  |  |  | 108 | 132 | 72 | 312
2011-01-17 00:00:00 |  |  |  |  |  | 108 | 132 | 72 | 312
2011-01-18 00:00:00 |  |  |  |  |  | 108 | 132 | 72 | 312
2011-01-19 00:00:00 |  |  |  |  |  | 108 | 132 | 72 | 312
2011-01-20 00:00:00 |  |  |  |  |  | 108 | 132 | 72 | 312
2011-01-21 00:00:00 |  |  |  |  |  | 108 | 132 |  | 240
2011-01-22 00:00:00 |  |  |  |  |  | 108 | 132 |  | 240
2011-01-23 00:00:00 |  |  |  |  |  | 108 | 132 |  | 240
2011-01-24 00:00:00 |  |  |  |  |  | 108 | 132 |  | 240
2011-01-25 00:00:00 |  |  |  |  |  | 108 | 132 |  | 240
2011-01-26 00:00:00 |  |  |  |  |  | 108 | 132 |  | 240
2011-01-27 00:00:00 |  |  |  |  |  | 108 | 132 |  | 240
2011-01-28 00:00:00 |  |  |  |  |  | 108 | 132 |  | 240
2011-01-29 00:00:00 |  |  |  |  |  | 108 | 132 |  | 240
2011-01-30 00:00:00 |  |  |  |  |  | 108 | 132 |  | 240
2011-01-31 00:00:00 |  |  |  |  |  |  | 132 |  | 132
2011-02-01 00:00:00 |  |  |  |  |  |  | 132 |  | 132
2011-02-02 00:00:00 |  |  |  |  |  |  | 132 |  | 132
2011-02-03 00:00:00 |  |  |  |  |  |  | 132 |  | 132
2011-02-04 00:00:00 |  |  |  |  |  |  | 132 |  | 132
2011-02-05 00:00:00 |  |  |  |  |  |  | 132 |  | 132
2011-02-06 00:00:00 |  |  |  |  |  |  | 132 |  | 132
2011-02-07 00:00:00 |  |  |  |  |  |  | 132 |  | 132
2011-02-08 00:00:00 |  |  |  |  |  |  | 132 |  | 132
2011-02-09 00:00:00 |  |  |  |  |  |  | 132 |  | 132
Grand Total | 780 | 288 | 1386 | 720 | 630 | 1692 | 6468 | 2376 | 14340