{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet1","index":0,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[33,1,34,1],[33,2,34,2],[33,10,34,10],[33,11,34,11],[11,10,12,10],[11,11,12,11],[35,0,43,0],[39,1,39,2],[39,10,41,11],[40,1,40,2],[22,0,23,0],[22,1,23,1],[22,2,23,2],[22,10,23,10],[22,11,23,11],[24,0,32,0],[28,1,28,2],[29,1,29,2],[28,10,30,11],[33,0,34,0],[13,0,21,0],[17,1,17,2],[18,1,18,2],[17,10,19,11],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,10,1,10],[0,11,1,11],[2,0,10,0],[6,1,6,2],[7,1,7,2],[6,10,8,11],[11,0,12,0],[11,1,12,1],[11,2,12,2]]}
["迭次","基变量","cB","x1","x2","x3","x4","x5","x6","x7","b","比值θ"]
[null,null,null,50,100,0,0,0,0]
[0,"x3",0,1,1,1,0,0,null,null,300,{"$f":"K3/(D3*D$9+E3*E$9+F3*F$9+G3*G$9+H3*H$9+I3*I9)","v":300},{"$f":"L3=MIN(L$3:L$6)","v":{"$error":"#DIV/0!"}}]
[null,"x4",0,2,1,0,1,0,null,null,400,{"$f":"K4/(D4*D$9+E4*E$9+F4*F$9+G4*G$9+H4*H$9+I4*I10)","v":400},{"$f":"L4=MIN(L$3:L$6)","v":{"$error":"#DIV/0!"}}]
[null,"x5",0,0,1,0,0,1,null,null,250,250,{"$f":"L5=MIN(L$3:L$6)","v":{"$error":"#DIV/0!"}}]
[null,"x6",{"$nulls":9},{"$f":"K6/(D6*D$9+E6*E$9+F6*F$9+G6*G$9+H6*H$9+I6*I$9)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"zj",null,{"$f":"$C3*D3+$C4*D4+$C5*D5","v":0},{"$f":"$C3*E3+$C4*E4+$C5*E5","v":0},0,0,0,0,null,{"$f":"C3*K3+C4*K4+C5*K5","v":0}]
[null,"σj",null,{"$f":"D2-D7","v":50},{"$f":"E2-E7","v":100},0,0,0,0]
[null,null,null,{"$f":"IF(D8=0,FALSE,D8=MAX($D8:$I8))","v":false},{"$f":"IF(E8=0,FALSE,E8=MAX($D8:$I8))","v":true},false,false,false,false]
[]
[]
["迭次","基变量","cB","x1","x2","x3","x4","x5","x6","x7","b","比值θ"]
[null,null,null,{"$f":"D2","v":50},{"$f":"E2","v":100},0,0,0,0]
[1,"x3",{"$f":"C3","v":0},{"$f":"D3-D5","v":1},{"$f":"E3-E5","v":0},1,0,-1,null,null,50,{"$f":"K14/(D14*D$20+E14*E$20+F14*F$20+G14*G$20+H14*H$20+I14*I$20)","v":50},{"$f":"L14=_xlfn.AGGREGATE(5,6,L$14:L$17)","v":true}]
[null,"x4",{"$f":"C4","v":0},{"$f":"D4-D5","v":2},{"$f":"E4-E5","v":0},0,1,-1,null,null,150,{"$f":"K15/(D15*D$20+E15*E$20+F15*F$20+G15*G$20+H15*H$20+I15*I$20)","v":75},{"$f":"L15=_xlfn.AGGREGATE(5,6,L$14:L$17)","v":false}]
[null,"x2",100,{"$f":"D5","v":0},{"$f":"E5","v":1},0,0,1,null,null,250,{"$f":"K16/(D16*D$20+E16*E$20+F16*F$20+G16*G$20+H16*H$20+I16*I$20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"x6",{"$nulls":8},{"$f":"K6/4","v":0},{"$f":"K17/(D17*D$20+E17*E$20+F17*F$20+G17*G$20+H17*H$20+I17*I$20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"zj",null,{"$f":"$C14*D14+$C15*D15+$C16*D16+$C17*D17","v":0},{"$f":"$C14*E14+$C15*E15+$C16*E16+$C17*E17","v":100},{"$f":"$C14*F14+$C15*F15+$C16*F16+$C17*F17","v":0},{"$f":"$C14*G14+$C15*G15+$C16*G16+$C17*G17","v":0},100,0,null,{"$f":"C14*K14+C15*K15+C16*K16+C17*K17","v":25000}]
[null,"σj",null,{"$f":"D13-D18","v":50},{"$f":"E13-E18","v":0},0,0,-100,0]
[null,null,null,{"$f":"D19=MAX($D19:$I19)","v":true},{"$f":"E19=MAX($D19:$I19)","v":false},false,false,false,false]
[]
[]
["迭次","基变量","cB","x1","x2","x3","x4","x5","x6","x7","b","比值θ"]
[null,null,null,{"$f":"D13","v":50},{"$f":"E13","v":100},{"$f":"F13","v":0},0,0]
[2,"x1",50,{"$f":"D14","v":1},{"$f":"E14","v":0},1,0,-1,null,null,50,{"$f":"K25/(D25*D$31+E25*E$31+F25*F$31+G25*G$31+H25*H$31+I25*I$31)","v":{"$error":"#DIV/0!"}},{"$f":"L25=_xlfn.AGGREGATE(5,6,L$14:L$16)","v":{"$error":"#DIV/0!"}}]
[null,"x4",null,{"$f":"D15-2*D14","v":0},{"$f":"E15-2*E14","v":0},-2,1,1,null,null,50,{"$f":"K26/(D26*D$31+E26*E$31+F26*F$31+G26*G$31+H26*H$31+I26*I$31)","v":{"$error":"#DIV/0!"}},{"$f":"L26=_xlfn.AGGREGATE(5,6,L$14:L$16)","v":{"$error":"#DIV/0!"}}]
[null,"x2",{"$f":"C16","v":100},{"$f":"D16","v":0},{"$f":"E16","v":1},0,0,1,null,null,250,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"x6",{"$nulls":9},{"$error":"#DIV/0!"}]
[null,"zj",null,{"$f":"$C25*D25+$C26*D26+$C27*D27+$C28*D28","v":50},{"$f":"$C25*E25+$C26*E26+$C27*E27+$C28*E28","v":100},50,0,50,0,null,{"$f":"C25*K25+C26*K26+C27*K27+C28*K28","v":27500}]
[null,"σj",null,{"$f":"D24-D29","v":0},{"$f":"E24-E29","v":0},-50,0,-50,0]
[null,null,null,{"$f":"IF(D30=0,FALSE,D30=MAX($D30:$I30))","v":false},{"$f":"IF(E30=0,FALSE,E30=MAX($D30:$I30))","v":false},false,false,false,false]
[]
[]
["迭次","基变量","cB","x1","x2","x3","x4","x5","x6","x7","b","比值θ"]
[null,null,null,{"$f":"D24","v":50},{"$f":"E24","v":100},{"$f":"F24","v":0},0,0]
[3,"x3",{"$nulls":9},{"$f":"K36/(D36*D$31+E36*E$31+F36*F$31+G36*G$31+H36*H$31+I36*I$31)","v":{"$error":"#DIV/0!"}},{"$f":"L36=_xlfn.AGGREGATE(5,6,L$14:L$16)","v":{"$error":"#DIV/0!"}}]
[null,"x4",{"$nulls":9},{"$f":"K37/(D37*D$31+E37*E$31+F37*F$31+G37*G$31+H37*H$31+I37*I$31)","v":{"$error":"#DIV/0!"}},{"$f":"L37=_xlfn.AGGREGATE(5,6,L$14:L$16)","v":{"$error":"#DIV/0!"}}]
[null,"x5",{"$nulls":9},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"x6",{"$nulls":9},{"$error":"#DIV/0!"}]
[null,"zj",null,{"$f":"$C36*D36+$C37*D37+$C38*D38+$C39*D39","v":0},{"$f":"$C36*E36+$C37*E37+$C38*E38+$C39*E39","v":0},{"$f":"$C36*F36+$C37*F37+$C38*F38+$C39*F39","v":0},{"$f":"$C36*G36+$C37*G37+$C38*G38+$C39*G39","v":0},{"$f":"$C36*H36+$C37*H37+$C38*H38+$C39*H39","v":0},{"$f":"$C36*I36+$C37*I37+$C38*I38+$C39*I39","v":0},null,{"$f":"C36*K36+C37*K37+C38*K38+C39*K39","v":0}]
[null,"σj",null,{"$f":"D35-D40","v":50},{"$f":"E35-E40","v":100},{"$f":"F35-F40","v":0},{"$f":"G35-G40","v":0},{"$f":"H35-H40","v":0},{"$f":"I35-I40","v":0}]
[null,null,null,{"$f":"D41=MAX($D41:$I41)","v":false},{"$f":"E41=MAX($D41:$I41)","v":true},false,false,false,false]