Forum Discussion
Solved
Design optimization using discrete decision variables
Hi! I have a linear equation system that is based on a couple of input variables (x,y,z,w). The variables can only have certain values, e.g. x=[1 2 3 ... 50], y=[0.1 0.2 ... 20], z=[5 10 15 ......
Solver can constrain input variable to be whole numbers. You could use formulas to convert for example input 1, 2, ..., 50 to 0.1, 0.2, 50.0
Solver will use B2 to B5 as variables, but your target formula should refer to C2 to C5.
In the screenshot, F2:G5 is a lookup table for C5; the formula in C5 is =VLOOKUP(B5,F1:G5,2,FALSE)
Solver can constrain input variable to be whole numbers. You could use formulas to convert for example input 1, 2, ..., 50 to 0.1, 0.2, 50.0
Solver will use B2 to B5 as variables, but your target formula should refer to C2 to C5.
In the screenshot, F2:G5 is a lookup table for C5; the formula in C5 is =VLOOKUP(B5,F1:G5,2,FALSE)
- I really like the idea about using a lookup table for this problem. I will try this out!
Thank you very much!
