Simple DAQ using Arduino+EthernetShield, Google Drive & PushingBox

    434 views
    0 comments
    0 likes
    details

    This project demonstrates a simple Data Aquisition (DAQ) with google spreadsheet and arduino. In general, DAQ stores input data (sensor) and adjust saving time (sampling rate) for a long period, but as it relies on Arduino’s hardware capacity and cheap sensors, it will only be able to handle a small amount of data per seconds.

     

    Parts
    Arduino Mega
    Arduino Ethernet Shield
    Router
    Switch and sensors

    <Hardware connection>

     

    Physical environment
    Arduino Mega2560 receives 5 sensor data that are connected to 3 switches and sends data through ethernet.

    Sensors ——>> Arduino and Ethernet Shield —Router
    SW1/SW2/SW3—>>

    [Sensor1]—–+      +—–[A0]—————-+=+————+

    [Sensor2]—–+      +—–[A1]-               |=|            |
    [Sensor3]—–+======+—–[A2]-   [ARDUINO]   |=|   Ethernet |
    [Sensor4]—–+      +—–[A3]-               |=|   Shield   |
    [Sensor5]—–+      +—–[A4]-               +=+————+
                               [  ]-               |      ||
    VCC—–+                  [  ]-               |      || LAN
            +–[SW_TACT1]-+—-[03]-               |      ||
            +–[SW_SLDR2]-+    [  ]-               | +————-+
    GND——–[10k]——+   [  ]-               | |             |
    GND—–[220ohm]—[LED]—[04]-               | |   Router    |
    GND——–[10k]——+—-[05]-               | |             |
    VCC——–[SW_SLDR3]-+        —————-+ +————-+

    ** SW_SLDR2 == ON & SW_SLDR3 == ON –>> continuous sampling

    ** SW_SLDR2 == OFF & SW_TACT1 –>> discrete sampling when tact switch pushed
     Step by Step guide
    1. Connect Arduino Mega 2560 and ethernet shield.
    2. Bridge a router (IP-TIME) and ethernet Shield with a LAN cable.
    3. As an image shown below, configure the network settings.

     

    4. Open a google account to use a google spreadsheet. Make five questions as five input data will be stored; fill up corresponding answers to the questions.

     

    5. Copy the link above as some of information needs to be extracted later on.

    https://docs.google.com/forms/d/1Bm0aiZU-5BtFmbkdq43iusDKzkpoNy3ci-XzG8jLrq4/viewform?entry.1187211743=1&entry.1887603566=2&entry.545717569=3&entry.740437495=4&entry.802468911=5

     

     For an actual data acquisition part, please follow the source link at the bottom of the page. 

    <A graph of data collected in google drive>

     

    Source
    : https://docs.google.com/forms/d/1Bm0aiZU-5BtFmbkdq43iusDKzkpoNy3ci-XzG8jLrq4/viewform?entry.1187211743=1&entry.1887603566=2&entry.545717569=3&entry.740437495=4&entry.802468911=5:

    http://electoy.tistory.com/170

    This project demonstrates a simple Data Aquisition (DAQ) with google spreadsheet and arduino. In general, DAQ stores input data (sensor) and adjust saving time (sampling rate) for a long period, but as it relies on Arduino’s hardware capacity and cheap sensors, it will only be able to handle a small amount of data per seconds.

     

    Parts
    Arduino Mega
    Arduino Ethernet Shield
    Router
    Switch and sensors

    <Hardware connection>

     

    Physical environment
    Arduino Mega2560 receives 5 sensor data that are connected to 3 switches and sends data through ethernet.

    Sensors ——>> Arduino and Ethernet Shield —Router
    SW1/SW2/SW3—>>

    [Sensor1]—–+      +—–[A0]—————-+=+————+

    [Sensor2]—–+      +—–[A1]-               |=|            |
    [Sensor3]—–+======+—–[A2]-   [ARDUINO]   |=|   Ethernet |
    [Sensor4]—–+      +—–[A3]-               |=|   Shield   |
    [Sensor5]—–+      +—–[A4]-               +=+————+
                               [  ]-               |      ||
    VCC—–+                  [  ]-               |      || LAN
            +–[SW_TACT1]-+—-[03]-               |      ||
            +–[SW_SLDR2]-+    [  ]-               | +————-+
    GND——–[10k]——+   [  ]-               | |             |
    GND—–[220ohm]—[LED]—[04]-               | |   Router    |
    GND——–[10k]——+—-[05]-               | |             |
    VCC——–[SW_SLDR3]-+        —————-+ +————-+

    ** SW_SLDR2 == ON & SW_SLDR3 == ON –>> continuous sampling

    ** SW_SLDR2 == OFF & SW_TACT1 –>> discrete sampling when tact switch pushed
     Step by Step guide
    1. Connect Arduino Mega 2560 and ethernet shield.
    2. Bridge a router (IP-TIME) and ethernet Shield with a LAN cable.
    3. As an image shown below, configure the network settings.

     

    4. Open a google account to use a google spreadsheet. Make five questions as five input data will be stored; fill up corresponding answers to the questions.

     

    5. Copy the link above as some of information needs to be extracted later on.

    https://docs.google.com/forms/d/1Bm0aiZU-5BtFmbkdq43iusDKzkpoNy3ci-XzG8jLrq4/viewform?entry.1187211743=1&entry.1887603566=2&entry.545717569=3&entry.740437495=4&entry.802468911=5

     

     For an actual data acquisition part, please follow the source link at the bottom of the page. 

    <A graph of data collected in google drive>

     

    Source
    : https://docs.google.com/forms/d/1Bm0aiZU-5BtFmbkdq43iusDKzkpoNy3ci-XzG8jLrq4/viewform?entry.1187211743=1&entry.1887603566=2&entry.545717569=3&entry.740437495=4&entry.802468911=5:

    http://electoy.tistory.com/170

    COMMENTS

    Please Login to comment
      Subscribe  
    Notify of
    POSTED BY
    george