Need a book? Engineering books recommendations...

# RE: Calculation Software

• Subject: RE: Calculation Software
• From: Christopher Wright <chrisw(--nospam--at)skypoint.com>
• Date: Wed, 21 Jul 04 11:54:48 -0500

```>I have seen it referenced, but as an old f--t,
>I don't have a clue.
Old farts have their uses...

Looping macros are easy, like this one. This does the parsing operation
for a specified number (Nelem) of rows

=SET.NAME("Nelem",INPUT("Format how many nodes?",1,"Grid force format"))
=WHILE(Nelem>0)
=PARSE("[      ][     183][  SHELL4    ][0.650297E-01][ -.187117E-01][
-.980578E+01][ 0.149528E-01][ -.784487E+00][ 0.128183E-02]")
=SELECT("R[1]C")
=NEXT()

Doing it with a macro is the most straightforward way, but sometimes you
can have Excel iterate on a circular reference--a pair of cells with the
result of each depending on the result of the other. Excel issues an
done this a couple of times so I didn't have to write a macro, but it
only works when you've set up the circular reference so it converges.

Christopher Wright P.E.    |"They couldn't hit an elephant at
chrisw(--nospam--at)skypoint.com        | this distance"   (last words of Gen.
___________________________| John Sedgwick, Spotsylvania 1864)
http://www.skypoint.com/~chrisw

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