Page 1 of 1

Acorn Wizard Data Excel Spreadsheet

Posted: Fri Nov 17, 2017 12:39 am
by 762x51
Working with Keith and Marty we have modified the spreadsheet that was found on the MACH forum so it would give you the info you need to enter into the Wizard's Axis Configuration page. I hope you find this helpful when setting up your Acorn.

Orin

NOTE

Working together, Marty and I have gotten the spreadsheet corrected.
AcornStepperCalc-Rev2.xlsx
(93.21 KiB) Downloaded 213 times

Re: Acorn Wizard Data Excel Spreadsheet

Posted: Fri Nov 17, 2017 10:36 am
by DICKEYBIRD
Wow thanks Orin, that's perfect! Wish I would've had that a couple weeks ago. I finally came up with the correct number back then but hate to admit how long it took me to wrap my head around it. This will make it a no-brainer for everyone. :D

Re: Acorn Wizard Data Excel Spreadsheet

Posted: Fri Nov 17, 2017 10:53 am
by cnckeith
for the rotary gear reduction section. please add a calculator for a rotary table since they are often worm drives.. the spec on the rotary table is often is a reduction value. like 90:1 or 180:1 etc..
here is how you calculate overall turns ratio for a rotary axis...

for all rotary axes on a Centroid the "turns ratio" is in: "Revolutions per Degree".

rev/deg = how many rev's of the servo motor yields 1 degree of rotation on the rotary axis

here are some example calculations..

so if the c axis motor turns one revolution and the spindle turns one revolution then set the turns ratio to 1/360 = .0027777

if the c axis motor turns 2 revolutions to the spindles 1 revolution , set the turns ratio to 2/360 = .0055555

if the c axis motor turns 20 times to the spindles 1 revolution, set the turns ratio to 20/360 = .0555555

if the c axis motor turns 180 times to the spindles 1 revolution, set the turns ratio to 180/360 = .5

Re: Acorn Wizard Data Excel Spreadsheet

Posted: Tue Nov 21, 2017 10:11 pm
by 762x51
Using Keith's information and Marty's knowledge, Marty and I have gotten the spreadsheet corrected.

Orin
AcornStepperCalc-Rev2.xlsx
(93.21 KiB) Downloaded 231 times

Re: Acorn Wizard Data Excel Spreadsheet

Posted: Sat Jan 06, 2018 5:51 pm
by Gary Campbell
Since Acorn is going to have a number of router specific changes coming in the future, and with all due respect to Orin, Marty and Keith, I thought I would post a portion of my drive mechanics calculator here to assist those that may need calculations for rack and pinion and gear (belt) reduction units that are common on larger machines. If we need more, I have them.

Hopefully this is clear enough to use for most. General instructions are to enter your data into the dark blue cells.
For inch pitch lead screws (TPI) enter them as 1/16 for 16 threads per inch
Use the drop down box to select INCH or MM for the screw pitch.

Re: Acorn Wizard Data Excel Spreadsheet

Posted: Sat Jan 06, 2018 5:58 pm
by 762x51
Wow Gary - Now that's one heck of a helpful spreadsheet that sure will help a lot of folks trying to figure out how to setup their system.
Thanks for posting the spreadsheet.

Orin