{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Diversification","Table 15-Improvement","Table16-RefSet Update","Combination","Improvement 2"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":15,"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":"Diversification","index":0,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[8,1,8,8],[4,12,4,13],[8,10,8,17],[0,0,0,18]]}
["Diversification Generation Method"]
[]
[null,"x1","x2","x3","x4","x5","x6","x7","x8"]
["Profit",10,14,9,8,7,5,9,3,null,null,"Capacity",38]
["Weight",7,12,8,9,8,6,11,5]
[]
["Seed",0,0,0,0,1,0,0,1]
[]
["h","Type 1",null,null,null,null,null,null,null,null,"Type 2"]
[1,{"$f":"IF(B$7<>\"\",1-B$7,\"\")","v":1},{"$f":"IF(C$7<>\"\",1-C$7,\"\")","v":1},1,1,0,{"$f":"IF(G$7<>\"\",1-G$7,\"\")","v":1},1,{"$f":"IF(I$7<>\"\",1-I$7,\"\")","v":0},null,{"$f":"IF(B10<>\"\",1-B10,\"\")","v":0},{"$f":"IF(C10<>\"\",1-C10,\"\")","v":0},0,0,1,0,0,1]
[2,{"$f":"IF(B$7<>\"\",1-B$7,\"\")","v":1},{"$f":"C$7","v":0},{"$f":"IF(D$7<>\"\",1-D$7,\"\")","v":1},{"$f":"E$7","v":0},{"$f":"IF(F$7<>\"\",1-F$7,\"\")","v":0},{"$f":"G$7","v":0},{"$f":"IF(H$7<>\"\",1-H$7,\"\")","v":1},{"$f":"I$7","v":1},null,{"$f":"IF(B11<>\"\",1-B11,\"\")","v":0},{"$f":"IF(C11<>\"\",1-C11,\"\")","v":1},{"$f":"IF(D11<>\"\",1-D11,\"\")","v":0},{"$f":"IF(E11<>\"\",1-E11,\"\")","v":1},{"$f":"IF(F11<>\"\",1-F11,\"\")","v":1},{"$f":"IF(G11<>\"\",1-G11,\"\")","v":1},{"$f":"IF(H11<>\"\",1-H11,\"\")","v":0},{"$f":"IF(I11<>\"\",1-I11,\"\")","v":0}]
[3,{"$f":"IF($B$7<>\"\",1-$B$7,\"\")","v":1},{"$f":"C$7","v":0},{"$f":"D$7","v":0},{"$f":"IF(E$7<>\"\",1-E$7,\"\")","v":1},{"$f":"F$7","v":1},{"$f":"G$7","v":0},{"$f":"IF(H$7<>\"\",1-H$7,\"\")","v":1},{"$f":"I$7","v":1},null,0,1,1,0,0,1,0,0]
[4,{"$f":"IF($B$7<>\"\",1-$B$7,\"\")","v":1},0,{"$f":"D$7","v":0},{"$f":"E$7","v":0},{"$f":"IF(F$7<>\"\",1-F$7,\"\")","v":0},{"$f":"G$7","v":0},{"$f":"H$7","v":0},{"$f":"I$7","v":1},null,0,1,1,1,1,1,1,0]
[5,{"$f":"IF($B$7<>\"\",1-$B$7,\"\")","v":1},0,{"$f":"D$7","v":0},{"$f":"E$7","v":0},{"$f":"F$7","v":1},{"$f":"IF(G$7<>\"\",1-G$7,\"\")","v":1},{"$f":"H$7","v":0},{"$f":"I$7","v":1},null,0,1,1,1,0,0,1,0]
[6,{"$f":"IF($B$7<>\"\",1-$B$7,\"\")","v":1},0,{"$f":"D$7","v":0},{"$f":"E$7","v":0},{"$f":"F$7","v":1},{"$f":"G$7","v":0},{"$f":"IF(H$7<>\"\",1-H$7,\"\")","v":1},{"$f":"I$7","v":1},null,0,1,1,1,0,1,0,0]
[7,{"$f":"IF($B$7<>\"\",1-$B$7,\"\")","v":1},0,{"$f":"D$7","v":0},{"$f":"E$7","v":0},{"$f":"F$7","v":1},{"$f":"G$7","v":0},{"$f":"H$7","v":0},{"$f":"IF(I$7<>\"\",1-I$7,\"\")","v":0},null,0,1,1,1,0,1,1,1]

{"sheet":"Table 15-Improvement","index":1,"n_rows":18,"n_cols":24,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,22],[2,1,2,11],[2,13,2,23]]}
["Table 15: Improvement Method after Diversification"]
[]
[null,"Trial Solutions",null,null,null,null,null,null,null,null,null,null,null,"Improved Solutions"]
[null,"x1","x2","x3","x4","x5","x6","x7","x8","Obj.","Weight","Div.",null,"x1","x2","x3","x4","x5","x6","x7","x8","Obj.","Weight","Div."]
[1,{"$f":"Diversification!B10","v":1},{"$f":"Diversification!C10","v":1},{"$f":"Diversification!D10","v":1},{"$f":"Diversification!E10","v":1},{"$f":"Diversification!F10","v":0},{"$f":"Diversification!G10","v":1},{"$f":"Diversification!H10","v":1},{"$f":"Diversification!I10","v":0},{"$f":"SUMPRODUCT(B5:I5,Diversification!Profit)","v":55},{"$f":"SUMPRODUCT(B5:I5,Diversification!Weight)","v":53},4.3076925277709961,null,1,1,1,1,0,0,0,0,{"$f":"IF(COUNT(N5:U5),SUMPRODUCT(N5:U5,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(N5:U5),SUMPRODUCT(N5:U5,Diversification!Weight),\"\")","v":36},3.384615421295166]
[2,{"$f":"Diversification!B11","v":1},{"$f":"Diversification!C11","v":0},{"$f":"Diversification!D11","v":1},{"$f":"Diversification!E11","v":0},{"$f":"Diversification!F11","v":0},{"$f":"Diversification!G11","v":0},{"$f":"Diversification!H11","v":1},{"$f":"Diversification!I11","v":1},{"$f":"SUMPRODUCT(B6:I6,Diversification!Profit)","v":31},{"$f":"SUMPRODUCT(B6:I6,Diversification!Weight)","v":31},4.3076925277709961,null,1,0,1,0,0,1,1,1,{"$f":"IF(COUNT(N6:U6),SUMPRODUCT(N6:U6,Diversification!Profit),\"\")","v":36},{"$f":"IF(COUNT(N6:U6),SUMPRODUCT(N6:U6,Diversification!Weight),\"\")","v":37},4.4615383148193359]
[3,{"$f":"Diversification!B12","v":1},{"$f":"Diversification!C12","v":0},{"$f":"Diversification!D12","v":0},{"$f":"Diversification!E12","v":1},{"$f":"Diversification!F12","v":1},{"$f":"Diversification!G12","v":0},{"$f":"Diversification!H12","v":1},{"$f":"Diversification!I12","v":1},{"$f":"SUMPRODUCT(B7:I7,Diversification!Profit)","v":37},{"$f":"SUMPRODUCT(B7:I7,Diversification!Weight)","v":40},4.3076925277709961,null,1,0,0,1,1,0,1,0,{"$f":"IF(COUNT(N7:U7),SUMPRODUCT(N7:U7,Diversification!Profit),\"\")","v":34},{"$f":"IF(COUNT(N7:U7),SUMPRODUCT(N7:U7,Diversification!Weight),\"\")","v":35},4.9230771064758301]
[4,{"$f":"Diversification!B13","v":1},{"$f":"Diversification!C13","v":0},{"$f":"Diversification!D13","v":0},{"$f":"Diversification!E13","v":0},{"$f":"Diversification!F13","v":0},{"$f":"Diversification!G13","v":0},{"$f":"Diversification!H13","v":0},{"$f":"Diversification!I13","v":1},{"$f":"SUMPRODUCT(B8:I8,Diversification!Profit)","v":13},{"$f":"SUMPRODUCT(B8:I8,Diversification!Weight)","v":12},4.3076925277709961,null,1,1,1,0,0,1,0,1,{"$f":"IF(COUNT(N8:U8),SUMPRODUCT(N8:U8,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(N8:U8),SUMPRODUCT(N8:U8,Diversification!Weight),\"\")","v":38},3.230769157409668]
[5,{"$f":"Diversification!B14","v":1},{"$f":"Diversification!C14","v":0},{"$f":"Diversification!D14","v":0},{"$f":"Diversification!E14","v":0},{"$f":"Diversification!F14","v":1},{"$f":"Diversification!G14","v":1},{"$f":"Diversification!H14","v":0},{"$f":"Diversification!I14","v":1},{"$f":"SUMPRODUCT(B9:I9,Diversification!Profit)","v":25},{"$f":"SUMPRODUCT(B9:I9,Diversification!Weight)","v":26},4.3076925277709961,null,1,1,0,0,1,1,0,1,{"$f":"IF(COUNT(N9:U9),SUMPRODUCT(N9:U9,Diversification!Profit),\"\")","v":39},{"$f":"IF(COUNT(N9:U9),SUMPRODUCT(N9:U9,Diversification!Weight),\"\")","v":38},3.538461446762085]
[6,{"$f":"Diversification!B15","v":1},{"$f":"Diversification!C15","v":0},{"$f":"Diversification!D15","v":0},{"$f":"Diversification!E15","v":0},{"$f":"Diversification!F15","v":1},{"$f":"Diversification!G15","v":0},{"$f":"Diversification!H15","v":1},{"$f":"Diversification!I15","v":1},{"$f":"SUMPRODUCT(B10:I10,Diversification!Profit)","v":29},{"$f":"SUMPRODUCT(B10:I10,Diversification!Weight)","v":31},4.3076925277709961,null,1,0,0,0,1,1,1,1,{"$f":"IF(COUNT(N10:U10),SUMPRODUCT(N10:U10,Diversification!Profit),\"\")","v":34},{"$f":"IF(COUNT(N10:U10),SUMPRODUCT(N10:U10,Diversification!Weight),\"\")","v":37},4.769230842590332]
[7,{"$f":"Diversification!B16","v":1},{"$f":"Diversification!C16","v":0},{"$f":"Diversification!D16","v":0},{"$f":"Diversification!E16","v":0},{"$f":"Diversification!F16","v":1},{"$f":"Diversification!G16","v":0},{"$f":"Diversification!H16","v":0},{"$f":"Diversification!I16","v":0},{"$f":"SUMPRODUCT(B11:I11,Diversification!Profit)","v":17},{"$f":"SUMPRODUCT(B11:I11,Diversification!Weight)","v":15},4.3076925277709961,null,1,1,1,0,1,0,0,0,{"$f":"IF(COUNT(N11:U11),SUMPRODUCT(N11:U11,Diversification!Profit),\"\")","v":40},{"$f":"IF(COUNT(N11:U11),SUMPRODUCT(N11:U11,Diversification!Weight),\"\")","v":35},3.384615421295166]
[8,{"$f":"Diversification!K10","v":0},{"$f":"Diversification!L10","v":0},{"$f":"Diversification!M10","v":0},{"$f":"Diversification!N10","v":0},{"$f":"Diversification!O10","v":1},{"$f":"Diversification!P10","v":0},{"$f":"Diversification!Q10","v":0},{"$f":"Diversification!R10","v":1},{"$f":"SUMPRODUCT(B12:I12,Diversification!Profit)","v":10},{"$f":"SUMPRODUCT(B12:I12,Diversification!Weight)","v":13},4.3076925277709961,null,1,1,0,0,1,1,0,1,{"$f":"IF(COUNT(N12:U12),SUMPRODUCT(N12:U12,Diversification!Profit),\"\")","v":39},{"$f":"IF(COUNT(N12:U12),SUMPRODUCT(N12:U12,Diversification!Weight),\"\")","v":38},3.538461446762085]
[9,{"$f":"Diversification!K11","v":0},{"$f":"Diversification!L11","v":1},{"$f":"Diversification!M11","v":0},{"$f":"Diversification!N11","v":1},{"$f":"Diversification!O11","v":1},{"$f":"Diversification!P11","v":1},{"$f":"Diversification!Q11","v":0},{"$f":"Diversification!R11","v":0},{"$f":"SUMPRODUCT(B13:I13,Diversification!Profit)","v":34},{"$f":"SUMPRODUCT(B13:I13,Diversification!Weight)","v":35},4.3076925277709961,null,0,1,0,1,1,1,0,0,{"$f":"IF(COUNT(N13:U13),SUMPRODUCT(N13:U13,Diversification!Profit),\"\")","v":34},{"$f":"IF(COUNT(N13:U13),SUMPRODUCT(N13:U13,Diversification!Weight),\"\")","v":35},3.846153736114502]
[10,{"$f":"Diversification!K12","v":0},{"$f":"Diversification!L12","v":1},{"$f":"Diversification!M12","v":1},{"$f":"Diversification!N12","v":0},{"$f":"Diversification!O12","v":0},{"$f":"Diversification!P12","v":1},{"$f":"Diversification!Q12","v":0},{"$f":"Diversification!R12","v":0},{"$f":"SUMPRODUCT(B14:I14,Diversification!Profit)","v":28},{"$f":"SUMPRODUCT(B14:I14,Diversification!Weight)","v":26},4.3076925277709961,null,1,1,1,0,0,1,0,1,{"$f":"IF(COUNT(N14:U14),SUMPRODUCT(N14:U14,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(N14:U14),SUMPRODUCT(N14:U14,Diversification!Weight),\"\")","v":38},3.230769157409668]
[11,{"$f":"Diversification!K13","v":0},{"$f":"Diversification!L13","v":1},{"$f":"Diversification!M13","v":1},{"$f":"Diversification!N13","v":1},{"$f":"Diversification!O13","v":1},{"$f":"Diversification!P13","v":1},{"$f":"Diversification!Q13","v":1},{"$f":"Diversification!R13","v":0},{"$f":"SUMPRODUCT(B15:I15,Diversification!Profit)","v":52},{"$f":"SUMPRODUCT(B15:I15,Diversification!Weight)","v":54},4.3076925277709961,null,0,1,1,1,1,0,0,0,{"$f":"IF(COUNT(N15:U15),SUMPRODUCT(N15:U15,Diversification!Profit),\"\")","v":38},{"$f":"IF(COUNT(N15:U15),SUMPRODUCT(N15:U15,Diversification!Weight),\"\")","v":37},3.846153736114502]
[12,{"$f":"Diversification!K14","v":0},{"$f":"Diversification!L14","v":1},{"$f":"Diversification!M14","v":1},{"$f":"Diversification!N14","v":1},{"$f":"Diversification!O14","v":0},{"$f":"Diversification!P14","v":0},{"$f":"Diversification!Q14","v":1},{"$f":"Diversification!R14","v":0},{"$f":"SUMPRODUCT(B16:I16,Diversification!Profit)","v":40},{"$f":"SUMPRODUCT(B16:I16,Diversification!Weight)","v":40},4.3076925277709961,null,1,1,1,1,0,0,0,0,{"$f":"IF(COUNT(N16:U16),SUMPRODUCT(N16:U16,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(N16:U16),SUMPRODUCT(N16:U16,Diversification!Weight),\"\")","v":36},3.384615421295166]
[13,{"$f":"Diversification!K15","v":0},{"$f":"Diversification!L15","v":1},{"$f":"Diversification!M15","v":1},{"$f":"Diversification!N15","v":1},{"$f":"Diversification!O15","v":0},{"$f":"Diversification!P15","v":1},{"$f":"Diversification!Q15","v":0},{"$f":"Diversification!R15","v":0},{"$f":"SUMPRODUCT(B17:I17,Diversification!Profit)","v":36},{"$f":"SUMPRODUCT(B17:I17,Diversification!Weight)","v":35},4.3076925277709961,null,0,1,1,1,0,1,0,0,{"$f":"IF(COUNT(N17:U17),SUMPRODUCT(N17:U17,Diversification!Profit),\"\")","v":36},{"$f":"IF(COUNT(N17:U17),SUMPRODUCT(N17:U17,Diversification!Weight),\"\")","v":35},3.538461446762085]
[14,{"$f":"Diversification!K16","v":0},{"$f":"Diversification!L16","v":1},{"$f":"Diversification!M16","v":1},{"$f":"Diversification!N16","v":1},{"$f":"Diversification!O16","v":0},{"$f":"Diversification!P16","v":1},{"$f":"Diversification!Q16","v":1},{"$f":"Diversification!R16","v":1},{"$f":"SUMPRODUCT(B18:I18,Diversification!Profit)","v":48},{"$f":"SUMPRODUCT(B18:I18,Diversification!Weight)","v":51},4.3076925277709961,null,0,1,1,1,0,1,0,0,{"$f":"IF(COUNT(N18:U18),SUMPRODUCT(N18:U18,Diversification!Profit),\"\")","v":36},{"$f":"IF(COUNT(N18:U18),SUMPRODUCT(N18:U18,Diversification!Weight),\"\")","v":35},3.538461446762085]

{"sheet":"Table16-RefSet Update","index":2,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[6,13,6,14],[3,2,3,9],[0,0,0,18],[12,2,12,9]]}
["Table 16: Reference Set Update Methods"]
[]
["Method 1"]
[null,null,"Reference Set"]
[null,null,"x1","x2","x3","x4","x5","x6","x7","x8",null,"Profit","Weight"]
["Quality",1,1,1,1,1,0,0,0,0,null,{"$f":"IF(COUNT(C6:J6),SUMPRODUCT(C6:J6,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(C6:J6),SUMPRODUCT(C6:J6,Diversification!Weight),\"\")","v":36}]
[null,2,1,1,1,0,0,1,0,1,null,{"$f":"IF(COUNT(C7:J7),SUMPRODUCT(C7:J7,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(C7:J7),SUMPRODUCT(C7:J7,Diversification!Weight),\"\")","v":38}]
[null,3,1,1,1,0,1,0,0,0,null,{"$f":"IF(COUNT(C8:J8),SUMPRODUCT(C8:J8,Diversification!Profit),\"\")","v":40},{"$f":"IF(COUNT(C8:J8),SUMPRODUCT(C8:J8,Diversification!Weight),\"\")","v":35}]
[null,4,1,1,0,0,1,1,0,1,null,{"$f":"IF(COUNT(C9:J9),SUMPRODUCT(C9:J9,Diversification!Profit),\"\")","v":39},{"$f":"IF(COUNT(C9:J9),SUMPRODUCT(C9:J9,Diversification!Weight),\"\")","v":38}]
[]
[]
["Method 2"]
[null,null,"Reference Set"]
[null,null,"x1","x2","x3","x4","x5","x6","x7","x8",null,"Profit","Weight"]
["Quality",1,1,1,1,1,0,0,0,0,null,{"$f":"IF(COUNT(C15:J15),SUMPRODUCT(C15:J15,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(C15:J15),SUMPRODUCT(C15:J15,Diversification!Weight),\"\")","v":36}]
[null,2,1,1,1,0,0,1,0,1,null,{"$f":"IF(COUNT(C16:J16),SUMPRODUCT(C16:J16,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(C16:J16),SUMPRODUCT(C16:J16,Diversification!Weight),\"\")","v":38}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Min Div"]
["Diverse",3,1,0,0,1,1,0,1,0,null,{"$f":"IF(COUNT(C18:J18),SUMPRODUCT(C18:J18,Diversification!Profit),\"\")","v":34},{"$f":"IF(COUNT(C18:J18),SUMPRODUCT(C18:J18,Diversification!Weight),\"\")","v":35},4]
[null,4,0,1,0,1,1,1,0,0,null,{"$f":"IF(COUNT(C19:J19),SUMPRODUCT(C19:J19,Diversification!Profit),\"\")","v":34},{"$f":"IF(COUNT(C19:J19),SUMPRODUCT(C19:J19,Diversification!Weight),\"\")","v":35},4]

{"sheet":"Combination","index":3,"n_rows":20,"n_cols":31,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,8],[2,10,2,17],[2,19,2,26],[0,0,0,28],[12,1,12,8],[12,10,12,17],[12,19,12,26]]}
["Combination Method"]
[]
[null,"Reference Solution",null,null,null,null,null,null,null,null,"Reference Solution",null,null,null,null,null,null,null,null,"Combined Solution"]
[null,"x1","x2","x3","x4","x5","x6","x7","x8","P","x1","x2","x3","x4","x5","x6","x7","x8","P","x1","x2","x3","x4","x5","x6","x7","x8","P","W"]
[1,1,1,1,1,0,0,0,0,{"$f":"IF(COUNT(B5:I5)=8,SUMPRODUCT(B5:I5,Diversification!Profit),\"\")","v":41},1,1,1,0,0,1,0,1,{"$f":"IF(COUNT(K5:R5)=8,SUMPRODUCT(K5:R5,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT($J5,$S5)=2,IF(RAND()<=(B5*$J5+K5*$S5)/($J5+$S5),1,0),\"\")","v":1},{"$f":"IF(COUNT($J5,$S5)=2,IF(RAND()<=(C5*$J5+L5*$S5)/($J5+$S5),1,0),\"\")","v":1},1,1,0,1,0,1,{"$f":"IF(COUNT($T5:$AA5)=8,SUMPRODUCT($T5:$AA5,Diversification!Profit),\"\")","v":49},{"$f":"IF(COUNT($T5:$AA5)=8,IF(SUMPRODUCT($T5:$AA5,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":"I"},null,{"$f":"IF(COUNT(#REF!)=8,IF(SUMPRODUCT(#REF!,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""}]
[2,1,1,1,1,0,0,0,0,{"$f":"IF(COUNT(B6:I6)=8,SUMPRODUCT(B6:I6,Diversification!Profit),\"\")","v":41},1,1,1,0,1,0,0,0,{"$f":"IF(COUNT(K6:R6)=8,SUMPRODUCT(K6:R6,Diversification!Profit),\"\")","v":40},{"$f":"IF(COUNT($J6,$S6)=2,IF(RAND()<=(B6*$J6+K6*$S6)/($J6+$S6),1,0),\"\")","v":1},{"$f":"IF(COUNT($J6,$S6)=2,IF(RAND()<=(C6*$J6+L6*$S6)/($J6+$S6),1,0),\"\")","v":1},1,1,1,0,0,0,{"$f":"IF(COUNT(T6:AA6)=8,SUMPRODUCT(T6:AA6,Diversification!Profit),\"\")","v":48},{"$f":"IF(COUNT($T6:$AA6)=8,IF(SUMPRODUCT($T6:$AA6,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":"I"},null,{"$f":"IF(COUNT(#REF!)=8,IF(SUMPRODUCT(#REF!,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""}]
[3,1,1,1,1,0,0,0,0,{"$f":"IF(COUNT(B7:I7)=8,SUMPRODUCT(B7:I7,Diversification!Profit),\"\")","v":41},1,1,0,0,1,1,0,1,{"$f":"IF(COUNT(K7:R7)=8,SUMPRODUCT(K7:R7,Diversification!Profit),\"\")","v":39},{"$f":"IF(COUNT($J7,$S7)=2,IF(RAND()<=(B7*$J7+K7*$S7)/($J7+$S7),1,0),\"\")","v":1},1,1,0,1,0,0,1,{"$f":"IF(COUNT(T7:AA7)=8,SUMPRODUCT(T7:AA7,Diversification!Profit),\"\")","v":43},{"$f":"IF(COUNT($T7:$AA7)=8,IF(SUMPRODUCT($T7:$AA7,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":"I"},null,{"$f":"IF(COUNT(#REF!)=8,IF(SUMPRODUCT(#REF!,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""}]
[4,1,1,1,0,0,1,0,1,{"$f":"IF(COUNT(B8:I8)=8,SUMPRODUCT(B8:I8,Diversification!Profit),\"\")","v":41},1,1,1,0,1,0,0,0,{"$f":"IF(COUNT(K8:R8)=8,SUMPRODUCT(K8:R8,Diversification!Profit),\"\")","v":40},1,1,{"$f":"IF(COUNT($J8,$S8)=2,IF(RAND()<=(D8*$J8+M8*$S8)/($J8+$S8),1,0),\"\")","v":1},0,0,1,0,0,{"$f":"IF(COUNT(T8:AA8)=8,SUMPRODUCT(T8:AA8,Diversification!Profit),\"\")","v":38},{"$f":"IF(COUNT($T8:$AA8)=8,IF(SUMPRODUCT($T8:$AA8,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""},null,{"$f":"IF(COUNT(#REF!)=8,IF(SUMPRODUCT(#REF!,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""}]
[5,1,1,1,0,0,1,0,1,{"$f":"IF(COUNT(B9:I9)=8,SUMPRODUCT(B9:I9,Diversification!Profit),\"\")","v":41},1,1,0,0,1,1,0,1,{"$f":"IF(COUNT(K9:R9)=8,SUMPRODUCT(K9:R9,Diversification!Profit),\"\")","v":39},1,1,0,0,0,1,0,1,{"$f":"IF(COUNT(T9:AA9)=8,SUMPRODUCT(T9:AA9,Diversification!Profit),\"\")","v":32},{"$f":"IF(COUNT($T9:$AA9)=8,IF(SUMPRODUCT($T9:$AA9,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""},null,{"$f":"IF(COUNT(#REF!)=8,IF(SUMPRODUCT(#REF!,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""}]
[6,1,1,1,0,1,0,0,0,{"$f":"IF(COUNT(B10:I10)=8,SUMPRODUCT(B10:I10,Diversification!Profit),\"\")","v":40},1,1,0,0,1,1,0,1,{"$f":"IF(COUNT(K10:R10)=8,SUMPRODUCT(K10:R10,Diversification!Profit),\"\")","v":39},1,1,0,0,1,0,0,1,{"$f":"IF(COUNT(T10:AA10)=8,SUMPRODUCT(T10:AA10,Diversification!Profit),\"\")","v":34},{"$f":"IF(COUNT($T10:$AA10)=8,IF(SUMPRODUCT($T10:$AA10,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""},null,{"$f":"IF(COUNT(#REF!)=8,IF(SUMPRODUCT(#REF!,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""}]
[]
[]
[null,"Reference Solution",null,null,null,null,null,null,null,null,"Reference Solution",null,null,null,null,null,null,null,null,"Combined Solution"]
[null,"x1","x2","x3","x4","x5","x6","x7","x8","P","x1","x2","x3","x4","x5","x6","x7","x8","P","x1","x2","x3","x4","x5","x6","x7","x8","P","W"]
[1,1,1,1,1,0,0,0,0,{"$f":"IF(COUNT(B15:I15)=8,SUMPRODUCT(B15:I15,Diversification!Profit),\"\")","v":41},1,1,1,0,0,1,0,1,{"$f":"IF(COUNT(K15:R15)=8,SUMPRODUCT(K15:R15,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT($J15,$S15)=2,IF(RAND()<=(B15*$J15+K15*$S15)/($J15+$S15),1,0),\"\")","v":1},{"$f":"IF(COUNT($J15,$S15)=2,IF(RAND()<=(C15*$J15+L15*$S15)/($J15+$S15),1,0),\"\")","v":1},{"$f":"IF(COUNT($J15,$S15)=2,IF(RAND()<=(D15*$J15+M15*$S15)/($J15+$S15),1,0),\"\")","v":1},{"$f":"IF(COUNT($J15,$S15)=2,IF(RAND()<=(E15*$J15+N15*$S15)/($J15+$S15),1,0),\"\")","v":0},{"$f":"IF(COUNT($J15,$S15)=2,IF(RAND()<=(F15*$J15+O15*$S15)/($J15+$S15),1,0),\"\")","v":0},{"$f":"IF(COUNT($J15,$S15)=2,IF(RAND()<=(G15*$J15+P15*$S15)/($J15+$S15),1,0),\"\")","v":0},{"$f":"IF(COUNT($J15,$S15)=2,IF(RAND()<=(H15*$J15+Q15*$S15)/($J15+$S15),1,0),\"\")","v":0},{"$f":"IF(COUNT($J15,$S15)=2,IF(RAND()<=(I15*$J15+R15*$S15)/($J15+$S15),1,0),\"\")","v":1},{"$f":"IF(COUNT(T15:AA15)=8,SUMPRODUCT(T15:AA15,Diversification!Profit),\"\")","v":36},{"$f":"IF(COUNT($T15:$AA15)=8,IF(SUMPRODUCT($T15:$AA15,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""}]
[2,1,1,1,1,0,0,0,0,{"$f":"IF(COUNT(B16:I16)=8,SUMPRODUCT(B16:I16,Diversification!Profit),\"\")","v":41},1,0,0,1,1,0,1,0,{"$f":"IF(COUNT(K16:R16)=8,SUMPRODUCT(K16:R16,Diversification!Profit),\"\")","v":34},1,1,0,1,1,0,1,0,{"$f":"IF(COUNT(T16:AA16)=8,SUMPRODUCT(T16:AA16,Diversification!Profit),\"\")","v":48},{"$f":"IF(COUNT($T16:$AA16)=8,IF(SUMPRODUCT($T16:$AA16,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":"I"}]
[3,1,1,1,1,0,0,0,0,{"$f":"IF(COUNT(B17:I17)=8,SUMPRODUCT(B17:I17,Diversification!Profit),\"\")","v":41},0,1,0,1,1,1,0,0,{"$f":"IF(COUNT(K17:R17)=8,SUMPRODUCT(K17:R17,Diversification!Profit),\"\")","v":34},0,{"$f":"IF(COUNT($J17,$S17)=2,IF(RAND()<=(C17*$J17+L17*$S17)/($J17+$S17),1,0),\"\")","v":1},1,1,0,0,0,0,{"$f":"IF(COUNT(T17:AA17)=8,SUMPRODUCT(T17:AA17,Diversification!Profit),\"\")","v":31},{"$f":"IF(COUNT($T17:$AA17)=8,IF(SUMPRODUCT($T17:$AA17,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""}]
[4,1,1,1,0,0,1,0,1,{"$f":"IF(COUNT(B18:I18)=8,SUMPRODUCT(B18:I18,Diversification!Profit),\"\")","v":41},1,0,0,1,1,0,1,0,{"$f":"IF(COUNT(K18:R18)=8,SUMPRODUCT(K18:R18,Diversification!Profit),\"\")","v":34},1,0,1,1,0,0,1,1,{"$f":"IF(COUNT(T18:AA18)=8,SUMPRODUCT(T18:AA18,Diversification!Profit),\"\")","v":39},{"$f":"IF(COUNT($T18:$AA18)=8,IF(SUMPRODUCT($T18:$AA18,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":"I"}]
[5,1,1,1,0,0,1,0,1,{"$f":"IF(COUNT(B19:I19)=8,SUMPRODUCT(B19:I19,Diversification!Profit),\"\")","v":41},0,1,0,1,1,1,0,0,{"$f":"IF(COUNT(K19:R19)=8,SUMPRODUCT(K19:R19,Diversification!Profit),\"\")","v":34},0,1,0,1,1,1,0,0,{"$f":"IF(COUNT(T19:AA19)=8,SUMPRODUCT(T19:AA19,Diversification!Profit),\"\")","v":34},{"$f":"IF(COUNT($T19:$AA19)=8,IF(SUMPRODUCT($T19:$AA19,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""}]
[6,1,0,0,1,1,0,1,0,{"$f":"IF(COUNT(B20:I20)=8,SUMPRODUCT(B20:I20,Diversification!Profit),\"\")","v":34},0,1,0,1,1,1,0,0,{"$f":"IF(COUNT(K20:R20)=8,SUMPRODUCT(K20:R20,Diversification!Profit),\"\")","v":34},0,0,0,1,1,1,0,0,{"$f":"IF(COUNT(T20:AA20)=8,SUMPRODUCT(T20:AA20,Diversification!Profit),\"\")","v":20},{"$f":"IF(COUNT($T20:$AA20)=8,IF(SUMPRODUCT($T20:$AA20,Diversification!Weight)>Diversification!Capacity,\"I\",\"\"),\"\")","v":""}]

{"sheet":"Improvement 2","index":4,"n_rows":17,"n_cols":22,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,21],[2,1,2,10],[2,12,2,21]]}
["Improvement Method after Combination"]
[]
[null,"Trial Solutions",null,null,null,null,null,null,null,null,null,null,"Improved Solutions"]
[null,"x1","x2","x3","x4","x5","x6","x7","x8","Obj.","Weight",null,"x1","x2","x3","x4","x5","x6","x7","x8","Obj.","Weight"]
[1,{"$f":"Combination!T5","v":1},{"$f":"Combination!U5","v":1},{"$f":"Combination!V5","v":1},{"$f":"Combination!W5","v":1},{"$f":"Combination!X5","v":0},{"$f":"Combination!Y5","v":1},{"$f":"Combination!Z5","v":0},{"$f":"Combination!AA5","v":1},{"$f":"SUMPRODUCT(B5:I5,Diversification!Profit)","v":49},{"$f":"SUMPRODUCT(B5:I5,Diversification!Weight)","v":47},null,1,1,1,0,0,1,0,1,{"$f":"IF(COUNT(M5:T5),SUMPRODUCT(M5:T5,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(M5:T5),SUMPRODUCT(M5:T5,Diversification!Weight),\"\")","v":38}]
[2,{"$f":"Combination!T6","v":1},{"$f":"Combination!U6","v":1},{"$f":"Combination!V6","v":1},{"$f":"Combination!W6","v":1},{"$f":"Combination!X6","v":1},{"$f":"Combination!Y6","v":0},{"$f":"Combination!Z6","v":0},{"$f":"Combination!AA6","v":0},{"$f":"SUMPRODUCT(B6:I6,Diversification!Profit)","v":48},{"$f":"SUMPRODUCT(B6:I6,Diversification!Weight)","v":44},null,1,1,1,1,0,0,0,0,{"$f":"IF(COUNT(M6:T6),SUMPRODUCT(M6:T6,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(M6:T6),SUMPRODUCT(M6:T6,Diversification!Weight),\"\")","v":36}]
[3,{"$f":"Combination!T7","v":1},{"$f":"Combination!U7","v":1},{"$f":"Combination!V7","v":1},{"$f":"Combination!W7","v":0},{"$f":"Combination!X7","v":1},{"$f":"Combination!Y7","v":0},{"$f":"Combination!Z7","v":0},{"$f":"Combination!AA7","v":1},{"$f":"SUMPRODUCT(B7:I7,Diversification!Profit)","v":43},{"$f":"SUMPRODUCT(B7:I7,Diversification!Weight)","v":40},null,1,1,0,1,0,1,0,0,{"$f":"IF(COUNT(M7:T7),SUMPRODUCT(M7:T7,Diversification!Profit),\"\")","v":37},{"$f":"IF(COUNT(M7:T7),SUMPRODUCT(M7:T7,Diversification!Weight),\"\")","v":34}]
[4,{"$f":"Combination!T8","v":1},{"$f":"Combination!U8","v":1},{"$f":"Combination!V8","v":1},{"$f":"Combination!W8","v":0},{"$f":"Combination!X8","v":0},{"$f":"Combination!Y8","v":1},{"$f":"Combination!Z8","v":0},{"$f":"Combination!AA8","v":0},{"$f":"SUMPRODUCT(B8:I8,Diversification!Profit)","v":38},{"$f":"SUMPRODUCT(B8:I8,Diversification!Weight)","v":33},null,1,1,1,0,1,0,0,0,{"$f":"IF(COUNT(M8:T8),SUMPRODUCT(M8:T8,Diversification!Profit),\"\")","v":40},{"$f":"IF(COUNT(M8:T8),SUMPRODUCT(M8:T8,Diversification!Weight),\"\")","v":35}]
[5,{"$f":"Combination!T9","v":1},{"$f":"Combination!U9","v":1},{"$f":"Combination!V9","v":0},{"$f":"Combination!W9","v":0},{"$f":"Combination!X9","v":0},{"$f":"Combination!Y9","v":1},{"$f":"Combination!Z9","v":0},{"$f":"Combination!AA9","v":1},{"$f":"SUMPRODUCT(B9:I9,Diversification!Profit)","v":32},{"$f":"SUMPRODUCT(B9:I9,Diversification!Weight)","v":30},null,1,1,0,0,1,1,0,1,{"$f":"IF(COUNT(M9:T9),SUMPRODUCT(M9:T9,Diversification!Profit),\"\")","v":39},{"$f":"IF(COUNT(M9:T9),SUMPRODUCT(M9:T9,Diversification!Weight),\"\")","v":38}]
[6,{"$f":"Combination!T10","v":1},{"$f":"Combination!U10","v":1},{"$f":"Combination!V10","v":0},{"$f":"Combination!W10","v":0},{"$f":"Combination!X10","v":1},{"$f":"Combination!Y10","v":0},{"$f":"Combination!Z10","v":0},{"$f":"Combination!AA10","v":1},{"$f":"SUMPRODUCT(B10:I10,Diversification!Profit)","v":34},{"$f":"SUMPRODUCT(B10:I10,Diversification!Weight)","v":32},null,1,1,0,0,1,1,0,1,{"$f":"IF(COUNT(M10:T10),SUMPRODUCT(M10:T10,Diversification!Profit),\"\")","v":39},{"$f":"IF(COUNT(M10:T10),SUMPRODUCT(M10:T10,Diversification!Weight),\"\")","v":38}]
[]
[1,{"$f":"Combination!T15","v":1},{"$f":"Combination!U15","v":1},{"$f":"Combination!V15","v":1},{"$f":"Combination!W15","v":0},{"$f":"Combination!X15","v":0},{"$f":"Combination!Y15","v":0},{"$f":"Combination!Z15","v":0},{"$f":"Combination!AA15","v":1},{"$f":"SUMPRODUCT(B12:I12,Diversification!Profit)","v":36},{"$f":"SUMPRODUCT(B12:I12,Diversification!Weight)","v":32},null,1,1,1,1,0,0,0,0,{"$f":"IF(COUNT(M12:T12),SUMPRODUCT(M12:T12,Diversification!Profit),\"\")","v":41},{"$f":"IF(COUNT(M12:T12),SUMPRODUCT(M12:T12,Diversification!Weight),\"\")","v":36}]
[2,{"$f":"Combination!T16","v":1},{"$f":"Combination!U16","v":1},{"$f":"Combination!V16","v":0},{"$f":"Combination!W16","v":1},{"$f":"Combination!X16","v":1},{"$f":"Combination!Y16","v":0},{"$f":"Combination!Z16","v":1},{"$f":"Combination!AA16","v":0},{"$f":"SUMPRODUCT(B13:I13,Diversification!Profit)","v":48},{"$f":"SUMPRODUCT(B13:I13,Diversification!Weight)","v":47},null,1,0,1,1,0,0,1,0,{"$f":"IF(COUNT(M13:T13),SUMPRODUCT(M13:T13,Diversification!Profit),\"\")","v":36},{"$f":"IF(COUNT(M13:T13),SUMPRODUCT(M13:T13,Diversification!Weight),\"\")","v":35}]
[3,{"$f":"Combination!T17","v":0},{"$f":"Combination!U17","v":1},{"$f":"Combination!V17","v":1},{"$f":"Combination!W17","v":1},{"$f":"Combination!X17","v":0},{"$f":"Combination!Y17","v":0},{"$f":"Combination!Z17","v":0},{"$f":"Combination!AA17","v":0},{"$f":"SUMPRODUCT(B14:I14,Diversification!Profit)","v":31},{"$f":"SUMPRODUCT(B14:I14,Diversification!Weight)","v":29},null,1,1,0,1,1,0,0,0,{"$f":"IF(COUNT(M14:T14),SUMPRODUCT(M14:T14,Diversification!Profit),\"\")","v":39},{"$f":"IF(COUNT(M14:T14),SUMPRODUCT(M14:T14,Diversification!Weight),\"\")","v":36}]
[4,{"$f":"Combination!T18","v":1},{"$f":"Combination!U18","v":0},{"$f":"Combination!V18","v":1},{"$f":"Combination!W18","v":1},{"$f":"Combination!X18","v":0},{"$f":"Combination!Y18","v":0},{"$f":"Combination!Z18","v":1},{"$f":"Combination!AA18","v":1},{"$f":"SUMPRODUCT(B15:I15,Diversification!Profit)","v":39},{"$f":"SUMPRODUCT(B15:I15,Diversification!Weight)","v":40},null,1,0,0,0,1,1,1,1,{"$f":"IF(COUNT(M15:T15),SUMPRODUCT(M15:T15,Diversification!Profit),\"\")","v":34},{"$f":"IF(COUNT(M15:T15),SUMPRODUCT(M15:T15,Diversification!Weight),\"\")","v":37}]
[5,{"$f":"Combination!T19","v":0},{"$f":"Combination!U19","v":1},{"$f":"Combination!V19","v":0},{"$f":"Combination!W19","v":1},{"$f":"Combination!X19","v":1},{"$f":"Combination!Y19","v":1},{"$f":"Combination!Z19","v":0},{"$f":"Combination!AA19","v":0},{"$f":"SUMPRODUCT(B16:I16,Diversification!Profit)","v":34},{"$f":"SUMPRODUCT(B16:I16,Diversification!Weight)","v":35},null,0,1,1,1,1,0,0,0,{"$f":"IF(COUNT(M16:T16),SUMPRODUCT(M16:T16,Diversification!Profit),\"\")","v":38},{"$f":"IF(COUNT(M16:T16),SUMPRODUCT(M16:T16,Diversification!Weight),\"\")","v":37}]
[6,{"$f":"Combination!T20","v":0},{"$f":"Combination!U20","v":0},{"$f":"Combination!V20","v":0},{"$f":"Combination!W20","v":1},{"$f":"Combination!X20","v":1},{"$f":"Combination!Y20","v":1},{"$f":"Combination!Z20","v":0},{"$f":"Combination!AA20","v":0},{"$f":"SUMPRODUCT(B17:I17,Diversification!Profit)","v":20},{"$f":"SUMPRODUCT(B17:I17,Diversification!Weight)","v":23},null,0,0,0,1,1,1,1,0,{"$f":"IF(COUNT(M17:T17),SUMPRODUCT(M17:T17,Diversification!Profit),\"\")","v":29},{"$f":"IF(COUNT(M17:T17),SUMPRODUCT(M17:T17,Diversification!Weight),\"\")","v":34}]