Re: [R] Optimization in R similar to MS Excel Solver

2013-03-12 Thread Berend Hasselman
On 11-03-2013, at 23:31, Pavel_K kuk...@vsb.cz wrote: Dear all, I am trying to find the solution for the optimization problem focused on the finding minimum cost. I used the solution proposed by excel solver, but there is a restriction in the number of variables. My data consists of 300

Re: [R] Optimization in R similar to MS Excel Solver

2013-03-12 Thread Pavel_K
.n4.nabble.com/Optimization-in-R-similar-to-MS-Excel-Solver-tp4660997p4661019.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide

Re: [R] Optimization in R similar to MS Excel Solver

2013-03-12 Thread Hans W Borchers
Pavel_K kuk064 at vsb.cz writes: Dear all, I am trying to find the solution for the optimization problem focused on the finding minimum cost. I used the solution proposed by excel solver, but there is a restriction in the number of variables. My data consists of 300 rows represent cities

Re: [R] Optimization in R similar to MS Excel Solver

2013-03-12 Thread Berend Hasselman
to this list). Berend Thank you Pavel example.xls http://r.789695.n4.nabble.com/file/n4661019/example.xls -- View this message in context: http://r.789695.n4.nabble.com/Optimization-in-R-similar-to-MS-Excel-Solver-tp4660997p4661019.html Sent from the R help mailing list archive

[R] Optimization in R similar to MS Excel Solver

2013-03-11 Thread Pavel_K
confused here about how can I treat with the variables firms. Thanks Pavel -- View this message in context: http://r.789695.n4.nabble.com/Optimization-in-R-similar-to-MS-Excel-Solver-tp4660997.html Sent from the R help mailing list archive at Nabble.com

Re: [R] Optimization in R similar to MS Excel Solver

2012-10-27 Thread Berend Hasselman
On 26-10-2012, at 21:41, Richard James wrote: That solution works very well. The only issue is that 'rnorm' occasionally generates negative values which aren't logical in this situation. Try another random generator. Lognormal, uniform, ... Is there a way to set a lower limit of

Re: [R] Optimization in R similar to MS Excel Solver

2012-10-26 Thread Richard James
this message in context: http://r.789695.n4.nabble.com/Optimization-in-R-similar-to-MS-Excel-Solver-tp4646759p4647524.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo

Re: [R] Optimization in R similar to MS Excel Solver

2012-10-26 Thread Berend Hasselman
On 26-10-2012, at 12:50, Richard James wrote: Dear Berend and Thomas, thank you for suggesting the lsei function. I found that the tlsce {BCE} function also works very well: library(BCE) tlsce(A=bmat,B=target) The limSolve package has an 'xsample' function for generating uncertainty

Re: [R] Optimization in R similar to MS Excel Solver

2012-10-26 Thread Berend Hasselman
On 26-10-2012, at 12:50, Richard James wrote: Dear Berend and Thomas, thank you for suggesting the lsei function. I found that the tlsce {BCE} function also works very well: library(BCE) tlsce(A=bmat,B=target) The limSolve package has an 'xsample' function for generating uncertainty

Re: [R] Optimization in R similar to MS Excel Solver

2012-10-26 Thread Richard James
That solution works very well. The only issue is that 'rnorm' occasionally generates negative values which aren't logical in this situation. Is there a way to set a lower limit of zero? -- View this message in context: http://r.789695.n4.nabble.com/Optimization-in-R-similar-to-MS-Excel

Re: [R] Optimization in R similar to MS Excel Solver

2012-10-21 Thread Thomas Schu
Thomas -- View this message in context: http://r.789695.n4.nabble.com/Optimization-in-R-similar-to-MS-Excel-Solver-tp4646759p4646911.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https://stat.ethz.ch

Re: [R] Optimization in R similar to MS Excel Solver

2012-10-21 Thread Berend Hasselman
On 21-10-2012, at 13:37, Thomas Schu wrote: Dear Richard, It is funny. I have to perform the approach of sediment fingerprinting for my master thesis. Mr. Hasselman gave me the advice to take a closer look into the limSolve package a few days ago.

Re: [R] Optimization in R similar to MS Excel Solver

2012-10-21 Thread Richard James
Dear Berend, Many thanks for taking your time to assist with this optimization problem. I'll work on data this week and let you know how I get on. Again, many thanks Richard -- View this message in context: http://r.789695.n4.nabble.com/Optimization-in-R-similar-to-MS-Excel-Solver

Re: [R] Optimization in R similar to MS Excel Solver

2012-10-20 Thread Berend Hasselman
appreciated. -- View this message in context: http://r.789695.n4.nabble.com/Optimization-in-R-similar-to-MS-Excel-Solver-tp4646759.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org mailing list https