Author Topic: Temperature logging interface  (Read 2027 times)

0 Members and 1 Guest are viewing this topic.

Offline IanJ

  • Frequent Contributor
  • **
  • Posts: 719
  • Country: scotland
  • Pro EE guy many years ago, now a hobby/home biz.
    • IanJohnston.com
Temperature logging interface
« on: July 17, 2017, 07:18:00 PM »
Hi all,

So I am building a new workshop (for my 3458a, but don't tell her that!)......and have built a PC to use 24/7 with my 3458a GPIB logging spreadsheet (Windows).........but I would also like to log the workshop ambient temp alongside the 3458a data.

Any ideas on what to use, I see many USB temperature & humidity loggers on Ebay, but I'd really like one that maybe comes with drivers that allow interfacing via VBA/macro.

Any ideas?......

PS. Spreadsheet is here: http://www.eevblog.com/forum/metrology/3458a-logging-via-excel-macro/

Ian.
Ian Johnston
www.ianjohnston.com
Manufacturer of the PDVS2
 

Online mimmus78

  • Supporter
  • ****
  • Posts: 591
  • Country: it
    • 118Volt.it
Re: Temperature logging interface
« Reply #1 on: July 17, 2017, 07:30:12 PM »
Well because you did not went with raspberry, maybe you still can buy one gpio usb board for PC and attach how many bme280 (or other chips) you like.

The only problem is I don't know how much is easy to use this gpio boards in Windows.


Inviato dal mio Nexus 6P utilizzando Tapatalk

-> Check my Store @ Ebay
-> OR my Blog @ 118volt [IT][EN]
 

Offline alm

  • Super Contributor
  • ***
  • Posts: 1098
  • Country: 00
Re: Temperature logging interface
« Reply #2 on: July 17, 2017, 07:49:33 PM »
Expect cheap eBay hardware to come with software that actually works? That is a tall order. You could use something that implements a CDC (RS-232-like) interface. I imagine you can easily open serial ports in VBA. I might grab a bus pirate with a BME280, but that is not exactly the most elegant solution ;). At least both the bus pirate and the BME280 are well documented.

I am not familiar with hardware access in VBA (I have only used it for automating applications). Can you import arbitrary DLLs? Then an FT232 in I2C mode using the FTDI D2XX driver together with I2C sensors might be an option.

If you want something turnkey, then I would go for the more reputable brands, not random eBay sensors. Sorry, no direct experience, I just stuck a BME280 breakout board on the BBB's GPIO header ;).
 

Offline Flinstone

  • Regular Contributor
  • *
  • Posts: 160
  • Country: be
Re: Temperature logging interface
« Reply #3 on: July 17, 2017, 08:42:23 PM »
Hello IanJ - I have similar setup and using SI7051 from Silicon Labs - these generate Temperature and Relative Humidity data - there is a USB kit with all source code available - makes it easy to customize the protocol to your VB Excel Macro. These devices are highly accurate and development kit SI-7051-EVB is low cost.
This should be straightforward ...

Best regards
Fred Flinstone

http://www.mouser.be/Search/Refine.aspx?Keyword=SI7051
https://www.digikey.be/products/en?keywords=SI-7051
http://be.farnell.com/silicon-labs/si7051-a20-im/temperature-sensor-0-1deg-c-dfn/dp/2769160?ost=SI-7051&searchView=table&iscrfnonsku=false&ddkey=http%3Anl-BE%2FElement14_Belgium%2Fsearch

my setup:
https://photos.google.com/share/AF1QipPRm88afjKCBzi68-ipMLvFNQh_TZ4x5PRU4Nr2fU-9bHXPKgf2bHeJ0lNcVdXBaQ?key=bDlmTUtGa0NDWEhnSUxsMW81UWpwaGItYzVpYmpB

 

Offline IanJ

  • Frequent Contributor
  • **
  • Posts: 719
  • Country: scotland
  • Pro EE guy many years ago, now a hobby/home biz.
    • IanJohnston.com
Re: Temperature logging interface
« Reply #4 on: July 17, 2017, 10:42:35 PM »
Hello IanJ - I have similar setup and using SI7051 from Silicon Labs - these generate Temperature and Relative Humidity data - there is a USB kit with all source code available - makes it easy to customize the protocol to your VB Excel Macro. These devices are highly accurate and development kit SI-7051-EVB is low cost.
This should be straightforward ...

Best regards
Fred Flinstone

http://www.mouser.be/Search/Refine.aspx?Keyword=SI7051
https://www.digikey.be/products/en?keywords=SI-7051
http://be.farnell.com/silicon-labs/si7051-a20-im/temperature-sensor-0-1deg-c-dfn/dp/2769160?ost=SI-7051&searchView=table&iscrfnonsku=false&ddkey=http%3Anl-BE%2FElement14_Belgium%2Fsearch

my setup:
https://photos.google.com/share/AF1QipPRm88afjKCBzi68-ipMLvFNQh_TZ4x5PRU4Nr2fU-9bHXPKgf2bHeJ0lNcVdXBaQ?key=bDlmTUtGa0NDWEhnSUxsMW81UWpwaGItYzVpYmpB

Cheers Fred, this looks just the ticket........and the Dev kit software package looks pretty comprehensive enough.

http://www.silabs.com/products/development-tools/sensors/si7051-evb-usb-dongle-temperature-evaluation-kit
https://www.silabs.com/documents/public/user-guides/si70xx-temp-and-humidity-sensor-eval-guide.pdf

The tools guide PDF above even gives an Excel example (or it may be an export of data).....but anyways perfect!

I've placed an order for a kit, and so once it comes I'll update the Excel Macro logging thread with any changes I make to the spreadsheet to incorporate the temp/humidity logging data.

Ian.
« Last Edit: July 17, 2017, 11:41:27 PM by IanJ »
Ian Johnston
www.ianjohnston.com
Manufacturer of the PDVS2
 

Offline plesa

  • Frequent Contributor
  • **
  • Posts: 953
  • Country: se
Re: Temperature logging interface
« Reply #5 on: July 18, 2017, 01:33:17 AM »
What about this. We have support for BME280 and python + web server scripts for plotting
http://www.eevblog.com/forum/metrology/raspberry-pi23-logging-platform-for-voltnuts/
 

Offline IanJ

  • Frequent Contributor
  • **
  • Posts: 719
  • Country: scotland
  • Pro EE guy many years ago, now a hobby/home biz.
    • IanJohnston.com
Re: Temperature logging interface
« Reply #6 on: July 18, 2017, 02:48:58 AM »
What about this. We have support for BME280 and python + web server scripts for plotting
http://www.eevblog.com/forum/metrology/raspberry-pi23-logging-platform-for-voltnuts/

Rasp-Pi based?........My setup is Windows only and I wanted to keep it that way. Appreciate the suggestion but I just don't want to go learn another embedded/Linux type system not to mention python. My existing 3458a GPIB logging is via a Windows NI Vesa driver and works pretty good and I just wanted to add to that existing setup. Hopefully I can.

Ian.
Ian Johnston
www.ianjohnston.com
Manufacturer of the PDVS2
 

Offline branadic

  • Frequent Contributor
  • **
  • Posts: 732
  • Country: de
Re: Temperature logging interface
« Reply #7 on: July 18, 2017, 02:50:56 AM »
Please, don't go for BME280 if you want to do metrology stuff, better use SHT25 and MS5611. You want the best ambient sensors you can get. No problem using Raspberry Pi together with those sensors are any other cheap ass micro with VCP. If you need support just write me a short message.

-branadic-
« Last Edit: July 18, 2017, 02:52:56 AM by branadic »
Prema 5000 | Prema 5017 SC | Keithley 181 | Tek 2465A | VNWA2.x with TCXO upgrade and access to: Keysight 3458A, Keithley 2002, Prema 5017 SC, 34401A, 34410A, HDO6054, Keysight 53230A and other goodies at work
 

Offline Flinstone

  • Regular Contributor
  • *
  • Posts: 160
  • Country: be
Re: Temperature logging interface
« Reply #8 on: July 18, 2017, 04:33:00 AM »

Hello IanJ - can you consider to add a loop counter in the VB Form ... - it saves the user lots of time if such sample counter is present in the VB Excel form ?

A second application that runs ACAL? 72 over a time span of 7 ... 28 days (adjustable) and reads out ACAL? 72 every 6-12-24 hours (adjustable) would also be very appreciated ...

Thank you for considering these add ons ...

:-)

Fred Flinstone
 

Offline IanJ

  • Frequent Contributor
  • **
  • Posts: 719
  • Country: scotland
  • Pro EE guy many years ago, now a hobby/home biz.
    • IanJohnston.com
Re: Temperature logging interface
« Reply #9 on: July 18, 2017, 04:47:36 AM »

Hello IanJ - can you consider to add a loop counter in the VB Form ... - it saves the user lots of time if such sample counter is present in the VB Excel form ?

A second application that runs ACAL? 72 over a time span of 7 ... 28 days (adjustable) and reads out ACAL? 72 every 6-12-24 hours (adjustable) would also be very appreciated ...

Thank you for considering these add ons ...

:-)

Fred Flinstone

Yup, once i get back into it again I'll look at these.

Ian.
Ian Johnston
www.ianjohnston.com
Manufacturer of the PDVS2
 

Offline Muxr

  • Super Contributor
  • ***
  • Posts: 1273
  • Country: us
Re: Temperature logging interface
« Reply #10 on: July 21, 2017, 05:13:35 AM »
Rasp-Pi based?........My setup is Windows only and I wanted to keep it that way. Appreciate the suggestion but I just don't want to go learn another embedded/Linux type system not to mention python. My existing 3458a GPIB logging is via a Windows NI Vesa driver and works pretty good and I just wanted to add to that existing setup. Hopefully I can.

Ian.
If you don't want to use Rpi and just want to use a Windows based PC, the easiest would probably be to use an Arduino board (like an Arduino Nano clone or something) and use serial (over USB).
 
The following users thanked this post: IanJ

Offline alm

  • Super Contributor
  • ***
  • Posts: 1098
  • Country: 00
Re: Temperature logging interface
« Reply #11 on: July 21, 2017, 07:35:18 PM »
Please, don't go for BME280 if you want to do metrology stuff, better use SHT25 and MS5611. You want the best ambient sensors you can get. No problem using Raspberry Pi together with those sensors are any other cheap ass micro with VCP. If you need support just write me a short message.
Care to elaborate on this? The only references I found on this forum were posts by you without any supporting data. Comparing the data sheets, the SHT25 seems to have marginally better accuracy than the BME280, and the MS5611 seems to have very similar specs to the BME280. The only thing resembling a comparative test I could find (this one) shows the BME280 superior to the Sensirion device. Even if you take the caveat mentioned at the end into account, it is hard to support the conclusion that the Sensirion device is superior, even if the SHT25 performs slightly better than the SHT21.
 

Offline d-smes

  • Regular Contributor
  • *
  • Posts: 75
  • Country: us
Re: Temperature logging interface
« Reply #12 on: July 24, 2017, 10:54:36 PM »
For temperature, check out TSYS01 (that's a zero in the p/n) http://www.te.com/commerce/DocumentDelivery/DDEController?Action=showdoc&DocId=Data+Sheet%7FTSYS01%7FA%7Fpdf%7FEnglish%7FENG_DS_TSYS01_A.pdf%7FG-NICO-018
Max error +/-0.1C over -5C to +50C range.
 

Offline branadic

  • Frequent Contributor
  • **
  • Posts: 732
  • Country: de
Re: Temperature logging interface
« Reply #13 on: July 25, 2017, 05:19:31 AM »
Quote
Care to elaborate on this? The only references I found on this forum were posts by you without any supporting data.

No data that I can share with the board. Just take the suggestion as it is. The only other hint that I can give you is this link: http://electronics-from-t.blogspot.de/2016/02/lps25h-vs-ms5611-vs-bmp180.html

If you want to compare performance then compare to SHT25 original by Sensirion and not some ebay-available copies of this device. If available use the more precise SHT35.

-branadic-
Prema 5000 | Prema 5017 SC | Keithley 181 | Tek 2465A | VNWA2.x with TCXO upgrade and access to: Keysight 3458A, Keithley 2002, Prema 5017 SC, 34401A, 34410A, HDO6054, Keysight 53230A and other goodies at work
 

Offline feedback.loop

  • Regular Contributor
  • *
  • Posts: 91
  • Country: us
Re: Temperature logging interface
« Reply #14 on: July 25, 2017, 10:54:48 AM »
For temperature, check out TSYS01 (that's a zero in the p/n) http://www.te.com/commerce/DocumentDelivery/DDEController?Action=showdoc&DocId=Data+Sheet%7FTSYS01%7FA%7Fpdf%7FEnglish%7FENG_DS_TSYS01_A.pdf%7FG-NICO-018
Max error +/-0.1C over -5C to +50C range.

It seems to me that Si7051 is cheaper (~$2 vs ~$6.80) and easier to use (6-pin package vs 16-pin) and also 0.1C accuracy.
 

Offline CatalinaWOW

  • Super Contributor
  • ***
  • Posts: 2108
  • Country: us
Re: Temperature logging interface
« Reply #15 on: July 25, 2017, 12:41:02 PM »
I have used a $30 Texas Instruments development board for their sensor quite successfully.  USB interface that looks like a serial port from the PC side. Works fine in VB. 

I am not sure the absolute accuracy of the sensor is really that critical for the type of metrology uses envisioned here.  The sensitivity to temperature of the things being measured is already low so a few tenths of a degree error in temperature will be a small contributor to the overall error.

In any case there is likely to be more difficulty in relating the sensor temperature to the temperature of the critical part of the device.  Are you interested in the temperature of the air inlet to the instrument, the air near the reference, the reference itself or something else.  Each of these locations presents unique problems in coupling the sensor and understanding differences between the sensor temp and "reality".
 

Offline IanJ

  • Frequent Contributor
  • **
  • Posts: 719
  • Country: scotland
  • Pro EE guy many years ago, now a hobby/home biz.
    • IanJohnston.com
Re: Temperature logging interface
« Reply #16 on: September 03, 2017, 08:06:26 PM »
Hi all,

I've updated my main 3458a Excel logging page with details of my first attempt at temperature logging.

http://www.eevblog.com/forum/metrology/3458a-logging-via-excel-macro/msg1293712/#msg1293712

Ian.
Ian Johnston
www.ianjohnston.com
Manufacturer of the PDVS2
 


Share me

Digg  Facebook  SlashDot  Delicious  Technorati  Twitter  Google  Yahoo
Smf