From the category archives:

Calculated Fields

Building Excel Formulas with Monarch

April 27, 2008

Regular readers will recognize the name Nick Osdale-Popa from his contribution to the site a few months ago that gave all of us a better color management tool for Excel. Well he’s been at it again, only his activity wasn’t recent; it was almost four years ago! Nonetheless, I only discovered his idea this week [...]

2 comments Click to continue...

Using Monarch for Data Entry Validation

April 11, 2008

I was recently required to review a thousand page PDF file. This file contained hundreds of financial summaries for specific topics. The challenge was, and the need for the review, was that just because certain numeric values were permitted by the online system, the updates the users provided might have been incorrect, incomplete or otherwise [...]

2 comments Click to continue...

Comparing Monarch’s Internal and External Lookups

March 21, 2008

One of Monarch’s greatest strengths is its ability to add even more related data to the new data that has just been extracted. This gives all kinds of flexibility and analytical capabilities to your main information system, be it a small accounting package or a large ERP system, that it doesn’t currently provide. Imagine being [...]

3 comments Click to continue...

Handling Floating or Missing Values with Monarch

March 13, 2008

From time to time you may run into a report designed by some renegade programmer who thought that having values shift positions from line to line on the report was actually a good idea. Additionally, maybe she thought that, rather than display zero values, it would be best if the report simply doesn’t display anything [...]

0 comments Click to continue...

Make creating expressions easier to build and read

February 16, 2008

When including numeric values in the expression to build up a character string, it’s common to use the Trim (removes leading and trailing spaces) and Str (converts numerics to characters) functions together, such as: Trim(Str(MyValue)) The equivalent when programming in Excel is the Cstr() function, so why not go ahead and build yourself a custom [...]

1 comment Click to continue...

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

0 comments Click to continue...

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

0 comments Click to continue...

Copyright © 2007 - 2012 Excel with Monarch Training and Services. All rights reserved. Privacy Policy
Microsoft Excel™ Microsoft Corporation. Monarch and Monarch Pro™ Datawatch Corporation.