@davidpbest
I opened up your spreadsheet from a few posts back to see if i could figure out why it isn't giving the pitches that Just for funi s seeing when he actually cuts the threads.
It appears that the formulas in the TPI row are the issue. As they are now, they multiply the gear ratio times the thread TPI count. To get an accurate pitch, the gear ratio needs to be multiplied with the actual pitch, then take 1 divided by the gear ratio*pitch product, to convert the pitch back to TPI.
here is an example. For 40/127 * 120/46, in B3 the current formula shown is F15 * R3, which gives 7.806 TPI, but the OP is seeing an actual 11.56 tpi using that setup. The formula for that cell should be 1/ (f15*R4). The same typo appears to exist in all of the TPI cells.
When I edit that cell to show =1/(F15*R4) it gives the correct 11.562 TPI.
The metric formulas are currently correct and shouldn't need any adjustment.
I went through and pasted the formula adjustments into all of the TPI cells. I'm using Openoffice, but tried to save it using the current excel format. Hopefully it still works.
@Just for fun
Just to check my work, does the data in this adjusted spreadsheet now match what you've seen so far in test cutting threads?
Edited to add: Just wanted to point out, according to the adjusted spreadsheet, 35/127 * 120/40 in B3 gets you alot closer to a true 11.5tpi (11.49) tpi) than the other setting.