Post by walterdnes on Jan 20, 2010 5:57:21 GMT
I've uploaded a spreadsheet to www.mediafire.com/walterdnes-climate as tracker.xls. Currently, it tracks ENSO and Arctic sea ice. I use Gnumeric on linux, and save the results in .xls format. It should import properly into Excel, OpenOffice, etc. Let me know if you run into problems. I do not expect to have it updated daily. The whole point is to allow people to download it and play with it as they wish. This includes updating it if you wish. I will try to update it Monday evenings when the latest ENSO data is available.
The sea ice data is sourced from IARC/JAXA, specifically... www.ijis.iarc.uaf.edu/seaice/extent/plot.csv I've had to make every year have 366 days, including February 29th. 3/4 of all years will be missing that day. The "extent_raw" tab has the raw data for each year, as well as comparisons between this year (2010) and previous years. The "extent_clean" tab has the raw data, with blanks and -9999 replaced by #NA. This prevents the graph from trying to plot blanks as zero and -9999 as -9999. Believe me, the result would look ugly. There are 3 extent graphs, with varying scales.
The ENSO data is sourced from NOAA, specifically... www.cpc.noaa.gov/data/indices/wksst.for I've had to write an ugly bash script to convert the text+numeric dates to strictly numeric. Note that according to the numbering scheme, 2010.0 is actually the data for 31DEC2009. 2009.5 is mid-2009 (near the end of June). The "ENSO_data" tab has the actual data in columns A through I. Column K has the sum of the 4 weekly anomalies, to create a crude ENSO index. Column L is an attempt at a 4 and 1/3 week average, i.e. a "monthly average". There are graphs of the weekly and pseudo-monthly data.
Enjoy.
The sea ice data is sourced from IARC/JAXA, specifically... www.ijis.iarc.uaf.edu/seaice/extent/plot.csv I've had to make every year have 366 days, including February 29th. 3/4 of all years will be missing that day. The "extent_raw" tab has the raw data for each year, as well as comparisons between this year (2010) and previous years. The "extent_clean" tab has the raw data, with blanks and -9999 replaced by #NA. This prevents the graph from trying to plot blanks as zero and -9999 as -9999. Believe me, the result would look ugly. There are 3 extent graphs, with varying scales.
The ENSO data is sourced from NOAA, specifically... www.cpc.noaa.gov/data/indices/wksst.for I've had to write an ugly bash script to convert the text+numeric dates to strictly numeric. Note that according to the numbering scheme, 2010.0 is actually the data for 31DEC2009. 2009.5 is mid-2009 (near the end of June). The "ENSO_data" tab has the actual data in columns A through I. Column K has the sum of the 4 weekly anomalies, to create a crude ENSO index. Column L is an attempt at a 4 and 1/3 week average, i.e. a "monthly average". There are graphs of the weekly and pseudo-monthly data.
Enjoy.
