{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["2011","2012","2013","2014","2015","Today","Stocks"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[25,5,25,6],[4,0,6,6],[0,0,0,6],[9,0,9,6],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,3],[7,0,7,6]]}
["Quickie Stock Market Game"]
[]
["Name:",null,"Joseph Winder"]
["Period:",null,4]
["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:$I$101,2,FALSE)","v":"L-3 Communications"},54,{"$f":"VLOOKUP(C12,Stocks!$A$2:$I$101,3,FALSE)","v":"LLL"},{"$f":"VLOOKUP(C12,Stocks!$A$2:$D$101,4,FALSE)","v":75.87},1,{"$f":"E12*F12","v":75.87}]
[2,{"$f":"VLOOKUP(C13,Stocks!$A$2:$I$101,2,FALSE)","v":"L-3 Communications"},54,{"$f":"VLOOKUP(C13,Stocks!$A$2:$I$101,3,FALSE)","v":"LLL"},{"$f":"VLOOKUP(C13,Stocks!$A$2:$D$101,4,FALSE)","v":75.87},2,{"$f":"E13*F13","v":151.74}]
[3,{"$f":"VLOOKUP(C14,Stocks!$A$2:$I$101,2,FALSE)","v":"General Motors"},38,{"$f":"VLOOKUP(C14,Stocks!$A$2:$I$101,3,FALSE)","v":"GM"},{"$f":"VLOOKUP(C14,Stocks!$A$2:$D$101,4,FALSE)","v":38.979999999999997},1,38.979999999999997]
[4,{"$f":"VLOOKUP(C15,Stocks!$A$2:$I$101,2,FALSE)","v":"Amazon"},5,{"$f":"VLOOKUP(C15,Stocks!$A$2:$I$101,3,FALSE)","v":"AMZN"},{"$f":"VLOOKUP(C15,Stocks!$A$2:$D$101,4,FALSE)","v":185.49},1,185.49]
[5,{"$f":"VLOOKUP(C16,Stocks!$A$2:$I$101,2,FALSE)","v":"Pier 1 Imports"},75,{"$f":"VLOOKUP(C16,Stocks!$A$2:$I$101,3,FALSE)","v":"PIR"},{"$f":"VLOOKUP(C16,Stocks!$A$2:$D$101,4,FALSE)","v":9.43},5,47.15]
[null,null,null,null,null,null,{"$f":"SUM(G12:G16)","v":499.23}]
[]
[]
[null,"2012 Increase",null,{"$f":"'2012'!M6","v":-27}]
[null,"2013 Increase",null,{"$f":"'2013'!M6","v":197.19999999999993}]
[null,"2014 Increase",null,{"$f":"'2014'!M6","v":409.20000000000005}]
[null,"2015 Increase",null,{"$f":"'2015'!M6","v":359.36999999999989}]
[]
[null,"2011 Portfolio:",null,{"$f":"G17","v":499.23}]
[null,"Today's Portfolio:",null,{"$f":"Today!M7","v":1157.26},null,"Print this Page Only!"]
[null,"Cash Assets",null,{"$f":"Today!M8","v":1142.82}]
[null,"Less Initial Investment:",null,{"$f":"G17","v":499.23}]
[null,"TOTAL INCREASE:",null,{"$f":"D27-D28","v":643.58999999999992}]

{"sheet":"2012","index":1,"n_rows":30,"n_cols":13,"rows_kept":30,"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":"L-3 Communications"},{"$f":"'2011'!C12","v":54},{"$f":"'2011'!D12","v":"LLL"},{"$f":"'2011'!E12","v":75.87},{"$f":"'2011'!F12","v":1},{"$f":"E4*F4","v":75.87},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,5,FALSE)","v":67.069999999999993},{"$f":"H4-E4","v":-8.8000000000000114},{"$f":"F4*H4","v":67.069999999999993}]
[2,{"$f":"'2011'!B13","v":"L-3 Communications"},{"$f":"'2011'!C13","v":54},{"$f":"'2011'!D13","v":"LLL"},{"$f":"'2011'!E13","v":75.87},{"$f":"'2011'!F13","v":2},{"$f":"E5*F5","v":151.74},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,5,FALSE)","v":67.069999999999993},{"$f":"H5-E5","v":-8.8000000000000114},{"$f":"F5*H5","v":134.13999999999999},null,"Stock Portfolio"]
[3,{"$f":"'2011'!B14","v":"General Motors"},{"$f":"'2011'!C14","v":38},{"$f":"'2011'!D14","v":"GM"},{"$f":"'2011'!E14","v":38.979999999999997},{"$f":"'2011'!F14","v":1},38.979999999999997,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,5,FALSE)","v":22.92},-16.059999999999995,22.92,null,"Market Gains:",{"$f":"J9-G9","v":-27}]
[4,{"$f":"'2011'!B15","v":"Amazon"},{"$f":"'2011'!C15","v":5},{"$f":"'2011'!D15","v":"AMZN"},{"$f":"'2011'!E15","v":185.49},{"$f":"'2011'!F15","v":1},185.49,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,5,FALSE)","v":173.1},-12.390000000000015,173.1,null,"2012 Portfolio:",{"$f":"J9","v":472.23}]
[5,{"$f":"'2011'!B16","v":"Pier 1 Imports"},{"$f":"'2011'!C16","v":75},{"$f":"'2011'!D16","v":"PIR"},{"$f":"'2011'!E16","v":9.43},{"$f":"'2011'!F16","v":5},47.15,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,5,FALSE)","v":15},5.57,75,null,"2012 Sell:",{"$f":"F20","v":142.07}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":499.23},null,null,{"$f":"SUM(J4:J8)","v":472.23},null,"2012 Buy:",{"$f":"G30","v":232.95999999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7-M8+G30","v":563.12}]
["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":-90.889999999999986}]
[null,null,null,{"$f":"D4","v":"LLL"},null,{"$f":"J4","v":67.069999999999993},null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":409.11}]
[null,null,null,{"$f":"D5","v":"LLL"}]
[null,null,null,{"$f":"D6","v":"GM"}]
[null,null,null,{"$f":"D7","v":"AMZN"}]
[null,null,null,{"$f":"D8","v":"PIR"},null,{"$f":"J8","v":75}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":142.07}]
[]
["BUY"]
[]
[null,"Buy",null,null,null,"Shares","Total","Companies"]
[61,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$C$101,2,FALSE)))","v":"Metlife"},{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,3,FALSE)))","v":"MET"},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,5,FALSE)))","v":35.24},3,{"$f":"IF(A25=\"\",\"\",IF(A25>0,E25*F25))","v":105.72},{"$f":"IF(A25=\"\",C4,A25)","v":61}]
["",{"$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":54}]
["",{"$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,"",38]
["",{"$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,"",5]
[89,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$C$101,2,FALSE)))","v":"Tyler Technologies"},{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,3,FALSE)))","v":"TYL"},null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,5,FALSE)))","v":31.81},4,127.24,89]
[null,null,null,null,null,null,{"$f":"SUM(G25:G29)","v":232.95999999999998}]

{"sheet":"2013","index":2,"n_rows":30,"n_cols":13,"rows_kept":30,"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":"Metlife"},{"$f":"'2012'!H25","v":61},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"MET"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,5,FALSE)","v":35.24},{"$f":"IF('2012'!F25=\"\",'2012'!F4,'2012'!F25)","v":3},{"$f":"E4*F4","v":105.72},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,6,FALSE)","v":35.950000000000003},{"$f":"H4-E4","v":0.71000000000000085},{"$f":"F4*H4","v":107.85000000000001}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"L-3 Communications"},{"$f":"'2012'!H26","v":54},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"LLL"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,5,FALSE)","v":67.069999999999993},{"$f":"IF('2012'!F26=\"\",'2012'!F5,'2012'!F26)","v":2},{"$f":"E5*F5","v":134.13999999999999},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,6,FALSE)","v":77.709999999999994},{"$f":"H5-E5","v":10.64},{"$f":"F5*H5","v":155.41999999999999},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"General Motors"},{"$f":"'2012'!H27","v":38},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"GM"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,5,FALSE)","v":22.92},{"$f":"IF('2012'!F27=\"\",'2012'!F6,'2012'!F27)","v":1},22.92,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,6,FALSE)","v":29.07},6.1499999999999986,29.07,null,"Total Increase:",{"$f":"J9-G9","v":197.19999999999993}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Amazon"},{"$f":"'2012'!H28","v":5},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"AMZN"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,5,FALSE)","v":173.1},{"$f":"IF('2012'!F28=\"\",'2012'!F7,'2012'!F28)","v":1},173.1,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,6,FALSE)","v":267.94},94.84,267.94,null,"2013 Portfolio:",{"$f":"J9","v":760.31999999999994}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Tyler Technologies"},{"$f":"'2012'!H29","v":89},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"TYL"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,5,FALSE)","v":31.81},{"$f":"IF('2012'!F29=\"\",'2012'!F8,'2012'!F29)","v":4},127.24,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,6,FALSE)","v":50.01},18.2,200.04,null,"2013 Sell:",{"$f":"F20","v":263.27}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":563.12},null,null,{"$f":"SUM(J4:J8)","v":760.31999999999994},null,"2013 Buy:",{"$f":"G30","v":237.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7-M8+M9","v":734.55}]
["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":409.11}]
[null,null,null,"Current",null,"Sell",null,null,null,null,null,"Liquid Assets",{"$f":"F20-G30","v":25.769999999999982}]
[null,null,null,{"$f":"D4","v":"MET"},null,{"$f":"J4","v":107.85000000000001},null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":434.88}]
[null,null,null,{"$f":"D5","v":"LLL"},null,{"$f":"J5","v":155.41999999999999}]
[null,null,null,{"$f":"D6","v":"GM"}]
[null,null,null,{"$f":"D7","v":"AMZN"}]
[null,null,null,{"$f":"D8","v":"TYL"}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":263.27}]
[]
["BUY"]
[]
[null,"Buy",null,null,null,"Shares","Total"]
[29,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$C$101,2,FALSE)))","v":"Dr Pepper Snapple"},{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,3,FALSE)))","v":"DPS"},null,{"$f":"IF(A25=\"\",\"\",IF(A25>0,VLOOKUP(A25,Stocks!$A$2:$H$101,6,FALSE)))","v":45.3},1,{"$f":"IF(A25=\"\",\"\",IF(A25>0,E25*F25))","v":45.3},{"$f":"IF(A25=\"\",C4,A25)","v":29}]
[86,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$C$101,2,FALSE)))","v":"Toyota"},{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,3,FALSE)))","v":"TM"},null,{"$f":"IF(A26=\"\",\"\",IF(A26>0,VLOOKUP(A26,Stocks!$A$2:$H$101,6,FALSE)))","v":96.1},2,{"$f":"IF(A26=\"\",\"\",IF(A26>0,E26*F26))","v":192.2},{"$f":"IF(A26=\"\",C5,A26)","v":86}]
["",{"$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,"",38]
["",{"$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,6,FALSE)))","v":""},null,"",5]
["",{"$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,"",89]
[null,null,null,null,null,null,{"$f":"SUM(G25:G29)","v":237.5}]

{"sheet":"2014","index":3,"n_rows":30,"n_cols":13,"rows_kept":30,"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":"Dr Pepper Snapple"},{"$f":"'2013'!H25","v":29},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"DPS"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,6,FALSE)","v":45.3},{"$f":"IF('2013'!F25=\"\",'2013'!F4,'2013'!F25)","v":1},{"$f":"E4*F4","v":45.3},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,7,FALSE)","v":47.88},{"$f":"H4-E4","v":2.5800000000000054},{"$f":"F4*H4","v":47.88}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"Toyota"},{"$f":"'2013'!H26","v":86},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"TM"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,6,FALSE)","v":96.1},{"$f":"IF('2013'!F26=\"\",'2013'!F5,'2013'!F26)","v":2},{"$f":"E5*F5","v":192.2},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,7,FALSE)","v":119.19},{"$f":"H5-E5","v":23.090000000000003},{"$f":"F5*H5","v":238.38},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"General Motors"},{"$f":"'2013'!H27","v":38},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"GM"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,6,FALSE)","v":29.07},{"$f":"IF('2013'!F27=\"\",'2013'!F6,'2013'!F27)","v":1},29.07,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,7,FALSE)","v":36.08},7.009999999999998,36.08,null,"Total Increase:",{"$f":"J9-G9","v":409.20000000000005}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Amazon"},{"$f":"'2013'!H28","v":5},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"AMZN"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,6,FALSE)","v":267.94},{"$f":"IF('2013'!F28=\"\",'2013'!F7,'2013'!F28)","v":1},267.94,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,7,FALSE)","v":399.61},131.67000000000002,399.61,null,"2013 Portfolio:",{"$f":"'2013'!M10","v":734.55}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Tyler Technologies"},{"$f":"'2013'!H29","v":89},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"TYL"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,6,FALSE)","v":50.01},{"$f":"IF('2013'!F29=\"\",'2013'!F8,'2013'!F29)","v":4},200.04,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,7,FALSE)","v":105.45},55.440000000000005,421.8,null,"2013 Sell:",{"$f":"F20","v":421.8}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":734.55},null,null,{"$f":"SUM(J4:J8)","v":1143.75},null,"2013 Buy:",{"$f":"G30","v":815.25}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Gain",{"$f":"M7-M8+M9","v":1128}]
["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":434.88}]
[null,null,null,"Current",null,"Sell",null,null,null,null,null,"Liquid Assets",{"$f":"F20-G30","v":-393.45}]
[null,null,null,{"$f":"D4","v":"DPS"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":41.430000000000007}]
[null,null,null,{"$f":"D5","v":"TM"}]
[null,null,null,{"$f":"D6","v":"GM"}]
[null,null,null,{"$f":"D7","v":"AMZN"}]
[null,null,null,{"$f":"D8","v":"TYL"},null,{"$f":"J8","v":421.8}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":421.8}]
[]
["BUY"]
[]
[null,"Buy",null,null,null,"Shares","Total"]
["",{"$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":29}]
["",{"$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":86}]
["",{"$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,"",38]
["",{"$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,"",5]
[78,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$C$101,2,FALSE)))","v":"Regeneron Pharmaceuticals"},{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,3,FALSE)))","v":"REGN"},null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,7,FALSE)))","v":271.75},3,815.25,78]
[null,null,null,null,null,null,{"$f":"SUM(G25:G29)","v":815.25}]

{"sheet":"2015","index":4,"n_rows":30,"n_cols":13,"rows_kept":30,"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":"Dr Pepper Snapple"},{"$f":"'2014'!H25","v":29},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"DPS"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,7,FALSE)","v":47.88},{"$f":"IF('2014'!F25=\"\",'2014'!F4,'2014'!F25)","v":1},{"$f":"E4*F4","v":47.88},{"$f":"VLOOKUP(C4,Stocks!$A$2:$H$101,8,FALSE)","v":71.599999999999994},{"$f":"H4-E4","v":23.719999999999992},{"$f":"F4*H4","v":71.599999999999994}]
[2,{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,2,FALSE)","v":"Toyota"},{"$f":"'2014'!H26","v":86},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"TM"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,7,FALSE)","v":119.19},{"$f":"IF('2014'!F26=\"\",'2014'!F5,'2014'!F26)","v":2},{"$f":"E5*F5","v":238.38},{"$f":"VLOOKUP(C5,Stocks!$A$2:$H$101,8,FALSE)","v":128.88},{"$f":"H5-E5","v":9.6899999999999977},{"$f":"F5*H5","v":257.76},null,"Stock Portfolio"]
[3,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,2,FALSE)","v":"General Motors"},{"$f":"'2014'!H27","v":38},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"GM"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,7,FALSE)","v":36.08},{"$f":"IF('2014'!F27=\"\",'2014'!F6,'2014'!F27)","v":1},36.08,{"$f":"VLOOKUP(C6,Stocks!$A$2:$H$101,8,FALSE)","v":32.619999999999997},-3.4600000000000009,32.619999999999997,null,"Total Increase:",{"$f":"J9-G9","v":359.36999999999989}]
[4,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,2,FALSE)","v":"Amazon"},{"$f":"'2014'!H28","v":5},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"AMZN"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,7,FALSE)","v":399.61},{"$f":"IF('2014'!F28=\"\",'2014'!F7,'2014'!F28)","v":1},399.61,{"$f":"VLOOKUP(C7,Stocks!$A$2:$H$101,8,FALSE)","v":308.52},-91.090000000000032,308.52,null,"2014 Portfolio:",{"$f":"J9","v":1896.57}]
[5,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,2,FALSE)","v":"Regeneron Pharmaceuticals"},{"$f":"'2014'!H29","v":78},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"REGN"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,7,FALSE)","v":271.75},{"$f":"IF('2014'!F29=\"\",'2014'!F8,'2014'!F29)","v":3},815.25,{"$f":"VLOOKUP(C8,Stocks!$A$2:$H$101,8,FALSE)","v":408.69},136.94,1226.07,null,"2014 Sell:",{"$f":"F20","v":1226.07}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":1537.2},null,null,{"$f":"SUM(J4:J8)","v":1896.57},null,"2014 Buy:",{"$f":"G30","v":124.68}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M7-M8+M9","v":795.18000000000006}]
["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":41.430000000000007}]
[null,null,null,"Current",null,"Sell",null,null,null,null,null,"Liquid Assets",{"$f":"F20-G30","v":1101.3899999999999}]
[null,null,null,{"$f":"D4","v":"DPS"},null,null,null,null,null,null,null,"Total Cash",{"$f":"M13+M14","v":1142.82}]
[null,null,null,{"$f":"D5","v":"TM"}]
[null,null,null,{"$f":"D6","v":"GM"}]
[null,null,null,{"$f":"D7","v":"AMZN"}]
[null,null,null,{"$f":"D8","v":"REGN"},null,{"$f":"J8","v":1226.07}]
[null,null,null,null,null,{"$f":"SUM(F15:F19)","v":1226.07}]
[]
["BUY"]
[]
[null,"Buy",null,null,null,"Shares","Total"]
["",{"$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":29}]
["",{"$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":86}]
["",{"$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,"",38]
["",{"$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,"",5]
[43,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$C$101,2,FALSE)))","v":"Honda"},{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,3,FALSE)))","v":"HMC"},null,{"$f":"IF(A29=\"\",\"\",IF(A29>0,VLOOKUP(A29,Stocks!$A$2:$H$101,8,FALSE)))","v":31.17},4,124.68,43]
[null,null,null,null,null,null,{"$f":"SUM(G25:G29)","v":124.68}]

{"sheet":"Today","index":5,"n_rows":9,"n_cols":13,"rows_kept":9,"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 2015","# 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":"Dr Pepper Snapple"},{"$f":"'2015'!H25","v":29},{"$f":"VLOOKUP(C4,Stocks!$A$2:$C$101,3,FALSE)","v":"DPS"},{"$f":"VLOOKUP(C4,Stocks!$A$2:$M$101,8,FALSE)","v":71.599999999999994},{"$f":"IF('2015'!F25=\"\",'2015'!F4,'2015'!F25)","v":1},{"$f":"E4*F4","v":71.599999999999994},86.26,{"$f":"H4-E4","v":14.660000000000011},{"$f":"F4*H4","v":86.26}]
[2,{"$f":"IF('2015'!B26=\"\",'2015'!B5,'2015'!B26)","v":"Toyota"},{"$f":"'2015'!H26","v":86},{"$f":"VLOOKUP(C5,Stocks!$A$2:$C$101,3,FALSE)","v":"TM"},{"$f":"VLOOKUP(C5,Stocks!$A$2:$M$101,8,FALSE)","v":128.88},{"$f":"IF('2015'!F26=\"\",'2015'!F5,'2015'!F26)","v":2},{"$f":"E5*F5","v":257.76},122.92,{"$f":"H5-E5","v":-5.9599999999999937},{"$f":"F5*H5","v":245.84},null,"Stock Portfolio"]
[3,{"$f":"IF('2015'!B27=\"\",'2015'!B6,'2015'!B27)","v":"General Motors"},{"$f":"'2015'!H27","v":38},{"$f":"VLOOKUP(C6,Stocks!$A$2:$C$101,3,FALSE)","v":"GM"},{"$f":"VLOOKUP(C6,Stocks!$A$2:$M$101,8,FALSE)","v":32.619999999999997},{"$f":"IF('2015'!F27=\"\",'2015'!F6,'2015'!F27)","v":1},32.619999999999997,35.75,3.1300000000000026,35.75,null,"Total Increase:",{"$f":"J9-G9","v":362.07999999999993}]
[4,{"$f":"IF('2015'!B28=\"\",'2015'!B7,'2015'!B28)","v":"Amazon"},{"$f":"'2015'!H28","v":5},{"$f":"VLOOKUP(C7,Stocks!$A$2:$C$101,3,FALSE)","v":"AMZN"},{"$f":"VLOOKUP(C7,Stocks!$A$2:$M$101,8,FALSE)","v":308.52},{"$f":"IF('2015'!F28=\"\",'2015'!F7,'2015'!F28)","v":1},308.52,659.37,350.85,659.37,null,"Today's Portfolio:",{"$f":"J9","v":1157.26}]
[5,{"$f":"IF('2015'!B29=\"\",'2015'!B8,'2015'!B29)","v":"Honda"},{"$f":"'2015'!H29","v":43},{"$f":"VLOOKUP(C8,Stocks!$A$2:$C$101,3,FALSE)","v":"HMC"},{"$f":"VLOOKUP(C8,Stocks!$A$2:$M$101,8,FALSE)","v":31.17},{"$f":"IF('2015'!F29=\"\",'2015'!F8,'2015'!F29)","v":4},124.68,32.51,1.3399999999999963,130.04,null,"Liquid Assets:",{"$f":"'2015'!M15","v":1142.82}]
[null,null,null,null,null,null,{"$f":"SUM(G4:G8)","v":795.18000000000006},null,null,{"$f":"SUM(J4:J8)","v":1157.26},null,null,{"$f":"SUM(M7:M8)","v":2300.08}]

{"sheet":"Stocks","index":6,"n_rows":101,"n_cols":22,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[null,null,null,2011,2012,2013,2014,2015]
[1,"Apple","AAPL",48.02,59.97,74.33,76.13,109.33,"NASDAQ"]
[2,"Alliance Fiber Optic","ADS",71.64,108.49,151.1,256.89,289.55,"NYSE"]
[3,"Assurant, Inc.","AIZ",39.31,41.17,36.19,67.739999999999995,65.180000000000007,"NYSE"]
[4,"Allstate","ALL",31.35,23.98,43.21,54.09,70.42,"NYSE"]
[5,"Amazon","AMZN",185.49,173.1,267.94,399.61,308.52,"NASDAQ"]
[6,"Aeropostale","ARO",24.83,16.39,13.81,7.71,2.97,"NYSE"]
[7,"Avery Dennison Corp","AVY",41.49,28.8,35.93,51.15,51.79,"NYSE"]
[8,"American Express","AXP",46,49.76,59.61,86.95,93.02,"NYSE"]
[9,"Bank of America Corp","BAC",15.25,6.61,12.11,16.41,15.73,"NYSE"]
[10,"Blackberry","BBRY",64.77,16.170000000000002,17.54,9.08,10.38,"NYSE"]
[11,"Build-a-Bear Workshop","BBW",7.61,7.87,4.6100000000000003,8.73,22.44,"NYSE"]
[12,"Barnes & Noble","BKS",16.88,16.16,12.76,14.68,24.8,"NYSE"]
[13,"Citigroup","C",51.3,28.55,42.43,54.72,46.95,"NYSE"]
[14,"Cabelas Inc","CAB",22.15,25.15,51.92,65.790000000000006,54.93,"NYSE"]
[15,"Cardinal Health Inc.","CAH",40.590000000000003,41.52,44.64,69.319999999999993,80.510000000000005,"NYSE"]
[16,"CBS Corporation","CBS",19.940000000000001,27.79,40.42,63.14,54.79,"NYSE"]
[17,"Carnival Corp","CCL",47.85,34.28,37.06,41.36,46.3,"NYSE"]
[18,"Colgate ","CL",39.159999999999997,44.9,53.55,64.7,69.3,"NYSE"]
[19,"Comcast Corporation","CMCSA",22.84,25.38,38.46,51.07,56.31,"NASDAQ"]
[20,"Cinemark Holdings Inc.","CNK",16.82,19.760000000000002,27.22,32.42,37.17,"NYSE"]
[21,"Costco","COST",70.650000000000006,81.13,101.2,117.29,141.61000000000001,"NASDAQ"]
[22,"Campbell Soup Company","CPB",35.32,31.75,36.29,41.79,44,"NYSE"]
[23,"Cirrus Logic","CRUS",15.98,16.5,29.39,17.510000000000002,26.5,"NASDAQ",null,null,null,null,null,null,null,null,"1st Buy","2nd Buy","3rd Buy","4th Buy","5th Buy"]
[24,"Century Link","CTL",43.02,36.590000000000003,40.020000000000003,31.6,38.4,"NYSE",null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(1,100)","v":71},{"$f":"IF('2012'!F15=0,\"\",IF('2012'!F15>0,RANDBETWEEN(1,100)))","v":50},{"$f":"IF('2013'!F15=0,\"\",IF('2013'!F15>0,RANDBETWEEN(1,100)))","v":19},{"$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":""}]
[25,"Delta Airlines","DAL",11.54,8.85,12.98,29.23,50.56,"NYSE",null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(1,100)","v":19},{"$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":52},{"$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":""}]
[26,"3D Systems","DDD",12.28,12.27,39.229999999999997,96.42,29.08,"NYSE",null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(1,100)","v":3},{"$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":""}]
[27,"Walt Disney Co","DIS",39.450000000000003,38.4,52.19,75.39,93.75,"NYSE",null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(1,100)","v":100},{"$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":""}]
[28,"Dick's Sporting Goods","DKS",35.42,34.64,48.82,57.59,49.94,"NYSE",null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(1,100)","v":6},{"$f":"IF('2012'!F19=0,\"\",IF('2012'!F19>0,RANDBETWEEN(1,100)))","v":13},{"$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":42},{"$f":"IF('2015'!F19=0,\"\",IF('2015'!F19>0,RANDBETWEEN(1,100)))","v":30}]
[29,"Dr Pepper Snapple","DPS",35.549999999999997,37.67,45.3,47.88,71.599999999999994,"NYSE"]
[30,"Datalink Corporation","DTLK",5.79,8.89,9.18,13.81,12.97,"NASDAQ"]
[31,"Dreamworks ","DWA",28.76,18.25,16.64,33.74,18.670000000000002,"NASDAQ"]
[32,"EA Games","EA",15,18.04,14.46,24.1,54.86,"NASDAQ"]
[33,"Ebay","EBAY",27.7,30.63,54.21,52.16,53,"NYSE"]
[34,"Ford","F",18.649999999999999,11.71,13.68,15.51,15.21,"NYSE"]
[35,"Fedex","FDX",93.15,85.49,94.91,142.63,176.01,"NYSE"]
[36,"21st Century Fox","FOX",16.91,18.920000000000002,27.83,34.659999999999997,31.85,"NASDAQ"]
[37,"General Electric","GE",18.82,18.649999999999999,21.13,25.13,23.59,"NYSE"]
[38,"General Motors","GM",38.979999999999997,22.92,29.07,36.08,32.619999999999997,"NYSE"]
[39,"Game Stop","GME",20.77,24.87,23.71,37.65,32.270000000000003,"NYSE"]
[40,"Rangold Resources LTD","GOLD",76.430000000000007,106.75,95.83,70.11,74.91,"NASDAQ"]
[41,"Gap Inc.","GPS",19.2,18,33.54,37.299999999999997,42.02,"NYSE"]
[42,"Goldman Sachs","GS",175,108.74,137.13,178.39,180.49,"NYSE"]
[43,"Honda","HMC",40.24,32.130000000000003,37.75,39.76,31.17,"NYSE"]
[44,"Hewlett Packard","HPQ",45.09,26.4,16.16,28.34,36.130000000000003,"NYSE"]
[45,"Hershey Co.","HSY",49.39,60.69,74.540000000000006,95.81,110.66,"NYSE"]
[46,"Jet Blue","JBLU",7.08,5.45,5.95,9.0500000000000007,14.85,"NYSE"]
[47,"Johnson & Johnson","JNJ",62.6,65.27,71.55,94.74,104.52,"NYSE"]
[48,"JP Morgan","JPM",44.91,35.36,47.16,58.49,54.38,"NYSE"]
[49,"Nordstrom","JWN",40.909999999999997,49.74,55.12,61.11,78.5,"NYSE"]
[50,"Kellog Stock","K",51,50.81,57.02,60.58,68.680000000000007,"NYSE"]
[51,"Kimberly Clark Corp","KMB",62.99,72.7,85.1,104.35,107.96,"NYSE"]
[52,"The Coca-Cola Co","KO",31.1,33.5,38.770000000000003,40.130000000000003,43.31,"NYSE"]
[53,"Lee Enterprises","LEE",2.82,0.75,1.33,4.2,3.13,"NYSE"]
[54,"L-3 Communications","LLL",75.87,67.069999999999993,77.709999999999994,106.32,125.67,"NYSE"]
[55,"Logitech","LOGI",19.13,8.0500000000000007,7.24,15.46,14.94,"NASDAQ"]
[56,"Southwest Airlines","LUV",13.29,8.52,11.26,21.22,40.75,"NYSE"]
[57,"La-Z Boy Incorporated","LZB",8.89,12.77,15.27,30.97,27.01,"NYSE"]
[58,"Macy's, Inc.","M",23.31,34.56,36.89,56.23,65.83,"NYSE"]
[59,"Mattel Inc.","MAT",23.51,29.35,38.03,46.87,27.82,"NASDAQ"]
[60,"McDonalds ","MCD",74.06,101.74,91.73,96.54,89.56,"NYSE"]
[61,"Metlife","MET",46.21,35.24,35.950000000000003,54.1,53.91,"NYSE"]
[62,"3M","MMM",86.23,87.46,100.59,138.44999999999999,161.62,"NYSE"]
[63,"Microsoft","MSFT",28.6,28.11,26.74,36.909999999999997,47.18,"NASDAQ"]
[64,"Motorolla","MSI",38.9,46.55,57.5,66.099999999999994,65.11,"NYSE"]
[65,"Nestle","NESN",51.35,53.2,63.4,66.849999999999994,64.8,"NYSE"]
[66,"Newmarket Corp","NEU",129.59,218.6,286.54000000000002,333.61,402.09,"NYSE"]
[67,"Nike","NKE",41.76,50.88,53.29,73.39,95.99,"NYSE"]
[68,"Nokia","NOK",9.5500000000000007,5.24,4.18,7.79,7.55,"NYSE"]
[69,"Nu Skin Enterprises","NUS",30.97,47.26,45.08,137.68,41.61,"NYSE"]
[70,"Newell Rubbermaid","NWL",17.7,17.190000000000001,21.8,32.4,38.159999999999997,"NYSE"]
[71,"Pep Boys","PBY",13.19,10.6,10.63,11.8,8.43,"NYSE"]
[72,"PepsiCo Inc.","PEP",66.39,65.39,70.88,83.5,96.82,"NYSE"]
[73,"Procter & Gamble Co","PG",64.2,65.81,69.22,80.3,84.29,"NYSE"]
[74,"Progressive Corp.","PGR",19.47,20.43,22.72,25.94,26.92,"NYSE"]
[75,"Pier 1 Imports","PIR",9.43,15,22.02,21.57,16.36,"NYSE"]
[76,"Rite Aid Corporation","RAD",1.39,1.38,1.56,5.47,7.51,"NYSE"]
[77,"Royal Caribbean Cruises","RCL",49.96,25.5,38.42,49.09,82.95,"NYSE"]
[78,"Regeneron Pharmaceuticals","REGN",34.1,65.790000000000006,179.46,271.75,408.69,"NASDAQ"]
[79,"Sturm, Ruger & Company","RGR",14.85,38.68,47.51,80.55,38.71,"NYSE"]
[80,"Starbucks Corporation","SBUX",16.350000000000001,23.68,27.4,38.840000000000003,39.9,"NYSE"]
[81,"JM Smucker Co","SJM",61.84,78.59,90.2,101.51,101.86,"NYSE"]
[82,"Sony","SNE",35.880000000000003,17.440000000000001,11.09,15.75,22.6,"NYSE"]
[83,"Solar Winds","SWI",20.27,27.53,54.81,38.11,49.54,"NYSE"]
[84,"AT&T","T",27.92,30.51,33.44,34.799999999999997,33.369999999999997,"NYSE"]
[85,"Target","TGT",54.35,50.17,61.54,60.24,74.94,"NYSE"]
[86,"Toyota","TM",82.46,71.400000000000006,96.1,119.19,128.88,"NYSE"]
[87,"Tesoro","TSO",19.350000000000001,22.95,42.17,52.58,75.5,"NYSE"]
[88,"Time Warner Cable Inc.","TWC",65.61,69.05,100.54,133.36000000000001,146.76,"NYSE"]
[89,"Tyler Technologies","TYL",20.36,31.81,50.01,105.45,107.85,"NYSE"]
[90,"Under Armour Inc.","UA",13.31,19.29,24.04,41,69.819999999999993,"NYSE"]
[91,"UnitedHealth Group","UNH",40.409999999999997,52.27,52.09,74.7,100.78,"NYSE"]
[92,"United Parcel Service","UPS",72.48,73.48,76.569999999999993,96.33,98.87,"NYSE"]
[93,"Visa Inc.","V",17.54,25.18,39.19,58.04,63.74,"NYSE"]
[94,"Viacom","VIAB",40.520000000000003,46.89,59.02,85.4,64.42,"NYSE"]
[95,"Verizon","VZ",35.93,38.33,42.54,48.42,47.99,"NYSE"]
[96,"Walmart","WMT",56.7,61.01,69,78.650000000000006,89.35,"NYSE"]
[97,"Watsco Inc.","WSO",61.83,67.61,76.150000000000006,96.62,110.74,"NYSE"]
[98,"Exxon Mobil Corporation","XOM",75.59,87.49,91.73,99.16,90.89,"NYSE"]
[99,"Yahoo","YHOO",16.809999999999999,15.52,19.29,41.23,46.47,"NASDAQ"]
[100,"YUM! Brands","YUM",46.4,61.23,65.150000000000006,72.099999999999994,72.430000000000007,"NYSE"]