{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["2011","2012","2013","2014","2015","2016","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":"2011","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!"]
[]
[2011]
[]
[1,{"$f":"VLOOKUP(C12,Stocks!$A$2:$J$101,2,FALSE)","v":"Johnson & Johnson"},47,{"$f":"VLOOKUP(C12,Stocks!$A$2:$J$101,3,FALSE)","v":"JNJ"},{"$f":"VLOOKUP(C12,Stocks!$A$2:$D$101,4,FALSE)","v":62.6},null,{"$f":"E12*F12","v":0},null,null,null,null,{"$f":"RANDBETWEEN(1,100)","v":48}]
[2,{"$f":"VLOOKUP(C13,Stocks!$A$2:$J$101,2,FALSE)","v":"Nokia"},68,{"$f":"VLOOKUP(C13,Stocks!$A$2:$J$101,3,FALSE)","v":"NOK"},{"$f":"VLOOKUP(C13,Stocks!$A$2:$D$101,4,FALSE)","v":9.5500000000000007},null,{"$f":"E13*F13","v":0},null,null,null,null,{"$f":"RANDBETWEEN(1,100)","v":41}]
[3,{"$f":"VLOOKUP(C14,Stocks!$A$2:$J$101,2,FALSE)","v":"YUM! Brands"},100,{"$f":"VLOOKUP(C14,Stocks!$A$2:$J$101,3,FALSE)","v":"YUM"},{"$f":"VLOOKUP(C14,Stocks!$A$2:$D$101,4,FALSE)","v":46.4},null,0,null,null,null,null,98]
[4,{"$f":"VLOOKUP(C15,Stocks!$A$2:$J$101,2,FALSE)","v":"Newmarket Corp"},66,{"$f":"VLOOKUP(C15,Stocks!$A$2:$J$101,3,FALSE)","v":"NEU"},{"$f":"VLOOKUP(C15,Stocks!$A$2:$D$101,4,FALSE)","v":129.59},null,0,null,null,null,null,8]
[5,{"$f":"VLOOKUP(C16,Stocks!$A$2:$J$101,2,FALSE)","v":"Visa Inc."},93,{"$f":"VLOOKUP(C16,Stocks!$A$2:$J$101,3,FALSE)","v":"V"},{"$f":"VLOOKUP(C16,Stocks!$A$2:$D$101,4,FALSE)","v":17.54},null,0,null,null,null,null,67]
[null,null,null,null,null,null,{"$f":"SUM(G12:G16)","v":0}]
[]
[]
[null,"2012 Increase",null,{"$f":"'2012'!M6","v":0}]
[null,"2013 Increase",null,{"$f":"'2013'!M6","v":0}]
[null,"2014 Increase",null,{"$f":"'2014'!M6","v":0}]
[null,"2015 Increase",null,{"$f":"'2015'!M6","v":0}]
[null,"2016 Increase",null,{"$f":"'2016'!M6","v":0}]
[]
[null,"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}]
[null,"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('2012'!F37>0,1,0)","v":0}]
[null,null,13,{"$f":"IF('2013'!F41>0,1,0)","v":0}]
[null,null,14,{"$f":"IF('2014'!F37>0,1,0)","v":0}]
[null,null,15,{"$f":"IF('2015'!F40>0,1,0)","v":0}]
[null,null,16,{"$f":"IF('2016'!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":"2012","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]]}
[2012]
["2011 Investment Portfolio",null,null,null,"Jan, 2011","# of Shares","Total","Jan, 2012"]
[null,null,null,null,"Stock Price",null,null,"Stock Price"]
[1,{"$f":"'2011'!B12","v":"Johnson & Johnson"},{"$f":"'2011'!C12","v":47},{"$f":"'2011'!D12","v":"JNJ"},{"$f":"'2011'!E12","v":62.6},{"$f":"'2011'!F12","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-62.6},{"$f":"F4*H4","v":0}]
[2,{"$f":"'2011'!B13","v":"Nokia"},{"$f":"'2011'!C13","v":68},{"$f":"'2011'!D13","v":"NOK"},{"$f":"'2011'!E13","v":9.5500000000000007},{"$f":"'2011'!F13","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-9.5500000000000007},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"'2011'!B14","v":"YUM! Brands"},{"$f":"'2011'!C14","v":100},{"$f":"'2011'!D14","v":"YUM"},{"$f":"'2011'!E14","v":46.4},{"$f":"'2011'!F14","v":0},0,null,-46.4,0,null,"Market Gains:",{"$f":"J9-G9","v":0}]
[4,{"$f":"'2011'!B15","v":"Newmarket Corp"},{"$f":"'2011'!C15","v":66},{"$f":"'2011'!D15","v":"NEU"},{"$f":"'2011'!E15","v":129.59},{"$f":"'2011'!F15","v":0},0,null,-129.59,0,null,"2012 Portfolio:",{"$f":"J9","v":0}]
[5,{"$f":"'2011'!B16","v":"Visa Inc."},{"$f":"'2011'!C16","v":93},{"$f":"'2011'!D16","v":"V"},{"$f":"'2011'!E16","v":17.54},{"$f":"'2011'!F16","v":0},0,null,-17.54,0,null,"2012 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,"2012 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":"JNJ"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":500}]
[null,null,null,{"$f":"D5","v":"NOK"}]
[null,null,null,{"$f":"D6","v":"YUM"}]
[null,null,null,{"$f":"D7","v":"NEU"}]
[null,null,null,{"$f":"D8","v":"V"}]
[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":47}]
[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":68}]
[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,"",100]
[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,"",66]
[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,"",93]
[null,null,null,null,null,null,{"$f":"SUM(G25:G29)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"SUM(F25:F29)","v":0}]

{"sheet":"2013","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]]}
[2013]
["2012 Investment Portfolio",null,null,null,"Jan 2012","# of Shares","Total","Jan, 2013"]
[null,null,null,null,"Stock Price",null,null,"Stock Price"]
[1,{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,2,FALSE)","v":"Johnson & Johnson"},{"$f":"'2012'!H25","v":47},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"JNJ"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,5,FALSE)","v":65.27},{"$f":"IF('2012'!F25=\"\",'2012'!F4,'2012'!F25)","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-65.27},{"$f":"F4*H4","v":0}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"Nokia"},{"$f":"'2012'!H26","v":68},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"NOK"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,5,FALSE)","v":5.24},{"$f":"IF('2012'!F26=\"\",'2012'!F5,'2012'!F26)","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-5.24},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"YUM! Brands"},{"$f":"'2012'!H27","v":100},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"YUM"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,5,FALSE)","v":61.23},{"$f":"IF('2012'!F27=\"\",'2012'!F6,'2012'!F27)","v":0},0,null,-61.23,0,null,"Total Increase:",{"$f":"J9-G9","v":0}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Newmarket Corp"},{"$f":"'2012'!H28","v":66},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"NEU"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,5,FALSE)","v":218.6},{"$f":"IF('2012'!F28=\"\",'2012'!F7,'2012'!F28)","v":0},0,null,-218.6,0,null,"2013 Portfolio:",{"$f":"J9","v":0}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Visa Inc."},{"$f":"'2012'!H29","v":93},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"V"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,5,FALSE)","v":25.18},{"$f":"IF('2012'!F29=\"\",'2012'!F8,'2012'!F29)","v":0},0,null,-25.18,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+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":"'2012'!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":"JNJ"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":500}]
[null,null,null,{"$f":"D5","v":"NOK"}]
[null,null,null,{"$f":"D6","v":"YUM"}]
[null,null,null,{"$f":"D7","v":"NEU"}]
[null,null,null,{"$f":"D8","v":"V"}]
[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":47}]
[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":68}]
[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,"",100]
[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,"",66]
[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,"",93]
[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":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]]}
[2014]
["2013 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":"Johnson & Johnson"},{"$f":"'2013'!H25","v":47},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"JNJ"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,6,FALSE)","v":71.55},{"$f":"IF('2013'!F25=\"\",'2013'!F4,'2013'!F25)","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-71.55},{"$f":"F4*H4","v":0}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"Nokia"},{"$f":"'2013'!H26","v":68},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"NOK"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,6,FALSE)","v":4.18},{"$f":"IF('2013'!F26=\"\",'2013'!F5,'2013'!F26)","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-4.18},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"YUM! Brands"},{"$f":"'2013'!H27","v":100},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"YUM"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,6,FALSE)","v":65.150000000000006},{"$f":"IF('2013'!F27=\"\",'2013'!F6,'2013'!F27)","v":0},0,null,-65.150000000000006,0,null,"Total Increase:",{"$f":"J9-G9","v":0}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Newmarket Corp"},{"$f":"'2013'!H28","v":66},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"NEU"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,6,FALSE)","v":286.54000000000002},{"$f":"IF('2013'!F28=\"\",'2013'!F7,'2013'!F28)","v":0},0,null,-286.54000000000002,0,null,"2013 Portfolio:",{"$f":"'2013'!M10","v":0}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Visa Inc."},{"$f":"'2013'!H29","v":93},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"V"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,6,FALSE)","v":39.19},{"$f":"IF('2013'!F29=\"\",'2013'!F8,'2013'!F29)","v":0},0,null,-39.19,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,"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":"'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":"JNJ"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":500}]
[null,null,null,{"$f":"D5","v":"NOK"}]
[null,null,null,{"$f":"D6","v":"YUM"}]
[null,null,null,{"$f":"D7","v":"NEU"}]
[null,null,null,{"$f":"D8","v":"V"}]
[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":47}]
[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":68}]
[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,"",100]
[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,"",66]
[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,"",93]
[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":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]]}
[2015]
["2014 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":"Johnson & Johnson"},{"$f":"'2014'!H25","v":47},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"JNJ"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,7,FALSE)","v":94.74},{"$f":"IF('2014'!F25=\"\",'2014'!F4,'2014'!F25)","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-94.74},{"$f":"F4*H4","v":0}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"Nokia"},{"$f":"'2014'!H26","v":68},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"NOK"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,7,FALSE)","v":7.79},{"$f":"IF('2014'!F26=\"\",'2014'!F5,'2014'!F26)","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-7.79},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"YUM! Brands"},{"$f":"'2014'!H27","v":100},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"YUM"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,7,FALSE)","v":72.099999999999994},{"$f":"IF('2014'!F27=\"\",'2014'!F6,'2014'!F27)","v":0},0,null,-72.099999999999994,0,null,"Total Increase:",{"$f":"J9-G9","v":0}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Newmarket Corp"},{"$f":"'2014'!H28","v":66},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"NEU"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,7,FALSE)","v":333.61},{"$f":"IF('2014'!F28=\"\",'2014'!F7,'2014'!F28)","v":0},0,null,-333.61,0,null,"2014 Portfolio:",{"$f":"J9","v":0}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Visa Inc."},{"$f":"'2014'!H29","v":93},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"V"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,7,FALSE)","v":58.04},{"$f":"IF('2014'!F29=\"\",'2014'!F8,'2014'!F29)","v":0},0,null,-58.04,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":"'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":"JNJ"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":500}]
[null,null,null,{"$f":"D5","v":"NOK"}]
[null,null,null,{"$f":"D6","v":"YUM"}]
[null,null,null,{"$f":"D7","v":"NEU"}]
[null,null,null,{"$f":"D8","v":"V"}]
[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":47}]
[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":68}]
[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,"",100]
[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,"",66]
[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,"",93]
[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":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 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":"Johnson & Johnson"},{"$f":"'2015'!C4","v":47},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"JNJ"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,7,FALSE)","v":94.74},{"$f":"IF('2015'!F25=\"\",'2015'!F4,'2015'!F25)","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-94.74},{"$f":"F4*H4","v":0}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"Nokia"},{"$f":"'2015'!C5","v":68},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"NOK"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,7,FALSE)","v":7.79},{"$f":"IF('2015'!F26=\"\",'2015'!F5,'2015'!F26)","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-7.79},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"YUM! Brands"},{"$f":"'2015'!C6","v":100},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"YUM"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,7,FALSE)","v":72.099999999999994},{"$f":"IF('2015'!F27=\"\",'2015'!F6,'2015'!F27)","v":0},0,null,-72.099999999999994,0,null,"Total Increase:",{"$f":"J9-G9","v":0}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Newmarket Corp"},{"$f":"'2015'!C7","v":66},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"NEU"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,7,FALSE)","v":333.61},{"$f":"IF('2015'!F28=\"\",'2015'!F7,'2015'!F28)","v":0},0,null,-333.61,0,null,"2014 Portfolio:",{"$f":"J9","v":0}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Visa Inc."},{"$f":"'2015'!C8","v":93},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"V"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,7,FALSE)","v":58.04},{"$f":"IF('2015'!F29=\"\",'2015'!F8,'2015'!F29)","v":0},0,null,-58.04,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":"'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":"JNJ"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":500}]
[null,null,null,{"$f":"D5","v":"NOK"}]
[null,null,null,{"$f":"D6","v":"YUM"}]
[null,null,null,{"$f":"D7","v":"NEU"}]
[null,null,null,{"$f":"D8","v":"V"}]
[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":47}]
[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":68}]
[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,"",100]
[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,"",66]
[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,"",93]
[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 2016","# of Shares","Total","Today's"]
[null,null,null,null,"Stock Price",null,null,"Stock Price"]
[1,{"$f":"IF('2015'!B25=\"\",'2015'!B4,'2015'!B25)","v":"Johnson & Johnson"},{"$f":"'2015'!H25","v":47},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"JNJ"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$N$101,9,FALSE)","v":100.9},{"$f":"IF('2016'!F25=\"\",'2016'!F4,'2016'!F25)","v":0},{"$f":"E4*F4","v":0},null,{"$f":"H4-E4","v":-100.9},{"$f":"F4*H4","v":0}]
[2,{"$f":"IF('2015'!B26=\"\",'2015'!B5,'2015'!B26)","v":"Nokia"},{"$f":"'2015'!H26","v":68},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"NOK"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$N$101,9,FALSE)","v":7.46},{"$f":"IF('2016'!F26=\"\",'2016'!F5,'2016'!F26)","v":0},{"$f":"E5*F5","v":0},null,{"$f":"H5-E5","v":-7.46},{"$f":"F5*H5","v":0},null,"Stock Portfolio"]
[3,{"$f":"IF('2015'!B27=\"\",'2015'!B6,'2015'!B27)","v":"YUM! Brands"},{"$f":"'2015'!H27","v":100},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"YUM"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$N$101,9,FALSE)","v":68.02},{"$f":"IF('2016'!F27=\"\",'2016'!F6,'2016'!F27)","v":0},0,null,-68.02,0,null,"Total Increase:",{"$f":"J9-G9","v":0}]
[4,{"$f":"IF('2015'!B28=\"\",'2015'!B7,'2015'!B28)","v":"Newmarket Corp"},{"$f":"'2015'!H28","v":66},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"NEU"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$N$101,9,FALSE)","v":368.02},{"$f":"IF('2016'!F28=\"\",'2016'!F7,'2016'!F28)","v":0},0,null,-368.02,0,null,"Today's Portfolio:",{"$f":"J9","v":0}]
[5,{"$f":"IF('2015'!B29=\"\",'2015'!B8,'2015'!B29)","v":"Visa Inc."},{"$f":"'2015'!H29","v":93},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"V"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$N$101,9,FALSE)","v":75.7},{"$f":"IF('2016'!F29=\"\",'2016'!F8,'2016'!F29)","v":0},0,null,-75.7,0,null,"Liquid Assets:",{"$f":"'2015'!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":false,"merged":[]}
[null,null,null,2011,2012,2013,2014,2015,2016]
[1,"Apple","AAPL",48.02,59.97,74.33,76.13,109.33,96.96,"NASDAQ"]
[2,"Alliance Fiber Optic","ADS",71.64,108.49,151.1,256.89,289.55,256.24,"NYSE"]
[3,"Assurant, Inc.","AIZ",39.31,41.17,36.19,67.739999999999995,65.180000000000007,77.400000000000006,"NYSE"]
[4,"Allstate","ALL",31.35,23.98,43.21,54.09,70.42,58.44,"NYSE"]
[5,"Amazon","AMZN",185.49,173.1,267.94,399.61,308.52,587,"NASDAQ"]
[6,"Aeropostale","ARO",24.83,16.39,13.81,7.71,2.97,0.25,"NYSE"]
[7,"Avery Dennison Corp","AVY",41.49,28.8,35.93,51.15,51.79,58.16,"NYSE"]
[8,"American Express","AXP",46,49.76,59.61,86.95,93.02,54.52,"NYSE"]
[9,"Bank of America Corp","BAC",15.25,6.61,12.11,16.41,15.73,13.69,"NYSE"]
[10,"Blackberry","BBRY",64.77,16.170000000000002,17.54,9.08,10.38,6.99,"NYSE"]
[11,"Build-a-Bear Workshop","BBW",7.61,7.87,4.6100000000000003,8.73,22.44,12.89,"NYSE"]
[12,"Barnes & Noble","BKS",16.88,16.16,12.76,14.68,24.8,8.08,"NYSE"]
[13,"Citigroup","C",51.3,28.55,42.43,54.72,46.95,41.06,"NYSE"]
[14,"Cabelas Inc","CAB",22.15,25.15,51.92,65.790000000000006,54.93,41.28,"NYSE"]
[15,"Cardinal Health Inc.","CAH",40.590000000000003,41.52,44.64,69.319999999999993,80.510000000000005,79.27,"NYSE"]
[16,"CBS Corporation","CBS",19.940000000000001,27.79,40.42,63.14,54.79,45.88,"NYSE"]
[17,"Carnival Corp","CCL",47.85,34.28,37.06,41.36,46.3,49.57,"NYSE"]
[18,"Colgate ","CL",39.159999999999997,44.9,53.55,64.7,69.3,62.81,"NYSE"]
[19,"Comcast Corporation","CMCSA",22.84,25.38,38.46,51.07,56.31,53.55,"NASDAQ"]
[20,"Cinemark Holdings Inc.","CNK",16.82,19.760000000000002,27.22,32.42,37.17,31.03,"NYSE"]
[21,"Costco","COST",70.650000000000006,81.13,101.2,117.29,141.61000000000001,154.82,"NASDAQ"]
[22,"Campbell Soup Company","CPB",35.32,31.75,36.29,41.79,45.75,50.82,"NYSE",null,null,null,null,null,null,null,null,2012,2013,2014,2015,2016,2017]
[23,"Cirrus Logic","CRUS",15.98,16.5,29.39,17.510000000000002,26.5,25.76,"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",43.02,36.590000000000003,40.020000000000003,31.6,38.4,22.24,"NYSE",null,null,null,null,null,null,null,null,{"$f":"IF('2012'!F15=0,\"\",IF('2012'!F15>0,RANDBETWEEN(1,100)))","v":""},{"$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('2015'!F15>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F15=0,\"\",IF('2016'!F15>0,RANDBETWEEN(1,100)))","v":""}]
[25,"Delta Airlines","DAL",11.54,8.85,12.98,29.23,50.56,44.5,"NYSE",null,null,null,null,null,null,null,null,{"$f":"IF('2012'!F16=0,\"\",IF('2012'!F16>0,RANDBETWEEN(1,100)))","v":""},{"$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('2015'!F16=0,\"\",IF('2015'!F16>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F16=0,\"\",IF('2016'!F16>0,RANDBETWEEN(1,100)))","v":""}]
[26,"3D Systems","DDD",12.28,12.27,39.229999999999997,96.42,29.08,6.42,"NYSE",null,null,null,null,null,null,null,null,{"$f":"IF('2012'!F17=0,\"\",IF('2012'!F17>0,RANDBETWEEN(1,100)))","v":""},{"$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('2015'!F17=0,\"\",IF('2015'!F17>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F17=0,\"\",IF('2016'!F17>0,RANDBETWEEN(1,100)))","v":""}]
[27,"Walt Disney Co","DIS",39.450000000000003,38.4,52.19,75.39,93.75,99.25,"NYSE",null,null,null,null,null,null,null,null,{"$f":"IF('2012'!F18=0,\"\",IF('2012'!F18>0,RANDBETWEEN(1,100)))","v":""},{"$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('2015'!F18=0,\"\",IF('2015'!F18>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F18=0,\"\",IF('2016'!F18>0,RANDBETWEEN(1,100)))","v":""}]
[28,"Dick's Sporting Goods","DKS",35.42,34.64,48.82,57.59,49.94,35.83,"NYSE",null,null,null,null,null,null,null,null,{"$f":"IF('2012'!F19=0,\"\",IF('2012'!F19>0,RANDBETWEEN(1,100)))","v":""},{"$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('2015'!F19=0,\"\",IF('2015'!F19>0,RANDBETWEEN(1,100)))","v":""},{"$f":"IF('2016'!F19=0,\"\",IF('2016'!F19>0,RANDBETWEEN(1,100)))","v":""}]
[29,"Dr Pepper Snapple","DPS",35.549999999999997,37.67,45.3,47.88,71.599999999999994,89.16,"NYSE"]
[30,"Datalink Corporation","DTLK",5.79,8.89,9.18,13.81,12.97,6.24,"NASDAQ"]
[31,"GEO Group","GEO",23.41,17.41,32.49,33.479999999999997,41.51,29,"NYSE"]
[32,"EA Games","EA",15,18.04,14.46,24.1,54.86,64.48,"NASDAQ"]
[33,"Ebay","EBAY",27.7,30.63,54.21,52.16,53,25.86,"NYSE"]
[34,"Ford","F",18.649999999999999,11.71,13.68,15.51,15.21,12.54,"NYSE"]
[35,"Fedex","FDX",93.15,85.49,94.91,142.63,176.01,134.71,"NYSE"]
[36,"21st Century Fox","FOX",16.91,18.920000000000002,27.83,34.659999999999997,31.85,25.89,"NASDAQ"]
[37,"General Electric","GE",18.82,18.649999999999999,21.13,25.13,23.59,28.58,"NYSE"]
[38,"General Motors","GM",38.979999999999997,22.92,29.07,36.08,32.619999999999997,30.3,"NYSE"]
[39,"Game Stop","GME",20.77,24.87,23.71,37.65,32.270000000000003,28.45,"NYSE"]
[40,"Rangold Resources LTD","GOLD",76.430000000000007,106.75,95.83,70.11,74.91,60.99,"NASDAQ"]
[41,"Gap Inc.","GPS",19.2,18,33.54,37.299999999999997,42.02,23.36,"NYSE"]
[42,"Goldman Sachs","GS",175,108.74,137.13,178.39,180.49,164.62,"NYSE"]
[43,"Honda","HMC",40.24,32.130000000000003,37.75,39.76,31.17,27.62,"NYSE"]
[44,"Hewlett Packard","HPQ",45.09,26.4,16.16,28.34,36.130000000000003,10.58,"NYSE"]
[45,"Hershey Co.","HSY",49.39,60.69,74.540000000000006,95.81,110.66,83.32,"NYSE"]
[46,"Jet Blue","JBLU",7.08,5.45,5.95,9.0500000000000007,14.85,20.286999999999999,"NYSE"]
[47,"Johnson & Johnson","JNJ",62.6,65.27,71.55,94.74,104.52,100.9,"NYSE"]
[48,"JP Morgan","JPM",44.91,35.36,47.16,58.49,54.38,58.96,"NYSE"]
[49,"Nordstrom","JWN",40.909999999999997,49.74,55.12,61.11,78.5,50.13,"NYSE"]
[50,"Kellog Stock","K",51,50.81,57.02,60.58,68.680000000000007,72.010000000000005,"NYSE"]
[51,"Kimberly Clark Corp","KMB",62.99,72.7,85.1,104.35,107.96,125.71,"NYSE"]
[52,"The Coca-Cola Co","KO",31.1,33.5,38.770000000000003,40.130000000000003,43.31,41.51,"NYSE"]
[53,"Lee Enterprises","LEE",2.82,0.75,1.33,4.2,3.13,1.67,"NYSE"]
[54,"L-3 Communications","LLL",75.87,67.069999999999993,77.709999999999994,106.32,125.67,108.05,"NYSE"]
[55,"Logitech","LOGI",19.13,8.0500000000000007,7.24,15.46,14.94,13.78,"NASDAQ"]
[56,"Southwest Airlines","LUV",13.29,8.52,11.26,21.22,40.75,42.85,"NYSE"]
[57,"La-Z Boy Incorporated","LZB",8.89,12.77,15.27,30.97,27.01,22.36,"NYSE"]
[58,"Macy's, Inc.","M",23.31,34.56,36.89,56.23,65.83,36.15,"NYSE"]
[59,"Mattel Inc.","MAT",23.51,29.35,38.03,46.87,27.82,26.92,"NASDAQ"]
[60,"McDonalds ","MCD",74.06,101.74,91.73,96.54,89.56,115.48,"NYSE"]
[61,"Metlife","MET",46.21,35.24,35.950000000000003,54.1,53.91,43,"NYSE"]
[62,"3M","MMM",86.23,87.46,100.59,138.44999999999999,161.62,147.46,"NYSE"]
[63,"Microsoft","MSFT",28.6,28.11,26.74,36.909999999999997,47.18,51.64,"NASDAQ"]
[64,"Motorolla","MSI",38.9,46.55,57.5,66.099999999999994,65.11,60.36,"NYSE"]
[65,"Nestle","NESN",51.35,53.2,63.4,66.849999999999994,64.8,73.05,"NYSE"]
[66,"Newmarket Corp","NEU",129.59,218.6,286.54000000000002,333.61,402.09,368.02,"NYSE"]
[67,"Nike","NKE",41.76,50.88,53.29,73.39,95.99,58.78,"NYSE"]
[68,"Nokia","NOK",9.5500000000000007,5.24,4.18,7.79,7.55,7.46,"NYSE"]
[69,"Nu Skin Enterprises","NUS",30.97,47.26,45.08,137.68,41.61,32.299999999999997,"NYSE"]
[70,"Newell Rubbermaid","NWL",17.7,17.190000000000001,21.8,32.4,38.159999999999997,36.200000000000003,"NYSE"]
[71,"HCA Holdings","HCA",32.950000000000003,23.9,31.94,51.41,73.97,67.83,"NYSE"]
[72,"PepsiCo Inc.","PEP",66.39,65.39,70.88,83.5,96.82,97.44,"NYSE"]
[73,"Procter & Gamble Co","PG",64.2,65.81,69.22,80.3,84.29,77.86,"NYSE"]
[74,"Progressive Corp.","PGR",19.47,20.43,22.72,25.94,26.92,30.64,"NYSE"]
[75,"Pier 1 Imports","PIR",9.43,15,22.02,21.57,16.36,4.09,"NYSE"]
[76,"Rite Aid Corporation","RAD",1.39,1.38,1.56,5.47,7.51,7.76,"NYSE"]
[77,"Royal Caribbean Cruises","RCL",49.96,25.5,38.42,49.09,82.95,85.48,"NYSE"]
[78,"Regeneron Pharmaceuticals","REGN",34.1,65.790000000000006,179.46,271.75,408.69,463.46,"NASDAQ"]
[79,"Sturm, Ruger & Company","RGR",14.85,38.68,47.51,80.55,38.71,51.89,"NYSE"]
[80,"Starbucks Corporation","SBUX",16.350000000000001,23.68,27.4,38.840000000000003,39.9,58.65,"NYSE"]
[81,"JM Smucker Co","SJM",61.84,78.59,90.2,101.51,101.86,122.38,"NYSE"]
[82,"Sony","SNE",35.880000000000003,17.440000000000001,11.09,15.75,22.6,22.21,"NYSE"]
[83,"Smith & Wesson","SWHC",3.63,4.74,9.02,13.43,10.02,20.55,"NASDAQ"]
[84,"AT&T","T",27.92,30.51,33.44,34.799999999999997,33.369999999999997,34.590000000000003,"NYSE"]
[85,"Target","TGT",54.35,50.17,61.54,60.24,74.94,71.38,"NYSE"]
[86,"Toyota","TM",82.46,71.400000000000006,96.1,119.19,128.88,112.6,"NYSE"]
[87,"Tesoro","TSO",19.350000000000001,22.95,42.17,52.58,75.5,91.92,"NYSE"]
[88,"Tesla Motors","TSLA",23.04,26.6,34.520000000000003,145.72,219.31,207.85,"NASDAQ"]
[89,"Tyler Technologies","TYL",20.36,31.81,50.01,105.45,107.85,163.79,"NYSE"]
[90,"Under Armour Inc.","UA",13.31,19.29,24.04,41,69.819999999999993,80.150000000000006,"NYSE"]
[91,"UnitedHealth Group","UNH",40.409999999999997,52.27,52.09,74.7,100.78,109.23,"NYSE"]
[92,"United Parcel Service","UPS",72.48,73.48,76.569999999999993,96.33,98.87,88.7,"NYSE"]
[93,"Visa Inc.","V",17.54,25.18,39.19,58.04,63.74,75.7,"NYSE"]
[94,"Viacom","VIAB",40.520000000000003,46.89,59.02,85.4,64.42,40.97,"NYSE"]
[95,"Verizon","VZ",35.93,38.33,42.54,48.42,47.99,45.52,"NYSE"]
[96,"Walmart","WMT",56.7,61.01,69,78.650000000000006,89.35,63.54,"NYSE"]
[97,"Watsco Inc.","WSO",61.83,67.61,76.150000000000006,96.62,110.74,109.28,"NYSE"]
[98,"Exxon Mobil Corporation","XOM",75.59,87.49,91.73,99.16,90.89,77.47,"NYSE"]
[99,"Yahoo","YHOO",16.809999999999999,15.52,19.29,41.23,46.47,30.17,"NASDAQ"]
[100,"YUM! Brands","YUM",46.4,61.23,65.150000000000006,72.099999999999994,72.430000000000007,68.02,"NYSE"]