{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["運算結果報表 1","GameTheory","Sheet3","Sheet2","MenuSheet","Ex28","Pr01","Pr02","GTA1","GT01","Decision Analysis Menu","Decision Analysis Menu (2)","Sheet1","DA1","顏色","Pr03","Ex1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":108,"comments":1,"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":"運算結果報表 1","index":0,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 10.0 運算結果報表"]
["工作表: [FOR.xls]GameTheory"]
["報表的建立: 2011/8/4 上午 11:41:50"]
[]
[]
["目標儲存格 (Min)"]
[null,"儲存格","名稱","初值","終值"]
[null,"$B$1","Object",null,350.00000000583481]
[]
[]
["可調整儲存格"]
[null,"儲存格","名稱","初值","終值"]
[null,"$B$2","YA",1,1.0000000000247375]
[null,"$B$3","YB",1,0]
[null,"$B$4","YC",1,0]
[null,"$B$5","YD",1,2.2406965172194759E-11]
[null,"$B$6","YE",1,1]
[null,"$B$7","X0",0,0]
[null,"$B$8","X2",1,10.999999999998568]
[null,"$B$9","X3",1,11.000000000020975]
[null,"$B$10","X4",1,18.999999999999339]
[null,"$B$11","Xn",1,25]
[]
[]
["限制式"]
[null,"儲存格","名稱","儲存格值","公式","狀態","Slack"]
[null,"$F$2","<= 公式",12.000000000023306,"$F$2>=$H$2","Binding",0]
[null,"$F$3","<= 公式",8.0000000000007709,"$F$3>=$H$3","Binding",0]
[null,"$F$4","<= 公式",11.000000000020975,"$F$4>=$H$4","Binding",0]
[null,"$F$5","<= 公式",8.0000000000007709,"$F$5>=$H$5","Binding",0]
[null,"$F$6","<= 公式",7.0000000000006608,"$F$6>=$H$6","Binding",0]
[null,"$B$2","YA",1.0000000000247375,"$B$2<=$E$2","Not Binding",1.9999999999752625]
[null,"$B$3","YB",0,"$B$3<=$E$3","Not Binding",1]
[null,"$B$4","YC",0,"$B$4<=$E$4","Not Binding",2]
[null,"$B$5","YD",2.2406965172194759E-11,"$B$5<=$E$5","Not Binding",1.999999999977593]
[null,"$B$6","YE",1,"$B$6<=$E$6","Binding",0]
[null,"$B$7","X0",0,"$B$7=$D$7","Not Binding",0]
[null,"$B$11","Xn",25,"$B$11<=$D$11","Binding",0]

{"sheet":"GameTheory","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["OBJ",{"$f":"B2*C2+B3*C3+B4*C4+B5*C5+B6*C6","v":350.00000000583481},null,null,null,"公式"]
["YA",1.0000000000247375,100,"<=",3,{"$f":"B8-B7+B2","v":12.000000000023306},">=",12]
["YB",0,150,"<=",1,{"$f":"B10-B8+B3","v":8.0000000000007709},">=",8]
["YC",0,200,"<=",2,{"$f":"B9-B7+B4","v":11.000000000020975},">=",11]
["YD",2.2406965172194759E-11,150,"<=",2,{"$f":"B10-B9+B5","v":8.0000000000007709},">=",8]
["YE",1,250,"<=",1,{"$f":"B11-B10+B6","v":7.0000000000006608},">=",7]
["X1",0,null,0]
["X2",10.999999999998568]
["X3",11.000000000020975]
["X4",18.999999999999339]
["X5",25,null,25]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"MenuSheet","index":4,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["c"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Level","Caption","Position/Macro","Divider","FaceID"]
[1,"&FOR",10,null,null,null,"Click the link below for a method to"]
[2,"多準則決策分析"]
[3,"加權目標法(Weights Method)"]
[4,"建立加權目標法試算表","OR0901",null,71]
[4,"進行加權目標法分析","OR0902",null,72]
[4,"列印加權目標法試算表","OR0903",null,73]
[3,"優先目標法(Preemptive Method)"]
[4,"建立優先目標法試算表","OR0904",null,71]
[4,"進行優先目標法分析","OR0905",null,72]
[4,"列印優先目標法試算表","OR0906",null,73]
[3,"層級分析法(AHP)"]
[4,"建立決策準則成對比較矩陣","MF0206",null,71]
[4,"建立決策方案成對比較矩陣","MF0207",null,72]
[4,"進行層級分析(AHP)","MF0208",null,73]
[4,"列印層級分析(AHP)報表","MF0209",null,74]
[2,"PERT與CPM"]
[3,"專案計畫建置","MF0311",null,71]
[3,"時間排程","MF0312",null,72]
[3,"推算指定完成時間的機率","MF0313",null,73]
[3,"最佳趕工方案","MF0316",null,76]
[2,"軟體使用統計","MFUsage",true]
[2,"關於作業研究軟體","MFAbout",true]
[2,"結束作業","MFEnd",true]

{"sheet":"Ex28","index":5,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Gorman Manufacturing Company"]
["Indicators","Decisions","State of Nature","p(s)","p(I|s)","p(I∩s)","p(s|I)","r","EMV"]
["Favorable(I1)","Manufacture(d1)","Low(s1)",0.35,0.1,{"$f":"D3*E3","v":3.4999999999999996E-2},{"$f":"F3/$F$9","v":9.8591549295774641E-2},-20,{"$f":"D3*H3+D4*H4+D5*H5","v":37},{"$f":"MAX(H3,H6)","v":10},{"$f":"D3*J3","v":3.5}]
[{"$f":"MAX(I4,I7)","v":64.507042253521121},{"$f":"D3*MAX(H3,H6)+D4*MAX(H4,H7)+D5*MAX(H5,H8)","v":49.25},"Medium(s2)",0.35,0.4,0.13999999999999999,0.39436619718309857,40,{"$f":"G3*H3+G4*H4+G5*H5","v":64.507042253521121},{"$f":"MAX(H4,H7)","v":45},{"$f":"D4*J4","v":15.749999999999998}]
[null,null,"High(s3)",0.3,0.6,0.18,0.50704225352112675,100,null,{"$f":"MAX(H5,H8)","v":100},{"$f":"D5*J5","v":30}]
[null,"Purchase(d2)","Low(s1)",0.35,0.1,3.4999999999999996E-2,9.8591549295774641E-2,10,{"$f":"D6*H6+D7*H7+D8*H8","v":40.25},null,{"$f":"SUM(K3:K5)","v":49.25}]
[null,null,"Medium(s2)",0.35,0.4,0.13999999999999999,0.39436619718309857,45,{"$f":"G6*H6+G7*H7+G8*H8","v":54.225352112676056}]
[null,null,"High(s3)",0.3,0.6,0.18,0.50704225352112675,70]
[null,null,null,null,"p(I1)=",{"$f":"SUM(F6:F8)","v":0.35499999999999998}]
["Unfavorable(I2)","Manufacture(d1)","Low(s1)",0.35,0.9,{"$f":"D10*E10","v":0.315},{"$f":"F10/$F$16","v":0.48837209302325579},-20,{"$f":"D10*H10+D11*H11+D12*H12","v":37}]
[{"$f":"MAX(I11,I14)","v":32.558139534883722},null,"Medium(s2)",0.35,0.6,0.21,0.32558139534883718,40,{"$f":"G10*H10+G11*H11+G12*H12","v":21.86046511627907}]
[null,null,"High(s3)",0.3,0.4,0.12,0.18604651162790697,100]
[null,"Purchase(d2)","Low(s1)",0.35,0.9,0.315,0.48837209302325579,10,{"$f":"D13*H13+D14*H14+D15*H15","v":40.25}]
[null,null,"Medium(s2)",0.35,0.6,0.21,0.32558139534883718,45,{"$f":"G13*H13+G14*H14+G15*H15","v":32.558139534883722}]
[null,null,"High(s3)",0.3,0.4,0.12,0.18604651162790697,70]
[null,null,null,null,"p(I2)=",{"$f":"SUM(F13:F15)","v":0.64500000000000002}]
["EVPI","EMVwoSI","EMVwSI","EMVSI",null,"Rate"]
[{"$f":"B4-B18","v":9},{"$f":"MAX(I3,I6)","v":40.25},{"$f":"A4*F9+A11*F16","v":43.899999999999991},{"$f":"C18-B18","v":3.6499999999999915},null,{"$f":"D18/A18","v":0.40555555555555461}]

{"sheet":"Pr01","index":6,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[14,0,14,9],[0,0,0,9]]}
["Decision Maker A"]
["Decisions","State of Nature","p(s)","r","p","U","EMV","EUV","UN","pN"]
["Investment1(d1)","Up(s1)",0.4,100,1,{"$f":"E3*$C$12+(1-E3)*$C$13","v":10},{"$f":"D3*C3","v":40},{"$f":"D3*F3","v":1000},{"$f":"(D3-$D$13)*($C$12-$C$13)/($D$12-$D$13)","v":10},{"$f":"(I3-$C$13)/($C$12-$C$13)","v":1},{"$f":"IF(F3=I3,\"平險\",IF(F3>I3,\"避險\",\"冒險\"))","v":"平險"}]
[{"$f":"SUM(G3:G5)","v":47.5},"Stable(s2)",0.3,25,0.3,3,{"$f":"D4*C4","v":7.5},{"$f":"D4*F4","v":75},{"$f":"(D4-$D$13)*($C$12-$C$13)/($D$12-$D$13)","v":2.5},{"$f":"(I4-$C$13)/($C$12-$C$13)","v":0.25},{"$f":"IF(F4=I4,\"平險\",IF(F4>I4,\"避險\",\"冒險\"))","v":"避險"}]
[{"$f":"SUM(H3:H5)","v":1075},"Down(s3)",0.3,0,0,0,0,0,0,0,"平險"]
["Investment2(d2)","Up(s1)",0.4,75,0.8,8,30,600,7.5,0.75,"避險"]
[{"$f":"SUM(G6:G8)","v":52.5},"Stable(s2)",0.3,50,0.6,6,15,300,5,0.5,"避險"]
[{"$f":"SUM(H6:H8)","v":975},"Down(s3)",0.3,25,0.3,3,7.5,75,2.5,0.25,"避險"]
["Investment3(d3)","Up(s1)",0.4,50,0.6,6,20,300,5,0.5,"避險"]
[{"$f":"SUM(G9:G11)","v":50},"Stable(s2)",0.3,50,0.6,6,15,300,5,0.5,"避險"]
[{"$f":"SUM(H9:H11)","v":900},"Down(s3)",0.3,50,0.6,6,15,300,5,0.5,"避險"]
[{"$f":"MAX(A4,A7,A10)","v":52.5},"Max",10,{"$f":"MAX(D3:D11)","v":100},null,null,{"$f":"MAX(G3:G11)","v":40},{"$f":"MAX(H3:H11)","v":1000}]
[{"$f":"MAX(A5,A8,A12)","v":1075},"Min",0,{"$f":"MIN(D3:D11)","v":0},null,null,{"$f":"MIN(G3:G11)","v":0},{"$f":"MIN(H3:H11)","v":0}]
[]
["Decision Maker B"]
["Decisions","State of Nature","p(s)","r","p","U","EMV","EUV","UN","pN"]
["Investment1(d1)","Up(s1)",0.4,100,1,{"$f":"E17*$C$12+(1-E17)*$C$13","v":10},{"$f":"D17*C17","v":40},{"$f":"D17*F17","v":1000},{"$f":"(D17-$D$13)*($C$12-$C$13)/($D$12-$D$13)","v":10},{"$f":"(I17-$C$13)/($C$12-$C$13)","v":1},{"$f":"IF(F17=I17,\"平險\",IF(F17>I17,\"避險\",\"冒險\"))","v":"平險"}]
[{"$f":"SUM(G17:G19)","v":47.5},"Stable(s2)",0.3,25,0.15,1.5,{"$f":"D18*C18","v":7.5},{"$f":"D18*F18","v":37.5},{"$f":"(D18-$D$13)*($C$12-$C$13)/($D$12-$D$13)","v":2.5},{"$f":"(I18-$C$13)/($C$12-$C$13)","v":0.25},{"$f":"IF(F18=I18,\"平險\",IF(F18>I18,\"避險\",\"冒險\"))","v":"冒險"}]
[{"$f":"SUM(H17:H19)","v":1037.5},"Down(s3)",0.3,0,0,0,0,0,0,0,"平險"]
["Investment2(d2)","Up(s1)",0.4,75,0.6,6,30,450,7.5,0.75,"冒險"]
[{"$f":"SUM(G20:G22)","v":52.5},"Stable(s2)",0.3,50,0.3,3,15,150,5,0.5,"冒險"]
[{"$f":"SUM(H20:H22)","v":637.5},"Down(s3)",0.3,25,0.15,1.5,7.5,37.5,2.5,0.25,"冒險"]
["Investment3(d3)","Up(s1)",0.4,50,0.3,3,20,150,5,0.5,"冒險"]
[{"$f":"SUM(G23:G25)","v":50},"Stable(s2)",0.3,50,0.3,3,15,150,5,0.5,"冒險"]
[{"$f":"SUM(H23:H25)","v":450},"Down(s3)",0.3,50,0.3,3,15,150,5,0.5,"冒險"]
[{"$f":"MAX(A18,A21,A24)","v":52.5},"Max",10,{"$f":"MAX(D17:D25)","v":100},null,null,{"$f":"MAX(G17:G25)","v":40},{"$f":"MAX(H17:H25)","v":1000}]
[{"$f":"MAX(A19,A22,A25)","v":1037.5},"Min",0,{"$f":"MIN(D17:D25)","v":0},null,null,{"$f":"MIN(G17:G25)","v":0},{"$f":"MIN(H17:H25)","v":0}]

{"sheet":"Pr02","index":7,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Alexander Industries  (Minimization)"]
["Decision","State of Nature","p(s)","r","p","U","EMV","EUV"]
["Purchase Insurance(d1)","None",0.96,10000,0.99,0.99,{"$f":"D3*C3","v":9600},{"$f":"C3*F3","v":0.95039999999999991}]
[{"$f":"SUM(G3:G5)","v":10000},"Minor",0.03,10000,0.99,0.99,300,2.9699999999999997E-2,{"$f":"SUM(H3:H5)","v":0.98999999999999988}]
[null,"Major",0.01,10000,0.99,0.99,100,9.9000000000000008E-3]
["No Insurance(d2)","None",0.96,0,1,1,0,0.96]
[{"$f":"SUM(G6:G8)","v":5000},"Minor",0.03,100000,0.99,0.99,3000,2.9699999999999997E-2,{"$f":"SUM(H6:H8)","v":0.98969999999999991}]
[null,"Major",0.01,200000,0,0,2000,0]
[]
[]
["Decision","State of Nature","p(s)","r","p","U","Un","pN","Risk"]
["Purchase Insurance(d1)","None",0.96,10000,0.99,{"$f":"E12*$C$19+(1-E12)*$C$20","v":0.99},{"$f":"(D12-$D$20)*($C$19-$C$20)/($D$19-$D$20)","v":0.95},{"$f":"(G12-$C$20)/($C$19-$C$20)","v":0.95},{"$f":"IF(F12=G12,\"平險\",IF(F12>G12,\"避險\",\"冒險\"))","v":"避險"}]
[null,"Minor",0.03,10000,0.99,0.99,0.95,0.95,"避險"]
[null,"Major",0.01,10000,0.99,0.99,0.95,0.95,"避險"]
["No Insurance(d2)","None",0.96,0,1,1,1,1,"平險"]
[null,"Minor",0.03,100000,0.99,0.99,0.5,0.5,"避險"]
[null,"Major",0.01,200000,0,0,0,0,"平險"]
[]
[null,"Best",1,{"$f":"MIN(D12:D17)","v":0}]
[null,"Worst",0,{"$f":"MAX(D12:D17)","v":200000}]

{"sheet":"GTA1","index":8,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,0,2,7]]}
[4,4,2,"GTA1"]
[1,5,0]
["雙方零和競賽決策(賽局值與雙方最佳策略)"]
[null,"C1","C2","C3","C4","C5","R方策略","C方賽局值"]
["R1",21,13,11,20,6,1]
["R2",17,15,14,16,17,1]
["R3",10,14,13,13,18,1]
["R4",15,16,12,12,11,1]
["C方策略",1,1,1,1,1]
["R方賽局值"]
[null,0,0,7.1424714083386201E-2,0,0]
[null,1,1,1,1,1,{"$f":"SUM(B12:F12)","v":5}]

{"sheet":"GT01","index":9,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
["StartRow","RowNum","Status","SheetName"]
["StartCol","ColNum","Comments"]
["雙方零和競賽決策(賽局值與雙方最佳策略)"]
[null,"C1","C2","C3","R方策略","R期望值"]
["R1",3,2,3]
["R2",1,0,-1]
["R3",-1,1,0]
["C方策略"]
["C期望值",null,null,null,null,2541]

{"sheet":"Decision Analysis Menu","index":10,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["決策分析"]
["非機率性決策分析","frm非機率性"]
["機率性(無樣本資訊)分析","frm機率性無樣本"]
["機率性(有樣本資訊)分析","frm機率性有樣本"]
["效率率定","frm效率率定"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,54]
[]
[null,null,null,null,null,241]
[]
[]
[]
[null,{"$f":"A19*A20","v":0}]
[null,{"$f":"A20*A21","v":0}]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]

{"sheet":"Decision Analysis Menu (2)","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":12,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,2254]
[null,144]

{"sheet":"DA1","index":13,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[10]
[8,"率定各利潤(成本)值的等效用機率","率定各利潤(成本)值的等效用機率"]
[]
[null,"推算各利潤(成本)值的效用","推算各利潤(成本)值的效用"]
[]
[]
[]
[]
[]
["利潤值","P","U","Un","Pn","冒險度"]
[150]
[247]
[514]
[715]
[0]
[800]
[541]
[254]
[800,"最大值",7]
[0,"最小值",0]

{"sheet":"顏色","index":14,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[1,53,52,51,49,11,55,56]
[9,46,12,10,14,5,47,16]
[3,45,43,50,42,41,13,48]
[7,44,6,4,8,33,54,15]
[38,40,36,35,34,37,39,2]
["黑","褐色","橄欖綠","深綠","深藍綠","深藍","靛藍|(店)","灰80%"]
["深紅","橙","深黃","綠","藍綠","藍","藍灰","灰50%"]
["紅","淺橙","深亮綠","海藻綠","青","淺藍","紫","灰40%"]
["粉紅","金","黃","淺亮綠","淺粉藍","天藍","梅紅","灰25%"]
["玫瑰紅","深黃褐","淺黃","淺綠","淺藍綠","淡藍","淡紫","白"]
[]
[1,"黑"]
[2,"白"]
[3,"紅"]
[4,"淺亮綠"]
[5,"藍"]
[6,"黃"]
[7,"粉紅"]
[8,"淺粉藍"]
[9,"深紅"]
[10,"綠"]
[11,"深藍"]
[12,"深黃"]
[13,"紫"]
[14,"藍綠"]
[15,"灰25%"]
[16,"灰50%"]
[33,"天藍"]
[34,"淺藍綠"]
[35,"淺綠"]
[36,"淺黃"]
[37,"淡藍"]
[38,"玫瑰紅"]
[39,"淡紫"]
[40,"深黃褐"]
[41,"淺藍"]
[42,"青"]
[43,"深亮綠"]
[44,"金"]
[45,"淺橙"]
[46,"橙"]
[47,"藍灰"]
[48,"灰40%"]
[49,"深藍綠"]
[50,"海藻綠"]
[51,"深綠"]
[52,"橄欖綠"]
[53,"褐色"]
[54,"梅紅"]
[55,"靛藍|(店)"]
[56,"灰80%"]

{"sheet":"Pr03","index":15,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["Lottery  (Maximization)"]
["Decision","State of Nature","p(s)","r","p","U","EMV","EUV"]
["Purchase Lottery(d1)","Win(s1)",{"$f":"1/250000","v":3.9999999999999998E-6},300000,1,10,{"$f":"C3*D3","v":1.2},{"$f":"F3*C3","v":3.9999999999999996E-5}]
[null,"Lose(s2)",{"$f":"1-C3","v":0.999996},-2,0,0,{"$f":"C4*D4","v":-1.999992},{"$f":"F4*C4","v":0}]
["Not Purchase Lottery(d2)","Win(s1)",{"$f":"1/250000","v":3.9999999999999998E-6},0,9.9999999999999995E-7,9.9999999999999991E-6,{"$f":"C5*D5","v":0},{"$f":"F5*C5","v":3.9999999999999998E-11}]
[null,"Lose(s2)",{"$f":"1-C5","v":0.999996},0,9.9999999999999995E-7,9.9999999999999991E-6,{"$f":"C6*D6","v":0},{"$f":"F6*C6","v":9.9999599999999997E-6}]
[]
[]
[]
[]
[]
[]
[]
[]
["Decision","State of Nature","p(s)","r","p","U","Un","pN","Risk"]
["Purchase Lottery(d1)","Win(s1)",{"$f":"1/250000","v":3.9999999999999998E-6},300000,1,{"$f":"E16*$C$20+(1-E16)*$C$21","v":10},{"$f":"(D16-$D$20)*($C$19-$C$20)/($D$19-$D$20)","v":0},{"$f":"(G16-$C$20)/($C$19-$C$20)","v":1.11111061728417},{"$f":"IF(F16=G16,\"平險\",IF(F16>G16,\"避險\",\"冒險\"))","v":"避險"}]
[null,"Lose(s2)",{"$f":"1-C16","v":0.999996},-2,0,{"$f":"E17*$C$20+(1-E17)*$C$21","v":0}]
["Not Purchase Lottery(d2)","Win(s1)",{"$f":"1/250000","v":3.9999999999999998E-6},0,9.9999999999999995E-7,{"$f":"E18*$C$20+(1-E18)*$C$21","v":9.9999999999999991E-6}]
[null,"Lose(s2)",{"$f":"1-C18","v":0.999996},0,9.9999999999999995E-7,{"$f":"E19*$C$20+(1-E19)*$C$21","v":9.9999999999999991E-6}]
[null,"best",10,{"$f":"MAX(D16:D19)","v":300000}]
[null,"worst",0,{"$f":"MIN(D16:D19)","v":-2}]

{"sheet":"Ex1","index":16,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Some Title"]
["Profit","s1","s2","s3","s4","Optimistic","Conservative","Pessimistic","miniMax Regret"]
["d1",14,9,10,5,{"$f":"MAX(B3:E3)","v":14},{"$f":"MIN(B3:E3)","v":5},{"$f":"MIN(B3:E3)","v":5},{"$f":"MAX(B11:E11)","v":8}]
["d2",11,10,8,7,{"$f":"MAX(B4:E4)","v":11},{"$f":"MIN(B4:E4)","v":7},{"$f":"MIN(B4:E4)","v":7},{"$f":"MAX(B12:E12)","v":6}]
["d3",9,10,10,11,{"$f":"MAX(B5:E5)","v":11},{"$f":"MIN(B5:E5)","v":9},{"$f":"MIN(B5:E5)","v":9},{"$f":"MAX(B13:E13)","v":5}]
["d4",8,10,11,13,{"$f":"MAX(B6:E6)","v":13},{"$f":"MIN(B6:E6)","v":8},{"$f":"MIN(B6:E6)","v":8},{"$f":"MAX(B14:E14)","v":6}]
["最大值",{"$f":"MAX(B3:B6)","v":14},10,11,13,14,9,{"$f":"MIN(H3:H6)","v":5},{"$f":"MIN(I3:I6)","v":5}]
["最小值",{"$f":"MIN(B3:B6)","v":8},{"$f":"MIN(C3:C6)","v":9},8,5,11,5,5,5]
["最佳案",null,null,null,null,"d1","d3","d1","d3"]
["Regret","s1","s2","s3","s4","遺憾值"]
["d1",{"$f":"$B$7-B3","v":0},{"$f":"$C$7-C3","v":1},{"$f":"$D$7-D3","v":1},{"$f":"$E$7-E3","v":8}]
["d2",{"$f":"$B$7-B4","v":3},{"$f":"$C$7-C4","v":0},{"$f":"$D$7-D4","v":3},{"$f":"$E$7-E4","v":6}]
["d3",{"$f":"$B$7-B5","v":5},{"$f":"$C$7-C5","v":0},{"$f":"$D$7-D5","v":1},{"$f":"$E$7-E5","v":2}]
["d4",{"$f":"$B$7-B6","v":6},{"$f":"$C$7-C6","v":0},{"$f":"$D$7-D6","v":0},{"$f":"$E$7-E6","v":0}]
[]
[]
["Cost","s1","s2","s3","s4","Optimistic","Conservative","Pessimistic","miniMax Regret"]
["d1",14,9,10,5,{"$f":"MIN(B18:E18)","v":5},{"$f":"MAX(B18:E18)","v":14},{"$f":"MAX(B18:E18)","v":14},{"$f":"MAX(B25:E25)","v":6}]
["d2",11,10,8,7,{"$f":"MIN(B19:E19)","v":7},{"$f":"MAX(B19:E19)","v":11},{"$f":"MAX(B19:E19)","v":11},{"$f":"MAX(B26:E26)","v":3}]
["d3",9,10,10,11,{"$f":"MIN(B20:E20)","v":9},{"$f":"MAX(B20:E20)","v":11},{"$f":"MAX(B20:E20)","v":11},{"$f":"MAX(B27:E27)","v":6}]
["d4",8,10,11,13,{"$f":"MIN(B21:E21)","v":8},{"$f":"MAX(B21:E21)","v":13},{"$f":"MAX(B21:E21)","v":13},{"$f":"MAX(B28:E28)","v":8}]
[null,{"$f":"MIN(B18:B21)","v":8},9,8,5,5,11,{"$f":"MAX(H18:H21)","v":14},{"$f":"MIN(I18:I21)","v":3}]
[null,null,null,null,null,"d1","d2 or d3","d1","d2"]
["Regret","s1","s2","s3","s4"]
["d1",{"$f":"B18-$B$22","v":6},{"$f":"C18-$C$22","v":0},{"$f":"D18-$D$22","v":2},{"$f":"E18-$E$22","v":0}]
["d2",{"$f":"B19-$B$22","v":3},{"$f":"C19-$C$22","v":1},{"$f":"D19-$D$22","v":0},{"$f":"E19-$E$22","v":2}]
["d3",{"$f":"B20-$B$22","v":1},{"$f":"C20-$C$22","v":1},{"$f":"D20-$D$22","v":2},{"$f":"E20-$E$22","v":6}]
["d4",{"$f":"B21-$B$22","v":0},{"$f":"C21-$C$22","v":1},{"$f":"D21-$D$22","v":3},{"$f":"E21-$E$22","v":8}]