Sunday, June 9, 2013

Medicare Cost Data and the Pixel

Extensive cost data for medical procedures has recently been released. I thought it might be interesting to explore it, and out of curiosity try to do so on the Pixel. Unfortunately, this highlights why ChromeOS still needs some work.

The spreadsheet cannot be uploaded to a Google Sheet, because it has more than 400 thousand cells. Oops. A second option was fusion tables, but fusion tables is unable to geocode addresses split into multiple columns. In fact, Google's recommended solution is to download and modify the file on something other than a Chromebook using Excel.

I was expecting problems with programming given the lack of editors, IDEs and build tools, but not basic spreadsheet tasks!