optimization

Hi all Is it possible to solve multi-dimensional constrained optimization problems with excel? Constrained problems can easily be solved with matlab (f.e. fmincon) or R (f.e. optim). With the optimization function fmincon() of matlab for example, you can formulate linear equality and...

I've adjusted many settings in my workbook, but I can't remember exactly what I've changed. Is there any way to recover the workbook's default settings? My workbook has become more slow when I use it, but I can't see any big changes. Is it possible that some cells are 'in use' even though I...

Hello, I am wondering if there is a way to have excel run iterations to find out when one cell would be equal to another. As an example: Say I have an INPUT of 5% which generates an output of $10 I have another INPUT of 7% which generates an output of $20 I know these two eventually...

Hi there, I'm working on a rather large optimization program. I really should be using Matlab, but my company doesn't have it, so here I am. Anywho, I'm working to optimize pump cost efficiency. I have about 30 different pump combinations, with 15 drag reducer concentrations at one pumping...