How to keep Excel from dropping zeroes after the decimal point

Dave Farquhar Office, Software , ,

At work part of my job is reporting security metrics along with my colleague, and sometimes we report things like the number of machines running a specific operating system. The problem we run into is that when it comes to operating system versions, OS X versions 10.1 and 10.10 are really not the same. We run into similar issues with versioning for other operating systems too, such as AIX.

To keep Excel from dropping those significant zeroes on your charts, highlight the column containing your version data and switch it from a numeric format to text format. Then switch to the tab that contains your chart, refresh the data, and your charts will show the zeroes properly.

The Altair 837016 LED outdoor fixture from Costco

Dave Farquhar Saving money , , ,

My front porch lights sustained damage in a storm, so that gave me an excuse to modernize to an Altair 837016 from Costco. Priced at about $38, it has two energy-saving features: It turns itself off if it’s light outside, and it uses LEDs that deliver 950 lumens while consuming 10.5 watts.

These worked for me for about 10 years, but today there’s another option I like better that works just as well.

Read more

Google’s migrating corporate apps to the cloud is less crazy than it sounds

Dave Farquhar security , , , ,

Google is moving its corporate applications to the Internet. A year ago I would have said that’s the dumbest thing I ever heard. Today I’m not so sure.

Sticking stuff in the cloud is the popular answer to everything these days, and I just see the cloud as the new mainframe. It’s not a solution so much as a different take on the same problem, and while I see a couple of potential disadvantages, believe it or not I see some real advantages to the approach as well.

Read more

The difference between the TP-Link TL-WR841N and TL-WR841ND

Dave Farquhar Servers and Networking , ,
The difference between the TP-Link TL-WR841N and TL-WR841ND

I see people asking about the difference between the TP-Link TL-WR841N and TL-WR841ND (sometimes they just ask TP-Link TL-WR841N vs TL-WR841ND). Since nobody else seems to have answered, I’ll take the question.

TP-Link TL-WR841n
This is the TP-Link TL-WR841n.

Here’s how to decode TP-Link model numbers. This is true of the 841 series, which is my go-to for the moment when I need a capable yet inexpensive router, but also other TP-Link models.

“TL” stands for TP-Link. “WR” stands for wireless router. The numbers tell you where the model stands in the product line. Beefier routers have larger numbers. “N” stands for the type of networking, which, in this case, is 802.11N. “D” stands for detachable antennae.

If you don’t need to be able to detach the antennae to replace them with bigger, longer-range models, you can save some money by buying the N-model. Otherwise, the TL-WR841N and TL-WR841ND are functionally identical. They both use the same DD-WRT build.

Fare thee well, Super Civic. And thanks for everything.

Dave Farquhar Parenting, Saving money

Last week, at about 238,000 miles, we traded my wife’s 2002 Honda Civic. It was good to us.

She drove that car the night we first met. It was the car we drove home after we got married. We drove our dog home from the Humane Society in it, I drove her to the hospital in it, and we drove our two boys home from the hospital in it. When a car lasts 13 years, it gets to participate in a lot I guess.

Read more

Beware “graded value” baseball cards on Ebay

Dave Farquhar Baseball, scams , ,

There are a few hucksters on Ebay, whom I don’t care to give free advertising by mentioning by name, who hawk “graded” cards on Ebay and claim them to be especially valuable. One even puts supposed appraised values in his listings in parenthesis, then invites you to visit his page for an explanation of “graded” value, where he cites an example of a run-of-the-mill 1970s star card, normally worth $60, being worth $2,500 once graded.

The thing is, that’s an edge case. It’s important to understand those edge cases to avoid a ripoff.

Read more