• Support PF! Buy your school textbooks, materials and every day products Here!

Excel spreedsheet for Range formula- Lab

  • #1
I have to program the range formula R= [Vo2sin(2*theta)]/g, into an Excel spredsheet. I need to progran the equation for various values of 'theta' to determine for which value(s) of 'thet' is the range maximum.

Table should have left side Injection angle (degrees), right side Range (R). The injection angle will go from 0 to 90 degrees in steps of two degrees.



Problem = I do not know Excel! Can someone help me on this?
 

Answers and Replies

  • #2
cristo
Staff Emeritus
Science Advisor
8,107
73
Well, first you need to pick a value for V_0. Then make the column theta start at some value, and increase 2 degrees in each row until you get to 90. In the next column, you simply type in the equation for range, with the parameters you know, making sure get excel to insert the value in the corresponding left column cell in place of the theta value.
 
  • #3
Help

I tried this as well and am receiving alot of negative numbers which can't be right.

V=10
G=10 m/s^2
In column A I numbered each row 0 to 90 increments of 2.

Then in column B programmed the following formula =10*2*SIN(2*A4)... A4 is the cell number value which = 4 in this case

Then the next row I had it take the value of B and divide it by 10^2 since G=10

Please advise
 
  • #4
malty
Gold Member
162
0
I tried this as well and am receiving alot of negative numbers which can't be right.

V=10
G=10 m/s^2
In column A I numbered each row 0 to 90 increments of 2.

Then in column B programmed the following formula =10*2*SIN(2*A4)... A4 is the cell number value which = 4 in this case

Then the next row I had it take the value of B and divide it by 10^2 since G=10

Please advise
Be careful!!!

Excel calculates angles in radians!!!

You must change to degrees first.. there is a function in excel that does this, but my the life of me I cannot remember :uhh:

1 sec .. .

//

Jerry Hester to the rescue once again (his tutorials really have been invaluable)
http://phoenix.phys.clemson.edu/tutorials/excel/trig.html
 
Last edited:
  • #5
Okay that makes sense, but how do I do it when I have an equation such as
V02sin(2Theta)
 
  • #6
malty
Gold Member
162
0
Okay that makes sense, but how do I do it when I have an equation such as
V02sin(2Theta)
Not 100% here, so you may want to check with a calculator .. .

[tex] V_o 2*\sin {(RADIANS(2*\theta)) [/tex]
 
  • #7
now how do I apply inExcel??
 

Related Threads on Excel spreedsheet for Range formula- Lab

  • Last Post
Replies
7
Views
2K
  • Last Post
Replies
1
Views
2K
  • Last Post
Replies
1
Views
6K
  • Last Post
Replies
6
Views
2K
Replies
13
Views
906
  • Last Post
Replies
1
Views
1K
  • Last Post
Replies
4
Views
3K
Replies
4
Views
9K
  • Last Post
Replies
4
Views
3K
Replies
2
Views
2K
Top