{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Active-Completed","Development","Proposals","Definitions","Forecast to Budget","In Discussion","Lists","DC'D In D-P","Archieved","Budget Sheet","Pharma Names","Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":213,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Active-Completed","index":0,"n_rows":235,"n_cols":51,"rows_kept":235,"cut":false,"hidden":false,"merged":[[228,0,228,5],[229,0,229,5],[227,0,227,5]]}
["ACTIVE / COMPLETED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Results / Estimates for Ramp Up",null,null,null,null,null,null,null,null,null,null,null,"FY 2013"]
["Client","NPAD","Program Name","Product Line","Type","Status","Contract Value","Monthly Value","FY Value","Start Date","Term Date","Expected Program End Date","Renewal Prob%","Target Activity (letters/Pts/$)","Activity       (to Date)","Next Report Due Date","Latest Report Results","PCC #","Comments","blank","ID","2011-09","2011-10","2011-11","2011-12","2012-01","2012-02","2012-03","2012-04","2012-05","2012-06","2012-07","2012-08","2012-09","2012-10","2012-11","2012-12","2013-01","2013-02","2013-03","2013-04","2013-05","2013-06","2013-07","2013-08","Unit Lift","WAC","Tot Rev","Total Purch","Total GP","Comment"]
["Abbott",{"$f":"IF(A4=\"\",\"\",VLOOKUP(A4,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Androgel IVR","Adherence","IVR","Completed",244320,20360,183240,"2012-02-28","2012-12-20","2012-12-31",null,48000,null,"2012-07-15","2012-06-30","9493, 9494","FU on initial call volmue",null,51,null,null,null,null,null,null,11315.5,14592.17,15519.83,14357.57,16084.28,14009.140000000001,12575.23,14994.61,14283.67,14024,null,null,null,null,null,null,null,null,null,null,{"$f":"AT4*AU4*1.2*0.87","v":0},{"$f":"AU4*0.975*AT4","v":0},{"$f":"AV4-AW4","v":0}]
["Abbott",{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Humira Inj Training","RPh Service","SAR","Active",1600000,{"$f":"G5/12","v":133333.33333333334},{"$f":"H5*8","v":1066666.6666666667},"2012-01-17","2012-12-14","2013-12-14",null,null,null,null,null,"N/A","Market Activity Report with Lantus, Victoza? Rx Advisor Data?  Report broken down by all and then by program.  15th of every month",null,45,0,0,0,9030,9150,59430,153420,94360,104770,102685,92970,86187.5,82715,83015,90392.5,86402.5,96960,89557.5,98637.5,80970,92830,75797.5,83497.5,86992.5,null,null,0,0,0]
["Abbott",{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Humira Inj Training (Pre Bill)","RPh Service","SAR","Completed",9000,9000,90000,"2011-11-01","2011-12-31","2011-12-31","NA",null,null,"2012-01-30",null,"N/A","Need volume and $ from inception to Mfar",null,43,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Abbott",{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Niaspan/Simcor IVR","Adherence","IVR","Completed",593728,25641.620000000003,{"$f":"IF(J7=K7,H7,(IF(DATE(2012,8,31)<K7,DATE(2012,8,31),K7)-IF(DATE(2011,9,1)>J7,DATE(2011,9,1),J7))/30*H7)","v":311973.04333333333},"2011-06-22","2013-05-01","2012-12-31",null,67200,69109,"2012-02-15","2012-06-30","1924-11-22",null,null,1,12715.5,26762.560000000001,25641.620000000003,19620.98,27087.47,27087.47,23601.5,23661.84,23008.22,20478.21,19851.3,19718.72,18960.8,21546.67,18846.38,19138,null,null,null,null,null,null,null,null,{"$f":"11*1.4*25000","v":384999.99999999994},4,1607759.9999999998,1501499.9999999998,106260,"(25,000 pts heard msg at  11 days)"]
["Abbott",{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Tricor/Trilipix IVR","Adherence","IVR","Completed",586331,15392.8,{"$f":"IF(J8=K8,H8,(IF(DATE(2012,8,31)<K8,DATE(2012,8,31),K8)-IF(DATE(2011,9,1)>J8,DATE(2011,9,1),J8))/30*H8)","v":171373.17333333331},"2011-10-02","2013-05-01","2012-12-31",null,50400,3015,"2012-02-15","2012-06-30","1925-06-10","Tricor expires 7/31/12",null,2,0,10384.240000000002,15392.8,16097.07,10154.450000000001,20354.45,18009.75,17556.29,17811.78,16917.27,17274.34,17690.420000000002,17387.23,18701.53,17827.759999999998,17664.5,null,null,null,null,null,null,null,null,{"$f":"40000*5","v":200000},4.8899999999999997,1021031.9999999998,953549.99999999988,67481.999999999884,"(40,000 pts at 5 days)"]
["Acurian",{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Diabetes (DSS1)","Clinical Trials","DM","Completed - 1T",44182,44182,44182,"2012-02-06","2012-02-06","2012-02-06","N/A",null,null,null,null,null,"W199",null,47,null,null,null,null,null,44182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Diabetes (DSS1)","Clinical Trials","DM","Completed - 1T",36000,36000,36000,"2012-02-20","2012-02-20",{"$f":"K10","v":"2012-02-20"},"N/A",null,null,null,null,null,"W230",null,48,null,null,null,null,null,33375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Diabetes (DSS1)","Clinical Trials","DM","Completed - 1T",90000,90000,90000,"2012-03-13","2012-03-13",{"$f":"K11","v":"2012-03-13"},"N/A",null,null,null,null,null,"W242",null,52,null,null,null,null,null,null,87751,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Diabetes (DSS1)","Clinical Trials","DM","Completed - 1T",44000,44000,44000,"2012-05-31","2012-05-31",{"$f":"K12","v":"2012-05-31"},"N/A",null,null,null,null,null,"W370",null,52,null,null,null,null,null,null,null,null,41474,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Diabetic Peripheral Neuropathy (1675)","Clinical Trials","DM","Completed - 1T",33322,16697,16697,"2011-10-06","2011-10-06",{"$f":"K13","v":"2011-10-06"},"N/A",null,null,"2012-07-15",null,"N/A","16663 + 16659",null,3,0,16697,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian","GregL","Gout (2029) W4","Clinical Trials","DM","Completed - 1T",78000,78000,78000,"2012-08-24","2013-02-20","2012-08-27","N/A",null,null,null,null,null,"2013-02-20",null,88,null,null,null,null,null,null,null,null,null,null,null,77754,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"2013-02-20"]
["Acurian","GregL","IBS (1964) W11","Clinical Trials","DM","Completed - 1T",7300,7300,7300,"2012-08-23",{"$f":"J15","v":"2012-08-23"},"2012-08-23","N/A",null,null,null,null,null,"2013-02-16",null,89,null,null,null,null,null,null,null,null,null,null,null,7201,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT15*AU15*1.2*0.87","v":0},{"$f":"AU15*0.975*AT15","v":0},{"$f":"AV15-AW15","v":0},"2013-02-16"]
["Acurian","GregL","IBS (1964) W16","Clinical Trials","DM","Completed - 1T",13000,13000,13000,"2012-09-18","2012-09-18","2012-09-18","N/A",null,null,null,null,null,"2013-02-16",null,98,null,null,null,null,null,null,null,null,null,null,null,null,12075,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"2013-02-16"]
["Acurian","GregL","IBS (1964) W7","Clinical Trials","DM","Completed - 1T",13000,13000,13000,"2012-08-16","2012-08-16","2012-08-16","N/A",61261,null,null,null,null,"2013-02-16",null,85,null,null,null,null,null,null,null,null,null,null,null,10548,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"2013-02-16"]
["Acurian",{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"MDDS2 (1848) W25","Clinical Trials","DM","Completed - 1T",480000,480000,480000,"2012-06-15","2012-06-15",{"$f":"K18","v":"2012-06-15"},"N/A",null,null,null,null,null,null,null,74,null,null,null,null,null,null,null,null,null,421234,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"MDDS2 (1848) W40","Clinical Trials","DM","Completed - 1T",73000,73000,480000,"2012-07-27","2012-07-27","2012-07-27","N/A",null,null,null,null,null,null,null,80,null,null,null,null,null,null,null,null,null,null,63848,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian","GregL","MDDS2 (1848) W48","Clinical Trials","DM","Completed - 1T",16000,16000,16000,"2012-08-03","2012-08-03","2012-08-03","N/A",null,null,null,null,null,null,null,84,null,null,null,null,null,null,null,null,null,null,null,15219,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian","GregL","MDDS2 (1848) W80","Clinical Trials","DM","Completed - 1T",49000,49000,49000,"2012-08-13","2012-08-13","2012-08-13","N/A",null,null,null,null,null,null,null,86,null,null,null,null,null,null,null,null,null,null,null,42866,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian","GregL","MDDS2 W98","Clinical Trials","DM","Completed - 1T",63000,63000,63000,"2012-08-22","2012-08-22","2012-08-22","N/A",null,null,null,null,null,null,null,88,null,null,null,null,null,null,null,null,null,null,null,62186,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian","GregL","OA/RA + CV CTR (1952)","Clinical Trials","DM","Completed - 1T",13000,13000,13000,"2012-07-20",{"$f":"J23","v":"2012-07-20"},"2012-07-20","N/A",null,null,null,null,null,"2013-01-31",null,81,null,null,null,null,null,null,null,null,null,null,12557,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"OIC (1682)","Clinical Trials","DM","Completed - 1T",75126,75126,75126,"2012-04-02",{"$f":"J24","v":"2012-04-02"},"2012-04-02","N/A",null,null,null,null,null,"2012-10-02",null,64,null,null,null,null,null,null,null,75126,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"OIC reminder letter (1682)","Clinical Trials","DM","Completed - 1T",36067,36067,36067,"2012-04-02",{"$f":"J25","v":"2012-04-02"},"2012-04-02","N/A",null,null,null,null,null,"2012-10-02",null,65,null,null,null,null,null,null,null,36067,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Rheumatoid Arthritis (1768/RAS1)","Clinical Trials","DM","Completed - 1T",36678,18337,18337,"2011-10-07","2011-10-07","2011-10-07","N/A",null,null,"N/A",null,"N/A","18341 + 18337",null,4,0,18337,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Rheumatoid Arthritis (1768/RAS1)","Clinical Trials","DM","Completed - 1T",11880,11880,11880,"2011-12-09","2011-12-09","2011-12-09","N/A",null,null,null,null,"N/A","total pool = 28,538; expected mail count = 26,250",null,199,0,0,0,11880,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian","GregL","OA/RA + CV/DB/SM CTR (1952)","Clinical Trials","DM","Completed - 1T",340000,340000,340000,"2012-10-18",{"$f":"J28","v":"2012-10-18"},"2012-10-18","N/A",null,null,null,null,null,"2013-01-31",null,103,null,null,null,null,null,null,null,null,null,null,null,null,null,323067,12170,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Crohn's (1931) W11","Clinical Trials","DM","Completed - 1T",15000,15000,15000,"2012-11-01","2013-01-31","2013-01-31","N/A",null,null,null,null,null,null,null,121,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15073,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian","GregL","Gout (2029) W7","Clinical Trials","DM","Completed - 1T",78000,78000,78000,"2012-08-24","2013-02-20",null,null,null,null,null,null,null,null,null,154,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60725,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"RA (2012) W4","Clinical Trials","DM","Completed - 1T",20000,20000,20000,"2012-12-01","2013-03-31","2013-03-31",null,null,null,null,null,null,null,null,155,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19405,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian","GregL","Crohn's (1931) W20 reminder","Clinical Trials","DM","Completed - 1T",15000,15000,15000,"2012-11-01","2013-01-31","2013-01-31","N/A",null,null,null,null,null,null,null,156,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14684,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian","GregL",null,"Clinical Trials","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,157,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Acurian",{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"COPD (2013) W86","Clinical Trials","DM","Completed - 1T",null,null,null,"2013-01-11","2013-07-01","2013-01-11",null,null,null,null,null,null,null,null,170,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,169764,null,null,null,null,null,null,null,null,null,{"$f":"AT34*AU34*1.2*0.87","v":0},{"$f":"AU34*0.975*AT34","v":0},{"$f":"AV34-AW34","v":0}]
["Acurian",{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"High TG (2038) W1","Clinical Trials","DM","Completed - 1T",null,null,null,"2013-01-11","2014-01-03","2013-01-11",null,null,null,null,null,null,null,null,171,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28298,null,null,null,null,null,null,null,null,null,{"$f":"AT35*AU35*1.2*0.87","v":0},{"$f":"AU35*0.975*AT35","v":0},{"$f":"AV35-AW35","v":0}]
["Acurian",{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"RA (2012) W21","Clinical Trials","DM","Completed - 1T",null,null,null,"2013-01-24","2013-03-31","2013-01-24",null,null,null,null,null,null,null,null,172,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15665,null,null,null,null,null,null,null,null,null,{"$f":"AT36*AU36*1.2*0.87","v":0},{"$f":"AU36*0.975*AT36","v":0},{"$f":"AV36-AW36","v":0}]
["Acurian",{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Crohn's (1931) W32/33 & W41/42","Clinical Trials","DM","Completed - 1T",null,null,null,"2013-01-24","2013-01-31","2013-01-30",null,null,null,null,null,null,null,null,173,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14433,null,null,null,null,null,null,null,null,null,{"$f":"AT37*AU37*1.2*0.87","v":0},{"$f":"AU37*0.975*AT37","v":0},{"$f":"AV37-AW37","v":0}]
["Acurian",{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"COPD (2013) W201","Clinical Trials","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,208,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151458]
["Acurian","GregL","OA/RA + CV CTR (1952) W355","Clinical Trials","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,209,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59188]
["Acurian","GregL","Back Pain CTR (2096) W44","Clinical Trials","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75005]
["Alcon",{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"90-Day - Azopt & Travatan Z","90-Day","REB","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,205,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38140,18000,18000,18000]
["Allergan",{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Lumigan RPh Alert","Education","MPU","Completed - 1T",25000,25000,25000,null,null,null,null,null,null,null,null,null,null,null,160,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Amylin","MaryT","Bydureon RPh Alert","Education","MPU","Completed - 1T",25000,25000,25000,"2012-04-02","2012-04-16",{"$f":"K43","v":"2012-04-16"},null,null,null,null,null,null,"Published 4/25/12",null,68,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Amylin",{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Byetta ","Adherence","DM","Completed",111000,11056.5,{"$f":"IF(J44=K44,H44,(IF(DATE(2012,8,31)<K44,DATE(2012,8,31),K44)-IF(DATE(2011,9,1)>J44,DATE(2011,9,1),J44))/30*H44)","v":134520.75},"2011-07-09","2013-02-28","2013-03-31",null,12000,18142,"2012-01-15",null,"1925-01-01",null,null,5,11458.2,13080.6,11056.5,11823.75,11436.75,9600.75,0,6297.75,8012.25,7758,7731,7503.75,6842.25,7242.75,6846.75,7085.25,6212.25,6423.75,7031.25,null,null,null,null,null,null,null,0,0,0]
["Amylin",{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Adheris - Symlin","Adherence","DM","Active",null,null,null,"2012-12-05",null,null,null,null,null,null,null,null,null,null,142,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4203.84,4588.96,2794.8299999999995,2971.8299999999995,2242.5899999999997,1246.08,0,null,null,null,null,0,0,0]
["Amylin","MaryT","Bydureon RPh Alert (kits)","Education","MPU","Completed - 1T",25000,25000,25000,null,null,null,null,null,null,null,null,null,null,null,158,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Aptalis","TomR","Rectiv MPU","Education","MPU","Completed - 1T",25000,25000,25000,"2012-05-21","2012-05-21",{"$f":"K47","v":"2012-05-21"},"N/A",null,null,null,null,"N/A",null,null,70,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Aptalis",{"$f":"IF(A48=\"\",\"\",VLOOKUP(A48,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"????"},"Viokace - RPh EDU","Education","MPU","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,174,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,{"$f":"AT48*AU48*1.2*0.87","v":0},{"$f":"AU48*0.975*AT48","v":0},{"$f":"AV48-AW48","v":0}]
["Astellas",{"$f":"IF(A49=\"\",\"\",VLOOKUP(A49,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Vesicare","Adherence","DM","Active",202000,{"$f":"G49/12","v":16833.333333333332},202000,"2012-10-23","2013-09-30",null,null,null,null,null,null,null,null,null,108,null,null,null,null,null,null,null,null,null,null,null,null,null,21079,0,20740.199999999997,13603.2,13208,15971.800000000001,7607.6,null,null,null,null,null,null,0,0,0,"(3,000 pts per year * 5 days"]
["Astellas",{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Myrbetriq  MPU","Education","MPU","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,221,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000]
["Astellas",{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Astragraf XL MPU ","Education","MPU","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,226,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000]
["AstraZeneca",{"$f":"IF(A52=\"\",\"\",VLOOKUP(A52,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Crestor","90-Day","PCC","Completed",370000,{"$f":"G52/12","v":30833.333333333332},{"$f":"H52*9","v":277500},"2012-01-02","2012-05-15",null,null,null,null,"2012-02-28",null,"1925-07-20","To be turned off week of 5/14/2012 due to max dollar volumne",null,42,0,0,0,0,{"$f":"6689.67+53520","v":60209.67},59093.62,51627.360000000001,57589.87,35103.51,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"(15,000 pts per year at 10 days per patient)"]
["AstraZeneca",{"$f":"IF(A53=\"\",\"\",VLOOKUP(A53,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Nexium DN","Other","DM","Completed - 1T",null,null,null,"2013-02-18",null,null,null,null,null,null,null,null,null,null,182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47140.800000000003,null,null,null,null,null,null,null,{"$f":"AT53*AU53*1.2*0.87","v":0},{"$f":"AU53*0.975*AT53","v":0},{"$f":"AV53-AW53","v":0}]
["AstraZeneca","VanA","Adheris - Nexium DN","Other","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,214,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29005.760000000002]
["AstraZeneca",{"$f":"IF(A55=\"\",\"\",VLOOKUP(A55,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Crestor DN CAP mailing","Other","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,223,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54600]
["B&L",{"$f":"IF(A56=\"\",\"\",VLOOKUP(A56,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Advisory Board (6/26/13)","Education","Other","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,213,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60000]
["Bayer Diagnostics","TomR","Blood Glucose Monitoring and Catalina Messaging (Pilot) and Breeze & Contour TS","Adherence","DM","Completed",38759,0,{"$f":"IF(J57=K57,H57,(IF(DATE(2012,8,31)<K57,DATE(2012,8,31),K57)-IF(DATE(2011,9,1)>J57,DATE(2011,9,1),J57))/30*H57)","v":0},"2011-09-01","2012-07-31","2012-04-30",null,12500,null,"2012-04-15",null,"9200  9197 9198  9199 ","Terming early due to funding out",null,6,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,"45,000 pts per year at 10 days)"]
["Bayer Diagnostics","TomR","Blood Glucose Monitoring w/o Messaging (National) and Breeze and Contour TS","Adherence","DM","Completed",246900,65621.3,631000,"2011-09-01","2012-07-31","2012-04-30",null,"103,000 ltrs",41628,"2012-04-15","Too Soon","9196","Terming early due to funding out",null,7,56690.400000000001,96742.599999999991,65621.299999999988,54420.299999999996,46349.8,44597,44385.4,24980.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Bayer Diagnostics","TomR","PSC Rebate Income","PSC","REB","Active",{"$f":"5000*12","v":60000},{"$f":"G59/12","v":5000},null,"2012-05-08","2014-04-30",{"$f":"K59","v":"2014-04-30"},null,null,null,null,null,null,null,null,82,null,null,null,null,null,null,null,null,null,null,15114.99,5000,5000,8000,5000,5000,5000,8000,8000,8000,8000,8000,8000,8000,null,null,0,0,0]
["Bayer Diagnostics",{"$f":"IF(A60=\"\",\"\",VLOOKUP(A60,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"????"},"Adheris - Contour","Adherence","DM","Active",null,null,null,"2012-12-28",null,null,null,null,null,null,null,null,null,null,128,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,614.79999999999995,4484.5599999999995,4867.4999999999991,8814.5999999999985,8588.0399999999991,8784.5099999999984,12010,9487.1999999999989,9111.9599999999991,null,null,0,0,0]
["Bayer Diagnostics",{"$f":"IF(A61=\"\",\"\",VLOOKUP(A61,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"????"},"Adheris - Contour CAP/nonCAP mailing","Other","DM","Completed - 1T",null,null,null,"2012-12-28",null,null,null,null,null,null,null,null,null,null,152,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136332.12,null,null,null,null,null,null,null,null,null,null,0,0,0]
["BMS",{"$f":"IF(A62=\"\",\"\",VLOOKUP(A62,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Plavix 90-D","90-Day","REB","Completed",325000,{"$f":"I62/2","v":162500},{"$f":"G62","v":325000},"2012-01-27","2012-03-19",{"$f":"K62","v":"2012-03-19"},null,null,null,null,null,"N/A","Started 2/1/12?",null,46,null,null,null,null,0,76000,46580.65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT62*AU62*1.2*0.87","v":0},{"$f":"AU62*0.975*AT62","v":0},{"$f":"AV62-AW62","v":0}]
["BMS",{"$f":"IF(A63=\"\",\"\",VLOOKUP(A63,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Plavix LOE Patient Communication","Other","DM","Completed",325000,325000,325000,"2012-04-06","2012-04-06",{"$f":"K63","v":"2012-04-06"},"N/A",null,null,null,null,null,null,null,57,null,null,null,null,null,null,null,320857.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["BMS",{"$f":"IF(A64=\"\",\"\",VLOOKUP(A64,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Plavix MPU","Education","MPU","Completed - 1T",0,0,0,"2012-05-14","2012-05-14","2012-05-14","NA",null,null,null,null,null,null,null,61,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Boehringer",{"$f":"IF(A65=\"\",\"\",VLOOKUP(A65,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Aggrenox","Adherence","DM","Completed",42000,1528.8,{"$f":"IF(J65=K65,H65,(IF(DATE(2012,8,31)<K65,DATE(2012,8,31),K65)-IF(DATE(2011,9,1)>J65,DATE(2011,9,1),J65))/30*H65)","v":18600.399999999998},"2010-11-10","2012-12-31",{"$f":"K65","v":"2012-12-31"},null,7200,3321,"2012-08-15","1.9 : 1 (6Mo)","1923-08-20","Contract with legal and BI",null,8,1430.1,1614.9,1528.8,1577.1000000000001,1541.4,1323,1501.5,2364.6,2263.8000000000002,1908.9,1816.5,1822.8000000000002,1810.2,1064.7,331.8,218.4,null,null,null,null,null,null,null,null,{"$f":"3000*5*2","v":30000},2.7,84564,78975.000000000015,5588.9999999999854]
["Boehringer",{"$f":"IF(A66=\"\",\"\",VLOOKUP(A66,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Pradaxa","Adherence","DM","Completed",328750,12749.1,{"$f":"IF(J66=K66,H66,(IF(DATE(2012,8,31)<K66,DATE(2012,8,31),K66)-IF(DATE(2011,9,1)>J66,DATE(2011,9,1),J66))/30*H66)","v":148739.5},"2011-09-16","2012-12-31","2012-12-31",null,null,2344,"2012-02-15","Too Soon","9213","CAP Reporting",null,9,8540.7000000000007,8689.8000000000011,12749.1,13150.2,12675.6,0,5363.4,9727.2000000000007,9198,8761.2000000000007,8754.9,8297.1,8202.6,8412.6,8038.8,4718.7,null,null,null,null,null,null,null,null,{"$f":"15000*20","v":300000},3.64,1140048,1064700,75348]
["Boehringer",{"$f":"IF(A67=\"\",\"\",VLOOKUP(A67,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Spiriva","Adherence","DM","Completed",282500,23442.3,{"$f":"IF(J67=K67,H67,(IF(DATE(2012,8,31)<K67,DATE(2012,8,31),K67)-IF(DATE(2011,9,1)>J67,DATE(2011,9,1),J67))/30*H67)","v":285214.64999999997},"2009-04-27","2012-12-31","2012-12-31",null,40000,110231,"2012-08-15","5.6 : 1 (7Mo)","1922-04-07",null,null,10,21260.400000000001,23906.400000000001,23442.3,24238.2,24483.9,7681.8,8828.4,38043.599999999999,44240.700000000004,40395.599999999999,38360.700000000004,37510.200000000004,37655.1,40372.5,40607.699999999997,26077.800000000003,null,null,null,null,null,null,null,null,{"$f":"45000*10","v":450000},6.05,2842290,2654437.5,187852.5,"(25,000 pts * 8 days)"]
["Boehringer",{"$f":"IF(A68=\"\",\"\",VLOOKUP(A68,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Combivent","Adherence","DM","Active",null,null,null,"2013-01-10",null,null,null,null,null,null,null,null,null,null,166,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1976.6399999999999,2217.8099999999995,4088.7,3913.4700000000003,6809.19,25086,24167.579999999998,22565.729999999996,null,null,{"$f":"AT68*AU68*1.2*0.87","v":0},{"$f":"AU68*0.975*AT68","v":0},{"$f":"AV68-AW68","v":0}]
["Boehringer","VanA","Adheris - Combivent MDI","Adherence","DM","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,206,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22693.17,5469,483.21,42.47999999999999]
["Boehringer",{"$f":"IF(A70=\"\",\"\",VLOOKUP(A70,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Tradjenta/Jentaduetto MD mailing","Other","DM","Completed - 1T",null,null,null,"2013-02-06","2013-04-01","2013-02-06","NA",null,null,null,null,null,null,null,197,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14038.5,null,null,null,null,null,null,{"$f":"AT70*AU70*1.2*0.87","v":0},{"$f":"AU70*0.975*AT70","v":0},{"$f":"AV70-AW70","v":0}]
["Boehringer",{"$f":"IF(A71=\"\",\"\",VLOOKUP(A71,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Tradjenta/Jentaduetto Patient mailing","Other","DM","Completed - 1T",null,null,null,"2013-02-06","2013-04-01","2013-02-06","NA",null,null,null,0,0,0,null,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9240]
["Boehringer",{"$f":"IF(A72=\"\",\"\",VLOOKUP(A72,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Pleio - Micardis","Adherence","GS","Active",5167,null,null,null,null,null,null,null,null,null,null,null,null,null,176,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20000,null,null,null,1143,1200,1350,63,null,null,{"$f":"AT72*AU72*1.2*0.87","v":0},{"$f":"AU72*0.975*AT72","v":0},{"$f":"AV72-AW72","v":0}]
["Boehringer",{"$f":"IF(A73=\"\",\"\",VLOOKUP(A73,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Pradaxa","Adherence","DM","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,185,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2449.3999999999996,4123.6499999999996,3934.95,4744,5024.6000000000004,5111.5499999999993,null,null,{"$f":"AT73*AU73*1.2*0.87","v":0},{"$f":"AU73*0.975*AT73","v":0},{"$f":"AV73-AW73","v":0}]
["Boehringer",{"$f":"IF(A74=\"\",\"\",VLOOKUP(A74,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Spiriva","Adherence","DM","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,186,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19723.109999999997,29622.719999999998,28727.099999999995,37647,37839.06,38516.97,null,null,{"$f":"AT74*AU74*1.2*0.87","v":0},{"$f":"AU74*0.975*AT74","v":0},{"$f":"AV74-AW74","v":0}]
["Boehringer","VanA","Pleio - Aggrenox","Adherence","GS","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,217,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,540,108]
["Covidien",{"$f":"IF(A76=\"\",\"\",VLOOKUP(A76,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Pennsaid RPh Alert","Education","MPU","Completed - 1T",25000,25000,{"$f":"G76","v":25000},{"$f":"K76","v":"2012-04-16"},"2012-04-16",{"$f":"K76","v":"2012-04-16"},"NA",null,null,null,null,null,"Published on 4/2/12",null,62,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Daiichi Sankyo",{"$f":"IF(A77=\"\",\"\",VLOOKUP(A77,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"90-Day - Benicar Family","90-Day","REB","Active",400000,{"$f":"G77/12","v":33333.333333333336},null,"2012-08-06","2014-07-31",{"$f":"K77","v":"2014-07-31"},null,null,null,null,null,null,"requires new baseline rates for year-2",null,96,null,null,null,null,null,null,null,null,null,null,null,null,null,6000,9000,9000,10000,10000,10000,20000,20000,20000,20000,20000,null,null,0,0,0]
["Daiichi Sankyo",{"$f":"IF(A78=\"\",\"\",VLOOKUP(A78,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"90-Day - Welchol Family","90-Day","REB","Active",200000,{"$f":"G78/12","v":16666.666666666668},null,"2012-08-06","2014-07-31",{"$f":"K78","v":"2014-07-31"},null,null,null,null,null,null,"requires new baseline rates for year-2",null,97,null,null,null,null,null,null,null,null,null,null,null,null,null,6000,9000,9000,10000,10000,10000,"(see above)","(see above)","(see above)",null,null,null,null,0,0,0,"(25,000 pts per 6 months * 7 days"]
["Daiichi Sankyo",{"$f":"IF(A79=\"\",\"\",VLOOKUP(A79,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Azor","Adherence","DM","Active",null,null,null,"2012-12-21",null,null,null,null,null,null,null,null,null,null,124,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45684,7522.35,2478.6000000000004,8098.2000000000007,4910.4000000000005,4251.6000000000004,5575,4564.8,4494.6000000000004,null,null,0,0,0]
["Daiichi Sankyo","VanA","Adheris - Benicar","Adherence","DM","Active",null,null,null,"2013-02-01",null,null,null,null,null,null,null,null,null,null,177,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38067.65,51916.960000000006,26651.530000000002,19724.370000000003,25371,20811.54,20676.270000000004,null,null,{"$f":"AT80*AU80*1.2*0.87","v":0},{"$f":"AU80*0.975*AT80","v":0},{"$f":"AV80-AW80","v":0}]
["Daiichi Sankyo",{"$f":"IF(A81=\"\",\"\",VLOOKUP(A81,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Benicar HCT","Adherence","DM","Active",null,null,null,"2012-11-22",null,null,null,null,null,null,null,null,null,null,125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74599.320000000007,82604.399999999994,6906.119999999999,16891.719999999998,41717.219999999987,29871.909999999996,21932.94,32484,24469.119999999995,24457.01,null,null,0,0,0]
["Daiichi Sankyo",{"$f":"IF(A82=\"\",\"\",VLOOKUP(A82,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Brovana","Adherence","DM","Active",null,null,null,"2012-12-19",null,null,null,null,null,null,null,null,null,null,126,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1289.92,2199.3599999999997,1380.5999999999997,1460.25,1180.5899999999999,971.72999999999979,1250,962.88,150.44999999999999,null,null,0,0,0]
["Daiichi Sankyo",{"$f":"IF(A83=\"\",\"\",VLOOKUP(A83,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Tribenzor","Adherence","DM","Active",null,null,null,"2012-12-12",null,null,null,null,null,null,null,null,null,null,144,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29104.2,20424.239999999998,10779.629999999997,11239.809999999998,6797.1699999999983,6736.619999999999,9180,7248.6999999999989,7426.8899999999994,null,null,0,0,0]
["Daiichi Sankyo",{"$f":"IF(A84=\"\",\"\",VLOOKUP(A84,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Welchol","Adherence","DM","Active",null,null,null,"2012-11-21",null,null,null,null,null,null,null,null,null,null,146,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86971.15,44405.599999999999,21044.25,20980.799999999999,25765.200000000004,15822.000000000004,13314.600000000002,19070,15940.799999999997,18010.8,null,null,0,0,0]
["Daiichi Sankyo","VanA","Adheris - Azor DN","Other","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,222,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29005.760000000002]
["Daiichi Sankyo",{"$f":"IF(A86=\"\",\"\",VLOOKUP(A86,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Edarbi/Edarbyclor CAP mailing","Other","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,187,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6626.88,null,null,null,null,null,null,null,{"$f":"AT86*AU86*1.2*0.87","v":0},{"$f":"AU86*0.975*AT86","v":0},{"$f":"AV86-AW86","v":0}]
["Daiichi Sankyo","JenL","Benicar - RPh EDU","Education","MPU","Completed - 1T",25000,25000,25000,"2013-02-25","2013-02-25","2013-02-25","NA",null,null,null,null,null,null,null,180,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,0,0,0]
["Daiichi Sankyo",{"$f":"IF(A88=\"\",\"\",VLOOKUP(A88,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Pleio - Welchol","Adherence","GS","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,189,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,559,6968,7891,8000,10751,6708,null,null,{"$f":"AT88*AU88*1.2*0.87","v":0},{"$f":"AU88*0.975*AT88","v":0},{"$f":"AV88-AW88","v":0}]
["Daiichi Sankyo",{"$f":"IF(A89=\"\",\"\",VLOOKUP(A89,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Hypertension Franchise GoodStart ","Adherence","GS","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,195,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72930,99099,99000,147498,64272,null,null,{"$f":"AT89*AU89*1.2*0.87","v":0},{"$f":"AU89*0.975*AT89","v":0},{"$f":"AV89-AW89","v":0}]
["Daiichi Sankyo",{"$f":"IF(A90=\"\",\"\",VLOOKUP(A90,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Azor Webkey Program","Adherence","DM","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,203,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,765,1857.5,2102.5,1300]
["DEY",{"$f":"IF(A91=\"\",\"\",VLOOKUP(A91,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"EpiPen &Jr EDU (MPU)","Education","MPU","Completed - 1T",25000,20000,{"$f":"H91","v":20000},"2011-09-30","2011-09-30",{"$f":"K91","v":"2011-09-30"},"NA",null,null,null,null,"N/A","Published on 9/30/11",null,36,0,0,20000,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["DEY",{"$f":"IF(A92=\"\",\"\",VLOOKUP(A92,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Adheris - EpiPen &Jr reminder mailing","Other","DM","Completed - 1T",null,null,null,"2012-11-28",null,null,null,null,null,null,null,null,null,null,150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,434807.43999999994,98546.64,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Edgemont","TomR","fluoxetine 60mg MPU","Education","MPU","Completed - 1T",25000,25000,25000,"2012-03-12","2012-04-16",{"$f":"K93","v":"2012-04-16"},"N/A",null,null,null,null,null,"Published 4/9/12",null,67,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Endo",{"$f":"IF(A94=\"\",\"\",VLOOKUP(A94,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Adheris - Fortesta Gel","Adherence","DM","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,201,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2277.4399999999996,5746.4,9421,7434.24,2986.7200000000003]
["Eisai",{"$f":"IF(A95=\"\",\"\",VLOOKUP(A95,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Belviq - RPh EDU","Education","MPU","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,212,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000]
["Forest",{"$f":"IF(A96=\"\",\"\",VLOOKUP(A96,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Namenda XR - RPh EDU","Education","MPU","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,211,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000]
["Galderma",{"$f":"IF(A97=\"\",\"\",VLOOKUP(A97,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Oracea","Adherence","DM","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,184,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5286.6,19916.420000000002,17474.259999999998,19179,12217.92,11162.380000000001,null,null,{"$f":"AT97*AU97*1.2*0.87","v":0},{"$f":"AU97*0.975*AT97","v":0},{"$f":"AV97-AW97","v":0}]
["Gilead",{"$f":"IF(A98=\"\",\"\",VLOOKUP(A98,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Truvada - Condoms","Other","Other","Active",0,null,null,"2012-10-25","2013-04-30","2013-04-30",null,null,null,null,null,null,"500,000 indirect revenue",null,109,null,null,null,null,null,null,null,null,null,null,null,null,null,44000,null,null,15532.56,6569.18,5007.0091999999995,6509.1,5024.42,5005.96,0,null,null,null,0,0,0]
["GSK",{"$f":"IF(A99=\"\",\"\",VLOOKUP(A99,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Advair Asthma","Adherence","DM","Completed",667920,40000,{"$f":"IF(J99=K99,H99,(IF(DATE(2012,8,31)<K99,DATE(2012,8,31),K99)-IF(DATE(2011,9,1)>J99,DATE(2011,9,1),J99))/30*H99)","v":161333.33333333334},"2011-02-15","2011-12-31","2012-12-31",1,290400,34517,null,null,"1923-06-01","GSK review 5-29",null,11,38442.449999999997,46194.55,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["GSK",{"$f":"IF(A100=\"\",\"\",VLOOKUP(A100,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Advair COPD","Adherence","DM","Completed",0,0,{"$f":"IF(J100=K100,H100,(IF(DATE(2012,8,31)<K100,DATE(2012,8,31),K100)-IF(DATE(2011,9,1)>J100,DATE(2011,9,1),J100))/30*H100)","v":0},"2011-05-03","2011-12-31","2012-12-31",1,237600,23893,null,null,"1923-06-02","GSK review 5-29",null,12,0,0,15168.4,0,0,0,null,null,null,null,null,null,null,null,7918.9,23207,null,null,null,null,null,null,null,null,null,null,0,0,0]
["GSK",{"$f":"IF(A101=\"\",\"\",VLOOKUP(A101,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Flovent HFA","Adherence","DM","Completed",575378,46729.8,{"$f":"IF(J101=K101,H101,(IF(DATE(2012,8,31)<K101,DATE(2012,8,31),K101)-IF(DATE(2011,9,1)>J101,DATE(2011,9,1),J101))/30*H101)","v":188476.86000000002},"2011-04-13","2011-12-31","2012-12-31",1,244841,33482,null,null,"1923-07-11","GSK review TBD",null,13,35198.800000000003,43609.8,46729.8,42918.200000000004,5077.8,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["GSK",{"$f":"IF(A102=\"\",\"\",VLOOKUP(A102,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Lovaza","Adherence","DM","Completed",201240,15124.2,{"$f":"IF(J102=K102,H102,(IF(DATE(2012,8,31)<K102,DATE(2012,8,31),K102)-IF(DATE(2011,9,1)>J102,DATE(2011,9,1),J102))/30*H102)","v":61000.94},"2011-05-03","2011-12-31","2012-12-31",1,77400,18092,null,null,"1924-07-07","GSK review June",null,14,15113.8,16192.800000000001,15124.2,17368,18207.8,8689.2000000000007,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["GSK",{"$f":"IF(A103=\"\",\"\",VLOOKUP(A103,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Vesicare","Adherence","DM","Completed",223080,17843.8,{"$f":"H103*7","v":124906.59999999999},"2011-03-20","2012-03-27","2012-03-27",1,85800,31847,null,null,"1924-05-06","Existing only due to PI Issue",null,15,16021.2,16731,17843.8,16751.800000000003,10350.6,2818.4,1081.5999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"25000*8","v":200000},5.09,1062792,992550,70242]
["GSK",{"$f":"IF(A104=\"\",\"\",VLOOKUP(A104,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Biotene  MPU ","Education","MPU","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,227,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000]
["IMS (was SDI)","GregL","Hypertension","Clinical Trials","DM","Completed - 1T",{"$f":"28495*1.25","v":35618.75},35618.75,35618.75,"2012-05-16","2012-05-16",{"$f":"K105","v":"2012-05-16"},"NA",null,null,null,null,null,null,null,71,null,null,null,null,null,null,null,null,35618.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["J&J (Janssen)",{"$f":"IF(A106=\"\",\"\",VLOOKUP(A106,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Nucynta - RPH EDU (MPU)","Education","MPU","Completed - 1T",25000,25000,{"$f":"H106","v":25000},"2011-11-11","2011-11-17",{"$f":"K106","v":"2011-11-17"},"NA",null,null,null,null,"N/A",null,null,36,0,0,25000,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["J&J (Janssen)",{"$f":"IF(A107=\"\",\"\",VLOOKUP(A107,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"90-Day - Aciphex (also Eisai)","90-Day","REB","Active",167000,{"$f":"G107/12","v":13916.666666666666},{"$f":"H107*2","v":27833.333333333332},"2012-11-01","2013-12-31",{"$f":"K107","v":"2013-12-31"},null,null,null,null,null,null,null,null,117,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64422.48,20000,20000,20000,13000,13000,13000,13000,null,null,0,0,0]
["J&J (Janssen)",{"$f":"IF(A108=\"\",\"\",VLOOKUP(A108,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Prezista RPh Alert","Education","MPU","Completed - 1T",25000,25000,25000,"2012-11-26","2012-11-26","2012-11-26",null,null,null,null,null,null,null,null,159,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,0,0,0]
["LEO Pharma",{"$f":"IF(A109=\"\",\"\",VLOOKUP(A109,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"????"},"Taclonex RPh Alert","Education","MPU","Completed - 1T",25000,25000,25000,null,null,null,null,null,null,null,null,null,null,null,161,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Lilly",{"$f":"IF(A110=\"\",\"\",VLOOKUP(A110,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Cymbalta","Adherence","DM","Completed",600000,32060.600000000002,{"$f":"IF(J110=K110,H110,(IF(DATE(2012,8,31)<K110,DATE(2012,8,31),K110)-IF(DATE(2011,9,1)>J110,DATE(2011,9,1),J110))/30*H110)","v":96181.8},"2011-02-04","2011-11-30","2011-11-30","NA",null,44708,null,"6.4 : 1 (12Mo)","1920-07-06","Will not be renewed",null,16,45726.2,48352.200000000004,32060.600000000002,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"7*1.3*25000","v":227500},4.97,1180424.7,1102408.125,78016.574999999953]
["Lilly",{"$f":"IF(A111=\"\",\"\",VLOOKUP(A111,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Humalog","Adherence","DM","Completed",380000,6546.8,{"$f":"H111*11","v":72014.8},"2010-06-17","2011-12-31","2012-12-31",0.5,null,null,null,"6.3 : 1 (P12MoF6)","1923-02-01","Is this being renewed",null,17,0,2854.8,6546.8,7547.8,8015.8,6671.6,5860.4,6354.4000000000005,null,null,null,null,null,22168.399999999998,5077.8,7092.8,179.4,null,null,null,null,null,null,null,null,null,0,0,0]
["Lilly",{"$f":"IF(A112=\"\",\"\",VLOOKUP(A112,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Strattera","Adherence","DM","Completed",250000,8338.1866589013462,{"$f":"IF(J112=K112,H112,(IF(DATE(2012,8,31)<K112,DATE(2012,8,31),K112)-IF(DATE(2011,9,1)>J112,DATE(2011,9,1),J112))/30*H112)","v":33630.686190902095},"2011-02-20","2011-12-31",{"$f":"K112","v":"2011-12-31"},"NA",null,8217,null,"5 : 1 (p12MoF6)","1924-04-16","Current Program suspended due to lack of PI's\nNeed Estimated Cost",null,18,8093.79,8387.5865798614723,8338.1866589013462,3510,0,0,3286.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Lilly",{"$f":"IF(A113=\"\",\"\",VLOOKUP(A113,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Effient (program never started)","Adherence","DM","Completed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20000,null,null,null,null,null,null,null,null,null,{"$f":"AT113*AU113*1.2*0.87","v":0},{"$f":"AU113*0.975*AT113","v":0},{"$f":"AV113-AW113","v":0}]
["Lilly",{"$f":"IF(A114=\"\",\"\",VLOOKUP(A114,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Adheris - Effient","Adherence","DM","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,183,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4419.75,31818.62,26868.04,29566,17844.05,16216.410000000002,null,null,{"$f":"AT114*AU114*1.2*0.87","v":0},{"$f":"AU114*0.975*AT114","v":0},{"$f":"AV114-AW114","v":0}]
["Lilly",{"$f":"IF(A115=\"\",\"\",VLOOKUP(A115,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Adheris - Glucagon DN","Other","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,215,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30934.080000000002]
["Lilly",{"$f":"IF(A116=\"\",\"\",VLOOKUP(A116,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Adheris - Effient CAP/NoCAP mailing","Other","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,224,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12867.75]
["Meda",{"$f":"IF(A117=\"\",\"\",VLOOKUP(A117,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Dymista  MPU","Education","MPU","Completed - 1T",25000,25000,25000,"2012-09-24","2012-10-08",{"$f":"K117","v":"2012-10-08"},null,null,null,null,null,null,null,null,110,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Medicis",{"$f":"IF(A118=\"\",\"\",VLOOKUP(A118,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Solodyn/Ziana Cash Pilot","Other","Other","Active",{"$f":"150000+5000*9","v":195000},null,null,"2012-10-23","2013-09-30",null,null,null,null,null,null,null,null,null,107,null,null,null,null,null,null,null,null,null,null,null,null,null,145000,null,null,null,0,1666,1666,1666,1666,1666,1666,null,null,{"$f":"AT118*AU118*1.2*0.87","v":0},{"$f":"AU118*0.975*AT118","v":0},{"$f":"AV118-AW118","v":0}]
["Medicis",{"$f":"IF(A119=\"\",\"\",VLOOKUP(A119,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Adheris - Solodyn reminder mailing","Other","DM","Completed - 1T",null,null,null,"2012-12-31",null,null,null,null,null,null,null,null,null,null,153,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8816,3332,null,null,null,null,null,null,null,null,null,0,0,0]
["Merck",{"$f":"IF(A120=\"\",\"\",VLOOKUP(A120,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Pleio - Januvia Family","Adherence","GS","Active",183750,22968.75,183750,"2012-03-12","2013-02-20",{"$f":"K120","v":"2013-02-20"},null,null,null,null,null,null,null,null,53,null,null,null,null,null,null,9750,14500,30544.5,30224.25,29373.75,28502.25,27541.5,26250,31463.25,30450,32949,32277,32287.5,30471,24654,25000,8211,13912.5,null,null,0,0,0]
["Merck",{"$f":"IF(A121=\"\",\"\",VLOOKUP(A121,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Zetia & Zetia ZR","Adherence","DM","Completed",456500,12693.300000000001,{"$f":"IF(J121=K121,H121,(IF(DATE(2012,8,31)<K121,DATE(2012,8,31),K121)-IF(DATE(2011,9,1)>J121,DATE(2011,9,1),J121))/30*H121)","v":51196.310000000005},"2010-08-21","2011-12-31",{"$f":"K121","v":"2011-12-31"},null,null,26276,"2011-10-15",null,"8338 & 8339","Is this Still Active - was it renewed",null,19,11982.6,12213.6,12693.300000000001,12883.050000000001,12762.6,12573.75,12812.85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Merck",{"$f":"IF(A122=\"\",\"\",VLOOKUP(A122,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Asmanex","Adherence","DM","Active",null,null,null,"2012-11-21",null,null,null,null,null,null,null,null,null,null,123,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12017.5,41718.49,27370.639999999999,22223.739999999998,28007.979999999992,23181.62,20083.14,23755,16696.68,15618.679999999997,null,null,0,0,0]
["Merck",{"$f":"IF(A123=\"\",\"\",VLOOKUP(A123,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Dulera","Adherence","DM","Active",null,null,null,"2012-12-07",null,null,null,null,null,null,null,null,null,null,130,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22093.4,29532.399999999998,22256,28203.199999999997,24947.200000000001,21408,27550,19830.399999999998,19251.2,null,null,0,0,0]
["Merck",{"$f":"IF(A124=\"\",\"\",VLOOKUP(A124,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Janumet","Adherence","DM","Active",null,null,null,"2013-11-16",null,null,null,null,null,null,null,null,null,null,132,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11016,10463.040000000001,7393.68,451.21999999999991,420.4199999999999,4860.59,3593.5200000000004,5889,7117.81,7917.9800000000005,null,null,0,0,0]
["Merck",{"$f":"IF(A125=\"\",\"\",VLOOKUP(A125,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Janumet XR","Adherence","DM","Active",null,null,null,"2012-11-16",null,null,null,null,null,null,null,null,null,null,133,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3833.06,518.32000000000005,599.82999999999993,5325.880000000001,5797.6100000000006,368.05999999999995,328.02,1263,2063.5999999999995,2684.22,null,null,0,0,0]
["Merck",{"$f":"IF(A126=\"\",\"\",VLOOKUP(A126,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Januvia","Adherence","DM","Active",null,null,null,"2012-11-20",null,null,null,null,null,null,null,null,null,null,134,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77656.039999999994,19990.849999999999,15664.55,11265.099999999999,13002.219999999998,11477.619999999999,8044.9599999999991,14048,17924.059999999998,20428.099999999999,null,null,0,0,0]
["Merck",{"$f":"IF(A127=\"\",\"\",VLOOKUP(A127,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Juvisync","Adherence","DM","Active",null,null,null,"2012-12-01",null,null,null,null,null,null,null,null,null,null,135,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48.07,33.44,16.939999999999998,20.019999999999996,15.399999999999999,35.419999999999995,33,36.959999999999994,35.42,null,null,0,0,0]
["Merck",{"$f":"IF(A128=\"\",\"\",VLOOKUP(A128,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Nasonex","Adherence","DM","Active",null,null,null,"2012-11-21",null,null,null,null,null,null,null,null,null,null,139,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120401.61,197996.15,180321.02,119422.38,132895.83999999997,115926.58,95832.659999999989,104456,76710.479999999981,13260.939999999999,null,null,0,0,0]
["Merck",{"$f":"IF(A129=\"\",\"\",VLOOKUP(A129,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Saphris","Adherence","DM","Active",null,null,null,"2012-12-01",null,null,null,null,null,null,null,null,null,null,141,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15302.98,8504.2099999999991,5551.7,6095.3199999999988,5199.0399999999991,2500.9599999999996,3776,3501.9599999999996,3361.8199999999997,null,null,0,0,0]
["Merck",{"$f":"IF(A130=\"\",\"\",VLOOKUP(A130,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Vytorin","Adherence","DM","Active",null,null,null,"2012-11-16",null,null,null,null,null,null,null,null,null,null,145,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53660.88,90793.44,39847.68,31478.720000000005,32227.370000000003,28963.900000000009,19642,22322,16660.280000000002,17349.36,null,null,0,0,0]
["Merck",{"$f":"IF(A131=\"\",\"\",VLOOKUP(A131,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Zetia","Adherence","DM","Active",null,null,null,"2012-11-10",null,null,null,null,null,null,null,null,null,null,147,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72084.100000000006,104840.67,64547.280000000006,48900.53,53622.66,48089.090000000004,34553.820000000007,39283,30144.030000000006,34091.750000000007,null,null,0,0,0]
["Merck","VanA","Pleio - Liptruzet","Adherence","GS","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,218,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,866.25,420]
["Merck","VanA","Pleio - Vytorin","Adherence","GS","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,219,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5066.25,3496.5]
["Merck","VanA","Pleio - Zetia","Adherence","GS","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19603.5,9612.75]
["Mylan Specialty",{"$f":"IF(A135=\"\",\"\",VLOOKUP(A135,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"EpiPen Well Experience Pilot Program","Marketing","Other","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,190,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15000,null,null,null,null,null,null,null,{"$f":"AT135*AU135*1.2*0.87","v":0},{"$f":"AU135*0.975*AT135","v":0},{"$f":"AV135-AW135","v":0}]
["Mylan Specialty",{"$f":"IF(A136=\"\",\"\",VLOOKUP(A136,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Adheris - EpiPen &Jr CAP/NoCAP mailing","Other","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,225,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127049.52]
["Nipro","TomR","PSC Rebate Income","PSC","REB","Active",{"$f":"H137*12","v":180000},{"$f":"AH137","v":15000},null,"2012-03-27","2014-03-14",{"$f":"K137","v":"2014-03-14"},null,null,null,null,null,null,null,null,83,null,null,null,null,null,null,null,null,null,null,46482.83,15000,15000,20000,15000,15000,15000,20000,20000,20000,20000,20000,20000,20000,null,null,0,0,0]
["Novartis","Jen L","Arcapta RPh Alert","Education","MPU","Completed - 1T",25000,25000,25000,"2012-03-26","2012-03-26",{"$f":"K138","v":"2012-03-26"},"N/A",null,null,null,null,null,"Published on 3/26/12",null,66,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis",{"$f":"IF(A139=\"\",\"\",VLOOKUP(A139,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"CV products 30 to 90 day","90-Day","PCC","Completed",451000,6000,120000,"2011-06-15","2012-01-15",{"$f":"K139","v":"2012-01-15"},null,75300,8349,null,null,"1924-12-12","Non Diovan only after 11/30/11",null,20,26400,41448,30384,5400,7080,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis",{"$f":"IF(A140=\"\",\"\",VLOOKUP(A140,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Diovan & HCT 90D Rebate Program","90-Day","REB","Completed",{"$f":"130000*10","v":1300000},{"$f":"G140/10","v":130000},{"$f":"IF(J140=K140,H140,(IF(DATE(2012,8,31)<K140,DATE(2012,8,31),K140)-IF(DATE(2011,9,1)>J140,DATE(2011,9,1),J140))/30*H140)","v":1157000},"2011-12-08","2012-09-30","2012-09-30","NA",null,null,null,null,"N/A",null,null,39,0,0,0,130000,130000,130000,130000,113000,100000,100000,100000,100000,100000,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis",{"$f":"IF(A141=\"\",\"\",VLOOKUP(A141,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Diovan HCT","Adherence","DM","Completed",324137,27039.100000000002,{"$f":"IF(J141=K141,H141,(IF(DATE(2012,8,31)<K141,DATE(2012,8,31),K141)-IF(DATE(2011,9,1)>J141,DATE(2011,9,1),J141))/30*H141)","v":81117.3},"2011-04-06","2011-11-30",null,1,44100,25383,null,null,"1924-07-25",null,null,21,32352.45,35579.000000000007,27039.100000000002,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis","JenL","Diovan/Diovan HTC LOE","Other","Other","Completed - 1T",348000,348000,348000,"2012-06-15","2012-06-15","2012-06-15","N/A",null,null,null,null,null,"waiting on internal communiciation",null,75,null,null,null,null,null,null,null,null,null,311280.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis",{"$f":"IF(A143=\"\",\"\",VLOOKUP(A143,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Exelon - RPh EDU","Education","MPU","Completed - 1T",25000,25000,25000,"2012-10-29","2012-10-29","2012-10-29","NA",null,null,null,null,null,null,null,179,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,{"$f":"AT143*AU143*1.2*0.87","v":0},{"$f":"AU143*0.975*AT143","v":0},{"$f":"AV143-AW143","v":0}]
["Novartis",{"$f":"IF(A144=\"\",\"\",VLOOKUP(A144,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"90-Day - Exforge Family","90-Day","REB","Active",300000,{"$f":"G144/12","v":25000},{"$f":"H144*4","v":100000},"2012-04-25","2013-12-31",{"$f":"K144","v":"2013-12-31"},null,null,null,null,null,null,null,null,69,null,null,null,null,null,null,null,null,20000,20000,20000,20000,20000,16000,20000,20000,16000,16000,16000,16000,16000,16000,16000,16000,null,null,0,0,0]
["Novartis",{"$f":"IF(A145=\"\",\"\",VLOOKUP(A145,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Exforge/Exforge HCT","Adherence","DM","Completed",277000,{"$f":"G145/12","v":23083.333333333332},{"$f":"H145*9","v":207750},"2012-03-12","2012-09-30","2012-09-30",null,null,null,null,null,"9353,9354,9394,9395",null,null,41,0,0,0,0,0,0,11833,6749.2,9237.85,9623.25,10243.65,10095.6,10253.050000000001,6786.8,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis",{"$f":"IF(A146=\"\",\"\",VLOOKUP(A146,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"LCQ908 CV Risk CTR pilot mail/Catalina","Clinical Trials","DM","Completed - 1T",6000,6000,6000,"2012-07-29","2012-07-29","2012-07-29","N/A",null,null,null,null,null,null,null,76,null,null,null,null,null,null,null,null,null,null,1750,1750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis","TomR","COPD Registry Data","Clinical Trials","Data","Completed - 1T",4000,4000,4000,"2012-10-15",{"$f":"J147","v":"2012-10-15"},"2012-10-15",null,null,null,null,null,null,null,null,99,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis","TomR","RA AIN Data","Clinical Trials","Data","Completed - 1T",20000,4000,4000,"2012-10-15","2012-10-15","2012-10-15",null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis","TomR","COPD Low Dose Data","Clinical Trials","Data","Completed - 1T",20000,4000,4000,"2012-10-15","2012-10-15","2012-10-15",null,null,null,null,null,null,null,null,101,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis",{"$f":"IF(A150=\"\",\"\",VLOOKUP(A150,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"COPD NVA-QVA Low Dose","Clinical Trials","Data","Completed - 1T",20000,{"$f":"G150","v":20000},20000,"2012-11-15","2012-11-15","2012-11-15",null,null,null,null,null,null,null,null,114,null,null,null,null,null,null,null,null,null,null,null,null,null,20000,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis",{"$f":"IF(A151=\"\",\"\",VLOOKUP(A151,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"RA AIN-F Study Data","Clinical Trials","Data","Completed - 1T",20000,20000,20000,"2012-11-15","2012-11-15","2012-11-15",null,null,null,null,null,null,null,null,115,null,null,null,null,null,null,null,null,null,null,null,null,null,20000,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis",{"$f":"IF(A152=\"\",\"\",VLOOKUP(A152,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"COPD Registry Data","Clinical Trials","Data","Completed - 1T",4000,4000,4000,"2012-11-15","2012-11-15","2012-11-15",null,null,null,null,null,null,null,null,116,null,null,null,null,null,null,null,null,null,null,null,null,null,4000,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis",{"$f":"IF(A153=\"\",\"\",VLOOKUP(A153,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Adheris - Exforge &HCT Cap/nonCAP mailing","Other","DM","Completed - 1T",null,null,null,"2012-12-21",null,null,null,null,null,null,null,null,null,null,151,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40102.11,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novartis","JenL","Exforge & HCT CAP/nonCAP mailing","Other","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,216,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40102.11]
["Novo Nordisk",{"$f":"IF(A155=\"\",\"\",VLOOKUP(A155,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Levemir Flexpen GoodStart","Adherence","GS","Completed",337315,23244,{"$f":"IF(J155=K155,H155,(IF(DATE(2012,8,31)<K155,DATE(2012,8,31),K155)-IF(DATE(2011,9,1)>J155,DATE(2011,9,1),J155))/30*H155)","v":282802},"2011-07-26","2012-12-31","2013-12-31",null,8085,1434,"2012-02-28",null,"1924-05-27","In renewal",null,22,32283,28704,23244,30966,29952,27924,39975,25311,27339,23127,24882,21216,19890,19500,21255,11193,0,null,null,null,null,null,null,null,null,null,0,0,0]
["Novo Nordisk",{"$f":"IF(A156=\"\",\"\",VLOOKUP(A156,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Levemir Vial (all) &\nFlexpen NNTT (Vial only after 11/2011)","Adherence","DM","Completed",204500,17810,{"$f":"9685+7050","v":16735},"2009-11-24","2011-12-31","2012-01-05",0,19320,63127,null,null,"9193 &\n9194",null,null,23,{"$f":"9685+7050","v":16735},0,{"$f":"17810+13440","v":31250},{"$f":"6632.5+9100","v":15732.5},12682.5,7710,4607.5,1347.5,2225,1732.5,1600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novo Nordisk",{"$f":"IF(A157=\"\",\"\",VLOOKUP(A157,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Novolog Flexpen GoodStart (NTT)","Adherence","GS","Completed",327760,33540,{"$f":"IF(J157=K157,H157,(IF(DATE(2012,8,31)<K157,DATE(2012,8,31),K157)-IF(DATE(2011,9,1)>J157,DATE(2011,9,1),J157))/30*H157)","v":408070},"2011-06-17","2012-12-31","2013-12-31",null,7840,{"$f":"1362+1095+1074","v":3531},"2012-01-31",null,"1924-10-13","In renewal",null,24,29796,32799,33540,37908,39663,42393,28275,38766,37869,31629,31902,25272,22737,21450,34710,19227,0,null,null,null,null,null,null,null,null,null,{"$f":"AT157*AU157*1.2*0.87","v":0},{"$f":"AU157*0.975*AT157","v":0},{"$f":"AV157-AW157","v":0}]
["Novo Nordisk",{"$f":"IF(A158=\"\",\"\",VLOOKUP(A158,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Novolog Flexpen NNTT","Adherence","DM","Completed",357500,6507.5,6005,"2010-08-06","2011-09-30",{"$f":"K158","v":"2011-09-30"},0,50000,40323,null,null,"1923-03-13",null,null,25,6005,0,6507.5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novo Nordisk",{"$f":"IF(A159=\"\",\"\",VLOOKUP(A159,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"PSC Rebate - Preferred Insulin","PSC","REB","Active",{"$f":"H159*12","v":1002892.4849999986},83574.373749999882,{"$f":"G159*10/12","v":835743.73749999888},"2011-10-01","2012-12-31","2013-12-31",null,null,null,null,null,"N/A",null,null,26,0,72960,83574.373749999882,83500,83500,83500,83500,83500,120000,120000,120000,120000,120000,130000,120000,120000,140000,140000,140000,140000,150000,150000,150000,150000,null,null,0,0,0]
["Novo Nordisk",{"$f":"IF(A160=\"\",\"\",VLOOKUP(A160,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Victoza injection training","RPh Service","INJ TR","Active",876600,32700,{"$f":"IF(J160=K160,H160,(IF(DATE(2012,8,31)<K160,DATE(2012,8,31),K160)-IF(DATE(2011,9,1)>J160,DATE(2011,9,1),J160))/30*H160)","v":397850},"2011-05-02","2012-12-31","2013-12-31",null,27000,5203,"2012-02-15",null,"N/A",null,null,27,49200,33504,32700,32700,40524,41892,46800,41604,48024,46152,48708,49908,48000,44868,55668,23892,50400,47844,53376,48240,67963.5,58818.6,40584,55589,null,null,0,0,0]
["Novo Nordisk","MaryT","Victoza Enhancements","Adherence","DM","Completed - 1T",0,0,0,"2012-11-01","2012-12-31","2013-12-31",null,null,null,null,null,null,null,null,112,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Novo Nordisk",{"$f":"IF(A162=\"\",\"\",VLOOKUP(A162,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Pleio - Levemir","Adherence","GS","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,194,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44109,18356,20000,null,5500,null,null,{"$f":"AT162*AU162*1.2*0.87","v":0},{"$f":"AU162*0.975*AT162","v":0},{"$f":"AV162-AW162","v":0}]
["Pfizer",{"$f":"IF(A163=\"\",\"\",VLOOKUP(A163,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Chantix","Adherence","DM","Completed",300000,12228.050000000001,{"$f":"IF(J163=K163,H163,(IF(DATE(2012,8,31)<K163,DATE(2012,8,31),K163)-IF(DATE(2011,9,1)>J163,DATE(2011,9,1),J163))/30*H163)","v":39537.361666666671},"2011-05-22","2011-12-07",{"$f":"K163","v":"2011-12-07"},"NA",55000,56840,null,null,"1924-07-05",null,null,28,59742.6,57882.850000000006,12228.050000000001,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Pfizer",{"$f":"IF(A164=\"\",\"\",VLOOKUP(A164,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Geodon LOE mailing","Other","Other","Completed - 1T",49000,49000,49000,{"$f":"K164","v":"2012-03-02"},"2012-03-02",{"$f":"K164","v":"2012-03-02"},"NA",null,null,null,null,null,null,null,63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Pfizer",{"$f":"IF(A165=\"\",\"\",VLOOKUP(A165,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Lipitor 30 to 90 day","90-Day","REB","Completed",18000,13884,18000,"2011-09-07","2011-11-30","2011-11-22","NA",null,611,null,null,"1925-04-11","Enrollment ended 11/5/11;calls ended 11/22/11",null,29,0,18816,13884,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Pfizer","JenL","Lipitor LOE - Pt Edu","Other","Other","Completed - 1T",1000000,887516,887516,"2011-11-01","2011-11-30","2011-11-30","NA","2813-07-11","2813-07-11","NA","NA","N/A","Mailing completed 11/29 & 11/30",null,38,0,0,887516,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Pfizer",{"$f":"IF(A167=\"\",\"\",VLOOKUP(A167,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Lipitor/Detrol LA/Lyrica - NJ, OK-C","RPh Service","ADH","Completed",0,0,{"$f":"IF(J167=K167,H167,(IF(DATE(2012,8,31)<K167,DATE(2012,8,31),K167)-IF(DATE(2011,9,1)>J167,DATE(2011,9,1),J167))/30*H167)","v":0},"2010-08-10","2011-12-31","2011-12-31",0,null,null,null,null,"N/A","Is this termed?",null,30,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Pfizer",{"$f":"IF(A168=\"\",\"\",VLOOKUP(A168,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Pleio - Lipitor","Adherence","GS","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23097.5,19315,25487.5,8102.5,4150,2477.5,4030,3652.5,400,0,null,null,0,0,0]
["Pfizer",{"$f":"IF(A169=\"\",\"\",VLOOKUP(A169,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Adheris - Celebrex","Adherence","DM","Active",null,null,null,"2012-11-20",null,null,null,null,null,null,null,null,null,null,127,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10870.6,43690.51,53063.719999999994,41127.599999999991,50246.639999999992,45168.689999999995,30744.089999999997,41942,33605.399999999994,31716.749999999996,null,null,0,0,0]
["Pfizer",{"$f":"IF(A170=\"\",\"\",VLOOKUP(A170,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Adheris - Detrol LA","Adherence","DM","Active",null,null,null,"2012-11-22",null,null,null,null,null,null,null,null,null,null,129,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1304.02,6517.84,9846.82,7946.369999999999,10810.619999999997,9030.5099999999984,7823.25,10931,8538.0299999999988,8659.4399999999987,null,null,0,0,0]
["Pfizer",{"$f":"IF(A171=\"\",\"\",VLOOKUP(A171,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Adheris - Lyrica","Adherence","DM","Active",null,null,null,"2012-12-29",null,null,null,null,null,null,null,null,null,null,137,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2316.02,57313.340000000004,73316.42,99259.92,91951.24,58768.479999999996,76480,74108.52,77743.28,null,null,0,0,0]
["Pfizer",{"$f":"IF(A172=\"\",\"\",VLOOKUP(A172,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Adheris - Toviaz","Adherence","DM","Active",null,null,null,"2012-12-01",null,null,null,null,null,null,null,null,null,null,143,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22362.7,20062.019999999997,12424.859999999999,11787.029999999997,9769.2299999999977,7789.0499999999993,10243,8158.4099999999989,8467.9199999999983,null,null,0,0,0]
["Pfizer",{"$f":"IF(A173=\"\",\"\",VLOOKUP(A173,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Chantix Surround Sound","Marketing","Other","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,181,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1132852.5,614631,0,973813.5,null,null,null,null,{"$f":"AT173*AU173*1.2*0.87","v":0},{"$f":"AU173*0.975*AT173","v":0},{"$f":"AV173-AW173","v":0}]
["Salix",{"$f":"IF(A174=\"\",\"\",VLOOKUP(A174,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Pleio - Apriso","Adherence","GS","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,202,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3198,3500,3120,2288]
["Salix",{"$f":"IF(A175=\"\",\"\",VLOOKUP(A175,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Pleio - Xifaxan","Adherence","GS","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,204,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1950,2000,1872,1157]
["Sanofi Aventis",{"$f":"IF(A176=\"\",\"\",VLOOKUP(A176,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Apidra Shortage - Pt Edu","Education","Other","Completed - 1T",25000,25000,{"$f":"IF(J176=K176,H176,(IF(DATE(2012,8,31)<K176,DATE(2012,8,31),K176)-IF(DATE(2011,9,1)>J176,DATE(2011,9,1),J176))/30*H176)","v":25000},"2011-10-20","2011-10-20",{"$f":"K176","v":"2011-10-20"},"NA",null,null,null,null,"N/A",null,null,31,0,24272.5,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,20877.5,null,null,null,null,null,null,null,0,0,0]
["Sanofi Aventis",{"$f":"IF(A177=\"\",\"\",VLOOKUP(A177,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Apidra Vial NTT RPH EDUC - FREE","Education","Other","Completed - 1T",0,0,0,"2011-12-13","2011-12-13",{"$f":"K177","v":"2011-12-13"},"NA",null,null,null,null,"N/A",null,null,40,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Sanofi Aventis",{"$f":"IF(A178=\"\",\"\",VLOOKUP(A178,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Lantus Inj Training","RPh Service","INJ TR","Active",1200000,100000,{"$f":"H178*9","v":900000},"2011-11-23","2012-11-13","2013-11-13",null,null,null,"2012-02-15",null,"N/A",null,null,37,0,0,0,{"$f":"94236+30000","v":124236},94200,284268,189600,152388,199824,195672,199032,202968,190000,190440,213636,182916,184800,234252,224364,201048,221160,139728,99068,null,null,null,0,0,0]
["Sanofi Aventis",{"$f":"IF(A179=\"\",\"\",VLOOKUP(A179,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Lantus IVR","Adherence","IVR","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,196,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37183.71,4109.5600000000004,3899.7200000000003,null,null,null,null,{"$f":"AT179*AU179*1.2*0.87","v":0},{"$f":"AU179*0.975*AT179","v":0},{"$f":"AV179-AW179","v":0}]
["Sanofi Aventis",{"$f":"IF(A180=\"\",\"\",VLOOKUP(A180,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Renvela/Renagel","Adherence","DM","Active",null,null,null,"2013-01-03",null,null,null,null,null,null,null,null,null,null,169,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,850.2,886.6,1060.8,954.2,7011.4,46340.6,8473.7999999999993,7350.4,null,null,{"$f":"AT180*AU180*1.2*0.87","v":0},{"$f":"AU180*0.975*AT180","v":0},{"$f":"AV180-AW180","v":0}]
["Sanofi Aventis",{"$f":"IF(A181=\"\",\"\",VLOOKUP(A181,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Sklice - RPh EDU","Education","MPU","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,175,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,{"$f":"AT181*AU181*1.2*0.87","v":0},{"$f":"AU181*0.975*AT181","v":0},{"$f":"AV181-AW181","v":0}]
["Santarus",{"$f":"IF(A182=\"\",\"\",VLOOKUP(A182,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"????"},"Uceris MPU","Education","MPU","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,192,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,{"$f":"AT182*AU182*1.2*0.87","v":0},{"$f":"AU182*0.975*AT182","v":0},{"$f":"AV182-AW182","v":0}]
["SDI","GregL","Actos (REMS) #1, #2","Education","REMS","Completed - 1T",19000,9500,null,"2011-11-14","2011-11-14","2011-11-14","NA",null,null,null,null,"N/A","Mailing #1 - 11/14, Mailing #2 - 11/29",null,198,0,0,9500,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["SDI","GregL","Axiron (REMS)","Education","REMS","Completed - 1T",10000,10000,10000,"2012-02-10","2012-02-10","2012-02-10","NA",null,null,"N/A",null,"N/A",null,null,44,0,0,0,0,0,10000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["SDI","GregL","Forteo REMS","Education","REMS","Completed - 1T",11000,11000,11000,"2012-04-06",{"$f":"J185","v":"2012-04-06"},"2013-01-01","NA",null,null,null,null,null,null,null,56,null,null,null,null,null,null,null,11000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["SDI","GregL","Opioid Induced Constipation CTR wave 1","Clinical Trials","DM","Completed - 1T",30625,30625,30625,"2012-02-14","2012-04-30","2012-02-14","NA",null,null,null,null,null,null,null,49,null,null,null,null,null,30625,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["SDI","GregL","Opioid Induced Constipation CTR wave 2","Clinical Trials","DM","Completed - 1T",59074.75,59074.75,59074.75,"2012-03-09","2012-04-30","2012-03-09","NA",null,null,null,null,null,null,null,54,null,null,null,null,null,null,59074.75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Shire",{"$f":"IF(A188=\"\",\"\",VLOOKUP(A188,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Lialda Adherence","Adherence","DM","Active",{"$f":"6000*12","v":72000},{"$f":"6000","v":6000},{"$f":"H188*7","v":42000},"2012-10-26","2013-07-31",null,null,null,null,null,null,null,null,null,113,null,null,null,null,null,null,null,null,null,null,null,null,null,10142.5,2022.5,3305,1347.5,632.5,2125,5805,4805,6587.5,6775,6227.5,null,null,0,0,0]
["Shire",{"$f":"IF(A189=\"\",\"\",VLOOKUP(A189,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Lialda CAP mailing","Other","DM","Completed - 1T",null,null,null,"2012-11-12",null,null,null,null,null,null,null,null,null,null,148,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11666,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Strativa",{"$f":"IF(A190=\"\",\"\",VLOOKUP(A190,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Nascobal","Adherence","DM","Active",null,null,null,"2012-12-12",null,null,null,null,null,null,null,null,null,null,138,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5359.2,5175.92,2623.14,4134.7199999999993,3244.4099999999989,2449.6799999999994,141,0,null,null,null,0,0,0]
["Sunovion",{"$f":"IF(A191=\"\",\"\",VLOOKUP(A191,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Xopenex Back to School PT Letter","Education","DM","Completed - 1T",70302.5,70302.5,{"$f":"IF(J191=K191,H191,(IF(DATE(2012,8,31)<K191,DATE(2012,8,31),K191)-IF(DATE(2011,9,1)>J191,DATE(2011,9,1),J191))/30*H191)","v":70302.5},"2011-10-04","2011-10-04",{"$f":"K191","v":"2011-10-04"},"NA",null,null,null,null,"N/A","(back to school reminder letter)",null,32,0,70302.5,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Sunovion",{"$f":"IF(A192=\"\",\"\",VLOOKUP(A192,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Zetonna MPU","Education","MPU","Completed - 1T",25000,25000,25000,"2012-08-05","2012-08-05",{"$f":"K192","v":"2012-08-05"},"NA",null,null,null,null,null,null,null,91,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Sunovion",{"$f":"IF(A193=\"\",\"\",VLOOKUP(A193,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Adheris - Lunesta","Adherence","DM","Active",null,null,null,"2012-12-18",null,null,null,null,null,null,null,null,null,null,136,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28962.880000000001,73657.679999999993,32038.76999999999,32371.53,24112.709999999995,21130.259999999995,27508,20523.150000000001,19565.579999999994,null,null,0,0,0]
["Takeda",{"$f":"IF(A194=\"\",\"\",VLOOKUP(A194,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Edarbyclor RPh Alert","Education","Other","Completed - 1T",25000,25000,25000,"2012-03-19","2012-04-11","2012-04-11","NA",null,null,null,null,null,null,null,60,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Takeda",{"$f":"IF(A195=\"\",\"\",VLOOKUP(A195,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Uloric, Uloric ZR","Adherence","DM","Completed",79000,6315,{"$f":"IF(J195=K195,H195,(IF(DATE(2012,8,31)<K195,DATE(2012,8,31),K195)-IF(DATE(2011,9,1)>J195,DATE(2011,9,1),J195))/30*H195)","v":76832.5},"2010-06-17","2013-04-30",null,null,8400,10139,"2012-02-15",null,"8334 & 8335","In renewal",null,33,6447.5,6437.5,6315,6247.5,5852.5,5812.5,6205,6012.5,5677.5,5410,5542.5,5520,5237.5,5857.5,5245,5635,4227.5,3887.5,5007.5,1830,null,null,null,null,null,null,0,0,0]
["Takeda","BrianS","Colcrys MPU","Education","MPU","Completed - 1T",25000,25000,25000,"2012-10-15","2012-10-15","2012-10-15",null,null,null,null,null,null,null,null,119,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Takeda",{"$f":"IF(A197=\"\",\"\",VLOOKUP(A197,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Adheris - Amitiza","Adherence","DM","Active",null,null,null,"2012-12-01",null,null,null,null,null,null,null,null,null,null,122,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28445.59,23231.27,16519.37,16421.43,12658.959999999997,9710.6799999999967,12130,9462.6200000000008,9374.14,null,null,{"$f":"AT197*AU197*1.2*0.87","v":0},{"$f":"AU197*0.975*AT197","v":0},{"$f":"AV197-AW197","v":0}]
["Takeda",{"$f":"IF(A198=\"\",\"\",VLOOKUP(A198,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Adheris - Dexilant","Adherence","DM","Active",null,null,null,"2013-01-31",null,null,null,null,null,null,null,null,null,null,167,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2533.4399999999996,48276.899999999994,83131.700000000012,57379.28,30241.199999999997,33303,null,24785.46,null,null,{"$f":"AT198*AU198*1.2*0.87","v":0},{"$f":"AU198*0.975*AT198","v":0},{"$f":"AV198-AW198","v":0}]
["Takeda",{"$f":"IF(A199=\"\",\"\",VLOOKUP(A199,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Adheris - Edarbi/Edarbyclor","Adherence","DM","Active",null,null,null,"2013-02-22",null,null,null,null,null,null,null,null,null,null,178,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,434.5,8122.78,8272.8799999999974,6094.0599999999995,6327,4807.9399999999996,4472.9799999999996,null,null,{"$f":"AT199*AU199*1.2*0.87","v":0},{"$f":"AU199*0.975*AT199","v":0},{"$f":"AV199-AW199","v":0}]
["Takeda",{"$f":"IF(A200=\"\",\"\",VLOOKUP(A200,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Adheris - Dexilant CAP/nonCAP mailing","Other","DM","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,188,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45857.279999999999,null,null,null,25722.399999999998,null,null,null,{"$f":"AT200*AU200*1.2*0.87","v":0},{"$f":"AU200*0.975*AT200","v":0},{"$f":"AV200-AW200","v":0}]
["Takeda",{"$f":"IF(A201=\"\",\"\",VLOOKUP(A201,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Adheris - Uloric","Adherence","DM","Active",null,null,null,null,null,null,null,null,null,null,null,null,null,null,207,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6146.94,5272,4733.43,4380.45,null,null,{"$f":"AT201*AU201*1.2*0.87","v":0},{"$f":"AU201*0.975*AT201","v":0},{"$f":"AV201-AW201","v":0}]
["Takeda",{"$f":"IF(A202=\"\",\"\",VLOOKUP(A202,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Nesina  MPU ","Education","MPU","Completed - 1T",null,null,null,null,null,null,null,null,null,null,null,null,null,null,228,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000]
["Teva",{"$f":"IF(A203=\"\",\"\",VLOOKUP(A203,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Actiq (REMS)","Education","REMS","Completed",16000,350,350,"2009-01-01","2011-09-07",{"$f":"K203","v":"2011-09-07"},"NA",null,null,null,null,"1921-02-11",null,null,34,350,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Teva",{"$f":"IF(A204=\"\",\"\",VLOOKUP(A204,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Fentora (REMS)","Education","REMS","Completed",8000,175,175,"2009-01-01","2011-09-07",{"$f":"K204","v":"2011-09-07"},"NA",null,null,null,null,"1921-10-29",null,null,35,175,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Teva",{"$f":"IF(A205=\"\",\"\",VLOOKUP(A205,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"ProAir HFA- RPh EDU","Education","MPU","Completed - 1T",25000,25000,25000,"2011-11-20","2012-04-01","2012-04-01","NA",null,null,"N/A",null,"N/A",null,null,50,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Teva",{"$f":"IF(A206=\"\",\"\",VLOOKUP(A206,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"QNASL - RPh EDU","Education","MPU","Completed - 1T",25000,25000,25000,"2012-06-04","2012-06-04","2012-06-04","NA",null,null,null,null,null,null,null,77,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Teva",{"$f":"IF(A207=\"\",\"\",VLOOKUP(A207,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Adheris - QVAR","Adherence","DM","Active",null,null,null,"2012-12-07",null,null,null,null,null,null,null,null,null,null,140,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58461.68,94686.159999999989,85620.209999999992,109600.16999999998,90202.739999999991,75138.26999999999,81028,48959.97,46719.149999999994,null,null,0,0,0]
["Teva",{"$f":"IF(A208=\"\",\"\",VLOOKUP(A208,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Adheris - QVAR CAP/nonCAP mailing","Other","DM","Completed - 1T",null,null,null,"2012-11-19",null,null,null,null,null,null,null,null,null,null,149,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100650.44,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Upsher-Smith",{"$f":"IF(A209=\"\",\"\",VLOOKUP(A209,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"B-Nexa RPh alert","Education","MPU","Completed - 1T",25000,25000,25000,"2012-08-06","2012-08-06","2012-08-06","NA",null,null,null,null,null,null,null,92,null,null,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Vertex",{"$f":"IF(A210=\"\",\"\",VLOOKUP(A210,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"Specialty"},"Adheris - Incivek","Adherence","DM","Active",null,null,null,"2012-12-18",null,null,null,null,null,null,null,null,null,null,131,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,360.15,0,0,0,0,0,null,null,null,null,null,0,0,0]
["VisibiltyRx/J Rector","GregL","844743 Obesity CTR (Orexigen)","Clinical Trials","DM","Completed - 1T",{"$f":"98300*1.15","v":113044.99999999999},113045,113045,"2012-06-30","2012-06-30",{"$f":"K211","v":"2012-06-30"},"N/A",null,null,null,null,null,null,null,73,null,null,null,null,null,null,null,null,null,null,73436.7,43507.95,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["VisibiltyRx/J Rector","GregL","Androgel Wave 2","Education","REMS","Completed - 1T",{"$f":"7500+700*2.5","v":9250},9250,9250,"2012-05-24","2012-08-13","2013-05-01","N/A",null,null,null,null,null,null,null,72,null,null,null,null,null,null,null,null,9250,2705,4347.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["VisibiltyRx/J Rector",{"$f":"IF(A213=\"\",\"\",VLOOKUP(A213,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Brilinta REMS survey notice","Education","REMS","Completed - 1T",null,null,null,null,null,{"$f":"K213","v":"00:00:00"},"NA",null,null,null,null,null,null,null,95,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"7500+2.5*1200","v":10500},null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["VisibiltyRx/J Rector",{"$f":"IF(A214=\"\",\"\",VLOOKUP(A214,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Fortesta REMS survey notice","Education","REMS","Completed - 1T",12000,12000,12000,"2012-08-17",{"$f":"J214","v":"2012-08-17"},"2012-08-21","NA",null,null,null,null,null,null,null,87,null,null,null,null,null,null,null,null,null,null,null,11250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["VisibiltyRx/J Rector",{"$f":"IF(A215=\"\",\"\",VLOOKUP(A215,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"TIRF REMS survey notice","Education","REMS","Completed - 1T",16500,16500,16500,"2012-09-24",{"$f":"J215","v":"2012-09-24"},"2012-09-24","NA",null,null,null,null,null,null,null,93,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"12000+2.5*892","v":14230},null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["VisibiltyRx/J Rector",{"$f":"IF(A216=\"\",\"\",VLOOKUP(A216,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"TIRF REMS survey reminder","Education","REMS","Completed - 1T",2000,2000,2000,"2012-10-08",{"$f":"J216","v":"2012-10-08"},"2012-10-08","NA",null,null,null,null,null,null,null,102,null,null,null,null,null,null,null,null,null,null,null,null,null,2110,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["VisibiltyRx/J Rector","GregL","Parkinson's Disease CTR","Clinical Trials","DM","Completed - 1T",90000,90000,90000,"2012-11-02","2013-03-01","2013-03-01","NA",null,null,null,null,null,"2013-03-01",null,104,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27000,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["VisibiltyRx/J Rector","GregL","Ulcerative Colitis CTR","Clinical Trials","DM","Completed - 1T",50000,50000,50000,"2012-11-01","2013-03-01","2013-03-01","NA",null,null,null,null,null,null,null,105,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40226.199999999997,6715.7999999999993,null,null,null,null,null,null,null,null,null,null,0,0,0]
["VisibiltyRx/J Rector","GregL","Lisonopril REMS","Education","DM","Canceled - E",40000,40000,40000,null,null,null,"NA",null,null,null,null,null,null,null,106,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Watson",{"$f":"IF(A220=\"\",\"\",VLOOKUP(A220,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Gelnique - RPh EDU","Education","MPU","Completed - 1T",25000,25000,25000,"2012-06-04","2012-06-04","2012-06-04","NA",null,null,null,null,null,null,null,79,null,null,null,null,null,null,null,null,null,25000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Watson",{"$f":"IF(A221=\"\",\"\",VLOOKUP(A221,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"90-Day - Rapaflo","90-Day","REB","Active",{"$f":"80000-13000","v":67000},{"$f":"G221/12","v":5583.333333333333},{"$f":"H221*9","v":50250},"2012-11-01","2013-09-30",{"$f":"K221","v":"2013-09-30"},null,null,null,null,null,null,null,null,118,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37011.17,12000,12000,12000,12000,12000,12000,12000,null,null,0,0,0]
["Amgen","MaryT","Prolia SAR (no direct rev)","RPH Service","SAR","Active",0,{"$f":"IF(K222=J222,G222,G222/((K222-J222)/30))","v":0},{"$f":"IF(K222=J222,G222,(IF(41517<K222,41517,K222)-J222)/30*H222)","v":0},"2012-12-01","2013-12-01",null,null,null,null,null,null,null,null,null,162,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["Sunovion","VanA","Pleio - Brovana","Adherence","GS","Active",13000,{"$f":"G223/12","v":1083.3333333333333},{"$f":"G223","v":13000},"2013-01-01",null,null,null,null,null,null,null,null,null,null,163,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1352,1390,2054,1690,2366,2400,2054,806,null,null,0,0,0]
["Sunovion","VanA","Brovana ","Adherence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,165,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,{"$f":"IF(A225=\"\",\"\",VLOOKUP(A225,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,229]
[null,{"$f":"IF(A226=\"\",\"\",VLOOKUP(A226,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,230]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,231]
[]
["Total for Filtered Programs:  ",null,null,null,null,null,{"$f":"SUBTOTAL(9,G4:G227)","v":500000},{"$f":"SUBTOTAL(9,H4:H227)","v":495000},{"$f":"SUBTOTAL(9,I4:I227)","v":495000},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,V4:V227)","v":0},0,45000,0,0,25000,0,100000,50000,50000,0,50000,0,50000,0,100000,50000,50000,25000,0,0,50000,25000,75000,null,null,null,{"$f":"SUBTOTAL(9,AW4:AW228)","v":0},{"$f":"SUBTOTAL(9,AX4:AX228)","v":0}]
["Total for All Programs:  ",null,null,null,null,null,{"$f":"SUM(G4:G227)","v":21871998.484999999},{"$f":"SUM(H4:H227)","v":5789652.5470755659},{"$f":"SUM(I4:I227)","v":14417891.745357567},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V4:V227)","v":542160.68999999994},833456.78657986142,1552619.5304089012,729506.45,700957.64,1102602.54,1110045.96,1321756.7199999997,997011.69,1582050.95,1011663.94,1118503.43,806612.46,{"$f":"SUM(AI4:AI224)","v":1358069.56},{"$f":"SUM(AJ4:AJ224)","v":1941276.6700000002},{"$f":"SUM(AK4:AK224)","v":2093777.5599999998},{"$f":"SUM(AL4:AL224)","v":1835358.3399999999},{"$f":"SUM(AM4:AM224)","v":1418710.02},{"$f":"SUM(AN4:AN227)","v":2896783.1291999999},2226924.9099999992,1496435.9,2880499.33,1506499.39,1344801.2599999995]
[null,null,"Budget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1062473.58,1062473.58,1062473.58,1062473.58,885411.79,885411.79,885411.79,1721823.58,1721823.58,1721823.58,1721823.58,1721823.58,720333.33333333326,920333.33333333326,1920333.3333333333,2957111.1111111115,3057111.1111111115,3157111.1111111115,2557111.111111111,2557111.111111111,3057111.111111111,2865444.444444444,2865444.444444444,3365444.444444444]
[null,null,"Variance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V230-V231","v":-520312.89000000013},{"$f":"W230-W231","v":-229016.79342013865},490145.95040890109,-332967.13000000012,-184454.15000000002,217190.75,224634.16999999993,-400066.86000000034,{"$f":"AD230-AD231","v":-724811.89000000013},-139772.63000000012,-710159.64000000013,-603320.15000000014,{"$f":"AH230-AH231","v":86279.126666666707},{"$f":"AI230-AI231","v":437736.2266666668},20943.336666666903,-863333.55111111165,-1221752.7711111116,-1738401.0911111115,339672.01808888884,-330186.20111111179,-1560675.2111111111,15054.885555556044,-1358945.0544444441,-2020643.1844444445]
[null,null,"Total Running Sums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V230","v":542160.68999999994},{"$f":"V233+W230","v":1375617.4765798612},2928237.0069887624,3657743.4569887621,4358701.0969887618,5461303.6369887618,6571349.5969887618,7893106.3169887615,8890118.0069887619,10472168.956988761,11483832.896988761,12602336.32698876,{"$f":"AH230","v":806612.46},{"$f":"AH233+AI230","v":2164682.02},{"$f":"AI233+AJ230","v":4105958.6900000004},6199736.25,8035094.5899999999,9453804.6099999994,12350587.7392,14577512.6492,16073948.5492,18954447.8792,20460947.269200001,21805748.529199999]
[null,null,"Budget Running Sums",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V231","v":1062473.58},{"$f":"W231+V234","v":2124947.16},{"$f":"X231+W234","v":3187420.74},4249894.32,5135306.1100000003,6020717.9000000004,6906129.6900000004,8627953.2699999996,10349776.85,12071600.43,13793424.01,15515247.59,{"$f":"AH231","v":720333.33333333326},{"$f":"AH234+AI231","v":1640666.6666666665},{"$f":"AI234+AJ231","v":3561000},6518111.1111111119,9575222.2222222239,12732333.333333336,15289444.444444448,17846555.55555556,20903666.666666672,23769111.111111116,26634555.55555556,30000000.000000004]
[null,null,"Variance (running)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V233-V234","v":-520312.89000000013},-749329.6834201389,-259183.73301123781,-592150.86301123817,-776605.01301123854,-559414.26301123854,-334780.09301123861,-734846.95301123802,-1459658.8430112377,-1599431.4730112385,-2309591.1130112391,-2912911.2630112395,{"$f":"AH233-AH234","v":86279.126666666707},{"$f":"AI233-AI234","v":524015.35333333351},544958.69000000041,-318374.86111111194,-1540127.632222224,-3278528.7233333364,-2938856.705244448,-3269042.9063555598,-4829718.1174666714,-4814663.2319111153,-6173608.2863555588,-8194251.4708000049]

{"sheet":"Development","index":1,"n_rows":35,"n_cols":26,"rows_kept":35,"cut":false,"hidden":false,"merged":[[33,0,33,5],[34,0,34,5]]}
["DEVELOPMENT"]
[]
["Client","NPAD","Program Desc","Product Line","Type","Status","Estimated Contract Value","Estimated Monthly Value","Estimated FY Contract","Target Start Date","Expected Start Date","Expected Term Date","Contract Status","Development Status","Materials Status","Implement Status","RPH Training","Front Door","Outsourced Vendor Contract Status","PCC ID","Weekly Action Item","Blank","2011-09","2011-10","2011-11","Comments"]
["Amylin","MaryT","Bydureon Goodstart","Adherence","GS","Develop",293000,{"$f":"IF(L4=K4,G4,G4/((L4-K4)/30))","v":24082.191780821919},{"$f":"IF(L4=K4,G4,(IF(41517<L4,41517,L4)-K4)/30*H4)","v":243230.13698630137},"2012-06-01","2012-11-01","2013-11-01","Executed","O - Approval","Ordered","Not Started","NA","NA",null,null,"10/30 Script in Amylin review to become unbranded : Letters approved"]
["Boehringer",{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Tradjenta/Jentadueto (Patient and MD Mailing)","Education","Other","Develop",5167,{"$f":"IF(L5=K5,G5,G5/((L5-K5)/30))","v":2627.2881355932204},{"$f":"IF(L5=K5,G5,(IF(41517<L5,41517,L5)-K5)/30*H5)","v":5167},"2012-12-31","2013-02-01","2013-04-01","Executed","Complete",null,"Not Started"]
["Daiichi Sankyo","VanA","Welchol","Adherence","GS","Develop",245700,{"$f":"G6/12","v":20475},{"$f":"H6*7","v":143325},"2012-10-31","2013-02-01","2014-01-31","Review","O - Approval","Partial",null,null,null,null,null,"10/2 Letters returned to Daiichi for review, MSA w/mfg  SOW w/Wag    "]
["Daiichi Sankyo","VanA","Benicar","Adherence","GS","Develop",2210600,{"$f":"G7/12","v":184216.66666666666},{"$f":"H7*7","v":1289516.6666666665},"2013-01-01","2013-02-01","2014-01-31","Review","O - Approval"]
["DEY",{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"EpiPen & JR","Adherence","IVR","Develop",347000,{"$f":"G8/4","v":86750},{"$f":"H8*5","v":433750},"2012-07-01","2013-02-01",null,"Review","Partial",null,null,null,null,null,null,"10/16 Porgram will start with Adheris in 2012  Contract in Wag legal - Launch delayed to 2013 "]
["J&J (Janssen)",{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Prezista - HIV COE","RPH Service","ADH","Develop",250000,{"$f":"G9/12","v":20833.333333333332},{"$f":"H9*3","v":62500},"2013-03-02","2013-02-01","2014-12-01","Review","Partial",null,"Not Started",null,null,null,null,"10/2 Contract with Janssen AE reporting issue ",null,null,null,null,": F2F NTT IC+ cap, follow up NTT call w/in 7 days, late refill call on all 3 days late,"]
["Sanofi Aventis",{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Apidra - Restock letter","Education",null,"Develop",25000,25000,25000,"2012-07-23","2012-12-01",{"$f":"K10","v":"2012-12-01"},"O - Review","Complete",null,"Not Started",null,null,null,null,"10/30 Sanofi has not finalized MSA. All projects still on hold. Review for effectiveness of this letter as it's now stale. 6/26 No change in SOW review. "]
["Sanofi Aventis",{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Lantus Vial IVR","Adherence","IVR","Develop",235850,{"$f":"G11/12","v":19654.166666666668},{"$f":"H11*8","v":157233.33333333334},"2012-01-01","2013-12-01",null,"Executed","Complete","NA","Not Started","NA","NA","Eliza contract executed",null,"10/30 Script final.The amended and restated Lantus IVR SOW is under Sanofi's review"]
["Eisai","VanA","Belviq ","Education","MPU","Active",25000,25000,25000,"2013-02-25",null,"2013-08-25","Draft","Not Started","Not Started","Not Started","NA","NA",null,null,"New drug launch MPU"]
["Acurian",{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"RA (2012) recount request","Clinical Trials","Other","Completed"]
["Acurian",{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Gout 2029 recount request","Clinical Trials","Other","Completed"]
["Acurian",{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"COPD (2013)","Clinical Trials","Other","Develop"]
["Acurian",{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"High Triglycerides (2038)","Clinical Trials","Other","Develop"]
["Boehringer","VanA","Pradaxa Physician Mailing","Education","DM","Develop",75000,{"$f":"IF(L17=K17,G17,G17/((L17-K17)/30))","v":75000},{"$f":"IF(L17=K17,G17,(IF(41517<L17,41517,L17)-K17)/30*H17)","v":75000},"2012-09-30","2012-12-01","2012-12-01","Review","Draft",null,"canceled",null,null,null,null,"10/02 Letters completed in review at BI, contract in Wag legal "]
["Medicis","MaryT","Solodyn/Ziana Cash Expansion","Other","Other","Develop",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10/2 SOW w/Wag legal    "]
["Novo Nordisk","MaryT","Victoza Enhancements (????)"]
["Takeda","BrianS","Dexilant ADHERIS","Adherence","DM","Completed",null,null,null,null,null,"2013-12-31","Not Started","Partial"]
["Boehringer","VanA","Spiriva ADHERIS","Adherence","DM",null,null,null,null,null,null,"2013-12-31","Not Started","Not Started"]
["Boehringer","VanA","Pradaxa ADHERIS","Adherence","DM",null,null,null,null,null,null,"2013-12-31","Not Started","Not Started"]
["Takeda","BrianS","Edarbiclor ADHERIS","Adherence","DM",null,null,null,null,null,null,"2013-12-31","Not Started","Not Started"]
["Novartis","JenL","Exforge ADHERIS","Adherence","DM",null,null,null,null,null,null,"2013-12-31","Draft","Not Started"]
["Novartis","JenL","Exforge HCT ADHERIS","Adherence","DM",null,null,null,null,null,null,"2013-12-31","Draft","Not Started"]
["AstraZeneca","VanA","Nexium DN ADHERIS","Adherence","DM",null,null,null,null,null,null,"2013-12-31","Draft","Not Started"]
["Boehringer","VanA","Combivent Res ADHERIS","Adherence","DM",null,null,null,null,null,null,null,"Executed","Complete"]
["Boehringer","VanA","Combivent ADHERIS","Adherence","DM",null,null,null,null,null,null,null,"Not Started","Not Started"]
["Daiichi Sankyo",{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Benicar ADHERIS","Adherence","DM","Completed",null,null,null,null,null,"2013-12-31","Executed","Partial"]
["Alcon",{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Azopt, Travatan Z 90-Day Program","90-Day","REB","Develop",null,null,null,null,"2013-02-01","2014-01-31","O - Sign","Not Started","NA","Not Started","NA","NA","NA","NA","at Alcon - they are sigining"]
[null,{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":""}]
[null,{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":""}]
[]
["Total for Filtered Programs:  ",null,null,null,null,null,{"$f":"SUBTOTAL(9,G4:G32)","v":25000},{"$f":"SUBTOTAL(9,H4:H32)","v":25000},{"$f":"SUBTOTAL(9,I4:I32)","v":25000}]
["Total for All Programs:  ",null,null,null,null,null,{"$f":"SUM(G4:G33)","v":3712317},{"$f":"SUM(H4:H33)","v":483638.64658308181},{"$f":"SUM(I4:I33)","v":2459722.1369863013}]

{"sheet":"Proposals","index":2,"n_rows":23,"n_cols":20,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,0,20,5],[21,0,21,5],[22,0,22,5]]}
["Proposed Programs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program with Monthly Variability"]
["Client","NPAD","Program Desc","Solution","Product","Status","Estimated Contract Value","Estimated Monthly Value","Estimated FY Value","Target Start Date","Target Term Date","Proba- bility","Pt Counts ","Comments","Blank","ID","2011-09","2011-10","2011-11","2011-12"]
["Daiichi Sankyo","VanA","Benicar MPU","Education","MPU","Proposed",25000,null,null,"2012-09-01"]
["Novartis",{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"COPD registry mailing","Clinical Trials","DM","Proposed",4000,0,4000,null,null,"Medium",null,null,null,"P79"]
["Teva","MaryT","Copaxone SAR","RPh Service","SAR","Proposed",222380,18532,55596,"2012-09-01","2013-08-31","Low",null,null,null,"P57"]
["Trial Accel./Ballenger",{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Diabetic Peripheral Neuropathy","Clinical Trials","DM","Proposed",null,null,null,"2012-04-01","2012-04-01","NA",null,"Requested Rx counts only",null,"P28"]
["Trial Accel./Ballenger",{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Hypertriglyceridemia CTR","Clinical Trials","DM","Proposed",2000000,2000000,2000000,"2012-07-23","2012-07-24","NA",1055567]
["Trial Accel./Ballenger","GregL","Merck RA CTR","Clinical Trials","DM","Proposed","TBD",null,null,"2012-07-30","2012-07-30","NA"]
["Trial Accel./Ballenger",{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Midodrine","Clinical Trials","DM","Proposed","small",null,null,null,null,"NA",null,null,null,"P84"]
["Trial Accel./Ballenger",{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"OAB","Clinical Trials","DM","Proposed",null,null,null,"2012-04-01","2012-04-01","NA",null,null,null,"P7"]
["Trial Accel./Ballenger",{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Psoriasis/failed on Humira CTR","Clinical Trials","DM","Proposed",null,null,null,"2012-09-01","2013-08-31","NA",null,null,null,"P48"]
["Trial Accel./Ballenger",{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Restless Leg Syndrome","Clinical Trials","DM","Proposed",null,null,null,"2012-04-01","2012-04-01","NA",null,"Requested Rx counts only",null,"P27"]
["Trial Accel./Ballenger",{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Type I Diabetes - Metformin","Clinical Trials","DM","Proposed",null,null,null,"2012-04-01","2012-04-01","NA",null,null,null,"P8"]
[]
[]
[]
[]
[null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"P89"]
[null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"P89"]
[]
["Total for Filtered Programs:  ",null,null,null,null,null,{"$f":"SUBTOTAL(9,G4:G9)","v":2251380},{"$f":"SUBTOTAL(9,H4:H9)","v":2018532},{"$f":"SUBTOTAL(9,I4:I9)","v":2059596}]
["Total for All Programs:  ",null,null,null,null,null,{"$f":"SUM(G4:G9)","v":2251380},{"$f":"SUM(H4:H9)","v":2018532},{"$f":"SUM(I4:I9)","v":2059596}]

{"sheet":"Definitions","index":3,"n_rows":157,"n_cols":4,"rows_kept":157,"cut":false,"hidden":true,"merged":[]}
[null,"call in number for anyone off-site from 1411 Lake Cook is 866-309-0558 meeting number *8473748326*"]
[null,"Moderator * 2192*"]
[]
["Active Programs drop-down boxes"]
[]
[null,"Status header:"]
[null,null,"Running","Program is running normally"]
[null,null,"Enrollment stopped","The enrollment limit has been reached; contacts are continuing for those already enrolled"]
[null,null,"Suspended","Contacts have been halted but are expected to resume in the near future"]
[null,null,"Stopped","The program has been stopped recently and is not expected to resume in the near future"]
[]
["Programs in Development drop-down boxes"]
[]
[null,"Contract status header:"]
[null,"LPCS,OTCS,FFCS,IPCS,PCCS","Not Started","Work has not commenced on a written agreement or SOW yet"]
[null,null,"In development","The legal document is in the process of being developed but has not been reviewed yet"]
[null,null,"In review at Walgreens","The legal document is being reviewed by Walgreens - add comments if necessary (in legal, etc.)"]
[null,null,"In review at Sponsor","The legal document is being reviewed by the program sponsor"]
[null,null,"Finalized","All terms have been negotiated and the document is ready to be finalized for signoff & signatures"]
[null,null,"Signing - at Sponsor","The document is at the program sponsor to be signed"]
[null,null,"Routed - at Walgreens","The document has been routed for sign-off and signatures by Walgreens"]
[null,null,"Executed","The agreement or SOW has been signed by all parties"]
[]
[null,"Development status header - Letter Programs:"]
[null,"LPDS","Not Started","Work has not commenced on the program design or mailing materials"]
[null,null,"Program design in process","A program design is in the process of being developed but has not been reviewed yet"]
[null,null,"Letters in development","Letters and ancillary printed material are in the process of being developed but have not been reviewed yet"]
[null,null,"Letters in review at Sponsor","Materials are being reviewed by the program sponsor"]
[null,null,"Letters in review at Walgreens","Materials are being reviewed by Walgreens"]
[null,null,"Letters in Approval at Sponsor","Materials are in Med-Reg or other approval process at the program sponsor"]
[null,null,"Letters in Approval at Walgreens","Materials are in approval process at Walgreens"]
[null,null,"Templates loaded at printer","Templates have been developed and provided to the printing/mailing firm"]
[null,null,"Test samples awaiting approval","Test mailing samples have been produced and are awaiting approval from the sponsor"]
[null,null,"Completed","All steps for printing materials are completed"]
[null,"Development status header - One-time Mailings"]
[null,"OTDS","Not Started","Work has not commenced on the program design or mailing materials"]
[null,null,"Program design in process","A program design is in the process of being developed but has not been reviewed yet"]
[null,null,"Letters in development","Letters and ancillary printed material are in the process of being developed but have not been reviewed yet"]
[null,null,"Letters in review - Sponsor","Materials are being reviewed by the program sponsor"]
[null,null,"Letters in review - Walgreens","Materials are being reviewed by Walgreens"]
[null,null,"Letters in Approval - Sponsor","Materials are in Med-Reg or other approval process at the program sponsor"]
[null,null,"Letters in Approval - Walgreens","Materials are in approval process at Walgreens"]
[null,null,"Templates loaded at printer","Templates have been developed and provided to the printing/mailing firm"]
[null,null,"Test samples awaiting approval","Test mailing samples have been produced and are awaiting approval from the sponsor"]
[null,null,"Completed","All steps for printing materials are completed"]
[null,"Development status header - Acurian Mailings"]
[null,"AMDS","Not Started","Work has not commenced on the program design or mailing materials"]
[null,null,"Letters in development","Letters and ancillary printed material are in the process of being developed but have not been reviewed yet"]
[null,null,"Letters in review - Sponsor","Materials are being reviewed by the program sponsor"]
[null,null,"Letters in review - Walgreens","Materials are being reviewed by Walgreens"]
[null,null,"Letters in Approval - Sponsor","Materials are in Med-Reg or other approval process at the program sponsor"]
[null,null,"Letters in Approval - Walgreens","Materials are in approval process at Walgreens"]
[null,null,"Templates loaded at printer","Templates have been developed and provided to the printing/mailing firm"]
[null,null,"Test samples pending","Test mailing samples have been produced and are awaiting approval from the sponsor"]
[null,null,"Completed","All steps for printing materials are completed"]
[null,"Development status header - Face-to-Face Programs:"]
[null,"FFDS","Not Started","Work has not commenced on the program design or call script"]
[null,null,"Manufacturer Kick Off Mtg"]
[null,null,"Program Design in Progress","A program design is in the process of being developed but has not been reviewed yet"]
[null,null,"Program design final"]
[null,null,"FDRx Request Submitted"]
[null,null,"FDRx Approved"]
[null,null,"Materials in development"]
[null,null,"Manufacturer review"]
[null,null,"Materials final"]
[null,null,"RCA kick off meeting"]
[null,null,"RCA campaign logic in development"]
[null,null,"RCA campaign testing in progress"]
[null,null,"RCA quality test complete"]
[null,null,"Completed","All steps are completed and Rx Advisor program is ready to turn on"]
[null,"Development status header - IVR/Phone-based Programs:"]
[null,"IPDS","Not Started","Work has not commenced on the program design or call script"]
[null,null,"Program design in process","A program design is in the process of being developed but has not been reviewed yet"]
[null,null,"Script in development","Call script is in the process of being developed but has not been reviewed yet"]
[null,null,"Script in review - Sponsor","Call script is being reviewed by the program sponsor"]
[null,null,"Script in review - Walgreens","Call script is  being reviewed by Walgreens"]
[null,null,"Script in Approval - Sponsor","Call script is in Med-Reg or other approval process at the program sponsor"]
[null,null,"Script in Approval - Walgreens","Call script is in approval process at Walgreens"]
[null,null,"Script loaded at program partner","Call script has been loaded in the IVR or call management system at Eliza, Pleio or other partner"]
[null,null,"Test/Training phase","Call flow is being tested and/or agents are being trained"]
[null,null,"Completed","All steps are completed and IVR/cal program ready to turn on"]
[null,"Development status header - Pharmacist Communications Programs:"]
[null,"PCDS","Not Started","Work has not commenced on the document"]
[null,null,"Update document in process","A communication document is in the process of being developed but has not been reviewed yet"]
[null,null,"Update document in development","Information has been received and a document is being prepared"]
[null,null,"Document in review - Sponsor","Update document is being reviewed by the program sponsor"]
[null,null,"Completed","All steps are completed and documen t is ready to be disseminated"]
[null,"Ancillary materials status header - Letter Programs:"]
[null,"LPAM","Not Started","No decisions have been made about ancillary materials to be included"]
[null,null,"Samples under review","Samples have been provided by the sponsor and are under review by Walgreens"]
[null,null,"Materials on order","Sponsor is in the process of shipping start-up supply to our printing/mailing firm"]
[null,null,"Materials on hand","The supply of ancillary materials need for start-up have been delivered"]
[null,null,"PI only will be used","The only inserts will be the product's FDA-approved Professional Package Insert or Patient Information Insert"]
[null,null,"Not Applicable","This program will not have any ancillary materials to be included in the mailing"]
[null,"Pharmacist Training status header - Face to Face Programs:"]
[null,"FFPT","Not Required","Pharmacist training will not be required"]
[null,null,"Not Started","Training will be required but has not been started"]
[null,null,"Pharm Ops kick off meeting"]
[null,null,"Launch strategy in development"]
[null,null,"Launch strategy final"]
[null,null,"Materials in development","Materials to be used are in the process of being developed"]
[null,null,"Materials final","Sessions have been planned and scheduled"]
[null,null,"Training Development Complete","Training has been completed for this program"]
[null,"Data Feed status header - IVR/Phone Programs:"]
[null,"IPDF","Not Required","Data feed does not need to be established or is already in place"]
[null,null,"Not Started","Data Feed will be required but has not been started"]
[null,null,"Data Feed in development","The appropriate internal and external resources are engaged to establish a secure link"]
[null,null,"Testing","Data feed has been established and is being tested"]
[null,null,"Completed","Data feed for this program is ready to go live"]
[null,"Implementation status header - Letter Programs:"]
[null,"LPIS","Not Started","Program has not been loaded in PCC system"]
[null,null,"Exclusion group running; no supplemental load needed"]
[null,null,"Exclusion group running; supplemental load needed"]
[null,null,"No exclusion group needed"]
[null,"Implementation status header - One-time Mailings:"]
[null,"OMIS","Not Started","Program has not been loaded in PCC system, nor data extract ordered"]
[null,null,"Data Extract Ordered","Data Extract has been ordered fron DSS Support"]
[null,null,"Data Extract Ready","Data Extract ready for processing against address validation & DNC listing"]
[null,null,"Data Extract scrubbed","Data Extract has been scrubbed and is ready for final steps to create mailing list(s)"]
[null,null,"Mailng list(s) ready","Mailing list(s) for this program have been finalized"]
[null,null,"Mailing completed","Mailing has been completed by printing/mailing firm"]
[null,"Implementation status header - Acurian Mailings:"]
[null,"AMIS","Not Started","Data generation for this program has not started"]
[null,null,"Data Extract for mailing counts ordered","Data Extract has been ordered fron DSS Support"]
[null,null,"Mailing counts completed","Counts of potential mailing candidates by zip code completed"]
[null,null,"Waves by zip code groupings pending","Mailing list \"Waves\" of Zip Code groupings have been requested by Acurian"]
[null,null,"Mailng list(s) for waves ready"," Requested  mailing list(s) \"Waves\" are ready"]
[null,null,"Mailng list(s) transmitted to printer","Mailing list(s) for this program have been sent to printer"]
[null,null,"Mailing completed","Mailing has been completed by printing/mailing firm"]
[null,"Implementation status header - Face to Face Programs:"]
[null,"FFIS","Not Started","Process has not started to load program in Rx Advisor"]
[null,null,"Market communication plan in progress"]
[null,null,"Market communication plan final"]
[null,null,"Market meetings in progress"]
[null,null,"Final materials placed on storenet"]
[null,null,"Program launch communicated to market"]
[null,null,"Program active"]
[null,null,"Follow-up market survey/feedback"]
[null,"Implementation status header - IVR/Phone Programs:"]
[null,"IPIS","Not Started","Program Implementation has not been started"]
[null,null,"Exclusion group running; no supplemental load needed","(For PCC-driven programs)"]
[null,null,"Exclusion group running; supplemental load needed","(For PCC-driven programs)"]
[null,null,"DSS programming in process","(For DSS extract-driven programs)"]
[null,null,"DSS programming ready","(For DSS extract-driven programs)"]
[null,null,"Completed","Program ready to go operational"]
[null,"Implementation status header - Pharmacist Communication Programs:"]
[null,"PCIS","Not Started","Document has not been submitted to be published"]
[null,null,"Submitted to Pharmacy Services","Document is finalized and has been submitted for inclusion in next weekly bulletin"]
[null,null,"Published","Update document has been published in a weekly bulletin"]
[]
[]
["Recently Completed Programs drop-down boxes"]
[]
[null,"Program status header:"]
[null,"RCPS","Add'l mailing pending","Work has not commenced on a written agreement or SOW yet"]
[null,null,"Gift Card mailing pending","The legal document is in the process of being developed but has not been reviewed yet"]
[null,null,"Mailing completed","Mailing has been completed by printing/mailing firm"]

{"sheet":"Forecast to Budget","index":4,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":true,"merged":[[0,0,0,14]]}
["BUDGET ANALYSIS"]
[]
[]
["BUDGET VARIANCE"]
["2012 FY ","2011-09-01","2011-10-01","2011-11-01","YTD","2011-12-01","2012-01-01","2012-02-01","2012-03-01","2012-04-01","2012-05-01","2012-06-01","2012-07-01","2012-08-01","Total"]
["Budget",1062473.58,1062473.58,1062473.58,{"$f":"SUM(B6:D6)","v":3187420.74},1062473.58,885411.79,885411.79,885411.79,1721823.58,1721823.58,1721823.58,1721823.58,1721823.58,{"$f":"SUM(B6:N6)-E6","v":15515247.589999998}]
["Estimated",{"$f":"B8","v":535110.68704994081},871010.52098591544,{"$f":"C7+D24+D37","v":1705708.0209859153},{"$f":"SUM(B7:D7)","v":3111829.2290217718},null,null,null,null,null,null,null,null,null,{"$f":"SUM(B7:N7)","v":6223658.4580435436}]
["Actual",535110.68704994081,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B8:N8)","v":535110.68704994081}]
[]
["VAR (Act)",{"$f":"IF(B8=\"\",B7,B8)-B6","v":-527362.89295005926},{"$f":"IF(C8=\"\",C7,C8)-C6","v":-191463.05901408463},643234.44098591525,-75591.510978228413,-1062473.58,-885411.79,-885411.79,-885411.79,-1721823.58,-1721823.58,-1721823.58,-1721823.58,-1721823.58,-14980136.902950058]
[]
[]
["GAINED REVENUE"]
["1T Mailings",null,165302.5,1000000]
[]
["New Recurring Programs"]
["PSC Rebates",null,80000]
["Trilipix/Tricor IVR",null,{"$f":"'Active-Completed'!H9","v":44182}]
["Pradaxa full Month",null,10000]
[]
[]
[]
[]
["Total New",null,{"$f":"SUM(C14:C23)","v":299484.5},{"$f":"SUM(D14:D23)","v":1000000}]
[]
[]
["LOST REVENUE"]
["1T Mailings",null,null,{"$f":"-C14","v":-165302.5}]
[]
["Lost Recurring Programs"]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(D28:D36)","v":-165302.5}]

{"sheet":"In Discussion","index":5,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,0,23,5],[24,0,24,5],[25,0,25,5]]}
["IN DISCUSSION"]
[]
["Client","NPAD","Program Desc","Solution","Product","Status","Estimated Contract Value","Estimated Monthly Value","Comments"]
["Abbott",{"$f":"IF(A4=\"\",\"\",VLOOKUP(A4,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Tarka - generic gone - Patient","Education","DM",null,null,null,"with copay card"]
["Acurian",{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Rosacea ","Clinical Trials","DM"]
["Acurian",{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Parkinson's","Clinical Trials","DM"]
["B&L",{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Portfolio - Store Media","Education","Other",null,100000,{"$f":"G7","v":100000},{"$f":"H7","v":100000}]
["Galderma",{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Epi DUO and Oracia","Adherence","Other",null,null,null,"1st Fill issue"]
["J&J (Janssen)",{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Xarelto","RPH Service","ADH",null,250000,{"$f":"G9/12","v":20833.333333333332},{"$f":"H9*3","v":62500}]
["Novartis",{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"LCQQ908 CV Risk (Hyperlipidemia) study","Clinical Trials","DM",null,null,null,"may include Catalina"]
["Novartis",{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"KRP203 SCLE (Lupus) study","Clinical Trials","DM",null,null,null,"may include Catalina"]
["Novo Nordisk",{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Deguldec PSC","PSC","Rebate"]
["Novo Nordisk",{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"F2F Deglidec","RPH Service","INJ TR"]
["Novo Nordisk",{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Launch Playbook Deguldec","Other","Other"]
["Pfizer",{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Pfizer OAB and diabetes trial recruitmant","Clinical Trials","DM"]
["SDI",{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Diabetes w anti-coagulent/anti-platelet","Clinical Trials","DM",null,{"$f":"75000*0.5+(75000*0.005*105)","v":76875},null,"SDI to pull mail list ID's"]
["Teva",{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"ProAir Back to School / Summer","Education","DM",null,25000,null,"MPU"]
["UCB",{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Cimzia","RPH Service","SAR",null,150000,{"$f":"G18/12","v":12500},{"$f":"H18*3","v":37500}]
["Novartis","JenL","Foradil Asthma Study - Data","Clinical Trials","Data"]
["Medicis","MaryT","Solodyn Letter Campaign","Adherence","DM"]
[]
[]
[]
[]
["Total for Filtered Programs:  ",null,null,null,null,null,{"$f":"SUBTOTAL(9,G4:G23)","v":601875},{"$f":"SUBTOTAL(9,H4:H23)","v":133333.33333333331}]
["Total for All Programs:  ",null,null,null,null,null,{"$f":"SUM(G4:G23)","v":601875},{"$f":"SUM(H4:H23)","v":133333.33333333331}]

{"sheet":"Lists","index":6,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Product Line","Type","NPAD","Status - A/C","Status - Proposed","Contract","Develop","Materials","Implementation","Probability"]
["90-Day","DM","Brian S.","Active","Develop","Draft","Draft","Complete","Not Started ","Low",{"$f":"D2","v":"Active"}]
["Adherence","E-COM","Cathy P.","Develop","Proposed","Business","Approval","Develop","In Progress","Medium",{"$f":"K2&\",\"&D3","v":"Active,Develop"}]
["Clinical Trials","SAR","Jen L.","Existing Only","Open - Ct","Review","Complete","Ordered","Complete","High",{"$f":"K3&\",\"&D4","v":"Active,Develop,Existing Only"}]
["RPh Service","INJ TR","Mary T.","Completed","Complete - Ct","Sign","O - Draft","Partial",null,"NA","Active,Develop,Existing Only,Completed"]
["Data","Data","Van A.","Completed - 1T",null,"Ctr-Sig","O - Approval","Not Started",null,null,{"$f":"K5&\",\"&D7","v":"Active,Develop,Existing Only,Completed,Hold"}]
["Education","MPU","NA","Hold",null,"Executed","Partial","NA",null,null,"Active,Develop,Existing Only,Completed,Hold,Canceled - E"]
["Marketing","REB",null,"Canceled - E",null,"Hold","Not Started",null,null,null,"Active,Develop,Existing Only,Completed,Hold,Canceled - E,Canceled - I"]
["Outcomes","ADH",null,"Canceled - I",null,"O - Draft","NA",null,null,null,"Active,Develop,Existing Only,Completed,Hold,Canceled - E,Canceled - I,Off - Budget"]
["PSC","Adheris",null,"Off - Budget",null,"O - Review",null,null,null,null,"Active,Develop,Existing Only,Completed,Hold,Canceled - E,Canceled - I,Off - Budget,Off - Revise"]
["Other","REMS",null,"Off - Revise",null,"O - Sign",null,null,null,null,"Active,Develop,Existing Only,Completed,Hold,Canceled - E,Canceled - I,Off - Budget,Off - Revise,Proposed"]
[null,"Fax",null,"Proposed",null,"O - CtrSig"]
[null,"GS",null,null,null,"O - Hold"]
[null,"IVR",null,null,null,"Not Started"]
[null,"PCC"]
[null,"Retail"]
[null,"Other"]

{"sheet":"DC'D In D-P","index":7,"n_rows":84,"n_cols":46,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["Client","NPAD","Program Desc","Solution","Product","Status","Estimated Contract Value","Estimated Monthly Value","Estimated FY Contract","Target Start Date","Expected Start Date","Expected Term Date","Contract Status","Development Status","Materials Status","Implement Status","RPH Training","Front Door","Outsourced Vendor Contract Status","PCC ID","Comments","ID","2011-09","2011-10","2011-11","2011-12","2012-01","2012-02","2012-03","2012-04","2012-05","2012-06","2012-07","2012-08","2012-09","2012-10","2012-11","2012-12","2013-01","2013-02","2013-03","2013-04","2013-05","2013-06","2013-07","2013-08"]
["Sanofi Aventis",{"$f":"IF(A2=\"\",\"\",VLOOKUP(A2,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Multaq","ADH","Direct Mail","Canceled - E",40822,{"$f":"G2/12","v":3401.8333333333335},{"$f":"H2*9","v":30616.5},"2011-12-01",{"$f":"J2","v":"2011-12-01"},"2012-11-30","O - Hold","Complete","Complete","Not Started","NA","NA","NA",null,"The program is discontinued, eff. 11/7/11 per Sanofi.  Drug Saftey Issue\n","D14"]
["Acurian",{"$f":"IF(A3=\"\",\"\",VLOOKUP(A3,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Depression","CTR","Direct Mail","Proposed",30000,30000,30000,"2011-12-30","2011-12-30","Low",null,null,null,"P2",null,null,null,null,"Decided on by PDMA RSG"]
["Acurian",{"$f":"IF(A4=\"\",\"\",VLOOKUP(A4,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Major Depressive Disorder","CTR","Direct Mail","Proposed","TBD","TBD","TBD",null,null,"Low",null,"Requested national counts by Zip",null,"P31",null,null,null,null,"Decided on by PDMA RSG"]
["Ballenger",{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":{"$error":"#N/A"}},"Depression (SSRI's & SNRI's) ","CTR","Direct Mail","Proposed","TBD","TBD","TBD",null,null,"Low",null,"Requested Rx counts only",null,"P29",null,null,null,null,"Decided on by PDMA RSG"]
["Ballenger",{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":{"$error":"#N/A"}},"Depression","CTR","Direct Mail","Proposed",50000,{"$f":"G6/((K6-J6)/30+1)","v":50000},{"$f":"G6","v":50000},"2012-01-15","2012-01-15","Low",null,null,null,"P6",null,null,null,null,"Decided on by PDMA RSG"]
["Novartis",{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Tekturna products","ADH","Direct Mail","Develop",320000,{"$f":"G7/12","v":26666.666666666668},{"$f":"H7*9","v":240000},"2011-11-01","2011-12-01","2012-11-30","Executed","Complete","Ordered","Started ","NA","NA","NA",null,"Programs DC'ed until further notice due to negative study"]
["Actavis",{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Opana ER Generic 7.5mg & 15mg - Pt Letter","EDU","Direct Mail","Develop",{"$f":"1000*2.5","v":2500},{"$f":"G8","v":2500},{"$f":"H8","v":2500},"2011-12-10","2012-01-23",{"$f":"K8","v":"2012-01-23"},"Review","Approval","Not Started","Not Started","NA","NA","NA",null,"1/24/2012 Cancelled Program"]
["Boehringer",{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Tradjenta Met - Fixed Dose MD Mailing","EDU","Direct Mail","Proposed",20000,20000,20000,"2012-02-15","2012-04-01","2012-02-25","O - Review","Draft","Ordered","Not Started","NA","NA","NA",null,"3/27/2012 -  Contract in review ",null,"D27"]
["Sunovion","VanA","Brovana Rph Alert","EDU","Other","Canceled - E",25000,25000,25000,"2012-03-19","2012-03-26","2012-03-26","Review","Complete","NA","Not Started","NA","NA","NA",null,"Dead Deal "]
["Sunovion","VanA","Zetonna RPh Alert","EDU","Other","Canceled - E",25000,25000,25000,"2012-04-16","2012-04-16","2012-04-16","O - Review","Draft","NA","Not Started","NA","NA","NA",null,"Dead Deal "]
["Sunovion","VanA","Latuda RPh Alert","EDU","Other","Canceled - E",25000,25000,25000,"2012-04-26","2012-04-26","2012-04-26","O - Review","Complete","NA","Not Started","NA","NA","NA",null,"Dead Deal "]
["SDI",{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Effient REMS (REMOVE FROM ACCRUAL)","REMS","Direct Mail","Canceled - E",8750,8750,8750,"2012-03-28","2013-01-01","2012-03-28","N/A",null,null,null,null,null,null,null,55,null,null,null,null,null,null,8750]
["Teva","MaryT","QVAR","ADH","PCC",null,null,null,"Live Outreach"]
["Teva",{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Respiratory PSC","PSC","Other",null,null,null,null,"2012-03-01","2013-02-28","NA",null,null,null,"P19"]
["Abbott",{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Synthroid","PSC","Other","Canceled - I",0,0,"No opportunity"]
["Pfizer",{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Lipitor","EDU","Direct Mail","Canceled - I",218000,218000,218000,"2012-03-01","2012-03-15","2012-03-15","Executed","Complete","Ordered","Not Started","NA","NA","NA",null,"4/24 -  Business decision ",null,"D31"]
["Pfizer",{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Lipitor","ADH","GoodStart","Canceled - E",1650000,137500,550000,"2012-04-30","2012-05-10","2013-04-30","O - Review","Partial",null,"Not Started","NA","NA",null,null,"4/23 Pending legal rsp then next step: send to Pfizer 4/17 Script with Pfizer ",null,"D32"]
["Takeda",{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Nesina/Oseni RPh Alert","EDU",null,null,null,null,null,"2012-05-21",null,null,null,null,null,null,null,null,null,null,"ON HOLD",null,"D49"]
["Joe Rector",{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":{"$error":"#N/A"}},"Hep C ","CTR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ON HOLD",null,"D44"]
["Pfizer",{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Detrol LA 90D","90D","90D","Canceled - E",1000000,{"$f":"G21/12","v":83333.333333333328},{"$f":"G21/6","v":166666.66666666666},"2012-03-01","2012-02-28","Medium",null,null,null,"P39"]
["Pfizer","JenL","Lyrica 90D","90D","90D","Canceled - E",3000000,{"$f":"G22/12","v":250000},{"$f":"G22/6","v":500000},"2012-03-01","2013-02-28","High",null,null,null,"P41"]
["Pfizer",{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"JenL"},"Pristiq 90D","90D","90D","Canceled - E",1300000,{"$f":"G23/12","v":108333.33333333333},{"$f":"G23/6","v":216666.66666666666},"2012-03-01","2013-02-28","High",null,null,null,"P40"]
["Merck",{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Januvia Family 90D","90D","90D","Canceled - E",2000000,{"$f":"G24/12","v":166666.66666666666},{"$f":"H24*5","v":833333.33333333326},"2012-04-01","2013-03-31","NA",null,"Most likely will not happen",null,"P42"]
["Merck",{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Singulair 90D","90D","90D",null,4000000,{"$f":"G25/6","v":666666.66666666663},{"$f":"H25*5","v":3333333.333333333},"2012-04-01","2012-07-30","NA",null,null,null,"P44"]
["Takeda",{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Actos 90D","90D","90D","Canceled - E",{"$f":"3000000*5/6","v":2500000},{"$f":"G26/5","v":500000},{"$f":"G26","v":2500000},"2012-03-01","2013-02-28","Medium",null,null,null,"P25"]
["Daiichi Sankyo",{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Sprix","DATA","Other","Canceled - E",null,null,null,"2012-04-01","2012-12-31","NA",null,null,null,"P11"]
["AstraZeneca",{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Crestor","90D","90D","Proposed",1000000,{"$f":"G28/12","v":83333.333333333328},{"$f":"H28","v":83333.333333333328},"2012-08-01","2013-07-30","NA",null,"AZ declined due to legal",null,"P69"]
["Abbott",{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Creon","90D","90D","Proposed",300000,{"$f":"G29/12","v":25000},{"$f":"H29","v":25000},"2012-08-01","2012-07-30","Low",null,"Abbott to propose counter 6/28",null,"P71"]
["Abbott",{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Niaspan/Simcor","90D","90D","Proposed",1000000,{"$f":"G30/12","v":83333.333333333328},{"$f":"H30","v":83333.333333333328},"2012-08-01","2013-07-30","Medium",null,"Abbott to propose counter 6/28",null,"P61"]
["Abbott",{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Norvir Caps to Tabs","ADH","GoodStart","Proposed",null,null,null,"3000-01-01","3000-01-01","NA",null,"Catalina - no direct revenue",null,"P37"]
["Abbott",{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Synthroid","90D","90D","Proposed",300000,{"$f":"G32/12","v":25000},{"$f":"H32","v":25000},"2012-08-01","2013-07-30","Low",null,"Abbott to propose counter 6/28",null,"P62"]
["Abbott",{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Tricor/Trilipix","90D","90D","Proposed",1000000,{"$f":"G33/12","v":83333.333333333328},{"$f":"H33","v":83333.333333333328},"2012-08-01","2013-07-30","Low",null,"Abbott to propose counter 6/28",null,"P60"]
["Acurian",{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"COPD (1823)","CTR","Direct Mail","Complete - Ct",null,null,null,"2012-04-01","2012-04-01","NA",237368,null,null,"P1"]
["Acurian",{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Gout CTR mailing (2029)","CTR","Direct Mail","Complete - Ct",null,null,null,"2012-05-22","2012-05-22","NA",156115,null,null,"P74"]
["Acurian",{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"IBS (1964)","CTR","Direct Mail","Complete - Ct",null,null,null,"2012-06-15","2012-06-15","NA",61261,null,null,"P83"]
["Acurian",{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"MDD (1914)","CTR","Direct Mail","Complete - Ct",null,null,null,"2011-12-13","2011-12-13","NA",2741291,null,null,"P80"]
["Acurian",{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Painful Diabetic Peripheral Neuropathy (1870)","CTR","Direct Mail","Complete - Ct",null,null,null,"2011-12-13","2011-12-13","NA",173028,"Counts only.",null,"P30"]
["Acurian",{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Parkinson's CTR (1929)","CTR","Direct Mail","Complete - Ct",null,null,null,"2012-04-01","2012-04-01","NA",10845,"Counts only.",null,"P47"]
["Acurian",{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Rheumatoid Arthritis (2012)","CTR","Direct Mail","Complete - Ct",null,null,null,"2012-06-20","2012-06-20","NA",87913,"Counts only.",null,"P82"]
["Acurian",{"$f":"IF(A41=\"\",\"\",VLOOKUP(A41,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Rosacea (1942)","CTR","Direct Mail","Complete - Ct",null,null,null,"2012-01-25","2012-01-25","NA",627029,"Counts only.",null,"P81"]
["Acurian",{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"MDD (1939)","CTR","Direct Mail","Complete - Ct",null,null,null,"2012-08-02","2012-08-02","NA",16426,"Counts only.",null,"P86"]
["Acurian",{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Post-MI (2043)","CTR","Direct Mail","Complete - Ct",null,null,null,"2012-07-06","2012-07-06","NA",662192,"Counts only.",null,"P87"]
["Acurian",{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"High Triglycerides (2038)","CTR","Direct Mail","Complete - Ct",null,null,null,"2012-08-08","2012-08-10","NA",68673,"Counts only.",null,"P89"]
["Acurian",{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"GregL"},"Diabetic Neuropathy (2069)","CTR","Direct Mail","Complete - Ct",null,null,null,"2012-08-10","2012-08-13","NA",389152,"Counts only.",null,"P89"]
["BMS",{"$f":"IF(A46=\"\",\"\",VLOOKUP(A46,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Atripla Face to face","ADH","F2F","Proposed",300000,{"$f":"G46/12","v":25000},{"$f":"H46*2","v":50000},"2012-07-01","2013-07-01","Medium",null,null,null,"P56"]
["BMS",{"$f":"IF(A47=\"\",\"\",VLOOKUP(A47,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"CathyP"},"Onglyza Family","90D","90D","Proposed",170000,14166.666666666666,{"$f":"H47*2","v":28333.333333333332},"2013-01-01","2014-06-30","NA",null,null,null,"P70"]
["Boehringer",{"$f":"IF(A48=\"\",\"\",VLOOKUP(A48,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Combivent","90D","90D","Proposed",0,0,{"$f":"H48","v":0},"2013-01-01","2013-07-30","NA",null,null,null,"P66"]
["Boehringer",{"$f":"IF(A49=\"\",\"\",VLOOKUP(A49,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Micardis","90D","90D","Proposed",0,0,{"$f":"H49","v":0},"2013-01-01","2013-07-30","NA",null,null,null,"P67"]
["Boehringer",{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Spiriva","90D","90D","Proposed",1400000,116666.66666666667,{"$f":"H50","v":116666.66666666667},"2013-01-01","2013-07-30","NA",null,null,null,"P65"]
["Boehringer",{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Tradjenta Family","90D","90D","Proposed",0,0,{"$f":"H51","v":0},"2013-01-01","2013-07-30","NA",null,null,null,"P68"]
["Lilly",{"$f":"IF(A52=\"\",\"\",VLOOKUP(A52,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Cymbalta","90D","90D","Proposed",1500000,125000,0,"2013-01-01","2014-12-31","Low",null,null,null,"P72"]
["Abbott","MaryT","Synthroid","90D","90D"]
["AstraZeneca",{"$f":"IF(A54=\"\",\"\",VLOOKUP(A54,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Nexium","90D","90D"]
["AstraZeneca",{"$f":"IF(A55=\"\",\"\",VLOOKUP(A55,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Crestor","90D","90D"]
["Chelsea Therapeutics",{"$f":"IF(A56=\"\",\"\",VLOOKUP(A56,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"TomR"},null,"CTR","Direct Mail","Develop",null,null,null,null,null,"NA",null,null,null,"P85"]
["Galderma",{"$f":"IF(A57=\"\",\"\",VLOOKUP(A57,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Oracea","Education","MPU","Develop",25000,25000,25000,"2012-07-15","2012-08-06",null,"Not Started","Complete",null,null,null,null,null,null,"8/30 On hold. 7/31Follow up with Van on contract",null,"D57"]
["Novo Nordisk","MaryT","Victoza Enhancements (add Catalina) \n[this program is directily between Novo and Catalina]","Adherence","Other","Develop",254845,21237,127422,"2012-04-01",null,"2012-12-31","Draft","O - Approval",null,null,null,null,null,null,null,null,"D50"]
["Sunovion",{"$f":"IF(A59=\"\",\"\",VLOOKUP(A59,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Latuda","Education","MPU","Develop",25000,25000,25000,"2012-08-01","2012-08-19",null,null,"Draft",null,null,null,null,null,null,"7/31 On hold. Send first draft this week to Sunovion"]
["Takeda",{"$f":"IF(A60=\"\",\"\",VLOOKUP(A60,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Prevacid Solutab MPU","Education","MPU","Develop",25000,25000,25000,"2012-09-01","2012-09-01",null,"Not Started",null,null,null,null,null,null,null,"on hold",null,"D65"]
["UCB",{"$f":"IF(A61=\"\",\"\",VLOOKUP(A61,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Neupro","Education","MPU","Develop",25000,25000,25000,"2012-07-15","2012-08-06",null,"Not Started","Draft",null,null,"NA","NA","NA",null,null,null,"D58"]
["Eisai",{"$f":"IF(A62=\"\",\"\",VLOOKUP(A62,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Aciphex direct mailing","Adherence","DM","Proposed",127000,127000,127000,"2012-09-01","2013-03-31","Low",null,"Make patients aware of co-pay offer",null,"P78"]
["Teva",{"$f":"IF(A63=\"\",\"\",VLOOKUP(A63,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Q-Nasal Launch Playbook","Other","Other","Canceled - E",4904802,700686,"Catalina Campaign","3000-01-01","3000-01-01",null,null,null,null,"P34"]
["Teva",{"$f":"IF(A64=\"\",\"\",VLOOKUP(A64,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"QNASL Launch Playbook","Other","Other","Canceled - E",407640,135880,"RxEdge (pricing for 6800 stores) (3500 stores $262,500 12 wks or $87,500 per month)"]
["Teva",{"$f":"IF(A65=\"\",\"\",VLOOKUP(A65,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"QNASL Launch Playbook","ADH","Direct Mail","Canceled - E",244000,null,"&PCC"]
["J&J (Janssen)",{"$f":"IF(A66=\"\",\"\",VLOOKUP(A66,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Simponi","RPh Service","SAR","Proposed",126000,{"$f":"G66/12","v":10500},{"$f":"H66*2","v":21000},"2012-06-01","2013-06-01","Low",null,null,null,"P55"]
["J&J (Janssen)",{"$f":"IF(A67=\"\",\"\",VLOOKUP(A67,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Xarelto","Adherence","IVR","Proposed",145000,{"$f":"G67/12","v":12083.333333333334},{"$f":"H67*2","v":24166.666666666668},"2012-06-01","2013-06-01","Low",null,null,null,"P54"]
["Lilly",{"$f":"IF(A68=\"\",\"\",VLOOKUP(A68,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Glucagon hyperglycemia","Adherence","DM","Proposed",38000,38000,38000,"2012-09-01","2013-03-31","Low",null,null,null,"P51"]
[]
["Amgen",{"$f":"IF(A70=\"\",\"\",VLOOKUP(A70,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"Enbrel SAR","RPH Service","SAR"]
["Gilead",{"$f":"IF(A71=\"\",\"\",VLOOKUP(A71,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"MaryT"},"HIV Quad Pill Launch","Other","Other"]
["J&J (Janssen)",{"$f":"IF(A72=\"\",\"\",VLOOKUP(A72,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Invega/Risperdol","RPH Service","SAR",null,200000,{"$f":"G72/12","v":16666.666666666668},{"$f":"H72*3","v":50000}]
["Lilly",{"$f":"IF(A73=\"\",\"\",VLOOKUP(A73,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Livalo","Adherence","DM"]
["Merck",{"$f":"IF(A74=\"\",\"\",VLOOKUP(A74,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Respiratory PSC","PSC","Rebate"]
["Merck",{"$f":"IF(A75=\"\",\"\",VLOOKUP(A75,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Singulair LOE","Other"]
["Merck",{"$f":"IF(A76=\"\",\"\",VLOOKUP(A76,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Vytorin","Adherence","DM","Proposed"]
["Novo Nordisk","MaryT","FlexPen (Novolog, Levamir)","Education","DM",null,null,null,"Vial to Pen"]
["Takeda",{"$f":"IF(A78=\"\",\"\",VLOOKUP(A78,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Actos LOE","Other","Other"]
["Takeda",{"$f":"IF(A79=\"\",\"\",VLOOKUP(A79,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Actos LOE - Patient Soft Lauch","Education","DM",null,250000,{"$f":"G79","v":250000},{"$f":"H79","v":250000}]
["UCB",{"$f":"IF(A80=\"\",\"\",VLOOKUP(A80,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Nuepro","Adherence","DM",null,150000,{"$f":"G80/12","v":12500},"Maybe Pleio.  Q2'12 Launch"]
["Lilly",{"$f":"IF(A81=\"\",\"\",VLOOKUP(A81,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"BrianS"},"Axiron Face to Face","RPh Service","ADH","Proposed",1259280,{"$f":"G81/12","v":104940},{"$f":"H81*5","v":524700},"2012-07-01","2013-07-31","Low",null,null,null,"P53"]
["Boehringer",{"$f":"IF(A82=\"\",\"\",VLOOKUP(A82,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Pradaxa Physician Mailing","Education","DM","Develop",75000,{"$f":"IF(L82=K82,G82,G82/((L82-K82)/30))","v":75000},{"$f":"IF(L82=K82,G82,(IF(41517<L82,41517,L82)-K82)/30*H82)","v":75000},"2012-09-30","2012-12-01","2012-12-01","Review","Draft",null,null,null,null,null,null,"10/02 Letters completed in review at BI, contract in Wag legal "]
["Daiichi Sankyo",{"$f":"IF(A83=\"\",\"\",VLOOKUP(A83,'Pharma Names'!$A$2:$B$124,2,FALSE))","v":"VanA"},"Welchol","Adherence","DM","Develop",359100,{"$f":"G83/12","v":29925},{"$f":"H83*5","v":149625},"2012-10-31","2012-12-11",null,"Review","O - Approval",null,null,null,null,null,null,"10/16 Letters will be with Adheris, MSA w/mfg  SOW w/Wag    "]
["Salix","CathyP","Relistor","Education","MPU","Develop",25000,25000,25000,"2012-10-02","2012-10-02",{"$f":"K84","v":"2012-10-02"},"O - Review","Complete",null,null,null,null,null,null,"6/12 Waiting as of 5/22 for Salix's response to the agreement ON HOLD"]

{"sheet":"Archieved","index":8,"n_rows":58,"n_cols":19,"rows_kept":58,"cut":false,"hidden":true,"merged":[[0,0,0,18]]}
["Archived Programs (Completed prior to FY'12)"]
[]
["Client","Program Name","Solution","Product","Status","NPAD","Estimated Contract Value","Estimated Monthly Value","Estimated FY Contract","Target Start Date","Expiration Date","Renewal Process","Target Enrollment","Enrollment to Date","Contract to Date Activity","Next Report Due Date","Latest Report Results","PCC #","Comments"]
["GSK","Vesicare","ADH","Direct Mail","Completed","NA",106139.8,null,null,"2010-02-09","2010-08-12",null,"(80,190 ltrs)",null,null,null,8333]
["Novartis","Diovan, Diovan HCT","ADH","Direct Mail","Completed","NA",1487307.9500000002,null,null,"2009-07-06","2010-10-13",null,null,null,null,null,"8233 & 8234"]
["GSK","Lovaza","ADH","Direct Mail","Completed","NA",771004.84000000008,null,null,"2009-04-23","2010-12-15",null,52200,null,null,null,"8193"]
["Lilly","Strattera","ADH","Direct Mail","Completed","NA",70697.45,null,null,"2010-04-09","2010-12-16",null,"(96,154 ltrs)",null,null,null,8096]
["Amylin","Byetta","ADH","Direct Mail","Completed","NA",97474,null,null,"2010-02-19","2010-12-31",null,22500,null,null,null,8275]
["Lilly","Cymbalta","ADH","Direct Mail","Completed","NA",645041.80000000005,null,null,"2009-02-01","2011-01-11",null,104500,null,null,null,7493,"(324,368 ltrs)"]
["Sanofi-BMS","Plavix Zero Refill","ADH","Direct Mail","Completed","NA",48942.400000000001,null,null,"2010-08-02","2010-12-31",null,75000,null,null,null,8285]
["Takeda","Actos, ActosPLUS met","ADH","Direct Mail","Completed","NA",394194,null,null,"2009-03-16","2011-03-31",null,100400,null,null,null,"8173 & 8174"]
["Abbott","Niaspan/Simcor IVR","ADH","Direct Mail","Completed","NA",200000,null,null,"2010-08-05","2011-05-30",null,48000,null,null,null,"N/A"]
["Abbott","Tricor/Trilipix","ADH","Direct Mail","Completed","NA",660000,null,null,"2010-05-01","2011-07-31",null,110180,null,null,null,"8393 & 8394"]
["Sanofi","Multaq","ADH","Direct Mail","Completed","NA",81250,null,null,"2010-03-15","2011-07-31",null,20000,null,null,null,8295]
["SDI","Suboxone REMS","REMS","Direct Mail","Completed","NA",10625,null,null,"2010-11-12","2010-11-29"]
["SDI","Forteo REMS","REMS","Direct Mail","Completed","NA",11507.5,null,null,"2010-11-16","2010-11-19"]
["SDI","Androgel REMS","REMS","Direct Mail","Completed","NA",9375,null,null,"2010-11-29","2010-12-13"]
["SDI","Colcrys REMS","REMS","Direct Mail","Completed","NA",9375,null,null,"2010-12-06","2011-01-10"]
["SDI","Zonegran REMS","REMS","Direct Mail","Completed","NA",9375,null,null,"2010-12-10","2011-01-14"]
["Pinney","Edluar",null,null,"Completed","NA",4710,null,null,"2011-02-18","2011-03-09",null,null,null,null,null,"8813","(+884 repeat)"]
["Acurian","Depression Clinical Trial notice - 1st batch","CTR","Direct Mail","Completed","NA",92733,null,null,"2011-02-18","2011-02-28",null,null,null,null,null,"8853","2 mailings"]
["Acurian","Depression Clinical Trial notice - 2nd batch, w76-w77","CTR","Direct Mail","Completed","NA",93455,null,null,"2011-04-28","2011-04-28",null,null,null,null,null,"8853"]
["Acurian","Bipolar Disorder Clinical Trial notice","CTR","Direct Mail","Completed","NA",29866,null,null,"2011-05-05","2011-05-05"]
["Acurian","Depression Clinical Trial notice - 3rd batch, w 78 , w79","CTR","Direct Mail","Completed","NA",222818,null,null,"2011-05-18","2011-05-27",null,null,null,null,null,"8853"]
["Acurian","Depression Clinical Trial notice - 4th batch, w113, w121","CTR","Direct Mail","Completed","NA",109052,null,null,"2011-06-21","2011-06-21",null,null,null,null,null,"8853"]
["Acurian","Opioid Induced Constipation, w12, w22","CTR","Direct Mail","Completed","NA",29192,null,null,"2011-06-03","2011-06-03"]
["SDI","Zortress REMS survey","REMS","Direct Mail","Completed","NA",7563,null,null,"2011-06-09","2011-06-16"]
["Novartis","Diovan F2F","ADH","F2F","Completed","NA",344107.80000000005,null,null,"OKC -8/4/2009","2010-10-19",null,null,null,null,null,null,"8278 & 8279"]
["Novarrtis","Diovan HCT F2F","ADH","F2F","Completed","NA",null,null,null,"NJ - 8/6/2009","2010-10-19",null,null,null,null,null,null,"8281 & 8282"]
["Sunovion","   Latuda","EDU","Fax","Completed","NA",20000,null,null,"2011-02-18",null,null,null,null,null,null,null,null,"Bulletin"]
["Allergan","Zymar D/C notice","EDU","Fax","Completed","NA",20000,null,null,"2011-04-08",null,null,null,null,null,null,null,null,"Store Bulletin"]
["Ferring","Lysteda","EDU","RxNews","Completed","NA",25000,null,null,"2011-04-08",null,null,null,null,null,null,null,null,"RxNews"]
["Silenor","Somaxon","EDU","RxNews","Completed","NA",25000,null,null,"2011-04-14",null,null,null,null,null,null,null,null,"RxNews"]
["Abbott","Androgel 1.62%","EDU","Fax","Completed","NA",15000,null,null,"2011-06-10",null,null,null,null,null,null,null,null,"NPI"]
["B&L","Zirgan","EDU","Fax","Completed","NA",null,null,null,"2011-07-07",null,null,null,null,null,null,null,null,"MPU"]
["SDI","Factive REMS","REMS","Direct Mail","Completed","NA",17500,null,null,"2011-03-03","2011-03-21",null,null,4000,null,null,null,"8834"]
["SDI","Seroquel REMS","REMS","Direct Mail","Completed","NA",{"$f":"7500+2000*2.5","v":12500},null,null,"2011-02-21","2011-03-28",null,null,2000,null,null,null,"8833"]
["Sanofi","Lantus Opticlik D/C","EDU","Direct Mail","Completed","NA",18962.2,null,null,"2011-01-18","--",null,null,3447,null,null,null,8758]
["SDI","Byetta REMS","REMS","Direct Mail","Completed","NA",10000,null,null,"2011-01-26","--",null,null,1000,null,null,null,"8793"]
["SDI","Qualaquin REMS survey","REMS","Direct Mail","Completed","NA",{"$f":"7500+750","v":8250},null,null,"2011-08-17",null,null,null,300]
["NovoNordisk","Pleio GoodStart Pgm","ADH","GoodStart","Completed","NA",null,null,null,"2011-06-16",null,null,null,null,null,null,null,"Pleio"]
["SDI","Suboxone REMS survey","REMS","Direct Mail","Completed","NA",{"$f":"7500+63","v":7563},null,null,"2011-06-24",null,null,null,1500]
["Perrigo","Wal-Fex Allergy OTC notice","OTHER","Direct Mail","Completed","NA",150000,null,null,"2011-04-15",null,null,null,"est 150,000",null,null,null,"N/A"]
["Acurian","Opioid Induced Constipation, w40","CTR","Direct Mail","Completed","NA",119489,null,null,"2011-06-24",null,null,null,119485]
["Acurian","Opioid Induced Constipation, wave 126","CTR","Direct Mail","Completed","NA",21504,null,null,"2011-08-25",null,null,null,21504]
["Acurian","Opioid Induced Constipation, wave w113","CTR","Direct Mail","Completed","NA",36894,null,null,"2011-08-16",null,null,null,36894]
["Acurian","Opioid Induced Constipation, wave w83","CTR","Direct Mail","Completed","NA",11007,null,null,"2011-07-20",null,null,null,11007]
["Acurian","Opioid Induced Constipation, wavie w72","CTR","Direct Mail","Completed","NA",13929,null,null,"2011-07-08",null,null,null,13929]
["Acurian","PAH, wave w1","CTR","Direct Mail","Completed","NA",8461,null,null,"2011-07-29",null,null,null,961,null,null,null,"1643"]
["Amylin","Byetta","ADH","Direct Mail","Active","Jen L.",111000,null,null,"2011-07-09","2012-03-30",null,null,5043,null,null,null,"1925-01-01"]
["B & L","Zirgan Physician Letter","EDU","Direct Mail","Completed","NA",null,null,null,"2011-07-08",null,null,null,4000]
["Chattem","Allegra/Allegra D OTC","OTHER","Direct Mail","Completed","NA",357150,null,null,"2011-02-24",null,null,null,359331,null,null,null,"N/A"]
["Daiichi-Sankyo","Sprix Physician Letter",null,"Direct Mail","Completed","NA",{"$f":"10000+14741*2.5","v":46852.5},null,null,"2011-08-11",null,null,null,14741]
["DEY","EpiPen reminder","ADH","Direct Mail","Completed","NA",297000,null,null,"2011-01-06","--",null,null,110000,null,null,null,8756]
["GSK","Avodart","ADH","Direct Mail","Completed","NA",3654,null,null,"2011-05-03","2011-07-01",null,"52,560 ltrs",1446,null,null,null,8954]
["PDI","Dose-Alert time cap","ADH","OTHER","Completed","NA",39000,null,null,"2010-12-22","--",null,null,13400,null,null,null,8755]
["NovoNordisk","Novolog FlexPen","ADH","Direct Mail","Completed","NA",27500,null,null,"2010-10-27",null,null,4000,9683,null,null,null,8533]
["NovoNordisk","Novolog Mix","ADH","Direct Mail","Completed","NA",null,null,null,"2010-08-06",null,null,null,null,null,null,null,"8474"]

{"sheet":"Budget Sheet","index":9,"n_rows":76,"n_cols":48,"rows_kept":76,"cut":false,"hidden":false,"merged":[[46,0,46,2],[60,0,60,7],[2,0,2,14],[0,0,0,14],[1,0,1,14],[5,11,5,14],[5,5,5,9],[5,0,5,3],[40,0,40,9],[24,0,24,3]]}
["FY'13 Accrual to Budget Report"]
["Retail Trade Strategy"]
["(accrual values on this report are not adjusted to match invoices or receivables)"]
[]
[]
["Revenue: YTD",null,null,null,null,"Gross Profit YTD",null,null,null,null,null,"Full FY Projected"]
["Service","Revenue","BUDGET","VAR",null,"GP%","Budg GP%","GP $","Budg GP $","GP Var",null,"Service","Revenue","FY GP%","GP"]
[{"$f":"A27","v":"Adherence"},{"$f":"SUM(B27:M27)","v":7833898.7400000002},{"$f":"SUM(B65:M65)","v":10820000},{"$f":"B8-C8","v":-2986101.26},null,0.56000000000000005,{"$f":"F8","v":0.56000000000000005},{"$f":"F8*B8","v":4386983.2944000009},{"$f":"C8*G8","v":6059200.0000000009},{"$f":"H8-I8","v":-1672216.7056},null,"+Adherence",{"$f":"B8+INDEX(B27:M27,MATCH(9.99999999999999E+307,B27:M27))*COUNTBLANK(B27:M27)","v":9848238.3800000008},{"$f":"O8/M8","v":0.56000000000000005},{"$f":"M8*F8","v":5515013.4928000011}]
["RPh Service",3358691.6,3333333.3333333335,25358.266666666605,null,0.67,0.7,2250323.372,2333333.3333333335,{"$f":"H9-I9","v":-83009.961333333515},null,"RPh Service",{"$f":"B9+INDEX(B28:M28,MATCH(9.99999999999999E+307,B28:M28))*COUNTBLANK(B28:M28)","v":3907379.8},{"$f":"O9/M9","v":0.67},{"$f":"M9*F9","v":2617944.466}]
["Clinical Trials",954759,2900000,-1945241,null,0.45,0.7,429641.55,2029999.9999999998,-1600358.4499999997,null,"Clinical Research",{"$f":"B10+INDEX(B29:M29,MATCH(9.99999999999999E+307,B29:M29))*COUNTBLANK(B29:M29)+250000","v":1507675},{"$f":"1-0.55","v":0.44999999999999996},{"$f":"N10*M10","v":678453.74999999988}]
["PSC",1598000,1665000,-67000,null,1,{"$f":"F11","v":1},1598000,1665000,-67000,null,"PSC",1954000,{"$f":"O11/M11","v":1},{"$f":"M11*F11","v":1954000}]
["Education",432717.5,1350000,-917282.5,null,0.55000000000000004,{"$f":"F12","v":0.55000000000000004},237994.62500000003,742500.00000000012,-504505.37500000012,null,"Education",652717.5,{"$f":"O12/M12","v":0.55000000000000004},358994.625]
["90-Day",743573.65,1066666.6666666667,-323093.01666666672,null,1,{"$f":"F13","v":1},743573.65,1066666.6666666667,-323093.01666666672,null,"90-Day",901573.65,{"$f":"O13/M13","v":1},901573.65]
["Marketing",2736297,891666.66666666651,1844630.3333333335,null,{"$f":"900000/2900000","v":0.31034482758620691},0.8,849195.62068965519,713333.33333333326,135862.28735632193,null,"Marketing",{"$f":"B14+INDEX(B33:M33,MATCH(9.99999999999999E+307,B33:M33))*COUNTBLANK(B33:M33)-974000*2","v":2735924},{"$f":"O14/M14","v":0.31034482758620691},849079.86206896557]
["Data",0,600000,-600000,null,0.9,{"$f":"F15","v":0.9},0,540000,-540000,null,"Data",0,0.9,0]
["Outcomes",0,500000,-500000,null,0.5,{"$f":"F16","v":0.5},0,250000,-250000,null,"Insights",0,0.5,0]
["Other",1296510.3891999999,642444.44444444438,654065.94475555548,null,0.55000000000000004,4.29,713080.71406000003,2756086.6666666665,-2043005.9526066664,null,"Other",1509938.2091999999,0.55000000000000004,830466.01506000001]
[]
["Total",{"$f":"SUM(B8:B18)","v":18954447.8792},{"$f":"SUM(C8:C18)","v":23769111.111111116},{"$f":"SUM(D8:D17)","v":-4814663.2319111107},null,{"$f":"H19/B19","v":0.59135422448521036},{"$f":"I19/C19","v":0.76385355409915745},{"$f":"SUM(H8:H17)","v":11208792.826149656},{"$f":"SUM(I8:I18)","v":18156120},{"$f":"SUM(J8:J18)","v":-6947327.1738503445},null,"Total",{"$f":"SUM(M8:M17)","v":23017446.539199997},{"$f":"O19/M19","v":0.5954407600160031},{"$f":"SUM(O8:O17)","v":13705525.860928968}]
[null,null,null,null,null,null,null,null,null,null,null,"Budget",{"$f":"SUM(B60:M60)","v":30000000.000000004},{"$f":"O20/M20","v":0.76666666666666661},23000000]
[null,null,null,null,null,null,null,null,null,null,null,"Variance",{"$f":"M19-M20","v":-6982553.460800007},{"$f":"(N19-N20)/N19","v":-0.28756161510686912},{"$f":"O19-O20","v":-9294474.1390710324}]
[null,null,null,null,null,null,null,null,null,null,null,"Variance %",{"$f":"M21/M20","v":-0.23275178202666688},null,{"$f":"O21/O20","v":-0.40410757126395791}]
[]
[]
["Monthly Values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FY'13 PROJECTED (current rates)"]
["Service","2012-09-01","2012-10-01","2012-11-01","2012-12-01","2013-01-01","2013-02-01","2013-03-01","2013-04-01","2013-05-01","2013-06-01","2013-07-01","2013-08-01","BUDG LM","Var LM",null,null,null,null,null,null,"PROJECT","BUDGET","VAR",null,null,null,null,null,null,null,null,null,null,null,"Service","Revenue","GP%","GP","Growth Assumptions",null,"Service","Revenue","GP%","GP"]
["Adherence",{"$f":"SUMIFS('Active-Completed'!AH$4:AH$228,'Active-Completed'!$D$4:$D$228,$A27)","v":189092.46},{"$f":"SUMIFS('Active-Completed'!AI$4:AI$228,'Active-Completed'!$D$4:$D$228,$A27)","v":245569.55999999997},{"$f":"SUMIFS('Active-Completed'!AJ$4:AJ$228,'Active-Completed'!$D$4:$D$228,$A27)","v":761987.09},{"$f":"SUMIFS('Active-Completed'!AK$4:AK$228,'Active-Completed'!$D$4:$D$228,$A27)","v":1137240.3899999997},{"$f":"SUMIFS('Active-Completed'!AL$4:AL$228,'Active-Completed'!$D$4:$D$228,$A27)","v":908740.12999999977},{"$f":"SUMIFS('Active-Completed'!AM$4:AM$228,'Active-Completed'!$D$4:$D$228,$A27)","v":754487.34000000008},{"$f":"SUMIFS('Active-Completed'!AN$4:AN$228,'Active-Completed'!$D$4:$D$228,$A27)","v":984377.66000000015},{"$f":"SUMIFS('Active-Completed'!AO$4:AO$228,'Active-Completed'!$D$4:$D$228,$A27)","v":1014582.3099999999},{"$f":"SUMIFS('Active-Completed'!AP$4:AP$228,'Active-Completed'!$D$4:$D$228,$A27)","v":830651.98000000021},{"$f":"SUMIFS('Active-Completed'!AQ$4:AQ$228,'Active-Completed'!$D$4:$D$228,$A27)","v":1007169.82},null,null,{"$f":"N65","v":957000},{"$f":"INDEX(B27:M27,MATCH(9.99999999999999E+307,B27:M27))-N27","v":50169.819999999949},null,null,null,null,null,null,{"$f":"B27+C27+D27+E27+1400000*8","v":13533889.5},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"V27-W27","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,"+Adherence",{"$f":"1300000*12","v":15600000},0.56000000000000005,{"$f":"AL27*AK27","v":8736000},"$1.3 M per Month in Nov'12",null,"+Adherence",1682079,0.2,{"$f":"AR27*AQ27","v":336415.80000000005},{"$f":"AM27-AS27","v":8399584.1999999993},null,{"$f":"COUNTBLANK(B27:M27)","v":2}]
["RPh Service",{"$f":"SUMIFS('Active-Completed'!AH$4:AH$228,'Active-Completed'!$D$4:$D$228,$A28)","v":320715},{"$f":"SUMIFS('Active-Completed'!AI$4:AI$228,'Active-Completed'!$D$4:$D$228,$A28)","v":318323},{"$f":"SUMIFS('Active-Completed'!AJ$4:AJ$228,'Active-Completed'!$D$4:$D$228,$A28)","v":359696.5},{"$f":"SUMIFS('Active-Completed'!AK$4:AK$228,'Active-Completed'!$D$4:$D$228,$A28)","v":293210.5},{"$f":"SUMIFS('Active-Completed'!AL$4:AL$228,'Active-Completed'!$D$4:$D$228,$A28)","v":332160},{"$f":"SUMIFS('Active-Completed'!AM$4:AM$228,'Active-Completed'!$D$4:$D$228,$A28)","v":371653.5},{"$f":"SUMIFS('Active-Completed'!AN$4:AN$228,'Active-Completed'!$D$4:$D$228,$A28)","v":376377.5},{"$f":"SUMIFS('Active-Completed'!AO$4:AO$228,'Active-Completed'!$D$4:$D$228,$A28)","v":330258},{"$f":"SUMIFS('Active-Completed'!AP$4:AP$228,'Active-Completed'!$D$4:$D$228,$A28)","v":381953.5},{"$f":"SUMIFS('Active-Completed'!AQ$4:AQ$228,'Active-Completed'!$D$4:$D$228,$A28)","v":274344.09999999998},null,null,333333.33333333331,-58989.233333333337,null,null,null,null,null,null,{"$f":"B9+B9/4*8","v":10076074.800000001},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"V28-W28","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,"RPh Service",9035460,0.67,6053758.2000000002,"Grow volume by 2x",null,"RPh Service",{"$f":"AK28","v":9035460},{"$f":"N9","v":0.67},6053758.2000000002]
["Clinical Trials",{"$f":"SUMIFS('Active-Completed'!AH$4:AH$228,'Active-Completed'!$D$4:$D$228,$A29)","v":12075},{"$f":"SUMIFS('Active-Completed'!AI$4:AI$228,'Active-Completed'!$D$4:$D$228,$A29)","v":367067},{"$f":"SUMIFS('Active-Completed'!AJ$4:AJ$228,'Active-Completed'!$D$4:$D$228,$A29)","v":94469.2},{"$f":"SUMIFS('Active-Completed'!AK$4:AK$228,'Active-Completed'!$D$4:$D$228,$A29)","v":101529.8},{"$f":"SUMIFS('Active-Completed'!AL$4:AL$228,'Active-Completed'!$D$4:$D$228,$A29)","v":228160},{"$f":"SUMIFS('Active-Completed'!AM$4:AM$228,'Active-Completed'!$D$4:$D$228,$A29)","v":0},{"$f":"SUMIFS('Active-Completed'!AN$4:AN$228,'Active-Completed'!$D$4:$D$228,$A29)","v":0},{"$f":"SUMIFS('Active-Completed'!AO$4:AO$228,'Active-Completed'!$D$4:$D$228,$A29)","v":0},{"$f":"SUMIFS('Active-Completed'!AP$4:AP$228,'Active-Completed'!$D$4:$D$228,$A29)","v":0},{"$f":"SUMIFS('Active-Completed'!AQ$4:AQ$228,'Active-Completed'!$D$4:$D$228,$A29)","v":151458},null,null,400000,-248542,null,null,null,null,null,null,{"$f":"B10+B10/4*8","v":2864277},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"V29-W29","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,"Clinical Research",5000000,0.5,2500000,"Recruitment via PFP / Observational studies x 4",null,"Clinical Research",3000000,0.5,1500000,{"$f":"AM29-AS29","v":1000000}]
["PSC",{"$f":"SUMIFS('Active-Completed'!AH$4:AH$228,'Active-Completed'!$D$4:$D$228,$A30)","v":140000},{"$f":"SUMIFS('Active-Completed'!AI$4:AI$228,'Active-Completed'!$D$4:$D$228,$A30)","v":158000},{"$f":"SUMIFS('Active-Completed'!AJ$4:AJ$228,'Active-Completed'!$D$4:$D$228,$A30)","v":140000},{"$f":"SUMIFS('Active-Completed'!AK$4:AK$228,'Active-Completed'!$D$4:$D$228,$A30)","v":140000},{"$f":"SUMIFS('Active-Completed'!AL$4:AL$228,'Active-Completed'!$D$4:$D$228,$A30)","v":160000},{"$f":"SUMIFS('Active-Completed'!AM$4:AM$228,'Active-Completed'!$D$4:$D$228,$A30)","v":168000},{"$f":"SUMIFS('Active-Completed'!AN$4:AN$228,'Active-Completed'!$D$4:$D$228,$A30)","v":168000},{"$f":"SUMIFS('Active-Completed'!AO$4:AO$228,'Active-Completed'!$D$4:$D$228,$A30)","v":168000},{"$f":"SUMIFS('Active-Completed'!AP$4:AP$228,'Active-Completed'!$D$4:$D$228,$A30)","v":178000},{"$f":"SUMIFS('Active-Completed'!AQ$4:AQ$228,'Active-Completed'!$D$4:$D$228,$A30)","v":178000},null,null,175000,3000,null,null,null,null,null,null,{"$f":"B11+160000*8","v":2878000},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,"PSC",2016000,1,2016000,"No Private Brand Insulin",null,"PSC",2016000,{"$f":"N11","v":1},2016000]
["Education",{"$f":"SUMIFS('Active-Completed'!AH$4:AH$228,'Active-Completed'!$D$4:$D$228,$A31)","v":24730},{"$f":"SUMIFS('Active-Completed'!AI$4:AI$228,'Active-Completed'!$D$4:$D$228,$A31)","v":52110},{"$f":"SUMIFS('Active-Completed'!AJ$4:AJ$228,'Active-Completed'!$D$4:$D$228,$A31)","v":0},{"$f":"SUMIFS('Active-Completed'!AK$4:AK$228,'Active-Completed'!$D$4:$D$228,$A31)","v":100000},{"$f":"SUMIFS('Active-Completed'!AL$4:AL$228,'Active-Completed'!$D$4:$D$228,$A31)","v":50000},{"$f":"SUMIFS('Active-Completed'!AM$4:AM$228,'Active-Completed'!$D$4:$D$228,$A31)","v":50000},{"$f":"SUMIFS('Active-Completed'!AN$4:AN$228,'Active-Completed'!$D$4:$D$228,$A31)","v":45877.5},{"$f":"SUMIFS('Active-Completed'!AO$4:AO$228,'Active-Completed'!$D$4:$D$228,$A31)","v":0},{"$f":"SUMIFS('Active-Completed'!AP$4:AP$228,'Active-Completed'!$D$4:$D$228,$A31)","v":0},{"$f":"SUMIFS('Active-Completed'!AQ$4:AQ$228,'Active-Completed'!$D$4:$D$228,$A31)","v":110000},null,null,300000,-190000,null,null,null,null,null,null,{"$f":"B12+B12/4*8","v":1298152.5},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,"Education",500000,0.55000000000000004,275000,"No Growth",null,"Education",500000,{"$f":"N12","v":0.55000000000000004},275000]
["90-Day",{"$f":"SUMIFS('Active-Completed'!AH$4:AH$228,'Active-Completed'!$D$4:$D$228,$A32)","v":120000},{"$f":"SUMIFS('Active-Completed'!AI$4:AI$228,'Active-Completed'!$D$4:$D$228,$A32)","v":28000},{"$f":"SUMIFS('Active-Completed'!AJ$4:AJ$228,'Active-Completed'!$D$4:$D$228,$A32)","v":38000},{"$f":"SUMIFS('Active-Completed'!AK$4:AK$228,'Active-Completed'!$D$4:$D$228,$A32)","v":38000},{"$f":"SUMIFS('Active-Completed'!AL$4:AL$228,'Active-Completed'!$D$4:$D$228,$A32)","v":137433.65000000002},{"$f":"SUMIFS('Active-Completed'!AM$4:AM$228,'Active-Completed'!$D$4:$D$228,$A32)","v":68000},{"$f":"SUMIFS('Active-Completed'!AN$4:AN$228,'Active-Completed'!$D$4:$D$228,$A32)","v":68000},{"$f":"SUMIFS('Active-Completed'!AO$4:AO$228,'Active-Completed'!$D$4:$D$228,$A32)","v":68000},{"$f":"SUMIFS('Active-Completed'!AP$4:AP$228,'Active-Completed'!$D$4:$D$228,$A32)","v":99140},{"$f":"SUMIFS('Active-Completed'!AQ$4:AQ$228,'Active-Completed'!$D$4:$D$228,$A32)","v":79000},null,null,216666.66666666666,-137666.66666666666,null,null,null,null,null,null,{"$f":"B13+50000*8","v":1143573.6499999999},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,"90-Day",2448000,1,2448000,"3x Growth + Performance",null,"90-Day",2448000,{"$f":"N13","v":1},2448000]
["Marketing",{"$f":"SUMIFS('Active-Completed'!AH$4:AH$228,'Active-Completed'!$D$4:$D$228,$A33)","v":0},{"$f":"SUMIFS('Active-Completed'!AI$4:AI$228,'Active-Completed'!$D$4:$D$228,$A33)","v":0},{"$f":"SUMIFS('Active-Completed'!AJ$4:AJ$228,'Active-Completed'!$D$4:$D$228,$A33)","v":0},{"$f":"SUMIFS('Active-Completed'!AK$4:AK$228,'Active-Completed'!$D$4:$D$228,$A33)","v":0},{"$f":"SUMIFS('Active-Completed'!AL$4:AL$228,'Active-Completed'!$D$4:$D$228,$A33)","v":0},{"$f":"SUMIFS('Active-Completed'!AM$4:AM$228,'Active-Completed'!$D$4:$D$228,$A33)","v":0},{"$f":"SUMIFS('Active-Completed'!AN$4:AN$228,'Active-Completed'!$D$4:$D$228,$A33)","v":1147852.5},{"$f":"SUMIFS('Active-Completed'!AO$4:AO$228,'Active-Completed'!$D$4:$D$228,$A33)","v":614631},{"$f":"SUMIFS('Active-Completed'!AP$4:AP$228,'Active-Completed'!$D$4:$D$228,$A33)","v":0},{"$f":"SUMIFS('Active-Completed'!AQ$4:AQ$228,'Active-Completed'!$D$4:$D$228,$A33)","v":973813.5},null,null,191666.66666666666,782146.83333333337,null,null,null,null,null,null,2000000,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,"Marketing",10591691,0.31,3283424.21,"Chantix renews plus 2; Bus",null,"Marketing",10591691,{"$f":"AL33","v":0.31},3283424.21]
["Data",{"$f":"SUMIFS('Active-Completed'!AH$4:AH$228,'Active-Completed'!$D$4:$D$228,$A34)","v":0},{"$f":"SUMIFS('Active-Completed'!AI$4:AI$228,'Active-Completed'!$D$4:$D$228,$A34)","v":0},{"$f":"SUMIFS('Active-Completed'!AJ$4:AJ$228,'Active-Completed'!$D$4:$D$228,$A34)","v":0},{"$f":"SUMIFS('Active-Completed'!AK$4:AK$228,'Active-Completed'!$D$4:$D$228,$A34)","v":0},{"$f":"SUMIFS('Active-Completed'!AL$4:AL$228,'Active-Completed'!$D$4:$D$228,$A34)","v":0},{"$f":"SUMIFS('Active-Completed'!AM$4:AM$228,'Active-Completed'!$D$4:$D$228,$A34)","v":0},{"$f":"SUMIFS('Active-Completed'!AN$4:AN$228,'Active-Completed'!$D$4:$D$228,$A34)","v":0},{"$f":"SUMIFS('Active-Completed'!AO$4:AO$228,'Active-Completed'!$D$4:$D$228,$A34)","v":0},{"$f":"SUMIFS('Active-Completed'!AP$4:AP$228,'Active-Completed'!$D$4:$D$228,$A34)","v":0},{"$f":"SUMIFS('Active-Completed'!AQ$4:AQ$228,'Active-Completed'!$D$4:$D$228,$A34)","v":0},null,null,200000,-200000,null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,"Data",0,0.9,0,null,null,"Data",0,{"$f":"N15","v":0.9},0]
["Outcomes",{"$f":"SUMIFS('Active-Completed'!AH$4:AH$228,'Active-Completed'!$D$4:$D$228,$A35)","v":0},{"$f":"SUMIFS('Active-Completed'!AI$4:AI$228,'Active-Completed'!$D$4:$D$228,$A35)","v":0},{"$f":"SUMIFS('Active-Completed'!AJ$4:AJ$228,'Active-Completed'!$D$4:$D$228,$A35)","v":0},{"$f":"SUMIFS('Active-Completed'!AK$4:AK$228,'Active-Completed'!$D$4:$D$228,$A35)","v":0},{"$f":"SUMIFS('Active-Completed'!AL$4:AL$228,'Active-Completed'!$D$4:$D$228,$A35)","v":0},{"$f":"SUMIFS('Active-Completed'!AM$4:AM$228,'Active-Completed'!$D$4:$D$228,$A35)","v":0},{"$f":"SUMIFS('Active-Completed'!AN$4:AN$228,'Active-Completed'!$D$4:$D$228,$A35)","v":0},{"$f":"SUMIFS('Active-Completed'!AO$4:AO$228,'Active-Completed'!$D$4:$D$228,$A35)","v":0},{"$f":"SUMIFS('Active-Completed'!AP$4:AP$228,'Active-Completed'!$D$4:$D$228,$A35)","v":0},{"$f":"SUMIFS('Active-Completed'!AQ$4:AQ$228,'Active-Completed'!$D$4:$D$228,$A35)","v":0},null,null,0,0,null,null,null,null,null,null,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,"Insights",2000000,0.5,{"$f":"AK35*AL35","v":1000000},"Includes Loyalty and Outcomes retrospective analyses",null,"Insights",2000000,{"$f":"AL35","v":0.5},1000000]
["Other",{"$f":"SUMIFS('Active-Completed'!AH$4:AH$228,'Active-Completed'!$D$4:$D$228,$A36)","v":0},{"$f":"SUMIFS('Active-Completed'!AI$4:AI$228,'Active-Completed'!$D$4:$D$228,$A36)","v":189000},{"$f":"SUMIFS('Active-Completed'!AJ$4:AJ$228,'Active-Completed'!$D$4:$D$228,$A36)","v":547123.87999999989},{"$f":"SUMIFS('Active-Completed'!AK$4:AK$228,'Active-Completed'!$D$4:$D$228,$A36)","v":283796.87},{"$f":"SUMIFS('Active-Completed'!AL$4:AL$228,'Active-Completed'!$D$4:$D$228,$A36)","v":18864.559999999998},{"$f":"SUMIFS('Active-Completed'!AM$4:AM$228,'Active-Completed'!$D$4:$D$228,$A36)","v":6569.18},{"$f":"SUMIFS('Active-Completed'!AN$4:AN$228,'Active-Completed'!$D$4:$D$228,$A36)","v":106297.96919999999},{"$f":"SUMIFS('Active-Completed'!AO$4:AO$228,'Active-Completed'!$D$4:$D$228,$A36)","v":31453.599999999999},{"$f":"SUMIFS('Active-Completed'!AP$4:AP$228,'Active-Completed'!$D$4:$D$228,$A36)","v":6690.42},{"$f":"SUMIFS('Active-Completed'!AQ$4:AQ$228,'Active-Completed'!$D$4:$D$228,$A36)","v":106713.91},null,null,91777.777777777781,14936.132222222222,null,null,null,null,null,null,{"$f":"C36","v":189000},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,"Other",3000000,{"$f":"N17","v":0.55000000000000004},{"$f":"AL36*AK36","v":1650000.0000000002},"`",null,"Other",0,0,0,{"$f":"AM36-AS36","v":1650000.0000000002}]
[]
["Total",{"$f":"SUM(B27:B36)","v":806612.46},1358069.56,1941276.6699999997,2093777.5599999996,1835358.3399999999,1418710.02,2896783.1292000003,2226924.91,1496435.9000000001,{"$f":"SUM(K27:K36)","v":2880499.33},0,0,{"$f":"SUM(N27:N37)","v":2865444.444444444},{"$f":"SUM(O27:O37)","v":15054.88555555552},null,null,null,null,null,null,"Chantix"]
["BUDGET",{"$f":"B76","v":720333.33333333326},{"$f":"C76","v":920333.33333333326},1920333.3333333333,2957111.1111111115,3057111.1111111115,3157111.1111111115,2557111.111111111,2557111.111111111,3057111.111111111,{"$f":"K76","v":2865444.444444444},2865444.444444444,3365444.444444444,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AK27:AK38)","v":50191151},{"$f":"AM39/AK39","v":0.5571137910345989},{"$f":"SUM(AM27:AM38)","v":27962182.41},null,null,"Total",{"$f":"SUM(AQ27:AQ38)","v":31273230},{"$f":"AS39/AQ39","v":0.54080113278992936},{"$f":"SUM(AS27:AS38)","v":16912598.210000001}]
["VAR",{"$f":"B38-B39","v":86279.126666666707},437736.2266666668,20943.336666666437,-863333.55111111188,-1221752.7711111116,-1738401.0911111115,339672.01808888931,-330186.20111111086,-1560675.2111111109,{"$f":"K38-K39","v":15054.885555556044},-2865444.444444444,-3365444.444444444,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted to Orig GP",null,0.75,{"$f":"AL40*AK39","v":37643363.25},null,null,"Revenue and GP Assumption assume full credit on all WBAD services"]
[" Expected Revenue and GP reduction due to Hitech/HIPAA not reflected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hitech/HIPAA",null,null,{"$f":"AM27+AM29+AM36","v":12886000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenue and GP Assumption assume full credit on all WBAD services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AT26:AT42)","v":11049584.199999999}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"w/o HiTech","w/ HiTech"]
["FY'13 BUDGET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revenue",{"$f":"AK39","v":50191151},{"$f":"AQ39","v":31273230},{"$f":"AK47-AL47","v":18917921}]
["Service","Sep'12","Oct'12","Nov'12","Dec'12","Jan'13","Feb'13","Mar'13","Apr'13","May'13","Jun'13","Jul'13","Aug'13",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pct GP",{"$f":"AK49/AK47","v":0.5571137910345989},{"$f":"AL49/AL47","v":0.54080113278992936}]
["Adherence",207000,207000,957000,1873666.6666666667,1873666.6666666667,1873666.6666666667,957000,957000,957000,957000,957000,957000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GP",{"$f":"AM39","v":27962182.41},{"$f":"AS39","v":16912598.210000001},{"$f":"AK49-AL49","v":11049584.199999999}]
["RPh Service",333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331]
["*Clinical Trials",0,200000,200000,200000,300000,400000,400000,400000,400000,400000,400000,400000]
["PSC",146666.66666666666,146666.66666666666,146666.66666666666,175000,175000,175000,175000,175000,175000,175000,175000,175000]
["Education",0,0,150000,100000,100000,100000,200000,200000,200000,300000,300000,300000]
["90-Day",33333.333333333336,33333.333333333336,33333.333333333336,100000,100000,100000,150000,150000,150000,216666.66666666666,216666.66666666666,216666.66666666666]
["Marketing",0,0,100000,83333.333333333328,83333.333333333328,83333.333333333328,116666.66666666667,116666.66666666667,116666.66666666667,191666.66666666666,191666.66666666666,191666.66666666666]
["Data",0,0,0,0,0,0,133333.33333333334,133333.33333333334,133333.33333333334,200000,200000,200000]
["Outcomes",0,0,0,0,0,0,0,0,500000,0,0,500000]
["Other",0,0,0,91777.777777777781,91777.777777777781,91777.777777777781,91777.777777777781,91777.777777777781,91777.777777777781,91777.777777777781,91777.777777777781,91777.777777777781]
[]
["Total",{"$f":"SUM(B49:B58)","v":720333.33333333326},920333.33333333326,1920333.3333333333,2957111.1111111115,3057111.1111111115,3157111.1111111115,2557111.111111111,2557111.111111111,3057111.111111111,2865444.444444444,2865444.444444444,3365444.444444444]
["*reduced from $400K to $0 in Feb'13 due to Hitech ($2.8 mil impact)"]
[]
[]
[{"$f":"A48","v":"Service"},"Sep'12","Oct'12","Nov'12","Dec'12","Jan'13","Feb'13","Mar'13","Apr'13","May'13","Jun'13","Jul'13","Aug'13","Last Mo"]
[{"$f":"A49","v":"Adherence"},{"$f":"IF(B27=\"\",\"\",B49)","v":207000},{"$f":"IF(C27=\"\",\"\",C49)","v":207000},957000,1873666.6666666667,1873666.6666666667,1873666.6666666667,957000,957000,957000,957000,"","",{"$f":"INDEX(B65:M65,MATCH(9.99999999999999E+307,B65:M65))","v":957000}]
["RPh Service",{"$f":"IF(B28=\"\",\"\",B50)","v":333333.33333333331},333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,333333.33333333331,"","",333333.33333333331]
["*Clinical Trials",{"$f":"IF(B29=\"\",\"\",B51)","v":0},200000,200000,200000,300000,400000,400000,400000,400000,400000,"","",400000]
["PSC",{"$f":"IF(B30=\"\",\"\",B52)","v":146666.66666666666},146666.66666666666,146666.66666666666,175000,175000,175000,175000,175000,175000,175000,"","",175000]
["Education",{"$f":"IF(B31=\"\",\"\",B53)","v":0},0,150000,100000,100000,100000,200000,200000,200000,300000,"","",300000]
["90-Day",{"$f":"IF(B32=\"\",\"\",B54)","v":33333.333333333336},33333.333333333336,33333.333333333336,100000,100000,100000,150000,150000,150000,216666.66666666666,"","",216666.66666666666]
["Marketing",{"$f":"IF(B33=\"\",\"\",B55)","v":0},0,100000,83333.333333333328,83333.333333333328,83333.333333333328,116666.66666666667,116666.66666666667,116666.66666666667,191666.66666666666,"","",191666.66666666666]
["Data",{"$f":"IF(B34=\"\",\"\",B56)","v":0},0,0,0,0,0,133333.33333333334,133333.33333333334,133333.33333333334,200000,"","",200000]
["Outcomes",{"$f":"IF(B35=\"\",\"\",B57)","v":0},0,0,0,0,0,0,0,500000,0,"","",0]
["Other",{"$f":"IF(B36=\"\",\"\",B58)","v":0},0,0,91777.777777777781,91777.777777777781,91777.777777777781,91777.777777777781,91777.777777777781,91777.777777777781,91777.777777777781,"","",91777.777777777781]
[null,{"$f":"IF(B37=\"\",\"\",B59)","v":""},"","","","","","","","","","",""]
["Total",{"$f":"IF(B38=\"\",\"\",B60)","v":720333.33333333326},920333.33333333326,1920333.3333333333,2957111.1111111115,3057111.1111111115,3157111.1111111115,2557111.111111111,2557111.111111111,3057111.111111111,2865444.444444444,2865444.444444444,3365444.444444444,3365444.444444444]

{"sheet":"Pharma Names","index":10,"n_rows":125,"n_cols":2,"rows_kept":125,"cut":false,"hidden":true,"merged":[]}
["Pharma","NPAD"]
["Abbott","MaryT"]
["Access","BrianS"]
["Acorda","Specialty"]
["Actavis","VanA"]
["Actelion","JenL"]
["Actient","CathyP"]
["Acurian","GregL"]
["Alexion","Specialty"]
["Alkermes","Specialty"]
["Allergan","JenL"]
["Amgen","MaryT"]
["Amneal","BrianS"]
["Amylin","MaryT"]
["Anchen","JenL"]
["Apotex","VanA"]
["Aptalis","????"]
["Astellas","CathyP"]
["AstraZeneca","VanA"]
["Auxilium","Specialty"]
["B&L","BrianS"]
["Baxter","BrianS"]
["Bayer","Specialty"]
["Bayer Diagnostics","????"]
["Biogen","Specialty"]
["Biomarin","Specialty"]
["Biosolutia","Specialty"]
["BMS","CathyP"]
["Boehringer","VanA"]
["Cadence ","MaryT"]
["Celgene","Specialty"]
["Chelsea Therapeutics","TomR"]
["CorePharma","BrianS"]
["Covidien","MaryT"]
["CSL Behring","BrianS"]
["Daiichi Sankyo","VanA"]
["Depuy Mitek","Specialty"]
["DesignRx","Specialty"]
["DEY","CathyP"]
["Edgemont","????"]
["Eisai","VanA"]
["Elan","CathyP"]
["EMD Serono","Specialty"]
["Endo","CathyP"]
["Enzon Biochem","CathyP"]
["Eyetech","Specialty"]
["Falcon ","VanA"]
["Ferring","Specialty"]
["Forest","CathyP"]
["Fougera","VanA"]
["Galderma","VanA"]
["Genentech","JenL"]
["Genzyme","MaryT"]
["Gilead","MaryT"]
["Glenmark","CathyP"]
["Global Health","CathyP"]
["GPC Biotech/Specturm","JenL"]
["GSK","CathyP"]
["Hospira ","CathyP"]
["IMS (was SDI)","GregL"]
["Intermune","Specialty"]
["Ipsen/Tercica","Specialty"]
["J&J","BrianS"]
["J&J (Centocor)","BrianS"]
["J&J (Janssen)","BrianS"]
["Kremmers Urban","BrianS"]
["Lannett","VanA"]
["LEO Pharma","????"]
["Ligand","MaryT"]
["Lilly","BrianS"]
["Lundbeck","VanA"]
["Lupin Pharma","VanA"]
["Meda","CathyP"]
["Medicis","MaryT"]
["Medimmune","Specialty"]
["Merck","VanA"]
["Mylan Specialty","CathyP"]
["Neurogesx","Specialty"]
["Nipro","????"]
["Novartis","JenL"]
["Novartis (Sandoz)","JenL"]
["Novo Nordisk","MaryT"]
["Octa","BrianS"]
["Onyx","MaryT"]
["OSI","VanA"]
["Otsuka","VanA"]
["Paddock","CathyP"]
["PAR","VanA"]
["Pernix ","BrianS"]
["Perrigo","CathyP"]
["Pfizer","JenL"]
["Progenics ","VanA"]
["Prostrakan","Specialty"]
["Purdue","VanA"]
["Qualitest","BrianS"]
["Questcor","JenL"]
["Ranbaxy","VanA"]
["Reckitt Benckiser","VanA"]
["Regeneron","VanA"]
["Salix","CathyP"]
["Sanofi Aventis","MaryT"]
["Santarus","????"]
["SDI","GregL"]
["Shinogi (Victory)","MaryT"]
["Shire","VanA"]
["Smith + Nephew","Specialty"]
["Strativa","VanA"]
["Sunovion","VanA"]
["Takeda","BrianS"]
["Talecris","BrianS"]
["Taro","BrianS"]
["Teva","MaryT"]
["TherRx","Specialty"]
["Trial Accel./Ballenger","GregL"]
["UCB","BrianS"]
["United Therapeutics","Specialty"]
["Upsher-Smith","VanA"]
["URL","VanA"]
["Valeant","JenL"]
["Vertex","Specialty"]
["Alcon","JenL"]
["VisibiltyRx/J Rector","GregL"]
["Warner Chilcott","BrianS"]
["Watson","JenL"]
["Zydus","VanA"]

{"sheet":"Sheet1","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet3","index":13,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,"2011-09","2011-10","2011-11","2011-12","2012-01","2012-02","2012-03","2012-04","2012-05","2012-06","2012-07","2012-08",null,"Totals"]
["Total Revenue",542160.68999999994,833456.78657986142,1552619.5304089012,729506.45,700957.64,1102602.54,1110045.96,1321756.7199999997,{"$f":"J19","v":920000},{"$f":"K19","v":1036000},{"$f":"L19","v":1246000},{"$f":"M19","v":1346000},null,{"$f":"SUM(B2:M2)","v":12441106.316988762}]
["Budget",1062473.58,1062473.58,1062473.58,1062473.58,885411.79,885411.79,885411.79,1721823.58,1721823.58,1721823.58,1721823.58,1721823.58,null,{"$f":"SUM(B3:M3)","v":15515247.59}]
["Variance",-520312.89000000013,-229016.79342013865,490145.95040890109,-332967.13000000012,-184454.15000000002,217190.75,224634.16999999993,-400066.86000000034,{"$f":"J2-J3","v":-801823.58000000007},{"$f":"K2-K3","v":-685823.58000000007},{"$f":"L2-L3","v":-475823.58000000007},{"$f":"M2-M3","v":-375823.58000000007},null,{"$f":"O3-O2","v":3074141.2730112374}]
[]
["Total Running Sums",542160.68999999994,1375617.4765798612,2928237.0069887624,3657743.4569887621,4358701.0969887618,5461303.6369887618,6571349.5969887618,7893106.3169887615,{"$f":"I6+J2","v":8813106.3169887625},{"$f":"J6+K2","v":9849106.3169887625},{"$f":"K6+L2","v":11095106.316988762},{"$f":"L6+M2","v":12441106.316988762}]
["Budget Running Sums",1062473.58,2124947.16,3187420.74,4249894.32,5135306.1100000003,6020717.9000000004,6906129.6900000004,8627953.2699999996,10349776.85,12071600.43,13793424.01,15515247.59]
["Variance (running)",-520312.89000000013,-749329.6834201389,-259183.73301123781,-592150.86301123817,-776605.01301123854,-559414.26301123854,-334780.09301123861,-734846.95301123802,{"$f":"I8+J4","v":-1536670.5330112381},{"$f":"J8+K4","v":-2222494.1130112382},{"$f":"K8+L4","v":-2698317.6930112382},{"$f":"L8+M4","v":-3074141.2730112383}]
[]
["Expected Revenue"]
["Active Programs",null,null,null,null,null,null,null,null,800000,800000,800000,800000]
["CTR",null,null,null,null,null,null,null,null,120000,120000,120000,120000]
["New-90D",null,null,null,null,null,null,null,null,null,null,260000,360000]
["New ADH Let",null,null,null,null,null,null,null,null,null,100000,100000,100000]
["New SAR",null,null,null,null,null,null,null,null,null,24000,24000,24000]
["RPH Alert",null,null,null,null,null,null,null,null,null,50000,50000,50000]
["Goodstart (Benicar)",null,null,null,null,null,null,null,null,null,null,180000,180000]
[]
["Totals",null,null,null,null,null,null,null,null,920000,1036000,1246000,1346000]
[]
[]
[]
["Missing",null,null,null,null,null,null,null,null,"Total FY'11 "]
["Diovan LOE",null,null,null,null,null,null,null,null,600000]
["Lipitor GS/Direct Mail",null,null,null,null,null,null,null,null,400000]
[]
[]
["New 90D"]
["July'12",null,null,null,null,null,null,null,null,"Benicar Family, Welchol, Onglyza,  Travatan Azopt"]
["Aug'12",null,null,null,null,null,null,null,null,"Niaspan/Simcor, Aciphex"]
[]
["New SAR",null,null,null,null,null,null,null,null,"Prolia, Prezista"]
["Ned ADH DM",null,null,null,null,null,null,null,null,"Epi-Pen, Lialda, Victoza Enhancements, Effient"]