Analysis of laterally loaded piles on elasto-plastic springs

Analysis of laterally loaded piles on elasto-plastic springs

 

This is a spreadsheet for the analysis of laterally loaded single elastic piles. The pile-soil interaction is modelled with elasto-plastic springs defined by their stiffness and maximum force. Free or fixed conditions may be specified at the pile head.

This soil behaviour model provides excellent results and is usually sufficient to handle most of the buiding and bridge foundations design work. However, more advanced p-y or continuum models may be necessary for large rafts, high loads, offshore structures, unusual geotechnical conditions, cyclic loading, etc. As usual with any tool, proper engineering judgement is required.

An auxiliary worksheet is included in the file to demonstrate the calculation of spring properties. It presents an example that correlates CPT qc values with corrected SPT data and then proceeds to calculate springs’ stiffness and maximum passive forces.

The program allows the use of elastic piles of any shape, as the pile stiffness must be introduced directly and the soil springs properties input into the main worksheet already multiplied by their respective influence width.

Second order geometrically non-linear effects (P-Delta) are not taken into account in the analysis. Piles are assumed to remain elastic throughout the loading process.

The VBA module is, as usual, open source and the code is commented thoroughly.

Download Link

 

Source: https://www.linkedin.com/in/andresilvacorreia

Design of 2 and 4 piles caps by the Strut and Tie method

Design of 2 and 4 piles caps by the Strut and Tie method

Two spreadsheets for the design of 2 and 4 piles caps by the Strut and Tie Method, taking into consideration the stress limits in EN1992-1-1.

The spreadsheet uses a combined model, allowing the use of the column reinforcement to reduce the compressive forces on the CCC(C) node at the column/cap connection. Only compressive axial forces in the column are considered.

Detailed handwritten notes of the model assumptions are also included in the files.

Download Links:

2 Piles cap
4 Piles cap

Slope stability by the Simplified Bishop method

Slope stability by the Simplified Bishop method

 

Slope stability  spreadsheet currently supports analysis by the Simplified Bishop method.

Circular surfaces, 6 soil layers, pseudostatic seismic analysis, external uniformly distributed vertical loads, user defined piezometric line (including water level above the surface) and grid search with variable radia.

 

Download Link

Method Statement Template for Civil Work

Method Statement Template for Civil Work

 

A work method statement sometimes called a “safe system of work”, is a document that details the way a work task or process is to be completed.

The method statement should outline the hazards involved and include a step by step guide on how to do the job safely.

 

[su_button url=”https://drive.google.com/open?id=1h3Ia-dmqrxS2tiRrOJUB7DtG9Zn5xVwj” size=”7″ center=”yes”] Download Link[/su_button]

Electric passenger jet revolution looms as E-Fan X project takes off

Electric passenger jet revolution looms as E-Fan X project takes off

Battery-powered air taxis and bigger hybrid planes poised to change aviation

Trains, ships and automobiles have all been swept along in recent years by the electric power revolution – and planes are next.

Passenger jets are poised for an electric makeover that could fundamentally change the economics and environmental outlook of the aviation industry. Up until now the fact that the necessary batteries weigh two tonnes each has limited the switch from fossil fuels to a totally electric-powered future.

However, last month a consortium comprising Airbus, Rolls-Royce and Siemens said they had found a way to use hybrid electric jet engines to conquer gravity. They are converting a regional jet into a demonstration plane, called the E-Fan X, which will be ready by 2020.

Paul Stein, chief technology officer at Rolls-Royce, said: “It is a two-tonne battery pack – the batteries are still fairly heavy. Beating gravity into submission is a huge challenge, so weight is a big issue.”

The BAE 146 demo aircraft, a jet that seats up to 100 people, will at first have one of its four gas turbine engines replaced with the hybrid engine. This engine will be powered by batteries and an onboard generator using jet fuel. If successful, the team will then move to two electric engines. Siemens is designing the 2MW electric motor, Rolls is building the generator that powers the engine and Airbus will integrate the system into the plane and link it to flight controls. They are developing the hybrid motor because fully electric commercial flights are currently out of reach.

Pound for pound, fossil fuels contain around 100 times as much energy as a lithium-ion battery, the most common electric power pack at present. In a car, which has its wheels planted firmly on the ground, engineering boffins can design a vehicle to offset that weight disadvantage.

But in a machine that must lift itself off the ground and propel upwards this is a much harder problem to solve.

This tricky dilemma is a challenge that has been embraced with renewed gusto in the aviation sector. “Aviation has always eluded electrification largely because of the size and weight of components involved,” Stein said. “But technology has moved on apace. Electrification is now poised to make a significant impact.”

Stein said three classes of aviation are potentially within reach of an electric engine revolution. “The smallest is air taxis, which can take 1 to 4 people up to 75 miles. For small air taxis, the battery technology is almost ready now,” he said.

Some of these air taxis look like flying cars, such as those backed by Larry Page, one of Google’s founders. Chinese-owned Terrafugia’s “roadable aircraft” drives like a typical car on the ground and fits in a standard single-car garage and can be pre-ordered for $300,000 (£224,000). Pipistrel, a Slovenian company, already makes a two-seater electric training plane. Airbus has also developed a two-seater, the E Fan, which flew across the Channel in 2015.

The second market is the small, regional jet that can carry between 10 and 100 passengers. “Our target end game is a fixed wing, regional hybrid design,” Stein said of the E-Fan X project. The third market – the short-haul commercial market, dominated by Airbus’s A320 and Boeing’s 737 – is still some way off.

Bjorn Fehrm, an aeronautical analyst at aviation Leeham News and Comment, said: “For ultra short range, it can be fully electric. For the range of today’s thousands of single aisle [A320, 737] planes, it will have to be hybrid for at least another 30 years. For long range, it’s unrealistic. There would have to be a breakthrough in fuel cells, or similar.”

Airlines are watching the evolution of electric battery technology with interest. EasyJet wants electric planes to fly passengers on its short-haul routes within 10 to 20 years. It has signed a deal with Wright Electric, a US engineering company, to develop electric-powered aircraft that could reach Paris and Amsterdam from London.

The attractions for airlines are clear; depending on the oil price, jet fuel had accounted for between 17% and 36% of their running costs over the last few years. Stein reckons the E-Fan X could produce fuel savings of 15%.

The rush to electric battery technology in the automobile sector and a renewed push by aviation is likely to lead to scientific breakthroughs in what is possible over the coming years. Samsung Electronics recently declared it increased the energy capacity of a lithium-ion battery by 45%, and decreased the time needed for a recharge, by incorporating graphene – an ultra-thin form of carbon – into the power pack. Lithium-ion battery chemistry is notoriously unstable, prone to overheating and catching fire – not ideal when cruising at 35,000 feet.

“For us, safety is paramount. The burden of proof to ensure we maintain that safety margin is very high,” Stein said. “We cannot have a battery chemistry that risks a fire.”

So, lots of big hitters are ploughing huge investment and brain-power into developing alternative battery chemistries. One promising option is a solid-state lithium battery, which replaces the liquid electrolyte of current cells with a solid substitute. Such batteries offer much higher energy densities and should also be cheap to mass produce. Huge riches await those that can crack the problem and produce a next generation power source that is cheaper and greener.

Source: www.thegardian.com

Engineering with the Spreadsheets by ASCE

Engineering with the Spreadsheets by ASCE

 

Today, the spreadsheet is an essential tool for engineers. Christy provides the tools needed to quickly apply the powerful analytic capability of Microsoft Excel to structural engineering applications. The book and CD-ROM present more than 50 ready-to-use Excel templates that demonstrate basic calculations and presentation techniques as well as advanced functions that may be unfamiliar to even experienced users. Applications include concrete, wind and seismic issues, foundation soil loading, the vortex shedding of tall stacks, and other engineering issues.Beneficial to professionals and college students alike, Engineering with the Spreadsheet is an indispensable resource for structural engineers.

Engineering_with_the_spreadsheets
10 Absolute Relative References.xls
11 Circular Reference.xls
12 Logic.xls
13 Database.xls
14 Regression Analysis.xls
15 Takedown.xls
16 Pole.xls
17 Numerical Integration.xls
18 Matrix Math.xls
19 Exhaust Stack Cover.xls
20 Seismic.xls
21 Wind.xls
23 Vortex Shedding.xls
24 Bolt Patterns.xls
25 Bolt Threads.xls
27 Bolt Group Pullout.xls
28 Roark Flat Plates.xls
30 Foundation Loading.xls
31 Foundation Design.xls
33 Concrete Beam.xls
34 Concrete Shear.xls
37 Tank Support Cover.xls
38 Seismic.xls
39 Seismic ASCE 7-02_05.xls
40 Celerity.xls
41 LRFD.xls
42 Pile Foundation.xls
43 Two Way Slab Loading.xls
45 Concrete Column.xls
46 Partial Shell.xls
47 Concrete Column Photos.xls
48 Concrete Shear.xls
49 Column Deck Interface.xls
50 Column Slab Moment Shear Transfer.xls
51 Bolt Group Pullout.xls
52 Embed.xls
53 Concrete Beam.xls
54 Tank Test Measurements.xls
56 LRFD Compared.xls
57 Acceleration.xls
58 Quadratic and Cubic Equations.xls
59 LISP.xls
60 Units.xls
61 Notation.xls
_2 Tips.xls
_2 Tipslinks.xls
_3 Worksheet_70.xls
_4 Editing in Excel.xls
_5 Math Editing.xls
_6 Symbols.xls
_7 Drawing in Excel.xls
_8 Pictures.xls
_9  Graphing.xls
Sample Header.xls

 

[su_button url=”https://drive.google.com/open?id=1VxADPlrYNG6nM2r4J79P8kQwRCi4q4NI” size=”7″ center=”yes”] Download Link[/su_button]

 

Foundation Design: Principles and Practices (2nd Edition)

Foundation Design: Principles and Practices (2nd Edition)

 

Using a design-oriented approach that addresses geotechnical, structural, and construction aspects of foundation engineering, this book explores practical methods of designing structural foundations, while emphasizing and explaining how and why foundations behave the way they do.

It explains the theories and experimental data behind the design procedures, and how to apply this information to real-world problems. Covers general principles (performance requirements,

soil mechanics, site exploration and characterization); shallow foundations (bearing capacity, settlement, spread footings — geotechnical design, spread footings — structural design, mats);

deep foundations (axial load capacity — full-scale load tests, static methods, dynamic methods; lateral load capacity; structural design); special topics (foundations on weak and compressible

soils, foundation on expansive soils, foundations on collapsible soils); and earth retaining structures (lateral earth pressures, cantilever retaining walls, sheet pile walls, soldier pile walls,

internally stabilized earth retaining structures). For geotechnical engineers, soils engineers, structural engineers, and foundation engineers.

[su_button url=”https://drive.google.com/open?id=1pDu1Y3kptj-uubwlq2abSh-ugkUxHIiO” size=”7″ center=”yes”] Download Link[/su_button]

 

Ground Anchors and Anchored Structures (Xanthakos)

Ground Anchors and Anchored Structures (Xanthakos)

 

Treating anchorages as a direct application of the laws of statics and the theories governing the transfer of load, this book focuses on designs that are safe and reasonably priced. It is divided into two parts.

Following a general introduction in the first chapter, Part One goes on to explore anchor systems, components, installation and construction details.

Presents special anchor systems such as extractable, compression-type, multibell, and regroutable anchors. Analyzes the transfer of load and its relation to failure modes and anchor load capacity; deals with design considerations; covers mechanisms and types of corrosion; and details anchor stressing, testing programs, and evaluation standards.

Part Two considers uses and applications and design aspects of anchored structures; presents design examples of practical value and reasonable simplicity; and incorporates examples and case histories.

 

[su_button url=”https://drive.google.com/open?id=1x-LM-1n83RIM30mugheaXJYo2WZRhfPo” size=”7″ center=”yes”] Download Link[/su_button]

 

Excel Sheet to Design Basement Wall

Excel Sheet to Design Basement Wall

 

This Excel sheet to design Concrete Basement Wall details strength design (durability and other considerations not included) for a new buried concrete basement wall in a single-story masonry building.

The example follows the provisions of ACI 318-11, Building Code Requirements for Structural Concrete. Throughout the example, discussion of the “in practice” decisions/situations the designer may encounter are included. Additionally, at the conclusion of the problem some “what-ifs” are evaluated.

ACI Committee E702, “Designing Concrete Structures Committee,” is part of the ACI Educational Committee structure.

Their mission is to develop educational programs and instructional materials within the area of design.

The committee has developed various design examples to illustrate the use of various ACI documents.

These examples provide step-by-step calculations with references to applicable code provisions for common member design problems, and may also include calculations for common concrete testing procedures, field data analysis, or evaluations.

[su_button url=” https://drive.google.com/open?id=1jals_5SHu1h6Lbyq1wACskjQog_-g6LT” size=”7″ center=”yes”] Download Link[/su_button]

 

Excel Sheet to Design Flat Slab According to Eurocode

Excel Sheet to Design Flat Slab According to Eurocode

Common practice of design and construction is to support the slabs by beams and support the beams by columns. This may be called as beam-slab construction.

The beams reduce the available net clear ceiling height. Hence in warehouses, offices and public halls some times beams are avoided and slabs are directly supported by columns.

 

This types of construction is aesthetically appealing also. These slabs which are directly supported by columns are called Flat Slabs.

 

Download Link

 

error: Content is protected !!
Exit mobile version