A method and tool for calculating the contribution of one-dimensional dimensional chain links

Abstract

The present invention relates to a one-dimensional dimension chain link contribution calculation method and tool, the one-dimensional dimension chain link contribution calculation method comprises the following steps: establishing a link contribution calculation table in Excel software, the link contribution calculation table is provided with a code column, a tolerance column, a tolerance distribution form column and a contribution column; editing the link contribution calculation formula in the link contribution calculation table to form a link contribution calculation template; inputting the code of each link in the code column, inputting the tolerance parameters of each link in the tolerance column, inputting the tolerance distribution form of each link in the tolerance distribution form column, and displaying the contribution calculation results of each link in the contribution column. The one-dimensional dimension chain link contribution calculation tool comprises the link contribution calculation template formed in the one-dimensional dimension chain link contribution calculation method. The present invention improves the efficiency of dimension chain analysis.

Description

Technical Field

[0001] The invention relates to automobile parts, and in particular to a one-dimensional dimensional chain link contribution calculation method and tool. Background Art

[0002] According to the current status of the automotive manufacturing industry, in the current one-dimensional dimension chain statistical analysis, the tolerance distribution of each link generally exists in three different forms, namely normal distribution, uniform distribution and extreme value distribution. When the tolerance value is the same, each distribution has a different impact on the analysis result of the entire dimension chain. When analyzing the dimension chain, it is impossible to quickly identify which link has a significant impact on the calculation result. Therefore, in the actual analysis process, experience is needed to judge the impact of each link, thereby reducing the efficiency of the dimension chain analysis. Summary of the invention

[0003] The purpose of the present invention is to provide a one-dimensional dimensional chain link contribution calculation method and tool to alleviate or eliminate at least one of the above-mentioned technical problems.

[0004] A method for calculating the contribution of a one-dimensional dimensional chain link according to the present invention comprises the following steps:

[0005] S1. Establish a link contribution calculation table in Excel software. The link contribution calculation table is provided with a code column, a tolerance column, a tolerance distribution form column and a contribution column. The code column is used to input the code of each link, the tolerance column is used to input the tolerance of each link, the tolerance distribution form column is used to input the tolerance distribution form of each link, and the contribution column is used to display the contribution calculation result of each link;

[0006] S2. Edit the chain link contribution calculation formula in the chain link contribution calculation table to form a chain link contribution calculation template. The chain link contribution calculation formula includes:

[0007] When the tolerance distribution of the chain link is normal distribution, the contribution of the chain link is A i is the tolerance value corresponding to the chain link,

[0008] When the tolerance distribution of the chain link is uniform, the contribution of the chain link is B i is the tolerance value corresponding to the chain link,

[0009] When the tolerance distribution of a link is an extreme value distribution, the contribution of the link is C i is the tolerance value corresponding to the chain link,

[0010] in,

[0011]

[0012] A1, A2...A q are the tolerance values ​​of all q links whose tolerance distribution form is normal distribution,

[0013] B1, B2...B w are the tolerance values ​​of all w chain links with uniform tolerance distribution,

[0014] C1, C2...C e are the tolerance values ​​of all e links whose tolerance distribution form is extreme value distribution,

[0015] The tolerance value is the difference between the upper and lower tolerance limits of each link;

[0016] S3. Enter the code of each link in the code column, enter the tolerance parameters of each link in the tolerance column, enter the tolerance distribution form of each link in the tolerance distribution form column, and display the contribution calculation results of each link in the contribution column.

[0017] The present invention also proposes a one-dimensional dimensional chain link contribution calculation tool, including a link contribution calculation template formed in the one-dimensional dimensional chain link contribution calculation method.

[0018] The present invention proposes a method for calculating the contribution of a one-dimensional dimension chain link, forming a simple calculation tool. During the calculation process, each link can clearly present its contribution in the entire calculation result, which is easy to identify and improves efficiency. At the same time, it can quickly determine the direction of tolerance optimization and improve the rationality and accuracy of tolerance allocation.

[0019] The present invention adopts mathematical calculation to perform mathematical analysis on each link, obtains the proportion of each link in the whole vehicle size chain analysis result, and uses Excel table tool to reflect the contribution of each link in the table tool.

[0020] The present invention can more accurately lock the contribution of each link in the actual dimension chain analysis, can very conveniently identify the link with the largest contribution, and quickly find the optimization direction; in the dimension chain tolerance decomposition, it can find the leverage point for optimizing the tolerance, reasonably distribute the tolerance, and ensure the lowest cost and the optimal tolerance distribution; in the problem decomposition, it can quickly find the largest influencing factor, improve the analysis efficiency, and save analysis time. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] Figure 1 It is a schematic diagram of the one-dimensional dimension chain link contribution calculation tool described in the specific implementation manner. DETAILED DESCRIPTION

[0022] The present invention will be further described below in conjunction with the accompanying drawings.

[0023] A method for calculating the contribution of a one-dimensional dimensional chain link according to the present invention comprises the following steps:

[0024] S1. Establish a link contribution calculation table in Excel software. The link contribution calculation table is provided with a code column, a tolerance column, a tolerance distribution form column and a contribution column. The code column is used to input the code of each link, the tolerance column is used to input the tolerance of each link, the tolerance distribution form column is used to input the tolerance distribution form of each link, and the contribution column is used to display the contribution calculation result of each link;

[0025] S2. Edit the link contribution calculation formula in the link contribution calculation table, establish a mapping relationship between the tolerance column, the tolerance distribution form column and the contribution column, and form a link contribution calculation template. The link contribution calculation formula includes:

[0026] When the tolerance distribution of the chain link is normal distribution, the contribution of the chain link is A i is the tolerance value corresponding to the chain link,

[0027] When the tolerance distribution of the chain link is uniform, the contribution of the chain link is B i is the tolerance value corresponding to the chain link,

[0028] When the tolerance distribution of a link is an extreme value distribution, the contribution of the link is C i is the tolerance value corresponding to the chain link,

[0029] in, C e ),

[0030]

[0031] A1, A2...A q are the tolerance values ​​of all q links whose tolerance distribution form is normal distribution,

[0032] B1, B2...B w are the tolerance values ​​of all w chain links with uniform tolerance distribution,

[0033] C1, C2...C e are the tolerance values ​​of all e links whose tolerance distribution form is extreme value distribution,

[0034] The tolerance value is the difference between the upper and lower limits of the tolerance parameters corresponding to each link. The tolerance value can be directly obtained or calculated based on the tolerance parameters entered in the tolerance column. The tolerance distribution form of the link can be determined based on the tolerance distribution form column.

[0035] S3. Enter the code of each link in the code column, enter the tolerance parameters of each link in the tolerance column, enter the tolerance distribution form of each link in the tolerance distribution form column, and display the contribution calculation results of each link in the contribution column.

[0036] The principle of the chain link contribution calculation formula is specifically explained below using q=3, w=2, and e=2.

[0037] The calculation principle formula of one-dimensional dimensional chain is:

[0038] Let the above formula be m;

[0039] make is n;

[0040] Then the proportion of n is

[0041] C i The proportion of m is

[0042] Let A2 = xA1, A3 = yA1,

[0043] Then: A1 2 +A2 2 +A3 2 =(1+x 2 +y 2 )*1 2

[0044] Then: A i The proportion in m is:

[0045] B i The proportion in m is:

[0046] The present invention also proposes a one-dimensional dimension chain link contribution calculation tool, including a link contribution calculation template formed in the above-mentioned one-dimensional dimension chain link contribution calculation method. The link contribution calculation template is saved as an Excel file to form a reusable one-dimensional dimension chain link contribution calculation tool.

[0047] In some embodiments, Figure 1As shown, the link contribution calculation template includes a code column 1, a dimension link element column 2, a direction column 3, a tolerance column 4, an angle vector column 5, a tolerance band column 6, a square column 7, a distribution form column 8, a normal distribution column 9, a uniform distribution column 10, an extreme value distribution column 11 and a contribution column 12. Code column 1 is used to input the code of the link to distinguish the links with different processes and assembly forms; dimension link element column 2 is used to input the Chinese name of the link; direction column 3 is used to input the tolerance direction; tolerance column 4 is used to input the tolerance parameter; angle vector column 5 is used to input the vector angle of the link; tolerance band column 6 is used to display the tolerance value; square column 7 is used to display the square of the tolerance value; distribution form column 8 is used to input the tolerance distribution form of the link; normal distribution column 9 is used to display the square of the tolerance value of the link with a normal distribution; uniform distribution column 10 is used to display the square of the tolerance value of the link with a uniform distribution; extreme value distribution column 11 is used to display the square of the tolerance value of the link with an extreme value distribution; contribution column 12 is used to display the contribution ratio of the link in the dimension chain.

Claims

1. A method for calculating the contribution of a one-dimensional dimensional chain link, characterized in that: The following steps are involved: S1. Establish a link contribution calculation table in Excel software. The link contribution calculation table is provided with a code column, a tolerance column, a tolerance distribution form column and a contribution column. The code column is used to input the code of each link, the tolerance column is used to input the tolerance of each link, the tolerance distribution form column is used to input the tolerance distribution form of each link, and the contribution column is used to display the contribution calculation result of each link; S2. Edit the chain link contribution calculation formula in the chain link contribution calculation table to form a chain link contribution calculation template. The chain link contribution calculation formula includes: When the tolerance distribution of the chain link is normal distribution, the contribution of the chain link is A i is the tolerance value corresponding to the chain link, When the tolerance distribution of the chain link is uniform, the contribution of the chain link is B i is the tolerance value corresponding to the chain link, When the tolerance distribution of a link is an extreme value distribution, the contribution of the link is C i is the tolerance value corresponding to the chain link, in, A1, A2...A q are the tolerance values ​​of all q links whose tolerance distribution form is normal distribution, B1, B2...B w are the tolerance values ​​of all w chain links with uniform tolerance distribution, C1, C2...C e are the tolerance values ​​of all e links whose tolerance distribution form is extreme value distribution, The tolerance value is the difference between the upper and lower tolerance limits of each link; S3. Enter the code of each link in the code column, enter the tolerance parameters of each link in the tolerance column, enter the tolerance distribution form of each link in the tolerance distribution form column, and display the contribution calculation results of each link in the contribution column.

2. One-dimensional dimensional chain link contribution calculation tool, characterized by: It includes the link contribution calculation template formed in the one-dimensional dimension chain link contribution calculation method described in claim 1.

Images