Help needed with difficult programming

B

Bill Snow

I have a La Crosse data logger that tracks temperature and humidity every 5
minutes. A sample of the raw data from download of the weather instrument
is:

"Date";"Indoor Temperature";"Indoor Humidity";"Outdoor Temperature
1";"Outdoor Humidity 1";"Outdoor Temperature 2";"Outdoor Humidity
2";"Outdoor Temperature 3";"Outdoor Humidity 3";"Outdoor Temperature
4";"Outdoor Humidity 4";"Outdoor Temperature 5";"Outdoor Humidity 5"
"2007-05-06
13:05";"74.1";"38";"53.0";"53";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:10";"72.3";"39";"53.9";"53";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:15";"71.0";"40";"53.9";"53";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:20";"70.1";"41";"53.9";"54";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:25";"70.1";"41";"53.9";"54";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:30";"69.6";"41";"53.9";"54";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:35";"69.4";"42";"56.3";"54";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:40";"69.4";"42";"56.3";"53";"---";"---";"---";"---";"---";"---";"---";"---"
"2007-05-06
13:45";"69.2";"42";"57.5";"53";"---";"---";"---";"---";"---";"---";"---";"---"

I edited each of the above to provide time separate from date, thus:
"2007-05-06";"13:45";"69.2";"42";"57.5";"53";"---";"---";"---";"---";"---";"---";"---";"---"

I then used their "export" of the above after editing each (per example
above) into Excel 2000. This gives me ( headings done manually):

Date Time Indoor Outdoor
Temp Humid Temp1 Humid1
5/6/2007 13:05 74.1 38 53 53
5/6/2007 13:10 72.3 39 53.9 53
5/6/2007 13:15 71 40 53.9 53
5/6/2007 13:20 70.1 41 53.9 54
5/6/2007 13:25 70.1 41 53.9 54
5/6/2007 13:30 69.6 41 53.9 54
5/6/2007 13:35 69.4 42 56.3 54
5/6/2007 13:40 69.4 42 56.3 53
5/6/2007 13:45 69.2 42 57.5 53

From that I want to display the data as shown below:

Indoor Temperature Indoor Humidity
Outdoor Temperature Outdoor Humidity
Date Time Max Time Min Time Max Time Min Time Max
Time Min Time Max Time Min
5/6/2007 13:05 74.1 13:45 69.2 13:35 42 13:05 38 13:45 57.5
13:05 53.0 13:35 54 13:05 53

How can I automate this process on a daily basis? Macro's? Some kind of
programming? I used 'Sort' to find the Maximums and Minimums with the
corresponding times then copied and pasted but it take too long and prone to
errors.

Any suggestions will certainly be appreciated,

Bill Snow
 
J

JLatham

Bill, This is another of those things that appear to be beyond the general
scope of the function of this forum. You've got several pieces to a puzzle
here that need to be worked with for the final solution.

You say you're doing manual editing of some file - but we don't know
where/what that is. Sounds like you're editing it inside of the data
gathering/reporting tool associated with the sensor equipment. I'm thinking
that if you can simply get raw output from that into a .txt or .csv file that
some Excel code would be able to pretty much deal with it all for you:
reading that .txt/.csv file; splitting the date and time; placing it on a
worksheet or into memory and determining the min/max and providing it in an
Excel sheet just as you want it to be.

Although this looks beyond the scope of this forum, it does not look like a
project that would continue forever, and I'd be willing to assist you with
it. If you want to try that, get in touch with me at HelpFrom @ jlatham
site.com (remove the spaces) and we'll give it a go.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top