Tuesday, November 6, 2007

Re: Structural Engineering Spreadsheets

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)?
Gary

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@cc.usu.edu <mailto:sdustin@dustinengineers.net>
>
> 435-770-7816
>
> ------------------------------------------------------------------------
>
> *From:* Garner, Robert [mailto:rgarner@moffattnichol.com]
> *Sent:* Monday, November 05, 2007 8:10 AM
> *To:* seaint@seaint.org
> *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?
>
> Thanks.
>
> Bob Garner, S.E.
>
> ------------------------------------------------------------------------
>
> *From:* Christopher Banbury [mailto:cbanbury@arkengineering.net]
> *Sent:* Friday, November 02, 2007 7:42 AM
> *To:* seaint@seaint.org
> *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
>
> President
>
> Ark Engineering, Inc.
>
> PO Box 10129, Brooksville, FL 34603
>
> 22 North Broad ST, Brooksville, FL 34601
>
> Phone: (352) 754-2424
>
> Fax: (352) 754-2412
>
> www.arkengineering.net <http://www.arkengineering.net>
>
> 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: http://www.seaint.org/list_FAQ.asp
*
* This email was sent to you via Structural Engineers
* Association of Southern California (SEAOSC) server. To
* subscribe (no fee) or UnSubscribe, please go to:
*
*

http://www.seaint.org/sealist1.asp
*
* Questions to seaint-ad@seaint.org. 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: http://www.seaint.org

******* ****** ****** ****** ******* ****** ****** ********