How to Find the Critical Design Storm: Automate RORB Post-Processing with Python & Excel

How do you find the critical design storm for your catchment without spending hours testing every duration manually in RORB? In this step-by-step tutorial, we’ll explore how to automate RORB post-processing using Excel formulas and Python code — making your hydrological modelling faster, smarter, and more reliable.
We’ll start by defining what a critical design storm really means, then walk through a RORB setup for a hypothetical catchment, and finally, use automation tools to extract the peak flow and critical duration across temporal patterns.
By the end, you’ll be able to find the critical design rainfall in just a few seconds — and use these insights for better flood estimation and drainage design.
________________________________________
⏱️ Timestamps
00:00 – Why Critical Design Storms Matter
00:49 – What Is a Critical Design Storm?
01:12 – Study Catchment
01:57 – Setting Up RORB for a Hypothetical Catchment
06:45 – Manual Post-Processing: The Problem
11:25 – Automating with Excel Formulas
15:15 – Automating with Python Code
16:34 – Comparing Results and Key Takeaways
17:25 – What’s Next: Flow Routing

Also, watch our other relevant tutorials to learn more on this topic:
Mastering Catchment Response with RORB: A Sensitivity Analysis
https://youtu.be/bUCHGym3CzU
How to Calculate Time of Concentration | Physically-Based & Empirical Methods Explained
https://youtu.be/erjN81zIjfo
________________________________________
📚 Keywords
RORB hydrology tutorial, critical design rainfall, RORB critical storm, hydrological model automation, rainfall-runoff model, flood modelling, drainage design, Excel hydrology, Python hydrology code, RORB post-processing, peak flow estimation, flood risk assessment, catchment analysis, critical storm duration, hydrological data analysis, rainfall temporal patterns.

Видео How to Find the Critical Design Storm: Automate RORB Post-Processing with Python & Excel канала Water Edu Hub