Spreadsheet: 80012d1280254651-use-indirect-pull-data-from-multiple-wbs-into-consolidating-ws-pu-7312129
Sheet: New Monitoring Value Datasheet

 |  | PROJECT UPDATE (SITE MANAGEMENT) |  |  |  |  |  |  |  | 40543
Activity Name |  | 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 | 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
 |  |  |  |  |  |  |  | Units | $ | Units | $ |  | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00 | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00 | 2012-12-31 00:00:00 | 2013-01-31 00:00:00 | 2013-02-28 00:00:00 |  | 2010 | 2010 | 2011 | 2011 | 2012 | 2012 | 2013 | 2013 | Project to Date Actual |  | Project Remaining |  | Project to Date Total
Medical Monitoring |  |  |  |  |  |  |  |  |  |  |  |  | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |  | Units | $ | Units | $ | Units | $ | Units | $ | Units | $ | Units | $ | Units | $
Process A |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Process B |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Process C |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Process D |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Process E |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Process F |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Medical Monitoring Total |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Clinical Monitoring
Process 1 |  | 2010-05-21 00:00:00 | 1900-01-01 00:00:00 | per study | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Process 2 |  | 2010-06-17 00:00:00 | 1900-01-01 00:00:00 | Per week | 13 | 2069.0631 | 159.1587 | 0 | 0 | 5 | 795.7934999999999 |  | 0 | 0 | 0 | 159.1587 | 636.6347999999999 | 636.6347999999999 | 636.6347999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 13 | 2069.0631 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 795.7934999999999 | 8 | 1273.2696 | 13 | 2069.0631
Process 3 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | per T-con | 7 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 7 | 0
Process 4 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | per study | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Process 5 |  | 2010-06-17 00:00:00 | 1900-01-01 00:00:00 | per study | 1 | 2400.1164 | 2400.1164 | 0 | 0 | 1 | 2400.1164 |  | 0 | 0 | 0 | 2400.1164 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 | 2400.1164 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2400.1164 | 0 | 0 | 1 | 2400.1164
Process 6 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | per visit | 1 | 7733.7084 | 7733.7084 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 7733.7084 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 | 7733.7084 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 7733.7084 | 1 | 7733.7084
Process 7 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | per hour | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Process 8 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | per visit | 12 | 91204.42319999999 | 7600.368599999999 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 91204.42319999999 | 0 | 0
Process 9 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | per visit | 12 | 33601.6296 | 2800.1358 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 33601.6296 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 12 | 33601.6296 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 33601.6296 | 12 | 33601.6296
Process 10 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | per hour | 133 | 57602.7936 | 433.1037112781955 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 57602.7936 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 133 | 57602.7936 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 133 | 57602.7936 | 133 | 57602.7936
Process 11 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Process 12 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | per visit | 1 | 2266.7766 | 2266.7766 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2266.7766 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 | 2266.7766 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2266.7766 | 1 | 2266.7766
Process 13 |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | per study | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Clinical Monitoring Total |  |  |  |  | 35 | 105674.0877 | 20160.1287 | 0 | 0 | 6 | 3195.9099 |  | 0 | 0 | 0 | 2559.2751 | 636.6347999999999 | 99574.7664 | 636.6347999999999 | 2266.7766 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 168 | 105674.0877 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 3195.9099 | 174 | 102478.1778 | 168 | 105674.0877
 |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Study |  |  |  |  |  | 105674.0877 | 20160.1287 | 0 | 0 | 6 | 3195.9099 |  | 0 | 0 | 0 | 2559.2751 | 636.6347999999999 | 99574.7664 | 636.6347999999999 | 2266.7766 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 168 | 105674.0877 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 3195.9099 | 174 | 102478.1778 | 168 | 105674.0877
 |  |  |  |  | Project to date Revenue | 3195.9099
 |  |  | 7132-129 |  | PS ActRev | #N/A
 |  |  |  |  | Over(Under) Recognized | #N/A