Adcats Free Tolerancing Spreadsheets

Check the software you plan to download.
	CATS 1D Tolerance Stack-up Features include: Four methods of tolerance stackup analysis: 1) Worst Case (WC) 2) Statistical (RSS)--using ą3 Sigma tolerances; Normal or Uniform distributions. 3) Motorola Six Sigma (6s)--using Cp and Cpk 4) Measurement data (Meas)--using production part measurement data Plots the resulting normal distribution with applied upper and lower limits. Automatically calculates the rejects at the upper and lower limits, and calculates the predicted yield of acceptable assemblies as a percent or parts-per-million (ppm). No Monte Carlo simulation is required. Just input mean and 3 sigma variation for each dimension. Standard Excel 2000 spreadsheet. No .dll files required. No macros to get corrupted.
	Weight Factor Allocation Uses weight factor allocation method. Enter tolerances for each dimension and the required assembly tolerance. Weight factors can then be added to direct the distribution of any excess assembly tolerances to the components that need it most.
	Minimum Cost Allocation Reduces the overall cost of an assembly by increasing the tolerance of those parts which are produced by expensive processes and decreasing tolerances on less expensive parts. The governing constraint is the tolerance sum allowed for the assembly, which may be calculated by worst case or statistical analysis. Uses a cost vs. tolerance model which assumes that the cost of producing a part to a given tolerance varies as 1/tol^k. An empirical cost function of the form: C = A + B/tol^k is supplied by the designer by specifying the coefficients A, B and k for each part. C is the cost in US Dollars. A is the setup cost per part, B and K depend on the process and nominal size. Tables of these values can be found in the appendix of the "Tolerance Allocation" paper, also available for download.

License Agreement

Description of User Rights

1. You may make as many copies of this software as you want for your own personal use, or for the use of someone under your direction. You may change the name of the file for the purpose of archiving analysis results. You may use images of the worksheet, or portions thereof, in documents or reports related to its intended application.

2. You may distribute copies of the original software to your associates or clients as long as you do not change any protected cells in any of its worksheets, and as long as you retain the ADCATS copyright notice in the footer of the first worksheet. Please forward this license agreement with the .xls file.

3. You may unprotect the file and modify the program if you so desire, but you may not distribute a modified version without express permission from the ADCATS director. We recommend that you keep a virgin copy of the original in a safe place, if you intend to unprotect the worksheet.

Limitations

1. This software product is protected by copyright laws and international treaty. You may not sell, lease or rent it, or use it, or any portion of it, as part of a commercial computer application without express permission, in writing, from the ADCATS Director.

2. This limitation does not include the user receiving compensation for applying the software for design or analysis purposes.

3. If you intend to use the software in a published work, you must obtain permission from the ADCATS Director. Sale of published works may be subject to royalty payments.

4. You may use the software in education or training courses. You may use images of the worksheet in notes copied for the class. You may distribute copies of the software to the class if the instructor will provide ADCATS with the name of the school or sponsor, the name and phone number or email address of the instructor, time and place of the course, and a list of names of the students in the course. Class members may retain copies of the software for their own use, subject to the above restrictions on copying, modifying or distributing.

Liability

Use the software at your own risk. There is no guarantee or warranty. ADCATS accepts no liability for any special, incidental, indirect, or consequential damages whatsoever arising out of the use or inability to use this software product. This includes, without limitation, damages for loss of business profits, business interruption, loss of business information, or any other pecuniary loss.

I have read the license agreement and agree to abide by the stated limitations.

*Please use this form to complete the registration of your software*
Name
Company
Division/Department
Street Address
PO box/mail stop
City	State ZIP
Country
Email
Telephone (optional)
To ensure that you are a human using this form and not a computer, please type the word "submit" in the next box. (don't use quotes)