Need a book? Engineering books recommendations...

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

RE: Fwd: MS Excel - iteration

[Subject Prev][Subject Next][Thread Prev][Thread Next]
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 

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


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) [mailto:seaint-seaosc(--nospam--at)] On 
Behalf Of Gary L. Hodgson and Assoc. Sent: Thursday, January 03, 2013 5:04 
AM To: seaint-seaosc(--nospam--at)
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.


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: 

The email messages sent to the list will be saved in an archive on the World Wide Web.
These archives are located at:

To contact the list owner, send your message to:

5700 Ralston Street, Suite 300, Ventura, CA 93003

To unsubscribe, switch to/from digest, get on/off vacation, or change your email address, click here.