Get a Workout at Work

I’ve thought about getting a Wii, with a balance board, for a bit of fun and exercise (and to steer the Roomba). Maybe I should get a treadmill for my computer desk instead.

At Salo LLC, a staffing firm in Minneapolis, a dozen desks were outfitted with treadmills and adjustable countertops.

According to an article in Downtown Journal, revenues have gone up and the participating employees have lost weight. I’ll bet the meetings are shorter too.

There are plenty of times during the day that I could walk and work at the same time, and maybe it would help beat that afternoon slump as well.

Using Excel as a 3D Game Engine

In an article on the Gamasutra blog, Peter Rakos describes how Excel can be used as a 3D game engine.

That’s not something that I’ve tried in my workbooks, but he makes a convincing argument:

“I hope you will discover that Excel effectively and efficiently incorporates practicality, tons of features, the multi-platform portability and the high performance with the unique and futuristic 3D engine features.”

Making Games in Excel

Have you built any games in Excel, for your own entertainment, or to share with other people?

To see a few games that I’ve built, and links to other people’s creations, go to the Excel Games page on my Contextures site.

You’ll find several games to download, including a Concentration card game that Doug Glancy made. The goal is to turn over matching pairs of cards.

You can even choose the pattern you’d like for the back of the cards.

Excel Concentration Game
Excel Concentration Game

Print Bingo Cards in Excel

There are printable Excel games too, like my Bingo Card template.

This workbook has three printable Bingo cards on the main worksheet. Each bingo card has a set of 24 random numbers, with a FREE square in the centre of the card.

The random numbers are filled in by formulas, so you can print a large number or unique Bingo cards. There are no macros needed in this workbook.

To get these games and more, go to the Excel Games page on my Contextures site.

bingo card numbers 1 to 75

What Business Can Learn From Baseball

In Moneyball: The Art of Winning an Unfair Game, author Michael Lewis details how Oakland A’s general manager, Billy Beane, used statistical data to create a winning team on a small payroll.

In 2007, NetSuite invited Billy Beane onto their board of directors, and have improved their sales process by using his data analysis techniques.

In the GigaOM blog, Carleen Hawn outlines their five tips for “managing by the numbers.”

  1. Just start measuring it.
  2. Reduce the number of systems you use.
  3. No such thing as a wrong metric.
  4. Consistency is king.
  5. Trust your data.

Excel Bug Fix Postponed

It’s Labour Day, and I’m doing as little labour as possible, so this posting will be very short.

Solver Problem in Excel 97

In the OneNote Testing blog, John Guin describes why a bug in the Solver sample workbook (solvsamp.xls) wasn’t considered “ship stopping” in the Office 97 release.

Don’t worry, it’s fixed now, so you won’t accidentally print 12334 copies of the worksheet.

Obviously this is old news, but it’s interesting to see how the decision was made to postpone the fix.

print 12334 copies of the worksheet
print 12334 copies of the worksheet

Back To School

In my neighbourhood, the kids head back to school next week, and the fall session has already started in other school districts. Maybe you’ve thought about taking a few courses yourself, but don’t have the time or energy to get to evening classes, or there’s no school nearby.

If it’s just the experience that you’re looking for, and not the credits, you can attend courses online at a few major universities. There are no fees, and courses are stored online so you can listen to them on demand.

For example, Berkeley has a broad range of courses, with podcasts and webcasts that you can access. To help you remember to attend, you can subscribe to the RSS feed of any event or course.

Maybe I’ll do the Introduction to Statistics, to brush up on those long forgotten skills.

Or the Modern Poetry course at Open Yale Courses might be an easier place to start.

Office 2007 Bulk File Conversion

There are many tools available to help you prepare for migration to Office 2007. The 2007 Office Resource Kit has white papers, books and other tools that you can download, such as the Migrating to Excel 2007 white paper.

One of the tools is the Migration Planning Manager kit, which contains an Office File Converter that will do a bulk conversion of your Office XP or Office 2003 files.

By converting the files to the newer version, you’ll be able to use all the new features, without individually converting each file as you open it.

The Migration Planning Manager utility and release notes are available for download on the Microsoft website. Also, Doug Mahugh describes the process in detail on his Office Interoperability blog.

Batch Resize Graphics With Shrink O’Matic

How many times has this happened to you? You have a graphic. You’re trying to find an exciting new way to prepare it for your blog or website.

You could scale the graphic, remove the graphic’s tail, head and bones, and serve the graphic as you would any other graphic dinner. But why bother, now that you can use Rovco’s amazing new computer tool, the Super Shrink O’Matic ’08.

Yes, graphic user, the days of troublesome scaling, cutting and gutting are over, because Super Shrink O’Matic ’08 is the tool that lets you use the graphic with no gif waste, and without scaling, cutting or gutting.

Here’s how it works: Catch a graphic, remove the hook, and drop the graphic – that’s the whole graphic – into the Super Shrink O’Matic ’08. Now, adjust the control dial so that the graphic is blended just the way you like it.

Yes, it’s that simple!


With apologies to fellow Canadian, Dan Aykroyd, and the legendary Bass-O-Matic.

The Business Side of Twitter

Sure, you can use Twitter to let everyone know what you had for lunch, or all about football practice, or what you fished out of the swimming pool, and plenty of people do just that.

However, you can also use Twitter to ask for feedback, share links, or give quick updates on your business or industry. If you listen, you might pick up some ideas that you can turn into blog posts, or apply in your business.

Find and follow a few people in your industry, and a few others with interests in a different area. Stick with them for a little while, and if they’re boring, or too chatty, move on, and find a couple of new people.

I follow some Excel colleagues, business associates, friends, and a few people in marketing, which is an area that I want to learn more about. If you’re looking for someone fascinating to follow, you’ll find me here. 😉

A couple of days ago I found TwitterFeed, which sends your blog feed to Twitter. This might help a few more people find your blog and become subscribers.

It requires an OpenID login, so I had to set that up, but the rest was very easy. Now, once a day, my new blog posts appear as Twitters.


For everything you ever wanted to know about Twitter, check the Twitter Fan Wiki. It has lists of users, groups, related applications, and tons of other tips and ideas.

Catalogue Your Books at LibraryThing

Use the free web application, LibraryThing, to catalogue your books, see what people with similar tastes are reading, and share reviews.

There’s also an Early Reviewers program in which publishers provide free advance copies of books, for members to review. However, there are many more requests than copies available for most books, so your chances for a free book are slim.

Sign up is quick and easy — just enter a user name, password, and optional email address. With the free membership you can catalogue up to 200 of your books. For a $10 annual or $25 lifetime membership you can catalogue an unlimited number.

Update: 2020-03-29 — Library Thing is now free for everyone.

To add a book to your catalogue, just enter a few words from the title, or other info.


Click Search, and LibraryThing will return a list of matching items. Click on a book in the list, and it’s added to your library. You’ll see how many other members have added the book, and any reviews they’ve written.

There are over 480,000 members, and 30 million books catalogued, so you’re bound to find a few people whose collections are similar to yours.

Other features include special interest groups and a Local Connection page, that shows events, libraries and bookstores in your area.

If you’re an author, you can connect with your readers, and participate in an Author Chat. You can import a wish list from Amazon, or other sources, and export your library as a CSV or tab-delimited text file.

Learn Languages Online from the BBC

If you’ll be travelling soon, you might want to learn a few key phrases of another language before you go. Free language lessons are available online, at the BBC website.

It’s good to see Nick’s tax dollars hard at work.


It’s too late to learn much Mandarin before the Olympics are over, but you can study French, Urdu, Welsh, Japanese, and many other languages.

The Quick Fix page has a list of essential holiday phrases that you can print or download as an mp3 file.

Take these along on your travels and you’ll be able to say “Sorry, I don’t speak Albanian,” “We were robbed,” or “Danger! Avalanche!”