Procurement Audit Step 14

Sub POStep14()
'
' run the round number report by the specified sort keys
'
Dim oEZ As New cEZ
' InFile - name of input file to be analyzed
' Report - name of output file to contain the report
' SortKeys - specifies how the input file is sorted
' Column - name of the column whose values are to be analyzed
oEZ.AnalyzeRN _
Infile:=BASEDIR & "povend.srt", _
Report:=BASEDIR & "povend.rn", _
SortKeys:="vendor_number + a", _
Column:="invamount"

' macro to load a report file to a worksheet
LoadSheet _
ToSheet:="$RN", _
Infile:=BASEDIR & "povend.rn"
' sort the sheet by descending chi square
Call SortRange("$RN", "Chi Square", "D")
Set oEZ = Nothing
End Sub

Main Page

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

	Procurement Audit Step 14
	Benford's Law Downloads Site Map