Support

Equilla Formula Language

Array Functions

Equilla is providing a number of functions to help you use arrays in your scripts.

Modifying arrays

AppendArray Apppends an array or a single variable to another array.
Array_Copy Copies some elements from one array to another.
ClearArray Clears an array and resets it to its initial state.
CopyArray Copy all or some elements from one array to another.
FillArray Fills an array with the given values.
InsertAtArray Inserts a value into an array at a given index.
InsertSortedArray Inserts a value into an array keeping it sorted.
RemoveAtArray Removes an element at a given index from the array.
SetArrayLength Shrinks or grows a dynamic array.
SetValRangeArray Sets a range of elements to a given value.

Information

Array_GetType Returns the type of the array elements.
ArrayLength Returns the length (and maximum index) of an array.
CompareArray Compares one array to another.
GetArrayDimensions Returns the number of dimensions of an array.

Finding elements

BinarySearchArray Returns the position of a given value using a binary search.
HighestArray Returns the highest value in the array.
IndexOfHighestArray Returns the index of the highest value in the array.
IndexOfLowestArray Returns the lowest value in the array.
LowestArray Returns the lowest value in the array.
SearchArray Returns the position of a given value.

Sorting

Array_Sort Sorts a range of elements in an array.
CreateSortedIndexArray Creates a sorted index into another array.
CreateSortedIndexArrayLegacy Creates a sorted index into another array, also processes element at index 0.
SortArray Sorts some or all elements of an array.
Sort2DArray Sorts a 2-dimensional array by columns.

Statistics

Array_Sum Returns the sum of all elements or the number of true values in case of booleans.
AverageArray Returns the (mean) average of all or some elements of the array.
AvgDeviationArray Returns the average deviation of all or some elements of the array.
HarmonicMeanArray Returns the harmonic mean of all or some elements of the array.
KurtosisArray Returns the Kurtosis value of all or some elements of the array.
MedianArray Returns the median of all or some elements of the array.
SkewnessArray Returns the skewness of all or some elements of the array.
StdDeviationArray Returns the standard deviation of all or some elements of the array.
StdErrorArray Returns the standard error of all or some elements of the array.
SummationArray Returns the sum of all or some elements of the array.
SummationRecArray Returns the sum of reciprocals of all or some elements of the array.
SummationSqrArray Returns the sum of squares of all or some elements of the array.
VarianceArray Returns the variance of all or some elements of the array.