Forum Discussion
problem with solver in excel
I have 200 columns and it's total in last column. I want to change my total so it will automatically changes the value with its ratio. Example Columns Value A 10 B 20 C 3 D 0...
Thanks for reply. I know this solution but I am searching like goal seek or solver solution.
It is possible to set up an optimisation problem with the solution you desire but the result is trivial.
The setup would require a set of parameters p that would be the base values you wish to scale for a solution. The optimisation variables x could be set with an initial value 1, as would the further variable s which is used to scale the solution.
The objective function could be
= SUM( (x - p*s)^2 )
and the total
= SUM(x)
would be constrained to equal the target value set.
The non-linear solver gives the trivially obvious solution.
