587,193 active members*
2,410 visitors online*
Register for free
Login
IndustryArena Forum > Community Club House > Gear ratio calculation spreadsheet
Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2003
    Posts
    453

    Gear ratio calculation spreadsheet

    Hi,
    I made an excell spreadsheet for experimenting with gear ratios. What I'm trying to do is match as closely as possible my X axis which is a belt and pulley system to my Y and Z axies which are ballscrews. I think it's unlikely that I can get a perfect match but with the ratios I've worked out the theoretical rapid speed on y and z is 104.987 ipm and x is 104.900 ipm. I understand Mach2 has a ratio compensation input which I hope will make the axies proportional to each other. If anyone is intersted in looking over my spreadsheet (please check my formulas, I'm not a good mathamatician) it's here for download. If anyone has any comments or suggestions I'm all ears.
    Thanks
    Splint
    Attached Files Attached Files

Similar Threads

  1. Back EMF calculation?
    By OCNC in forum Stepper Motors / Drives
    Replies: 13
    Last Post: 05-28-2014, 02:41 PM
  2. High Speed Spreadsheet
    By MachineSMM in forum Hard / High Speed Machining
    Replies: 17
    Last Post: 05-21-2014, 01:57 AM
  3. Basic Bevel Gear - Milling a valley for gear teeth
    By ngr1 in forum Uncategorised CAM Discussion
    Replies: 10
    Last Post: 04-05-2012, 03:55 PM
  4. resistor calculation need help
    By mike10 in forum Stepper Motors / Drives
    Replies: 2
    Last Post: 03-30-2005, 04:21 AM
  5. Metric Change Gear Combinations by J.W. Early Excel Spreadsheet
    By cncadmin in forum DNC Problems and Solutions
    Replies: 0
    Last Post: 05-26-2003, 09:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •