Resource icon

Complete Gear Cutting and Dividing Plate Spreadsheet Version 7

No permission to download
This Spreadsheet will allow calculating any gear indexing plate set up. It will calculate all Gear dimensions. It is a spreadsheet on 4 pages. The 3rd page will allow calculating number of teeth up to 127 (Logan Lathe max usage) with any indexing plate or rotary table. Enter the number of turns for 360 of your table, I have included standard indexing plate numbers but you may change. Enter number of teeth, DP and the program scans all the plate numbers and gives the minimum error plate number and how many turns and holes by tooth to eliminate cumulative error.
Author
weston1968
Downloads
139
Views
1,338
First release
Last update
Rating
4.00 star(s) 1 ratings

More downloads from weston1968

Latest updates

  1. Minor change

    I was cutting a gear and had the number of holes wrong. I put in a picture showing how to use...
  2. Fixed Depth of Cut

    The depth of cut was too deep and has been fixed.
  3. converted degrees from decimal to degrees, minutes, seconds

    I have converted the inexact plate sheet from decimal to degrees, minutes, seconds. This will...
  4. Clean Up and Easier to Read

    I made the third sheet easier to read and made the first sheet easier to find.
  5. Added both tooth width and position error for cutting when teeth don't work out exactly

    I have added both tooth position, and tooth width error in selecting the best dividing plate...
  6. Fixed a bug on Page3 of spreadsheet

    I had total number of holes on Page 3. Should have had the remainder holes after turns.

Latest reviews

Works well but all cells not requiring user input are locked so any notes or other calculations i need to do have to be done in separate sheet. this is a very good item.
Back
Top