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

' macro to load a report file to a worksheet
LoadSheet _
ToSheet:="$WD", _
Infile:=BASEDIR & "povend.wd"
' sort the sheet by descending chi square
Call SortRange("$WD", "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