To save the data, Parallax Data Acquisition (PLX-DAQ) has been used with the help of Microsoft Excel. As some blind persons were computer literate, they can save the heart rate by their own. Before start, download PLX-DAQ and enable Active X and Macro on Microsoft Excel. Then put the following code in the Arduino IDE;
i. Serial.println("CLEARDATA");
This line required to clears sheet starting from row 2.
ii. Serial.println("CLEARSHEET");
This line has to clears sheet starting from row 1.
iii. Serial.println("LABEL,Date,Time,Heart Beat,millis");
It defines four columns named "Date", "Time", "Timer", "Heart Beat" and "millis". This part can be edited according to the data obtained.
iv. Serial.println( (String) "DATA,DATE,TIME," + myBPM + "," + millis() + ",AUTOSCROLL" );
Getting the data from the sensor to be included in the Excel.
v. Serial.println("CELL,GET,FROMSHEET,Simple Data,E,4");
Serial.println((String) "Value of cell E4 is: " + myBPM);
The line E4 from the Excel has been selected to fill in the value of the sensor.
As the code has been wrote, run the code at the same time connect PLX-DAQ and Arduino Uno with the same port and baudrate. Picture below shows the result:
i. Serial.println("CLEARDATA");
This line required to clears sheet starting from row 2.
ii. Serial.println("CLEARSHEET");
This line has to clears sheet starting from row 1.
iii. Serial.println("LABEL,Date,Time,Heart Beat,millis");
It defines four columns named "Date", "Time", "Timer", "Heart Beat" and "millis". This part can be edited according to the data obtained.
iv. Serial.println( (String) "DATA,DATE,TIME," + myBPM + "," + millis() + ",AUTOSCROLL" );
Getting the data from the sensor to be included in the Excel.
v. Serial.println("CELL,GET,FROMSHEET,Simple Data,E,4");
Serial.println((String) "Value of cell E4 is: " + myBPM);
The line E4 from the Excel has been selected to fill in the value of the sensor.
As the code has been wrote, run the code at the same time connect PLX-DAQ and Arduino Uno with the same port and baudrate. Picture below shows the result:
Results on Microsoft Excel via PLX-DAQ

Comments
Post a Comment