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 ask that [...]

2 comments Read more...

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

2 comments Read more...

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

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 that allows you [...]

2 comments Read more...

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

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

2 comments Read more...

Monarch Batch File Generator

June 11, 2008

Update February 2010: I’ve just revised the Monarch Batch File Generator slightly. A warning, and a recommendation, will be presented if you select a PDF file as your report file. This is because Monarch v9, and only v9 (as far as I know), has a bug related to opening PDF files as a report source [...]

0 comments Read more...

← Previous Entries