Procurement Audit Step 16
Procurement Audit Step 16 Benford's Law Fraud detectionDownloads First digits lawSite Map
Home Page | Population | Sampling | Fraud | Other | Tutorial | Macros
Procurement Audit Step 16
Sub POStep16()
'
' run the Holiday report by the specified sort keys
'
Dim oEZ As New cEZ
oEZ.AnalyzeHol _
Infile:=BASEDIR & "povend.srt", _
Report:=BASEDIR & "povend.hol", _
SortKeys:="vendor_number + a", _
Column:="paydate"

' macro to load a report file to a worksheet
LoadSheet _
ToSheet:="$Hol2", _
Infile:=BASEDIR & "povend.hol"
' sort the sheet by descending chi square
Call SortRange("$Hol2", "Chi Square", "D")

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