Create-a-spreadsheet-to-collect-data.md

Detailed usage

1. Go to the Google Docs dashboard and create a new Spreadsheet using the big green "+" button on the right bottom:
   
2. Name the title of the spreadsheet "Speedtest", otherwise you can use SPREADSHEET environment variable while executing the script to use a different name.
3. Fill in the first four columns Date, Download, Upload and Ping:
   
4. Run the speedtest-to-google script to make sure it's working:
   /usr/local/bin/speedtest-to-google
5. Yep, it works:
   
6. Setup a cronjob so the speedtest runs automatically:
   crontab -e

and insert the following line to make the speedtest run every 10 minutes:

*/10 * * * * PATH=$PATH:/usr/local/bin /usr/local/bin/speedtest-to-google

Save and quit using Ctrl + X.

1. Now back in the spreadsheet, select the whole columns A - D by clicking on A, then with Shift + Click on D:
   
2. Click on "Insert" => "Chart" to create a chart.
3. In the "Start" tab type in, Sheet1!A:D:
   
4. In the "Charts" tab select a appropriate line chart type, "line chart" for example:
   
5. Click on the "Customise" tab for the final adjustments.
6. At the very top, check "Compare mode" in the features:
   
7. Scroll down to the "Series" group and select "Ping" in the drop down menu, then set it to "Left axis":
   
8. Finally, click on "Insert" to transfer the chart in your spreadsheet.
9. Now click on the little arrow in the top right corner of the chart and select "Publish chart":
   
10. Hit "Publish" to receive an URL which is publicly available.