From the monthly archives:

October 2009

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

30 Days to Become a Better Monarch Modeler

October 1, 2009

Welcome to the first in a series of daily (yes, he said daily) posts here on ExcelWithMonarch.com designed with the intention of helping us all become better Monarch modelers. On each of the next 30 days I’ll present some amount of theory or other introduction or discussion, and a task for you to perform on [...]

0 comments Read more...

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.