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]
• To: seaint(--nospam--at)seaint.org
• Subject: Re: Matrix Stiffness Method with Spreadsheets
• From: Daryl Richardson <h.d.richardson(--nospam--at)shaw.ca>
• Date: Thu, 19 Jun 2003 10:37:14 -0600

```Ed,

It's possible to develop matrix solutions for structural problems
within some spreadsheet programs.  Whether Excel is one of those programs
or not I don't know.  If you want ot try this I can recommend a textbook,
"STRUCTURAL ANALYSIS, A Unified Classical And Matrix Approach" by A Ghali
and A.M. Nevil, published by Chapman and Hall; it's a good reference even
if you don't want to do this.

I would suggest, however, that you will find this (matrix) task
much more bothersome than your present approach.  If you really want to
develop your own programs you might want to try moment distribution
analysis for your simple problems: it's simple; it's direct, and it's as
accurate as the number of iterations you choose to use.

Regards,

H. Daryl Richardson

Ed Tornberg wrote:

> 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
******* ****** ****** ****** ******* ****** ****** ********

```