Procurement Audit Step 12

Sub POStep12()
'
' run the Benford report by the specified sort keys
'
Dim oEZ As New cEZ
oEZ.AnalyzeBenford _
Infile:=BASEDIR & "povend.srt", _
Report:=BASEDIR & "povend.ba", _
SortKeys:="vendor_number + a", _
Column:="invamount", _
BenType:="F1"

' macro to load a report file to a worksheet

LoadSheet _
ToSheet:="$BA", _
Infile:=BASEDIR & "povend.ba"
' sort by descending d-stat
Call SortRange("$BA", "D-stat", "D")

Set oEZ = Nothing
End Sub

Main Page

Complete Auditor resources
Links \| Privacy Policy \| FAQ \| Downloads \| Trademarks

	Procurement Audit Step 12
	Benford's Law Downloads Site Map