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

Count of OUT PUT | M/C TYPE | ORD NO
 | TYPE-A(10) |  | TYPE-B(8) |  |  |  | TYPE-C(12) |  | Grand Total |  |  | NOTE:
DATE | ORD-1 | ORD-2 | ORD-3 | ORD-7 | ORD-8 | ORD-9 | ORD-4 | ORD-5 |  |  |  | 1 | I HV GIVEN THE MACHINE TYPE AND WITH IN BRACKET TOTAL NUMBER OF MACHINES
2010-12-19 00:00:00 | 3 |  |  |  |  |  |  | 3 | 6 |  |  |  | FOR EX IN TYPE-A 10 MACHINES ARE AVAILABLE AND HENCE IT IS GIVEN TYPE-A(10)
2010-12-20 00:00:00 | 3 |  |  |  |  |  |  | 3 | 6 |  |  | 2 | FROM THIS PIVOT TABLE, I AM ABLE TO GET INFO ABOUT NUMBER OF MACHINES
2010-12-21 00:00:00 | 3 |  | 6 |  |  |  |  | 3 | 12 |  |  |  | RUNNING IN EACH TYPE OF MACHINE (LIKE TYPE-A OR TYPE-B OR TYPE-C) ON PARTICULAR DATE
2010-12-22 00:00:00 | 3 |  | 6 |  |  |  |  | 3 | 12 |  |  | 3 | ON SEEING THIS TABLE WE CAN EASILY IDENTIFY THAT OUT OF TYPE-A TOTAL 10 MACHINES
2010-12-23 00:00:00 | 3 |  | 6 |  |  |  | 6 | 3 | 18 |  |  |  | HOW MANY MACHINES ARE RUNNING AND BALANCE IS IDLE ON ANY DATE
2010-12-24 00:00:00 | 3 |  | 6 |  |  |  | 6 | 3 | 18 |  |  | 4 | THIS SHEET IS USED TO KEEP CONTROL ON NUMBER OF MACHINES TO BE RUN ON EACH ORDER ON
2010-12-25 00:00:00 | 3 | 2 | 6 |  |  |  | 6 | 3 | 20 |  |  |  | A PARTICULAR DATE.
2010-12-26 00:00:00 | 3 | 2 | 6 |  |  |  | 6 | 3 | 20 |  |  |  | FOR EX ON 21ST DEC, 3 MACHINES OF TYPE A SHOULD BE RUNNING FOR ORD-1, 6 MACHINES OF
2010-12-27 00:00:00 | 3 | 2 | 6 |  |  |  | 6 | 3 | 20 |  |  |  | TYPE-B MACHINES RUNNING FOR ORD-3
2010-12-28 00:00:00 | 3 | 2 | 6 |  |  |  | 6 | 3 | 20 |  |  | 5 | FROM THIS TABLE WE CAN UNDERSTAND THAT FROM 19TH DEC TO 24 DEC, IN TYPE-A MACHINES
2010-12-29 00:00:00 | 3 | 2 | 6 |  |  |  | 6 | 3 | 20 |  |  |  | OUT OF 10 MACHINES ONLY 3 ARE RUNNING.
2010-12-30 00:00:00 | 3 | 2 | 6 |  |  |  | 6 | 3 | 20
2010-12-31 00:00:00 | 3 | 2 | 6 |  |  |  | 6 | 3 | 20
2011-01-01 00:00:00 |  | 2 | 6 |  |  |  | 6 | 3 | 17
2011-01-02 00:00:00 |  | 2 | 5 | 1 |  |  | 6 | 3 | 17
2011-01-03 00:00:00 |  |  |  | 6 |  |  | 6 | 3 | 15
2011-01-04 00:00:00 |  |  |  | 6 |  |  | 6 | 3 | 15
2011-01-05 00:00:00 |  |  |  | 6 |  |  | 6 | 3 | 15
2011-01-06 00:00:00 |  |  |  | 6 |  |  | 6 | 3 | 15
2011-01-07 00:00:00 |  |  |  | 6 |  |  | 6 | 3 | 15
2011-01-08 00:00:00 |  |  |  | 6 |  |  | 6 | 3 | 15
2011-01-09 00:00:00 |  |  |  | 3 | 3 |  | 6 | 3 | 15
2011-01-10 00:00:00 |  |  |  |  | 6 |  | 6 | 3 | 15
2011-01-11 00:00:00 |  |  |  |  | 6 |  | 6 | 3 | 15
2011-01-12 00:00:00 |  |  |  |  | 6 |  | 6 | 3 | 15
2011-01-13 00:00:00 |  |  |  |  | 6 |  | 6 | 3 | 15
2011-01-14 00:00:00 |  |  |  |  | 6 |  | 6 | 3 | 15
2011-01-15 00:00:00 |  |  |  |  | 2 | 4 | 6 | 3 | 15
2011-01-16 00:00:00 |  |  |  |  |  | 6 | 6 | 3 | 15
2011-01-17 00:00:00 |  |  |  |  |  | 6 | 6 | 3 | 15
2011-01-18 00:00:00 |  |  |  |  |  | 6 | 6 | 3 | 15
2011-01-19 00:00:00 |  |  |  |  |  | 6 | 6 | 3 | 15
2011-01-20 00:00:00 |  |  |  |  |  | 6 | 6 | 3 | 15
2011-01-21 00:00:00 |  |  |  |  |  | 6 | 6 |  | 12
2011-01-22 00:00:00 |  |  |  |  |  | 6 | 6 |  | 12
2011-01-23 00:00:00 |  |  |  |  |  | 6 | 6 |  | 12
2011-01-24 00:00:00 |  |  |  |  |  | 6 | 6 |  | 12
2011-01-25 00:00:00 |  |  |  |  |  | 6 | 6 |  | 12
2011-01-26 00:00:00 |  |  |  |  |  | 6 | 6 |  | 12
2011-01-27 00:00:00 |  |  |  |  |  | 6 | 6 |  | 12
2011-01-28 00:00:00 |  |  |  |  |  | 6 | 6 |  | 12
2011-01-29 00:00:00 |  |  |  |  |  | 6 | 6 |  | 12
2011-01-30 00:00:00 |  |  |  |  |  | 6 | 6 |  | 12
2011-01-31 00:00:00 |  |  |  |  |  |  | 6 |  | 6
2011-02-01 00:00:00 |  |  |  |  |  |  | 6 |  | 6
2011-02-02 00:00:00 |  |  |  |  |  |  | 6 |  | 6
2011-02-03 00:00:00 |  |  |  |  |  |  | 6 |  | 6
2011-02-04 00:00:00 |  |  |  |  |  |  | 6 |  | 6
2011-02-05 00:00:00 |  |  |  |  |  |  | 6 |  | 6
2011-02-06 00:00:00 |  |  |  |  |  |  | 6 |  | 6
2011-02-07 00:00:00 |  |  |  |  |  |  | 6 |  | 6
2011-02-08 00:00:00 |  |  |  |  |  |  | 6 |  | 6
2011-02-09 00:00:00 |  |  |  |  |  |  | 6 |  | 6
Grand Total | 39 | 18 | 77 | 40 | 35 | 94 | 294 | 99 | 696