Chris Buczkowski,
the original author of this workbook created it in
June 2000 by importing the values (dimensions and
properties) for the steel sections into Microsoft
Excel v8.0 from the html tables contained on the Corus
Construction Manual released on CD in February 2000.
You can download a copy of the Corus Construction
Manual from: http://www.corusconstruction.com/
I downloaded the
workbook from Chris' very useful website located at
http://www.structural-engineering.fsnet.co.uk/
and noticed the following statement he made in the
"Notes" spreadsheet of the workbook: "The
dimensions and properties for the steel sections in
these tables apply to the UK only... These tables
are freely supplied as a service for developers creating
structural engineering spreadsheets. They may be copied
to new workbooks and used for developing spreadsheets
for the design of structural steelwork".
Armed with the
above information, I immediately began evaluating
the large workbook for possible areas I could add
value to it. I soon noticed how laborious it would
be for users to "read off" values from the
various tables in the workbook. A menu-driven query
interface I thought, would take the drudgery out of
that process.
So, I proceeded
to add this interface - which now drastically reduces
the time and effort taken to retrieve various values
from five(5) of the tables in the workbook. To elaborate,
the interface makes it unnecessary for a user to navigate
around any of the five(5) tables to "read off"
any values.
To understand
what I mean, download the workbook. It remains exactly
as Chris created it, except that I have added a "Query"
worksheet with Excel VB driven drop menus which interact
with Index/Match formulas to demonstrate the one-screen
data retrieval capability it now possesses. If you
can spare the time, let
me know what you think by filling/submitting this
contact form :-)))
<<Download
Structural Steel Sections Auto-Query Workbook>>
Back
to top
