Re: [R] need advice on using excel to check data for import into R

2012-04-24 Thread Michael Bibo
Markus Weisner themarkus.com> writes: > My question is whether anybody can think of clever alternatives for clients > to validate their data … for example, is their a R excel plugin (that would > be easily installed by a client) where I might be able write some lines of > R to check the data and

Re: [R] need advice on using excel to check data for import into R

2012-04-23 Thread Greg Snow
This is really a job for a database, and Excel is not a database (even though many think it is). I have some clients that I have convinced to create an Access database rather than use Excel (still MS product so it can't be that scary, right?). They were often a little reluctant at first because t

Re: [R] need advice on using excel to check data for import into R

2012-04-22 Thread Markus Weisner
If I go to wiki -> "how to install" it looks like a rather complicated installation that involves installing R followed by several command line prompts. It looks like it might be too much of an installation process to make sense for a client to conduct a one-time data check. Looks like a great to

Re: [R] need advice on using excel to check data for import into R

2012-04-22 Thread Richard M. Heiberger
This looks like a perfect case for an RExcel solution. RExcel is an addin that allows you, among other things, to place an arbitrary R function inside the Excel automatic recalculation mode. For details see rcom.univie.ac.at There are many references item listed on the wiki page in the left panel.