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)

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)

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.

Vancouver, Canada

Incredible Idea

Such an incredible idea. Wishing I would have thought of it.

http://www.engadget.com/entry/1234000430055701/

Cool Discovery Photos

An online picture journal of the Space Shuttle Discovery Mission. Amazing what a group of engineers can accomplish.

More Adobe Premiere Problems

I made sure that when I finished my "wedding video" project in late June, I left the files in a perfectly archived state so that I could come back to it at anytime. Unfortunately, Adobe Premiere had yet another unfortunate surprise in mind for me.

I loaded the .prproj file tonight to give my friend Scott a short tutorial on Adobe Premiere. I was showing him the ins and outs of cross fades and video transitions when I noticed that one of the primary video source files was missing! Ack, what happened? I had not changed this project (or any of its dependencies) since archiving it months ago. What's the problem?

Ironically (long story) I received the lovely "red screen of death" faced me which said "media missing!." I double checked to make sure the video file was in the same place in my file system. I then tried linking, then unlinking the media through Premiere's pop-up menu. Nothing worked. Finally, I found a link on Adobe Premiere's "Support Knowledge" base which said to,

Rename the .AVI file to use the .MPG extension (for example, rename movie.avi to movie.mpg), and then import it into Adobe Premiere or Adobe Premiere Pro.

I did this and sure enough, the problem was resolved. Now what I don't understand is what caused this error? Why now? I hadn't done a thing between the last time I had used this .prprof file. Ah, yet another sad revelation of how bad Adobe Premiere really is.

Sky Diving Accident

My clever girlfriend went skydiving for the first time in Australia a few weeks ago. Then I found this story on CNN about a woman who died on her first tandem skydive jump.

Intel IRCON 2005 in Portland, OR

Some pictures from Intel's IRCON 2005 in Portland, OR.

Intel's Placelab in the news...

Microsoft's Virtual Earth project has recently debuted. It provides real-time location services by either (1) looking at your ip address and making an estimate on your position based on your dns entry or (2) by using Wi-Fi technology. This second method is said to be more accurate and is based on research by Intel Research Labs, Seattle pioneered through the PlaceLab project. Of course, one of the main tenents of PlaceLab is to try and preserve privacy by conducting the localization algorithms "on-device" rather than "on-server" so that no information is exchanged with an outside source that might compromise privacy. Privacy is certainly a critical issue in many domains of CS right now, from e-mail to peer2peer apps, but it's arguably more important when dealing with location as it opens the possibility of endangering someone's physical health.

Two recent articles about PlaceLab. They both specifically mention my research :)
1. The Future of Mobile Computing
2. Intel experiments with Wi-Fi as GPS substitute.

You take your car to work

I'll take my board.

All along the undertows, strengthening its hold.
I never thought it would come to this, now I can never go home.

Best part is when they break it down boys choir style 2 minutes in and then proceed to rock out.

Ack, I need to stop listening to the same music I listened to in high school.

My name is Steve Vaught and I walk

Very cool, inspirational story from a fat man born Stephen James Liller in Youngston, Ohio.

http://www.thefatmanwalking.com/

K's Choice, More than an Addict

K's Choice is popularly known for their song "Not an Addict" about the dark, unrelenting temptations of heroin. Launchcast served me up another song by them called "Believe" and before I could hit the next button, I was hooked. K's Choice, not just a one hit wonder. Who knew?

They are now an official member of my "purchased music" playlist in iTunes.

Hot or Not Google Maps Integration

Ahem.

http://apps.hotornot.com/jeff/

Can't wait until they add this to:

http://www.meowmix.com/playtime/hotnot.asp

Eclipse Ruins Then Saves

I love Eclipse. I even use Eclipse when I don't really need to. Right now, Eclipse is my glorified CVS client -- I'm using VS2005 b2 for my C# IDE.

Imagine, if you will, the following frightening developer horror story:

I open Eclipse. I select some dirs to check-in. I try to commit them but I get an error. I look into a folder and think perhaps the cause is an object folder that has been bothersome (and should never be in CVS anyway). I think I select such a folder but really I select a folder containing new source code. I press delete and reflexively hit the enter button on the delete confirmation dialog.
I notice my error and panic, but only slightly. I search on Google for recovery software. I download two such tools PC Inspector File Recovery, which seemed OK but didn't find my newly deleted C# code and Restoration, which really blew and didn't find my source code files either.

Ack, now I'm getting more panicky.

I remember that Eclipse saves a local history of files. I wonder to self if Eclipse could be written such that, upon file/folder deletion through its interface, it would do one last local history backup. To calm my expectations, I figure that, nah that's probably not possible particularly when I only open the Eclipse IDE momentarily to checkin my files and not as a development environment.

I was wrong.

Eclipse saves the day. I open the local history browser and wahlah, my files! Again, stay calm. I make sure that these files are, in fact, the newly modified files and not some old, worthless version... ah, I see a new method, I see two new methods, I see all my new methods.*

Relief!

*I am a big geek.

XML Newbie

I am a relative newbie when it comes to XML. For work, I created an XML file and a corresponding parser in C#. For whatever reason the text "Cajun & Creole" kept throwing an XmlArgumentException. I thought perhaps it had something to do with the ampersand and... I was right. To include the "&" character in XML text, you must use "&"

This link from XML.com explains it all.

Prescription for a Queasy Stomach

A friend of a friend told me about the King County online restaurant inspection reporting system and how it, for a while anyway, completely affected the restaurants she would patronize.

Here is a listing of health inspection reports for restaurants on University Ave. in the University District at UW (note that the listing spans multiple pages). Be forewarned, however, that such listing could impact your desire to eat on the Ave. ever again. Below, I will review some of my favorite restaurants on the Ave. and their records of inspection.

But first, a briefing on the way these inspection reports supposedly work.

Inspections Overview
Inspections are based on regulations to eliminate risk factors for food borne disease. Every violation of these regulations is color coded and has a numerical value based on the amount of risk they create.

The red violations are the highest risk and pertain to things that cause food borne diseas, and the blue violations relate to maintenance and cleanliness of the restaurant. Most importantly, there is a scoring system (note that the lower the score the better).

• 35 or more red critical violation points require a re-inspection within 14 days.
• 75 or more red critical violation points require the establishment be closed.
• 101 or more total (red & blue) points also requires the establishment be closed.

Those restaurants that are forced closed are allowed to reopen when they "have remedied the conditions that have led to closure" -- Whew, that's a relief!

Interesting Finds
What I've noticed from my brief investigations is that American food places tend to do very well (e.g. Schultzy's, Big Time Brewery, even Jack in the Box), each maintaing a near perfect health inspection report (no score over 10). Schultzy's is one of my favorite places on the Ave. so I am fairly relieved there and many of my fellow Grad students hang out/eat at Big Time Brewery. Cheers to them as well.

The most common citation among all restaurants was "Food worker cards not available or current," which presumably means that (a) the restaurant is not keeping good records of their employees or (b) restaurants are hiring illegal immigrants. Admittedly (b) would be more likely in California.

Disgusting Finds (e.g. Point Winners)

• Honeybee's Cafe back in February '04 was cited with "Ineffective measures to control pests," a 13 point penalty (apparently). I'm not sure what this means exactly, but it cannot be good. It sort of has this implication that there is a pest problem to control.
• Ichiro Teriyaki scored a resounding 49 points on their last routine inspection. Cited for, among other things, improper refrigeration of food, poor handwashing facilities, unclean food contact surfaces, and, our favorite, ineffective measures to control pests.
• Never one to be out done, Aladdin Gyro-cery & Deli one-upped Ichiro Teriyaki by 7 points, scoring 56 points in 02/11/2004 for inadequate toilet facilities, unsanitary wiping clothes, improper refrigeration, inaccurate thermometers in refrigerators (the latter point here perhaps the cause of the former?). Of course, Aladdin really didn't learn much from that inspection given that one year later (02/10/2005), the restaurant scored 46 points. I hate to say it, but anyone who has eaten at Aladdin's (I have multiple times) probably isn't surprised by such a record. I'm not being perfidious, just honest.
• China Express has scored above 37 three times (see Worst Restaurants Section)
• Batavia just opened on the Ave and already received a 48 (see Worst Restaurants Section).
• Tokyo Garden. One of the few places mentioned in this blog post that I have never eaten at and perhaps for good reason. Tokyo Garden received a score of 58 points on 02/18/2005 for not storing utensils properly, poor handwashing facilities, food storage.

Favorite Restaurants and how They Fared
My all time favorite restaurant on the Ave is actually on Brooklyn Ave. Cedars offers a fantastic selection of Indian and Mediterranean food -- a seemingly strange mix, but works quite well. I really like Indian food and this is the place to do it in the U. District. The only bad part about Cedars is the table wait on weekend evenings... and their apparent "presence of pests" which are "not controlled." Cedars consistently scores in the 10-20 range in their health inspection report, most recently because of said pest issue and because of separation of living quarters/employee area, inaccurate refrigerator thermometers, etc.

My two favorite Mexican places on the Ave are, Pepes and Chipotle (yes, I know it's owned by McDonalds, shhhhh I like to eat corporate food sometimes, ok?), both of which have flawless health inspection reports never scoring even one point.

Thai food on the Ave. is fairly popular only second in prominence to Teriyaki places. I like, in order of preference: Thai 65 (just opened in early 2005), Thai Tom, Thai Spice, Thaiger Room. Overall, I am not a huge fan of Thai food (it tends to be too sweet and I don't like peanut sauce) but it's hard to avoid on the Ave.

IMO, Worst Restaurants on the Ave. (and how they fared)
The worst restaurant on the Ave is a relatively new addition to the U. District and goes by the name Batavia, which tries to pass as an authentic Indonesian restaurant. Now, I've never been to Indonesia but I hope for their sake that Batavia's version of authentic is a bit skewed. The portions are incredibly small but the food is so bad, that's actually a blessing. I went there one time and that was more than enough. Batavia received a score of a 48, which is, imo, 27 points too small. It would seem that there is some people who disagree with me on Citysearch. My guess would be, however, that those reviews were written by the owners themselves (or their kin).

The second worst restaurant on the Ave goes to Hawaii BBQ Restaurant, which managed to give myself and two others digestion problems for an entire afternoon. I went to Hawaii BBQ for the benefit of a friend who wanted to try it out and when I saw the pictures of their food on the menu posted by the door, I had difficulty staying. But I did and soon regreted it. I'm not sure what Hawaii BBQ is supposed to mean but they appeared to only have three or four authentic Hawaiin dishes -- the rest was your standard Teriyaki offering found at a dime a dozen on the Ave. But I digress, they scored a 39 at their worst inspection and an 18 (most recent) at their best.

The third worst restaurant on the Ave goes to China First, which offers a $3.50 lunch making it almost worth it suffering through their cuisine. The food here is standard Americanized Chinese food, not necessarily bad but just not good. China First has quite the health inspection report though receiving 50, 43, 38 respectively for such things as: food stored on floor, floors not properly cleaned (maybe because there was food in the way?), room temperature storage dangerous (at highest bacteria breeding temperature)

Conclusion
I feel a slight sense of guilt actually typing up these health inspection reports and publishing them on my blog. I realize that many of the restaurants on the Ave are owned and operated by families and that they are doing the best they can. It is a difficult environment, lot's of competition and little pricing flexibility. An overwhelming portion of patrons are students and, therefore, there is only so many foods and preparations that can be offered at the $6-10 range.

Fremont Outdoor Movies

I went to the "Scene It Fremont Outdoor Movies" night in Fremont tonight and saw, for the first time and perhaps only time, a Monty Python movie: Monty Python and the Holy Grail*. Sadly, I am not blessed with a British sense of humor and, for the most part, found the movie utterly boring and sinfully edited. Mostly, it felt like a high school improv class video gone bad (with slightly higher budget, say, $5,000 rather than a nickel). Sole funny parts: flesh wound scene, monsterous rabit, John Cleese. Everything else, I could have more than lived without. I do not think this opinion to be unique. One person I was with fell asleep and I heard plenty of "when does this thing end" chatter behind me.

My apologies to the geeks I've offended everywhere. This is yet more mounting evidence that I do not have what it takes to be a true computer scientist (dare I admit to not liking Star Trek or seeing any of those movies).

I will say, though, that I thoroughly enjoy the idea of outdoor movies. I wish that it were in a park in Fremont (perhaps a grassy knoll) rather than a parking lot. But I suppose we can't have everything -- especially when the price of admission is a suggested donation (ala The Art Institute of Chicago Museum)

* I cannot believe that Monty Python and the Holy Grail received 8.4/10 votes, beating out Braveheart, The Deer Hunter, Sixth Sense, The Graduate, Saving Private Ryan, Hotel Rwanda, The Sting, and even the Wizard of Oz (to name a few). That is blashemy and a testament of the influence that geeks have on imdb.com.

Update: Australian Calling Rates

Last week, I blogged about the large pricing disparity in calling Australian land lines versus Australian cell phones with American calling cards. I also mentioned using SkypeOut as another possible cheap way to call my g/f overseas.

Well, I tried SkypeOut as well as another calling card company called Pincity, which came highly recommended to me from a friend who uses it to call Asia.

Although SkypeOut offers the cheapest calling rates of any other technology I looked into (other than computer-to-computer of course), my experience with SkypeOut was absolutely horrible. SkypeOut from Seattle, WA to an Australian cell phone costs 2 cents a minute but it is hardly worth it (rates). The audio quality was bad but the delay (over 5 seconds) was worse -- paired together, SkypeOut to Australia was unusuable. *Given that SkypeOut is essentially Voice over IP, I imagine that they will improve.

My Sprint International Calling Card that I got from Sam's club was out of minutes, so rather than recharging it I decided to try Pincity. Pincity offers incredible global calling rates to nearly everywhere in the world (rates). Calling an Australian land line costs an incredibly low $0.05 a minute; however, calling an Australian cell phone is nearly 5 times as much ($0.23 a minute). Nonetheless, I opted to try out Pincity and purchased a 10 dollar card online. Unfortunately, not only is the Australian mobile phone rate twice as high as Sprint's, the sound quality was diminished by that digitized feedback and a 2 second delay.

As soon as my Pincity account runs out (I have roughly 35 minutes left), I'm back to Sprint.

* If you're curious, SkypeOut is able to provide insanely low call rates because it uses the internet to carry most of the call to its destination and then there is only a local charge to make the call to a regular phone (link).

Independence Day @ Gasworks

A few photos from my meager SMT5600 phone camera (I biked and didn't want the extra pocket load of my S200 -- particularly since it has been so unreliable lately, see this post).