Need a book? Engineering books recommendations...

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

RE: Calculation Software

[Subject Prev][Subject Next][Thread Prev][Thread Next]
>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 
alert message and iterates automatically usually about 100 times. I've 
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 
*   without your permission. Make sure you visit our web 
*   site at: http://www.seaint.org 
******* ****** ****** ****** ******* ****** ****** ********