02/03/2007 Copyright 2000-2007 Chris Buczkowski. All rights reserved. STEEL BEAM FOR MICROSOFT EXCEL ****************************** VERSION 2.03 CONTENTS ******** I Setup II Getting Started III Spreadsheet Information IV Latest Version V Registration VI Disclaimer I SETUP ************* Place the steel beam.xls in any directory of your choice, e.g. C:\My Documents. For ease of access you may place the spreadsheet in the TEMPLATES folder of the folder in which you installed Microsoft Office or Microsoft Excel. This spreadsheet has been formatted using Arial, Arial Black, Tahoma and Symbol TrueType fonts. This spreadsheet has been optimised for a screen resolution of 1024x768 HiColor 16 bit) using large fonts. Right click on the main Windows desktop, click on Properties and go to Settings to adjust (or see Screen Resolution below). Sheet Tabs should be enabled. Go to Tools > Options > View Remember! If you are using 256 colour, change to Hicolor (16 bit). SCREEN RESOLUTION Although this spreadsheet has been optimised and thoroughly tested out on a resolution of 1024x768 using large fonts, it has also been tested using other combinations of 1024x768, 800x600, large fonts and small fonts. If you wish to use a combination other than the 1024x768 with large fonts, you may want to adjust Excel's display. Go to View menu > Zoom and adjust. Then save the spreadsheet (see Customisation on saving). II GETTING STARTED *********************** If you have placed steel beam.xls in your TEMPLATES folder then, to use, open up Excel and click on the FILE menu and then on NEW. Steel Beam will be displayed under the general tab with the name steel beam.xls. Click on steel beam.xls and then on OK. If you have placed Steel Beam in a folder other than the TEMPLATES folder, then click on the FILE menu and then on OPEN. Navigate to the directory where the spreadsheet resides, click on 'steel beam.xls' and then on OPEN. CUSTOMISATION To customise Steel Beam spreadsheet with your own Zoom settings, adjust the display and then hit the SAVE button. If you have placed 'steel beam.xls' in the TEMPLATES folder, hit the SAVE button. Then, navigate back to the TEMPLATES folder, change the file name back to 'steel beam.xls' and hitting the SAVE button overwrite the copy of Steel Beam already there. COMPANY DETAILS Enter your company name and other details in the title block on the first sheet only. This is the 'Not Full Restraint' sheet. The details will be automatically copied to the other sheets. Company details cannot be entered in the other sheets directly. III SPREADSHEET INFORMATION ******************************* This spreadsheet performs an analysis and design of simply supported and cantilever, steel beams bending about their X-X axis and subjected to gravity loads. Design is in accordance with BS 5950-1:1990. Bending moments, shear forces and deflections are computed at 1/60th positions along the span and the maximums of these values are used for the design. The equations for the analysis have been obtained from the Reinforced Concrete Designer's Handbook by Reynolds and Steedman. Self weight of the steel section is automatically included in the calculations. The moment capacity of the section is calculated taking into account the corresponding shear force and a reduction is made as necessary. A check is made to see if a shear bucking calculation is required and a warning is issued. This spreadsheet also contains a calculation sheet for checking local web bearing and buckling. The spreadsheet uses steel section properties which have been directly obtained from the Corus Construction Manual, released on CD in February 2000. The values were imported into Microsoft Excel v8.0 from the html tables contained on the Corus CD. No typing in of values has been carried out and therefore these tables should accurately reflect the tables as published by Corus. IV LATEST VERSION ********************** Please ensure you have the latest version of this software, which may be downloaded from : http://www.structural-engineering.org.uk/ If you have comments, suggestions, bug reports or require further information, please email: info@structural-engineering.org.uk V REGISTRATION ******************** ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- REGISTRATION: Single user licence 40 Pounds Multi-user licences 40 Pounds per copy installed Delivery will be by attachment to an email. To order a copy, please send a cheque payable to 'C. Buczkowski' to the following address: Flat 708 100 Kingsway North Finchley LONDON N12 0EQ Tel nos: 07939-187549 / 020-8343 9844 email: chris@buczkowski.freeserve.co.uk You should include your email or postal address and a contact telephone number. Also include the name you require the spreadsheet registered to (30 characters maximum). ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- LICENSE FOR USE AND DISTRIBUTION This spreadsheet is NOT a public domain program. It is copyrighted by the Author*. This software is protected by United Kingdom copyright law and also by international treaty provisions. The Author grants you a license to use this software for evaluation purposes for an indefinite period. You may not use, copy, rent, lease, sell, modify, decompile, unprotect, disassemble, otherwise reverse engineer, or transfer this software except as provided in this agreement. Any such unauthorised use shall result in immediate and automatic termination of this license. All rights not expressly granted here are reserved to the Author. You may copy and distribute the UNREGISTERED version of this spreadsheet, completely unaltered, without further permission. This readme.txt file MUST accompany any copies of the spreadsheet. * The Author is CHRIS BUCZKOWSKI FONTS Arial and Arial Black are provided free by Microsoft Corporation. They may be downloaded from: http://www.microsoft.com/typography/fontpack/ Microsoft also provide Tahoma which can be downloaded from: http://support.microsoft.com/support/kb/articles/Q175/0/15.asp VI DISCLAIMER ****************** THIS SOFTWARE IS PROVIDED FOR EVALUATION ONLY, ON AN "AS IS" BASIS. THE AUTHOR DISCLAIMS ALL WARRANTIES RELATING TO THIS SOFTWARE, WHETHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. THE AUTHOR* SHALL NOT BE LIABLE FOR ANY INDIRECT, CONSEQUENTIAL, OR INCIDENTAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE SUCH SOFTWARE, EVEN IF THE AUTHOR HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES OR CLAIMS. THE PERSON USING THE SOFTWARE BEARS ALL RISK AS TO THE QUALITY AND PERFORMANCE OF THE SOFTWARE. ALTHOUGH EVERY EFFORT HAS BEEN MADE TO ENSURE THE ACCURACY OF THIS PROGRAM, USERS SHOULD VERIFY THE RESULTS FOR THEMSELVES. ** END **