Monday, November 5, 2007

RE: Structural Engineering Spreadsheets

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

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