Tolerance analysis of 2-D and 3-D dimensional chains.

Table of Content:

Tolerance analysis of 2-D and 3-D dimensional chains.

The program is designed for the tolerance analysis of two-dimensional (2-D) and three-dimensional (3-D) dimensional chains. The program solves the following problems:

  1. Tolerance analysis of a dimensional chain using the "Worst case" method.
  2. Tolerance analysis of a dimensional chain using the "Monte Carlo" method.

In designing a dimensional chain, the program enables work with standardized tolerance values.

Data, methods, algorithms and information from professional literature and ANSI, ISO, DIN and other standards are used in calculation.
List of standards: ANSI B4.1, ISO 286, ISO 2768, DIN 7186


User interface

 User interface.

 

Download

 Download.

 

Purchase, Price list

 Purchase, Price list.
 

Control, structure and syntax of calculations.

Information on the syntax and control of the calculation can be found in the document "Control, structure and syntax of calculations".

Information on the project.

Information on the purpose, use and control of the paragraph "Information on the project" can be found in the document  "Information on the project".

Theory - Fundamentals.

A dimensional chain is a set of interdependent dimensions which connect each other to create a geometrically closed circuit. They can be dimensions specifying the mutual position of components on one part or dimensions of several parts in an assembly unit.

A dimensional chain consists of separate partial components (input dimensions) and ends with a closed component (resulting dimension). Partial components (A, B, C,…) are dimensions either directly dimensioned in the drawing or following from previous manufacturing, possibly assembly operations. The closed component (Z) in the given chain represents the resulting manufacturing or assembly dimension, which is the result of combining partial dimensions as a scaled manufacturing dimension, possibly assembly clearance or interference of a component. The size, tolerance and limit deviations of the resulting dimension depend directly on the size and tolerance of partial dimensions. Depending on the mutual position of the individual components, we differentiate between three types of dimensional chains:
- Linear chains (1D) – these include only parallel dimensions
- Two-dimensional chains (2D) – the dimensions are distributed in one or more parallel planes
- Three-dimensional chains (3D) – the dimensions lie in out-of-parallel planes
This calculation is designed for the tolerance analysis of 2-D and 3-D dimensional chains.

When solving tolerance relations in dimensional chains, two types of problems occur:

  1. Tolerance analysis - direct tasks, control
    Using known limit deviations of all partial components, the limit deviation of the closed component is set. Direct tasks are unambiguous in calculation and are usually used for checking components and assembly units manufactured according to the specific drawing.
  2. Tolerance synthesis - indirect tasks, designing
    Using known limit deviations of a closed component given by the functional demands, limit deviations of partial components are designed. Indirect tasks are solved when designing functional groups and assemblies.

To solve the tolerance relations in dimensional chains, this program uses two calculation methods:
- "Worst Case" method
- "Monte Carlo" method
The choice of method of calculation of tolerances and limit deviations of dimensional chain components affects manufacturing accuracy and assembly interchangeability of components. Therefore, economy of production and operation depends on it.

“Worst Case” Method.

The most often used method, sometimes called the maximum - minimum calculation method. It works on the condition of keeping the required limit deviation of a closed component for any combination of real dimensions of partial components, i.e. also upper and lower limit sizes. This method guarantees full assembly and working interchangeability of components. However, due to the demand of higher accuracy of the closed component, it results in too limited tolerances of partial components and therefore high manufacturing costs. The "Worst Case" method is therefore suitable for calculating dimensional circuits with a small number of components or in case that broader tolerance of the resulting dimension is acceptable. It is most often used in piece or small-lot production.

The purpose of the "Worst Case" method is to find the minimum and maximum values that can be achieved by the resulting dimension for a random combination of real input dimensions. The calculation algorithm is based on a gradual testing of all the existing combinations of different (pre-selected) values of input dimensions. In the case of common dimensional chains, the resulting dimension usually reaches its limit sizes only within a certain combination of limit sizes of input dimensions. In tolerance analysis, for the most often solved tasks we can therefore limit ourselves only to testing the combinations of the minimum and maximum dimensions of partial chain components.

In a small percentage of cases, however, the above-mentioned assumption will not hold true and to find the limit sizes of the resulting dimension, it will also be necessary to perform the calculation for the values of the input dimensions lying inside the tolerance interval. In the program, this fact is handled by the optional choice of number of tested values of input dimensions (division of tolerance interval).

Although the selected calculation algorithm guarantees high success in searching for the limit sizes of the resulting dimension for the "Worst Case" method, it may simultaneously lead to disproportionate demands on the duration of the calculation. The speed of the calculation will depend on the total number of calculation cycles performed which are needed to test all the combinations of input dimensions. The number of these cycles depends on the selected division of tolerance interval and grows in a geometric series with an increasing number of partial components of the dimensional chain. It is mathematically described by this relation:

with:
c ... total of calculation cycles
n ... number of partial components of the dimensional chain
k ... number of tested values of each partial component

From the facts mentioned above, it follows that the "Worst Case" method is designed for solving tolerance relations especially in less complicated dimensional chains with a smaller number of partial components. The practical utilization of the method is limited by the performance of the computer, the number of partial components of the dimensional chain and the selected "precision" of the tolerance interval division.

Hint: The reasonable upper limit of number of performed calculation cycles may be considered as approximately 100,000 cycles, which in case of medium-performance computers represents the duration of the calculation in minutes. If the roughest division of the tolerance interval is selected (calculation for the maximum – minimum dimension), the "Worst Case" method will be applicable for dimensional chains with a maximum of approximately 17 input dimensions. In the event of testing 10 different values for each input dimension, the applicability of the method will decrease to dimensional chains with no more than 5 input dimensions.

"Monte Carlo" Method.

This method belongs to the statistic methods of dimensional chain calculation. Statistic methods are based on the calculus of probability and assume that in a random selection of components during assembly, the limit values of deviations occur only rarely with more partial components simultaneously, as this is the case of combined probability. The probability of the occurrence of limit value of deviations in manufacturing individual dimensions on one component will be similarly small. With a certain, pre-selected risk of rejection of some components, the tolerances of partial components in the dimensional chain can be increased.

The "Monte Carlo" method guarantees only partial assembly interchangeability, with a low percentage of unfavourable cases (spoilage). With respect to larger tolerances of partial dimensions, however, it results in a decrease in manufacturing costs. It is mainly used in mass and large-lot production, where savings in manufacturing costs outbalance increased assembly and operating costs resulting from incomplete assembly interchangeability of components.

The dimensions of closed component show a certain variance from the mean of the tolerance field. The frequency of occurrence of individual dimensions observes the rules of mathematic statistics. The "Monte Carlo" method is meant to analyse this frequency and determine the expected yield of the manufacturing process.

The "Monte Carlo" method is a simulation method. The algorithm is based on the random generation of input dimensions within selected tolerances according to the rated distribution functions. For this generated set of input dimensions, the calculation of the resulting dimensions is subsequently performed. The process is repeated periodically for the pre-defined number of simulations. The simulation will result in a statistic set of data (resulting dimensions) commonly described by the mean size:

and the standard deviation: 

with:
Zi ... value of resulting dimension in the ith cycle of simulation
n ... total number of simulation cycles 

For the evaluation purposes of the frequency of the resulting dimension occurrence, this statistic set is further processed into the form of a histogram.

In the case of the "Monte Carlo" method, the expected production yield will be the decisive index for the evaluation of the quality of the dimensional chain design. The production yield gives the expected rate of products meeting the specification requirements, i.e. products with the resulting closed component dimension within the interval set by the required limit sizes. In common engineering, the manufacturing process is usually considered satisfactorily efficient on the level of 3s, i.e. the process with a minimum yield of 99.73%.

The accuracy (informational value) of the ascertained statistic results will depend on the number of simulations performed. It is evident that the quality of the results increases with an increasing number of performed simulations. An optimum number of simulations will depend on the number of input dimensions, their tolerance value and the total complexity of the dimensional chain. In common practice, a value of approximately 30 to 50,000 performed simulations may be considered a reasonable lower limit in the case of final calculations.

Calculation units, standardized tolerances.

This line is used to switch over the system of units for calculation and to select standardized tolerances.

Units of calculation.

In the list box, select the required system of units for calculation. After switching the units, all values will be automatically recalculated.

Warning: The results of the tolerance analysis in Paragraph [3] will be cleared after the change of units; therefore it is necessary to restart calculation [2.7].

Standardized tolerances.

When defining the dimensional chain in paragraph [1.1], the tolerance is also set for each dimension. To simplify work, the program is provided with a tool for automatic selection of standardized tolerances.

The program includes a set of basic dimensional tolerances according to ISO, or ANSI. With respect to the type of deviation and applied standard, the tolerances are divided into 5 subsets:

Each subset contains a set of list boxes and buttons in the heading of the workbook. Set the required parameters of tolerance, possibly fits (accuracy level, tolerance field, ..) in the list boxes. Using the buttons, insert the dimensions of the required deviation into the appropriate place in the input table - the line with the active cell.

Tolerances according to ISO are defined by the standard in [mm] and are intended for calculation in SI units. Tolerances according to ANSI are defined in [in] and are intended for calculation in Imperial units. In case of use of standardized tolerances defined in units other than those set in the calculation, the deviations of the dimension will be automatically recalculated and rounded. The ISO 2768 standard is meant for the tolerance of angular dimensions.

Warning: The program enables setting standardized tolerance only for one dimension in one step. If more cells in several lines are selected in the input table, the automatic tolerance set-up will not be performed. 
Note: If the selected tolerance is not defined by the standard for the given nominal dimension, zero values of deviation are set in the input table. 
Hint 1: The function of the automatic selection of standardized tolerances may also be used in Table [2.1] to set the required limits of the resulting dimensions.
Hint 2: For more detailed information on standardized tolerances, see workbook "Tolerances and fits".

Process of calculation.

The task of the tolerance analysis of the dimensional chain includes the following steps:

  1. Define the dimensions and tolerances of all dimensional chain partial components in table [1.1].
  2. In table [2.1], define the relations for the calculation describing the individual resulting dimensions.
  3. In paragraph [2.2], select the required calculation method and set its parameters.
  4. Run calculation [2.7].
  5. Check the parameters of the resulting dimensions in paragraph [3].
  6. Save the workbook with a suitable solution under a new name.
Hint: You can find an illustration of the procedure of the tolerance analysis of the dimensional chain for the "Worst Case" method in Example 1, for the "Monte Carlo" method in Example 2.

Definition of input dimensions. [1]

In this paragraph, define the parameters of all partial components of the dimensional chain.

1.1 Table of input dimensions.

This table is used to define the parameters of the individual input dimensions (partial components) of the dimensional chain. Each line of the table belongs to one partial component. The meaning of the table is obvious from the following description:

Column 1 - Name of component is an optional parameter.
Column 2
– Set the switches to select the type of dimension. Implicitly, a longitudinal dimension is expected for all components of a dimensional chain; check the checkbox to set an angular dimension for the selected partial component. The type of dimension set herein affects the function of the automatic selection of standardized tolerances.
Column 3
- Set the nominal dimension of partial component.
Column 4
- Set upper and lower deviation of the dimension. Press the selected button in the heading of the workbook to insert the deviations appropriate to the selected tolerance into the table. For the tolerancing of longitudinal dimensions, all the standards specified herein can be used; tolerances of angular dimensions are standardized in ISO 2768.
Columns 5..7 – In these columns, the minimum, maximum and mean dimension of all partial components is calculated.
Column 8 - In the list box choose the type of theoretical frequency distribution. As a standard, normal distribution, which best matches the real distribution of random process quantities in the outright majority of cases, is used to describe the manufacturing processes.

Diagram of theoretical frequency distribution for normal distribution

Diagram of theoretical frequency distribution for uniform and triangular distribution

Note: This parameter only makes sense for the calculation performed using the "Monte Carlo" method.

Definition of resulting dimensions, tolerance analysis. [2]

In this paragraph, define the parameters of all closed components of the dimensional chain in Table [2.1]. In Paragraph [2.2], select the required calculation method and set its parameters. Run the calculation using the button on Line [2.7].

2.1 Table of resulting dimensions.

This table is used to define the parameters of the individual resulting dimensions (closed components) of the dimensional chain. One line of the table belongs to each dimension. The meaning of the table is obvious from the following description:

Column 1 - Name of component is an optional parameter.

Column 2 – Set the calculation relation used to define the resulting dimension. The formulae used (algorithms) have to observe Microsoft Excel syntax and can contain all mathematic formulae and functions defined by Excel (see Excel help). To mark the input dimensions (partial components) of the dimensional chain, use the symbols consisting of the underscore character and a name of a dimension ("_A", "_B", "_C", ...) in the formulae. Similarly, use the symbols "_Z1", "_Z2", ... for the names of the resulting dimensions. If the calculation relation is defined correctly, the nominal value of the resulting dimension will be calculated in this place in real time. Otherwise, Excel gives the appropriate error value.

Warning: When working with angular dimensions, remember that the goniometric functions of Excel work with radians, whereas in Input Table [1.1], these dimensions are defined in degrees. Therefore, angular dimensions in formulae have to be transformed to radians using the function "RADIANS()".

Column 3, 4 – Define the required limit sizes of the closed component set by the functional demands of the product. The resulting dimension limits specified herein are optional and are only used for the comparison of the achieved results. In the case of "Monte Carlo" calculation method, the permissible limit values are used to set the expected production yield and reject.

2.2 Tolerance analysis.

In this paragraph, select the required calculation method and set its parameters. Run the calculation using the button on Line [2.7]. You can find the complete results of the performed tolerance analysis in Paragraph [3].

2.3 "Worst Case" Method.

The purpose of the "Worst Case" method is to find the minimum and maximum values that can be achieved by the resulting dimension for a random combination of real input dimensions. The calculation algorithm is based on a gradual testing of all the existing combinations of different (pre-selected) values of input dimensions. In the case of common dimensional chains, the resulting dimension usually reaches its limit sizes only within a certain combination of limit sizes of input dimensions. In tolerance analysis, for the most often solved tasks we can therefore limit ourselves only to testing the combinations of the minimum and maximum dimensions of partial chain components.

In a small percentage of cases, however, the above-mentioned assumption will not hold true and to find the limit sizes of the resulting dimension, it will also be necessary to perform the calculation for the values of the input dimensions lying inside the tolerance interval. In the program, this fact is handled by the optional choice of number of tested values of input dimensions (division of tolerance interval). Set the required "accuracy" of the division of the tolerance interval in List Box [2.4].

Although the selected calculation algorithm guarantees high success in searching for the limit sizes of the resulting dimension for the "Worst Case" method, it may simultaneously lead to disproportionate demands on the duration of the calculation. The speed of the calculation will depend on the total number of calculation cycles performed which are needed to test all the combinations of input dimensions. The number of these cycles depends on the selected division of tolerance interval and grows in a geometric series with an increasing number of partial components of the dimensional chain.

From the facts mentioned above, it follows that the "Worst Case" method is designed for solving tolerance relations especially in less complicated dimensional chains with a smaller number of partial components. The practical utilization of the method is limited by the performance of the computer, the number of partial components of the dimensional chain and the selected "precision" of the tolerance interval division.

Hint: The reasonable upper limit of number of performed calculation cycles may be considered as approximately 100,000 cycles, which in case of medium-performance computers represents the duration of the calculation in minutes. If the roughest division of the tolerance interval is selected (calculation for the maximum – minimum dimension), the "Worst Case" method will be applicable for dimensional chains with a maximum of approximately 17 input dimensions. In the event of testing 10 different values for each input dimension, the applicability of the method will decrease to dimensional chains with no more than 5 input dimensions.
Note: The program does not check as to whether all the input dimensions defined in Table [1.1] are really used for the calculation of the resulting dimensions. Therefore, remove all unused dimensions from the table before the start of calculation; it will speed up the calculation significantly.

2.5 "Monte Carlo" Method.

The dimensions of closed component show a certain variance from the mean of the tolerance field. The frequency of occurrence of individual dimensions observes the rules of mathematic statistics. The "Monte Carlo" method is meant to analyse this frequency and determine the expected yield of the manufacturing process.

The "Monte Carlo" Method is a simulation method and belongs to statistic methods. The algorithm is based on the random generation of input dimensions within selected tolerances according to the rated distribution functions. For this generated set of input dimensions, the calculation of the resulting dimensions is subsequently performed. The process is repeated periodically for the pre-defined number of simulations. The simulation will result in a statistic set of data (resulting dimensions) commonly described by the mean size m and the standard deviation s. In the case of the "Monte Carlo" method, the expected production yield will be the decisive index for the evaluation of the quality of the dimensional chain design.

The accuracy (informational value) of the ascertained statistic results will depend on the number of simulations performed. It is evident that the quality of the results increases with an increasing number of performed simulations. An optimum number of simulations will depend on the number of input dimensions, their tolerance value and the total complexity of the dimensional chain. In common practice, a value of approximately 30 to 50,000 performed simulations may be considered a reasonable lower limit in the case of final calculations. Set the required number of simulations in List Box [2.6].

Hint: The selected number of simulations is decisive not only on the quality of the results, but it is also decisive for the duration of the calculation. Therefore, select the number of simulations closer to the lower limit in the initial steps of the dimensional chain designing and use higher values for the final calculations.

Results of tolerance analysis. [3]

After the end of Calculation [2.7], this paragraph shows the results of the tolerance analysis of the above-defined chain. The paragraph is divided into two parts. In Table [3.1], the basic information regarding all the dimensions defined in Table [2.1] is given in the form of a summary. Paragraph [3.2] presents detailed parameters of the selected resulting dimension in numerical and graphical form.

Note: The results of the tolerance analysis specified in this paragraph are only relevant for the current task. If you change Paragraphs [1.1, 2.1], it is necessary to restart Calculation [2.7] to recalculate the results.

3.1 Summary table of resulting dimensions.

This table gives a summary of the basic information of all closed components of the dimensional chain defined in Table [2.1]. In the case of a calculation using the "Worst Case" method, the resulting dimension is described using the minimum and maximum value found. In the case of the "Monte Carlo" method, the statistic set specifying the frequency of occurrence of the resulting dimensions is described in the table by mean value, standard deviation and number of rejects per million components produced.

Note: The results of the tolerance analysis specified in this paragraph are only relevant for the current task. If you change Paragraphs [1.1, 2.1], it is necessary to restart Calculation [2.7] to recalculate the results.

3.2 Detailed description of the resulting dimension.

This paragraph presents the detailed parameters of the selected resulting dimension (closed component) of the dimensional chain using the numerical and graphic forms. In the list box, select the required resulting dimension of which you want to show the parameters.

With respect to the calculation method used, the results of the tolerance analysis are divided into two parts. To assess the quality of the dimensional chain design, the limit sizes that can be achieved by the resulting dimension [3.10, 3.11] are decisive for the "Worst Case" method. In the case of the "Monte Carlo" method the decisive index is given by the expected production yield [3.15] or the number of rejects per million pieces produced [3.16]. The enclosed histogram shows the frequency of occurrence of the individual dimensions.

Note: The results of the tolerance analysis specified in this paragraph are only relevant for the current task. If you change Paragraphs [1.1, 2.1], it is necessary to restart Calculation [2.7] to recalculate the results.

3.15 Productive yield.

The productive yield specifies the expected rate of products meeting the requirements of the specification, i.e. products with a resulting dimension of closed component within the interval given by the required limit sizes. In common engineering, the manufacturing process is usually considered satisfactorily efficient at the level of 3s, i.e. the process with a minimum yield of 99.73%.

3.16 Reject.

Rejection of the manufacturing process gives the expected number of unsuitable products, i.e. products with the resulting dimension of closed component outside the interval given by the required limit sizes. In common engineering, the manufacturing process is usually considered satisfactorily efficient at the level of 3s, i.e. the process with maximum number of 2,700 rejected pieces per million produced.

 3.17, 3.18 Minimum and maximum sizes of the resulting dimension.

The limit sizes specified herein have only an informative character. These limits do not determine the real limit values which can be achieved by the resulting dimension. They only specify the minimum and maximum value of the dimension found during simulation calculation within the selected number of simulations. To find the real limit sizes, it is necessary to use the "Worst Case" calculation method.

Examples. 

To illustrate the problems of the tolerance analysis of dimensional chains, help is completed with practical examples of the use of this calculation:

Example 1 - Tolerance analysis of the dimensional chain using the "Worst Case" method

For the eccentric crank gear of a piston compressor (see the picture), ascertain the:

  1. limit sizes of a piston stroke
  2. piston stroke for a random angle of orientation of the driving component (crankshaft)

Solution of the task.

If we start from the graphic illustration of the dimensional chain

we can describe the rate of the piston stroke in the case of the given kinematical mechanism by the relation of:

where the position of the piston against crankshaft axis X is a kinematical quantity dependent on the angle of orientation of the crankshaft, a. For the eccentric crank gear illustrated in the previous picture, the following relation can be used to set the position of the piston:

The limit positions of the piston against the crankshaft axis are obvious from the following diagram

 

and can be described by these relations:

A. Determining the limit values of a piston stroke.

The solution of the task of the tolerance analysis of the kinematical mechanism can be divided into the following steps:

1) In Table [1.1] we will define all the input dimensions (partial components) of the dimensional chain. 

2) For the individual dimensions we will further set the rated production tolerances. For dimensions B, C and D, the standardized symmetrical tolerances according to ANSI B4.1 in accuracy level 13 are rated. To set them in the table, we can use the function of automatic tolerance selection.

3) In Table [2.1] we will define the parameters of the resulting dimensions (closed components) of the dimensional chain. The calculation relations for the minimum and maximum piston stroke defined in the previous paragraph have to be modified into the form (syntax) required by Excel. Therefore, in the second column of the table, we will set the relation "=_E+_F-_D-((_C+_B)^2-_A^2)^0.5" for the minimum piston stroke and the relation "=_E+_F-_D-((_C-_B)^2-_A^2)^0.5" for the maximum piston stroke.

4) In Line [2.3], check the switch next to the "Worst Case" calculation method. In List Box [2.4], further select the "roughest" division of tolerance interval ("Min. - Max." item) which is sufficient for the given task.

5) Press the button on Line [2.7] to run the calculation (tolerance analysis) of the dimensional chain. The limit values of the stroke can be found in Paragraph [3].

 

B. Determining the piston stroke for a random angle of crankshaft orientation.

The procedure of solving this task will be similar to the previous one and can be divided into the following steps:

1) The input dimension will be defined in Table [1.1] similarly to example A in steps 1) and 2).

2) The angle of crankshaft orientation for which we intend to set the piston stroke will be defined as a constant "Z1" in the first line of Table [2.1]. In the second line of Table "Z2", set the relation for the calculation of the stroke. The above-mentioned calculation relation has to be modified into the form (syntax) required by Excel:

"=_E+_F-_D-(_B*COS(RADIANS(_Z1))+_C*(1-(_B/_C*SIN(RADIANS(_Z1))+_A/_C)^2)^0.5)"

3) In Line [2.3], check the switch next to the "Worst Case" calculation method. In List Box [2.4], further select the "roughest" division of the tolerance interval ("Min. - Max." item).

4) Press the button on Line [2.7] to run the calculation. The parameters of the stroke for the given angle can be found in Paragraph [3].

5) To set the stroke for a different value of orientation angle, it will be enough to change the angle size in Table [2.1] and recalculate the task using Button [2.7].

Example 2 - Tolerance analysis of the dimensional chain using the "Monte Carlo" method

For the component (see the picture) design, the production tolerances of the dimensions are such that the required distance 160±0.3 mm between the centres of orifices is maintained for at least 99.5% of the manufactured components.

Solution of task.

If we start from the graphical illustration of the dimensional chain

 

we can describe the resulting dimension for the given component using this relation:

where the following relations will hold for the auxiliary variables X, Y:

If the task was solved using the traditional "Worst Case" method, it would be necessary to use tolerances at approximately accuracy level 4 for dimensions B, C, D and E so that the required tolerance of the resulting dimension was kept. It is obvious that production with this accuracy would be disproportionately expensive. Therefore, it will be more convenient to use the statistic method of calculation in this case. These methods enable the manufacture of the component with significantly higher tolerances upon the occurrence of a small (pre-determined) percentage of rejects.

Design of the dimensional chain.

The solution of the task of the dimensional chain design can be divided into the following steps:

1) In Table [1.1], define all input dimensions (partial components) of the dimensional chain.

2) Further set the production tolerances for all dimensions. For dimensions with strictly set tolerances, set the rated dimensional deviations in the input table.

For the remaining dimensions, select a tentatively symmetrical tolerance at accuracy level 12.

3) In the list boxes, in the last column of the table, select a normal division with a production process capability level of 3s for all dimensions.

4) In Table [2.1], define the parameters of the resulting dimension (closed component) of the dimensional chain. To facilitate work and increase clear arrangement, we will divide the calculation relation into three parts (see above). We will use the first two lines of the table to define the auxiliary dimensions; the parameters of the searched resulting dimensions will be placed on Line "Z3". The above-mentioned calculation relations have to be modified in the form (syntax) required by Excel. Therefore, set the following text into the appropriate lines of the second column of the table:

Line 1 "Z1" ..... "=_B-_D+(_C-_E)*COS(RADIANS(_A))-_G*SIN(RADIANS(_A))"

Line 2 "Z2" ..... "=(_C-_E)*SIN(RADIANS(_A))+_G*COS(RADIANS(_A))-_F"

Line 3 "Z3" ..... "=(_Z1^2+_Z2^2)^0.5"

5) On line [2.5] check the switch next to the "Monte Carlo" calculation method. In List Box [2.6] further set the required number of simulations. To speed up the designing process, set smaller numbers of simulations in the initial steps of designing.

6) Press the button on Line [2.7] to run the calculation (tolerance analysis) of the dimensional chain. The parameters of the resulting dimension can be found in Paragraph [3].

7) Expected production yield [3.15], better stated number of rejects [3.16] will be the decisive factor for the assessment of the design quality. The task assignment prescribes the maximum permissible number of 5,000 rejects per million pieces produced. The achieved results are higher by order of magnitude; therefore the designed tolerances are not suitable.

For an unsuitable design, the next logical step could be decreasing the sizes of the manufacturing tolerances used. On a closer view of the design, however, we discover that the main problem is not the selected size of tolerances, but rather the improper centring of the design. In the case of an optimally designed dimensional chain the mean dimension [3.13] should be close to the required dimension [3.6].

8) Therefore, in the next step we will adjust the position of the tolerance fields of dimensions B, C, D and E, while maintaining the originally designed values of the tolerances. By repeated adjustments of the deviations of the individual dimensions with a subsequent recalculation of the results, we will gradually achieve the solution

for which the design will be centred

Hint: For the centring of the design it may be more convenient to use the "Worst Case" method, which gives more accurate results and is also significantly faster in cases of a small number of input dimensions.

9) Although the design is already well centred, the required production yield has not yet been achieved. In the next step it will be necessary to decrease the tolerances designed tentatively in Step 2). After selecting the tolerances of dimensions B and C in accuracy level 11 and the centring of design, we will achieve the suitable solution 

which meets the functional requirements set by the task assignment.

Warning: The "Monte Carlo" method belongs to statistical methods; therefore the quality of the achieved results will depend on the number of simulations. With gradual refining of the design, it is therefore appropriate to increase the number of performed simulations [2.6]. In the case of final calculations the number of simulations should not drop below approximately 30,000.

 

Setting calculations, change the language.

Information on setting of calculation parameters and setting of the language can be found in the document "Setting calculations, change the language".

Workbook modifications (calculation).

General information on how to modify and extend calculation workbooks is mentioned in the document "Workbook (calculation) modifications". 

^