Author: Dave Farquhar

How to sort by color in Excel

Dave Farquhar Office
How to sort by color in Excel

When doing data analysis, frequently you’ll use conditional formatting to highlight certain cells. But then you’ll probably find you still need to group those similar cells afterward. That’s where sorting by color comes in. Here’s how to sort by color in Excel.

You can sort by color in Excel using either the filtering function, or the Sort button on the Data tab of the ribbon. Sorting with the filtering function is faster and easier, but using the sort button lets you set up complex criteria, including multiple levels. This is useful if you want to sort on both cell color and font color.

Read more

1989 Donruss variations

Dave Farquhar Baseball
1989 Donruss variations

The 1989 Donruss set is controversial, due to the number of variations in it. There are no fewer than six variations of the set, all minor. But there is no effect I can find in the value.

1989 Donruss variations hinge on the presence or absence of a period after the abbreviation “INC” and the number of asterisks in the line “DENOTES LED LEAGUE.” This makes for an interesting and (usually) inexpensive curiosity for completists to chase in an overproduction-era set, but it typically has no effect on the card’s value.

Read more

What are scam likely calls?

Dave Farquhar scams
What are scam likely calls?

What are scam likely calls? It’s a partial solution to the problem of unsolicited phone calls. It’s probably not the ideal solution and it’s probably not the final solution. But it’s a way for your phone company to warn you that it’s suspicious of the call that’s coming through.

Flagging a suspicious phone call as “scam likely” is T-Mobile’s way of alerting its customers that it has reason to believe the phone call you are receiving isn’t legitimate. If your caller ID says “scam likely,” use caution if you decide to answer the call.

Read more

How to sort screws and nails

Dave Farquhar DIY
How to sort screws and nails

I think almost every adult at some point in their life ends up with at least one container, or maybe multiple containers, full of assorted nuts, bolts, screws, and nails. Sound like you? I bet you’d like to use them, because they’re expensive. But they aren’t useful if you can’t find anything. So here’s how to sort screws and nails and nuts and bolts.

The important part when you sort screws and nails and nuts and bolts is to identify the parts that are most useful to you, then set those apart. Also set apart items that exist in large quantities, figure out what those are, and determine if they’re useful. Then group them in a way that makes sense to you so the next time you need a bolt, you can spend two minutes in the garage instead of making a trip to the hardware store.

Read more

Using landscape transformers on train layouts

Dave Farquhar model railroading, Toy trains
Using landscape transformers on train layouts

It’s fairly common for hobbyists with extremely large train layouts to use outdoor landscape transformers instead of specialized train transformers to power the lights and accessories on their layouts. Landscape transformers are large, rugged, and less expensive. But it can be confusing how to set them up. So here’s a step by step guide to using landscape transformers on train layouts.

I use PC power supplies to power lights and accessories, but that limits me to 12 volts DC for power. I’m OK with that. But if you want 15 volts AC, or you’re uncomfortable modifying a PC power supply, low-voltage landscape transformers are another viable alternative. I don’t think they’re as economical as an old PC power supply, but they cost much less per watt than a train transformer.

Read more

How to take the drawers out of a Stanley toolbox

Dave Farquhar DIY
How to take the drawers out of a Stanley toolbox

I bought a Stanley toolbox to get some extra tool storage space. I had to take drawers out to put it together. If you got a used or floor model one without a manual, here’s how to take the drawers out of a Stanley toolbox.

Most Stanley toolboxes use small hand-operated levers on either side of the drawer. Extend the drawer as far as it will go, then push the levers on each side in opposite directions. This releases the drawer so you can pull it out the rest of the way.

Read more

Insulate an overhang properly and safely

Dave Farquhar DIY, Saving money
Insulate an overhang properly and safely

When the polar vortex brought single-digit temperatures to St. Louis, our kitchen pipes froze. They didn’t burst, but we had to go without a kitchen sink until I could thaw the pipes. Our kitchen is partially on an overhang, which makes it colder than the rest of the house in winter and warmer than the rest of the house in summer. I finally did something about it. Here’s how to insulate an overhang properly.

Read more

How to cut thin metal at home

Dave Farquhar DIY
How to cut thin metal at home

When I first became interested in electric trains as a hobby, I noticed the construction of a lot of parts was pretty simple. I wanted to replicate some of it myself. But I quickly became frustrated at paying $4 for a tiny sheet of brass and ruining half of it when I cut out my part. Here’s how to cut thin metal at home without wasting half of it.

The tools for cutting metal vary depending on the type of metal, but generally speaking, you can use relatively simple and inexpensive tools to do it, including a paper guillotine, electric metal shears, a nibbler, a rotary tool, or hand shears.

Read more

Are Harbor Freight tools any good?

Dave Farquhar DIY
Are Harbor Freight tools any good?

As a longtime homeowner, a landlord, and a train hobbyist, I’ve collected a fair number of tools. Enough tools that I recently had to buy another tool cabinet because I was out of room. A fair number of my tools came from Harbor Freight. So are Harbor Freight tools any good? Sometimes. But definitely not always. They aren’t all junk, but they aren’t all good either.

It’s hard to generalize with Harbor Freight because some of their tools are a good value for the money, or even an excellent value for their money. Others are a poor value. Harbor Freight has a reputation and has started offering better quality in recent years, but many of their cheap tools also remain on the shelves. But if you’re careful, you can do very well at Harbor Freight.

Read more

Transfer an image to metal with paper

Dave Farquhar Toy trains
Transfer an image to metal with paper

I’ve wanted for years to be able to transfer an image to metal from paper. I experimented with it a lot in the 2004 timeframe, but I was never happy with the results and I eventually gave up. Until now. Today, the materials you need to transfer an image to metal with paper are readily available, work well, and are inexpensive.

The trick is to print a reverse image on a laser printer (color or black and white) onto paper that the toner doesn’t stick to very well. Apply a thin coat of adhesive to your metal, then stick your image down and smooth it out. Let it dry, then peel the paper back to leave your image behind. Apply a clearcoat and enjoy.

Read more