{"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":"2024-10-04"}]
["Start date  ",{"$f":"DATE(YEAR(B4)-5, MONTH(B4)-1,1)","v":"2019-09-01"}]
["End date  ",{"$f":"DATE(YEAR(B4), MONTH(B4)-1, 28)","v":"2024-09-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":"2019-09-01"},{"$f":"_xlfn.STOCKHISTORY(B2,$A$71,$A$72,2,0,1)","v":267.62},{"$f":"_xlfn.STOCKHISTORY(C2,$A$71,$A$72,2,0,1)","v":117.69},{"$f":"_xlfn.STOCKHISTORY(D2,$A$71,$A$72,2,0,1)","v":54.44},{"$f":"_xlfn.STOCKHISTORY(E2,$A$71,$A$72,2,0,1)","v":84.69},{"$f":"_xlfn.STOCKHISTORY(F2,$A$71,$A$72,2,0,1)","v":232.02},{"$f":"_xlfn.STOCKHISTORY(G2,$A$71,$A$72,2,0,1)","v":54.01},{"$f":"_xlfn.STOCKHISTORY(H2,$A$71,$A$72,2,0,1)","v":111.83},{"$f":"_xlfn.STOCKHISTORY(I2,$A$71,$A$72,2,0,1)","v":70.61},{"$f":"_xlfn.STOCKHISTORY(J2,$A$71,$A$72,2,0,1)","v":298.52},"_1","_2","_3","_4","_5","_6","_7","_8"]
[{"$f":"EDATE(A3,1)","v":"2019-10-01"},287.41000000000003,124.92,54.43,93.75,234.58,56.13,113.95,67.569999999999993,304.97000000000003,{"$f":"LN(B4/B3)","v":7.1341703873963769E-2},{"$f":"LN(C4/C3)","v":5.9619483525306972E-2},{"$f":"LN(D4/D3)","v":-1.8370533715667776E-4},{"$f":"LN(E4/E3)","v":0.1016341339170125},{"$f":"LN(F4/F3)","v":1.0973106246098343E-2},{"$f":"LN(G4/G3)","v":3.8501214349308199E-2},{"$f":"LN(H4/H3)","v":1.8779894651596275E-2},{"$f":"LN(I4/I3)","v":-4.4007679964172326E-2},{"$f":"LN(J4/J3)","v":2.137647885076082E-2}]
[{"$f":"EDATE(A4,1)","v":"2019-11-01"},314.66000000000003,131.76,53.4,97.69,220.51,57.64,117.35,68.13,316.06,{"$f":"LN(B5/B4)","v":9.0582923061470685E-2},5.3308553454506913E-2,-1.9104726479959561E-2,4.1167534814330969E-2,-6.1853635760882542E-2,2.6546342177213279E-2,2.9401166605339254E-2,8.2535472214936567E-3,3.5718657867010194E-2]
["2019-12-01",323.57,139.4,55.35,97.56,218.38,53.98,131.43,69.78,323.24,2.7922783028760001E-2,5.6365412457038841E-2,3.586591318849687E-2,-1.331626317131589E-3,-9.706380746556378E-3,-6.560316354146277E-2,0.11331346819688444,2.3929790973051264E-2,2.2463012384289299E-2]
["2020-01-01",345.09,132.36000000000001,58.4,96.95,228.1,54.98,139.63999999999999,62.12,323.24,6.4389778734991132E-2,-5.1822015273012015E-2,5.3639230679535389E-2,-6.2721916590586929E-3,4.354746470442216E-2,1.8355875147241109E-2,6.0593291742918359E-2,-0.11627943747814183,0]
["2020-02-01",369.03,116.11,53.49,88.39,217.84,46.19,126.13,51.44,295.91000000000003,6.7072688972774741E-2,-0.1309874654144968,-8.782116929102253E-2,-9.2436540615804225E-2,-4.6023280924838178E-2,-0.17420615829458558,-0.10175456113773343,-0.18865191835112236,-8.8339727329046339E-2]
["2020-03-01",375.5,90.03,44.25,74.959999999999994,186.71,35.61,138.72,37.97,258.39999999999998,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,{"$f":"LN(B63/B62)","v":1.1229222927252454E-2},{"$f":"LN(C63/C62)","v":-6.4016711870732407E-2},-8.4529014358173393E-3,-4.0415162925875582E-2,9.4940060745136987E-2,2.4253964294909849E-2,-8.0304889356525633E-2,-6.123509524074853E-3,1.7611970045769861E-2]
[]
["Monthly Standard Deviation",null,null,null,null,null,null,null,null,null,{"$f":"STDEV(K4:K63)","v":0.13239235989361894},{"$f":"STDEV(L4:L63)","v":7.8971910116795163E-2},5.4239936731785156E-2,7.4041656556725358E-2,7.2789667584483034E-2,0.10995432449095216,8.5583706642531843E-2,9.6776683996229226E-2,5.2711742863526583E-2]
["Annualized Standard Deviation",null,null,null,null,null,null,null,null,null,{"$f":"K65*SQRT(12)","v":0.45862058773938424},{"$f":"L65*SQRT(12)","v":0.27356672138610372},0.18789265243754658,0.2564878220656272,0.25215080504474791,0.38089295306048809,0.2964706564098703,0.33524426733901375,0.18259883359026843]
["Correlation with S&P",null,null,null,null,null,null,null,null,null,{"$f":"CORREL(K4:K63,$S$4:$S$63)","v":0.53154611601356849},{"$f":"CORREL(L4:L63,$S$4:$S$63)","v":0.74671346815134254},0.60270812939628771,0.71525809446110222,0.71114133609867114,0.56925111064305023,0.24260841359075205,0.48375115006121955,1.0000000000000002]
["Beta",null,null,null,null,null,null,null,null,null,{"$f":"K67*(K66/$S$66)","v":1.3350468200894456},{"$f":"L67*(L66/$S$66)","v":1.1187144587975966},0.62018155785183426,1.0046887335260393,0.9820153659920976,1.1874322102863071,0.39390325892881745,0.88814806035717153,1.0000000000000002]
["Expected Return from CAPM",null,null,null,null,null,null,null,null,null,{"$f":"$U$1+K68*$U$2","v":0.10609766874509841},{"$f":"$U$1+L68*$U$2","v":9.3766724151463005E-2},6.5350348797554553E-2,8.7267257810984239E-2,8.597487586154956E-2,9.7683635986319503E-2,5.2452485758942596E-2,8.0624439440358769E-2,{"$f":"$U$1+S68*$U$2","v":8.7000000000000022E-2}]
[]
[{"$f":"startDate","v":"2019-09-01"}]
[{"$f":"endDate","v":"2024-09-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":1},{"$f":"TRANSPOSE(C5:C11)","v":0.40319570778204772},-1.713214430324346E-2,0.34350563814801377,0.30678154438227567,0.17891589778536027,0.2515868037864919,-2.2121992544913462E-2,null,{"$f":"B4","v":"NFLX"},{"$f":"Returns!K66","v":0.45862058773938424},{"$f":"Returns!K69","v":0.10609766874509841}]
[{"$f":"D2","v":"_2"},{"$f":"D3","v":"JPM"},{"$f":"CORREL(_2,_1)","v":0.40319570778204772},{"$f":"CORREL(_2,_2)","v":1.0000000000000002},{"$f":"TRANSPOSE(D6:D11)","v":0.49702925265245662},0.63801614346584379,0.47630476894408136,0.61141171047656251,9.3313405348368239E-2,0.59368404051150236,null,{"$f":"B5","v":"JPM"},{"$f":"Returns!L66","v":0.27356672138610372},{"$f":"Returns!L69","v":9.3766724151463005E-2}]
[{"$f":"E2","v":"_3"},{"$f":"E3","v":"KO"},{"$f":"CORREL(_3,_1)","v":-1.713214430324346E-2},{"$f":"CORREL(_3,_2)","v":0.49702925265245662},{"$f":"CORREL(_3,_3)","v":1},{"$f":"TRANSPOSE(E7:E11)","v":0.42761392152242372},0.43835422262048346,0.3876798653458437,8.0437494318989805E-2,0.41569643969080522,null,"KO",{"$f":"Returns!M66","v":0.18789265243754658},{"$f":"Returns!M69","v":6.5350348797554553E-2}]
[{"$f":"F2","v":"_4"},{"$f":"F3","v":"GRMN"},{"$f":"CORREL(_4,_1)","v":0.34350563814801377},{"$f":"CORREL(_4,_2)","v":0.63801614346584379},{"$f":"CORREL(_4,_3)","v":0.42761392152242372},{"$f":"CORREL(_4,_4)","v":1},{"$f":"TRANSPOSE(F8:F11)","v":0.43387519097502414},0.50348210005692251,0.17099468649777474,0.23834150630227358,null,"GRMN",{"$f":"Returns!N66","v":0.2564878220656272},{"$f":"Returns!N69","v":8.7267257810984239E-2}]
[{"$f":"G2","v":"_5"},{"$f":"G3","v":"HD"},{"$f":"CORREL(_5,_1)","v":0.30678154438227567},{"$f":"CORREL(_5,_2)","v":0.47630476894408136},{"$f":"CORREL(_5,_3)","v":0.43835422262048346},{"$f":"CORREL(_5,_4)","v":0.43387519097502414},{"$f":"CORREL(_5,_5)","v":1},{"$f":"TRANSPOSE(G9:G11)","v":0.38687509817957921},4.2126125018849277E-2,0.25943841597675826,null,"HD",{"$f":"Returns!O66","v":0.25215080504474791},{"$f":"Returns!O69","v":8.597487586154956E-2}]
[{"$f":"H2","v":"_6"},{"$f":"H3","v":"LUV"},{"$f":"CORREL(_6,_1)","v":0.17891589778536027},{"$f":"CORREL(_6,_2)","v":0.61141171047656251},{"$f":"CORREL(_6,_3)","v":0.3876798653458437},{"$f":"CORREL(_6,_4)","v":0.50348210005692251},{"$f":"CORREL(_6,_5)","v":0.38687509817957921},{"$f":"CORREL(_6,_6)","v":0.99999999999999989},{"$f":"TRANSPOSE(H10:H11)","v":8.4029489305418887E-3},0.38421873185687716,null,"LUV",{"$f":"Returns!P66","v":0.38089295306048809},{"$f":"Returns!P69","v":9.7683635986319503E-2}]
[{"$f":"I2","v":"_7"},{"$f":"I3","v":"LLY"},{"$f":"CORREL(_7,_1)","v":0.2515868037864919},{"$f":"CORREL(_7,_2)","v":9.3313405348368239E-2},{"$f":"CORREL(_7,_3)","v":8.0437494318989805E-2},{"$f":"CORREL(_7,_4)","v":0.17099468649777474},{"$f":"CORREL(_7,_5)","v":4.2126125018849277E-2},{"$f":"CORREL(_7,_6)","v":8.4029489305418887E-3},{"$f":"CORREL(_7,_7)","v":1},{"$f":"TRANSPOSE(I11)","v":0.14478846267092627},null,"LLY",{"$f":"Returns!Q66","v":0.2964706564098703},{"$f":"Returns!Q69","v":5.2452485758942596E-2}]
[{"$f":"J2","v":"_8"},{"$f":"J3","v":"XOM"},{"$f":"CORREL(_8,_1)","v":-2.2121992544913462E-2},{"$f":"CORREL(_8,_2)","v":0.59368404051150236},{"$f":"CORREL(_8,_3)","v":0.41569643969080522},{"$f":"CORREL(_8,_4)","v":0.23834150630227358},{"$f":"CORREL(_8,_5)","v":0.25943841597675826},{"$f":"CORREL(_8,_6)","v":0.38421873185687716},{"$f":"CORREL(_8,_7)","v":0.14478846267092627},{"$f":"CORREL(_8,_8)","v":1.0000000000000002},null,"XOM",{"$f":"Returns!R66","v":0.33524426733901375},{"$f":"Returns!R69","v":8.0624439440358769E-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.21033284349841824},{"$f":"'Correlation Matrix'!D4*'Correlation Matrix'!$M$5*'Correlation Matrix'!M4","v":5.0586276361006474E-2},{"$f":"'Correlation Matrix'!E4*'Correlation Matrix'!$M$6*'Correlation Matrix'!M4","v":-1.4763015225034799E-3},{"$f":"'Correlation Matrix'!F4*'Correlation Matrix'!$M$7*'Correlation Matrix'!M4","v":4.0406772842941661E-2},{"$f":"'Correlation Matrix'!G4*'Correlation Matrix'!$M$8*'Correlation Matrix'!M4","v":3.5476693429105317E-2},{"$f":"'Correlation Matrix'!H4*'Correlation Matrix'!$M$9*'Correlation Matrix'!M4","v":3.1253986224911962E-2},{"$f":"'Correlation Matrix'!I4*'Correlation Matrix'!$M$10*'Correlation Matrix'!M4","v":3.4207640490471924E-2},{"$f":"'Correlation Matrix'!J4*'Correlation Matrix'!$M$11*'Correlation Matrix'!M4","v":-3.4012546486897697E-3}]
[null,{"$f":"D2","v":"JPM"},{"$f":"'Correlation Matrix'!C5*'Correlation Matrix'!$M$4*'Correlation Matrix'!M5","v":5.0586276361006474E-2},{"$f":"'Correlation Matrix'!D5*'Correlation Matrix'!$M$5*'Correlation Matrix'!M5","v":7.4838751049942115E-2},{"$f":"'Correlation Matrix'!E5*'Correlation Matrix'!$M$6*'Correlation Matrix'!M5","v":2.5547888540003241E-2},{"$f":"'Correlation Matrix'!F5*'Correlation Matrix'!$M$7*'Correlation Matrix'!M5","v":4.4767380502997646E-2},{"$f":"'Correlation Matrix'!G5*'Correlation Matrix'!$M$8*'Correlation Matrix'!M5","v":3.285553584153738E-2},{"$f":"'Correlation Matrix'!H5*'Correlation Matrix'!$M$9*'Correlation Matrix'!M5","v":6.3708877902690045E-2},{"$f":"'Correlation Matrix'!I5*'Correlation Matrix'!$M$10*'Correlation Matrix'!M5","v":7.5681375936830992E-3},{"$f":"'Correlation Matrix'!J5*'Correlation Matrix'!$M$11*'Correlation Matrix'!M5","v":5.4447757823228388E-2}]
[null,{"$f":"E2","v":"KO"},{"$f":"'Correlation Matrix'!C6*'Correlation Matrix'!$M$4*'Correlation Matrix'!M6","v":-1.4763015225034799E-3},{"$f":"'Correlation Matrix'!D6*'Correlation Matrix'!$M$5*'Correlation Matrix'!M6","v":2.5547888540003245E-2},{"$f":"'Correlation Matrix'!E6*'Correlation Matrix'!$M$6*'Correlation Matrix'!M6","v":3.5303648840016674E-2},{"$f":"'Correlation Matrix'!F6*'Correlation Matrix'!$M$7*'Correlation Matrix'!M6","v":2.0607645881692883E-2},{"$f":"'Correlation Matrix'!G6*'Correlation Matrix'!$M$8*'Correlation Matrix'!M6","v":2.0768032311003742E-2},{"$f":"'Correlation Matrix'!H6*'Correlation Matrix'!$M$9*'Correlation Matrix'!M6","v":2.7745079978467566E-2},{"$f":"'Correlation Matrix'!I6*'Correlation Matrix'!$M$10*'Correlation Matrix'!M6","v":4.4807431116375574E-3},{"$f":"'Correlation Matrix'!J6*'Correlation Matrix'!$M$11*'Correlation Matrix'!M6","v":2.6184691551575857E-2}]
[null,{"$f":"F2","v":"GRMN"},{"$f":"'Correlation Matrix'!C7*'Correlation Matrix'!$M$4*'Correlation Matrix'!M7","v":4.0406772842941661E-2},{"$f":"'Correlation Matrix'!D7*'Correlation Matrix'!$M$5*'Correlation Matrix'!M7","v":4.4767380502997646E-2},{"$f":"'Correlation Matrix'!E7*'Correlation Matrix'!$M$6*'Correlation Matrix'!M7","v":2.0607645881692883E-2},{"$f":"'Correlation Matrix'!F7*'Correlation Matrix'!$M$7*'Correlation Matrix'!M7","v":6.5786002867968846E-2},{"$f":"'Correlation Matrix'!G7*'Correlation Matrix'!$M$8*'Correlation Matrix'!M7","v":2.8060275244713665E-2},{"$f":"'Correlation Matrix'!H7*'Correlation Matrix'!$M$9*'Correlation Matrix'!M7","v":4.9187383674942027E-2},{"$f":"'Correlation Matrix'!I7*'Correlation Matrix'!$M$10*'Correlation Matrix'!M7","v":1.3002626273064829E-2},{"$f":"'Correlation Matrix'!J7*'Correlation Matrix'!$M$11*'Correlation Matrix'!M7","v":2.0494049919057639E-2}]
[null,{"$f":"G2","v":"HD"},{"$f":"'Correlation Matrix'!C8*'Correlation Matrix'!$M$4*'Correlation Matrix'!M8","v":3.5476693429105317E-2},{"$f":"'Correlation Matrix'!D8*'Correlation Matrix'!$M$5*'Correlation Matrix'!M8","v":3.285553584153738E-2},{"$f":"'Correlation Matrix'!E8*'Correlation Matrix'!$M$6*'Correlation Matrix'!M8","v":2.0768032311003739E-2},{"$f":"'Correlation Matrix'!F8*'Correlation Matrix'!$M$7*'Correlation Matrix'!M8","v":2.8060275244713662E-2},{"$f":"'Correlation Matrix'!G8*'Correlation Matrix'!$M$8*'Correlation Matrix'!M8","v":6.358002848471446E-2},{"$f":"'Correlation Matrix'!H8*'Correlation Matrix'!$M$9*'Correlation Matrix'!M8","v":3.7156437979593435E-2},{"$f":"'Correlation Matrix'!I8*'Correlation Matrix'!$M$10*'Correlation Matrix'!M8","v":3.1491517322813751E-3},{"$f":"'Correlation Matrix'!J8*'Correlation Matrix'!$M$11*'Correlation Matrix'!M8","v":2.1930877209512169E-2}]
[null,{"$f":"H2","v":"LUV"},{"$f":"'Correlation Matrix'!C9*'Correlation Matrix'!$M$4*'Correlation Matrix'!M9","v":3.1253986224911962E-2},{"$f":"'Correlation Matrix'!D9*'Correlation Matrix'!$M$5*'Correlation Matrix'!M9","v":6.3708877902690059E-2},{"$f":"'Correlation Matrix'!E9*'Correlation Matrix'!$M$6*'Correlation Matrix'!M9","v":2.774507997846757E-2},{"$f":"'Correlation Matrix'!F9*'Correlation Matrix'!$M$7*'Correlation Matrix'!M9","v":4.918738367494202E-2},{"$f":"'Correlation Matrix'!G9*'Correlation Matrix'!$M$8*'Correlation Matrix'!M9","v":3.7156437979593442E-2},{"$f":"'Correlation Matrix'!H9*'Correlation Matrix'!$M$9*'Correlation Matrix'!M9","v":0.14507944169113918},{"$f":"'Correlation Matrix'!I9*'Correlation Matrix'!$M$10*'Correlation Matrix'!M9","v":9.4889110785740312E-4},{"$f":"'Correlation Matrix'!J9*'Correlation Matrix'!$M$11*'Correlation Matrix'!M9","v":4.9061727077026683E-2}]
[null,{"$f":"I2","v":"LLY"},{"$f":"'Correlation Matrix'!C10*'Correlation Matrix'!$M$4*'Correlation Matrix'!M10","v":3.4207640490471924E-2},{"$f":"'Correlation Matrix'!D10*'Correlation Matrix'!$M$5*'Correlation Matrix'!M10","v":7.5681375936830992E-3},{"$f":"'Correlation Matrix'!E10*'Correlation Matrix'!$M$6*'Correlation Matrix'!M10","v":4.4807431116375574E-3},{"$f":"'Correlation Matrix'!F10*'Correlation Matrix'!$M$7*'Correlation Matrix'!M10","v":1.3002626273064831E-2},{"$f":"'Correlation Matrix'!G10*'Correlation Matrix'!$M$8*'Correlation Matrix'!M10","v":3.1491517322813751E-3},{"$f":"'Correlation Matrix'!H10*'Correlation Matrix'!$M$9*'Correlation Matrix'!M10","v":9.4889110785740312E-4},{"$f":"'Correlation Matrix'!I10*'Correlation Matrix'!$M$10*'Correlation Matrix'!M10","v":8.7894850112099368E-2},{"$f":"'Correlation Matrix'!J10*'Correlation Matrix'!$M$11*'Correlation Matrix'!M10","v":1.4390538045617298E-2}]
[null,{"$f":"J2","v":"XOM"},{"$f":"'Correlation Matrix'!C11*'Correlation Matrix'!$M$4*'Correlation Matrix'!M11","v":-3.4012546486897693E-3},{"$f":"'Correlation Matrix'!D11*'Correlation Matrix'!$M$5*'Correlation Matrix'!M11","v":5.4447757823228395E-2},{"$f":"'Correlation Matrix'!E11*'Correlation Matrix'!$M$6*'Correlation Matrix'!M11","v":2.6184691551575857E-2},{"$f":"'Correlation Matrix'!F11*'Correlation Matrix'!$M$7*'Correlation Matrix'!M11","v":2.0494049919057639E-2},{"$f":"'Correlation Matrix'!G11*'Correlation Matrix'!$M$8*'Correlation Matrix'!M11","v":2.1930877209512166E-2},{"$f":"'Correlation Matrix'!H11*'Correlation Matrix'!$M$9*'Correlation Matrix'!M11","v":4.9061727077026683E-2},{"$f":"'Correlation Matrix'!I11*'Correlation Matrix'!$M$10*'Correlation Matrix'!M11","v":1.4390538045617298E-2},{"$f":"'Correlation Matrix'!J11*'Correlation Matrix'!$M$11*'Correlation Matrix'!M11","v":0.11238871878367214}]
[]
[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":5.0312010707916355E-2},{"$f":"B16","v":5.4714745906043994E-4},{"$f":"B17","v":0.51916928304725207},{"$f":"B18","v":7.5024377597413094E-2},{"$f":"B19","v":0.13359694738561223},{"$f":"B20","v":-1.8402518138923008E-2},{"$f":"B21","v":0.20455879240018282},{"$f":"B22","v":3.5193921996386719E-2}]
[{"$f":"B3","v":"NFLX"},5.0312010707916355E-2,{"$f":"C3*$B$15*C14","v":5.3241519473157673E-4},{"$f":"D3*B15*$D$14","v":1.3925435086912042E-6},{"$f":"E3*B15*$E$14","v":-3.8561660882807632E-5},{"$f":"F3*B15*$F$14","v":1.5252050743483857E-4},{"$f":"G3*B15*$G$14","v":2.3845769634317279E-4},{"$f":"H3*B15*$H$14","v":-2.8937056018665924E-5},{"$f":"I3*B15*$I$14","v":3.5205696818032129E-4},{"$f":"J3*B15*$J$14","v":-6.0225233106950409E-6}]
[{"$f":"B4","v":"JPM"},5.4714745906043994E-4,{"$f":"C4*B16*$C$14","v":1.3925435086912044E-6},2.2404502493403264E-8,7.2571882498863503E-6,1.8376740004357139E-6,2.4016486700476009E-6,-6.4147774988446681E-7,8.4705489618517684E-7,1.0484604530110265E-6]
["KO",0.51916928304725207,{"$f":"C5*B17*$C$14","v":-3.8561660882807625E-5},7.2571882498863503E-6,9.5156305758900099E-3,8.0267506774909299E-4,1.4404589122113066E-3,-2.6507710862475997E-4,4.7585779326222007E-4,4.7843629526672079E-4]
["GRMN",7.5024377597413094E-2,1.5252050743483857E-4,1.8376740004357141E-6,8.0267506774909299E-4,3.7028686093079193E-4,2.8124891959757263E-4,-6.7909944933108272E-5,1.995499542045366E-4,5.411253230013813E-5]
["HD",0.13359694738561223,2.3845769634317276E-4,2.4016486700476009E-6,1.4404589122113062E-3,2.8124891959757263E-4,1.1347855262202374E-3,-9.1349855100352623E-5,8.6061373385326511E-5,1.0311461042137706E-4]
["LUV",-1.8402518138923008E-2,-2.8937056018665924E-5,-6.4147774988446681E-7,-2.6507710862475997E-4,-6.7909944933108258E-5,-9.1349855100352636E-5,4.9131540849861317E-5,-3.5720027331092244E-6,-3.1775160568433746E-5]
["LLY",0.20455879240018282,3.5205696818032129E-4,8.4705489618517684E-7,4.7585779326222001E-4,1.9954995420453666E-4,8.6061373385326511E-5,-3.5720027331092244E-6,3.6778984368366803E-3,1.0360073829132407E-4]
["XOM",3.5193921996386719E-2,-6.0225233106950401E-6,1.0484604530110267E-6,4.7843629526672079E-4,5.411253230013813E-5,1.0311461042137706E-4,-3.1775160568433746E-5,1.0360073829132406E-4,1.3920603210126388E-4]
["Sum",{"$f":"SUM(B15:B22)","v":0.99999996245490075}]
[]
["Port. Var",{"$f":"SUM(C15:J22)","v":2.391755486907169E-2}]
["Port. S.D.",{"$f":"SQRT(B25)","v":0.15465301441960869}]
["Port. E(R.)",{"$f":"SUMPRODUCT('Correlation Matrix'!N4:N11,B15:B22)","v":6.9119820166617843E-2}]
[]
["Sharpe",{"$f":"(B27-Returns!U1)/'Covar Matrix'!B26","v":0.25295219956383719}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["$b$17",{"$f":"IF(ISBLANK(A1048500)=TRUE,\"\",INDIRECT(A1048500))","v":0.51916928304725207},"this is foreign investments"]
["$b$18",{"$f":"IF(ISBLANK(A1048501)=TRUE,\"\",INDIRECT(A1048501))","v":7.5024377597413094E-2}]
["$b$19",{"$f":"IF(ISBLANK(A1048502)=TRUE,\"\",INDIRECT(A1048502))","v":0.13359694738561223}]
["$b$22",3.5193921996386719E-2]
["$b$20",-1.8402518138923008E-2]
["$b$21",0.20455879240018282]
[null,{"$f":"SUM(B1048500:B1048505)","v":0.94914080428792391}]
["$b$16",{"$f":"IF(ISBLANK(A1048507)=TRUE,\"\",INDIRECT(A1048507))","v":5.4714745906043994E-4},"this is fixed income"]
["$b$17",{"$f":"IF(ISBLANK(A1048508)=TRUE,\"\",INDIRECT(A1048508))","v":0.51916928304725207}]
["$b$18",{"$f":"IF(ISBLANK(A1048509)=TRUE,\"\",INDIRECT(A1048509))","v":7.5024377597413094E-2}]
["$b$19",0.13359694738561223]
["$b$20",-1.8402518138923008E-2]
[null,{"$f":"SUM(B1048507:B1048511)","v":0.70993523735041486}]
[]
[]
[]
[]
["$b$15",{"$f":"IF(ISBLANK(A1048517)=TRUE,\"\",INDIRECT(A1048517))","v":5.0312010707916355E-2},"this is real estate"]
["$b$22",{"$f":"IF(ISBLANK(A1048518)=TRUE,\"\",INDIRECT(A1048518))","v":3.5193921996386719E-2}]
[]
[]
[]
[null,{"$f":"SUM(B1048517:B1048521)","v":8.5505932704303067E-2}]
[]
[]
["$b$16",{"$f":"IF(ISBLANK(A1048525)=TRUE,\"\",INDIRECT(A1048525))","v":5.4714745906043994E-4},"This is for commodities"]
["$b$18",{"$f":"IF(ISBLANK(A1048526)=TRUE,\"\",INDIRECT(A1048526))","v":7.5024377597413094E-2}]
["$b$20",{"$f":"IF(ISBLANK(A1048527)=TRUE,\"\",INDIRECT(A1048527))","v":-1.8402518138923008E-2}]
[]
[]
[null,{"$f":"SUM(B1048525:B1048529)","v":5.716900691755053E-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"}]
[1.9999920224251684E-2,0.35768463034829612,-0.1723629729393828,-0.44351213205149459,1.5568641396421559,-0.22618206250480913,-0.1865003352355788,-0.17039171223093044,0.75317249801618424,-0.11108742269614361]
[2.9999919687415257E-2,0.29933859131934715,-0.12321591454069443,-0.3727682732200604,1.34715717420624,-0.15828195608880916,-0.12059873832086739,-0.13638405658185293,0.63846790854243662,-7.4376143996392724E-2]
[3.9999919150579037E-2,0.24499176204357781,-7.406893528910953E-2,-0.30202425954322942,1.1374503749586038,-9.0381971545981307E-2,-5.469721116864433E-2,-0.10237625119158135,0.52376327832385461,-3.7665024543912178E-2]
[5.0000002265918407E-2,0.19796532724337687,-2.4921483320010481E-2,-0.23127977239948275,0.9277416509239772,-2.248134603785009E-2,1.1204953742744089E-2,-6.8368254925251365E-2,0.40905775848191989,-9.5350646604637664E-4]
[6.0000001729081757E-2,0.1646568028378485,2.4225512207363159E-2,-0.16053569064223427,0.71803484282973462,4.541863369181217E-2,7.7106421249278814E-2,-3.4360469212848098E-2,0.29435315515750732,3.5757594719386478E-2]
[7.0000001192255176E-2,0.15422557635500622,7.3374072330180853E-2,-8.9793673012905653E-2,0.50833092135670144,0.11331806551005721,0.14300652558747048,-3.5286194976837684E-4,0.17964694243083007,7.2470007747433743E-2]
[8.000000065540841E-2,0.17091304172809135,0.12251942997426736,-1.9047521334737853E-2,0.29862091675795582,0.181218597345043,0.20890962129333535,3.365500690285568E-2,6.4944046564887878E-2,0.10917990249639289]
[9.0000000119973375E-2,0.20830047111838451,0.17164976303497198,5.161695568404194E-2,8.8970285870866195E-2,0.24889611505783607,0.27505013812198181,6.7722085232981066E-2,-4.9814367875996468E-2,0.14590902487331739]
[0.10000008323391035,0.25752513734990634,0.2208139008204672,0.12244089000657064,-0.12079463735483781,0.31701925572950646,0.34071331611848743,0.10167071923722039,-0.16446613485952311,0.18260269030210885]
[0.11000008269707372,0.31305148180911663,0.26996084131496312,0.19318487062901127,-0.330501662867556,0.38491934513937287,0.40661496115477969,0.13567852366441424,-0.27917064633483613,0.21931376729985061]
[0.12000008216023778,0.37206899616763695,0.31910788977821469,0.26392848344397485,-0.54020860372157686,0.4528195885749885,0.47251647306291283,0.16968632337218775,-0.39387526949005641,0.25602511497935471]
[0.13000008162144852,0.43315301101243231,0.36814529777219268,0.33500634186438449,-0.75023447519016906,0.52084899761246262,0.53850650204738459,0.2034000383200312,-0.50848099960800308,0.29280829718171603]
[6.9119820166617843E-2,0.15465301441960869,5.0312010707916355E-2,5.4714745906043994E-4,0.51916928304725207,7.5024377597413094E-2,0.13359694738561223,-1.8402518138923008E-2,0.20455879240018282,3.5193921996386719E-2,"MVP"]
[8.2772071017825563E-2,0.17962366640306823,0.1361418232482072,5.6722054221749227E-4,0.24048519799645091,0.20004094584705909,0.22717959944069152,4.3082719046493308E-2,3.3150060428424256E-2,0.11935240314349964,"MVE"]