onEnterFrame's blog

Excel Formula

A coworker had a pretty complex spread sheet with several sheets in it.
One sheet had monthly and yearly totals going back to 2003.
She wanted a chart on a new sheet that compared this year's data with previous years.
But only up to the current months data... so August 2009 compared to Aug. 08, Aug. 07, etc
Here is what I came up with:
=INDIRECT(ADDRESS(104,MONTH(TODAY()),4,1,"damages per 1000"))
I am far from an excel expert so I'm proud of it.
Luckily the sheet with the monthly totals is arranged so that month 1 is in col 2 etc.

My Current G1 settings

Full-screen Articulate

Full-screen Articulate via new menu item Demo & Files:

Hello World

Creating content to get that silly "Welcome to your new Drupal website!" off my home page.