Standards of limits and fits for mating parts (Part 2)

In the previous post ( Standards of limits and fits for mating parts ), we talked about the definitions of each term related to limits and fits as well as the formulas to determine the values of tolerances. In this post, we're going to convert those information into the real calculation using Microsoft Excel (as usual). As stated earlier, the calculation results may be different from the real values used in general mechanical design handbook. So please use this just for educational purpose only, but use the real table from general limits and fits table if you want to get higher accuracy values. This is the screen shot of excel file to calculate upper deviation and lower deviation according to the selected shaft diameter and tolerance grade. Let's see how to manually calculate the deviation values before using the program. Example: To calculate the upper deviation and lower deviation of a shaft with diameter of 40 mm and tolerance g6. Please refer to previous post ( ...