I have a problem in statics that I must use excel to do and my instructor modified the given question in a few ways to allows to use the capabilities of excel to find what the question asks for.

http://herograw.com/5-51.JPG [Broken]

These are my instructors additions:

If the whole excel approach sounds confusing then please help in solving the original question. That way I can use that method in solving the question the way my instructor expects.

Last edited by a moderator: Apr 21, 2017 at 9:25 AM

In class today I was given an extension on this problem.

I also found that the free body diagram that I was using was a little complicated and the only forces acting on the handle is the applied force and the force caused by the spring. I'm a little confused in how to find the force caused by the spring and which [tex]\Sigma F=0[/tex] and [tex]\Sigma M=0[/tex] equations to use.