David L. Farquhar on technology old and new, computer security, and more
I understand business analysts ask each other how to merge data in Excel in job interviews. The rest of us struggle and swear a lot. If you don’t count a business analyst among your best friends, here’s the secret you need to merge data with the best of them. Including the detail everyone seems to forget.
I’ll talk about Excel here, but you may be able to adapt this to other spreadsheets too.
The Coleco Expansion Module 1 was a product that added Atari 2600 compatibility to the ColecoVision game console. The product immediately allowed Coleco to claim the ColecoVision had the largest software library of any game console. It is a famous but widely misunderstood product.
The Marx Montclair passenger car was a 6-inch passenger car based on the design Marx used for its 6-inch freights. The basic design underwent some changes and updates over the years, but Marx used the name from 1935 to 1942, then resumed production in 1946 and continued until 1961.
The IBM PC/AT had a troubled history with hard drives. And if you’re using one today, even if it had one of the better hard drives in it, after 35-40 years it may not work. Here’s what you need to know about IBM 5170 hard drive types to substitute newer drives for it.
The IBM 5170 defined either 14 or 22 different hard drive types, depending on the BIOS revision. You’ll get best results if you choose something that can emulate one of the existing types.
When you think of dominance pitchers of the 1980s, Dave Stieb is right up there with Jack Morris. Arguably, the better of the two is not in the Hall of Fame. Why isn’t Dave Stieb in the Hall of Fame?
An unassuming chip, labeled VTI 73192 E4002, lurks within the Atari compatibility products of the 1980s that made Coleco and other video game consoles compatible with the Atari 2600. Here’s what that chip does and why it was important.
The Marx Bogota passenger car was a 6-inch passenger car based on the design Marx used for its 6-inch freights. The basic design underwent some changes and updates over the years, but Marx used the name from 1935 to 1942, then resumed production in 1946 and continued until 1961.
I’m not sure anyone likes refilling their Weed Eater or other string trimmer. Once you’ve done it a few times, it’s not the worst chore in the world, but if I told you how to make your string trimmer line last longer, I don’t think anyone would object to it. Especially since you can make it last longer almost for free. Soak your Weed Eater string in water to make it last longer.
The IBM PC/XT-286, also known as the IBM 5162 or IBM model 5162, was a short-lived computer from IBM announced in 1986 and released in 1987. It was a difficult computer to understand at the time, and had a mixed reception when it was new, although it has a cult following today. In this blog post, I’ll explain what was wrong with this PC at the time, and what makes it appealing to hobbyists now.
YouTuber Adrian Black was repairing a dilapidated AT motherboard with battery damage and mentioned how tedious it is to remove motherboard plastic standoffs with needle nose pliers and other tools. I have an unconventional but cheap and effective motherboard plastic standoff removal tool. I’ve been using it since the early ’90s.