Calculate the Torque and Ratio needed

	A	B	C	D	E	F	G
1
2	Input into green cells	Output in yellow.
3
4	Name	Symbol	# Teeth	Equations and consierations:	teeth OK?
5
6	Power In (W)	Pin	20
7	Torque Motor In (Nm)	Cin	3.17
8	RPM In (rpm/min)	Nin	13	(Pin/Cin)(60/(2PI))
9	Mass needed (Kg)	M	8
10	Arm Lenght (m)	L	0.7
11	gravity acceleration(m.s-2)	g	9.81
12	Force needed (N)	Fout	78.48	M*g
13	Torque Needed (Nm)	Cout	54.936	Fout*L
14
15	System yeild	Y	0.95
16						trmin in	120
17	Power Out(W)	Pout	19	Pin*Y		trmin out	6.578200087
18	RPM out (rpm/min)	Nout	3.302691043	(Pout/Cout)(60/(2PI))
19
20	Ratio Needed(with torque)	Rt	18.24207206	1/((Cin/Cout)*Y)
21	Ratio Needed(with rpm)	Rr	3.936184109	1/(Nout/Nin)
22
23
24	Input Diametral Pitch	Dp1	0
25	Sun Gear 1 Toothcount	Ns1	12	Ns1 must be evenly divisible by P	GOOD
26	Planet Gears 1 Toothcount	Np1	30	Np1=(Na1-Ns1)/2, bust be whole #	GOOD
27	Annulus Gear 1 Toothcount	Na1	72	Na1 must be evenly divisible by P	GOOD
28
29	Output Diametral Pitch	Dp2	0	Dp2=(Dp1*(Na2-Np2))/(Na1-Np1)
30	Sun Gear 2 Toothcount	Ns2	14	Ns2=Na2-(2*Np2), must be evenly divisible by P	GOOD
31	Planet Gears 2 Toothcount	Np2	30	Np2=Np1*n, must be whole #	GOOD
32	Annulus Gear 2 Toothcount	Na2	74	Na2=(n*Na1)+P, must be whole #	GOOD
33	# of planets in carrier	P	2	Will this many planets fit around the annulus? Check your drawing...
34	2nd stage multiplier	n	1	Must be rational number. ...does this make Na2 teeth too tiny?
35
36	Ratio First Stage	R1	7	R1=(Na1/Ns1)+1
37	Ratio Second Stage	R2	36	R2=(nNa1)/(Na2-(nNa1))
38	Final Ratio at Output Shaft	Rf	252	Rf=R1*R2
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100