Excel Power Utility Pak

I first found out about John Walkenback from his books. He, without question, has the best books on Excel. Back when books only were made from dead trees I judged books by how much real information versus fluff. He wins outright. His books now are available in paper format or electronically.

He also has a site with many good Excel tips.

For many years I have also used his add-in. It is another reason why I am running Excel on Windows as the Mac does not support these add-ins.

In fact even if it had only the cells items

And the text tools items

It is well worth the money!

I also get the source code which he sells for an additional price. That opens up many opportunities for programming or learning programming.

On his site, and I agree he says:

PUP is an Excel add-in that adds dozens of new features and functions to Excel. A free 30-day trial version is available.

There is also an Enhanced Data Form for free.

The J-Walk Enhanced Data Form is a free Excel add-in that provides a general-purpose data entry dialog box. The VBA code is available for a small fee.

There are other competing Excel add-ins. But I trust J-Walk’s and it is just the right amount of add-ins in the menu bar.

If you ever have questions or issues with Pup, John replies very quickly to any support request.

I had a glitch installing the latest version of Pup, enabling the worksheet functions, and found out that it was my Excel file.

  • You need to ensure that a workbook’s VB project is not protected. If you unprotect your VB project, it should work.
  • And, you also need to make sure the workbook is not shared.

Finally a Ride to Work

It was a comfortable ride. The secret was to dress for winter riding and be warm rather than dress for summer riding and be cold!

Total distance: 28.28 km
Max elevation: 1125 m
Min elevation: 1025 m
Total climbing: 164 m
Total descent: -259 m

Short and quick exercise at Glendale Hockey Rink

Fortunately, the Chinook hasn’t killed the ice and it will be cooler after today. It was actually too bumpy for messing with the puck, so I skated laps, doing a few intervals.

Total distance: 6.32 km
Max elevation: 1145 m
Min elevation: 1138 m
Total climbing: 36 m
Total descent: -32 m