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 though. Is there a simpler way of deploying Rexcel that I am not seeing? Thanks, Markus On Sun, Apr 22, 2012 at 3:43 PM, Richard M. Heiberger <r...@temple.edu>wrote: > 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. > For further followup, please sign up for the rcom mailing list, again with > the > details on the web site. > > Rich > > On Sun, Apr 22, 2012 at 2:34 PM, Markus Weisner <r...@themarkus.com> wrote: > >> 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 that the data does not show the same fire engine responding twice >> on the same call). >> >> I am finding that I spend a lot of time taking client data, converting it >> to my S4 object, and then sending it back to the client to correct data >> validity issues. >> >> I am trying to figure out a clever way to have excel (typically the >> program >> used by my clients) check client data prior to them submitting it to me. >> I >> have been working with somebody on trying to develop an excel toolbar >> add-in with limited success. >> >> 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 output messages or maybe some sort of server >> where they could upload their data and I could have some lines of R code >> that would check the code and send back potential error messages? >> >> I realize this is a fairly open ended question just looking for some >> general ideas and directions to go. Getting a little frustrated with >> spending most of my work time dealing with data cleaning issues guessing >> this is a problem shared by many of us that use R! >> >> Thanks, >> Markus >> >> [[alternative HTML version deleted]] >> >> >> ______________________________________________ >> 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<http://www.r-project.org/posting-guide.html> >> and provide commented, minimal, self-contained, reproducible code. >> >> > [[alternative HTML version deleted]]
______________________________________________ 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.
