I've seen one mechanics professor at university making shaft vibration simulations in ms access with vba. After this, making calculations in excel is pretty nice, I sometimes use excel to generate text conversions. While I know several programming languages, it is sometimes way faster to do it in excel than to make a custom simple script in python especially when you only need to do it once.
Excel is more like CAM, Computer Aided Manufacturing. Did computer generate some gcode from parameters? If yes, it was CAM. Doesn't matter if it was excel or something other. Ms Paint would be actual CAD here, computer aided design. If it gives you some model to visualise and input parameters into your CAM tool, it's a CAD.
Very interesting video, I used to work at a Ballscrew factory for 38 years in Coventry it closed in 2005. In the early 1970s when it was owned by the Americans we made ballscrews for the tracking systems that brought the Apollo 13 safety home. Anyway I think you did very well with your ballscrew well done, 🇬🇧 from Coventry in UK.
Yes you are. I myself often try to sound like Bach while practicing my cello. To do so would be a victory. It took most people a long time to realize that learning as humans was always about watching the hands and listening to the voice. You go. Imitation is the most sincere compliment.
Stupendous video, your clarity of presentation and transitions make it look effortless. My favorite was the angled milling vise reveal, such an intuitive way to represent the rotation
Nice work; a curious mix of clever CNC solutions, and very labour-intensive processes. My heart sank when I saw the excel spreadsheet. Subscribed to see more of this! 😄
Great idea. Experimenting is the best part of Engineering. I always part off this sort of thing in the Lathe with a stout tool. It doesn't matter if there's an intermittent cut on a decent lathe. Another useful idea is to use the CNC mill to machine a form tool from Gauge Plate which is then hardened. I have a standard 3D model that I use to project the desired profile onto an angled plane. The profile is cut with the stock at an angle, so that when it's used flat, there's clearance on the front and the shape is then correct.
Interesting video, I think you were quite brave to attempt this, results are pretty blooming good but I have to agree that a factory made unit will be better. A very satisfying thing to do well done indeed!
I honestly and seriously need to follow and make a copy of what you have done... I do probably do it at 1/4" and particularly need it to use it on the X axis of a CNC lathe... "Now seriously don't know how I'll be making the nut...Because I do not have a CNC Mill... probably would need that large nut to be a bit smaller as well! I really enjoyed your work. Thank you for taking the time to share it.
The algorithm isn't as powerful as you may think. As an example, it only just showed me this channel, dispite (If this video's a typical example of your content) it being 100% the kind of channel I subscribe to within seconds of finishing the first of it's videos I see........ Which is what I did here BTW. 😏 Outstanding machine work, amusing graphics and visual gags, and very informative.
You should try making hydrostatic screws! Pump a few hundred psi oil or water into an otherwise normal lead-nut and get ballscrew-like performance in a nice low profile package. You'd need sleeves over the screw to capture and recirculate the fluid but your design already has that.
This was so amazing god damn! I love those little bits that I haven't even thought of before like the cross section of the channels. I always just took ballscrews and linear rails for granted but this changed my POV a bit
Nice work and clever approach to making the nut. One thing I could think of to make whole thing more precise would be to fabricate the nut with even more reduced contact surfaces and make them slightly too small to accommodate the balls. Then run the screw back and forth with shims, thick enough enough allow for movement under force, between the two halves of the nut . Repeat, reducing the shim thickness by small increments till the channel the balls pass through has been burnished to match the screw exactly. Adding some polishing paste instead of grease could add an abrasive element to the fitting THis would be obviously overkill for this application, but might be one way to make the nut fit the screw very precisely and also work harden the contact areas with the bearings. Though it would be limited by how accurate you can make the screw. Any defects in the screw could transfer to the nut in this way, though it could potentially also improve the screw as well.
I did actually think it would come out slightly undersize and need some sort of wearing in, but being brass it came out the exact dimensions I machined it to.
Hi Alex, good to hear from you, I hope you're doing well! This was really quite a simple toolpath and could actually have been written in notepad using helical interpolation moves (G02/03), but excel allows more flexibility and easier modification. Excel is also really good for modifying existing gcode.
You are smart AF!!! Respect!!! Why? Cuz you made nut from two halves. If it gets worn a bit, you just grind mating planes a bit. Then you can tighten your nut and change clearance using different washers between half nuts. Maybe it is not ideal and can cog somehow but I think it will be good enough.
Now it's a half-nut. In fact, it's two half nuts next to each other. One is a mirror image of the other, so that when flipped over, they make a whole nut. That's nuts...
A year ago I made a toolpath generator for a DIY CNC lathe, I made it with Javascript. and Today I saw your video which uses Excel to generate G-Code cycles. Oh my God, I feel like I have friends who think the same way🤣🤣
Have you considered non-recirculating nuts? They'd be like helical drawer slides. You'd need a cage to hold the balls against the screw but overall the actuator could be slimmer and have the same travel if the cage is half the length of the screw + half the length of the nut.
Both the brass and the steel will continuously work harden with use. You might want to rig a drive to do a few thousand full length cycles overnight (under load) to even out the hardness along the full stroke. Awsome job !!
Arrrgghh.! Machines making machines….we’re doomed. Great project. Do you have a video about your workshop machines? I’ve been sat in a drawing office for 20’ish years and want to get back to my apprenticeship days making chips, so it’s interesting to see what machinery people actually use in their workshops/hobby shops.
Yes, I seem to spend most of my spare time making machines to make other machines! I have quite a few videos about workshop machines I've built from scratch, and a few about machines I've bought and repaired/modified.
First time viewer of the channel. I was SO excited to find another machining channel with quality content... and then I saw you upload intervals. Sigh. I guess you simply can't expect quality content to be mass producible. Subbed and having a crack at the Terminator series. It will be like Project Binky, won't it? :P
Welcome aboard! I wish I could spend more time on my projects, but this is just a hobby after all and life gets in the way. There was a big gap between videos recently, but I promise I'll try and upload more regularly in future. Really I will.
I found this as I am Not familiar with all this stuff. But i bought a defekt Vice which has exactly such ball Channel to hold the screw of the vice. I bought IT to try to repair IT. The defect is: with Balls INSIDE the screw can Not be driven. If Balls are Out the vice works but could Not be fastened. So i watched your Video to learn more about the technique behind. And you gave me the Idea to try First smaller Balls. I think Something ist wrong with the Channel. I can Put a Pipe Cleaner through it, so there IS No piece of Metal INSIDE or some other dirt. Maybe the Gothic Arc is Missing. I have No milling or other Machines, only a drill Press. I am looking Forward to get IT run now. Thanks a Lot for Sharing this technique and for the nice speech without music in Background . This makes it better to understand - English ist my 2nd language and often i do Not understand the speech due to Background music but could understand the meaning.
Yes, I think new balls is the first thing I'd try, they might have small imperfections causing them to jam against each other. Another thing you can do is alternate a smaller ball in between each regular one, this allows all the balls to rotate without sliding on each other since the smaller balls can rotate backwards like an idler between the bigger ones.
I generated nose radius compensation by hand recently to turn on a CNC-mill and felt pretty good about myself, but Excel just isn't beatable. I do actually think there's an over reliance on CAM in the hobby-scene, I work in production and write my programs on the machine. If you don't have 3D contours it's not that hard to do.
If you made your screw and nut out of materials that work harden, I'm thinking stainless, then use shims to adjust the split nut... do you think such ball formed races would be uniform enough for a smooth high load ballscrew? I am enthralled by your innovative approach, moar plz!
I did think I might have to adjust the nut somehow to get it to work, but it worked ok. Brass does work harden but it's still relatively soft. I think to wear in/form either the nut or screw it would have to be made from material a lot softer then the balls. There are definitely a lot of possible variations on this approach.
@@AndysMachines You should try to get slightly bigger balls, it would reduce backlash with no further machining needed. As you have 0,1mm backlash currently you should go with balls 0,05mm bigger. I have repaired worn out ball nut this way - by ordering balls 0,02mm bigger, as it was too expensive for customer to order a new screw/nut set and backlash was only slightly too big - it will work for few more years until it crosses the line again. I would also smooth the screw a little, using some 400 grit sandpaper wrapped around something soft like electric wire or large oring to conform to screw shape.
Love the video! I think you should raise the volume of the talking or lower the machines because I would turn up/down the volume when watching. It's personal preference though.
I actually try hard to balance the levels, but it also depends what you are listening to it on. Are you using a phone? My phone, computer, and TV all sound different. RUclips does have a 'stable volume' switch, I turn it off as I find it amplifies any background noise, but you might try that.
what about those 8mm leadscrews 3d printers use, they have a 8mm pitch and can be backdriven and are easy to get spare parts for. what made you discard those as an option?
Yes, I have one of those on my 3D printer. It probably would have worked, but looks a bit weak. The reason these are backdrivable is because of the very high pitch/diameter ratio, though they are not as efficient as a ballscrew and that coupled with the higher pitch would have meant I'd need either a more powerful (larger) motor or higher gear reduction giving slower movement.
Doing CAM in Excel is cursed, great job!
I'm still in shock.
I'm almost in disbelief.
It is Excel Assisted Machining.
The very definition of brute force.
I've seen one mechanics professor at university making shaft vibration simulations in ms access with vba. After this, making calculations in excel is pretty nice, I sometimes use excel to generate text conversions. While I know several programming languages, it is sometimes way faster to do it in excel than to make a custom simple script in python especially when you only need to do it once.
-what CAD do you use?
-excel
holy shit bro thats some serious flex
I use Ms Paint.
Excel is more like CAM, Computer Aided Manufacturing. Did computer generate some gcode from parameters? If yes, it was CAM. Doesn't matter if it was excel or something other. Ms Paint would be actual CAD here, computer aided design. If it gives you some model to visualise and input parameters into your CAM tool, it's a CAD.
7:39
Watching a guy make a ball screw and he just casually drops that he's a wizard
I know, right? Holy smokes! I couldn't believe that bit.
I am impressed and horrified by the excel cam
Likewise. Guy is wizard
Very interesting video, I used to work at a Ballscrew factory for 38 years in Coventry it closed in 2005.
In the early 1970s when it was owned by the Americans we made ballscrews for the tracking systems that brought the Apollo 13 safety home. Anyway I think you did very well with your ballscrew well done, 🇬🇧 from Coventry in UK.
Thanks for commenting! It's a shame most manufacturing like that in this country has closed down now.
No more.
Fully 75% of Americans can’t calculate 2/3 + 3/4.
The amount of knowledge you gained on ball screws was priceless, thanks for passing it along to us so we could learn along with you!
Yes, I learnt from this too.
It seems that I have stumbled on to the British version of "This Old Tony"
As soon as the gags kicked in I immediately started hoping Andy and Tony get each other in the annual Maker Secret Santa
I am not worthy!
And --the Slick King-- I mean _ClickSpring_ too!
Yes you are. I myself often try to sound like Bach while practicing my cello. To do so would be a victory. It took most people a long time to realize that learning as humans was always about watching the hands and listening to the voice. You go. Imitation is the most sincere compliment.
Stupendous video, your clarity of presentation and transitions make it look effortless. My favorite was the angled milling vise reveal, such an intuitive way to represent the rotation
Thank you very much!
@@AndysMachines Seriously though, your subtle animations are excellent at describing what you're talking about.
Nice work; a curious mix of clever CNC solutions, and very labour-intensive processes. My heart sank when I saw the excel spreadsheet.
Subscribed to see more of this! 😄
The best video ever! You made my night! Now I just have to figure out where to get this new “Excel”. 🤣
Generating g-code with excel? What a badass.
8:00 THIS GOTTA BE A JOKE
Superb technical content, video production and humor. A true machinist's trifecta!! Thank you.
Cheers,
F.C.
I don't know much about machining but I love your dry narration with the hilarious comic relief in the video! 🤣
That’s some fine problem solving and utilization of what’s available and convenient.
Very enjoyable. 👍
That are the type of videos I come for to YT. Strange projects that I definitely won't do on my own. Liked. Subscribed.
Your video editing and modeling work is extremely good.
Agreed! I liked the little visual representations of a spoken word or a concept!
👍 for style and clarity 🙂
This channel is a real life terminator subplot and I’m absolutely here for it.
well done, truly!
So glad I found your channel. Amazing work!
Subscribed. From a fellow machinist, great work. You opened my mind to the fact that math and digital readouts can do amazing things.
Thanks!
What a blast of a video! Engineering, problem solving, reasoning, machining and humour😂! Excellent🎉
Great job; this is rare tool build. We shared this video on our homemade tool forum last week 😎
This guys comedy and skill are both great I laughed and learned, would certainly say test to a second date haha
Great idea. Experimenting is the best part of Engineering. I always part off this sort of thing in the Lathe with a stout tool. It doesn't matter if there's an intermittent cut on a decent lathe.
Another useful idea is to use the CNC mill to machine a form tool from Gauge Plate which is then hardened. I have a standard 3D model that I use to project the desired profile onto an angled plane. The profile is cut with the stock at an angle, so that when it's used flat, there's clearance on the front and the shape is then correct.
What a marvellous exercise, 🙏 thanks for sharing, after having seen this I need to have a go myself even if purely on an academic level
Balls,nuts,screws,holes...
Drilling. 😂
but is he a Pro(fessional)
Rigid tool @@lawrencemanning
Shafts
Flange
Genius, loved it! Also excel gcodes is next level insanity, well done.
Interesting video, I think you were quite brave to attempt this, results are pretty blooming good but I have to agree that a factory made unit will be better. A very satisfying thing to do well done indeed!
I honestly and seriously need to follow and make a copy of what you have done... I do probably do it at 1/4" and particularly need it to use it on the X axis of a CNC lathe... "Now seriously don't know how I'll be making the nut...Because I do not have a CNC Mill... probably would need that large nut to be a bit smaller as well! I really enjoyed your work. Thank you for taking the time to share it.
The algorithm isn't as powerful as you may think. As an example, it only just showed me this channel, dispite (If this video's a typical example of your content) it being 100% the kind of channel I subscribe to within seconds of finishing the first of it's videos I see........ Which is what I did here BTW. 😏
Outstanding machine work, amusing graphics and visual gags, and very informative.
Well presented, relevant topic and a pleasure to watch.
Thank you.
You should try making hydrostatic screws! Pump a few hundred psi oil or water into an otherwise normal lead-nut and get ballscrew-like performance in a nice low profile package.
You'd need sleeves over the screw to capture and recirculate the fluid but your design already has that.
Great solution to this problem 😊 love the sound effects too
This was so amazing god damn! I love those little bits that I haven't even thought of before like the cross section of the channels. I always just took ballscrews and linear rails for granted but this changed my POV a bit
Impressive as always, Andy! Thanks for a very fine video!
Thanks Tom!
Good engineering content and great humour👍👍
Nice work and clever approach to making the nut. One thing I could think of to make whole thing more precise would be to fabricate the nut with even more reduced contact surfaces and make them slightly too small to accommodate the balls. Then run the screw back and forth with shims, thick enough enough allow for movement under force, between the two halves of the nut . Repeat, reducing the shim thickness by small increments till the channel the balls pass through has been burnished to match the screw exactly. Adding some polishing paste instead of grease could add an abrasive element to the fitting
THis would be obviously overkill for this application, but might be one way to make the nut fit the screw very precisely and also work harden the contact areas with the bearings. Though it would be limited by how accurate you can make the screw. Any defects in the screw could transfer to the nut in this way, though it could potentially also improve the screw as well.
I did actually think it would come out slightly undersize and need some sort of wearing in, but being brass it came out the exact dimensions I machined it to.
Taking care of both holes separately for better access, nice.
I'd love to hear you explain the math and process of creating the G-code for the milling of the threads.
Fantastic result, well done.
you'll have to make a roller screw next. thanks for another great video!
"simple formulas" Simple for you perhaps.
Terrific job!
Wow. I use Excel for post-processing GCODE for 3D printing, and people think I'm wild. Actually creating toolpaths, I doff my cap to you!
Hi Alex, good to hear from you, I hope you're doing well! This was really quite a simple toolpath and could actually have been written in notepad using helical interpolation moves (G02/03), but excel allows more flexibility and easier modification. Excel is also really good for modifying existing gcode.
You are smart AF!!! Respect!!! Why? Cuz you made nut from two halves. If it gets worn a bit, you just grind mating planes a bit. Then you can tighten your nut and change clearance using different washers between half nuts. Maybe it is not ideal and can cog somehow but I think it will be good enough.
Brilliant! Thanks for sharing this.
Most people watch for the machining. I watch for the video editing
Call this guy Skynet and prey for humanity. Can't wait the next episode
Excellent ! Just absolutely brill 👏👏👏
Honestly pretty banger of a video
Love the command and conquer reference
Awesome dude, happy to have you on my list of teachers. (I'm new) 🙃
fantastic!
I fucking love this video! Great work man
I get excited when I see the notification - brilliant watching
Thanks for the ride, Andy,, 👍🌟👍
Yes, very nice. Another piece of Arnold's Skeleton finished. :)
Now it's a half-nut. In fact, it's two half nuts next to each other.
One is a mirror image of the other, so that when flipped over, they make a whole nut.
That's nuts...
My basic math is more basic than yours! I struggled just trying to understand that video! But that was nice! 😂
Amazing Craftsmanship 👍🏻👍🏽👍🇬🇧🇬🇧
A year ago I made a toolpath generator for a DIY CNC lathe, I made it with Javascript. and Today I saw your video which uses Excel to generate G-Code cycles. Oh my God, I feel like I have friends who think the same way🤣🤣
Have you considered non-recirculating nuts? They'd be like helical drawer slides. You'd need a cage to hold the balls against the screw but overall the actuator could be slimmer and have the same travel if the cage is half the length of the screw + half the length of the nut.
I see what you mean, but in this case I needed the maximum amount of travel from the shortest nut possible, so it had to recirculate.
I swear I'm going nuts with all the ballscrews! Ballsy move to make your own ballscrews!
Very impressive!
Both the brass and the steel will continuously work harden with use.
You might want to rig a drive to do a few thousand full length cycles overnight (under load) to even out the hardness along the full stroke.
Awsome job !!
coolest linear actuators ever.
Excellent video. Thanks..
Very nice.
Thanks for sharing.
amazing job
Very interesting. Nice work mister
Arrrgghh.! Machines making machines….we’re doomed. Great project. Do you have a video about your workshop machines? I’ve been sat in a drawing office for 20’ish years and want to get back to my apprenticeship days making chips, so it’s interesting to see what machinery people actually use in their workshops/hobby shops.
Yes, I seem to spend most of my spare time making machines to make other machines! I have quite a few videos about workshop machines I've built from scratch, and a few about machines I've bought and repaired/modified.
You are so good !
5:44 If you have watched Forged In Fire, you will see the crazy warping of steel!
Awesome video. Thanks for sharing!
Well done.
12:03 yup that was the best of them all
Balls, nuts, screws, drilling, holes... that swear jar would be full in no time!
This design and purpose has come a long, rather right way since its middle age origin
First time viewer of the channel. I was SO excited to find another machining channel with quality content... and then I saw you upload intervals. Sigh. I guess you simply can't expect quality content to be mass producible. Subbed and having a crack at the Terminator series. It will be like Project Binky, won't it? :P
Welcome aboard! I wish I could spend more time on my projects, but this is just a hobby after all and life gets in the way. There was a big gap between videos recently, but I promise I'll try and upload more regularly in future. Really I will.
@@AndysMachines I get it. This Old Tony and Clickspring also have periods of inactivity, but I'm still delighted like a child whenever they upload.
Genius 👍
I found this as I am Not familiar with all this stuff.
But i bought a defekt Vice which has exactly such ball Channel to hold the screw of the vice.
I bought IT to try to repair IT.
The defect is: with Balls INSIDE the screw can Not be driven. If Balls are Out the vice works but could Not be fastened. So i watched your Video to learn more about the technique behind.
And you gave me the Idea to try First smaller Balls.
I think Something ist wrong with the Channel. I can Put a Pipe Cleaner through it, so there IS No piece of Metal INSIDE or some other dirt.
Maybe the Gothic Arc is Missing.
I have No milling or other Machines, only a drill Press.
I am looking Forward to get IT run now.
Thanks a Lot for Sharing this technique and for the nice speech without music in Background .
This makes it better to understand - English ist my 2nd language and often i do Not understand the speech due to Background music but could understand the meaning.
Yes, I think new balls is the first thing I'd try, they might have small imperfections causing them to jam against each other. Another thing you can do is alternate a smaller ball in between each regular one, this allows all the balls to rotate without sliding on each other since the smaller balls can rotate backwards like an idler between the bigger ones.
I understand the RUclips confusion. You also have the b-screw type you can use in the bedroom....
Any screwball can make ballscrews, but can you make balls screw or screws ball?
Wow! Thanks For Sharing.
I remember the poorly translated instructions that read "Please avoid removing the ball nut from the shaft as often as possible. "
For a precision ball screw nut, most companies use grinding heads, not boring bars.
thanks !
bro doing cnc gcode in exel you have worked for your sub never seen that befor cool
12:37 WOOAAAH
You know there's a whole video on that. Actually a whole series.
I generated nose radius compensation by hand recently to turn on a CNC-mill and felt pretty good about myself, but Excel just isn't beatable.
I do actually think there's an over reliance on CAM in the hobby-scene, I work in production and write my programs on the machine. If you don't have 3D contours it's not that hard to do.
This was very cool, thanks.
Cool! Confused as to why you wouldn't modify the nut you already had though.... But perhaps there are constraints I am unaware of.
They are made from hardened steel and about the only thing that will modify one is an angle grinder! I could have tried softening it first though.
If you made your screw and nut out of materials that work harden, I'm thinking stainless, then use shims to adjust the split nut... do you think such ball formed races would be uniform enough for a smooth high load ballscrew?
I am enthralled by your innovative approach, moar plz!
I did think I might have to adjust the nut somehow to get it to work, but it worked ok. Brass does work harden but it's still relatively soft. I think to wear in/form either the nut or screw it would have to be made from material a lot softer then the balls. There are definitely a lot of possible variations on this approach.
@@AndysMachines You should try to get slightly bigger balls, it would reduce backlash with no further machining needed. As you have 0,1mm backlash currently you should go with balls 0,05mm bigger. I have repaired worn out ball nut this way - by ordering balls 0,02mm bigger, as it was too expensive for customer to order a new screw/nut set and backlash was only slightly too big - it will work for few more years until it crosses the line again.
I would also smooth the screw a little, using some 400 grit sandpaper wrapped around something soft like electric wire or large oring to conform to screw shape.
Why is British this old Tony building a terminator?
Great material. 👍 You didn't provide subtitles, I couldn't turn on the translation.
I did upload a transcript, but it takes youtube a while to generate the timings, hopefully subtitles will appear soon.
@@AndysMachines Thanks
First I hear of excel g code. Surprisingly complex parts can be programmed using only manual g code programming, how it used to be done.
I've never found larger and longer nuts in tight spaces to be a problem
Love the video! I think you should raise the volume of the talking or lower the machines because I would turn up/down the volume when watching. It's personal preference though.
I actually try hard to balance the levels, but it also depends what you are listening to it on. Are you using a phone? My phone, computer, and TV all sound different. RUclips does have a 'stable volume' switch, I turn it off as I find it amplifies any background noise, but you might try that.
what about those 8mm leadscrews 3d printers use, they have a 8mm pitch and can be backdriven and are easy to get spare parts for. what made you discard those as an option?
Yes, I have one of those on my 3D printer. It probably would have worked, but looks a bit weak. The reason these are backdrivable is because of the very high pitch/diameter ratio, though they are not as efficient as a ballscrew and that coupled with the higher pitch would have meant I'd need either a more powerful (larger) motor or higher gear reduction giving slower movement.
Fist time I see this channel. Is this ThisOldTony's brother?