Hi!
I want to use piecewise linearization on quadratic equation on my linear programming. I have Wij as a decision variable and would like to incorporated it to 1/(Wij)^2 as a dependent variable. I know I can use a certain range to make the quadratic equation linear, but I am not sure on how to do that in Excel.
I attached my work below, the specified problem located in sheet "correct".
Thank you in advance!
Bookmarks