Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Anyone good at formulas in Excel 2007?

  1. Mar 7, 2008 #1
    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!
     
  2. jcsd
  3. Mar 7, 2008 #2
    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!
     
  4. Mar 7, 2008 #3
    It sure does, thanks!
     
  5. Mar 7, 2008 #4
    Nevermind.
     
    Last edited: Mar 7, 2008
  6. May 9, 2008 #5
    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?
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?



Similar Discussions: Anyone good at formulas in Excel 2007?
  1. Anybody good with Excel? (Replies: 16)

Loading...