VBA Script for Splitting Excel Workbook

Recently I got an Excel file which contained more than 50 worksheets and I needed to split them into individual files.

After a lot of searching, I found this simple VBA script to split excel files into individual worksheet.

Continue reading


Cryptographic Hash Option in Context Menu

What is Cryptographic Hash Function?

A cryptographic hash function is an algorithm that can be run on a piece of data, like an individual file or a password, to produce a value called a checksum.

Unlike secret key and public key algorithms, hash functions, also called message digests, have no key. Instead, a fixed-length hash value is computed, based on the plaintext that makes it impossible for either the contents or length of the plaintext to be recovered.

Continue reading

Identifying Frauds Using Correlation Coefficient

Correlation is a relationship between two things (variables) that tend to vary or move together. There is usually some logical connection between the two things/variables.

How much the two variables are connected can be determined by calculating the correlation coefficient, which is denoted as ‘r’.

correlation coefficient formula

Continue reading

International Fraud Awareness Week 2017

Every year in November ACFE celebrates International Fraud Awareness Week, to promote anti-fraud awareness and education. This year November 12-18 is being celebrated as International Fraud Awareness Week.

Whenever we speak of frauds, the first question which comes to our mind is, why do people commit frauds?

Continue reading

Batch Unzip Script for WinRAR

Extracting multiple zip files at a time can be a time consuming process. To save time, you can automate the process by creating a simple batch script to unzip multiple files in one go. I have compiled (I’m not the author) a script to automate the task of extracting multiple zip files using WinRAR.

Continue reading

Science Fiction to Reality

I love sci-fi and action movies. One of my favourite Sci-fi movie is the ‘Back to the Future’ trilogy. The best part of sci-fi movies is that what is a fiction today, can become a reality tomorrow. I still wish to own the DeLorean from Back to the Futures, but I don’t think that will become a reality during my lifetime, but who knows.

Continue reading

Largest Subset & Growth Tests

The first analysis of any data set need not use sophisticated mathematics or statistics. The goal of these test is to find subsets that are highly inflated due to the error or fraud.

Largest Subset Test

The largest subsets test uses two fields, one with transaction or balance numbers (such as amount, inventory counts, vote counts, population counts) and another field to indicate the subset (e.g., vendor number, credit card number, or branch number). Subset is a group of records that have something in common.

The data can often be divided into several subset groupings. For example, accounts payable data could be grouped by vendor or by the type of purchase (purchase order, no. purchase order) or by time. There are often a few different ways that data can be divided into subsets. For inventory data the grouping could be by location. For airline ticket refunds or retail customer refunds the groupings could be the credit card that received the refund.

Continue reading