Yes
Text Search
The text search script gives you an alternatvie interface to performing a text search from within IDEA. The script allows you to select up to 10 different search terms (you can use the wildcards), it also allows you decide if the search is case sensitve or not and the type of search, i.e.
- Read more about Text Search
- 10 comments
- Log in or register to post comments
Identify Blank / Repeat Fields
This script will identify any blank fields or fields in which the information repeats. The scrpt will rename the fields based on a prefix that the user gives. It also write a text file to the working directory of the fields which should be kept. The script will then create a new IDEA file which will list the fields that contain empty or repeating data and allows the user to decide if they wish to keep or delete the field. The user would then run the script a second time in order to delete the choosen fields.
- Read more about Identify Blank / Repeat Fields
- 2 comments
- Log in or register to post comments
GEL-2
The purpose of the GEL tests (GEL-1 and GEL-2) is to detect relationships or links within a data file that serve as potential indicators of fraud.
- Read more about GEL-2
- 6 comments
- Log in or register to post comments
Same-Same-Same Test (SSS)
The purpose of the Same-Same-Same test (SSS) and the Same-Same-Different test (SSD) IDEAScripts are to identify abnormal duplications as potential indicators of errors or fraud.
Updated Sept 17, 2015 - Updated the dialog.
- Read more about Same-Same-Same Test (SSS)
- 1 comment
- Log in or register to post comments
The Same-Same-Different Test (SSD)
The purpose of the Same-Same-Same test (SSS) and the Same-Same-Different test (SSD) IDEAScripts are to identify abnormal duplications as potential indicators of errors or fraud.
This script was originally writting using the Duplicate - Exclude function in IDEA but it turns out that there is a bug in version 7 and 8 of IDEA in which this function does not capture duplicate entries, it would only capture the first entry. The script was rewritten to capture dulicates that fit the Same-Same-Different test.
September 2015 - Rewrote the interface.
- Read more about The Same-Same-Different Test (SSD)
- 16 comments
- Log in or register to post comments
Review Status
This script is a good utility script for adding x number of multistate fields along with opotion comment fields. This would be useful for anyone using IDEA to change a sample database into one where a user can track and comment on audit steps.
- Read more about Review Status
- Log in or register to post comments
Mod Calculation Script
This mod test looks for round number in multiples of 100, 1000 and 10000 when taking into consideration the possible tax rate.
- Read more about Mod Calculation Script
- 1 comment
- Log in or register to post comments
Last-Two Digits Test
This script is based on Mark J. Nigrini's Forensic Analytics book - Chapter 8 - The Last-Two Digits Test. This test is a powerful test for number invention or number creativity. The test identifies abnormal duplications on the right side, these duplications could indicate errors, invented numbers, or excessive rounding. To run this test, select the file you wish to perform the test on and the amount field. The resulting file will have 100 transactions showing the last two digits i.e. 01 to 99 and the difference with the expected rate
- Read more about Last-Two Digits Test
- Log in or register to post comments
Benford's law 1st digit test
This will perform the Benford 1st 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.
September 2015 - The interface has been rewritten along with some updates.
- Read more about Benford's law 1st 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