1. Don Wheeler's book "Making Sense of Data - SPC for the Service Sector" describe how to place control limits on seasonal data with no trend as well as non-seasonal data with an up or down trend. In my work I frequently see data that exhibits strong seasonality as well as an up or down (linear) trend.

Could someone explain how to combine Wheeler's two techniques into one to deal with seasonal data with trend?

2. I am shopping for a basic SPC tool with the following characteristics. Could somebody advise where I should look?
a. Able to apply a linear trend line to the data and construct control limits based on trend line and not the average of the data (Wheeler's technique).
b. Customizable outlier detection rules - I am hoping to just use Wheeler's 3 rules for outlier detection (but Wheeler's 1, 2, 4 and 5 rules are OK substitution).
c. Query SQL database, recompute limits based on updated data, detect outliers and send notification emails.