I recognise the format as ...

Published by

I recognise the format as one used by a data logger for rain gauges made in Australia. Do you know the manufacturer of the rain gauge?.  You can write an excel macro to convert it in to a standard hourly rainfall total using the date and time. However, I will send a message to an old colleague who might have access to the conversion program.

Cheers

charles

1 Comment

Thanks for the answer. I don't really know where the datalogger is from, I just get the raw data and process it for further needs. 
I started creating an excel spreadsheet that converts it to regular time series, I used "countif" function since all readings are 0.5mm. It became too slow since I am working with 5 to 10 year readings, so I implemented a similar code to R, it works flawlessly, but my doubdt is wheather I am doing things correct or I am making some kind of dumb mistake with missing data or by aggregating the readings. I hope this makes sense and you understand what I mean. 

Published by

Permalink