Acorn Wizard Data Excel Spreadsheet

All things related to the Centroid Acorn CNC Controller

Moderator: cnckeith

Post Reply
762x51
Posts: 119
Joined: Wed Aug 02, 2017 8:40 pm
Acorn CNC Controller: Yes
Allin1DC CNC Controller: No
Oak CNC controller: No
CNC Control System Serial Number: B0D5CC56DD75-0605170063 , 985DAD4295CF-0928170127 , 38D2694E4703-1222170401
DC3IOB: No
CNC11: No
CPU10 or CPU7: No
Location: Near Guilford College, Greensboro, NC
Contact:

Acorn Wizard Data Excel Spreadsheet

Post 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 212 times
Last edited by 762x51 on Tue Nov 21, 2017 10:09 pm, edited 3 times in total.
DICKEYBIRD
Posts: 536
Joined: Sat Jul 08, 2017 7:38 am
Acorn CNC Controller: Yes
Allin1DC CNC Controller: No
Oak CNC controller: No
CNC Control System Serial Number: n/a yet
DC3IOB: No
CNC11: No
CPU10 or CPU7: No
Location: Collierville, TN USA

Re: Acorn Wizard Data Excel Spreadsheet

Post 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
Milton in Collierville, TN

"Accuracy is the sum total of your compensating mistakes."
cnckeith
Posts: 7164
Joined: Wed Mar 03, 2010 4:23 pm
Acorn CNC Controller: Yes
Allin1DC CNC Controller: Yes
Oak CNC controller: Yes
CNC Control System Serial Number: none
DC3IOB: Yes
CNC11: Yes
CPU10 or CPU7: Yes
Contact:

Re: Acorn Wizard Data Excel Spreadsheet

Post 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
Need support? READ THIS POST first. http://centroidcncforum.com/viewtopic.php?f=60&t=1043
All Acorn Documentation is located here: viewtopic.php?f=60&t=3397
Answers to common questions: viewforum.php?f=63
and here viewforum.php?f=61
Gear we use but don't sell. https://www.centroidcnc.com/centroid_di ... _gear.html
762x51
Posts: 119
Joined: Wed Aug 02, 2017 8:40 pm
Acorn CNC Controller: Yes
Allin1DC CNC Controller: No
Oak CNC controller: No
CNC Control System Serial Number: B0D5CC56DD75-0605170063 , 985DAD4295CF-0928170127 , 38D2694E4703-1222170401
DC3IOB: No
CNC11: No
CPU10 or CPU7: No
Location: Near Guilford College, Greensboro, NC
Contact:

Re: Acorn Wizard Data Excel Spreadsheet

Post 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
Gary Campbell
Posts: 2164
Joined: Sat Nov 18, 2017 2:32 pm
Acorn CNC Controller: Yes
Allin1DC CNC Controller: No
Oak CNC controller: No
CNC Control System Serial Number: Acorn 238
DC3IOB: No
CNC12: Yes
CNC11: No
CPU10 or CPU7: No
Location: Marquette, MI
Contact:

Re: Acorn Wizard Data Excel Spreadsheet

Post 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.
Attachments
GCnC Drive Calculator.xlsx
(14.7 KiB) Downloaded 211 times
GCnC Control
CNC Control & Retrofits
https://www.youtube.com/user/Islaww1/videos
762x51
Posts: 119
Joined: Wed Aug 02, 2017 8:40 pm
Acorn CNC Controller: Yes
Allin1DC CNC Controller: No
Oak CNC controller: No
CNC Control System Serial Number: B0D5CC56DD75-0605170063 , 985DAD4295CF-0928170127 , 38D2694E4703-1222170401
DC3IOB: No
CNC11: No
CPU10 or CPU7: No
Location: Near Guilford College, Greensboro, NC
Contact:

Re: Acorn Wizard Data Excel Spreadsheet

Post 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
Post Reply