I needs some help matching a sample of shafts to a sample of holes. I've measure all the parts radius' and put them into an excel spreadsheet. The shaft has two radiuses and the holes have two radiuses. I created three worksheets. The first worksheet has the data for the shaft's two radiuses, the second worksheet has the data for the hole's two radius, and the third work sheet is for matching. I would like to know what the best hole and shaft match (a big shaft paired with big hole and vice versa) is for the entire sample and have the serial numbers matched in the Best Fit worksheet. Also, I would like to list the parts that cannot be match (if they cannot be matched without an interference fit).

Best Fit.xlsx


Thanks,
Brett C.