From the monthly archives:

June 2008

Audience Participation Day

June 26, 2008

I need your help. With the long history of both Excel and Monarch, the challenge for me isn’t so much what to write about, as there’s so much than can be discussed, as much as it is choosing to focus on what it is that is interesting and useful to you. To that end, I [...]

2 comments Click to continue...

Three Ways to Improve Your Visual Analysis Toolkit

June 24, 2008

On the Recommended page, you’ll find links to Stephen Few’s textbooks on visual presentation. With a little extra effort – mostly avoiding Excel’s defaults – you can accomplish many of his teachings with Excel. With a little extra software, you can even mirror his samples (more on that later). But there are a few additional [...]

2 comments Click to continue...

Monarch’s Conversion Functions

June 19, 2008

Over the past week, we’ve been discussing Monarch various functions that you can use in your calculated fields and filters. So far, we’ve covered date functions, the special report functions that return data related to the origin of the data (as opposed to the data within the report), and we even had a quick look [...]

0 comments Click to continue...

Monarch’s Special Functions

June 16, 2008

Over the last couple of posts, we’ve examined some of Monarch functions. Since we’re on a bit of a roll, let’s carry on with the topic. Today we’ll look at a special category of functions, known as, well, special functions. There aren’t too many, so this might be pretty quick. If() Just about every application [...]

2 comments Click to continue...

Exploring Monarch’s Report Functions

June 15, 2008

Last week we touched on a couple of useful conversion functions that are available to us in Monarch. Today we’ll continue looking at functions; this time focusing on one of the smaller function categories, that of the “report” functions. Report functions are those which give us data related to the actual report file in use, [...]

0 comments Click to continue...

Conquering Date Problems in Monarch

June 12, 2008

Yesterday I received a message from a reader asking about how she could resolve a challenge with extracting dates from her report. The problem was that the date in the report appeared in the form of 01-Oct-07, and she wanted 10-01-2007. She’d been trying to use, correctly, the CtoD function, but kept getting null values [...]

2 comments Click to continue...

Monarch Batch File Generator

June 11, 2008

Update September 2010: Again, slight revisions have been made to the Monarch Batch File Generator. Regular site reader Lance wrote today to ask if the utility was capable of creating exports to Access databases (.mdb format), which it is. But his question prompted me to think about the new file format options available when exporting [...]

3 comments Click to continue...

← Previous Entries