{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["RESULTS","IndexChange_500","Inputs"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":36,"comments":0,"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":"RESULTS","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"IndexChange_500","index":1,"n_rows":285,"n_cols":31,"rows_kept":285,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,14,0,15]]}
[null,"Additions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","New Year","King Bday","Pres Day","Good Friday","Mem. Day","Indep Day","Labor Day","9-11 and Funerals","Thanksgiving","Christmas",null,"Additional Closures","Reason"]
["Date","Company","Ticker",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1999,null,null,null,null,null,null,null,null,"1999-11-25","1999-12-24"]
[null,null,null,"113 DAYS BEFORE EVENT","10 DAYS AFTER EVENT","BEGIN","end","row number",null,null,null,null,null,null,null,null,null,2000,null,"2000-01-17","2000-02-21","2000-04-21","2000-05-29","2000-07-04","2000-09-04","2001-09-11","2000-11-23","2000-12-25"]
["2000-01-03","NCR Corp.","NCR","1999-07-27","2000-01-18",{"$f":"NETWORKDAYS(D4,$A4,$S$2:$AB$18)","v":113},{"$f":"NETWORKDAYS(E4,$A4,$S$2:$AB$18)","v":-11},{"$f":"ROW()","v":4},"Good",null,{"$f":"D4-1","v":"1999-07-26"},null,null,null,null,null,null,2001,"2001-01-01","2001-01-15","2001-02-19","2001-04-13","2001-05-28","2001-07-04","2001-09-03",{"$f":"Z3+1","v":"2001-09-12"},"2001-11-22","2001-12-25",null,"9/11/2001 - 9/16/2001","9/11 Attacks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2002,"2002-01-01","2002-01-21","2002-02-18","2002-03-29","2002-05-27","2002-07-04","2002-09-02",{"$f":"Z4+1","v":"2001-09-13"},"2002-11-28","2002-12-25"]
["2000-04-17","Altera Corp.","ALTR","1999-11-05","2000-05-02",{"$f":"NETWORKDAYS(D6,$A6,$S$2:$AB$18)","v":113},{"$f":"NETWORKDAYS(E6,$A6,$S$2:$AB$18)","v":-11},{"$f":"ROW()","v":6},"Good",null,null,null,null,null,null,null,null,2003,"2003-01-01","2003-01-20","2003-02-17","2003-04-18","2003-05-26","2003-07-04","2003-09-01",{"$f":"Z5+1","v":"2001-09-14"},"2003-11-27","2003-12-25"]
["2000-05-04","Sapient Corp.","SAPE","1999-11-24","2000-05-18",{"$f":"NETWORKDAYS(D7,$A7,$S$2:$AB$18)","v":112},-11,{"$f":"ROW()","v":7},"Good",null,null,null,null,null,null,null,null,2004,"2004-01-01","2004-01-19","2004-02-16","2004-04-09","2004-05-31","2004-07-05","2004-09-06",{"$f":"Z6+1","v":"2001-09-15"},"2004-11-25","2004-12-24",null,"2004-06-11","Reagan Funeral"]
["2000-05-09","Maxim Integrated Products","MXIM","1999-11-30","2000-05-23",112,-11,{"$f":"ROW()","v":8},"Good",null,null,null,null,null,null,null,null,2005,null,"2005-01-17","2005-02-21","2005-03-25","2005-05-30","2005-07-04","2005-09-05",{"$f":"Z7+1","v":"2001-09-16"},"2005-11-24","2005-12-26"]
["2000-06-02","Agilent Technologies","A","1999-12-23","2000-06-18",112,-11,{"$f":"ROW()","v":9},"Good",null,null,null,null,null,null,null,null,2006,"2006-01-02","2006-01-16","2006-02-20","2006-04-14","2006-05-29","2006-07-04","2006-09-04","2004-06-11","2006-11-23","2006-12-25"]
["2000-06-07","Starbucks Corp.","SBUX","1999-12-29","2000-06-21",112,-11,{"$f":"ROW()","v":10},"Good",null,null,null,null,null,null,null,null,2007,"2007-01-01","2007-01-15","2007-02-19","2007-04-06","2007-05-28","2007-07-04","2007-09-03","2007-01-02","2007-11-22","2007-12-25",null,"2007-01-02","Ford Funeral"]
["2000-06-12","Convergys Corp.","CVG","2000-01-03","2000-06-26",112,-11,{"$f":"ROW()","v":11},"Good",null,null,null,null,null,null,null,null,2008,"2008-01-01","2008-01-21","2008-02-18","2008-03-21","2008-05-26","2008-07-04","2008-09-01","2012-10-29","2008-11-27","2008-12-25"]
["2000-06-20","Sanmina Corp.","SANM","2000-01-11","2000-07-05",112,-11,{"$f":"ROW()","v":12},"Good",null,null,null,null,null,null,null,null,2009,"2009-01-01","2009-01-19","2009-02-16","2009-04-10","2009-05-25","2009-07-03","2009-09-07","2012-10-30","2009-11-26","2009-12-25"]
["2000-06-20","Tiffany & Co.","TIF","2000-01-11","2000-07-05",112,-11,{"$f":"ROW()","v":13},"Good",null,null,null,null,null,null,null,null,2010,"2010-01-01","2010-01-18","2010-02-15","2010-04-02","2010-05-31","2010-07-05","2010-09-06",null,"2010-11-25","2010-12-24"]
["2000-06-30","Broadcom Corporation","BRCM","2000-01-24","2000-07-17",112,-11,{"$f":"ROW()","v":14},"Good",null,null,null,null,null,null,null,null,2011,null,"2011-01-17","2011-02-21","2011-04-22","2011-05-30","2011-07-04","2011-09-05",null,"2011-11-24","2011-12-26"]
["2000-07-26","JDS Uniphase Corp.","JDSU","2000-02-16","2000-08-09",112,-11,{"$f":"ROW()","v":15},"Good",null,null,null,null,null,null,null,null,2012,"2012-01-02","2012-01-16","2012-02-20","2012-04-06","2012-05-28","2012-07-04","2012-09-03",null,"2012-11-22","2012-12-25",null,"10/29/2012-10/30/2013","Hurricane Sandy"]
["2000-08-29","Devon Energy Corp.","DVN","2000-03-22","2000-09-13",112,-11,{"$f":"ROW()","v":16},"Good",null,null,null,null,null,null,null,null,2013,"2013-01-01","2013-01-21","2013-02-18","2013-03-29","2013-05-27","2013-07-04","2013-09-02",null,"2013-11-28","2013-12-25"]
["2000-10-02","Moody's Corp.","MCO","2000-04-25","2000-10-16",112,-11,{"$f":"ROW()","v":17},"Good",null,null,null,null,null,null,null,null,2014,"2014-01-01","2014-01-20","2014-02-17","2014-04-18","2014-05-26","2014-07-04","2014-09-01",null,"2014-11-27","2014-12-25"]
["2000-10-17","Nabors Industries","NBR","2000-05-10","2000-10-31",112,-11,{"$f":"ROW()","v":18},"Good",null,null,null,null,null,null,null,null,2015,"2015-01-01","2015-01-19","2015-02-16","2015-04-03","2015-05-25","2015-07-03","2015-07-07"]
["2000-10-20","Power-One Inc.","PWER","2000-05-15","2000-11-05",112,-11,{"$f":"ROW()","v":19},"Good"]
["2000-11-01","NiSource Inc.","NI","2000-05-25","2000-11-15",112,-11,{"$f":"ROW()","v":20},"Good"]
["2000-11-01","EOG Resources","EOG","2000-05-25","2000-11-15",112,-11,{"$f":"ROW()","v":21},"Good"]
["2000-11-03","BroadVision Inc.","BVSN","2000-05-30","2000-11-19",112,-11,{"$f":"ROW()","v":22},"Good"]
["2000-11-16","Starwood Hotels & Resorts","HOT","2000-06-12","2000-12-03",112,-11,{"$f":"ROW()","v":23},"Good"]
["2000-11-21","Forest Laboratories","FRX","2000-06-15","2000-12-06",112,-11,{"$f":"ROW()","v":24},"Good"]
["2000-12-04","Robert Half International","RHI","2000-06-27","2000-12-18",112,-11,{"$f":"ROW()","v":25},"Good"]
["2000-12-08","MetLife Inc.","MET","2000-07-03","2000-12-25",112,-11,{"$f":"ROW()","v":26},"Good"]
["2000-12-08","Intuit  Inc.","INTU","2000-07-03","2000-12-25",112,-11,{"$f":"ROW()","v":27},"Good"]
["2000-12-11","Vitessa Semiconductor","VTSS","2000-07-05","2000-12-26",112,-11,{"$f":"ROW()","v":28},"Good"]
["2000-12-11","Stryker Corp.","SYK","2000-07-05","2000-12-26",112,-11,{"$f":"ROW()","v":29},"Good"]
["2000-12-11","QLogic Corp.","QLGC","2000-07-05","2000-12-26",112,-11,{"$f":"ROW()","v":30},"Good"]
["2000-12-29","Applied Micro Circuits","AMCC","2000-07-24","2001-01-16",112,-11,{"$f":"ROW()","v":31},"Good"]
["2001-01-12","Noble Drilling Corp.","NE","2000-08-04","2001-01-29",112,-11,{"$f":"ROW()","v":32},"Good"]
["2001-01-29","Jabil Circuit","JBL","2000-08-18","2001-02-12",112,-11,{"$f":"ROW()","v":33},"Good"]
["2001-02-28","Cintas Corporation","CTAS","2000-09-19","2001-03-14",112,-11,{"$f":"ROW()","v":34},"Good"]
["2001-03-30","FIserv Inc.","FISV","2000-10-19","2001-04-16",112,-11,{"$f":"ROW()","v":35},"Good"]
["2001-06-22","Zions Bancorp","ZION","2001-01-12","2001-07-09",{"$f":"NETWORKDAYS(D36,$A36,$S$2:$AB$18)","v":112},{"$f":"NETWORKDAYS(E36,$A36,$S$2:$AB$18)","v":-11},{"$f":"ROW()","v":36},"Good"]
["2001-08-02","PMC-Sierra  Inc.","PMCS","2001-02-23","2001-08-16",112,-11,{"$f":"ROW()","v":37},"Good"]
["2001-08-03","Family Dollar Stores","FDO","2001-02-26","2001-08-19",112,-11,{"$f":"ROW()","v":38},"Good"]
["2001-08-29","CIENA Corp.","CIEN","2001-03-22","2001-09-19",112,-11,{"$f":"ROW()","v":39},"Good"]
["2001-08-29","AmerisourceBergen","ABC","2001-03-22","2001-09-19",112,-11,{"$f":"ROW()","v":40},"Good"]
["2001-08-31","XL Capital","XL","2001-03-26","2001-09-23",112,-11,{"$f":"ROW()","v":41},"Good"]
["2001-08-31","Int'l. Game Technology","IGT","2001-03-26","2001-09-23",112,-11,{"$f":"ROW()","v":42},"Good"]
["2001-10-09","TECO Energy","TE","2001-04-26","2001-10-23",112,-11,{"$f":"ROW()","v":43},"Good"]
["2001-11-06","Health Management Assoc.","HMA","2001-05-24","2001-11-20",112,-11,{"$f":"ROW()","v":44},"Good"]
["2001-11-29","NVIDIA Corp.","NVDA","2001-06-18","2001-12-13",112,-11,{"$f":"ROW()","v":45},"Good"]
["2001-11-30","Equity Res.Properties","EQR","2001-06-19","2001-12-16",112,-11,{"$f":"ROW()","v":46},"Good"]
["2001-12-14","Jones Apparel Group","JNY","2001-07-03","2002-01-01",112,-11,{"$f":"ROW()","v":47},"Good"]
["2001-12-31","Waters Corporation","WAT","2001-07-18","2002-01-15",112,-11,{"$f":"ROW()","v":48},"Good"]
["2002-01-16","Plum Creek Timber Co.","PCL","2001-08-02","2002-01-31",112,-11,{"$f":"ROW()","v":49},"Good"]
["2002-01-29","MeadWestvaco Corp.","MWV","2001-08-14","2002-02-12",112,-11,{"$f":"ROW()","v":50},"Good"]
["2002-01-29","ACE Limited","ACE","2001-08-14","2002-02-12",112,-11,{"$f":"ROW()","v":51},"Good"]
["2002-05-14","Apollo Group","APOL","2001-12-03","2002-05-29",112,-11,{"$f":"ROW()","v":52},"Good"]
["2002-06-25","Simon Property Group","SPG","2002-01-15","2002-07-10",112,-11,{"$f":"ROW()","v":53},"Good"]
["2002-07-19","United Parcel Services","UPS","2002-02-08","2002-08-04",112,-11,{"$f":"ROW()","v":54},"Good"]
["2002-07-19","Goldman Sachs Group","GS","2002-02-08","2002-08-04",112,-11,{"$f":"ROW()","v":55},"Good"]
["2002-07-19","Prudential Financial","PRU","2002-02-08","2002-08-04",112,-11,{"$f":"ROW()","v":56},"Good"]
["2002-07-19","eBay Inc.","EBAY","2002-02-08","2002-08-04",112,-11,{"$f":"ROW()","v":57},"Good"]
["2002-07-19","Principal Financial Group","PFG","2002-02-08","2002-08-04",112,-11,{"$f":"ROW()","v":58},"Good"]
["2002-08-13","Monsanto Co","MON","2002-03-06","2002-08-27",112,-11,{"$f":"ROW()","v":59},"Good"]
["2002-11-18","Comcast Corp.","CMCSA","2002-06-12","2002-12-03",112,-11,{"$f":"ROW()","v":60},"Good"]
["2002-12-11","Quest Diagnostics","DGX","2002-07-05","2002-12-26",112,-11,{"$f":"ROW()","v":61},"Good"]
["2003-02-21","AutoNation Inc.","AN","2002-09-12","2003-03-09",112,-11,{"$f":"ROW()","v":62},"Good"]
["2003-03-13","Apartment Investment & Management Co.","AIV","2002-10-02","2003-03-27",112,-11,{"$f":"ROW()","v":63},"Good"]
["2003-03-20","McCormick & Company","MKC","2002-10-09","2003-04-03",112,-11,{"$f":"ROW()","v":64},"Good"]
["2003-03-28","Symantec Corp.","SYMC","2002-10-17","2003-04-13",112,-11,{"$f":"ROW()","v":65},"Good"]
["2003-04-15","Federated Investors Inc.","FII","2002-11-04","2003-04-30",112,-11,{"$f":"ROW()","v":66},"Good"]
["2003-07-16","ProLogis","PLD","2003-02-05","2003-07-30",112,-11,{"$f":"ROW()","v":67},"Good"]
["2003-09-25","Express Scripts","ESRX","2003-04-17","2003-10-09",112,-11,{"$f":"ROW()","v":68},"Good"]
["2003-11-12","BIOGEN IDEC","BIIB","2003-06-06","2003-11-27",112,-11,{"$f":"ROW()","v":69},"Good"]
["2004-02-26","M&T Bank Corp.","MTB","2003-09-17","2004-03-11",112,-11,{"$f":"ROW()","v":70},"Good"]
["2004-03-31","E*Trade Financial","ET","2003-10-21","2004-04-15",112,-11,{"$f":"ROW()","v":71},"Good"]
["2004-04-22","Mylan Laboratories","MYL","2003-11-11","2004-05-06",112,-11,{"$f":"ROW()","v":72},"Good"]
["2004-04-28","Valero Energy","VLO","2003-11-17","2004-05-12",112,-11,{"$f":"ROW()","v":73},"Good"]
["2004-06-30","Regions Financial Corp. (New)","RF","2004-01-21","2004-07-15",112,-11,{"$f":"ROW()","v":74},"Good"]
["2004-06-30","Gilead Sciences","GILD","2004-01-21","2004-07-15",112,-11,{"$f":"ROW()","v":75},"Good"]
["2004-06-30","Regions Financial Corp. (New)","RF","2004-01-21","2004-07-15",{"$f":"NETWORKDAYS(D76,$A76,$S$2:$AB$18)","v":112},{"$f":"NETWORKDAYS(E76,$A76,$S$2:$AB$18)","v":-11},{"$f":"ROW()","v":76},"Good"]
["2004-08-31","Coach Inc.","COH","2004-03-23","2004-09-15",112,-11,{"$f":"ROW()","v":77},"Good"]
["2004-10-29","Laboratory Corp of America Holdings","LH","2004-05-21","2004-11-14",112,-11,{"$f":"ROW()","v":78},"Good"]
["2004-11-30","L-3 Communications Holdings","LLL","2004-06-23","2004-12-14",112,-11,{"$f":"ROW()","v":79},"Good"]
["2005-02-08","Molson Coors Brewing","TAP","2004-08-31","2005-02-23",112,-11,{"$f":"ROW()","v":80},"Good"]
["2005-03-11","National Oilwell Varco","NOV","2004-10-01","2005-03-28",112,-11,{"$f":"ROW()","v":81},"Good"]
["2005-03-24","Sears Holdings Corp. (Value)","SHLD","2004-10-14","2005-04-10",112,-11,{"$f":"ROW()","v":82},"Good"]
["2005-07-01","D.R. Horton","DHI","2005-01-24","2005-07-18",112,-11,{"$f":"ROW()","v":83},"Good"]
["2005-07-01","Constellation Brands","STZ","2005-01-24","2005-07-18",112,-11,{"$f":"ROW()","v":84},"Good"]
["2005-07-21","Weatherford Int'l","WFT","2005-02-10","2005-08-04",112,-11,{"$f":"ROW()","v":85},"Good"]
["2005-08-10","Tyson Foods","TSN","2005-03-03","2005-08-24",112,-11,{"$f":"ROW()","v":86},"Good"]
["2005-08-11","Vornado Realty Trust","VNO","2005-03-04","2005-08-25",112,-11,{"$f":"ROW()","v":87},"Good"]
["2005-08-12","Murphy Oil","MUR","2005-03-07","2005-08-28",112,-11,{"$f":"ROW()","v":88},"Good"]
["2005-08-18","Public Storage","PSA","2005-03-11","2005-09-01",112,-11,{"$f":"ROW()","v":89},"Good"]
["2005-08-29","Coventry Health Care Inc.","CVH","2005-03-22","2005-09-13",112,-11,{"$f":"ROW()","v":90},"Good"]
["2005-10-03","Lennar Corp.","LEN","2005-04-26","2005-10-17",112,-11,{"$f":"ROW()","v":91},"Good"]
["2005-10-10","Patterson Companies Inc.","PDCO","2005-05-03","2005-10-24",112,-11,{"$f":"ROW()","v":92},"Good"]
["2005-11-18","Amazon.com","AMZN","2005-06-14","2005-12-05",112,-11,{"$f":"ROW()","v":93},"Good"]
["2005-12-01","Genworth Financial Inc.","GNW","2005-06-24","2005-12-15",112,-11,{"$f":"ROW()","v":94},"Good"]
["2005-12-19","Scripps (E.W.) 'A'","SSP","2005-07-13","2006-01-04",112,-11,{"$f":"ROW()","v":95},"Good"]
["2006-01-04","Estee Lauder","EL","2005-07-27","2006-01-19",112,-11,{"$f":"ROW()","v":96},"Good"]
["2006-01-31","VeriSign Inc.","VRSN","2005-08-22","2006-02-14",112,-11,{"$f":"ROW()","v":97},"Good"]
["2006-01-31","Harman Int'l","HAR","2005-08-22","2006-02-14",112,-11,{"$f":"ROW()","v":98},"Good"]
["2006-03-02","Chesapeake Energy Corp.","CHK","2005-09-21","2006-03-16",112,-11,{"$f":"ROW()","v":99},"Good"]
["2006-03-31","Dean Foods","DF","2005-10-20","2006-04-17",112,-11,{"$f":"ROW()","v":100},"Good"]
["2006-03-31","Kimco Realty Corp.","KIM","2005-10-20","2006-04-17",112,-11,{"$f":"ROW()","v":101},"Good"]
["2006-03-31","Boston Properties","BXP","2005-10-20","2006-04-17",112,-11,{"$f":"ROW()","v":102},"Good"]
["2006-03-31","Google Inc.","GOOGL","2005-10-20","2006-04-17",112,-11,{"$f":"ROW()","v":103},"Good"]
["2006-04-19","SanDisk Corp.","SNDK","2005-11-07","2006-05-03",112,-11,{"$f":"ROW()","v":104},"Good"]
["2006-04-21","Legg Mason","LM","2005-11-09","2006-05-07",112,-11,{"$f":"ROW()","v":105},"Good"]
["2006-06-01","Juniper Neworks Inc.","JNPR","2005-12-20","2006-06-15",112,-11,{"$f":"ROW()","v":106},"Good"]
["2006-06-27","CONSOL Energy Inc. ","CNX","2006-01-18","2006-07-12",112,-11,{"$f":"ROW()","v":107},"Good"]
["2006-08-10","Chicago Mercantile Exchange Holdings","CME","2006-03-03","2006-08-24",112,-11,{"$f":"ROW()","v":108},"Good"]
["2006-11-03","Celgene Corp.","CELG","2006-05-30","2006-11-19",112,-11,{"$f":"ROW()","v":109},"Good"]
["2006-11-09","CB Richard Ellis Group","CBG","2006-06-05","2006-11-26",112,-11,{"$f":"ROW()","v":110},"Good"]
["2006-11-09","Fidelity National Information Services","FIS","2006-06-05","2006-11-26",112,-11,{"$f":"ROW()","v":111},"Good"]
["2006-11-16","Cognizant Technology Solutions Corp.","CTSH","2006-06-12","2006-12-03",112,-11,{"$f":"ROW()","v":112},"Good"]
["2006-11-17","Peabody Energy Corp ","BTU","2006-06-13","2006-12-04",112,-11,{"$f":"ROW()","v":113},"Good"]
["2006-11-30","IAC/InterActive Corp.","IACI","2006-06-23","2006-12-14",112,-11,{"$f":"ROW()","v":114},"Good"]
["2006-11-30","Questar Corp.","STR","2006-06-23","2006-12-14",112,-11,{"$f":"ROW()","v":115},"Good"]
["2006-12-01","DirecTV Group Inc. ","DTV","2006-06-26","2006-12-17",112,-11,{"$f":"ROW()","v":116},"Good"]
["2006-12-19","Terex Corp. ","TEX","2006-07-13","2007-01-07",112,-11,{"$f":"ROW()","v":117},"Good"]
["2007-01-03","ENSCO International ","ESV","2006-07-25","2007-01-18",112,-11,{"$f":"ROW()","v":118},"Good"]
["2007-01-09","AvalonBay Communities","AVB","2006-07-31","2007-01-24",112,-11,{"$f":"ROW()","v":119},"Good"]
["2007-01-31","Polo Ralph Lauren Corp. ","RL","2006-08-21","2007-02-14",112,-11,{"$f":"ROW()","v":120},"Good"]
["2007-02-09","Varian Medical Systems","VAR","2006-08-30","2007-02-26",112,-11,{"$f":"ROW()","v":121},"Good"]
["2007-02-14","Hudson City Bancorp.","HCBK","2006-09-05","2007-03-01",112,-11,{"$f":"ROW()","v":122},"Good"]
["2007-02-21","Integrys Energy Group  Inc. ","TEG","2006-09-11","2007-03-07",{"$f":"NETWORKDAYS(D123,$A123,$S$2:$AB$18)","v":112},{"$f":"NETWORKDAYS(E123,$A123,$S$2:$AB$18)","v":-11},{"$f":"ROW()","v":123},"Good"]
["2007-03-01","C.H. Robinson Worldwide","CHRW","2006-09-19","2007-03-15",112,-11,{"$f":"ROW()","v":124},"Good"]
["2007-03-19","Host Hotels & Resorts","HST","2006-10-05","2007-04-02",112,-11,{"$f":"ROW()","v":125},"Good"]
["2007-03-22","Developers Diversified Reaty","DDR","2006-10-10","2007-04-08",112,-11,{"$f":"ROW()","v":126},"Good"]
["2007-03-28","Abercrombie & Fitch Co. ","ANF","2006-10-16","2007-04-12",112,-11,{"$f":"ROW()","v":127},"Good"]
["2007-04-09","Assurant Inc. ","AIZ","2006-10-25","2007-04-23",112,-11,{"$f":"ROW()","v":128},"Good"]
["2007-05-31","Precision Castparts","PCP","2006-12-18","2007-06-14",112,-11,{"$f":"ROW()","v":129},"Good"]
["2007-06-29","General Growth Properties","GGP","2007-01-22","2007-07-16",112,-11,{"$f":"ROW()","v":130},"Good"]
["2007-06-29","Bank of New York Mellon Corp.","BK","2007-01-22","2007-07-16",112,-11,{"$f":"ROW()","v":131},"Good"]
["2007-07-06","American Capital Strategies","ACAS","2007-01-26","2007-07-22",112,-11,{"$f":"ROW()","v":132},"Good"]
["2007-07-11","Akamai Technologies ","AKAM","2007-01-31","2007-07-25",112,-11,{"$f":"ROW()","v":133},"Good"]
["2007-08-24","Leucadia National Corp.","LUK","2007-03-19","2007-09-10",112,-11,{"$f":"ROW()","v":134},"Good"]
["2007-09-07","Microchip Technology","MCHP","2007-03-30","2007-09-23",112,-11,{"$f":"ROW()","v":135},"Good"]
["2007-09-25","IntercontinentalExchange Inc. ","ICE","2007-04-18","2007-10-09",112,-11,{"$f":"ROW()","v":136},"Good"]
["2007-09-26","Tesoro Petroleum Co.","TSO ","2007-04-19","2007-10-10",112,-11,{"$f":"ROW()","v":137},"Good"]
["2007-10-01","Expedia Inc.","EXPE","2007-04-24","2007-10-15",112,-11,{"$f":"ROW()","v":138},"Good"]
["2007-10-05","Noble Energy  Inc.  ","NBL ","2007-04-30","2007-10-21",112,-11,{"$f":"ROW()","v":139},"Good"]
["2007-10-09","Expeditors Int'l.   ","EXPD ","2007-05-02","2007-10-23",112,-11,{"$f":"ROW()","v":140},"Good"]
["2007-10-24","NYSE Euronext  ","NYX ","2007-05-17","2007-11-07",112,-11,{"$f":"ROW()","v":141},"Good"]
["2007-10-25","Jacobs Engineering Group","JEC","2007-05-18","2007-11-08",112,-11,{"$f":"ROW()","v":142},"Good"]
["2007-11-08","Pepco Holdings Inc.","POM","2007-06-04","2007-11-25",112,-11,{"$f":"ROW()","v":143},"Good"]
["2007-11-15","Manitowoc Co.","MTW","2007-06-11","2007-12-02",112,-11,{"$f":"ROW()","v":144},"Good"]
["2007-11-16","American Tower Corp. ","AMT","2007-06-12","2007-12-03",112,-11,{"$f":"ROW()","v":145},"Good"]
["2007-11-26","Transocean Inc. (New)","RIG","2007-06-19","2007-12-10",112,-11,{"$f":"ROW()","v":146},"Good"]
["2007-12-13","GameStop Corp. ","GME","2007-07-09","2007-12-30",112,-11,{"$f":"ROW()","v":147},"Good"]
["2007-12-20","Range Resources Corp. ","RRC","2007-07-16","2008-01-07",112,-11,{"$f":"ROW()","v":148},"Good"]
["2007-12-31","Total System Services","TSS","2007-07-24","2008-01-15",112,-11,{"$f":"ROW()","v":149},"Good"]
["2008-01-28","Cameron International ","CAM","2007-08-17","2008-02-11",112,-11,{"$f":"ROW()","v":150},"Good"]
["2008-03-28","HCP Inc.","HCP","2007-10-17","2008-04-13",112,-11,{"$f":"ROW()","v":151},"Good"]
["2008-06-02","Intuitive Surgical Inc.","ISRG","2007-12-20","2008-06-16",112,-11,{"$f":"ROW()","v":152},"Good"]
["2008-06-06","Southwestern Energy Co.","SWN","2007-12-27","2008-06-22",112,-11,{"$f":"ROW()","v":153},"Good"]
["2008-06-20","Cabot Oil & Gas Corp.","COG","2008-01-11","2008-07-07",112,-11,{"$f":"ROW()","v":154},"Good"]
["2008-06-30","AK Steel Holding Corp.","AKS","2008-01-22","2008-07-15",112,-11,{"$f":"ROW()","v":155},"Good"]
["2008-07-17","MasterCard Inc.","MA","2008-02-07","2008-07-31",112,-11,{"$f":"ROW()","v":156},"Good"]
["2008-07-30","DaVita Inc.","DVA","2008-02-21","2008-08-13",112,-11,{"$f":"ROW()","v":157},"Good"]
["2008-08-20","Invesco Ltd.","IVZ","2008-03-13","2008-09-04",112,-11,{"$f":"ROW()","v":158},"Good"]
["2008-09-12","Salesforce.com","CRM","2008-04-07","2008-09-28",112,-11,{"$f":"ROW()","v":159},"Good"]
["2008-09-12","Fastenal Co.","FAST","2008-04-07","2008-09-28",112,-11,{"$f":"ROW()","v":160},"Good"]
["2008-09-19","Harris Corp.","HRS","2008-04-14","2008-10-05",112,-11,{"$f":"ROW()","v":161},"Good"]
["2008-09-23","Pioneer Natural Resources Co.","PXD","2008-04-16","2008-10-07",112,-11,{"$f":"ROW()","v":162},"Good"]
["2008-09-29","Amphenol Corp.","APH","2008-04-22","2008-10-13",112,-11,{"$f":"ROW()","v":163},"Good"]
["2008-10-01","Flowserve Corp.","FLS","2008-04-24","2008-10-15",112,-11,{"$f":"ROW()","v":164},"Good"]
["2008-10-03","Dr. Pepper Snapple Group Inc.","DPS","2008-04-28","2008-10-19",112,-11,{"$f":"ROW()","v":165},"Good"]
["2008-10-21","NASDAQ OMX Group Inc.","NDAQ","2008-05-14","2008-11-04",112,-11,{"$f":"ROW()","v":166},"Good"]
["2008-10-30","Wisconsin Energy Corp.","WEC","2008-05-23","2008-11-13",112,-11,{"$f":"ROW()","v":167},"Good"]
["2008-11-05","J.M. Smucker Co.","SJM","2008-05-30","2008-11-19",112,-11,{"$f":"ROW()","v":168},"Good"]
["2008-11-12","People's United Financial Inc.","PBCT","2008-06-06","2008-11-27",112,-11,{"$f":"ROW()","v":169},"Good"]
["2008-11-13","DENTSPLY International Inc.","XRAY","2008-06-09","2008-11-30",112,-11,{"$f":"ROW()","v":170},"Good"]
["2008-11-13","Wynn Resorts Ltd.","WYNN","2008-06-09","2008-11-30",112,-11,{"$f":"ROW()","v":171},"Good"]
["2008-11-18","Stericycle Inc.","SRCL","2008-06-12","2008-12-03",112,-11,{"$f":"ROW()","v":172},"Good"]
["2008-12-01","The Dun & Bradstreet Corp.","DNB","2008-06-24","2008-12-15",112,-11,{"$f":"ROW()","v":173},"Good"]
["2008-12-04","Republic Services Inc.","RSG","2008-06-27","2008-12-18",112,-11,{"$f":"ROW()","v":174},"Good"]
["2008-12-18","Equitable Resources Inc.","EQT","2008-07-14","2009-01-05",112,-11,{"$f":"ROW()","v":175},"Good"]
["2008-12-31","SCANA Corp.","SCG","2008-07-24","2009-01-15",{"$f":"NETWORKDAYS(D176,$A176,$S$2:$AB$18)","v":112},{"$f":"NETWORKDAYS(E176,$A176,$S$2:$AB$18)","v":-11},{"$f":"ROW()","v":176},"Good"]
["2008-12-31","FLIR Systems Inc.","FLIR","2008-07-24","2009-01-15",112,-11,{"$f":"ROW()","v":177},"Good"]
["2008-12-31","Owens-Illinois Inc.","OI","2008-07-24","2009-01-15",112,-11,{"$f":"ROW()","v":178},"Good"]
["2009-01-05","Iron Mountain Inc.","IRM","2008-07-28","2009-01-20",112,-11,{"$f":"ROW()","v":179},"Good"]
["2009-01-29","Health Care REIT","HCN","2008-08-20","2009-02-12",112,-11,{"$f":"ROW()","v":180},"Good"]
["2009-02-25","Diamond Offshore Drilling Inc.","DO","2008-09-16","2009-03-11",112,-11,{"$f":"ROW()","v":181},"Good"]
["2009-03-03","Ventas Inc.","VTR","2008-09-22","2009-03-17",112,-11,{"$f":"ROW()","v":182},"Good"]
["2009-03-03","Hormel Foods Corp.","HRL","2008-09-22","2009-03-17",112,-11,{"$f":"ROW()","v":183},"Good"]
["2009-03-26","O'Reilly Automotive Inc.","ORLY","2008-10-15","2009-04-12",112,-11,{"$f":"ROW()","v":184},"Good"]
["2009-03-27","Time Warner Cable Inc.","TWC","2008-10-16","2009-04-13",112,-11,{"$f":"ROW()","v":185},"Good"]
["2009-04-01","Denbury Resources Inc.","DNR","2008-10-21","2009-04-16",112,-11,{"$f":"ROW()","v":186},"Good"]
["2009-06-04","FMC Technologies Inc.","FTI","2008-12-23","2009-06-18",112,-11,{"$f":"ROW()","v":187},"Good"]
["2009-06-08","DeVry Inc.","DV","2008-12-26","2009-06-22",112,-11,{"$f":"ROW()","v":188},"Good"]
["2009-06-30","Quanta Services Inc.","PWR","2009-01-21","2009-07-15",112,-11,{"$f":"ROW()","v":189},"Good"]
["2009-06-30","Western Digital","WDC","2009-01-21","2009-07-15",112,-11,{"$f":"ROW()","v":190},"Good"]
["2009-07-24","Red Hat Inc.","RHT","2009-02-13","2009-08-09",112,-11,{"$f":"ROW()","v":191},"Good"]
["2009-08-18","FMC Corp.","FMC","2009-03-11","2009-09-01",112,-11,{"$f":"ROW()","v":192},"Good"]
["2009-09-08","Airgas Inc.","ARG","2009-03-31","2009-09-22",112,-11,{"$f":"ROW()","v":193},"Good"]
["2009-10-15","First Solar Inc.","FSLR","2009-05-08","2009-10-29",112,-11,{"$f":"ROW()","v":194},"Good"]
["2009-11-05","Priceline.com Inc","PCLN","2009-06-01","2009-11-19",112,-11,{"$f":"ROW()","v":195},"Good"]
["2009-12-18","Cliffs Natural Resources Inc","CLF","2009-07-14","2010-01-05",112,-11,{"$f":"ROW()","v":196},"Good"]
["2009-12-18","Mead Johnson Nutrition Co W/I","MJN","2009-07-14","2010-01-05",112,-11,{"$f":"ROW()","v":197},"Good"]
["2009-12-18","Ross Stores Inc","ROST","2009-07-14","2010-01-05",112,-11,{"$f":"ROW()","v":198},"Good"]
["2009-12-18","Visa Inc","V","2009-07-14","2010-01-05",112,-11,{"$f":"ROW()","v":199},"Good"]
["2009-12-22","Roper Industries Inc","ROP","2009-07-16","2010-01-07",112,-11,{"$f":"ROW()","v":200},"Good"]
["2010-01-28","NRG Energy","NRG","2009-08-19","2010-02-11",112,-11,{"$f":"ROW()","v":201},"Good"]
["2010-02-05","Urban Outfitters","URBN","2009-08-27","2010-02-22",112,-11,{"$f":"ROW()","v":202},"Good"]
["2010-02-11","Berkshire Hathaway B","BRK-B","2009-09-02","2010-02-28",112,-11,{"$f":"ROW()","v":203},"Good"]
["2010-02-26","Discovery Communications Inc","DISCA","2009-09-17","2010-03-14",112,-11,{"$f":"ROW()","v":204},"Good"]
["2010-02-26","Helmerich & Payne Inc","HP","2009-09-17","2010-03-14",112,-11,{"$f":"ROW()","v":205},"Good"]
["2010-03-12","ONEOK Inc","OKE","2009-10-01","2010-03-28",112,-11,{"$f":"ROW()","v":206},"Good"]
["2010-04-29","Cerner Corp","CERN","2009-11-17","2010-05-13",112,-11,{"$f":"ROW()","v":207},"Good"]
["2010-06-25","Carmax Inc","KMX","2010-01-15","2010-07-12",112,{"$f":"NETWORKDAYS(E208,$A208,$S$2:$AB$18)","v":-11},{"$f":"ROW()","v":208},"Good"]
["2010-07-14","ACE Limited","ACE","2010-02-03","2010-07-28",112,-11,{"$f":"ROW()","v":209},"Good"]
["2010-11-16","Ingersoll-Rand Plc","IR","2010-06-10","2010-12-01",112,-11,{"$f":"ROW()","v":210},"Good"]
["2010-12-17","Cablevision Systems Co A","CVC","2010-07-13","2011-01-03",112,-11,{"$f":"ROW()","v":211},"Good"]
["2010-12-17","F5 Networks Inc","FFIV","2010-07-13","2011-01-03",112,-11,{"$f":"ROW()","v":212},"Good"]
["2010-12-17","NetFlix Inc","NFLX","2010-07-13","2011-01-03",112,-11,{"$f":"ROW()","v":213},"Good"]
["2010-12-17","Newfield Exploration Co","NFX","2010-07-13","2011-01-03",112,-11,{"$f":"ROW()","v":214},"Good"]
["2011-01-14","Noble Corp","NE","2010-08-09","2011-01-31",112,-11,{"$f":"ROW()","v":215},"Good"]
["2011-03-31","Edwards Lifesciences Corp","EW","2010-10-21","2011-04-14",112,-11,{"$f":"ROW()","v":216},"Good"]
["2011-04-01","BlackRock Inc","BLK","2010-10-22","2011-04-17",112,-11,{"$f":"ROW()","v":217},"Good"]
["2011-04-27","Chipotle Mexican Grill Inc.","CMG","2010-11-16","2011-05-11",112,-11,{"$f":"ROW()","v":218},"Good"]
["2011-06-01","Alpha Natural Resources","ANR","2010-12-21","2011-06-15",112,-11,{"$f":"ROW()","v":219},"Good"]
["2011-06-02","ProLogis, Inc","PLD","2010-12-22","2011-06-16",112,-11,{"$f":"ROW()","v":220},"Good"]
["2011-07-05","Accenture plc","ACN","2011-01-25","2011-07-19",112,-11,{"$f":"ROW()","v":221},"Good"]
["2011-09-23","Mosaic Co","MOS","2011-04-15","2011-10-09",112,-11,{"$f":"ROW()","v":222},"Good"]
["2011-10-14","TE Connectivity Ltd.","TEL","2011-05-09","2011-10-30",112,-11,{"$f":"ROW()","v":223},"Good"]
["2011-12-16","Borgwarner Inc","BWA","2011-07-12","2012-01-03",112,-11,{"$f":"ROW()","v":224},"Good"]
["2011-12-16","Dollar Tree Inc","DLTR","2011-07-12","2012-01-03",112,-11,{"$f":"ROW()","v":225},"Good"]
["2011-12-16","Perrigo Co","PRGO","2011-07-12","2012-01-03",112,-11,{"$f":"ROW()","v":226},"Good"]
["2012-09-04","LyondellBasell Industries N.V.","LYB","2012-03-27","2012-09-18",{"$f":"NETWORKDAYS(D227,$A227,$S$2:$AB$18)","v":112},{"$f":"NETWORKDAYS(E227,$A227,$S$2:$AB$18)","v":-11},{"$f":"ROW()","v":227},"Good"]
["2012-09-28","Pentair Ltd.","PNR","2012-04-23","2012-10-14",112,-11,{"$f":"ROW()","v":228},"Good"]
["2012-11-30","Dollar General Corp","DG","2012-06-21","2012-12-16",112,-11,{"$f":"ROW()","v":229},"Good"]
["2012-12-11","Garmin Ltd","GRMN","2012-07-02","2012-12-26",112,-11,{"$f":"ROW()","v":230},"Good"]
["2012-12-21","Delphi Automotive PLC","DLPH","2012-07-13","2013-01-08",112,-11,{"$f":"ROW()","v":231},"Good"]
["2013-02-13","PVH Corp","PVH","2012-08-31","2013-02-28",112,-11,{"$f":"ROW()","v":232},"Good"]
["2013-04-30","Regeneron Pharmaceuticals Inc","REGN","2012-11-16","2013-05-14",112,-11,{"$f":"ROW()","v":233},"Good"]
["2013-05-08","Macerich Co","MAC","2012-11-27","2013-05-22",112,-11,{"$f":"ROW()","v":234},"Good"]
["2013-05-23","Kansas City Southern Inc","KSU","2012-12-12","2013-06-07",112,-11,{"$f":"ROW()","v":235},"Good"]
["2013-06-06","General Motors Company","GM","2012-12-26","2013-06-20",112,-11,{"$f":"ROW()","v":236},"Good"]
["2013-06-21","Zoetis Inc  When Issued","ZTS","2013-01-11","2013-07-08",112,-11,{"$f":"ROW()","v":237},"Good"]
["2013-07-08","Nielsen Holdings NV","NLSN","2013-01-28","2013-07-22",112,-11,{"$f":"ROW()","v":238},"Good"]
["2013-09-10","Delta Air Lines","DAL","2013-04-03","2013-09-24",112,-11,{"$f":"ROW()","v":239},"Good"]
["2013-09-20","AMETEK Inc","AME","2013-04-15","2013-10-06",112,-11,{"$f":"ROW()","v":240},"Good"]
["2013-09-20","Vertex Pharmaceuticals Inc","VRTX","2013-04-15","2013-10-06",112,-11,{"$f":"ROW()","v":241},"Good"]
["2013-10-28","Transocean Inc","RIG","2013-05-21","2013-11-11",112,-11,{"$f":"ROW()","v":242},"Good"]
["2013-11-12","Michael Kors Holdings Ltd","KORS","2013-06-06","2013-11-26",112,-11,{"$f":"ROW()","v":243},"Good"]
["2013-12-09","General Growth Properties Inc","GGP","2013-07-02","2013-12-23",112,-11,{"$f":"ROW()","v":244},"Good"]
["2013-12-20","Alliance Data Systems Corp","ADS","2013-07-16","2014-01-07",112,-11,{"$f":"ROW()","v":245},"Good"]
["2013-12-20","Facebook Inc","FB","2013-07-16","2014-01-07",112,-11,{"$f":"ROW()","v":246},"Good"]
["2013-12-20","Mohawk Industries Inc","MHK","2013-07-16","2014-01-07",112,-11,{"$f":"ROW()","v":247},"Good"]
["2014-01-23","Tractor Supply Co","TSCO","2013-08-14","2014-02-06",112,-11,{"$f":"ROW()","v":248},"Good"]
["2014-03-21","Keurig Green Mountain Inc","GMCR","2013-10-10","2014-04-06",112,-11,{"$f":"ROW()","v":249},"Good"]
["2014-04-01","Essex Property Trust","ESS","2013-10-21","2014-04-15",112,-11,{"$f":"ROW()","v":250},"Good"]
["2014-04-30","Under Armour Inc A","UA","2013-11-18","2014-05-14",112,-11,{"$f":"ROW()","v":251},"Good"]
["2014-05-07","Avago Technologies Ltd","AVGO","2013-11-25","2014-05-21",112,-11,{"$f":"ROW()","v":252},"Good"]
["2014-06-20","Cimarex Energy Co","XEC","2014-01-10","2014-07-07",112,-11,{"$f":"ROW()","v":253},"Good"]
["2014-06-30","Affiliated Managers Grp","AMG","2014-01-21","2014-07-15",112,-11,{"$f":"ROW()","v":254},"Good"]
["2014-07-01","Martin Marietta Materials","MLM","2014-01-22","2014-07-16",112,-11,{"$f":"ROW()","v":255},"Good"]
["2014-08-06","Discovery Communications Inc","DISCK","2014-02-27","2014-08-20",112,-11,{"$f":"ROW()","v":256},"Good"]
["2014-08-18","Mallinckrodt plc","MNK","2014-03-11","2014-09-02",112,-11,{"$f":"ROW()","v":257},"Good"]
["2014-09-19","United Rentals Inc","URI","2014-04-11","2014-10-05",112,-11,{"$f":"ROW()","v":258},"Good"]
["2014-09-19","Universal Health Services B","UHS","2014-04-11","2014-10-05",112,-11,{"$f":"ROW()","v":259},"Good"]
["2014-11-04","Level 3 Communications","LVLT","2014-05-29","2014-11-18",112,-11,{"$f":"ROW()","v":260},"Good"]
["2014-12-04","Royal Caribbean Cruises Ltd","RCL","2014-06-27","2014-12-18",112,-11,{"$f":"ROW()","v":261},"Good"]
["2015-01-26","Endo International plc","ENDP","2014-08-15","2015-02-09",112,-11,{"$f":"ROW()","v":262},"Good"]
["2015-01-26","HCA Holdings Inc","HCA","2014-08-15","2015-02-09",112,-11,{"$f":"ROW()","v":263},"Good"]
["2015-03-11","Skyworks Solutions Inc","SWKS","2014-09-30","2015-03-25",112,-11,{"$f":"ROW()","v":264},"Good"]
["2015-03-17","Schein Henry Inc","HSIC","2014-10-06","2015-03-31",112,-11,{"$f":"ROW()","v":265},"Good"]
["2015-03-20","American Airlines Group Inc.","AAL","2014-10-09","2015-04-06",112,-11,{"$f":"ROW()","v":266},"Good"]
["2015-03-20","Equinix Inc","EQIX","2014-10-09","2015-04-06",112,-11,{"$f":"ROW()","v":267},"Good"]
["2015-03-20","Hanesbrands Inc","HBI","2014-10-09","2015-04-06",112,-11,{"$f":"ROW()","v":268},"Good"]
["2015-03-20","SL Green Realty Corp","SLG","2014-10-09","2015-04-06",112,-11,{"$f":"ROW()","v":269},"Good"]
["2015-04-06","Realty Income Corp","O","2014-10-23","2015-04-20",{"$f":"NETWORKDAYS(D270,$A270,$S$2:$AB$18)","v":112},-11,{"$f":"ROW()","v":270},"Good"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,-1]

{"sheet":"Inputs","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["An Event Study - S&P 500 Additions"]
[]
[]
[null,"Place the ticker symbols for any stock which joined the S&P500 index in the highlighted cells below and click the \"Download\"  button. This spreadsheet will do the rest."]
[null,"The ticker symbols for all of the firms that joined the S&P500 are in column C of the IndexChange_500 worksheet"]
[]
[]
[]
[]
[]
[]
[null,null,"Ticker Symbols"]