D
David
With Excel 97 SR-2 I'm using Solver to find roots of a 4th
order polynomial. It seems to work well as the function is
well behaved and I'm able to set up constraints to find
each root. Problem is I have lots of variations (i.e.
different sets of coefficients) for which I want to do the
same type of evaluation. Solver seems to simply produce an
answer and then through a dialog give me the option of
entering the answer in the cell. I'd like to copy the
solver setup from one cell to many others just as is done
with "functions". Is there a way to do this? I see
something about saving scenarios, but haven't figured out
how this helps me.
I will have a column that represents one equation and the
cells going down the column will be used to calculate the
equation coefficients. The bottom cell(s) will be the
solver supplied solution(s). I'd like to copy the bottom
part of the column to the next columns to do the same
calculations on data for each column included running
solver with constraints set up exactly the same with
respect to the rows of each column. Solver seems to always
use absolute cell references, so even if I could copy
the "solver function", it would be making the evaluation
for the original column and not each new column. Solver
just doesn't seem to work in a way that is consistent with
the rest of Excel. Maybe I'm not seeing something obvious.
An option may be to record a macro of the setup for Solver
and then modify it to work across multiple columns, but
this is an inefficient solution for those of us who aren't
Excel gurus. Please advise.
Thanks,
David
order polynomial. It seems to work well as the function is
well behaved and I'm able to set up constraints to find
each root. Problem is I have lots of variations (i.e.
different sets of coefficients) for which I want to do the
same type of evaluation. Solver seems to simply produce an
answer and then through a dialog give me the option of
entering the answer in the cell. I'd like to copy the
solver setup from one cell to many others just as is done
with "functions". Is there a way to do this? I see
something about saving scenarios, but haven't figured out
how this helps me.
I will have a column that represents one equation and the
cells going down the column will be used to calculate the
equation coefficients. The bottom cell(s) will be the
solver supplied solution(s). I'd like to copy the bottom
part of the column to the next columns to do the same
calculations on data for each column included running
solver with constraints set up exactly the same with
respect to the rows of each column. Solver seems to always
use absolute cell references, so even if I could copy
the "solver function", it would be making the evaluation
for the original column and not each new column. Solver
just doesn't seem to work in a way that is consistent with
the rest of Excel. Maybe I'm not seeing something obvious.
An option may be to record a macro of the setup for Solver
and then modify it to work across multiple columns, but
this is an inefficient solution for those of us who aren't
Excel gurus. Please advise.
Thanks,
David