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]

For straight iteration, you can control the iteration functionality. This 
control is in a different place in Excel 2010 than 2007 and earlier. I 
don’t have a good feel for the Goal Seek functionality and will leave it 
to the accountants to play with. If you get into discrete conditions (e.g. 
as wheels pass support points) Goal Seek won’t help easily, anyway.

As Bill Allen pointed out, this could be handled by coding for 
manualiteration, unless you really want a generalized template for future 
projects. In that case, you may have better software than Excel in your 
toolkit, already.


Paul Ransom, P.Eng.


Paul Ransom Engineering

ph 905 639-9628


> Date: Thu, 03 Jan 2013 08:03:44 -0500
> From: "Gary L. Hodgson and Assoc." <design(--nospam--at)>
> 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: 

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.