Excel Temperature Measurement


An Excel Temperature Measurement Data Acquisition Solution

There are generally speaking, a number of ways to collect temperature data with a PC.  Use commercial off the shelf software (COTS) provided with a data collection system (not flexible, but very low labor), use custom configurable software ( moderately flexible, low labor), or use a software development environment to write custom software (extremely flexible, high labor).

For the non-programmer, the most difficult method is use a software development environment to write custom software. Without the knowledge of computer software development, this may make the task difficult to complete in a realistic period of time.

The simplest method is to use a device, with the COTS software, written specifically for the measurement device. It allows a user to setup a system and start taking data is as short a period as possible. It may or may not do exactly what you want, with no ability to customize it, but it’s simple.

As an alternate method; temperature measurement real time using Excel, allows the non-programmer a way to configure a custom temperature data collection application. The use of Excel, a commonly used spreadsheet program, allows a user with business software experience to setup a data collection, and display application; taking advantage of the macros and charting tools available within Excel. While this is not the simplest method, it allows a greater flexibility than COTS software, and a greater simplicity than using a software development environment.

The connection to Excel is made simple in part by using an add in to Excel such as ROI-XL. It allows a simple connection to Excel. Used with devices, such as the ROI-USB or the ROI-RFX, that is designed to read temperature; it allows a user to setup a system and start taking data is as short a period as possible, with the benefit of customizing it when needed. Another way is to use keyboard wedge software to allow the device to act as it a person was directly typing, this allows any type of spreadsheet, e.g. Google Sheets or Open Office Calcs, to be used. Either way, you can turn a PC into an inexpensive data acquisition system or data logger.

Learn more about ROI-USB general purpose A-D’s, family of data acquisition modules

Learn more about ROI-RFX Wireless Sensor Network components