Thread claculation spreadsheet
- Thread starter joshsapp
- Start date
Help Support Home Model Engine Machinist Forum:
Rynne JT
New Member
Thanks for the opportunity to access...Jim
- Joined
- Jan 17, 2009
- Messages
- 1,081
- Reaction score
- 281
How did you manage to upload a spreadsheet? When I tried it was not an accepted format.
velocette
Well-Known Member
- Joined
- Sep 11, 2011
- Messages
- 184
- Reaction score
- 54
Hi tornitore45 this will be read by in "Open Office" with a warning that the "Macros MAY contain Viruses". I have not attempted to use it yet or scan for Viruses
joshsapp
Member
- Joined
- Jun 2, 2018
- Messages
- 8
- Reaction score
- 4
If you run into a snag let me know.
![TurboCAD 2020 Designer [PC Download]](https://m.media-amazon.com/images/I/51UKfAHH1LL._SL500_.jpg)
![MeshMagic 3D Free 3D Modeling Software [Download]](https://m.media-amazon.com/images/I/B1U+p8ewjGS._SL500_.png)
![DreamPlan Home Design and Landscaping Software Free for Windows [PC Download]](https://m.media-amazon.com/images/I/51kvZH2dVLL._SL500_.jpg)
I just found this thread and I’ve got to say this is a most valuable piece of work to have in my iPad, especially for the pipe thread calculations! Instead of hunting it down in my books, it’s all right here in one easy to use format.
Thanks a million for your hard work and for sharing it!
John W
Camp Verde, AZ
Thanks a million for your hard work and for sharing it!
John W
Camp Verde, AZ
trlvn
Well-Known Member
I had a faint hope I could use your spreadsheet in Libreoffice Calc, but for anyone else who want to try this don't bother. Unfortunately macros don't translate between Excel and LibreOffice, so the macros would have to be re-written to make this work in LibreOffice.
Having said that - for the benefit of those who can use your spreadsheet with Excel I would suggest adding an introduction page which explains what the spreadsheet is for and how to use it.
Having said that - for the benefit of those who can use your spreadsheet with Excel I would suggest adding an introduction page which explains what the spreadsheet is for and how to use it.
- Joined
- Jun 24, 2010
- Messages
- 2,447
- Reaction score
- 969
Looks great! I didn't check every parameter but seems to correspond to the website I use.
http://theoreticalmachinist.com/Threads_UnifiedImperial.aspx
I know this is probably intended as a hobby assist tool, one minor suggestion is to have a nomenclature page since there are lots of abbreviations. Most people might know what they are, but many may not. Or standardize the terminology to a cut & paste reference image, attached example. Another option I often do in spreadsheets is put a more full description in a cell comment so that when you hover over, it conveys the whole definition or other useful information. Some people like this because its helpful, some people find it busy & prefer a cleaner look & a separate 'nomenclature' page. Thanks for contributing!
http://theoreticalmachinist.com/Threads_UnifiedImperial.aspx
I know this is probably intended as a hobby assist tool, one minor suggestion is to have a nomenclature page since there are lots of abbreviations. Most people might know what they are, but many may not. Or standardize the terminology to a cut & paste reference image, attached example. Another option I often do in spreadsheets is put a more full description in a cell comment so that when you hover over, it conveys the whole definition or other useful information. Some people like this because its helpful, some people find it busy & prefer a cleaner look & a separate 'nomenclature' page. Thanks for contributing!
Attachments
joshsapp
Member
- Joined
- Jun 2, 2018
- Messages
- 8
- Reaction score
- 4
Simply didn’t take the time to wipe them out. I created these sheets for work, years ago, and use the macros for various functions of my work. These were paired down and cleaned up a bit to submit.
Last edited:
joshsapp
Member
- Joined
- Jun 2, 2018
- Messages
- 8
- Reaction score
- 4
Great idea. Will check into it in my spare time. The numbers should work. Every thing is out of the Machinists Handbook.
Zach Wells
New Member
- Joined
- Jan 10, 2025
- Messages
- 1
- Reaction score
- 0
i know this thread is old, but could you supply the passwords to unlock the sheets so I can adjust the formatting as needed?
