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 elevationareastorage curves we calculated in the previous videos.

Chapters:
00:00 Introduction
00:44 Copy data table
01:07 Insert ElevationStorage scatter chart
02:12 Add polynomial trendline
02:59 Format Trendline Label (Scientific & 14 decimal places)
03:53 Insert AreaStorage 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 ElevationStorage: Satellite Radar Altimetry data
11:43 AreaStorage: Sentinel2 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 f...  
*******************************************************************

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  Kaj...  
Video on Reservoir ElevationAreaStorage Capacity Curves in Excel:    • Excel: How to add a 2nd Axis to a Cha...  

#Excel #Reservoir #Monitoring