IDEAScript provides additional functions, routines, dialogs and processes for IDEA. As a wide reaching a full-featured programming language, it allows a wide range of options. The most common objectives in using IDEAScript are:

• Automating repetitive tasks
• Creating a local automated audit system
• Creating special tests and/or functions
• Working with other OLE (Object Linking and Embedding) enabled software
• Importing files

IDEAScript is extremely versatile and can be used for any task that can be programmed.

Shared IDEAScripts from the IDEA KnowledgeBase.

Below is a list of the scripts that are available for IDEA 2002.

• Running Index (This script produces a running total for an indexed field.)
• Accumulated Total (This script produces a running total for a numeric field.)
• Classical Sample Planning (This is a script to calculate the required sample size for a population/stratum. It is based on the Classical Sample Planning function in the DOS version of IDEA.)
• Amounts by Month (This script summarizes a numeric amount field by the month in the date field for key field selected by the user.)
• Large Items with Sample (This script separates large items and items under the cut-off amount. Then a random sample is selected from the items under the cut-off amount.)
• Time Interval Sample (This script produces a sample based on a time interval selection.)
• Coefficient of Variance (This script calculates the coefficient of variance for a selected numeric field and writes the results in the history log.)
• Percentages (This script calculates the percentage of the control total amount for each record in a numeric field.)
• Stratum Sample Planning with History (Similar to the Classical Sample Planning script above, this script allows users to calculate the required sample size for a stratum/population and writes the results to the history log.)
• Max Min Ratio Analysis (This script identifies the maximum and minimum values in a numeric field based on the key field selected by the user and produces a ratio showing the relationship of the two numbers.)

IDEAScript User Guide

The IDEAScript User's Guide is a reference manual created to assist user's with their creation of IDEA macros. The Guide covers topics from beginning to advanced. Areas covered include Basics, Programming Fundamentals, Dialog Boxes, Advanced Topics, Basic Language Objects, and IDEAScript Objects. The table below lists many of the scripting examples that users may find throughout the Guide.

IDEAScript User Guide - $75

Click here to order .