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.
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.
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.
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.
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! 😄
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
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 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.
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.
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!
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.
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.
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
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.
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🤣🤣
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...
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 !!
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 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.
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.
Ballscrews were invented at the end of the 19th century, though I don't know what their first application was. They are still used in many steering boxes and it's a good example of where their use has advantages over a plain screw, I don't know if any steering systems (other than perhaps a traction engine?) use plain screws, but I think it would be terrible and might even lock up completely under external load!
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.
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.
when i first read the title, the first thing in my mind was: either this man is a a huge poser or a master screwer. when i saw that his nuts were made of brass i even laughed, everyone knows that those nuts would be destroyed with all the screwing in and out. but then i noticed ... he got steel balls in there. 6 out of 5 on anything related to nuts balls or screws.
The rod on the left is connected to the screw which rotates, the rod on the right is connected to the nut which can only move linearly. The rod on the right is actually hollow and the screw fits inside it.
I have never seen a decent demo or how-to on using the arc/radius function of a DRO *specifically* for z-axis 3D milling. I know your channel isn't exactly a how-to channel, but it sure would be amazing to see a proper how-to for this feature from someone who clearly knows what they are doing (you). I've seen demos on x-y arcs, and I'm sure an x-z arc is the exact same thing, but my brain can't compute!!
Yes, I try and avoid 'how-to' videos, more just 'this is how I did it'. I'm just a hobby machinist after all and not really qualified to give in depth tuition. Working in the X-Z plane is definitely harder to comprehend than X-Y, but it's just a case (in both) of moving each axis one at a time through a series of points, always first moving the axis which takes the tool AWAY from the part, then the other axis that takes the tool towards the part to end up at the specified point. (And the third unused axis should be locked in place, (unless working in the X-Y plane and taking the cuts by plunging with the Z, then you can ignore most of the above. See, how-to's are complicated!)).
Yes, probably. But I'd have to soften the nut to be able to machine it. And I didn't have one small enough since the screw had to be around 10mm diameter due to other limitations of the design. I maybe could have made a 1204 ballnut work, but I'm not sure how the circuit(s) are arranged in these.
-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.
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.
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
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.
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.
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! 😄
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.
Generating g-code with excel? What a badass.
That’s some fine problem solving and utilization of what’s available and convenient.
Very enjoyable. 👍
The best video ever! You made my night! Now I just have to figure out where to get this new “Excel”. 🤣
Superb technical content, video production and humor. A true machinist's trifecta!! Thank you.
Cheers,
F.C.
8:00 THIS GOTTA BE A JOKE
I don't know much about machining but I love your dry narration with the hilarious comic relief in the video! 🤣
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 channel is a real life terminator subplot and I’m absolutely here for it.
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.
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.
So glad I found your channel. Amazing work!
What a blast of a video! Engineering, problem solving, reasoning, machining and humour😂! Excellent🎉
Subscribed. From a fellow machinist, great work. You opened my mind to the fact that math and digital readouts can do amazing things.
Thanks!
Great job; this is rare tool build. We shared this video on our homemade tool forum last week 😎
well done, truly!
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.
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
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 🙂
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!
That are the type of videos I come for to YT. Strange projects that I definitely won't do on my own. Liked. Subscribed.
Great solution to this problem 😊 love the sound effects too
This guys comedy and skill are both great I laughed and learned, would certainly say test to a second date haha
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.
My basic math is more basic than yours! I struggled just trying to understand that video! But that was nice! 😂
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.
Balls,nuts,screws,holes...
Drilling. 😂
but is he a Pro(fessional)
Rigid tool @@lawrencemanning
Shafts
Flange
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
Genius, loved it! Also excel gcodes is next level insanity, well done.
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.
Good engineering content and great humour👍👍
"simple formulas" Simple for you perhaps.
Terrific job!
I'd love to hear you explain the math and process of creating the G-code for the milling of the threads.
Impressive as always, Andy! Thanks for a very fine video!
Thanks Tom!
Excellent ! Just absolutely brill 👏👏👏
Brilliant! Thanks for sharing this.
you'll have to make a roller screw next. thanks for another great video!
Fantastic result, well done.
Most people watch for the machining. I watch for the video editing
Taking care of both holes separately for better access, nice.
Love the command and conquer reference
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🤣🤣
Thanks for the ride, Andy,, 👍🌟👍
coolest linear actuators ever.
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...
12:03 yup that was the best of them all
I fucking love this video! Great work man
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 !!
Call this guy Skynet and prey for humanity. Can't wait the next episode
5:44 If you have watched Forged In Fire, you will see the crazy warping of steel!
fantastic!
Awesome dude, happy to have you on my list of teachers. (I'm new) 🙃
I get excited when I see the notification - brilliant watching
Honestly pretty banger of a video
Yes, very nice. Another piece of Arnold's Skeleton finished. :)
For a precision ball screw nut, most companies use grinding heads, not boring bars.
Amazing Craftsmanship 👍🏻👍🏽👍🇬🇧🇬🇧
This design and purpose has come a long, rather right way since its middle age origin
Why is British this old Tony building a terminator?
Awesome video. Thanks for sharing!
I understand the TH-cam confusion. You also have the b-screw type you can use in the bedroom....
I swear I'm going nuts with all the ballscrews! Ballsy move to make your own ballscrews!
Very impressive!
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 remember the poorly translated instructions that read "Please avoid removing the ball nut from the shaft as often as possible. "
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.
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.
Very nice.
Thanks for sharing.
Excellent video. Thanks..
Very interesting. Nice work mister
You are so good !
I've never found larger and longer nuts in tight spaces to be a problem
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.
Balls, nuts, screws, drilling, holes... that swear jar would be full in no time!
Well done.
Any screwball can make ballscrews, but can you make balls screw or screws ball?
Wow! Thanks For Sharing.
amazing job
Bro literally is like "just use excel to make your gcode. It's not that hard if you're good at basic math" 😅
I don't know if they invented them, but GM steering boxes used to use this technology
Ballscrews were invented at the end of the 19th century, though I don't know what their first application was. They are still used in many steering boxes and it's a good example of where their use has advantages over a plain screw, I don't know if any steering systems (other than perhaps a traction engine?) use plain screws, but I think it would be terrible and might even lock up completely under external load!
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.
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.
when i first read the title, the first thing in my mind was: either this man is a a huge poser or a master screwer. when i saw that his nuts were made of brass i even laughed, everyone knows that those nuts would be destroyed with all the screwing in and out. but then i noticed ... he got steel balls in there. 6 out of 5 on anything related to nuts balls or screws.
Fist time I see this channel. Is this ThisOldTony's brother?
@12:10... Am I missing something? How is the right side moving linear but the left side is not?
The rod on the left is connected to the screw which rotates, the rod on the right is connected to the nut which can only move linearly. The rod on the right is actually hollow and the screw fits inside it.
@AndysMachines ohh got it, thank you.
I just got kicked out of the room for saying BALL SCREW.
This was very cool, thanks.
5:00 Predator HUD sound from AVP :D
I have never seen a decent demo or how-to on using the arc/radius function of a DRO *specifically* for z-axis 3D milling. I know your channel isn't exactly a how-to channel, but it sure would be amazing to see a proper how-to for this feature from someone who clearly knows what they are doing (you). I've seen demos on x-y arcs, and I'm sure an x-z arc is the exact same thing, but my brain can't compute!!
Yes, I try and avoid 'how-to' videos, more just 'this is how I did it'. I'm just a hobby machinist after all and not really qualified to give in depth tuition. Working in the X-Z plane is definitely harder to comprehend than X-Y, but it's just a case (in both) of moving each axis one at a time through a series of points, always first moving the axis which takes the tool AWAY from the part, then the other axis that takes the tool towards the part to end up at the specified point. (And the third unused axis should be locked in place, (unless working in the X-Y plane and taking the cuts by plunging with the Z, then you can ignore most of the above. See, how-to's are complicated!)).
depending on the nut in question, could you not just cut off a race of balls to achieve the same result with hardened steel?
Yes, probably. But I'd have to soften the nut to be able to machine it. And I didn't have one small enough since the screw had to be around 10mm diameter due to other limitations of the design. I maybe could have made a 1204 ballnut work, but I'm not sure how the circuit(s) are arranged in these.
@@AndysMachines what about using abrasives to cut through it like an angle grinder?
Im gonna be the 500th person to comment about 8:00 but my man!... Thats cool! And honestly, its bananas!