PLX-DAQ mode

DAELOC is compatible with PLX-DAQ and implements all commands.

Supported Commands

Command	Description
CLEARSHEET	Clears the entire sheet, including labels and data.
CLEARDATA	Clears only the data, keeping column labels intact.
LABEL, col1, col2, ...	Defines column headers for incoming data.
DATA, value1, value2, ...	Inserts a row of data into the spreadsheet.
DATA, ..., AUTOSCROLL_25	Inserts row while keeping 25 rows visible.
CELL,SET,cell,value	Sets a value in a specific cell.
CELL,SET,ONSHEET,...	Sets a value in a cell on a specific sheet.
CELL,GET,cell	Retrieves the value from a cell.
CELL,GET,FROMSHEET,...	Retrieves the value from a cell on a sheet.
CUSTOMBOXn,LABEL,label	Sets the label of a custom box (n=1,2,3,4).
CUSTOMBOXn,SET,value	Sets the value (0 or 1) of a custom box.
CUSTOMBOXn,GET	Gets the value of a custom box.
ROW,GET	Retrieves the current logging row.
ROW,SET,value	Sets the row to start logging.
CLEARRANGE, ...	Clears a specific range of cells.
RESETTIMER	Resets the internal timestamp timer.
PAUSELOGGING	Temporarily pauses logging.
RESUMELOGGING	Resumes logging after a pause.
STOPLOGGING	Stops logging completely.
SAVEWORKBOOK	Saves the current workbook.
SAVEWORKBOOKAS, filename	Saves workbook under a new name.
MSG, text	Displays a message in the UI.
FORCEEXCELQUIT	Forces LibreOffice Calc to quit.
BEEP	Emits a beep sound from LibreOffice.
DONE	Flush serial buffer.
GETRANDOM, min, max	Generates a random number in a range.

Command reference

CLEARSHEET

Clears the entire sheet, including labels and data.

Example:

CLEARSHEET

CLEARDATA

Clears only the data, keeping the column labels intact.

Example:

CLEARDATA

LABEL, col1, col2, ...

Defines column headers for incoming data.

Example:

LABEL, Time, Temperature, Humidity

DATA, value1, value2, ...

Inserts a row of data into the spreadsheet.

Example:

DATA, 12:00:01, 25.6, 55

DATA, value1, value2, ..., AUTOSCROLL_25

Inserts a row of data into the spreadsheet while keeping only 25 lines visible (auto-scroll enabled).

Example:

DATA, 12:00:01, 25.6, 55, AUTOSCROLL_25

CELL,SET,cell,value

Inserts a specific value into a designated cell.

Example:

CELL, SET, A1, 42

CELL,SET,ONSHEET,sheetname,cell,value

Inserts a specific value into a designated cell on a specific sheet.

Example:

CELL, SET, ONSHEET, Info, A1, 42

CELL,GET,cell

Retrieves the value from a specific cell.

Example:

CELL, GET, A1

CELL,GET,FROMSHEET,sheetname,cell

Retrieves the value from a specific cell on a specified sheet.

Example:

CELL, GET, FROMSHEET, Info, A1

CUSTOMBOXn,LABEL,label

Sets the label for a custom box (n=1,2,3,4).

Example:

CUSTOMBOX1, LABEL, Sensor Active

CUSTOMBOXn,SET,value

Sets a value (0 or 1) for a custom box (n=1,2,3,4).

Example:

CUSTOMBOX1, SET, 1

CUSTOMBOXn,GET

Retrieves the value of a custom box (n=1,2,3,4).

Example:

CUSTOMBOX1, GET

ROW,GET

Retrieves the current row where data is being logged.

Example:

ROW, GET

ROW,SET,value

Sets the row number to start logging to.

Example:

ROW, SET, 5

CLEARRANGE, col_start, row_start, col_end, row_end

Clears a specific range of cells.

Example:

CLEARRANGE, A, 2, A, 10

RESETTIMER

Resets the internal timer (used for timestamps).

Example:

RESETTIMER

PAUSELOGGING

Temporarily pauses data logging.

Example:

PAUSELOGGING

RESUMELOGGING

Resumes logging after a pause.

Example:

RESUMELOGGING

STOPLOGGING

Stops logging completely (manual restart required).

Example:

STOPLOGGING

SAVEWORKBOOK

Saves the current workbook.

Example:

SAVEWORKBOOK

SAVEWORKBOOKAS, filename

Saves the current workbook under a new name.

Example:

SAVEWORKBOOKAS, experiment1.ods

MSG, text

Displays a message in the UI message box.

Example:

MSG, Data logging started.

FORCEEXCELQUIT

Forces LibreOffice Calc to quit.
⚠️ Use with caution, data will be lost unless saved!

Example:

FORCEEXCELQUIT

BEEP

Makes LibreOffice emit a beep sound.

Example:

BEEP

DONE

Flush serial buffer.

Example:

DONE

GETRANDOM, min, max

Generates a random number within a specified range.

Example:

GETRANDOM, 1, 100

Example Arduino Sketch

Example PLX-DAQ sketch

void setup() {
  Serial.begin(9600);
  Serial.println("CLEARDATA");
  Serial.println("LABEL,Time,Temperature (c),Light (%)");
}

void loop() {
  int temp_value = analogRead(A0);
  float temp = (temp_value * 500)/1023;

  int ldr_value = analogRead(A1);
  float ldr_percent = map(ldr_value,0,1023,0,100);

  Serial.print("DATA,TIME,");
  Serial.print(temp);
  Serial.print(",");
  Serial.println(ldr_percent);    
  delay(1000);
}