Opensolver for google docs is not using constraints. I’m trying to do a simple optimization, but I can’t get it to actually use the constraints. I’m trying to use variable > 0.0001 and < 0.9999 yet it keeps setting the variable to 0. Any idea why this might be happening?
Welcome to the world of practical numerical values. Any solver has to define “effectively 0”; a value of 0.0001 can often be classed as 0. It is bad practice to specify bounds that are effectively 0 or 1, as this causes numerical instability. Furthermore, no value for a decision variable can ever get a divide by zero error in a linear model; I suspect your model is not linear, in which case we OpenSolver for Google Sheets cannot solve it. Andrew
Opensolver for google docs is not using constraints. Trying to solve a simple probability linear optimization (user churn), but it keeps setting the p variable to 0, when I set constraints to specifically be between 0.0001 and 0.9999. I keep getting an error ” divide by 0″ and it sets p to 0. Even if I change to add a constraint p = 10 (thus no variable), it still sets p to 0. Why might this be happening?
Opensolver for google docs is not using constraints. I’m trying to do a simple optimization, but I can’t get it to actually use the constraints. I’m trying to use variable > 0.0001 and < 0.9999 yet it keeps setting the variable to 0. Any idea why this might be happening?
Welcome to the world of practical numerical values. Any solver has to define “effectively 0”; a value of 0.0001 can often be classed as 0. It is bad practice to specify bounds that are effectively 0 or 1, as this causes numerical instability. Furthermore, no value for a decision variable can ever get a divide by zero error in a linear model; I suspect your model is not linear, in which case we OpenSolver for Google Sheets cannot solve it. Andrew
Opensolver for google docs is not using constraints. Trying to solve a simple probability linear optimization (user churn), but it keeps setting the p variable to 0, when I set constraints to specifically be between 0.0001 and 0.9999. I keep getting an error ” divide by 0″ and it sets p to 0. Even if I change to add a constraint p = 10 (thus no variable), it still sets p to 0. Why might this be happening?