Re: Survey for Special Math Problem Message #8 Posted by Namir on 3 June 2012, 9:46 p.m., in response to message #7 by Les Wright
To solve the nonlinear/hybrid system, here is the core steps expressed in Excel VBA:
For J = 1 To N
Sum = B(J)
For I = 1 To N
If I <> J Then
Sum = Sum - A(J, I) * X(I)
End If
Next I
X(J) = Sqr(Sum / A(J, J))
Next J
The core steps of the Gauss-Seidel for linear systems is:
For J = 1 To N
Sum = B(J)
For I = 1 To N
If I <> J Then
Sum = Sum - A(J, I) * X(I)
End If
Next I
X(J) = Sum / A(J, J)
Next J
Since we using the squares of the variables n the diagonal elements, calculating them iteratively would require the square root values of Sum/A(I,I).
Using the minor modification of the first code snippet allows Gauss-Seidel method to work with the nonliner/hybrid system of equations.
Namir
|