Gaps in Number Series

The 'Gaps' analysis examines a numeric series for its completeness and highlights those records where there is a gap in the series.

The form has three parameters

For this form of Lists Analysis there are two audit trail headers

The Start Value of a list is not necessarily 1 and it may not be easy to find the smallest value in a long list. The Gaps Analysis entry form will find the smallest number for you. You may also enter your own Start Value.

The analysis identifies those records where there is a gap between it and the previous record in the series and the number of records that are missing.



Remarks

The software is designed to examine whole number series only. To ensure that this is the case the package provides a validation routine which checks the list. If it finds any records that do not match the validation criteria it stops the routine and points to the first record that it found with an error.

The analysis requires that the numeric series is in ascending order and will reorder your database/list accordingly. The user will always be given the opportunity to record the original order of the database.

For more details about ACBA Analytical and Audit Tools our website contains general descriptions and additional information about it.


See also

List Analysis


  Last Updated: 06/12/2008 | © ACBA (UK) LTD, 2009