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: Jeff Hedman <jeff_h(--nospam--at)lrpope.com>
• Date: Fri, 04 Jan 2013 09:14:24 -0700
• List-subscribe: <mailto:SEAINT-SEAOSC-on@mail-list.com>

```Gary,
I would also do what Bill suggests.  My beam spreadsheets I have programmed
operate this same way to generate shear and moment diagrams.  I only have
an equation written for shear.  Moment is determined by the area under the
shear curve.  Deflection is also based on the sheardiagram by using the
slope deflection and the second integral of themoment diagram.  Once it is
set up, you can easily modify it for point loads, tapered loads, and
uniform loads located at any location.  Then all you do is enter your
location of your points loads as they move across the beam.  Then you just
take note of the location for worst case shear, moment, and deflection and
determine if they are adequate.  You will still need to check the crane
rail beams for out of plane forces too.  AISC had at one time an excel
from their site for free to check some numbers on a crane rail beam I
designed once.  The file is called CraneBeam_v1_1.xls.  I'm not sure if
they still have it on their website, but that may be a good place to start.
I think it will only do one crane though, but it could assist you in
determining if the rail beams could take any extra at all.

Jeff Hedman

> Date: Thu, 03 Jan 2013 08:03:44 -0500
> From: "Gary L. Hodgson and Assoc." <design(--nospam--at)hodgsoneng.ca>
> Subject: Re: Fwd: MS Excel - iteration
>
> Thanks, David,
> Still early days. I looked up Goal Seeker to see what it does but Iam
> 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
>

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