Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Newcomers DBPro Corner / Useful Equations and Formulae Compilation

Author
Message
vorconan
17
Years of Service
User Offline
Joined: 4th Nov 2006
Location: Wales
Posted: 26th Feb 2008 23:27 Edited at: 26th Feb 2008 23:29
I have countless times had to remember trigonometry equations and vectors etc. I'm sure others have too so I thought that everyone could benefit from and easily understandable compilation of formulae and equations to use. I will be making diagrams for them all so it might take some time to create them all.

Distance Equation - 2D



If anyone wants to contribute then please send the maths along with a simple, understandable description to my e-mail and I'll try my best to get it up. With limited internet at the moment, I'm sorry in advance if I can't reply that quickly.



vorconan
17
Years of Service
User Offline
Joined: 4th Nov 2006
Location: Wales
Posted: 26th Feb 2008 23:28
2D Distance Equation

- Making new posts to host images.



Attachments

Login to view attachments
Libervurto
18
Years of Service
User Offline
Joined: 30th Jun 2006
Location: On Toast
Posted: 27th Feb 2008 21:11
Since this is a DB function your Y axis should originate from the top not the bottom.

Nice idea though I like the diagram.

Do you know that ATANFULL performs this function?

vorconan
17
Years of Service
User Offline
Joined: 4th Nov 2006
Location: Wales
Posted: 29th Feb 2008 17:17
Thanks, I forgot about atanfull. But at least this can be used to calculate distances in a 3D world too. I'm going to make another diagram eventually, but just to note this can work easily with 3 dimensions too:

DX = X1 - X2
DY = Y1 - Y2
DZ = Z1 - Z2

Distance = Sqrt(DX * DX + DY * DY + DZ * DZ)



Sven B
19
Years of Service
User Offline
Joined: 5th Jan 2005
Location: Belgium
Posted: 5th Mar 2008 15:04
I've got some formula's too if you want. Can I post them here then?

It's the programmer's life:
Have a problem, solve the problem, and have a new problem to solve.
vorconan
17
Years of Service
User Offline
Joined: 4th Nov 2006
Location: Wales
Posted: 23rd Mar 2008 22:13
Lol long time since I posted here.

@Sven B - Go ahead.



Login to post a reply

Server time is: 2024-09-27 12:16:01
Your offset time is: 2024-09-27 12:16:01