Macro - Interval Sample
Macro - Interval Sample Benford's Law Fraud detectionDownloads First digits lawSite Map
Home Page | Population | Sampling | Fraud | Other | Tutorial | Macros
Macro - Interval Sample
Sub RunIS()
'
' interval sample using the following parameters
'
' Infile - name of the file to be checked
' Extract - name of the file to contain the sampled
' data
' Report - where the reconciliation report is to be written
' RN - random start (must be less than interval)
' Note that the sequence of parameters does not matter
'
Dim oEZ As New cEZ

oEZ.iSamp _
Infile:=BASEDIR & "clmdensp.txt", _
Report:=BASEDIR & "clmdensp.isr", _
Extract:=BASEDIR & "clmdensp.ext", _
interval:=100, _
RN:=27

LoadSheet _
ToSheet:="$Debug", _
Infile:=BASEDIR & "clmdensp.ext"

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