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:Paul.Sorenson@vision-bio.com]
> 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]]


