QWXL 3 Features
QWXL 3 is a powerful charting utility for Microsoft Excel® that offers many features to help you unlock the power of your data. These include eleven different charts over 5 chart screens and over 100 statistical calculations.
QWXL 3 Features
- Trieto Chart
- MultiLine Chart
- Forecast Chart
- Logsheet
- Numeric data is displayed in colour (based on Limits)
- You can use Excel® based filtering to slice through data
- Prioritizing of relationships based on correlation coefficients
- Limits now saved as a Named Range on the Excel® Workbook
QWXL 3 charts and statistics are available via 6 different screens that are accessible at the click of a mouse button.
The Logsheet Screen
The Logsheet Screen takes the spreadsheet data and reproduces it using colors based on either calculated of fixed limits for each variable. If limits are saved they will be inserted in the first seven rows of the spreadsheet.
Control Screen
The Control Screen offers a control chart, moving range chart and histogram in addition to several statistical calculations. The control chart displays your data over a color coded overlay of your specification and control limits. Average is automatically calculated, and limit calculations and x-axis labels are easily customized from their defaults.
Relate Screen
The Relate Screen uses two control charts to explore relationships between variables. It also offers a scatter plot and more statistics.
Compare Screen
The Compare Screen allows you to compare two separate time frames for an individual variable to help identify if a change has occurred in a product or variable. Included on this screen is a histogram and statistics.
The Trieto Screen
The Trieto screen is a unique combination of up three pareto charts, ranking highest to lowest or vice-versa. It provides you with a simple way of ranking both text of numeric data for analysis, perfect for event type data like downtime or defects.
MultiLine Screen
The MultiLine Screen offers a new MultiLine Chart that allows for the comparison of multiple variables using the Capability Bar (+/- 3SD around the average) for each variable. Variables can be selected of filtered for inclusion in the chart.
Forecast Screen
The Forecast Screen offers new Forecast Chart that provides the ability to set goals for a variable and then allows the viewing of data in the future to predict when, or if, a goal will be met. The chart allows for the exploring of both linear and exponential plotting of data to determine the best fit for the data.
Report Screen
The Report screen provides you with a quick display of the summary statistics for the data you have selected. The values highlighted in light blue are to bring your attention to values that have exceeded a pre-set value. You can hover your cursor over a highlighted value to view the reason why it is highlighted.
Statistics in QWXL v3
In addition to providing exciting charts of your data, QWXL 3 automatically performs 100 different statistical calculations on your data, including target deviation, three different ways of calculating limits, average, moving range, and observed and calculated out of limits. These automatic calculations are reported on screen in the Statistics Box, making statistical analysis a breeze!
Ease of Use
QWXL 3 is a breeze to install and use, saving you from complicated set up procedures. The program offers a simple point and click interface that is intuitive and easy to learn and includes an on-line help program. By using your existing Excel® spreadsheets and templates, the majority of the work is already done and the data is just waiting to be analyzed. Imagine: power and sophistication without the effort!
A Pedigree of Excel®lence
QWXL 3 uses the Quality Window charts which have been tested on the factory floors in over 50 countries for the past 10 years. Adopted as a standard by Fortune 500 firms for process monitoring, downtime analysis and quality control, Quality Window incorporates both traditional and cutting edge SPC/SQC theory in its calculations.
|
