Recording Voltage readings in Excel

  • Thread starter Thread starter dingpud
  • Start date Start date
  • Tags Tags
    Excel Voltage
Click For Summary

Discussion Overview

The discussion revolves around capturing voltage readings in Excel using various USB interface modules and data loggers. Participants explore options for real-time data acquisition, timer functions in Excel, and the necessary components for effective data logging.

Discussion Character

  • Exploratory
  • Technical explanation
  • Debate/contested
  • Homework-related

Main Points Raised

  • One participant inquires about USB interface modules for capturing multiple voltage or current readings in Excel.
  • Another participant mentions a preference for Mac and does not provide specific suggestions.
  • A suggestion is made to check a specific website for examples of data loggers that can interface with Excel.
  • A participant shares their experience using Visual Basic macros for data capture over RS232 but notes challenges with USB access.
  • Discussion includes the need for a data acquisition component that can digitize voltage readings and possibly log data for later export to Excel.
  • Concerns are raised about the reliability of low voltage levels on serial lines for data acquisition due to potential signal distortion.
  • One participant expresses a desire for real-time data logging and considers purchasing a data logger from eBay.
  • Additional resources for affordable USB data loggers with Excel output are shared.
  • A participant expresses satisfaction with a specific data logger recommendation and plans to provide feedback if purchased.

Areas of Agreement / Disagreement

Participants generally agree that data loggers are a suitable solution for capturing voltage readings, but there are differing opinions on the best approach and specific devices to use. The discussion remains unresolved regarding the optimal method for real-time data capture in Excel.

Contextual Notes

Participants mention various types of interface modules and data acquisition components, but there is no consensus on the best specific products or methods. Limitations in accessing USB ports and the need for voltage transformation are noted but not fully explored.

Who May Find This Useful

This discussion may be useful for individuals interested in data acquisition, particularly those looking to integrate voltage readings into Excel for analysis or logging purposes.

dingpud
Messages
198
Reaction score
1
I am sure that many of you are using Excel to do data capture, what are some suggestions as to a USB interface module that will allow multiple voltage or current readings.

Also, any suggestions on any built in timer functions in Excel?

Thanks,
pud
 
Engineering news on Phys.org
Couldn't begin to tell you, pal... I'm a Mac guy.
 
I have used Excel Visual Basic macros to capture data over a RS232 cable. I was unable to find code which allowed me to directly access a USB port thou I did not research it very far.

VB has a timer function, IIRC it does not quite work the way I wanted it to, but I could use to take timed measurements.

alt f11, will get you into the VB editor, use the help function, and find a reference for VB coding.

I am not sure what kind of module you are looking for, seems like you need a smart (at with some form of communications) instrument. You should be looking for an instrument, not a USB module.
 
These instruments essentially have two or three parts: they need an interface module, a data acquisition component (in this case, something to read voltage and digitize it), and optionally, memory to log it. Here's an example of one my company sometimes uses: http://www.microdaq.com/supco/logit/lcv.php

These don't go realtime into Excel, you data log, then export to Excel later.

There may still be interface devices specifically designed to take a 0-10V signal, digitize it, and send it to a computer. You'd still need a voltage transformer to get the signal down to 0-10V.
 
Definitely data loggers are the way to go. I don't think I would trust a low voltage level on a serial line as the DAQ path. There would be too much room for signal distortion I would think.
 
I appreciate all of the responses, and I will continue to update as I get new information. I definitely want to try and keep it real time.

Data logger is what I was looking towards...guess it's time to go on ebay...

thanks all...

BTW...work has really been interupting the amount of time that i get to surf PF... any suggestions? Other than quitting?
 
Anhar Miah, this looks like it will work perfectly. The price is nice too. If I end up getting one, I'll try and give some feedback.

Thanks again.
 

Similar threads

Replies
2
Views
2K
Replies
20
Views
3K
Replies
2
Views
1K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 17 ·
Replies
17
Views
3K
Replies
2
Views
2K
  • · Replies 7 ·
Replies
7
Views
2K
  • · Replies 13 ·
Replies
13
Views
2K
  • · Replies 14 ·
Replies
14
Views
2K
  • · Replies 16 ·
Replies
16
Views
2K