利用Excel函数建立公差分析模板

Use Excel Functions to Establish Tolerance Analysis Template

介绍利用Excel函数编制公差分析模板的方法,利用此模板可以满足一维尺寸链公差的计算。只需输入计算零件尺寸及上、下偏差,就能够自动计算出公差结果,计算结果正确,而且缩短工作时间,降低设计人员工作量。

The paper introduces how to generate a tolerance analysis template by using Excel functions for the tolerance calculation of one-dimensional dimension chains.With this templete,the tolerance result can be calculated out automatically by just inputting the dimensions,and the upper and lower deviations of the calculated part.The correct calculation result could reduce the design time and workload.