Reinforced Concrete Excel Workbook Package

This ECSEC package brings together programmed examples covering materials technology, structural loading, flexural strength, shear and torsion, serviceability, beam and slab design, and reinforced concrete columns.

Package Contents

Materials Technology and Structural Loading

Establish a strong foundation in concrete technology, material behaviour and structural loading. The programmed examples help users calculate key concrete properties, evaluate early-age behaviour and determine design actions for strength and serviceability conditions.

Your validated Chapter 1 workbook includes examples for water-cement ratio, water-reducing admixture, target mean strength, carbonation depth, bleed-water evaporation, thermal cracking, strength and serviceability load combinations, beam design loads and fire-resistance levels.

Example calculations include:

• Water-cement ratio

• Concrete target mean strength

• Concrete admixture requirements

• Carbonation depth

• Bleed-water evaporation and plastic-shrinkage risk

• Temperature rise and thermal-cracking assessment

• Strength design actions

• Short-term and long-term serviceability actions

• Beam load calculations

• Positive and negative design actions

• Fire-resistance level assessment

Flexural Strength

Develop a practical understanding of how reinforced concrete sections resist bending. The spreadsheets automate important flexural-analysis calculations and help users investigate the relationship between concrete compression, reinforcement tension, neutral-axis depth and section capacity.

Example calculations may include:

• Rectangular stress-block parameters

• Neutral-axis depth

• Internal force equilibrium

• Singly reinforced sections

• Doubly reinforced sections

• Tensile and compression reinforcement

• Reinforcement ratios

• Ultimate moment capacity

• Strength-reduction factors

• Under-reinforced and over-reinforced behaviour

• Section-capacity verification

Shear and Torsion

Analyse reinforced concrete members subjected to shear forces and torsional moments. The spreadsheets simplify the calculation of shear resistance, transverse reinforcement, torsional capacity and reinforcement requirements.

Example calculations may include:

• Concrete contribution to shear strength

• Ultimate shear capacity

• Minimum shear reinforcement

• Stirrup size and spacing

• Maximum shear capacity

• Torsional cracking assessment

• Torsional strength

• Closed-stirrup reinforcement

• Longitudinal torsional reinforcement

• Combined shear and torsion checks

• Beam section verification

Serviceability

Assess the behaviour of reinforced concrete members under normal service conditions. These Excel tools assist with deflection, cracking and long-term behaviour calculations, helping users understand how a structurally adequate member can also satisfy functional and durability requirements.

Example calculations may include:

• Uncracked and cracked section properties

• Effective moment of inertia

• Immediate deflection

• Long-term deflection

• Creep and shrinkage effects

• Tension-stiffening effects

• Crack-control requirements

• Minimum reinforcement

• Service stress calculations

• Span-to-depth assessments

• Serviceability-limit verification

• Beam and slab deflection examples

Beam and Slab Design for Flexure

Apply flexural-strength principles to the practical design of reinforced concrete beams and slabs. The spreadsheets automate reinforcement calculations and capacity checks for structural elements commonly used in building projects.

Example calculations may include:

• Singly reinforced beam design

• Doubly reinforced beam design

• Rectangular and flanged sections

• Required tensile reinforcement

• Compression reinforcement

• Reinforcement bar selection

• Ultimate moment-capacity verification

• One-way slab design

• Continuous beam and slab design

• Positive and negative moment reinforcement

• Minimum and maximum reinforcement checks

• Practical reinforcement arrangement

Columns

Analyse and design reinforced concrete columns subjected to axial compression and bending moments. The programmed examples provide practical tools for evaluating column capacity, reinforcement requirements and the interaction between axial loads and flexural actions.

Example calculations may include:

• Axially loaded columns

• Short-column capacity

• Combined axial load and uniaxial bending

• Combined axial load and biaxial bending

• Moment-axial force interaction

• Rectangular column design

• Circular column design

• Longitudinal reinforcement requirements

• Tie and restraint requirements

• Slenderness assessment

• Second-order effects

• Column capacity verification

• Interpretation of column design charts

Important Notice

This is an independently developed Excel workbook package intended to complement the user’s own legally obtained copy of the textbook. It is not the textbook, does not reproduce the book, and is not a substitute for applicable Australian Standards, project-specific engineering assessment or independent design verification.

Bring reinforced concrete theory and practical calculation together with ECSEC’s complete Excel workbook package.

Independent engineering spreadsheet developed by East Coast Structural Engineering Consultant Pty. Ltd. The methodology is informed by established prestressed concrete material principles and applicable Australian Standards. Technical reference materials consulted during development include Prestressed Concrete by Robert Warner, Stephen Foster, Andrew Kilpatrick and Rebecca Gravina. This spreadsheet is independently developed and is not affiliated with, endorsed by or published by the textbook authors or publisher.

This excels sheets introduces the fundamental material properties that govern the behaviour and performance of prestressed concrete structures. The Excel spreadsheets automate the calculation of concrete and prestressing steel properties, helping users understand how material characteristics influence stresses, strength, serviceability, and long-term structural performance.

Included Excel Examples:

✅ Calculation of concrete compressive and tensile strength properties

✅ Modulus of elasticity of concrete

✅ Stress-strain relationships for concrete

✅ Time-dependent concrete behaviour

✅ Creep coefficient calculations

✅ Shrinkage strain calculations

✅ Prestressing steel stress-strain behaviour

✅ Relaxation characteristics of prestressing tendons

✅ High-strength reinforcing steel properties

✅ Material factors used in design

✅ Evaluation of effective material properties over time

✅ Worked examples following Stephen Foster's design procedures

Independent engineering spreadsheet developed by East Coast Structural Engineering Consultant Pty. Ltd. The methodology is informed by established prestressed concrete material principles and applicable Australian Standards. Technical reference materials consulted during development include Prestressed Concrete by Robert Warner, Stephen Foster, Andrew Kilpatrick and Rebecca Gravina. This spreadsheet is independently developed and is not affiliated with, endorsed by or published by the textbook authors or publisher.

This excels sheets focuses on the flexural response of prestressed concrete members that remain uncracked under service loading. The Excel spreadsheets automate the calculation of stresses, section properties, and bending behaviour, enabling users to understand how prestressing influences structural performance before cracking occurs.

Included Excel Examples:

✅ Stress distribution due to prestressing force and eccentricity

✅ Combined effects of prestress and external loads

✅ Calculation of section properties and kern distances

✅ Extreme fibre stresses at transfer and service stages

✅ Determination of cracking moments

✅ Load-balancing concept and equivalent prestressing loads

✅ Serviceability stress verification

✅ Assessment of tension-free sections

✅ Worked examples based on textbook design procedures

Prestressed Concrete - Flexural behaviour in the post-cracking range

This excels sheets explores the behaviour of prestressed concrete members after cracking has occurred and as loads increase towards ultimate strength. The accompanying Excel spreadsheets automate the analysis of cracked sections, enabling users to evaluate strain distributions, tendon stresses, flexural capacity, and failure mechanisms using practical design procedures from Stephen Foster's Prestressed Concrete textbook.

Included Excel Examples

✅ Cracked section analysis of prestressed concrete members

✅ Location of the neutral axis in cracked sections

✅ Strain compatibility analysis

✅ Stress calculations in concrete, prestressing tendons, and reinforcement

✅ Bonded tendon behaviour at ultimate load

✅ Unbonded tendon stress development

✅ Ultimate moment capacity calculations

✅ Effects of prestressing steel ratio on strength

✅ Reinforcement contribution to flexural resistance

✅ Ductility assessment of prestressed members

✅ Comparison of under-reinforced and over-reinforced sections

✅ Prediction of flexural failure modes

✅ Complete worked design examples based on textbook procedures

Prestressed Concrete - Flexural strength analysis

This excels sheets examines the behaviour of prestressed concrete members after cracking has occurred and focuses on the structural response as loads approach ultimate capacity. The Excel spreadsheets automate the complex calculations associated with cracked section analysis, allowing users to evaluate strength, ductility, stress development, and failure mechanisms efficiently.

Included Excel Examples:

✅ Cracked section analysis

✅ Determination of neutral axis depth after cracking

✅ Strain compatibility calculations

✅ Stress distribution in concrete and prestressing steel

✅ Evaluation of tendon stress at ultimate load

✅ Ultimate moment capacity calculations

✅ Bonded and unbonded tendon behaviour

✅ Reinforcement contribution to flexural capacity

✅ Load-deflection behaviour after cracking

✅ Ductility assessment of prestressed members

✅ Identification of flexural failure modes

✅ Worked examples based on Stephen Foster's design procedures

Prestressed Concrete - Shear and torsion

This excels sheets examines the behaviour and design of prestressed concrete members subjected to shear forces and torsional moments. The Excel spreadsheets automate the complex calculations associated with ultimate limit state design, enabling users to evaluate shear capacity, torsional resistance, cracking behaviour, and reinforcement requirements efficiently and accurately.

Included Excel Examples

✅ Shear stress distribution in prestressed concrete members

✅ Influence of prestressing on shear resistance

✅ Principal tensile stress calculations

✅ Web-shear cracking assessment

✅ Flexural-shear cracking assessment

✅ Shear capacity of concrete sections

✅ Shear reinforcement design (stirrups)

✅ Ultimate shear strength verification

✅ Torsional stress calculations

✅ Torsional cracking moment determination

✅ Combined shear and torsion design

✅ Interaction between shear, torsion, and bending

✅ Design of transverse reinforcement for torsion

✅ Practical beam design examples

✅ Step-by-step worked solutions based on Stephen Foster's textbook procedures

Prestressed Concrete - Anchorage

This excels sheets focuses on the design and behaviour of anchorage zones in prestressed concrete members. The Excel spreadsheets automate the calculations associated with concentrated prestressing forces, helping engineers evaluate bursting stresses, spalling stresses, anchorage reinforcement, and end-block behaviour. These practical examples illustrate how prestressing forces are safely transferred from the tendon anchorage into the concrete member.

Included Excel Examples

✅ Anchorage zone stress analysis

✅ Load transfer from anchorages into concrete

✅ End-block force distribution

✅ Bursting force calculations

✅ Spalling force calculations

✅ Anchorage reinforcement design

✅ Local zone and general zone analysis

✅ End-block design for post-tensioned members

✅ Stress trajectories in anchorage regions

✅ Reinforcement detailing requirements

✅ Verification of anchorage zone capacity

✅ Design examples for post-tensioned beams and slabs

✅ Step-by-step worked examples based on Stephen Foster's design procedures

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.

Service information on this website is general. The services, responsibilities, deliverables and exclusions applying to a project will be defined in ECSEC’s written proposal or Engagement Agreement.