Skip to main content
Post Made Community Wiki by whuber
Source Link
Greg Snow
  • 52.9k
  • 2
  • 112
  • 190

The R statistical program along with the qcc package fits your specified needs (and it is hard to beat the price):

  • There are several packages for interfacing with databases, RODBC being a common and useful one on MS windows.
  • You can leave it on as long as you want, you can program a regular event loop to check for new data and run a new set of charts and notifications if there is new data.
  • The mail and sendmailR packages were designed to automatically send e-mails.
  • It produces the standard SPC charts, these can go to the screen or a file to be sent out.
  • You can program your own tests for out of control signals
  • Full programming language with common (and uncommon) statistics so you can proproccess you data in many ways to reduce dimension.
  • You can have multiple instances running on multiple or a single computer, each processing for a single department, or you can combine it all into one script to run for all the departments.