Skip to content

forwardTransformSequence

Implementations

Microsoft Excel: AIDCT.forwardTransformSequence(domain, startValue, count, tweak)

Google Sheets: Google Sheets: aidctForwardTransformSequence(domain, startValue, count, tweak)

Transform a sequence of values forward.

This function returns an array of values.

Parameters

NameTypeDescription
domainNumberTransformation domain. Valid input values are from 0 to domain-1.
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.
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.