Metric thread dimensions calculation worksheet
Does anyone know/have a downloadable Mathcad worksheet that calculates all the major, minor, pitch dimensions, thread shear areas, tensile area (root and effective), etc. for a METRIC thread? I've found several metric thread calculators that are strictly web based. One would think that surely someone has created a Mathcad version for Threads based on how integral threaded fasteners are engrained in engineering projects. I hate working in Excel due to the difficulty it has in checking/tracking all the formulas. Mathcad is the way to go, especially when outputs of the threads are typically inputs later on in the Mathcad design document.
Many years ago in my engineering career, I created an Imperial thread worksheet/template which spits out all the dimensions, thread shear areas, root and effective tensile area, etc. taking into account thread class and everything else based on ASME B1.1 (?). Served me well over the 2 decades. Unfortunately I am now tasked with working in Metric units. Tell you one thing - crossing over from Imperial to Metric is not as easy as I would have thought just in general. Much appreciated.

