Steel Connection Design Spreadsheet

Steel Connection Design Spreadsheet

Steel Connection is divided into two common methods: bolting and welding.
Bolting is the preferred method of Steel connecting members on the site. Staggered bolt layout allows easier access for tightening with a pneumatic wrench when a connection is all bolted.  High strength bolts may be snug-tightened or slip-critical. Snug-tightened connections are referred to as bearing connections Bolts in a slip-critical connection act like clamps holding the plies of the material together.Bearing type connections may have threads included ( Type N ) or excluded ( Type X ) from the shear plane(s).  Including the threads in the shear plane reduces the strength of the connection by approximately 25%.  Loading along the length of the bolt puts the bolt in axial tension. If tension failure occurs, it usually takes place in the threaded section.Three types of high strength bolts A325, A490 (Hexagonal Head Bolts), and F1852 (Button Head Bolt). A325 may be galvanized A490 bolts must not be galvanized F1852 bolts are mechanically galvanized. High strength bolts are most commonly available in 5/8” – 1 ½” diameters. Bolting requires punching or drilling of holes. Holes may be standard size holes, oversize holes, short slotted holes, long slotted holes

 

Due to high costs of labor, extensive field -welding is the most expensive component in a steel frame. Welding should be performed on bare metal. Shop welding is preferred over field welding. The weld material should have a higher strength than the pieces being connected.Single-pass welds are more economical than multi-pass welds. The most economical size weld that may be horizontally deposited in one pass has 5/16”. Fillet welds and groove welds make up the majority of all structural welds. The strength of a fillet weld is directly proportional to the weld’s throat dimension. The capacity of a weld depends on the weld’s throat dimension and its length.

 

Download link

Contiguous Piled Wall With Ground Anchor Support Design Spreadsheet

Contiguous Piled Wall With Ground Anchor Support Design Spreadsheet

 

Contiguous Piles, structures made of piles, and pile-like structures are useful structural elements to support deep excavations and cuts in slopes, and to retain creeping or sliding slopes, not uncommonly in seismic areas.
Depending on the static system and the dimensions the structural elements transfer forcesmainly by shear (“dowel”) and/or mainly by bending (“beam”) to the ground.
In numerous cases they are particularly effective in combination with otherstructural measures like (pre-stressed)
anchors and/or drainage systems. The paper presents case histories including piles and pile-like structures, which are applied for retaining structures in slopes.
The main focus is on infrastructureprojects in creeping slopes. Two case historiesfrom Austria and Sloveniaare presented in detail. Miscellaneous projects from European countries concentrating on various aspects complement
the contribution.

Download link

Over 500 Spreadsheets for Mechanical and Civil Engineering-Free Download

Over 500 Spreadsheets for Mechanical and Civil Engineering-Free Download

 

Here a big list of spreadsheets available for download from Piping, Process, Instrumentation, Mechanical, Drilling and Civil.

Civil Engineering Spreadsheets

    • Bar Schedule 8666.xls
    • Daniel-Conventional Slabs.xls
    • Daniel-Pile Caps.xls
    • Daniel-Tank Footing.xls
    • Daniel-Wind-ASCE7-05.xls
    • Daniel-Wind-IR16-7.xls
    • Steel Beam.xls
    • Tank Size Calculator.xls
    • Wind Design.xls

Beam and Pipe Spreadsheets:

    • CALCULO SOPORTES.xls
    • DIÁMETROS DE TUBERIA.xlsx
    • header & Piping sizing.xls
    • piping design info.xls
    • PIPINGS AND FITTINGS.xls
    • POLIN TIPO A.xls POLIN TIPO B.xls
    • Prontuario del Acero.xls QCF522 FIRED HEATER INSTALLATIONOF STACK, PIPING AND OUTLET MANIFOLD.xls
    • Steel_Pipe Dimens.xlsstress tables.xls
    • Tablas Varias.xls
    • Useful_Piping & Structural Data.xls

Mechanical Engineering Spreadsheets

  • BESSEL.XLS
  • CALIBTK.XLS
  • CATENARY.XLS
  • COMPRESS.XLS
  • CONE.XLS
  • CVCALCS.XLS
  • DPT.XLS
  • EXDUCT.XLS
  • FLUMLVL.XLS
  • ORIFICE.XLS
  • PACKED.XLS
  • PLATE.XLS
  • PUMPCURV.XLS
  • WEIR.XLS

Instrumentation Spreadsheets

    • CVCALCS.xls
    • CVGAS.xls
    • CVOIL.xls
    • Instt Air Consumption.xls
    • mA to PLC Raw Count Conversion.xls
    • Mercer_Pilot Valve Sizing_v5.1.xls
    • Mercer_Spring Valve Sizing_v4.99.xls
    • Orifice Calculation.xls
    • Ross_Valve Sizing.xls

Drilling Spreadsheets

    • General Formulae.xls
    • Drilling Calculation.xls
    • Assortment of Mini Applications.xls
    • Pressure Drops & Others.XLS
    • SRB Hydraulic Programs.xls
    • Hydraulics Worksheet.xls
    • Nowsco Calculation Sheets.xls
    • BASIC MUD REPORTv1.5.xls
    • MudEng2.55.xls
    • Simple Mud Engineerv1.22.xls
    • MUD MIXING.XLS
    • Hydraulic Calculations & Mudpump.xls
    • Spot Heavy Mud.xls
    • Mud Motors, Jets & Surveys.xls
    • Floating Casing.xls
    • Lubricate and Bleed Procedure.xls
    • Maximum Casing Pressure and Pit Gain.xls
    • Critical Rotary Speed.xls
    • Drill String Design.xls
    • Filling the Hole.xls
    • Volumetric Method.xls
    • Well Control.xls
    • Well Control Worksheet-Surface BOP.xls
    • Randy Smith Kill.xls
    • Kill Sheet IWCF.XLW
    • Shell Kill.xls
    • Kill Sheet7.xls
    • Kill Sheet1.xls
    • WELL CONTROL DATA SHEET for DIRECTIONAL WELLS Wt. & Wt. METHOD.xls
    • WELL CONTROL DATA SHEET for DRILLER’S METHOD.xls
    • WELL CONTROL DATA SHEET for VERTICAL WELLS Wt. & Wt. METHOD.xls
    • IDEAL KICK REMOVAL.XLS
    • Well Control.xls
    • Cement Calculations.XLS
    • CASING CEMENTING.xls
    • CEMENT.XLS
    • PRIMARY CEMENTATION.XLS
    • PUMPING RATES FOR CEMENT SPACERS.XLS
    • Buckling & Wellhead Load After Cementing.XLS
    • Squeeze Cementing Job.xls

Download Link

Structural Toolkit 3.42

Structural Toolkit 3.42

 

Structural Toolkit is a Structural Engineering software package specifically developed to assist the
Professional Structural Engineer.
Comprising a suite of structural engineering modules that use Microsoft® Excel combined with the power of
Visual Basic, Structural Toolkit delivers fast and accurate design assistance.

Structural Toolkit covers a diverse range of materials and methods including:
Analysis
Concrete
Composite
Footings
Loadings
Masonry
Retaining walls
Steel
Timber

Modules comply with current Australian Standards, and refer to a range of standard engineering references
and technical papers. Modules receive regular updates incorporating improvements, corrections and updates
as Standards change.

Only Australian Standards but because my stepson is now student in Melbourne (IT not Civil) i dedicated some time to free this program.
You can see it is registerd to Australian People and i hope after checking it you will buy it.

Copy the adapted files respectively in the proper folders and replace the existing.

—-
This is a very useful tool to Australian Standards. This also has simple structural modelling available.

Just a caution if you use this, especially the reinforced concrete design. AS3600 uses a steel grade with Fy=500 MPa.

For Steel Design, the section they use is similar to British Standard and the steel grade is nominally grade 300 steel (Fy=300 MPa).

 

Download Link

Gantt Excel v2.61

Gantt Excel v2.61

 

In companies and organizations all over the world, people use Excel in diverse ways – from repurposing it as a makeshift calculator to tracking massive projects. Given the software’s omnipresence, it’s no wonder so many people try to use it for tasks that Excel was never meant to do.

Gantt Chart Excel is completely automated and it is super easy to use. If you use Microsoft Excel, you can create a Gantt Chart with almost no learning curve by downloading our Gantt Chart Template. Microsoft Excel is instantly familiar, so everyone on your team “gets it” and hits the ground running

 

Download Link

Excel Sheet to calculate Concrete Quantities

Excel Sheet to calculate Concrete Quantities

 

This excel sheet will make you able to calculate quantities for different concrete and steel structure members with this excel sheet you will calculate quantities for sand, cement and steel for beams, footings columns, beamed slabs, flat slab, and all other structural members.
The sheet also provide tables to calculate quantities for steel structure

Download Link

RC Element Analysis and Design Program

RC Element Analysis and Design Program

The theory and techniques relative to the design and proportioning of concrete mixes, as well as the placing, finishing, and curing of concrete, are outside the scope of this book and are adequately discussed in many other publications . Field testing, quality control, and inspection are also adequately covered elsewhere. This is not to imply that these are of less importance in overall concrete construction technology but only to reiterate that the objective of this book is to deal with the design and analysis of reinforced concrete members.

The design and construction of reinforced concrete buildings is controlled by the Building Code Requirements for Structural Concrete (ACI 318-11) of the American Concrete Institute (ACI) [1]. The use of the term code in this text refers to the ACI Code unless otherwise stipulated. The code is revised, updated, and reissued on a 3-year cycle. The
code itself has no legal status. It has been incorporated into the building codes of almost all states and municipalities
throughout the United States, however. When so incorporated, it has official sanction, becomes a legal document, and
is part of the law controlling reinforced concrete design and construction in a particular area.

Therefore, tensile reinforcement must be embedded in the concrete to overcome this deficiency. In the United
States, this reinforcement is in the form of steel reinforcing bars or welded wire reinforcing composed of steel wire. In
addition, reinforcing in the form of structural steel shapes, steel pipe, steel tubing, and high-strength steel tendons is
permitted by the ACI Code.

 

Download Link

Civil Engineering Spreadsheets

Civil Engineering Spreadsheets – 150 civil engineering spreadsheets in structural, hydraulic, geotechnical engineering

This achieve contains nearly 150 civil engineering spreadsheets in structural, hydraulic, geotechnical engineering.

Content:

2-DOF System Dynamic Simulation.zip
2D_Frame.zip
2D_Truss_2002.zip
2D_Truss_DOS.zip
3D_Truss_DOS.zip
ANSYS Result File Filter.zip
Analysis of Plane Frames_plf5.zip
Analysis of Space Frames_spf6.zip
Analytc.xls
AnchorageToConcrete.xls
Atterberg.zip
BasePlate.xls
BeamAnalysis.xlt
BeamConnection.xls
Bolt Design Program.xls
Boltgroup.zip
BoltsConnection.xls
BoundarySpringGenerator.xls
Bridge2d_97.exe
CALCULO DE POLIGONAL BASE Y RADIACIONES TAQUI…
CID Pilecaps.XLS
Centrifuge_Calculates settling times.zip
CircularColumn.xlt
ColumnShear.zip
Combined Footing Design.xls
CombinedFooting.xls
CompositeMember.xls
Computer Aided Design Beam (CADB) Thailand.xls
Concrete Design & Batch 1.2.zip
ConcreteBeam.xls
ConcreteColumn.xls
ConcreteRetainingWall.xls
Concrete_RetainingWall.xls
Contbeam.zip
Continuous Beam Influence Lines..exe
Corbel.xls
CouplingBeam.xls
Dana App.zip
DeepBeam.xls
Design and Analysis of Concrete Structure.zip
Diaphragm-Ledger-CMUWall.xls
EBF-IBC.xls
EBF-UBC.xls
Engineering_Formulas.zip
Ensayo Compresi&oacute_n Inconfinada v1.0.xls
Excel_2D_Truss_Analysis_2004_(For_Distri butio…
Fast_Formulas.zip
Fast_Formulas_Spreadsheets.zip
Fdadvdis.xls
Fdadvret.xls
Fdfick2.xls
Fdnnlret.xls
Financed project for potential incentive fund…
Flagpole.xls
FloorDeck.xls
Footing Design.xls
Footing.xls
Foundationpad.xls
Friction.xls
Fscons.xls
Inch-foot calculations.xls
Inf_line.zip
Isolated Footing Design.xls
JoistGirder.xls
LRFD_ShearTorsion2004.zip
Live Mohr’s Circle!.zip
MTesting4.15_Thailand.xls
Map_Projections.xls
MasonryRetainingWall.xls
MechanicalUnitAnchorage.xls
Minlogic.zip
Moment_Dist.zip
MudMaster.zip
NEO RC Design4.20_Thailand.xls
NEO Timber_Steel_Thailand.4.15.xls
NEO Timber_Steel_Thailand.4.20.xls
NEO_FOOTING_Retaining_Wall_Thailand.xls
NEO_PreStressed4.20_Thailand.xls
OCBF-IBC.xls
OCBF-UBC.xls
OMRF-IBC.xls
OMRF-UBC.xls
PT-SlabOnGround.xls
Pile Foundation Design.doc
Pile Foundation Design.pdf
PileLoads.xlt
PlainConcreteFooting.xls
Post-Tension.xls
Post-Tension.xlw
PostPro2000.exe
PostPro97.exe
PrestLoss2.zip
PrestressedMember.xls
Project Life Cycle Cost Analysis LCC2005 – EP…
Projwr.pdf
Qfact_calculation of the broadening descripto…
RCC11 Element Design.xls
RCC12 Bending and Axial Force.xls
RCC13 Punching Shear.xls
RCC14 Crack Width.xls
RCC21 Subframe Analysis.xls
RCC31 One-way slabs (A&D).xls
RCC32 Ribbed Slabs (A & D).xls
RCC41 Continuous Beams (A & D).xls
RCC42 Post tensioned Analysis & Design.xls
RCC51 Column Load Take-down & Design.xls
RCC52 Column Chart generation.xls
RCC53 Column Design.xls
RCC61 Basement Wall.xls
RCC62 Retaining Wall.xls
RCC71 Stair Flight & Landing – Single.xls
RCC72 Stairs & Landings – Multiple.xls
RCC81 Foundation Pads.xls
RCC91 One-way Solid Slabs (Tables).xls
RCC92 Ribbed Slabs (Tables).xls
RCC93 Flat Slabs (Tables).xls
RCC94 Two-way Slabs (Tables).xls
RCC95 Continuous Beams (Tables).xls
RCCe11 Element Design.xls
RCCe21 Subframe Analysis.xls
RCCe41 Continuous Beams (A & D).xls
Rectangular Beam Design.zip
RectangularColumn.xlt
Regression.zip
RestrainedRetainingWall.xls
Retaining Wall rcc62.xls
Retaining Wall.xls
RoofDeck.xls
SCBF-IBC.xls
SCBF-UBC.xls
SHORTCOL2.zip
SMRF-ACI.xls
SMRF-IBC.xls
SMRF-UBC.xls
STATE.XLS
SectProp.zip
Section properties of a plate girder.zip
SectionDesign2.xlt
Seismic-IBC.xls
Seismic-UBC.xls
ShearWall.xls
ShearWallOpening.xls
Short Column Analysis.xls
Slab.xls
Snow.xls
Space Frame Analysis 2.1.zip
Steel Beam Design.xls
SteelJoists.xls
Subdiaphragm.xls
Survey_Map_Projections.xls
Terzcons.xls
TiltupPanel.xls
ToeNail.xls
TopPlateConnection.xls
WF-Opening.xls
WallFooting.xls
WallLateralForce-IBC.xls
WallLateralForce-UBC.xls
WeldConnection.xls
WeldGroup.zip
Weld_Design.xlt
Wind-ASCE7.xls
Wind-UBC.xls
WoodBeam.xls
WoodColumn.xls
WoodDiaphragm.xls
WoodShearWall.xls
WorkSheet.xls
WorkSheet.zip
WorkSheet_Design_Thailand.xls
WorkSheet_Design_Thailand.zip
sbeam20.zip

Download link

Water structures Sheets – Dam Spillway Design, Complete Water Supply Treatment Plant

Water structures Sheets – Dam Spillway Design, Complete Water Supply Treatment Plant

 

 

1-Dam Spillway Design:
A spillway is a structure used to provide the controlled release of flows from a dam or levee into a downstream area, typically being the river that was dammed. In the UK they may be known as overflow channels. Spillways release floods so that the water does not overtop and damage or even destroy the dam. Except during flood periods, water does not normally flow over a spillway. In contrast, an intake is a structure used to release water on a regular basis for water supply, hydroelectricity generation, etc. Floodgates and fuse plugs may be designed into spillways to regulate water flow and dam height. Other uses of the term “spillway” include bypasses of dams or outlets of a channels used during highwater, and outlet channels carved through natural dams such as moraines.

Energy dissipation
As water passes over a spillway and down the chute, potential energy converts into increasing kinetic energy. Failure to dissipate the water’s energy can lead to scouring and erosion at the dam’s toe (base). This can cause spillway damage and undermine the dam’s stability. The energy can be dissipated by addressing one or more parts of a spillway’s design.
Steps – First, on the spillway surface itself by baffles and/or steps along the spillway.
Flip bucket – Second, at the base of a spillway, a flip bucket can create a hydraulic jump and deflect water upwards.
Ski jump – A ski jump can also direct water horizontally and eventually down into a plunge pool or two ski jumps can direct their water discharges to collide with one another.
Stilling basin – Third, a stilling basin at the terminus of a spillway serves to further dissipate energy and prevent erosion. They are usually filled with a relatively shallow depth of water and sometimes lined with concrete. A number of velocity-reducing components can be incorporated into the their design to include chute blocks, baffle blocks, wing walls, surface boils or an end sill.

2-Complete Water Supply Treatment Plant:
Complete Water Supply Treatment Plant
Calculation of Water Demand
Physical & Chemical Standards Of Water
Comparison of Given Data & Standard Data and Treatment Proposed
Design of Intake Well
Design of Pen Stock & Bell Mouth Strainer
Design of Gravity Main
Design of Jack Well
Design Of Pumping System
Design of Rising Main
Treatment Units – Design Of Aeration Unit
Design Of Chemical House & Calculation Of Chemical Dose
Lime – Soda Process
Design Criteria for Mechanical Rapid Mix Unit
Design Of Clariflocculator
Design Of Rapid Gravity Filter
Design Of Disinfection Unit

The rar file includes the following sheets:
bucket design.xls
Complete Water Supply Treatment Plant.xlsx
length of spill way.xls
optimisation of spillway-Ungated.xls
Spillway Stability.xls

Download Link

error: Content is protected !!
Exit mobile version