As I have started my Air Quality project I was searching the web, trying to find information hot to calibrate my new Grove Dust Sensor (I would appreciate any information on this), my eye caught this site (Robottini) and I can say that I was excited.
Some guys from Parallax made a program called PLX-DAQ and it does this: Allows you to capture data in real time to your Excel spreadsheet and plot them (in real time too).
I did not spend much time with this program but I can say it works and its very easy. With this one the user doesn’t have to spent time importing csv files to excel or any other language he uses. As Parallax says: Parallax Data Acquisition tool (PLX-DAQ) software add-in for Microsoft Excel acquires up to 26 channels of data from any Parallax microcontrollers and drops the numbers into columns as they arrive. PLX-DAQ provides easy spreadsheet analysis of data collected in the field, laboratory analysis of sensors and real-time equipment monitoring.
I wrote a small script and uploaded to my Arduino to see if PLX-DAQ works. I used the same circuit as described in my previous article From Arduino to R (matlab,mathematica etc). The code is the following. Enjoy!!
[code language=”C”]
int LDR_Pin = A0;
int row = 0;
void setup() {
Serial.begin(128000); // opens serial port, sets data rate to 9600 bps
Serial.println("CLEARDATA");
Serial.println("LABEL,Time,LDR_Read");
}
void loop() {
int LDRReading = analogRead(LDR_Pin);
Serial.print("DATA,TIME,");Serial.println(LDRReading);
row++;
LDRReading++;
delay(100);
}
[/code]
Leave a Reply