solver iteration

Hello my fellow Excellers! I have a practical issue which appears simple at first but reveals itself being tricky (at least for me) , the problem is the following : In my Solver Model there are several variables which can range from let's say 1000 to 100000+ and are sold by multiples of 100s...

Hi. My problem is suppose I have 5 hours and hence 5 variables and i want that variables to lie between 0 to 500 with the constraint that next variable should lie between X(previous)-60<X(new)<X(previous)+180. First variable can be any. Apart from this each variable can either be 0 or 50% i.e...

I need to use the solver code for 100 rows. In the optimization process the target cell, the changing cells and the two cells included in the constraints change its value for each iteration. Below I present a possible code, but the software says me that there is some mistakes. How Can I solve...

An outline of my code is as follows; 1. Copy single column of data from raw data sheets, of which there are 5 in a separate workbook, to the curve fitting sheet (different workbook). 2. Run solver on these data to minimize the sum of the squares. 3. Copy the output to the i'th row of column...

Hi People, I am a novice in VBA macros. However, I have read through various posts about VBA Macros and I found some of them very useful. I have a script that invokes a solver but would like it to iterate, say 100 times copying the result of each iteration (i.e., the change cell values and...