SortSeries( seriesName, [element count], [offset], [direction] )

seriesName

The series name to be sorted.

[element count]

Optional function value.  When omitted, the default is to sort all the elements in the series unless a specified number of elements is entered into this field.   When a value is entered, that value will specify how many elements to sort.

[offset]

Optional function value.  When omitted, the default is to sort all the elements in the series.

When a value is entered into the optional "element count" field, the value entered in this field will be the starting index from which element count will use to start the optional "element count" number of elements to sort.  This means when the intent is to sort the entire series without any exclusions the value entered into this area should be the same as "element count" value.

[direction]

Optional function value.  The default, or no entry in this field, is to sort the elements in an ascending order.

Note:

A positive value sorts the elements in an ascending order.

A negative value sorts the elements in a descending order.

'  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
'  WtFactors = Manual, or Non Auto-Indexing Series
'  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
'  Adjust Series Element Count
SetSeriesSize( WtFactors, 3)
'  Get Series New Size
PRINT
PRINT "Show Series Size"
PRINT "Series Size = ", GetSeriesSize( WtFactors )
'  Assign Zero to all the Element in the series
SetSeriesValues( WtFactors, 0)
 
'  Assign Weight Factor to Series
WtFactors[1] = 0.30
WtFactors[2] = 0.40
WtFactors[3] = 0.30
 
PRINT
PRINT "Unsorted Series"
For Ndx = 1 TO 3 STEP 1
PRINT "WtFactors[" + AsString(Ndx,0) + "] = ", WtFactors[Ndx]
Next '  Ndx
 
'  Sort Series in Ascending Order
SortSeries( WtFactors)
 
PRINT
PRINT "Series Sorted in Ascending Order"
For Ndx = 1 TO 3 STEP 1
PRINT "WtFactors[" + AsString(Ndx,0) + "] = ", WtFactors[Ndx]
Next '  Ndx
 
'  Sort Series in Descending Order
SortSeries( WtFactors,3,3,-1)
 
PRINT
PRINT "Series Sorted in Descending Order"
For Ndx = 1 TO 3 STEP 1
PRINT "WtFactors[" + AsString(Ndx,0) + "] = ", WtFactors[Ndx]
Next '  Ndx
'  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Return - 1:

Show Series Size

Series Size =  3

Unsorted Series

WtFactors[1]        =  0.300000000

WtFactors[2]        =  0.400000000

WtFactors[3]        =  0.300000000

Series Sorted in Ascending Order

WtFactors[1]        =  0.300000000

WtFactors[2]        =  0.300000000

WtFactors[3]        =  0.400000000

Series Sorted in Descending Order

WtFactors[1]        =  0.400000000

WtFactors[2]        =  0.300000000

WtFactors[3]        =  0.300000000

' Now sort the results series.
SortSeries( results, elementsToSort, elementsToSort, -1 )

SortSeriesDual

See Also:

Series Functions

Edit Time: 9/18/2020 11:37:15 AM

Topic ID#: 571