Author: Dave Farquhar

Add serial and PS/2 ports to a Dell Optiplex computer

Dave Farquhar Hardware
Add serial and PS/2 ports to a Dell Optiplex computer

A lot of modern computers don’t come with PS/2 ports anymore, the reason being that USB replaced most of the ways we used to connect external peripherals to computers. But sometimes you need those ports on a modern or modern-ish computer. Here’s how to add PS/2 ports to a Dell Optiplex computer.

Read more

Watermelon KPI meaning and examples

Dave Farquhar security
Watermelon KPI meaning and examples

A former Microsoft executive referenced watermelon KPIs the other day on social media. It’s been a long time since I’ve heard that term, but I see examples of watermelon KPIs frequently. Let’s talk about what watermelon KPIs are, how to recognize them, and why they are bad, but people still love them.

A watermelon KPI is a statistic or metric that looks good, but upon further examination, is actually bad. Like a watermelon, these KPIs are green on the outside, but red on the inside.

Read more

Tandy 1000 and 1000SX upgrades

Dave Farquhar Retro Computing
Tandy 1000 and 1000SX upgrades

I watched a YouTube video recently about a Tandy 1000sx and he inquired about what kind of upgrades he should try. So let’s explore some options for upgrading a Tandy 1000 SX, or the models it replaced, the Tandy 1000 and Tandy 1000A.

The Tandy 1000 and Tandy 1000SX have ISA expansion slots, giving them more options for upgrading than the IBM PCjr or the compact all-in-one Tandy 1000EX or HX. But the Tandy 1000SX with five slots can go a step further than the 1000 or 1000A, which only have three slots.

Read more

What the build dates on Lionel trains mean

Dave Farquhar Toy trains
What the build dates on Lionel trains mean

Here’s a question that comes up from time to time on train forums. What do the build dates on Lionel trains mean? In the Lionel postwar era, not a lot. At least not if you’re looking to figure out the actual age of the model.

The build dates on Lionel postwar trains, and largely for MPC-era trains as well, indicate when the model was first released, not when the example you hold in your hands was built.

Read more

Rebuild an XLSX file in Python

Dave Farquhar Software
Rebuild an XLSX file in Python

I ran into a compatibility issue with the formatting in an Excel file. When I tried to open the file in a Python program using Pandas, as one does, I got the following error: ValueError: Colors must be aRGB hex values.

Very old versions of xlrd (version 1.2.0) can get around the color problem and open the file anyway, but Pandas requires version 2.0.1 or newer. I got around the problem by using an old xlrd to open the file and rebuild the file with a current version of xlsxwriter so Pandas could open the resulting file.

Read more

Are Ecosmart light bulbs good? My experience

Dave Farquhar DIY
Are Ecosmart light bulbs good? My experience

I’ve been buying Ecosmart light bulbs at Home Depot since the summer of 2015. Ecosmart is Home Depot’s house brand. At the time I started buying them, they seemed like good bulbs for the money. The last time I bought bulbs, they had pretty much crowded everything else off the shelf. So let’s talk about Ecosmart light bulbs and whether they are any good.

Read more

Amiga 500 motherboard revisions

Dave Farquhar Retro Computing
Amiga 500 motherboard revisions

There were four major revisions of the Amiga 500 motherboard released, and that matters if you are trying to upgrade them. Fortunately, if you know what to look for, you can quickly distinguish between all four, and you can even identify them without opening the case. Although it is certainly easier to identify them if you can see the entire board.

Read more

Update Windows without rebooting

Dave Farquhar security
Update Windows without rebooting

Of course, saying you can update Windows without rebooting is a bit of a misnomer. Some updates don’t require a reboot, but with the ones that do, there isn’t really any getting around it. You can delay the reboot, but if you never get around to rebooting, you have a partially applied update indefinitely.

But here’s how I used to use delayed reboots to help me get more done in my maintenance window.

Read more

Prevent tools from rusting

Dave Farquhar DIY
Prevent tools from rusting

A common problem with tools, whether we are talking garden tools or hand tools, is the tools rusting in storage when we aren’t using them. Here’s how to prevent tools from rusting in your garage, your shed, or your toolbox.

Read more

Twitter vs Mastodon

Dave Farquhar Software
Twitter vs Mastodon

Twitter’s instability over the course of 2022 caused an unprecedented number of people to seek alternatives. The alternative that appears to be the most viable is Mastodon, an open source social network with some clear similarities, but also notable differences. So let’s look at Twitter vs Mastodon, and I will provide some tips as someone who has started the migration.

Millions of people migrated to Mastodon in November 2022, a migration that rivaled the migration from Digg to Reddit in 2010. And much like how Reddit was like Digg in some ways but not others, Mastodon is like Twitter on the surface but has some differences that can be confusing at first.

Read more