Putting Your Keyboard in the Dishwasher

And other tricks for getting grime off your computer equipment.

DishwasherI just listened to an NPR Podcast called “Are Computer Keyboards Dishwasher Safe?” In it, the reporter tells of her research and hands on experience with cleaning a dirty computer keyboard in the dishwasher. She found that although keyboard manufacturers warned against cleaning a keyboard with water, she and another computer user gave it a try. After letting hers air dry for a full week, she found that it worked fine.

And of course, it was very clean.

Now I’m not suggesting that you unplug your keyboard and throw it in the dishwasher with tonight’s dinner dishes. And I won’t be held responsible for damages if you do decide to give it a try. But her results support something a fellow instructor used to say when we taught Macintosh troubleshooting classes together years ago: computer keyboards are dishwasher safe.

Me, I’m a coward. Instead of having to clean a keyboard after months or years of use, I simply buy a keyboard “skin” that fits perfectly over it. The plastic membrane is so flexible that I have no trouble typing right through it. And, after about a week to get used to the feel, I don’t even notice it anymore. As a result, all of my keyboards are as clean as they were the day I bought them — under that plastic membrane, of course.

Of course, having the keyboard skin over my keyboards has made me a bit sloppy at lunchtime. Spills and crumbs simply don’t bother me because I know they won’t harm the keyboard.

I do recall the old days, when I used to clean my keyboards by hand. Pop off the keys and soak them in a bowl of Fantastik spray cleaner. Rinse well and dry. Then put the keys back on — where they belonged. A huge amount of work. I guess you can see why I switched to the skins.

On a related note, the battery in my wireless Mighty Mouse died today. I decided to take the opportunity to clean the rodent — by submerging it in a drinking glass of 90% isopropyl alcohol. I got the idea from MacOSXHints and I referenced it in an article I wrote here about my initial Mighty Mouse impressions.

The dirt practically slid off the mouse as I repeatedly dipped it in the alcohol. (My nail polish almost did, too.) A little rubbing on the obviously dirty areas finished it off. It was tough to resist the temptation to rinse it off when I was done, but I set it out on a piece of paper towel to dry. Trouble is, it didn’t dry as quickly as I expected. Now I’m wondering if it’s still wet in the places I can’t see. I’m going to let it dry overnight.

Of course, with half a bottle of alcohol in a drinking glass, I couldn’t resist giving my wireless Microsoft mouse the same treatment. (Didn’t want to throw all that alcohol away without using it to the max.) And I’m afraid to plug that one in now, too.

Use the Comments link or form to share your experiences.

Footnote: After drying my Mighty Mouse for about 6 hours (in the Arizona desert, mind you), I put in some fresh batteries and turned it on. It works fine!

Excel Splitting Digits Example

Another quick spreadsheet to show off the capabilities of Excel.

Site visitor Jamie left the following comment on my recent post, “Random Number Generator for Excel“:

maria dont spose u know how to split a four digit number like 2365 into 4 different numbers 2 3 6 5 in all different cells in excel without having to do it manually just wandering please tell me if you know a way thanks

I had an idea of how to do this with the MID function, which is a text function. I just didn’t know if I had to convert the starting number to text before extracting the digits.

So I whipped up the attached worksheet and popped in the formulas. The answer: no, you don’t need to convert the number to text first.

Split Digits worksheet

The MID function has 3 arguments:

  • text is the text you want to extract characters from. For this example, it’s the four-digit number.
  • start_num is the number of the first character in the string you want to extract. For this example, it’s the digit number (1 though 4).
  • num_chars is the number of characters you want to extract. For this example, it’s 1.

You can examine the formulas in the spreadsheet for yourself to learn more. Download it here.

Hope this helps, Jamie!

StumbleUpon

Yet another way to waste time on the Internet.

StumbleUponThe other day, I [finally] discovered StumbleUpon. This is yet another bookmarking service for people who spend a lot of time surfing the ‘Net. The gimmick for this one: you “Stumble” pages you like to add them to a database of pages. People can then randomly stumble upon the page by clicking a button in a StumbleUpon toolbar they install in their browser

Well, that’s the way I’ve been using it, anyway. For all I know, all the other bookmarking sites and services have the same functionality.

My Limited Experience with StumbleUpon

I installed the StumbleUpon toolbar the other day and spent an hour of my life stumbling upon seemingly random pages on the Internet that matched interests I indicated when signing up. I found a few very good pages, a few very bad pages, and a bunch of pages in between.

The magic was clicking that Stumble! button in the toolbar and not knowing what would appear next. Something I like? Stick around and check it out. Something I don’t like? Click Stumble! again. You could easily spend an entire day doing this, finding all kinds of cool yet unpopular Web pages buried in the depths of the Internet.

When you see a page you like, you can give it a thumbs up. A thumbs down goes to pages you don’t like. Easy.

StumbleUpon and the Blogosphere

StumbleUpon has been embraced by a number of bloggers. You can tell by the “Stumble It!” link that appears at the top or bottom of a post. I just added that this evening to this blog. It’s pretty simple to do in WordPress: just insert the following code where you want the link to appear:

<a href="http://www.stumbleupon.com/submit?url=<?php the_permalink(); ?>&title=<?php the_title(); ?>">Stumble it!</a>

There’s an icon that can appear with it, but since that didn’t go with the formatting of my post, I omitted it. I may add it sometime in the future, when I get around to adding icons for Digg, Technorati, and Delicious.

Do You Use StumbleUpon?

If so, don’t keep your experiences to youreself! Use the Comments link or form to share them with the rest of us. I’m especially interested in learning more about the benefits of this service. How does it stack up against the others? Inquiring minds want to know.