Works with multiple types of gears
EXCEL-LENT can optimize rack and pinion, spur, helical, internal, external, circular pitch gears, bevel and Gleason type spiral bevel gears in English or metric units. Our gear/gear box design software quickly determines product parameters for various applications saving HUNDREDS of engineering hours.
Performs gear design
Our Design program calculates the approximate gears sizes for speed decreasing as well as speed increasing drives based on rotational speed, gear ratio, power, and material. Optional variables include, but are not limited to; face width and center distance for cylindrical gears and cone distance and face width for bevel and spiral bevel gears. Output data from Design can be exported to Analysis to optimize gear capacity based on AGMA standards and reliability factors.
Runs analysis for load/life
The Analysis program can calculate capacities for spur and helical gears-external, internal, and rack and bevel and spiral bevel gears. AGMA does not have a standard for calculating bending fatigue capacity for internal gears but our Excel-lent can calculate bending fatigue capacity of internal gears as well.
Calculates manufacturing inspection data
In addition, EXCEL-LENT’s Dimension program provides you with manufacturing inspection data for your gears. When dimensions of the existing pinion/gear are entered along with the center distance, Excel-Lent will calculate the required dimension for the mating gear/pinion. Non-standard center distance or balancing beam strength or specific sliding is as easy as clicking that option.
You don’t need to be a gear expert to use our program
EXCEL-LENT has an extensive materials library built into the software. Designers do not need metallurgical knowledge to choose gear material and heat treatment. All physical characteristics are automatically extracted from the table and used by the program in accordance with AGMA standards.
Easy to use interface
Choosing to use module or Diametral Pitch gears, setting safety factors, face width, or gear material is as easy as clicking a tab or typing in a few characters. If any required input data fields are missing, the program will prompt the user to supply what is missing.
EXCEL-LENT™ software quickly determines optimum product parameters for various industries; time savings in hundreds of engineering hours being realized
In response to the gear market’s need for optimization software, which has been lacking for many years, EXCEL-LENT™ gear/gearbox design and analysis software has been developed by longtime builder of gears and gearboxes, Excel Gear, Inc. (Roscoe, IL) and written in Visual Basic.Net. This software has been written by engineers who also design and manufacture gears for their own use, according to company president N.K. “Chinn” Chinnusamy.
Mr. Chinnusamy further comments, “Although commercial software has long been available in the gear industry, it has been too expensive or too complicated to be used by engineers without specialized gear design knowledge. Our software is specifically designed with a user-friendly interactive input screen providing defaults and options in accordance with the AGMA 2001 standard (American Gear Manufacturers Association).” The users of Excel-Lent software can easily navigate through the input screens to edit, analyze and produce reports on the optimum gear and gearbox design for various industrial and other applications.
“This software is not designed for any specific industry,” continues Chinnusamy. It can be used for machine tools, heavy materials handling equipment or even the wind turbine industry. For the wind turbine industry, for example, the designer needs a full understanding of all the operating loads on the gear members to arrive at the required power rating.
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.
DESIGN: This section calculates the size of gears, based on minimal input by the user. The user needs to specify only the input rotational speed, gear ratio, power to be transmitted and the material and heat treatments selected from the material tables of all commonly used materials in the industry.
Key values calculated are the diameter and face width of the pinion required to achieve the surface fatigue power rating and optimized DP or module (based on the calculated diameter) required for the bending fatigue power rating. The data are automatically exported to the analysis program for detailed analysis. The results are the power ratings for 5,000 -100,000 hours of B1 life (reliability factor of 1).
If required, other values such as face width or center distance may be entered but Excel Gear recommends leaving the face width and center distance values blank for optimized gear design. Design and analysis programs are used to design one gear stage in sequence on an external or internal spur and helical gear mesh.
ANALYSIS: This program calculates the power rating of a gear set for 5,000, 10,000, 25,000, 50,000 and 100,000 hours of B1 life (reliability factor of 1). Reliability factor of 1, 1.25, or 1.5 can be selected, as required. The user needs to input mesh type (spur, helical, internal and external), pressure angle, helix angle (if applicable), pinion speed, number of teeth in pinion and gear, material (from the list provided in the software), face width, DP or module and quality required. Crown and/or profile shift, if used, can also be entered. The program will calculate the power rating of the gear set and show HP or KW capability along with torque, tangential force and static capacity. Static capacity is based on yield strength and, if bending stress exceeds yield strength at any time, permanent deformation or even tooth breakage may occur. If the results are satisfactory, the user can print the single page results only or, optionally, also print all the AGMA factors used in making the calculations.
Most commercially available gear software will generate five or six pages of output along with required bending and surface fatigue strength of the gear set. The user therefore needs knowledge of metallurgy to select proper material and heat treatment or must consult a metallurgist. By contrast, the EXCEL-LENT software program lists commonly used gear material for the user to select. If the results are not as required, the user can select another material or change other design criteria as required to achieve the desired results. If a special material is desired, its yield, bending and contact stress numbers can be easily entered. If any of the required input data are missing, the program will prompt the user to supply what is missing. Metric or inch units can also be selected with just one click.
DIMENSIONS: In the opinion of the manufacturer, this EXCEL-LENT gear dimension software is the most versatile program available in the market. The program will calculate the manufacturing dimensions for a new pinion and gear or calculate the dimension of a pinion or gear to mate an existing pinion or gear. This can be done for external gears, internal gears or a gear rack. Users need only to enter the type of mesh (spur or helical, internal of external), pressure angle, helix angle(if helical gears), number of teeth in pinion and mating gear, DP or module and the quality of the gears.
The program will then calculate the center distance, dimension over pins, span measurement, form diameter, roll angles and all gear tolerances to match the quality required (AGMA, DIN, or ISO). The program will calculate the helix angle required to match a specified center distance if the user chooses that option.
The program displays plain English error messages when input is questionable or in error. For example, if the center distance is incorrect, the program will flash error messages such as, “Center distance specified is too large/small.”
The program calculates optimized profile shifts for pinion and gear operating at a non-standard center distance, if the operating center distance is specified. If the profile shift required to operate is large and makes the top land narrow, the program will flash warning messages and display the proper profile shift amount to avoid narrow top land.
EXCEL-LENT software further provides users the option to balance beam strength or specific sliding of gear and pinion, if desired. This is a key requirement for wind turbine gears. The program will also calculate gear blank tolerances to achieve the desired quality level, if shaft and bore diameters are entered. Users can switch between inch and metric dimensions with one click.
The bevel/spiral bevel section gives the dimensions of a straight bevel or Gleason type spiral bevel pair. Select English of metric units. Then enter shaft angle, spiral angle (if Gleason spiral bevel), numbers of teeth and one but only one of DP, module, cone distance. Face width may be left blank. If it is left blank, the program will calculate optimum face width.