🚀 go-pugleaf

In article <mst.712611829@sanjuan> mst@sanjuan.UVic.CA (Marc Stadelmann) writes:
>
>Hi there,
>
>I am looking for a spreadsheet (or spreadsheet extension) 
>that solves simultaneous equations (or systems of equations).
>
>Does anybody know of any software or description of any such
>product?
>
>-- Marc
>
>
>Please reply to:	mst@sanjuan.uvic.ca


Microsoft Excel has a macro function "MINVERSE(array)"  which returns the
matrix inverse of an array.  Also "MMULT(array)".  This should solve your
problem.

Rob Lake
BP Research
lake@rcwcl1.dnet.bp.com

>>
>>I am looking for a spreadsheet (or spreadsheet extension) 
>>that solves simultaneous equations (or systems of equations).
 
> Microsoft Excel has a macro function "MINVERSE(array)"  which returns the
> matrix inverse of an array.  Also "MMULT(array)".  This should solve your
> problem.
> 
Quattro (and 123, I think) have matrix inverse and multiply commands as well.
In quattro see Tools/Advanced Math; in 123 see ???

John Garland
jgarland@kean.ucs.mun.ca

In article <1992Aug3.103537.1@kean.ucs.mun.ca>, jgarland@kean.ucs.mun.ca writes:
>>>
>>>I am looking for a spreadsheet (or spreadsheet extension) 
>>>that solves simultaneous equations (or systems of equations).
>  
>> Microsoft Excel has a macro function "MINVERSE(array)"  which returns the
>> matrix inverse of an array.  Also "MMULT(array)".  This should solve your
>> problem.
>> 
> Quattro (and 123, I think) have matrix inverse and multiply commands as well.
> In quattro see Tools/Advanced Math; in 123 see ???
> 
> John Garland
> jgarland@kean.ucs.mun.ca

XESS from Applied Information Systems includes a number of matrix-valued
functions called embedded tools.  These functions return a matrix 
of values rather than a single value like most spreadsheet functions.  The
advantage of this technique is that recalcs automatically update values 
just like for other functions.  You don't have to wait to execute a command
or macro to get your results.

Embedded tools (functions) include:

	DFT,FFT,INVDFT,INVFFT	Discrete and Fast Fourier Transforms
	MMUL,INVERT		Matrix multiply, inverse,
	TRANSPOSE		      and transpose
	EIGEN			Eigenvalues of matrix

plus a variety of tools that fit curves, etc.

XESS provides a variety of other features for scientific/engineering
applications and a full client/server API for integrating with other
applications.

Arthur Coston
Applied Information Systems
arthur@ais.com

In article <1992Aug3.103537.1@kean.ucs.mun.ca>, jgarland@kean.ucs.mun.ca writes...
>>>
>>>I am looking for a spreadsheet (or spreadsheet extension) 
>>>that solves simultaneous equations (or systems of equations).
> 
>> Microsoft Excel has a macro function "MINVERSE(array)"  which returns the
>> matrix inverse of an array.  Also "MMULT(array)".  This should solve your
>> problem.
>> 
>Quattro (and 123, I think) have matrix inverse and multiply commands as well.
>In quattro see Tools/Advanced Math; in 123 see ???
> 
>John Garland
>jgarland@kean.ucs.mun.ca

In 123 2.x see DATA/MATRIX.
In version 2.2 the row number + colume number must be smaller than 8192.
I don't know whether this limit is lifted in newer version.
Anyway, all serious spreadsheet can do matrix multiple and inverse at least.
Excel will calculate matrix determinant using a built-in function, but
123 and Quattro won't (maybe someone can do it by macro).

 YK Chen