Re: Improved Version: TPI, Feeds, X-Feeds: Generalized Lathe TPI Excel file: "TPI_ManyLathesRev1 N502_1630"
Edit: I re-attached the files. I found a small limitation in the way the macros were written and I have fixed it. See the posting below this one explaining this.
Hi Folks,
I will start a new thread for a new and improved version the Excel threading work book. I have worked pretty hard on improving this program and I think it is sufficiently better than the old version that it should be posted here. If you down load the files please make a short comment so that I will know that real people are getting them and possibly have used them. Has this task been worth worth my effort? I have spent a long time working on this project and I would like to know it has been helpful or not to others.
If your lathe model is not included I am willing to help you incorporate it into the workbook.
I will link this thread to the the previous thread on this subject. It is here, but the files posted here are much improved:
This new workbook incorporates new macros with special features and minor improvements to the individual lathe sheets.
The improvements include:
-Generation of the AllTPI sheet with or without the duplicate rows. Without the duplicates the size of the table is reduced by at least 25% and if there are considerable external gears then much more.
-Improvements in sorting
-Improvements in searching for a value and approximate values. The user can input the desired value in many forgiving formats, Wild cards are still allowed, but now both values above and below the target are found.
-A new macro is added which searches from a list of thread values (Imperial and Metric) which the user inputs. As a default, the list contains the standard threads. So it generates a new table which has all of the lathe settings to get to any standard threads.
-A new macro is added which will automatically hide columns which provide no value to the final table. Of course there is also hide macro which allows the user to manually choose the columns to hide. Likewise there is a macro to unhide the columns.
-A new macro is added to allow the user to input eye guiding lines to the AllTPI table. Of course there is a new one that also removes the lines.
-The ReadMe sheet has been significantly rewritten and hopefully provides more insight to how the lathe sheets function so that if your lathe is not included it is easier to make a sheet for your model lathe.
-There are others which are described in the ReadMe sheet.
Attached are the files:
-The Workbook which includes the macros installed and is ready to be run. (Zipped so that it can be posted)
-The Workbook which has the macros removed. You can still operate the lathe sheets manually. But other than just getting an idea of how things work, this is of limited value.
-A Zipped file which only contains the macros. If you wish you can open these with a simple text editor to convince yourself that there is nothing bad in the text, Then you can import these into the Workbook which has no macros. The top two or three lines of these text files have an Attribute command which assigns the Keystroke short cut description for the importing into Excel. However, if you like you delete these, create a blank macro and then copy/paste the macro text into the version you created.
- A pdf file is include which basically shows the ReadMe sheet in a format that has word wrapping. (Significantly easier to read than on the sheet inside the spread sheet. )
I had some trouble zipping and uploading these files so please let me know if they even work. I had run the macro to generate the AllTPI table for my PM1440GT and the resulting the table had 21840 rows of possible TPI values (after the duplication were left out) and so the file size was too large for HM. So I deleted that data sheet, zipped it again and am trying to post it now. The same was true for the version without the macros.
Dave L.
Edit: I re-attached the files. I found a small limitation in the way the macros were written and I have fixed it. See the posting below this one explaining this.
Hi Folks,
I will start a new thread for a new and improved version the Excel threading work book. I have worked pretty hard on improving this program and I think it is sufficiently better than the old version that it should be posted here. If you down load the files please make a short comment so that I will know that real people are getting them and possibly have used them. Has this task been worth worth my effort? I have spent a long time working on this project and I would like to know it has been helpful or not to others.
If your lathe model is not included I am willing to help you incorporate it into the workbook.
I will link this thread to the the previous thread on this subject. It is here, but the files posted here are much improved:
This new workbook incorporates new macros with special features and minor improvements to the individual lathe sheets.
The improvements include:
-Generation of the AllTPI sheet with or without the duplicate rows. Without the duplicates the size of the table is reduced by at least 25% and if there are considerable external gears then much more.
-Improvements in sorting
-Improvements in searching for a value and approximate values. The user can input the desired value in many forgiving formats, Wild cards are still allowed, but now both values above and below the target are found.
-A new macro is added which searches from a list of thread values (Imperial and Metric) which the user inputs. As a default, the list contains the standard threads. So it generates a new table which has all of the lathe settings to get to any standard threads.
-A new macro is added which will automatically hide columns which provide no value to the final table. Of course there is also hide macro which allows the user to manually choose the columns to hide. Likewise there is a macro to unhide the columns.
-A new macro is added to allow the user to input eye guiding lines to the AllTPI table. Of course there is a new one that also removes the lines.
-The ReadMe sheet has been significantly rewritten and hopefully provides more insight to how the lathe sheets function so that if your lathe is not included it is easier to make a sheet for your model lathe.
-There are others which are described in the ReadMe sheet.
Attached are the files:
-The Workbook which includes the macros installed and is ready to be run. (Zipped so that it can be posted)
-The Workbook which has the macros removed. You can still operate the lathe sheets manually. But other than just getting an idea of how things work, this is of limited value.
-A Zipped file which only contains the macros. If you wish you can open these with a simple text editor to convince yourself that there is nothing bad in the text, Then you can import these into the Workbook which has no macros. The top two or three lines of these text files have an Attribute command which assigns the Keystroke short cut description for the importing into Excel. However, if you like you delete these, create a blank macro and then copy/paste the macro text into the version you created.
- A pdf file is include which basically shows the ReadMe sheet in a format that has word wrapping. (Significantly easier to read than on the sheet inside the spread sheet. )
I had some trouble zipping and uploading these files so please let me know if they even work. I had run the macro to generate the AllTPI table for my PM1440GT and the resulting the table had 21840 rows of possible TPI values (after the duplication were left out) and so the file size was too large for HM. So I deleted that data sheet, zipped it again and am trying to post it now. The same was true for the version without the macros.
Dave L.
Last edited: