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: "Gary L. Hodgson and Assoc." <design(--nospam--at)hodgsoneng.ca>
• Date: Fri, 04 Jan 2013 13:59:39 -0500
• List-subscribe: <mailto:SEAINT-SEAOSC-on@mail-list.com>

```Bill et al,
```
I forgot to mention that the runway beams are continuous over 2 spans with equal and unequal spans. If it were a simple beam it would not be easy but a heck of a lot easier than continuous beams. In addition there are three different combinations of beam spans, combined with the different wheel loads and wheel spacings. What you have described may be something I programmed in Excel several years ago. For a simple beam, it was a fair bit of work and let's just say that it is an ongoing project.
```Gary

On 2013/01/03 3:40 PM, T. William (Bill) Allen, S.E. wrote:
```
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.
```
```
Truncated 1281 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