I have a stepper type motor driving a ball screw that lifts an arm that can weigh up to 100LB. is there a formula that i can figure what kind of power i need
If you know how fast the 100# weight is being lifted, you can convert to horsepower.
If you lift it 5.5 feet in one second you are doing 100x5.5=550 ft-lb/sec of work, which is 1 horsepower.
1 HP =745 watts.
then you have the efficiency factor of the ball screw, motor, and the gear train. If you have no quatitative measurement of that, I would use a rectally extracted number of about 60% for an initial estimate. So for every 100 watts of electricity you put in you would expect to get approximately 60 watts (.08 HP) of mechanical work out.