How to calculate SPI data using Microsoft Excel | Standardized Precipitation Index | Drought Index
ฝัง
- เผยแพร่เมื่อ 6 ต.ค. 2024
- In this video, you will know how to calculate SPI data using Microsoft excel. You can also plot graphs. If you have queries leave a comment bellow. Stay tuned. Thank you.
Subscribe us for further updates.
Related video links:
How to calculate RAI (Rainfall Anomaly Index) using Excel Sheet www.youtube.co...
How to create single legend for multiple maps in ArcGIS || Single legend || ArcGIS Tutorial www.youtube.co...
How to prepare a study area map by attributes in ArcMap | ArcGIS www.youtube.co...
How to calculate SPEI data using RStudio step by step procedure | SPEI Calculation | RStudio | SPEI www.youtube.co...
How to add horizontal legend in ArcMap | Adding a Horizontal Legend to the Map | ArcGIS www.youtube.co...
How to install ArcGIS software crack version || Reinstall ArcGIS Application || ArcGIS Crack || www.youtube.co...
How to Introduce Grid in ArcMap || Introducing Latitude Longitude in ArcGIS || Lat long in ArcGIS www.youtube.co...
ArcGIS desktop has encountered a serious application error and is unable to continue || ArcMap www.youtube.co...
How To Add Legend In ArcGIS || ArcMap || How To Edit legend In ArcGIS || Horizontal Legend || www.youtube.co...
Exporting excel data into ArcMap || Importing excel data into ArcMap ||How To Export Excel Data www.youtube.co...
Tags:
How to calculate SPI using excel
SPI calculation using excel
DrinC software
how to download DrinC
how to install DrinC
how to calculate RDI
how to calculate DRI
Reconnaissance drought index
Drought reconnaissance index
RDI calculation
DRI calculation
Drought index calculator
How to calculate RAI (Rainfall Anomaly Index) using Excel Sheet
Rainfall anomaly index
drought indices
drought index
rai
how to calculate rai
how to calculate rai with excel
how to calculate rai using excel sheet
Rainfall anomaly index calculation
ArcGIS desktop has encountered a serious application error and is unable to continue
ArcGIS for beginners
ArcMap
ArcGIS
ArcGIS error
How to solve ArcGIS error
ArcGIS desktop has encountered a serious application error
unable to continue
ArcGIS desktop
ArcGIS error solution
How to resolve ArcGIS error
ArcGIS desktop 10.3
ArcGIS desktop 10.5
ArcGIS desktop 10.8
ArcGIS tutorial
ArcGIS tutorial for beginners
arcgis pro
arcgis pro tutorial
arcgis online
arcgis pro tutorial for beginners
arcgis online tutorial
arcgis online tutorial for beginners
arcgis basics
arcgis crack
arcgis course
arcgis create a map layout
arcgis coordinate transformation
arcgis download
arcgis software download
arcgis application
arcgis download free
arcgis esri
esri arcgis
arcgis free
arcgis free download
arcgis georeferencing
arcgis hydrology
arcgis install
how to install arcgis
installation of arcgis
how to reinstall arcgis
how to install arcgis desktop crack version
how to install arcgis crack
qgis
arcgis shapefile
how to download shapefile
arcgis jobs
arcgis kml to shapefile
kml
kml to layer
arcgis kriging
arcgis license manager
arcgis legend
how to add legend in arcgis
how to edit legend in arcgis
how to insert horizontal legend in arcgis
horizontal legend
horizontal legend in arcgis
multiple data frame in arcgis
how to add multiple data frame in arcgis
multiple data frame with single legend
how to add single legend for multiple data frame
how to export data in arcgis
exporting excel data into arcgis
how to add excel data into arcmap
how to interpolate in arcgis
interpolation in arcgis
how to interpolate excel data in arcgis
idw interpolation
error in arcgis
error
resolve error
resolve error in arcgis
error solution
how to introduce grid
how to introduce grid in arcgis
grid in arcmap
how to add grid in arcmap
how to add latitude longitude
lat long in arcgis
how to introduce lat long in arcgis
how to edit lat long in arcgis
arcgis basemap
drought
SPEI data
arcgis zoom to layer
arcgis 10.7
arcgis 10.6
arcgis 10.3 tutorial full
mapping with arcmap
map
arcgis 10.7 tutorial
google earth
georefferencing
digitization in arcgis
NDVI
erdas
arcgis 3d modelling
arcgis 3d analyst
arcgis download windows 7
arcgis download windows 10
arcgis crack installation
multiple maps
arcgis drawing
arcgis full tutorial
how to add single legend in arcgis
single legend
how to create single legend in arcgis
how to create single legend for multiple maps in arcgis
single legend in arcgis
single legend for multiple maps
![[Part-2] Determination of SPI Drought Index Using SPI Generator, RStudio and Microsoft Excel(PART-2)](http://i.ytimg.com/vi/7jV19OsCJwc/mqdefault.jpg)
Thank you very much
I have seen some researchers are using gama distribution and normal distribution to calculate the SPI index
Yes, you can do that also.
Dear Mr. DieFarbe , could you tell us how you can conduct both SPI and SPEI manually in Excel by using Gamma distribution for different scale and for only one station. (I am able to do so in both R programming and Python ) but I really want to learn from their eauation manually. Thank you so much
Thank you Mr
DieFarbe.
I'm a research student. My project supervisor asked me to compute SPI, I followed the steps you explained above, but he said "that is exacly for normalized rainfall index", that SPI is supposed to be fitted
to gamma distribution. Please how do i go about it?
What is formula referance. Please mention the referance paper.
Thank a lot, I want to calculate the SPI for one station, how should I proceed please?
many research papers use gamma distribtion and also normal distribution , can u mention the source where u got this formula ?article ? etc...?
hello sir, why did you change dolar sign for ist value and calculate others according to this ist one. but why ist column of the said value is not changed?
Very helpful sir 🎉🎉🎉🎉🎉😊😊😊😊😊😊
Thank you so much. I believe this video is for Meteorological drought How can I calculate agricultural, groundwater and stream- flow and lake storage drought.
Try yourself following related formulas. If you can't do so, then inform me, I'll do that for you.
How to plot the Analysis kindly send the next Analysis video to show the seasonal RF and Monthly SPI
thank you it was useful for me. I have monthly precipitation data for a station only, how can I calculate spi ?
Use spi tool
Sir can you please tell, how to calculate SPI for one station
Thank you very much
Can you explain me...If I want to calculate SPI7, i will take Precipitation data only for 7 months for each year?
I will be grateful to your answer!
Better, use SPI program.
@@DieFarbeoCan you please tell me What's the SPI Tool and where is it available???
@@KalyanAngara I've a video regarding this on my channel.
Sir, can you tell me, what is the 'Geo point value'? how it is find? I have no idea about that. I will be grateful to your answer.
Diefarbe
HI
I have yearly or monthly precipitation data from the google earth engine database and I want to calculate SPI
But how I can calculate these yearly SPI?
If you have data in excel you can calulate SPI. if your data is in KML or KMZ format you need to convert your data as CSV format. you can also calculate SPI using RStudio. If you have monthly data and you want to calculate yearly SPI, you should take a summation of 12 months precipitation for each year.
Thank you so much for this video
You're welcome ☺️
Thanks a lot for this video
My pleasure 🥰
Thank you so much sir
How do insert a line graph?
How to get this drought index sheet ??
Hi,
Can you post the source of your SPI calculation?
hello Mr. where can i download the SPI data?
You've to collect precipitation data from meteorological department
How to get this data please tell me
1. You may contact with the meteorological department of you country.
Or
Download from
2.ERA5 Dataset
3. NOAA Dataset
4. MEERA-2 Reanalysis data
How to gather the rainfall data for apu calculation sir?
What is apu ?
Sir i am confuse regarding spi3 spi 6 time scales can you clearly explain me please it's a request
It's spi 12, spi 3 6 can be calculated using spi tool
Sir I want to want what is this spi 12 means??
@@sin168gh spi 12 is the calculated standardized precipitation index values in 12 months interval.
Can u calculate my spi i don't now how to calculate the spi i will give u the charges plzz sir
Yes, I will. Mail me here. sundysuad@gmail.com
I'm from India. From where you have downloaded the data? would you please tell?
Thanks Madhurima. I've bought this data from meteorological department of Bangladesh.
@@DieFarbeo Can you please tell me in India how can I collect the data😅
@@madhurimasharma7973 download from Indian meteorological department's website. www.imdtvm.gov.in
you can use CHIRPS data
kindly write clear formula, it is written different ways
Sir where to download rainfall data station wise please tell me
Which country do you belong?
@@DieFarbeo I'm from India
@@ayandas9946 Ok, there's a lot of websites to download rainfall data.
Data.gov.in
Imdtvm.gov.in
Imd.gov.in
Or you may directly contact with the meteorological department of India. I don't know if the data is free. You may also take a look at www.ncdc.noaa.gov/cdo-web/
globalweather.tamu.edu
My recommendation is, you should contact with the meteorological department.
Kindly bolben je ata ki spi value calculate kora holo SPI3/SPI6/ naki SPI12
Yearly. Today I'll upload an easiest way to calculate SPI.
Madhurima, I've uploaded new video on SPI calculation, make sure you've watched it.
th-cam.com/video/R7U_1_g_yQ8/w-d-xo.html
@@DieFarbeo thank you so much
@@madhurimasharma7973 my pleasure ❤️
How can I get this data?
You can buy from Bangladesh Meteorological Department (BMD),
How can I get this data sir
Get of what ?
Simplest way is to buy from the country of your residence. Or can download from NOAA or NASA's website.
Hello sir can i have the excel?
Where are you from?
how to get this excel sheet data
From meteorological department directly/online and from website both.
PLease share me the link i want to download data for marathawada
@@somyasharma9979 two ways to get data. One is free and other is for money. you want to buy data or you want to get for free?
I need ur help
What kind of help
next plot the SPI on an of tools
Can do with excel too.
Hii sir
yes, hi
not a good video. the video is all about standardized rainfall anomaly and not about standardized precipitation index