How it works
This sampling methodology gives the user the option to select a sample based on a given starting point and a fixed interval across our population data.
To select samples, simply follow these steps:
Step 1
In the Analysing and Sampling group, click on Sampling Tool and click on ‘Fixed Interval’.
A new pop-up window will appear.
Step 2
Step 3
Choose between starting from a random row or starting from a specific row.
Unchecking the tickbox will enable the starting row to be edited.
Step 4
Enter the interval to be used for sampling.
Step 5
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 6
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 7
Click Continue to execute the function.
Step 8
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. Fixed Interval Sampling,
- The sampling interval selected,
- The Starting row 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
