Executive Methods for Problem Solution: A Model to Solve a System of Nonlinear Equations by Using Microsoft Excel

This is an example for solving a system of nonlinear equations by using the Big Data Science Analysis with Microsoft excel plus VBA.

Definitely, there are many complicated problems that can be solved by using this analytic model. For instance, one of the applications of this model is to solve problems related to optimization, such as Hill Climbing.

For example, what is the maximum area of a rectangle inscribed in a circle with a radius of 2 units?

You can find the answers for “x” and “y” in this rectangle in the below data analysis:

I would like to inform you that this model is able to solve all linear and nonlinear system of equations in which it gives us less error than traditional methods such as Newton – Raphson , Gauss – Seidel, Jacobian and so on. Don't worry, if you have not any knowledge about traditional methods. Dive into new technology.

Example: A Model to Track the Location of a Particle in the Space

One of the most important needs for many projects is, quickly to track the motion of a particle when

it is tripping between two points in the space. For instance, suppose particle P is moving by velocity “V” with accelerate equal to zero from point A (x1, y1, z1) to point B (x2, y2, z2). We want to know the coordination of P (x, y, z) at the moment of “t” when it is moving in direction of A to B. This model gives us the opportunity to obtain the coordination P (x, y, z) only by click. In fact, if we have the coordination P (x, y, z), it will be as an index for us that other particles which are moving from A to B such as P1, P2, …. are not tripping in the exact direction of A to B. In this case, we have to solve a system of two nonlinear equations as follows:

First of all, we should define amount of “a” and “b” as follows:

The distance of point A to point B is calculated by using below formula and also “X” is the distance that particle P will travel after time “t” in direction of A to B:

Therefore, we should solve below system of two nonlinear equations

Below figure as well as shows you the components of this model

Let me explain you about the components of above model as follows:

1. In right side on cells G4:J10, we have inputs including the coordination points A and B, velocity of particle P (v), the time after staring to travel particle P (t) and Error which is the difference between the results. So, X = v.t, d = distance between point A and B and on cell G10, I have included a logic formula (=if (H8 >= H9, H8, 0)). It means, if X = 0 then the particle has passed point B

2. In left side on cells C5:E6, we have other inputs including the ranges to reach to the answer for coordination particle P (x, y, z) which is the solution for system of two nonlinear equations.
Here, there are lower and upper ranges which are changed by click on cell A2 and also this change will again go back by click on cell B2 (Go & Back).

This part has been utilized by the method stated in article of “Can We Solve a Nonlinear Equation with Many Variables?” posted on link:
http://emfps.org/2016/10/can-we-solve-nonlinear-equation-with.html

3. On cells C9:E9, we have outputs which are the answer to above

system of two nonlinear equations.

4. On cells C12:E13, we have Control (1) where first equation is solved by using the coordination A

and P and it is compared with amount of “X^2” on cell C14. So, second equation is solved by using the coordination B and P and it is also compared with amount of “(d-X)^2”on cell C15. The differences have been mentioned on cell G12 and G13 as the errors.

5. On cells E15:G17, we have Control (2) which is referred to track the directions in which we are willing to know if the motion of particle P is in direction from point A to point B. In this case, a control can be conducted by using below formulas: