Need a book? Engineering books recommendations...

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

In house spreadsheet calcs.

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Thanks for comments.
Would you send me the "spread sheet calc. and the database from AISC." 
We also have timber, steel, Concrete and ... on Lotus 123 that can send you.
Let me know.

Thanks in advance
Kasey Hemmatyar, P. Eng. (structural)
Vancouver, B.C.
_________________________message separator_________________
>We use a Lotus spreadsheet for most of our calcs, including steel beams.  I
>have incorporated the relevant portions of the steel tables (I and S) directly
>into the spreadsheet so that I don't have to read from an external database.
>The spreadsheet calcs the beam for moment and deflection and then picks the
>lightest beam within the family (W12x, etc.) that you specify.  We also have a
>version that calcs tubes and pipes.  Even with a good chunk of the steel table
>actually in the spreadsheet, the file size in still relatively small (36Kb).
>For the record, I did not enter all the steel properties by hand, but got a
>database of them on disk from AISC.  The database includes, I think, every
>property and dimension for every steel shape that is in the AISC manual.  I,
>of course, hacked away at this to only keep the pieces I needed for my beam
>I embedded everything in the spreadsheet because the first version of this
>spreadsheet was written for Lotus for DOS about 10 years ago when "linking"
>was not even a remote option.  Anyway, I still use the spreadsheet today with
>only minor modifications through the years, running Lotus for DOS through a
>Win95 environment.  The rest of my office, though, has upgraded to Lotus for
>Windows and it runs fine there, too.  If you translate it to Quattropro you
>may lose some of the macro formatting.
>Let me know if this helps, or if you want to see a copy of the spreadsheet.
>Bruce Resnick, SE
>Parker Resnick Str. Eng.