Thank you so much for working through this with me. I was having so much difficulties and this made it easy to follow, step by step, and understand how to input all values :) BIG THUMBS UP!
I have a constraint that only uses 2 out of the 4 variables. When I add this constraint to the solver I get an error message that states cell reference box is empty or contents are not valid.
you need to simplify it first so all variable are at the left hand side and all constants at the right hand side. In your case: X1 + x2 >= 0.6(X1 + X2 +X3 + X4 +X5) X1 - 0.6X1 + X2 - 0.6X2 - 0.6X3 -0.6X4 >=0 0.4X1 + 0.4X2 - 0.6X3 -0.6X4 >=0 I even multiply them by 10 4X1 + 4X2 - 6X3 - 6X4 >=0 and multiply them by 1/2 2X1 + 2X2 - 3X3 - 3X4 >=0 and that is what I will use.
In the title it is mentioned as linear programming but while getting the answer by using solver there you have not used simplex algorithm. And these values are not integer solutions.
Thank you so much for working through this with me. I was having so much difficulties and this made it easy to follow, step by step, and understand how to input all values :) BIG THUMBS UP!
Thank you, this was very helpful
how to solve if multiple objective cells are coming
Can u post this problem excel file
Really enjoyed the video. Straight to the point. The only thing I would recommend is not using the magnifying bubble around the cursor.
Saved my life. Thanks a lot.
why do yo make it so complicated? Can you just do a simple one without matrices?
Is there anyway to solve problems on goal programming using excel?
I have a constraint that only uses 2 out of the 4 variables. When I add this constraint to the solver I get an error message that states cell reference box is empty or contents are not valid.
there should not be any problem unless your A matrix is not full rank... let me see what the problem is ... please post it here in the comments
Good video, thank you, Dr. Salimian
Thank you somuch!!! You have the best way to do this online!
how would you put a constraint such as "X1 + x2 >= 0.6(X1 + X2 +X3 + X4 +X5)" in this model? would i put all variables on one side?
you need to simplify it first so all variable are at the left hand side and all constants at the right hand side. In your case:
X1 + x2 >= 0.6(X1 + X2 +X3 + X4 +X5)
X1 - 0.6X1 + X2 - 0.6X2 - 0.6X3 -0.6X4 >=0
0.4X1 + 0.4X2 - 0.6X3 -0.6X4 >=0
I even multiply them by 10
4X1 + 4X2 - 6X3 - 6X4 >=0
and multiply them by 1/2
2X1 + 2X2 - 3X3 - 3X4 >=0
and that is what I will use.
DrSalimian thanks so much!
Very good explanation. Your voice is soothing and it was easy for me to follow.
thnq sooooo much sir
In the title it is mentioned as linear programming but while getting the answer by using solver there you have not used simplex algorithm. And these values are not integer solutions.
Thanks to you Dr.
Thanks a lot!!
Great explanation!