From the category archives:

Extraction Templates

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...

Defining Fields in Monarch

October 9, 2009

I’ll be among the first to say that being a desk jockey can be tough on a person. Long days virtually tied to a desk really aren’t healthy, so after a bit of an extended absence from sports, I’ve recently returned to cycling to get more exercise. Being somewhat apprehensive, I was careful getting on [...]

0 comments Click to continue...

Extracting Data from Multi-column Regions

October 8, 2009

Many of the reports that our various computer systems generate for us present data in a very linear fashion. These reports tend to be structured in a very top-down manner, having a layout similar to: Header Optional grouping data (what we as Monarch modelers normally think of as append data) A cluster of detail records [...]

0 comments Click to continue...

Understanding Template Types

October 7, 2009

And once again, after an unfortunate and unexpected interruption caused by my site host, ExcelWithMonarch.com returns. It was a bit like a radio station whose transmission tower is destroyed in a storm or something. Though the outage was out of my control, just days ago I’d promised daily posts for this series. Timing is everything, [...]

0 comments Click to continue...

Learn to Build Traps

October 2, 2009

Put some nice smelly cheese into a trap, and you might catch a mouse. Put the right trap into a Monarch template and you’ll capture your data. On day 2 of the 30 Days to Become a Better Monarch Modeler series we’re going to review the tools that are Monarch makes available to us to [...]

0 comments Click to continue...

Experimentation Produces Monarch Success

February 11, 2009

In the last post we talked about the process of learning the fundamentals of Monarch, and this leads nicely into a discussion of Monarch’s unwritten (?) cardinal rule and how we can take advantage of it. What’s the rule? Simply put, “Don’t allow the user to alter the original data in any way with Monarch”. [...]

4 comments Click to continue...

Handling Floating or Missing Values with Monarch

March 13, 2008

From time to time you may run into a report designed by some renegade programmer who thought that having values shift positions from line to line on the report was actually a good idea. Additionally, maybe she thought that, rather than display zero values, it would be best if the report simply doesn’t display anything [...]

0 comments Click to continue...

← Previous Entries