Solver

[John Kurby]

Does anybody know how to run solver on more than one entry!

I have 400 rows, and i'm trying to solve the same equation, with the same
contraints, but my input data for the equation is changing.

If anybody has any thoughts, please let me know.

 

[Bernard V Liengme]

Hi John,
Depending on the problem, this might work:
Let's say the targets cells are in K2:K22
Make a formula =SUMSQ(K2:K22)
Have Solver minimize this by changing the appropriate cells
Could take a few seconds
I have used this with 400 equations.
Bernard
www.stfx.ca/people/bliengme

 

[John Kurby]

Thanks Bernard

It works great, although cant use it on to many rows at once, but I broke it
up to 50 rows, it works great!

John