Thread: PJs Knurl Calculator
10-12-2016, 11:54 AM #1
PJs Knurl Calculator
Calculate material diameters for knurling quickly and accurately, based on your knurl wheels. This can be used on computers/laptops, tablets or cell phones that have a spreadsheet program or app. Personally I use it on my tablet in the shop.
Knurling Calculator for Sale - $5.00
$5.00 - Click here to buy now via PayPal and download instantly
30-day money-back guarantee.
If you purchase these plans and are not 100% satisfied, we'll refund your purchase price.
This is simple to use spreadsheet with two sheets allows you to calculate material diameters in Imperial and Metric forms based on your knurl diameters. It is pre-loaded with LMS and some Zeus (metric) knurl wheel data.
Additionally there is a section below the main table (on each sheet) that allows you to enter your tooth count and measured wheel diameters for the most accurate diameters of material size, ensuring you will get good knurls every time. Once you enter the data for "Your Wheels" the Calculator Cells will automatically populate.
I have also added "Material to Remove" row that will automatically calculate how much material to remove based on your material measurement. I found this quite handy after taking a skim cut or working with odd size materials that I could use my compound dial setting to remove the necessary material prior to setting up the knurling tool.
Please note: All cells are locked except the "data entry" cells to insure the integrity of the labels, formulas, functions and tables built into the spreadsheet. If you would like to learn more about how the spreadsheet works and how I developed it you can visit my knurling pages and read (slog through) my dissertation.
As most of the regulars here know this was a Tool of the Week for me and have had a tremendous viewing of that Must Read Thread. Because of the issues with keeping a Live Spreadsheet on my website and my Great Appreciation for HomemadeTools.net and all the wonderful people I have encountered here, I have decided to donate the proceeds of the first 1000 copies of this little tool to HMT. A small way for me pay forward all I have learned and fun I've had these last few years here on this great forum. If you feel the same I encourage you to make a small donation by purchasing this useful tool.
Happy Knurling! ~PJ
Last edited by PJs; 10-12-2016 at 12:08 PM.
The Following User Says Thank You to PJs For This Useful Post:
10-14-2016, 09:43 PM #2
10-14-2016, 10:12 PM #3
10-14-2016, 11:52 PM #4
- Join Date
- Jan 2012
- Colorado, USA
- Thanked 857 Times in 512 Posts
Hi Jim - no problem, I can see your order. You should only need to download it once, but the system gives everyone 3 downloads. I've just reset you to 3 more downloads, so please give it another try. If that doesn't do it, I'll email you the calculator directly.
The Following User Says Thank You to Jon For This Useful Post:
10-15-2016, 01:00 PM #5
Thanks Gunner312 for downloading the spreadsheet. Sorry you had some issues and hope they are all resolved now with Jon's Expedient Help! Please let me/us know that you were successful this time and would love any feedback about the spreadsheet.
Thanks Again, ~PJ
12-03-2016, 10:22 AM #6
The Following User Says Thank You to olderdan For This Useful Post:
12-03-2016, 11:26 AM #7
12-03-2016, 02:43 PM #8
PJs I downloaded your Knurling calculator about a month ago. I hardly ever do any Knurling but thought it would be a nice reference tool to have for those times when I do need to make a few knurls. However most of my knurling was done on an ID as in valve guides not using wheels but a broach
Last edited by Frank S; 12-03-2016 at 02:47 PM.Never try to tell me it can't be done
When I have to paint I use http://kbs.justoldtrucks.com/
The Following User Says Thank You to Frank S For This Useful Post:
12-03-2016, 06:20 PM #9
Thanks Frank! I hope you find it handy and useful when you do some knurling. I remember knurled valve guides from my automotive days. It saved them for a while and kept them a bit cooler too as I remember.
Post your reply!
Join 20,941 of us and get our 50 Must Read Homemade Tools eBook free.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)