Anyone good at formulas in Excel 2007?

In summary, the conversation discusses a formula for calculating the throat area of a throttle body, using values for minimum diameter, open angle, and closed angle. The formula involves plugging in the values into cells in an Excel spreadsheet. The final answer was 1.29 and it is unclear if the formula was calculated correctly or if "RADIANS" needs to be inserted anywhere.
  • #1
5.0stang
63
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!
 
Computer science news on Phys.org
  • #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!
 
  • #3
It sure does, thanks!
 
  • #4
Nevermind.
 
Last edited:
  • #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?
 

Related to Anyone good at formulas in Excel 2007?

1. What is Excel 2007?

Excel 2007 is a powerful spreadsheet program developed by Microsoft. It is a part of the Microsoft Office suite and is commonly used for organizing, analyzing, and visualizing data.

2. What are formulas in Excel 2007?

Formulas in Excel 2007 are mathematical expressions that are used to perform calculations or manipulate data. They can be used to add, subtract, multiply, divide, or perform more complex operations on data in a spreadsheet.

3. How do I create a formula in Excel 2007?

To create a formula in Excel 2007, you can either type it directly into a cell or use the "Formulas" tab in the ribbon. You can also use the formula bar at the top of the screen to enter and edit formulas.

4. Can I use functions in my formulas in Excel 2007?

Yes, Excel 2007 has a wide range of built-in functions that can be used in formulas. These functions can perform a variety of tasks such as calculating averages, finding the maximum or minimum value, and more.

5. How can I check if my formula is correct in Excel 2007?

Excel 2007 has a "Formula Auditing" feature that allows you to check your formulas for errors. You can also use the "Evaluate Formula" feature to see the step-by-step calculation of a formula. Additionally, you can use the "Error Checking" feature to identify and fix any errors in your formulas.

Similar threads

  • Mechanical Engineering
Replies
6
Views
4K
  • Introductory Physics Homework Help
Replies
11
Views
1K
  • Calculus and Beyond Homework Help
Replies
2
Views
867
Replies
1
Views
799
Replies
6
Views
2K
  • Introductory Physics Homework Help
Replies
3
Views
793
Replies
1
Views
2K
  • Introductory Physics Homework Help
Replies
10
Views
2K
  • Introductory Physics Homework Help
Replies
14
Views
2K
  • Introductory Physics Homework Help
Replies
4
Views
1K
Back
Top