Hi all,
I currently have global cloud fraction datasets, basically cloud cover data for the entire earth at 0.1 degrees resolution for both latitude and longitude in CSV Excel format. I need to create a spreadsheet which allows me the flexibly and, more importantly quickly, ascertain the AVERAGE cloud cover fraction for any pairs of latitude and longitude values (i.e.: the area being estimated should be a square, bounded area).
As these annual datasets are large (about 60mb/year), I have only included a single year with this thread. However, within this dataset, I have also had to remove large chunks of latitudes and longitudes to further reduce the size so I can attach it here. The principles still stay the same though!
The rows represents longitude and the columns represent latitude. No need to worry too much about the positive or negative longitude and latitude values.
Would appreciate if anyone has any ideas - thank you very much!
Best wishes,
Xu Teo
Bookmarks