Go Down

Topic: Data Acquisition from Vernier to PC. (Read 1 time) previous topic - next topic

vennishmuthu

Hey guys i am doing a small project on Data Acquisition from a vernier Caliper to PC.

i was some what successful in transferring the data from Vernier to Arduino Serial window Screen.
but now i want to transfer my data to a Excel file.

I have used the PLX-DAQ software but i frankly don't know how to use this software,should we program some where or if we connect directly will it work.

can someone help me out...

strykeroz

Hi,

Would you consider writing this with the Processing language?  Only reasons I'd suggest that is it's what the Arduino IDE was apparently inspired by, so the environment is immediately familiar if you're already coding on the Arduino.  Also there's a great series of tutorial videos for getting your Arduino to communicate with a PC using it (by Jeremy Blum) so hopefully it won't be too much of a stretch as you're already writing to the USB port.

I'd suggest writing to a CSV file which Excel will be happy to read from.

Cheers ! Geoff
"There is no problem so bad you can't make it worse"
- retired astronaut Chris Hadfield

PeterH

If the caliper provides a serial port design for connection to a PC then I would expect the manufacturer to advise how to access the data from a PC, and usually they would also provide a user-friendly application to manage this for you.

Has the manufacturer provided this information and/or software? If so, why not use it?
I only provide help via the forum - please do not contact me for private consultancy.

liudr

Excel has some serial port capabilities but you need to write code in VBA. I did it ages ago but it works. I was able to update a chart live with data from arduino. Google how to do serial port in Excel.

retrolefty


Hey guys i am doing a small project on Data Acquisition from a vernier Caliper to PC.

i was some what successful in transferring the data from Vernier to Arduino Serial window Screen.
but now i want to transfer my data to a Excel file.

I have used the PLX-DAQ software but i frankly don't know how to use this software,should we program some where or if we connect directly will it work.

can someone help me out...


Well I think there are several methods you can use depending on your PC programming skills. I too used PLX-DAQ software a long time ago to import values from an external serial port directly into a Excel worksheet, but it's been some years and I certainly don't remember the details. And as lidur stated Excel has a build in VBA programming language that should be able to link up with a serial port and import values directly, just a matter of learning the programming skills required.
For a 'little' skills required solution you might look into using an PC terminal program (I use Brey terminal, but windows Hyper terminal should work) and have it save the serial data stream from your arduino to a simple text file. Then is a second step just manually import the file into a worksheet as CSV data?

Lefty

liudr

If I dig up my old project files, I will post here for the OP.

MikMo

If you have managed to get the data into your Arduino, the GoBetwino can send it to Excel, or to a CSV file on your PC.

supertechqc

I have great success with the UNO R3 to the serial monitor.  This code actually works without having to learn Process or any other weird libraries.

I a video I think was yours on Youtube...  Can you post the code for your project.  See mine:  supertechqc and on youtube supertechqc.

Does anyone have caliper data code for Leonardo so I can send data in a keyboard function to Excel?

Hello Vennishmuthu,

If the caliper provides a interface style for association to a computer then i'd expect the manufacturer to advise a way to access the info from a computer, and frequently they might additionally give a easy application to manage this for you.

Has the manufacturer provided this data and/or thusftware? If so, why not use it?

Best of luck for your future.
Cheers,
Jean wilson

Measuring Tools

Nick_Pyner

#9
Dec 05, 2013, 05:27 am Last Edit: Dec 05, 2013, 05:29 am by Nick_Pyner Reason: 1

I was some what successful in transferring the data from Vernier to Arduino
I want to transfer my data to a Excel file.

I have used the PLX-DAQ software but i frankly don't know how to use this software,should we program some where or if we connect directly will it work.



PLX-DAQ is all you need and it is just a matter of formatting the output from Arduino. The rest of the instructions are quite OK.

Here is some stripped down code.  This is to make a live file in Excel with data/time stamping and some temperature readings. There only two lines that count, labelled here, and here. The real joy of PLX is that it can plot real-time graphs in Excel, but I guess you don't need that!

Code: [Select]
void setup() {
 lcd.init();  
 Wire.begin();
 Serial.begin(9600);

 Serial.println("LABEL,Time,InTemp,OutTemp,diff,DrainTemp");  // HERE

 sensors.setResolution(InThermo, 12);
 sensors.setResolution(OutThermo, 12);
 sensors.setResolution(DrainThermo, 12);

 Serial.println("Starting multiple datastream upload to Cosm...");
 Serial.println();
}

void loop() {
   running();
  GetClock();

Serial.print("DATA,TIME,       "); // AND HERE

 Serial.print(monthDay);
  Serial.print("/");
  Serial.print(month);
  Serial.print("/");
  Serial.print(year);
  Serial.print(" ");
  Serial.print(hour);
  Serial.print(":");
  Serial.print(minute);
  Serial.print(":");
   if ((second) < 10)
 {
   Serial.print("0");
 };
  Serial.print(second);
  Serial.print("       ");

 int ret=0;
 //get the values from the DS8B20's
 sensors.requestTemperatures();

 float InTemp = (sensorValue(InThermo));
 float OutTemp = (sensorValue(OutThermo));  
 float DrainTemp = (sensorValue(DrainThermo));

 Serial.print(InTemp);
 Serial.print(" ,  ");
 Serial.print(OutTemp);
 Serial.print(" ,  ");
 Serial.print(DrainTemp);
 Serial.println(" ,  ");




Go Up