similar to: Excel Solver Add-In / Alternatives

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",