Optimization of cutting conditions in Microsoft Excel

Modern stage of scientific and technological progress is characterized by a wide introducing of computer techniques. They allow one to increase efficiency and to reduce the time-for work in calculating the cutting conditions, standard time for processing, analysis of cutting processes, designing technological processes, etc. Computer introducing into manufacture facilitates to reducing costs and increase of designing quality. Calculation of optimal parameters of technological processes or operations with the specified structure from the point of view of a certain criterion is called parametrical optimization. Following optimization calculations the graphical image of linear restrictions and purposeful function are optimal values of the rotation frequency n and feeding s and their integrated values are displayed.