Results 1 to 13 of 13
Thread: Cannon Problem (200)

20030409, 09:29 #1
 Join Date
 Apr 2002
 Posts
 67
 Thanks
 0
 Thanked 0 Times in 0 Posts
Cannon Problem (200)
I know I posted this up before but I don

20030409, 09:50 #2
 Join Date
 Feb 2001
 Location
 Weert, Limburg, Netherlands
 Posts
 4,812
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Cannon Problem (200)
Like this.....
Jan Karel Pieterse
Microsoft Excel MVP, WMVP
www.jkpads.com
Professional Office Developers Association

20030409, 09:54 #3
 Join Date
 Apr 2002
 Posts
 67
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Cannon Problem (200)
fantastic ! thanks a lot

20030409, 09:57 #4
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 Posts
Re: Cannon Problem (200)
You might have asked your question in a reply in the previous thread. In fact, Steve (sdckapr) has already answered your question, but you are using a nonstandard way of measuring the angle. Mathematicians start at the positive xaxis and count counterclockwise (see attached picture). In your case, starting at the positive Yaxis and counting clockwise:
X = distance * SIN(RADIANS(angle))
Y = distance * COS(RADIANS(angle))
In the example, distance = 7 meters and angle = 116 degrees, so X = 7*SIN(RADIANS(116)) = 6.29 and Y = 7*COS(RADIANS(116)) = 3.07 (rounded to 2 decimals)

20030409, 10:47 #5
 Join Date
 Apr 2002
 Posts
 67
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Cannon Problem (200)
Saw steve's answer but couldnt quite grasp it, as i was doing something wrong somewhere which i wasnt sure was down to the way i posted the orgiginal question, hence the reposting.
why on earth do mathemticians do it counterclockwise ?
My next bit is now is wind resistance , off googling!

20030409, 13:03 #6
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 Posts
Re: Cannon Problem (200)
The reason that mathematicians measure angles counterclockwise is probably related to the standard coordinate system: positive xaxis points "East", positive yaxis points "North". Starting from the positive xaxis and going towards the positive yaxis, you turn counterclockwise. But in the end, it's just a convention.

20030409, 14:38 #7
 Join Date
 Apr 2002
 Posts
 67
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Cannon Problem (200)
This makes me wonder if Mathemticians are good maps readers,
Heres how my spreadsheet is going, I have yet to put in the "Direct Hit" coding and for an added element I am adding a Team of journalist wondering around as well to avoid,
This is expanding on my other post usesless things you can do in excel,
Please note I know the coding is dirty at the moment !

20030409, 22:43 #8
 Join Date
 Dec 2000
 Location
 Hornsby Heights, New South Wales, Australia
 Posts
 3,822
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Cannon Problem (200)
Next time round, instead of DELETING your original post which leaves all the answers to that post hanging in the wild, EDIT the post instead of starting a new thread, thanks. <img src=/S/exclamation.gif border=0 alt=exclamation width=15 height=15>
Cheers, Claude.

20030410, 05:28 #9
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 Posts
Re: Cannon Problem (200)
Steve,
If you substitute Angle = 0 in your formula, 90Angle = 90, so Sin = 1 and Cos = 0, leading to X = distance and Y = 0 (disregarding p1 instead of pi)
I think <post#=242441>post 242441</post#> contains the correct formulas for Chance's coordinate system.

20030410, 08:11 #10
 Join Date
 Feb 2001
 Location
 Weert, Limburg, Netherlands
 Posts
 4,812
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Cannon Problem (200)
My sample file further up this thread should be correct too...
Jan Karel Pieterse
Microsoft Excel MVP, WMVP
www.jkpads.com
Professional Office Developers Association

20030410, 08:17 #11
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 Posts
Re: Cannon Problem (200)
Yes, of course. Sorry for not mentioning your post too <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.
The formulas in your and my post are basically the same; the RADIANS function multiplies by PI()/180.

20030410, 11:13 #12
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Cannon Problem (200)
<P ID="edit" class=small>(Edited by sdckapr on 10Apr03 07:13. change/correct PI from P1)</P>If you want to "work with" your "degree syntax" use:
X = distance * SIN((90angle)/180*pi())
Y = distance * COS((90angle)/180*pi())
Where angle is the degrees with North = 0, East = 90, etc. The "90Angle" puts it into the math standard and the "/180 * Pi()" converts to radians
Steve

20030410, 11:14 #13
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Cannon Problem (200)
Yes, I thought that is what he wanted.
In his "degree scheme" 90