Article View: comp.apps.spreadsheets
Article #43Re: Ssheets & simultaneous equations -- ANY HINTS ?y
From: Yu-Kang J Chen
Date: Mon, 03 Aug 1992 22:00
Date: Mon, 03 Aug 1992 22:00
23 lines
1618 bytes
1618 bytes
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
Technical Details
Message-ID:
<BsFEDr.662@acsu.buffalo.edu>Path:
arc1-ca.pugleaf.net!sparky!uunet!cs.utexas.edu!sun-barr!ames!haven.umd.edu!darwin.sura.net!zaphod.mps.ohio-state.edu!ub!acsu.buffalo.edu!ubvmsd.cc.buffalo.edu!v116qg42References:
<mst.712611829@sanjuan> <1992Aug2.152430.27162@usenet.ins.cwru.edu> <1992Aug3.103537.1@kean.ucs.mun.ca>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!cs.utexas.edu!sun-barr!ames!haven.umd.edu!darwin.sura.net!zaphod.mps.ohio-state.edu!ub!acsu.buffalo.edu!ubvmsd.cc.buffalo.edu!v116qg42 From: v116qg42@ubvmsd.cc.buffalo.edu (Yu-Kang J Chen) Newsgroups: comp.apps.spreadsheets Subject: Re: Ssheets & simultaneous equations -- ANY HINTS ?y Message-ID: <BsFEDr.662@acsu.buffalo.edu> Date: 3 Aug 92 22:00:00 GMT References: <mst.712611829@sanjuan> <1992Aug2.152430.27162@usenet.ins.cwru.edu> <1992Aug3.103537.1@kean.ucs.mun.ca> Sender: nntp@acsu.buffalo.edu Organization: University at Buffalo Lines: 23 News-Software: VAX/VMS VNEWS 1.41 Nntp-Posting-Host: ubvmsd.cc.buffalo.edu