Excel feed and speeds spreadsheet.
- FixitMike
- Vectric Wizard
- Posts: 2173
- Joined: Sun Apr 17, 2011 5:21 am
- Model of CNC Machine: Shark Pro Plus (retired)
- Location: Burien, WA USA
Excel feed and speeds spreadsheet.
I made the attached spreadsheet to make a reference for setting my router speeds. I believe it is more convenient to use than most charts. It is designed for my machine, which has a maximum feed of 100 inches per minute, and a speed range of 5,000 to 25,000 rpm. It can, of course, be modified to suit your machine.
The file is zipped, because this forum will not accept .xls files.Good judgement comes from experience.
Experience comes from bad judgement.
Experience comes from bad judgement.
- Mike-S
- Vectric Wizard
- Posts: 1123
- Joined: Mon Jun 13, 2011 6:45 am
- Model of CNC Machine: Joe's Hybrid 4x4 (but 3x3)
- Location: Hayesville, NC
Re: Excel feed and speeds spreadsheet.
Thanks, Mike--nice tool to have.
-
- Posts: 28
- Joined: Fri Apr 12, 2013 10:57 am
- Model of CNC Machine: CNC6040
- Location: Morecambe Lancashire
Re: Excel feed and speeds spreadsheet.
I have downloaded it but not had a chance to look at it yet. but here is a big thanks in advance
Ian
Ian
-
- Vectric Wizard
- Posts: 1701
- Joined: Sun Sep 23, 2012 12:14 pm
- Model of CNC Machine: CNC Shark Pro, Probotix Meteor 25" x 50"
Re: Excel feed and speeds spreadsheet.
I know pass depth should change the outcome, but don't see it in your calculations. What pass depth does your table assume?
-
- Vectric Apprentice
- Posts: 62
- Joined: Wed Dec 29, 2010 8:03 pm
- Model of CNC Machine: XYZ Gantry, PMDX motion, Mach3
- Location: Sylvania, Ohio, USA
Re: Excel feed and speeds spreadsheet.
Thanks Mike ! Should come in handy.
- FixitMike
- Vectric Wizard
- Posts: 2173
- Joined: Sun Apr 17, 2011 5:21 am
- Model of CNC Machine: Shark Pro Plus (retired)
- Location: Burien, WA USA
Re: Excel feed and speeds spreadsheet.
The assumed pass depth is equal to the tool diameter.
Amana Tool suggests if it is 2 x Dia, reduce chip load by 25%, and if it is 3 x Diameter reduce chip load by 50%.
Amana Tool suggests if it is 2 x Dia, reduce chip load by 25%, and if it is 3 x Diameter reduce chip load by 50%.
Good judgement comes from experience.
Experience comes from bad judgement.
Experience comes from bad judgement.
- dhellew2
- Vectric Wizard
- Posts: 1322
- Joined: Thu May 22, 2008 10:14 pm
- Model of CNC Machine: Legacy Artisan 72 and AVID CNC Rotary
- Location: Royal City Washington
Re: Excel feed and speeds spreadsheet.
Thanks Mike.
Nothing wrong with pdf's
Dale
Nothing wrong with pdf's
Dale
You will get old if you live long enough!
Young = time, no money
Old = money, no time
Dale
Young = time, no money
Old = money, no time
Dale
- FixitMike
- Vectric Wizard
- Posts: 2173
- Joined: Sun Apr 17, 2011 5:21 am
- Model of CNC Machine: Shark Pro Plus (retired)
- Location: Burien, WA USA
Re: Excel feed and speeds spreadsheet.
Dale: Can PDFs work like a spreadsheet? For example, if you change the inches per minute number, the RPMs will change in the chart to suit.
Good judgement comes from experience.
Experience comes from bad judgement.
Experience comes from bad judgement.
- Ms Wolffie
- Vectric Wizard
- Posts: 2695
- Joined: Sat Mar 31, 2012 10:41 pm
- Model of CNC Machine: Blue Elephant 1325, Shark HD Pro
- Location: Tully Heads, Wet Tropics, Queensland, Australia
Re: Excel feed and speeds spreadsheet.
Yes, provided you have Adobe Acrobat and make it editable.FixitMike wrote:Dale: Can PDFs work like a spreadsheet? For example, if you change the inches per minute number, the RPMs will change in the chart to suit.
Cheers
Wolffie
Whatshammacallit
Cut3D, VCarvePro 6.5, Aspire4, PhotoVCarve, Corel Graphics Suite X6
Wolffie
Whatshammacallit
Cut3D, VCarvePro 6.5, Aspire4, PhotoVCarve, Corel Graphics Suite X6
- FixitMike
- Vectric Wizard
- Posts: 2173
- Joined: Sun Apr 17, 2011 5:21 am
- Model of CNC Machine: Shark Pro Plus (retired)
- Location: Burien, WA USA
Re: Excel feed and speeds spreadsheet.
Wolfie: Do PDFs do the calculations for you? In my spreadsheet, if you change the feed number, all of the speeds are automatically recalculated for you. The cells have the formulas entered.
Good judgement comes from experience.
Experience comes from bad judgement.
Experience comes from bad judgement.
- Adrian
- Vectric Archimage
- Posts: 14546
- Joined: Thu Nov 23, 2006 2:19 pm
- Model of CNC Machine: ShopBot PRS Alpha 96x48
- Location: Surrey, UK
Re: Excel feed and speeds spreadsheet.
You could put it on Google Sheets if it being in Excel format is a problem for people.
-
- Vectric Apprentice
- Posts: 56
- Joined: Sun Jan 25, 2015 10:52 pm
- Model of CNC Machine: Shark Piranha
Re: Excel feed and speeds spreadsheet.
Thanks Mike, I downloaded it and it went right into Numbers (Xcel for us Mac users!) Works great,
Mike
Mike
FixitMike wrote:I made the attached spreadsheet to make a reference for setting my router speeds. I believe it is more convenient to use than most charts. It is designed for my machine, which has a maximum feed of 100 inches per minute, and a speed range of 5,000 to 25,000 rpm. It can, of course, be modified to suit your machine.The file is zipped, because this forum will not accept .xls files.
- Ms Wolffie
- Vectric Wizard
- Posts: 2695
- Joined: Sat Mar 31, 2012 10:41 pm
- Model of CNC Machine: Blue Elephant 1325, Shark HD Pro
- Location: Tully Heads, Wet Tropics, Queensland, Australia
Re: Excel feed and speeds spreadsheet.
If you use AA it will import the spreadsheet exactly as it is formulated including formulas (bad English?)FixitMike wrote:Wolfie: Do PDFs do the calculations for you? In my spreadsheet, if you change the feed number, all of the speeds are automatically recalculated for you. The cells have the formulas entered.
But the PDF must be made open for editing, you cannot have your cake and eat it too
Meaning that people who use it will be able to alter it.
After a rethink, I saw another solution, if people import the spreadsheet, I believe they can post it into Excel. If you place the formulas into a separate cel as an entry, they should be able to copy and paste into the top row.
I will have a look at it tomorrow a bit late here now.
I believe numbers are only in Windows 8.
Still thinking
If you upload the spreadsheet into Dropbox, they can download it as is into Excel
Cheers
Wolffie
Whatshammacallit
Cut3D, VCarvePro 6.5, Aspire4, PhotoVCarve, Corel Graphics Suite X6
Wolffie
Whatshammacallit
Cut3D, VCarvePro 6.5, Aspire4, PhotoVCarve, Corel Graphics Suite X6
- Ms Wolffie
- Vectric Wizard
- Posts: 2695
- Joined: Sat Mar 31, 2012 10:41 pm
- Model of CNC Machine: Blue Elephant 1325, Shark HD Pro
- Location: Tully Heads, Wet Tropics, Queensland, Australia
Re: Excel feed and speeds spreadsheet.
https://www.dropbox.com/s/1q4zm7eodvehe ... r.xls?dl=0
I just put it into my dropbox and all people have to do is tell it to open it in Excel
Very very short, sharp and shiny that dropbox
I just put it into my dropbox and all people have to do is tell it to open it in Excel
Very very short, sharp and shiny that dropbox
Cheers
Wolffie
Whatshammacallit
Cut3D, VCarvePro 6.5, Aspire4, PhotoVCarve, Corel Graphics Suite X6
Wolffie
Whatshammacallit
Cut3D, VCarvePro 6.5, Aspire4, PhotoVCarve, Corel Graphics Suite X6
-
- Vectric Wizard
- Posts: 1479
- Joined: Sun Nov 28, 2010 5:10 pm
- Model of CNC Machine: Home built designs - 3'x4' and 5'x12'
- Location: Eastern NC, USA
Re: Excel feed and speeds spreadsheet.
The file opens into Apache Open Office Calc v4.1 just fine. It's a free download office suite. I also added a text note in my copy of the spreadsheet file that shows your comment about the pass depth.
Thanks Mike,
CarveOne
Thanks Mike,
CarveOne
CarveOne
http://www.carveonecncwoodcraft.com
http://www.carveonecncwoodcraft.com