Author: Dave Farquhar

We buy houses for cash. What does that even mean?

Dave Farquhar Investing, Saving money
We buy houses for cash. What does that even mean?

I’m sure you’ve seen the signs attached to telephone poles. They say “We buy houses for cash,” stapled to a telephone pole or maybe stuck into the ground. They include a phone number and maybe a promise of a cash advance or a quick closing. You may have even received a post card in the mail offering to buy your house for cash. Who are these people, and should you consider selling to them?

If you’re not interested in selling and aren’t already working with a realtor, you have every reason to ignore those signs and postcards. If working with a realtor isn’t an option for you and you do need to sell your house or risk losing it, going the cash route may be an option for you.

Read more

Stop phone calls from political parties if you don’t want them

Dave Farquhar security
Stop phone calls from political parties if you don’t want them

Any time Congress makes it illegal to robocall you, they exempt political calls. That makes it hard to stop unwanted political calls and it pretty much means your phone is going to ring off the hook in the runup to the election. But you can still get peace regardless. Here’s how to stop phone calls from political parties if you don’t want them.

Most robocall services or apps block political robocalls along with all the others. Many of them work with landlines and cell phones. If you have a landline phone that doesn’t work with robocall services, you can still use a device to block the calls.

Read more

Origin of DeWalt tools

Dave Farquhar DIY
Origin of DeWalt tools

The history and origin of DeWalt tools can be a little confusing. In some regards, the DeWalt brand has two origin stories in its history. That’s why DeWalt started in 1923 but you might not remember seeing it much until the early 1990s. DeWalt is a good example of clever marketing.

DeWalt invented the radial arm saw in 1923. The company changed hands in 1949 and again in 1960, when Black and Decker bought it. Black and Decker divested the product in 1989 but didn’t sell the DeWalt name, which remained dormant. In 1992, Black and Decker turned around its struggling professional tool line by re-branding it DeWalt, which means that today DeWalt tools are made by Stanley Black and Decker.

Read more

LEDs for American Flyer, Lionel, and Marx trains

Dave Farquhar Toy trains , , , ,
LEDs for American Flyer, Lionel, and Marx trains

A frequent, sometimes heated topic of debate is upgrading to LED lighting in the headlight of vintage American Flyer, Lionel, or Marx trains. It shows how sometimes a little knowledge can be a dangerous thing. You have several options for LEDs in old electric trains, and not all of them are expensive or difficult.

Specialty retailers like Town and Country Hobbies sell screw-in replacement LED bulbs with an E10 base for vintage trains. It’s also possible to wire up your own circuit. You can also take your chances on cheap 12V E10 LED bulbs from Ebay.

Read more

Should I paint my basement?

Dave Farquhar DIY
Should I paint my basement?

Painting a basement is a cheap way to really improve its appearance. It also takes a fraction of the time it takes to finish it. But it’s not a zero-maintenance option. So, should I paint my basement? Only after you weigh all of the factors.

Painting a basement isn’t a one-time effort that you can just do and forget about. Over time the paint will degrade and you will have to paint it again. It can take years or decades. But as long as you don’t look at it as something you do once and forget about, painting a basement can improve its appearance and make it less humid, making it a more pleasant and useful place.

Read more

Cut plywood without a table saw

Dave Farquhar DIY
Cut plywood without a table saw

There are tons of woodworking projects available online that allow you to build some great-looking stuff with inexpensive lumber. But so many of them assume you have a table saw. How do you square up cheap dimensional lumber without a table saw? How do you cut plywood without a table saw? It turns out you can.

You can buy or make clamp-on jigs that allow you to make long cuts in a straight line with a circular saw or jig saw. This lets you do many things people normally do on a table saw, such as cutting the rounded edges off 1×4 or 2×4 lumber or ripping plywood. It’s much less expensive than a table saw, and in some cases, it’s also safer.

Read more

Change batteries in a 27 LED Harbor Freight work light/flashlight

Dave Farquhar DIY
Change batteries in a 27 LED Harbor Freight work light/flashlight

If you shop at Harbor Freight, you know their little blue 27 LED work light/flashlight. It sells for $3.99, but they almost always have a coupon to give you one free with any purchase. But you don’t have to throw them out when they stop working. The batteries are replaceable. Here’s how to change batteries in a 27 LED Harbor Freight work light/flashlight.

The Harbor Freight work light/flashlight has three AAA batteries inside. Simply remove the three Philips-head screws from the back, pop off the back, and replace the batteries.

Read more

Reduce American Flyer voltage drop

Dave Farquhar Toy trains
Reduce American Flyer voltage drop

If your American Flyer train slows down on part of your layout, you’re experiencing voltage drop. Fortunately, there are things you can do to lessen the effect of voltage drop and give yourself a smoother running layout. Some of them won’t even cost anything. Here’s how to reduce American Flyer voltage drop.

Make sure you use a thick enough wire (thicker than 18 gauge, generally), run feeder wires every third or fourth track section, have a good electrical connection between each rail, and treat any rust present to ensure good, consistent electrical conductivity throughout your layout for smooth running trains.

Read more

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