Rainfall Threshold for Landslides Prediction with Excel only

Name: Rainfall Threshold for Landslides Prediction with Excel only
Rating: 4.2 (58 reviews)

Using Excel for ID, IE and Antecedent thresholds for early-warning systems, landslides & geo-hydrological risk analysis

Created byDr. Omar AlThuwaynee

Last updated 3/2020

English

What you'll learn

Employed within early-warning systems for geo-hydrological risk mitigation and Civil Protection purposes
Forecasting Landslides Induced by Rainfall
To understand the theory and the logic of threshold analysis
To easily construct the most significant thresholds in the academic literature
To learn how effectively use, analyze, and visualize the rainfall record
My continuous support, taking your hand step-by-step to make perfect use of the course objectives
Full access (downloadable) to Excel sheet equations and data used in the course

Course content

2 sections • 29 lectures • 3h 13m total length

Causes And Effects Of Rainfall Precipitation3:28
Understand how rainfall saturates soil and triggers landslides after days to weeks of precipitation, and identify rainfall thresholds across regions like Southeast Asia, Italy, and Turkey.
Definitions And Types Of Rainfall Thresholds13:43
Examine rainfall thresholds for landslide prediction, differentiating empirical thresholds from physical processes, and explore how daily and accumulated rainfall, duration, and intensity relate to landslide events.
Most Frequent Types Of Rainfall Thresholds Worldwide4:23
Explore the most frequent rainfall thresholds worldwide for landslide prediction, focusing on intensity-duration thresholds illustrated by a large table and a web tool, designed for Excel-only workflows.
Intensity-Duration (ID); Cumulative Rainfall-Duration (ED) Thresholds3:58
Explore intensity-duration and cumulative rainfall-duration thresholds for predicting landslides using Excel, showing how to compute daily intensity, accumulate rainfall over days, and apply thresholds.
Antecedent Daily Rainfall Thresholds3:05
Explore antecedent daily rainfall thresholds across time windows from 3 to 15 days, noting where there is no significant difference in rainfall signals, and emphasize routine calibration for data quality.
Intensity-Date (I-Date); Cumulative Rainfall-Date (E-Date) Thresholds2:03
Explore how intensity-date and cumulative rainfall-date thresholds predict landslides and mudslides using Excel, by analyzing daily intensity and accumulated rainfall data.
Other Empirical Thresholds2:24
Examine other empirical thresholds for landslide prediction, detailing how to accumulate and normalize rainfall, divide values, and relate intensity and total rainfall over storm timing using Excel.
Reliability Index2:01
Apply a reliability index to evaluate rainfall thresholds for landslide prediction, analyze predicted events versus false alarms, and explore the link between rainfall intensity and landslide events using Excel.
Data Preparation Process6:28
Prepare rainfall data for landslide threshold analysis in Excel by cleaning missing values, handling outliers, aligning dates, and incorporating station proximity, slope, and altitude considerations.
How To Overcome The Inventory Errors And Uncertainty9:20
Identify how to overcome inventory errors and uncertainty in rainfall–landslide data using station selection, correlation checks, missing data handling, and outlier management when using excel.
Processing Steps "First Comes First"1:36
Open and clean data in Excel, identify outliers, and prepare the data sheet. Compute correlations between stations and apply the rainfall threshold for landslide prediction.

Supplementary materials for exercise application [Excel sheet]0:05
Introduction To Real Incidents Data Inventory5:44
Build a real incidents data inventory for landslide prediction using rainfall thresholds and Excel only, aligning dates, intensity, and literature records.
Simple Method To Convert From Deg.Min.Sec To Dec.Deg7:31
Learn a simple method to convert degrees, minutes, and seconds to decimal degrees using Excel, with a focus on latitude and longitude representation.
Import Incidents To QGIS4:31
Import incidents to QGIS to visualize station data and address data issues, while using Excel to assess rainfall thresholds for landslide prediction.
Incidents Visualization And Optimization6:44
Visualize incidents and optimize data handling in Excel to support rainfall threshold-based landslide prediction. Learners clean data, deduplicate points across locations, label events, and align dates to enable accurate visualization.
Distance Matrix For Outlier Incidents Optimization12:29
Select two stations and build a distance matrix to identify the nearest and farthest points, enabling outlier incidents optimization for landslide risk assessment.
Nearest Neighbor Analysis For Incidents Groups Identification4:00
Learn to identify incident groups using shared nearest neighbors clustering, handle outliers, adjust the number of clusters, and interpret grouped points to reveal meaningful patterns.
Correlation Matrix Of Two Rain Gauges Record7:13
Explore how to assess the relationship between two rain gauges using a correlation matrix, handling missing data, and evaluating station-to-station similarity to inform landslide risk thresholds.
Visualization Of Relationship Between Rainfall Record And Incidents7:55
Visualize the relationship between rainfall records and incidents by organizing data, correcting dates, and selecting key records to reveal how rainfall patterns relate to incident occurrences.
Antecedent Days Threshold Analysis Using Excel11:52
Analyze antecedent days thresholds for landslide prediction using Excel, building binary indicators from rainfall days before events across a station's record.
Visualization Of Antecedent Days Thresholds Results11:45
Visualize antecedent days thresholds to predict landslides by analyzing rainfall data and threshold lines, comparing observed points against a reference line to identify risk days.
Reliability Index Of Antecedent Days Thresholds4:13
Assess how antecedent days thresholds and their reliability index influence rainfall threshold models for landslide prediction, using Excel to calculate and visualize day-based thresholds.
ID And ED Thresholds Analysis Using Excel21:57
Learn to analyze rainfall thresholds for landslide prediction with Excel only, focusing on ID and ED thresholds, rainfall intensity and duration, and threshold equations to identify critical events.
Visualization Of ID And ED Thresholds7:04
Explore visualization of id and ed thresholds for rainfall-triggered landslide prediction using Excel only, focusing on plotting data, interpreting thresholds, and enhancing clarity of x and y axes.
Reliability Index Of ID And ED Thresholds10:27
Investigate how rainfall thresholds predict landslides and assess the reliability index of ID and ED thresholds using Excel.
I-Date And E-Date Thresholds Analysis Using Excel3:17
Analyze i-date and e-date rainfall thresholds for landslide prediction using Excel, translating data points into actionable relationships through threshold analysis.
Temporal Probability of Re-occurrence11:27
Explore how temporal probability helps predict landslide reoccurrence using rainfall thresholds, calculating yearly exceedances, years between events, and reappearance rates with Excel-driven calculations.
Process Summary And Recommendations3:05
Analyze and summarize a step-by-step process using nearest-neighbor grouping to compare rainfall stations, filter outsiders, and derive inter-station relationships, with recommendations and reflections on data behavior and limitations.

Requirements

No statistical background needed
Basics of Microsoft excel
Basics of QGIS software (optional) for visualization purposes only

Description

In this course, we go through the development and validation of precipitation rainfall threshold step-by-step.

You will learn how to effectively build, apply and validate the most powerful Precipitation thresholds, and much more: [Excel sheet and Articles are available for the exercise application purposes]

What is all about with experience sharing : focus on that thresholds that Induces Landslides
How to prepare the data for threshold analysis
Errors and Uncertainties
Correlation between station records
Spatial pattern analysis for incidents and stations

a. Compute the Distance Matrix [distance matrix, rename the source stations as text and target as ID]
b. Compute Nearest Neighbor Analysis [shared nearest neighbor clustering, high no.= less groups]
c. Select points by delete unwanted and outliers

6. Correlation analysis

7. Precipitation Threshold Analysis that Induces Landslides types

a. ID, IE,

b. E-Date, I-Date,

c. Antecedents and others

8.Reliability index

9.Processing steps : first comes first

10.Temporal analysis

Tools: Microsoft excel and open source GIS software QGIS.

Data used in the tutorial, is strictly protected under copyright law of Landslides (Journal of the International Consortium on Landslides). Please cite the article below:

Althuwaynee O F., Asikoglu O. & Eris E. (2018) ”Threshold contour production of rainfall intensity that induces landslides in susceptible regions of northern Turkey “ Landslides. DOI : 10.1007/s10346- 018-0968-2

Who this course is for:

Students of Ecology, geo-hydrological mitigation, Civil Protection and Natural Sciences
Anyone who has rainfall data to develop thresholds
Researchers interested in precipitation threshold that induces slopes failures

Rainfall Threshold for Landslides Prediction with Excel only

What you'll learn

Explore related topics

Course content

Theoretical Section11 lectures • 52min

Practical Section18 lectures • 2hr 21min

Requirements

Description

Who this course is for: