Go Down

### Topic: Problem displaying multiple columns in excel PLX-DAQ (Read 939 times)previous topic - next topic

#### Summer82 ##### Jul 18, 2017, 01:05 pm
Hi ,
I used this code to display flow rate, liquid passed/sec and total liquid, I tried different Serial.print options to print them in three columns but it is either combining two data in the same column or ignoring one. It is showing five columns for time, timer, flow rate, liquid, total liquid but the displayed data is not the correct data.
I tried using arduino code and it is giving the correct data on the serial monitor but the problem with the added lines relating to PLX-DAQ.
I attached the code below.
`/*Liquid flow rate sensor -DIYhacking.com Arvind SanjeevMeasure the liquid/water flow rate using this code. Connect Vcc and Gnd of sensor to arduino, and the signal line to arduino digital pin 2.  */byte statusLed    = 13;byte sensorInterrupt = 0;  // 0 = digital pin 2byte sensorPin       = 2;// The hall-effect flow sensor outputs approximately 24 pulses per second per// litre/minute of flow.float calibrationFactor = 24;volatile byte pulseCount;  float flowRate;unsigned int flowMilliLitres;unsigned long totalMilliLitres;unsigned long oldTime;void setup(){    // Initialize a serial connection for reporting values to the host  Serial.begin(38400);  // Set up the status LED line as an output  pinMode(statusLed, OUTPUT);  digitalWrite(statusLed, HIGH);  // We have an active-low LED attached    pinMode(sensorPin, INPUT);  digitalWrite(sensorPin, HIGH);  pulseCount        = 0;  flowRate          = 0.0;  flowMilliLitres   = 0;  totalMilliLitres  = 0;  oldTime           = 0;  // The Hall-effect sensor is connected to pin 2 which uses interrupt 0.  // Configured to trigger on a FALLING state change (transition from HIGH  // state to LOW state)  attachInterrupt(sensorInterrupt, pulseCounter, FALLING);Serial.println("CLEARDATA"); //clears up any data left from previous projectsSerial.println("LABEL,Time,Timer,Flow Rate (L/min),Current liquid Flowing (ml/Sec),Output Liquid Quantity (ml)"); //always write LABEL, so excel knows the next things will be the names of the columns (instead of Acolumn you could write Time for instance)Serial.println("RESETTIMER"); //resets timer to 0  }/** * Main program loop */void loop(){    if((millis() - oldTime) > 1000)    // Only process counters once per second  {     // Disable the interrupt while calculating flow rate and sending the value to    // the host    detachInterrupt(sensorInterrupt);            // Because this loop may not complete in exactly 1 second intervals we calculate    // the number of milliseconds that have passed since the last execution and use    // that to scale the output. We also apply the calibrationFactor to scale the output    // based on the number of pulses per second per units of measure (litres/minute in    // this case) coming from the sensor.    flowRate = ((1000.0 / (millis() - oldTime)) * pulseCount) / calibrationFactor;        // Note the time this processing pass was executed. Note that because we've    // disabled interrupts the millis() function won't actually be incrementing right    // at this point, but it will still return the value it was set to just before    // interrupts went away.    oldTime = millis();        // Divide the flow rate in litres/minute by 60 to determine how many litres have    // passed through the sensor in this 1 second interval, then multiply by 1000 to    // convert to millilitres.    flowMilliLitres = (flowRate / 60) * 1000;        // Add the millilitres passed in this second to the cumulative total    totalMilliLitres += flowMilliLitres;          unsigned int frac;        // Print the flow rate for this second in litres / minute    Serial.print("Flow rate: ");    Serial.print(int(flowRate));  // Print the integer part of the variable    Serial.print(".");             // Print the decimal point    // Determine the fractional part. The 10 multiplier gives us 1 decimal place.    frac = (flowRate - int(flowRate)) * 10;    Serial.print(frac, DEC) ;      // Print the fractional part of the variable    Serial.print("L/min");    // Print the number of litres flowed in this second    Serial.print("  Current Liquid Flowing: ");             // Output separator    Serial.print(flowMilliLitres);    Serial.print("mL/Sec");    // Print the cumulative total of litres flowed since starting    Serial.print("  Output Liquid Quantity: ");             // Output separator    Serial.print(totalMilliLitres);    Serial.println("mL");                 Serial.print("DATA,TIME,TIMER,");        Serial.print(int(flowRate));  // Print the integer part of the variable    Serial.print(".");             // Print the decimal point    // Determine the fractional part. The 10 multiplier gives us 1 decimal place.    frac = (flowRate - int(flowRate)) * 10;    Serial.print(frac, DEC) ;      // Print the fractional part of the variable            Serial.print(",");    Serial.print(flowMilliLitres);    Serial.print(",");    Serial.print(totalMilliLitres);               Serial.println(); //be sure to add println to the last command so it knows to go into the next row on the second run    delay(100); //add a delay        // Reset the pulse counter so we can start incrementing again    pulseCount = 0;        // Enable the interrupt again now that we've finished sending output    attachInterrupt(sensorInterrupt, pulseCounter, FALLING);  }}/*Insterrupt Service Routine */void pulseCounter(){  // Increment the pulse counter  pulseCount++;}`
{"ft_lang_label":"__label__en","ft_lang_prob":0.65081036,"math_prob":0.95216787,"size":5073,"snap":"2019-35-2019-39","text_gpt3_token_len":1211,"char_repetition_ratio":0.14933912,"word_repetition_ratio":0.110091746,"special_character_ratio":0.25054207,"punctuation_ratio":0.15393259,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.98438853,"pos_list":[0,1,2],"im_url_duplicate_count":[null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2019-09-16T02:06:28Z\",\"WARC-Record-ID\":\"<urn:uuid:b03ce7e1-d7bb-497c-9633-6a622c0c1c6d>\",\"Content-Length\":\"24563\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:168d6811-c9ef-4fb3-9c41-0107daf6fd63>\",\"WARC-Concurrent-To\":\"<urn:uuid:1ad80a9c-f5c2-4e28-b466-df79e210b75a>\",\"WARC-IP-Address\":\"104.20.190.47\",\"WARC-Target-URI\":\"https://forum.arduino.cc/index.php?topic=489780.0;prev_next=prev\",\"WARC-Payload-Digest\":\"sha1:PPPIXGXRNZO6C5W62XUM6SIZITLXZ2SE\",\"WARC-Block-Digest\":\"sha1:KYJ5B3JPH7TVP7MOFLXGFKGO2ANVOB3W\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2019/CC-MAIN-2019-39/CC-MAIN-2019-39_segments_1568514572471.35_warc_CC-MAIN-20190916015552-20190916041552-00339.warc.gz\"}"}