Excel Formula To Generate EAN 13 Digit Barcode Check Digit

I was preparing data in an Excel spreadsheet for import into an OpenBravoPOS database, and needed to generate check digits for my custom EAN-13 barcodes. 

Here’s the Excel formula I constructed to generate a 13-digit barcode check digit. It works in Google Sheets too!

Continue reading “Excel Formula To Generate EAN 13 Digit Barcode Check Digit”

Garlic & Onions against Teeth Plaque?

It’s a known fact that eating garlic and onions make you socially repulsive, but garlic and onions also have known curative properties.

Garlic, for one, is known, and I have personal experience with this, to drastically lower blood cholesterol.  The downside is that you have to take it chopped and, yes, raw – for at least 2 weeks. Say goodbye to your non garlic-eating friends.

Continue reading “Garlic & Onions against Teeth Plaque?”

Disable, Limit and Delete WordPress Revisions

For me, a major WordPress Blog annoyance is the WordPress Revisions feature. It essentially saves a copy of your post or page every time you update it. If you share my frustration, here’s how to stop or limit WordPress Revisions and clean current revisions from your database.

Continue reading “Disable, Limit and Delete WordPress Revisions”

A New Theme for 1Earth is Coming

Ever since I switched 1EarthAdventures to WordPress way back when *checks notes*, on 15 October 2005, or thereabouts, I’ve been using this awesome Illacrimo Theme from Design Disease.

However, this is 2010 and my blog has evolved from a Twilight-esque, emo diary, into a blog where some of the posts are actually helpful enough to be linked to and read quite often. So, I think it’s time for a new theme.

Continue reading “A New Theme for 1Earth is Coming”

Repair XP MBR with only an Ubuntu Live CD

I just deleted an old Ubuntu off the Journo’s dual-boot Ubuntu/XP HP Pavillion, and along with it Ubuntu’s Grub and her Master Boot Record (MBR), which of course rendered the machine useless. Sigh.

I had an Ubuntu 10.04 Lycid Lynx Live CD at hand (never leave home without it), so here’s how to repair an XP MBR with only an Ubuntu Live CD.

Continue reading “Repair XP MBR with only an Ubuntu Live CD”

World Cup Also Has Football Action

I’ll be the last person you’ll ever see at a screening of a regular football (soccer) game, yet, like many, I find the World Cup irresistible. And it’s not just because I’m from South Africa either.

2010 FIFA Football World Cup Country Flags
Continue reading “World Cup Also Has Football Action”