Need a book? Engineering books recommendations...

# RE: Fwd: MS Excel - iteration

• To: seaint-seaosc(--nospam--at)mail-list.com
• Subject: RE: Fwd: MS Excel - iteration
• From: "T. William \(Bill\) Allen, S.E." <Bill(--nospam--at)AllenDesigns.com>
• Date: Thu, 3 Jan 2013 12:40:14 -0800
• Authentication-results: cox.net; auth=pass (LOGIN) smtp.auth=t.w.allen(--nospam--at)cox.net
• List-subscribe: <mailto:SEAINT-SEAOSC-on@mail-list.com>

```I'm not sure if I understand your problem correctly, if this is the same as
a beam of span "L" with two point loads, P1 and P2 separated by a distance
of "a", I would introduce another variable, "b" which would represent the
distance P1 is from the left support and then writethe equation for the
bending moment, shear and deflection of the beam in terms of L, a, b, P1
and P2. I would then create a column in Excel representing x/L in
increments of 0.01 (dividing the beam into 100points). The next column
would be x which would be the previous column multiplied by L. I would then
insert the expression for bending moment as the next column, shears as the
next column and deflections asthe next column. I would then set up
conditional formatting so that when values of bending moments, shears and
deflections exceeded the allowable, the values would be red and bold. After
this is set up, I would MANUALLY adjust "b" and watch the results. It
would take me probably 5 minutes to find the acceptable range of "b", if
any exists.

But, I'm sure you could pour hours into programming to find a more elegant
solution.

My two cents.

T. William (Bill) Allen, S.E. (CA #2607)

University of Southern California, M.S.C.E., 1983

University of Texas at El Paso, B.S.C.E., 1977

ALLEN DESIGNS

Consulting Structural Engineers

32302 Camino Capistrano, #206

San Juan Capistrano, CA 92675

V (949) 248-8588•F (949) 209-2509

-----Original Message-----
From: seaint-seaosc(--nospam--at)mail-list.com [mailto:seaint-seaosc(--nospam--at)mail-list.com] On
Behalf Of Gary L. Hodgson and Assoc. Sent: Thursday, January 03, 2013 5:04
AM To: seaint-seaosc(--nospam--at)mail-list.com
Subject: Re: [SEAINT-SEAOSC] Fwd: MS Excel - iteration

Thanks, David,

Still early days. I looked up Goal Seeker to see what it does but I am
still thinking how to approach this.

My customer has two 12.5 ton cranes but with different wheel loads and
wheel bases for each crane.  The problem is to space the 2 cranes far
enough apart to avoid over-stressing the runway, columns and/or footings,
which were all originally designed for 1 -10ton crane.

Gary

On 2012/12/31 11:46 AM, David Topete wrote:

> I assume you are using the 'goalseek' function? I set up a cell off

> the print area to use the goalseek function. Hope that helps.

>

Truncated 346 characters in the previous message to save energy.

-------------------------------------------------------------------------
Post your message to the list by sending it to:
SEAINT-SEAOSC(--nospam--at)mail-list.com.

The email messages sent to the list will be saved in an archive on the World Wide Web.
These archives are located at:
http://archive.mail-list.com/SEAINT-SEAOSC

To contact the list owner, send your message to:
SEAINT-SEAOSC-list-owner(--nospam--at)mail-list.com.

5700 Ralston Street, Suite 300, Ventura, CA 93003