DE Histograms

This software is now unsupported. Sharing of software or other experience does not imply its fitness for your purpose, nor imply or express any warranty.

Download dehist.zip (266KB) now  and use pkunzip (29KB) to extract.

Also download the DE Histograms Users Guide (12KB)

DE Histograms Release 2000.1030

This Excel Add-In provides fast and easy graphical and statistical data analysis.
It allows your product or process to "speak for itself".
This Release has been designed for Excel (97 or 2000) for Windows.

Contents:
  New Features
  Overview
  Features
  Installation

-----------------------------------------------------------------------

New Features

Please note that the DE Histograms menu is now located on the right side of the main Worksheet ToolBar.

New Features in the 2000.1030 Release:
  * New: Multi-Vari Charts

New Features from the 2000.0726 Release included in the 2000.1030 Release:
  * Active Help System
  * Flexible Tests Table Column Headers
  * Multiple Test Limits over different Conditions
  * New OLAP Graphical User Interface
      * Lists all files for a given Project
      * Lists all file attributes
      * User may use existing file attributes or add your own to the list
      * User selects Condition(s) of interest, and desired Report
          * The New OLAP Engine does all the hard work of pulling the data together!
              (see Reporting Options below)
 * New OLAP Engine analyzes data across all user files that are in Standard format
    * New Bins Report
    * New Data Report
    * New Tests Table Report
    * Verification of File integrity
        * Reports why files are invalid
  * CDF Standard File Format recognized and generated
    * CDF is a very fast, small, easy-to-mine, parametric (and meta-) data format

------------------------------------------------------------------------

Overview

Are you responsible for a product, process, or part?
Continuous improvement principles encourage you to know and improve your product.
Now this Excel Add-In allows you to graphically and statistically analyze your data. Your product or process "speaks for itself".
If your data is "continuous" numeric data that can be fit by one or more Normal distributions, read on.

The Features of this Add-In are very advanced:
  * Full Excel capability
  * Tests-Table Driven
  * Smart X-Axis features (no more hunting for off-scale data)
  * Up to 65,535 data points per Test * Condition
  * Up to 32,767 Tests (limited by available Memory)
  * Graphical comparison of any number of Conditions
  * Advanced Statistics automatically deal with outliers
     (which drastically inflate estimates of standard deviation, and skew the average,
     in most other programs)
See the Features section for a more complete list.
Output Histograms appear in a new Workbook containing a Summary
Sheet followed by one Sheet per page of 8 histograms.

One Histogram is output for each Test in the Tests Table and for each Condition.

A Tukey rank-based robust outlier detection method is applied,
then Normal statistics are calculated on the remaining Main Mode points.

If there is more than one Condition, t-test and F-test statistics are reported,
with the first Condition as the reference distribution. Conditions with
significantly different Average or Variance are highlighted:
  * Green on Yellow for improved Variance
  * Red on Yellow for different Average, or increased Variance
  * Significance level is set to 0.05 divided by the number of tests
    (in order to control overall Type I Error rate)
 

Multiple Test Limits over Conditions are simply handled: This program reads the Condition #(s) from
the user Comments in the Header Cells of the Tests Table.
More than one Condition # is indicated using commas or spaces.

-------------------------------------------------------------------------

Features

* Your data is safe: All calculations are done in a separate workbook
* Comprehensive Output is placed in a new Excel Workbook and includes:
   * Full Excel capabilities (viewing, filtering, saving, printing, editing ...)
   * Statistical results are presented in both tabular and graphical form
   * All traceability information (reference to data, tests table)
   * AutoFilter (point-and-click selection of tests or conditions of interest)
   * Results are presented in 1-page-wide view (ready for printing)
   * File-size estimate
* Fast - Thousands of data points per second
* Active Help System
* Demo Data
   * Includes a random number generator with which to simulate new data
* Automatic handling of Outliers
* Handles all types of data including formulas, text, and error values
* Tests-Table driven (Spec Limits and other options)
   * Tests may be in any order and are individually selectable
   * The following user-specified Tests-Table Columns drive this program:
      * Test
      * Name
      * Sort
      * SpecLo, SpecHi (multiple over Conditions is handled)
      * HistSigma (+-6-sigma lines are plotted, or user's choice)
      * Title
      * ChartLo, ChartHi
      * Units
      * Avg, StDev, Cp (used to turn off statistics if desired)
* Tests Table and Data may be anywhere, on any sheet(s) in any workbook(s)
   * "Make Blank Excel Tests/Data Tables" option allows a quick-start
   * Only One Column is required in the Tests Table
   * Defaults are stored in Tests-Table-Sheet-level names
      - Effective if multiple Tests Tables are in different Sheets
   * Multiple Tests Tables may be used (on different Sheets)
* Handles all input errors (such as non-numeric data)
* Filters are observed, providing useful selection of tests or data rows
* All user inputbox inputs pop up as defaults for the next Run
* Histogram X-Axis Features:
   * All data is always shown
   * No truncation or round-off error
   * X-Axis scale is automatically locked across Conditions (user may override)
* Smart pagination
* Smart Tabular output
   * t-test and F-test statistics are reported (if there is more than one Condition)
   * Number format is aligned non-scientific if possible
   * Explanatory Field Comments are included
* Smart Graphical output
   * The Histograms for a given Condition are always at
   the same place on a page, for #Conditions=1 thru 8
   * Yaxis scale is not affected by a high number of off-chart outliers
   * Smart format of very small or very large numbers
* Titles may be included for each Test, Condition, and Run
* Professional Documentation:
   * All output contains consistent DateTime and Release Code Stamps
   * Release Code is traceable
 

General Specifications:* Requires: Excel (Excel 97 or later) for Windows
   * Subject to available Memory
   * Only the author's current version of Excel will be supported
   * Full fast-response Support is limited to Delphi Automotive Systems, its Suppliers, and Customers
   * Up to 32,767 Tests per Project
   * Any number of Conditions (Multi-Vari Charts show the first <=32 Conditions)
   * Measurements may be either Periodic or non-Periodic
   * This Release allows any of the following Tests Table Column Headers for the Min and Max limits:
      "speclo", "min", "limit min", "lim min", "lspl", "_lspl", "Spec Limit Lo", "Spec Lo Limit",
      "Spec Lim Lo", "Spec Lo Lim", "Low Limit", "Lo Limit", "Low Lim", "Lo Lim", "LimLo",
      "LoLim", "Lim Lo", "Limit Lo", "Lim Low", "Limit Low", "lsl", "_lsl_", "_lsl"
      "spechi", "max", "limit max", "lim max", "uspl", "_uspl", "Spec Limit Hi", "Spec Hi Limit",
      "Spec Lim Hi", "Spec Hi Lim", "High Limit", "Hi Limit", "High Lim", "Hi Lim", "LimHi",
      "HiLim", "Lim Hi", "Limit Hi", "Lim High", "Limit High", "usl", "_usl_", "_usl"
   These Headers are then carried thru to the Main Table and Graphical Output.

Specifications, Analysis of Data in Excel:
* Up to 65,535 data points per Test * Condition
* Any number of Data Range Areas (limited by 255-Character InputBox) per Condition

Specifications, OLAP Analysis of Data In Files:
* Up to 65,500 Standard Data Files (in each OLAP List)
* Up to 32,767 File-level Conditions (in each file)
* Up to 32,767 Part-level Conditions (for each part)
* Up to 65,500 Bins per Project
* Any number of Parts or Times/Cycles per file

(One "part" may also be multiple measurements of one part.)
---------------------------------------------------------------------------

Installation

1 If you have installed prior Releases of DE Histograms,
it is best to rename or remove the old file "dehist.xla" using
Start-Find. Excel has a habit of tenaciously hanging onto old files.

2 Everything needed to run this program is contained in one file called dehist.xla.
Right-click dehist.zip and select the Save Link/Target As option to begin downloading the zipped file onto your computer.
The zipped file can be unzipped after downloading (right click, then Save Link/Target As) the pkunzip.exe program. Once downloaded, drag the
dehist.zip file onto the pkunzip.exe program, or from the Dos command line, type "pkunzip dehist.zip".

3 Open dehist.xla

(Due to the smart toolbars in Excel 2000, it is no longer recommended to load this from Tools-AddIns.)

If a security dialog comes up during installation of DE Histograms, click on "Enable Macros".
This tells you that you are loading Visual Basic code.

Following Installation, the Active Help System should appear.

"DE Histograms" should now appear on the right side of the main CommandBar (toolbar).

Open your data workbook(s) prior to Analysis.
Click on Window to return to any open Workbook.

Click on "DE Histograms" in the Menu (at the top). Then the options are:
  * Analyze Data in Files
  * Analyze Data in Excel
  * Help

Verify the proper Release at the top of the Help dialog or the bottom of any output Sheet.

---------------------------------------------------------------------------

Several users have commented that this combined with a writeable CD-ROM and the freely available 2MB Excel Viewer available at:
http://www.microsoft.com/office/000/viewers.htm#excel
is a good solution for data-retention archival requirements.

---------------------------------------------------------------------------

(c) Copyright Delphi Delco Electronics Systems 1997 - 2000
This software may be freely shared world-wide.
"Sharing of software or other experience does not imply its fitness for your purpose, nor imply or express any warranty."