Markus Weisner r at 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
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
I have created an S4 object type for conducting fire department data
analysis. The object includes validity check that ensures certain fields
are present and that duplicate records don't exist for certain combinations
of columns (e.g. no duplicate incident number / incident data / unit ID
ensures
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
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 tool
5 matches
Mail list logo
