{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sample Data","Calculation of Expected Return"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sample Data","index":0,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,2,15,3],[8,2,8,3],[8,4,8,5],[8,6,8,7],[1,1,1,7],[3,1,4,1],[3,2,3,3],[3,4,3,5],[3,6,3,7]]}
[]
[null,"Dataset for Expected Return"]
[]
[null,"Market Condition","Investment 1",null,"Investment 2",null,"Investment 3"]
[null,null,"Return","Probability","Return","Probability","Return","Probability"]
[null,"Good ",0.09,0.3,0.05,0.35,0.17,0.25]
[null,"Normal",0.08,0.4,0.06,0.4,0.1,0.45]
[null,"Bad",-0.06,0.3,-0.03,0.25,-0.08,0.3]
[null,"Expected Return (Investments)"]
[]
[]
[null,"Investments","Retruns","Weights"]
[null,"Investment1",null,0.35]
[null,"Investment2",null,0.25]
[null,"Investment3",null,0.4]
[null,"Expected Return (Portfolio)"]

{"sheet":"Calculation of Expected Return","index":1,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,2,8,3],[8,4,8,5],[8,6,8,7],[1,1,1,7],[3,1,4,1],[3,2,3,3],[3,4,3,5],[3,6,3,7],[17,3,17,4],[11,1,11,7],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2]]}
[]
[null,"Calculation of Expected Return of Individual Investment"]
[]
[null,"Market / Economic Condition","Investment 1",null,"Investment 2",null,"Investment 3"]
[null,null,"Return","Probability","Return","Probability","Return","Probability"]
[null,"Good ",0.09,0.3,0.05,0.35,0.17,0.25]
[null,"Normal",0.08,0.4,0.06,0.4,0.1,0.45]
[null,"Bad",-0.06,0.3,-0.03,0.25,-0.08,0.3]
[null,"Expected Return (Investments)",{"$f":"SUMPRODUCT(C6:C8,D6:D8)","v":4.0999999999999995E-2},null,{"$f":"SUMPRODUCT(E6:E8,F6:F8)","v":3.3999999999999996E-2},null,{"$f":"SUMPRODUCT(G6:G8,H6:H8)","v":6.3500000000000001E-2}]
[]
[]
[null,"Calculation of Expected Return of Portfolio"]
[]
[null,"Investments",null,"Retruns","Weights"]
[null,"Investment1",null,{"$f":"C9","v":4.0999999999999995E-2},0.35]
[null,"Investment2",null,{"$f":"E9","v":3.3999999999999996E-2},0.25]
[null,"Investment3",null,{"$f":"G9","v":6.3500000000000001E-2},0.4]
[null,"Expected Return (Portfolio)",null,{"$f":"SUMPRODUCT(D15:D17,E15:E17)","v":4.8250000000000001E-2}]