At least once a month I use an INDEX/MATCH formula to match and merge patient data from multiple Excel files. I wrote this post because when I first sought to learn the technique I found the other tutorials on the web either lacking or hard-to-follow.

[Read more →]

I’m not a professional movie critic. But if I were, both my thumbs—and my toes—would be pointing down when I reviewed The Happening, the latest thriller from filmmaker M. Night Shyamalan. There are two main reasons why.

[Read more →]

I recently finished reading Blonde Faith by Walter Mosley, the 11th and final novel in the acclaimed Easy Rawlins mystery series (the one that President Clinton made famous when he declared it his all-time favorite). Like the 10 installments before it, it was excellent. Instead of reviewing this particular book, I want to commemorate the end of the series by sharing a few personal thoughts on the collection as a whole. I’ll try to avoid spoilers.

[Read more →]

In between watching trailers for I Am Legend and raking leaves, I’ve been using Crystal Reports XI a lot lately. I mean really using it—OLAP cubes, Custom Functions, posting questions on the Business Objects message board—the whole nine yards. Somebody at work heard that I was pretty good with it and the next thing I know I have 40 complex reports to develop.

[Read more →]