Test and Measurement Forum

TC08 Monitoring Heatup Profiles using Excel

Post your VB and VBA discussions here

TC08 Monitoring Heatup Profiles using Excel

Postby Michael Hayes » Sat Jun 05, 2010 7:44 am

I originally posted this about 5 or 6 years ago but noticed that the old posts seem to have been purged. As I still use this and find it very useful I decided to post again.
This concerns using a TC-08 USB to monitor a bunch of thermocouples and the logging of the data into an excel spreadsheet. The TC08 simply needs to be running and excel uses a DDE transfer to get the data. The logging period is selectable in excel as is a composite chanel made up of a weighted average of the 8 real inputs.
The computer can be used while the logging is occuring but would not be recomended. You can also specify a save frequency. If the power goes down, simply set up again and resume logging and you will get a gap in the data during the off period.
I use it to monitor furnace heatups and have also built in 3 configurable heatup profiles. You also set the deviation from these profiles which cause the logged values to change colour to red or blue depending on whether the temperature is above or below the profile.
Attachments
Heatup V1.1.xls
(209.5 KiB) Downloaded 197 times
Michael Hayes
User
User
 
Posts: 3
Joined: Wed Jan 18, 2006 7:57 am
Location: Sydney

Return to VB and VBA (Excel, Access)

Who is online

Users browsing this forum: No registered users and 0 guests