If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Solver Limits for Constraints and Adjustable Cells
What is Solver's limits for constraints and adjustable cells?
According to Microsoft Knowledge Base Article 75714 it is: 200 adjustable cells, and unlimited constraints for linear problems and 500 for non-linear problems for Excel 97, 98 and 2000. According to Frontline Systems, the developers of the Excel Solver, the limits are 200 adjustable cells, and 200 constraints for linear problems and 100 for non-linear problems. They do not refer to a specific version of Excel. There is a significant difference (in terms of the number of constraints) between the above two pieces of information. Can someone please clarify this matter for me? I will really appreciate it. Thanks Johan Zietsman |
#3
|
|||
|
|||
Solver Limits for Constraints and Adjustable Cells
Just to throw another set of numbers in - found buried in the help for Excel
2003:- When the Assume Linear Model check box on the Solver Options dialog box is selected, there is no limit on the number of constraints. For nonlinear problems, each adjustable cell can have up to 100 constraints, in addition to bounds and integer restrictions on the variables. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ---------------------------------------------------------------------------- Newsgroups - Where you really can get a free lunch!! ---------------------------------------------------------------------------- "Johan Zietsman" wrote in message ... What is Solver's limits for constraints and adjustable cells? According to Microsoft Knowledge Base Article 75714 it is: 200 adjustable cells, and unlimited constraints for linear problems and 500 for non-linear problems for Excel 97, 98 and 2000. According to Frontline Systems, the developers of the Excel Solver, the limits are 200 adjustable cells, and 200 constraints for linear problems and 100 for non-linear problems. They do not refer to a specific version of Excel. There is a significant difference (in terms of the number of constraints) between the above two pieces of information. Can someone please clarify this matter for me? I will really appreciate it. Thanks Johan Zietsman --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003 |
Thread Tools | |
Display Modes | |
|
|