Need a book? Engineering books recommendations...

# RE: Matrix Stiffness Method with Spreadsheets

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

```While learning VBA is a worthwhile endeavor (you can use that skill with
several programs), you DON'T need to know it to do matrix structural
analysis using Excel.

Regards,

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

:-----Original Message-----
:From: G M [mailto:newabhaju(--nospam--at)hotmail.com]
:Sent: Thursday, June 19, 2003 9:30 AM
:To: seaint(--nospam--at)seaint.org
:Subject: RE: Matrix Stiffness Method with Spreadsheets
:
:
: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>
:>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?
:>:
:>: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
:>:*   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
:>*   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
:*   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