Hey Guys
First post on these forums, mainly due to the fact that ive just started my fourth year honors thesis regarding climate change in Australia. Initially I had thought I was pretty competent on excel but have been having a great deal of trouble with even the smallest issues.
Basically my research involves finding climate records from hundreds of isolated areas in Australia and graphing them in order to gain an idea of what temperature trends would be over the last 100 years or so.
The first road block i ran into is that it seems to be impossible to actually input dates before 1900 in excel
secondly I have had a lot of detail incorperating data in its raw form from the various websites into a format that I will be able to actually graph succesfully.
Basically as far as I know the only way to graph this data would be to put it into the format
date temperature
mmyy #
mmyy #
and so on month by month for about 100 years worth however the majority of the data I am working with is in this format
http://www.bom.gov.au/jsp/ncc/cdio/...e=36&p_display_type=dataFile&p_stn_num=046042
http://data.giss.nasa.gov/work/gistemp/STATIONS//tmp.501943290000.1.1/station.txt
are there any techniques that can enable you to convert this data into the right format without having to copy past and transpose each row individually?
Sorry if these questions have already been raised but I have searched through these forums already and was unable to find anything applicable to my work..
Any assistance would be greatly appreciated!!!!
Dale
First post on these forums, mainly due to the fact that ive just started my fourth year honors thesis regarding climate change in Australia. Initially I had thought I was pretty competent on excel but have been having a great deal of trouble with even the smallest issues.
Basically my research involves finding climate records from hundreds of isolated areas in Australia and graphing them in order to gain an idea of what temperature trends would be over the last 100 years or so.
The first road block i ran into is that it seems to be impossible to actually input dates before 1900 in excel
secondly I have had a lot of detail incorperating data in its raw form from the various websites into a format that I will be able to actually graph succesfully.
Basically as far as I know the only way to graph this data would be to put it into the format
date temperature
mmyy #
mmyy #
and so on month by month for about 100 years worth however the majority of the data I am working with is in this format
http://www.bom.gov.au/jsp/ncc/cdio/...e=36&p_display_type=dataFile&p_stn_num=046042
http://data.giss.nasa.gov/work/gistemp/STATIONS//tmp.501943290000.1.1/station.txt
are there any techniques that can enable you to convert this data into the right format without having to copy past and transpose each row individually?
Sorry if these questions have already been raised but I have searched through these forums already and was unable to find anything applicable to my work..
Any assistance would be greatly appreciated!!!!
Dale
