Spreadsheet Tools for Linear Equations
The ubiquitous (and potentially dangerous!) spreadsheet
doe not have a standard facility fo solving sets of linear
algebraic equations. However, since these, if well posed,
do have an analytical solution, it is possible to program
thhis into spreadsheet cells. Since the solution is
very cumbersome, and impractical to produce manually,
we have produced a program to generate it.
Preprogrammed spreadsheets are available for the following
sizes of equation set:
.slk format -
2 ;
4 ;
6 ;
12 ;
18 ;
.xls format -
2 ;
4 ;
6 ;
12 ;
18 ;
You can use a larger solver than actually required by leaving
extra equations as `xi = 0'.
There is also an online facility to generate spreadsheets
here.