Page 430 - Excel for Scientists and Engineers: Numerical Methods

APPENDIX 3 CUSTOM FUNCTIONS HELP FILE 407

GaussSeidel
Solves a set of N linear equations in N unknowns by the Gaussian-Seidel method.
Returns the array of N unknowns, in column format only.

Syntax
Ga ussSeidel( coeff-matrix,const- vector, init- values)
coeff-matrix a reference to an N row x N column array of coefficients
const-vector a reference to an N row x 1 column array of constants
init-values a reference to an N row x 1 column array of initial values

Remarks
The coeff-matrix, const-vector and init-values tables can contain values or
formulas.
The optional init-values may be helpful for large arrays.
The GaussSeidel function is an array function. You must select an N row x 1 column
vertical range of cells, enter the function and then press CONTROL+SHIFT+ENTER
(Windows) or COMMAND+RETURN or CONTROL+SHIFT+RETURN (Macintosh).

See Also
GaussElim, GaussJordanl, GaussJordanZ, SimultEqNL

SimultEqNL
Solves a set of N non-linear equations in N unknowns by Newton’s iteration method.
Returns the array of N unknowns, in column format only.

Syntax
Si mu It EqN L( equations, variables, constants)
equations a reference to an N row x N column array of coefficients
variables a reference to an N row x 1 column array of constants
constants a reference to an N row x 1 column array of initial values

Remarks
The coeff-matrix, const-vector and init-values tables can contain values or
formulas.
The optional init-values may be helpful for large arrays.
The SimultEqNL function is an array function. You must select an N row x 1 column
vertical range of cells, enter the function and then press CONTROL+SHIFT+ENTER
(Windows) or COMMAND+RETURN or CONTROL+SHIFT+RETURN (Macintosh).

See Also
GaussElim, GaussJordanl, GaussJordanZ