mentby.com
Blog | Jobs | Help | Signup | Login

Hi, R users

We can create a form using R?
I would like to create a form where the information can be read by R.
Itneeds to be updated daily because I have to tabulate the reasons for
delays
in the generation of numerical models products.

I really appreciate any help,

Thanks in advance,
Nilza Barros

    [[alternative HTML version deleted]]


Nilza BARROS Fri, 12 Mar 2010 08:38:33 -0800

It would be a form that is filled daily, but some fields were tabulated and
other fields would be filled with only the opinions of users.

Currently, my form is a Word document that is the filling and printed. At
the end of every month they are analyzed and the reasons for delays are
tabulated and the graphs created. I wish the print was not necessary.
Furthermore,
the reasons would be tabulated automatically.
Please let me know if I were clear.
Thanks for you attention
Nilza Barros

--
Abraço,
Nilza Barros

    [[alternative HTML version deleted]]


Nilza BARROS Fri, 12 Mar 2010 11:07:46 -0800

Sounds like a job for sweave or perhaps one of the packages brew or
odfWeave. See also the xtable package, perhaps. You would then be able to:

-- read the latest data file
-- have R produce all tabular summaries, analyses, plots
-- output all the results in a nicely formatted template (report)

with a single push of a button.

Bert Gunter
Genentech Nonclinical Biostatistics


Bert Gunter Fri, 12 Mar 2010 11:22:05 -0800

Do you want to build a graphical user interface? With fields to fill
in, and choices and buttons to press?

You should first look at the tcltk package that you should find with
R. That lets you build interfaces using the Tk toolkit.

There are also ways of using the Gtk and Qt toolkits from R, but that
is getting a bit complex and harder to make work on Windows and Linux.
I guess you're talking Windows because you mention 'Word document'.

So do library(tcltk) and then read the documentation.

Barry


Barry Rowlingson Fri, 12 Mar 2010 13:21:47 -0800

You also could use the Excel addin RExcel (from rcom.univie.ac.at).
You could use Excel forms to collect you data and the
transfer mechanisms of RExcel to put your data into R.

The web site has a video demonstrating how to yuse RExcel.

--
Erich Neuwirth, University of Vienna
Faculty of Computer Science
Computer Supported Didactics Working Group
Visit our SunSITE at  http://sunsite.univie.ac.at
Phone: +43-1-4277-39464 Fax: +43-1-4277-39459


Erich Neuwirth Sat, 13 Mar 2010 05:09:40 -0800

Hi Nilza,

I think your solution should be to create a google spreadsheet and then read
it.

Here is an example code for reading a google spreadsheet:

supplements.data.0 <-
read.csv(" http://spreadsheets.google.com/pub?key=0Aqe2P9sYhZ2ndFRKaU1F[..] )

I used this trick here: http://www.r-statistics.com/2010/02/nutritional-supplements-[..]
And I found out about it from here: http://blog.revolution-computing.com/2009/09/how-to-use-a-go[..]

You will need to know how to create a google form that will feed a google
spreadsheet:
Here is a simple video tutorial:
&feature=related>
(This video explains your situation very well :) )

Good luck.

Tal

----------------Contact
Details:-------------------------------------------------------
Contact me: Tal.Galili*******|  972-52-7275845
Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
www.r-statistics.com (English)
----------------------------------------------------------------------------------------------

    [[alternative HTML version deleted]]


Tal Galili Sat, 13 Mar 2010 08:55:52 -0800

Hi Nilza,
Google spreadsheets + google forms + R = Easily collecting and importing
data for analysis< http://www.r-statistics.com/2010/03/google-spreadsheets-goog[..] >

I copy it here:

First view the following video (2:50 min) which explains what google
spreadsheets are


Then view the next video (2 min), which explains what using google forms
with google spreadsheet is all about


The next step for you is to access the spreadsheet without having to make it
public is to go thorough this
tutorial< http://www.omegahat.org/RGoogleDocs/run.pdf> > on
how to use the R package RGoogleDocs < http://www.omegahat.org/RGoogleDocs/>.

If you feel comfortable to publish the google spreadsheet, there is a
simpler tutorial for you
here< http://blog.revolution-computing.com/2009/09/how-to-use-a-go[..]
And you could see examples of using this method here
< http://chartsgraphs.wordpress.com/2009/09/11/co2-emissions-c[..] >
and here< http://www.r-statistics.com/2010/02/nutritional-supplements-[..] >
.

I hope this helps.

Tal

----------------Contact
Details:-------------------------------------------------------
Contact me: Tal.Galili*******|  972-52-7275845
Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
www.r-statistics.com (English)
----------------------------------------------------------------------------------------------

    [[alternative HTML version deleted]]


Tal Galili Sat, 13 Mar 2010 10:20:52 -0800

I really appreciate the advices and suggestions.
But Gail`s information about google docs  it`s exactly what I need.
It`s amazing.
Thank you very much indeed.

Nilza Baroros

--
Abraço,
Nilza Barros

    [[alternative HTML version deleted]]


Nilza BARROS Mon, 15 Mar 2010 18:21:49 -0700



Related Topics

Post a Comment