Source:- ACL Blog
The Product Pulse is ACL’s regular blog series on product & ecosystem updates.
Dice coefficients for fuzzy matching, a catalog for ScriptHub, and a COSO 2013 SOX template in Project Manager.
When I presented Inspirations to the crowd at the 2015 Connections conference, I wasn’t totally shocked when only a handful of people were aware of the DICECOEFFICIENT() function released with ACL Analytics 11.3. If you’re like me, you thought that the scary sounding dice coefficient function was only wielded by statistical wizards.
WRONG! Dice coefficent can be used to do super-effective fuzzy matching:
DICECOEFFICENT(employee_name, vendor_name, 2) = percentage match between employee_name and vendor_nameIt’s like, a bajillion times faster than a Levenshtein distance test. HOW? Think of “Dice” not as in random and statistics, but rather “chop up”. DICECOEFFICIENT() chops up your strings into small pieces (whose size is determined by the third parameter. In our example, it was 2) and compares the pieces together. It’s fast, simple, and usefully (though not perfectly) accurate.
The bad news? The fields need to be in the same table for it to work… so if you’re comparing employees and vendors, they’re typically in two different tables.
The good news? We’ve got a script for that in ScriptHub. It’s called, “Company and Name Matching“.
Read on to learn how to find specific scripts in ScriptHub.
We’ve realized that finding scripts in ScriptHub was harder than using the scripts themselves. We’ve painstakingly categorized them all and made them into a catalog here: http://docs.acl.com/release_notes/ScriptHub/scripthub-catalog.html
Some of my favorite categories include Harmonizing, Patterns/Transpositions, and Keyword Searching.
PROTIP: once you hover over the filter/search bar, you’ll see a little triangle nub that you can click on to get a list of all the categories.
Okay, you just groaned. But no matter how many SOX puns you endure, I’m sure you’d rather read them all day rather than actually manage a SOX program. We’ve got a few folks at ACL who used to do them themselves, and would love to make your job easier with… a pre-built framework!
Want to get started with this content? In Project Manager, create a new Project from ACL Project Template, and select Sarbanes-Oxley (SOX) Audit Template (COSO 2013 Framework). You can then clone/copy individual processes/sections to your own project, or use the whole project as a starting point.