From the category archives:

Calculated Fields

Favorite Functions and Features

April 8, 2010
Image by Marcin Wichary

UK-based consultant Grant Perkins continues to share his insights with us while I do my best to fight back against a touch of pneumonia. As users will know (I hope!) Monarch offers a broad selection of Functions to help us extract information from a wide range of data sources and then shape it into the [...]

0 comments Click to continue...

A Challenging Reinforcement

November 27, 2009

As we’re at the midpoint of the 30 Days to Become a Better Monarch Modeler series, today on day 15 I have a real-life challenge and proposed solution that I think quite nicely reinforces some of the concepts and tools that we’ve discussed so far. This week a new Monarch Forum member named MikeMetta posted [...]

0 comments Click to continue...

Mastering Monarch’s Calculated Fields

October 12, 2009

During my teen years in grade school I was a consummate math geek. I “trained” and competed in national math contests, mostly for fun. Who’d have thought, huh? In retrospect, I probably should have gone into something like engineering, but computing drew me in. It was probably the possibility of encountering and solving endless calculations [...]

1 comment Click to continue...

Examining Chrysler Closures With Monarch

May 26, 2009

Auto maker Chrysler recently announced their intent to close 789 dealerships (PDF) in the US as part of their recovery plan. While it’s unfortunate, and will clearly have an impact on individuals and local economies, we can use their PDF list as an example of what can be done with Monarch Pro in terms of: [...]

4 comments Click to continue...

T-Shirt Monarch

May 12, 2009

Buying a T-shirt, in North America at least, means that you pick a shirt that has a label that that reads either Small, Medium, Large, Extra Large, or depending on the manufacturer, maybe Extra Small or Extra-Extra Large. This simplifies the choices rather than forcing an exact measurement. It’s not about precision; it’s about being [...]

0 comments Click to continue...

Address Your Addresses with Monarch

November 10, 2008

It’s usually around this time of year that the panic starts in offices everywhere. It often begins with “We need a clean list of contact information for the annual mailing”, and is just as often followed by an inordinate amount of stress on the part of the person who’s responsible for compiling the list. The [...]

0 comments Click to continue...

Fine Tune Monarch

September 25, 2008

When I’m at my desk for anything longer than just a couple of minutes, you can almost guarantee that there will be music playing. And it’s usually one of the many songs I copied from my constantly growing CD collection to my computer. It’s no wonder that the iPod and portable media players in general [...]

0 comments Click to continue...

Copyright © 2007 - 2013 Excel with Monarch Training and Services. All rights reserved. Privacy Policy
Microsoft Excel™ Microsoft Corporation. Monarch and Monarch Pro™ Datawatch Corporation.