Hi Paul, I find your question intriguing, but might I ask that you elaborate on your terminology and context of "lock out" and "hidden" in your question? Otherwise I am afraid that my current ideas on an answer will surely be based on the wrong diagnosis of what you are really looking for.
Thanks, Bill ------------------------------- Bill Pikounis, PhD Nonclinical Statistics Centocor, Inc. 200 Great Valley Parkway MailStop C4-1 Malvern, PA 19355 610 240 8498 fax 610 651 6717 > -----Original Message----- > From: Paul Sorenson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 19, 2005 5:19 PM > To: r-help@stat.math.ethz.ch > Subject: [R] easing out of Excel > > > I know enough about R to be dangerous and our marketing > people have asked me to "automate" some reporting. Data > comes from an SQL source and graphs and various summaries are > currently created manually in Excel. The raw information is > invoicing records and the reporting is basically summaries by > customer, region, product line etc. > > With function such as aggregate(), hist() and pareto() (which > someone on this list kindly pointed me at) I can produce > something roughly equivalent to the current reports. > > My question is, are there any neat R "lock out" features > people here like to use on this kind of info, particularly > when the output is very visual (report is intended for > marketing people). > > Another way of looking at this is, What kind of "hidden" > information can I extract with R that the Excel solution > hasn't touched? > > For example, even the pareto plot mentioned earlier is > something the Excel guys haven't thought of or can't easily produce. > > regards > > BTW the tool chain I am using goes something like: > Production (run daily): > DB -> SQL/python -> CSV -> R/python -> images -> network > Presentation: > network -> CGI/python -> browser > > ______________________________________________ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html > [[alternative HTML version deleted]] ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
