Al's Engineering Worksheets

Disclaimer

The following engineering spreadsheets are offered on the public domain to assist fellow engineers and students in good faith. While every effort has been taken to ensure these worksheets do not contain errors, errors may exist. It is the user's responsibility to check all results obtained from these worksheets. As the competency of the person using these worksheets cannot be controlled, nor can the quality or appropriateness of data entered into the worksheets be controlled, the author cannot accept any liability for the results, nor any loss or damages resulting from application, correct or otherwise, of the worksheets.

Statistical and Quality Calculation Worksheets

This is not a tutorial on how to use Control Charts. These files are presented here for those who know what they are and how to use them (in general terms). Below is a list of references should you wish to know more about Control Charts and Design of Experiments.

References:

• John McConnell, Safer Than a Known Way, Delaware Books, ISBN 0 9588324 3 9
• John McConnell, The Seven Tools of TQC, Delaware Books, ISBN 0 9588324 0 4
• John McConnell, Analysis and Control of Variation, Delaware Books, ISBN 0 9588324 2 0
• Keki R. Bhote, World Class Quality, Amacom, ISBN 0-8144-5053-9

c Control Chart

p Control Chart

u Control Chart

Mean x and R Chart

x and R Chart

Process Capability (Cpk) Calculations

CpkPerfectSamples

Deming Funnel Experiment

2^2 Full Factorial Analysis

2^3 Full Factorial Analysis

2^4 Full Factorial Analysis

Variables Search

Air Systems Measurement and Design Worksheets

References:

• Industrial Ventilation, American Conference of Governmental Industrial Hygenists, ISBN 0-936712-97-X
• Fan Engineering, Buffalo Forge Company

10 Point Measurement Traverse Calculations

Mechanical and Structural Worksheets

References:

2D Centroid

External Loading Design

Estimating Worksheet