Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Math Software

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Title: RE: Math Software
That is how you execute an array formula in excel.
 
-gerard
SJ, CA
-----Original Message-----
From: Mitchell J. Sklar [mailto:MJS(--nospam--at)bala.com]
Sent: Tuesday, October 02, 2001 10:22 AM
To: seaint(--nospam--at)seaint.org
Subject: RE: Math Software

What is the <Ctrl> <Shift> <Enter>  about?
 

Mitchell J. Sklar, P.E.
Senior Structural Engineer

BALA Consulting Engineers, Inc.
(mjs(--nospam--at)bala.com)
p 610-649-8000 x345
f 610-649-8475

-----Original Message-----
From: Andrew Mole [mailto:Andrew.Mole(--nospam--at)arup.com]
Sent: Tuesday, October 02, 2001 12:45 PM
To: 'seaint(--nospam--at)seaint.org'
Subject: RE: Math Software

I am interested that no-one has mentioned using Excel for matrices. It is fairly basic, but it will do matrix addition, subtraction, multiplication, inversions and determinants. If that is all you want it for and you have the program already then there is no need to pay for anything else. Obviously it doesn't lay things out as beautifully as MathCAD and isn't as powerful as MatLab (or Mathematica or Maple), but as a student that may not matter. Excel also has a fairly powerful optimization function that will allow you to solve for a number of variables.

The relevant functions are "+", "-", MMULT(), MINVERSE() and MDETERM(). Remember to select an range with the appropriate dimensions before entering the formula, and then press <Ctrl> <Shift> <Enter> rather than just <Enter>.

Andrew Mole