New Speed Results

My new results since my service reconnect.

Speed Test

I just tested my new DSL speeds and I am now getting 3Mbps on downloads.

Unlimited local and long distance + 3Mbps download for just $50/month. That's $5 less than my last package with twice the speed.

I love better stuff for less. Go Technology!

Sling This

There is a cool little invention (and no, it was not invented by Microsoft) that we use at work for remote access to set-top boxes called Slingbox. We have dozens of them all over the place. But when I have mentioned it to others, they look at me like I'm from Mars. I have even seen them for sale on some of the deal-a-day web sites. I do not know why it has not taken off quicker. Perhaps people just don't need what it has to offer. Whatever the case, it is fun technology. Check it out for yourself.

SlingMedia

Online Christmas

I bought almost all of my kid's Christmas gifts online this year. No traffic, no lines, no fights, no hassles, great prices. I bought almost everything on amazon.com. It all arrived well before the 25th and shipping mostly free. I even bought my own gifts online but from woot and newegg. I started to buy my wife's gift online but was quickly 'corrected' by my in-laws as to the appropriate type of gift to get and where to get it. This was the first year where I bought most of the kid's gifts. The wish lists and saved carts are nice tools to use for comparison shopping and you never have to get dressed or leave your house. I look forward to doing it again next year. The Holidays aren't so bad after all.

Shell Shocker

I noticed several online retailers jumping on the one deal per day bandwagon. NewEgg now has the ShellShocker but I have not found a unique URL that links to it. I believe you have to be a member to get the ShellShocker deals. They are usually really good buys. I picked up a new HP personal laser printer for just $50. Not too bad. I tend to end up buying more from NewEgg than anywhere else. My personal favorite.

Yug

I discovered Yugster the other day. It is similar to Woot only a little different. It usually has a today deal, a tomorrow deal, and a Yours Until Gone deal. It also has YugOvers and YugBacks. Check it out if you like daily deal sites.

Sellout.Woot

Woot has another site. Sellout.woot. Appearently it is part of Yahoo! Sometimes they coordinate what they are selling with complimentary widgets on the two sites.

Change Case

Have you ever needed to change the case of text in selected cells within an Excel spreadsheet? After searching the Internet, I found something close then modified it to meet my needs. Others may need to do the same so here is the macro that I ended up with.

---

Sub Change_Case()

Dim ocell As Range
Dim Ans As String
Ans = Application.InputBox("Type in Letter" & vbCr & _
"(L)owercase, (U)ppercase, (S)entence, (T)itles ")
If Ans = "" Then Exit Sub
If TypeName(Selection) <> "Range" Then Exit Sub

For Each ocell In Selection

Select Case UCase(Ans)
Case "L": ocell = LCase(ocell.Text)
Case "U": ocell = UCase(ocell.Text)
Case "S": ocell = UCase(Left(ocell.Text, 1)) & _
LCase(Right(ocell.Text, Len(ocell.Text) - 1))
Case "T": ocell = Application.WorksheetFunction.Proper(ocell.Text)
End Select

Next

End Sub

---

I only needed it to force all upper or all lower case. I have not tested the other options so use it at your own risk.

Shopping for Electronics?

I have found myself shopping online for electronics more and more so I have added some links to my side bar for some of my favorite shopping sites. NewEgg has been my fav for a while. You can find good buys if you watch their daily deals. Woot has one deal for sell each day so you have to check it every morning to see if it has something that you want.