arduino data acquisition into excel for mac

Arduino Data Acquisition Into Excel Software Doesnt Work

Arduino Data Acquisition Into Excel Software Doesnt Work

We can use Excel to store data in a sheet and display it in a graph using an application available on the network called PLX-DAQ (Parallax Data Acquisition), but this software doesnt work under Windows 10 and is no longer supported.

So we can found a new version of PLX-DAQ re-written by NetDevil, an Arduino forums member, to be able to be run on modern systems.

We take a device of any ohmic value and connect its two external pins respectively to 5V and GND pins supplied by Arduino.

We pick up the voltage signal offered by the central pin, which varies according to the resistive divider that is formed while we turn its knob.

To collect data from our experiment, we can open the PLX-DAQ-v2.11.xlsm worksheet which contains a macro that allows us to save the data from the USB in Excel.

Before clicking on the Connect button, we have to open Arduino IDE and use the sketch that is reported below, or use that is provided with PLX-DAQ software distribution.

We have programmed the Serial.print instructions according to the modality proposed by PLX-DAQ (see the reactive help for more details).

Arduino transforms all the signals that it receives on analogue pins into levels between 0 and 1023, so it is our task to enter in the sketch the calculations necessary to return the correct interpretation to the numerical values obtained.

In this case the range 01023 represents the voltages between 05V, so we insert the instruction: sensorVoltage sensorValue5.01023.0.

Arduino Data Acquisition Into Excel For Mac