Excel: How to calculate the Seasons & the Water Year
Автор: Geosearch International
Загружено: 2022-10-11
Просмотров: 2436
In this video I will show you how to calculate the Season and the Water Year (Hydrological Year) in Excel from any date. We will be using the Month(), Year(), Lookup(), and IF functions. I'll introduce you to the theory, and then apply it to a practical example from India where we will use the CHIRPS daily precipitation from the Tapi River Basin of India to add the Season and Water Year as metadata. Then we will display the results using Excel tables, PivotTables and Pivot Charts to show you that the monsoon rainfall has been increasing steadily over the past 40 years in the Tapi.
This is an educational video to teach you useful Excel skills for water resources management. The example in the video is precipitation, but you can apply the same methodology for any water resources data - groundwater levels, river flows, evapotranspiration, NDVI etc.
Link to this video on YouTube: • Excel: How to calculate the Seasons & the ...
Link to Excel file used in the video: https://bit.ly/3Vhu1fs
Link to other Excel for IWRM videos:
• Excel for IWRM
Chapters
00:00 Introduction
00:11 The seasons
01:53 The water year
02:46 The Tapi River Basin, India
03:18 Format as Table
03:54 India Seasons & Water Year
04:34 The Seasons Formula
07:25 The Water Year Formula
09:12 PivotChart & PivotTable
11:01 Insert Data Slicer
11:40 Display by Season
12:00 Concluding remarks
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: