Spreadsheet: 187966d1350643323-complex-pivot-table-and-chart-help-investigation-report-test
Sheet: Sheet1

StudyID | Acronym | InvestigatorName | InvestigatorID | SiteName | SiteID | [NAME] | StudyEntryDate |  |  |  |  | Gender | DOB | Ethnicity | Postcode | Approval Date | End Date | Approval to End Months | Target | Target Per Month | Month
 | ABCDEFGHI |  |  |  |  | 31 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 2013-03-31 00:00:00 | 39 | 40 | 1.025641025641026 | Sep-12
 | ABCDEFGHI |  |  |  |  | 31 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2013-04-01 00:00:00 | 17 | 60 | 3.529411764705882 | Sep-12
 | ABCDEFGH |  |  |  |  | 101 | 2009-06-25 00:00:00 |  |  |  |  |  |  |  |  | 2012-05-02 00:00:00 | 2016-07-01 00:00:00 | 50 | 81 | 1.62 | Jun-09
 | ABCDEFGH |  |  |  |  | 102 | 2009-06-26 00:00:00 |  |  |  |  |  |  |  |  | 2012-05-03 00:00:00 | 2016-07-02 00:00:00 | 50 | 81 | 1.62 | Jun-09
 | ABCDEFGHIJ |  |  |  |  | S07 | 2012-01-04 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jan-12
 | ABCDEFGHIJ |  |  |  |  | S08 | 2012-01-05 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jan-12
 | ABCDEFGHIJ |  |  |  |  | S09 | 2012-01-10 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jan-12
 | ABCDEFGHIJ |  |  |  |  | S10 | 2012-01-19 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jan-12
 | ABCDEFGHIJ |  |  |  |  | S11 | 2012-01-24 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jan-12
 | ABCDEFGHIJ |  |  |  |  | S12 | 2012-01-31 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jan-12
 | ABCDEFGHIJ |  |  |  |  | S13 | 2012-02-01 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Feb-12
 | ABCDEFGHIJ |  |  |  |  | S14 | 2012-02-06 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Feb-12
 | ABCDEFGHIJ |  |  |  |  | S15 | 2012-02-28 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Feb-12
 | ABCDEFGHIJ |  |  |  |  | S16 | 2012-03-19 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Mar-12
 | ABCDEFGHIJ |  |  |  |  | S17 | 2012-03-20 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Mar-12
 | ABCDEFGHIJ |  |  |  |  | S18 | 2012-03-21 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Mar-12
 | ABCDEFGHIJ |  |  |  |  | S19 | 2012-03-22 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Mar-12
 | ABCDEFGHIJ |  |  |  |  | S20 | 2012-03-28 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Mar-12
 | ABCDEFGHIJ |  |  |  |  | S21 | 2012-04-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Apr-12
 | ABCDEFGHIJ |  |  |  |  | S22 | 2012-05-08 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | May-12
 | ABCDEFGHIJ |  |  |  |  | S23 | 2012-05-10 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | May-12
 | ABCDEFGHIJ |  |  |  |  | S24 | 2012-05-11 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | May-12
 | ABCDEFGHIJ |  |  |  |  | S25 | 2012-05-11 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | May-12
 | ABCDEFGHIJ |  |  |  |  | S26 | 2012-05-14 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | May-12
 | ABCDEFGHIJ |  |  |  |  | [NAME] | 2012-05-30 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | May-12
 | ABCDEFGHIJ |  |  |  |  | S28 | 2012-06-15 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jun-12
 | ABCDEFGHIJ |  |  |  |  | S29 | 2012-06-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jun-12
 | ABCDEFGHIJ |  |  |  |  | S30 | 2012-06-26 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jun-12
 | ABCDEFGHIJ |  |  |  |  | S31 | 2012-06-29 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jun-12
 | ABCDEFGHIJ |  |  |  |  | S32 | 2012-07-10 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jul-12
 | ABCDEFGHIJ |  |  |  |  | S33 | 2012-07-26 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jul-12
 | ABCDEFGHIJ |  |  |  |  | S34 | 2012-07-27 00:00:00 |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 2014-02-01 00:00:00 | 31 | 75 | 2.419354838709677 | Jul-12
 | ABCD |  |  |  |  | P002 | 2012-02-15 00:00:00 |  |  |  |  |  |  |  |  | 2006-11-16 00:00:00 | 2013-12-31 00:00:00 | 85 | 20 | 0.2352941176470588 | Feb-12
 | ABCD |  |  |  |  | P003 | 2012-03-28 00:00:00 |  |  |  |  |  |  |  |  | 2006-11-16 00:00:00 | 2013-12-31 00:00:00 | 85 | 20 | 0.2352941176470588 | Mar-12
 | ABCD |  |  |  |  | P004 | 2012-05-09 00:00:00 |  |  |  |  |  |  |  |  | 2006-11-16 00:00:00 | 2013-12-31 00:00:00 | 85 | 20 | 0.2352941176470588 | May-12
 | ABCD |  |  |  |  | P001 | 2011-12-13 00:00:00 |  |  |  |  |  |  |  |  | 2006-11-16 00:00:00 | 2013-12-31 00:00:00 | 85 | 20 | 0.2352941176470588 | Dec-11
 | ABCDEF |  |  |  |  | HA5 | 2012-01-09 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Jan-12
 | ABCDEF |  |  |  |  | HA6 | 2012-01-11 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Jan-12
 | ABCDEF |  |  |  |  | HA7 | 2012-01-09 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Jan-12
 | ABCDEF |  |  |  |  | HA8 | 2012-01-25 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Jan-12
 | ABCDEF |  |  |  |  | HA9 | 2012-01-25 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Jan-12
 | ABCDEF |  |  |  |  | HA10 | 2012-01-25 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Jan-12
 | ABCDEF |  |  |  |  | HA11 | 2012-02-09 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Feb-12
 | ABCDEF |  |  |  |  | HA12 | 2012-02-10 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Feb-12
 | ABCDEF |  |  |  |  | HA13 | 2012-02-14 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Feb-12
 | ABCDEF |  |  |  |  | HA14 | 2012-02-24 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Feb-12
 | ABCDEF |  |  |  |  | HA15 | 2012-03-06 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Mar-12
 | ABCDEF |  |  |  |  | HA16 | 2012-03-06 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Mar-12
 | ABCDEF |  |  |  |  | HA17 | 2012-03-14 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Mar-12
 | ABCDEF |  |  |  |  | HA18 | 2012-03-16 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Mar-12
 | ABCDEF |  |  |  |  | HA19 | 2012-03-16 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Mar-12
 | ABCDEF |  |  |  |  | HA1 | 2011-12-19 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Dec-11
 | ABCDEF |  |  |  |  | HA2 | 2011-12-15 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Dec-11
 | ABCDEF |  |  |  |  | HA3 | 2011-12-20 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Dec-11
 | ABCDEF |  |  |  |  | HA4 | 2011-12-15 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-16 00:00:00 | 2013-10-02 00:00:00 | 12 | 72 | 6 | Dec-11
 | ABC |  |  |  |  | 011 | 2012-06-22 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Jun-12
 | ABC |  |  |  |  | 013 | 2012-06-29 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Jun-12
 | ABC |  |  |  |  | 015 | 2012-06-22 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Jun-12
 | ABC |  |  |  |  | 017 | 2012-07-13 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Jul-12
 | ABC |  |  |  |  | 019 | 2012-07-13 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Jul-12
 | ABC |  |  |  |  | 021 | 2012-07-20 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Jul-12
 | ABC |  |  |  |  | 023 | 2012-07-20 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Jul-12
 | ABC |  |  |  |  | 025 | 2012-07-18 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Jul-12
 | ABC |  |  |  |  | 027 | 2012-07-27 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Jul-12
 | ABC |  |  |  |  | 053 | 2012-08-24 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Aug-12
 | ABC |  |  |  |  | 055 | 2012-08-17 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Aug-12
 | ABC |  |  |  |  | 057 | 2012-08-24 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Aug-12
 | ABC |  |  |  |  | 059 | 2012-08-24 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Aug-12
 | ABC |  |  |  |  | 061 | 2012-08-24 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Aug-12
 | ABC |  |  |  |  | 063 | 2012-08-24 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Aug-12
 | ABC |  |  |  |  | 065 | 2012-08-24 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Aug-12
 | ABC |  |  |  |  | 067 | 2012-08-24 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Aug-12
 | ABC |  |  |  |  | 069 | 2012-08-24 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Aug-12
 | ABC |  |  |  |  | 071 | 2012-08-22 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00 | 2012-10-31 00:00:00 | 3 | 33 | 11 | Aug-12
 | ABCDE |  |  |  |  | 110 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2015-03-22 00:00:00 | 40 | 170 | 4.25 | Sep-12
 | ABCDE |  |  |  |  | 111 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2015-03-22 00:00:00 | 40 | 170 | 4.25 | Sep-12
 | ABCDE |  |  |  |  | 112 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2015-03-22 00:00:00 | 40 | 170 | 4.25 | Sep-12
 | ABCDE |  |  |  |  | 114 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2015-03-22 00:00:00 | 40 | 170 | 4.25 | Sep-12
 | ABCDE |  |  |  |  | 115 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2015-03-22 00:00:00 | 40 | 170 | 4.25 | Sep-12
 | ABCDE |  |  |  |  | 116 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2015-03-22 00:00:00 | 40 | 170 | 4.25 | Sep-12
 | ABCDE |  |  |  |  | 117 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2015-03-22 00:00:00 | 40 | 170 | 4.25 | Sep-12
 | ABCDE |  |  |  |  | 118 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2015-03-22 00:00:00 | 40 | 170 | 4.25 | Sep-12
 | ABCDEFG |  |  |  |  | 07 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2013-04-01 00:00:00 | 17 | 60 | 3.529411764705882 | Sep-12
 | ABCDEFG |  |  |  |  | 08 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2013-04-01 00:00:00 | 17 | 60 | 3.529411764705882 | Sep-12
 | ABCDEFG |  |  |  |  | 09 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2013-04-01 00:00:00 | 17 | 60 | 3.529411764705882 | Sep-12
 | ABCDEFG |  |  |  |  | 10 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2013-04-01 00:00:00 | 17 | 60 | 3.529411764705882 | Sep-12
 | ABCDEFG |  |  |  |  | 11 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2013-04-01 00:00:00 | 17 | 60 | 3.529411764705882 | Sep-12
 | ABCDEFG |  |  |  |  | 12 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2013-04-01 00:00:00 | 17 | 60 | 3.529411764705882 | Sep-12
 | ABCDEFG |  |  |  |  | 13 | 2012-09-25 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 2013-04-01 00:00:00 | 17 | 60 | 3.529411764705882 | Sep-12