{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Company Overview Tool","Data","DataSearch"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Company Overview Tool","index":0,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,13,2,17],[16,16,16,17],[19,16,19,17],[20,16,20,17],[4,17,14,17],[3,1,5,11],[16,13,17,13],[19,13,20,13],[22,14,22,17],[17,16,17,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"make selections in green cells below\nuse ribbon for controls"]
[]
[null,{"$f":"O5 & IF(O6=\"\",\" Stock Performance Over Time\",\" and Competitor Stock Performance Over Time\")","v":"AAPL and Competitor Stock Performance Over Time"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:","AAPL",null,null,"colors for line graph. change to desired color scheme!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:","FB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:","TWTR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:","LNKD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ticker:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"begin:",1,"January",2015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"day","month","year"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"end:",28,"March",2015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"day","month","year"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"increment:","weekly"]

{"sheet":"Data","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,"AAPL","FB","TWTR","LNKD"]
["2015-03-23",127.12,83.92,48.24,264.25]
["2015-03-16",123.88,77.959999999999994,46.9,259.8]
["2015-03-09",127.96,79.680000000000007,47.22,264.45]
["2015-03-02",129.25,79,48.26,267.45]
["2015-02-23",130.02000000000001,79.959999999999994,49.02,267]
["2015-02-17",127.49,75.3,48.2,269.63]
["2015-02-09",118.55,74.05,46.73,262.75]
["2015-02-02",118.05,76.11,37.700000000000003,225.55]
["2015-01-26",113.74,77.98,39.33,232.21]
["2015-01-20",107.84,75.72,37.590000000000003,215.22]
["2015-01-12",112.6,77.84,40.28,226.61]
["2015-01-05",108.29,77.98,36.26,227.99]
["2015-01-02",111.39,78.58,36.229999999999997,230.74]

{"sheet":"DataSearch","index":2,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
["January",0,null,{"$f":"VLOOKUP('Company Overview Tool'!$P$17,DataSearch!$A$1:$B$12,2,FALSE)","v":0},{"$f":"'Company Overview Tool'!O17","v":1},{"$f":"'Company Overview Tool'!Q17","v":2015},{"$f":"VLOOKUP('Company Overview Tool'!$P$20,DataSearch!$A$1:$B$12,2,FALSE)","v":2},{"$f":"'Company Overview Tool'!O20","v":28},{"$f":"'Company Overview Tool'!Q20","v":2015},{"$f":"VLOOKUP('Company Overview Tool'!O23,DataSearch!$A$14:$B$16,2,FALSE)","v":"w"}]
["February",1]
["March",2,null,"LNKD"]
["April",3]
["May",4]
["June",5]
["July",6]
["August",7]
["September",8]
["October",9]
["November",10]
["December",11]
[]
["daily","d"]
["weekly","w"]
["monthly","m"]
[]
[{"$f":"TODAY()","v":"2015-04-13"},{"$f":"TEXT(A18,\"yyyy\")","v":"2015"},{"$f":"VALUE(B18)","v":2015}]
[{"$f":"A18-365","v":"2014-04-13"},{"$f":"TEXT(A19,\"yyyy\")","v":"2014"},{"$f":"VALUE(B19)","v":2014}]
[{"$f":"A19-365","v":"2013-04-13"},"2013",2013]
["2012-04-13","2012",2012]
["2011-04-14","2011",2011]
["2010-04-14","2010",2010]
["2009-04-14","2009",2009]
["2008-04-14","2008",2008]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]