-38% OFF
Spreadsheets
PHC Pile Design Excel Workbook – Eurocode 7 & 2 Multi-National Annex Edition (UK, France, Germany, Belgium, Nordics)
49 $
79 $
What's Included
PHC Pile Design Excel Workbook (European Edition) is a comprehensive, automated design tool for Pretensioned Spun High-Strength Concrete (PHC) piles under Eurocode 7 (EN 1997-1 / EN 1997-3) and Eurocode 2 (EN 1992-1-1). Features an interactive National Annex selector covering the United Kingdom, France, Germany, Belgium, and Nordic countries (Denmark, Sweden, Norway, Finland) with full Ground Model and Imported Rrep axial resistance routes.
- ✔ Interactive Country Profiles: UK (DA1), France (PMT/CPT), Germany (DA2), Belgium (CPT), Nordics (DA3).
- ✔ Automated Geotechnical & Structural Checks: Compression, uplift, soil layer continuity, and minimum spacing verifications.
- ✔ Turnkey Package: Master Excel workbook (.xlsx), 1080p English video walkthrough, and sample calculation references.
⚡
Instant Digital Access
Direct file download immediately after checkout. Access anytime under My Account.
🛡️
Verified & Standard Compliant
Spreadsheets, tools, and code templates are fully tested for technical accuracy.
💬
Dedicated Support
Direct technical assistance via Telegram @hungthinhvn or Email hangchat.xyz@gmail.com
Product Description
Eurocode 7 & Eurocode 2 Certified Methodology
Pretensioned Spun High-Strength Concrete (PHC) Pile Foundation Design Workbook
A rigorous, peer-reviewed engineering workbook developed specifically for structural and geotechnical consultants executing pile foundation designs across the European Union and the United Kingdom. Includes automated limit state verifications (ULS & SLS), axial geotechnical resistance via ground modeling or imported empirical methods, and dynamic country-specific National Annex parameter adaptation.
🎬 Video Walkthrough & Calculation Tutorial
Watch the complete practical walkthrough of the English Version of the PHC Pile Design Workbook. Learn how to configure project design factors, verify soil profile stratification, select the European National Annex, and interpret automated pass/fail results.
Original workbook diagrams, close-up calculation views, English narration, professional subtitles, and timed highlights guide you through every calculation phase.
⚙️ Step-by-Step Calculation Capabilities & Workflow
1. Design Basis Configuration
Complete the Design Basis worksheet with project consequence classes (CC1–CC3), geotechnical categories, design life factors, and supporting European standard references.
2. Pile Geometry & Toe Condition
Check external pile diameter (e.g. D300 to D800), concrete wall thickness, effective prestress (MPa), embedded length, and open-ended vs closed-ended toe plugging criteria.
3. Geotechnical Resistance Routes
Enter representative base and shaft resistance values ({b,rep}$ and {s,rep}$). Switch dynamically between the comprehensive Ground Model route and the Imported {rep}$ route.
4. EC2 Structural Section Resistance
Import verified structural design resistance {Rd}$ derived from Eurocode 2 (EN 1992-1-1) section analysis, incorporating high-strength prestressed concrete and N-M interaction.
5. Design Actions & Pile Group Layout
Enter factored design actions ({Ed}, V_{Ed}, M_{Ed}$) and centred pile coordinates $(x_i, y_i)$ to compute individual pile axial forces under combined loading.
6. Automated Design Checks & Alerts
Instantly interpret compression capacity, tension/uplift resistance, minimum pile spacing ( ge 3D$), soil profile thickness continuity, and clear missing-input checks.
🌍 European National Annex (GEO) Standard Compliance
The workbook is pre-calibrated to accommodate the unique safety factors, design approaches, and empirical formulations mandated by National Annexes across European jurisdictions:
| Country / Jurisdiction | Governing National Standard | Design Approach (DA) | Geotechnical Derivation Method |
|---|---|---|---|
| 🇬🇧 United Kingdom | BS EN 1997-1:2004+A1:2013 / BS EN 1992-1-1 (UK NA) | DA1 (Comb. 1 & 2) | Ground model from borehole laboratory & in-situ SPT/CPT profiles. |
| 🇫🇷 France | NF EN 1997-1 / NF P 94-262 (Fondations profondes) | DA2* / DA-FR | Ménard Pressiometer (PMT) & Cone Penetration (CPT) direct derivation. |
| 🇩🇪 Germany | DIN EN 1997-1:2014 / DIN 1054:2021-04 (EA-Pfähle) | DA2 | Empirical tables from CPT cone resistance ($) & static load tests. |
| 🇧🇪 Belgium | NBN EN 1997-1 ANB:2014 / NBN B 03-002 | DA1 (Comb. 1) | Belgian method based on continuous mechanical/electrical CPT logs. |
| 🇩🇰 Denmark | DS/EN 1997-1 DK NA:2021 | DA3 | Danish partial safety factor approach for precast driven concrete piles. |
| 🇸🇪 Sweden | SS-EN 1997-1 / IEG Tilämpningsdokument / Pålkommissionen | DA3 | Swedish dynamic PDA formula correlations & CPT profile evaluations. |
| 🇳🇴 Norway | NS-EN 1997-1:2008+NA:2020 / NGF Melding 6 | DA3 / DA2 | Norwegian Geotechnical Society driven pile guidelines in marine clay/till. |
| 🇫🇮 Finland | SFS-EN 1997-1 / NA / Finnish Transport Agency | DA2 | Precast prestressed pile standards under Nordic frost and glacial till. |
| 🇨🇭 Central Europe & Mediterranean | SIA 267 (Switzerland) / NTC 2018 (Italy) / TS EN 1997-1 (Türkiye) | DA2 / DA1 | Adopted national parameters and Eurocode 7 second-generation transition. |
📊 Workbook Interface & Calculation Spreadsheets
⚠️ Professional Engineering Scope & Evaluation Notes
- Outputs Marked “REQUIRED”: These indicators flag calculations awaiting specific project geotechnical borehole records or supplier testing certificates. They ensure no unverified assumption enters production calculation reports.
- French Jurisdictional Draft: The baseline tutorial workbook demonstrates an engineering draft configured for France (NF P 94-262). Applicable national factors, partial safety parameters, and separate group, settlement, lateral, and pile cap verifications require project-specific sign-off.
- Second-Generation Eurocode Readiness: Prepared with references to EN 1997-1:2024 and EN 1992-1-1:2023 frameworks to ensure long-term regulatory compliance.
📦 What is Included in Your Instant Download
- 1. PHC Pile Design Master Workbook (.xlsx): Unlocked formulas, interactive country dropdowns, comprehensive calculation sheets (Pile Foundation, Pile Axial Resistance, Supplier Data, Design Basis, Country Profiles).
- 2. High-Definition English Video Walkthrough Guide (.mp4): 1080p recorded step-by-step tutorial explaining each worksheet tab, data entry route, and code compliance interpretation.
- 3. Instant Google Drive & Direct Server Access: Direct one-click download after checkout, with permanent Google Drive shared access linked to your email.
Tags: #PHCPiles #PileFoundation #GeotechnicalEngineering #StructuralEngineering #Eurocode #ExcelEngineering #PileDesign #Eurocode7 #Eurocode2
Related Products
Spreadsheets
VERIFIED DIGITAL FILE
Instant access
Steel Beam-to-Beam Connection – AISC 360-10
Excel design calculations for a welded steel beam-to-beam connection to AISC 360-10, covering flange welds, web…
Spreadsheets
VERIFIED DIGITAL FILE
Instant access
Pile Capacity Analysis Excel Spreadsheet
Complete pile foundation design workbook: vertical end bearing and skin friction, lateral capacity, settlement and group…
Spreadsheets
VERIFIED DIGITAL FILE
Instant access
Premium HSE Dashboard Excel Templates
A collection of ready-made HSE dashboard templates in Excel with clean layouts, charts and KPIs for…
Spreadsheets
-31% OFF
VERIFIED DIGITAL FILE
Instant access
Excel Files - Fire Protection Design according to Eurocode
Nine Excel modules for structural fire design to Eurocode 3 and Eurocode 4 — fire resistance…