Hello everyone,
I have a problem with Solver.I need for my research that the variables assume a specific range of value.In this case only these values:
0.1,0.2,0.3,0.4
How can i do that?
Thank you
Hello everyone,
I have a problem with Solver.I need for my research that the variables assume a specific range of value.In this case only these values:
0.1,0.2,0.3,0.4
How can i do that?
Thank you
If four of you variables shall have specific values and the sum of these are 1.0 then your last variable mus be 0 if the result should be 1???
So why do you need solver???
Alf
Alf,thank you
you are right
here is the correct spreadsheet
You could do it like this:
D E F 3 Solver Pesi 4 2 0.2E4: =D4/10 5 1 0.1 6 1 0.1 7 2 0.2 8 4 0.4 9 1E9: =SUM(E4:E8)
Maximize B30 by changing D4:D8, constrained as integers >=1, <=4, D8 constrained to =1.
Last edited by shg; 11-06-2017 at 02:20 PM.
Entia non sunt multiplicanda sine necessitate
Great idea,shg
Thanks a lot!
shg,
for a wider solution i solved like this.
Could you have a look?
Thank you
Not knowing what you're trying to do, it looks fine.
BTW, you can set those constraints en masse, e.g.,
F4:F7 >= 0
F4:F7 <= 10
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks