Hi CNCNewb,
For your stated problem, the traveling nut on the screw is moving at a constant linear velocity because the screw is turning at a constant angular velocity, ie. 1000 RPM.
The traveling nut is pushing at a constant 100 lb thrust.
Now assume the system is lossless, so work, energy is conserved. For 5 turns of the screw the advance is 1 inch = 5TPI. For rotation Work = T x Theta where T = torque, Theta = radians. For linear motion, Work = Force x Distance.
In this case when the work out = 100 lb x 1 in = 100 in.lbs. at the same time work in = T x 5 x 2 PI, so:
Torque = 100/10PI = 3.1831 in.lbs.
For precision ball screws, one can expect around 90% efficiency (10% loss) so the input torque would probably be closer to:
3.1831 x 1.1 = 3.5 in.lbs.
In other words, the torque(T) thrust(W) relation for a lossless screw system is T = func(TPI) x W