🚀 Water Hammer & Surge Analysis Excel Tool

Advanced Hydraulic Transient Design Made Simple

📌 Overview

The Water Hammer & Surge Analysis Excel Tool is a comprehensive, engineer-friendly solution designed to analyze transient flow conditions in pipelines and prevent catastrophic failures caused by pressure surges.

Built using industry-standard formulas and structured workflows, this tool enables accurate, fast, and reliable surge analysis—without requiring expensive software.

Whether you're working on water supply systems, pumping mains, or industrial pipelines, this tool helps you design safer and more resilient systems.

⚙️ Key Features

🔹 1. Structured Input System (Pipe Data Module)

• Clean and guided input interface
• Enter:
  • Pipe length, diameter, thickness
  • Material properties
  • Flow velocity and fluid characteristics
• Blue-cell input system minimizes errors

🔹 2. Wave Celerity Calculation (Allievi Formula)

• Automatically computes pressure wave velocity
• Accounts for:
  • Pipe elasticity
  • Fluid compressibility
• Essential for accurate transient analysis

🔹 3. Joukowski Surge Pressure Estimation

• Calculates maximum surge pressure using the Joukowski equation
• Instant identification of worst-case pressure rise
• Helps assess risk of pipe burst or failure

🔹 4. Critical Valve Closure Time Analysis

• Determines whether closure is:
  • Rapid (dangerous)
  • Gradual (safe)
• Prevents underestimation of surge severity

🔹 5. Pressure Profile Along Pipeline

• Generates surge pressure distribution
• Evaluates pressure at multiple stations
• Helps visualize:
  • High-risk zones
  • Pressure variation along pipeline

🔹 6. Safety Check Module (Design Verification)

• Built-in 6-point safety validation matrix
• Checks:
  • Pressure limits
  • Design compliance
  • Structural safety
• Quickly identifies design failures

🔹 7. Air Vessel Sizing (Protection System Design)

• Preliminary design of air vessels using:
  • Rigid column method (Thorley approach)
• Helps mitigate surge effects
• Essential for pump systems

🔹 8. Automated Summary Dashboard

• Consolidated results in one place
• Quick decision-making
• Clean presentation for reports

🎯 Who Is This For?

• Civil & Mechanical Engineers
• Hydraulic Designers
• Water Resource Professionals
• Students & Researchers
• Consultants working on pipeline systems

💡 Why This Tool?

✅ No coding required

✅ No expensive software needed

✅ Based on real engineering principles

✅ Saves hours of manual calculation

✅ Reduces design risk

📊 Applications

• Water supply pipelines
• Pumping mains
• Irrigation systems
• Industrial fluid transport
• Sewer force mains

🧠 Engineering Methods Used

• Allievi Wave Speed Formula
• Joukowski Equation
• Critical Time Analysis
• Surge Envelope Method
• Rigid Column Theory (Thorley)

📦 What You Get

• Fully automated Excel workbook
• Pre-built engineering formulas
• Structured workflow (Input → Analysis → Design → Summary)
• Easy-to-use interface