eChook GPT Documentation
  • Welcome to the eChook nano documentation
  • System Overview
  • The eChook Nano Kit
    • Versions
  • Build Instructions (Kit V1.x)
    • Build Steps Photos
    • First Power On
  • Build Instructions (Kit V2+)
  • Programming the Arduino
    • Install Arduino IDE
    • Arduino Drivers
    • Download the eChook Arduino Code
    • Programming the Arduino
  • Setting up the Bluetooth
    • Pairing with a phone
  • Connecting the eChook to the Car
    • Power and Voltage
    • Current Sensor
    • Throttle Input
    • External Buttons and Brake
    • Temperature Sensors
    • Wheel and Motor RPM
    • PWM Output
  • Calibrating the eChook
    • Wheel Speed and Motor RPM
    • Temperature
    • Voltage
    • Current
  • Using the App
    • Pair eChook to Phone
    • Setting up the App
    • Logging Data
    • Lap Counting
  • Telemetry (Live Data)
    • eChook Live Data
    • Node-Red Integration
    • DIY Web Dashboard
  • Using the Data
  • Circuit Schematics
    • 12 and 24v Inputs
    • Temperature Inputs
    • Bluetooth Module
    • Throttle Input
    • Current Input
    • Button Inputs
    • RPM Inputs
    • PWM Output
    • Power Regulator
    • Expansion Port
  • All about the Arduino nano
    • The eChook nano Code
  • Bluetooth Communication
    • Bluetooth Packet Encoding
    • Bluetooth Packet Decoding
  • Experimental Section
    • GUI Calibration
  • eChook Accessories
  • DIY eChook
  • Spare Parts
  • Troubleshooting
  • Contributing
Powered by GitBook
On this page
  • Retrieving data from phone
  • Opening the Data
  • Graphing the data

Was this helpful?

Using the Data

PreviousDIY Web DashboardNextCircuit Schematics

Last updated 6 years ago

Was this helpful?

It’s time to get the data off the phone and onto a computer for some useful analysis.

Retrieving data from phone

In the eChook app settings, the top option is to share data. Tap this to display a list of ways to send the data file to via service you wish.

Alternatively, the data is saved in a .csv file in the phone's downloads folder so can also be retrieved via a file manager app, or via a USB connection to a computer.

Opening the Data

Open the arduino.csv file in a spreadsheet programme such as Excel. Data identifying names will be along the top, and the data below. The one bit of data that is not immediately readable is the timestamp, as this is recorded in , as milliseconds since 00:00:00 1st January 1970.

This needs to be converted in excel using the following formula:

=A2/(1000*60*60*24)+"1/1/1970"

Create a new column for Time and set the cell number format to Time. Enter the formula above, replacing ‘A2’ with the timestamp cell on the same row. Once the cell shows a legible timestamp, select it and double click the bottom right corner of the cell to propagate the calculation down the whole sheet.

This converts milliseconds to days (the multiplication) and adds them to the start point of Unix Time. This is now a value that excel will recognise as a time and date when the cell format is set to time.

Graphing the data

To start looking at the data in a meaningful way, graphs are needed. To start with, select the columns Time, Voltage and Current, then go to Insert>Charts>Scatter with Smooth lines. This will give a voltage and current over time graph. Add and remove data to see what you want!

Unix Time