Data Acquisition from Vernier to PC.

Using Arduino Project Guidance
10

vennishmuthu:
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!

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(" ,  ");