Articles by "Spreadsheets"

3D printing Aerodynamic engineering Aeronautical engineering Aeronautical engineering books Airports Architecture Artificial intelligence Automobiles Blast Resistant Design Books Bridges Building Codes Cabin Systems Civil Engineering Codes Concrete Conferences Construction Management Construction Materials Cooling Cryptocurrency Dams Do it Yourself Docks and Harbours Downloads Earthquake Engineering Electronics Engineering Engines Environmental Design & Construction Environmental Engineering Estimation Fluid Mechanics Fluid Mechanics Books Formwork design foundation engineering General Geotech Books Geotechnical Engineering Global Positioning System HVAC Hydraulics Hydraulics Books Hydro Power Hydrology Irrigation Engineering Machinery Magazines Management Books Masonry Mechanical Engineering Mechanics Mechanics Books Miscellaneous Books Modern Steel Construction Nanotechnology Natural Hazards Network Security Engineer Networking Systems News Noise and Attenuation Nuclear Engineering Nuclear Hazards to Buildings Pavement Design Prestressed Concrete Project Management Project Management Books Quantity Survey Quantity Survey Books railways RCC Structural Designing Remote Sensing Remote Sensing and GIS Books Renewable Energy Reports Resume Roads scholarships Smart devices Software Software Engineering Soil Mechanics Solar Energy Special Concrete Spreadsheets Steel Steel Spreadsheets Structural Analyses structures Structures Books Surveying Surveying Books Testing Thermodynamics Thesis Transportation Books Transportation Engineering Tunnel Engineering Wind Energy Zero Energy Buildings
Showing posts with label Spreadsheets. Show all posts

Definition of Bar bending

It is the method of bending reinforcing steel into shapes which are important for reinforced concrete construction.

Definition of Bar bending schedule (BBS)


Bar bending schedule alias schedule of bars refers to a list of reinforcement bars, a specified RCC work item that is shown in a tabular form for a smooth view. This table sums up all the necessary particulars of bars ranging from diameter, shape of bending, length of each bent and straight portions, angles of bending, total length of each bar, and number of each type of bar. This information can be used for making an estimate of quantities.
Download: Bar Bending Schedule of a Box Culvert
It includes all the details essential for fabrication of steel like bar mark, bar type and size, number of units, length of a bar, shape code, distance between stirrups (column, plinth, beam) etc.

While generating bar schedules, it is important to take proper care about length. In case of bending, bar length will be raised at the bending positions.

Benefits of the Bar Schedule:


When bar bending schedule is applied along with reinforcement detailed drawing, it makes the quality of construction superior.

Once bar bending schedule is prepared, cutting and bending of reinforcement is performed at factory and shipped to job site. This improves quick implementation at site and minimizes construction time and cost as fewer workers are needed for bar bending. Bar bending also circumvents the wastage of steel reinforcement (5 to 10%) and thus project cost is saved significantly.

It offers the perfect estimation of reinforcement steel requirement for all the structural members which are applied to workout complete reinforcement requirement for whole project.

Bar bending schedule offers the steel quantity requirement in a better way and thus delivers an option to make optimal use of the design in case of cost overflow.

The process becomes simple for site engineers to validate and approve the bar bending and cutting length throughout inspection prior to positioning of concrete with the support of bar bending schedule and thus facilitates in superior quality control.

It becomes easier to handle the reinforcement stock necessary for identified time duration.

It will facilitate the fabrication of R/F with structure.


P.S: Please share this article on social media and elsewhere if you find it useful and do leave your feedback in the comments section below.

Spreadsheet: Seismic Analysis for Buildings and Non-Building Structures as per IBC 2000
"IBC2000E" is a spreadsheet program written in MS-Excel for the purpose of seismic loading analysis for  buildings and various nonbuilding structures, as well as architectural, mechanical, and electrical components  per the IBC 2000 Code. Specifically, the total base seismic shear for buildings and nonbuilding 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.

"REBARS" is a spreadsheet program written in MS-Excel for the purpose of determining reinforcing bar development and splice lengths. 
"REBARS" is a spreadsheet program written in MS-Excel for the purpose of determining reinforcing bar development and splice lengths.
Specifically, the development lengths and splice lengths for straight bars in tension as well as compression are determined. Also, the development length for standard hook bars is determined. The provisions for development and splice lengths are included for high seismic risk applications per ACI 318-05, Chapter 21. There is also a worksheet which contains reinforcing bar data tables. This version is based on the ACI 318-05 Code.

Program Assumptions and Limitations:

1. This program follows the procedures and guidelines of the ACI 318-05 Building Code, Chapters 12 and 21.
2. The "Calc Development" worksheet, for a given reinforcing bar size, determines the straight development and  splice lengths for a "top" bar and an "other" bar in tension, the straight development and splice lengths for the  bar in compression, and the tension development length of the bar as a standard hook, all at one time.  A complete table of reinforcing bar development and splice lengths is also created for #3 through #18 bars.
3. The "Rebar Data" worksheet contains tables of reinforcing bar data which include various bar properties,  reinforcing bar areas based on spacing, tension development and splice lengths for straight bars, tension  development lengths for 90 degree standard hooks, tension lap splice criteria, compression development  and splice lengths for straight bars, maximum spacing for column ties, and various plain welded wire fabric  properties.
4. This program contains numerous “comment boxes” which contain a wide variety of information including  explanations of input or output items, equations used, data tables, etc. (Note: presence of a “comment box”  is denoted by a “red triangle” in the upper right-hand corner of a cell. Merely move the mouse pointer to the  desired cell to view the contents of that particular "comment box".)

Dear fellows,
After receiving numerous requests, we are providing an interactive Microsoft excel spreadsheet for design of timber formwork systems for elevated concrete slabs. The formulae, calculations and tables used in this spreadsheet are based on ACI committee 347, Formwork for Concrete, 6th Edition. Please enjoy it and keep sharing it.

Spreadsheet: Symmetrically Reinforced Rectangular Column Design as per BS8110:1997
All advice or information from the British Cement Association and/or Reinforced Concrete Council is intended for those who will evaluate the significance and limitations of its contents and take responsibility for its use and application. No liability (including that for negligence) for any loss resulting from such advice or information is accepted by the BCA, RCC or their subcontractors, suppliers or advisors. Users should note that all BCA software and publications are subject to revision from time to time and should therefore ensure that they are in possession of the latest version.








Spreadsheet: Seismic Design for Special Moment Resisting Frame (SMRF) as per ACI 318-02
Reinforced concrete special moment frames are used as part of seismic force-resisting systems in buildings that are designed to resist earthquakes. Beams, columns, and beam-column joints in moment frames are proportioned and detailed to resist flexural, axial, and shearing actions that result as a building sways through multiple displacement cycles during strong earthquake ground shaking. Special proportioning and detailing requirements result in a frame capable of resisting strong earthquake shaking without significant loss of stiffness or strength. These moment-resisting frames are called “Special Moment Frames” because of these additional requirements, which improve the seismic resistance in comparison with less stringently detailed Intermediate and Ordinary Moment Frames.

Spreadsheet: Design of Concrete Retaining Wall as per BS 8110:2005
Retaining walls provide lateral support to vertical slopes of soil. They retain soil which would otherwise collapse into a more natural shape. The retained soil is sometimes referred to as backfill. Retaining walls can be constructed of many different materials and with a variety of building techniques.
 
All advice or information from the British Cement Association and/or The Concrete Centre is intended for those who will evaluate the significance and limitations of its contents and take responsibility for its use and application. No liability (including that for negligence) for any loss resulting from such advice or information is accepted by the BCA, TCC or their subcontractors, suppliers or advisors. Users should note that all TCC software and publications are subject to revision from time to time and should therefore ensure that they are in possession of the latest version.

Spreadsheet: Design of Two Way Slabs by Coefficient Method
Slab is one of the basic parts of a building. Slab being the first element to be designed has pretty much importance as the whole structural design is based on the design of slab. the loads considered for its design calculations are carefully chosen and vary according to the type of structure and its purpose. Slabs can be designed by Direct Design Method known as DDM and another method for design is Coefficient Method which is the easier one. Slabs are mainly of two types; either one way or two way. If the ratio of longer dimension of the slab panel to the shorter dimension is greater than or equal to 2 then it is designed as one way slab. If less than 2 then it is designed as a two way slab. Most of residential and office buildings have rooms that have two way slab. The basic difference between the two types of slabs is that: In one way slab load is carried by one direction only that is the shorter one and hence main reinforcement is provided parallel to the span whereas temperature or shrinkage reinforcement is provided perpendicular to the main reinforcement. While in a two way slab load is carried by both the directions (longer and shorter) and accordingly main reinforcement is provided in both directions to withstand the loads. Design of a slab using excel sheet is much easier and time saving. So today I am going to share with you my excel sheet for the design of two way slab using coefficient method.

Spreadsheet: Retaining / Fence Wall Design Based on ACI 530-02 & ACI 318-02Retaining walls are structures designed to restrain soil to unnatural slopes. They are used to bound soils between two different elevations often in areas of terrain possessing undesirable slopes or in areas where the landscape needs to be shaped severely and engineered for more specific purposes like hillside farming or roadway overpasses.
Please find below an excel spreadsheet for design of Retaining / Fence Wall based on ACI 530-02 & ACI 318-02 for free download. Don't forget to share!

Spreadsheet: Prestressed Concrete Girder Design for Bridge Structure Based on AASHTO 17th Edition & ACI 318-11
Design of prestressed concrete girder bridge is one of the most specialized tasks faced by structural design engineers. An effective excel spreadsheet for design of prestressed concrete girder bridge design according to AASHTO 17th Edition & ACI 318-11 is made available for free download.
Please share with others and don't forget to give your valuable feedback in the comments section below.Voila!
Download

Spreadsheet: Beam Column Tie Design as per BS 8110
Spreadsheet: Beam Column Tie Design as per BS 8110
An Excel 2010 Template for Reinforced Concrete Sections to BS 8110 in Bi-Axial Shear, Bending and Tension or Compression. Re-bars can be randomly located in the section. Details can be saved/retrieved for up to 1 million sections. Auto Analysis allows unattended analyses and optional printing of results.
RC Beam-Column-Tie is an Excel spreadsheet for calculating the shear and bending moment capacities of rectangular reinforced concrete sections under axial compression or tension. The calculated shear capacities are in two directions as non-concurrent. The calculated bending moment capacities are in two directions as non-concurrent and bi-axial as concurrent.
Sections can be singly, doubly or randomly reinforced to resist axial load and bending. They can also have links to enhance their shear resistance. The capacities are calculated using BS 8110-1. The applied axial load can be any value in the range of pure compression capacity as a maximum positive upper value and pure tension capacity as a maximum negative lower value.

Spreadsheet: Analysis of Steel Beam End Connections Using a Beam Tab (Single Plate) AISC 9th Edition Manual
"BEAMTAB" is a spreadsheet program written in MS-Excel for the purpose of analysis of steel beam end  connections using a beam tab (single plate) field bolted to the beam web and shop welded to either the column flange, column web, or girder web. The connections may be subjected to end shear reaction and/or axial load. Specifically, all applicable "limit states" for the end connection analysis pertaining to the beam tab (single plate),  bolts, beam web, and either column flange or web, or girder web are checked.

Spreadsheet: Analysis of Steel Column Base Plates as per AISC Manual 9th Edition
"BASEPLT9" is a spreadsheet program written in MS-Excel for the purpose of analysis of steel column base plates. Specifically, wide flange column base plates may be subjected to axial loads (compression or tension), with or without major-axis column bending, plus major-axis shear. Base plate bearing pressure is checked as well as bolt tension, if applicable. If shear is present, bolt shear as well as interaction of bolt tension and shear, if applicable, are calculated. Finally, the required base plate thickness is calculated. There is a separate worksheet for base plate shear lug design, when shear load is high and cannot be effectively handled by bolts.

Spreadsheet: Snow Loading Analysis for Structural Steel Members as per Chapter 10 of ASCE 7-05
"ASCE705I" is a spreadsheet program written in MS-Excel for the purpose of determining ice loading due to  freezing rain on structural steel members per the ASCE 7-05 Code. Specifically, coefficients and related and  required parameters are determined in order to compute the ice loading on various types of structural steel members.
 

Spreadsheet: Snow Loading Analysis for Buildings and Structures per ASCE 7-02 Code
"ASCE702S" is a spreadsheet program written in MS-Excel for the purpose of flat roof snow loading analysis for buildings and structures per the ASCE 7-02 Code. Specifically, coefficients and related and required parameters are selected or calculated in order to compute the net design snow loads, including snow drift due on lower roofs and rain-on-snow surcharge.

Author Name

Engineeersdaily

Contact Form

Name

Email *

Message *

Powered by Blogger.