Macro - CMA Sampling

Sub RunCMA()
'
' select a CMA sample using the following parameters
'
' Infile - name of the file to be checked
' Column - name of the column value to be sampled
' this will be a numeric column
' Report - where the reconciliation report is to be written
' Extract - where the sampled items will be written
' J - the interval value
' R - reliability, a value of 1,2 or 3 (if omitted 1)
' RN - a random starting number (must be less than J/R)
' Note that the sequence of parameters does not matter
'
Dim oEZ As New cEZ

oEZ.CMA _
Infile:=BASEDIR & "clmdensp.txt", _
Report:=BASEDIR & "clmdensp.cma", _
Extract:=BASEDIR & "clmdensp.ext", _
j:=100, _
r:=1, _
Column:="paidamt", _
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

	Macro - CMA Sampling
	Benford's Law Downloads Site Map