Need a book? Engineering books recommendations...

# RE: Calculation Software

• To: <seaint(--nospam--at)seaint.org>
• Subject: RE: Calculation Software
• From: "Bill Allen, S.E." <T.W.Allen(--nospam--at)cox.net>
• Date: Wed, 21 Jul 2004 10:15:14 -0700

```Iteration by circular reference depends on how the program is setup.

Go to Tools, Options and click on the Calculation tab. If "Iteration" is not
checked, then you will get an error message regarding the circular
reference. You can also change the number of iterations. One needs to be
careful using circular references because you can get it to "bomb" pretty
easily (DAMHIK). Save often. You will always have a "calculate" at the
bottom of the screen even if your calculation mode is "automatic".

Another way (less volatile, but more manual) is using the Solver add-in.
Take the non-constrained flag pole equation. You have an initial depth, plug
it into the formula and come out with a required depth. You can create a
formula which is the difference between the two. Using solver, you can vary
the initial depth until the difference becomes zero. This is just an example
of using solver. There are other ways to solve for the depth of the footing.
I don't think Solver installs automatically. If you don't see it in your add
in list (Tools, Add-Ins must be checked), you need to check the box and
install it.

T. William (Bill) Allen, S.E. (CA #2607)
ALLEN DESIGNS
Consulting Structural Engineers
http://www.AllenDesigns.com
V (949) 248-8588	 .	 F (949) 209-2509

-----Original Message-----
From: Christopher Wright [mailto:chrisw(--nospam--at)skypoint.com]
Sent: Wednesday, July 21, 2004 9:55 AM
Subject: RE: Calculation Software

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