❏ Verify that you receive data similar to that shown in
❏ Open the dial_data.csv file in NotePad. Highlight the
text from the Arduino that precedes that dial data. This
should appear similar to Figure 22.
❏ Erase that highlighted data which should leave only the
dial data as shown in Figure 23.
❏ Save the edited dial_data.csv.
❏ You will need to create an account for Google Drive.
Since Google seems to change how this is done on
occasion, we will not go into the details here. If the
instructions are insufficient, then search Google for
further information and play with the charting feature. It
can be obtuse, but Google is very good at making
things simple, so you will figure this out.
❏ In your file explorer, click on dial_data.csv and then
drag and drop it onto your Drive page. It will then be
uploaded to your Google Drive.
❏ In your Google Drive, click on CREATE and then click
❏ In the spreadsheet, click on File/Import and select the
dial_data.csv file from your Google Drive.
❏ Click on the 'Insert Chart' icon on the spreadsheet
❏ In the Chart Editor, click on the 'Switch rows/columns,’
then select a line chart and add text for the title and
axes so the chart appears as in Figure 24.
❏ Examine Figure 24 and see if you can notice a problem
with the data.
❏ The dial goes from zero to 180, but the chart values
exceed 180. What does this indicate?
❏ Probably, I swished the dial too far to the right
exceeding the 180 mark, but nonetheless, this does
give an example of how you can display a block of data
and notice things that you might not have noticed in
the raw data.
Next month, we will finish Arduino 101 by applying
all that we have learned so far to build a battery-powered
data logger that will measure temperature and light levels.
January 2015 61
■ FIGURE 21: Pu TTY receives the dial data.
■ FIGURE 22: Dial data sent to
dial_data.csv before deletion.
■ FIGURE 23: Dial data sent to
dial_data.csv after deletion.
■ FIGURE 24: Dial data shown in Google Chart.