I have a spreadsheet of metrics I track every week. I add a new column to the left every week for that week's data, so that I don't have to scroll forever to the right to see recent information. (Yes, it would be easier to add rows, but that's another story.) All was well until I wanted to add sparklines; since the newer data was on the left, it looked like the sparklines were trending down, when actually the data was just backwards. I needed to find a way to reverse an array in Google Spreadsheets.
This blog post was originally posted to my blog at Mediacurrent. It appeared on Drupal Planet.
This summer I was a mentor for the Google Summer of Code program for Drupal. I maintain the Facebook-style Statuses module, which allows users to have a stream of “status updates” on their user profiles and to write messages on other users’ profiles, like Facebook. So when I had the chance to mentor the Facebook-style Micropublisher proposal, which built on Facebook-style Statuses to allow attaching images, links, and video to status updates, I jumped on it.
The result was a resounding success, and I learned a lot during the process. Nitin Gupta, the student driving the project (and better known to some as publicmind) was an extraordinary developer in the true Drupal spirit. He gracefully put up with my pickiness about coding style, thoroughly researched the best code architecture for our purposes, and even identified places where Facebook-style Statuses itself could become more flexible. I truly believe that Nitin will remain committed to the module he created, and that both of us are better Drupal developers as a result of this process.
As the maintainer of the Facebook-style Statuses module for the Drupal content management system, I like to read around the web and see what kinds of statistics and innovations I can find on comparable systems. This week, there was a gold mine that indicates that the "status movement" is going to grow its already expansive online presence exponentially.
I normally avoid talking about web design, because when I do, most people have no idea what I'm talking about. But today, Google rolled out a new version of their already-awesome Google Analytics tracking system, and it is simply beautiful.