“‘we just created one in Excel where you point to the amount column… you can go look at the visual and you see huge spikes’”
Daniel McCarville · The Audit Podcast · Ep 297: Benford's Law w/ Daniel McCarville
Play from 9:39
9:39
Audio streams from the publisher’s own feed. Verbatim does not host or copy it.
What was described
build an Excel sheet where you point to an amount column and it automatically plots the Benford digit distribution
Said nearby on the same subject
“The one piece of advice I would give is first normal form inside a table in Excel. So that means that where you've got different months across the top, you don't want different months. You want a column and then a single column of values.”
“Excel is not dead ... until we get to a point where we are building systems that are customized for that business, you're still going to have external files”
“Ended up with hundreds of sheets of sort of emotional journeys, came back and hundreds and hundreds of different pain points… I was able to compare and see where the relationships lie”
NW
Neil Williams
This is Journey Management ·
How they workhundreds of sheets; hundreds of pain pointsShare this moment
“We plotted all of them, put the image into CLIP and plotted this CLIP space in 2d ... we found a big island of solutions that are not open-ended and a small island where the coolest simulations lie”