{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["2012","2013","2014","2015","2016","2017","Today","Stocks"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"2012","index":0,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[26,5,26,6],[4,0,6,6],[0,0,0,6],[9,0,9,6],[2,0,2,1],[3,0,3,1],[7,0,7,6],[2,3,2,5]]}
["Quickie Stock Market Game"]
[]
["Name:"]
["Period:"]
["It's January, 2011, and you have saved $500 to invest in the stock market. There are fifty stocks you can choose from. Click the \"choose stock\" button. Then in column F, choose how many shares of each stock you will purchase. You must stay as close to $500 as possible. "]
[]
[]
["MAKE SURE TO CHECK THE \"ENABLE\" BUTTON BEFORE BEGINNING!"]
[]
[2012]
[]
[1,{"$f":"VLOOKUP(C12,Stocks!$A$2:$J$101,2,FALSE)","v":"Cardinal Health Inc."},15,{"$f":"VLOOKUP(C12,Stocks!$A$2:$J$101,3,FALSE)","v":"CAH"},{"$f":"VLOOKUP(C12,Stocks!$A$2:$D$101,4,FALSE)","v":41.52},null,{"$f":"E12*F12","v":0},null,null,null,null,{"$f":"RANDBETWEEN(1,100)","v":3}]
[2,{"$f":"VLOOKUP(C13,Stocks!$A$2:$J$101,2,FALSE)","v":"Micron"},14,{"$f":"VLOOKUP(C13,Stocks!$A$2:$J$101,3,FALSE)","v":"MU"},{"$f":"VLOOKUP(C13,Stocks!$A$2:$D$101,4,FALSE)","v":7.76},null,{"$f":"E13*F13","v":0},null,null,null,null,{"$f":"RANDBETWEEN(1,100)","v":59}]
[3,{"$f":"VLOOKUP(C14,Stocks!$A$2:$J$101,2,FALSE)","v":"Ebay"},33,{"$f":"VLOOKUP(C14,Stocks!$A$2:$J$101,3,FALSE)","v":"EBAY"},{"$f":"VLOOKUP(C14,Stocks!$A$2:$D$101,4,FALSE)","v":30.63},null,0,null,null,null,null,99]
[4,{"$f":"VLOOKUP(C15,Stocks!$A$2:$J$101,2,FALSE)","v":"Assurant, Inc."},3,{"$f":"VLOOKUP(C15,Stocks!$A$2:$J$101,3,FALSE)","v":"AIZ"},{"$f":"VLOOKUP(C15,Stocks!$A$2:$D$101,4,FALSE)","v":41.17},null,0,null,null,null,null,80]
[5,{"$f":"VLOOKUP(C16,Stocks!$A$2:$J$101,2,FALSE)","v":"Southwest Airlines"},56,{"$f":"VLOOKUP(C16,Stocks!$A$2:$J$101,3,FALSE)","v":"LUV"},{"$f":"VLOOKUP(C16,Stocks!$A$2:$D$101,4,FALSE)","v":8.52},null,0,null,null,null,null,77]
[null,null,null,null,null,null,{"$f":"SUM(G12:G16)","v":0}]
[]
[]
[null,"2012 Increase",null,{"$f":"'2013'!M6","v":0}]
[null,"2013 Increase",null,{"$f":"'2014'!M6","v":0}]
[null,"2014 Increase",null,{"$f":"'2015'!M6","v":0}]
[null,"2015 Increase",null,{"$f":"'2016'!M6","v":0}]
[null,"2016 Increase",null,{"$f":"'2017'!M6","v":0}]
[""]
["","2011 Portfolio:",null,{"$f":"G17+500","v":500}]
[null,"Today's Portfolio:",null,{"$f":"Today!M7","v":0},null,"Print this Page Only!"]
[null,"Cash Assets",null,{"$f":"Today!M8","v":500}]
["","Less Initial Investment:",null,{"$f":"D26","v":500}]
[null,"TOTAL INCREASE:",null,{"$f":"D27+D28-D29","v":0},{"$f":"IF(D39=6,\"COMPLETE\",IF(D39=6,\"INCOMPETE\",IF(D39=8,\"CHECK\")))","v":false}]
[]
[null,null,12,{"$f":"IF('2013'!F37>0,1,0)","v":0}]
[null,null,13,{"$f":"IF('2014'!F41>0,1,0)","v":0}]
[null,null,14,{"$f":"IF('2015'!F37>0,1,0)","v":0}]
[null,null,15,{"$f":"IF('2016'!F40>0,1,0)","v":0}]
[null,null,16,{"$f":"IF('2017'!F39>0,1,0)","v":0}]
[null,null,"Today",{"$f":"IF(Today!H21>0,1,0)","v":0}]
[null,null,null,{"$f":"IF(D30>1200,2,0)","v":0}]
[null,null,null,{"$f":"SUM(D32:D38)","v":0}]

{"sheet":"2013","index":1,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,11,4,12],[11,11,11,12],[0,0,0,9],[1,0,2,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[1,5,2,5],[10,0,11,9],[13,3,13,4],[23,1,23,4],[21,0,21,9],[24,2,24,3],[1,6,2,6]]}
[2013]
["2011 Investment Portfolio",null,null,null,"Jan, 2012","# of Shares","Total","Jan, 2013"]
[null,null,null,null,"Stock Price",null,null,"Stock Price"]
[1,{"$f":"'2012'!B12","v":"Cardinal Health Inc."},{"$f":"'2012'!C12","v":15},{"$f":"'2012'!D12","v":"CAH"},{"$f":"'2012'!E12","v":41.52},{"$f":"'2012'!F12","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-41.52},{"$f":"F4*H4","v":0}]
[2,{"$f":"'2012'!B13","v":"Micron"},{"$f":"'2012'!C13","v":14},{"$f":"'2012'!D13","v":"MU"},{"$f":"'2012'!E13","v":7.76},{"$f":"'2012'!F13","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-7.76},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"'2012'!B14","v":"Ebay"},{"$f":"'2012'!C14","v":33},{"$f":"'2012'!D14","v":"EBAY"},{"$f":"'2012'!E14","v":30.63},{"$f":"'2012'!F14","v":0},0,null,-30.63,0,null,"Market Gains:",{"$f":"J9-G9","v":0}]
[4,{"$f":"'2012'!B15","v":"Assurant, Inc."},{"$f":"'2012'!C15","v":3},{"$f":"'2012'!D15","v":"AIZ"},{"$f":"'2012'!E15","v":41.17},{"$f":"'2012'!F15","v":0},0,null,-41.17,0,null,"2013 Portfolio:",{"$f":"J9","v":0}]
[5,{"$f":"'2012'!B16","v":"Southwest Airlines"},{"$f":"'2012'!C16","v":56},{"$f":"'2012'!D16","v":"LUV"},{"$f":"'2012'!E16","v":8.52},{"$f":"'2012'!F16","v":0},0,null,-8.52,0,null,"2013 Sell:",{"$f":"F20","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":0},null,null,{"$f":"SUM(J4:J8)","v":0},null,"2013 Buy:",{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7-M8+G30","v":0}]
["SELL"]
[null,null,null,null,null,null,null,null,null,null,null,"Cash"]
[null,null,null,null,null,null,null,null,null,null,null,"Starting Cash",500]
[null,null,null,"Current",null,"Sell",null,null,null,null,null,"Liquid Assets",{"$f":"F20-G30","v":0}]
[null,null,null,{"$f":"D4","v":"CAH"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":500}]
[null,null,null,{"$f":"D5","v":"MU"}]
[null,null,null,{"$f":"D6","v":"EBAY"}]
[null,null,null,{"$f":"D7","v":"AIZ"}]
[null,null,null,{"$f":"D8","v":"LUV"}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
[]
["BUY"]
[]
[null,"Buy",null,null,null,"Shares","Total","Companies"]
[null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,5,FALSE)))","v":""},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,E25*F25))","v":""},{"$f":"IF(A25=\"\",C4,A25)","v":15}]
[null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,5,FALSE)))","v":""},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,E26*F26))","v":""},{"$f":"IF(A26=\"\",C5,A26)","v":14}]
[null,{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$H$101,5,FALSE)))","v":""},null,"",33]
[null,{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$H$101,5,FALSE)))","v":""},null,"",3]
[null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,5,FALSE)))","v":""},null,"",56]
[null,null,null,null,null,null,{"$f":"SUM(G25:G29)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F25:F29)","v":0}]

{"sheet":"2014","index":2,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,11,4,12],[11,11,11,12],[13,3,13,4],[0,0,0,9],[1,0,2,3],[1,5,2,5],[1,6,2,6],[10,0,11,9],[28,2,28,3],[21,0,21,9],[23,1,23,4],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3]]}
[2014]
["2012 Investment Portfolio",null,null,null,"Jan 2013","# of Shares","Total","Jan, 2014"]
[null,null,null,null,"Stock Price",null,null,"Stock Price"]
[1,{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,2,FALSE)","v":"Cardinal Health Inc."},{"$f":"'2013'!H25","v":15},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"CAH"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,5,FALSE)","v":44.64},{"$f":"IF('2013'!F25=\"\",'2013'!F4,'2013'!F25)","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-44.64},{"$f":"F4*H4","v":0}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"Micron"},{"$f":"'2013'!H26","v":14},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"MU"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,5,FALSE)","v":7.89},{"$f":"IF('2013'!F26=\"\",'2013'!F5,'2013'!F26)","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-7.89},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"Ebay"},{"$f":"'2013'!H27","v":33},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"EBAY"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,5,FALSE)","v":54.21},{"$f":"IF('2013'!F27=\"\",'2013'!F6,'2013'!F27)","v":0},0,null,-54.21,0,null,"Total Increase:",{"$f":"J9-G9","v":0}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Assurant, Inc."},{"$f":"'2013'!H28","v":3},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"AIZ"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,5,FALSE)","v":36.19},{"$f":"IF('2013'!F28=\"\",'2013'!F7,'2013'!F28)","v":0},0,null,-36.19,0,null,"2014 Portfolio:",{"$f":"J9","v":0}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Southwest Airlines"},{"$f":"'2013'!H29","v":56},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"LUV"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,5,FALSE)","v":11.26},{"$f":"IF('2013'!F29=\"\",'2013'!F8,'2013'!F29)","v":0},0,null,-11.26,0,null,"2014 Sell:",{"$f":"F20","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":0},null,null,{"$f":"SUM(J4:J8)","v":0},null,"2014 Buy:",{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7-M8+M9","v":0}]
["SELL"]
[null,null,null,null,null,null,null,null,null,null,null,"Cash"]
[null,null,null,null,null,null,null,null,null,null,null,"Starting Cash",{"$f":"'2013'!M15","v":500}]
[null,null,null,"Current",null,"Sell",null,null,null,null,null,"Liquid Assets",{"$f":"F20-G30","v":0}]
[null,null,null,{"$f":"D4","v":"CAH"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":500}]
[null,null,null,{"$f":"D5","v":"MU"}]
[null,null,null,{"$f":"D6","v":"EBAY"}]
[null,null,null,{"$f":"D7","v":"AIZ"}]
[null,null,null,{"$f":"D8","v":"LUV"}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
[]
["BUY"]
[]
[null,"Buy",null,null,null,"Shares","Total"]
[null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,6,FALSE)))","v":""},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,E25*F25))","v":""},{"$f":"IF(A25=\"\",C4,A25)","v":15}]
[null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,6,FALSE)))","v":""},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,E26*F26))","v":""},{"$f":"IF(A26=\"\",C5,A26)","v":14}]
[null,{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$H$101,6,FALSE)))","v":""},null,"",33]
[null,{"$f":"IF(A28=\"\",\"\",IF(A28>H250,VLOOKUP(A28,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$H$101,6,FALSE)))","v":""},null,"",3]
[null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,6,FALSE)))","v":""},null,"",56]
[null,null,null,null,null,null,{"$f":"SUM(G25:G29)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F25:F29)","v":0}]

{"sheet":"2015","index":3,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,11,4,12],[11,11,11,12],[13,3,13,4],[0,0,0,9],[1,0,2,3],[1,5,2,5],[1,6,2,6],[10,0,11,9],[28,2,28,3],[21,0,21,9],[23,1,23,4],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3]]}
[2015]
["2013 Investment Portfolio",null,null,null,"Jan 2014","# of Shares","Total","Jan, 2015"]
[null,null,null,null,"Stock Price",null,null,"Stock Price"]
[1,{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,2,FALSE)","v":"Cardinal Health Inc."},{"$f":"'2014'!H25","v":15},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"CAH"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,6,FALSE)","v":69.319999999999993},{"$f":"IF('2014'!F25=\"\",'2014'!F4,'2014'!F25)","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-69.319999999999993},{"$f":"F4*H4","v":0}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"Micron"},{"$f":"'2014'!H26","v":14},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"MU"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,6,FALSE)","v":20.97},{"$f":"IF('2014'!F26=\"\",'2014'!F5,'2014'!F26)","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-20.97},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"Ebay"},{"$f":"'2014'!H27","v":33},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"EBAY"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,6,FALSE)","v":52.16},{"$f":"IF('2014'!F27=\"\",'2014'!F6,'2014'!F27)","v":0},0,null,-52.16,0,null,"Total Increase:",{"$f":"J9-G9","v":0}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Assurant, Inc."},{"$f":"'2014'!H28","v":3},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"AIZ"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,6,FALSE)","v":67.739999999999995},{"$f":"IF('2014'!F28=\"\",'2014'!F7,'2014'!F28)","v":0},0,null,-67.739999999999995,0,null,"2015 Portfolio:",{"$f":"'2014'!M10","v":0}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Southwest Airlines"},{"$f":"'2014'!H29","v":56},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"LUV"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,6,FALSE)","v":21.22},{"$f":"IF('2014'!F29=\"\",'2014'!F8,'2014'!F29)","v":0},0,null,-21.22,0,null,"2015 Sell:",{"$f":"F20","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":0},null,null,{"$f":"SUM(J4:J8)","v":0},null,"2015 Buy:",{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Gain",{"$f":"M7-M8+M9","v":0}]
["SELL"]
[null,null,null,null,null,null,null,null,null,null,null,"Cash"]
[null,null,null,null,null,null,null,null,null,null,null,"Starting Cash",{"$f":"'2014'!M15","v":500}]
[null,null,null,"Current",null,"Sell",null,null,null,null,null,"Liquid Assets",{"$f":"F20-G30","v":0}]
[null,null,null,{"$f":"D4","v":"CAH"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":500}]
[null,null,null,{"$f":"D5","v":"MU"}]
[null,null,null,{"$f":"D6","v":"EBAY"}]
[null,null,null,{"$f":"D7","v":"AIZ"}]
[null,null,null,{"$f":"D8","v":"LUV"}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
[]
["BUY"]
[]
[null,"Buy",null,null,null,"Shares","Total"]
[null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,7,FALSE)))","v":""},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,E25*F25))","v":""},{"$f":"IF(A25=\"\",C4,A25)","v":15}]
[null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,7,FALSE)))","v":""},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,E26*F26))","v":""},{"$f":"IF(A26=\"\",C5,A26)","v":14}]
[null,{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$H$101,7,FALSE)))","v":""},null,"",33]
[null,{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$H$101,7,FALSE)))","v":""},null,"",3]
[null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,7,FALSE)))","v":""},null,"",56]
[null,null,null,null,null,null,{"$f":"SUM(G25:G29)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F25:F29)","v":0}]

{"sheet":"2016","index":4,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[11,11,11,12],[4,11,4,12],[13,3,13,4],[0,0,0,9],[1,0,2,3],[1,5,2,5],[1,6,2,6],[10,0,11,9],[28,2,28,3],[21,0,21,9],[23,1,23,4],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3]]}
[2016]
["2014 Investment Portfolio",null,null,null,"Jan 2015","# of Shares","Total","Jan, 2016"]
[null,null,null,null,"Stock Price",null,null,"Stock Price"]
[1,{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,2,FALSE)","v":"Cardinal Health Inc."},{"$f":"'2015'!H25","v":15},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"CAH"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,7,FALSE)","v":80.510000000000005},{"$f":"IF('2015'!F25=\"\",'2015'!F4,'2015'!F25)","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-80.510000000000005},{"$f":"F4*H4","v":0}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"Micron"},{"$f":"'2015'!H26","v":14},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"MU"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,7,FALSE)","v":33.53},{"$f":"IF('2015'!F26=\"\",'2015'!F5,'2015'!F26)","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-33.53},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"Ebay"},{"$f":"'2015'!H27","v":33},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"EBAY"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,7,FALSE)","v":53},{"$f":"IF('2015'!F27=\"\",'2015'!F6,'2015'!F27)","v":0},0,null,-53,0,null,"Total Increase:",{"$f":"J9-G9","v":0}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Assurant, Inc."},{"$f":"'2015'!H28","v":3},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"AIZ"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,7,FALSE)","v":65.180000000000007},{"$f":"IF('2015'!F28=\"\",'2015'!F7,'2015'!F28)","v":0},0,null,-65.180000000000007,0,null,"2016 Portfolio:",{"$f":"J9","v":0}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Southwest Airlines"},{"$f":"'2015'!H29","v":56},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"LUV"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,7,FALSE)","v":40.75},{"$f":"IF('2015'!F29=\"\",'2015'!F8,'2015'!F29)","v":0},0,null,-40.75,0,null,"2016 Sell:",{"$f":"F20","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":0},null,null,{"$f":"SUM(J4:J8)","v":0},null,"2016 Buy:",{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7-M8+M9","v":0}]
["SELL"]
[null,null,null,null,null,null,null,null,null,null,null,"Cash"]
[null,null,null,null,null,null,null,null,null,null,null,"Starting Cash",{"$f":"'2015'!M15","v":500}]
[null,null,null,"Current",null,"Sell",null,null,null,null,null,"Liquid Assets",{"$f":"F20-G30","v":0}]
[null,null,null,{"$f":"D4","v":"CAH"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":500}]
[null,null,null,{"$f":"D5","v":"MU"}]
[null,null,null,{"$f":"D6","v":"EBAY"}]
[null,null,null,{"$f":"D7","v":"AIZ"}]
[null,null,null,{"$f":"D8","v":"LUV"}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
[]
["BUY"]
[]
[null,"Buy",null,null,null,"Shares","Total"]
[null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,8,FALSE)))","v":""},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,E25*F25))","v":""},{"$f":"IF(A25=\"\",C4,A25)","v":15}]
[null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,8,FALSE)))","v":""},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,E26*F26))","v":""},{"$f":"IF(A26=\"\",C5,A26)","v":14}]
[null,{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$H$101,8,FALSE)))","v":""},null,"",33]
[null,{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$H$101,8,FALSE)))","v":""},null,"",3]
[null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,8,FALSE)))","v":""},null,"",56]
[null,null,null,null,null,null,{"$f":"SUM(G25:G29)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F25:F29)","v":0}]

{"sheet":"2017","index":5,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[10,0,11,9],[11,11,11,12],[0,0,0,9],[1,0,2,3],[1,5,2,5],[1,6,2,6],[4,11,4,12],[27,2,27,3],[28,2,28,3],[13,3,13,4],[21,0,21,9],[23,1,23,4],[24,2,24,3],[25,2,25,3],[26,2,26,3]]}
[2016]
["2014 Investment Portfolio",null,null,null,"Jan 2016","# of Shares","Total","Jan, 2017"]
[null,null,null,null,"Stock Price",null,null,"Stock Price"]
[1,{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,2,FALSE)","v":"Cardinal Health Inc."},{"$f":"'2016'!H25","v":15},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"CAH"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,7,FALSE)","v":80.510000000000005},{"$f":"IF('2016'!F25=\"\",'2016'!F4,'2016'!F25)","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-80.510000000000005},{"$f":"F4*H4","v":0}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"Micron"},{"$f":"'2016'!H26","v":14},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"MU"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,7,FALSE)","v":33.53},{"$f":"IF('2016'!F26=\"\",'2016'!F5,'2016'!F26)","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-33.53},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"Ebay"},{"$f":"'2016'!H27","v":33},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"EBAY"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,7,FALSE)","v":53},{"$f":"IF('2016'!F27=\"\",'2016'!F6,'2016'!F27)","v":0},0,null,-53,0,null,"Total Increase:",{"$f":"J9-G9","v":0}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Assurant, Inc."},{"$f":"'2016'!H28","v":3},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"AIZ"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,7,FALSE)","v":65.180000000000007},{"$f":"IF('2016'!F28=\"\",'2016'!F7,'2016'!F28)","v":0},0,null,-65.180000000000007,0,null,"2017 Portfolio:",{"$f":"J9","v":0}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Southwest Airlines"},{"$f":"'2016'!H29","v":56},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"LUV"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,7,FALSE)","v":40.75},{"$f":"IF('2016'!F29=\"\",'2016'!F8,'2016'!F29)","v":0},0,null,-40.75,0,null,"2017 Sell:",{"$f":"F20","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":0},null,null,{"$f":"SUM(J4:J8)","v":0},null,"2017 Buy:",{"$f":"G30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7-M8+M9","v":0}]
["SELL"]
[null,null,null,null,null,null,null,null,null,null,null,"Cash"]
[null,null,null,null,null,null,null,null,null,null,null,"Starting Cash",{"$f":"'2015'!M15","v":500}]
[null,null,null,"Current",null,"Sell",null,null,null,null,null,"Liquid Assets",{"$f":"F20-G30","v":0}]
[null,null,null,{"$f":"D4","v":"CAH"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":500}]
[null,null,null,{"$f":"D5","v":"MU"}]
[null,null,null,{"$f":"D6","v":"EBAY"}]
[null,null,null,{"$f":"D7","v":"AIZ"}]
[null,null,null,{"$f":"D8","v":"LUV"}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":0}]
[]
["BUY"]
[]
[null,"Buy",null,null,null,"Shares","Total"]
[null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,8,FALSE)))","v":""},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,E25*F25))","v":""},{"$f":"IF(A25=\"\",C4,A25)","v":15}]
[null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,8,FALSE)))","v":""},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,E26*F26))","v":""},{"$f":"IF(A26=\"\",C5,A26)","v":14}]
[null,{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A27=\"\",\"\",IF(A27>0,VLOOKUP(A27,Stocks!$A$2:$H$101,8,FALSE)))","v":""},null,"",33]
[null,{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A28=\"\",\"\",IF(A28>0,VLOOKUP(A28,Stocks!$A$2:$H$101,8,FALSE)))","v":""},null,"",3]
[null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$C$101,2,FALSE)))","v":""},{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,3,FALSE)))","v":""},null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,8,FALSE)))","v":""},null,"",56]
[null,null,null,null,null,null,{"$f":"SUM(G25:G29)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F25:F29)","v":0}]

{"sheet":"Today","index":6,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,2,3],[1,5,2,5],[1,6,2,6],[4,11,4,12]]}
["Today"]
["2015 Investment Portfolio",null,null,null,"Jan 2017","# of Shares","Total","Today's"]
[null,null,null,null,"Stock Price",null,null,"Stock Price"]
[1,{"$f":"IF('2017'!B25=\"\",'2017'!B4,'2017'!B25)","v":"Cardinal Health Inc."},{"$f":"'2017'!H25","v":15},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"CAH"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$N$101,9,FALSE)","v":73.72},{"$f":"IF('2017'!F25=\"\",'2017'!F4,'2017'!F25)","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-73.72},{"$f":"F4*H4","v":0}]
[2,{"$f":"IF('2017'!B26=\"\",'2017'!B5,'2017'!B26)","v":"Micron"},{"$f":"'2017'!H26","v":14},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"MU"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$N$101,9,FALSE)","v":22.55},{"$f":"IF('2017'!F26=\"\",'2017'!F5,'2017'!F26)","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-22.55},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"IF('2017'!B27=\"\",'2017'!B6,'2017'!B27)","v":"Ebay"},{"$f":"'2017'!H27","v":33},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"EBAY"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$N$101,9,FALSE)","v":37.33},{"$f":"IF('2017'!F27=\"\",'2017'!F6,'2017'!F27)","v":0},0,null,-37.33,0,null,"Total Increase:",{"$f":"J9-G9","v":0}]
[4,{"$f":"IF('2017'!B28=\"\",'2017'!B7,'2017'!B28)","v":"Assurant, Inc."},{"$f":"'2017'!H28","v":3},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"AIZ"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$N$101,9,FALSE)","v":95.98},{"$f":"IF('2017'!F28=\"\",'2017'!F7,'2017'!F28)","v":0},0,null,-95.98,0,null,"Today's Portfolio:",{"$f":"J9","v":0}]
[5,{"$f":"IF('2017'!B29=\"\",'2017'!B8,'2017'!B29)","v":"Southwest Airlines"},{"$f":"'2017'!H29","v":56},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"LUV"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$N$101,9,FALSE)","v":50.3},{"$f":"IF('2017'!F29=\"\",'2017'!F8,'2017'!F29)","v":0},0,null,-50.3,0,null,"Liquid Assets:",{"$f":"'2016'!M15","v":500}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":0},null,null,{"$f":"SUM(J4:J8)","v":0},null,null,{"$f":"SUM(M7:M8)","v":500}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H4:H8)","v":0}]

{"sheet":"Stocks","index":7,"n_rows":101,"n_cols":24,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
[null,null,null,2012,2013,2014,2015,2016,2017]
[1,"Apple","AAPL",59.97,74.33,76.13,109.33,96.96,118.99,"NASDAQ"]
[2,"Kroger Co.","KR",12.06,13.23,19.55,34.53,38.81,33.24,"NYSE"]
[3,"Assurant, Inc.","AIZ",41.17,36.19,67.739999999999995,65.180000000000007,77.400000000000006,95.98,"NYSE"]
[4,"Allstate","ALL",23.98,43.21,54.09,70.42,58.44,73.09,"NYSE"]
[5,"McKesson Corporation","MCK",77.239999999999995,103.98,160.71,213.98,170.18,136.74,"NASDAQ"]
[6,"Teva Pharmeceutical","TEVA",45.05,37.729999999999997,39.880000000000003,56.22,63.7,34.590000000000003]
[7,"Avery Dennison Corp","AVY",28.8,35.93,51.15,51.79,58.16,73.17,"NYSE"]
[8,"American Express","AXP",49.76,59.61,86.95,93.02,54.52,76.69,"NYSE"]
[9,"Bank of America Corp","BAC",6.61,12.11,16.41,15.73,13.69,22.68,"NYSE"]
[10,"Intel Corporation","INTC",25.25,21.16,25.85,36.450000000000003,31.51,37.979999999999997]
[11,"Build-a-Bear Workshop","BBW",7.87,4.6100000000000003,8.73,22.44,12.89,13.85,"NYSE"]
[12,"Barnes & Noble","BKS",16.16,12.76,14.68,24.8,8.08,11.1,"NYSE"]
[13,"Citigroup","C",28.55,42.43,54.72,46.95,41.06,59.23,"NYSE"]
[14,"Micron","MU",7.76,7.89,20.97,33.53,11.07,22.55]
[15,"Cardinal Health Inc.","CAH",41.52,44.64,69.319999999999993,80.510000000000005,79.27,73.72,"NYSE"]
[16,"CBS Corporation","CBS",27.79,40.42,63.14,54.79,45.88,65.739999999999995,"NYSE"]
[17,"Carnival Corp","CCL",34.28,37.06,41.36,46.3,49.57,55.83,"NYSE"]
[18,"Colgate ","CL",44.9,53.55,64.7,69.3,62.81,67.36,"NYSE"]
[19,"Comcast Corporation","CMCSA",25.38,38.46,51.07,56.31,53.55,35.08,"NASDAQ"]
[20,"Cinemark Holdings Inc.","CNK",19.760000000000002,27.22,32.42,37.17,31.03,40.82,"NYSE"]
[21,"Costco","COST",81.13,101.2,117.29,141.61000000000001,154.82,162.91,"NASDAQ"]
[22,"Campbell Soup Company","CPB",31.75,36.29,41.79,45.75,50.82,62.29,"NYSE",null,null,null,null,null,null,null,null,2012,2013,2014,2015,2016,2017]
[23,"Cirrus Logic","CRUS",16.5,29.39,17.510000000000002,26.5,25.76,61.74,"NASDAQ",null,null,null,null,null,null,null,null,"1st Buy","2nd Buy","3rd Buy","4th Buy","5th Buy","6th Buy"]
[24,"Century Link","CTL",36.590000000000003,40.020000000000003,31.6,38.4,22.24,25.48,"NYSE",null,null,null,null,null,null,null,null,{"$f":"IF('2013'!F15=0,\"\",IF('2013'!F15>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2014'!F15=0,\"\",IF('2014'!F15>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2015'!F15=0,\"\",IF('2015'!F15>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F15=0,\"\",IF('2016'!F15>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2017'!F15=0,\"\",IF('2016'!F15>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2017'!F15=0,\"\",IF('2017'!F15>0,RANDBETWEEN(1,100)))","v":""}]
[25,"Delta Airlines","DAL",8.85,12.98,29.23,50.56,44.5,49.7,"NYSE",null,null,null,null,null,null,null,null,{"$f":"IF('2013'!F16=0,\"\",IF('2013'!F16>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2014'!F16=0,\"\",IF('2014'!F16>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2015'!F16=0,\"\",IF('2015'!F16>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F16=0,\"\",IF('2016'!F16>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F16=0,\"\",IF('2016'!F16>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2017'!F16=0,\"\",IF('2017'!F16>0,RANDBETWEEN(1,100)))","v":""}]
[26,"3D Systems","DDD",12.27,39.229999999999997,96.42,29.08,6.42,17,"NYSE",null,null,null,null,null,null,null,null,{"$f":"IF('2013'!F17=0,\"\",IF('2013'!F17>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2014'!F17=0,\"\",IF('2014'!F17>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2015'!F17=0,\"\",IF('2015'!F17>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F17=0,\"\",IF('2016'!F17>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F17=0,\"\",IF('2016'!F17>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2017'!F17=0,\"\",IF('2017'!F17>0,RANDBETWEEN(1,100)))","v":""}]
[27,"Walt Disney Co","DIS",38.4,52.19,75.39,93.75,99.25,108.16,"NYSE",null,null,null,null,null,null,null,null,{"$f":"IF('2013'!F18=0,\"\",IF('2013'!F18>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2014'!F18=0,\"\",IF('2014'!F18>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2015'!F18=0,\"\",IF('2015'!F18>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F18=0,\"\",IF('2016'!F18>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F18=0,\"\",IF('2016'!F18>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2017'!F18=0,\"\",IF('2017'!F18>0,RANDBETWEEN(1,100)))","v":""}]
[28,"Dick's Sporting Goods","DKS",34.64,48.82,57.59,49.94,35.83,54.62,"NYSE",null,null,null,null,null,null,null,null,{"$f":"IF('2013'!F19=0,\"\",IF('2013'!F19>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2014'!F19=0,\"\",IF('2014'!F19>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2015'!F19=0,\"\",IF('2015'!F19>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F19=0,\"\",IF('2016'!F19>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F19=0,\"\",IF('2016'!F19>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2017'!F19=0,\"\",IF('2017'!F19>0,RANDBETWEEN(1,100)))","v":""}]
[29,"Dr Pepper Snapple","DPS",37.67,45.3,47.88,71.599999999999994,89.16,90.02,"NYSE"]
[30,"Realty Income Corp","O",33.83,34.79,38.409999999999997,48.62,54.04,59.84]
[31,"GEO Group","GEO",17.41,32.49,33.479999999999997,41.51,29,16.920000000000002,"NYSE"]
[32,"EA Games","EA",18.04,14.46,24.1,54.86,64.48,79.17,"NASDAQ"]
[33,"Ebay","EBAY",30.63,54.21,52.16,53,25.86,37.33,"NYSE"]
[34,"Ford","F",11.71,13.68,15.51,15.21,12.54,12.85,"NYSE"]
[35,"Fedex","FDX",85.49,94.91,142.63,176.01,134.71,190.25,"NYSE"]
[36,"21st Century Fox","FOX",18.920000000000002,27.83,34.659999999999997,31.85,25.89,29,"NASDAQ"]
[37,"General Electric","GE",18.649999999999999,21.13,25.13,23.59,28.58,31.21,"NYSE"]
[38,"General Motors","GM",22.92,29.07,36.08,32.619999999999997,30.3,35.15,"NYSE"]
[39,"Game Stop","GME",24.87,23.71,37.65,32.270000000000003,28.45,23.93,"NYSE"]
[40,"Rangold Resources LTD","GOLD",106.75,95.83,70.11,74.91,60.99,82.71,"NASDAQ"]
[41,"Gap Inc.","GPS",18,33.54,37.299999999999997,42.02,23.36,23.97,"NYSE"]
[42,"Goldman Sachs","GS",108.74,137.13,178.39,180.49,164.62,233.68,"NYSE"]
[43,"Honda","HMC",32.130000000000003,37.75,39.76,31.17,27.62,30.16,"NYSE"]
[44,"Hewlett Packard","HPQ",26.4,16.16,28.34,36.130000000000003,10.58,14.58,"NYSE"]
[45,"Hershey Co.","HSY",60.69,74.540000000000006,95.81,110.66,83.32,104.83,"NYSE"]
[46,"Jet Blue","JBLU",5.45,5.95,9.0500000000000007,14.85,20.286999999999999,21.34,"NYSE"]
[47,"Johnson & Johnson","JNJ",65.27,71.55,94.74,104.52,100.9,114.2,"NYSE"]
[48,"JP Morgan","JPM",35.36,47.16,58.49,54.38,58.96,86.11,"NYSE"]
[49,"Nordstrom","JWN",49.74,55.12,61.11,78.5,50.13,44.9,"NYSE"]
[50,"Kellog Stock","K",50.81,57.02,60.58,68.680000000000007,72.010000000000005,71.98,"NYSE"]
[51,"Kimberly Clark Corp","KMB",72.7,85.1,104.35,107.96,125.71,114.36,"NYSE"]
[52,"The Coca-Cola Co","KO",33.5,38.770000000000003,40.130000000000003,43.31,41.51,41.32,"NYSE"]
[53,"Hyatt Hotels Corporation","H",45.76,40.49,49.8,58.56,36.99,54.78]
[54,"L-3 Communications","LLL",67.069999999999993,77.709999999999994,106.32,125.67,108.05,152.29,"NYSE"]
[55,"Logitech","LOGI",8.0500000000000007,7.24,15.46,14.94,13.78,25.12,"NASDAQ"]
[56,"Southwest Airlines","LUV",8.52,11.26,21.22,40.75,42.85,50.3,"NYSE"]
[57,"La-Z Boy Incorporated","LZB",12.77,15.27,30.97,27.01,22.36,29.1,"NYSE"]
[58,"Macy's, Inc.","M",34.56,36.89,56.23,65.83,36.15,35.840000000000003,"NYSE"]
[59,"Mattel Inc.","MAT",29.35,38.03,46.87,27.82,26.92,29.91,"NASDAQ"]
[60,"McDonalds ","MCD",101.74,91.73,96.54,89.56,115.48,119.48,"NYSE"]
[61,"Metlife","MET",35.24,35.950000000000003,54.1,53.91,43,53.7,"NYSE"]
[62,"3M","MMM",87.46,100.59,138.44999999999999,161.62,147.46,178.32,"NYSE"]
[63,"Microsoft","MSFT",28.11,26.74,36.909999999999997,47.18,51.64,62.3,"NASDAQ"]
[64,"Motorolla","MSI",46.55,57.5,66.099999999999994,65.11,60.36,82.89,"NYSE"]
[65,"Nestle","NESN",53.2,63.4,66.849999999999994,64.8,73.05,74.45,"NYSE"]
[66,"Newmarket Corp","NEU",218.6,286.54000000000002,333.61,402.09,368.02,424.31,"NYSE"]
[67,"Nike","NKE",50.88,53.29,73.39,95.99,58.78,51.98,"NYSE"]
[68,"Nokia","NOK",5.24,4.18,7.79,7.55,7.46,4.92,"NYSE"]
[69,"Nu Skin Enterprises","NUS",47.26,45.08,137.68,41.61,32.299999999999997,49.87,"NYSE"]
[70,"Newell Rubbermaid","NWL",17.190000000000001,21.8,32.4,38.159999999999997,36.200000000000003,46.68,"NYSE"]
[71,"HCA Holdings","HCA",23.9,31.94,51.41,73.97,67.83,79.31,"NYSE"]
[72,"PepsiCo Inc.","PEP",65.39,70.88,83.5,96.82,97.44,101.81,"NYSE"]
[73,"Procter & Gamble Co","PG",65.81,69.22,80.3,84.29,77.86,86.06,"NYSE"]
[74,"Progressive Corp.","PGR",20.43,22.72,25.94,26.92,30.64,36.03,"NYSE"]
[75,"Pier 1 Imports","PIR",15,22.02,21.57,16.36,4.09,8.6999999999999993,"NYSE"]
[76,"Dominion Energy","D",43.39,49.56,52.43,67.78,76.89,75.209999999999994]
[77,"Royal Caribbean Cruises","RCL",25.5,38.42,49.09,82.95,85.48,84.33,"NYSE"]
[78,"Regeneron Pharmaceuticals","REGN",65.790000000000006,179.46,271.75,408.69,463.46,379.7,"NASDAQ"]
[79,"Sturm, Ruger & Company","RGR",38.68,47.51,80.55,38.71,51.89,54.14,"NYSE"]
[80,"Starbucks Corporation","SBUX",23.68,27.4,38.840000000000003,39.9,58.65,58.03,"NYSE"]
[81,"JM Smucker Co","SJM",78.59,90.2,101.51,101.86,122.38,129.04,"NYSE"]
[82,"Sony","SNE",17.440000000000001,11.09,15.75,22.6,22.21,28.96,"NYSE"]
[83,"Smith & Wesson","SWHC",4.74,9.02,13.43,10.02,20.55,20.8,"NASDAQ"]
[84,"AT&T","T",30.51,33.44,34.799999999999997,33.369999999999997,34.590000000000003,40.81,"NYSE"]
[85,"Target","TGT",50.17,61.54,60.24,74.94,71.38,65.39,"NYSE"]
[86,"Toyota","TM",71.400000000000006,96.1,119.19,128.88,112.6,119.64,"NYSE"]
[87,"Pandora Media","P",10.01,11.54,33.47,17.57,13.41,12.47]
[88,"Tesla Motors","TSLA",26.6,34.520000000000003,145.72,219.31,207.85,238.36,"NASDAQ"]
[89,"Tyler Technologies","TYL",31.81,50.01,105.45,107.85,163.79,146.61000000000001,"NYSE"]
[90,"Under Armour Inc.","UA",19.29,24.04,41,69.819999999999993,80.150000000000006,30.38,"NYSE"]
[91,"UnitedHealth Group","UNH",52.27,52.09,74.7,100.78,109.23,161.94999999999999,"NYSE"]
[92,"United Parcel Service","UPS",73.48,76.569999999999993,96.33,98.87,88.7,116.05,"NYSE"]
[93,"Visa Inc.","V",25.18,39.19,58.04,63.74,75.7,81.8,"NYSE"]
[94,"Viacom","VIAB",46.89,59.02,85.4,64.42,40.97,37.479999999999997,"NYSE"]
[95,"Verizon","VZ",38.33,42.54,48.42,47.99,45.52,54.64,"NYSE"]
[96,"Walmart","WMT",61.01,69,78.650000000000006,89.35,63.54,69.06,"NYSE"]
[97,"Watsco Inc.","WSO",67.61,76.150000000000006,96.62,110.74,109.28,147.28,"NYSE"]
[98,"Exxon Mobil Corporation","XOM",87.49,91.73,99.16,90.89,77.47,85.6,"NYSE"]
[99,"Qualcomm, Inc","QCOM",61.06,64.900000000000006,74.08,72.180000000000007,45.88,54.05]
[100,"YUM! Brands","YUM",61.23,65.150000000000006,72.099999999999994,72.430000000000007,68.02,64.489999999999995,"NYSE"]