Skip to content

createAlphabeticSequence

Implementations

Microsoft Excel: AIDCT.createAlphabeticSequence(length, startValue, count, exclusion, tweak)

Google Sheets: Google Sheets: aidctCreateAlphabeticSequence(length, startValue, count, exclusion, tweak)

Create a sequence of alphabetic strings.

This function returns an array of values.

Parameters

NameTypeDescription
lengthNumberLength of string to create.
startValueNumberStart value of a domain of values to transform.
countNumberCount of values to transform. If positive, values transformed are startValue to startValue+count-1. If negative, values transformed are startValue down to startValue+count+1.
exclusionNumberString values to exclude. The only valid value is 0 (no exclusions).
tweakNumberValue by which to tweak the transformation. If not provided or zero, the output is sequential. Otherwise, the output is encrypted in such a way as to appear random, masking the values used as inputs to the sequence.

Parameters in italics are optional.