Memorized...

Home
Up
Instructions
Order
Freebies
Example script

 

This is cool: an extension that remembers your selections and calculations in a table, lets you redo them at any time, and writes clean commented Avenue code that turns what you did into scripts that work right away, all the time!

Want to document your work?  Save hours the next time you have to redo some database manipulation?  Write scripts in seconds instead of hours?  Learn the hard part of Avenue--data manipulation--quickly?  This is the way.

Would you like to treat a table like a spreadsheet, where you can recalculate formulas cell by cell?  This extension does it.

To see how incredibly powerful Memorized Calculations is, take a look at the "Freebies" page.  Each memorized calculation does the equivalent of an entire Avenue script.   Indeed, each calculation can be turned into Avenue code at the click of a button: see the "Example script" page.

Description

Memorized Calculations offers the familiar ArcView dialogs--the Query dialog, the Field Calculator, and the New Field dialog.  You access them by double-clicking on a memorized formula within a list of formulas presented to you.  Your changes can be immediately tested without damaging your tables.

Here is a screen shot of Memorized Calculations immediately after it has executed a series of four memorized formulas.  Each formula consists of an optional preliminary selection of records.  Only the selected records will be changed by the formula.  Then, the designated field will be computed as indicated in the [Formula] column.

In effect, the [Selection] determines the row or rows to recompute and the [Field] determines the column in your table.  This gives you the precision to designate individual cells or ranges of cells for recomputation, just like your spreadsheet does.

Memorized calculations are saved with each ArcView Table document individually--they are part of your project.

A demo version will shortly be available from our "free software" links.  The demo memorizes calculations, but it does not provide the coolest feature--Avenue script writing--or the time-saving conveniences of copy and paste to the clipboard, save and load from files.

Features

Remember every selection and calculation you perform on a table.
Automatically write Avenue code based on your selections and calculations.
Redo any calculation at any time.
Test new selections or calculations in real time without affecting your data.
Enhanced selection capabilities: XOR a selection with the previous one; set a table definition just like you set a  theme definition.
Speed up your calculations: batch a series of formulas and execute them all at once, saving huge amounts of time on large tables.
Get meaningful error messages if a calculation fails.
Apply the same formula to many tables, using copy/paste and pushing a button.
Enter comments or descriptions of your formulas to make it easier to remember them.
Share your work with colleagues by saving expressions to a file.

How to Get Your Copy

Order the full featured version on-line here for only $29.95.

Try the demo version.  It is free and there are no artificial limitations to its use.  However, it does not have the script-writing capability.

 

Google
ColorRamp, Memorized Calculations, and Sample are  trademarks of Quantitative Decisions. All other products mentioned are registered trademarks or trademarks of their respective companies.
Questions or problems regarding this web site should be directed to [email protected].
Copyright © 2000 Quantitative Decisions.  All rights reserved.
Last modified: Thursday October 05, 2000.