{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Start","7.3 Template","Example A","Example B","Example C","Example D","Sheet1"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":44,"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":"Start","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[4,2,4,8]]}
[]
[null,"To use the Template, you need to add : Solver as Add-Ins into your Excel"]
[]
[null,null,"Video Instruction:"]
[null,null,"https://www.youtube.com/watch?v=LKV6fT8xApA"]
[]
[]
[null,"Next, you need to do the following 2 steps:"]
[]
[null,"Step 1:  press Alt+F11 to open up VBA."]
[]
[null,"Step 2: Add the Solver reference in visual basic"]
[null,null,"Tools > References..., then make sure that SOLVER is checked"]
[null,null,"Check then click OK"]
[]
[]
[null,null,"Save the file, and you don't have to do that again"]

{"sheet":"7.3 Template","index":1,"n_rows":23,"n_cols":31,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,8,23,8],[22,16,23,16],[4,33,4,37],[8,2,12,2],[8,3,12,3],[8,20,9,20],[8,27,9,27],[8,8,9,8],[8,12,9,12],[8,16,9,16],[8,28,9,28]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"Fill Green Cells","x:","y:",null,null,null,null,null,"Fill Green Cells","x:","y:",null,null,null,null,null,"Max","Min",null,"Max","Min",null,"Max"]
[null,null,null,null,null,null,null,null,"Products:",null,null,null,null,null,null,null,"Products:",null,null,null,null,null,null,null,{"$f":"MAX($AB$7)","v":0},{"$f":"MIN($AC$7)","v":0},null,"Total Profit","Total Profit",null,"Min"]
[null,null,null,null,null,null,null,null,"Production quantity",null,null,null,null,null,null,null,"Production quantity",null,null,null,null,null,null,null,{"$f":"COUNT($J$6:$K$6)","v":0},{"$f":"COUNT($R$6:$S$6)","v":0}]
[null,null,null,null,null,null,null,null,"Objective:\nMaximum F =",null,null,null,null,null,null,null,"Objective:\nMinimum F =",null,null,null,null,null,null,null,{"$f":"$AB$12<=$M$12","v":true},{"$f":"$AC$14>=$U$14","v":true},null,{"$f":"(J7*J6)+(K7*K6)","v":0},{"$f":"(R7*R6)+(S7*S6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AB$13<=$M$13","v":true},{"$f":"$AC$13>=$U$13","v":true}]
[null,null,null,null,null,null,null,null,"Constraints:\nIngredient, Units","x: ","y: ",null,"Available",null,null,null,"Constraints:\nIngredient, Units","x: ","y: ",null,"Available",null,null,null,{"$f":"$AB$14<=$M$14","v":true},{"$f":"$AC$15>=$U$15","v":true},null,"Used","Used"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J5=\"\",\"\",J5)","v":""},{"$f":"IF(K5=\"\",\"\",K5)","v":""},null,null,null,null,null,null,{"$f":"IF(R5=\"\",\"\",R5)","v":""},{"$f":"IF(S5=\"\",\"\",S5)","v":""},null,null,null,null,null,{"$f":"$AB$15<=$M$15","v":true},{"$f":"$AC$11>=$U$11","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AB$11<=$M$11","v":true},{"$f":"$AC$12>=$U$12","v":true},null,{"$f":"(J11*$J$6)+(K11*$K$6)","v":0},{"$f":"(R11*$R$6)+(S11*$S$6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"{32767,32767,0.000001,0.01,TRUE,FALSE,FALSE,1,1,1,0.0001,TRUE}","v":32767},{"$f":"{32767,32767,0.000001,0.01,TRUE,FALSE,FALSE,1,1,1,0.0001,TRUE}","v":32767},null,{"$f":"(J12*$J$6)+(K12*$K$6)","v":0},{"$f":"(R12*$R$6)+(S12*$S$6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"{0,0,2,0,0,FALSE,FALSE,0.075,0,0,FALSE,30}","v":0},{"$f":"{0,0,2,0,0,FALSE,FALSE,0.075,0,0,FALSE,30}","v":0},null,{"$f":"(J13*$J$6)+(K13*$K$6)","v":0},{"$f":"(R13*$R$6)+(S13*$S$6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J14*$J$6)+(K14*$K$6)","v":0},{"$f":"(R14*$R$6)+(S14*$S$6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(J15*$J$6)+(K15*$K$6)","v":0},{"$f":"(R15*$R$6)+(S15*$S$6)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"x =","y =",null,"Max F =",null,null,null,null,"x =","y =",null,"Min F ="]
[null,null,null,null,null,null,null,null,"Results",{"$f":"IF(J7+K7=0,\"\",ROUND(J6,2))","v":""},{"$f":"IF(J7+K7=0,\"\",ROUND(K6,2))","v":""},null,{"$f":"IF(J7+K7=0,\"\",ROUND(AB7,2))","v":""},null,null,null,"Results",{"$f":"IF(R7+S7=0,\"\",ROUND(R6,2))","v":""},{"$f":"IF(R7+S7=0,\"\",ROUND(S6,2))","v":""},null,{"$f":"IF(R7+S7=0,\"\",ROUND(AC7,2))","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(J7+K7=0,\"\",\"Data Entered: \")","v":""},null,null,null,null,null,null,null,{"$f":"IF(R7+S7=0,\"\",\"Data Entered: \")","v":""}]

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

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

{"sheet":"Example C","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Example D","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":6,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,{"$f":"IF(OR('7.3 Template'!J7=0,'7.3 Template'!K7=0),\"\",\"     Data Entered\")","v":""},null,null,null,null,null,{"$f":"IF(OR('7.3 Template'!R7=0,'7.3 Template'!S7=0),\"\",\"     Data Entered\")","v":""}]
[null,null,{"$f":"IF(OR(C19=0,D19=0),\"\",\"     Max F = \"&C19&\" x + \"&D19&\" y\")","v":""},null,null,null,null,null,{"$f":"IF(OR(H19=0,I19=0),\"\",\"     Min F = \"&H19&\" x + \"&I19&\" y\")","v":""}]
[null,null,{"$f":"IF(OR(D13=0,D13=\"\"),\"\",B13&\" x + \" &C13&\" y \")","v":""},{"$f":"IF(OR(D13=0,D13=\"\"),\"\",\" <=  \"&D13)","v":""},null,null,null,null,{"$f":"IF(OR(J13=0,J13=\"\"),\"\",H13&\" x + \" &I13&\" y \")","v":""},{"$f":"IF(OR(J13=0,J13=\"\"),\"\",\" >=  \"&J13)","v":""}]
[null,null,{"$f":"IF(OR(D14=0,D14=\"\"),\"\",B14&\" x + \" &C14&\" y \")","v":""},{"$f":"IF(OR(D14=0,D14=\"\"),\"\",\" <=  \"&D14)","v":""},null,null,null,null,{"$f":"IF(OR(J14=0,J14=\"\"),\"\",H14&\" x + \" &I14&\" y \")","v":""},{"$f":"IF(OR(J14=0,J14=\"\"),\"\",\" >=  \"&J14)","v":""}]
[null,null,"","",null,null,null,null,{"$f":"IF(OR(J15=0,J15=\"\"),\"\",H15&\" x + \" &I15&\" y \")","v":""},""]
[null,null,"","",null,null,null,null,"",""]
[null,null,"","",null,null,null,null,"",""]
[]
[]
[]
[null,{"$f":"'7.3 Template'!J11","v":0},{"$f":"'7.3 Template'!K11","v":0},{"$f":"'7.3 Template'!M11","v":0},null,null,null,{"$f":"'7.3 Template'!R11","v":0},{"$f":"'7.3 Template'!S11","v":0},{"$f":"'7.3 Template'!U11","v":0}]
[null,{"$f":"'7.3 Template'!J12","v":0},{"$f":"'7.3 Template'!K12","v":0},{"$f":"'7.3 Template'!M12","v":0},null,null,null,{"$f":"'7.3 Template'!R12","v":0},{"$f":"'7.3 Template'!S12","v":0},{"$f":"'7.3 Template'!U12","v":0}]
[null,{"$f":"'7.3 Template'!J13","v":0},{"$f":"'7.3 Template'!K13","v":0},{"$f":"'7.3 Template'!M13","v":0},null,null,null,{"$f":"'7.3 Template'!R13","v":0},{"$f":"'7.3 Template'!S13","v":0},{"$f":"'7.3 Template'!U13","v":0}]
[null,{"$f":"'7.3 Template'!J14","v":0},{"$f":"'7.3 Template'!K14","v":0},{"$f":"'7.3 Template'!M14","v":0},null,null,null,{"$f":"'7.3 Template'!R14","v":0},{"$f":"'7.3 Template'!S14","v":0},{"$f":"'7.3 Template'!U14","v":0}]
[null,{"$f":"'7.3 Template'!J15","v":0},{"$f":"'7.3 Template'!K15","v":0},{"$f":"'7.3 Template'!M15","v":0},null,null,null,{"$f":"'7.3 Template'!R15","v":0},{"$f":"'7.3 Template'!S15","v":0},{"$f":"'7.3 Template'!U15","v":0}]
[null,{"$f":"'7.3 Template'!J16","v":0}]
[null,null,{"$f":"'7.3 Template'!J7","v":0},{"$f":"'7.3 Template'!K7","v":0},null,null,null,{"$f":"'7.3 Template'!R7","v":0},{"$f":"'7.3 Template'!S7","v":0}]