Gear Calculation Excel Download

Spur Gears are the simplest type of gear. The calculations for spur gears are also simple and they are used as the basisfor the calculations for other types of gears. This section introduces calculation methods of standard spur gears, profileshifted spur gears, and linear racks. The standard spur gear is a non-profile-shifted spur gear.(1) Standard Spur Gear

Figure 4.1 shows the meshing of standard spur gears. The meshing of standard spur gears means the reference circlesof two gears contact and roll with each other. The calculation formulas are in Table 4.1.

Fig. 4.1 The Meshing of Standard Spur Gears

( =20, z1=12, z2=24, x1=x2=0 )

NOTE 1 : The subscripts 1 and 2 of z1 and z2 denote pinion and gearAll calculated values in Table 4.1 are based upon given module m and number of teeth (z1 and z2). If instead, the modulem, center distance a and speed ratio i are given, then the number of teeth, z1 and z2, would be calculated using theformulas as shown in Table 4.2.

Gear Calculation Excel Download

Download File 🔥 https://urlgoal.com/2y3LtK 🔥

Note, that the number of teeth will probably not be integer values when using the formulas in Table 4.2. In this case,it will be necessary to resort to profile shifting or to employ helical gears to obtain as near a transmission ratioas possible.(2) Profile Shifted Spur Gear

Figure 4.2 shows the meshing of a pair of profile shifted gears. The key items in profile shifted gears are the operating(working) pitch diameters (dw) and the working (operating) pressure angle (w). These values are obtainable from themodified center distance and the following formulas :In the meshing of profile shifted gears, it is the operating pitch circle that is in contact and roll on each other thatportrays gear action. Table 4.3 presents the calculations where the profile shift coefficient has been set at x1 and x2 at the beginning. This calculation is based on the idea that the amount of the tip and root clearance should be 0.25m.

Fig. 4.2 The Meshing of Profile Shifted Gears

( =20, z1=12, z2=24, x1=+0.6, x2=+0.36 )

(3) Rack and Spur Gear

Table 4.5 presents the method for calculating the mesh of a rack and spur gear.

Figure 4.3 (1) shows the the meshing of standard gear and a rack. In this mesh, the reference circle of the gear touchesthe pitch line of the rack.Figure 4.3 (2) shows a profile shifted spur gear, with positive correction xm, meshed with a rack. The spur gear hasa larger pitch radius than standard, by the amount xm. Also, the pitch line of the rack has shifted outward by the amount xm.

Table 4.5 presents the calculation of a meshed profile shifted spur gear and rack. If the profile shift coefficient x1 is 0, then it is the case of a standard gear meshed with the rack.

As there has been a lot of questions surrounding stat contribution to damage lately, and specifically for stat weights, I present to you a stat-weight-less calculation tool, that you can use to compare Gear Sets.

In this article, we discuss how to calculate the inverse of involute angles without any programming by Excel Circular Referencing & also a simple VB Program to show how excel performs this task internally.

In Microsoft Excel when a formula refers back to its own cell, either directly or indirectly, it creates a circular reference. By default, iterative calculations are turned off in Microsoft Office Excel. You can enable iterative calculations as described below.

Equation (4) does yield correct results considering the re-calculation of sevolute but the result is negative value for and we are looking for a positive value. For our calculation, negative values are incorrect as Involute does not exist for negative pressure angle.

Equation (3) can be used for calculation of fillet radius of internal gears as we never enter the value of sevolute less than 1.0035 in this case and equation (5) can be used for the calculation of fillet radius for external gears as it can give correct results starting from 0 degree to 65 degrees instantly.

A lot of other gear calculations, such as tip chamfers, finding minimum pin diameter that fits a particular external or internal gear, protuberance can be calculated using Excel circular referencing but one should know how to form the correct equation for it and should also know the limits of input for which the equation yields correct results.

Excel-LentTM software from longtime builder of gears and gearboxes, quickly determines optimum product parameters for various industries; time savings in hundreds of engineering hours being realized. Excel-lent software is on sale through the website.

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 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, AutoCAD/SolidWorks/CADAM and other programs are all utilized to affect the best solutions to customer requirements. Excel also builds two-axis CNC gimbal heads with 20,000 RPM motorized spindle, 15,000 RPM cartridge type spindle assemblies and CNC rotary tables for major machine tool companies. Our high-accuracy gear grinding equipment produces to AGMA 15 (DIN 2) tolerances for quality that meets or exceeds the increasing customer demands for high-speed and high power transmission with smooth, quiet operation. Recently, the company has entered the emerging wind turbine market to provide various gears and gearbox components, as well as extensive maintenance and system performance engineering assistance.

The sixteen gearboxes, filled with environmentally-friendly biodegradable canola (vegetable) oil and protected with special Teflon bearing seals, are used in pairs at each of eight stations to provide the sequential vibration to the massive assembly that holds the piling above the insertion tube. As the piling vibrates, it literally shakes its way into position. (This is shown in the video.)

Another aspect of this immense job was the need to minimize backlash for noise and distortion. The offset bearing calculations needed the highest accuracy possible and, owing to the very nature of spiral bevel gearing, this was an immense math and machining challenge. Excel maintains a battery of the largest gearmaking machines in the industry, as its customer base comprises heavy materials handling equipment, naval vessel gun turret builders, barge off-loading crane and other manufacturers where huge gears and precision motion are both required.

Despite the timing of the job, Excel Gear shipped the order ahead of schedule by several days, satisfying the customer completely. Chinn acknowledges several suppliers who greatly assisted Excel in the completion of this job. Youngberg Industries of Belvidere, Illinois performed some of the heavy fabrications needed, while Reliance Gear of Addison, Illinois did spiral bevel gearwork, a highly specialized service, and General Surface Hardening in Chicago handled the carburizing and hardening in the heat treat processes on the 4320 alloy steels used. Finally, Chuck Schultz of Beyta Gear Surface in Winfield, Illinois did some consulting and spec writing on the job.

For more information on this success, please contact: EXCEL GEAR, INC. 11865 Main Street Roscoe, IL 61073 Phone: 815-623-3414 Fax: 815-623-3314 Web: www.excelgear.com Email: sales@excelgear.com N.K. Chinnusamy, President

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. 2351a5e196