Hi
@Dpaul7 ,
I am not for sure if you are asking for my spread sheet tool or some other. Anyway, I am still polishing my tool up, but when I am finished I will be happy to sent it you. Yes, I am writing it in Excel. I am traveling a bit currently so am not really working on the spread sheet ... for a while. I will let you know. By the way, in the future I would suggest that you sent a private message to folks rather than posting your email address for all the world to see. ...unless you do not care.
Which model lathe do you have? Is it a PM1340GT ? Do you have the standard set of change gears for the PM1340GT or did you purchase a 35T gear in addition?
Perhaps what I can send you, at this time, is a pdf print out of a table of all of the threading options/possibilities for the standard set of gears plus the 35T for the PM1340GT. There will be some duplication in it as I have the spread sheet set up to put a gear at either top, bottom, or both of the external gear positions. I will see if I can get that generated now and if so I will attach it for you. If you cannot download it I will sent it to you via your email. The table has two types of threading: 1) via the conventional leadscrew and 1/2 nut. 2) by using the power feed which may not be as good. The later opens up some non-conventional TPI values. For each of these, it is sorted by increasing TPI. Anyway, maybe this is of some use to you for now. The titles describe the column content. Note TPI is at the far left with other distance per turns info following in a few columns. The gear settings are in the middle and immediately following that is the Metric info.
I make no guarantees about this being correct. Take a look and let me know what you think or how it could be improved. When the spread sheet is complete the table will be something that you can customize or improve upon..
In the spread sheet that I will be trying to provide, will have macros that allow one to sort one a column or search for any TPI value with wild cards. etc. There are other macros coming that will be provide additional features. Within a limited format one can change lathe properties to generate this sort of table for any lathe the user wants to describe into the spread sheet. So far I have input three different lathe models. Determining the feed rates accurately has turned out to be a challenge.
You maybe interested to follow this thread where we have been discussing X-Feed rates and Power feed rates.
https://www.hobby-machinist.com/threads/x-feed-rates-on-pm-lathes.98071/
Dave L.