You have downloaded this file 0 times in the last 24 hours, limit is 100.
Your file downloads total 0 in the last 24 hours, limit is 20.

Grating Strength
 
This location is for Registered Users Only.
Perhaps you need to login or register.

Description:
Calculation Preview








"GRATING" --- GRATING ANALYSIS / DESIGN

Program Description:

"GRATING" is a spreadsheet program written in MS-Excel for the purpose of analysis and design of welded steel grating and fabricated aluminum bar grating.  Specifically, light duty steel or aluminum grating covered floors, platforms, walkways, trenches, etc. subjected to uniformly distributed gravity loading (dead + live), along with a concentrated line load may be analyzed.  Light duty steel or aluminum grating may also be analyzed for an imposed wheel or post load.  Heavy duty steel grating may be analyzed for vehicular wheels loads from either lift trucks with designated capacity or from AASHTO truck loading (H-20 and H-15).  Bending stresses and deflections are checked against allowable values.  Allowable load tables for grating are included for quick selection of grating size or clear span based on either uniformly distributed  or concentrated line loading, and allow for user input of a clear span value not specifically noted in the tables.

This program is a workbook consisting of nine (9) worksheets, described as follows:

Worksheet NameDescription
DocThis documentation sheet
Light Duty Steel - Light duty welded steel grating analysis and design
Light Duty Steel (wheel or post) - Light duty welded steel grating analysis and design for wheel or post load
Heavy Duty Steel - Heavy duty welded steel grating analysis and design
Heavy Duty Steel (wheel) - Heavy duty welded steel grating analysis and design for wheel load
Light Duty Steel Table - Light duty welded steel grating allowable load table
Aluminum - Light duty aluminum bar grating analysis and design
Aluminum (Wheel or Post) - Light duty aluminum bar grating analysis and design for wheel or post load
Aluminum Table - Light duty auminum bar grating allowable load table

Program Assumptions and Limitations:

1.  This program is based on the following references:
         a. "Product Catalog - Architectural & Industrial Grating Solutions" - by Ohio Gratings, Inc., July 2005
         b. "PIP STE05530 - Grating Design Guide" - by Process Industry Practices, Oct. 2007
         c. "Metal Bar Grating Engineering Design Manual" MBG 534-12 by National Association of Architectural Metal Manufacturers (NAAMM)
2.  This program handles welded steel grating of the following types/styles: 
         a. Light Duty Type W-19-4 (bearing bars spaced at 1-3/16" (19/16") o.c. and cross bars spaced at 4" o.c.)
         b. Heavy Duty Type W-19-4 (bearing bars spaced at 1-3/16" (19/16") o.c. and cross bars spaced at 4" o.c.)
3.  This program handles aluminum bar grating of the following type/style: 
         a. Type W-19-4 (bearing bars spaced at 1-3/16" (19/16") o.c. and cross bars spaced at 4" o.c.)
4.  While the user can quickly and easily make a grating selection based on the applied loads directly from the 
         a grating vendor catalog, the four (4) calculation-type worksheets in this workbook provide the user with the ability to demonstrate the selection and analysis with actual calculations if desired or required.
5.  In the "Light Duty Steel Table" and the "Aluminum Table" worksheets, after the design load is determined, the Tables may be used to quickly determine the required grating size and/or support beam spacing.
6.  In the "Light Duty Steel Table" and the "Aluminum Table" worksheets, just to the right of the Tables, the user may input a specific clear span length, 'L', to calculate the allowable loads and actual deflections for that specified value.

Calculation Reference
Structural Steel Design
Grating Strength
Structural Aluminium Design

Submitted By:
Alex Tomanovich (ATomanovich)
Submitted On:
09 Mar 2015
File Size:
3,442.50 Kb
Downloads:
260
File Version:
1.2
File Author:
Alex Tomanovich
Rating:
Total Votes:5
Comments: 2
ATomanovich 4 years ago
It was brought to my attention that there was the same text display typo error in each of the calculation worksheets of the "GRATING.xls" workbook.
In the results section and under "Properties", I had inadvertently displayed "Fb = ...." for the modulus of elasticity (E), when it obviously should have been displaying "E = ......". The input data text description was correct, so it was just the text to the right of the input cell that was in error. Kind of surprising that I missed that, and on every sheet no less, but not too surprising that I was consistent through all of the calculation worksheets. There's something to be said for consistency, right? (lol)
I have made the corrections and this workbook is now version 1.2.
ATomanovich 4 years ago
It was brought to my attention in the "Heavy Duty Steel" worksheet of the "GRATING.xls" workbook that the user could not select potentially any one of all of the available heavy duty grating sizes that were listed in the table.
I had inadvertently stopped the input data validation pick box list at Cell L20, when it should have continued all the way down to Cell L50, to include all of the sizes. The rest of the selection pick boxes in the other worksheets were all right.
I have made this correction, and the new version of this workbook is now 1.1.

We have 156 guests and 4 members online

Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.