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

https://s3.amazonaws.com/tool-plans/...latorCover.png

$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.
https://s3.amazonaws.com/tool-plans/...ified_logo.png

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.

https://s3.amazonaws.com/tool-plans/...alculator1.png

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! :hattip: ~PJ

Paid for your calculator but won't let me download. I am gunner312@q.com. Help?

Jim Wright

The page it sends me to tells me that I can use it three time before it expires. I go to the page and it tells me there are no downloads remaining. Help?

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.

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

Hi PJs
I downloaded your calculator and it works a treat, many thanks for a great effort.
Regards
Olderdan

Thanks Olderdan, very pleased you found it a treat. Many happy Knurls! ~PJ

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

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.

Hi PJ
I have your Knurling Calculator but I have not been able to use it, Top line is light blue and the letters are
somewhat the same color. Can we fix this?
Thanks
Jim D

Hi Jim - what problems are you experiencing?

Hi Jon, My problem is with lines, 4, 12, 13 and 19. The background colors are a light blue and the writing is
almost the same color to the point where I can't read what's there.
I would change the colors myself but the sheet is locked.

Thanks for your help
Jim D

Message was duplicated

Sorry Jon I missed this message. But at the expense of looking dumb, where do I go to download this file again.
Thanks
Jim D

No problem, I've just reset your download count so you should be able to download this again if you lost it. Let me know if you need a hand with anything.

Hi Jon, Can you e-mail the plans at: jdeprey2@roadrunner.com

Thanks

Jim D

Sure thing, I just re-issued your order to that email address.

Hi Jon.

I just received the new work sheet and the first page, US version is still the same.
Would it be possible to change the lettering on my copy to black, on lines 4, 12, 13 and 19.

I sorry for all the trouble, I'm sure it's something with my own computer.

Thanks again Jon, if your ever in Maine call me and I will treat you to a great Maine Lobster

Jim D

Purchased, Thanks!

Thanks Janders1957 for supporting HMT. Hope it serves you well. :cool: