This blog is about new ideas which give us new methods and new theorems as the tools to break complex problems in all fields such as Strategic Management, Engineering, Financial Management and so on and finally to solve these problems in the real world in which there is the balance of the cost and the time.
A Model for Analysis of Bond Valuation By Using Microsoft Excel plus VBA
▼
Friday, May 26, 2017
Wednesday, May 24, 2017
The Change Depends on the Direction of the Motion: Generating All Directions in 3D Space
In physics, science, and engineering, especially fluid dynamics and electromagnetism fields, we usually need to investigate the changes of a function in different directions. In this case, the best way for analyzing and designing is to have different directions all together in our hands, in which we will be able to compare all results to reach the new theorems and the new physical phenomena. The purpose of this article is to make a spreadsheet on an Excel file by using a new method where you will have all unit vectors in 3D space in different directions.
Let me give you an example:
Suppose you have a curve of f (x, y, z) = x^2 + y^2 - 2z^2 and the point P (x, y, z) wants to move from P0 (-1, 3, 2) on this curve toward all directions in amount of 4 unit (∆s = 4 unit). The question is:
What is the maximum change of the function when point P (x, y, z) moves in all directions? In which direction will the maximum change in the function occur?
Solution:
You as well as know, we can easily
get all unit vectors in 2D surface by using bellow formula:
U = i cosθ + j sinθ
On the other hand, we can obtain the direction of a vector in 2D and 3D, by using below formula:
Direction of A = A / │A│
But, how can we prove above formula?
A vector in 3D space can be modelled
as the radius of a sphere in which we will have below function:
w = r (x, y, z) = (x^2 + y^2 + z^2)
^0.5
The gradient vector in any point is:
As you can see, the gradient vector
proves above formula (formula:
Direction of A = A / │A│) where
vector A = xi + yj + zk because we have:
Generating all
directions in 3D space
Consider a particle starts its circular motion
on surface XY and simultaneously has a circular motion on surface XZ
perpendicular to surface XY. In this case, this particle will produce a sphere
where its circular angle on surface XY is “θ” and its circular angle on surface
XZ is “β”.
According to above circular angles
and radius of sphere (r), we can calculate coordination of point P (x, y, z) on
sphere by using below equations:
x = r * cos β * cos θ
y = r * cos β * sin θ
z = r * sin β
Example:
Solve equation: x^2 + y^2 + z^2 = 225
If θ = 25 degree and β = 56 degree
Answer:
We have: r = (225) ^0.5 = 15
x = 15 * cos 56 * cos 25 = 7.602013
y = 15 * cos 56 * sin 25 = 3.544877
z = 15 * sin 56 = 12.43556
(7.602013 ^2) + (3.544877 ^2) +
(12.43556 ^2) = 225
In fact, we have below vector:
V = xi + yj + zk
V = (r * cos β * cos θ)i + (r * cos β * sin θ)j + (r * sin β)k
For r = 1, we have below unit vector in 3D space:
U = (cos β * cos θ)i + (cos β * sin θ)j + (sin β)k
It is clear; the range of changes
for “θ” and “β” is between 0 and 360 degree.
Therefore, for making a spreadsheet
included all directions, we should go below steps:
- Choose ∆θ and ∆β between 0 and 360 degree. For instance, I
considered ∆θ = ∆β = 1
- By using the method stated in article of “Can We Solve a
Nonlinear Equation with Many Variables?” posted on link: http://emfps.blogspot.co.uk/2016/10/can-we-solve-nonlinear-equation-with.html, we should find all combinations of “θ” and “β” for ∆θ and ∆β between 0 and 360 degree. For example, when
I considered ∆θ = ∆β = 1, I will have 130321 combinations on my excel spreadsheet
(361^2 = 130321).
If you choose ∆θ = ∆β = 0.5, you
will have 519841 combinations (directions) on your excel spreadsheet (721^2 =
519841).
Anyway, I think that ∆θ = ∆β = 1 is
enough.
- Using from above equations for r = 1 and each set of
combinations. In this case, you have
130321 rows that it show you all directions which you need to your analysis.
In the next articles, I will show
you how we can utilize this spreadsheet as a template to investigate the changes
of some physical functions.