The Excel solver was déveoppé by Frontline Solvers "which, on its website http://www.solver.com/ do not hesitate to also tell you that he can sell you better live!
The Excel solver is limited to 200 variables, other solvers - whether add-ins for Excel or not - can go up to thousands of variables. Another limitation of the Excel Solver, Frontline forget that just happened to clarify, is far more serious: the solver of Excel is really reliable for linear models Continuing (linear programming).
Certainly, the solver of Excel gives you the right to specify that a particular variable is full or Boolean. Certainly, it allows you to define models with nonlinear constraints, with formulas containing such functions if () or max (), variables squared,
... But in solving problems containing such variables or such formulas, we have observed (and the list is not exhaustive) the following phenomena:
● solver says that one solution is optimal when it is not
● solver says there is no feasible solution then there are
● solver found or not found the optimal solution according to the order constraints
The result of my experiences is this: the Excel Solver is reliable, I repeat, that for continuous linear models .
To conclude this series on the solver where we started, here's a riddle that you can play to resolve. If anyone knows about this riddle (Found in English on the Internet at multiple locations), I will be happy to do him honor.
In 10 years, Tim will be twice as old as Jane was when Mary was nine times the age of Tim. 8 years ago, Mary was half as old as Jane will be when it will be a year older than the age that Tim will be when Mary will be 5 times as old as Tim in 2 years. When Tim was 1 year old, Mary was 3 years older than Tim did when Jane will be 3 times as old as Mary was six years before the year in which Jane was half as old as Tim will be when Mary will be 10 years older than she was when Jane was the third age Tim will be when Mary will be 3 times the age she was when Jane was born. What are their ages now?
0 comments:
Post a Comment