Tel: (613) 938-0900
Fax: (613) 937-3315

QWXL Maintenance Release Information

This page contains detailed information about the changes evident in each maintenance release of QWXL, and it's associated programs. Should you have any questions concerning a change, contact Busitech Tech Support directly.

Build No.	Details of Changes to QWXL
2.2.0.14 February 10, 2006	Corrected bug in median calculation Corrected 'Type Mismatch' error when invalid data entered in the spreadsheet Limits named ranges
2.2.0.12 January 8, 2004	Corrected "tib" indexes on compare. Data was not being split equally on first view.
2.2.11 June 25, 2003	Corrected international decimal problem (comma vs period) of fixed limits from spreadsheet.
2.2.10 March 4, 2003	Changed how QWXL icon is placed on Excel® Toolbar Corrected scaling with the relate chart
2.2.09 August 16, 2002	Corrected scaling with the Relate chart
2.2.08 August 08, 2002	Modified Tz calculation to simulate report type of "VT"
2.2.0.7 May 21, 2002	Modified all calculated limits to be affected by the standard deviation calculation method
2.2.0.6 March 8, 2002	Correlation Coefficient on relationship screen corrected
2.2.0.3 February 5, 2002	Version 2.2 Released Median calculation corrected when data point population is less than 3 Histogram stats were not printing when elevator chart displayed
2.01.0053 September 6, 2001	Fixed subscript error when selecting a row on a spreadsheet with column limits
2.01.0045 June 6, 2001	Changed descriptive statistics in elevator chart to reflect current method of standard deviation on calculated UCL and LCL
2.01.0042 June 5, 2001	Fixed histogram cursor Changed calculated limit strings in statistics box Fixed moving range calculations
2.01.0040 May 25, 2001	Added highlight section on axis bar for lowest SD data point range Corrected calculation for Low-SD. Now uses segment count instead of population count. Corrected tib movement errors.
2.01.0037 April 25, 2001	Setting sample size descriptive statistic to false was not printing other statistics
2.01.0035 March 30, 2001	Made changes to control chart and histogram color bands Fixed copy and paste to exclude dropdown menu from image
2.01.0031 March 19, 2001	Limit multiplier is now reflected on Range chart
2.01.0030 March 16, 2001	Added error trapping to save limits to spreadsheet
2.01.0025 January 10, 2001	QWXL initialization during splash screen changed
2.01.0024 December 29, 2000	Install stub changed to address QWXL icon on Excel® Toolbar
2.01.0023 December 28, 2000	Fixed decimal place precision problem in histogram stats Changes for international decimal characters. These changes effect the stats box, histogram stats, and limits on the options screen
2.01.0018 December 13, 2000	Made changes for proper support of internationalization settings
2.01.0001 November 30, 2000	Version 2.1 Released Custom colors not updating on combo limits box Removed colors from limit multiplier text boxes (will be confusing) Custom colors are now being written when Save Limits to Spreadsheet is envoked. GetCr calculation had division by zero error. If any error occures the returned value will be zero and no error message will be displayed. Multiple limits set to the same value...overwriting limit label values. limit label displayed will be the last drawable band. (eg. LSL over LCL, LCL over TGT)
2.00.0102 November 22, 2000	Changed copy chart only to include range chart if present Added hot keys for paste menu options (CTRL-V for chart only, CTRL-T for Complete Window) Made changes for new QWRegist command line parameters
2.00.0100 November 21, 2000	Changed copy and paste menus (under Edit, right click, toolbar dropdown menu) Changed UI on Limits option tab Changed UI on Colors option tab Single click color preview box brings up color picker. Double click list entry brings up color picker. Fixed the hairline cursor on the histogram
2.00.0095 November 17, 2000	Added button to restore default settings for colors, labels, and SD multipliers Fixed saving of colors to INI file Paste in Excel® activated after chart copy performed
2.00.0092 November 16, 2000	Option to change band labels added on General Options window Option to change band colors added to new Colors tab in Options window Copy has 3 functions, Copy Chart Window, Copy Control Chart, Statistics as Text
2.00.0091 October 31, 2000	Now writes all limits to the spreadsheet
2.00.0090 October 31, 2000	Fixed formatting issues with statistics on all charts
2.00.0089 October 30, 2000	Addressed issue of Compare chart statistics needing fixed limits in order to be calculated. Statistics will now use full fixed limits against selection area data
2.00.0088 October 24, 2000	Fixed the report stats function (removed MRUCL) Fixed title bar to update when worksheet is changed and refresh is selected. Disabled tibs if selection is <= 2 on Control Chart and Relate Chart Disabled tibs if selection is <=4 on Comparison Chart
2.00.0082 October 23, 2000	Fixed chart labels from printing past the window space on all charts. Revised chart labels on all charts. Fixed axis scaling on Histogram Fixed number formatting errors in Comparison stats box Added the following statistic calculations MRsd = MRbar * 1.089 MRucl = MRbar * 3.267 MRuwl = MRbar + (x * MRsd) MRlwl = MRbar - (x * MRsd) Modified the following statistic calculation SDMR = MRBAR / 1.128 Fixed division by zero error in Cr calculation Fixed limits combo box to retain calculated value if no fixed limit is available Added lower warning limit to Range chart Changed range chart to show red control line if warning limit exceeds control limit Fixed decimal place error Fixed wrong color for lower warning limit on range chart
2.00.0076 October 20, 2000	Selectable standard deviation multiplier for calculated limits. Limits are saved in memory for the entire scope of the program. Range chart now has a warning limit band calculated as MR-bar + (1 * MR-SD) Range chart labels read MR-bar and MR-UCL Range chart now occupies 50% of control chart window when enabled t-Calc fixed
2.00.0072 August 16, 2000	Fixed Capability Index statistic from printing null value
2.00.0071 August 15, 2000	Fixed Capability Index statistic division by 0 error Added Capability Index statistic (calculated 1 / Cr). Value will highlight if < 1.33
2.00.0066 June 2, 2000	Error handling in place if writing qwxl.qwx to a read-only drive
2.00.0066 June 1, 2000	Import Utility Better error trapping has been established for reading files on mapped network drives with the read-only attribute set
2.00.0065 May 19, 2000	Import Utility Statistics abbreviations for Observed & Calculated made more meaningful Bottom chart data on Relate screen was not consistent with top chart after selection changed
2.00.0063 May 16, 2000	Average Moving Range stat not being calculated for bottom chart in Relate Average Moving Range stat not being printed in Compare
2.00.0059 May 15, 2000	Version 2.0 Released Corrected subscript error if one numeric cell selected Error message if 1 selected cell is not numeric Error message if less than 5 cells are selected and Compare is chosen

• Click here to download the latest version of the software.