Jan
10
Getting my priorities straight
Filed under: ,

I am down to the last two weeks before I can move in to my new place. When I first move in, I will have minimal furniture. By that I mean really minimal. In fact I can count all bits of furniture on one hand....one ugly hand. I have some IKEA Billy shelves, and IKEA Ivar shelves that are actually my current computer desk, and an IKEA mattress I lie on the floor when visitors come. That's it!!! Which means I have a hell of a lot of stuff I need to buy.

To help me figure out what gets the priority, I have been using some of the cool features of Excel 2007. Actually, the features could have been there before, but I just noticed them now. First, I listed the item, a rough cost, a location and a priority. I set Conditional Formatting for the Priority to show ratings. Then I set Conditional Formatting for Cost to show Green to Red for value of the item. Then I sorted by Priority then Cost. As you can see, the XBox and LCD TV come way before a real bed. Over on the right, I have sums of items based on priority. Using the function SUMIF, I can sum up all priority 4 items easily: =SUMIF(C2:C26,"=4",B2:B26). I thought that was pretty cool.

Prices on most things are fairly low because at first lots of things are expected to come from Ikea. Some of that is because I want to get the basics, and then there are some things that IKEA does better than anyone else. An example is a good desk. My last desk was an Ikea Effectiv. The thing cost me 900 USD and was rock solid. It held 2 19" Viewsonic CRTs, plus me standing on them and they wouldn't budge. I sold it for 500 just before I left San Francisco so it retained value well too.

image

Posted at 1:26 AM on Thursday, January 10, 2008
Comments: 0 | Views: 25,283


Email This | Technorati Search | Digg This | Share on Facebook
The Technovangelist is the site of Matt Williams, the International Trainer for Captaris, based in Amsterdam in the Netherlands. He uses this site to get the word out about what he is up to, where he is traveling to, what gadgets he is buying, and more. For more, check out the About page.