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.

• NEW! Stratification Summary (This script produces summary information on the stratifications within a stratified database that can be used for sample planning purposes.)
• 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.)
• Z-Stat field (Adds a Z-Stat field to any Benford's Analysis output file selected. The Z-stat calculates the significance of the variance between the actual record count for each digit combination and expected record count from Benford's equations. It provides a mechanism for user to easily identify the most significant variances.)