Excel offers gear/gearbox optimization software

May 10, 2011 - Excel-Lent software quickly determines optimum product parameters for various industries. With minimal input, the program will calculate the number of teeth in the pinion and gear, DP or Module, face width etc. required to transmit the power, within a few seconds. The calculated data can be exported to the “Analysis” section for complete analysis with clicking the “Transfer Data “ tab on screen. Calculated capacity will be very close to the required power, on the very first try.

A free demo shows how easy it is to design a new gearbox. Non-standard center distance or matching a new gear to an existing gear is as easy as clicking the indicated option. The material tables provided have all the commercially available materials listed, with heat treat and mechanical properties to allow the user to choose any gear material from the list to fit their need.

In all three sections, sample input data are stored for the users to get started. Clicking one of the samples fills the input screen with data. To run the sample click “Calculate”.

The key calculations performed are the AGMA power rating and load calculations, including bending strength geometry factor (J) and pitting resistance geometry factors (I). Output from the software is a single page of data printed in a format that is easy to read and interpret. Other commercial software typically prints five or six pages of information, which may be confusing to most design engineers unless they are gear experts, Chinnusamy further observed.

The users of Excel-Lent need not be familiar with AGMA standards to use this software. Those who are not gear engineers can also benefit from the gear engineering knowledge embedded in the software package.

Excel-Lent contains three sections - design, analysis and gear dimensions. Any of the sections can be used individually to run calculations. On a typical job, according to Excel Gear, hundreds of hours typically spent doing the calculations can be saved.

Excel Gear brings over 50 years of machine tool experience to the design, manufacturing and quality analysis of its various gear, gearbox, fluid bearing, spindle, CNC gimbal head, nutator and special equipment production. ANSYS software for FEA on stress, strain, deflection, as well as modal analysis, time and frequency domain, our Spindle Analysis Program, MATLAB/Simulink,