From the monthly archives:

November 2007

Performing Analysis Work with Monarch

November 12, 2007

It’s Backwards Day!
If you have school aged children, you may have heard of “Backwards Day”. It’s a special day for the children to wear their clothes inside out or backwards, sing songs and read books backwards, and generally have a lot of fun.
When I heard about it, I though that I might very well be [...]

0 comments Read more...

Monarch’s User Edited Fields

November 8, 2007

You Can Edit, Produce and Direct Without Going to Hollywood!
Today we’ll conclude our review of Monarch’s calculated fields. We began with an overview of the field types, followed by a good look at formula-based fields, then runtime parameters, and yesterday’s examination of lookup fields.
The final available option when building a calculated field is the user-edit [...]

0 comments Read more...

Monarch’s Lookup Fields

November 7, 2007

Be on the lookout for lookups
In the fourth installment of our series on Monarch’s calculated fields, today we’ll have a look at lookup fields. We’ll talk about what’s different about lookup fields compared to the other calculated fields and how we can enhance our models by utilizing them.
A lookup field lets us add a specific [...]

0 comments Read more...

Monarch’s Runtime Parameters

November 6, 2007

Running with the Pack
Today we continue our series looking at Monarch’s calculated fields. Yesterday we examined formula-based fields.
One of the options available to us when you begin to create a calculated field is the “Runtime Parameter”. What does that term mean, and why would we want to create such a thing, and how can we [...]

0 comments Read more...

Monarch’s Formula Based Calculated Fields

November 5, 2007

Is There a Secret Ingredient in This Formula?
Yesterday we looked at the field types available when building calculated fields. Today we’ll examine the rest of the process of defining a calculated field.
The mechanism Monarch provides for building calculated fields allows us to select from the list of all existing fields, logical operators and a [...]

0 comments Read more...

An Introduction to Monarch’s Field Types

November 4, 2007

Playing the field
Monarch lets you add real value to the existing, already useful data you’ve captured and extracted from your reports with its calculated fields feature. To use calculated fields to your best advantage, you need to understand the types of data you can create, and how to handle your calculations so that you can [...]

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.