Posts Tagged ‘ Google Spreadsheet ’

Example 9.18: Constructing the fastest relay team via enumeration

January 5, 2012
By
Example 9.18: Constructing the fastest relay team via enumeration

In competitive swimming, the medley relay is a team event in which four different swimmers each swim one of the four strokes: freestyle, breaststroke, backstroke, and butterfly. In general, every swimmer might be able swim any given stroke. How can w...

Read more »

Google Spreadsheets API: Listing Individual Spreadsheet Sheets in R

September 7, 2011
By
Google Spreadsheets API: Listing Individual Spreadsheet Sheets in R

In Using Google Spreadsheets as a Database Source for R, I described a simple Google function for pulling data into R from a Google Visualization/Chart tools API query language query applied to a Google spreadsheet, given the spreadsheet key and worksheet ID. But how do you get a list of sheets in spreadsheet, without opening

Read more »

Nutritional supplements efficacy score – Graphing plots of current studies results (using R)

February 25, 2010
By
Nutritional supplements efficacy score – Graphing plots of current studies results (using R)

In this post I showcase a nice bar-plot and a balloon-plot listing recommended Nutritional supplements , according to how much evidence exists for thier benefits, scroll down to see it(and click here for the data behind it) * * * * The gorgeous blog “Information Is Beautiful” recently publish an eye candy post showing a “balloon race” image...

Read more »

Solar Trends: Sunspot Numbers Since 1749

September 17, 2009
By
Solar Trends: Sunspot Numbers Since 1749

This is the 1st in a series of  posts I will be doing on solar trends. In this post, I show how to retrieve online monthly sunspot data back to 1749, calculate average annual sunspot numbers (SSN),  plot the monthly and annual average SSN as well as a lowess smooth, add the Solar

Read more »

Global Mean Sea Level Trends

September 6, 2009
By
Global Mean Sea Level Trends

In this post, I show an R script that downloads the University  of Colorado, Boulder’s 1993-2009 global mean sea level (msl) change (link) data, converts the ASCII file into a usable R data frame, calculates moving average and msl change  trend rate and develops a trend  chart that shows msl change  and trend rates

Read more »

Global Sea Surface Temperature Trends (1850-2009)

September 4, 2009
By
Global Sea Surface Temperature Trends (1850-2009)

In this post, I show an R script that downloads the Hadley Centre’s 1850-2009 monthly sea surface temperature (HadSST2) anomaly data, converts the ASCII file into 2 usable R data frames, calculates overall and post 1980 SST anomaly trend rates and develops a 2 panel chart that shows SST anomalies and trend rates and the

Read more »

CO2 Emission Trends

August 23, 2009
By
CO2 Emission Trends

“Since 1751 approximately 329 billion tons of carbon have been released to the atmosphere from the consumption of fossil fuels and cement production. Half of these emissions have occurred since the mid 1970s. The 2006 global fossil-fuel carbon emission estimate, 8230 million metric tons of carbon, represents an all-time high and a 3.2% increase

Read more »