{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Inputs","Returns","Correlation Matrix","Covar Matrix","Efficient Frontier"],"not_rendered":{"charts":1,"images":41,"macros":1,"external_links":0,"defined_names":107,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Inputs","index":0,"n_rows":1048576,"n_cols":9,"rows_kept":4500,"cut":true,"hidden":false,"merged":[[10,4,10,5],[11,4,11,5],[24,7,24,8],[13,1,13,2]],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0},"read":"row_number_cap"}
["Finding the Efficient Frontier"]
[]
[]
["Today's date",{"$f":"TODAY()","v":"2026-02-02"}]
["Start date  ",{"$f":"DATE(YEAR(B4)-5, MONTH(B4)-1,1)","v":"2021-01-01"}]
["End date  ",{"$f":"DATE(YEAR(B4), MONTH(B4)-1, 28)","v":"2026-01-28"}]
[]
[]
[]
[]
[null,null,null,null,"Risk-free Rate",null,0.03]
[null,null,null,null,"Market Risk Premium (Rm-Rf)",null,5.7000000000000002E-2]
[]
[null,"Ticker Symbols"]
[null,1,"SBUX"]
[null,2,"JPM"]
[null,3,"KO"]
[null,4,"GRMN"]
[null,5,"HD"]
[null,6,"LUV"]
[null,7,"LLY"]
[null,8,"XOM"]
[]
[]
[null,null,null,null,null,null,null,"Enter Value for x"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ignore everything below this point on this worksheet"]
[]
[]
[]
[]
[]
["If selected to be restricted, weights for these individual ETFs must be 0.2 or less"]
["Financial (XLF)"]
["Health (XLV)"]
["Energy (IYE)"]
["Technology (VGT)"]
["Utilities  (IDU)"]
["China (FXI)"]
["Japan (NKY)"]
["India (INP)"]
["Latin America (EWZ)"]
["Europe (EWG)"]
["Emerging Markets (VWO)"]
["Junk Bonds (HYG)"]
["Domestic Real Estate (VNQ)"]
["Global Real Estate (IFGL)"]
["Precious Metals (IAU)"]
["Natural Resources (VAW)"]
["Agricultural Commodities (RJA)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0,"Financial (XLF)",null,null,"if any of these are 1's then the weight must be less than .2"]
[0,"Health (XLV)"]
[0,"Energy (IYE)"]
[0,"Technology (VGT)"]
[0,"Utilities  (IDU)"]
[0,"China (FXI)"]
[0,"Japan (NKY)"]
[0,"India (INP)"]
[0,"Latin America (EWZ)"]
[0,"Europe (EWG)"]
[0,"Emerging Markets (VWO)"]
[0,"Junk Bonds (HYG)"]
[0,"Domestic Real Estate (VNQ)"]
[0,"Global Real Estate (IFGL)"]
[0,"Precious Metals (IAU)"]
[0,"Natural Resources (VAW)"]
[0,"Agricultural Commodities (RJA)"]
[0,"weights less than 50%..then 1"]
[0,"non-negative..then 1"]
["m"]
["^GSPC",null,null,null,null,null,null,null,"^GSPC"]

{"sheet":"Returns","index":1,"n_rows":72,"n_cols":21,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,18]]}
[null,"PRICES",null,null,null,null,null,null,null,null,"RETURNS",null,null,null,null,null,null,null,null,"Rf",{"$f":"Inputs!$G$11","v":0.03}]
["Date",{"$f":"Inputs!C15","v":"SBUX"},{"$f":"Inputs!C16","v":"JPM"},{"$f":"Inputs!C17","v":"KO"},{"$f":"Inputs!C18","v":"GRMN"},{"$f":"Inputs!C19","v":"HD"},{"$f":"Inputs!C20","v":"LUV"},{"$f":"Inputs!C21","v":"LLY"},{"$f":"Inputs!C22","v":"XOM"},"ivv",{"$f":"B2","v":"SBUX"},{"$f":"C2","v":"JPM"},{"$f":"D2","v":"KO"},"GRMN","HD","LUV","LLY","XOM",{"$f":"J2","v":"ivv"},"Rm-Rf",{"$f":"Inputs!$G$12","v":5.7000000000000002E-2}]
[{"$f":"A71","v":"2021-01-01"},{"$f":"_xlfn.STOCKHISTORY(B2,$A$71,$A$72,2,0,1)","v":96.81},{"$f":"_xlfn.STOCKHISTORY(C2,$A$71,$A$72,2,0,1)","v":128.66999999999999},{"$f":"_xlfn.STOCKHISTORY(D2,$A$71,$A$72,2,0,1)","v":48.15},{"$f":"_xlfn.STOCKHISTORY(E2,$A$71,$A$72,2,0,1)","v":114.86},{"$f":"_xlfn.STOCKHISTORY(F2,$A$71,$A$72,2,0,1)","v":270.82},{"$f":"_xlfn.STOCKHISTORY(G2,$A$71,$A$72,2,0,1)","v":43.94},{"$f":"_xlfn.STOCKHISTORY(H2,$A$71,$A$72,2,0,1)","v":207.97},{"$f":"_xlfn.STOCKHISTORY(I2,$A$71,$A$72,2,0,1)","v":44.84},{"$f":"_xlfn.STOCKHISTORY(J2,$A$71,$A$72,2,0,1)","v":371.52},"_1","_2","_3","_4","_5","_6","_7","_8"]
[{"$f":"EDATE(A3,1)","v":"2021-02-01"},108.03,147.16999999999999,48.99,124.02,258.33999999999997,58.13,204.89,54.37,381.77,{"$f":"LN(B4/B3)","v":0.10965867159691348},{"$f":"LN(C4/C3)","v":0.13433739397912264},{"$f":"LN(D4/D3)","v":1.7295057406349006E-2},{"$f":"LN(E4/E3)","v":7.6728847485581494E-2},{"$f":"LN(F4/F3)","v":-4.7177846750808564E-2},{"$f":"LN(G4/G3)","v":0.27985681475679508},{"$f":"LN(H4/H3)","v":-1.4920588770721907E-2},{"$f":"LN(I4/I3)","v":0.19271193295387007},{"$f":"LN(J4/J3)","v":2.7215634524684042E-2}]
[{"$f":"EDATE(A4,1)","v":"2021-03-01"},109.27,152.22999999999999,52.71,131.85,305.25,61.06,186.82,55.83,397.82,{"$f":"LN(B5/B4)","v":1.1412917253760473E-2},3.3804153895141256E-2,7.3188995216631997E-2,6.1222069877563748E-2,0.16685456618694477,4.9175105593472539E-2,-9.2327663314405048E-2,2.6498828164439877E-2,4.1181308642704105E-2]
["2021-04-01",114.49,153.81,53.98,137.24,323.67,62.78,182.77,57.24,418.88,4.6665599353067008E-2,1.0325539392556239E-2,2.3808416722742969E-2,4.0066305190953361E-2,5.8593365240544482E-2,2.7779564107075671E-2,-2.1917054678351783E-2,2.4941595365981208E-2,5.1584841044620355E-2]
["2021-05-01",113.88,164.24,55.29,142.24,318.91000000000003,61.46,199.74,58.37,421.65,-5.3422205258841947E-3,6.5610698246959365E-2,2.3978452759983133E-2,3.5784553775345569E-2,-1.4815546914580284E-2,-2.1249994711468868E-2,8.87879890486378E-2,1.9549104527449394E-2,6.5911032991153549E-3]
["2021-06-01",111.81,155.54,54.11,144.63999999999999,318.89,53.09,229.52,63.08,429.92,-1.8344260250560015E-2,-5.4425839443881033E-2,-2.1573048695197754E-2,1.6732124878271859E-2,-6.271558484355691E-5,-0.14639797010675842,0.13897365085812077,7.7601702879137993E-2,1.9423558846530537E-2]
["2021-07-01",121.43,151.78,57.03,157.19999999999999,328.19,50.52,243.5,57.57,440.4,8.2536962906450809E-2,-2.4470829291030432E-2,5.2558433513803543E-2,8.3270983351239794E-2,2.8746493233777894E-2,-4.9619289113289715E-2,5.9126770849535062E-2,-9.1402163407119374E-2,2.4084259981343677E-2]
["2021-08-01",117.49,159.94999999999999,56.31,174.43,326.18,49.78,258.29000000000002,54.52,453.71,-3.2984741486246458E-2,5.2429162419760131E-2,-1.2705305901920315E-2,0.10400463503493731,-6.1433327369408266E-3,-1.4756000542844426E-2,5.8966042156857169E-2,-5.4433991859386376E-2,2.9774822574747176E-2]
["2021-09-01",110.31,163.69,52.47,155.46,328.26,51.43,231.05,58.82,430.82,-6.3058639598190872E-2,2.3113128760736273E-2,-7.0630561567906772E-2,-0.11513505122796978,6.3566010750178434E-3,3.2608362847378836E-2,-0.11144884736322619,7.5914326297517126E-2,-5.1767857963318488E-2]
["2021-10-01",106.07,169.89,56.37,143.6,371.74,47.28,254.76,64.47,460.99,-3.9195330463911535E-2,3.7176773637560064E-2,7.1695524394863208E-2,-7.9356807187949907E-2,0.12438870787641736,-8.4134286688981999E-2,9.7687788186889488E-2,9.1718066196679854E-2,6.7685981327451156E-2]
["2021-11-01",109.64,158.83000000000001,52.45,133.54,400.61,44.4,248.04,59.84,457.63,3.3103017917206282E-2,-6.7316720946759473E-2,-7.207676725117737E-2,-7.2630598184401041E-2,7.4793700296117399E-2,-6.2847903659663765E-2,-2.6731902021487786E-2,-7.4525665656306861E-2,-7.3153534301832112E-3]
["2021-12-01",116.97,158.35,59.21,136.16999999999999,415.01,42.84,276.22000000000003,61.19,476.99,6.4715220228030626E-2,-3.0266748624149945E-3,0.12123011170137855,1.9503046706761201E-2,3.5314230849602953E-2,-3.576722385863091E-2,0.10760762616810557,2.2309443808227265E-2,4.1434528950777552E-2]
["2022-01-01",98.32,148.6,61.01,124.42,366.98,44.76,245.39,75.959999999999994,451.77,-0.17369002640483627,-6.3549640700989993E-2,2.9947338620076321E-2,-9.0241166049610064E-2,-0.12299526566911968,4.3842637864176311E-2,-0.11834886799951823,0.21622310846963599,-5.4322325541161204E-2]
["2022-02-01",91.79,141.80000000000001,62.24,110.44,315.83,43.8,249.95,78.42,438.72,-6.8724106026779669E-2,-4.6840518185631536E-2,1.9960094706375133E-2,-0.11919055202492002,-0.15010325651374051,-2.1681066061324052E-2,1.8412116209314818E-2,3.1872110920100651E-2,-2.9311804392888084E-2]
["2022-03-01",90.97,136.32,62,118.61,299.33,45.8,286.37,82.59,453.69,-8.9735773970291907E-3,-3.9412551017021596E-2,-3.8634948250445898E-3,7.1368412979230661E-2,-5.3657450428442402E-2,4.465027373773893E-2,0.13602378313704125,5.1809610958440028E-2,3.35527490568093E-2]
["2022-04-01",74.64,119.36,64.61,109.74,300.39999999999998,46.72,292.13,85.25,413.56,-0.19785322529488214,-0.13286092662555476,4.1234812524982449E-2,-7.7726868410355171E-2,3.568276175354968E-3,1.9888247399832366E-2,1.9914227676558371E-2,3.1699508341000542E-2,-9.2611538712266517E-2]
["2022-05-01",78.5,132.22999999999999,63.38,105.62,302.75,45.86,313.44,96,414.87,5.0422068249274414E-2,0.10239869411328063,-1.9220843307299309E-2,-3.8266184352042133E-2,7.7924625432220515E-3,-1.8579061090213268E-2,7.0409045523051772E-2,0.11876007530421016,3.162611426184429E-3]
["2022-06-01",76.39,112.61,62.91,98.25,274.27,36.119999999999997,324.23,85.64,379.15,-2.7246827235094365E-2,-0.16061230885979724,-7.4432206808365004E-3,-7.2332496529416548E-2,-9.8794359774584617E-2,-0.23874654888097371,3.384518629613345E-2,-0.11419572774635418,-9.0033312997732234E-2]
["2022-07-01",84.78,115.36,64.17,97.62,300.94,38.119999999999997,329.69,96.93,414.28,0.10420786837122281,2.4127151827704821E-2,1.9830678180485714E-2,-6.4328602903691422E-3,9.2797886672114957E-2,5.3892350237216759E-2,1.6699678521760183E-2,0.12383660478303464,8.8610168573733578E-2]
["2022-08-01",84.07,113.73,61.71,88.49,288.42,36.700000000000003,301.23,95.59,397.18,-8.4098807772856558E-3,-1.4230455340285749E-2,-3.908981942944844E-2,-9.819283917974278E-2,-4.2493158196807664E-2,-3.7962323725476678E-2,-9.0278726454669625E-2,-1.3920856428845399E-2,-4.2152495284659391E-2]
["2022-09-01",84.26,104.5,56.02,80.31,275.94,30.84,323.35000000000002,87.31,358.65,2.2574714036651829E-3,-8.4640146791487542E-2,-9.6737222501012993E-2,-9.6995405078887903E-2,-4.4234300354036922E-2,-0.17396420636539589,7.0861235333147213E-2,-9.0603208252954939E-2,-0.10204259586357527]
["2022-10-01",86.59,125.88,59.85,88.04,296.13,36.35,362.09,110.81,387.79,2.7277078908839323E-2,0.18614200079134038,6.6132662172019629E-2,9.1897110457890036E-2,7.0615096318018822E-2,0.16438165528439966,0.11315747181717094,0.23835201912551779,7.811697341575051E-2]
["2022-11-01",102.2,138.18,63.61,92.99,323.99,39.909999999999997,371.08,111.34,409.32,0.16574734230989416,9.3228110864442743E-2,6.0929258686730665E-2,5.4700703831844902E-2,8.9914104020583127E-2,9.3432715081114087E-2,2.4524873075297809E-2,4.7715598071276961E-3,5.4033290230360631E-2]
["2022-12-01",99.2,134.1,63.61,92.29,315.86,33.67,365.84,110.3,384.21,-2.9793663478777006E-2,-2.9971392773016043E-2,0,-7.5561672126204333E-3,-2.5413573676580817E-2,-0.17001968588765923,-1.4221593435271076E-2,-9.3846564959050322E-3,-6.3307968112464655E-2]
["2023-01-01",109.14,139.96,61.32,98.88,324.17,35.770000000000003,344.15,116.01,408.31,9.5493447467258685E-2,4.277087721185463E-2,-3.6664636687099482E-2,6.8971200431895169E-2,2.5968992106065344E-2,6.050232009794336E-2,-6.1118470505426549E-2,5.047246802785877E-2,6.0837411714769481E-2]
["2023-02-01",102.09,143.35,59.51,98.13,296.54000000000002,33.58,311.22000000000003,109.91,397.97,-6.6776684577161766E-2,2.3932524829891395E-2,-2.9961688346852693E-2,-7.6138634909783901E-3,-8.908595295809385E-2,-6.3178901621531794E-2,-0.10057755125300921,-5.401454520650651E-2,-2.5650064261823993E-2]
["2023-03-01",104.13,130.31,62.03,100.92,295.12,32.54,343.42,109.66,411.08,1.9785341360880511E-2,-9.5372965172564189E-2,4.1473773328265615E-2,2.8034993554454733E-2,-4.8000633014599154E-3,-3.1460549858502947E-2,9.8454130294292605E-2,-2.2771791049065815E-3,3.2411217197836843E-2]
["2023-04-01",114.29,138.24,64.150000000000006,98.17,300.54000000000002,30.29,395.86,118.34,417.66,9.3098959367702044E-2,5.9075077898930899E-2,3.3605952076619323E-2,-2.7627454068426937E-2,1.8198803309160256E-2,-7.1652476751745756E-2,0.14210642550693256,7.6177167272645688E-2,1.5879861651757834E-2]
["2023-05-01",97.64,135.71,59.66,103.15,283.45,29.87,429.46,102.18,419.43,-0.15745183238474725,-1.8471048962466177E-2,-7.256231197504312E-2,4.9483569812830766E-2,-5.8545115827267874E-2,-1.3962992811127494E-2,8.146799214639712E-2,-0.14682587334589603,4.2289422592128138E-3]
["2023-06-01",99.06,145.44,60.22,104.29,310.64,36.21,468.98,107.25,445.71,1.4438481635332429E-2,6.9243374335889354E-2,9.3427439669854038E-3,1.0991240615860714E-2,9.1598944653099257E-2,0.19248069154953143,8.803151807477444E-2,4.8426593905474463E-2,6.0771869649528194E-2]
["2023-07-01",101.57,157.96,61.93,105.89,333.84,34.159999999999997,454.55,107.24,460.18,2.5022488791318104E-2,8.2578205989279937E-2,2.8000191896381737E-2,1.522533930924156E-2,7.2027150859885203E-2,-5.8279954857180863E-2,-3.1252205045893308E-2,-9.3244440367901328E-5,3.1949200974015553E-2]
["2023-08-01",97.44,146.33000000000001,59.83,106.02,330.3,31.6,554.20000000000005,111.19,452.69,-4.1511411989822791E-2,-7.6477491314113563E-2,-3.4497507548029098E-2,1.2269361172968524E-3,-1.0660503886553025E-2,-7.7898248327502528E-2,0.19821771386101078,3.6171136347399289E-2,-1.641015277757191E-2]
["2023-09-01",91.27,145.02000000000001,55.98,105.2,302.16000000000003,27.07,537.13,117.58,429.43,-6.5414657432801018E-2,-8.9926811608884646E-3,-6.6512723314632982E-2,-7.7644552560505063E-3,-8.9044653992542466E-2,-0.15473101696665659,-3.1285481556938645E-2,5.5878503258951009E-2,-5.2748816581768214E-2]
["2023-10-01",92.24,139.06,56.49,102.53,284.69,22.23,553.92999999999995,105.85,419.94,1.0571729432017668E-2,-4.1966169272574932E-2,9.0691472498633692E-3,-2.570786162160961E-2,-5.9555809429755024E-2,-0.19698337565010457,3.0798174101417886E-2,-0.10509595539323481,-2.2346904002543255E-2]
["2023-11-01",99.3,156.08000000000001,58.44,122.24,313.49,25.57,591.04,102.74,458.42,7.3751695090323269E-2,0.11546320164398398,3.3936955545327878E-2,0.17583088673621036,9.6366592663144596E-2,0.13997706132699012,6.484537203751771E-2,-2.9821472541752349E-2,8.7673950536716935E-2]
["2023-12-01",96.01,170.1,58.93,128.54,346.55,28.88,582.91999999999996,99.98,477.63,-3.3693218341594389E-2,8.6017803086960151E-2,8.3497119673233075E-3,5.0253814524929663E-2,0.10025964672640268,0.12172952472153016,-1.383374134537927E-2,-2.7231359053697352E-2,4.1050579709802706E-2]
["2024-01-01",93.03,174.36,59.49,119.49,352.96,29.89,645.61,102.81,485.2,-3.1530330929065174E-2,2.4735627968375778E-2,9.4579323499923516E-3,-7.300745408147756E-2,1.8327627701143948E-2,3.4374662271221088E-2,0.10214565063744499,2.7912458569202735E-2,1.5724802893872111E-2]
["2024-02-01",94.9,186.06,60.02,137.35,380.61,34.270000000000003,753.68,104.52,510.45,1.9901683835414963E-2,6.4947074970220633E-2,8.8696088124067679E-3,0.13929972667962037,7.5420492755479046E-2,0.13674635959067111,0.15477226843747136,1.6495816097784593E-2,5.0731512545129288E-2]
["2024-03-01",91.39,200.3,61.18,148.87,383.6,29.19,777.96,116.24,525.73,-3.7687642331771923E-2,7.3747040331360078E-2,1.9142498710536242E-2,8.0541029347682994E-2,7.8251141886665175E-3,-0.1604441510204942,3.1707234234492322E-2,0.1062785786096158,2.949508335025066E-2]
["2024-04-01",88.49,191.74,61.77,144.47,334.22,25.94,781.1,118.27,504.44,-3.2246512004851548E-2,-4.3675955022922035E-2,9.5974709850504304E-3,-3.0001568347675936E-2,-0.13780088423404657,-0.1180400059777256,4.0280736413470753E-3,1.7313127000998078E-2,-4.1338869877601256E-2]
["2024-05-01",80.22,202.63,62.93,163.85,334.87,26.84,820.34,117.26,529.96,-9.8116690937351966E-2,5.5241368228387204E-2,1.8605187831034486E-2,0.12587950160353362,1.9429380336863141E-3,3.4107133215183161E-2,4.9015705851405189E-2,-8.5764547269564298E-3,4.9352628912248675E-2]
["2024-06-01",77.849999999999994,202.26,63.65,162.91999999999999,344.24,28.61,905.38,115.12,547.23,-2.9988962061899511E-2,-1.8276574032134445E-3,1.1376327464573373E-2,-5.6920923646118417E-3,2.759669172142136E-2,6.3862994958537783E-2,9.8635856606103287E-2,-1.8418628956956618E-2,3.2067657367010456E-2]
["2024-07-01",77.95,212.8,66.739999999999995,171.25,368.16,26.94,804.27,118.59,553.32000000000005,1.2836972237783492E-3,5.079875899346499E-2,4.7405148319812282E-2,4.986519436212293E-2,6.7178537756711523E-2,-6.0144136079800875E-2,-0.11841971137448726,2.9697103397591355E-2,1.1067306639681753E-2]
["2024-08-01",94.57,224.8,72.47,183.29,368.5,28.92,960.02,117.94,566.75,0.1932727055236351,5.4858360552046764E-2,8.236820979796218E-2,6.7945120841421694E-2,9.2308534233555837E-4,7.0921226308346033E-2,0.17701908387893153,-5.4961454043457696E-3,2.3981793381023853E-2]
["2024-09-01",97.49,210.86,71.86,176.03,405.2,29.63,885.94,117.22,576.82000000000005,3.0409507613759296E-2,-6.4016711870732407E-2,-8.4529014358173393E-3,-4.0415162925875582E-2,9.4940060745136987E-2,2.4253964294909849E-2,-8.0304889356525633E-2,-6.123509524074853E-3,1.7611970045769861E-2]
["2024-10-01",97.7,221.92,65.31,198.35,393.75,30.58,829.74,116.78,571.24,2.1517504075570437E-3,5.1122550417717641E-2,-9.557461777080685E-2,0.11937871190245816,-2.8664582234685453E-2,3.1558838915442353E-2,-6.5536829517056666E-2,-3.7606881928916517E-3,-9.7208228486758055E-3]
["2024-11-01",102.46,249.72,64.08,212.6,429.13,32.36,795.35,117.96,605.07000000000005,4.7570919462319131E-2,0.11802333362702197,-1.9012861154462081E-2,6.9379318947508498E-2,8.6043713186795601E-2,5.6576891689374659E-2,-4.2330129360252503E-2,1.0053761091683825E-2,5.7534717232432281E-2]
["2024-12-01",91.25,239.71,62.26,206.26,388.99,33.619999999999997,772,107.57,588.67999999999995,-0.11586948604845526,-4.0910430808224575E-2,-2.8813137746641685E-2,-3.0274957019924637E-2,-9.8206266979495166E-2,3.8198035790178463E-2,-2.9797719319593317E-2,-9.220378550316144E-2,-2.7461411521252803E-2]
["2025-01-01",107.68,267.3,63.48,215.85,411.98,30.71,811.08,106.83,604.66,0.16556087343381679,0.10894176375955462,1.9405730644746252E-2,4.5446213113563526E-2,5.7421168134779842E-2,-9.0532793527738423E-2,4.9382142875486923E-2,-6.9030124861179489E-3,2.6783574291956321E-2]
["2025-02-01",115.81,264.64999999999998,71.209999999999994,228.93,396.6,31.06,920.63,111.33,597.04,7.278705129986858E-2,-9.9634248408768788E-3,0.11490836233582499,5.8832557968165014E-2,-3.8046588396227342E-2,1.1332483267809919E-2,0.12669152539489079,4.1259977782819875E-2,-1.2682203764736336E-2]
["2025-03-01",98.09,245.3,71.62,217.13,366.49,33.58,825.91,118.93,561.9,-0.16606549262006204,-7.5926247039552752E-2,5.7411065762533421E-3,-5.2920027463970981E-2,-7.895698026083979E-2,7.8009833928853814E-2,-0.10857240954839363,6.603632099853822E-2,-6.0660214704979398E-2]
["2025-04-01",80.05,244.62,72.55,186.87,360.49,27.96,898.95,105.63,557.96,-0.20323398513350069,-2.7759652052265827E-3,1.2901614759910111E-2,-0.15008306457151666,-1.6507018735632494E-2,-0.18315573428378515,8.4741606825543714E-2,-0.11859266290408328,-7.036622894117917E-3]
["2025-05-01",83.95,264,72.099999999999994,202.97,368.29,33.380000000000003,737.67,102.3,592.15,4.7569944080826244E-2,7.6243117087099188E-2,-6.2219350392935489E-3,8.2644996935371279E-2,2.1406454214738559E-2,0.17718200086807959,-0.1977308454467494,-3.2032748877489997E-2,5.9472705943469525E-2]
["2025-06-01",91.63,289.91000000000003,70.75,208.72,366.64,32.44,779.53,107.8,620.9,8.7537345453572002E-2,9.3621426839695515E-2,-1.8901507767556263E-2,2.7935455958937754E-2,-4.490231103093394E-3,-2.8564688986476943E-2,5.5194603840809882E-2,5.2367985517315939E-2,4.7410057203343008E-2]
["2025-07-01",89.16,296.24,67.89,218.76,367.51,30.93,740.07,111.64,634.9,-2.732622045945372E-2,2.159940661934542E-2,-4.126378820979125E-2,4.6981597650098877E-2,2.3700889661671075E-3,-4.7665642550233804E-2,-5.194639764734086E-2,3.5001750193224684E-2,2.2297467805557206E-2]
["2025-08-01",88.19,301.42,68.989999999999995,241.82,406.77,32.9,732.58,114.29,648.32000000000005,-1.0938930617578675E-2,1.733470438617303E-2,1.6072818244461537E-2,0.1002184092675287,0.10149738597529173,6.1746071074348007E-2,-1.017222637426211E-2,2.3459669241385282E-2,2.0916895443859846E-2]
["2025-09-01",84.6,315.43,66.319999999999993,246.22,405.19,31.91,763,112.75,669.3,-4.1559311287911897E-2,4.5432146325393788E-2,-3.9470055730977768E-2,1.8031797473368361E-2,-3.8918222431147966E-3,-3.0553217481174004E-2,4.0685481339695483E-2,-1.3566099526718903E-2,3.1847988486332454E-2]
["2025-10-01",80.87,311.12,68.900000000000006,213.94,379.59,30.3,862.86,114.36,685.23,-4.509133950444668E-2,-1.3758097469432195E-2,3.816466719257345E-2,-0.14052984334148413,-6.5264370029930796E-2,-5.1771727774828649E-2,0.12299442184188637,1.4178389071323218E-2,2.3522158222055816E-2]
["2025-11-01",87.11,313.08,73.12,195.32,356.92,34.81,1075.47,115.92,686.88,7.4328760723069737E-2,6.2800590891455479E-3,5.9445749126281734E-2,-9.1056362684525313E-2,-6.1580055837331248E-2,0.13875698930802413,0.22026060118960719,1.3548930558315872E-2,2.4050561475982895E-3]
["2025-12-01",84.21,322.22000000000003,69.91,202.85,344.1,41.33,1074.68,120.34,684.94,-3.3858008788899857E-2,2.8775793126203295E-2,-4.4893226622000841E-2,3.7827550458996703E-2,-3.6579354228515923E-2,0.17168392670029342,-7.3483248661588023E-4,3.7420771779778851E-2,-2.8283612912377641E-3]
["2026-01-01",91.95,305.89,74.81,201.64,374.59,47.52,1037.1500000000001,141.4,695.03,{"$f":"LN(B63/B62)","v":8.7931272008429304E-2},{"$f":"LN(C63/C62)","v":-5.2008981862032878E-2},6.7742865360419763E-2,-5.9828604380261999E-3,8.4899781708747443E-2,0.13956204653074855,-3.554637603718009E-2,0.16127168367026665,1.4623766915803409E-2]
[]
["Monthly Standard Deviation",null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.STDEV.S(K4:K63)","v":8.3426589495354433E-2},{"$f":"_xlfn.STDEV.S(L4:L63)","v":6.8294887948979935E-2},4.653032646224009E-2,7.3857686687707355E-2,6.9432489053803878E-2,0.10705109649439098,8.8397706005736001E-2,7.6168229893578646E-2,4.4081368470407105E-2]
["Annualized Standard Deviation",null,null,null,null,null,null,null,null,null,{"$f":"K65*SQRT(12)","v":0.28899818341629169},{"$f":"L65*SQRT(12)","v":0.23658043164971335},0.16118577905073289,0.25585053174522526,0.24052119747431647,0.37083587626848741,0.30621863614894246,0.26385448819652957,0.15270233971581973]
["Correlation with S&P",null,null,null,null,null,null,null,null,null,{"$f":"CORREL(K4:K63,$S$4:$S$63)","v":0.5090780283993569},{"$f":"CORREL(L4:L63,$S$4:$S$63)","v":0.68248432547965443},0.35074535386048855,0.58927177221832228,0.66726073049359991,0.47126576886323529,0.19079343178930416,0.21863030580361589,1]
["Beta",null,null,null,null,null,null,null,null,null,{"$f":"K67*(K66/$S$66)","v":0.96346019123451454},{"$f":"L67*(L66/$S$66)","v":1.0573671406516951},0.37023115176650351,0.98731621627464783,1.0510012500435921,1.1444635011943776,0.38260385909885514,0.37777147062329902,1]
["Expected Return from CAPM",null,null,null,null,null,null,null,null,null,{"$f":"$U$1+K68*$U$2","v":8.4917230900367333E-2},{"$f":"$U$1+L68*$U$2","v":9.0269927017146617E-2},5.1103175650690696E-2,8.6277024327654925E-2,8.990707125248476E-2,9.5234419568079529E-2,5.1808419968634743E-2,5.1532973825528045E-2,{"$f":"$U$1+S68*$U$2","v":8.6999999999999994E-2}]
[]
[{"$f":"startDate","v":"2021-01-01"}]
[{"$f":"endDate","v":"2026-01-28"}]

{"sheet":"Correlation Matrix","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,2,0,9]]}
[null,null,"Correlation Matrix"]
[null,null,{"$f":"Returns!K3","v":"_1"},{"$f":"Returns!L3","v":"_2"},{"$f":"Returns!M3","v":"_3"},{"$f":"Returns!N3","v":"_4"},{"$f":"Returns!O3","v":"_5"},{"$f":"Returns!P3","v":"_6"},{"$f":"Returns!Q3","v":"_7"},{"$f":"Returns!R3","v":"_8"}]
[null,null,{"$f":"Returns!B2","v":"SBUX"},{"$f":"Returns!C2","v":"JPM"},{"$f":"Returns!D2","v":"KO"},{"$f":"Returns!E2","v":"GRMN"},{"$f":"Returns!F2","v":"HD"},{"$f":"Returns!G2","v":"LUV"},{"$f":"Returns!H2","v":"LLY"},{"$f":"Returns!I2","v":"XOM"},null,null,"Stand Dev","Expect Ret"]
[{"$f":"C2","v":"_1"},{"$f":"C3","v":"SBUX"},{"$f":"CORREL(_1,_1)","v":1},{"$f":"TRANSPOSE(C5:C11)","v":0.45024870652771126},0.31098405843020793,0.39959070351419901,0.43357148541505436,0.25434494418785275,0.18809150669022842,0.15619167456599906,null,{"$f":"B4","v":"SBUX"},{"$f":"Returns!K66","v":0.28899818341629169},{"$f":"Returns!K69","v":8.4917230900367333E-2}]
[{"$f":"D2","v":"_2"},{"$f":"D3","v":"JPM"},{"$f":"CORREL(_2,_1)","v":0.45024870652771126},{"$f":"CORREL(_2,_2)","v":0.99999999999999978},{"$f":"TRANSPOSE(D6:D11)","v":0.13876093639597425},0.54529717212491158,0.44787238485183128,0.44903884510282827,8.8967939637027774E-3,0.30460823061766606,null,{"$f":"B5","v":"JPM"},{"$f":"Returns!L66","v":0.23658043164971335},{"$f":"Returns!L69","v":9.0269927017146617E-2}]
[{"$f":"E2","v":"_3"},{"$f":"E3","v":"KO"},{"$f":"CORREL(_3,_1)","v":0.31098405843020793},{"$f":"CORREL(_3,_2)","v":0.13876093639597425},{"$f":"CORREL(_3,_3)","v":1},{"$f":"TRANSPOSE(E7:E11)","v":0.11787664437182062},0.29205209565815232,0.20368634801833929,0.30412255119258286,0.29166152197376,null,"KO",{"$f":"Returns!M66","v":0.16118577905073289},{"$f":"Returns!M69","v":5.1103175650690696E-2}]
[{"$f":"F2","v":"_4"},{"$f":"F3","v":"GRMN"},{"$f":"CORREL(_4,_1)","v":0.39959070351419901},{"$f":"CORREL(_4,_2)","v":0.54529717212491158},{"$f":"CORREL(_4,_3)","v":0.11787664437182062},{"$f":"CORREL(_4,_4)","v":1.0000000000000002},{"$f":"TRANSPOSE(F8:F11)","v":0.39361667075143475},0.38991048268843376,2.1215669670568808E-2,5.1344564248439133E-2,null,"GRMN",{"$f":"Returns!N66","v":0.25585053174522526},{"$f":"Returns!N69","v":8.6277024327654925E-2}]
[{"$f":"G2","v":"_5"},{"$f":"G3","v":"HD"},{"$f":"CORREL(_5,_1)","v":0.43357148541505436},{"$f":"CORREL(_5,_2)","v":0.44787238485183128},{"$f":"CORREL(_5,_3)","v":0.29205209565815232},{"$f":"CORREL(_5,_4)","v":0.39361667075143475},{"$f":"CORREL(_5,_5)","v":1.0000000000000002},{"$f":"TRANSPOSE(G9:G11)","v":0.31257517247621031},-1.6548069608960835E-2,0.1305664021561895,null,"HD",{"$f":"Returns!O66","v":0.24052119747431647},{"$f":"Returns!O69","v":8.990707125248476E-2}]
[{"$f":"H2","v":"_6"},{"$f":"H3","v":"LUV"},{"$f":"CORREL(_6,_1)","v":0.25434494418785275},{"$f":"CORREL(_6,_2)","v":0.44903884510282827},{"$f":"CORREL(_6,_3)","v":0.20368634801833929},{"$f":"CORREL(_6,_4)","v":0.38991048268843376},{"$f":"CORREL(_6,_5)","v":0.31257517247621031},{"$f":"CORREL(_6,_6)","v":0.99999999999999989},{"$f":"TRANSPOSE(H10:H11)","v":-9.2523448392686586E-2},0.39523138232748473,null,"LUV",{"$f":"Returns!P66","v":0.37083587626848741},{"$f":"Returns!P69","v":9.5234419568079529E-2}]
[{"$f":"I2","v":"_7"},{"$f":"I3","v":"LLY"},{"$f":"CORREL(_7,_1)","v":0.18809150669022842},{"$f":"CORREL(_7,_2)","v":8.8967939637027774E-3},{"$f":"CORREL(_7,_3)","v":0.30412255119258286},{"$f":"CORREL(_7,_4)","v":2.1215669670568808E-2},{"$f":"CORREL(_7,_5)","v":-1.6548069608960835E-2},{"$f":"CORREL(_7,_6)","v":-9.2523448392686586E-2},{"$f":"CORREL(_7,_7)","v":0.99999999999999989},{"$f":"TRANSPOSE(I11)","v":-3.0761809795872935E-2},null,"LLY",{"$f":"Returns!Q66","v":0.30621863614894246},{"$f":"Returns!Q69","v":5.1808419968634743E-2}]
[{"$f":"J2","v":"_8"},{"$f":"J3","v":"XOM"},{"$f":"CORREL(_8,_1)","v":0.15619167456599906},{"$f":"CORREL(_8,_2)","v":0.30460823061766606},{"$f":"CORREL(_8,_3)","v":0.29166152197376},{"$f":"CORREL(_8,_4)","v":5.1344564248439133E-2},{"$f":"CORREL(_8,_5)","v":0.1305664021561895},{"$f":"CORREL(_8,_6)","v":0.39523138232748473},{"$f":"CORREL(_8,_7)","v":-3.0761809795872935E-2},{"$f":"CORREL(_8,_8)","v":1.0000000000000002},null,"XOM",{"$f":"Returns!R66","v":0.26385448819652957},{"$f":"Returns!R69","v":5.1532973825528045E-2}]

{"sheet":"Covar Matrix","index":3,"n_rows":1048530,"n_cols":10,"rows_kept":4500,"cut":true,"hidden":false,"merged":[[0,3,0,8],[11,3,11,8]],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
[null,null,null,"Var/Cov Matrix"]
[null,null,{"$f":"'Correlation Matrix'!C3","v":"SBUX"},{"$f":"'Correlation Matrix'!D3","v":"JPM"},{"$f":"'Correlation Matrix'!E3","v":"KO"},{"$f":"'Correlation Matrix'!F3","v":"GRMN"},{"$f":"'Correlation Matrix'!G3","v":"HD"},{"$f":"'Correlation Matrix'!H3","v":"LUV"},{"$f":"'Correlation Matrix'!I3","v":"LLY"},{"$f":"'Correlation Matrix'!J3","v":"XOM"}]
[null,{"$f":"C2","v":"SBUX"},{"$f":"'Correlation Matrix'!C4*'Correlation Matrix'!$M$4*'Correlation Matrix'!M4","v":8.3519950017916567E-2},{"$f":"'Correlation Matrix'!D4*'Correlation Matrix'!$M$5*'Correlation Matrix'!M4","v":3.0784096132717577E-2},{"$f":"'Correlation Matrix'!E4*'Correlation Matrix'!$M$6*'Correlation Matrix'!M4","v":1.4486382975642439E-2},{"$f":"'Correlation Matrix'!F4*'Correlation Matrix'!$M$7*'Correlation Matrix'!M4","v":2.9545872039314056E-2},{"$f":"'Correlation Matrix'!G4*'Correlation Matrix'!$M$8*'Correlation Matrix'!M4","v":3.0137635958293676E-2},{"$f":"'Correlation Matrix'!H4*'Correlation Matrix'!$M$9*'Correlation Matrix'!M4","v":2.7258375202338949E-2},{"$f":"'Correlation Matrix'!I4*'Correlation Matrix'!$M$10*'Correlation Matrix'!M4","v":1.664546439381745E-2},{"$f":"'Correlation Matrix'!J4*'Correlation Matrix'!$M$11*'Correlation Matrix'!M4","v":1.1910156823246761E-2}]
[null,{"$f":"D2","v":"JPM"},{"$f":"'Correlation Matrix'!C5*'Correlation Matrix'!$M$4*'Correlation Matrix'!M5","v":3.0784096132717577E-2},{"$f":"'Correlation Matrix'!D5*'Correlation Matrix'!$M$5*'Correlation Matrix'!M5","v":5.5970300639564673E-2},{"$f":"'Correlation Matrix'!E5*'Correlation Matrix'!$M$6*'Correlation Matrix'!M5","v":5.2914264562021465E-3},{"$f":"'Correlation Matrix'!F5*'Correlation Matrix'!$M$7*'Correlation Matrix'!M5","v":3.3006417534433223E-2},{"$f":"'Correlation Matrix'!G5*'Correlation Matrix'!$M$8*'Correlation Matrix'!M5","v":2.5485107071439212E-2},{"$f":"'Correlation Matrix'!H5*'Correlation Matrix'!$M$9*'Correlation Matrix'!M5","v":3.9395305722218041E-2},{"$f":"'Correlation Matrix'!I5*'Correlation Matrix'!$M$10*'Correlation Matrix'!M5","v":6.4453123798143051E-4},{"$f":"'Correlation Matrix'!J5*'Correlation Matrix'!$M$11*'Correlation Matrix'!M5","v":1.901450131141403E-2}]
[null,{"$f":"E2","v":"KO"},{"$f":"'Correlation Matrix'!C6*'Correlation Matrix'!$M$4*'Correlation Matrix'!M6","v":1.4486382975642439E-2},{"$f":"'Correlation Matrix'!D6*'Correlation Matrix'!$M$5*'Correlation Matrix'!M6","v":5.2914264562021465E-3},{"$f":"'Correlation Matrix'!E6*'Correlation Matrix'!$M$6*'Correlation Matrix'!M6","v":2.5980855368191683E-2},{"$f":"'Correlation Matrix'!F6*'Correlation Matrix'!$M$7*'Correlation Matrix'!M6","v":4.8611700186359163E-3},{"$f":"'Correlation Matrix'!G6*'Correlation Matrix'!$M$8*'Correlation Matrix'!M6","v":1.1322449880744117E-2},{"$f":"'Correlation Matrix'!H6*'Correlation Matrix'!$M$9*'Correlation Matrix'!M6","v":1.2175039734528768E-2},{"$f":"'Correlation Matrix'!I6*'Correlation Matrix'!$M$10*'Correlation Matrix'!M6","v":1.5010908078689095E-2},{"$f":"'Correlation Matrix'!J6*'Correlation Matrix'!$M$11*'Correlation Matrix'!M6","v":1.2404245308810735E-2}]
[null,{"$f":"F2","v":"GRMN"},{"$f":"'Correlation Matrix'!C7*'Correlation Matrix'!$M$4*'Correlation Matrix'!M7","v":2.9545872039314053E-2},{"$f":"'Correlation Matrix'!D7*'Correlation Matrix'!$M$5*'Correlation Matrix'!M7","v":3.3006417534433216E-2},{"$f":"'Correlation Matrix'!E7*'Correlation Matrix'!$M$6*'Correlation Matrix'!M7","v":4.8611700186359163E-3},{"$f":"'Correlation Matrix'!F7*'Correlation Matrix'!$M$7*'Correlation Matrix'!M7","v":6.5459494594314535E-2},{"$f":"'Correlation Matrix'!G7*'Correlation Matrix'!$M$8*'Correlation Matrix'!M7","v":2.4222176535764958E-2},{"$f":"'Correlation Matrix'!H7*'Correlation Matrix'!$M$9*'Correlation Matrix'!M7","v":3.699414361879428E-2},{"$f":"'Correlation Matrix'!I7*'Correlation Matrix'!$M$10*'Correlation Matrix'!M7","v":1.6621671180051456E-3},{"$f":"'Correlation Matrix'!J7*'Correlation Matrix'!$M$11*'Correlation Matrix'!M7","v":3.4661334724469927E-3}]
[null,{"$f":"G2","v":"HD"},{"$f":"'Correlation Matrix'!C8*'Correlation Matrix'!$M$4*'Correlation Matrix'!M8","v":3.013763595829368E-2},{"$f":"'Correlation Matrix'!D8*'Correlation Matrix'!$M$5*'Correlation Matrix'!M8","v":2.5485107071439209E-2},{"$f":"'Correlation Matrix'!E8*'Correlation Matrix'!$M$6*'Correlation Matrix'!M8","v":1.1322449880744118E-2},{"$f":"'Correlation Matrix'!F8*'Correlation Matrix'!$M$7*'Correlation Matrix'!M8","v":2.4222176535764962E-2},{"$f":"'Correlation Matrix'!G8*'Correlation Matrix'!$M$8*'Correlation Matrix'!M8","v":5.7850446434479154E-2},{"$f":"'Correlation Matrix'!H8*'Correlation Matrix'!$M$9*'Correlation Matrix'!M8","v":2.7879795246292843E-2},{"$f":"'Correlation Matrix'!I8*'Correlation Matrix'!$M$10*'Correlation Matrix'!M8","v":-1.2187996317666108E-3},{"$f":"'Correlation Matrix'!J8*'Correlation Matrix'!$M$11*'Correlation Matrix'!M8","v":8.2860830218390181E-3}]
[null,{"$f":"H2","v":"LUV"},{"$f":"'Correlation Matrix'!C9*'Correlation Matrix'!$M$4*'Correlation Matrix'!M9","v":2.7258375202338949E-2},{"$f":"'Correlation Matrix'!D9*'Correlation Matrix'!$M$5*'Correlation Matrix'!M9","v":3.9395305722218048E-2},{"$f":"'Correlation Matrix'!E9*'Correlation Matrix'!$M$6*'Correlation Matrix'!M9","v":1.2175039734528768E-2},{"$f":"'Correlation Matrix'!F9*'Correlation Matrix'!$M$7*'Correlation Matrix'!M9","v":3.699414361879428E-2},{"$f":"'Correlation Matrix'!G9*'Correlation Matrix'!$M$8*'Correlation Matrix'!M9","v":2.7879795246292839E-2},{"$f":"'Correlation Matrix'!H9*'Correlation Matrix'!$M$9*'Correlation Matrix'!M9","v":0.13751924712781688},{"$f":"'Correlation Matrix'!I9*'Correlation Matrix'!$M$10*'Correlation Matrix'!M9","v":-1.0506671930366142E-2},{"$f":"'Correlation Matrix'!J9*'Correlation Matrix'!$M$11*'Correlation Matrix'!M9","v":3.8672090582979331E-2}]
[null,{"$f":"I2","v":"LLY"},{"$f":"'Correlation Matrix'!C10*'Correlation Matrix'!$M$4*'Correlation Matrix'!M10","v":1.664546439381745E-2},{"$f":"'Correlation Matrix'!D10*'Correlation Matrix'!$M$5*'Correlation Matrix'!M10","v":6.4453123798143051E-4},{"$f":"'Correlation Matrix'!E10*'Correlation Matrix'!$M$6*'Correlation Matrix'!M10","v":1.5010908078689097E-2},{"$f":"'Correlation Matrix'!F10*'Correlation Matrix'!$M$7*'Correlation Matrix'!M10","v":1.6621671180051456E-3},{"$f":"'Correlation Matrix'!G10*'Correlation Matrix'!$M$8*'Correlation Matrix'!M10","v":-1.2187996317666108E-3},{"$f":"'Correlation Matrix'!H10*'Correlation Matrix'!$M$9*'Correlation Matrix'!M10","v":-1.0506671930366144E-2},{"$f":"'Correlation Matrix'!I10*'Correlation Matrix'!$M$10*'Correlation Matrix'!M10","v":9.3769853124918395E-2},{"$f":"'Correlation Matrix'!J10*'Correlation Matrix'!$M$11*'Correlation Matrix'!M10","v":-2.4854669146421762E-3}]
[null,{"$f":"J2","v":"XOM"},{"$f":"'Correlation Matrix'!C11*'Correlation Matrix'!$M$4*'Correlation Matrix'!M11","v":1.1910156823246759E-2},{"$f":"'Correlation Matrix'!D11*'Correlation Matrix'!$M$5*'Correlation Matrix'!M11","v":1.9014501311414033E-2},{"$f":"'Correlation Matrix'!E11*'Correlation Matrix'!$M$6*'Correlation Matrix'!M11","v":1.2404245308810733E-2},{"$f":"'Correlation Matrix'!F11*'Correlation Matrix'!$M$7*'Correlation Matrix'!M11","v":3.4661334724469923E-3},{"$f":"'Correlation Matrix'!G11*'Correlation Matrix'!$M$8*'Correlation Matrix'!M11","v":8.2860830218390163E-3},{"$f":"'Correlation Matrix'!H11*'Correlation Matrix'!$M$9*'Correlation Matrix'!M11","v":3.8672090582979324E-2},{"$f":"'Correlation Matrix'!I11*'Correlation Matrix'!$M$10*'Correlation Matrix'!M11","v":-2.4854669146421766E-3},{"$f":"'Correlation Matrix'!J11*'Correlation Matrix'!$M$11*'Correlation Matrix'!M11","v":6.961919094145258E-2}]
[]
[null,null,null,"Weighted Var/Cov Matrix"]
[null,null,{"$f":"C2","v":"SBUX"},{"$f":"D2","v":"JPM"},"KO","GRMN","HD","LUV","LLY","XOM"]
[null,"Weights",{"$f":"B15","v":-4.5355235733430456E-2},{"$f":"B16","v":0.11930896122328224},{"$f":"B17","v":0.4557242248016844},{"$f":"B18","v":0.15273272055572668},{"$f":"B19","v":0.10677239785678115},{"$f":"B20","v":-3.7351199891645558E-2},{"$f":"B21","v":0.1102762930773017},{"$f":"B22","v":0.1378918197145528}]
[{"$f":"B3","v":"SBUX"},-4.5355235733430456E-2,{"$f":"C3*$B$15*C14","v":1.7180867273448083E-4},{"$f":"D3*B15*$D$14","v":-1.6658155031554691E-4},{"$f":"E3*B15*$E$14","v":-2.9942599804928273E-4},{"$f":"F3*B15*$F$14","v":-2.0467100817804203E-4},{"$f":"G3*B15*$G$14","v":-1.4594714614229665E-4},{"$f":"H3*B15*$H$14","v":4.6177663171092255E-5},{"$f":"I3*B15*$I$14","v":-8.3254075696843636E-5},{"$f":"J3*B15*$J$14","v":-7.4487502218159943E-5}]
[{"$f":"B4","v":"JPM"},0.11930896122328224,{"$f":"C4*B16*$C$14","v":-1.6658155031554691E-4},7.9671642142359377E-4,2.8770535390143899E-4,6.0145555649766076E-4,3.2465232924273272E-4,-1.7555859540057547E-4,8.4800652551932626E-6,3.1282143731201025E-4]
["KO",0.4557242248016844,{"$f":"C5*B17*$C$14","v":-2.9942599804928273E-4},2.8770535390143899E-4,5.3958227512413649E-3,3.3835688126868519E-4,5.5093646469575651E-4,-2.0724165890525497E-4,7.5438186445116705E-4,7.7949074674315861E-4]
["GRMN",0.15273272055572668,-2.0467100817804198E-4,6.0145555649766065E-4,3.3835688126868519E-4,1.5269922162081089E-3,3.9500650601437536E-4,-2.1104235469957396E-4,2.7995545433819267E-5,7.2998825540602778E-5]
["HD",0.10677239785678115,-1.4594714614229665E-4,3.2465232924273267E-4,5.5093646469575662E-4,3.9500650601437547E-4,6.5951504452247658E-4,-1.1118677507263321E-4,-1.4350712678279987E-5,1.219963337273652E-4]
["LUV",-3.7351199891645558E-2,4.6177663171092255E-5,-1.755585954005755E-4,-2.0724165890525497E-4,-2.1104235469957396E-4,-1.1118677507263318E-4,1.9185477023657806E-4,4.3276475953451554E-5,-1.9917769910821517E-4]
["LLY",0.1102762930773017,-8.3254075696843636E-5,8.4800652551932643E-6,7.5438186445116716E-4,2.7995545433819274E-5,-1.4350712678279987E-5,4.3276475953451561E-5,1.1403221324830235E-3,-3.7794503825490101E-5]
["XOM",0.1378918197145528,-7.4487502218159929E-5,3.128214373120103E-4,7.794907467431585E-4,7.2998825540602751E-5,1.2199633372736516E-4,-1.9917769910821515E-4,-3.7794503825490115E-5,1.3237500140307883E-3]
["Sum",{"$f":"SUM(B15:B22)","v":0.99999998160425285}]
[]
["Port. Var",{"$f":"SUM(C15:J22)","v":1.6676806960717043E-2}]
["Port. S.D.",{"$f":"SQRT(B25)","v":0.12913871209175443}]
["Port. E(R.)",{"$f":"SUMPRODUCT('Correlation Matrix'!N4:N11,B15:B22)","v":6.2246539732625311E-2}]
[]
["Sharpe",{"$f":"(B27-Returns!U1)/'Covar Matrix'!B26","v":0.24970467190127932}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["$b$17",{"$f":"IF(ISBLANK(A1048500)=TRUE,\"\",INDIRECT(A1048500))","v":0.4557242248016844},"this is foreign investments"]
["$b$18",{"$f":"IF(ISBLANK(A1048501)=TRUE,\"\",INDIRECT(A1048501))","v":0.15273272055572668}]
["$b$19",{"$f":"IF(ISBLANK(A1048502)=TRUE,\"\",INDIRECT(A1048502))","v":0.10677239785678115}]
["$b$22",0.1378918197145528]
["$b$20",-3.7351199891645558E-2]
["$b$21",0.1102762930773017]
[null,{"$f":"SUM(B1048500:B1048505)","v":0.92604625611440117}]
["$b$16",{"$f":"IF(ISBLANK(A1048507)=TRUE,\"\",INDIRECT(A1048507))","v":0.11930896122328224},"this is fixed income"]
["$b$17",{"$f":"IF(ISBLANK(A1048508)=TRUE,\"\",INDIRECT(A1048508))","v":0.4557242248016844}]
["$b$18",{"$f":"IF(ISBLANK(A1048509)=TRUE,\"\",INDIRECT(A1048509))","v":0.15273272055572668}]
["$b$19",0.10677239785678115]
["$b$20",-3.7351199891645558E-2]
[null,{"$f":"SUM(B1048507:B1048511)","v":0.79718710454582897}]
[]
[]
[]
[]
["$b$15",{"$f":"IF(ISBLANK(A1048517)=TRUE,\"\",INDIRECT(A1048517))","v":-4.5355235733430456E-2},"this is real estate"]
["$b$22",{"$f":"IF(ISBLANK(A1048518)=TRUE,\"\",INDIRECT(A1048518))","v":0.1378918197145528}]
[]
[]
[]
[null,{"$f":"SUM(B1048517:B1048521)","v":9.2536583981122356E-2}]
[]
[]
["$b$16",{"$f":"IF(ISBLANK(A1048525)=TRUE,\"\",INDIRECT(A1048525))","v":0.11930896122328224},"This is for commodities"]
["$b$18",{"$f":"IF(ISBLANK(A1048526)=TRUE,\"\",INDIRECT(A1048526))","v":0.15273272055572668}]
["$b$20",{"$f":"IF(ISBLANK(A1048527)=TRUE,\"\",INDIRECT(A1048527))","v":-3.7351199891645558E-2}]
[]
[]
[null,{"$f":"SUM(B1048525:B1048529)","v":0.23469048188736333}]

{"sheet":"Efficient Frontier","index":4,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,3,0,8]]}
[null,null,null,"Efficient Frontier"]
["Expect. Ret.","Stand. Dev.",{"$f":"'Covar Matrix'!C13","v":"SBUX"},{"$f":"'Covar Matrix'!D13","v":"JPM"},{"$f":"'Covar Matrix'!E13","v":"KO"},{"$f":"'Covar Matrix'!F13","v":"GRMN"},{"$f":"'Covar Matrix'!G13","v":"HD"},{"$f":"'Covar Matrix'!H13","v":"LUV"},{"$f":"'Covar Matrix'!I13","v":"LLY"},{"$f":"'Covar Matrix'!J13","v":"XOM"}]
[1.9999994663486398E-2,0.25193380172605057,-0.19311203425863846,-0.21130010894233772,1.1929660484535374,0.18281705830504202,-0.29544814331963065,-0.26168515070248105,0.1218018095414857,0.4639605209230227]
[2.9999994467243333E-2,0.2096181028364052,-0.15813725706651852,-0.13304305942484004,1.0184567473704842,0.17569582223571384,-0.2002400751556519,-0.20858398394189268,0.11907369614973946,0.3867781098329654]
[3.9999997943850549E-2,0.17219909892053839,-0.1231623017440953,-5.4785886294863667E-2,0.84394760471732511,0.16857478581920196,-0.10503230554112869,-0.15548287199159294,0.11634529570259908,0.30959567933255461]
[4.9999997283998045E-2,0.14355832661929527,-8.8187633496233819E-2,2.3471385240002276E-2,0.66943809883411476,0.16145366150851331,-9.824459719057807E-3,-0.10238172609909031,0.11361735041008759,0.23241332332166395]
[5.9999999135128476E-2,0.12965003727206809,-5.3212810193136159E-2,0.10172847986622369,0.49492889499952147,0.15433254930006163,8.5383468769949317E-2,-4.9280561934218016E-2,0.11088913654280255,0.15523084264879569]
[6.9999999895214868E-2,0.13510352430742378,-1.8263954919471182E-2,0.17981321071300468,0.32029124478047666,0.14687501393093966,0.18103894470434431,3.8658111344221642E-3,0.10825623538284933,7.812349427343411E-2]
[8.0000000932114304E-2,0.15792543770697873,1.6736813235542634E-2,0.25824285889123866,0.14591024978218486,0.14009043058847559,0.27579911379028732,5.6921671340099698E-2,0.10543281878751595,8.6604358465544064E-4]
[9.0000002696155559E-2,0.19201983546028176,5.1711536817482466E-2,0.33649997014660132,-2.8598945044726154E-2,0.13296929179322314,0.37100712626630145,0.11002284216796261,0.10270464616984303,-7.6316468316687688E-2]
[0.10000000457409088,0.23247896498171039,8.6686320736289943E-2,0.41475721702693458,-0.20310816615282123,0.1258482629389672,0.46621501934959297,0.16312386694736059,9.9976397022976463E-2,-0.15349891786930048]
[0.11000000295171557,0.27652303855253424,0.12166116978540854,0.49301447936598192,-0.37761733349265031,0.11872714257941552,0.56142264472914727,0.2162250560814146,9.7248217821455624E-2,-0.23068137687017315]
[0.12000000711979622,0.32268748023267541,0.15662708837820946,0.57118325962051941,-0.55188806587404882,0.11160320490264898,0.65665239499529648,0.26939664294035753,9.4542955929600991E-2,-0.30811748089258417]
[0.13000000616847832,0.37017979644911497,0.19161077254148565,0.64952909979646412,-0.72663591623257062,0.1044850578071026,0.75183821916919569,0.32242715917732961,9.1791913528756736E-2,-0.38504630578776344]
[6.2246539732625311E-2,0.12913871209175443,-4.5355235733430456E-2,0.11930896122328224,0.4557242248016844,0.15273272055572668,0.10677239785678115,-3.7351199891645558E-2,0.1102762930773017,0.1378918197145528,"MVP"]
[8.1971886967613303E-2,0.16394537196106262,2.363369248355579E-2,0.27367427397832444,0.11149883974554538,0.13868614013224906,0.29457292921062023,6.7392612248645997E-2,0.10489475366203978,-1.435327349826478E-2,"MVE"]