Anyone good at formulas in Excel 2007?

[5.0stang]

Okay, the formula that I am working from is:

(RL+S) – sqrt [ RL^2 – (S*sin CA)^2 ] – S*cos CA

Rod Length = RL = 5.090
Half Stroke = S = 1.5
Crank Angle = CA = 107.5

With numbers plugged in (my version?):

(5.090+1.5) - sqrt [5.090^2 - (1.5*sin (107.5))^2] - 1.5*cos (107.5)

The final answer should be 2.156.

How can I put this into an Excel spreadsheet so I can just change out the 3 inputs and get the correct answers for each?

Thanks for any help!

 

[acvwJosh]

Put your values into these cells:

Rod Length -- A2
Half Stroke -- B2
Crank Angle -- C2

And paste this equation into E2:

=(A2+B2)-SQRT((A2^2)-(B2*SIN(RADIANS(C2)))^2)-B2*COS(RADIANS(C2))

Hope that helps!

 

[5.0stang]

It sure does, thanks!

 

[5.0stang]

Nevermind.

 

[5.0stang]

Okay I got another one that I need help with. Maybe someone can help explain it to me. :)

Formula on paper looks like:

(Pi*d^2/4) * 1-((cos(Open Angle + Closed Angle)) / (cos(Closed Angle)))

I am using this for a throttle body throat area formula.

D = Minimum Diameter and I am using 2 for now.
Open Angle = 75
Closed Angle = 15

They both equal 90 degrees.

I put it in Excel like this:

=((3.14*(B1)^2)/4)*(1-(COS(D1+C1))/(COS(C1)))

The answer was 1.29.

Did I do any of this correctly? Do I need to insert "RADIANS" anywhere?