Did I mention that I REALLY don't like gurgle stuff? I've found so many problems with the spreadsheet on gurgle drive upload that I can't recommend it's use. I'll probably have to take it down. Can anyone tell me a better way? In the mean time, if you really want a fully working copy, send message to cdkra...@gmail.com and I'll email you a copy directly. DanK
On Sunday, September 17, 2023 at 7:20:31 AM UTC-4 Jeff Richmond wrote: > Nice 👍 > > Jeff from Connecticut > Sent from my iPhone > > On Sep 16, 2023, at 8:44 PM, cdkr...@gmail.com <cdkr...@gmail.com> wrote: > > > > Hi everyone. > Here is a screen shot of the ratio and tooth count calculator I've been > working on. You work from lead screw TPI to workpiece TPI. > Here's how it works: > 1. the green areas are data entry. > 2. the pink areas are calculated > There are some restrictions on tooth counts that will limit driver choices > to a range that will fit on the banjo. If a tooth count in one cell > results in a non-integer count in another cell, it complains and tells > you. Working the matrix from top to bottom, you will have to use some math > skills to find factors of numbers to use in the fraction boxes. (see > example). It will allow you to enter other factors if needed, in this > example 2 and 6 instead of 3 and 4. It should be easy to feel confident > your choices are workable because it will complain if not. Then you can > enter (reasonable) tooth counts and the other side of the tooth count will > be calculated. No poke and hope. > > <Capture.JPG> > This is a screen shot. I will shortly post the working copy if it looks > interesting to just one person! > DanK > > -- > You received this message because you are subscribed to the Google Groups > "Legacy Ornamental Mills" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to legacy-ornamental...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/legacy-ornamental-mills/ad243dee-b2c0-4609-ac58-2fe790df9c4fn%40googlegroups.com > > <https://groups.google.com/d/msgid/legacy-ornamental-mills/ad243dee-b2c0-4609-ac58-2fe790df9c4fn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > <Capture.JPG> > > -- You received this message because you are subscribed to the Google Groups "Legacy Ornamental Mills" group. To unsubscribe from this group and stop receiving emails from it, send an email to legacy-ornamental-mills+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/legacy-ornamental-mills/a481b4b4-d693-442d-a8e3-e153512007b2n%40googlegroups.com.
