Analyzing imported Water Temp Pro data in Excel

I imported a .csv file from a Water Temp Pro logger into Excel. When I run the Dmax function on the summer-long database to identify peak water temp on a particular DAY, the value returned is the peak temp for the ENTIRE database. I have run this function on dozens of databases and this is the only time peak temp for the entire database is returned. Apparently Excel is not recognizing the criteria callout (date in this case) within the function. How do I get Excel to run the function properly? Thanks, Loose

Comments & Subscriptions


 

It may be easier for you to use HOBware's ability to create a filtered series. With the data showing on the graph, select (highlight) the series, right click, then select "Filter Series" you can choose from min, max or average. This will create an additional series that reflects only the filtered data. This can also be exported from HOBOware.
Good luck! If you have any difficulty using this feature or any HOBOware feature, please click on the link below to open a tech support case.
-Gregg
Please submit a support case by clicking here.

Thanks Gregg. I'll learn how to take advantage of HoboWare's software. I fixed my Excel problem. Turns out I had to delete the database header imported from Hoboware (in this case, Date) and retype "Date" in Excel so it matched the criteria header. Although they were identical on screen in appearance and format, apparently the imported "Date" looked differently to Excel behind the scenes? Anyway, Dmax function works normally after making that simple change.
Hi, I am reading the wireless temperature sensor data through serial com port of laptop connected with wireless modem, which receive the of from wirless sensor. But, I am looking for temperature montioring solution which is easily availble and connect with wireless sensor networks. Wireless Temperature Sensor - https://store.ncd.io/product/industrial-long-range-wireless-temperature-humidity-sensor/

I have forwarded this question to the sales department. Please feel free to contact them directly at sales@onsetcomp.com. There are several option we can discuss.
Sincerely,
Gregg

Comment or Subscribe


 
Comment on this
Credentials (your e-mail address will not be shown publicly)
This screen name is what will publicly represent you as a user.
This email address will not appear to the public. The username field will be used to identify you as a poster..
Image CAPTCHA
Enter the characters shown in the image.
Subscribe to comments