{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Inputs","Returns","Correlation Matrix","Covar Matrix","Efficient Frontier"],"not_rendered":{"charts":1,"images":43,"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":"2025-02-06"}]
["Start date  ",{"$f":"DATE(YEAR(B4)-5, MONTH(B4)-1,1)","v":"2020-01-01"}]
["End date  ",{"$f":"DATE(YEAR(B4), MONTH(B4)-1, 28)","v":"2025-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,"NFLX"]
[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":"NFLX"},{"$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":"NFLX"},{"$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":"2020-01-01"},{"$f":"_xlfn.STOCKHISTORY(B2,$A$71,$A$72,2,0,1)","v":345.09},{"$f":"_xlfn.STOCKHISTORY(C2,$A$71,$A$72,2,0,1)","v":132.36000000000001},{"$f":"_xlfn.STOCKHISTORY(D2,$A$71,$A$72,2,0,1)","v":58.4},{"$f":"_xlfn.STOCKHISTORY(E2,$A$71,$A$72,2,0,1)","v":96.95},{"$f":"_xlfn.STOCKHISTORY(F2,$A$71,$A$72,2,0,1)","v":228.1},{"$f":"_xlfn.STOCKHISTORY(G2,$A$71,$A$72,2,0,1)","v":54.98},{"$f":"_xlfn.STOCKHISTORY(H2,$A$71,$A$72,2,0,1)","v":139.63999999999999},{"$f":"_xlfn.STOCKHISTORY(I2,$A$71,$A$72,2,0,1)","v":62.12},{"$f":"_xlfn.STOCKHISTORY(J2,$A$71,$A$72,2,0,1)","v":323.24},"_1","_2","_3","_4","_5","_6","_7","_8"]
[{"$f":"EDATE(A3,1)","v":"2020-02-01"},369.03,116.11,53.49,88.39,217.84,46.19,126.13,51.44,295.91000000000003,{"$f":"LN(B4/B3)","v":6.7072688972774741E-2},{"$f":"LN(C4/C3)","v":-0.1309874654144968},{"$f":"LN(D4/D3)","v":-8.782116929102253E-2},{"$f":"LN(E4/E3)","v":-9.2436540615804225E-2},{"$f":"LN(F4/F3)","v":-4.6023280924838178E-2},{"$f":"LN(G4/G3)","v":-0.17420615829458558},{"$f":"LN(H4/H3)","v":-0.10175456113773343},{"$f":"LN(I4/I3)","v":-0.18865191835112236},{"$f":"LN(J4/J3)","v":-8.8339727329046339E-2}]
[{"$f":"EDATE(A4,1)","v":"2020-03-01"},375.5,90.03,44.25,74.959999999999994,186.71,35.61,138.72,37.97,258.39999999999998,{"$f":"LN(B5/B4)","v":1.7380529655386195E-2},-0.2543950695185293,-0.1896393490892202,-0.1648042031426899,-0.15420423738825972,-0.26013682715282771,9.5144391933129971E-2,-0.303619705685653,-0.13554658212775381]
["2020-04-01",419.85,95.76,45.89,81.16,219.83,31.25,154.63999999999999,46.47,291.16000000000003,0.11163903342538282,6.1702113129332291E-2,3.6391856952803552E-2,7.9467877027447356E-2,0.16329790939478137,-0.13060712110727585,0.10864232186784369,0.20201056885317598,0.11936417234161045]
["2020-05-01",419.73,97.31,46.68,90.17,248.48,32.1,152.94999999999999,45.47,305.18,-2.8585721626796451E-4,1.6056697584179967E-2,1.7068579011613089E-2,0.10527426255420148,0.12250783902835115,2.6836653953559785E-2,-1.098876430316296E-2,-2.1754175259967777E-2,4.7028822213532363E-2]
["2020-06-01",455.04,94.06,44.68,97.5,250.51,34.18,164.18,44.72,309.69,8.0773679761517198E-2,-3.3968882316995672E-2,-4.3789833217355328E-2,7.815560049198618E-2,8.1364804874348232E-3,6.2784647551474615E-2,7.0852316323207779E-2,-1.6631938990075496E-2,1.4670030682018788E-2]
["2020-07-01",488.88,96.64,47.24,98.59,265.49,30.89,150.29,42.08,327.82,7.1731733411838666E-2,2.7059857669602984E-2,5.5715017128161633E-2,1.1117458583148542E-2,5.8078335301418656E-2,-0.10120817075695453,-8.8396625974117238E-2,-6.0848260417389353E-2,5.6892880115605553E-2]
["2020-08-01",529.55999999999995,100.19,49.53,103.61,285.04000000000002,37.58,148.38999999999999,39.94,350.77,7.9929412482796017E-2,3.6075649084666865E-2,4.7337555270984669E-2,4.9664013676710327E-2,7.1052346108350359E-2,0.1960394870548289,-1.272281792796796E-2,-5.2194240441785236E-2,6.7666060765732561E-2]
["2020-09-01",500.03,96.27,49.37,94.86,277.70999999999998,37.5,148.02000000000001,34.33,336.06,-5.7378376447192403E-2,-3.9911639481296488E-2,-3.2355943293748898E-3,-8.8231729814224766E-2,-2.6052117550351198E-2,-2.1310610089540628E-3,-2.4965432487145649E-3,-0.15135872051806842,-4.2841022577150542E-2]
["2020-10-01",475.74,98.04,48.06,104.02,266.70999999999998,39.53,130.46,32.619999999999997,327.62,-4.979661010990119E-2,1.821881487003682E-2,-2.6892721962448546E-2,9.2181067895490729E-2,-4.0415477949106868E-2,5.271894433222904E-2,-0.12628073340137044,-5.1094010276732924E-2,-2.5435315273310617E-2]
["2020-11-01",490.7,117.88,51.6,116.76,277.41000000000003,46.34,145.65,38.130000000000003,363.32,3.0961456583495143E-2,0.18429159920958205,7.1071442179194158E-2,0.11553735764098774,3.9334630459534385E-2,0.1589456416956361,0.11013981703749355,0.15607577667660474,0.10342958845752757]
["2020-12-01",540.73,127.07,54.84,119.66,265.62,46.61,168.84,41.22,375.39,9.7087135385270223E-2,7.5070957846948963E-2,6.0898182206596568E-2,2.4533841975971707E-2,-4.3429840285552371E-2,5.8095913804194045E-3,0.14774503750885432,7.7922201592840412E-2,3.2681496911060537E-2]
["2021-01-01",532.39,128.66999999999999,48.15,114.86,270.82,43.94,207.97,44.84,371.52,-1.5543775006594212E-2,1.2512871480455748E-2,-0.13009871644997914,-4.0940392525735302E-2,1.9387677582573235E-2,-5.8990043428185458E-2,0.20844231761553156,8.4177022741646249E-2,-1.0362787035546547E-2]
["2021-02-01",538.85,147.16999999999999,48.99,124.02,258.33999999999997,58.13,204.89,54.37,381.77,1.2060935568307009E-2,0.13433739397912264,1.7295057406349006E-2,7.6728847485581494E-2,-4.7177846750808564E-2,0.27985681475679508,-1.4920588770721907E-2,0.19271193295387007,2.7215634524684042E-2]
["2021-03-01",521.66,152.22999999999999,52.71,131.85,305.25,61.06,186.82,55.83,397.82,-3.2421204371071793E-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",513.47,153.81,53.98,137.24,323.67,62.78,182.77,57.24,418.88,-1.5824429599890149E-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",502.81,164.24,55.29,142.24,318.91000000000003,61.46,199.74,58.37,421.65,-2.0979239929855266E-2,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",528.21,155.54,54.11,144.63999999999999,318.89,53.09,229.52,63.08,429.92,4.9281566764438962E-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",517.57000000000005,151.78,57.03,157.19999999999999,328.19,50.52,243.5,57.57,440.4,-2.0349150214035217E-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",569.19000000000005,159.94999999999999,56.31,174.43,326.18,49.78,258.29000000000002,54.52,453.71,9.5069515851724615E-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",610.34,163.69,52.47,155.46,328.26,51.43,231.05,58.82,430.82,6.9801881395493717E-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",690.31,169.89,56.37,143.6,371.74,47.28,254.76,64.47,460.99,0.12312459312002097,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",641.9,158.83000000000001,52.45,133.54,400.61,44.4,248.04,59.84,457.63,-7.2708243741934103E-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",602.44000000000005,158.35,59.21,136.16999999999999,415.01,42.84,276.22000000000003,61.19,476.99,-6.3444452974084534E-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",427.14,148.6,61.01,124.42,366.98,44.76,245.39,75.959999999999994,451.77,-0.34387624699981106,-6.3549640700989993E-2,2.9947338620076321E-2,-9.0241166049610064E-2,-0.12299526566911968,4.3842637864176311E-2,-0.11834886799951823,0.21622310846963599,-5.4322325541161204E-2]
["2022-02-01",394.52,141.80000000000001,62.24,110.44,315.83,43.8,249.95,78.42,438.72,-7.9441992258044131E-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",374.59,136.32,62,118.61,299.33,45.8,286.37,82.59,453.69,-5.1837741573610568E-2,-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",190.36,119.36,64.61,109.74,300.39999999999998,46.72,292.13,85.25,413.56,-0.67691507825927255,-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",197.44,132.22999999999999,63.38,105.62,302.75,45.86,313.44,96,414.87,3.6517724464113117E-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",174.87,112.61,62.91,98.25,274.27,36.119999999999997,324.23,85.64,379.15,-0.12139189999145489,-0.16061230885979724,-7.4432206808365004E-3,-7.2332496529416548E-2,-9.8794359774584617E-2,-0.23874654888097371,3.384518629613345E-2,-0.11419572774635418,-9.0033312997732234E-2]
["2022-07-01",224.9,115.36,64.17,97.62,300.94,38.119999999999997,329.69,96.93,414.28,0.25161301823970189,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",223.56,113.73,61.71,88.49,288.42,36.700000000000003,301.23,95.59,397.18,-5.9760245637726014E-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",235.44,104.5,56.02,80.31,275.94,30.84,323.35000000000002,87.31,358.65,5.1776269523719949E-2,-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",291.88,125.88,59.85,88.04,296.13,36.35,362.09,110.81,387.79,0.21488665497220194,0.18614200079134038,6.6132662172019629E-2,9.1897110457890036E-2,7.0615096318018822E-2,0.16438165528439966,0.11315747181717094,0.23835201912551779,7.811697341575051E-2]
["2022-11-01",305.52999999999997,138.18,63.61,92.99,323.99,39.909999999999997,371.08,111.34,409.32,4.5705214565626151E-2,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",294.88,134.1,63.61,92.29,315.86,33.67,365.84,110.3,384.21,-3.5479479541532292E-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",353.86,139.96,61.32,98.88,324.17,35.770000000000003,344.15,116.01,408.31,0.18233286076334373,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",322.13,143.35,59.51,98.13,296.54000000000002,33.58,311.22000000000003,109.91,397.97,-9.394616390807288E-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",345.48,130.31,62.03,100.92,295.12,32.54,343.42,109.66,411.08,6.9979563635300959E-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",329.93,138.24,64.150000000000006,98.17,300.54000000000002,30.29,395.86,118.34,417.66,-4.6054243664566473E-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",395.23,135.71,59.66,103.15,283.45,29.87,429.46,102.18,419.43,0.18058736317627955,-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",440.49,145.44,60.22,104.29,310.64,36.21,468.98,107.25,445.71,0.10841986971915787,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",438.97,157.96,61.93,105.89,333.84,34.159999999999997,454.55,107.24,460.18,-3.4566700327130538E-3,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",433.68,146.33000000000001,59.83,106.02,330.3,31.6,554.20000000000005,111.19,452.69,-1.2124138658160052E-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",377.6,145.02000000000001,55.98,105.2,302.16000000000003,27.07,537.13,117.58,429.43,-0.1384715006807371,-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",411.69,139.06,56.49,102.53,284.69,22.23,553.92999999999995,105.85,419.94,8.6435204678305885E-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",473.97,156.08000000000001,58.44,122.24,313.49,25.57,591.04,102.74,458.42,0.1408733896032158,0.11546320164398398,3.3936955545327878E-2,0.17583088673621036,9.6366592663144596E-2,0.13997706132699012,6.484537203751771E-2,-2.9821472541752349E-2,8.7673950536716935E-2]
["2023-12-01",486.88,170.1,58.93,128.54,346.55,28.88,582.91999999999996,99.98,477.63,2.6873657595793632E-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",564.11,174.36,59.49,119.49,352.96,29.89,645.61,102.81,485.2,0.14723158179344792,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",602.91999999999996,186.06,60.02,137.35,380.61,34.270000000000003,753.68,104.52,510.45,6.6535250000219565E-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",607.33000000000004,200.3,61.18,148.87,383.6,29.19,777.96,116.24,525.73,7.2877827201998091E-3,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",550.64,191.74,61.77,144.47,334.22,25.94,781.1,118.27,504.44,-9.7991062572419407E-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",641.62,202.63,62.93,163.85,334.87,26.84,820.34,117.26,529.96,0.15291499004618256,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",674.88,202.26,63.65,162.91999999999999,344.24,28.61,905.38,115.12,547.23,5.0538669154118497E-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",628.35,212.8,66.739999999999995,171.25,368.16,26.94,804.27,118.59,553.32000000000005,-7.1437561229256111E-2,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",701.35,224.8,72.47,183.29,368.5,28.92,960.02,117.94,566.75,0.10990971310452687,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",709.27,210.86,71.86,176.03,405.2,29.63,885.94,117.22,576.82000000000005,1.1229222927252454E-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",756.03,221.92,65.31,198.35,393.75,30.58,829.74,116.78,571.24,6.3844785838951437E-2,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",886.81,249.72,64.08,212.6,429.13,32.36,795.35,117.96,605.07000000000005,0.15954969624646712,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",891.32,239.71,62.26,206.26,388.99,33.619999999999997,772,107.57,588.67999999999995,5.0727558404160787E-3,-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",976.76,267.3,63.48,215.85,411.98,30.71,811.08,106.83,604.66,{"$f":"LN(B63/B62)","v":9.153746189830142E-2},{"$f":"LN(C63/C62)","v":0.10894176375955462},1.9405730644746252E-2,4.5446213113563526E-2,5.7421168134779842E-2,-9.0532793527738423E-2,4.9382142875486923E-2,-6.9030124861179489E-3,2.6783574291956321E-2]
[]
["Monthly Standard Deviation",null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.STDEV.S(K4:K63)","v":0.13350834077428234},{"$f":"_xlfn.STDEV.S(L4:L63)","v":8.0592893414032557E-2},5.5375313654252668E-2,7.4977304394350339E-2,7.4468492985227189E-2,0.11052160724359357,8.6714135026781353E-2,9.6069088873865907E-2,5.3244934518145305E-2]
["Annualized Standard Deviation",null,null,null,null,null,null,null,null,null,{"$f":"K65*SQRT(12)","v":0.46248645891055312},{"$f":"L65*SQRT(12)","v":0.27918197224417507},0.19182571346845642,0.25972900125114406,0.25796642682700005,0.38285807816015299,0.3003865752015466,0.33279308593277135,0.18444586366221113]
["Correlation with S&P",null,null,null,null,null,null,null,null,null,{"$f":"CORREL(K4:K63,$S$4:$S$63)","v":0.5345182992652332},{"$f":"CORREL(L4:L63,$S$4:$S$63)","v":0.74394155219477653},0.60285705692599378,0.70327000311995791,0.73776394769807752,0.55681216064585892,0.239630584434879,0.49229554099537459,1.0000000000000002]
["Beta",null,null,null,null,null,null,null,null,null,{"$f":"K67*(K66/$S$66)","v":1.3402711806148047},{"$f":"L67*(L66/$S$66)","v":1.1260489427754119},0.62697792603313007,0.99031559663898572,1.0318384248399213,1.1557864702864127,0.39025982552671262,0.88824194278941437,1.0000000000000002]
["Expected Return from CAPM",null,null,null,null,null,null,null,null,null,{"$f":"$U$1+K68*$U$2","v":0.10639545729504386},{"$f":"$U$1+L68*$U$2","v":9.4184789738198479E-2},6.5737741783888415E-2,8.6447989008422182E-2,8.8814790215875516E-2,9.5879828806325521E-2,5.2244810055022614E-2,8.0629790738996621E-2,{"$f":"$U$1+S68*$U$2","v":8.7000000000000022E-2}]
[]
[{"$f":"startDate","v":"2020-01-01"}]
[{"$f":"endDate","v":"2025-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":"NFLX"},{"$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":"NFLX"},{"$f":"CORREL(_1,_1)","v":0.99999999999999978},{"$f":"TRANSPOSE(C5:C11)","v":0.42616293999052335},-3.3040393108453574E-2,0.35359494748833131,0.32761669752475753,0.17512300815481574,0.22496785936628474,-1.1120206671306235E-2,null,{"$f":"B4","v":"NFLX"},{"$f":"Returns!K66","v":0.46248645891055312},{"$f":"Returns!K69","v":0.10639545729504386}]
[{"$f":"D2","v":"_2"},{"$f":"D3","v":"JPM"},{"$f":"CORREL(_2,_1)","v":0.42616293999052335},{"$f":"CORREL(_2,_2)","v":0.99999999999999989},{"$f":"TRANSPOSE(D6:D11)","v":0.47579903571230986},0.64462354424239154,0.52088457448921666,0.59373789373478381,7.0418201644190992E-2,0.58033366220855642,null,{"$f":"B5","v":"JPM"},{"$f":"Returns!L66","v":0.27918197224417507},{"$f":"Returns!L69","v":9.4184789738198479E-2}]
[{"$f":"E2","v":"_3"},{"$f":"E3","v":"KO"},{"$f":"CORREL(_3,_1)","v":-3.3040393108453574E-2},{"$f":"CORREL(_3,_2)","v":0.47579903571230986},{"$f":"CORREL(_3,_3)","v":0.99999999999999989},{"$f":"TRANSPOSE(E7:E11)","v":0.38295212231265496},0.4346403215431594,0.35829885809776996,0.11047087830064492,0.44143069607617141,null,"KO",{"$f":"Returns!M66","v":0.19182571346845642},{"$f":"Returns!M69","v":6.5737741783888415E-2}]
[{"$f":"F2","v":"_4"},{"$f":"F3","v":"GRMN"},{"$f":"CORREL(_4,_1)","v":0.35359494748833131},{"$f":"CORREL(_4,_2)","v":0.64462354424239154},{"$f":"CORREL(_4,_3)","v":0.38295212231265496},{"$f":"CORREL(_4,_4)","v":1},{"$f":"TRANSPOSE(F8:F11)","v":0.44531592812068338},0.49033427024775145,0.1446756818068653,0.24912584904802795,null,"GRMN",{"$f":"Returns!N66","v":0.25972900125114406},{"$f":"Returns!N69","v":8.6447989008422182E-2}]
[{"$f":"G2","v":"_5"},{"$f":"G3","v":"HD"},{"$f":"CORREL(_5,_1)","v":0.32761669752475753},{"$f":"CORREL(_5,_2)","v":0.52088457448921666},{"$f":"CORREL(_5,_3)","v":0.4346403215431594},{"$f":"CORREL(_5,_4)","v":0.44531592812068338},{"$f":"CORREL(_5,_5)","v":1.0000000000000002},{"$f":"TRANSPOSE(G9:G11)","v":0.36582557524765641},5.6309015755183663E-2,0.29167922940600732,null,"HD",{"$f":"Returns!O66","v":0.25796642682700005},{"$f":"Returns!O69","v":8.8814790215875516E-2}]
[{"$f":"H2","v":"_6"},{"$f":"H3","v":"LUV"},{"$f":"CORREL(_6,_1)","v":0.17512300815481574},{"$f":"CORREL(_6,_2)","v":0.59373789373478381},{"$f":"CORREL(_6,_3)","v":0.35829885809776996},{"$f":"CORREL(_6,_4)","v":0.49033427024775145},{"$f":"CORREL(_6,_5)","v":0.36582557524765641},{"$f":"CORREL(_6,_6)","v":1.0000000000000002},{"$f":"TRANSPOSE(H10:H11)","v":-7.4671708484449614E-3},0.38972817660185632,null,"LUV",{"$f":"Returns!P66","v":0.38285807816015299},{"$f":"Returns!P69","v":9.5879828806325521E-2}]
[{"$f":"I2","v":"_7"},{"$f":"I3","v":"LLY"},{"$f":"CORREL(_7,_1)","v":0.22496785936628474},{"$f":"CORREL(_7,_2)","v":7.0418201644190992E-2},{"$f":"CORREL(_7,_3)","v":0.11047087830064492},{"$f":"CORREL(_7,_4)","v":0.1446756818068653},{"$f":"CORREL(_7,_5)","v":5.6309015755183663E-2},{"$f":"CORREL(_7,_6)","v":-7.4671708484449614E-3},{"$f":"CORREL(_7,_7)","v":0.99999999999999989},{"$f":"TRANSPOSE(I11)","v":0.16172084955538787},null,"LLY",{"$f":"Returns!Q66","v":0.3003865752015466},{"$f":"Returns!Q69","v":5.2244810055022614E-2}]
[{"$f":"J2","v":"_8"},{"$f":"J3","v":"XOM"},{"$f":"CORREL(_8,_1)","v":-1.1120206671306235E-2},{"$f":"CORREL(_8,_2)","v":0.58033366220855642},{"$f":"CORREL(_8,_3)","v":0.44143069607617141},{"$f":"CORREL(_8,_4)","v":0.24912584904802795},{"$f":"CORREL(_8,_5)","v":0.29167922940600732},{"$f":"CORREL(_8,_6)","v":0.38972817660185632},{"$f":"CORREL(_8,_7)","v":0.16172084955538787},{"$f":"CORREL(_8,_8)","v":1},null,"XOM",{"$f":"Returns!R66","v":0.33279308593277135},{"$f":"Returns!R69","v":8.0629790738996621E-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":"NFLX"},{"$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":"NFLX"},{"$f":"'Correlation Matrix'!C4*'Correlation Matrix'!$M$4*'Correlation Matrix'!M4","v":0.21389372467562268},{"$f":"'Correlation Matrix'!D4*'Correlation Matrix'!$M$5*'Correlation Matrix'!M4","v":5.5025256085482109E-2},{"$f":"'Correlation Matrix'!E4*'Correlation Matrix'!$M$6*'Correlation Matrix'!M4","v":-2.9312377804706241E-3},{"$f":"'Correlation Matrix'!F4*'Correlation Matrix'!$M$7*'Correlation Matrix'!M4","v":4.247423033509759E-2},{"$f":"'Correlation Matrix'!G4*'Correlation Matrix'!$M$8*'Correlation Matrix'!M4","v":3.9086630920455064E-2},{"$f":"'Correlation Matrix'!H4*'Correlation Matrix'!$M$9*'Correlation Matrix'!M4","v":3.1008449091074721E-2},{"$f":"'Correlation Matrix'!I4*'Correlation Matrix'!$M$10*'Correlation Matrix'!M4","v":3.1253597651926153E-2},{"$f":"'Correlation Matrix'!J4*'Correlation Matrix'!$M$11*'Correlation Matrix'!M4","v":-1.7115365392513784E-3}]
[null,{"$f":"D2","v":"JPM"},{"$f":"'Correlation Matrix'!C5*'Correlation Matrix'!$M$4*'Correlation Matrix'!M5","v":5.5025256085482109E-2},{"$f":"'Correlation Matrix'!D5*'Correlation Matrix'!$M$5*'Correlation Matrix'!M5","v":7.794257362614733E-2},{"$f":"'Correlation Matrix'!E5*'Correlation Matrix'!$M$6*'Correlation Matrix'!M5","v":2.5481075264379781E-2},{"$f":"'Correlation Matrix'!F5*'Correlation Matrix'!$M$7*'Correlation Matrix'!M5","v":4.6742719927856148E-2},{"$f":"'Correlation Matrix'!G5*'Correlation Matrix'!$M$8*'Correlation Matrix'!M5","v":3.7513886102948736E-2},{"$f":"'Correlation Matrix'!H5*'Correlation Matrix'!$M$9*'Correlation Matrix'!M5","v":6.3462905798521665E-2},{"$f":"'Correlation Matrix'!I5*'Correlation Matrix'!$M$10*'Correlation Matrix'!M5","v":5.9054475973173478E-3},{"$f":"'Correlation Matrix'!J5*'Correlation Matrix'!$M$11*'Correlation Matrix'!M5","v":5.3918701945464144E-2}]
[null,{"$f":"E2","v":"KO"},{"$f":"'Correlation Matrix'!C6*'Correlation Matrix'!$M$4*'Correlation Matrix'!M6","v":-2.9312377804706245E-3},{"$f":"'Correlation Matrix'!D6*'Correlation Matrix'!$M$5*'Correlation Matrix'!M6","v":2.5481075264379777E-2},{"$f":"'Correlation Matrix'!E6*'Correlation Matrix'!$M$6*'Correlation Matrix'!M6","v":3.6797104347682338E-2},{"$f":"'Correlation Matrix'!F6*'Correlation Matrix'!$M$7*'Correlation Matrix'!M6","v":1.9079709077131583E-2},{"$f":"'Correlation Matrix'!G6*'Correlation Matrix'!$M$8*'Correlation Matrix'!M6","v":2.150799979413091E-2},{"$f":"'Correlation Matrix'!H6*'Correlation Matrix'!$M$9*'Correlation Matrix'!M6","v":2.6314193335672646E-2},{"$f":"'Correlation Matrix'!I6*'Correlation Matrix'!$M$10*'Correlation Matrix'!M6","v":6.3655384892859646E-3},{"$f":"'Correlation Matrix'!J6*'Correlation Matrix'!$M$11*'Correlation Matrix'!M6","v":2.8180172468464961E-2}]
[null,{"$f":"F2","v":"GRMN"},{"$f":"'Correlation Matrix'!C7*'Correlation Matrix'!$M$4*'Correlation Matrix'!M7","v":4.2474230335097597E-2},{"$f":"'Correlation Matrix'!D7*'Correlation Matrix'!$M$5*'Correlation Matrix'!M7","v":4.6742719927856148E-2},{"$f":"'Correlation Matrix'!E7*'Correlation Matrix'!$M$6*'Correlation Matrix'!M7","v":1.9079709077131583E-2},{"$f":"'Correlation Matrix'!F7*'Correlation Matrix'!$M$7*'Correlation Matrix'!M7","v":6.7459154090916795E-2},{"$f":"'Correlation Matrix'!G7*'Correlation Matrix'!$M$8*'Correlation Matrix'!M7","v":2.9836773880770891E-2},{"$f":"'Correlation Matrix'!H7*'Correlation Matrix'!$M$9*'Correlation Matrix'!M7","v":4.875851928303087E-2},{"$f":"'Correlation Matrix'!I7*'Correlation Matrix'!$M$10*'Correlation Matrix'!M7","v":1.1287467233903123E-2},{"$f":"'Correlation Matrix'!J7*'Correlation Matrix'!$M$11*'Correlation Matrix'!M7","v":2.1533445832626473E-2}]
[null,{"$f":"G2","v":"HD"},{"$f":"'Correlation Matrix'!C8*'Correlation Matrix'!$M$4*'Correlation Matrix'!M8","v":3.9086630920455064E-2},{"$f":"'Correlation Matrix'!D8*'Correlation Matrix'!$M$5*'Correlation Matrix'!M8","v":3.7513886102948736E-2},{"$f":"'Correlation Matrix'!E8*'Correlation Matrix'!$M$6*'Correlation Matrix'!M8","v":2.1507999794130914E-2},{"$f":"'Correlation Matrix'!F8*'Correlation Matrix'!$M$7*'Correlation Matrix'!M8","v":2.9836773880770887E-2},{"$f":"'Correlation Matrix'!G8*'Correlation Matrix'!$M$8*'Correlation Matrix'!M8","v":6.6546677369889992E-2},{"$f":"'Correlation Matrix'!H8*'Correlation Matrix'!$M$9*'Correlation Matrix'!M8","v":3.6130591149410481E-2},{"$f":"'Correlation Matrix'!I8*'Correlation Matrix'!$M$10*'Correlation Matrix'!M8","v":4.3633660055748006E-3},{"$f":"'Correlation Matrix'!J8*'Correlation Matrix'!$M$11*'Correlation Matrix'!M8","v":2.5040499452330375E-2}]
[null,{"$f":"H2","v":"LUV"},{"$f":"'Correlation Matrix'!C9*'Correlation Matrix'!$M$4*'Correlation Matrix'!M9","v":3.1008449091074718E-2},{"$f":"'Correlation Matrix'!D9*'Correlation Matrix'!$M$5*'Correlation Matrix'!M9","v":6.3462905798521665E-2},{"$f":"'Correlation Matrix'!E9*'Correlation Matrix'!$M$6*'Correlation Matrix'!M9","v":2.6314193335672642E-2},{"$f":"'Correlation Matrix'!F9*'Correlation Matrix'!$M$7*'Correlation Matrix'!M9","v":4.875851928303087E-2},{"$f":"'Correlation Matrix'!G9*'Correlation Matrix'!$M$8*'Correlation Matrix'!M9","v":3.6130591149410481E-2},{"$f":"'Correlation Matrix'!H9*'Correlation Matrix'!$M$9*'Correlation Matrix'!M9","v":0.14658030801248587},{"$f":"'Correlation Matrix'!I9*'Correlation Matrix'!$M$10*'Correlation Matrix'!M9","v":-8.5876517106189029E-4},{"$f":"'Correlation Matrix'!J9*'Correlation Matrix'!$M$11*'Correlation Matrix'!M9","v":4.9656249604523688E-2}]
[null,{"$f":"I2","v":"LLY"},{"$f":"'Correlation Matrix'!C10*'Correlation Matrix'!$M$4*'Correlation Matrix'!M10","v":3.1253597651926153E-2},{"$f":"'Correlation Matrix'!D10*'Correlation Matrix'!$M$5*'Correlation Matrix'!M10","v":5.9054475973173478E-3},{"$f":"'Correlation Matrix'!E10*'Correlation Matrix'!$M$6*'Correlation Matrix'!M10","v":6.3655384892859655E-3},{"$f":"'Correlation Matrix'!F10*'Correlation Matrix'!$M$7*'Correlation Matrix'!M10","v":1.1287467233903123E-2},{"$f":"'Correlation Matrix'!G10*'Correlation Matrix'!$M$8*'Correlation Matrix'!M10","v":4.3633660055748015E-3},{"$f":"'Correlation Matrix'!H10*'Correlation Matrix'!$M$9*'Correlation Matrix'!M10","v":-8.5876517106189018E-4},{"$f":"'Correlation Matrix'!I10*'Correlation Matrix'!$M$10*'Correlation Matrix'!M10","v":9.0232094561314397E-2},{"$f":"'Correlation Matrix'!J10*'Correlation Matrix'!$M$11*'Correlation Matrix'!M10","v":1.61666794901732E-2}]
[null,{"$f":"J2","v":"XOM"},{"$f":"'Correlation Matrix'!C11*'Correlation Matrix'!$M$4*'Correlation Matrix'!M11","v":-1.7115365392513782E-3},{"$f":"'Correlation Matrix'!D11*'Correlation Matrix'!$M$5*'Correlation Matrix'!M11","v":5.3918701945464144E-2},{"$f":"'Correlation Matrix'!E11*'Correlation Matrix'!$M$6*'Correlation Matrix'!M11","v":2.8180172468464958E-2},{"$f":"'Correlation Matrix'!F11*'Correlation Matrix'!$M$7*'Correlation Matrix'!M11","v":2.1533445832626473E-2},{"$f":"'Correlation Matrix'!G11*'Correlation Matrix'!$M$8*'Correlation Matrix'!M11","v":2.5040499452330375E-2},{"$f":"'Correlation Matrix'!H11*'Correlation Matrix'!$M$9*'Correlation Matrix'!M11","v":4.9656249604523688E-2},{"$f":"'Correlation Matrix'!I11*'Correlation Matrix'!$M$10*'Correlation Matrix'!M11","v":1.61666794901732E-2},{"$f":"'Correlation Matrix'!J11*'Correlation Matrix'!$M$11*'Correlation Matrix'!M11","v":0.11075123804465693}]
[]
[null,null,null,"Weighted Var/Cov Matrix"]
[null,null,{"$f":"C2","v":"NFLX"},{"$f":"D2","v":"JPM"},"KO","GRMN","HD","LUV","LLY","XOM"]
[null,"Weights",{"$f":"B15","v":7.4504632238481944E-2},{"$f":"B16","v":-0.1116283656777549},{"$f":"B17","v":0.52888670283204864},{"$f":"B18","v":0.13565581849199659},{"$f":"B19","v":0.1167653390243609},{"$f":"B20","v":1.3420269838044199E-2},{"$f":"B21","v":0.18458870959435456},{"$f":"B22","v":5.7806910807915106E-2}]
[{"$f":"B3","v":"NFLX"},7.4504632238481944E-2,{"$f":"C3*$B$15*C14","v":1.1873112801751588E-3},{"$f":"D3*B15*$D$14","v":-4.576357188490253E-4},{"$f":"E3*B15*$E$14","v":-1.1550398635270654E-4},{"$f":"F3*B15*$F$14","v":4.2928648821489459E-4},{"$f":"G3*B15*$G$14","v":3.4003643781898283E-4},{"$f":"H3*B15*$H$14","v":3.1004488345427298E-5},{"$f":"I3*B15*$I$14","v":4.2982178759346651E-4},{"$f":"J3*B15*$J$14","v":-7.3713869925157928E-6}]
[{"$f":"B4","v":"JPM"},-0.1116283656777549,{"$f":"C4*B16*$C$14","v":-4.5763571884902535E-4},9.7123399401925087E-4,-1.5043710428873423E-3,-7.078267519758176E-4,-4.8896814458060812E-4,-9.5072686915128769E-5,-1.2168373182302092E-4,-3.4793150534916144E-4]
["KO",0.52888670283204864,{"$f":"C5*B17*$C$14","v":-1.1550398635270655E-4},-1.5043710428873421E-3,1.0292928139937877E-2,1.3689034646524449E-3,1.3282401883434193E-3,1.8677294107957314E-4,6.2144533242514198E-4,8.6156104892061945E-4]
["GRMN",0.13565581849199659,4.292864882148947E-4,-7.078267519758176E-4,1.3689034646524449E-3,1.2414171567380573E-3,4.7261144408510593E-4,8.8766722027431032E-5,2.8264418993719274E-4,1.6886191869826619E-4]
["HD",0.1167653390243609,3.4003643781898283E-4,-4.8896814458060812E-4,1.3282401883434195E-3,4.7261144408510583E-4,9.0730700843319131E-4,5.6617444118564587E-5,9.4046085209599942E-5,1.6901945342755241E-4]
["LUV",1.3420269838044199E-2,3.1004488345427298E-5,-9.5072686915128755E-5,1.8677294107957311E-4,8.8766722027431045E-5,5.6617444118564594E-5,2.6399647395619836E-5,-2.1273590953081579E-6,3.8522540903087953E-5]
["LLY",0.18458870959435456,4.2982178759346651E-4,-1.2168373182302092E-4,6.2144533242514208E-4,2.8264418993719274E-4,9.4046085209599956E-5,-2.1273590953081575E-6,3.0744774099373401E-3,1.7250660315858133E-4]
["XOM",5.7806910807915106E-2,-7.3713869925157902E-6,-3.479315053491615E-4,8.6156104892061935E-4,1.6886191869826619E-4,1.6901945342755241E-4,3.8522540903087953E-5,1.7250660315858133E-4,3.7009064938806497E-4]
["Sum",{"$f":"SUM(B15:B22)","v":1.0000000171494472}]
[]
["Port. Var",{"$f":"SUM(C15:J22)","v":2.4655517814301999E-2}]
["Port. S.D.",{"$f":"SQRT(B25)","v":0.15702075599837748}]
["Port. E(R.)",{"$f":"SUMPRODUCT('Correlation Matrix'!N4:N11,B15:B22)","v":6.9870233934373652E-2}]
[]
["Sharpe",{"$f":"(B27-Returns!U1)/'Covar Matrix'!B26","v":0.25391696582320389}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["$b$17",{"$f":"IF(ISBLANK(A1048500)=TRUE,\"\",INDIRECT(A1048500))","v":0.52888670283204864},"this is foreign investments"]
["$b$18",{"$f":"IF(ISBLANK(A1048501)=TRUE,\"\",INDIRECT(A1048501))","v":0.13565581849199659}]
["$b$19",{"$f":"IF(ISBLANK(A1048502)=TRUE,\"\",INDIRECT(A1048502))","v":0.1167653390243609}]
["$b$22",5.7806910807915106E-2]
["$b$20",1.3420269838044199E-2]
["$b$21",0.18458870959435456]
[null,{"$f":"SUM(B1048500:B1048505)","v":1.0371237505887201}]
["$b$16",{"$f":"IF(ISBLANK(A1048507)=TRUE,\"\",INDIRECT(A1048507))","v":-0.1116283656777549},"this is fixed income"]
["$b$17",{"$f":"IF(ISBLANK(A1048508)=TRUE,\"\",INDIRECT(A1048508))","v":0.52888670283204864}]
["$b$18",{"$f":"IF(ISBLANK(A1048509)=TRUE,\"\",INDIRECT(A1048509))","v":0.13565581849199659}]
["$b$19",0.1167653390243609]
["$b$20",1.3420269838044199E-2]
[null,{"$f":"SUM(B1048507:B1048511)","v":0.68309976450869547}]
[]
[]
[]
[]
["$b$15",{"$f":"IF(ISBLANK(A1048517)=TRUE,\"\",INDIRECT(A1048517))","v":7.4504632238481944E-2},"this is real estate"]
["$b$22",{"$f":"IF(ISBLANK(A1048518)=TRUE,\"\",INDIRECT(A1048518))","v":5.7806910807915106E-2}]
[]
[]
[]
[null,{"$f":"SUM(B1048517:B1048521)","v":0.13231154304639706}]
[]
[]
["$b$16",{"$f":"IF(ISBLANK(A1048525)=TRUE,\"\",INDIRECT(A1048525))","v":-0.1116283656777549},"This is for commodities"]
["$b$18",{"$f":"IF(ISBLANK(A1048526)=TRUE,\"\",INDIRECT(A1048526))","v":0.13565581849199659}]
["$b$20",{"$f":"IF(ISBLANK(A1048527)=TRUE,\"\",INDIRECT(A1048527))","v":1.3420269838044199E-2}]
[]
[]
[null,{"$f":"SUM(B1048525:B1048529)","v":3.7447722652285895E-2}]

{"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":"NFLX"},{"$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"}]
[2.0000005492891441E-2,0.37839924915308926,-0.17062549220704287,-0.44983863484055336,1.5479542338295034,-6.6218802809090094E-2,-0.34247000952771645,-0.14078889948650053,0.76619062824760564,-0.14420302320620629]
[3.0000004588481986E-2,0.31688539878398259,-0.12147188488814119,-0.38202068408129047,1.3436103620786506,-2.5738774659586117E-2,-0.25038391856357051,-0.10986675854004337,0.64956757265602028,-0.10369591400203976]
[4.0000003684072763E-2,0.25918829225266132,-7.2318240548029808E-2,-0.31420271205757422,1.1392665876643417,1.4741206169187874E-2,-0.1582978653320605,-7.8944663549854507E-2,0.53294446448653165,-6.3188776832541774E-2]
[5.000000277966371E-2,0.20850092660399874,-2.3164611998109489E-2,-0.24638471750816832,0.93492274256372931,5.5221173800003451E-2,-6.6211764540492338E-2,-4.8022633298405365E-2,0.41632136605377479,-2.2681555072332143E-2]
[6.0000001875254477E-2,0.17116819980390047,2.5988973777304088E-2,-0.17856665677116906,0.7305789331228687,9.5701178442029994E-2,2.587429772333252E-2,-1.7100546743137063E-2,0.29969826841851582,1.7825552030254963E-2]
[7.0000000970850781E-2,0.15702330887514121,7.5145034756740961E-2,-0.11075211346460276,0.52623915657291975,0.13618068514775683,0.11795848716119305,1.3821502151950294E-2,0.18307295968470225,5.8334287989339685E-2]
[8.0000000066436316E-2,0.1718893164492607,0.12429617845737355,-4.2930394212916084E-2,0.32189124905009309,0.17666113931614061,0.21004639988456358,4.4743596312101154E-2,6.6452172276117216E-2,9.8839658916527032E-2]
[9.0000082953913096E-2,0.20968444420231672,0.17345014347894674,2.4888079634559895E-2,0.11754558059091488,0.21714163769275827,0.30213337100814608,7.5665858096947008E-2,-5.0171903063943875E-2,0.13934723256167103]
[9.9999998257606415E-2,0.2606160476575996,0.22260331854275944,9.2705573836620966E-2,-8.679656543447628E-2,0.25762143305539004,0.39421855544011924,0.10658765261156278,-0.16679401770467081,0.17985404965269455]
[0.11000008114509856,0.3184434242014263,0.27175745049080713,0.16052407716595815,-0.29114250195831926,0.29810187544261146,0.4863054191924388,0.1375097933918161,-0.28341789425300101,0.22036178052768873]
[0.12000008024068951,0.38003067582595113,0.32091102539391825,0.22834205994556434,-0.4954863282147694,0.33858205231491573,0.5783913692705549,0.16843203980447219,-0.40004094132507317,0.26086872281041712]
[0.13000007933628074,0.44381557588241882,0.37006452050263411,0.29616029823544904,-0.69982990920312371,0.37906214031272956,0.67047736345935116,0.19935402093835672,-0.51666421551070107,0.30137578126530451]
[6.9870233934373652E-2,0.15702075599837748,7.4504632238481944E-2,-0.1116283656777549,0.52888670283204864,0.13565581849199659,0.1167653390243609,1.3420269838044199E-2,0.18458870959435456,5.7806910807915106E-2,"MVP"]
[8.284555429430325E-2,0.18077438903831539,0.13828294214749559,-2.3632173461660671E-2,0.26374368531943021,0.18818027821261105,0.23624976667953265,5.3542577132923111E-2,3.3266607844451582E-2,0.1103663239933905,"MVE"]