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

First ski day of the year

My first impression coming from Calgary was, where’s all the snow?

I arrived early, by 9:30, and was the third car in the Elk Pass parking lot. When I returned the lot was mostly full.

  • Up Elk Pass, skier set track, packed underneath. Solid snow cover.
  • Tyrwhitt, skier set track, a bit rough. Lots of bush tops poking out of the snow. I don’t know if they are waiting for more snow before setting tracks.
  • Whiskey Jack: trackset, hard packed and fast.
  • Moraine, thin snow but good enough coverage with a shallow trackset.
  • Fox Creek, thin, trackset, a few roots and rocks showing through
  • The wind was picking up and hopefully it won’t blow too much onto the tracks. There was already some tree bits on Moraine and Fox Creek.

    Total distance: 19.96 km
    Max elevation: 2004 m
    Min elevation: 1722 m
    Total climbing: 631 m
    Total descent: -631 m