Thank you so much great video We wish to make videos about: 1 How do you calculate the Palmer Drought Index? 2 How do you calculate climate extremes? Thank you so much
I'm not getting plots automatically in excel, after copy the data from R , i placed in Excel and how can I get plots and automatically filled data of spi3, spi6,...... please explain
The file you attached is different from the one you are using here. The one you attached has Raw data sheet, sheet1, 701, spi3, spi6 and spi12. You don't have any formula in 701 for the one you have attached. Also, you copied the first 6 months and pasted and i wonder how you get the remaining 6 months (july to december). Please can you explain all these and also send me the correct excel sheet with all the formulas? Thanks
What does 1978 mean in "HLOOKUP($B4,$N$2:$Z$40,ABS(1978-A4),0)" code? Can you explain this formula? I have data set of 1901 to 2021 so I want to adjust it accordingly. Thanks very much.
Thanks for your valuable video. Could you please let me how to create your Raw data sheet excel file with auto arranging spi3 ,spi6, etc please? please send me a link how to create like this excel sheet if it is available
Hi thank you so much for the video , it helped me so much but i just wonder that how can i see the process of calculation for different periods. I mean i want to know how and which calculation R does? Can you help me about that?
Thanks TEDDY, I was facing issue to get R Studio data to excel, since last one week. I appreciate your effort!
Thank you so much
great video
We wish to make videos about:
1 How do you calculate the Palmer Drought Index?
2 How do you calculate climate extremes?
Thank you so much
help please, not getting the template from the download.
Thank you for the video. How do I determine the drought year from obtained data? Do I take SPI-12 value of December?
I'm not getting plots automatically in excel, after copy the data from R , i placed in Excel and how can I get plots and automatically filled data of spi3, spi6,......
please explain
The file you attached is different from the one you are using here. The one you attached has Raw data sheet, sheet1, 701, spi3, spi6 and spi12. You don't have any formula in 701 for the one you have attached. Also, you copied the first 6 months and pasted and i wonder how you get the remaining 6 months (july to december). Please can you explain all these and also send me the correct excel sheet with all the formulas? Thanks
I have also downloaded the file attached but it seems different from the one used in the video. It is a bit misleading
Hey the linked excel file is blank? Could you upload again? Thanks again for the vid - so helpful!
What does 1978 mean in "HLOOKUP($B4,$N$2:$Z$40,ABS(1978-A4),0)" code? Can you explain this formula? I have data set of 1901 to 2021 so I want to adjust it accordingly. Thanks very much.
how to calculate cumulative areal rainfall for selected years and periods
Hello, The Excel file you put in the link is incorrect. Can you throw it again?
HELLO plz what's the solution for missing data
How to calculate for 4 months
Thanks for your valuable video. Could you please let me how to create your Raw data sheet excel file with auto arranging spi3 ,spi6, etc please? please send me a link how to create like this excel sheet if it is available
can you make excel file and video for SPEI too?
Hi thank you so much for the video , it helped me so much but i just wonder that how can i see the process of calculation for different periods. I mean i want to know how and which calculation R does? Can you help me about that?
There is another video on that. You can check that out 😄
HI! ..... the excel link appears blank can you send it again please :(?
Error in read.table(filename, header = TRUE) :
'file' must be a character string or connection, help meee pleasee
Can you tell me the name of your EXCEL file
Plz provide me excel file for period 2021 to 2058
Plz provide sheet for period 2021 to 1958
Plz plz 🙏🙏...becoz hv project submission tomorrow
Sorry but I donot have those data at the moment
Plz Plz help me 🙏
@@VipinKumar-sm7rx Where are you from? and for what purpose do you need these data?
@@theteddychannel2770 I'm from India and i need to for my college projcet work
@@VipinKumar-sm7rx These data are not of india. And i dont have tha data for the time period you are asking for
hello sir. you excel data is not same as in video