Go Down

Topic: Using PLX DAQ with Microsoft Excel 2010 (Read 8402 times) previous topic - next topic

NiveditMishra

I've made a kind of noise pollution sensor with a sound sensor, some LED pins and an LCD display. It takes values from the sound sensor, then checks if it is more than the threshold value. If it is, it lights up the LED and displays a message on the LCD display. Pretty basic stuff.

I also wanted to take the values from the sound sensor, send it to Excel using PLX-DAQ and plot a real-time graph depicting the peaks in sound values.

Everything works fine, except the fact that nothing shows up on Excel. The program executes perfectly, I can even see the values of the sound sensor on the Serial Monitor but there's nothing on Excel.

I'm using an Arduino/Genuino 101 on a Windows 7 machine, with Microsoft Excel 2010.

Device Manager says that my board is connected to COM17 (it's the only port where I'm able to upload anything on the board, the laptop doesn't detect the board on any other port). Now, as you all would know, the Ports drop-down menu in PLX DAQ goes only uptil 15. So, I manually selected all the ports one by one to see where my board is.

PLX-DAQ detected the board on port 3. The C, R and T characters became green in colour and it said "Connected". But when I ran the program, nothing showed up on Excel. It doesn't say "accepting data for row 1, row 2.." like I was expecting it to. It just sits there like that. (I clicked "OK" when it said PLX-DAQ wants to use ActiveX controls, so I don't think that's the problem).

I reinstalled PLX-DAQ but to no avail. I went to their official website and there it says:

"System Requirements

    Microsoft Windows 98
    Microsoft Office/Excel 2000 to 2003
    May not work with newer software; no longer supported "

This made me suspect that maybe PLX-DAQ is not supported on Excel 2010. That is the only logical conclusion that is left, I've exhausted all other options.

But I really need a real-time graph of the sound sensor values for my project. Is there any way I can do this? Is there an alternate version of PLX-DAQ for higher versions of Windows or Microsoft Office? If not, is there any other method to plot a real-time graph of the sound sensor values?

Any help will be appreciated. Thanks.

PROGRAM CODE:

Code: [Select]

#include <LiquidCrystal.h>
LiquidCrystal lcd(12, 11, 5, 4, 3, 2);

void setup() {
  Serial.begin(9600);
  pinMode(A1, INPUT);
  pinMode(13, OUTPUT);
  Serial.println("CLEARDATA");
  Serial.println("LABEL, Current Time, Sound Level");
  lcd.setCursor(0,1);
    lcd.begin(16, 1);
    lcd.print("LCD OK!");
 
 
}

void loop() {
  lcd.setCursor(0, 1);
  int ledState = LOW;
  ledState = digitalRead(13);
  int soundSensorVal = 0;
  int threshold = 130;
  soundSensorVal = analogRead(A1);


  if(soundSensorVal>=threshold)
    { digitalWrite(13, HIGH);
      Serial.print("DATA,TIME");
      Serial.println(soundSensorVal);
      delay(100);
      lcd.clear();
      lcd.print("DANGER!");
     
    }

  if(soundSensorVal<=threshold)
    { digitalWrite(13, LOW); 
      Serial.print("DATA, TIME,");
      Serial.println(soundSensorVal);
      delay(100);
      lcd.clear();
      lcd.print("SAFE!"); 
    }

 

}




ieee488

This made me suspect that maybe PLX-DAQ is not supported on Excel 2010.
Gee, do you think? ? ?



PaulS

Quote
If not, is there any other method to plot a real-time graph of the sound sensor values?
Yep. Write your own program. Not exactly rocket science, you know.
The art of getting good answers lies in asking good questions.

Nick_Pyner

If not, is there any other method to plot a real-time graph of the sound sensor values?
If that is really all you want to do, then yes. This is something you really need to know before you go out and re-invent the wheel. You might try Live Graph, and there are others that I cannot remember but might come out of a Google search.


NiveditMishra

If that is really all you want to do, then yes. This is something you really need to know before you go out and re-invent the wheel. You might try Live Graph, and there are others that I cannot remember but might come out of a Google search.


Thanks a lot. I'll try that.

Gee, do you think? ? ?



Yep. Write your own program. Not exactly rocket science, you know.
A little less sarcasm would do you all a lot of good, don't you think?

ieee488


A little less sarcasm would do you all a lot of good, don't you think?
A little bit more common sense would do you a lot of good, don't you think? ? ?


NetDevil

#6
Nov 30, 2016, 10:11 pm Last Edit: Dec 02, 2016, 07:18 am by NetDevil
Hey there.

I found out that the original PLX DAQ can only be used with Excel 32 bit versions. Error message is "object not available on this machine" due to selmaDAQ_Ver2.ocx that is not 64 bit compatible)

You can check out the new version I developed with full Office support (32 bit and 64 bit and versions up to Office 2016) on the official Arduino board here: https://forum.arduino.cc/index.php?topic=437398.0

If you have any questions I will try to answer them on the board of course :-)
The new module is now open code and can be enhanced if needed.

Greetings and don't be frustrated anymore! PLX DAQ is very cool and now works with all Office / Excel versions.

NetDevil

(I posted this to all "first search site result" websites I found with Google for PLX DAQ issues so the next users of PLX DAQ can find the new version as fast as possible :-) sorry for grave digging this thread)

larryd

@NetDevil
There is something wrong with your link.


.
No technical PMs.
If you are asked a question, please respond with an answer.
If you are asked for more information, please supply it.
If you need clarification, ask for help.

NetDevil

#8
Dec 02, 2016, 07:19 am Last Edit: Dec 02, 2016, 08:28 pm by NetDevil
@NetDevil
There is something wrong with your link.
Fixed as well. Thanks for the information

ianthetraveller

Just to say Thanks NetDevil, I've been using successfully for about a year to measure the Ah in lead-acid batteries. Works a treat.

Go Up