Excel: Reservoir Storage Monitoring from Elevation & Area - Kajaki Reservoir

Описание: How do we calculate the volume a reservoir if all we know is its surface area or the elevation of the water level? In this video I will show you how to do this in Excel, using polynomial formulas. We will be working on the Kajaki reservoir, Afghanistan using the elevation-area-storage curves we calculated in the previous videos.

Chapters:
00:00 Introduction
00:44 Copy data table
01:07 Insert Elevation-Storage scatter chart
02:12 Add polynomial trendline
02:59 Format Trendline Label (Scientific & 14 decimal places)
03:53 Insert Area-Storage chart
04:44 Delete unnecessary data points
05:31 Extract polynomial formulas
06:03 Processing of formulas
08:39 Assess accuracy of formulas
10:09 Elevation-Storage: Satellite Radar Altimetry data
11:43 Area-Storage: Sentinel-2 NWDI data
13:10 Sensitivity analysis of elevation & area data
13:56 Final remarks

Disclaimer: This video is based on open source data & the purpose is to train you in Excel. I am not responsible for what you do with this information/methodology. You need to check you own data, work and conclusions.

*******************************************************************
Link to Kajaki reservoir data on Google Drive used for this video
EXCEL data & calculations: https://bit.ly/3Hbo6QX
Link to Reservoir Storage Monitoring video:    • Excel: Reservoir Storage Monitoring from E...  
*******************************************************************

Some useful links:
The Global Water Monitor for Lakes & Reservoirs: https://blueice.gsfc.nasa.gov/gwm/lak...
Video on Reservoir volumes from DEM:    • QGIS: Reservoir volume from DEM - Kajaki R...  
Video on Reservoir Elevation-Area-Storage Capacity Curves in Excel:    • Excel: How to add a 2nd Axis to a Chart - ...  

#Excel #Reservoir #Monitoring