Sherline Gear Tooth and Thread Calculators

Joe Martin developed some calculators to help you with gear and thread calculations. They are in the form of Microsoft Excel® spreadsheets. Click on any of the links below to open these programs. (These are zipped files that need to be decompressed, and you will need Microsoft ® Excel required to open and use.)

This Excel calculator will calculate the various dimensions needed to produce a helical gear. If the helical angle is set to “0” it will give you standard spur gear dimensions. I put it together primarily to calculate the amount of A-axis rotation needed to cut a helical gear using CNC. If you enable the Macro the program will generate the g-code that was written for a Sherline cnc mill. It may or may not work with other cnc machines. The Macro was written in 2005 using Excel 2002. On some newer computers it sometimes puts two lines on one line or leaves off the “n” and possibly the first number at the beginning of a line, but you can correct those errors by editing them yourself in Wordpad.

Instructions for use:

  1. When opening the program, select “Enable Macros” if asked.
  2. Enter the appropriate numbers for your desired gear in the pink cells of the chart
  3. Hit the [Enter] key after entering your new numbers
  4. Click on the “Create G-Code” box in the grey instructions cell
  5. Click “OK” in the box that says “End.”
  6. If the g-code window in Wordpad loads behind the Excel window, you may have to minimize the Excel window in order to view it.
  7. Review the G-code to make sure all the lines begin with the letter “n” and the proper number. (Edit in Wordpad if necessary.)

This calculator is similar to the one above except it does not contain the macro needed to calculate helical gears.

Enter a number in the appropriate box and hit [Enter]. Convert weights between kilograms, grams, miligrams, micrograms, pounds and ounces.


More Calculators
  • ONLINE CONVERSIONS! This link from Machine Tools Online offers a number of handy conversion calculators for dimensions, time, money and more, or for dimensional conversions between systems.
  • MORE FREE CALCULATORS, formulas, conversions, cost of living…you name it. See Cleave Books’ Specialist Calculators page at
  • Here’s an interesting site with lots of handy software for the shop that has one major attraction…IT’S ALL FREE! Marvin Klotz has put up a site called Software for People Who Build Things that includes a wealth of programs for your use. It’s worth looking over the list to see if there is anything that could help you solve a problem. I’ll bet you find something you’ll download. It’s cool stuff and the price is right.
  • Frederik Rombach has come up with a neat little program that will help you calculate spindle speed/FPM for a number of material and cutter size combinations for the lathe, mill and drill press. CLICK HERE to download his small (348 kb) .exe program. Select the material from the top menu and enter the known values of cutter size and so on in the boxes. It’s as easy as that. This program will run on any Windows-based computer with a Windows 98 or newer OS.
  • The Machinist’s Calculator is a valuable utility program for Machine Shop Owners, Machinists, CNC Programmers, Metalworkers, Students, Engineers, or anyone else who needs to solve Trigonometry calculations. Also a great utility tool for cad or cad-cam users. It’s available for purchase, but also is offered as a 30-day demo, and it is available on multiple platforms like PC, iOS, Android, and Blackberry!
  • Need a quick way to do trig calculations? See Page Tutor, and just fill in the sides or angles you know and it does the rest.
  • This link to CNC information comes from Robert Adams. His site, CAD2GcodeApps is now offering all DXF to G-code conversion programs in one package for your lathe or mill.