Spreadsheet: 117033d1312402020-creating-dynamic-graph-graph_automatically
Sheet: Summary_InQQR

Month_all | Month |  | Data Error % | CDM Error % | # of Queries Reviewed | Target |  | Plot Count
2011-01-01 00:00:00 | 2011-01-01 00:00:00 | Overall | 0.03 | 0.0085 | 1365 | 0.02 |  | 11
2011-01-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1354 | 0.02
2011-01-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02
2011-02-01 00:00:00 | 2011-02-01 00:00:00 | Overall | 0.0085 | 0.0085 | 1387 | 0.02
2011-02-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1387 | 0.02
2011-02-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02
2011-03-01 00:00:00 | 2011-03-01 00:00:00 | Overall | 0.0085 | 0.0085 | 1387 | 0.02
2011-03-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1387 | 0.02
2011-03-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02
2011-04-01 00:00:00 | 2011-04-01 00:00:00 | Overall | 0.0085 | 0.0085 | 1387 | 0.02
2011-04-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1387 | 0.02
2011-04-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02
2011-05-01 00:00:00 | 2011-05-01 00:00:00 | Overall | 0.0085 | 0.0085 | 1387 | 0.02
2011-05-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1387 | 0.02
2011-05-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02
2011-06-01 00:00:00 | 2011-06-01 00:00:00 | Overall | 0.0085 | 0.0085 | 1387 | 0.02
2011-06-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1387 | 0.02
2011-06-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02
2011-07-01 00:00:00 | 2011-07-01 00:00:00 | Overall | 0.03 | 0.0085 | 1365 | 0.02
2011-07-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1354 | 0.02
2011-07-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02
2011-08-01 00:00:00 | 2011-08-01 00:00:00 | Overall | 0.0085 | 0.0085 | 1387 | 0.02
2011-08-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1387 | 0.02
2011-08-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02
2011-09-01 00:00:00 | 2011-09-01 00:00:00 | Overall | 0.0085 | 0.0085 | 1387 | 0.02
2011-09-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1387 | 0.02
2011-09-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02
2011-10-01 00:00:00 | 2011-10-01 00:00:00 | Overall | 0.0085 | 0.0085 | 1387 | 0.02
2011-10-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1387 | 0.02
2011-10-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02 |  |  |  | chrt_M_InQQR |  | OFFSET(Summary_InQQR!$B$1,COUNTA(Summary_InQQR!$B:$B)-1,0,-MIN(Summary_InQQR!chrt_M_InQQR_len,COUNTA(Summary_InQQR!$B:$B)-1),1)
2011-11-01 00:00:00 | 2011-11-01 00:00:00 | Overall | 0.0085 | 0.0085 | 1387 | 0.02 |  |  |  |  |  | OFFSET(Summary_InQQR!$B$1,COUNTA(Summary_InQQR!$A:$A)-1,0,-MIN(graph_automatically.xlsx!chrt_M_InQQR_len,[NAME])
2011-11-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1387 | 0.02
2011-11-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02 |  |  |  | chrt_M_InQQR_len |  | (Summary_InQQR!$I$2)*3
2011-12-01 00:00:00 | 2011-12-01 00:00:00 | Overall | 0.0085 | 0.0085 | 1387 | 0.02
2011-12-01 00:00:00 |  | QBD | 0.0025 | 0.0025 | 1387 | 0.02 |  |  |  | chrt_M_InQQR_A |  | OFFSET(Summary_InQQR!chrt_M_InQQR,0,1)
2011-12-01 00:00:00 |  | QVC | 0.056 | 0.01 | 1387 | 0.02
 |  |  |  |  |  |  |  |  |  | chrt_M_InQQR_B |  | OFFSET(Summary_InQQR!chrt_M_InQQR,0,2)
 |  |  |  |  |  |  |  |  |  | [NAME] |  | OFFSET(Summary_InQQR!chrt_M_InQQR,0,3)
 |  |  |  |  |  |  |  |  |  | chrt_M_InQQR_D |  | OFFSET(Summary_InQQR!chrt_M_InQQR,0,4)
 |  |  |  |  |  |  |  |  |  | chrt_M_InQQR_E |  | OFFSET(Summary_InQQR!chrt_M_InQQR,0,5)
 |  |  |  |  |  |  |  |  |  | OFFSET(initial reference, # of rows(to move), # of cols(to move), height, width)
 |  |  |  |  |  |  |  |  |  | OFFSET(Summary_InQQR!$B$1,COUNTA(Summary_InQQR!$B:$B)-1,0,-MIN(Summary_InQQR!chrt_M_InQQR_len,COUNTA(Summary_InQQR!$B:$B)-1),1)
 |  |  |  |  |  |  |  |  |  | OFFSET(Summary_InQQR!$A$1,COUNTA(Summary_InQQR!$a:$a)-1,0,-MIN(Summary_InQQR!chrt_M_InQQR_len,COUNTA(Summary_InQQR!$a:$a)-1),1)
 |  |  |  |  |  |  |  |  |  | OFFSET(Summary_InQQR!$A$1,COUNTA(Summary_InQQR!$a:$a)-1,0,-MIN(Summary_InQQR!chrt_M_InQQR_len,COUNTA(Summary_InQQR!$a:$a)-1),1)
 |  |  |  |  |  |  |  |  |  | OFFSET(Summary_InQQR!$A$1,COUNTA(Summary_InQQR!$B:$B)-1,0,-MIN(Summary_InQQR!chrt_M_InQQR_len,COUNTA(Summary_InQQR!$a:$a)-1),1)