From the category archives:

Excel Reporting

Learn to Program Excel to Become a Better Monarch Modeler

February 7, 2010

Working with Monarch to extract and manage the data we need is usually a very efficient experience. Often there are just three basic steps: Open the data source, Apply the model that was previously created, and Export the data to another location for further use or analysis. As we know from our earlier discussions in [...]

2 comments Click to continue...

Focus Your Command of Monarch

February 3, 2010

Congratulations! You’ve read every part of the 30 Days to Become a Better Monarch Modeler series, and now, hopefully, you’re much more accomplished and proficient than you were beforehand. You’ve mastered defining templates. You can handle just about any kind of report layout that comes your way. You can add new fields that extend the [...]

0 comments Click to continue...

Share Your Story with Monarch

December 11, 2009

Over the course of the 30 Days to Become a Better Monarch Modeler series we’ve learned how to positively fill Monarch with actionable data. We’ve morphed reports that had content that was cast in stone into dynamic and practically living data that is now free to tell its once concealed story. But all great stories [...]

0 comments Click to continue...

A to Z Monarch

November 25, 2009

Yesterday’s topic of filtering Monarch’s extractions and calculations helped to focus on specific aspects of the data. But what if, even after that effort, we’re still left with a large sample to make sense of? Today on day 13 of the 30 Days to Become a Better Monarch Modeler series, we’ll rather quickly sort through, [...]

0 comments Click to continue...

Get Enchanted with Excel

March 17, 2009

A sufficiently high level of technology is indistinguishable from magic. – Arthur C. Clarke Jon Peltier is the wizard of Excel charting. On his PTS Blog, he describes how to make Excel do things with graphs that you not only likely believed to be impossible, but you may not have even dreamed up the concept [...]

0 comments Click to continue...

How to Get Direct Results Indirectly

December 17, 2008

Everybody that uses Excel regularly has their favorite functions that seem to appear in most of their work, and I’m no exception. Working as I do with data extracted by Monarch, I use Excel’s various lookup functions frequently. That said, I rarely use the Indirect function. I just never really thought that I needed to [...]

2 comments Click to continue...

Restoring the Last 8 Seconds

November 24, 2008

For the last couple of years I’ve been running a particular report generation every week. This Excel custom VBA program acquires new data with Monarch, of course, and creates a distributable file that shelters the recipients of the file from the behind the scenes calculations required to get to the end result. One of the [...]

1 comment Click to continue...

← Previous Entries

Next Entries →