On 12-03-2013, at 08:45, Pavel_K wrote:
> Dear Mr Hasselman,
> for a better understanding I have attached an example solved in excel by
> using the tool Solver.
>
> I want to assign for each municipality one of the centres and apply it for
> calculating the minimum cost as you can see in an exa
Pavel_K 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
Dear Mr Hasselman,
for a better understanding I have attached an example solved in excel by
using the tool Solver.
I want to assign for each municipality one of the centres and apply it for
calculating the minimum cost as you can see in an example.
I used package lpsolve, but it does not work. I a
On 11-03-2013, at 23:31, Pavel_K 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 rows re
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 and 6 columns represent the
centres. It co
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
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-Sol
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 un
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 un
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
values via Monte-Carlo simulation, however it only works
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-tp4646759
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.
> http://cran.r-project.org/web/packa
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.
http://cran.r-project.org/web/packages/limSolve/index.html
I guess, the lsei-function of thi
I do not know what algorithms the Excel solver function uses.
See inline for how to do what you want in R.
Forgive me if I have misinterpreted your request.
On 19-10-2012, at 16:25, Richard James wrote:
> Dear Colleagues,
> I am attempting to develop an optimization routine for a river suspende
14 matches
Mail list logo
