Prestressed Concrete Workbook Package

Complete Bundle

Transform prestressed concrete theory into practical engineering calculations with this comprehensive collection of professionally developed Excel spreadsheets, this workbook package automates key design procedures, worked examples, and engineering calculations commonly encountered in university studies and professional practice.

The spreadsheets provide transparent formulas, editable inputs, and step-by-step solutions, enabling users to learn fundamental concepts while significantly reducing manual calculation time.

Included

Properties of Materials

Develop a solid understanding of the concrete and steel properties that form the foundation of prestressed concrete design. Automated examples cover material strength, modulus of elasticity, creep, shrinkage, relaxation, and stress-strain relationships.

Excel Examples Include:

• Concrete material properties

• Prestressing steel properties

• Modulus of elasticity calculations

• Creep and shrinkage effects

• Relaxation of prestressing tendons

• Time-dependent material behaviour

Analysis of Prestress

Learn how prestressing forces influence structural behaviour at transfer and service stages. The spreadsheets automate stress calculations, tendon eccentricity effects, and equivalent load analysis.

Excel Examples Include:

• Prestress force calculations

• Tendon eccentricity effects

• Equivalent load method

• Stress distribution calculations

• Section property analysis

• Transfer and service condition assessment

Flexural Behaviour of Uncracked Members

Examine the flexural response of prestressed concrete members before cracking occurs. Examples illustrate stress distributions, cracking moments, and serviceability performance.

Excel Examples Include:

• Extreme fibre stress calculations

• Combined prestress and load effects

• Cracking moment determination

• Service stress verification

• Kern distance calculations

• Load-balancing analysis

Flexural Behaviour in the Post-Cracking Range

Explore how prestressed concrete members behave after cracking and as loads increase toward ultimate conditions. Automated examples simplify cracked-section analysis and stress redistribution.

Excel Examples Include:

• Cracked section analysis

• Neutral axis determination

• Strain compatibility calculations

• Tendon stress evaluation

• Ductility assessment

• Failure mode investigation

Flexural Strength Analysis

Master the ultimate strength design of prestressed concrete members using automated calculations based on force equilibrium and strain compatibility principles.

Excel Examples Include:

• Ultimate moment capacity

• Bonded tendon analysis

• Unbonded tendon analysis

• Neutral axis depth

• Internal force equilibrium

• Flexural strength verification

Shear and Torsion

Gain practical experience in the design of prestressed members subjected to shear and torsional actions. The spreadsheets automate cracking checks, capacity calculations, and reinforcement design.

Excel Examples Include:

• Web-shear cracking

• Flexural-shear cracking

• Shear resistance calculations

• Stirrup design

• Torsional strength assessment

• Combined shear and torsion design

Anchorage

Understand the critical design principles governing anchorage zones and force transfer regions in prestressed concrete structures.

Excel Examples Include:

• Bursting force calculations

• Spalling force calculations

• Anchorage zone analysis

• End-block design

• Reinforcement detailing

• Local and general zone design

Package Benefits

✅ Fully automated Excel design spreadsheets

✅ Step-by-step worked examples

✅ Transparent formulas for learning and verification

✅ Editable inputs for custom applications

✅ Suitable for university coursework and professional practice

✅ Developed by practicing structural engineers

✅ Based on Stephen Foster's internationally respected textbook

✅ Applicable to prestressed and post-tensioned concrete structures

Who Should Use This Package?

• Structural Engineering Students

• Graduate Engineers

• Design Engineers

• Post-Tensioning Engineers

• Consulting Structural Engineers

• Bridge Engineers

• Building and Infrastructure Designers

Product Description for ECSEC Store

Prestressed Concrete Design Workbook Package

Master the analysis and design of prestressed concrete structures with this comprehensive Excel workbook package. The package contains professionally developed spreadsheets that automate the worked examples and design procedures.

Whether you are learning prestressed concrete for the first time or applying it to real-world projects, these spreadsheets provide practical tools for analysing prestress effects, flexural behaviour, ultimate strength, shear, torsion, and anchorage design.

Save hours of calculation time while gaining a deeper understanding of prestressed concrete behaviour and design.

Developed by ECSEC – East Coast Structural Engineering Consultant Pty Ltd.