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 a [...]

0 comments Read more...

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

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
Optional subtotals
Optional new groupings, [...]

0 comments Read more...

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, right? [...]

0 comments Read more...

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 let [...]

0 comments Read more...

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”.
What’s the [...]

4 comments Read more...

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

← Previous Entries

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