How it works
The number of items per month sampling methodology allows you to select a number of transactions for each month in your dataset. The Sampling Tool will then randomly select that number of items in each month.
To select samples, simply follow these steps:
Step 1
In the Analysing and Sampling group, click on Sampling Tool and click on ‘Random’.
A new pop-up window will appear.
Step 2
Step 3
With the Date Column dropdown, select the heading/column in which the dates are located.
Step 4
Select the number of items to be selected for each month.
Step 5
Select the date format that is used in the date column.
Step 6
To further stratify your population or include all material items over and above the sample size.
Click below to view the Sampling Advance Section Guidance Page.
Step 7
Select whether you would like the selected items to be highlighted in the original dataset
Also select whether you would like the resulting sample to be emailed?
If email is selected, upon completion of executing the sample selection, a new email will be populated containing the sample ready to be sent to whomever.
Step 8
Click Continue to execute the function.
Step 9
The sample will be selected and populated into a new sheet in the active workbook along with the following information related to the sample selection displayed above it.
General Info:
- Performed by sign off,
- The methodology used, i.e. Number per Month,
- The sample size per month selected,
- Population size,
- Population value,
- Coverage Obtained.
Advanced Section Info:
- If applicable, the materiality value used for selecting material items
- If applicable, the values that have been excluded
