{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Problem"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":"Problem","index":0,"n_rows":115,"n_cols":8,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
["Allocation","Asset A","Asset B"]
[null,0.5,0.5]
[]
["Parameters","Asset A","Asset B","Portfolio"]
["mu",0,0.02]
["sigma",0.5,0.1]
[]
["Observed"]
["mu",{"$f":"AVERAGE((B16:B36))","v":-0.17370438031232316},{"$f":"AVERAGE(C16:C36)","v":7.9936186993415127E-3},{"$f":"AVERAGE(LN(F16:F36/F15:F35))","v":-5.1555014938874738E-2}]
["sigma",{"$f":"_xlfn.STDEV.S((B16:B36))","v":0.49006410717855875},{"$f":"_xlfn.STDEV.S(C16:C36)","v":8.6623377814584915E-2},{"$f":"_xlfn.STDEV.S(LN(F16:F36/F15:F35))","v":0.25412420920885126}]
["correl",{"$f":"CORREL(B16:B115,C16:C115)","v":8.5709704346420112E-2}]
[]
[null,"Rtns",null,null,null,"Porfolio"]
["t","Asset A Rtn","Asset B Rtn","Asset A CumRtn","Asset B CumRtn","Numeraire","Numeraire Rtn","Rtn Attribution"]
[0,null,null,1,1,{"$f":"SUM(B2:C2)","v":1}]
[{"$f":"A15+1","v":1},{"$f":"IF(sigma_a=0,mu_a,_xlfn.NORM.INV(RAND(),mu_a,sigma_a))","v":0.69116043453390252},{"$f":"IF(sigma_b=0,mu_b,_xlfn.NORM.INV(RAND(),mu_b,sigma_b))","v":0.18417497413360168},{"$f":"D15*EXP(B16)","v":1.996030452494983},{"$f":"E15*EXP(C16)","v":1.2022261631750231},{"$f":"alloc_a*F15/SUM(alloc_a,alloc_b)*EXP(B16)+alloc_b*F15/SUM(alloc_a,alloc_b)*EXP(C16)","v":1.5991283078350031},{"$f":"LN(F16/F15)","v":0.46945867318102585},{"$f":"EXP(G16)/(EXP(B16)+EXP(C16))","v":0.5}]
[{"$f":"A16+1","v":2},-0.46083816659192461,-0.11625390335817277,1.2590056817284483,1.0702808287089736,{"$f":"alloc_a*F16/SUM(alloc_a,alloc_b)*EXP(B17)+alloc_b*F16/SUM(alloc_a,alloc_b)*EXP(C17)","v":1.2161401993491829},{"$f":"LN(F17/F16)","v":-0.2737766007656478},{"$f":"EXP(G17)/(EXP(B17)+EXP(C17))","v":0.5}]
[3,0.23941925311888063,-6.8349304087648236E-2,1.5995806818599558,0.99957185836657847,{"$f":"alloc_a*F17/SUM(alloc_a,alloc_b)*EXP(B18)+alloc_b*F17/SUM(alloc_a,alloc_b)*EXP(C18)","v":1.340457261282868},{"$f":"LN(F18/F17)","v":9.7328723101729936E-2},0.5]
[4,7.7679808650829123E-3,5.0054383114016734E-2,1.6120545797644774,1.0508781519240364,{"$f":"alloc_a*F18/SUM(alloc_a,alloc_b)*EXP(B19)+alloc_b*F18/SUM(alloc_a,alloc_b)*EXP(C19)","v":1.3800855338956692},2.9134682815075506E-2,0.5]
[5,-0.62396848788932757,6.2151589663405893E-2,{"$f":"D19*EXP(B20)","v":0.86376115794004127},1.1182642870035397,{"$f":"alloc_a*F19/SUM(alloc_a,alloc_b)*EXP(B20)+alloc_b*F19/SUM(alloc_a,alloc_b)*EXP(C20)","v":1.1040252888676614},-0.22318262415660517,0.50000000000000011]
[6,-0.9048160034448075,-1.2798638825700752E-3,{"$f":"D20*EXP(B21)","v":0.34949186649571967},1.1168339764281026,{"$f":"alloc_a*F20/SUM(alloc_a,alloc_b)*EXP(B21)+alloc_b*F20/SUM(alloc_a,alloc_b)*EXP(C21)","v":0.77465992354966473},-0.35429400843192782,0.5]
[7,-0.56413923089436968,7.5174735535386561E-2,0.19880830294745436,{"$f":"E21*EXP(C22)","v":1.2040280104604135},{"$f":"alloc_a*F21/SUM(alloc_a,alloc_b)*EXP(B22)+alloc_b*F21/SUM(alloc_a,alloc_b)*EXP(C22)","v":0.63790227258039578},{"$f":"LN(F22/F21)","v":-0.19423903088758551},0.49999999999999994]
[8,0.18568070298505659,2.7758803232673036E-2,0.2393727024250781,1.2379185919060245,{"$f":"alloc_a*F22/SUM(alloc_a,alloc_b)*EXP(B23)+alloc_b*F22/SUM(alloc_a,alloc_b)*EXP(C23)","v":0.71195807674223444},0.1098339348602127,0.49999999999999989]
[9,-0.10436167753551075,7.8374073836449815E-2,0.2156507248084735,1.3388425716144647,{"$f":"alloc_a*F23/SUM(alloc_a,alloc_b)*EXP(B24)+alloc_b*F23/SUM(alloc_a,alloc_b)*EXP(C24)","v":0.7057022995574489},-8.8255521487619372E-3,0.49999999999999994]
[10,0.15579284854336839,-6.6804110328357771E-2,0.25200600905223147,1.2523244417169086,{"$f":"alloc_a*F24/SUM(alloc_a,alloc_b)*EXP(B25)+alloc_b*F24/SUM(alloc_a,alloc_b)*EXP(C25)","v":0.74238559373618473},5.0675299745083169E-2,0.49999999999999989]
[11,1.0169334077218797,-3.1542609861209159E-2,0.69672190344852625,1.2134393529856704,{"$f":"alloc_a*F25/SUM(alloc_a,alloc_b)*EXP(B26)+alloc_b*F25/SUM(alloc_a,alloc_b)*EXP(C26)","v":1.3859051743280033},0.62423998432381445,0.5]
[12,-0.35920927199660163,4.6292040050492089E-2,0.48647089200525645,1.2709324047311086,{"$f":"alloc_a*F26/SUM(alloc_a,alloc_b)*EXP(B27)+alloc_b*F26/SUM(alloc_a,alloc_b)*EXP(C27)","v":1.2096238983414236},-0.13604399816174767,0.5]
[13,-0.31127754358316273,7.0456610581192486E-2,0.35634505776862929,1.3637079432314476,{"$f":"alloc_a*F27/SUM(alloc_a,alloc_b)*EXP(B28)+alloc_b*F27/SUM(alloc_a,alloc_b)*EXP(C28)","v":1.0919931488254011},-0.10230488014104709,0.50000000000000011]
[14,-0.22345627751087555,7.3256594979026493E-2,0.28498690940564425,1.4673587465519671,{"$f":"alloc_a*F28/SUM(alloc_a,alloc_b)*EXP(B29)+alloc_b*F28/SUM(alloc_a,alloc_b)*EXP(C29)","v":1.0241566002512685},-6.4135158476013573E-2,0.50000000000000011]
[15,-0.28952963426220374,-1.2144864038746758E-2,0.2133456484313721,1.4496456533528721,{"$f":"alloc_a*F29/SUM(alloc_a,alloc_b)*EXP(B30)+alloc_b*F29/SUM(alloc_a,alloc_b)*EXP(C30)","v":0.88924659951018148},-0.14125013701603614,0.50000000000000011]
[16,-0.82173261349068139,-7.0943826240781785E-2,9.3801514276149522E-2,1.3503655361645974,{"$f":"alloc_a*F30/SUM(alloc_a,alloc_b)*EXP(B31)+alloc_b*F30/SUM(alloc_a,alloc_b)*EXP(C31)","v":0.60966010330055109},-0.37747299265826817,0.49999999999999994]
[17,9.5819923718101399E-2,-0.1792015651371425,0.10323427533745141,1.1288210372297862,{"$f":"alloc_a*F31/SUM(alloc_a,alloc_b)*EXP(B32)+alloc_b*F31/SUM(alloc_a,alloc_b)*EXP(C32)","v":0.59030286090403328},-3.2265865404986958E-2,0.49999999999999994]
[18,0.21488023827885397,0.11305310510416496,0.12798091631915356,1.2639311992824009,{"$f":"alloc_a*F32/SUM(alloc_a,alloc_b)*EXP(B33)+alloc_b*F32/SUM(alloc_a,alloc_b)*EXP(C33)","v":0.69638170485225293},0.1652622077549678,0.5]
[19,-0.31279616445073677,5.4040086690363809E-2,9.3605111973815422E-2,1.3341133981447721,{"$f":"alloc_a*F33/SUM(alloc_a,alloc_b)*EXP(B34)+alloc_b*F33/SUM(alloc_a,alloc_b)*EXP(C34)","v":0.62219125108161566},-0.11265041341461997,0.49999999999999994]
[20,-0.47652718626665386,-9.335350276346159E-2,5.8122788206975848E-2,1.2152058025005945,{"$f":"alloc_a*F34/SUM(alloc_a,alloc_b)*EXP(B35)+alloc_b*F34/SUM(alloc_a,alloc_b)*EXP(C35)","v":0.47653861080017579},-0.26669877327843405,0.5]
[21,-0.80259451840705709,-2.7047454536511108E-2,2.6048580944686955E-2,1.1827780991112782,{"$f":"alloc_a*F35/SUM(alloc_a,alloc_b)*EXP(B36)+alloc_b*F35/SUM(alloc_a,alloc_b)*EXP(C36)","v":0.33869498912028656},-0.341448784556597,0.5]
[22,2.8649146099643179E-2,-5.6518939291934897E-2,{"$f":"D36*EXP(B37)","v":2.6805643361052518E-2},{"$f":"E36*EXP(C37)","v":1.1177827698502762},{"$f":"alloc_a*F36/SUM(alloc_a,alloc_b)*EXP(B37)+alloc_b*F36/SUM(alloc_a,alloc_b)*EXP(C37)","v":0.3343109323527157},{"$f":"LN(F37/F36)","v":-1.3028470152716848E-2},0.5]
[23,0.25544516802878825,2.8551298418685783E-2,3.4607056506761179E-2,1.1501568815532472,{"$f":"alloc_a*F37/SUM(alloc_a,alloc_b)*EXP(B38)+alloc_b*F37/SUM(alloc_a,alloc_b)*EXP(C38)","v":0.38780051682436262},0.14841958040312853,0.5]
[24,-6.5464741798789902E-2,2.5616356439492408E-2,3.2414078977360324E-2,1.1800003183343559,{"$f":"alloc_a*F38/SUM(alloc_a,alloc_b)*EXP(B39)+alloc_b*F38/SUM(alloc_a,alloc_b)*EXP(C39)","v":0.38054464215710526},-1.8887580110655004E-2,0.50000000000000011]
[25,2.9414284350349755E-2,4.296461709102057E-2,3.3381676748540916E-2,1.2318034626841321,{"$f":"alloc_a*F39/SUM(alloc_a,alloc_b)*EXP(B40)+alloc_b*F39/SUM(alloc_a,alloc_b)*EXP(C40)","v":0.39457762831438326},3.6212401984770624E-2,0.5]
[26,3.3328408997661561E-2,1.3358482290724907E-3,3.4512982517276747E-2,1.2334500647186679,{"$f":"alloc_a*F40/SUM(alloc_a,alloc_b)*EXP(B41)+alloc_b*F40/SUM(alloc_a,alloc_b)*EXP(C41)","v":0.40152747464309424},1.7460063650549227E-2,0.5]
[27,0.40443329072398443,5.3384578485513867E-2,5.1716084681537842E-2,1.3010865877197613,{"$f":"alloc_a*F41/SUM(alloc_a,alloc_b)*EXP(B42)+alloc_b*F41/SUM(alloc_a,alloc_b)*EXP(C42)","v":0.51260770281116197},0.24423487971957444,0.5]
[28,-0.12720427668122622,-5.7576039154393688E-2,4.5538793730058168E-2,1.2282909269999118,{"$f":"alloc_a*F42/SUM(alloc_a,alloc_b)*EXP(B43)+alloc_b*F42/SUM(alloc_a,alloc_b)*EXP(C43)","v":0.46765300186322356},-9.1784268862240823E-2,0.5]
[29,0.46153471707543653,0.20709260289342998,7.2247613060305721E-2,1.5109163420332421,{"$f":"alloc_a*F43/SUM(alloc_a,alloc_b)*EXP(B44)+alloc_b*F43/SUM(alloc_a,alloc_b)*EXP(C44)","v":0.65859652545422176},0.34238452237608791,0.5]
[30,8.4160557453821103E-2,-4.3118739367472375E-2,7.859120886456121E-2,1.447152129341452,{"$f":"alloc_a*F44/SUM(alloc_a,alloc_b)*EXP(B45)+alloc_b*F44/SUM(alloc_a,alloc_b)*EXP(C45)","v":0.67361291802750056},2.2544546064233891E-2,0.5]
[31,-0.52847145116246119,-0.18252941027033712,4.6329939589518483E-2,1.2057094708325449,{"$f":"alloc_a*F45/SUM(alloc_a,alloc_b)*EXP(B46)+alloc_b*F45/SUM(alloc_a,alloc_b)*EXP(C46)","v":0.47916293251481523},-0.34061494937802911,0.5]
[32,-6.1893494436668715E-2,-0.19437517020369446,4.354935536788869E-2,0.99271962720524587,{"$f":"alloc_a*F46/SUM(alloc_a,alloc_b)*EXP(B47)+alloc_b*F46/SUM(alloc_a,alloc_b)*EXP(C47)","v":0.42246165293001958},-0.12594201057820006,0.5]
[33,{"$f":"IF(sigma_a=0,mu_a,_xlfn.NORM.INV(RAND(),mu_a,sigma_a))","v":0.51906029764410233},{"$f":"IF(sigma_b=0,mu_b,_xlfn.NORM.INV(RAND(),mu_b,sigma_b))","v":-2.2904617204656589E-2},7.3182417843250289E-2,0.97024018838097958,{"$f":"alloc_a*F47/SUM(alloc_a,alloc_b)*EXP(B48)+alloc_b*F47/SUM(alloc_a,alloc_b)*EXP(C48)","v":0.56141002756662772},0.28435284510068443,0.5]
[34,-0.10616453491373926,0.10023728458450519,6.5811241276242952E-2,1.0725357057445779,{"$f":"alloc_a*F48/SUM(alloc_a,alloc_b)*EXP(B49)+alloc_b*F48/SUM(alloc_a,alloc_b)*EXP(C49)","v":0.56273210964238607},2.3521628476527319E-3,0.5]
[35,-0.83288672251870544,0.37551421213340691,2.8614224126940306E-2,1.5613328936641901,{"$f":"alloc_a*F49/SUM(alloc_a,alloc_b)*EXP(B50)+alloc_b*F49/SUM(alloc_a,alloc_b)*EXP(C50)","v":0.53193156675268105},-5.6288841186547797E-2,0.5]
[36,0.687712792433255,5.6732334414269059E-2,5.6918290177179018E-2,1.6524717708139345,{"$f":"alloc_a*F50/SUM(alloc_a,alloc_b)*EXP(B51)+alloc_b*F50/SUM(alloc_a,alloc_b)*EXP(C51)","v":0.81053955104279085},0.42118529116653819,0.5]
[37,0.35169549066224609,5.4871162840022664E-2,8.0907960977288002E-2,1.7456786177054247,{"$f":"alloc_a*F51/SUM(alloc_a,alloc_b)*EXP(B52)+alloc_b*F51/SUM(alloc_a,alloc_b)*EXP(C52)","v":1.0042099147184629},0.21425621849207635,0.50000000000000011]
[38,0.44540877571156834,9.5850021769385549E-2,0.12630770083873888,1.9212833889672947,{"$f":"alloc_a*F52/SUM(alloc_a,alloc_b)*EXP(B53)+alloc_b*F52/SUM(alloc_a,alloc_b)*EXP(C53)","v":1.3364639133369707},0.28582617754156403,0.5]
[39,-0.8029465398352712,-3.3020850928378892E-2,5.6586727444162148E-2,1.8588770030084087,{"$f":"alloc_a*F53/SUM(alloc_a,alloc_b)*EXP(B54)+alloc_b*F53/SUM(alloc_a,alloc_b)*EXP(C54)","v":0.94589926284533377},-0.34564645844105968,0.5]
[40,2.7692218482914598E-2,-3.2517109485040122E-2,5.8175638157182165E-2,1.7994038832500792,{"$f":"alloc_a*F54/SUM(alloc_a,alloc_b)*EXP(B55)+alloc_b*F54/SUM(alloc_a,alloc_b)*EXP(C55)","v":0.94404771212024463},-1.9593685346480086E-3,0.49999999999999994]
[41,0.22321683672514558,-2.572305706760682E-2,7.2724877173697799E-2,1.7537079536058287,{"$f":"alloc_a*F55/SUM(alloc_a,alloc_b)*EXP(B56)+alloc_b*F55/SUM(alloc_a,alloc_b)*EXP(C56)","v":1.0501098546273901},0.10647335376504374,0.5]
[42,-0.54900751201086251,2.5081297962779272E-2,4.2000268178045509E-2,1.7982494698920037,{"$f":"alloc_a*F56/SUM(alloc_a,alloc_b)*EXP(B57)+alloc_b*F56/SUM(alloc_a,alloc_b)*EXP(C57)","v":0.84162166907942848},-0.2213194720012801,0.5]
[43,-0.89222121518598918,6.2315864036955909E-2,1.7209383515198177E-2,1.9138741509441359,{"$f":"alloc_a*F57/SUM(alloc_a,alloc_b)*EXP(B58)+alloc_b*F57/SUM(alloc_a,alloc_b)*EXP(C58)","v":0.62029329675087941},-0.30513816367480884,0.49999999999999994]
[44,-0.13273091091869707,9.4981626681669304E-2,1.5070269223606381E-2,2.1045699893930752,{"$f":"alloc_a*F58/SUM(alloc_a,alloc_b)*EXP(B59)+alloc_b*F58/SUM(alloc_a,alloc_b)*EXP(C59)","v":0.61264487968564396},-1.2406972747091622E-2,0.49999999999999994]
[45,0.80846437440422247,7.4164960908715036E-2,3.382459673051267E-2,2.2665891549906303,{"$f":"alloc_a*F59/SUM(alloc_a,alloc_b)*EXP(B60)+alloc_b*F59/SUM(alloc_a,alloc_b)*EXP(C60)","v":1.0174325670271926},0.507252189218243,0.5]
[46,0.50009563654465738,1.4559314424807634E-2,5.5772665752439145E-2,2.2998305378531771,{"$f":"alloc_a*F60/SUM(alloc_a,alloc_b)*EXP(B61)+alloc_b*F60/SUM(alloc_a,alloc_b)*EXP(C61)","v":1.3549885982647831},0.28651067678502623,0.5]
[47,0.15649561637826478,2.701927111744843E-2,6.5220869669876516E-2,2.3628173800950893,{"$f":"alloc_a*F61/SUM(alloc_a,alloc_b)*EXP(B62)+alloc_b*F61/SUM(alloc_a,alloc_b)*EXP(C62)","v":1.4883148948165723},9.3851497151015054E-2,0.50000000000000011]
[48,0.38611489341053307,0.19617139092217256,9.5956445718560726E-2,2.8749236088629044,{"$f":"alloc_a*F62/SUM(alloc_a,alloc_b)*EXP(B63)+alloc_b*F62/SUM(alloc_a,alloc_b)*EXP(C63)","v":2.0002871246790761},0.29564619571285611,0.5]
[49,-0.17782235984195757,-8.1349968762920971E-2,8.0324287780954087E-2,2.6503087278903075,{"$f":"alloc_a*F63/SUM(alloc_a,alloc_b)*EXP(B64)+alloc_b*F63/SUM(alloc_a,alloc_b)*EXP(C64)","v":1.7592146409232887},-0.12842324988225043,0.5]
[50,-0.90515290903726597,0.11385272842328556,3.2489570469681338E-2,2.9699017240639316,{"$f":"alloc_a*F64/SUM(alloc_a,alloc_b)*EXP(B65)+alloc_b*F64/SUM(alloc_a,alloc_b)*EXP(C65)","v":1.3414601975174476},-0.27110876240212528,0.50000000000000011]
[51,0.1668725851764726,-4.7471993893863279E-2,3.8389796739772129E-2,2.8322087062689381,{"$f":"alloc_a*F65/SUM(alloc_a,alloc_b)*EXP(B66)+alloc_b*F65/SUM(alloc_a,alloc_b)*EXP(C66)","v":1.4321703278668831},6.5432285195270723E-2,0.49999999999999989]
[52,-0.10014950953458349,-1.5328629468428518E-2,3.4731331507535733E-2,2.7891258724148726,{"$f":"alloc_a*F66/SUM(alloc_a,alloc_b)*EXP(B67)+alloc_b*F66/SUM(alloc_a,alloc_b)*EXP(C67)","v":1.3530360444860157},-5.6840016254149292E-2,0.5]
[53,0.89346342673446044,7.0051181276435087E-2,8.486872336137484E-2,2.9915134222700774,{"$f":"alloc_a*F67/SUM(alloc_a,alloc_b)*EXP(B68)+alloc_b*F67/SUM(alloc_a,alloc_b)*EXP(C68)","v":2.3787329185481845},0.56421696949824651,0.50000000000000011]
[54,-9.6161676701015802E-2,-3.142408096064396E-2,7.7087716968164424E-2,2.8989695309174075,{"$f":"alloc_a*F68/SUM(alloc_a,alloc_b)*EXP(B69)+alloc_b*F68/SUM(alloc_a,alloc_b)*EXP(C69)","v":2.2328947950073994},-6.3269100747262566E-2,0.5]
[55,-0.62556254245689757,0.12860503430254475,4.1238876360492033E-2,3.2968266149758487,{"$f":"alloc_a*F69/SUM(alloc_a,alloc_b)*EXP(B70)+alloc_b*F69/SUM(alloc_a,alloc_b)*EXP(C70)","v":1.8669247562575317},-0.17900629620666028,0.5]
[56,5.6045387050970639E-2,0.18873002468175648,4.3616119680880382E-2,3.9816264781340327,{"$f":"alloc_a*F70/SUM(alloc_a,alloc_b)*EXP(B71)+alloc_b*F70/SUM(alloc_a,alloc_b)*EXP(C71)","v":2.1146288382283247},0.12458674510219454,0.5]
[57,-5.3068801101465404E-2,-2.7742567044813159E-2,4.1361810291378892E-2,3.8726840964830958,{"$f":"alloc_a*F71/SUM(alloc_a,alloc_b)*EXP(B72)+alloc_b*F71/SUM(alloc_a,alloc_b)*EXP(C72)","v":2.0310518223390188},-4.0325508949409283E-2,0.49999999999999989]
[58,0.39830791497344226,0.24491477517166524,6.1600249037612978E-2,4.9474020815156399,{"$f":"alloc_a*F72/SUM(alloc_a,alloc_b)*EXP(B73)+alloc_b*F72/SUM(alloc_a,alloc_b)*EXP(C73)","v":2.8097722941086403},0.32454964798792163,0.49999999999999994]
[59,0.39192462521134958,0.26353516624507145,9.1157660334198226E-2,6.4391579150634355,{"$f":"alloc_a*F73/SUM(alloc_a,alloc_b)*EXP(B74)+alloc_b*F73/SUM(alloc_a,alloc_b)*EXP(C74)","v":3.9074790025462836},0.32978896373329303,0.49999999999999994]
[60,0.158526613930176,0.12976544948787291,0.10681700668699257,7.331376018704133,{"$f":"alloc_a*F74/SUM(alloc_a,alloc_b)*EXP(B75)+alloc_b*F74/SUM(alloc_a,alloc_b)*EXP(C75)","v":4.513811138159241},0.14424942871783794,0.5]
[61,1.0416952146002874,8.1710511124326549E-2,0.30272123547185947,7.9555813078731061,{"$f":"alloc_a*F75/SUM(alloc_a,alloc_b)*EXP(B76)+alloc_b*F75/SUM(alloc_a,alloc_b)*EXP(C76)","v":8.8451714116532134},0.6727298685329185,0.5]
[62,9.0888314523008953E-2,1.3214592956142277E-2,0.33152415794442863,8.0614087699942143,{"$f":"alloc_a*F76/SUM(alloc_a,alloc_b)*EXP(B77)+alloc_b*F76/SUM(alloc_a,alloc_b)*EXP(C77)","v":9.3247963116217392},5.2805415112366701E-2,0.50000000000000011]
[63,-3.2486847977725795E-2,8.5037126614570899E-2,0.32092704836355895,8.7769191607707349,{"$f":"alloc_a*F77/SUM(alloc_a,alloc_b)*EXP(B78)+alloc_b*F77/SUM(alloc_a,alloc_b)*EXP(C78)","v":9.589586347742447},2.8000632223698179E-2,0.5]
[64,-0.41068605115700729,-7.4541247306394082E-2,0.21283724858223785,8.146465937532291,{"$f":"alloc_a*F78/SUM(alloc_a,alloc_b)*EXP(B79)+alloc_b*F78/SUM(alloc_a,alloc_b)*EXP(C79)","v":7.6302626686281965},-0.22855548378306947,0.5]
[65,{"$f":"IF(sigma_a=0,mu_a,_xlfn.NORM.INV(RAND(),mu_a,sigma_a))","v":0.18709051160840193},{"$f":"IF(sigma_b=0,mu_b,_xlfn.NORM.INV(RAND(),mu_b,sigma_b))","v":-5.9425561478505001E-2},0.25662562071223527,7.6764610826793609,{"$f":"alloc_a*F79/SUM(alloc_a,alloc_b)*EXP(B80)+alloc_b*F79/SUM(alloc_a,alloc_b)*EXP(C80)","v":8.1950626776406494},7.1409589970624604E-2,0.5]
[{"$f":"A80+1","v":66},8.8084192665652136E-2,2.6021308237871056E-3,0.2802557241090961,7.6964622502216908,{"$f":"alloc_a*F80/SUM(alloc_a,alloc_b)*EXP(B81)+alloc_b*F80/SUM(alloc_a,alloc_b)*EXP(C81)","v":8.5830398196541839},4.6256281643659525E-2,{"$f":"EXP(G81)/(EXP(B81)+EXP(C81))","v":0.5}]
[67,-0.18399326410510577,-0.15089778367892284,0.23315634162504853,6.6184618339161734,{"$f":"alloc_a*F81/SUM(alloc_a,alloc_b)*EXP(B82)+alloc_b*F81/SUM(alloc_a,alloc_b)*EXP(C82)","v":7.2607238360463526},-0.16730861628694577,0.50000000000000011]
[68,-6.7268454679156889E-2,6.9151334767215328E-2,0.21798816405066412,7.0923328930605827,{"$f":"alloc_a*F82/SUM(alloc_a,alloc_b)*EXP(B83)+alloc_b*F82/SUM(alloc_a,alloc_b)*EXP(C83)","v":7.2844756403452493},3.2659332654012985E-3,0.5]
[69,-0.20933078753508549,0.11415367549846078,0.1768160595141649,7.9499687818296616,{"$f":"alloc_a*F83/SUM(alloc_a,alloc_b)*EXP(B84)+alloc_b*F83/SUM(alloc_a,alloc_b)*EXP(C84)","v":7.0369901363953389},-3.456491776104146E-2,0.49999999999999994]
[70,-0.95309545250821648,0.13937542268576772,6.8170677787110584E-2,9.138931039562781,{"$f":"alloc_a*F84/SUM(alloc_a,alloc_b)*EXP(B85)+alloc_b*F84/SUM(alloc_a,alloc_b)*EXP(C85)","v":5.4012464382597507},-0.26455079247100977,0.5]
[71,5.3851756167925327E-2,5.5410285206301244E-2,7.1942434909979786E-2,9.6596142019129072,{"$f":"alloc_a*F85/SUM(alloc_a,alloc_b)*EXP(B86)+alloc_b*F85/SUM(alloc_a,alloc_b)*EXP(C86)","v":5.7045327216437673},5.4631324313678051E-2,0.5]
[72,0.34435165595370471,-8.4947906875185455E-2,0.10151615415431978,8.8729365139860725,{"$f":"alloc_a*F86/SUM(alloc_a,alloc_b)*EXP(B87)+alloc_b*F86/SUM(alloc_a,alloc_b)*EXP(C87)","v":6.6447392438156641},0.15256437728590452,0.5]
[73,-5.9644279601442723E-2,0.30343398687996331,9.56383280223949E-2,12.018411789760789,{"$f":"alloc_a*F87/SUM(alloc_a,alloc_b)*EXP(B88)+alloc_b*F87/SUM(alloc_a,alloc_b)*EXP(C88)","v":7.6301599579446941},0.13828335898612434,0.5]
[74,0.12003831892222781,-6.280072758385026E-2,0.10783604581744989,11.286858249535712,{"$f":"alloc_a*F88/SUM(alloc_a,alloc_b)*EXP(B89)+alloc_b*F88/SUM(alloc_a,alloc_b)*EXP(C89)","v":7.8845138380237287},3.2791752533459222E-2,0.5]
[75,-0.17273096494917051,8.7069189277676082E-2,9.0729360468075865E-2,12.31364813181616,{"$f":"alloc_a*F89/SUM(alloc_a,alloc_b)*EXP(B90)+alloc_b*F89/SUM(alloc_a,alloc_b)*EXP(C90)","v":7.6177653658836224},-3.4417494334758499E-2,0.49999999999999994]
[76,0.10928154739540048,8.4177959842104966E-2,0.10120645726810981,13.395063067570552,{"$f":"alloc_a*F90/SUM(alloc_a,alloc_b)*EXP(B91)+alloc_b*F90/SUM(alloc_a,alloc_b)*EXP(C91)","v":8.3921067623539081},9.6808525313910002E-2,0.49999999999999989]
[77,-0.36397218566951156,-3.5366458749285137E-2,7.0329432145598447E-2,12.929606413485274,{"$f":"alloc_a*F91/SUM(alloc_a,alloc_b)*EXP(B92)+alloc_b*F91/SUM(alloc_a,alloc_b)*EXP(C92)","v":6.9661290006196017},-0.18623190255341696,0.5]
[78,-0.18518108192498642,-0.15675035734932835,5.8440508859043512E-2,11.0537462226138,{"$f":"alloc_a*F92/SUM(alloc_a,alloc_b)*EXP(B93)+alloc_b*F92/SUM(alloc_a,alloc_b)*EXP(C93)","v":5.8719983223122689},-0.17086468477739702,0.5]
[79,0.22704089666892013,-6.9524146041297946E-2,7.3335895146452376E-2,10.311350194332967,{"$f":"alloc_a*F93/SUM(alloc_a,alloc_b)*EXP(B94)+alloc_b*F93/SUM(alloc_a,alloc_b)*EXP(C94)","v":6.423140550278843},8.9712174775235048E-2,0.5]
[80,-8.5724153217459922E-2,-4.2237229497131781E-2,6.7311159333815526E-2,9.8848968309693976,{"$f":"alloc_a*F94/SUM(alloc_a,alloc_b)*EXP(B95)+alloc_b*F94/SUM(alloc_a,alloc_b)*EXP(C95)","v":6.0264785964210787},-6.3744320914712632E-2,0.49999999999999994]
[81,-0.49103943835505076,0.1614901602455838,4.1193752203780673E-2,11.617332684912347,{"$f":"alloc_a*F95/SUM(alloc_a,alloc_b)*EXP(B96)+alloc_b*F95/SUM(alloc_a,alloc_b)*EXP(C96)","v":5.3854144411504876},-0.1124685896710773,0.50000000000000011]
[82,1.4697082752026172E-2,-5.8742056213742927E-3,4.1803651077539326E-2,11.549290127593521,{"$f":"alloc_a*F96/SUM(alloc_a,alloc_b)*EXP(B97)+alloc_b*F96/SUM(alloc_a,alloc_b)*EXP(C97)","v":5.4095104810093293},4.4643348708140003E-3,0.5]
[83,-0.2635784829194382,-5.156719104202169E-2,3.2117633166682868E-2,10.968820886394944,{"$f":"alloc_a*F97/SUM(alloc_a,alloc_b)*EXP(B98)+alloc_b*F97/SUM(alloc_a,alloc_b)*EXP(C98)","v":4.6468700001676222},-0.15196472995272334,0.50000000000000011]
[84,0.42805497141985749,0.14437051353447497,4.9277134517545625E-2,12.672411361148752,{"$f":"alloc_a*F98/SUM(alloc_a,alloc_b)*EXP(B99)+alloc_b*F98/SUM(alloc_a,alloc_b)*EXP(C99)","v":6.2490701339381562},0.29623879939983994,0.5]
[85,-0.74847364069640177,-3.6441687161770223E-2,2.3312426157046755E-2,12.218920482194596,{"$f":"alloc_a*F99/SUM(alloc_a,alloc_b)*EXP(B100)+alloc_b*F99/SUM(alloc_a,alloc_b)*EXP(C100)","v":4.4909018215266796},-0.33037914140398084,0.5]
[86,3.4501017507609158E-2,-0.15702514384894267,{"$f":"D100*EXP(B101)","v":2.4130764154751128E-2},{"$f":"E100*EXP(C101)","v":10.443298342485058},{"$f":"alloc_a*F100/SUM(alloc_a,alloc_b)*EXP(B101)+alloc_b*F100/SUM(alloc_a,alloc_b)*EXP(C101)","v":4.2434209092520065},{"$f":"LN(F101/F100)","v":-5.66837705449839E-2},0.5]
[87,0.42179106009387701,0.13208050784109179,3.6791932936955131E-2,11.917894064498967,{"$f":"alloc_a*F101/SUM(alloc_a,alloc_b)*EXP(B102)+alloc_b*F101/SUM(alloc_a,alloc_b)*EXP(C102)","v":5.6562469256802519},0.28739082277898703,0.49999999999999989]
[88,0.24833724621724051,-6.2372491206162561E-2,4.7163290846350819E-2,11.197253022623366,{"$f":"alloc_a*F102/SUM(alloc_a,alloc_b)*EXP(B103)+alloc_b*F102/SUM(alloc_a,alloc_b)*EXP(C103)","v":6.2824642382926914},0.10500171320625296,0.5]
[89,0.11037691043927114,8.7019055951914018E-2,5.2667194377303161E-2,12.21527891589507,{"$f":"alloc_a*F103/SUM(alloc_a,alloc_b)*EXP(B104)+alloc_b*F103/SUM(alloc_a,alloc_b)*EXP(C104)","v":6.9346353998467762},9.876618031607759E-2,0.5]
[90,-2.7254195036525944E-2,4.4687277451764623E-2,5.1251176256134276E-2,12.773526868048513,{"$f":"alloc_a*F104/SUM(alloc_a,alloc_b)*EXP(B105)+alloc_b*F104/SUM(alloc_a,alloc_b)*EXP(C105)","v":6.9998717477495589},9.3633486752660727E-3,0.5]
[91,0.16683586574808881,-0.14296485485704719,6.0556355954833857E-2,11.071895503539313,{"$f":"alloc_a*F105/SUM(alloc_a,alloc_b)*EXP(B106)+alloc_b*F105/SUM(alloc_a,alloc_b)*EXP(C106)","v":7.1690756103316087},2.3884894522685166E-2,0.49999999999999989]
[92,0.89711237020187273,0.12052666593501687,0.14851512502023489,12.490103701471087,{"$f":"alloc_a*F106/SUM(alloc_a,alloc_b)*EXP(B107)+alloc_b*F106/SUM(alloc_a,alloc_b)*EXP(C107)","v":12.834802355337889},0.58238369366154252,0.5]
[93,-0.57932970223044566,-2.8932366712341281E-2,8.3209132116031745E-2,12.133913007181919,{"$f":"alloc_a*F107/SUM(alloc_a,alloc_b)*EXP(B108)+alloc_b*F107/SUM(alloc_a,alloc_b)*EXP(C108)","v":9.8298924873478946},-0.26673241841993839,0.5]
[94,-0.14256571010750896,5.5898268018604091E-2,7.2153182425332835E-2,12.831492851463736,{"$f":"alloc_a*F108/SUM(alloc_a,alloc_b)*EXP(B109)+alloc_b*F108/SUM(alloc_a,alloc_b)*EXP(C109)","v":9.4594071368303272},-3.8418286327122332E-2,0.5]
[95,0.52220722928619467,3.6086166454896942E-2,0.12163182110204765,13.302988305634557,{"$f":"alloc_a*F109/SUM(alloc_a,alloc_b)*EXP(B110)+alloc_b*F109/SUM(alloc_a,alloc_b)*EXP(C110)","v":12.876568520712617},0.3083995554064049,0.5]
[96,0.33777835097298281,-1.5031227414435213E-2,0.1705071059473274,13.104523385508269,{"$f":"alloc_a*F110/SUM(alloc_a,alloc_b)*EXP(B111)+alloc_b*F110/SUM(alloc_a,alloc_b)*EXP(C111)","v":15.367611086630482},0.17685285246480364,0.5]
[97,0.22799511069582692,-0.22510442413289389,0.2141704265154559,10.463081807145986,{"$f":"alloc_a*F111/SUM(alloc_a,alloc_b)*EXP(B112)+alloc_b*F111/SUM(alloc_a,alloc_b)*EXP(C112)","v":15.786470869700523},2.6891180705502688E-2,0.5]
[98,0.4790059784595927,-0.10316004498225066,0.34577146882894,9.4375177757306083,{"$f":"alloc_a*F112/SUM(alloc_a,alloc_b)*EXP(B113)+alloc_b*F112/SUM(alloc_a,alloc_b)*EXP(C113)","v":19.862943295086858},0.229702550654416,0.5]
[99,0.29229807490900167,7.3368575335748365E-2,0.46316165361655942,10.155968613822292,{"$f":"alloc_a*F113/SUM(alloc_a,alloc_b)*EXP(B114)+alloc_b*F113/SUM(alloc_a,alloc_b)*EXP(C114)","v":23.990754180808466},0.1888126638509896,0.5]
[100,-0.34723566044873816,-8.8686122924137883E-2,0.32728798669822068,9.294059666215313,{"$f":"alloc_a*F114/SUM(alloc_a,alloc_b)*EXP(B115)+alloc_b*F114/SUM(alloc_a,alloc_b)*EXP(C115)","v":19.453761290973368},-0.20962807971890773,0.5]