Need a book? Engineering books recommendations...

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

RE: Matrix Stiffness Method with Spreadsheets

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Ed:

To add to Bill Allen's email - the basic is to learn the matrix analysis method. If you want to do fancy stuff in excel, learn to write macros in visual basic. It is not as difficult as it sounds - especially with the current editions of Excel. If you have had any programming experience in any language, you will have very little difficulty.

For continuous beams - calculate the formulae by hand using basic mechanics principle and program excel and forget about macros and matrix.

Good Luck.

Gautam


From: "Bill Allen" <T.W.Allen(--nospam--at)cox.net>
Reply-To: <seaint(--nospam--at)seaint.org>
To: <seaint(--nospam--at)seaint.org>
Subject: RE: Matrix Stiffness Method with Spreadsheets
Date: Thu, 19 Jun 2003 09:02:30 -0700

Ed-

I agree with all of your points, especially for small models (single bay
braced and moment frames, etc.)

You only need to learn two new functions in Excel:

MINVERSE and MMULT

These two functions take the inverse of a matrix (Excel calls 'em
arrays) and MMULT multiplies two matrices. Once you highlight the
regions you want to operate, then, instead of just hitting the "enter"
key, hold down the "control" and "shift" keys while you press the
"enter" key. Some wizards have suggested that it helps to close one eye
and stick your tongue out just right, but I have yet to see the benefit
of this.

Second, you can learn enough about matrix structural analysis in a
weekend if you get the book creatively titled "Structural Analysis", by
Russell C. Hibbeler, 3rd Ed. Chapters 13, 14 and 15 are all you need to
study.

Happy vectorializing!

Regards,

T. William (Bill) Allen, S.E. (CA #2607)
V/F (949) 248-8588
San Juan Capistrano, CA




:-----Original Message-----
:From: Ed Tornberg [mailto:edt(--nospam--at)blazerind.com]
:Sent: Thursday, June 19, 2003 8:17 AM
:To: seaint(--nospam--at)seaint.org
:Subject: Matrix Stiffness Method with Spreadsheets
:
:
:I'm tired of the inefficiency of transferring data back and
:forth between my FEA program (RISA) and Excel.  I have to use
:the FEA program to get the member results for things like
:continuous roof or floor beams, and have to use the
:spreadsheet to put in all the load work-ups and other
:commentary you need to have in the calcs.  Is there a simpler
:way for "simple" things like 2-D continuous beams?
:
:Can you write the matrix stiffness method into Excel?  Are
:there any references for this?
:
:Or what would be the best FEA program to integrate with Excel?
:
:What about Mathcad?  I tried it for other things and frankly
:got tired of it's tendency to crash if you put too many
:spreadsheets or other program objects into it.
:
:Ed Tornberg, PE
:Blazer Industries, Inc.
:
:
:
:
:******* ****** ******* ******** ******* ******* ******* ***
:*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
:*
:*   This email was sent to you via Structural Engineers
:*   Association of Southern California (SEAOSC) server. To
:*   subscribe (no fee) or UnSubscribe, please go to:
:*
:*   http://www.seaint.org/sealist1.asp
:*
:*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you
:*   send to the list is public domain and may be re-posted
:*   without your permission. Make sure you visit our web
:*   site at: http://www.seaint.org
:******* ****** ****** ****** ******* ****** ****** ********
:



******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
*
*   This email was sent to you via Structural Engineers
*   Association of Southern California (SEAOSC) server. To
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you
*   send to the list is public domain and may be re-posted
*   without your permission. Make sure you visit our web
*   site at: http://www.seaint.org
******* ****** ****** ****** ******* ****** ****** ********

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail


******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at: http://www.seaint.org/list_FAQ.asp
* * This email was sent to you via Structural Engineers * Association of Southern California (SEAOSC) server. To * subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
* Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you * send to the list is public domain and may be re-posted * without your permission. Make sure you visit our web * site at: http://www.seaint.org ******* ****** ****** ****** ******* ****** ****** ********