SBK-Spreadsheet

De MCHobby - Wiki
Révision datée du 5 juillet 2024 à 23:07 par Admin (discussion | contributions) (→‎Forewords)
(diff) ← Version précédente | Voir la version actuelle (diff) | Version suivante → (diff)
Sauter à la navigation Sauter à la recherche

Forewords

The SBK Datalogger does record data under the CSV format namely, a coma-separated value content see more on wikipedia).

Once the recorded CSV file available on your computer, the data it contains can be loaded and manipulated into a spreadsheet software.

The CSV file content is descrived in this section.

Loading the CSV file

Most of the countries do use dot as decimal separator. If it's your case then CSV file would be immediately loaded into the spreadsheet software.

France and Belgium do use a coma as decimal separator (and dot as thousands seperator).
Such regional settings are not compatible with the common CSV format using coma as field separator and dot as decimal separator.

Loading in LibreOffice Calc

Double clicking the CSV file do starts the spreadsheet software which then displays the "import" configuration window.

Selects:

  • Use UTF-8 character set
  • Select a "langage source" using the dot as decimal separator will helps a lot (eg: English based langage).
  • Select "coma" and "semi-colon" as field separator
  • Select "double-quotes" as string separator.

SBK-Spreadshee-01.png

The preview show data as they will be imported into the spreadsheet.

Press the OK button to load the data.

Voila! The data is available for any further treatment

SBK-Spreadsheet-02.png

Graph the data

Importing the data into the spreadsheet is a great way to do some math on it.

For sure, the most interesting task is to explore the data draw into a chart.

Charts with LibreOffice

The spreadsheet graphic tools can display a chart of single or multiple collection(s) of data.

To do so, select the "timing" column by clicking onto the columns header.

Then with the Control key held down, click on the column header to be added to the chart (in the following capture this concerns the column D & E).

SBK-Spreadsheet-50.png

Then selects the menu entry "Insert | Chart..."

SBK-Spreadsheet-51.png

Which displays the chart option dialog.

The chart configuration in made dead easy because:

  1. the timing data appears in the first columns.
  2. the data also contains column title in the first row.

Just select the XY chart type then single line to have thinner lines in the chart.

SBK-Spreadsheet-52.png

Just click the "Finish" button and the chart appears into the spreadsheet

SBK-Spreadsheet-53.png

The graph here above shows the values of accelerometer X & Y axis while turning the sensor. The value is return in multiple of g (so 9.81 m/s^2).

As we can expect, the value on X and Y axis should go from -1 to +1 depending on the orientation of the sensor relative to the earth center.

Any value outside of [-1..+1] range indicates an additional acceleration due my shaking hand.

Voilà!



Written by Meurisse D. for MCHobby


MCHobby investit du temps et de l'argent dans la réalisation de traduction et/ou documentation. C'est un travail long et fastidieux réalisé dans l'esprit Open-Source... donc gratuit et librement accessible.
SI vous aimez nos traductions et documentations ALORS aidez nous à en produire plus en achetant vos produits chez MCHobby.