[R] I need help integrating ggplot2 into Excel

[Jannik Vindeloev]

Dear all

I use ggplot2 extensively for my plotting routines and rexcel  to have the
best of two worlds. (RExcel v 1.75 and R (D)Com v. 2.5)

I can run my ggplot functions, such as qplot(...), in scratchpad mode, but
not in Macro nor Worksheet functions mode.

I have tried the following in Macro mode:

Call RInterface.RRun("library(ggplot2)")
...
Call
RInterface.RRun("qplot(x=Hours,y=pH,data=ds,facets=Sample~.,geom=""line"",group=Cell)")

With no output ...

I have tried the following in Worksheet function mode:

if Range(H40:I42) contains:
"
(Embedded image moved to file: pic10654.jpg)
"
and Range(H48) contains:

"qplot"

The following call:

=Rcalla(H48;makeargs(H40:I42))

Gives me no output

Scratchpad mode

However, right clicking a cell containing:
qplot(x=Hours,y=pH,data=ds,facets=Sample~.,geom=""line"",group=Cell)
and then selecting "Run R" works like a dream!

I would like to develop an excel based GUI for R-data treatment and
plotting, and I would like to use ggplot2 as my plotting engine.

What am I doing wrong?

Thank you for your help

Jannik Vindeløv, Ph.D.
Project Manager
Dairy Culture Development
Innovation

P.O. Box 64
Arpajon
Cedex
F-91292
France

Phone: +33 (0)1 6988 3636
Direct Phone: +33 (0)1 6988 3629__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] How to estimate the parameters of differential equations from data

[Jannik Vindeloev]

Hello list

I have a theoretical differential equation model (two coupled differential
equations) describing the acidification of dairy cultures in milk:

dX/dt = f(H, param)*X
dH/dt = g(param)*dX/dt

pH = -log10(H)

I also have actual data of the same.

I would like to estimate the parameters of the theoretical model from real
data, but don't know how to go about it in R (I'm fairly new to R). Is
there an R-package for this purpose?

Any help from the list is highly appreciated.

Thank you

Jannik Vindeløv, Ph.D.
Project Manager
Dairy Culture Development
Innovation

P.O. Box 64
Arpajon
Cedex
F-91292
France

Phone: +33 (0)1 6988 3636
Direct Phone: +33 (0)1 6988 3629
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.