- #1

- 22

- 0

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?

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

- Thread starter brncsfns5621
- Start date

- #1

- 22

- 0

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?

- #2

cristo

Staff Emeritus

Science Advisor

- 8,107

- 73

- #3

- 2

- 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

- #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

- 2

- 0

Okay that makes sense, but how do I do it when I have an equation such as

V02sin(2Theta)

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

- 1

- 0

now how do I apply inExcel??

Share: