Need a book? Engineering books recommendations...

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

Re: Structural Engineering Spreadsheets

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Since we are on spreadsheets, I was looking at one that contained an equation solving routine called "shooting method". It is not explained in the spreadsheet and what I have looked up does not help. Can somebody explain it to an OF (old wind-breaker)?

Shaun Dustin wrote:

You can go to the Engineering-International website and download samples. The actual spreadsheets are identical except for the unlocking of some input cells—WYSWYG.

I just run a hand check of the spreadsheet the first time I use it. The code methods are documented in the spreadsheet, and if you’re used to doing it by hand it’s no big deal to do this. The hidden formulas should give exactly the same result as the code equations. You can try several cases to make sure you’re happy with the results. After I am satisfied, I print the spreadsheet calc, staple it to my hand calc, and put them both in a file for calculation template documentation. If I had a problem with numbers that didn’t match, I would contact EI—hasn’t been necessary so far.

Shaun Dustin, MS, PE

Doctoral Candidate

USTAR Biofuels Initiative

Utah State University
4130 Old Main Hill
Logan, UT 84322

sdustin(--nospam--at) <mailto:sdustin(--nospam--at)>



*From:* Garner, Robert [mailto:rgarner(--nospam--at)]
*Sent:* Monday, November 05, 2007 8:10 AM
*To:* seaint(--nospam--at)
*Subject:* RE: Structural Engineering Spreadsheets

I don't mind they're being locked but can you see the formulas to verify the answers or do you have to believe that all the formulas are correct?


Bob Garner, S.E.


*From:* Christopher Banbury [mailto:cbanbury(--nospam--at)]
*Sent:* Friday, November 02, 2007 7:42 AM
*To:* seaint(--nospam--at)
*Subject:* RE: Structural Engineering Spreadsheets

We have the entire suite of EI spreadsheets and use them whenever we can. They are locked and cannot be modified so they don’t fit every application but they save a lot of time when they match the design scenario. I have only found one error in the code since I have been using them although I have not used all of them yet. The woodbeam.xls does not report the correct Fb for timbers thicker than 2”. I pointed this out and they sent me a corrected spreadsheet the same day.

They are really just one more tool in the box but not a stand-alone solution in my opinion.

Christopher Banbury, PE


Ark Engineering, Inc.

PO Box 10129, Brooksville, FL 34603

22 North Broad ST, Brooksville, FL 34601

Phone: (352) 754-2424

Fax: (352) 754-2412 <>

The information contained in the e-Mail, including any accompanying documents or attachments, is from Moffatt & Nichol and is intended only for the use of the individual or entity named above, and is privileged and confidential. If you are not the intended recipient, be aware that any disclosure, dissemination, distribution, copying or use of the contents of this message is strictly prohibited. If you received this message in error, please notify us.

******* ****** ******* ******** ******* ******* ******* ***
*   Read list FAQ at:
* * This email was sent to you via Structural Engineers * Association of Southern California (SEAOSC) server. To * subscribe (no fee) or UnSubscribe, please go to:
* Questions to seaint-ad(--nospam--at) Remember, any email you * send to the list is public domain and may be re-posted * without your permission. Make sure you visit our web * site at: ******* ****** ****** ****** ******* ****** ****** ********