| Tool Name | Description | Download | Developer | Date Added |
Download Count |
|---|---|---|---|---|---|
| 50% UDL | This spreadsheet helps the connection designer to quickly calculate the max beam reaction (before the beam failure under uniformly distributed load) for connection design purposes. The End reaction (which usually is 50% of the maximum uniform load) could be calculated for any length, any Fy. Some EOR requires more than 50% in this case we should just change the coefficient . "m" =1.2 for 60 %
This tool could be applied for Imperial format as well: 1.Convert the imperial format W10x45 to W250x67 2.Convert the beam length from ft to meters 3.Input the beam shape and length in the table 4.The calculated m*V(column #8) should be converted from kN-to Kips |
 |
Harry Aslanian |
2021 01 |
|
| ASCE705I | Analysis of ice loading on structural steel per ASCE 7-05 Code | |
Alex Tomanovich |
2018 07 |
|
| ASCE705S | Analysis of snow loading per ASCE 7-05 Code. | |
Alex Tomanovich |
2018 07 |
|
| ASCE710E | "ASCE710E" is a spreadsheet program written in MS-Excel for the purpose of seismic loading analysis for buildings and various non-building structures, as well as architectural, mechanical, and electrical components per the IBC 2012 and ASCE 7-10 Codes. Specifically, the total base seismic shear for buildings and non-building structures is calculated. For Multi-Level Buildings, the vertical distribution of the total seismic shear is also determined, and a drift analysis can also be performed.. The seismic restraint force for various components is also calculated. Seismic maps are also included. | |
David R Taylor |
2018 07 |
|
| ASCE710I | Workbook for ice load analysis on structural steel members, per the ASCE 7-10 code. Very similar to the workbook previously posted for the ASCE 7-05 code. | |
Alex Tomanovich |
2018 07 |
|
| ASCE710S | For snow load and snow drift analysis per the ASCE 7-10 code. Very similar to the workbook previously posted for ASCE 7-05, also available on this site. | |
Alex Tomanovich |
2018 07 |
|
| ASCE710W_v2.4 | "ASCE710W" (version 2.4) is a spreadsheet program written in MS-Excel for the purpose of wind loading analysis for buildings and structures per the ASCE 7-10 Code. Specifically, wind pressure coefficients and related and required parameters are selected or calculated in order to compute the net design wind pressures. Program is based on Alex Tomanovich's "ASCE705W" program and modified by David Taylor and William Fultz. Version 2.4 (10/20/2015) - On MWFRS (Any Ht.), cell A96 was corrected to 27.4.7 instead of 27.1.5 and cell A159 was corrected to Figure 27.4-1 instead of Figure 6.9. | |
David R. Taylor |
2018 07 |
|
| Earthquake lateral forces according to ASCE7-05 & IBC 2006 | Earthquake Lateral Forces calculations according ASEC7-05 & IBC 2006. | |
Mohamed Ali Abu Shady |
2018 07 |
|
| Eurocode_1990_spreadsheet_verification_manual | The spreadsheet has been developed with the goal of producing calculations to show compliance with Eurocodes (EN1990). The data given in the “problem sketch” of each test is intended to illustrate the problem in general terms rather than to give all the data necessary to actually perform the test. Thanks. Carlo Sigmund, from Italy |  |
Carlo Sigmund |
2018 07 |
|
| FMG128 | Spreadsheet program for the purpose of determining Factory Mutual Global (FMG) required roof zone ratings for the three (3) zones of a roof, based on FMG Data Sheet 1-28 (2009/2011). | |
Alex Tomanovich |
2018 07 |
|
| IBC 2006 & ASCE 7-05 | The application is created by Yo Ratanapeanchai, SE. This spreadsheet is intended as an educational tool for learning and understanding of the IBC 2006 and ASCE 7-05. It will perform both Fire Life Safety (chapter 3, 5, 6, 7, 8, 9, 10, 15 and 29) and Structural (Snow, Wind and Earthquake Load, Chapter 16 and ASCE7-05) .The application is freeware, so feel free to distribute, modify or use in anyway you see fit. Password protection is in place on some of the Worksheets and will not be given due to data integrity of the original development. Report by fax or email any errors or suggestions you may have. This will be greatly appreciated. | |
Ahmad M. Machmouchi |
2018 07 |
|
| IBC2006E | Analysis of seismic loading per IBC2006 Code (and ASCE 7-05), using Equivalent Lateral Force method. | |
Alex Tomanovich |
2018 07 |
|
| IBC2009E2 | Analysis of seismic loading per IBC2009 Code (and ASCE 7-05), using Equivalent Lateral Force method. | |
Alex Tomanovich |
2018 07 |
|
| MOVLOADS | Analysis of simple-span members subjected to 1-8 moving wheel loads | |
Alex Tomanovich |
2018 07 |
|
| PONDING9 | Ponding analysis (per AISC 9th Edition ASD Manual) | |
Alex Tomanovich |
2018 07 |
|
| Seismic_Base_Shear_and_Force_Distribution | This application can auto-generate seismic design base shear and distribute story forces based on any combination of criteria - a much better alternative to USGS ground motion parameter calculator. All structural systems from ASCE 7-10 are supported and the structure location can be easily specified with integrated Google Maps. Go to www.SEsheets.com and register an free account to access this application and many other powerful design tools for structural engineers in United States. | |
Frank Zhang |
2018 07 |
|
| The cable under the moving load (dynamic analysis) | Spreadsheet (OpenOffice/LibreOffice) + brief description of the problem. The spreadsheet generates Input file with your custom data for the open-source program (Impact-fem.org). Verification is also available. See the animation here: https://youtu.be/brsBV-Uejxw . If you have a questions, email me. All these data are absolutely free, for any use (GPL like conditions). | |
Leonid Alifanov |
2018 07 |
|
| THERMAL | This is spreadsheet workbook for the purpose of considering the thermal effects for a steel building or structure. Specifically, the appropriate maximum design temperature change, the change of length or stress as applicable, and the maximum building or structure length either without or between expansion joints is determined. There is also a "General Thermal Effects Calculator" which can be used to selectively determine any of the analysis parameters, as well as a temperature converter which can be used to convert from °C (Celsius) to °F (Fahrenheit). | |
Alex Tomanovich |
2018 07 |
|
| UBC_IBC_Seismic | 1997 UBC and 2003 IBC Seismic | |
Ahmad M Machmouchi |
2018 07 |
|
| WEIGHTS | Calculate weight of pipe and tank/vessel volumes | |
Alex Tomanovich |
2018 07 |
|
| Wind_Analysis_per_ASCE_7_10 | This demo design sheet does wind analysis per latest ASCE 7-10 code. It can automatically calculate all parameters including topographic factor and gust effect factor for flexible structures. It will display the calculated wind pressure profile graphically on plan and elevation. It's very powerful yet extremely easy to use. You can sign up a free account at www.SEsheets.com to gain full access. | |
Frank Zhang |
2018 07 |
|
| Wind(ASCE_7-10)_v.1.02 | ASCE 7-10 Wind Load Calculator. Calculates wind loads for enclosed and partially enclosed buildings, as well as trussed towers (open structure) with square cross sections. Calculates gust effect factors as well. As with any spreadsheet I post I believe it to be correct but there are no guarantees. Please do not substitute this spreadsheet for good engineering judgement. You will need to enable macros to use this spreadsheet. | |
D.Craig Brinck |
2018 07 |
