Hi
@Ischgl99
I was surprised that I did not get your table to work as I know you are very good at this process. Anyway,....
I agree, it seemed simple, but maybe I missed something the first time through it as I was rushing. I think I was confused by the 30T gear showing up but not the 90T gear to establish the initial TIP values. Hence, I thought I was suppose to change gear tooth number where you had placed the number 52. So I did so as a check. I thought that if I put it to the standard 90T gear that I should get the original table back, but instead the "one-a" entry is 24 not 76. This, now, is obviously not what you wanted me to do. So just now, I changed the 52T number to 30 and the original TPI values appeared. No where in the table was there a place to change the gear box gear, 90T. Maybe you had built this into the initial gear ratios you had placed in column A and so it was not so obvious. Anyway, I did not understand earlier but think I understand now. Your spread sheet works!
So recreated your table, but some what differently so that the ratios were increasing as the knob was turned from one to five. In my version of your table I put the gear ratios as decreasing with knob number rather than increasing. I did this because the TPI in the first column was also decreasing as one does down the column of the table. I also used integers rather than fractions. I put the additional fractional relationship, 1/3 at the top of the table. The gear number and the ratio to make it all fit was 1/3. Then I added the possibility of using the exchange gears, 89, 91, and 56 at the top. I also added what appears to be an unimportant 1 on the Imperial tables, but when you turn to the Metric page you will see that 25.4 is included to make this conversion.
Then when I changed the 30T to 52T as you suggested. I got the Five-B to yield 11.53846TPI, in agreement with your spread sheet. It is even more ironic that if I change the Upper gear to 30 and the lower gear to 52 we get 11.55556! But maybe in this arrangement it is physically impossible to get all of the gears to touch???
Anyway, in the spread sheet that I am attaching I repeated a few of these tables so that one can try out upper and lower gears for each table and compare them. I also added the metric sheet. Note, that I set one of these up to yield 1.5mm/T and we see that it is an approximation because of the 91/86 is not quite exact. If you replace the 91 with 127 and the 86 with 120 the metric threads come out even, 1.5mm/T.
Good night.
Dave L.