Spreadsheet: 45068d1243863032-creating-monthly-data-table-from-weekly-data-table-test_data_2
Sheet: Stream vs Resolver 

'WC - 16-03-09'! |  |  |  |  | Stream vs [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Calls
'WC - 23-03-09'!
'WC - 30-03-09'! |  | [NAME] |  |  | MCA |  |  | Ad Rock |  |  |  |  | Snoop |  |  |  |  |  |  | Aesop Rock |  |  | El-p
'WC - 06-04-09'! |  | Style | Vibe |  | Style | Vibe |  | Style |  |  | Vibe |  | Style |  |  | Vibe |  |  |  | Style | Vibe |  | Style | Vibe |  | Style | Vibe
'WC - 13-04-09'! | 2009-03-16 00:00:00 | 48 | 0 |  | 3 | 0 |  | 5 |  |  | 4 |  | 1 | NA() |  | 31 | NA() | NA() |  | 0 | 9 |  | 0 | 0 |  | 57 | 44 |  | 2009-03-16 00:00:00 | 2009-03-01 00:00:00 | 2009-03-16 00:00:00
'WC - 20-04-09'! | 2009-03-23 00:00:00 | 58 | 0 |  | 7 | 5 |  | 5 |  |  | 2 |  | 0 |  |  | 31 |  |  |  | 2 | 1 |  | 1 | 3 |  | 73 | 42 |  | 2009-03-23 00:00:00 | 2009-04-01 00:00:00
'WC - 27-04-09'! | 2009-03-30 00:00:00 | 51 | 0 |  | 7 | 2 |  | 8 |  |  | 3 |  | 0 |  |  | 10 |  |  |  | 0 | 0 |  | 4 | 5 |  | 70 | 20 |  | 2009-03-30 00:00:00 | 2009-05-01 00:00:00
'WC - 04-05-09'! | 2009-04-06 00:00:00 | 44 | 0 |  | 5 | 6 |  | 13 |  |  | 4 |  | 0 |  |  | 14 |  |  |  | 0 | 1 |  | 5 | 0 |  | 67 | 25 |  | 2009-04-06 00:00:00 | 2009-06-01 00:00:00
'WC - 11-05-09'! | 2009-04-13 00:00:00 | 50 | 0 |  | 13 | 0 |  | 7 |  |  | 1 |  | 0 |  |  | 21 |  |  |  | 0 | 1 |  | 1 | 1 |  | 71 | 24 |  | 2009-04-13 00:00:00 | 2009-07-01 00:00:00
'WC - 18-05-09'! | 2009-04-20 00:00:00 | 43 | 2 |  | 8 | 0 |  | 11 |  |  | 1 |  | 1 |  |  | 7 |  |  |  | 0 | 0 |  | 3 | 0 |  | 66 | 10 |  | 2009-04-20 00:00:00 | 2009-08-01 00:00:00
'WC - 25-05-09'! | 2009-04-27 00:00:00 | 49 | 0 |  | 14 | 4 |  | 6 |  |  | 2 |  | 1 |  |  | 11 |  |  |  | 0 | 1 |  | 1 | 3 |  | 71 | 21 |  | 2009-04-27 00:00:00 | 2009-09-01 00:00:00
'WC - 11-04-11'! | 2009-05-04 00:00:00 | 35 | 1 |  | 13 | 3 |  | 10 |  |  | 0 |  | 0 |  |  | 8 |  |  |  | 0 | 0 |  | 5 | 4 |  | 63 | 16 |  | 2009-05-04 00:00:00 | 2009-10-01 00:00:00
'Stream Stats'! | 2009-05-11 00:00:00 | 54 | 0 |  | 9 | 1 |  | 8 |  |  | 2 |  | 0 |  |  | 25 |  |  |  | 0 | 1 |  | 1 | 0 |  | 72 | 29 |  | 2009-05-11 00:00:00 | 2009-11-01 00:00:00
'Stream %'! | 2009-05-18 00:00:00 | 41 | 1 |  | 15 | 3 |  | 6 |  |  | 2 |  | 0 |  |  | 14 |  |  |  | 0 | 0 |  | 1 | 0 |  | 63 | 20 |  | 2009-05-18 00:00:00 | 2009-12-01 00:00:00
'Resolver Stats'! | 2009-05-25 00:00:00 | 25 | 0 |  | 13 | 1 |  | 1 |  |  | 1 |  | 0 |  |  | 10 |  |  |  | 0 | 1 |  | 1 | 1 |  | 40 | 14 |  | 2009-05-25 00:00:00 | 2010-01-01 00:00:00
'Resolver %'! | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA() |  | NA() | 2010-02-01 00:00:00
'Parameters'! | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA() |  | NA() | 2010-03-01 00:00:00
 | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA() |  | NA() | 2010-04-01 00:00:00
 | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA() |  | NA()
 | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA() |  | NA()
 | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA() |  | NA()
 | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA() |  | NA()
 | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA() |  | NA()
 | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA() |  | NA()
 | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA()
 | NA() | NA() | NA() |  | NA() | NA() |  | NA() |  |  | NA() |  | NA() |  |  | NA() |  |  |  | NA() | NA() |  | NA() | NA() |  | NA() | NA()
 | Weekly Average (excludes current WC) | 47.3 | 0.4 |  | 6.566666666666666 | 4.133333333333334 |  | 7.9 |  |  | 2.1 |  | 0.3 | 17.2 | 17.2 | 17.2 | 0.2 | 0.7727272727272727 |  | 0.2 | 1.4 |  | 2.2 | 1.6 |  | 67.3 | 25.1 |  |  |  |  | Totals
 | Total | 498 | 4 |  | 107 | 25 |  | 80 |  |  | 22 |  | 3 | 0 | 0 | 182 | 0 | 0 |  | 2 | 15 |  | 23 | 17 |  | 713 | 265 |  |  |  |  | [NAME] |  |  | MCA |  |  | Ad Rock |  |  | Aesop Rock |  |  | El-p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Style | Vibe |  | Style | Vibe |  | Style | Vibe |  | Style | Vibe |  | Style | Vibe
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-03-01 00:00:00 |  | 157 | 0 |  | 17 | 7 |  | 18 | 9 |  | 72 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-04-01 00:00:00 |  | 186 | 2 |  | 40 | 10 |  | 37 | 0 |  | 8 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-05-01 00:00:00 |  | 155 | 2 |  | 50 | 8 |  | 25 | 0 |  | 5 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-07-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-08-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-09-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-11-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-03-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-05-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-06-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-07-01 00:00:00 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0