Anyone good at formulas in Excel 2007?

  • Thread starter Thread starter 5.0stang
  • Start date Start date
  • Tags Tags
    Excel Formulas
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
Sign up Log in
4 replies · 4K views
5.0stang
Messages
63
Reaction score
0
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!
 
Physics news on Phys.org
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!
 
It sure does, thanks!
 
Nevermind.
 
Last edited:
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?