Automatic processing method for ball bearing contact stress calculation

The invention discloses an automatic processing method for ball bearing contact stress calculation, a VBA language and Excel form programming are adopted to form a user interface and an execution control, the user interface comprises an input box and an output box which are matched with the execution control, and the input box provides a relevant parameter input form; the execution control comprises an algorithm for calculating normal stress and drawing a three-dimensional diagram corresponding to the normal stress, and the calculation process comprises the following steps: inputting ball bearing parameters; calculating a comprehensive curvature; carrying out numerical integration and ellipse solving integration; solving the transcendental equation to obtain an ellipticity; calculating the half width of a contact ellipse; calculating the maximum stress and the average stress; judging whether a three-dimensional diagram needs to be constructed or not, if so, continuing the next step, and otherwise, outputting