Author: Dave Farquhar

Get rid of trailing zeroes in Excel charts

Dave Farquhar Office, Software ,

I was making a chart in an Excel spreadsheet the other week and it insisted on adding trailing zeroes in the charts after the decimal point, even though all of my stats were whole numbers. Here’s the solution I finally found to get rid of trailing zeroes in Excel charts.

Read more

Lionel CW-80 vs vintage transformers

Dave Farquhar Toy trains , , , , ,
Lionel CW-80 vs vintage transformers

Someone asked me recently about the Lionel CW-80 and how it compares vs older transformers. That’s a fair question, and one that tends to stir up a lot of emotions on train forums. So I’ll try to present the pros and cons in a fair manner.

Read more

Hole in wall repair made easy

Dave Farquhar DIY, Landlording
Hole in wall repair made easy

When fixing up a house or changing things around, it’s inevitable that you’ll have to patch some holes in the wall. Small nail holes are easy to fill with a bit of spackle applied with your fingertip, but bigger holes can be tougher, unless you know a couple of tricks that make hole in wall repair easy.

Read more

High side vs low side

Dave Farquhar security , , , ,
High side vs low side

The other day I heard a reference to the “high side vs low side” of a computer system in a podcast, and the speaker didn’t stop to clarify. Worse yet is when you hear “on the low side” or “on the high side.” I came from the private sector into government contracting myself. I wasn’t born knowing this jargon either, so I’ll explain it.

Read more

Who bought Commodore

Dave Farquhar Retro Computing , , , ,

Commodore International went out of business in April 1994, after nearly a decade of declining revenue. But the company left a significant legacy, which leads to some logical questions. What became of Commodore? Who bought Commodore?

Read more

Your Lionel 675 light doesn’t work? Here’s the fix.

Dave Farquhar Toy trains ,
Your Lionel 675 light doesn’t work? Here’s the fix.

Your Lionel 675 light doesn’t work, you say? Mine didn’t either, but the fix was really simple. You might not even need any parts.

The postwar 675 (and its brothers, the 2025 and 2035) have a quirk in their design that can make the light bulb quit working. But it’s easy enough to fix it, once you know what to look for.

Read more

When DD-WRT doesn’t work with Charter

Dave Farquhar DD-WRT, Servers and Networking , , , ,
When DD-WRT doesn’t work with Charter

I set up a DD-WRT router on Charter’s Spectrum broadband, and had a hard time getting it to work. It wouldn’t pull an IP address on the WAN side, or it would pull a 192.168 address rather than a Charter public address.

Here’s what I had to do to fix it.

Read more

Wooden ties for electric train track

Dave Farquhar Toy trains , , , , , , ,

Someone asked me the other day about the dimensions of the metal ties on vintage electric train track, presumably to cut some wooden ties to match. So I pulled some track out of my stash, got out my caliper, and took some measurements.

Vintage electric train track from American Flyer, Lionel and Marx had large gaps in between the ties. Filling those gaps makes the track look more finished and a bit more realistic.

Matching them exactly using the wood and the tools available to you may be difficult, but you don’t have to be exact. I have some tips for that as well.

Read more

Why MAC address filtering doesn’t help security

Dave Farquhar security , , , ,

The other question that came out of my recommended DD-WRT settings was why not filter MAC addresses. I hate to be flip, but MAC address filtering doesn’t help, so why bother?

The reason is because your MAC addresses are broadcast as part of the network traffic, and it’s unencrypted. So your MAC addresses aren’t any secret at all. So it doesn’t do any good. One could argue it doesn’t do any harm. But it adds an extra step every time you put something on your wireless network. Why go to the inconvenience if you don’t gain anything from it?

Read more

Why hiding your SSID makes your security worse

Dave Farquhar security , , , ,

I got a couple of questions about my recommended DD-WRT settings, but I’m going to start with the question about why not to hide the SSID. It actually turns out that hiding your SSID is bad for you, and makes your security worse. I’ll explain.

Read more