{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Market Values","webQuery1","webQuery2","webQuery3","webQuery4","webQuery5","Historical Values","Email List","Dow","S&P 500","NASDAQ","Gold","Oil","3-Month US Treasury","6-Month US Treasury","12-Month US Treasury","2-Year US Treasury","3-Year US Treasury","5-Year US Treasury","7-Year US Treasury","10-Year US Treasury","30-Year US Treasury","Yield Curve"],"not_rendered":{"charts":30,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Dow","index":8,"reason":"not_a_worksheet"},{"sheet":"S&P 500","index":9,"reason":"not_a_worksheet"},{"sheet":"NASDAQ","index":10,"reason":"not_a_worksheet"},{"sheet":"Gold","index":11,"reason":"not_a_worksheet"},{"sheet":"Oil","index":12,"reason":"not_a_worksheet"},{"sheet":"3-Month US Treasury","index":13,"reason":"not_a_worksheet"},{"sheet":"6-Month US Treasury","index":14,"reason":"not_a_worksheet"},{"sheet":"12-Month US Treasury","index":15,"reason":"not_a_worksheet"},{"sheet":"2-Year US Treasury","index":16,"reason":"not_a_worksheet"},{"sheet":"3-Year US Treasury","index":17,"reason":"not_a_worksheet"},{"sheet":"5-Year US Treasury","index":18,"reason":"not_a_worksheet"},{"sheet":"7-Year US Treasury","index":19,"reason":"not_a_worksheet"},{"sheet":"10-Year US Treasury","index":20,"reason":"not_a_worksheet"},{"sheet":"30-Year US Treasury","index":21,"reason":"not_a_worksheet"},{"sheet":"Yield Curve","index":22,"reason":"not_a_worksheet"}],"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":"Market Values","index":0,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Market Values"]
[null,"Jason Merrill"]
[null,null,"Value","Web Query #"]
[null,"Dow",10997.35,1]
[null,"S&P 500",1194.3699999999999,1,null,"Number of Users:",{"$f":"COUNTA('Email List'!A:A)-1","v":2}]
[null,"NASDAQ",2454.0500000000002,1]
[null,"Gold",1161.9000000000001,5]
[null,"Oil",84.92,2]
[null,"Fed Funds Rate",0.2,3]
[null,"Fed Reserve Target Rate",0.25,3]
[null,"US Unemployment Rate",9.6999999999999993,3]
[null,"1-Month LIBOR",0.25,3]
[null,"3-Month LIBOR",0.3,3]
[null,"3-Month US Treasury",0.15000000596046448,4]
[null,"6-Month US Treasury",0.23000000417232513,4]
[null,"12-Month US Treasury",0.43999999761581421,4]
[null,"2-Year US Treasury",1.059999942779541,4]
[null,"3-Year US Treasury",1.690000057220459,4]
[null,"5-Year US Treasury",2.619999885559082,4]
[null,"7-Year US Treasury",3.3399999141693115,4]
[null,"10-Year US Treasury",3.880000114440918,4]
[null,"30-Year US Treasury",4.7399997711181641,4]

{"sheet":"webQuery1","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["INDEX","VALUE","CHANGE","%CHANGE","TIME"]
["DOW JONES INDUS. AVG",10997.35,70.28,6.4000000000000003E-3,"2010-04-09"]
["S&P 500 INDEX",1194.3699999999999,7.93,6.7000000000000002E-3,"2010-04-09"]
["NASDAQ COMPOSITE INDEX",2454.0500000000002,17.239999999999998,7.1000000000000004E-3,"2010-04-09"]
["S&P/TSX COMPOSITE INDEX",12176.84,63.31,5.1999999999999998E-3,"2010-04-09"]
["MEXICO BOLSA INDEX",33840.85,273.5,8.0999999999999996E-3,"2010-04-09"]
["BRAZIL BOVESPA INDEX",71417.27,-367.51,-5.1000000000000004E-3,"2010-04-09"]

{"sheet":"webQuery2","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"PRICE","CHANGE","%CHANGE","TIME"]
["  BRENT CRUDE FUTR (USD/bbl.)",84.83,0.02,0.02,"2010-04-09"]
["  GAS OIL FUT (ICE) (USD/MT)",707.5,0.5,7.0000000000000007E-2,"2010-04-09"]
["  GASOLINE RBOB FUT (USd/gal.)",228.93,-0.9,-0.39,"2010-04-09"]
["  HEATING OIL FUTR (USd/gal.)",222.6,-0.22,-0.1,"2010-04-09"]
["  NATURAL GAS FUTR (USD/MMBtu)",4.07,0,0,"17:25:00"]
["  WTI CRUDE FUTURE (USD/bbl.)",84.92,-0.47,-0.55000000000000004,"2010-04-09"]

{"sheet":"webQuery3","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"CURRENT","1 MONTH","3 MONTH","6 MONTH","1 YEAR"]
[null,null,"PRIOR","PRIOR","PRIOR","PRIOR"]
["Fed Funds Rate",0.2,0.15,0.11,0.13,0.15]
["Fed Reserve",0.25,0.25,0.25,0.25,0.25]
["Target Rate"]
["Prime Rate",3.25,3.25,3.25,3.25,3.25]
["US Unemployment",9.6999999999999993,9.6999999999999993,10,9.8000000000000007,8.6]
["Rate"]
["1-Month Libor",0.25,0.23,0.23,0.24,0.45]
["3-Month Libor",0.3,0.26,0.25,0.28000000000000003,1.1299999999999999]

{"sheet":"webQuery4","index":4,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"COUPON","MATURITY","CURRENT","PRICE/YIELD","TIME"]
[null,null,"DATE","PRICE/YIELD","CHANGE"]
["3-Month",0,"2010-07-08","0.14 / .15",{"$f":"-0.008 / -0.008","v":1},"2010-04-09"]
["6-Month",0,"2010-10-07","0.22 / .23",{"$f":"-0.003 / -0.003","v":1},"2010-04-09"]
["12-Month",0,"2011-04-07","0.43 / .44",{"$f":"-0.006 / -0.006","v":1},"2010-04-09"]
["2-Year",1,"2012-03-31","99-28½ / 1.06","0-00+ / -.008","2010-04-09"]
["3-Year",1.75,"2013-04-15","100-06 / 1.69","0-00 / .000","2010-04-09"]
["5-Year",2.5,"2015-03-31","99-13½ / 2.62","0-01½ / -.010","2010-04-09"]
["7-Year",3.25,"2017-03-31","99-15 / 3.34","0-02+ / -.013","2010-04-09"]
["10-Year",3.625,"2020-02-15","97-28+ / 3.88","0-02 / -.008","2010-04-09"]
["30-Year",4.625,"2040-02-15","98-05½ / 4.74","0-06+ / -.013","2010-04-09"]
[]
["Inflation Indexed Treasury"]
[null,"COUPON","MATURITY","CURRENT","PRICE/YIELD","TIME"]
[null,null,"DATE","PRICE/YIELD","CHANGE"]
["5-Year",1.25,"2014-04-15","103-18 / .35","0-00 / -.009","2010-04-09"]
["10-Year",1.375,"2020-01-15","98-15 / 1.54","0-00 / -.000","2010-04-09"]
["20-Year",2.5,"2029-01-15","106-19 / 2.07",{"$f":"0-1 / 0.003","v":-333.33333333333331},"2010-04-09"]
["30-Year",2.125,"2040-02-15","100-27 / 2.09","0-09 / -.014","2010-04-09"]

{"sheet":"webQuery5","index":5,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"PRICE","CHANGE","%CHANGE","TIME"]
["  GOLD 100 OZ FUTR (USD/t oz.)",1161.9000000000001,9,0.78,"2010-04-09"]
["  SILVER FUTURE (USD/t oz.)",18.350999999999999,0.224,1.24,"2010-04-09"]

{"sheet":"Historical Values","index":6,"n_rows":10,"n_cols":20,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"Treasury Maturities [in years]"]
[null,null,null,null,null,null,null,null,null,null,null,0.25,0.5,1,2,3,5,7,10,30]
["Date Stamp","Dow","S&P 500","NASDAQ","Gold","Oil","Fed Funds Rate","Fed Reserve Target Rate","US Unemployment Rate","1-Month LIBOR","3-Month LIBOR","3-Month US Treasury","6-Month US Treasury","12-Month US Treasury","2-Year US Treasury","3-Year US Treasury","5-Year US Treasury","7-Year US Treasury","10-Year US Treasury","30-Year US Treasury"]
["2010-04-10T14:57:38",10997.35,1194.3699999999999,2454.0500000000002,1161.9000000000001,84.92,0.2,0.25,9.6999999999999993,0.25,0.3,0.15000000596046448,0.23000000417232513,0.43999999761581421,1.059999942779541,1.690000057220459,2.619999885559082,3.3399999141693115,3.880000114440918,4.7399997711181641]
["2010-04-10T13:17:56",10997.35,1194.3699999999999,2454.0500000000002,1161.9000000000001,84.92,0.2,0.25,9.6999999999999993,0.25,0.3,0.15000000596046448,0.23000000417232513,0.43999999761581421,1.059999942779541,1.690000057220459,2.619999885559082,3.3399999141693115,3.880000114440918,4.7399997711181641]
["2010-04-09T09:59:08",10976.95,1191.0999999999999,2443.9299999999998,1163.4000000000001,84.85,0.2,0.25,9.6999999999999993,0.25,0.3,0.15,0.23,0.45,1.08,1.71,2.66,3.36,3.91,4.76]
["2010-04-08T09:36:14",10870.69,1179.44,2423.1,1151.5999999999999,85.05,0.2,0.25,9.6999999999999993,0.25,0.28999999999999998,0.16,0.23,0.44,1.03,1.65,2.59,3.3,3.85,4.74]
["2010-04-07T10:45:00",10929.33,1185.78,2435.13,1151.0999999999999,86.46,0.21,0.25,9.6999999999999993,0.25,0.3,0.15999999642372131,0.23999999463558197,0.46,1.1000000000000001,1.72,2.67,3.38,3.93,4.8]
["2010-04-06T08:57:00",10948.08,1185.93,2424.36,1137.2,86.87,0.2,0.25,9.6999999999999993,0.25,0.28999999999999998,0.17,0.25,0.43,1.1399999999999999,1.7,2.7,3.4,3.95,4.82]
["2010-04-02T13:35:00",10927.07,1178.0999999999999,2402.58,1126.0999999999999,84.87,0.2,0.25,9.6999999999999993,0.25,0.28999999999999998,0.15999999642372131,0.23999999463558197,0.42,1.1000000000000001,1.66,2.66,3.39,3.94,4.8]

{"sheet":"Email List","index":7,"n_rows":3,"n_cols":36,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Email Address","Dow","S&P 500","NASDAQ","Gold","Oil","Fed Funds Rate","Fed Reserve Target Rate","US Unemployment Rate","1-Month LIBOR","3-Month LIBOR","3-Month US Treasury","6-Month US Treasury","12-Month US Treasury","2-Year US Treasury","3-Year US Treasury","5-Year US Treasury","7-Year US Treasury","10-Year US Treasury","30-Year US Treasury","Dow Graph","S&P 500 Graph","NASDAQ Graph","Gold Graph","Oil Graph","3-Month US Treasury Graph","6-Month US Treasury Graph","12-Month US Treasury Graph","2-Year US Treasury Graph","3-Year US Treasury Graph","5-Year US Treasury Graph","7-Year US Treasury Graph","10-Year US Treasury Graph","30-Year US Treasury Graph","Yield Curve Graph","Frequency"]
["jason.s.merrill@gmail.com",true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,"Daily"]
["jason.s.merrill.00@alum.dartmouth.org",true,false,true,false,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,false,true,false,true,true,true,true,true,true,true,true,true,true,true,"Weekly"]