Zorich Technical Consulting & Publishing
Statistical Application Software
Home Page
We offer powerful MS Excel spreadsheets designed to simplify activities in Manufacturing, QA, & R&D.  Each spreadsheet is formally validated (protocol and report provided free to purchasers of the spreadsheet), and are "GMP" and "Part 11" compliant --- the Validation Protocols/Reports have successfully withstood the scrutiny of auditors from FDA, FDB, TUV, BSI, KEMA, & NSAI. None of the files contain macros or other code-based add-ins.  The purchase price entitles you to make as many copies for use by as many employees on as many computers as desired, all within a single company at 3 sites (e.g., home office, a pilot plant, & a Mexican mfg. facility).
                               (Click here for a list of current prices.)
Our statistical clients (for seminars, consulting services, and/or software) include many start-ups and a few major corporations, including Becton Dickinson, Boston Scientific, and Siemens.  Our spreadsheets are in use at over a dozen Mfg/R&D plants in the USA, and 5 in Mexico. Working "demo" copies of our validated products are available for download, below; in addition, two "freeware" programs are provided for sampling plan analysis.
About Us
Client List
Quality Systems
Safety
Prop 65
Variables Data SPC  (demo file --- click here to start downloading)
Seminars
XbarR, XbarS, XmR, and other types of Statistical Process Control Charts are automaticly generated, along with a histogram chart, capability indices, and a preformatted customizable printable report.  SPC Charts automaticly identify out-of-control points.
Count Data SPC  (demo file --- click here to start downloading)
P and U Statistical Process Control Charts are automaticly generated, along with a pareto chart and a preformatted customizable printable report.  SPC Charts automaticly identify out-of-control points.
Reliability Statistics Basics  (demo file --- click here to start downloading)
Calculation of component reliability using K-factors, stress/strength analysis, failure analyses, with applications for "normally distributed" data as well as data from unknown distributions.  Calculations are simplified with easy-to-use interfaces & expanded ranges of inputs, compared to tables typically available.
Reliability Plotting  (demo file --- click here to start downloading)
Calculation of component % reliability at a given % confidence, using "Reliability plotting", which is also known as "probability plotting", "rectification", etc.  Reliability plotting can also be used to confirm data as being "normally distributed" or can be used to identify what data transformation is needed.
Mouse click the following link to read more about RELIABILITY PLOTTING.
Power Curves for t-Tests  (demo file --- click here to start downloading)
REVISED 2010 --- Four types of power curves are provided (as opposed to the one type provided in most other stat-packages):  Power vs. Sample Size,  Power vs. Hypothesized Difference, Power vs. Alpha, and Power vs. Population Standard Deviation. Simple user interface.
Statistical Analysis of Gages  (demo file --- click here to start downloading)
Powerful tools for quantifying measurement uncertainty. Methods include Gage R&R (up to 3 persons, 3 gages, 3 replicates, and 10 parts), Gage Correlation (up to 3 gages), Gage Bias, Gage Linearity, Spec/Inaccuracy Ratios, and Guardbanding. An essential tool for setting product spec limits that take into consideration the uncertainty in the measurement process.
MDD-Plus C=0 Sampling Plans  (demo file --- click here to start downloading)
NEW IN 2009 --- File provides sampling plans that meet the requirements of Annex IV, Section 6, of the version of the MDD that had been in place up thru 2009. File outputs the smallest sample size that has no more than a 5% chance of passing QC (as required by the MDD). Automaticly created OC curve and SampleSize vs. LotSize curve. For lot sizes up to 10,000. 
C = 0 Sampling Plans (demo file --- click here to start downloading)
File outputs include two different types of OC curves, and the AOQL for the chosen plan. Instead of relying on a sample-size table, this program calculates the exact absolute smallest sample size that gives the desired protection level for a given exact size lot.  For lot sizes up to 1000, only. 
Self-made Sampling Plans   ( FREE-ware --- click here to start downloading)
Examine the OC curves for your own custom sampling plans. Use either binomial or hypergeometric calculations.  Now be able to explain the "valid statistical rationale" of the sampling plans you already use.
Sequential Sampling Plans   ( FREE-ware --- click here to start downloading)
Provides an analysis and planning tool for sample sizes in situations where lots undergo sequential inspections (e.g., 1st by Manufacturing, 2nd by QC, and finally by QA).