📦 Resource excel

Benthic Scour Risk Assessment Matrix (BSRAM) v3.1 – Site-Specific Template

The Benthic Scour Risk Assessment Matrix (BSRAM) v3.1 – Site-Specific Template is a structured Excel-based decision-support tool designed to systematically evaluate, rank, and communicate the risk of benthic scour around offshore wind substation foundations and array cable crossings. It integrates site-specific geophysical, hydrodynamic, and geotechnical data with engineering judgment to classify scour susceptibility and inform mitigation strategies. Developed for use by marine geotechnical engineers and offshore wind designers, it supports regulatory compliance, design optimization, and lifecycle asset integrity management.

📖 Overview

BSRAM v3.1 operationalizes a semi-quantitative risk framework that maps qualitative and quantitative inputs—such as near-bed current velocity, sediment mobility (e.g., Shields parameter), seabed stratigraphy, foundation geometry, and cable burial depth—to a standardized 5×5 risk matrix (Likelihood × Consequence). Each cell in the matrix corresponds to a defined risk level (Low to Extreme), accompanied by prescriptive guidance on required actions (e.g., 'monitor only', 'design mitigation', or 're-evaluate siting'). The methodology adheres to principles from DNV-RP-F109 (Scour Around Offshore Structures), CIRIA C682 (Scour at Marine Structures), and industry best practices adopted by the UK’s Crown Estate and Ørsted/ScottishPower joint guidance. Crucially, the 'Site-Specific Template' variant enables dynamic input calibration: users populate designated worksheets with bathymetric surveys, ADCP/CTD-derived current profiles, grain-size distributions from grab samples or vibrocores, and foundation/cable as-built geometries—triggering automated conditional logic and color-coded risk outputs. This ensures traceability, auditability, and consistency across multidisciplinary project teams while reducing subjectivity in early-phase geotechnical hazard assessment.

📑 Key Components

1 Scour Likelihood Rating Engine
2 Consequence Severity Scoring Table
3 Automated Risk Matrix & Mitigation Recommendation Logic

🎯 Applications

  • Pre-consent geotechnical hazard screening for offshore wind farm planning
  • Input to Foundation Design Basis Reports (DBRs) and Cable Route Engineering Assessments
  • Regulatory submission documentation for Marine Management Organisation (MMO) or BOEM approvals

📐 Key Formulas

Shields Parameter (θ)

θ = (ρ_s − ρ_f) g d_50 / (ρ_f u_*²)

Dimensionless parameter quantifying sediment entrainment threshold; used to assess bedload mobility under site-specific shear stress

Critical Bed Shear Stress (τ_cr)

τ_cr = θ_cr × (ρ_s − ρ_f) × g × d_50

Minimum shear stress required to initiate sediment motion; derived from Shields curve or empirical fits for local sediment

Scour Depth Estimate (Empirical – HEC-18 Modified)

y_s ≈ K₁ K₂ K₃ K₄ × a × (u₁ / u_c)^n

Semi-empirical prediction of equilibrium scour depth around cylindrical foundations; coefficients K₁–K₄ account for pier shape, flow alignment, bed condition, and sediment gradation

🔗 Related Concepts

Sediment Transport Modelling Offshore Geotechnical Design Hydrodynamic Load Characterisation

📚 References

#offshore-wind #geotechnical-risk #scour-assessment #excel-tool #marine-engineering