Tuesday, September 20, 2005

Absolute, Relative, Mixed Formulas in Excel

Here is a quick review of absolute, relative, and mixed formulas. Normally if you enter a formula like =SUM(A2:A4403) in D1 and then copy the formula to E2, your formula in E2 will change to =SUM(B3:C4403). This is a cool feature of worksheets called "relative addressing", but sometimes we do not want that to happen. In this case, we want every formula to refer to the range A2:B4403. As we copy the formula from cell to cell, it should always point to A2:B4403. While entering the formula, hit F4 once after entering the range, and your formula will change to =SUM($A$2:$A$4403). The dollar sign indicates that that portion of the reference will not change as you copy the formula. This is called absolute addressing. It is possible to lock only the column with the $ and allow the row to be relative. This is called a mixed reference and would be entered as =$A4406. To lock the row but allow the column to be relative, use =B$4405. As you enter a formula, use F4 to toggle among the four flavors of relative, absolute and mixed references.

(from link)

Friday, September 16, 2005

Mayer forms John Mayer Trio

Signed into the iTunes Music Store tonight and saw that John Mayer has a new band called the John Mayer Trio. Since I'm essentially TVless, I did not see him perform at the Grammys where, I guess, the John Mayer Trio sort of debuted their stuff with a new take on Mayer's grammy award winning number, Daughters.

The John Mayer Trio represents a different, harder-edged sound for the singer, songwriter and guitarist. Those fortunate enough to have tickets to the sold-out Fillmore gigs will witness a different side to the pop tunesmith known for slick hits such as ``Your Body Is a Wonderland.''
``I wouldn't just change just for the sake of changing, but I've always had another agenda,'' Mayer explains. ``That other agenda is a whole different set of heroes and hues and colors and textures. I've just decided to go to my next place. . . .
``It's a very thought-out process of taking what excites me about Eric Clapton and B.B. King and Buddy Guy and Blind Faith and Derek & the Dominos and the Band and Cream . . . and placing it in my thing. I love pop music. I love guitar playing. I love blues. I love jazz. And I love the idea even more that I could put my own stamp on all those things and roll them into one sound.''


``He's really serious about his guitar playing,'' Palladino says from his home in London. ``Some guitarists have a special touch, and you know the guys I'm talking about, and John is one of those guys. It's the way he strikes a note. He just has something.''
The same could be said for both Jordan and Palladino, two stellar players who have performed with rock legends.

(from link)

Monday, September 12, 2005

Well, at least we have sports...

Headline story on espn.com this morning:

Moment of Relief
Two weeks of suffering. A city, and region, in mourning. The mayor's pregame plea. Did New Orleans really need the Saints' 23-20 win Sunday? Len Pasquarelli says yes.

I have to remind myself why I check this page everyday? It certainly can't be for the insightful and worldly perspective.