Procurement Audit Step 13
Procurement Audit Step 13 Benford's Law Fraud detectionDownloads First digits lawSite Map
Home Page | Population | Sampling | Fraud | Other | Tutorial | Macros
Procurement Audit Step 13
Sub POStep13()
'
' checks for round numbers using the following parameters
'
' Infile - name of the file to be checked
' Column - name of the column value to be checked
' this will be a numeric column
' Report - where the report is to be written
' Note that the sequence of parameters does not matter
'
Dim oEZ As New cEZ
oEZ.RN _
Infile:=BASEDIR & "povend.srt", _
Column:="invamount", _
Report:=BASEDIR & "povend.rn"
'
' takes the report generated above and puts the values on a work sheet
'
LoadSheet _
ToSheet:="$RN", _
Infile:=BASEDIR & "povend.rn"

Set oEZ = Nothing

End Sub

 

 

 

 

Main Page

Complete Auditor resources
Links | Privacy Policy | FAQ | Downloads | Trademarks
Web Page last updated on 04-20-2008
© EZ-R Stats, LLC 2005-2007