Yes
Benford's law 1st 2 digit test
This will perform the Benford 1st 2 digit test on each distinct item in a selected column. So if you have a vendor column this would perform the test for each vendor. It allows you to exclude low value items.
Updated for IDEA v9 on Feb 14, 2013.
- Read more about Benford's law 1st 2 digit test
- Log in or register to post comments
Cross Join - Updated July 2015
The cross join script will take two files that do not have a common key and creates a new file containing all records from both files. - The menu has been updated.
July 2015 - I have rewritten the interface, probably not much of a difference for the user but the backend should work better and the dialog won't close each time you make a selection. It will also work for time fields. It currently ignores virtual and boolean fields, they won't be copied over to the new file.
- Read more about Cross Join - Updated July 2015
- Log in or register to post comments
Relative Size Factor Test (RSF) - Updated Oct 24, 2012
The purpose of the Relative Size Factor test (RSF) IDEAScript is to identify anomalies where the largest amount for subsets in a given key is outside the norm for those subsets. This test compares the top two amounts for each subset and calculates the RSF for each. The RSF test is based on Chapter 11 of Mark J. Nigrini’s book, entitled, “Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations”.
Compare multiple fields
This script will take the same file from different points and time and compare multiple fields. Currently the compare funciton in IDEA only allows to compare on one field based on an amount field. This will allow for comparison of text and date fields also.
- Read more about Compare multiple fields
- 14 comments
- Log in or register to post comments
GEL - 1
The GEL tests establish possible links between two selected fields over the entire data set. The first field is the key field and the second field is the element factor.
The test was updated in October 2015.
- Read more about GEL - 1
- Log in or register to post comments