Perhitungan Kalendering Tiang Pancang Xls Apr 2026

| Parameter | Symbol | Description | |-----------|--------|-------------| | Hammer Energy (rated) | ( E_h ) | Hammer manufacturer’s energy (kg.m or kJ) | | Hammer Weight | ( W_h ) | Weight of the ram (ton or kg) | | Pile Weight | ( W_p ) | Total weight of pile driven (ton or kg) | | Pile Cross-section Area | ( A ) | (m² or cm²) | | Final Set | ( S ) | Average penetration per blow (mm/blow) – usually for last 10 blows | | Rebound | ( C ) | Elastic rebound of pile head (mm) | | Efficiency factor | ( \eta ) | Hammer efficiency (0.7–0.9 for diesel hammers; 0.9–1.0 for hydraulic) | | Modulus of Elasticity | ( E ) | Pile material (steel: 210 GPa; concrete: 25–30 GPa) | | Pile Length | ( L ) | (m) | 1. Danish Formula (Simplified) [ R_u = \frac\eta \cdot E_hS + \fracC2 ]

Limitation: Assumes uniform soil resistance. [ R_u = \frac\eta \cdot W_h \cdot hS + \fracC2 \times \fracW_h + e^2 \cdot W_pW_h + W_p ] perhitungan kalendering tiang pancang xls

Where: ( R_u ) = Ultimate bearing capacity (kN) ( C = \sqrt\frac2 \cdot \eta \cdot E_h \cdot LA \cdot E ) (elastic compression, in mm) Accurate field measurement of set and rebound is paramount

However, remember: Garbage in, garbage out . Accurate field measurement of set and rebound is paramount. Use your XLS template as a decision-support tool, not a replacement for engineering judgment. While many templates exist online, always verify formulas and units. A reliable kalendering XLS should be validated with sample hand calculations or known PDA results. A reliable kalendering XLS should be validated with

refers to the calculation of pile bearing capacity based on driving resistance—specifically the set (penetration per blow) and rebound (elastic compression). Traditionally done manually or with nomographs, engineers now leverage Microsoft Excel (XLS) to automate, standardize, and archive these calculations.

Introduction In deep foundation construction, the driven pile is one of the most reliable methods for transferring structural loads to competent bearing strata. However, ensuring that each pile achieves its required bearing capacity without overstressing the material is a challenge. This is where "Kalendering" (Pile Driving Record or Driving Log) becomes critical.

This article explores the core formulas, the parameters required, and how an XLS-based template revolutionizes this essential task. Kalendering is not just a record of hammer blows; it is a dynamic formula-based estimation of pile capacity. When a hammer strikes a pile head, the energy drives the pile downward. By measuring the penetration (set) for the last few blows, we can back-calculate the soil's resistance.