Here’s is an Excel-based calculator for determining the tolerances required to achieve standard metric hole/shaft fits. Download the calculator here.
As shown in the image above, the user inputs a basic size (Cell B3) and selects the desired fit from the dropdown menu (Cell A3). The upper and lower limits are instantly calculated for both the shaft and bore. The results are displayed in the cells highlighted green.
All calculations are based on the methods described in Shigley’s Mechanical Engineering Design (9th Edition).