Manipulating Weather data again...

Question

Manipulating Weather data again...

ahramos (Mechanical)

(OP)

30 Nov 04 14:22

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 (Petroleum) · Answer 1 · 2004-11-30 14:51:13

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 (Mechanical) · Answer 2 · 2004-11-30 15:18:30

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

Come Join Us!

Posting Guidelines

Manipulating Weather data again...