Hi guys
I am having a problem in getting excel solver to solve a linear programming problem.
Suppose i have binary variables as follows:
0 1 1 0 1 0 1
I want to track the change between each variable. eg if there's a change of value from one variable to the next then i want to times it by 15 ie (x2-x1)*15.
The problem is i want a positive 15 not negative 15 in some cases.
I tried using absolute value function but it's not linear so i cant use solver with simplex method to solve it.
Note: I can only use solver simplex method to solve this.
The above problem is an extract of a bigger problem with more constraints in solver.
If you have any more questions feel free to ask.
Thanks![]()
Bookmarks