Useless Blogging

This is for my family.  Without you guys (all of you) this wouldn’t have been possible.  I love you all.

Solved in Excel!

=SUMPRODUCT((MOD(ROW(A1:A999), 3)=0)*ROW(A1:A999))+SUMPRODUCT((MOD(ROW(A1:A999), 5)=0)*ROW(A1:A999))-SUMPRODUCT((MOD(ROW(A1:A999), 15)=0)*ROW(A1:A999))

(Project Euler)

I wasn’t raptured today, which is a good thing, because I had something else to do today.

Today marks eight years since I got a second light in my life.  Every moment has been more enlightening and joyous than the last, and I am grateful for the chance to call her my daughter.

Happy Birthday, Sara.  I love you.

I get walking out so that there’s no quorum, and no business can be conducted. I do. I think that sometimes, it’s a necessary evil so that actual discussion can take place on a bill that’s being seemingly rammed through; a consensus can be reached (or at least adequately explained) on an issue that deserves a few extra moments.

This type of stunt though, where you decide to stall other things so you can get your way on something unrelated: not cool.

Work it out.

A window into my life: what’s currently in the bathoom book container:
- Dave Barry’s Complete Guide to Guys by Dave Barry
- The College Solution by Lynn O’Shaughnessy
- Mummy: The Resurrection (White Wolf)
- When Will Jesus Bring The Pork Chops? By George Carlin
- The Higher Arithmetic (7th Ed.) by H. Davenport
- Dead Magic II: Secrets and Survivors (White Wolf)
- War of Ages (White Wolf)
- Teachings of Zen edited by Thomas Cleary
- Dilbert Gives You The Business by Scott Adams

Transparency like you never wanted.

I need to save this link somewhere, and somewhere public seemed appropriate.

http://io9.com/5656279/if-you-get-bored-with-nothing-to-do-you-are-not-a-writer-guillermo-del-toros-words-to-live-by

New foster at the house.

If you’re thinking “what should I get Sean for his birthday?”, I offer:

http://www.gamestop.com/Catalog/ProductDetails.aspx?product_id=77858

OK, so the formula that I last posted apparently required a little work. It became immediately obvious that the use of the formula for a named range failed if the matching column was to the right of column Z; ther CHAR() function will only return one character. I needed to make the formula a bit more complex in order to handle that.

=OFFSET(INDIRECT(“Source!$” & IF(MATCH(“MatchingColumn”,Source!$1:$1, 0)>26, CHAR(64+TRUNC(MATCH(“MatchingColumn”,Source!$1:$1, 0)/26)) & CHAR(64+MOD(MATCH(“MatchingColumn”,Source!$1:$1, 0), 26)), CHAR(64+MATCH(“MatchingColumn”,Source!$1:$1, 0))) & “$2″), 0, 0, COUNTA(Source!$A:$A)-1,1)

Go to town!

The MAN!