{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["treeCalc_2","Cover Page","Design 1","Design 2","Design 3","COST","REWARD","PROFIT","MAX PROFIT TREE","MAX REWARD TREE","MIN COST TREE","treeCalc_3","MIN RISK PROFIT TREE","MIN RISK REWARD TREE","treeCalc_4","treeCalc_5","MIN Pr(LOSS)","treeCalc_6","treeCalc_1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":49,"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":"treeCalc_2","index":0,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Name","MAX REWARD TREE",null,null,"Ptree1 Compatibility",3,null,"Output Label","",null,"R-Value Ref.",100]
["SheetRef",{"$f":"'MAX REWARD TREE'!#REF!","v":{"$error":"#REF!"}},null,null,"Eval. Function",{"$f":"_xll.PTreeEvaluate5(B3,$L$11:$L$20,$J$11:$J$20,$K$11:$K$20,$N$11:$N$20,$G$11:$G$20,,L1)","v":154805378}]
["GenInfo","0,2,1,0,0,Exponential, 0,0,-1,0,-1,-1,.0001",null,null,"Creation Version","6.3.0",null,"Output Value NF","<NF>"]
["Def. Link","=",null,null,"Required Version","5.0.0",null,"Output Prob NF","Automatic"]
["EXT REFS",0,null,0,"Recommended Version","5.0.0",null,"Input Value NF","<NF>"]
["Def. Form",null,null,null,"Last Modified By Version","8.2.0",null,"Input Prob NF","Automatic"]
["Calc Macro",null,null,null,null,"37001417"]
["Highest#",10]
[]
["Anchor Cell","Branch Name","bformtype","valformula","pbformula","distribution","cumPayoffFunction","link","ENDNODEFORMULA","VAL","PB","GenInfo","IntRefs","RefRefs","NodeNames","Collapsed"]
[{"$f":"'MAX REWARD TREE'!$C$5","v":953.44920000000047},{"$f":"B1","v":"MAX REWARD TREE"},0,null,null,null,null,null,"DEFAULT",{"$f":"'MAX REWARD TREE'!$B$5","v":0},{"$f":"'MAX REWARD TREE'!$B$4","v":0},"2,0,0,9,2,3,4,5,6,7,8,9,10,0,0,0","0",null,{"$f":"'MAX REWARD TREE'!$C$4","v":"Decision"},false]
[{"$f":"'MAX REWARD TREE'!$D$3","v":611.03139999999996},"ALTERNATIVE 1",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX REWARD TREE'!$C$3","v":611.03139999999996},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX REWARD TREE'!$D$7","v":697.03139999999996},"ALTERNATIVE 2",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX REWARD TREE'!$C$7","v":697.03139999999996},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX REWARD TREE'!$D$9","v":649.03139999999996},"ALTERNATIVE 3",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX REWARD TREE'!$C$9","v":649.03139999999996},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX REWARD TREE'!$D$11","v":731.13120000000094},"ALTERNATIVE 4",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX REWARD TREE'!$C$11","v":731.13120000000094},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX REWARD TREE'!$D$13","v":645.13120000000083},"ALTERNATIVE 5",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX REWARD TREE'!$C$13","v":645.13120000000083},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX REWARD TREE'!$D$15","v":683.13120000000094},"ALTERNATIVE 6",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX REWARD TREE'!$C$15","v":683.13120000000094},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX REWARD TREE'!$D$17","v":905.44920000000047},"ALTERNATIVE 7",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX REWARD TREE'!$C$17","v":905.44920000000047},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX REWARD TREE'!$D$19","v":867.44920000000047},"ALTERNATIVE 8",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX REWARD TREE'!$C$19","v":867.44920000000047},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX REWARD TREE'!$D$21","v":953.44920000000047},"ALTERNATIVE 9",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX REWARD TREE'!$C$21","v":953.44920000000047},null,"4,0,0,0,1,0,0","0",null,null,false]

{"sheet":"Cover Page","index":1,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[[21,2,21,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Design 1","Design 2","Design 3",null,null,"Team Performance -- Design 1",null,null,null,"Team Performance -- Design 2",null,null,null,"Team Performance -- Design 3"]
[null,"Wing Length, L (cm)",null,null,null,null,null,null,"Mean","S.D.",null,null,"Mean","S.D.",null,null,"Mean","S.D."]
[null,"Wing Width, W (cm)",null,null,null,null,null,"Time",null,null,null,"Time",null,null,null,"Time"]
[null,"Base Length, B (cm)",null,null,null,null,null,"Distance",null,null,null,"Distance",null,null,null,"Distance"]
[null,"Tail Height, HT (cm)"]
[null,"Body Height, HB (cm)",null,null,null,null,null,"Group Performance",null,null,null,"Group Performance",null,null,null,"Group Performance"]
[null,"Number of Paper Clips, n",null,null,null,null,null,null,"Mean ","S.D.",null,null,"Mean ","S.D.",null,null,"Mean ","S.D."]
[null,"Number of Trials, N",null,null,null,null,null,"Group Time",null,null,null,"Group Time",null,null,null,"Group Time"]
[null,null,null,null,null,null,null,"Group Distance",null,null,null,"Group Distance",null,null,null,"Group Distance"]
[null,"Total Area (cm2)",{"$f":"2*C12*C13+2*C13*C16+C14*C15","v":0},{"$f":"2*D12*D13+2*D13*D16+D14*D15","v":0},0]
[]
[null,null,"Total Costs by Design "]
["Design Costs","$",{"$f":"C11","v":"Design 1"},{"$f":"D11","v":"Design 2"},{"$f":"E11","v":"Design 3"}]
["Cost of Paper per sq. meter ($/cm2)",1,{"$f":"C20*$B$24","v":0},{"$f":"D20*$B$24","v":0},{"$f":"E20*$B$24","v":0}]
["Cost per Paper Clip ($/clip)",10,{"$f":"C17*$B$25","v":0},{"$f":"D17*$B$25","v":0},0]
["Cost of Testing if N≤50 ($/test)",0.5,{"$f":"IF(C18<=50,C18*$B$26,50*$B$26)","v":0},{"$f":"IF(D18<=50,D18*$B$26,50*$B$26)","v":0},0]
["Cost of Testing for Extra Tests ($/test)",2,{"$f":"IF(C18>50,(C18-50)*$B$27,0)","v":0},{"$f":"IF(D18>50,(D18-50)*$B$27,0)","v":0},0]
[]
[null,"Total Cost by Design",{"$f":"SUM(C24:C25)","v":0},{"$f":"SUM(D24:D25)","v":0},{"$f":"SUM(E24:E25)","v":0}]
[null,"Reward for time",{"$f":"D1_TimeReward","v":{"$error":"#NUM!"}},{"$f":"D2_TimeReward","v":{"$error":"#NUM!"}},{"$f":"D3_TimeReward","v":{"$error":"#NUM!"}}]
[null,"Reward for distance",{"$f":"D1_DistanceReward","v":{"$error":"#NUM!"}},{"$f":"D2_DistanceReward","v":{"$error":"#NUM!"}},{"$f":"D3_DistanceReward","v":{"$error":"#NUM!"}}]
[null,"Profit/Loss by Design",{"$f":"C30+C31-C29","v":{"$error":"#NUM!"}},{"$f":"D30+D31-D29","v":{"$error":"#NUM!"}},{"$f":"E30+E31-E29","v":{"$error":"#NUM!"}}]
[]
[null,"Overall Profit/Loss",{"$f":"SUM(C32:E32)-SUM(C26:C27)","v":{"$error":"#NUM!"}}]
[]
[]
["Alternatives","Design (Flight & Distance)","Total Cost","Total Reward","Profit/Loss"]
[1,"Both are Design 1 ",{"$f":"D1_TotalCost","v":0},{"$f":"D1_TotalReward+C31","v":{"$error":"#NUM!"}},{"$f":"D38-C38-SUM($C$26:$C$27)","v":{"$error":"#NUM!"}}]
[2,"D1 and D2",{"$f":"D1_TotalCost+D2_TotalCost","v":0},{"$f":"D1_TotalReward+D31","v":{"$error":"#NUM!"}},{"$f":"D39-C39-SUM($C$26:$C$27)","v":{"$error":"#NUM!"}}]
[3,"D1 and D3",{"$f":"D1_TotalCost+D3_TotalCost","v":0},{"$f":"D1_TotalReward+E31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[4,"Both are Design 2",{"$f":"D2_TotalCost","v":0},{"$f":"D2_TotalReward+D31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[5,"D2 and D1",{"$f":"D1_TotalCost+D2_TotalCost","v":0},{"$f":"D2_TotalReward+C31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[6,"D2 and D3",{"$f":"D2_TotalCost+D3_TotalCost","v":0},{"$f":"D2_TotalReward+E31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[7,"Both are Design 3",{"$f":"D3_TotalCost","v":0},{"$f":"D3_TotalReward+E31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[8,"D3 and D1",{"$f":"D1_TotalCost+D3_TotalCost","v":0},{"$f":"D3_TotalReward+C31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[9,"D3 and D2",{"$f":"D2_TotalCost+D3_TotalCost","v":0},{"$f":"D3_TotalReward+D31","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[]
[null,null,null,"MAX PROFIT",{"$f":"MAX(E38:E46)","v":{"$error":"#NUM!"}}]
["Number of Samples",100]

{"sheet":"Design 1","index":2,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Materials "]
["    Variable Costs","Cost",null,null,"Area Paremeters"]
["Paper Clips",{"$f":"'Cover Page'!C25","v":0},null,null,"Wing Length, L",{"$f":"'Cover Page'!C12","v":0}]
["Cost of Paper",{"$f":"'Cover Page'!C24","v":0},null,null,"Wing Width, W",{"$f":"'Cover Page'!C13","v":0}]
["Testing Cost",{"$f":"SUM('Cover Page'!C26:C27)","v":0},null,null,"Base Length, B",{"$f":"'Cover Page'!C14","v":0}]
["Total Cost",{"$f":"SUM(B3:B5)","v":0},null,null,"Tail Height, HT",{"$f":"'Cover Page'!C15","v":0}]
[null,null,null,null,"Body Height, HB",{"$f":"'Cover Page'!C16","v":0}]
["Team Performance"]
[null,"Mean","S.D."]
["Time",{"$f":"'Cover Page'!I13","v":0},{"$f":"'Cover Page'!J13","v":0}]
["Distance",{"$f":"'Cover Page'!I14","v":0},{"$f":"'Cover Page'!J14","v":0},null,null,null,null,null,"Group Time 1","Group Time 2","Group Time 3","Best Time"]
[null,null,null,null,null,null,null,null,{"$f":"B23","v":{"$error":"#NUM!"}},{"$f":"C23","v":{"$error":"#NUM!"}},{"$f":"D23","v":{"$error":"#NUM!"}},{"$f":"E23","v":{"$error":"#NUM!"}}]
["Simulation","1st Trial","2nd Trial","3rd Trial","Best Time",null,null,1,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Time",{"$f":"NORMINV(RAND(),$B$10,$C$10)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$10,$C$10)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$10,$C$10)","v":{"$error":"#NUM!"}},{"$f":"MAX(B14:D14)","v":{"$error":"#NUM!"}},null,null,2,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Distance",{"$f":"NORMINV(RAND(),$B$11,$C$11)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$11,$C$11)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$11,$C$11)","v":{"$error":"#NUM!"}},{"$f":"SUM(B15:D15)","v":{"$error":"#NUM!"}},null,null,3,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,4,{"$f":"B14","v":{"$error":"#NUM!"}},{"$f":"C14","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Group Performance"]
[null,"Mean ","S.D."]
["Group Time",{"$f":"'Cover Page'!I18","v":0},{"$f":"'Cover Page'!J18","v":0}]
["Group Distance",{"$f":"'Cover Page'!I19","v":0},{"$f":"'Cover Page'!J19","v":0}]
[null,null,null,null,null,null,null,null,"Group Dist 1","Group Dist 2","Group Dist 3","Total"]
["Simulation","1st Trial","2nd Trial","3rd Trial","Best Time",null,null,null,{"$f":"B24","v":{"$error":"#NUM!"}},{"$f":"C24","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Time",{"$f":"NORMINV(RAND(),$B$19,$C$19)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$19,$C$19)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$19,$C$19)","v":{"$error":"#NUM!"}},{"$f":"MAX(B23:D23)","v":{"$error":"#NUM!"}},null,null,1,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Distance",{"$f":"NORMINV(RAND(),$B$20,$C$20)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$20,$C$20)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"SUM(B24:D24)","v":{"$error":"#NUM!"}},null,null,2,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,3,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Ranking",null,null,null,null,null,null,4,{"$f":"B15","v":{"$error":"#NUM!"}},{"$f":"C15","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Time Rank",{"$f":"RANK(L16,L13:L16,0)","v":{"$error":"#NUM!"}}]
["Distance Rank",{"$f":"RANK(L26,L23:L26,1)","v":{"$error":"#NUM!"}}]
[]
["Reward"]
["Time","Prize"]
["Best ",1000]
["Worst ",10]
[]
["Normalized rank (0-1)",{"$f":"(B27-H13)/(H16-H13)","v":{"$error":"#NUM!"}}]
["Time Reward",{"$f":"B32*(B33/B32)^B35","v":{"$error":"#NUM!"}}]
[]
["Distance","Prize"]
["Best ",500]
["Second Place",100]
["Others",0]
[]
["Distance Reward",{"$f":"IF(B28=1,B39,IF(B28=2,B40,B41))","v":{"$error":"#NUM!"}}]
[]
["Total Reward",{"$f":"B36+B43","v":{"$error":"#NUM!"}}]

{"sheet":"Design 2","index":3,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Materials "]
["    Variable Costs","Cost",null,null,"Area Paremeters"]
["Paper Clips",{"$f":"'Cover Page'!D25","v":0},null,null,"Wing Length, L",{"$f":"'Cover Page'!D12","v":0}]
["Cost of Paper",{"$f":"'Cover Page'!D24","v":0},null,null,"Wing Width, W",{"$f":"'Cover Page'!D13","v":0}]
["Testing Cost",{"$f":"SUM('Cover Page'!D26:D27)","v":0},null,null,"Base Length, B",{"$f":"'Cover Page'!D14","v":0}]
["Total Cost",{"$f":"SUM(B3:B5)","v":0},null,null,"Tail Height, HT",{"$f":"'Cover Page'!D15","v":0}]
[null,null,null,null,"Body Height, HB",{"$f":"'Cover Page'!D16","v":0}]
["Team Performance"]
[null,"Mean","S.D."]
["Time",{"$f":"'Cover Page'!M13","v":0},{"$f":"'Cover Page'!N13","v":0}]
["Distance",{"$f":"'Cover Page'!M14","v":0},{"$f":"'Cover Page'!N14","v":0},null,null,null,null,null,"Group Time 1","Group Time 2","Group Time 3","Best Time"]
[null,null,null,null,null,null,null,null,{"$f":"B23","v":{"$error":"#NUM!"}},{"$f":"C23","v":{"$error":"#NUM!"}},{"$f":"D23","v":{"$error":"#NUM!"}},{"$f":"E23","v":{"$error":"#NUM!"}}]
["Simulation","1st Trial","2nd Trial","3rd Trial","Best Time",null,null,1,3.0430533738158583,2.8775196061156052,2.7384607568937214,3.0430533738158583]
["Time",{"$f":"NORMINV(RAND(),$B$10,$C$10)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$10,$C$10)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"MAX(B14:D14)","v":{"$error":"#NUM!"}},null,null,2,1.9948672987731637,3.5801246725873663,1.9981111284992084,3.5801246725873663]
["Distance",{"$f":"NORMINV(RAND(),$B$11,$C$11)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$11,$C$11)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"SUM(B15:D15)","v":{"$error":"#NUM!"}},null,null,3,4.10821940609131,2.9829249706093366,2.8798762082311615,4.10821940609131]
[null,null,null,null,null,null,null,4,{"$f":"B14","v":{"$error":"#NUM!"}},{"$f":"C14","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Group Performance"]
[null,"Mean ","S.D."]
["Group Time",{"$f":"'Cover Page'!M18","v":0},{"$f":"'Cover Page'!N18","v":0}]
["Group Distance",{"$f":"'Cover Page'!M19","v":0},{"$f":"'Cover Page'!N19","v":0}]
[null,null,null,null,null,null,null,null,"Group Dist 1","Group Dist 2","Group Dist 3","Total"]
["Simulation","1st Trial","2nd Trial","3rd Trial","Best Time",null,null,null,{"$f":"B24","v":{"$error":"#NUM!"}},{"$f":"C24","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Time",{"$f":"NORMINV(RAND(),$B$19,$C$19)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$19,$C$19)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$19,$C$19)","v":{"$error":"#NUM!"}},{"$f":"MAX(B23:D23)","v":{"$error":"#NUM!"}},null,null,1,0.48565425474803348,1.2228297651069617,0.10073308962778427,1.8092171094827796]
["Distance",{"$f":"NORMINV(RAND(),$B$20,$C$20)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$20,$C$20)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"SUM(B24:D24)","v":{"$error":"#NUM!"}},null,null,2,1.4257362300929715,0.13820334305485815,-0.18760640791822281,1.3763331652296067]
[null,null,null,null,null,null,null,3,0.62526184789769268,1.9462231160703114E-2,1.2805466006412431,1.9252706796996391]
["Ranking",null,null,null,null,null,null,4,{"$f":"B15","v":{"$error":"#NUM!"}},{"$f":"C15","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Time Rank",{"$f":"RANK(L16,L13:L16,0)","v":{"$error":"#NUM!"}}]
["Distance Rank",{"$f":"RANK(L26,L23:L26,1)","v":{"$error":"#NUM!"}}]
[]
["Reward"]
["Time","Prize"]
["Best ",1000]
["Worst ",10]
[]
["Normalized rank (0-1)",{"$f":"(B27-H13)/(H16-H13)","v":{"$error":"#NUM!"}}]
["Time Reward",{"$f":"B32*(B33/B32)^B35","v":{"$error":"#NUM!"}}]
[]
["Distance","Prize"]
["Best ",500]
["Second Place",100]
["Others",0]
[]
["Distance Reward",{"$f":"IF(B28=1,B39,IF(B28=2,B40,B41))","v":{"$error":"#NUM!"}}]
[]
["Total Reward",{"$f":"B36+B43","v":{"$error":"#NUM!"}}]

{"sheet":"Design 3","index":4,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Materials "]
["    Variable Costs","Cost",null,null,"Area Paremeters"]
["Paper Clips",{"$f":"'Cover Page'!E25","v":0},null,null,"Wing Length, L",{"$f":"'Cover Page'!E12","v":0}]
["Cost of Paper",{"$f":"'Cover Page'!E24","v":0},null,null,"Wing Width, W",{"$f":"'Cover Page'!E13","v":0}]
["Testing Cost",{"$f":"SUM('Cover Page'!E26:E27)","v":0},null,null,"Base Length, B",{"$f":"'Cover Page'!E14","v":0}]
["Total Cost",{"$f":"SUM(B3:B5)","v":0},null,null,"Tail Height, HT",{"$f":"'Cover Page'!E15","v":0}]
[null,null,null,null,"Body Height, HB",{"$f":"'Cover Page'!E16","v":0}]
["Team Performance"]
[null,"Mean","S.D."]
["Time",{"$f":"'Cover Page'!Q13","v":0},{"$f":"'Cover Page'!R13","v":0}]
["Distance",{"$f":"'Cover Page'!Q14","v":0},{"$f":"'Cover Page'!R14","v":0},null,null,null,null,null,"Group Time 1","Group Time 2","Group Time 3","Best Time"]
[null,null,null,null,null,null,null,null,{"$f":"B23","v":{"$error":"#NUM!"}},{"$f":"C23","v":{"$error":"#NUM!"}},{"$f":"D23","v":{"$error":"#NUM!"}},{"$f":"E23","v":{"$error":"#NUM!"}}]
["Simulation","1st Trial","2nd Trial","3rd Trial","Best Time",null,null,1,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Time",{"$f":"NORMINV(RAND(),$B$10,$C$10)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$10,$C$10)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$10,$C$10)","v":{"$error":"#NUM!"}},{"$f":"MAX(B14:D14)","v":{"$error":"#NUM!"}},null,null,2,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Distance",{"$f":"NORMINV(RAND(),$B$11,$C$11)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$11,$C$11)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"SUM(B15:D15)","v":{"$error":"#NUM!"}},null,null,3,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,4,{"$f":"B14","v":{"$error":"#NUM!"}},{"$f":"C14","v":{"$error":"#NUM!"}},{"$f":"D14","v":{"$error":"#NUM!"}},{"$f":"E14","v":{"$error":"#NUM!"}}]
["Group Performance"]
[null,"Mean ","S.D."]
["Group Time",{"$f":"'Cover Page'!Q18","v":0},{"$f":"'Cover Page'!R18","v":0}]
["Group Distance",{"$f":"'Cover Page'!Q19","v":0},{"$f":"'Cover Page'!R19","v":0}]
[null,null,null,null,null,null,null,null,"Group Dist 1","Group Dist 2","Group Dist 3","Total"]
["Simulation","1st Trial","2nd Trial","3rd Trial","Best Time",null,null,null,{"$f":"B24","v":{"$error":"#NUM!"}},{"$f":"C24","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Time",{"$f":"NORMINV(RAND(),$B$19,$C$19)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$19,$C$19)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$19,$C$19)","v":{"$error":"#NUM!"}},{"$f":"MAX(B23:D23)","v":{"$error":"#NUM!"}},null,null,1,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Distance",{"$f":"NORMINV(RAND(),$B$20,$C$20)","v":{"$error":"#NUM!"}},{"$f":"NORMINV(RAND(),$B$20,$C$20)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"SUM(B24:D24)","v":{"$error":"#NUM!"}},null,null,2,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,null,null,null,null,null,3,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
["Ranking",null,null,null,null,null,null,5,{"$f":"B15","v":{"$error":"#NUM!"}},{"$f":"C15","v":{"$error":"#NUM!"}},{"$f":"D15","v":{"$error":"#NUM!"}},{"$f":"E15","v":{"$error":"#NUM!"}}]
["Time Rank",{"$f":"RANK(L16,L13:L16,0)","v":{"$error":"#NUM!"}}]
["Distance Rank",{"$f":"RANK(L26,L23:L26,1)","v":{"$error":"#NUM!"}}]
[]
["Reward"]
["Time","Prize"]
["Best ",1000]
["Worst ",10]
[]
["Normalized rank (0-1)",{"$f":"(B27-H13)/(H16-H13)","v":{"$error":"#NUM!"}}]
["Time Reward",{"$f":"B32*(B33/B32)^B35","v":{"$error":"#NUM!"}}]
[]
["Distance","Prize"]
["Best ",500]
["Second Place",100]
["Others",0]
[]
["Distance Reward",{"$f":"IF(B28=1,B39,IF(B28=2,B40,B41))","v":{"$error":"#NUM!"}}]
[]
["Total Reward",{"$f":"B36+B43","v":{"$error":"#NUM!"}}]

{"sheet":"COST","index":5,"n_rows":1008,"n_cols":11,"rows_kept":1008,"cut":false,"hidden":false,"merged":[]}
[100]
[]
[null,"Alt. 1","Alt. 2","Alt. 3","Alt. 4","Alt. 5","Alt. 6","Alt. 7","Alt. 8","Alt. 9","OPTIMAL"]
["Average",{"$f":"AVERAGE(B9:B1008)","v":151},{"$f":"AVERAGE(C9:C1008)","v":283},227,132,283,208,76,227,208,{"$f":"MIN(B4:J4)","v":76}]
["StDev",{"$f":"STDEV(B9:B1008)","v":0},{"$f":"STDEV(C9:C1008)","v":0},0,0,0,0,0,0,0,{"$f":"MIN(B5:J5)","v":0}]
[]
[]
[null,"Alt. 1","Alt. 2","Alt. 3","Alt. 4","Alt. 5","Alt. 6","Alt. 7","Alt. 8","Alt. 9"]
[1,151,283,227,132,283,208,76,227,208]
[{"$f":"A9+1","v":2},151,283,227,132,283,208,76,227,208]
[{"$f":"A10+1","v":3},151,283,227,132,283,208,76,227,208]
[4,151,283,227,132,283,208,76,227,208]
[5,151,283,227,132,283,208,76,227,208]
[6,151,283,227,132,283,208,76,227,208]
[7,151,283,227,132,283,208,76,227,208]
[8,151,283,227,132,283,208,76,227,208]
[9,151,283,227,132,283,208,76,227,208]
[10,151,283,227,132,283,208,76,227,208]
[11,151,283,227,132,283,208,76,227,208]
[12,151,283,227,132,283,208,76,227,208]
[13,151,283,227,132,283,208,76,227,208]
[14,151,283,227,132,283,208,76,227,208]
[15,151,283,227,132,283,208,76,227,208]
[16,151,283,227,132,283,208,76,227,208]
[17,151,283,227,132,283,208,76,227,208]
[18,151,283,227,132,283,208,76,227,208]
[19,151,283,227,132,283,208,76,227,208]
[20,151,283,227,132,283,208,76,227,208]
[21,151,283,227,132,283,208,76,227,208]
[22,151,283,227,132,283,208,76,227,208]
[23,151,283,227,132,283,208,76,227,208]
[24,151,283,227,132,283,208,76,227,208]
[25,151,283,227,132,283,208,76,227,208]
[26,151,283,227,132,283,208,76,227,208]
[27,151,283,227,132,283,208,76,227,208]
[28,151,283,227,132,283,208,76,227,208]
[29,151,283,227,132,283,208,76,227,208]
[30,151,283,227,132,283,208,76,227,208]
[31,151,283,227,132,283,208,76,227,208]
[32,151,283,227,132,283,208,76,227,208]
[33,151,283,227,132,283,208,76,227,208]
[34,151,283,227,132,283,208,76,227,208]
[35,151,283,227,132,283,208,76,227,208]
[36,151,283,227,132,283,208,76,227,208]
[37,151,283,227,132,283,208,76,227,208]
[38,151,283,227,132,283,208,76,227,208]
[39,151,283,227,132,283,208,76,227,208]
[40,151,283,227,132,283,208,76,227,208]
[41,151,283,227,132,283,208,76,227,208]
[42,151,283,227,132,283,208,76,227,208]
[43,151,283,227,132,283,208,76,227,208]
[44,151,283,227,132,283,208,76,227,208]
[45,151,283,227,132,283,208,76,227,208]
[46,151,283,227,132,283,208,76,227,208]
[47,151,283,227,132,283,208,76,227,208]
[48,151,283,227,132,283,208,76,227,208]
[49,151,283,227,132,283,208,76,227,208]
[50,151,283,227,132,283,208,76,227,208]
[51,151,283,227,132,283,208,76,227,208]
[52,151,283,227,132,283,208,76,227,208]
[53,151,283,227,132,283,208,76,227,208]
[54,151,283,227,132,283,208,76,227,208]
[55,151,283,227,132,283,208,76,227,208]
[56,151,283,227,132,283,208,76,227,208]
[57,151,283,227,132,283,208,76,227,208]
[58,151,283,227,132,283,208,76,227,208]
[59,151,283,227,132,283,208,76,227,208]
[60,151,283,227,132,283,208,76,227,208]
[61,151,283,227,132,283,208,76,227,208]
[62,151,283,227,132,283,208,76,227,208]
[63,151,283,227,132,283,208,76,227,208]
[64,151,283,227,132,283,208,76,227,208]
[65,151,283,227,132,283,208,76,227,208]
[66,151,283,227,132,283,208,76,227,208]
[{"$f":"A74+1","v":67},151,283,227,132,283,208,76,227,208]
[68,151,283,227,132,283,208,76,227,208]
[69,151,283,227,132,283,208,76,227,208]
[70,151,283,227,132,283,208,76,227,208]
[71,151,283,227,132,283,208,76,227,208]
[72,151,283,227,132,283,208,76,227,208]
[73,151,283,227,132,283,208,76,227,208]
[74,151,283,227,132,283,208,76,227,208]
[75,151,283,227,132,283,208,76,227,208]
[76,151,283,227,132,283,208,76,227,208]
[77,151,283,227,132,283,208,76,227,208]
[78,151,283,227,132,283,208,76,227,208]
[79,151,283,227,132,283,208,76,227,208]
[80,151,283,227,132,283,208,76,227,208]
[81,151,283,227,132,283,208,76,227,208]
[82,151,283,227,132,283,208,76,227,208]
[83,151,283,227,132,283,208,76,227,208]
[84,151,283,227,132,283,208,76,227,208]
[85,151,283,227,132,283,208,76,227,208]
[86,151,283,227,132,283,208,76,227,208]
[87,151,283,227,132,283,208,76,227,208]
[88,151,283,227,132,283,208,76,227,208]
[89,151,283,227,132,283,208,76,227,208]
[90,151,283,227,132,283,208,76,227,208]
[91,151,283,227,132,283,208,76,227,208]
[92,151,283,227,132,283,208,76,227,208]
[93,151,283,227,132,283,208,76,227,208]
[94,151,283,227,132,283,208,76,227,208]
[95,151,283,227,132,283,208,76,227,208]
[96,151,283,227,132,283,208,76,227,208]
[97,151,283,227,132,283,208,76,227,208]
[98,151,283,227,132,283,208,76,227,208]
[99,151,283,227,132,283,208,76,227,208]
[100,151,283,227,132,283,208,76,227,208]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"A138+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"A202+1","v":195}]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[{"$f":"A266+1","v":259}]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[{"$f":"A330+1","v":323}]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[{"$f":"A394+1","v":387}]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[{"$f":"A458+1","v":451}]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[514]
[{"$f":"A522+1","v":515}]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[578]
[{"$f":"A586+1","v":579}]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[642]
[{"$f":"A650+1","v":643}]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[706]
[{"$f":"A714+1","v":707}]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[770]
[{"$f":"A778+1","v":771}]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[834]
[{"$f":"A842+1","v":835}]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[898]
[{"$f":"A906+1","v":899}]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[962]
[{"$f":"A970+1","v":963}]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]

{"sheet":"REWARD","index":6,"n_rows":1008,"n_cols":11,"rows_kept":1008,"cut":false,"hidden":false,"merged":[]}
[100]
[]
[null,"Alt. 1","Alt. 2","Alt. 3","Alt. 4","Alt. 5","Alt. 6","Alt. 7","Alt. 8","Alt. 9","OPTIMAL"]
["Average",{"$f":"AVERAGE(B9:B1008)","v":611.03139999999996},{"$f":"AVERAGE(C9:C1008)","v":697.03139999999996},649.03139999999996,731.13120000000094,645.13120000000083,683.13120000000094,905.44920000000047,867.44920000000047,953.44920000000047,{"$f":"MIN(B4:J4)","v":611.03139999999996}]
["StDev",{"$f":"STDEV(B9:B1008)","v":313.33192014194566},{"$f":"STDEV(C9:C1008)","v":282.63379321788034},300.32597922257798,110.39174556756659,207.84454300055793,175.4268367873392,424.26252873455911,435.39296723133373,408.49195824998725,{"$f":"MIN(B5:J5)","v":110.39174556756659}]
[]
[]
[null,"Alt. 1","Alt. 2","Alt. 3","Alt. 4","Alt. 5","Alt. 6","Alt. 7","Alt. 8","Alt. 9"]
[1,1100,1500,1500,715.44,315.44,715.44,715.44,315.44,715.44]
[{"$f":"A9+1","v":2},715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44]
[{"$f":"A10+1","v":3},110,510,510,715.44,315.44,715.44,715.44,315.44,715.44]
[4,46.42,546.41999999999996,546.41999999999996,715.44,215.44,715.44,546.41999999999996,46.42,546.41999999999996]
[5,110,510,510,715.44,315.44,715.44,715.44,315.44,715.44]
[6,510,510,510,715.44,715.44,715.44,715.44,715.44,715.44]
[7,510,510,510,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[8,715.44,715.44,715.44,715.44,715.44,715.44,1500,1500,1500]
[9,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44]
[10,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44]
[11,510,510,110,715.44,715.44,315.44,315.44,715.44,715.44]
[12,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[13,146.41999999999999,546.41999999999996,546.41999999999996,715.44,315.44,715.44,1500,1100,1500]
[14,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[15,510,510,510,715.44,715.44,715.44,715.44,715.44,715.44]
[16,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[17,715.44,715.44,715.44,715.44,715.44,715.44,1500,1500,1500]
[18,315.44,715.44,715.44,715.44,315.44,715.44,715.44,315.44,715.44]
[19,715.44,715.44,715.44,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[20,546.41999999999996,546.41999999999996,146.41999999999999,715.44,715.44,315.44,1100,1500,1500]
[21,715.44,715.44,715.44,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[22,715.44,715.44,715.44,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[23,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[24,315.44,715.44,715.44,715.44,315.44,715.44,715.44,315.44,715.44]
[25,1500,1500,1500,715.44,715.44,715.44,715.44,715.44,715.44]
[26,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[27,110,510,510,715.44,315.44,715.44,1500,1100,1500]
[28,715.44,715.44,715.44,715.44,715.44,715.44,1500,1500,1500]
[29,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,1500,1500,1500]
[30,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,1500,1500,1500]
[31,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[32,1100,1500,1500,715.44,315.44,715.44,1500,1100,1500]
[33,510,510,510,715.44,715.44,715.44,715.44,715.44,715.44]
[34,315.44,715.44,715.44,715.44,315.44,715.44,715.44,315.44,715.44]
[35,315.44,715.44,715.44,715.44,315.44,715.44,715.44,315.44,715.44]
[36,1500,1500,1500,715.44,715.44,715.44,1500,1500,1500]
[37,315.44,715.44,715.44,715.44,315.44,715.44,1500,1100,1500]
[38,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44]
[39,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[40,510,510,510,1500,1500,1500,1500,1500,1500]
[41,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,1500,1500,1500]
[42,510,510,510,715.44,715.44,715.44,1500,1500,1500]
[43,315.44,715.44,715.44,715.44,315.44,715.44,1500,1100,1500]
[44,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[45,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[46,315.44,715.44,715.44,715.44,315.44,715.44,1500,1100,1500]
[47,510,510,510,715.44,715.44,715.44,715.44,715.44,715.44]
[48,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44]
[49,146.41999999999999,546.41999999999996,546.41999999999996,715.44,315.44,715.44,1500,1100,1500]
[50,715.44,715.44,315.44,715.44,715.44,315.44,315.44,715.44,715.44]
[51,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[52,146.41999999999999,546.41999999999996,546.41999999999996,715.44,315.44,715.44,715.44,315.44,715.44]
[53,1500,1500,1500,715.44,715.44,715.44,1500,1500,1500]
[54,1500,1500,1500,715.44,715.44,715.44,1500,1500,1500]
[55,715.44,715.44,315.44,715.44,715.44,315.44,110,510,510]
[56,1500,1500,1500,715.44,715.44,715.44,715.44,715.44,715.44]
[57,1500,1500,1500,715.44,715.44,715.44,1500,1500,1500]
[58,510,510,510,715.44,715.44,715.44,715.44,715.44,715.44]
[59,715.44,715.44,715.44,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[60,715.44,715.44,715.44,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[61,546.41999999999996,546.41999999999996,546.41999999999996,1500,1500,1500,715.44,715.44,715.44]
[62,1500,1500,1100,715.44,715.44,315.44,1100,1500,1500]
[63,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[64,715.44,715.44,715.44,715.44,715.44,715.44,1500,1500,1500]
[65,510,510,110,715.44,715.44,315.44,1100,1500,1500]
[66,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,1500,1500,1500]
[{"$f":"A74+1","v":67},510,510,510,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[68,715.44,715.44,715.44,715.44,715.44,715.44,510,510,510]
[69,315.44,715.44,315.44,715.44,315.44,315.44,1100,1100,1500]
[70,510,510,110,715.44,715.44,315.44,315.44,715.44,715.44]
[71,715.44,715.44,715.44,715.44,715.44,715.44,1500,1500,1500]
[72,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44]
[73,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[74,715.44,715.44,315.44,715.44,715.44,315.44,1100,1500,1500]
[75,510,510,510,715.44,715.44,715.44,1500,1500,1500]
[76,315.44,715.44,715.44,715.44,315.44,715.44,715.44,315.44,715.44]
[77,110,510,510,715.44,315.44,715.44,715.44,315.44,715.44]
[78,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,1500,1500,1500]
[79,715.44,715.44,715.44,715.44,715.44,715.44,1500,1500,1500]
[80,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[81,715.44,715.44,315.44,715.44,715.44,315.44,315.44,715.44,715.44]
[82,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[83,715.44,715.44,715.44,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[84,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44]
[85,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[86,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,1500,1500,1500]
[87,715.44,715.44,715.44,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[88,510,510,510,715.44,715.44,715.44,715.44,715.44,715.44]
[89,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,546.41999999999996,546.41999999999996,546.41999999999996]
[90,546.41999999999996,546.41999999999996,146.41999999999999,715.44,715.44,315.44,146.41999999999999,546.41999999999996,546.41999999999996]
[91,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,1500,1500,1500]
[92,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[93,1000,1500,1100,715.44,215.44,315.44,110,10,510]
[94,546.41999999999996,546.41999999999996,546.41999999999996,715.44,715.44,715.44,715.44,715.44,715.44]
[95,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44]
[96,510,510,510,715.44,715.44,715.44,1500,1500,1500]
[97,146.41999999999999,546.41999999999996,546.41999999999996,715.44,315.44,715.44,715.44,315.44,715.44]
[98,510,510,510,715.44,715.44,715.44,1500,1500,1500]
[99,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44,715.44]
[100,715.44,715.44,715.44,715.44,715.44,715.44,1500,1500,1500]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"A138+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"A202+1","v":195}]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[{"$f":"A266+1","v":259}]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[{"$f":"A330+1","v":323}]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[{"$f":"A394+1","v":387}]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[{"$f":"A458+1","v":451}]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[514]
[{"$f":"A522+1","v":515}]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[578]
[{"$f":"A586+1","v":579}]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[642]
[{"$f":"A650+1","v":643}]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[706]
[{"$f":"A714+1","v":707}]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[770]
[{"$f":"A778+1","v":771}]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[834]
[{"$f":"A842+1","v":835}]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[898]
[{"$f":"A906+1","v":899}]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[962]
[{"$f":"A970+1","v":963}]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]

{"sheet":"PROFIT","index":7,"n_rows":1008,"n_cols":11,"rows_kept":1008,"cut":false,"hidden":false,"merged":[]}
[100]
[]
[null,"Alt. 1","Alt. 2","Alt. 3","Alt. 4","Alt. 5","Alt. 6","Alt. 7","Alt. 8","Alt. 9","OPTIMAL"]
["Average",{"$f":"AVERAGE(B9:B1008)","v":427.03139999999968},381.03139999999956,389.03139999999956,566.13120000000072,329.13119999999952,442.13120000000026,796.44920000000047,607.44920000000013,712.44920000000025,{"$f":"MAX(B4:J4)","v":796.44920000000047}]
["StDev",{"$f":"STDEV(B9:B1008)","v":313.33192014194589},282.63379321788074,300.32597922257844,110.39174556756232,207.84454300055953,175.42683678733962,424.26252873455826,435.39296723133316,408.49195824998696,{"$f":"MIN(B5:J5)","v":110.39174556756232}]
["Pr(Loss)",{"$f":"COUNTIF(B9:B1008,\"<0\")/$A$1","v":0.09},{"$f":"COUNTIF(C9:C1008,\"<0\")/$A$1","v":0},0.05,0,0.21,0,0,0.02,0,{"$f":"MIN(B6:J6)","v":0}]
[]
[null,"Alt. 1","Alt. 2","Alt. 3","Alt. 4","Alt. 5","Alt. 6","Alt. 7","Alt. 8","Alt. 9"]
[1,916,1184,1240,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[{"$f":"A9+1","v":2},531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[3,-74,194,250,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[4,-137.58000000000001,230.42,286.42,550.44000000000005,-100.56,474.44,437.42,-213.58,305.42]
[5,-74,194,250,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[6,326,194,250,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[7,326,194,250,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[8,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,1391,1240,1259]
[9,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[10,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[11,326,194,-150,550.44000000000005,399.44,74.44,206.44,455.44,474.44]
[12,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[13,-37.58,230.42,286.42,550.44000000000005,-0.56000000000000005,474.44,1391,840,1259]
[14,362.42,230.42,286.42,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[15,326,194,250,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[16,362.42,230.42,286.42,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[17,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,1391,1240,1259]
[18,131.44,399.44,455.44,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[19,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[20,362.42,230.42,-113.58,550.44000000000005,399.44,74.44,991,1240,1259]
[21,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[22,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[23,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[24,131.44,399.44,455.44,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[25,1316,1184,1240,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[26,362.42,230.42,286.42,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[27,-74,194,250,550.44000000000005,-0.56000000000000005,474.44,1391,840,1259]
[28,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,1391,1240,1259]
[29,362.42,230.42,286.42,550.44000000000005,399.44,474.44,1391,1240,1259]
[30,362.42,230.42,286.42,550.44000000000005,399.44,474.44,1391,1240,1259]
[31,362.42,230.42,286.42,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[32,916,1184,1240,550.44000000000005,-0.56000000000000005,474.44,1391,840,1259]
[33,326,194,250,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[34,131.44,399.44,455.44,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[35,131.44,399.44,455.44,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[36,1316,1184,1240,550.44000000000005,399.44,474.44,1391,1240,1259]
[37,131.44,399.44,455.44,550.44000000000005,-0.56000000000000005,474.44,1391,840,1259]
[38,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[39,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[40,326,194,250,1335,1184,1259,1391,1240,1259]
[41,362.42,230.42,286.42,550.44000000000005,399.44,474.44,1391,1240,1259]
[42,326,194,250,550.44000000000005,399.44,474.44,1391,1240,1259]
[43,131.44,399.44,455.44,550.44000000000005,-0.56000000000000005,474.44,1391,840,1259]
[44,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[45,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[46,131.44,399.44,455.44,550.44000000000005,-0.56000000000000005,474.44,1391,840,1259]
[47,326,194,250,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[48,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[49,-37.58,230.42,286.42,550.44000000000005,-0.56000000000000005,474.44,1391,840,1259]
[50,531.44000000000005,399.44,55.44,550.44000000000005,399.44,74.44,206.44,455.44,474.44]
[51,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[52,-37.58,230.42,286.42,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[53,1316,1184,1240,550.44000000000005,399.44,474.44,1391,1240,1259]
[54,1316,1184,1240,550.44000000000005,399.44,474.44,1391,1240,1259]
[55,531.44000000000005,399.44,55.44,550.44000000000005,399.44,74.44,1,250,269]
[56,1316,1184,1240,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[57,1316,1184,1240,550.44000000000005,399.44,474.44,1391,1240,1259]
[58,326,194,250,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[59,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[60,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[61,362.42,230.42,286.42,1335,1184,1259,606.44000000000005,455.44,474.44]
[62,1316,1184,840,550.44000000000005,399.44,74.44,991,1240,1259]
[63,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[64,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,1391,1240,1259]
[65,326,194,-150,550.44000000000005,399.44,74.44,991,1240,1259]
[{"$f":"A73+1","v":66},362.42,230.42,286.42,550.44000000000005,399.44,474.44,1391,1240,1259]
[67,326,194,250,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[68,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,401,250,269]
[69,131.44,399.44,55.44,550.44000000000005,-0.56000000000000005,74.44,991,840,1259]
[70,326,194,-150,550.44000000000005,399.44,74.44,206.44,455.44,474.44]
[71,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,1391,1240,1259]
[72,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[73,362.42,230.42,286.42,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[74,531.44000000000005,399.44,55.44,550.44000000000005,399.44,74.44,991,1240,1259]
[75,326,194,250,550.44000000000005,399.44,474.44,1391,1240,1259]
[76,131.44,399.44,455.44,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[77,-74,194,250,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[78,362.42,230.42,286.42,550.44000000000005,399.44,474.44,1391,1240,1259]
[79,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,1391,1240,1259]
[80,362.42,230.42,286.42,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[81,531.44000000000005,399.44,55.44,550.44000000000005,399.44,74.44,206.44,455.44,474.44]
[82,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[83,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[84,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[85,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[86,362.42,230.42,286.42,550.44000000000005,399.44,474.44,1391,1240,1259]
[87,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[88,326,194,250,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[89,362.42,230.42,286.42,550.44000000000005,399.44,474.44,437.42,286.42,305.42]
[90,362.42,230.42,-113.58,550.44000000000005,399.44,74.44,37.42,286.42,305.42]
[91,362.42,230.42,286.42,550.44000000000005,399.44,474.44,1391,1240,1259]
[92,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[93,816,1184,840,550.44000000000005,-100.56,74.44,1,-250,269]
[94,362.42,230.42,286.42,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[95,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[96,326,194,250,550.44000000000005,399.44,474.44,1391,1240,1259]
[97,-37.58,230.42,286.42,550.44000000000005,-0.56000000000000005,474.44,606.44000000000005,55.44,474.44]
[98,326,194,250,550.44000000000005,399.44,474.44,1391,1240,1259]
[99,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,606.44000000000005,455.44,474.44]
[100,531.44000000000005,399.44,455.44,550.44000000000005,399.44,474.44,1391,1240,1259]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[{"$f":"A137+1","v":130}]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[{"$f":"A201+1","v":194}]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[{"$f":"A265+1","v":258}]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[{"$f":"A329+1","v":322}]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[{"$f":"A393+1","v":386}]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[{"$f":"A457+1","v":450}]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[{"$f":"A521+1","v":514}]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[{"$f":"A585+1","v":578}]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[{"$f":"A649+1","v":642}]
[643]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[{"$f":"A713+1","v":706}]
[707]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[{"$f":"A777+1","v":770}]
[771]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[{"$f":"A841+1","v":834}]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[{"$f":"A905+1","v":898}]
[899]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[{"$f":"A969+1","v":962}]
[963]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]

{"sheet":"MAX PROFIT TREE","index":8,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[100,"Number of Samples"]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_4!$F$2,2)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_4!$F$2,2)","v":0}]
[null,null,{"$f":"PROFIT!B4","v":427.03139999999968},{"$f":"_xll.PTreeNodeValue(treeCalc_4!$F$2,2)","v":427.03139999999968}]
[null,null,"Decision"]
[null,null,{"$f":"_xll.PTreeNodeValue(treeCalc_4!$F$2,1)","v":796.44920000000047}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_4!$F$2,3)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_4!$F$2,3)","v":0}]
[null,null,{"$f":"PROFIT!C4","v":381.03139999999956},{"$f":"_xll.PTreeNodeValue(treeCalc_4!$F$2,3)","v":381.03139999999956}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_4!$F$2,4)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_4!$F$2,4)","v":0}]
[null,null,{"$f":"PROFIT!D4","v":389.03139999999956},{"$f":"_xll.PTreeNodeValue(treeCalc_4!$F$2,4)","v":389.03139999999956}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_4!$F$2,5)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_4!$F$2,5)","v":0}]
[null,null,{"$f":"PROFIT!E4","v":566.13120000000072},{"$f":"_xll.PTreeNodeValue(treeCalc_4!$F$2,5)","v":566.13120000000072}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_4!$F$2,6)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_4!$F$2,6)","v":0}]
[null,null,{"$f":"PROFIT!F4","v":329.13119999999952},{"$f":"_xll.PTreeNodeValue(treeCalc_4!$F$2,6)","v":329.13119999999952}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_4!$F$2,7)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_4!$F$2,7)","v":0}]
[null,null,{"$f":"PROFIT!G4","v":442.13120000000026},{"$f":"_xll.PTreeNodeValue(treeCalc_4!$F$2,7)","v":442.13120000000026}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_4!$F$2,8)","v":true},{"$f":"_xll.PTreeNodeProbability(treeCalc_4!$F$2,8)","v":1}]
[null,null,{"$f":"PROFIT!H4","v":796.44920000000047},{"$f":"_xll.PTreeNodeValue(treeCalc_4!$F$2,8)","v":796.44920000000047}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_4!$F$2,9)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_4!$F$2,9)","v":0}]
[null,null,{"$f":"PROFIT!I4","v":607.44920000000013},{"$f":"_xll.PTreeNodeValue(treeCalc_4!$F$2,9)","v":607.44920000000013}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_4!$F$2,10)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_4!$F$2,10)","v":0}]
[null,null,{"$f":"PROFIT!J4","v":712.44920000000025},{"$f":"_xll.PTreeNodeValue(treeCalc_4!$F$2,10)","v":712.44920000000025}]

{"sheet":"MAX REWARD TREE","index":9,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[100]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_2!$F$2,2)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_2!$F$2,2)","v":0}]
[null,null,{"$f":"REWARD!B4","v":611.03139999999996},{"$f":"_xll.PTreeNodeValue(treeCalc_2!$F$2,2)","v":611.03139999999996}]
[null,null,"Decision"]
[null,null,{"$f":"_xll.PTreeNodeValue(treeCalc_2!$F$2,1)","v":953.44920000000047}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_2!$F$2,3)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_2!$F$2,3)","v":0}]
[null,null,{"$f":"REWARD!C4","v":697.03139999999996},{"$f":"_xll.PTreeNodeValue(treeCalc_2!$F$2,3)","v":697.03139999999996}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_2!$F$2,4)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_2!$F$2,4)","v":0}]
[null,null,{"$f":"REWARD!D4","v":649.03139999999996},{"$f":"_xll.PTreeNodeValue(treeCalc_2!$F$2,4)","v":649.03139999999996}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_2!$F$2,5)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_2!$F$2,5)","v":0}]
[null,null,{"$f":"REWARD!E4","v":731.13120000000094},{"$f":"_xll.PTreeNodeValue(treeCalc_2!$F$2,5)","v":731.13120000000094}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_2!$F$2,6)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_2!$F$2,6)","v":0}]
[null,null,{"$f":"REWARD!F4","v":645.13120000000083},{"$f":"_xll.PTreeNodeValue(treeCalc_2!$F$2,6)","v":645.13120000000083}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_2!$F$2,7)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_2!$F$2,7)","v":0}]
[null,null,{"$f":"REWARD!G4","v":683.13120000000094},{"$f":"_xll.PTreeNodeValue(treeCalc_2!$F$2,7)","v":683.13120000000094}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_2!$F$2,8)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_2!$F$2,8)","v":0}]
[null,null,{"$f":"REWARD!H4","v":905.44920000000047},{"$f":"_xll.PTreeNodeValue(treeCalc_2!$F$2,8)","v":905.44920000000047}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_2!$F$2,9)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_2!$F$2,9)","v":0}]
[null,null,{"$f":"REWARD!I4","v":867.44920000000047},{"$f":"_xll.PTreeNodeValue(treeCalc_2!$F$2,9)","v":867.44920000000047}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_2!$F$2,10)","v":true},{"$f":"_xll.PTreeNodeProbability(treeCalc_2!$F$2,10)","v":1}]
[null,null,{"$f":"REWARD!J4","v":953.44920000000047},{"$f":"_xll.PTreeNodeValue(treeCalc_2!$F$2,10)","v":953.44920000000047}]

{"sheet":"MIN COST TREE","index":10,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[100]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_1!$F$2,2)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_1!$F$2,2)","v":0}]
[null,null,{"$f":"COST!B4","v":151},{"$f":"_xll.PTreeNodeValue(treeCalc_1!$F$2,2)","v":151}]
[null,null,"Decision"]
[null,null,{"$f":"_xll.PTreeNodeValue(treeCalc_1!$F$2,1)","v":76}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_1!$F$2,3)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_1!$F$2,3)","v":0}]
[null,null,{"$f":"COST!C4","v":283},{"$f":"_xll.PTreeNodeValue(treeCalc_1!$F$2,3)","v":283}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_1!$F$2,4)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_1!$F$2,4)","v":0}]
[null,null,{"$f":"COST!D4","v":227},{"$f":"_xll.PTreeNodeValue(treeCalc_1!$F$2,4)","v":227}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_1!$F$2,5)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_1!$F$2,5)","v":0}]
[null,null,{"$f":"COST!E4","v":132},{"$f":"_xll.PTreeNodeValue(treeCalc_1!$F$2,5)","v":132}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_1!$F$2,6)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_1!$F$2,6)","v":0}]
[null,null,{"$f":"COST!F4","v":283},{"$f":"_xll.PTreeNodeValue(treeCalc_1!$F$2,6)","v":283}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_1!$F$2,7)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_1!$F$2,7)","v":0}]
[null,null,{"$f":"COST!G4","v":208},{"$f":"_xll.PTreeNodeValue(treeCalc_1!$F$2,7)","v":208}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_1!$F$2,8)","v":true},{"$f":"_xll.PTreeNodeProbability(treeCalc_1!$F$2,8)","v":1}]
[null,null,{"$f":"COST!H4","v":76},{"$f":"_xll.PTreeNodeValue(treeCalc_1!$F$2,8)","v":76}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_1!$F$2,9)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_1!$F$2,9)","v":0}]
[null,null,{"$f":"COST!I4","v":227},{"$f":"_xll.PTreeNodeValue(treeCalc_1!$F$2,9)","v":227}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_1!$F$2,10)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_1!$F$2,10)","v":0}]
[null,null,{"$f":"COST!J4","v":208},{"$f":"_xll.PTreeNodeValue(treeCalc_1!$F$2,10)","v":208}]

{"sheet":"treeCalc_3","index":11,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Name","MIN RISK REWARD TREE",null,null,"Ptree1 Compatibility",3,null,"Output Label","",null,"R-Value Ref.",100]
["SheetRef",{"$f":"'MIN RISK REWARD TREE'!#REF!","v":{"$error":"#REF!"}},null,null,"Eval. Function",{"$f":"_xll.PTreeEvaluate5(B3,$L$11:$L$20,$J$11:$J$20,$K$11:$K$20,$N$11:$N$20,$G$11:$G$20,,L1)","v":154779651}]
["GenInfo","0,3,1,0,0,Exponential, 0,0,0,0,-1,-1,.0001",null,null,"Creation Version","6.3.0",null,"Output Value NF","<NF>"]
["Def. Link","=",null,null,"Required Version","5.0.0",null,"Output Prob NF","Automatic"]
["EXT REFS",0,null,0,"Recommended Version","5.0.0",null,"Input Value NF","<NF>"]
["Def. Form",null,null,null,"Last Modified By Version","8.2.0",null,"Input Prob NF","Automatic"]
["Calc Macro",null,null,null,null,"31ACD247"]
["Highest#",10]
[]
["Anchor Cell","Branch Name","bformtype","valformula","pbformula","distribution","cumPayoffFunction","link","ENDNODEFORMULA","VAL","PB","GenInfo","IntRefs","RefRefs","NodeNames","Collapsed"]
[{"$f":"'MIN RISK REWARD TREE'!$C$5","v":110.39174556756659},{"$f":"B1","v":"MIN RISK REWARD TREE"},0,null,null,null,null,null,"DEFAULT",{"$f":"'MIN RISK REWARD TREE'!$B$5","v":0},{"$f":"'MIN RISK REWARD TREE'!$B$4","v":0},"2,0,0,9,2,3,4,5,6,7,8,9,10,0,0,0","0",null,{"$f":"'MIN RISK REWARD TREE'!$C$4","v":"Decision"},false]
[{"$f":"'MIN RISK REWARD TREE'!$D$3","v":313.33192014194566},"ALTERNATIVE 1",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK REWARD TREE'!$C$3","v":313.33192014194566},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK REWARD TREE'!$D$7","v":282.63379321788034},"ALTERNATIVE 2",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK REWARD TREE'!$C$7","v":282.63379321788034},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK REWARD TREE'!$D$9","v":300.32597922257798},"ALTERNATIVE 3",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK REWARD TREE'!$C$9","v":300.32597922257798},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK REWARD TREE'!$D$11","v":110.39174556756659},"ALTERNATIVE 4",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK REWARD TREE'!$C$11","v":110.39174556756659},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK REWARD TREE'!$D$13","v":207.84454300055793},"ALTERNATIVE 5",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK REWARD TREE'!$C$13","v":207.84454300055793},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK REWARD TREE'!$D$15","v":175.4268367873392},"ALTERNATIVE 6",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK REWARD TREE'!$C$15","v":175.4268367873392},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK REWARD TREE'!$D$17","v":424.26252873455911},"ALTERNATIVE 7",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK REWARD TREE'!$C$17","v":424.26252873455911},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK REWARD TREE'!$D$19","v":435.39296723133373},"ALTERNATIVE 8",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK REWARD TREE'!$C$19","v":435.39296723133373},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK REWARD TREE'!$D$21","v":408.49195824998725},"ALTERNATIVE 9",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK REWARD TREE'!$C$21","v":408.49195824998725},null,"4,0,0,0,1,0,0","0",null,null,false]

{"sheet":"MIN RISK PROFIT TREE","index":12,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[100]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_5!$F$2,2)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_5!$F$2,2)","v":0}]
[null,null,{"$f":"PROFIT!B5","v":313.33192014194589},{"$f":"_xll.PTreeNodeValue(treeCalc_5!$F$2,2)","v":313.33192014194589}]
[null,null,"Decision"]
[null,null,{"$f":"_xll.PTreeNodeValue(treeCalc_5!$F$2,1)","v":110.39174556756232}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_5!$F$2,3)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_5!$F$2,3)","v":0}]
[null,null,{"$f":"PROFIT!C5","v":282.63379321788074},{"$f":"_xll.PTreeNodeValue(treeCalc_5!$F$2,3)","v":282.63379321788074}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_5!$F$2,4)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_5!$F$2,4)","v":0}]
[null,null,{"$f":"PROFIT!D5","v":300.32597922257844},{"$f":"_xll.PTreeNodeValue(treeCalc_5!$F$2,4)","v":300.32597922257844}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_5!$F$2,5)","v":true},{"$f":"_xll.PTreeNodeProbability(treeCalc_5!$F$2,5)","v":1}]
[null,null,{"$f":"PROFIT!E5","v":110.39174556756232},{"$f":"_xll.PTreeNodeValue(treeCalc_5!$F$2,5)","v":110.39174556756232}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_5!$F$2,6)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_5!$F$2,6)","v":0}]
[null,null,{"$f":"PROFIT!F5","v":207.84454300055953},{"$f":"_xll.PTreeNodeValue(treeCalc_5!$F$2,6)","v":207.84454300055953}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_5!$F$2,7)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_5!$F$2,7)","v":0}]
[null,null,{"$f":"PROFIT!G5","v":175.42683678733962},{"$f":"_xll.PTreeNodeValue(treeCalc_5!$F$2,7)","v":175.42683678733962}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_5!$F$2,8)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_5!$F$2,8)","v":0}]
[null,null,{"$f":"PROFIT!H5","v":424.26252873455826},{"$f":"_xll.PTreeNodeValue(treeCalc_5!$F$2,8)","v":424.26252873455826}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_5!$F$2,9)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_5!$F$2,9)","v":0}]
[null,null,{"$f":"PROFIT!I5","v":435.39296723133316},{"$f":"_xll.PTreeNodeValue(treeCalc_5!$F$2,9)","v":435.39296723133316}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_5!$F$2,10)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_5!$F$2,10)","v":0}]
[null,null,{"$f":"PROFIT!J5","v":408.49195824998696},{"$f":"_xll.PTreeNodeValue(treeCalc_5!$F$2,10)","v":408.49195824998696}]

{"sheet":"MIN RISK REWARD TREE","index":13,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[100]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_3!$F$2,2)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_3!$F$2,2)","v":0}]
[null,null,{"$f":"REWARD!B5","v":313.33192014194566},{"$f":"_xll.PTreeNodeValue(treeCalc_3!$F$2,2)","v":313.33192014194566}]
[null,null,"Decision"]
[null,null,{"$f":"_xll.PTreeNodeValue(treeCalc_3!$F$2,1)","v":110.39174556756659}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_3!$F$2,3)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_3!$F$2,3)","v":0}]
[null,null,{"$f":"REWARD!C5","v":282.63379321788034},{"$f":"_xll.PTreeNodeValue(treeCalc_3!$F$2,3)","v":282.63379321788034}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_3!$F$2,4)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_3!$F$2,4)","v":0}]
[null,null,{"$f":"REWARD!D5","v":300.32597922257798},{"$f":"_xll.PTreeNodeValue(treeCalc_3!$F$2,4)","v":300.32597922257798}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_3!$F$2,5)","v":true},{"$f":"_xll.PTreeNodeProbability(treeCalc_3!$F$2,5)","v":1}]
[null,null,{"$f":"REWARD!E5","v":110.39174556756659},{"$f":"_xll.PTreeNodeValue(treeCalc_3!$F$2,5)","v":110.39174556756659}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_3!$F$2,6)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_3!$F$2,6)","v":0}]
[null,null,{"$f":"REWARD!F5","v":207.84454300055793},{"$f":"_xll.PTreeNodeValue(treeCalc_3!$F$2,6)","v":207.84454300055793}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_3!$F$2,7)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_3!$F$2,7)","v":0}]
[null,null,{"$f":"REWARD!G5","v":175.4268367873392},{"$f":"_xll.PTreeNodeValue(treeCalc_3!$F$2,7)","v":175.4268367873392}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_3!$F$2,8)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_3!$F$2,8)","v":0}]
[null,null,{"$f":"REWARD!H5","v":424.26252873455911},{"$f":"_xll.PTreeNodeValue(treeCalc_3!$F$2,8)","v":424.26252873455911}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_3!$F$2,9)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_3!$F$2,9)","v":0}]
[null,null,{"$f":"REWARD!I5","v":435.39296723133373},{"$f":"_xll.PTreeNodeValue(treeCalc_3!$F$2,9)","v":435.39296723133373}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_3!$F$2,10)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_3!$F$2,10)","v":0}]
[null,null,{"$f":"REWARD!J5","v":408.49195824998725},{"$f":"_xll.PTreeNodeValue(treeCalc_3!$F$2,10)","v":408.49195824998725}]

{"sheet":"treeCalc_4","index":14,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Name","MAX PROFIT TREE",null,null,"Ptree1 Compatibility",3,null,"Output Label","",null,"R-Value Ref.",100]
["SheetRef",{"$f":"'MAX PROFIT TREE'!#REF!","v":{"$error":"#REF!"}},null,null,"Eval. Function",{"$f":"_xll.PTreeEvaluate5(B3,$L$11:$L$20,$J$11:$J$20,$K$11:$K$20,$N$11:$N$20,$G$11:$G$20,,L1)","v":154753924}]
["GenInfo","0,4,1,0,0,Exponential, 0,0,-1,0,-1,-1,.0001",null,null,"Creation Version","6.3.0",null,"Output Value NF","<NF>"]
["Def. Link","=",null,null,"Required Version","5.0.0",null,"Output Prob NF","Automatic"]
["EXT REFS",0,null,0,"Recommended Version","5.0.0",null,"Input Value NF","<NF>"]
["Def. Form",null,null,null,"Last Modified By Version","8.2.0",null,"Input Prob NF","Automatic"]
["Calc Macro",null,null,null,null,"FA1D6AA"]
["Highest#",10]
[]
["Anchor Cell","Branch Name","bformtype","valformula","pbformula","distribution","cumPayoffFunction","link","ENDNODEFORMULA","VAL","PB","GenInfo","IntRefs","RefRefs","NodeNames","Collapsed"]
[{"$f":"'MAX PROFIT TREE'!$C$5","v":796.44920000000047},{"$f":"B1","v":"MAX PROFIT TREE"},0,null,null,null,null,null,"DEFAULT",{"$f":"'MAX PROFIT TREE'!$B$5","v":0},{"$f":"'MAX PROFIT TREE'!$B$4","v":0},"2,0,0,9,2,3,4,5,6,7,8,9,10,0,0,0","0",null,{"$f":"'MAX PROFIT TREE'!$C$4","v":"Decision"},false]
[{"$f":"'MAX PROFIT TREE'!$D$3","v":427.03139999999968},"ALTERNATIVE 1",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX PROFIT TREE'!$C$3","v":427.03139999999968},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX PROFIT TREE'!$D$7","v":381.03139999999956},"ALTERNATIVE 2",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX PROFIT TREE'!$C$7","v":381.03139999999956},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX PROFIT TREE'!$D$9","v":389.03139999999956},"ALTERNATIVE 3",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX PROFIT TREE'!$C$9","v":389.03139999999956},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX PROFIT TREE'!$D$11","v":566.13120000000072},"ALTERNATIVE 4",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX PROFIT TREE'!$C$11","v":566.13120000000072},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX PROFIT TREE'!$D$13","v":329.13119999999952},"ALTERNATIVE 5",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX PROFIT TREE'!$C$13","v":329.13119999999952},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX PROFIT TREE'!$D$15","v":442.13120000000026},"ALTERNATIVE 6",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX PROFIT TREE'!$C$15","v":442.13120000000026},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX PROFIT TREE'!$D$17","v":796.44920000000047},"ALTERNATIVE 7",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX PROFIT TREE'!$C$17","v":796.44920000000047},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX PROFIT TREE'!$D$19","v":607.44920000000013},"ALTERNATIVE 8",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX PROFIT TREE'!$C$19","v":607.44920000000013},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MAX PROFIT TREE'!$D$21","v":712.44920000000025},"ALTERNATIVE 9",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MAX PROFIT TREE'!$C$21","v":712.44920000000025},null,"4,0,0,0,1,0,0","0",null,null,false]

{"sheet":"treeCalc_5","index":15,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Name","MIN RISK PROFIT TREE",null,null,"Ptree1 Compatibility",3,null,"Output Label","",null,"R-Value Ref.",100]
["SheetRef",{"$f":"'MIN RISK PROFIT TREE'!#REF!","v":{"$error":"#REF!"}},null,null,"Eval. Function",{"$f":"_xll.PTreeEvaluate5(B3,$L$11:$L$20,$J$11:$J$20,$K$11:$K$20,$N$11:$N$20,$G$11:$G$20,,L1)","v":154728197}]
["GenInfo","0,5,1,0,0,Exponential, 0,0,0,0,-1,-1,.0001",null,null,"Creation Version","6.3.0",null,"Output Value NF","<NF>"]
["Def. Link","=",null,null,"Required Version","5.0.0",null,"Output Prob NF","Automatic"]
["EXT REFS",0,null,0,"Recommended Version","5.0.0",null,"Input Value NF","<NF>"]
["Def. Form",null,null,null,"Last Modified By Version","8.2.0",null,"Input Prob NF","Automatic"]
["Calc Macro",null,null,null,null,"AC58584"]
["Highest#",10]
[]
["Anchor Cell","Branch Name","bformtype","valformula","pbformula","distribution","cumPayoffFunction","link","ENDNODEFORMULA","VAL","PB","GenInfo","IntRefs","RefRefs","NodeNames","Collapsed"]
[{"$f":"'MIN RISK PROFIT TREE'!$C$5","v":110.39174556756232},{"$f":"B1","v":"MIN RISK PROFIT TREE"},0,null,null,null,null,null,"DEFAULT",{"$f":"'MIN RISK PROFIT TREE'!$B$5","v":0},{"$f":"'MIN RISK PROFIT TREE'!$B$4","v":0},"2,0,0,9,2,3,4,5,6,7,8,9,10,0,0,0","0",null,{"$f":"'MIN RISK PROFIT TREE'!$C$4","v":"Decision"},false]
[{"$f":"'MIN RISK PROFIT TREE'!$D$3","v":313.33192014194589},"ALTERNATIVE 1",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK PROFIT TREE'!$C$3","v":313.33192014194589},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK PROFIT TREE'!$D$7","v":282.63379321788074},"ALTERNATIVE 2",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK PROFIT TREE'!$C$7","v":282.63379321788074},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK PROFIT TREE'!$D$9","v":300.32597922257844},"ALTERNATIVE 3",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK PROFIT TREE'!$C$9","v":300.32597922257844},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK PROFIT TREE'!$D$11","v":110.39174556756232},"ALTERNATIVE 4",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK PROFIT TREE'!$C$11","v":110.39174556756232},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK PROFIT TREE'!$D$13","v":207.84454300055953},"ALTERNATIVE 5",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK PROFIT TREE'!$C$13","v":207.84454300055953},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK PROFIT TREE'!$D$15","v":175.42683678733962},"ALTERNATIVE 6",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK PROFIT TREE'!$C$15","v":175.42683678733962},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK PROFIT TREE'!$D$17","v":424.26252873455826},"ALTERNATIVE 7",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK PROFIT TREE'!$C$17","v":424.26252873455826},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK PROFIT TREE'!$D$19","v":435.39296723133316},"ALTERNATIVE 8",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK PROFIT TREE'!$C$19","v":435.39296723133316},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN RISK PROFIT TREE'!$D$21","v":408.49195824998696},"ALTERNATIVE 9",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN RISK PROFIT TREE'!$C$21","v":408.49195824998696},null,"4,0,0,0,1,0,0","0",null,null,false]

{"sheet":"MIN Pr(LOSS)","index":16,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[100]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_6!$F$2,2)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_6!$F$2,2)","v":0}]
[null,null,{"$f":"PROFIT!B6","v":0.09},{"$f":"_xll.PTreeNodeValue(treeCalc_6!$F$2,2)","v":0.09}]
[null,null,"Decision"]
[null,null,{"$f":"_xll.PTreeNodeValue(treeCalc_6!$F$2,1)","v":0}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_6!$F$2,3)","v":true},{"$f":"_xll.PTreeNodeProbability(treeCalc_6!$F$2,3)","v":1}]
[null,null,{"$f":"PROFIT!C6","v":0},{"$f":"_xll.PTreeNodeValue(treeCalc_6!$F$2,3)","v":0}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_6!$F$2,4)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_6!$F$2,4)","v":0}]
[null,null,{"$f":"PROFIT!D6","v":0.05},{"$f":"_xll.PTreeNodeValue(treeCalc_6!$F$2,4)","v":0.05}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_6!$F$2,5)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_6!$F$2,5)","v":0}]
[null,null,{"$f":"PROFIT!E6","v":0},{"$f":"_xll.PTreeNodeValue(treeCalc_6!$F$2,5)","v":0}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_6!$F$2,6)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_6!$F$2,6)","v":0}]
[null,null,{"$f":"PROFIT!F6","v":0.21},{"$f":"_xll.PTreeNodeValue(treeCalc_6!$F$2,6)","v":0.21}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_6!$F$2,7)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_6!$F$2,7)","v":0}]
[null,null,{"$f":"PROFIT!G6","v":0},{"$f":"_xll.PTreeNodeValue(treeCalc_6!$F$2,7)","v":0}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_6!$F$2,8)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_6!$F$2,8)","v":0}]
[null,null,{"$f":"PROFIT!H6","v":0},{"$f":"_xll.PTreeNodeValue(treeCalc_6!$F$2,8)","v":0}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_6!$F$2,9)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_6!$F$2,9)","v":0}]
[null,null,{"$f":"PROFIT!I6","v":0.02},{"$f":"_xll.PTreeNodeValue(treeCalc_6!$F$2,9)","v":0.02}]
[null,null,{"$f":"_xll.PTreeNodeDecision(treeCalc_6!$F$2,10)","v":false},{"$f":"_xll.PTreeNodeProbability(treeCalc_6!$F$2,10)","v":0}]
[null,null,{"$f":"PROFIT!J6","v":0},{"$f":"_xll.PTreeNodeValue(treeCalc_6!$F$2,10)","v":0}]

{"sheet":"treeCalc_6","index":17,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Name","MIN Pr(LOSS) TREE",null,null,"Ptree1 Compatibility",3,null,"Output Label","",null,"R-Value Ref.",100]
["SheetRef",{"$f":"'MIN Pr(LOSS)'!#REF!","v":{"$error":"#REF!"}},null,null,"Eval. Function",{"$f":"_xll.PTreeEvaluate5(B3,$L$11:$L$20,$J$11:$J$20,$K$11:$K$20,$N$11:$N$20,$G$11:$G$20,,L1)","v":154702470}]
["GenInfo","0,6,1,0,0,Exponential, 0,0,0,0,-1,-1,.0001",null,null,"Creation Version","6.3.0",null,"Output Value NF","<NF>"]
["Def. Link","=",null,null,"Required Version","5.0.0",null,"Output Prob NF","Automatic"]
["EXT REFS",0,null,0,"Recommended Version","5.0.0",null,"Input Value NF","<NF>"]
["Def. Form",null,null,null,"Last Modified By Version","8.2.0",null,"Input Prob NF","Automatic"]
["Calc Macro",null,null,null,null,"2C92A651"]
["Highest#",10]
[]
["Anchor Cell","Branch Name","bformtype","valformula","pbformula","distribution","cumPayoffFunction","link","ENDNODEFORMULA","VAL","PB","GenInfo","IntRefs","RefRefs","NodeNames","Collapsed"]
[{"$f":"'MIN Pr(LOSS)'!$C$5","v":0},{"$f":"B1","v":"MIN Pr(LOSS) TREE"},0,null,null,null,null,null,"DEFAULT",{"$f":"'MIN Pr(LOSS)'!$B$5","v":0},{"$f":"'MIN Pr(LOSS)'!$B$4","v":0},"2,0,0,9,2,3,4,5,6,7,8,9,10,0,0,0","0",null,{"$f":"'MIN Pr(LOSS)'!$C$4","v":"Decision"},false]
[{"$f":"'MIN Pr(LOSS)'!$D$3","v":0.09},"ALTERNATIVE 1",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN Pr(LOSS)'!$C$3","v":0.09},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN Pr(LOSS)'!$D$7","v":0},"ALTERNATIVE 2",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN Pr(LOSS)'!$C$7","v":0},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN Pr(LOSS)'!$D$9","v":0.05},"ALTERNATIVE 3",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN Pr(LOSS)'!$C$9","v":0.05},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN Pr(LOSS)'!$D$11","v":0},"ALTERNATIVE 4",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN Pr(LOSS)'!$C$11","v":0},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN Pr(LOSS)'!$D$13","v":0.21},"ALTERNATIVE 5",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN Pr(LOSS)'!$C$13","v":0.21},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN Pr(LOSS)'!$D$15","v":0},"ALTERNATIVE 6",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN Pr(LOSS)'!$C$15","v":0},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN Pr(LOSS)'!$D$17","v":0},"ALTERNATIVE 7",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN Pr(LOSS)'!$C$17","v":0},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN Pr(LOSS)'!$D$19","v":0.02},"ALTERNATIVE 8",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN Pr(LOSS)'!$C$19","v":0.02},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN Pr(LOSS)'!$D$21","v":0},"ALTERNATIVE 9",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN Pr(LOSS)'!$C$21","v":0},null,"4,0,0,0,1,0,0","0",null,null,false]

{"sheet":"treeCalc_1","index":18,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Name","MIN COST TREE",null,null,"Ptree1 Compatibility",3,null,"Output Label","",null,"R-Value Ref.",100]
["SheetRef",{"$f":"'MIN COST TREE'!#REF!","v":{"$error":"#REF!"}},null,null,"Eval. Function",{"$f":"_xll.PTreeEvaluate5(B3,$L$11:$L$20,$J$11:$J$20,$K$11:$K$20,$N$11:$N$20,$G$11:$G$20,,L1)","v":154831105}]
["GenInfo","0,1,1,0,0,Exponential, 0,0,0,0,-1,-1,.0001",null,null,"Creation Version","6.3.0",null,"Output Value NF","<NF>"]
["Def. Link","=",null,null,"Required Version","5.0.0",null,"Output Prob NF","Automatic"]
["EXT REFS",0,null,null,"Recommended Version","5.0.0",null,"Input Value NF","<NF>"]
["Def. Form",null,null,null,"Last Modified By Version","8.2.0",null,"Input Prob NF","Automatic"]
["Calc Macro",null,null,null,null,"1F8651FF"]
["Highest#",10]
[]
["Anchor Cell","Branch Name","bformtype","valformula","pbformula","distribution","cumPayoffFunction","link","ENDNODEFORMULA","VAL","PB","GenInfo","IntRefs","RefRefs","NodeNames","Collapsed"]
[{"$f":"'MIN COST TREE'!$C$5","v":76},{"$f":"B1","v":"MIN COST TREE"},0,null,null,null,null,null,"DEFAULT",{"$f":"'MIN COST TREE'!$B$5","v":0},{"$f":"'MIN COST TREE'!$B$4","v":0},"2,0,0,9,2,3,4,5,6,7,8,9,10,0,0,0","0",null,{"$f":"'MIN COST TREE'!$C$4","v":"Decision"},false]
[{"$f":"'MIN COST TREE'!$D$3","v":151},"ALTERNATIVE 1",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN COST TREE'!$C$3","v":151},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN COST TREE'!$D$7","v":283},"ALTERNATIVE 2",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN COST TREE'!$C$7","v":283},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN COST TREE'!$D$9","v":227},"ALTERNATIVE 3",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN COST TREE'!$C$9","v":227},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN COST TREE'!$D$11","v":132},"ALTERNATIVE 4",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN COST TREE'!$C$11","v":132},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN COST TREE'!$D$13","v":283},"ALTERNATIVE 5",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN COST TREE'!$C$13","v":283},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN COST TREE'!$D$15","v":208},"ALTERNATIVE 6",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN COST TREE'!$C$15","v":208},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN COST TREE'!$D$17","v":76},"ALTERNATIVE 7",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN COST TREE'!$C$17","v":76},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN COST TREE'!$D$19","v":227},"ALTERNATIVE 8",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN COST TREE'!$C$19","v":227},null,"4,0,0,0,1,0,0","0",null,null,false]
[{"$f":"'MIN COST TREE'!$D$21","v":208},"ALTERNATIVE 9",0,null,null,null,null,"DEFAULT","DEFAULT",{"$f":"'MIN COST TREE'!$C$21","v":208},null,"4,0,0,0,1,0,0","0",null,null,false]