Spreadsheet: 67368d1268002314-pulling-data-from-2-workbooks-example
Sheet: PacingFulfillment_Managed

 |  |  |  | Current Cycle |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Next Cycle |  |  | Life Time (Active Orders Only)
 | Property | Advertiser | Marketing Program | Purchased | Targeted | Spend | Bonus | Credited | Elapsed % | Targeted Fulfilled % | Targeted Variance | Purchased Fulfilled % | Purchased [NAME] | Google % | Yahoo % | MSN % | Ask % | Start Date | End Date | Purchased | Start Date | EndDate | Purchased | To Date Purchased | Actual | Billable | To Date Delivered % | Fulfilled % | Bonus | Credited | To Date Liability | Remaining % | Start Date | End Date | Days Remaining
 | Property name A | Advertiser Name 1 | Program Name 1 | 1000 | 1186.27 | 33.91 | 0 | 0 | 0.0323 | 0.0286 | -0.0037 | 0.0339 | 0.0016 | 1 | 0 | 0 | 0 | 3/1/2010 | 3/31/2010 | 786 | 4/1/2010 | 4/22/2010 | 2000 | 246.26 | 61.64 | 61.64 | 0.2503 | 0.0308 | 0 | 0 | -184.62 | 0.9692 | 2/23/2010 | 4/22/2010 | 52
 | Property name A | Advertiser Name 2 | Program Name 2 | 1026.49 | 1008.93 | 17.38 | 0 | 0 | 0.0323 | 0.0172 | -0.0151 | 0.0169 | -0.0154 | 0.570771 | 0.402761 | 0 | 0.026467 | 3/1/2010 | 3/31/2010 | 264.9 | 4/1/2010 | 4/8/2010 | 5000 | 3741.72 | 3743.55 | 3743.55 | 1.0005 | 0.7487 | 0 | 0 | 1.83 | 0.2513 | 11/9/2009 | 4/8/2010 | 38
 | Property name A | Advertiser Name 3 | Program Name 3 | 1000 | 995.01 | 14.7 | 0 | 0 | 0.0323 | 0.0148 | -0.0175 | 0.0147 | -0.0176 | 0.443537 | 0.508843 | 0 | 0.047619 | 3/1/2010 | 3/31/2010 | 1000 | 4/1/2010 | 4/30/2010 | 10000 | 925.26 | 912.69 | 912.69 | 0.9864 | 0.0913 | 0 | 0 | -12.57 | 0.9087 | 2/4/2010 | 12/3/2010 | 277
 | Property name A | Advertiser Name 4 | Program Name 4 | 5555 | 5610.26 | 200.64 | 0 | 0 | 0.0714 | 0.0358 | -0.0356 | 0.0361 | -0.0353 | 1 | 0 | 0 | 0 | 3/1/2010 | 3/14/2010 | 0 | 1/1/0001 | 1/1/0001 | 10428.35 | 5270.14 | 5018.73 | 5018.73 | 0.9523 | 0.4813 | 0 | 0 | -251.41 | 0.5187 | 2/15/2010 | 3/14/2010 | 13
 | Property name A | Advertiser Name 5 | Program Name 5 | 1666 | 1948.72 | 19.75 | 0 | 0 | 0.0476 | 0.0101 | -0.0375 | 0.0119 | -0.0357 | 0.538227 | 0.336202 | 0.125569 | 0 | 3/1/2010 | 3/21/2010 | 0 | 1/1/0001 | 1/1/0001 | 2222 | 635.33 | 293.03 | 293.03 | 0.4612 | 0.1319 | 0 | 0 | -342.3 | 0.8681 | 2/22/2010 | 3/21/2010 | 20
 | Property name A | Advertiser Name 6 | Program Name 6 | 0 | 0 | 0 | 0 | 0 | 0.0714 | 0 | -0.0714 | 0 | -0.0714 | 0 | 0 | 0 | 0 | 3/1/2010 | 3/14/2010 | 0 | 1/1/0001 | 1/1/0001 | 626.95 | 626.95 | 634.19 | 626.95 | 1 | 1 | 7.24 | 0 | 0 | 0 | 2/15/2010 | 3/14/2010 | 13
 | Property name A | Advertiser Name 7 | Program Name 7 | 0 | 0 | 0 | 0 | 0 | 0.0714 | 0 | -0.0714 | 0 | -0.0714 | 0 | 0 | 0 | 0 | 3/1/2010 | 3/14/2010 | 0 | 1/1/0001 | 1/1/0001 | 55.7 | 55.7 | 55.7 | 55.7 | 1 | 1 | 0 | 0 | 0 | 0 | 2/15/2010 | 3/14/2010 | 13
 | Property name A | Advertiser Name 8 | Program Name 8 | 0 | 82.42 | 53.04 | 0 | 0 | 0.0323 | 0.6435 | 0.6112 | 0 | -0.0323 | 0.665723 | 0.289969 | 0 | 0.044306 | 3/1/2010 | 3/31/2010 | 0 | 1/1/0001 | 1/1/0001 | 27693 | 27693 | 27663.62 | 27663.62 | 0.9989 | 0.9989 | 0 | 0 | -29.38 | 0.0011 | 6/1/2009 | 2/28/2010 | 0
 | Property name B | Advertiser Name 9 | Program Name 9 | 0 | 13.13 | 4.54 | 0 | 0 | 0.0323 | 0.3458 | 0.3135 | 0 | -0.0323 | 0.438325 | 0.348017 | 0 | 0.213656 | 3/1/2010 | 3/31/2010 | 0 | 1/1/0001 | 1/1/0001 | 2250 | 2250 | 2241.41 | 2241.41 | 0.9962 | 0.9962 | 0 | 0 | -8.59 | 0.0038 | 10/14/2009 | 1/13/2010 | 0
 | Property name B | Advertiser Name 10 | Program Name 10 | 1000 | 342 | 35.71 | 0 | 0 | 0.0323 | 0.1044 | 0.0721 | 0.0357 | 0.0034 | 0.990198 | 0 | 0 | 0.009801 | 3/1/2010 | 3/31/2010 | 1000 | 4/1/2010 | 4/30/2010 | 3000 | 1032.26 | 1693.71 | 1693.71 | 1.6408 | 0.5646 | 0 | 0 | 661.45 | 0.4354 | 2/1/2010 | 4/30/2010 | 60
 | Property name B | Advertiser Name 11 | Program Name 11 | 48 | 35.78 | 14.18 | 0 | 0 | 0.3333 | 0.3963 | 0.063 | 0.2954 | -0.0379 | 0.456276 | 0.407616 | 0.086741 | 0.049365 | 3/1/2010 | 3/3/2010 | 0 | 1/1/0001 | 1/1/0001 | 1500 | 1468 | 1478.4 | 1478.4 | 1.0071 | 0.9856 | 0 | 0 | 10.4 | 0.0144 | 12/4/2009 | 3/3/2010 | 2
 | Property name B | Advertiser Name 12 | Program Name 12 | 433.92 | 477.09 | 43.17 | 0 | 0 | 0.0588 | 0.0905 | 0.0317 | 0.0995 | 0.0407 | 0.791985 | 0.176279 | 0.020152 | 0.011582 | 3/1/2010 | 3/17/2010 | 0 | 1/1/0001 | 1/1/0001 | 4620 | 4211.6 | 4186.08 | 4186.08 | 0.9939 | 0.9061 | 0 | 0 | -25.52 | 0.0939 | 9/18/2009 | 3/17/2010 | 16
 | Property name B | Advertiser Name 13 | Program Name 13 | 1538 | 1865.92 | 119.12 | 0 | 0 | 0.0323 | 0.0638 | 0.0315 | 0.0775 | 0.0452 | 0.814137 | 0.165463 | 0.013263 | 0.007135 | 3/1/2010 | 3/31/2010 | 0 | 1/1/0001 | 1/1/0001 | 6152 | 4663.61 | 4905.2 | 4405.2 | 0.9446 | 0.7161 | 0 | 500 | -258.41 | 0.2839 | 12/1/2009 | 3/31/2010 | 30
 | Property name B | Advertiser Name 14 | Program Name 14 | 1538 | 1492.56 | 71.12 | 0 | 0 | 0.0323 | 0.0476 | 0.0153 | 0.0462 | 0.0139 | 0.419994 | 0.397215 | 0.172947 | 0.009842 | 3/1/2010 | 3/31/2010 | 1538 | 4/1/2010 | 4/30/2010 | 10766 | 2629.61 | 2696.56 | 2696.56 | 1.0255 | 0.2505 | 0 | 0 | 66.95 | 0.7495 | 1/11/2010 | 8/10/2010 | 162