Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help needed with difficult programming
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help needed with difficult programming
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. "Bill Snow" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A rather difficult statistical search formula needed (Part 2) | Excel Worksheet Functions | |||
A rather difficult & complex statistical search formula needed | Excel Worksheet Functions | |||
help needed with excel programming!!! | Excel Programming | |||
Difficult function: help needed. | Excel Discussion (Misc queries) | |||
VBA programming guru needed - HELP! | Excel Programming |