Displaying 20 results from an estimated 3000 matches similar to: "Excel Solver Add-In / Alternatives"
2012 Oct 26
2
Interpreting and visualising lme results
Dear R users,
I have used the following function (in blue) aiming to find the linear regression between MOE and XLA and nesting my data by Species. I have obtained the following results (in green).
model4<-lme(MOE~XLA, random = ~ XLA|Species, method="ML")summary(model4)
Linear mixed-effects model fit by maximum likelihood Data: NULL AIC BIC logLik -1.040187 8.78533
2008 Oct 04
1
back-solver: any R thing like TK!Solver?
Just thought I'd ask. For those who've never seen TK!Solver, I strongly
recommend taking a look. So far as I can tell, it's the only product of
its type available, retail or open source, for any platform.
What makes TK!Solver so cool is that it adaptively back-solves pretty
much any unknown from any set of equations you give it. (or vector full
of unknowns, producing a vector of
2007 Dec 13
1
[LLVMdev] Puzzle solver on LLVM 2.1
Dear guys,
I've put the puzzle solver running on LLVM 2.1. Well, at least
partially, for it is failing three of SPEC2000 benchmarks. I will try to
debug it now. The results are not as good as before. I mean, the puzzle
solver is still the same, but the default allocator is producing very good
code now. Even though, the puzzle solver produces faster code for half the
benchmarks. It
2012 Jul 18
1
Defining a variable outside of optim or differential equation solver.
This is applicable to either using optim or the differential equation
solver or any similar solver
Suppose I want to use the differential equation solver and this is my code
d<-y[2]
vdpol<-function(t,y)
{
list(c(1,
d,
3,
4
)
}
stiff<-ode(y=rep(0,4),times=c(0,1),func=dvdpol,parms=1)
The thing is I want d to be composed of one of state variables in the
2011 Nov 07
2
How to do a target value search analogous to Excel Solver
Hi all,
i'm trying to find a solver possibility analogous to the Excel Solver in R.
Since i just started with R, I have only little knowledge. Can someone help
me by solving the problem?
I have the following 'starting position':
z = rnorm(1,0,1)
y <- function(x,z){2*x - 1 + z}
I am looking for a certain "x" in such a way that the result of the function
'y'
2013 Feb 20
2
'gmm' package: How to pass controls to a numerical solver used in the gmm() function?
Hello --
The question I have is about the gmm() function from the 'gmm' package
(v. 1.4-5).
The manual accompanying the package says that the gmm() function is
programmed to use either of four numerical solvers -- optim, optimize,
constrOptim, or nlminb -- for the minimization of the GMM objective
function.
I wonder whether there is a way to pass controls to a solver used
while calling
2009 Feb 08
3
general inverse solver?
Just wondering if there's an R package which does tricks similar to what
TK!Solver does.
TK!Solver, for those not lucky enough to have found it, basically allows
one to define a bunch of equations, assign values to an arbitrary subset
of the variables, from which it calculates (either directly when
possible or back-solving when not) the values of the other variable(s).
thanks
Carl
2012 Jan 08
2
R package equivalent to Excel SOLVER - Paquete R equivalente a SOLVER de Excel
Esteemed colleagues
I wonder if there is a package in R that performs the functions of the
Excel SOLVER.
Thanks in advance for the reply.
Best regards,
-------------------------
Estimados colegas
Me pregunto si hay un paquete en R que funcione como el SOLVER de Excel.
De antemano gracias por la respuesta.
Saludos,
--
Ricardo Bandin Llanos
rbandin@udec.cl
[c] Magíster Cs. m. Pesquerías
2011 Apr 23
2
Loop and Solver with Black/Scholes-Formula
Hello,
for my diploma thesis I need to program a solver for Merton?s respectively
Black?s and Scholes? Option pricing formula, which should be achieved for
several dates.
What I want to do is to estimate the value of a firm?s assets "vA" (x[2]
denotes vA) and the option-implied volatility of firm?s assets "sigA" (x[1]
denotes sigA) by solving it simultaneous using the Black
2012 Oct 24
1
equation solver
Hi,
I'm Pina and I'm a student in geology. I'm working with spectral profile of
sand and I have to find the similarity between one spectral profile selected
by hyperspectral image anche one that I created to mix different percentage
of 4 mineral component. I have to find the best mix of percentage of this 4
mineral in order to have the best likeness with the spectral profile chose
by
2004 Jan 14
2
nonlinear regression and Excel solver
Hi all,
Earlier today I posted this question on s-news, so apologies to some for
the duplication.
> Please put aside your snobbery about Microsoft products for a moment.
>
> I am fitting population models to annual survey data for trout. For those of you familiar with ecological models, I am working in the Lefkovitch matrix framework; for those unfamiliar with that shorthand, the
2004 Sep 16
3
newbie needs help using R as solver
Greetings
I'm a total newbie in R and I'm trying to make a comparisson of Excel
and R in the fields of:
- optimisation modeling (using solver)
- decision trees
- simulation modeling
as described in Winston, Wayne L.: Practical Management Science.
for optimisation modeling in Excel I would normaly use solver. In R
however I can't seem to be able to find the solution. I've
2017 Dec 15
2
RFC: Exposing TargetTransformInfo factories from TargetMachine
Hi all,
I'd like to be able to use TargetTransformInfo to make architecture
specific code generation decisions from the XLA LLVM IR emitter[0].
However, we don't have a great way to do this today --
TargetTransformInfo is wrapped in a TargetIRAnalysis and getting the
TargetTransformInfo out of it requires something like:
FunctionAnalysisManager DummyFAM;
TTI = TIRA.run(F, DummyFAM);
2010 Sep 10
4
Solver in R
Hi all:
I'm looking for a package that similar to solver in MS. All I need is find a
r to satisfy R0=sum( r * Xt ), where t are from 1 to n and Xt are come from
another formula.
The most package I found were to max or min the obj. function. Is there any
package can do it?
Thanks.
Peter
[[alternative HTML version deleted]]
2013 Mar 11
3
Optimization in R similar to MS Excel Solver
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 constitutes a cost matrix, where the cost are distances between
each city and each of six centres.
..+
2009 Jul 08
2
i need same function solver in excel..
hi..
i used R a few days..
who can call me? same function solver in excel.
_________________________________________________________________
[[elided Hotmail spam]]
[[alternative HTML version deleted]]
2010 Sep 16
1
More accurate ODE solver?
Dear All,
I was using rk4 and lsoda to solve a ODE system. However, both of them gave
bad accurate solutions, especially compared with Matlab solver ODE45. For
example, ODE45 gave solutions that can go to a stable level (about 1.6) when
time goes to infinity, however, the solutions from lsoda are decreasing to
very very small (about 1e-130) numbers.
Does R have more accurate ODE solvers as
2013 May 02
2
ODE solver
I am trying to use the package ode and periodically it will come up with
this error message
Warning..Internal T (=R1) and H (=R2) are
such that in the machine, T + H = T on the next step
(H = step size). Solver will continue anyway.
And then the program just take very long to run. Is there anyway to get the
program to terminate when this warning is issued instead of continuing to
run ?
2011 Jul 29
1
Cplex solver and optimization in R
Dear all,
I want to work with R in an optimization problem and I was wondering if
there are any available solvers. I found RCplex package but downloading it,
I get problems. Why? Is it not free? are there any other solvers available?
many thanks!
--
View this message in context: http://r.789695.n4.nabble.com/Cplex-solver-and-optimization-in-R-tp3703385p3703385.html
Sent from the R help
2012 Jul 18
4
The best solver for non-smooth functions?
# Hi all,
# consider the following code (please, run it:
# it's fully working and requires just few minutes
# to finish):
require(CreditMetrics)
require(clusterGeneration)
install.packages("Rdonlp2", repos= c("http://R-Forge.R-project.org",
getOption("repos")))
install.packages("Rsolnp2", repos= c("http://R-Forge.R-project.org",