Number of columns - can they be increased?

[FrankO]

I am busy setting up a linear program (LP) on Excel 2000, but I have ru
out of columns on my worksheet. I have already used more than 1 90
rows for variables, but the standard 256 colums are inadequate for th
constraints!

How can I increase the number of columns on a worksheet?

If that is impossible, can one use multiple worksheets for a singl
solver application so that I can solve an LP with more than 25
variables or constraints?

Please help, this is urgent!

Fran

 

[Guest]

Frank,
I don't know about the solver issue, but I can tell you that 256 is the max number of columns.

Good Luck,
Mark Graesser
(e-mail address removed)

----- FrankO > wrote: -----

I am busy setting up a linear program (LP) on Excel 2000, but I have run
out of columns on my worksheet. I have already used more than 1 900
rows for variables, but the standard 256 colums are inadequate for the
constraints!

How can I increase the number of columns on a worksheet?

If that is impossible, can one use multiple worksheets for a single
solver application so that I can solve an LP with more than 256
variables or constraints?

Please help, this is urgent!

Frank

 

[FrankO]

Thanks Mark

I have now also realised that solver can handle only 200 adjustabl
cells, which is hopelessly inadequate for what I need to do with it.

If software exists that can increase the handling capabilities o
Excel, I would appreciate any advice in this regard.

Fran

 

[Michael Bednarek]

I am busy setting up a linear program (LP) on Excel 2000, but I have run
out of columns on my worksheet. I have already used more than 1 900
rows for variables, but the standard 256 colums are inadequate for the
constraints!

How can I increase the number of columns on a worksheet?

If that is impossible, can one use multiple worksheets for a single
solver application so that I can solve an LP with more than 256
variables or constraints?

Please help, this is urgent!

Excel is inadequate for this kind of thing. You need to get a
stand-alone Solver, e.g. from Frontline Systems, and write some code
in a language supported by that package. Expect a lot of pain.