Customer Complaint Surveillance: Tools to Establish Alert Thresholds
- Importance of establishing thresholds
- Alarm Estimation Tool
- Threshold Analysis Tool
- Which tool is right for me?
- Instructional videos for using these tools
Importance of Establishing Thresholds
Establishing thresholds is a key step in deploying Customer Complaint Surveillance (CCS). The simplest approach uses counting algorithms that compare the number of complaints over a predetermined time (e.g., one day, two days, etc.) to an established threshold. Thresholds are based on historical records of customer water quality complaints.
- Establish a baseline for different thresholds using historical complaint data.
- Apply a configurable scan algorithm to compare different alerting thresholds.
- Determine when an alert would have been generated in an historical dataset.
Alarm Estimation Tool (AET)
The Alarm Estimation Tool is a Microsoft Excel spreadsheet with macros that generate alerts based on historical complaint data. This data must be properly formatted and entered into the spreadsheet. The alerts can be viewed on a time-series plot for visual interpretation.
Download the Alarm Estimation Tool (xls) (Excel) Free Viewers
Threshold Analysis Tool (TAT)
The Threshold Analysis Tool is a software application that analyzes a variety of data file formats, including .txt, .csv, .xls, .xlsx, and .tab. It offers three different statistical methods (percentile, standard deviation, and recurrence intervals) to determine thresholds for CCS. Utilities can also set thresholds for temporal units (e.g., week days, weekends) or spatial units (e.g., treatment source, pressure zone), if their complaint data contains those details.
Download the Threshold Analysis Tool (zip) (Excel) Free Viewers
Which Tool is Right for Me?
Both tools will give the same results with the same data sets. The AET does not offer all the functionality of the TAT, but it is simpler to use. For users unfamiliar with statistical methods, the AET provides a straightforward approach to establishing thresholds using historical data. Although the AET supports fewer data file formats than the TAT, it provides a visual presentation of alerts.
The TAT supports a robust analysis of historical data using multiple statistical methods and sub-unit analysis for temporal or spatial data. In addition, the TAT supports more data file formats than the AET, making it easier to import historical data into the tool.
For a comparison of the two tools, see the table below.
FEATURE |
Alarm Estimation Tool |
Threshold Analysis Tool |
---|---|---|
Format of Tool |
|
|
Supporting Materials |
|
|
Acceptable Data |
|
|
Analysis Options |
|
|
Basis for Statistical Analyses |
|
|
Display Output Options |
|
|
Instructional Videos for Using These Tools
The following six videos provide an introduction and instructions for using the AET and the TAT. The following links exit the site
- An Introduction to the Alarm Estimation Tool and the Threshold Analysis Tool (6:43)
- Using the AET (4:07 min)
- Using the TAT - Gathering Data (5:44 min)
- Using the TAT without Spatial Units - Setting an Analysis Type, Setting a Threshold and Creating a Report (5:58 min)
- Using the TAT with Spatial Units - Different Thresholds (8:13 min)
- Using the TAT with Spatial Units - Same Threshold (7:20 min)