Posts

Use Excel to solve Soduko puzzles

Image
I found a clever Excel template on the Microsoft site . With this template, it can help you solve Soduko puzzles. You enter the numbers you have, and have it calculate possible answers for the remaining open spots. If it cannot completely solve it, try 1 of the possible numbers and recalculate. Eventually, you will solve the puzzle. Microsoft has other game templates as well.

Music just gets better and better on the Internet

I have talked about some of my favorite music services in the past, including Pandora and of course the iTunes/iPod combination. I have also used YouTube , Live365 , and other streaming services. Now I have a new favorite, last.fm . With last.fm, I enter my favorite artist, band, or song, and it streams music related to that category. At the surface it sounds just like Pandora, but I believe the music matching algorithm is better, as well as last.fm offers many more features. For example, the module above will play my music recommendations, or you can play it on the last.fm site . These are the songs that match what I have selected. I can also play my recommended songs through a downloadable client . last.fm uses scrobbing to assist in recommending music. Scrobbling a song means that when you listen to it, the name of the song is sent to Last.fm and added to your music profile. Once you've signed up and downloaded Last.fm , you can scrobble songs you

Cool Firefox Trick

Image
I ran across a cool trick with Firefox, which allows you to open Firefox within Firefox. There's no real purpose behind it, it's just a fun thing to do. Just enter this into the URL line of Firefox: chrome://browser/content/browser.xul

How much do you pay for phone service?

Image
Where I live, basic service is about $25 a month; long distance is extra. That's a guaranteed minimum $300 a year if I don't make any long distance calls. I decided to do something about that -- I got setup with Skype . If you're in the US or Canada, all long-distance is free after a one-time $30 fee ( SkypeOut: Skype Unlimited ). In addition, to get an incoming number ( SkypeIn ), I only paid $38 for a year of service, which includes voice mail . You can get your incoming number to have any area code -- so if you have friends or family that have to pay long distance charges to call you, you can get a phone number in their area code. My final expense was an inexpensive Skype phone , $35. So for $103, I have local and long distance for a year. In addition, with just the basic free Skype service, you can talk Skype-to-Skype for no cost. Many Podcasters, such as Leo Laporte , use this service to record guests on their shows; which is cheaper and yields better quality than if

Determining Quarter from a date in Excel

Image
Excel is a great program to manipulate your data, perform what-ifs, and graphically display results. But it's not straight forward when you want to know the which Quarter certain activity took place. Fortunately, with a simple formula you can determine the Quarter. =ROUNDUP(MONTH(A1)/3,0) Roundup can be a useful function in other applications as well. The last parameter (0 in this example) is used to change the rounding level. A positive number will add decimal places, while a negative number will round left of the decimal (i.e. -1 rounds to 10s and -2 rounds to 100s).

Find and Replace special characters in Word

Image
I recently had a list of items that I wanted to grab from a web page drop-down list. Of course you can't copy a drop-down list, but... you can view the source and get the list. The problem though is, "how do you remove the option tags and the value?" As you may have guessed by the title, you can do it with Word. Here's a sample taken from News.com : Copy the list and paste it into Word. Open the Find and Replace dialog (Edit | Replace... or Ctrl + H). Click the More button and check Use wildcards . Here's the trick, as you need to use special characters. First, paste the string you want to remove in the Find what: field. For each greater than and less than character, place a backslash before it, i.e. < becomes \< . Replace the contents of the value field with an asterisk. Validate Word will be able to find the code by clicking the Find Next button -- the code should now be highlighted. Go to the Replace with: field and enter ^p . This will replace your

Active window loses focus

Image
Do you ever have the experience where your typing away, say in Word, and another program pops-up and takes focus, forcing you to click back on the program you were working in? This happens the most to me when a new IM conversation begins in Trillian . It's not a problem once the conversation is going, just for new ones. Where there are a couple of work-arounds to prevent this from happening. Perhaps the easiest is to get Microsoft's Tweak UI to disable it. Look for Focus in the General section of Tweak UI. You can also do this through a registry setting: Start the Registry Editor: Go to Start | Run and enter regedit [Enter] Find HKEY_CURRENT_USER | Control Panel | Desktop Go to the Edit menu and select New > DWORD value Name the DWORD value "ForegroundLockTimeout" Assign a value of 30d40 Close the Registry Editor While your in the Registry Editor, you can also set how many times the Window seeking your attention flashes in your taskbar. This is another setting