Tweet
What I've found most useful in Google Docs can be summed up in three words. "Google Apps Scripts."They're basically javascript attatched to a spreadsheet, whose most obvious use is creating custom functions in spreadsheets, and dealing with forms, but they can do so much more. You can use them to fetch information from all sorts of different places, and even in the free version, can be used for a host of other things. And it can do these things at frequencies ranging from once per minute to once per week (though you'll probably hit the unspecified usage limits pretty quick at once per minute).
Currently, I'm using them to auto-post the following to Google Calendar
Severe Weather Warnings, with durations.
Astronomy Forecasts from Accu-Weather.com.
Visibility times for flyovers of the International Space Station and Iridium Flares from my location.
Due dates for library books.
Estimated arrival dates for netflix DVDs.
Those are probably the most /useful/ things I'm doing with scripts attatched to spreadsheets. Things I'm doing because I got bored and had a spare hour to bash things together:
Tracking and graphing the temperature,humidity, air pressure, wind speed, and several other Weather variables on an hourly basis for the past two months.
Tracking and graphing the progression of the Sun, Moon, Mercury, Venus, Mars,Jupiter, Saturn, and Uranus on a daily basis across the celestial sphere for the past three months.
Recording the geographic location, magnitude, and depth of every earthquake that the USGS has detected since late May, and graphing those in several ways.
Recording and graphing the number of "Likes" in Google Reader that every story posted by Gizmodo has received in the past month.
Threw together a spreadsheet that accepts a city name and produces a graph of the change in Sunrise, Sunset and twilight times for each day of the year..
If there's information on the internet that you can write javascript to parse, a Google Apps Script can do all sorts of interesting things with it. Heck, the documentation includes enough information to use Google Apps scripting to write a Twitterbot.
Powered By WizardRSS.com | Full Text RSS Feed | Amazon Plugin | Settlement Statement | WordPress Tutorials
Currently, I'm using them to auto-post the following to Google Calendar
Severe Weather Warnings, with durations.
Astronomy Forecasts from Accu-Weather.com.
Visibility times for flyovers of the International Space Station and Iridium Flares from my location.
Due dates for library books.
Estimated arrival dates for netflix DVDs.
Those are probably the most /useful/ things I'm doing with scripts attatched to spreadsheets. Things I'm doing because I got bored and had a spare hour to bash things together:
Tracking and graphing the temperature,humidity, air pressure, wind speed, and several other Weather variables on an hourly basis for the past two months.
Tracking and graphing the progression of the Sun, Moon, Mercury, Venus, Mars,Jupiter, Saturn, and Uranus on a daily basis across the celestial sphere for the past three months.
Recording the geographic location, magnitude, and depth of every earthquake that the USGS has detected since late May, and graphing those in several ways.
Recording and graphing the number of "Likes" in Google Reader that every story posted by Gizmodo has received in the past month.
Threw together a spreadsheet that accepts a city name and produces a graph of the change in Sunrise, Sunset and twilight times for each day of the year..
If there's information on the internet that you can write javascript to parse, a Google Apps Script can do all sorts of interesting things with it. Heck, the documentation includes enough information to use Google Apps scripting to write a Twitterbot.
Powered By WizardRSS.com | Full Text RSS Feed | Amazon Plugin | Settlement Statement | WordPress Tutorials