ACI 318M-11 RC Beam Ledge Design
(adsbygoogle = window.adsbygoogle || []).push({});
Ledge beams are commonly used as spandrels in precast concrete structures. The design...
Home » Search Excel Sheets
Ledge beams are commonly used as spandrels in precast concrete structures. The design of ledge beams according to the ACI code
Click button to download file
All software and resources in the SONATUTS directory are property of their respective authors. All downloadable or viewable content available on SONATUTS is provided as-is. You agree that you bear sole responsibility for your own decisions to download or use any of the software and resources listed.
Click button to download file
All software and resources in the SONATUTS directory are property of their respective authors. All downloadable or viewable content available on SONATUTS is provided as-is. You agree that you bear sole responsibility for your own decisions to download or use any of the software and resources listed.
ACI 318-08 Moment & Shear Strength Design of Rectangular RC
Click button to download file All software and resources in the SONATUTS directory are property of their respective authors. All downloadable...
ACI 318-08 Development and Splices of Reinforcement
ACI 318-08 permits three types of splices -lap splices, mechanical splices, and welded splices. Tension lap splices of bars larger than No. 11 are not permitted. Lap splices are also not permitted in tension tie members.
Click button to download file
All software and resources in the SONATUTS directory are property of their respective authors. All downloadable or viewable content available on SONATUTS is provided as-is. You agree that you bear sole responsibility for your own decisions to download or use any of the software and resources listed.
SNRN
12/27/2020
Admin
Bandung Indonesia
ACI 318-08 Development and Splices of Reinforcement
ACI 318-08 Development and Splices of ReinforcementACI 318-08 permits three types of splices -lap splices, mechanical splices, and welded splices....
Retaining Wall with Counterfort Check of Stability & Calculation of Internal forces And design sections According ACI 318-08
All software and resources in the SONATUTS directory are property of their respective authors. All downloadable or viewable content available on SONATUTS is provided as-is. You agree that you bear sole responsibility for your own decisions to download or use any of the software and resources listed.
ACI 318-08 Design of Retaining Wall with Counterfort
Retaining Wall with Counterfort Check of Stability & Calculation of Internal forces And design sections According ACI 318-08Click button to...
Slab consists of two types which are one way slab and two way slabs.
One way slab has two types namely simply supported slab and one way continuous slab. While two way slabs also consist of two types namely simply supported two way slab and constrained slab. Slab types can be decided through side ratio calculation through BS8 110 reference such as:
- Ly / Lx <2.0 (two way)
- Ly / Lx > 2.0 (one-way)
with Ly was longer side and Lx was shorter side.
A slab is called one-way if the main reinforcement designs within one direction only.
This situation happens if slab is supported only on two sides only. If slab were supported at all four sides, slab will become one way if long span ratio (Ly) to short span (Lx) is exceeding 2. Because of slab string one-way then reinforcement in span direction is main reinforcement, while reinforcement in direction perpendicular by span known as second reinforcement which functions as binding main reinforcement and help stress distribution because of temperature changes and concrete shrinkage.
Download Excel Spreadsheets
All software and resources in the SONATUTS directory are property of their respective authors. All downloadable or viewable content available on SONATUTS is provided as-is. You agree that you bear sole responsibility for your own decisions to download or use any of the software listed.
One Way Slab Design Spreadsheets to Eurocode 2
Slab consists of two types which are one way slab and two way slabs.One way slab has two types namely simply supported slab and one way continuous...
It typically shapes component of the base of a structure, normally a multi-story structure, construction or bearing foundation for weighty furnishings. The shed solid pile cap disperses the burden of the structure into the pyramids. A parallel structure to a pile cap is a construction, which is a solid base floor laying without deviation onto yielding ground which may be accountable to falling in.
- As per Indian Standard 2911 (Part I/ Sec 3) -2010, the pile cap can be created by supposing.
- that the burden from column is distributed at 45° from the peak of the cap up to the central.
- Deepness of the pile cap from the foundation of the column or pedestal. The result from.
- piles can as well be used to be dispersed at 45° from the margin of the pile, up to the
- Central deepness of the pile cap. On account of the utmost bending moment and shear
- Forces must be effective at important sections.
- Pile cap is absolutely stiff.
- Pile heads are joined to the pile cap and therefore no bending moment is
- Passed on to piles from pile caps.
- Considering the piles are undersized and expandable columns, the dislocations and stress dispensation are planer
- Deepness of pile cap.
- Quantity of steel to be offered.
- Preparation of reinforcement.
Design of pile cap foundation
It typically shapes component of the base of a structure, normally a multi-story structure, construction or bearing foundation for weighty furnishings....
This Proforma calculates bending moments and shear forces for loads on a single span or continuous multi-span beam using the moment distribution method. Static point or distributed loads may be analysed. Settlement at the supports may also be analyzed.
1.Enter data in the yellow cells only.
2.Enter the Span Length for each span. Any number of spans may be analyzed up to a maximum of 10. Any of the 10 spans not used will be removed when loads are added. (Note: The print-out for more than 8 spans requires the paper orientation to be set to 'Landscape').
3.Enter Modulus of Elasticity (E) multiplied by the Second Moment of Area (I) for each span. Relative values of EI may be used providing settlement effects are not required, for example, if the beam is of the same material and cross section throughout then a value of 1 may be entered for EI for each span. If settlement of the supports is being considered then actual stiffness values of EI (measured in kNm2) need to be entered.
4.Loads are entered by clicking the "Add Loading" button and selecting appropriate options from the screens that follow. Loads are entered span by span by clicking the "Add" button. When all the loads have been added then click the "OK" button to calculate bending moments and shears together with moment and shear diagrams.
5.The bending moment and shear can be calculated for any point on the beam by clicking the "Moment & Shear at a Point" button after the loading has been added.
Software : Line Beam Analysis for Static Loads
Developer : David Childs
Version : 1.06
Platform : Spreadsheet
File Size : 0.29 MB
License : Freeware
All software and resources in the SONATUTS directory are property of their respective authors. All downloadable or viewable content available on SONATUTS is provided as-is. You agree that you bear sole responsibility for your own decisions to download or use any of the software listed.
SNRN
11/29/2020
Admin
Bandung Indonesia
Line Beam Analysis for Static Loads
This Proforma calculates bending moments and shear forces for loads on a single span or continuous multi-span beam using the moment distribution...
FRAME is a spreadsheet program written in MS-Excel for the purpose of plane frame analysis of portal and gable rigid plane frames subjected to various types of loading. Specifically, the "stiffness matrix" method of analysis is used to determine the unknown joint displacements, support reactions, and member end forces. Individual frame members are also analyzed to determine the shears and intermediate moments. Plots of both the shear and moment diagrams are also produced. Also, the frame is drawn for visual confimation of geometry/configuration.
Program Assumptions and Limitations:
1. This program uses the "stiffness matrix" method of analysis and four (4) following basic analysis assumptions:
- Members must be of constant cross section (E and I are constant for entire length).
- Deflections must not significantly alter the geometry of the problem.
- Stress must remain within the "elastic" region.
- Since this analysis is "first-order", the effects of "P-D", "P-d", and shear deformation are not included.
2. Additional assumptions and features are as follows:
- Frame support joints may each be either fixed or pinned.
- Frame support joints may be at different levels (elevations).
- Columns must be vertical (cannot be sloped).
- For a portal frame, the top (roof) member may be flat or sloped in either direction.
3. A vertical load, horizontal load, and externally moment may be applied to any of the joints of the frame. These joint loads are to be applied in "global" axes directions. Note: Joint loads applied directly at supports are merely added directly to support reactions and are not reflected in member end force values.
4. On any individual member, this program will handle up to five (5) full uniform, partial uniform, triangular, or trapezoidal loads, up to ten (10) point loads, and up to four (4) externally applied moments. For vertical members, distributed loads and point loads are input in a "X-Global" sence of direction. For flat or sloped top (roof) members, distributed loads may be applied global over actual member length or applied global over the "projected" member length. Program designations are "Y-Global", "Y-Projected", "X-Global", and "X-Projected".For a flat top (roof) member of a portal frame, "Y-Global" and "Y-Projected" loads produce the same results.Uniformly distributed gravity (dead or live) load would be an example of a "Y-Global" distributed load on a sloped top (roof) member, while lateral uniformly distributed wind load on sloped top (roof) member would be an example of an "X-Projected" distributed load. A uniformly distributed load such as wind suction perpendicular (normal) to a sloped top (roof) member must be resolved into Y-Global and X-Global component values by user.
5. This program will calculate the member end reactions, the member end forces (axial, shear, and moment), the member maximum positive and negative moments (if applicable), and the joint displacements. The calculated values for the maximum moments are determined from dividing the member into fifty (50) equal segments with fifty-one (51) points, and including all of the point load and applied moment locations as well. (Note: the actual point of maximum moment occurs where the shear = 0, or passes through zero.)
6. The user is also given the ability to select an AISC W, S, C, MC, or HSS (rectangular tube) shape to aide in obtaining the required moment of inertia for input. (This facility is located off to the right of the main page.)
7. 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".)
Software : FRAME
Developer : Alex Tomanovich
Version : 1.1
Platform : Spreadsheet
File Size : 1.42 MB
License : Freeware
All software and resources in the SONATUTS directory are property of their respective authors. All downloadable or viewable content available on SONATUTS is provided as-is. You agree that you bear sole responsibility for your own decisions to download or use any of the software listed.
SNRN
11/29/2020
Admin
Bandung Indonesia
Portal and Gable Rigid Plane Frame Analysis
FRAME is a spreadsheet program written in MS-Excel for the purpose of plane frame analysis of portal and gable rigid plane frames subjected to various...
ASCE705W is a spreadsheet program written in MS-Excel for the purpose of wind loading analysis for buildings and structures per the ASCE 7-05 Code. Specifically, wind pressure coefficients and related and required parameters are selected or calculated in order to compute the net design wind pressures.
This program is a workbook consisting of nine (9) worksheets, described as follows:
- Simplified - Analysis using simplified method for low-rise buildings with h <= 60’
- MWFRS (Low-Rise) - Main Wind-Force Resisting System for low-rise buildings with h <= 60’
- MWFRS (Any Ht.) - Main Wind-Force Resisting System for buildings of any height
- Wall C&C - Analysis of wall Components and Cladding
- Roof C&C - Analysis of roof Components and Cladding
- Stacks & Tanks - Analysis of cantilevered chimneys, stacks, and vertical tanks
- Open Structures (no roof) - Analysis of open structures without roofs
- Wind Map - Basic wind speed map (Figure 6-1 of ASCE 7-05 Code)
Program Assumptions and Limitations:
1. Worksheet for "Simplified" analysis is applicable for low-rise buildings meeting the criteria of Section 6.4.1.
2. In the worksheet for Simplified analysis, the design MWFRS wind load is calculated for each direction. The design MWFRS load is assumed to be the total wind load on either the width or the length of the building respectively.
3. Worksheet for "MWFRS (Low-Rise)" is applicable for low-rise buildings as defined in Section 6.2.
4. Worksheets for "MWFRS (Any Ht.)", "Wall C&C", and "Roof C&C" are applicable for buildings with mean roof heights of up to 500 feet.
5. In worksheets for "MWFRS (Any Ht.)", "Wall C&C", and "Roof C&C" the user may opt to utilize user designated steps in height, 'z', in determining the wind pressure distribution.
6. Worksheets for "MWFRS (Any Ht.)", "Stacks & Tanks", and "Open Structures" can handle “rigid” as well as “flexible” buildings and structures. For “rigid” buildings or structures, this program uses the smaller value of either 0.85 or the calculated value from Section 6.5.8.1 of the Code for the gust effect factor, 'G'. For “flexible” buildings or structures, this program calculates the gust effect factor, ‘Gf’, per Section 6.5.8.2 of the Code based on the assumed formula for the fundamental period of vibration from Section 12.8.2.1 of the Code, where the exponent 'x' in the formula T = Ct*h^x is assumed to be 0.75.
7. Worksheets for "Wall C&C" and "Roof C&C" are applicable for flat roof buildings, gable roof buildings with roof angles <= 45 degrees, and monoslope roof buildings with roof angles <= 3 degrees.
8. Worksheet for "Stacks & Tanks" is applicable for cantilevered structures up to 600 feet tall.
9. Worksheet for "Open Structures" is applicable for open structures without roofs up to 500 feet tall. This can be utilized for open process-type structures as well as pipe/utility racks and bridges.
10. This program uses the equations listed in the reference, “Guide to the Use of the Wind Load Provisions of ASCE 7-02” for determining the external wind pressure coefficients, ‘GCp’, used in the Wall C&C and Roof C&C worksheets. (Note: a version of this document applicable to the ASCE 7-05 Code was not available.)
11. 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".)
Software : ASCE705W
Developer : Alex Tomanovich
Version : 1.4
Platform : Spreadsheet
File Size : 0.88 MB
License : Freeware
All software and resources in the SONATUTS directory are property of their respective authors. All downloadable or viewable content available on SONATUTS is provided as-is. You agree that you bear sole responsibility for your own decisions to download or use any of the software listed.
SNRN
11/26/2020
Admin
Bandung Indonesia
ASCE705W-Wind Load Calculator Excel Spreadsheet
ASCE705W is a spreadsheet program written in MS-Excel for the purpose of wind loading analysis for buildings and structures per the ASCE 7-05 Code....
Designers and contractors will find the knowledge contained in Anchorage to Concrete invaluable for choosing the proper anchors for specific applications. A compilation of 15 symposium papers, this ACI publication will explore the various problems, and give insight into the latest solutions in this often neglected aspect of concrete construction. Presenting the various anchorage system alternatives, this state-of-the-art publication includes such topics as: anchor bolts in reinforced concrete foundations, dowels for anchoring new concrete facing to existing lock walls, strength and behavior of single cast-in-place anchor bolts subject to tension, headed studs, theoretical considerations on loadbearing behavior of expansion anchors, and transverse load capacity of multi-dowel anchorages in concrete.
2.Group of Tension and Shear Fasteners Near Two Edges Based on ACI 318-02
3.Single Fastener in Tension and Shear Near an Edge Based on ACI 318-02
4.Group of Tension Fasteners Near an Edge with Eccentricity Based on ACI 318-02
5.Single Tension Fastener Away from Edges Based on ACI 318-02
Click button to download file
All software and resources in the SONATUTS directory are property of their respective authors. All downloadable or viewable content available on SONATUTS is provided as-is. You agree that you bear sole responsibility for your own decisions to download or use any of the software and resources listed.
Anchorage to concrete Excel Sheets
Designers and contractors will find the knowledge contained in Anchorage to Concrete invaluable for choosing the proper anchors for specific applications....
A culvert is a structure that allows water to flow under a road, railroad, trail, or similar obstruction. Typically embedded so as to be surrounded by soil, a culvert may be made from a pipe, reinforced concrete or other material. A structure that carries water above land is known as an aqueduct. ‘Box culverts’ includes analyses of all relevant load cases using a stiffness matrix solution with spring supports and compilations of load combination bending moments and shears (at supports and at ’d’ from supports)
- Culvert data
- earth pressure coefficients
- loadings
- load combinations
- buoyancy and sliding checks
- analysis of roof, walls and base loading by stiffness matrix
- partial factors
- design moments
- design shears
Click here to download excel worksheet
1.Box culvert design materials
2.Box culvert design geometry
3.Box culvert design loads
4.Box culvert design analysis
5.Box culvert design wall
6.1.Box culvert design slab
7.Box culvert design drawing
Excel Sheet Box Culvert Analysis and Design
A culvert is a structure that allows water to flow under a road, railroad, trail, or similar obstruction. Typically embedded so as to be surrounded by...
Concrete Design Excel Sheets Free Download
This excel sheets are mainly very useful for civil engineers and for those who are structural designers. Here we are sharing some important excel sheets of various segments for designing purpose.
They are including:
- Concrete Design
- Concrete Floor
- Anchorage to Concrete
- Concrete Pool
- Concrete Beam
- Equipment Mounting
- Suspended Anchorage
- Coupling Beam
Click button to download file
All software and resources in the SONATUTS directory are property of their respective authors. All downloadable or viewable content available on SONATUTS is provided as-is. You agree that you bear sole responsibility for your own decisions to download or use any of the software and resources listed.
Concrete Design Excel Sheets
Concrete Design Excel Sheets Free DownloadThis excel sheets are mainly very useful for civil engineers and for those who are structural designers....
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.
This spreadsheet should be used in compliance with the accompanying publication 'Spreadsheets for concrete design to BS 8110 and EC2' available from British Cement Association, Telford Avenue, Crowthorne, Berkshire RG45 6YS.
Sona 12/11/2018 Admin Bandung Indonesia
Stair Design Flight and Landing (Excel Sheet )
All advice or information from the British Cement Association and/or Reinforced Concrete Council is intended...
