Spreadsheet: 78582d1278956142-sum-multiple-columns-if-col-date-ptd-date-ecd-sum-all-year-unit-or-
Sheet: SUM Col based on Date

PROJECT UPDATE (SITE MANAGEMENT)
Activity Name | Activity ID | Start | Finish | Activity Units | Units Budgeted | Total Price | Price/Unit |  | Check/Non Sprad |  |  | Project to Date |  |  | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2013 | 2013 | 2013 |  |  |  |  | 2010-06-30 00:00:00 |  |  |  | 6
 |  |  |  |  |  |  |  |  | Units | $ |  | Units |  |  | 2010-04-01 00:00:00 | 2010-05-02 00:00:00 | 2010-06-02 00:00:00 | 2010-07-03 00:00:00 | 2010-08-03 00:00:00 | 2010-09-03 00:00:00 | 2010-10-04 00:00:00 | 2010-11-04 00:00:00 | 2010-12-05 00:00:00 | 2011-01-05 00:00:00 | 2011-02-05 00:00:00 | 2011-03-08 00:00:00 | 2011-04-08 00:00:00 | 2011-05-09 00:00:00 | 2011-06-09 00:00:00 | 2011-07-10 00:00:00 | 2011-08-10 00:00:00 | 2011-09-10 00:00:00 | 2011-10-11 00:00:00 | 2011-11-11 00:00:00 | 2011-12-12 00:00:00 | 2012-01-12 00:00:00 | 2012-02-12 00:00:00 | 2012-03-14 00:00:00 | 2012-04-14 00:00:00 | 2012-05-15 00:00:00 | 2012-06-15 00:00:00 | 2012-07-16 00:00:00 | 2012-08-16 00:00:00 | 2012-09-16 00:00:00 | 2012-10-17 00:00:00 | 2012-11-17 00:00:00 | 2012-12-18 00:00:00 | 2013-01-18 00:00:00 | 2013-02-18 00:00:00 | 2013-03-21 00:00:00 | 2010 | 2011 | 2012 | 2013 | Project to Date Actual | Project to Date Forecast
Site Management |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units | Units
Start-up (includes Safetly Plan) |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
Subject Eligibility (Recruitment/Enrollment) |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
Teleconferences |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
On-going Study Monitoring |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
SAE (per SAE) |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
CSR |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
Monitoring
Administrative/Set up |  | 2010-05-21 00:00:00 |  | per study | 1 | 3735 | 3735 |  | 1 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 1
Site Management |  | 2010-05-21 00:00:00 | 2010-06-17 00:00:00 | Per week | 7 | 3922 | 560.2857142857143 |  | 7 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 7
Teleconferences |  |  |  | per T-con | 4 | 747 | 186.75 |  | 4 |  |  | 0 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 | 4
Qualification Visit (SQV) |  |  |  | per study | 0 | 0 | 0 |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
Initiation Visit (SIV) |  | 2010-06-17 00:00:00 |  | per study | 1 | 3361 | 3361 |  | 1 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 1
Process Monitoring Visit (PMV) |  |  |  | per visit | 0 | 0 | 0 |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
Process Monitoring Visit (PMV) (Add for 2nd Design) |  |  |  | per hour |  | 0 | 0 |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
Routine Monitoring Visit (RMV) |  |  |  | per visit | 8 | 59011 | 7376.375 |  | 8 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 8
 |  |  |  |  |  | 0 | 0 |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | 0 | 0 |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0
Close-Out Visit (COV) |  |  |  | per visit | 1 | 2801 | 2801 |  | 1 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 1
 |  |  |  |  |  | 73577