Manipulating Weather data again...

[ahramos]

I've got data in the following format:

Date Hour Temp
9/1/2003 100 59.8°F
9/2/2003 200 60.1°F
.
.
.
8/31/2004 2400 60.8°F

I need to get to the following format on a month by month basis:

January

Hour Average Temp
100 (average temp at hour 100)
200 (average temp at hour 200)
.
.
.
2400

Any help is appreciated.

 

[InspEngr]

Presuming this is an excel file, I know exactly how to do this. You need to use the Database functions.

To make sure I still knew how to do this (it's been yearssince I did something similar) I set up a quick database. Too much to try and explain. If you could leave an email address I'd be happy to send the Excel file to you.

-InspEngr

 

[ahramos]

Thanks InspEngr. Shortly after I started the thread, I figured out a method based on responses to an earlier "Manipulating Weather Data" thread I started one year ago. Basically I did a SUMIF divided by a COUNTIF.

I would still like to see your spreadsheet to compare to.

Send to ahrpe@yahoo.com.

-ahramos